{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Blad1","Blad2","Blad3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Blad1","index":0,"n_rows":51,"n_cols":28,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,11,1,11],[32,5,32,6],[33,5,33,6],[34,5,34,6],[40,5,40,6],[0,3,1,3],[41,5,41,6],[30,0,30,6],[31,5,31,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6]]}
[null,null,"wedstrijden in voorronde",6,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,"aantal spelers in de finale hier aangeven (menu)"]
[null,"naam speler","vereniging speler","punten behaald","moyenne aanvang","moyenne behaald","ranglijst punten","resultaat pnt ranglijst","percent. Moyenne","ranglijst moyenne","ranglijst is totaal gele kolommen",{"$f":"IF(D1=4,\"finale met 4 spelers \",\"finale met 6 spelers \")","v":"finale met 6 spelers "},null,"gem. van de 2 moyennes","moyenne in volgende"]
[{"$f":"IF(B4=\"\",\"\",1)","v":1},"Gerard Versteege","Concordia`54",8,0.68,1.05,{"$f":"IF(D4=\"\",\"\",RANK(D4,D$4:D$28))","v":1},{"$f":"IF(G4=G12,(A4+A5+A6+A7+A8+A9+A10+A11+A12)/9,IF(G4=G11,(A4+A5+A6+A7+A8+A9+A10+A11)/8,IF(G4=G10,(A4+A5+A6+A7+A8+A9+A10)/7,IF(G4=G9,(A4+A5+A6+A7+A8+A9)/6,IF(G4=G8,(A4+A5+A6+A7+A8)/5,IF(G4=G7,(A4+A5+A6+A7)/4,IF(G4=G6,(A5+A4+A6)/3,IF(G4=G5,(A4+A5)/2,1))))))))","v":1.5},{"$f":"IF(AND(E4>0,F4>0),F4/E4,\"\")","v":1.5441176470588236},{"$f":"RANK(I4,I$4:I$28)","v":1},{"$f":"IF(E4<0.001,\"\",H4+J4)","v":2.5},{"$f":"M4","v":1},{"$f":"IF(ISERROR(RANK(K4,K$4:K$28,1)),\"\",RANK(K4,K$4:K$28,1))","v":1},{"$f":"IF(B4=\"\",\"\",(E4+F4)/2)","v":0.86499999999999999},{"$f":"IF(B4=\"\",\"\",FLOOR(IF(F4>E4,N4,E4)*1000,1)/1000)","v":0.86499999999999999},{"$f":"IF(AND(L4=1,L$1=5),\"FINALE\",IF(AND(L4=2,L$1=5),\"FINALE\",IF(AND(L4=3,L$1=5),\"FINALE\",IF(AND(L4=4,L$1=5),\"FINALE\",IF(AND(L4=5,L$1=5),\"FINALE\",IF(AND(L4=6,L$1=5),\"1e Res\",IF(AND(L4=7,L$1=5),\"2e Res\",IF(AND(L4=1,L$1=6),\"FINALE\",IF(AND(L4=2,L$1=6),\"FINALE\",IF(AND(L4=3,L$1=6),\"FINALE\",IF(AND(L4=4,L$1=6),\"FINALE\",IF(AND(L4=5,L$1=6),\"FINALE\",IF(AND(L4=6,L$1=6),\"FINALE\",IF(AND(L4=7,L$1=6),\"1e Res\",IF(AND(L4=8,L$1=6),\"2e Res\",IF(AND(L4=1,L$1=8),\"FINALE\",IF(AND(L4=2,L$1=8),\"FINALE\",IF(AND(L4=3,L$1=8),\"FINALE\",IF(AND(L4=4,L$1=8),\"FINALE\",IF(AND(L4=5,L$1=8),\"FINALE\",IF(AND(L4=6,L$1=8),\"FINALE\",IF(AND(L4=7,L$1=8),\"FINALE\",IF(AND(L4=8,L$1=8),\"FINALE\",IF(AND(L4=9,L$1=8),\"1e Res\",IF(AND(L4=10,L$1=8),\"2e Res\",\"\")))))))))))))))))))))))))","v":"FINALE"},{"$f":"B4","v":"Gerard Versteege"},null,null,4,null,5]
[{"$f":"IF(B5=\"\",\"\",2)","v":2},"Herman Jansen","A.B.C.",8,0.65,0.84,{"$f":"IF(D5=\"\",\"\",RANK(D5,D$4:D$28))","v":1},{"$f":"IF(G5=G4,H4,IF(G5=G13,(A5+A6+A7+A8+A9+A10+A11+A12+A13)/9,IF(G5=G12,(A5+A6+A7+A8+A9+A10+A11+A12)/8,IF(G5=G11,(A5+A6+A7+A8+A9+A10+A11)/7,IF(G5=G10,(A5+A6+A7+A8+A9+A10)/6,IF(G5=G9,(A5+A6+A7+A8+A9)/5,IF(G5=G8,(A5+A6+A7+A8)/4,IF(G5=G7,(A5+A6+A7)/3,IF(G5=G6,(A5+A6)/2,2)))))))))","v":1.5},1.2923076923076922,{"$f":"IF(D5=\"\",\"\",RANK(I5,I$4:I$28))","v":3},4.5,{"$f":"IF(M5=\"\",\"\",IF(K5=K4,M5+1,M5))","v":2},2,{"$f":"IF(B5=\"\",\"\",(E5+F5)/2)","v":0.745},0.745,{"$f":"IF(AND(L5=1,L$1=5),\"FINALE\",IF(AND(L5=2,L$1=5),\"FINALE\",IF(AND(L5=3,L$1=5),\"FINALE\",IF(AND(L5=4,L$1=5),\"FINALE\",IF(AND(L5=5,L$1=5),\"FINALE\",IF(AND(L5=6,L$1=5),\"1e Res\",IF(AND(L5=7,L$1=5),\"2e Res\",IF(AND(L5=1,L$1=6),\"FINALE\",IF(AND(L5=2,L$1=6),\"FINALE\",IF(AND(L5=3,L$1=6),\"FINALE\",IF(AND(L5=4,L$1=6),\"FINALE\",IF(AND(L5=5,L$1=6),\"FINALE\",IF(AND(L5=6,L$1=6),\"FINALE\",IF(AND(L5=7,L$1=6),\"1e Res\",IF(AND(L5=8,L$1=6),\"2e Res\",IF(AND(L5=1,L$1=8),\"FINALE\",IF(AND(L5=2,L$1=8),\"FINALE\",IF(AND(L5=3,L$1=8),\"FINALE\",IF(AND(L5=4,L$1=8),\"FINALE\",IF(AND(L5=5,L$1=8),\"FINALE\",IF(AND(L5=6,L$1=8),\"FINALE\",IF(AND(L5=7,L$1=8),\"FINALE\",IF(AND(L5=8,L$1=8),\"FINALE\",IF(AND(L5=9,L$1=8),\"1e Res\",IF(AND(L5=10,L$1=8),\"2e Res\",\"\")))))))))))))))))))))))))","v":"FINALE"},"Herman Jansen",null,null,6,null,6]
[{"$f":"IF(B6=\"\",\"\",3)","v":3},"Eric Holthausen","De Olde Mölle",6,0.5,0.64100000000000001,3,{"$f":"IF(D6=\"\",\"\",IF(G6=G5,H5,IF(G6=G14,(A6+A7+A8+A9+A10+A11+A12+A13+A14)/9,IF(G6=G13,(A6+A7+A8+A9+A10+A11+A12+A13)/8,IF(G6=G12,(A6+A7+A8+A9+A10+A11+A12)/7,IF(G6=G11,(A6+A7+A8+A9+A10+A11)/6,IF(G6=G10,(A6+A7+A8+A9+A10)/5,IF(G6=G9,(A6+A7+A8+A9)/4,IF(G6=G8,(A6+A7+A8)/3,IF(G6=G7,(A6+A7)/2,3))))))))))","v":3},1.282,5,8,{"$f":"IF(M6=\"\",\"\",IF(K6=K5,M6+1,IF(K6=K4,M6+1,M6)))","v":3},3,{"$f":"IF(B6=\"\",\"\",(E6+F6)/2)","v":0.57050000000000001},0.56999999999999995,"FINALE","Eric Holthausen",null,null,null,null,8]
[{"$f":"IF(B7=\"\",\"\",4)","v":4},"Wim Leusink","De Veemarkt",4,0.98499999999999999,1.04,4,{"$f":"IF(D7=\"\",\"\",IF(G7=G6,H6,IF(G7=G15,(A7+A8+A9+A10+A11+A12+A13+A14+A15)/9,IF(G7=G14,(A7+A8+A9+A10+A11+A12+A13+A14)/8,IF(G7=G13,(A7+A8+A9+A10+A11+A12+A13)/7,IF(G7=G12,(A7+A8+A9+A10+A11+A12)/6,IF(G7=G11,(A7+A8+A9+A10+A11)/5,IF(G7=G10,(A7+A8+A9+A10)/4,IF(G7=G9,(A7+A8+A9)/3,IF(G7=G8,(A7+A8)/2,4))))))))))","v":6.5},1.0558375634517767,10,16.5,{"$f":"IF(M7=\"\",\"\",IF(K7=K6,M7+1,IF(K7=K5,M7+1,IF(K7=K4,M7+1,M7))))","v":7},7,1.0125,1.012,"FINALE","Wim Leusink",null,null,10,98,257,3,"0.381","0.515",96078,"0.355"]
[{"$f":"IF(B8=\"\",\"\",5)","v":5},"Ulrich Verheyen","Gildehuis",4,0.83,0.77400000000000002,4,{"$f":"IF(D8=\"\",\"\",IF(G8=G7,H7,IF(G8=G16,(A8+A9+A10+A11+A12+A13+A14+A15+A16)/9,IF(G8=G15,(A8+A9+A10+A11+A12+A13+A14+A15)/8,IF(G8=G14,(A8+A9+A10+A11+A12+A13+A14)/7,IF(G8=G13,(A8+A9+A10+A11+A12+A13)/6,IF(G8=G12,(A8+A9+A10+A11+A12)/5,IF(G8=G11,(A8+A9+A10+A11)/4,IF(G8=G10,(A8+A9+A10)/3,IF(G8=G9,(A8+A9)/2,5))))))))))","v":6.5},{"$f":"IF(AND(E8>0,F8>0),F8/E8,\"\")","v":0.93253012048192774},12,18.5,{"$f":"IF(M8=\"\",\"\",IF(K8=K7,M8+1,IF(K8=K6,M8+1,IF(K8=K5,M8+1,IF(K8=K4,M8+1,M8)))))","v":9},9,0.80200000000000005,0.83,"1e Res","Ulrich Verheyen",null,null,"Frank Stevens",10,81,249,3,"0.325","0.576",90000,"0.302"]
[{"$f":"IF(B9=\"\",\"\",6)","v":6},"Bertus Mensert","De Veemarkt",4,0.69199999999999995,0.73599999999999999,4,{"$f":"IF(D9=\"\",\"\",IF(G9=G8,H8,IF(G9=G17,(A9+A10+A11+A12+A13+A14+A15+A16+A17)/9,IF(G9=G16,(A9+A10+A11+A12+A13+A14+A15+A16)/8,IF(G9=G15,(A9+A10+A11+A12+A13+A14+A15)/7,IF(G9=G14,(A9+A10+A11+A12+A13+A14)/6,IF(G9=G13,(A9+A10+A11+A12+A13)/5,IF(G9=G12,(A9+A10+A11+A12)/4,IF(G9=G11,(A9+A10+A11)/3,IF(G9=G10,(A9+A10)/2,6))))))))))","v":6.5},1.0635838150289019,8,14.5,{"$f":"IF(M9=\"\",\"\",IF(K9=K8,M9+1,IF(K9=K7,M9+1,IF(K9=K6,M9+1,IF(K9=K5,M9+1,IF(K9=K4,M9+1,M9))))))","v":5},5,0.71399999999999997,0.71399999999999997,"FINALE","Bertus Mensert",null,null,"Nicky Berenschot",2,67,305,3,"0.219","0.333",75444,"0.280"]
[{"$f":"IF(B10=\"\",\"\",7)","v":7},"Antoon Jacobs","Buitenmolen",4,0.69,0.72899999999999998,4,{"$f":"IF(D10=\"\",\"\",IF(G10=G9,H9,IF(G10=G18,(A10+A11+A12+A13+A14+A15+A16+A17+A18)/9,IF(G10=G17,(A10+A11+A12+A13+A14+A15+A16+A17)/8,IF(G10=G16,(A10+A11+A12+A13+A14+A15+A16)/7,IF(G10=G15,(A10+A11+A12+A13+A14+A15)/6,IF(G10=G14,(A10+A11+A12+A13+A14)/5,IF(G10=G13,(A10+A11+A12+A13)/4,IF(G10=G12,(A10+A11+A12)/3,IF(G10=G11,(A10+A11)/2,1))))))))))","v":6.5},1.0565217391304349,9,15.5,{"$f":"IF(M10=\"\",\"\",IF(K10=K9,M10+1,IF(K10=K8,M10+1,IF(K10=K7,M10+1,IF(K10=K6,M10+1,IF(K10=K5,M10+1,IF(K10=K4,M10+1,M10)))))))","v":6},6,0.70950000000000002,{"$f":"IF(B10=\"\",\"\",FLOOR(IF(F10>E10,N10,E10)*1000,1)/1000)","v":0.70899999999999996},"FINALE","Antoon Jacobs",null,null,"Erik Holthausen",2,48,297,2,"0.161","0.200",53333,"0.280"]
[{"$f":"IF(B11=\"\",\"\",8)","v":8},"Henk Vollema","Concordia`54",4,0.85,1.1559999999999999,4,{"$f":"IF(D11=\"\",\"\",IF(G11=G10,H10,IF(G11=G19,(A11+A12+A13+A14+A15+A16+A17+A18+A19)/9,IF(G11=G18,(A11+A12+A13+A14+A15+A16+A17+A18)/8,IF(G11=G17,(A11+A12+A13+A14+A15+A16+A17)/7,IF(G11=G16,(A11+A12+A13+A14+A15+A16)/6,IF(G11=G15,(A11+A12+A13+A14+A15)/5,IF(G11=G14,(A11+A12+A13+A14)/4,IF(G11=G13,(A11+A12+A13)/3,IF(G11=G12,(A11+A12)/2,8))))))))))","v":6.5},1.3599999999999999,2,8.5,{"$f":"IF(M11=\"\",\"\",IF(K11=K10,M11+1,IF(K11=K9,M11+1,IF(K11=K8,M11+1,IF(K11=K7,M11+1,IF(K11=K6,M11+1,IF(K11=K5,M11+1,IF(K11=K4,M11+1,M11))))))))","v":4},4,1.0029999999999999,1.0029999999999999,"FINALE","Henk Vollema",null,null,"Poule Concordia`54    "," "," "," "," "," "," "," "," "]
[{"$f":"IF(B12=\"\",\"\",9)","v":9},"Rob Verkerke ","Concordia`54",4,0.89400000000000002,0.75,4,{"$f":"IF(D12=\"\",\"\",IF(G12=G11,H11,IF(G12=G20,(A12+A13+A14+A15+A16+A17+A18+A19+A20)/9,IF(G12=G19,(A12+A13+A14+A15+A16+A17+A18+A19)/8,IF(G12=G18,(A12+A13+A14+A15+A16+A17+A18)/7,IF(G12=G17,(A12+A13+A14+A15+A16+A17)/6,IF(G12=G16,(A12+A13+A14+A15+A16)/5,IF(G12=G15,(A12+A13+A14+A15)/4,IF(G12=G14,(A12+A13+A14)/3,IF(G12=G13,(A12+A13)/2,9))))))))))","v":6.5},0.83892617449664431,13,19.5,{"$f":"IF(M12=\"\",\"\",IF(K12=K11,M12+1,IF(K12=K10,M12+1,IF(K12=K9,M12+1,IF(K12=K8,M12+1,IF(K12=K7,M12+1,IF(K12=K6,M12+1,IF(K12=K5,M12+1,IF(K12=K4,M12+1,M12)))))))))","v":11},11,0.82200000000000006,0.89400000000000002,"","Rob Verkerke ",null,null,"Edwin Kuijer ",10,76,303,3,"0.250","0.271",85911,"0.291"]
[{"$f":"IF(B13=\"\",\"\",10)","v":10},"Jan Pothof","A.B.C.",2,0.81,1.046,11,{"$f":"IF(D13=\"\",\"\",IF(G13=G12,H12,IF(G13=G21,(A13+A14+A15+A16+A17+A18+A19+A20+A21)/9,IF(G13=G20,(A13+A14+A15+A16+A17+A18+A19+A20)/8,IF(G13=G19,(A13+A14+A15+A16+A17+A18+A19)/7,IF(G13=G18,(A13+A14+A15+A16+A17+A18)/6,IF(G13=G17,(A13+A14+A15+A16+A17)/5,IF(G13=G16,(A13+A14+A15+A16)/4,IF(G13=G15,(A13+A14+A15)/3,IF(G13=G14,(A13+A14)/2,10))))))))))","v":12.5},1.2913580246913581,4,16.5,{"$f":"IF(M13=\"\",\"\",IF(K13=K12,M13+1,IF(K13=K11,M13+1,IF(K13=K10,M13+1,IF(K13=K9,M13+1,IF(K13=K8,M13+1,IF(K13=K7,M13+1,IF(K13=K6,M13+1,IF(K13=K5,M13+1,IF(K13=K4,M13+1,IF(K13=K4,M13+1,M13)))))))))))","v":8},7,0.92800000000000005,0.92800000000000005,"FINALE","Jan Pothof","Nicky Berenschot    ","B.V. van Dorth          ","0.280    ",15," "," ",4,"0.295","0.410",98333,"0.300"]
[{"$f":"IF(B14=\"\",\"\",11)","v":11},"Gerrit Nijenhuis","Gildehuis",2,0.95599999999999996,1.036,11,{"$f":"IF(D14=\"\",\"\",IF(G14=G13,H13,IF(G14=G22,(A14+A15+A16+A17+A18+A19+A20+A21+A22)/9,IF(G14=G21,(A14+A15+A16+A17+A18+A19+A20+A21)/8,IF(G14=G20,(A14+A15+A16+A17+A18+A19+A20)/7,IF(G14=G19,(A14+A15+A16+A17+A18+A19)/6,IF(G14=G18,(A14+A15+A16+A17+A18)/5,IF(G14=G17,(A14+A15+A16+A17)/4,IF(G14=G16,(A14+A15+A16)/3,IF(G14=G15,(A14+A15)/2,11))))))))))","v":12.5},1.0836820083682008,7,19.5,{"$f":"IF(M14=\"\",\"\",IF(K14=K13,M14+1,IF(K14=K12,M14+1,IF(K14=K11,M14+1,IF(K14=K10,M14+1,IF(K14=K9,M14+1,IF(K14=K8,M14+1,IF(K14=K7,M14+1,IF(K14=K6,M14+1,IF(K14=K5,M14+1,IF(K14=K4,M14+1,M14)))))))))))","v":12},{"$f":"IF(ISERROR(RANK(K14,K$4:K$28,1)),\"\",RANK(K14,K$4:K$28,1))","v":11},0.996,{"$f":"IF(B14=\"\",\"\",FLOOR(IF(F14>E14,N14,E14)*1000,1)/1000)","v":0.996},"","Gerrit Nijenhuis","Rein Dieleman","Graafschap","0.280",15," "," ",3,"0.176"," ",53333,"0.330"]
[{"$f":"IF(B15=\"\",\"\",12)","v":12},"Cor Heuven","De Veemarkt",2,0.85599999999999998,0.60699999999999998,11,{"$f":"IF(D15=\"\",\"\",IF(G15=G14,H14,IF(G15=G23,(A15+A16+A17+A18+A19+A20+A21+A22+A23)/9,IF(G15=G22,(A15+A16+A17+A18+A19+A20+A21+A22)/8,IF(G15=G21,(A15+A16+A17+A18+A19+A20+A21)/7,IF(G15=G20,(A15+A16+A17+A18+A19+A20)/6,IF(G15=G19,(A15+A16+A17+A18+A19)/5,IF(G15=G18,(A15+A16+A17+A18)/4,IF(G15=G17,(A15+A16+A17)/3,IF(G15=G16,(A15+A16)/2,12))))))))))","v":12.5},0.70911214953271029,16,28.5,{"$f":"IF(M15=\"\",\"\",IF(K15=K14,M15+1,IF(K15=K13,M15+1,IF(K15=K12,M15+1,IF(K15=K11,M15+1,IF(K15=K10,M15+1,IF(K15=K9,M15+1,IF(K15=K8,M15+1,IF(K15=K7,M15+1,IF(K15=K6,M15+1,IF(K15=K5,M15+1,IF(K15=K3,M15+1,M15))))))))))))","v":15},15,0.73150000000000004,0.85599999999999998,"","Cor Heuven","Erik Holthausen","De Olde Molle","0.280",15," "," ",null,3000,132000]
[{"$f":"IF(B16=\"\",\"\",13)","v":13},"Bennie Schennink","Piet van de Pol",2,0.5,0.60899999999999999,11,{"$f":"IF(D16=\"\",\"\",IF(G16=G15,H15,IF(G16=G24,(A16+A17+A18+A19+A20+A21+A22+A23+A24)/9,IF(G16=G23,(A16+A17+A18+A19+A20+A21+A22+A23)/8,IF(G16=G22,(A16+A17+A18+A19+A20+A21+A22)/7,IF(G16=G21,(A16+A17+A18+A19+A20+A21)/6,IF(G16=G20,(A16+A17+A18+A19+A20)/5,IF(G16=G19,(A16+A17+A18+A19)/4,IF(G16=G18,(A16+A17+A18)/3,IF(G16=G17,(A16+A17)/2,13))))))))))","v":12.5},1.218,6,18.5,{"$f":"IF(M16=\"\",\"\",IF(K16=K15,M16+1,IF(K16=K14,M16+1,IF(K16=K13,M16+1,IF(K16=K12,M16+1,IF(K16=K11,M16+1,IF(K16=K10,M16+1,IF(K16=K9,M16+1,IF(K16=K8,M16+1,IF(K16=K7,M16+1,IF(K16=K7,M16+1,M16)))))))))))","v":10},9,0.55449999999999999,0.55400000000000005,"2e Res","Bennie Schennink","Willem Siebers","Tapperij","0.330",17," "," ",null,2069,106000]
[{"$f":"IF(B17=\"\",\"\",14)","v":14},"Henk Brussee","De Veemarkt",4,0.5,0.38600000000000001,4,{"$f":"IF(D17=\"\",\"\",IF(G17=G16,H16,IF(G17=G25,(A17+A18+A19+A20+A21+A22+A23+A24+A25)/9,IF(G17=G24,(A17+A18+A19+A20+A21+A22+A23+A24)/8,IF(G17=G23,(A17+A18+A19+A20+A21+A22+A23)/7,IF(G17=G22,(A17+A18+A19+A20+A21+A22)/6,IF(G17=G21,(A17+A18+A19+A20+A21)/5,IF(G17=G20,(A17+A18+A19+A20)/4,IF(G17=G19,(A17+A18+A19)/3,IF(G17=G18,(A17+A18)/2,14))))))))))","v":14},0.77200000000000002,14,28,{"$f":"IF(M17=\"\",\"\",IF(K17=K16,M17+1,IF(K17=K15,M17+1,IF(K17=K14,M17+1,IF(K17=K13,M17+1,IF(K17=K12,M17+1,IF(K17=K11,M17+1,IF(K17=K10,M17+1,IF(K17=K9,M17+1,IF(K17=K8,M17+1,IF(K17=K8,M17+1,M17)))))))))))","v":14},14,0.443,0.5,"","Henk Brussee","Frank Stevens","Pand 8","0.280",15," ",null,null,2650,98000]
[{"$f":"IF(B18=\"\",\"\",15)","v":15},"Meindert Siccama","De Veemarkt",2,0.60799999999999998,0.64,11,{"$f":"IF(D18=\"\",\"\",IF(G18=G17,H17,IF(G18=G26,(A18+A19+A20+A21+A22+A23+A24+A25+A26)/9,IF(G18=G25,(A18+A19+A20+A21+A22+A23+A24+A25)/8,IF(G18=G24,(A18+A19+A20+A21+A22+A23+A24)/7,IF(G18=G23,(A18+A19+A20+A21+A22+A23)/6,IF(G18=G22,(A18+A19+A20+A21+A22)/5,IF(G18=G21,(A18+A19+A20+A21)/4,IF(G18=G20,(A18+A19+A20)/3,IF(G18=G19,(A18+A19)/2,15))))))))))","v":15},1.0526315789473684,11,26,13,13,0.624,0.624,"","Meindert Siccama",{"$f":"IF(ISERROR(RANK(K18,K$4:K$28,1)),\"\",RANK(K18,K$4:K$28,1))","v":13},null,null,null,null,null,null,1387,90000]
[{"$f":"IF(B19=\"\",\"\",16)","v":16},"Wim Raasing","Piet van de Pol",0,0.876,0.64700000000000002,16,{"$f":"IF(D19=\"\",\"\",IF(G19=G18,H18,IF(G19=G27,(A19+A20+A21+A22+A23+A24+A25+A26+A27)/9,IF(G19=G26,(A19+A20+A21+A22+A23+A24+A25+A26)/8,IF(G19=G25,(A19+A20+A21+A22+A23+A24+A25)/7,IF(G19=G24,(A19+A20+A21+A22+A23+A24)/6,IF(G19=G23,(A19+A20+A21+A22+A23)/5,IF(G19=G22,(A19+A20+A21+A22)/4,IF(G19=G21,(A19+A20+A21)/3,IF(G19=G20,(A19+A20)/2,16))))))))))","v":16},0.73858447488584478,15,31,16,16,0.76150000000000007,0.876,"","Wim Raasing",16,null,null,null,null,null,null,"0.000",95000]
[{"$f":"IF(B20=\"\",\"\",17)","v":""},null,null,null,null,null,"",{"$f":"IF(D20=\"\",\"\",IF(G20=G19,H19,IF(G20=G28,(A20+A21+A22+A23+A24+A25+A26+A27+A28)/9,IF(G20=G27,(A20+A21+A22+A23+A24+A25+A26+A27)/8,IF(G20=G26,(A20+A21+A22+A23+A24+A25+A26)/7,IF(G20=G25,(A20+A21+A22+A23+A24+A25)/6,IF(G20=G24,(A20+A21+A22+A23+A24)/5,IF(G20=G23,(A20+A21+A22+A23)/4,IF(G20=G22,(A20+A21+A22)/3,IF(G20=G21,(A20+A21)/2,17))))))))))","v":""},"","","","","","","","",0,""]
[{"$f":"IF(B21=\"\",\"\",18)","v":""},null,null,null,null,null,"",{"$f":"IF(D21=\"\",\"\",IF(G21=G20,H20,IF(G21=G29,(A21+A22+A23+A24+A25+A26+A27+A28+A29)/9,IF(G21=G28,(A21+A22+A23+A24+A25+A26+A27+A28)/8,IF(G21=G27,(A21+A22+A23+A24+A25+A26+A27)/7,IF(G21=G26,(A21+A22+A23+A24+A25+A26)/6,IF(G21=G25,(A21+A22+A23+A24+A25)/5,IF(G21=G24,(A21+A22+A23+A24)/4,IF(G21=G23,(A21+A22+A23)/3,IF(G21=G22,(A21+A22)/2,18))))))))))","v":""},"","","","","","","","",0,"",null,null,null,null,null,null,2833,105000]
[{"$f":"IF(B22=\"\",\"\",19)","v":""},null,null,null,null,null,"",{"$f":"IF(D22=\"\",\"\",IF(G22=G21,H21,IF(G22=G30,(A22+A23+A24+A25+A26+A27+A28+A29+A30)/9,IF(G22=G29,(A22+A23+A24+A25+A26+A27+A28+A29)/8,IF(G22=G28,(A22+A23+A24+A25+A26+A27+A28)/7,IF(G22=G27,(A22+A23+A24+A25+A26+A27)/6,IF(G22=G26,(A22+A23+A24+A25+A26)/5,IF(G22=G25,(A22+A23+A24+A25)/4,IF(G22=G24,(A22+A23+A24)/3,IF(G22=G23,(A22+A23)/2,19))))))))))","v":""},"","","","","","","","",0,"",null,null,null,null,null,null,2727,90000]
[{"$f":"IF(B23=\"\",\"\",20)","v":""},null,null,null,null,null,"",{"$f":"IF(D23=\"\",\"\",IF(G23=G22,H22,IF(G23=G31,(A23+A24+A25+A26+A27+A28+A29+A30+A31)/9,IF(G23=G30,(A23+A24+A25+A26+A27+A28+A29+A30)/8,IF(G23=G29,(A23+A24+A25+A26+A27+A28+A29)/7,IF(G23=G28,(A23+A24+A25+A26+A27+A28)/6,IF(G23=G27,(A23+A24+A25+A26+A27)/5,IF(G23=G26,(A23+A24+A25+A26)/4,IF(G23=G25,(A23+A24+A25)/3,IF(G23=G24,(A23+A24)/2,20))))))))))","v":""},"","","","","","","","",0,"",null,null,null,null,null,null,1387,90000]
[{"$f":"IF(B24=\"\",\"\",21)","v":""},null,null,null,null,null,"",{"$f":"IF(D24=\"\",\"\",IF(G24=G23,H23,IF(G24=G32,(A24+A25+A26+A27+A28+A29+A30+A31+A32)/9,IF(G24=G31,(A24+A25+A26+A27+A28+A29+A30+A31)/8,IF(G24=G30,(A24+A25+A26+A27+A28+A29+A30)/7,IF(G24=G29,(A24+A25+A26+A27+A28+A29)/6,IF(G24=G28,(A24+A25+A26+A27+A28)/5,IF(G24=G27,(A24+A25+A26+A27)/4,IF(G24=G26,(A24+A25+A26)/3,IF(G24=G25,(A24+A25)/2,21))))))))))","v":""},"","","","","","","","",0,"",null,null,null,null,null,null,"0.000",95000]
[{"$f":"IF(B25=\"\",\"\",22)","v":""},null,null,null,null,null,"",{"$f":"IF(D25=\"\",\"\",IF(G25=G24,H24,IF(G25=G33,(A25+A26+A27+A28+A29+A30+A31+A32+A33)/9,IF(G25=G32,(A25+A26+A27+A28+A29+A30+A31+A32)/8,IF(G25=G31,(A25+A26+A27+A28+A29+A30+A31)/7,IF(G25=G30,(A25+A26+A27+A28+A29+A30)/6,IF(G25=G29,(A25+A26+A27+A28+A29)/5,IF(G25=G28,(A25+A26+A27+A28)/4,IF(G25=G27,(A25+A26+A27)/3,IF(G25=G26,(A25+A26)/2,22))))))))))","v":""},"","","","","","","","",0,""]
[{"$f":"IF(B26=\"\",\"\",23)","v":""},null,null,null,null,null,"",{"$f":"IF(D26=\"\",\"\",IF(G26=G25,H25,IF(G26=G34,(A26+A27+A28+A29+A30+A31+A32+A33+A34)/9,IF(G26=G33,(A26+A27+A28+A29+A30+A31+A32+A33)/8,IF(G26=G32,(A26+A27+A28+A29+A30+A31+A32)/7,IF(G26=G31,(A26+A27+A28+A29+A30+A31)/6,IF(G26=G30,(A26+A27+A28+A29+A30)/5,IF(G26=G29,(A26+A27+A28+A29)/4,IF(G26=G28,(A26+A27+A28)/3,IF(G26=G27,(A26+A27)/2,23))))))))))","v":""},"","","","","","","","",0,"",null,null,null,null,null,null,2833,105000]
[{"$f":"IF(B27=\"\",\"\",24)","v":""},null,null,null,null,null,"",{"$f":"IF(D27=\"\",\"\",IF(G27=G26,H26,IF(G27=G35,(A27+A28+A29+A30+A31+A32+A33+A34+A35)/9,IF(G27=G34,(A27+A28+A29+A30+A31+A32+A33+A34)/8,IF(G27=G33,(A27+A28+A29+A30+A31+A32+A33)/7,IF(G27=G32,(A27+A28+A29+A30+A31+A32)/6,IF(G27=G31,(A27+A28+A29+A30+A31)/5,IF(G27=G30,(A27+A28+A29+A30)/4,IF(G27=G29,(A27+A28+A29)/3,IF(G27=G28,(A27+A28)/2,24))))))))))","v":""},"","","","","","","","",0,"",null,null,null,null,null,null,2727,90000]
[{"$f":"IF(B28=\"\",\"\",25)","v":""},null,null,null,null,null,"",{"$f":"IF(D28=\"\",\"\",IF(G28=G27,H27,IF(G28=G36,(A28+A29+A30+A31+A32+A33+A34+A35+A36)/9,IF(G28=G35,(A28+A29+A30+A31+A32+A33+A34+A35)/8,IF(G28=G34,(A28+A29+A30+A31+A32+A33+A34)/7,IF(G28=G33,(A28+A29+A30+A31+A32+A33)/6,IF(G28=G32,(A28+A29+A30+A31+A32)/5,IF(G28=G31,(A28+A29+A30+A31)/4,IF(G28=G30,(A28+A29+A30)/3,IF(G28=G29,(A28+A29)/2,25))))))))))","v":""},"","","","","","",{"$f":"IF(B28=\"\",\"\",FLOOR(IF(F28>E28,N28,E28)*1000,1)/1000)","v":""},"",0,"",null,null,null,null,null,null,1516,81000]
[{"$f":"SUM(A4:A28)","v":136},{"$f":"25-COUNTBLANK(B4:B28)","v":16},null,{"$f":"SUM(D4:D28)","v":60},{"$f":"IF(D1=4,B29*4,B29*6)","v":96},null,{"$f":"SUM(G4:G28)","v":104},{"$f":"SUM(H4:H28)","v":140},null,{"$f":"SUM(J4:J28)","v":136},{"$f":"SUM(K4:K28)","v":276},{"$f":"SUM(L4:L28)","v":136}]
[{"$f":"IF(A29=H29,\"\",IF(A29=L29,\"\",IF(A29=J29,\"\",\"FOUT in een kolom \")))","v":""},{"$f":"IF(D1=4,B29*4,B29*6)","v":96},null,{"$f":"IF(E29=B30,\"\",\"fout in invoer spelers\")","v":""},null,{"$f":"MAX(A4:A28)","v":16},null,null,null,null,{"$f":"IF(J29+H29=K29,\"\",\"fout in telling\")","v":""},{"$f":"IF(L29=J29,\"\",\"fout in invoer spelers\")","v":""}]
["naar de finale gaan"]
["rang","naam speler",null,"moy.","car.","positie"]
[1,{"$f":"VLOOKUP(A33,$L$4:$Q$28,6,FALSE)","v":"Gerard Versteege"},{"$f":"IF(A4>0.01,VLOOKUP(B33,B$4:C$28,2,FALSE),\"\")","v":"Concordia`54"},{"$f":"VLOOKUP(B33,$B$4:$O$28,14,FALSE)","v":0.86499999999999999},null,{"$f":"VLOOKUP(B33,B:P,15,FALSE)","v":"FINALE"}]
[2,"Herman Jansen",{"$f":"IF(A5>0.01,VLOOKUP(B34,B$4:C$28,2,FALSE),\"\")","v":"A.B.C."},{"$f":"VLOOKUP(B34,$B$4:$O$28,14,FALSE)","v":0.745},null,{"$f":"VLOOKUP(B34,B:P,15,FALSE)","v":"FINALE"}]
[3,"Eric Holthausen","De Olde Mölle",0.56999999999999995,null,"FINALE"]
[4,"Henk Vollema","Concordia`54",1.0029999999999999,null,"FINALE"]
[5,"Bertus Mensert","De Veemarkt",0.71399999999999997,null,"FINALE"]
[6,"Antoon Jacobs","Buitenmolen",0.70899999999999996,null,"FINALE"]
[7,"Wim Leusink","De Veemarkt",1.012,null,"FINALE"]
[8,"Jan Pothof","A.B.C.",0.92800000000000005,null,{"$f":"VLOOKUP(B40,B:P,15,FALSE)","v":"FINALE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1800,73000]
[9,"Ulrich Verheyen","Gildehuis",0.83,null,"1e Res"]
[10,"Bennie Schennink","Piet van de Pol",0.55400000000000005,null,"2e Res"]
[]
["·         Je moet ingeven: naam speler, punten behaald, moyennes start en behaald en op sorteren klikken"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4285,96333]
["·         Je ziet in de gele kolommen de ranglijsten die eruit komt na berekening van resp.  de punten en het moyennepercentage. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2136,103942]
["·         Bij hetzelfde aantal punten wordt hier een berekening gemaakt om bij gelijk geëindigde spelers in resp. punten dezelfde score te krijgen. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3533,103702]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lucilio Cordeiro    ","Ons Genoegen (Z)      ",0.3,16," "," "," "," ",2208,94136]
["·         In de blauwe kolom zijn de resultaten van de gele kolommen bij elkaar opgeteld en hier komt een getal uit waarbij de minste punten de rangschikking bepaald.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edwin Kuijer","De Olde Molle",0.29099999999999998,15," "," "," "," ",1566,78138]
["                  Bij gelijk aantal punten in de blauwe kolom worden resultaten van de eerste gele kolom doorslaggevend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wim Sak","Tapperij",0.35499999999999998,18," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hans Zandbergen","Nieuwe Rosegaar","0.330",17," "," "," "," "]

{"sheet":"Blad2","index":1,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["0.220 0.240 0.528 12 Inschrijven vanaf 0,000 mag worden toegestaan,men wordt dan wel op 0,220 (ondergrens) ingeschreven 60 0.240 0.260 13 0.260 0.280 14 0.280 0.300 15 0.300 - 0.320 16 0.320 - 0.340 17 0.340 - 0.360 18 0.360 0.380 19 0.380 - 0.400 20 0.400 - 0.420 21 0.420 - 0.440 22 Uitloop tot +20% 0.440 - 0.480 23 0.480 - 0.520 25 0.520 - 0.528 27"]
[]
[]
[null,"0.220 0.240 "]
[null,"0.528 "]
[null,12]
[null," ",null,null,null,null,null,"0.300 - 0.350 "]
[null,"Inschrijven vanaf ",null,null,null,null,null,1680]
[null,"0,000 mag worden ",null,null,null,null,null,20]
[null,"toegestaan,men ",null,null,null,null,null," "]
[null,"wordt dan wel op ",null,null,null,null,null,"Inschrijven vanaf "]
[null,"0,220 (ondergrens) ",null,null,null,null,null,"0,000 mag worden "]
[null,"ingeschreven ",null,null,null,null,null,"toegestaan, "]
[null,60,null,null,null,null,null,"men wordt dan wel "]
[null,"0.240 0.260 13 ",null,null,null,null,null,"op 0,300 (ondergrens) "]
[null,"0.260 0.280 14 ",null,null,null,null,null,"ingeschreven "]
[null,"0.280 0.300 15 ",null,null,null,null,null,60]
[null,"0.300 - 0.320 16 ",null,null,null,null,null,"0.350 - 0.400",0.35,21]
[null,"0.320 - 0.340 17 ",null,null,null,null,null,"0.400 - 0.500 ",0.4,23]
[null,"0.340 - 0.360 18 ",null,null,null,null,null,"0.500 - 0.600 25 ",0.5,25]
[null,"0.360 0.380 19 ",null,null,null,null,null,"0.600 - 0.700 27 ",6,27]
[null,"0.380 - 0.400 20 ",null,null,null,null,null,"0.700 - 0.800 29 ",0.7,29]
[null,"0.400 - 0.420 21 ",null,null,null,null,null,"0.800 - 0.900 31 ",0.8,31]
[null,"0.420 - 0.440 22 ",null,null,null,null,null,"0.900 - 1.000 33 ",0.9,33]
[null,"Uitloop tot +20% ",null,null,null,null,null,"1.000 - 1.100 35 ",1,35]
[null,"0.440 - 0.480 23 ",null,null,null,null,null,"1.100 - 1.200 37 ",1.1000000000000001,37]
[null,"0.480 - 0.520 25 ",null,null,null,null,null,"1.200 - 1.300 39 ",1.2,39]
[null,"0.520 - 0.528 27",null,null,null,null,null,"1.300 - 1.400 41 ",1.3,41]
[null,null,null,null,null,null,null,"Uitloop tot +20% "]
[null,null,null,null,null,null,null,"1.400 - 1.500 43 ",1.4,43]
[null,null,null,null,null,null,null,"1.500 - 1.600 45 ",1.5,45]
[null,null,null,null,null,null,null,"1.600 - 1.680 47 ",1.6,47]
[null,null,null,null,null,null,null,"Libre-klein 3e klasse ",1.7,49]
[null,null,null,null,null,null,null,"1,400-2,400 ",1.8,51]
[null,null,null,null,null,null,null,"INTERVALSYSTEEM ",1.9,53]
[null,null,null,null,null,null,null,"1.400 - 1.500 ",2,55]
[null,null,null,null,null,null,null,2880,2.2000000000000002]
[null,null,null,null,null,null,null,43,2.4]
[null,null,null,null,null,null,null,40,2.6]
[null,null,null,null,null,null,null,"1.500 - 1.600 45 ",2.8]
[null,null,null,null,null,null,null,"1.600 - 1.700 47 ",3]
[null,null,null,null,null,null,null,"1.700 - 1.800 49 ",3.5]
[null,null,null,null,null,null,null,"1.800 - 1.900 51 ",4]
[null,null,null,null,null,null,null,"1.900 - 2.000 53 ",4.5]
[null,null,null,null,null,null,null,"2.000 - 2.200 55 ",5]
[null,null,null,null,null,null,null,"2.200 - 2.400 60 "]
[null,null,null,null,null,null,null,"Uitloop tot +20% "]
[null,null,null,null,null,null,null,"2.400 - 2.600 65 "]
[null,null,null,null,null,null,null,"2.600 - 2.800 70 "]
[null,null,null,null,null,null,null,"2.800 - 2.880 75 "]
[null,null,null,null,null,null,null,"Libre-klein 2e klasse "]
[null,null,null,null,null,null,null,"2,400-4,000 "]
[null,null,null,null,null,null,null,"VAST AANTAL CARAMBOLES "]
[null,null,null,null,null,null,null,"2.400 - 2.600 "]
[null,null,null,null,null,null,null,4800]
[null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,"90 40"]
[null,null,null,null,null,null,null,"2.600 - 2.800 70 "]
[null,null,null,null,null,null,null,"2.800 - 3.000 75 "]
[null,null,null,null,null,null,null,"3.000 - 3.500 80 "]
[null,null,null,null,null,null,null,"3.500 - 4.000 90"]
[]
[null,null,null,null,null,null,null,"4.000 - 4.500 "]
[null,null,null,null,null,null,null,8400]
[null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,"125 40"]
[null,null,null,null,null,null,null,"4.500 - 5.000 110 "]
[null,null,null,null,null,null,null,"5.000 - 5.500 120 "]
[null,null,null,null,null,null,null,"5.500 - 6.000 130 "]
[null,null,null,null,null,null,null,"6.000 - 6.500 140 "]
[null,null,null,null,null,null,null,"6.500 - 7.000 150 "]
[null,null,null,null,null,null,null,"Libre-klein Hoofdklasse "]
[null,null,null,null,null,null,null,"Gewestelijk "]
[null,null,null,null,null,null,null,"7,000-11,000 "]
[null,null,null,null,null,null,null,"VAST AANTAL CARAMBOLES "]
[null,null,null,null,null,null,null,7000]
[null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,8000]
[null,null,null,null,null,null,null,13200]
[null,null,null,null,null,null,null,160]
[null,null,null,null,null,null,null,"160 30"]
[null,null,null,null,null,null,null,"8.000 9.000 170 "]
[null,null,null,null,null,null,null,"9.000 10.000 180 "]
[null,null,null,null,null,null,null,"10.000 11.000"]

{"sheet":"Blad3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}