spring calculator (2).xlsx

	A	B	C	D	E	F	G	H
1	Outer diameter D	24	mm		fully compressed lenght	24,2
2	Wire diameter d	2,200	mm		will it prime?	12,8	yes if >0
3	active coils count rounded	11	coils		resulting coil height	8,636363636	мм
4	length relaxed	95	mm
5	compressed(working) length	37	mm		mean spring diameter	21,800
6
7	spring index	9,909090909	4-12 ok 7-10 good
8
9	Target spring force	120	n		Maximum allowed stress for this steel wire: [τ]	896,8189221	MPa
10	Outer diameter D	24	mm		Maximum allowed stress for this steel wire: [τ]
11	Wire diameter d	2,200	mm		Rm for steel	2100	MPa
12					desired coefficient (0.5 or less recommended)	0,5
13
14	d ^3	7,419972812
15	Minimal required d=	1,95044678	mm
16
17
18	Wire diameter d	2,200	mm			steel modulus for GOST 9389-75	78500	MPa
19	Outer diameter D	24	mm
20	Target spring force	120	н
21	Required stiffness	2068,965517	newtons/m	2,068965517	newtons/mm
22	Requred deformation	58	mm
23	Coil count:
24	from stiffness	5,096366437	coils
25	from deformation	10,72377417	coils
26
27	stiffness rounded	2,017010816	newtons/mm
28	resulting stiffness	2,068965517	newtons/mm
29	force	120	newtons
30	force rounded	116,9866273	newtons
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100