FINALPROJECT_IKEZHAN

Surgery Scheduler

Efficient operating room management system that optimizes scheduling and resource allocation

Smart Optimization

Efficient scheduling algorithms organize surgeries based on type, duration, and time preferences to maximize operating room utilization.

Data Processing

The system processes surgery data from Excel files, validating inputs and organizing information for effective scheduling decisions.

Resource Allocation

Strategic assignment of operating rooms based on surgery type, duration, and availability to ensure optimal resource utilization.

Visual Scheduling

Interactive calendar interface displays schedules in an intuitive format, making it easy to view and manage operating room assignments.

01

Smart Data Processing

Our system works like a highly skilled medical assistant with a photographic memory. Here's how:

📋 Data Collection

We gather information from the uploaded Excel file:

👤

Patient Info
(Age, Name)

💉

Surgery Details
(Type, Duration)

⏱️

Time Preferences
(Morning/Afternoon)

⏱️ Duration Estimation

Our system uses historical data to estimate surgery durations:

📊

Historical Data

1000 case dataset

⚙️

Random Forest

Machine learning model

=

Duration Estimates

For scheduling efficiency

Features Used in Model:

Surgery Type

Categorized procedures

Patient Age

Risk factor calculation

Pre-op Metrics

Preparation times

Complexity Score

Case difficulty rating

Model Performance & Details:

📏 Error Metrics

Mean Absolute Error

~15 minutes

CV Score

0.76 ± 0.08

🧮 Baseline Calculation

Base Duration = Pre-op + Transfer + Anesthesia + Positioning

Machine learning predictions adjust this baseline

🔝 Top Duration Factors

Surgery Type

+40-120 min (varies)

Complexity Score

+5-30 min per point

Patient Age > 70

+10-15 min

Comorbidities

+5-20 min per condition

🎯 Priority Assignment

Our scheduling algorithm considers key factors:

👵

Patient Age

🔍

Surgery Type

Time Preference

📅

Room Availability

02

Intelligent Scheduling

Our system analyzes the input data to create an efficient surgery schedule:

📋

Data Validation

Input verification

➡️
⏱️

Time Allocation

Based on preferences

➡️
📊

Room Assignment

Optimized placement

03

Smart Scheduling

Our system organizes surgeries in a logical and efficient way:

🕒

Time-Based Grouping

Morning & afternoon slots

🏥

Room Assignment

Efficient distribution

📅

Calendar View

Visual scheduling

How It Works

🔧 System Design

Built with modern technology:

  • Fast backend API (FastAPI)
  • Responsive interface (React)
  • Interactive calendar view

📌 Key Features

What makes our system special:

  • Batch import from Excel
  • Time preference support
  • Visual calendar interface

Transforming Operating Room Management

The Surgery Scheduler streamlines the operating room scheduling process, helping hospitals optimize resources and improve patient care through efficient management.

⏱️

Reduced Wait Times

🏥

Optimized OR Usage

👨‍⚕️

Enhanced Patient Care

View Surgery Schedule →