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...
ABCDEFGHIJKLMNOPQRSTUVWXYAFAGAHAIAJAKAL
1
2
Arse2Mouse Predict-o-tron -- 2015/2016 Premier League Season
3
- Choose W, D, L in yellow cells. Record actual results next to your prediction. The points will autocalc...
4
- 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
5
6
Match WeekAFCLCFCMCFCTHFC
7
OpponentPredictionResultOpponentPredictionResultOpponentPredictionResultOpponentPredictionResult
8
points as of FEB 26W,D,L51W,D,L51W,D,L53W,D,L53W,D,L47W,D,L47W,D,L51W,D,L51
9
week 27 - Feb 27 & 28ManUnited (A)W3L00Norwich (H)W3W31 resched. xxxxSwansea (H)W3W31
x ManCity match vs NUFC rescheduled due to COC Final. Date not announced yet.
10
week 28 - Mar 1 & 2 (Tue/Wed)
Swansea (H)W3L00West Brom (H)D1D11Liverpool (A)W3L00West Ham (A)D1L00
11
week 29 - Mar 5 & 6Tott (A)D1D11Watford (A)D1W30AVilla (H)W3W31Arsenal (H)D1D11
12
week 30 - Mar 12, 13, 14 resched. xxxxNewcastle (H)W3W31Norwich (A)W3D10AVilla (A)W3W31
x Arsenal West Brom match rescheduled due to FA Cup
13
week 31 - Mar 19 & 20Everton (A)L0W30CPalace (A)W3W31ManUnited (H)D1L00AFCB (H)W3W31
14
week 32 - Apr 2Watford (H)W3W31Southamp (H)D1W30AFCB (A)D1W30Liverpool (A)D1D11
15
week 33 - Apr 9West Ham (A)D1D11Sunderland (A)W3W31West Brom (H)W3W31ManUnited (H)D1W30
16
week 34 - Apr 16CPalace (H)W3D10West Ham (H)W3D10Chelsea (A)L0W30Stoke (A)D1W30
17
week 35 - Apr 23Sunderland (A)W3D10Swansea (H)W3W31Stoke (H)W3W31West Brom (H)W3D10
18
week 36 - Apr 30Norwich (H)W3xxManUnited (A)L0xxSouthamp (A)D1xxChelsea (A)L0xx
19
week 37 - May 7ManCity (A)D1xxEverton (H)D1xxArsenal (H)D1xxSouthamp (H)W3xx
20
week 38 - May 15 (Sunday)
AVilla (H)W3xxChelsea (A)L0xxSwansea (A)W3xxNewcastle (A)W3xx
21
22
Rescheduled: AFC Apr21 MC Apr 19
West Brom (H)W3W31xxxxNewcastle (A)W3D10xxxx
23
Rescheduled games:xxxxxxxxxxxxxxxx
24
Rescheduled games:xxxxxxxxxxxxxxxx
25
dates per premierleague.com
26
Total Points Predicted
78757274
27
Total Points Actual
64766469
28
Difference Actual vs Predicted Points
-141-8-5
29
# matches predicted correctly
4635
30
31
Rank Predictedautocalcs1243
32
Rank Actualautocalcs3132
33
34
MINDING THE GAP >>>>>
-5
35
36
37
I hope you all like the enhancements this season. Enjoy!
38
Tweet or DM me with feedback, questions or ideas to improve this next year.
39
Cheers, Dave (@GiantCalGunner)
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
Notes:
59
- range values for 'opponents' and 'resultchoose' are down below
60
- calcs & formulas to support "# matches predicted correctly" are in the dark gray column for each team, don't delete or edit that column!
61
- I will edit and update this spreadsheet as matches get moved/rescheduled/etc.
62
63
- USE THE "MAKE A COPY" feature under the File pulldown menu to create your own version and predict away!
64
65
66
67
"Resultchoose" range
select the highlighted array below and name the range 'resultchoose'
68
xx
69
W3
70
D1
71
L0
72
73
'Opponents' range
select the highlighted array below and name the range 'opponents'
74
resched.
75
AFCB (A)
76
AFCB (H)
77
Arsenal (A)
78
Arsenal (H)
79
AVilla (A)
80
AVilla (H)
81
Chelsea (A)
82
Chelsea (H)
83
CPalace (A)
84
CPalace (H)
85
Everton (A)
86
Everton (H)
87
Leicester (A)
88
Leicester (H)
89
Liverpool (A)
90
Liverpool (H)
91
ManCity (A)
92
ManCity (H)
93
ManUnited (A)
94
ManUnited (H)
95
Newcastle (A)
96
Newcastle (H)
97
Norwich (A)
98
Norwich (H)
99
Southamp (A)
100
Southamp (H)
Loading...
 
 
 
2015-2016
2014/2015