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...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1
Arse2Mouse Predict-o-tron 2016/2017 Premier League Season
2
3
Match WeekAFCChelseaMCFCTHFCLFCMUFC
4
OpponentTimElliotDaveGroup PredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResult
5
points as of March 1stW,D,L50W,D,L50W,D,L63W,D,L63W,D,L52W,D,L52W,D,L53W,D,L53W,D,L49W,D,L49W,D,L48W,D,L48
6
week 27 - March 4-6Liverpool (A)L0L01West Ham (A)W3W31Sunderland (A)W3W31Everton (A)W3W31Arsenal (H)W3W31B'mouth (H)D1D11
7
week 28 - March 11-13
resched. xxxx resched. xxxxStoke (H)xxxx resched. xxxxBurnley (H)xxxx resched. xxxx
8
week 29 - March 18-19
West Brom (A)xxxxStoke (A)xxxxLiverpool (H)xxxxSouthamp (H)xxxxManCity (A)xxxxMidd (A)xxxx
9
week 30 - April 1ManCity (H)xxxxCPalace (H)xxxxArsenal (A)xxxxBurnley (A)xxxxEverton (H)xxxxWest Brom (H)xxxx
10
week 31 - April 4-5West Ham (H)xxxxManCity (H)xxxxChelsea (A)xxxxSwansea (A)xxxxB'mouth (H)xxxxEverton (H)xxxx
11
week 32 - April 8CPalace (A)xxxxB'mouth (A)xxxxHull (H)xxxxWatford (H)xxxxStoke (A)xxxxSunderland (A)xxxx
12
week 33 - April 15-16Midd (A)xxxxManUnited (A)xxxxSouthamp (A)xxxxB'mouth (H)xxxxWest Brom (A)xxxxChelsea (H)xxxx
13
week 34 - April 22Sunderland (H)xxxxSouthamp (H)xxxxWest Brom (H)xxxxLeicester (A)xxxxCPalace (H)xxxxBurnley (A)xxxx
14
week 35 - April 29Tott (A)xxxxEverton (A)xxxxMidd (A)xxxxArsenal (H)xxxxWatford (A)xxxxSwansea (H)xxxx
15
week 36 - May 5-6ManUnited (H)xxxxMidd (H)xxxxCPalace (H)xxxxWest Ham (A)xxxxSouthamp (H)xxxxArsenal (A)xxxx
16
week 37 - May 13Stoke (A)xxxxWest Brom (A)xxxxLeicester (H)xxxxManUnited (H)xxxxWest Ham (A)xxxxTott (A)xxxx
17
week 38 - May 21Everton (H)xxxxSunderland (H)xxxxWatford (A)xxxxHull (A)xxxxMidd (H)xxxxCPalace (H)xxxx
18
19
Rescheduled games:Southamp (A)xxxxWatford (H)xxxxManUnited (H)xxxxCPalace (A)xxxx resched. xxxxManCity (A)xxxx
20
Rescheduled games:Leicester (H)xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxxSouthamp (A)xxxx
21
Rescheduled games: resched. xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxx
22
dates per premierleague.com
23
Total Points Predicted
506655565249
24
Total Points Actual
506655565249
25
Difference Actual vs Predicted Points
000000
26
# matches predicted correctly
111111
27
28
Rank Predicted
autocalcs513246
29
Rank Actualautocalcs513246
30
31
MINDING THE GAP >>>>>
-6
32
33
Instructions
34
- Choose W, D, L in yellow cells. Record actual results next to your prediction. The points will autocalc...
35
- 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
36
- enter league table points as of last FEB results
37
38
Notes:
39
- range values for 'opponent1617' and 'resultchoose1617' are down below
40
- calcs & formulas to support "# matches predicted correctly" are in the dark gray column for each team, don't delete or edit that column!
41
- 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, or recreate it (under Data menu). Use the range names for the choice arrays below. Sorry Googledocs is not perfect :-( Tweet me if you need help
42
43
44
"Resultchoose1617" range
45
xx
46
W3
47
D1
48
L0
49
50
'Opponent1617' range
51
resched.
52
Arsenal (A)
53
Arsenal (H)
54
B'mouth (A)
55
B'mouth (H)
56
Burnley (A)
57
Burnley (H)
58
Chelsea (A)
59
Chelsea (H)
60
CPalace (A)
61
CPalace (H)
62
Everton (A)
63
Everton (H)
64
Hull (A)
65
Hull (H)
66
Leicester (A)
67
Leicester (H)
68
Liverpool (A)
69
Liverpool (H)
70
ManCity (A)
71
ManCity (H)
72
ManUnited (A)
73
ManUnited (H)
74
Midd (A)
75
Midd (H)
76
Southamp (A)
77
Southamp (H)
78
Stoke (A)
79
Stoke (H)
80
Sunderland (A)
81
Sunderland (H)
82
Swansea (A)
83
Swansea (H)
84
Tott (A)
85
Tott (H)
86
Watford (A)
87
Watford (H)
88
West Brom (A)
89
West Brom (H)
90
West Ham (A)
91
West Ham (H)
92
93
94
Formula testTeam choice123Pts
95
DWWWW93
96
WWWD70
97
WWWL
draw or win?
6
98
DWDD5
99
DWDL4
100
DWLL
Loss or draw?
3
Loading...
 
 
 
2016-2017
2015-2016
2014/2015