Error in transfer of sales tax in "Send to Excel with equations"?

  • mark.norman
  • Topic Author
More
12 May 2013 13:22 #1609 by mark.norman
Hi
Good work with the feature "Send to excel with equations". I may have found a very small transposition error.
With a commercial PV system, in the excel file - table "Values from SAM input pages (ok to change values in white cells)" the sales tax % seems to be the $ value of sales tax rather than the %.
Hope this helps
Mark
Image attached

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

  • Paul Gilman
More
13 May 2013 23:21 #1610 by Paul Gilman
Dear Mark,

Thank you for pointing that out. We will fix that for the next release, sometime later in 2013.

Best regards,
Paul.

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

  • mark.norman
  • Topic Author
More
14 May 2013 04:30 #1611 by mark.norman
Hi Paul
No worries - also just noticed Graph with label "After Tax Cash Flow" is picking up "After Tax Net Equity Cost Flow", out by one line in the excel file. Should be
=SERIES('Base Case Cash Flow'!$C$6:$AG$6,'Base Case Cash Flow'!$C$6:$AG$6,'Base Case Cash Flow'!$C$103:$AG$103,1)

not

=SERIES('Base Case Cash Flow'!$C$6:$AG$6,'Base Case Cash Flow'!$C$6:$AG$6,'Base Case Cash Flow'!$C$102:$AG$102,1)

Might be better to have relative rather than absolute referencing, so when new lines added/removed, graph reference adjusts

Hope this helps

Regards Mark

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

  • Paul Gilman
More
14 May 2013 15:07 #1612 by Paul Gilman
Thank you Mark. I will add that to the To Do list for the Excel export function. Please let us know if you notice other problems or have more suggestions!

Best regards,
Paul.

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

Moderators: Paul Gilman
Powered by Kunena Forum