Thanks very much to YvesJ for building such a great spreadsheet and Jwocky for posting it here. YvesJ, I love the layout and formatting you've done. Super job!
For US buyers using the spreadsheet, please do not forget to add in the $695 Delivery and Handling charge into your calculations, because the version posted does not add this fee. I believe the $695 charge is a taxable item, so I built it into the base price in cells 'L3' and 'M3'. You can just tack on a "+695" to the formulas in those cells, or if you want to keep it in a similar fashion the rest of the spreadsheet, you can add "+INDIRECT("'(Invoice)'!"&$B$1&"35")" to the end of each formula in cells 'L3' and 'M3'.
So for example, the updated formula for cell 'L3' would read "=INDIRECT("'(Invoice)'!"&$B$1&"4")+INDIRECT("'(In voice)'!"&$B$1&"35")" if you wanted to add in the delivery and handling charge.
|