GETTING THE SHOP ORGANIZED (Part 2 of ?)…
1. Taking Inventory
Initially jotting down everything I have in the shop didn’t take as long as I thought, despite having a lot of stuff. Here a sample of the little diagrams I made. I also took pictures to help remind me of the items because I wasn’t going to be in the shop when I logged it in the computer. Using a tablet or something as you're walking around might increase the speed and accuracy of this process.

Once I had the list, I chose to use the old tried and proven MS-Excel to handle the database. It can handle all the future sorting duties that will be needed and pull down menus can be utilized to reduce the amount of typing and guarantee consistent data entry. It also allows for "filtering" that can be useful for a lot of things, like checking to see how many things I assigned to be stuffed in one little cabinet, for instance.
Here’s a sample snip from the file. So far I have over 350 items logged in it and I haven't even started with any of the storage lofts yet.

1. Taking Inventory
Initially jotting down everything I have in the shop didn’t take as long as I thought, despite having a lot of stuff. Here a sample of the little diagrams I made. I also took pictures to help remind me of the items because I wasn’t going to be in the shop when I logged it in the computer. Using a tablet or something as you're walking around might increase the speed and accuracy of this process.

Once I had the list, I chose to use the old tried and proven MS-Excel to handle the database. It can handle all the future sorting duties that will be needed and pull down menus can be utilized to reduce the amount of typing and guarantee consistent data entry. It also allows for "filtering" that can be useful for a lot of things, like checking to see how many things I assigned to be stuffed in one little cabinet, for instance.
Here’s a sample snip from the file. So far I have over 350 items logged in it and I haven't even started with any of the storage lofts yet.

Last edited:




























. So I looked to who could ship it to me the cheapest - gotta love free ship-to-store for this big stuff. We have 4 other Rubbermaid cabinets at the house (three of the bigger size) and they are doing great. They are under the eaves so I guess they are somewhat protected from the elements.






.






