ࡱ> ZY 6%\pu74297 B=KY.8 @"1NArial1NArial1NArial1NArial1NArial1NArial1NArial1 NArial1NArial1 NArial1NArial1NArial1NArial1NArial1/NArial1NArial1NArial1 NArial1NSymbol1NArial1NArial1NArial1NArial1NArial1QNTahoma1N Courier New1 NArial"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00!"$"#,##0.00;[Red]\-"$"#,##0.003*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-*)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-;,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-2+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)52_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)41_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0000000000000.000 0.000000000 0,000,000.0000.000\ 000\ 000\ 000 0.00000 000,000.000 0.0000 000,000.0000 00,000.000 0,000.000000.00 00.000000.00\00\' 0.00000\" 0.000\" 00.000\" 00.00000\"0.000\ 000\ 000\00\0.000\ 000\ 00000.000\ 000\ 000\ 00.000\ 00\"0.000\ 000\ 0000 0.00000000                       #     A  @  $ #0 !0 @  $  @  ( @!4 @  ( "8 "8 @ "0 @!4  $ @ #4   h @  h   h @  ( @  @@ @ @@  $  $  $ !0  !x &0 &  !|  !| @  $ @  $ @  $ @ #0 @#0  #x  $    (  h A @" #8 @ ( #8 @ ( @ ( "0 #8  ( @ #0  #|   l   l   l  h A  ( @"x A  ( @ ( @  , @  , @ (0 @@"0  $  $ !4 @ !  !|     l  $  $  $  $ "4  $  #|  $   l @ "0 @  #| @   l @   l @   l H@   h AH@ "8 @I@ "8  ( #8 "8 !8  "| (     l @   h @   l @   l A@   l AH@    !|  !| @  !|  !| @  l @  l A   h A h  h A   h   l   l @  h  @  l @  !| @   l A@  !| @  "x @ "x A8 ``i̜̙3f3333f3ffff333ff333f33f33BBBIConstants & Parameters&C&Latitude & Longitude to E,N,Zne&RE,N Zne to Latitude & Longitude Test data 6% #Od  dMbP?_*+%=&C&F&RConstants & Parameters&L&D&CGDA Technical ManualMHP LaserJet 4M PlusanualrsLongipS A4` 4 5''''" d??U} } $} $ #x@;,,!,!,!h!,! h! ,! ! ! !!!!;;!!TEllipsoid definition UGRS80VSemi major axis (a) (m)~ nfJ)VInverse flattening (1/f)or@VFlattening (f)W!6Zwk?DVSemi-minor axis (b) (m)$X'?XA DDVFlattening (f)Y!6Zwk?DVEccentricity (e2)*Yz>k{? DDD VeYJͶ=?DA& VSecond eccentricity (e'2)$ Yߚ{? DD   e' YH $?D A   n+  b_+)[? DDDD n**2  Pyo> D D  n**3 ߔ9V4> D D  n**4 `|= D D  GW =!@ADD D  D D@A  ! TM definitionUGDA-MGAFalse easting (m)~ {AFalse northing (m)~ {cA&Central Scale factor (K0) |x#?Zone width (degrees)~ }@<Z4Longitude of the central meridian of zone 1(degrees)~ ~ f.y&Longitude of western edge of zone zero*z@gD?D%Central meridian of zone zero$zfDD:11?<K<P._/<333h,+,<.N`Q!" !rKEY" User inputM] `, /@D 88FD Text 1@INSTRUCTIONS (1) Copy & Paste the values required from the table below into the fields to the left, or enter your own values. Coord set Ellipsoid Semi Major axis Inverse Flattening GDA/MGA GRS80 6378137.0 m 298.257222101 WGS84 WGS84 6378137.0 m 298.257223563 AGD/AMG ANS 6378160.0 m 298.25 ANG CLARKE 1858 6975449.335 yd 294.26 Note: GRS80 is used with GDA94/MGA94. The GRS80 and WGS84 ellipsoids are identical for all practical purposes. (2) Proceed to the Lat/long->East/north or East/north->lat/long worksheet, and enter your coordinates. Note: For the NSW Integrated Survey Grid (ISG)- which is a Transverse Mercator projection, but not a Universal Transverse Mercator projection - use the ANS ellipsoid with the following parameters: False Easting 300,000 m Central Scale factor 0.99994 False Northing 5,000,000 m Zone width 2 Longitude of Central meridian of zone 1 141 For the Australian National Grid (ANG): False Easting 400,000 yd Central Scale factor 1.0 False Northing 4915813.467 yd Zone width 5 Longitude of Central meridian of zone 1 116R   # & F ?9Enter this longitude as + or - 0 to 180, not 0 to 360=KY.8 > 4" 6% 4(?O  dMbP?_*+%=&C&F&RLat/Long to E,N Zone&L&D&CGDA Technical Mmanual&?'p= ף?(RQ?)Q?MHP LaserJet 4M Plusmanuals + orpS A4 1@INSTRUCTIONS (1) Copy & Pa 4 5''''" c??Constants & ParametersU} Is } $s } s } Is } s } Is } s } ms } Is } ms } $s } ms } s } $ s } Is  4 h   ! !  ! !  !  !  !  !  ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !  !B Site NameS BuninyongSSAA(   Z GDA-MGA dec deg radiansD>N[dec deg[radians>> =LatitudeOBPC@VO$@q'ՠB[D  DED  D(D  D $""B#] DAOa@PK@  w#A@q D٥a@& [D  D ED   D (D   D  $ ""B# q}Zێ@ D AZone no. (real number)A@-Ln~K@ +D ZZ 6'ՠB@ DADA<DA 6 D٥a@ DAD A<D ACentral MeridianA\a@  +DZZDiff longitude (w)!\@  D B, ]K@  D D<B/ ^q#A@ D DD < a|vi@  D D# "&?  D A *ZonexK@ DB a@ D#1@  DA ! FUNCTIONS Sin latitude (sinj) beJDA   A0A pE? +D D @D  sin(2j) ! 2 DA  e2  ( "z>k{?  Z A2= I.|dd? 'D D D  sin(4j) ! Ѕ'h߿ DA  e4   "#0~? D D  A43 8O#> D D  sin(6j) ! za? DA  e6   "z">  D D  A6# r\\->  #D     !Meridian Distance ) #! Radii of Curvature # 1st term 32fO ZD D Rho(r)  Q Ȝu5BXA  ;ZD D DD?2nd term 43N'bL@ ZD D  Nu (n)  G u%q\XA  1ZD DD?3rd term 31W, ZD D  4th term 41X`<9 ZD D  sum (meridian dist) )2ǖÁO  DDDD  !Powers $ Cos latitude $ Diff long (w)      % Tan latitude  Psi (y)= Nu/Rho~ &? 'gxwU? DA "&? )D   (n DA  M?  D D ~ &@ 't? DD '')= ,_e?  DD   (E ?! D D  E0"? * D D ~ &@ 'YG ? DD '')P!7w!? DD (  io!4? + D D ~ &@ ' %?, DD '')U > DD   (vT?" D D  >FE?  D D ~ &@ 'G,!? DD '')zI\T>  DD ( ~ &@ '㑌? DD '')̾lS>  DD   (؉:q?# D D ~ &@ '? DD '')8?~)> , DD  ~ & @')Ouw=  DD   !Easting#Northing   !-6% Meridian Dist 76  <ǖÁO D 1st term $ 2ԌBA D DD  1st term - :ʏy ! D DDDD\lNh1noppUKs! !" !# !$ !% ;!& !' ( !) !* !+ !, !- !. / 1 2 3 !2nd term !3!1H<@ D DDD D  !!42nd term! A! ;{ Jߜ " +D DDDD D D "3rd term "g"1Ja  QD DDD D D D D D D x ""43rd term" " ;N J # mD DDDD  D D D D  D D D D #4th term #D#ZCY2 $.D DD=D D D  ##44th term# I# d> $ 3D DDDi' D D D  $Sum $!$2$o(A % % # $ $4Sum$ !$ < #maO % %# %Sum*K0 %-%2t]`A 'ZD$ %%4Sum*K0 % -% <xO ' ZD$ & False Origin &(&2A Z &&4 False Origin& (& <cA &Z'*Easting '++'8]5;#'A  D%D& ''5Northing' +' 9>Õ "DDDD D **2nd term* \* ~> + FDDD D D D D D +3rd term+\ +D+B(+] +D+D+<B.+_qZ? *D+D+D+<#+arcZ> + D+Aq+mzCiA> [DDDD  D D  $D D D D D ++3rd term+ :+ 0_a , $DD=D D ,4th term,\ ,D,B(,] ,D,D,<B.,_kT +D,D,D,<#,anν , D,A?,0s+p .)DDDD D ;, ,Sum, !, (UQM]? . %)+ --\? -D.B(-]G@ -D.D-<B.-_,C\3@ .D.D-D-<-a( .*Grid Convergence.Q? D-.RG@ .D-.`,C\3@ .D-#.ar? - D.A!.),Fa? . %),.., Point Scale. +-. W? 8ZD, /.////////0  1 rKEY2 p User input3 qResult(T@W8F]p0 ; /@ D eD Text 1INSTRUCTIONS (1) Enter the appropriate ellipsoid parameters and if neccessary, TM constants, on the "Constant & parameters" worksheet. (2) Enter the station name in cell C2 (documentation only). (3) Enter the latitude in cells (C4:E4). Remember that south latitude is negative. (4) Enter the longitude in cells (I4:K4). Remember that east longitude is positive. To see the intermediate steps, use the Excel "outlining" features: (i) SHOW the outline symbols, and then (ii) UNGROUP the hidden rows and columns as required.a  =KY.8 > 4; ;; " 6% 7Tl/  dMbP?_*+%=&C&F&RE, N Zone to Lat, Long&L&D&CGDA Technical ManualMRHP LaserJet 4/4M PSanualngG 4WXA4 1INSTRUCTIONS (1) Enter thePRIV''''X " W??Constants & ParametersU} s } $s } s } s }  s } s } s } $s } s } s } s } s } Is } $s } s } s } s } $ s  7h;!!;!!! ! ! ! ! !!!!!!!!!!!;!!;!!!!!! !B Station NameS BuninyongSSCC(  $Z GDA-MGA FZone G~ ?K@GHEasting #i~j A#  #Northing   mn¨;VAM False Origin (cA Z  t False origin( ccA  Z    ME' cʧ  DD   tN' c"{O  DD    ME'/K0 -cY DZ  t m = N'/K0- c)1O  D Z   "t IJJJJ   tsigma7 j -F !D AZ     IJJJJ  t2 sigma j -F D    IJJJJ  t4 sigma j -F D    IJJJJ  t6 sigma jC;u D      t8 sigma j -F D   " ttttt !Foot Point latitude udeg smin ssecsdec degsradians   #Radii of curvature # MTerm 1hB(LBg@(LL<Bffy('("LLL<eǟB( LAj -F D   w Rho' (r') cSH@BXA  rZZZ.Z@ZS?  4 MTerm 2h(g (f\3np6(eu3&&(Vj47c @Z Z D A   wNu' (n')p c̖Ju\XA ZZZZ(Z;?  4 MTerm 3h(g(fyFi7Eؿ(euB(VjHSpؾ @Z 7Z D A MTerm 4h(g(f\Q?(e׬ej\>(9jl)-6> #ZD A` MTerm 5h(g(fз%j>(eXX >(8jx&= "IZD A  MLat'hB(gD(f 1A( <eI|B(!jI+:  % "MKj Msin(j')KjmӐ  DA Msec(j')K!jHK8? % DA M t'/(k0n'r') KAjY<? +D ZZ  " LLLLPowers sns x = E'/(k0n')   &s E'2/(k02n'r')    st'=tanj' vy'=n'/r'  JJJ~ J?(jb_+)[? Z j2fcZ , DD +jO\N-]? ,DDD D  j1\߹ DA j(H?  D D   JJJ~ J@jPyo>  DDj">DR>]?  DDj`%A> - DD jt? - D D  jS"?  D D   JJJ~ J@jߔ9V4>  DDj׮  DDj4l8 9> . DD j;}ݿ D D  j⴦4?  D D   JJJ~ J@j`|=  DDj%R*"N>  DDj jҙH]? . D D  jݮj/E?  D D   JJJ~ J@jj  DDj j*ʠѿ  D D  j  JJJ~ J@ j jZVL 99> ! DD j jB6=? / D D  j DlxJ}&xaaaa&&ei&!!"!#!$!%!&!'!(!)!*+a,!-!.!/!0!12456!JJJ~ !J@!j!jA$  DD !jjj ""IJJJJ #Latitude #Deg #Min #KSecs#KDec Deg#KRadians# #  Longitude # Deg # Min #lSecs#EDec Deg#ERadians$Foot point latitude$hB $D$B($]D $D$D$<B.$f 1A D$D$D$<$dI|B($$$* LA$jI+: %D$ $ Central meridian$ h`b@($ $ $* LB($ ] $D$D$ <B.$f %D$D$ D$ <T$d`b@ $>DZZZ,#$jjk@  D$A%1st term%h %D%B(%]@ %D%D%<B.%f Ba8@ &D%D%D%<%d#n?(%$D%j{F? &.D ZD DD% % 1st term% h(% $ (% ] %D%D% <B.%f>? $ D%D% D% <#%dO~ % D%A%j:{ & DD&2nd term&h &D&B(&] &D&D&<B.&fS^¿ 'D&D&D&<&d)i(&$o&j(qꧾ 'YD ZD DDD  D D  D & & 2nd term& h(& $ (& ] &D&D& <B.&f+0uF@ 'D&D& D& <#&dȤ`? & D&A4&jD.c? 'DDD D '3rd term'h 'D'B('] 'D'D'<B.'fΞ]:G&? (D'D'D'<'dB5Yi>('$'jIP > (D ZD DDD  D  D GD D bD D D D D hD ' ' 3rd term' h(' $ (' ] 'D'D' <B.'fl٥ (D'D' D' <#'dq$7ž ' D'Al'j ͢"g (VDDxD D D  DD HD D D (4th term(h (D(B((] (D(D(<B.(fee1 $D(D(D(<(ds-ѽ(($c(jve0s *MD ZD D!Di1D D 'D ( ( 4th term( h(( $ (( ] (D(D( <B.(f?D4s8> %D(D( D( <#(df,Ӌ0> ( D(AE(jן}= */DD!=D (D D ))hB )D*B()]C )D*D)<B.)fO$ *D*D)D)<)djh]fdj**Latitude*bB  D)*RC@ *D)A*O$@ *D)A*d9IB()$!*jLk] * %$(* * + Longitude* ba@(* $ +* RK@ *D*D* <BA1*'$A@ D*D* D* <A#*d^n٥a@ * D*A!*jk{_ێ@ * %$(+MGrid Convergence +Deg +Min +KSecs+KDec Deg+KRadians+ +  Point Scale +  ,1st term,h ,D,B(,]J ,D,D,<B.,fhSH &D,D,D,<#,d[h , D,A ,jU͠  D D, , 1st term ,  ",j ?  D-2nd term-h -D-B(-] -D-D-<B.-fYB@ .D-D-D-<#-de@]#]? - D-AB-j-{? ,D DD D D - - 2nd term -  W-j}> ADD D D D D .3rd term.h .D.B(.] .D.D.<B..fa? /D.D.D.<#.dvľ . D.A~.jcn1g hD DD  D D D D D D D D . . 3rd term .  .jXf *= /D/4th term/h /D/B(/] /D/D/<B./f?3> ,///<#/d >5Z0> / D/AD/jSg= 1.D D!;MD iD -D /  / sum /  !/jӖ ? 1 %,.00h 0D1B(0]J 0D1D0<B.0fI.E 1D1D0D0<0dj 0j1*Grid Convergence1b $D01RJ 1D01`I.E 1D0#1d=*  0 D1A!1jP5ɠ 1 %,/1 1 + Point Scale 1 ++ 1k;? -D1-1j;? 1D/Z"2.////////////0 4rKEY5p User input6qResult.De&7(-;YH&]63i >? /@D hGD Text 1INSTRUCTIONS (1)Enter the appropriate ellipsoid parameters and, if necessary, the TM constants on the "Constant & parameters" worksheet. (2) Enter the station name in cell C2 (documentation only). (3) Enter the zone number in cell E3 (4) Enter the easting in cell E4. (5) Enter the northing in cell O4. To see the intermediate steps, use the Excel "outlining" features: (i) SHOW the outline symbols, and then (ii) UNGROUP the hidden rows and columns as required.a h =KY.8 > 4:::" 6% 9  dMbP?_*+%=&C&F&RTest Data &L&D&C&FMHP LaserJet 4M Plus?pS A4 1INSTRUCTIONS (1)Enter the 4 5''''" ^??cU} } } I} } } $} } m }  hh;   GDA94/MGA94 Test DataDEllipsoid definition GRS80 Bunninyong Semi major axis (a) (m)~ {fJLatitudeBPC@VO$@ Inverse flattening (1/f){r@ Longitudea@PK@w#A@ TM definition MGA Zone ~ K@False easting (m)~ {AEasting ]5;#'AFalse northing (m)~ {cANorthing >Õ " Oh+'0 hp| u74297Microsoft Excel@?)L\@x1U;@e՜.+,0 @HT `h p  Constants & Parameters Latitude & Longitude to E,N,Zne E,N Zne to Latitude & Longitude Test data  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHJKLMNOPRSTUVWXRoot EntryFPBook SummaryInformation(IDocumentSummaryInformation8Q