Friday, January 27, 2012

A Simple Coupon Tracker

Simple Coupon Tracker

A simple Coupon Tracker , Lets you know how long you have to use your coupons.

You can download THIS Spreadsheet HERE

My Gift to you - Free Downloadable Spreadsheets

Household Management Binder / Notebook

Home Management Binder in a Spreadsheet
Quick Calendar & Schedule at a Glance

Important Dates

Household Chores (Use Filter to Ease usage)







A simple Home Management Binder in a spreadsheet form.
You can Edit it as needed , Copy Monthly Charts by Date and re-date the Calendar yourself.
Its a simple Go to for quick information at a glance.

You can download this spreadsheet HERE

My Gift to you - Free Downloadable Spreadsheets

6 week sales cycle tracker

This is a 6 week s sales cycle calculator. It uses 6 weeks worth of sales data on a single Item to estimate the best price date. 


Click Screen Shots for a better preview.

Once you have your simple price comparison done with 6 weeks worth of data you should be able to fill out the 6 weeks sales cycle calculator and roughly estimate the next sales dates.

You can Download THIS Spreadsheet by clicking HERE

My Gift to you - Free Downloadable Spreadsheets

Simple Price Comparison Spreadsheet

Simple Price Comparison Worksheet
This lets you keep a price book , and simply compare prices without all the features of the larger worksheet I offer. Click Screen shots for a better preview.




How to Use  : Please reference my original post on the price book / comparison / Inventory spreadsheet HERE

To Download or Preview THIS spreadsheet please click HERE
My Gift to you - Free Downloadable Spreadsheets

Price Book / Comparison / Inventory / Stockpile

Pricebook - Helps compare prices , track inventory & Compute prices after coupon , even tells you where you stored it.
I created this spreadsheet to compare prices , print a grocery list based on best sale items & control and monitor inventory. Click the screen shots to see full size .








How to Use : Enter the date , Choose an Item Category , and choose an Item , Enter the Qty / Count , Enter the prices at various stores (Edit Store names to reflect YOUR stores) , Enter coupon & Inventory Data . DO not Edit Orange Rows , as they use formula's to automatically update .

Use the Filter function to narrow your view to current or past dates , Use 6 Week Sales tracker after you have 6 weeks worth of data to predict sales dates. (a different worksheet) , Use various filter functions to narrow the list to the items you want & print.

Change Categories  , or add Items to Categories from The Category Data Sheet , Choose to hide colums as needed. (I often Hide Columns when entering Data so I don't accidentally enter sales data for the wrong store. (Example when I enter data for super 1 , i hide all columns for other stores. I also often hide unit price for easy of data entry.)

I often Use filter function to narrow the range of data I see by Date , Category , Item or weather I need it [x in List Column]. I add different package sizes as different Items and later compare Unit Price to choose which I want to add to list. (is it cheaper to buy the 10 lb bag vs the 3lb bag ?)

I know it seems a bit big in file structure , but it works. I will later be adding the 6 weeks sales tracking worksheet to calculate sales date.

To Use or Download this template click this Link


My Gift to you - Free Downloadable Spreadsheets
Related Posts Plugin for WordPress, Blogger...