Excel Exchange

ICON_Under-Construction

This topic is under construction.

If you have questions about this topic, please contact user support:
solar.advisor.support@nrel.gov.

Solar Advisor allows you to connect any input variable in Solar Advisor to a cell or range of cells in a Microsoft Excel workbook. This feature allows you to use external spreadsheet-based cost and performance models to generate values for Solar Advisor input variables. Because Solar Advisor can both import values from workbooks and export values to them, you can use the result of a spreadsheet calculation as the value of one input variable that depends on the value of other input variables. User variables are user-defined input variables that can also share values with external workbooks.

For an example of a Solar Advisor file with Excel Exchange, open the sample template Excel Sample: On the File menu, click Open Sample Template and select the template from the list.

To display the Excel data exchange setup options:

1.	On the Main window, click Configure Simulations to view the Configure Simulation page.

2.	On the Configure Simulations page, click Excel Exchange to display the Excel data exchange options.

SS_ConfigureSimulations-ExcelExchangeClick

Contents

►	Page Reference describes the Excel data exchange setup options.

►	Setting up Excel Exchange describes the steps for connecting input variables to Excel cells and ranges.

Page Reference

The Excel Data Exchange options allow you to add and remove Solar Advisor input variables to the list of variables to exchange data with Excel, specify the Excel workbook with which to exchange data, and for each input variable, define the relationship with a cell or range of cells in the workbook.

SS_ExcelExchange-Overview

Parametric Simulation Setup

Add	Add one or more input variable from the input pages. You can configure each variable to either send a value to an Excel range, or "capture" a value from an Excel range.
Remove	Delete the highlighted variable from the list.
Clear All	Delete all variables from the list.
Browse	Browse your computer's folders to find the Excel workbook with which you want to exchange data. The workbook can be located in any folder on your computer.
Apply for all variables
Send Variable Value to Excel Range	Configure the highlighted variable to send its value to the specified Excel range.
Capture Variable Value From Excel Range	Configure the highlighted variable to capture its value from the specified Excel range.
Excel Range	The range name or cell reference identifying the cell or range of cells in the Excel workbook with which the highlighted variable will exchange data.
Enable this simulation	This box must be checked for the analysis to exchange data with Excel.

Setting up Excel Exchange