🔬 KPI-Daily 🗓️ Workforce Scheduler 📊 Daily Report
📊 Open Daily Report

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.

📊 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.

✅ (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…