solar plant revenue based on hourly production forecast

This project was awarded to mrkhodegaokar for $15 USD / hour.

Get free quotes for a project like this
Project Budget
$15 - $25 USD / hour
Total Bids
Project Description

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.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online