?       !"#$%&'()*+,-./0123456789:;<=>?2       \AAA DF0 8 DP0"@ DP1"" D! G9? G:? G;? G<? GC0?5 Arial MT5! Arial5" Arial5# Arial5$ Arial MT5% Arial !!""            %!%"%#%$%% &      @  @@  @@  @@  @               @ @@ @@  @ ? ? ? ? q@'Currentqqqq0*q0* h5*??1*1*DD1*1*22(4*%%%%%%%%%%%%%%%'UTM FROM LAT/LONG'aSQ @' 'The answers are in('This works with standard USGS maps'eC|?hԭ? ~b]"? (p9s? 'these columns.$'CALIFORNIA CENTRAL MERIDIAN =   nd@ &h'dm'fx'fy''INPUT - LATITUDE LONGITUDE 'ELEV 'Rp  'N^2'f1'f2'f3'X'Y 'UTM E 'UTM N ' DEG ' MIN ' SEC ' DEG ' MIN ' SECDJ<Z+@x +@x  m?&h X,{@&h. P:V} @ '#/ B`3? ( (:W¸?  Eoh?q?    K9Jϛ?@ Z  'We˜y$? Z  'F   '+贎d @&1~Ҩ? ) *[@  ) J|]D@   (  ( k`0 @   ( ' 0 ' (%Ϳ@?!?ƒ @?!H%u?F,<J<+@x +@@x  p?&h PƒJ@&h. )X @ '#/ h( Ct? ( ɩ?  E7l ʝ?    K@A5M?@ Z  'W| A? Z  'F   '+q @&h%~? ) *Q[,@  ) JpX@   (  ( kXRl @   ( ' 0 ' (%E O@?!#KX @?!H%u?HZJ<+@x +@@x  WX3?&h |W,5@&h. <㼓 @ '#/ (/TZ? ( 1>V  EH(!?    K?@ Z  'WXxy҂? Z  'F   '+-n I @&Ǭkݽ? ) *+csj@  ) J׿    (  ( k!\ @   ( ' 0 ' (%-zOgw@?!-B @?!H%u?JZ+HDDDD@x +@x  Lwt?&h vO:@&h. J @ '#/ pJw? ( `ߛOw  EC]+?    K:c?@ Z  'W+񭸺? Z  'F   '+XGZ @&c? ) *@(@  ) J`e)w   (  ( k@< @   ( ' 0 ' (%K%@?!0; ـ @?!H%u? 'H9:A9+B9/60+C9/3600 'I10:D10+E10/60+F10/3600 'J11:H11*@PI/180, 'Spreadsheet by Dr. Don Stierman (1996) 'k12:I12*@PI/180/ 'Geology Department - University of Toledo( 'L13:H$1/@SQRT(1-I$2*(@SIN(J13)^2))!'dstierm@geology.utoledo.edu% 'M14:(I$2/(1-I$2))*(@COS(J14))^2*'File sent to Karen Nakamura 10/10/96 'N15:M$3-K15.'O16:(1-I$2/4-(3/64)*J$2-(5/256)*K$2)*J16('CENTRAL MERIDIAN CALCULATION HERE  :'P17:((3/8)*I$2+(3/32)*J$2+(45/1024)*K$2)*@SIN(2*J17),'Central Meridians are 6 degrees apart. @ L'Q18:((15/256)*J$2+(45/1024)*K$2)*@SIN(4*J18)-(35/3072)*K$2*@SIN(6*J18)J'Pick the central meridian within 3 degrees of your area of interest.'R19:(O19-P19+Q19)*H$1;'It's not very pretty but it works - as far as I know.'S20:1-(@TAN(J20))^2+M20a'I've also a spreadsheet that does the inverse (UTM to Lat/Long) - send an e-mail request to'T21:5-(@TAN(J21))^2+9*M215'dstierm@geology.utoledo.edu if you need a copy.;'U22:L22*(N22*@COS(J22)+((N22^3*(@COS(J22))^3*S22)/6))\'V23:(L23*((N23^2)/2)*@COS(J23)*@SIN(J23)+((N23^4)/24)*@SIN(J23)*(@COS(J23))^3*T23)+R23' 'W24:500+0.9996*U24' 'X25:0.9996*V25'Y26:G26/0.30286A  ??@V,BLB-d_  Arial MT  O!4!*&d"dFM3FM3 PropertyWK3WK3 Property  ' F&' 'F&D' 'CMHdr'