Arial Assist Scoring Analysis

Still loading...

	A	B	C	D	E	F	G	H	I	K	L
1	Input
2	Output
3	Constants
4	A = Assist
5	T = Truss
6	C = Catch
7
8		Upper Goal								Variables
9	Cycle	1A	1A+T	2A	2A + T	2A + T + C	3A	3A+T	3A+T+C	Match Length (sec)	140
10	Estimated Time Per Cycle	15	25	10	20	20	15	30	20	Catching Percentage	75%
11	Points Per Cycle	7.5	15	15	22.5	28.125	30	37.5	43.125	Upper Goal Percentage	75%
12	# Cycles	9	5	14	7	7	9	4	7	Lower Goal Percentage	100%
13	Theoretical Max Score	68	75	210	158	197	270	150	302
14										Points
15		Lower Goal								Upper Goal	10
16	Cycle	1A	1A+T	2A	2A + T	2A + T + C	3A	3A+T	3A+T+C	Lower Goal	1
17	Estimated Time Per Cycle	20	30	15	25	25	20	35	35	1 Assist	0
18	Points Per Cycle	1	11	11	21	28.5	31	41	48.5	2 Assists	10
19	# Cycles	7	4	9	5	5	7	4	4	3 Assists	30
20	Theoretical Max Score	7	44	99	105	143	217	164	194	Catch	10
21										Truss	10
22
23
24	Variables are blue, constants are grey, and calculated output is green. Cycle time is used to determine the max number of cycles you can get if you only use that type of cycle. Points are then calculated based on how many cycles you can do. If you want to change a formula, please make a copy of the spreadsheet first (aka, don't change the formulas in this spreadsheet).
25
26
27
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