import openpyxl
from openpyxl.styles import (
    PatternFill, Font, Alignment, Border, Side, GradientFill
)
from openpyxl.utils import get_column_letter
from openpyxl.worksheet.datavalidation import DataValidation

wb = openpyxl.Workbook()

# ── Colour palette ──────────────────────────────────────────────
C_HEADER_BG   = "1F4E79"   # dark navy
C_HEADER_FG   = "FFFFFF"
C_PHASE1_BG   = "D6E4F0"   # light blue  – Medicine/Pharm/Biochem
C_PHASE2_BG   = "E2EFDA"   # light green – Path/Surgery/PSM
C_BREAK_BG    = "FFF2CC"   # yellow      – breaks
C_PYQ_BG      = "FCE4D6"   # peach       – PYQ
C_TD_BG       = "EAD1DC"   # pink        – T&D
C_DONE_BG     = "C6EFCE"   # green tick
C_PEND_BG     = "FFEB9C"   # amber
C_MISS_BG     = "FFC7CE"   # red miss
C_ALT1        = "F2F7FB"
C_ALT2        = "FFFFFF"
C_SUBJ = {
    "Medicine":    "D6E4F0",
    "Pharmacology":"DDEBF7",
    "Biochemistry":"BDD7EE",
    "Pathology":   "E2EFDA",
    "Surgery":     "C6EFCE",
    "PSM":         "EBF3E8",
    "All Subjects":"F0EBF8",
    "BREAK":       "FFF2CC",
    "LUNCH BREAK": "FFE699",
    "DINNER":      "FFE699",
    "PYQ":         "FCE4D6",
    "T&D":         "EAD1DC",
    "REST":        "F2F2F2",
}

def fill(hex_col):
    return PatternFill("solid", fgColor=hex_col)

def font(bold=False, color="000000", size=10, italic=False):
    return Font(name="Arial", bold=bold, color=color, size=size, italic=italic)

def border_thin():
    s = Side(style="thin", color="BFBFBF")
    return Border(left=s, right=s, top=s, bottom=s)

def border_medium():
    s = Side(style="medium", color="2F75B6")
    return Border(left=s, right=s, top=s, bottom=s)

def center_align(wrap=True):
    return Alignment(horizontal="center", vertical="center", wrap_text=wrap)

def left_align(wrap=True):
    return Alignment(horizontal="left", vertical="center", wrap_text=wrap)

# ════════════════════════════════════════════════════════════════
# SHEET 1 – OVERVIEW DASHBOARD
# ════════════════════════════════════════════════════════════════
ws_dash = wb.active
ws_dash.title = "📊 Dashboard"
ws_dash.sheet_view.showGridLines = False

# Title row
ws_dash.merge_cells("A1:K1")
ws_dash["A1"] = "🩺  NEET-PG 2026 — 15-Day Study Tracker"
ws_dash["A1"].font = Font(name="Arial", bold=True, size=16, color="FFFFFF")
ws_dash["A1"].fill = fill(C_HEADER_BG)
ws_dash["A1"].alignment = center_align()
ws_dash.row_dimensions[1].height = 36

# Sub-header
ws_dash.merge_cells("A2:K2")
ws_dash["A2"] = "July 15 – July 30, 2026  |  13 hrs/day  |  Medicine · Pharmacology · Biochemistry · Pathology · Surgery · PSM"
ws_dash["A2"].font = Font(name="Arial", italic=True, size=10, color="1F4E79")
ws_dash["A2"].fill = fill("D6E4F0")
ws_dash["A2"].alignment = center_align()
ws_dash.row_dimensions[2].height = 20

ws_dash.row_dimensions[3].height = 8

# Column headers for overview table
headers = ["Day", "Date", "Phase", "Primary Subject(s)", "Key Topics", "Study Hrs", "PYQ Done?", "T&D Done?", "MCQ Score", "Notes", "Status"]
col_widths = [5, 13, 10, 24, 52, 10, 12, 12, 12, 28, 12]
for i, (h, w) in enumerate(zip(headers, col_widths), start=1):
    cell = ws_dash.cell(row=4, column=i, value=h)
    cell.font = font(bold=True, color="FFFFFF", size=10)
    cell.fill = fill(C_HEADER_BG)
    cell.alignment = center_align()
    cell.border = border_thin()
    ws_dash.column_dimensions[get_column_letter(i)].width = w

ws_dash.row_dimensions[4].height = 22

# ── Daily data ──────────────────────────────────────────────────
days = [
    # (day, date_str, phase, subjects, key_topics)
    (1,  "Wed 15 Jul", "Phase 1A", "Medicine + Pharmacology",
     "ECG & Arrhythmias · VHD + HF + JVP · CAD + Aorta | Antihypertensives · Antiarrhythmics · Anticoagulants · Antiemetics"),
    (2,  "Thu 16 Jul", "Phase 1A", "Medicine + Pharmacology",
     "ABG/RTA · Electrolytes · DKA & HHS | NSAIDs · Anti-TB · Antimuscarinic · PK/PD"),
    (3,  "Fri 17 Jul", "Phase 1A", "Medicine + Pharmacology",
     "HIV · Malabsorption · Cirrhosis · Pleural Disease | Antimicrobials · Antifungals · Antimalarials · Antiparkinsonians"),
    (4,  "Sat 18 Jul", "Phase 1A", "Medicine + Pharmacology",
     "CVS Revision · Endocrine/Renal/CNS Revision · All 12 Pharm topics Revision · 100-Q MCQ Drill"),
    (5,  "Sun 19 Jul", "Phase 1B", "Biochemistry",
     "Vitamins (15×) · Lysosomal SD (6×) · Glycogen SD (4×) · Alkaptonuria · FH · Homocystinuria · Metabolic Cycles · Inhibition · Minerals"),
    (6,  "Mon 20 Jul", "Phase 1B", "Biochemistry + Revision",
     "Biochem Full Revision · Medicine weak spots · Pharm revision · Phase 1 integrated 80-Q drill"),
    (7,  "Tue 21 Jul", "Phase 2",  "Pathology + Surgery + PSM",
     "Genetics & Syndromes (8×) · Leukaemia (8×) · Lymphoma (5×) · HbDisorders | Breast Ca · Inguinal Hernia | Biomedical Waste · Parametric Tests"),
    (8,  "Wed 22 Jul", "Phase 2",  "Pathology + Surgery + PSM",
     "Intestinal Dis · Tumors · Lung Ca/Thymoma · Glomerular | Triage · GCS · Aortic Dis · PAD/Leriche | Vit Deficiency · Case-Control"),
    (9,  "Thu 23 Jul", "Phase 2",  "Pathology + Surgery + PSM",
     "Thyroid · Myeloma/Amyloid · Coagulation · IDA · Macrocytic | Fistula-in-Ano · Hollow Viscus · Hydatid · Oesoph Varices · Rectal Ca | Disaster · Vaccines · Varicella"),
    (10, "Fri 24 Jul", "Phase 2",  "Pathology + Surgery + PSM",
     "Inflammation · General Path · WBC Revision | SAH · Cystourethroscope · Penile Ca · remaining Surg | Kata Thermometer · Demography · ASHA · Regression"),
    (11, "Sat 25 Jul", "Phase 2",  "Pathology + Surgery + PSM",
     "Haematology Revision · Biostatistics Revision · Surgery Top-8 Revision · 90-Q Mock + Analysis"),
    (12, "Sun 26 Jul", "Phase 2",  "Path + Med + Pharm + Surgery + PSM",
     "Solid Tumours Revision · ECG/DKA Revision · Antihypertensives/Anticoag Revision · Onco-Surgery Revision · PSM Full Revision"),
    (13, "Mon 27 Jul", "Phase 2",  "Biochem + Medicine + Path + Surgery + PSM",
     "Biochem Rapid Revision · Medicine Renal Revision · 50-Q Path Drill · 50-Q Surgery Drill · 40-Q PSM Drill"),
    (14, "Tue 28 Jul", "Phase 2",  "Medicine + Pharmacology",
     "CNS/Vasculitis Revision · Endocrine Revision · Antimicrobials Revision · 120-Q Full Mock + Analysis"),
    (15, "Wed 29 Jul", "Phase 3",  "All Subjects – Final Revision",
     "Flash Revision all subjects · Path Final · Surgery+PSM Final · Med+Pharm+Biochem Final · 100-Q Confidence Mock"),
    (16, "Thu 30 Jul", "Phase 3",  "Light Revision + REST",
     "Weak areas only · 30-Q Rapid-fire PYQs · Formula/Chart Recap · REST from 12:00 PM"),
]

phase_colors = {
    "Phase 1A": "D6E4F0",
    "Phase 1B": "BDD7EE",
    "Phase 2":  "E2EFDA",
    "Phase 3":  "F0EBF8",
}

dv_done = DataValidation(type="list", formula1='"✅ Done,⏳ Pending,❌ Missed"', allow_blank=True)
dv_status = DataValidation(type="list", formula1='"✅ Complete,🔄 In Progress,⏳ Not Started"', allow_blank=True)
ws_dash.add_data_validation(dv_done)
ws_dash.add_data_validation(dv_status)

for idx, (day, date, phase, subj, topics) in enumerate(days):
    row = 5 + idx
    bg = phase_colors.get(phase, "F2F2F2")
    alt = "F7FBFF" if idx % 2 == 0 else "FFFFFF"

    data = [day, date, phase, subj, topics, 13, "", "", "", "", "⏳ Not Started"]
    for col, val in enumerate(data, start=1):
        c = ws_dash.cell(row=row, column=col, value=val)
        c.font = font(size=9)
        c.border = border_thin()
        c.alignment = left_align() if col in (4, 5, 10) else center_align()
        if col == 3:
            c.fill = fill(bg)
            c.font = font(bold=True, size=9, color="1F4E79")
        elif col in (1, 2):
            c.fill = fill(alt)
            c.font = font(bold=(col==1), size=9)
        elif col == 6:
            c.fill = fill("EBF3E8")
            c.font = font(bold=True, size=9, color="375623")
        else:
            c.fill = fill(alt)

    ws_dash.row_dimensions[row].height = 40

    # dropdowns
    dv_done.add(ws_dash.cell(row=row, column=7))
    dv_done.add(ws_dash.cell(row=row, column=8))
    dv_status.add(ws_dash.cell(row=row, column=11))

# Freeze panes
ws_dash.freeze_panes = "A5"

# Progress summary block (below table)
summary_row = 5 + len(days) + 2
ws_dash.merge_cells(f"A{summary_row}:C{summary_row}")
ws_dash[f"A{summary_row}"] = "PROGRESS SUMMARY"
ws_dash[f"A{summary_row}"].font = font(bold=True, color="FFFFFF", size=11)
ws_dash[f"A{summary_row}"].fill = fill(C_HEADER_BG)
ws_dash[f"A{summary_row}"].alignment = center_align()

labels = ["Total Days", "Days Complete", "Days In Progress", "Days Not Started", "Overall Progress %"]
for i, lbl in enumerate(labels):
    r = summary_row + 1 + i
    ws_dash[f"A{r}"] = lbl
    ws_dash[f"A{r}"].font = font(bold=True, size=9)
    ws_dash[f"A{r}"].fill = fill("D6E4F0")
    ws_dash[f"A{r}"].border = border_thin()
    ws_dash[f"B{r}"] = ""
    ws_dash[f"B{r}"].border = border_thin()
    ws_dash[f"B{r}"].alignment = center_align()
    ws_dash[f"B{r}"].font = font(size=9)

ws_dash[f"B{summary_row+1}"] = 16
ws_dash[f"B{summary_row+1}"].font = font(bold=True, size=9)

# Legend
legend_row = summary_row + 8
ws_dash[f"A{legend_row}"] = "LEGEND"
ws_dash[f"A{legend_row}"].font = font(bold=True, color="FFFFFF")
ws_dash[f"A{legend_row}"].fill = fill(C_HEADER_BG)
ws_dash.merge_cells(f"A{legend_row}:B{legend_row}")
ws_dash[f"A{legend_row}"].alignment = center_align()

legend_items = [
    ("Phase 1A", "D6E4F0", "Medicine + Pharmacology (July 15–18)"),
    ("Phase 1B", "BDD7EE", "Biochemistry (July 19–20)"),
    ("Phase 2",  "E2EFDA", "Pathology + Surgery + PSM (July 21–28)"),
    ("Phase 3",  "F0EBF8", "Final Revision + REST (July 29–30)"),
]
for i, (lbl, col, desc) in enumerate(legend_items):
    r = legend_row + 1 + i
    ws_dash[f"A{r}"] = lbl
    ws_dash[f"A{r}"].fill = fill(col)
    ws_dash[f"A{r}"].font = font(bold=True, size=9)
    ws_dash[f"A{r}"].border = border_thin()
    ws_dash[f"A{r}"].alignment = center_align()
    ws_dash[f"B{r}"] = desc
    ws_dash[f"B{r}"].font = font(size=9)
    ws_dash[f"B{r}"].border = border_thin()
    ws_dash.merge_cells(f"B{r}:D{r}")

# ════════════════════════════════════════════════════════════════
# SHEETS 2–17 — ONE SHEET PER DAY
# ════════════════════════════════════════════════════════════════

daily_schedule = {
1: [
    ("6:00–8:00 AM",   "Study 1",  "Medicine",    "ECG, Arrhythmias & Heart Blocks (9×)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Valvular Heart Disease + Heart Failure + JVP"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","Antihypertensives (7×) + Antiarrhythmics (6×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Medicine",    "Coronary Artery Disease + Disorders of Aorta"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Pharmacology","Anticoagulants & Fibrinolytics (5×) + Antiemetics (5×)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "CVS Medicine PYQs + CVS Pharmacology PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Discuss ECG + Antiarrhythmic errors; comparison tables"),
],
2: [
    ("6:00–8:00 AM",   "Study 1",  "Medicine",    "ABG & RTA (5×) + Electrolyte Disorders (3×)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Diabetes – DKA & HHS (5×)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","NSAIDs (5×) + Anti-TB (5×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Medicine",    "Pituitary Disorders – DI & SIADH (5×) + Vasculitis (4×)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Pharmacology","Antimuscarinic (7×) + Pharmacokinetics & PD (4×)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Endocrine Medicine PYQs + Anti-TB + NSAIDs PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "DKA vs HHS comparison table + PK/PD concept discussion"),
],
3: [
    ("6:00–8:00 AM",   "Study 1",  "Medicine",    "HIV (4×) + Malabsorption Disorders (3×)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Cirrhosis & Complications – SBP, Child-Pugh, Variceal Bleed (3×)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","Antimicrobials (3×) + Antifungals (3×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Medicine",    "Pleural Disease (3×) + RS revision (completed topics)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Pharmacology","Antimalarials (3×) + Antiparkinsonians (3×)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "GI Medicine + Antimicrobials + Antifungal PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Anti-infective drug chart + doubt clearing"),
],
4: [
    ("6:00–8:00 AM",   "Study 1",  "Medicine",    "Revision – CVS block (ECG, VHD, CAD, HF)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Revision – Endocrine, Renal, CNS (rapid recap)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","Full revision – all 12 Pharm topics rapid notes"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Medicine",    "100-Q mixed timed MCQ drill (Med + Pharm)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Medicine",    "Review wrong answers + weak area consolidation"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Medicine + Pharm mixed PYQs – 50 Qs timed"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Phase 1A wrap-up – error patterns, key tables, doubt clearing"),
],
5: [
    ("6:00–8:00 AM",   "Study 1",  "Biochemistry","Vitamins (15× – highest yield)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Biochemistry","Lysosomal Storage Disorders (6×) + Glycogen Storage Disorders (4×)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Biochemistry","Alkaptonuria (3×) + Familial Hypercholesterolaemia (3×) + Homocystinuria (2×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Biochemistry","Metabolic Cycles + Enzyme Inhibition + Minerals"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Biochemistry","60-MCQ timed test (Biochemistry)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Vitamins + Storage Disorders + Metabolic Cycles PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Storage disorder comparison tables + MCQ test analysis"),
],
6: [
    ("6:00–8:00 AM",   "Study 1",  "Biochemistry","Full revision – Vitamins + Storage Disorders (tables)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Revision buffer – Medicine weak spots"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","Revision – Antihypertensives + Antiarrhythmics deep dive"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Biochemistry","Biochem full PYQ paper – last 3 years"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "All Subjects","Phase 1 integrated 80-Q drill (Med + Pharm + Biochem)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Phase 1 integrated PYQs – mixed"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Phase 1 overall wrap-up – patterns, mnemonics, tips"),
],
7: [
    ("6:00–8:00 AM",   "Study 1",  "Pathology",   "Genetics & Syndromes (8×) + Leukaemia (8×)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Pathology",   "Lymphoma (5×) + Disorders of Haemoglobin (4×)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Surgery",     "Breast Cancer (5×) + Inguinal Hernia (5×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "PSM",         "Biomedical Waste Management (6×) + Parametric Tests (5×)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Surgery",     "Bladder Carcinoma (4×) + Oral Cavity Cancer (4×)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Haematology Path + Surgery onco + PSM Waste PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Leukaemia vs Lymphoma table + Surgery staging charts"),
],
8: [
    ("6:00–8:00 AM",   "Study 1",  "Pathology",   "Intestinal Disorders (5×) + Tumors (4×)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Pathology",   "Carcinoma Lung & Thymoma (4×) + Glomerular Diseases (4×)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Surgery",     "Triage/Trauma (4×) + Glasgow Coma Scale (3×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "PSM",         "Vitamin Deficiency (5×) + Case-Control/Cohort Study (4×)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Surgery",     "Aortic Dissection (3×) + Peripheral Arterial Disease / Leriche's Syndrome (3×)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Solid tumor Path + PSM Biostatistics + Vascular Surgery PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Study design flowchart + GCS scoring + Lung tumor types"),
],
9: [
    ("6:00–8:00 AM",   "Study 1",  "Pathology",   "Thyroid (4×) + Multiple Myeloma & Amyloid (3×)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Pathology",   "Coagulation Disorders (3×) + IDA (3×) + Macrocytic Anaemia (3×)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Surgery",     "Fistula in Ano (3×) + Hollow Viscus Perforation (3×) + Hydatid Cyst (3×)"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "PSM",         "Disaster Management (4×) + Vaccines/Immunisation (3×) + Varicella (3×)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Surgery",     "Oesophageal Varices (3×) + Rectal Carcinoma (3×) + Penile Carcinoma (4×)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Coagulation + Anaemia Path + GI Surgery + Vaccines PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Anaemia differentiation table + Myeloma vs Amyloid recap"),
],
10: [
    ("6:00–8:00 AM",   "Study 1",  "Pathology",   "Inflammation (3×) + remaining General Path topics"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Pathology",   "WBC disorders – revision + remaining sub-topics"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Surgery",     "SAH (3×) + Cystourethroscope (3×) + remaining Surgery topics"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "PSM",         "Kata Thermometer (3×) + Demography (2×) + ASHA (2×) + Coeff. of Regression (2×)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "Pathology",   "60-Q MCQ revision drill (Path + Surgery mixed)"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "General Path + WBC + PSM Environment/Demography PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Inflammation classification + PSM stats formulas recap"),
],
11: [
    ("6:00–8:00 AM",   "Study 1",  "Pathology",   "Revision – Haematology block (Leukaemia, Lymphoma, Myeloma, Coagulation)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "PSM",         "Biostatistics full revision – Parametric tests + Regression + Study designs"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Surgery",     "Revision – Top 8 Surgery topics rapid recap"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "All Subjects","90-Q mixed timed mock test (Path + Surgery + PSM)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "All Subjects","Full mock analysis – wrong answers by subject"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Path + Surgery mixed PYQs – 40 Qs each"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Key PYQ patterns + high-frequency concept revision"),
],
12: [
    ("6:00–8:00 AM",   "Study 1",  "Pathology",   "Revision – Solid tumors block (Lung, GI, Thyroid, Glomerular)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Rapid revision – ECG/Arrhythmias + DKA/HHS"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","Rapid revision – Antihypertensives + Anticoagulants + Antimuscarinic"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Surgery",     "Revision – Onco-surgery (Breast, Oral, Bladder, Penile, Rectal)"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "PSM",         "Full PSM revision – all 11 topics rapid notes"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Path solid tumors + Med + Pharm PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Cross-subject integration – Cirrhosis in Med/Path/Surgery overlap"),
],
13: [
    ("6:00–8:00 AM",   "Study 1",  "Biochemistry","Rapid revision – Vitamins + Storage Disorders"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Revision – Renal topics + Electrolyte Disorders"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pathology",   "MCQ drill – 50 Path Qs timed"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Surgery",     "MCQ drill – 50 Surgery Qs timed"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "PSM",         "MCQ drill – 40 PSM Qs timed"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Biochem + Medicine Renal PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Path + Surgery + PSM drill analysis – error patterns"),
],
14: [
    ("6:00–8:00 AM",   "Study 1",  "Medicine",    "Revision – CNS topics (completed) + Vasculitis"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Medicine",    "Revision – Endocrine block (Pituitary, Diabetes, Cirrhosis)"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Pharmacology","Revision – Antimicrobials + Anti-TB + Antimalarials"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "All Subjects","120-Q full mock – all subjects"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "All Subjects","Full mock analysis – rank weak subjects"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Medicine CNS + Endocrine + Pharm Antimicrobials PYQs"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Final doubt clearing – all subjects, plan Day 15 priorities"),
],
15: [
    ("6:00–8:00 AM",   "Study 1",  "All Subjects","Flash revision – top 3 topics per subject (15 min each)"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + walk"),
    ("8:30–10:30 AM",  "Study 2",  "Pathology",   "Final revision – Genetics, Leukaemia, Lymphoma, Thyroid"),
    ("10:30–11:00 AM", "BREAK",    "BREAK",       "🍎 Snack + rest eyes"),
    ("11:00 AM–1:00 PM","Study 3", "Surgery",     "Final revision – Top 8 Surgery + Top 6 PSM topics"),
    ("1:00–2:30 PM",   "LUNCH BREAK","LUNCH BREAK","🍽 Lunch + rest/nap"),
    ("2:30–4:30 PM",   "Study 4",  "Medicine",    "Final revision – Medicine + Pharm + Biochem top picks + formula sheets"),
    ("4:30–5:00 PM",   "BREAK",    "BREAK",       "🌿 Snack + walk"),
    ("5:00–7:00 PM",   "Study 5",  "All Subjects","100-Q final confidence mock"),
    ("7:00–8:00 PM",   "DINNER",   "DINNER",      "🍛 Dinner + wind down"),
    ("8:00–9:30 PM",   "PYQ",      "PYQ",         "Rapid mixed PYQs – 30 Qs across all subjects"),
    ("9:30–9:45 PM",   "BREAK",    "BREAK",       "💤 Short rest"),
    ("9:45–11:15 PM",  "T&D",      "T&D",         "Final T&D – high-yield tables, drug charts, path staging recap"),
],
16: [
    ("6:00–8:00 AM",   "Study 1",  "All Subjects","Light revision – personal weak areas only"),
    ("8:00–8:30 AM",   "BREAK",    "BREAK",       "☕ Tea + relaxed walk"),
    ("8:30–10:00 AM",  "PYQ",      "PYQ",         "Rapid-fire PYQs – 30 Qs (confidence building only)"),
    ("10:00–10:30 AM", "BREAK",    "BREAK",       "🍎 Snack + rest"),
    ("10:30 AM–12:00 PM","T&D",    "T&D",         "Formula / drug chart / staging table recap"),
    ("12:00 PM onward","REST",     "REST",         "🛌 No new topics. Relax. Early sleep."),
],
}

date_map = {
    1:"Wed 15 Jul", 2:"Thu 16 Jul", 3:"Fri 17 Jul", 4:"Sat 18 Jul",
    5:"Sun 19 Jul", 6:"Mon 20 Jul", 7:"Tue 21 Jul", 8:"Wed 22 Jul",
    9:"Thu 23 Jul", 10:"Fri 24 Jul",11:"Sat 25 Jul",12:"Sun 26 Jul",
    13:"Mon 27 Jul",14:"Tue 28 Jul",15:"Wed 29 Jul",16:"Thu 30 Jul",
}
phase_map = {
    1:"Phase 1A",2:"Phase 1A",3:"Phase 1A",4:"Phase 1A",
    5:"Phase 1B",6:"Phase 1B",
    7:"Phase 2",8:"Phase 2",9:"Phase 2",10:"Phase 2",
    11:"Phase 2",12:"Phase 2",13:"Phase 2",14:"Phase 2",
    15:"Phase 3",16:"Phase 3",
}

dv_slot = DataValidation(type="list", formula1='"✅ Done,⏳ Pending,❌ Missed,⏭ Skipped"', allow_blank=True)

for day_num in range(1, 17):
    date_str  = date_map[day_num]
    phase_str = phase_map[day_num]
    sched     = daily_schedule[day_num]
    bg        = phase_colors.get(phase_str, "F2F2F2")

    ws = wb.create_sheet(title=f"Day {day_num:02d} – {date_str}")
    ws.sheet_view.showGridLines = False
    ws.add_data_validation(dv_slot)

    # Title
    ws.merge_cells("A1:H1")
    ws["A1"] = f"Day {day_num}  |  {date_str}  |  {phase_str}"
    ws["A1"].font = Font(name="Arial", bold=True, size=14, color="FFFFFF")
    ws["A1"].fill = fill(C_HEADER_BG)
    ws["A1"].alignment = center_align()
    ws.row_dimensions[1].height = 32

    # Sub-header
    ws.merge_cells("A2:H2")
    ws["A2"] = "13 hrs/day  •  Breaks included  •  PYQ 1.5 hrs  •  T&D 1.5 hrs"
    ws["A2"].font = Font(name="Arial", italic=True, size=9, color="1F4E79")
    ws["A2"].fill = fill("D6E4F0")
    ws["A2"].alignment = center_align()
    ws.row_dimensions[2].height = 16

    ws.row_dimensions[3].height = 6

    # Column headers
    col_headers = ["Time Slot", "Block", "Subject", "Topic / Activity", "Status", "MCQ Score\n(if applicable)", "Notes", "Confidence\n(1-5)"]
    col_widths_d = [18, 12, 16, 52, 16, 16, 28, 14]
    for ci, (h, cw) in enumerate(zip(col_headers, col_widths_d), start=1):
        c = ws.cell(row=4, column=ci, value=h)
        c.font = font(bold=True, color="FFFFFF", size=9)
        c.fill = fill(C_HEADER_BG)
        c.alignment = center_align()
        c.border = border_thin()
        ws.column_dimensions[get_column_letter(ci)].width = cw
    ws.row_dimensions[4].height = 30

    for si, (time_slot, block_type, subject, topic) in enumerate(sched):
        row = 5 + si
        subj_bg = C_SUBJ.get(subject, C_SUBJ.get(block_type, "F2F2F2"))
        is_break = block_type in ("BREAK", "LUNCH BREAK", "DINNER", "REST")

        row_data = [time_slot, block_type, subject if not is_break else "", topic, "", "", "", ""]
        for ci, val in enumerate(row_data, start=1):
            c = ws.cell(row=row, column=ci, value=val)
            c.border = border_thin()
            c.alignment = center_align() if ci != 4 else left_align()
            if is_break:
                c.fill = fill(subj_bg)
                c.font = font(italic=True, size=9, color="7F6000" if block_type in ("LUNCH BREAK","DINNER") else "595959")
            else:
                c.fill = fill(subj_bg)
                c.font = font(bold=(ci in (1,2)), size=9)
        ws.row_dimensions[row].height = 22

        if not is_break:
            dv_slot.add(ws.cell(row=row, column=5))

    # Totals row
    tot_row = 5 + len(sched) + 1
    ws.merge_cells(f"A{tot_row}:C{tot_row}")
    ws[f"A{tot_row}"] = "Daily Summary"
    ws[f"A{tot_row}"].font = font(bold=True, color="FFFFFF", size=10)
    ws[f"A{tot_row}"].fill = fill(C_HEADER_BG)
    ws[f"A{tot_row}"].alignment = center_align()

    summary_items = [
        ("Study Hours", "13 hrs"),
        ("PYQ Session", "1.5 hrs"),
        ("T&D Session", "1.5 hrs"),
        ("Total Breaks", "4 hrs 15 min"),
    ]
    for ii, (lbl, val) in enumerate(summary_items):
        r = tot_row + 1 + ii
        ws[f"A{r}"] = lbl
        ws[f"A{r}"].font = font(bold=True, size=9)
        ws[f"A{r}"].fill = fill("D6E4F0")
        ws[f"A{r}"].border = border_thin()
        ws[f"B{r}"] = val
        ws[f"B{r}"].font = font(size=9, bold=True, color="375623")
        ws[f"B{r}"].fill = fill("EBF3E8")
        ws[f"B{r}"].border = border_thin()
        ws[f"B{r}"].alignment = center_align()

    ws.freeze_panes = "A5"

# ════════════════════════════════════════════════════════════════
# SHEET 18 – SUBJECT TOPIC CHECKLIST
# ════════════════════════════════════════════════════════════════
ws_ck = wb.create_sheet("📋 Topic Checklist")
ws_ck.sheet_view.showGridLines = False

ws_ck.merge_cells("A1:F1")
ws_ck["A1"] = "NEET-PG High-Yield Topic Checklist (Dr Ganga's 180 Topics)"
ws_ck["A1"].font = Font(name="Arial", bold=True, size=13, color="FFFFFF")
ws_ck["A1"].fill = fill(C_HEADER_BG)
ws_ck["A1"].alignment = center_align()
ws_ck.row_dimensions[1].height = 30

checklist_data = [
    # (Subject, Topic, Times_repeated, Priority, Day_scheduled)
    ("Medicine","ECG, Arrhythmias & Heart Blocks",9,"High","Day 1"),
    ("Medicine","ABG and RTA",5,"High","Day 2"),
    ("Medicine","Diabetes – DKA and HHS",5,"High","Day 2"),
    ("Medicine","Pituitary Disorders – DI and SIADH",5,"High","Day 2"),
    ("Medicine","HIV",4,"High","Day 3"),
    ("Medicine","Valvular Heart Disease",4,"High","Day 1"),
    ("Medicine","Vasculitis",4,"High","Day 2"),
    ("Medicine","Cirrhosis & Complications (SBP, Child-Pugh, Variceal Bleed)",3,"High","Day 3"),
    ("Medicine","Coronary Artery Disease",3,"High","Day 1"),
    ("Medicine","Disorders of Aorta",3,"High","Day 1"),
    ("Medicine","Electrolyte Disorders",3,"High","Day 2"),
    ("Medicine","Heart Failure",3,"High","Day 1"),
    ("Medicine","JVP",3,"High","Day 1"),
    ("Medicine","Malabsorption Disorders",3,"High","Day 3"),
    ("Medicine","Pleural Disease",3,"High","Day 3"),
    ("Pharmacology","Antihypertensives",7,"High","Day 1"),
    ("Pharmacology","Antimuscarinic",7,"High","Day 2"),
    ("Pharmacology","Antiarrhythmic",6,"High","Day 1"),
    ("Pharmacology","Anti-TB",5,"High","Day 2"),
    ("Pharmacology","Anticoagulants and Fibrinolytics",5,"High","Day 1"),
    ("Pharmacology","Antiemetics",5,"High","Day 1"),
    ("Pharmacology","NSAIDs",5,"High","Day 2"),
    ("Pharmacology","Pharmacokinetics and Pharmacodynamics",4,"High","Day 2"),
    ("Pharmacology","Antifungal",3,"High","Day 3"),
    ("Pharmacology","Antimalarials",3,"High","Day 3"),
    ("Pharmacology","Antimicrobials",3,"High","Day 3"),
    ("Pharmacology","Antiparkinsonians",3,"High","Day 3"),
    ("Biochemistry","Vitamins",15,"High","Day 5"),
    ("Biochemistry","Lysosomal Storage Disorder",6,"High","Day 5"),
    ("Biochemistry","Glycogen Storage Disorders",4,"High","Day 5"),
    ("Biochemistry","Alkaptonuria",3,"High","Day 5"),
    ("Biochemistry","Familial Hypercholesterolaemia",3,"High","Day 5"),
    ("Biochemistry","Homocystinuria",2,"High","Day 5"),
    ("Biochemistry","Metabolic Cycles – Insulin:Glucagon ratio",2,"Moderate","Day 5"),
    ("Biochemistry","Inhibition",2,"Moderate","Day 5"),
    ("Biochemistry","Minerals",2,"Moderate","Day 5"),
    ("Pathology","Genetics and Syndromes",8,"High","Day 7"),
    ("Pathology","Leukaemia",8,"High","Day 7"),
    ("Pathology","Intestinal Disorders",5,"High","Day 8"),
    ("Pathology","Lymphoma",5,"High","Day 7"),
    ("Pathology","Carcinoma Lung and Thymoma",4,"High","Day 8"),
    ("Pathology","Disorders of Haemoglobin",4,"High","Day 7"),
    ("Pathology","Glomerular Diseases",4,"High","Day 8"),
    ("Pathology","Thyroid",4,"High","Day 9"),
    ("Pathology","Tumors",4,"High","Day 8"),
    ("Pathology","Coagulation Disorders",3,"High","Day 9"),
    ("Pathology","Inflammation",3,"High","Day 10"),
    ("Pathology","Iron Deficiency Anaemia",3,"High","Day 9"),
    ("Pathology","Macrocytic Anaemia",3,"High","Day 9"),
    ("Pathology","Multiple Myeloma and Amyloid",3,"High","Day 9"),
    ("Surgery","Breast Cancer",5,"High","Day 7"),
    ("Surgery","Inguinal Hernia",5,"High","Day 7"),
    ("Surgery","Bladder Carcinoma",4,"High","Day 7"),
    ("Surgery","Oral Cavity Cancer",4,"High","Day 7"),
    ("Surgery","Penile Carcinoma",4,"High","Day 9"),
    ("Surgery","Triage / Trauma",4,"High","Day 8"),
    ("Surgery","Aortic Dissection",3,"High","Day 8"),
    ("Surgery","Cystourethroscope",3,"High","Day 10"),
    ("Surgery","Fistula in Ano",3,"High","Day 9"),
    ("Surgery","Glasgow Coma Scale",3,"High","Day 8"),
    ("Surgery","Hollow Viscus Perforation",3,"High","Day 9"),
    ("Surgery","Hydatid Cyst",3,"High","Day 9"),
    ("Surgery","Oesophageal Varices",3,"High","Day 9"),
    ("Surgery","Peripheral Arterial Disease / Leriche's Syndrome",3,"High","Day 8"),
    ("Surgery","Rectal Carcinoma",3,"High","Day 9"),
    ("Surgery","Subarachnoid Haemorrhage",3,"High","Day 10"),
    ("PSM","Biomedical Waste Management",6,"High","Day 7"),
    ("PSM","Parametric Test",5,"High","Day 7"),
    ("PSM","Vitamin Deficiency",5,"High","Day 8"),
    ("PSM","Case-Control / Cohort Study",4,"High","Day 8"),
    ("PSM","Disaster Management / Disaster Cycle",4,"High","Day 9"),
    ("PSM","Kata Thermometer",3,"High","Day 10"),
    ("PSM","Vaccines / CI for Live Vaccine / Immunisation Schedule",3,"High","Day 9"),
    ("PSM","Varicella",3,"High","Day 9"),
    ("PSM","ASHA",2,"Moderate","Day 10"),
    ("PSM","Coefficient of Regression / Variation",2,"Moderate","Day 10"),
    ("PSM","Demography / Demographic Cycle",2,"Moderate","Day 10"),
]

ck_headers = ["Subject", "Topic", "Times Repeated", "Priority", "Scheduled Day", "Status"]
ck_widths   = [14, 52, 14, 12, 14, 16]
for ci, (h, cw) in enumerate(ck_headers, start=1):
    c = ws_ck.cell(row=2, column=ci, value=h)
    c.font = font(bold=True, color="FFFFFF", size=10)
    c.fill = fill(C_HEADER_BG)
    c.alignment = center_align()
    c.border = border_thin()
    ws_ck.column_dimensions[get_column_letter(ci)].width = cw
ws_ck.row_dimensions[2].height = 22

dv_ck = DataValidation(type="list", formula1='"✅ Done,⏳ Pending,❌ Need Redo"', allow_blank=True)
ws_ck.add_data_validation(dv_ck)

subj_order = ["Medicine","Pharmacology","Biochemistry","Pathology","Surgery","PSM"]
for si, subj in enumerate(subj_order):
    rows = [r for r in checklist_data if r[0]==subj]
    for ri, (s, topic, times, prio, day) in enumerate(rows):
        row = 3 + checklist_data.index((s,topic,times,prio,day))
        sbg = C_SUBJ.get(s, "F2F2F2")
        alt_bg = "F7FBFF" if ri % 2 == 0 else "FFFFFF"
        row_data = [s, topic, f"{times}×", prio, day, "⏳ Pending"]
        for ci, val in enumerate(row_data, start=1):
            c = ws_ck.cell(row=row, column=ci, value=val)
            c.border = border_thin()
            c.alignment = center_align() if ci != 2 else left_align()
            if ci == 1:
                c.fill = fill(sbg)
                c.font = font(bold=True, size=9)
            elif ci == 3:
                c.fill = fill("FFF2CC")
                c.font = font(bold=True, size=9, color="7F6000")
            elif ci == 4:
                prio_col = "C6EFCE" if prio=="High" else "FFEB9C"
                c.fill = fill(prio_col)
                c.font = font(size=9, bold=(prio=="High"))
            else:
                c.fill = fill(alt_bg)
                c.font = font(size=9)
        ws_ck.row_dimensions[row].height = 18
        dv_ck.add(ws_ck.cell(row=row, column=6))

ws_ck.freeze_panes = "A3"

# ════════════════════════════════════════════════════════════════
# SHEET 19 – MCQ SCORE TRACKER
# ════════════════════════════════════════════════════════════════
ws_mcq = wb.create_sheet("📈 MCQ Score Tracker")
ws_mcq.sheet_view.showGridLines = False

ws_mcq.merge_cells("A1:G1")
ws_mcq["A1"] = "MCQ Score Tracker — Daily Performance Log"
ws_mcq["A1"].font = Font(name="Arial", bold=True, size=13, color="FFFFFF")
ws_mcq["A1"].fill = fill(C_HEADER_BG)
ws_mcq["A1"].alignment = center_align()
ws_mcq.row_dimensions[1].height = 30

mcq_headers = ["Day", "Date", "Test Type", "Subject(s)", "Total Qs", "Correct", "Score %"]
mcq_widths   = [6, 14, 20, 30, 10, 10, 12]
for ci, (h, cw) in enumerate(mcq_headers, start=1):
    c = ws_mcq.cell(row=2, column=ci, value=h)
    c.font = font(bold=True, color="FFFFFF", size=10)
    c.fill = fill(C_HEADER_BG)
    c.alignment = center_align()
    c.border = border_thin()
    ws_mcq.column_dimensions[get_column_letter(ci)].width = cw
ws_mcq.row_dimensions[2].height = 22

mcq_rows = [
    (1, "Wed 15 Jul", "PYQ Session", "Medicine CVS + Pharm CVS", 30, "", ""),
    (2, "Thu 16 Jul", "PYQ Session", "Medicine Endocrine + Pharm", 30, "", ""),
    (3, "Fri 17 Jul", "PYQ Session", "GI Medicine + Anti-infectives", 30, "", ""),
    (4, "Sat 18 Jul", "MCQ Drill + PYQ", "Medicine + Pharmacology – Mixed", 150, "", ""),
    (5, "Sun 19 Jul", "Timed Test + PYQ", "Biochemistry", 90, "", ""),
    (6, "Mon 20 Jul", "Integrated Drill", "Med + Pharm + Biochem", 80, "", ""),
    (7, "Tue 21 Jul", "PYQ Session", "Path Haem + Surgery + PSM", 40, "", ""),
    (8, "Wed 22 Jul", "PYQ Session", "Path Solid + PSM Stats + Surgery Vasc", 40, "", ""),
    (9, "Thu 23 Jul", "PYQ Session", "Coagulation + GI Surg + Vaccines", 40, "", ""),
    (10,"Fri 24 Jul", "MCQ Drill + PYQ", "Path + Surgery + PSM", 60, "", ""),
    (11,"Sat 25 Jul", "Mock Test", "Path + Surgery + PSM – 90 Qs", 90, "", ""),
    (12,"Sun 26 Jul", "PYQ Session", "Path + Med + Pharm", 40, "", ""),
    (13,"Mon 27 Jul", "MCQ Drill", "Path 50 + Surgery 50 + PSM 40", 140, "", ""),
    (14,"Tue 28 Jul", "Full Mock", "All Subjects – 120 Qs", 120, "", ""),
    (15,"Wed 29 Jul", "Confidence Mock", "All Subjects – 100 Qs", 100, "", ""),
    (16,"Thu 30 Jul", "Rapid-fire PYQ", "All Subjects – 30 Qs", 30, "", ""),
]

for ri, row_data in enumerate(mcq_rows):
    row = 3 + ri
    alt_bg = "F2F7FB" if ri % 2 == 0 else "FFFFFF"
    for ci, val in enumerate(row_data, start=1):
        c = ws_mcq.cell(row=row, column=ci, value=val)
        c.border = border_thin()
        c.alignment = center_align()
        c.font = font(size=9, bold=(ci==1))
        c.fill = fill(alt_bg)
    # Score % formula
    c_score = ws_mcq.cell(row=row, column=7)
    c_score.value = f'=IFERROR(F{row}/E{row},"")'
    c_score.number_format = "0.0%"
    c_score.fill = fill("EBF3E8")
    c_score.font = font(bold=True, size=9, color="375623")
    ws_mcq.row_dimensions[row].height = 18

ws_mcq.freeze_panes = "A3"

# Save
out_path = "/tmp/workspace/neet-timetable/NEET_PG_15Day_Timetable.xlsx"
wb.save(out_path)
print(f"Saved: {out_path}")

Successfully replaced 1 instance(s) of the string in '/tmp/workspace/neet-timetable/create_timetable.py'

Successfully replaced 1 instance(s) of the string in '/tmp/workspace/neet-timetable/create_timetable.py'