Vedic Astrology Excel Workbook

I need a single-file Excel workbook that performs core Vedic astrology calculations and produces clear, ready-to-read results. The primary focus is on two functions: accurate birth chart generation and reliable horoscope predictions. All computations must follow the Vedic system—sidereal zodiac, traditional house calculations, and the standard planetary periods (dashas).

Structure & flow I have in mind
• One clean input sheet where a user types birth date, time, and location (latitude, longitude, time-zone).
• Behind the scenes, formulas or VBA code convert that data into planetary longitudes, house cusps, divisional charts as needed, and then render the main Rāshi chart visibly on a results sheet.
• A second results section produces daily, weekly, and monthly prediction text that draws on those planetary positions. I am comfortable if you hard-code a concise rule set for the predictions to keep the scope manageable.

Acceptance criteria
• Birth chart matches trusted Vedic software to within ±1 arc-minute for planet positions.
• Workbook runs without external add-ins; all code is self-contained (Excel 2016+ compatible).
• No locked sheets—formulas and VBA remain viewable for future edits.
• A short “How it works” tab explains input fields, calculation logic, and where to add or edit prediction rules.

Please build with clarity and speed in mind: lean formulas, well-commented VBA, and tidy formatting. Once done, provide the .xlsx (or .xlsm) file along with any auxiliary documentation so I can test the results straight away.