Uploading load data to Homer Pro
I'm a bit concerned I'm missing something obvious because I can't see this question asked anywhere before.
The Homer Pro help states that you can use six different formats to upload load data, including two-column format, three-column format etc. It also says that files have to be in text format. https://www.homerenergy.com/support/docs/3.10/importing-a-load-from-time-series-file.html
The only format I can get to upload is the sixth option listed. Any other attempts to convert my excel files into text and upload result in an error. Can anyone give me any ideas what I am doing wrong?
I am trying to model particular sites that I have 12 months load data for.
The file format (extension) doesn't really matter. You can import the load data using the excel file as such and don't need to convert it to a text file. If you still have the same issue, please send screenshot of the error that you get and I can look into it.
Could you guys also please try CSV format?
The CSV format should work fine. The dates in HOMER Pro start from 1/1/2007 by default because all calculations in HOMER Pro are calculated considering the 1st day of the year to be Monday and Jan 1st in 2007 is a Monday. This is why you see a mismatch in dates but that does not affect the energy balance calculations in any way.
While using CSV format, try the Import and Edit button and you can see where your dataset has incomplete or wrong values. If you still have issues in importing the load profile, please submit a ticket to email@example.com and attach the files and screenshots along with it. I can help you over our support channel.