Code: Course: Augusta National Golf Course Round: 1 Hole 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 72 Par 4 5 4 3 4 3 4 5 4 4 4 3 5 4 5 3 4 4 Player 1 A 3 5 3 2 3 2 5 5 4 5 3 4 6 4 5 3 6 5 73 -2 B 2 4 3 2 3 3 3 7 4 5 5 3 5 4 5 3 5 4 70 -3 C 4 4 2 2 4 3 3 6 4 4 7 2 4 3 6 2 5 4 69 -4 D 5 4 3 2 4 2 4 6 3 4 5 2 3 4 5 3 4 5 68 5 E 4 4 3 3 3 2 3 8 5 6 5 2 6 5 6 2 5 5 77 3 F 4 5 2 3 3 3 3 5 5 5 6 2 6 4 6 2 5 6 75 1 G 3 5 3 4 3 2 3 9 4 4 5 3 4 5 6 2 4 4 73 That's the scorecard for a round. Code: Score Strokes Player -1 3 A 40.92544239 4.735107859 0 -2 2 B -2.028115316 0 0 4 C 204.075023 90.53556901 14.26909695 0 1 5 D 276.6179177 179.2613736 42.15965936 -4.387732148 0 0 4 E 216.3096485 72.17794451 -18.08157396 0 0 4 F 242.9563937 108.5848771 -3.527383271 0 -1 3 G 78.1275212 7.277985082 0 That's the stroke by stroke information for a particular hole. The numbers are the number of yards from the hole the ball is after each stroke. Negative means it overshot.
How many yards was the hole? Player B must have hit an epic tee shot. Should probably have the yardage for each hole below the Par score on the round scorecard. Looks good though. You can probably round the distances to 1 decimal place at most, aye?
445. I don't actually know how he hit that many yards. There's a 1% chance he drive for 384 yards or more with some plus/minus but there's only a 1% chance the variance would be +48 yards or more. Either it's a bug or he got really, really lucky.
445. I don't actually know how he hit that many yards. There's a 1% chance he drive for 384 yards or more with some plus/minus but there's only a 1% chance the variance would be +48 yards or more. Either it's a bug or he got really, really lucky.
Played around with the numbers lots and I think I like the results a lot better now. Same course and hole as before. Code: Course: Augusta National Golf Course Round: 1 Hole 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 72 Par 4 5 4 3 4 3 4 5 4 4 4 3 5 4 5 3 4 4 Player 4 A 4 5 3 4 4 4 4 5 5 5 6 2 4 4 5 2 6 4 76 5 B 4 4 4 3 5 3 5 6 4 4 4 3 4 5 6 3 5 5 77 -3 C 4 5 3 4 6 2 4 4 4 3 5 3 4 4 5 2 3 4 69 5 D 5 5 4 4 4 4 4 5 5 3 5 3 5 5 4 3 5 4 77 -2 E 3 5 3 2 4 5 4 5 4 3 5 3 4 5 4 4 3 4 70 -1 F 5 4 4 4 3 2 4 6 4 4 5 3 4 4 4 3 4 4 71 -4 G 4 6 3 4 4 2 4 4 4 3 3 3 4 4 5 4 4 3 68 Code: Score Strokes Player 0 4 A 164.5 10.7 -0.1 0.0 0 4 B 194.7 -9.6 -0.6 0.1 0 4 C 108.0 9.8 -0.2 0.0 1 5 D 241.1 -11.4 -1.0 -0.2 0.0 -1 3 E 92.7 7.2 0.0 1 5 F 247.3 71.7 -5.1 0.4 -0.1 0 4 G 110.5 23.9 -1.4 -0.1
How about making the distances inverse so we know how big each shot was? I mean we still can your way but it will be quicker and easier to read
What do you mean make them inverse? Would this work? Code: Score Strokes Player 0 4 A 138.6 (306.4) -8.2 (146.8) 0.1 (-8.3) 0 (0.2) 2 6 B 186.5 (258.5) 55.6 (130.9) 2.4 (53.2) -0.4 (2.7) -0.1 (-0.2) 0 (-0.2) 1 5 C 123.3 (321.7) 17.2 (106.1) 2.9 (14.3) 0.2 (2.7) 0 (0.2) 1 5 D 281.1 (163.9) 57.8 (223.3) 13.2 (44.6) 0.7 (12.5) 0 (0.7) -1 3 E 180.1 (264.9) 9.6 (170.5) 0 (9.6) 0 4 F 213.6 (231.4) 4.3 (209.3) 0.4 (3.9) 0.1 (0.3) 0 4 G 113.1 (331.9) 16.8 (96.3) 0.8 (16) 0.1 (0.7)
Those roundings are a bit annoying. Have you used the =ROUND(x,1) sub-formula? It might help get rid of those little differences.
