[1217topher]

I have been working on this excel spreadsheet for some while. I borrowed the basics from Shanabme from an earlier posting and then made quite a few tweaks to help me calculate fillers and taxes.

There are two spreadsheets. One calculates taxes after coupons, the other before coupons.

Input cells are in blue.

Please be free to download, tweak, and use as you like. If you find an error, please let me know.

[kmeiding]

Hey that's fancy! Looks useful. Almost seems easier for me to do it in my head and on paper though. I'm sure there are many people here who will get good use from it.

[Barbara34]

Originally Posted by 1217topher

I have been working on this excel spreadsheet for some while. I borrowed the basics from another member on this forum, sorry forgot the name

The filler calculation area is still a little confusing. It has to count the number of coupons being redeemed as well as the value. If someone is good with advanced excel function formulas, I think an if/then function with conditional rounding might work. But can't seem to figure out how.

Input cells are in blue.

Please be free to download, tweak, and use as you like.

Ooooh, looks so nice. I saved it, then made a copy for me to horse around with. I can't wait to dig in. I've been playing around with one, but it isn't nearly as complete as this one. I don't know how it could be improved, because it looks really good to me, but if there are tweaks to it, I'll watch for them, too. Thank you for the effort you put into this.

[Barbara34]

Originally Posted by kmeiding

Hey that's fancy! Looks useful. Almost seems easier for me to do it in my head and on paper though. I'm sure there are many people here who will get good use from it.

Do it in my head? I only wish!!!!! I can barely do it when I use a spread sheet, and then I often mess up. I used to think I had a fair amount of intelligence, but when it comes to WAGS and their RRs, I think I joined the imbecile class.

[Lynda1811]

WOW Now that is awesome. I will have to save it.

Lynda

[joyagain]

This looks really great. Why hadn't I ever thought of that. ..

Theresa

[cindia86]

thanks

[1217topher]

Revised the spreadsheet to help make the filler calculation area a little easier to use

[akiceman]

I just wrote a simple one yesterday. This makes mine look so sad! Thanks 1217topher's!

[jeanettebr]

wow...very neat! Kinda hard for me to use though...I get taxed AFTER coupons etc....but awesome spreadsheet! thanks

[1217topher]

Originally Posted by jeanettebr

wow...very neat! Kinda hard for me to use though...I get taxed AFTER coupons etc....but awesome spreadsheet! thanks

Taxed after coupons!! That would be awesome. Would save some major OOP that way. Let me play with the sheet. I think the changes are minimal.

[jeanettebr]

thanks!

[vaneska]

this help me a lot with the taxes THANKS!!

[1217topher]

Originally Posted by jeanettebr

wow...very neat! Kinda hard for me to use though...I get taxed AFTER coupons etc....but awesome spreadsheet! thanks

I have another version of the spreadsheet to calculate after taxes. But I am not sure how to handle taxes with the RR. Does the tax get calulated before or after RR are used? Lets say you buy something for $2. You use a $1mq. This would leave you with a subtotal of $1. You then use a $1 RR to pay. Do you pay taxes on the $1 before RR? Or do you pay taxes on zero after the RR? Which basically means no taxes? If you are really walking out of the store with somethings for FREE, then I am moving to your neighborhood

[jeanettebr]

our taxes are after Q's and RR I just looked at an old receipt and I bought over $30 worth of items and paid 12 cents tax after Q's and RR....our sales tax rate for this WAGS was 8.475% so not sure how I managed that.
I have yet to walk out with zero OOP but I have been close

[1217topher]

Ok. We are now up to version 5. Now have two spreadsheets, one calculates taxes before coupons and the other calculates taxes after coupons.

[jeanettebr]

thanks

[1217topher]

Version 6 now up. Darn bugs!!

[gidget0949]

wow thanks for all of the effort you spent in creating this and then the willingness to share

[pjwalz]

This looks great, can't wait to give it a try!!! Thanks!

[coley31]

This is great! Im always looking for an excuse to use a spread sheet!

[TheSoCalMom]

Waaaaay over my head. I am hoping to find someone more technical to help me understand it.

Good ole' pen and paper work for me now.

Oh how I want to use this!

THANK YOU SO MUCH FOR SHARING!

[bigshirley]

thanks!

[kaleidoscopegirl]

ack! I can't believe that I don't have excel on my computer at home! I have to wait until tuesday when I go back to work to see this! Its killing me! May have to stop by office and play with this tomorrow! Thanks so much!!

[VivLyn]

Originally Posted by Barbara34

Do it in my head? I only wish!!!!! I can barely do it when I use a spread sheet, and then I often mess up. I used to think I had a fair amount of intelligence, but when it comes to WAGS and their RRs, I think I joined the imbecile class.

I haven't even tried to do WAGS yet...scared! I think I will fit in the imbecile class. I do like the spreadsheets though and saved them. Maybe I'll getto use them someday.