- Posts: 26
Error in transfer of sales tax in "Send to Excel with equations"?
- mark.norman
- Topic Author
Less
More
12 May 2013 07:22 #1609
by mark.norman
Error in transfer of sales tax in "Send to Excel with equations"? was created 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
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.
- pgilman
Less
More
- Posts: 5423
13 May 2013 17:21 #1610
by pgilman
Replied by pgilman on topic Error in transfer of sales tax in "Send to Excel with equations"?
Dear Mark,
Thank you for pointing that out. We will fix that for the next release, sometime later in 2013.
Best regards,
Paul.
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
Less
More
- Posts: 26
13 May 2013 22:30 #1611
by mark.norman
Replied by mark.norman on topic Error in transfer of sales tax in "Send to Excel with equations"?
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
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.
- pgilman
Less
More
- Posts: 5423
14 May 2013 09:07 #1612
by pgilman
Replied by pgilman on topic Error in transfer of sales tax in "Send to Excel with equations"?
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.
Best regards,
Paul.
Please Log in or Create an account to join the conversation.
Moderators: pgilman