{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Pressverband","Iteration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Cover","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel in Perfektion"]
[]
[]
[null,"Kapitel",8]
[null,"Thema","Berechnungen durchführen"]
[]
[null,"Inhalt","Pressverbindung"]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2017-03-01"]
[null,"Version","2.0"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Pressverband","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Maße"]
[null,"di",null,100,"mm"]
[null,"da",null,200,"mm"]
[null,"l",null,250,"mm"]
[null," "]
[null,"Zulässige Festigkeiten"]
[null,"σ zul,i",null,480,"N/mm²"]
[null,"σ zul,a",null,630,"N/mm²"]
[null,"Haftbeiwert ν",null,0.3]
[]
[null,"Auswertung"]
[null,"c",null,{"$f":"Zul_i/Zul_a","v":0.76190476190476186}]
[null,"q",null,{"$f":"D_i/D_a","v":0.5}]
[null,"df",null,{"$f":"D_a*INDEX(Mittelwert,COUNTA(Mittelwert))","v":154.31102979928255},"mm","opt. Fugendurchmesser"]
[]
[null,"gewählt df",null,150,"mm","Fugendurchmesser"]
[null,"qa",null,{"$f":"D_f/D_a","v":0.75}]
[null,"p0",null,{"$f":"(1-q_a^2)/SQRT(3+q_a^4)*Zul_a","v":151.35080818353495},"N/mm²","vorh. Fugenpressung"]
[null,"Fa",null,{"$f":"D_f*PI()*Lng*p_0*Haft/1000","v":5349.1791049230524},"kN","übertragbare Axialkraft"]
[null,"Md",null,{"$f":"D_f^2*PI()/2*Lng*p_0*Haft/1000000","v":401.18843286922896},"kNm","übertragbares Drehmoment"]

{"sheet":"Iteration","index":2,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["q0","q1","q2","f "]
[{"$f":"D_i/D_a","v":0.5},{"$f":"1","v":1},{"$f":"(A2+B2)/2","v":0.75},{"$f":"(1-C2*C2)/SQRT(3+C2^4)-q_Zul/2*(1-(q_D/C2)^2)","v":2.8599166428891459E-2}]
[{"$f":"IF(D2>=0,C2,A2)","v":0.75},{"$f":"IF(D2<0,C2,B2)","v":1},{"$f":"(A3+B3)/2","v":0.875},{"$f":"(1-C3*C3)/SQRT(3+C3^4)-q_Zul/2*(1-(q_D/C3)^2)","v":-0.13279553692700902}]
[{"$f":"IF(D3>=0,C3,A3)","v":0.75},{"$f":"IF(D3<0,C3,B3)","v":0.875},{"$f":"(A4+B4)/2","v":0.8125},{"$f":"(1-C4*C4)/SQRT(3+C4^4)-q_Zul/2*(1-(q_D/C4)^2)","v":-5.334312889856424E-2}]
[0.75,0.8125,0.78125,{"$f":"(1-C5*C5)/SQRT(3+C5^4)-q_Zul/2*(1-(q_D/C5)^2)","v":-1.2738855851668812E-2}]
[0.75,0.78125,0.765625,{"$f":"(1-C6*C6)/SQRT(3+C6^4)-q_Zul/2*(1-(q_D/C6)^2)","v":7.8287048030542816E-3}]
[0.765625,0.78125,0.7734375,{"$f":"(1-C7*C7)/SQRT(3+C7^4)-q_Zul/2*(1-(q_D/C7)^2)","v":-2.4790794244755887E-3}]
[0.765625,0.7734375,0.76953125,{"$f":"(1-C8*C8)/SQRT(3+C8^4)-q_Zul/2*(1-(q_D/C8)^2)","v":2.6686513112177401E-3}]
[0.76953125,0.7734375,0.771484375,{"$f":"(1-C9*C9)/SQRT(3+C9^4)-q_Zul/2*(1-(q_D/C9)^2)","v":9.3266221053461829E-5}]
[0.771484375,0.7734375,0.7724609375,{"$f":"(1-C10*C10)/SQRT(3+C10^4)-q_Zul/2*(1-(q_D/C10)^2)","v":-1.1932840051751825E-3}]
[0.771484375,0.7724609375,0.77197265625,{"$f":"(1-C11*C11)/SQRT(3+C11^4)-q_Zul/2*(1-(q_D/C11)^2)","v":-5.5010355657514332E-4}]
[0.771484375,0.77197265625,0.771728515625,{"$f":"(1-C12*C12)/SQRT(3+C12^4)-q_Zul/2*(1-(q_D/C12)^2)","v":-2.2844237329097683E-4}]
[0.771484375,0.771728515625,0.7716064453125,{"$f":"(1-C13*C13)/SQRT(3+C13^4)-q_Zul/2*(1-(q_D/C13)^2)","v":-6.759400743872046E-5}]
[0.771484375,0.7716064453125,0.77154541015625,{"$f":"(1-C14*C14)/SQRT(3+C14^4)-q_Zul/2*(1-(q_D/C14)^2)","v":1.2834623359464503E-5}]
[0.77154541015625,0.7716064453125,0.771575927734375,{"$f":"(1-C15*C15)/SQRT(3+C15^4)-q_Zul/2*(1-(q_D/C15)^2)","v":-2.7380062824350349E-5}]
[0.77154541015625,0.771575927734375,0.7715606689453125,{"$f":"(1-C16*C16)/SQRT(3+C16^4)-q_Zul/2*(1-(q_D/C16)^2)","v":-7.2728124382581694E-6}]
[0.77154541015625,0.7715606689453125,0.77155303955078125,{"$f":"(1-C17*C17)/SQRT(3+C17^4)-q_Zul/2*(1-(q_D/C17)^2)","v":2.780882282921171E-6}]
[0.77155303955078125,0.7715606689453125,0.77155685424804688,{"$f":"(1-C18*C18)/SQRT(3+C18^4)-q_Zul/2*(1-(q_D/C18)^2)","v":-2.2459708719779758E-6}]
[0.77155303955078125,0.77155685424804688,0.77155494689941406,{"$f":"(1-C19*C19)/SQRT(3+C19^4)-q_Zul/2*(1-(q_D/C19)^2)","v":2.6745425688035063E-7}]
[0.77155494689941406,0.77155685424804688,0.77155590057373047,{"$f":"(1-C20*C20)/SQRT(3+C20^4)-q_Zul/2*(1-(q_D/C20)^2)","v":-9.8925866967580767E-7}]
[0.77155494689941406,0.77155590057373047,0.77155542373657227,{"$f":"(1-C21*C21)/SQRT(3+C21^4)-q_Zul/2*(1-(q_D/C21)^2)","v":-3.6090229696417175E-7}]
[0.77155494689941406,0.77155542373657227,0.77155518531799316,{"$f":"(1-C22*C22)/SQRT(3+C22^4)-q_Zul/2*(1-(q_D/C22)^2)","v":-4.6724042607193539E-8}]
[0.77155494689941406,0.77155518531799316,0.77155506610870361,{"$f":"(1-C23*C23)/SQRT(3+C23^4)-q_Zul/2*(1-(q_D/C23)^2)","v":1.1036510144668554E-7}]
[0.77155506610870361,0.77155518531799316,0.77155512571334839,{"$f":"(1-C24*C24)/SQRT(3+C24^4)-q_Zul/2*(1-(q_D/C24)^2)","v":3.1820527934822707E-8}]
[0.77155512571334839,0.77155518531799316,0.77155515551567078,{"$f":"(1-C25*C25)/SQRT(3+C25^4)-q_Zul/2*(1-(q_D/C25)^2)","v":-7.4517576553745357E-9}]
[0.77155512571334839,0.77155515551567078,0.77155514061450958,{"$f":"(1-C26*C26)/SQRT(3+C26^4)-q_Zul/2*(1-(q_D/C26)^2)","v":1.2184385056457359E-8}]
[0.77155514061450958,0.77155515551567078,0.77155514806509018,{"$f":"(1-C27*C27)/SQRT(3+C27^4)-q_Zul/2*(1-(q_D/C27)^2)","v":2.3663136727858358E-9}]
[0.77155514806509018,0.77155515551567078,0.77155515179038048,{"$f":"(1-C28*C28)/SQRT(3+C28^4)-q_Zul/2*(1-(q_D/C28)^2)","v":-2.5427219774165621E-9}]
[0.77155514806509018,0.77155515179038048,0.77155514992773533,{"$f":"(1-C29*C29)/SQRT(3+C29^4)-q_Zul/2*(1-(q_D/C29)^2)","v":-8.8204166193150968E-11}]
[0.77155514806509018,0.77155514992773533,0.77155514899641275,{"$f":"(1-C30*C30)/SQRT(3+C30^4)-q_Zul/2*(1-(q_D/C30)^2)","v":1.1390547394185546E-9}]