School pickup authorization rota calculator

Calculate named assignment table [event ID,assigned people] and unfilled demand [event ID,missing people] with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use named assignment table [event ID,assigned people] and unfilled demand [event ID,missing people] to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Pickups JSON [ID,start minute,end minute,adults required,explicit approved adult IDs]
[["Mon",900,910,1,["A","B"]],["Tue",2340,2350,1,["A","B"]]]
Adult availability JSON [ID,start minute,end minute]
[["A",880,920],["B",2320,2360]]
Named assignment table [event ID,assigned people]
[["Mon",["A"]],["Tue",["B"]]]
Unfilled demand [event ID,missing people]
[]
Unfilled person-event positions
0

Try another scenario

Pickups JSON [ID,start minute,end minute,adults required,explicit approved adult IDs]
[["Mon",900,910,1,["A","B"]],["Tue",2340,2350,1,["A","B"]]]
Adult availability JSON [ID,start minute,end minute]
[["A",880,920]]
Named assignment table [event ID,assigned people]
[["Mon",["A"]],["Tue",[]]]
Unfilled demand [event ID,missing people]
[["Tue",1]]
Unfilled person-event positions
1
Calculation method

Calculation method

Named assignment table [event ID,assigned people]

Process fixed events by start, then ID; choose lexicographically smallest eligible people whose availability covers event and who have no assigned overlapping event.

Unfilled demand [event ID,missing people]

Required headcount minus assigned, report positives.

Unfilled person-event positions

Sum headcount deficits.

Symbols and units
a
Pickups JSON [ID,start minute,end minute,adults required,explicit approved adult IDs]
b
Adult availability JSON [ID,start minute,end minute]

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Permission-aware fixed pickup assignment using supplied approved names only. No legal authorization is created or verified. Single weekly minute axis; travel between pickups must already be included in event windows. Supported limits: Unique pickups; required positive integers; 0<=start<end<=10080; 1..100 events/people; supplied eligibility and availability explicit.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.