I have an Excel sheet weather data for Maan Jordan, where the parameters (GHI, DNI, Ta...) are daily, not hourly. I would like to convert this weather data file from excel format into TMY3 format, so I can use it in the simulation on SAM. The version of SAM is 2016.3.14. Could you please tell me how to do this conversion?
SAM requires a weather file with at least hourly data, so it will not work with daily data.
Also, in general, I would recommend using the SAM CSV format for creating your own weather files instead of the TMY3 format. The SAM CSV format is more flexible, and does not require all of the extra data columns of the TMY3 format. You can download a PDF file describing the SAM CSV format here:
sam.nrel.gov/sites/default/files/content/documents/pdf/wfcsv.pdf
Best regards,
Paul.