[BigJimSlade]

Hi iisrosered,

The fields that are not supposed to be changed should be protected to help the new users from making mistakes. If you wish to remove the protection, you can do so from the file menu at the top of the screen. Assuming you do not have Vista which is different from all the other versions, go to Tools, Protection, Unprotect Sheet in the menu bar at the top. There is no password, so the protection should discontinue at that point. Then you can do anything you want with the spreadsheet.

Let me know if that was not the problem. Thanks!

[shellyandrade]

Hi Jim - Awesome job on your spreadsheet! I'm new to all this "coupon stuff" but not to Excel - actually go back to the dos days - yikes, I'm old. Anyway - is there a reason why the coupon count isn't multiplying across to the final cost columns? For instance, if I'm buying two razors at 7.99 and I have two $3 coupons, it's not calculating off the $6 in the final cost columns. I don't know - maybe I need another cup of coffee; am I missing something?

[BigJimSlade]

Hi shelly!

The reason it is not calculating $6 is twofold:

1) Sometimes people have coupons of different values for the same product. It would be difficult to enter this if the count of coupons was multiplied by the coupon(s) value.

2) The coupon count itself is actually there to count the total number of coupons because, last time I checked, CVS cash registers will error if you have more coupons than items. In an effort to prevent a slowdown at the register, this allows the user to see if they could toss in another item.

Hope that helps!

Thanks,

Big Jim

[aberzinski]

Here is an awesome spreadsheet I got from someone and modified it a little. It calculates the OOP not including tax. It gives you a good estimate of what you will spend.
Not sure if the attachment worked, let me see.

[loral]

Awesome. This will help allot.
Good find!

[dianneproctor]

Thats great deal thanks for letting us know

[lifeworthliving]

Just can't tell you how much I love this program. Got my black Friday ready and perfectly figured out. Thank you a million times!

[michmedic]

OMG, me too! i just found it and you would think I just won the lottery or something! HAHA!
THANKS SO MUCH!

[boygirlboygirl]

I've been hanging out around here for about a month and have loved the deal ideas, but my OOP has been way too high at the register. I am so gonna love this calculator!

My thank you's many times over!!

[bedinky1207]

Bumping this for someone...I believe this is what you were asking for.

[HappyGal]

bumping for VJ...hahah bedinky got it too!

[Keri]

for taking the time to do this and sharing it!!

[Keri]

Now we need to talk you into making a sheet for Walgreens. I'll send you some coupons!

[lgoodwin]

I just can't use spreadsheets, It's like a foreign language....
I wish there was a SIMPLE printable spreadsheet for dummys!!
I usually write mine out in columns, but can't create anything on the computer...

[lgoodwin]

oops those doubles...

[TheSoCalMom]

i can't for the life of me figure this spreadsheet out...i am not really excel savvy

[mskayjay]

It won't open on my computer! Help please!

[my4psinapod]

I am so fustrated! I clicked on her link but my stupid puter won't let me see it. It keeps asking me for a microsoft registration code to get in to the program . Supposedly the authinticity code or some caca mimi stuff. Can some one please help me I want to see it, I need to see it, I have to see it. Can some one PM me a copy or I'll give you my private email to send me a scan. YES I am desprate for savings! THANKS!!!

[warenas]

I'll try it... thanks!

[healthysaver]

This program sounds like a great idea. However how are you all using it? Do you all input your item info, print it out and bring it to the store? What if the number of items planned to buy are not in stock or you find some other deals there? Do you just manually calculate the figures at the store? I take way too much time at the store trying to figure out the least amount oop and it is very hard with 2 squirming kids (and being preggo!) which is why I've been going to the store at night recently (but this won't happen for long since I'm due in 2 month)... I would love to figure out a way to pre-calculate this stuff so I don't have to at the store.

[genosgirl]

Originally Posted by healthysaver

This program sounds like a great idea. However how are you all using it? Do you all input your item info, print it out and bring it to the store? What if the number of items planned to buy are not in stock or you find some other deals there? Do you just manually calculate the figures at the store? I take way too much time at the store trying to figure out the least amount oop and it is very hard with 2 squirming kids (and being preggo!) which is why I've been going to the store at night recently (but this won't happen for long since I'm due in 2 month)... I would love to figure out a way to pre-calculate this stuff so I don't have to at the store.

I sometimes plan it out ahead of time in the spreadsheet. I export it from my pc to my blackberry and can either create or modify it on the fly if they are out of something in my original plan.

[aaronalita]

How do you input BOGO 50% off or BOGO free? Just wondering. Thanks for the help.

[someone]

wow! you just made my job easier, thank!

[Jackitty]

I can't express enough thanks to your spreadsheet. It makes things soooo much easier!

[melindagail]

Thank you so much! This is a great tool!