| Sheet | What it does |
|---|---|
| Lists | 12 locations, containers/vehicles and statuses. Edit these and every dropdown updates. |
| Equipment | One row per asset, with dropdowns for location, container and status, row colour by status, filters and frozen headers. |
| Dashboard | Location × status counts, total items and quantity, and a "not checked in 30+ days" counter. |
| Manifest | Pick a location or vehicle and get a print-ready list (landscape, repeating header, sign-off line). It works in every Excel version and in Google Sheets, with no FILTER() needed. |
Formulas were verified by recalculating the file in LibreOffice: dashboard totals = 60 items, and the manifest for "Location 01" lists 6 items.
Download .xlsx · Google Sheets: File → Import → Upload.
Generated by build_tracker.py (openpyxl), so it's easy to adapt to your categories and columns.