SO (XLS) - Fichier XLS

Fichier partagé
SO (XLS)

Aperçu texte

Menu
Distance 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I PW AW SW Put
Minimum MAX MAX            
Average MAX MAX            
Maximum MAX MAX            
Percentage 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 2.040816326530617 
Flag 300.0 yards            
Wind 3.4 m/s            
Direction 90.0 degrees            
Temperature 23.0 degrees            
Weather s Sunny            
Ground f Fairway            
Lie low av high           
Fairway 0.98 0.99 1.0 average is calulated automatically          
Rough 0.8 0.9 1.0           
Bunker 0.66 0.74 0.82  ONLY USE THE DRIVER         
Green 0.9 1.0 1.1  ON THE TEE!         
            IF(Calc!B69<Setup!B15;"";IF(Calc!B69>110;"MAX";Calc!B69))  
Calc
Correction 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I AW PW SW Put Correction  90.0 windrose
Wind 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Wind  0.0 0.0
Temperature 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 1.0 Temperature  15.0 0.0
Weather 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Clouds  30.0 0.0
Total 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 1.0 Total  45.0 0.0
PowTotal 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 1.0 PowTotal  60.0 0.0
                 75.0 2.72
Normal Driver Wood  Iron Set           Average  90.0 3.4
Fairway 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I AW PW SW Put 1.0  105.0 2.72
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0  120.0 0.0
10.0 17.4636 9.702 15.614666666665565 18.612768932039348 22.06633333333296 22.43910899999954 19.827653999999846 15.709155000000457 14.30398200000001 12.59643 10.182199999999952 6.403319999999999 2.32848 0.5 10.0  135.0 0.0
20.0 34.60865536983339 18.886559999999772 33.300399999999044 37.225537864078696 44.13266666666592 44.87821799999908 39.65530799999969 31.418310000000915 28.60796400000002 25.19286 20.364399999999904 13.047066666666412 4.65696 1.0 20.0  150.0 0.0
30.0 60.164635531979236 41.39843399999981 50.98613333333252 53.75975533980669 58.652999999999366 57.57813599999922 51.64374599999974 42.91518000000078 38.95999800000002 34.312740000000005 28.82179999999992 20.661666666666452 10.47816 5.0 30.0  165.0 0.0
40.0 85.72061569412509 63.910307999999844 68.67186666666599 70.29397281553469 73.17333333333282 70.27805399999936 63.63218399999978 54.41205000000063 49.312032000000016 43.43262 37.27919999999993 28.276266666666494 19.79208 8.0 40.0  180.0 0.0
50.0 111.27659585627092 86.42218199999988 86.35759999999947 86.82819029126269 87.69366666666626 82.9779719999995 75.62062199999983 65.90892000000049 59.66406600000001 52.5525 45.736599999999946 35.89086666666653 29.105999999999998 10.0 50.0  195.0 0.0
60.0 136.83257601841677 108.53304 104.04333333333295 103.36240776699069 102.21399999999971 95.67788999999965 87.60905999999989 77.40579000000035 70.01610000000001 61.67238 54.19399999999997 43.021999999999984 37.25568 13.0 60.0  210.0 0.0
70.0 158.9327628865979 131.36508 121.78133333333332 119.53240776699029 115.28066666666668 107.95092 97.1817 87.51204 79.75044 69.66036 62.523999999999994 51.548 43.076879999999996 15.0 70.0  225.0 0.0
80.0 190.40591752577322 154.16478 139.25799999999998 137.5862912621359 133.50866666666664 121.40436 114.06317999999999 101.61228 90.81071999999999 81.10871999999999 70.56 58.93066666666666 53.55504 19.0 80.0  240.0 0.0
90.0 218.94513402061855 177.90233999999998 157.2573333333333 151.74681553398057 145.62800000000001 134.40503999999999 125.86728000000001 113.64275999999998 102.74418 90.03456 81.04599999999999 66.60733333333333 61.70472 19.0 90.0  255.0 0.0
100.0 234.6062912621359 197.82378 174.73399999999998 169.92629126213592 159.64199999999997 145.95042 133.20846 121.82478 110.2794 97.08467999999999 87.22 73.56533333333333 67.52591999999999 25.0 100.0  270.0 0.0
110.0 264.612476829146 221.49342600000008 192.47200000000032 186.03349514563067 174.81566666666694 159.17748000000034 147.55125000000015 134.89013999999963 121.77627000000001 107.27177999999999 96.48100000000004 81.57846666666677 73.34711999999999 29.0 110.0  285.0 0.0
999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0  300.0 0.0
XXX 264.612476829146 221.49342600000008 192.47200000000032 186.03349514563067 174.81566666666694 159.17748000000034 147.55125000000015 134.89013999999963 121.77627000000001 107.27177999999999 96.48100000000004 81.57846666666677 73.34711999999999 29.0 300.0  315.0 0.0
XXX 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0   330.0 0.0
YYY 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0   345.0 0.0
YYY 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0   6.1257422745431e-17 3.0
Forecast 152.837748608605 199.76431405196075 228.5233395492778 234.6253347592513 245.02910433062488 259.0686630789561 269.17216244665315 279.8657454736141 290.6162904074652 302.13857287145174 310.4704510375959 321.6548784589969 327.6781541694119 358.3701030927835   cosine Weather
                 factor Sunny
Low Driver Wood  Iron Set           Low   
Fairway 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I AW PW SW Put 1.0   
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   
10.0 17.2872 9.604 15.45694276094167 18.42476116504905 21.84344107744071 22.21245133333288 19.627374666666512 15.55047666666712 14.159497333333343 12.469193333333333 10.079349494949447 6.338639999999999 2.30496 0.45 10.0   
20.0 34.25907299236033 18.695786666666443 32.96403232323137 36.8495223300981 43.68688215488142 44.42490266666576 39.254749333333024 31.10095333333424 28.318994666666686 24.938386666666666 20.158698989898895 12.91527811447786 4.60992 0.9 20.0   
30.0 59.55691194074712 40.98026799999981 50.47112188552108 53.216727508091466 58.06054545454483 56.9965386666659 51.12209199999974 42.4816933333341 38.56646266666668 33.966146666666674 28.53067070707063 20.45296296296275 10.37232 4.5 30.0   
40.0 84.85475088913391 63.26474933333318 67.97821144781078 69.58393268608484 72.43420875420824 69.56817466666604 62.98943466666645 53.86243333333396 48.813930666666685 42.99390666666666 36.90264242424236 27.99064781144764 19.592159999999996 7.2 40.0   
50.0 110.15258983752071 85.54923066666653 85.48530101010049 85.95113786407822 86.80787205387165 82.13981066666618 74.85677733333316 65.24317333333383 59.061398666666676 52.02166666666667 45.274614141414084 35.52833265993253 28.811999999999998 9.0 50.0   
60.0 135.4504287859075 107.43674666666666 102.99239057239019 102.31834304207158 101.18153535353507 94.7114466666663 86.72411999999989 76.62391333333368 69.30886666666667 61.04942666666666 53.64658585858582 42.58743434343433 36.87936 11.700000000000001 60.0   
70.0 157.32738144329895 130.03816 120.55121885521885 118.32500970873785 114.11621548821549 106.86050666666665 96.20006666666666 86.62808 78.94488 68.95671999999999 61.892444444444436 51.02731313131313 42.64176 13.5 70.0   
80.0 188.48262542955328 152.60756 137.85135353535352 136.19653074433654 132.16009427609424 120.17805333333332 112.91102666666666 100.58589333333333 89.89343999999998 80.28943999999998 69.84727272727272 58.3354074074074 53.01408 17.1 80.0   
90.0 216.73356701030926 176.10534666666663 155.6688754208754 150.21401941747573 144.15701010101012 133.0474133333333 124.59589333333334 112.49485333333331 101.70636 89.12512 80.22735353535353 65.93453198653198 61.08143999999999 17.1 90.0   
100.0 232.23653074433653 195.82556 172.96901010101007 168.2098640776699 158.0294545454545 144.47617333333332 131.86292 120.59422666666667 109.16546666666666 96.10402666666666 86.3389898989899 72.82224915824915 66.84383999999999 22.5 100.0   
110.0 261.93962352784143 219.25611866666674 190.5278383838387 184.15436893203844 173.0498518518521 157.569626666667 146.06083333333348 133.52761333333297 120.54620666666666 106.18822666666665 95.50644444444447 80.75444175084185 72.60623999999999 26.1 110.0   
999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0   
XXX 261.93962352784143 219.25611866666674 190.5278383838387 184.15436893203844 173.0498518518521 157.569626666667 146.06083333333348 133.52761333333297 120.54620666666666 106.18822666666665 95.50644444444447 80.75444175084185 72.60623999999999 26.1 300.0   
XXX 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0    
YYY 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0    
YYY 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0    
Forecast 155.90624562630688 202.0575489256675 230.37613203925304 236.3880692155646 246.64103330781222 260.4825662422006 270.447455709522 280.9978897381809 291.6082114780024 302.98431275167025 311.21313513642474 322.2627215917494 328.2150413448381 360.27967930928156    
High Driver Wood  Iron Set           High   
Fairway 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I AW PW SW Put 1.0   
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0   
10.0 17.64 9.8 15.77239057238946 18.800776699029644 22.28922558922521 22.665766666666205 20.027933333333177 15.867833333333795 14.448466666666677 12.723666666666668 10.285050505050458 6.468 2.352 0.55 10.0   
20.0 34.95823774730646 19.077333333333105 33.63676767676671 37.60155339805929 44.57845117845042 45.33153333333241 40.055866666666354 31.73566666666759 28.896933333333354 25.447333333333336 20.570101010100917 13.178855218854961 4.704 1.1 20.0   
30.0 60.77235912321135 41.81659999999981 51.50114478114396 54.30278317152191 59.24545454545391 58.15973333333255 52.165399999999735 43.348666666667455 39.35353333333335 34.65933333333334 29.112929292929216 20.870370370370157 10.584 5.5 30.0   
40.0 86.58648049911625 64.55586666666652 69.3655218855212 71.00401294498454 73.9124579124574 70.98793333333269 64.27493333333311 54.961666666667305 49.810133333333354 43.87133333333333 37.65575757575751 28.561885521885348 19.991999999999997 8.8 40.0   
50.0 112.40060187502112 87.29513333333321 87.22989898989846 87.70524271844717 88.57946127946087 83.81613333333283 76.3844666666665 66.57466666666717 60.26673333333335 53.083333333333336 46.19858585858581 36.25340067340054 29.4 11.0 50.0   
60.0 138.21472325092603 109.62933333333334 105.09427609427571 104.40647249190978 103.24646464646436 96.64433333333298 88.49399999999989 78.18766666666703 70.72333333333336 62.29533333333334 54.74141414141411 43.456565656565644 37.632 14.3 60.0   
70.0 160.5381443298969 132.692 123.01144781144781 120.73980582524271 116.44511784511785 109.04133333333333 98.16333333333334 88.396 80.556 70.36399999999999 63.15555555555555 52.068686868686875 43.512 16.5 70.0   
80.0 192.32920962199313 155.722 140.66464646464644 138.97605177993523 134.85723905723904 122.63066666666667 115.21533333333333 102.63866666666667 91.728 81.928 71.27272727272728 59.525925925925925 54.096000000000004 20.900000000000002 80.0   
90.0 221.15670103092782 179.6993333333333 158.84579124579122 153.27961165048544 147.0989898989899 135.76266666666666 127.13866666666668 114.79066666666665 103.78200000000001 90.944 81.86464646464647 67.28013468013468 62.328 20.900000000000002 90.0   
100.0 236.97605177993523 199.822 176.49898989898986 171.64271844660195 161.25454545454545 147.42466666666667 134.554 123.05533333333334 111.39333333333333 98.06533333333333 88.10101010101009 74.3084175084175 68.208 27.500000000000004 100.0   
110.0 267.28533013045046 223.73073333333343 194.41616161616196 187.9126213592229 176.58148148148177 160.78533333333368 149.0416666666668 136.2526666666663 123.00633333333334 108.35533333333333 97.45555555555559 82.40249158249169 74.088 31.900000000000002 110.0   
999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0   
XXX 267.28533013045046 223.73073333333343 194.41616161616196 187.9126213592229 176.58148148148177 160.78533333333368 149.0416666666668 136.2526666666663 123.00633333333334 108.35533333333333 97.45555555555559 82.40249158249169 74.088 31.900000000000002 300.0   
XXX 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0    
YYY 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0    
YYY 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0 999.0    
Forecast 149.74683399365836 197.45784333511995 226.6615930438972 232.85443250101787 243.41025340796995 257.6493356514875 267.8923966861121 278.73002524493484 289.62158364158654 301.29077514639204 309.72616127879326 321.0459424193105 327.14040687114027 356.4490745527866    
Columns 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 for VLOOKUP formulas   
Setup
Distances Driver Wood  Iron Set           Distances
Percentage 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I PW AW SW Put Percentage
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
10.0 18.0 10.0 16.09427609427496 19.184466019418004 22.74410774410736 23.12833333333286 20.436666666666508 16.19166666666714 14.743333333333345 12.983333333333334 10.494949494949447 6.6 2.4 0.5 10.0
20.0 35.67167117072088 19.466666666666434 34.32323232323134 38.36893203883601 45.48821548821472 46.25666666666572 40.873333333333015 32.38333333333428 29.48666666666669 25.96666666666667 20.989898989898894 13.447811447811185 4.8 1.0 20.0
30.0 62.012611350215664 42.6699999999998 52.552188552187715 55.41100323624685 60.45454545454481 59.34666666666587 53.229999999999734 44.23333333333414 40.15666666666669 35.366666666666674 29.707070707070628 21.296296296296077 10.8 5.0 30.0
40.0 88.35355152971046 65.87333333333318 70.78114478114409 72.45307443365769 75.42087542087489 72.43666666666601 65.58666666666645 56.08333333333399 50.82666666666669 44.766666666666666 38.42424242424236 29.144781144780968 20.4 8.0 40.0
50.0 114.69449170920524 89.07666666666654 89.01010101010047 89.49514563106854 90.38720538720497 85.52666666666616 77.94333333333316 67.93333333333385 61.496666666666684 54.16666666666667 47.14141414141409 36.99326599326586 30.0 10.0 50.0
60.0 141.03543188870003 111.86666666666667 107.23905723905685 106.53721682847937 105.35353535353507 98.6166666666663 90.29999999999988 79.7833333333337 72.16666666666669 63.56666666666667 55.858585858585826 44.34343434343433 38.4 13.0 60.0
70.0 163.81443298969072 135.4 125.52188552188552 123.20388349514563 118.82154882154883 111.26666666666667 100.16666666666667 90.2 82.2 71.8 64.44444444444444 53.131313131313135 44.4 15.0 70.0
80.0 196.25429553264607 158.9 143.53535353535352 141.8122977346278 137.6094276094276 125.13333333333334 117.56666666666666 104.73333333333333 93.6 83.6 72.72727272727273 60.74074074074074 55.2 19.0 80.0
90.0 225.6701030927835 183.36666666666665 162.08754208754206 156.40776699029126 150.10101010101013 138.53333333333333 129.73333333333335 117.13333333333333 105.9 92.8 83.53535353535354 68.65319865319866 63.6 19.0 90.0
100.0 241.8122977346278 203.9 180.10101010101008 175.14563106796118 164.54545454545453 150.43333333333334 137.3 125.56666666666668 113.66666666666667 100.06666666666666 89.8989898989899 75.82491582491582 69.6 25.0 100.0
110.0 272.74013278617394 228.29666666666677 198.38383838383874 191.74757281553357 180.18518518518547 164.06666666666703 152.08333333333348 139.03333333333296 125.51666666666668 110.56666666666666 99.44444444444449 84.0841750841752 75.6 29.0 110.0
do not show % under 70.0 70.0 70.0 70.0 70.0 70.0 70.0 70.0 70.0 70.0 50.0 40.0 10.0 0.0 do not show % under
Wind Driver Wood  Iron Set           Wind
Meter 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I PW AW SW Put Meter
1.0 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.035 0.0 1.0
Temperature Driver Wood  Iron Set           Temperature
Degrees 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I PW AW SW Put Degrees
20.0 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 1.0 20.0
21.0 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 1.0 21.0
22.0 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 1.0 22.0
23.0 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 0.98 1.0 23.0
24.0 0.99 0.99 0.99 0.99 0.99 0.99 0.99 0.99 0.99 0.99 0.99 0.99 0.99 1.0 24.0
25.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 25.0
26.0 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.0 26.0
27.0 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.02 1.0 27.0
28.0 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.03 1.0 28.0
29.0 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.0 29.0
30.0 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.0 30.0
Weather Driver Wood  Iron Set           Weather
 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I PW AW SW Put 
Clouds 0.945 0.945 0.945 0.945 0.945 0.945 0.945 0.945 0.945 0.945 0.945 0.945 0.945 1.0 Clouds
Rain 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 1.0 Rain
Personal Driver Wood  Iron Set           Personal
Power 1W 3W 5W 3I 4I 5I 6I 7I 8I 9I PW AW SW Put Power
 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 
Blah
Atagong's Shot-Online Calculator
Shot-Online is an online multiplayer golf simulation game.
Download and information:
http://www.shot-online.com/
Some more information:
http://en.wikipedia.org/wiki/Shot_Online
This calculator is not sponsored  approved  or authorised by OnNet Entertainment.
The original sheet has been made on Excel 2000 and contains no macros.
Use at your own own risk.
I said: you use this spreadsheet at your own risk
if it messes with your computer and/or other hardware
if it messes with your spreadsheet program (that you had copied anyway)
if it messes with your Shot-Online program
if it messes with your operating system
if it messes with anything at all
I AM NOT TO BLAME
If Bill Gates can get away with that  so can I.
You are free to make changes to this calculator  and to distribute it
as long as you don't intend to make money out of it.
Be honest enough to tell that you grabbed the original
from me but that you are responsible for the changes.
Like I said:
I AM NOT TO BLAME
Some pages are password protected  this is to prevent you from
erasing the formulae. The PW is SHOTONLINE if you wanna have a peek.
This is version 3;00 from January 3  2008.
Most recent version and help at:
http://www.atagong.com/SO
or
Felix Atagong's Unfinished Projects
SO (XLS) - Fichier XLS

SO (XLS)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
