Excel Astrology Chart Generator

I want to roll all of my routine astrological calculations into a single, self-contained Excel workbook. The sheet should take three simple inputs—date, time (with seconds), and place of birth (latitude, longitude, time-zone)—and instantly produce both North Indian and South Indian style charts.

From the same data I need full dasha tables for Vimshottari, Ashtottari and Yogini right up to 120 years, each showing start/end dates and running lords. Under KP rules the workbook must list, for every house, the cusp details, occupying planets and ruling lords, followed by the final CSL significations in one clear matrix. A short section should also flag common yogas (basic Raja, Dhana, Kemadruma, etc.) as simply “Yes/No”.

I am happy for you to use VBA, Office-JS or embedded Python for the heavy maths, but the interface and final outputs must live in Excel so I can copy, filter or print without extra software. Please drive the calculations from a recognised ephemeris such as Swiss-Ephemeris and note the version you integrate.

Deliverables
• Unlocked .xlsm workbook with formulas/VBA cleanly commented
• Read-me explaining input format, ephemeris source and any settings
• Sample output for one test chart for verification

Acceptance criteria
• Planetary longitudes match Swiss-Ephemeris to ±1″ arc
• Dasha periods replicate standard KP tables
• KP significator list correctly reflects cusps, planets and lords for all 12 houses
• Both chart styles render cleanly when printed on A4