Spreadsheet to compute the swing weight of a golf club...

[Guest]

I have heard that the Excel formula exists and requires the trimmed shaft
weight (in grams), shaft length (in inches), weight of the head (in grams),
the grip weight (in grams), and the fulcrum point from butt end of the grip
(14 inches) of the finished club to produce an accurate swing weight value
forthe club. It gives the swing weight prior to full assembly which is
really the best time to make adjustments.

Thanks,
CWR

 

[Niek Otten]

I couldn't find that in the Excel groups using Google's Group search.
But it seems to me that Excel is of minor importance; if you manage to get and post the formulas from whatever golf book or site,
there are no doubt tens of Excel hobbyists willing to help you.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have heard that the Excel formula exists and requires the trimmed shaft
| weight (in grams), shaft length (in inches), weight of the head (in grams),
| the grip weight (in grams), and the fulcrum point from butt end of the grip
| (14 inches) of the finished club to produce an accurate swing weight value
| forthe club. It gives the swing weight prior to full assembly which is
| really the best time to make adjustments.
|
| Thanks,
| CWR

 

[Pete_UK]

I managed to find this for you:

" ...
This gives us the equation:

SW = ((Lc*(H + S/2) - 14*(H + S) - 10G) / 50) - 124

Where:
SW = Swingweight with respect to D-0.
That is: if SW = 2, then swingweight is D-2.
if SW = -4, then swingweight is C-6.
Lc = nominal club Length (inches)
H = Head weight (grams)
S = trimmed Shaft weight (grams)
G = Grip weight (grams)

Just a few more qualifications and caveats about this equation before I

give it a rest:

To use the formula, you have to compute a trimmed length from the
shaft's raw length and raw weight (which are in most catalogs). I
usually make the simplifying assumption that it's proportional to the
trimmed length. That is:

S = raw shaft weight * (cut shaft length/raw shaft length)

Historically, this has been a decent approximation for most shafts.
However, it doesn't accommodate tip-heavy shafts, which to be accurate
must be computed by separately considering the tip-trimming and the
butt-trimming.

Ed Stephenson
.... "

As I don't play golf, it doesn't mean much to me, but it might to you.

Hope this helps.

Pete

 

[CLR]

Maybe this..........

http://www.golfsmith.com/cm/forum/view.php?bn=gsif_swingweight&key=114823374
6&last=1141863700&site=gsif
Mh x (CL-14) + Ms x (CSL/2-13.8) - 10 Mg

Mh=Head Mass, CL-Clublength, Ms=Shaft Mass, CSL=Cut Shaft Length, Mg=Grip
Mass

hth
Vaya con Dios,
Chuck, CABGx3