Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
The application is a web app designed to streamline the process of uploading and managing Bill of Quantities (BOQ) for infrastructure piping works. Users can upload Excel sheets containing BOQ details and lists of equipment, which the application then analyzes to allocate equipment based on network depth and pipe types. The app also calculates and represents the working hours for each BOQ item, offering a comprehensive tool for project management in construction.

## CORE FEATURES
1. **Excel Upload Functionality**: Users can easily upload Excel sheets containing BOQ and equipment lists, with validation checks for data integrity.
2. **Equipment Allocation Engine**: The app processes the uploaded data to allocate equipment based on specified criteria such as network depth and pipe types.
3. **Working Hours Calculation**: Automatically calculates working hours required for each item in the BOQ based on equipment allocation and project parameters.
4. **Dynamic Reporting Dashboard**: Visualize and track the progress of the project with real-time updates on equipment allocation and working hours.
5. **User Authentication**: Secure login for users to manage their projects and access their uploaded data.
6. **Export Functionality**: Users can export reports in various formats (e.g., PDF, Excel) for further analysis and sharing.

## DESIGN SPECIFICATIONS
- **Visual Style**: minimalist - Clean, simple design with plenty of white space, minimal color palette, and focus on typography
- **Color Mode**: Light theme with dark text on light backgrounds
- **Primary Color**: #1978E5 (accent for buttons, links, highlights)
- **Typography**: Use Inter from Google Fonts for headings, Inter for body text and UI elements
- **Border Radius**: 8px (moderately rounded) for buttons, cards, and inputs
- **Layout**: The main layout should feature a sidebar for navigation, a header for quick access to actions, and a main content area displaying the dashboard, upload forms, and reports.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript
- **Styling**: Tailwind CSS
- **UI Components**: shadcn/ui
- **State Management**: Redux Toolkit (optional for state management)

## IMPLEMENTATION STEPS
1. **Set Up Project**: Initialize a new React project with TypeScript and install Tailwind CSS.
2. **Build Authentication Module**: Create a user authentication system, allowing users to sign up and log in.
3. **Develop Excel Upload Feature**: Implement functionality for uploading and parsing Excel files.
4. **Create Equipment Allocation Logic**: Develop the backend logic that processes uploaded data to allocate equipment.
5. **Implement Working Hours Calculation**: Write the algorithm that computes working hours based on the allocated equipment.
6. **Design the Dashboard**: Create components for the dashboard to display allocation results and working hours, using dynamic charts for visualization.
7. **Add Export Functionality**: Implement options to export reports in PDF and Excel formats.
8. **Test and Deploy**: Conduct thorough testing for usability and performance, then deploy the application.

## USER EXPERIENCE
Users will interact with a clean and intuitive interface where they can easily upload their BOQ and equipment files. Upon uploading, they will receive feedback on the data validity, and once processed, they can view the equipment allocation and working hours in a visually appealing dashboard. The authentication process ensures that users can securely access their data, while the export feature allows for convenient sharing of reports with stakeholders. The minimalist design ensures a clutter-free experience, focusing on the essential functions of the application.