hypertension diabetes mellitus management guidelines

appendicitis surgical management outcomes

preeclampsia obstetric complications management

neonatal jaundice management paediatrics

tuberculosis diagnosis treatment guidelines

postpartum hemorrhage prevention management

mkdir -p /home/daytona/workspace/block-exam-prep && ls /home/daytona/workspace/b…

~/block-exam-prep/create_tracker.py

from openpyxl import Workbook
from openpyxl.styles import (Font, PatternFill, Alignment, Border, Side,
                              GradientFill)
from openpyxl.utils import get_column_letter
from openpyxl.formatting.rule import DataBarRule, ColorScaleRule, CellIsRule, FormulaRule
from openpyxl.styles.differential import DifferentialStyle
from openpyxl.formatting.rule import Rule
import io

wb = Workbook()

# ─────────────────────────────────────────────
# HELPERS
# ─────────────────────────────────────────────
def hex_fill(hex_color):
    return PatternFill("solid", start_color=hex_color, fgColor=hex_color)

def thin_border():
    s = Side(style='thin', color='BBBBBB')
    return Border(left=s, right=s, top=s, bottom=s)

def bold_font(size=11, color='000000'):
    return Font(name='Arial', bold=True, size=size, color=color)

def reg_font(size=10, color='000000'):
    return Font(name='Arial', size=size, color=color)

def center():
    return Alignment(horizontal='center', vertical='center', wrap_text=True)

def left():
    return Alignment(horizontal='left', vertical='center', wrap_text=True)

# Color palette
COL_HEADER_DARK   = '1F3864'   # dark navy  – sheet headers
COL_SUBJECT_SURG  = '2E75B6'   # blue       – Surgery
COL_SUBJECT_GYN   = 'C55A11'   # orange     – Gynae & Obs
COL_SUBJECT_PED   = '375623'   # dark green – Paediatrics
COL_SUBJECT_MED   = '7030A0'   # purple     – Medicine
COL_WEEKEND_BG    = 'F2F2F2'   # light grey – weekend row
COL_DONE          = 'E2EFDA'   # soft green – completed
COL_PARTIAL       = 'FFF2CC'   # soft yellow– partial
COL_NOT_DONE      = 'FCE4D6'   # soft red   – not done
COL_ROW_ALT       = 'EEF3FB'   # alt row bg
WHITE             = 'FFFFFF'

SUBJECT_COLORS = {
    'Surgery':       COL_SUBJECT_SURG,
    'Gynae & Obs':   COL_SUBJECT_GYN,
    'Paediatrics':   COL_SUBJECT_PED,
    'Medicine':      COL_SUBJECT_MED,
}

# ─────────────────────────────────────────────
# SHEET 1 : DAILY TRACKER
# ─────────────────────────────────────────────
ws = wb.active
ws.title = "📅 Daily Tracker"
ws.sheet_view.showGridLines = False
ws.freeze_panes = 'A5'   # freeze top 4 rows

# --- Title row ---
ws.merge_cells('A1:K1')
ws['A1'] = '🎓  BLOCK EXAM STUDY TRACKER  |  Exam: 3 August 2026'
ws['A1'].font = Font(name='Arial', bold=True, size=16, color=WHITE)
ws['A1'].fill = hex_fill(COL_HEADER_DARK)
ws['A1'].alignment = center()
ws.row_dimensions[1].height = 36

# --- Subtitle row ---
ws.merge_cells('A2:K2')
ws['A2'] = 'Subjects: Surgery  •  Gynae & Obs  •  Paediatrics  •  Medicine'
ws['A2'].font = Font(name='Arial', size=11, color='D9E1F2')
ws['A2'].fill = hex_fill('2F528F')
ws['A2'].alignment = center()
ws.row_dimensions[2].height = 22

# row 3 spacer
ws.row_dimensions[3].height = 6
ws.merge_cells('A3:K3')
ws['A3'].fill = hex_fill('D9E1F2')

# --- Column headers row 4 ---
headers = ['Date', 'Day', 'Subject', 'Topics to Cover', 'Hours\nPlanned',
           'Hours\nActual', 'Status\n(✅/🔄/❌)', 'Confidence\n(1-5)',
           'Notes / Doubts', 'MCQs\nDone?', 'Revision\nDone?']
col_widths = [13, 10, 14, 42, 9, 9, 12, 12, 34, 10, 12]

for col_idx, (h, w) in enumerate(zip(headers, col_widths), start=1):
    cell = ws.cell(row=4, column=col_idx, value=h)
    cell.font = bold_font(10, WHITE)
    cell.fill = hex_fill(COL_HEADER_DARK)
    cell.alignment = center()
    cell.border = thin_border()
    ws.column_dimensions[get_column_letter(col_idx)].width = w
ws.row_dimensions[4].height = 30

# ── Schedule data ──────────────────────────────────────────────────────────
schedule = [
    # (date_str, day_str, subject, topics, hrs_planned, day_type)
    # day_type: 'weekday' | 'weekend'
    ('12 Jul', 'Sun',  'Surgery',     'GI Surgery: Appendicitis, Intestinal Obstruction', 4.5, 'weekend'),
    ('13 Jul', 'Mon',  'Surgery',     'Hernias, Peritonitis, Acute Abdomen',               8.5, 'weekday'),
    ('14 Jul', 'Tue',  'Surgery',     'Breast Surgery, Thyroid & Parathyroid',              8.5, 'weekday'),
    ('15 Jul', 'Wed',  'Surgery',     'Fluids & Electrolytes, Burns, Trauma',               8.5, 'weekday'),
    ('16 Jul', 'Thu',  'Surgery',     'Urology (BPH, Renal Calculi) + Surgery MCQ Practice',8.5,'weekday'),
    ('17 Jul', 'Fri',  'Surgery',     'Surgery Rapid Revision + Short Notes',               8.5, 'weekday'),
    ('18 Jul', 'Sat',  'Surgery',     'Surgery Revision (Pending Topics)',                  4.5, 'weekend'),
    ('19 Jul', 'Sun',  'Gynae & Obs', 'Obstetrics: Normal Pregnancy, ANC, Partograph',      4.5, 'weekend'),
    ('20 Jul', 'Mon',  'Gynae & Obs', 'Obstetrics: Labour, Delivery, Puerperium',           8.5, 'weekday'),
    ('21 Jul', 'Tue',  'Gynae & Obs', 'Obs Complications: APH, PPH, Pre-eclampsia',         8.5, 'weekday'),
    ('22 Jul', 'Wed',  'Gynae & Obs', 'Ectopic Pregnancy, Abortion, Molar Pregnancy',       8.5, 'weekday'),
    ('23 Jul', 'Thu',  'Gynae & Obs', 'Gynaecology: PCOS, Fibroids, Endometriosis',         8.5, 'weekday'),
    ('24 Jul', 'Fri',  'Gynae & Obs', 'Gynaecology: Cancers (Cx, Endo, Ovary), Contraception',8.5,'weekday'),
    ('25 Jul', 'Sat',  'Gynae & Obs', 'Gynae & Obs Full Revision + MCQs',                   4.5, 'weekend'),
    ('26 Jul', 'Sun',  'Paediatrics', 'Neonatology: NNJ, Birth Asphyxia, RDS, NEC',         4.5, 'weekend'),
    ('27 Jul', 'Mon',  'Paediatrics', 'Growth & Development, Nutrition (PEM, Vit def.)',     8.5, 'weekday'),
    ('28 Jul', 'Tue',  'Paediatrics', 'Paediatric Infections: Measles, Mumps, Polio, Pertussis',8.5,'weekday'),
    ('29 Jul', 'Wed',  'Paediatrics', 'Immunisation Schedule, Respiratory + GI Diseases',   8.5, 'weekday'),
    ('30 Jul', 'Thu',  'Paediatrics', 'Paediatrics Rapid Revision + MCQ Practice',           8.5, 'weekday'),
    ('31 Jul', 'Fri',  'Medicine',    'Medicine: CVS (HTN, IHD, Heart Failure, Arrhythmias)',8.5,'weekday'),
    ('1 Aug',  'Sat',  'Medicine',    'Medicine: Respiratory (TB, Asthma, COPD, Pneumonia)', 4.5, 'weekend'),
    ('2 Aug',  'Sun',  'Medicine',    'FINAL REVISION – All subjects, High-yield MCQs, Short Notes ONLY',4.0,'weekend'),
]

for row_num, (date, day, subject, topics, hrs_plan, day_type) in enumerate(schedule, start=5):
    r = row_num
    is_weekend = day_type == 'weekend'
    is_final   = date == '2 Aug'

    # Row BG
    if is_final:
        row_bg = 'FFE699'
    elif is_weekend:
        row_bg = 'F2F2F2'
    else:
        row_bg = WHITE if (row_num % 2 == 1) else COL_ROW_ALT

    # subj color
    subj_color = SUBJECT_COLORS.get(subject, '4472C4')

    cells_data = [date, day, subject, topics, hrs_plan, '', '', '', '', 'No', 'No']
    for col_idx, val in enumerate(cells_data, start=1):
        cell = ws.cell(row=r, column=col_idx, value=val)
        cell.border = thin_border()
        cell.font = reg_font(10)
        cell.fill = hex_fill(row_bg)

        if col_idx == 1:   # date
            cell.font = bold_font(10)
            cell.alignment = center()
        elif col_idx == 2: # day
            cell.alignment = center()
            if is_weekend:
                cell.font = Font(name='Arial', size=10, bold=True, color='C00000')
        elif col_idx == 3: # subject
            cell.font = Font(name='Arial', size=10, bold=True, color=WHITE)
            cell.fill = hex_fill(subj_color)
            cell.alignment = center()
        elif col_idx == 4: # topics
            cell.alignment = left()
        elif col_idx in (5, 6, 7, 8, 10, 11):
            cell.alignment = center()
        elif col_idx == 9:
            cell.alignment = left()

    ws.row_dimensions[r].height = 28

# ── Data validation dropdowns ──
from openpyxl.worksheet.datavalidation import DataValidation

# Status dropdown  G5:G26
dv_status = DataValidation(type="list", formula1='"✅ Done,🔄 Partial,❌ Not Done"', allow_blank=True)
dv_status.sqref = f'G5:G{4+len(schedule)}'
ws.add_data_validation(dv_status)

# Confidence 1-5  H5:H26
dv_conf = DataValidation(type="list", formula1='"1,2,3,4,5"', allow_blank=True)
dv_conf.sqref = f'H5:H{4+len(schedule)}'
ws.add_data_validation(dv_conf)

# MCQ done J, Revision done K
dv_yn = DataValidation(type="list", formula1='"Yes,No,Partial"', allow_blank=True)
dv_yn.sqref = f'J5:K{4+len(schedule)}'
ws.add_data_validation(dv_yn)

# ── Conditional formatting: Status column ──
last_data_row = 4 + len(schedule)
# Done → green
ws.conditional_formatting.add(
    f'G5:G{last_data_row}',
    CellIsRule(operator='equal', formula=['"✅ Done"'],
               fill=hex_fill(COL_DONE))
)
# Partial → yellow
ws.conditional_formatting.add(
    f'G5:G{last_data_row}',
    CellIsRule(operator='equal', formula=['"🔄 Partial"'],
               fill=hex_fill(COL_PARTIAL))
)
# Not Done → red
ws.conditional_formatting.add(
    f'G5:G{last_data_row}',
    CellIsRule(operator='equal', formula=['"❌ Not Done"'],
               fill=hex_fill(COL_NOT_DONE))
)

# ── Summary strip at bottom ──
summary_row = last_data_row + 2
ws.merge_cells(f'A{summary_row}:C{summary_row}')
ws.cell(summary_row, 1, '📊 PROGRESS SUMMARY').font = bold_font(11, WHITE)
ws.cell(summary_row, 1).fill = hex_fill(COL_HEADER_DARK)
ws.cell(summary_row, 1).alignment = center()

labels = ['Days Done', 'Days Partial', 'Days Not Done', 'Days Remaining',
          'Total Planned Hrs', 'Total Actual Hrs']
formulas = [
    f'=COUNTIF(G5:G{last_data_row},"✅ Done")',
    f'=COUNTIF(G5:G{last_data_row},"🔄 Partial")',
    f'=COUNTIF(G5:G{last_data_row},"❌ Not Done")',
    f'={len(schedule)}-COUNTIF(G5:G{last_data_row},"✅ Done")-COUNTIF(G5:G{last_data_row},"🔄 Partial")',
    f'=SUM(E5:E{last_data_row})',
    f'=SUM(F5:F{last_data_row})',
]
for i, (lbl, frm) in enumerate(zip(labels, formulas)):
    col_lbl = 4 + i*2 - 1   # D, F, H, J ...
    col_val = col_lbl + 1
    lbl_cell = ws.cell(summary_row, col_lbl, lbl)
    lbl_cell.font = bold_font(10, COL_HEADER_DARK)
    lbl_cell.fill = hex_fill('D9E1F2')
    lbl_cell.alignment = center()
    lbl_cell.border = thin_border()

    val_cell = ws.cell(summary_row, col_val, frm)
    val_cell.font = bold_font(12, '1F3864')
    val_cell.fill = hex_fill('EEF3FB')
    val_cell.alignment = center()
    val_cell.border = thin_border()

ws.row_dimensions[summary_row].height = 28

# ─────────────────────────────────────────────
# SHEET 2 : SUBJECT BREAKDOWN
# ─────────────────────────────────────────────
ws2 = wb.create_sheet("📚 Subject Breakdown")
ws2.sheet_view.showGridLines = False

ws2.merge_cells('A1:G1')
ws2['A1'] = 'SUBJECT-WISE TOPIC BREAKDOWN & PROGRESS'
ws2['A1'].font = bold_font(14, WHITE)
ws2['A1'].fill = hex_fill(COL_HEADER_DARK)
ws2['A1'].alignment = center()
ws2.row_dimensions[1].height = 32

subj_data = {
    'Surgery': [
        ('Appendicitis & Acute Abdomen', 'High'),
        ('Intestinal Obstruction', 'High'),
        ('Hernia (Inguinal, Femoral)', 'High'),
        ('Peritonitis', 'Medium'),
        ('Breast (Carcinoma, Fibroadenoma)', 'High'),
        ('Thyroid & Parathyroid Surgery', 'High'),
        ('Fluids & Electrolytes', 'High'),
        ('Burns – Rule of 9s, Management', 'High'),
        ('Trauma – ATLS principles', 'Medium'),
        ('BPH & Renal Calculi (Urology)', 'Medium'),
    ],
    'Gynae & Obs': [
        ('Normal Pregnancy & ANC', 'High'),
        ('Normal Labour & Partograph', 'High'),
        ('Antepartum Haemorrhage (APH)', 'High'),
        ('Postpartum Haemorrhage (PPH)', 'High'),
        ('Pre-eclampsia & Eclampsia', 'High'),
        ('Ectopic Pregnancy', 'High'),
        ('Abortion Types & Management', 'High'),
        ('Molar Pregnancy', 'Medium'),
        ('PCOS', 'High'),
        ('Fibroids & Endometriosis', 'High'),
        ('Gynaecological Cancers', 'High'),
        ('Contraception', 'Medium'),
    ],
    'Paediatrics': [
        ('Neonatal Jaundice', 'High'),
        ('Birth Asphyxia & Neonatal Resuscitation', 'High'),
        ('Respiratory Distress Syndrome (RDS)', 'High'),
        ('Growth & Development Milestones', 'High'),
        ('Protein Energy Malnutrition (PEM)', 'High'),
        ('Vitamin Deficiencies', 'Medium'),
        ('Immunisation Schedule', 'High'),
        ('Measles, Mumps, Rubella', 'High'),
        ('Polio & Pertussis', 'Medium'),
        ('Paediatric Respiratory Diseases', 'Medium'),
        ('Paediatric GI Diseases', 'Medium'),
    ],
    'Medicine': [
        ('Hypertension', 'High'),
        ('Ischaemic Heart Disease (IHD)', 'High'),
        ('Heart Failure', 'High'),
        ('Arrhythmias', 'High'),
        ('Asthma & COPD', 'High'),
        ('Tuberculosis (TB)', 'High'),
        ('Pneumonia', 'High'),
        ('Diabetes Mellitus (T1 & T2)', 'High'),
        ('Thyroid Disorders', 'High'),
        ('Acute Kidney Injury (AKI)', 'High'),
        ('Chronic Kidney Disease (CKD)', 'High'),
        ('Nephrotic & Nephritic Syndrome', 'High'),
        ('Liver Diseases (Cirrhosis, Hepatitis)', 'High'),
        ('Anaemia (Iron def., B12, Haemolytic)', 'High'),
        ('Malaria, Dengue, Typhoid', 'High'),
        ('Stroke & Epilepsy', 'Medium'),
    ],
}

cur_row = 3
for subj, topics_list in subj_data.items():
    # Subject header
    ws2.merge_cells(f'A{cur_row}:G{cur_row}')
    hdr = ws2.cell(cur_row, 1, f'  {subj.upper()}')
    hdr.font = bold_font(12, WHITE)
    hdr.fill = hex_fill(SUBJECT_COLORS[subj])
    hdr.alignment = left()
    ws2.row_dimensions[cur_row].height = 26
    cur_row += 1

    # Column sub-headers
    col_hdrs = ['#', 'Topic', 'Priority', 'Status', 'Confidence (1-5)', 'Notes', 'Revision Date']
    col_ws   = [5, 38, 10, 14, 16, 30, 14]
    for ci, (ch, cw) in enumerate(zip(col_hdrs, col_ws), start=1):
        c = ws2.cell(cur_row, ci, ch)
        c.font = bold_font(9, WHITE)
        c.fill = hex_fill('2F528F')
        c.alignment = center()
        c.border = thin_border()
        ws2.column_dimensions[get_column_letter(ci)].width = cw
    ws2.row_dimensions[cur_row].height = 22
    cur_row += 1

    for ti, (topic, priority) in enumerate(topics_list, start=1):
        row_bg = WHITE if ti % 2 == 1 else COL_ROW_ALT
        vals = [ti, topic, priority, '', '', '', '']
        for ci, val in enumerate(vals, start=1):
            c = ws2.cell(cur_row, ci, val)
            c.font = reg_font(10)
            c.fill = hex_fill(row_bg)
            c.border = thin_border()
            c.alignment = center() if ci in (1, 3, 4, 5, 7) else left()
        # Priority color
        prio_cell = ws2.cell(cur_row, 3)
        if priority == 'High':
            prio_cell.font = Font(name='Arial', size=10, bold=True, color='C00000')
        else:
            prio_cell.font = Font(name='Arial', size=10, bold=True, color='7030A0')
        ws2.row_dimensions[cur_row].height = 22
        cur_row += 1

    # DV for status col in this subject block
    dv_s2 = DataValidation(type="list", formula1='"✅ Done,🔄 Partial,❌ Not Done"', allow_blank=True)
    dv_s2.sqref = f'D{cur_row - len(topics_list)}:D{cur_row - 1}'
    ws2.add_data_validation(dv_s2)

    cur_row += 1  # spacer

# ─────────────────────────────────────────────
# SHEET 3 : HIGH-YIELD PUBMED PAPERS
# ─────────────────────────────────────────────
ws3 = wb.create_sheet("🔬 PubMed Papers")
ws3.sheet_view.showGridLines = False

ws3.merge_cells('A1:F1')
ws3['A1'] = 'HIGH-YIELD RECENT PubMed PAPERS (2023-2026)  |  For Block Exam Preparation'
ws3['A1'].font = bold_font(13, WHITE)
ws3['A1'].fill = hex_fill(COL_HEADER_DARK)
ws3['A1'].alignment = center()
ws3.row_dimensions[1].height = 30

ws3.merge_cells('A2:F2')
ws3['A2'] = 'Use these papers to understand current management guidelines and update exam answers with recent evidence.'
ws3['A2'].font = Font(name='Arial', size=10, italic=True, color='2F528F')
ws3['A2'].fill = hex_fill('D9E1F2')
ws3['A2'].alignment = center()
ws3.row_dimensions[2].height = 20

phdrs = ['Subject', 'PMID', 'Year', 'Title', 'Journal', 'Key Takeaway for Exam']
phdr_w = [14, 10, 6, 58, 22, 48]
for ci, (h, w) in enumerate(zip(phdrs, phdr_w), start=1):
    c = ws3.cell(3, ci, h)
    c.font = bold_font(10, WHITE)
    c.fill = hex_fill('2F528F')
    c.alignment = center()
    c.border = thin_border()
    ws3.column_dimensions[get_column_letter(ci)].width = w
ws3.row_dimensions[3].height = 24

papers = [
    ('Medicine', '37793979', '2023',
     '2023 Clinical Practice Guidelines for Diabetes Mellitus (Korean Diabetes Association)',
     'Diabetes Metab J',
     'Updated DM targets: HbA1c <6.5-7%, individualized BP & lipid goals; GLP-1RA/SGLT2i for CVD risk'),
    ('Medicine', '40840485', '2026',
     'A clinical practice guideline for tuberculous meningitis',
     'Lancet Infect Dis',
     'TB meningitis: dexamethasone adjunct, longer ATT duration, CSF findings – high-yield for Medicine'),
    ('Surgery', '37914953', '2023',
     'Diagnosis and treatment of appendicitis: systematic review and meta-analysis',
     'Surg Endosc',
     'Alvarado score, CT vs USS, laparoscopic appendicectomy as gold standard; antibiotics in uncomplicated'),
    ('Surgery', '38682788', '2024',
     'Appendectomy versus antibiotic treatment for acute appendicitis (Cochrane)',
     'Cochrane Database Syst Rev',
     'Non-operative management of uncomplicated appendicitis feasible; ~30% require surgery within 1 yr'),
    ('Surgery', '41046476', '2026',
     'Reevaluating Non-operative Management for Pediatric Uncomplicated Acute Appendicitis',
     'JAMA Pediatr',
     'In children: antibiotics-first approach safe option; compare with adult data for Surgery Paeds crossover'),
    ('Gynae & Obs', '40237648', '2025',
     'Uterotonic agents for preventing postpartum haemorrhage: a network meta-analysis (Cochrane)',
     'Cochrane Database Syst Rev',
     'Carbetocin > oxytocin for PPH prevention; combination oxytocin+misoprostol useful in resource-limited settings'),
    ('Gynae & Obs', '38965226', '2024',
     'Systematic review and meta-analysis of pregnancy outcomes in women with PCOS',
     'Nat Commun',
     'PCOS → ↑ risk GDM, pre-eclampsia, preterm birth, miscarriage – important obstetric complications to know'),
    ('Gynae & Obs', '38726883', '2024',
     'Magnesium sulphate for women at risk of preterm birth for neuroprotection of the fetus (Cochrane)',
     'Cochrane Database Syst Rev',
     'MgSO4 given <34 wks reduces cerebral palsy risk in preterm neonates – high-yield for PROM/preterm labour'),
    ('Paediatrics', '38804265', '2024',
     'Transcutaneous bilirubinometry for detecting jaundice in term or late preterm neonates (Cochrane)',
     'Cochrane Database Syst Rev',
     'TcB reliable screening tool before serum bilirubin; helps decide phototherapy threshold'),
    ('Paediatrics', '41784088', '2026',
     'High- versus low-dose phototherapy for neonatal jaundice (Cochrane)',
     'Cochrane Database Syst Rev',
     'High-dose phototherapy reduces exchange transfusion rate; no major difference in adverse effects'),
]

for ri, row_data in enumerate(papers, start=4):
    row_bg = WHITE if ri % 2 == 0 else COL_ROW_ALT
    subj = row_data[0]
    subj_col = SUBJECT_COLORS.get(subj, '4472C4')
    for ci, val in enumerate(row_data, start=1):
        c = ws3.cell(ri, ci, val)
        c.font = reg_font(10)
        c.fill = hex_fill(row_bg)
        c.border = thin_border()
        c.alignment = left() if ci in (4, 6) else center()
    # Subject cell colored
    ws3.cell(ri, 1).font = Font(name='Arial', size=10, bold=True, color=WHITE)
    ws3.cell(ri, 1).fill = hex_fill(subj_col)
    ws3.cell(ri, 1).alignment = center()
    ws3.row_dimensions[ri].height = 42

# ─────────────────────────────────────────────
# SHEET 4 : EXAM DAY CHECKLIST
# ─────────────────────────────────────────────
ws4 = wb.create_sheet("✅ Exam Day Checklist")
ws4.sheet_view.showGridLines = False

ws4.merge_cells('A1:D1')
ws4['A1'] = '✅  EXAM DAY CHECKLIST  |  3 August 2026'
ws4['A1'].font = bold_font(16, WHITE)
ws4['A1'].fill = hex_fill(COL_HEADER_DARK)
ws4['A1'].alignment = center()
ws4.row_dimensions[1].height = 36

checklist = [
    ('NIGHT BEFORE (2 Aug evening)', [
        'Review short notes for all 4 subjects (1 hr max)',
        'Pack exam essentials: pen, admit card, stationery',
        'Set alarm – wake up 1.5 hrs before exam',
        'Sleep by 10 PM – minimum 7-8 hrs sleep',
    ]),
    ('MORNING OF EXAM (3 Aug)', [
        'Light breakfast – avoid heavy/oily food',
        'Glance through key mnemonics only (30 min max)',
        'Reach exam hall 20-30 mins early',
        'No new topics – only revision',
    ]),
    ('DURING EXAM', [
        'Read each question TWICE before answering',
        'Attempt all questions – no negative marking typically',
        'Manage time: 1 min per MCQ, 5-8 min per short note',
        'Start with your strongest subject',
        'If stuck, move on and return later',
    ]),
]

cur_row4 = 3
ws4.column_dimensions['A'].width = 5
ws4.column_dimensions['B'].width = 42
ws4.column_dimensions['C'].width = 14
ws4.column_dimensions['D'].width = 30

for section, items in checklist:
    ws4.merge_cells(f'A{cur_row4}:D{cur_row4}')
    c = ws4.cell(cur_row4, 1, f'  {section}')
    c.font = bold_font(11, WHITE)
    c.fill = hex_fill('2F528F')
    c.alignment = left()
    ws4.row_dimensions[cur_row4].height = 26
    cur_row4 += 1

    # sub headers
    for hdr_txt, col_n, w in [('', 1, 5), ('Item', 2, 42), ('Done?', 3, 14), ('Notes', 4, 30)]:
        c2 = ws4.cell(cur_row4, col_n, hdr_txt)
        c2.font = bold_font(9, WHITE)
        c2.fill = hex_fill(COL_HEADER_DARK)
        c2.alignment = center()
        c2.border = thin_border()
    ws4.row_dimensions[cur_row4].height = 20
    cur_row4 += 1

    dv_ck = DataValidation(type="list", formula1='"✅ Done,⏳ Pending"', allow_blank=True)

    for item_num, item in enumerate(items, start=1):
        row_bg = WHITE if item_num % 2 == 1 else COL_ROW_ALT
        ws4.cell(cur_row4, 1, item_num).fill = hex_fill(row_bg)
        ws4.cell(cur_row4, 1).font = reg_font(10)
        ws4.cell(cur_row4, 1).alignment = center()
        ws4.cell(cur_row4, 1).border = thin_border()

        c_item = ws4.cell(cur_row4, 2, item)
        c_item.font = reg_font(10)
        c_item.fill = hex_fill(row_bg)
        c_item.alignment = left()
        c_item.border = thin_border()

        c_done = ws4.cell(cur_row4, 3, '⏳ Pending')
        c_done.font = reg_font(10)
        c_done.fill = hex_fill(row_bg)
        c_done.alignment = center()
        c_done.border = thin_border()

        c_note = ws4.cell(cur_row4, 4, '')
        c_note.font = reg_font(10)
        c_note.fill = hex_fill(row_bg)
        c_note.alignment = left()
        c_note.border = thin_border()

        dv_ck.sqref = f'C{cur_row4}'
        ws4.row_dimensions[cur_row4].height = 22
        cur_row4 += 1

    ws4.add_data_validation(dv_ck)
    cur_row4 += 1  # spacer

# ─────────────────────────────────────────────
# SAVE
# ─────────────────────────────────────────────
output_path = '/home/daytona/workspace/block-exam-prep/Block_Exam_Study_Tracker.xlsx'
wb.save(output_path)
print(f"Saved to: {output_path}")

cd /home/daytona/workspace/block-exam-prep && python create_tracker.py

~/block-exam-prep/create_tracker.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker.py'

cd /home/daytona/workspace/block-exam-prep && python create_tracker.py

grep -n "BytesIO\|buf\|wb.save" /home/daytona/workspace/block-exam-prep/create_t…

grep -n "DataValidation\|dv_ck\|add_data_validation" /home/daytona/workspace/blo…

~/block-exam-prep/create_tracker.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker.py'

~/block-exam-prep/create_tracker.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker.py'

~/block-exam-prep/create_tracker.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker.py'

~/block-exam-prep/create_tracker.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker.py'

cd /home/daytona/workspace/block-exam-prep && python create_tracker.py 2>&1

~/block-exam-prep/create_tracker.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker.py'

cd /home/daytona/workspace/block-exam-prep && python create_tracker.py 2>&1

python /home/daytona/skills/xlsx/scripts/recalc.py /home/daytona/workspace/block…

~/block-exam-prep/create_tracker_v2.py

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from openpyxl.utils import get_column_letter
from openpyxl.formatting.rule import CellIsRule
from openpyxl.worksheet.datavalidation import DataValidation
import io as _io

wb = Workbook()

# ─── HELPERS ───────────────────────────────────────────
def hex_fill(h):
    return PatternFill("solid", start_color=h, fgColor=h)

def tb():
    s = Side(style='thin', color='BBBBBB')
    return Border(left=s, right=s, top=s, bottom=s)

def bf(size=11, color='000000'):
    return Font(name='Arial', bold=True, size=size, color=color)

def rf(size=10, color='000000'):
    return Font(name='Arial', size=size, color=color)

def ca():
    return Alignment(horizontal='center', vertical='center', wrap_text=True)

def la():
    return Alignment(horizontal='left', vertical='center', wrap_text=True)

# Colors
NAV   = '1F3864'
WHITE = 'FFFFFF'
ALT   = 'EEF3FB'
WKEND = 'F5F5F5'
TRAVEL= 'FFF3CD'
EXAM  = 'D4EDDA'

SUBJ_COLOR = {
    'Surgery':     '2E75B6',
    'Gynae & Obs': 'C55A11',
    'Paediatrics': '375623',
    'Medicine':    '7030A0',
    'REVIEW':      '595959',
}

COL_DONE    = 'E2EFDA'
COL_PARTIAL = 'FFF2CC'
COL_NOTDONE = 'FCE4D6'

# ─── SHEET 1: DAILY TRACKER ────────────────────────────
ws = wb.active
ws.title = "Daily Tracker"
ws.sheet_view.showGridLines = False
ws.freeze_panes = 'A5'

# Title
ws.merge_cells('A1:L1')
ws['A1'] = 'BLOCK EXAM STUDY TRACKER  |  Exam: 3 August 2026  |  Surgery > Gynae & Obs > Paeds > Medicine'
ws['A1'].font = bf(14, WHITE)
ws['A1'].fill = hex_fill(NAV)
ws['A1'].alignment = ca()
ws.row_dimensions[1].height = 34

ws.merge_cells('A2:L2')
ws['A2'] = '20 Study Days (Jul 12 - Aug 1)  |  Aug 2 = Travel + Review Only  |  Aug 3 = EXAM DAY'
ws['A2'].font = Font(name='Arial', size=10, italic=True, color='D9E1F2')
ws['A2'].fill = hex_fill('2F528F')
ws['A2'].alignment = ca()
ws.row_dimensions[2].height = 20

ws.merge_cells('A3:L3')
ws['A3'].fill = hex_fill('D9E1F2')
ws.row_dimensions[3].height = 5

# Headers
headers = ['Date','Day','Subject','Morning / Block 1 Topics','Afternoon / Block 2 Topics',
           'Hrs\nPlanned','Hrs\nActual','Status','Confidence\n(1-5)','MCQs\nDone?','Notes / Doubts','Revision\nDone?']
col_w   = [11,    9,     13,       38,                         38,
           8,     8,     13,       13,             10,          34,              12]

for ci,(h,w) in enumerate(zip(headers,col_w),1):
    c = ws.cell(4, ci, h)
    c.font = bf(9, WHITE)
    c.fill = hex_fill(NAV)
    c.alignment = ca()
    c.border = tb()
    ws.column_dimensions[get_column_letter(ci)].width = w
ws.row_dimensions[4].height = 30

# ── Schedule rows ──
schedule = [
    # (date, day, subject, morning_topics, afternoon_topics, hrs, day_type)
    # day_type: weekday | weekend | travel
    ('12 Jul','Sun','Surgery',
     'General: Haemorrhage + Shock + Wound Healing',
     'Systemic: Intestinal Obstruction + Hernia + Abdominal Wall',
     4.5,'weekend'),

    ('13 Jul','Mon','Surgery',
     'General: Fluids & Electrolytes + Acid-Base Disorders',
     'Systemic: Appendix + Rectum + Anal Canal',
     8.5,'weekday'),

    ('14 Jul','Tue','Surgery',
     'General: Pre-op + Post-op + Surgical Infections',
     'Systemic: Stomach + Duodenum + Oesophagus',
     8.5,'weekday'),

    ('15 Jul','Wed','Surgery',
     'General: Burns + ATLS + Plastic Surgery (Grafts & Flaps)',
     'Systemic: Breast + Endocrine Surgery (Thyroid, Parathyroid, Adrenal)',
     8.5,'weekday'),

    ('16 Jul','Thu','Surgery',
     'General: Head & Neck + Neuro Surgery + Cardiothoracic',
     'Systemic: Liver + Pancreas + Spleen + Hepatobiliary (Revision - AI-studied, redo from MCQ angle)',
     8.5,'weekday'),

    ('17 Jul','Fri','Surgery',
     'General: Vascular (Arterial + Venous + Lymphatic) + Nutrition',
     'Systemic: Kidney + Ureter + Bladder + Prostate + Urethra + Testes',
     8.5,'weekday'),

    ('18 Jul','Sat','Surgery',
     'General: Principles of Anaesthesia + Radiology + Orthopaedics',
     'Surgery Full Rapid Revision + MCQ Practice (all topics)',
     4.5,'weekend'),

    ('19 Jul','Sun','Gynae & Obs',
     'Obs: ANC + Normal Fetal Development + Fetal Well-being + Prenatal Diagnosis',
     'Gynae: Anatomy of Female Pelvis + Menstrual Cycle + Hormonal Disorders',
     4.5,'weekend'),

    ('20 Jul','Mon','Gynae & Obs',
     'Obs: Antenatal Obstetric Complications + Multiple Pregnancy + Preterm Labour',
     'Gynae: Disorders of Menstrual Bleeding + Contraception & Abortion',
     8.5,'weekday'),

    ('21 Jul','Tue','Gynae & Obs',
     'Obs: Hypertensive Disorders of Pregnancy (Pre-eclampsia, Eclampsia, HELLP)',
     'Gynae: Subfertility + Implantation + Early Pregnancy (Ectopic, Molar)',
     8.5,'weekday'),

    ('22 Jul','Wed','Gynae & Obs',
     'Obs: Normal + Abnormal Labour + Operative Delivery (Forceps, Ventouse, LSCS)',
     'Gynae: Benign Conditions - Ovary (PCOS, Cysts) + Uterus (Fibroids) + Endometriosis',
     8.5,'weekday'),

    ('23 Jul','Thu','Gynae & Obs',
     'Obs: Obstetric Emergencies (APH, PPH) + Puerperium + Neonates (Obstetric chapter)',
     'Gynae: Malignant Disease - Ovary + Uterus + Lower Genital Tract + STIs',
     8.5,'weekday'),

    ('24 Jul','Fri','Gynae & Obs',
     'Obs: Perinatal Infections + Medical Complications of Pregnancy + Full Obs Revision',
     'Gynae: Urogynaecology + Menopause + Full Gynae Revision + MCQs',
     8.5,'weekday'),

    ('25 Jul','Sat','Paediatrics',
     'Growth: Anthropometrics + Growth Charts + Percentiles + Red Flags + Factors',
     'Development Milestones (gross motor, fine motor, speech, social)',
     4.5,'weekend'),

    ('26 Jul','Sun','Paediatrics',
     'Normal Nutrition + Malnutrition: Kwashiorkor + Marasmus + Marasmic-Kwashiorkor',
     'Obesity + Rickets + Vitamin Deficiencies (A, D, C, B12, Iron)',
     4.5,'weekend'),

    ('27 Jul','Mon','Paediatrics',
     'Neonatology: Prematurity + RDS + IVH + Neonatal Resuscitation + Hypoglycaemia',
     'Normal Newborn Exam & Care + Neonatal Sepsis + Immunisation Schedule',
     8.5,'weekday'),

    ('28 Jul','Tue','Paediatrics',
     'Respiratory: Bronchopneumonia + Asthma + Croup + Acute Epiglottitis + Bronchiolitis',
     'Paeds GIT + Haematology & Oncology + Paeds CVS + Full Paeds Revision + MCQs',
     8.5,'weekday'),

    ('29 Jul','Wed','Medicine',
     'CVS: Hypertension + IHD (Angina, MI, ACS) + Heart Failure',
     'CVS: Arrhythmias + Valvular Diseases + Infective Endocarditis',
     8.5,'weekday'),

    ('30 Jul','Thu','Medicine',
     'Respiratory: Asthma + COPD + Tuberculosis + Pneumonia',
     'Respiratory: Pleural Effusion + Lung Cancer + Pneumothorax',
     8.5,'weekday'),

    ('31 Jul','Fri','Medicine',
     'Gastro: Peptic Ulcer Disease + IBD (Crohns + UC) + GI Bleeding',
     'Gastro/Hepato: Cirrhosis + Hepatitis + Jaundice + (Hepato if in syllabus)',
     8.5,'weekday'),

    ('1 Aug','Sat','Medicine',
     'Neuro: Stroke + Epilepsy + Meningitis + Headache',
     'Medicine Full Rapid Revision - ALL topics + High-Yield MCQs',
     4.5,'weekend'),

    ('2 Aug','Sun','REVIEW',
     'TRAVEL DAY - Light Review Only: Skim short notes & cheat sheets for all subjects',
     'NO new topics. Rest, travel, sleep early.',
     3.0,'travel'),
]

for rn,(date,day,subj,morn,aftn,hrs,dtype) in enumerate(schedule, start=5):
    is_travel = dtype == 'travel'
    is_weekend = dtype == 'weekend'
    sc = SUBJ_COLOR.get(subj,'4472C4')

    if is_travel:
        row_bg = TRAVEL
    elif is_weekend:
        row_bg = WKEND
    else:
        row_bg = WHITE if rn%2==1 else ALT

    vals = [date, day, subj, morn, aftn, hrs, '', '', '', 'No', '', 'No']
    for ci,val in enumerate(vals,1):
        c = ws.cell(rn, ci, val)
        c.border = tb()
        c.font = rf(10)
        c.fill = hex_fill(row_bg)

        if ci==1:
            c.font = bf(10)
            c.alignment = ca()
        elif ci==2:
            c.alignment = ca()
            if is_weekend:
                c.font = Font(name='Arial',size=10,bold=True,color='C00000')
            elif is_travel:
                c.font = Font(name='Arial',size=10,bold=True,color='856404')
        elif ci==3:
            c.font = Font(name='Arial',size=10,bold=True,color=WHITE)
            c.fill = hex_fill(sc)
            c.alignment = ca()
        elif ci in (4,5,11):
            c.alignment = la()
        else:
            c.alignment = ca()

    ws.row_dimensions[rn].height = 38

last_row = 4 + len(schedule)

# Data validations
dv_status = DataValidation(type="list", formula1='"Done,Partial,Not Done"', allow_blank=True)
dv_status.sqref = f'H5:H{last_row}'
ws.add_data_validation(dv_status)

dv_conf = DataValidation(type="list", formula1='"1,2,3,4,5"', allow_blank=True)
dv_conf.sqref = f'I5:I{last_row}'
ws.add_data_validation(dv_conf)

dv_yn = DataValidation(type="list", formula1='"Yes,No,Partial"', allow_blank=True)
dv_yn.sqref = f'J5:L{last_row}'
ws.add_data_validation(dv_yn)

# Conditional formatting on Status col H
ws.conditional_formatting.add(f'H5:H{last_row}',
    CellIsRule(operator='equal', formula=['"Done"'], fill=hex_fill(COL_DONE)))
ws.conditional_formatting.add(f'H5:H{last_row}',
    CellIsRule(operator='equal', formula=['"Partial"'], fill=hex_fill(COL_PARTIAL)))
ws.conditional_formatting.add(f'H5:H{last_row}',
    CellIsRule(operator='equal', formula=['"Not Done"'], fill=hex_fill(COL_NOTDONE)))

# Summary
sr = last_row + 2
ws.merge_cells(f'A{sr}:C{sr}')
ws.cell(sr,1,'PROGRESS SUMMARY').font = bf(11,WHITE)
ws.cell(sr,1).fill = hex_fill(NAV)
ws.cell(sr,1).alignment = ca()

sum_labels = ['Days Done','Days Partial','Days Not Done','Days Remaining','Planned Hrs','Actual Hrs']
sum_formulas = [
    f'=COUNTIF(H5:H{last_row},"Done")',
    f'=COUNTIF(H5:H{last_row},"Partial")',
    f'=COUNTIF(H5:H{last_row},"Not Done")',
    f'={len(schedule)}-COUNTIF(H5:H{last_row},"Done")-COUNTIF(H5:H{last_row},"Partial")',
    f'=SUM(F5:F{last_row})',
    f'=SUM(G5:G{last_row})',
]
sr2 = sr + 1
for i,(lbl,frm) in enumerate(zip(sum_labels,sum_formulas)):
    col = 4+i
    lc = ws.cell(sr, col, lbl)
    lc.font = bf(9,NAV); lc.fill = hex_fill('D9E1F2')
    lc.alignment = ca(); lc.border = tb()
    vc = ws.cell(sr2, col, frm)
    vc.font = bf(12,'1F3864'); vc.fill = hex_fill('EEF3FB')
    vc.alignment = ca(); vc.border = tb()

ws.row_dimensions[sr].height = 22
ws.row_dimensions[sr2].height = 28

# ─── SHEET 2: FULL SYLLABUS BREAKDOWN ──────────────────
ws2 = wb.create_sheet("Syllabus Breakdown")
ws2.sheet_view.showGridLines = False

ws2.merge_cells('A1:F1')
ws2['A1'] = 'COMPLETE SYLLABUS BREAKDOWN - All 4 Subjects'
ws2['A1'].font = bf(14,WHITE)
ws2['A1'].fill = hex_fill(NAV)
ws2['A1'].alignment = ca()
ws2.row_dimensions[1].height = 32

syllabus = {
    'Surgery': {
        'color': '2E75B6',
        'General Surgery': [
            ('Haemorrhage & Shock','High'),('Wound Healing','High'),
            ('Fluids & Electrolytes','High'),('Acid-Base Disorders','High'),
            ('Burns - Rule of 9s + Management','High'),('ATLS Principles','High'),
            ('Plastic Surgery - Grafts & Flaps','Medium'),
            ('Pre-op Assessment','High'),('Post-op Complications','High'),
            ('Surgical Infections','High'),
            ('Head & Neck Surgery','Medium'),('Neuro Surgery basics','Medium'),
            ('Cardiothoracic Surgery','Medium'),
            ('Vascular - Arterial + Venous + Lymphatic','High'),
            ('Nutrition in Surgery','Medium'),
            ('Principles of Anaesthesia','High'),
            ('Principles of Radiology','Medium'),
            ('Orthopaedics (basics)','Medium'),
        ],
        'Systemic Surgery': [
            ('Intestinal Obstruction','High'),('Hernia (Inguinal, Femoral, Umbilical)','High'),
            ('Appendix & Appendicitis','High'),('Rectum & Anal Canal (piles, fissure, fistula)','High'),
            ('Stomach & Duodenum (PUD, Ca Stomach)','High'),
            ('Oesophagus (GERD, Carcinoma)','High'),
            ('Breast (Fibroadenoma, Ca Breast)','High'),
            ('Endocrine Surgery - Thyroid','High'),('Endocrine Surgery - Parathyroid + Adrenal','Medium'),
            ('Head & Neck Surgery (Salivary glands, Thyroglossal cyst)','Medium'),
            ('Liver - Abscess, Hydatid, Ca Liver','High'),
            ('Pancreas - Pancreatitis, Ca Pancreas','High'),
            ('Spleen - Splenomegaly, Splenectomy','Medium'),
            ('Hepatobiliary - Gallstones, Cholecystitis','High'),
            ('Kidney + Ureter - Calculi, Hydronephrosis, Tumors','High'),
            ('Bladder + Prostate - BPH, Ca Prostate','High'),
            ('Urethra + Penis + Testes & Scrotum','Medium'),
        ]
    },
    'Gynae & Obs': {
        'color': 'C55A11',
        'Obstetrics': [
            ('Obstetric History & Examination','High'),
            ('Antenatal Care (ANC)','High'),
            ('Normal Fetal Development & Growth','High'),
            ('Assessment of Fetal Well-being (CTG, BPP)','High'),
            ('Prenatal Diagnosis (AFP, amniocentesis)','High'),
            ('Antenatal Obstetric Complications','High'),
            ('Multiple Pregnancy','High'),
            ('Preterm Labour','High'),
            ('Hypertensive Disorders - Pre-eclampsia + Eclampsia + HELLP','High'),
            ('Medical Complications of Pregnancy (DM, cardiac, thyroid)','High'),
            ('Perinatal Infections (TORCH, GBS, HIV)','High'),
            ('Normal Labour + Partograph','High'),
            ('Abnormal Labour + Dystocia','High'),
            ('Operative Delivery (Forceps, Ventouse, LSCS)','High'),
            ('Obstetric Emergencies: APH + PPH','High'),
            ('Obstetric Emergencies: Ectopic Pregnancy + Molar Pregnancy','High'),
            ('Puerperium + Puerperal Sepsis + PPD','High'),
            ('Neonates (Obstetric chapter - normal newborn)','Medium'),
        ],
        'Gynaecology': [
            ('Anatomy of Female Sexual Organs & Pelvis','High'),
            ('Hormonal Control of Menstrual Cycle','High'),
            ('Disorders of Menstrual Bleeding (DUB, amenorrhoea)','High'),
            ('Contraception + Abortion','High'),
            ('Implantation & Early Pregnancy','Medium'),
            ('Subfertility','High'),
            ('Menopause & Post-reproductive Health','Medium'),
            ('STIs and Related Conditions','Medium'),
            ('Urogynaecology & Pelvic Floor Problems','Medium'),
            ('Benign Conditions of Ovary & Pelvis (PCOS, cysts)','High'),
            ('Benign Conditions of Uterus, Cervix & Endometrium (Fibroids)','High'),
            ('Benign Conditions of Vulva & Vagina','Medium'),
            ('Malignant Disease of the Ovary','High'),
            ('Malignant Disease of the Uterus (Endometrial Ca)','High'),
            ('Premalignant + Malignant Disease of Lower Genital Tract (Cx Ca)','High'),
        ]
    },
    'Paediatrics': {
        'color': '375623',
        'Paediatrics': [
            ('Growth - Anthropometric Measurements','High'),
            ('Growth Charts, Percentiles, Red Flags','High'),
            ('Development Milestones (gross/fine motor, speech, social)','High'),
            ('Normal Nutrition in Paediatrics','High'),
            ('Malnutrition - Kwashiorkor + Marasmus','High'),
            ('Obesity in Children','Medium'),
            ('Rickets + Vitamin D Deficiency','High'),
            ('Vitamin Deficiencies (A, C, B12, Iron)','High'),
            ('Immunisation Schedule','High'),
            ('Neonatology - Prematurity + Complications','High'),
            ('Respiratory Distress Syndrome (RDS)','High'),
            ('Intraventricular Haemorrhage (IVH)','High'),
            ('Neonatal Resuscitation (NRP algorithm)','High'),
            ('Neonatal Hypoglycaemia','High'),
            ('Normal Newborn Examination & Care','High'),
            ('Neonatal Sepsis','High'),
            ('Paediatric GIT Diseases','Medium'),
            ('Paediatric Haematology & Oncology','Medium'),
            ('Paediatric CVS','Medium'),
            ('Bronchopneumonia','High'),
            ('Asthma in Children','High'),
            ('Croup (Laryngotracheobronchitis)','High'),
            ('Acute Epiglottitis','High'),
            ('Bronchiolitis','High'),
        ]
    },
    'Medicine': {
        'color': '7030A0',
        'Medicine': [
            ('Hypertension - Classification, Management','High'),
            ('Ischaemic Heart Disease - Angina, MI, ACS','High'),
            ('Heart Failure - Causes, Features, Management','High'),
            ('Arrhythmias - AF, VT, Heart Block','High'),
            ('Valvular Heart Diseases','High'),
            ('Infective Endocarditis','Medium'),
            ('Asthma - Classification, Management, Status asthmaticus','High'),
            ('COPD - GOLD staging, Management','High'),
            ('Tuberculosis - Types, Diagnosis, ATT','High'),
            ('Pneumonia - CAP vs HAP, Management','High'),
            ('Pleural Effusion + Pneumothorax','High'),
            ('Lung Cancer (basics)','Medium'),
            ('Peptic Ulcer Disease + H. pylori','High'),
            ('Inflammatory Bowel Disease - Crohns + UC','High'),
            ('GI Bleeding (upper + lower)','High'),
            ('Cirrhosis - Complications, Management','High'),
            ('Hepatitis (A, B, C, E) - Serology, Management','High'),
            ('Jaundice - Approach','High'),
            ('Hepato topics (if in syllabus)','Medium'),
            ('Stroke - Types, Investigations, Management','High'),
            ('Epilepsy - Classification, Drugs','High'),
            ('Meningitis - Bacterial vs Viral, CSF findings','High'),
        ]
    }
}

cur2 = 3
col_hdrs2 = ['#','Topic','Priority','Status','Confidence (1-5)','Revision Date']
col_w2    = [4, 52, 10, 14, 16, 14]
for ci,(h,w) in enumerate(col_hdrs2,1):
    ws2.column_dimensions[get_column_letter(ci)].width = w

for subj_name, subj_info in syllabus.items():
    sc = subj_info['color']
    # Subject big header
    ws2.merge_cells(f'A{cur2}:F{cur2}')
    c = ws2.cell(cur2,1, f'  {subj_name.upper()}')
    c.font = bf(13,WHITE); c.fill = hex_fill(sc)
    c.alignment = la()
    ws2.row_dimensions[cur2].height = 28
    cur2 += 1

    for section_name, topics in subj_info.items():
        if section_name == 'color': continue

        # Section sub-header
        ws2.merge_cells(f'A{cur2}:F{cur2}')
        c2 = ws2.cell(cur2,1,f'    {section_name}')
        c2.font = bf(10,WHITE)
        c2.fill = hex_fill('2F528F')
        c2.alignment = la()
        ws2.row_dimensions[cur2].height = 22
        cur2 += 1

        # column headers
        for ci,(h,w) in enumerate(zip(col_hdrs2,col_w2),1):
            ch = ws2.cell(cur2,ci,h)
            ch.font = bf(9,WHITE); ch.fill = hex_fill('404040')
            ch.alignment = ca(); ch.border = tb()
        ws2.row_dimensions[cur2].height = 20
        cur2 += 1

        dv = DataValidation(type="list", formula1='"Done,Partial,Not Done"', allow_blank=True)
        ts = cur2
        for ti,(topic,prio) in enumerate(topics,1):
            bg = WHITE if ti%2==1 else ALT
            vals2 = [ti, topic, prio, '', '', '']
            for ci,val in enumerate(vals2,1):
                c = ws2.cell(cur2,ci,val)
                c.font = rf(10); c.fill = hex_fill(bg)
                c.border = tb()
                c.alignment = ca() if ci in (1,3,4,5,6) else la()
            pc = ws2.cell(cur2,3)
            pc.font = Font(name='Arial',size=10,bold=True,
                           color='C00000' if prio=='High' else '7030A0')
            ws2.row_dimensions[cur2].height = 20
            cur2 += 1

        dv.sqref = f'D{ts}:D{cur2-1}'
        ws2.add_data_validation(dv)
        cur2 += 1  # spacer

# ─── SHEET 3: CHEAT SHEET LOG ──────────────────────────
ws3 = wb.create_sheet("Cheat Sheet Log")
ws3.sheet_view.showGridLines = False

ws3.merge_cells('A1:E1')
ws3['A1'] = 'CHEAT SHEET LOG  |  A new cheat sheet is created each time you study a topic'
ws3['A1'].font = bf(12,WHITE); ws3['A1'].fill = hex_fill(NAV)
ws3['A1'].alignment = ca(); ws3.row_dimensions[1].height = 30

ws3.merge_cells('A2:E2')
ws3['A2'] = 'Tell Orris "I am studying [topic] today" and a cheat sheet will be generated for that topic.'
ws3['A2'].font = Font(name='Arial',size=10,italic=True,color='2F528F')
ws3['A2'].fill = hex_fill('D9E1F2'); ws3['A2'].alignment = ca()
ws3.row_dimensions[2].height = 22

log_hdrs = ['Date Studied','Subject','Topic','Cheat Sheet Created?','Notes']
log_w    = [14,13,40,20,35]
for ci,(h,w) in enumerate(zip(log_hdrs,log_w),1):
    c = ws3.cell(3,ci,h)
    c.font = bf(10,WHITE); c.fill = hex_fill(NAV)
    c.alignment = ca(); c.border = tb()
    ws3.column_dimensions[get_column_letter(ci)].width = w
ws3.row_dimensions[3].height = 24

for ri in range(4,30):
    bg = WHITE if ri%2==0 else ALT
    for ci in range(1,6):
        c = ws3.cell(ri,ci,'')
        c.fill = hex_fill(bg); c.border = tb(); c.alignment = ca()
    ws3.row_dimensions[ri].height = 22

dv_cs = DataValidation(type="list", formula1='"Yes,No,Pending"', allow_blank=True)
dv_cs.sqref = 'D4:D29'
ws3.add_data_validation(dv_cs)

# ─── SAVE ──────────────────────────────────────────────
output = '/home/daytona/workspace/block-exam-prep/Block_Exam_Study_Tracker_v2.xlsx'
buf = _io.BytesIO()
wb.save(buf)
with open(output,'wb') as f:
    f.write(buf.getvalue())
print(f"Saved: {output}")

cd /home/daytona/workspace/block-exam-prep && python create_tracker_v2.py 2>&1

~/block-exam-prep/create_tracker_v2.py

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/block-exam-prep/create_tracker_v2.py'

cd /home/daytona/workspace/block-exam-prep && python create_tracker_v2.py 2>&1

python /home/daytona/skills/xlsx/scripts/recalc.py /home/daytona/workspace/block…

~/block-exam-prep/intestinal_obstruction_pdf.py

from reportlab.lib.pagesizes import A4
from reportlab.lib import colors
from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle
from reportlab.lib.units import cm
from reportlab.platypus import (SimpleDocTemplate, Paragraph, Spacer, Table,
                                 TableStyle, HRFlowable, KeepTogether)
from reportlab.lib.enums import TA_LEFT, TA_CENTER, TA_JUSTIFY
import os

OUTPUT = '/home/daytona/workspace/block-exam-prep/Intestinal_Obstruction_Cheatsheet.pdf'

doc = SimpleDocTemplate(OUTPUT, pagesize=A4,
                        leftMargin=1.8*cm, rightMargin=1.8*cm,
                        topMargin=1.8*cm, bottomMargin=1.8*cm)

W = A4[0] - 3.6*cm  # usable width

# ── Color palette ─────────────────────────────────────
NAV    = colors.HexColor('#1F3864')
BLUE   = colors.HexColor('#2E75B6')
PINK   = colors.HexColor('#C0143C')
GREEN  = colors.HexColor('#375623')
ORANGE = colors.HexColor('#C55A11')
PURPLE = colors.HexColor('#7030A0')
LTBLUE = colors.HexColor('#D9E1F2')
LTYELL = colors.HexColor('#FFF2CC')
LTGRN  = colors.HexColor('#E2EFDA')
LTPINK = colors.HexColor('#FCE4D6')
WHITE  = colors.white
BLACK  = colors.black

# ── Styles ────────────────────────────────────────────
styles = getSampleStyleSheet()

def S(name, **kw):
    return ParagraphStyle(name, **kw)

TITLE    = S('TITLE',    fontSize=20, textColor=WHITE,      alignment=TA_CENTER, fontName='Helvetica-Bold', spaceAfter=4)
SUBTITLE = S('SUBTITLE', fontSize=11, textColor=LTBLUE,     alignment=TA_CENTER, fontName='Helvetica',      spaceAfter=2)
H1       = S('H1',       fontSize=13, textColor=WHITE,      alignment=TA_LEFT,   fontName='Helvetica-Bold', spaceAfter=2, spaceBefore=4)
H2       = S('H2',       fontSize=11, textColor=NAV,        alignment=TA_LEFT,   fontName='Helvetica-Bold', spaceAfter=2, spaceBefore=6)
H3       = S('H3',       fontSize=10, textColor=PINK,       alignment=TA_LEFT,   fontName='Helvetica-Bold', spaceAfter=1, spaceBefore=3)
BODY     = S('BODY',     fontSize=9,  textColor=BLACK,      alignment=TA_JUSTIFY,fontName='Helvetica',      spaceAfter=2, leading=13)
BULL     = S('BULL',     fontSize=9,  textColor=BLACK,      alignment=TA_LEFT,   fontName='Helvetica',      spaceAfter=1, leading=12, leftIndent=12)
SMALL    = S('SMALL',    fontSize=8,  textColor=colors.HexColor('#444444'), fontName='Helvetica', leading=11)
MNEM     = S('MNEM',     fontSize=10, textColor=PURPLE,     fontName='Helvetica-Bold', spaceAfter=1, leading=13)
WARN     = S('WARN',     fontSize=9,  textColor=PINK,       fontName='Helvetica-Bold', spaceAfter=1, leading=12)

def hdr_table(text, bg=NAV, style=H1):
    t = Table([[Paragraph(text, style)]], colWidths=[W])
    t.setStyle(TableStyle([
        ('BACKGROUND', (0,0), (-1,-1), bg),
        ('ROUNDEDCORNERS', [4]),
        ('TOPPADDING',  (0,0),(-1,-1), 5),
        ('BOTTOMPADDING',(0,0),(-1,-1), 5),
        ('LEFTPADDING', (0,0),(-1,-1), 8),
    ]))
    return t

def sub_hdr(text, bg=BLUE):
    style = S('sh', fontSize=11, textColor=WHITE, fontName='Helvetica-Bold',
              alignment=TA_LEFT, spaceAfter=0)
    t = Table([[Paragraph(text, style)]], colWidths=[W])
    t.setStyle(TableStyle([
        ('BACKGROUND', (0,0), (-1,-1), bg),
        ('TOPPADDING',  (0,0),(-1,-1), 4),
        ('BOTTOMPADDING',(0,0),(-1,-1), 4),
        ('LEFTPADDING', (0,0),(-1,-1), 8),
    ]))
    return t

def box(content_rows, bg=LTBLUE, border=BLUE):
    """content_rows: list of Paragraph objects"""
    cells = [[p] for p in content_rows]
    t = Table(cells, colWidths=[W])
    t.setStyle(TableStyle([
        ('BACKGROUND', (0,0),(-1,-1), bg),
        ('BOX', (0,0),(-1,-1), 1, border),
        ('TOPPADDING',  (0,0),(-1,-1), 3),
        ('BOTTOMPADDING',(0,0),(-1,-1), 3),
        ('LEFTPADDING', (0,0),(-1,-1), 10),
        ('RIGHTPADDING', (0,0),(-1,-1), 6),
    ]))
    return t

def two_col(left_items, right_items, bg_l=LTBLUE, bg_r=LTGRN):
    cw = W/2 - 2
    def make_cell(items, bg):
        rows = [[Paragraph(it, BULL)] for it in items]
        t = Table(rows, colWidths=[cw])
        t.setStyle(TableStyle([
            ('BACKGROUND',(0,0),(-1,-1),bg),
            ('TOPPADDING',(0,0),(-1,-1),2),
            ('BOTTOMPADDING',(0,0),(-1,-1),2),
            ('LEFTPADDING',(0,0),(-1,-1),6),
        ]))
        return t
    outer = Table([[make_cell(left_items, bg_l), make_cell(right_items, bg_r)]],
                  colWidths=[cw+2, cw+2])
    outer.setStyle(TableStyle([
        ('VALIGN',(0,0),(-1,-1),'TOP'),
        ('LEFTPADDING',(0,0),(-1,-1),0),
        ('RIGHTPADDING',(0,0),(-1,-1),0),
    ]))
    return outer

def b(txt): return f'<b>{txt}</b>'
def c(txt, col='#C0143C'): return f'<font color="{col}">{txt}</font>'
def u(txt): return f'<u>{txt}</u>'

# ══════════════════════════════════════════════════════
# BUILD STORY
# ══════════════════════════════════════════════════════
story = []

# ── COVER HEADER ──────────────────────────────────────
cover = Table([[Paragraph('INTESTINAL OBSTRUCTION', TITLE),
                Paragraph('High-Yield Cheat Sheet + MCQ Reference  |  Surgery Block Exam', SUBTITLE)]],
              colWidths=[W])
cover.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,-1), NAV),
    ('TOPPADDING',(0,0),(-1,-1), 10),
    ('BOTTOMPADDING',(0,0),(-1,-1), 10),
    ('LEFTPADDING',(0,0),(-1,-1), 10),
    ('SPAN',(0,0),(0,1)),
]))
story.append(hdr_table('📋  INTESTINAL OBSTRUCTION  |  High-Yield Cheat Sheet + MCQ Reference', NAV, H1))
story.append(Spacer(1, 4))

# ══ SECTION 1: CLASSIFICATION ═════════════════════════
story.append(sub_hdr('1.  CLASSIFICATION', BLUE))
story.append(Spacer(1,3))

class_data = [
    [Paragraph(b('TYPE'), BULL), Paragraph(b('DESCRIPTION'), BULL), Paragraph(b('EXAMPLES'), BULL)],
    [Paragraph(c('DYNAMIC','#1F3864'), BULL),
     Paragraph('Peristalsis working <b>against</b> a mechanical block', BULL),
     Paragraph('Adhesions, Hernia, Malignancy, Volvulus, Intussusception, Stricture, Gallstone ileus', BULL)],
    [Paragraph(c('ADYNAMIC','#C0143C'), BULL),
     Paragraph('<b>No</b> mechanical block; peristalsis absent/inadequate', BULL),
     Paragraph('Paralytic ileus, Pseudo-obstruction', BULL)],
]
ct = Table(class_data, colWidths=[W*0.22, W*0.38, W*0.40])
ct.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,0), NAV),
    ('TEXTCOLOR',(0,0),(-1,0), WHITE),
    ('BACKGROUND',(0,1),(-1,1), LTBLUE),
    ('BACKGROUND',(0,2),(-1,2), LTPINK),
    ('BOX',(0,0),(-1,-1),1,BLUE),
    ('INNERGRID',(0,0),(-1,-1),0.5,colors.HexColor('#AAAAAA')),
    ('TOPPADDING',(0,0),(-1,-1),4),
    ('BOTTOMPADDING',(0,0),(-1,-1),4),
    ('LEFTPADDING',(0,0),(-1,-1),6),
    ('VALIGN',(0,0),(-1,-1),'TOP'),
]))
story.append(ct)
story.append(Spacer(1,4))

# Most common causes (pie chart data from book)
story.append(Paragraph(b('Most Common Causes (from book pie chart):'), H2))
causes_data = [
    [Paragraph(b('Cause'), BULL), Paragraph(b('Frequency'), BULL),
     Paragraph(b('Cause'), BULL), Paragraph(b('Frequency'), BULL)],
    [Paragraph('Adhesions', BULL), Paragraph(c('40%','#1F3864'), BULL),
     Paragraph('Faecal impaction', BULL), Paragraph('8%', BULL)],
    [Paragraph('Inflammatory', BULL), Paragraph('15%', BULL),
     Paragraph('Pseudo-obstruction', BULL), Paragraph('5%', BULL)],
    [Paragraph('Carcinoma', BULL), Paragraph('15%', BULL),
     Paragraph('Miscellaneous', BULL), Paragraph('5%', BULL)],
    [Paragraph('Obstructed hernia', BULL), Paragraph('12%', BULL),
     Paragraph('', BULL), Paragraph('', BULL)],
]
caut = Table(causes_data, colWidths=[W*0.3, W*0.2, W*0.3, W*0.2])
caut.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,0), colors.HexColor('#2F528F')),
    ('TEXTCOLOR',(0,0),(-1,0), WHITE),
    ('ROWBACKGROUNDS',(0,1),(-1,-1),[LTBLUE, WHITE]),
    ('BOX',(0,0),(-1,-1),1,BLUE),
    ('INNERGRID',(0,0),(-1,-1),0.5,colors.HexColor('#CCCCCC')),
    ('TOPPADDING',(0,0),(-1,-1),3),('BOTTOMPADDING',(0,0),(-1,-1),3),
    ('LEFTPADDING',(0,0),(-1,-1),6),
    ('VALIGN',(0,0),(-1,-1),'MIDDLE'),
]))
story.append(caut)
story.append(box([Paragraph(f'🔑  {b("MCQ TIP:")} Adhesions = #1 cause of SBO in western countries (40%). '
                            f'Carcinoma = most common cause of {b("large")} bowel obstruction.', WARN)], LTYELL, ORANGE))
story.append(Spacer(1,4))

# ══ SECTION 2: PATHOPHYSIOLOGY ════════════════════════
story.append(sub_hdr('2.  PATHOPHYSIOLOGY  (Simple)', BLUE))
story.append(Spacer(1,3))
path_steps = [
    '1.  Obstruction occurs → bowel PROXIMAL distends, bowel DISTAL collapses',
    '2.  Gas accumulates (90% = Nitrogen + Hydrogen sulphide) due to aerobic + anaerobic bacterial overgrowth',
    '3.  Fluid accumulates (saliva 500 mL + bile 500 mL + pancreatic 500 mL + gastric 1 L = ~2.5 L/day) → cannot be absorbed → dehydration + electrolyte loss',
    '4.  Proximal peristalsis ↑ (trying to overcome) → eventually fatigues → flaccidity + paralysis',
    '5.  If strangulation → blood supply cut off → ischaemia → necrosis → perforation → peritonitis → DEATH',
]
story.append(box([Paragraph(p, BULL) for p in path_steps], LTBLUE, BLUE))
story.append(Spacer(1,4))

# ══ SECTION 3: STRANGULATION ══════════════════════════
story.append(sub_hdr('3.  STRANGULATION  ⚠️  SURGICAL EMERGENCY', PINK))
story.append(Spacer(1,3))
story.append(Paragraph(b('Causes of strangulation:'), H3))
story.append(two_col(
    [b('Direct pressure on bowel wall:'), '• Hernial orifices', '• Adhesions/bands'],
    [b('Interrupted mesenteric flow:'), '• Volvulus', '• Intussusception',
     b('Increased intraluminal P:'), '• Closed-loop obstruction']
))
story.append(Spacer(1,3))
story.append(box([
    Paragraph(f'⚠️  {b("Clinical features of STRANGULATION")} (Summary Box 78.8):', WARN),
    Paragraph('• Constant, severe pain (not colicky - RED FLAG)', BULL),
    Paragraph('• Tenderness with rigidity and peritonism', BULL),
    Paragraph('• Shock', BULL),
    Paragraph(f'{b("KEY:")} In strangulation, pain may be ABSENT (bowel is dead). Fever + tachycardia are late signs.', WARN),
], LTPINK, PINK))
story.append(Spacer(1,4))

# ══ SECTION 4: CLINICAL FEATURES ══════════════════════
story.append(sub_hdr('4.  CLINICAL FEATURES  -  The Classic QUARTET', BLUE))
story.append(Spacer(1,3))

quartet = [
    [Paragraph(b('SYMPTOM'), BULL), Paragraph(b('SMALL BOWEL'), BULL), Paragraph(b('LARGE BOWEL'), BULL)],
    [Paragraph(c('Pain','#7030A0'), BULL),
     Paragraph('Colicky, central/periumbilical, EARLY, severe', BULL),
     Paragraph('Lower abdomen, less severe, late onset', BULL)],
    [Paragraph(c('Vomiting','#7030A0'), BULL),
     Paragraph('EARLY, profuse, causes rapid dehydration; becomes faeculent (bacterial overgrowth)', BULL),
     Paragraph('LATE or absent in low obstruction', BULL)],
    [Paragraph(c('Distension','#7030A0'), BULL),
     Paragraph('Minimal in HIGH SBO; marked in LOW SBO. Visible peristalsis may be seen', BULL),
     Paragraph('EARLY and pronounced. Colon proximal to obstruction distended on X-ray', BULL)],
    [Paragraph(c('Absolute Constipation','#7030A0'), BULL),
     Paragraph('Present in complete obstruction (neither faeces NOR flatus passed)', BULL),
     Paragraph('Cardinal feature. May pass flatus/faeces early (distal bowel evacuation)', BULL)],
]
qt = Table(quartet, colWidths=[W*0.2, W*0.40, W*0.40])
qt.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,0), NAV),
    ('TEXTCOLOR',(0,0),(-1,0), WHITE),
    ('ROWBACKGROUNDS',(0,1),(-1,-1),[colors.HexColor('#F3E8FF'), WHITE]),
    ('BOX',(0,0),(-1,-1),1,PURPLE),
    ('INNERGRID',(0,0),(-1,-1),0.5,colors.HexColor('#CCCCCC')),
    ('TOPPADDING',(0,0),(-1,-1),4),('BOTTOMPADDING',(0,0),(-1,-1),4),
    ('LEFTPADDING',(0,0),(-1,-1),6),
    ('VALIGN',(0,0),(-1,-1),'TOP'),
]))
story.append(qt)
story.append(Spacer(1,3))

story.append(box([
    Paragraph(f'🔑  {b("Absolute constipation does NOT apply in:")}', WARN),
    Paragraph("Richter's hernia | Gallstone ileus | Mesenteric vascular occlusion | "
              "Functional obstruction with pelvic abscess | Partial obstruction", BULL),
], LTYELL, ORANGE))
story.append(Spacer(1,4))

# ══ SECTION 5: SPECIAL TYPES ══════════════════════════
story.append(sub_hdr('5.  SPECIAL TYPES OF MECHANICAL OBSTRUCTION', BLUE))
story.append(Spacer(1,3))

spec_data = [
    [Paragraph(b('TYPE'), BULL), Paragraph(b('KEY FACTS'), BULL), Paragraph(b('MCQ POINTS'), BULL)],
    [Paragraph(c('Closed-loop\nObstruction','#1F3864'), BULL),
     Paragraph('Bowel obstructed at BOTH ends. Distension confined to loop. Classic = malignant stricture of colon + competent ileocaecal valve', BULL),
     Paragraph('Ileocaecal valve competent → caecal distension greatest (most vulnerable to ischaemia)', BULL)],
    [Paragraph(c('Volvulus','#C0143C'), BULL),
     Paragraph('Twisting >180° (obstruction) or >360° (vascular occlusion). Most common spontaneous type in adults = SIGMOID. Neonatal midgut = life-threatening', BULL),
     Paragraph('Sigmoid: anticlockwise rotation. Predisposed by: African population, high-residue diet, chronic constipation. Coffee-bean sign on X-ray', BULL)],
    [Paragraph(c('Intussusception','#375623'), BULL),
     Paragraph('One segment invaginates into adjacent. Peak: 5-10 months. 90% idiopathic in children. Most common type = ILEOCOLIC (77%)', BULL),
     Paragraph('"Redcurrant jelly" stool. Sausage-shaped lump. Sign of Dance (emptiness RIF). Target sign on CT/USS. Radiological reduction first-line in children', BULL)],
    [Paragraph(c('Adhesions','#7030A0'), BULL),
     Paragraph('#1 cause of SBO in western world. Forms within hours of abdominal surgery. Most common site: lower small bowel', BULL),
     Paragraph('Risk of adhesional SBO after any laparotomy = 4%. Risk of laparotomy for adhesions = 2%', BULL)],
    [Paragraph(c('Gallstone Ileus','#C55A11'), BULL),
     Paragraph('Large gallstone erodes through gallbladder → duodenum → impacts ~60 cm proximal to ileocaecal valve', BULL),
     Paragraph("Rigler's Triad: SBO + pneumobilia + ectopic gallstone shadow. Seen in 40-50% of cases", BULL)],
]
st = Table(spec_data, colWidths=[W*0.18, W*0.42, W*0.40])
st.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,0), NAV),
    ('TEXTCOLOR',(0,0),(-1,0), WHITE),
    ('ROWBACKGROUNDS',(0,1),(-1,-1),[LTBLUE, WHITE, LTGRN, WHITE, LTYELL]),
    ('BOX',(0,0),(-1,-1),1,BLUE),
    ('INNERGRID',(0,0),(-1,-1),0.5,colors.HexColor('#CCCCCC')),
    ('TOPPADDING',(0,0),(-1,-1),4),('BOTTOMPADDING',(0,0),(-1,-1),4),
    ('LEFTPADDING',(0,0),(-1,-1),6),
    ('VALIGN',(0,0),(-1,-1),'TOP'),
]))
story.append(st)
story.append(Spacer(1,4))

# ══ SECTION 6: IMAGING ════════════════════════════════
story.append(sub_hdr('6.  IMAGING  -  HIGH YIELD RADIOLOGY', BLUE))
story.append(Spacer(1,3))
story.append(Paragraph(b('Plain X-ray (Supine Abdominal Film) - Summary Box 78.9:'), H3))

img_data = [
    [Paragraph(b('BOWEL'), BULL), Paragraph(b('RADIOLOGICAL FEATURE'), BULL)],
    [Paragraph('Jejunum', BULL), Paragraph('Valvulae conniventes - cross ENTIRE width of bowel, regularly spaced → "Concertina / Ladder pattern"', BULL)],
    [Paragraph('Ileum', BULL), Paragraph('Featureless (no markings)', BULL)],
    [Paragraph('Colon', BULL), Paragraph('Haustral folds - do NOT cross entire width, irregularly spaced', BULL)],
    [Paragraph('Caecum', BULL), Paragraph('Rounded gas shadow in RIGHT ILIAC FOSSA', BULL)],
    [Paragraph('SBO on erect film', BULL), Paragraph('"Stepladder" fluid levels with gas above', BULL)],
]
it = Table(img_data, colWidths=[W*0.2, W*0.8])
it.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,0), colors.HexColor('#2F528F')),
    ('TEXTCOLOR',(0,0),(-1,0), WHITE),
    ('ROWBACKGROUNDS',(0,1),(-1,-1),[LTBLUE, WHITE]),
    ('BOX',(0,0),(-1,-1),1,BLUE),
    ('INNERGRID',(0,0),(-1,-1),0.5,colors.HexColor('#CCCCCC')),
    ('TOPPADDING',(0,0),(-1,-1),3),('BOTTOMPADDING',(0,0),(-1,-1),3),
    ('LEFTPADDING',(0,0),(-1,-1),6),
    ('VALIGN',(0,0),(-1,-1),'TOP'),
]))
story.append(it)
story.append(Spacer(1,3))

story.append(box([
    Paragraph(f'🔑  {b("CT features of strangulation (Summary Box 78.10):")}', WARN),
    Paragraph('• Reduced bowel wall enhancement on CT → ↑ probability of strangulation', BULL),
    Paragraph('• Absence of mesenteric fluid on CT → ↓ probability of strangulation', BULL),
    Paragraph('• CT is most accurate overall for diagnosing intestinal obstruction (gold standard)', BULL),
    Paragraph(f'• {b("Barium follow-through is CONTRAINDICATED")} in acute obstruction (life-threatening)', BULL),
], LTYELL, ORANGE))
story.append(Spacer(1,4))

# ══ SECTION 7: TREATMENT ══════════════════════════════
story.append(sub_hdr('7.  TREATMENT  -  Summary Box 78.11', GREEN))
story.append(Spacer(1,3))

treat_data = [
    [Paragraph(b('STEP'), BULL), Paragraph(b('ACTION'), BULL), Paragraph(b('DETAILS'), BULL)],
    [Paragraph(c('1','#375623'), BULL),
     Paragraph('Resuscitation (GI Drainage)', BULL),
     Paragraph('NGT (nasogastric tube) - "drip and suck". Fluid replacement. Catheter for urine output monitoring', BULL)],
    [Paragraph(c('2','#375623'), BULL),
     Paragraph('Fluid & Electrolyte correction', BULL),
     Paragraph('IV fluids (Normal saline + K+ replacement). Monitor dehydration, electrolytes, urine output', BULL)],
    [Paragraph(c('3','#375623'), BULL),
     Paragraph('Relief of obstruction', BULL),
     Paragraph('Conservative first in simple SBO (adhesions may resolve). SURGERY if: complete, strangulation, closed-loop, or no improvement in 24-48h', BULL)],
]
tt = Table(treat_data, colWidths=[W*0.08, W*0.28, W*0.64])
tt.setStyle(TableStyle([
    ('BACKGROUND',(0,0),(-1,0), GREEN),
    ('TEXTCOLOR',(0,0),(-1,0), WHITE),
    ('ROWBACKGROUNDS',(0,1),(-1,-1),[LTGRN, WHITE]),
    ('BOX',(0,0),(-1,-1),1,GREEN),
    ('INNERGRID',(0,0),(-1,-1),0.5,colors.HexColor('#CCCCCC')),
    ('TOPPADDING',(0,0),(-1,-1),4),('BOTTOMPADDING',(0,0),(-1,-1),4),
    ('LEFTPADDING',(0,0),(-1,-1),6),
    ('VALIGN',(0,0),(-1,-1),'TOP'),
]))
story.append(tt)
story.append(Spacer(1,3))

story.append(box([
    Paragraph(f'⚠️  {b("ABSOLUTE indications for immediate surgery:")}', WARN),
    Paragraph('• Strangulation (or suspected strangulation)', BULL),
    Paragraph('• Closed-loop obstruction', BULL),
    Paragraph('• Complete LBO (large bowel obstruction) - does not resolve with conservative management', BULL),
    Paragraph('• Caecal diameter >9-10 cm (risk of perforation)', BULL),
], LTPINK, PINK))
story.append(Spacer(1,4))

# ══ SECTION 8: MNEMONICS ══════════════════════════════
story.append(sub_hdr('8.  MNEMONICS  🧠', PURPLE))
story.append(Spacer(1,3))

mnemonics = [
    ('Classic Quartet of Obstruction:', '"PAVD" - Pain, Absolute constipation, Vomiting, Distension'),
    ("Causes of Dynamic SBO (Intraluminal):", '"FBI Go" - Faecal impaction, Bezoars, Intussusception, Gallstones, Objects (foreign bodies)'),
    ("Rigler's Triad (Gallstone Ileus):", '"PSE" - Pneumobilia, SBO (stepladder), Ectopic gallstone'),
    ('Causes of Strangulation:', '"HBV + CI" - Hernia, Bands/adhesions, Volvulus, Intussusception, Closed-loop'),
    ('Intussusception in Children (Classic 4):', '"RSSD" - Redcurrant jelly stool, Screaming baby, Sausage lump, Sign of Dance (empty RIF)'),
    ('Sigmoid Volvulus vs Caecal Volvulus:', 'Sigmoid = anticlockwise; Caecal = clockwise; Sigmoid = more common in adults/Africa'),
]
for title, content in mnemonics:
    story.append(box([
        Paragraph(f'🔑  {b(title)}', MNEM),
        Paragraph(content, BULL),
    ], colors.HexColor('#F3E8FF'), PURPLE))
    story.append(Spacer(1,2))

story.append(Spacer(1,4))

# ══ SECTION 9: MCQ PRACTICE ═══════════════════════════
story.append(sub_hdr('9.  PRACTICE MCQs WITH EXPLANATIONS', PINK))
story.append(Spacer(1,3))

mcqs = [
    {
        'q': 'Q1. A 65-year-old man presents with colicky abdominal pain, vomiting, distension and absolute constipation. Plain X-ray shows dilated small bowel loops with a "stepladder" fluid level pattern. What is the MOST LIKELY cause?',
        'options': ['A. Paralytic ileus', 'B. Adhesions from previous appendicectomy', 'C. Carcinoma of sigmoid colon', 'D. Volvulus of sigmoid colon'],
        'answer': 'B. Adhesions',
        'explanation': 'Adhesions are the #1 cause of small bowel obstruction (40%). The stepladder pattern = SBO on erect AXR. Paralytic ileus has no mechanical cause. Carcinoma causes LBO not SBO typically. Volvulus would show a coffee-bean sign.',
        'color': LTGRN,
    },
    {
        'q': 'Q2. An 8-month-old baby presents with intermittent episodes of screaming, drawing up of legs, pallor, and passing "redcurrant jelly" stool. The most likely diagnosis is:',
        'options': ['A. Hirschsprung disease', 'B. Meckel diverticulum', 'C. Intussusception', 'D. Malrotation'],
        'answer': 'C. Intussusception',
        'explanation': 'Classic intussusception triad: screaming baby (intermittent colic), redcurrant jelly stool (blood + mucus), sausage-shaped abdominal lump. Peak age 5-10 months. 90% idiopathic. Most common type = ileocolic (77%).',
        'color': LTBLUE,
    },
    {
        'q': "Q3. Which of the following is the PATHOGNOMONIC radiological sign of gallstone ileus?",
        'options': ["A. Stepladder pattern", "B. Coffee-bean sign", "C. Rigler's triad (SBO + pneumobilia + ectopic stone)", "D. Target sign"],
        'answer': "C. Rigler's Triad",
        'explanation': "Rigler's triad = SBO + pneumobilia (gas in biliary tree) + ectopic gallstone shadow on X-ray. Found in 40-50% of gallstone ileus cases. Gallstone erodes through gallbladder → duodenum → impacts 60cm proximal to ileocaecal valve.",
        'color': LTYELL,
    },
    {
        'q': 'Q4. A 70-year-old African male presents with features of large bowel obstruction. X-ray shows a grossly distended loop of bowel in the left side of abdomen resembling a "coffee bean." Most likely diagnosis:',
        'options': ['A. Caecal volvulus', 'B. Sigmoid volvulus', 'C. Carcinoma colon', 'D. Pseudo-obstruction'],
        'answer': 'B. Sigmoid volvulus',
        'explanation': 'Sigmoid volvulus is the most common cause of LBO in African and Eastern European populations. Coffee-bean sign = pathognomonic on AXR. The sigmoid rotates anticlockwise. Predisposing factors: high-residue diet, chronic constipation, elderly. Treatment: rectal tube decompression / sigmoidoscopy first, then surgery.',
        'color': LTPINK,
    },
    {
        'q': 'Q5. Which finding on CT scan INCREASES the probability of strangulation in intestinal obstruction?',
        'options': ['A. Absence of mesenteric fluid', 'B. Reduced bowel wall enhancement', 'C. Free gas in abdomen', 'D. Multiple air-fluid levels'],
        'answer': 'B. Reduced bowel wall enhancement',
        'explanation': 'Reduced bowel wall enhancement on CT = compromised blood supply = ischaemia/strangulation. Absence of mesenteric fluid DECREASES probability of strangulation. Free gas = perforation (not specifically strangulation). CT is the gold standard for diagnosing obstruction and strangulation.',
        'color': LTGRN,
    },
    {
        'q': 'Q6. A patient with intestinal obstruction has a competent ileocaecal valve. Which part of the bowel is at GREATEST risk of perforation?',
        'options': ['A. Terminal ileum', 'B. Sigmoid colon', 'C. Caecum', 'D. Rectum'],
        'answer': 'C. Caecum',
        'explanation': 'In LBO with a competent ileocaecal valve → closed-loop obstruction. Gas cannot decompress into small bowel. The caecum is widest and has greatest wall tension (Law of Laplace). Caecal diameter >9-10 cm = risk of perforation → emergency surgery.',
        'color': LTBLUE,
    },
    {
        'q': 'Q7. Which of the following is a CONTRAINDICATION in suspected acute intestinal obstruction?',
        'options': ['A. CT scan abdomen', 'B. Erect chest X-ray', 'C. Barium follow-through', 'D. Water-soluble contrast enema'],
        'answer': 'C. Barium follow-through',
        'explanation': 'Barium is contraindicated in acute obstruction because if perforation occurs, barium leakage into peritoneal cavity is life-threatening (barium peritonitis). Water-soluble contrast (e.g., Gastrografin) is safe and can also be therapeutic in adhesional SBO. CT is the investigation of choice.',
        'color': LTYELL,
    },
    {
        'q': 'Q8. Absolute constipation is NOT a feature in which of the following?',
        'options': ["A. Complete SBO", "B. Complete LBO with incompetent ileocaecal valve", "C. Richter's hernia", "D. High SBO"],
        'answer': "C. Richter's hernia",
        'explanation': "Absolute constipation does NOT apply in: Richter's hernia (only part of bowel wall is trapped, lumen not fully blocked), gallstone ileus, mesenteric vascular occlusion, functional obstruction with pelvic abscess, and partial obstruction. In Richter's hernia, bowel lumen is not fully obstructed so flatus/stool may still pass.",
        'color': LTPINK,
    },
]

for i, mcq in enumerate(mcqs):
    q_rows = [
        [Paragraph(mcq['q'], BODY)],
    ]
    for opt in mcq['options']:
        q_rows.append([Paragraph(f'    {opt}', BULL)])
    q_rows.append([Paragraph(f'✅  {b("Answer:")} {mcq["answer"]}', WARN)])
    q_rows.append([Paragraph(f'💡  {b("Explanation:")} {mcq["explanation"]}', SMALL)])

    qt = Table(q_rows, colWidths=[W])
    qt.setStyle(TableStyle([
        ('BACKGROUND',(0,0),(-1,-1), mcq['color']),
        ('BACKGROUND',(0,0),(0,0), colors.HexColor('#2F528F')),
        ('TEXTCOLOR',(0,0),(0,0), WHITE),
        ('BOX',(0,0),(-1,-1),1,BLUE),
        ('TOPPADDING',(0,0),(-1,-1),3),('BOTTOMPADDING',(0,0),(-1,-1),3),
        ('LEFTPADDING',(0,0),(-1,-1),8),('RIGHTPADDING',(0,0),(-1,-1),6),
        ('VALIGN',(0,0),(-1,-1),'TOP'),
    ]))
    story.append(KeepTogether(qt))
    story.append(Spacer(1,5))

# ══ FOOTER ════════════════════════════════════════════
story.append(HRFlowable(width=W, thickness=1, color=NAV))
story.append(Paragraph(
    'Block Exam Prep  |  Surgery: Intestinal Obstruction  |  Source: Bailey & Love Chapter 78  |  Created by Orris',
    S('footer', fontSize=7, textColor=colors.HexColor('#888888'), alignment=TA_CENTER)
))

# ── BUILD ──────────────────────────────────────────────
doc.build(story)
print(f"PDF saved: {OUTPUT}")

cd /home/daytona/workspace/block-exam-prep && python intestinal_obstruction_pdf.…