压缩弹簧EXCEL计算表

1、圆形截面圆柱螺旋压缩弹簧计算,参数名称,符号,需修正的计算值,备注,公式,弹簧中径(mm),D,300,0.4,0.5,0.6,0.7,0.8,0.9,1,1.2,1.4,1.6,1.8,2,2.2,2.5,2.8,3,3.2,3.5,3.8,4,4.2,4.5,4.8,5,5.5,6,6.5,7,7.5,8,8.5,9,10,12,14,16,18,20,22,25,26,30,32,35,38,42,45,48,50,52,55,58,60,65,70,75,80,85,90,95,100,105,110,115,120,125,130,135,140,145,150,160,170,18

2、0,190,200,210,220,230,240,250,260,270,280,290,300,320,340,360,380,400,450,500,550,600,650,700钢丝直径（mm）,d,35,0.1,0.12,0.14,0.16,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.6,0.7,0.8,0.9,1,1.2,1.6,2,2.5,3,3.5,4,4.5,5,6,8,10,12,16,20,25,30,35,40,45,50,60,70,80,第二系列,0.08,0.09,0.18,0.22,0.28,0.32,0.55,0.65,1.4,1.8,2

3、.2,2.8,3.2,5.5,6.5,7,9,11,14,18,22,28,32,38,42,55,65,有效圈数,n,6,1,2,2.25,2.5,2.75,3,3.25,3.5,3.75,4,4.25,4.5,4.75,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,10.5,11,11.5,12.5,13.5,14.5,15,16,18,20,22,25,28,30,总圈数,n1,8,2,有效圈数+1.5，2，2.5,1.5,2,2.5,材料的切变模量（MPa),G,78500,材料许用切应力（MPa),590,弹簧刚度（N/mm）,k,90.89433835,试验载荷

4、（N）,Fs,33112.71382,试验变形量(mm),fs,364.2989698,旋绕比,C,8.571428571,曲度系数/应力修正系数,K,1,1.170806604,(当C6时可调整为1),安装载荷（N）,F1,10000,安装高度（mm）,H1,479.9821465,安装变形量（mm）,f1,110.0178535,安装状态下切应力(MPa),1,178.1792949,最大工作载荷（N）,F2,28000,最大载荷过大,0.845596654,最大载荷工作高度（mm）,H2,281.9500102,最大载荷工作变形量（mm）,f2,308.0499898,最大载荷下切应力(MPa),2,498.9020257,节距(mm),t,89.58333333,89.84166496,取值范围(0.28-0.5)D,螺旋角（）,5.429700983,推荐取值5 9,自由高度(mm),H,590,591.5499898,198.0321363,高径比,b,1.966666667,满足左边条件时不用校核稳定性,两端固定b5.3一端固定一端回转b3.