Enterprise Architecture built a capacity planning spreadsheet with a frontend

“We'll put it on the roadmap.”— Plant Manager

Reason:

Because the workaround has onboarding documentation. With 2 users, one of whom is the CEO.

Built by:

Bastian, a team lead

Build time:

one weekend

Built with:

a Notion database with increasingly ambitious automations

Database:

an Access database called Headcount_old_final_FINAL.xlsx with 16 linked tables

Authentication:

the role is stored in localStorage

Deployment:

hosted on a free trial using Marco's credit card

Responsible:

a team that has since been reorganised

Documentation:

comments in the code explaining what the code used to do

Security situation:

the service account is also a real employee

Future disaster:

It will create a GDPR incident somebody describes as "probably minor".

Age: 4.1 years · originally expected to last 2 months · 4 owners so far · survived 1 reorganisation · last meaningful change 19 days ago · original builder left 1313 days ago

Rated common mostly because: alive 25x longer than intended, the builder has left, 1 departments depend on it.