mkdir -p /home/daytona/workspace/knot-table && cat > /home/daytona/workspace/knot-table/create_table.py << 'EOF' import openpyxl from openpyxl.styles import ( Font, PatternFill, Alignment, Border, Side, Color ) from openpyxl.utils import get_column_letter wb = openpyxl.Workbook() ws = wb.active ws.title = "Knot Configurations" # ── Color palette ────────────────────────────────────────────────────────────── TEAL_FILL = PatternFill("solid", fgColor="1A7A8A") # header bg TEAL_FONT = Font(color="1A7A8A", bold=True, name="Arial", size=10) ORANGE_FILL = PatternFill("solid", fgColor="E07820") ORANGE_FONT = Font(color="E07820", bold=True, name="Arial", size=10) RED_FILL = PatternFill("solid", fgColor="C0392B") RED_FONT = Font(color="C0392B", bold=True, name="Arial", size=10) HEADER_BG = PatternFill("solid", fgColor="1A7A8A") HEADER_FONT = Font(color="FFFFFF", bold=True, name="Arial", size=11) TITLE_FONT = Font(bold=True, name="Arial", size=14, color="1A3A4A") TITLE_BG = PatternFill("solid", fgColor="D9EEF3") BODY_FONT = Font(name="Arial", size=10) WRAP = Alignment(wrap_text=True, vertical="top") CENTER = Alignment(horizontal="center", vertical="center", wrap_text=True) def thin_border(): s = Side(style="thin", color="AAAAAA") return Border(left=s, right=s, top=s, bottom=s) def thick_border(): s = Side(style="medium", color="555555") return Border(left=s, right=s, top=s, bottom=s) # ── Column widths ────────────────────────────────────────────────────────────── col_widths = [18, 42, 42, 42, 42] for i, w in enumerate(col_widths, 1): ws.column_dimensions[get_column_letter(i)].width = w # ── Title row ────────────────────────────────────────────────────────────────── ws.merge_cells("A1:E1") title_cell = ws["A1"] title_cell.value = "Open and Laparoscopic Knot Configurations with Properties and Clinical Indications" title_cell.font = TITLE_FONT title_cell.fill = TITLE_BG title_cell.alignment = CENTER ws.row_dimensions[1].height = 36 # ── Column headers ───────────────────────────────────────────────────────────── headers = ["Property", "Square Knot\n(Card 1)", "Surgeon's Knot\n(Card 2)", "Granny Knot\n(Card 3)", "Reef / Slip Knot\n(Endoloop) (Card 4)"] for col, h in enumerate(headers, 1): c = ws.cell(row=2, column=col, value=h) c.font = HEADER_FONT c.fill = HEADER_BG c.alignment = CENTER c.border = thick_border() ws.row_dimensions[2].height = 32 # ── Data rows ────────────────────────────────────────────────────────────────── data = [ ( "Subtitle", "The gold standard", "First throw = double", "WRONG — slips under load", "Pre-tied; single use", ), ( "Description", "Two half-hitches thrown in OPPOSITE directions. Each throw locks the previous one flat. The FLS standard knot for all tasks. Cannot be locked flat if directions are the same (→ granny knot).", "First throw is a DOUBLE pass (2 wraps instead of 1) to hold tissue together without an assistant while completing subsequent throws. Subsequent throws are single — alternating direction to form a square.", "Both throws in the SAME direction. Superficially looks identical to square knot but cannot lock flat. Slips under tension. An examiner pulling on a granny knot will feel it give way — automatic FLS fail.", "A self-tightening slip knot pre-loaded in the Endoloop device. Activated by snapping the plastic release tab. Not a square knot — functions as a ratchet ligature that tightens when pushed but does not loosen.", ), ( "Structure", "Throw 1 (any dir) + Throw 2 (opposite dir) = Square. Repeat to add security throws.", "Double throw (2 wraps) + Single throw (opposite) + Single throw (original dir).", "Throw 1 (dir A) + Throw 2 (SAME dir A) = Granny. Knot rolls rather than locking.", "Single slip loop held by a ratchet/stop mechanism in the plastic applicator tube.", ), ( "Clinical Use", "Universal — all surgical closures, open and laparoscopic", "Under tension; no assistant; IC task first throw (FLS standard)", "NO surgical use — always an error", "Appendix ligation, cystic duct closure, vessel tips, peritoneal defects", ), ( "Security", "HIGHEST of all flat knots", "GOOD — double first throw prevents slippage while tying", "NONE — unreliable, unacceptable", "ADEQUATE for ligation — not for anastomosis", ), ( "Common Error", "Same direction twice = Granny Knot → SLIPS", "Repeating double throws → Knot bulk increases, difficult to lay flat", "This IS the mistake — NEVER use", "Cannot be untied/adjusted once deployed — must cut and reapply if malpositioned", ), ] row_heights = [22, 90, 50, 50, 40, 60] # Label fill colors per row label_fills = { "Subtitle": PatternFill("solid", fgColor="F0F0F0"), "Description": PatternFill("solid", fgColor="FFF3E8"), "Structure": PatternFill("solid", fgColor="E8F7F8"), "Clinical Use": PatternFill("solid", fgColor="E8F7F8"), "Security": PatternFill("solid", fgColor="E8F7F8"), "Common Error": PatternFill("solid", fgColor="FFF3E8"), } label_fonts = { "Subtitle": Font(name="Arial", size=10, italic=True, color="555555"), "Description": Font(name="Arial", size=10, bold=True, color="E07820"), "Structure": Font(name="Arial", size=10, bold=True, color="1A7A8A"), "Clinical Use": Font(name="Arial", size=10, bold=True, color="1A7A8A"), "Security": Font(name="Arial", size=10, bold=True, color="1A7A8A"), "Common Error": Font(name="Arial", size=10, bold=True, color="E07820"), } # Cell bg for data columns per row cell_fills = { "Subtitle": PatternFill("solid", fgColor="F9F9F9"), "Description": PatternFill("solid", fgColor="FFFFFF"), "Structure": PatternFill("solid", fgColor="F4FBFC"), "Clinical Use": PatternFill("solid", fgColor="F4FBFC"), "Security": PatternFill("solid", fgColor="F4FBFC"), "Common Error": PatternFill("solid", fgColor="FFF8F2"), } for r_idx, (row, height) in enumerate(zip(data, row_heights), 3): label = row[0] ws.row_dimensions[r_idx].height = height for col_idx, val in enumerate(row, 1): c = ws.cell(row=r_idx, column=col_idx, value=val) c.border = thin_border() c.alignment = WRAP if col_idx > 1 else Alignment(horizontal="center", vertical="center", wrap_text=True) if col_idx == 1: c.font = label_fonts.get(label, BODY_FONT) c.fill = label_fills.get(label, PatternFill("solid", fgColor="F0F0F0")) else: c.font = BODY_FONT c.fill = cell_fills.get(label, PatternFill("solid", fgColor="FFFFFF")) # ── Source footer ────────────────────────────────────────────────────────────── footer_row = len(data) + 3 ws.merge_cells(f"A{footer_row}:E{footer_row}") fc = ws[f"A{footer_row}"] fc.value = "Source: Fischer's Mastery of Surgery | SAGES FLS Course Manual | Sabiston Textbook of Surgery" fc.font = Font(name="Arial", size=9, italic=True, color="888888") fc.alignment = CENTER # ── Freeze panes ────────────────────────────────────────────────────────────── ws.freeze_panes = "B3" out = "/home/daytona/workspace/knot-table/Knot_Configurations_Table.xlsx" wb.save(out) print(f"Saved: {out}") EOF python3 /home/daytona/workspace/knot-table/create_table.py

ls -la /home/daytona/workspace/knot-table/ && python3 -c "import openpyxl; print(openpyxl.__version__)"

python3 - << 'EOF' import openpyxl from openpyxl.styles import Font, PatternFill, Alignment, Border, Side from openpyxl.utils import get_column_letter import os wb = openpyxl.Workbook() ws = wb.active ws.title = "Knot Configurations" def thin_border(): s = Side(style="thin", color="AAAAAA") return Border(left=s, right=s, top=s, bottom=s) def thick_border(): s = Side(style="medium", color="555555") return Border(left=s, right=s, top=s, bottom=s) HEADER_BG = PatternFill("solid", fgColor="1A7A8A") HEADER_FONT = Font(color="FFFFFF", bold=True, name="Arial", size=11) TITLE_FONT = Font(bold=True, name="Arial", size=14, color="1A3A4A") TITLE_BG = PatternFill("solid", fgColor="D9EEF3") BODY_FONT = Font(name="Arial", size=10) WRAP = Alignment(wrap_text=True, vertical="top") CENTER = Alignment(horizontal="center", vertical="center", wrap_text=True) col_widths = [18, 42, 42, 42, 42] for i, w in enumerate(col_widths, 1): ws.column_dimensions[get_column_letter(i)].width = w ws.merge_cells("A1:E1") t = ws["A1"] t.value = "Open and Laparoscopic Knot Configurations with Properties and Clinical Indications" t.font = TITLE_FONT; t.fill = TITLE_BG; t.alignment = CENTER ws.row_dimensions[1].height = 36 headers = ["Property","Square Knot\n(Card 1)","Surgeon's Knot\n(Card 2)","Granny Knot\n(Card 3)","Reef / Slip Knot (Endoloop)\n(Card 4)"] for col, h in enumerate(headers, 1): c = ws.cell(row=2, column=col, value=h) c.font = HEADER_FONT; c.fill = HEADER_BG; c.alignment = CENTER; c.border = thick_border() ws.row_dimensions[2].height = 32 data = [ ("Subtitle","The gold standard","First throw = double","WRONG — slips under load","Pre-tied; single use"), ("Description", "Two half-hitches thrown in OPPOSITE directions. Each throw locks the previous one flat. The FLS standard knot for all tasks. Cannot be locked flat if directions are the same (-> granny knot).", "First throw is a DOUBLE pass (2 wraps instead of 1) to hold tissue together without an assistant while completing subsequent throws. Subsequent throws are single — alternating direction to form a square.", "Both throws in the SAME direction. Superficially looks identical to square knot but cannot lock flat. Slips under tension. An examiner pulling on a granny knot will feel it give way — automatic FLS fail.", "A self-tightening slip knot pre-loaded in the Endoloop device. Activated by snapping the plastic release tab. Not a square knot — functions as a ratchet ligature that tightens when pushed but does not loosen."), ("Structure", "Throw 1 (any dir) + Throw 2 (opposite dir) = Square. Repeat to add security throws.", "Double throw (2 wraps) + Single throw (opposite) + Single throw (original dir).", "Throw 1 (dir A) + Throw 2 (SAME dir A) = Granny. Knot rolls rather than locking.", "Single slip loop held by a ratchet/stop mechanism in the plastic applicator tube."), ("Clinical Use", "Universal — all surgical closures, open and laparoscopic", "Under tension; no assistant; IC task first throw (FLS standard)", "NO surgical use — always an error", "Appendix ligation, cystic duct closure, vessel tips, peritoneal defects"), ("Security", "HIGHEST of all flat knots", "GOOD — double first throw prevents slippage while tying", "NONE — unreliable, unacceptable", "ADEQUATE for ligation — not for anastomosis"), ("Common Error", "Same direction twice = Granny Knot -> SLIPS", "Repeating double throws -> Knot bulk increases, difficult to lay flat", "This IS the mistake — NEVER use", "Cannot be untied/adjusted once deployed — must cut and reapply if malpositioned"), ] row_heights = [22, 90, 50, 45, 40, 55] label_fills = { "Subtitle": PatternFill("solid", fgColor="F0F0F0"), "Description": PatternFill("solid", fgColor="FFF3E8"), "Structure": PatternFill("solid", fgColor="E8F7F8"), "Clinical Use": PatternFill("solid", fgColor="E8F7F8"), "Security": PatternFill("solid", fgColor="E8F7F8"), "Common Error": PatternFill("solid", fgColor="FFF3E8"), } label_fonts = { "Subtitle": Font(name="Arial", size=10, italic=True, color="555555"), "Description": Font(name="Arial", size=10, bold=True, color="E07820"), "Structure": Font(name="Arial", size=10, bold=True, color="1A7A8A"), "Clinical Use": Font(name="Arial", size=10, bold=True, color="1A7A8A"), "Security": Font(name="Arial", size=10, bold=True, color="1A7A8A"), "Common Error": Font(name="Arial", size=10, bold=True, color="E07820"), } cell_fills = { "Subtitle": PatternFill("solid", fgColor="F9F9F9"), "Description": PatternFill("solid", fgColor="FFFFFF"), "Structure": PatternFill("solid", fgColor="F4FBFC"), "Clinical Use": PatternFill("solid", fgColor="F4FBFC"), "Security": PatternFill("solid", fgColor="F4FBFC"), "Common Error": PatternFill("solid", fgColor="FFF8F2"), } for r_idx, (row, height) in enumerate(zip(data, row_heights), 3): label = row[0] ws.row_dimensions[r_idx].height = height for col_idx, val in enumerate(row, 1): c = ws.cell(row=r_idx, column=col_idx, value=val) c.border = thin_border() if col_idx == 1: c.alignment = Alignment(horizontal="center", vertical="center", wrap_text=True) c.font = label_fonts.get(label, BODY_FONT) c.fill = label_fills.get(label, PatternFill("solid", fgColor="F0F0F0")) else: c.alignment = WRAP c.font = BODY_FONT c.fill = cell_fills.get(label, PatternFill("solid", fgColor="FFFFFF")) footer_row = len(data) + 3 ws.merge_cells(f"A{footer_row}:E{footer_row}") fc = ws[f"A{footer_row}"] fc.value = "Source: Fischer's Mastery of Surgery | SAGES FLS Course Manual | Sabiston Textbook of Surgery" fc.font = Font(name="Arial", size=9, italic=True, color="888888") fc.alignment = CENTER ws.freeze_panes = "B3" out = "/tmp/Knot_Configurations_Table.xlsx" wb.save(out) print(f"Saved to {out}, size={os.path.getsize(out)}") EOF

cp /tmp/Knot_Configurations_Table.xlsx /home/daytona/workspace/knot-table/Knot_Configurations_Table.xlsx && ls -lh /home/daytona/workspace/knot-table/