Stronghold score simulation - Google Sheets

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Comments

Still loading...

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Action	Time for action (sec)	Points	Success rate		Actions with cycle	Time for cycle	score per cycle	cycles per match	Match score		Match length
2	Portcullis	3	5	80.00%		Cross defense low goal	17	1.60	7.94	12.71		135
3	Cheval de frise	7	5	70.00%		Cross defense high goal	17	3.00	7.94	23.82
4	Moat	3	5	90.00%
5	Ramparts	4	5	90.00%
6	Drawbridge	8	5	60.00%
7	Sally port	9	5	50.00%
8	Rock wall	4	5	80.00%
9	Rough terrain	3	5	80.00%
10	Low bar	2	5	90.00%
11	Low goal	5	2	80.00%
12	High goal	5	5	60.00%
13
14	Driving constant	8	-----	-----
15	Defense constant	1	-----	-----
16	Crossing defense	3	(shooting cycle)	-----
17							IDEAL	IDEAL	REAL	REAL
18	scenario	score	score/time ideal	score/time real		Weaken defense	time to weaken	time to breach	time to weaken	time to breach
19	Portcullis	5	0.42	0.33		Portcullis	12	24	15.00	30.00
20	cheval de frise	5	0.31	0.22		cheval de frise	16	32	22.86	45.71
21	Moat	5	0.42	0.38		Moat	12	24	13.33	26.67
22	Ramparts	5	0.38	3.60		Ramparts	13	26	14.44	28.89
23	Drawbridge	5	0.29	0.18		Drawbridge	17	34	28.33	56.67
24	Sally port	5	0.28	0.14		Sally port	18	36	36	72
25	Rock wall	5	0.38	0.31		Rock wall	13	26	16.25	32.50
26	Rough terrain	5	0.42	0.33		Rough terrain	12	24	15.00	30.00
27	Low bar	5	0.45	0.41		Low bar	11	22	12.22	24.44
28	low goal	2	0.14	0.11		total	67.5	135	92.83	185.66
29	high goal	5	0.36	0.21
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

Loading...