Jyotish Calculator in Excel

[Guest guest]

Dear Sarajit,

 

You made me sad by being so overly considerate and modest- you volunteered your great work for benefits of all of us and 'clogging the mail' simply is a big injustice to such a valuable present.

I am sure everybody likes and appreciates this great tool, and loves the way it was sent- ready for use.

I send my warmest wishes your way,

Anna

-"Sarajit Poddar" Mon, 08 Dec 2003 04:59:20 -0500vedic astrology Subject: |Sri Varaha| Re: [vedic astrology] Re: Jyotish Calculator in Excel|| Jaya Jagannath ||Dear Jyotisha,I have uploaded this file in to the files section of Varahamihira and Srijagannath . Those who have trouble accessing this, can write me personal mails and I would send them to their personal mailbox. The approximate size of the mail if 300 KB approx after zipping and I do not wish to clog the mailbox of the list members. Sorry for the inconvinience caused with my initial mail. Best WishesSarajit> dear friends, > Please let me know how to get this zip file> thanks> venkat> > vedic astrology , "Sarajit Poddar" > <sarajit@s...> wrote:> > || Jaya J

agannath ||> > 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) = "Jagan

nath 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 le

vel 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. Ple

ase 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> > >

[Guest guest]

Hi sarajit,

How are you? Are you coming to puri?

What is this jyotish calculator for? I cannot

access from india, so if you can forward

the file to me at narya.

regards,

nitish

 

--- Sarajit Poddar <sarajit wrote:

> || Jaya Jagannath ||

> Dear Jyotisha,

>

> I have uploaded this file in to the files section of

> Varahamihira and

> Srijagannath . Those who have trouble

> accessing this, can

> write me personal mails and I would send them to

> their personal

> mailbox. The approximate size of the mail if 300 KB

> approx after

> zipping and I do not wish to clog the mailbox of the

> list members.

> Sorry for the inconvinience caused with my initial

> mail.

>

> Best Wishes

> Sarajit

>

> > dear friends,

> > Please let me know how to get this zip file

> > thanks

> > venkat

> >

> > vedic astrology , " Sarajit

> Poddar "

> > <sarajit@s...> 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

> >

> >

> >