Guest guest Posted March 10, 2005 Report Share Posted March 10, 2005 Can you tell me where can i get this .xls file? Thanks in Advance. Nallathampy vedic astrology, "aokedia" <anilkedia@i...> wrote: > > > > Dear Friends > > RAM KRISHN HARE > > Event-Dasha-Transit.xls has 48 sheets with features as given below: > > DATA SHEET > > PLEASE ENTER ONLY IN BOLD AREAS > > Sample entries for chart are shown below: > > > Name Anilkumar Kedia > > Year 1968 > Month 1 > Day 28 > Hour 2:47:27 PM Enter as HH:MM:SS AM (or PM) > > Latitude(degrees) 20 (N=+, S=-) > > latitude(minutes) 42 (N=+, S=-) > > longitude(degrees) 77 (E=+, W=-) > > Longitude(minutes) 2 (E=+, W=-) > > TZ(hours) -5.5 (E of GMT=-, W of GMT=+) > > Note: for DST subtract 1 from Standard Time Zone > > OPEN AND SAVE FILE BUTTONS: > You can directly open and save data in .jhd compatible file format. > You can enter upto 20 events and save them in same .jhd files without > any difficulty in opening in Jagannath Hora Lite.DST will be mearged > in time zone. > > ENTER VARG FOR CHART/ASHTAKVARG/DASHAS IN DIGITS: 1 > > HORA: Kashinath?Ayana?Parivrittidwaya? x > You may choose one of the three hora charts.Default is Kashinath- hora. > > Difference 0 (Lahiri- Required Ayan) > It helps you to choose any ayanansha by entering its difference from > Lahiri. > > Change Lagna By(Degrees) 0 > You can change lagn by any degree to make any Rashi/Grah Etc. as Lagn > and find dashas > with respect to it.Also suitable for rectification trials. > > CALCULATED KETU > Put X to use calculated Rashi of Ketu in Vargas.Default is opposite > to Rahu. > Longitude of RAVI > For Exact Date/Time enter longitude and it will be used for Mas Dasha > etc. > > EVENT NO.FOR SARVATOBHADR CHAKR 0 > Years Completed 35 > EPHEMERIS: > ENTER START DATE 1/1/2004 6:12:43 PM > INTERVAL IN DAYS 1 > You can set time interval from a second to years as you please. > But do not forget to convert it in days. Fractions(=365.25636) > and expressions(=1/24 for hourly interval) are allowed. > NOTE: ALL DATES ARE SHOWN IN DD/MM/YYYY FORMAT BUT YOU > MUST ENTER ALL DATES IN MM/DD/YYYY FORMAT ON ALL SHEETS. > > Chart for Event No. 24 > This is reference for vargas and dashas. > > RASHI-BHUKT-VINSHOTTARY/UDU DASHA > > Days/Year 365.25636 > Change Longitude > You can enter any longitude here from which Udu dashas will be > calculated. > For example,you may enter longitude of lagn or special nakshatr to > calculate dashas begining from it. > Compression factor may be entered to calculate Varsh- dasha,Tribhagi- > dasha etc.You can even compress the dasha to any desired length. > Please note that dasha-length * compression =120(for Vinshottary > Dasha) > Some typical values for compression are given below. > compression=1 Vinshottary dasha > compression=3 Tribhagi dasha > compression=120 Varsh Vinshottary dasha > DASHA CYCLE You can use it to find 1st,2nd etc. cycles of dasha.You > may also use 0,-1 etc. to find > dashas before birth but make sure that it is after 1900. It can be > useful if you want to check events before > your birth.If event and dashas are not in same time-period,you will > see only Maha-dashas. > > Stronger Mangal/Ketu,Shani/Rahu,Shani/Ketu may be changed here. > > SUDASHA > Modify Sree Lagn > Sree Lagn degrees to be entered > > Dasha Compression > Purnayush You can enter any value like 1,5,120,144 etc. for rashi > dashas. > Compression It is for compressing calculated dashas by entered > number. > use 1 for normal dashas without compression. > Days in a year > 1 Solar Year: 365.25636(but you can use any value you wish) > > NIRYAN & SHOOL DASHA > > Rasi of Relation to be entered in digits. > > STRONGER RASHI can be seen for opposite/trinal/kendr Rashis. > You can use Suggested or Modify. > Modify Periods > You need to enter difference between shown years and years you want > to be used. > Exaltation and Debilitation signs for Rahu and Ketu can be entered in > place of shown signs. > > FIND STRONG RASHI > ENTER RASHI PAIR ONE,TWO,THREE can calculate stronger of 2 rashis > based on > Jaimini Rules for 3 pairs you may enter.This option is useful if you > need to know strength > of any 2 rashis selected at random. > GRAH SUGGESTED ORDER will give order for mool dasha based on > their strength. > MODIFY ORDER may be used to provide your own order. > MODIFY YEAR can be used to specify your own dasha years. > > Enter an x next to the chosen value if you want to change default > options in following cases. > Leaving these boxes unmodified, will use known rules to find default > values. > > Modify Dasha Progression > You can choose to have CHAR/STHIR/DWISWABHAV Dasha progression for > NARAYAN DASHA and PARYAY DASHA. > > Use Dasha Years = 9 This option sets dasha years to 9 for following > Rashi Dashas. > (Narayan,Char,Sudasha,Drig,Trikon,Paryay,LKendradi,Niryan,Shool,Mando o > k) > > Reverse Sequence forward/backward can be used to modify > sequence for any/all 6 levels of > Rashi Dashas. > (Narayan,Char,Sudasha,Drig,Trikon,Paryay,LKendradi,Niryan,Shool,Mando o > k) > > Enter Start Rashi In Digits can be used to modify starting Rashi for > any/all 6 levels of > Rashi Dashas. > (Narayan,Char,Sudasha,Drig,Trikon,Paryay,LKendradi,Niryan,Shool,Mando o > k) > > EVENTS SHEET > > EXACT DATE AND TIME CALCULATION FOR DASHA can be used to find dasha > date/time > based on Ravi's Longitude. > DATE CALCULATED BY PROGRAM needs to be entered/copied. > DATE EXACT will show exact date/time. > > EVENT > 0 indicates current date/time on your computer. > 1-20 can be entered by you.You may also enter event description in > last column in place of > EVENT1,EVENT2 ETC.Please take care to have only one word for > description.If you wish,you may > combine words using_between 2 words.This will help proper retrival > after saving. > TRIAL Event can be used to find suitable dasha/transit/muhurt etc. > for native.You can change it > to find suitability of date/time. > TAJIK CHART can provide you exact date/time for any choosen age as > per Ravi's Longitude. > Tithi Pravesh: You can findly monthly/early Tithi-Pravesh charts for > age used above. > BIRTH can be used as event to find various details like > Vedha,transit,etc. > You can even use any event as natal chart to see all dashas and > vargas set accordingly. > This is particularly useful in Tajik/Prashna/Tithi-Pravesh charts. > for example Event No. 24-Birth, 23-Tithi-Pravesh, 22-Tajik chart etc. > > TRANSIT SHEET > > PLEASE ENTER ONLY IN BOLD AREAS(COLUMNS B & C). > YOU CAN ENTER ANY DEGREE in FRACTION ALSO. > RAVI,CHANDR,RAHU,LAGN ARE CORRECT EXCEPT FOR 0/360.TRY INTERCHANGING > 0/360. > BUT IN OTHER CASES IT MAY OR MAY NOT GIVE CORRECT DATE. > TRY ANOTHER DATE IF REQUIRED.Dates from calculation will be helpful > in most cases. > First use any period and then change it till you get exact > transit.CLOSER DATE IS BETTER. > > TITHI - VARG > It shows Varg occupied by tithi.You can also experiment with Grah and > Bhav Tithis.Enter Tithi > at proper place to get vargas occupied by it. > BODY - VARG You may also use it for finding vargas for any longitude > you will enter. > You can also see Jyotirling table for Grah and Rashi. > > CHART SHEET > > NORTH INDIAN RASHI CHART, SUNRISE,SUNSET,DAY/NIGHT,ISHTKAL IN GHATI > > WEEKDAY,HORA-LAGN,GHATI-LAGN,LAGN,YAMA-LORD,TATWA > GRAH LONGITUDE IN DEG. IN DECIMAL,RASHI,GRAH- > GATI/DAY,NAKSHTR,UDAY/AST, > > BHAV-GRAH: > DHAN,BHRATRI,MATRI,SANTAN ETC. GRAHAS > > BHAV-GRAH-TITHI: > TITHIS FOR ALL GRAHAS FOR EACH BHAV LIKE DHAN,BHRATRI,MATRI,ETC. > > MUHURT SHEET > > DAY CHAUGHADIA AND NIGHT CHAUGHADIA(1/8) > DAY GUN AND NIGHT GUN(1/8) > DAY KAL-HORA AND NIGHT KAL-HORA(1/12) > > DAY DWIMUHURT AND NIGHT DWIMUHURT(1/15) > > DAY DUGHADIA AND NIGHT DUGHADIA(1/16) > > EPHEMERIS SHEET > > TIME IN GMT DEGREES and KAKSHYA of 9 planets > PANCHANG > > TITHI VAR(DAY) NAKSHTR YOG KARAN > > ANANDADI-YOG with PHAL(results) > > GRAH-CHARTS SHEET > > LAGN KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Lagn > > RAVI KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Ravi > > CHANDR KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Chandr > > MANGAL KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Mangal > > BUDH KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Budh > > GURU KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Guru > > > SHUKR KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Shukr > > SHANI KUNDALI > Kakshya Points for all 9 planets at Birth and Event from Shani > > RAHU KUNDALI > EVENT TRANSIT (NAR-CHAKR) analysis of all Grahas in Ang(Limb) > with Results > > KETU KUNDALI > EVENT TRANSIT results based on birth nakshatr. > > HORA KUNDALI > TARA FROM CHANDR Standered Nav-tara Placement of planets. > > > GHATI KUNDALI > SARVASHTAK-VARG with Sarvashtak Points for all 9 planets at Birth and > Event > > EVENT KUNDALI > ASHTAK-VARG with Bhinnashtak Points for all 9 planets at Birth > and Event. > VARG HELPER > VHELPER SHEET > > It helps in finding vargas in which a given planet is in specific > sign. > It also provides sorted list of natal grahas and bhavas for ORB users. > > DIN-VARSH PROGRESSION(1day=1year)at the time of event > Panchag Analysis of Event > TITHI-LORD VAR-LORD Nakshatresh YOG-LORD > KARNESH > KP RULING PLANETS of Event > RASHI-LORD VAR-LORD Nakshatresh LAGN-LORD lagn- > nak-lord > MUHURT ANALYSIS of Event > Chaughadia Dughadia Kal-Hora Dwimuhurt Gun > NATAL SAMAY AND EVENT SAMAY FOR VINSHOTTARY DASHA > with Samay Results for all grahas. > > REPORT SHEET > > Summary of 28 dashas > DASHA-PROGRESSION-DEGREE > All Dasha(Maha,Antar,PratyAntar,Sookshm,Prana) Rashis/Grahas with > > Kakshya-Lord and Sarvashtak, Lagnashtak/Chandrashtak Points and their > Kakshya. > > SBHADR SHEET > > Nakshatr ,Gati,Vedh-Direction(LEFT/RIGHT/OPPOSITE), Upgrahas based on > Ravi, Uday/Ast of > planets at the time of selected event are given in addition to > SARVATOBHADR CHAKR > All planets and upgrahas at the time of event are shown in chakr. > > ASHTAK SHEET > > SARVASHTAKVARG,Ashtakvarg for 9 planets and lagn for any choosen varg > with Prastar ashtakvarg > > KP SHEET > > Nakshatr and Sub Lords with KP-Longitude upto 5 level. > Grahas present in Nakshatr of planet > It provides longitudes of 12 houses as per placidus house system. > All longitudes are as per KP ayanansh on this sheet. > > KP-EPH SHEET > > KP-AYANANSH-EPHEMERIS Nakshatr and Sub Lords with KP-Longitude for 9 > planets. > > PROGRESSION SHEET > > MAHADASHA STARTING DATES FOR SELECTED EVENT > PROGRESSION OF NAVGRAH AND THREE LAGN AT THE TIME OF EVENT IN 20 > VARGAS > YEARS FOR PROGRESSION OF NAVGRAH AND THREE LAGN IN SELECTED VARG > All 28 Dashas/Bhukties/Pratyantar running at the time of selected > event are shown. > Position of all planets at the start of all mahadashas for the event > are displayed. > > VSPHUT SHEET > > Longitudes of 3 lagnas and 9 planets in varg charts,Events 31-50 are > also based on these longitudes. > So you can use any varg chart exactly as birth chart. use No. between > 31-50 to set these charts as birth chart instead of normal Rashi- > chart. > This will not be useful for events as date is same as birth-date. > Longitude of varg Chandr etc. will be used for all calculations > including > Dashas.You will also see Vargas of the selected vargas.This may be > useful > if you want to study Navamansh-Dwadashansh etc. > > BHAV SHEET > > VARGAS FROM 3LAGNAS AND 9 GRAHAS WITH DEITIES > > BHAV-VARGAS SHEET > > BENEFIC VARGAS FOR ALL BHAVAS FROM 3LAGNAS AND 9 GRAHAS IN > 16 AND 10 VARG SCHEME AND SUMMARY OF 20 VARGAS. > > VARG SHEET > > VARG CLASSIFICATION AND 20 VARG WITH DEITIES > You can see saumy\Krur and malefic\benefic based on D-60. > > RASHI BHUKT VINSHOTTARY DASHA SHEET > > NISARG DASHA SHEET > MAS DASHA SHEET > MOOL DASHA SHEET > SuDasha SHEET > Sudasha can be calculated for any varg with same Shree-Lagn > (adjustable). > > Narayan Dasha SHEET > All Rashi Dashas can be calculated for any varg upto Deh(6th) level > It will > automatically use correct lord,exception etc.You can even override > starting dasha/sequence/progression/Strong rashi or grah. > You can set Paramayush/compress and even use 9 years fixed Dasha > length. > Starting Dasha and Direction can be changed for All Dashas and Sub > Dashas. > Kakshya details for all dashas upto 5 level are provided. > Paramayush=1 will set first cycle dasha length=1 Year. > compress=144 will give dasha-length of 1 year including second cycle > (dasha-length*compress=144).This is applicable to all rashi dashas. > You should use only one of them as per your need/choice. > You can even find Lagnamsaka Dasa by starting dasha from > Navamansh Lagn Rashi.Padanadamsa dasa by starting dasha from > Arudh Lagn of Rashi in Navamansh varg. > > Char Dasha SHEET > Trikon Dasha SHEET > Drig Dasha SHEET > Lagn-Kendradi Dasha SHEET > Paryay Dasha SHEET > Niryan-Shool Dasha SHEET > Shool Dasha SHEET > Mandook Dasha SHEET > Sudarshan-Chakr Dasha SHEET > RASHI BHUKT 116 YEARS DASHA SHEET > > RASHI BHUKT 112 YEARS DASHA SHEET > RASHI BHUKT 108 YEARS DASHA(KRITTIKADI) SHEET > RASHI BHUKT 108 YEARS DASHA SHEET > RASHI BHUKT 105 YEARS DASHA SHEET > RASHI BHUKT 100 YEARS DASHA SHEET > RASHI BHUKT 84 YEARS DASHA SHEET > RASHI BHUKT 72 YEARS DASHA SHEET > RASHI BHUKT 60 YEARS DASHA SHEET > RASHI BHUKT 36 YEARS DASHA SHEET > RASHI BHUKT 36 YEARS DASHA(REGULAR) SHEET > RASHI BHUKT YOGINI DASHA SHEET > RASHI BHUKT SANDHYA-PACHAK DASHA SHEET > > STRONG SHEET > > It gives calculations for calculation of Rashi and Grah strength for > dashas etc. > > DASHA SHEET > > All 28 Dashas are automatically set as per the event and you can view > upto 6th level > on relevent dasha sheet. A summary is given on Report and Progression > sheets. > This sheet includes calculations for various dashas and other sheets. > It is only for use in Program and provide understanding for > Programmers. > > ********************************************************************* * > ************************************************** > Important Instructions: > > (1) Ketu is always opposite to Rahu in all vargas. > This is different from other softwares where > D16,D20,D24,D30,D40,D45,D-5,D-6,D-8 AND D2 have them > togather. > If you want them togather put x against calculated ketu > option. > > (2) Dasha dates are EXACT FOR GIVEN YEAR LENGTH. Based on Sun's > longitude it may be off by upto 5 days. > Mas dasha calculations can differ by 2-3 days. > Please ALWAYS check Sun's longitude for exact date and time. > Use exact date/time option when accuracy is needed. > > (3) For Mas-dasha you must also enter longitude of Ravi in data > sheet. > otherwise leave longitude of Ravi in data sheet blank. > You can also use this option to find entry of Ravi in > Mesh,Tula > etc. This will be useful for mundane charts.If you want to > use > it,copy calculated date/time manually to some event and set > the chart to that event. > > (4) If you corrupt something,exit without saving else re- > install. > > (5) Change in Lagna longitude will help you in rectification > trials > but original time will remain same.After you are > certain,you can > adjust time(=change*4 approx.) to suit your calculations. > You may also use it for relocation studies by adjusting > longitude(=change approximatly) accordingly. > Relocation is however not part of vedic- > jyotish. > > (6) Dasha calculation for Shani in 108 years and shukr in 60 > years dasha > includes Abhijeet.If your birth dashas are of these > planets,it will give > approximate results. All other cases will be correct. > > (7) Prashna/current time will change with system clock.If you > want to > use it,copy date/time shown manually to some other place > and set > the chart to that event. > > (8) Enter your data only on DATA, EVENT AND TRANSIT SHEETS in > BOLD areas only. > You do not need to enter any data if you just need dashas > from > Rashi chart.So if you do not know,just leave it unchanged. > It will do correctly. > > (9) If you see a lot of #NAME in most places, put the > directory containing swedll32.dll > file in path or copy it in any directory in path.If you > can't use open/save buttons,do not > bother.Just enter data manually and every thing will work > fine.You need to register > comdlg32.ocx manually to use those options.However if you > are using win 9x you > will have no problems.Installation will automatically take > care of everything. > > (10) IT WILL NOT TAKE DATES BEFORE 1-1-1900 (unless you modify > it). > > All calculations are correct upto seconds.Moon may be off by upto 5 > seconds. > This program is based on swiss ephemeris and needs MSExcel 97. Visit: > http://www.astro.ch/swisseph for licence details of swiss ephemeris. > You may download ephemeris files for better accuracy from this site. > > You can add your own calculations as there is no hidden code. > This is a freeware and open source/free code program. > You can freely copy/modify/distribute it for non commercial use. > > You are welcome to contribute/share your code for the program. > > Please feel free to send your suggestions/bugs. > > email: anilkedia@i... > > Anilkumar Kedia > > OM TAT SAT 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.