Exporting Graph and Table Data

ICON_Under-Construction

This topic describes SAM 3.0 and has not been revised for SAM 2009 Beta.

You may find useful information, especially if you are new to SAM, but some of the information may be inconsistent with the new version.

Solar Advisor allows you to export the data represented in graphs and shown in tables on the Results Summary page. You can export the data to a comma separated text file recognized by Excel and other software. You can also export the data in text or .xml format using the advanced properties feature.

To export graph data to a comma-separated file:

1.	Display the graph on the Results Summary page.

2.	Click Send to Excel. Solar Advisor displays the graph data in Excel.

3.	Solar Advisor creates a comma-separated file in the folder containing the Solar Advisor file and names it after the graph. For example, it creates the file Cost stacked bar.csv when you export the Cost stacked bar graph.

Note. Each time you click Send to Excel for a graph, Solar Advisor creates a new Excel file in the Solar Advisor temporary folder (C:\SAM\Temporary by default). If a csv file already exists with the graph name, Solar Advisor appends (n) to the filename, incrementing n for each version of the file with the same graph name. When you close Solar Advisor, it deletes all files in the temporary folder. If you want to save the workbook, save it to a location other than the temporary folder.

To export table data:

1.	Display the table on the Results Summary page.

2.	Right-click the graph and click Copy on the shortcut menu.

3.	Open a text file, word-processing document or spreadsheet and paste the table data.

Advanced - To export graph data to a text, xml, or html file:

1.	Display the graph on the Results Summary page.

2.	Right-click the graph and click Advanced Properties on the shortcut menu.

3.	In the chart editing window, click Export in the navigation tree.

4.	On the Data tab, make the appropriate selections and click Copy, Save, or Send.