Risk Management built a capacity planning spreadsheet with a frontend

“We just need it until SAP is updated.”— Chen, Risk Management

Reason:

Officially because the source of truth is an email attachment from April. With 3 tests, all skipped.

Built by:

Chen, a warehouse supervisor

Build time:

51 minutes

Built with:

WordPress with eleven plugins

Database:

booleans stored as "yes", "no", "Y", "N" and occasionally "maybe"

Authentication:

the encryption key is in the source code

Deployment:

running on a VM with 4 GB of free disk space

Responsible:

Priya, who only knows the database

Documentation:

a Loom video nobody can find

Security situation:

security is handled by the fact nobody knows it exists

Future disaster:

It will cause Procurement to ask "what vendor?".

Age: 4.9 years · originally expected to last 4 weeks · 3 owners so far · survived 3 reorganisations · last meaningful change 420 days ago

Rated common mostly because: alive 59x longer than intended, 2 departments depend on it, 1 accidental connections.