{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Pressverband","Information","Liste"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":16,"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","4.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2023-06-06"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Pressverband","index":1,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Information"]
[]
[]
[]
[]
[null,"Maße"]
[null,"di",null,100,"mm"]
[null,"da",null,200,"mm"]
[null,"l",null,250,"mm"]
[null," "]
[null,"Zulässige Festigkeiten",null,null,null,"Innenteil",null,"Außenteil"]
["42CrMo4","σ zul,i",null,{"$f":" VLOOKUP(Mat_i,Festigkeiten,2,FALSE)","v":1080},"N/mm²"]
["St 37-2","σ zul,a",null,{"$f":" VLOOKUP(Mat_a,Festigkeiten,2,FALSE)","v":350},"N/mm²"]
[null,"Haftbeiwert ν",null,0.3]
[]
[]
[]
[]
[]
[null,"Auswertung"]
[null,"c",null,{"$f":"Zul_i/Zul_a","v":3.0857142857142859}]
[null,"q",null,{"$f":"D_i/D_a","v":0.5}]
[null,"df",null,{"$f":"D_a*faktor(D23,D24)","v":115.14205932617188},"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":84.083782324186075},"N/mm²","vorh. Fugenpressung"]
[null,"Fa",null,{"$f":"D_f*PI()*Lng*p_0*Haft/1000","v":2971.7661694016956},"kN","übertragbare Axialkraft"]
[null,"Md",null,{"$f":"D_f^2*PI()/2*Lng*p_0*Haft/1000000","v":222.88246270512718},"kNm","übertragbares Drehmoment"]

{"sheet":"Information","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Pressverbindung",null,null,null,"Die Pressverbíndung wird durch elastische"]
[null,null,null,null,null,"Verformungen von Welle und Nabe"]
[null,null,null,null,null,"erzeugt."]
[null,null,null,null,null,"Dieses Formblatt bestimmt den"]
[null,null,null,null,null,"optimalen Fugendurchmesser im"]
[null,null,null,null,null,"Sinne gleichmäßiger Beanspruchung."]
[]
[null,null,null,null,null,"Auslegung siehe DIN 7190"]
[null,null,null,null,null,"Festigkeitsnachweis siehe DIN 743"]
[]
[]
[]
[]
[null,"Eine Pressverbundung muss so ausgelegt sein, dass:"]
[null,"1.","Eine Mindestflächenpressung vorhanden ist, die das größte auftretende"]
[null,null,"Drehmoment und die gräßten Kräfte übertragen kann."]
[null,"2.","Die höchstzulässige Flächenpressung nicht überschritten wird, damit die"]
[null,null,"Bauteile nicht überansprucht werden."]
[]
[null,null,"… zurück"]

{"sheet":"Liste","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Material","Festigkeit \nin N/mm2"]
["St 37-2",350]
["St 50-2",460]
["42CrMo4",1080]
["16MnCr5",760]