Jun
30

Coupon Savings Calculator

by Carrie on June 30, 2011

We are so lucky! Kelley Redmond created a coupon savings calculator just for Coupon Closet readers. If you have been curious how you are doing on your grocery bill, you don’t have to anymore. You will now know! It is a very simple calculator which will allow you to enter your shopping trips from up to 4 stores. On the main page, it will automatically give you all your totals from your 4 stores so you will always know how you are doing on your budget.

Go here to download the Coupon Closet’s Savings Calculator. You will need Microsoft Excel to use the program. If you are good at excel then you are ready to get started. I

would go ahead and get it downloaded. Save your receipts and stay tuned. Over this weekend, I make a video to help you use your new calculator. Once again, thank you Kelley for creating this awesome feature for Coupon Closet readers.

Share with your friends on Facebook Tweet your friends on Twitter Share with your linkedin groups Email Your Friends Pin It Print Me

{ 35 comments… read them below or add one }

Amber M June 30, 2011 at 8:31 PM

I just opened the calculator and it is AMAZING!!!!! Thanks Kelley for putting that together!!!

Reply

Liz June 30, 2011 at 9:19 PM

THIS IS SO AWESOME! Much better system than me saving all my receipts in an overstuffed folder in my box. My favorite part is it does all my math for me. Thank you so much Kelly!

Reply

David June 30, 2011 at 9:56 PM

Pretty cool spreadsheet. I put my receipts from last week in and it shows I had an 88% savings. Can’t wait to get a full months worth of data into it. How do you get rid of the picture in cell B13 on the store1 tab. It doesn’t affect anything but I can’t delete it.

Reply

Lauren June 30, 2011 at 10:04 PM

Im having a hard time with this. When I click the link a window opens up that wants me to open or save the file. I have tried both and neither will let me pull it up. I cant even find it on the computer anywhere. What am I doing wrong? I have Microsoft Exel, so why cant I find this?! lol

Reply

Lauren June 30, 2011 at 10:07 PM

Its saying that its a “zipped folder”, what does that mean?

Reply

Kerry June 30, 2011 at 10:32 PM

I having trouble, too….lots of files with XML extention, but no excel files

Reply

Angie July 1, 2011 at 12:59 AM

I’m having trouble as well. I have Excel, I tried both saving the zipped file and just opening it rather than saving it. I can find it saved on my computer but everything I go to open takes me to an internet page full of codes and it doesn’t open to excel :(

Reply

Liz July 1, 2011 at 8:27 AM

What version of Excel do you have? Is it one of the older programs? I have 2010 and it downloaded it fine.

Reply

Lauren July 1, 2011 at 9:52 AM

I have im guessing the 2010 version. I bought my lap top from Best Buy last fall so im guessing its the 2010 version. I think I have Windows 7, but im not sure if that makes any difference.

Reply

Angie July 1, 2011 at 1:03 AM

I extracted the files…still not working. :(

Reply

John July 1, 2011 at 7:35 AM

The excel spreadsheet is in Excel 2007/2010 XLSX format. If you have Excel 2003 you will not be able open the file unless it is saved as an XLS file and reposted. BTW, Great Spreadsheet.

Reply

Lauren July 1, 2011 at 10:28 AM

Okay, I figured it out. The file is saved under the Desktop. Open your Exel program. Then go to “open” and select the “all files” from the drop down box on the bottom right hand corner. Then click on the desktop file on the left and inside there you will see the “zipped” file. Click on it to open it, then the warning will come up asking you to verify that the file isnt corrupt. Select “yes” and then it should open :) Hope that helps you! I didnt realise it was saving the actual zipped file under the desktop lol

Reply

Janette July 1, 2011 at 11:13 AM

This worked for me. Im not a computer whiz but i am pretty familar with excel and downloading and this was puzzling to me. Thanks for the help! :)

Reply

Rachel August 14, 2011 at 7:05 PM

Thanks. I was not able to find it but with your help I figured it out. Thanks for the post. It was very helpful!!!!

Reply

Jayme August 18, 2011 at 2:54 PM

You are a genius!! Thank you!Very helpful!!!

Reply

Angie July 1, 2011 at 11:42 AM

I have Office 07… Thanks Lauren! That worked by opening Excel first and doing it that way! Thanks so much!

Reply

Michelle July 1, 2011 at 12:55 PM

Since there wasn’t enough sheets for all the stores I used, I tried to copy and paste one of the sheets to make a new one and it won’t let me. Is this possible or am I only stuck with using 4 stores on the excel file?

Thanks so much!

Reply

Lyndsey July 1, 2011 at 9:57 PM

Michelle,

Because of the way the spreadsheet is set up you won’t be able to add another store without a lot of hassle. The main page reflects totals for all your stores and adding another store would mess that up.

Reply

Kristen July 5, 2011 at 10:55 PM

I just downloaded a second calculator to have more stores.

Reply

jessi July 6, 2011 at 5:09 PM

I aslo just made a misc store tab….for store I don’t go to much. And I combined sams and aldi since either one of them don’t coupons. But my question is since its password protected is there any way to add a column, I would like to put misc info in it…But I do love it!!

Reply

Sarah August 2, 2011 at 7:02 PM

When you total up your savings, do you put the total before or after taxes?? Always wondered about that.

Reply

Kimberly August 11, 2011 at 4:27 PM

I have Excel 2003. Will I not be able to use this?

Reply

lindsay August 14, 2011 at 6:52 PM

I have excel 2003 and it will not open on my computer:(

Reply

Stacy August 15, 2011 at 2:05 AM

Love Love Love It!!!!!!!!!!!!!

Reply

Melody August 17, 2011 at 11:20 PM

Well, I tried opening Excel first and it didn’t recognize the file and imported junk like all over the screen. Is it possible for someone to covert the file from an .xlsx to a .xls file and repost it? If you have a later version of Excel, it would be super easy to convert it. I’d do iyt if I could. :-(

Reply

Kimberly Pennala September 7, 2011 at 9:39 PM

I just downloaded the coupon calculator, but I’m confused on how the system works. Well the main one I’m having trouble with is the Homeland reciept I have. On the receipt here’s what it look likes:

Fisher Bou Fish Fipc——4.49 B
SC 7310 One Card Saving——2.24 -B

So have do I know have much I actually paid for the product.

They were also BOGO and I had a $0.75 coupon on top if it.

Reply

Nicole September 12, 2011 at 3:59 PM

I downloaded the Zip file but it does not contain an excel document. I have excel on my computer and I use it everyday for work, but I can’t seem to get the calculator to open. I have a windows 7 operating system. Any suggestions?

Reply

SUSAN October 17, 2011 at 3:40 PM

What can we do if we do not have excell? I have works.

Reply

Tamara Willis November 3, 2011 at 10:28 AM

Is it possible to have this e-mailed to me because I am not able to open it either :-(

Thanks

Reply

Susan November 28, 2011 at 10:03 PM

I can’t use it and I am an Excel user. It is protected so therefore I can not enter any information other than in three columns.
And it looks like a wonderful sheet, but not useful to me at this time

Reply

tina January 1, 2012 at 12:23 AM

The coupon calculator is FABULOUS!!! Can you please post a 2012 calculator….:)

Reply

Carrie January 1, 2012 at 4:44 PM

that is actually my plan to do today! ;) Well… tonight.

Reply

Zena Sue January 29, 2012 at 9:31 PM

The Savings Calculator won’t calculate 2012 entries.

Reply

Priscila February 2, 2012 at 4:14 PM

I had to use google chrome to download the file and then it work for me.

Reply

Amy February 2, 2012 at 9:04 PM

Has the 2012 savings calculator been posted yet? I can’t seem to find it…
Thanks!

Reply

Leave a Comment

{ 3 trackbacks }

Previous post:

Next post: