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.
30 freelancers are bidding on average $17/hour for this job
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,
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
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! :)