{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Výpočty","Tisk","Tabulky"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":1,"defined_names":34,"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":"Výpočty","index":0,"n_rows":360,"n_cols":15,"rows_kept":360,"cut":false,"hidden":false,"merged":[[21,7,21,8],[22,7,22,8],[32,15,32,16],[30,5,30,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[31,5,31,6],[87,5,87,6],[33,5,33,6],[76,10,78,10],[3,5,3,6],[12,5,12,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[25,5,25,6],[9,5,9,6],[7,5,7,6],[8,5,8,6],[27,5,27,6],[56,5,56,6],[46,5,46,6],[47,5,47,6],[53,5,53,6],[54,5,54,6],[10,5,10,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[14,5,14,6],[11,5,11,6],[45,5,45,6],[55,5,55,6],[52,5,52,6],[8,0,8,3],[7,0,7,3],[6,0,6,3],[5,0,5,3],[49,0,49,3],[66,0,66,3],[107,0,107,7],[109,7,109,8],[113,7,113,8],[48,0,48,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[37,0,37,3],[20,7,20,8],[19,7,19,8],[40,7,40,8],[39,7,39,8],[23,5,23,6],[26,5,26,6],[11,0,11,3],[10,0,10,3],[9,0,9,3],[15,0,15,3],[93,5,93,6],[83,5,83,6],[81,5,81,6],[84,5,84,6],[85,5,85,6],[74,0,74,3],[105,5,105,6],[104,5,104,6],[103,0,103,7],[82,5,82,6],[30,0,30,3],[31,0,31,3],[38,0,38,3],[39,0,39,3],[32,0,32,3],[33,0,33,3],[36,5,36,6],[34,5,34,6],[35,5,35,6],[32,5,32,6],[17,0,17,3],[18,0,18,3],[23,0,23,3],[19,0,19,3],[20,0,20,3],[84,9,85,9],[43,5,43,6],[41,5,41,6],[42,5,42,6],[32,7,32,8],[53,0,53,3],[58,0,58,3],[41,7,41,8],[44,7,44,8],[40,0,40,3],[55,0,55,3],[54,0,54,3],[65,0,65,3],[64,0,64,3],[63,0,63,3],[62,0,62,3],[61,0,61,3],[73,0,73,3],[72,0,72,3],[70,0,70,3],[59,0,59,3],[57,0,57,3],[56,0,56,3],[50,0,50,3],[142,0,142,3],[141,0,141,3],[139,0,139,3],[138,0,138,3],[129,0,129,3],[130,0,130,3],[131,0,131,3],[133,0,133,3],[132,0,132,3],[124,0,124,3],[125,0,125,3],[108,0,108,3],[109,0,109,3],[110,0,110,3],[113,0,113,3],[109,5,109,6],[113,5,113,6],[114,5,114,6],[114,0,114,3],[135,7,135,8],[122,0,122,8],[106,0,106,8],[102,0,102,8],[116,7,116,8],[118,7,118,8],[119,7,119,8],[120,7,120,8],[135,0,135,3],[124,5,124,6],[125,5,125,6],[126,5,126,6],[123,0,123,7],[121,5,121,6],[115,7,115,8],[105,7,105,8],[136,5,136,6],[129,5,129,6],[128,5,128,6],[136,0,136,3],[134,0,134,3],[127,7,127,8],[125,7,125,8],[115,0,115,3],[116,0,116,3],[117,0,117,3],[119,0,119,3],[118,0,118,3],[120,0,120,3],[126,0,126,3],[127,0,127,3],[128,0,128,3],[127,5,127,6],[135,5,135,6],[133,5,133,6],[132,5,132,6],[131,5,131,6],[134,5,134,6],[1,0,1,8],[35,7,35,8],[34,7,34,8],[33,7,33,8],[105,0,105,3],[104,0,104,3],[28,0,28,3],[94,0,94,3],[93,0,93,3],[92,0,92,3],[91,0,91,3],[89,0,89,3],[90,0,90,3],[88,0,88,3],[87,0,87,3],[52,0,52,3],[34,0,34,3],[35,0,35,3],[31,7,31,8],[23,7,23,8],[4,0,4,3],[3,0,3,3],[14,0,14,3],[12,0,12,3],[0,0,0,8],[104,7,104,8],[28,5,28,6],[89,7,89,8],[90,7,90,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[97,5,97,6],[98,5,98,6],[96,0,96,3],[96,5,96,6],[99,0,99,3],[11,7,11,8],[37,5,37,6],[7,7,7,8],[8,7,8,8],[9,7,9,8],[41,0,41,3],[43,0,43,3],[42,0,42,3],[50,7,50,8],[12,7,12,8],[15,9,18,9],[94,5,94,6],[79,5,79,6],[80,5,80,6],[108,5,108,6],[110,5,110,6],[36,0,36,3],[45,0,45,3],[46,0,47,3],[60,0,60,3],[85,0,85,3],[84,0,84,3],[16,0,16,3],[83,0,83,3],[82,0,82,3],[81,0,81,3],[80,0,80,3],[79,0,79,3],[78,0,78,3],[77,0,77,3],[76,0,76,3],[75,0,75,3],[88,7,88,8],[84,7,84,8]]}
["VÝPOČET KUŽELOVÉHO SOUKOLÍ"]
["Normy: Definice a parametry kuželových kol DIN 3971, Výpočty únosnosti kuželových kol ISO 10300 1-3 a další.."]
["Vstupní hodnoty pro výpočet"]
["Výkon na hnacím hřídeli",null,null,null,"P",5,null,"[kW]"]
["Otáčky hnacího hřídele",null,null,null,"n1",1500,null,"[min-1]"]
["Počet zubů pastorku",null,null,null,"z1",17]
["Počet zubů kola",null,null,null,"z2",21]
["Čelní úhel záběru",null,null,null,"αt",20,null,"[°]"]
["Úhel sklonu zubu",null,null,null,"βm",0,null,"[°]"]
["Úhel mezi osami",null,null,null,"Σ",90,null,"[°]"]
["Požadovaná životnost",null,null,null,"Lh",100000,null,"[hod]"]
["Směr stoupání zubů pastorku",null,null,null,null,"LEVÝ"]
["Poměrná šířka věnce",null,null,null,"ΨL",0.35]
["Materiálové hodnoty",null,null,null,null,"Pastorek","Kolo"]
["Stupeň přesnosti dle ISO 1328",null,null,null,null,6,null,"°"]
["Modul pružnosti pastorku a kola",null,null,null,"E",206000,206000,"[MPa]"]
["Poissonova konstanta pastorku a kola",null,null,null,"μ",0.3,0.3]
["Mez únavy v ohybu",null,null,null,"σFlim",390,390,"[MPa]"]
["Mez únavy v dotyku",null,null,null,"σHlim",1140,1140,"[MPa]"]
["Exponent Wöhlerovy křivky pro ohyb",null,null,null,"qF",6,6]
["Exponent Wöhlerovy křivky pro dotyk",null,null,null,"qH",10,10]
["Bázový počet zatěžovacích cyklů pro ohyb",null,null,null,"NFlim",{"$f":"3*10^6","v":3000000},{"$f":"3*10^6","v":3000000}]
["Bázový počet zatěžovacích cyklů pro dotyk",null,null,null,"NHlim",{"$f":"100*10^6","v":100000000},{"$f":"100*10^6","v":100000000}]
["Kinematická viskozita oleje",null,null,null,"v",50,null,"[mm^2/s]"]
["Parametry převodu"]
["Krouticí moment ",null,null,null,"Mk",{"$f":"(9550*F4)/F5","v":31.833333333333332},null,"[Nm]"]
["Převodový poměr",null,null,null,"u",{"$f":"F7/F6","v":1.2352941176470589}]
["Otáčky hnaného hřídele",null,null,null,"n2",{"$f":"F$5/F$27","v":1214.2857142857142},null,"[min-1]"]
["Obvodová rychlost pastorku ",null,null,null,"v",{"$f":"(F64*PI()*F5)/(60*1000)","v":3.337942194439155},null,"[m/s]"]
["Návrh modulu a parametry profilu ozubení"]
["Druh ozubení",null,null,null,null,{"$f":"IF(AND(F9=0,F32=\"Typ I\"),\"PŘÍMÉ\",IF(AND(F9>0,F32=\"Typ I\"),\"ŠIKMÉ\",\"ZAKŘIVENÉ\"))","v":"PŘÍMÉ"}]
["Ozubení",null,null,null,null,"TYP I",null,{"$f":"IF(OR((AND(F32=\"Typ III\",F9=0)),(AND(F32=\"Typ II\",F9=0))),\"βm≠0!\",\"\")","v":""}]
["Koeficient bezpečnosti na dotyk",null,null,null,"SH",1.3]
["Součinitel přídavného zatížení na dotyk",null,null,null,"KH",2]
["Součinitel ozubení",null,null,null,"fH",77]
["Poměrná šířka ozubení",null,null,null,"Ψb",9]
["Návrh normálového modulu",null,null,null,"mnm´",{"$f":"F35*(((F34*F26*10^3*(COS(F77/180*PI()))^2)/(F36*F6^2*(F19/F33)^2)*((F88+1)/F88))^(1/3))","v":2.4402836638161931}]
["Normalizovaný normálový modul",null,null,null,"mnm",2.5]
["Jednotková výška hlavy",null,null,null,"ha*",1]
["Jednotková vůle",null,null,null,"c*",{"$f":"IF(F32=\"Typ I\",0.2,0.25)","v":0.2}]
["Zaoblení paty zubu",null,null,null,"rf*",{"$f":"(F40)/(1-SIN(F80/180*PI()))","v":0.30396067291614748}]
["Součinitel záběru profilem",null,null,null,"εα",{"$f":"(((F92^2-F91^2)^(1/2))-(2*F95*SIN(F81/180*PI()))+((G92^2-G91^2)^(1/2)))/(2*PI()*F56*COS(F8/180*PI()))","v":1.6125241996094093}]
["Součinitel záběru krokem",null,null,null,"εβ",{"$f":"(0.85*F60*SIN(F9/180*PI()))/(PI()*F54)","v":0}]
["Součinitel celkového záběru",null,null,null,"εγ",{"$f":"F42+F43","v":1.6125241996094093}]
["Komplexní stanovení korekcí",null,null,null,null,"Pastorek","Kolo"]
["Typ korekce",null,null,null,null,{"$f":"0","v":0}]
["Pomocné veličiny",null,null,null,"a",{"$f":"Tabulky!E7","v":0.03}]
[null,null,null,null,"b",{"$f":"Tabulky!E8","v":8.0000000000000002E-3}]
["Jednotkové posunutí",null,null,null,"x",{"$f":"(2*(1-(1/(F27)^2)))*(((COS(F9/180*PI()))^3)/F6)^0.5","v":0.16719009072799371},{"$f":"-F49","v":-0.16719009072799371}]
["Jednotková změna tloušťky zubu",null,null,null,"xt",{"$f":"F47+F48*(F27-2.5)","v":1.9882352941176469E-2},{"$f":"-F50","v":-1.9882352941176469E-2}]
["Snížení výšky paty zubu",null,null,null,"k",{"$f":"0.02*(17-F89)","v":-9.7442578026299104E-2},{"$f":"0.02*(17-G89)","v":-0.32751618307819341},{"$f":"IF(F51>0,\"ANO\",\"NE\")","v":"NE"}]
["Geometrie a parametry ozubení kuželových kol",null,null,null,null,"Pastorek","Kolo"]
["Vnější normálný modul ",null,null,null,"mne",{"$f":"F55*COS(F84/180*PI())","v":3.0303030303030303},null,"[mm]"]
["Střední normálný modul",null,null,null,"mnm",{"$f":"F38","v":2.5},null,"[mm]"]
["Vnější tečný modul",null,null,null,"mte",{"$f":"F54/((1-0.5*F13)*COS(F9/180*PI()))","v":3.0303030303030303},null,"[mm]"]
["Střední tečný modul",null,null,null,"mtm",{"$f":"F55*(F58/F57)","v":2.5},null,"[mm]"]
["Kuželová vzdálenost vnější",null,null,null,"Le",{"$f":"0.5*F55*(F6/SIN(F77/180*PI()))","v":40.937139654867565},null,"[mm]"]
["Kuželová vzdálenost střední",null,null,null,"Lm",{"$f":"F57-0.5*F60","v":33.773140215265741},null,"[mm]"]
["Kuželová vzdálenost vnitřní",null,null,null,"Li",{"$f":"F57-F60","v":26.609140775663917},null,"[mm]"]
["Šířka věnce",null,null,null,"b",{"$f":"F57*F13","v":14.327998879203646},null,"[mm]"]
["Vnější roztečný průměr",null,null,null,"de",{"$f":"F55*F6","v":51.515151515151516},{"$f":"F55*F7","v":63.636363636363633},"[mm]"]
["Vnější průměr hlavové kružnice",null,null,null,"dae",{"$f":"F55*(F6+2*(F39+F49)*COS(F77/180*PI()))","v":57.013287946417805},{"$f":"F55*(F7+2*(F39+G49)*COS(G77/180*PI()))","v":66.812136483218637},"[mm]"]
["Vnější průměr patní kružnice",null,null,null,"dfe",{"$f":"F55*(F6-2*(F39+F40-F49)*COS(F77/180*PI()))","v":46.650023003651334},{"$f":"F55*(F7-2*(F39+F40-G49)*COS(G77/180*PI()))","v":58.422826767645773},"[mm]"]
["Střední roztečný průměr",null,null,null,"dm",{"$f":"F56*F6","v":42.5},{"$f":"F7*F56","v":52.5},"[mm]"]
["Vnější výška hlavy zubu",null,null,null,"hae",{"$f":"IF(F32=\"Typ III\",IF(H51=\"NE\",(F39+F49)*F54,(F39+F49-F51)*F54),IF(H51=\"NE\",(F39+F49)*F55,(F39+F49-F51)*F55))","v":3.5369396688727082},{"$f":"IF(F32=\"Typ III\",IF(H51=\"NE\",(F39+G49)*F54,(F39+G49-G51)*F54),IF(H51=\"NE\",(F39+G49)*F55,(F39+G49-G51)*F55))","v":2.5236663917333524},"[mm]"]
["Vnější výška paty zubu",null,null,null,"hfe",{"$f":"IF(F32=\"Typ III\",(F39+F40-F49)*F54,(F39+F40-F49)*F55)","v":3.1297269977939584},{"$f":"IF(F32=\"Typ III\",(F39+F40-G49)*F54,(F39+F40+F49)*F55)","v":4.1430002749333141},"[mm]"]
["Vnější výška zubu",null,null,null,"he",{"$f":"IF(F32=\"Typ III\",((2*F39+F40)*F54),((2*F39+F40)*F55))","v":6.666666666666667},{"$f":"F67","v":6.666666666666667},"[mm]"]
["Střední výška hlavy zubu",null,null,null,"ha",{"$f":"(F39+F49)*F54","v":2.9179752268199843},{"$f":"(F39+G49)*F54","v":2.0820247731800157},"[mm]"]
["Střední výška paty zubu",null,null,null,"hf",{"$f":"(F39+F40-F49)*F54","v":2.5820247731800157},{"$f":"(F39+F40-G49)*F54","v":3.4179752268199843},"[mm]"]
["Střední výška zubu",null,null,null,"h",{"$f":"IF(F32=\"Typ III\",F68+F69,(2*F39+F40)*F54)","v":5.5},{"$f":"IF(F32=\"Typ III\",G68+G69,F70)","v":5.5},"[mm]"]
["Vnější tloušťka zubu ",null,null,null,"se",{"$f":"(0.5*PI()+2*F49*TAN(F8/180*PI())+F50)*F55","v":5.1890397354987394},{"$f":"(0.5*PI()+2*G49*TAN(F8/180*PI())+G50)*F55","v":4.3309380026521485},"[mm]"]
["Střední tloušťka zubu",null,null,null,"sm",{"$f":"(0.5*PI()+2*F49*TAN(F8/180*PI())+F50)*F54","v":4.2809577817864604},{"$f":"(0.5*PI()+2*G49*TAN(F8/180*PI())+G50)*F54","v":3.5730238521880224},"[mm]"]
["Šířka zubové mezery",null,null,null,"e",{"$f":"G71","v":4.3309380026521485},{"$f":"F71","v":5.1890397354987394},"[mm]"]
["Výška hlavového kužele",null,null,null,"A",{"$f":"F57*COS(F77/180*PI())-F65*SIN(F77/180*PI())","v":29.592745643621651},{"$f":"F57*COS(G77/180*PI())-G65*SIN(G77/180*PI())","v":23.796068999224143},"[mm]"]
["Úhel hlavy zubu",null,null,null,"qa",{"$f":"IF(F32=\"Typ III\",0,(ATAN(F65/F57))*180/PI())","v":4.9380515996753465},{"$f":"IF(F32=\"Typ III\",0,(ATAN(G65/F57)*180/PI()))","v":3.527668947791414},"[°]"]
["Úhel paty zubu",null,null,null,"qf",{"$f":"IF(F32=\"Typ III\",0,ATAN(F66/F57)*180/PI())","v":4.3718735486240563},{"$f":"IF(F32=\"Typ III\",0,ATAN(G66/F57)*180/PI())","v":5.7788832914470776},"[°]"]
["Úhel roztečného kužele",null,null,null,"d",{"$f":"ATAN((SIN(F10/180*PI())/(COS(F10/180*PI())+F27)))*180/PI()","v":38.990994042505477},{"$f":"F10-F77","v":51.009005957494523},"[°]"]
["Úhel hlavového kužele",null,null,null,"da",{"$f":"F77+F75","v":43.929045642180824},{"$f":"G77+G75","v":54.536674905285935},"[°]"]
["Úhel patního kužele",null,null,null,"df",{"$f":"F77-F76","v":34.619120493881418},{"$f":"G77-G76","v":45.230122666047443},"[°]"]
["Normálný střední úhel záběru",null,null,null,"αnm",{"$f":"ATAN(TAN(F81/180*PI())*COS(F82/180*PI()))*180/PI()","v":20},null,"[°]"]
["Čelní úhel záběru",null,null,null,"αt",{"$f":"F8","v":20},null,"[°]"]
["Úhel sklonu",null,null,null,"βm",{"$f":"F9","v":0},null,"[°]"]
["Základní úhel sklonu",null,null,null,"βb",{"$f":"ASIN(SIN(F82/180*PI())*COS(F80/180*PI()))*180/PI()","v":0},null,"[°]"]
["Úhel sklonu zubů na konci",null,null,null,"βe",{"$f":"ASIN(SIN(F82/180*PI())*(F58/F57))*180/PI()","v":0},null,"[°]"]
["Normální rozteč",null,null,null,"pe",{"$f":"PI()*F53","v":9.5199777381508888}]
["Čelní rozteč",null,null,null,"pte",{"$f":"PI()*F55/COS(F82/180*PI())","v":9.5199777381508888}]
["Geometrie ozubení virtuálních a bivirtuálních kol",null,null,null,null,"Pastorek","Kolo"]
["Virtuální převodový poměr",null,null,null,"uv",{"$f":"G$89/F$89","v":1.5259515570934257}]
["Virtuální počet zubů",null,null,null,"zv",{"$f":"IF(F32=\"Typ I\",F6/(COS(F77/180*PI())),F6/(COS(F77/180*PI())*(COS(F82/180*PI()))^3))","v":21.872128901314955},{"$f":"IF(F32=\"Typ I\",F7/(COS(G77/180*PI())),F7/(COS(G77/180*PI())*(COS(F82/180*PI()))^3))","v":33.375809153909671},"[mm]"]
["Roztečný průměr",null,null,null,"dv",{"$f":"IF(F32=\"Typ I\",F64/(COS(F77/180*PI())),F64/(COS(F77/180*PI())*(COS(F82/180*PI()))^2))","v":54.680322253287393},{"$f":"IF(F32=\"Typ I\",G64/(COS(G77/180*PI())),G64/(COS(G77/180*PI())*(COS(F82/180*PI()))^2))","v":83.439522884774178},"[mm]"]
["Základní průměr",null,null,null,"dvb",{"$f":"F90*COS(F8/180*PI())","v":51.38269532360966},{"$f":"G90*COS(F8/180*PI())","v":78.407503936719223},"[mm]"]
["Hlavový průměr",null,null,null,"dva",{"$f":"F90+F65*2*(1-0.5*F13)","v":60.51627270692736},{"$f":"G90+2*G65*(1-0.5*F13)","v":87.603572431134211},"[mm]"]
["Patní průměr",null,null,null,"dvf",{"$f":"F90-F65*2*(1-0.5*F13)","v":48.844371799647426},{"$f":"G90-2*G65*(1-0.5*F13)","v":79.275473338414145},"[mm]"]
["Šířka",null,null,null,"bv",{"$f":"F60/COS(F9/180*PI())","v":14.327998879203646},null,"[mm]"]
["Středová vzdálenost",null,null,null,"av",{"$f":"0.5*(F90+G90)","v":69.059922569030789},null,"[mm]"]
["Síly působící na ozubení",null,null,null,null,"Pastorek","Kolo"]
["Smysl stoupání",null,null,null,null,{"$f":"F12","v":"LEVÝ"}]
["Obvodová síla",null,null,null,"Ft",{"$f":"(2*F26*10^3)/F64","v":1498.0392156862745},null,"[N]"]
["Normálová síla",null,null,null,"FN",{"$f":"F98/(COS(F80/180*PI())*COS(F82/180*PI()))","v":1594.1800356305821},null,"[N]"]
["Radiální síla",null,null,null,"Fr",{"$f":"(F98/COS(F82/180*PI()))*(TAN(F80/180*PI())*COS(F77/180*PI())+(IF(F12=\"LEVÝ\",\"-1\",1)*(SIN(F82/180*PI())*SIN(F77/180*PI()))))","v":423.78630239732593},{"$f":"F101","v":343.06510194069244},"[N]"]
["Axiální síla",null,null,null,"Fa",{"$f":"(F98/COS(F82/180*PI()))*(TAN(F80/180*PI())*SIN(F77/180*PI())+(IF(F12=\"LEVÝ\",\"1\",-1)*(SIN(F82/180*PI())*COS(F77/180*PI()))))","v":343.06510194069244},{"$f":"F100","v":423.78630239732593},"[N]"]
["Koeficienty pro pevnostní výpočty",null,null,null,null,"Pastorek","Kolo"]
["Společné koeficienty"]
["Součinitel:"]
["Vnějších dynamických sil",null,null,null,"KA",1.1000000000000001]
["Vnitřních dynamických sil",null,null,null,"Kv",1]
["Koeficienty pro výpočet na ohyb"]
["Součinitel:"]
["Přídavného zatížení ",null,null,null,"KF",{"$f":"F105*F106*F110*F111","v":1.1000000000000001}]
["Nerovnoměrnosti zatížení zubů po obvodu",null,null,null,"KFα",1]
["Nerovnoměrnosti zatížení podél zubu",null,null,null,"KFβ",1]
["Tvaru zubu",null,null,null,"YFa",2.52,2.8]
["Koncentrace napětí",null,null,null,"YSa",1.76,1.62]
["Vlivu záběru profilem",null,null,null,"Yε",{"$f":"IF(F43=0,0.25+(0.75/F42),IF(AND(F43>0,F43<1),0.25+(0.75/F42)-F43*((0.75/F42)-0.375),0.625))","v":0.71510929893744679}]
["Sklonu zubu",null,null,null,"Yβ",{"$f":"1-MIN(F43,1)*MIN(F82,30)/120","v":1}]
["Charakteru cyklu",null,null,null,"YA",1,1]
["Technologie výroby",null,null,null,"YT",1,1]
["Životnosti",null,null,null,"YN",{"$f":"MIN(MAX(((F22)/(60*F5*F11))^(1/F20),1),2.5)","v":1},{"$f":"MIN(MAX(((G22)/(60*(F5/F27)*F11))^(1/G20),1),2.5)","v":1}]
["Vrubové citlivosti",null,null,null,"Yδ",1.2,1.2]
["Velikosti",null,null,null,"YX",1,1]
["Drsnosti povrchu",null,null,null,"YR",1,1]
["Vlivu kuželového soukolí",null,null,null,"YK",0.8]
["Koeficienty pro výpočet na dotyk"]
["Součinitel:"]
["Přídavného zatížení ",null,null,null,"KH",{"$f":"F105*F106*F126*F127","v":1.1000000000000001}]
["Nerovnoměrnosti zatížení zubů po obvodu",null,null,null,"KHα",{"$f":"F110","v":1}]
["Nerovnoměrnosti zatížení podél zubu",null,null,null,"KHβ",{"$f":"F111","v":1}]
["Mechanických vlastností materiálu",null,null,null,"ZE",{"$f":"(1/(PI()*(((1-F17^2)/F16)+((1-G17^2)/G16))))^(1/2)","v":189.81170043756651},null,"[MPa]^1/2"]
["Délky dotyku",null,null,null,"Zε",{"$f":"IF(F42<1,((4-F42)/3*(1-F43)+F43/F42)^0.5,(1/F42)^0.5)","v":0.78749332182349063}]
["Tvaru spoluzabírajících zubů",null,null,null,"ZH",2.4900000000000002]
["Životnosti",null,null,null,"ZN",{"$f":"MIN(MAX(((F23)/(60*F5*F11))^(1/F21),0.85),1.6)","v":0.85},{"$f":"MIN(MAX(((G23)/(60*(F5/F27)*F11))^(1/F21),0.85),1.6)","v":0.85}]
["Vlivu maziva",null,null,null,"ZL",{"$f":"0.6*(F24)^(1/9)","v":0.92667126296782731}]
["Vlivu jakosti povrchu",null,null,null,"ZR",{"$f":"IF(F15<=6,1,IF(F15=7,0.95,0.9))","v":1}]
["Vlivu obvodové rychlosti",null,null,null,"ZV",0.96]
["Sklonu zubu",null,null,null,"Zβ",{"$f":"(COS(F82/180*PI()))^(1/2)","v":1}]
["Vlivu velikosti",null,null,null,"ZX",1]
["Vlivu kuželového soukolí",null,null,null,"ZK",0.8]
["Pevnostní výpočet ozubení na ohyb",null,null,null,null,"Pastorek","Kolo"]
["Součinitel bezpečnosti v ohybu",null,null,null,"SF",{"$f":"(F18*F116*F117*F118*F119*F120*F121)/(F112*F113*F115*F114*F122*((F109*F98)/(F60*F54)))","v":4.0094048552583956},{"$f":"(F18*G116*G117*G118*G119*G120*G121)/(G112*G113*F115*F114*F122*((F109*F98)/(F60*F54)))","v":3.9203069695859867}]
["Minimální součinitel bezpečnosti v ohybu",null,null,null,"SFmin",1.3,1.3]
["Pevnostní výpočet ozubení na dotyk",null,null,null,null,"Pastorek","Kolo"]
["Součinitel bezpečnosti v dotyku",null,null,null,"SH",{"$f":"(F19*F131*F132*F133*F134*F136)/(F128*F130*F129*F135*F137*(((F98*F125)/(F60*F64))*((F88+1)/F88))^0.5)","v":1.3678821340391027},{"$f":"(G19*G131*F132*F133*F134*F136)/(F128*F130*F129*F135*F137*(((F98*F125)/(F60*F64))*((F88+1)/F88))^0.5)","v":1.3678821340391027}]
["Minimální součinitel bezpečnosti v dotyku",null,null,null,"SHmin",1.1000000000000001,1.1000000000000001]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Typ I"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Typ II"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Typ III"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Tisk","index":1,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,9,12,9],[31,10,31,11],[29,0,29,3],[30,0,30,3],[1,5,1,6],[2,5,2,6],[10,0,10,3],[5,5,5,6],[6,5,6,6],[3,0,3,3],[15,0,15,3],[4,5,4,6],[22,0,22,3],[23,0,23,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[7,5,7,6],[14,0,14,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[12,0,12,3],[11,0,11,3],[13,0,13,3],[9,5,9,6],[8,5,8,6],[63,0,63,3],[64,0,64,3],[42,1,42,2],[32,0,32,8],[34,4,34,5],[33,4,33,5],[34,2,34,3],[33,2,33,3],[42,5,42,6],[60,0,60,3],[61,0,61,3],[62,0,62,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[52,0,52,3],[53,0,53,3],[49,1,49,2],[47,5,47,6],[46,5,46,6],[48,5,48,6],[38,1,38,2],[38,5,38,6],[45,5,45,6],[43,5,43,6],[44,5,44,6],[37,1,37,2],[35,4,35,8],[36,1,36,2],[41,1,41,2],[37,5,37,6],[35,0,35,3],[36,5,36,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[26,5,26,6],[27,0,27,3],[16,0,16,3],[24,0,24,3],[24,5,24,6],[25,5,25,6],[20,0,20,3],[21,0,21,3]]}
["Parametry a geometrie ozubení",null,null,null,null,"Pastorek","Kolo"]
["Typ ozubení",null,null,null,null,{"$f":"Výpočty!F32","v":"TYP I"}]
["Druh ozubení",null,null,null,null,{"$f":"Výpočty!F31","v":"PŘÍMÉ"}]
["Počet zubů pastorku a kola",null,null,null,"z",{"$f":"Výpočty!F6","v":17},{"$f":"Výpočty!F7","v":21}]
["Čelní úhel záběru",null,null,null,"αt",{"$f":"Výpočty!F8","v":20},null,"[°]"]
["Úhel sklonu zubu",null,null,null,"βm",{"$f":"Výpočty!F9","v":0},null,"[°]"]
["Úhel mezi osami",null,null,null,"Σ",{"$f":"Výpočty!F10","v":90},null,"[°]"]
["Kuželová vzdálenost vnější",null,null,null,"Le",{"$f":"Výpočty!F57","v":40.937139654867565},null,"[mm]"]
["Kuželová vzdálenost střední",null,null,null,"Lm",{"$f":"Výpočty!F58","v":33.773140215265741},null,"[mm]"]
["Šířka věnce",null,null,null,"b",{"$f":"Výpočty!F60","v":14.327998879203646},null,"[mm]"]
["Vnější roztečný průměr",null,null,null,"de",{"$f":"Výpočty!F61","v":51.515151515151516},{"$f":"Výpočty!G61","v":63.636363636363633},"[mm]"]
["Vnější průměr hlavové kružnice",null,null,null,"dae",{"$f":"Výpočty!F62","v":57.013287946417805},{"$f":"Výpočty!G62","v":66.812136483218637},"[mm]"]
["Vnější průměr patní kružnice",null,null,null,"dfe",{"$f":"Výpočty!F63","v":46.650023003651334},{"$f":"Výpočty!G63","v":58.422826767645773},"[mm]"]
["Střední roztečný průměr",null,null,null,"dm",{"$f":"Výpočty!F64","v":42.5},{"$f":"Výpočty!G64","v":52.5},"[mm]"]
["Vnější výška zubu",null,null,null,"he",{"$f":"Výpočty!F67","v":6.666666666666667},{"$f":"Výpočty!G67","v":6.666666666666667},"[mm]"]
["Vnější tloušťka zubu ",null,null,null,"se",{"$f":"Výpočty!F71","v":5.1890397354987394},{"$f":"Výpočty!G71","v":4.3309380026521485},"[mm]"]
["Výška hlavového kužele",null,null,null,"A",{"$f":"Výpočty!F74","v":29.592745643621651},{"$f":"Výpočty!G74","v":23.796068999224143},"[mm]"]
["Úhel roztečného kužele",null,null,null,"d",{"$f":"Výpočty!F77","v":38.990994042505477},{"$f":"Výpočty!G77","v":51.009005957494523},"[°]"]
["Úhel hlavového kužele",null,null,null,"da",{"$f":"Výpočty!F78","v":43.929045642180824},{"$f":"Výpočty!G78","v":54.536674905285935},"[°]"]
["Úhel patního kužele",null,null,null,"df",{"$f":"Výpočty!F79","v":34.619120493881418},{"$f":"Výpočty!G79","v":45.230122666047443},"[°]"]
["Virtuální počet zubů",null,null,null,"zv",{"$f":"Výpočty!F89","v":21.872128901314955},{"$f":"Výpočty!G89","v":33.375809153909671}]
["Roztečný průměr",null,null,null,"dv",{"$f":"Výpočty!F90","v":54.680322253287393},{"$f":"Výpočty!G90","v":83.439522884774178},"[mm]"]
["Jednotkové posunutí",null,null,null,"x",{"$f":"Výpočty!F49","v":0.16719009072799371},{"$f":"Výpočty!G49","v":-0.16719009072799371}]
["Jednotková změna tloušťky zubu",null,null,null,"xt",{"$f":"Výpočty!F50","v":1.9882352941176469E-2},{"$f":"Výpočty!G50","v":-1.9882352941176469E-2}]
["Smysl stoupání",null,null,null,null,{"$f":"Výpočty!F97","v":"LEVÝ"}]
["Obvodová síla",null,null,null,"Ft",{"$f":"Výpočty!F98","v":1498.0392156862745},null,"[N]"]
["Normálová síla",null,null,null,"FN",{"$f":"Výpočty!F99","v":1594.1800356305821},null,"[N]"]
["Radiální síla",null,null,null,"Fr",{"$f":"Výpočty!F100","v":423.78630239732593},{"$f":"Výpočty!G100","v":343.06510194069244},"[N]"]
["Axiální síla",null,null,null,"Fa",{"$f":"Výpočty!F101","v":343.06510194069244},{"$f":"Výpočty!G101","v":423.78630239732593},"[N]"]
["Součinitel bezpečnosti v ohybu",null,null,null,"SF",{"$f":"Výpočty!F139","v":4.0094048552583956},{"$f":"Výpočty!G139","v":3.9203069695859867}]
["Součinitel bezpečnosti v dotyku",null,null,null,"SH",{"$f":"Výpočty!F142","v":1.3678821340391027},{"$f":"Výpočty!G142","v":1.3678821340391027}]
["Koeficienty pro pevnostní výpočty"]
["SPOLEČNÉ PRO OHYB I DOTYK"]
[null,null,"KA",null,{"$f":"Výpočty!F105","v":1.1000000000000001}]
[null,null,"Kv",null,{"$f":"Výpočty!F106","v":1}]
["PRO OHYB",null,null,null,"PRO DOTYK"]
["KF",{"$f":"Výpočty!F109","v":1.1000000000000001},null,null,"KH",{"$f":"Výpočty!F125","v":1.1000000000000001}]
["KFα",{"$f":"Výpočty!F110","v":1},null,null,"KHα",{"$f":"Výpočty!F126","v":1}]
["KFβ",{"$f":"Výpočty!F111","v":1},null,null,"KHβ",{"$f":"Výpočty!F127","v":1}]
["YFa",{"$f":"Výpočty!F112","v":2.52},{"$f":"Výpočty!G112","v":2.8},null,"ZE",{"$f":"Výpočty!F128","v":189.81170043756651},null,"[MPa]^1/2"]
["YSa",{"$f":"Výpočty!F113","v":1.76},{"$f":"Výpočty!G113","v":1.62},null,"Zε",{"$f":"Výpočty!F129","v":0.78749332182349063}]
["Yε",{"$f":"Výpočty!F114","v":0.71510929893744679},null,null,"ZH",{"$f":"Výpočty!F130","v":2.4900000000000002}]
["Yβ",{"$f":"Výpočty!F115","v":1},null,null,"ZN",{"$f":"Výpočty!F131","v":0.85}]
["YA",{"$f":"Výpočty!F116","v":1},{"$f":"Výpočty!G116","v":1},null,"ZL",{"$f":"Výpočty!F132","v":0.92667126296782731}]
["YT",{"$f":"Výpočty!F117","v":1},{"$f":"Výpočty!G117","v":1},null,"ZR",{"$f":"Výpočty!F133","v":1}]
["YN",{"$f":"Výpočty!F118","v":1},{"$f":"Výpočty!G118","v":1},null,"ZV",{"$f":"Výpočty!F134","v":0.96}]
["Yδ",{"$f":"Výpočty!F119","v":1.2},{"$f":"Výpočty!G119","v":1.2},null,"Zβ",{"$f":"Výpočty!F135","v":1}]
["YX",{"$f":"Výpočty!F120","v":1},{"$f":"Výpočty!G120","v":1},null,"ZX",{"$f":"Výpočty!F136","v":1}]
["YR",{"$f":"Výpočty!F121","v":1},{"$f":"Výpočty!G121","v":1},null,"ZK",{"$f":"Výpočty!F137","v":0.8}]
["YK",{"$f":"Výpočty!F122","v":0.8}]

{"sheet":"Tabulky","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,0,1,1]]}
["Tabulka normalizovaných modulů (ČSN 01 4608)",null,null,"Pomocné veličiny pro stanovení obvodového posunutí"]
[null,null,null,null,"0°-15°","15°-29","29°-40°","40° a větší"]
[null,0.05,null,"a",0.03,7.0000000000000007E-2,0.11,0.15]
[null,0.06,null,"b",8.0000000000000002E-3,0.01,0.01,1.2E-2]
[null,0.08]
[null,0.1,null,"Úhel 𝛽𝑚",{"$f":"Výpočty!F9","v":0},"[°]"]
[null,0.12,null,"a",{"$f":"IF(Výpočty!F$9<15,Tabulky!E3,IF(AND(Výpočty!F$9>=15,Výpočty!F$9<=29),Tabulky!F3,IF(AND(Výpočty!F$9>29,Výpočty!F$9<=40),Tabulky!G3,IF(Výpočty!F$9>40,Tabulky!H3))))","v":0.03}]
[null,0.15,null,"b",{"$f":"IF(E$6<15,E4,IF(AND(E$6>=15,E$6<=29),F4,IF(AND(E$6>29,E$6<=40),G4,IF(E$6>40,H4))))","v":8.0000000000000002E-3}]
[null,0.2]
[null,0.25,null,"αt",null,"βm",null,"Smysl"]
[null,0.3,null,14.5,null,0,null,"PRAVÝ"]
[null,0.4,null,15,null,20,null,"LEVÝ"]
[null,0.5,null,17.5,null,25]
[null,0.6,null,20,null,30,null,"Ozubení"]
[null,0.8,null,22,null,35,null,"PŘÍMÉ"]
[null,1,null,22.5,null,40,null,"ŠIKMÉ"]
[null,1.25,null,25,null,45,null,"ZAKŘIVENÉ"]
[null,1.5]
[null,2,null,"Typ I"]
[null,2.5,null,"TYP I"]
[null,3,null,"TYP II"]
[null,4,null,"TYP III"]
[null,5]
[null,6]
[null,8]
[null,10]
[null,12]
[null,16]
[null,20]
[null,25]
[null,32]
[null,40]
[null,50]
[null,60]
[null,80]
[null,100]