Noting the times which transiting planets make aspects to sensitive points
in a natal chart is a common tool
used in astrology. This article will show how this can be achieved using Astrolog.
Our goal will be to display this list in Excel. We will describe how to do
this for three different versions
First, open a chart, or enter the details of the natal chart of interest - the time and place.
|Astrolog32||File -> Open Main Chart|
|16-bit Astrolog||File -> Open Chart|
|64-bit Astrolog||File -> Open Chart|
Define a new chart
|Astrolog32||Edit -> Enter/Edit Main Chart Data|
|16-bit Astrolog||Info -> Set Chart Info|
|64-bit Astrolog||Info -> Set Chart Info|
Then set the default location and time zone to the location and time
zone of the chart we are considering.
If you omit this step, the transits will be inaccurate.
|Astrolog32||Edit -> Set Default Location/Time Zone|
|16-bit Astrolog||Info -> Default Chart Info|
|64-bit Astrolog||Info -> Default Chart Info|
Then select only the natal points that we want to receive the transits.
|Astrolog32||Settings -> Object Selections (tick the ones we want)|
|16-bit Astrolog||Setting -> Restrictions (un-tick the ones we want)|
|64-bit Astrolog||Setting -> Restrictions (un-tick the ones we want)|
Select the aspects that we want the transiting planets to make to the points
in the natal chart.
Note that if we want an aspect that doesn't appear here, then simply select any aspect and change the angle
for that aspect to the one we want. Remember that in the transit list when this transit aspect is listed,
the angle will be different than that associated with than angle name.
|Astrolog32||Settings -> Aspect Selections and Settings (tick the ones we want)|
|16-bit Astrolog||Setting -> Aspect Settings (un-tick the ones we want)|
|64-bit Astrolog||Setting -> Aspect Settings (un-tick the ones we want)|
If we are using the Moon's North Node in the natal chart, or as a transiting
"planet", then select
whether we want to use the mean node or the true node.
|Astrolog32||Settings -> Calculation Settings|
|16-bit Astrolog||Setting -> Obscure Settings|
|64-bit Astrolog||Setting -> Calculation Settings|
If we want the accuracy of the time of day that the transit occurred, then
make sure times are displayed in
24h time rather than am/pm. Excel will recognize the date and time as a "date" if it is in this format.
Also, make certain that the date is in the format that Excel recognizes as a date in your country - m/d/y, or d/m/y.
|Astrolog32||Settings -> Miscellaneous Settings|
|16-bit Astrolog||Setting -> Obscure Settings|
|64-bit Astrolog||Setting -> Display Settings|
Set the view is to text mode rather than graphics mode.
|Astrolog32||View -> Text Mode|
|16-bit Astrolog||View -> Show Graphics (a toggle switch)|
|64-bit Astrolog||View -> Show Graphics (a toggle switch)|
Ensure that the colours are turned off. If we save a chart as a colored text file, the file will contain a lot
of unwanted characters.
|Astrolog32||View -> Colored Text (a toggle switch)|
|16-bit Astrolog||View -> Colored Text (a toggle switch)|
|64-bit Astrolog||View -> Colored Text (a toggle switch)|
Now we are ready to calculate the actual transits. Press Enter to bring
up the command line. We can calculate
the transits for a single month, or for several years. If we wish to calculate the transits for a single month,
we enter tm m yyyy. The m is the number of the month, and the yyyy is the year. If we wanted to know the transits
for April 2001, we would enter tm 4 2001.
If we want to calculate the transits for several years, we would enter
tY yyyy n. The yyyy provides the starting year,
and the n states the number of years we want to calculate. If we wanted to know the transits for 2001 through 2003,
we would enter tY 2001 3.
If we want to save this transit list, or manipulate it in Excel, then we need to save the list as a text file.
|Astrolog32||File -> Save Chart as Text File|
|16-bit Astrolog||File -> Save Chart Text Output|
|64-bit Astrolog||File -> Save Chart Text Output|
Astrolog will save the list and then re-display the list on the screen. This
may take quite a while, so be patient.
When Astrolog has finished this process, you should turn off the transits by using the same command
(simply tm or tY will also work) before you try to do anything else. Otherwise, Astrolog will calculate the entire
transit list again. This can be annoying if you want to make more than one change to the settings.
If we want to log aspects made by a transiting hypothetical planet such as Transpluto, we will need to use a version of Astrolog that allows the use of the Matrix routines. This means Astrolog 5.4x or Astrolog 32 1.0. When Astrolog is using the Matrix routines, the positions are not as accurate as they could be. This is especially true for the asteroids. If we only have a few active natal points, then we can comfortably solve this problem. Use the ephemeris files to get accurate locations of the points you are interested in, to the nearest arc-second. Then, turn off the ephemeris files, and restrict all but one planet in the natal chart, say the Sun. Then adjust the date and time until the Sun is exactly where one of the natal planets were. Now do the transit list using only the transiting hypothetical planet/s. This procedure can be repeated for each of the natal points of interest. Just remember to change "Sun" to the name of the real natal planet/point later on (and also change the name of the planet in Astrolog substituting for the hypothetical planet). This can be easily done in Excel.
We may want to manipulate and/or sort this data in Excel. After you have opened Excel, open the text file with the fixed width option in the text import wizard. Click next, go down past the natal chart locations, then select where we want the column boundaries to be. Remember that Excel will not recognise dates before 1900. If we want to sort these dates, the best format would be yyyymmdd. If we want yyyymmdd as our final date format, we need the month, day, and year in separate columns with no "/" between them. You should also place the time in a separate column. If all our dates are on or after 1/1/1900, we have no problems; the date and time can be in one column. Click finish. We can delete any unwanted rows or columns.
If we have dates before 1900 and want the date in the format yyyymmdd, then in another column we can sum yyyy*10000 + mm*100 + dd to get the date in the right format. Remember to copy this column and paste special -> values in another column before deleting the 3 columns with the years, months and days, or before using these dates for sorting purposes. If any planet names or aspect names need changing, then this can easily be done using the Edit -> Replace feature.
Now we can manipulate and sort the data as we wish. Data can be sorted by date, transiting planet, natal planet, aspect, or sign of the natal or transiting planet. If we want to sort by sign, then we must remove the brackets around the sign if we still want them to be sorted by date as well. Excel will distinguish between the round brackets used for direct planets and the square brackets used for retrograde planets. Simply use Edit -> Replace to do this.