Table to import into Tablepress.
| Team No | Team Name | Played | Won | Lost | For | Against | Points | Comments | Adj | filter | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | River Hamble | =D2+E2 | =SUM(I11:I70) | =SUM(J11:J70) | =SUM(K11:K70) | =SUM(L11:L70) | =D2+F2+J2 | 0 | include | ||||||||||||||||||||||||||||||
| 2 | Cobbetts Ales | =D3+E3 | =SUM(M11:M70) | =SUM(N11:N70) | =SUM(O11:O70) | =SUM(P11:P70) | =D3+F3+J3 | 0 | include | ||||||||||||||||||||||||||||||
| 3 | Fareham Conifers | =D4+E4 | =SUM(Q11:Q70) | =SUM(R11:R70) | =SUM(S11:S70) | =SUM(T11:T70) | =D4+F4+J4 | 0 | include | ||||||||||||||||||||||||||||||
| 4 | Bye | =D5+E5 | =SUM(U11:U70) | =SUM(V11:V70) | =SUM(W11:W70) | =SUM(X11:X70) | =D5+F5+J5 | -99 | include | ||||||||||||||||||||||||||||||
| 5 | Shedfield | =D6+E6 | =SUM(Y11:Y70) | =SUM(Z11:Z70) | =SUM(AA11:AA70) | =SUM(AB11:AB70) | =D6+F6+J6 | 0 | include | ||||||||||||||||||||||||||||||
| 6 | Crondalliers | =D7+E7 | =SUM(AC11:AC70) | =SUM(AD11:AD70) | =SUM(AE11:AE70) | =SUM(AF11:AF70) | =D7+F7+J7 | 0 | include | ||||||||||||||||||||||||||||||
| 7 | Bordon Scorpions | =D8+E8 | =SUM(AG11:AG70) | =SUM(AH11:AH70) | =SUM(AI11:AI70) | =SUM(AJ11:AJ70) | =D8+F8+J8 | 0 | include | ||||||||||||||||||||||||||||||
| 8 | Handcross | =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 | |
| 6d1 | Cobbetts Ales | 2 | Bordon Scorpions | 7 | 4 | 1 | =IF(2=1,(IF(1=1,1,0)),0) +IF(7=1,(IF(1=2,1,0)),0) | =IF(2=1,(IF(1=2,1,0)),0) +IF(7=1,(IF(1=1,1,0)),0) | =(IF(2=1,4,0)+IF(7=1,1,0)) | =(IF(2=1,1,0)+IF(7=1,4,0)) | =IF(2=2,(IF(1=1,1,0)),0) +IF(7=2,(IF(1=2,1,0)),0) | =IF(2=2,(IF(1=2,1,0)),0) +IF(7=2,(IF(1=1,1,0)),0) | =(IF(2=2,4,0)+IF(7=2,1,0)) | =(IF(2=2,1,0)+IF(7=2,4,0)) | =IF(2=3,(IF(1=1,1,0)),0) +IF(7=3,(IF(1=2,1,0)),0) | =IF(2=3,(IF(1=2,1,0)),0) +IF(7=3,(IF(1=1,1,0)),0) | =(IF(2=3,4,0)+IF(7=3,1,0)) | =(IF(2=3,1,0)+IF(7=3,4,0)) | =IF(2=4,(IF(1=1,1,0)),0) +IF(7=4,(IF(1=2,1,0)),0) | =IF(2=4,(IF(1=2,1,0)),0) +IF(7=4,(IF(1=1,1,0)),0) | =(IF(2=4,4,0)+IF(7=4,1,0)) | =(IF(2=4,1,0)+IF(7=4,4,0)) | =IF(2=5,(IF(1=1,1,0)),0) +IF(7=5,(IF(1=2,1,0)),0) | =IF(2=5,(IF(1=2,1,0)),0) +IF(7=5,(IF(1=1,1,0)),0) | =(IF(2=5,4,0)+IF(7=5,1,0)) | =(IF(2=5,1,0)+IF(7=5,4,0)) | =IF(2=6,(IF(1=1,1,0)),0) +IF(7=6,(IF(1=2,1,0)),0) | =IF(2=6,(IF(1=2,1,0)),0) +IF(7=6,(IF(1=1,1,0)),0) | =(IF(2=6,4,0)+IF(7=6,1,0)) | =(IF(2=6,1,0)+IF(7=6,4,0)) | =IF(2=7,(IF(1=1,1,0)),0) +IF(7=7,(IF(1=2,1,0)),0) | =IF(2=7,(IF(1=2,1,0)),0) +IF(7=7,(IF(1=1,1,0)),0) | =(IF(2=7,4,0)+IF(7=7,1,0)) | =(IF(2=7,1,0)+IF(7=7,4,0)) | =IF(2=8,(IF(1=1,1,0)),0) +IF(7=8,(IF(1=2,1,0)),0) | =IF(2=8,(IF(1=2,1,0)),0) +IF(7=8,(IF(1=1,1,0)),0) | =(IF(2=8,4,0)+IF(7=8,1,0)) | =(IF(2=8,1,0)+IF(7=8,4,0)) | |
| 6d1 | Shedfield | 5 | Crondalliers | 6 | 3 | 2 | =IF(5=1,(IF(1=1,1,0)),0) +IF(6=1,(IF(1=2,1,0)),0) | =IF(5=1,(IF(1=2,1,0)),0) +IF(6=1,(IF(1=1,1,0)),0) | =(IF(5=1,3,0)+IF(6=1,2,0)) | =(IF(5=1,2,0)+IF(6=1,3,0)) | =IF(5=2,(IF(1=1,1,0)),0) +IF(6=2,(IF(1=2,1,0)),0) | =IF(5=2,(IF(1=2,1,0)),0) +IF(6=2,(IF(1=1,1,0)),0) | =(IF(5=2,3,0)+IF(6=2,2,0)) | =(IF(5=2,2,0)+IF(6=2,3,0)) | =IF(5=3,(IF(1=1,1,0)),0) +IF(6=3,(IF(1=2,1,0)),0) | =IF(5=3,(IF(1=2,1,0)),0) +IF(6=3,(IF(1=1,1,0)),0) | =(IF(5=3,3,0)+IF(6=3,2,0)) | =(IF(5=3,2,0)+IF(6=3,3,0)) | =IF(5=4,(IF(1=1,1,0)),0) +IF(6=4,(IF(1=2,1,0)),0) | =IF(5=4,(IF(1=2,1,0)),0) +IF(6=4,(IF(1=1,1,0)),0) | =(IF(5=4,3,0)+IF(6=4,2,0)) | =(IF(5=4,2,0)+IF(6=4,3,0)) | =IF(5=5,(IF(1=1,1,0)),0) +IF(6=5,(IF(1=2,1,0)),0) | =IF(5=5,(IF(1=2,1,0)),0) +IF(6=5,(IF(1=1,1,0)),0) | =(IF(5=5,3,0)+IF(6=5,2,0)) | =(IF(5=5,2,0)+IF(6=5,3,0)) | =IF(5=6,(IF(1=1,1,0)),0) +IF(6=6,(IF(1=2,1,0)),0) | =IF(5=6,(IF(1=2,1,0)),0) +IF(6=6,(IF(1=1,1,0)),0) | =(IF(5=6,3,0)+IF(6=6,2,0)) | =(IF(5=6,2,0)+IF(6=6,3,0)) | =IF(5=7,(IF(1=1,1,0)),0) +IF(6=7,(IF(1=2,1,0)),0) | =IF(5=7,(IF(1=2,1,0)),0) +IF(6=7,(IF(1=1,1,0)),0) | =(IF(5=7,3,0)+IF(6=7,2,0)) | =(IF(5=7,2,0)+IF(6=7,3,0)) | =IF(5=8,(IF(1=1,1,0)),0) +IF(6=8,(IF(1=2,1,0)),0) | =IF(5=8,(IF(1=2,1,0)),0) +IF(6=8,(IF(1=1,1,0)),0) | =(IF(5=8,3,0)+IF(6=8,2,0)) | =(IF(5=8,2,0)+IF(6=8,3,0)) | |