Find Unfilled Hours in a School Volunteer Rota — Free
Convert unfilled volunteer places into person-hours while preserving the shift that needs help. Extra volunteers at closing do not cover an empty lunch slot.
The proof surface
Caregiver rotas concern care handoffs; this is staffing arithmetic for school events, without personal records, care instructions or safeguarding judgments.
Why the flat version breaks
Offsetting gaps with surplus elsewhere
A surplus after school cannot staff the lunch slot.
Mixing duration units
Two-hour and half-day shifts need separate runs.
Assuming availability equals eligibility
Training or clearance may still be required.
How to work the rota pegrail
Copy the required headcount for each shift from the event plan. Do not invent a supervision ratio from attendance; the organiser must decide what roles and clearance are required.
Only count people who accepted that exact slot. A general offer to help is not a booked person, and a parent supervising their own child may not fill an event role.
This run uses one duration for every row. Run separate groups for one-hour and two-hour shifts so the multiplication stays meaningful.
The starter is short one morning volunteer and three at lunch, giving eight missing person-hours. Contact the coordinator about those slots rather than publishing volunteers’ names.
What the rota pegrail replaces
| Question | Before | Visible working |
|---|---|---|
| Offsetting gaps with surplus elsewhere | A surplus after school cannot staff the lunch slot. | Count confirmed availability |
| Mixing duration units | Two-hour and half-day shifts need separate runs. | Keep shift lengths consistent |
| Assuming availability equals eligibility | Training or clearance may still be required. | Recruit for the actual gap |
A local arithmetic aid replaces hand calculation, not expert review. No paid AI service is needed.
Run it on the samples, right here
FIRST-LOAD
Input is processed locally. A state link encodes your inputs in its URL: share only non-sensitive rows. Browser history, clipboard and anyone receiving the link may retain it. Optional AI use below leaves this device; it is not required.
This is scheduling arithmetic, not a safeguarding or supervision recommendation. The school coordinator must approve staffing levels and volunteer eligibility.
Data note: Everything runs in this browser tab on the rota pegrail: your shift | people required | confirmed volunteers stays on this device, nothing is uploaded, and the reading is rebuilt only when you press run.
Go deeper: the companion app files the same reading as a triage clipboard with three lanes
The article demo above runs without limits. The companion app keeps a local history, exports the rows as CSV, prints the rota pegrail reading, and holds your drafts on this device — one free run, then $ 4 one-time for the layer that keeps filing.
The rota pegrail reading is complete for free. The optional $4 layer adds print, row CSV and the last five local reading summaries; it does not add hidden answers. Checkout is not configured yet; the article demo remains unlimited.
Open the find unfilled hours in a school volunteer rota companionBoundary
This is scheduling arithmetic, not a safeguarding or supervision recommendation. The school coordinator must approve staffing levels and volunteer eligibility.
What this is built on
- Method: This run uses one duration for every row. Run separate groups for one-hour and two-hour shifts so the multiplication stays meaningful.
- All sample records are invented examples. The app does not fetch measurements, policies, files or personal records.
- Google’s official pricing page, fetched 2026-09-27, lists free-tier access including AI Studio. Optional formatting only; limits and availability can change. Free-tier content may be used to improve products. Never paste private records there.
Before: A surplus after school cannot staff the lunch slot. After: the rota pegrail shows the working beside each named row so the reader can change the assumption and inspect the consequence.
Optional AI formatting, not calculation
For this rota pegrail, use the free AI Studio interface only if available to you, with no paid API key. Manual entry completes the same workflow for free. Supply only fictional or non-sensitive notes. Review its output against the source; never paste unresolved questions into the numeric rows.
Format my non-sensitive notes for a rota pegrail. Return plain rows only: shift | people required | confirmed volunteers. Preserve supplied quantities exactly. Do not guess missing values; list questions separately. Do not calculate or add advice. I will check every row before pasting into the local tool.
Accepted schema: shift | people required | confirmed volunteers. No AI response is executed as code.