{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kragstütze","Rahmen"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Kragstütze","index":0,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[null,"System:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Eingabe:",null,null,null,null,null,null,"Auswahl:"]
[null,null,"EI = ",7750,"kNm²","F =","900","kN"]
[null,null,"EA = ","dehnstarr","kN","e =",0.1,"m","Ergebnis:"]
[null,null,"h = ",4,"m","W =",0,"kN"]
[null,null,null,null,null,"u2,imp =",0,"m"]
[null,"Ergebnisse:"]
[null,null,"Kraft- und Verformungsgrößen"]
[null,null,"Av","Ah","AM","M1","M2","elast. u2","ges. u2"]
[null,null,"kN","kN","kNm","kNm","kNm","m","m"]
[null,"Iteration",null,null,null,null,null,0,{"$f":"H24+$G$19","v":0}]
[null,0,{"$f":"$G$16*1","v":900},{"$f":"-$G$18","v":0},{"$f":"-F25","v":90},{"$f":"-$G$16*($G$17+$G$19+H24)-$G$18*$D$18","v":-90},{"$f":"-$G$16*$G$17","v":-90},{"$f":"$D$18/$D$16*(0.5*$G$16*$G$17+1/3*$G$18*$D$18+1/3*$G$16*$G$19+5/12*$G$16*H24)*$D$18","v":9.290322580645162E-2},{"$f":"H25+$G$19","v":9.290322580645162E-2}]
[null,1,{"$f":"$G$16*1","v":900},{"$f":"-$G$18","v":0},{"$f":"-F26","v":173.61290322580646},{"$f":"-$G$16*($G$17+$G$19+H25)-$G$18*$D$18","v":-173.61290322580646},{"$f":"-$G$16*$G$17","v":-90},{"$f":"$D$18/$D$16*(0.5*$G$16*$G$17+1/3*$G$18*$D$18+1/3*$G$16*$G$19+5/12*$G$16*H25)*$D$18","v":0.16482830385015609},0.16482830385015609]
[null,2,900,0,238.34547346514049,-238.34547346514049,-90,0.22051223523883054,0.22051223523883054]
[null,3,900,0,288.46101171494752,-288.46101171494752,-90,0.26362237566877206,0.26362237566877206]
[null,4,900,0,327.26013810189488,-327.26013810189488,-90,0.29699796825969449,0.29699796825969449]
[null,5,900,0,357.29817143372503,-357.29817143372503,-90,0.32283713671718284,0.32283713671718284]
[null,6,900,0,380.55342304546451,-380.55342304546451,-90,0.34284165423265767,0.34284165423265767]
[null,7,900,0,398.55748880939188,-398.55748880939188,-90,0.35832902263173499,0.35832902263173499]
[null,8,900,0,412.49612036856155,-412.49612036856155,-90,0.37031924332779487,0.37031924332779487]
[null,9,900,0,423.28731899501537,-423.28731899501537,-90,0.37960199483442181,0.37960199483442181]
[null,10,900,0,431.64179535097963,-431.64179535097963,-90,0.38678864116213302,0.38678864116213302]
[null,11,900,0,{"$f":"-F36","v":438.10977704591977},{"$f":"-$G$16*($G$17+$G$19+H35)-$G$18*$D$18","v":-438.10977704591977},-90,0.39235249638358682,{"$f":"H36+$G$19","v":0.39235249638358682}]
[null,12,900,0,443.1172467452281,-443.1172467452281,-90,0.39665999720019623,0.39665999720019623,{"$f":"IF(E37>1.01*E36,\"Iteration unvollständig\",\"12 Iterationen ausreichend\")","v":"Iteration unvollständig"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Last-Verformungsdiagramm:"]
[null,null,null,"Th. I. Ord.","Th. II. Ord."]
[null,"Laststufe","Lastgröße","Verformung","Verformung","Iteration"]
[null,0,0,0,0,"OK"]
[null,1,100,1.032258064516129E-2,1.1294117647058665E-2,"OK"]
[null,2,200,2.0645161290322581E-2,2.4935064932180295E-2,"OK"]
[null,3,300,3.0967741935483871E-2,4.1739129495035054E-2,"OK"]
[null,4,400,4.1290322580645161E-2,6.2950760013569793E-2,"OK"]
[null,5,500,5.1612903225806452E-2,9.0564476505719971E-2,"OK"]
[null,6,600,6.1935483870967742E-2,0.12797639153642709,"OK"]
[null,7,700,7.2258064516129039E-2,0.1813731175156513,"OK"]
[null,8,800,8.2580645161290323E-2,0.26277157937840406,"OK"]
[null,9,900,9.290322580645162E-2,0.39665999720019623,"??"]
[null,10,1000,0.1032258064516129,0.6341771303800664,"??"]
[null,11,1050,0.10838709677419356,0.82175689627095361,"??"]
[null,12,1100,0.1135483870967742,1.0823483480290885,"??"]
[null,13,1150,0.11870967741935484,1.4474847636908776,"??"]
[null,14,1200,0.12387096774193548,1.9620160076818725,"??"]

{"sheet":"Rahmen","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"System:",null,null,null,"Formeln:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Eingabe:"]
[null,null,"EI =",34560,"kNm²","F =",800,"kN"]
[null,null,"L =",6,"m","W =",12,"kN"]
[null,null,"H =",6,"m","uR,imp =",{"$f":"D18/200","v":0.03},"m"]
[]
[null,"Ergebnisse:"]
[null,null,"Kraft- und Verformungsgrößen"]
[null,null,"Bv","Bh","Av","Ah","M2","uR"]
[null,null,"kN","kN","kN","kN","kNm","m"]
[null,"Iteration",null,null,null,null,null,{"$f":"$G$18+0","v":0.03}]
[null,0,{"$f":"$G$17*$D$18/$D$17+$G$16*($D$17+H24)/$D$17","v":816},{"$f":"-C25*H24/$D$18","v":-4.08},{"$f":"$G$16-C25","v":-16},{"$f":"D25-$G$17","v":-16.079999999999998},{"$f":"E25*H24-F25*$D$18","v":95.999999999999986},{"$f":"$G$18+1/$D$16*(1/3*$D$17*G25*$D$17+1/3*$D$18*G25*$D$18)","v":9.6666666666666651E-2}]
[null,1,{"$f":"$G$17*$D$18/$D$17+$G$16*($D$17+H25)/$D$17","v":824.8888888888888},{"$f":"-C26*H25/$D$18","v":-13.289876543209873},{"$f":"$G$16-C26","v":-24.8888888888888},{"$f":"D26-$G$17","v":-25.289876543209871},{"$f":"E26*H25-F26*$D$18","v":149.33333333333331},{"$f":"$G$18+1/$D$16*(1/3*$D$17*G26*$D$17+1/3*$D$18*G26*$D$18)","v":0.13370370370370371}]
[null,2,{"$f":"$G$17*$D$18/$D$17+$G$16*($D$17+H26)/$D$17","v":829.82716049382725},{"$f":"-C27*H26/$D$18","v":-18.491827465325411},{"$f":"$G$16-C27","v":-29.82716049382725},{"$f":"D27-$G$17","v":-30.491827465325411},{"$f":"E27*H26-F27*$D$18","v":178.96296296296296},0.15427983539094653]
[null,3,{"$f":"$G$17*$D$18/$D$17+$G$16*($D$17+H27)/$D$17","v":832.57064471879278},{"$f":"-C28*H27/$D$18","v":-21.40814366975826},{"$f":"$G$16-C28","v":-32.570644718792778},{"$f":"D28-$G$17","v":-33.40814366975826},{"$f":"E28*H27-F28*$D$18","v":195.42386831275721},0.16571101966163695]
[null,4,834.09480262155159,-23.036450039481522,-34.094802621551594,-35.036450039481522,204.56881572930956,0.17206167758979832]
[null,5,834.94155701197315,-23.943574164819722,-34.941557011973146,-35.943574164819722,209.64934207183865,0.17558982088322128]
[null,6,835.41197611776295,-24.448306541702653,-35.411976117762947,-36.448306541702649,212.471856706577,0.17754990049067848]
[null,7,835.67332006542381,-24.728952470055152,-35.673320065423809,-36.728952470055148,214.03992039254277,0.1786388336059325]
[null,8,835.81851114745768,-24.884940656271485,-35.818511147457684,-36.884940656271482,214.91106688474596,0.17924379644774024]
[null,9,{"$f":"$G$17*$D$18/$D$17+$G$16*($D$17+H33)/$D$17","v":835.89917285969875},{"$f":"-C34*H33/$D$18","v":-24.97162353181638},{"$f":"$G$16-C34","v":-35.899172859698751},{"$f":"D34-$G$17","v":-36.971623531816377},{"$f":"E34*H33-F34*$D$18","v":215.39503715819217},0.17957988691541124]
[null,10,{"$f":"$G$17*$D$18/$D$17+$G$16*($D$17+H34)/$D$17","v":835.94398492205482},{"$f":"-C35*H34/$D$18","v":-25.019787713320142},{"$f":"$G$16-C35","v":-35.943984922054824},{"$f":"D35-$G$17","v":-37.019787713320142},{"$f":"E35*H34-F35*$D$18","v":215.663909532329},0.17976660384189516]