Spreadsheet: 22235d1210858970-formula-football-scores-and-table-groupa
Sheet: Group A

 | Group A
 | Pos |  |  | Team |  |  |  | PLD |  | W |  |  | D | L | F | A |  | [NAME] | Pts |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 | 2008-08-12 00:00:00
 | 1 | a | 1 | Team 1 |  |  |  | 2 |  | 0 |  |  | 1 | 1 | 0 | 3 |  | -3 | 1 |  | At the moment I have to manually drag I14 & K14 down to I18 & K18 to work out the scores for week 1 |  |  |  |  |  |  |  |  |  |  |  |  | Week 2 | 2008-08-19 00:00:00
 | 2 | b | 2 | Team 2 |  |  |  | 2 |  | 0 |  |  | 2 | 0 | 0 | 0 |  | 0 | 2 |  | this then changes the table |  |  |  |  |  |  |  |  |  |  |  |  | Week 3 | 2008-08-26 00:00:00
 | 3 | c | 3 | Team 3 |  |  |  | 2 |  | 0 |  |  | 2 | 0 | 0 | 0 |  | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 4 | 2008-09-02 00:00:00
 | 4 | d | 4 | Team 4 |  |  |  | 2 |  | 1 |  |  | 1 | 0 | 4 | 0 |  | 4 | 4 |  | I have not touched week 2 because im just showing what it looks like before I drag I20 & K20 |  |  |  |  |  |  |  |  |  |  |  |  | Week 5 | 2008-09-09 00:00:00
 | 5 | e | 5 | Team 5 |  |  |  | 2 |  | 1 |  |  | 1 | 0 | 3 | 0 |  | 3 | 4 |  | down and leaving this does not effect the table. |  |  |  |  |  |  |  |  |  |  |  |  | Week 6 | 2008-09-16 00:00:00
 | 6 | f | 6 | Team 6 |  |  |  | 2 |  | 1 |  |  | 1 | 0 | 3 | 0 |  | 3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7 | 2008-09-23 00:00:00
 | 7 | g | 7 | Team 7 |  |  |  | 2 |  | 0 |  |  | 1 | 1 | 0 | 3 |  | -3 | 1 |  | But my aim is have a formula already in place without me doing any dragging, but this then |  |  |  |  |  |  |  |  |  |  |  |  | Week 8 | 2008-09-30 00:00:00
 | 8 | h | 8 | Team 8 |  |  |  | 2 |  | 0 |  |  | 1 | 1 | 0 | 4 |  | -4 | 1 |  | calculates the table and already is classed as draw before scores have been entered. |  |  |  |  |  |  |  |  |  |  |  |  | Week 9 | 2008-10-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 10 | 2008-10-14 00:00:00
 | Group A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11 | 2008-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12 | 2008-10-28 00:00:00
 |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  | Week 1 |  | 2008-08-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13 | 2008-11-04 00:00:00
 | 1 |  | b | Team 2 | 0 | 0 | Week 1 | 0 | v | 0 | c |  | Team 3 |  |  |  |  |  |  | 0 | 0 | Week 1 | D |  |  | Team 2D | 0 | 0 | D | Team 3D | 0 | 0 | 0 | Week 14 | 2008-11-11 00:00:00
 | 2 |  | e | Team 5 | 3 | 6 | Week 1 | 3 | v | 0 | g |  | Team 7 |  |  |  |  |  |  | 3 | 1 | Week 1 | W |  |  | Team 5W | 3 | 0 | L | Team 7L | 3 | 0 | -3 | Week 15 | 2008-11-18 00:00:00
 | 3 |  | f | Team 6 | 0 | 3 | Week 1 | 3 | v | 0 | a |  | Team 1 |  |  |  |  |  |  | 0 | 0 | Week 1 | W |  |  | Team 6W | 3 | 0 | L | Team 1L | 3 | 0 | -3 | Week 16 | 2008-11-25 00:00:00
 | 4 |  | h | Team 8 | 0 | 4 | Week 1 | 0 | v | 4 | d |  | Team 4 |  |  |  |  |  |  | 5 | 4 | Week 1 | L |  |  | Team 8L | 0 | 4 | W | Team 4W | 0 | 4 | 4 | Week 17 | 2008-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 18 | 2008-12-09 00:00:00
 |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  | Week 2 |  | 2008-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13 | 2008-12-16 00:00:00
 | 1 |  | g | Team 7 | 0 | 0 | Week 2 |  | v |  | b |  | Team 2 |  |  |  |  |  |  | 0 | 0 | Week 2 |  |  |  | Team 7 | 0 | 0 |  | Team 2 | 0 | 0 | 0 | Week 14 | 2008-12-23 00:00:00
 | 2 |  | a | Team 1 | 0 | 0 | Week 2 |  | v |  | c |  | Team 3 |  |  |  |  |  |  | 0 | 0 | Week 2 |  |  |  | Team 1 | 0 | 0 |  | Team 3 | 0 | 0 | 0 | Week 15 | 2008-12-30 00:00:00
 | 3 |  | d | Team 4 | 0 | 0 | Week 2 |  | v |  | e |  | Team 5 |  |  |  |  |  |  | 0 | 0 | Week 2 |  |  |  | Team 4 | 0 | 0 |  | Team 5 | 0 | 0 | 0 | Week 16 | 2009-01-06 00:00:00
 | 4 |  | h | Team 8 | 0 | 0 | Week 2 |  | v |  | f |  | Team 6 |  |  |  |  |  |  | 0 | 0 | Week 2 |  |  |  | Team 8 | 0 | 0 |  | Team 6 | 0 | 0 | 0 | Week 17 | 2009-01-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 24 | 2009-01-20 00:00:00
 |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  | Week 3 |  | 2008-08-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13 | 2009-01-27 00:00:00
 | 1 |  | b | Team 2 | 0 | 0 | Week 3 | 0 | v | 0 | a |  | Team 1 |  |  |  |  |  |  | 0 | 0 | Week 3 | D |  |  | Team 2D | 0 | 0 | D | Team 1D | 0 | 0 | 0 | Week 14 | 2009-02-03 00:00:00
 | 2 |  | g | Team 7 | 0 | 0 | Week 3 | 0 | v | 0 | d |  | Team 4 |  |  |  |  |  |  | 0 | 0 | Week 3 | D |  |  | Team 7D | 0 | 0 | D | Team 4D | 0 | 0 | 0 | Week 15 | 2009-02-10 00:00:00
 | 3 |  | c | Team 3 | 0 | 0 | Week 3 | 0 | v | 0 | h |  | Team 8 |  |  |  |  |  |  | 0 | 0 | Week 3 | D |  |  | Team 3D | 0 | 0 | D | Team 8D | 0 | 0 | 0 | Week 16 | 2009-02-17 00:00:00
 | 4 |  | e | Team 5 | 0 | 0 | Week 3 | 0 | v | 0 | f |  | Team 6 |  |  |  |  |  |  | 0 | 0 | Week 3 | D |  |  | Team 5D | 0 | 0 | D | Team 6D | 0 | 0 | 0 | Week 17 | 2009-02-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 30 | 2009-03-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 31 | 2009-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 32 | 2009-03-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 33 | 2009-03-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 34 | 2009-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 35 | 2009-04-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 36 | 2009-04-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 37 | 2009-04-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 38 | 2009-04-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 39 | 2009-05-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 40 | 2009-05-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 41 | 2009-05-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 42 | 2009-05-26 00:00:00