Mundoscope & Precession spreadsheets
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Mundoscope & Precession spreadsheets
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!
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
www.jeshelman.com
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
Could someone please test these to confirm that I shared them correctly? Thanks!
Jim Eshelman
www.jeshelman.com
www.jeshelman.com
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Use
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.
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
www.jeshelman.com
- Jupiter Sets at Dawn
- Irish
- Posts: 2486
- Joined: Sun May 07, 2017 7:03 pm
Re: Mundoscope & Precession spreadsheets
All three open in Excel Online, ready to be edited in my browser.Jim Eshelman wrote: ↑Wed Jul 12, 2017 8:07 pmCould someone please test these to confirm that I shared them correctly? Thanks!
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
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
All three open in Excel Online, ready to be edited in my browser.Jim Eshelman wrote: ↑Wed Jul 12, 2017 8:07 pmCould someone please test these to confirm that I shared them correctly? Thanks!
That is not what you want. [/quote]
Well, it could be worse

Yup. Let me go tweak 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.
Jim Eshelman
www.jeshelman.com
www.jeshelman.com
Re: Mundoscope & Precession spreadsheets
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 :
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 amPlacing 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
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
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
www.jeshelman.com
Re: Mundoscope & Precession spreadsheets
Yes, did that. First tab, columns C. D, & E this is what I getJim Eshelman wrote: ↑Sun Sep 10, 2017 5:26 pmFirst 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.
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
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
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.
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
www.jeshelman.com
Re: Mundoscope & Precession spreadsheets

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
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
You need the SVP from the solar return, from it's Reports page.
Jim Eshelman
www.jeshelman.com
www.jeshelman.com
Re: Mundoscope & Precession spreadsheets
Yes, the SVP from the SSR chart is 06*39'21'' PisJim Eshelman wrote: ↑Mon Sep 11, 2017 6:58 pmYou need the SVP from the solar return, from it's Reports page.
- as is in every other chart I have calculated!
Seems like some kind of bug in the program.
QUID VOLIS ILUD FAC
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
Aha! Aha! Aha! Let's use your natal as an example. The Reports page has the following at the top:Danica wrote: ↑Mon Sep 11, 2017 7:44 pmYes, the SVP from the SSR chart is 06*39'21'' PisJim Eshelman wrote: ↑Mon Sep 11, 2017 6:58 pmYou need the SVP from the solar return, from it's Reports page.
- as is in every other chart I have calculated!
Seems like some kind of bug in the program.
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
www.jeshelman.com
Re: Mundoscope & Precession spreadsheets
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

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
Re: Mundoscope & Precession spreadsheets
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
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

-
- Constellation Member
- Posts: 137
- Joined: Mon May 29, 2017 3:04 am
- Jim Eshelman
- Nabu
- Posts: 7760
- Joined: Sun May 07, 2017 12:40 pm
- Gender:
Re: Mundoscope & Precession spreadsheets
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.
Jim Eshelman
www.jeshelman.com
www.jeshelman.com
Re: Mundoscope & Precession spreadsheets
Hi guys! I do indeed mean the Calcs tab. Thank you for your response, Jim 

-
- Constellation Member
- Posts: 137
- Joined: Mon May 29, 2017 3:04 am
Re: Mundoscope & Precession spreadsheets
Mike, Mr. E is correct.
Re: Mundoscope & Precession spreadsheets
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 default data is my birth data, and my Dec 2017 Solar Return for Hackensack, NJ, which does have some natal planets foreground.
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.
The default data is my birth data, and my Dec 2017 Solar Return for Hackensack, NJ, which does have some natal planets foreground.
Re: Mundoscope & Precession spreadsheets
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.
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.
Who is online
Users browsing this forum: No registered users and 1 guest