Mundoscope & Precession spreadsheets

[Jim Eshelman]

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]

Could someone please test these to confirm that I shared them correctly? Thanks!

[Jim Eshelman]

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.

[Jupiter Sets at Dawn]

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.

[Jim Eshelman]

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.

[Danica]

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 :

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

[Jim Eshelman]

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.

[Danica]

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

[Jim Eshelman]

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.

[Danica]

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.

[Jim Eshelman]

You need the SVP from the solar return, from it's Reports page.

[Danica]

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.

[Jim Eshelman]

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.

[Danica]

aha!
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

[Mike]

Hi all,

Could someone help me figure out what the names of some of the quantities in the Calcs tab of the simplified spreadsheet are?
I'm trying to update the astrology software I wrote with clearer variable names for these calculations, but I don't actually know what the mathematical quantities are called.

I'm interested in columns E, I, J, K, L, O, and P (just the planetary calculations, not the LST-related calculations at the top of the sheet)

Thank you

[DDonovanKinsolving]

I'm interested in columns E, I, J, K, L, O, and P (just the planetary calculations, not the LST-related calculations at the top of the sheet)

Just to make sure, do you mean those columns in the CALCS tab?

-Derek

[Jim Eshelman]

I'm interested in columns E, I, J, K, L, O, and P (just the planetary calculations, not the LST-related calculations at the top of the sheet)

If you do mean the Calcs tab, Derek can speak better to this... since he actually did the coding and just smudged it around a bit... but here's what I can discern.

E: is headed with a d and evidently is declination

I, J, K: These are calculated values x & y and their difference - I think they're just interim values (trig values of something that is used in later steps.

L: Looks like Hour Angle in degrees and radians (RA of the planet subtracted from RAMC)

O & P: I think N & O are, again, just interim calculations. P is the final value, the Prime Vertical longitude with its output display adjusted before it gets to the Main tab.

[Mike]

Hi guys! I do indeed mean the Calcs tab. Thank you for your response, Jim

[DDonovanKinsolving]

Mike, Mr. E is correct.

[Mike]

Hi all,

I spent some time messing around with my downloaded copy of Jim's simplified spreadsheet (not the calcs, just the formatting).

In great respect to Derek and Jim for actually creating and formatting the original spreadsheet (which has been an invaluable tool for me), I want to share my tweaks in the hopes of encouraging even more people to use it.

https://drive.google.com/file/d/1U9Y8l4 ... sp=sharing

What I updated:

• The Natal tab is simplified, with lots of instructions added to help Solar Fire users get the right data.

• The Main tab has a new box with coding added to show what angle a planet is conjunct in PVL, as well as whether or not it is square MC.

• Values will populate if a planet is within 10* of an angle in PVL, or within 4* of a square to MC in RA (4* chosen just so near-hits like 3*01' will still show)

• Degrees and minutes (truncated) for orbs for planets that are so foreground.

While I did not change any of the original calculations (obviously), it is possible that I missed some edge cases with my new coding, so if you see any weird stuff being displayed on the Main page (I dunno, something like a planet conjunct the Ascendant -359* or something silly like that), please let me know. All should be in order, however.

The default data is my birth data, and my Dec 2017 Solar Return for Hackensack, NJ, which does have some natal planets foreground.

[Mike]

EDIT:
Version 3 here:

https://drive.google.com/file/d/10pzDt1 ... sp=sharing

Updated a formula typo; Moon calculations were using un-precessed longitude, because apparently "C" looks like "G" to me. They are now correct.