Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This project is a web application designed for managing and updating an existing Excel spreadsheet focused on patient management and hospital bed availability. The application will allow users to make surgical and precise corrections to the spreadsheet without altering any existing functionalities or layouts, ensuring that all core features remain intact.

## CORE FEATURES
1. **Patient Information Management**: Automatically populate the Patient Board with essential patient details such as name, birth date, admission date, bed, and SES.
2. **Kanban Board Updates**: Refresh the Kanban board based on patient admissions and departures, displaying relevant information like SES, full name, admission date, and pending tasks.
3. **Stay Duration Calculation**: Automatically compute the duration of patient stays based on the current date and admission date, ensuring real-time updates.
4. **Bed Availability Tracking**: Monitor and display bed availability dynamically, indicating occupied and free beds and updating automatically upon patient admission or discharge.
5. **Age Calculation**: Revise age calculation formulas to accurately reflect the patient's age based on day, month, and year, while ensuring real-time updates.
6. **Data Protection**: Implement selective protection for formulas and automation, allowing manual data entry while preventing accidental formula changes.

## 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 application will feature a clean layout with a central navigation menu, sidebars for context-specific actions, and a main content area displaying dynamic boards and patient information.

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

## IMPLEMENTATION STEPS
1. **Set Up Project**: Initialize a new React project with TypeScript and install Tailwind CSS and shadcn/ui for UI components.
2. **Create Core Components**: Develop components for the Patient Board, Kanban Board, and Bed Availability Tracker, ensuring they are responsive and visually aligned with the design specifications.
3. **Implement State Management**: Use React Context API or Redux to manage the state across the application, focusing on patient data and bed availability.
4. **Integrate Excel Functionality**: Implement logic to read and update the Excel file as per the specified rules, ensuring that functionality remains intact and that only targeted updates are made.
5. **Apply Design Specifications**: Style the components according to the design guidelines provided, ensuring a minimalist aesthetic and adherence to the typography and color scheme.
6. **Testing and Validation**: Conduct thorough testing of all features to confirm that functionality works as intended, including tests for data integrity and automation.

## USER EXPERIENCE
Users will interact with the application through a straightforward interface that prominently displays patient information, bed availability, and Kanban updates. The central navigation will guide users to different sections with ease, while real-time updates ensure they have access to the most accurate information. Input fields will be clearly marked, and the protected areas will prevent accidental changes to critical formulas and functionalities, allowing users to focus on managing patient data effectively.