Three assessors, two hundred firms, one spreadsheet
Your accreditation scheme needs each approved firm assessed on a cycle: an initial assessment, then surveillance visits, some of them on site, some remote, some witnessing a job in progress. Your assessors are a mix of employed staff and freelance associates spread around the country, each qualified for certain categories of work.
The scheduling spreadsheet has a row per firm with a due date. Every few weeks the scheme coordinator sorts it by due date, emails assessors to ask their availability, emails firms to propose dates, waits, reshuffles when a firm cannot do the proposed day, and books travel. When a firm postpones twice, their assessment slips past its due date, and the coordinator is not sure what the scheme rules say should happen then.
Why the juggling never ends
- Due dates, assessor availability and firm availability are held in three different places.
- Assessor competence (which categories each can assess) is known to the coordinator but not written anywhere the schedule can use.
- Travel efficiency depends on grouping nearby firms, which is hard to see in a spreadsheet.
- Firms postpone by email, and each postponement means starting the offer again.
- Overdue assessments are noticed late, because nothing counts down.
What to do about an overdue assessment is a scheme rules question for your scheme board. The scheduling problem is that you often do not see it coming.
What the juggling costs
Coordinator time, mostly spent on email. Assessor time lost to inefficient travel, which you may pay for if they are freelance. Firms irritated by being asked for dates repeatedly. And a growing list of overdue assessments, which weakens the scheme's credibility if anyone looks closely.
Consider an ordinary case. An assessor based in Leeds is sent to a firm near Carlisle on Tuesday, and another assessor drives up from Manchester to a different firm twenty minutes away on Thursday, because the two visits were booked from separate email threads a week apart. Neither person did anything wrong. The schedule simply had no way to show that the visits sat next to each other. Multiply that across a year and the travel bill, and the lost assessor days, add up quietly.
There is a fairness point too. When the same few firms always get the Friday afternoon slot, or one assessor always gets the long drives, people notice. A schedule built from visible rules is easier to defend than one built from whoever answered their email first.
A scheduler built for assessment cycles
We build a scheduling tool around your scheme's cycle and your assessors' competences.
- Each approved firm has its assessment cycle and next due window calculated from your rules, and upcoming visits appear on a list weeks ahead.
- Each assessor has a profile: categories they are competent to assess, home region, working days and any conflicts of interest with specific firms.
- For each due visit, the scheduler suggests suitable assessors, prioritising competence, no conflict, and nearby visits already booked.
- The coordinator confirms an assessor, and the firm gets a link to pick from the assessor's available slots within the due window.
- Postponements go through the same link, with the due window enforced, and anything drifting towards overdue is escalated.
- Before each visit the assessor gets a pack (firm details, previous findings, open actions), and completes the report in a form that feeds the firm's record.
| Scheduling input | Where it comes from | How it is used |
|---|---|---|
| Due window | Scheme cycle rules and last visit date | Sets which slots the firm can pick |
| Assessor competence | Assessor profile | Only competent assessors are suggested |
| Conflicts of interest | Assessor declarations | Excludes conflicted assessors |
| Location | Firm and assessor addresses | Groups nearby visits |
| Firm availability | Firm's slot choice | Books the visit |
Assessors' calendars can sync with Outlook or Google Calendar, so a booked visit appears where they already look.
A normal week in the scheme office
The coordinator reviews the due list, confirms assessors for the next batch, and firms pick their own slots. Assessors see their week with visits grouped by area. Postponements happen within the rules without anyone emailing. Reports come back in a standard form, so findings and actions go straight to the firm's record and the next cycle starts itself.
Is your scheduling like this?
- Assessments are scheduled from a spreadsheet sorted by due date.
- Assessor competences are known but not recorded.
- Firms are emailed dates rather than choosing slots.
- Overdue visits are noticed after the fact.
- Assessor reports arrive as Word documents.