D. Define the Sent To Variables

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.

To define the Sent To variables (export values to an external spreadsheet from Solar Advisor):

1.	On the Residential case's Array page, right-click Array Power to open the Sent To window.

2.	Under Sent To, select the workbook User Guide Workbook Example.xls, and select the Named Range Array_Power.

3.	Click OK to return to the Array page.

4.	Use the same procedure on the Costs page to define Total Installed Costs as a Sent To variable for the workbook's Installed_Costs named range.

Tip. You can send the value of a single Solar Advisor input variable to more than one cell in either a single workbook or different workbooks. To send the value to additional cells, add a row for each cell to the table in the Sent To window and select the workbook name and named range.

5.	Click OK to return to the main window.

6.	On the View menu, click SentTo variables and CapturedFrom variables to display lists of the variables that are connected to the workbook.

7.	You can double click a variable name in either the SentTo or CapturedFrom window to open the page that contains the variable.

You have now defined a set of variables that interact with the Excel workbook. When you change a variable's value in Solar Advisor that affects one of the Sent To variable's values or change the value of the UDV and click the Run button, Solar Advisor recalculates the value of the O&M variable Fixed (per capacity) and displays it on the Costs page.

9.	On the Costs page, type "2" for the UDV OM per Installed Cost. Solar Advisor uses the spreadsheet to recalculate the value of Fixed (per capacity). You may need to switch to a different page, for example the BOS page, and then switch back to the cost page to see the recalculated value.