Meridian Longitude spreqdsheet

Because so many of us use Solar Fire, this space collates tips & custom templates.
Post Reply
User avatar
Jim Eshelman
Are You Sirius?
Posts: 19068
Joined: Sun May 07, 2017 12:40 pm

Meridian Longitude spreqdsheet

Post 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.
Jim Eshelman
www.jeshelman.com
SteveS
Nabu
Posts: 6469
Joined: Mon May 08, 2017 5:11 am

Re: Meridian Longitude spreqdsheet

Post by SteveS »

Thanks Jim, I will see if I can work this procedure with the May 23 Canlunar.
User avatar
Jim Eshelman
Are You Sirius?
Posts: 19068
Joined: Sun May 07, 2017 12:40 pm

Re: Meridian Longitude spreqdsheet

Post 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.)
Jim Eshelman
www.jeshelman.com
SteveS
Nabu
Posts: 6469
Joined: Mon May 08, 2017 5:11 am

Re: Meridian Longitude spreqdsheet

Post 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. :)
Post Reply