Create employee time clock excel spreadsheetmunkák

...need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing all the subtasks. Speed and proficiency in E...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Ski...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Ski...

I need to scrape base salary information from Glassdoor for about 2000 companies. Key project requirements: - Scraping Glassdoor for base salary and range info only for every job function/title. - Compiling this data into an Excel spreadsheet Ideal skills include: - Proficient in web scraping techniques - Experience with data analysis Website: (it is free but need to register and complete the profile to see the information)

As an entrepreneur, I'm swamped with a ton of ta...but also skilled in email management, appointment scheduling, light accounting, and spreadsheet tasks. Here's what the job entails: - Managing my emails and scheduling appointments - Helping with light accounting and maintaining spreadsheets - Entrusted with some data entry duties The ideal candidate would have: - Proven experience in similar roles - Exceptional command over English - Strong skills in using spreadsheet and email tools You should expect to work around 10-20 hours a week. This job requires professional-level English fluency given the nature of the tasks at hand. Excellent organizational skills and an eye for detail would be a big plus for this role. If this sounds like a role you can excel...

I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in design...

i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.

Add macros in existing Excel file

I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you'd be interested in.

I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to ensure the information is accurately documented. - Proficient in ...

I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friendly applications - Understanding of...

I need to have a python script prepare for Zerodha's Kite API platform to broadcast same orders from one account to mutiple accounts. The final work would looks like this See the video and let me know if you can create this ? I have python codes for login, Orders and etc. Products Requirement. – Copy Trade (decoded) Overview : Copy trades from one account to another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL –

I have a photo that contains a mix of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurately represent this ...

I'm looking for a skilled developer who can create a real-time GPS tracking app for both iOS and Android platforms. Here's what I need: - Compatibility: The app should be functioning flawlessly on both iOS and Android devices. - Real-time GPS tracking: One of the core features of this app is to provide real-time GPS tracking. This means the user should be able to see their own location and the location of others in real-time. - Interface: The intended way for users to interact with the app is through a map interface. This design choice is aimed to make the user experience as seamless and intuitive as possible. Ideal candidates for this project should have experience in: - Developing for iOS and Android platforms - Implementing real-time...

Send me samples of your best Interactive Customizable VR Backgrounds work. I'm seeking an experienced Unreal Engine developer to create custom virtual reality backgrounds for interactive installations. Key Requirements: - Customizable VR Backgrounds: The backgrounds must be fully customizable to fit various interactive scenarios. The ability to tweak elements like colors, textures, lighting, and spatial layout is critical to achieving the desired immersive effect. Ideal Candidate: - Proficiency in Unreal Engine: A solid grasp of Unreal Engine is non-negotiable for this project. You should be able to design and implement complex, interactive VR environments within this software. - UI/UX Skills: While not mandatory, additional skills in user interface and experience design ...

I'm in need of an experienced full-stack developer proficient in both Python and Java. As a dedicated developer on this project, you would: - Develop the frontend using Python - Design and build back-end services with Java Skills & Experience Needed: - Proven experience as a full-stack developer - Proficiency in Python for frontend development - Proficiency in Java for backend development This job requires the ability to quickly learn and adapt in a fast-paced development environment. If you have the skills and experience detailed above and are excited about joining the team, I encourage you to bid on this project.

I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional formatting in the spreads...

I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-...designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating str...

Se trata de generar informes de ventas en Excel desde un archivo madre, también en Excel

I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel-Word integrations. Please...

I would like to hire a professional to extract and organize Amazon Seller details using web scraping techniques. After you find the company name on Amazon, i need you to s...need you to scrape the web for their contact information since Amazon wont disclose it on Specifically, this project involves: - Extracting Amazon seller information from the website -Use that Amazon seller information to scrape the web for email and contact details - Organizing the data in an Excel spreadsheet The main goal of this exercise is to generate leads from this data. Ideal Skills: - Proficient in web scraping techniques - Ability to handle and manipulate data in Excel - Experience in lead generation would be a plus as it will help in creating a strategic approach in leveraging the c...

For the new version of an existing application, we have 4 XD projects with different scenarios with desktop and mobile version that need to be transformed into XHTML. Here are some details: - we want responsive pages - no javascript except if it comes from bootstrap - please note that the top bar is almost always the same, it must be the same XHTML code - there is a breadcrumb trail that changes color as you progress Desktop version : The 1st project () and 2nd project () are almost the same except for the beginning. The 1st is an account creation. The 2nd is when the user already has an account. for the 1st XD project : - page 1 ignore this - page 2 account creation for the 2nd XD project : - page 1 ignore this 1st project and 2nd project : - (1st project after account creation) page ...

Hello, The following checkout page has been created by another dev using a woocommerce plugin The current plugin uses Attributes and Variations to identify the right product, but I need to have multiple individual products on woocommerce. I want to modify the existing plugin or create a new one in such a way that when a product is chosen on the front end, the relevant product is sold on the backend woocommerce products. The design has to be modified a bit too in order to match the homepage. Also, required is the Payment integration. My max budget for this gig is $50, any quote above that will be completely ignored. Thanks.

More details: Is this project for business or personal use? This question was skipped by the user What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

I need a skilled freelancer to design a PowerPoint presentation, to be used as a sales pitch for a new chapter. ...skilled freelancer to design a PowerPoint presentation, to be used as a sales pitch for a new chapter. The main focus of the content will be on chapter creation, purpose, strategy, and timeline Key Requirements: - Prior experience in designing presentations - Strong understanding of how to visualize and present data - Ability to influence potential buyers through compelling visuals - No need to create an additional chapter Your strength in translating business data into compelling visuals will notably increase your chances of securing this project. Creativity, attention to detail, and understanding of the sales process are equally important. Let's help lure thos...

Description de l'offre : Nous sommes à la recherche d'un spécialiste passionné et expérimenté du web et du marketing digital pour rejoindre notre équipe à temps plein. Le candidat idéal doit être un expert des technologies web, y compris la gestion de sites WordPress, et posséder une solide expérience en marketing digital, notamment sur les plateformes sociales comme Instagram et Pinterest. Responsabilités : Développement et gestion de sites sous WordPress, incluant la maintenance et l'optimisation pour le SEO. Création et gestion de campagnes publicitaires sur les réseaux sociaux. Analyse des performances des sites et des campagnes marketing pour recommander des am&eac...

Urgent! We need a skilled Figma designer to create a user-friendly betting app interface similar to Action Network. Experience with mobile app UI/UX design is crucial, and knowledge of betting app trends is a plus. Submit your portfolio and hourly rate for immediate consideration!

I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The...

We are seeking a dedicated part-time employee who is familiar with the Run Diffusion / Stable Diffusion program or is willing to familiarize themselves with it. Experience is advantageous but not mandatory. Responsibilities: - Application and optimization of the Run Diffusion / Stable Diffusion program, primarily utilizing the programs ComfyUI, AutoForge1111, and FaceSwap for image editing tasks - Collaborating with the team to develop solutions and solve problems - Documenting work processes and results Requirements: - MacBook with M1 Chip or higher - Basic knowledge or experience with the Run Diffusion / Stable Diffusion program (experience is advantageous but not mandatory) - Proficiency in utilizing ComfyUI, AutoForge1111, and FaceSwap for image editing tasks - Good p...

Job Title: Experienced YouTube Ads Media Buyer for Travel Industry Compensation: $600 per client Location: Remote/Anywhere About the Job: Join our team as a YouTube Ads Manager and be part of something special. As our YouTube ads manager, you will work with us on per client basis and be responsible for the following tasks: *Setting up and launching YouTube campaigns *Setti...campaigns once they go live *Build & A/B test high-converting landing pages. * etc, etc Requirements: *Good English with clear communication. *Experience setting up, launching and managing effective YouTube campaigns *Proven track record that you’re able to prove *Knowledge of landing pages, funnels, conversions, testing etc. *Ability to check on client campaigns and report results into a Google Spre...

EXCEL. Preferencia: Google Sheets. Tengo una sola hoja con varias columnas: Conjunto 1: columna 1 "Activo" tienen nombres que pueden repetirse. columna 2 "Categoria". tienen clasificaciones. Conjunto 2: columna 3 "Titulo" tiene nombres de Clasificaciones. columna 4 "Categoria de Activo 1" a columna 11 "Categoria de Activo 8". columna 12 a 31 "" y "" con pasos de suma 1 en 1, portan valores numericos del 0 a 5. columna 32 a 41 "D1" con paso de suma 1 en 1. Relaciones: + columna 1, 2 y 32 a 41 estan relacionadas. + columna 3, 4 a 11, 12 a 31 estan relacionadas. Se necesita crear una tabla dinamica donde aparesca cada dato de "Activo" donde se halla una coincidencia "Categoria" con...

Good day, We please need a Freelancer to create a WebM video from an existing and purchased Premiere Pro template. This is the template: The requirements to the output video are: - Put below mentioned sequences 01-03 into a row - Video will be displayed in this frame (check ) - Video must be in WebM format - Video background must be transparent (!!) - Video must be web-optimized - Video must run in a loop - Video must contain transparent gradient on left/right side - Video sequence 03 must contain transition animation Please check the individual sequences for more details: Sequence 01 - Smartphone - Take animation from 00:09 - 00:15 - Take screenshot

We're having a company 'fun afternoon' with catering and a few fun things for our employees. I'm looking for someone to come and draw some cartoon/caricatures for a bit of fun!

I'm looking for an expert in Odoo who can provide staff training and consultation on HR management, Payroll management, and Inventory management. The ideal candidate will have proven experience in: - HR Tasks: Specifically, training will be required on managing employee databases, attendance, and leave management. - Payroll Responsibilities: This includes understanding payroll metrics for our team of less than 50 employees. - Inventory Management: How to manage stock effectively within the overall business operations. This Odoo consultation is key to streamlining our business processes and improving our overall operational workflow. Proficiency in Odoo is a must, excellent communication skills and teaching or training experience will be a plus.

Confirmis ( ) is a Singapore-based business information provider speciali...site visit to the candidate’s former employer • Conduct the basic verification about the candidate in the candidate's former employer; to verify whether the candidate was indeed an employee at the specified company. • Take pictures of the candidate’s former employer as per Confirmis’ standard operating guidelines • Job will only take less than one hour to accomplish (excluding travel time) REQUIREMENTS: • Must be living in (or nearby) Cimahi, Indonesia • Has a camera or phone/tablet of quality with a camera, internet access Note: Payment will be released the following week after the site visit to give us time to organize the report and contact y...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Ski...

Good day, We please need a Freelancer to create a WebM video from an existing and purchased Premiere Pro template. This is the template: The requirements to the output video are: - Put below mentioned sequences 01-03 into a row - Video will be displayed in this frame (check ) - Video must be in WebM format - Video background must be transparent (!!) - Video must be web-optimized - Video must run in a loop - Video must contain transparent gradient on left/right side - Video sequence 03 must contain transition animation Please check the individual sequences for more details: Sequence 01 - Smartphone - Take animation from 00:09 - 00:15 - Take screenshot

I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in ha...individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel...

I'm developing an open source WBO whiteboard: In order to optimize better pen writing I want to implement a smooth SVG freehand drawn path in real time. The following code snippet makes the curve smoother by calculating the average of the last mouse positions. The level of smoothing depends on the size of the buffer in which these values ​​are kept. Please look at the example I have attached. Here is the link to the code snippet Please bid only experts. My requests is: Adapt this code to WBO so that the writing quality is as in this code snippet.

As a business in need of a real-time barcode-based inventory control system, I am looking for a skilled freelancer to design and implement a system that will help me effectively manage my inventory. The system will need to be developed from scratch as it does not need to integrate with any existing software or systems. Key Features: - Real-time Inventory Tracking: The system should allow me to track inventory levels in real-time to prevent stockouts and overstocking. - Reporting and Analytics: An essential feature of the system should be the ability to generate detailed reports and analytics. This will help me make data-driven decisions to optimize my inventory management processes. Ideal Skills: - Extensive experience in designing and developing inventory control sy...

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm seeking a skilled Java developer to create a (Web Scraper and Analyzer) for my project. 1- i need it to work on eclipse 2- i need the program written in a (GENERIC code) 3- you must use data structure 4- i need you to simplify the code for me as you can 5- i need to ask you simple Questions like what data structure did you use, why this data structure not other, and lastly i need the Pros and Cons for the selected data structure.

I'm seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation processes, and the ability to logically interpret and visualize data.

Saya membetuhkan orang yang bisa mengedit. Channel saya tentang komentari AI voice yang memakai subtitle text yang bagus dengan background tersedia. Apa yang diperlakukan jika anda mau melamar: 1. Mempunyai laptop yang kuat untuk edit memakai editing aplikasi dari saya (bisa capcut atau premiere pro) 2. Mempunyai wifi internet atau hotspot yang sedikit kuat 3. mempunyai experience minimal 6 bulan di capcut atau premiere pro 4. Disiplin dan tidak delay perkerjaan 5. Bisa kerja minimal 15 jam per minggu 6. Aktif dengan perkerjaan saya 7. Membalas WA saya dengan waktu cepat Apa yang saya inginkan dengan anda yang paling penting? - Disiplin

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project sch...

As a business in Hamburg, Germany, we require a detail-oriented freelancer to conduct extensive pre-employment screenings. The main purpose is to examine potential gaps in employment, authenticate employee references, and confirm past employments. Key Areas: - Verification of Start and End Dates - Detailed check on Job Title and Responsibilities - Investigation into reasons for Leaving Ideal candidates should have experience in human resources, specifically employment verification. They should have meticulous attention to detail and understand German employment laws. Knowledge of local language and business practices in Hamburg is advantageous. Please include in your application any relevant work experience you may have in this field along with a detailed project proposal outli...

...scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API design principles. 5. Have experience with database management systems like PostgreSQL or MySQL. 6. Be comfortable...

I need a professional to create an interactive API news site that comes with a variety of specific features. These features are critical to the uniqueness and usability of the site: - Real-time news updates: The system should be able to update news posts every hour. This will ensure up-to-the-minute news accessibility for users. - Customizable news categories: I aim to offer categories that users can tailor to their liking. Ideal customization should accommodate a broad range of categories, allowing users to set up their favorite news areas. - Social media sharing functionality: In this age of social network reliance, I wish for users to share news posts across various platforms efficiently. This increases engagement and enhances user interactivity. - Dynamic news and events...