{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["form&result","Figuur","te verbergen"],"not_rendered":{"charts":2,"images":47,"macros":1,"external_links":0,"defined_names":1,"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":"form&result","index":0,"n_rows":31,"n_cols":27,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,25,8,26],[10,25,10,26],[6,25,6,26],[2,25,2,26],[3,25,3,26],[5,25,5,26],[7,25,7,26],[17,25,17,26],[28,25,28,26],[29,25,29,26],[30,25,30,26],[12,25,12,26],[27,25,27,26]]}
[]
[null,"Beweegvriendelijkheid",null,null,null,null,null,1,"select","var","knopscore"]
[null,null,null,null,null,null,null,2,true,"Beweegvriendelijkheid",1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stap 1:","Vink aan voor welke thema's je de Quickscan wilt invullen."]
[null,"Bodemkwaliteit",null,null,null,null,null,3,true,"Bodemkwaliteit",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra, eigen, thema's toevoegen kan. Vul dan op de … de naam in."]
[null,null,null,null,null,null,null,4,true,"Groen",5]
[null,"Groen",null,null,null,null,null,5,true,"Hitte",4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stap 2:","Bepaal m.b.v. de themabladen de score voor ieder thema."]
[null,null,null,null,null,null,null,6,true,"Industrie",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weten hoe? In 'Toelichting en Instructie' lees je meer"]
[null,"Hitte",null,null,null,null,null,7,true,"Sociale Veiligheid",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vul deze in met behulp van de knoppen."]
[null,null,null,null,null,null,null,8,true,"Veehouderij - Fijn Stof",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De figuur wordt direct aangepast."]
[null,"Industrie",null,null,null,null,null,9,true,"Veehouderij - Omgeving",3]
[null,null,null,null,null,null,null,10,true,"Verkeer - NO2",4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stap 3:","Bespreek de resultaten!"]
[null,"Sociale Veiligheid",null,null,null,null,null,11,true,"Verkeer - Geluid",2]
[null,null,null,null,null,null,null,12,true,"Verkeersveiligheid",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figuur printen?"]
[null,"Veehouderij - Fijn Stof",null,null,null,null,null,13,true,"Voorzieningen",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ga onderaan naar het tabblad 'Figuur'"]
[null,null,null,null,null,null,null,14,false,"...",1,{"$f":"IF(I15=TRUE,M15,N15)","v":"vink aan voor extra thema"},"vul rechts variabelenaam in","vink aan voor extra thema",null,null,null,null,null,null,null,null,null,null,null,null,"Ga naar afdrukken (bestand>afdrukken)"]
[null,"Veehouderij - Omgeving",null,null,null,null,null,15,false,"…",1,{"$f":"IF(I16=TRUE,M16,N16)","v":"vink aan voor extra thema"},"vul rechts variabelenaam in","vink aan voor extra thema",null,null,null,null,null,null,null,null,null,null,null,null,"Je krijgt nu paginavullend je eigen figuur"]
[null,null,null,null,null,null,null,16,false,"…",1,{"$f":"IF(I17=TRUE,M17,N17)","v":"vink aan voor extra thema"},"vul rechts variabelenaam in","vink aan voor extra thema"]
[null,"Verkeer - Geluid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figuur invoegen in advies?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ga onderaan naar het tabblad 'Figuur'en klik 1x op het figuur"]
[null,"Verkeer - NO2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopieer (ctrl+c)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ga naar je Word-bestand"]
[null,"Verkeersveiligheid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plak als afbeelding (bestand>plakken>afbeelding)"]
[]
[null,"Voorzieningen"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deze publicatie kan als volgt worden aangehaald:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quickscan Gezonde Leefomgeving, Scoreblad, versie april 2020. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GGD’en Gelderland en Overijssel."]

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

{"sheet":"te verbergen","index":2,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[" "]
["rang+tie","var","score","rang","tie-breaker","gesorteerde rang","aangevinkt"]
[{"$f":"D3+E3","v":12.0001},{"$f":"'form&result'!J3","v":"Beweegvriendelijkheid"},{"$f":"'form&result'!K3*'form&result'!I3","v":1},{"$f":"_xlfn.RANK.EQ(C3,$C$3:$C$18,0)","v":12},1E-4,{"$f":"LARGE(A3:A18,1)","v":13.0015},{"$f":"'form&result'!I3","v":true}]
[1.0002,{"$f":"'form&result'!J4","v":"Bodemkwaliteit"},{"$f":"'form&result'!K4*'form&result'!I4","v":5},{"$f":"_xlfn.RANK.EQ(C4,$C$3:$C$18,0)","v":1},2.0000000000000001E-4,{"$f":"LARGE(A3:A18, 2)","v":13.0014},{"$f":"'form&result'!I4","v":true}]
[1.0003,{"$f":"'form&result'!J5","v":"Groen"},{"$f":"'form&result'!K5*'form&result'!I5","v":5},{"$f":"_xlfn.RANK.EQ(C5,$C$3:$C$18,0)","v":1},2.9999999999999997E-4,{"$f":"LARGE(A3:A18,3)","v":13.001300000000001},{"$f":"'form&result'!I5","v":true}]
[3.0004,{"$f":"'form&result'!J6","v":"Hitte"},{"$f":"'form&result'!K6*'form&result'!I6","v":4},3,4.0000000000000002E-4,{"$f":"LARGE(A3:A18, 4)","v":12.0001},{"$f":"'form&result'!I6","v":true}]
[3.0005000000000002,{"$f":"'form&result'!J7","v":"Industrie"},{"$f":"'form&result'!K7*'form&result'!I7","v":4},3,5.0000000000000001E-4,{"$f":"LARGE(A3:A18,5)","v":9.0012000000000008},{"$f":"'form&result'!I7","v":true}]
[6.0006000000000004,{"$f":"'form&result'!J8","v":"Sociale Veiligheid"},{"$f":"'form&result'!K8*'form&result'!I8","v":3},6,5.9999999999999995E-4,{"$f":"LARGE(A3:A18, 6)","v":9.0010999999999992},{"$f":"'form&result'!I8","v":true}]
[6.0007000000000001,{"$f":"'form&result'!J9","v":"Veehouderij - Fijn Stof"},{"$f":"'form&result'!K9*'form&result'!I9","v":3},6,6.9999999999999999E-4,{"$f":"LARGE(A3:A18,7)","v":9.0009999999999994},{"$f":"'form&result'!I9","v":true}]
[6.0007999999999999,{"$f":"'form&result'!J10","v":"Veehouderij - Omgeving"},{"$f":"'form&result'!K10*'form&result'!I10","v":3},6,8.0000000000000004E-4,{"$f":"LARGE(A3:A18, 8)","v":6.0007999999999999},{"$f":"'form&result'!I10","v":true}]
[3.0009000000000001,{"$f":"'form&result'!J11","v":"Verkeer - NO2"},{"$f":"'form&result'!K11*'form&result'!I11","v":4},3,8.9999999999999998E-4,{"$f":"LARGE(A3:A18,9)","v":6.0007000000000001},{"$f":"'form&result'!I11","v":true}]
[9.0009999999999994,{"$f":"'form&result'!J12","v":"Verkeer - Geluid"},{"$f":"'form&result'!K12*'form&result'!I12","v":2},9,1E-3,{"$f":"LARGE(A3:A18,10)","v":6.0006000000000004},{"$f":"'form&result'!I12","v":true}]
[9.0010999999999992,{"$f":"'form&result'!J13","v":"Verkeersveiligheid"},{"$f":"'form&result'!K13*'form&result'!I13","v":2},9,1.1000000000000001E-3,{"$f":"LARGE(A3:A18,11)","v":3.0009000000000001},{"$f":"'form&result'!I13","v":true}]
[9.0012000000000008,{"$f":"'form&result'!J14","v":"Voorzieningen"},{"$f":"'form&result'!K14*'form&result'!I14","v":2},9,1.1999999999999999E-3,{"$f":"LARGE(A3:A18, 12)","v":3.0005000000000002},{"$f":"'form&result'!I14","v":true}]
[13.001300000000001,{"$f":"'form&result'!J15","v":"..."},{"$f":"'form&result'!K15*'form&result'!I15","v":0},13,1.2999999999999999E-3,{"$f":"LARGE(A3:A18,13)","v":3.0004},{"$f":"'form&result'!I15","v":false}]
[13.0014,{"$f":"'form&result'!J16","v":"…"},{"$f":"'form&result'!K16*'form&result'!I16","v":0},13,1.4E-3,{"$f":"LARGE(A3:A18, 14)","v":1.0003},{"$f":"'form&result'!I16","v":false}]
[13.0015,{"$f":"'form&result'!J17","v":"…"},{"$f":"'form&result'!K17*'form&result'!I17","v":0},13,1.5E-3,{"$f":"LARGE(A3:A18,15)","v":1.0002},{"$f":"'form&result'!I17","v":false}]
[]
[]
[null,"daar hoort bij"]
["gesorteerde rang","variabele","score",null,"kleur 5","kleur 4","kleur 3","kleur 2","kleur 1"]
[{"$f":"'te verbergen'!F3","v":13.0015},{"$f":"IF((VLOOKUP(A22,$A$2:$G$18,7,FALSE))=TRUE,(VLOOKUP(A22,$A$2:$G$18,2,FALSE)),$A$1)","v":" "},{"$f":"VLOOKUP(A22,$A$2:$G$18,3,FALSE)","v":0},null,{"$f":"IF(C22=5,C22,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C22=4,C22,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C22=3,C22,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C22=2,C22,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C22=1,C22,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F4","v":13.0014},{"$f":"IF((VLOOKUP(A23,$A$2:$G$18,7,FALSE))=TRUE,(VLOOKUP(A23,$A$2:$G$18,2,FALSE)),$A$1)","v":" "},{"$f":"VLOOKUP(A23,$A$2:$G$18,3,FALSE)","v":0},null,{"$f":"IF(C23=5,C23,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C23=4,C23,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C23=3,C23,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C23=2,C23,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C23=1,C23,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F5","v":13.001300000000001},{"$f":"IF((VLOOKUP(A24,$A$2:$G$18,7,FALSE))=TRUE,(VLOOKUP(A24,$A$2:$G$18,2,FALSE)),$A$1)","v":" "},{"$f":"VLOOKUP(A24,$A$2:$G$15,3,FALSE)","v":0},null,{"$f":"IF(C24=5,C24,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C24=4,C24,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C24=3,C24,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C24=2,C24,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C24=1,C24,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F6","v":12.0001},{"$f":"IF((VLOOKUP(A25,$A$2:$G$18,7,FALSE))=TRUE,(VLOOKUP(A25,$A$2:$G$18,2,FALSE)),$A$1)","v":"Beweegvriendelijkheid"},{"$f":"VLOOKUP(A25,$A$2:$G$18,3,FALSE)","v":1},null,{"$f":"IF(C25=5,C25,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C25=4,C25,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C25=3,C25,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C25=2,C25,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C25=1,C25,_xludf.NA())","v":1}]
[{"$f":"'te verbergen'!F7","v":9.0012000000000008},"Voorzieningen",2,null,{"$f":"IF(C26=5,C26,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C26=4,C26,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C26=3,C26,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C26=2,C26,_xludf.NA())","v":2},{"$f":"IF(C26=1,C26,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F8","v":9.0010999999999992},"Verkeersveiligheid",{"$f":"VLOOKUP(A27,$A$2:$G$15,3,FALSE)","v":2},null,{"$f":"IF(C27=5,C27,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C27=4,C27,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C27=3,C27,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C27=2,C27,_xludf.NA())","v":2},{"$f":"IF(C27=1,C27,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F9","v":9.0009999999999994},"Verkeer - Geluid",{"$f":"VLOOKUP(A28,$A$2:$G$18,3,FALSE)","v":2},null,{"$f":"IF(C28=5,C28,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C28=4,C28,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C28=3,C28,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C28=2,C28,_xludf.NA())","v":2},{"$f":"IF(C28=1,C28,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F10","v":6.0007999999999999},"Veehouderij - Omgeving",3,null,{"$f":"IF(C29=5,C29,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C29=4,C29,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C29=3,C29,_xludf.NA())","v":3},{"$f":"IF(C29=2,C29,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C29=1,C29,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F11","v":6.0007000000000001},"Veehouderij - Fijn Stof",{"$f":"VLOOKUP(A30,$A$2:$G$18,3,FALSE)","v":3},null,{"$f":"IF(C30=5,C30,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C30=4,C30,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C30=3,C30,_xludf.NA())","v":3},{"$f":"IF(C30=2,C30,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C30=1,C30,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F12","v":6.0006000000000004},"Sociale Veiligheid",{"$f":"VLOOKUP(A31,$A$2:$G$18,3,FALSE)","v":3},null,{"$f":"IF(C31=5,C31,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C31=4,C31,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C31=3,C31,_xludf.NA())","v":3},{"$f":"IF(C31=2,C31,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C31=1,C31,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F13","v":3.0009000000000001},"Verkeer - NO2",4,null,{"$f":"IF(C32=5,C32,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C32=4,C32,_xludf.NA())","v":4},{"$f":"IF(C32=3,C32,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C32=2,C32,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C32=1,C32,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F14","v":3.0005000000000002},"Industrie",{"$f":"VLOOKUP(A33,$A$2:$G$15,3,FALSE)","v":4},null,{"$f":"IF(C33=5,C33,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C33=4,C33,_xludf.NA())","v":4},{"$f":"IF(C33=3,C33,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C33=2,C33,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C33=1,C33,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F15","v":3.0004},"Hitte",{"$f":"VLOOKUP(A34,$A$2:$G$18,3,FALSE)","v":4},null,{"$f":"IF(C34=5,C34,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C34=4,C34,_xludf.NA())","v":4},{"$f":"IF(C34=3,C34,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C34=2,C34,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C34=1,C34,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F16","v":1.0003},"Groen",5,null,{"$f":"IF(C35=5,C35,_xludf.NA())","v":5},{"$f":"IF(C35=4,C35,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C35=3,C35,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C35=2,C35,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C35=1,C35,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F17","v":1.0002},"Bodemkwaliteit",{"$f":"VLOOKUP(A36,$A$2:$G$15,3,FALSE)","v":5},null,{"$f":"IF(C36=5,C36,_xludf.NA())","v":5},{"$f":"IF(C36=4,C36,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C36=3,C36,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C36=2,C36,_xludf.NA())","v":{"$error":"#NAME?"}},{"$f":"IF(C36=1,C36,_xludf.NA())","v":{"$error":"#NAME?"}}]
[{"$f":"'te verbergen'!F18","v":0},{"$error":"#N/A"},{"$f":"VLOOKUP(A37,$A$2:$G$18,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(C37=5,C37,_xludf.NA())","v":{"$error":"#N/A"}},{"$f":"IF(C37=4,C37,_xludf.NA())","v":{"$error":"#N/A"}},{"$f":"IF(C37=3,C37,_xludf.NA())","v":{"$error":"#N/A"}},{"$f":"IF(C37=2,C37,_xludf.NA())","v":{"$error":"#N/A"}},{"$f":"IF(C37=1,C37,_xludf.NA())","v":{"$error":"#N/A"}}]