I need to create a user interface "tool" on EXCEL

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

I have a list of 20 energy efficient projects and each one has calculations and results for the following variables: energy savings MWh, CO2 reduced, investment euros, financial savings and payback period.

What I want to create is a user interface that shows 4 different scenarios or possibilities that select the top 8 projects of the list considering:

Scenario 1. Prioritizing the variables of low Payback time and low investment

Scenario 2. Prioritizing the vriables of low payback time and high CO2 reductions

Scenario 3. Taking into account low payback time, high energy savings MWh and low investment

Scenario 4. Taking into account all variables equally as important. Meaning top 8 projects with low payback, high energy savings MWh, high CO2 reduction, low investment and high financial savings

They idea is to create a "tool" so that the user can press a button according to the variables he/she want to prioritize. So for instance, if the person is coming from the economic department they will give more importance to investment and payback, what are the top 8 projects that show? environmental department might give more importance to high CO2 reduction and fast payback, etc etc... that why I have the different scenarios.

Excel Financial Analysis Statistics UI / User Interface Visual Basic

Project ID: #18334742

About the project

13 proposals Remote project Active 5 years ago

13 freelancers are bidding on average €43 for this job

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project create a user interface "tool" on EXCEL. I can assure you the quality job. I have good experience in Excel, Financial Analysis, Statistics, U More

€160 EUR in 3 days
(586 Reviews)
8.5
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

€30 EUR in 3 days
(336 Reviews)
7.5
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor More

€50 EUR in 1 day
(278 Reviews)
7.1
daniyal3214

I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Forecasting, Cash More

€30 EUR in 1 day
(283 Reviews)
7.4
nvchien94

No more than 3 hours you can get your result. I need to discuss 1 point that not clear so I can start. Contact me if needed. Thank.

€14 EUR in 1 day
(229 Reviews)
6.6
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

€100 EUR in 3 days
(113 Reviews)
6.6
ravim211071

hi I have a good knowledge of advanced Excel with macro and pivot table.I can complete your work in just one day. let's work together to make a change

€11 EUR in 2 days
(14 Reviews)
3.7
claudiasofamata

I have the patience and dedication necessary for this task, as well as a experience in the hierarchization of capital investment projects. Hello. My name is Claudia Mata, I am specialist in Excel, I stand out for doin More

€50 EUR in 2 days
(3 Reviews)
1.7
aktaiasha

I am a web developer and highly experienced in Social Media Marketing. I have more than 8 years of experience in design. Success is my priority. If you want your business to be at the greatest level and your place in S More

€11 EUR in 1 day
(0 Reviews)
1.4
khalilbrellin

i am an experienced call center leader who has experience in creating excel reports and tools Relevant Skills and Experience i know advanced excel reporting

€24 EUR in 7 days
(0 Reviews)
0.0
JCGauvreau

Hello, With around 4 years of professional experience financial modeling in Excel, I believe that I have the expertise to model the different scenarios and to make it intuitive to change between them. Thank you, More

€30 EUR in 3 days
(0 Reviews)
0.0
Rana09

Hi, Good day! I can do this simple interface which show your required results depends on the criteria. Hope I can do it within one day. Please see my sample work. Hope, we can work together and create a professiona More

€19 EUR in 2 days
(0 Reviews)
0.0