Jyotish Calculator in Excel

December 7, 2003

|| Jaya Jagannath ||

Dear Jyotisha,

I forgot to mention one

thing.

The excel file has VBA

coding and only can be opened if the security settings of MS Excel is set at

least to Medium. If some machine the excel file is not working, try the

following settings. Go to Tools-> Options-> Security Tab->Macro

Security.

I received some mails

that the the excel file could not be opened, hence I am uploading it into the

files section of Vedic-Astrology and SriJagannath list. It has already been

uploaded to varahamihira group.

Best Wishes

Sarajit

-----Original

Message-----

Sarajit Poddar

[sarajit (AT) (DOT) org]

10.0pt;font-family:Tahoma;mso-ansi-language:EN-US">Sunday, December 07, 2003

EN-US"> 1:09 PM

EN-US">

varahamihira;

vedic astrology;

[vedic astrology] Jyotish

Calculator in Excel

|| Jaya Jagannath ||

Dear Jyotisha,

I am attaching an excel

file for calculation of planetary positions and the divisional charts. This is

a advance calculator, which can make composite divisional charts. The function

for finding the composite division is “divplanetlongitude()”. The

parameters to be supplied for this function is Degree of a planet in the Rasi

Chart, the division chart no. and the variation in the divisional chart.

The Divisional chart no.

and their variations are listed below:

N(1, 1) =

"Rasi"

N(2, 1) =

"Hora (1/7 House)"

N(2, 2) =

"Parashara Hora"

N(2, 3) =

"Parivrittidvaya Hora"

N(2, 4) =

"Jagannath Hora"

N(2, 5) =

"Kashinath Hora"

N(3, 1) =

"Parashara Drekkana"

N(3, 2) =

"Jagannath Drekkana"

N(3, 3) =

"Parivrittitraya

Drekkana"

N(3, 4) =

"Somnath Drekkana"

N(4, 1) =

"Parashara Chaturthamsa"

N(4, 2) =

"Cyclical Chaturthamsa"

N(5, 1) =

"Cyclical Panchamsa"

N(6, 1) =

"Shasthamsa"

N(7, 1) =

"Saptamsa"

N(8, 1) =

"Ashtamsa"

N(9, 1) =

"Navamsa"

DE">N(10, 1) = "Dasamsa"

DE">N(11, 1) = "Rudramsa"

DE">N(12, 1) = "Dwadasamsa"

DE">N(16, 1) = "Shodasamsa"

DE">N(20, 1) = "Vimsamsa"

DE">N(24, 1) = "Siddhamsa"

DE">N(27, 1) = "Nakshatramsa"

DE">N(30, 1) = "Standard Trimsamsa"

DE">N(30, 2) = "Parivritti Trimsa Trimsamsa"

DE">N(30, 3) = "Trimsamsa (Like Shastyamsa)"

DE">N(40, 1) = "Khavedamsa"

N(45, 1) =

"Akshavedamsa"

N(60, 1) =

"Shastyamsa"

There

are 4 sheets. The details of the 4 sheets are

provided below:

tab-stops:list 1.0in">

Arial">1.

font-family:Arial">Sheet1: “Basic”- Here one needs to put the date

of birth, time of birth, the longitude and latitude. The longitude and latitude

need to be converted in decimals. For converting this divide the mintutes by 60

and seconds by 3600 and add it to the degrees. The system shall calculate the

Planetary longitudes for the planets and some upagrahas (Other bodies are in

the process of being programmed).

tab-stops:list 1.0in">

Arial">2.

font-family:Arial">Sheet2: “Division”- Here one can create any

composite divisional chart. Lets take Navamsa Dwadasamsa. For creating this you

need to put the Parameters for Navamsa, namely (9,1) in to the cells B2 and C2

and Dwadasamsa in the cells D2 and E2. Somebody well versed in Excel can create

composite charts to any level such as Navamsa-Navamsa-Dwadasamsa.

tab-stops:list 1.0in">

Arial">3.

font-family:Arial">Sheet3: “Two Big Charts”: While analysing any

native’s horoscope we generally analyse a particular divisional chart in

conjunction with the Rasi Chart. This sheet shows Big view of two divisional

charts. By default, I have put Rasi and Navamsa Chart. You can chose your own

divisional chatrs, you need to just put the parameters on the cells marked

yellow on the top of the divisional charts. The Kashinath Hora chart is

programmed. Use the parameters 2, 5 for Division and Var respectively to get

the chart.

tab-stops:list 1.0in">

Arial">4.

font-family:Arial">Sheet4: “All Divisional Charts”: This displays

all the divisional charts which has been programmed so far. You can see most of

the variations of different divisional charts. Please let me know if you want

something else to be included.

Other

consideration:

tab-stops:list 1.0in">

Arial">1.

font-family:Arial">To make the excelsheet working, please place the .dll file

included in the zip file I am sending, in the /windows/systems directory

tab-stops:list 1.0in">

Arial">2.

font-family:Arial">You can use the degrees of the planets in the divisional

charts, judiciously. Even though no shastras have spoken anything on this so

far. I “personally” think that they can be used in various ways

such as finding the exact planetary conjunctions, aspects etc. This is open to

research. Look in Sheet “Division” for the degrees of planets in

the divisional charts.

tab-stops:list 1.0in">

Arial">3.

font-family:Arial">You find the placement of any body in the zodiac in the

divisional charts. What you need to do is just put the longitude of the planet

in the the sheet “Division” in the column F.

tab-stops:list 1.0in">

Arial">4.

font-family:Arial">There are numerous functions available in the sheet, which

can be used in research, but yet to be documented. I will send an update

whenever I do that.

tab-stops:list 1.0in">

Arial">5.

font-family:Arial">This excel file is in public domain. Anyone can enhance it,

however, please let me know incase you are making any modifications or

enhancement.

tab-stops:list 1.0in">

Arial">6.

font-family:Arial">Currently the excel file doesnot show retrogression etc.

which shall be programmed and released later.

Please let me know your

feedback.

Best Wishes

Sarajit

line-break">

Archives:

vedic astrology

mso-ansi-language:EN-US">

To UNSUBSCRIBE: Blank mail to

vedic astrology-

|| Om Tat Sat

|| Sarvam Sri Krishnaarpanamastu ||

mso-ansi-language:EN-US">

December 7, 2003

Poddar Sahab,

I tried to download it, seems my lack of knowledge as

to how to unzip disallows me to open it. Could you

please help?

Regards

Inder Mohan

--- Sarajit Poddar <sarajit wrote:

> || Jaya Jagannath ||

> Dear Jyotisha,

>

> I am attaching an excel file for calculation of

> planetary positions and

> the divisional charts. This is a advance calculator,

> which can make

> composite divisional charts. The function for

> finding the composite

> division is "divplanetlongitude()". The parameters

> to be supplied for

> this function is Degree of a planet in the Rasi

> Chart, the division

> chart no. and the variation in the divisional chart.

>

> The Divisional chart no. and their variations are

> listed below:

>

> N(1, 1) = "Rasi"

> N(2, 1) = "Hora (1/7 House)"

> N(2, 2) = "Parashara Hora"

> N(2, 3) = "Parivrittidvaya Hora"

> N(2, 4) = "Jagannath Hora"

> N(2, 5) = "Kashinath Hora"

> N(3, 1) = "Parashara Drekkana"

> N(3, 2) = "Jagannath Drekkana"

> N(3, 3) = "Parivrittitraya Drekkana"

> N(3, 4) = "Somnath Drekkana"

> N(4, 1) = "Parashara Chaturthamsa"

> N(4, 2) = "Cyclical Chaturthamsa"

> N(5, 1) = "Cyclical Panchamsa"

> N(6, 1) = "Shasthamsa"

> N(7, 1) = "Saptamsa"

> N(8, 1) = "Ashtamsa"

> N(9, 1) = "Navamsa"

> N(10, 1) = "Dasamsa"

> N(11, 1) = "Rudramsa"

> N(12, 1) = "Dwadasamsa"

> N(16, 1) = "Shodasamsa"

> N(20, 1) = "Vimsamsa"

> N(24, 1) = "Siddhamsa"

> N(27, 1) = "Nakshatramsa"

> N(30, 1) = "Standard Trimsamsa"

> N(30, 2) = "Parivritti Trimsa Trimsamsa"

> N(30, 3) = "Trimsamsa (Like Shastyamsa)"

> N(40, 1) = "Khavedamsa"

> N(45, 1) = "Akshavedamsa"

> N(60, 1) = "Shastyamsa"

>

> There are 4 sheets. The details of the 4 sheets are

> provided below:

> 1. Sheet1: "Basic"- Here one needs to put the date

> of birth, time

> of birth, the longitude and latitude. The longitude

> and latitude need to

> be converted in decimals. For converting this divide

> the mintutes by 60

> and seconds by 3600 and add it to the degrees. The

> system shall

> calculate the Planetary longitudes for the planets

> and some upagrahas

> (Other bodies are in the process of being

> programmed).

> 2. Sheet2: "Division"- Here one can create any

> composite divisional

> chart. Lets take Navamsa Dwadasamsa. For creating

> this you need to put

> the Parameters for Navamsa, namely (9,1) in to the

> cells B2 and C2 and

> Dwadasamsa in the cells D2 and E2. Somebody well

> versed in Excel can

> create composite charts to any level such as

> Navamsa-Navamsa-Dwadasamsa.

> 3. Sheet3: "Two Big Charts": While analysing any

> native's horoscope

> we generally analyse a particular divisional chart

> in conjunction with

> the Rasi Chart. This sheet shows Big view of two

> divisional charts. By

> default, I have put Rasi and Navamsa Chart. You can

> chose your own

> divisional chatrs, you need to just put the

> parameters on the cells

> marked yellow on the top of the divisional charts.

> The Kashinath Hora

> chart is programmed. Use the parameters 2, 5 for

> Division and Var

> respectively to get the chart.

> 4. Sheet4: "All Divisional Charts": This displays

> all the

> divisional charts which has been programmed so far.

> You can see most of

> the variations of different divisional charts.

> Please let me know if you

> want something else to be included.

>

> Other consideration:

> 1. To make the excelsheet working, please place the

> .dll file

> included in the zip file I am sending, in the

> /windows/systems directory

> 2. You can use the degrees of the planets in the

> divisional charts,

> judiciously. Even though no shastras have spoken

> anything on this so

> far. I "personally" think that they can be used in

> various ways such as

> finding the exact planetary conjunctions, aspects

> etc. This is open to

> research. Look in Sheet "Division" for the degrees

> of planets in the

> divisional charts.

> 3. You find the placement of any body in the zodiac

> in the

> divisional charts. What you need to do is just put

> the longitude of the

> planet in the the sheet "Division" in the column F.

> 4. There are numerous functions available in the

> sheet, which can

> be used in research, but yet to be documented. I

> will send an update

> whenever I do that.

> 5. This excel file is in public domain. Anyone can

> enhance it,

> however, please let me know incase you are making

> any modifications or

> enhancement.

> 6. Currently the excel file doesnot show

> retrogression etc. which

> shall be programmed and released later.

>

> Please let me know your feedback.

>

> Best Wishes

> Sarajit

>

> ATTACHMENT part 2 application/x-zip-compressed

name=Jyotish Calc.zip

Protect your identity with Mail AddressGuard

http://antispam./whatsnewfree

December 7, 2003

Dear Inder Mohan,

You need Winzip to unzip the file. Do you have it installed in your PC.

If you still have problems, please let me know.

Regards

Sarajit

Kashmiripundit tryn2learn [kashmiripundit]

Sunday, December 07, 2003 5:19 PM

vedic astrology

Re: [vedic astrology] Jyotish Calculator in Excel

Poddar Sahab,

I tried to download it, seems my lack of knowledge as

to how to unzip disallows me to open it. Could you

please help?

Regards

Inder Mohan

--- Sarajit Poddar <sarajit wrote:

> || Jaya Jagannath ||

> Dear Jyotisha,

>

> I am attaching an excel file for calculation of

> planetary positions and

> the divisional charts. This is a advance calculator,

> which can make

> composite divisional charts. The function for

> finding the composite

> division is "divplanetlongitude()". The parameters

> to be supplied for

> this function is Degree of a planet in the Rasi

> Chart, the division

> chart no. and the variation in the divisional chart.

>

> The Divisional chart no. and their variations are

> listed below:

>

> N(1, 1) = "Rasi"

> N(2, 1) = "Hora (1/7 House)"

> N(2, 2) = "Parashara Hora"

> N(2, 3) = "Parivrittidvaya Hora"

> N(2, 4) = "Jagannath Hora"

> N(2, 5) = "Kashinath Hora"

> N(3, 1) = "Parashara Drekkana"

> N(3, 2) = "Jagannath Drekkana"

> N(3, 3) = "Parivrittitraya Drekkana"

> N(3, 4) = "Somnath Drekkana"

> N(4, 1) = "Parashara Chaturthamsa"

> N(4, 2) = "Cyclical Chaturthamsa"

> N(5, 1) = "Cyclical Panchamsa"

> N(6, 1) = "Shasthamsa"

> N(7, 1) = "Saptamsa"

> N(8, 1) = "Ashtamsa"

> N(9, 1) = "Navamsa"

> N(10, 1) = "Dasamsa"

> N(11, 1) = "Rudramsa"

> N(12, 1) = "Dwadasamsa"

> N(16, 1) = "Shodasamsa"

> N(20, 1) = "Vimsamsa"

> N(24, 1) = "Siddhamsa"

> N(27, 1) = "Nakshatramsa"

> N(30, 1) = "Standard Trimsamsa"

> N(30, 2) = "Parivritti Trimsa Trimsamsa"

> N(30, 3) = "Trimsamsa (Like Shastyamsa)"

> N(40, 1) = "Khavedamsa"

> N(45, 1) = "Akshavedamsa"

> N(60, 1) = "Shastyamsa"

>

> There are 4 sheets. The details of the 4 sheets are

> provided below:

> 1. Sheet1: "Basic"- Here one needs to put the date

> of birth, time

> of birth, the longitude and latitude. The longitude

> and latitude need to

> be converted in decimals. For converting this divide

> the mintutes by 60

> and seconds by 3600 and add it to the degrees. The

> system shall

> calculate the Planetary longitudes for the planets

> and some upagrahas

> (Other bodies are in the process of being

> programmed).

> 2. Sheet2: "Division"- Here one can create any

> composite divisional

> chart. Lets take Navamsa Dwadasamsa. For creating

> this you need to put

> the Parameters for Navamsa, namely (9,1) in to the

> cells B2 and C2 and

> Dwadasamsa in the cells D2 and E2. Somebody well

> versed in Excel can

> create composite charts to any level such as

> Navamsa-Navamsa-Dwadasamsa.

> 3. Sheet3: "Two Big Charts": While analysing any

> native's horoscope

> we generally analyse a particular divisional chart

> in conjunction with

> the Rasi Chart. This sheet shows Big view of two

> divisional charts. By

> default, I have put Rasi and Navamsa Chart. You can

> chose your own

> divisional chatrs, you need to just put the

> parameters on the cells

> marked yellow on the top of the divisional charts.

> The Kashinath Hora

> chart is programmed. Use the parameters 2, 5 for

> Division and Var

> respectively to get the chart.

> 4. Sheet4: "All Divisional Charts": This displays

> all the

> divisional charts which has been programmed so far.

> You can see most of

> the variations of different divisional charts.

> Please let me know if you

> want something else to be included.

>

> Other consideration:

> 1. To make the excelsheet working, please place the

> .dll file

> included in the zip file I am sending, in the

> /windows/systems directory

> 2. You can use the degrees of the planets in the

> divisional charts,

> judiciously. Even though no shastras have spoken

> anything on this so

> far. I "personally" think that they can be used in

> various ways such as

> finding the exact planetary conjunctions, aspects

> etc. This is open to

> research. Look in Sheet "Division" for the degrees

> of planets in the

> divisional charts.

> 3. You find the placement of any body in the zodiac

> in the

> divisional charts. What you need to do is just put

> the longitude of the

> planet in the the sheet "Division" in the column F.

> 4. There are numerous functions available in the

> sheet, which can

> be used in research, but yet to be documented. I

> will send an update

> whenever I do that.

> 5. This excel file is in public domain. Anyone can

> enhance it,

> however, please let me know incase you are making

> any modifications or

> enhancement.

> 6. Currently the excel file doesnot show

> retrogression etc. which

> shall be programmed and released later.

>

> Please let me know your feedback.

>

> Best Wishes

> Sarajit

>

> ATTACHMENT part 2 application/x-zip-compressed

name=Jyotish Calc.zip

Protect your identity with Mail AddressGuard

http://antispam./whatsnewfree

Your use of is subject to

December 7, 2003

Dear Sarajit,

Good initiative and nice work indeed.

Thank you.

Kind regards/Jay Weisshttp://www.alvicomm.com

-

Sarajit Poddar

varahamihira ; vedic astrology ;

Sunday, December 07, 2003 6:09 AM

[vedic astrology] Jyotish Calculator in Excel

|| Jaya Jagannath ||

Dear Jyotisha,

I am attaching an excel file for calculation of planetary positions and the

divisional charts. This is a advance calculator, which can make composite

divisional charts. The function for finding the composite division is

“divplanetlongitude()”. The parameters to be supplied for this function is

Degree of a planet in the Rasi Chart, the division chart no. and the variation

in the divisional chart.

The Divisional chart no. and their variations are listed below:

N(1, 1) = "Rasi"

N(2, 1) = "Hora (1/7 House)"

N(2, 2) = "Parashara Hora"

N(2, 3) = "Parivrittidvaya Hora"

N(2, 4) = "Jagannath Hora"

N(2, 5) = "Kashinath Hora"

N(3, 1) = "Parashara Drekkana"

N(3, 2) = "Jagannath Drekkana"

N(3, 3) = "Parivrittitraya Drekkana"

N(3, 4) = "Somnath Drekkana"

N(4, 1) = "Parashara Chaturthamsa"

N(4, 2) = "Cyclical Chaturthamsa"

N(5, 1) = "Cyclical Panchamsa"

N(6, 1) = "Shasthamsa"

N(7, 1) = "Saptamsa"

N(8, 1) = "Ashtamsa"

N(9, 1) = "Navamsa"

N(10, 1) = "Dasamsa"

N(11, 1) = "Rudramsa"

N(12, 1) = "Dwadasamsa"

N(16, 1) = "Shodasamsa"

N(20, 1) = "Vimsamsa"

N(24, 1) = "Siddhamsa"

N(27, 1) = "Nakshatramsa"

N(30, 1) = "Standard Trimsamsa"

N(30, 2) = "Parivritti Trimsa Trimsamsa"

N(30, 3) = "Trimsamsa (Like Shastyamsa)"

N(40, 1) = "Khavedamsa"

N(45, 1) = "Akshavedamsa"

N(60, 1) = "Shastyamsa"

There are 4 sheets. The details of the 4 sheets are provided below:

Sheet1: “Basic”- Here one needs to put the date of birth, time of birth, the

longitude and latitude. The longitude and latitude need to be converted in

decimals. For converting this divide the mintutes by 60 and seconds by 3600 and

add it to the degrees. The system shall calculate the Planetary longitudes for

the planets and some upagrahas (Other bodies are in the process of being

programmed). Sheet2: “Division”- Here one can create any composite divisional

chart. Lets take Navamsa Dwadasamsa. For creating this you need to put the

Parameters for Navamsa, namely (9,1) in to the cells B2 and C2 and Dwadasamsa

in the cells D2 and E2. Somebody well versed in Excel can create composite

charts to any level such as Navamsa-Navamsa-Dwadasamsa. Sheet3: “Two Big

Charts”: While analysing any native’s horoscope we generally analyse a

particular divisional chart in conjunction with the Rasi Chart. This sheet

shows Big view of two divisional charts. By default, I have put Rasi and

Navamsa Chart. You can chose your own divisional chatrs, you need to just put

the parameters on the cells marked yellow on the top of the divisional charts.

The Kashinath Hora chart is programmed. Use the parameters 2, 5 for Division

and Var respectively to get the chart. Sheet4: “All Divisional Charts”: This

displays all the divisional charts which has been programmed so far. You can

see most of the variations of different divisional charts. Please let me know

if you want something else to be included.

Other consideration:

To make the excelsheet working, please place the .dll file included in the zip

file I am sending, in the /windows/systems directory You can use the degrees of

the planets in the divisional charts, judiciously. Even though no shastras have

spoken anything on this so far. I “personally” think that they can be used in

various ways such as finding the exact planetary conjunctions, aspects etc.

This is open to research. Look in Sheet “Division” for the degrees of planets

in the divisional charts. You find the placement of any body in the zodiac in

the divisional charts. What you need to do is just put the longitude of the

planet in the the sheet “Division” in the column F. There are numerous

functions available in the sheet, which can be used in research, but yet to be

documented. I will send an update whenever I do that. This excel file is in

public domain. Anyone can enhance it, however, please let me know incase you

are making any modifications or enhancement. Currently the excel file doesnot

show retrogression etc. which shall be programmed and released later.

Please let me know your feedback.

Best Wishes

SarajitArchives: vedic astrologyGroup info:

vedic astrology/info.htmlTo UNSUBSCRIBE: Blank

mail to vedic astrology-....... May Jupiter's light

shine on us .......

December 7, 2003

om namo näräyaëäya|Dear Sarajit,

Really this is a good work.Now I wanted to clarify from you that is that I have

to put all the figures from my chart like not only date,time,lat. and Long.but

also all planetary Long.etc.?

With Sri Hari Vaayu Naama Smarana,

Ramadas Rao."J. Weiss" <jayhw (AT) telia (DOT) com> wrote: