Food Storage Inventory Software System

Posted: February 2, 2010 in Food & Water, Storage

I have started to use a new software application named “Inventory Droid” . It allows us to use the phones built in camera to scan barcodes on food we bring into and out of our home. The program allow you to export the data to a CSV file.

First change the raw CSV data into a workable Excel table by using the “Insert” tool tab. Then click the “Table” button. I also freeze the top row and add “Total Row”.

Next I need to create additional columns “Gallons”, “Calories” & “Need” Columns.

The formula for the “Gallons” column the will be “Ounces * Servings Per Container * Quantity / 128”
The formula for the “Calories” column the will be “Servings Per Container * Calories Per Serving * Quantity”
The formula for the “Need” column the will be “Servings Per Container * Calories Per Serving * Quantity”

Scroll to the end of the data table and pick “Sum” from the total selector in the “Gallons” & “Calories” columns.

To find the total calories filter the “Category” column to exclude “Cat Food”, “Dog Food” & “Pet”.

The total calories can be entered into the “Calories On Hand” on the “Storage Food” spreadsheet.

The same can be done for dog and cat food by filtering the category



I filter for drinks and water then enter the data into the “Storage Food” spreadsheet.



For the shopping list version I filter where the “Need” column is greater than 0.

I then sort by the “Category” column and hide all but the “Name”, “Category”, “Quantity”, “Need” & “UPC” columns. Print and go to the store.

Advertisements
Comments
  1. The spreadsheet(s)? you have above, did you design them or are they found somewhere? Or do you have them for download, perhaps I am missing this.

  2. Anne says:

    This application does not recognize the bar codes from the Provident Pantry items I purchased from Emergency Essentials. I have to type them all in manually (the item name, the brand name, the purchase location, etc). it would be nice to have a selection list for brand and purchase location.

  3. Russell Powell says:

    The formula for the “Gallons” column the will be “Ounces * Servings Per Container * Quantity / 128″
    The formula for the “Calories” column the will be “Servings Per Container * Calories Per Serving * Quantity”
    The formula for the “Need” column the will be “Servings Per Container * Calories Per Serving * Quantity”

    Are these right? Seems needed would be calculated different. Thanks…, Love the Blog!

    Russell

  4. Scott says:

    Very cool program. Do you know if the inventory database can be shared by more than one Droid? My wife and I both have one and it would be nice if one of us took something out of the pantry and used it that we could scan it, decrease inventory and the change would be reflected on both phones. I suppose it would be possible by exporting and importing into another phone but if some sort of real time data transfer was possible between phones that would be awesome.

  5. Aaron Ladd says:

    I’m sure you knew somebody would ask, any chance You can do this for the iPhone?
    Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s