An intern built a timesheet app because the other timesheet app sucks

“It's not shadow IT if the manager knows about it.”— Finance Business Partner

Reason:

Officially because the last 10% is authentication, billing and everything else. Started as Suppliers_old.xlsm with a script attached.

Built by:

Petra, a warehouse supervisor

Build time:

an afternoon, mostly

Built with:

Google Apps Script

Database:

an API that returns CSV

Authentication:

no login. It is on the intranet, so it is fine.

Deployment:

running on localhost through a tunnel

Responsible:

HR Generalist, because their name appeared first in the meeting notes

Documentation:

a PDF exported from PowerPoint

Security situation:

CSRF protection was temporarily disabled

Future disaster:

It will hold the only copy of Suppliers_use-this-one.xlsm.

Age: 1.3 years · originally expected to last 2 months · 2 owners so far · last meaningful change 74 days ago

Rated common mostly because: 78 users, €39k per year, alive 8x longer than intended.