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