ABCDEFGHIJKLMNOPQRS
1
GROCERY WEEKLY SCENARIO
2
INSTRUCTIONS FOR USE:
1.) Place the items or products you plan to purchase in the column entitled "Item".
2.) Place the cost for that particular item beside it in the column entitled "Price". Place the current price, which is the sale price, regular price, clearance price, or etc.... If you are buying something like chicken or bananas that are sold by the pound, estimate or round your total high, so you won't go over your anticipated budget or out-of-pocket.
3.) Place any coupons you plan to use in the column entitled "Coupon". Here is where you place what the coupon is for, for example Dove, Kraft Cheese, or etc.... Also include any discount coupons like $ off $$ or $ off your total purchase. This is also where you place any gift cards you plan to use that will lower your actual out-of-pocket.
4.) Place the exact value of the coupon you plan to use in the column entitled "Amount". The column entitled "Double" will automatically double your coupon if it is $0.50 or under. If it is $0.51 or higher, this column will just show a matching amount.
3
5.) The spreadsheet will automatically calculate your spend total, which is the total of all the products you plan to purchase before coupons; your coupon total, which is the total of all the coupons you plan to use; and your grand total OOP, which is the amount you plan to spend out-of-pocket. It also automatically calculates your percent of savings.
6.) The spreadsheet will automatically take the final values and place them on the tab entitled "Weekly Total Spend", so you can see how much you will pay and save out-of-pocket for all of the stores you plan to visit this week combined.

USAGE TIP: Do not delete or alter anything in the column entitled "Double" or the section that includes Spend Total, Coupon Total, & Grand Total, because these sections include formulas which automatically calculate. By deleting the value in the column, you'll delete the formula and have to enter the information manually.

PRINTING TIP: When printing to use as a shopping list, highlight the information you want to print. Next, go to "File" and select "Print". Under "Print What", select "Selection" and click "Ok" to begin printing only what is highlighted.
4
CHANGE or EDIT A STORE TIP: If you are a shopper in Terre Haute or another city and would like to alter one of these stores to match a local store, simply change the name of the store. For example, click in the cell with the word "MEIJER", delete this text, and type "BAESLERS". Next, if your store does not double coupons, simply right-click on the letter corresponding with the column entitled "Double". For example, to delete the Meijer double column, click on right-click on the letter "E" and select "Delete". This will mess up your coupon total. To fix this, delete the text in the box next to "Coupon Total". Then type the following information, which is in "" - "=sum(". After typing this, select all of the cells under the column "Amount" and press your enter button.

TO DELETE INSTRUCTIONS: Once you get good with this spreadsheet, you can remove these instructions, so they'll no longer be in your way. To do so, highlight the numbers that correspond with the columns matching the instructions (2-4). Right-click and select "Delete".
5
MEIJERKROGERMARSH
6
Spend Total$0.00Spend Total$0.00Spend Total$0.00
7
Coupon Total$0.00Coupon Total$0.00Coupon Total$0.00
8
Grand Total OOP$0.00Grand Total OOP$0.00Grand Total OOP$0.00
9
10
% Savings#DIV/0!% Savings#DIV/0!% Savings#DIV/0!
11
ItemPrice Coupon AmountDoubleItemPrice Coupon AmountDoubleItemPrice Coupon AmountDouble
12
$0.00$0.00$0.00
13
$0.00$0.00$0.00
14
$0.00$0.00$0.00
15
$0.00$0.00$0.00
16
$0.00$0.00$0.00
17
$0.00$0.00$0.00
18
$0.00$0.00$0.00
19
$0.00$0.00$0.00
20
$0.00$0.00$0.00
21
$0.00$0.00$0.00
22
$0.00$0.00$0.00
23
$0.00$0.00$0.00
24
$0.00$0.00$0.00
25
$0.00$0.00$0.00
26
$0.00$0.00$0.00
27
$0.00$0.00$0.00
28
$0.00$0.00$0.00
29
$0.00$0.00$0.00
30
$0.00$0.00$0.00
31
$0.00$0.00$0.00
32
$0.00$0.00$0.00
33
$0.00$0.00$0.00
34
$0.00$0.00$0.00
35
$0.00$0.00$0.00
36
$0.00$0.00$0.00
37
$0.00$0.00$0.00
38
$0.00$0.00$0.00
39
$0.00$0.00$0.00
40
$0.00$0.00$0.00
41
$0.00$0.00$0.00
42
$0.00$0.00$0.00
43
$0.00$0.00$0.00
44
$0.00$0.00$0.00
45
$0.00$0.00$0.00
46
$0.00$0.00$0.00
47
$0.00$0.00$0.00
48
$0.00$0.00$0.00
49
$0.00$0.00$0.00
50
$0.00$0.00$0.00
51
$0.00$0.00$0.00
52
$0.00$0.00$0.00
53
$0.00$0.00$0.00
54
$0.00$0.00$0.00
55
$0.00$0.00$0.00
56
$0.00$0.00$0.00
57
$0.00$0.00$0.00
58
$0.00$0.00$0.00
59
$0.00$0.00$0.00
60
$0.00$0.00$0.00
61
$0.00$0.00$0.00
62
$0.00$0.00$0.00
63
$0.00$0.00$0.00
64
$0.00$0.00$0.00
65
$0.00$0.00$0.00
66
$0.00$0.00$0.00
67
$0.00$0.00$0.00
68
$0.00$0.00$0.00
69
$0.00$0.00$0.00
70
$0.00$0.00$0.00
71
$0.00$0.00$0.00
72
$0.00$0.00$0.00
73
$0.00$0.00$0.00
74
$0.00$0.00$0.00
75
$0.00$0.00$0.00
76
$0.00$0.00$0.00
77
$0.00$0.00$0.00
78
$0.00$0.00$0.00
79
$0.00$0.00$0.00
80
$0.00$0.00$0.00
81
$0.00$0.00$0.00
82
$0.00$0.00$0.00
83
$0.00$0.00$0.00
84
$0.00$0.00$0.00
85
$0.00$0.00$0.00
86
$0.00$0.00$0.00
87
$0.00$0.00$0.00
88
$0.00$0.00$0.00
89
$0.00$0.00$0.00
90
$0.00$0.00$0.00
91
$0.00$0.00$0.00
92
$0.00$0.00$0.00
93
$0.00$0.00$0.00
94
$0.00$0.00$0.00
95
$0.00$0.00$0.00
96
$0.00$0.00$0.00
97
$0.00$0.00$0.00
98
$0.00$0.00$0.00
99
$0.00$0.00$0.00
100
$0.00$0.00$0.00