A workforce dashboard that refreshes every hour
Your team updates a 21-tab workbook by hand every day. You want this month against last month, and nobody has time to build it.
Before and after.
A manpower agency tracked deployed staff, attendance, hires and attrition for a dozen client sites in a large Excel workbook updated by hand. Management wanted week-on-week and month-on-month comparisons, but changing how the team worked was not an option.
- A 21-tab workbook updated by hand
- 8 recruiter sheets with no combined view
- No week-on-week or month-on-month comparisons
- Dashboard refreshed every hour, unattended
- One recruitment funnel across 8 recruiters
- A weekly report every Monday
What we built, step by step.
Read the workbook as it is
Every hour, the live workbook is read as is. Odd headers, half-filled rows and shifting tab names are handled.
Work out the numbers
Headcount against target, attendance, hires against attrition and month-on-month changes, with full daily history for any date range.
One recruitment funnel
Eight recruiter sheets merge into one funnel, with each recruiter shown by number at the client's request.
Monday report in the inbox
Every Monday, management gets a short emailed report. Code works out every number, and AI only writes the summary.
From busywork to running on its own.
The problem
A manpower agency tracked deployed staff, attendance, hires and attrition for a dozen client sites in a large Excel workbook updated by hand. Management wanted week-on-week and month-on-month comparisons, but changing how the team worked was not an option.
What we built
We built an hourly job that reads all 21 tabs exactly as they are, cleans the messy rows, and works out headcount, attendance, hires, attrition and month-on-month changes. Eight recruiter sheets feed one recruitment funnel, and every Monday management gets an emailed report where code does the math and AI only writes the short summary.
What changed
Management can compare any period, refreshed every hour, while the operations team keeps the same workbook. Showing attrition as a monthly rate revealed that much of the new hiring was replacing people who left, which moved the focus to retention.
Built for a Workchestra client. Names and numbers in the screens are samples; the results are real.
Want this for your team?
A free 20-minute call with the founder. We will tell you honestly if it is worth automating.