Search the Community
Showing results for tags 'excel'.
Good morning, I'm running simulations for a self-consumption PV installation and in order to calculate a financial model I need to square hour-per-hour production and consumption with the electricity price according to Spanish legislation, which is rather complicated. Basically, there are 6 different prices which change depending on the hour of day, weekends, the month, and national bank holidays (please see the image I attach below if you're curious). I'm wondering if the hourly simulation results exported to Excel from PVsyst show production in the solar hour or in "legal" hours, which in Spain can have a 2-hour difference at times, so that for example 3pm could actually be 1pm, and the prices for electricity at those two times can sometimes vary significantly and thus impact the project's NPV / IRR. Thanks in advance for your support!