MEDI PALET LINKs

• 

  Main screen

• 

• 

• 

• 

• 

Medication-order preparation in a hospital can require staff to cross-reference treatment schedules, medication strengths, and supply information across multiple spreadsheets. I built MEDI PALET LINKs to bring those daily checks into one desktop application.

The app imports adopted medicines, regimens, treatment schedules, and operational tasks from existing Excel workbooks and manages them in SQLite. It calculates required quantities from scheduled administrations and medication strengths, and provides dashboard, calendar, and supply-alert views for daily review. It also includes integrity checks and automatic/manual backup.

MEDI PALET LINKs does not diagnose, prescribe, determine whether medication administration is appropriate, or make any clinical decision. This initial version is a single-PC application for organizing, reviewing, and preparing operational information.

I used Codex to organize the existing workflow, design the data model, implement Excel import, order calculations, tests, and UI improvements. I used GPT-5.6 to compare implementation options and identify edge cases and test scenarios. The README documents setup and reproducible fictional demo data.

Built With

• codex
• gpt-5.6
• openpyxl
• pyside6
• python
• sqlite