Room No-Show Reclaim & Utilization

The problem this kills

Your best meeting rooms are always "booked" and never used. Someone reserves the big room with the screen for a recurring sync that fizzled out months ago, or grabs three rooms "just in case," or books a 9 a.m. that never happens - and the room sits empty and locked on the calendar while four people stand in the hallway because "there's nothing free." You can see it with your own eyes: the room is dark, the booking is green. Meanwhile the small huddle rooms nobody wanted turn out to be the ones people actually fight over.

So you're stuck. You can feel that you have the wrong mix of rooms and a pile of ghost bookings, but you can't prove it. You can't tell which rooms are genuinely over-subscribed versus just hoarded, which ones are dead weight you could repurpose into focus pods or storage, or how often a "booked" room is really a no-show. And without that, every conversation about reconfiguring the floor, adding rooms, or pushing back on a team's standing reservation is just opinion against opinion.

This tool ends the ghost-booking problem and gives you the numbers. Every booking needs a quick check-in; if nobody checks in within a grace period you set, the room is auto-released back to the pool and the booker is notified - so empty rooms free themselves instead of sitting locked all afternoon. And every check-in and release feeds a utilization and no-show dashboard that finally tells you which rooms are over-used, which are dead, and what to do about it - with you approving the action before it counts.

What you'll build

A small internal web app, just for your team, that:

• Lets you import your existing bookings (from a calendar export, a booking-system CSV, or a sheet) and your room list with capacity - or collect new bookings directly in the tool.
• Requires a quick check-in for each reservation - a tap on a tablet by the door, a link, or a click in the app - so a room only counts as "in use" when someone actually shows.
• Auto-releases no-shows: if nobody checks in within the grace period you configure, the room is freed back to the pool, the booker gets a polite "we released your room" note, and the release is logged.
• Shows a utilization + no-show dashboard: utilization % and no-show rate by room, by room type, and by time of day, so you can see what's over-subscribed and what's dead.
• Lets the workplace manager review the report and approve a space action - repurpose an under-used room, add more of a popular type, retire a never-used booking - before it's recorded as a decision.
• Keeps auto-release rules configurable (grace period, which rooms are exempt, quiet hours) and a full audit of every auto-release.
• Dedupes on booking ID so the same reservation can't be imported or processed twice, and exports a clean utilization CSV for your reports or your real-estate team.

What's inside the Implementation Plan

The plan is a single markdown file you paste into Claude Code (a free AI coding agent). It walks the agent through building the whole tool, step by step, each step ending with a ready-to-paste prompt - no coding knowledge needed on your part.

The most important part: the plan opens by interviewing you about your business. Before it writes a single line, the agent asks how rooms get booked today, what booking system or calendar you use and how its export is shaped, the real field names and room-naming conventions in your data (room IDs, floors, capacity, room types), your typical and peak booking volumes, exactly what counts as a check-in and how long your grace period should be, what "over-used" and "under-used" mean to you, and your messy edge cases - recurring meetings, all-day holds, VIP rooms that should never auto-release, rooms with no door tablet. It reads a short tailored spec back to you, you confirm it, and only then does it build - so you get a tool shaped to your floor and your rules, not a generic template you have to fight.

Inside you'll find:

• The discovery interview and how the agent turns your answers into the data model, the check-in flow, the grace-period rules, and the utilization math.
• The full build: database, login, booking + room import with a duplicate guard on booking ID, the check-in flow, the auto-release engine with notifications, the utilization + no-show dashboard, the manager approval gate for space actions, and the CSV export.
• The hard human-in-the-loop lock - the tool drafts a space recommendation, but no repurpose/expand decision is recorded until the workplace manager approves it - enforced in code.
• Verification steps so you can prove it works, and the CSV-export fallback so it's fully usable even before you connect it to your booking system.

The governance it includes (this is the point)

This isn't a toy. The plan builds in the controls a facilities/workplace team actually needs:

• Login so only your team can see or touch anything.
• Row-level security so people only see their own organization's data (and, if you run multiple sites, only their own site's rooms).
• A complete, immutable audit trail - every import, check-in, auto-release, rule change, recommendation, approval, and export is logged with who (or what rule) did it and when, so you can always answer "why was this room released?".
• A hard human-in-the-loop gate - the tool measures, releases empty rooms by your rules, and drafts a space recommendation, but a real workplace manager must approve any repurpose/add/retire decision before it's recorded as the plan of record.
• Configurable, logged auto-release - grace period, exempt rooms, and quiet hours are all settings you control, and every automatic release is recorded with the rule that fired it - nothing happens by magic.
• Duplicate guards so the same booking ID can't be imported or processed twice.

Who it's for

Workplace and facilities managers, office managers, real-estate and space planners, and workplace-experience teams who own meeting rooms and bookable spaces and are tired of ghost bookings, empty-but-locked rooms, and arguments about the floor plan that go nowhere. If you suspect you have the wrong mix of rooms - too few of the kind people fight over, too many nobody uses - and you want hard utilization and no-show numbers (plus an enforced check-in to stop the no-shows) without buying an expensive workplace-management platform or hiring a developer, this is for you. You don't need to write code. You need your bookings, your room list, and an afternoon.

You've got this - paste the first prompt and let the agent interview you.