ࡱ> @? %,\p BAGD66 <-> GDA94$ ; =.z 8@"1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1Symbol1 MS Sans Serif1QTahoma"$"#,##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.000000000.0000000000000.000 0.00000.0                ( &               "  @  H  H &X &P #p @#p #p   `@ @ `@  l  h  l   ` @ `  ` @ `  `  @  H  H &X &P #p @#p #p   ` @ `  `   l  h  l   ` @ `  `   ` @ `  `  @  @  @       (  d@      $  $  $  ,  $  $  $  d@   l   d   l  l      8 ``i̜̙3f3333f3ffff333ff333f33f33BBBRAGD66 <-> Ҷٴ941Ҷ84 <-> GDA94S Test Data %, &O$4(  dMbP?_*+%=.-&Chttp://www.anzlic.org.au/icsm/gdatm.htm&R&D&~?'~?(~?)~?MHP LaserJet 4M Plusrg.au/icsm/gpS A40ĢL 4 5''''" d `? `?U} m} m}  } } } I} } m } $ &;;     ! !!! ;! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !80Transformation using abriged Molodensky formulae8.0Transformation using abriged Molodensky formulae ------.------!AGD66 to GDA94, ICSM 1997-! /GDA94 to AGD66, ICSM 1997 -----//----- AGD66  GDA94 -  0GDA94  11   0AGD66  11POSITION  deg !min "sec !deg !min "sec/POSITION  2deg  3min  4sec  3deg  3min 4secLatitude#B$C@T46</@%BD"B+&C@D"D<BA1'ӱY$@D"DD<A-Latitude 5B6C@7Џ@  8B D" B+ 9C@D" D <BA1:/@D" D D <A Longitude#a@$K@T5^I >%a#+&İ#<BA1'SEA@ D#DD<A- Longitude 5a@6K@7@  8a@ D# B+ 9K@D# D <BA1:&7>@ D# D D <A AHD ()~ J10@ %&'- Ellip. Ht  ;< ~  7h@  89 U =Nч@ D$  N(ANS) () J?5^I0@ %&' -N(ANS) ;<=89  V?5^I0@  Ellip. Ht  *+,++ Xe:ud@>!D$ -AHD >?@??  WaKiK@ DD  ELLIPSOID (ANS) ELLIPSOID (ANS) a Radius~ TXA A Radius~ TXA Inverse flattening (1/f)~ r@Flattening(f)1/f~  r@ fܜwk?D f ܜwk? D  e2 (    ZDX~  ZDX~  @ ZDY~ n ZDY~  n@ ZDZ~ @ ZDZ~  dec degradians dec deg radians Zf .BDD<D#^G DA Zf . Q܏B D D <D # 5 D A Zl .fY a@DD<D#.ǂ@  DA Zl . ka@ D D <D # `Y@ D A Zn6w<w\XA D DDADAA Zn6 ;yw\XA D D D AD AA ZrIum&{;BXA3D DDDADA? ZrI `;BXA 3D D D D AD A? sec rads  sec  radsZDf ]{݆@iDDADADDADADDAD DDDDADU>(yr[>"DAZDf  n iD D AD AD D AD AD D AD D D D D AD U>( .j>[" D A ZDlI@-@3DDADDADDAU>(=_>#DA ZDlI 0 - 3D D AD D AD D AU>( fS_# D AB!X00xzz6D\^y<8Z>>>L> !! !" !# !$ !%  ZDh (m)v e7&v*$`DDADADDADADDAD DDDDADAD ZDh (m)v Br*@$ `D D AD AD D AD AD D AD D D D D AD AD "GDA94 f #"5яB D"A"m" DD"GDA94 f #" u|B D" A" S" D D #GDA94 l ##za@ D#A#@# DD#GDA94 l ## .U a@ D# A# ɂ@# D D $ GDA94 N+H$$e:ud@ DD D $ GDA94 N+H$  =Nч@ D D %% du]P&|4 /@x(@Text 1AGD66 -> GDA94 Instructions: (1) Enter the AGD66 latitude, longitude in the shaded fields, on the left hand side of the table. (2) Enter either the AHD (MSL) height and ANS geoid-ellipsoid separation (N value), or the ANS ellipsoidal height (3) Note the transformed results in the bold field, on the right hand side of the table. Note: This spreadsheet has been setup for southern hemisphere use. If only a 2 dimensional transformation is required, the height component can be ignored, or an estimate used with no effect on the transformed latitude and longitude. Use the Excel outlining function to see the intermediate steps  N S x]FF&-4i /@( Text 2GDA94 -> AGD66 Instructions: (1) Enter the GDA94 latitude, longitude and ellipsoidal height in the shaded fields, on the left hand side of the table. (2) If height transformation to AHD (MSL) is required, enter the ANS geoid-ellipsoid separation (N value) in the shaded cell on the right hand side of the table. (3) Note the transformed results in the bold field, on the right hand side of the table. Note: This spreadsheet has been setup for southern hemisphere use. If only a 2 dimensional transformation is required, the height component can be ignored, or an estimate used with no effect on the transformed latitude and longitude. Use the Excel outlining function to see the intermediate stepshemisphere use.     YSThe conversion to decimal degrees assummes a negative (south) latitude was entered.YSThe conversion to decimal degrees assummes a negative (south) latitude was entered.=.z 8> 4????m,׉whV(}hV%0L%v0{0<@00@88pKKI,0Y88qq     "  %, '3GK  dMbP?_*+)%=&A.-&Chttp://www.anzlic.org.au/icsm/gdatm.htm&R&DMHP LaserJet 4M Plusrg.au/icsm/gpS A4 4 5''''" 9X??AGD66 <-> GDA94U} > } > } $ > } I> } $> } I>  ';;;     " """ ;" " " " " " " " " " " " " " " "80Transformation using abriged Molodensky formulae8.0Transformation using abriged Molodensky formulae ------.------!AGD84 to GDA94, ICSM 1997-" /GDA94 to AGD84, ICSM, 1997 -----/------ AGD84  GDA94 -  0GDA94  11   0AGD84  11POSITION  deg !min "sec !deg !min "sec/POSITION  2deg  3min  4sec  3deg  3min 4secLatitude#B$C@T7[ !/@%BD"B+&C@D"D<BA1'U$@>!"<A-Latitude 5B6C@7ȏ@  8B D" B+ 9C@D" D <BA1:ݥ"/@D" D D <A Longitude#a@$K@TZӌ>%a#+&İ#<BA1'S>A@ D#DD<A- Longitude 5a@6K@7@  8a@ D# B+ 9K@D# D <BA1:2>@D# D D <A AHD ()~ J10@ %&'- Ellip. Ht  ;< ~  7`@  89: N(ANS) () JDl0@ %&' -N (ANS) ;<=89  VDl0@ Ellip. Ht (ABS) *+,++ X,b@ D$ -AHD >?@??  WD@D$  ELLIPSOID (ANS) ELLIPSOID (ANS) semi major axis (a)~ TXA semi major axis (a)~ TXAInverse flattening1/f~ r@Inverse flattening1/f~  r@ fܜwk? D f ܜwk?D  e2 (    ZDX~ ` ZDX~  `@ ZDY~ YJ ZDY~  YJ@ ZDZ~ @ ZDZ~  dec degradians dec deg radians Zf .gBDD<D#&[ DA Zf . oŏB D D <D # 0 D A Zl .=uښa@DD<D#t@  DA Zl . Zץa@ D D <D # C؎@ D A Zn6%w\XA D DDADAA Zn6  -syw\XA D D D AD AA ZrIK{;BXA3D DDDADA? ZrI 0;BXA 3D D D D AD A? sec rads  sec  radsZDf 39U @iDDADADDADADDAD DDDDADU>(HA{p>"DAZDf  @7 iD D AD AD D AD AD D AD D D D D AD U>( 3p" D A ZDlI1jV@3DDADDADDAU>(@C֓>#DA ZDlI ڈ |V 3D D AD D AD D AU>( oŞ# D AB!X00xz}{6Z^^z<8Z>>>L> "! "" "# "$ "% "&  ZDh (m)v dlKM*$`DDADADDADADDAD DDDDADAD ZDh (m)v ({*@$ `D D AD AD D AD AD D AD D D D D AD AD "GDA94 f #"KB  D"A"0z" DD"GDA94 f #" B D" A" b" D D #GDA94 l ##amڥa@ D#A#ێ@# DD#GDA94 l ## fךa@ D# A# tp@# D D $ GDA94 N+H$$,b@ DD D $ GDA94 N+H$$ D@ D D D xz]r%KU4i /@x(Text 1AGD84 -> GDA94 Instructions: (1) Enter the AGD84 latitude, longitude in the shaded fields, on the left hand side of the table. (2) Enter either the AHD (MSL) height and ANS geoid-ellipsoid separation (N value), or the ANS ellipsoidal height (3) Note the transformed results in the bold field, on the right hand side of the table. Note: This spreadsheet has been setup for southern hemisphere use. If only a 2 dimensional transformation is required, the height component can be ignored, or an estimate used with no effect on the transformed latitude and longitude. Use the Excel outlining function to see the intermediate steps`N SXx]F9%x3 /@8ؽText 2GDA94 -> AGD84 Instructions: (1) Enter the GDA94 latitude, longitude and ellipsoidal height in the shaded fields, on the left hand side of the table. (2) If height transformation to AHD (MSL) is required, enter the ANS geoid-ellipsoid separation (N value) in the shaded cell on the right hand side of the table. (3) Note the transformed results in the bold field, on the right hand side of the table. Note: This spreadsheet has been setup for southern hemisphere use. If only a 2 dimensional transformation is required, the height component can be ignored, or an estimate used with no effect on the transformed latitude and longitude. Use the Excel outlining function to see the intermediate stepsh$ (*DMA Technical report 8350.2, 30 Sept 1987 "Department of Defense World Geodetic System 1984 - its definition and relationship with local geodetic systems.DMA Technical report 8350.2, 30 Sept 1987 "Department of Defense World Geodetic System 1984 - its definition and relationship with local geodetic systems.YSThe conversion to decimal degrees assummes a negative (south) latitude was entered.YSThe conversion to decimal degrees assummes a negative (south) latitude was entered.=.z 8> 4" p %, U[  dMbP?_*+%=&A.-&Chttp://www.anzlic.org.au/icsm/gdatm.htm&R&DMHP LaserJet 4M Plusrg.au/icsm/gpS A4e was entered.tem 1984 - its 4 5''''" d??AGD66 <-> GDA94cU} > } > } > } > } K> } > } $ K>         !HAGD66 to GDA94, ICSM 1997 AGD66 GDA94POSITION Ideg Imin Psec Ideg Imin PsecLatitude*CEDH@Nz@DEDH@R@ Longitude*C`b@D:@N@D`b@D:@R3@ AHD CD~ K|@ DDR N(ANS) CD~ KT@ DDR Ellip. Ht (ABS) EFOFF~ SЮ@! HAGD84 to GDA94, ICSM 1997 AGD84 GDA94POSITION Gdeg Gmin Lsec Gdeg Gmin LsecLatitude*A1BJ@M@B1BJ@Q@ Longitude*C^@D.@Ne@D^@D0@Rh@ AHD CD~ N'@ DDRN(ANS) CD~ N @ DDREllip. Ht (ABS)EFOFF~ S¥@$ ,%"nBC;>=%"nBC;>=.z 8> " Oh+'0x8@L X dp66@m @>\oc+՜.+,0@HT `h p 66 AGD66 <-> GDA94AGD84 <-> GDA94 Test Data'AGD66 <-> GDA94'!Print_Area  Worksheets Named Ranges  !"#$%&'()*+,-.012345689:;<=>Root EntryFBook \SummaryInformation(/DocumentSummaryInformation87