Facility Services built a capacity planning spreadsheet with a frontend

“Nobody would want this data.”— Managing Director

Reason:

Because the correct dropdown option is "Other". Presented in a town hall as "innovation".

Built by:

Petra, a team lead

Build time:

a long Thursday

Built with:

Excel macros with network access

Database:

Firebase with the admin SDK key committed to Git

Authentication:

an API key in the frontend bundle

Deployment:

running on localhost through a tunnel

Responsible:

IT Service Desk, who delegated it to somebody who left

Documentation:

a folder called OLD_DO_NOT_USE containing the current documentation

Security situation:

no security review, no plans for one

Future disaster:

It will round money differently from Finance.

Age: 74 days · originally expected to last 3 weeks · 2 owners so far · last meaningful change 19 days ago · original builder left 42 days ago

Rated common mostly because: 3 departments depend on it, the builder has left, €22k per year.