SLALOM COURSE STANDARD THREE-POINT SURVEY REDUCTION (V3.50 JUN 2008) Approved by AWSA Tech Comm SLALOM COURSE SURVEY -- CORRECTION PLANNING -- (V3.50 JUN 2008) SLALOM COURSE SURVEY -- CORRECTION MOVEMENT MAP -- (V3.50 JUN 2008) Bell Acqua Lake 3 - Steve Grubbs Survey Date: 8/24/17 Scroll right to Cell AA1 (F5) to A183 for Instructions & Help. Errors & Fixes shown in: Bell Acqua Lake 3 - Steve Grubbs Survey Date: 42971 Owen Letcher - TC to Plan Corrections ---> Print Range AA1..AO60 for this section. 0 " (0=Cm, 1=Inches)" (F5) to A183 for Instructions. Survey Baseline A to B B to C A to C Objects to be Moved are indicated with surrounding ** Movemt Basis: Prt Rng A1..T60 for this section. Lengths (Mtrs): 100.970 104.226 205.196 Derived Width Measures "Error / Fix X-POS: - Toward Entrance, else Away" Scroll right to Cell BA1 "Move each flagged object by the displayed amount(s)," ------------- from fitted centerline "Orientation Width: - Narrower, else Wider" for Correction Map ----> in the direction(s) indicated -- towards that number 0 " (0 = Cm," Angular Sighting Input Values Sighting Transformed " (- is Narrow, + is Wide)" and away from that object's Identification Code. 1=Inches) Buoy ---- - - - - - - - --- Errors Coordinates ------------------------ Buoy Initial Errors Planned Fixes Revised Errors " ""To Fix"" Sighting" Tar- Station A Station B Station C -------- ------------- Ideal +/- Width Obj- -------------- ------------- -------------- fm Survey Station B get: Deg Min Sec Deg Min Sec Deg Min Sec OK Value X-Pos Width Value Limit Error OK ect: X-Pos Width OK X-Pos Width X-Pos Width OK Dist Deg Min Sec Print Range 0 0 0 0 0 0 0 0 0 0 ----- ---- - --- ----- - --- ----- - --- --------- ------ ------ ------ ------ -------- ---- ------ -------- ------ ------ ------ -------- ---- ----- - --- BA1..BW58 for 0 0 P2 0 0 0 0 P1 0 0 P1 22 44 50 10 38 0 6 48 45 0 0.094 -54.94 1.138 1.150 0.115 -0.012 0 P1 6.5 -1.2 0 6.5 -1.2 0 0.00 0 0 0 this Section. 0 0 0 0 0 0 0 0 0 0 P2 21 21 30 9 56 20 6 21 55 0 0.064 -55.07 1.121 1.150 0.115 -0.029 0 P2 -7.1 -2.9 0 -7.1 -2.9 0 0.00 0 0 0 G1 52 2 45 15 4 15 8 25 50 0 0.032 0.01 1.261 1.250 0.063 0.011 0 G1 0.7 1.1 0 0.7 1.1 0 0.00 0 0 0 G2 49 56 25 14 2 0 7 49 25 0 0.084 0.03 1.233 1.250 0.063 -0.017 0 G2 3.4 -1.7 0 3.4 -1.7 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 G3 90 11 50 18 47 35 9 28 20 0 0.093 26.99 1.127 1.150 0.115 -0.023 0 G3 -1.2 -2.3 0 -1.2 -2.3 0 0.00 0 0 0 0 0 G2 0 0 0 0 G1 0 0 G4 90 13 50 17 36 40 8 50 35 0 0.097 27.00 1.183 1.150 0.115 0.033 0 G4 0.1 3.3 0 0.1 3.3 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 S1 90 18 50 12 5 0 6 1 50 0 0.071 26.91 11.494 11.500 0.115 -0.006 0 S1 -8.8 -0.6 0 -8.8 -0.6 0 0.00 0 0 0 S2 132 38 5 36 44 10 15 12 10 0 0.069 67.95 11.507 11.500 0.115 0.007 0 S2 -5.2 0.7 0 -5.2 0.7 0 0.00 0 0 0 G5 140 9 35 29 47 55 11 46 20 0 0.086 67.92 1.126 1.150 0.115 -0.024 0 G5 -7.6 -2.4 0 -7.6 -2.4 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G6 142 5 45 28 6 10 10 59 50 0 0.090 67.91 1.180 1.150 0.115 0.030 0 G6 -9.3 3.0 0 -9.3 3.0 0 0.00 0 0 0 0 0 S1 0 0 0 0 G4 0 0 0 0 G3 0 0 G7 157 19 15 61 12 40 15 32 30 0 0.070 108.92 1.171 1.150 0.115 0.021 0 G7 -7.7 2.1 0 -7.7 2.1 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G8 158 42 20 59 28 25 14 32 15 0 0.068 108.91 1.141 1.150 0.115 -0.009 0 G8 -8.9 -0.9 0 -8.9 -0.9 0 0.00 0 0 0 S3 165 14 15 48 53 15 9 56 35 0 0.052 108.91 11.494 11.500 0.115 -0.006 0 S3 -8.9 -0.6 0 -8.9 -0.6 0 0.00 0 0 0 S4 160 5 25 116 28 15 28 30 40 0 0.034 149.97 11.501 11.500 0.115 0.001 0 S4 -2.7 0.1 0 -2.7 0.1 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G9 164 25 20 122 55 15 22 37 25 0 0.100 149.92 1.182 1.150 0.115 0.032 0 G9 -7.9 3.2 0 -7.9 3.2 0 0.00 0 0 0 0 0 TNL 0 0 0 0 G6 0 0 0 0 G5 0 0 0 0 S2 0 0 G10 165 25 15 124 45 15 21 15 15 0 0.086 149.93 1.110 1.150 0.115 -0.040 0 G10 -7.1 -4.0 0 -7.1 -4.0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G11 168 11 45 151 34 0 39 47 30 0 0.099 190.96 1.185 1.150 0.115 0.035 0 G11 -3.6 3.5 0 -3.6 3.5 0 0.00 0 0 0 G12 168 58 20 153 12 20 37 48 50 0 0.098 190.94 1.133 1.150 0.115 -0.017 0 G12 -6.1 -1.7 0 -6.1 -1.7 0 0.00 0 0 0 S5 172 31 45 161 9 20 27 48 50 0 0.078 191.08 11.504 11.500 0.115 0.004 0 S5 8.0 0.4 0 8.0 0.4 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 S6 167 46 20 156 52 45 90 18 0 0 0.071 232.21 11.490 11.500 0.115 -0.010 0 S6 21.5 -1.0 0 21.5 -1.0 0 0.00 0 0 0 0 0 S3 0 0 0 0 G8 0 0 0 0 G7 0 0 G13 170 32 30 161 52 45 89 56 55 0 0.074 232.03 1.091 1.150 0.115 -0.059 0 G13 2.6 -5.9 0 2.6 -5.9 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G14 171 10 25 163 2 15 89 57 35 0 0.069 232.03 1.227 1.150 0.115 0.077 0 G14 3.3 7.7 0 3.3 7.7 0 0.00 0 0 0 G15 171 35 0 165 21 15 128 13 20 0 0.077 259.10 1.294 1.250 0.063 0.044 0 G15 9.9 4.4 0 9.9 4.4 0 0.00 0 0 0 G16 172 12 0 166 24 10 130 21 0 0 0.092 259.06 1.267 1.250 0.063 0.017 0 G16 6.1 1.7 0 6.1 1.7 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 P15 173 12 55 169 36 15 157 24 10 0 0.018 314.15 1.158 1.150 0.115 0.008 0 P15 15.3 0.8 0 15.3 0.8 0 0.00 0 0 0 0 0 G10 0 0 0 0 G9 0 0 0 0 S4 0 0 P16 173 39 55 170 17 35 158 46 50 0 0.068 314.19 1.137 1.150 0.115 -0.013 0 P16 18.6 -1.3 0 18.6 -1.3 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TNL 153 56 20 1 1 55 0 29 45 0 0.021 30.42 31.377 Angle: 45.90 1.90 0 ------ ------ ------ ------ TFR 158 37 0 140 31 45 80 21 55 0 0.030 219.23 42.268 Angle: 46.69 2.69 0 7.2 2.2 <- Mean Abs Errs -> Mean Abs Errs 7.2 2.2 Skier Buoys BSLN 180 0 0 180 0 0 0 0 0 0 0 <- ACTUAL (Baseline Chks) DERIVED -> 0 0 Avg Width OK 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ----- ---- - - ----- - - ----- - - ------ ------ ------ ------ ------ ------ TNL Angle: 45.90 0 Angle: 45.90 0 --------- -- 0 0 S5 0 0 0 0 G12 0 0 0 0 G11 0 0 0 0 TFR 0 0 Avg Sighting Error: 0.074 0 11.498 Avg Width (R/C Min 11.48) TFR Angle: 46.69 0 Angle: 46.69 0 11.498 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Diagonal Distances and Errors --- Derived Up-and-Down Course Distances and Computed Errors --- Derived Up-and-Down Course Distances and Computed Errors Seg- ------- - - - - ---- +/- G2/G4/G6 Side G1/G3/G5 Side Thru Skier Buoys Seg- +/- G2/G4/G6 Side G1/G3/G5 Side Thru Skier Buoys 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ment Actual Ideal Error OK Lim Ideal Lim Leng Error OK Leng Error OK Leng Error OK ment Ideal Lim Leng Error OK Leng Error OK Leng Error OK 0 0 G14 0 0 0 0 G13 0 0 0 0 S6 0 0 ----- ------ ------- ----- -- --- --- ----- ---- --------- ---- --------- ---- --------- ----- --- ----- ---- --------- ---- --------- ---- ----- -- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G-S1 29.250 29.347 -0.097 0 .147 27 .135 26.967 -0.033 0 26.980 -0.020 0 26.891 -0.109 0 G-S1 27 .135 26.967 -0.033 0 26.980 -0.020 0 26.891 -0.109 0 S1-2 47.043 47.011 0.032 0 .235 41 .205 40.906 -0.094 0 40.936 -0.064 0 41.036 0.036 0 S1-S2 41 .205 40.906 -0.094 0 40.936 -0.064 0 41.036 0.036 0 S2-3 46.979 47.011 -0.032 0 .235 41 .205 41.004 0.004 0 40.999 -0.001 0 40.963 -0.037 0 S2-S3 41 .205 41.004 0.004 0 40.999 -0.001 0 40.963 -0.037 0 0 0 0 0 0 0 0 0 0 0 S3-4 47.062 47.011 0.051 0 .235 41 .205 41.019 0.019 0 40.999 -0.001 0 41.062 0.062 0 S3-S4 41 .205 41.019 0.019 0 40.999 -0.001 0 41.062 0.062 0 0 0 G16 0 0 0 0 G15 0 0 S4-5 47.107 47.011 0.096 0 .235 41 .205 41.010 0.010 0 41.043 0.043 0 41.108 0.108 0 S4-S5 41 .205 41.010 0.010 0 41.043 0.043 0 41.108 0.108 0 0 0 0 0 0 0 0 0 0 0 S5-6 47.125 47.011 0.114 0 .235 41 .205 41.094 0.094 0 41.061 0.061 0 41.134 0.134 0 S5-S6 41 .205 41.094 0.094 0 41.061 0.061 0 41.134 0.134 0 S6-G 29.214 29.347 -0.133 0 .147 27 .135 27.029 0.029 0 27.074 0.074 0 26.866 -0.134 0 S6-G 27 .135 27.029 0.029 0 27.074 0.074 0 26.866 -0.134 0 0 0 0 0 0 0 0 0 0 0 Left End Pre-Gate 55 .275 55.105 0.105 0 54.943 -0.057 0 NOTE - Measures P1-G1 & P2-G2 .275 55.105 0.105 0 54.943 -0.057 0 NOTE - Measures 0 0 P16 0 0 0 0 P15 0 0 Calculated Right End Pre-Gate 55 .275 55.124 0.124 0 55.054 0.054 0 Errs and Limits G15-P15 & G16-P16 .275 55.124 0.124 0 55.054 0.054 0 Errs and Limits 0 0 0 0 0 0 0 0 0 0 ---------- Overall Course Length 259 .648 259.03 0.027 0 259.09 0.092 0 in this section G1-G15 & G2-G16 .648 259.03 0.027 0 259.09 0.092 0 in this section 19 Sep-17 Gate to 3rd Buoy 109/259ths .115 109.13 0.121 0 108.92 -0.123 0 all in Meters. G1-G7 & G10-G16 .115 109.13 0.121 0 108.92 -0.123 0 all in Meters. -- Initial -- -- Revised -- To Fix Sightings converted to Fractional Radians --- Triangle Vertex Sines ---- ------- Triangle Sides ------- Abs(Errs) Abs(Errs) Sta B Loc: Sta A Sta B Sta C A-B A-C B-C Largest S A S B S C """S""" Loc: X-Pos Width X-Pos Width Angle ----- ----- ----- ----- ------ ------ ------ ------ ------ ------ ------ ------ ---- ------ ------ ------ ------ ----- P1 0.397013923 1 0.185586677 0.118900555 0.209855578 0.274542 0.274542 0.066636707 0.274542 0.123089765 0.507127554 0.38764031 0.508928814 P1 6.460203042 1.218891739 6.460203042 1.218891739 0 P2 0.372773239 1 0.173466335 0.111095055 0.197990003 0.25870197 0.25870197 0.062330849 0.25870197 0.083850337 0.348017841 0.266345299 0.349106738 P2 7.064107093 2.857778732 7.064107093 2.857778732 0 G1 0.908371154 1 0.263035663 0.147140952 0.601466495 0.689812618 0.689812618 0.115635443 0.689812618 0.037462518 0.223479213 0.194857641 0.227899686 G1 0.727649888 1.114127541 0.727649888 1.114127541 0 G2 0.871622277 1 0.244927872 0.136547773 0.586470532 0.670642423 0.670642423 0.108168046 0.670642423 0.098069314 0.608030232 0.531716756 0.618908151 G2 3.414686085 1.702931634 3.414686085 1.702931634 0 G3 1.574238504 1 0.328000696 0.165321465 0.947791603 0.986926135 0.986926135 0.161962641 0.986926135 0.103013035 0.627714243 0.602823522 0.6667754 G3 1.225072906 2.279641148 1.225072906 2.279641148 0 G4 1.57482028 1 0.307371874 0.154340435 0.954341759 0.988723734 0.988723734 0.15243484 0.988723734 0.10627937 0.689349862 0.665378343 0.730503788 G4 0.10756745 3.290106476 0.10756745 3.290106476 0 S1 1.576274721 0.210893951 0.10525305 0.978976306 0.995026637 0.995026637 0.105444519 0.995026637 0.075023528 0.707959119 0.696539346 0.739760997 S1 8.840846944 0.561590146 8.840846944 0.561590146 0 S2 2.314912605 0.641166093 0.265338528 0.994705309 0.887558669 0.994705309 0.36704246 0.994705309 0.087967484 0.21271736 0.238396733 0.269540789 S2 5.199107771 0.6953277 5.199107771 0.6953277 0 G5 2.446248631 1 0.520083876 0.205464038 0.937518363 0.783828952 0.937518363 0.309454993 0.937518363 0.111338368 0.282012696 0.337308389 0.365329726 G5 7.627324383 2.414144399 7.627324383 2.414144399 0 G6 2.480040145 1 0.490486001 0.191937736 0.913594749 0.753579327 0.913594749 0.294133 0.913594749 0.117299857 0.300526454 0.364340396 0.391083354 G6 9.318216467 2.956381206 9.318216467 2.956381206 0 G7 2.745766524 1 1.068335428 0.271253255 0.994319898 0.6186941 0.994319898 0.715320171 0.994319898 0.130983613 0.113290233 0.182071775 0.21317281 G7 7.715092002 2.051707718 7.715092002 2.051707718 0 G8 2.769934486 1 1.038010332 0.25372724 0.987046972 0.585409781 0.987046972 0.706317867 0.987046972 0.131959302 0.109370398 0.1844071 0.2128684 G8 8.926730987 0.928315538 8.926730987 0.928315538 0 S3 2.883938423 0.853247838 0.173539057 0.896099437 0.417955163 0.896099437 0.628566553 0.896099437 0.120890679 0.080384302 0.172344629 0.186809805 S3 8.884895043 0.602186545 8.884895043 0.602186545 0 S4 2.794102448 2.032799524 0.497612762 0.689865266 0.748039451 0.748039451 0.999366046 0.999366046 0.080537986 0.060283808 0.055595604 0.098208699 S4 2.727797209 0.051025808 2.727797209 0.051025808 0 G9 2.869709141 1 2.145373261 0.394856503 0.662638203 0.618427445 0.662638203 0.983893705 0.983893705 0.271099002 0.170399569 0.182581263 0.312039917 G9 7.850814779 3.153894449 7.850814779 3.153894449 0 G10 2.887138193 1 2.177370964 0.370955188 0.651657229 0.585429434 0.651657229 0.97236992 0.97236992 0.24222852 0.145837199 0.162335303 0.275200511 G10 7.07225702 3.978795446 7.07225702 3.978795446 0 G11 2.93557108 1 2.64533737 0.694495598 0.286176169 0.783648284 0.783648284 0.928647778 0.928647778 0.410884599 0.346728887 0.126619998 0.442116742 G11 3.567488849 3.46372019 3.567488849 3.46372019 0 G12 2.949121622 1 2.673941377 0.659976864 0.271720405 0.752893722 0.752893722 0.903397669 0.903397669 0.415976189 0.346675525 0.125115686 0.4438837 G12 6.118002755 1.671706563 6.118002755 1.671706563 0 S5 3.011202014 2.812695052 0.485443939 0.197205833 0.577639983 0.577639983 0.727273824 0.727273824 0.374497569 0.297446109 0.101547866 0.386745772 S5 8.042191326 0.360747247 8.042191326 0.360747247 0 S6 2.928177671 2.738057986 1.576032315 0.188976425 0.97619096 0.97619096 0.917610158 0.97619096 0.393603048 0.418730911 0.081060237 0.446697098 S6 21.47187444 0.950618816 21.47187444 0.950618816 0 G13 2.976513595 1 2.825324449 1.569899421 0.15061382 0.986552359 0.986552359 0.950681279 0.986552359 0.513126721 0.532488005 0.081293255 0.563453991 G13 2.57937792 5.871560988 2.57937792 5.871560988 0 G14 2.987543106 1 2.845541179 1.570093347 0.141525174 0.988265437 0.988265437 0.956700763 0.988265437 0.511234128 0.528101407 0.075627094 0.557481315 G14 3.259462243 7.735905216 3.259462243 7.735905216 0 G15 2.994694108 1 2.88597464 2.237899952 0.108505419 0.686594198 0.686594198 0.603652576 0.686594198 0.494058895 0.56194239 0.08880616 0.572403723 G15 9.931552979 4.388267052 9.931552979 4.388267052 0 G16 3.005456972 1 2.904276357 2.27503668 0.101008064 0.667182767 0.667182767 0.588530226 0.667182767 0.616932134 0.699380372 0.105882617 0.711097561 G16 6.134020035 1.650108091 6.134020035 1.650108091 0 P15 3.023176912 1 2.960151133 2.747196724 0.062984061 0.272490164 0.272490164 0.21134849 0.272490164 0.079758027 0.102831479 0.023768726 0.103179116 P15 15.29514454 0.764596724 15.29514454 0.764596724 0 P16 3.031030894 1 2.972174513 2.771243483 0.058822406 0.256875102 0.256875102 0.199581716 0.256875102 0.296623654 0.381774608 0.087423425 0.382910844 P16 18.57544306 1.340897675 18.57544306 1.340897675 0 TNL 2.686740458 -- 0.018010828 0.008653924 0.455437007 0.447087039 0.455437007 0.009356768 0.455437007 0.020996014 1.003235976 1.021972794 1.023102392 TNL TFR 2.768383082 20 2.452696653 1.402638702 0.310469052 0.979050409 0.979050409 0.867452059 0.979050409 0.105568492 0.119149956 0.037783932 0.13125119 TFR BSLN 3.1416 3.1416 0.0000 <-- Baseline Cross-Sighting Angles BSVA 0.0000 3.1416 0.0000 <-- Baseline Vertices (Calc Fm Angles) Coordinates of X-POS Y-POS BSVL 0.0000 3.1416 0.0000 <-- Baseline Vertices (Calc fm Lengths) Station B ---> 100.97 0 Diffs: 0 0 0 <-- Diffs betwn Vert Calcs above (secs) Revised Trans- REVISED COORDINATE TRANSFORMATION TO NEW FIT LINE formed Coords ------------------------------------------------- BISECTOR SLOPES " ""Ideal"" Coords" -------------- TRANSLATED TRANSL-POLAR ROTATED-POLAR Loc: D(a-b) Y(a-b) X(a-b) D(a-c) Y(a-c) X(a-c) D(b-c) Y(b-c) X(b-c) A-B B-C Loc: X-POS Width X-Pos Width X-POS Y-POS DIST ANGLE DIST ANGLE ----- ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ---- ------ ------ ------ ------ ----- ----- ----- ----- ---- ----- P1 88.78155372 34.32883059 -81.87609951 88.65846395 34.28123593 -81.7625837 288.6113768 34.23525381 -81.37768027 -0.299829429 -0.153430865 P1 -55 1.150 -54.93539797 1.137811083 -54.93500352 1.156699042 54.94717977 3.12053999 54.94717977 3.120883813 P2 88.02055038 32.05704968 -81.97537956 87.93670004 32.02651142 -81.89728799 288.6077682 31.99698261 -81.63258464 -0.280119797 -0.143248634 P2 -55 1.150 -55.07064107 1.121422213 -55.07102339 -1.10248762 55.08205784 -3.12157595 55.08205784 -3.121232127 G1 43.64916831 34.41749996 -26.84558793 43.61170579 34.38796065 -26.82254732 234.3582028 34.35939246 -26.62979526 -0.663350684 -0.208012944 G1 0 1.250 0.007276499 1.261141275 0.007710107 1.261138699 1.261162267 1.564682795 1.261162267 1.565026618 G2 41.74778679 31.95267131 -26.86828052 41.64971748 31.87761161 -26.80516451 233.6492442 31.80523228 -26.27839706 -0.624549193 -0.193085059 G2 0 1.250 0.034146861 1.232970684 0.033722936 -1.232982351 1.233443438 -1.543452439 1.233443438 -1.543108617 G3 34.31933972 34.3191364 0.118133013 34.21632668 34.21612397 0.117778425 207.3101874 34.11691766 0.712382751 -1.401696728 -0.251788322 G3 27 1.150 26.98774927 1.127203589 26.98813523 1.117924526 27.0112791 0.041399147 27.0112791 0.04174297 G4 32.01049426 32.0102351 0.128808394 31.90421489 31.90395659 0.128380732 206.8691752 31.80166903 0.785849816 -1.372390224 -0.235046635 G4 27 1.150 27.00107567 1.182901065 27.00066737 -1.192184573 27.02697435 -0.044125233 27.02697435 -0.04378141 S1 21.59037641 21.59005241 0.11828001 21.66539994 21.66507482 0.118691016 206.9150597 21.73825242 -0.573993688 -1.243687424 -0.159403401 S1 27 11.500 26.91159153 11.4943841 26.90763791 -11.50363623 29.26353746 -0.404005776 29.26353746 -0.403661954 S2 60.71468734 44.66699122 41.12338937 60.62671985 44.60227471 41.06380707 169.8461107 44.53975851 41.29386082 -10.74992338 -0.487072603 S2 68 11.500 67.94800892 11.50695328 67.95196126 11.48359054 68.91546916 0.167413923 68.91546916 0.167757745 G5 53.52144436 34.28849348 41.0955499 53.41010599 34.21716459 41.01006058 167.3762482 34.14834644 41.34027417 -11.38238255 -0.379573139 G5 68 1.150 67.92372676 1.125858556 67.92410984 1.102504783 67.93305686 0.016229995 67.93305686 0.016573818 G6 52.06070614 31.98310864 41.07794889 51.94340628 31.91104635 40.98539468 166.9181685 31.84154426 41.34304449 -11.66283429 -0.355100973 G6 68 1.150 67.90681784 1.179563812 67.90640826 -1.202911636 67.91706177 -0.017712405 67.91706177 -0.017368583 G7 88.99562104 34.31409255 82.11433259 88.86463743 34.26358913 81.99347684 127.6962112 34.21480498 82.16889132 2.860997619 -0.791919485 G7 109 1.150 108.9228491 1.170517077 108.9232451 1.13306688 108.9291383 0.010402059 108.9291383 0.010745881 G8 88.11645946 32.00045179 82.10043552 87.98450016 31.95252933 81.97748555 127.1096086 31.90624064 82.15598859 2.889526568 -0.753706084 G8 109 1.150 108.9107327 1.140716845 108.910334 -1.17816274 108.9167064 -0.010817309 108.9167064 -0.010473487 S3 84.89327188 21.6319024 82.09097641 84.7723812 21.60109789 81.97407629 124.9286143 21.57133926 82.14383228 3.258136924 -0.563822402 S3 109 11.500 108.911151 11.49397813 108.9071927 -11.53142356 109.5159822 -0.105489978 109.5159822 -0.105146156 S4 131.0175326 44.61659238 123.1866614 130.9369947 44.58916605 123.1109371 93.35827528 44.56262864 123.1597904 0.891576453 -3.169853165 S4 150 11.500 149.972722 11.50051026 149.9766673 11.44894558 150.4130283 0.076190407 150.4130283 0.07653423 G9 127.9076119 34.34910786 123.2091554 127.6365129 34.27630524 122.9480148 88.92183039 34.20607066 123.1165467 0.735338386 -3.224942386 G9 150 1.150 149.9214919 1.181538944 149.9218892 1.12999249 149.9261477 0.007537065 149.9261477 0.007880888 G10 127.302364 32.04422933 123.2033248 127.0601355 31.98325618 122.9688959 88.06592165 31.92440869 123.1201894 0.697934051 -3.271703558 G10 150 1.150 149.9292774 1.110212046 149.9288869 -1.161761042 149.9333879 -0.007748592 149.9333879 -0.00740477 G11 167.9924669 34.36575472 164.4398487 167.5815823 34.28170119 164.0376533 53.43870965 34.20066465 164.1349451 0.366319151 10.05570357 G11 191 1.150 190.9643251 1.184637202 190.9647211 1.118979296 190.9679995 0.005859546 190.9679995 0.006203368 G12 167.5117712 32.04246893 164.4185929 167.095795 31.96289897 164.0102979 52.00826106 31.88619072 164.1091401 0.342593198 10.36695829 G12 191 1.150 190.93882 1.133282934 190.938419 -1.198931934 190.9421831 -0.006279073 190.9421831 -0.00593525 S5 165.3769617 21.50255666 163.9731061 165.7514593 21.55124939 164.3444247 46.28929038 21.59863173 164.2546088 0.233768004 12.74966826 S5 191 11.500 191.0804219 11.50360747 191.0764554 -11.56930454 191.4263843 -0.06047421 191.4263843 -0.060130387 S6 209.804192 44.43624173 205.0444327 210.197795 44.51960632 205.4291062 44.60127683 44.60066545 205.4295307 0.318646652 1.505714825 S6 232 11.500 232.2147187 11.49049381 232.2186557 11.41065248 232.4988324 0.049098045 232.4988324 0.049441868 G13 208.5060585 34.26386631 205.6714951 207.9929318 34.17954403 205.1653442 34.09826453 34.09825081 205.1654171 0.245430793 1.380741041 G13 232 1.150 232.0257938 1.09128439 232.0261553 1.011508633 232.0283601 0.004359432 232.0283601 0.004703254 G14 208.1436592 31.93776524 205.6787835 207.632425 31.85932098 205.1736035 31.78370176 31.7836939 205.1736567 0.228928528 1.351490953 G14 232 1.150 232.0325946 1.227359052 232.0321589 -1.307137011 232.0358407 -0.005633371 232.0358407 -0.005289548 G15 235.2840747 34.4387159 232.7500176 234.7900158 34.36640011 232.2612798 43.65566579 34.29663248 232.2063342 0.204020354 0.654675981 G15 259 1.250 259.0993155 1.293882671 259.0997451 1.204798415 259.1025462 0.004649907 259.1025462 0.00499373 G16 235.0063976 31.89402778 232.8320809 234.3894655 31.81030048 232.2208568 41.63424315 31.72960696 232.1523025 0.188926856 0.615772307 G16 259 1.250 259.0613402 1.266501081 259.0608894 -1.355572129 259.064436 -0.005232591 259.064436 -0.004888769 P15 289.2762962 34.17486799 287.2505073 289.3560543 34.18429054 287.3297068 88.98730911 34.19342369 287.3516508 0.15106222 0.296147577 P15 314 1.150 314.1529514 1.157645967 314.1533309 1.04963304 314.1550844 0.003341136 314.1550844 0.003684959 P16 289.420929 31.93373524 287.6538036 289.1243054 31.90100678 287.358991 88.05128164 31.86936466 287.2774948 0.140911646 0.276632884 P16 314 1.150 314.1857544 1.136591023 314.1853451 -1.244615094 314.1878103 -0.003961383 314.1878103 -0.003617561 TNL 3.992769542 1.754141615 3.586808583 3.971773528 1.744917445 3.567947319 200.6136301 1.736073481 4.589881844 -4.505281472 -0.013333166 TNL 30.42290857 31.37721026 30.41211858 -31.38766849 43.70449278 -0.801182504 43.70449278 -0.800838682 TFR 206.7360605 75.37719478 192.5047459 206.630492 75.33870388 192.4064446 76.37879169 75.3014529 192.4127683 0.587332092 2.682150702 TFR 219.2328824 42.26754075 219.247402 42.19216105 223.2702437 0.190116714 223.2702437 0.190460537 ROTATED TO BASELINE ORIENTATION PLANNED MVMTS Initial Coordinates TRANSLATED TRANSL-POLAR ROTATED-POLAR " ""FIXED"" BASELINE COORDINATES" BASELINE-POLAR FITTED-POLAR CONV TO MTRS Loc: X-POS (Insc Y-POS X^2 X*Y Loc: X-POS Y-POS DIST ANGLE DIST ANGLE Loc: X-POS Y-POS X^2 X*Y DIST ANGLE DIST ANGLE X-POS Y-POS ----- ------ Ctr) ------ --- ----- ----- ------ ------ ------ ------ ------ ------ ---- ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ P1 -81.75926853 34.29380122 6684.577991 -2803.836103 P1 -54.93500352 1.156699042 54.94717977 3.12053999 54.94717977 3.120883813 P1 -81.75926853 34.29380122 6684.577991 -2803.836103 0 -0.000343823 0 0 0 0 P2 -81.8952884 32.03461456 6706.838262 -2623.483998 P2 -55.07102339 -1.10248762 55.08205784 -3.12157595 55.08205784 -3.121232127 P2 -81.8952884 32.03461456 6706.838262 -2623.483998 0 -0.000343823 0 0 0 0 G1 -26.81655491 34.39824088 719.127617 -922.4423152 G1 0.007710107 1.261138699 1.261162267 1.564682795 1.261162267 1.565026618 G1 -26.81655491 34.39824088 719.127617 -922.4423152 0 -0.000343823 0 0 0 0 G2 -26.79054208 31.90411983 717.7331448 -854.7286647 G2 0.033722936 -1.232982351 1.233443438 -1.543452439 1.233443438 -1.543108617 G2 -26.79054208 31.90411983 717.7331448 -854.7286647 0 -0.000343823 0 0 0 0 G3 0.16387022 34.25502671 0.026853449 5.61337877 G3 26.98813523 1.117924526 27.0112791 0.041399147 27.0112791 0.04174297 G3 0.16387022 34.25502671 0.026853449 5.61337877 0 -0.000343823 0 0 0 0 G4 0.176402357 31.94491761 0.031117792 5.635158759 G4 27.00066737 -1.192184573 27.02697435 -0.044125233 27.02697435 -0.04378141 G4 0.176402357 31.94491761 0.031117792 5.635158759 0 -0.000343823 0 0 0 0 S1 0.083372898 21.63346595 S1 26.90763791 -11.50363623 29.26353746 -0.404005776 29.26353746 -0.403661954 S1 0.083372898 21.63346595 0 -0.000343823 0 0 0 0 S2 41.12769624 44.62069272 S2 67.95196126 11.48359054 68.91546916 0.167413923 68.91546916 0.167757745 S2 41.12769624 44.62069272 0 -0.000343823 0 0 0 0 G5 41.09984482 34.23960696 1689.197245 1407.242533 G5 67.92410984 1.102504783 67.93305686 0.016229995 67.93305686 0.016573818 G5 41.09984482 34.23960696 1689.197245 1407.242533 0 -0.000343823 0 0 0 0 G6 41.08214325 31.93419055 1687.742494 1311.92499 G6 67.90640826 -1.202911636 67.91706177 -0.017712405 67.91706177 -0.017368583 G6 41.08214325 31.93419055 1687.742494 1311.92499 0 -0.000343823 0 0 0 0 G7 82.09898008 34.27016906 6740.24253 2813.545927 G7 108.9232451 1.13306688 108.9291383 0.010402059 108.9291383 0.010745881 G7 82.09898008 34.27016906 6740.24253 2813.545927 0 -0.000343823 0 0 0 0 G8 82.08606904 31.95893944 6738.12273 2623.383709 G8 108.910334 -1.17816274 108.9167064 -0.010817309 108.9167064 -0.010473487 G8 82.08606904 31.95893944 6738.12273 2623.383709 0 -0.000343823 0 0 0 0 S3 82.08292771 21.60567862 S3 108.9071927 -11.53142356 109.5159822 -0.105489978 109.5159822 -0.105146156 S3 82.08292771 21.60567862 0 -0.000343823 0 0 0 0 S4 123.1524023 44.58604776 S4 149.9766673 11.44894558 150.4130283 0.076190407 150.4130283 0.07653423 S4 123.1524023 44.58604776 0 -0.000343823 0 0 0 0 G9 123.0976242 34.26709467 15153.02509 4218.197943 G9 149.9218892 1.12999249 149.9261477 0.007537065 149.9261477 0.007880888 G9 123.0976242 34.26709467 15153.02509 4218.197943 0 -0.000343823 0 0 0 0 G10 123.1046218 31.97534114 15154.74792 3936.312279 G10 149.9288869 -1.161761042 149.9333879 -0.007748592 149.9333879 -0.00740477 G10 123.1046218 31.97534114 15154.74792 3936.312279 0 -0.000343823 0 0 0 0 G11 164.1404561 34.25608148 26942.08933 5622.808838 G11 190.9647211 1.118979296 190.9679995 0.005859546 190.9679995 0.006203368 G11 164.1404561 34.25608148 26942.08933 5622.808838 0 -0.000343823 0 0 0 0 G12 164.114154 31.93817025 26933.45555 5241.505791 G12 190.938419 -1.198931934 190.9421831 -0.006279073 190.9421831 -0.00593525 G12 164.114154 31.93817025 26933.45555 5241.505791 0 -0.000343823 0 0 0 0 S5 164.2521904 21.56779764 S5 191.0764554 -11.56930454 191.4263843 -0.06047421 191.4263843 -0.060130387 S5 164.2521904 21.56779764 0 -0.000343823 0 0 0 0 S6 205.3943907 44.54775466 S6 232.2186557 11.41065248 232.4988324 0.049098045 232.4988324 0.049441868 S6 205.3943907 44.54775466 0 -0.000343823 0 0 0 0 G13 205.2018903 34.14861081 42107.81577 7007.359489 G13 232.0261553 1.011508633 232.0283601 0.004359432 232.0283601 0.004703254 G13 205.2018903 34.14861081 42107.81577 7007.359489 0 -0.000343823 0 0 0 0 G14 205.2078939 31.82996517 42110.27972 6531.760115 G14 232.0321589 -1.307137011 232.0358407 -0.005633371 232.0358407 -0.005289548 G14 205.2078939 31.82996517 42110.27972 6531.760115 0 -0.000343823 0 0 0 0 G15 232.2754801 34.3419006 53951.89864 7976.781447 G15 259.0997451 1.204798415 259.1025462 0.004649907 259.1025462 0.00499373 G15 232.2754801 34.3419006 53951.89864 7976.781447 0 -0.000343823 0 0 0 0 G16 232.2366244 31.78153005 53933.84972 7380.835258 G16 259.0608894 -1.355572129 259.064436 -0.005232591 259.064436 -0.004888769 G16 232.2366244 31.78153005 53933.84972 7380.835258 0 -0.000343823 0 0 0 0 P15 287.3290659 34.18673522 82557.9921 9822.842697 P15 314.1533309 1.04963304 314.1550844 0.003341136 314.1550844 0.003684959 P15 287.3290659 34.18673522 82557.9921 9822.842697 0 -0.000343823 0 0 0 0 P16 287.3610801 31.89248709 82576.39033 9164.659535 P16 314.1853451 -1.244615094 314.1878103 -0.003961383 314.1878103 -0.003617561 P16 287.3610801 31.89248709 82576.39033 9164.659535 0 -0.000343823 0 0 0 0 TNL 3.587853562 1.74943369 TNL 30.41211858 -31.38766849 43.70449278 -0.801182504 43.70449278 -0.800838682 TNL 3.587853562 1.74943369 12.87269319 6.276711898 0 -0.000343823 0 0 0 0 TFR 192.423137 75.32926323 TFR 219.247402 42.19216105 223.2702437 0.190116714 223.2702437 0.190460537 TFR 192.423137 75.32926323 37026.66365 14495.09314 0 -0.000343823 0 0 0 0 Baseline Derivations Conversion Baseline Derivations X-POS Y-POS Constants X-POS Y-POS ------ ------ ------ ------ ------ Centerline Points Centerline Points Sums X^2 & X*Y 473105.1842 67865.91801 0.017453293 Pi / 180 Sums X^2 & X*Y 473105.1842 67865.91801 Geometric Center 102.6757273 33.09257716 0.008726646 Pi / 360 Geometric Center 102.6757273 33.09257716 57.29577951 180 / Pi Centerline Origin -26.82426501 33.13710218 Centerline Origin -26.82426501 33.13710218 Centerline slope -0.000343823 Centerline slope -0.000343823 Centerline Rotated -0.000343823 Radians from Survey baseline Centerline Rotated -0.000343823 Radians from Survey baseline SLALOM COURSE THREE POINT SURVEY REDUCTION INSTRUCTIONS ------------------------------------------------------- a) Enter the Name of the Site and the survey date in the heading section at the top of the worksheet. Then input the baseline segment distances from station A to B and from B to C -- plus " the distance from A to C, if station B is off the baseline. If" " your baseline distances are in feet, then enter each value as " " "".3048*xxx.xx"" (where xxx.xx is the distance value in feet, to" " two decimal places), this will convert the baseline to the " " metric system, which is the official measurement basis." Then enter all the sighting angles in the sighting input area. " If your sighting Station B is off the baseline, be sure to also" input the Station-to-Station sighting values on the BSLN row -- It is CRITICAL that the Station-to-Station alignment follows the arrangement shown at the bottom of the Slalom Course Data Recording Form. IMPORTANT NOTE -- If you should enter a set of sighting and/or " distance values on the wrong row by mistake, DO NOT use the" " 1-2-3 (or equivalent for other systems) ""Move"" command to place" these values on the proper row -- you will have to re-key the " data on the proper row, and then enter the correct values for" the first row on top of the misplaced ones. b) Double check the input section to ensure that each value has been entered into the worksheet correctly -- then press the Calculate key (F9) to process the survey reduction. You can review the resulting derivations on the screen by moving the " display window around, although it is usually preferable to" print the results on paper so that you can see it all at once. The necessary Range and Setup parameters have already been pre- set in the worksheet to print the primary section -- which " consists of the input area plus the key derivative measures," including both tolerances and highlight flags. All of this information will print on a single sheet of paper. c) Examine the printout or screen carefully -- any value highlighted with asterisks (****) is outside the official " tolerances for that measurement, according to the official" " rules. If you are looking at the worksheet on the screen, be" sure to scroll over to the right to examine the one or two data columns which are lurking there. Triple check the input data relating to any buoy(s) which are involved in any such out-of- " tolerance situations, before starting to move buoys around." Large sighting errors can result from a number of possible conditions -- refer to the READSRV.TXT instruction file for suggestions on diagnosing and solving such problems. Note that there are two baseline consistency check values shown on the BSLN row: The value under the Sighting Error column " reports on the actual values of the baseline cross-sightings," showing any deviation (in seconds) from a perfect 180 degree triangle. The other value (under the Y-Pos column) reports on the sum of the discrepancies between the actual vertex angles " of the basepoint triangle as reported by the cross-sightings," and the derived vertex angles which are implied by the reported baseline segment distances -- again reported in seconds. Large values appearing at either of these check points indicates some " inconsistency with either your cross-sightings, or your base-" " line measurements, or both. The values on row 103 report the" difference between the actual and derived vertex angle values (in seconds) at each of the three basepoints -- review these if you see large values at either of the two check points above. " Note that the section headed ""Transformed Coordinates"" shows" " the X (up and down course) and Width locations of each buoy," relative to a least squares best fit centerline down the center of all the boat gate buoy pairs. You should be aware that if one or two buoys at either end of the course are significantly " off their nominal positions, that could result in several other" " width measures showing out of tolerance, instead of (or in" addition to) the offending buoys. Take this into consideration in evaluating the results. d) MAKING CORRECTIONS -- NEW FEATURES HERE -- CHECK THIS OUT ! This latest revision includes a lot of new features to help you plan and execute corrections to a slalom course. Those features are located to the right of the primary data and " derivatives area, at the top of the spreadsheet. To find this" " section, scroll over to the right, to cell AA1." " We've included a control parameter at the top of this section," that controls whether this section works with Metric or English " measures. If cell AI4 contains a zero, then all error values" " will be displayed in centimeters, and your inputs are assumed " " to be expressed in cm as well. If cell AI4 contains 1, then" the basis for both will be in inches instead of cm. Since the information you cook up in this section will eventually be used " to actually move things around later, you should use whichever" measurement basis you are more comfortable working with. " The top part of this section includes four sets of columns," arranged from left to right. The leftmost columns display the " unadjusted deviations from ideal placement, of each buoy or" " object in your survey. The ""X-Pos"" error column is the" " deviation in the up-and-down-course direction, and the ""Width""" error column is in the side-to-side direction. These errors " are signed, with Positive values in X-Pos meaning away from the" " P1-P2 end, and Positive values in Width meaning away from the" fitted centerline. Negative values indicate the opposite directions. At the bottom of each column you will find an MAD (Mean " Absolute Deviation) statistic, which is the average of the" " absolute values of the errors, in that respective direction." The second set of columns is where you will input your plan of " correction movements, with each movement separated into X-Pos" " and Width components. These are also signed values, with the" signs meaning the same directions as cited above. The third set of columns presents Revised errors. Assuming " that any correction movements you plan will actually be made," " this fits a new centerline to that revised gate layout, and" then calculates new error values from that new basis line for each object in the revised layout. There are also revised MAD statistics shown at the bottom of each column. " The fourth set of columns displays revised EDM sightings, as" " would be seen from survey Station B, of each object for which" you have input a correction movement. Once you finalize your " movement plan, this data can be used to actually accomplish" those specific movements. Note that the EDM Distance values shown for each sighting will always be expressed in meters -- the Centimeters/Inches control parameter at the top only applies to the deviation and movement plan columns. Both the Initial and Revised width columns are accompanied by a tolerance check column. The revised section will continue " to change, as your movement plan develops. There is also a" complete length measurement derivation and check area at the " bottom of this section, which reflects all of your planned" movements. The content here is almost identical to what is " shown in the primary measurement section, except that this" area will reflect the effects of your planned corrections. RECOMMENDED PROCEDURE TO DEVELOP A CORRECTION PLAN -- Since the fitted centerline is based on the locations of all " 20 gate buoys, moving ANY of these buoys will then also move" " the centerline, which in turn will affect all of the other" " deviation values for the whole layout. Consequently, you" need to develop your correction plan in a specific step-by- " step fashion, and in a specific order. After you enter each" " planned movement value, then press the F9 key to recalculate" " the spreadsheet to reflect that change, and then observe the" effect of that change on all the other measurements. Follow that same procedure through the following areas: 1) First plan side-to-side corrections in the gate " buoys, beginning with those which are most" obviously out of line with the others. The objective here is to eliminate all the Width " error tolerance checks, and/or to reduce the MAD" value which appears at the bottom of the revised Width error column. 2) Then plan the up-and-down-course movements of the gate buoys. The objective here is to elim- inate all the Length tolerance checks in the " Length check area at the bottom of this section," and/or to reduce the MAD value which appears at the bottom of the revised X-Pos error column. " 3) Once the gate layout has been corrected, THEN you" should plan any necessary movements to the skier " buoys, based on their relationships to the revised" " refitted centerline. Use the ""Thru Skier Buoys""" section at the lower right and the Width errors " on those skier buoy rows as guidance, and also" " check the revised ""Skier Buoy Average Width""." 4) Finally you can figure corrections in your Judges " tower markers, to correct the angle to the final" entrance gate locations. It's easiest to plan these corrections in the up-and-down-course " direction, although your shoreline configuration" " may dictate movement in both axis directions, in" order to get the angle you want. Note that the " Ideal angle is 44 degrees, and the +/- tolerance" " is 3 degrees -- hence the ""Good"" range is 41-47." " Then once you're satisfied with your correction plan, you" should print out a copy of this section (note the print " range cited at the top of this section), and use that data" " to execute your movements. If you have an EDM instrument," " you can guide the corrections using the ""Revised Sightings""" " shown in the rightmost columns, which will have been" " figured from your existing survey basepoint ""B""." " Alternatively, you can accomplish your corrections thru" " visual alignment of each buoy to be moved, relative to it's" adjacent neighbors in both directions. Separate observers (coaches) in both the up-and-down-course and side-to-side " directions, will help ensure that those movements are" accomplished as intended. As an additional aid to this " procedure, the revised spreadsheets also include a visual" " ""Correction Movement Map"" section, which you can print" out and work from. Scroll over to column BA1 to find this new section and the associated print range. e) After making any adjustments and/or corrections (and reshooting all or part of the survey if necessary and re-processing the " results), print out a final copy of the worksheet and attach it" to the Technical Controller's report from the tournament. Save a copy of the completed worksheet file -- DON'T save it to the original SLMSURV3 file name (which will wipe out your master " copy of the template), but save it under a name which will" " help you identify it, if and when you need to access" it again at a later date. ---------------------------------------------------------- " Excel (5.0/95) Template revised June, 2008 by David Clark" " (Former Chairman, AWSA Technical Committee) -- from a" spreadsheet originally developed by Brian Keller.