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)D1D11 resched. xxxxBurnley (H)W3W31 resched. xxxx
8
week 29 - March 18-19
West Brom (A)L0L01Stoke (A)W3W31Liverpool (H)D1D11Southamp (H)W3W31ManCity (A)D1D11Midd (A)W3W31
9
week 30 - April 1ManCity (H)D1D11CPalace (H)L0L01Arsenal (A)D1D11Burnley (A)W3W31Everton (H)W3W31West Brom (H)D1D11
10
week 31 - April 4-5West Ham (H)W3W31ManCity (H)W3W31Chelsea (A)L0L01Swansea (A)W3W31B'mouth (H)D1D11Everton (H)D1D11
11
week 32 - April 8CPalace (A)L0L01B'mouth (A)W3W31Hull (H)W3W31Watford (H)W3W31Stoke (A)W3W31Sunderland (A)W3W31
12
week 33 - April 15-17Midd (A)W3W31ManUnited (A)L0L01Southamp (A)W3W31B'mouth (H)W3W31West Brom (A)W3W31Chelsea (H)W3W31
13
week 34 - April 22 resched. xxxxSouthamp (H)W3W31 resched. xxxx resched. xxxxCPalace (H)L0L01Burnley (A)W3W31
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)D1D11CPalace (A)W3W31 resched. xxxxManCity (A)D1D11
20
Rescheduled games:Leicester (H)W3W31 resched. xxxxWest Brom (H)xxxxLeicester (A)xxxx resched. xxxxSouthamp (A)xxxx
21
Rescheduled games:Sunderland (H)xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxx resched. xxxx
22
dates per premierleague.com
23
Total Points Predicted
607865746664
24
Total Points Actual
607865746664
25
Difference Actual vs Predicted Points
000000
26
# matches predicted correctly
778788
27
28
Rank Predicted
autocalcs614235
29
Rank Actualautocalcs614235
30
31
MINDING THE GAP >>>>>
-14
32
33
Instructions
34
- Choose W, D, L in yellow cells. Record actual results next to your prediction. The points will autocalc... I did NOT autocalc a group prediction based on individual votes (this time!)
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
D1
46
L0
47
W3
48
xx
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
DWWWW933339WW
96
WWWD763317W
97
WWWL
draw or win?
63306W
98
DWDD53115D
99
DWDL43104D
100
DWLL
Loss or draw?
33003D
Loading...
 
 
 
2016-2017
2015-2016
2014/2015