{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabulka výsledných hodnot","Výpočet"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":33,"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":"Tabulka výsledných hodnot","index":0,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,3,0,13],[45,0,45,13],[46,3,46,13],[17,0,17,13],[18,2,18,13],[31,2,31,13],[25,2,25,13],[40,3,40,13],[19,3,19,13]]}
["Veličina","symbol","jednotka","Hodnota"]
["Převodový poměr absolutní","i","[-]",0.79999999999999982,0.94295227524972269,1.1023474178403756,1.2811955168119551,1.483289124668435,1.7134751773049643,1.9780487804878049,2.2853377265238879,2.6465949820788528,3.0774066797642443,3.6000000000000005]
["Průměr planetového kola","Dp","[mm]",175,175,175,175,175,175,175,175,175,175,175]
["Průměr korunového kola","Dk","[mm]",-320,-320,-320,-320,-320,-320,-320,-320,-320,-320,-320]
["Průmer satelitu pod planetou","Dsp","[mm]",44.130434782608695,49.333180778032037,54.53592677345538,59.738672768878715,64.941418764302057,70.144164759725399,75.346910755148741,80.549656750572083,85.752402745995425,90.955148741418768,96.15789473684211]
["Průměr satelitu pod korunou","Dsk","[mm]",100.86956521739131,95.666819221967955,90.464073226544627,85.261327231121285,80.058581235697943,74.855835240274601,69.653089244851259,64.450343249427917,59.247597254004575,54.044851258581232,48.84210526315789]
["Vzdálenost satelitu od osy variátoru","Ls","[mm]",109.56521739130434,112.16659038901602,114.76796338672769,117.36933638443935,119.97070938215103,122.57208237986271,125.17345537757437,127.77482837528603,130.37620137299771,132.97757437070939,135.57894736842104]
["Axiální poloha planetových kol","La","[mm]",0,9.7084561968977408,19.416912393795428,29.125368590693114,38.833824787590856,48.542280984488599,58.250737181386285,67.95919337828397,77.667649575181713,87.376105772079455,97.084561968977084]
["Převodový poměr skutečný","Is","[-]",-0.79999999999999982,-0.94295227524972269,-1.1023474178403756,-1.2811955168119551,-1.483289124668435,-1.7134751773049643,-1.9780487804878049,-2.2853377265238879,-2.6465949820788528,-3.0774066797642443,-3.6000000000000005]
[]
["Otáčky vstupní hřídele","nin","[ot/min]",1450,1450,1450,1450,1450,1450,1450,1450,1450,1450,1450]
["Otáčky výstupní hřídele","nout","[ot/min]",1812.5000000000005,1537.7236346516004,1315.3747870528109,1131.7554432348368,977.5572246065808,846.23344370860934,733.04562268803943,634.47952710495963,547.87378114842909,471.17594484167506,402.77777777777771]
["Otáčky satelitů","ns","[ot/min]",5750,5143.5969868173261,4652.8960817717207,4247.667185069985,3907.3676680972821,3617.5496688741723,3367.7558569667076,3150.2306805074973,2959.1007583965329,2789.8365679264552,2638]
["Obvodová rychlost planetového kola","vop","[m/s]",13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834]
["Obvodová rychlost korunového kola","vok","[m/s]",30.368728984701345,25.764806793988605,22.039316094519201,18.96274445934306,16.379128508200864,14.178777439877114,12.282297295908801,10.630806513099026,9.1797133117352914,7.8946287299351257,6.7486064410447408]
["Poloměr zaoblení planetového kola","R1'","[mm]",200,200,200,200,200,200,200,200,200,200,200]
["Poloměr zaobleni korunového kola","R3'","[mm]",200,200,200,200,200,200,200,200,200,200,200]
[]
["Kontakt Planetové kolo satelit"]
["Maximální kontaktní tlak","Pmax","[Mpa]",1555]
["Modul pružnosti planetového kola","E1","[Mpa]",206000,206000,206000,206000,206000,206000,206000,206000,206000,206000,206000]
["Modul pružnosti kuželu satelitu","E2","[Mpa]",206000,206000,206000,206000,206000,206000,206000,206000,206000,206000,206000]
["Poisson planetového kola","ϑ1","[-]",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Poisson kužele satelitu","ϑ2","[-]",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Maximální normálová přítlačná síla","FN1","[N]",3557.3904055117705,9319.1852735307002,10242.858281007007,11134.685770316699,11995.081169904388,12824.763669265809,13624.645391935572,14395.754465081296,15139.182149901038,15856.04639291443,16547.466745810234]
["Kontakt satelit korunové kolo"]
["Modul pružnosti kuželu satelitu","E2","[Mpa]",206000,206000,206000,206000,206000,206000,206000,206000,206000,206000,206000]
["Modul pružnosti korunového kola","E3","[Mpa]",206000,206000,206000,206000,206000,206000,206000,206000,206000,206000,206000]
["Poisson kužele satelitu","ϑ2","[-]",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Poisson korunového kola","ϑ3","[-]",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Maximální normálová přítlačná síla","FN2","[N]",20556.105137083978,18811.250799406422,17152.658111661975,15576.522166694474,14079.426153318382,12658.320036574585,11310.505796524831,10033.629727407873,8825.6828420565271,7685.0112325587752,6610.3395153147803]
["Výsledné kontakty"]
["Skutečná síla - linearizace","FN","[N]",3557.3904055117705,3862.6853164920713,4167.9802274723725,4473.2751384526737,4778.5700494329749,5083.8649604132761,5389.1598713935773,5694.4547823738785,5999.7496933541797,6305.0446043344809,6610.3395153147803]
["Tlak v doteku palentové kolo - satelit","P1","[Mpa]",1554.9999999999993,1549.1985160367738,1537.5609751121519,1529.0314345120989,1522.9036619612641,1518.6675014579196,1515.9449229582397,1514.44969268004,1513.9610372414747,1514.3059246553541,1515.3468303185473]
["Tlak v doteku satelit - korunové kolo","P2","[Mpa]",866.06743838709531,916.85754609564094,969.76096549123997,1025.2715540053509,1083.9529693962743,1146.4689445829267,1213.6228206840517,1286.411991649964,1366.1061601763686,1454.3642802150111,1553.4163723729046]
["Hlavní polosa elipsy doteku planeta","a1","[mm]",2.3495260555902715,2.3818801135149057,2.4202953258562676,2.4573690544026738,2.4931890402438865,2.5278423604742835,2.5614116194189807,2.5939734140695334,2.6255979277734056,2.6563490743021085,2.6862848952323795]
["Vedlejší polosa elipsy doteku planeta","b1","[mm]",0.46576182935386118,0.5006362102085089,0.5355715291956632,0.5692141052769526,0.60167272172748643,0.63304034320746427,0.66339756896877489,0.69281509053737977,0.72135549894388473,0.74907465077236068,0.77602272516897064]
["Hlavní polosa elipsy doteku koruna","a2","[mm]",1.9525023171339499,2.028350540325957,2.1031802964885133,2.1774051025801757,2.2514167233625177,2.3256040177143333,2.4003712724768795,2.4761582932606476,2.5534649044680666,2.6328835800683992,2.7151461248883302]
["Vedlejší polosa elipsy doteku koruna","b2","[mm]",1.004453910676971,0.99171345614826789,0.97572223009785808,0.9567296204592507,0.93491770185648781,0.91041141663571024,0.88328461451125595,0.85356267882218928,0.82122193799822252,0.78618555652011812,0.74831497014911075]
["Axiální síla na 1 kolo","Fa","[N]",3682.8815512457018,3998.946100584024,4315.0106499223466,4631.0751992606693,4947.1397485989919,5263.2042979373136,5579.2688472756363,5895.3333966139589,6211.3979459522816,6527.4624952906042,6843.5270446289251]
["Teplota oleje",null,"[°C]",50]
["Spinová rychlost planeta - satelit","ωs1","[rad/s]",78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426]
["Spinová rychlost koruna - satelit","ωs2","[rad/s]",98.250067959970551,83.355283645888363,71.30243432870094,61.348992668628583,52.990380001300281,45.871720471376982,39.736155722404852,34.393189879874349,29.698557920727822,25.541003366509191,21.833348435549006]
["Součinitel tření planeta - satelit","μ1max","[-]",9.9228972283347039E-2,9.8902454780740945E-2,9.8459297691537093E-2,9.8069316513335031E-2,9.7723163851460682E-2,9.7413579480145257E-2,9.7134837349833969E-2,9.6882357800999602E-2,9.6652431402470845E-2,9.6442019097503898E-2,9.6248605287781883E-2]
["Součinitel tření koruna - satelit","μ2max","[-]",7.6232178349488436E-2,8.0103918272456276E-2,8.36056642684469E-2,8.682357730924177E-2,8.9823179944799741E-2,9.2654655637312941E-2,9.5356545637735962E-2,9.7958068519507349E-2,0.10048020389740385,0.1029354465843008,0.10532573712098367]
[]
["Počet satelitů","xs","[-]",4]
["Moment vstupní hříídel","Min*","[Nm]",247.09733576470052,267.42034189261238,287.26348419239997,307.08372478290352,326.88388874149479,346.66623837128094,366.4326172920471,386.18454399529156,405.9232769682373,425.64986249928791,445.36517117943174]
["Moment korunová kola","Mout*","[Nm]",347.12015341021731,396.05277299775713,446.03744713674251,497.13375975546222,549.40973750918226,602.9360092335279,657.78133660876415,714.00677344386133,771.65577282766628,830.73610506381556,891.18576905023372]
["Přepočet momentu z korun na vstup","Meout","[Nm]",433.90019176277173,420.01359283307335,404.62511175522212,388.02333697865106,370.39962632503881,351.87904512387189,332.54050309444301,312.42943445820634,291.56549379593571,269.94680635692163,247.55160251395378]
["Krouticí moment maximální vstupní","Min","[Nm]",247.09733576470052,267.42034189261238,287.26348419239997,307.08372478290352,326.88388874149479,346.66623837128094,332.54050309444301,312.42943445820634,291.56549379593571,269.94680635692163,247.55160251395378]
["Krouticí moment maximální výstupní","Mout","[Nm]",197.67786861176037,252.16461983569758,316.66416003932164,393.43429147777226,484.86331719958588,594.00399425887565,657.78133660876415,714.00677344386133,771.65577282766628,830.73610506381556,891.18576905023372]
["Maximálni přenositelný výkon","P","[W]",37520.160113399703,40606.079439664594,43619.134493200152,46628.712067723049,49635.241133278592,52639.065206216503,50494.162074556873,47440.424109523883,44272.367311896953,40989.70701269502,37589.137632373859]

{"sheet":"Výpočet","index":1,"n_rows":95,"n_cols":21,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,0,0,2],[35,0,36,1],[32,5,32,14],[66,1,67,2],[60,0,60,2],[59,0,59,2],[57,0,57,2],[58,0,58,2]]}
["vstupní parametry - vrcholový úhel satelitu 30°",null,null,"Jednotka",0.7]
[null,null,"poloha","[-]",1,2,3,4,5,6,7,8,9,10,11]
[null,"parametry","převodový poměr - rozsah","[-]",0.8,null,null,null,null,null,null,null,null,null,3.6]
[null,null,"průměr centrál","[mm]",175,{"$f":"E4","v":175},{"$f":"F4","v":175},175,175,175,175,175,175,175,175]
[null,null,"průměr koruna","[mm]",-320,{"$f":"E5","v":-320},{"$f":"F5","v":-320},-320,-320,-320,-320,-320,-320,-320,-320]
[null,null,"satelit pod planetou","[mm]",{"$f":"(E3*E4*(ABS(E5)-E4))/(ABS(E5)*(1+E3*E4/ABS(E5)))","v":44.130434782608695},{"$f":"($O$6-$E$6)/10*E2+$E$6","v":49.333180778032037},54.53592677345538,59.738672768878715,64.941418764302057,70.144164759725399,75.346910755148741,80.549656750572083,85.752402745995425,90.955148741418768,{"$f":"(O3*O4*(ABS(O5)-O4))/(ABS(O5)*(1+O3*O4/ABS(O5)))","v":96.15789473684211}]
[null,null,"satelit pod korunou","[mm]",{"$f":"ABS(E5)-E4-E6","v":100.86956521739131},95.666819221967955,90.464073226544627,85.261327231121285,80.058581235697943,74.855835240274601,69.653089244851259,64.450343249427917,59.247597254004575,54.044851258581232,48.84210526315789]
[null,null,"poloha satelitu od stredu","[mm]",{"$f":"E4/2+E6/2","v":109.56521739130434},112.16659038901602,114.76796338672769,117.36933638443935,119.97070938215103,122.57208237986271,125.17345537757437,127.77482837528603,130.37620137299771,132.97757437070939,135.57894736842104]
[null,null,"poloha axiální","[mm]",0,{"$f":"(F8-E8)/TAN(15*PI()/180)+E9","v":9.7084561968977408},{"$f":"(G8-F8)/TAN(15*PI()/180)+F9","v":19.416912393795428},29.125368590693114,38.833824787590856,48.542280984488599,58.250737181386285,67.95919337828397,77.667649575181713,87.376105772079455,97.084561968977084]
[null,null,"převodový poměr","[-]",{"$f":"1/(E4/E6*E7/E5)","v":-0.79999999999999982},-0.94295227524972269,-1.1023474178403756,-1.2811955168119551,-1.483289124668435,-1.7134751773049643,-1.9780487804878049,-2.2853377265238879,-2.6465949820788528,-3.0774066797642443,-3.6000000000000005]
[null,null,"přvodový poměr 2","[-]",{"$f":"ABS(E10)","v":0.79999999999999982},{"$f":"ABS(F10)","v":0.94295227524972269},1.1023474178403756,1.2811955168119551,1.483289124668435,1.7134751773049643,1.9780487804878049,2.2853377265238879,2.6465949820788528,3.0774066797642443,3.6000000000000005]
[null,null,"otáčky vstup","[ot/min]",1450,{"$f":"E12","v":1450},{"$f":"F12","v":1450},1450,1450,1450,1450,1450,1450,1450,1450]
[null,null,"otáčky výstup","[ot/min]",{"$f":"E12/E11","v":1812.5000000000005},{"$f":"F12/F11","v":1537.7236346516004},{"$f":"G12/G11","v":1315.3747870528109},1131.7554432348368,977.5572246065808,846.23344370860934,733.04562268803943,634.47952710495963,547.87378114842909,471.17594484167506,402.77777777777771]
[null,null,"otáčky satelitů","[ot/min]",{"$f":"E12*E4/E6","v":5750},5143.5969868173261,4652.8960817717207,4247.667185069985,3907.3676680972821,3617.5496688741723,3367.7558569667076,3150.2306805074973,2959.1007583965329,2789.8365679264552,2638.8888888888887]
[null,null,"rychlost centrál","[m/s]",{"$f":"PI()*E4/1000*E12/60","v":13.286318930806834},13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834,13.286318930806834]
[null,null,"rychlost koruna","[m/s]",{"$f":"PI()*ABS(E5)/1000*E13/60","v":30.368728984701345},25.764806793988605,22.039316094519201,18.96274445934306,16.379128508200864,14.178777439877114,12.282297295908801,10.630806513099026,9.1797133117352914,7.8946287299351257,6.7486064410447408]
[null,null,"zaoblení central","[mm]",200,{"$f":"E17","v":200},{"$f":"F17","v":200},200,200,200,200,200,200,200,200]
[null,null,"zaobleni koruna","[mm]",200,{"$f":"E18","v":200},{"$f":"F18","v":200},200,200,200,200,200,200,200,200]
[null," kontaktní tlaky"]
[]
[null,"planety","p max","[MPa]",1555]
[null,null,"E centrál","[MPa]",206000,210000,{"$f":"F22","v":210000},210000,210000,210000,210000,210000,210000,210000,210000]
[null,null,"E satelit","[MPa]",206000,{"$f":"E23","v":206000},{"$f":"F23","v":206000},206000,206000,206000,206000,206000,206000,206000,206000]
[null,null,"poisson cental","[-]",0.3,{"$f":"E24","v":0.3},{"$f":"F24","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,"poisson satelit","[-]",0.3,{"$f":"E25","v":0.3},{"$f":"F25","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,"maximální přítlačná síla","[N]",{"$f":"hertz(E22,E23,E24,E25,E4/2,E17,E6/2,E6*1000,$E$21)","v":3557.3904055117705},{"$f":"hertz(F22,F23,F24,F25,F4,F17,F6,100000,$E$21)","v":9319.1852735307002},10242.858281007007,11134.685770316699,11995.081169904388,12824.763669265809,13624.645391935572,14395.754465081296,15139.182149901038,15856.04639291443,16547.466745810234]
[]
[null,"koruny","E satelit","[MPa]",206000,{"$f":"E28","v":206000},206000,206000,206000,206000,206000,206000,206000,206000,206000]
[null,null,"E koruna","[MPa]",206000,{"$f":"E29","v":206000},206000,206000,206000,206000,206000,206000,206000,206000,206000]
[null,null,"poisson satelit","[-]",0.3,{"$f":"E30","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,"poisson koruna","[-]",0.3,{"$f":"E31","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,"maximální přítlačná síla","[N]",{"$f":"hertz(E29,E28,E31,E30,E5/2,E17,E7/2,E7/2*1000,$E$21)","v":20556.105137083978},{"$f":"hertz(F29,F28,F31,F30,F5/2,F17,F7/2,F7/2*1000,$E$21)","v":18811.250799406422},17152.658111661975,15576.522166694474,14079.426153318382,12658.320036574585,11310.505796524831,10033.629727407873,8825.6828420565271,7685.0112325587752,6610.3395153147803]
[null,null,"změna přítlačné síli v průběhhu",null,2,"0 - konatantní síla, 1 - maximální kontaktní tlaky, 2 - linearizováná síla"]
[null,"(síla na ax. ložisko)","skutečná síla linearizace","[N]",{"$f":"MIN($E$26:$O$26,$E$32:$O$32)","v":3557.3904055117705},{"$f":"($O$34-$E$34)/10+E34","v":3862.6853164920713},{"$f":"($O$34-$E$34)/10+F34","v":4167.9802274723725},4473.2751384526737,4778.5700494329749,5083.8649604132761,5389.1598713935773,5694.4547823738785,5999.7496933541797,6305.0446043344809,{"$f":"MIN(O26,O32)","v":6610.3395153147803}]
[null,null,"výsledná maximální axiální síla síla","[N]",{"$f":"IF($E$33=0,MIN($E$26:$O$26,$E$32:$O$32),IF($E$33=2,E34,MIN(E26,E32)))","v":3557.3904055117705},{"$f":"IF($E$33=0,MIN($E$26:$O$26,$E$32:$O$32),IF($E$33=2,F34,MIN(F26,F32)))","v":3862.6853164920713},4167.9802274723725,4473.2751384526737,4778.5700494329749,5083.8649604132761,5389.1598713935773,5694.4547823738785,5999.7496933541797,6305.0446043344809,6610.3395153147803]
["výsledený tlak v doteku",null,"central","[MPa]",{"$f":"hertz2(E22,E23,E24,E25,E4/2,E17,E6/2,E6*1000,E35)","v":1554.9999999999993},{"$f":"hertz2(F22,F23,F24,F25,F4/2,F17,F6/2,F6*1000,F35)","v":1549.1985160367738},1537.5609751121519,1529.0314345120989,1522.9036619612641,1518.6675014579196,1515.9449229582397,1514.44969268004,1513.9610372414747,1514.3059246553541,1515.3468303185473]
[null,null,"koruna","[MPa]",{"$f":"hertz2(E28,E29,E30,E31,E5/2,E18,E7/2,E7*1000,E35)","v":866.06743838709531},{"$f":"hertz2(F28,F29,F30,F31,F5/2,F18,F7/2,F7*1000,F35)","v":916.85754609564094},969.76096549123997,1025.2715540053509,1083.9529693962743,1146.4689445829267,1213.6228206840517,1286.411991649964,1366.1061601763686,1454.3642802150111,{"$f":"hertz2(O28,O29,O30,O31,O5/2,O18,O7/2,O7*1000,O35)","v":1553.4163723729046}]
[null,null,"hlavní polosa elipsy doteku planeta-satelit","[mm]",{"$f":"elipsaa(E22,E23,E24,E25,E4/2,E17,E6/2,E6*10000,E35)","v":2.3495260555902715},{"$f":"elipsaa(F22,F23,F24,F25,F4/2,F17,F6/2,F6*10000,F35)","v":2.3818801135149057},2.4202953258562676,2.4573690544026738,2.4931890402438865,2.5278423604742835,2.5614116194189807,2.5939734140695334,2.6255979277734056,2.6563490743021085,2.6862848952323795]
[null,null,"vedlejší polosa elipsy doteku planeta-satelit","[mm]",{"$f":"elipsab(E22,E23,E24,E25,E4/2,E17,E6/2,E6*1000,E35)","v":0.46576182935386118},{"$f":"elipsab(F22,F23,F24,F25,F4/2,F17,F6/2,F6*1000,F35)","v":0.5006362102085089},0.5355715291956632,0.5692141052769526,0.60167272172748643,0.63304034320746427,0.66339756896877489,0.69281509053737977,0.72135549894388473,0.74907465077236068,0.77602272516897064]
[null,null,"hlavní polosa elipsy doteku satelit-koruna","[mm]",{"$f":"elipsaa(E28,E29,E30,E31,E5/2,E18,E7/2,E7*1000,E35)","v":1.9525023171339499},{"$f":"elipsaa(F28,F29,F30,F31,F5/2,F18,F7/2,F7*1000,F35)","v":2.028350540325957},2.1031802964885133,2.1774051025801757,2.2514167233625177,2.3256040177143333,2.4003712724768795,2.4761582932606476,2.5534649044680666,2.6328835800683992,2.7151461248883302]
[null,null,"vedlejší polosa elipsy doteku satelit-koruna","[mm]",{"$f":"elipsab(E28,E29,E30,E31,E5/2,E18,E7/2,E7*1000,E35)","v":1.004453910676971},{"$f":"elipsab(F28,F29,F30,F31,F5/2,F18,F7/2,F7*1000,F35)","v":0.99171345614826789},0.97572223009785808,0.9567296204592507,0.93491770185648781,0.91041141663571024,0.88328461451125595,0.85356267882218928,0.82122193799822252,0.78618555652011812,0.74831497014911075]
[null,null,"axiální síla","[N]",{"$f":"E35*SIN(15*PI()/180)*$E$49","v":3682.8815512457018},{"$f":"F35*SIN(15*PI()/180)*$E$49","v":3998.946100584024},4315.0106499223466,4631.0751992606693,4947.1397485989919,5263.2042979373136,5579.2688472756363,5895.3333966139589,6211.3979459522816,6527.4624952906042,6843.5270446289251]
[null,"Součinitel tření","teplota oleje",null,50]
[null,null,"spinová rychlost planeta - satelit","[rad/s]",{"$f":"4*PI()*E12*SIN(15/180*PI())/60","v":78.600054367976426},{"$f":"4*PI()*F12*SIN(15/180*PI())/60","v":78.600054367976426},78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426,78.600054367976426]
[null,null,"spinová rychlost koruna - satelit","[rad/s]",{"$f":"4*PI()*E13*SIN(15/180*PI())/60","v":98.250067959970551},{"$f":"4*PI()*F13*SIN(15/180*PI())/60","v":83.355283645888363},71.30243432870094,61.348992668628583,52.990380001300281,45.871720471376982,39.736155722404852,34.393189879874349,29.698557920727822,25.541003366509191,21.833348435549006]
[null,null,"součinitel tření planeta - satelit","[-]",{"$f":"treni50(E36,$E$43,E15,E38,E39,E44)","v":9.3478972283347034E-2},{"$f":"treni50(F36,$E$43,F15,F38,F39,F44)","v":9.315245478074094E-2},9.2709297691537088E-2,9.2319316513335026E-2,9.1973163851460676E-2,9.1663579480145252E-2,9.1384837349833964E-2,9.1132357800999597E-2,9.090243140247084E-2,9.0692019097503893E-2,9.0498605287781878E-2]
[null,null,"součinitel tření koruna - satelit","[-]",{"$f":"treni50(E37,$E$43,E16,E40,E41,E45)","v":7.0932178349488437E-2},{"$f":"treni50(F37,$E$43,F16,F40,F41,F45)","v":7.4803918272456277E-2},7.8305664268446901E-2,8.1523577309241771E-2,8.4523179944799742E-2,8.7354655637312942E-2,9.0056545637735963E-2,9.265806851950735E-2,9.5180203897403851E-2,9.7635446584300803E-2,0.10002573712098367]
[null,"Koruticí momenty"]
[null,null,"počet satelitů","[-]",4]
[null,null,"moment central","[Nmm]",{"$f":"E35*E46*E4/2000*$E$49*2","v":232.7788393825156},251.87303349373175,270.48736377682366,289.07879235063149,307.65014429252705,326.20368190561749,344.74124880968799,363.26436349623668,381.7742844524866,400.27205796684166,418.75855463028978]
[null,null,"moment koruna","[Nmm]",{"$f":"E35*E47*ABS(E5)/2000*$E$49*2","v":322.98681689922546},369.84831581067499,417.76186927356997,466.78706121619939,516.99191829382903,568.44706934208421,621.22127604123,675.37559220023695,730.95347090795144,787.96268246801048,846.34122577833841]
[null,null,"moment z koruny na central","[Nmm]",{"$f":"E51/E11","v":403.73352112403194},{"$f":"F51/F11","v":392.22379066080288},378.97477919621127,364.33710162967355,348.54426537334325,331.75098003821972,314.05761180875993,295.52550783271613,276.18637375855695,256.04762855989355,235.0947849384273]
[null,null,"moment maximální vstupní","[Nmm]",{"$f":"MIN(E52,E50)","v":232.7788393825156},{"$f":"MIN(F52,F50)","v":251.87303349373175},270.48736377682366,289.07879235063149,307.65014429252705,326.20368190561749,314.05761180875993,295.52550783271613,276.18637375855695,256.04762855989355,235.0947849384273]
[null,null,"moment maximální výstupní","[Nmm]",{"$f":"E53*E11","v":186.22307150601245},{"$f":"F53*F11","v":237.50425000696396},298.17104701783188,370.36645276504316,456.33411323178018,558.94191169076009,621.22127604123,675.37559220023695,730.95347090795133,787.96268246801048,846.34122577833841]
[]
[null,null,"maximálni přenášený výkon","[W]",{"$f":"E53*E12*2*PI()/60","v":35345.987432904687},{"$f":"F53*F12*2*PI()/60","v":38245.319463628708},41071.787221623388,43894.777500605407,46714.719270620066,49531.956048017106,47687.65249301384,44873.670277189936,41937.14566970522,38879.205194554401,35697.649047558712]
[]
["dovolený přenášený výkon pro otáčky ",null,null,null,{"$f":"E12","v":1450},"je ",{"$f":"MIN(E56:O56)/1000","v":35.345987432904685},"kW"]
["rozsah převodových poměrů",null,null,null,{"$f":"E11","v":0.79999999999999982},"až",{"$f":"O11","v":3.6000000000000005}]
["rozsah výstupních otáček",null,null,null,{"$f":"O13","v":402.77777777777771},"až",{"$f":"E13","v":1812.5000000000005}]
[" max axiální síla",null,null,null,{"$f":"MAX(E35:O35)*SIN(15*PI()/180)*E49","v":6843.5270446289251},"N"]
[]
[]
[]
[]
[]
[null,"Výpočty rozměrů a zatížení"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Axiální ložisko","d","D","h","C [kN]"]
[null,"ložisko axial","síla na axiální ložisko","[N]",{"$f":"E35*SIN(15*PI()/180)*$E$49","v":3682.8815512457018},3998.946100584024,4315.0106499223466,4631.0751992606693,4947.1397485989919,5263.2042979373136,5579.2688472756363,5895.3333966139589,6211.3979459522816,6527.4624952906042,6843.5270446289251,null,51310,50,95,31,81.900000000000006]
[null,51310,"maximální síla","[N]",{"$f":"MAX(E70:O70)","v":6843.5270446289251},null,null,null,null,null,null,null,null,null,null,null,51309,45,85,28,76.099999999999994]
[null,51309,"životnost","[h]",20000,null,null,null,null,null,null,null,null,null,null,null,51406,30,70,28,70.2]
[null,51406,"otáčky","[ot/min]",{"$f":"E12","v":1450},null,null,null,null,null,null,null,null,null,null,null,51407,35,80,32,76.099999999999994]
[null,51407,"počet otáček v mil","[-]",{"$f":"E72*E73*60/10^6","v":1740}]
[null,null,"únosnost","[N]",{"$f":"E71*E74^(1/3)","v":82311.984157275263}]
[]
[null,"Výpočet satelitu","průměr v místě ložiska","[mm]",94.34]
[null,null,"převod","[-]",{"$f":"E11","v":0.79999999999999982},0.94295227524972269,1.1023474178403756,1.2811955168119551,1.483289124668435,1.7134751773049643,1.9780487804878049,2.2853377265238879,2.6465949820788528,3.0774066797642443,3.6000000000000005]
[null,null,"Vzdálenost planetového a korunového kola Lkol","[mm]",{"$f":"(E7-E6)/2/TAN(15*3.14159/180)","v":105.87675243109416},86.459822862444355,67.042893293794592,47.625963725144821,28.209034156495036,8.79210458784525,-10.624824980804535,-30.041754549454321,-49.458684118104102,-68.875613686753894,-88.292543255403672]
[null,null,"Moment od radiální složky Mor","[Nmm]",{"$f":"E79*E35*COS(15/180*3.14159)","v":363811.09959758306},322587.45477296854,269912.00559395592,205784.752060545,130205.69417273575,43174.831930528264,-55307.834666077491,-165242.30561708153,-286628.58092248376,-419466.66058228438,-563756.544596483]
[null,null,"Mometn od axiální složky Moa","[Nmm]",{"$f":"E35*SIN(15*3.14159/180)*(E7-E6)/2","v":26120.415532384191},23160.696233634393,19378.775829246777,14774.654319221323,9348.3317035580276,3099.8079822568984,-3970.9168446820659,-11863.842777258866,-20578.969815473498,-30116.29795932597,-40475.827208816263]
[null,null,"Moment od obvodových sil Moo","[Nmm]",{"$f":"$G$58*1000000*60/4/3.14159/TAN(15/180*3.14159)/$E$49/E12*(($E$77-E6)/E4+E11*($E$77-E7)/ABS(E5))","v":29383.94911339588},27503.570562470246,26149.603376105697,25418.414267366381,25431.420182420592,26343.793700697614,28357.069940602578,31737.859610668096,36846.42162529131,44181.739353136254,54455.406467775916]
[null,null,"Výsledný ohybový moment Mo1","[Nmm]",{"$f":"((E80+E81)^2+E82^2)^0.5","v":391037.08642154455},{"$f":"((F80+F81)^2+F82^2)^0.5","v":346840.35278232762},290470.23595056153,222019.25035109537,141852.329098877,53247.889776054457,65712.20431769584,179927.42851423347,309409.33731386211,451748.67205482273,606681.25933724712]
[]
[null,null,"D","[mm]",41,41,41,41,41,41,41,41,41,41,41]
[null,null,"d","[mm]",25.5,25.5,25.5,25.5,25.5,25.5,25.5,25.5,25.5,25.5,25.5]
[null,null,"napětí","[MPa]",{"$f":"32*E83*E85/(E85^4-E86^4)/3.14159","v":67.961050750491779},{"$f":"32*F83*F85/(F85^4-F86^4)/3.14159","v":60.279793493417209},50.482839434985628,38.586267299544836,24.65350134736758,9.2543205365588275,11.420580317405824,31.270837281861425,53.774397380802675,78.512538820649212,105.43934907172344]
[null,null,"počet cyklů v milionech","[-]",{"$f":"20000*60*(0.25*E14+0.5*H14+0.25*O14)/10^6","v":5065.2669777086576}]
[]
[null,"vyrovnávání satelitu","radiální síla na 1 satelit","[N]",{"$f":"E35*COS(15/180*3.14159)","v":3436.1754704778618},3731.0677271013838,4025.9599837249061,4320.8522403484285,4615.7444969719509,4910.6367535954732,5205.5290102189956,5500.421266842518,5795.3135234660404,6090.2057800895627,6385.0980367130833]
[null,null,"klopný moment na satelit ","[Nmm]",{"$f":"E90*194","v":666618.04127270519},{"$f":"F90*194","v":723827.13905766839},781036.23684263183,838245.33462759515,895454.43241255847,952663.53019752179,1009872.6279824851,1067081.7257674485,1124290.8235524117,1181499.9213373752,1238709.0191223382]
[null,null,"síla na vyrovnávací ozubení ","[N]",{"$f":"E91/336","v":1983.9822656925749},{"$f":"F91/336","v":2154.2474376716323},2324.5126096506901,2494.7777816297476,2665.042953608805,2835.3081255878624,3005.5732975669198,3175.8384695459777,3346.1036415250351,3516.3688135040929,3686.6339854831494]
[null,null,"moment","[Nmm]",{"$f":"E92*36.25/2","v":35959.678565677918},39045.734807798333,42131.791049918756,45217.847292039172,48303.903534159588,51389.959776280004,54476.01601840042,57562.072260520843,60648.128502641259,63734.184744761682,{"$f":"O92*36.25/2","v":66820.240986882083}]
[null,null,"únosnost ","[Nmm]",9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600]
[null,null,"bezpečnost","[-]",{"$f":"E94/E93","v":0.26696567886351513},0.24586552275826704,0.22785644191165977,0.21230555134565479,0.19874170196640661,0.18680691796203855,0.17622434057507799,0.16677648359411471,0.15829012761015229,0.15062560286046531,{"$f":"O94/O93","v":0.14366904186838594}]