Golf Ball Value

	A	B	C	D	E	F	G	H	I	J	K	L	N
1	Number	Golf Ball Model	# (text)	Spin (RPM)	Launch Angle (deg)	Ball Class	Value	Stopping Power	$/doz	$/ball

2	1	Bridgestone B330	1	6600	30.3	1	1.85	2.64	$45	$3.75
3	2	Bridgestone B330-RX	2	6300	30.8	1	1.59	2.44	$45	$3.75
4	3	Bridgestone B330-RXS	3	6900	29.5	1	2.10	2.81	$45	$3.75
5	4	Bridgestone B330-S	4	7080	28.8	1	2.22	2.88	$45	$3.75
6	5	Callaway Hex Black Tour	5	7020	30.5	1	3.61	3.01	$30	$2.50
7	6	Dixon Fire	6	7020	29.3	1	1.33	2.88	$75	$6.25
8	7	Maxfli U/4	7	7320	27.5	1	2.61	2.95	$40	$3.33
9	8	Maxfli U/4X	8	7260	28.0	1	2.61	2.95	$40	$3.33
10	9	Nike 20XI-S	9	6900	28.8	1	1.96	2.74	$46	$3.83
11	10	Nike 20XI-X	10	6540	30.0	1	1.72	2.57	$46	$3.83
12	11	Srixon Z-Star	11	6840	31.3	1	2.28	2.92	$45	$3.75
13	12	Srixon Z-Star SL	12	6420	32.0	1	1.70	2.64	$49	$4.08
14	13	Srixon Z-Star XV	13	6540	32.0	1	2.00	2.74	$45	$3.75
15	14	Titleist Pro V1	14	6900	27.0	1	1.65	2.57	$48	$4.00
16	15	Titleist Pro V1X	15	6960	27.5	1	1.77	2.66	$48	$4.00
17	16	Wilson FG Tour	16	6660	28.3	1	1.88	2.51	$40	$3.33
18	17	Wilson FG Tour X	17	6840	28.0	1	2.06	2.62	$40	$3.33
19	18	Bridgestone E5	18	5820	32.0	2	2.09	2.17	$27	$2.25
20	19	Bridgestone E6	19	4860	36.3	2	1.30	1.71	$27	$2.25
21	20	Callaway Hex Chrome	20	6720	31.5	2	2.70	2.84	$36	$3.00
22	21	Callaway HX Diablo Tour	21	5040	35.8	2	1.52	1.82	$26	$2.17
23	22	Maxfli U/3	22	6360	29.8	2	2.78	2.41	$25	$2.08
24	23	Nike Vapor Black	23	5520	34.5	2	2.12	2.10	$25	$2.08
25	24	Srixon Q-Star	24	5940	32.3	2	2.49	2.28	$25	$2.08
26	25	Titleist NXT Tour	25	5100	35.3	2	1.09	1.83	$37	$3.08
27	26	Titleist NXT Tour-S	26	5880	32.8	2	1.66	2.26	$37	$3.08
28	27	Titleist Velocity	27	4920	34.8	2	1.26	1.68	$27	$2.25
29	28	Bridgestone XFIXX	28	4740	36.0	3	1.57	1.62	$20	$1.67
30	29	Callaway HX Diablo	29	4620	36.3	3	1.44	1.55	$20	$1.67
31	30	Maxfli U/2	30	6120	31.0	3	3.24	2.32	$20	$1.67
32	31	Srixon Soft Feel	31	5340	34.3	3	2.29	1.95	$20	$1.67
33	32	Titleist DT Solo	32	5040	34.3	3	1.45	1.74	$25	$2.08
34	33	Top Flite Gamer V2	33	5100	36.3	3	2.13	1.89	$20	$1.67
35	34	Wilson Duo	34	4860	37.0	3	1.83	1.75	$20	$1.67
36											The size of the bubbles represent the relative value of each golf ball.
37											Data extracted from Golf Digest May 2012 "Wedge Launch & Spin" chart
38
39											Stopping Power Weight Advantage (0-100+)		100
40
41												This is the advantage given to Stopping Power over Cost. A setting of 0 will weight the two equally, while a setting of 100 will use the square of the Stopping Power versus Cost.
42
43											Stopping Power =	((SPIN RATE) ^ 2) * (LAUNCH ANGLE) / 500000000
44
45												Spin Rate is squared in order to weigh it more heavily than launch angle. A ball with a higher spin rate should climb to make up for at least some of the lower launch angle. The product is then divided by 500 million to get a reasonable number to work with.
46
47											Value =	((STOPPING POWER) ^ (1 + (SP WEIGHT ADVANTAGE) / 100)) / ($/BALL)
48
49												Value is calculated as stopping power over cost, except that the stopping power is weighted by a factor specified above. This can be used to allow each person to select the importance of spin control to their game.
50
51											*There is absolutely no good science behind these calculations. Some assumptions are provided above, but no actual testing was done to calibrate this model.*
52
53											NOTE: The green shaded cell can be modified to manipulate the model. The unshaded cells contain formulas and should not be overwritten.
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73