DallasRead
-
Posts
5 -
Joined
-
Last visited
DallasRead's Achievements
Newbie (1/14)
0
Reputation
-
Thank you for the conversion! I have tried to use your macro to convert my table by copying and pasting that into my existing spreadsheet (changing the table name to 'table') and running the macro, but unfortunately it only copies the first column of 365 numbers, and does not copy the second column below that, so not sure why that is not working? Can you post my original excel spreadsheet with the macro embedded, then I can simply duplicate it, and use in the future with new data? This 365 Row x 48 Column format is the standard output to customers in the UK with a >=100kVA supply. There is normally other rows & columns included such as the headers, dates and often other extra info such as power factor lead/lag etc, but those are easily deleted without disturbing the main usage data. I'm sure it would be useful if it was included within the PVSol programme ongoing. Many thanks so far though Dallas
-
I will try to write a suitable macro myself to do this. If I achieve this I'll post is on the forum to share. Dallas
-
I thought that might work, but it is my understanding that the transponse only works if you have one row to convert to one column. In this case I have 365 rows (the days) and 48 columns (one for each 30min usage period) so the transpose doesn't work, as far as I know. I am more than happy to be proven wrong though!
-
Thanks for your response on this. I thought it must be a formatting problem. Unfortunately all our Half hourly meter data is in tabular form in UK, so it is simple to remove the columns and rows to remove the header, but difficult to convert to a single column of 17,520 rows. Is there any way in which we can enter the data in a 48 Column x 365 Row format? Alternatively have you a spreadsheet with a suitable macro to convert the above format to the required single column. It should be just maths, but I'm not sure I have the required Excel skills! Cheers Dallas
-
I have been struggling to import load profiles into Premium edition. My task is to import Half Hourly usage data for a site into PVSol, then I can run a simulation to predict the Exported energy and onsite usage, important to show the business case for a local Power Purchase Agreement. My problem is that no matter what format I try (text or CSV in every combination that Excel can output), I cannot get the data to load into the 'Import Load Profiles' section of the 'Consumption' page. The Error message is 'konvertierungsfehler in datensatz in zeile 1', or 'conversion errors in data in line 1' translated. I have even tried to word wrap the text file to try to get it into a single column then save it without luck I have tried formatting the column to ensure there are 2 decimal places, so it mimics the 'number format file' drop down list (####.##) exactly, but no. I believe it is a format issue, but I really cannot work out what it is. I have included a couple of the files I have tried on this posting. Can anyone help? Dallas Simple HHM for PVSol (MSDOS).csv Test (Unicode Text)(WRAP).txt