Jyotish Calculator in Excel -> Ramadas Rao

[Guest guest]

Dear Ramadas Rao,

I also use XP and there is no problem. The Excel sheet works fine.

I suggest that you check Excels parameters (like the separating character [,] / [.] / [:]).

 

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

-

Ramadas Rao

vedic astrology

Monday, December 08, 2003 10:35 PM

Re: [vedic astrology] Re: Jyotish Calculator in Excel

` nmae naray[ay,

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

After replying your mail,I tried to put my birth data into the software and as

in the case of Raghunadha Rao,same thing happens like #Value!.I am using

Windows XP Professional.

Please try to solve the problem.

With Sri Hari Vaayu Naama Smarana,

Ramadas Rao.Rao Nemani <raon1008 > wrote:

Hare Rama KrishnaNamaste Sarajit Ji,I have set my security to medium and enabled

the macros. But when I tried to change the birth date immediately, I see

"#VALUE!" all over the spread-sheet and I am not able to enter my own birth

details to get the different charts.Can you and some one please help me to

understand what and how to run this macro to work for any given birth

details.Thanks for your help in adavance.RegardsRaghunadha Rao--- In

vedic astrology, "Sarajit Poddar" <sarajit@s...> wrote:> ||

Jaya Jagannath ||> Dear Ramadas,> > You need not put any planetary longitudes,

you only need to put the > Date, Time, Longitude and Latitude. The excel sheet

shall calculate > everything on its own.> > You need to how ever, enable macro

written for it. In most of the > windows O/S it asks whether you would like to

enable the macro, when > the security is set to medium.> > Regards> Sarajit> >

> > ` nmae naray[ay,> > 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@t...> wrote:> > > > @page Section1 {size: 8.5in 11.0in;

margin: 1.0in 1.25in 1.0in > 1.25in; mso-header-margin: .5in;

mso-footer-margin: .5in; mso-paper-> source: 0; }P.MsoNormal { FONT-SIZE:

12pt; MARGIN: 0in 0in 0pt; > FONT-FAMILY: "Times New Roman"; mso-style-paren t:

""; mso-pagination: > widow-orphan; mso-fareast-font-family: "Times New Roman";

mso-ansi-> language: EN-GB}LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in

0pt; > FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: >

widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-ansi-> language:

EN-GB}DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; > FONT-FAMILY:

"Times New Roman"; mso-style-parent: ""; mso-pagination: > widow-orphan;

mso-fareast-font-family: "Times New Roman"; mso-ansi-> language: EN-GB}A:link {

COLOR: blue; TEXT-DECORATION: > underline; text-underline:

single}SPAN.MsoHyperlink { COLOR: blue; > TEXT-DECORATION: underline;

text-underline: single}A:visited { COLOR: > purple; TEXT-DECORATION: und

erline; text-underline:> > single}SPAN.MsoHyperlinkFollowed { COLOR:

purple; TEXT-DECORATION: > underline; text-underline: single}SPAN.EmailStyle17

{ COLOR: > windowtext; FONT-FAMILY: Arial; mso-style-type:

personal-compose; mso-> style-noshow: yes; mso-ansi-font-size: 10.0pt;

mso-bidi-font-size: > 10.0pt; mso-ascii-font-family: Arial;

mso-hansi-font-family: Arial; mso-> bidi-font-family: Arial}SPAN.GramE {

mso-style-name: ""; mso-gram-e: > yes}DIV.Section1 { page: Section1}OL {

MARGIN-BOTTOM: 0in}UL {> MARGIN-BOTTOM: 0in}Dear Sarajit,> > > > Good

initiative and nice work indeed.> > Thank you.> > > > Kind regards> > /Jay

Weiss> > http://www.alvicomm.com> > > > - > >

Sarajit Poddar > > varahamihira ;

vedic astrology ; > > > Sent:

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 Cha rts": 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:> > > >

&nb sp; 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> > > > Sarajit> > > > > > > > Archives:

vedic astrology> > > > Group info:

vedic astrology/info.html> > < BR>> > To

UNSUBSCRIBE: Blank mail to vedic astrology-> > > >

> > > > || Om Tat Sat ||

Sarvam Sri Krishnaarpanamastu || > > > > Your use of is subject

to the > > > > Sponsor> > >

> Archives: vedic astrology> > > > Group info:

vedic astrology/info.html> > > > To UNSUBSCRIBE:

Blank mail to vedic astrology-> > > > ....... May

Jupiter's light shine on us .......> > > > || Om Tat Sat || Sarvam Sri

Krishnaarpanamastu || > > > > Your use of is subject to the

> > > > India Mobile: Ringtones, Wallpapers,

Picture Messages and > more.Download now.> >Archives:

vedic astrologyGroup info:

vedic astrology/info.htmlTo UNSUBSCRIBE: Blank

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

shine on us .......

 

India Mobile: Ringtones, Wallpapers, Picture Messages and more. Download

now. Archives: vedic astrologyGroup info:

vedic astrology/info.htmlTo UNSUBSCRIBE: Blank

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

shine on us .......

 

[Guest guest]

Hare Rama Krishna

 

Namaste Jay,

 

I have tried all those combinations, but still I am getting #Value!

in all the cells. I am using Win 2000 Professional with MS-Excel

2000 versions.

 

Any other suggestions / ideas you have for us please.

 

Regards

Raghunadha Rao

 

 

vedic astrology, "J. Weiss" <jayhw@t...> wrote:

> Dear Ramadas Rao,

> I also use XP and there is no problem. The Excel sheet works fine.

> I suggest that you check Excels parameters (like the separating

character [,] / [.] / [:]).

>

> Kind regards

> /Jay Weiss

> http://www.alvicomm.com

>

> -

> Ramadas Rao

> vedic astrology

> Monday, December 08, 2003 10:35 PM

> Re: [vedic astrology] Re: Jyotish Calculator in Excel

>

>

> ` nmae naray[ay,

>

> om namo näräyaëäya|

> Dear sarajit,

> After replying your mail,I tried to put my birth data into the

software and as in the case of Raghunadha Rao,same thing happens like

#Value!.I am using Windows XP Professional.

> Please try to solve the problem.

> With Sri Hari Vaayu Naama Smarana,

> Ramadas Rao.

> Rao Nemani <raon1008> wrote:

> Hare Rama Krishna

>

> Namaste Sarajit Ji,

>

> I have set my security to medium and enabled the macros.

> But when I tried to change the birth date immediately, I

> see "#VALUE!" all over the spread-sheet and I am not able

> to enter my own birth details to get the different charts.

>

> Can you and some one please help me to understand what and

> how to run this macro to work for any given birth details.

>

> Thanks for your help in adavance.

>

> Regards

> Raghunadha Rao

>

>

>

> vedic astrology, "Sarajit Poddar"

> <sarajit@s...> wrote:

> > || Jaya Jagannath ||

> > Dear Ramadas,

> >

> > You need not put any planetary longitudes, you only need to

put the

> > Date, Time, Longitude and Latitude. The excel sheet shall

calculate

> > everything on its own.

> >

> > You need to how ever, enable macro written for it. In most of

the

> > windows O/S it asks whether you would like to enable the

macro,

> when

> > the security is set to medium.

> >

> > Regards

> > Sarajit

> >

> >

> > > ` nmae naray[ay,

> > > 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@t...> wrote:

> > >

> > > @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in

1.0in

> > 1.25in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-

paper-

> > source: 0; }P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in

0in 0pt;

> > FONT-FAMILY: "Times New Roman"; mso-style-paren t: ""; mso-

> pagination:

> > widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-

ansi-

> > language: EN-GB}LI.MsoNormal { FONT-SIZE: 12pt; MARGIN:

0in

> 0in 0pt;

> > FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-

> pagination:

> > widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-

ansi-

> > language: EN-GB}DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN:

0in

> 0in 0pt;

> > FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-

> pagination:

> > widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-

ansi-

> > language: EN-GB}A:link { COLOR: blue; TEXT-DECORATION:

> > underline; text-underline: single}SPAN.MsoHyperlink {

COLOR: blue;

> > TEXT-DECORATION: underline; text-underline: single}A:visited {

> COLOR:

> > purple; TEXT-DECORATION: und erline; text-underline:

> > > single}SPAN.MsoHyperlinkFollowed { COLOR: purple;

TEXT-

> DECORATION:

> > underline; text-underline: single}SPAN.EmailStyle17 {

COLOR:

> > windowtext; FONT-FAMILY: Arial; mso-style-type: personal-

compose;

> mso-

> > style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-

size:

> > 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family:

Arial;

> mso-

> > bidi-font-family: Arial}SPAN.GramE { mso-style-name: "";

mso-gram-

> e:

> > yes}DIV.Section1 { page: Section1}OL { MARGIN-

BOTTOM: 0in}UL

> {

> > MARGIN-BOTTOM: 0in}Dear Sarajit,

> > >

> > > Good initiative and nice work indeed.

> > > Thank you.

> > >

> > > Kind regards

> > > /Jay Weiss

> > > http://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 Cha rts": 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:

> > >

> > > &nb sp; 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

> > >

> > > Sarajit

> > >

> > >

> > >

> > >

> > >

> > > Group info: vedic-

astrology/info.html

> > > < BR>> > To UNSUBSCRIBE: Blank mail to vedic astrology-

>

> > >

> > > ....... May Jupiter's light shine on us .......

> > >

> > >

> > >

> > > Terms of

> Service.

> > >

> > > Sponsor

> > >

> > >

> > >

> > > Group info: vedic-

astrology/info.html

> > >

> > > To UNSUBSCRIBE: Blank mail to vedic astrology-

>

> > >

> > > ....... May Jupiter's light shine on us .......

> > >

> > >

> > >

> > > Terms of

> Service.

> > >

> > > India Mobile: Ringtones, Wallpapers, Picture

Messages and

> > more.Download now.

> > >

>

>

>

>

>

> Group info: vedic-

astrology/info.html

>

> To UNSUBSCRIBE: Blank mail to vedic astrology-

 

>

> ....... May Jupiter's light shine on us .......

>

>

>

> Terms of

Service.

>

> India Mobile: Ringtones, Wallpapers, Picture Messages and

more. Download now.

> Sponsor

>

>

>

>

>

>

>

>

>

> To UNSUBSCRIBE: Blank mail to vedic astrology-

 

>

> ....... May Jupiter's light shine on us .......

>

>

>

> Terms of

Service.

[Guest guest]

||Om Brihaspataye Namah||

 

Dear Shri Ramadas and Ragunadha,

 

The trick is to click the (original unmodified) input data cell and

press F2 (for edit); then the format of the cell is revealed and you

can enter data according to the format specified.

 

Hope this helps.

 

regards

Hari

 

 

vedic astrology, "Rao Nemani" <raon1008>

wrote:

> Hare Rama Krishna

>

> Namaste Jay,

>

> I have tried all those combinations, but still I am getting

#Value!

> in all the cells. I am using Win 2000 Professional with MS-Excel

> 2000 versions.

>

> Any other suggestions / ideas you have for us please.

>

> Regards

> Raghunadha Rao

>

>

> vedic astrology, "J. Weiss" <jayhw@t...>

wrote:

> > Dear Ramadas Rao,

> > I also use XP and there is no problem. The Excel sheet works

fine.

> > I suggest that you check Excels parameters (like the separating

> character [,] / [.] / [:]).

> >

> > Kind regards

> > /Jay Weiss

> > http://www.alvicomm.com

> >

> > -

> > Ramadas Rao

> > vedic astrology

> > Monday, December 08, 2003 10:35 PM

> > Re: [vedic astrology] Re: Jyotish Calculator in Excel

> >

> >

> > ` nmae naray[ay,

> >

> > om namo näräyaëäya|

> > Dear sarajit,

> > After replying your mail,I tried to put my birth data into the

> software and as in the case of Raghunadha Rao,same thing happens

like

> #Value!.I am using Windows XP Professional.

> > Please try to solve the problem.

> > With Sri Hari Vaayu Naama Smarana,

> > Ramadas Rao.

> > Rao Nemani <raon1008> wrote:

> > Hare Rama Krishna

> >

> > Namaste Sarajit Ji,

> >

> > I have set my security to medium and enabled the macros.

> > But when I tried to change the birth date immediately, I

> > see "#VALUE!" all over the spread-sheet and I am not able

> > to enter my own birth details to get the different charts.

> >

> > Can you and some one please help me to understand what and

> > how to run this macro to work for any given birth details.

> >

> > Thanks for your help in adavance.

> >

> > Regards

> > Raghunadha Rao

> >

> >

> >

> > vedic astrology, "Sarajit Poddar"

> > <sarajit@s...> wrote:

> > > || Jaya Jagannath ||

> > > Dear Ramadas,

> > >

> > > You need not put any planetary longitudes, you only need

to

> put the

> > > Date, Time, Longitude and Latitude. The excel sheet shall

> calculate

> > > everything on its own.

> > >

> > > You need to how ever, enable macro written for it. In most

of

> the

> > > windows O/S it asks whether you would like to enable the

> macro,

> > when

> > > the security is set to medium.

> > >

> > > Regards

> > > Sarajit

> > >

> > >

> > > > ` nmae naray[ay,

> > > > 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@t...> wrote:

> > > >

> > > > @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in

> 1.0in

> > > 1.25in; mso-header-margin: .5in; mso-footer-margin: .5in;

mso-

> paper-

> > > source: 0; }P.MsoNormal { FONT-SIZE: 12pt; MARGIN:

0in

> 0in 0pt;

> > > FONT-FAMILY: "Times New Roman"; mso-style-paren t: ""; mso-

> > pagination:

> > > widow-orphan; mso-fareast-font-family: "Times New Roman";

mso-

> ansi-

> > > language: EN-GB}LI.MsoNormal { FONT-SIZE: 12pt;

MARGIN:

> 0in

> > 0in 0pt;

> > > FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-

> > pagination:

> > > widow-orphan; mso-fareast-font-family: "Times New Roman";

mso-

> ansi-

> > > language: EN-GB}DIV.MsoNormal { FONT-SIZE: 12pt;

MARGIN:

> 0in

> > 0in 0pt;

> > > FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-

> > pagination:

> > > widow-orphan; mso-fareast-font-family: "Times New Roman";

mso-

> ansi-

> > > language: EN-GB}A:link { COLOR: blue; TEXT-

DECORATION:

> > > underline; text-underline: single}SPAN.MsoHyperlink {

> COLOR: blue;

> > > TEXT-DECORATION: underline; text-underline: single}

A:visited {

> > COLOR:

> > > purple; TEXT-DECORATION: und erline; text-underline:

> > > > single}SPAN.MsoHyperlinkFollowed { COLOR: purple;

> TEXT-

> > DECORATION:

> > > underline; text-underline: single}SPAN.EmailStyle17 {

> COLOR:

> > > windowtext; FONT-FAMILY: Arial; mso-style-type: personal-

> compose;

> > mso-

> > > style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-

font-

> size:

> > > 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-

family:

> Arial;

> > mso-

> > > bidi-font-family: Arial}SPAN.GramE { mso-style-

name: "";

> mso-gram-

> > e:

> > > yes}DIV.Section1 { page: Section1}OL { MARGIN-

> BOTTOM: 0in}UL

> > {

> > > MARGIN-BOTTOM: 0in}Dear Sarajit,

> > > >

> > > > Good initiative and nice work indeed.

> > > > Thank you.

> > > >

> > > > Kind regards

> > > > /Jay Weiss

> > > > http://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 Cha rts": 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:

> > > >

> > > > &nb sp; 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

> > > >

> > > > Sarajit

> > > >

> > > >

> > > >

> > > >

> > > >

> > > > Group info: vedic-

> astrology/info.html

> > > > < BR>> > To UNSUBSCRIBE: Blank mail to vedic astrology-

> >

> > > >

> > > > ....... May Jupiter's light shine on us .......

> > > >

> > > > || Om Tat Sat || Sarvam Sri Krishnaarpanamastu

||

> > > >

> > > > Terms

of

> > Service.

> > > >

> > > > Sponsor

> > > >

> > > >

> > > >

> > > > Group info: vedic-

> astrology/info.html

> > > >

> > > > To UNSUBSCRIBE: Blank mail to vedic astrology-

> >

> > > >

> > > > ....... May Jupiter's light shine on us .......

> > > >

> > > > || Om Tat Sat || Sarvam Sri Krishnaarpanamastu

||

> > > >

> > > > Terms

of

> > Service.

> > > >

> > > > India Mobile: Ringtones, Wallpapers, Picture

> Messages and

> > > more.Download now.

> > > >

> >

> >

> >

> >

> >

> > Group info: vedic-

> astrology/info.html

> >

> > To UNSUBSCRIBE: Blank mail to vedic astrology-

>

> >

> > ....... May Jupiter's light shine on us .......

> >

> >

> >

> > Terms of

> Service.

> >

> > India Mobile: Ringtones, Wallpapers, Picture Messages

and

> more. Download now.

> > Sponsor

> >

> >

> >

> >

> >

> >

> >

> > Group info: vedic-

astrology/info.html

> >

> > To UNSUBSCRIBE: Blank mail to vedic astrology-

>

> >

> > ....... May Jupiter's light shine on us .......

> >

> >

> >

> > Terms of

> Service.