Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This web application is designed to allow users to upload Excel sheets and extract specific data from designated columns across all tabs. The application will utilize Gemini prompts to calculate residual risk based on the retrieved data and display the results in a user-friendly interface.

## CORE FEATURES
1. **Excel Sheet Upload**: Users can easily upload Excel files from their local devices.
2. **Data Extraction**: The application will read through all tabs of the uploaded Excel sheet, focusing on specified columns (1-4) to gather necessary inputs.
3. **Gemini Prompt Integration**: Implement Gemini prompts that will process the extracted data to calculate residual risk.
4. **Results Display**: After processing, the application will showcase the calculated residual risk results on the screen in a clear and concise manner.
5. **Download Results**: Users can download the results in a user-friendly format (e.g., CSV or PDF).

## DESIGN SPECIFICATIONS
- **Visual Style**: Minimalist - Clean, simple design with ample white space, emphasizing clarity and ease of use.
- **Color Mode**: Light theme with dark text on light backgrounds for improved readability.
- **Layout**: 
  - **Header**: Contains the logo and navigation links.
  - **Hero Section**: A prominent call-to-action inviting users to upload their Excel sheets.
  - **Features Section**: Brief descriptions of core features.
  - **Results Section**: Area to display results after processing the uploaded file.
  - **Footer**: Contact information and links to terms and privacy policies.
- **Typography**: 
  - Primary Font: Arial or Helvetica for body text.
  - Headings: Use a larger, bold font size for headings to establish a clear hierarchy.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript for a robust and scalable application.
- **Styling**: Tailwind CSS for utility-first styling that ensures responsive design and quick adjustments.
- **UI Components**: Utilize shadcn/ui for pre-built components that align with the minimalist design.
- **State Management**: Consider using React Context or Redux if global state management is necessary for handling user data and results.

## IMPLEMENTATION STEPS
1. **Set Up Project**: Initialize a new React project with TypeScript and install Tailwind CSS and shadcn/ui.
2. **Create Components**: Develop the following components:
   - UploadComponent for Excel file uploads.
   - DataDisplayComponent for showcasing results.
   - Navbar for navigation links.
   - Footer for additional information.
3. **Implement File Upload Logic**: Integrate file reading capabilities to extract data from Excel sheets using a library like `xlsx`.
4. **Connect Gemini Prompts**: Set up the backend logic to run Gemini prompts against the extracted data and calculate residual risk.
5. **Display Results**: Create a responsive layout to accurately present the calculated results.
6. **User Authentication**: Implement user registration and login functionality to manage user data securely.
7. **Testing**: Thoroughly test the application for usability, responsiveness, and performance.
8. **Deployment**: Deploy the application to a cloud platform such as Vercel or Netlify for public access.

## USER EXPERIENCE
Users will have a seamless experience starting from the upload of their Excel sheets through an intuitive interface. Upon uploading, the application will promptly process the data, and users will be able to view the calculated residual risk results in a clean, organized manner. The ability to download results ensures that users can easily keep records of their analyses. The minimalist design will guide users through each step without distractions, enhancing overall engagement and satisfaction.