I would recommend the Troop Equipment information be expanded to be a more robust database. The current categories are a start but it still requires managing a separate spreadsheet for equipment.
In addition to the items listed in the equipment area, I would add the following columns:
- A record number
- Item description - currently there
- Unit cost
- Year purchased
- Year removed
- Inventory date to address last time item was checked
- Picture - currently there
- Id# - our troop puts unique Id numbers on our tents
- Location 1 - request at least 2 location fields. This way we can sort. For example, it is in the trailer and located in patrol box 2. This allows us to do quicker sorting on items.
- Location 2
- Condition - already there