齿轮计算EXCEL

安装中心距A法向模数Mn齿数Z法向压力角arfa分圆螺旋角bita齿顶高系数hap顶隙系数cp端面模数Mt分圆直径d理论中心距Ao端面压力角arfat端面啮合角arfatp法向中心距变动系数YninvARFAtinvARFAtp总变位系数Xz变位系数X法向齿顶缩短系数cigmn齿顶高ha齿全高h齿顶圆直径Da齿根圆直径Df法向压力角渐开线函数invarfan当量齿数Zv无根切最小齿顶高系数Hamin基圆直径Db顶圆压力角arfaDa理论接触线长N1-N2齿顶圆曲率半径Pa有效渐开线最小曲率半径P0有效渐开线起始圆直径D0齿数比U端面啮合角弧度值共轭齿轮顶圆压力角弧度值齿根滑动率Et噪声指标1Bcg噪声指标2Brc齿轮参数计算理论公法线跨齿数Kv各挡传动比上偏差系数下偏差系数实际公法线跨齿数K齿距极限偏差齿圈径向跳动公差公法线平均长度上偏差公法线平均长度公差公法线平均长度公法线平均上限值公法线平均下限值分圆齿厚（法向）Sn分圆齿厚（端面）St顶圆齿厚（法向）Sa计算齿宽（接触齿宽）Bj径向重合度Ea轴向重合度Eb总重合度Ev刀具允许的最大齿顶圆角RoRc无干涉刀具最大齿顶圆角Rc输入扭距T1输入转数N1基圆齿距极限偏差Fpb齿形公差ff接触工况系数KA弯曲工况系数KA刀具齿顶圆角系数Raop齿面粗糙度Rz齿根粗糙度Rzr接触极限应力Chlim弯曲极限应力Cflim接触寿命系数Zn弯曲寿命系数Ynt弯曲计算齿宽Bj原计算齿宽（接触齿宽）原弯曲计算齿宽切向力Ft输入齿轮节圆线速度V传动比U齿向载荷分布系数KHBN齿向载荷分布系数KFB基圆螺旋角Bb当量齿数Zv单位齿宽柔度q刚性系数CP啮合刚度Cr齿形平均直径dm1Q诱导质量mred主动齿轮临界转数ne1临界转数比N基节偏差对Kv影响系数Cv1齿形误差对Kv影响系数Cv2啮合刚性对Kv影响系数Cv3无量刚参数Bp无量刚参数Bf无量刚参数Bk动载系数Kv齿廓跑合量YaFtHKha=Kfa重合度系数ZeYeEv/Ea/Ze^2齿间载荷分布系数KHAKHAEv/Ea/YeKFAKFAArfatArfatp节点区域系数ZH弹性系数ZE刀具齿顶高Hao刀具齿顶圆角半径Rao法向压力角ArfanEGHCCita0Cita1Cita2Cita3SFn/MnPf/MnPbtDeArfaetinvArfaetGametArfafethfe/MnBfeArfafen齿形系数YF齿根圆角参数qsLc应力修正系数Ys螺旋角系数ZbEbjYbminYb弯曲螺旋角系数Yb重合度系数ZE润滑系数ZL速度系数ZvRz100齿面粗糙度系数ZRX*相对齿根圆角敏感系数Ydrelt相对齿根表面粗糙度系数YrreltChoChCfoCf接触安全系数SH弯曲安全系数SF61612.52.5935202025251.051.450.250.252.7584450382.75844503824.8260053496.5455763360.6857908360.6857908321.8802438121.8802438122.6037850322.603785030.1256836660.1256836660.0197146760.0197146760.0218268910.0218268910.1276716710.1276716710.5-0.3723283290.0019880050.0019880053.8700299892.6892091656.8700299896.87002998932.56606532101.923994718.8260053488.183934680.0149044040.01490440411.9046752346.295959241.1962918032.33547312823.0376577989.590891444.9751830128.478385523.4457347323.4457347311.5088545724.30006618-0.85433144911.9368801623.1009351692.717227383.8888888893.8888888890.3945106410.3945106410.4970418060.784965362-8.314003132.7494448841.0312594540.9747518770.8416398430.841639843齿轮参数计算2.4776670444.9349842463.888888889-4-4-10-10340.010.010.0360.036-0.046452869-0.046452869-0.085104091-0.08510409119.7227004726.815431619.676247626.7689787419.6375963826.730327514.8369260093.2494175385.3369583043.5853355130.6056386381.05538416114.714.71.5373940381.5373940380.7909995820.7909995822.328393622.328393620.2380004210.4459210840.5064589090.8197004920.7316821111.18422279711011036003600991.21.21.31.31.31.30.350.356.36.32525147514754184181.211.210.91181712121412.58861.6753678861.6753674.6796027034.6796027033.8888888893.8888888891.3031276361.3031276360.5932028280.5932028281.1700666121.1700666120.4083890760.40838907611.7898130345.849272890.0621856020.06218560216.0808927316.0808927322.5622246522.5622246525.6960353325.6960353313668.2365313668.236530.0236013180.02360131832805.9087432805.908740.1097363290.1097363290.320.320.2810105470.2810105470.1249359670.1249359670.1708254380.1708254380.0107727750.010772775111.0200408571.0200408570.6750.67515313.120915313.12090.9770424290.9770424290.8282925950.8282925950.7378384990.7378384992.2075149332.2075149330.9770424290.977042429112.0526263322.0526263320.9770424290.977042429110.3818824590.3818824590.3945106410.3945106412.2626934372.262693437189.8189.84.253.250.8750.8750.3490660.349066-0.1960557140.16791469-0.85-1.322328329-0.767429272-0.981609685-0.144192278-0.057681540.6707170520.9280767870.6563902370.9078269430.6563596540.907753010.6563596540.9077530092.0268932832.0455388360.5504514310.6338618448.0416784128.04167841227.1544298898.097361080.5578521040.4195178440.066109290.0264765160.1685794310.0303742460.3892726730.3891435981.1709190161.528663940.4374825460.4374622310.3557621720.3556452531.7058735362.1867400851.8411190971.6135525881.7310277271.3381219920.3939038740.3414336371.8123492241.6177705610.9520019470.9520019470.7909995820.7909995820.8022501050.80225010525250.835208420.835208420.835208420.835208420.8282925950.8282925950.984380.984380.9806562320.9806562327.4284217957.4284217950.930032180.930032180.9364476390.8454210350.9933992780.9909069110.9412547580.9412547581871.0340261871.0340262459.5498152459.549815508.4952552616.0782329788.9662247955.88879640.6514773450.6514773450.9536529910.87457872渐开线圆柱齿轮精度说明：本程序适用于高变位、角变位和非变位直齿、斜齿渐开线圆柱齿轮传动按照新、旧国家标准选取偏差、公差值。公差数值是按照法向模数1至10毫米，分度圆直径800毫米以下，精度等级3、4、5、6、7、8级设定的。引用标准：GB/T10095--1988渐开线圆柱齿轮精度GB/T10095.1--2001idtISO1328-1：1997渐开线圆柱齿轮精度（第一部分）GB/T10095.2--2001idtISO1328-1：1997渐开线圆柱齿轮精度（第二部分）ISO/TR10064—2：1996圆柱齿轮—检验实施规范—第1、2、3、4部分程序设计：邓时俊2002.10注意：本程序有“单变量求解”，应从工具--选项--重新计算中设置反复操作，最多迭代次数10000，最大误差0.00001。说明：请在兰色框中输入已定或初定数据（黄色框中为判断或参考数据）。输出数据在最后列表，可单独打印。产品型号：订货号：10026零件件号：①30201②30202计算人：计算日期：1轮齿数Z1172轮齿数Z244法向模数mn2毫米2法向压力角αn注：如不输入，则默认αn=20度分度圆柱螺旋角βf10.30451度0分0有效齿宽b15毫米15齿顶高系数ha*1注：如不输入，则默认ha*=1齿顶倒棱系数hd*顶隙系数c*0.25注：如不输入，则默认c*=0.25标准中心距a062毫米实际中心距a62毫米端面总变位系数xtΣ0法向总变位系数xnΣ0径向变位系数x10或法向变位系数xn10取消！0x1x20第Ⅰ公差组精度等级77第Ⅱ公差组精度等级77第Ⅲ公差组精度等级77齿厚极限偏差种类代码实际选取注：齿厚极限偏差共14种，越往后间隙越大：C=+fpt，D=0，E=-2fpt，F=-4fpt，1轮齿厚上偏差FG，H，J，K，L，M，N，P，R=-40fpt，S=-50fpt（单位：微米）1轮齿厚下偏差H注：各偏差如不输入“实际选取”，则默认“推荐”种类。2轮齿厚上偏差J2轮齿厚下偏差M最小法向侧隙0.196毫米最大法向侧隙0.392毫米注：如果侧隙不合适，可重新选择齿厚极限偏差种类。说明：如在下面输入齿厚上、下偏差的具体数值，则不认齿厚上、下偏差种类代码。1轮齿厚上偏差Ess1毫米1轮齿厚下偏差Esi1毫米2轮齿厚上偏差Ess2毫米2轮