Sarvatobhadra Chakra Excel

The Sarvatobhadra Chakra is a complex astrological chart used in Hindu astrology, also known as Jyotish. It's a 12-spoked wheel that displays the relationships between the 12 zodiac signs and their corresponding planetary rulers.

Creating a Sarvatobhadra Chakra in Excel requires some setup and calculations. Here's a step-by-step guide to help you create one:

Understanding the Sarvatobhadra Chakra

Before we dive into the Excel setup, let's briefly understand the Sarvatobhadra Chakra: sarvatobhadra chakra excel

  • The chart has 12 spokes, each representing a zodiac sign.
  • Each spoke is divided into sections, representing the planetary rulers and their relationships.
  • The chart displays the Sarvatobhadra Chakra's core principles:
    • The 12 zodiac signs
    • Their lords
    • The Nakshatras

Setting up the Sarvatobhadra Chakra in Excel

To create a Sarvatobhadra Chakra in Excel:

3. Step-by-Step Excel Construction

Title:

Creating Sarvatobhadra Chakra in Excel – A Digital Tool for Vedic Astrology & Auspicious Timing The Sarvatobhadra Chakra is a complex astrological chart

The Core Components of a Sarvatobhadra Chakra Excel Template

To build or understand a standard Sarvatobhadra Chakra Excel workbook, you must familiarize yourself with the following sheets:

Step 1: Setting Up the 17x17 Grid

Open a new Excel workbook. Select cells B2 to R18 (17 columns and 17 rows). Adjust row height and column width to form perfect squares (e.g., row height = 20, column width = 3).

Label the rows and columns with numbers 1 to 17. In Vedic tradition, the center (row 9, column 9) represents the "self" or the ascendant point. The chart has 12 spokes, each representing a zodiac sign

Step 1: Create a new Excel sheet

  • Open a new Excel workbook and create a new sheet.

2. The Input Dashboard

This is where the astrologer enters live data:

  • Date & Time (Converted to IST or Local Mean Time)
  • Latitude and Longitude
  • Chakra Type: Choose between "Prashna" (Question) or "Varshaphala" (Annual).

1. Color-Coded Directional Astrology

The Chakra is mapped to the 8 cardinal directions. Use Excel's conditional formatting to turn the North-East quadrant green (Ishanya—God’s zone) and the South-West quadrant red (Nairitya—demon zone).

Step 4: Write Excel Formulas for Coordinates

We need to get the Row and Column offset for each input. Use VLOOKUP or XLOOKUP against your conversion tables.

Example for Tithi: (Assume Tithi table in 'Lookups'!A:C with columns: TithiNum, RowOffset, ColOffset)

= XLOOKUP(B2, Lookups!A:A, Lookups!B:B)  → Store in C2 (Tithi Row Offset)
= XLOOKUP(B2, Lookups!A:A, Lookups!C:C)  → Store in D2 (Tithi Col Offset)

Repeat for Vara, Nakshatra, Karana, Yoga. You will have 5 row offsets and 5 col offsets.

Related Posts