- 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.
- Paul Gilman
        Less
        More
        
            
    
        - Posts: 5665
            
        
                13 May 2013 17:21                #1610
        by Paul Gilman
    
    
            
            
            
            
            
                                
    
                                                
    
        Replied by Paul Gilman 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.
- Paul Gilman
        Less
        More
        
            
    
        - Posts: 5665
            
        
                14 May 2013 09:07                #1612
        by Paul Gilman
    
    
            
            
            
            
            
                                
    
                                                
    
        Replied by Paul Gilman 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: Paul Gilman    
 
  
 















