Vedic Astrology Excel Workbook

I want a single, self-contained Excel workbook that can automatically generate a Vedic horoscope while carrying out both birth-chart and transit-chart calculations. After the user enters date, time, and location, the sheet should compute planetary longitudes, house cusps, and full aspect tables, then display the results in a clear Option for the user for North-Indian or South-Indian style wheel (I am open to whichever is simpler in Excel). Essential elements to include • Horoscope generation that updates instantly from a single data-entry panel. • Birth-chart and real-time transit-chart computations. • Planet positions, twelve houses, full aspect matrix, plus KP-style Sub Lord and Sub-Sub Lord output. Technical expectations The workbook may rely on VBA, Power Query, or pure formulas—use whichever achieves accurate astronomical math and a smooth user experience. No external DLLs, paid plugins, or internet calls; everything must live inside the .xlsm file so it works offline. Deliverables 1. The finished Excel workbook with unlocked, well-commented code. 2. A short PDF or sheet inside the file explaining how to input data, refresh transits, and read the Sub Lord information. 3. A quick test case (sample birth details) so I can cross-check your calculations. Acceptance criteria • Planetary longitudes must match standard ephemeris values for the given date to within one arc-minute. • Sub Lord/Sub-Sub Lord output should align with KP ephemeris. • Workbook opens with no security or reference errors on Excel 2016 and later. If you’ve built similar astrological tools—or already have routines for planetary positions—let me know; that will speed the project considerably.

Project ID: 40400608