Freezer Inventory Tracker.......

  • Some of the links on this forum allow SMF, at no cost to you, to earn a small commission when you click through and make a purchase. Let me know if you have any questions about this.
SMF is reader-supported. When you buy through links on our site, we may earn an affiliate commission.

diggingdogfarm

Master of the Pit
Original poster
Jun 23, 2011
4,648
176
Southern Tier of New York State
Here's a simple freezer inventory tracker I put together too keep track of what's in the freezer(s) and to avoid things being forgotten before they should be used up.

Days until "Use Date" are displayed as a negative number, like the -365 in the Italian sausage example below.

Once the "Use Date is within 30 days it's highlighted in red, like the -9 in the ground beef example.

If something has gone past the "Use Date", the background changes to black and the number to white as in the Polish sausage example.

The highlighting makes it easy to spot items that need to be used soon.

Dates must be entered in the following format, MM/DD/YR

Any and all feedback is welcome.


[ATTACHMENT=185]Freezer Inventory Tracker.xls (3,950k. xls file)[/ATTACHMENT]


~Martin
 
Last edited:
  • Like
Reactions: baconologist
Thanks Martin,    This is a great idea and something I can use but....One I can't change the date and the until use date field is not working either.

I think that since you can put in where its stored then it will work for fridge too. Like sauces and condiments. Oh yea and Cheese.

Some kind of sort would be nice.

Stan
 
Martin, as usual, you have given me a tool to use in my smoking hobby that will be great!  You are the man.  All the info that I get from you has been most helpful.  Now if I can only remember to keep the entries up(CRS) I will profit by it's use.  Thanks for always being there for me, and all the others on this forem.  Keep on keeping on!  Steve
 
Thanks Martin,    This is a great idea and something I can use but....One I can't change the date and the until use date field is not working either.


I think that since you can put in where its stored then it will work for fridge too. Like sauces and condiments. Oh yea and Cheese.
Some kind of sort would be nice.
Stan

I don't know what the problem could be, you should be able to just click in the cell and change the date.
I just downloaded the file above and ran it and it works okay here.
What spreadsheet program are you using?

re: refrigerator inventory

I'm working on a sheet of the pantry, fridge, etc.

~Martin
 
  • Like
Reactions: baconologist
Thanks Martin,    This is a great idea and something I can use but....One I can't change the date and the until use date field is not working either.


I think that since you can put in where its stored then it will work for fridge too. Like sauces and condiments. Oh yea and Cheese.
Some kind of sort would be nice.
Stan
I don't know what the problem could be, you should be able to just click in the cell and change the date.
I just downloaded the file above and ran it and it works okay here.
What spreadsheet program are you using?

re: refrigerator inventory

I'm working on a sheet of the pantry, fridge, etc.

~Martin
Excel but a older version.  Tried on the kitchen laptop too with no luck.  If you say it works then I will call my tech son and see if he can figure it out.
 
Maybe it has something to do with the document protection, try unchecking "protect" or whatever it's called in Excel, no need for a password.
If you can't get it working, I can send you an unprotected file so you can see if that works.




~Martin
 
Last edited:
Martin great spreadsheet.  I just attempted to change the date as well and I said that it was a locked cell and would not allow it to be changed

Jeremy
 
Martin great spreadsheet.  I just attempted to change the date as well and I said that it was a locked cell and would not allow it to be changed

Jeremy


As I suspected.
That's really strange because it works fine for me.
I'll unprotect it and post it again in the first post in a few minutes, try downloading it again in about 10 minutes.

~Martin
 
Last edited:
Martin, is there any way I can hook up my freezer to my computer so that it automatically updates anytime I take something out?:banana_smiley:

This is a Great tool, I'm just too much of a lazy procrastinator to keep up with it!:biggrin:
 
Still the same for me.  I can unprotect and change the date but the until use date field wont work and in the first four boxes It has #NAME instead of a number.
 
Are you entering the date like this?

3/21/12

The formulas in the first 4 "Until Use Date" cells should be:

=IF(ISBLANK(W10),"",DAYS(TODAY(),W10))

=IF(ISBLANK(W12),"",DAYS(TODAY(),W12))

=IF(ISBLANK(W14),"",DAYS(TODAY(),W14))

=IF(ISBLANK(W16),"",DAYS(TODAY(),W16))

Those cellls should be blank if there's no date entered in the "Use Before" column.


~Martin
 
Are you entering the date like this?

3/21/12

The formulas in the first 4 "Until Use Date" cells should be:

=IF(ISBLANK(W10),"",DAYS(TODAY(),W10))

=IF(ISBLANK(W12),"",DAYS(TODAY(),W12))

=IF(ISBLANK(W14),"",DAYS(TODAY(),W14))

=IF(ISBLANK(W16),"",DAYS(TODAY(),W16))

Those cellls should be blank if there's no date entered in the "Use Before" column.


~Martin
Yes I am .  When I opened it the first 3 boxes that should be -9   6   -365  Say #NAME?   Without changing anything.  if I input dates into the two boxes then the until still shows the same @NAME?

Think I should upgrade my office?
 
Ok I got it fixed. This is the change my son made.

=IF(ISBLANK(W10),"",DAYS(TODAY(),W10))

=IF(ISBLANK(W10),"",TODAY()-W10)

Everything works  Thanks Martin

Stan
 
Stan's figured it out.

That date function was not available in 2003 and earlier versions of Excel.  I was in the process of fixing my copy and was going to post the data, but Stan beat me to it.

And let me say, Martin this is a great tool and thanks for sharing it with us!!!!!!!!!

Since the template was locked and some users may not know how to edit a protected spreadsheet, here is a modified version that will work in Excel 2003 (Not sure about earlier versions as I only have 2003 on this PC).  I made the change to the function and re-protected the cells.
https://statich.smokingmeatforums.c...zerInventoryTrackerforExcel2003.vnd.ms-office
 
Last edited:
Martin! Shamey on you! Now I have to go thru my freezers and check stuff! Lol

This is great! Thank you really! I need to clean out and take stock of what we have!

Kat
 
SmokingMeatForums.com is reader supported and as an Amazon Associate, we may earn commissions from qualifying purchases.

Latest posts

Hot Threads

Clicky