The day the “Temporary” tracking spreadsheet turned three years old. OK, Storytime since I’m pretty sure I spend too much of my free time thinking about this. I was working with a mid-sized logistics team recently and they had The Spreadsheet.
That's right, capital T, Capital S.
It was "created as a quick temporary solution" to track a few high-value assets while they "looked into establishing a real system." that was three years before I came along. This bad boy had 40 tabs.
This system relied on one person as the de facto "spreadsheet priest" - the guy understood the color-coding system but the rest of the team lived in fear of him taking vacation.
Long story short, here is the timeline that lead to The Spreadsheet's untimely demise.
Consider this your case study in why, "We'll tackle the tracking issue later" always costs more in the long run. Month 1 On the team: The usual “probably out in Yard 2.” Stuff.
Everyone accustomed to it. Month 2 A piece of gear that would make even grown men cry if lost for an entire week!
Where could it possibly be?
It somehow found its way to a new job site.
No one had updated the tab. The Spreadsheet Priest was off of the grid (on Vacation! As is customary). Month 3 A shipment of something we truly care about arrives and guess what?
No idea when it got there but no one can tell when it went out of spec thanks to the temp being recorded on logger only checked upon delivery. Month 4 The day of reckoning. Insurance audit shows half the “active assets” have literally not been seen in 6 months.
We paid insurance for items we couldn’t account for. Management finally called it what it was -- no, later. No, now.
Instead of buying an extra 50 tabs and designating more spreadsheet priests, we switched to the correct systems.
We implemented RFID tags on anything in specific locations,GPS trackers on movable items between sites, and Real-Time Temperature Alerts for temperature sensitive shipments that don't need to wait until delivery to be assessed. The geofencing feature alone triggered notifications twice in the first month when assets inexplicably left the designated storage areas. The moral isn’t to throw your spreadsheets to the wolves; that they're great for many things! Simply recognize that a tracking spreadsheet isn't a tracking system if the health and safety of your operations is dictated by a single individual and their willingness to update something regularly.
It's more like a hostage negotiation.
In any case, if you're stuck in the hell of Spreadsheet-dom but don't want the pressure of an aggressive sales call, I suggest taking a peek atAsset Track Pro to see what a well-constructed tracking ecosystem looks like without committing yet: Asset Track Pro. Go ahead, check to see if your priest has his bags packed. I'll be here.