How to get MICA data into Excel
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]
Log in to reply.