Jump to content

Half Hourly Data load profile showing half of total consumption

Ryan PSE

Recommended Posts


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?




Link to comment
Share on other sites

  • 2 weeks later...

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,


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...