ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Urban Axes — Variety Show Yahtzee Scoring Workbook
2
3
How this workbook is organized
4
There is one tab per Heat + Arena color (e.g. "Heat 1 Green"). Each tab scores one team's run through all six Yahtzee throwing goals.
5
A "Rankings" tab at the end automatically pulls every team's total score from all 16 heat tabs into one list.
6
7
For each coach on an iPad
8
1. Open the tab that matches your arena color and the current heat number. Hide/unhide tabs as heats finish (right-click a tab > Hide/Unhide sheet).
9
2. Enter the Team Name in the yellow cell at the top.
10
3. For each Lane (1-4), enter the thrower's name and the throw type they've chosen (dropdown).
11
4. For each goal, tap the yellow "Attempt" cell and choose the attempt number they hit on: 1, 2, 3, or M (missed all three).
12
5. For Straight, also pick the Target they declared (1, 3, 5, or Clutch) before they threw.
13
6. For Clutches: if a thrower misses all 3 attempts but the other 3 lanes already hit within their first 3 attempts, that thrower gets one bonus attempt. Record it in the "Save" column as Hit or Miss. Leave Save as N/A otherwise.
14
7. The Goal Score row and Team Total calculate automatically. The Status cell tells you if any entries are still missing.
15
16
Scoring logic (built into the formulas)
17
- A goal only pays its full point value if every one of the 4 throwers completes it within 3 attempts (Clutch bonus attempt is the one exception below).
18
- Every missed attempt (by any thrower, whether or not the team ultimately completes the goal) is a -10 point deduction.
19
- If any thrower fails to complete a goal within 3 attempts (no eligible bonus), the team scores 0 for that goal, but all -10 deductions still apply.
20
- Clutches: if exactly 3 of 4 throwers hit within 3 attempts, the 4th gets a bonus attempt. If they hit it, the team completes the goal but the max value drops to 750 (their share is forfeited). If they miss the bonus, the goal scores 0, plus the extra -10 for that missed bonus attempt.
21
22
Example
23
All 1s (100 pts), 4 throwers: hits on 1st, 1st, 2nd, 3rd attempt -> team completes the goal (100 pts) minus 10x(0+0+1+2) missed attempts = 100 - 30 = 70 points.
24
25
Cell color legend:
26
Yellow fill = cell the coach fills in
27
Green fill = auto-calculated score (do not edit)
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100