 |
 | 
12-12-2007, 04:13 PM
|  |
| |||
 CVS Coupon Calculator Hi, Big Jim here: I would like to offer everyone this spreadsheet for calculating how much you will be spending with all of your coupons/EB. Not only does this tell you how much you will spend, but it tells you how much you will save in Extra Bucks as well as if your total purchase goes negative or you do not have enough coupons to cover your total item count. It is an Excel Spreadsheet. If you do not have Excel and would still like to use this, you can download openoffice.org for free and run spreadsheets using their calc application - OpenOffice.org: Home Feel free to make changes and do whatever to it. It took about 20 minutes to put together, so it may need them. Let me know what you think. You can also suggest your changes be added to a later version at the top of this thread if they are popular enough. All ideas are good ideas. Big Jim (glad to finally participate and offer something for all you guys have offered me) Updated 12/14/07 - Formula was incorrect for comparing coupons/items. Fixed! Updated 02/05/08 - Removed version 1.02 and replaced with 1.01. Version was causing confusion concerning coupons. Updated 04/08/08 - Sleeker look for version 1.06. Blatant use as a stacking tool removed due to lack of available coupons (those CVS guys caught on!!). Updated 04/10/08 - Removed Profit concept. Also adjusted how coupon totals for each row are calculated Updated 04/12/08 - Added unit and total cost fields for each row item Last edited by queenbear; 07-09-2008 at 07:01 PM.   |
| The Following 126 Users Say Thank You to BigJimSlade For This Useful Post: | ||
*monkey's_mama* (01-25-2008), 2callmemommy (08-29-2008), A20SomethingMother (01-09-2008), AAKCS (07-06-2008), aariell (03-25-2008), aberzinski (04-09-2008), alexasias (01-17-2008), ambam (12-14-2007), angel nee nee (02-01-2008), angelger28 (06-14-2008), anneh (05-21-2008), arizonah13 (04-05-2008), Ashley_EMCBTS (05-27-2008), austinsmommy (04-28-2008), babybenzmom (08-14-2008), ban26ana (07-18-2008), bclarkcaldwell (12-12-2007), betsyd (01-09-2008), brios86 (03-13-2008), brownquatro (08-26-2008), ButtonsMama (12-13-2007), CARRIEMB2 (04-20-2008), catsan500 (12-14-2007), ccd2u (04-09-2008), cjhar99 (01-30-2008), Clyde's Mom (07-02-2008), cmb6k (04-08-2008), cocoadiva43 (03-27-2008), coffelover (02-12-2008), couponfreak (05-24-2008), coupons_r_cool (06-12-2008), craftylildevil (09-02-2008), curlyd1239 (05-31-2008), cwaltz (12-12-2007), cwidener (04-12-2008), daliadoll (12-13-2007), darlingsta (01-09-2008), DawnG (03-18-2008), deecar02 (05-21-2008), dizzyvizzy (01-29-2008), drake-partyof6 (12-17-2007), dsrajji@yahoo.com (12-18-2007), erinlooneybin (01-26-2008), florida_mommy (02-07-2008), GrannyGodley (12-13-2007), houndthorn (08-07-2008), irismania (03-16-2008), jbo711 (12-14-2007), jeanleona (07-11-2008), jmgconner (12-12-2007), JRA191 (03-27-2008), JSIllinois (07-06-2008), Katie0409 (07-07-2008), Kimi in MD (12-17-2007), kimmieg (01-09-2008), klrodrigues (04-10-2008), ladyred71 (01-07-2008), LCrenny (02-04-2008), Lette (12-13-2007), lifeworthliving (12-16-2007), lizmolik (04-12-2008), lm5385 (05-23-2008), lmilla (02-17-2008), lochelle (12-14-2007), loganzmama (03-26-2008), lolobean (03-04-2008), luvadeal (02-04-2008), M&M's Mom (04-27-2008), mabagnoli (04-13-2008), maxndeals (07-01-2008), melinnc (12-19-2007), mfostertx (12-13-2007), militarymommy (03-29-2008), mimi73 (04-05-2008), missyo (12-13-2007), mjfenton3 (07-01-2008), Mom2Four (12-14-2007), mommyhope (06-12-2008), Momtoabunch (05-27-2008), monica (12-12-2007), mpayne (12-14-2007), mrj0308 (04-10-2008), mrsfloyd (01-04-2008), mstreff (05-28-2008), mtkanicholson (06-12-2008), mvonnesha (07-25-2008), mysterylover (12-13-2007), NoiseFreeLakeland (03-23-2008), p00h717 (07-28-2008), paarkhi (04-18-2008), pamb (04-11-2008), piglet05 (12-20-2007), pollyanna (04-07-2008), prayforlife247 (07-08-2008), rkwells (01-19-2008), roygbiv (05-21-2008), ru.bu. (01-06-2008), Rzachary (12-12-2007), savenicky (12-13-2007), savingsqueen (12-13-2007), Scarlett (04-09-2008), schatz (07-06-2008), scmommy (04-09-2008), scraphappygirl (01-08-2008), shanmarie (12-12-2007), shauna779 (04-11-2008), SheenaMarie412 (07-12-2008), Shesheroy (12-16-2007), Sienna'sMaMa (04-13-2008), sjchristian (04-10-2008), slkawsarani (01-05-2008), stampinonthefarm (07-06-2008), susan_t6 (02-17-2008), tam-I-am (07-22-2008), Tdugdell (01-12-2008), theirfavoritemommy (08-05-2008), therbel (12-12-2007), tmatson (01-14-2008), twilson79 (12-14-2007), TylerK612 (06-09-2008), VJMinistries (05-27-2008), waterfalls123 (08-03-2008), WishfulThinking (02-02-2008), youngnos (07-08-2008), zenfire (01-06-2008), zigaggie (06-14-2008) | ||
|
12-12-2007, 04:14 PM
| |
| |||
| Perhaps everyone can fill it out with their own deals and repost it so the rest of us can just print out the spreadsheet and take it to our local stacking CVS store.  |
| The Following User Says Thank You to BigJimSlade For This Useful Post: | ||
melinnc (12-19-2007) | ||
|
12-12-2007, 05:06 PM
| |
| |||
| I will try this in a bit and see how it works for me. It seems that my "ciphering" on my calculator and notepad gets me in trouble sometimes Thanks for putting this together! |
|
12-12-2007, 06:09 PM
| |
| |||
 WOW! Impressive spreadsheet! Thanks BigJim  |
|
12-12-2007, 07:22 PM
| |
| |||
| Quote:
Thanks, Jim! |
|
12-12-2007, 07:38 PM
| |
| |||
| And to think I just do it in my head! I total my cart ~ count items I total my coupons ~ count discounts/coupons I figure out what the difference is and check to see that I have a ECB close to that amount. Then I count the ECB dollars I will earn with items in the cart just to ball-park wether I am gaining or loosing ECB's. But I will try the spreadsheet... |
| The Following User Says Thank You to mjloves2shop For This Useful Post: | ||
GrannyGodley (12-13-2007) | ||
|
12-12-2007, 07:39 PM
| |
| |||
| Incredible!!! This will save so much time! |
|
12-12-2007, 10:28 PM
| |
| |||
| Thank you Thank you Thank you!!!! I love it! I am spread sheet challenged when it comes to making them, but this is awesome. I cannot wait to go shopping, well, in a few hours! |
|
12-13-2007, 07:04 AM
| |
| |||
| [quote=mjloves2shop;253704]And to think I just do it in my head!...] Me too, but I have to start over every 20 seconds after telling my 2 year old to stop banging on something (every CVS item is a drum to him) or stop opeining every bottle on the shelf to smell it's contents, or after telling my 5 year old to stop whining, or to tell them both to stop running around and crashing down on the floor laughing for no reason, etc. (And then they complain that it is "taking too long for me to think..)! My 2 and 4 year old boys thank you Big Jim, as well as the other CVS customers in the store with us, and expecially CVS employees who have to put up with us! |
| The Following 2 Users Say Thank You to missyo For This Useful Post: | ||
Kimi in MD (12-17-2007), ladyred71 (01-07-2008) | ||
|
12-13-2007, 03:42 PM
| |
| |||
| I do a little spreadsheet, but not on your level. I will have to study your formulas since I have been wanting to learn how to do these "if" functions. Pretty nice tool. ThanksIt will help if others who use it will post their deals so we can get a more detailed heads up. I"m kind of like mjlove... I count, add, sort, and hope as I go to the register. Best plan I have had lately has been to put coupons for each item together, i.e. buying toothpaste? have a cvs coup and a manf coup - fold them together. That has helped me not to forget to use one. Sometimes it is hard to do the deals if you have a fuzzy brain or a migraine - or as you younger ladies and chaps - a cart full of kids. Last edited by GrannyGodley; 12-13-2007 at 03:45 PM. |
|
12-13-2007, 04:14 PM
| |
| |||
| I agree, GG, it would be great to see everyone else's deals. I left mine in there from this week (still valid through 12/15/07). I'll post my deals next week as another example, but I think there are other people in here who would fill it out much better than I. I've had a recommendation come in already for an update from an intelligent member. She suggested that the total coupon count is not always what flags the register but that it could be the total CVS coupon count (so no manufacturer coupons) which must not exceed the total item count. Anyone else notice this? I could add another field to the spreadsheet to compare both coupon totals so that you don't have to look up and over to where the different coupon categories are summed up. Big Jim |
|
12-13-2007, 05:39 PM
| |
| |||
| Just wanted to shout out again!!!! I had everything ready today when I got to the store. I printed out each transaction and had all of my coupons put together for each one. I did my first 2 transactions in about 5 minutes and then was able to 2 two more in about 10 more. I had 2 more as back up but had to change a few things around. Finally , I had to do one in my head because I found something that I just "had" to buy today! |
|
12-13-2007, 08:15 PM
| |
| |||
 figuring up the count BigJim - I don't understand the CVS coupon count thing. I thought it was a count of items vs count of any coupons. That means CVS coupons, ECB, and manufacturers. So if you have 3 each of these (9) and you have 10 products you are good to go. But if you have 9 of these and you have 8 products you have to grab a pack of gum or something. Then there is the version that ECB do not count in the coupon count - only manufacturers coupons and CVS coupons. I assume by CVS coupons it means any coupon from an email or online as well as a coupon for $_XX off a certain product that prints on the register tape.  So what was the take on what constitutes a CVS coupon by the other member? They are all so savvy on CVS procedures that I bow to their knowledge. |
|
12-13-2007, 09:03 PM
| |
| |||
| Hi GG, The other member suggested the following about coupon count: In some CVS's they say the item count only has to be greater than the CVS coupons used... In my area i have to have more items than ALL my coupons, but when I have posted some have said they are getting away as long as item count is greater than CVS coupons.. So maybe a column that checks that As far as I know, I have never run into this before. I have always had to have at least a 1:1 ratio of items to all coupons. I left ECB out of the spreadsheet as I did not think the 1:1 ratio is effected by them. They're not considered coupons, right? |
|
12-13-2007, 09:52 PM
| |
| |||
| Quote:
|