solaranywhere weather data compatibility issue?

• Missing data. Some columns have no values, and some rows may have missing values.
• The time stamp is inconsistent with the TMY3 time convention: The hour time stamp for the last hour of the day is 0:00 instead of 24:00, and the final hour of the year is on January 1 instead of December 31.

UPDATE 9/6/2019: In newer versions of SAM, the Solar Resource File Converter implements the conversion algorithm in the LK script below, so you do not need to download the script. Instead, click Macros under the Simulate button and then choose Solar Resource File Converter from the list of macros.

1. Download the script ( LK 4.65 KB ).
2. Start SAM, and click Open script and open the LK file you downloaded in Step 1. (If SAM is already open, you can open the script SAM Start menu.) Read the description of what the script does in the comment block at the top of the script.
3. Click Run at the top of the scripting window. If all goes well, the script should create a SAM CSV file with the data from your SolarAnywhere file and save it in the same folder as the SolarAnywhere file.
4. Open your SAM project file, and on the Location and Resource page, add the folder that contains the SAM CSV file to the Folder Settings list (click Folder Settings) and refresh the library.
5. Click View hourly data to see the data. Missing data should be visible in the graphs as -999 values.

• 
  Convert SolarAnywhere and SolarAnywhere TMY3 files to SAM CSV. The script determines the input file format from the number of columns in the header row. This simple approach should be robust enough for files from SolarAnywhere, but may cause problems if you try to convert files that are not in one of the SolarAnywhere formats.
• 
  For SolarAnywhere files with historical data over a multi-year period, the script creates a separate SAM CSV file for each year and appends the year to the file name so that you can use the set of files for P50/P90 simulations in SAM.
• 
  The script replaces blanks in the original file with -999 flag values in the SAM CSV file to avoid simulation errors in SAM. See the comments in the script for more details about how this might affect simulations.
• 
  When you convert a file with one year of data, the script displays the converted file in the time series data viewer.

1. 
   Download the LK file from the  Sample Files page .
2. 
   Start SAM, and click Open Script on the Welcome page. You do not need to run the script from an open case.
3. 
   Navigate to the folder that contains the LK script and open it.
4. 
   Read the information about the script in the comments, which appear as green text in the script editing window.
5. 
   Click Run at the top of the script editing window and open the SolarAnywhere file you want to convert.
   
   
   
   The script will save the converted SAM CSV file(s) in the folder that contains the original SolarAnywhere file. To use the SAM CSV files in SAM, you can either add them to your weather file folder, or use the Use a specific weather file on disk option. See the Help topic "Weather Files and Libraries" under "Weather Data" for more details.