{"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",15]
[null,"Thema","Formular erstellen"]
[]
[null,"Inhalt","Pressverbindung"]
[]
[]
[]
[]
[null,"Version","5.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2026-05-17"]
[]
[]
[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},-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},-5.334312889856424E-2]
[0.75,0.8125,0.78125,-1.2738855851668812E-2]
[0.75,0.78125,0.765625,7.8287048030542816E-3]
[0.765625,0.78125,0.7734375,-2.4790794244755887E-3]
[0.765625,0.7734375,0.76953125,2.6686513112177401E-3]
[0.76953125,0.7734375,0.771484375,9.3266221053461829E-5]
[0.771484375,0.7734375,0.7724609375,-1.1932840051751825E-3]
[0.771484375,0.7724609375,0.77197265625,-5.5010355657514332E-4]
[0.771484375,0.77197265625,0.771728515625,-2.2844237329097683E-4]
[0.771484375,0.771728515625,0.7716064453125,-6.759400743872046E-5]
[0.771484375,0.7716064453125,0.77154541015625,1.2834623359464503E-5]
[0.77154541015625,0.7716064453125,0.771575927734375,-2.7380062824350349E-5]
[0.77154541015625,0.771575927734375,0.7715606689453125,-7.2728124382581694E-6]
[0.77154541015625,0.7715606689453125,0.77155303955078125,2.780882282921171E-6]
[0.77155303955078125,0.7715606689453125,0.77155685424804688,-2.2459708719779758E-6]
[0.77155303955078125,0.77155685424804688,0.77155494689941406,2.6745425688035063E-7]
[0.77155494689941406,0.77155685424804688,0.77155590057373047,-9.8925866967580767E-7]
[0.77155494689941406,0.77155590057373047,0.77155542373657227,-3.6090229696417175E-7]
[0.77155494689941406,0.77155542373657227,0.77155518531799316,-4.6724042607193539E-8]
[0.77155494689941406,0.77155518531799316,0.77155506610870361,1.1036510144668554E-7]
[0.77155506610870361,0.77155518531799316,0.77155512571334839,3.1820527934822707E-8]
[0.77155512571334839,0.77155518531799316,0.77155515551567078,-7.4517576553745357E-9]
[0.77155512571334839,0.77155515551567078,0.77155514061450958,1.2184385056457359E-8]
[0.77155514061450958,0.77155515551567078,0.77155514806509018,2.3663136727858358E-9]
[0.77155514806509018,0.77155515551567078,0.77155515179038048,-2.5427219774165621E-9]
[0.77155514806509018,0.77155515179038048,0.77155514992773533,-8.8204166193150968E-11]
[0.77155514806509018,0.77155514992773533,0.77155514899641275,1.1390547394185546E-9]