{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Blad1","index":0,"n_rows":101,"n_cols":13,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,"KLANT"]
[]
[null,"BREEDTE VOORGEVEL","BREEDTE LINKERGEVEL","BREEDTE RECHTERGEVEL","BREEDTE ACHTERGEVEL"]
[]
["BREEDTE GEVEL",5]
["BREEDTE GEVEL IS MAX MAAT"]
["LENGTE STELLING",{"$f":"B59","v":6}]
["AFSTAND STELLING TOT GEVEL "]
["HOOGTE WERKPLATFORM",6]
["TRAPLUIK ELKE VERDIEPING"]
["UITBOUW"]
[]
[]
[]
[]
["VOETEN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BEREKENINGEN"]
[]
[]
[]
[null,"BREEDTE VOORGEVEL","BREEDTE LINKERGEVEL","BREEDTE RECHTERGEVEL","BREEDTE ACHTERGEVEL"]
[]
["BREEDTE GEVEL",{"$f":"B5","v":5},{"$f":"C5","v":0},0,0]
["GEVELBREEDTE IS MAX STELLINGLENGTE",{"$f":"B6","v":0}]
["LENGTE STELLING",{"$f":"--IF(B58=\"Ja\",M87,(B66*3))","v":6}]
["AFSTAND STELLING TOT GEVEL",{"$f":"B8","v":0}]
["HOOGTE WERKPLATFORM",6]
["TRAPLUIK ELKE VERDIEPING",0]
["UITBOUW",0]
[]
[]
["aantal verdelingen horizontaal",{"$f":"ROUNDUP(B57/3,0)","v":2}]
[]
["aantal verdiepingen",{"$f":"B61/3","v":2}]
["hoogte staanders",{"$f":"B61+1","v":7}]
["berekening hoogte staander 3m",{"$f":"(_xlfn.FLOOR.MATH(B69,3)/3)","v":2}]
["berekening hoogte staander 2m",{"$f":"--(IF(B69-(B70*3)>1,1))","v":0}]
["berekening hoogte staander 1m",{"$f":"--(IF(B69-(B70*3)<=1,1))","v":1}]
["aantal voeten",{"$f":"(B66+1)*2","v":6}]
["aantal staander 3m",{"$f":"B70*B73","v":12}]
["aantal staander 2m",{"$f":"B71*B73","v":0}]
["aantal staander 1m",{"$f":"B72*B73","v":6}]
["aantal ligger 3m opbouw stelling",{"$f":"--IF(B58=\"Ja\",((G87*2*B68)+(B68)+2),((B66*2*B68)+(B68)+2))","v":12}]
["aantal ligger 2,5m opbouw stelling"]
["aantal ligger 0,75m opbouw stelling"]
["leuning 3m"]
["leuning 2,5m"]
["leuning 0,75"]
["platform 3m voor opbouw stelling"]
["platform 2,5m voor opbouw stelling"]
["platform 0,75m voor opbouw stelling"]
[null,null,null,null,null,null,3,null,2.5,null,0.75,null,"Tot"]
[null,null,null,null,"max breedte voorgevel",{"$f":"B57","v":5},{"$f":"INT(F87/$G$86)","v":1},{"$f":"$G$86*G87","v":3},{"$f":"IF(H87<F87,INT((F87-H87)/$I$86),0)","v":0},{"$f":"H87+(I87*$I$86)","v":3},{"$f":"IF(J87<F87,INT((F87-J87)/$K$86),0)","v":2},null,{"$f":"J87+(K87*$K$86)","v":4.5}]
[null,null,null,null,null,13,{"$f":"INT(F88/$G$86)","v":4},{"$f":"$G$86*G88","v":12},{"$f":"IF(H88<F88,INT((F88-H88)/$I$86),0)","v":0},{"$f":"H88+(I88*$I$86)","v":12},{"$f":"IF(J88<F88,INT((F88-J88)/$K$86),0)","v":1},null,{"$f":"J88+(K88*$K$86)","v":12.75}]
[null,null,null,null,null,21,{"$f":"INT(F89/$G$86)","v":7},{"$f":"$G$86*G89","v":21},{"$f":"IF(H89<F89,INT((F89-H89)/$I$86),0)","v":0},{"$f":"H89+(I89*$I$86)","v":21},{"$f":"IF(J89<F89,INT((F89-J89)/$K$86),0)","v":0},null,{"$f":"J89+(K89*$K$86)","v":21}]
[null,null,null,null,null,16,{"$f":"INT(F90/$G$86)","v":5},{"$f":"$G$86*G90","v":15},{"$f":"IF(H90<F90,INT((F90-H90)/$I$86),0)","v":0},{"$f":"H90+(I90*$I$86)","v":15},{"$f":"IF(J90<F90,INT((F90-J90)/$K$86),0)","v":1},null,{"$f":"J90+(K90*$K$86)","v":15.75}]
[]
[]
[]
["uitbouw",{"$f":"--(IF(B11=\"Ja\",(B73/2)))","v":0}]
[]
[null,null,null,null,0.75,0]
[null,null,null,null,2.5,2]
[null,null,null,null,3,0]
[null,null,null,null,"Sum",{"$f":"SUMPRODUCT(E96:E98,F96:F98)","v":5}]
[null,null,null,null,"Target",5]
[null,null,null,null,null,{"$f":"(F100-F99)^2","v":0}]