Errors in Community Solar Send to Excel spreadsheet

[brtietz]

This morning I was testing whether or not the use could change subscriber percentages in the spreadsheet, and came away with the following error:

Data validation for the Single Owner workbook value for target year was preserved in the Community Solar workbook. A workaround for now is to remove data validation from that cell in the community_solar.xlsx workbook in runtime/spreadsheets: Select Cell C34 and go to Data, Data Tools, Data Validation, and change Allow to “Any value”

It looks like there’s also a units error in D96 where the replacement reserve cost in $/W is multiplied by a number in kW.

Finally, the numbers in row 37 don’t add up properly due to a mix of percents and kW: (this is for a 1300 kWdc system)

If I change C37 to “=100-SUM(subscriber1_share,subscriber2_share,subscriber3_share,subscriber4_share)” it looks correct.