Out-of-School Care | Staff Hours & Payroll Calculator

An interactive, widescreen “paper replica” spreadsheet dashboard built to automate split shifts, monthly attendance ratios, and government auditing for childcare facilities.

🛑 The Challenge

Childcare operations required tracking complex split shifts, computing provincial wage top-ups, and exporting clean landscape logs for licensing audits. Doing this manually on paper led to calculation errors and took administrators hours each week.

💡 The Solution

• Smart Input Parser: Users type simple shift strings (e.g., 7-9 or 2:30-6) which the JS engine automatically parses, sorts chronologically, and logs.
• Automated Wage Adjustments: Instantly calculates provincial wage top-up brackets based on employee certification tiers.
• High-Fidelity PDF Exports: Custom print styles format digital records into landscape physical ledger replicas with digital stamp grids.
• Gamified Onboarding: Built a digital achievement stamp book that eases training and drives system adoption.
• Decoupled Portfolio Demo: Engineered a mock client-side database layer utilizing browser localStorage to showcase the app’s full capabilities without server dependencies.

📈 The Result

✅ Reduced administrative payroll compilation times from 3 hours down to 10 minutes while maintaining 100% data validation accuracy.