Annual Energy Output for all years in VBA Code

Hi Soheb,

When you use SAM's Code Generator to generate VBA code (or code in any other language) it includes a few lines to display the values of some output variables as an example. It's up to you to write code to work with other output variables.

You could use the information in the cashflow.lk as a reference to write a VBA program to build your own cash flow table.

One way to identify the names of both input and output variables is to use SAM's LK script editor to list the variables. The variables browser shows both the variable label that you see in the user interface and the variable name. In SAM, on the File menu, click New script, and then click Variables at the top of the script editor window. For example, you could use it to find that "Electricity to grid" is year1_hourly_e_togrid:



Best regards,
Paul.

Hi Soheb,

SAM has a separate battery life model that calculates the degradation in battery capacity over time that accounts for number of charge/discharge cycles, depth of discharge, battery temperature, and battery age, so you do not need to specify a degradation rate input to account for the battery.

The "Battery relative capacity to nameplate" (batt_capacity_percent) variable indicates the battery degradation over time. Note that this is a time series variable with a value for each time step. If you include battery replacements in your analysis, the battery capacity is restored to its nameplate value when the battery is replaced.

The time series "Electricity to grid" and "Electricity to grid from battery" outputs are (year1_hourly_e_togrid and batt_to_grid, respectively).

One way to find the names of SSC variables is to first find them on the Data Tables tab in SAM, and then open a script editor and use the script editor's variable browser to match the SAM variable name to the SSC name:

1. Start SAM and open a file or create a new one.
2. On the File menu, click New script to open the script editor.
3. Click Variables in the menu bar at the top of the script editor.
4. In the Search box, type the name of the variable label as you see it in SAM (for example "Electricity to grid from battery").
5. Find the variable in the list -- variables are sorted by inputs and outputs and by type, and get the equivalent SSC Variable name (for example batt_to_grid).

Best regards,
Paul.

Hi Soheb,

Please attach image files to your posts instead of copying and pasting them into your message, or describe the results you are getting in words. As you can see, pasted images to not always render correctly.

Best regards,
Paul.