If you are trying to upload a custom weather file and get the "Error Parsing File" message, the formatting for your weather file may not match what HelioScope is expecting. All data in the uploaded weather file must be in the correct format, or it will result in an error message. In many cases, it is easier to take the critical columns from your weather file and paste them into a weather file known to upload into HelioScope. Below are the steps to get your weather data into a working weather file.
Step 1: Download this Sample Weather File (CSV)
Step 2: Use Excel to copy the following values from your weather file and overwrite the sample weather file. Make sure to leave row 2 (the column headers) unchanged.
General Weather File Fields
The first row in the sample weather file contains information about the weather file. The most important fields to update are Timezone (UTC), Latitude, and Longitude (Column D, Column E, and Column F), so the weather file shows up in the correct location with the correct Time Zone. Below is a list of all seven fields in the first row of the sample weather file. Note that the upload will only work for a single year of data.
| A | B | C | D | E | F | G |
| File ID | File Name | State (Abrv.) | Time Zone | Latitude | Longitude | Elevation |
Standard Values
The sample weather file contains 70 data columns, but most columns are not required fields. Instead, focus on updating the fields that affect performance modeling in HelioScope. Below is a list of the four most important fields to update for simulating performance in HelioScope:
- Global Horizontal Irradiance (GHI) - Column E
- Diffuse Horizontal Irradiance (DHI) - Column K
- Dry Bulb Temperature (Ambient Temperature) - Column AF
- Windspeed - Column AU
Optional Values (set cells to 0 if unavailable)
The columns below are not required to run a simulation, but feel free to enter them if you have them:
- Direct Normal Irradiance (DNI) - Column H
- Albedo - Column BJ
- Dew Point Temperature - Column AI
- Relative Humidity - Column AL
- Precipitable Water - Column BD
Step 3: Clean up the CSV file before saving
Excel's date formatting can break the weather file parser. Before saving, make sure the date is in MM/DD/YYYY format.
- Select Column A from Row 3 through Row 8762
- Click the Formatting Dropdown and select More Number Formats
- Under Custom manually enter "mm/dd/yyyy"
- Click OK and save the file
Step 4: Clean up the file in a text editor
Excel leaves behind metadata when saving a CSV. Below is a snapshot of the first line from the original sample weather file compared to the first line when we save in Excel:
As a result, the last step in preparing a weather file for uploading is going in and reversing the metadata that Excel adds to the weather file. Only two simple things we need to change to get the file to upload cleanly:
- Put quotation marks around the file name (in this case "Seattle_SA_TimeSeries")
- Delete the line of commas following the last number (elevation of 61 in this case)
Below is the cleaned-up result. Note that the new Seattle formatting matches the original sample file:
NOTE: If your file name contains a non-English letter, such as Ó or ü, those complex letters will break the uploader. Change them to their non-accented counterpart and the upload should work correctly.
Step 5: Save and upload your new weather file
Go to the Weather File Uploader to upload the newly created weather file. For more information on how to use the weather file uploader, please review the weather file upload instructions.