Excel VBA Jobs

I am looking for help in conducting an analysis of liquidity gap, repricing gap, economics value of equity, net interest gap, and duration gap till maturity. The purpose of this project is to identify any risks associated with these gaps. Expertise in economics and financial mathematics should be leveraged to develop a comprehensive model for the analysis. The analysis should account for market conditions including the impact of liquidity, interest rate cycles, and developing markets. The analysis should also consider the effect of portfolio composition, capital structure, leverage, and diversification on the results. The outcome of this project should include clear identification of associated risks and comprehensive recommendations for improvement. I anticipate this project to take up to...

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 need a expert excel date linearity

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.

I have a weekly team meeting with my IT techs and we go over our open tickets, our closed tickets, the age of our tickets and I would like to have a fancy report created with aa dashboard that shows all the information. I need this created before tomorrow for our meeting.

We had a freelancer who we've used to make many spreadsheets and calculator tools who has not had time recently to help with turn around projects quickly, so we are looking for another person. This current project is a calculator tool used for budgeting projects. We need to create validation rules, a few math expressions, and then pivot tables and reports. We want to be able to have people use this tool without needing to worry about worrying about viruses, so we are not using any macros or vba. Aside from skill with Excel, the person we select needs to have excellent math skills and be good with large number and data sets.

Tool used: Excel and R(if required) Task: task is to formulate the problem, prepare the data, run an analysis, answer research questions. Concept to be used : Linear Programming and Optimisation

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).

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

In spreadsheet , Column F (Field2) are a list of Youtube channels. For each channel, we want the scraper script to find the Youtube URL of the channel. For example, in Row 2, the URL for 滾石唱片 ROCK RECORDS is @RockRecordsTaipei . Candidates should state on which platform they plan to use, such as Google App Script, VBA, etc. Thank you

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...

We are looking to transform a CSV into something more useful for the project owners. Our ask is that a script/workflow will be created to automatically create 9 data tabs in an XLSX workbook and 9 stats tabs from the input CSV. The data tabs will be sorting/filtering the main CSV dataset into 9 smaller sets. The stats tabs will be identical in nature, just one stats tab for each of the 9 XLS workbook tabs. A small handful of charts and infographs will be required as well. This entire process should be automated and not require any administrative effort other than running the script. End result is that the project owners should then be able to open a Word DOC/template, point to one of the transformed XLS files, and MSFT Word would then output 9 reports - one from each of the stats ta...

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.