Trampoline Park: Jumpers Per Session

All versions

Two separate limits govern a jump session and only one of them binds at a time. Space says how many bodies fit on the court; supervision says how many a monitor can watch. Capacity is the smaller of the two, which is exactly what MIN is for.

Quick formula: The lower of the space limit and the staffing limit:

=MIN(ROUNDDOWN(B2/C2,0),D2*E2)

5,200 sq ft at 90 sq ft a jumper allows 57, while four monitors at 32 each allow 128 — space binds, so 57.

Functions used (tap for the full reference guide):

MIN ROUNDDOWN

The example

Three zones of a park, each with a court area, the space a jumper needs, and the monitors assigned.

	A	B	C	D	E	F
1	Zone	Court sq ft	Sq ft each	Monitors	Per monitor	Capacity
2	Main court	5200	90	4	32	57
3	Foam pit zone	1400	90	1	32	15
4	Toddler court	900	60	1	12	12

The formula

Two limits, one MIN:

=MIN(ROUNDDOWN(B2/C2,0),D2*E2) // space limit vs supervision limit, whichever is smaller

How it works

Compute each limit separately, then take the smaller:

B2/C2 is the space limit. Square feet per jumper comes from your operating manual and the trampoline layout — it is not a number to invent.
ROUNDDOWN(...,0) drops the partial jumper. Capacity always rounds toward safety.
D2*E2 is the supervision limit: monitors times the jumpers one monitor can watch on that surface.
MIN(...) returns whichever binds. Notice the toddler court is staff-bound and the main court is space-bound — the same formula handles both without an IF.

Because MIN shows which limit is active, it also shows the cheapest fix: adding a monitor only helps on the zones where staffing is the smaller number.

Try it: interactive demo

Interactive

Enter the court area, space per jumper, and the monitors on duty.

Court sq ft

Sq ft per jumper

Monitors

Jumpers per monitor

Variations

Which limit is binding?

Label the constraint so a manager knows what to change.

=IF(ROUNDDOWN(B2/C2,0)<D2*E2,"Space","Staffing")

Monitors needed to unlock the space

Solve for the staffing that would let the court fill.

=ROUNDUP(ROUNDDOWN(B2/C2,0)/E2,0)

Park-wide capacity

Sum the zone capacities for a whole-session number.

=SUM(F2:F4)

Pitfalls & errors

Do not average the two limits. Capacity is the smaller one, full stop — averaging a 57-person space limit with a 128-person staffing limit puts 92 people on a court that fits 57.

Square feet per jumper is not the same across surfaces. A foam pit, a dodgeball court and an open jump area each carry their own figure, and the toddler area is stricter still.

Insurance and local code may set a hard cap that sits below both calculations. Wrap the whole thing in another MIN against the posted occupancy if that applies to you.

Practice workbook

📊

Download the free Trampoline Park: Jumpers Per Session practice workbook

Edit the yellow court, space-per-jumper, and monitor cells; capacity recalculates.

Frequently asked questions

Where does square feet per jumper come from?

From the manufacturer's operating guidance and your own layout, not from a rule of thumb. It varies with trampoline size, spacing and the activity on that court, and it is the number an inspector will ask about.

Why MIN rather than nested IFs?

MIN is the rule stated once. An IF chain gives the same answer but has to be rewritten every time a third constraint appears, whereas MIN just takes another argument.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: MIN ROUNDDOWN