Page 1 of 1

Meridian Longitude spreqdsheet

Posted: Tue Apr 25, 2023 7:35 am
by Jim Eshelman
Prime Vertical Parans are calculated differently depending on the specific aspect. In all cases, the goal is to identify aspects between one planet on the prime vertical when another planet is on the PV, horizon, or meridian.

The easy part: Prime vertical conjunctions and oppositions are simply measured in azimuth. PV-to-meridian squares are also measured in azimuth:

The hard part: PV-to-horizon squares need a different measurement, which I call Meridian Longitude. At the moment, no software calculates this. You can use the following spreadsheet in combination with Solar Fire to do this:
https://1drv.ms/x/s!Ansnmu2xbktanrcehnA ... g?e=BR8Cd2

1. Calculate the chart in Solar Fire.
2. Right-click on the chart and pick Export Charts as Text. Select only Azimuth and Altitude on the right, then click Export.
3. On the Natal Data tab of the Meridian Longitude spreadsheet, on the BOTTOM RIGHT section place your mouse on the "Moon" cell and paste (it pastes your export).
4. Copy the Moon through Pluto lines of this lower righthand table. Place your mouse in the "Moon" cell of the similar table right above it and paste. [This awkward "paste, copy again, and paste again" is necessary because of quirks in Excel.]
5. Look on the PVP Calc tab to get your answers.

Re: Meridian Longitude spreqdsheet

Posted: Tue Apr 25, 2023 7:47 am
by SteveS
Thanks Jim, I will see if I can work this procedure with the May 23 Canlunar.

Re: Meridian Longitude spreqdsheet

Posted: Tue Apr 25, 2023 7:54 am
by Jim Eshelman
SteveS wrote: Tue Apr 25, 2023 7:47 am Thanks Jim, I will see if I can work this procedure with the May 23 Canlunar.
You're welcome; and I just gave you (in the other thread) the example of the Saturn-Pluto aspect in the Arisolar.

My suggested way of using this is:

1. Only look at planet within 3° of azimuth 90° or 270°. (If there isn't one, you don't have an aspect to track down.)
2. PVP conjunction and oppositions are conjunctions or oppositions OF THESE IDENTIFIED PLANETS in azimuth.
3. PVP squares meridian-to-PV are also measured in azimuth.
4, PVP squares horizon-to-PV are measured in Meridian Longitude (ML).

The key is to only consider these when you have at least one planet within 3° of 90° or 270° azimuth. (We may need to tweak this in the future.)

Re: Meridian Longitude spreqdsheet

Posted: Wed Apr 26, 2023 12:04 am
by SteveS
Got it Jim, I was able to reproduce your May Canlunar ML #s with your spreadsheet procedure. And, I understand the way you are using these PVP aspects.
Jim wrote:
The key is to only consider these when you have at least one planet within 3° of 90° or 270° azimuth. (We may need to tweak this in the future.)
Understood Jim, thanks again for this SF tip. :)