Bivio Hotel Management
Engineering highly complex, formula-driven digital systems to replace manual, error-prone planning with robust spreadsheet logic.
Shift Scheduler Engine
I engineered a comprehensive employee shift calendar using advanced conditional formatting, complex lookup arrays, and automated scheduling rules. It perfectly handles rotating schedules, rest days, and dynamic role assignments across a massive staff list without external SaaS dependencies.
- ▶ Rotating shift algorithms
- ▶ Dynamic role assignment tracking
- ▶ Absence & Leave formula modeling
Spatial Table Tracking
Developed a strictly visual table management interface natively within the spreadsheet grid constraints to track reservations and spatial organization in real-time across the hotel's bar and bistro areas.
- ▶ Grid-based spatial mapping
- ▶ Real-time reservation conflict checks
- ▶ Zero-lag rendering optimization
The Consultant Reality
Sometimes the most effective solutions don't require a full web stack; they require deep mathematical and logical modeling within tools the client already uses. By avoiding an expensive custom software rewrite, I delivered a tailored, instantly adoptable automation pipeline that drastically improved operational efficiency for Galli Erio.