System Requirements Document (SRD)

1. Introduction

This document outlines the requirements for a system that generates an Excel sheet to calculate time durations for celestial cycles based on planetary years. The system will allow users to input planetary years and compute the time required to complete cycles for zodiac signs, nakshatras, nakshatra charans, and degrees. Additionally, the system will provide functionality to adjust calculations based on the user's date of birth (DOB). The goal is to provide an automated and user-friendly solution for astrological calculations with DOB-based adjustments. The system will also include functionality to provide a downloadable Excel template for celestial cycle calculations, including formulas for DOB-based adjustments.

2. System Overview

The system will be a web-based application where users can input planetary years and their date of birth to receive an Excel sheet with calculated results. The calculations will include:

• Time taken by planets to complete one cycle of 12 zodiac signs.
• Time taken to complete one zodiac sign.
• Time taken to complete one nakshatra.
• Time taken to complete one nakshatra charan.
• Time taken to complete one degree.
• Adjustments based on the user's date of birth to provide personalized insights.
• A downloadable Excel template with pre-configured formulas for celestial cycle calculations, including DOB-based adjustments.

The system will use formulas and logic to perform these calculations dynamically and export the results into an Excel sheet. The DOB-based adjustments will allow users to view calculations specific to their age and celestial alignment. Additionally, users will have access to a downloadable Excel template for manual data entry and calculations.

3. Functional Requirements as Story Points

• As User I should be able to input planetary years for celestial bodies (e.g., Surya, Moon, Mars, Mercury, Jupiter, Venus, Saturn, Rahu, and Ketu).
• As User I should be able to input my date of birth to adjust celestial cycle calculations.
• As User I should be able to calculate the time taken by celestial bodies to complete one cycle of 12 zodiac signs.
• As User I should be able to calculate the time taken to complete one zodiac sign.
• As User I should be able to calculate the time taken to complete one nakshatra.
• As User I should be able to calculate the time taken to complete one nakshatra charan.
• As User I should be able to calculate the time taken to complete one degree.
• As User I should be able to view calculations dynamically based on the input planetary years and DOB adjustments.
• As User I should be able to export the calculated results into an Excel sheet.
• As User I should be able to download a pre-configured Excel template for celestial cycle calculations.
• As User I should be able to adjust celestial cycle calculations based on my age derived from my date of birth.
• As User I should be able to calculate the next celestial cycle completion date for each planet based on my date of birth.

4. User Personas

4.1 Astrologer

• Description: A professional astrologer who uses the system to perform complex celestial calculations for clients.
• Needs: Accurate and detailed calculations for celestial cycles, including DOB-based adjustments.
• Goals: To save time and ensure precision in astrological computations.

4.2 Enthusiast

• Description: An astrology enthusiast who uses the system for personal learning and exploration.
• Needs: Easy-to-use interface and clear explanations of calculations, including personalized DOB-based insights.
• Goals: To understand celestial cycles and their implications.

4.3 Researcher

• Description: A researcher studying celestial movements and their effects.
• Needs: Reliable data and export functionality for further analysis, including DOB-based adjustments for specific case studies.
• Goals: To gather insights and validate theories.

4.4 Individual User

• Description: A person interested in understanding celestial cycles based on their own date of birth.
• Needs: Personalized calculations and insights based on DOB.
• Goals: To explore how celestial cycles align with their personal astrological profile.

4.5 Excel User

• Description: A user who prefers manual data entry and calculations using Excel templates.
• Needs: A downloadable Excel template with pre-configured formulas for celestial cycle calculations, including DOB-based adjustments.
• Goals: To manually input data and perform calculations offline.

5. Visuals Colors and Theme

The system will use a celestial-themed color palette to align with the astrological context:

• Primary Color: Midnight Blue (#191970) - Represents the night sky.
• Secondary Color: Gold (#FFD700) - Represents celestial bodies like stars and planets.
• Accent Color: Silver (#C0C0C0) - Represents the moon and other reflective celestial objects.
• Background Color: Deep Space Black (#000000) - Provides a clean and immersive backdrop.
• Highlight Color: Cosmic Purple (#800080) - Used for DOB-related adjustments and personalized insights.

6. Non-Functional Requirements

• Performance: The system should generate Excel sheets within 2 seconds of input submission.
• Scalability: The system should handle up to 10,000 planetary year inputs and DOB entries without performance degradation.
• Usability: The interface should be intuitive and require minimal training for users.
• Reliability: The calculations should be accurate to the nearest decimal point.
• Security: User data, including DOB, should be encrypted during input and export processes.
• Compatibility: The exported Excel sheet should be compatible with all major spreadsheet software (e.g., Microsoft Excel, Google Sheets).
• Accessibility: The downloadable Excel template should be easy to access and include pre-configured formulas for celestial cycle calculations.

7. Tech Stack

Frontend

• React for Web: To create a dynamic and responsive user interface.

Backend

• Python: For implementing calculation logic.
• FastAPI: To handle API requests and responses.

Database RDBMS

• MySQL: To store planetary year inputs, DOB entries, and calculation history.
• Alembic: For database migrations.

AI Models

• GPT 5.2: For user-friendly responses and explanations of calculations.

AI Tools

• Langchain: To manage complex workflows and integrate AI functionalities.

Local Orchestration

• Docker: To containerize the application for easy deployment.
• Docker-compose: To manage multi-container setups.

Server-side Orchestration

• Kubernetes: To ensure scalability and reliability of the application.

8. Assumptions and Constraints

Assumptions

• Users have basic knowledge of celestial cycles and planetary years.
• The system will primarily be used for astrological purposes.
• Users will input planetary years and DOB in a consistent format (e.g., integers or decimals for years, and YYYY-MM-DD for DOB).
• Users may prefer manual calculations using a downloadable Excel template.

Constraints

• The system will only support calculations for the provided celestial bodies (Surya, Moon, Mars, Mercury, Jupiter, Venus, Saturn, Rahu, and Ketu).
• The calculations are based on fixed formulas and do not account for variations in celestial movements.
• DOB adjustments will be limited to aligning celestial cycles with the user's age and astrological profile.
• The downloadable Excel template will include pre-configured formulas but will not dynamically update based on external inputs.

9. Glossary

• Celestial Cycle: The time taken by a celestial body to complete one full rotation through the zodiac signs.
• Zodiac Sign: One of the 12 divisions of the celestial sphere.
• Nakshatra: A lunar mansion or segment of the zodiac.
• Nakshatra Charan: A subdivision of a nakshatra.
• Degree: A unit of measurement used in celestial calculations.
• Planetary Years: The time taken by a celestial body to complete one orbit around the sun.
• Date of Birth (DOB): The user's birth date used to adjust celestial cycle calculations.
• Excel Template: A downloadable spreadsheet with pre-configured formulas for celestial cycle calculations.

10. DOB-Based Adjustment Formulas

To adjust calculations based on the user's date of birth, the following formulas can be implemented in Excel:

1. Time per Rashi:
   Formula: =Planetary Years/12
   Example for Surya: =19/12

2. Time per Nakshatra:
   Formula: =Time per Rashi/27
   Example for Moon: =(16/12)/27

3. Time per Charan:
   Formula: =Time per Nakshatra/4
   Example for Mars: =((28/12)/27)/4

4. Time per Degree:
   Formula: =Time per Rashi/30
   Example for Mercury: =(10/12)/30

5. Next Cycle Completion Date:
   Formula: =EDATE(DOB, Planetary Years * 12)
   Example for Jupiter: =EDATE(DOB, 12 * 12)
   This calculates the next cycle completion date for each planet based on the user's DOB.

These formulas can be directly implemented in Excel to provide dynamic and personalized celestial cycle calculations.