SAM (Send to Excel with Equations)

  • mharnedy
  • Topic Author
More
27 Sep 2013 22: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.

  • Paul Gilman
More
30 Sep 2013 15:24 #1841 by Paul Gilman
Replied by Paul Gilman 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: Paul Gilman
Powered by Kunena Forum

NREL is a national laboratory of the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, operated by the Alliance for Sustainable Energy, LLC.

NREL Home

NREL Research

Follow NREL

NREL is a national laboratory of the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, operated by the Alliance for Sustainable Energy, LLC.