Describe the bug

We noted a difference in the LCOE real as reported in the Summary tab compared to the cash flow workbook created with 'send to Excel with equations'. The values are equivalent when modelling PV only, but when modelling Storage only or PV + Storage, the discrepancy occurs. For our PV + Storage model, the Summary report shows a real LCOE is 16.91 R / kWh. In the excel workbook, the real LCOE is R 2.86. When I model the PV only system with a higher installation cost that matches the cost of the PV + Storage, the real LCOE is 2.53 R/kWh in both the summary report and the excel workbook. The 16.91 R / kWh seems much too high for the PV + storage.

To Reproduce

Steps to reproduce the behavior:

1. Create a 'PV-Battery, Commercial' model
2. Simulate
3. Note the real LCOE on the Summary Tab
4. Click on the 'Cash Flow' tab
5. 'Send to Excel with equations'
6. Note the real LCOE on the 'Inputs and Outputs' tab

Expected behavior

I expect the reported real LCOE to be similar, maybe with 5% due to the limited functionality of the excel workbook model, not 5x or so as noted.

Screenshots

See attachments. Note the values are in Rand-cents, not USD-cents

Operating System and Version

• OS: Windows 10 Enterprise, version 10.0.19045 19045
• SAM Version 2022.11.21, 64 bit, updated to revision 1

Additional context

20230510 S8_pv_storage.xlsx

I attached the summary report and the excel workbook for the PV + storage project.