Formula populate spreadsheet jobs

I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, man...Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate ...

I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar projects you've worked on in the past. Looking fo...

I am looking for a proficient specialist who can modify my IRR (Internal Rate of Return) spreadsheet aimed at financial analysis. The main requirement is unspecified modifications, suggesting that I need a freelancer who can intuitively understand how to improve the spreadsheet based on its current state and purpose. The IRR spreadsheet is used mainly for analyzing financial data, with a specific focus on calculating the Internal Rate of Return. Ideal Skills Required: - Expertise in financial analysis, particularly in calculating the Internal Rate of Return - Strong understanding of Excel spreadsheets, their functionalities, formatting, and calculation adjustments - Ability to assess existing tools and intuitively suggest and implement improvements. Please do not b...

...needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cash retained in the business after commissions. Ideal Freelancer: - Proficient in Excel: The freelancer should have a deep understanding of complex Excel functions and formulas. - Fin...

I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsheets, particularly in...

...by way of an MS Excel spreadsheet which will have columns that include the author (to be supplied); the verbatim quotation (or its English translation); the source of the information; and the name/date of the translation if the original quotation is not in English, plus any other pertinent information. Engagement Terms After an initial trial, we anticipate the ongoing engagement terms will be based on an hourly rate - as we understand some of the identified authors will prove more or less easy to obtain the required quotes/references. We are seeking an ongoing engagement with a suitable party which has the potential to expand past the initial task. Initial Trial Our starting point will be to provide a defined list of authors, along with the Excel spreadsheet temp...

I am in immediate need of an Excel specialist who is well-versed in formula troubleshooting and fixing. There are 4 formulas that require attention; unfortunately, I am unable to enumerate them as I skipped that information. However, here's what I can provide: - Detailed description of how each formula should function - Expectations for the fixes I'm looking for individuals who are confident they can rectify the issues and can offer neoteric solutions. This project requires more than just experience, a resourceful approach to problem-solving is necessary. The application must include: - Detailed project proposal The proposal should provide clear insight into your troubleshooting steps, planned adjustments, and method of testing the new formulas. Time effic...

I need a simple calculator to calculate the length of a timing belt based on two timing pulleys and a given distance between the centers of the pulleys. Here is complete example but I added one result more (see attached picture) , Belt Total teeth N, this result is get when L is divided with T and rounded to highest number (as example 23.2 is rounded to 24 or 56.8 is rounded to 57) It need to be used the formula shown on the calculator page. This must be added to woocommerce product page and must be working on PC and mobile version (responsive). I added it on the page as image illustration only but this must be replaced with working code

I'm looking for a freelancer to copy type a printed document into a spreadsheet. Key Requirements: - The source material is printed, not handwritten. - The final document should be a spreadsheet, not a plain text file or a formatted Word document. - Basic formulas need to be applied to the spreadsheet. Ideal Skills and Experience: - Proficient in copy typing. - Experience in data entry and spreadsheet management. - Familiarity with basic formulas in spreadsheet software.

I'm looking for a skilled freelancer who can help me organize and manage my data in a spreadsheet. The data will consist of text, numbers, and dates. Key Requirements: - Experience in data entry and management - Proven track record of successful data handling - Proficiency in spreadsheet software (Excel, Google Sheets, etc.) Your application should include past work you've done in similar projects. I'm looking for someone who is detail-oriented and can assure the accuracy and structure of the data.

Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.

Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.

I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

As an investor, I require a CFA-qualified professional to assist with complex bond pricing tasks. Specifically, my investment portfolio focuses on municipal bond...pricing tasks. Specifically, my investment portfolio focuses on municipal bonds and I am keen on better understanding their quantitative pricing. Key tasks will include: - provide spreadsheet with all cash flows and formula - extrapolate discount rate using forward sofr and muni curve - The perfect candidate will have a strong background in quantitative investment analysis, a solid understanding of bond markets, and proven experience in pricing municipal bonds. In-depth knowledge and practical application of quantitative pricing models will also be highly advantageous. In the end, I just want excel spreadshee...

Financial Statements based on Excel template and Data - you product financial Statement with fi...will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown in the renew breakdown This is not just putting data but understanding all financial Projection and profit loss - so will make sense this is projections for company for 2024, 2025, and 2026 We need it in 4 days from now you have to fill up all areas and Spread sheet tabs in the Financial Plan Spreadsheet Thanks! See attached Full Zip Specs Ideal skills and experience: - Proven experience in financial analysis, particularly in creating detailed financial projections. - A good understanding of business planning and financial analysis processes. - Proficiency in accounting software ...

We operate a Goog...Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. The documents created all appear here: Then deploy the working code to the Original spreadsheet. All bids are final.

I require a competent freelancer with experience in creating management systems to develop an automated spreadsheet for my insurance business. It will encompass the management of multiple insurance policy types including, but not limited to life, health, motor, travel and term insurances. Key Requirements: - Accurate tracking of policy details: This will span essential areas such as policyholder's name, policy start & end dates, insurance company details, premium amounts, policy type and number, beneficiary information, registration number, contact numbers, email IDs, premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry date...

I need a meticulous researcher to compile data from LinkedIn ...additional data fields from Google, Organization Website, and LinkedIn and put into Google spreadsheet doc including: First Name, Last Name, Job Title, Organization Name, Email, Address, City, State, Zip, Organization Website Address, LinkedIn, URL, Event Date, Event Name, Event Website You will locate people with several different job titles including: CEO, President, Chief Financial Officer, Executive Director, Director of Development, or any job title that contains "Development" or "Events" in it. I will provide you a Google doc in which you will work. You may work individually or as a team. You will fill in the google doc with multiple records that match each organization, each line in spr...

I'm seeking a proficient programmer to develop a code for programmatically filling forms using data from a JSON file. I don't know the PDF file internals and have encountered issues while attempting to parse fillable fields using Python libraries. The solution should effectively extract data from a JSON file and populate corresponding form fields within a PDF document. Prior experience with PDF manipulation and strong programming skills are essential for this task.

I need to find a job in a school as a teacher or teaching assistant. My Address: Tong Rd, LS12 5HE, England. The school must be a Primary School The school must have a vacancy ava...Tong Rd, LS12 5HE, England. The school must be a Primary School The school must have a vacancy available online. The job role must be a Teacher or Teaching Assistant. The school must be within 1 hour drive. Please check Primary School websites for job vacancies and add into a spreadsheet with: Primary School name - Area/Town - Job Role - Year Group - Advert Posted Date (if stated) - Start Date Anyone who can help me with this job search may be able to get regular work until I find a job. Must use a spreadsheet. Thanks Must have the name of the specific school (no generalised non-s...

Hello harry, are you able to make the same website in 2 days ?

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

The Logo will be of my initials M and H and will be put into the headrest (similar to the one attached). This is a formula 1 simulator, so please look at racing drivers such as Max Verstappen who already have a logo and try and come up with something. Incorporate the M and the H so it's not immediately obvious but when you look closer you can see it. Feel free to use creativity.

...be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelancer, and they must be able to seamlessly integrate these additional features into it. Ideal skills for this job include: - Advanced proficiency in Excel - Experience in developing automated systems within E...

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work efficiently and meet deadl...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance ...

...data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached () - this is for the items required by customers on Saturday May 4th. This data is not available to access without exporting it to a csv file. For retail orders we use Shopify but use two apps to provide the data to our production team so that they know when the customer has selected to pick up their order - Zapiet Pick + Delivery to assign an order pickup/delivery date (it does so by adding date tags to orders) and Report Pundit to organise this information into production reports. See an example Report Pundit export for Sunday May 5th (Production - Daily ) This data needs to populate into the relevant

Please look at the spreadsheet and ensure the new coins are added

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

I'm seeking a flexible skilled coder with robust experience in Pinescript and TradingView platform who can modify my existing Pinescript indicator. Key Modifications Include: - Parameter calculation changes: This includes both adjusting current indicator inputs and modifying the calculation formula to maximize the efficiency and effectiveness of the indicator. - Adding options to the settings interface to allow for customized user experience. - Based on testing, would need to accomodate any suggested changes realtime Your skills and experience in TradingView and Pinescript will be vital for the successful completion of this innovation-focused project. Your keen attention to detail and understanding of financial markets will also be advantageous.

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding...

I'm in need of a Python script that can efficiently take addresses from an excel spreadsheet and search google maps locate solar panels on roof tops Ideal Skills and Experience: - Proficiency in Python programming - Experience with image processing and analysis - Familiarity with satellite image utilization - Understanding of data output and manipulation in Excel Key Features: - The script should focus on residential rooftops specifically, using satellite images to identify solar panels. - It should be able to iteratively search through said images, pinpointing and marking the locations of solar panels. - The final output should be an Excel spreadsheet containing the results of the search, detailing the coordinates of the identified solar panels. Please, only bid...

I want all funeral directorss email addresses scraped from All send on a spreadsheet with Names, phone number, city and email address Price for all contacts from the site PLEASE PROVIDE PRICE TO COMPLETE THE JOB. DO NOT MESSAGE FOR A CHAT DO NOT BID A PRICE THEN ASK FOR A HIGHER PRICE Feedback will be left according to quality of work.

I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the ...data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel s...

I need an individual who can update my website with an array of physical products. Specifically, these will comprise a selection of paintings and prints/posters. This task will require: - Knowledge on how to upload and set up products effectively on my website. - An understanding of art, particularly paintings and prints, as you will need to write accurate and appealing product descriptions. Ideal candidates would have previous experience in eCommerce, particularly with physical art products. An appreciation for art and excellent attention to detail will be essential for this role.

I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products tha...Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables -...

I'm seeking a detailed market research report on the baby milk formula industry in India. The report should cover: - Market size and growth trends nationwide - An in-depth analysis of the competitive landscape including market share - An overview on consumer preferences and purchasing behavior The main objective of this market research is to assess the competitive landscape of the baby milk formula industry in India, enabling me to make informed business decisions. A nationwide, Pan-India focus is required. It would greatly benefit from having a candidate with experience in market research, an understanding of the Indian consumer market—especially the baby product segment—and excellent analytical skills.

I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching

...to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is developed with necessary security measures in place. This is to secure the data which officials input and populate for sharing. - The dashboard will be publicly accessible so it should be able to handle a high volume of traffic. Ideal Skills and Experience: - Proficiency in web development, particularly in creating real-time data visualization. - Previous experience in creating dashboards for live events or elections would be a big plus. - Knowledge of data security protocols to ensure the...

1. Develop a function that copies specific fields from Account records into corresponding Ticket fields automatically. 2. Develop a function that auto-fills multiple Ticket fields based on the input from a manually entered field. This function should dynamically pull data from the account database and populate the ticket fields according to the values entered. If your work meets our expectations, we may be interested in an ongoing collaboration for future projects across various Zoho applications (Desk, CRM, Campaigns, Projects)

I need help with data entry into spreadsheets. Key Responsibilities: - Efficiently and accurately transfer data into spreadsheet format Ideal Skills: - Proficient in spreadsheet software - Experience with data entry The project involves basic data entry tasks. The data is mainly in digital format. Your primary responsibility will be to ensure all data is accurately entered into the spreadsheet.

I require an expert in Excel to build a comprehensive tracking file. This task in...form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optimally to produce an efficient, easy-to-use, and insightful...

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data ent...responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project suc...

I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as Excel)

I'm looking for an experienced data miner or online researcher who can compile a comprehensive contact list consisting of both industrial business owners and industrial property owners in the Charlotte market. The data points that you need to scrape are the following: For Business/tenant contacts: * Property address * Property city * Property size (square footage) * Business/tenant n...different tools and strategies to scrape this information is a major plus. Experience in real estate or business to business lead generation projects will also be beneficial. The goal is to have a well-curated list of contacts complete with crucial details primarily for telemarketing and email marketing purposes. I expect the final output to be delivered in an organized and easy to navigate spreadsh...

I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.