{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["keuze","Flex","Perfo"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"keuze","index":0,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,8,1,12],[25,4,29,17],[6,8,6,12],[7,8,7,12],[8,8,8,12],[9,8,9,12]]}
[]
[null,null,null,null,null,null,null,null,"Kies hier de achtergrondconstructie!"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF($A$47>$A$48,A49,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($A$47>$A$48,A50,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($A$47>$A$48,A51,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($A$47>$A$48,A52,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Hoewel aan dit rekenprogramma uiteraard de grootste zorg is besteed, \nbestaat er een mogelijkheid dat een fout over het hoofd is gezien.\nGebr. Bodegraven BV wijst hiervoor elke aansprakelijkheid van de hand.\nWij stellen het echter zeer op prijs als u eventuele onvolkomenheden aan ons mailt."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2016-09-01"]
[{"$f":"CONCATENATE(DAY(TODAY())&\"-\",MONTH(TODAY())&\"-\",YEAR(NOW()))","v":"13-9-2016"}]
[{"$f":"A46-A45","v":12}]
[400]
["Let op, dit is rekenhulp V1.00"]
["kijk regelmatig op"]
["http:www.gb.nl/rekenhulp"]
["of een nieuwe versie beschikkbaar is."]

{"sheet":"Flex","index":1,"n_rows":89,"n_cols":51,"rows_kept":89,"cut":false,"hidden":false,"merged":[[11,9,11,10],[2,4,2,7],[3,8,3,11],[0,0,0,26],[2,0,2,3],[2,8,2,11],[7,9,8,9],[7,10,8,10],[72,30,72,34],[72,24,72,28],[2,18,2,21],[2,12,2,14],[2,15,2,17],[3,15,3,17],[12,20,12,25],[12,12,14,14],[3,12,3,14]]}
["Rekenhulp voor Kalkzandsteen, Beton of Baksteen."]
[]
["Isolatiedikte",null,null,null,"Luchtspouw",null,null,null,"Inlegdiepte",null,null,null,"Buitenblad",null,null,"Spouwanker",null,null,"Advies"]
["Artikel:",{"$f":"VLOOKUP(B8,A54:D63,4)","v":"330100.0250"},null,null,null,null,null,null,"buitenblad",null,null,null,null,null,null," -lengte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flexplug:",{"$f":"$B$4","v":"330100.0250"},null,{"$f":"$B$6","v":"UNI-Flexplug 100 iso 40-60  NY"}]
[null,{"$f":"VLOOKUP(B8,A54:E63,5)","v":"UNI-Flexplug 100 iso 40-60  NY"}]
[null,null,null,null,null,null,null,null,null,"min","max",null,null,null,null,null,null,null,null,"Inslaghulp:",{"$f":"VLOOKUP(B8,A54:G63,7)","v":"390000.0001"},null,{"$f":"VLOOKUP(B8,A54:H63,8)","v":"Inslaghulpstuk tbv plug 45  EV"}]
[null,1,{"$f":"VLOOKUP(B8,A54:D63,2)","v":100},null,null,1,{"$f":"VLOOKUP($F$8,H70:I89,2)","v":20},null,null,45,75]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z48=0,\" \",CONCATENATE(AB48,\" buitenblad toepassing!\"))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z48=0,\" \",\"Anker:\")","v":" "},{"$f":"IF($Z$48=0,\"\",IF($Z$48=1,Y72,AE72))","v":""},null,{"$f":"IF($Z$48=0,\"\",IF($Z$48=1,AA72,AG72))","v":""}]
[null,null,{"$f":"VLOOKUP(B8,A54:D63,2)","v":100},null,null,null,{"$f":"VLOOKUP($F$8,H70:I89,2)","v":20},null,null,{"$f":"CONCATENATE(J8,\" - \",K8)","v":"45 - 75"},null,null,null,null,null,{"$f":"C12+G12+J8","v":165},"-",{"$f":"C12+G12+K8","v":195},null,{"$f":"IF($Z$48=0,\"\",\"Hulpstuk:\")","v":""},{"$f":"IF(U13=\"Voor deze maat is geen anker beschikbaar!\",\"\",IF(Z48=0,\"\",(IF(Z48=2,\"39012.0001\",IF(AK60=1,AK63,\"\")))))","v":""},null,{"$f":"IF(U13=\"Voor deze maat is geen anker beschikbaar!\",\"\",IF(Z48=0,\"\",IF(Z48=2,\"Indraaihulpstuk EV\",AM63)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z48=0,\"kies hier voor een gemetselde of een gelijmde buitengevel!\",\"\")","v":"kies hier voor een gemetselde of een gelijmde buitengevel!"},null,null,null,null,null,null,null,{"$f":"IF($Z$48=0,\"Kies eerst gemetselde of gelijmde buitengevel bij buitenblad!\",IF($Z$48=1,Y73,AE73))","v":"Kies eerst gemetselde of gelijmde buitengevel bij buitenblad!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z48=0,\" \",IF(X67=2,\"Anker:\",\"\"))","v":" "},{"$f":"IF($Z$48=0,\"\",IF($Z$48=1,Y74,AE74))","v":""},null,{"$f":"IF($Z$48=0,\"\",IF(Z48=1,AA74,AG74))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z48=0,\" \",IF(X67=2,\"Hulpstuk:\",\"\"))","v":" "},{"$f":"IF(U13=\"Voor deze maat is geen anker beschikbaar!\",\"\",IF(X67=1,\"\",IF(Z48=0,\"\",(IF(Z48=2,\"39012.0001\",IF(Z48=0,\"\",IF(AS60=1,AS63,\"\")))))))","v":""},null,{"$f":"IF(U13=\"Voor deze maat is geen anker beschikbaar!\",\"\",IF(Z48=0,\"\",(IF(Z48=2,\"Indraaihulpstuk EV\",IF(Z48=0,\"\",IF(AS60=1,AU63,\"\"))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X67","v":1},null,null,"Radiobutton Buitenblad:",null,0,null,{"$f":"IF(Z48=1,Y51,AF51)","v":"Gelijmde"}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO72","v":90},{"$f":"AO74","v":{"$error":"#VALUE!"}}]
[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,null,null,null,null,null,null,null,null,null,null,"bepalen maat van slagpijp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Gemetselde",null,null,null,null,null,2,"Gelijmde",null,null,null,null,"voor gemetselde UNI-Slagspouwanker"]
[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,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,"afm.",null,null,2]
[null,"Isolatielaag",null,null,null,null,"Inslaghulp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X53=TRUE,1,0)","v":0},{"$f":"AND(AC53>=$P$12,AC53<=$R$12)","v":false},"37461.0250","UNI-slagspouwanker 160x4   316",null,null,160,{"$f":"IF(AE53=TRUE,1,0)","v":0},{"$f":"AND(AH53>=$P$12,AH53<=$R$12)","v":false},"38103.0250","UNI-Lijmboorsp.anker 160x4 316",160,null,null,{"$f":"AND($AQ53<=$AO$72,$AQ54>=$AO$72,AK54=FALSE)","v":true},"390075.0001","Slagpijp binnenmaat 75      GP","binnenmaat 75 mm","t.b.v. UNI-Slagspouwanker",null,80,null,{"$f":"AND($AQ53<=$AO$74,$AQ54>=$AO$74,AS54=FALSE)","v":{"$error":"#VALUE!"}},"390075.0001","Slagpijp binnenmaat 75      GP","binnenmaat 75 mm","t.b.v. UNI-Slagspouwanker",null,80]
[1,100,"41-60","330100.0250","UNI-Flexplug 100 iso 40-60  NY",null,"390000.0001","Inslaghulpstuk tbv plug 45  EV","t.b.v. art.nr. 330100",null,null,null,null,null,null,null,null,"let op; ceel W15 ; witte tekst om bij AE66 < 2",null,null,null,null,{"$f":"IF(X54=TRUE,W53+1,0)","v":1},true,"37462.0250","UNI-slagspouwanker 190x4   316",null,null,190,{"$f":"IF(AE54=TRUE,AD53+1,0)","v":1},true,"38105.0250","UNI-Lijmboorsp.anker 190x4 316",190,null,null,{"$f":"AND($AQ54<=$AO$72,$AQ55>=$AO$72,AK55=FALSE)","v":false},"390110.0001","Slagpijp binnenmaat 110     GP","binnenmaat 110 mm","t.b.v. UNI-Slagspouwanker",null,115,null,{"$f":"AND($AQ54<=$AO$74,$AQ55>=$AO$74,AS55=FALSE)","v":{"$error":"#VALUE!"}},"390110.0001","Slagpijp binnenmaat 110     GP","binnenmaat 110 mm","t.b.v. UNI-Slagspouwanker",null,115]
[2,120,"61-80","330120.0250","UNI-Flexplug 120 iso 60-80  NY",null,"392080.0001","Inslaghulpstuk rood      KS/VD","t.b.v. art.nr. 330120 en 331140",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X55=TRUE,W54+1,0)","v":0},false,"37463.0250","UNI-slagspouwanker 220x4   316",null,null,220,{"$f":"IF(AE55=TRUE,AD54+1,0)","v":0},false,"38107.0250","UNI-Lijmboorsp.anker 220x4 316",220,null,null,{"$f":"AND($AQ55<=$AO$72,$AQ56>=$AO$72,AK56=FALSE)","v":false},"390200.0001","Slagpijp binnenmaat 200     GP","binnenmaat 200 mm","t.b.v. UNI-Slagspouwanker",null,205,null,{"$f":"AND($AQ55<=$AO$74,$AQ56>=$AO$74,AS56=FALSE)","v":{"$error":"#VALUE!"}},"390200.0001","Slagpijp binnenmaat 200     GP","binnenmaat 200 mm","t.b.v. UNI-Slagspouwanker",null,205]
[3,140,"81-100","330140.0250","UNI-Flexplug 140 iso 80-100 NY",null,"392100.0001","Inslaghulpstuk blauw     KS/VD","t.b.v. art.nr. 330140 en 331160",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37464.0250","UNI-slagspouwanker 250x4   316",null,null,250,0,false,"38109.0250","UNI-Lijmboorsp.anker 250x4 316",250,null,null,{"$f":"AND($AQ56<=$AO$72,$AQ57>=$AO$72,AK57=FALSE)","v":false},"390275.0001","Slagpijp binnenmaat 275     GP","binnenmaat 275 mm","t.b.v. UNI-Slagspouwanker",null,280,null,{"$f":"AND($AQ56<=$AO$74,$AQ57>=$AO$74,AS57=FALSE)","v":{"$error":"#VALUE!"}},"390275.0001","Slagpijp binnenmaat 275     GP","binnenmaat 275 mm","t.b.v. UNI-Slagspouwanker",null,280]
[4,160,"101-120","330160.0250","UNI-Flexplug 160 iso100-120 NY",null,"392120.0001","Inslaghulpstuk groen     KS/VD","t.b.v. art.nr. 330160 en 331180",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37467.0250","UNI-slagspouwanker 275x4   316",null,null,275,0,false,"38110.0250","UNI-Lijmboorsp.anker 275x4 316",275,null,null,{"$f":"AND($AQ57<=$AO$72)","v":false},"39018.0001","Slagpijp binnenmaat 350 mm  GP","binnenmaat 350 mm","t.b.v. UNI-Slagspouwanker",null,355,null,{"$f":"AND($AQ57<=$AO$74)","v":{"$error":"#VALUE!"}},"39018.0001","Slagpijp binnenmaat 350 mm  GP","binnenmaat 350 mm","t.b.v. UNI-Slagspouwanker",null,355]
[5,180,"121-140","330180.0250","UNI-Flexplug 180 iso120-140 NY",null,"392140.0001","Inslaghulpstuk transparant  VD","t.b.v. art.nr. 330180",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37465.0250","UNI-slagspouwanker 300x4   316",null,null,300,0,false,"38111.0250","UNI-Lijmboorsp.anker 300x4 316",300]
[6,200,"141-160","330200.0250","UNI-Flexplug 200 iso140-160 NY",null,"392160.0001","Inslaghulpstuk grijs     KS/VD","t.b.v. art.nr. 330200",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374653.0250","UNI-slagspouwanker 325x4   316",null,null,325,0,false,"38112.0250","UNI-Lijmboorsp.anker 325x4 316",325]
[7,220,"161-180","330220.0250","UNI-Flexplug 220 iso160-180 NY",null,"392180.0001","Inslaghulpstuk zwart     KS/VD","t.b.v. art.nr. 330220",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374655.0250","UNI-slagspouwanker 350x4   316",null,null,350,0,false,"38113.0250","UNI-Lijmboorsp.anker 350x4 316",350,null,null,{"$f":"COUNTIFS(AK53:AK58,TRUE)","v":1},null,null,null,null,null,null,null,{"$f":"COUNTIFS(AS53:AS58,TRUE)","v":0}]
[8,240,"181-200","330240.0250","UNI-Flexplug 240 iso180-200 NY",null,"392200.0001","Inslaghulpstuk bruin     KS/VD","t.b.v. art.nr. 330240",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374657.0250","UNI-slagspouwanker 375x4   316",null,null,375,0,false,"38114.0250","UNI-Lijmboorsp.anker 375x4 316",375]
[9,260,"201-220","330260.0250","UNI-Flexplug 260 iso200-220 NY",null,"392220.0001","Inslaghulpstuk zilver    KS/VD","t.b.v. art.nr. 330260 | 330280",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37466.0250","UNI-slagspouwanker 400x4   316",null,null,400,0,false,"38115.0250","UNI-Lijmboorsp.anker 400x4 316",400]
[10,280,"221-240","330280.0250","UNI-Flexplug 280 iso220-240 NY",null,"392220.0001","Inslaghulpstuk zilver    KS/VD","t.b.v. art.nr. 330260 | 330280",null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374663.0250","UNI-slagspouwanker 425x4   316",null,null,425,null,null,null,null,null,null,null,{"$f":"VLOOKUP(TRUE,$AK53:$AQ57,2,FALSE)","v":"390075.0001"},null,{"$f":"VLOOKUP(TRUE,$AK53:$AQ57,3,FALSE)","v":"Slagpijp binnenmaat 75      GP"},null,null,null,null,null,{"$f":"VLOOKUP(TRUE,$AS$53:$AY$57,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(TRUE,$AS$53:$AY$57,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374665.0250","UNI-slagspouwanker 450x4   316",null,null,450]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374667.0250","UNI-slagspouwanker 475x4   316",null,null,475]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(X53:X65,TRUE)","v":1},null,null,null,null,null,null,{"$f":"COUNTIFS(AE53:AE65,TRUE)","v":1}]
[null,null,null,null,null,null,null,null,"luchtspouw"]
[]
[null,null,null,null,null,null,null,null,10,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,null,"Benodigde lengte Slagpijp is lengte slagspouwanker minus Isolatiedikte, naar beneden afgerond."]
[null,null,null,null,null,null,null,1,20]
[null,null,null,null,null,null,null,2,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slagspouwanker:",{"$f":"IF(W53=1,Y53,IF(W54=1,Y54,IF(W55=1,Y55,IF(W56=1,Y56,IF(W57=1,Y57,IF(W58=1,Y58,IF(W59=1,Y59,IF(W60=1,Y60,IF(W61=1,Y61,IF(W62=1,Y62,IF(W63=1,Y63,IF(W64=1,Y64,IF(W65=1,Y65,\"-\")))))))))))))","v":"37462.0250"},null,{"$f":"IF(W53=1,Z53,IF(W54=1,Z54,IF(W55=1,Z55,IF(W56=1,Z56,IF(W57=1,Z57,IF(W58=1,Z58,IF(W59=1,Z59,IF(W60=1,Z60,IF(W61=1,Z61,IF(W62=1,Z62,IF(W63=1,Z63,IF(W64=1,Z64,IF(W65=1,Z65,\" \")))))))))))))","v":"UNI-slagspouwanker 190x4   316"},null,{"$f":"IF(W53=1,AC53,IF(W54=1,AC54,IF(W55=1,AC55,IF(W56=1,AC56,IF(W57=1,AC57,IF(W58=1,AC58,IF(W59=1,AC59,IF(W60=1,AC60,IF(W61=1,AC61,IF(W62=1,AC62,IF(W63=1,AC63,IF(W64=1,AC64,IF(W65=1,AC65,\" \")))))))))))))","v":190},null,{"$f":"IF(AD53=1,AF53,IF(AD54=1,AF54,IF(AD55=1,AF55,IF(AD56=1,AF56,IF(AD57=1,AF57,IF(AD58=1,AF58,IF(AD59=1,AF59,IF(AD60=1,AF60,IF(AD61=1,AF61,IF(AD62=1,AF62,\"-\"))))))))))","v":"38105.0250"},null,{"$f":"IF(AD53=1,AG53,IF(AD54=1,AG54,IF(AD55=1,AG55,IF(AD56=1,AG56,IF(AD57=1,AG57,IF(AD58=1,AG58,IF(AD59=1,AG59,IF(AD60=1,AG60,IF(AD61=1,AG61,IF(AD62=1,AG62,\" \"))))))))))","v":"UNI-Lijmboorsp.anker 190x4 316"},null,null,null,{"$f":"AC72","v":190}," - ",{"$f":"$C$12","v":100}," =",{"$f":"AK72-AM72","v":90}]
[null,null,null,null,null,null,null,3,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X67=2,\"of\",IF(Y72=\"-\",\"Voor deze maat is geen anker beschikbaar!\",\" \"))","v":" "},null,null,null,null,null,{"$f":"IF(AE67=2,\"of\",IF(AE72=\"-\",\"Voor deze maat is geen anker beschikbaar!\",\" \"))","v":" "}]
[null,null,null,null,null,null,null,4,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X67","v":1},{"$f":"IF(W53=2,Y53,IF(W54=2,Y54,IF(W55=2,Y55,IF(W56=2,Y56,IF(W57=2,Y57,IF(W58=2,Y58,IF(W59=2,Y59,IF(W60=2,Y60,IF(W61=2,Y61,IF(W62=2,Y62,IF(W63=2,Y63,IF(W64=2,Y64,IF(W65=2,Y65,\" \")))))))))))))","v":" "},null,{"$f":"IF(W53=2,Z53,IF(W54=2,Z54,IF(W55=2,Z55,IF(W56=2,Z56,IF(W57=2,Z57,IF(W58=2,Z58,IF(W59=2,Z59,IF(W60=2,Z60,IF(W61=2,Z61,IF(W62=2,Z62,IF(W63=2,Z63,IF(W64=2,Z64,IF(W65=2,Z65,\" \")))))))))))))","v":" "},null,{"$f":"IF(W53=2,AC53,IF(W54=2,AC54,IF(W55=2,AC55,IF(W56=2,AC56,IF(W57=2,AC57,IF(W58=2,AC58,IF(W59=2,AC59,IF(W60=2,AC60,IF(W61=2,AC61,IF(W62=2,AC62,IF(W63=2,AC63,IF(W64=2,AC64,IF(W65=2,AC65,\" \")))))))))))))","v":" "},null,{"$f":"IF(AD53=2,AF53,IF(AD54=2,AF54,IF(AD55=2,AF55,IF(AD56=2,AF56,IF(AD57=2,AF57,IF(AD58=2,AF58,IF(AD59=2,AF59,IF(AD60=2,AF60,IF(AD61=2,AF61,IF(AD62=2,AF62,\" \"))))))))))","v":" "},null,{"$f":"IF(AD53=2,AG53,IF(AD54=2,AD54,IF(AD55=2,AG55,IF(AD56=2,AG56,IF(AD57=2,AG57,IF(AD58=2,AG58,IF(AD59=2,AG59,IF(AD60=2,AG60,IF(AD61=2,AG61,IF(AD62=2,AG62,\" \"))))))))))","v":" "},null,null,null,{"$f":"AC74","v":" "}," - ",{"$f":"$C$12","v":100}," =",{"$f":"AK74-AM74","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,5,60]
[null,null,null,null,null,null,null,6,70]
[null,null,null,null,null,null,null,7,80]
[null,null,null,null,null,null,null,8,90]
[null,null,null,null,null,null,null,9,100]
[null,null,null,null,null,null,null,10,110]
[null,null,null,null,null,null,null,11,120]
[null,null,null,null,null,null,null,12,130]
[null,null,null,null,null,null,null,13,140]
[null,null,null,null,null,null,null,14,150]
[null,null,null,null,null,null,null,15,160]
[null,null,null,null,null,null,null,16,170]
[null,null,null,null,null,null,null,17,180]
[null,null,null,null,null,null,null,18,190]
[null,null,null,null,null,null,null,19,200]

{"sheet":"Perfo","index":2,"n_rows":91,"n_cols":33,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,0,0,26],[74,30,74,34],[2,0,2,3],[2,4,2,7],[2,8,2,11],[11,9,11,10],[2,15,2,17],[74,24,74,28],[2,18,2,21],[2,12,2,14],[12,12,14,14],[11,20,11,26],[7,9,8,9],[7,10,8,10],[3,8,3,11]]}
["Rekenhulp voor Keramische holle steen."]
[]
["Isolatiedikte",null,null,null,"Luchtspouw",null,null,null,"Inlegdiepte",null,null,null,"Buitenblad",null,null,"Spouwanker",null,null,"Advies"]
["Artikel:",{"$f":"VLOOKUP(B8,A56:D65,4)","v":"331140.0250"},null,null,null,null,null,null,"buitenblad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perfoplug:",{"$f":"$B$4","v":"331140.0250"},null,{"$f":"$B$6","v":"UNI-Perfoplug 140 iso60-80  NY"}]
[null,{"$f":"VLOOKUP(B8,A56:E65,5)","v":"UNI-Perfoplug 140 iso60-80  NY"}]
[null,null,null,null,null,null,null,null,null,"min","max",null,null,null,null,null,null,null,null,"Inslaghulp:",{"$f":"VLOOKUP(C8,A56:G60,7)","v":"392220.0001"},null,{"$f":"VLOOKUP(C8,A56:H60,8)","v":"Inslaghulpstuk zilver    KS/VD"}]
[null,1,{"$f":"VLOOKUP(B8,A56:D60,2)","v":140},null,null,1,{"$f":"VLOOKUP($F$8,H72:I91,2)","v":20},null,null,45,75]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z50=0,\" \",CONCATENATE(AB50,\" buitenblad toepassing!\"))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z50=0,\" \",\"Anker:\")","v":" "},{"$f":"IF($Z$50=0,\"\",IF($Z$50=1,Y74,AE74))","v":""},null,{"$f":"IF($Z$50=0,\"\",IF($Z$50=1,AA74,AG74))","v":""},null,null,""]
[null,null,{"$f":"C8","v":140},null,null,null,{"$f":"VLOOKUP($F$8,H72:I91,2)","v":20},null,null,{"$f":"CONCATENATE(J8,\" - \",K8)","v":"45 - 75"},null,null,null,null,null,{"$f":"C12+G12+J8","v":205},"-",{"$f":"C12+G12+K8","v":235},null,null,{"$f":"IF($Z$50=0,\"Kies eerst gemetselde of gelijmde buitengevel bij buitenblad!\",IF($Z$50=1,Y75,AE75))","v":"Kies eerst gemetselde of gelijmde buitengevel bij buitenblad!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z50=0,\"kies hier voor een gemetselde of een gelijmde buitengevel!\",\"\")","v":"kies hier voor een gemetselde of een gelijmde buitengevel!"},null,null,null,null,null,null,null,{"$f":"IF($Z$50=0,\"\",IF($Z$50=1,Y76,AE76))","v":""},null,{"$f":"IF($Z$50=0,\"\",IF(Z50=1,AA76,AG76))","v":""},null,null,""," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z50=0,\"\",\"Hulpstuk:\")","v":""},{"$f":"IF($Z$50=0,\" \",IF($Z$50=1,\"39010.0001\",\"39012.0001\"))","v":" "},null,{"$f":"IF($Z$50=0,\" \",IF($Z$50=1,\"Indraaihulpstuk GP\",\"Indraaihulpstuk EV\"))","v":" "},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,"Radiobutton Buitenblad:",null,0,null,{"$f":"IF(Z50=1,Y53,AD53)","v":"Gelijmde"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Gemetselde",null,null,null,2,"Gelijmde"]
[]
[null,"Isolatielaag",null,null,null,null,"Inslaghulp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y55=TRUE,1,0)","v":0},{"$f":"AND(AC$55>=$P$12,AC$55<=$R$12)","v":false},"37435.0250","UNI-boorspouwanker 160x4   316",null,160,{"$f":"IF(AE55=TRUE,1,0)","v":0},{"$f":"AND($AC55>=$P$12,$AC55<=$R$12)","v":false},"38103.0250","UNI-Lijmboorsp.anker 160x4 316"]
[1,140,"61-80","331140.0250","UNI-Perfoplug 140 iso60-80  NY",null,"392080.0001","Inslaghulpstuk rood      KS/VD","t.b.v. art.nr. 330120 en 331140",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y56=TRUE,X55+1,0)","v":0},{"$f":"AND(AC56>=$P$12,AC56<=$R$12)","v":false},"37436.0250","UNI-boorspouwanker 190x4   316",null,190,{"$f":"IF(AE56=TRUE,AD55+1,0)","v":0},false,"38105.0250","UNI-Lijmboorsp.anker 190x4 316"]
[2,160,"81-100","331160.0250","UNI-Perfoplug 160 iso80-100 NY",null,"392100.0001","Inslaghulpstuk blauw     KS/VD","t.b.v. art.nr. 330140 en 331160",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y57=TRUE,X56+1,0)","v":1},true,"37437.0250","UNI-boorspouwanker 220x4   316",null,220,{"$f":"IF(AE57=TRUE,AD56+1,0)","v":1},true,"38107.0250","UNI-Lijmboorsp.anker 220x4 316"]
[3,180,"101-120","331180.0250","UNI-Perfoplug 180 iso100-120NY",null,"392180.0001","Inslaghulpstuk zwart     KS/VD","t.b.v. art.nr. 330220",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37438.0250","UNI-boorspouwanker 250x4   316",null,250,0,false,"38109.0250","UNI-Lijmboorsp.anker 250x4 316"]
[4,200,"121-140","331200.0250","UNI-Perfoplug 200 iso120-140NY",null,"392220.0001","Inslaghulpstuk zilver    KS/VD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374385.0250","UNI-boorspouwanker 275x4   316",null,275,0,false,"38110.0250","UNI-Lijmboorsp.anker 275x4 316"]
[5,220,"141-160","331220.0250","UNI-Perfoplug 220 iso140-160NY",null,"392220.0001","Inslaghulpstuk zilver    KS/VD","t.b.v. art.nr. 330260 | 330280",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37439.0250","UNI-boorspouwanker 300x4   316",null,300,0,false,"38111.0250","UNI-Lijmboorsp.anker 300x4 316"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374393.0250","UNI-boorspouwanker 325x4   316",null,325,0,false,"38112.0250","UNI-Lijmboorsp.anker 325x4 316"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374395.0250","UNI-boorspouwanker 350x4   316",null,350,0,false,"38113.0250","UNI-Lijmboorsp.anker 350x4 316"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"374397.0250","UNI-boorspouwanker 375x4   316",null,375,0,false,"38114.0250","UNI-Lijmboorsp.anker 375x4 316"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,"37440.0250","UNI-boorspouwanker 400x4   316",null,400,0,false,"38115.0250","UNI-Lijmboorsp.anker 400x4 316"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Y55:Y67,TRUE)","v":1},null,null,null,null,null,{"$f":"COUNTIFS(AE55:AE67,TRUE)","v":1}]
[null,null,null,null,null,null,null,null,"luchtspouw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zoek eerste \"WAAR\""]
[]
[null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,1,20]
[null,null,null,null,null,null,null,2,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boorspouwanker:",{"$f":"IF(X55=1,Z55,IF(X56=1,Z56,IF(X57=1,Z57,IF(X58=1,Z58,IF(X59=1,Z59,IF(X60=1,Z60,IF(X61=1,Z61,IF(X62=1,Z62,IF(X63=1,Z63,IF(X64=1,Z64,\"-\"))))))))))","v":"37437.0250"},null,{"$f":"IF(X55=1,AA55,IF(X56=1,AA56,IF(X57=1,AA57,IF(X58=1,AA58,IF(X59=1,AA59,IF(X60=1,AA60,IF(X61=1,AA61,IF(X62=1,AA62,IF(X63=1,AA63,IF(X64=1,AA64,\" \"))))))))))","v":"UNI-boorspouwanker 220x4   316"},null,null,null,{"$f":"IF(AD55=1,AF55,IF(AD56=1,AF56,IF(AD57=1,AF57,IF(AD58=1,AF58,IF(AD59=1,AF59,IF(AD60=1,AF60,IF(AD61=1,AF61,IF(AD62=1,AF62,IF(AD63=1,AF63,IF(AD64=1,AF64,\"-\"))))))))))","v":"38107.0250"},null,{"$f":"IF(AD55=1,AG55,IF(AD56=1,AG56,IF(AD57=1,AG57,IF(AD58=1,AG58,IF(AD59=1,AG59,IF(AD60=1,AG60,IF(AD61=1,AG61,IF(AD62=1,AG62,IF(AD63=1,AG63,IF(AD64=1,AG64,\" \"))))))))))","v":"UNI-Lijmboorsp.anker 220x4 316"}]
[null,null,null,null,null,null,null,3,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y69=2,\"of\",IF(Y74=\"-\",\"Voor deze maat is geen anker beschikbaar!\",\" \"))","v":" "},null,null,null,null,null,{"$f":"IF(AE69=2,\"of\",IF(AE74=\"-\",\"Voor deze maat is geen anker beschikbaar!\",\" \"))","v":" "}]
[null,null,null,null,null,null,null,4,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X55=2,Z55,IF(X56=2,Z56,IF(X57=2,Z57,IF(X58=2,Z58,IF(X59=2,Z59,IF(X60=2,Z60,IF(X61=2,Z61,IF(X62=2,Z62,IF(X63=2,Z63,IF(X64=2,Z64,\" \"))))))))))","v":" "},null,{"$f":"IF(X55=2,AA55,IF(X56=2,AA56,IF(X57=2,AA57,IF(X58=2,AA58,IF(X59=2,AA59,IF(X60=2,AA60,IF(X61=2,AA61,IF(X62=2,AA62,IF(X63=2,AA63,IF(X64=2,AA64,\" \"))))))))))","v":" "},null,null,null,{"$f":"IF(AD55=2,AF55,IF(AD56=2,AF56,IF(AD57=2,AF57,IF(AD58=2,AF58,IF(AD59=2,AF59,IF(AD60=2,AF60,IF(AD61=2,AF61,IF(AD62=2,AF62,IF(AD63=2,AF63,IF(AD64=2,AF64,\" \"))))))))))","v":" "},null,{"$f":"IF(AD55=2,AG55,IF(AD56=2,AG56,IF(AD57=2,AG57,IF(AD58=2,AG58,IF(AD59=2,AG59,IF(AD60=2,AG60,IF(AD61=2,AG61,IF(AD62=2,AG62,IF(AD63=2,AG63,IF(AD64=2,AG64,\" \"))))))))))","v":" "}]
[null,null,null,null,null,null,null,5,60]
[null,null,null,null,null,null,null,6,70]
[null,null,null,null,null,null,null,7,80]
[null,null,null,null,null,null,null,8,90]
[null,null,null,null,null,null,null,9,100]
[null,null,null,null,null,null,null,10,110]
[null,null,null,null,null,null,null,11,120]
[null,null,null,null,null,null,null,12,130]
[null,null,null,null,null,null,null,13,140]
[null,null,null,null,null,null,null,14,150]
[null,null,null,null,null,null,null,15,160]
[null,null,null,null,null,null,null,16,170]
[null,null,null,null,null,null,null,17,180]
[null,null,null,null,null,null,null,18,190]
[null,null,null,null,null,null,null,19,200]