Southern Counties Petanque

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 Southdown =D2+E2 =SUM(I11:I70) =SUM(J11:J70) =SUM(K11:K70) =SUM(L11:L70) =D2+F2+J2 0 include
2 Bedouin Bullets =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 Cougars =D5+E5 =SUM(U11:U70) =SUM(V11:V70) =SUM(W11:W70) =SUM(X11:X70) =D5+F5+J5 0 include
5 Oxshott =D6+E6 =SUM(Y11:Y70) =SUM(Z11:Z70) =SUM(AA11:AA70) =SUM(AB11:AB70) =D6+F6+J6 0 include
6 Bye =D7+E7 =SUM(AC11:AC70) =SUM(AD11:AD70) =SUM(AE11:AE70) =SUM(AF11:AF70) =D7+F7+J7 -99 include
7 Bye =D8+E8 =SUM(AG11:AG70) =SUM(AH11:AH70) =SUM(AI11:AI70) =SUM(AJ11:AJ70) =D8+F8+J8 -99 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 Adur Southdown 1 Clymping Crusaders 8 2 3 =IF(1=1,(IF(2=1,1,0)),0) +IF(8=1,(IF(2=2,1,0)),0) =IF(1=1,(IF(2=2,1,0)),0) +IF(8=1,(IF(2=1,1,0)),0) =(IF(1=1,2,0)+IF(8=1,3,0)) =(IF(1=1,3,0)+IF(8=1,2,0)) =IF(1=2,(IF(2=1,1,0)),0) +IF(8=2,(IF(2=2,1,0)),0) =IF(1=2,(IF(2=2,1,0)),0) +IF(8=2,(IF(2=1,1,0)),0) =(IF(1=2,2,0)+IF(8=2,3,0)) =(IF(1=2,3,0)+IF(8=2,2,0)) =IF(1=3,(IF(2=1,1,0)),0) +IF(8=3,(IF(2=2,1,0)),0) =IF(1=3,(IF(2=2,1,0)),0) +IF(8=3,(IF(2=1,1,0)),0) =(IF(1=3,2,0)+IF(8=3,3,0)) =(IF(1=3,3,0)+IF(8=3,2,0)) =IF(1=4,(IF(2=1,1,0)),0) +IF(8=4,(IF(2=2,1,0)),0) =IF(1=4,(IF(2=2,1,0)),0) +IF(8=4,(IF(2=1,1,0)),0) =(IF(1=4,2,0)+IF(8=4,3,0)) =(IF(1=4,3,0)+IF(8=4,2,0)) =IF(1=5,(IF(2=1,1,0)),0) +IF(8=5,(IF(2=2,1,0)),0) =IF(1=5,(IF(2=2,1,0)),0) +IF(8=5,(IF(2=1,1,0)),0) =(IF(1=5,2,0)+IF(8=5,3,0)) =(IF(1=5,3,0)+IF(8=5,2,0)) =IF(1=6,(IF(2=1,1,0)),0) +IF(8=6,(IF(2=2,1,0)),0) =IF(1=6,(IF(2=2,1,0)),0) +IF(8=6,(IF(2=1,1,0)),0) =(IF(1=6,2,0)+IF(8=6,3,0)) =(IF(1=6,3,0)+IF(8=6,2,0)) =IF(1=7,(IF(2=1,1,0)),0) +IF(8=7,(IF(2=2,1,0)),0) =IF(1=7,(IF(2=2,1,0)),0) +IF(8=7,(IF(2=1,1,0)),0) =(IF(1=7,2,0)+IF(8=7,3,0)) =(IF(1=7,3,0)+IF(8=7,2,0)) =IF(1=8,(IF(2=1,1,0)),0) +IF(8=8,(IF(2=2,1,0)),0) =IF(1=8,(IF(2=2,1,0)),0) +IF(8=8,(IF(2=1,1,0)),0) =(IF(1=8,2,0)+IF(8=8,3,0)) =(IF(1=8,3,0)+IF(8=8,2,0))
6d3E Clymping Challengers 3 Oxshott 5 3 2 =IF(3=1,(IF(1=1,1,0)),0) +IF(5=1,(IF(1=2,1,0)),0) =IF(3=1,(IF(1=2,1,0)),0) +IF(5=1,(IF(1=1,1,0)),0) =(IF(3=1,3,0)+IF(5=1,2,0)) =(IF(3=1,2,0)+IF(5=1,3,0)) =IF(3=2,(IF(1=1,1,0)),0) +IF(5=2,(IF(1=2,1,0)),0) =IF(3=2,(IF(1=2,1,0)),0) +IF(5=2,(IF(1=1,1,0)),0) =(IF(3=2,3,0)+IF(5=2,2,0)) =(IF(3=2,2,0)+IF(5=2,3,0)) =IF(3=3,(IF(1=1,1,0)),0) +IF(5=3,(IF(1=2,1,0)),0) =IF(3=3,(IF(1=2,1,0)),0) +IF(5=3,(IF(1=1,1,0)),0) =(IF(3=3,3,0)+IF(5=3,2,0)) =(IF(3=3,2,0)+IF(5=3,3,0)) =IF(3=4,(IF(1=1,1,0)),0) +IF(5=4,(IF(1=2,1,0)),0) =IF(3=4,(IF(1=2,1,0)),0) +IF(5=4,(IF(1=1,1,0)),0) =(IF(3=4,3,0)+IF(5=4,2,0)) =(IF(3=4,2,0)+IF(5=4,3,0)) =IF(3=5,(IF(1=1,1,0)),0) +IF(5=5,(IF(1=2,1,0)),0) =IF(3=5,(IF(1=2,1,0)),0) +IF(5=5,(IF(1=1,1,0)),0) =(IF(3=5,3,0)+IF(5=5,2,0)) =(IF(3=5,2,0)+IF(5=5,3,0)) =IF(3=6,(IF(1=1,1,0)),0) +IF(5=6,(IF(1=2,1,0)),0) =IF(3=6,(IF(1=2,1,0)),0) +IF(5=6,(IF(1=1,1,0)),0) =(IF(3=6,3,0)+IF(5=6,2,0)) =(IF(3=6,2,0)+IF(5=6,3,0)) =IF(3=7,(IF(1=1,1,0)),0) +IF(5=7,(IF(1=2,1,0)),0) =IF(3=7,(IF(1=2,1,0)),0) +IF(5=7,(IF(1=1,1,0)),0) =(IF(3=7,3,0)+IF(5=7,2,0)) =(IF(3=7,2,0)+IF(5=7,3,0)) =IF(3=8,(IF(1=1,1,0)),0) +IF(5=8,(IF(1=2,1,0)),0) =IF(3=8,(IF(1=2,1,0)),0) +IF(5=8,(IF(1=1,1,0)),0) =(IF(3=8,3,0)+IF(5=8,2,0)) =(IF(3=8,2,0)+IF(5=8,3,0))
6d3E Oxshott 5 Adur Southdown 1 4 1 =IF(5=1,(IF(1=1,1,0)),0) +IF(1=1,(IF(1=2,1,0)),0) =IF(5=1,(IF(1=2,1,0)),0) +IF(1=1,(IF(1=1,1,0)),0) =(IF(5=1,4,0)+IF(1=1,1,0)) =(IF(5=1,1,0)+IF(1=1,4,0)) =IF(5=2,(IF(1=1,1,0)),0) +IF(1=2,(IF(1=2,1,0)),0) =IF(5=2,(IF(1=2,1,0)),0) +IF(1=2,(IF(1=1,1,0)),0) =(IF(5=2,4,0)+IF(1=2,1,0)) =(IF(5=2,1,0)+IF(1=2,4,0)) =IF(5=3,(IF(1=1,1,0)),0) +IF(1=3,(IF(1=2,1,0)),0) =IF(5=3,(IF(1=2,1,0)),0) +IF(1=3,(IF(1=1,1,0)),0) =(IF(5=3,4,0)+IF(1=3,1,0)) =(IF(5=3,1,0)+IF(1=3,4,0)) =IF(5=4,(IF(1=1,1,0)),0) +IF(1=4,(IF(1=2,1,0)),0) =IF(5=4,(IF(1=2,1,0)),0) +IF(1=4,(IF(1=1,1,0)),0) =(IF(5=4,4,0)+IF(1=4,1,0)) =(IF(5=4,1,0)+IF(1=4,4,0)) =IF(5=5,(IF(1=1,1,0)),0) +IF(1=5,(IF(1=2,1,0)),0) =IF(5=5,(IF(1=2,1,0)),0) +IF(1=5,(IF(1=1,1,0)),0) =(IF(5=5,4,0)+IF(1=5,1,0)) =(IF(5=5,1,0)+IF(1=5,4,0)) =IF(5=6,(IF(1=1,1,0)),0) +IF(1=6,(IF(1=2,1,0)),0) =IF(5=6,(IF(1=2,1,0)),0) +IF(1=6,(IF(1=1,1,0)),0) =(IF(5=6,4,0)+IF(1=6,1,0)) =(IF(5=6,1,0)+IF(1=6,4,0)) =IF(5=7,(IF(1=1,1,0)),0) +IF(1=7,(IF(1=2,1,0)),0) =IF(5=7,(IF(1=2,1,0)),0) +IF(1=7,(IF(1=1,1,0)),0) =(IF(5=7,4,0)+IF(1=7,1,0)) =(IF(5=7,1,0)+IF(1=7,4,0)) =IF(5=8,(IF(1=1,1,0)),0) +IF(1=8,(IF(1=2,1,0)),0) =IF(5=8,(IF(1=2,1,0)),0) +IF(1=8,(IF(1=1,1,0)),0) =(IF(5=8,4,0)+IF(1=8,1,0)) =(IF(5=8,1,0)+IF(1=8,4,0))
6d3E Cranleigh Cougars 4 Clymping Challengers 3 3 2 =IF(4=1,(IF(1=1,1,0)),0) +IF(3=1,(IF(1=2,1,0)),0) =IF(4=1,(IF(1=2,1,0)),0) +IF(3=1,(IF(1=1,1,0)),0) =(IF(4=1,3,0)+IF(3=1,2,0)) =(IF(4=1,2,0)+IF(3=1,3,0)) =IF(4=2,(IF(1=1,1,0)),0) +IF(3=2,(IF(1=2,1,0)),0) =IF(4=2,(IF(1=2,1,0)),0) +IF(3=2,(IF(1=1,1,0)),0) =(IF(4=2,3,0)+IF(3=2,2,0)) =(IF(4=2,2,0)+IF(3=2,3,0)) =IF(4=3,(IF(1=1,1,0)),0) +IF(3=3,(IF(1=2,1,0)),0) =IF(4=3,(IF(1=2,1,0)),0) +IF(3=3,(IF(1=1,1,0)),0) =(IF(4=3,3,0)+IF(3=3,2,0)) =(IF(4=3,2,0)+IF(3=3,3,0)) =IF(4=4,(IF(1=1,1,0)),0) +IF(3=4,(IF(1=2,1,0)),0) =IF(4=4,(IF(1=2,1,0)),0) +IF(3=4,(IF(1=1,1,0)),0) =(IF(4=4,3,0)+IF(3=4,2,0)) =(IF(4=4,2,0)+IF(3=4,3,0)) =IF(4=5,(IF(1=1,1,0)),0) +IF(3=5,(IF(1=2,1,0)),0) =IF(4=5,(IF(1=2,1,0)),0) +IF(3=5,(IF(1=1,1,0)),0) =(IF(4=5,3,0)+IF(3=5,2,0)) =(IF(4=5,2,0)+IF(3=5,3,0)) =IF(4=6,(IF(1=1,1,0)),0) +IF(3=6,(IF(1=2,1,0)),0) =IF(4=6,(IF(1=2,1,0)),0) +IF(3=6,(IF(1=1,1,0)),0) =(IF(4=6,3,0)+IF(3=6,2,0)) =(IF(4=6,2,0)+IF(3=6,3,0)) =IF(4=7,(IF(1=1,1,0)),0) +IF(3=7,(IF(1=2,1,0)),0) =IF(4=7,(IF(1=2,1,0)),0) +IF(3=7,(IF(1=1,1,0)),0) =(IF(4=7,3,0)+IF(3=7,2,0)) =(IF(4=7,2,0)+IF(3=7,3,0)) =IF(4=8,(IF(1=1,1,0)),0) +IF(3=8,(IF(1=2,1,0)),0) =IF(4=8,(IF(1=2,1,0)),0) +IF(3=8,(IF(1=1,1,0)),0) =(IF(4=8,3,0)+IF(3=8,2,0)) =(IF(4=8,2,0)+IF(3=8,3,0))
6d3E Clymping Crusaders 8 Clymping Challengers 3 2 3 =IF(8=1,(IF(2=1,1,0)),0) +IF(3=1,(IF(2=2,1,0)),0) =IF(8=1,(IF(2=2,1,0)),0) +IF(3=1,(IF(2=1,1,0)),0) =(IF(8=1,2,0)+IF(3=1,3,0)) =(IF(8=1,3,0)+IF(3=1,2,0)) =IF(8=2,(IF(2=1,1,0)),0) +IF(3=2,(IF(2=2,1,0)),0) =IF(8=2,(IF(2=2,1,0)),0) +IF(3=2,(IF(2=1,1,0)),0) =(IF(8=2,2,0)+IF(3=2,3,0)) =(IF(8=2,3,0)+IF(3=2,2,0)) =IF(8=3,(IF(2=1,1,0)),0) +IF(3=3,(IF(2=2,1,0)),0) =IF(8=3,(IF(2=2,1,0)),0) +IF(3=3,(IF(2=1,1,0)),0) =(IF(8=3,2,0)+IF(3=3,3,0)) =(IF(8=3,3,0)+IF(3=3,2,0)) =IF(8=4,(IF(2=1,1,0)),0) +IF(3=4,(IF(2=2,1,0)),0) =IF(8=4,(IF(2=2,1,0)),0) +IF(3=4,(IF(2=1,1,0)),0) =(IF(8=4,2,0)+IF(3=4,3,0)) =(IF(8=4,3,0)+IF(3=4,2,0)) =IF(8=5,(IF(2=1,1,0)),0) +IF(3=5,(IF(2=2,1,0)),0) =IF(8=5,(IF(2=2,1,0)),0) +IF(3=5,(IF(2=1,1,0)),0) =(IF(8=5,2,0)+IF(3=5,3,0)) =(IF(8=5,3,0)+IF(3=5,2,0)) =IF(8=6,(IF(2=1,1,0)),0) +IF(3=6,(IF(2=2,1,0)),0) =IF(8=6,(IF(2=2,1,0)),0) +IF(3=6,(IF(2=1,1,0)),0) =(IF(8=6,2,0)+IF(3=6,3,0)) =(IF(8=6,3,0)+IF(3=6,2,0)) =IF(8=7,(IF(2=1,1,0)),0) +IF(3=7,(IF(2=2,1,0)),0) =IF(8=7,(IF(2=2,1,0)),0) +IF(3=7,(IF(2=1,1,0)),0) =(IF(8=7,2,0)+IF(3=7,3,0)) =(IF(8=7,3,0)+IF(3=7,2,0)) =IF(8=8,(IF(2=1,1,0)),0) +IF(3=8,(IF(2=2,1,0)),0) =IF(8=8,(IF(2=2,1,0)),0) +IF(3=8,(IF(2=1,1,0)),0) =(IF(8=8,2,0)+IF(3=8,3,0)) =(IF(8=8,3,0)+IF(3=8,2,0))
6d3E Adur Southdown 1 Clymping Challengers 3 5 0 =IF(1=1,(IF(1=1,1,0)),0) +IF(3=1,(IF(1=2,1,0)),0) =IF(1=1,(IF(1=2,1,0)),0) +IF(3=1,(IF(1=1,1,0)),0) =(IF(1=1,5,0)+IF(3=1,0,0)) =(IF(1=1,0,0)+IF(3=1,5,0)) =IF(1=2,(IF(1=1,1,0)),0) +IF(3=2,(IF(1=2,1,0)),0) =IF(1=2,(IF(1=2,1,0)),0) +IF(3=2,(IF(1=1,1,0)),0) =(IF(1=2,5,0)+IF(3=2,0,0)) =(IF(1=2,0,0)+IF(3=2,5,0)) =IF(1=3,(IF(1=1,1,0)),0) +IF(3=3,(IF(1=2,1,0)),0) =IF(1=3,(IF(1=2,1,0)),0) +IF(3=3,(IF(1=1,1,0)),0) =(IF(1=3,5,0)+IF(3=3,0,0)) =(IF(1=3,0,0)+IF(3=3,5,0)) =IF(1=4,(IF(1=1,1,0)),0) +IF(3=4,(IF(1=2,1,0)),0) =IF(1=4,(IF(1=2,1,0)),0) +IF(3=4,(IF(1=1,1,0)),0) =(IF(1=4,5,0)+IF(3=4,0,0)) =(IF(1=4,0,0)+IF(3=4,5,0)) =IF(1=5,(IF(1=1,1,0)),0) +IF(3=5,(IF(1=2,1,0)),0) =IF(1=5,(IF(1=2,1,0)),0) +IF(3=5,(IF(1=1,1,0)),0) =(IF(1=5,5,0)+IF(3=5,0,0)) =(IF(1=5,0,0)+IF(3=5,5,0)) =IF(1=6,(IF(1=1,1,0)),0) +IF(3=6,(IF(1=2,1,0)),0) =IF(1=6,(IF(1=2,1,0)),0) +IF(3=6,(IF(1=1,1,0)),0) =(IF(1=6,5,0)+IF(3=6,0,0)) =(IF(1=6,0,0)+IF(3=6,5,0)) =IF(1=7,(IF(1=1,1,0)),0) +IF(3=7,(IF(1=2,1,0)),0) =IF(1=7,(IF(1=2,1,0)),0) +IF(3=7,(IF(1=1,1,0)),0) =(IF(1=7,5,0)+IF(3=7,0,0)) =(IF(1=7,0,0)+IF(3=7,5,0)) =IF(1=8,(IF(1=1,1,0)),0) +IF(3=8,(IF(1=2,1,0)),0) =IF(1=8,(IF(1=2,1,0)),0) +IF(3=8,(IF(1=1,1,0)),0) =(IF(1=8,5,0)+IF(3=8,0,0)) =(IF(1=8,0,0)+IF(3=8,5,0))