To work with this in Excel, you must first understand the layout. The chakra is an outer grid of 8x8. However, the actual path of Nakshatras follows a specific spiral starting from the second cell of the second row.
In Excel terms, here is the mapping (Row, Column):
To build this in Excel, you must understand the three layers that occupy the same grid.
To automatically display the Nakshatra type based on the birth Nakshatra (say in cell Z1), you would use:
=CHOOSE(MOD( (NakshatraNumber - 1 + Offset), 9 ) + 1, "Janma", "Sampat", "Vipat", "Kshema", "Pratyari", "Sadhaka", "Vadha", "Mitra", "Param Mitra")
To work with this in Excel, you must first understand the layout. The chakra is an outer grid of 8x8. However, the actual path of Nakshatras follows a specific spiral starting from the second cell of the second row.
In Excel terms, here is the mapping (Row, Column): sarvatobhadra+chakra+in+excel+format+link
To build this in Excel, you must understand the three layers that occupy the same grid. To work with this in Excel, you must
To automatically display the Nakshatra type based on the birth Nakshatra (say in cell Z1), you would use: To work with this in Excel
=CHOOSE(MOD( (NakshatraNumber - 1 + Offset), 9 ) + 1, "Janma", "Sampat", "Vipat", "Kshema", "Pratyari", "Sadhaka", "Vadha", "Mitra", "Param Mitra")