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 Southampton City Pilgrims =D2+E2 =SUM(I11:I70) =SUM(J11:J70) =SUM(K11:K70) =SUM(L11:L70) =D2+F2+J2 0 include
2 Cobbetts Cubs =D3+E3 =SUM(M11:M70) =SUM(N11:N70) =SUM(O11:O70) =SUM(P11:P70) =D3+F3+J3 0 include
3 Portchester Pumas =D4+E4 =SUM(Q11:Q70) =SUM(R11:R70) =SUM(S11:S70) =SUM(T11:T70) =D4+F4+J4 0 include
4 Muscliff Musketeers =D5+E5 =SUM(U11:U70) =SUM(V11:V70) =SUM(W11:W70) =SUM(X11:X70) =D5+F5+J5 0 include
5 Racing Club Racers =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 Portchester Pirates =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
6d3W Southampton City Pilgrims 1 Racing Club Racers 5 2 3 =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,2,0)+IF(5=1,3,0)) =(IF(1=1,3,0)+IF(5=1,2,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,2,0)+IF(5=2,3,0)) =(IF(1=2,3,0)+IF(5=2,2,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,2,0)+IF(5=3,3,0)) =(IF(1=3,3,0)+IF(5=3,2,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,2,0)+IF(5=4,3,0)) =(IF(1=4,3,0)+IF(5=4,2,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,2,0)+IF(5=5,3,0)) =(IF(1=5,3,0)+IF(5=5,2,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,2,0)+IF(5=6,3,0)) =(IF(1=6,3,0)+IF(5=6,2,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,2,0)+IF(5=7,3,0)) =(IF(1=7,3,0)+IF(5=7,2,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,2,0)+IF(5=8,3,0)) =(IF(1=8,3,0)+IF(5=8,2,0))
6d3W Portchester Pumas 3 Cobbetts Cubs 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))