Jyotish Calculator in Excel -> Ramadas Rao

December 8, 2003

All you have to do is increase the width of column. Point your mouse pointer

inbetween two column where you see # Value and shift it towards your right.

There is nothing wrong with your XP. The width of your column is not good enough

to display the value. (e.g. if you try to display 5 digits and your columun

width is set for 4 digits, you will see #Value)

Hope this helps.

RajRao Nemani <raon1008 > wrote:

Hare Rama KrishnaNamaste 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.RegardsRaghunadha Raovedic 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> > > > > > > > > > > > Archives:

vedic astrology> > > > > > 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 || > > > > > > Your

use of is subject to the Terms of > Service. > > >

> > > Sponsor> > > > > > Archives:

vedic astrology> > > > > > 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.> > >> > > > 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.

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

> > Terms of

Service.Archives: vedic astrologyGroup info:

vedic astrology/info.htmlTo UNSUBSCRIBE: Blank

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

shine on us .......

New Photos - easier uploading and sharing

December 8, 2003

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

I have tried all the method and of no use.

Anyhow there is some trick is there which i dont know and only computer experts

can solve this like you and others.If you can ,please write me privately to

solve this problem.

With Sri Hari Vaayu Naama Smarana,

Ramadas Rao.

"J. Weiss" <jayhw (AT) telia (DOT) com> 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 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 > > To:

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

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

> > > > > >

> 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 .......|| Om Tat Sat || Sarvam Sri Krishnaarpanamastu

||

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

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.

December 8, 2003

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

Thanks for replying.I will try and get back to you.

With Sri Hari Vaayu Naama Smarana,

Ramadas Rao.R Shukla <info4shukla > wrote: