Excel Exchange

2 posts / 0 new
Last post
Bulk CSV Exports

I have a mess of projects I'm modeling. I would like to export the summary, monthly, and annual data tables to csv for all the projects in bulk. All in one go instead of going from project to project and exporting each one by hand. Is it possible to script this in SAM? In case anyone's curious, I'm working up evaluations for several parcels of land in a small city. I want to get this all into something like R or Excel. I'm using R to make some prettier plots than SAM can do. Excel makes it easier to format tables for insertion into a written report.

3 posts / 0 new
Last post
Sending Values from SAM to excel

I want to send a calculated value from SAM to an excel-workbook using an lk script, I'm running the script with no errors but nothing is changing in the excel workbook Book100, I tried the same script also for different workbooks and also it's not working. Can someone please help me with that. Thank you

The Script:

/set the current SAM case

//create an Excel object and open the Excel file
xl = xl_create('C:/Users/Admin/Desktop/SAM work/Book100.xls.xlsm');
path = path_only( project_file() );

2 posts / 0 new
Last post
Hourly excel exchange input?


2 posts / 0 new
Last post
How do I export SAM to Excel including formulae?

I want to see how LCOE is calculated in SAM. How do I export the formula to Excel?

1 post / 0 new
Paul Gilman
SAM at MREA Energy Fair 2016

If you are planning to attend the Midwest Renewable Energy Fair this year (June 17-19, 2016) in Central Wisconsin, I will be giving a three-hour workshop on SAM on Friday, June 17 from 10 am to 1 pm. The workshop is free, but you'll need a ticket to the fair to attend. (This is an in-person workshop, not a webinar.)

I hope to see you there! If you do plan to attend, be sure to bring your laptop with SAM installed and let me know what you are interested in learning about so I can prepare examples for a demonstration.


6 posts / 0 new
Last post
Calculation error and question


Hi, I noticed that in the Single Owner PPA model there is a reference name error (carefully read the named reference in Cell P:214 on the Cash Flow Tab, it's easily fixed).

Separately, the depreciation allocation is pulled from cell B:80. Is this correct? It doesn't seem like capital reserves should be counted as depreciable assets. I've changed the link to cell B:67, but please let me know if I'm on the wrong track.

thanks so much, Robert

3 posts / 0 new
Last post
LK Script to Exchange Data with Excel

Hi !

I am trying to use an LK script code to exchange data between excel and SAM (the idea is to pre-size my PV system with excel, export the main outputs data to SAM and use the simulation to asses my system.

I have issue on importing the load profile on SAM. I want to import the load hour by hour, for each hour of the year, in the Energy Usage data.

For that, I created the following loop which seems to be okay when I simulates :

for( i=5; i<8766; i++) {

Energy_usage[i-5]= xl_get(xl,index);


4 posts / 0 new
Last post
Exchange settings (file names and variables) get cleared after

Dear Paul,

I have successfully used the exchnage feature of SAM before for CSP models. Currently, I am trying to use it for PV models and it works fine till I save and close my SAM model. When I reopen the SAM file all the exchange settings, including file name and variables are cleared.
Can you please let me know what the issue is. I am using version 2015..06.30.

Also, I cannot locate user parameters (that existed previously) in this versio od SAM.

Thanks for your help,

8 posts / 0 new
Last post
Having trouble: 'Save as CSV' and 'Copy to clipboard' the Cash flow statements in OS X

Paul, good morning. I'm having issues Saving as CSV and Copying to clipboard the cash flow statements in the latest release of SAM for OS X. Can you tell me if you're seeing this as well? And if so, can you push out a fix for it? Thanks in advance, Brian S.

2 posts / 0 new
Last post
clacchini's picture
Does not accept new time series load data

I must input a new time series data for the city of Fortaleza in Brazil. I have converted the information retrieved from Energy Plus (8760 values) from Excel to tex values.
When I try to change the energy usage data and import the new text file, I receive a message saying that the time serie is incomplete (only 765 found) and the electric load is not updated.
I am working with the SAM 2015.6.30 on a MAC OS X 10.10.4.
I am adding the txt file with the demand time series.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer