壓縮彈簧EXCEL計(jì)算表

1、圓形截面圓柱螺旋壓縮彈簧計(jì)算,參數(shù)名稱(chēng),符號(hào),需修正的計(jì)算值,備注,公式,彈簧中徑(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,有效圈數(shù),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,總?cè)?shù),n1,8,2,有效圈數(shù)+1.5，2，2.5,1.5,2,2.5,材料的切變模量（MPa),G,78500,材料許用切應(yīng)力（MPa),590,彈簧剛度（N/mm）,k,90.89433835,試驗(yàn)載荷

4、（N）,Fs,33112.71382,試驗(yàn)變形量(mm),fs,364.2989698,旋繞比,C,8.571428571,曲度系數(shù)/應(yīng)力修正系數(shù),K,1,1.170806604,(當(dāng)C6時(shí)可調(diào)整為1),安裝載荷（N）,F1,10000,安裝高度（mm）,H1,479.9821465,安裝變形量（mm）,f1,110.0178535,安裝狀態(tài)下切應(yīng)力(MPa),1,178.1792949,最大工作載荷（N）,F2,28000,最大載荷過(guò)大,0.845596654,最大載荷工作高度（mm）,H2,281.9500102,最大載荷工作變形量（mm）,f2,308.0499898,最大載荷下切應(yīng)力(MPa),2,498.9020257,節(jié)距(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,滿(mǎn)足左邊條件時(shí)不用校核穩(wěn)定性,兩端固定b5.3一端固定一端回轉(zhuǎn)b3.