how can i improve my excel macro for vedic jyotish calculations?

Payyes Avatar

·

I have developed a custom worksheet calculation for Vedic astrology using VBA,
Any ideas/modifications would be appreciated. Link to google drive file

https://docs.google.com/spreadsheets/d/1Rl7VONf-diE-i_0EKBsSWG_IU5KO4Yx-/edit?usp=sharing&ouid=118063737601745889040&rtpof=true&sd=true

Steps to calculations
1. Enter birth details in DOB sheet
2. Enter the corresponding reference number in Vedic sheet (C3)
3. Click on Calculate Button to generate details in the table
gives Planetary degrees, conjunctions, exchange, bhava, rasi, natural benefic and functional benefic status, aspects
4.Click on Calculate Bhava Strength Button to generate table
gives details of Bhava Lord, Bhava Lord conjoined planets, Bhava lord aspecting planets, planets in bhava, planets aspecting bhava

how can i improve my excel macro for vedic jyotish calculations?

Payyes Avatar

·

I have developed a custom worksheet calculation for Vedic astrology using VBA,
Any ideas/modifications would be appreciated. Link to google drive file

https://docs.google.com/spreadsheets/d/1Rl7VONf-diE-i_0EKBsSWG_IU5KO4Yx-/edit?usp=sharing&ouid=118063737601745889040&rtpof=true&sd=true

Steps to calculations
1. Enter birth details in DOB sheet
2. Enter the corresponding reference number in Vedic sheet (C3)
3. Click on Calculate Button to generate details in the table
gives Planetary degrees, conjunctions, exchange, bhava, rasi, natural benefic and functional benefic status, aspects
4.Click on Calculate Bhava Strength Button to generate table
gives details of Bhava Lord, Bhava Lord conjoined planets, Bhava lord aspecting planets, planets in bhava, planets aspecting bhava