Excel automatic data entry formula jobs
I need a freelancer who can extract data from structured tables in a PDF and input it into a spreadsheet. The ideal candidate should have experience in data entry and be proficient with Excel. Attention to detail is critical to ensure all data is accurately transferred.
...bot. The module will dynamically handle position entries, bot-managed Stop Loss (SL) and Take Profit (TP), and real-time synchronization of wallet and trading data. It will integrate with a Redis database for state management, providing seamless performance. Below are the detailed requirements and expectations. Key Features and Requirements 1. WebSocket Integration The module must utilize KuCoin’s WebSocket API to ensure real-time updates and precise control over trading operations: • Position Monitoring Subscribe to /contract/position to track and manage active positions. Ensure accurate synchronization of position details such as entry price, quantity, and mark price. • Order Tracking and Immediate Cancellation Monitor orders via /contract/order. If an o...
...in Static Margin from Subsonic to Supersonic flight ≤ +10% To numerically evaluate and optimize the performance of a UAV, we use the flight score formula: Vehicle performance Score ? × ? × ???????? ? = ?????? × ? Where: • M = Mach Number • L = Lift Force (N) • ???????? = Payload Weight (in kilograms) • ?????? = All-up Weight (in kilograms) • D = Drag Force (N) This formula quantifies the UAV's performance by combining its endurance, range, and payload capacity while factoring in the total weight. To achieve the highest flight score, the UAV should maximize endurance, range, and payload weight while minimizing all-up weight. By applying this formula, we aim to identify UAV designs that offer optimal performance, bala...
I have a Word document that needs formatting to present as a business report. The elements that require formatting include: - Table of Contents - Headers and Footers - Headings and Sub-headings There's no specific style guidelines or templates to follow, so creativity and attention to...experience with document formatting for business reports. It is a 100+ page manual that need to be properly formatted. The contents were pulled from various Word files from various sources. The document has numerous formats that had to be corrected manually. Need someone to go through the entire document so it flows properly and when changes need to be made, it formats properly. Also need to have an automatic Table of Contents created that will automatically update when the changes are made ...
I need a professional WordPress developer...professional WordPress developer to customize the WordPress Automatic Plugin for my theme. Requirements: - The main functionality to be customized is content scraping and auto-posting from various blogs. - The plugin should be tailored to scrape content specifically from blogs, enhancing the quality and relevance of the content being posted on my site. Skills and experience needed: - Proficiency in WordPress and PHP. - Experience customizing WordPress plugins, particularly the WordPress Automatic Plugin. - Familiarity with content scraping and auto-posting functionalities. - Understanding of blog structures for effective content scraping. The plugin I want to customize from ThemeForce
I am looking for a skilled developer to create a time sheet application for Windows-based desktop systems. The application should primarily support manual time entry. Key Features: - The time sheet application should be easy to navigate and user-friendly. - It needs to support Windows operating system seamlessly. Ideal skills and experience: - Proficient in desktop application development, specifically for Windows operating system. - Previous experience in developing time tracking software is a plus. - Strong understanding of creating user-friendly and intuitive interfaces.
...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...
I'm looking for a comprehensive Excel budget sheet tailored for personal finance. It should help me track monthly expenses, savings goals, and debt repayment. Key Features: - Track monthly expenses: The sheet should have a clear layout for tracking all monthly expenditures. - Monitor savings goals: I want a section that helps me visualize my progress towards different savings targets. - Debt repayment tracking: I need a part of the sheet dedicated to my debt, with space for each individual loan or credit line. Built-in Formulas/Functions: - Automatic expense categorization: The sheet should have a method for categorizing expenses, ideally automating this process based on pre-set criteria. - Savings goal progress calculation: A built-in function to calculate how close ...
I'm looking for a reliable and detail-oriented data entry specialist. The tasks may vary from updating databases, entering data into spreadsheets, to transcribing documents. Ideal Skills and Experience: - Proficient in data entry tasks - Strong attention to detail - Good at transcribing - Experience with updating databases - Able to work on a long-term basis for $2 per hour
1. Introduction Tabou Connection Inc., a non-profit organization, is seeking a skilled software developer or development team to build a Membership Management Software. The syst...systems. Payment gateway integration (e.g., Stripe, PayPal). A database to manage and store member details and payment records. Testing, debugging, and deployment of the software. Documentation and training materials. 4. Key Features User Authentication: Secure login via email/password. Payment System: Multiple payment options, real-time transaction tracking. Membership Categorization: Automatic update of member status based on payments. Reports: Downloadable payment history and status reports. 5. Deliverables Fully functional software (web and mobile). Deployment to a hosting platform. Doc...
...include: Company Logo (provided upon project award) Consistent and modern design formatting Clear and organized layout for easy readability The design should reflect a professional and contemporary look that aligns with our brand identity. Both price sheets should be formatted for easy editing in the future (preferably in Microsoft Excel or Word). Requirements Proven experience in graphic design or document formatting Proficiency in tools such as Microsoft Excel, Word, Adobe Illustrator, or similar Ability to integrate branding elements (logo, color scheme, etc.) Quick turnaround time (please specify availability in your proposal) What We Provide Current price sheets Company logo and branding guidelines Deliverables Two separate price sheets (Distributor and Customer) in...
I'm seeking a professional for a dual task: 1. Website Design: The primary aim of the website is to facilitate multi-step forms and inc...incorporate file upload capabilities. As such, you should have experience in designing user-friendly, intuitive websites with these specific features. Your design should prioritize simplicity and functionality, catering to users of all skill levels. 2. Data Entry: This task involves document transcription. The selected freelancer should possess excellent typing skills, a keen eye for detail, and experience in transcribing various types of documents accurately and efficiently. Your bid should reflect your experience in web design and data entry, particularly document transcription. Please provide examples of similar pr...
Excel expert to analyze my data. Your goal will be to provide insights from my data, so experience in identifying trends, performance metrics and conducting predictive analysis is a plus.
I'm seeking a professional who can design and implement an automatic control system for monitoring and diagnostics of my industrial machinery. The ideal candidate will have a strong background in control systems engineering and experience working with industrial machinery. Key Responsibilities: - Design an automatic control system for industrial machinery. - The system should be capable of monitoring and diagnosing issues. - The system should monitor temperature and pressure. Ideal Skills: - Control Systems Engineering. - Experience with industrial machinery. - Proficiency in designing monitoring systems. - Understanding of temperature and pressure monitoring. Please provide examples of similar projects you've completed in your bid.
Hi there - I'll deliver the work as we have discussed. Thanks for the work!
I'm looking for a proficient Excel expert to develop a simple yet effective project and task tracker template for me. It should accommodate tracking of daily, weekly, and monthly tasks. Key Features: - The template should include automatic updates. - Task reminders are essential to help keep track of deadlines. The design of the template should be simple and clean, avoiding unnecessary clutter while ensuring all necessary information is easily accessible. Ideal skills for this job include advanced Excel proficiency, experience in template creation, and an understanding of project management principles. Th image attached is an example of what it currently looks like. It is not formatted well and looks disorganized.
...scripts - one for Mac and the other for Windows. These scripts should navigate and complete application forms online using data from an Excel spreadsheet. Key tasks for the scripts include: - Navigating to the specified website and locating the application forms - Filling out the forms with user credentials sourced from an Excel (.xlsx) spreadsheet The scripts should be able to handle: - Login information for multiple users - Completing forms quickly and accurately Ideal candidates for this project should have: - Proven experience in creating automation scripts for form-filling - Deep understanding of both Mac and Windows operating systems - Proficiency in handling Excel data - Experience with online application forms Please note, the scripts will...
I'm seeking a skilled WordPress developer to create a custom plugin that displays product prices based on SKUs. This price lookup will be shown on a separate page with a search bar for SKU inputs. Key Requirements: - Develop a custom WordPress plugin that displays product prices by SKU. - The option to upload the latest prices should be in the form of uploading an Excel Sheet - The last update date should be shown. - It should have the option to show custom Fields like Category of the Product being Searched , HSN Code and Tax % Ideal Skills: - Extensive experience with WordPress plugin development. - Strong understanding of SKU-based pricing systems. - Proficient in PHP, JavaScript, HTML, and CSS.
I need an experienced Google Sheets expert to create a formula for me to sum numbers contained within brackets in a single cell. The numbers are separated by words and semi-colons. The formula should also account for decimal numbers, which should be included in the sum. here is an example of a cell: Dorp ( 27632) 34540; La Cotte ( 7433) 10390; Welgeluk (4000 ) 5000; Beach Villa (10285 ) 12100; Botlierskop (34680 ) 56040; Pure Sea (13760 ) 17200; ATG (10485) 11785 I am currently adding the numbers in brackets manually to input into the next cell, but want a formula to add these numbers
I'm looking for a proficient Excel expert to develop a simple yet effective project and task tracker template for me. It should accommodate tracking of daily, weekly, and monthly tasks. Key Features: - The template should include automatic updates. - Task reminders are essential to help keep track of deadlines. The design of the template should be simple and clean, avoiding unnecessary clutter while ensuring all necessary information is easily accessible. Ideal skills for this job include advanced Excel proficiency, experience in template creation, and an understanding of project management principles. Th image attached is an example of what it currently looks like. It is not formatted well and looks disorganized.
I'm in need of an Excel expert who can utilize the VLOOKUP function to assist me in matching customer information within a single Excel file. Ideal Skills: - Proficiency in Excel, specifically with VLOOKUP - Experience in data matching - Attention to detail for accuracy
I'm in need of an Excel expert who can utilize the VLOOKUP function to assist me in matching customer information within a single Excel file. Ideal Skills: - Proficiency in Excel, specifically with VLOOKUP - Experience in data matching - Attention to detail for accuracy
I need a comprehensive Excel sheet tailored for tracking employee work hours, overtime, and materials. This sheet should allow for easy manual data input. Ideal skills and experience for the job: - Proficiency in Excel - Prior experience in creating tracking sheets - Good understanding of time and material tracking - Attention to detail
I'm looking for an Excel expert to develop a comprehensive dashboard for sales data. This will involve defining key performance indicators, organizing data, creating a report, and generating histograms and frequency tables. Key Tasks: - Design and implement a user-friendly Excel dashboard for sales data. - Identify and define relevant KPIs, focusing primarily on the Inventory Accuracy Rate. - Organize the data in a meaningful way. - Create a comprehensive report. - Generate histograms and frequency tables. The data will not be updated on the dashboard. Therefore, it's crucial that the dashboard is designed to be static, yet insightful. Ideal Skills: - Proficiency in Excel, particularly in dashboard creation. - Experience...
Advertising game platform development web app pwa Advertising costs are deducted when you play a simple advertising game Automatic registration of all contents using SNS API Promotional partner reward system PayPal payment Self-generated coin payment and product payment Apply only if you meet the following conditions for participation in development 1. More than 5 years of relevant experience, intermediate or higher 2. The client does not speak English, so someone who does not have communication problems using a translator 3. The development budget is $200 and the development period is 15 days 4. Someone who has experience making a simple game in 30 seconds
I need a Power App created from my Excel data. This app will primarily be used by my internal team members to automate certain processes. Key Features: - Workflow Automation: The primary purpose of this app is to streamline our workflows. - Data Handling: The app should facilitate data collection and updates. Ideal Skills: - Proficient in Power Apps and Excel - Strong understanding of workflow automation - Experience in creating user-friendly internal apps This project is aimed at improving our efficiency by minimizing manual tasks and reducing the time spent on data handling.
I need an Excel expert to help me automate my change order form. This form is crucial in the construction industry for tracking additional work beyond the initial contract. Ideal Skills: - Proficient in Excel 365 - Experienced in creating and automating Excel spreadsheets - Knowledge of construction industry practices is a plus Requirements: - Automating the process of adding tabs for additional change orders (jobs can have between 1 and 20 change orders) - Automating the written dollar amount - Setting up pre-filling information for the next change order With this automation, I aim to streamline the process, reducing manual input and potential errors. Looking forward to your proposals.
I'm currently seeking a part-time position in the customer service field. My expertise includes exceptional communication and problem-solving skills, technical support capabilities, and data entry proficiency. Ideal Skills: - Excellent Communication Skills: Able to articulate clearly and effectively, both verbally and in writing. - Problem-Solving Skills: Capable of identifying issues and finding effective solutions promptly. - Technical Support Skills: Experienced in providing tech-related assistance and troubleshooting. - Data Entry: Proficient in accurate and efficient data handling. If you're looking for a diligent and skilled customer service professional, I'd love to connect.
Description: We are looking for a skilled graphic designer to create a professional and eye-catching flyer / social media creative for our "MS-Excel Mastery" course. The flyer will be used for online promotions and must effectively communicate the course details, benefits, and call-to-action. Reference: Please refer to the attached flyer for design style and content inspiration. We are looking for something along similar lines but with a fresh and unique look that aligns with our branding. Requirements: Course Details to Highlight: Course Name: MS-Excel Mastery Learn skills from Basics to Advanced. Perfect for: Students, Professionals, Business Owners. Admissions Now Open for the January 2025 Batch! Price: ₹5500 (Original Price: ₹6999). Course Highlights: 100% ...
I'm looking for assistance with data entry, specifically extracting text data from online databases. The ideal candidate should be detail-oriented, efficient, and skilled in navigating online platforms.
...with advanced search and AI-driven recommendation features. Key Responsibilities: 1. Develop a user-friendly website with comparison tools and filters. 2. The college list should be shown to students based on their eligibility criteria, including their scores. 3. Automatic Discounts should be Shown to students according to their scores and colleges while they pay the application fee through the payment gateway. 4. Integrate AI algorithms for personalized college recommendations. 5. Manage a secure database for colleges and user data. 6. Optimize search functionality for speed and relevance. 7. Ensure seamless backend and frontend integration with APIs. 8. Students should have a login dashboard to check their application status Required Skills: Frontend: HTML, CSS, Java...
I'm looking for a seasoned Typescript developer with expertise in Palantir Foundry. The goal is to automate real-time monitoring through a Qlik Dashboard, using Foundry Functions and a mapping excel document. Key Aspects: - Real-time Analytics: The automation should focus on real-time monitoring. - Integration with APIs: The system will pull data from various APIs, so experience with API interaction is crucial. - Proficient use of Qlik: The automation will occur via a Qlik Dashboard, so familiarity with Qlik is essential. Ideal Skills: - Deep knowledge of Typescript - Extensive experience with Palantir Foundry - Proficient in Qlik - Strong understanding of real-time monitoring systems - Experience with API integration
I am in need of a reliable data copying service to accurately replicate asset maps from photos onto a PDF plan. This task must be completed using specific Apple tools, including an iPad running IOS 16.4 or later and an Apple pen, within a 3-4 day turnaround time. Key Responsibilities: - Copying asset maps from photos onto a PDF plan with precision - Ensuring copied asset maps are good representations of the originals - Completing the task within a 3-4 day timeframe Requirements: - Access to an iPad running IOS 16.4 or later and an Apple pen - Ability to accurately replicate detailed specifications - Adherence to the project timeline Training and assistance will be provided to meet the project's specifications. I have an ongoing need for this service, and am willing to pay $1...
Excel to Branded Adobe Forms Conversion as per discussed to design the excel and connect them to a QR code for students to download it.
...commercial directors, etc.). • Organized and capable of delivering detailed reports with the gathered information, including names, positions, companies, emails, and phone numbers when available. Tasks to Perform: • Identify relevant companies in Canada, Poland, and France interested in olives, pickles, or gourmet products. • Locate and verify key contacts within these companies. • Create a database in Excel or Google Sheets format with the collected information. Deliverables: • A database with at least 200 qualified contacts per country (total minimum of 600 contacts). • A report detailing the methodology used for prospecting. How We Will Evaluate Your Proposal: • A brief description of your experience in client prospecting. • Tools you us...
DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1
I'm in need of a web scraping expert who can help me extract text data from a specific website. The project involves scraping user data and compiling it into an Excel file. Key Requirements: - Proficient in web scraping techniques, with a focus on extracting text data. - Able to deliver the scraped data in Excel format. - Prior experience in scraping user data is a plus. Please note: The data to be scraped from the website is exclusively text, with a focus on user data.
I'm looking for an Excel macro that validates IPv4 addresses, subnets, ranges, and TCP/UDP ports. Requirements: - The macro should validate only IPv4 addresses. - Upon detecting an invalid IP address or port, the macro should both show a warning message and highlight the cell. - The macro needs to validate IP address, subnet, range, and port. Ideal Skills: - Extensive experience in Excel and its macro programming. - Understanding of IPv4 addressing. - Ability to implement user-friendly error handling. PAYMENT WILL BE MADE VIA 25$ GIFT CARD.
DONT USE AI TO WRITE COVER LETTER. I WILL NOT HIRE BOTS. Write briefly if you can work under budget and can start immediately. Enter Excel file with recent projects I have completed, well organized, and categorised for future use and portfolio reference. My profile: https://www.freelancer.in/u/Ansaf1
...involves QR code scanning and data logging. Key Features: 1. Login Activity: Users will log in by scanning a QR code with their device's 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 d...
I'm seeking an experienced Excel professional to customize a workbook for tracking sales leads. The workbook should be user-friendly, as leads will be entered manually. Key Requirements: - Create a comprehensive and intuitive workbook for logging sales leads. - Incorporate advanced Excel functions to enhance tracking and lead management. Skills & Experience: - Proficient in Microsoft Excel with a strong understanding of its advanced functions. - Experience in developing and customizing Excel workbooks for lead tracking. - Previous experience in sales or lead management is a plus. Please note, the project does not require automating follow-ups or importing leads from other systems. The focus is on creating a tailored workbook for manual data ...
...involves QR code scanning and data logging. Key Features: 1. Login Activity: Users will log in by scanning a QR code with their device's 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 ...
I need an expert in Tableau who can create an interactive dashboard for visualizing economic data aimed at assessing a country's sustainability indicators. Key Requirements: - Proficiency in Tableau with experience in creating interactive dashboards. - Ability to visualize economic data in an understandable manner. Please note that while I have not specified the primary indicators to visualize, All of the data, how I want it to be visualized and structured on the page will be given. I will send the expert excel sheets, data and instructions on where each data set should be inserted and how different data sets might link to each other. All I need is a somebody who can do the visualization part of the project and provide with a clean...
I'm looking for a freelancer who can assist me with data entry. The specifics of the data entry tasks are not yet defined. I may need help with manual data entry, data extraction, and data cleaning. Ideal candidates should have: - Experience with different types of data entry - Proficient in using Excel and other data management tools - Attention to detail for data cleaning tasks Please note, the source of the data and the final format are yet to be determined. Therefore, flexibility and willingness to adapt to changing requirements are essential.
I'm seeking a skilled mobile app developer to create a cross-platform (iOS and Android) mobile application for automatic backup of crucial data. This app should be capable of: - Automatically backing up photos and videos, contacts and documents. - Storing the backed-up data securely in the cloud. Ideal candidates for this project should have extensive experience in mobile app development with a strong portfolio of cross-platform applications. Understanding of cloud storage solutions and data security is critical. I also value proactive communication and a keen attention to detail.
I require assistance with manual data entry from my digital files, predominantly Excel and Word. The data is mixed, encompassing both text and numeric components. Ideal Skills and Experience: - Proficiency in Excel and Word - Excellent attention to detail - Prior experience in manual data entry - Ability to handle mixed data (text and numeric) - Strong organizational skills
I need my sales data cleaned and sorted. The data is currently stored in Excel/CSV files and contains duplicates, inconsistent formats, and missing values. Ideal skills and experience: - Proficiency in Excel and data management - Experience with data cleaning and sorting - Attention to detail to identify and rectify data issues - Ability to work with large datasets
...for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that w...
...management with login options (Google, Facebook, email). 3. API Integrations: - Mediastack: Configure GET requests to fetch news based on defined parameters (category, date, language). - OpenAI GPT: Implement automatic summaries based on fetched news. - ElevenLabs: Configure text-to-speech conversion with customized voices for categories (e.g., male voice for sports). Generate MP3 files ready for playback and download. 4. Technical Requirements: - User Authentication: Using Supabase with user roles (authenticated, admin). - Storage: Efficient use of Supabase to manage search history and data cache. - Speed: Optimize API responses and summary generation to under 3 seconds. 5. Deliverables: - Functional MVP Fully integrated backend. Functional and attractive frontend, acc...