You have chosen to sponsor your bid up to a maximum amount of .
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.