Table to import into Tablepress.

<--! Need blank rows imported in Tablepress to ensure that calculations work when calendar is incomplete. -->

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