Atagong's Shot-Online Calculator

This product is no longer upgraded, but you can still download it and try.

GETTING STARTED

Basically the spreadsheet attempts to advice you what club to take and how hard to hit the ball, taking the following parameters in consideration:

• distance to the flag
• wind speed
• wind direction
• temperature
• weather conditions (clouds, rain or sunny)
• lie (fairway, rough or bunker)

The ball / lie angle and the height difference between start- and end-point are not included yet. After the ball lands it bounces and rolls a bit, a ball will roll further on the green than on a fairway, and some greens are 'faster' than others.

There are 2 main pages in the spreadsheet: Menu and Setup. A third, hidden, page is called Calc and contains most of the formulae.

The Menu is kept as small as possible so that you can adjust the Excel window. It is easier to navigate between Shot-Online and Excel that way.

MENU - CLUBS AND PERCENTAGE GRID

The header row shows the 14 clubs, from driver, woods, irons to putter.
Underneath are 4 rows:

Minimum	the softest shot (in percentage of power)
Average	the ideal shot (in percentage of power)
Maximum	the heaviest shot (in percentage of power)
The minimum and maximum percentages will be better understood when we arrive at the lie grid.
Percentage	The deviation from a 'normal' shot in percentage, taking into account:   wind speed   wind direction   temperature   weather conditions but not:   the lie (fairway, rough or bunker).

If the sun is shining, the temperature is hot and the wind is blowing from tee to flag your shot must be softer to cover the same distance. The clubs and percentage grid is read-only.

MENU - CONDITIONS GRID

The clubs and percentage grid can only make a calculation if you have filled in all the conditions of the shot.

Flag	distance to the flag in yards or the distance you would like to shoot
Wind	windspeed in m/s
Direction	wind direction in degrees (zero to 360)
North	Up	0 or 360 degrees
East	Right	90 degrees
South	Down	180 degrees
West	Left	270 degrees
The Direction cell allows integers between 0 and 360. The windrose gives an impression of the direction and windspeed.

Temperature	in degrees Celsius (default in Shot-Online)
This cell allows entries between 20 and 30 degrees.
Weather	B	There are clouds in the sky
	R	It is raining again
	S	Sunny
Ground	F	Fairway
	R	Rough
	B	Bunker (or sand)
This setting is ignored for putter (green) and driver (tee off).

MENU - LIE GRID

The game Shot-Online gives you a minimum and maximum percentage value based on the ground your ball has landed on (these values are also influenced by your stamina index inside the game). On the Shot-Online Calculator you can fill the minimum percentage in the low column and the maximum percentage in the high column.
The average is automatically calculated and is read-only.
Normally you just have to fill in these percentages once (per golf court) as they seldom change. For the green I have taken a -10 and +10 percent ratio.

IMPORTANT

To use the spreadsheet you need to convert all percentages to a ratio between 0 and 2. To add (or subtract) 1% simply add (or subtract) 0.01.
In most cases, no influence at all (100%) is represented as 1.00.
A condition that makes a ball fly further way (hot weather) adds up.
A condition that makes a ball land earlier (rain) subtracts.
Example:

85%	= 0.85 (15% decrease)
102%	= 1.02 (2% increase)
100%	= 1.00 (neutral)

Tee Off   Getting Started   Setup   Extra   Future Stuff   Download

---

Yoohoo!   users have seen this page!