A coach with fourteen players and a bucket of tokens is running a math problem, not a practice. Swings per player times bodies gives the pitch count; the token machine turns that into a purchase, and it only sells whole tokens.
14 players at 45 swings each is 630 pitches — 32 twenty-pitch tokens, because 31.5 does not exist.
The example
Three practice plans, each with a roster size, a swing target, and the pitch count that machine's token delivers.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Practice | Players | Swings each | Pitches/token | Tokens |
| 2 | Full team | 14 | 45 | 20 | 32 |
| 3 | Infield group | 9 | 60 | 20 | 27 |
| 4 | Youth clinic | 18 | 30 | 25 | 22 |
The formula
Pitches first, then tokens:
How it works
Three inputs, one per party:
B2*C2is total pitches. Swings each is the coach's plan — a normal round is 30 to 50 depending on how many rounds the session runs./D2is the machine's spec. Cages vary from 12 to 30 pitches a token; do not assume it is the same across every cage in the building.ROUNDUP(...,0)puts the last partial token on the card. Running out with two hitters left is the failure this formula prevents.- Multiply the token count by the token price and the coach has a budget number before anyone walks in.
If the facility sells cage time rather than tokens, swap the denominator for pitches per minute and the same structure gives you minutes.
Try it: interactive demo
Enter the roster size, swings per player, and pitches per token.
Variations
Cost of the practice
Multiply tokens by the token price for a coach-facing number.
Cage minutes instead of tokens
When the cage bills by time, divide pitches by pitches per minute.
Pitfalls & errors
One token does not equal one hitter's round. Most rounds are 8 to 12 swings, so a 20-pitch token covers about two rounds — the multiplication has to be pitches, not rounds.
Add 10% for fouled-off and missed pitches if the machine counts every ball thrown rather than every ball hit. Younger groups need more of a buffer than travel teams.
Do not split the roster across cages and then divide the token count. Each cage rounds up separately, so two cages of seven players cost more tokens than one cage of fourteen.
Practice workbook
Frequently asked questions
How many swings should a practice plan?
Do soft-toss and tee work count?
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