{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Blad1","index":0,"n_rows":132,"n_cols":20,"rows_kept":132,"merged":[[0,7,0,9],[1,2,1,3],[3,2,3,3],[5,2,5,3],[7,2,7,3],[9,2,9,3]]}
[null,null,4,{"$nulls":4},"©HW-Products / V.1.05"]
[null,"m","Basisscore",null,220,null,3]
[null,"M"]
[null,"v","Handicap percentage ",null,80,null,4]
[null,"V"]
[null,null,"Maximale handicap",null,60,null,5]
[]
[null,null,"Aantal games",null,6,null,6]
[]
[null,null,"Mixed Toernooi ",null,"Nee",null,"Ja"]
[{"$nulls":6},"Nee"]
[null,null,"Naam","Gesl.","Pas gem.","Handicap berekenen","HCP","Game 1","Game 2","Game 3","Game 4","Game 5","Game 6","Aantal games","Score scratch","Totaal HCP","Totaal score","Gem.     scratch","Gem. incl.  handicap","Hgst game"]
[null,{"$f":"IF($C13<>\"\",ROW()-12,\"\")","v":1},"Daphne Deur","v",199,{"$f":"IF($E13<>\"\",($E$4/100)*($E$2-$E13),\"\")","v":{"v":16.8,"d":"16.80"}},{"$f":"IF($E13=\"\",\"\",IF($F13>$E$6,$E$6,TRUNC(($E$4/100)*($E$2-$E13),0)))","v":16},203,189,175,178,201,202,{"$f":"IF(H13<>\"\",COUNTA(H13:M13),\"\")","v":6},{"$f":"IF($N13<>\"\",SUM(H13:M13),\"\")","v":1148},{"$f":"IF($N13<>\"\",($N13*$G13),\"\")","v":96},{"$f":"IF($N13<>\"\",SUM($O13+$P13),\"\")","v":1244},{"$f":"IF($N13<>\"\",SUM($O13/$N13),0)","v":{"v":191.33333333333334,"d":"191.33"}},{"$f":"IF($N13<>\"\",SUM($Q13/$N13),0)","v":{"v":207.33333333333334,"d":"207.33"}},{"$f":"MAX($H13:$M13)","v":203}]
[null,2,"Ad Aarts","m",170,{"v":40,"d":"40.00"},40,160,172,161,180,133,185,6,991,240,1231,{"v":165.16666666666666,"d":"165.17"},{"v":205.16666666666666,"d":"205.17"},{"$f":"IF($G14<>\"\",MAX($H14:$M14),0)","v":185}]
[null,3,"Frits Flinkenvleugel","m",154,{"v":52.800000000000004,"d":"52.80"},52,154,154,156,151,151,149,6,915,312,1227,{"v":152.5,"d":"152.50"},{"v":204.5,"d":"204.50"},{"$f":"MAX($H15:$M15)","v":156}]
[null,4,"Eddie Engel","m",110,{"v":88,"d":"88.00"},60,140,126,156,156,133,142,6,853,360,1213,{"v":142.16666666666666,"d":"142.17"},{"v":202.16666666666666,"d":"202.17"},156]
[null,5,"Beatrix Bal","v",164,{"v":44.800000000000004,"d":"44.80"},44,167,177,171,122,144,152,6,933,264,1197,{"v":155.5,"d":"155.50"},{"v":199.5,"d":"199.50"},177]
[null,6,"Corne Coureur","m",126,{"v":75.2,"d":"75.20"},60,155,134,118,98,134,166,6,805,360,1165,{"v":134.16666666666666,"d":"134.17"},{"v":194.16666666666666,"d":"194.17"},166]
[null,7,"Gerard Balk","m",149,{"v":56.800000000000004,"d":"56.80"},56,{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,8,"Fiona Fietsegraag","v",175,{"v":36,"d":"36.00"},36,{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,{"$f":"IF($C43<>\"\",ROW()-12,\"\")","v":""},{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},{"$f":"IF($E45<>\"\",($E$4/100)*($E$2-$E45),\"\")","v":""},{"$f":"IF($E45=\"\",\"\",IF($F45>$E$6,$E$6,TRUNC(($E$4/100)*($E$2-$E45),0)))","v":""},{"$nulls":6},{"$f":"IF(H45<>\"\",COUNTA(H45:M45),\"\")","v":""},{"$f":"IF($N45<>\"\",SUM(H45:M45),\"\")","v":""},{"$f":"IF($N45<>\"\",($N45*$G45),\"\")","v":""},{"$f":"IF($N45<>\"\",SUM($O45+$P45),\"\")","v":""},{"$f":"IF($N45<>\"\",SUM($O45/$N45),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($N45<>\"\",SUM($Q45/$N45),0)","v":{"v":0,"d":"0.00"}},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"MAX($H47:$M47)","v":0}]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,{"$f":"IF($C75<>\"\",ROW()-12,\"\")","v":""},{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},{"$f":"IF($E77<>\"\",($E$4/100)*($E$2-$E77),\"\")","v":""},{"$f":"IF($E77=\"\",\"\",IF($F77>$E$6,$E$6,TRUNC(($E$4/100)*($E$2-$E77),0)))","v":""},{"$nulls":6},{"$f":"IF(H77<>\"\",COUNTA(H77:M77),\"\")","v":""},{"$f":"IF($N77<>\"\",SUM(H77:M77),\"\")","v":""},{"$f":"IF($N77<>\"\",($N77*$G77),\"\")","v":""},{"$f":"IF($N77<>\"\",SUM($O77+$P77),\"\")","v":""},{"$f":"IF($N77<>\"\",SUM($O77/$N77),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($N77<>\"\",SUM($Q77/$N77),0)","v":{"v":0,"d":"0.00"}},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"MAX($H79:$M79)","v":0}]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},{"$f":"IF($E109<>\"\",($E$4/100)*($E$2-$E109),\"\")","v":""},{"$f":"IF($E109=\"\",\"\",IF($F109>$E$6,$E$6,TRUNC(($E$4/100)*($E$2-$E109),0)))","v":""},{"$nulls":6},{"$f":"IF(H109<>\"\",COUNTA(H109:M109),\"\")","v":""},{"$f":"IF($N109<>\"\",SUM(H109:M109),\"\")","v":""},{"$f":"IF($N109<>\"\",($N109*$G109),\"\")","v":""},{"$f":"IF($N109<>\"\",SUM($O109+$P109),\"\")","v":""},{"$f":"IF($N109<>\"\",SUM($O109/$N109),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($N109<>\"\",SUM($Q109/$N109),0)","v":{"v":0,"d":"0.00"}},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"MAX($H111:$M111)","v":0}]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
[null,"",{"$nulls":3},"","",{"$nulls":6},"","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]