How to create an ephemeris

[Hermanus]

I am aware of tons of special astro software which offer this as part of their standard features.

I still would like to have one written in excel (gives me the chance to manipulate it my ways).

Any chance someone can help me?

Thanks

 

[Tana Lee]

Aloha...

In the event that no one else has a clue:

Ephemeris (plural: ephemerides) - Pronounced ee-FEM-er-is (ef-fi-MARE-uh-deez). A table listing specific data of a moving object, as a function of time. Ephemerides usually contain right ascension ("R.A." in these web pages) and declination ("Decl." in these web pages), apparent angle of elongation ("Elong." in these web pages) from the sun (in degrees), and magnitude (brightness) of the object; other quantities frequently included in ephemerides include the objects distances from the sun and earth (in AU), usually given as Roman letter "r" and Greek letter "Delta", respectively; phase angle; and moon phase.

Right.

Can you give us a hint what data is needed and what the formula(s) would be?

Tana-Lee

 

[Tana Lee]

Aloha Part II...

How about this?

http://www.jyotish.net/10-year.htm

This emphemeris was calculated for 12:00 noon at Boulder, Colorado, using Lahiri ayanamsha. It was created using Goravani Jyotish 2.2.2 Vedic Astrology software, which compensates for daylight savings time, etc. So it is very accurate. It does include the outer planets. I removed Ketu from the list, since it is always figured as the exact opposite of Rahu.

What you are downloading is a zip archive of a microsoft excel file. That way, once you unpack it, you can load it into excel and print it, reformat it, re-configure it, etc. The file itself is also Mac-compatible, although I don't think the zip format is. Unsure on this.

Depending on your connection, etc., you can download this in about 4 minutes.

ten year ephemeris.ZIP

Other possibilities:

http://www.google.com/search?q=excel+ephemeris+&hl=en&lr=&ie=UTF-8&oe=UTF-8

Tana-Lee

 

[Hermanus]

Thanks for the reply.

My problem is not the spreadsheet but the creation of the 360 chart off this
data (The Wheel).

Sorry, the correct question should have been:
How to create a graphical ephemeris (360 degree wheel).

e.g. (not the best match of my idea)
http://www.treehousemountain.com/studychart5.htm


or better the overlay visible here

http://community.webtv.net/pnreda/cgw


THX

 

[santeria]

I am intrigued as to why you would want an Emphemeris done in an Excel format.

This Site:
http://www.stargazing.net/kepler/astrofnc.html

Claims to have some Demo VBA.

You even have the Swiss Open Source Code version

http://www.astro.com/swisseph/sweph_g.htm

And even some messy coding in :

http://www.moneytide.com/hans/product/ephi.html

I guess the main thing is, all the Ephemeris Software I have seen work off a relational database, which does not go too well on a strictly Excel format.
So, Are you using a Backend Database to drive this Graph?

 

[Hermanus]

Thanks again for the reply.

The main reason why I want this in Excel is to have enough flexibility to add features at a later time like a 3-dimensional view etc.


I like the last link - looked familiar to me but somehow I did miss all the different features there.

Wondering what this all means:

Market AstroPhysics Master Course.
Top Secret. The Ultimate. Covers everything that Hans has learned, including his Complete Chaos Method. One week living with Hans. All past purchases credited to course price. By acceptance only. The Full Circle. Requires Non-disclosure.
Requires Non-disclosure. Click to see.


.........................................................MAP...$36000

Must be something special LOL

 

[tusharm]

What the heck are you smoking? {vbg} XL is awful at 3D anything!

Thanks again for the reply.

The main reason why I want this in Excel is to have enough flexibility to add features at a later time like a 3-dimensional view etc.

{snip}

 

[luckycharm]

I loved this one.
Thread of the year!

 

[Hermanus]

Response to last post


ALREADY and I have just asked a simple question.....


previous post: very offensive - don't like your style, dude


cheers

 

[iprosper]

Was there a solution found to this as I'd be interested, but I'd prefer to have it in an Access database which I could easily integrate with Excel