Amended Lal-Kitab, excel file uploaded and enclosed.

[Guest guest]

Hi Lal Kitabers,

 

A new Excel file on calculations of Lal-Kitab has been uploaded and is being attached with this mail. File name "lal-kitab ver 5.0"

 

The changes in this file.

 

1) This is a contuniation of the Natal as well as Varshphal file that was circulated some time back.

 

2) Jagmeetji had suggested that Natal Chart and Varshphal of spouse too should be included.

This has been incorporated in the "lal-kitab ver 5.0" file.

 

3) He had also suggested that the "Benefic" and "Malefic" planets instead of a table should be shoun in the chart itself.

This has been incorporated in the "lal-kitab ver 5.0" file.

The "Benefic" Planets are shown in "Black" Colour and the "Malefic" Planets are shown as "Red"

 

4) Mercury in house 11 & 9 could be Benefic as well as Malefic.

This has been incorporated in the "lal-kitab ver 5.0" file.

Mercury in house 11 & 9 is shown as "Bu*" and with "Orange" Colour

 

5) The completed years now has been automated.

Just enter the DOB year and the varshphal year and the completed year is calculated automatically.

 

6) The printout has been fitted to 1 page. When printed on a printer the output will fit in 1 A4 Sheet.

 

7) The cells that require data input have been colored "Yellow" and are open for editing.

All other cells are locked.

 

 

As there have been many formulaes and calculations that have been added, it is requested that some of the learned members, do a check by entering the natal chart and creating a vashphal chart along with benefic and malefic planets for some random years and mail back if you find some errors.

 

Feedbacks and suggestions to enhance the spreadsheet is always welcome.

 

Thanking you all,

 

with best regards,

Pankaj Agarwal.

 

 

 

[Guest guest]

Dear Pankaj Ji,

My Pagdi(though I don't tie one at present)off to you. Its a wonderful

job you have done. My heartfelt thanks your wonderful gift to the group

and I am sure everyone must be as thrilled as I am. Seeing the spouse

chart also it becomes so easy to decide which planets need immediate

upaye.

Can I request you one more thing?

1)Please CHANGE Spouse to Person. Same sheet can be used for other

members of the family or even for that matter of girl/boy friend for

further snap shot look for the whole family. On two sheets I can have my

complete family's charts.

 

With regards,

Jagmeet

[Guest guest]

Thank you Jagmeetji for your kind words. With the kind of help I am receiving from the group, this is the least I could do in return.

 

Enclosed is the file with the changes. The changed file has been uploaded too.

 

Regards,

Pankaj.

 

 

 

-

jagmeet dheendsa

lalkitab

Cc: lalkitab

Tuesday, July 29, 2003 12:03 AM

Re: [lalkitab] Amended Lal-Kitab, excel file uploaded and enclosed.

Dear Pankaj Ji,My Pagdi(though I don't tie one at present)off to you. Its a wonderfuljob you have done. My heartfelt thanks your wonderful gift to the groupand I am sure everyone must be as thrilled as I am. Seeing the spousechart also it becomes so easy to decide which planets need immediateupaye.Can I request you one more thing?1)Please CHANGE Spouse to Person. Same sheet can be used for othermembers of the family or even for that matter of girl/boy friend forfurther snap shot look for the whole family. On two sheets I can have mycomplete family's charts.With regards,Jagmeet

[Guest guest]

Dear Pankaj Ji,

I can't say anything more then THANK YOU.

With regards,

Jagmeet

[Guest guest]

Pankaj ji

 

Just noticed some descrepency in the work sheet by chance. The

second set of of chart & Benefic/ Malefic table seems to differ from

the first for Mars, Guru & Rahu in 9 to 12 houses

 

Hope you can correct this since the work sheet is protected by you.

 

Regards.

Nigam

 

 

 

 

lalkitab , " Pankaj Agarwal " <apankaj68@h...>

wrote:

> Thank you Jagmeetji for your kind words. With the kind of help I

am receiving from the group, this is the least I could do in return.

>

> Enclosed is the file with the changes. The changed file has been

uploaded too.

>

> Regards,

> Pankaj.

>

>

> -

> jagmeet dheendsa

> lalkitab

> Cc: lalkitab

> Tuesday, July 29, 2003 12:03 AM

> Re: [lalkitab] Amended Lal-Kitab, excel file uploaded

and enclosed.

>

>

> Dear Pankaj Ji,

> My Pagdi(though I don't tie one at present)off to you. Its a

wonderful

> job you have done. My heartfelt thanks your wonderful gift to

the group

> and I am sure everyone must be as thrilled as I am. Seeing the

spouse

> chart also it becomes so easy to decide which planets need

immediate

> upaye.

> Can I request you one more thing?

> 1)Please CHANGE Spouse to Person. Same sheet can be used for

other

> members of the family or even for that matter of girl/boy friend

for

> further snap shot look for the whole family. On two sheets I can

have my

> complete family's charts.

>

> With regards,

> Jagmeet

>

>

[Guest guest]

Dear Pankaj ji

 

Can you tell me where can i find the excel file , these people are talking about.

Please do reply

 

Paras Jain

Pankaj jiJust noticed some descrepency in the work sheet by chance. The second set of of chart & Benefic/ Malefic table seems to differ from the first for Mars, Guru & Rahu in 9 to 12 housesHope you can correct this since the work sheet is protected by you.Regards.Nigamlalkitab , "Pankaj Agarwal" <apankaj68@h...> wrote:> Thank you Jagmeetji for your kind words. With the kind of help I am receiving from the group, this is the least I could do in return.> > Enclosed is the file with the changes. The changed file has been uploaded too.> > Regards,> Pankaj.> > > - > jagmeet dheendsa > lalkitab > Cc:

lalkitab > Tuesday, July 29, 2003 12:03 AM> Re: [lalkitab] Amended Lal-Kitab, excel file uploaded and enclosed.> > > Dear Pankaj Ji,> My Pagdi(though I don't tie one at present)off to you. Its a wonderful> job you have done. My heartfelt thanks your wonderful gift to the group> and I am sure everyone must be as thrilled as I am. Seeing the spouse> chart also it becomes so easy to decide which planets need immediate> upaye.> Can I request you one more thing?> 1)Please CHANGE Spouse to Person. Same sheet can be used for other> members of the family or even for that matter of girl/boy friend for> further snap shot look for the whole family. On two sheets I can have

my> complete family's charts.> > With regards,> Jagmeet> >