{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ein- und Ausgabe","Berechnung"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Ein- und Ausgabe","index":0,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,9,3,10]]}
[]
[null,"Auswertung von Arbeitsintegralen",null,null,null,null,null,null,"Stablänge:  L = ",null,4," m"]
[null,null,null,null,null,null,null,null,"Biege- bzw. Dehnsteifigkeit:  B = ",null,20000," kNm² bzw. kN"]
[null,null,null,null,null,null,null,"Ergebnis: ","        d =   ",{"$f":"Berechnung!M10/'Ein- und Ausgabe'!K3","v":1.0666666666666665E-3},null," m bzw. rad"]

{"sheet":"Berechnung","index":1,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,12,9,13]]}
[]
[null,null,"Funktion 1","Funktion 2",null,null,"Stablänge","L =",{"$f":"'Ein- und Ausgabe'!K2","v":4}]
[null,"Stützstellen","linear","quadratisch",null,null,"Gleichungssystem",null,null,null,"Polynom (Funktion1 * Funktion2)"]
[null,"J1",0,0,null,null,1,0,0,null,null,null,{"$f":"TRANSPOSE(D8:D10)","v":0},4,-1]
[null,"J2",2,4,null,null,1,{"$f":"0.5*I2","v":2},{"$f":"(I2/2)^2","v":4}]
[null,"J3",4,0,null,null,1,{"$f":"I2","v":4},{"$f":"I2^2","v":16},null,{"$f":"C8","v":0},null,{"$f":"MMULT(K6:K8,M4:O4)","v":0},0,0]
[null,"Koeff.",{"$f":"C3","v":"linear"},{"$f":"D3","v":"quadratisch"},null,null,"Inverse",null,null,null,{"$f":"C9","v":1},null,0,4,-1]
[null,1,{"$f":"MMULT(G8:I10,C4:D6)","v":0},0,null,null,{"$f":"MINVERSE(G4:I6)","v":1},0,0,null,{"$f":"C10","v":0},null,0,0,0]
[null,"x",1,4,null,null,-0.75,1,-0.25]
[null,"x²",0,-1,null,null,0.125,-0.25,0.125,null,"Integral:",null,{"$f":"M6*I2+1/2*(M7+N6)*I2^2+1/3*(M8+N7+O6)*I2^3+1/4*(N8+O7)*I2^4+1/5*O8*I2^5","v":21.333333333333329}]
[]
[null,null,null,null,null,{"$f":"CONCATENATE(C2,\" (\",C3,\")\")","v":"Funktion 1 (linear)"},null,null,null,null,null,{"$f":"CONCATENATE(D2,\" (\",D3,\")\")","v":"Funktion 2 (quadratisch)"}]
[null,"Abszisse",{"$f":"C7","v":"linear"},{"$f":"D7","v":"quadratisch"}]
[0,{"$f":"A14*$I$2/10","v":0},{"$f":"C$8+$B14*C$9+C$10*$B14^2","v":0},{"$f":"D$8+$B14*D$9+D$10*$B14^2","v":0}]
[1,0.4,{"$f":"C$8+$B15*C$9+C$10*$B15^2","v":0.4},1.44]
[2,0.8,0.8,2.56]
[3,1.2,1.2,3.36]
[4,1.6,1.6,3.84]
[5,2,2,4]
[6,2.4,2.4,3.84]
[7,2.8,2.8,3.3600000000000003]
[8,3.2,3.2,2.5599999999999987]
[9,3.6,3.6,1.4399999999999995]
[10,4,4,0]