ls -la /home/daytona/workspace/ 2>/dev/null || mkdir -p /home/daytona/workspace/icu-drug-infusions

mkdir -p /home/daytona/workspace/icu-drug-infusions && cat > /home/daytona/workspace/icu-drug-infusions/build_infusions.py << 'PYEOF' import openpyxl from openpyxl.styles import ( Font, PatternFill, Alignment, Border, Side, GradientFill ) from openpyxl.utils import get_column_letter wb = openpyxl.Workbook() # ── DATA ──────────────────────────────────────────────────────────────────── drugs = [ # (No, Drug, Class, Std Concentration mg/mL, Typical Dilution in NS, # Usual Dose/Rate, Indications, ICU Role, Signs & Symptoms Treated) (1, "Norepinephrine", "Vasopressor / Alpha-1 >> Beta-1 agonist", "0.04–0.1 mg/mL (e.g. 4 mg in 100 mL NS)", "4–8 mg in 100–250 mL NS", "0.01–3 mcg/kg/min IV", "Septic shock, distributive shock, vasodilatory shock", "First-line vasopressor in septic shock; maintains MAP ≥ 65 mmHg; increases SVR", "Hypotension, warm flushed skin, wide pulse pressure, bounding pulse (distributive shock)"), (2, "Epinephrine (Adrenaline)", "Vasopressor / Inotrope (Alpha + Beta agonist)", "0.04–0.1 mg/mL (e.g. 4 mg in 100 mL NS)", "4 mg in 100 mL NS (0.04 mg/mL)", "0.01–1 mcg/kg/min IV", "Cardiac arrest (ACLS), anaphylaxis, refractory septic shock, severe bradycardia", "Second-line vasopressor; used in anaphylaxis and post-cardiac arrest; increases HR, BP, CO", "Cardiac arrest, anaphylaxis (urticaria, bronchospasm, hypotension), severe bradycardia"), (3, "Dopamine", "Vasopressor / Inotrope (dose-dependent agonist)", "1.6–3.2 mg/mL (e.g. 400 mg in 250 mL NS)", "200–400 mg in 250–500 mL NS", "2–20 mcg/kg/min IV", "Cardiogenic shock, bradycardia refractory to atropine, hypotension", "Low dose (2–5): renal/splanchnic; mid (5–10): inotrope; high (>10): vasopressor", "Cardiogenic shock: cool extremities, hypotension, oliguria, elevated PCWP"), (4, "Dobutamine", "Inotrope (Beta-1 agonist)", "0.5–1 mg/mL (e.g. 250 mg in 250 mL NS)", "250 mg in 250 mL NS (1 mg/mL)", "2–20 mcg/kg/min IV", "Cardiogenic shock, acute decompensated heart failure, low cardiac output states", "Increases contractility & CO; reduces afterload; used alongside vasopressors in CS", "Pulmonary edema, S3 gallop, elevated JVP, cool extremities, low CO"), (5, "Vasopressin (ADH)", "Vasopressor (V1 receptor agonist)", "0.4 units/mL (e.g. 20 units in 50 mL NS)", "20 units in 50 mL NS (0.4 units/mL)", "0.01–0.04 units/min (fixed) IV", "Septic shock (adjunct to norepinephrine), vasodilatory shock, DI (central)", "Second-line vasopressor; spares catecholamine doses; useful in catecholamine-resistant shock", "Refractory hypotension, high vasopressor requirements, vasodilatory shock"), (6, "Phenylephrine", "Vasopressor (pure Alpha-1 agonist)", "0.1–0.5 mg/mL (e.g. 100 mg in 250 mL NS)", "100 mg in 250 mL NS (0.4 mg/mL)", "0.5–6 mcg/kg/min IV", "Hypotension without tachycardia, LVOTO (HCM), spinal shock, SVT (vagal reflex)", "Raises SVR without increasing HR; used when tachycardia is harmful", "Hypotension, reflex bradycardia, vasoplegia; LVOTO: syncope, dyspnea on exertion"), (7, "Amiodarone", "Antiarrhythmic (Class III)", "1.5–6 mg/mL (e.g. 150 mg in 100 mL NS over 10 min; 1 mg/min in 500 mL NS)", "Loading: 150 mg in 100 mL NS; Maintenance: 360 mg in 250 mL NS", "150 mg IV bolus over 10 min, then 1 mg/min × 6 h, then 0.5 mg/min × 18 h", "VF, pulseless VT, hemodynamically stable VT, AF with RVR", "Broadest spectrum antiarrhythmic; first-line in refractory VF/VT in ACLS", "Palpitations, VT/VF, AF rapid ventricular response, wide-complex tachycardia"), (8, "Lidocaine", "Antiarrhythmic (Class Ib)", "8 mg/mL (e.g. 2 g in 250 mL NS)", "2 g in 250 mL NS (8 mg/mL)", "1–1.5 mg/kg IV bolus; maintenance 1–4 mg/min", "VT, VF (if amiodarone unavailable), ventricular ectopy", "Membrane stabilizer; suppresses ventricular arrhythmias; used in ACLS if amiodarone unavailable", "VT, VF, ventricular ectopy; toxicity: perioral numbness, seizures, bradycardia"), (9, "Labetalol", "Antihypertensive (Alpha + Beta blocker)", "1–2 mg/mL (e.g. 200 mg in 200 mL NS)", "200 mg in 200 mL NS (1 mg/mL)", "0.5–2 mg/min IV infusion; or 20 mg IV bolus q10 min", "Hypertensive emergency, aortic dissection, hypertensive encephalopathy, pre-eclampsia", "Controlled BP reduction; does not increase HR; preferred in aortic dissection", "Severe headache, blurred vision, altered consciousness, focal deficits (hypertensive crisis)"), (10, "Nicardipine", "Antihypertensive (CCB, Dihydropyridine)", "0.1 mg/mL (e.g. 25 mg in 250 mL NS)", "25 mg in 250 mL NS (0.1 mg/mL)", "5–15 mg/h IV infusion", "Hypertensive emergency, subarachnoid hemorrhage, perioperative hypertension", "Smooth, titratable BP control; preferred in neurological emergencies; cerebral vasodilation", "Hypertensive encephalopathy, intracranial hemorrhage, post-op hypertension"), (11, "Sodium Nitroprusside", "Vasodilator (Arteriolar + Venous)", "0.2–0.4 mg/mL (e.g. 50 mg in 250 mL NS)", "50 mg in 250 mL NS (0.2 mg/mL)", "0.3–10 mcg/kg/min IV", "Hypertensive crisis, acute aortic dissection, acute severe MR/AR, cardiogenic shock (afterload reduction)", "Potent balanced vasodilator; reduces preload and afterload; risk of cyanide toxicity", "Malignant hypertension, aortic dissection; toxicity: metabolic acidosis, cyanosis, altered mental status"), (12, "Nitroglycerin (GTN)", "Venodilator / Coronary vasodilator (Nitrate)", "0.1–0.4 mg/mL (e.g. 50 mg in 250 mL NS)", "50 mg in 250–500 mL NS (0.1–0.2 mg/mL); use glass bottle (adsorbs to PVC)", "5–200 mcg/min IV", "Acute coronary syndrome, acute pulmonary edema, hypertensive emergency with ACS, vasospastic angina", "Reduces preload; coronary vasodilation; reduces PCWP; relieves ischemia", "Chest pain, ST changes, pulmonary edema, elevated PCWP"), (13, "Heparin (Unfractionated)", "Anticoagulant (indirect thrombin inhibitor)", "50–100 units/mL (e.g. 25,000 units in 250 mL NS = 100 units/mL)", "25,000 units in 250 mL NS (100 units/mL)", "80 units/kg bolus, then 18 units/kg/h; titrate per aPTT protocol", "DVT/PE (treatment & prevention), ACS (NSTEMI, STEMI), AFib (anticoagulation), ECMO, CPB", "Prevents clot propagation; anticoagulation for mechanical valves, ACS, VTE; monitor aPTT 60–100 s", "DVT (unilateral limb swelling), PE (dyspnea, tachycardia, hypoxia), ACS (chest pain, ST changes)"), (14, "Insulin (Regular)", "Hormone / Antihyperglycemic", "1 unit/mL (e.g. 100 units in 100 mL NS)", "100 units in 100 mL NS (1 unit/mL)", "0.05–0.1 units/kg/h; DKA protocol; hyperkalemia: 10 units IV bolus", "DKA, HHS, hyperglycemia in ICU, hyperkalemia (acute management)", "Glucose control in ICU; anabolic; drives K+ intracellularly in hyperkalemia", "DKA: polyuria, polydipsia, vomiting, Kussmaul breathing, fruity breath, anion-gap acidosis"), (15, "Dextrose 50% (D50W) + Insulin", "Carbohydrate + Hormone (hyperkalemia Rx)", "N/A (D50W given as 50 mL push; insulin separate)", "50 mL D50W IV push + 10 units regular insulin IV bolus", "50 mL D50W over 5 min + 10 units regular insulin IV", "Hyperkalemia (acute management), hypoglycemia reversal", "Drives K+ into cells alongside insulin; not a definitive K+ removal strategy", "Hyperkalemia: peaked T-waves, wide QRS, sine wave pattern, bradycardia, cardiac arrest"), (16, "Morphine Sulfate", "Opioid Analgesic / Anxiolytic", "1 mg/mL (e.g. 50 mg in 50 mL NS)", "50 mg in 50 mL NS (1 mg/mL)", "1–5 mg IV bolus or 1–5 mg/h infusion; titrate to pain/comfort", "Moderate-to-severe pain, acute pulmonary edema (dyspnea relief), post-op analgesia, palliative care", "Analgesia, anxiolysis, preload reduction in APE; sedation adjunct in ICU", "Severe pain, dyspnea, tachycardia; APE: orthopnea, pink frothy sputum, respiratory distress"), (17, "Fentanyl", "Opioid Analgesic (short-acting)", "0.05 mg/mL = 50 mcg/mL (e.g. 500 mcg in 10 mL NS)", "500–1000 mcg in 100–250 mL NS (2–4 mcg/mL)", "25–100 mcg IV bolus; 25–200 mcg/h infusion", "Procedural sedation, analgesia in ICU, intubation, hemodynamically unstable patients", "Preferred opioid in ICU (rapid onset, short duration, minimal histamine, renal-safe)", "Acute pain, agitation, dyspnea; preferred over morphine in renal failure"), (18, "Midazolam", "Benzodiazepine Sedative / Anxiolytic", "0.5–1 mg/mL (e.g. 50 mg in 100 mL NS)", "50 mg in 100 mL NS (0.5 mg/mL)", "0.02–0.1 mg/kg/h infusion; 1–5 mg IV bolus for procedural sedation", "ICU sedation, seizure (status epilepticus), procedural sedation, alcohol withdrawal", "Short-acting BZD; rapid onset; amnesia; first-line for status epilepticus in many protocols", "Agitation, seizure, alcohol withdrawal (diaphoresis, tremor, hypertension, hallucinations)"), (19, "Propofol", "General Anesthetic / Sedative (GABA-A agonist)", "10 mg/mL (standard 1% emulsion; do NOT dilute in NS for infusion — use undiluted)", "Undiluted (1% = 10 mg/mL); use dedicated IV line; change vial every 12 h", "5–50 mcg/kg/min (sedation); higher for induction", "ICU sedation (ventilated patients), refractory status epilepticus, procedural sedation, RSI", "Preferred for daily awakening trials; rapid on/offset; lowers ICP; PRIS risk > 48 h high dose", "Agitation on ventilator, raised ICP, refractory seizures; PRIS: metabolic acidosis, rhabdomyolysis"), (20, "Dexmedetomidine", "Alpha-2 agonist Sedative / Analgesic", "0.004 mg/mL (4 mcg/mL); e.g. 200 mcg in 50 mL NS", "200 mcg in 50 mL NS (4 mcg/mL)", "0.2–1.5 mcg/kg/h IV; optional loading 1 mcg/kg over 10 min", "ICU sedation (light, cooperative), alcohol withdrawal, opioid-sparing analgesia, post-op shivering", "Cooperative sedation without respiratory depression; reduces opioid & BZD needs; facilitates weaning", "Agitation, delirium, alcohol/drug withdrawal, prevention of ICU delirium"), (21, "Ketamine", "Dissociative Anesthetic / Analgesic (NMDA antagonist)", "1–2 mg/mL (e.g. 500 mg in 500 mL NS)", "500 mg in 500 mL NS (1 mg/mL)", "0.1–0.5 mg/kg/h infusion; 1–2 mg/kg IV bolus for RSI/induction", "RSI in hypotensive/asthmatic patients, procedural sedation, refractory bronchospasm, pain management", "Bronchodilator; preserves airway reflexes; maintains hemodynamics; analgesic at sub-anesthetic doses", "Severe asthma, hypotensive trauma, procedural pain, status asthmaticus"), (22, "Hydralazine", "Antihypertensive (direct arteriolar vasodilator)", "0.2 mg/mL (e.g. 20 mg in 100 mL NS)", "20 mg in 100 mL NS (0.2 mg/mL)", "5–20 mg IV q4–6 h; or 0.1–0.2 mg/kg IV", "Hypertensive emergency in pregnancy/eclampsia, acute heart failure (afterload reduction)", "Reduces afterload; used in pregnancy (safe profile); reflex tachycardia is a side effect", "Eclampsia: severe hypertension, headache, visual disturbance, proteinuria, seizures"), (23, "Magnesium Sulfate", "Electrolyte / Anticonvulsant / Antiarrhythmic", "20 mg/mL (e.g. 4 g in 200 mL NS)", "4–5 g in 100–250 mL NS (loading); 1–2 g/h maintenance", "Loading: 4–6 g IV over 15–20 min; Maintenance: 1–2 g/h", "Eclampsia/pre-eclampsia (seizure prevention & Rx), Torsades de Pointes, severe asthma, hypomagnesemia", "Anticonvulsant of choice in eclampsia; treats TdP (Mg deficiency-related); bronchodilator in asthma", "Eclampsia: HTN, seizures, hyperreflexia; TdP: polymorphic VT, QTc prolongation; wheeze (asthma)"), (24, "Adenosine", "Antiarrhythmic (Class V / endogenous nucleoside)", "3 mg/mL standard vial; given undiluted IV push, NS flush immediately", "6 mg undiluted rapid IV push; if no effect: 12 mg × 2; follow with 20 mL NS flush", "6 mg IV rapid push; repeat 12 mg if needed", "PSVT (paroxysmal supraventricular tachycardia), SVT diagnosis", "Transiently blocks AV node; terminates AVNRT and AVRT; used diagnostically in wide-complex tachycardia", "Sudden-onset palpitations, rapid regular tachycardia (HR 150–250), dizziness, near-syncope (PSVT)"), (25, "Calcium Gluconate / Chloride", "Electrolyte / Cardiac stabilizer", "0.1 g/mL (10% solution = 100 mg/mL); NS dilution optional for infusion", "1–2 g in 100 mL NS for infusion; give undiluted slow IV push for emergency", "1 g (10 mL of 10%) IV over 3–5 min; infusion: 0.5–1 g/h", "Hyperkalemia (cardiac stabilization), hypocalcemia, calcium-channel blocker overdose, hypermagnesemia", "Stabilizes cardiac membrane (does NOT lower K+); temporizing measure before definitive K+ removal", "Peaked T-waves, wide QRS, bradycardia (hyperkalemia); tetany, prolonged QTc, seizures (hypocalcemia)"), (26, "Sodium Bicarbonate", "Alkalinizing agent / Buffer", "1 mEq/mL (8.4% solution); dilute for infusion", "50–100 mEq in 500 mL D5W or NS (hypotonic NaHCO3 for infusion)", "1–2 mEq/kg IV bolus for cardiac arrest; 50–100 mEq/h infusion for acidosis", "Severe metabolic acidosis (pH < 7.1), TCA overdose, hyperkalemia, urinary alkalinization, cardiac arrest (specific)", "Raises serum pH; widens QRS in TCA; shifts K+ intracellularly; alkalinizes urine in rhabdomyolysis", "Metabolic acidosis: Kussmaul breathing, confusion; TCA: wide QRS, hypotension, seizure; hyperkalemia"), (27, "Furosemide (Frusemide)", "Loop Diuretic", "10 mg/mL standard; 0.1–0.4 mg/mL for infusion", "250–500 mg in 250–500 mL NS (1 mg/mL) for continuous infusion", "Bolus: 20–200 mg IV; Infusion: 5–40 mg/h", "Acute pulmonary edema, fluid overload, hypertensive emergency, acute kidney injury (oliguria), hypercalcemia", "Rapidly reduces preload in APE; promotes urine output; used in AKI to convert oliguric to non-oliguric", "APE: orthopnea, bibasal crackles, SpO2↓, S3 gallop; fluid overload: edema, ascites, elevated JVP"), (28, "Potassium Chloride (KCl)", "Electrolyte replacement", "0.3–0.4 mEq/mL (e.g. 40 mEq in 100–150 mL NS); max 10 mEq/h via peripheral", "40 mEq in 100 mL NS (0.4 mEq/mL) over 4 h; use central line for rates > 10 mEq/h", "10–20 mEq/h IV (peripheral); up to 40 mEq/h central (life-threatening hypokalemia)", "Hypokalemia, hypokalemia-induced arrhythmias, DKA (K+ replacement), digoxin toxicity prevention", "Replaces K+ deficit; treats/prevents arrhythmias; critical in DKA as insulin drives K+ into cells", "Hypokalemia: weakness, ileus, U-waves, flat T-waves, PVCs, VT; severe: respiratory failure"), (29, "Alteplase (tPA)", "Thrombolytic (recombinant tissue plasminogen activator)", "1 mg/mL (reconstituted); dilute in NS for infusion", "0.9 mg/kg (max 90 mg): 10% as IV bolus, 90% in 100 mL NS over 60 min", "Ischemic stroke: 0.9 mg/kg; STEMI: 15 mg bolus then infusion; Massive PE: 100 mg over 2 h", "Acute ischemic stroke (< 4.5 h), massive PE with hemodynamic compromise, STEMI (if PCI unavailable)", "Dissolves thrombus; restores perfusion; strict hemorrhagic contraindication checklist required", "Stroke: sudden focal deficit, aphasia, facial droop, arm weakness; PE: acute dyspnea, syncope, obstructive shock"), (30, "Naloxone (Narcan)", "Opioid Antagonist (mu-receptor competitive antagonist)", "0.004 mg/mL for infusion (e.g. 2 mg in 500 mL NS); 0.4 mg/mL undiluted for bolus", "2 mg in 500 mL NS (0.004 mg/mL) for infusion; bolus undiluted", "Bolus: 0.4–2 mg IV q2–3 min prn; Infusion: 2/3 of effective bolus dose per hour", "Opioid overdose, opioid-induced respiratory depression, opioid reversal post-procedure", "Rapidly reverses opioid toxidrome; infusion used for long-acting opioids; titrate to respiratory rate not full reversal", "Opioid overdose: respiratory depression, miosis, altered consciousness, cyanosis, bradycardia"), ] # ── WORKBOOK SETUP ─────────────────────────────────────────────────────────── ws = wb.active ws.title = "ICU Emergency Drug Infusions" # ── COLORS ─────────────────────────────────────────────────────────────────── NAVY = "1F3864" TEAL = "17375E" LTBLUE = "BDD7EE" ALTROW = "EAF4FB" WHITE = "FFFFFF" GOLD = "C9A227" RED = "C00000" # ── HELPER: thin border ─────────────────────────────────────────────────────── thin = Side(style="thin", color="8EA9C1") border = Border(left=thin, right=thin, top=thin, bottom=thin) # ── TITLE ROW ──────────────────────────────────────────────────────────────── ws.merge_cells("A1:I1") title_cell = ws["A1"] title_cell.value = "Emergency Drug Infusions — ICU Reference Guide (30 Drugs)" title_cell.font = Font(name="Arial", bold=True, size=16, color=WHITE) title_cell.fill = PatternFill("solid", fgColor=NAVY) title_cell.alignment = Alignment(horizontal="center", vertical="center") ws.row_dimensions[1].height = 36 # ── SUBTITLE ROW ───────────────────────────────────────────────────────────── ws.merge_cells("A2:I2") sub = ws["A2"] sub.value = "Concentration (mg/mL) • Dilution in NS • Dose/Rate • Indications • ICU Role • Signs & Symptoms" sub.font = Font(name="Arial", italic=True, size=10, color=WHITE) sub.fill = PatternFill("solid", fgColor=TEAL) sub.alignment = Alignment(horizontal="center", vertical="center") ws.row_dimensions[2].height = 20 # ── HEADER ROW ─────────────────────────────────────────────────────────────── headers = [ "No.", "Drug Name", "Drug Class", "Standard Concentration", "Dilution in NS", "Usual Dose / Rate", "Indications", "ICU Role / Management", "Signs & Symptoms Treated" ] hdr_fill = PatternFill("solid", fgColor="2E74B5") hdr_font = Font(name="Arial", bold=True, size=10, color=WHITE) hdr_align = Alignment(horizontal="center", vertical="center", wrap_text=True) for col_idx, hdr in enumerate(headers, start=1): cell = ws.cell(row=3, column=col_idx, value=hdr) cell.font = hdr_font cell.fill = hdr_fill cell.alignment = hdr_align cell.border = border ws.row_dimensions[3].height = 32 # ── DATA ROWS ───────────────────────────────────────────────────────────────── base_font = Font(name="Arial", size=9) no_font = Font(name="Arial", size=9, bold=True, color=WHITE) cls_font = Font(name="Arial", size=9, italic=True, color="1F3864") ind_font = Font(name="Arial", size=9, color=RED) fill_alt = PatternFill("solid", fgColor=ALTROW) fill_dark = PatternFill("solid", fgColor=LTBLUE) fill_no = PatternFill("solid", fgColor="2E74B5") for row_idx, drug in enumerate(drugs, start=4): alt = (row_idx % 2 == 0) row_fill = fill_dark if not alt else fill_alt for col_idx, val in enumerate(drug, start=1): cell = ws.cell(row=row_idx, column=col_idx, value=val) cell.border = border cell.alignment = Alignment(vertical="top", wrap_text=True, horizontal="center" if col_idx == 1 else "left") if col_idx == 1: cell.font = no_font cell.fill = fill_no elif col_idx == 3: cell.font = cls_font cell.fill = row_fill elif col_idx == 7: cell.font = ind_font cell.fill = row_fill else: cell.font = base_font cell.fill = row_fill ws.row_dimensions[row_idx].height = 80 # ── COLUMN WIDTHS ───────────────────────────────────────────────────────────── col_widths = [5, 22, 28, 30, 32, 30, 38, 42, 48] for i, w in enumerate(col_widths, start=1): ws.column_dimensions[get_column_letter(i)].width = w # ── FREEZE PANES ────────────────────────────────────────────────────────────── ws.freeze_panes = "A4" # ── FOOTER ─────────────────────────────────────────────────────────────────── footer_row = len(drugs) + 4 ws.merge_cells(f"A{footer_row}:I{footer_row}") footer = ws.cell(row=footer_row, column=1, value="⚕ For clinical use only. Always verify against current institutional protocols, formulary, and patient-specific parameters. Prepared by Orris AI.") footer.font = Font(name="Arial", size=8, italic=True, color="595959") footer.alignment = Alignment(horizontal="center") ws.row_dimensions[footer_row].height = 18 # ── PAGE SETUP ─────────────────────────────────────────────────────────────── ws.page_setup.orientation = "landscape" ws.page_setup.paperSize = 9 # A4 ws.page_setup.fitToPage = True ws.page_setup.fitToWidth = 1 ws.page_setup.fitToHeight = 0 # ── SAVE ───────────────────────────────────────────────────────────────────── out_path = "/home/daytona/workspace/icu-drug-infusions/Emergency_Drug_Infusions_ICU.xlsx" wb.save(out_path) print(f"Saved: {out_path}") PYEOF echo "Script written."

cd /home/daytona/workspace/icu-drug-infusions && python3 build_infusions.py

ls -la /home/daytona/workspace/icu-drug-infusions/ && python3 -c "import openpyxl; wb = openpyxl.Workbook(); ws = wb.active; ws['A1'] = 'test'; wb.save('/home/daytona/workspace/icu-drug-infusions/test.xlsx'); print('ok')"

ls /home/daytona/skills/xlsx/ && python3 /home/daytona/skills/xlsx/create_excel.py --help 2>/dev/null || true

/home/daytona/skills/xlsx/scripts

python3 -c " import io, openpyxl wb = openpyxl.Workbook() ws = wb.active ws['A1'] = 'test' buf = io.BytesIO() wb.save(buf) buf.seek(0) data = buf.read() with open('/home/daytona/workspace/icu-drug-infusions/test.xlsx', 'wb') as f: f.write(data) print('ok', len(data)) "

~/icu-drug-infusions/build_infusions.py

cd /home/daytona/workspace/icu-drug-infusions && python3 build_infusions.py && ls -lh *.xlsx