Excel automatic data entry formula jobs

Rahul, Hello! A few months ago, you helped me to convert a Google Docs based spreadsheet ito an Excel format. I now need to use it for another client & want to change the values in the drop-down menu for the strengths/development areas. I was able to unhide the settings tab and update the dropdown menu source but now it causes a run error for our "start" setup function. What is the cost to fix this & also set it up so i can easily make these changes for other clients? Mary

I'm seeking an experienced professional to produce 10 exam papers for me, each containing 35 non-verbal reasoning questions. The questions should be of high difficulty and in line with the GATE exam's Abstract Reasoning component for Year 7 entry in Australia. Specific Requirements: - Format: The papers need to be delivered in PDF format, in black and white. - Question Sourcing: A mixture of original questions and those from specified sources. - Answer Key: Each exam paper should include an answer key. Ideal Skills and Experience: - Strong understanding of non-verbal reasoning questions - Experience in creating or sourcing exam content - Ability to maintain consistent difficulty levels across papers. Please refer to the attached document for an example of the forma...

Web scrape Automation: I can scrape multiple pages using Selenium and Python, extract all the data, and seamlessly convert it into an Excel file.

I'm seeking an Excel expert to assist with semi-monthly payroll calculations. Tasks will mainly involve tracking hours, vacation pay and holiday pay. The project has the following components: - Gross pay calculation: Accurately determining pre-tax earnings based on hours worked and other factors. - Tax deductions: Applying the correct tax rates and ensuring compliance with relevant regulations. - Net pay summary: Summarizing post-deduction amounts in a clear, concise manner. Skills and experience in data analysis and financial modelling are a plus, as is familiarity with macros and automation. The ideal candidate will be detail-oriented, reliable, and able to validate data to minimize errors.

I'm in need of a customizable Excel template specifically designed for project management. This template should allow a user to input a project name and its go-live date, and in response, automatically populate all related deadlines, legal references, and resources. Please note, I will populate the actual document with the data, but require a fully functional template with adjustable formulas. Key Requirements: - The template must include deadline formulas that populate fields based on the proximity of the go-live date, taking into account: - The year (i.e., the year prior, odd years, etc.) - The number of days (i.e., 45 days prior to go-live, 60 days prior to go-live, etc.) - The month and/or day of the week (i.e., first Friday in August prior to go-live, second ...

Project Description 1. Read data from Nse Bhav copy excel file 2. Do calculation as an output I need 9-10 columns after calculation 3. I need a code/ Software which I can use in my laptop 4. This code will ready the input file which I will put in a folder 5. Also calculate OI change activity if it getting in creased or decrease. 6. Oi change calculation input data will be in the same file 7. Calculate OI Interpretation

I am looking for a proficient Excel expert to design an Audit Tracker for me. This tracker will manage and monitor up to 50 separate audits. The tool should be capable of tracking both corrective and preventative actions as statistics. It should also present a live stats dashboard that displays the progress of all audits, current outstanding audits, and their respective progress. Key requirements: - The tracker should be able to identify and reflect audit trends for the year as audits are added. - The dashboard should include visuals primarily in the form of bar charts. - Additional information to be displayed on the dashboard includes: audit completion rate, monthly audit trends, and audit compliance scores. Ideal skills for this project: - Advanced Excel skills, including...

The indicator includes TP levels, dynamic Buy Orders, entry shifts, and SL, coded in Pine Script for TradingView.

...all tender information from both platforms in Namibia on a daily basis. The scraped data should be neatly organized in an Excel spreadsheet. Key Requirements: - The scraper should pull data from all relevant sources, including government websites and social media. - Information to be collected includes: the name of the entity or organization, tender advertising date, due date, a clickable link for document download, and contact details. - One of the primary websites to scrape from is: , which mainly hosts government tenders. - The scraper must ensure no tender is overlooked. Ideal Skills and Experience: - Expertise in web scraping and data collection. - Familiarity with Excel and data organization. - Experience in developing scrapers that gat...

I need an Excel expert to create monthly reports for my crockery and cutlery inventory. Sales Report: - Should include total revenue. Inventory Report: - Should include sold items and quantities. Sold Items Breakdown: - By category (e.g., crockery, cutlery). The ideal freelancer for this project would have extensive experience in Excel and data analysis, with the ability to create clear, concise reports. Familiarity with inventory management and sales reporting would be a plus.

Please Sign Up or Login to see details.

...login and dashboard functionality. ### Key Responsibilities: 1. Dashboard for Union Members: - Implement features for managing "Exclusive for Union" accommodations (viewing, adding, or excluding units) using the existing dashboard UI. - Develop back-end APIs to list and toggle accommodations as "Exclusive for Union." 2. Discount Management: - Create functionality to configure automatic discounts for union members (global or category-specific). - Ensure real-time price calculations based on configured discounts are accurately displayed. 3. Vacation Fund Management: - Use the existing dashboard UI to display union members’ vacation fund balances and expiration notifications. - Create APIs to fetch fund balances and gen...

I'm looking for a freelancer who can assist with data entry. Key Responsibilities: - Entering text data from text files into databases. - Handling numerical data sourced from databases. Ideal Skills and Experience: - Proficiency in data entry tasks. - Experience working with databases. - Good command of handling and processing text documents.

...elements in data visualization and effective communication. Here are some tips for creating good graphics and designs: Chart 1. Choose the right graph type (bar, line, circle, etc.). 2. Use contrasting and harmonious colors. 3. Give clear labels and titles. 4. Ensure the scale and axis are accurate. 5. Avoid data overload. 6. Use animation wisely. Design 1. Choose a font that is clear and consistent. 2. Use colors that match the theme. 3. Arrange the composition and free space. 4. Create a simple and intuitive design. 5. Ensure alignment of visual elements. 6. Use relevant images and icons. Graphic Creation and Design Tools 1. Adobe Illustrator 2. Canva 3. Tableau 4. Power BI 5. Google Data Studio 6. Microsoft Excel Additional Tips 1. Know your audience a...

...detect specific objects. Implement a data transmission system configurable based on the installation environment (Wi-Fi, LoRaWAN, or 4G/LTE). Optimize energy management to ensure continuous operation, even with limited sunlight. Device Operations Flow: Idle State: Only PIR sensors remain active to detect motion. All other system components (cameras, Coral, communication modules) remain off or in low-power mode. Motion Detection: A PIR sensor detects motion and sends a signal to the management microcontroller. The microcontroller activates the corresponding camera and wakes up the Coral Dev Board Micro. Image Capture and Processing: The camera captures an image or sequence of images and sends it to the microcontroller. The microcontroller transmits the data to the Coral ...

I'm in need of an Building Designer to help create my home project. step 1 = insert new survey step 2 = shower sewer and junction using old survey Step 3 = create floor plans using DH Markup as a guide Step 4 = Propose Levels for each floor based off existing survey Step 5 = introduce stairs with correct levels from basement to rear GF and entry example project have been provided

Its urgent...I'm preparing for a finance interview and need an advanced Excel sheet that I can use to demonstrate my skills. The Excel sheet should be able to handle budget and forecasting data, and it should include the following features: - Pivot tables and charts: These should be used to summarize and analyze the data efficiently. - Advanced formulas and functions: I need the sheet to incorporate complex calculations to showcase my understanding of Excel. - Data visualization and dashboards: The sheet should be able to present the data visually, making it easier to understand and interpret. The ideal freelancer for this project should have extensive experience in creating sophisticated Excel spreadsheets, particularly for th...

...app) for LIPAEARN, an engaging and profitable online earning platform. The platform will cater to a global audience and should highlight various earning activities: - Watching YouTube and TikTok videos - Playing games (Chess & Draughts) - Clicking ads - Answering simple trivia questions - Spinning Key features of the platform will include: - Welcome bonus upon joining - Weekly agent bonus - Automatic activations - Instant withdrawals - Free forex classes - 24/7 customer service As this is an international venture, it is crucial that the platform is user-friendly, engaging, and offers seamless navigation. Prior experience in developing similar platforms will be an added advantage. Please note, an activation fee is required to get started. Your bid should reflect your un...

...view it in read-only mode. Can view submitted data and monitor the submissions, including user participation, via an interactive dashboard. Role should allow filtering and sorting of submissions. - User: Can submit the form and may interact with specific sections depending on the permissions and workflow configuration. Workflow System: Customizable Workflows: The workflow should be easy to define and modify: Basic submission without approval. Level 1 approval. Multi-level approval (e.g., Level 1, Level 2, and Level 3 approvals). Approval Process: Forms should include an approval system where designated users (e.g., Managers, Leads) can approve or reject form submissions based on the workflow rules defined. 4. Notifications: - Automatic Notifications: The system shoul...

I'm looking for a freelancer to help me with data entry in Excel. The job involves using basic arithmetic functions. Ideal skills for the job include: - Proficiency in Excel, particularly with data entry - Familiarity with basic arithmetic functions in Excel - Attention to detail to ensure accuracy in data entry Experience in similar projects would be a plus.

I'm seeking a skilled Excel expert to troubleshoot and repair my complex Excel workbook. The issues primarily pertain to intricate multi-step formulas affecting the entire workbook. Post-repair, I would appreciate a detailed walkthrough of the fixes implemented. Ideal Skills and Experience: - Proficient in Microsoft Excel, particularly complex multi-step formulas - Strong troubleshooting and problem-solving skills - Excellent communication skills for clear explanations

...Spaincheck.com. Each tool will include a visually appealing and intuitive interface, optimized for seamless use on both desktop and mobile platforms. Deliverables and Specific Requirements Salary Calculator Page URL: Current Stage: From Scratch To Be Completed: Design the user interface and layout. Implement formulas based on the provided Excel file: Add embed code generator and PDF download functionality. Capture user email before PDF download. Expat Tax Checker Page URL: Current Stage: Almost Finished To Be Completed: Design Improvements Mortgage Calculator

...chance to get them paid—by winning a skill-based game (Spot the Difference). Two months ago, we launched, attracted a few players, and celebrated some winners. After pausing to rebrand, we’re ready for an exciting relaunch. Check out our new website - One of our marketing ideas is to encourage users to create short videos in exchange for a free competition entry. We’re still exploring the most effective types of videos and how to make this idea successful, and we need your expertise to help bring it to life. ### **What We’re Looking For** 1. **Relaunch Strategy and Execution:** - Refine and finalize our relaunch strategy. - Optimize the website for user engagement and conversions. 2. **Viral User-Generated Content (UGC) Campaign:** - Expan...

I'm seeking a talented Flutter developer to create a robust Android app tailored to meet specific producti...primarily function as a productivity functions. - It will include unique features such as printing and reporting. - It will also incorporate additional functionalities like reporting tools and the ability to export to PDF/Excel. Ideal Candidate: - Proven experience in Flutter development. - Prior work on productivity tools will be a plus. - Skills in client-side systems development, ensuring seamless integration and performance. - Expertise in implementing printing capabilities and reporting tools within an app. - Familiarity with creating export functionalities to PDF/Excel. If you are passionate about creating user-friendly and efficient applications, I would ...

I need assistance converting PDF tables to an Excel file. The PDF consists of simple tables with rows and columns. The Excel file will require some specific formatting. Ideal skills for this project include: - Proficiency in Excel - Attention to detail for precise data transfer - Ability to follow specific formatting instructions

I need an Excel-based master file to allocate components/parts to various work orders. The file should indicate which work orders have sufficient stock and which ones are short. Key requirements: - The master file should be in Excel - It should include automated functions using formulas (no macros required) - It should focus on the allocation of components/parts Ideal skills and experience: - Proficiency in Excel, particularly with creating and using formulas - Experience in supply chain management or inventory control - Ability to create user-friendly, organized files for tracking purposes.

I need assistance with data entry from my invoices into an Excel spreadsheet. I will provide photocopies of the invoices, and I need the following details extracted: - Name of product - Date purchased -invoice number amount purchased units description price summary of total brought price per unit Please provide me with your price per invoice.

I'm looking for a detail-oriented freelancer to help me with data entry. The data is a mix of text and numbers sourced from online databases. The final product should be an organized Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry from online databases - Ability to handle mixed data types (text and numbers)

I'm looking for a developer to create a website for me. The primary function of the site will be to facilitate the upload and download of mechanical CAD designs. Key Requirements: - Only I, as the website owner, will have access to upload and download files. - The website should have automatic backups to ensure the safety of the files. Ideal skills for this project include web development, understanding of CAD files, and experience with implementing backup systems on websites. Please provide examples of similar projects you've completed.

I'm in need of a diligent data entry professional to assist with transcribing information from existing digital files into a specified format. Key Requirements: - Transcription of text data from Word Documents - High attention to detail to ensure accuracy - Timely completion of tasks Ideal Skills and Experience: - Proven experience in data entry from Word Documents - Proficiency in Microsoft Word - Strong written communication skills for maintaining data integrity

I need assistance with entering text data into MS Excel. The numeric data is currently stored in a database, and I need this transferred to Excel in a clear and organized manner with basic formatting (like headers and columns). Ideal skills and experience for the job: - Proficiency in MS Excel - Experience with data entry - Ability to follow formatting instructions - Attention to detail - Basic understanding of databases.

I am looking for a professional to assist with my bookkeeping tasks using Microsoft Excel as well as accounting software Xero. This will involve data entry and organization, managing accounts payable and receivable, and performing bank reconciliations. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience in bookkeeping and managing accounts - Attention to detail for data entry and bank reconciliation Skills Required Accounting Excel Finance Xero Bookkeeping

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. NEED TO CALL AND DISCUSS SOME DETAILS BEFORE STARTING WORK

...email option. Key Features: - The application needs to have cross-platform compatibility, working seamlessly on Android, iOS, and the Web. - It must feature a user-friendly interface and incorporate secure login and user management. - Incorporation of AI guided site visit workflows are essential. - Automatic report generation is a must. - Advanced AI analytics and summary capabilities. - AI-based recommendations to assist field users. - Automated data validation to ensure the accuracy of collected data. Ideal skills for this job would include: - Proficiency in cross-platform app development. - Strong understanding of AI integration in applications. - Experience in developing user-friendly interfaces. - Knowledge of secure system implementation. - Capable of delive...

I'm in need of a seasoned Full-Stack Web Developer to build an interactive, secure website centered on QR code generation. The site will feature: - User registration and form submission - Automatic QR code generation post form completion - PIN-protected access for specific actions - Automated email notifications to users and selected contacts The project will heavily prioritize data security, smooth operational flows, and an intuitive user interface. Detailed specifications will be provided to shortlisted candidates. For your initial inquiry, please provide: - A rough cost estimate for a project of similar scope - Your availability timeline - Relevant experience or portfolio examples Note: More detailed technical requirements will be shared with suitable candidates a...

I have a data entry task that needs to be completed on my computer using TeamViewer. Requirements: - The data entry involves mixed data (text and numbers) from scanned documents. - The final format of the entered data should be in an Excel spreadsheet. Ideal Skills: - Experience in data entry is preferred. - Proficiency in Excel is crucial. - Familiarity with TeamViewer is a plus. - Attention to detail is key, as the data is coming from scanned documents.

I'm seeking a freelancer skilled in data analysis to help me prepare for an upcoming viva. The tasks will involve: - Data cleaning and preprocessing - Creating dashboards and visualizations - Running complex queries and reporting Proficiency in the following tools is essential: - Excel - Power BI - SQL Experience in these areas is crucial, as I need to demonstrate a solid understanding of advanced data analysis techniques during my viva. I look forward to working with someone who can help me master these skills and improve my chances of success.

...indicator prints all boxes green / has already printed green boxes - Type 1: Price retraces to 10EMA for the entry (THIS CAN BE ENABLED OR DISABLED) - Type 2: Price retraces to low 8 EMA for the entry (THIS CAN BE ENABLED OR DISABLED) - Optional filters: (THE FOLLOWING CAN BE ENABLED OR DISABLED INDIVIDUALLY) 1. All boxes of pips 29 indicator are green 2. 10 EMA is above 34 EMA Sell: - On M15 chart, price is below 200 SMA - On M15 chart, the 8EMA (High and Low) channel is below 200 SMA - M15 Genesis indicator prints all boxes red / has already printed red boxes - Type 1: Price retraces to 10EMA for the entry (THIS CAN BE ENABLED OR DISABLED) - Type 2: Price retraces to high 8 EMA for the entry (THIS CAN BE ENABLED OR DISABLED) - Optional filters: (THE FOLL...

I'm seeking assistance with manual data entry tasks from text files. The project encompasses handling approximately 50-200 text files. Ideal Skills and Experience: - Proficiency in data entry - Attention to detail - Experience with text file processing - Ability to maintain confidentiality and handle data responsibly.

i have two of my suppliers websites that i need product data scrubbed and put into an excel sheet. All the images need to be saved to a file with product code label.

I am seeking an experienced developer who can integrate a reliable payment gateway into my high-risk website, an SMM panel. - The payment gateway must be compatibl...platforms. - It should ideally support various payment methods, including but not limited to PayPal, Stripe - Although I have not specified particular features, I would appreciate a gateway that offers fraud detection and multi-currency support. - The ability to handle recurring payments is a plus, as my site will require it. - The selected professional should also be able to implement support for automatic refunds. Ideal candidates should have proven experience with payment gateway integration and a strong understanding of high-risk online platforms. Please note that clear and open communication is essential for thi...

I need a skilled developer with expertise in cloaking payment gateways, particularly Stripe. The job entails cloaking transaction det...entails cloaking transaction details, payer information, and order info. The process should be seamless in terms of user experience, with users being redirected back to Site A automatically after making a purchase on Site B. Key Requirements: - Proficient in cloaking payment gateways, especially Stripe - Capable of concealing transaction details, payer information, and order info - Ensures automatic redirection to Site A post payment on Site B Ideal Candidates Should: - Have a proven track record in payment gateway cloaking - Possess excellent understanding of Stripe's functionalities and limitations - Be able to deliver a secure and user-fr...

I'm seeking a detail-oriented freelancer to help with uploading auto parts to my Shopify website. The task involves: - Working from a product list with SKUs provided in both Excel and CSV formats. - Downloading product images and descriptions from a specified source. - Uploading the images and text into Shopify, creating product listings, and saving them as drafts. Skills Required: - Proven experience with Shopify product uploads. - Proficiency in managing and organizing product data using Excel and CSV files. - Strong attention to detail to ensure accurate uploads. Ideal Candidate: - Familiar with managing SKUs and product variations. - Can start immediately and complete the task efficiently. Deliverables: - All products uploaded and saved as drafts in Shopif...

I'm looking for a professional with expertise in ANSYS to help me extract data related to deformation and displacement from the program. The extracted data should be delivered in Excel format. Please note, I might require some post-processing depending on the quality of the raw data.

...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you have exp...

...Yahoo Finance, TradingView, or any specified platforms for data gathering and analysis. • Compile reports and summaries of your findings. • Generate charts, graphs, or data visualizations as needed. • Maintain organized documentation of your research process and results. • Provide insights or commentary based on the data, where applicable. What I’ll Provide • Detailed step-by-step instructions for each task or project. • Guidance on methodology and tools to use. • Feedback to refine the process and expectations. What You Bring • Strong experience with stock market analysis and financial tools. • Familiarity with financial metrics like P/E, EPS, ROE, and others. • Proficiency with platforms like E...

THE MOST IMPORTANT THING is understanding the data and good English communication skills. I have an existing project that requires a variety of data cleaning, streamlining, and analysis. The ideal candidate will be proficient in Excel Macros and VBS, with coding skills to tackle complex tasks. If any humans are actually reading this - I am looking for someone I can communicate well with and who can talk through a solution with me and then implement it. Will start with a simple data transformation operation to see how we work together. I will offer the winning bidder an hour of paid time to discuss my project and see how we communicate and if we agree I will assign a task to begin. Thank you

I need a skilled TC2000 coder to translate my current script into TC2000. The script involves a straightforward scan strategy based on technical indicators. If you can also provide insights or enhancements based on your experience with TC2000, that would be a plus. I'm looking for someone who can deliver high-quality work in a timely manner.

I need a seasoned professional skilled in utilizing spreadsheets and uploading product images for Walmart's marketing platform. The primary focus will be on analyzing product performance. Key Responsibilities: - Data entry and organization - Product performance analysis Ideal Skills: - Proficiency in spreadsheets - Experience with Walmart's marketing platform - Strong data analysis skills - Ability to upload product photos

We are seeking a reliable and organized Admin Assistant to support our team with essential administrative tasks. This role offers a monthly salary of $420 USD and requires excellent organizational skills and attention to detail. Key Responsibilities: Manage and organize documents, schedules, and team communications. Assist in data entry, record-keeping, and maintaining accurate files. Coordinate with team members to ensure smooth daily operations. Handle administrative tasks such as creating reports and preparing correspondence. Support in scheduling meetings and managing calendars. Requirements: Proven experience in an administrative or assistant role. Excellent communication skills and attention to detail. Proficiency with productivity tools such as Microsoft Office or Goo...