Schedule Counter (GAS) — Cockrell Hill

← Back to Hub

This is a Google Apps Script web app. It runs inside Google Sheets via Apps Script and cannot be opened directly in a browser. Follow the setup steps below to deploy it to your Google account. An onboarding wizard walks you through initial configuration.

What It Does

Combines your HotSchedules schedule export with daily sales data to show exactly where you're overstaffed, understaffed, or on target — hour by hour, day by day. Replaces guesswork with color-coded grids, actionable insights, and automated weekly forecasts.

HotSchedules export converter (raw Excel/HTML → clean hourly CSV)
Color-coded staffing grid with sales intensity overlay
SPLH tracking with configurable goals (overall, FOH, BOH)
Optimization insights — specific add/cut staff recommendations
Ideal staffing model — target headcount per hour to hit your SPLH goal
Sales forecasting with linearly-weighted moving average + trend adjustment
Exponential smoothing of sales curves with outlier protection
Week-over-week trend charts and drill-down history
Forecast bias detection with auto-alerting
Automated Monday pipeline (archive, smooth, detect, clean, cache)
Thursday schedule reminder email with performance summary
Sunday sync check with failure alerting
Productivity tracker for long-term monthly performance
Built-in onboarding wizard for first-time setup

App Tabs

1. File Converter

Upload raw HotSchedules export, get a clean hourly CSV. Pull FOH and BOH separately.

2. Schedule Analysis

Upload CSVs + sales estimates. Get staffing grid, metrics, insights, ideal model, and manager shift view.

Trends

SPLH over time, goal distribution, weekly sales history, drill-down per week, bias flags.

Forecast

Predicted daily sales for the week you're scheduling. LWMA with outlier exclusion and trend adjustment.

Settings

SPLH goals, labor shares, sales curves, location, notifications, advanced params, trigger management.

Information

Complete documentation: tab guide, automation, data architecture, key concepts, workflow, troubleshooting.

Weekly Automation

🔻

Sunday 10:00 PM — Sync Check

Validates CFA sales data arrived in Sheet1. Alerts you if the sync failed so you can fix it before Monday.

▶️

Monday 6:00 AM — Weekly Pipeline

Archives sales, updates curves via smoothing, runs bias detection, cleans old data, rebuilds app cache.

📧

Thursday 7:00 PM — Schedule Reminder

Sends reminder email with latest schedule performance summary. Post your schedule tonight.

Setup Steps

Create a new Google Sheet for Schedule Counter.
Open Extensions → Apps Script and paste Code.gs.
Create all HTML files: Index.html, JavaScript.html, Stylesheet.html, Onboarding.html, TrackerEmbed.html, ProductivityTracker.html.
Deploy as a Web App (Deploy → New Deployment → Web App). Set access to "Anyone" or your domain.
Open the web app URL — the onboarding wizard will guide you through configuration.
Once set up, go to Settings → Automation → Install Triggers to enable weekly automation.
If you have existing CFA sales data in Sheet1, click Backfill History then Rebuild Curves.

Sheet Tabs (Auto-Created)

These are created automatically by the onboarding wizard or initSheets().

config — All settings (goals, email, shares, alpha, bias flags)
schedule_history — Hourly staffing per day per week
sales_history — Hourly sales per day per week (estimated + actual)
sales_curves — Per-day hourly weight distributions
weekly_summary — One row per week with SPLH, peak hour, goal %
app_cache — Pre-computed JSON for fast app load
Sheet1 — Raw CFA sales landing zone (cleared after pipeline)

Project Files

Code.gs Index.html JavaScript.html Stylesheet.html Onboarding.html TrackerEmbed.html ProductivityTracker.html