Class Capacity Utilization

Excel Formulas › Fitness & Gym

All versions

For a gym or studio, capacity utilization is attendees over class capacity — how full sessions run. It guides scheduling, staffing, and whether to add classes.

Quick formula: utilization from attendance and capacity:
=attendance / capacity
Attendees over the class capacity, as a percentage. Average across classes for a schedule-wide view.

The example

18 attendees, 24 spots.

AB
1ItemValue
2Attendance18
3Capacity24 → 75%

The formula

The formula:

=B2 / B3 // attendance ÷ capacity

How it works

How it works:

  1. Divide attendance by class capacity for utilization.
  2. Average across the schedule with AVERAGE, or weight by capacity with SUMPRODUCT.
  3. Consistently full classes signal demand to add sessions; empty ones to cut or reschedule.
  4. Compare by time slot and instructor with AVERAGEIFS to optimize the timetable.

Educational use only. These are general Excel formulas for learning spreadsheet techniques — estimates only, not training, medical, or nutrition advice. Individual results vary; consult a qualified professional before acting on them.

Try it: interactive demo

Live demo

Attendance and capacity.

Utilization · Empty

Variations

Schedule average

All classes:

=AVERAGE(utilization_range)

Empty spots

Open capacity:

=capacity - attendance

By time slot

Best hours:

=AVERAGEIFS(util, slot, "6pm")

Pitfalls & errors

Define capacity. Physical limit vs booked limit can differ.

Average right. Weight by capacity if class sizes vary widely.

Zero capacity. A missing capacity gives #DIV/0!.

Practice workbook

📊
Download the free Class Capacity Utilization practice workbook
A capacity sheet with the schedule-average, empty-spots, and by-slot variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate class capacity utilization in Excel?
Divide attendance by capacity: =attendance / capacity. 18 of 24 is 75%.
How do I see utilization across the schedule?
Average the per-class rates with AVERAGE, or AVERAGEIFS by time slot or instructor.
What does utilization tell me?
Consistently full classes signal demand to add sessions; empty ones to cut or reschedule.

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

Related formulas: Bed occupancy rate · Occupancy rate · Average by group