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)
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.
끝없는 스릴과 승리를 경험하세요: 우리 사이트에서 슬롯의 세계를 탐험하세요,"이 기사는 슬롯 게임의
기본 플레이 방법과 사용 가능한 다양한 게임을 포함하여 슬롯 게임의 세계에 대한 소개를 제공합니다.
또한 자금의 중요성에 대해서도
설명합니다. 관리 및 책임감 있는 게임, 슬롯 게임에서 승리하기
위한 팁. 이 기사는 슬롯 게임 플레이의 이점을 강조하고 발생할 수 있는 모든 문제 또는 질문에 대한 고객 지원을 제공하는 것으로 결론을 내립니다."
Thanks. I’ve got more information than what I want.
It is great. I love seeing stuff like this on the internet.
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.
There is a way to do the calculation with ms excel sheet. If you like to know more just mail
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.
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!
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.
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.
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.
Thank you, Dennis! I’m on PC. I’ll check it out.
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.
Здравствуйте Олег!В Вашем случае надо правильно отредактировать файл 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.
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.
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 – .
Есть еще вариант при установке 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 (то, что Вы устанавливали на другом компьютере и где сказали не устанавливать сервер )
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Вот то что сейчас