Excel Convertion to TMY2 too slow when using Office 365

Dear Community, 

Since upgrading to Microsoft Office 365 (coming from Office 2010) I have experienced up to 20 times slower convertion time when passing from excel to get TMY2 file.

I've been using SAM 2014.1.14 for several years and not more than 30 seconds were taking into this process, now, not less than 10 minutes or more are needed.

Is there any configuration I could make to solve this lossing time situation? (not SAM software upgrading is allowed- contract especification at my CSP Plant can't be changed)

Thanks in advance to all of you for your help.

Dear Alvaro,

Can you describe exactly what you are trying to do? I'm not sure what you mean by "passing from excel to get TMY2 file".

Best regards,
Paul.

Hi,

I'll try to explain step by step by attaching a pdf document.

1)I paste current meteorological data on Excel spread sheet 
2)click on the macro to convert to TMY2
3) select destination and substitute the original file.

---> wait about 30 seconds on Microsoft Excel 2010
---> wait about 10-20 minutes on Excel for Office 365

3)the file was created. saved.
4) run zSam for this CSP Plant Location.

Waiting for your coments. Thaks again.

Hi Alvaro,

Thank you for the additional information. Now I understand that your question is about the "Excel to TMY2 converter" spreadsheet.

That is a very old spreadsheet, and is no longer needed for SAM now that it uses the more flexible SAM CSV file format for weather data. NREL is also no longer using the old TMY2 file format for weather data, so data from the National Solar Radiation Database is provided in the SAM CSV format.

I'm not sure why the converter macro is taking so long to run on your version of Excel.

You might try using the "TMY3 Creator" in SAM 2014.1.14 by clicking "Create TMY3 File" on the Location and Resource page so you don't need to rely on Excel to create a weather file SAM 2014.1.14 can read.

Best regards,
Paul.