Export to Excel, Flat Plate PV

I created files in the Flate Plate PV, Commercial PPA model and executed Send to Excel with Equations. The resulting spreadsheet has a slightly lower energy output in year 1 than the SAM model result. In the spreadsheet, the year 1 degradation in cell D8 = 1 - Degradation, but in the SAM model output the Degradation factor is not applied to the Annual Energy in year 1.

Dear Tom,

It looks like the logic of the IF statement in the Cell D8 formula is incorrect.

The incorrect formula is:
=IF(ISNUMBER(outYear),IF(outYear>1,(1-inDegradation)^(outYear-1),1-inDegradation),"")

The correct formula is:
=IF(ISNUMBER(outYear),IF(outYear>1,1-inDegradation,(1-inDegradation)^(outYear-1)),"")

You should at least replace the formula in Cell D8, but to be more complete, you should replace Cells D8:CY8.

Best regards,
Paul.