Bivio Management Systems Management
This consulting project involved engineering highly complex, automated software solutions using advanced spreadsheet logic (Excel/Calc) for Bivio Hotel, directed by owner Galli Erio. The goal was to replace manual, error-prone planning with a robust, formula-driven digital system.
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 the client.
Key Contributions
Engineered a comprehensive employee shift calendar using advanced conditional formatting, complex lookup arrays, and automated scheduling rules.
Developed a visual table management interface within the spreadsheet to track reservations and spatial organization in real-time.
Optimized the spreadsheets to ensure zero-lag performance despite thousands of interconnected formula cells.
Delivered a tailored consulting solution that directly improved the operational efficiency of the Bivio Hotel staff.