Spreadsheet: 328287d1403855931-football-predictor-football-prediction
Sheet: Score Prediction

 | manual calculation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | automatic calculation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide
 | Fixtures |  |  | result | BH |  | EMcK |  | GF |  | GM |  | IF |  | JMcL |  |  |  |  | Fixtures |  |  | result |  | BH |  |  |  | EMcK |  |  |  | GF |  |  |  | GM |  |  |  | IF |  |  |  | JMcL |  |  |  |  |  |  | Chelsea
 | Cardiff | vs. | Chelsea | 1-2 | 0-2 | 4 | 1-2 | 5 | 1-2 | 5 | 0-3 | 3 | 0-2 | 4 | 0-3 | 3 |  |  |  | Cardiff | vs. | Chelsea | 1 | 2 | 0 | 2 |  |  | 1 | 2 |  |  | 1 | 2 |  |  | 0 | 3 |  |  | 0 | 2 |  |  | 0 | 3 |  |  |  |  |  | Crystal Palace
 | Fulham | vs. | Crystal Palace | 2-2 | 1-1 | 3 | 1-3 | 0 | 1-1 | 3 | 1-3 | 0 | 0-1 | 0 | 0-2 | 0 |  |  |  | Fulham | vs. | Crystal Palace | 2 | 2 | 1 | 1 |  |  | 1 | 3 |  |  | 1 | 1 |  |  | 1 | 3 |  |  | 0 | 1 |  |  | 0 | 2 |  |  |  |  |  | Everton
 | Hull | vs. | Everton | 0-2 | 0-2 | 5 | 0-2 | 5 | 0-2 | 5 | 1-2 | 4 | 1-1 | 0 | 1-2 | 4 |  |  |  | Hull | vs. | Everton | 0 | 2 | 0 | 2 |  |  | 0 | 2 |  |  | 0 | 2 |  |  | 1 | 2 |  |  | 1 | 1 |  |  | 1 | 2 |  |  |  |  |  | Fulham
 | Liverpool | vs. | Newcastle | 2-1 | 3-1 | 4 | 3-0 | 3 | 2-1 | 5 | 4-0 | 3 | 3-0 | 3 | 2-0 | 4 |  |  |  | Liverpool | vs. | Newcastle | 2 | 1 | 3 | 1 |  |  | 3 | 0 |  |  | 2 | 1 |  |  | 4 | 0 |  |  | 3 | 0 |  |  | 2 | 0 |  |  |  |  |  | Hull
 | Man City | vs. | West Ham | 2-0 | 5-1 | 3 | 3-0 | 4 | 3-0 | 4 | 3-1 | 3 | 2-0 | 5 | 5-0 | 4 |  |  |  | Man City | vs. | West Ham | 2 | 0 | 5 | 1 |  |  | 3 | 0 |  |  | 3 | 0 |  |  | 3 | 1 |  |  | 2 | 0 |  |  | 5 | 0 |  |  |  |  |  | Liverpool
 | [NAME] | vs. | Arsenal | 0-2 | 1-2 | 4 | 0-2 | 5 | 1-2 | 4 | 1-3 | 3 | 0-1 | 4 | 0-3 | 4 |  |  |  | [NAME] | vs. | Arsenal | 0 | 2 | 1 | 2 |  |  | 0 | 2 |  |  | 1 | 2 |  |  | 1 | 3 |  |  | 0 | 1 |  |  | 0 | 3 |  |  |  |  |  | Man City
 | Southampton | vs. | Man Utd | 1-1 | 1-2 | 0 | 2-2 | 3 | 2-2 | 3 | 1-2 | 0 | 1-1 | 5 | 2-1 | 0 |  |  |  | Southampton | vs. | Man Utd | 1 | 1 | 1 | 2 |  |  | 2 | 2 |  |  | 2 | 2 |  |  | 1 | 2 |  |  | 1 | 1 |  |  | 2 | 1 |  |  |  |  |  | Man Utd
 | Sunderland | vs. | Swansea | 1-3 | 2-0 | 0 | 2-1 | 0 | 0-1 | 3 | 3-0 | 0 | 1-0 | 0 | 2-1 | 0 |  |  |  | Sunderland | vs. | Swansea | 1 | 3 | 2 | 0 |  |  | 2 | 1 |  |  | 0 | 1 |  |  | 3 | 0 |  |  | 1 | 0 |  |  | 2 | 1 |  |  |  |  |  | Newcastle
 | Tottenham | vs. | [NAME] | 3-0 | 2-0 | 4 | 2-0 | 4 | 3-1 | 4 | 2-1 | 3 | 2-0 | 4 | 2-0 | 4 |  |  |  | Tottenham | vs. | [NAME] | 3 | 0 | 2 | 0 |  |  | 2 | 0 |  |  | 3 | 1 |  |  | 2 | 1 |  |  | 2 | 0 |  |  | 2 | 0 |  |  |  |  |  | [NAME]
 | West Brom | vs. | Stoke | 1-2 | 1-0 | 0 | 0-1 | 3 | 0-1 | 3 | 2-3 | 3 | 0-1 | 3 | 0-1 | 3 |  |  |  | West Brom | vs. | Stoke | 1 | 2 | 1 | 0 |  |  | 0 | 1 |  |  | 0 | 1 |  |  | 2 | 3 |  |  | 0 | 1 |  |  | 0 | 1 |  |  |  |  |  | Southampton
 |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoke
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunderland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swansea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tottenham
 |  | 5 | points correct score and result |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Brom
 |  | 3 | points correct result wrong score |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Ham
 |  | 1 | bonus point if part of correct result but wrong score is correct, i.e. predict 3-1 result 2-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I hide column AG, AK, AO, AS, and AW
 |  | 0 | points for anything else |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column AC can hide them.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | See Column AB? I use =IF(AC6=1,0,IF(AC6<8,AC6)) copy down
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I made it shorter on Column AC6 =IF(COUNT($X6:$Y6,Z6:AA6)=4,IF(SIGN($X6-$Y6)=SIGN(Z6-AA6),3,0)+($X6=Z6)+($Y6=AA6),"") copy down
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Why getting a 1 instead 0? See cell U12 Southampton v Man Utd 1-1?  [NAME] and AA6 Prediction 1-2 See X6 and [NAME] both got 1? That the reason why it getting a 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | instead 0!! I try so many different formulas? Still not getting 0!!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Only way make up other column what you see now Column AB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Regard
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | micope21