UPDATE: Locals Mode - Personal ADE Planner & Tracker
I'm back with some updates for all the Amsterdam/Netherlands locals. Thankfully if you created the last app you won't lose anything by updating with the new code just take a look at the documentation, there's an "already running the app" path.
Full code blocks and documentation
Unsurprisingly, 90% of you that viewed my last post were from the Netherlands: https://www.reddit.com/r/AmsterdamDanceEvent/comments/1ui5168/personal_ade_2026_trackerplanner_google_sheet/
Since the first app I shared was made for me traveling from the US - I made some updates for people that live in the area.
- 24 hour clock and properly formatted dates
- Last train home logic - can use when the set might end to see if you can get the last train home
- Everything is anchored to your home
- next-set countdown replaces days-to-flight
- per-night "going?" toggles shared across friends plus a 📍 meet-point picker
- "🚲 bike" as a third day mode with a rain hint from the forecast
- a Costs tab with even-split balances
- late-night Places seed (4am fries, comedown coffee, dienstapotheek, P+R)
- and the one optional extra — an NS API key in ⚙ for a live departure board, degrading silently without it.
- One caveat to check before October: the Nachtnet table reflects the current NS structure but times/corridors drift year to year — it's a small commented array at the top of Index.html, built to be edited.
Photos of the new local mode:
u/wishfulwatermelon — 2 days ago
