Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
The project is a **web application** designed to revise and correct an existing Excel file for managing patient data in a healthcare setting. The main purpose is to ensure that the specified changes are implemented without disrupting the existing functionalities of the spreadsheet, preserving all data layouts, formulas, and validations.

## CORE FEATURES
1. **Patient Board**: Automatically populated by the "Passagem de Plantão" with essential patient information (name, birth date, admission date, bed, SES) while maintaining original formatting.
   
2. **Kanban Board**: Automatically updates with key details (SES, name, sex, admission date, procedure, pending tasks, and length of stay) to visually manage patient flow without altering the existing layout.

3. **Length of Stay Calculation**: Automatically computes the length of stay based on the admission date and updates in real-time, ensuring accurate tracking.

4. **Discharge Forecasting**: Displays occupancy status with clear indicators for bed availability, always using uppercase letters and updating automatically.

5. **Age Calculation**: Revises existing formulas to calculate age accurately based on the full date format, ensuring automatic updates as the current date changes.

6. **Data Protection**: Ensures that formulas and automations remain intact while allowing specific fields to be editable, preventing accidental alterations.

## 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 consist of a top navigation bar, a hero section for key information, followed by sections for the Patient Board and Kanban Board. Each section will maintain a clear structure with adequate spacing and alignment.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript
- **Styling**: Tailwind CSS
- **UI Components**: shadcn/ui
- **State Management**: Use React Context or Redux for managing application state related to patient data and updates.

## IMPLEMENTATION STEPS
1. **Setup Project**: Initialize a new React project using Create React App with TypeScript. Install required packages for Tailwind CSS and shadcn/ui.
2. **Create Layout Components**: Develop the top navigation bar and main layout structure. Utilize Tailwind CSS for styling and responsiveness.
3. **Implement Patient Board**: Create a component that dynamically displays patient information based on the provided criteria and integrates with the existing Excel-like data structure.
4. **Develop Kanban Board**: Create a Kanban component that automatically pulls and displays the necessary patient details while ensuring the original layout is preserved.
5. **Integrate Calculations**: Add logic for length of stay and age calculations, ensuring they update in real-time based on the current date.
6. **Implement Data Protection**: Use form controls that allow editing of specific fields while protecting the integrity of formulas and automations in the background.
7. **Testing**: Conduct thorough testing to ensure that all functionalities work as intended and that no existing features are disrupted.

## USER EXPERIENCE
Key user interactions will involve viewing and managing patient data seamlessly through the Patient Board and Kanban. Users will be able to edit specific fields easily while the application manages the underlying calculations and data integrity. The interface will prioritize clarity and simplicity, allowing users to focus on patient management without unnecessary distractions.