Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This application is a web app designed to facilitate the mapping of Bill of Quantities (BOQ) serials to material codes for piping works by allowing users to upload Excel sheets containing data. The app will extract relevant information, match it with purchase orders, and provide the ability to export results back into an Excel sheet. This streamlined process enhances efficiency in managing and pricing materials.

## CORE FEATURES
1. **Data Upload**: Users can upload Excel sheets containing BOQ serials and material codes.
2. **Data Mapping**: The application performs mapping between BOQ serials and material codes to retrieve prices based on description, diameter, and material type.
3. **Price Calculation**: Automatically calculates and displays BOQ prices from the purchase orders.
4. **Export Functionality**: Allows users to export the resulting data back to an Excel file for their records.
5. **User Authentication**: Secure login for users to manage their data and access features.
6. **Dashboard Overview**: A user-friendly dashboard to view uploaded data, mappings, and calculated prices.

## 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 will feature a header with the app title, a sidebar for navigation, a central content area for data upload and mapping features, and a footer with contact information.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript
- **Styling**: Tailwind CSS
- **UI Components**: shadcn/ui
- **State Management**: React Context or Redux (if needed for larger state management)

## IMPLEMENTATION STEPS
1. **Set Up the Project**: Initialize a new React project with TypeScript and install necessary dependencies (e.g., Tailwind CSS, shadcn/ui).
2. **Create Authentication**: Implement user authentication to allow users to log in and manage their data securely.
3. **Build Upload Functionality**: Create a component for uploading Excel files and parsing the data.
4. **Implement Mapping Logic**: Develop the logic to match BOQ serials with material codes and retrieve prices.
5. **Create Dashboard**: Design and implement a dashboard to display uploaded data, mappings, and calculated prices.
6. **Export Functionality**: Implement the feature to export the processed data back to an Excel file.
7. **Styling**: Apply Tailwind CSS styles based on the design specifications for a clean and minimalist look.

## USER EXPERIENCE
Users will begin by logging in to their accounts. Once authenticated, they can navigate to the upload section to select and upload their Excel files. After uploading, they will see a progress indicator as the app processes the data. Users can then view the results of the mapping and pricing calculations on the dashboard. Finally, they can export the results to an Excel file for further use. The overall experience emphasizes simplicity and efficiency to enhance user satisfaction.