solar plant revenue based on hourly production forecast

In Progress

I have an excel file with kilowatt hour (kWh) production data for a solar facility broken down by the hour over a 365 day period. I need a spreadsheet created that will allow me to use this forecasted production data to calculate how much revenue the solar facility will generate. There are variable rates based on how much solar energy is converted during two seasonal periods, the day of the week (Monday thru Friday) and the time of each day. Each daily period cell should offer a drop down to select individual hours between 5:00 am - 10:00 pm and corresponding cells to input rates. There are at least three separate rates that will contribute to the hourly revenue; power, capacity, REC. Rates paid may vary from day to day and hour to hour. Ideally the kWh production data will be imported from excel files.

Skills: Data Entry, Excel

See more: production spreadsheet, excel energy, Solar energy , rec, power plant, plant, plant plant, hourly, forecast, kwh spreadsheet, excel seasonal, cell power, day week monday, power cell, excel drop, daily revenue, energy kwh, online hourly based work, excel revenue calculate, production entry excel, paid time excel spreadsheet, individual hourly, revenue forecast, calculate revenue excel, hourly based

Project ID: #4728089

Awarded to:

mrkhodegaokar

I have delivered more or less similar excel sheets for my current MW scale solar energy projects.

$15 USD / hour
(0 Reviews)
0.0

30 freelancers are bidding on average $17/hour for this job

nagybatonyi

Such jobs are my daily practice. I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opport More

$22 USD / hour
(48 Reviews)
5.6
pkcyber

I will give u an automated application for this. Please see my releated projects in the links in your PMB. Keenly looking for your response. Regards, Ali

$15 USD / hour
(20 Reviews)
5.4
seaanddream

Hi, your 5-star excel and vba coding expert is ready to help you. kindly get back to me if you wish to proceed with a top-rated and reliable partner here...regards,

$15 USD / hour
(38 Reviews)
5.1
javed1705

please check pm

$15 USD / hour
(22 Reviews)
4.9
priyal1997

Dear Sir/Madam. Happy to help you on this project. ;-)) Kindly check pm for my bid details. Thanks - Priyal

$15 USD / hour
(38 Reviews)
4.7
satsin7

Hi! I am an experienced investment banker and have loads of experience in developing financial models. In fact I have also worked in the power industry for many years and developed financial models for solar power proj More

$15 USD / hour
(18 Reviews)
4.6
maverick44000

Hi there. Without any exageration, I can get it done within 2 days and not more than 10 hours. I recently worked on a similar project for a US based client. Regards

$16 USD / hour
(2 Reviews)
3.8
eperfections

10+ years experience. Done excel manipulation many times. Please see private message

$15 USD / hour
(9 Reviews)
3.3
Thang93

Hi mdonnellysolar! Experienced Excel user. I can do this job quickly! I'm ambitious, hardworking, punctual and really want to perform well. Please check PM and Portfolio to see my skills! :)

$15 USD / hour
(5 Reviews)
2.9
pawankhurana

HI i can help you on that check Pm for details Regards pawan

$15 USD / hour
(4 Reviews)
2.6
CivilMechEng

Please check the PM.

$15 USD / hour
(3 Reviews)
2.0
swaroopjacob

Dear Hiring Manager, I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Office. My typing speed is +55 words per minute. I believe More

$15 USD / hour
(2 Reviews)
1.0
thuneshk

I am interested in this project.Hope you will consider me. Thanks

$20 USD / hour
(0 Reviews)
0.0
professionaldeal

I'm a PhD student in Renewable energy field. Interested in your job on solar power. Looking forward to proceed. See my PM also.

$15 USD / hour
(0 Reviews)
0.0
spaul1107

Hello, I can get this completed. Please check PM. Thank you

$17 USD / hour
(0 Reviews)
0.0
ms629277fl

The project as stated sounds very interesting. My own enthusiasm for solar energy and its potential as a business makes me curious to see where these real world numbers go. I have some experience using Excel, Access More

$22 USD / hour
(0 Reviews)
0.0
preemptlessidea

Hi I am Suman have good skill on Design and all type of HTML (HTML, XHTML, HTML5, 100% layout, Mobile design) http://www.preemptlessidea.com this my personal web site. http://www.completewebgraphics.com/ http:/ More

$15 USD / hour
(0 Reviews)
0.0
asociatianike

Hello, Is a very nice an interesting problem to solve, please read PM to view my idea.. Regardly..

$16 USD / hour
(0 Reviews)
0.0
ayyim

Hi, i'am expert in excel especially data entry..

$22 USD / hour
(0 Reviews)
0.0
bmatson11

I have been using Microsoft Excel for over 15 years. I am an expert in creating spreadsheets for any purpose, even complicated ones. I am confident that I have the skills you are looking for to complete your project in More

$17 USD / hour
(0 Reviews)
0.0