Quote:
Originally Posted by melanemac  Hey BigJim-
I took a look and I have an older version of yours...so in mine the ECB's were before the coupon totals. I see in the new version, that isn't the case. I do however like to add each of my ECB's on a separate line so that as my "shopping list" I know which ones to use. I also have a tax field, because I do like to at least have an estimate of what my tax will be. I just have a field with the tax percent and it calculates based on that. Does that make sense? | Hi Melanemac,
The concepts are good. Tax is a messy issue. We would have to provide a field for the user to enter their state/local sales tax. The real tricky part is that so many things in a drug store are not taxed (at least last time I checked). I could set it up so that each individual item entered in the spreadsheet has an option of being taxed, but I am not sure if most people want to micro-manage their purchases to that degree. The current setup guarantees that any ECB applied will be used in-whole as there will always be some tax to add on to whatever final total is calculated.
As for adding the ECBs on separate lines, that is also an understandable idea. Currently, we are forced to do the math ourselves to see which combination of ECBs to use during a given transaction.
There is a good chance I can try to incorporate the separate lines for ECBs in an upcoming version. Checking off which line items should be taxed would increase the width of the already wide spreadsheet. As most people would probably not think to print in "landscape", I am trying to avoid this unless it would be of extreme value to everyone using the spreadsheet. I would like to hear from others if "tax" is something they really would like to see here.
In the meantime, that is why the spreadsheet is available on AFC, so that anyone can make the personal changes they would like to see and use. I guess we all are a little different. 
Thanks for the great and reasonable ideas,
Big Jim
 |