Platoon Manager
Almost every company starts with a shared sheet. It is free, everyone can read it, and for a platoon it works. The failures arrive in a predictable order.
One: two people edit at once
Someone updates the roster on a phone in the motor pool while the training room updates it on a laptop. One version wins and nobody knows which. The first symptom is a soldier who was marked out being present again the next morning with no one admitting to it.
Two: status columns instead of dates
A cell that says LEAVE has no end. Somebody has to clear it, and the day they forget is the day the count is wrong. Sheets that survive longest are the ones with a From and a Through column, because a date can be checked against today and a word cannot.
Three: everybody can see everything
The sheet that started as one platoon now has the whole company on it, including phone numbers and reasons for appointments, and it is shared with a link. A team leader who needs eight names can read four hundred.
Four: no history
Cells get overwritten. When the commander asks how many times a soldier has been unaccounted for this quarter, or how many people the company had available during the last gunnery, the answer was typed over weeks ago.
The tell that you have outgrown it
The clearest signal is not the sheet itself. It is that somebody has started keeping a second copy, because they no longer trust the first. Once two versions exist, every formation includes a reconciliation nobody scheduled.
The second signal is a soldier being asked to confirm their own status, because the record cannot be trusted over a person's memory. At that point the sheet has stopped being a record and become a rumour with a header row.
What to do at each stage
At stage one, name a single owner per platoon and have everyone else send changes to them. It is slower, and it will hold for a few months.
At stage two, switch the status column to two date columns before you do anything else. This one change fixes most of the drift and costs nothing.
Stages three and four are where a sheet runs out. Scoped access and a change history are not things you can add to a spreadsheet without building software, and at that point you are either building it or using something that already has it.
Related
Skip stages three and four
Platoon Manager has the parts a spreadsheet cannot grow: every leader scoped to their own units, an audit log of who changed what, and absences stored as date windows that close themselves. Import a platoon and compare it against your sheet for a week.