Excel and Astrology – Who Knew?

January 27th, 2011

Hi, everyone.

Today I spent the afternoon adding data to my astro-research database.  As I read magazines and newspapers, other bloggers, and listen to the radio I continually see or hear phrases that are great descriptions of various astrological configurations.  I keep a stack of these pages and notes and when I have time, I fill in my database.  I’ve gathered hundreds of these bits of data.  When it’s time to write or speak to someone about a particular configuration, I sort through these snippets.  I find it gives me a “real life” take on various parts of astrology, more telling   than formal study gives me.

Pacioli, the creator of double-entry bookkeeping. Doesn't it look like he's studying an astrology chart? (Source:Wikipedia)

For years I searched and searched for the right tool to capture this info and all along it was right under my nose.  As an accountant I’ve used Excel spreadsheets in my work forever.  I’m very comfortable with Excel but by no means am I a super-user – just competent.

Really it was a fortuitous disaster that got me into using Excel for astrology in the first place.  I was using an automated card index system called NDx but then all of a sudden I couldn’t access my hundreds of notecards anymore.  The company had apparently gone out of business.  I called, I wrote, I called again and wrote again, all the while panicking about the year of wasted work.  But then my genius son cracked the code and was able to download my data into an Excel sheet.  When I opened the spreadsheet to see what he’d been able to retrieve I was shocked.  There was all my research, spread out into the columns and rows I know so well!

I show an example of the spreadsheet below.  I’ve only shown two columns but each entry has many, including the source of the quote, the author’s name, the publication, the category of information, and many more.  This way if I want to use a quotation in the future, I’ve got the bibliography right there.  And with Excel’s ease of copying and pasting and other tools it doesn’t take long to enter many items in one short session.  It’s such a great system.

The sample below is based on an article in the New York Times Magazine about Lynn Redgrave, who died last year.  When I come across a descriptive article that interests me, the first thing I do is see if I can find out the person’s birthchart.  There’s a wonderful resource on the web called Astrodatabank.  They have, I believe, over 35,000 charts of the famous and semi-famous.  That’s always my first stop.  They also tell you how accurate they believe the information to be, whether they had a birth certificate in hand, or what other source of information they used.

If I have no luck there, I go to Wikipedia.  In most cases, if there’s an article on the person the birthday is listed and often the place of birth.  Even without the time of birth, there is a lot you can see about a person from the planetary placements and aspects alone.

In today’s case I was lucky.  Astrodatabank had Lynn Redgrave’s chart, with an A rating.  Reading through the article with her birthchart in front of me  I filled in my database as you see below.  As you read through it, see how it gives words to the various configurations in her chart.  Then next time I see a chart with Sun in the 12th house, for example, I can cull through all of my entries on that placement of the Sun for language that really describes the situation, in the words of someone who has lived it.

Here’s a sample of my spreadsheet:

******************************************************
Check out my other blog for all things business, including weekly and monthly forecasts.
Astro4Business Intersections

Copyright 2011. All rights reserved.

15 Responses to “Excel and Astrology – Who Knew?”

  1. astrologer says:

    What you posted made a lot of sense. But,
    think on this, what if you were to write a awesome headline?

    I ain’t suggesting your information isn’t good., but suppose you
    added something to maybe grab people’s attention? I mean Excel
    and Astrology – Who Knew? « Ellen Longo's Astrology Blog is a little plain.
    You ought to peek at Yahoo’s home page and
    see how they write post titles to get viewers interested.
    You might try adding a video or a related picture or two to
    get readers interested about what you’ve written. Just my opinion, it
    could bring your website a little livelier.

  2. There is a way to do the calculation with ms excel sheet. If you like to know more just mail

  3. I have read some just right stuff here. Definitely worth bookmarking
    for revisiting. I wonder how much effort you set to make this
    kind of great informative site.

  4. Natalie says:

    Hi Ellen. Thank you for the tip. It works wonderfully as tool to keep track of characters and plotpoints – I’ve spent a few hours organizing my material today, thanks to this! I’ve been looking for a method to replace the drawer full of post-it notes … Have a great weekend!

    • admin says:

      Natalie, your comment made me so happy. It was so satisfying to realize that someone else took up a tool I used and wrote about. Thank you so much for letting me know and for continuing to read and comment on my work.

  5. Couldn’t agree with you more. Excel is a very competent program. By the way lovely new theme for the blog. Looks elegant and refined.

    • admin says:

      Thank you so much for your comment on my new theme, Dennis. I really like it, too.

      Do you mind a technical question? Do you know how to take a “picture” of a chart in Excel and post it to a blog? All I could figure out was to print it, scan it, and then import it to the blog but I don’t think it turned out very well. Do you have any better idea? Thanks. Ellen

      • If you are on a mac, there is a nifty tool/software call GRAB. It takes snapshot of your screen and you can specify which parts. On a PC, the same function can be executed, by a software called SNIPPET.

        • admin says:

          Thank you, Dennis! I’m on PC. I’ll check it out.

          • Carin says:

            I can’t thank you enough. I’m not a big Excel fan but this will patch up what I need to prneest until I get through some MATLAB code or R. Thanks a ton.

          • Martin says:

            Здравствуйте Олег!В Вашем случае надо правильно отредактировать файл palo.ini и перегрузить palo-сервер (можно перегрузить компьютер).Пример правильного файла:splash-limit 1000 500 100goalseek-limit 1000goalseek-timeout 10000user-loginverboseinfotemplate-directory ../Apilog C:\Program Files\Jedox\Palo\Log\PaloServer.log http 192.168.2.64 7777template-directory C:\Program Files\Jedox\Palo\Api В данном случае указан порт 7777. К нему и connect.

      • Mihai says:

        actually there are more options there:
        easycapture, fscapture, mwsnap, printscreen pro, screenshot captor, snagit.
        My favorite is snagit, then fscapture. But all are usable.
        I don’t know now which ones are freeware, but you can check them out.

        • Tshweu says:

          My uncle send me a letter where he asked about excel preblom. I advised him a tool, which I was found some days ago. To my great surprise, he thanked me a lot and besides I believe that this tool would be useful for any situation with excel files – .

        • Jaffar says:

          Есть еще вариант при установке palo-suite: отредактировать файл palo.ini (находится в каталоге palo suite\palo\data )Пример правильного файла:user-loginlog ..\..\log\olap_severr.loghttp 127.0.0.1 7921http 192.168.2.64 7922verbose infosplash-limit 1000 500 100goalseek-limit 1000goalseek-timeout 10000cache-barrier 100000clear-cache-cells 10000В нем говорится о том, что для локального соединения (local host или 127.0.0.1) используется порт 7921, а для внешнего соединения (адрес в сети: 192.168.2.64) использовать другой порт 7922.Предыдущий вариант был описан под установку palo severr + client (то, что Вы устанавливали на другом компьютере и где сказали не устанавливать сервер )

        • Adriana says:

          splash-limit 1000 500 100goalseek-limit 1000goalseek-timeout 10000user-loginverbose infotemplate-directory ../Apilog abC:\Program Files(x86)\Jedox\Palo\Log\PaloServer.logbbhttp ab192.168.0.60 7777template-directory abC:\Program Files(x86)\Jedox\Palo\ApibbВот то что сейчас

RSS feed for comments on this post. And trackBack URL.

Leave a Reply