Table to import into Tablepress.
Team No | Team Name | Played | Won | Lost | For | Against | Points | Comments | Adj | filter | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Adur Southdown | =D2+E2 | =SUM(I11:I70) | =SUM(J11:J70) | =SUM(K11:K70) | =SUM(L11:L70) | =D2+F2+J2 | 0 | include | ||||||||||||||||||||||||||||||
2 | Bedouins | =D3+E3 | =SUM(M11:M70) | =SUM(N11:N70) | =SUM(O11:O70) | =SUM(P11:P70) | =D3+F3+J3 | 0 | include | ||||||||||||||||||||||||||||||
3 | Clymping Challengers | =D4+E4 | =SUM(Q11:Q70) | =SUM(R11:R70) | =SUM(S11:S70) | =SUM(T11:T70) | =D4+F4+J4 | 0 | include | ||||||||||||||||||||||||||||||
4 | Cranleigh | =D5+E5 | =SUM(U11:U70) | =SUM(V11:V70) | =SUM(W11:W70) | =SUM(X11:X70) | =D5+F5+J5 | 0 | include | ||||||||||||||||||||||||||||||
5 | Worthing Peacocks | =D6+E6 | =SUM(Y11:Y70) | =SUM(Z11:Z70) | =SUM(AA11:AA70) | =SUM(AB11:AB70) | =D6+F6+J6 | 0 | include | ||||||||||||||||||||||||||||||
6 | Anglesey Arms | =D7+E7 | =SUM(AC11:AC70) | =SUM(AD11:AD70) | =SUM(AE11:AE70) | =SUM(AF11:AF70) | =D7+F7+J7 | 0 | include | ||||||||||||||||||||||||||||||
7 | Arundel Aardvarks | =D8+E8 | =SUM(AG11:AG70) | =SUM(AH11:AH70) | =SUM(AI11:AI70) | =SUM(AJ11:AJ70) | =D8+F8+J8 | 0 | include | ||||||||||||||||||||||||||||||
8 | Clymping Crusaders | =D9+E9 | =SUM(AK11:AK70) | =SUM(AL11:AL70) | =SUM(AM11:AM70) | =SUM(AN11:AN70) | =D9+F9+J9 | 0 | include | ||||||||||||||||||||||||||||||
League | Home Team | Home Team No. | Away Team | Away Team No. | H | A | T1 Won | T1 Lost | T1 For | T1 Agin | T2 Won | T2 Lost | T2 For | T2 Agin | T3 Won | T3 Lost | T3 For | T3 Agin | T4 Won | T4 Lost | T4 For | T4 Agin | T5 Won | T5 Lost | T5 For | T5 Agin | T6 Won | T6 Lost | T6 For | T6 Agin | T7 Won | T7 Lost | T7 For | T7 Agin | T8 Won | T8 Lost | T8 For | T8 Agin | |
6d3E | Arundel Aardvarks | 7 | Anglesey Arms | 6 | 0 | 5 | =IF(7=1,(IF(2=1,1,0)),0) +IF(6=1,(IF(2=2,1,0)),0) | =IF(7=1,(IF(2=2,1,0)),0) +IF(6=1,(IF(2=1,1,0)),0) | =(IF(7=1,0,0)+IF(6=1,5,0)) | =(IF(7=1,5,0)+IF(6=1,0,0)) | =IF(7=2,(IF(2=1,1,0)),0) +IF(6=2,(IF(2=2,1,0)),0) | =IF(7=2,(IF(2=2,1,0)),0) +IF(6=2,(IF(2=1,1,0)),0) | =(IF(7=2,0,0)+IF(6=2,5,0)) | =(IF(7=2,5,0)+IF(6=2,0,0)) | =IF(7=3,(IF(2=1,1,0)),0) +IF(6=3,(IF(2=2,1,0)),0) | =IF(7=3,(IF(2=2,1,0)),0) +IF(6=3,(IF(2=1,1,0)),0) | =(IF(7=3,0,0)+IF(6=3,5,0)) | =(IF(7=3,5,0)+IF(6=3,0,0)) | =IF(7=4,(IF(2=1,1,0)),0) +IF(6=4,(IF(2=2,1,0)),0) | =IF(7=4,(IF(2=2,1,0)),0) +IF(6=4,(IF(2=1,1,0)),0) | =(IF(7=4,0,0)+IF(6=4,5,0)) | =(IF(7=4,5,0)+IF(6=4,0,0)) | =IF(7=5,(IF(2=1,1,0)),0) +IF(6=5,(IF(2=2,1,0)),0) | =IF(7=5,(IF(2=2,1,0)),0) +IF(6=5,(IF(2=1,1,0)),0) | =(IF(7=5,0,0)+IF(6=5,5,0)) | =(IF(7=5,5,0)+IF(6=5,0,0)) | =IF(7=6,(IF(2=1,1,0)),0) +IF(6=6,(IF(2=2,1,0)),0) | =IF(7=6,(IF(2=2,1,0)),0) +IF(6=6,(IF(2=1,1,0)),0) | =(IF(7=6,0,0)+IF(6=6,5,0)) | =(IF(7=6,5,0)+IF(6=6,0,0)) | =IF(7=7,(IF(2=1,1,0)),0) +IF(6=7,(IF(2=2,1,0)),0) | =IF(7=7,(IF(2=2,1,0)),0) +IF(6=7,(IF(2=1,1,0)),0) | =(IF(7=7,0,0)+IF(6=7,5,0)) | =(IF(7=7,5,0)+IF(6=7,0,0)) | =IF(7=8,(IF(2=1,1,0)),0) +IF(6=8,(IF(2=2,1,0)),0) | =IF(7=8,(IF(2=2,1,0)),0) +IF(6=8,(IF(2=1,1,0)),0) | =(IF(7=8,0,0)+IF(6=8,5,0)) | =(IF(7=8,5,0)+IF(6=8,0,0)) | |
6d3E | Worthing Peacocks | 5 | Cranleigh | 4 | 3 | 2 | =IF(5=1,(IF(1=1,1,0)),0) +IF(4=1,(IF(1=2,1,0)),0) | =IF(5=1,(IF(1=2,1,0)),0) +IF(4=1,(IF(1=1,1,0)),0) | =(IF(5=1,3,0)+IF(4=1,2,0)) | =(IF(5=1,2,0)+IF(4=1,3,0)) | =IF(5=2,(IF(1=1,1,0)),0) +IF(4=2,(IF(1=2,1,0)),0) | =IF(5=2,(IF(1=2,1,0)),0) +IF(4=2,(IF(1=1,1,0)),0) | =(IF(5=2,3,0)+IF(4=2,2,0)) | =(IF(5=2,2,0)+IF(4=2,3,0)) | =IF(5=3,(IF(1=1,1,0)),0) +IF(4=3,(IF(1=2,1,0)),0) | =IF(5=3,(IF(1=2,1,0)),0) +IF(4=3,(IF(1=1,1,0)),0) | =(IF(5=3,3,0)+IF(4=3,2,0)) | =(IF(5=3,2,0)+IF(4=3,3,0)) | =IF(5=4,(IF(1=1,1,0)),0) +IF(4=4,(IF(1=2,1,0)),0) | =IF(5=4,(IF(1=2,1,0)),0) +IF(4=4,(IF(1=1,1,0)),0) | =(IF(5=4,3,0)+IF(4=4,2,0)) | =(IF(5=4,2,0)+IF(4=4,3,0)) | =IF(5=5,(IF(1=1,1,0)),0) +IF(4=5,(IF(1=2,1,0)),0) | =IF(5=5,(IF(1=2,1,0)),0) +IF(4=5,(IF(1=1,1,0)),0) | =(IF(5=5,3,0)+IF(4=5,2,0)) | =(IF(5=5,2,0)+IF(4=5,3,0)) | =IF(5=6,(IF(1=1,1,0)),0) +IF(4=6,(IF(1=2,1,0)),0) | =IF(5=6,(IF(1=2,1,0)),0) +IF(4=6,(IF(1=1,1,0)),0) | =(IF(5=6,3,0)+IF(4=6,2,0)) | =(IF(5=6,2,0)+IF(4=6,3,0)) | =IF(5=7,(IF(1=1,1,0)),0) +IF(4=7,(IF(1=2,1,0)),0) | =IF(5=7,(IF(1=2,1,0)),0) +IF(4=7,(IF(1=1,1,0)),0) | =(IF(5=7,3,0)+IF(4=7,2,0)) | =(IF(5=7,2,0)+IF(4=7,3,0)) | =IF(5=8,(IF(1=1,1,0)),0) +IF(4=8,(IF(1=2,1,0)),0) | =IF(5=8,(IF(1=2,1,0)),0) +IF(4=8,(IF(1=1,1,0)),0) | =(IF(5=8,3,0)+IF(4=8,2,0)) | =(IF(5=8,2,0)+IF(4=8,3,0)) | |
6d3E | Clymping Challengers | 3 | Bedouins | 2 | 3 | 2 | =IF(3=1,(IF(1=1,1,0)),0) +IF(2=1,(IF(1=2,1,0)),0) | =IF(3=1,(IF(1=2,1,0)),0) +IF(2=1,(IF(1=1,1,0)),0) | =(IF(3=1,3,0)+IF(2=1,2,0)) | =(IF(3=1,2,0)+IF(2=1,3,0)) | =IF(3=2,(IF(1=1,1,0)),0) +IF(2=2,(IF(1=2,1,0)),0) | =IF(3=2,(IF(1=2,1,0)),0) +IF(2=2,(IF(1=1,1,0)),0) | =(IF(3=2,3,0)+IF(2=2,2,0)) | =(IF(3=2,2,0)+IF(2=2,3,0)) | =IF(3=3,(IF(1=1,1,0)),0) +IF(2=3,(IF(1=2,1,0)),0) | =IF(3=3,(IF(1=2,1,0)),0) +IF(2=3,(IF(1=1,1,0)),0) | =(IF(3=3,3,0)+IF(2=3,2,0)) | =(IF(3=3,2,0)+IF(2=3,3,0)) | =IF(3=4,(IF(1=1,1,0)),0) +IF(2=4,(IF(1=2,1,0)),0) | =IF(3=4,(IF(1=2,1,0)),0) +IF(2=4,(IF(1=1,1,0)),0) | =(IF(3=4,3,0)+IF(2=4,2,0)) | =(IF(3=4,2,0)+IF(2=4,3,0)) | =IF(3=5,(IF(1=1,1,0)),0) +IF(2=5,(IF(1=2,1,0)),0) | =IF(3=5,(IF(1=2,1,0)),0) +IF(2=5,(IF(1=1,1,0)),0) | =(IF(3=5,3,0)+IF(2=5,2,0)) | =(IF(3=5,2,0)+IF(2=5,3,0)) | =IF(3=6,(IF(1=1,1,0)),0) +IF(2=6,(IF(1=2,1,0)),0) | =IF(3=6,(IF(1=2,1,0)),0) +IF(2=6,(IF(1=1,1,0)),0) | =(IF(3=6,3,0)+IF(2=6,2,0)) | =(IF(3=6,2,0)+IF(2=6,3,0)) | =IF(3=7,(IF(1=1,1,0)),0) +IF(2=7,(IF(1=2,1,0)),0) | =IF(3=7,(IF(1=2,1,0)),0) +IF(2=7,(IF(1=1,1,0)),0) | =(IF(3=7,3,0)+IF(2=7,2,0)) | =(IF(3=7,2,0)+IF(2=7,3,0)) | =IF(3=8,(IF(1=1,1,0)),0) +IF(2=8,(IF(1=2,1,0)),0) | =IF(3=8,(IF(1=2,1,0)),0) +IF(2=8,(IF(1=1,1,0)),0) | =(IF(3=8,3,0)+IF(2=8,2,0)) | =(IF(3=8,2,0)+IF(2=8,3,0)) | |