{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Monitor","gegevens","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Monitor","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,5,2,9],[3,5,3,9],[6,0,8,0],[6,5,6,9],[16,2,16,4],[0,0,0,10],[2,2,2,4],[3,2,3,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[3,0,5,0],[4,2,4,4],[5,2,5,4]]}
[]
[null,null,null,null,null,"Indien een andere melding, geef verder info:"]
["NUMMER",null,"Status"]
[1,{"$f":"INDEX(gegevens!$A$5:$C$11,MATCH(SMALL(gegevens!$E$5:$E$11,ROW()-3),gegevens!$E$5:$E$11,0),1)","v":2},{"$f":"IF(B4=0,0,INDEX(gegevens!$A$5:$C$11,MATCH(SMALL(gegevens!$E$5:$E$11,ROW()-3),gegevens!$E$5:$E$11,0),2))","v":"Emergency stop B"}]
[null,{"$f":"INDEX(gegevens!$A$5:$C$11,MATCH(SMALL(gegevens!$E$5:$E$11,ROW()-3),gegevens!$E$5:$E$11,0),1)","v":1},{"$f":"IF(B5=0,0,INDEX(gegevens!$A$5:$C$11,MATCH(SMALL(gegevens!$E$5:$E$11,ROW()-3),gegevens!$E$5:$E$11,0),2))","v":"Ander"}]
[null,{"$f":"INDEX(gegevens!$A$5:$C$11,MATCH(SMALL(gegevens!$E$5:$E$11,ROW()-3),gegevens!$E$5:$E$11,0),1)","v":1},{"$f":"IF(B6=0,0,INDEX(gegevens!$A$5:$C$11,MATCH(SMALL(gegevens!$E$5:$E$11,ROW()-3),gegevens!$E$5:$E$11,0),2))","v":"Emergency stop F"}]
[2,null,{"$f":"IF(B7=0,0,VLOOKUP(B7,gegevens!A8:B11,2,FALSE))","v":0}]
[null,null,{"$f":"IF(B8=0,0,VLOOKUP(B8,gegevens!A9:B11,2,FALSE))","v":0}]
[null,null,{"$f":"IF(B9=0,0,VLOOKUP(B9,gegevens!A10:B11,2,FALSE))","v":0}]
[5]
[6]
[7]
[8]
[]
[]
[]
[9]

{"sheet":"gegevens","index":1,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,22,20,26],[20,29,20,33],[22,22,22,26],[22,29,22,33],[4,22,4,26],[4,29,4,33],[8,22,8,24],[8,29,8,31],[10,22,10,26],[10,29,10,33],[12,22,12,26],[12,29,12,33],[18,15,18,17],[18,22,18,24],[18,29,18,31],[14,22,14,26],[14,29,14,33],[8,15,8,17],[4,15,4,19],[23,8,23,12],[0,0,0,1],[20,15,20,19],[22,15,22,19],[10,15,10,19],[12,15,12,19],[14,15,14,19],[4,8,4,12],[8,8,8,10],[10,8,10,12],[12,8,12,12],[15,8,15,12],[19,8,19,10],[21,8,21,12]]}
[null,null,null,null,null,null,"Hoe bepaal je deze rij?"]
[null,null,null,null,null,null,"Als er 3 benamingen zijn met hetzelfde aantal en je moet een top 3 maken adhv een gewicht of rank, hoe schrijf je dit in formule?"]
[null,null,null,null,null,null,"en hoe breng ik dit naar het tabblad monitor?"]
["aantal","benaming","gewicht","hulp","RANK","index","rij"]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"Emergency stop A\",\"\")))/LEN(\"Emergency stop A\")","v":0},"Emergency stop A",115,{"$f":"(A5&C5)*1","v":115},{"$f":"_xlfn.RANK.AVG(D5,$D$5:$D$11)","v":5},{"$f":"INDEX($A$5:$C$11,1,3)","v":115},null,null,null,null,null,null,null,null,null,"11 defect:",null,null,null,null,null,null,"21 defect:"]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"Emergency stop B\",\"\")))/LEN(\"Emergency stop B\")","v":2},"Emergency stop B",110,{"$f":"(A6&C6)*1","v":2110},{"$f":"_xlfn.RANK.AVG(D6,$D$5:$D$11)","v":1},{"$f":"INDEX($A$5:$C$11,2,3)","v":110},1]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"\",\"Emergency stop C\")))/LEN(\"Emergency stop C\")","v":0},"Emergency stop C",100,100,6,{"$f":"INDEX($A$5:$C$11,3,3)","v":100}]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"Emergency stop D\",\"\")))/LEN(\"Emergency stop D\")","v":0},"Emergency stop D",10,10,7,{"$f":"INDEX($A$5:$C$11,4,3)","v":10}]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"Emergency stop E\",\"\")))/LEN(\"Emergency stop E\")","v":1},"Emergency stop E",20,120,4,{"$f":"INDEX($A$5:$C$11,5,3)","v":20}]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"Emergency stop F\",\"\")))/LEN(\"Emergency stop F\")","v":1},"Emergency stop F",30,130,3,{"$f":"INDEX($A$5:$C$11,6,3)","v":30},3,null,null,null,null,null,null,null,null,"Geef de specifieke melding:",null,null,null,null,null,null,"Geef de specifieke melding:"]
[{"$f":"SUM(LEN(I4:AI26)-LEN(SUBSTITUTE(I4:AI26,\"Ander\",\"\")))/LEN(\"Ander\")","v":1},"Ander",90,190,2,{"$f":"INDEX($A$5:$C$11,7,3)","v":90},2,null,"Emergency stop E",null,null,null,null,null,null,"Emergency stop B",null,null,null,null,null,null,"Emergency stop C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indien andere:",null,null,null,null,null,null,"Indien andere:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 22 defect:",null,null,null,null,null,null,"12 defect:"]
[]
[]
["Emergency stop A"]
["Emergency stop B"]
["Emergency stop C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geef de specifieke melding:",null,null,null,null,null,null,"Geef de specifieke melding:"]
["Emergency stop D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency stop B",null,null,null,null,null,null,"Ander"]
["Emergency stop E",null,null,null,null,null,null,null,"Emergency stop F",null,null,null,null,null,null,"Indien andere:",null,null,null,null,null,null,"Indien andere:"]
["Emergency stop F"]
["Ander"]
[]
[null,null,null,null,null,null,null,null,"de gegevens worden telkens in een kleine opdracht monitor ingegeven adhv dropdownlists (zie vb 22 defect:)"]

{"sheet":"Data","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ja",null,"Emergency stop A"]
[null,"Nee",null,"Emergency stop B"]
[null,null,null,"Emergency stop C"]
[null,null,null,"Emergency stop D"]
[null,null,null,"Emergency stop E"]
[null,null,null,"Emergency stop F"]
[null,null,null,"Ander"]