Forums

New Player/Putting

• maoriand1 1,287 Posts

  Wed, Jun 10 2020 1:29 AM

  Ahaha haha Simon.. This is the same formula used by SpaceX to send the next rocket to the iss... 😂😂😂🚀

• SimonTheBeetle 3,645 Posts

  Wed, Jun 10 2020 2:35 AM

  maoriand1:

  Ahaha haha Simon.. This is the same formula used by SpaceX to send the next rocket to the iss... 😂😂😂🚀

  LOL One small formula for maoriand, one giant leap for all WGTers! ;-)

• ScottHope 10,441 Posts

  Wed, Jun 10 2020 4:22 AM

  Try this one maoriand1, a bit shorter but should work...

  =(IF(B2<0,4;B2+0,35;B2+1,35)*1,94/B1+17,9/B3)/2,25*B1+1,1  (for Italian excel users)

  You can name cells or ranges to make formulas a bit more readable...

  B1 = distance
  B2 = elevation
  B3 = speed

  ...then you can replace the cell references with the cell names.

  =(IF(elevation<0.4,elevation+0.35,elevation+1.35)*1.94/distance+17.9/speed)/2.25*distance+1.1  (for UK excel users)

  ...any better?

• maoriand1 1,287 Posts

  Wed, Jun 10 2020 5:25 AM

   

   

  IT WORKS

   

  

  thx Scott but i no need this formula for real.. i use a different one. very easy and short to calculate. 

• ScottHope 10,441 Posts

  Wed, Jun 10 2020 6:01 AM

  Yeah, I had an idea your used your own formula. But it's a good mental exercise to play around with other peoples (Jason's) maths.

  ⇩ EDIT : It's all good my friend.  ; ) ⇩

• maoriand1 1,287 Posts

  Wed, Jun 10 2020 7:02 AM

  of course..i joke

• MarchieB 1,530 Posts

  Wed, Jun 10 2020 8:29 AM

  All these Charts and Rocket Math Formulas are making my head hurt!!! 😖

  

  There is only one other way ...

  

   

   

• kipdog87 2,070 Posts

  Wed, Jun 10 2020 11:55 AM

  Try just reading the shot. ok i miss some but when they go in .....YES BABY.

  Mick

• SimonTheBeetle 3,645 Posts

  Wed, Jun 10 2020 2:09 PM

  @MarchieB

  LOL I believe you've got the wrong guy for the "Grip It & Rip It" part, though. ;-)

  

• Duffalicious 23 Posts

  Tue, Jan 3 2023 12:27 PM

  This works REMARKABLE when I get stuck on slow greens, thanks a TON!