Doing some more astro. I currently pull up MICA on my laptop, and find the position of a body at one minute intervals.
The tables produced seem to be text. What I'm trying to do is get the table into Excel, then add two more columns that produce the data with reverse readings. That is, the Zenith Distance would be subtracted from 360 and the Azimuth have 180 added to it.
I like to pickup the reverse readings as quickly after my direct readings, and it's a pain to do the math on the fly, minute by minute trying to catch up with the star after flipping and spinning the scope.
I can probably do the math easy enough once in Excel, but does anyone know if there's an easy way to output Excel files directly from MICA? I can't find any. Failing that, is there a simple way to parse the text data into cells in excel?
Thanks in advance.
Here's an example, out of MICA:
[PRE]
Arcturus
Apparent Topocentric Positions
Local Zenith and True North
Location: W 72?ø31'34.4", N43?ø38'58.7", 259m
(Longitude referred to Greenwich meridian)
Date Time Zenith Azimuth
(UT1) Distance (E of N)
h m s ?ø ' " ?ø ' "
2017 May 16 23:22:00.0 56 20 10.9 95 17 12.5
2017 May 16 23:23:00.0 56 09 20.8 95 28 16.3
2017 May 16 23:24:00.0 55 58 30.9 95 39 21.9
2017 May 16 23:25:00.0 55 47 41.2 95 50 29.1
2017 May 16 23:26:00.0 55 36 51.7 96 01 38.1
2017 May 16 23:27:00.0 55 26 02.4 96 12 48.8
2017 May 16 23:28:00.0 55 15 13.3 96 24 01.3
2017 May 16 23:29:00.0 55 04 24.5 96 35
[/PRE]
Save the data in a .txt file. Use Excel to open that file (you have to tell it you want other file types than its own). It should pop up the option to read it as fixed-width or delimited. You can figure out which columns you want to break it at, or pick space-delimited.
Saving it as a .txt did the trick. Thank you. Now, I only need to find the excel routine to convert DDD HH MM.M to decimal and back again so that I can subtract from 360 for the Zenith Distance. I think Scott Zelenak made one ages ago; just have to find it. This will work. Thanks again!
rfc, post: 429012, member: 8882 wrote: Saving it as a .txt did the trick. Thank you. Now, I only need to find the excel routine to convert DDD HH MM.M to decimal and back again so that I can subtract from 360 for the Zenith Distance. I think Scott Zelenak made one ages ago; just have to find it. This will work. Thanks again!
I've got a free add-in for excel that will help with that (and a few other surveyor functions). Send me your email address if you would like a copy...