Keep the decision fields together.
- Squad / group
- Player ID
- Print name (optional)
- Jersey number
- Role
- Top product and size
- Bottom product and size
- Quantity
- Notes
- Duplicate-number check
Collect player sizes, garment quantities, names and numbers in one controlled teamwear roster, with duplicate-number checks and a size summary.
The important fields remain readable on this page. The Excel file adds editable cells, dropdowns, checks or formulas where relevant.
| Squad | Player ID | Print name | No. | Top | Bottom | Quantity |
|---|---|---|---|---|---|---|
| U18 A | Player 01 | RIVERA | 8 | Top A / M | Short A / M | 1 set |
| U18 A | Player 02 | CHEN | 12 | Top B / L | Short A / L | 1 set |
| U18 B | Player 03 | MORGAN | 8 | Top A / M | Short A / M | 1 set |
Confirm the selected garment and its own size reference.
Give one person responsibility for the master file.
Enter one wearer per row and keep tops and bottoms separate.
Review duplicate numbers within each squad.
Freeze and approve one final version before production release.
Using a universal size label across different garments.
Collecting changes in several chat threads.
Assuming the same number cannot appear in different squads.
Adding unnecessary personal contact data.
Yes. The workbook checks duplicates within the same squad or group, not across unrelated squads.
No. Size labels must be checked against the selected product and its approved measurement reference.
No. Print name is optional; use a non-identifying player ID when a name is not needed.