{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"images":1,"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Blad1","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"merged":[[2,3,2,5],[3,3,3,5],[5,5,5,8],[6,5,6,7],[8,5,8,8],[8,9,8,10],[18,5,18,8],[19,5,19,7],[21,5,21,8],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3]]}
[null,"B","C","D","E","F","G","H","I"]
[2]
[3,null,"Kandidaatnaam:"]
[4,null,"Kandidaatnummer:"]
[5]
[6,{"$nulls":4},"draden H07V-U (VD)"]
[7,{"$nulls":3},"pvc-Ø16 mm","2,5 mm²",null,null,"1,5 mm²"]
[8,{"$nulls":3},"buis","bruin","blauw","geel/groen","zwart"]
[9,null,"leidingnummer:","lengte (mm)","aantal","aantal",{"$nulls":3},"formules"]
[10,null,1,null,1,{"$nulls":4},"Rij 31"]
[11,null,2,null,1,{"$nulls":4},"Formule in E31:"]
[12,null,3,null,1,{"$nulls":4},"Formule in F31:"]
[13,null,4,null,1,{"$nulls":4},"Formule in G31:"]
[14,null,5,null,1,{"$nulls":4},"Formule in H31:"]
[15,null,6,null,1,{"$nulls":4},"Formule in I31:"]
[16,null,7,null,1]
[17,null,8,null,1,{"$nulls":4},"Rij 33"]
[18,{"$nulls":8},"Formule in E33:"]
[19,{"$nulls":4},"draden H07V-U (VD)",{"$nulls":3},"Formule in F33:"]
[20,{"$nulls":3},"pvc-Ø16 mm","2,5 mm²",null,null,"1,5 mm²","Formule in G33:"]
[21,{"$nulls":3},"buis","bruin","blauw","geel/groen","zwart","Formule in H33:"]
[22,null,"leidingnummer:","lengte (mm)","lengte (mm)","lengte (mm)",{"$nulls":3},"Formule in I33:"]
[23,null,1,{"$f":"D10","v":0},{"$f":"E10*$D10","v":0},0,0,0,0]
[24,null,2,{"$f":"D11","v":0},0,0,0,0,0,"Rij 34"]
[25,null,3,0,0,0,0,0,0,"Formule in E34:"]
[26,null,4,0,0,0,0,0,0,"Formule in F34:"]
[27,null,5,0,0,0,0,0,0,"Formule in G34:"]
[28,null,6,0,0,0,0,0,0,"Formule in H34:"]
[29,null,7,0,{"$f":"E16*$D16","v":0},0,0,0,0,"Formule in I34:"]
[30,null,8,0,{"$f":"E17*$D17","v":0},{"$f":"F17*$D17","v":0},{"$f":"G17*$D17","v":0},{"$f":"H17*$D17","v":0},{"$f":"I17*$D17","v":0}]
[31,null,"subtotaal in mm"]
[32,null,"5% voor las, krul en aansluiting",null,null,{"$f":"0.05*F31","v":0},{"$f":"0.05*G31","v":0},0,0]
[33,null,"totaal in mm"]
[34,null,"totaal in m"]
[35,null,"totaal naar boven afgerond in m",null,{"$f":"ROUNDUP(E34,0)","v":0},{"$f":"ROUNDUP(F34,0)","v":0},{"$f":"ROUNDUP(G34,0)","v":0},{"$f":"ROUNDUP(H34,0)","v":0},{"$f":"ROUNDUP(I34,0)","v":0}]
[36]