Mundoscope & Precession spreadsheets

Because so many of us use Solar Fire, this space will collate the various tips & custom templates. (Some free downloads are scattered around the forum in other locations where they make more sense.)
Post Reply
User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Wed Jul 12, 2017 8:06 pm

I wanted to create a spreadsheet that would allow for the calculation of one chart's mundoscope positions within the framework (RAMC, latitude, i.e., "house structure") of another chart, precessed so that they were in the same Sidereal framework. Derek Kinsolving had already created it, and he offered it for our use, and wrote extensively on how to use it. I have made a separate version - really just a simplification - that some people may prefer; or you may want the more flexible one Derek first designed.

The prior thread (a bit rambling in places) discusses the use of these spreadsheets. Perhaps we will one day write something more straightforward, but, for now, the original thread will do.
http://solunars.com/viewtopic.php?f=8&t=1539&start=25

Here is Derek's original, as an ODS file.
https://1drv.ms/x/s!Ansnmu2xbktakeVEHCFa1ho4ClIzEQ

Here is the same file opened and resaved in Excel 2016.
https://1drv.ms/x/s!Ansnmu2xbktakeVC8coeTGRpjAVHug

Here is my simplified version, an Excel file.
https://1drv.ms/x/s!Ansnmu2xbktakeVDDsl0f-h0bTO15w

Download those you want and enjoy!
Jim Eshelman
www.jeshelman.com

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Re: Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Wed Jul 12, 2017 8:07 pm

Could someone please test these to confirm that I shared them correctly? Thanks!
Jim Eshelman
www.jeshelman.com

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Use

Post by Jim Eshelman » Wed Jul 12, 2017 8:20 pm

I will explain briefly the use of my simplified adaptation (the final link above).

Make a copy of the spreadsheet. We recommend naming if after the person whose chart it contains. (You can reuse it forever.)

NOTE: I plan an updated version that will let you simply type each longitude in sign, degree, minute, etc., requiring no other software. For now, the easiest way is to import the values from Solar Fire.

On the NATAL tab, see the heading, "STEP 1: IMPORT HERE." This is where you will do the first step.

In Solar Fire, in the Calculated Charts box, right click on the natal (or other) chart in question, pick "Export Chart as Text." Select "Chart Points" in the first box, Longitude and Latitude (only!) in the second box, "Export to Clipboard" at the bottom, and a File Delimiter of "Tabs." Click Export, then OK.

In the spreadsheet, place the mouse on the blank space under "STEP 1" (i.e., in cell J7) and paste. (Ctrl+V is one easy way.) HINT: You might want to do the paste lower on the spreadsheet, in empty space, and then copy and paste exactly the planets and long/lat columns where they belong in cells J8 through M17.

In the spreadsheet, click over to the MAIN tab. Fill in the four blanks at the top. (You can get this information off the Reports page in Solar Fire.) The first value is the LST (Local Sidereal Time, aka RAMC of the chart); next, obliquity of the ecliptic (Ob.); next, the SVP; and finally the geographic latitude of the horoscope.

At this point, you are done: You've calculated the mundoscope of the birth chart.

To get a relocated mundoscope, just change the LST and geographic latitude fields at the top to match those of the locality chart.

To see the mundoscope positions of the natal planets within the angle structure of another chart such as a solar or lunar return, just edit the four values at the top of the MAIN page. These should match the LST, obliquity, SVP, and latitude of the return chart.

Notice that ,if you create this for yourself (for example) and you stay in the same location, you can fill these four in once, then usually just change the LST for a new return chart and (every 6-12 months) update the SVP. The geographic latitude will stay the same, and the obliquity will move so slowly you don't have to worry. The SVP will change less than 0°01' per year.
Jim Eshelman
www.jeshelman.com

User avatar
Jupiter Sets at Dawn
Synetic Member
Synetic Member
Posts: 1579
Joined: Sun May 07, 2017 7:03 pm

Re: Mundoscope & Precession spreadsheets

Post by Jupiter Sets at Dawn » Wed Jul 12, 2017 10:08 pm

Jim Eshelman wrote:
Wed Jul 12, 2017 8:07 pm
Could someone please test these to confirm that I shared them correctly? Thanks!
All three open in Excel Online, ready to be edited in my browser.

That is not what you want.

Anybody tries using these, go to the three dots on the far right, click that for a drop down menu that will let you download them. That's what you want.

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Re: Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Wed Jul 12, 2017 10:35 pm

Jim Eshelman wrote:
Wed Jul 12, 2017 8:07 pm
Could someone please test these to confirm that I shared them correctly? Thanks!
All three open in Excel Online, ready to be edited in my browser.

That is not what you want. [/quote]
Well, it could be worse :) But I should make sure it is set to disallow editing. (There is a download menu option, but one has to know to download it.)
Anybody tries using these, go to the three dots on the far right, click that for a drop down menu that will let you download them. That's what you want.
Yup. Let me go tweak it.
Jim Eshelman
www.jeshelman.com

User avatar
Danica
Synetic Member
Synetic Member
Posts: 1985
Joined: Sun May 07, 2017 10:19 pm

Re: Mundoscope & Precession spreadsheets

Post by Danica » Sun Sep 10, 2017 5:21 pm

Jim, in your Excel (the simplified vers. from above), where do we read the result data?

For my natal planets in current SSR, I followed all the steps, but I don't see where does it show the positions you got :
Jim Eshelman wrote:
Wed Aug 09, 2017 10:16 am
Placing your natal planets in the SSR wheel, we get the following:

+4°04' from Asc Sun
+2°54' from Dsc Saturn
-3°52' from Asc Mars
-5°21' from Dsc Pluto
-9°20' from Asc Mercury
QUID VOLIS ILUD FAC

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Re: Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Sun Sep 10, 2017 5:26 pm

Danica wrote:
Sun Sep 10, 2017 5:21 pm
Jim, in your Excel (the simplified vers. from above), where do we read the result data?
First tab, columns C. D, & E.

If that doesn't make it clear, I'll walk through it more slowly. Basically, you need to have your natal planets copied into tab 3, cols. L & M. Then, on the first tab, fill in the SSR's four values (LST etc.) at the top. Then they appear magically on the same tab in cols. C-E.
Jim Eshelman
www.jeshelman.com

User avatar
Danica
Synetic Member
Synetic Member
Posts: 1985
Joined: Sun May 07, 2017 10:19 pm

Re: Mundoscope & Precession spreadsheets

Post by Danica » Sun Sep 10, 2017 10:32 pm

Jim Eshelman wrote:
Sun Sep 10, 2017 5:26 pm
Danica wrote:
Sun Sep 10, 2017 5:21 pm
Jim, in your Excel (the simplified vers. from above), where do we read the result data?
First tab, columns C. D, & E.
If that doesn't make it clear, I'll walk through it more slowly. Basically, you need to have your natal planets copied into tab 3, cols. L & M. Then, on the first tab, fill in the SSR's four values (LST etc.) at the top. Then they appear magically on the same tab in cols. C-E.
Yes, did that. First tab, columns C. D, & E this is what I get

CAMPANUS
PLANET HOUSE ° '
Mon 1 14 49
Sun 9 18 7
Mer 10 7 5
Ven 10 25 26
Mar 9 28 57
Jup 4 25 33
Sat 3 17 39
Ura 4 23 53
Nep 5 13 13
Plu 3 18 27
QUID VOLIS ILUD FAC

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Re: Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Sun Sep 10, 2017 10:51 pm

For Chino, current SSR April 22, 2017, 6:44:36 AM PDT, the four items for the top of the first page are:

LST 19:57:05
Obliquity 23°26'13"
SVP 5°01'15"
Latitude 34M00'44"

Your natal planets within this chart are given as follows (house, degree, minute), which looks right against the chart when visually checked.

Mon 5 21 60
Sun 12 23 56
Mer 1 4 4
Ven 1 20 46
Mar 1 0 22
Jup 7 22 8
Sat 6 25 34
Ura 7 20 3
Nep 8 14 46
Plu 7 5 54

I think I did make some kind of error, though. You quoted me as saying that Sun is 4°04' past Asc (which it is: 23°56' in the 12th house is 4°04' past Ascendant). However, I said Saturn is 2°54' past Descendant, and it looks like it's 4°26' past. You quoted me as saying Mars is 3°52' before Ascendant, and the above shows it is 0°22' before. Pluto should read 5°54' before Dsc, and Mercury 4°04'. Not sure where I screwed up, but I must have put a wrong number somewhere.
Jim Eshelman
www.jeshelman.com

User avatar
Danica
Synetic Member
Synetic Member
Posts: 1985
Joined: Sun May 07, 2017 10:19 pm

Re: Mundoscope & Precession spreadsheets

Post by Danica » Mon Sep 11, 2017 6:39 pm

:o I have SVP 06*39'21'' !!

SF v9.0.26

EDIT: went to review settings, and it shows SVP for Jan 1 1900 (06*39'21'' Pis) as a locked option, going by default with Fagan-Allen zodiac.
QUID VOLIS ILUD FAC

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Re: Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Mon Sep 11, 2017 6:58 pm

You need the SVP from the solar return, from it's Reports page.
Jim Eshelman
www.jeshelman.com

User avatar
Danica
Synetic Member
Synetic Member
Posts: 1985
Joined: Sun May 07, 2017 10:19 pm

Re: Mundoscope & Precession spreadsheets

Post by Danica » Mon Sep 11, 2017 7:44 pm

Jim Eshelman wrote:
Mon Sep 11, 2017 6:58 pm
You need the SVP from the solar return, from it's Reports page.
Yes, the SVP from the SSR chart is 06*39'21'' Pis

- as is in every other chart I have calculated!

Seems like some kind of bug in the program.
QUID VOLIS ILUD FAC

User avatar
Jim Eshelman
Irish
Irish
Posts: 3992
Joined: Sun May 07, 2017 12:40 pm

Re: Mundoscope & Precession spreadsheets

Post by Jim Eshelman » Mon Sep 11, 2017 8:09 pm

Danica wrote:
Mon Sep 11, 2017 7:44 pm
Jim Eshelman wrote:
Mon Sep 11, 2017 6:58 pm
You need the SVP from the solar return, from it's Reports page.
Yes, the SVP from the SSR chart is 06*39'21'' Pis

- as is in every other chart I have calculated!

Seems like some kind of bug in the program.
Aha! Aha! Aha! Let's use your natal as an example. The Reports page has the following at the top:

DeltaT = +53s. ET = 8:25:53 pm Apr 22 1983, JDE = 2445447.351312
ST(0°) = 10:26:10, LST = 11:55:27, Ob = 23°26'29"; Eq. Time = +1m28s
Ayanamsa of date = 5°Pi29'53", SVP 1900 = 6°P139'22"
ACD(0h) = Jun 16 1983; ACD(12h) = Dec 15 1983

The third line is the key one, and they have an error in their labelling (or at least something likely to cause confusion). "Ayanamsa" actually means the difference between the starting points of the Tropical and Sidereal zodiacs measured clockwise and, for your birth, this is 24°30'07". They've used this label for the SVP, which is 5°29'53" Pisces at your birth. The value labelled "SVP 1900" is the definition of the SVP, i.e., that at the astronomical start of 1900 (1900.0) its value was 6°39'22" Pisces, moving about 50"/year since then.

I'd looked past that mislabeling so long, I hadn't registered (at least in years) how confusing it was. Thanks for creating the need to explain it.
Jim Eshelman
www.jeshelman.com

User avatar
Danica
Synetic Member
Synetic Member
Posts: 1985
Joined: Sun May 07, 2017 10:19 pm

Re: Mundoscope & Precession spreadsheets

Post by Danica » Mon Sep 11, 2017 9:16 pm

aha!
:D well, this makes it clarified!

but I do get different values than yours above, this is what I get:

Mon 5 20 39
Sun 12 22 55
Mer 1 3 0
Ven 1 19 31
Mar 12 29 20
Jup 7 20 53
Sat 6 24 32
Ura 7 18 50
Nep 8 13 10
Plu 7 4 52

it's 1* - 1* 30' off
QUID VOLIS ILUD FAC

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest