{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blad1","Toelichting"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":7,"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":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Project:","VBA in EXCEL",null,null,null,"Versie:","1.00"]
[null,null,null,"Onderdeel:","Let's talk"]
[null,null,null,"Datum:","2020-04-01",null,null,null,"Klik op logo Vullings Advies"]
[]
[]
[null,"Invoer",null,null,null,null,null,null,"Tabel 3.1 - Sterkte- en vervormingseigenschappen voor beton (NEN-EN 1992-1-1:2005)"]
[null,"Breedte","=",250,"mm",null,null,null,"Naam",null,null,null,null,null,{"$f":"\"C\" & O9 & \"/\" & O10","v":"C12/15"},{"$f":"\"C\" & P9 & \"/\" & P10","v":"C16/20"},"C20/25","C25/30","C30/37","C35/45","C40/50","C45/55","C50/60","C55/67","C60/75","C70/85","C80/95","C90/105"]
[null,"Hoogte","=",500,"mm",null,null,null,"Karakteristieke cilinderdruksterkte",null,null,null,"fck","MPa",12,16,20,25,30,35,40,45,50,55,60,70,80,90]
[null,"Lengte","=",1500,"mm",null,null,null,"Karakteristieke kubusdruksterkte",null,null,null,"fck,cube","MPa",15,20,25,30,37,45,50,55,60,67,75,85,95,105]
[null,"Doorsnede O","=",{"$f":"(Breedte+Hoogte)*2","v":1500},"mm",null,null,null,"Gemiddelde cilinderdruksterkte",null,null,null,"fcm","MPa",{"$f":"O9+8","v":20},{"$f":"P9+8","v":24},28,33,38,43,48,53,58,63,68,78,88,98]
[null,"Doorsnede A","=",{"$f":"Breedte*Hoogte","v":125000},"mm2",null,null,null,"Gemiddelde axiale treksterkte",null,null,null,"fctm","MPa",{"$f":"IF(O9<50,0.3*O9^(2/3),2.12*LN(1+O11/10))","v":1.5724448365253381},{"$f":"IF(P9<50,0.3*P9^(2/3),2.12*LN(1+P11/10))","v":1.9048812623618392},2.2104188991842313,2.5649639200150443,2.896468153816889,3.2099624416952368,3.5088212858554391,3.7954469938578708,4.0638759378259692,4.214293618087213,4.3547423154345584,4.6104736495464218,4.8386506576342363,5.0446378043559692]
[null,"Doorsnede W","=",{"$f":"1/6*Breedte*Hoogte^2","v":10416666.666666666},"mm3",null,null,null,"Karakteristieke axiale treksterkte (5%)",null,null,null,"fctk,0,05","MPa",{"$f":"0.7*O12","v":1.1007113855677366},{"$f":"0.7*P12","v":1.3334168836532874},1.5472932294289619,1.7954747440105308,2.0275277076718221,2.2469737091866655,2.4561749000988073,2.6568128957005093,2.8447131564781785,2.950005532661049,3.0483196208041905,3.227331554682495,3.3870554603439653,3.531246463049178]
[null,"Doorsnede I","=",{"$f":"1/12*Breedte*Hoogte^3","v":2604166666.6666665},"mm4",null,null,null,"Karakteristieke axiale treksterkte (95%)",null,null,null,"fctk,0,95","MPa",{"$f":"1.3*O12","v":2.0441782874829397},{"$f":"1.3*P12","v":2.4763456410703912},2.8735445689395007,3.3344530960195575,3.765408599961956,4.1729511742038081,4.5614676716120712,4.9340810920152318,5.28303871917376,5.4785817035133775,5.6611650100649262,5.9936157444103486,6.2902458549245077,6.5580291456627604]
[null,null,null,null,null,null,null,null,"Secans E modulus",null,null,null,"Ecm","GPa",{"$f":"22*(O11/10)^0.3","v":27.085177093588158},28.607904894961401,29.961951054640309,31.475806210019346,32.836568031330792,34.077146199189329,35.220462288934414,36.283188218914134,37.277869091614654,38.214206461639002,39.099873708049074,40.742817784548983,42.244238168935823,43.630531500658059]
[null,"Beton",":","C35/45",null,null,null,null,"Betonstuik bij piekspanning fc",null,null,null,"ec1","0/00",{"$f":"IF(0.7*O11^0.31>2.8,2.8,0.7*O11^0.31)","v":1.7718107758850909},{"$f":"IF(0.7*P11^0.31>2.8,2.8,0.7*P11^0.31)","v":1.8748370396696974},1.9666045051940388,2.0693662482105193,2.1618768697354804,2.2463284691964671,2.3242499142093389,2.3967545449312704,2.4646810048680772,2.5286784670814431,2.5892608390866876,2.7017637279883995,2.8,2.8]
[null,null,null,null,null,null,null,null,"Grenswaarde van de rek",null,null,null,"ecu1","0/00",{"$f":"IF(O9>50,2.8+27*((98-O11)/100)^4,3.5)","v":3.5},{"$f":"IF(P9>50,2.8+27*((98-P11)/100)^4,3.5)","v":3.5},3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.2051687499999995,3.0186999999999999,2.8431999999999999,2.8026999999999997,2.8]
[null,null,null,null,null,null,null,null,"Vervorming bij maximale sterkte",null,null,null,"ec2","0/00",{"$f":"IF(O9>50,2+0.085*(O9-50)^0.53,2)","v":2},{"$f":"IF(P9>50,2+0.085*(P9-50)^0.53,2)","v":2},2,2,2,2,2,2,2,2.1994679057750481,2.2880175327183223,2.4158769243143414,2.5155765911087431,2.6004968327615767]
[null,null,null,null,null,null,null,null,"Grenswaarde van de rek",null,null,null,"ecu2","0/00",{"$f":"IF(O9>50,2.6+35*((90-O9)/100)^4,3.5)","v":3.5},{"$f":"IF(P9>50,2.6+35*((90-P9)/100)^4,3.5)","v":3.5},3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.1252187500000002,2.8835000000000002,2.6560000000000001,2.6034999999999999,2.6]
[null,null,null,null,null,null,null,null,"Exponent",null,null,null,"n","-",{"$f":"IF(O9>50,1.4+23.4*((90-O9)/100)^4,2)","v":2},{"$f":"IF(P9>50,1.4+23.4*((90-P9)/100)^4,2)","v":2},2,2,2,2,2,2,2,1.7511462499999997,1.58954,1.4374399999999998,1.4023399999999999,1.4]
[null,null,null,null,null,null,null,null,"Vervorming bij maximale sterkte",null,null,null,"ec3","0/00",{"$f":"IF(O9>50,1.75+0.55*((O10-50)/40),1.75)","v":1.75},{"$f":"IF(P9>50,1.75+0.55*((P10-50)/40),1.75)","v":1.75},1.75,1.75,1.75,1.75,1.75,1.75,1.75,1.9837500000000001,2.09375,2.2312500000000002,2.3687499999999999,2.5062500000000001]
[null,null,null,null,null,null,null,null,"Grenswaarde van de rek",null,null,null,"ecu3","0/00",{"$f":"IF(O9>50,2.6+35*((90-O9)/100)^4,3.5)","v":3.5},{"$f":"IF(P9>50,2.6+35*((90-P9)/100)^4,3.5)","v":3.5},3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.1252187500000002,2.8835000000000002,2.6560000000000001,2.6034999999999999,2.6]

{"sheet":"Toelichting","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Project:",{"$f":"Projectnaam","v":"VBA in EXCEL"},null,null,null,null,"Versie:",null,{"$f":"Versie","v":"1.00"}]
[null,null,null,"Onderdeel:",{"$f":"Onderdeel","v":"Let's talk"}]
[null,null,null,"Datum:",{"$f":"Datum","v":"2020-04-01"}]
[]
[]
[]
[]
[null,"Let's talk"]
[null,"De gesproken taal en de stem (man/vrouw) is afhankelijk van de huidige instelling van Windows."]
[null,"Om deze te wijzigen, neem de volgende stappen:"]
[]
[null,"1) Ga naar Control Panel"]
[null,"    Ga naar Instellingen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2) Gaan naar Tijd en Taal (Spraak, regio, datum)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3) Voor een andere stem kies \"Spraak\" en"]
[null,"    \"Stemmen\". Er is een optie \"Stemmen toevoegen\"."]
[null,"   Gebruik deze als andere stemmen gewenst zijn."]
[]
[]
[]
[null,"Voor meer informatie ga naar Microsoft Help."]