This is a submission for the MLH x DEV Writing Challenge
Author: Ravi Saxena (@ravi_saxena_6fd4d0ef1c9cb) โ solo. No teammates.
What I Built
HotelFlow is a hotel operations engine, not a guest chatbot.
After a guest books, the hard part is everything before checkout: late arrivals, dirty rooms, a broken AC, extra towels, a VIP moved up, and two staff off the floor. That story usually lives in WhatsApp and phone calls. A manager keeps asking: what should we do right now?
HotelFlow reads one Excel workbook (rooms, staff, reservations, rules, chaos events) and builds a live queue for the next 5, 15, and 30 minutes. It scores each job (urgency + guest impact + arrival time + VIP / out-of-order), assigns people by skill and floor, and escalates if nobody is free.
The interesting piece is Event โ impact โ priority โ assignment โ resolve. Click Simulate hotel chaos and the plan rewrites itself. I did not build another PMS. I built the layer that decides what is next.
What I learned: storing โroom 101 = occupiedโ is easy. Conflicting priorities with four people and twelve jobs is the actual product.
Demo
Live (no login): https://hotelflow-gamma.vercel.app/
Code: https://github.com/Ravi-Saxena-kronos/hotelflow
- Open the site. Badge NORMAL. Demo hotel: Grand Demo Hotel, New Delhi.
- Click Simulate hotel chaos.
- Badge CHAOS. NOW should show VIP 303 / 105 and repairs (leak / AC). Some staff become unavailable.
- Click Reset from Excel to go back to NORMAL.
- Optional: type
Room 302 bathroom is leaking and guest arrives at noonโ Add to queue. - Mark resolved on a card to close a job.
Partner Technologies
I did not use a paid MLH perk token in this build.
Stack: Next.js 14, TypeScript, Tailwind, Vercel, and xlsx to import the hotel workbook. The decision engine is in src/lib/engine.ts โ not an LLM chatbot.
Vercel is serverless, so chaos / resolve / typed incidents send the current hotel state with the request. The default hotel is the Excel file in the repo (data/HotelFlow-input-template.xlsx).
Hackathon Experience
Solo build. I am the only author.
I built HotelFlow as an operations control room for a problem I see in hotels: the desk is not short on screens; it is short on one next action when everything breaks at once.
The part I will remember is the chaos button. A calm map is not a demo. Injecting the Excel chaos playbook (checkouts, AC, leak, VIP moved to 11:00, two staff unavailable) and watching NOW / 15 / 30 reorder is the story.
