Ryan PSE Posted February 4, 2021 Report Share Posted February 4, 2021 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 Quote Link to comment Share on other sites More sharing options...
developer_mh Posted February 5, 2021 Report Share Posted February 5, 2021 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 Quote Link to comment Share on other sites More sharing options...
jamesbm Posted February 7, 2021 Report Share Posted February 7, 2021 It sounds like you need to change the "Units" setting from kW to kWh. Hope that helps! 1 Quote Link to comment Share on other sites More sharing options...
developer_mh Posted February 18, 2021 Report Share Posted February 18, 2021 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.