generate report in CSV format

Hi, I am trying to generate report of the simulation in another currency. Since there is no real option to change currency in SAM, I was wondering if the report can be exported to an Excel file or CSV file - any editable form really.

Just out of curiosity, is there is an LK script that creates the PDF report? Perhaps, I could directly modify that for my requirements.

Any other suggestions would be much appreciated. Thanks

Hello,

It is not possible to edit the PDF report template.

You can export data and images of graphs from the Results page by right-clicking (ctrl-click on some computers) the graphs and tables you see on the Results page.

If you are using SAM on a Windows computer with the Residential, Commercial, or Single Owner financial model, you can click the "Send to Excel With Equations" button on the Cash Flow tab of the Results page to export financial model inputs to an Excel workbook that makes the same financial calculations as SAM. You could then change the currency in the workbook and create your report based on that data.

Best regards,
Paul.

Thanks for your reply, Paul.

On the similar lines, had another question. I wrote an LK script to out the parameters of my interest to a csv file. It works on a PC but on a Mac I get "Error 30 - Read only file system"

I am guessing I need to give SAM write privileges to disk. Now really sure how since it runs off an image in OS X.

Any advice?

Thanks,
Chetan.

Dear Chetan,
Here are a couple of things to try:
1. Make sure that the folder your script is writing to is one for which you have write permissions.
2. Move SAM.app from the disk image (.dmg) to the Applications folder, and run SAM from there.
If you are still having trouble, please feel free to [url=mailto:sam.support@nrel.gov?subject=LK%20script%20for%20OS%20X%20file%20write%20testing t=_self]email me[/url] your script for testing.
Best regards,

Paul.