Face Painting: Faces You Can Paint

Excel Formulas › Face Painting

All versions

At a busy fair the line is the real limit, not the price. Multiply artists by hours by how many faces one artist paints an hour to see how many kids you can actually get through — and whether to book a second painter.


Quick formula: Artists times hours times faces-per-hour:
=B2*C2*D2

Three artists for four hours at 12 faces an hour clears 144 faces — enough to size the booking honestly.

Functions used (tap for the full reference guide):

The example

Three events, each with a number of artists, hours booked, and faces painted per hour.

ABCDE
1EventArtistsHoursPer hrFaces
2Fair3412144
3Party121530
4Festival231272

The formula

Capacity is just the three inputs multiplied together:

=B2*C2*D2 // artists x hours x faces-per-hour

How it works

Three inputs, one throughput:

  1. B2*C2 is total artist-hours — how many hours of painting the booking provides.
  2. *D2 multiplies by faces-per-hour to turn artist-hours into painted faces.
  3. Faces-per-hour drops for detailed full-face designs and rises for quick cheek art — set it to the style you offer.
  4. If capacity falls short of the expected crowd, add an artist or simplify the designs to raise faces-per-hour.

Compare the capacity to the expected headcount — if the crowd is bigger, you either add an artist or the line will not clear.

Try it: interactive demo

Interactive

Enter the artists, hours, and faces painted per hour.

Variations

Artists to clear a crowd

Solve for artists given an expected number of faces.

=ROUNDUP(200/(C2*D2),0)

Detailed-design pace

Full-face designs run slower — drop the per-hour rate.

=B2*C2*6

Pitfalls & errors

Faces-per-hour is not one number. A quick cheek design and a full-face masterpiece are worlds apart, so use the pace for the style you will actually paint at that event.

Capacity is a ceiling, not a promise. Breaks, no-shows in line, and fussy toddlers all eat into it — book to a bit under the calculated number so you do not turn kids away.

Practice workbook

📊
Download the free Face Painting: Faces You Can Paint practice workbook
Edit the yellow artists, hours, and per-hour cells; the capacity recalculates.

Frequently asked questions

How many faces per hour is realistic?
Quick cheek art can run 15 to 20 an hour, while detailed full-face designs drop to 6 to 10. Use the pace for the style you actually offer at that event, not a best-case number from a quiet day.
How do I know if I need a second artist?
Compare the capacity to the expected crowd. If the number of kids likely to want a face exceeds what one artist can clear in the booked hours, add an artist or the line simply will not get through.

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: Throughput Per Hour · Mobile Bartending: Bartenders Needed · Cycle Time vs Takt

Function references: PRODUCT