Sunday, April 13, 2014

Keeping Track of Your Possessions with a Digital Home Inventory

Cori Pippins

Disasters, both natural and man-made, are becoming more and more frequent in today’s world.  We never know when something may happen to disrupt our lives.  If your personal property is destroyed or stolen, having an inventory (hard evidence) of the missing items to give the insurance company will improve your chances of recouping your financial losses.

This project was designed to help keep track of all of a person’s belongings.  The format would also be adaptable to a business environment.  Everything needed to keep track of the inventory is located in a single directory, making backing up the data easier.  The files could potentially be synched with online storage or transferred to a USB memory device.  There are two needed components to manage this project: an excel file and a folder to house pictures.

When you open the excel spreadsheet, you will first land on a summary sheet.  There are multiple tabs across the bottom indicating the different types of belongings you would need to keep track of, including properties, vehicles, individual items within the home, and food storage.  There is also a section to save important information about family members.  Each tab has buttons that when clicked will add a new entry, view/edit the current entry, or delete the current entry.  To add or edit an entry, the user will interface with a form.  The subsequent sections will go over how to use these properties.

In addition to the individual tabs at the bottom of the spreadsheet, there is a tab on the ribbon entitled “Home Inventory”.  This ribbon contains several buttons needed to make modifications to the spreadsheet.  The purpose of these buttons will also be discussed in subsequent sections.

No comments:

Post a Comment