error on commercial.xls sheet ?

  • stef
  • Topic Author
  • New Member
  • New Member
More
06 Mar 2018 12:25 #6094 by stef
error on commercial.xls sheet ? was created by stef
Hello,
Thank you so much for your work. There isn't error on the D178 cell? it's compute white cell.

sam.nrel.gov/financial commercial .xls

regards
stef

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

  • Paul Gilman
  • Paul Gilman's Avatar
  • Platinum Member
  • Platinum Member
More
07 Mar 2018 00:12 #6095 by Paul Gilman
Replied by Paul Gilman on topic error on commercial.xls sheet ?
Dear Stef,

I agree with your observation. I'd have to trace through all of those formulas to see what is going on.

Those spreadsheets are old. If you are interested in SAM's Residential, Commercial, or Single Owner financial models, I would recommend generating an Excel workbook from the Cash Flow tab on the results page (click Send to Excel with Equations. That will generate a workbook with input variables populated from SAM with formulas that you can trace.

Unfortunately that feature is only available for Windows versions of SAM.

Best regards,
Paul.

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

  • Paul Gilman
  • Paul Gilman's Avatar
  • Platinum Member
  • Platinum Member
More
07 Mar 2018 00:12 #6096 by Paul Gilman
Replied by Paul Gilman on topic error on commercial.xls sheet ?
Dear Stef,

I agree with your observation. I'd have to trace through all of those formulas to see what is going on.

Those spreadsheets are old. If you are interested in SAM's Residential, Commercial, or Single Owner financial models, I would recommend generating an Excel workbook from the Cash Flow tab on the results page (click Send to Excel with Equations). That will generate a workbook with input variables populated from SAM with formulas that you can trace.

Unfortunately that feature is only available for Windows versions of SAM.

Best regards,
Paul.

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.