用Excel编的格里森齿制弧齿圆锥齿轮正交传动的几何计算

格里森齿制弧齿圆锥齿轮正交传动的几何计算输出参数项目代号轮1输入值轮2输入值项目大端端面模数me(mm)1.51.5齿数比齿数Z1031默认高度变位系数齿形角α（°）2020默认切向变位系数齿宽中点螺旋角βm（°）3535分锥角高度变位系数x0.35-0.35分度圆直径切向变位系数χτ0.12-0.12外锥距齿顶高系数h﹡a0.850.85默认齿宽系数顶隙系数C﹡0.1880.188默认齿宽安装距A（mm)125116.5齿顶高齿宽b(mm)7.375340382齿全高刀盘直径Do(mm)228.6齿根高顶隙中点模数Mm1.273575齿顶圆直径小轮分锥角度COS值0.951708618大轮分锥角度COS值0.3070028000°00′35″0.819152044齿宽中点螺旋角35度的COS值齿根角中点法向模数Mnm1.043251565齿顶角锥顶到轮冠距离AkAk122.697395顶锥角Ak26.786218537根锥角π值3.1415926齿形角20度TAN值0.3639702外锥高0.30700278小轮分锥角sin值齿宽中点螺旋角35度的平方值0.6710101支承端距0.951708618大轮分锥角SIN值中点锥距中点法向齿厚smnsmn12.241110785大端螺旋角smn21.036360611分度圆弧齿厚中点法向齿厚半角ψmnψmn10.112375553当量齿数ψmn20.005407494αvat（°）端面重合度齿线重合度输入参数输出参数1总重合度格里森齿制弧齿圆锥齿轮正交传动的几何计算输出参数代号轮1输出值轮2输出值u3.1x0.3494173-0.349417χτ0.12-0.12δ（°）17.87869772.121303d(mm)1546.5Re(mm)24.42974624.429746Φr0.3019b(mm)7.3753404hα(mm)1.80.75h(mm)2.832hf(mm)1.0322.082C0.282dα(mm)18.42615146.960504θf（°）2.41894084.8712033θα（°）4.87120332.4189408δα（°）22.749974.540244δf（°）15.45975667.2501Ak(mm)22.6973956.7862185H(mm)102.30261109.71378Rm20.742076β（°）31.119391s(mm)2.98260521.7297838Zv19.116238183.70705αt（°）23.956803αvat（°）41.93267225.19147εα1.177905εβ1.2907272εγ1.7474086