skip nav

# Forums

#### New Player/Putting

Wed, Jun 10 2020 2:09 PM by SimonTheBeetle. 28 replies.
•  maoriand1 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 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 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 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 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.

•  maoriand1 1,196 Posts Wed, Jun 10 2020 7:02 AM

of course..i joke

•  MarchieB 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 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. ;-)