{"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":[[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],[2,5,2,9],[3,5,3,9]]}
[]
[null,null,null,null,null,"Indien een andere melding, geef verder info:"]
["NUMMER",null,"Status"]
[1,{"$f":"MAX(gegevens!A5:A11)","v":2},{"$f":"IF(B4=0,0,VLOOKUP(B4,gegevens!$A$5:$B$11,2,FALSE))","v":"Emergency stop B"}]
[null,{"$f":"LARGE(gegevens!A5:A11,2)","v":1},{"$f":"IF(B5=0,0,VLOOKUP(B5,gegevens!$A$5:$B$11,2,FALSE))","v":"Emergency stop E"}]
[null,{"$f":"SMALL(gegevens!A5:A11,6)","v":1},{"$f":"IF(B6=0,0,VLOOKUP(B6,gegevens!$A$5:$B$11,2,FALSE))","v":"Emergency stop E"}]
[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":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,14,8,16],[4,14,4,18],[23,7,23,11],[0,0,0,1],[20,14,20,18],[22,14,22,18],[10,14,10,18],[12,14,12,18],[14,14,14,18],[4,7,4,11],[8,7,8,9],[10,7,10,11],[12,7,12,11],[15,7,15,11],[19,7,19,9],[21,7,21,11],[18,14,18,16],[18,21,18,23],[18,28,18,30],[14,21,14,25],[14,28,14,32],[20,21,20,25],[20,28,20,32],[22,21,22,25],[22,28,22,32],[4,21,4,25],[4,28,4,32],[8,21,8,23],[8,28,8,30],[10,21,10,25],[10,28,10,32],[12,21,12,25],[12,28,12,32]]}
[null,null,null,null,null,"Hoe bepaal je deze rij?"]
[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,"en hoe breng ik dit naar het tabblad monitor?"]
["aantal","benaming","gewicht","RANK","index","rij"]
[{"$f":"SUM(LEN(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"Emergency stop A\",\"\")))/LEN(\"Emergency stop A\")","v":0},"Emergency stop A",115,{"$f":"_xlfn.RANK.AVG(C5,$C$5:$C$11,14)","v":7},{"$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(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"Emergency stop B\",\"\")))/LEN(\"Emergency stop B\")","v":2},"Emergency stop B",110,6,{"$f":"INDEX($A$5:$C$11,2,3)","v":110},1]
[{"$f":"SUM(LEN(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"\",\"Emergency stop C\")))/LEN(\"Emergency stop C\")","v":0},"Emergency stop C",100,5,{"$f":"INDEX($A$5:$C$11,3,3)","v":100}]
[{"$f":"SUM(LEN(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"Emergency stop D\",\"\")))/LEN(\"Emergency stop D\")","v":0},"Emergency stop D",10,1,{"$f":"INDEX($A$5:$C$11,4,3)","v":10}]
[{"$f":"SUM(LEN(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"Emergency stop E\",\"\")))/LEN(\"Emergency stop E\")","v":1},"Emergency stop E",20,2,{"$f":"INDEX($A$5:$C$11,5,3)","v":20}]
[{"$f":"SUM(LEN(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"Emergency stop F\",\"\")))/LEN(\"Emergency stop F\")","v":1},"Emergency stop F",30,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(H4:AH26)-LEN(SUBSTITUTE(H4:AH26,\"Ander\",\"\")))/LEN(\"Ander\")","v":1},"Ander",90,4,{"$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,"Indien andere:",null,null,null,null,null,null,"Indien andere:"]
[]
[]
[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,"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,"Emergency stop B",null,null,null,null,null,null,"Ander"]
["Emergency stop E",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,"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"]