Hotel & Restaurant Management System
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu and daily reports behind a login screen.
- Industry
- Hospitality
- Deliverable
- Hotel Management System.xlsm
- Built with
- Excel VBA, UserForms, Shapes
Before
Room status, table bookings and orders were tracked on paper and in separate files.
After
A building map shows live room status and the restaurant module handles bookings, orders and daily reports.
More like this
Related projects
Trade Opportunity Finder & Profitability Analysis
International Trade
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading…
View project
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
View project