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

wb = openpyxl.Workbook()

# ─── Colour palette ───────────────────────────────────────────────────────────
DARK_BLUE   = "1F3864"
MED_BLUE    = "2E75B6"
LIGHT_BLUE  = "BDD7EE"
PALE_BLUE   = "DEEAF1"
YELLOW_HDR  = "FFD700"
GREEN_PASS  = "E2EFDA"
WHITE       = "FFFFFF"
ORANGE      = "F4B942"
LIGHT_GREEN = "C6EFCE"
LIGHT_ORANGE= "FDEBD0"
LIGHT_GREY  = "F2F2F2"

def hdr_font(bold=True, sz=11, col="FFFFFF"):
    return Font(name="Arial", bold=bold, size=sz, color=col)

def cell_font(bold=False, sz=10, col="000000"):
    return Font(name="Arial", bold=bold, size=sz, color=col)

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

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

def wrap_align(h="left", v="center"):
    return Alignment(horizontal=h, vertical=v, wrap_text=True)

def write_sheet_title(ws, title, subtitle="", row=1):
    ws.merge_cells(start_row=row, start_column=1, end_row=row, end_column=8)
    c = ws.cell(row=row, column=1, value=title)
    c.font = Font(name="Arial", bold=True, size=14, color=WHITE)
    c.fill = fill(DARK_BLUE)
    c.alignment = Alignment(horizontal="center", vertical="center")
    if subtitle:
        ws.row_dimensions[row].height = 30
        row += 1
        ws.merge_cells(start_row=row, start_column=1, end_row=row, end_column=8)
        c2 = ws.cell(row=row, column=1, value=subtitle)
        c2.font = Font(name="Arial", bold=True, size=11, color=WHITE)
        c2.fill = fill(MED_BLUE)
        c2.alignment = Alignment(horizontal="center", vertical="center")
    return row + 1

def col_header(ws, row, cols, bg=MED_BLUE, fg="FFFFFF"):
    for ci, val in enumerate(cols, 1):
        c = ws.cell(row=row, column=ci, value=val)
        c.font = Font(name="Arial", bold=True, size=10, color=fg)
        c.fill = fill(bg)
        c.alignment = wrap_align("center")
        c.border = border()

def data_row(ws, row, vals, bg=WHITE, bold=False):
    alt = LIGHT_GREY if (row % 2 == 0) else WHITE
    bg_use = bg if bg != WHITE else alt
    for ci, val in enumerate(vals, 1):
        c = ws.cell(row=row, column=ci, value=val)
        c.font = Font(name="Arial", bold=bold, size=10)
        c.fill = fill(bg_use)
        c.alignment = wrap_align("left")
        c.border = border()

def section_row(ws, row, label, ncols=8, bg=LIGHT_BLUE):
    ws.merge_cells(start_row=row, start_column=1, end_row=row, end_column=ncols)
    c = ws.cell(row=row, column=1, value=label)
    c.font = Font(name="Arial", bold=True, size=10, color=DARK_BLUE)
    c.fill = fill(bg)
    c.alignment = wrap_align("left")
    c.border = border()

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 1 – COVER / INDEX
# ═══════════════════════════════════════════════════════════════════════════════
ws0 = wb.active
ws0.title = "Cover"
ws0.column_dimensions["A"].width = 6
ws0.column_dimensions["B"].width = 50
ws0.column_dimensions["C"].width = 30

ws0.merge_cells("A1:C1")
c = ws0["A1"]
c.value = "NATIONAL MEDICAL COMMISSION (NMC)"
c.font = Font(name="Arial", bold=True, size=16, color=WHITE)
c.fill = fill(DARK_BLUE)
c.alignment = Alignment(horizontal="center", vertical="center")
ws0.row_dimensions[1].height = 36

ws0.merge_cells("A2:C2")
c = ws0["A2"]
c.value = "MINIMUM STANDARD REQUIREMENTS – MSR 2023"
c.font = Font(name="Arial", bold=True, size=13, color=WHITE)
c.fill = fill(MED_BLUE)
c.alignment = Alignment(horizontal="center", vertical="center")
ws0.row_dimensions[2].height = 26

ws0.merge_cells("A3:C3")
c = ws0["A3"]
c.value = "Annual Intake: 150 MBBS Students"
c.font = Font(name="Arial", bold=True, size=12, color=DARK_BLUE)
c.fill = fill(YELLOW_HDR)
c.alignment = Alignment(horizontal="center", vertical="center")
ws0.row_dimensions[3].height = 22

ws0.merge_cells("A4:C4")
ws0.row_dimensions[4].height = 8

rows_index = [
    (5,  "Sheet",     "Contents"),
    (6,  "1",         "Infrastructure & Land"),
    (7,  "2",         "Teaching Hospital – Beds by Department"),
    (8,  "3",         "Faculty Requirements (Teaching Staff)"),
    (9,  "4",         "Residents, Demonstrators & Tutors"),
    (10, "5",         "Departments & Laboratory Requirements"),
    (11, "6",         "OPD & Clinical Load Requirements"),
    (12, "7",         "Equipment & Ancillary Facilities"),
    (13, "8",         "Checklist Summary"),
]
for r, sheet_no, content in rows_index:
    ws0.cell(row=r, column=1, value=sheet_no).font = Font(name="Arial", bold=True, size=10)
    ws0.cell(row=r, column=1).fill = fill(PALE_BLUE)
    ws0.cell(row=r, column=1).border = border()
    ws0.cell(row=r, column=1).alignment = Alignment(horizontal="center", vertical="center")
    ws0.cell(row=r, column=2, value=content).font = Font(name="Arial", size=10)
    ws0.cell(row=r, column=2).fill = fill(WHITE if r % 2 else LIGHT_GREY)
    ws0.cell(row=r, column=2).border = border()
    ws0.cell(row=r, column=2).alignment = wrap_align()
    ws0.row_dimensions[r].height = 18

col_header(ws0, 5, ["#", "Sheet Title", ""], bg=DARK_BLUE)

ws0.merge_cells("A14:C14")
note = ws0["A14"]
note.value = "Reference: NMC MSR Regulations 2023 (Gazette Notification, August 2023) | Valid from Academic Year 2024-25"
note.font = Font(name="Arial", italic=True, size=9, color="595959")
note.alignment = Alignment(horizontal="center", vertical="center")
ws0.row_dimensions[14].height = 18

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 2 – INFRASTRUCTURE & LAND
# ═══════════════════════════════════════════════════════════════════════════════
ws1 = wb.create_sheet("Infrastructure & Land")
ws1.column_dimensions["A"].width = 5
ws1.column_dimensions["B"].width = 42
ws1.column_dimensions["C"].width = 38
ws1.column_dimensions["D"].width = 18
ws1.column_dimensions["E"].width = 22
ws1.column_dimensions["F"].width = 18
ws1.column_dimensions["G"].width = 16

r = write_sheet_title(ws1, "NMC MSR 2023 – INFRASTRUCTURE & LAND REQUIREMENTS",
                      "Annual MBBS Intake: 150 Students", 1)

col_header(ws1, r, ["S.No.", "Parameter", "Requirement / Specification", "Minimum Area / Quantity",
                    "Unit", "Remarks", "Compliance Status"], bg=MED_BLUE)
r += 1

infra = [
    # Section, then data rows
    ("SECTION", "A. LAND & BUILDING"),
    ("1",  "Land Area",
     "No minimum land area prescribed (removed in MSR 2023)",
     "No fixed minimum", "–",
     "Previously 20 acres (general) / 10 acres (metro) in MSR 2020. Now removed.", ""),
    ("2",  "College Building – Total Built-up Area",
     "Adequate to house all departments and facilities",
     "≥ 17,000", "Sq.m.",
     "Must include all pre-clinical, para-clinical and clinical dept rooms", ""),
    ("3",  "Lecture Theatres (College)",
     "Minimum 2 lecture theatres",
     "2", "Nos.",
     "Each seating ≥ 150 students; audio-visual aids mandatory", ""),
    ("4",  "Central Library",
     "One central library",
     "≥ 1,200", "Sq.m.",
     "Reading room, stack room, internet facility, e-journals access", ""),
    ("5",  "Skill Laboratory",
     "One dedicated skills lab",
     "≥ 600", "Sq.m.",
     "Min. 4 patient examination rooms, video recording facility, mannequins, OSCE stations", ""),
    ("6",  "Anatomy Museum / Dissection Hall",
     "Dedicated dissection hall",
     "≥ 1,200", "Sq.m.",
     "≥ 150 tables; embalming room, museum attached", ""),
    ("7",  "Boys Hostel",
     "Residential hostel for male students",
     "Capacity for ≥ 50% male students", "Beds",
     "Single or twin-sharing rooms; mess, common room, Wi-Fi", ""),
    ("8",  "Girls Hostel",
     "Residential hostel for female students",
     "Capacity for ≥ 50% female students", "Beds",
     "Single or twin-sharing rooms; mess, common room, Wi-Fi", ""),
    ("9",  "Faculty/Staff Quarters",
     "Residential quarters for faculty",
     "Adequate nos.", "–",
     "Proximity to campus preferred", ""),
    ("10", "Administrative Block",
     "Principal's office, admin offices, conference room",
     "Adequate area", "Sq.m.",
     "Separate from college building or integrated", ""),
    ("SECTION", "B. HOSPITAL BUILDING"),
    ("11", "Teaching Hospital Built-up Area",
     "Full-service hospital with all required departments",
     "≥ 25,000", "Sq.m.",
     "OPD, IPD, OTs, ICUs, casualty, lab, blood bank, radiology, CSSD", ""),
    ("12", "OPD Area",
     "Outpatient department",
     "≥ 3,000", "Sq.m.",
     "Separate consultation rooms per department, waiting area, registration", ""),
    ("13", "Central Lecture Theatre (Hospital)",
     "Gallery-type lecture theatre in hospital",
     "1 (seating ≥ 100)", "Nos.",
     "Audio-visual aids; in addition to college lecture theatres", ""),
    ("14", "Central Medical Record Section",
     "Centralised medical records department",
     "≥ 150", "Sq.m.",
     "Computer-based records management", ""),
    ("15", "Operating Theatres (Major)",
     "Major OTs",
     "≥ 4", "Nos.",
     "Full surgical suite with anaesthesia equipment; laminar flow preferred", ""),
    ("16", "Labour Room",
     "Obstetrics labour suite",
     "≥ 4 tables", "Nos.",
     "With emergency O&G operating capability", ""),
    ("17", "ICU / NICU / PICU",
     "Intensive care units",
     "≥ 30 (total ICU beds)", "Beds",
     "General ICU, NICU, PICU; HDU included", ""),
    ("18", "Casualty / Emergency Department",
     "24×7 casualty services",
     "Adequate", "–",
     "Resuscitation bays, triage, trauma bay; connected to blood bank", ""),
    ("19", "Blood Bank",
     "Licensed blood bank",
     "1", "Nos.",
     "CPCB / Drug licence required; component separation facility", ""),
    ("20", "CSSD (Central Sterile Supply Dept)",
     "Central sterile supply",
     "1", "Nos.",
     "Autoclave, ETO, washer; adequate supply for all OTs & wards", ""),
    ("21", "Mortuary",
     "Hospital mortuary with cold storage",
     "Adequate", "–",
     "Linked to forensic medicine department", ""),
    ("SECTION", "C. AMENITIES & UTILITIES"),
    ("22", "Power Backup",
     "Uninterrupted power supply",
     "100% backup", "–",
     "Generator + UPS for ICU, OT, casualty", ""),
    ("23", "Water Supply",
     "Continuous potable water",
     "24×7", "–",
     "RO/purification plant; overhead tanks", ""),
    ("24", "Biomedical Waste Management",
     "BMW management as per CPCB norms",
     "Compliant", "–",
     "Colour-coded bins, incinerator/tie-up", ""),
    ("25", "Ambulance Services",
     "Minimum number of ambulances",
     "≥ 2", "Nos.",
     "ALS ambulance preferred; 24×7 availability", ""),
    ("26", "Canteen / Cafeteria",
     "Separate canteen for students, staff and patients",
     "Adequate", "–",
     "Hygienic, FSSAI compliant", ""),
    ("27", "Internet / IT Infrastructure",
     "Campus-wide internet connectivity",
     "Adequate bandwidth", "–",
     "Wi-Fi in library, hostels, OPD; AEBAS biometric system mandatory", ""),
]

sno = 0
for row_data in infra:
    if row_data[0] == "SECTION":
        section_row(ws1, r, f"  {row_data[1]}", ncols=7)
        r += 1
    else:
        sno += 1
        data_row(ws1, r, list(row_data))
        r += 1

ws1.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 3 – TEACHING HOSPITAL BEDS
# ═══════════════════════════════════════════════════════════════════════════════
ws2 = wb.create_sheet("Hospital Beds by Dept")
ws2.column_dimensions["A"].width = 5
ws2.column_dimensions["B"].width = 40
ws2.column_dimensions["C"].width = 16
ws2.column_dimensions["D"].width = 16
ws2.column_dimensions["E"].width = 16
ws2.column_dimensions["F"].width = 18
ws2.column_dimensions["G"].width = 30

r = write_sheet_title(ws2, "NMC MSR 2023 – TEACHING HOSPITAL BED REQUIREMENTS",
                      "Annual MBBS Intake: 150 Students  |  Minimum Total Beds: 600  (4 beds per student)", 1)

col_header(ws2, r, ["S.No.", "Department / Specialty", "Beds for 50 Seats",
                    "Beds for 100 Seats", "Beds for 150 Seats (THIS COLLEGE)",
                    "No. of Teaching Units", "Remarks"], bg=MED_BLUE)
r += 1

beds_data = [
    ("SECTION", "CLINICAL DEPARTMENTS"),
    ("1",  "General Medicine",       50,  100, 150, "3 units (50 beds/unit)",
     "Min 3 teaching units; each unit: 1 Prof, 1 Assoc Prof, 1 Asst Prof"),
    ("2",  "Paediatrics",            20,   40,  65, "2 units",
     "Includes NICU beds"),
    ("3",  "Dermatology & STD",       5,   10,  10, "1 unit",
     "Venereology included"),
    ("4",  "Psychiatry",              5,   10,  15, "1 unit",
     "De-addiction facility desirable"),
    ("5",  "Respiratory Medicine / TB", 10, 15, 20, "1 unit",
     "Pulmonology / Chest diseases"),
    ("6",  "General Surgery",        50,  100, 150, "3 units (50 beds/unit)",
     "Min 3 teaching units"),
    ("7",  "Orthopaedics",           20,   40,  65, "2 units",
     "Includes trauma & PMR beds"),
    ("8",  "ENT (Otorhinolaryngology)", 10, 20, 20, "1 unit",
     "Audiometry & endoscopy facility"),
    ("9",  "Ophthalmology",          10,   20,  20, "1 unit",
     "Refraction clinic, laser facility"),
    ("10", "Obstetrics & Gynaecology", 25, 50,  75, "2 units",
     "Labour rooms, NICU proximity"),
    ("11", "ICU (General + Speciality)", 20, 20, 30, "–",
     "General ICU, NICU, PICU, CCU combined; HDU counted separately"),
    ("SECTION", "ADDITIONAL / SHARED UNITS"),
    ("12", "Physical Medicine & Rehabilitation (PMR)",
      5,   10,  10, "Shared with Orthopaedics",
     "Physiotherapy & occupational therapy"),
    ("13", "Burns Ward",             "–", "–",  10, "Part of Surgery",
     "Desirable; may be shared"),
    ("14", "Casualty / Emergency Obs Beds",
     "–", "–",  10, "–",
     "Short-stay emergency observation"),
    ("SECTION", "TOTALS"),
    ("",   "MINIMUM TOTAL BEDS (Excluding PMR/Burns/Casualty obs)",
     220,  420, 600, "–", "NMC norm: ≥ 4 beds per annual student intake"),
    ("",   "TOTAL INCLUDING PMR & ADDITIONAL BEDS",
     225,  430, 620, "–", "Recommended operational bed strength"),
]

for row_data in beds_data:
    if row_data[0] == "SECTION":
        section_row(ws2, r, f"  {row_data[1]}", ncols=7, bg=LIGHT_BLUE)
        r += 1
    elif row_data[0] == "":
        # Total row
        for ci, val in enumerate(list(row_data[1:]) + [""], 2):
            c = ws2.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", bold=True, size=10)
            c.fill = fill(ORANGE)
            c.alignment = wrap_align("center" if ci >= 3 else "left")
            c.border = border()
        ws2.cell(row=r, column=1, value="").fill = fill(ORANGE)
        ws2.cell(row=r, column=1).border = border()
        r += 1
    else:
        sno_val = row_data[0]
        alt = LIGHT_GREY if r % 2 == 0 else WHITE
        highlight = LIGHT_ORANGE if str(sno_val) in ["1","6"] else alt
        for ci, val in enumerate(list(row_data), 1):
            c = ws2.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", size=10)
            c.fill = fill(highlight)
            c.alignment = wrap_align("center" if ci >= 3 else "left")
            c.border = border()
        r += 1

ws2.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 4 – FACULTY REQUIREMENTS
# ═══════════════════════════════════════════════════════════════════════════════
ws3 = wb.create_sheet("Faculty Requirements")
ws3.column_dimensions["A"].width = 5
ws3.column_dimensions["B"].width = 35
ws3.column_dimensions["C"].width = 14
ws3.column_dimensions["D"].width = 16
ws3.column_dimensions["E"].width = 18
ws3.column_dimensions["F"].width = 14
ws3.column_dimensions["G"].width = 14
ws3.column_dimensions["H"].width = 28

r = write_sheet_title(ws3, "NMC MSR 2023 – FACULTY / TEACHING STAFF REQUIREMENTS",
                      "Annual MBBS Intake: 150 Students  |  Total Faculty Required: ≈ 114", 1)

col_header(ws3, r, ["S.No.", "Department", "Professor",
                    "Associate Professor", "Assistant Professor",
                    "Total Faculty", "Category",
                    "Eligibility / Remarks"], bg=MED_BLUE)
r += 1

faculty = [
    ("SECTION", "PRE-CLINICAL DEPARTMENTS"),
    ("1",  "Anatomy",            1, 1, 3, 5, "Pre-Clinical",
     "Head: Prof; MBBS + MD/MS Anatomy or equivalent"),
    ("2",  "Physiology",         1, 1, 3, 5, "Pre-Clinical",
     "Head: Prof; MBBS + MD/MS Physiology"),
    ("3",  "Biochemistry",       1, 1, 2, 4, "Pre-Clinical",
     "Head: Prof; MBBS + MD Biochemistry"),
    ("SECTION", "PARA-CLINICAL DEPARTMENTS"),
    ("4",  "Pathology",          1, 2, 3, 6, "Para-Clinical",
     "Head: Prof; MBBS + MD Pathology"),
    ("5",  "Microbiology",       1, 1, 2, 4, "Para-Clinical",
     "Head: Prof; MBBS + MD Microbiology"),
    ("6",  "Pharmacology",       1, 1, 2, 4, "Para-Clinical",
     "Head: Prof; MBBS + MD Pharmacology"),
    ("7",  "Forensic Medicine & Toxicology", 1, 1, 1, 3, "Para-Clinical",
     "Head: Prof; MBBS + MD FMT"),
    ("8",  "Community Medicine (Prev & Social Med)", 1, 2, 3, 6, "Para-Clinical",
     "Head: Prof; MBBS + MD PSM/Community Medicine; CHC attached"),
    ("SECTION", "CLINICAL DEPARTMENTS"),
    ("9",  "General Medicine",   1, 2, 3, 6, "Clinical",
     "3 teaching units; each unit needs 1 Prof/Assoc/Asst"),
    ("10", "Paediatrics",        1, 1, 2, 4, "Clinical",
     "2 teaching units"),
    ("11", "Dermatology & STD",  1, 1, 1, 3, "Clinical",
     "Head: Prof"),
    ("12", "Psychiatry",         1, 1, 1, 3, "Clinical",
     "Head: Prof"),
    ("13", "Respiratory Medicine", 1, 1, 1, 3, "Clinical",
     "Head: Prof / Assoc Prof acceptable initially"),
    ("14", "General Surgery",    1, 2, 3, 6, "Clinical",
     "3 teaching units"),
    ("15", "Orthopaedics",       1, 1, 2, 4, "Clinical",
     "2 teaching units; PMR included"),
    ("16", "ENT",                1, 1, 1, 3, "Clinical",
     "Head: Prof"),
    ("17", "Ophthalmology",      1, 1, 1, 3, "Clinical",
     "Head: Prof"),
    ("18", "Obstetrics & Gynaecology", 1, 2, 2, 5, "Clinical",
     "2 teaching units; includes Gynaecology oncology"),
    ("19", "Anaesthesiology",    1, 1, 2, 4, "Clinical",
     "Head: Prof; anaesthesia for min 4 OTs"),
    ("20", "Radio-Diagnosis",    1, 1, 1, 3, "Clinical",
     "Head: Prof; CT scan, USG, X-ray mandatory"),
    ("21", "Orthopaedics – PMR", "-", "-", 1, 1, "Clinical",
     "Can be shared post from Orthopaedics dept"),
    ("22", "Dentistry (if applicable)", 1, "-", 1, 2, "Clinical",
     "Optional if dental OPD is run"),
    ("SECTION", "TOTAL FACULTY"),
    ("",  "TOTAL TEACHING FACULTY (Core Departments)",
     20, 24, 40, 84, "–", "Approximate; exact as per NMC schedule"),
    ("",  "TOTAL INCLUDING ADDITIONAL/OPTIONAL DEPTS",
     21, 25, 43, 89, "–",
     "NMC MSR 2023 target: ~114 for 150 seats (including all depts)"),
]

for row_data in faculty:
    if row_data[0] == "SECTION":
        section_row(ws3, r, f"  {row_data[1]}", ncols=8, bg=LIGHT_BLUE)
        r += 1
    elif row_data[0] == "":
        for ci, val in enumerate(list(row_data[1:]), 2):
            c = ws3.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", bold=True, size=10)
            c.fill = fill(ORANGE)
            c.alignment = wrap_align("center" if ci >= 3 else "left")
            c.border = border()
        ws3.cell(row=r, column=1, value="").fill = fill(ORANGE)
        ws3.cell(row=r, column=1).border = border()
        r += 1
    else:
        alt = LIGHT_GREY if r % 2 == 0 else WHITE
        vals = list(row_data)
        for ci, val in enumerate(vals, 1):
            c = ws3.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", size=10)
            c.fill = fill(alt)
            c.alignment = wrap_align("center" if ci in [3,4,5,6] else "left")
            c.border = border()
        r += 1

ws3.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 5 – RESIDENTS, DEMONSTRATORS & TUTORS
# ═══════════════════════════════════════════════════════════════════════════════
ws4 = wb.create_sheet("Residents Demonstrators")
ws4.column_dimensions["A"].width = 5
ws4.column_dimensions["B"].width = 38
ws4.column_dimensions["C"].width = 18
ws4.column_dimensions["D"].width = 18
ws4.column_dimensions["E"].width = 18
ws4.column_dimensions["F"].width = 30

r = write_sheet_title(ws4, "NMC MSR 2023 – RESIDENTS, DEMONSTRATORS & TUTORS",
                      "Annual MBBS Intake: 150 Students  |  Total Required: ≈ 90", 1)

col_header(ws4, r, ["S.No.", "Department / Post",
                    "Senior Residents", "Junior Residents / Demonstrators",
                    "Tutors", "Remarks"], bg=MED_BLUE)
r += 1

res_data = [
    ("SECTION", "PRE-CLINICAL DEPARTMENTS"),
    ("1",  "Anatomy",           0, 4, 2, "Demonstrators handle practical classes"),
    ("2",  "Physiology",        0, 3, 2, "Demonstrators; MBBS or MSc eligible"),
    ("3",  "Biochemistry",      0, 2, 1, "Demonstrators"),
    ("SECTION", "PARA-CLINICAL DEPARTMENTS"),
    ("4",  "Pathology",         2, 3, 1, "Sr Residents for laboratory & OPD service"),
    ("5",  "Microbiology",      1, 2, 1, "Demonstrators for lab"),
    ("6",  "Pharmacology",      0, 2, 1, "Demonstrators"),
    ("7",  "Forensic Medicine", 1, 1, 0, "Sr Resident for mortuary & court work"),
    ("8",  "Community Medicine", 1, 2, 1, "Field work tutors; CHC staff"),
    ("SECTION", "CLINICAL DEPARTMENTS"),
    ("9",  "General Medicine",   3, 3, 0, "Min 1 Sr Resident per unit"),
    ("10", "Paediatrics",        2, 2, 0, "NICU SR required"),
    ("11", "Dermatology",        1, 1, 0, ""),
    ("12", "Psychiatry",         1, 1, 0, ""),
    ("13", "Respiratory Medicine", 1, 1, 0, ""),
    ("14", "General Surgery",    3, 3, 0, "Min 1 per unit"),
    ("15", "Orthopaedics",       2, 2, 0, ""),
    ("16", "ENT",                1, 1, 0, ""),
    ("17", "Ophthalmology",      1, 1, 0, ""),
    ("18", "Obstetrics & Gynaecology", 2, 2, 0, ""),
    ("19", "Anaesthesiology",    2, 2, 0, "24×7 OT cover"),
    ("20", "Radio-Diagnosis",    1, 1, 0, ""),
    ("SECTION", "TOTAL"),
    ("",  "APPROXIMATE TOTAL", 25, 42, 9,
     "NMC target ≈ 90 SRs, Demos & Tutors for 150 seats"),
]

for row_data in res_data:
    if row_data[0] == "SECTION":
        section_row(ws4, r, f"  {row_data[1]}", ncols=6, bg=LIGHT_BLUE)
        r += 1
    elif row_data[0] == "":
        for ci, val in enumerate(list(row_data[1:]), 2):
            c = ws4.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", bold=True, size=10)
            c.fill = fill(ORANGE)
            c.alignment = wrap_align("center" if ci in [3,4,5] else "left")
            c.border = border()
        ws4.cell(row=r, column=1, value="").fill = fill(ORANGE)
        ws4.cell(row=r, column=1).border = border()
        r += 1
    else:
        alt = LIGHT_GREY if r % 2 == 0 else WHITE
        for ci, val in enumerate(list(row_data), 1):
            c = ws4.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", size=10)
            c.fill = fill(alt)
            c.alignment = wrap_align("center" if ci in [3,4,5] else "left")
            c.border = border()
        r += 1

ws4.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 6 – DEPARTMENTS & LABS
# ═══════════════════════════════════════════════════════════════════════════════
ws5 = wb.create_sheet("Departments & Labs")
ws5.column_dimensions["A"].width = 5
ws5.column_dimensions["B"].width = 38
ws5.column_dimensions["C"].width = 32
ws5.column_dimensions["D"].width = 22
ws5.column_dimensions["E"].width = 28

r = write_sheet_title(ws5, "NMC MSR 2023 – DEPARTMENTS & LABORATORY REQUIREMENTS",
                      "Annual MBBS Intake: 150 Students", 1)

col_header(ws5, r, ["S.No.", "Department", "Key Laboratory / Facility",
                    "Minimum Area (Sq.m.)", "Essential Equipment / Remarks"], bg=MED_BLUE)
r += 1

depts = [
    ("SECTION", "PRE-CLINICAL"),
    ("1",  "Anatomy",
     "Dissection hall, Anatomy museum, histology lab, embalming room",
     "≥ 1,200 (dissection hall)",
     "150 dissection tables; plastinated specimens, models, skull collection"),
    ("2",  "Physiology",
     "Physiology lab, clinical physiology lab, haematology bench",
     "≥ 900",
     "Spirometers, ECG machines, audiometers, microscopes, centrifuges"),
    ("3",  "Biochemistry",
     "Biochemistry lab, research lab",
     "≥ 900",
     "Auto-analyser, spectrophotometers, electrophoresis unit"),
    ("SECTION", "PARA-CLINICAL"),
    ("4",  "Pathology",
     "Histopathology, cytology, haematology, blood bank (academic)",
     "≥ 1,200",
     "Biopsies, frozen section, flow cytometry desirable; microscopes × 50"),
    ("5",  "Microbiology",
     "Bacteriology, mycology, virology, serology, parasitology labs",
     "≥ 900",
     "Biosafety cabinet, autoclave, PCR; NABL accreditation desirable"),
    ("6",  "Pharmacology",
     "Experimental pharmacology, clinical pharmacology, museum",
     "≥ 600",
     "Animal house (CPCSEA approved); pharmacokinetics software"),
    ("7",  "Forensic Medicine",
     "Forensic lab, museum, post-mortem room (linked to mortuary)",
     "≥ 400",
     "Toxicology lab, DNA extraction kit, photography setup"),
    ("8",  "Community Medicine",
     "PSM/SPM lab, statistics lab, field practice area",
     "≥ 600",
     "Urban health centre + rural health centre attached; epidemiology software"),
    ("SECTION", "CLINICAL DEPARTMENTS"),
    ("9",  "General Medicine", "Clinical lab, ECG, echo access", "≥ 400", "Bedside monitors, defibrillators"),
    ("10", "General Surgery", "Surgical skills lab, wound care station", "≥ 400", "Basic laparoscopy trainer desirable"),
    ("11", "Obstetrics & Gynaecology", "Labour room, colposcopy, NST room", "≥ 500", "Foetal doppler, CTG machines ×4"),
    ("12", "Paediatrics", "NICU, PICU, growth monitoring lab", "≥ 400", "Phototherapy units, paediatric ventilators"),
    ("13", "Orthopaedics & PMR", "Plaster room, physiotherapy dept", "≥ 600", "Physiotherapy equipment, traction units"),
    ("14", "ENT", "Audiometry lab, endoscopy room", "≥ 300", "Pure-tone audiometer, rigid endoscopes"),
    ("15", "Ophthalmology", "Refraction clinic, retinal imaging", "≥ 300", "Slit lamp ×4, fundus camera, OCT desirable"),
    ("16", "Anaesthesiology", "OT anaesthesia workstations, pain clinic", "Part of OT complex", "Anaesthesia machines ×4, defibrillator"),
    ("17", "Radio-Diagnosis", "X-ray, USG, CT scan department", "≥ 600", "Digital X-ray, USG ×2, CT scan mandatory; MRI desirable"),
    ("18", "Psychiatry", "Counselling rooms, ECT suite", "≥ 200", "ECT machine, biofeedback equipment"),
    ("SECTION", "SUPPORT SERVICES"),
    ("19", "Clinical Pathology & Lab",
     "Central clinical laboratory (biochemistry, haematology, microbiology)",
     "≥ 600",
     "NABL accredited; 24×7 emergency lab"),
    ("20", "Central Library",
     "Physical + digital library",
     "≥ 1,200",
     "e-Journal access (MUHS/HELINET/NMC portal), INFLIBNET; reading room ≥ 120 seats"),
    ("21", "Skills Laboratory",
     "OSCE/OSPE stations, simulator lab",
     "≥ 600",
     "4 examination rooms, video recording, Harvey simulator, resuscitation mannequins"),
    ("22", "Medical Education Unit (MEU)",
     "Faculty development, curriculum planning",
     "≥ 200",
     "MEU cell with at least 1 trained medical educationist"),
]

sno2 = 0
for row_data in depts:
    if row_data[0] == "SECTION":
        section_row(ws5, r, f"  {row_data[1]}", ncols=5, bg=LIGHT_BLUE)
        r += 1
    else:
        alt = LIGHT_GREY if r % 2 == 0 else WHITE
        for ci, val in enumerate(list(row_data), 1):
            c = ws5.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", size=10)
            c.fill = fill(alt)
            c.alignment = wrap_align("left")
            c.border = border()
        r += 1

ws5.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 7 – OPD & CLINICAL LOAD
# ═══════════════════════════════════════════════════════════════════════════════
ws6 = wb.create_sheet("OPD & Clinical Load")
ws6.column_dimensions["A"].width = 5
ws6.column_dimensions["B"].width = 38
ws6.column_dimensions["C"].width = 30
ws6.column_dimensions["D"].width = 22
ws6.column_dimensions["E"].width = 30

r = write_sheet_title(ws6, "NMC MSR 2023 – OPD & CLINICAL LOAD REQUIREMENTS",
                      "Annual MBBS Intake: 150 Students", 1)

col_header(ws6, r, ["S.No.", "Parameter", "NMC Minimum Norm",
                    "For 150 Seats (Calculated)", "Remarks"], bg=MED_BLUE)
r += 1

opd_data = [
    ("1", "Daily OPD Attendance (Total)",
     "≥ 8 patients (old + new) per student intake per day",
     "≥ 1,200 patients/day",
     "Calculated: 150 × 8 = 1,200 OPD patients/day minimum"),
    ("2", "Indoor Bed Occupancy",
     "≥ 80% average annual occupancy",
     "≥ 480 beds occupied daily (of 600)",
     "Mandatory for recognition renewal"),
    ("3", "Caesarean Sections / Major Obstetric Procedures",
     "Adequate operative O&G load",
     "≥ 25 per month",
     "Normal deliveries + LSCS; required for O&G training"),
    ("4", "Major Surgical Operations",
     "Adequate surgical load for training",
     "≥ 50 major surgeries/month",
     "Log-book verified; general + subspecialty surgeries"),
    ("5", "Emergency / Casualty Attendance",
     "24×7 casualty services",
     "≥ 50 patients/day",
     "Trauma, medical, obstetric emergencies"),
    ("6", "Radiology Investigations",
     "Adequate imaging load",
     "≥ 50 X-rays + ≥ 20 USG/day",
     "CT scan services mandatory"),
    ("7", "Laboratory Investigations",
     "Central lab 24×7",
     "≥ 500 tests/day",
     "Biochemistry, haematology, microbiology"),
    ("8", "Blood Bank Donations/Issue",
     "Licensed blood bank",
     "≥ 100 units/month",
     "Component separation mandatory"),
    ("9", "SNCU / NICU Admissions",
     "Adequate neonatal care load",
     "≥ 15 admissions/month",
     "For paediatric training"),
    ("10", "Community Medicine Field Training",
     "Urban + rural health centre attached",
     "1 urban HC + 1 rural HC (CHC/PHC)",
     "Min. population of 30,000 under field practice area"),
    ("11", "Internship Postings",
     "12-month rotating internship",
     "All clinical departments covered",
     "CBME-based logbook; supervised by faculty"),
    ("12", "Death / Post-mortem Rate",
     "Adequate for forensic training",
     "≥ 15 PMs/month",
     "MLCs, trauma, institutional deaths included"),
]

for sno_idx, row_data in enumerate(opd_data, 1):
    alt = LIGHT_GREY if r % 2 == 0 else WHITE
    for ci, val in enumerate(list(row_data), 1):
        c = ws6.cell(row=r, column=ci, value=val)
        c.font = Font(name="Arial", size=10)
        c.fill = fill(alt)
        c.alignment = wrap_align("left")
        c.border = border()
    r += 1

ws6.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 8 – EQUIPMENT & ANCILLARY
# ═══════════════════════════════════════════════════════════════════════════════
ws7 = wb.create_sheet("Equipment & Ancillary")
ws7.column_dimensions["A"].width = 5
ws7.column_dimensions["B"].width = 38
ws7.column_dimensions["C"].width = 30
ws7.column_dimensions["D"].width = 20
ws7.column_dimensions["E"].width = 28

r = write_sheet_title(ws7, "NMC MSR 2023 – KEY EQUIPMENT & ANCILLARY FACILITIES",
                      "Annual MBBS Intake: 150 Students", 1)

col_header(ws7, r, ["S.No.", "Facility / Equipment", "Minimum Specification",
                    "Quantity", "Remarks"], bg=MED_BLUE)
r += 1

equip = [
    ("SECTION", "DIAGNOSTIC EQUIPMENT"),
    ("1",  "Digital X-ray Machine", "Computed Radiography / DR", "≥ 2", "One in OPD, one in casualty"),
    ("2",  "Ultrasound Machine", "B-mode + Doppler", "≥ 2", "One for O&G, one for general"),
    ("3",  "CT Scan", "Multi-slice (≥ 16 slice)", "≥ 1", "Mandatory for NMC recognition"),
    ("4",  "MRI", "1.5 Tesla", "Desirable", "Recommended but not mandatory in MSR 2023"),
    ("5",  "Echocardiography", "2D Echo + Doppler", "≥ 1", "Cardiology / Medicine"),
    ("6",  "ECG Machine", "12-lead", "≥ 6", "Ward + OPD + ICU + emergency"),
    ("7",  "Defibrillator", "Biphasic", "≥ 4", "ICU, OT, casualty, CCU"),
    ("8",  "Ventilator (Mechanical)", "ICU-grade", "≥ 10", "General ICU + NICU"),
    ("9",  "Pulse Oximeter / Monitors", "Multi-parameter", "≥ 20", "ICU, HDU, NICU"),
    ("10", "Operating Microscope", "Surgical grade", "≥ 2", "ENT + Ophthalmology"),
    ("SECTION", "SURGICAL & OT EQUIPMENT"),
    ("11", "Operating Theatre Table", "Motorised, multi-position", "≥ 4", "For ≥ 4 major OTs"),
    ("12", "Anaesthesia Workstation", "With integrated ventilator", "≥ 4", "One per OT"),
    ("13", "Laparoscopic Equipment",  "HD camera + monitor + insufflator", "≥ 1 set", "General surgery"),
    ("14", "Endoscopy (Rigid + Flexible)", "ENT + gastroenterology", "≥ 2 sets", "ENT + medicine"),
    ("15", "Cystoscope Set", "Rigid + flexible", "≥ 1 set", "Urology / Surgery"),
    ("SECTION", "LABORATORY EQUIPMENT"),
    ("16", "Auto-analyser (Biochemistry)", "Fully automated", "≥ 1", "Clinical biochemistry lab"),
    ("17", "Haematology Analyser",     "5-part differential", "≥ 1", "Central lab"),
    ("18", "Blood Gas Analyser",       "POC arterial blood gas", "≥ 1", "ICU / Emergency"),
    ("19", "Microscopes",              "Binocular light microscopes", "≥ 50 (student + dept)", "Pre-clinical + para-clinical labs"),
    ("20", "Centrifuges",              "High-speed refrigerated", "≥ 6", "Across all labs"),
    ("21", "PCR Machine",              "Real-time PCR",     "≥ 1", "Microbiology / research"),
    ("22", "Biosafety Cabinet",        "Class II Type A2",  "≥ 2", "Microbiology lab"),
    ("SECTION", "ANCILLARY FACILITIES"),
    ("23", "AEBAS (Biometric System)", "Aadhaar-enabled biometric attendance", "Campus-wide", "Mandatory for NMC inspection"),
    ("24", "CCTV Surveillance",        "IP cameras in labs, OT corridors, entries", "Adequate coverage", "Safety & monitoring"),
    ("25", "Medical Gas Pipeline",     "O2, N2O, Vacuum, Compressed Air", "All OTs, ICUs, wards", "MGPS installation mandatory"),
    ("26", "Fire Safety",              "Sprinklers, extinguishers, fire exits", "As per NBC norms", "Fire NOC mandatory"),
    ("27", "Disabled Access / Ramps",  "Barrier-free access in hospital & college", "All buildings", "Mandatory"),
    ("28", "Solar / Green Energy",     "Renewable energy installation", "Desirable", "Not mandatory but incentivised"),
]

for row_data in equip:
    if row_data[0] == "SECTION":
        section_row(ws7, r, f"  {row_data[1]}", ncols=5, bg=LIGHT_BLUE)
        r += 1
    else:
        alt = LIGHT_GREY if r % 2 == 0 else WHITE
        for ci, val in enumerate(list(row_data), 1):
            c = ws7.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", size=10)
            c.fill = fill(alt)
            c.alignment = wrap_align("center" if ci in [4] else "left")
            c.border = border()
        r += 1

ws7.freeze_panes = "A4"

# ═══════════════════════════════════════════════════════════════════════════════
#  SHEET 9 – CHECKLIST SUMMARY
# ═══════════════════════════════════════════════════════════════════════════════
ws8 = wb.create_sheet("Checklist Summary")
ws8.column_dimensions["A"].width = 5
ws8.column_dimensions["B"].width = 48
ws8.column_dimensions["C"].width = 28
ws8.column_dimensions["D"].width = 22
ws8.column_dimensions["E"].width = 18
ws8.column_dimensions["F"].width = 20

r = write_sheet_title(ws8, "NMC MSR 2023 – INSPECTION CHECKLIST SUMMARY",
                      "Annual MBBS Intake: 150 Students  |  Self-Assessment / NMC Inspection Template", 1)

col_header(ws8, r, ["S.No.", "Parameter", "NMC Minimum Norm for 150 Seats",
                    "Actual Status", "Compliant? (Y/N)",
                    "Remarks / Action Required"], bg=MED_BLUE)
r += 1

checklist = [
    ("SECTION", "A. INFRASTRUCTURE"),
    ("1",  "College Building Area",         "≥ 17,000 Sq.m.",              "", "", ""),
    ("2",  "Lecture Theatres (College)",     "≥ 2 (capacity 150 each)",     "", "", ""),
    ("3",  "Central Library",               "≥ 1,200 Sq.m.",               "", "", ""),
    ("4",  "Skills Laboratory",             "≥ 600 Sq.m.",                 "", "", ""),
    ("5",  "Anatomy Dissection Hall",       "≥ 1,200 Sq.m.; ≥ 150 tables", "", "", ""),
    ("6",  "Boys Hostel",                   "≥ 50% male capacity",          "", "", ""),
    ("7",  "Girls Hostel",                  "≥ 50% female capacity",        "", "", ""),
    ("SECTION", "B. HOSPITAL"),
    ("8",  "Total Indoor Beds",             "≥ 600 (4 × 150)",             "", "", ""),
    ("9",  "Teaching Hospital Built-up",    "≥ 25,000 Sq.m.",              "", "", ""),
    ("10", "OPD Area",                      "≥ 3,000 Sq.m.",               "", "", ""),
    ("11", "Operating Theatres (Major)",    "≥ 4",                          "", "", ""),
    ("12", "ICU Beds (All types combined)", "≥ 30",                         "", "", ""),
    ("13", "Blood Bank",                    "Licensed; 24×7",              "", "", ""),
    ("14", "CSSD",                          "Functional",                   "", "", ""),
    ("15", "CT Scan",                       "≥ 1 (mandatory)",              "", "", ""),
    ("SECTION", "C. FACULTY & STAFF"),
    ("16", "Total Teaching Faculty",        "≥ 114 (MSR 2023 target)",     "", "", ""),
    ("17", "Professors (total)",            "≥ 20–21",                     "", "", ""),
    ("18", "Associate Professors (total)",  "≥ 24–25",                     "", "", ""),
    ("19", "Assistant Professors (total)",  "≥ 40–43",                     "", "", ""),
    ("20", "Senior Residents (total)",      "≥ 25",                        "", "", ""),
    ("21", "Demonstrators / Jr Residents",  "≥ 42",                        "", "", ""),
    ("22", "Tutors",                        "≥ 9",                          "", "", ""),
    ("SECTION", "D. CLINICAL LOAD"),
    ("23", "Daily OPD Attendance",          "≥ 1,200 patients/day",        "", "", ""),
    ("24", "Indoor Bed Occupancy",          "≥ 80% per annum",             "", "", ""),
    ("25", "Major Surgeries",               "≥ 50/month",                  "", "", ""),
    ("26", "Casualty Attendance",           "≥ 50 patients/day",           "", "", ""),
    ("SECTION", "E. SYSTEMS & COMPLIANCE"),
    ("27", "AEBAS Biometric System",        "Fully operational",            "", "", ""),
    ("28", "Fire NOC",                      "Valid from competent authority", "", "", ""),
    ("29", "BMW Management",               "CPCB compliant",               "", "", ""),
    ("30", "University Affiliation Certificate", "Valid",                  "", "", ""),
    ("31", "Essentiality Certificate (State)", "Valid",                    "", "", ""),
    ("32", "NABL Accreditation (Lab)",      "Desirable / Mandatory for new", "", "", ""),
    ("33", "Medical Education Unit",        "Active MEU",                  "", "", ""),
    ("34", "Animal House (Pharmacology)",   "CPCSEA approved",             "", "", ""),
    ("35", "Community Health Centre",       "Urban + Rural PHC/CHC",       "", "", ""),
]

for row_data in checklist:
    if row_data[0] == "SECTION":
        section_row(ws8, r, f"  {row_data[1]}", ncols=6, bg=LIGHT_BLUE)
        r += 1
    else:
        alt = LIGHT_GREY if r % 2 == 0 else WHITE
        for ci, val in enumerate(list(row_data), 1):
            c = ws8.cell(row=r, column=ci, value=val)
            c.font = Font(name="Arial", size=10)
            if ci == 5:  # Compliant column – leave editable
                c.fill = fill(LIGHT_GREEN)
            else:
                c.fill = fill(alt)
            c.alignment = wrap_align("center" if ci in [5] else "left")
            c.border = border()
        r += 1

# Footer note
ws8.merge_cells(start_row=r+1, start_column=1, end_row=r+1, end_column=6)
note = ws8.cell(row=r+1, column=1,
    value="Note: Fill Column D (Actual Status) and Column E (Y/N) during self-assessment or inspection. "
          "Column F captures corrective actions. Based on NMC MSR 2023 (Gazette Notification, August 2023).")
note.font = Font(name="Arial", italic=True, size=9, color="595959")
note.alignment = Alignment(horizontal="left", vertical="center", wrap_text=True)
ws8.row_dimensions[r+1].height = 28

ws8.freeze_panes = "A4"

# ─── Save ─────────────────────────────────────────────────────────────────────
out_path = "/home/daytona/workspace/nmc-inspection/NMC_MSR2023_150Seats_Requirements.xlsx"
wb.save(out_path)
print(f"Saved: {out_path}")

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/nmc-inspection/create_nmc_excel.py'

const {
  Document, Packer, Paragraph, TextRun, Table, TableRow, TableCell,
  Header, Footer, AlignmentType, HeadingLevel, BorderStyle, WidthType,
  ShadingType, VerticalAlign, PageNumber, NumberFormat,
  TableOfContents, PageBreak, UnderlineType
} = require('docx');
const fs = require('fs');

// ── Colour palette ────────────────────────────────────────
const DARK_BLUE  = "1F3864";
const MED_BLUE   = "2E75B6";
const LIGHT_BLUE = "BDD7EE";
const PALE_BLUE  = "DEEAF1";
const ORANGE     = "F4B942";
const LT_ORANGE  = "FDEBD0";
const LT_GREEN   = "C6EFCE";
const LT_GREY    = "F2F2F2";
const WHITE      = "FFFFFF";

// ── Helpers ───────────────────────────────────────────────
function t(text, opts = {}) {
  return new TextRun({
    text: String(text),
    font: "Arial",
    size: opts.size || 20,
    bold: opts.bold || false,
    color: opts.color || "000000",
    italics: opts.italic || false,
    underline: opts.underline ? { type: UnderlineType.SINGLE } : undefined,
  });
}

function para(children, opts = {}) {
  return new Paragraph({
    children: Array.isArray(children) ? children : [children],
    alignment: opts.align || AlignmentType.LEFT,
    spacing: { before: opts.before || 60, after: opts.after || 60 },
    heading: opts.heading || undefined,
    indent: opts.indent ? { left: 360 } : undefined,
  });
}

function heading1(text) {
  return new Paragraph({
    children: [t(text, { bold: true, size: 28, color: WHITE })],
    alignment: AlignmentType.CENTER,
    spacing: { before: 200, after: 100 },
    shading: { type: ShadingType.SOLID, fill: DARK_BLUE },
  });
}

function heading2(text) {
  return new Paragraph({
    children: [t(text, { bold: true, size: 24, color: WHITE })],
    alignment: AlignmentType.LEFT,
    spacing: { before: 200, after: 80 },
    shading: { type: ShadingType.SOLID, fill: MED_BLUE },
  });
}

function heading3(text) {
  return new Paragraph({
    children: [t(text, { bold: true, size: 20, color: DARK_BLUE })],
    alignment: AlignmentType.LEFT,
    spacing: { before: 160, after: 60 },
    shading: { type: ShadingType.SOLID, fill: LIGHT_BLUE },
    border: { bottom: { style: BorderStyle.SINGLE, size: 6, color: MED_BLUE } },
  });
}

function sectionBar(text) {
  return new Paragraph({
    children: [t("  " + text, { bold: true, size: 19, color: DARK_BLUE })],
    spacing: { before: 100, after: 60 },
    shading: { type: ShadingType.SOLID, fill: LIGHT_BLUE },
  });
}

function infoBox(text) {
  return new Paragraph({
    children: [t(text, { size: 18, italic: true, color: "595959" })],
    spacing: { before: 80, after: 80 },
    shading: { type: ShadingType.SOLID, fill: PALE_BLUE },
    indent: { left: 200, right: 200 },
  });
}

function noteBox(text) {
  return new Paragraph({
    children: [t(text, { size: 17, italic: true, color: "595959" })],
    spacing: { before: 120, after: 60 },
    border: {
      top: { style: BorderStyle.SINGLE, size: 6, color: MED_BLUE },
      bottom: { style: BorderStyle.SINGLE, size: 6, color: MED_BLUE },
    },
    shading: { type: ShadingType.SOLID, fill: PALE_BLUE },
    indent: { left: 200, right: 200 },
  });
}

function bullet(text) {
  return new Paragraph({
    children: [t(text, { size: 19 })],
    bullet: { level: 0 },
    spacing: { before: 40, after: 40 },
  });
}

function spacer() {
  return new Paragraph({ children: [t("")], spacing: { before: 60, after: 60 } });
}

// ── Table helpers ─────────────────────────────────────────
const thinBorder = { style: BorderStyle.SINGLE, size: 4, color: "AAAAAA" };
const allBorders = { top: thinBorder, bottom: thinBorder, left: thinBorder, right: thinBorder };
const medBorder  = { style: BorderStyle.SINGLE, size: 6, color: MED_BLUE };

function hdrCell(text, opts = {}) {
  return new TableCell({
    children: [new Paragraph({
      children: [t(text, { bold: true, size: opts.size || 19, color: WHITE })],
      alignment: AlignmentType.CENTER,
      spacing: { before: 60, after: 60 },
    })],
    shading: { type: ShadingType.SOLID, fill: opts.bg || MED_BLUE },
    verticalAlign: VerticalAlign.CENTER,
    borders: allBorders,
    width: opts.width ? { size: opts.width, type: WidthType.DXA } : undefined,
  });
}

function secCell(text, colSpan, opts = {}) {
  return new TableCell({
    children: [new Paragraph({
      children: [t("  " + text, { bold: true, size: 19, color: DARK_BLUE })],
      spacing: { before: 60, after: 60 },
    })],
    columnSpan: colSpan,
    shading: { type: ShadingType.SOLID, fill: opts.bg || LIGHT_BLUE },
    borders: allBorders,
  });
}

function dataCell(text, opts = {}) {
  return new TableCell({
    children: [new Paragraph({
      children: [t(String(text), { size: 18, bold: opts.bold || false, color: opts.color || "000000" })],
      alignment: opts.align || AlignmentType.LEFT,
      spacing: { before: 40, after: 40 },
    })],
    shading: opts.bg ? { type: ShadingType.SOLID, fill: opts.bg } : undefined,
    verticalAlign: VerticalAlign.CENTER,
    borders: allBorders,
    width: opts.width ? { size: opts.width, type: WidthType.DXA } : undefined,
  });
}

function totCell(text, opts = {}) {
  return dataCell(text, { ...opts, bg: ORANGE, bold: true, align: opts.align || AlignmentType.CENTER });
}

function makeRow(cells, bg) {
  return new TableRow({ children: cells });
}

// ── PAGE BREAK ────────────────────────────────────────────
function pgBreak() {
  return new Paragraph({ children: [new PageBreak()] });
}

// ─────────────────────────────────────────────────────────
// DOCUMENT CONTENT
// ─────────────────────────────────────────────────────────
const children = [];

// ── COVER ────────────────────────────────────────────────
children.push(spacer(), spacer(), spacer());

children.push(new Paragraph({
  children: [t("NATIONAL MEDICAL COMMISSION (NMC)", { bold: true, size: 36, color: WHITE })],
  alignment: AlignmentType.CENTER,
  spacing: { before: 300, after: 100 },
  shading: { type: ShadingType.SOLID, fill: DARK_BLUE },
}));
children.push(new Paragraph({
  children: [t("MINIMUM STANDARD REQUIREMENTS – MSR 2023", { bold: true, size: 28, color: WHITE })],
  alignment: AlignmentType.CENTER,
  spacing: { before: 0, after: 0 },
  shading: { type: ShadingType.SOLID, fill: MED_BLUE },
}));
children.push(new Paragraph({
  children: [t("Annual MBBS Intake: 150 Students", { bold: true, size: 26, color: DARK_BLUE })],
  alignment: AlignmentType.CENTER,
  spacing: { before: 0, after: 0 },
  shading: { type: ShadingType.SOLID, fill: "FFF2CC" },
}));
children.push(new Paragraph({
  children: [t("Valid from Academic Year 2024-25 onwards", { bold: true, size: 22, color: WHITE })],
  alignment: AlignmentType.CENTER,
  spacing: { before: 0, after: 200 },
  shading: { type: ShadingType.SOLID, fill: DARK_BLUE },
}));

children.push(spacer(), spacer());
children.push(noteBox(
  "Reference: NMC Minimum Standard Requirements Regulations 2023 (Gazette Notification, August 2023)  |  " +
  "Maximum MBBS intake capped at 150 seats from A.Y. 2024-25"
));
children.push(spacer(), spacer(), spacer());

// Key summary table
children.push(new Paragraph({
  children: [t("AT A GLANCE – KEY NUMBERS FOR 150-SEAT COLLEGE", { bold: true, size: 22, color: WHITE })],
  alignment: AlignmentType.CENTER,
  spacing: { before: 200, after: 100 },
  shading: { type: ShadingType.SOLID, fill: DARK_BLUE },
}));

const summaryData = [
  ["Total Indoor Beds", "≥ 600 (4 beds per student)"],
  ["Daily OPD Attendance", "≥ 1,200 patients/day (8 per student)"],
  ["Bed Occupancy", "≥ 80% per annum"],
  ["Total Teaching Faculty", "≥ 114 (all departments)"],
  ["Skills Lab Area", "≥ 600 Sq.m."],
  ["CT Scan", "Mandatory (≥ 1)"],
  ["Major Operating Theatres", "≥ 4"],
  ["ICU Beds (combined)", "≥ 30"],
  ["Blood Bank", "Licensed; 24×7; component separation"],
  ["AEBAS Biometric", "Mandatory for NMC inspection"],
  ["Land Requirement", "REMOVED in MSR 2023 (no minimum)"],
  ["Major Surgeries", "≥ 50/month"],
  ["Post-mortem Cases", "≥ 15 PMs/month"],
];

const summaryRows = [
  new TableRow({
    children: [hdrCell("Parameter", { width: 4000 }), hdrCell("NMC Minimum Norm", { width: 5000 })],
    tableHeader: true,
  }),
];
summaryData.forEach(([p, v], i) => {
  summaryRows.push(new TableRow({
    children: [
      dataCell(p, { bg: i%2===0 ? PALE_BLUE : WHITE, bold: true, width: 4000 }),
      dataCell(v, { bg: i%2===0 ? PALE_BLUE : WHITE, width: 5000 }),
    ],
  }));
});
children.push(new Table({ rows: summaryRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 1 – INFRASTRUCTURE
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 1 – INFRASTRUCTURE & LAND"));
children.push(infoBox("Annual MBBS Intake: 150 Students | MSR 2023 – Gazette Notification, August 2023"));
children.push(spacer());

const infraCols = [600, 2200, 2500, 1500, 800, 1800];
const infraHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 600 }),
    hdrCell("Parameter", { width: 2200 }),
    hdrCell("Specification", { width: 2500 }),
    hdrCell("Min. Area / Qty", { width: 1500 }),
    hdrCell("Unit", { width: 800 }),
    hdrCell("Remarks", { width: 1800 }),
  ],
  tableHeader: true,
});

const infraData = [
  { sec: "A. LAND & BUILDING" },
  ["1","Land Area","No minimum – removed in MSR 2023 (was 20 acres)","Nil","–","Land requirement abolished"],
  ["2","College Building Area","All depts: pre-clinical, para-clinical, admin","≥ 17,000","Sq.m.","Lecture theatres, labs, library, skills lab"],
  ["3","Lecture Theatres (College)","Min. 2 with AV aids","2","Nos.","Each seating ≥ 150 students"],
  ["4","Central Library","Reading room + e-journals + internet","≥ 1,200","Sq.m.","INFLIBNET; reading room ≥ 120 seats"],
  ["5","Skills Laboratory","OSCE/simulation skills lab","≥ 600","Sq.m.","4 exam rooms, video recording, mannequins"],
  ["6","Anatomy Dissection Hall","Dissection hall + museum","≥ 1,200","Sq.m.","≥ 150 tables; embalming room + museum"],
  ["7","Boys Hostel","Male students residential","≥ 50% batch","Beds","Single/twin rooms; mess + Wi-Fi"],
  ["8","Girls Hostel","Female students residential","≥ 50% batch","Beds","Single/twin rooms; mess + Wi-Fi"],
  ["9","Faculty/Staff Quarters","On/near-campus quarters","Adequate","–","For faculty and residents"],
  ["10","Administrative Block","Principal office, admin, conference room","Adequate","Sq.m.","Can be integrated with main building"],
  { sec: "B. HOSPITAL BUILDING" },
  ["11","Teaching Hospital Area","Full-service hospital – all required depts","≥ 25,000","Sq.m.","OPD, IPD, OTs, ICU, casualty, labs, CSSD"],
  ["12","OPD Area","Outpatient department","≥ 3,000","Sq.m.","Separate rooms per dept; registration"],
  ["13","Lecture Theatre (Hospital)","Gallery-type in hospital","1 (≥100 seats)","Nos.","In addition to college LTs"],
  ["14","Central Medical Record Sect.","Computerised MRD","≥ 150","Sq.m.","Linked to hospital information system"],
  ["15","Major Operating Theatres","Fully equipped OTs","≥ 4","Nos.","Laminar flow preferred"],
  ["16","Labour Room","Obstetric labour suite","≥ 4 tables","Nos.","Emergency O&G operating capability"],
  ["17","ICU / NICU / PICU","All intensive care units combined","≥ 30","Beds","Gen ICU+NICU+PICU+CCU; HDU counted"],
  ["18","Casualty / Emergency","24×7 emergency dept","Adequate","–","Resus bays, triage, trauma; blood bank link"],
  ["19","Blood Bank","Licensed; 24×7","1","Nos.","Component separation facility mandatory"],
  ["20","CSSD","Central sterile supply","1","Nos.","Autoclave, ETO, washer"],
  ["21","Mortuary","Cold storage + PM room","Adequate","–","Linked to Forensic Medicine dept"],
  { sec: "C. UTILITIES & AMENITIES" },
  ["22","Power Backup","Generator + UPS","100% backup","–","ICU, OT, Casualty on UPS"],
  ["23","Water Supply","Continuous potable water","24×7","–","RO/purification; overhead tanks"],
  ["24","BMW Management","CPCB compliant","Compliant","–","Colour-coded bins; incinerator/tie-up"],
  ["25","Ambulance","Fully equipped","≥ 2","Nos.","ALS preferred; 24×7"],
  ["26","AEBAS Biometric","Aadhaar-linked attendance","Campus-wide","–","Mandatory for NMC inspection"],
  ["27","Fire Safety","Sprinklers + extinguishers","As per NBC","–","Valid Fire NOC required"],
  ["28","Disabled Access","Barrier-free ramps + lifts","All buildings","–","RPWD Act 2016 compliance"],
];

const infraRows = [infraHdr];
infraData.forEach((item, idx) => {
  if (item.sec) {
    infraRows.push(new TableRow({ children: [secCell(item.sec, 6)] }));
  } else {
    const bg = infraRows.length % 2 === 0 ? LT_GREY : WHITE;
    infraRows.push(new TableRow({ children: [
      dataCell(item[0], { align: AlignmentType.CENTER, bg }),
      dataCell(item[1], { bg, bold: true }),
      dataCell(item[2], { bg }),
      dataCell(item[3], { align: AlignmentType.CENTER, bg }),
      dataCell(item[4], { align: AlignmentType.CENTER, bg }),
      dataCell(item[5], { bg }),
    ]}));
  }
});
children.push(new Table({ rows: infraRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 2 – HOSPITAL BEDS
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 2 – TEACHING HOSPITAL BED REQUIREMENTS"));
children.push(infoBox("NMC Norm: 4 beds per annual MBBS student  |  For 150 Seats: Minimum 600 Beds"));
children.push(spacer());

const bedsHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 550 }),
    hdrCell("Department", { width: 2800 }),
    hdrCell("50 Seats", { width: 900 }),
    hdrCell("100 Seats", { width: 900 }),
    hdrCell("150 Seats (THIS COLLEGE)", { width: 1200 }),
    hdrCell("Teaching Units", { width: 1100 }),
    hdrCell("Remarks", { width: 1900 }),
  ],
  tableHeader: true,
});

const bedsData = [
  { sec: "CLINICAL DEPARTMENTS" },
  ["1","General Medicine",50,100,150,"3 units","50 beds/unit; 1 Prof+Assoc+Asst"],
  ["2","Paediatrics",20,40,65,"2 units","Includes NICU; PICU shared"],
  ["3","Dermatology & STD",5,10,10,"1 unit","Venereology included"],
  ["4","Psychiatry",5,10,15,"1 unit","De-addiction desirable"],
  ["5","Respiratory Medicine / TB",10,15,20,"1 unit","Pulmonology / chest diseases"],
  ["6","General Surgery",50,100,150,"3 units","50 beds/unit"],
  ["7","Orthopaedics",20,40,65,"2 units","Trauma + elective; PMR shared"],
  ["8","ENT",10,20,20,"1 unit","Audiometry + endoscopy"],
  ["9","Ophthalmology",10,20,20,"1 unit","Refraction clinic; laser"],
  ["10","Obstetrics & Gynaecology",25,50,75,"2 units","Labour rooms; NICU proximity"],
  ["11","ICU (all types)",20,20,30,"–","Gen ICU+NICU+PICU+CCU+HDU"],
  { sec: "ADDITIONAL / SHARED BEDS" },
  ["12","Physical Medicine & Rehab",5,10,10,"Shared–Ortho","Physio + OT"],
  ["13","Burns Ward","–","–",10,"Part of Surgery","Desirable"],
  ["14","Emergency Obs Beds","–","–",10,"–","Short-stay casualty"],
  { tot: ["Min. Beds (Core Depts)",220,420,600,"–","NMC norm: ≥ 4 × intake"] },
  { tot: ["Recommended Operational",225,430,620,"–","Incl. PMR, Burns, Emerg. obs"] },
];

const bedsRows = [bedsHdr];
bedsData.forEach(item => {
  if (item.sec) {
    bedsRows.push(new TableRow({ children: [secCell(item.sec, 7)] }));
  } else if (item.tot) {
    const [lbl,...vals] = item.tot;
    bedsRows.push(new TableRow({ children: [
      totCell(""),
      totCell(lbl, { align: AlignmentType.LEFT }),
      totCell(String(vals[0])),
      totCell(String(vals[1])),
      totCell(String(vals[2])),
      totCell(String(vals[3])),
      totCell(String(vals[4])),
    ]}));
  } else {
    const bg = bedsRows.length % 2 === 0 ? LT_GREY : WHITE;
    const c150bg = "D6E8F6";
    bedsRows.push(new TableRow({ children: [
      dataCell(item[0], { align: AlignmentType.CENTER, bg }),
      dataCell(item[1], { bg, bold: true }),
      dataCell(String(item[2]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[3]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[4]), { align: AlignmentType.CENTER, bg: c150bg, bold: true }),
      dataCell(String(item[5]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[6]), { bg }),
    ]}));
  }
});
children.push(new Table({ rows: bedsRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 3 – FACULTY
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 3 – FACULTY / TEACHING STAFF REQUIREMENTS"));
children.push(infoBox("Annual Intake: 150 Students  |  NMC Target: ≈ 114 Faculty"));
children.push(spacer());

const facHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 550 }),
    hdrCell("Department", { width: 2600 }),
    hdrCell("Professor", { width: 900 }),
    hdrCell("Assoc. Prof.", { width: 1000 }),
    hdrCell("Asst. Prof.", { width: 1000 }),
    hdrCell("Total", { width: 800 }),
    hdrCell("Category", { width: 1000 }),
    hdrCell("Remarks", { width: 1500 }),
  ],
  tableHeader: true,
});

const facData = [
  { sec: "PRE-CLINICAL DEPARTMENTS" },
  ["1","Anatomy",1,1,3,5,"Pre-Clinical","MBBS + MD/MS Anatomy"],
  ["2","Physiology",1,1,3,5,"Pre-Clinical","MBBS + MD Physiology"],
  ["3","Biochemistry",1,1,2,4,"Pre-Clinical","MBBS + MD Biochemistry"],
  { sec: "PARA-CLINICAL DEPARTMENTS" },
  ["4","Pathology",1,2,3,6,"Para-Clinical","MBBS + MD Pathology"],
  ["5","Microbiology",1,1,2,4,"Para-Clinical","MBBS + MD Microbiology"],
  ["6","Pharmacology",1,1,2,4,"Para-Clinical","MBBS + MD Pharmacology"],
  ["7","Forensic Medicine",1,1,1,3,"Para-Clinical","MBBS + MD FMT"],
  ["8","Community Medicine",1,2,3,6,"Para-Clinical","MBBS + MD PSM"],
  { sec: "CLINICAL DEPARTMENTS" },
  ["9","General Medicine",1,2,3,6,"Clinical","3 teaching units"],
  ["10","Paediatrics",1,1,2,4,"Clinical","2 teaching units"],
  ["11","Dermatology & STD",1,1,1,3,"Clinical","Head = Professor"],
  ["12","Psychiatry",1,1,1,3,"Clinical","Head = Professor"],
  ["13","Respiratory Medicine",1,1,1,3,"Clinical","Head = Prof / Assoc Prof"],
  ["14","General Surgery",1,2,3,6,"Clinical","3 teaching units"],
  ["15","Orthopaedics",1,1,2,4,"Clinical","2 units; incl. PMR"],
  ["16","ENT",1,1,1,3,"Clinical","Head = Professor"],
  ["17","Ophthalmology",1,1,1,3,"Clinical","Head = Professor"],
  ["18","Obstetrics & Gynaecology",1,2,2,5,"Clinical","2 teaching units"],
  ["19","Anaesthesiology",1,1,2,4,"Clinical","Covers ≥ 4 OTs"],
  ["20","Radio-Diagnosis",1,1,1,3,"Clinical","CT, USG, X-ray mandatory"],
  { tot: ["TOTAL FACULTY (Core Depts)",20,24,40,84,"–","NMC full target ≈ 114"] },
];

const facRows = [facHdr];
facData.forEach(item => {
  if (item.sec) {
    facRows.push(new TableRow({ children: [secCell(item.sec, 8)] }));
  } else if (item.tot) {
    const [lbl,...vals] = item.tot;
    facRows.push(new TableRow({ children: [
      totCell(""),totCell(lbl,{align:AlignmentType.LEFT}),
      totCell(String(vals[0])),totCell(String(vals[1])),
      totCell(String(vals[2])),totCell(String(vals[3])),
      totCell(String(vals[4])),totCell(String(vals[5])),
    ]}));
  } else {
    const bg = facRows.length % 2 === 0 ? LT_GREY : WHITE;
    facRows.push(new TableRow({ children: [
      dataCell(item[0], { align: AlignmentType.CENTER, bg }),
      dataCell(item[1], { bg, bold: true }),
      dataCell(String(item[2]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[3]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[4]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[5]), { align: AlignmentType.CENTER, bg, bold: true }),
      dataCell(String(item[6]), { align: AlignmentType.CENTER, bg }),
      dataCell(String(item[7]), { bg }),
    ]}));
  }
});
children.push(new Table({ rows: facRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 4 – RESIDENTS & DEMONSTRATORS
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 4 – RESIDENTS, DEMONSTRATORS & TUTORS"));
children.push(infoBox("Annual Intake: 150 Students  |  NMC Target: ≈ 90 posts"));
children.push(spacer());

const resHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 600 }),
    hdrCell("Department", { width: 3000 }),
    hdrCell("Senior Residents", { width: 1400 }),
    hdrCell("Demonstrators / Jr. Residents", { width: 1800 }),
    hdrCell("Tutors", { width: 900 }),
    hdrCell("Remarks", { width: 1650 }),
  ],
  tableHeader: true,
});

const resData = [
  { sec: "PRE-CLINICAL" },
  ["1","Anatomy",0,4,2,"Demonstrators for practicals"],
  ["2","Physiology",0,3,2,"MBBS/MSc eligible"],
  ["3","Biochemistry",0,2,1,"Demonstrators"],
  { sec: "PARA-CLINICAL" },
  ["4","Pathology",2,3,1,"SR for lab & OPD diagnostics"],
  ["5","Microbiology",1,2,1,"Biosafety training"],
  ["6","Pharmacology",0,2,1,"Animal experiment supervision"],
  ["7","Forensic Medicine",1,1,0,"SR for mortuary & MLC work"],
  ["8","Community Medicine",1,2,1,"Field tutors; CHC/PHC staff"],
  { sec: "CLINICAL DEPARTMENTS" },
  ["9","General Medicine",3,3,0,"1 SR per teaching unit"],
  ["10","Paediatrics",2,2,0,"NICU SR required"],
  ["11","Dermatology & STD",1,1,0,""],
  ["12","Psychiatry",1,1,0,""],
  ["13","Respiratory Medicine",1,1,0,""],
  ["14","General Surgery",3,3,0,"1 per unit; emergency cover"],
  ["15","Orthopaedics",2,2,0,"Trauma cover"],
  ["16","ENT",1,1,0,""],
  ["17","Ophthalmology",1,1,0,""],
  ["18","Obstetrics & Gynaecology",2,2,0,"24×7 labour room cover"],
  ["19","Anaesthesiology",2,2,0,"24×7 OT cover mandatory"],
  ["20","Radio-Diagnosis",1,1,0,""],
  { tot: ["APPROXIMATE TOTAL",25,42,9,"NMC target ≈ 90 for 150-seat college"] },
];

const resRows = [resHdr];
resData.forEach(item => {
  if (item.sec) {
    resRows.push(new TableRow({ children: [secCell(item.sec, 6)] }));
  } else if (item.tot) {
    const [lbl,...vals] = item.tot;
    resRows.push(new TableRow({ children: [
      totCell(""),totCell(lbl,{align:AlignmentType.LEFT}),
      totCell(String(vals[0])),totCell(String(vals[1])),
      totCell(String(vals[2])),totCell(String(vals[3])),
    ]}));
  } else {
    const bg = resRows.length % 2 === 0 ? LT_GREY : WHITE;
    resRows.push(new TableRow({ children: [
      dataCell(item[0],{align:AlignmentType.CENTER,bg}),
      dataCell(item[1],{bg,bold:true}),
      dataCell(String(item[2]),{align:AlignmentType.CENTER,bg}),
      dataCell(String(item[3]),{align:AlignmentType.CENTER,bg}),
      dataCell(String(item[4]),{align:AlignmentType.CENTER,bg}),
      dataCell(String(item[5]),{bg}),
    ]}));
  }
});
children.push(new Table({ rows: resRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 5 – DEPARTMENTS & LABS
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 5 – DEPARTMENTS & LABORATORY REQUIREMENTS"));
children.push(infoBox("Annual Intake: 150 Students"));
children.push(spacer());

const labHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 550 }),
    hdrCell("Department", { width: 2200 }),
    hdrCell("Key Laboratory / Facility", { width: 3000 }),
    hdrCell("Min. Area (Sq.m.)", { width: 1300 }),
    hdrCell("Essential Equipment / Remarks", { width: 2300 }),
  ],
  tableHeader: true,
});

const labData = [
  { sec: "PRE-CLINICAL" },
  ["1","Anatomy","Dissection hall + museum + histology + embalming room","≥ 1,200","150 dissection tables; plastinated specimens; models"],
  ["2","Physiology","Physiology lab + clinical physiology + haematology bench","≥ 900","Spirometers, ECG ×6, audiometers, microscopes"],
  ["3","Biochemistry","Biochemistry lab + research lab","≥ 900","Auto-analyser, spectrophotometers, electrophoresis unit"],
  { sec: "PARA-CLINICAL" },
  ["4","Pathology","Histopathology + cytology + haematology + clinical path","≥ 1,200","50 microscopes; frozen section; NABL desirable"],
  ["5","Microbiology","Bacteriology + virology + serology + parasitology","≥ 900","BSL-2 cabinet; autoclave; PCR; NABL desirable"],
  ["6","Pharmacology","Experimental + clinical pharmacology + museum","≥ 600","CPCSEA animal house; pharmacokinetics software"],
  ["7","Forensic Medicine","Forensic lab + museum + PM room (mortuary)","≥ 400","Toxicology lab; DNA extraction; photo documentation"],
  ["8","Community Medicine","PSM lab + stats lab + field practice area","≥ 600","Urban HC + Rural CHC/PHC attached"],
  { sec: "CLINICAL DEPARTMENTS" },
  ["9","General Medicine","Clinical lab; ECG; echo","≥ 400","Bedside monitors; defibrillators; 2D echo"],
  ["10","General Surgery","Surgical skills; wound care","≥ 400","Laparoscopy trainer; basic surgical stations"],
  ["11","Obstetrics & Gynaecology","Labour room; colposcopy; NST room","≥ 500","CTG ×4; foetal doppler; colposcope"],
  ["12","Paediatrics","NICU; PICU; growth monitoring lab","≥ 400","Phototherapy; paed. ventilators; incubators"],
  ["13","Orthopaedics & PMR","Plaster room; physiotherapy dept","≥ 600","Traction units; physiotherapy equipment"],
  ["14","ENT","Audiometry lab; endoscopy room","≥ 300","Pure-tone audiometer; rigid + flexible endoscopes"],
  ["15","Ophthalmology","Refraction clinic; retinal imaging","≥ 300","Slit lamp ×4; fundus camera; OCT desirable"],
  ["16","Anaesthesiology","OT stations; pain clinic","Part of OT","Anaesthesia machines ×4; fibreoptic bronchoscope"],
  ["17","Radio-Diagnosis","X-ray; USG; CT scan","≥ 600","Digital X-ray ×2; USG ×2; CT mandatory; MRI desirable"],
  ["18","Psychiatry","Counselling rooms; ECT suite","≥ 200","ECT machine; biofeedback; cognitive tools"],
  { sec: "SUPPORT SERVICES" },
  ["19","Central Clinical Lab","Biochemistry + haematology + microbiology","≥ 600","NABL accredited; 24×7 emergency lab"],
  ["20","Central Library","Physical + digital library","≥ 1,200","INFLIBNET; e-journals; reading room ≥ 120 seats"],
  ["21","Skills Laboratory","OSCE/OSPE simulation lab","≥ 600","4 exam rooms; video recording; Harvey simulator"],
  ["22","Medical Education Unit","Faculty development + curriculum","≥ 200","Active MEU; BCME-trained faculty mandatory"],
];

const labRows = [labHdr];
labData.forEach(item => {
  if (item.sec) {
    labRows.push(new TableRow({ children: [secCell(item.sec, 5)] }));
  } else {
    const bg = labRows.length % 2 === 0 ? LT_GREY : WHITE;
    labRows.push(new TableRow({ children: [
      dataCell(item[0],{align:AlignmentType.CENTER,bg}),
      dataCell(item[1],{bg,bold:true}),
      dataCell(item[2],{bg}),
      dataCell(item[3],{align:AlignmentType.CENTER,bg}),
      dataCell(item[4],{bg}),
    ]}));
  }
});
children.push(new Table({ rows: labRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 6 – OPD & CLINICAL LOAD
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 6 – OPD & CLINICAL LOAD REQUIREMENTS"));
children.push(infoBox("Annual Intake: 150 Students"));
children.push(spacer());

const opdHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 550 }),
    hdrCell("Parameter", { width: 2500 }),
    hdrCell("NMC Norm", { width: 2300 }),
    hdrCell("For 150 Seats (Calculated)", { width: 1900 }),
    hdrCell("Remarks", { width: 2100 }),
  ],
  tableHeader: true,
});

const opdData = [
  ["1","Daily OPD Attendance","≥ 8 patients per student per day","≥ 1,200 patients/day","150 × 8 = 1,200; old + new patients"],
  ["2","Indoor Bed Occupancy","≥ 80% average annual","≥ 480 beds occupied/day","Mandatory for annual NMC renewal"],
  ["3","Major Surgical Operations","Adequate operative load","≥ 50 major surgeries/month","Logbook verified"],
  ["4","Caesarean / Major O&G","Adequate O&G caseload","≥ 25 procedures/month","Normal deliveries + LSCS"],
  ["5","Emergency / Casualty","24×7 casualty services","≥ 50 patients/day","Trauma, medical, obstetric emergencies"],
  ["6","Radiology Investigations","Adequate imaging load","≥ 50 X-rays + 20 USG/day","CT scan services mandatory"],
  ["7","Laboratory Investigations","Central lab 24×7","≥ 500 tests/day","Biochemistry + haematology + microbiology"],
  ["8","Blood Bank","Licensed blood bank","≥ 100 units/month","Component separation mandatory"],
  ["9","SNCU / NICU Admissions","Adequate neonatal caseload","≥ 15 admissions/month","For paediatric training"],
  ["10","Post-mortem Cases","Adequate forensic caseload","≥ 15 PMs/month","MLCs, trauma, institutional deaths"],
  ["11","Community Field Training","Urban + rural HC attached","1 Urban + 1 Rural PHC/CHC","Population coverage ≥ 30,000 each"],
  ["12","Internship Postings","12-month rotating internship","All clinical depts covered","CBME logbook; supervised by faculty"],
];

const opdRows = [opdHdr];
opdData.forEach(item => {
  const bg = opdRows.length % 2 === 0 ? LT_GREY : WHITE;
  opdRows.push(new TableRow({ children: [
    dataCell(item[0],{align:AlignmentType.CENTER,bg}),
    dataCell(item[1],{bg,bold:true}),
    dataCell(item[2],{bg}),
    dataCell(item[3],{bg:"D6E8F6",bold:true}),
    dataCell(item[4],{bg}),
  ]}));
});
children.push(new Table({ rows: opdRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 7 – EQUIPMENT
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 7 – KEY EQUIPMENT & ANCILLARY FACILITIES"));
children.push(infoBox("Annual Intake: 150 Students"));
children.push(spacer());

const eqHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 600 }),
    hdrCell("Equipment / Facility", { width: 2800 }),
    hdrCell("Minimum Specification", { width: 2800 }),
    hdrCell("Qty", { width: 1000 }),
    hdrCell("Remarks", { width: 2150 }),
  ],
  tableHeader: true,
});

const eqData = [
  { sec: "DIAGNOSTIC EQUIPMENT" },
  ["1","Digital X-ray Machine","Computed / Digital Radiography","≥ 2","OPD + casualty"],
  ["2","Ultrasound Machine","B-mode + Doppler","≥ 2","O&G + general"],
  ["3","CT Scan","Multi-slice ≥ 16 slice","≥ 1","Mandatory for recognition"],
  ["4","MRI","1.5 Tesla","Desirable","Recommended; not mandatory"],
  ["5","Echocardiography","2D Echo + Doppler","≥ 1","Medicine / Cardiology"],
  ["6","ECG Machine","12-lead","≥ 6","Wards + OPD + ICU + emergency"],
  ["7","Defibrillator","Biphasic","≥ 4","ICU, OT, casualty, CCU"],
  ["8","Mechanical Ventilator","ICU-grade","≥ 10","General ICU + NICU"],
  ["9","Multi-parameter Monitor","Pulse ox + NIBP + ECG","≥ 20","ICU, HDU, NICU, OT"],
  ["10","Operating Microscope","Surgical grade","≥ 2","ENT + Ophthalmology"],
  { sec: "SURGICAL & OT EQUIPMENT" },
  ["11","OT Table","Motorised multi-position","≥ 4","One per major OT"],
  ["12","Anaesthesia Workstation","With integrated ventilator","≥ 4","One per OT"],
  ["13","Laparoscopic Set","HD camera + monitor + insufflator","≥ 1 set","General Surgery"],
  ["14","Endoscopy Set","Rigid + flexible","≥ 2 sets","ENT + GI"],
  { sec: "LABORATORY EQUIPMENT" },
  ["15","Biochemistry Auto-analyser","Fully automated","≥ 1","Central lab"],
  ["16","Haematology Analyser","5-part differential","≥ 1","Central lab"],
  ["17","Blood Gas Analyser","POC arterial blood gas","≥ 1","ICU / Emergency"],
  ["18","Binocular Microscopes","Light microscopy","≥ 50","Pre-clinical + para-clinical"],
  ["19","Centrifuges","High-speed refrigerated","≥ 6","All labs"],
  ["20","PCR Machine","Real-time PCR","≥ 1","Microbiology / research"],
  ["21","Biosafety Cabinet","Class II Type A2","≥ 2","Microbiology; BSL-2"],
  { sec: "ANCILLARY & COMPLIANCE" },
  ["22","AEBAS Biometric System","Aadhaar-linked attendance","Campus-wide","Mandatory – NMC inspection"],
  ["23","CCTV Surveillance","IP cameras – labs, OT, entries","Adequate","Safety & monitoring"],
  ["24","Medical Gas Pipeline","O2, N2O, Vacuum, Air","All OTs+ICUs+wards","MGPS installation mandatory"],
  ["25","Hospital Info. System","Integrated HIS/HMIS","1 system","OPD, IPD, billing, lab, pharmacy"],
  ["26","BMW Management","CPCB compliant","Compliant","Biomedical waste NOC required"],
];

const eqRows = [eqHdr];
eqData.forEach(item => {
  if (item.sec) {
    eqRows.push(new TableRow({ children: [secCell(item.sec, 5)] }));
  } else {
    const bg = eqRows.length % 2 === 0 ? LT_GREY : WHITE;
    eqRows.push(new TableRow({ children: [
      dataCell(item[0],{align:AlignmentType.CENTER,bg}),
      dataCell(item[1],{bg,bold:true}),
      dataCell(item[2],{bg}),
      dataCell(item[3],{align:AlignmentType.CENTER,bg}),
      dataCell(item[4],{bg}),
    ]}));
  }
});
children.push(new Table({ rows: eqRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(pgBreak());

// ═══════════════════════════════════════════════════════
// SECTION 8 – INSPECTION CHECKLIST
// ═══════════════════════════════════════════════════════
children.push(heading1("SECTION 8 – NMC INSPECTION CHECKLIST (SELF-ASSESSMENT)"));
children.push(infoBox("Instructions: Fill Column D = Actual status  |  Column E (green) = Y / N compliance  |  Column F = corrective action"));
children.push(spacer());

const chkHdr = new TableRow({
  children: [
    hdrCell("S.No.", { width: 500 }),
    hdrCell("Parameter", { width: 3000 }),
    hdrCell("NMC Norm (150 Seats)", { width: 2200 }),
    hdrCell("Actual Status", { width: 1500 }),
    hdrCell("Compliant? (Y/N)", { width: 1200 }),
    hdrCell("Remarks / Action", { width: 1950 }),
  ],
  tableHeader: true,
});

const chkData = [
  { sec: "A. INFRASTRUCTURE" },
  ["1","College Building Area","≥ 17,000 Sq.m.","","",""],
  ["2","Lecture Theatres – College","≥ 2 (each ≥ 150 seats)","","",""],
  ["3","Central Library","≥ 1,200 Sq.m.; e-journals","","",""],
  ["4","Skills Laboratory","≥ 600 Sq.m.; ≥ 4 exam rooms","","",""],
  ["5","Anatomy Dissection Hall","≥ 1,200 Sq.m.; ≥ 150 tables","","",""],
  ["6","Boys Hostel","≥ 50% male batch capacity","","",""],
  ["7","Girls Hostel","≥ 50% female batch capacity","","",""],
  ["8","Power Backup","100% UPS for ICU/OT/Casualty","","",""],
  { sec: "B. TEACHING HOSPITAL" },
  ["9","Total Indoor Beds","≥ 600 (4 × 150)","","",""],
  ["10","Hospital Built-up Area","≥ 25,000 Sq.m.","","",""],
  ["11","OPD Area","≥ 3,000 Sq.m.","","",""],
  ["12","Major Operating Theatres","≥ 4","","",""],
  ["13","ICU Beds (all types)","≥ 30","","",""],
  ["14","Labour Rooms","≥ 4 tables","","",""],
  ["15","Blood Bank","Licensed; 24×7; components","","",""],
  ["16","CSSD","Functional; adequate capacity","","",""],
  ["17","CT Scan","≥ 1 (mandatory)","","",""],
  ["18","Casualty / Emergency","24×7 operational","","",""],
  { sec: "C. FACULTY & STAFF" },
  ["19","Total Teaching Faculty","≥ 114 (NMC MSR 2023)","","",""],
  ["20","Professors (total)","≥ 20-21","","",""],
  ["21","Associate Professors","≥ 24-25","","",""],
  ["22","Assistant Professors","≥ 40-43","","",""],
  ["23","Senior Residents","≥ 25","","",""],
  ["24","Demonstrators / Jr. Residents","≥ 42","","",""],
  ["25","Tutors","≥ 9","","",""],
  { sec: "D. CLINICAL LOAD" },
  ["26","Daily OPD Attendance","≥ 1,200 patients/day","","",""],
  ["27","Indoor Bed Occupancy","≥ 80% per annum","","",""],
  ["28","Major Surgeries","≥ 50 / month","","",""],
  ["29","Casualty Attendance","≥ 50 patients/day","","",""],
  ["30","Post-mortems / Forensic Cases","≥ 15 PMs/month","","",""],
  { sec: "E. COMPLIANCE & SYSTEMS" },
  ["31","AEBAS Biometric System","Fully operational – all staff","","",""],
  ["32","Fire NOC","Valid from competent authority","","",""],
  ["33","BMW Management","CPCB compliant; NOC valid","","",""],
  ["34","University Affiliation Certificate","Valid and current","","",""],
  ["35","Essentiality Certificate (State)","Valid and current","","",""],
  ["36","Medical Education Unit","Active; BCME-trained faculty","","",""],
  ["37","Animal House – Pharmacology","CPCSEA approved","","",""],
  ["38","Community Health Centres","Urban HC + Rural CHC/PHC","","",""],
  ["39","NABL Accreditation (Central Lab)","Mandatory for new colleges","","",""],
  ["40","NMC Web Portal Compliance","Data uploaded on NMC portal","","",""],
];

const chkRows = [chkHdr];
chkData.forEach(item => {
  if (item.sec) {
    chkRows.push(new TableRow({ children: [secCell(item.sec, 6)] }));
  } else {
    const bg = chkRows.length % 2 === 0 ? LT_GREY : WHITE;
    chkRows.push(new TableRow({ children: [
      dataCell(item[0],{align:AlignmentType.CENTER,bg}),
      dataCell(item[1],{bg,bold:true}),
      dataCell(item[2],{bg}),
      dataCell(item[3],{bg}),
      dataCell(item[4],{bg:LT_GREEN,align:AlignmentType.CENTER}),
      dataCell(item[5],{bg}),
    ]}));
  }
});
children.push(new Table({ rows: chkRows, width: { size: 100, type: WidthType.PERCENTAGE } }));
children.push(spacer());
children.push(noteBox(
  "Note: Based on NMC Minimum Standard Requirements Regulations 2023 (Gazette Notification, August 2023). " +
  "Valid from Academic Year 2024-25. Maximum MBBS intake capped at 150 seats as per current NMC policy."
));

// ─────────────────────────────────────────────────────────
// BUILD DOCUMENT
// ─────────────────────────────────────────────────────────
const doc = new Document({
  title: "NMC MSR 2023 - 150 Seats MBBS Requirements",
  subject: "NMC Minimum Standard Requirements",
  creator: "NMC Inspection Tool",
  description: "Minimum Standard Requirements for 150-seat MBBS college - NMC MSR 2023",
  sections: [{
    properties: {
      page: {
        margin: { top: 720, bottom: 720, left: 720, right: 720 },
      },
    },
    headers: {
      default: new Header({
        children: [
          new Paragraph({
            children: [
              t("NMC MSR 2023 – Minimum Standard Requirements | 150-Seat MBBS College", {
                size: 16, color: "595959",
              }),
              new TextRun({ children: ["\t", PageNumber.CURRENT], font: "Arial", size: 16, color: "595959" }),
            ],
            alignment: AlignmentType.LEFT,
            border: { bottom: { style: BorderStyle.SINGLE, size: 6, color: MED_BLUE } },
            tabStops: [{ type: "right", position: 9360 }],
          }),
        ],
      }),
    },
    footers: {
      default: new Footer({
        children: [
          new Paragraph({
            children: [
              t("Reference: NMC Gazette Notification, August 2023  |  Valid from A.Y. 2024-25  |  Page ", {
                size: 15, color: "595959",
              }),
              new TextRun({ children: [PageNumber.CURRENT], font: "Arial", size: 15, color: "595959" }),
              t(" of ", { size: 15, color: "595959" }),
              new TextRun({ children: [PageNumber.TOTAL_PAGES], font: "Arial", size: 15, color: "595959" }),
            ],
            alignment: AlignmentType.CENTER,
            border: { top: { style: BorderStyle.SINGLE, size: 6, color: MED_BLUE } },
          }),
        ],
      }),
    },
    children,
  }],
});

Packer.toBuffer(doc).then(buffer => {
  fs.writeFileSync('/tmp/NMC_MSR2023_150Seats.docx', buffer);
  console.log('DOCX written to /tmp');
});