Polarization, Recoil Weight & MgR/I demystified?

[devoker]

Swingweight Calc

Sheet1 Specs,Old,New,Customization SW,322,336.87,Comment,Length (cm),Width (cm),Weight (g),Extra SW,Extra TW Weight,318,339,Tungsten Putty,0.5,0, Balance (cm),33,32.55,Overgrip,10,12,0, Twistweight,14.3,14.3,Grip Ring,19.5,1.5,0.14, RW,153.78,164.49,Dampener,39,4,3.36, Polarization,0.48,0.49,Lea...

docs.google.com

I created a spreadsheet to calculate SW,RW,PI, and MgR/I after customizations.
All the cells except the ones in borders are locked to protect the formulas. Feel free to use it.

https://imgur.com/a/InY5Ai7

 

[devoker]

Swingweight Calc

Sheet1 Specs,Old,New,Customization SW,322,336.87,Comment,Length (cm),Width (cm),Weight (g),Extra SW,Extra TW Weight,318,339,Tungsten Putty,0.5,0, Balance (cm),33,32.55,Overgrip,10,12,0, Twistweight,14.3,14.3,Grip Ring,19.5,1.5,0.14, RW,153.78,164.49,Dampener,39,4,3.36, Polarization,0.48,0.49,Lea...

docs.google.com

I created a spreadsheet to calculate SW,RW,PI, and MgR/I after customizations.
All the cells except the ones in borders are locked to protect the formulas. Feel free to use it.

https://imgur.com/a/InY5Ai7

I have just noticed that I forgot to unlock customization range . Now it is usable.

 

[devoker]

Btw I am also working on a similar spreadsheet which uses excel solver to find where to add how much weight to reach the desired rw, sw, and weight. I can also share it when it is finished. It is like twu auto customisation tool but an advanced version that considers recoil weight etc.

 

[anarosevoli]

Great, thanks. But Twistweight seems to be calculated wrongly: In the formula is "minus 10 cm" like in SW calculation.

 

[devoker]

Great, thanks. But Twistweight seems to be calculated wrongly: In the formula is "minus 10 cm" like in SW calculation.

I thought the width from the center. 10 cm is used for swing weight because it is where your hand is. For twist weight hands are in the middle of the racquet, so it is 0.

 

[anarosevoli]

I thought the width from the center. 10 cm is used for swing weight because it is where your hand is. For twist weight hands are in the middle of the racquet, so it is 0.

That's what I meant. But in your sheet in field J7 it calculates -10 for TW also.

 

[devoker]

That's what I meant. But in your sheet in field J7 it calculates -10 for TW also.

Omg you are right. I copy pasted formula over them at some point I guess.

 

[devoker]

Btw I am also working on a similar spreadsheet which uses excel solver to find where to add how much weight to reach the desired rw, sw, and weight. I can also share it when it is finished. It is like twu auto customisation tool but an advanced version that considers recoil weight etc.

In case anyone is interested I have built an excel/solver automatic customiser. It tells you where to add weight to reach the desired rw, sw, mgr/i etc.

Racquet SW/Weight/Balance/RW/MgR/I Auto Optimiser

I had previously created a spreadsheet to calculate the swingweight and others based on extra weights on the racquet. Swingweight Calc Spreadsheet I took it one step further and created a racquet spec auto optimizer using excel and solver. It works by setting target parameters and allowed...

tt.tennis-warehouse.com