Basic Football Scorinator for Public Enjoyment.xlsx

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	General Settings:		Maximum Theoretical Contribution		Percentile to GD Cutoffs						Cutoffs to GD
2	Randomness Weight (0-5)	3	600	28.57%	From	To	GD	From	To	GD	From	To	GD	From	To	GD
3	RP Post Weight (0-5)	5	1500	71.43%	∞	100	ERROR	8	-8	0	∞	2100	ERROR	168	-168	0
4	Skill Weight (0-5)	0	0	0.00%	100	99	10	-8	-20	-1	2100	2079	10	-168	-420	-1
5	RP Post Ceiling (0-5)	3			99	95	9	-20	-30	-2	2079	1995	9	-420	-630	-2
6	(0 = none \| 5 = heaviest)				95	90	8	-30	-40	-3	1995	1890	8	-630	-840	-3
7	Maximum Theoretical Outcome		2100		90	80	7	-40	-50	-4	1890	1680	7	-840	-1050	-4
8	Percentile Conversion Factor		21		80	70	6	-50	-65	-5	1680	1470	6	-1050	-1365	-5
9					70	60	5	-65	-80	-6	1470	1260	5	-1365	-1680	-6
10	Cells in YELLOW are cells that you can change.				60	50	4	-80	-90	-7	1260	1050	4	-1680	-1890	-7
11	IMPORTANT: When copying results to another sheet, remember to COPY and PASTE VALUES.				50	38	3	-90	-95	-8	1050	798	3	-1890	-1995	-8
12					38	23	2	-95	-99	-9	798	483	2	-1995	-2079	-9
13					23	8	1	-99	-100	-10	483	168	1	-2079	-2100	-10
14					10	AET	-10	-100	-∞	ERROR	210	AET	-210	-2100	-∞	ERROR
15	Score Now!	YES
16		(put YES above when ready to score)
17
18	Start copying below this line
19
20		Team A	Team B		BaseScoreA	Base ScoreB	RP Effect	Skill Effect	Outcome	GD	Random	UpperRandomLimit	RandomA1	RandomA2	RandProportionA	RandomB1	RandomB2	RandProportionB
21	Modifiers				67.67	52.56	0	0	15.11	0	Components	600	27	110	51	36	82	64
22	RP Posts	0	0						AET?	NO	RP and Skill	Post Difference	LesserPosts	RPWtLower	RPWtUpper	RPWtProportion	RPMultiplier	Skill Difference	SkillWtProportion	SkillMultiplier
23	Skill (0-5)	0	0								Bonuses	0	0	50	100	76	380	0	65	0
24	Results										Score	AbsValGD	Seed10	Seed10	Seed10	Seed10	Seed10	LoserGoals	WinnerGoals	FinalScoreA	FinalScoreB	HalftimeScoreA	HalftimeScoreB
25	Final Score	1	1								Creator	0	-2	2	9	-4	10	1	1	1	1	0	1
26	Halftime Score	0	1								Penalty Shootout	PenShootoutA	0	1	1	1	0	3	0	3
27	Penalty Shootout										Randomiser	PenShootoutB	1	1	1	0	1	4	0	4
28	Need to force win?	NO																	Tiebreak	PenShootoutScore
29
30	Stop copying above this line
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