View Single Post
 
Old 07-18-2008, 09:17:43 PM   #5 (permalink)
TRADER
SPARKING
iTrader: (0)
 
MommaDuck01's Avatar
 
Join Date: Jun 2008
Posts: 203
MommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond reputeMommaDuck01 has a reputation beyond repute
Default Re: Help with a spread sheet

I do a spreadsheet for so many things. I need lots of info to make me happy!

Here are my column headers:
A) category (use your organizer categories so you can sort the spreadsheet and search for coupons easily)
B) Item (I list the item on sale as well as details - size, etc.)
C) Quantity
D) Price (so if it was 2/$5, I would list 2 in qty and $5 in price; I can change this later if I want to buy a different qty)
E) Extra Bucks or Register Rewards
F) MIR's
G) EasySaver coupon/in-ad coupon, etc
H) Coupons (the one(s) that I have in my binder)
I) End Cost (each row would be set to calculate "=SUM(Dx:Hx)" x being the correct row number)
J) Price Each (rows would calculate "= Ix/Cx")
K) Amount paid at store (rows would calculate "=SUM(Dx,Gx,Hx)")
L) Details/notes - any reminder or details that don't fit any where else like "coupons expire on Tuesday!"

I make a tab for each week and separate the worksheet with store names and then sort under that by category so it is easy to shop by aisle.

Hope this makes sense to you! Like I said, it may be too detailed for what you want but I like lots of info. It tends to print small (adjust the font and all to fit) but I write small too so it doesn't bother me. I also adjust the page breaks so I might have one store printed out on one page and two on another.
__________________
-- MommaDuck
Gone crazy be back later!
MommaDuck01 is offline   Reply With Quote