Dan's springer efficiency sheet.xlsx

	A	B	C	D	E	G	H	I	J	K	L	N	O	P	Q	S	T	U	V	W	X	Y	Z	AA	AB
1	How to use:
2	1. Use the drop down box to pick a spring from the table (I cannot gurantee any measurements so please check the numbers first if you have a spring to hand)
3	2. Fill in the orange input tabs (only change the active coils number if you have cut down the spring)
4	3. See answers
5
6	Notes:
7	This is a guide only - two springs of the same type might have different dimensions due to manufacturing tolerances etc
8	Springs are never exactly as they are in this table. I have assumed material properties etc
9	If adding your own springs, or changing one of the existing ones, wire diameter is critical! Measure this very carefully
10	High 30's is a fair number for springer efficiency. Down in the 20's is not great….
11	If something seems too good to be true, it probably is. Check measurements again and make sure its not dieseling!
12
13
14
15
16				Information only, dont edit		Inputs						Interesting Outputs				Other outputs
17	Reference	Comments	Spring (choose from dropdown)	Active Coils (standard)	Length (standard)	Actual active coils	New length	Total preload (measured)	Pellet weight	Pellet speed	Stroke	Muzzle energy	Spring rate	Efficiency	Spring % compressed when cocked	Fitted length	Cocked length	Gap between coils (approx)	Coil bound length (approx)	Fitted rate	Cocked rate	Rate delta	Average rate	Recoverable energy	Recoverable energy
18					mm		mm	mm	grains	fps	mm	ft-lb	N/mm	%	%	mm	mm	mm	mm	N	N	N	N	kN	ft-lb
19	Dan's TX	TX200 mk3 .177 Mk2 piston, mk3 spring	TX200 mk3	25	226	25	226	40	8.44	760	84	10.83	5.507	38.7	83.8	186	102	0.96	78	220	683	463	452	37.93	27.98
20
21		TX200 test	test	#N/A	#N/A	26	#N/A	58	8.44	760	84	10.83	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
22
23	Anschutz 335		Custom 2	30.5	241	30.5	241	55	8.44	550	69	5.67	4.289	29.0	82.9	186	117	0.84	91.35	236	532	296	384	26.49	19.54
24
25	Diana Mod 34		Custom 4	34	264	34	264	55	16	517	91	9.50	3.848	36.6	89.8	209	118	0.49	101.5	212	562	350	387	35.19	25.95
26
27				#N/A	#N/A		#N/A					0.00	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
28
29				#N/A	#N/A		#N/A					0.00	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
30
31				#N/A	#N/A		#N/A					0.00	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
32
33
34
35
36						Dont edit	Dont edit	Dont edit	Dont edit
37	Spring Name	OD	Coil Dia	Length	Active Coils (standard)	ID	D	Standard Spring Rate	Estimated mass
38		mm	mm	mm		mm	mm	N/mm	g
39	Weepete HW57	20.3	3.1	222	24	14.1	17.2	7.496	80
40	Dan HW77	20.3	3.1	224	26.5	14.1	17.2	6.789	88
41	Vdubber HW97	18.58	2.86	202	25	12.86	15.72	6.829	65
42	vdub underlever	19	2.76	223	25	13.48	16.24	5.372	62
43	Custom 1	20.7	3.28	252	31.5	14.14	17.42	6.890	118
44	Custom 2	20.4	2.9	241	30.5	14.6	17.5	4.289	90
45	Custom 3	20.7	3.25	213	23	14.2	17.45	9.049	86
46	Custom 4	20.4	2.9	264	34	14.6	17.5	3.848	100
47						0
48	XS1	21	3.2	280	31	14.6	17.8	5.945	113
49	XS2	22.7	3.6	291	30	15.5	19.1	7.965	149
50	XS3	20.8	3.2	304	34	14.4	17.6	5.607	122
51	XS4	22.6	3.6	252	28	15.4	19	8.669	138
52	XS5	19	3	290	32	13	16	6.126	92
53	XS6	19.7	2.9	341	39	13.9	16.8	3.791	109
54	XS7	20	3.3	255	30	13.4	16.7	8.413	109
55	XS8	20	3.3	295	34	13.4	16.7	7.424	123
56	XS9	21	3.3	280	27	14.4	17.7	7.852	105
57	XS10	21	3	230	27	15	18	5.099	88
58	XS10+	21	3	230	27	15	18	5.099	88
59	XS11	18.8	3	230	31	12.8	15.8	6.567	88
60	XS12	18.9	2.875	295	36	13.15	16.025	4.571	95
61	XS13	19.4	3.1	340	39	13.2	16.3	5.420	121
62	XS14	22.4	3.6	358	37	15.2	18.8	6.772	179
63	XS15	17.5	2.3	254	33	12.9	15.2	2.394	53
64	TX200 mk2	20.8	3.25	220	23	14.3	17.55	8.895	86
65	TX200 mk3	21	3	226	25	15	18	5.507	82
66	TX200 20J FAC	21	3.35	230	29	14.3	17.65	7.829	115
67
68	Hatsan 125	19	3.6	380	48	11.8	15.4	9.497	189
69	protek v130	20.5	3.3	258	32	13.9	17.2	7.219	120
70	protek B10	20.5	3.5	257	33	13.5	17	9.175	137
71	protek B34	19	3.2	241	32.25	12.6	15.8	8.171	104
72	vortek 780105	19	2.7	292	34	13.6	16.3	3.578	81
73	vortek 780113	19.74	2.87	310	40	14	16.87	3.502	110
74	HW30	18	2.50	210	28	13	15.5	3.714	54
75	HW50/55 - 7.5J	20	3.00	215	27	14	17	6.053	83
76	hw35 - 16j	23	3.50	240	28	16	19.5	7.165	134
77	HW50/55/99 - 16j	20	3.00	225	28	14	17	5.837	86
78	hw77 16j	20.5	3.35	225	28	13.8	17.15	8.839	108
79	hw25 7.5J	17	2.50	240	32	12	14.5	3.969	58
80	HW80 - FAC	23	4	275	31	15	19	11.934	188
81	HW95 - FAC	21	3.50	295	34	14	17.5	8.163	145
82	HW77/97 - FAC	21	3.50	290	33	14	17.5	8.411	141
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100