{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vstupy","Materiály","Ložiská ","Výstupy","Výpočty","Výpočty 2"," Výpočty 3"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":4,"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":"Vstupy","index":0,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[22,8,22,11],[23,8,23,11],[23,13,23,16],[30,3,30,6],[31,3,31,6],[30,8,30,11],[31,8,31,11],[30,13,30,16],[31,13,31,16],[23,3,23,6],[50,0,50,1],[51,0,51,1],[52,0,52,1],[19,10,19,11],[18,13,18,14],[20,3,20,6],[21,3,21,6],[22,3,22,6],[20,13,20,16],[21,13,21,16],[22,13,22,16],[18,3,18,4],[19,3,19,4],[18,8,18,9],[20,8,20,11],[21,8,21,11],[44,0,44,1],[45,0,45,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[46,0,46,1],[28,0,28,1],[19,0,19,1],[30,0,30,1],[32,0,32,1],[33,0,33,1],[31,0,31,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[2,3,3,6],[2,8,3,11],[2,13,3,16],[0,5,1,14],[20,0,20,1],[0,0,3,0],[50,14,50,16],[51,14,51,16],[52,14,52,16],[40,13,40,14],[41,13,41,14],[42,13,42,14],[43,13,43,14],[44,13,44,14],[50,4,50,6],[51,4,51,6],[52,4,52,6],[50,9,50,11],[51,9,51,11],[52,9,52,11],[29,15,29,16],[45,3,45,4],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,13,45,14],[29,0,29,1],[29,3,29,6],[29,8,29,9],[29,10,29,11],[29,13,29,14],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1]]}
["Vstupné Parametre",null,null,null,null,"Výstupy"]
[]
[null,null,null,"1 stupňová převodovka",null,null,null,null,"2. stupňová převodovka",null,null,null,null,"2. stupňová koaxiálni převodovka"]
[]
["Maximálny výkon P [W]",90]
["Výstupné otáčky  nvystup [ min -1]",1000]
["Maximálne otáčky elektromotoru  nvstup [ min -1]",6000]
["Normalizovaný modul prvního soukolí mn12  [mm]",1.5]
["Normalizovaný modul druhého soukolí mn34  [mm]",2.5]
["Celková osová vzdálenost a",255]
["Osová vzdálenost prvního soukolí a12",120]
["úhel sklonu zubu β12                            ",12]
["úhel sklonu zubu β34                           ",10]
["poměrná šířka ozubení ψ12                                   ",19]
["poměrná šířka ozubení ψ34                                   ",19]
["provozní součinitel KH",2]
[]
[]
[null,null,null,"Min. počet zubů",null,null,null,null,"Min. počet zubů",null,null,null,null,"Min. počet zubů"]
["Realizovatelnost",null,null,{"$f":"IF(Výpočty!F3>17,\"Splněno\",\"Nesplněno \")","v":"Splněno"},null,null,null,null,{"$f":"IF('Výpočty 2'!F5>17,\"Splněno\",\"Nesplněno \")","v":"Splněno"},{"$f":"IF('Výpočty 2'!F7>17,\"Splněno\",\"Nesplněno \")","v":"Splněno"},{"$f":"IF(('Výpočty 2'!G18)/2>'Výpočty 2'!E22,\"Kolize hřídele a kola 2\",\" \")","v":" "},null,null,{"$f":"IF(' Výpočty 3'!F5>17,\"Splněno\",\"Nesplněno \")","v":"Splněno"},{"$f":"IF(' Výpočty 3'!F7>17,\"Splněno\",\"Nesplněno \")","v":"Splněno"}]
["Upravené výstupné otáčky nuvyst   [min -1]",null,null,{"$f":"Výpočty!J8","v":1010.5263157894736},null,null,null,null,{"$f":"'Výpočty 2'!K11","v":986.62526868879854},null,null,null,null,{"$f":"' Výpočty 3'!K11","v":989.75741239892182}]
["Krouticí moment na vstup. hřídeli Mk1 [N.m]",null,null,{"$f":"Výpočty!E6/1000","v":143.23944878270581},null,null,null,null,{"$f":"'Výpočty 2'!E10/1000","v":143.23944878270581},null,null,null,null,{"$f":"' Výpočty 3'!E10/1000","v":143.23944878270581}]
["Krouticí moment na předlohovém hřídeli Mk2 [N.m]",null,null,"-",null,null,null,null,{"$f":"'Výpočty 2'!E11/1000","v":291.75909685387222},null,null,null,null,{"$f":"'Výpočty 2'!E11/1000","v":291.75909685387222}]
["Krouticí moment na výstup. hřídeli Mk3 [N.m]",null,null,{"$f":"Výpočty!E7/1000","v":833.4745426043695},null,null,null,null,{"$f":"'Výpočty 2'!E12/1000","v":836.59219549728846},null,null,null,null,{"$f":"' Výpočty 3'!E12/1000","v":833.94475184065141}]
["Hlavné Rozmery",null,null,"Pastorek 1","Kolo 2","Pastorek 3","Kolo4",null,"Pastorek 1","Kolo 2","Pastorek 3","Kolo4",null,"Pastorek 1","Kolo 2","Pastorek 3","Kolo4"]
["Šířka kola bw [mm]",null,null,{"$f":"Výpočty!D11","v":29},{"$f":"Výpočty!H11","v":30},"-","-",null,{"$f":"'Výpočty 2'!E16","v":29},{"$f":"'Výpočty 2'!G16","v":30},{"$f":"'Výpočty 2'!I16","v":48},{"$f":"'Výpočty 2'!K16","v":50},null,{"$f":"' Výpočty 3'!E16","v":29},{"$f":"' Výpočty 3'!G16","v":30},{"$f":"' Výpočty 3'!I16","v":48},{"$f":"' Výpočty 3'!K16","v":50}]
["Průměr roztečnej kružnice d [mm]",null,null,{"$f":"Výpočty!D12","v":73.608522830282098},{"$f":"Výpočty!F12","v":437.0506043048},"-","-",null,{"$f":"'Výpočty 2'!E17","v":78.209055507174739},{"$f":"'Výpočty 2'!G17","v":162.55215458353965},{"$f":"'Výpočty 2'!I17","v":68.54129630228779},{"$f":"'Výpočty 2'!K17","v":200.54675584743464},null,{"$f":"' Výpočty 3'!E17","v":78.209055507174739},{"$f":"' Výpočty 3'!G17","v":162.55215458353965},{"$f":"' Výpočty 3'!I17","v":60.925596713144699},{"$f":"' Výpočty 3'!K17","v":177.69965708000538}]
["Hlavový průměr  da [mm]",null,null,{"$f":"Výpočty!D20","v":76.521614199249314},{"$f":"Výpočty!F20","v":440.0506043048},"-","-",null,{"$f":"'Výpočty 2'!E18","v":81.109378676577293},{"$f":"'Výpočty 2'!G18","v":165.55215458353965},{"$f":"'Výpočty 2'!I18","v":73.663587556607382},{"$f":"'Výpočty 2'!K18","v":205.54675584743464},null,{"$f":"' Výpočty 3'!E18","v":81.109378676577293},{"$f":"' Výpočty 3'!G18","v":165.55215458353965},{"$f":"' Výpočty 3'!I18","v":66.111482224475068},{"$f":"' Výpočty 3'!K18","v":182.69965708000538}]
["Patní průměr  df [mm]",null,null,{"$f":"Výpočty!D21","v":69.771614199249314},{"$f":"Výpočty!F21","v":433.21369567376723},"-","-",null,{"$f":"'Výpočty 2'!E19","v":74.359378676577293},{"$f":"'Výpočty 2'!G19","v":158.80215458353965},{"$f":"'Výpočty 2'!I19","v":62.413587556607382},{"$f":"'Výpočty 2'!K19","v":194.29675584743464},null,{"$f":"' Výpočty 3'!E19","v":74.359378676577293},{"$f":"' Výpočty 3'!G19","v":158.80215458353965},{"$f":"' Výpočty 3'!I19","v":54.861482224475068},{"$f":"' Výpočty 3'!K19","v":171.44965708000538}]
["součinitel záběru profilu εα",null,null,{"$f":"Výpočty!D26","v":1.9392077248075368},null,null,null,null,{"$f":"'Výpočty 2'!E32","v":1.8621655325022828},null,{"$f":"'Výpočty 2'!I32","v":1.4827068992155734},null,null,{"$f":"' Výpočty 3'!E32","v":1.8621655325022828},null,{"$f":"' Výpočty 3'!I32","v":1.3992211118304745}]
["Celková délka převodovky x [mm]",null,null,{"$f":"Výpočty!D13+Výpočty!D20/2+Výpočty!F20/2","v":513.6156728195657},null,null,null,null,{"$f":"'Výpočty 2'!E21+'Výpočty 2'!E22+'Výpočty 2'!E18/2+'Výpočty 2'!K18/2","v":398.25269838222437},null,null,null,null,{"$f":"' Výpočty 3'!E21+' Výpočty 3'!G18/2+' Výpočty 3'!K18/2","v":294.5065108771297}]
["Celková šířka převodovky y [mm]",null,null,{"$f":"Výpočty!D39+Výpočty!D40+Výpočty!D55/2+Výpočty!D56/2","v":105},null,null,null,null,{"$f":"'Výpočty 2'!E46+'Výpočty 2'!E47+'Výpočty 2'!E48+'Výpočty 2'!D58/2+'Výpočty 2'!D59/2","v":171.5},null,null,null,null,{"$f":"' Výpočty 3'!E46+' Výpočty 3'!E47+' Výpočty 3'!E48+' Výpočty 3'!D58/2+' Výpočty 3'!D59/2","v":261}]
["Počty dilů",null,null,"vnějši ф","délka l","hmotnost","cena [kč]",null,"vnějši ф","délka l","hmotnost","cena [kč]",null,"vnějši ф","délka l","hmotnost","cena [kč]"]
["Vstupný hřídel",null,null,{"$f":"Výpočty!F35","v":29},{"$f":"Výpočty!D60","v":163},{"$f":"(PI()*(D34/2000)^2*(E34/1000)*7850)","v":0.84516818099914748},{"$f":"3254+F34*2.16*1000","v":5079.5632709581587},null,{"$f":"'Výpočty 2'!G41","v":29},{"$f":"I32+'Výpočty 2'!D56/2+'Výpočty 2'!D57/2+2*'Výpočty 2'!G41+3","v":255.5},{"$f":"(PI()*(I34/2000)^2*(J34/1000)*7850)","v":1.3247881610140011},{"$f":"3254+K34*2.16*1000","v":6115.5424277902421},null,{"$f":"' Výpočty 3'!G41","v":29},{"$f":"' Výpočty 3'!B46+' Výpočty 3'!B47+' Výpočty 3'!D56/2+' Výpočty 3'!D57/2+5+2*' Výpočty 3'!G41","v":168},{"$f":"(PI()*(N34/2000)^2*(O34/1000)*7850)","v":0.87109358532427483},{"$f":"3254+P34*2.16*1000","v":5135.5621443004338}]
["Předlohový hřídel                                                  ",null,null,"-","-","-","-",null,{"$f":"'Výpočty 2'!G42","v":37},{"$f":"'Výpočty 2'!E46+'Výpočty 2'!E47+'Výpočty 2'!E48+'Výpočty 2'!D58/2+'Výpočty 2'!D59/2+5","v":176.5},{"$f":"(PI()*(I35/2000)^2*(J35/1000)*7850)","v":1.4897304539771703},{"$f":"9057+K35*0.965*1000","v":10494.589888087969},null,{"$f":"' Výpočty 3'!G42","v":37},{"$f":"' Výpočty 3'!E46+' Výpočty 3'!E47+' Výpočty 3'!E48+' Výpočty 3'!D58/2+' Výpočty 3'!D59/2+5","v":266},{"$f":"(PI()*(N35/2000)^2*(O35/1000)*7850)","v":2.2451461799315999},{"$f":"9057+P35*0.965*1000","v":11223.566063633994}]
["Výstupný hřídel                                                 ",null,null,{"$f":"Výpočty!F36","v":53},{"$f":"Výpočty!D47+Výpočty!D48+Výpočty!D57/2+Výpočty!D58/2+2*Výpočty!F36","v":221},{"$f":"(PI()*(D36/2000)^2*(E36/1000)*7850)","v":3.8273973425901069},{"$f":"6764+F36*0.262*1000","v":7766.7781037586083},null,{"$f":"'Výpočty 2'!G43","v":53},{"$f":"'Výpočty 2'!H46+'Výpočty 2'!H47+'Výpočty 2'!D60/2+'Výpočty 2'!D61/2+'Výpočty 2'!G43*2","v":274.5},{"$f":"(PI()*(I36/2000)^2*(J36/1000)*7850)","v":4.7539392332171246},{"$f":"6764+K36*0.262*1000","v":8009.5320791028862},null,{"$f":"' Výpočty 3'!G43","v":53},{"$f":"' Výpočty 3'!H46+' Výpočty 3'!H47+' Výpočty 3'!D60/2+' Výpočty 3'!D61/2+2*' Výpočty 3'!G43","v":239},{"$f":"(PI()*(N36/2000)^2*(O36/1000)*7850)","v":4.1391310628010665},{"$f":"6764+P36*0.262*1000","v":7848.4523384538797}]
["Pastorek 1        (roztečný průměr, šířka, hmotnost)                     ",null,null,{"$f":"D27","v":73.608522830282098},{"$f":"Výpočty!D11","v":29},{"$f":"Výpočty!G62","v":0.81838717275899919},{"$f":"3167+F37*1.886*1000","v":4710.4782078234721},null,{"$f":"I27","v":78.209055507174739},{"$f":"'Výpočty 2'!E16","v":29},{"$f":"((((PI()*(I27/1000)^2)/4)*(I26/1000))-(((PI()*(I34/1000)^2)/4)*(I26/1000)))*7850","v":0.94326568482492235},{"$f":"3167+K37*1.886*1000","v":4945.9990815798028},null,{"$f":"N27","v":78.209055507174739},{"$f":"' Výpočty 3'!E16","v":29},{"$f":"((((PI()*(N27/1000)^2)/4)*(N26/1000))-(((PI()*(N34/1000)^2)/4)*(N26/1000)))*7850","v":0.94326568482492235},{"$f":"3167+P37*1.886*1000","v":4945.9990815798028}]
["Kolo 2              ( roztečný průměr, šířka, hmotnost)                 ",null,null,{"$f":"E27","v":437.0506043048},{"$f":"Výpočty!H11","v":30},{"$f":"((((PI()*(E27/1000)^2)/4)*(E26/1000))-(((PI()*(D36/1000)^2)/4)*(E26/1000)))*7850","v":34.810493059678386},{"$f":"7593+F38*0.23*1000","v":15599.41340372603},null,{"$f":"J27","v":162.55215458353965},{"$f":"'Výpočty 2'!G16","v":30},{"$f":"((((PI()*(J27/1000)^2)/4)*(J26/1000))-(((PI()*(I35/1000)^2)/4)*(J26/1000)))*7850","v":4.634057135139189},{"$f":"7593+K38*0.304*1000","v":9001.7533690823129},null,{"$f":"O27","v":162.55215458353965},{"$f":"' Výpočty 3'!G16","v":30},{"$f":"((((PI()*(O27/1000)^2)/4)*(O26/1000))-(((PI()*(N35/1000)^2)/4)*(O26/1000)))*7850","v":4.634057135139189},{"$f":"7593+P38*0.304*1000","v":9001.7533690823129}]
["Pastorek 3        (roztečný průměr, šířka, hmotnost)                      ",null,null,"-","-","-","-",null,{"$f":"K27","v":68.54129630228779},{"$f":"'Výpočty 2'!I16","v":48},{"$f":"((((PI()*(K27/1000)^2)/4)*(K26/1000))-(((PI()*(I35/1000)^2)/4)*(K26/1000)))*7850","v":0.98515085317114848},{"$f":"4782+K39*0.54*1000","v":5313.9814607124199},null,{"$f":"P27","v":60.925596713144699},{"$f":"' Výpočty 3'!I16","v":48},{"$f":"((((PI()*(P27/1000)^2)/4)*(P26/1000))-(((PI()*(N35/1000)^2)/4)*(P26/1000)))*7850","v":0.69336159108704376},{"$f":"4782+P39*0.54*1000","v":5156.4152591870034}]
["Kolo 4              (roztečný průměr, šířka, hmotnost)                    ",null,null,"-","-","-","-",null,{"$f":"L27","v":200.54675584743464},{"$f":"'Výpočty 2'!K16","v":50},{"$f":"((((PI()*(L27/1000)^2)/4)*(L26/1000))-(((PI()*(I36/1000)^2)/4)*(L26/1000)))*7850","v":11.53233542225508},{"$f":"7100+K40*0.39*1000","v":11597.610814679481},null,{"$f":"Q27","v":177.69965708000538},{"$f":"' Výpočty 3'!K16","v":50},{"$f":"((((PI()*(Q27/1000)^2)/4)*(Q26/1000))-(((PI()*(N36/1000)^2)/4)*(Q26/1000)))*7850","v":8.8683280662176021},{"$f":"7100+P40*0.39*1000","v":10558.647945824865}]
["ložisko A",null,null,{"$f":"'Ložiská '!M6","v":"NU406"},null,{"$f":"'Ložiská '!R6","v":0.75},{"$f":"'Ložiská '!N6","v":3927},null,{"$f":"'Ložiská '!T6","v":"NU406"},null,{"$f":"'Ložiská '!Y6","v":0.75},{"$f":"'Ložiská '!U6","v":3927},null,{"$f":"'Ložiská '!AA6","v":"NU406"},null,{"$f":"'Ložiská '!AF6","v":0.75},{"$f":"'Ložiská '!AB6","v":3927}]
["ložisko B",null,null,{"$f":"'Ložiská '!M7","v":6406},null,{"$f":"'Ložiská '!R7","v":0.75},{"$f":"'Ložiská '!N7","v":808},null,{"$f":"'Ložiská '!T7","v":6406},null,{"$f":"'Ložiská '!Y7","v":0.75},{"$f":"'Ložiská '!U7","v":808},null,{"$f":"'Ložiská '!AA7","v":6406},null,{"$f":"'Ložiská '!AF7","v":0.75},{"$f":"'Ložiská '!AB7","v":808}]
["ložisko C",null,null,"-",null,"-",null,null,{"$f":"'Ložiská '!T11","v":6408},null,{"$f":"'Ložiská '!Y11","v":1.26},{"$f":"'Ložiská '!U11","v":1207},null,{"$f":"'Ložiská '!AA11","v":6408},null,{"$f":"'Ložiská '!AF11","v":1.26},{"$f":"'Ložiská '!AB11","v":1207}]
["ložisko D",null,null,"-",null,"-",null,null,{"$f":"'Ložiská '!T12","v":"NJ2308"},null,{"$f":"'Ložiská '!Y12","v":0.95},{"$f":"'Ložiská '!U12","v":1759},null,{"$f":"'Ložiská '!AA12","v":"NJ2308"},null,{"$f":"'Ložiská '!AF12","v":0.95},{"$f":"'Ložiská '!AB12","v":1759}]
["ložisko E",null,null,{"$f":"'Ložiská '!M16","v":6411},null,{"$f":"'Ložiská '!R16","v":2.4},{"$f":"'Ložiská '!N16","v":2061},null,{"$f":"'Ložiská '!T16","v":"NU211"},null,{"$f":"'Ložiská '!Y16","v":1.45},{"$f":"'Ložiská '!U16","v":1471},null,{"$f":"'Ložiská '!AA16","v":6411},null,{"$f":"'Ložiská '!AF16","v":2.4},{"$f":"'Ložiská '!AB16","v":2061}]
["ložisko F",null,null,{"$f":"'Ložiská '!M17","v":"NU411"},null,{"$f":"'Ložiská '!R17","v":2.5},{"$f":"'Ložiská '!N17","v":5549},null,{"$f":"'Ložiská '!T17","v":6411},null,{"$f":"'Ložiská '!Y17","v":2.4},{"$f":"'Ložiská '!U17","v":2061},null,{"$f":"'Ložiská '!AA17","v":"NU211"},null,{"$f":"'Ložiská '!AF17","v":1.45},{"$f":"'Ložiská '!AB17","v":1471}]
[null,null,null,null,null,null,{"$f":"SUM(G34:G46)","v":45501.232986266274},null,null,null,null,{"$f":"SUM(L34:L46)","v":66712.009121035109},null,null,null,null,{"$f":"SUM(Q34:Q46)","v":65103.396202062286}]
["Bezpečnosti",null,null,"1. Soukolí",null,"2. Soukolí",null,null,"1. Soukolí",null,"2. Soukolí",null,null,"1. Soukolí",null,"2. Soukolí"]
["Součinitel bezpečnosti v dotyku SH",null,null,{"$f":"Výpočty!E83","v":2.0129296281435023},null,"-",null,null,{"$f":"'Výpočty 2'!E91","v":2.0479605249213431},null,{"$f":"'Výpočty 2'!J91","v":1.4970026021086149},null,null,{"$f":"' Výpočty 3'!E91","v":2.0479605249213431},null,{"$f":"' Výpočty 3'!J91","v":1.3164371673203301},null,null,null,null,null,null,"pod výstup - hlavné rozmery, realizovatelnost, váha, axiálna sila"]
["Součinitel Bezpečnosti v ohybe SF",null,null,{"$f":"Výpočty!M71","v":1.7879888743261991},null,"-",null,null,{"$f":"'Výpočty 2'!N81","v":2.5036928963356559},null,{"$f":"'Výpočty 2'!S81","v":2.6655231986370898},null,null,{"$f":"' Výpočty 3'!N81","v":2.6968152134083789},null,{"$f":"' Výpočty 3'!S81","v":2.1950090114821488}]
["Statická kontrola  vstupního hřídele  σred1",null,null,{"$f":"Výpočty!C93","v":70.999599688361684},{"$f":"IF(D51>80,\"Nutno zvětšit průměr hřídele 1\",\" \")","v":" "},null,null,null,{"$f":"'Výpočty 2'!C70","v":65.300054765591923},{"$f":"IF(I51>80,\"Nutno zvětšit průměr hřídele1\",\" \")","v":" "},null,null,null,{"$f":"' Výpočty 3'!C70","v":63.56077759673493},{"$f":"IF(N51>80,\"Nutno zvětšit průměr hřídele 1\",\" \")","v":" "}]
["Statická kontrola předlohového hřídele  σred2",null,null,"-",null,null,null,null,{"$f":"'Výpočty 2'!H70","v":88.965277695289302},{"$f":"IF(I52>80,\"Nutno zvětšit průměr hřídele 2\",\" \")","v":"Nutno zvětšit průměr hřídele 2"},null,null,null,{"$f":"' Výpočty 3'!H70","v":101.73697272181379},{"$f":"IF(N52>80,\"Nutno zvětšit průměr hřídele 2\",\" \")","v":"Nutno zvětšit průměr hřídele 2"}]
["Statická kontrola výstupního hřídele σred3",null,null,{"$f":"Výpočty!H93","v":64.891425787421426},{"$f":"IF(D53>80,\"Nutno zvětšit průměr hřídele 3\",\" \")","v":" "},null,null,null,{"$f":"'Výpočty 2'!M70","v":61.137928230688907},{"$f":"IF(I53>80,\"Nutno zvětšit průměr hřídele 3\",\" \")","v":" "},null,null,null,{"$f":"' Výpočty 3'!M70","v":60.550300696519336},{"$f":"IF(N53>80,\"Nutno zvětšit průměr hřídele 3\",\" \")","v":" "}]

{"sheet":"Materiály","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[13,0,13,1],[0,0,1,1],[3,0,3,1],[4,0,4,1],[9,0,9,1],[11,0,11,1],[5,0,5,1]]}
["Materiály"]
[]
["Ozubené kola",null,"σFlim","σHlim"]
[12051,null,390,1140]
[15241,null,740,1288]
[16526,null,740,1330]

{"sheet":"Ložiská ","index":2,"n_rows":77,"n_cols":32,"rows_kept":77,"cut":false,"hidden":false,"merged":[[41,7,42,7],[60,7,61,7],[18,8,18,9],[19,8,19,9],[17,0,17,1],[18,0,18,1],[19,0,19,1],[15,8,15,9],[16,8,16,9],[17,8,17,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[12,8,12,9],[14,8,14,9],[13,8,13,9],[9,8,9,9],[0,0,1,2],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[10,8,10,9],[11,8,11,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[4,0,5,1],[4,2,4,4],[4,5,4,6],[4,8,5,9],[4,7,5,7],[25,8,25,9],[26,0,26,1],[26,8,26,9],[27,0,27,1],[27,8,27,9],[22,0,23,1],[22,2,22,4],[22,5,22,6],[22,8,23,9],[24,0,24,1],[24,8,24,9],[22,7,23,7],[37,0,37,1],[37,8,37,9],[38,0,38,1],[38,8,38,9],[20,11,24,12],[34,0,34,1],[34,8,34,9],[35,0,35,1],[35,8,35,9],[36,0,36,1],[36,8,36,9],[31,0,31,1],[31,8,31,9],[32,0,32,1],[32,8,32,9],[33,0,33,1],[33,8,33,9],[28,0,28,1],[28,8,28,9],[29,0,29,1],[29,8,29,9],[30,0,30,1],[30,8,30,9],[25,0,25,1],[43,0,43,1],[43,8,43,9],[44,0,44,1],[44,8,44,9],[45,0,45,1],[45,8,45,9],[19,24,19,25],[41,0,42,1],[41,2,41,4],[41,5,41,6],[41,8,42,9],[20,18,24,19],[20,20,24,21],[28,11,32,12],[36,11,40,12],[24,22,24,23],[24,24,24,25],[24,14,24,15],[24,16,24,17],[32,14,32,15],[32,16,32,17],[32,18,32,19],[19,14,19,15],[19,16,19,17],[49,0,49,1],[49,8,49,9],[50,0,50,1],[50,8,50,9],[51,0,51,1],[51,8,51,9],[46,0,46,1],[46,8,46,9],[47,0,47,1],[47,8,47,9],[48,0,48,1],[48,8,48,9],[55,0,55,1],[55,8,55,9],[56,0,56,1],[56,8,56,9],[57,0,57,1],[57,8,57,9],[52,0,52,1],[52,8,52,9],[53,0,53,1],[53,8,53,9],[54,0,54,1],[54,8,54,9],[0,11,2,17],[0,18,2,24],[0,25,2,31],[3,29,3,30],[32,20,32,21],[32,22,32,23],[32,24,32,25],[40,14,40,15],[40,16,40,17],[40,18,40,19],[40,20,40,21],[40,22,40,23],[40,24,40,25],[19,18,19,19],[19,20,19,21],[19,22,19,23],[3,11,3,13],[3,18,3,20],[3,25,3,27],[13,11,13,13],[13,18,13,20],[13,25,13,27],[8,25,8,27],[3,22,3,23],[3,15,3,16],[13,15,13,16],[8,22,8,23],[13,22,13,23],[8,29,8,30],[13,29,13,30],[25,14,25,15],[25,16,25,17],[25,22,25,23],[25,24,25,25],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[33,24,33,25],[70,0,70,1],[70,8,70,9],[71,0,71,1],[71,8,71,9],[72,0,72,1],[72,8,72,9],[76,0,76,1],[76,8,76,9],[73,0,73,1],[73,8,73,9],[74,0,74,1],[74,8,74,9],[75,0,75,1],[75,8,75,9],[42,20,43,21],[42,22,43,23],[41,24,41,25],[26,14,27,15],[26,16,27,17],[26,22,27,23],[26,24,27,25],[34,14,35,15],[34,16,35,17],[34,18,35,19],[34,20,35,21],[34,22,35,23],[34,24,35,25],[41,14,41,15],[41,16,41,17],[41,18,41,19],[41,20,41,21],[41,22,41,23],[67,0,67,1],[67,8,67,9],[68,0,68,1],[68,8,68,9],[69,0,69,1],[69,8,69,9],[64,0,64,1],[64,8,64,9],[65,0,65,1],[65,8,65,9],[66,0,66,1],[66,8,66,9],[62,0,62,1],[63,0,63,1],[62,8,62,9],[63,8,63,9],[17,23,17,24],[25,18,27,19],[25,20,27,21],[25,12,25,13],[25,11,27,11],[26,12,27,13],[33,12,33,13],[33,11,35,11],[34,12,35,13],[41,12,41,13],[41,11,43,11],[42,12,43,13],[42,24,43,25],[60,0,61,1],[60,2,60,4],[60,5,60,6],[60,8,61,9],[42,14,43,15],[42,16,43,17],[42,18,43,19]]}
["Ložiska ",null,null,null,null,null,null,null,null,null,null,"1 stupňová převodovka",null,null,null,null,null,null,"2 stupňová převodovka",null,null,null,null,null,null,"2 stupňová koaxiálna převodovka"]
[]
[]
["Válečkové ložisko  SKF NU4",null,null,null,null,null,null,null,null,null,null,"Vstupný hřídel",null,null,"průměr",{"$f":"Výpočty!F35","v":29},null,"mm","Vstupný hřídel",null,null,"průměr",{"$f":"'Výpočty 2'!G41","v":29},null,"mm","Vstupný hřídel",null,null,"průměr",{"$f":"' Výpočty 3'!G41","v":29},null,"mm"]
["Označení ložiska",null,"Rozmery",null,null,"Únosnost",null,"cena [kč]","m [kg]",null,null,null,"typ","cena","D","B","C","m",null,"typ","cena","D","B","C","m",null,"typ","cena","D","B","C","m"]
[null,null,"d","D","B","C","Co",null,null,null,null,"Ložisko A","NU406",3927,90,23,52000,0.75,"Ložisko A","NU406",3927,90,23,52000,0.75,"Ložisko A","NU406",3927,90,23,52000,0.75]
["NU406",null,30,90,23,52000,31000,3927,0.75,null,null,"Ložisko B",6406,808,90,23,43600,0.75,"Ložisko B",6406,808,90,23,43600,0.75,"Ložisko B",6406,808,90,23,43600,0.75]
["NU407",null,35,100,25,64000,40000,4085,1]
["NU408",null,40,110,27,80000,50000,4678,1.3,null,null,null,null,null,null,null,null,null,"Predlohový hřídel",null,null,"průměr",{"$f":"'Výpočty 2'!G42","v":37},null,"mm","Predlohový hřídel",null,null,"průměr",{"$f":"' Výpočty 3'!G42","v":37},null,"mm"]
["NU409",null,45,120,29,90000,57000,4987,1.65,null,null,null,null,null,null,null,null,null,null,"typ","cena","D","B","C","m",null,"typ","cena","D","B","C","m"]
["NU410",null,50,130,31,96500,72000,4990,2,null,null,null,null,null,null,null,null,null,"Ložisko C",6408,1207,110,27,6370,1.26,"Ložisko C",6408,1207,110,27,6370,1.26]
["NU411",null,55,140,33,120000,78000,5549,2.5,null,null,null,null,null,null,null,null,null,"Ložisko D","NJ2308",1759,90,33,129000,0.95,"Ložisko D","NJ2308",1759,90,33,129000,0.95]
["NU412",null,60,150,35,143000,98000,7698,3]
["NU413",null,65,160,37,156000,108000,8561,3.6,null,null,"Výstupný hřídel",null,null,"průměr",{"$f":"Výpočty!F36","v":53},null,"mm","Výstupný hřídel",null,null,"průměr",{"$f":"'Výpočty 2'!G43","v":53},null,"mm","Výstupný hřídel",null,null,"průměr",{"$f":"' Výpočty 3'!G43","v":53},null,"mm"]
["NU414",null,70,170,42,193000,134000,8829,5.25,null,null,null,"typ","cena","D","B","C","m",null,"typ","cena","D","B","C","m",null,"typ","cena","D","B","C","m"]
["NU415",null,75,180,45,224000,156000,9125,6.25,null,null,"Ložisko E",6411,2061,150,33,103000,2.4,"Ložisko E","NU211",1471,100,21,96500,1.45,"Ložisko E",6411,2061,150,33,103000,2.4]
["NU416",null,80,190,48,260000,183000,9598,7.3,null,null,"Ložisko F","NU411",5549,140,33,120000,2.5,"Ložisko F",6411,2061,150,33,103000,2.4,"Ložisko F","NU211",1471,100,21,96500,1.45]
["NU417",null,85,210,52,310000,228000,10025,8.6999999999999993]
["NU418",null,90,225,54,345000,255000,10397,10.5]
[null,null,null,null,null,null,null,null,null,null,null,"Životnost ložisek",null,null,"A",null,"B",null,"C",null,"D",null,"E",null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,"1 - stupňová",null,"FR",{"$f":"SQRT(Výpočty!D43*Výpočty!D43+Výpočty!D42*Výpočty!D42)","v":2233.0830985901739},"N",{"$f":"SQRT(Výpočty!D44*Výpočty!D44+Výpočty!D45*Výpočty!D45)","v":1977.6847962232341},"N","-",null,"-",null,{"$f":"SQRT(Výpočty!D51*Výpočty!D51+Výpočty!D50*Výpočty!D50)","v":9645.1206919481338},"N",{"$f":"SQRT(Výpočty!D52*Výpočty!D52+Výpočty!D53*Výpočty!D53)","v":11039.897326316279},"N"]
["Válečkové ložisko   SKF NJ23",null,null,null,null,null,null,null,null,null,null,null,null,"FA",{"$f":"Výpočty!D41","v":827.25433300600571},"N",0,"N",null,null,null,null,0,"N",{"$f":"Výpočty!D49","v":810.7092463458855},"N"]
["Označení ložiska",null,"Rozmery",null,null,"Únosnost",null,"cena [kč]","m [kg]",null,null,null,null,"Fe",{"$f":"0.56*O21+1.6*O22","v":2574.1334680201066},"N",{"$f":"Q21","v":1977.6847962232341},"N",null,null,null,null,{"$f":"W21","v":9645.1206919481338},"N",{"$f":"1*Y21+0*Y22","v":11039.897326316279},"N"]
[null,null,"d","D","B","C","Co",null,null,null,null,null,null,"n",{"$f":"Vstupy!B7","v":6000},"min-1",{"$f":"O24","v":6000},"min-1",null,null,null,null,{"$f":"Výpočty!J8","v":1010.5263157894736},"min-1",{"$f":"W24","v":1010.5263157894736},"min-1"]
["NJ2304",null,20,52,21,47500,38000,943,0.22,null,null,null,null,"C*",{"$f":"O23*((20000*O24)/16667)^(1/3)","v":49705.639389909593},null,{"$f":"Q23*((20000*Q24)/16667)^(1/3)","v":38188.418949227176},null,null,null,null,null,{"$f":"W23*((20000*W24)/16667)^(1/3)","v":102852.39186107767},null,{"$f":"Y23*((20000*Y24)/16667)^(1/3)","v":117725.83072602277}]
["NJ2305",null,25,62,24,64000,55000,933,0.35,null,null,null,"životnost",null,{"$f":"IF(O25<Q6,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(Q25<Q7,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,null,null,null,null,{"$f":"IF(W25<Q16,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(Y25<Q17,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"}]
["NJ2306",null,30,72,27,83000,75000,1150,0.54,null,null,null,null,null,{"$f":"IF(((O6/2)+(O16/2)+8)<Výpočty!F13,\" \",\"kolize ložisek A a E\")","v":" "},null,{"$f":"IF(((O7/2)+(O17/2)+8)<Výpočty!F13,\" \",\"kolize ložisek B a F\")","v":" "},null,null,null,null,null,{"$f":"IF(((O6/2)+(O16/2)+8)<Výpočty!F13,\" \",\"kolize ložisek A a E\")","v":" "},null,{"$f":"IF(((O7/2)+(O17/2)+8)<Výpočty!F13,\" \",\"kolize ložisek B a F\")","v":" "}]
["NJ2307",null,35,80,31,106000,98000,1238,0.73]
["NJ2308",null,40,90,33,129000,120000,1759,0.95,null,null,"2 - stupňová",null,"FR",{"$f":"SQRT('Výpočty 2'!B50*'Výpočty 2'!B50+'Výpočty 2'!B49*'Výpočty 2'!B49)","v":1528.7951383977693},"N",{"$f":"SQRT('Výpočty 2'!B51*'Výpočty 2'!B51+'Výpočty 2'!B52*'Výpočty 2'!B52)","v":433.92176675716252},"N",{"$f":"SQRT('Výpočty 2'!E50*'Výpočty 2'!E50+'Výpočty 2'!E51*'Výpočty 2'!E51)","v":5735.6504019623526},"N",{"$f":"SQRT('Výpočty 2'!E52*'Výpočty 2'!E52+'Výpočty 2'!E53*'Výpočty 2'!E53)","v":6505.9244118459092},"N",{"$f":"SQRT('Výpočty 2'!H49*'Výpočty 2'!H49+'Výpočty 2'!H50*'Výpočty 2'!H50)","v":3037.5869478159693},"N",{"$f":"SQRT('Výpočty 2'!H51*'Výpočty 2'!H51+'Výpočty 2'!H52*'Výpočty 2'!H52)","v":6097.71488316453},"N"]
["NJ2309",null,45,100,36,160000,153000,1802,1.33,null,null,null,null,"FA",{"$f":"'Výpočty 2'!B48","v":778.59231341741702},"N",{"$f":"0","v":0},"N",{"$f":"'Výpočty 2'!E49","v":738.11836207831902},"N",{"$f":"0","v":0},"N",{"$f":"0","v":0},"N",{"$f":"'Výpočty 2'!H48","v":1471.1160526428403},"N"]
["NJ2310",null,50,110,40,186000,186000,2212,1.77,null,null,null,null,"Fe",{"$f":"0.56*O29+1.6*O30","v":2101.8729789706181},"N",{"$f":"Q29","v":433.92176675716252},"N",{"$f":"1*S29+0*S30","v":5735.6504019623526},"N",{"$f":"U29","v":6505.9244118459092},"N",{"$f":"W29","v":3037.5869478159693},"N",{"$f":"1*Y29+0*Y30","v":6097.71488316453},"N"]
["NJ2311",null,55,120,43,232000,232000,3082,2.54,null,null,null,null,"n",{"$f":"Vstupy!B7","v":6000},"min-1",{"$f":"O32","v":6000},"min-1",{"$f":"Q32/('Výpočty 2'!F6/'Výpočty 2'!F5)","v":2886.7924528301883},"min-1",{"$f":"S32","v":2886.7924528301883},"min-1",{"$f":"'Výpočty 2'!K11","v":986.62526868879854},"min-1",{"$f":"W32","v":986.62526868879854},"min-1"]
["NJ2312",null,60,130,46,260000,265000,3601,2.8,null,null,null,null,"C*",{"$f":"O31*((20000*O32)/16667)^(1/3)","v":40586.450405178643},null,{"$f":"Q31*((20000*Q32)/16667)^(1/3)","v":8378.8813322307142},null,{"$f":"S31*((20000*S32)/16667)^(1/3)","v":86785.1422394486},null,{"$f":"U31*((20000*U32)/16667)^(1/3)","v":98440.02613687441},null,{"$f":"W31*((20000*W32)/16667)^(1/3)","v":32134.408936108975},null,{"$f":"Y31*((20000*Y32)/16667)^(1/3)","v":64507.277321655878}]
["NJ2313",null,65,140,48,285000,290000,4087,3.7,null,null,null,"životnost",null,{"$f":"IF(O33<X6,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(Q33<X7,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(S33<X11,\"vyhovuje\",\"nevyhovuje\")","v":"nevyhovuje"},null,{"$f":"IF(U33<X12,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(W33<X16,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(Y33<X17,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"}]
["NJ2314",null,70,150,51,315000,325000,4903,4,null,null,null,null,null,{"$f":"IF(((V6/2)+(V11/2)+8)<'Výpočty 2'!G21,\" \",\"kolize ložisek A a C\")","v":" "},null,{"$f":"IF(((V7/2)+(V12/2)+8)<'Výpočty 2'!G21,\" \",\"kolize ložisek B a D\")","v":" "},null,{"$f":"IF(((V6/2)+(V11/2)+8)<'Výpočty 2'!G21,\" \",\"kolize ložisek A a C\")","v":" "},null,{"$f":"IF(((V7/2)+(V12/2)+8)<'Výpočty 2'!G21,\" \",\"kolize ložisek B a D\")","v":" "},null,{"$f":"IF(((V11/2)+(V16/2)+8)<'Výpočty 2'!G22,\" \",\"kolize ložisek C aE\")","v":" "},null,{"$f":"IF(((V12/2)+(V17/2)+8)<'Výpočty 2'!G22,\" \",\"kolize ložisek D a F\")","v":" "}]
["NJ2315",null,75,160,55,380000,400000,6045,5]
["NJ2316",null,80,170,58,415000,440000,7145,6.95,null,null,"2 - stupňová koaxiálna",null,"FR",{"$f":"SQRT(' Výpočty 3'!B49*' Výpočty 3'!B49+' Výpočty 3'!B50*' Výpočty 3'!B50)","v":1254.1266832401886},"N",{"$f":"SQRT(' Výpočty 3'!B51*' Výpočty 3'!B51+' Výpočty 3'!B52*' Výpočty 3'!B52)","v":748.77963409924996},"N",{"$f":"SQRT(' Výpočty 3'!E50*' Výpočty 3'!E50+' Výpočty 3'!E51*' Výpočty 3'!E51)","v":5049.1260568771177},"N",{"$f":"SQRT(' Výpočty 3'!E53*' Výpočty 3'!E53+' Výpočty 3'!E52*' Výpočty 3'!E52)","v":8372.6304010041786},"N",{"$f":"SQRT(' Výpočty 3'!H49*' Výpočty 3'!H49+' Výpočty 3'!H50*' Výpočty 3'!H50)","v":4479.5033483272309},"N",{"$f":"SQRT(' Výpočty 3'!H51*' Výpočty 3'!H51+' Výpočty 3'!H52*' Výpočty 3'!H52)","v":5866.304020677675},"N"]
["NJ2317",null,85,180,60,455000,490000,8325,7.95,null,null,null,null,"FA",{"$f":"' Výpočty 3'!B48","v":778.59231341741702},"N",{"$f":"0","v":0},"N",{"$f":"' Výpočty 3'!E49","v":925.76071573174249},"N",{"$f":"0","v":0},"N",{"$f":"0","v":0},"N",{"$f":"' Výpočty 3'!H48","v":1655.0055592231952},"N"]
["NJ2318",null,90,190,64,500000,540000,8912,8.27,null,null,null,null,"Fe",{"$f":"0.56*O37+1.6*O38","v":1948.0586440823731},"N",{"$f":"Q37","v":748.77963409924996},"N",{"$f":"1*S37+0*S38","v":5049.1260568771177},"N",{"$f":"U37","v":8372.6304010041786},"N",{"$f":"W37","v":4479.5033483272309},"N",{"$f":"1*Y37+0*Y38","v":5866.304020677675},"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"n",{"$f":"Vstupy!B7","v":6000},"min-1",{"$f":"O40","v":6000},"min-1",{"$f":"O40/(' Výpočty 3'!F6/' Výpočty 3'!F5)","v":2886.7924528301883},"min-1",{"$f":"S40","v":2886.7924528301883},"min-1",{"$f":"' Výpočty 3'!K11","v":989.75741239892182},"min-1",{"$f":"W40","v":989.75741239892182},"min-1"]
["kuličkové ložisko SKF Typ 64",null,null,null,null,null,null,null,null,null,null,null,null,"C*",{"$f":"O39*((20000*O40)/16667)^(1/3)","v":37616.348055033457},null,{"$f":"Q39*((20000*Q40)/16667)^(1/3)","v":14458.679372081049},null,{"$f":"S39*((20000*S40)/16667)^(1/3)","v":76397.460152220607},null,{"$f":"U39*((20000*U40)/16667)^(1/3)","v":126684.83421180602},null,{"$f":"W39*((20000*W40)/16667)^(1/3)","v":47438.429914516586},null,{"$f":"Y39*((20000*Y40)/16667)^(1/3)","v":62124.80056434944}]
["Označení ložiska",null,"Rozmery",null,null,"Únosnost",null,"cena [kč]","m [kg]",null,null,null,"životnost",null,{"$f":"IF(O41<AE6,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(Q41<AE7,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(S41<AE11,\"vyhovuje\",\"nevyhovuje\")","v":"nevyhovuje"},null,{"$f":"IF(U41<AE12,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(W41<AE16,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"},null,{"$f":"IF(Y41<AE17,\"vyhovuje\",\"nevyhovuje\")","v":"vyhovuje"}]
[null,null,"d","D","B","C","Co",null,null,null,null,null,null,null,{"$f":"IF(((AC6/2)+(AC11/2)+8)<' Výpočty 3'!G21,\" \",\"kolize ložisek A a C\")","v":" "},null,null,null,{"$f":"IF(((AC6/2)+(AC11/2)+8)<' Výpočty 3'!G21,\" \",\"kolize ložisek A a C\")","v":" "},null,{"$f":"IF(((AC12/2)+(AC17/2)+8)<' Výpočty 3'!G22,\" \",\"kolize ložisek B a D\")","v":" "},null,null,null,{"$f":"IF(((AC12/2)+(AC17/2)+8)<' Výpočty 3'!G22,\" \",\"kolize ložisek B a D\")","v":" "}]
[6404,null,20,72,19,30700,15000,558,0.41]
[6405,null,25,80,21,35800,19300,642,0.54]
[6406,null,30,90,23,43600,23600,808,0.75]
[6407,null,35,10,25,55300,31000,975,0.97]
[6408,null,40,110,27,63700,36500,1207,1.26]
[6409,null,45,120,29,76000,45000,1476,1.57]
[6410,null,50,130,31,87100,52000,1733,1.94]
[6411,null,55,140,33,103000,62000,2061,2.4]
[6412,null,60,150,35,108000,69500,2486,2.81]
[6413,null,65,160,37,119000,78000,3559,3.42]
[6414,null,70,180,42,143000,104000,5058,4.93]
[6415,null,75,190,45,153000,114000,7102,5.81]
[6416,null,80,200,48,163000,125000,8499,6.86]
[6417,null,85,210,52,174000,137000,9078,8.0500000000000007]
[6418,null,90,225,54,186000,150000,10120,9.7799999999999994]
[]
["Válečkové ložisko  SKF NU2"]
["Označení ložiska",null,"Rozmery",null,null,"Únosnost",null,"cena [kč]","m [kg]"]
[null,null,"d","D","B","C","Co"]
["NU204",null,20,47,14,28500,22000,494,0.15]
["NU205",null,25,52,15,32500,27000,538,0.24]
["NU206",null,30,62,16,44000,36500,793,0.36]
["NU207",null,35,72,17,56000,48000,806,0.48]
["NU208",null,40,80,18,62000,53000,933,0.66]
["NU209",null,45,85,19,69500,64000,1069,0.87]
["NU210",null,50,90,20,73500,69500,1252,1.1499999999999999]
["NU211",null,55,100,21,96500,95000,1471,1.45]
["NU212",null,60,110,22,108000,102000,1614,1.85]
["NU213",null,65,120,23,122000,118000,1691,2.25]
["NU214",null,70,125,24,137000,137000,1845,2.75]
["NU215",null,75,130,25,150000,156000,1955,3.25]
["NU216",null,80,140,26,160000,166000,2284,3.9]
["NU217",null,85,150,28,190000,200000,2581,4.5]
["NU218",null,90,160,30,210000,220000,3031,5.4]

{"sheet":"Výstupy","index":3,"n_rows":111,"n_cols":28,"rows_kept":111,"cut":false,"hidden":false,"merged":[[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[22,3,22,4],[32,3,32,4],[34,5,34,6],[35,5,35,6],[28,3,28,4],[29,3,29,4],[30,3,30,4],[24,3,24,4],[31,3,31,4],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[9,14,9,15],[9,16,9,17],[14,9,14,11],[15,12,15,13],[19,12,19,13],[9,10,9,11],[9,12,9,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[33,5,33,6],[36,5,36,6],[37,5,37,6],[32,12,32,13],[36,9,36,11],[37,12,37,13],[41,12,41,13],[46,14,46,15],[55,10,55,13],[54,10,54,13],[56,10,56,13],[57,10,57,13],[58,10,58,13],[59,10,59,13],[54,14,54,15],[55,14,55,15],[56,14,56,15],[57,14,57,15],[58,14,58,15],[59,14,59,15],[24,19,24,21],[9,24,9,25],[9,26,9,27],[14,19,14,21],[15,22,15,23],[19,22,19,23],[0,1,2,4],[0,10,2,13],[0,19,2,19],[0,20,2,23],[9,20,9,21],[9,22,9,23],[24,9,24,11],[23,0,23,2],[13,0,13,2],[0,9,2,9],[0,0,2,0],[14,3,14,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[7,1,7,2],[7,3,7,4],[21,3,21,4],[28,22,28,23],[29,22,29,23],[30,22,30,23],[31,22,31,23],[32,22,32,23],[20,22,20,23],[21,22,21,23],[22,22,22,23],[23,22,23,23],[44,22,44,23],[45,22,45,23],[46,24,46,25],[54,20,54,23],[54,24,54,25],[52,24,52,25],[53,24,53,25],[36,19,36,21],[37,22,37,23],[41,22,41,23],[42,22,42,23],[43,22,43,23],[58,20,58,23],[58,24,58,25],[59,20,59,23],[59,24,59,25],[47,14,47,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15],[52,14,52,15],[53,14,53,15],[47,24,47,25],[48,24,48,25],[49,24,49,25],[50,24,50,25],[51,24,51,25],[55,20,55,23],[55,24,55,25],[56,20,56,23],[56,24,56,25],[57,20,57,23],[57,24,57,25]]}
["Výstupné hodnoty","1. stupňová převodovka",null,null,null,null,null,null,null,"Výstupné hodnoty","2. stupňová převodovka",null,null,null,null,null,null,null,null,"Výstupné hodnoty","2. koaxiální stupňová převodovka"]
[]
[]
["Upravené výstupné otáčky nuvyst",{"$f":"Výpočty!J8","v":1010.5263157894736},"min -1","x=",{"$f":"Vstupy!D31","v":513.6156728195657},null," ",null,null,"Upravené výstupné otáčky nuvyst",{"$f":"'Výpočty 2'!K11","v":986.62526868879854},"min -1","x=",{"$f":"Vstupy!I31","v":398.25269838222437},null,null,null,null,null,"Upravené výstupné otáčky nuvyst",{"$f":"' Výpočty 3'!K11","v":989.75741239892182},"min -1","x= ",{"$f":"Vstupy!N31","v":294.5065108771297}]
["Krouticí moment na vstup. hřídeli Mk1",{"$f":"Výpočty!E6","v":143239.44878270582},"N.mm","y=",{"$f":"Vstupy!D32","v":105},null,null,null,null,"Krouticí moment na vstup. hřídeli Mk1",{"$f":"'Výpočty 2'!E10","v":143239.44878270582},"N.mm","y=",{"$f":"Vstupy!I32","v":171.5},null,null,null,null,null,"Krouticí moment na vstup. hřídeli Mk1",{"$f":"' Výpočty 3'!E10","v":143239.44878270582},"N.mm","y=",{"$f":"Vstupy!N32","v":261}]
["Krouticí moment na výstup. hřídeli Mk2",{"$f":"Výpočty!E7","v":833474.54260436946},"N.mm",null,null,null,null,null,null,"Krouticí moment na druhém hřídeli Mk2",{"$f":"'Výpočty 2'!E11","v":291759.09685387224},"N.mm",null,null,null,null,null,null,null,"Krouticí moment na druhém hřídeli Mk2",{"$f":"' Výpočty 3'!E11","v":291759.09685387224},"N.mm"]
[null,null,null,null,null,null,null,null,null,"Krouticí moment na výstup. hřídeli Mk3",{"$f":"'Výpočty 2'!E12","v":836592.19549728849},"N.mm",null,null,null,null,null,null,null,"Krouticí moment na výstup. hřídeli Mk3",{"$f":"' Výpočty 3'!E12","v":833944.75184065138},"N.mm"]
["Hlavné Rozmery","Pastorek",null,"Kolo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korigovaný modul prvního soukolí mk12",{"$f":"' Výpočty 3'!E13","v":1.5}]
["Šířka kola bw",{"$f":"Výpočty!D11","v":29},"mm",{"$f":"Výpočty!H11","v":30},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korigovaný modul druhého soukolí mk34",{"$f":"' Výpočty 3'!E14","v":2.5}]
["Průměr roztečnej kružnice d",{"$f":"Výpočty!D12","v":73.608522830282098},"mm",{"$f":"Výpočty!F12","v":437.0506043048},"mm",null,null,null,null,"Hlavné Rozmery","Pastorek 1",null,"Kolo 2",null,"Pastorek 3",null,"Kolo 4",null,null,"Hlavné Rozmery","Pastorek 1",null,"Kolo 2",null,"Pastorek 3",null,"Kolo 4"]
["hlavový průměr  da",{"$f":"Výpočty!D20","v":76.521614199249314},"mm",{"$f":"Výpočty!F20","v":440.0506043048},"mm",null,null,null,null,"Šířka kola bw",{"$f":"'Výpočty 2'!E16","v":29},"mm",{"$f":"'Výpočty 2'!G16","v":30},"mm",{"$f":"'Výpočty 2'!I16","v":48},"mm",{"$f":"'Výpočty 2'!K16","v":50},"mm",null,"Šířka kola bw",{"$f":"' Výpočty 3'!E16","v":29},"mm",{"$f":"' Výpočty 3'!G16","v":30},"mm",{"$f":"' Výpočty 3'!I16","v":48},"mm",{"$f":"' Výpočty 3'!K16","v":50},"mm"]
["patní průměr  df",{"$f":"Výpočty!D21","v":69.771614199249314},"mm",{"$f":"Výpočty!F21","v":433.21369567376723},"mm",null,null,null,null,"Průměr roztečnej kružnice d",{"$f":"'Výpočty 2'!E17","v":78.209055507174739},"mm",{"$f":"'Výpočty 2'!G17","v":162.55215458353965},"mm",{"$f":"'Výpočty 2'!I17","v":68.54129630228779},"mm",{"$f":"'Výpočty 2'!K17","v":200.54675584743464},"mm",null,"Průměr roztečnej kružnice d",{"$f":"' Výpočty 3'!E17","v":78.209055507174739},"mm",{"$f":"' Výpočty 3'!G17","v":162.55215458353965},"mm",{"$f":"' Výpočty 3'!I17","v":60.925596713144699},"mm",{"$f":"' Výpočty 3'!K17","v":177.69965708000538},"mm"]
["Silové pomery",null,null,null,null,null,null,null,null,"hlavový průměr  da",{"$f":"'Výpočty 2'!E18","v":81.109378676577293},"mm",{"$f":"'Výpočty 2'!G18","v":165.55215458353965},"mm",{"$f":"'Výpočty 2'!I18","v":73.663587556607382},"mm",{"$f":"'Výpočty 2'!K18","v":205.54675584743464},"mm",null,"hlavový průměr  da",{"$f":"' Výpočty 3'!E18","v":81.109378676577293},"mm",{"$f":"' Výpočty 3'!G18","v":165.55215458353965},"mm",{"$f":"' Výpočty 3'!I18","v":66.111482224475068},"mm",{"$f":"' Výpočty 3'!K18","v":182.69965708000538},"mm"]
["Vsupný hřídel",null,null,null,null,null,null,null,null,"patní průměr  df",{"$f":"'Výpočty 2'!E19","v":74.359378676577293},"mm",{"$f":"'Výpočty 2'!G19","v":158.80215458353965},"mm",{"$f":"'Výpočty 2'!I19","v":62.413587556607382},"mm",{"$f":"'Výpočty 2'!K19","v":194.29675584743464},"mm",null,"patní průměr  df",{"$f":"' Výpočty 3'!E19","v":74.359378676577293},"mm",{"$f":"' Výpočty 3'!G19","v":158.80215458353965},"mm",{"$f":"' Výpočty 3'!I20","v":57.147505800120086},"mm",{"$f":"' Výpočty 3'!K20","v":166.68022525035028},"mm"]
[null,null,null," Mc -vstupný",null,{"$f":"Výpočty!$E$6","v":143239.44878270582},"N.mm",null,null,"Vsupný hřídel",null,null,null,null,null,null,null,null,null,"Vsupný hřídel"]
[null,null,null,"Tečná síla Ft",null,{"$f":"Výpočty!$D$31","v":3891.9256432565708},"N",null,null,null,null,null," Mc -vstupný",null,{"$f":"'Výpočty 2'!E10","v":143239.44878270582},"N.mm",null,null,null,null,null,null," Mc -vstupný",null,{"$f":"' Výpočty 3'!E10","v":143239.44878270582},"N.mm"]
[null,null,null,"Axiální síla Fa",null,{"$f":"Výpočty!$D$32","v":827.25433300600571},"N",null,null,null,null,null,"Tečná síla Ft",null,{"$f":"'Výpočty 2'!E37","v":3662.9888407120661},"N",null,null,null,null,null,null,"Tečná síla Ft",null,{"$f":"' Výpočty 3'!E37","v":3662.9888407120661},"N"]
[null,null,null,"Radiální síla Fr",null,{"$f":"Výpočty!$D$33","v":1448.1915480445314},"N",null,null,null,null,null,"Axiální síla Fa",null,{"$f":"'Výpočty 2'!E38","v":778.59231341741702},"N",null,null,null,null,null,null,"Axiální síla Fa",null,{"$f":"' Výpočty 3'!E38","v":778.59231341741702},"N"]
[null,null,null,"FAX",null,{"$f":"Výpočty!$D$41","v":827.25433300600571},"N",null,null,null,null,null,"Radiální síla Fr",null,{"$f":"'Výpočty 2'!E39","v":1363.0038099242645},"N",null,null,null,null,null,null,"Radiální síla Fr",null,{"$f":"' Výpočty 3'!E39","v":1363.0038099242645},"N"]
[null,null,null,"FAY",null,{"$f":"Výpočty!$D$42","v":1945.9628216282854},"N",null,null,null,null,null,"FAX",null,{"$f":"'Výpočty 2'!B48","v":778.59231341741702},"N",null,null,null,null,null,null,"FAX",null,{"$f":"' Výpočty 3'!B48","v":778.59231341741702},"N"]
[null,null,null,"FAZ",null,{"$f":"Výpočty!$D$43","v":1095.3943682754507},"N",null,null,null,null,null,"FAY",null,{"$f":"'Výpočty 2'!B49","v":968.06984379779919},"N",null,null,null,null,null,null,"FAY",null,{"$f":"' Výpočty 3'!B49","v":681.50190496213224},"N"]
[null,null,null,"FBZ",null,{"$f":"Výpočty!$D$44","v":-352.79717976908057},"N",null,null,null,null,null,"FAZ",null,{"$f":"'Výpočty 2'!B50","v":1183.2393471812704},"N",null,null,null,null,null,null,"FAZ",null,{"$f":"' Výpočty 3'!B50","v":1052.8004992153174},"N"]
[null,null,null,"FBY",null,{"$f":"Výpočty!$D$45","v":1945.9628216282854},"N",null,null,null,null,null,"FBZ",null,{"$f":"'Výpočty 2'!B51","v":-179.76446274299406},"N",null,null,null,null,null,null,"FBZ",null,{"$f":"' Výpočty 3'!B51","v":-310.20331070894707},"N"]
["-",null,null,null,null,null,null,null,null,null,null,null,"FBY",null,{"$f":"'Výpočty 2'!B52","v":394.93396612646529},"N",null,null,null,null,null,null,"FBY",null,{"$f":"' Výpočty 3'!B52","v":681.50190496213224},"N"]
[null,null,"-"," Ma - výstupný",null,{"$f":"Výpočty!E7","v":833474.54260436946},"N.mm",null,null,"Předlohový hřídel",null,null,null,null,null,null,null,null,null,"Předlohový hřídel"]
[null,null,{"$f":"Materiály!D14","v":0},"Tečná síla Ft",null,{"$f":"Výpočty!D31","v":3891.9256432565708},"N",null,null,null,null,null,"Tečná síla Ft",null,{"$f":"'Výpočty 2'!$I$37","v":8513.3813509194988},"N",null,null,null,null,null,null,"Tečná síla Ft",null,{"$f":"' Výpočty 3'!I37","v":9577.5540197844366},"N"]
[null,null,null,"Axiální síla Fa",null,{"$f":"Výpočty!D32","v":827.25433300600571},"N",null,null,null,null,null,"Axiální síla Fa",null,{"$f":"'Výpočty 2'!$I$38","v":1501.138829227388},"N",null,null,null,null,null,null,"Axiální síla Fa",null,{"$f":"' Výpočty 3'!I38","v":1688.7811828808115},"N"]
[null,null,null,"Radiální síla Fr",null,{"$f":"Výpočty!D33","v":1448.1915480445314},"N",null,null,null,null,null,"Radiální síla Fr",null,{"$f":"'Výpočty 2'!$I$39","v":3146.4185727762811},"N",null,null,null,null,null,null,"Radiální síla Fr",null,{"$f":"' Výpočty 3'!I39","v":3539.7208943733167},"N"]
[null,null,null,"FBX",null,{"$f":"Výpočty!D49","v":810.7092463458855},"N",null,null,null,null,null,"FAX",null,{"$f":"'Výpočty 2'!E49","v":738.11836207831902},"N",null,null,null,null,null,null,"FAX",null,{"$f":"' Výpočty 3'!E49","v":925.76071573174249},"N"]
[null,null,null,"FAY",null,{"$f":"Výpočty!D50","v":1907.0435651957196},"N",null,null,null,null,null,"FAY",null,{"$f":"'Výpočty 2'!E50","v":5648.1053745165082},"N",null,null,null,null,null,null,"FAY",null,{"$f":"' Výpočty 3'!E50","v":5046.3852819900485},"N"]
[null,null,null,"FAZ",null,{"$f":"Výpočty!D51","v":9454.7098317553682},"N",null,null,null,null,null,"FAZ",null,{"$f":"'Výpočty 2'!E51","v":998.2941509838837},"N",null,null,null,null,null,null,"FAZ",null,{"$f":"' Výpočty 3'!E51","v":166.34158815426986},"N"]
[null,null,null,"FBZ",null,{"$f":"Výpočty!D52","v":10873.937548839009},"N",null,null,null,null,null,"FBZ",null,{"$f":"'Výpočty 2'!E52","v":-812.38068806661738},"N",null,null,null,null,null,null,"FBZ",null,{"$f":"' Výpočty 3'!E52","v":-2037.6355724932671},"N"]
[null,null,null,"FBY",null,{"$f":"Výpočty!D53","v":1907.0435651957196},"N",null,null,null,null,null,"FBY",null,{"$f":"'Výpočty 2'!E53","v":6455.0050403008172},"N",null,null,null,null,null,null,"FBY",null,{"$f":"' Výpočty 3'!E53","v":8120.8978016922147},"N"]
["Počty dilů","vnej. D","vrtání","l",null,"hmotnosť"]
["Vstupný hřídel",{"$f":"Výpočty!B60","v":29},"-",{"$f":"Výpočty!D60","v":163},"mm",{"$f":"Výpočty!G60","v":0.84516818099914748},null,"kg"]
["Předlohový hřídel                                        ",{"$f":"Výpočty!B61","v":53},"-",{"$f":"Výpočty!D61","v":221},"mm",{"$f":"Výpočty!G61","v":3.8273973425901069},null,"kg"]
["Pastorek 1                                        z =",{"$f":"Výpočty!C62","v":48},"          b =",{"$f":"Výpočty!E62","v":29},"mm",{"$f":"Výpočty!G62","v":0.81838717275899919},null,"kg",null,"Výstupný hřídel",null,null,null,null,null,null,null,null,null,"Výstupný hřídel"]
["Kolo 2                                              z = ",{"$f":"Výpočty!C63","v":285},"          b =",{"$f":"Výpočty!E63","v":30},"mm",{"$f":"Výpočty!G63","v":34.810493059678386},null,"kg",null,null,null,null," Ma - výstupný",null,{"$f":"'Výpočty 2'!E12","v":836592.19549728849},"N.mm",null,null,null,null,null,null," Ma - výstupný",null,{"$f":"' Výpočty 3'!E12","v":833944.75184065138},"N.mm"]
["ložisko A",{"$f":"'Ložiská '!M6","v":"NU406"},null,null,null,{"$f":"'Ložiská '!R6","v":0.75},null,"kg",null,null,null,null,"Tečná síla Ft",null,{"$f":"'Výpočty 2'!K37","v":8343.1137239011096},"N",null,null,null,null,null,null,"Tečná síla Ft",null,{"$f":"' Výpočty 3'!K37","v":9386.0029393887471},"N"]
["ložisko B",{"$f":"'Ložiská '!M7","v":6406},null,null,null,{"$f":"'Ložiská '!R7","v":0.75},null,"kg",null,null,null,null,"Axiální síla Fa",null,{"$f":"'Výpočty 2'!K38","v":1471.1160526428403},"N",null,null,null,null,null,null,"Axiální síla Fa",null,{"$f":"' Výpočty 3'!K38","v":1655.0055592231952},"N"]
["ložisko E",{"$f":"'Ložiská '!M16","v":6411},null,null,null,{"$f":"'Ložiská '!R16","v":2.4},null,"kg",null,null,null,null,"Radiální síla Fr",null,{"$f":"'Výpočty 2'!K39","v":3083.4902013207561},"N",null,null,null,null,null,null,"Radiální síla Fr",null,{"$f":"' Výpočty 3'!K39","v":3468.9264764858499},"N"]
["ložisko F",{"$f":"'Ložiská '!M17","v":"NU411"},null,null,null,{"$f":"'Ložiská '!R17","v":2.5},null,"kg",null,null,null,null,"FBX",null,{"$f":"'Výpočty 2'!H48","v":1471.1160526428403},"N",null,null,null,null,null,null,"FBX",null,{"$f":"' Výpočty 3'!H48","v":1655.0055592231952},"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FAY",null,{"$f":"'Výpočty 2'!H49","v":3036.5396238933363},"N",null,null,null,null,null,null,"FAY",null,{"$f":"' Výpočty 3'!H49","v":4471.6334758408648},"N"]
["Bezpečnosti",null,null,null,null,null,null,null,null,null,null,null,"FAZ",null,{"$f":"'Výpočty 2'!H50","v":-79.759501425556209},"N",null,null,null,null,null,null,"FAZ",null,{"$f":"' Výpočty 3'!H50","v":-265.413461252861},"N"]
["Součinitel bezpečnosti v dotyku SH",{"$f":"Výpočty!E83","v":2.0129296281435023},null,null,null,null,null,null,null,null,null,null,"FBZ",null,{"$f":"'Výpočty 2'!H51","v":3003.7306998951999},"N",null,null,null,null,null,null,"FBZ",null,{"$f":"' Výpočty 3'!H51","v":3203.5130152329889},"N"]
["Součinitel Bezpečnosti v ohybe SF",{"$f":"Výpočty!M71","v":1.7879888743261991},null,null,null,null,null,null,null,null,null,null,"FBY",null,{"$f":"'Výpočty 2'!H52","v":5306.5741000077733},"N",null,null,null,null,null,null,"FBY",null,{"$f":"' Výpočty 3'!H52","v":4914.3694635478823},"N"]
["Statická kontrola hřídelu 1 σred1",{"$f":"Výpočty!C93","v":70.999599688361684},"N/mm2",{"$f":"IF(B47>80,\"Nutno zvětšit průměr hřídele 1\",\" \")","v":" "},null,null,null,null,null,"Počty dilů","d","vrtání","l",null,"hmotnosť",null,null,null,null,"Počty dilů","d","vrtání","l",null,"hmotnosť"]
["Statická kontrola hřídelu 2 σred2",{"$f":"Výpočty!H93","v":64.891425787421426},"N/mm2",{"$f":"IF(B48>80,\"Nutno zvětšit průměr hřídele 2\",\" \")","v":" "},null,null,null,null,null,"Vstupný hřídel",{"$f":"'Výpočty 2'!G41","v":29},null,{"$f":"'Výpočty 2'!B46+'Výpočty 2'!B47+2*'Výpočty 2'!G41+'Výpočty 2'!D56/2+'Výpočty 2'!D57/2","v":222.5},"mm",{"$f":"Vstupy!K34","v":1.3247881610140011},null,null,null,null,"Vstupný hřídel",{"$f":"Výpočty!F35","v":29},null,{"$f":"Vstupy!P34","v":0.87109358532427483},"mm",{"$f":"Vstupy!Q34","v":5135.5621443004338}]
[null,null,null,null,null,null,null,null,null,"Předlohový hřídel                                        ",{"$f":"'Výpočty 2'!G42","v":37},null,{"$f":"'Výpočty 2'!E46+'Výpočty 2'!E47+'Výpočty 2'!E48+'Výpočty 2'!D58/2+'Výpočty 2'!D59/2","v":171.5},"mm",{"$f":"Vstupy!K35","v":1.4897304539771703},null,null,null,null,"Předlohový hřídel                                        ",{"$f":"' Výpočty 3'!G42","v":37},null,{"$f":"Vstupy!P35","v":2.2451461799315999},"mm",{"$f":"Vstupy!Q35","v":11223.566063633994}]
[null,null,null,null,null,null,null,null,null,"Výstupný hřídel                                           ",{"$f":"'Výpočty 2'!G43","v":53},null,{"$f":"'Výpočty 2'!H46+'Výpočty 2'!H47+'Výpočty 2'!D60/2+'Výpočty 2'!D61/2+2*'Výpočty 2'!G43","v":274.5},"mm",{"$f":"Vstupy!K36","v":4.7539392332171246},null,null,null,null,"Výstupný hřídel                                           ",{"$f":"' Výpočty 3'!G43","v":53},null,{"$f":"Vstupy!P36","v":4.1391310628010665},"mm",{"$f":"Vstupy!Q36","v":7848.4523384538797}]
[null,null,null,null,null,null,null,null,null,"Pastorek 1                                         z =",{"$f":"'Výpočty 2'!F5","v":51},"    šířka",{"$f":"'Výpočty 2'!E16","v":29},"mm",{"$f":"Vstupy!K37","v":0.94326568482492235},null,null,null,null,"Pastorek 1                                         z =",{"$f":"Vstupy!N37","v":78.209055507174739},"          b =",{"$f":"Vstupy!P37","v":0.94326568482492235},"mm",{"$f":"Vstupy!Q37","v":4945.9990815798028}]
[null,null,null,null,null,null,null,null,null,"Kolo 2                                               z = ",{"$f":"'Výpočty 2'!F6","v":106},"    šířka",{"$f":"'Výpočty 2'!G16","v":30},"mm",{"$f":"Vstupy!K38","v":4.634057135139189},null,null,null,null,"Kolo 2                                               z = ",{"$f":"Vstupy!N38","v":162.55215458353965},"          b =",{"$f":"Vstupy!P38","v":4.634057135139189},"mm",{"$f":"Vstupy!Q38","v":9001.7533690823129}]
[null,null,null,null,null,null,null,null,null,"Pastorek 3                                         z = ",{"$f":"'Výpočty 2'!F7","v":27},"    šířka",{"$f":"'Výpočty 2'!I16","v":48},"mm",{"$f":"Vstupy!K39","v":0.98515085317114848},null,null,null,null,"Pastorek 3                                         z = ",{"$f":"Vstupy!N39","v":60.925596713144699},"          b =",{"$f":"Vstupy!P39","v":0.69336159108704376},"mm",{"$f":"Vstupy!Q39","v":5156.4152591870034}]
[null,null,null,null,null,null,null,null,null,"Kolo 4                                               z = ",{"$f":"'Výpočty 2'!F8","v":79},"    šířka",{"$f":"'Výpočty 2'!K16","v":50},"mm",{"$f":"Vstupy!K40","v":11.53233542225508},null,null,null,null,"Kolo 4                                               z = ",{"$f":"Vstupy!N40","v":177.69965708000538},"          b =",{"$f":"Vstupy!P40","v":8.8683280662176021},"mm",{"$f":"Vstupy!Q40","v":10558.647945824865}]
[null,null,null,null,null,null,null,null,null,"ložisko A",{"$f":"'Ložiská '!T6","v":"NU406"},null,null,null,{"$f":"'Ložiská '!Y6","v":0.75},null,"kg",null,null,"ložisko A",{"$f":"'Ložiská '!AA6","v":"NU406"},null,null,null,{"$f":"'Ložiská '!AF6","v":0.75},null,"kg"]
[null,null,null,null,null,null,null,null,null,"ložisko B",{"$f":"'Ložiská '!T7","v":6406},null,null,null,{"$f":"'Ložiská '!Y7","v":0.75},null,"kg",null,null,"ložisko B",{"$f":"'Ložiská '!AA7","v":6406},null,null,null,{"$f":"'Ložiská '!AF7","v":0.75},null,"kg"]
[null,null,null,null,null,null,null,null,null,"ložisko C",{"$f":"'Ložiská '!T11","v":6408},null,null,null,{"$f":"'Ložiská '!Y11","v":1.26},null,"kg",null,null,"ložisko C",{"$f":"'Ložiská '!AA11","v":6408},null,null,null,{"$f":"'Ložiská '!AF11","v":1.26},null,"kg"]
[null,null,null,null,null,null,null,null,null,"ložisko D",{"$f":"'Ložiská '!T12","v":"NJ2308"},null,null,null,{"$f":"'Ložiská '!Y12","v":0.95},null,"kg",null,null,"ložisko D",{"$f":"'Ložiská '!AA12","v":"NJ2308"},null,null,null,{"$f":"'Ložiská '!AF12","v":0.95},null,"kg"]
[null,null,null,null,null,null,null,null,null,"ložisko E",{"$f":"'Ložiská '!T16","v":"NU211"},null,null,null,{"$f":"'Ložiská '!Y16","v":1.45},null,"kg",null,null,"ložisko E",{"$f":"'Ložiská '!AA16","v":6411},null,null,null,{"$f":"'Ložiská '!AF16","v":2.4},null,"kg"]
[null,null,null,null,null,null,null,null,null,"ložisko F",{"$f":"'Ložiská '!T17","v":6411},null,null,null,{"$f":"'Ložiská '!Y17","v":2.4},null,"kg",null,null,"ložisko F",{"$f":"'Ložiská '!AA17","v":"NU211"},null,null,null,{"$f":"'Ložiská '!AF17","v":1.45},null,"kg"]
[null,null,null,null,null,null,null,null,null,"Bezpečnosti","Soukolí 12",null,"Soukolí 34",null,null,null,null,null,null,"Bezpečnosti","Soukolí 12",null,"Soukolí 34"]
[null,null,null,null,null,null,null,null,null,"Součinitel bezpečnosti v dotyku SH",{"$f":"'Výpočty 2'!E91","v":2.0479605249213431},null,{"$f":"'Výpočty 2'!J91","v":1.4970026021086149},null,null,null,null,null,null,"Součinitel bezpečnosti v dotyku SH",{"$f":"' Výpočty 3'!E91","v":2.0479605249213431},null,{"$f":"' Výpočty 3'!J91","v":1.3164371673203301}]
[null,null,null,null,null,null,null,null,null,"Součinitel Bezpečnosti v ohybe SF",{"$f":"'Výpočty 2'!N81","v":2.5036928963356559},null,{"$f":"'Výpočty 2'!S81","v":2.6655231986370898},null,null,null,null,null,null,"Součinitel Bezpečnosti v ohybe SF",{"$f":"' Výpočty 3'!N81","v":2.6968152134083789},null,{"$f":"' Výpočty 3'!S81","v":2.1950090114821488}]
[null,null,null,null,null,null,null,null,null,"Statická kontrola hřídelu 1 σred1",{"$f":"'Výpočty 2'!C70","v":65.300054765591923},"N/mm2",{"$f":"IF(K64>80,\"Nutno zvětšit průměr hřídele 1\",\" \")","v":" "},null,null,null,null,null,null,"Statická kontrola hřídelu 1 σred1",{"$f":"' Výpočty 3'!C70","v":63.56077759673493},"N/mm2",{"$f":"IF(U64>80,\"Nutno zvětšit průměr hřídele 1\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,"Statická kontrola hřídelu 2 σred2",{"$f":"'Výpočty 2'!H70","v":88.965277695289302},"N/mm2",{"$f":"IF(K65>80,\"Nutno zvětšit průměr hřídele 2\",\" \")","v":"Nutno zvětšit průměr hřídele 2"},null,null,null,null,null,null,"Statická kontrola hřídelu 2 σred2",{"$f":"' Výpočty 3'!H70","v":101.73697272181379},"N/mm2",{"$f":"IF(U65>80,\"Nutno zvětšit průměr hřídele 2\",\" \")","v":"Nutno zvětšit průměr hřídele 2"}]
[null,null,null,null,null,null,null,null,null,"Statická kontrola hřídelu 3 σred3",{"$f":"'Výpočty 2'!M70","v":61.137928230688907},"N/mm2",{"$f":"IF(K66>80,\"Nutno zvětšit průměr hřídele 3\",\" \")","v":" "},null,null,null,null,null,null,"Statická kontrola hřídelu 3 σred3",{"$f":"' Výpočty 3'!M70","v":60.550300696519336},"N/mm2",{"$f":"IF(U66>80,\"Nutno zvětšit průměr hřídele 3\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Reakce k ložiskám"]
[null,null,null,null,null,null,null,null,null,null,null,null,"obrázok ložiská kola"]
[null,null,null,null,null,null,null,null,null,null,null,null,"obrázok + zástavbové rozmery"]
[null,null,null,null,null,null,null,null,null,null,null,null,"spoločné vstupné a výstupné listy pre obe prevodovky"]

{"sheet":"Výpočty","index":4,"n_rows":93,"n_cols":25,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["Návrh hlavných rozmerov"]
["Převodový pomer ip",null,null,null,{"$f":"Vstupy!B7/Vstupy!B6","v":6},null,"úhel záběru  α ",null,null,20,"°           =",{"$f":"J2*PI()/180","v":0.3490658503988659},"rad",null,null,null,null,null,null,null,null,null,null,null,15]
["Počet zubů pastroku z1",null,null,null,{"$f":"(2*Vstupy!B10*COS(Výpočty!L3))/(Výpočty!E9*(1+Výpočty!E2))","v":47.510026321356278},{"$f":"ROUND(E3,0)","v":48},"úhel sklonu zubu β ",null,null,{"$f":"Vstupy!B12","v":12},"°           =",{"$f":"J3*PI()/180","v":0.20943951023931953},"rad",null,null,null,null,null,null,null,null,null,null,6,16]
["Počet   zubů  kola z2",null,null,null,{"$f":"E3*E2","v":285.06015792813764},{"$f":"ROUND(E4,0)","v":285},"poměrná šířka ozubení ψ",null,null,{"$f":"Vstupy!B14","v":19},null,null,null,null,null,null,null,null,null,null,null,null,null,8,17]
["Upravený převodový pomer ipu",null,null,null,{"$f":"F4/F3","v":5.9375},null,"provozní součinitel KH",null,null,{"$f":"Vstupy!B16","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,10,18]
["Krouticí moment na vstup. hřídeli Mk1",null,null,null,{"$f":"(1000*Vstupy!B5*30000)/(PI()*Vstupy!B7)","v":143239.44878270582},"N.mm","účinnost n12",null,null,0.98,null,null,null,null,null,null,null,null,null,null,null,null,null,12,19]
["Krouticí moment na výstup. hřídeli Mk2",null,null,null,{"$f":"E6*E5*J6","v":833474.54260436946},"N.mm","Hlavová vůle",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,15,20]
[null,null,null,null,null,null,"Upravené výstupné otáčky nuvyst",null,null,{"$f":"Vstupy!B7/Výpočty!E5","v":1010.5263157894736},"min -1",null,null,null,null,null,null,null,null,null,null,null,null,null,21]
["Normálny modul mn  ",null,null,null,{"$f":"Vstupy!B8","v":1.5},null,"patní vůle",null,null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,"Pastorek",null,"Kolo"]
["Šířka kola bw",null,{"$f":"J4*E9","v":28.5},{"$f":"ROUNDUP(C11,0)","v":29},"mm",{"$f":"C11+E9","v":30},"mm           =",{"$f":"ROUNDUP(F11,0)","v":30}]
["Průměr roztečnej kružnice d",null,null,{"$f":"E9*F3/COS(L3)","v":73.608522830282098},"mm",{"$f":"E9*F4/COS(L3)","v":437.0506043048},"mm"]
["Osová vzdálenost a12",null,null,{"$f":"(D12+F12)/2","v":255.32956356754104},"mm       =",{"$f":"ROUND(D13,0)","v":255},"mm"]
["Rozdíl osových vzdáleností ",null,null,{"$f":"ABS(F13-D13)","v":0.32956356754104377},"mm"]
["čelní úhel záběru at",null,null,{"$f":"ATAN(TAN(L2)/COS(L3))","v":0.3562271414598594},"rad       =",{"$f":"D15*180/PI()","v":20.410311753659691},"°"]
["valivý úhel záběru aW",null,null,{"$f":"ACOS((D13/F13)*COS(D15))","v":0.35273750924097058},"rad       =",{"$f":"D16*180/PI()","v":20.21037055546449},"°"]
["inv at",null,null,{"$f":"TAN(D15)-D15","v":1.587440435301396E-2}]
["inv aw",null,null,{"$f":"TAN(D16)-D16","v":1.5396367313337711E-2}]
["korekce x1+x2",null,{"$f":"((F3+F4)/2*TAN(L2))*(D18-D17)","v":-2.8969543677594554E-2},{"$f":"C19","v":-2.8969543677594554E-2},"mm",{"$f":"0","v":0},"mm"]
["hlavový průměr  da",null,null,{"$f":"D12+2*E9+2*D19*E9","v":76.521614199249314},"mm",{"$f":"F12+2*E9+2*F19*E9","v":440.0506043048},"mm"]
["patní průměr  df",null,null,{"$f":"D12-2*E9*(J7+J9)+2*E9*D19","v":69.771614199249314},"mm",{"$f":"F12-2*E9*(J7+J9)+2*E9*D19","v":433.21369567376723},"mm"]
["základní průmer db",null,null,{"$f":"D12*COS(D15)","v":68.987323853117616},"mm",{"$f":"F12*COS(D15)","v":409.6122353778859},"mm"]
["základní rozteč pbt",null,null,{"$f":"(PI()*E9*COS(D15))/COS(L3)","v":4.5152097876619637},"mm"]
["obvodová rychlost  v",null,null,{"$f":"(PI()*Vstupy!B7*Výpočty!D12)/60000","v":23.124799456521082},"m/s"]
["výška zubu h",null,null,{"$f":"E9+1.25*E9","v":3.375},"mm"]
["součinitel záběru profilu εα",null,null,{"$f":"(0.5*SQRT(D20*D20-D22*D22)+0.5*SQRT(F20*F20-F22*F22)-D13*SIN(D16))/D23","v":1.9392077248075368}]
["součinitel záběru kroku εβ",null,null,{"$f":"D11*SIN(E29)/PI()/E9","v":1.2023242119961839}]
["součinitel záběru  ε",null,null,{"$f":"D26+D27","v":3.1415319368037204}]
["úhel skolnu zub na zakl valci  βb",null,null,null,{"$f":"ASIN(SIN(L3)*COS(L2))","v":0.19663784832917419}]
["Silové pomery",null,null,"Pastorek",null,"Kolo"]
["Tečná síla Ft",null,null,{"$f":"2*E6/D12","v":3891.9256432565708},"N",{"$f":"2*E7/F12","v":3814.0871303914391},"N"]
["Axiální síla Fa",null,null,{"$f":"D31*TAN(L3)","v":827.25433300600571},"N",{"$f":"F31*TAN(L3)","v":810.7092463458855},"N"]
["Radiální síla Fr",null,null,{"$f":"D31*(TAN(L2)/COS(L3))","v":1448.1915480445314},"N",{"$f":"F31*(TAN(L2)/COS(L3))","v":1419.2277170836408},"N"]
["Průměry hřídelů"]
["Průměr vstupního hřídele d1",null,null,{"$f":"((16*E6)/(PI()*I35))^(1/3)","v":28.971467804951779},"mm       =",{"$f":"ROUNDUP(D35,0)","v":29},"mm"," ",30,"N/mm2"]
["Průměr výstupního hřídele d2",null,null,{"$f":"((16*E7)/(PI()*I36))^(1/3)","v":52.109119103618951},"mm       =",{"$f":"ROUNDUP(D36,0)","v":53},"mm",null,30,"N/mm2"]
["Reakčné síly"]
["Hřídel 1"]
["a1",null,null,{"$f":"D55/2+15+D11/2","v":41},"mm"]
["a2",null,null,{"$f":"D11/2+15+D56/2","v":41},"mm"]
["FAX",null,null,{"$f":"D32","v":827.25433300600571},"N"]
["FAY",null,null,{"$f":"D31-D45","v":1945.9628216282854},"N"]
["FAZ",null,null,{"$f":"D33+D44","v":1095.3943682754507},"N"]
["FBZ",null,null,{"$f":"(-D33*D39+D32*D12/2)/(D39+D40)","v":-352.79717976908057},"N"]
["FBY",null,null,{"$f":"(D31*D39)/(D39+D40)","v":1945.9628216282854},"N"]
["Hřídel 2"]
["c1",null,null,{"$f":"D39","v":41},"mm"]
["c2",null,null,{"$f":"D40","v":41},"mm"]
["FBX",null,null,{"$f":"F32","v":810.7092463458855},"N"]
["FAY",null,null,{"$f":"F31-D53","v":1907.0435651957196},"N"]
["FAZ",null,null,{"$f":"-F33+D52","v":9454.7098317553682},"N"]
["FBZ",null,null,{"$f":"(F33*D47+F31*F12/2)/(D47+D48)","v":10873.937548839009},"N"]
["FBY",null,null,{"$f":"F31*D47/(D47+D48)","v":1907.0435651957196},"N"]
[null,null,null,"B"]
["Rozmery ložiska A",null,null,{"$f":"'Ložiská '!P6","v":23}]
["Rozmery ložiska B",null,null,{"$f":"'Ložiská '!P7","v":23}]
["Rozmery ložiska E",null,null,{"$f":"'Ložiská '!P16","v":33}]
["Rozmery ložiska F",null,null,{"$f":"'Ložiská '!P17","v":33}]
["počty dielov",null,null,null,null,null,"hmotnost(ocel)"]
["hřídel 1 ⌀",{"$f":"F35","v":29},"x",{"$f":"D39+D40+D55/2+D56/2+2*Výpočty!F35","v":163},"mm",null,{"$f":"(PI()*(B60/2000)^2*(D60/1000)*7850)-(PI()*(Materiály!D11/2000)^2*(D60/1000)*7850)","v":0.84516818099914748}]
["hřídel 2 ⌀",{"$f":"F36","v":53},"x",{"$f":"D47+D48+D58/2+D57/2+2*F36","v":221},"mm",null,{"$f":"(PI()*(B61/2000)^2*(D61/1000)*7850)","v":3.8273973425901069}]
["ozubené kolo 1",null,{"$f":"F3","v":48},"zubov  b=",{"$f":"D11","v":29},"mm",{"$f":"((((PI()*(D12/1000)^2)/4)*(D11/1000))-(((PI()*(F35/1000)^2)/4)*(D11/1000)))*7850","v":0.81838717275899919},null,null,null,null,null,740]
["ozubené kolo 2",null,{"$f":"F4","v":285},"zubov  b=",{"$f":"H11","v":30},"mm",{"$f":"((((PI()*(F12/1000)^2)/4)*(H11/1000))-(((PI()*(F36/1000)^2)/4)*(H11/1000)))*7850","v":34.810493059678386}]
["Bezpečnosť na dotyk",null,null,null,null,null,{"$f":"(PI()*(B64/2000)^2*(D64/1000)*7850)","v":0},null,null,"Bezpečnosť na ohyb"]
[null,null,null,null,null,null,{"$f":"(PI()*(B65/2000)^2*(D65/1000)*7850)","v":0},null,null,"souč. sklonu zubu Yb",null,null,{"$f":"1-L3/(2*PI()/3)","v":0.9},null,null,"Nh",{"$f":"((D11/D25)^2)/(1+D11/D25+(D11/D25)^2)","v":0.88501570284624365}]
["součinitel tvaru  ZH",null,null,null,{"$f":"SQRT((2*COS(L3))/(COS(D15)*COS(D15)*TAN(D16)))","v":2.459648834403787},null,null,null,null,"souč.záběru profilu ea",null,null,{"$f":"(SQRT(D20*D20-D22*D22)+SQRT(F20*F20-F22*F22)-2*F13*SIN(D16))/(2*D23)","v":1.964423316546251}]
["součinitel pružnosti  ZE",null,null,null,189.8," (MPa)1/2",null,null,null,"souč. sklonu zubu Ye",null,null,{"$f":"0.25+(0.75/M66)*COS(E29)^2","v":0.61721821266973764}]
["souč. vlivu záběru  Ze",null,null,null,{"$f":"SQRT((2*D23)/(SQRT(D20*D20-D22*D22)+SQRT(F20*F20-F22*F22)-2*F13*SIN(D16)))","v":0.71348107804070615},null,null,null,null,"jmen. napětí v patě zubu sFO ",null,null,{"$f":"D31/(D11*E9)*3*1.65*M65*M67","v":246.01507401523409}]
["souč. sklonu zubu  Zb",null,null,null,{"$f":"SQRT(COS(L3))","v":0.98901344820674997},null,null,null,null,"napětí v ohybe v patě zubu sF ",null,null,{"$f":"M68*1.5*1.394*E74*E77^Q65","v":540.74010791524086},null,null,null,null,null,1]
["jmenovité napětí v dotyku  σHo",null,null,null,{"$f":"E66*E67*E68*E69*SQRT((D31*(F4/F3))/((F4/F3)*D11*D12))","v":444.80861391582295},"Mpa",null,null,null,"trvalá pevnost  sFlim",null,null,740,"Mpa",null,null,null,null,1.25]
["AA",{"$f":"50+56*(1-D71)","v":76.87882647727335},"BB",{"$f":"0.25*(7-4)^(2/3)","v":0.52002095576297602},null,null,null,null,null,"souč. Bezpečnosti v ohybe SF",null,null,{"$f":"M70/(M68*E73*1.1*1.1)","v":1.7879888743261991},null,null,null,null,null,1.5]
["vmax",{"$f":"((B71+13-7)^(2))/200","v":34.344499391249926},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75]
["souč. vnitřních dyn. sil  KV",null,null,null,{"$f":"((B71+SQRT(200*D24))/B71)^D71","v":1.390336162920113},null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["součinitel  nerovn.  KHa",null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,2.25]
["stredná obvodová sila Fm",null,null,null,{"$f":"D31*E73*1.5","v":8116.6274478235991},"N",null,null,null,null,null,null,null,null,null,null,null,null,2.5]
["odchylka dotykovej krivky FBy",null,null,null,{"$f":"1.33*(0.023*D11/D12)^2*E75/D11+12.44","v":12.470565022399448},"N",null,null,null,null,null,null,null,null,null,null,null,null,2.75]
["součinitel  nerovn.  KHb  ",null,null,null,{"$f":"1+(E76+20)/(2*E75/D11)","v":1.0580072444930362},null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["mez únavy v dotyku  sHlim",null,null,null,1330,"Mpa",null,null,null,null,null,null,null,null,null,null,null,null,3.5]
["Zm",0.92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Zw",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
["Zx",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["SHmin",1.3]
["Součinitel bezpečnosti v dotyku SH",null,null,null,{"$f":"E78/SQRT(E70*E70*1.5*E73*E74*E77)","v":2.0129296281435023}]
[]
[]
["Statická kontrola hřídelů"]
["Hřídel 1",null,null,null,null,"Hřídel 2"]
["Moy",null,{"$f":"D42*D39","v":79784.475686759703},"Nmm",null,"Moy",null,{"$f":"D50*D47","v":78188.786173024506},"Nmm"]
["Moz",null,{"$f":"D43*D39","v":44911.169099293475},"Nmm",null,"Moz",null,{"$f":"D52*D48","v":445831.43950239936},"Nmm"]
["Mored",null,{"$f":"SQRT(C88*C88+C89*C89+E6*E6)","v":170000.33928804344},"Nmm",null,"Mored",null,{"$f":"SQRT(H88*H88+H89*H89+E7*E7)","v":948450.82735034579},"Nmm"]
["Wo dutý",null,{"$f":"((PI()*F35^3)/32)*(1-(L35/F35)^4)","v":2394.3844758875457},"mm3",null,"Wo dutý",null,{"$f":"((PI()*F36^3)/32)*(1-(L36/F36)^4)","v":14615.965296515238},"mm3"]
["Wo plný",null,{"$f":"(PI()*F35*F35*F35)/32","v":2394.3844758875457},"mm3",null,"Wo",null,{"$f":"(PI()*F36*F36*F36)/32","v":14615.96529651524},"mm3"]
["σred",null,{"$f":"C90/C92","v":70.999599688361684},"N/mm2",null,"σred",null,{"$f":"H90/H92","v":64.891425787421426},"N/mm2"]

{"sheet":"Výpočty 2","index":5,"n_rows":91,"n_cols":22,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Návrh hlavných rozmerov"]
["Převodový pomer ip",null,null,null,{"$f":"Vstupy!B7/Vstupy!B6","v":6},null,null,"úhel záběru  α ",null,null,20,"°              =",{"$f":"(K2*PI())/180","v":0.3490658503988659},"rad"]
["Převodový pomer 1-2 ip12",null,null,null,{"$f":"SQRT(E2/1.4)","v":2.0701966780270626},null,null,"úhel sklonu zubu β12 ",null,null,{"$f":"Vstupy!B12","v":12},"°              =",{"$f":"(K3*PI())/180","v":0.20943951023931953},"rad"]
["Převodový pomer 3-4 ip34",null,null,null,{"$f":"1.4*E3","v":2.8982753492378874},null,null,"úhel sklonu zubu β34 ",null,null,{"$f":"Vstupy!B13","v":10},"°              =",{"$f":"(K4*PI())/180","v":0.17453292519943295},"rad"]
["Počet zubů pastroku z1",null,null,null,{"$f":"(Vstupy!B11*2*COS('Výpočty 2'!M3))/(Vstupy!B8*(1+'Výpočty 2'!E3))","v":50.975110890283297},{"$f":"ROUND(E5,0)","v":51},null,"poměrná šířka ozubení ψ",null,null,{"$f":"Vstupy!B14","v":19},null,{"$f":"Vstupy!B15","v":19}]
["Počet zubů kola z2",null,null,null,{"$f":"E5*E3","v":105.52850522712562},{"$f":"ROUND(E6,0)","v":106},null,"radiální vůle",null,null,0.25]
["Počet zubů pastroku z3",null,null,null,{"$f":"((Vstupy!B10-Vstupy!B11)*2*COS('Výpočty 2'!M4))/(Vstupy!B9*(1+'Výpočty 2'!E4))","v":27.283664645728958},{"$f":"ROUND(E7,0)","v":27},null,"účinnost n",null,null,0.98]
["Počet zubů kola z4",null,null,null,{"$f":"E4*E7","v":79.075572679589499},79,null,"Hlavová vůle",null,null,1,null,1]
["Upravený převodový pomer ipu",null,null,null,{"$f":"(F6/F5)*(F8/F7)","v":6.0813362381989844},null,"Upravený převodový pomer i12",null,null,null,{"$f":"F6/F5","v":2.0784313725490198}]
["Krouticí moment na vstup. hřídeli Mk1",null,null,null,{"$f":"(1000*Vstupy!B5*30000)/(PI()*Vstupy!B7)","v":143239.44878270582},"N.mm","Upravený převodový pomer i34",null,null,null,{"$f":"F8/F7","v":2.925925925925926}]
["Krouticí moment na 2. hřídeli Mk2",null,null,null,{"$f":"E10*K9*K7","v":291759.09685387224},"N.mm","Upravené výstupné otáčky nuvyst",null,null,null,{"$f":"Vstupy!B7/E9","v":986.62526868879854}]
["Krouticí moment na výstup. hřídeli Mk3",null,null,null,{"$f":"E11*K10*K7","v":836592.19549728849},"N.mm"]
["Normalizovaný modul mn12  ",null,null,null,{"$f":"Vstupy!B8","v":1.5},{"$f":"(Vstupy!B11*2*COS('Výpočty 2'!M3))/('Výpočty 2'!F5+'Výpočty 2'!F6)","v":1.4952574788287476}]
["Normalizovaný modul mn34  ",null,null,null,{"$f":"Vstupy!B9","v":2.5},{"$f":"((Vstupy!B10-Vstupy!B11)*2*COS('Výpočty 2'!M4))/('Výpočty 2'!F7+'Výpočty 2'!F8)","v":2.5084725784273223}]
[null,null,null,null,"Pastorek 1",null,"Kolo 2",null,"Pastorek 3",null,"Kolo 4"]
["Šířka kola bw",null,null,{"$f":"K5*E13","v":28.5},{"$f":"ROUNDUP(D16,0)","v":29},{"$f":"D16+E13","v":30},{"$f":"ROUNDUP(F16,0)","v":30},{"$f":"M5*E14","v":47.5},{"$f":"ROUNDUP(H16,0)","v":48},{"$f":"H16+E14","v":50},{"$f":"ROUNDUP(J16,0)","v":50}]
["Průměr roztečnej kružnice d",null,null,null,{"$f":"E13*F5/COS(M3)","v":78.209055507174739},"mm",{"$f":"E13*F6/COS(M3)","v":162.55215458353965},"mm",{"$f":"E14*F7/COS(M4)","v":68.54129630228779},"mm",{"$f":"E14*F8/COS(M4)","v":200.54675584743464},"mm"]
["hlavový průměr  da",null,null,null,{"$f":"E17+2*E13+2*E28*E13","v":81.109378676577293},"mm",{"$f":"G17+2*E13+2*G28*E13","v":165.55215458353965},"mm",{"$f":"I17+2*E14+2*I28*E14","v":73.663587556607382},"mm",{"$f":"K17+2*E14+2*K28*E14","v":205.54675584743464},"mm"]
["patní průměr  df",null,null,null,{"$f":"E17-2*E13*(K8+K6)+2*E28*E13","v":74.359378676577293},"mm",{"$f":"G17-2*E13*(K8+K6)+2*G28*E13","v":158.80215458353965},"mm",{"$f":"I17-2*E14*(K8+K6)+2*I28*E14","v":62.413587556607382},"mm",{"$f":"K17-2*E14*(K8+K6)+2*K28*E14","v":194.29675584743464},"mm"]
["základní průmer db",null,null,null,{"$f":"E17*COS(E24)","v":73.299031593937485},"mm",{"$f":"G17*COS(E24)","v":152.34700684230143},"mm",{"$f":"I17*COS(I24)","v":64.290944025135104},"mm",{"$f":"K17*COS(I24)","v":188.1105399253953},"mm"]
["Osová vzdálenost a12",null,null,null,{"$f":"(E17+G17)/2","v":120.38060504535719},"mm",{"$f":"ROUND(E21,0)","v":120},"mm"]
["Osová vzdálenost a34",null,null,null,{"$f":"(I17+K17)/2","v":134.54402607486122},"mm",{"$f":"ROUNDUP(E22,0)","v":135},"mm"]
["Rozdíl osových vzdáleností ",null,null,null,{"$f":"ABS(G21-E21)","v":0.38060504535718565},"mm",{"$f":"ABS(G22-E22)","v":0.45597392513877821},"mm"]
["čelní úhel záběru at",null,null,null,{"$f":"ATAN(TAN(M2)/COS(M3))","v":0.3562271414598594},"rad",null,null,{"$f":"ATAN(TAN(M2)/COS(M4))","v":0.35401489650556855},"rad"]
["valivý úhel záběru aW",null,null,null,{"$f":"ACOS((E21/G21)*COS(E24))","v":0.34760333070834815},"rad",null,null,{"$f":"ACOS((E22/G22)*COS(I24))","v":0.36304359355653926},"rad"]
["inv at",null,null,null,{"$f":"TAN(E24)-E24","v":1.587440435301396E-2},null,null,null,{"$f":"TAN(I24)-I24","v":1.5570165302622174E-2}]
["inv aw",null,null,null,{"$f":"TAN(E25)-E25","v":1.4711517553399167E-2},null,null,null,{"$f":"TAN(I25)-I25","v":1.683806137748961E-2}]
["korekce x1+x2",null,null,{"$f":"((F5+F6)/2*TAN(M2))*(E27-E26)","v":-3.3225610199148332E-2},{"$f":"D28","v":-3.3225610199148332E-2},"mm",0,{"$f":"((F7+F8)/2*TAN(M2))*(I27-I26)","v":2.4458250863919059E-2},{"$f":"H28","v":2.4458250863919059E-2},"mm",0,"mm"]
["základní rozteč pbt",null,null,null,{"$f":"(PI()*'Výpočty 2'!E13*COS('Výpočty 2'!E24))/COS('Výpočty 2'!M2)","v":4.6999854238693368},"mm",null,null,{"$f":"(PI()*E14*COS(I24))/COS('Výpočty 2'!M2)","v":7.8397380878263965},"mm"]
["úhel skolnu zub na zakl valci  βb",null,null,null,{"$f":"ASIN(SIN(M3)*COS(M2))","v":0.19663784832917419},"rad",null,null,{"$f":"ASIN(SIN(M4)*COS(M2))","v":0.16390885824145543},"rad"]
["výška zubu h",null,null,null,{"$f":"E13+1.25*E13","v":3.375},"mm",null,null,{"$f":"E14+1.25*E14","v":5.625}]
["součinitel záběru profilu εα",null,null,null,{"$f":"(0.5*SQRT(E18*E18-E20*E20)+0.5*SQRT(G18*G18-G20*G20)-E21*SIN(E25))/E29","v":1.8621655325022828},null,null,null,{"$f":"(0.5*SQRT(I18*I18-I20*I20)+0.5*SQRT(K18*K18-K20*K20)-E22*SIN(I25))/I29","v":1.4827068992155734}]
["součinitel záběru kroku εβ",null,null,null,{"$f":"E16*SIN(E30)/PI()/E13","v":1.2023242119961839},null,null,null,{"$f":"I16*SIN(I30)/PI()/E14","v":0.99725770965803573}]
["součinitel záběru  ε",null,null,null,{"$f":"E32+E33","v":3.0644897444984665},null,null,null,{"$f":"I32+I33","v":2.4799646088736091}]
["obvodová rychlost  v",null,null,null,{"$f":"(PI()*Vstupy!B7*'Výpočty 2'!E18)/60000","v":25.481262818756786},null,null,null,{"$f":"(PI()*Vstupy!B7*'Výpočty 2'!I17)/60000","v":21.532883293078854}]
["Silové pomery",null,null,null,"Pastorek 1",null,"Kolo 2",null,"Pastorek 3",null,"Kolo 4"]
["Tečná síla Ft",null,null,null,{"$f":"2*E10/E17","v":3662.9888407120661},"N",{"$f":"2*E11/G17","v":3589.7290638978261},"N",{"$f":"2*E11/I17","v":8513.3813509194988},"N",{"$f":"2*E12/K17","v":8343.1137239011096},"N"]
["Axiální síla Fa",null,null,null,{"$f":"E37*TAN(M3)","v":778.59231341741702},"N",{"$f":"G37*TAN(M3)","v":763.02046714906896},"N",{"$f":"I37*TAN(M4)","v":1501.138829227388},"N",{"$f":"K37*TAN(M4)","v":1471.1160526428403},"N"]
["Radiální síla Fr",null,null,null,{"$f":"E37*TAN(M2)/COS(M3)","v":1363.0038099242645},"N",{"$f":"G37*TAN(M2)/COS(M3)","v":1335.74373372578},"N",{"$f":"I37*TAN(M2)/COS(M4)","v":3146.4185727762811},"N",{"$f":"K37*TAN(M2)/COS(M4)","v":3083.4902013207561},"N"]
["Průměry hřídelů",null,null,null,null,null,null,null,"Tau d"]
["Průměr vstupního hřídele d1",null,null,null,{"$f":"((16*E10)/(PI()*I41))^(1/3)","v":28.971467804951779},"mm         =",{"$f":"ROUNDUP(E41,0)","v":29},"mm",30]
["Průměr předlohového hřídele d2",null,null,null,{"$f":"((16*E11)/(PI()*I42))^(1/3)","v":36.724657461594155},"mm         =",{"$f":"ROUNDUP(E42,0)","v":37},"mm",30]
["Průměr výstupního hřídele d3",null,null,null,{"$f":"((16*E12)/(PI()*I43))^(1/3)","v":52.174010509654451},"mm         =",53,"mm",30]
["Reakčné síly"]
["Hřídel 1",null,null,"Hřídel 2",null,null,"Hřídel 3"]
["a1",{"$f":"D56/2+15+E16/2","v":41},null,"b1",{"$f":"B46","v":41},null,"c1",{"$f":"E46+E47","v":90}]
["a2",{"$f":"E47+E48","v":100.5},null,"b2",{"$f":"G16/2+I16/2+10","v":49},null,"c2",{"$f":"D61/2+10+K16/2","v":51.5}]
["FAX",{"$f":"E38","v":778.59231341741702},"N","b3",{"$f":"H47","v":51.5},null,"FBX",{"$f":"K38","v":1471.1160526428403},"N"]
["FAY",{"$f":"E39-B52","v":968.06984379779919},"N","FAX",{"$f":"I38-G38","v":738.11836207831902},"N","FAY",{"$f":"K37-H52","v":3036.5396238933363},"N"]
["FAZ",{"$f":"E39+B51","v":1183.2393471812704},"N","FAY",{"$f":"I37+G37-E53","v":5648.1053745165082},"N","FAZ",{"$f":"-K39+H51","v":-79.759501425556209},"N"]
["FBZ",{"$f":"((-E39*B46)+(E38*(E17/2)))/(B46+B47)","v":-179.76446274299406},"N","FAZ",{"$f":"-G39+I39+E52","v":998.2941509838837},"N","FBZ",{"$f":"(K39*H46+K38*K17/2)/(H46+H47)","v":3003.7306998951999},"N"]
["FBY",{"$f":"(E39*B46)/(B46+B47)","v":394.93396612646529},"N","FBZ",{"$f":"(-I39*(E46+E47)+G39*E46+I38*I17/2+G38*G17/2)/(E46+E47+E48)","v":-812.38068806661738},"N","FBY",{"$f":"(K37*H46)/(H46+H47)","v":5306.5741000077733},"N"]
[null,null,null,"FBY",{"$f":"(G37*E46+I37*(E46+E47))/(E46+E47+E48)","v":6455.0050403008172},"N"]
[]
[null,null,null,"B",null,"D"]
["Rozmery ložiska A",null,null,{"$f":"'Ložiská '!W6","v":23}]
["Rozmery ložiska B",null,null,{"$f":"'Ložiská '!W7","v":23}]
["Rozmery ložiska C",null,null,{"$f":"'Ložiská '!W11","v":27}]
["Rozmery ložiska D",null,null,{"$f":"'Ložiská '!W12","v":33}]
["Rozmery ložiska E",null,null,{"$f":"'Ložiská '!W16","v":21}]
["Rozmery ložiska F",null,null,{"$f":"'Ložiská '!W17","v":33}]
[]
["Statická kontrola hřídelů"]
["Hřídel 1",null,null,null,null,"Hřídel 2",null,null,null,null,"Hřídel 3"]
["Moy",null,{"$f":"B49*B46","v":39690.863595709765},"Nmm",null,"Moy",null,{"$f":"E53*E48","v":332432.75957549206},"Nmm",null,"Moy",null,{"$f":"H49*H46","v":273288.56615040026},"Nmm"]
["Moz",null,{"$f":"B50*B46","v":48512.813234432091},"Nmm",null,"Moz",null,{"$f":"E52*E48+I38*I17/2","v":9607.3952070411033},"Nmm",null,"Moz",null,{"$f":"H51*H47","v":154692.13104460281},"Nmm"]
["Mored",null,{"$f":"SQRT(C65*C65+C66*C66+E10*E10)","v":156353.43740533985},"Nmm",null,"Mored",null,{"$f":"SQRT(H65*H65+H66*H66+E11*E11)","v":442410.68282606872},"Nmm",null,"Mored",null,{"$f":"SQRT(M65*M65+M66*M66+E12*E12)","v":893589.83732058841},"Nmm"]
["Wo dutý",null,{"$f":"((PI()*G41^3)/32)*(1-(K41/G41)^4)","v":2394.3844758875457},"mm3",null,"Wo dutý",null,{"$f":"((PI()*G42^3)/32)*(1-(K42/G42)^4)","v":4972.8466463213681},"mm3",null,"Wo dutý",null,{"$f":"((PI()*G43^3)/32)*(1-(K43/G43)^4)","v":14615.965296515238},"mm3"]
["Wo plný",null,{"$f":"(PI()*G41*G41*G41)/32","v":2394.3844758875457},"mm3",null,"Wo",null,{"$f":"(PI()*G42*G42*G42)/32","v":4972.846646321369},"mm3",null,"Wo",null,{"$f":"(PI()*G43*G43*G43)/32","v":14615.96529651524},"mm3"]
["σred",null,{"$f":"C67/C69","v":65.300054765591923},"N/mm2",null,"σred",null,{"$f":"H67/H69","v":88.965277695289302},"N/mm2",null,"σred",null,{"$f":"M67/M69","v":61.137928230688907},"N/mm2"]
[]
["Bezpečnosť na dotyk",null,null,null,null,null,null,null,null,null,"Bezpečnosť na ohyb"]
["1. soukolí",null,null,null,null,"2. soukolí",null,null,null,null,"1.soukolí",null,null,null,null,"2.soukolí"]
["součinitel tvaru  ZH",null,null,null,{"$f":"SQRT((2*COS(E30))/(COS(E24)*COS(E24)*TAN(E25)))","v":2.482591380399092},"součinitel tvaru  ZH",null,null,null,{"$f":"SQRT((2*COS(I30))/(COS(I24)*COS(I24)*TAN(I25)))","v":2.4297592347820833},"souč. sklonu zubu Yb",null,null,{"$f":"1-M3/(2*PI()/3)","v":0.9},null,"souč. sklonu zubu Yb",null,null,{"$f":"1-M4/(2*PI()/3)","v":0.91666666666666663}]
["součinitel pružnosti  ZE",null,null,null,189.8,"součinitel pružnosti  ZE",null,null,null,189.8,"souč.záběru profilu ea",null,null,{"$f":"(SQRT(E18*E18-E20*E20)+SQRT(G18*G18-G20*G20)-2*E21*SIN(E25))/(2*E29)","v":1.8621655325022828},null,"souč.záběru profilu ea",null,null,{"$f":"(SQRT(I18*I18-I20*I20)+SQRT(K18*K18-K20*K20)-2*E22*SIN(I25))/(2*I29)","v":1.4827068992155734}]
["souč. vlivu záběru  Ze",null,null,null,{"$f":"SQRT(1/E32)","v":0.73280910728172743},"souč. vlivu záběru  Ze",null,null,null,{"$f":"SQRT((2*I29)/(SQRT(I18*I18-I20*I20)+SQRT(K18*K18-K20*K20)-2*E22*SIN(I25)))","v":0.82124425750842101},"souč. sklonu zubu Ye",null,null,{"$f":"1/N75","v":0.53700918771504225},null,"souč. sklonu zubu Ye",null,null,{"$f":"1/S75","v":0.67444213049055768},null,null,"^"]
["souč. sklonu zubu  Zb",null,null,null,{"$f":"SQRT(COS(M3))","v":0.98901344820674997},"souč. sklonu zubu  Zb",null,null,null,{"$f":"SQRT(COS(M4))","v":0.99237480470445638},"jmen. napětí v patě zubu sFO ",null,null,{"$f":"(E37/(E16*E13))*2.3*1.7*N74*N76","v":159.12826279166478},null,"jmen. napětí v patě zubu sFO ",null,null,{"$f":"I37/(I16*E14)*2.3*1.65*S74*S76","v":166.45189838362253}]
["jmenovité napětí v dotyku  σHo",null,null,null,{"$f":"E74*E75*E76*E77*SQRT((E37*(F6/F5))/((F6/F5)*E16*E17))","v":433.99505846833091},"jmenovité napětí v dotyku  σHo",null,null,null,{"$f":"J74*J75*J77*J76*SQRT((I37*(F8/F7))/((F8/F7)*I16*I17))","v":604.59116025797596},"Nh",null,null,{"$f":"((E16/E31)^2)/(1+(E16/E31)+(E16/E31)^2)","v":0.88501570284624365},null,"Nh",null,null,{"$f":"((I16/I31)^2)/(1+(I16/I31)+(I16/I31)^2)","v":0.88423552269415517}]
["AA",{"$f":"50+56*(1-D79)","v":76.87882647727335},"BB",{"$f":"0.25*(7-4)^(2/3)","v":0.52002095576297602},null,"AA",{"$f":"50+56*(1-I79)","v":76.87882647727335},"BB",{"$f":"0.25*(7-4)^(2/3)","v":0.52002095576297602},null,"napětí v ohybe v patě zubu sF ",null,null,{"$f":"N77*1.5*1.394*E82*E85^N78","v":350.60620874296973},null,"napětí v ohybe v patě zubu sF ",null,null,{"$f":"S77*1.5*1.394*E82*E85^S78","v":366.72541312442308}]
["vmax",{"$f":"((B79+13-7)^(2))/200","v":34.344499391249926},null,null,null,"vmax",{"$f":"((G79+13-7)^(2))/200","v":34.344499391249926},null,null,null,"trvalá pevnost  sFlim",null,null,740,null,"trvalá pevnost  sFlim",null,null,740]
["souč. vnitřních dyn. sil  KV",null,null,null,{"$f":"((B79+SQRT(200*E35))/B79)^D79","v":1.407114407448363},"souč. vnitřních dyn. sil  KV",null,null,null,{"$f":"((B79+SQRT(200*I35))/B79)^D79","v":1.3783995737080577},"souč. Bezpečnosti v ohybe SF",null,null,{"$f":"N80/(N77*E81*1.2*1.1)","v":2.5036928963356559},null,"souč. Bezpečnosti v ohybe SF",null,null,{"$f":"S80/(S77*J81*1.1*1.1)","v":2.6655231986370898}]
["součinitel  nerovn.  KHa",null,null,null,1,"součinitel  nerovn.  KHa",null,null,null,1]
["stredná obvodová sila Fm",null,null,null,{"$f":"E37*E81*1.5","v":7731.3665581327878},"stredná obvodová sila Fm",null,null,null,{"$f":"I37*J81*1.5","v":17602.26183738235}]
["odchylka dotykovej krivky FBy",null,null,null,{"$f":"1.33*(0.023*E16/E17)^2*E83/E16+12.44","v":12.465789771427362},"odchylka dotykovej krivky FBy",null,null,null,{"$f":"1.33*(0.023*I16/I17)^2*J83/I16+12.44","v":12.566535504096811}]
["součinitel  nerovn.  KHb  ",null,null,null,{"$f":"1+(E84+20)/(2*E83/E16)","v":1.0608888413382109},"součinitel  nerovn.  KHb  ",null,null,null,{"$f":"1+(J84+20)/(2*J83/I16)","v":1.0444032056402222}]
["mez únavy v dotyku  sHlim",null,null,null,1330,"mez únavy v dotyku  sHlim",null,null,null,1330]
["Zm",0.92,null,null,null,"Zm",0.92]
["Zw",1,null,null,null,"Zw",1]
["Zx",1,null,null,null,"Zx",1]
["SHmin",1.3,null,null,null,"SHmin",1.3]
["Součinitel bezpečnosti v dotyku SH",null,null,null,{"$f":"E86/SQRT(E78*E78*1.5*E81*E82*E85)","v":2.0479605249213431},"Součinitel bezpečnosti v dotyku SH",null,null,null,{"$f":"J86/SQRT(J78*J78*1.5*J81*J82*J85)","v":1.4970026021086149}]

{"sheet":" Výpočty 3","index":6,"n_rows":91,"n_cols":22,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Návrh hlavných rozmerov"]
["Převodový pomer ip",null,null,null,{"$f":"Vstupy!B7/Vstupy!B6","v":6},null,null,"úhel záběru  α ",null,null,20,"°              =",{"$f":"(K2*PI())/180","v":0.3490658503988659},"rad"]
["Převodový pomer 1-2 ip12",null,null,null,{"$f":"SQRT(E2/1.4)","v":2.0701966780270626},null,null,"úhel sklonu zubu β12 ",null,null,{"$f":"Vstupy!B12","v":12},"°              =",{"$f":"(K3*PI())/180","v":0.20943951023931953},"rad"]
["Převodový pomer 3-4 ip34",null,null,null,{"$f":"1.4*E3","v":2.8982753492378874},null,null,"úhel sklonu zubu β34 ",null,null,{"$f":"Vstupy!B13","v":10},"°              =",{"$f":"(K4*PI())/180","v":0.17453292519943295},"rad"]
["Počet zubů pastroku z1",null,null,null,{"$f":"(Vstupy!B11*2*COS(' Výpočty 3'!M3))/(Vstupy!B8*(1+' Výpočty 3'!E3))","v":50.975110890283297},{"$f":"ROUND(E5,0)","v":51},null,"poměrná šířka ozubení ψ",null,null,{"$f":"Vstupy!B14","v":19},null,{"$f":"Vstupy!B15","v":19}]
["Počet zubů kola z2",null,null,null,{"$f":"E5*E3","v":105.52850522712562},{"$f":"ROUND(E6,0)","v":106},null,"radiální vůle",null,null,0.25]
["Počet zubů pastroku z3",null,null,null,{"$f":"(Vstupy!B11*2*COS(' Výpočty 3'!M4))/(Vstupy!B9*(1+' Výpočty 3'!E4))","v":24.252146351759077},{"$f":"ROUND(E7,0)","v":24},null,"účinnost n",null,null,0.98]
["Počet zubů kola z4",null,null,null,{"$f":"E4*E7","v":70.2893979374129},70,null,"Hlavová vůle",null,null,1,null,1]
["Upravený převodový pomer ipu",null,null,null,{"$f":"(F6/F5)*(F8/F7)","v":6.0620915032679736},null,"Upravený převodový pomer i12",null,null,null,{"$f":"F6/F5","v":2.0784313725490198}]
["Krouticí moment na vstup. hřídeli Mk1",null,null,null,{"$f":"(1000*Vstupy!B5*30000)/(PI()*Vstupy!B7)","v":143239.44878270582},"N.mm","Upravený převodový pomer i34",null,null,null,{"$f":"F8/F7","v":2.9166666666666665}]
["Krouticí moment na 2. hřídeli Mk2",null,null,null,{"$f":"E10*K9*K7","v":291759.09685387224},"N.mm","Upravené výstupné otáčky nuvyst",null,null,null,{"$f":"Vstupy!B7/E9","v":989.75741239892182}]
["Krouticí moment na výstup. hřídeli Mk3",null,null,null,{"$f":"E11*K10*K7","v":833944.75184065138},"N.mm"]
["Upravený modul mn12  ",null,null,null,{"$f":"Vstupy!B8","v":1.5}]
["Upravený modul mn34  ",null,null,null,{"$f":"Vstupy!B9","v":2.5}]
[null,null,null,null,"Pastorek 1",null,"Kolo 2",null,"Pastorek 3",null,"Kolo 4"]
["Šířka kola bw",null,null,{"$f":"K5*E13","v":28.5},{"$f":"ROUNDUP(D16,0)","v":29},{"$f":"D16+E13","v":30},{"$f":"ROUNDUP(F16,0)","v":30},{"$f":"M5*E14","v":47.5},{"$f":"ROUNDUP(H16,0)","v":48},{"$f":"H16+E14","v":50},{"$f":"ROUNDUP(J16,0)","v":50}]
["Průměr roztečnej kružnice d",null,null,null,{"$f":"E13*F5/COS(M3)","v":78.209055507174739},"mm",{"$f":"E13*F6/COS(M3)","v":162.55215458353965},"mm",{"$f":"E14*F7/COS(M4)","v":60.925596713144699},"mm",{"$f":"E14*F8/COS(M4)","v":177.69965708000538},"mm"]
["hlavový průměr  da",null,null,null,{"$f":"E17+2*E13+2*E28*E13","v":81.109378676577293},"mm",{"$f":"G17+2*E13+2*G28*E13","v":165.55215458353965},"mm",{"$f":"I17+2*E14+2*I28*E14","v":66.111482224475068},"mm",{"$f":"K17+2*E14+2*K28*E14","v":182.69965708000538},"mm"]
["patní průměr  df",null,null,null,{"$f":"E17-2*E13*(K8+K6)+2*E28*E13","v":74.359378676577293},"mm",{"$f":"G17-2*E13*(K8+K6)+2*G28*E13","v":158.80215458353965},"mm",{"$f":"I17-2*E14*(K8+K6)+2*I28*E14","v":54.861482224475068},"mm",{"$f":"K17-2*E14*(K8+K6)+2*K28*E14","v":171.44965708000538},"mm"]
["základní průmer db",null,null,null,{"$f":"E17*COS(E24)","v":73.299031593937485},"mm",{"$f":"G17*COS(E24)","v":152.34700684230143},"mm",{"$f":"I17*COS(I24)","v":57.147505800120086},"mm",{"$f":"K17*COS(I24)","v":166.68022525035028},"mm"]
["Osová vzdálenost a12",null,null,null,{"$f":"(E17+G17)/2","v":120.38060504535719},"mm",{"$f":"ROUND(E21,0)","v":120},"mm",null,null,null,null,null,{"$f":"SIN(E25)","v":0.34064545907037624}]
["Osová vzdálenost a34",null,null,null,{"$f":"(I17+K17)/2","v":119.31262689657504},"mm",{"$f":"ROUNDUP(E22,0)","v":120},"mm"]
["Rozdíl osových vzdáleností ",null,null,null,{"$f":"ABS(G21-E21)","v":0.38060504535718565},"mm",{"$f":"ABS(G22-E22)","v":0.68737310342496016},"mm"]
["čelní úhel záběru at",null,null,null,{"$f":"ATAN(TAN(M2)/COS(M3))","v":0.3562271414598594},"rad",null,null,{"$f":"ATAN(TAN(M2)/COS(M4))","v":0.35401489650556855},"rad",null,null,null,{"$f":"I25*180/PI()","v":21.153727786188295}]
["valivý úhel záběru aW",null,null,null,{"$f":"ACOS((E21/G21)*COS(E24))","v":0.34760333070834815},"rad",null,null,{"$f":"ACOS((E22/G22)*COS(I24))","v":0.36920219893959683},"rad"]
["inv at",null,null,null,{"$f":"TAN(E24)-E24","v":1.587440435301396E-2},null,null,null,{"$f":"TAN(I24)-I24","v":1.5570165302622174E-2}]
["inv aw",null,null,null,{"$f":"TAN(E25)-E25","v":1.4711517553399167E-2},null,null,null,{"$f":"TAN(I25)-I25","v":1.7743425919575229E-2}]
["korekce x1+x2",null,null,{"$f":"((F5+F6)/2*TAN(M2))*(E27-E26)","v":-3.3225610199148332E-2},{"$f":"D28","v":-3.3225610199148332E-2},"mm",0,{"$f":"((F7+F8)/2*TAN(M2))*(I27-I26)","v":3.7177102266073993E-2},{"$f":"H28","v":3.7177102266073993E-2},"mm",0,"mm"]
["základní rozteč pbt",null,null,null,{"$f":"(PI()*' Výpočty 3'!E13*COS(' Výpočty 3'!E24))/COS(' Výpočty 3'!M2)","v":4.6999854238693368},"mm",null,null,{"$f":"(PI()*E14*COS(I24))/COS(' Výpočty 3'!M2)","v":7.8397380878263965},"mm"]
["úhel skolnu zub na zakl valci  βb",null,null,null,{"$f":"ASIN(SIN(M3)*COS(M2))","v":0.19663784832917419},"rad",null,null,{"$f":"ASIN(SIN(M4)*COS(M2))","v":0.16390885824145543},"rad"]
["výška zubu h",null,null,null,{"$f":"E13+1.25*E13","v":3.375},"mm",null,null,{"$f":"E14+1.25*E14","v":5.625}]
["součinitel záběru profilu εα",null,null,null,{"$f":"(0.5*SQRT(E18*E18-E20*E20)+0.5*SQRT(G18*G18-G20*G20)-E21*SIN(E25))/E29","v":1.8621655325022828},null,null,null,{"$f":"(0.5*SQRT(I18*I18-I20*I20)+0.5*SQRT(K18*K18-K20*K20)-E22*SIN(I25))/I29","v":1.3992211118304745}]
["součinitel záběru kroku εβ",null,null,null,{"$f":"E16*SIN(E30)/PI()/E13","v":1.2023242119961839},null,null,null,{"$f":"I16*SIN(I30)/PI()/E14","v":0.99725770965803573}]
["součinitel záběru  ε",null,null,null,{"$f":"E32+E33","v":3.0644897444984665},null,null,null,{"$f":"I32+I33","v":2.3964788214885102}]
["obvodová rychlost  v",null,null,null,{"$f":"(PI()*Vstupy!B7*' Výpočty 3'!E18)/60000","v":25.481262818756786},null,null,null,{"$f":"(PI()*Vstupy!B7*' Výpočty 3'!I17)/60000","v":19.140340704958984}]
["Silové pomery",null,null,null,"Pastorek 1",null,"Kolo 2",null,"Pastorek 3",null,"Kolo 4"]
["Tečná síla Ft",null,null,null,{"$f":"2*E10/E17","v":3662.9888407120661},"N",{"$f":"2*E11/G17","v":3589.7290638978261},"N",{"$f":"2*E11/I17","v":9577.5540197844366},"N",{"$f":"2*E12/K17","v":9386.0029393887471},"N"]
["Axiální síla Fa",null,null,null,{"$f":"E37*TAN(M3)","v":778.59231341741702},"N",{"$f":"G37*TAN(M3)","v":763.02046714906896},"N",{"$f":"I37*TAN(M4)","v":1688.7811828808115},"N",{"$f":"K37*TAN(M4)","v":1655.0055592231952},"N"]
["Radiální síla Fr",null,null,null,{"$f":"E37*TAN(M2)/COS(M3)","v":1363.0038099242645},"N",{"$f":"G37*TAN(M2)/COS(M3)","v":1335.74373372578},"N",{"$f":"I37*TAN(M2)/COS(M4)","v":3539.7208943733167},"N",{"$f":"K37*TAN(M2)/COS(M4)","v":3468.9264764858499},"N"]
["Průměry hřídelů",null,null,null,null,null,null,null,"Tau d"]
["Průměr vstupního hřídele d1",null,null,null,{"$f":"((16*E10)/(PI()*I41))^(1/3)","v":28.971467804951779},"mm         =",{"$f":"ROUNDUP(E41,0)","v":29},"mm",30]
["Průměr předlohového hřídele d2",null,null,null,{"$f":"((16*E11)/(PI()*I42))^(1/3)","v":36.724657461594155},"mm         =",{"$f":"ROUNDUP(E42,0)","v":37},"mm",30]
["Průměr výstupního hřídele d3",null,null,null,{"$f":"((16*E12)/(PI()*I43))^(1/3)","v":52.118916476586755},"mm         =",{"$f":"ROUNDUP(E43,0)","v":53},"mm",30]
["Reakčné síly"]
["Hřídel 1",null,null,"Hřídel 2",null,null,"Hřídel 3"]
["a1",{"$f":"D56/2+15+E16/2","v":41},null,"b1",{"$f":"B46","v":41},null,"c1",{"$f":"I16/2+15+D60/2","v":55.5}]
["a2",{"$f":"E16/2+15+D57/2","v":41},null,"b2",{"$f":"B47+H46+D57/2+D60/2+15","v":139.5},null,"c2",{"$f":"D61/2+15+K16/2","v":50.5}]
["FAX",{"$f":"E38","v":778.59231341741702},"N","b3",{"$f":"H47","v":50.5},null,"FBX",{"$f":"K38","v":1655.0055592231952},"N"]
["FAY",{"$f":"E39-B52","v":681.50190496213224},"N","FAX",{"$f":"I38-G38","v":925.76071573174249},"N","FAY",{"$f":"K37-H52","v":4471.6334758408648},"N"]
["FAZ",{"$f":"E39+B51","v":1052.8004992153174},"N","FAY",{"$f":"I37+G37-E53","v":5046.3852819900485},"N","FAZ",{"$f":"-K39+H51","v":-265.413461252861},"N"]
["FBZ",{"$f":"((-E39*B46)+(E38*(E17/2)))/(B46+B47)","v":-310.20331070894707},"N","FAZ",{"$f":"-G39+I39+E52","v":166.34158815426986},"N","FBZ",{"$f":"(K39*H46+K38*K17/2)/(H46+H47)","v":3203.5130152329889},"N"]
["FBY",{"$f":"(E39*B46)/(B46+B47)","v":681.50190496213224},"N","FBZ",{"$f":"(-I39*(E46+E47)+G39*E46+I38*I17/2+G38*G17/2)/(E46+E47+E48)","v":-2037.6355724932671},"N","FBY",{"$f":"(K37*H46)/(H46+H47)","v":4914.3694635478823},"N"]
[null,null,null,"FBY",{"$f":"(G37*E46+I37*(E46+E47))/(E46+E47+E48)","v":8120.8978016922147},"N"]
[]
[null,null,null,"B",null,"D"]
["Rozmery ložiska A",null,null,{"$f":"'Ložiská '!AD6","v":23}]
["Rozmery ložiska B",null,null,{"$f":"'Ložiská '!AD7","v":23}]
["Rozmery ložiska C",null,null,{"$f":"'Ložiská '!AD11","v":27}]
["Rozmery ložiska D",null,null,{"$f":"'Ložiská '!AD12","v":33}]
["Rozmery ložiska E",null,null,{"$f":"'Ložiská '!AD16","v":33}]
["Rozmery ložiska F",null,null,{"$f":"'Ložiská '!AD17","v":21}]
[]
["Statická kontrola hřídelů"]
["Hřídel 1",null,null,null,null,"Hřídel 2",null,null,null,null,"Hřídel 3"]
["Moy",null,{"$f":"B49*B46","v":27941.57810344742},"Nmm",null,"Moy",null,{"$f":"E53*E48","v":410105.33898545685},"Nmm",null,"Moy",null,{"$f":"H49*H46","v":248175.65790916799},"Nmm"]
["Moz",null,{"$f":"B50*B46","v":43164.820467828009},"Nmm",null,"Moz",null,{"$f":"E52*E48+I38*I17/2","v":-51455.595768438099},"Nmm",null,"Moz",null,{"$f":"H51*H47","v":161777.40726926594},"Nmm"]
["Mored",null,{"$f":"SQRT(C65*C65+C66*C66+E10*E10)","v":152188.93915296302},"Nmm",null,"Mored",null,{"$f":"SQRT(H65*H65+H66*H66+E11*E11)","v":505922.36360656028},"Nmm",null,"Mored",null,{"$f":"SQRT(M65*M65+M66*M66+E12*E12)","v":885001.09367388918},"Nmm"]
["Wo dutý",null,{"$f":"((PI()*G41^3)/32)*(1-(K41/G41)^4)","v":2394.3844758875457},"mm3",null,"Wo dutý",null,{"$f":"((PI()*G42^3)/32)*(1-(K42/G42)^4)","v":4972.8466463213681},"mm3",null,"Wo dutý",null,{"$f":"((PI()*G43^3)/32)*(1-(K43/G43)^4)","v":14615.965296515238},"mm3"]
["Wo plný",null,{"$f":"(PI()*G41*G41*G41)/32","v":2394.3844758875457},"mm3",null,"Wo",null,{"$f":"(PI()*G42*G42*G42)/32","v":4972.846646321369},"mm3",null,"Wo",null,{"$f":"(PI()*G43*G43*G43)/32","v":14615.96529651524},"mm3"]
["σred",null,{"$f":"C67/C69","v":63.56077759673493},"N/mm2",null,"σred",null,{"$f":"H67/H69","v":101.73697272181379},"N/mm2",null,"σred",null,{"$f":"M67/M69","v":60.550300696519336},"N/mm2"]
[]
["Bezpečnosť na dotyk",null,null,null,null,null,null,null,null,null,"Bezpečnosť na ohyb"]
["1. soukolí",null,null,null,null,"2. soukolí",null,null,null,null,"1.soukolí",null,null,null,null,"2.soukolí"]
["součinitel tvaru  ZH",null,null,null,{"$f":"SQRT((2*COS(E30))/(COS(E24)*COS(E24)*TAN(E25)))","v":2.482591380399092},"součinitel tvaru  ZH",null,null,null,{"$f":"SQRT((2*COS(I30))/(COS(I24)*COS(I24)*TAN(I25)))","v":2.407478580262215},"souč. sklonu zubu Yb",null,null,{"$f":"1-M3/(2*PI()/3)","v":0.9},null,"souč. sklonu zubu Yb",null,null,{"$f":"1-M4/(2*PI()/3)","v":0.91666666666666663}]
["součinitel pružnosti  ZE",null,null,null,189.8,"součinitel pružnosti  ZE",null,null,null,189.8,"souč.záběru profilu ea",null,null,{"$f":"E32","v":1.8621655325022828},null,"souč.záběru profilu ea",null,null,{"$f":"(SQRT(I18*I18-I20*I20)+SQRT(K18*K18-K20*K20)-2*E22*SIN(I25))/(2*I29)","v":1.3992211118304745}]
["souč. vlivu záběru  Ze",null,null,null,{"$f":"SQRT(1/E32)","v":0.73280910728172743},"souč. vlivu záběru  Ze",null,null,null,{"$f":"SQRT(1/I32)","v":0.84538945310459679},"souč. sklonu zubu Ye",null,null,{"$f":"1/N75","v":0.53700918771504225},null,"souč. sklonu zubu Ye",null,null,{"$f":"0.25+0.75/S75*(COS(I30)^2)","v":0.77174042425374478},null,null,"^"]
["souč. sklonu zubu  Zb",null,null,null,{"$f":"SQRT(COS(M3))","v":0.98901344820674997},"souč. sklonu zubu  Zb",null,null,null,{"$f":"SQRT(COS(M4))","v":0.99237480470445638},"jmen. napětí v patě zubu sFO ",null,null,{"$f":"(E37/(E16*E13))*2.2*1.65*N74*N76","v":147.73288847410311},null,"jmen. napětí v patě zubu sFO ",null,null,{"$f":"I37/(I16*E14)*2.2*1.65*S74*S76","v":204.95696327047642}]
["jmenovité napětí v dotyku  σHo",null,null,null,{"$f":"E74*E75*E76*E77*SQRT((E37*(F6/F5))/((F6/F5)*E16*E17))","v":433.99505846833091},"jmenovité napětí v dotyku  σHo",null,null,null,{"$f":"J74*J75*J77*J76*SQRT((I37*(F8/F7))/((F8/F7)*I16*I17))","v":693.74199591411218},"Nh",null,null,{"$f":"((E16/E31)^2)/(1+(E16/E31)+(E16/E31)^2)","v":0.88501570284624365},null,"Nh",null,null,{"$f":"((I16/I31)^2)/(1+(I16/I31)+(I16/I31)^2)","v":0.88423552269415517}]
["AA",{"$f":"50+56*(1-D79)","v":76.87882647727335},"BB",{"$f":"0.25*(7-4)^(2/3)","v":0.52002095576297602},null,"AA",{"$f":"50+56*(1-I79)","v":76.87882647727335},"BB",{"$f":"0.25*(7-4)^(2/3)","v":0.52002095576297602},null,"napětí v ohybe v patě zubu sF ",null,null,{"$f":"N77*1.5*1.394*E82*E85^N78","v":325.49885875626092},null,"napětí v ohybe v patě zubu sF ",null,null,{"$f":"S77*1.5*1.394*E82*E85^S78","v":451.55944605007926}]
["vmax",{"$f":"((B79+13-7)^(2))/200","v":34.344499391249926},null,null,1330,"vmax",{"$f":"((G79+13-7)^(2))/200","v":34.344499391249926},null,null,1330,"trvalá pevnost  sFlim",null,null,740,null,"trvalá pevnost  sFlim",null,null,740]
["souč. vnitřních dyn. sil  KV",null,null,null,{"$f":"((B79+SQRT(200*E35))/B79)^D79","v":1.407114407448363},"souč. vnitřních dyn. sil  KV",null,null,null,{"$f":"((B79+SQRT(200*I35))/B79)^D79","v":1.3594003083781208},"souč. Bezpečnosti v ohybe SF",null,null,{"$f":"N80/(N77*E81*1.2*1.1)","v":2.6968152134083789},null,"souč. Bezpečnosti v ohybe SF",null,null,{"$f":"S80/(S77*J81*1.1*1.1)","v":2.1950090114821488}]
["součinitel  nerovn.  KHa",null,null,null,1,"součinitel  nerovn.  KHa",null,null,null,1]
["stredná obvodová sila Fm",null,null,null,{"$f":"E37*E81*1.5","v":7731.3665581327878},"stredná obvodová sila Fm",null,null,null,{"$f":"I37*J81*1.5","v":19529.594832004612}]
["odchylka dotykovej krivky FBy",null,null,null,{"$f":"1.33*(0.023*E16/E17)^2*E83/E16+12.44","v":12.465789771427362},"odchylka dotykovej krivky FBy",null,null,null,{"$f":"1.33*(0.023*I16/I17)^2*J83/I16+12.44","v":12.617681495500083}]
["součinitel  nerovn.  KHb  ",null,null,null,{"$f":"1+(E84+20)/(2*E83/E16)","v":1.0608888413382109},"součinitel  nerovn.  KHb  ",null,null,null,{"$f":"1+(J84+20)/(2*J83/I16)","v":1.0400840039246042}]
["mez únavy v dotyku  sHlim",null,null,null,1330,"mez únavy v dotyku  sHlim",null,null,null,1330]
["Zm",0.92,null,null,null,"Zm",0.92]
["Zw",1,null,null,null,"Zw",1]
["Zx",1,null,null,null,"Zx",1]
["SHmin",1.3,null,null,null,"SHmin",1.3]
["Součinitel bezpečnosti v dotyku SH",null,null,null,{"$f":"E86/SQRT(E78*E78*1.5*E81*E82*E85)","v":2.0479605249213431},"Součinitel bezpečnosti v dotyku SH",null,null,null,{"$f":"J86/SQRT(J78*J78*1.5*J81*J82*J85)","v":1.3164371673203301}]