Sarvatobhadra Chakra Excel Now
Press ALT + F11 to open the VBA Editor, click Insert > Module , and paste the following code:
+-------------------------------------------------+ | LAYER 1: OUTER RIM | | (Nakshatras 1-7, 14-21, Vowels, Consonants) | | +-----------------------------------------+ | | | LAYER 2: MIDDLE RIM | | | | (Nakshatras 8-13, 22-28, Consonants) | | | | +---------------------------------+ | | | | | LAYER 3: INNER RIM | | | | | | (Rasis / Zodiac Signs) | | | | | | +-------------------------+ | | | | | | | LAYER 4: CORE | | | | | | | | (Tithis & Days of Week)| | | | | | | +-------------------------+ | | | | | +---------------------------------+ | | | +-----------------------------------------+ | +-------------------------------------------------+ The 9x9 Grid Layout
Anuradha, Jyeshtha, Mula, Purva Ashadha, Uttara Ashadha, Abhijit , Shravana. (Note: Abhijit must be included between Uttara Ashadha and Shravana).
Repeat for Vara, Nakshatra, Karana, Yoga. You will have 5 row offsets and 5 col offsets. sarvatobhadra chakra excel
Complete Guide to Building and Using a Sarvatobhadra Chakra in Excel
Group them into the internal corners based on classic texts (Nanda, Bhadra, Jaya, Rikta, Purna). Automating Planet Transits and Vedha Logic
The SBC is a 5x5 grid (totaling 25 squares). However, it contains distinct elements (27 Nakshatras + 1 Abhijit Nakshatra). Press ALT + F11 to open the VBA
| | Cell | Example Value | |---|---|---| | Tithi Number (1-30) | B2 | 15 | | Vara (1-7: Sun=1, Mon=2...) | B3 | 2 (Monday) | | Nakshatra (1-27) | B4 | 10 (Magha) | | Karana (1-11: Kimstughna=1...) | B5 | 7 | | Yoga (1-27) | B6 | 14 |
Next, fill the inner squares with their respective Consonants (like A, Va, Ka, Ha ), Rasis (Mesha, Vrishabha, etc.), and the central Tithi groups. Step 3: Create the Planet Input Table
The final cell in the Chakra is found by summing ALL offsets from the center (Row 5, Col 5 in your Chakra_Data sheet). You will have 5 row offsets and 5 col offsets
Observe the malefic (red) and benefic (green) highlights on the nakshatras.
Krittika, Rohini, Mrigashirsha, Ardra, Punarvasu, Pushya, Ashlesha, Magha, Purva Phalguni.
Let us consider a practical example often cited in Jyotish tutorials: .