skip nav

Forums

New Player/Putting

Wed, Jun 10 2020 2:09 PM by SimonTheBeetle. 28 replies.
  • maoriand1 Italy
    1,196 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 Canada
    1,330 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 United Kingdom
    6,741 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 Italy
    1,196 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 United Kingdom
    6,741 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 Italy
    1,196 Posts
    Wed, Jun 10 2020 7:02 AM

    of course..i joke

  • MarchieB Canada
    630 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
    1,816 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 Canada
    1,330 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. ;-)

RSS