February 4, 20215 yr comment_4990 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 Report
February 5, 20215 yr comment_4992 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 Report
February 7, 20215 yr comment_4994 It sounds like you need to change the "Units" setting from kW to kWh. Hope that helps! Report
February 18, 20215 yr comment_5036 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 Report
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.