SAM (Send to Excel with Equations)

mharnedy
Topic Author

27 Sep 2013 16:37 #1840 by mharnedy

SAM (Send to Excel with Equations) was created by mharnedy

When I export my SAM case to Excel with equations I get #NAME? errors starting with Col D92 State Tax Savings and repeated throughout various Payback expenses included and excluded columns. See attached file for an example. Any ideas as to how to resolve this?

Please Log in or Create an account to join the conversation.

pgilman

30 Sep 2013 09:24 #1841 by pgilman

Replied by pgilman on topic SAM (Send to Excel with Equations)

Hello,

There is a typo in the Cell B51 formula. The incorrect formula is:

=IF(inStateITCPercent/100*inTotalInstalledCosts

Please Log in or Create an account to join the conversation.

Moderators: pgilman