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 Cobbetts Bees =D2+E2 =SUM(I11:I70) =SUM(J11:J70) =SUM(K11:K70) =SUM(L11:L70) =D2+F2+J2 0 include
2 Fareham Maple Leaves =D3+E3 =SUM(M11:M70) =SUM(N11:N70) =SUM(O11:O70) =SUM(P11:P70) =D3+F3+J3 0 include
3 Oxshott =D4+E4 =SUM(Q11:Q70) =SUM(R11:R70) =SUM(S11:S70) =SUM(T11:T70) =D4+F4+J4 0 include
4 Racing Club Rhinos =D5+E5 =SUM(U11:U70) =SUM(V11:V70) =SUM(W11:W70) =SUM(X11:X70) =D5+F5+J5 0 include
5 Shipmates =D6+E6 =SUM(Y11:Y70) =SUM(Z11:Z70) =SUM(AA11:AA70) =SUM(AB11:AB70) =D6+F6+J6 0 include
6 Parley =D7+E7 =SUM(AC11:AC70) =SUM(AD11:AD70) =SUM(AE11:AE70) =SUM(AF11:AF70) =D7+F7+J7 0 include
7 Muscliff Raiders =D8+E8 =SUM(AG11:AG70) =SUM(AH11:AH70) =SUM(AI11:AI70) =SUM(AJ11:AJ70) =D8+F8+J8 0 include
8 Bye =D9+E9 =SUM(AK11:AK70) =SUM(AL11:AL70) =SUM(AM11:AM70) =SUM(AN11:AN70) =D9+F9+J9 -99 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
6d2 Cobbetts Bees 1 Shipmates 5 1 4 =IF(1=1,(IF(2=1,1,0)),0) +IF(5=1,(IF(2=2,1,0)),0) =IF(1=1,(IF(2=2,1,0)),0) +IF(5=1,(IF(2=1,1,0)),0) =(IF(1=1,1,0)+IF(5=1,4,0)) =(IF(1=1,4,0)+IF(5=1,1,0)) =IF(1=2,(IF(2=1,1,0)),0) +IF(5=2,(IF(2=2,1,0)),0) =IF(1=2,(IF(2=2,1,0)),0) +IF(5=2,(IF(2=1,1,0)),0) =(IF(1=2,1,0)+IF(5=2,4,0)) =(IF(1=2,4,0)+IF(5=2,1,0)) =IF(1=3,(IF(2=1,1,0)),0) +IF(5=3,(IF(2=2,1,0)),0) =IF(1=3,(IF(2=2,1,0)),0) +IF(5=3,(IF(2=1,1,0)),0) =(IF(1=3,1,0)+IF(5=3,4,0)) =(IF(1=3,4,0)+IF(5=3,1,0)) =IF(1=4,(IF(2=1,1,0)),0) +IF(5=4,(IF(2=2,1,0)),0) =IF(1=4,(IF(2=2,1,0)),0) +IF(5=4,(IF(2=1,1,0)),0) =(IF(1=4,1,0)+IF(5=4,4,0)) =(IF(1=4,4,0)+IF(5=4,1,0)) =IF(1=5,(IF(2=1,1,0)),0) +IF(5=5,(IF(2=2,1,0)),0) =IF(1=5,(IF(2=2,1,0)),0) +IF(5=5,(IF(2=1,1,0)),0) =(IF(1=5,1,0)+IF(5=5,4,0)) =(IF(1=5,4,0)+IF(5=5,1,0)) =IF(1=6,(IF(2=1,1,0)),0) +IF(5=6,(IF(2=2,1,0)),0) =IF(1=6,(IF(2=2,1,0)),0) +IF(5=6,(IF(2=1,1,0)),0) =(IF(1=6,1,0)+IF(5=6,4,0)) =(IF(1=6,4,0)+IF(5=6,1,0)) =IF(1=7,(IF(2=1,1,0)),0) +IF(5=7,(IF(2=2,1,0)),0) =IF(1=7,(IF(2=2,1,0)),0) +IF(5=7,(IF(2=1,1,0)),0) =(IF(1=7,1,0)+IF(5=7,4,0)) =(IF(1=7,4,0)+IF(5=7,1,0)) =IF(1=8,(IF(2=1,1,0)),0) +IF(5=8,(IF(2=2,1,0)),0) =IF(1=8,(IF(2=2,1,0)),0) +IF(5=8,(IF(2=1,1,0)),0) =(IF(1=8,1,0)+IF(5=8,4,0)) =(IF(1=8,4,0)+IF(5=8,1,0))