Excel automatic data entry formula jobs
...flight data from Excel tables. The chart will be used to track both flight schedules and aircraft positions, so it's imperative that it accurately depicts arrival and departure flights, along with their corresponding aircraft registration. Key requirements: - The horizontal axis should represent dates and times, with a red vertical line indicating the current time. - The vertical axis will show the aircraft stands. - Flights need to be depicted as horizontal bars, with the size of the bars determined by the arrival time of each flight. - Bars need to be split in case of aircraft repositioning. All of this data will be sourced from provided Excel tables which consist of flight number, time, aircraft registration, and aircraft stand. The Gantt chart must...
I'm seeking an Excel expert who can add a pop-up calendar to specific cells in my spreadsheet. - Purpose: The calendar is needed for date entry for scheduling purposes. - Format: Dates will need to be entered in the DD/MM/YYYY format. Ideal candidates for this project should have a strong background in Excel, with particular experience in implementing interactive features. Please ensure you can deliver a user-friendly solution that will streamline the scheduling process.
Extract Ealing Landlords data from website and organize into Excel
...information - Please note, listings will require approval before appearing on the site. In the backend platform: - A need for listings to be approved before they go live - Our company can custom listing durations (1 month, 2 months etc.) but the users(e.g. agents, owners and customers) cannot. -Our company can limit on photos/videos for each listing - Our company can control of payment timings - Automatic email verification for all users For customers, - Premium special listing where customers pay to see special properties on the homepage The ideal freelancer for this project should have: - Extensive experience in web development, particularly with real estate platforms. - Knowledge of how to implement complex membership systems. - Ability to create custom web functions tailore...
I'm in need of a diligent freelancer to assist with the manual entry of maintenance expenses for my real estate accounting. Key responsibilities: - Accurately entering maintenance expense transactions. - Categorizing these expenses accordingly. The ideal candidate should have: - Prior experience in data entry,. - Strong attention to detail. - Ability to categorize expenses logically.
I'm looking for an Excel specialist who can assist me in creating dashboards and performing statistical analysis. Key Requirements: - Expertise in Excel with a focus on complex functions like VLOOKUP - Proven experience in creating interactive and insightful dashboards in Excel - Strong statistical analysis skills Please note that the key metrics for the dashboard have not been determined yet, so flexibility and creativity in presenting relevant data will be appreciated.
...for releasing features quickly? To consider you as one of the short-listed candidates, you should COMPLETE the above requirements For interested bidders: Please send us your CV/Resume and portfolio or attach the link of the required documents to your bid. Please be mindful of your bid as we consider your bid as an actual FINAL bid. Any change of bid during an interview process WILL lead to automatic termination of the interview....
I'm seeking a seasoned data analyst with substantial experience working with various programs, especially SBSS IBM, to help design surveys for data collection and analyze data collected . Key Aspects: - The primary focus will be on design surveys , analyzing overall data, with a specific emphasis on measuring performance and needs assessment . - The expert will need to generate comprehensive data analysis and reports in Excel. Ideal Skills: - experience in surveys design tools like KOBO ,,,etc -Proficiency in SPSS IBM and other data analysis programs. - Strong performance measurement capabilities. - Excellent Excel skills for report generation.
...up clients on the company business • Represent the company when needed in communication verbal and non-verbal as assigned by the direct manager. • Manage business/office logistics and maintain an organized workspace. • Coordinate and schedule meetings, appointments, and events. • Oversee office supplies inventory and place orders as needed. • Support administrative tasks including filing, data entry, and correspondence. • Serve as the point of contact for office-related inquiries and issues. • Assist with onboarding new consultants, volunteers, employees, or experts and maintaining personnel records. • Ensure compliance with company policies and procedures, Code of Conduct. • Other duties related to company projects as assig...
...top-tier Excel Programmer and Microsoft SharePoint expert. The Scope: - I will provide all necessary Excel tables. - We will store these files in a Microsoft SharePoint folder. - You'll create an IFRAME EMBED code to include in an HTML file. - This HTML file will be hosted on our Website server. - The setup should allow display on a computer or TV browser with real-time updates. - We will input data daily into the Excel file. Key Responsibilities: - Initiate and develop the project on your own SharePoint folder. - Create the EMBED code and HTML file. - Upload the HTML file to your own Hosting server. - After ensuring everything is functioning correctly, replicate the setup on my SharePoint folder. Dashboard Requirements: - Interactive charts - Real-t...
I'm looking for a proficient web scraper to extract product details from an industry directory. The required information includes product names and descriptions. Ideal Skills: - Proficiency in web scraping tools and software - Experience in data extraction from industry directories - Familiarity with Excel for data organization Please ensure the final output is well-organized in an Excel spreadsheet for easy understanding and analysis.
...of all Bank accounts 8. Calculation at year end of provisioning of Gratuity and Leave Salary for the staff 9. Periodical closure of books for preparation of Trial Balance, Balance Sheet and Profit/Loss account 10. Submission of Monthly and Yearly Accounting Reports 11. These monthly MIS Profit Reports would provide business in-sight, analytical report and recommendations - in easy-to-understand excel/pdf format, which can be customized as per requirements 12. After submission of the accounting records, on a monthly basis at mutually agreed time and date, these reports can be discussed in online or in physical meeting 13. Complementary Tax advisory meeting. At any point of time, for our of business, any UAE related Accounting and Tax laws (VAT or Corporate Tax) can be discussed fo...
I'm looking for a Qlik Sense expert who can create three comprehen...university's higher management. These dashboards will present key information including our admission rates, total number of students per year and semester, financial income, and graduation rates. Key Requirements: - Data Source: The dashboards need to pull data from CSV/Excel files. - User Access Control: The dashboards need to have different levels of access for different users. - Admission Rate Metrics: The dashboards should display the overall admission rate and the admission rate by department. Ideal Skills: - Extensive experience with Qlik Sense. - Proficiency in data handling and visualization. - Knowledge of designing user access controlled dashboards. - Ability to create de...
I need a two-page document providing a comprehensive overview of the global airlines market, including its size and key players. I also require research on five airl...providing a comprehensive overview of the global airlines market, including its size and key players. I also require research on five airline food and beverage catering providers. Ideal freelancers for this project should have: - Experience in market research, preferably within the aviation industry - Proficiency in data analysis - Ability to create visually appealing and easy-to-understand graphs and charts The document should be: - Text supported by graphs and an accompanying Excel spreadsheet - Focused solely on passenger airlines - Detailed and insightful enough for a non-expert to understand the dynami...
I'm seeking a Power Automate expert to streamline my shipment notifications. I have an Excel sheet on SharePoint containing "part number" and "shipment date". Key Requirements: - Configure Power Automate to check the shipment date and send email reminders at three intervals: 14 days, 7 days, and 1 day before shipment. - The email reminders should include: Part number, description, quantity, and shipment date. - The custom message in the email reminders should be personalized. Ideal Skills: - Proficiency in Power Automate and SharePoint. - Experience with configuring automated email reminders. - Strong attention to detail to ensure all aspects of the shipment notifications are covered.
I urgently require a professional with expertise in data entry on WordPress. Please note that specific details about the type of data, its source, and categorization have not been defined yet. However, I am open to discussing these aspects with potential candidates. Ideal skills include: - Proficiency in WordPress - Excellent attention to detail - Ability to work under tight deadlines Please be aware that this project requires immediate attention.
I'm seeking an experienced data analyst who specializes in descriptive analysis. The objective of this project is to analyze my sales data and provide insightful conclusions that can help inform business strategy. Ideal Skills: - Proficient in data analysis tools (e.g. Excel, SQL, Python, R) - Strong understanding of sales metrics - Excellent interpretative and communicative skills - Experience with data visualization tools (e.g. Tableau, Power BI)
...requirements. System Requirements: User Roles: Students Log clinical training sessions. View their own session logs and total training hours. Maintain data confidentiality (cannot view other students' data). Lecturers View aggregated data for all students in a class. Access detailed session data (dates, times, durations). Calculate total academic hours for each student. Key Features: Input Form for Students Fields: Date and Time: Date picker and time input. Patient Name: Free-text field. Duration: Dropdown with options: 45 minutes, 90 minutes, 135 minutes. Student Name: Dropdown pre-populated with the logged-in student’s name. Automatic calculation of academic hours (e.g., 45 minutes = 1 academic hour). Class and User Mana...
Hello again my friend! We have a new logo to be done please, this is for a company called "HDMO New Automobile Trading for Export" Can we please have some options with the name and some options without the name? The export all types of new cars (entry cars to luxury cars) In terms of color, they like blue and they hate red, so maybe something blue, or another color but not red Looking forward!
...primary function is to scan nutrition information on food packaging and assess the suitability of the food. Key Features: - Calorie Tracker: The app should keep track of calorie intake and expenditure. - Progress Tracking: Users should be able to monitor their fitness journey over time. - Barcode Scanning for Food Intake: Daily food consumption will be input through barcode scanning, not manual entry or voice input. The app should prioritize calorie information when analyzing food, although it should also consider macronutrients and other nutritional factors. Ideal Skills: - Proficient in Flutter or Kotlin - Experience in developing fitness or nutrition apps - Knowledge of integrating barcode scanning functionality - Understanding of calorie and nutritional analysis - UI/UX d...
...with real-world applications. Future goals in advancing media and technology. How to Participate: Write Your Articles, write as many as you can. Include links to sources like the webpages listed above and relevant hashtags and keywords so we can review your work. Publish It Online Your blog, Medium, LinkedIn, and other reputable publication, guest posts are fine. Submit Your Entry Share the links to your articles in our submission form. Rewards: Grand Prize: $45 + Feature on OpenQQuantify and Tomorrow's AI platforms. Bonus: Selected articles will be highlighted on our social media platforms, reaching thousands of viewers worldwide. You will also be invited to join our team! Selection Criteria: Numbers of articles written and submitted. Creativity and originality. Dept...
...innovative touch. With 8 years of experience, I’ve had the privilege of helping many clients achieve their goals through outstanding projects and results that speak for themselves. Why Choose Me? Strong and Versatile Expertise: I specialize in video editing, photo retouching, sound engineering, and leveraging artificial intelligence to enhance project quality. Creative and Professional Work: I excel at adding creative touches such as writing text on videos and delivering high-quality voice-overs. Commitment to Deadlines: I value your time and always ensure timely delivery of projects. Effective Communication: I work to understand your needs and vision fully to guarantee the best possible outcome. Services I Offer: Professional video editing tailored to all platforms. Photo...
I'm seeking a diligent Team of Classified Traffic Count Enumerator to analyze vehicle traffic from video footage. Responsibilities: - Count various vehicle types every 15 minutes. - Accurately log data into a specified Excel format. Vehicle Types to be Classified: - Cars, Trucks, Motorcycles - Auto Rickshaws, Cycle Rickshaws, Bicycles - LCVs under 4 Tons, 4-6 Tons, and 6 Tons - Tractors with and without Trailers - Construction Equipment Vehicle Types to be Counted: - All of the above vehicles Ideal Candidates: - Experience in data entry and traffic analysis preferred. - Proficiency in Excel essential. - Attention to detail and ability to work meticulously under time constraints. Prior to awarding the job, you will be given 15 minute video to co...
I'm looking for a professional with expertise in data entry and social media marketing to help me boost brand awareness across various platforms. Key Responsibilities: - Data Entry: Accurately input, update and maintain data. - Social Media Marketing: Implement strategies to enhance brand visibility on Facebook, Instagram, WhatsApp, and Telegram. Ideal Skills and Experience: - Proven experience in data entry. - Strong understanding and experience in social media marketing, particularly on the specified platforms. - Ability to generate creative marketing strategies. - Excellent communication skills.
I'm seeking a skilled designer to create a minimalist app icon featuring my initials, S and B, in a unique way. - The design should adhere to a clean, elegant, and rich aesthetic. - Inspiration can be drawn from the X AI logo by Elon Musk Background would be oxford blue. Logo icon would be white. Alternate background would be white with logo icon being black. If you are a Canva ...designer to create a minimalist app icon featuring my initials, S and B, in a unique way. - The design should adhere to a clean, elegant, and rich aesthetic. - Inspiration can be drawn from the X AI logo by Elon Musk Background would be oxford blue. Logo icon would be white. Alternate background would be white with logo icon being black. If you are a Canva person. Don't even bother to submit an ...
...skilled designer and video creator to clean up the mockup images I’ve created for my web application, DesignGenie, and transform them into a polished PowerPoint presentation and an engaging explainer video. ________________________________________ Project Overview: DesignGenie is a unique platform for fashion designers that combines AI-generated designs with tools like size chart generation, automatic Pantone suggestions, and tech pack creation. I need visually appealing and professional materials to showcase the product to potential investors and early users. The work is divided into three parts: 1. Clean up and refine the existing mockup images to make them visually professional and presentation-ready. 2. Create a PowerPoint presentation using the polished mockup images. ...
...gain insights from professionals 7. Stay updated with market developments and regulatory changes 8. Uphold professionalism, ethical standards, and punctuality 10. Seek feedback to improve skills and decision-making 11. Develop a strong foundation in stock trading and investing 12. No monetary investment is required *Skill(s) required* Accounting Financial Modeling MS-Excel Earn certifications in these skills Learn MS-Excel Learn Financial Modeling *Who can apply* Only those candidates can apply who: 1. are available for the work-from-home job/internship 2. can start the work-from-home job/internship between 17TH DEC TO 17TH JAN 3. are available for 1 month 4. have relevant skills and interests *Perks* Stipend: Performance-based (up to Rs.10000) Additional Incen...
...lightweight, and non-greasy formula. o Packaging: Sleek roll-on or compact tube for portability. 2. Windburn Protection Balm o Lightweight, protective barrier against windburn and environmental stressors. o Soothing and hydrating with aloe and panthenol. o Non-greasy and quick-absorbing. o Packaging: Small tin or tube for portability. 3. Daily Urban Shield Moisturizer (SPF 30) o Lightweight hydration with SPF and anti-pollution benefits. o Enriched with antioxidants for skin health and anti-aging properties. o Gender-neutral scent and smooth matte finish. o Packaging: Compact pump bottle for ease of application. 4. Protective Lip Balm (SPF 15) o Shields lips from dryness, cracking, and UV exposure. o Enriched with shea butter and vitamin E. o Non-sticky, smooth formula ...
Hello, I manage a 4-room hotel with double rooms, and I would like to automate several aspects of managing my establishment to optimize my time and profitability. I use Google Sheets to track my expenses and calendar, and I’m looking for an expert to help me automate the following processes: 1. Automatic Budgeting: • Maintenance: Monthly maintenance budget calculation. • Food Purchases: Calculate the food purchasing needs based on the number of guests staying each week and the remaining stock. • Salaries: Automate the calculation of employee salaries on a monthly basis. • General Expenses: Track monthly expenses such as client transportation, extra shopping, merchandising, etc. • Taxes: Calculate taxes to be paid based on the hotel’s month...
I'm seeking a diligent Team of Classified Traffic Count Enumerator to analyze vehicle traffic from video footage. Responsibilities: - Count various vehicle types every 15 minutes. - Accurately log data into a specified Excel format. Vehicle Types to be Classified: - Cars, Trucks, Motorcycles - Auto Rickshaws, Cycle Rickshaws, Bicycles - LCVs under 4 Tons, 4-6 Tons, and 6 Tons - Tractors with and without Trailers - Construction Equipment Vehicle Types to be Counted: - All of the above vehicles Ideal Candidates: - Experience in data entry and traffic analysis preferred. - Proficiency in Excel essential. - Attention to detail and ability to work meticulously under time constraints. Prior to awarding the job, you will be given 15 minute video to co...
I'm in need of a meticulous and dedicated freelancer to assist with manual data entry from scanned documents into Excel spreadsheets. Key Requirements: - Strong attention to detail and accuracy - Proficient in using Excel - Able to handle manual data entry tasks - Comfortable working with scanned documents Ideal Skills: - Data Entry - Excel proficiency - Attention to detail - Ability to work independently and meet deadlines
I need a Python script that can import mixed data (numerical and text) from an Excel file and produce a text file in a specified format. The output text file will be custom text format that I'll specify. Ideal Skills and Experience: - Proficient in Python, especially in data manipulation and file handling - Experience with Excel data import - Ability to understand and implement a custom output format - Strong attention to detail to ensure the data is correctly formatted.
Description: We are looking for an experienced Wix developer to implement a membership signup system on our Wix website, integrate a giveaway entry tracking system, and set up a calendar-based booking and payment system for 1-hour hoist rentals. Project Overview: Our business offers hoist rentals, and we are running giveaways to engage and reward loyal members. We need a system where: Users sign up as members via a Wix-based membership portal. Users can accumulate giveaway entries for completing specific actions, such as: Signing up for membership. Referring friends. Sharing content on social media. Booking hoist rentals or completing forms. A calendar booking and payment system is integrated where: Members can book 1-hour blocks to rent our hoists. Payments are collected at the t...
I need assistance merging my Excel spreadsheet with another to locate common product items. Key Tasks: - Examine two spreadsheets containing product information. - Match product information based on Product SKUs. Deliverable: - A detailed report of the mutual items found with the discounts of each item. Ideal Candidate: - Proficient in Excel with experience in data analysis. - Attention to detail for accurate product matching. - Capable of generating comprehensive reports. - possibly billing me for directions for my own use moving forward
Online Research and Data Entry: Manual Fixing Project Clean up HTML (remove inline styling, <span> tags, white blocks, unnecessary <div> tags) [Can largely be automated using an online tool] Review list formatting & fix as needed Reorganize information into the appropriate sections and input fields Remove sections of content Populate various input fields Download & upload photos to the appropriate sections Verify fixes and formatting on the front end Resort Pricing Project Prepare 7-night package pricing for every room type at every resort. This involves gathering pricing from WorkDrive, Zoho forms, our website, and the resort's website, often manually calculating packages based on room price, full board (if offered), airport transfers, and diving...
I've purchased a Lemaar Door closer for my interior wooden door but lack the tools and expertise for installation. The door closer comes with a manual, so familiarity with it will be beneficial. Ideal Skills: - Experience with door hardware installation - Basic carpentry skills - Familiarity with Lemaar products (preferred but not mandatory) Please ensure you have the necessary tools for this job.
I'm working on a personal project and I need a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization will be a key advantage.
...creation of new features over a period of years and/or months. The NEW CRM should be a claims management web-based software used for our business and eventually distributed/sold to other companies in the insurance business, third-party administrators (TPAs), and other entities that handle claims processing. Here are some key features of the NEW desired CRM: 1. Claims Intake and Management Claim Entry: Users can quickly enter new claims, whether they are submitted online or entered manually. Automated Workflows: Claims are automatically routed through predefined workflows for faster processing and approvals. Customizable Claim Forms: Tailor forms to meet specific needs for various types of claims. 2. Claim Tracking and Monitoring Real-Time Status Updates: Users can moni...
...Appointments**: - Displays a list of upcoming dental appointments scheduled by the user. - Users can add a new appointment by tapping the **“Add Appointment”** button: - Allows selecting the date and time using a Date Picker and Time Picker. - The system sends an automatic reminder notification **one day before the appointment**. #### 5. Profile Page - Displays the user’s basic information: - **Profile Picture**: Users can update their profile image. - **Username**. - **Email Address**. - **Add Additional Data**: Allows input of extra health information. - Additional features include: - **Change Password**: Supports two-factor authentication (2FA). - **Add X-rays**: - Allows uploading dental X-ray images. - **Add Medic...
I have a 242 page PDF payroll report with 9 or 10 employees' data on each page as a row. Format is the same for all pages. Need to take off only 6 of the entries per row that will be the columns. the finished product EXCEL spreadsheet is attached as a file here. One row on person's pay-week. One entry, the pay period ending is at the bottom of each page in the right hand corner. Same date for the employees on that page. A sample page of PDF is also attached as a file.
I'm looking for someone to compile a comprehensive spreadsheet containing all self-storage owners in the United States. Key Requirements: - Data fields: Each entry should include the owner's name and contact details, as well as the storage location addresses. As well as EMAIL - Organization: The data should be organized by owner name. Ideal Skills: - Data mining and research skills - Proficiency in spreadsheet software - Attention to detail for accurate data entry.
I'm looking to create a shipping method addon for CS CART (Aramex and Uber) to be integrated to the 3rd party system . The addon should provide: - Real-time rate calculation - Shipment tracking - Automatic label generation Additionally, some minor customizations to the existing shipping methods will be needed. Ideal candidates for this project should have: - Experience with shipping method integration, particularly with Aramex and Uber - Skills in real-time rate calculation setup - Proficiency in enabling shipment tracking and automatic label generation - Capability for minor customizations to existing shipping methods
Looking for an experienced EspoCRM developer to create a custom workflow automation that handles data transformation when converting Leads to Opportunities. Required Functionality: 1. Web Domain Value Transformation - Create a translation table mechanism - When a Lead is converted to Opportunity, use the Lead's web domain to derive two new values based on the translation table - These derived values should be stored in new custom fields in the Opportunity 2. Name Standardization - Implement automatic name formatting to convert any name to proper Name Caps format - Example: "john DOE" → "John Doe" 3. Character Set Conversion - Implement conversion of non-Latin characters to their Latin equivalents - Should handle various character sets includi...
Job Title: Data Entry Specialist Description: We are looking for a reliable and detail-oriented data entry freelancer to assist with our data management needs. The candidate will be responsible for accurately entering, updating, and maintaining various types of data in our systems and ensuring the information is organized and error-free. Key Responsibilities: Input and update data into spreadsheets, databases, or systems. Verify the accuracy and completeness of data entries. Organize and maintain files for easy access and retrieval. Review data for errors or discrepancies and resolve issues as needed. Meet daily/weekly productivity goals while maintaining high-quality standards. Follow privacy and data protection...
...occasional emergency meetings. The role primarily involves: - Managing and analyzing seller accounts on Amazon and Walmart - Overseeing product shipments - Conducting analysis and generating reports in Excel In addition to Amazon and Walmart, I would like this person to also manage my accounts on eBay, Shopify, and Newegg. Crucial Excel skills for this role include: - Proficient handling of Pivot Tables - Knowledge of complex formulas - Ability to create graphs Ideal candidates should have extensive experience with e-commerce platforms, particularly Amazon and Walmart, and a strong command of Excel. Full-time availability from Monday to Friday is a must....
I'm seeking a professional with experience in futures trading to assist with strategy optimization and backtesting. The main focus will be on refining my existing Ninjatrader strategies. Key requirements: - Proficient in futures market analysis - Skilled in strategy backtesting - Experienced in identifying optimal entry and exit points - Knowledgeable in financial software and tools - Full time or part time job
I am looking for a freelancer to help integrate GoHighLevel with Zoho CRM. This integration should enable GoHighLevel to be used as a messaging and VOIP solution, while keeping data synchronized with Zoho CRM. The solution should work seamlessly on both web and mobile apps. Since I resell GoHighLevel to my clients, I need this integration to be applicable to selected subaccounts. Below are the detailed requirements for this project: General Integration Requirements: Lead/Contact Details in GoHighLevel Inbox (Web and Mobile) Display lead or contact details in the right sidebar of the inbox or the details section of the LeadConnector mobile app when interacting with messages or calls. Creating New Leads in Zoho CRM Whenever a new message is received (e.g., via WhatsApp), a new lea...
I need help identifying a song from a recording I have. The assistance I require is specifically with the melody/humming. The recording is in MP3 format. PLEASE CHECK ATTACHED MP3 FILE. FIRST CORRECT ENTRY WINS THE CONTEST!
I'm seeking a professional with experience in futures trading to assist with strategy optimization and backtesting. The main focus will be on refining my existing Ninjatrader strategies. Key requirements: - Proficient in futures market analysis - Skilled in strategy backtesting - Experienced in identifying optimal entry and exit points - Knowledgeable in financial software and tools - Full time or part time job
