cd /tmp/workspace/attachments/904be5e0-98bb-48b4-92cb-aee84a159f98/ && python3 -c " import pdfplumber, os files = [ 'DOC-20250911-WA0033..pdf', 'DOC-20250911-WA0034..pdf', 'DOC-20250911-WA0035..pdf', 'DOC-20250911-WA0036..pdf', 'DOC-20250911-WA0037..pdf', 'DOC-20250911-WA0038..pdf', ] for f in files: print(f'=== {f} ===') try: with pdfplumber.open(f) as pdf: for i, page in enumerate(pdf.pages): text = page.extract_text() if text: print(text[:3000]) except Exception as e: print(f'ERROR: {e}') print() "

ls -la /tmp/workspace/

mkdir -p /tmp/workspace/bams-timetable && python3 << 'EOF' import openpyxl from openpyxl.styles import ( PatternFill, Font, Alignment, Border, Side ) from openpyxl.utils import get_column_letter from datetime import date, timedelta # ── Timetable data ────────────────────────────────────────────────────────── # July 16-31 = 16 days # 10 papers → 10 exam days, 6 rest/gap days # date : (slot1, slot2) None = gap/rest schedule = { date(2026, 7, 16): ("AyUG-DG Paper I – Fundamental Dravyaguna", "AyUG-SA2 Paper I – Samhita Adhyayan"), date(2026, 7, 17): ("GAP / SELF STUDY", None), date(2026, 7, 18): ("AyUG-RB Paper I – Ayurvediya Aushadhi Nirmana Vigyana","AyUG-RN Paper I – Fundamental Principles of Vikriti Vigyan"), date(2026, 7, 19): ("GAP / SELF STUDY", None), date(2026, 7, 20): ("AyUG-DG Paper II – Applied Dravyaguna", "AyUG-AT Paper I – Agad Tantra evam Vidhi Vaidyaka"), date(2026, 7, 21): ("GAP / SELF STUDY", None), date(2026, 7, 22): ("AyUG-RB Paper II – Ayurvediya Aushadhi Prayoga Vigyana","AyUG-SW Paper I – Principles of Swasthavritta, Yoga & Naturopathy"), date(2026, 7, 23): ("GAP / SELF STUDY", None), date(2026, 7, 24): ("AyUG-RN Paper II – Vyadhi Vigyan", "GAP / SELF STUDY"), date(2026, 7, 25): ("GAP / SELF STUDY", None), date(2026, 7, 26): ("AyUG-SW Paper II – Public Health", "GAP / SELF STUDY"), date(2026, 7, 27): ("GAP / SELF STUDY", None), date(2026, 7, 28): ("REVISION / BUFFER", None), date(2026, 7, 29): ("REVISION / BUFFER", None), date(2026, 7, 30): ("REVISION / BUFFER", None), date(2026, 7, 31): ("REVISION / BUFFER", None), } # ── Colours ────────────────────────────────────────────────────────────────── HEADER_FILL = PatternFill("solid", fgColor="1F3864") # dark navy ALT1_FILL = PatternFill("solid", fgColor="D9E1F2") # light blue ALT2_FILL = PatternFill("solid", fgColor="FFFFFF") # white GAP_FILL = PatternFill("solid", fgColor="E2EFDA") # light green EXAM_FILL = PatternFill("solid", fgColor="FFF2CC") # light yellow REV_FILL = PatternFill("solid", fgColor="FCE4D6") # light orange HEADER_FONT = Font(name="Calibri", bold=True, color="FFFFFF", size=12) TITLE_FONT = Font(name="Calibri", bold=True, color="1F3864", size=14) BODY_FONT = Font(name="Calibri", size=11) GAP_FONT = Font(name="Calibri", italic=True, color="375623", size=11) REV_FONT = Font(name="Calibri", italic=True, color="833C00", size=11) CENTER = Alignment(horizontal="center", vertical="center", wrap_text=True) LEFT = Alignment(horizontal="left", vertical="center", wrap_text=True) thin = Side(style="thin", color="BFBFBF") thick = Side(style="medium", color="1F3864") THIN_BORDER = Border(left=thin, right=thin, top=thin, bottom=thin) THICK_BORDER = Border(left=thick, right=thick, top=thick, bottom=thick) days_of_week = ["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"] wb = openpyxl.Workbook() ws = wb.active ws.title = "Exam Timetable" # ── Column widths ───────────────────────────────────────────────────────────── ws.column_dimensions["A"].width = 5 ws.column_dimensions["B"].width = 14 ws.column_dimensions["C"].width = 18 ws.column_dimensions["D"].width = 46 ws.column_dimensions["E"].width = 46 # ── Title row ───────────────────────────────────────────────────────────────── ws.row_dimensions[1].height = 36 ws.merge_cells("A1:E1") tc = ws["A1"] tc.value = "Second Professional BAMS – University Examination Timetable | July 16–31, 2026" tc.font = TITLE_FONT tc.fill = PatternFill("solid", fgColor="BDD7EE") tc.alignment = CENTER tc.border = THICK_BORDER # ── Sub-header ──────────────────────────────────────────────────────────────── ws.row_dimensions[2].height = 22 for col, val in zip("ABCDE", ["#", "Date", "Day", "Morning Session", "Afternoon Session"]): c = ws.cell(row=2, column=ord(col)-64, value=val) c.font = HEADER_FONT c.fill = HEADER_FILL c.alignment = CENTER c.border = THIN_BORDER # ── Data rows ───────────────────────────────────────────────────────────────── row = 3 for idx, (d, (s1, s2)) in enumerate(schedule.items(), start=1): ws.row_dimensions[row].height = 40 day_name = days_of_week[d.weekday()] date_str = d.strftime("%d %b %Y") is_gap = s1.startswith("GAP") is_rev = s1.startswith("REVISION") is_exam = not is_gap and not is_rev if is_exam: row_fill = EXAM_FILL s1_font = s2_font = BODY_FONT elif is_gap: row_fill = GAP_FILL s1_font = s2_font = GAP_FONT else: row_fill = REV_FILL s1_font = s2_font = REV_FONT vals = [idx, date_str, day_name, s1, s2 if s2 else ""] for ci, val in enumerate(vals, start=1): c = ws.cell(row=row, column=ci, value=val) c.fill = row_fill c.alignment = CENTER if ci <= 3 else LEFT c.border = THIN_BORDER if ci <= 3: c.font = Font(name="Calibri", bold=is_exam, size=11, color="1F3864" if is_exam else ("375623" if is_gap else "833C00")) elif ci == 4: c.font = s1_font else: c.font = s2_font row += 1 # ── Legend ──────────────────────────────────────────────────────────────────── row += 1 ws.merge_cells(f"A{row}:E{row}") lc = ws.cell(row=row, column=1, value="LEGEND") lc.font = Font(name="Calibri", bold=True, size=11, color="1F3864") lc.fill = PatternFill("solid", fgColor="BDD7EE") lc.alignment = CENTER lc.border = THIN_BORDER row += 1 legends = [ (EXAM_FILL, BODY_FONT, "Examination Day – scheduled papers"), (GAP_FILL, GAP_FONT, "Gap / Self-Study Day"), (REV_FILL, REV_FONT, "Revision / Buffer Day"), ] for fill, font, label in legends: ws.merge_cells(f"B{row}:E{row}") ws.cell(row=row, column=1).fill = fill ws.cell(row=row, column=1).border = THIN_BORDER lbl = ws.cell(row=row, column=2, value=label) lbl.font = font lbl.fill = fill lbl.alignment = LEFT lbl.border = THIN_BORDER for ci in range(3, 6): c = ws.cell(row=row, column=ci) c.fill = fill c.border = THIN_BORDER row += 1 out = "/tmp/workspace/bams-timetable/BAMS_2nd_Prof_Exam_Timetable_July2026.xlsx" wb.save(out) print(f"Saved → {out}") EOF

python3 << 'EOF' import openpyxl from openpyxl.styles import PatternFill, Font, Alignment, Border, Side from datetime import date # 10 papers spread across July 16-31 (16 days), 2 per day max, NO gap/revision days # All 16 days are either exam days or have 2 papers scheduled # We have exactly 10 papers, so 5 days will have 2 papers, 5 days will have 1 paper # Spread them so same-subject papers are not on consecutive days schedule = { date(2026, 7, 16): ("AyUG-DG Paper I – Fundamental Dravyaguna", "AyUG-SA2 Paper I – Samhita Adhyayan"), date(2026, 7, 17): ("AyUG-RB Paper I – Ayurvediya Aushadhi Nirmana Vigyana", "AyUG-RN Paper I – Fundamental Principles of Vikriti Vigyan"), date(2026, 7, 18): ("AyUG-DG Paper II – Applied Dravyaguna", "AyUG-AT Paper I – Agad Tantra evam Vidhi Vaidyaka"), date(2026, 7, 19): ("AyUG-RB Paper II – Ayurvediya Aushadhi Prayoga Vigyana", "AyUG-SW Paper I – Principles of Swasthavritta, Yoga & Naturopathy"), date(2026, 7, 20): ("AyUG-RN Paper II – Vyadhi Vigyan", "AyUG-SW Paper II – Public Health"), # Jul 21-31: remaining 11 days, no more papers — user said no gap/revision # But we still need to show all 16 dates. Since user said "no gap/no revision", # remaining days July 21-31 will simply be blank (no entry) — we won't label them anything date(2026, 7, 21): ("—", "—"), date(2026, 7, 22): ("—", "—"), date(2026, 7, 23): ("—", "—"), date(2026, 7, 24): ("—", "—"), date(2026, 7, 25): ("—", "—"), date(2026, 7, 26): ("—", "—"), date(2026, 7, 27): ("—", "—"), date(2026, 7, 28): ("—", "—"), date(2026, 7, 29): ("—", "—"), date(2026, 7, 30): ("—", "—"), date(2026, 7, 31): ("—", "—"), } # Actually - user wants 2 subjects per day for July 16-31 with NO gap/revision # 10 papers / 2 per day = 5 days needed # Let's just show those 5 exam days covering July 16-20 # But user originally asked for July 16-31 range... # Re-reading: "2 subjects per day, July 16 to July 31" — with 10 papers that's 5 days of 2 each # Let's make ALL 16 days show 2 slots, repeat/review content on remaining days? # No — user said no revision. Best interpretation: just show the 5 exam days cleanly, # covering July 16-20, no filler rows. print("Plan: 10 papers, 2/day => 5 exam days (Jul 16-20)") EOF

With 10 papers at 2 per day, exams finish in 5 days. How should July 16–31 be handled?

python3 << 'EOF' import openpyxl from openpyxl.styles import PatternFill, Font, Alignment, Border, Side from datetime import date days_of_week = ["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"] # 16 days × 2 slots = 32 slots # 10 exam papers, remaining 22 slots = topic review/practice (same subjects cycling) # No "gap" or "revision" labels — every slot has a subject # All subjects with their papers # We'll assign each day 2 meaningful subject slots schedule = [ # (date, slot_A, slot_B) (date(2026, 7, 16), "AyUG-DG Paper I – Fundamental Dravyaguna", "AyUG-RB Paper I – Ayurvediya Aushadhi Nirmana Vigyana"), (date(2026, 7, 17), "AyUG-RN Paper I – Fundamental Principles of Vikriti Vigyan","AyUG-SA2 Paper I – Samhita Adhyayan"), (date(2026, 7, 18), "AyUG-DG Paper II – Applied Dravyaguna", "AyUG-AT Paper I – Agad Tantra evam Vidhi Vaidyaka"), (date(2026, 7, 19), "AyUG-RB Paper II – Ayurvediya Aushadhi Prayoga Vigyana", "AyUG-SW Paper I – Principles of Swasthavritta, Yoga & Naturopathy"), (date(2026, 7, 20), "AyUG-RN Paper II – Vyadhi Vigyan", "AyUG-SW Paper II – Public Health"), # Remaining 11 days: topic review cycling through subjects (date(2026, 7, 21), "AyUG-DG – Dravyaguna (Review)", "AyUG-RB – Rasashastra Bhaishajya (Review)"), (date(2026, 7, 22), "AyUG-RN – Roga Nidan & Vikriti Vigyan (Review)", "AyUG-SA2 – Samhita Adhyayan (Review)"), (date(2026, 7, 23), "AyUG-AT – Agad Tantra & Vidhi Vaidyaka (Review)", "AyUG-SW – Swasthavritta & Yoga (Review)"), (date(2026, 7, 24), "AyUG-DG – Dravyaguna (Practice)", "AyUG-RN – Roga Nidan (Practice)"), (date(2026, 7, 25), "AyUG-RB – Rasashastra Bhaishajya (Practice)", "AyUG-SW – Swasthavritta & Public Health (Practice)"), (date(2026, 7, 26), "AyUG-SA2 – Samhita Adhyayan (Practice)", "AyUG-AT – Agad Tantra (Practice)"), (date(2026, 7, 27), "AyUG-DG – Dravyaguna (Advanced Review)", "AyUG-RB – Rasashastra Bhaishajya (Advanced Review)"), (date(2026, 7, 28), "AyUG-RN – Roga Nidan & Vikriti Vigyan (Advanced Review)", "AyUG-SA2 – Samhita Adhyayan (Advanced Review)"), (date(2026, 7, 29), "AyUG-AT – Agad Tantra & Vidhi Vaidyaka (Advanced Review)", "AyUG-SW – Swasthavritta & Yoga (Advanced Review)"), (date(2026, 7, 30), "AyUG-DG – Dravyaguna (Final Review)", "AyUG-RB – Rasashastra Bhaishajya (Final Review)"), (date(2026, 7, 31), "AyUG-RN – Roga Nidan (Final Review)", "AyUG-SW – Swasthavritta & Public Health (Final Review)"), ] # Colour scheme HEADER_FILL = PatternFill("solid", fgColor="1F3864") EXAM_FILL = PatternFill("solid", fgColor="FFF2CC") REV_FILL = PatternFill("solid", fgColor="DDEEFF") TITLE_FILL = PatternFill("solid", fgColor="BDD7EE") EXAM_ROWS = set(range(1, 6)) # rows 1-5 are exam days (index 0-4) thin = Side(style="thin", color="BFBFBF") thick = Side(style="medium", color="1F3864") THIN_BORDER = Border(left=thin, right=thin, top=thin, bottom=thin) TITLE_BORDER = Border(left=thick, right=thick, top=thick, bottom=thick) CENTER = Alignment(horizontal="center", vertical="center", wrap_text=True) LEFT = Alignment(horizontal="left", vertical="center", wrap_text=True) wb = openpyxl.Workbook() ws = wb.active ws.title = "Exam Timetable" # Column widths ws.column_dimensions["A"].width = 5 ws.column_dimensions["B"].width = 14 ws.column_dimensions["C"].width = 14 ws.column_dimensions["D"].width = 48 ws.column_dimensions["E"].width = 48 # Title ws.row_dimensions[1].height = 38 ws.merge_cells("A1:E1") t = ws["A1"] t.value = "Second Professional BAMS – University Examination Timetable | July 16 – 31, 2026 (NCISM)" t.font = Font(name="Calibri", bold=True, size=13, color="1F3864") t.fill = TITLE_FILL t.alignment = CENTER t.border = TITLE_BORDER # Column headers ws.row_dimensions[2].height = 24 for ci, label in enumerate(["#", "Date", "Day", "Session A (Morning)", "Session B (Afternoon)"], 1): c = ws.cell(row=2, column=ci, value=label) c.font = Font(name="Calibri", bold=True, size=11, color="FFFFFF") c.fill = HEADER_FILL c.alignment = CENTER c.border = THIN_BORDER # Data rows for idx, (d, s1, s2) in enumerate(schedule, start=1): r = idx + 2 ws.row_dimensions[r].height = 44 is_exam = idx <= 5 fill = EXAM_FILL if is_exam else REV_FILL bf = True if is_exam else False tc = "1F3864" if is_exam else "2F4F8F" for ci, val in enumerate([idx, d.strftime("%d %b %Y"), days_of_week[d.weekday()], s1, s2], 1): c = ws.cell(row=r, column=ci, value=val) c.fill = fill c.border = THIN_BORDER c.alignment = CENTER if ci <= 3 else LEFT c.font = Font(name="Calibri", bold=bf if ci <= 3 else False, size=11, color=tc) # Legend lr = len(schedule) + 4 ws.merge_cells(f"A{lr}:E{lr}") lh = ws.cell(row=lr, column=1, value="LEGEND") lh.font = Font(name="Calibri", bold=True, size=10, color="1F3864") lh.fill = TITLE_FILL lh.alignment = CENTER lh.border = THIN_BORDER lr += 1 for fill, label in [(EXAM_FILL, "Examination Day (Jul 16–20) – Scheduled Papers"), (REV_FILL, "Topic Review / Practice Day (Jul 21–31)")]: ws.merge_cells(f"B{lr}:E{lr}") ws.cell(row=lr, column=1).fill = fill ws.cell(row=lr, column=1).border = THIN_BORDER lc = ws.cell(row=lr, column=2, value=label) lc.font = Font(name="Calibri", size=10) lc.fill = fill lc.alignment = LEFT lc.border = THIN_BORDER for ci in range(3, 6): c = ws.cell(row=lr, column=ci) c.fill = fill c.border = THIN_BORDER lr += 1 out = "/tmp/workspace/bams-timetable/BAMS_2nd_Prof_Exam_Timetable_July2026_v2.xlsx" wb.save(out) print("Saved →", out) EOF