Arse2Mouse Predictotron 3000
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKAL
1
Arse2Mouse Predict-o-tron 2016/2017 Premier League Season
2
- Choose W, D, L in yellow cells. Record actual results next to your prediction. The points will autocalc...
3
- Pink-highlighted cells contain logic that will autocalc W/D/L and points based on the value entered for the other team in the match... do not enter values into these boxes
4
- enter league table points as of last FEB results
5
6
Match WeekAFCChelseaMCFCTHFCLFCMUFC
7
OpponentPredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResult
8
points as of March 1stW,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1W,D,L1
9
week 27 - March 4-6Liverpool (A)xxxxWest Ham (A)xxxxSunderland (A)xxxxEverton (A)xxxxArsenal (H)xxxxB'mouth (H)xxxx
10
week 28 - March 11-13
resched. xxxx resched. xxxxStoke (H)xxxx resched. xxxxBurnley (H)xxxx resched. xxxx
11
week 29 - March 18-19
West Brom (A)xxxxStoke (A)xxxxLiverpool (H)xxxxSouthamp (H)xxxxManCity (A)xxxxMidd (A)xxxx
12
week 30 - April 1ManCity (H)xxxxCPalace (H)xxxxArsenal (A)xxxxBurnley (A)xxxxEverton (H)xxxxWest Brom (H)xxxx
13
week 31 - April 4-5West Ham (H)xxxxManCity (H)xxxxChelsea (A)xxxxSwansea (A)xxxxB'mouth (H)xxxxEverton (H)xxxx
14
week 32 - April 8CPalace (A)xxxxB'mouth (A)xxxxHull (H)xxxxWatford (H)xxxxStoke (A)xxxxSunderland (A)xxxx
15
week 33 - April 15-16Midd (A)xxxxManUnited (A)xxxxSouthamp (A)xxxxB'mouth (H)xxxx
West Brom (A)
xxxxChelsea (H)xxxx
16
week 34 - April 22Sunderland (H)xxxxSouthamp (H)xxxx
West Brom (H)
xxxxLeicester (A)xxxxCPalace (H)xxxxBurnley (A)xxxx
17
week 35 - April 29Tott (A)xxxxEverton (A)xxxxMidd (A)xxxxArsenal (H)xxxxWatford (A)xxxxSwansea (H)xxxx
18
week 36 - May 5-6ManUnited (H)xxxxMidd (H)xxxxCPalace (H)xxxxWest Ham (A)xxxxSouthamp (H)xxxxArsenal (A)xxxx
19
week 37 - May 13Stoke (A)xxxxWest Brom (A)xxxxLeicester (H)xxxxManUnited (H)xxxxWest Ham (A)xxxxTott (A)xxxx
20
week 38 - May 21Everton (H)xxxxSunderland (H)xxxxWatford (A)xxxxHull (A)xxxxMidd (H)xxxxCPalace (H)xxxx
21
22
Rescheduled games:Southamp (A)xxxxWatford (H)xxxxManUnited (H)xxxxCPalace (A)xxxx resched. xxxxManCity (A)xxxx
23
Rescheduled games:Leicester (H)xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxxSouthamp (A)xxxx
24
Rescheduled games: resched. xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxx
25
dates per premierleague.com
26
Total Points Predicted
111111
27
Total Points Actual
111111
28
Difference Actual vs Predicted Points
000000
29
# matches predicted correctly
000000
30
31
Rank Predicted
autocalcs111111
32
Rank Actualautocalcs111111
33
34
MINDING THE GAP >>>>>
0
35
36
Tweet or DM me with feedback, questions or ideas to improve this next year.
37
Cheers, Dave (@GiantCalGunner)
38
39
Notes:
40
- range values for 'opponent1617' and 'resultchoose1617' are down below
41
- calcs & formulas to support "# matches predicted correctly" are in the dark gray column for each team, don't delete or edit that column!
42
- I will edit and update this spreadsheet as matches get moved/rescheduled/etc.
43
- if you copy and paste this spreadsheet into your own software or googledoc, some of the data entry validation may not copy over. You might have to do that as a second copy and paste. Then you will need to create the range names using the arrays below. Sorry Googledocs is not perfect :-( Tweet me if you need help
44
45
46
"Resultchoose1617" range
47
xx
48
W3
49
D1
50
L0
51
52
'Opponent1617' range
53
resched.
54
Arsenal (A)
55
Arsenal (H)
56
B'mouth (A)
57
B'mouth (H)
58
Burnley (A)
59
Burnley (H)
60
Chelsea (A)
61
Chelsea (H)
62
CPalace (A)
63
CPalace (H)
64
Everton (A)
65
Everton (H)
66
Hull (A)
67
Hull (H)
68
Leicester (A)
69
Leicester (H)
70
Liverpool (A)
71
Liverpool (H)
72
ManCity (A)
73
ManCity (H)
74
ManUnited (A)
75
ManUnited (H)
76
Midd (A)
77
Midd (H)
78
Southamp (A)
79
Southamp (H)
80
Stoke (A)
81
Stoke (H)
82
Sunderland (A)
83
Sunderland (H)
84
Swansea (A)
85
Swansea (H)
86
Tott (A)
87
Tott (H)
88
Watford (A)
89
Watford (H)
90
West Brom (A)
91
West Brom (H)
92
West Ham (A)
93
West Ham (H)
94
95
96
97
98
99
100
Loading...
 
 
 
2016-2017
2015-2016
2014/2015