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
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: