Guest guest Posted December 10, 2003 Report Share Posted December 10, 2003 Dear Ron, To find the navamsa of any varga you can do this. For Dasamsa it would be 10 1 9 1 or dwadamsa it would be 12 1 9 1. However, today morning I discovered that I have not copied the formula from the first cell to all the cells, in the Divisional Degree column. Please copy the formula and it should be working. Also the first 4 colums should update itself from the divisional degree column, please copy the formula for the first cell too. I would send this information to the list for them to update. Note that in the first cell formula where the cell no. for the divisional parameters are mentioned namely B2, C2 etc I guess for 10 1 9 1, just use absolute referencing by adding $ sign before the cell row and column indices. Thus B2 should be referenced as $B$2. This makes it a constant when you copy the formula to another cell. Regards Sarajit > Dear Sarajit, > > Thanks for sending the Excel calculator to the list. > How does one do navamsha values for any degree? > I assume that on row 2(sheet 2) the entry is 1191 but the list does not > update. > Individual entries in column F do not seem to work. > Please send instructions > > Thank you > Ron > > > Quote Link to comment Share on other sites More sharing options...
Guest guest Posted December 10, 2003 Report Share Posted December 10, 2003 Dear brother Sarjit Could you please send me this program. Love RG - " Sarajit Poddar " <sarajit " Ron Day " <ron Cc: <vedic astrology >; <varahamihira >; Wednesday, December 10, 2003 4:08 PM |Sri Varaha| Re: Excel calculator > Dear Ron, > > To find the navamsa of any varga you can do this. For Dasamsa it would > be 10 1 9 1 or dwadamsa it would be 12 1 9 1. However, today morning I > discovered that I have not copied the formula from the first cell to > all the cells, in the Divisional Degree column. Please copy the > formula and it should be working. Also the first 4 colums should > update itself from the divisional degree column, please copy the > formula for the first cell too. I would send this information to the > list for them to update. > > > Note that in the first cell formula where the cell no. for the > divisional parameters are mentioned namely B2, C2 etc I guess for 10 1 > 9 1, just use absolute referencing by adding $ sign before the cell > row and column indices. Thus B2 should be referenced as $B$2. This > makes it a constant when you copy the formula to another cell. > > Regards > Sarajit > > > > Dear Sarajit, > > > > Thanks for sending the Excel calculator to the list. > > How does one do navamsha values for any degree? > > I assume that on row 2(sheet 2) the entry is 1191 but the list > does not > > update. > > Individual entries in column F do not seem to work. > > Please send instructions > > > > Thank you > > Ron > > > > > > > > > > > |Om Tat Sat| > http://www.varahamihira > > Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.