Excel vba report example일자리
Project Description: We are looking for an Excel expert with experience in Technology Business Management (TBM) to build a financial model that helps distribute IT costs (Cost Pools) and link them to Towers, Sub-Towers, and Solutions. The goal is to ensure transparency, improve efficiency, and support strategic decision-making related to IT cost management. Expected Deliverables: Interactive Financial Model in Excel: A structured Cost Pools table (e.g., Internal Labor, External Labor, Software, Hardware, etc.). Distribution of costs to IT Towers and Sub-Towers. Linking IT Towers to Solutions, such as: Applications. Services. Products. Reports and Visualizations: Charts that show cost distribution by Towers and Solutions. Detailed analysis reflecting percentage allocations ...
We are loo...Indian content creators (e.g., those teaching or consulting in specific niches). The app should provide creators a unique link where fans or followers can: Pay to have direct, time-based interactions (e.g., similar to AstroTalk). Ensure creators maintain privacy by not sharing personal contact details. Understand pricing models, competitor landscape, and user expectations. Deliverables: Detailed Report: Survey methodology Key findings Recommendations Data Submission: Provide raw data from the survey (including telecalling data). Include a detailed questionnaire used for the market survey. Ensure data is well-organized for future reference and analysis. please write JSM as the first word of your proposal, which will ensure that you have read it and didnt submit a generic...
...and Excel Integration in Python or Visual Interface Description: Hi, I am looking for a ChatGPT expert to help me with automation and the integration of Excel data into a system where I can ask natural language questions and get precise answers based on the data. Scope of Work: Task Overview: I have data in an Excel sheet where certain ranges define decision-making authority. Example: Up to Rs. 15,000: X has the power. Rs. 15,001 to Rs. 25,000: Y has the power. When I ask a question like "Who has the power for Rs. 22,000?" the program should correctly respond, "Y has the power." Requirements: Prompt Engineering: Write effective ChatGPT prompts that can accurately interpret my queries. Python Programming: Create a Python program to auto...
I'm looking for...looking for a professional to develop our existing brand book that caters to both internal and external needs. The brand book has some elements already but needs a refresh (colour palette needs to be rediscussed) to be developped to contain clearer, more complete guidelines. We also need the development of the following templates: - Table design - Graph design - Letterhead - PowerPoint layouts - Excel layouts Ideal candidates should have a strong hands-on experience. Experience in creating brand books is desired. Experience creating PowerPoint templates (in PowerPoint) effectively and using is a must. Please provide samples of previous PowerPoint template that demonstrate your ease with the program. Additional Brand book details can be shared with shortli...
...room type and amenities, as well as the price range. Room Types: - The system should be capable of searching for various room types as specified in an accompanying Excel sheet. Ideal Skills: - Proficiency in Power Automate Desktop - Experience with web automation The input is a excel sheet is provided by travel agent. This excel sheet contains first name last name, booking date and check out date and location. Based on these details, we have to go to the website of and fill this details automatically and applying the search filters, we should Add the hotel with highest price, lowest price and average price in the excel sheet and update it. there should be proper error Handlingg like if date is out of range, then what happens and if any input value is miss...
I'm looking for a seasoned digital marketer with a strong focus on social media marketing, specifically on Facebook and Instagram. The primary goal of this campaign is lead generation. Key responsibilities: - Develop and implement a compre...marketing, specifically on Facebook and Instagram. The primary goal of this campaign is lead generation. Key responsibilities: - Develop and implement a comprehensive social media marketing strategy - Create engaging content aimed at generating leads - Monitor and report on the effectiveness of the campaigns Ideal skills: - Proven experience in social media marketing, particularly on Facebook and Instagram - Strong understanding of lead generation techniques - Excellent content creation skills - Ability to analyze and report on ...
I'm looking for someone to assist with typing mixed data (text and numbers) into an Excel file. Key Details: - Content: The data to be typed is a combination of text and numerical values. - Formatting: Standard formatting is sufficient, so there's no need for any specialized layout or design. - Validation: No data validation or error checking is required, so the focus will solely be on accurate and efficient data entry. Ideal Skills: - Proficiency with Microsoft Excel is essential. - Attention to detail to ensure accurate typing of mixed data. - Ability to work efficiently to complete the task in a timely manner.
I'm looking for a professional who can assist in creating an efficient spreadsheet to track trucking expenses and manage payroll for my small trucking company. Key Responsibilities: - Design a user-friendly spreadsheet to track: - Fuel co...Fuel costs - Maintenance costs - Develop a payroll system within the spreadsheet to monitor: - Employee deductions - Earnings based on individual truck performance per pay cycle - Implement a commission-based pay structure: - Calculating employee wages as a percentage (approximately 40%) of what their respective truck makes Ideal Skills and Experience: - Proficiency in Microsoft Excel or Google Sheets - Experience in designing spreadsheets for expense tracking and payroll management - Knowledge of the trucking industry ...
Harnessing the power of efficient data management, we meticulously collect and organize information from diverse sources to create an accurate and comprehensive Excel spreadsheet
...The software should have the following features: - Automated Report Generation: The software should be able to generate reports automatically on a scheduled basis, providing visitor level insights. - Real-Time Alerts: I need the software to send real-time alerts for specific events or thresholds that are met, such as a spike in traffic or visits from specific domains. User Access: The software should support multi-user roles. This means that different users should have different access levels, which can be managed from a single admin account. Ideal Skills and Experience: - Proficiency in web-based software development - Experience with implementing user access controls - Familiarity with developing features for automated report generation and real-time alerts - Knowled...
...to make an informed assumption based on your expertise will be beneficial. Introduction We are seeking a qualified freelancer to conduct a structural stress analysis for a chilled water piping system. The analysis should provide detailed insights into the structural requirements, enabling Hilti to select the appropriate support systems for the pipes. The final deliverable must be a professional report that includes calculations, tables, and graphs to facilitate informed decision-making. Scope of Work The scope of the analysis includes, but is not limited to: Structural Analysis: Assess thermal, weight, pressure, and dynamic stresses on the chilled water piping system. Evaluate load distribution and reactions at support points. Analyze the effects of...
I'm looking for an Android-based mobile application to load jobs in our maintenance logbook and a Windows desktop management to manage our maintenance logbook. The database wil...inputting data such as issue descriptions, locations (from a dropdown list), their names (from a dropdown list), estimated and actual completion dates (using a date picker), maintainer's names (from a dropdown list), and notes (in a text box). - A checkbox for staff confirming job completion. Ideal skills for this project include: - Mobile application development, specifically for Android - excel development in VBA - Experience with creating user-friendly interfaces - Familiarity with integrating applications with OneDrive - Knowledge in using dropdown lists, date pickers and check buttons...
...frontend. Project Requirements 1. Upgrade Laravel Version Upgrade the current project from Laravel 5.6 to Laravel 10.x. Ensure compatibility with PHP 8.x, as the project currently uses PHP 7.1.3. Update the following dependencies or suggest replacements if no longer supported: barryvdh/laravel-dompdf doctrine/dbal intervention/image jrean/laravel-user-verification laravelcollective/html maatwebsite/excel (migrate to v3.x if needed) maddhatter/laravel-fullcalendar (consider alternatives if unsupported) realrashid/sweet-alert spatie/laravel-permission (upgrade to the latest supported version) 2. API Development Build RESTful APIs for existing functionality such as: User management (registration, login, role management) Project creation and management Task creation, assignment, and...
I've been encountering a 'Connection refused' error with in my Ludo game, which is built on PHP CodeIgniter. This issue occurs at the start of the game and seems to have stemmed from recent changes I made on the client-side code. Ideal skills for this project include: - Proficiency in PHP and CodeIgniter (CI). - Extensive experience with socket.io. - St...skills for this project include: - Proficiency in PHP and CodeIgniter (CI). - Extensive experience with socket.io. - Strong problem-solving skills to troubleshoot and fix connection issues. Your task will be to diagnose the connection issue and implement a solution to ensure a smooth start to the game. Please be prepared to communicate clearly about the steps you're taking and to provide a brief report on you...
...app developer to create a vibrant and user-friendly mobile application for both iOS and Android. The app will have a series of unique features aimed at providing support and information to the Jewish community, as well as a tool for reporting anti-Semitic incidents. Key Features: - Anti-Semitism Report Form: This will include fields for the complainant's name, WhatsApp phone number, email, the country where the incident occurred, and a description of the event. A submit button will send the report via email. - Geolocation Service: Real-time tracking of the app user for potential remote intervention in case of danger. - WhatsApp Chat Integration: A chat feature connected to WhatsApp for timely support from an operator. - Jewish Holidays and Shabbat Times: A section li...
I need a web scraping expert who can extract soccer odds statistics from various websites for my personal analysis. Key Requirements: - Scraping specific soccer odds and stats from the web - Implementing 'auto scraping' on specific buttons and menus for data comparison - Saving all scraped data in an Excel spreadsheet Ideal Skills: - Proficiency in web scraping tools and techniques - Experience with Excel and data analysis - Knowledge of soccer odds and statistics is a plus
I'm looking for a data entry expert to help with Excel data entry and formatting customer information. Key Responsibilities: - Entering customer information into Excel - Formatting data for consistency Ideal Skills: - Proficiency in Excel - Experience in data entry and formatting - Attention to detail and ability to meet deadlines Please reach out if you're interested.
I'm seeking a proficient researcher, The task entails examining a specific e-commerce website and a 5-minute explainer video. Key Requirements: - Comprehensive assessment of the provided e-commerce website and the explainer video - Analysis should focus on the g...researcher, The task entails examining a specific e-commerce website and a 5-minute explainer video. Key Requirements: - Comprehensive assessment of the provided e-commerce website and the explainer video - Analysis should focus on the guidance provided in examples. - Delivery of a 3500-word academic-style report, formatted correctly I will supply example files in PDF format. The report is urgently needed within 36 hours. Ideal candidates should have prior experience in website analysis and repor...
"Enhance an Existing Excel Workbook with Creative Design & Marketing Skills Looking for a professional to refine an Excel workbook with existing formulas, functions, and macros. The task involves improving its visual appeal and overall presentation (logo included) without disrupting the calculations. Estimated time: 2-2.5 hours. Task Instructions for Excel Workbook Enhancement Aesthetic Improvement: Enhance the visual appeal of the workbook, making it more professional and polished. Remove unnecessary areas that do not add value for marketing purposes. Workbook Flow: Organize the pages to ensure logical progression and easy navigation. Improve readability and ensure a cohesive structure. Content Review: The workbook contains real data, such as companies, ...
I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.
...Ability to work with tools like Photoshop, Lightroom, or equivalent photo editing software. Keen eye for detail and aesthetics to ensure all images are visually appealing and consistent. Excellent communication skills and ability to follow detailed instructions. Deliverables: 20 edited images per product, in PNG format with a transparent or white background, sized in a 16:9 aspect ratio. A brief report citing sources of all original images and confirming that all images are edited as per project requirements. To Apply: Please submit a portfolio of your previous work, especially projects involving product photography or image extraction and editing. Include a brief outline of your approach to this project and an estimated timeline for delivery. Don't ask me about BUDGET Yo...
I'm seeking a skilled software developer to create a certified payroll reporting software. This software's primary function will be report generation, focused on compliance with federal regulations, state regulations, and industry standards. The software should be capable of generating specific types of reports, including: - Wage and hour reports - Employee benefits reports Ideal candidates will have extensive experience in software development with a focus on payroll systems, and a strong understanding of regulatory compliance. Knowledge of report generation is crucial for this project, API integrations with payroll providers ( Quickbooks, ADP and many others) Please provide examples of similar projects you've worked on in your proposal.
Hey Guys, We are looking for someone to research keywords on different niches. You will be provided with - - Niche of the site - A brief description of the niche - 6 Main...presentable with data from various sources (sources clearly mentioned) that can be cross-verified. We have a project for upto 300 websites - so the winner here will be provided with the said project as well. We'll require you to provide us with research on ONE niche as a sample (Paid of course) In your bid - - Please describe our requirements in your own words - Please share a sample keyword report that you've done previously. You may redact necessary information. - Tell me what all tools you will be using - What will be the number of keywords provided per niche? - What is the cost for research ...
I'm seeking a talented social media marketer to help promote my Kids Bollywood Contemporary classes. The primary goal is to increase class enrollment through strategic social media campaigns. Key Responsibilities: - Create engaging content targeted towards parents and children. - Develop and implement a comprehensive social media marketing strategy. - Monitor, analyze and report on performance metrics to optimize campaigns. Ideal Skills: - Proven experience in social media marketing, specifically targeting the children and parenting sector. - Strong understanding of various social media platforms and their demographics. - Excellent content creation and copywriting skills. Previous experience in promoting dance classes or similar activities will be an added advantage. Please...
...including property development businesses, while leading a remote bookkeeping team and driving the use of technology to streamline financial management and reporting. You must be engaged, confident and passionate about delivering great work. Key Responsibilities: - Lead and manage bookkeeping tasks by outsourcing to a remote team, ensuring accurate and efficient financial operations. - Prepare and report on business budgets, forecasts, and actuals, with a focus on operational and property development finances. - Confidently manage payruns for both business operations and property development projects. - Collaborate closely with Development Managers and the Accounts team at Homecorp, ensuring financial alignment and reporting consistency. - Guide the team on accounting best...
Create a tool that scrapes online business profile reviews for any business I input. Key Requirements: - The tool should allow me to input the name of a business with online reviews - It should capture ALL the reviews in a single excel document like the attached Timeline is 2 to 3 days
I need assistance with an Excel project where I am trying to find unique permutations of mixed data (text and numbers). Key Requirements: - Expertise in Excel, particularly in handling permutation matching. - Ability to work with mixed data sets (text and numbers). - Experience in displaying results in separate columns. I would like the results to be displayed in separate columns. If you have the necessary skills and experience to assist me with this project, please reach out.
...ensure approval. Key Responsibilities: Review and analyze my website against Mediavine’s standards. Confirm traffic metrics through Google Analytics. Provide a detailed report on improvements needed (if any). Offer support through the Mediavine application process. Preferred Qualifications: Experience with Mediavine approvals or similar ad networks. Strong knowledge of website optimization and analytics. Proven track record of assisting websites in achieving ad network approval. Deliverables: A fully optimized website ready for Mediavine application. Successful Mediavine approval or a comprehensive report on next step...
I'm in need of a formal editing expert with the ability to undertake major and minor differential revisions on a business document. This document is an internal report that requires substantial editing and rephrasing to enhance its overall quality and clarity. Key Tasks: - Modify the document to a formal tone suitable for a business setting - Change major and minor differential topics to ensure a wholesome paraphrase - Implement different aspects of editing to improve the document Focus Areas: - Grammar and punctuation - Clarity and conciseness - Formatting and structure Ideal Skills and Experience: - Proven experience in editing business documents - Excellent command of English grammar and punctuation - Ability to enhance the clarity and conciseness of the text - Proficienc...
...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skil...
I'm seeking an adept professional with strong Excel and MySQL skills for a project centered around the creation and management of a database. Key Responsibilities: - Creating and managing a new database in MySQL - Entering and updating a mix of numerical and textual data in Excel Ideal Candidate: - Proficient in Excel with experience in data entry and updates - Skilled in MySQL, with a solid understanding of database creation and management - Capable of handling and effectively managing mixed data sets (text and numbers)
Job Description: We are looking for a detail-oriented and resourceful professional to collect and analyze information on leading asset management systems such as Yardi and TRIRIGA. The objective is to identify their key fea...Proven experience in research, business analysis, or technical writing (experience with asset management systems is a plus). - Strong understanding of business and system requirements documentation. - Ability to analyze and synthesize complex information. - Excellent writing and communication skills. - Familiarity with tools and methodologies used for creating BRDs. Deliverables: 1. Comprehensive report detailing the features and components of leading asset management systems. 2. Well-structured Business Requirements Document (BRD) suited for guiding a develop...
I'm looking for an expert in web scraping who can extract product data from two specific e-commerce sites. I need the data to be organized in a well-structured Excel file, categorizing the products into 'product family', 'sub family', and 'product'. Key Requirements: - Extracting the 'Product name' and 'Price' for each product. - Excluding product images; scraping should only focus on product name and price. - Delivering the data in a clear, organized manner in an Excel file. Ideal Skills and Experience: - Proven experience in web scraping, particularly with Shopify and WordPress. - Proficiency in Excel and data organization. - Attention to detail to ensure data is accurately captured and well-structured.
...with our team to ensure successful project execution after client acquisition. Outreach Specialist: -Conduct outreach campaigns via email, LinkedIn, and cold calling to generate leads. -Research and identify key decision-makers within solar companies. -Create and manage outreach sequences to engage prospects. -Schedule meetings and book calls with qualified leads for follow-up by the sales team. -Report on the effectiveness of outreach strategies and suggest improvements. Requirements: Skills and Experience: -Proven experience in sales and/or outreach, especially in the solar industry or B2B marketing (preferred but not required). -Excellent communication and negotiation skills. -Strong understanding of lead generation strategies, including cold calling and email marketing. -A...
I'm seeking an experienced professional to assist with the design of a rural...work for both the drainage and irrigation systems. This will entail calculating design parameters, net irrigation requirements, and selecting appropriate equipment. - Analyzing leaching requirements during irrigation to prevent salinization. I also need a comprehensive analysis of calculation results under various rainfall conditions using SOBEK software. The final deliverable should be a clear report detailing the design steps and results, alongside a proposed management and maintenance plan for the study polder. I value efficiency above all in this project, so a strong background in maximizing system efficiency is a plus. Experience with SOBEK software and understanding of rural drainage system...
Request for Proposal Evaluation and Website Development Audit for Holiday Rental Web...(e.g., HTML, CSS, WordPress). Familiarity with security measures and GDPR compliance standards. Extensive knowledge of SEO best practices and experience conducting thorough SEO audits. Ability to produce detailed, actionable reports with feedback and recommendations. Timelines and Deliverables: Proposal evaluation report within 7 days of project start. Website audit report within 5 days after website completion. Final comprehensive report including conclusions and actionable recommendations. We look forward to receiving your applications, along with examples of prior audits, relevant projects, or evaluations. Please ensure your expertise aligns with the pro...
Since I am abroad, I need someone to visit my house in Bremen, Germany, to ascertain how many people curren...in Bremen, Germany, to ascertain how many people currently reside there. This task is crucial due to legal and compliance reasons. Key Responsibilities: - A site visit to my Bremen property. - Note and info about the number and names of occupants. - Note the duration of their stay (since when to when, how found the room). - Document your findings with photographic evidence. - Compose a written report detailing your observations. Ideal Candidate: - Must be located in or have access to Bremen, Germany. - Must keep project details confidential to tenants and guests. Pay is $ 30,- and 50,- if all needed informations eg photo for evidence are fully documented. Speak to you ...
I have a legacy Excel workbook developed over the last decade that I want to transform into a web-based platform. This will involve using the Excel workbook as an 'engine' in the background. The final product should include: - A web-based interface with user logins - Payment processing capabilities for licensing - An Admin dashboard - User analytics features - Integration of some AI elements, specifically natural language processing The platform should also have a user database where project details can be stored, allowing users to handle multiple projects and modify existing ones. Ideal skills for this project include: - Proficiency in web development - Experience with legacy system integration - Knowledge of AI, particularly natural language processing - Famil...
I'm in need of highly skilled cold callers who can help me gather market feedback and set appointments for my offerings. The target market is national, and the main objectives of the calls are to assess product fit and gauge market demand. This role is commission based with very lucrative commission structure and growth ...growth opportunity to work with a variety of offerings. Key responsibilities: - Conduct cold calls to potential clients - Gather feedback on product fit (problem qualifying and solution interest) - Assess overall market demand - Set appointments for further discussions Ideal candidates should: - Have proven experience in cold calling - Possess excellent communication skills - Be able to gather and report feedback effectively - Have a knack for sales and cli...
I'm seeking an Excel expert to create a comprehensive sales commission report. I receive monthly reports from my company, but they don't balance the commission sold versus the commission final at job completion. Key Requirements: - Creation of a report that can be used ongoing, allowing future data input - Each job has three commission payments based on billed/paid - The report should provide as much data as possible Data to be Included: - Sales amounts - Commission percentages - Job completion status - Cost - Price - Margin - Profit - Commission Rate - Commission amount sold - Commission amount executed - Commission due Ideal Skills: - Proficient in Excel - Experience with sales and commission reporting - Ability to create reports for CSV d...
I'm looking for a freelancer who can create two report templates in Zoho Writer connected with our Zoho CRM data. The templates should be modeled after an Excel report design and tailored for client presentations, hence they need to be professional and easy to follow. The first report is 3 pages long, and the second one is 8 pages long. The templates should include: Essential Elements: - Data feed from Zoho CRM - Conditional formatting for certain text field The ideal candidate will have experience with Zoho Writer and Zoho CRM, as well as a clear understanding of creating business report templates. I've specific branding guidelines that need to be applied to the report templates, so the freelancer should be able to adhere to these c...
I'm a startup cosmetics brand looking for an experienced Meta Ads specialist from Pakistan. I need someone who can run effective ads on both Facebook and Instagram, with a primary goal of generating sales. Key Responsibilities: - Create and manage video-based ad campaigns on Facebook and Instagram - Monitor ad performance and adjust strategies as needed - Report on sales generated from the ad campaigns Ideal Skills: - Proven experience in running Meta Ads - Strong understanding of the cosmetics market in Pakistan - Ability to create engaging video ad content Compensation: This is a commission-based role, with payment tied to the sales generated from the ad campaigns.
I'm facing problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation error. In addition to this, I also need assistance with importing an Excel file into my database. Ideal Skills and Experience: - Proficient in Laravel - Database management and Excel import experience - Strong debugging skills to identify and resolve issues - Familiarity with Admin panel functionalities in web applications.
...data on the platform. Process Automation: Link existing categories with dynamic data from the APIs. Set up workflows to ensure automated updates and data processing. Email Automation: Implement an automated email management system. Enable AI-powered responses to incoming inquiries based on customer inputs. Artificial Intelligence (AI): Integrate an AI solution for data analysis and automated report or response generation. Connect the AI with the platform’s categories and data. Social Media Integration: Automate the publishing of platform content to social networks (e.g., LinkedIn, Twitter, Facebook). Set up templates for social media posts based on platform content. Our Preparation: WordPress is already installed and set up. All categories, text, images, and design elem...
I am seeking an experienced environmental researcher to prepare a comprehensive yet accessible research report on climate change. The aim of this project is to provide a detailed understanding of climate change and its implications to the general public. Key Requirements: - In-depth understanding of climate change - Excellent research skills - Ability to translate complex concepts into simple, clear language - Experience in writing research reports Please include samples of similar work you've done in your application.
I'm looking for a professional to create a PowerPoint presentation from my Excel data. The presentation will primarily focus on sales statistics, specifically sales by region. The visual representation of the data will be in pie chart format. Ideal skills for this project include: - Proficiency in Excel for data extraction - Expertise in PowerPoint for presentation creation - Ability to create clear and engaging pie charts - Experience in sales report preparation The final output should be a well-structured and visually appealing PowerPoint presentation that effectively communicates the sales data.
...Identify and engage potential clients through social media platforms (e.g., Instagram, LinkedIn). Run targeted campaigns to attract aspiring aviation professionals. Use tools like Google Ads, Facebook Ads, or organic strategies to generate leads. Customer Conversion: Follow up with leads to explain the benefits of our classes. Guide clients through the enrollment process. Reporting: Track and report lead conversion metrics weekly. Suggest strategies to improve client acquisition. Proven experience in lead generation or digital marketing. Knowledge of payment platforms (e.g., Razorpay, Instamojo, PayPal). Strong communication skills and ability to engage clients online. Familiarity with aviation or career coaching industries is a plus. What We Offer: Flexible working hours. O...