Project Description
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.