Workforce Scheduler

Connected multi-day schedules, daily roll-forward queue & recurring task blueprints.

📗

Workforce Scheduler is the Excel File

The connected schedule is maintained in the 3-sheet Excel workbook: (1) To do list · (2) done · (3) roll forward.

📤 Upload / Sync (.xlsx) 📊 Back to Daily Report →

📊

Workforce Calculation: Daily Planned Work & Cadence Matrix

Pillar 1: Weekly (Code) · Pillar 2: Daily (Reliability)

Workforce assigns the full 8-hour daily workload upfront. Performance is strictly evaluated as Score = Finished / Requested.

📥 Download Assigned Schedule (.xlsx)

Day	Date	Daily Planned Work (Workforce Calculation)	Daily Commits Shipped	Daily Pillar 2 (Reliability)
Sprint Week 1 (11/09 ~ 11/13) — Weekly Code Target: 20 Commits · 20 Planned Deliverables (40.0h)
Mon	11/9	Unibox message ingestion foundation & API specs 8.0h accounted: 2 feature tasks + 4.5h CI/CD triage & test suites	7 commits	100% (Clean Deploy, 0 Incidents)
Tue	11/10	WhatsApp Cloud API webhook, WABA token & round-trip 8.0h accounted: 4 core tasks, token crypto, DB ACID double-write	12 commits	100% (Clean Deploy, 0 Incidents)
Wed	11/11	Teams OAuth, WhatsApp auto-reply echo, L3 docs & release 8.5h shift accounted: 11 commits (13:17~21:51), fake-data cleanup, Romit live WhatsApp test	11 commits	100% (Clean Deploy, 0 Incidents)
Thu	11/12	Signal & Google Voice relay prep, webhook handlers, E2E probe suite Workforce Assigned: 4 tasks · 8.0h budgeted · 100 pts · 4 commits required	(4 scheduled)	Evaluated on Deploy
Fri	11/13	WeChat & WeCom multi-channel integration, QR login bridge, sandbox relay Workforce Assigned: 3 tasks · 8.0h budgeted · 100 pts · 3 commits required	(3 scheduled)	Evaluated on Deploy
Week 1 Total		20 Planned Project Deliverables (40.0h)	30+ Commits (Target: 20)	Pillar 1: 100% · Pillar 2: Daily 100%
Sprint Week 2 (11/16 ~ 11/20) — Weekly Code Target: 18 Commits · 18 Planned Deliverables (40.0h)
Mon	11/16	Email Ingestion, Inline Images, SPF/DKIM, Jest Workforce Assigned: 4 tasks · 8.0h budgeted · 100 pts · 4 commits required	(4 scheduled)	Evaluated on Deploy
Tue	11/17	Email Release to Business Tier + Unibox Search & Badges Workforce Assigned: 5 tasks · 8.0h budgeted · 100 pts · 4 commits required	(4 scheduled)	Evaluated on Deploy
Wed	11/18	Unibox Multi-Channel Attachments & Typing Indicators Workforce Assigned: 2 tasks · 8.0h budgeted · 100 pts · 3 commits required	(3 scheduled)	Evaluated on Deploy
Thu	11/19	Channel Settings & Token Revocation Dashboard Workforce Assigned: 4 tasks · 8.0h budgeted · 100 pts · 4 commits required	(4 scheduled)	Evaluated on Deploy
Fri	11/20	Core Infra AI Loop Stress Testing, Release Notes & Pricing Gate Workforce Assigned: 6 tasks · 8.0h budgeted · 100 pts · 4 commits required	(4 scheduled)	Evaluated on Deploy
Sat	11/21	🚀 Kbot Meet Official Commercial Release (All 15 Channels Active) TARGET RELEASE Flag Unibox ON for all Business+ subscribers · L4 PCB 3-min real-device video sign-off · Smoke suite all 15 channels	🚀 RELEASE SHIP	L4 Commercial Sign-off
Sprint Total		15 Channels Unified + Full Unibox UI + L4 Commercial Sign-off	50+ Commits Shipped	Pillar 1: 100% · Pillar 2: Daily 100%

💡 Why Only 5–7 Commits for an 8-Hour Day? (And why commit volume ≠ 8 hours)

Workforce Principle: Looking directly at Git commit history and timestamps, 5 commits do not take 8 hours — at most, they represent 1 to 2 hours of actual code typing. If a system only tracks commits, it makes management ask: "Why only 7 commits for an 8-hour day?" because the other 4–5 hours of critical engineering work are completely invisible on the dashboard!

To solve this, Workforce accounts for an engineer's full 8-hour day across 4 mandatory components:

1. Core Code Commits (Pillar 1)

3.0 ~ 4.0h · Feature routes, DB schema, logic

2. Automated Tests & E2E Probes

1.5 ~ 2.0h · Jest, Playwright, HMAC & Webhook tests

3. Joint Debugging & Handshakes

1.5h · Cross-team live tests (e.g. Romit WhatsApp bridge)

4. Production Deploy & SLA (Pillar 2)

1.0h · Linode hostbuild CI, 0-downtime, health probe

Workforce assigns the full 8-hour daily To-Do items upfront based on project roadmap milestones, not based on what the engineer happened to submit.

Sheets:

📗

Connected Workforce Scheduler (.xlsx)

Live 3-Sheet Excel Workbook · Charles Liu · Today's Schedule 🟢 LIVE EDITABLE SPREADSHEET FORM · AUTO-SAVES TO DB

⏱️ Planned: 6.5h / 8.0h · 100 pts

Filter Schedule:

Loading live spreadsheet rows from DB...

📋 (1) Daily To-Do List Active Deliverables

All active deliverables scheduled for today · Mark complete to credit KPI points into (2) done.

📤 Sync Excel (.xlsx)

✅ (2) Done Deliverables Whatever Done from To-Do List

All completed & verified tasks removed from to-do list. Credited toward Set 1 & Set 2 Daily KPI.

0 pts credited

⏩ (3) Roll Forward Queue Not Done from Today

All unfinished deliverables not completed today. Select target destination date and pull them forward with 1 click.

📅 Roll Unfinished Tasks To:

0 unfinished tasks eligible for roll-forward

🚀 (4) New Assignments (Steve Hung Directives) Kbot Meet / Unibox

All urgent supervisor directives assigned directly into Charles's daily schedule.

5 Tasks · 65 pts Scope

[Teams] Teams app registration + OAuth

Scheduled: 2026-11-10 (Tue) · Azure AD app registration & bot OAuth flow · Kbot Meet

15 pts PENDING

[Teams] Teams inbound webhook route

Scheduled: 2026-11-10 (Tue) · Bot Framework messaging endpoint receives Teams inbound webhook · Kbot Meet

15 pts PENDING

[Teams] Teams → Unibox 2-way reply

Scheduled: 2026-11-10 (Tue) · Reply from Unibox sent out and delivered in Microsoft Teams · Kbot Meet

15 pts PENDING

[Teams] Teams profile enrichment

Scheduled: 2026-11-10 (Tue) · Teams sender display name and profile metadata populated · Kbot Meet

10 pts PENDING

[Teams] Teams attachments passthrough

Scheduled: 2026-11-10 (Tue) · Teams file and image attachments passed through to Unibox · Kbot Meet

10 pts PENDING

🎥 (5) L4 Video Requirements (Reference Standards) 21 Milestones

Mandatory criteria: Non-author human tester · Voice narration · Live kasercorp.com URL · Anti-fool input.

21 Video Milestones

1. Zoom Team Chat Auto-Send via User OAuth · 1.5 - 2.0 min · Live Kasercorp URL

L4 Verified

2. Kbot Meet Opt-In Full Auto-Reply · 1.5 - 2.0 min · Live Kasercorp URL

L4 Verified

3. Zoom Contact Real Name Capture & Cache · 1.5 min · Live Kasercorp URL

L4 Verified

4. LINE Channel Inbound Webhook & Message Parse · 2.0 min · Live Kasercorp URL

L4 Verified

5. LINE Profile Enrichment & 2-Way Threaded Reply · 2.0 min · Live Kasercorp URL

L4 Verified

6. Telegram Bot Inbound & 2-Way Reply (RO2/RO3) · 1.5 min · Scheduled Mon 11-09

L4 Ready

7. Discord Bot Inbound & 2-Way Reply (RO4/RO5) · 1.5 min · Scheduled Tue 11-10

L4 Ready

8. Messenger FB Page Inbound & 2-Way Reply (RO6/RO7) · 1.5 min · Scheduled Tue 11-10

L4 Ready

9. Instagram Inbound Webhook & 2-Way Reply Delivered · 2.0 min · Live Kasercorp URL

L4 Verified

10. WeCom Inbound Webhook & Thread Mirror in Unibox · 2.0 min · Live Kasercorp URL

L4 Verified

🗓️ Connected Multi-Day Schedule (Live DB & Excel Horizon)

Multi-day task schedule from the submitted Excel workbook · Click any date card below to switch and view that day's To-Do list

📊 Open Daily Report →

Loading connected schedule from DB…