{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["week1","cum uitslag","speelschema"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":5,"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":"week1","index":0,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Naam","aanwezig",null,null,null,"2019-11-15",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["ik","o",{"$f":"IF(B2=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B2=\"x\",A2,\"\")","v":""},null,"week 1","Speler 1","Speler 2","Speler 3","Speler 4","Speler 5",null,null,null,null,null,null,null,null,"gij"]
["gij","o",{"$f":"IF(B3=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B3=\"x\",A3,\"\")","v":""},null,"Naam"]
["hij","o",{"$f":"IF(B4=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B4=\"x\",A4,\"\")","v":""},null,"Ronde 1"]
["d","o",{"$f":"IF(B5=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B5=\"x\",A5,\"\")","v":""},null,"Ronde 2"]
["e","o",{"$f":"IF(B6=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B6=\"x\",A6,\"\")","v":""},null,"Ronde 3"]
["f","o",{"$f":"IF(B7=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B7=\"x\",A7,\"\")","v":""},null,"Ronde 4"]
["g","o",{"$f":"IF(B8=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B8=\"x\",A8,\"\")","v":""},null,"Ronde 5"]
["h","o",{"$f":"IF(B9=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B9=\"x\",A9,\"\")","v":""},null,"Sub Tot",{"$f":"SUM(G4:G8)","v":0},{"$f":"SUM(H4:H8)","v":0},0,0,0]
["i","o",{"$f":"IF(B10=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B10=\"x\",A10,\"\")","v":""}]
["wij","o",{"$f":"IF(B11=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B11=\"x\",A11,\"\")","v":""},null,{"$f":"F2","v":"week 1"},"Speler 6","Speler 7","Speler 8","Speler9","Speler 10"]
[null,"o",{"$f":"IF(B12=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B12=\"x\",A12,\"\")","v":""},null,"Naam"]
[null,"o",{"$f":"IF(B13=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B13=\"x\",A13,\"\")","v":""},null,"Ronde 1"]
[null,"o",{"$f":"IF(B14=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B14=\"x\",A14,\"\")","v":""},null,"Ronde 2"]
[null,"o",{"$f":"IF(B15=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B15=\"x\",A15,\"\")","v":""},null,"Ronde 3"]
[null,"o",{"$f":"IF(B16=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B16=\"x\",A16,\"\")","v":""},null,"Ronde 4"]
[null,"o",{"$f":"IF(B17=\"x\",RAND(),\"\")","v":""},{"$f":"IF(B17=\"x\",A17,\"\")","v":""},null,"Ronde 5"]
[null,null,null,null,null,"Sub Tot",{"$f":"SUM(G13:G17)","v":0},{"$f":"SUM(H13:H17)","v":0},{"$f":"SUM(I13:I17)","v":0},{"$f":"SUM(J13:J17)","v":0},{"$f":"SUM(K13:K17)","v":0}]
[]
[null,null,null,null,null,{"$f":"F2","v":"week 1"},"Speler 11","Speler 12","Speler13","Speler 14","Speler 15"]
[null,null,null,null,null,"Naam"]
[null,null,null,null,null,"Ronde 1"]
[null,null,null,null,null,"Ronde 2"]
[null,null,null,null,null,"Ronde 3"]
[null,null,null,null,null,"Ronde 4"]
[null,null,null,null,null,"Ronde 5"]
[null,null,null,null,null,"Sub Tot",{"$f":"SUM(G22:G26)","v":0},{"$f":"SUM(H22:H26)","v":0},{"$f":"SUM(I22:I26)","v":0},{"$f":"SUM(J22:J26)","v":0},{"$f":"SUM(K22:K26)","v":0}]

{"sheet":"cum uitslag","index":1,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Speeldatum"]
[null,"Naam","week 1","week 2","week 3","week 4","week 5","week 6","week 7","week 8","week 9","week 10","week 11","week 12","week 13","week 14","week 15","Totaal",null,"GEMIDD"]
[null,"ik",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C3:Q3)","v":0},null,{"$f":"AVERAGEIF(C3:Q3,\"<>0\")","v":{"$error":"#DIV/0!"}}]
[null,"gij",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C4:Q4)","v":0},null,{"$error":"#DIV/0!"}]
[null,"hij",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:Q5)","v":0},null,{"$error":"#DIV/0!"}]
[null,"d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C6:Q6)","v":0},null,{"$error":"#DIV/0!"}]
[null,"e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:Q7)","v":0},null,{"$error":"#DIV/0!"}]
[null,"f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:Q8)","v":0},null,{"$error":"#DIV/0!"}]
[null,"g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:Q9)","v":0},null,{"$error":"#DIV/0!"}]
[null,"h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C10:Q10)","v":0},null,{"$error":"#DIV/0!"}]
[null,"i",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C11:Q11)","v":0},null,{"$error":"#DIV/0!"}]
[null,"wij",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C12:Q12)","v":0},null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:Q13)","v":0},null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C14:Q14)","v":0},null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:Q15)","v":0},null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16:Q16)","v":0},null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:Q17)","v":0},null,{"$error":"#DIV/0!"}]

{"sheet":"speelschema","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["SPEELSCHEMA","DATA",null,"deelnemers "]
["week 1","2019-11-15",null,"Naam","adres","gemeente","tel","email adres"]
["week 2","2019-11-22",null,"ik","huis","ergens","samsung","ja"]
["week 3","2019-11-29",null,"gij","straat","daar","nokia","nee"]
["week 4","2019-12-13",null,"hij","weg","hier","zwart"]
["week 5","2020-01-10",null,"d"]
["week 6","2020-01-17",null,"e"]
["week 7","2020-01-24",null,"f"]
["week 8","2020-02-07",null,"g"]
["week 9","2020-02-14",null,"h"]
["week 10","2020-02-21",null,"i"]
["week 11","2020-02-28",null,"wij","","","",""]
["week 12","2020-03-06"]
["week 13","2020-03-13"]
["week 14","2020-03-20"]
["week 15","2020-03-27"]
[null,null,null,null,"","","",""]
[null,null,null,null,"","","",""]