Excel Macros Jobs

I am looking for a freelancer to help me merge congressional district codes with zip codes and latitude and longitude data. The main purpose of this project is for voting analysis. I require the merged dataset to be in Excel format (or Stata). 1) go through to extract "New ZCTA Master Data Set" the crosswalk between congressional district code and zip codes. 2) use the crosswalk to map on my master files 3) link the merged files with latitude and longitude 4) Use two redistrict events in 2000 and 2010 to identify districts that under through the redistricting process Please contact me with a proposal with the time line. I will evaluate the bid based on both the pricing and the proposal quality.

I need a convenient data-entry form to work with a tsv table in Excel. Tables are generated elsewhere and include words which need to be annotated using a pre-defined set of values. I attach technical specifications and a sample table (saved as Excel workbook to keep the formation for the purpose of this message; original tables will be in the tsv format).

Have multiple tasks using excel macros, looking for someone really skilled to help me out with my projects.

I am looking for a google app script expert who can write scripts to automate certain google forms tasks to maintain inventory.

Hi I need someone who is good at excel who can make a scorecard

I am looking for an expert who can make custom scripts and formulas on Google Sheets and google forms to track inventory. You must know English and Hindi.

We want to update the R&D Project status automatically based on the inputs in different excel sheets,

Job Description: We are looking for an Excel expert to create a mortgage calculator with multiple tabs for our financial analysis needs. The calculator should have the following functionality: Tab 1: Comparison Calculator Display loan provider details, including loan amount, interest rate, and loan term. Calculate and display the monthly payment and total payment for each loan provider using appropriate formulas. Tab 2: Effective Rate Calculator Input and manage details for multiple accounts, including balance, interest rate, and payment term. Calculate and display the effective interest rate for each account using the provided information. Tab 3: Monthly Savings Comparison Compare the monthly payments of an existing loan and a new loan from a chosen loan provider. Display the effectiv...

I need a convenient data-entry form to work with a tsv table in Excel. Tables are generated elsewhere and include words which need to be annotated using a pre-defined set of values. I attach technical specifications and a sample table (saved as Excel workbook to keep the formation for the purpose of this message; original tables will be in the tsv format).

Moveing fm one date base to other data abse

It's urgent! Hi, I have an excel sheet and i want to dynamically fetch data from some rows and display user forms accordingly. Thanks

Specific Requirements The data received from Vivino wine rating IT department comprises three data files: , and Region.xml. The file records the information of wine list across the world which detailed information about their ratings is recorded in and records the country of each wine region. You are asked to: 1 Import all the data from the other files into the Excel file. Write Excel formulas to fill the last three empty columns in the file with appropriate information provided from the other files. 2 Assess the data and correct it if necessary. You are also required to use Excel functions to automate the correction. 3 Investigate the data distribution of wine price by drawing its histogram and boxplot and providing your insight. 4 The company wants to collaborate with the favourite...

I am looking for a freelancer who can help me with linear programming for my caravan park management project. I want to maximize profits and need someone who has experience with Excel Solver to help me with the following: - Analyzing my existing data and constraints for the linear programming model - Developing a linear programming model that can maximize profits for my caravan park management project - Implementing and testing the solution to ensure it meets my requirements The ideal candidate should have the following skills and experience: - Proficient in Excel Solver and linear programming - Experience in caravan park management or a similar industry - Strong analytical and problem-solving skills - Excellent communication and project management skills If you meet these require...

I'm in need of a freelancer to help me automate a specific excel file and will require advance excel skills (VBA & Macros) . The project is for personal use and the specific task I need help with is performing calculations/formulas. The automation should be set up to be compatible with the latest version of Excel. Additionally, I would like it to have as few errors as possible and to be efficient so that the file runs quickly. If you can help me create an Excel file that is accurate, efficient, and compatible with the latest version of Excel then please reach out.

We have Fintech platform for publish Personal loan and other loan rates through our platform Banks provide personal loan to employees of different companies (it can be a private limited, Limited, partnership, trust, society, proprietorship) Each bank provides a list of company in excel sheet with around 50,000 to 1,00,000 or more companies The name of a company in each bank has to be mapped to single company name. It also has to be checked with MCA website(it is a government website for LLP, pvt ltd, ltd companies) and other government websites. WE also have to map it to few data points which shows how many employees work in that company etc.. This data has to be synchronised 0r uploaded with our platform which is developed on Laravel php and Angular for providing interest rates....

this project involves sorting the list in excel and writing string string statement of top x components of that list on csv files.