Could you provide me with an utility to change Excel files to tm2?
The best option for preparing weather data for use in SAM is the
TMY3 Creator
. It requires manually copying and pasting data from Excel or another spreadsheet program to SAM. It is also possible to automate the process by writing a script in
SAM's scripting language (SamUL)
with the
CustomizeTMY3() function to convert data stored in a text file to file in the TMY3 format for use in SAM.
I am aware of a
MATLAB program
to convert weather data from .xls to .tm2. There are probably other weather data converters out there.
Best regards,
Paul.