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

# ── colour palette ──────────────────────────────────────────────────────────
HEADER_FILL   = PatternFill("solid", fgColor="1F4E79")   # dark navy
SUBHDR_FILL   = PatternFill("solid", fgColor="2E75B6")   # mid-blue
HIGH_FILL     = PatternFill("solid", fgColor="C6EFCE")   # green
MOD_FILL      = PatternFill("solid", fgColor="FFEB9C")   # yellow
LOW_FILL      = PatternFill("solid", fgColor="FFC7CE")   # red
ALT_FILL      = PatternFill("solid", fgColor="DEEAF1")   # light blue row
WHITE_FILL    = PatternFill("solid", fgColor="FFFFFF")

HEADER_FONT   = Font(name="Arial", bold=True, color="FFFFFF", size=11)
SUBHDR_FONT   = Font(name="Arial", bold=True, color="FFFFFF", size=10)
TITLE_FONT    = Font(name="Arial", bold=True, color="1F4E79", size=13)
BODY_FONT     = Font(name="Arial", size=10)
BOLD_FONT     = Font(name="Arial", bold=True, size=10)

thin = Side(style="thin", color="B8CCE4")
BORDER = Border(left=thin, right=thin, top=thin, bottom=thin)

COLUMNS = ["#", "Topic", "Category", "Study Type",
           "Data Access", "Lab/Special Equipment",
           "Ethics Complexity", "Time Required", "Cost",
           "Overall Feasibility"]

COL_WIDTHS = [4, 62, 22, 28, 22, 26, 20, 16, 10, 22]

# ── feasibility star helper ──────────────────────────────────────────────────
def stars(n):
    return "★" * n + "☆" * (3 - n)

def feas_fill(rating):
    if rating == 3: return HIGH_FILL
    if rating == 2: return MOD_FILL
    return LOW_FILL

# ── DATA ─────────────────────────────────────────────────────────────────────
# Each row: (topic, category, study_type, data_access, lab, ethics, time, cost, feasibility 1-3)

SPECIALTIES = {}

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Nephrology"] = [
    ("Drug utilization study of drugs in CKD patients (stages 3-5)", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of antihypertensives in CKD patients", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug dose adjustment assessment in CKD inpatients", "Drug Safety", "Retrospective/Prospective", "Easy – ward + lab records", "No", "Simple", "Medium", "Low", 3),
    ("Drug utilization review of erythropoiesis-stimulating agents in CKD", "Drug Utilization", "Retrospective", "Easy – ward/dialysis records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of nephrotoxic drug use in hospitalized patients", "Drug Safety", "Retrospective/Prospective", "Easy – case sheets + lab", "No", "Simple", "Medium", "Low", 3),
    ("Drug utilization of immunosuppressants in renal transplant patients", "Drug Utilization", "Retrospective", "Moderate – transplant records", "No", "Moderate", "Medium", "Low", 2),
    ("Medication adherence in CKD/dialysis patients (MMAS-8)", "Adherence", "Cross-sectional", "Easy – dialysis unit OPD", "No", "Simple", "Short", "Low", 3),
    ("Assessment of medication adherence in renal transplant patients", "Adherence", "Cross-sectional", "Easy – transplant OPD", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on adherence in CKD patients", "Adherence", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("ADR monitoring of nephrotoxic drugs (NSAIDs, aminoglycosides, contrast)", "ADR/PV", "Prospective Observational", "Easy – ward patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of immunosuppressants in transplant patients", "ADR/PV", "Prospective Observational", "Moderate – transplant unit", "No", "Moderate", "Long", "Low", 2),
    ("Contrast-induced nephropathy – incidence and risk factor assessment", "Drug Safety", "Prospective Observational", "Easy – radiology + nephro ward", "No", "Simple", "Medium", "Low", 3),
    ("Identification of DRPs in CKD inpatients using PCNE classification", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug-drug interactions in polypharmacy CKD patients", "DRP", "Retrospective/Prospective", "Easy – prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Assessment of potassium-raising drug combinations in CKD patients", "Drug Safety", "Retrospective", "Easy – case records + labs", "No", "Simple", "Short", "Low", 3),
    ("Appropriateness of antibiotic dosing in CKD patients (renal dose adjustment)", "Medication Safety", "Retrospective", "Easy – ward records + eGFR", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist intervention on drug dose optimization in CKD", "Clinical Pharmacist", "Prospective Interventional", "Easy – ward patients", "No", "Moderate", "Medium", "Low", 3),
    ("Role of pharmacist in renal transplant medication management", "Clinical Pharmacist", "Prospective Observational", "Moderate – transplant OPD", "No", "Moderate", "Medium", "Low", 2),
    ("Assessment of calcium-phosphate balance and pharmacotherapy in dialysis patients", "Drug Utilization", "Cross-sectional", "Easy – dialysis unit records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of anemia management in CKD – iron, EPO, B12 use patterns", "Drug Utilization", "Retrospective", "Easy – dialysis/ward records", "No", "Simple", "Short", "Low", 3),
    ("KAP of CKD patients on dietary restrictions and medication use", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Patient knowledge on dialysis-related medications and adherence", "KAP", "Cross-sectional Survey", "Easy – dialysis unit", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in CKD/dialysis patients using KDQOL-SF", "QoL/Pharmaco-economics", "Cross-sectional", "Easy – dialysis unit OPD", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of CKD in a tertiary care hospital", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic analysis of peritoneal vs. hemodialysis drug costs", "Pharmaco-economics", "Retrospective Comparative", "Moderate – dialysis records + billing", "No", "Moderate", "Medium", "Low", 2),
    ("Assessment of RAAS inhibitor use and outcomes in CKD patients", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of SGLT2 inhibitor prescribing in diabetic nephropathy", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug-induced acute kidney injury (AKI) – identification and assessment", "Drug Safety", "Prospective Observational", "Easy – ward + lab records", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of proton pump inhibitor (PPI) overuse in CKD patients", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Medication reconciliation at dialysis initiation – discrepancy analysis", "Medication Safety", "Prospective Observational", "Easy – dialysis ward records", "No", "Moderate", "Medium", "Low", 3),
    ("Pharmacist role in phosphate binder counseling and adherence", "Clinical Pharmacist", "Prospective Interventional", "Easy – dialysis unit", "No", "Moderate", "Medium", "Low", 3),
    ("Assessment of vancomycin dosing in patients with renal impairment", "Drug Safety", "Retrospective", "Easy – ward + TDM records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of antibiotic stewardship in UTI/renal infection patients", "Antibiotic Stewardship", "Retrospective/Audit", "Easy – ward + microbiology records", "No", "Simple", "Short", "Low", 3),
    ("Sleep disorders and medication use in dialysis patients", "Drug Utilization", "Cross-sectional", "Easy – dialysis unit OPD", "No", "Simple", "Short", "Low", 3),
    ("Assessment of cardiovascular drug use in CKD patients – guideline adherence", "Drug Utilization", "Retrospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Respiratory"] = [
    ("Drug utilization study of bronchodilators in COPD patients", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of inhaled corticosteroids (ICS) in asthma patients", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of inhaler technique in asthma/COPD patients", "Medication Safety", "Cross-sectional", "Easy – OPD patients (direct observation)", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist-led inhaler technique education on patient outcomes", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug utilization review of antibiotics in community-acquired pneumonia (CAP)", "Drug Utilization/AMS", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of adherence to GOLD guidelines in COPD management", "Drug Utilization", "Retrospective/Audit", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of antituberculosis drugs and adherence to RNTCP/NTEP", "Drug Utilization", "Retrospective", "Easy – DOTS records", "No", "Simple", "Short", "Low", 3),
    ("Medication adherence in asthma patients and associated factors (MMAS-8)", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Adherence to inhaler therapy in COPD and impact on exacerbations", "Adherence", "Prospective Observational", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR monitoring of antituberculosis drugs – incidence, pattern, causality", "ADR/PV", "Prospective Observational", "Easy – DOTS/TB ward patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of inhaled corticosteroids and bronchodilators", "ADR/PV", "Prospective Observational", "Easy – OPD/ward patients", "No", "Simple", "Medium", "Low", 3),
    ("Drug-induced pulmonary toxicity surveillance in hospitalized patients", "ADR/PV", "Prospective Observational", "Easy – respiratory ward", "No", "Simple", "Medium", "Low", 3),
    ("Identification of DRPs in respiratory ward patients (PCNE classification)", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug-drug interactions in COPD/asthma polypharmacy patients", "DRP", "Retrospective/Prospective", "Easy – prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Assessment of antibiotic stewardship in hospital-acquired pneumonia", "AMS", "Retrospective/Audit", "Easy – ward + micro records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of nebulization therapy practices in hospitalized patients", "Medication Safety", "Cross-sectional/Audit", "Easy – ward records/observation", "No", "Simple", "Short", "Low", 3),
    ("KAP of asthma patients on trigger avoidance and medication use", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Assessment of patient knowledge on inhaler devices and spacer use", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in COPD patients using St. George Respiratory Questionnaire (SGRQ)", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in asthma patients using Asthma Quality of Life Questionnaire (AQLQ)", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of COPD exacerbations in a tertiary care hospital", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic analysis of generic vs. branded inhalers", "Pharmaco-economics", "Retrospective Comparative", "Easy – pharmacy records", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on self-management in COPD patients", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Assessment of corticosteroid overuse in asthma management", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of step-up/step-down asthma therapy – GINA guideline adherence", "Drug Utilization", "Retrospective/Audit", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of biologics (omalizumab, mepolizumab) in severe asthma", "Drug Utilization", "Retrospective", "Moderate – limited patient numbers", "No", "Simple", "Medium", "Low", 2),
    ("Assessment of COVID-19 related respiratory drug use patterns", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Pharmacist role in smoking cessation programs – counseling and NRT use", "Clinical Pharmacist", "Prospective Observational/Interventional", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Evaluation of oxygen therapy prescribing practices in COPD patients", "Medication Safety", "Retrospective/Audit", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of fixed-dose combination inhalers use vs. separate devices", "Drug Utilization", "Cross-sectional", "Easy – OPD/pharmacy records", "No", "Simple", "Short", "Low", 3),
    ("Medication reconciliation at discharge in respiratory inpatients", "Medication Safety", "Prospective Observational", "Easy – ward records", "No", "Moderate", "Medium", "Low", 3),
    ("Assessment of theophylline use and toxicity monitoring in COPD patients", "Drug Safety", "Retrospective/Prospective", "Easy – ward + TDM records", "No", "Simple", "Medium", "Low", 3),
    ("Antibiotic prescribing in acute exacerbation of COPD (AECOPD)", "AMS", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("KAP of healthcare providers on non-pharmacological management of asthma/COPD", "KAP", "Cross-sectional Survey", "Easy – HCPs as subjects", "No", "Simple", "Short", "Low", 3),
    ("Self-medication practices with OTC inhalers/bronchodilators in community", "Community Pharmacy", "Cross-sectional Survey", "Easy – community/OPD patients", "No", "Simple", "Short", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Endocrinology"] = [
    ("Drug utilization study of antidiabetic drugs in Type 2 DM outpatients", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of insulin in T1DM and T2DM inpatients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of SGLT2 inhibitor and GLP-1 agonist prescribing patterns", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization review of thyroid drugs (levothyroxine) in hypothyroid patients", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern in gestational diabetes mellitus (GDM)", "Drug Utilization", "Retrospective/Prospective", "Easy – OPD/ward records", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of drug use in polycystic ovarian syndrome (PCOS)", "Drug Utilization", "Cross-sectional/Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Medication adherence in Type 2 DM patients (MMAS-8) and glycemic control", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on HbA1c levels in T2DM patients", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Adherence to insulin therapy and barriers in T1DM patients", "Adherence", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Adherence to antithyroid drugs in hyperthyroidism patients", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("ADR monitoring of antidiabetic drugs – hypoglycemia, GI effects, weight changes", "ADR/PV", "Prospective Observational", "Easy – OPD/ward patients", "No", "Simple", "Medium", "Low", 3),
    ("Drug-induced hyperglycemia surveillance in hospitalized patients", "ADR/PV", "Prospective Observational", "Easy – ward + lab records", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of SGLT2 inhibitors – DKA, UTI, genital infections", "ADR/PV", "Prospective Observational", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Identification of DRPs in diabetic inpatients using PCNE classification", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug-drug interactions in polypharmacy diabetic patients", "DRP", "Retrospective/Prospective", "Easy – prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Assessment of inappropriate medication use in elderly diabetic patients (Beers/STOPP)", "DRP", "Retrospective", "Easy – case records", "No", "Simple", "Short", "Low", 3),
    ("KAP of diabetic patients on blood glucose monitoring and insulin self-administration", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Assessment of patient knowledge on hypoglycemia recognition and management", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("KAP of hypothyroid patients on levothyroxine use and dietary interactions", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in Type 2 DM patients using SF-36 / EQ-5D", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in hypothyroid patients and impact of treatment", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of Type 2 diabetes mellitus in a tertiary care hospital", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic comparison of oral antidiabetic regimens vs. insulin", "Pharmaco-economics", "Retrospective Comparative", "Easy – pharmacy + billing records", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of dyslipidemia management in diabetic patients – statin use patterns", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Pharmacist-led diabetes education program – impact on self-care behaviour", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Evaluation of glycemic control in T2DM patients on combination therapy", "Clinical Outcomes", "Prospective Observational", "Easy – OPD records + HbA1c", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of metformin use – appropriateness and contraindications", "Medication Safety", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of weight-loss medications in obese diabetic patients", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of diabetic complication screening and pharmacotherapy", "Clinical Outcomes", "Cross-sectional", "Easy – OPD patients + records", "No", "Simple", "Short", "Low", 3),
    ("Self-medication practices with OTC supplements in diabetic patients", "Community Pharmacy", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of insulin storage and handling practices in diabetic patients", "Medication Safety", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Pharmacist role in continuous glucose monitoring (CGM) education", "Clinical Pharmacist", "Prospective Observational", "Moderate – CGM device access", "No", "Moderate", "Medium", "Medium", 2),
    ("Assessment of prescribing in diabetic nephropathy – RAAS + SGLT2 combinations", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of antiobesity drugs and pharmacist counseling role", "Drug Utilization", "Cross-sectional/Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of steroid-induced hyperglycemia management in hospitalized patients", "Drug Safety", "Prospective Observational", "Easy – ward + lab records", "No", "Simple", "Medium", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Infectious Diseases"] = [
    ("Drug utilization study of antibiotics in a medicine/surgical ward (WHO DDD)", "Drug Utilization/AMS", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of antibiotic prescribing practices against standard guidelines (AWaRe)", "AMS", "Retrospective/Audit", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Antibiotic stewardship program (ASP) implementation and evaluation", "AMS", "Prospective Interventional", "Easy – ward records + micro", "No", "Moderate", "Medium", "Low", 3),
    ("Prescribing pattern of antiretrovirals (ART) in HIV patients – guideline adherence", "Drug Utilization", "Retrospective", "Easy – ART clinic records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization study of antifungal drugs in immunocompromised patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of antibiotic use in febrile neutropenia patients", "AMS", "Retrospective", "Easy – oncology ward records", "No", "Simple", "Short", "Low", 3),
    ("Medication adherence to ART in HIV patients (MMAS-8)", "Adherence", "Cross-sectional", "Easy – ART clinic patients", "No", "Simple", "Short", "Low", 3),
    ("Adherence to antituberculosis drugs and factors affecting it (DOTS patients)", "Adherence", "Cross-sectional Survey", "Easy – DOTS centre records", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on ART adherence and CD4 outcomes", "Clinical Pharmacist", "Prospective Interventional", "Easy – ART clinic", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("ADR monitoring and reporting in HIV/TB co-infected patients on HAART + ATT", "ADR/PV", "Prospective Observational", "Easy – HIV/TB ward patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of first-line ART regimens in HIV patients", "ADR/PV", "Prospective Observational", "Easy – ART clinic patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR monitoring of antituberculosis drugs – hepatotoxicity, peripheral neuropathy", "ADR/PV", "Prospective Observational", "Easy – TB ward/DOTS patients", "No", "Simple", "Medium", "Low", 3),
    ("Drug-induced liver injury (DILI) in patients on ATT – incidence and management", "Drug Safety", "Prospective Observational", "Easy – TB ward + LFT records", "No", "Simple", "Medium", "Low", 3),
    ("Drug-drug interactions in HIV patients on ART + co-medications", "DRP", "Retrospective/Prospective", "Easy – ART clinic prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Identification of DRPs in infectious disease ward patients (PCNE)", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("KAP of patients on HIV/AIDS regarding ART adherence and drug interactions", "KAP", "Cross-sectional Survey", "Easy – ART clinic patients", "No", "Simple", "Short", "Low", 3),
    ("KAP of healthcare providers on antimicrobial resistance (AMR)", "KAP", "Cross-sectional Survey", "Easy – HCPs as subjects", "No", "Simple", "Short", "Low", 3),
    ("Assessment of blood culture utilisation and antibiotic de-escalation practices", "AMS", "Retrospective/Audit", "Easy – micro lab + ward records", "No", "Simple", "Short", "Low", 3),
    ("Carbapenem use audit in ICU/medicine ward – appropriateness assessment", "AMS", "Retrospective/Audit", "Easy – ward + pharmacy records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of antifungal prophylaxis in immunocompromised patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of HIV/AIDS management in a tertiary care hospital", "Pharmaco-economics", "Retrospective", "Easy – hospital billing", "No", "Moderate", "Medium", "Low", 2),
    ("HRQoL in HIV patients on ART using SF-36/WHOQOL-BREF", "QoL", "Cross-sectional", "Easy – ART clinic patients", "No", "Simple", "Short", "Low", 3),
    ("Pharmacoeconomic impact of generic vs. innovator ART regimens", "Pharmaco-economics", "Retrospective Comparative", "Easy – pharmacy + billing records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of vaccination practices in HIV-positive patients", "Preventive Pharmacy", "Cross-sectional", "Easy – ART clinic records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of surgical antibiotic prophylaxis – appropriateness and duration", "AMS", "Retrospective/Audit", "Easy – OT + ward records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of broad-spectrum antibiotics and culture sensitivity correlation", "AMS", "Retrospective", "Easy – micro lab + ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of anti-malarial drug use and adherence in malaria patients", "Drug Utilization", "Retrospective/Prospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of antivirals in influenza/COVID-19 patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of medication errors related to antibiotic dosing and frequency", "Medication Safety", "Prospective Observational", "Easy – ward prescriptions", "No", "Moderate", "Medium", "Low", 2),
    ("Role of pharmacist in infection control and antimicrobial stewardship programs", "Clinical Pharmacist", "Prospective Observational", "Easy – ward/AMS team", "No", "Moderate", "Medium", "Low", 3),
    ("Assessment of drug resistance patterns and empirical antibiotic prescribing", "AMS", "Retrospective", "Easy – micro lab records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of antiviral therapy in Hepatitis B/C patients – guideline adherence", "Drug Utilization", "Retrospective", "Easy – hepatology/ID OPD records", "No", "Simple", "Short", "Low", 3),
    ("KAP on vaccine hesitancy among adults in a hospital setting", "KAP/Preventive", "Cross-sectional Survey", "Easy – OPD patients/staff", "No", "Simple", "Short", "Low", 3),
    ("Assessment of COVID-19 drug therapy and pharmacist interventions", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Self-medication with antibiotics – prevalence and awareness in community", "Community Pharmacy", "Cross-sectional Survey", "Easy – community patients", "No", "Simple", "Short", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Pediatrics"] = [
    ("Drug utilization study in a pediatric inpatient ward", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of off-label drug use in neonatal ICU (NICU)", "Drug Utilization", "Retrospective", "Easy – NICU records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of antibiotics in pediatric patients (WHO indicators)", "Drug Utilization/AMS", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of weight-based dose calculation errors in pediatric prescriptions", "Medication Safety", "Retrospective/Prospective", "Easy – ward prescriptions", "No", "Simple", "Medium", "Low", 3),
    ("Drug utilization review of antipyretics in febrile pediatric patients", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern in pediatric respiratory infections – antibiotic use assessment", "Drug Utilization/AMS", "Retrospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Medication errors in pediatric ward – incidence, type, and contributing factors", "Medication Safety", "Prospective Observational", "Easy – ward records/observations", "No", "Moderate", "Medium", "Low", 2),
    ("ADR monitoring and reporting in hospitalized pediatric patients", "ADR/PV", "Prospective Observational", "Easy – ward patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of antiepileptic drugs in pediatric epilepsy patients", "ADR/PV", "Prospective Observational", "Easy – neurology ward/OPD", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of antibiotic prescribing in neonatal sepsis", "Drug Utilization/AMS", "Retrospective", "Easy – NICU records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization study of iron and vitamin supplements in pediatric patients", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of ORS and zinc use in pediatric diarrhea management", "Drug Utilization", "Retrospective/Prospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of vaccination coverage and pharmacist role in pediatric OPD", "Preventive Pharmacy", "Cross-sectional Survey", "Easy – OPD parents/patients", "No", "Simple", "Short", "Low", 3),
    ("Drug-drug interactions in polypharmacy pediatric inpatients", "DRP", "Retrospective/Prospective", "Easy – ward prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Identification of DRPs in pediatric inpatients using PCNE classification", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Assessment of parental knowledge on correct antibiotic use in children", "KAP", "Cross-sectional Survey", "Easy – OPD parents", "No", "Simple", "Short", "Low", 3),
    ("KAP of parents on OTC drug use in fever and pain in children", "KAP", "Cross-sectional Survey", "Easy – OPD parents", "No", "Simple", "Short", "Low", 3),
    ("Assessment of pharmacist counseling impact on caregiver medication adherence in children", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD caregivers", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Evaluation of asthma pharmacotherapy in pediatric patients (GINA adherence)", "Drug Utilization", "Retrospective/Audit", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization in pediatric oncology patients – chemotherapy pattern study", "Drug Utilization", "Retrospective", "Moderate – oncology unit access", "No", "Moderate", "Medium", "Low", 2),
    ("Assessment of nutritional supplement prescribing in malnourished children", "Drug Utilization", "Retrospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of sedation and analgesia use in PICU patients", "Drug Utilization", "Retrospective", "Easy – PICU records", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in children with chronic illness (asthma/epilepsy) using PedsQL", "QoL", "Cross-sectional", "Easy – OPD patients/parents", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of pediatric respiratory infections", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Assessment of rational drug use in pediatric OPD using WHO core indicators", "Drug Utilization", "Cross-sectional", "Easy – OPD prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of pharmacist recommendations in pediatric ward rounds", "Clinical Pharmacist", "Prospective Observational", "Moderate – physician cooperation", "No", "Moderate", "Medium", "Low", 2),
    ("Drug-induced ADRs in pediatric patients on long-term therapy (TB, HIV, epilepsy)", "ADR/PV", "Prospective Observational", "Easy – ward/OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Prescription audit of pediatric inpatients using WHO prescribing indicators", "Drug Utilization", "Retrospective/Audit", "Easy – ward prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Assessment of medication storage and handling practices by parents at home", "Medication Safety", "Cross-sectional Survey", "Easy – OPD parents", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of antipyretic and analgesic use patterns in pediatric emergency", "Drug Utilization", "Retrospective", "Easy – emergency records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization in children with type 1 diabetes – insulin patterns and monitoring", "Drug Utilization", "Retrospective/Prospective", "Easy – OPD/ward records", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of fluid and electrolyte therapy in pediatric dehydration", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Role of pharmacist in pain management in pediatric palliative care", "Clinical Pharmacist", "Prospective Observational", "Moderate – palliative unit access", "No", "Moderate", "Medium", "Low", 2),
    ("Evaluation of antifungal use in immunocompromised pediatric patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of caregiver awareness on proper liquid medication measurement", "Medication Safety/KAP", "Cross-sectional Survey", "Easy – OPD caregivers", "No", "Simple", "Short", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Orthopedics"] = [
    ("Drug utilization study of NSAIDs in orthopedic outpatients and inpatients", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of surgical antibiotic prophylaxis in orthopedic surgeries", "AMS", "Retrospective/Audit", "Easy – OT + ward records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of analgesics in postoperative orthopedic patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of opioid use in chronic orthopedic pain management", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization review of disease-modifying antirheumatic drugs (DMARDs) in rheumatoid arthritis", "Drug Utilization", "Retrospective", "Easy – rheumatology OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of drugs in osteoarthritis management", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of calcium and vitamin D supplementation in osteoporosis patients", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Medication adherence in rheumatoid arthritis patients on DMARDs", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Adherence to bisphosphonate therapy in osteoporosis patients", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on NSAID-related GI risk awareness", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("ADR monitoring of NSAIDs – GI, renal, and cardiovascular adverse effects", "ADR/PV", "Prospective Observational", "Easy – OPD/ward patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of DMARDs (methotrexate, sulfasalazine, hydroxychloroquine)", "ADR/PV", "Prospective Observational", "Easy – rheumatology OPD", "No", "Simple", "Medium", "Low", 3),
    ("Drug-induced GI complications in patients on long-term NSAIDs – assessment and PPI use", "Drug Safety", "Retrospective/Prospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of anticoagulant use in deep vein thrombosis (DVT) prophylaxis post-orthopedic surgery", "Drug Utilization", "Retrospective", "Easy – OT/ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug-drug interactions in polypharmacy rheumatology patients", "DRP", "Retrospective/Prospective", "Easy – OPD prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Identification of DRPs in orthopedic inpatients using PCNE classification", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Assessment of inappropriate NSAID use in elderly orthopedic patients (Beers/STOPP)", "DRP", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("KAP of rheumatoid arthritis patients on methotrexate – side effects and monitoring", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Assessment of patient knowledge on bisphosphonate correct administration technique", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("KAP of patients on self-medication with NSAIDs for musculoskeletal pain", "KAP", "Cross-sectional Survey", "Easy – OPD/community patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in rheumatoid arthritis patients using HAQ-DI / SF-36", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in osteoarthritis patients before and after pharmacological intervention", "QoL", "Prospective", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Cost-of-illness study of rheumatoid arthritis in a tertiary care hospital", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic analysis of biologic vs. conventional DMARDs in RA", "Pharmaco-economics", "Retrospective Comparative", "Moderate – limited biologic patients", "No", "Moderate", "Medium", "Low", 2),
    ("Evaluation of uric acid-lowering therapy in gout – allopurinol/febuxostat use", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug use in ankylosing spondylitis – NSAIDs, DMARDs, biologic patterns", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of pain management protocols in total knee/hip replacement patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Medication reconciliation at discharge in orthopedic inpatients", "Medication Safety", "Prospective Observational", "Easy – ward records", "No", "Moderate", "Medium", "Low", 3),
    ("Assessment of steroid use in orthopedic conditions – patterns and complications", "Drug Utilization", "Retrospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Role of pharmacist in fall prevention in elderly orthopedic patients (FRIDs)", "Clinical Pharmacist", "Prospective Observational", "Easy – ward patients", "No", "Moderate", "Medium", "Low", 3),
    ("Drug utilization of muscle relaxants in musculoskeletal disorders", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of corticosteroid injection practices in orthopedic OPD", "Drug Utilization", "Retrospective/Audit", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of physiotherapy vs. pharmacotherapy in chronic low back pain patients", "Clinical Outcomes", "Retrospective Comparative", "Easy – OPD records", "No", "Simple", "Medium", "Low", 3),
    ("KAP of orthopedic patients on antibiotic prophylaxis before dental/surgical procedures", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Assessment of topical vs. systemic NSAID prescribing in musculoskeletal pain", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Dermatology"] = [
    ("Drug utilization study of topical corticosteroids in dermatology outpatients", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of topical corticosteroid misuse/overuse in skin conditions", "Medication Safety", "Cross-sectional/Retrospective", "Easy – OPD patients/records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of antifungals in superficial fungal infections", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization review of systemic retinoids (isotretinoin) in acne management", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("ADR monitoring of isotretinoin therapy – teratogenicity risk, mood changes, lipid effects", "ADR/PV", "Prospective Observational", "Easy – dermatology OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug-induced skin reactions (DISR) – incidence, pattern, and causality assessment", "ADR/PV", "Prospective Observational", "Easy – ward/OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Stevens-Johnson Syndrome (SJS/TEN) – drug causality analysis and pharmacist role", "ADR/PV", "Retrospective", "Easy – dermatology ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of antibiotic prescribing in skin and soft tissue infections (SSTIs)", "AMS", "Retrospective/Audit", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization study of biologics (dupilumab, secukinumab) in psoriasis/atopic dermatitis", "Drug Utilization", "Retrospective", "Moderate – limited patient numbers", "No", "Simple", "Medium", "Low", 2),
    ("Prescribing pattern of antileprosy drugs and adherence in leprosy patients", "Drug Utilization", "Retrospective", "Easy – leprosy clinic records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of medication adherence in psoriasis patients on systemic therapy", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Adherence to topical therapy in eczema/atopic dermatitis patients", "Adherence", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on proper use of topical medications", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Assessment of drug interactions in dermatology polypharmacy patients", "DRP", "Retrospective/Prospective", "Easy – OPD prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Identification of DRPs in dermatology inpatients using PCNE classification", "DRP", "Prospective Observational", "Easy – ward patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("KAP of dermatology patients on topical steroid use and side effects", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Patient awareness of photoprotection and sunscreen pharmacotherapy", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Assessment of OTC drug use and self-medication in skin conditions", "Community Pharmacy", "Cross-sectional Survey", "Easy – OPD/community patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in psoriasis patients using DLQI (Dermatology Life Quality Index)", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in acne patients using DLQI and impact of pharmacotherapy", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of psoriasis in a tertiary care hospital", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic comparison of topical vs. systemic acne therapies", "Pharmaco-economics", "Retrospective Comparative", "Easy – pharmacy + billing records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of antihistamines in allergic skin conditions", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of methotrexate use and toxicity monitoring in psoriasis/pemphigus", "Drug Safety", "Prospective Observational", "Easy – OPD patients + LFT/CBC", "No", "Simple", "Medium", "Low", 3),
    ("Evaluation of antivirals (acyclovir/valacyclovir) prescribing in herpes infections", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing patterns in urticaria management – antihistamines and steroids", "Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of scabies and pediculosis treatment practices and outcomes", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of cyclosporine use in dermatological conditions – safety monitoring", "Drug Safety", "Prospective Observational", "Easy – OPD patients + lab records", "No", "Moderate", "Medium", "Low", 2),
    ("Drug utilization of dapsone in dermatological conditions – safety monitoring", "Drug Safety/Drug Utilization", "Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of phototherapy drug prescribing (PUVA/NB-UVB) in psoriasis", "Drug Utilization", "Retrospective/Audit", "Easy – phototherapy unit records", "No", "Simple", "Short", "Low", 3),
    ("KAP of pharmacists on dermatology OTC products and counseling", "KAP", "Cross-sectional Survey", "Easy – pharmacists as subjects", "No", "Simple", "Short", "Low", 3),
    ("Drug-induced alopecia – identification, causality, and pharmacist reporting", "ADR/PV", "Prospective Observational", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of wound care and antimicrobial dressing use in dermatology ward", "Drug Utilization", "Retrospective/Audit", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of sunscreen prescribing and patient compliance in photodermatoses", "Drug Utilization/Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Medication reconciliation in dermatology inpatients at admission and discharge", "Medication Safety", "Prospective Observational", "Easy – ward records", "No", "Moderate", "Medium", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["ICU"] = [
    ("Drug utilization study of antibiotics in ICU patients (WHO DDD methodology)", "Drug Utilization/AMS", "Retrospective", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of carbapenem use in ICU – appropriateness and antibiotic stewardship", "AMS", "Retrospective/Audit", "Easy – ICU + micro records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization review of sedatives and analgesics (ABCDE bundle adherence)", "Drug Utilization", "Retrospective", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of vasopressors and inotropes in septic shock patients", "Drug Utilization", "Retrospective", "Easy – ICU case records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of anticoagulant use (DVT prophylaxis) in ICU patients", "Drug Utilization", "Retrospective", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Drug dose adjustment in acute kidney injury (AKI) ICU patients", "Drug Safety", "Retrospective", "Easy – ICU + lab records", "No", "Simple", "Short", "Low", 3),
    ("ADR monitoring in ICU patients – incidence, type, and clinical impact", "ADR/PV", "Prospective Observational", "Easy – ICU ward patients", "No", "Simple", "Medium", "Low", 3),
    ("Drug-induced QT prolongation in ICU patients – monitoring and assessment", "ADR/PV", "Prospective Observational", "Easy – ICU + ECG records", "No", "Moderate", "Medium", "Low", 3),
    ("Medication errors in ICU – incidence, type, severity, and contributing factors", "Medication Safety", "Prospective Observational", "Moderate – staff cooperation needed", "No", "Moderate", "Medium", "Low", 2),
    ("Assessment of high-alert medication (HAM) safety practices in ICU", "Medication Safety", "Cross-sectional/Audit", "Easy – ICU pharmacy/ward", "No", "Simple", "Short", "Low", 3),
    ("Drug-drug interactions in polypharmacy ICU patients – prevalence and clinical significance", "DRP", "Retrospective/Prospective", "Easy – ICU prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Identification of DRPs in ICU patients using PCNE classification", "DRP", "Prospective Observational", "Easy – ICU patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Assessment of stress ulcer prophylaxis (PPI/H2RA) appropriateness in ICU", "Drug Utilization", "Retrospective/Audit", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of blood glucose management and insulin protocol adherence in ICU", "Drug Safety/Utilization", "Retrospective/Prospective", "Easy – ICU + lab records", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of nutrition (TPN/enteral) drug interactions in ICU patients", "Drug Safety", "Prospective Observational", "Easy – ICU records", "No", "Simple", "Medium", "Low", 3),
    ("Role of clinical pharmacist in ICU ward rounds – types and outcomes of interventions", "Clinical Pharmacist", "Prospective Observational", "Moderate – physician cooperation", "No", "Moderate", "Medium", "Low", 2),
    ("Impact of pharmacist-led medication review on ICU drug-related problems", "Clinical Pharmacist", "Prospective Interventional", "Easy – ICU patients", "No", "Moderate", "Medium", "Low", 3),
    ("Pharmacist participation in antimicrobial stewardship in ICU – outcomes", "Clinical Pharmacist/AMS", "Prospective Observational", "Easy – ICU/AMS team", "No", "Moderate", "Medium", "Low", 3),
    ("Assessment of neuromuscular blocking agent (NMBA) use in mechanically ventilated patients", "Drug Utilization", "Retrospective", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of proton pump inhibitors and H2 blockers in ICU – overuse analysis", "Drug Utilization", "Retrospective/Audit", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Evaluation of opioid use and sedation scoring (RASS) adherence in ventilated ICU patients", "Drug Utilization", "Retrospective", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of antimicrobial de-escalation practices in ICU", "AMS", "Retrospective", "Easy – ICU + micro records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of thromboprophylaxis in post-surgical ICU patients", "Drug Utilization", "Retrospective", "Easy – ICU ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of vancomycin TDM practices in ICU patients", "Drug Safety", "Retrospective/Prospective", "Easy – ICU + TDM lab records", "No", "Simple", "Medium", "Low", 3),
    ("Evaluation of nephrotoxic drug combinations in ICU patients", "Drug Safety", "Retrospective", "Easy – ICU + lab records", "No", "Simple", "Short", "Low", 3),
    ("KAP of ICU nurses and physicians on medication error reporting", "KAP", "Cross-sectional Survey", "Easy – ICU staff as subjects", "No", "Simple", "Short", "Low", 3),
    ("Pharmacoeconomic analysis of generic vs. branded ICU drugs", "Pharmaco-economics", "Retrospective Comparative", "Easy – ICU pharmacy records", "No", "Simple", "Short", "Low", 3),
    ("Cost of antibiotic resistance in ICU patients – economic burden study", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + micro records", "No", "Moderate", "Medium", "Low", 2),
    ("Assessment of propofol infusion syndrome (PRIS) risk monitoring in ICU", "Drug Safety", "Prospective Observational", "Easy – ICU patients on propofol", "No", "Simple", "Medium", "Low", 3),
    ("Evaluation of glycopeptide (vancomycin/teicoplanin) use in ICU – dose adequacy", "Drug Utilization/AMS", "Retrospective", "Easy – ICU + lab records", "No", "Simple", "Short", "Low", 3),
    ("Drug-induced electrolyte disturbances in ICU patients – monitoring assessment", "Drug Safety", "Prospective Observational", "Easy – ICU + lab records", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of medication reconciliation in ICU patients at admission/discharge", "Medication Safety", "Prospective Observational", "Easy – ICU records", "No", "Moderate", "Medium", "Low", 3),
    ("Evaluation of delirium management pharmacotherapy in ICU (PADIS guidelines)", "Drug Utilization", "Retrospective/Audit", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization of antifungals in ICU patients – prophylaxis vs. treatment patterns", "Drug Utilization/AMS", "Retrospective", "Easy – ICU records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of pharmacist-led medication error prevention strategies in ICU", "Clinical Pharmacist/Medication Safety", "Prospective Interventional", "Moderate – multidisciplinary cooperation", "No", "Moderate", "Long", "Low", 2),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Gynecology"] = [
    ("Drug utilization study in antenatal care (ANC) – iron, folic acid, calcium prescribing", "Drug Utilization", "Retrospective", "Easy – ANC OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of oxytocics and uterotonics in labour and delivery ward", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization review in postpartum hemorrhage (PPH) management", "Drug Utilization", "Retrospective", "Easy – case sheets", "No", "Simple", "Short", "Low", 3),
    ("Assessment of antibiotic prescribing in caesarean section – appropriateness", "AMS", "Retrospective/Audit", "Easy – OT + ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization study in gestational diabetes mellitus (GDM)", "Drug Utilization", "Retrospective/Prospective", "Easy – OPD/ward records", "No", "Simple", "Medium", "Low", 3),
    ("Adherence to iron and folic acid supplementation in pregnant women", "Adherence", "Cross-sectional", "Easy – ANC clinic patients", "No", "Simple", "Short", "Low", 3),
    ("Compliance with antihypertensives in pregnancy-induced hypertension (PIH)/preeclampsia", "Adherence", "Prospective Observational", "Easy – ward + OPD", "No", "Simple", "Medium", "Low", 3),
    ("Adherence in PCOS patients on metformin/OCP and associated factors", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist counseling on adherence to antenatal supplements", "Clinical Pharmacist", "Prospective Interventional", "Easy – ANC clinic", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("ADR monitoring of obstetric drugs – oxytocin, magnesium sulfate, misoprostol", "ADR/PV", "Prospective Observational", "Easy – ward patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR surveillance of hormonal contraceptives in family planning clinic", "ADR/PV", "Cross-sectional/Prospective", "Easy – family planning OPD", "No", "Simple", "Medium", "Low", 3),
    ("Teratogenicity risk assessment – category C/D/X drug exposure in first trimester", "Drug Safety", "Retrospective", "Moderate – detailed records needed", "No", "Moderate", "Medium", "Low", 2),
    ("ADR profiling in preeclampsia – labetalol, nifedipine, magnesium sulfate", "ADR/PV", "Prospective Observational", "Easy – ward patients", "No", "Simple", "Medium", "Low", 3),
    ("Identification of DRPs in high-risk pregnancy patients (PCNE classification)", "DRP", "Prospective Observational", "Easy – high-risk OPD/ward", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug-drug interactions in polypharmacy obstetric patients", "DRP", "Retrospective/Prospective", "Easy – prescriptions/case sheets", "No", "Simple", "Short", "Low", 3),
    ("Inappropriate medication use in pregnancy (FDA/Hale lactation risk analysis)", "Drug Safety", "Retrospective", "Easy – case records", "No", "Simple", "Short", "Low", 3),
    ("Medication errors in obstetric wards – types, factors, and pharmacist interventions", "Medication Safety", "Prospective Observational", "Moderate – staff cooperation needed", "No", "Moderate", "Medium", "Low", 2),
    ("Impact of pharmacist counseling on nausea and vomiting of pregnancy (NVP)", "Clinical Pharmacist", "Prospective Interventional", "Easy – ANC OPD", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Pharmacist role in preeclampsia drug therapy optimization", "Clinical Pharmacist", "Prospective Interventional", "Easy – ward patients", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacist interventions reducing medication errors in L&D unit", "Medication Safety", "Prospective Interventional", "Moderate – ward access needed", "No", "Moderate", "Long", "Medium", 2),
    ("Pharmacist recommendations in gynecology ward rounds – type and acceptance", "Clinical Pharmacist", "Prospective Observational", "Moderate – physician cooperation", "No", "Moderate", "Medium", "Low", 2),
    ("KAP on oral contraceptive pill (OCP) use among reproductive-age women", "KAP", "Cross-sectional Survey", "Easy – OPD/community women", "No", "Simple", "Short", "Low", 3),
    ("Patient knowledge on drugs in pregnancy and lactation", "KAP", "Cross-sectional Survey", "Easy – ANC/postnatal patients", "No", "Simple", "Short", "Low", 3),
    ("Patient awareness of emergency contraception", "KAP", "Cross-sectional Survey", "Easy – OPD/community", "No", "Simple", "Short", "Low", 3),
    ("KAP of self-medication in pregnant women – risks and prevalence", "KAP", "Cross-sectional Survey", "Easy – ANC OPD", "No", "Simple", "Short", "Low", 3),
    ("Cost-of-illness study of preeclampsia in a tertiary care setting", "Pharmaco-economics", "Retrospective/Prospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic comparison of misoprostol vs. oxytocin in PPH prevention", "Pharmaco-economics", "Retrospective Comparative", "Easy – ward records + billing", "No", "Simple", "Medium", "Low", 3),
    ("Direct medical costs associated with gestational diabetes management", "Pharmaco-economics", "Retrospective", "Easy – hospital billing", "No", "Simple", "Short", "Low", 3),
    ("HRQoL in PCOS women using SF-36 questionnaire", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Pharmacotherapy assessment in PCOS – ovulation induction, metformin, OCP", "Drug Utilization", "Cross-sectional/Retrospective", "Easy – OPD records", "No", "Simple", "Short", "Low", 3),
    ("Drug therapy evaluation in endometriosis – hormonal and analgesic patterns", "Drug Utilization", "Retrospective", "Moderate – diagnosis confirmation", "No", "Simple", "Medium", "Low", 2),
    ("Management of preterm labor – tocolytic drug use assessment and outcomes", "Drug Utilization", "Retrospective/Prospective", "Easy – ward records", "No", "Simple", "Medium", "Low", 3),
    ("Chemotherapy regimen safety monitoring in gynecological cancers", "Drug Safety", "Prospective Observational", "Moderate – oncology unit access", "No", "Moderate", "Long", "Medium", 2),
    ("Antifungal use in vulvovaginal candidiasis – OTC vs. prescription analysis", "Drug Utilization", "Cross-sectional/Retrospective", "Easy – OPD records/pharmacy", "No", "Simple", "Short", "Low", 3),
    ("Pharmacist role in reproductive health counseling – contraception and preconception", "Clinical Pharmacist", "Cross-sectional/Interventional", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Assessment of pharmacist knowledge on drugs in breastfeeding", "KAP", "Cross-sectional Survey", "Easy – pharmacists as subjects", "No", "Simple", "Short", "Low", 3),
    ("Progesterone supplementation in threatened abortion – prescribing and outcomes", "Drug Utilization", "Retrospective Observational", "Easy – case records", "No", "Simple", "Short", "Low", 3),
    ("Digital health interventions for antenatal medication adherence", "Emerging Topics", "Prospective Interventional", "Moderate – smartphone access needed", "No", "Moderate", "Long", "Medium", 2),
    ("Evaluation of IV vs. oral iron therapy in pregnancy-related anemia", "Clinical Outcomes", "Prospective Comparative", "Easy – ANC ward/OPD", "No", "Moderate (IV access)", "Medium", "Medium", 3),
]

# ══════════════════════════════════════════════════════════════════════════════
SPECIALTIES["Cardiology"] = [
    ("Drug utilization study of antihypertensives in hypertensive inpatients/outpatients (WHO DDD)", "Drug Utilization", "Retrospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern of antiplatelet agents in ACS patients", "Drug Utilization", "Retrospective", "Easy – ward records", "No", "Simple", "Short", "Low", 3),
    ("Assessment of statin prescribing and LDL goal attainment in CAD patients", "Drug Utilization", "Retrospective/Prospective", "Easy – OPD/ward records", "No", "Simple", "Short", "Low", 3),
    ("Drug utilization review of anticoagulants in atrial fibrillation patients", "Drug Utilization", "Retrospective", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Prescribing pattern in heart failure – adherence to GDMT guidelines", "Drug Utilization", "Retrospective/Audit", "Easy – ward/OPD records", "No", "Simple", "Short", "Low", 3),
    ("Medication adherence in hypertensive patients (MMAS-8) and associated factors", "Adherence", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Adherence to DAPT post-PCI/stent and clinical outcomes", "Adherence", "Prospective Observational", "Easy – cardiology OPD", "No", "Simple", "Medium", "Low", 3),
    ("Impact of pharmacist counseling on medication adherence and BP control", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Factors influencing non-adherence to statin therapy in dyslipidemia patients", "Adherence", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("DRPs in cardiac ICU patients using PCNE classification", "DRP", "Prospective Observational", "Easy – CICU patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Drug-drug interactions in polypharmacy cardiac patients – prevalence/significance", "DRP", "Cross-sectional/Retrospective", "Easy – OPD/ward prescriptions", "No", "Simple", "Short", "Low", 3),
    ("Clinical significance of DDIs in patients on warfarin – pharmacist impact", "DRP", "Prospective Observational", "Easy – anticoagulation clinic", "No", "Simple", "Medium", "Low", 3),
    ("Inappropriate prescribing in elderly cardiac patients (Beers/STOPP-START)", "DRP", "Retrospective", "Easy – case records", "No", "Simple", "Short", "Low", 3),
    ("ADR monitoring of cardiovascular drugs – ACE inhibitors, statins, amiodarone, digoxin", "ADR/PV", "Prospective Observational", "Easy – cardiology ward", "No", "Simple", "Medium", "Low", 3),
    ("Statin-induced myopathy surveillance – incidence, risk factors, pharmacist reporting", "ADR/PV", "Prospective Observational", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("ADR profiling of antiarrhythmic drugs – prospective observational study", "ADR/PV", "Prospective Observational", "Easy – ward/OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Causality and severity assessment of ADRs in cardiac patients (Naranjo + WHO-UMC)", "ADR/PV", "Prospective Observational", "Easy – ward patients", "No", "Simple", "Medium", "Low", 3),
    ("Impact of pharmacist-led medication review on DRPs in heart failure patients", "Clinical Pharmacist", "Prospective Interventional", "Easy – HF clinic patients", "No", "Moderate", "Medium", "Low", 3),
    ("Pharmacist interventions in improving INR control in warfarin patients", "Clinical Pharmacist", "Prospective Observational", "Easy – anticoagulation clinic", "No", "Simple", "Medium", "Low", 3),
    ("Role of clinical pharmacist in anticoagulation management clinic", "Clinical Pharmacist", "Prospective Observational", "Easy – anticoagulation clinic", "No", "Simple", "Medium", "Low", 3),
    ("Pharmacist-driven hypertension management program – BP control and QoL", "Clinical Pharmacist", "Prospective Interventional", "Easy – OPD patients", "No", "Moderate (consent)", "Medium", "Low", 3),
    ("Assessment of pharmacist recommendations in cardiology ward rounds", "Clinical Pharmacist", "Prospective Observational", "Moderate – physician cooperation", "No", "Moderate", "Medium", "Low", 2),
    ("Cost-of-illness study of heart failure in a tertiary care cardiology unit", "Pharmaco-economics", "Retrospective", "Easy – hospital billing + records", "No", "Moderate", "Medium", "Low", 2),
    ("Pharmacoeconomic analysis of thrombolytic therapy vs. primary PCI in STEMI", "Pharmaco-economics", "Retrospective Comparative", "Easy – ward + billing records", "No", "Moderate", "Medium", "Low", 2),
    ("Cost-effectiveness of generic vs. branded antihypertensives", "Pharmaco-economics", "Retrospective Comparative", "Easy – pharmacy records", "No", "Simple", "Short", "Low", 3),
    ("KAP of hypertensive patients on their disease and medication", "KAP", "Cross-sectional Survey", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Impact of pharmacist-led cardiac rehab counseling on lifestyle modification", "Clinical Pharmacist", "Prospective Interventional", "Easy – cardiac rehab patients", "No", "Moderate", "Medium", "Low", 3),
    ("HRQoL in heart failure patients using MLHFQ (Minnesota Living with HF)", "QoL", "Cross-sectional", "Easy – OPD patients", "No", "Simple", "Short", "Low", 3),
    ("Patient knowledge on anticoagulation therapy and pharmacist education impact", "KAP/Clinical Pharmacist", "Cross-sectional + Interventional", "Easy – OPD patients", "No", "Simple", "Medium", "Low", 3),
    ("Medication errors in cardiology ICU – incidence, type, contributing factors", "Medication Safety", "Prospective Observational", "Moderate – staff cooperation", "No", "Moderate", "Medium", "Low", 2),
    ("High-alert medication safety assessment in cardiac care unit", "Medication Safety", "Cross-sectional/Audit", "Easy – ward/pharmacy records", "No", "Simple", "Short", "Low", 3),
    ("Medication reconciliation in cardiac inpatients at admission and discharge", "Medication Safety", "Prospective Observational", "Easy – ward records", "No", "Moderate", "Medium", "Low", 3),
    ("Assessment of SGLT2 inhibitor prescribing for cardiovascular risk reduction in T2DM", "Drug Utilization", "Retrospective/Cross-sectional", "Easy – cardiology/endo OPD records", "No", "Simple", "Short", "Low", 3),
    ("Pharmacist role in managing polypharmacy in chronic heart failure – deprescribing", "Clinical Pharmacist", "Prospective Interventional", "Easy – HF clinic patients", "No", "Moderate", "Medium", "Low", 3),
    ("Evaluation of antibiotic prophylaxis practices in cardiac surgery", "AMS", "Retrospective/Audit", "Easy – OT + ward records", "No", "Simple", "Short", "Low", 3),
]

# ══════════════════════════════════════════════════════════════════════════════

def write_specialty_sheet(wb, name, rows):
    ws = wb.create_sheet(title=name[:31])  # Excel max 31 chars

    # Title row
    ws.merge_cells("A1:J1")
    title_cell = ws["A1"]
    title_cell.value = f"M. Pharm (Pharmacy Practice) – {name} Project Topics"
    title_cell.font = TITLE_FONT
    title_cell.alignment = Alignment(horizontal="center", vertical="center")
    title_cell.fill = WHITE_FILL
    ws.row_dimensions[1].height = 22

    # Header row
    for col_idx, col_name in enumerate(COLUMNS, start=1):
        cell = ws.cell(row=2, column=col_idx, value=col_name)
        cell.font = HEADER_FONT
        cell.fill = HEADER_FILL
        cell.alignment = Alignment(horizontal="center", vertical="center", wrap_text=True)
        cell.border = BORDER
    ws.row_dimensions[2].height = 30

    # Data rows
    current_cat = None
    row_num = 3
    for idx, (topic, cat, study_type, data_access, lab, ethics, time_req, cost, feasibility) in enumerate(rows, start=1):
        # Category sub-header
        if cat != current_cat:
            current_cat = cat
            ws.merge_cells(f"A{row_num}:J{row_num}")
            cat_cell = ws.cell(row=row_num, column=1, value=f"  {cat}")
            cat_cell.font = SUBHDR_FONT
            cat_cell.fill = SUBHDR_FILL
            cat_cell.alignment = Alignment(horizontal="left", vertical="center")
            cat_cell.border = BORDER
            ws.row_dimensions[row_num].height = 18
            row_num += 1

        fill = ALT_FILL if idx % 2 == 0 else WHITE_FILL
        star_text = stars(feasibility)
        fstar_fill = feas_fill(feasibility)

        values = [idx, topic, cat, study_type, data_access, lab, ethics, time_req, cost, star_text]
        for col_idx, val in enumerate(values, start=1):
            cell = ws.cell(row=row_num, column=col_idx, value=val)
            cell.font = BODY_FONT
            cell.alignment = Alignment(vertical="center", wrap_text=True,
                                       horizontal="center" if col_idx != 2 else "left")
            cell.border = BORDER
            if col_idx == 10:
                cell.fill = fstar_fill
                cell.font = Font(name="Arial", bold=True, size=10)
            else:
                cell.fill = fill
        ws.row_dimensions[row_num].height = 36
        row_num += 1

    # Column widths
    for col_idx, width in enumerate(COL_WIDTHS, start=1):
        ws.column_dimensions[get_column_letter(col_idx)].width = width

    # Freeze panes
    ws.freeze_panes = "A3"

    # Summary block
    row_num += 1
    ws.merge_cells(f"A{row_num}:J{row_num}")
    sum_title = ws.cell(row=row_num, column=1, value="FEASIBILITY SUMMARY")
    sum_title.font = Font(name="Arial", bold=True, size=11, color="1F4E79")
    sum_title.alignment = Alignment(horizontal="center")
    row_num += 1

    high = sum(1 for r in rows if r[-1] == 3)
    mod  = sum(1 for r in rows if r[-1] == 2)
    low  = sum(1 for r in rows if r[-1] == 1)

    for label, count, fill_c in [
        ("★★★ High Feasibility", high, HIGH_FILL),
        ("★★ Moderate Feasibility", mod, MOD_FILL),
        ("★ Difficult", low, LOW_FILL),
    ]:
        ws.merge_cells(f"A{row_num}:I{row_num}")
        lc = ws.cell(row=row_num, column=1, value=label)
        lc.font = BOLD_FONT
        lc.fill = fill_c
        lc.alignment = Alignment(horizontal="left", vertical="center")
        cc = ws.cell(row=row_num, column=10, value=count)
        cc.font = BOLD_FONT
        cc.fill = fill_c
        cc.alignment = Alignment(horizontal="center")
        ws.row_dimensions[row_num].height = 18
        row_num += 1


def main():
    wb = openpyxl.Workbook()
    # Remove default sheet
    wb.remove(wb.active)

    # ── INDEX sheet ──────────────────────────────────────────────────────────
    idx_ws = wb.create_sheet(title="INDEX", index=0)
    idx_ws.merge_cells("A1:D1")
    t = idx_ws["A1"]
    t.value = "M. Pharm (Pharmacy Practice) – Master Topic List"
    t.font = Font(name="Arial", bold=True, size=14, color="1F4E79")
    t.alignment = Alignment(horizontal="center", vertical="center")
    idx_ws.row_dimensions[1].height = 28

    headers = ["#", "Specialty", "Total Topics", "High Feasibility (★★★)"]
    for ci, h in enumerate(headers, 1):
        c = idx_ws.cell(row=2, column=ci, value=h)
        c.font = HEADER_FONT
        c.fill = HEADER_FILL
        c.alignment = Alignment(horizontal="center", vertical="center")
        c.border = BORDER
    idx_ws.row_dimensions[2].height = 22

    for si, (spec, rows) in enumerate(SPECIALTIES.items(), start=1):
        high = sum(1 for r in rows if r[-1] == 3)
        row_data = [si, spec, len(rows), high]
        for ci, val in enumerate(row_data, 1):
            c = idx_ws.cell(row=si + 2, column=ci, value=val)
            c.font = BODY_FONT
            c.fill = ALT_FILL if si % 2 == 0 else WHITE_FILL
            c.alignment = Alignment(horizontal="center", vertical="center")
            c.border = BORDER
        idx_ws.row_dimensions[si + 2].height = 18

    for ci, w in enumerate([5, 30, 16, 26], 1):
        idx_ws.column_dimensions[get_column_letter(ci)].width = w

    # ── speciality sheets ────────────────────────────────────────────────────
    for spec, rows in SPECIALTIES.items():
        write_specialty_sheet(wb, spec, rows)

    out_path = "/home/daytona/workspace/mpharm-topics/MPharm_Pharmacy_Practice_Topics.xlsx"
    wb.save(out_path)
    print(f"Saved: {out_path}")

main()

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/mpharm-topics/generate_topics.py'

import openpyxl, io
from openpyxl.styles import PatternFill, Font, Alignment, Border, Side
from openpyxl.utils import get_column_letter

# ── styles ───────────────────────────────────────────────────────────────────
HEADER_FILL  = PatternFill("solid", fgColor="1F4E79")
TITLE_FILL   = PatternFill("solid", fgColor="E2EFDA")   # soft green for ★★★ theme
HIGH_FILL    = PatternFill("solid", fgColor="C6EFCE")
ALT_FILL     = PatternFill("solid", fgColor="F0FFF0")   # very light green alt row
WHITE_FILL   = PatternFill("solid", fgColor="FFFFFF")
SPEC_FILL    = PatternFill("solid", fgColor="375623")   # dark green for specialty header
SUBHDR_FILL  = PatternFill("solid", fgColor="548235")   # medium green sub-header

HEADER_FONT  = Font(name="Arial", bold=True, color="FFFFFF", size=11)
TITLE_FONT   = Font(name="Arial", bold=True, color="375623", size=13)
BODY_FONT    = Font(name="Arial", size=10)
BOLD_FONT    = Font(name="Arial", bold=True, size=10)
SPEC_FONT    = Font(name="Arial", bold=True, color="FFFFFF", size=11)

thin = Side(style="thin", color="A9D18E")
BORDER = Border(left=thin, right=thin, top=thin, bottom=thin)

SPECIALTY_SHEETS = ['Nephrology','Respiratory','Endocrinology','Infectious Diseases',
                    'Pediatrics','Orthopedics','Dermatology','ICU','Gynecology','Cardiology']

COLUMNS = ["#", "Topic", "Category", "Study Type",
           "Data Access", "Lab Required",
           "Ethics", "Time", "Cost", "Feasibility"]

COL_WIDTHS = [4, 64, 22, 28, 26, 14, 18, 12, 8, 14]

def apply_header(ws, row, values, fill, font):
    for ci, val in enumerate(values, 1):
        c = ws.cell(row=row, column=ci, value=val)
        c.font = font
        c.fill = fill
        c.alignment = Alignment(horizontal="center", vertical="center", wrap_text=True)
        c.border = BORDER
    ws.row_dimensions[row].height = 28

def write_data_row(ws, row_num, idx, data, alt):
    fill = ALT_FILL if alt else WHITE_FILL
    for ci, val in enumerate([idx] + list(data), 1):
        c = ws.cell(row=row_num, column=ci, value=val)
        c.font = BODY_FONT
        c.fill = fill
        c.alignment = Alignment(vertical="center", wrap_text=True,
                                horizontal="left" if ci == 2 else "center")
        c.border = BORDER
        if ci == 10:  # feasibility column
            c.fill = HIGH_FILL
            c.font = BOLD_FONT
    ws.row_dimensions[row_num].height = 38

def set_col_widths(ws):
    for ci, w in enumerate(COL_WIDTHS, 1):
        ws.column_dimensions[get_column_letter(ci)].width = w

# ── read source workbook ──────────────────────────────────────────────────────
src_wb = openpyxl.load_workbook('/home/daytona/workspace/mpharm-topics/MPharm_Pharmacy_Practice_Topics.xlsx')

# Extract ★★★ rows per specialty
specialty_data = {}   # {specialty: [(topic, cat, study_type, data_access, lab, ethics, time, cost, feas), ...]}

for spec in SPECIALTY_SHEETS:
    ws = src_wb[spec]
    rows = []
    for row in ws.iter_rows(min_row=3, values_only=True):
        # Skip merged category sub-headers (col B onward is None)
        if row[1] is None:
            continue
        # Only keep ★★★
        if row[9] == '★★★':
            # (topic, cat, study_type, data_access, lab, ethics, time, cost, feas)
            rows.append((row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9]))
    specialty_data[spec] = rows

# ── build new workbook ────────────────────────────────────────────────────────
wb = openpyxl.Workbook()
wb.remove(wb.active)

# ── MASTER COMBINED sheet ─────────────────────────────────────────────────────
master = wb.create_sheet(title="ALL ★★★ Topics", index=0)

# Title
master.merge_cells("A1:J1")
t = master["A1"]
t.value = "M. Pharm (Pharmacy Practice) – All ★★★ High Feasibility Topics (Filtered)"
t.font = TITLE_FONT
t.fill = TITLE_FILL
t.alignment = Alignment(horizontal="center", vertical="center")
master.row_dimensions[1].height = 24

apply_header(master, 2, COLUMNS, HEADER_FILL, HEADER_FONT)
master.freeze_panes = "A3"

master_row = 3
global_idx = 1

for spec in SPECIALTY_SHEETS:
    rows = specialty_data[spec]
    if not rows:
        continue
    # Specialty divider row
    master.merge_cells(f"A{master_row}:J{master_row}")
    sc = master.cell(row=master_row, column=1, value=f"  {spec.upper()}  ({len(rows)} topics)")
    sc.font = SPEC_FONT
    sc.fill = SPEC_FILL
    sc.alignment = Alignment(horizontal="left", vertical="center")
    sc.border = BORDER
    master.row_dimensions[master_row].height = 20
    master_row += 1

    for alt_idx, row_data in enumerate(rows):
        write_data_row(master, master_row, global_idx, row_data, alt_idx % 2 == 1)
        global_idx += 1
        master_row += 1

set_col_widths(master)

# Summary row
master_row += 1
master.merge_cells(f"A{master_row}:I{master_row}")
s = master.cell(row=master_row, column=1, value=f"TOTAL ★★★ Topics")
s.font = BOLD_FONT
s.fill = HIGH_FILL
s.alignment = Alignment(horizontal="left")
c = master.cell(row=master_row, column=10, value=global_idx - 1)
c.font = BOLD_FONT
c.fill = HIGH_FILL
c.alignment = Alignment(horizontal="center")
master.row_dimensions[master_row].height = 18

# ── per-specialty sheets ──────────────────────────────────────────────────────
for spec in SPECIALTY_SHEETS:
    rows = specialty_data[spec]
    ws = wb.create_sheet(title=spec[:31])

    # Title
    ws.merge_cells("A1:J1")
    t = ws["A1"]
    t.value = f"★★★ High Feasibility Topics – {spec}"
    t.font = TITLE_FONT
    t.fill = TITLE_FILL
    t.alignment = Alignment(horizontal="center", vertical="center")
    ws.row_dimensions[1].height = 24

    apply_header(ws, 2, COLUMNS, HEADER_FILL, HEADER_FONT)
    ws.freeze_panes = "A3"

    current_cat = None
    row_num = 3
    alt_toggle = 0

    for idx, row_data in enumerate(rows, 1):
        cat = row_data[1]
        if cat != current_cat:
            current_cat = cat
            ws.merge_cells(f"A{row_num}:J{row_num}")
            cc = ws.cell(row=row_num, column=1, value=f"  {cat}")
            cc.font = Font(name="Arial", bold=True, color="FFFFFF", size=10)
            cc.fill = SUBHDR_FILL
            cc.alignment = Alignment(horizontal="left", vertical="center")
            cc.border = BORDER
            ws.row_dimensions[row_num].height = 18
            row_num += 1
            alt_toggle = 0

        write_data_row(ws, row_num, idx, row_data, alt_toggle % 2 == 1)
        alt_toggle += 1
        row_num += 1

    set_col_widths(ws)

    # Count summary at bottom
    row_num += 1
    ws.merge_cells(f"A{row_num}:I{row_num}")
    s = ws.cell(row=row_num, column=1,
                value=f"Total ★★★ topics in {spec}: {len(rows)}  (all suitable for 2-year M. Pharm)")
    s.font = BOLD_FONT
    s.fill = HIGH_FILL
    s.alignment = Alignment(horizontal="left")
    ws.row_dimensions[row_num].height = 18

# ── INDEX sheet ───────────────────────────────────────────────────────────────
idx_ws = wb.create_sheet(title="INDEX", index=1)
idx_ws.merge_cells("A1:D1")
t = idx_ws["A1"]
t.value = "M. Pharm (Pharmacy Practice) – ★★★ Filtered Master Index"
t.font = TITLE_FONT
t.fill = TITLE_FILL
t.alignment = Alignment(horizontal="center", vertical="center")
idx_ws.row_dimensions[1].height = 24

for ci, h in enumerate(["#", "Specialty", "★★★ Topics", "% of Total"], 1):
    c = idx_ws.cell(row=2, column=ci, value=h)
    c.font = HEADER_FONT
    c.fill = HEADER_FILL
    c.alignment = Alignment(horizontal="center", vertical="center")
    c.border = BORDER
idx_ws.row_dimensions[2].height = 22

src_totals = {}
for spec in SPECIALTY_SHEETS:
    ws_src = src_wb[spec]
    total = sum(1 for r in ws_src.iter_rows(min_row=3, values_only=True) if r[1] is not None)
    src_totals[spec] = total

for si, spec in enumerate(SPECIALTY_SHEETS, 1):
    high = len(specialty_data[spec])
    total = src_totals[spec]
    pct = f"{round(high/total*100)}%" if total else "-"
    for ci, val in enumerate([si, spec, high, pct], 1):
        c = idx_ws.cell(row=si + 2, column=ci, value=val)
        c.font = BODY_FONT
        c.fill = ALT_FILL if si % 2 == 0 else WHITE_FILL
        c.alignment = Alignment(horizontal="center", vertical="center")
        c.border = BORDER
    idx_ws.row_dimensions[si + 2].height = 18

# Totals row
tr = len(SPECIALTY_SHEETS) + 3
for ci, val in enumerate(["", "TOTAL", sum(len(specialty_data[s]) for s in SPECIALTY_SHEETS), ""], 1):
    c = idx_ws.cell(row=tr, column=ci, value=val)
    c.font = BOLD_FONT
    c.fill = HIGH_FILL
    c.alignment = Alignment(horizontal="center")
    c.border = BORDER
idx_ws.row_dimensions[tr].height = 18

for ci, w in enumerate([5, 30, 16, 12], 1):
    idx_ws.column_dimensions[get_column_letter(ci)].width = w

# ── save ──────────────────────────────────────────────────────────────────────
out_path = "/home/daytona/workspace/mpharm-topics/MPharm_HighFeasibility_Topics_Filtered.xlsx"
buf = io.BytesIO()
wb.save(buf)
buf.seek(0)
with open(out_path, "wb") as f:
    f.write(buf.read())
print(f"Saved: {out_path}")
print(f"Total ★★★ topics: {global_idx - 1}")
for spec in SPECIALTY_SHEETS:
    print(f"  {spec}: {len(specialty_data[spec])}")