Operation: Kill the Spreadsheet. An after-action report on how the MEUCOM platform was built.

A. Size and Composition of Patrol

B. Task

C. Time of Operation

D. Routes and Terrain

E. Results of Encounters With Enemy

1236, Recon. An OP was established, read-only, on the PERSCOM database. The patrol exfiltrated 1,353 personnel and over 10,000 service records, every assignment, qualification, award, and application back to 2008, without disturbing the live install. In parallel, all 139 Discord roles were counted and the entire Unit Policy Manual was read cover to cover. The public PERSCOM code was observed for schema intelligence only. Read the map, never trace the map.

Midday, Objective 2. The spreadsheet was dissected under fire, formula by formula. A fresh PostgreSQL position was dug in across 40-plus migrations, and the main body moved in: 5,037 members imported with full service history and 56,000-plus attendance records. Where the two old sources disagreed about a member, the discrepancy was set aside for a human to settle rather than guessed at. Nothing was silently overwritten.

Afternoon, Consolidation. On the new position the patrol stood up a searchable roster that reads like the master sheet the unit already knows, dress-blues service cards with real ribbon racks in proper precedence, a ticket and approval system where a transfer request routes itself to the right leadership and executes on the final approval, duty-based permissions that let one member wear the squad-leader, training-NCO, and instructor hats all at once, reversible merge tools for duplicate records, and a red rebrand pulled straight from the unit's own colors.

1815, the Identity Heist. The highest-value action of the day. All 7,804 forum accounts were lifted out of the old forum, passwords and all, so no member has to reset anything: the old login just works. For the 2,482 members who joined through Steam or Discord and never held a password, those sign-in routes were wired up so they get in the way they always have. The platform was then made its own front door: it is the identity provider now, and the forum's replacement asks it who you are.

1822, the Brain Transplant. The spreadsheet's promotion math, its composite scores and eligibility gates, was ported into a real rules engine, with the rule numbers stored as adjustable settings rather than welded into the code. It was then verified, not vouched for: golden-master tests pin the ported formulas against the sheet's own historical outputs. Result of the encounter: zero composite-score violations. The new brain computes the same numbers, to the number, with a standing test suite posted to keep it that way.

Conclusions and Recommendations

Mission accomplished within the operational period. The platform is live on Railway: roster, ORBAT, personnel files, the rules engine, requests and approvals, permissions, awards, merge tools, single sign-on, and this report. Gone are the days of the spreadsheet.

Recommend all hands adopt. Recommend future operators measure the old system before replacing it, set disagreements aside for a human, prove the math instead of trusting it, and when the first ORBAT does not fit, build the second one flat.

On the attached AI co-author: does not sleep, does not drink, does not miss a footnote, and holds strong, load-bearing opinions about em dashes. None were used in the drafting of this report. Not here either.