Half Hourly Data load profile showing half of total consumption

[Ryan PSE]

Hello.

I have formatted half hourly data from 2020 to cover 17568 values (366 days, 2020 leap year) The data imports fine, I can set it up as 30 min intervals, but the figures are all coming out halved. For example, if the total sum on the HHD spreadsheet is 42,000, PVSOL is showing 21,000, and all of the months are halved. Any advice?

 

Cheers

Ryan

[developer_mh]

Hello Ryan,

would it be possible to send me the file that you imported? You can send it to me by private message here in the forum, thank you.

Kind regards,

Martin

[jamesbm]

It sounds like you need to change the "Units" setting from kW to kWh. Hope that helps!

 

[developer_mh]

Hello Ryan,

sorry for the late answer, and thanks for the csv file. 

As James correctly pointed out, you'll have to set the "Units" to kWh (or Wh - depending on the data you have) and the "Number format" to "####.##" (i.e. a point and no comma), otherwise you will get incorrect values.
It should also be noted that you are trying to import a leap year. We filter out the leap day, which is why the year's total is a little lower than the total in your Excel file.

Hope that helps, kind regards,

Martin