Can you make a schedule for me for my exam
What is your exam about? · When is your exam? · How many hours per day can you study?
NRE 1 for Pakistan I need schedule from 13 of July till 20 th September complete syllabus include mcqs practice 4 hours two sessions
NRE 1 Pakistan exam syllabus topics 2025 2026
https://firstaidmadeeasy.com.pk/blogs/home/details/nre-step-…
ls -la /home/daytona/workspace/ 2>/dev/null || echo "workspace empty or not found"
mkdir -p /home/daytona/workspace/nre-schedule && python3 << 'EOF' import openpyxl from openpyxl.styles import (PatternFill, Font, Alignment, Border, Side, GradientFill) from openpyxl.utils import get_column_letter from datetime import date, timedelta wb = openpyxl.Workbook() # ── colour palette ────────────────────────────────────────────── DARK_BLUE = "1F3864" MED_BLUE = "2E75B6" LIGHT_BLUE = "BDD7EE" ORANGE = "ED7D31" LIGHT_ORANGE= "FCE4D6" GREEN = "375623" LIGHT_GREEN = "E2EFDA" YELLOW = "FFF2CC" RED = "C00000" WHITE = "FFFFFF" GREY = "F2F2F2" DARK_GREY = "595959" def fill(hex_col): return PatternFill("solid", fgColor=hex_col) def font(bold=False, color=WHITE, size=11, name="Arial"): return Font(bold=bold, color=color, size=size, name=name) def center(): return Alignment(horizontal="center", vertical="center", wrap_text=True) def left(): return Alignment(horizontal="left", vertical="center", wrap_text=True) def thin_border(): s = Side(border_style="thin", color="BFBFBF") return Border(left=s, right=s, top=s, bottom=s) # ═══════════════════════════════════════════════════════════════ # SHEET 1 – OVERVIEW / MASTER PLAN # ═══════════════════════════════════════════════════════════════ ws1 = wb.active ws1.title = "Master Schedule" # Title block ws1.merge_cells("A1:H1") ws1["A1"] = "NRE STEP 1 – PAKISTAN | STUDY SCHEDULE" ws1["A1"].fill = fill(DARK_BLUE) ws1["A1"].font = Font(bold=True, color=WHITE, size=16, name="Arial") ws1["A1"].alignment = center() ws1.row_dimensions[1].height = 36 ws1.merge_cells("A2:H2") ws1["A2"] = "July 13 – September 20, 2026 | 4 hrs / day | 2 Sessions × 2 hrs | 70 Days" ws1["A2"].fill = fill(MED_BLUE) ws1["A2"].font = Font(bold=True, color=WHITE, size=11, name="Arial") ws1["A2"].alignment = center() ws1.row_dimensions[2].height = 22 ws1.row_dimensions[3].height = 8 # spacer # Session legend ws1.merge_cells("A4:H4") ws1["A4"] = "📘 Session 1 (Morning, 2 hrs): New Content / Reading / Notes 📝 Session 2 (Evening, 2 hrs): MCQs + Flashcard Review + Weak-point Revision" ws1["A4"].fill = fill(YELLOW) ws1["A4"].font = Font(bold=False, color="7F6000", size=10, name="Arial") ws1["A4"].alignment = center() ws1.row_dimensions[4].height = 22 ws1.row_dimensions[5].height = 8 # spacer # Phase headers phase_headers = ["Phase", "Dates", "Days", "Subject(s)", "Morning Session 1 Focus", "Evening Session 2 Focus", "Key Topics", "Resources"] col_widths = [10, 24, 7, 22, 34, 34, 44, 30] for i, (h, w) in enumerate(zip(phase_headers, col_widths), 1): c = ws1.cell(row=6, column=i) c.value = h c.fill = fill(DARK_BLUE) c.font = font(bold=True, size=10) c.alignment = center() c.border = thin_border() ws1.column_dimensions[get_column_letter(i)].width = w ws1.row_dimensions[6].height = 28 # Phase data phases = [ # phase, dates, days, subject, morn, eve, topics, resources ("Phase 1", "Jul 13 – Jul 19\n(Week 1)", 7, "Anatomy", "Gross Anatomy: Upper & Lower Limbs\nNeuroanatomy basics\nHead & Neck overview", "MCQs: Anatomy (50 Qs/day)\nFlashcard: muscle origins/insertions", "Brachial plexus, femoral triangle, cranial nerves, spinal cord tracts, ventricular system, autonomic NS", "BRS Gross Anatomy\nFirst Aid NRE Step 1\nMarrow / Qbank Anatomy"), ("Phase 2", "Jul 20 – Jul 26\n(Week 2)", 7, "Physiology", "CVS, Respiratory, Renal\nNervous system physiology", "MCQs: Physiology (50 Qs/day)\nReview CVS equations", "Frank-Starling, V/Q ratio, Henderson-Hasselbalch, GFR, RMP & AP, hormonal axes, GI motility", "BRS Physiology\nGanong Review\nFirst Aid NRE"), ("Phase 3", "Jul 27 – Aug 2\n(Week 3)", 7, "Biochemistry", "Metabolism (glycolysis, TCA, fatty acids)\nMolecular biology & genetics", "MCQs: Biochemistry (50 Qs/day)\nDraw metabolic pathways from memory", "Enzyme kinetics, HMP shunt, urea cycle, lysosomal storage diseases, DNA repair, mutations, vitamins & cofactors", "Lippincott Biochemistry\nFirst Aid NRE\nAmboss Biochem"), ("Phase 4", "Aug 3 – Aug 9\n(Week 4)", 7, "Pathology", "General Pathology (cell injury, inflammation, neoplasia)\nOrgan-system pathology", "MCQs: Pathology (60 Qs/day)\nFlashcards: lab findings + buzzwords", "Apoptosis vs necrosis, granuloma types, tumor markers, metaplasia, Robbins high-yield, CBC abnormalities", "Robbins Basic Pathology\nFirst Aid NRE\nAmboss / Marrow Pathology"), ("Phase 5", "Aug 10 – Aug 16\n(Week 5)", 7, "Pharmacology", "Pharmacokinetics & dynamics\nANS drugs, CVS drugs, Antibiotics", "MCQs: Pharmacology (50 Qs/day)\nDrug mechanism flashcards", "Beta-blockers, ACE inhibitors, diuretics, penicillin mechanism, resistance, antiepileptics, MOA tables", "Katzung & Trevor\nFirst Aid NRE\nSketchy Pharm (optional)"), ("Phase 6", "Aug 17 – Aug 23\n(Week 6)", 7, "Microbiology", "Bacteriology (gram+, gram-, anaerobes)\nVirology & Parasitology", "MCQs: Microbiology (50 Qs/day)\nPathogen vs disease flashcards", "Staph/Strep toxins, Mycobacteria, Hepatitis serology, HIV, malaria life cycle, helminth vs protozoa, lab ID", "Murray Medical Microbiology\nFirst Aid NRE\nSketchy Micro"), ("Phase 7", "Aug 24 – Aug 30\n(Week 7)", 7, "Behavioral Sciences\n& Ethics", "Biostatistics, epidemiology\nPsychology, ethics, patient communication", "MCQs: Behavioral Sciences (40 Qs/day)\nStatistics formula sheet practice", "Sensitivity/specificity, PPV/NPV, study designs, p-value, confidentiality, informed consent, defense mechanisms", "BRS Behavioral Sciences\nFirst Aid NRE\nUWorld Biostats"), ("Phase 8", "Aug 31 – Sep 7\n(Week 8 – 1.5 wks)", 8, "Rapid Revision:\nHigh-Yield All Subjects", "Re-read First Aid NRE Step 1 cover-to-cover\nFocus on bolded high-yield facts", "Mixed MCQs: 80 Qs/day across all subjects\nTarget weak areas from phase reviews", "STEMI vs NSTEMI, neonatal jaundice, drug of choice tables, TB treatment, malaria Rx, common lab panels", "First Aid NRE Step 1\nHigh-Yield 100 Topics PDF\nPersonal weak-point notes"), ("Phase 9", "Sep 8 – Sep 14\n(Week 9 – Timed Mock)", 7, "Mock Exam Practice", "Full timed mock exam (100 Qs in 2 hrs)\nImmediate review of wrong answers", "Targeted revision of incorrect MCQs\nRe-do weak-subject question sets", "Simulate exam conditions. Score, analyse error patterns. Repeat with different question banks daily.", "PMDC past papers\nMarrow / Amboss\nNREprep.com mock tests"), ("Phase 10", "Sep 15 – Sep 20\n(Final Week)", 6, "Final Revision\n& Exam Prep", "Light revision: high-yield tables only\nRead personal notes / mnemonics", "MCQs: 50 Qs easy-to-medium (confidence building)\nRest & sleep routine", "DO NOT start new topics. Review mnemonics, drug lists, micro buzzwords, path lab values only.", "First Aid NRE\nPersonal summary notes\nRest & exam logistics"), ] row_colors = [LIGHT_BLUE, LIGHT_GREEN, LIGHT_ORANGE, LIGHT_BLUE, LIGHT_GREEN, LIGHT_ORANGE, LIGHT_BLUE, YELLOW, LIGHT_BLUE, LIGHT_GREEN] for row_i, (ph, dates, days, subj, morn, eve, topics, resources) in enumerate(phases, 7): data = [ph, dates, days, subj, morn, eve, topics, resources] clr = row_colors[row_i - 7] for col_i, val in enumerate(data, 1): c = ws1.cell(row=row_i, column=col_i, value=val) c.fill = fill(clr) c.font = Font(color="000000", size=9, name="Arial") c.alignment = center() if col_i in [1,3,7] else left() c.border = thin_border() # Phase label bold ws1.cell(row=row_i, column=1).font = Font(bold=True, color=DARK_BLUE, size=9, name="Arial") ws1.row_dimensions[row_i].height = 60 # freeze panes ws1.freeze_panes = "A7" # ═══════════════════════════════════════════════════════════════ # SHEET 2 – DAILY SCHEDULE (every day Jul 13 – Sep 20) # ═══════════════════════════════════════════════════════════════ ws2 = wb.create_sheet("Daily Timetable") # Title ws2.merge_cells("A1:G1") ws2["A1"] = "NRE STEP 1 – DAILY STUDY TIMETABLE | July 13 – September 20, 2026" ws2["A1"].fill = fill(DARK_BLUE) ws2["A1"].font = Font(bold=True, color=WHITE, size=14, name="Arial") ws2["A1"].alignment = center() ws2.row_dimensions[1].height = 32 ws2.merge_cells("A2:G2") ws2["A2"] = "4 hrs/day | Session 1: Morning 2 hrs (Content) | Session 2: Evening 2 hrs (MCQs + Review)" ws2["A2"].fill = fill(MED_BLUE) ws2["A2"].font = Font(bold=True, color=WHITE, size=10, name="Arial") ws2["A2"].alignment = center() ws2.row_dimensions[2].height = 20 headers2 = ["Date", "Day", "Week / Phase", "Subject", "Session 1 – Morning (2 hrs)\nContent / Reading", "Session 2 – Evening (2 hrs)\nMCQs + Review", "Notes / Goals"] col_widths2 = [14, 12, 18, 20, 42, 42, 28] for i, (h, w) in enumerate(zip(headers2, col_widths2), 1): c = ws2.cell(row=3, column=i) c.value = h c.fill = fill(DARK_BLUE) c.font = font(bold=True, size=10) c.alignment = center() c.border = thin_border() ws2.column_dimensions[get_column_letter(i)].width = w ws2.row_dimensions[3].height = 34 # Subject allocation per week def get_subject_info(d): if date(2026,7,13) <= d <= date(2026,7,19): return "Anatomy", "Gross Anatomy topic of the day\n(see Phase 1 key topics)", "50 Anatomy MCQs + flashcards", "1", "Phase 1" elif date(2026,7,20) <= d <= date(2026,7,26): return "Physiology", "Physiology topic of the day\n(CVS → Resp → Renal → NS)", "50 Physiology MCQs + review notes", "2", "Phase 2" elif date(2026,7,27) <= d <= date(2026,8,2): return "Biochemistry", "Biochemistry topic of the day\n(Metabolism → Genetics → Vitamins)", "50 Biochemistry MCQs + pathway diagrams", "3", "Phase 3" elif date(2026,8,3) <= d <= date(2026,8,9): return "Pathology", "Pathology topic of the day\n(General Path → Organ Systems)", "60 Pathology MCQs + buzzword flashcards", "4", "Phase 4" elif date(2026,8,10) <= d <= date(2026,8,16): return "Pharmacology", "Pharmacology topic of the day\n(PK/PD → ANS → CVS → Antimicrobials)", "50 Pharmacology MCQs + drug tables", "5", "Phase 5" elif date(2026,8,17) <= d <= date(2026,8,23): return "Microbiology", "Microbiology topic of the day\n(Bacteria → Viruses → Parasites)", "50 Microbiology MCQs + pathogen cards", "6", "Phase 6" elif date(2026,8,24) <= d <= date(2026,8,30): return "Behavioral Sci.", "Behavioral Sci topic of the day\n(Biostatistics → Ethics → Psychology)", "40 Behavioral MCQs + stats formulas", "7", "Phase 7" elif date(2026,8,31) <= d <= date(2026,9,7): return "Rapid Revision", "First Aid NRE re-read (high-yield only)\nFocus on weak subjects", "80 Mixed MCQs (all subjects)\nTarget personal weak areas", "8", "Phase 8" elif date(2026,9,8) <= d <= date(2026,9,14): return "Mock Exams", "Full 100-Q timed mock (2 hrs)\nNo breaks – simulate real exam", "Review all wrong answers\nRedo weak-subject MCQs (50 Qs)", "9", "Phase 9" elif date(2026,9,15) <= d <= date(2026,9,20): return "Final Revision", "Light revision: tables & mnemonics only\nNo new topics", "50 Confidence-building MCQs\nRest & logistics prep", "10", "Phase 10" return "–","–","–","–","–" days_of_week = ["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"] phase_colors = { "1": LIGHT_BLUE, "2": LIGHT_GREEN, "3": LIGHT_ORANGE, "4": "D9E1F2", "5": "E2EFDA", "6": "FCE4D6", "7": LIGHT_BLUE, "8": YELLOW, "9": "FFD7D7", "10": "D9F0D3" } sunday_fill = fill("FFD7D7") # light red for Sundays (rest reminder) start_date = date(2026, 7, 13) end_date = date(2026, 9, 20) current = start_date row_num = 4 while current <= end_date: subj, s1, s2, phase_num, phase_label = get_subject_info(current) day_name = days_of_week[current.weekday()] date_str = current.strftime("%a, %b %d") week_num = ((current - start_date).days // 7) + 1 phase_str = f"Week {week_num}\n{phase_label}" # Sunday = lighter schedule note s1_text = s1 s2_text = s2 note = "" if day_name == "Sunday": s1_text = "⚡ LIGHT DAY\n" + s1 s2_text = "30 MCQs (review only)\nRest & recharge" note = "Rest day – reduce intensity" elif day_name == "Friday": note = "Weekly review: 100 mixed MCQs" elif day_name == "Saturday": note = "Timed MCQ block (60 Qs, 1 hr)" clr = phase_colors.get(phase_num, GREY) row_data = [date_str, day_name, phase_str, subj, s1_text, s2_text, note] for col_i, val in enumerate(row_data, 1): c = ws2.cell(row=row_num, column=col_i, value=val) c.fill = fill(clr) if day_name != "Sunday" else sunday_fill c.font = Font(color="000000", size=8.5, name="Arial", bold=(col_i in [1,2] or day_name=="Sunday")) c.alignment = center() if col_i <= 4 else left() c.border = thin_border() ws2.row_dimensions[row_num].height = 44 current += timedelta(days=1) row_num += 1 ws2.freeze_panes = "A4" # ═══════════════════════════════════════════════════════════════ # SHEET 3 – MCQ TRACKER # ═══════════════════════════════════════════════════════════════ ws3 = wb.create_sheet("MCQ Tracker") ws3.merge_cells("A1:H1") ws3["A1"] = "NRE Step 1 – MCQ Practice Tracker" ws3["A1"].fill = fill(DARK_BLUE) ws3["A1"].font = Font(bold=True, color=WHITE, size=14, name="Arial") ws3["A1"].alignment = center() ws3.row_dimensions[1].height = 30 ws3.merge_cells("A2:H2") ws3["A2"] = "Track daily MCQ performance per subject — update % correct each evening" ws3["A2"].fill = fill(MED_BLUE) ws3["A2"].font = Font(bold=True, color=WHITE, size=10, name="Arial") ws3["A2"].alignment = center() ws3.row_dimensions[2].height = 20 hdrs3 = ["Week", "Date Range", "Subject", "Qs Attempted", "Qs Correct", "% Score", "Weak Areas Identified", "Action Taken"] wds3 = [8, 22, 18, 14, 14, 10, 36, 36] for i, (h, w) in enumerate(zip(hdrs3, wds3), 1): c = ws3.cell(row=3, column=i) c.value = h c.fill = fill(DARK_BLUE) c.font = font(bold=True, size=10) c.alignment = center() c.border = thin_border() ws3.column_dimensions[get_column_letter(i)].width = w ws3.row_dimensions[3].height = 26 tracker_rows = [ (1, "Jul 13–19", "Anatomy", "", "", "", "", ""), (2, "Jul 20–26", "Physiology", "", "", "", "", ""), (3, "Jul 27–Aug2","Biochemistry", "", "", "", "", ""), (4, "Aug 3–9", "Pathology", "", "", "", "", ""), (5, "Aug 10–16", "Pharmacology", "", "", "", "", ""), (6, "Aug 17–23", "Microbiology", "", "", "", "", ""), (7, "Aug 24–30", "Behavioral Sci.", "", "", "", "", ""), (8, "Aug 31–Sep7","Rapid Revision", "", "", "", "", ""), (9, "Sep 8–14", "Mock Exams", "", "", "", "", ""), (10,"Sep 15–20", "Final Revision", "", "", "", "", ""), ] t_colors = [LIGHT_BLUE, LIGHT_GREEN, LIGHT_ORANGE, "D9E1F2", "E2EFDA", "FCE4D6", LIGHT_BLUE, YELLOW, "FFD7D7", "D9F0D3"] for ri, (wk, dr, subj, qa, qc, sc, wa, ac) in enumerate(tracker_rows, 4): clr = t_colors[ri-4] for ci, val in enumerate([wk, dr, subj, qa, qc, sc, wa, ac], 1): c = ws3.cell(row=ri, column=ci, value=val) c.fill = fill(clr) c.font = Font(color="000000", size=10, name="Arial") c.alignment = center() if ci <= 6 else left() c.border = thin_border() # % formula (if Qs attempted and correct filled in cols D and E) ws3.cell(row=ri, column=6).value = f"=IF(D{ri}>0,E{ri}/D{ri},\"\")" ws3.cell(row=ri, column=6).number_format = "0%" ws3.row_dimensions[ri].height = 24 # ═══════════════════════════════════════════════════════════════ # SHEET 4 – TIPS & RESOURCES # ═══════════════════════════════════════════════════════════════ ws4 = wb.create_sheet("Tips & Resources") ws4.column_dimensions["A"].width = 24 ws4.column_dimensions["B"].width = 70 ws4.merge_cells("A1:B1") ws4["A1"] = "NRE Step 1 – Study Tips & Recommended Resources" ws4["A1"].fill = fill(DARK_BLUE) ws4["A1"].font = Font(bold=True, color=WHITE, size=14, name="Arial") ws4["A1"].alignment = center() ws4.row_dimensions[1].height = 30 tips = [ ("DAILY ROUTINE", ""), ("Morning Session", "08:00–10:00 AM → New content reading (textbook/First Aid). Make concise notes."), ("Break", "10:00–12:00 → Rest, meals, short nap. Do NOT skip breaks."), ("Evening Session", "04:00–06:00 PM → MCQs (timed), review wrong answers, flashcards."), ("Night Wrap-up", "15 min before bed → Skim today's notes/flashcards. No new content."), ("", ""), ("HIGH-YIELD FOCUS", ""), ("Anatomy", "Brachial plexus injuries, hernias, dermatomes, cranial nerves, spinal cord tracts."), ("Physiology", "Frank-Starling curve, acid-base disorders, GFR/clearance, action potentials."), ("Biochemistry", "Enzyme deficiency diseases, metabolic pathways, DNA repair, vitamins."), ("Pathology", "Robbins buzzwords, tumor markers, inflammation mediators, CBC patterns."), ("Pharmacology", "Drug mechanisms, side-effects, antidotes, antibiotics spectrum."), ("Microbiology", "Gram stain, culture media, toxin mechanisms, Hepatitis serology, HIV."), ("Behavioral Sci.", "Sensitivity/Specificity, study designs, ethics principles (autonomy, beneficence)."), ("", ""), ("RECOMMENDED BOOKS",""), ("First Aid NRE", "Primary resource – read cover-to-cover twice (Phases 1-7 and Phase 8)."), ("Robbins Pathology","Basic Pathology (shorter edition). Focus on Chapters 1-4 + organ systems."), ("BRS Physiology", "Best for quick physiology review with self-test MCQs."), ("Lippincott Biochem","Illustrated Biochemistry – metabolism chapters especially."), ("Katzung Pharm", "Katzung & Trevor's Pharmacology review Q&A."), ("Murray Micro", "Medical Microbiology – use summary tables."), ("", ""), ("QUESTION BANKS", ""), ("Amboss", "Best overall QBank. Use spaced repetition mode."), ("Marrow", "Good for NRE-specific questions and image-based MCQs."), ("NREprep.com", "Pakistan-specific NRE question bank. Use for final phase."), ("PMDC Past Papers", "Download from pmdc.pk – practice under timed conditions."), ("", ""), ("WEEKLY REVIEW DAY","Every Friday: do 100 mixed MCQs + note weak topics for weekend revision."), ("SUNDAY", "Reduced intensity day. 30 MCQs only + rest. Prepare for next week."), ("MOCK EXAM WEEK", "Sep 8-14: Treat every mock like the real exam. No phones, timed strictly."), ("FINAL WEEK TIP", "Sep 15-20: DO NOT start any new topic. Revise only. Sleep 7-8 hrs."), ] row_c = 2 for cat, detail in tips: if cat == "" and detail == "": ws4.row_dimensions[row_c].height = 6 row_c += 1 continue is_header = (detail == "") c_a = ws4.cell(row=row_c, column=1, value=cat) c_b = ws4.cell(row=row_c, column=2, value=detail) if is_header: for c in [c_a, c_b]: c.fill = fill(MED_BLUE) c.font = Font(bold=True, color=WHITE, size=11, name="Arial") c.alignment = left() c.border = thin_border() ws4.merge_cells(f"A{row_c}:B{row_c}") ws4.row_dimensions[row_c].height = 24 else: c_a.fill = fill(LIGHT_BLUE) c_a.font = Font(bold=True, color=DARK_BLUE, size=10, name="Arial") c_a.alignment = left() c_a.border = thin_border() c_b.fill = fill(GREY) c_b.font = Font(color="000000", size=10, name="Arial") c_b.alignment = left() c_b.border = thin_border() ws4.row_dimensions[row_c].height = 22 row_c += 1 # Save out_path = "/home/daytona/workspace/nre-schedule/NRE_Step1_Study_Schedule.xlsx" wb.save(out_path) print(f"Saved: {out_path}") EOF
ls -la /home/daytona/workspace/nre-schedule/ && df -h /home/daytona/workspace/
mkdir -p /home/daytona/workspace/nre-schedule && ls -la /home/daytona/workspace/
ls /home/daytona/workspace/ && mkdir /home/daytona/workspace/nre-schedule && echo "dir created"
ls /home/daytona/ && stat /home/daytona/workspace
ls -la /home/daytona/ && file /home/daytona/workspace
d?????????). Let me write the file to an alternative location:mkdir -p /home/daytona/nre-schedule && echo "created" && ls /home/daytona/nre-schedule/
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 wb = openpyxl.Workbook() DARK_BLUE="1F3864"; MED_BLUE="2E75B6"; LIGHT_BLUE="BDD7EE"; ORANGE="ED7D31" LIGHT_ORANGE="FCE4D6"; LIGHT_GREEN="E2EFDA"; YELLOW="FFF2CC"; WHITE="FFFFFF" GREY="F2F2F2" def fill(h): return PatternFill("solid",fgColor=h) def font(bold=False,color=WHITE,size=11,name="Arial"): return Font(bold=bold,color=color,size=size,name=name) def center(): return Alignment(horizontal="center",vertical="center",wrap_text=True) def left(): return Alignment(horizontal="left", vertical="center",wrap_text=True) def border(): s=Side(border_style="thin",color="BFBFBF") return Border(left=s,right=s,top=s,bottom=s) # ── SHEET 1: Master Schedule ───────────────────────────────── ws1=wb.active; ws1.title="Master Schedule" ws1.merge_cells("A1:H1"); ws1["A1"]="NRE STEP 1 – PAKISTAN | COMPLETE STUDY SCHEDULE" ws1["A1"].fill=fill(DARK_BLUE); ws1["A1"].font=Font(bold=True,color=WHITE,size=15,name="Arial"); ws1["A1"].alignment=center(); ws1.row_dimensions[1].height=34 ws1.merge_cells("A2:H2"); ws1["A2"]="July 13 – September 20, 2026 | 4 hrs/day | Session 1 (Morning 2 hrs): Content | Session 2 (Evening 2 hrs): MCQs + Review" ws1["A2"].fill=fill(MED_BLUE); ws1["A2"].font=Font(bold=True,color=WHITE,size=10,name="Arial"); ws1["A2"].alignment=center(); ws1.row_dimensions[2].height=20 ws1.merge_cells("A3:H3"); ws1["A3"]="Total: 70 days | 7 Core Subjects + Revision + Mock Exams" ws1["A3"].fill=fill(YELLOW); ws1["A3"].font=Font(bold=True,color="7F6000",size=10,name="Arial"); ws1["A3"].alignment=center(); ws1.row_dimensions[3].height=18 ws1.row_dimensions[4].height=6 hdrs=["Phase","Dates","Days","Subject","Session 1 Morning (2 hrs)","Session 2 Evening (2 hrs)","Key High-Yield Topics","Resources"] widths=[10,22,6,20,36,36,46,30] for i,(h,w) in enumerate(zip(hdrs,widths),1): c=ws1.cell(row=5,column=i,value=h); c.fill=fill(DARK_BLUE); c.font=font(bold=True,size=10) c.alignment=center(); c.border=border(); ws1.column_dimensions[get_column_letter(i)].width=w ws1.row_dimensions[5].height=26 phases=[ ("Phase 1","Jul 13–19 (Wk 1)",7,"ANATOMY", "Gross Anatomy: Upper Limb, Lower Limb\nHead & Neck\nNeuroanatomy & Autonomic NS", "50 Anatomy MCQs\nFlashcards: nerves, muscles, vessels", "Brachial plexus injuries • Femoral/inguinal triangle • Dermatomes • Cranial nerves I-XII • Ventricular system • Spinal cord tracts", "BRS Gross Anatomy\nFirst Aid NRE Step 1\nMarrow / Amboss"), ("Phase 2","Jul 20–26 (Wk 2)",7,"PHYSIOLOGY", "CVS Physiology\nRespiratory & Renal\nNervous System & Endocrine", "50 Physiology MCQs\nReview equations (Frank-Starling, GFR)", "Cardiac output equations • V/Q ratio • Henderson-Hasselbalch • GFR/Tm • Action potentials • HPA/HPG/HPT axes", "BRS Physiology\nGanong Review\nFirst Aid NRE"), ("Phase 3","Jul 27–Aug 2 (Wk 3)",7,"BIOCHEMISTRY", "Metabolic Pathways (glycolysis, TCA, FA)\nMolecular Biology & Genetics\nVitamins & Cofactors", "50 Biochemistry MCQs\nDraw pathways from memory", "Enzyme kinetics (Km/Vmax) • Lysosomal storage diseases • Urea cycle • Hemoglobin variants • DNA repair disorders • Vitamin deficiencies", "Lippincott Biochemistry\nFirst Aid NRE\nAmboss Biochem"), ("Phase 4","Aug 3–9 (Wk 4)",7,"PATHOLOGY", "General Pathology (cell injury, inflammation, neoplasia)\nOrgan-System Pathology", "60 Pathology MCQs\nBuzzword flashcards + lab patterns", "Apoptosis vs necrosis • Granuloma types • Tumor markers • Metaplasia/dysplasia • CBC patterns • Robbins high-yield findings", "Robbins Basic Pathology\nFirst Aid NRE\nAmboss / Marrow Pathology"), ("Phase 5","Aug 10–16 (Wk 5)",7,"PHARMACOLOGY", "Pharmacokinetics & Dynamics\nANS / CVS / CNS Drugs\nAntimicrobials", "50 Pharmacology MCQs\nDrug mechanism + SE flashcards", "Beta-blockers • ACE-I/ARBs • Diuretics • Penicillin MOA & resistance • Antiepileptics • Drug antidotes • Autonomic receptor chart", "Katzung & Trevor\nFirst Aid NRE\nSketchy Pharm"), ("Phase 6","Aug 17–23 (Wk 6)",7,"MICROBIOLOGY", "Bacteriology (Gram +/-)\nVirology + Parasitology + Mycology", "50 Microbiology MCQs\nPathogen-disease-lab flashcards", "Staph/Strep toxins • Mycobacteria TB Rx • Hepatitis serology (A/B/C/D/E) • HIV • Malaria life cycle • Helminth vs protozoa", "Murray Medical Microbiology\nFirst Aid NRE\nSketchy Micro"), ("Phase 7","Aug 24–30 (Wk 7)",7,"BEHAVIORAL SCI.\n& ETHICS", "Biostatistics & Epidemiology\nPsychiatry basics\nMedical Ethics", "40 Behavioral Sci. MCQs\nStatistics formula practice", "Sensitivity/Specificity/PPV/NPV • Study designs (RCT, cohort, case-control) • p-value/CI • Autonomy/Beneficence • Defense mechanisms", "BRS Behavioral Sciences\nFirst Aid NRE\nUWorld Biostats"), ("Phase 8","Aug 31–Sep 7 (Wk 8)",8,"RAPID REVISION\n(All Subjects)", "First Aid NRE re-read (bold facts only)\nFocus on personal weak areas", "80 Mixed MCQs (all subjects)\nTarget weak-area question sets", "Drug of choice tables • STEMI/NSTEMI • Neonatal jaundice • Malaria/TB/Syphilis Rx • Common lab patterns • High-yield 100 topics", "First Aid NRE Step 1\nHigh-Yield 100 Topics PDF\nPersonal notes"), ("Phase 9","Sep 8–14 (Wk 9)",7,"MOCK EXAMS\n(Full Timed)", "100-Q timed mock exam (2 hrs)\nImmediate wrong-answer review", "Targeted redo of incorrect MCQs\nWeak-subject question sets (50 Qs)", "Simulate real exam conditions. Score each mock. Analyse error patterns by subject. Adjust final revision accordingly.", "PMDC past papers\nMarrow / Amboss\nNREprep.com"), ("Phase 10","Sep 15–20 (Wk 10)",6,"FINAL REVISION\n& EXAM PREP", "Light revision: tables & mnemonics ONLY\nNo new topics whatsoever", "50 easy/medium MCQs (confidence)\nRest & exam day logistics", "DO NOT start new topics. Skim drug lists, micro buzzwords, path lab values, mnemonics. Sleep 7-8 hrs nightly.", "First Aid NRE\nPersonal summary notes"), ] row_clrs=[LIGHT_BLUE,LIGHT_GREEN,LIGHT_ORANGE,"D9E1F2","E2EFDA","FCE4D6",LIGHT_BLUE,YELLOW,"FFD7D7","D9F0D3"] for ri,(ph,dates,days,subj,s1,s2,topics,res) in enumerate(phases,6): clr=row_clrs[ri-6] for ci,v in enumerate([ph,dates,days,subj,s1,s2,topics,res],1): c=ws1.cell(row=ri,column=ci,value=v) c.fill=fill(clr); c.font=Font(color="000000",size=9,name="Arial") c.alignment=center() if ci in[1,3] else left(); c.border=border() ws1.cell(row=ri,column=1).font=Font(bold=True,color=DARK_BLUE,size=9,name="Arial") ws1.row_dimensions[ri].height=62 ws1.freeze_panes="A6" # ── SHEET 2: Daily Timetable ───────────────────────────────── ws2=wb.create_sheet("Daily Timetable") ws2.merge_cells("A1:G1"); ws2["A1"]="NRE STEP 1 – DAILY TIMETABLE | July 13 – September 20, 2026" ws2["A1"].fill=fill(DARK_BLUE); ws2["A1"].font=Font(bold=True,color=WHITE,size=13,name="Arial"); ws2["A1"].alignment=center(); ws2.row_dimensions[1].height=30 ws2.merge_cells("A2:G2"); ws2["A2"]="Session 1 (Morning 08:00–10:00): New Content | Session 2 (Evening 16:00–18:00): MCQs + Review" ws2["A2"].fill=fill(MED_BLUE); ws2["A2"].font=Font(bold=True,color=WHITE,size=10,name="Arial"); ws2["A2"].alignment=center(); ws2.row_dimensions[2].height=18 hdrs2=["Date","Day","Phase / Week","Subject","Session 1 – Morning 2 hrs\n(Content / Reading)","Session 2 – Evening 2 hrs\n(MCQs + Flashcard Review)","Special Notes"] w2=[14,12,16,18,44,44,28] for i,(h,w) in enumerate(zip(hdrs2,w2),1): c=ws2.cell(row=3,column=i,value=h); c.fill=fill(DARK_BLUE); c.font=font(bold=True,size=10) c.alignment=center(); c.border=border(); ws2.column_dimensions[get_column_letter(i)].width=w ws2.row_dimensions[3].height=32 def get_day(d): if date(2026,7,13)<=d<=date(2026,7,19): return ("Anatomy","Gross Anatomy – upper limb, lower limb, head & neck, neuro","50 Anatomy MCQs + flashcards","Phase 1","1") if date(2026,7,20)<=d<=date(2026,7,26): return ("Physiology","Physiology – CVS > Resp > Renal > NS > Endocrine","50 Physiology MCQs + equation review","Phase 2","2") if date(2026,7,27)<=d<=date(2026,8,2): return ("Biochemistry","Biochemistry – metabolism > genetics > vitamins","50 Biochem MCQs + pathway diagrams","Phase 3","3") if date(2026,8,3) <=d<=date(2026,8,9): return ("Pathology","Pathology – general path > organ system pathology","60 Pathology MCQs + buzzword cards","Phase 4","4") if date(2026,8,10)<=d<=date(2026,8,16): return ("Pharmacology","Pharmacology – PK/PD > ANS > CVS > antimicrobials","50 Pharm MCQs + drug mechanism tables","Phase 5","5") if date(2026,8,17)<=d<=date(2026,8,23): return ("Microbiology","Microbiology – bacteria > viruses > parasites","50 Micro MCQs + pathogen-disease cards","Phase 6","6") if date(2026,8,24)<=d<=date(2026,8,30): return ("Behavioral Sci.","Behavioral Sci – biostats > ethics > psychiatry basics","40 Behav MCQs + statistics formulas","Phase 7","7") if date(2026,8,31)<=d<=date(2026,9,7): return ("Rapid Revision","First Aid NRE re-read: highlight weak areas & bold facts","80 Mixed MCQs all subjects","Phase 8","8") if date(2026,9,8) <=d<=date(2026,9,14): return ("Mock Exam","Full 100-Q timed mock (strict 2 hr limit)","Review all wrong answers + 50 weak-subject Qs","Phase 9","9") if date(2026,9,15)<=d<=date(2026,9,20): return ("Final Revision","Light revision: drug tables, mnemonics, lab values ONLY","50 confidence-building MCQs + rest","Phase 10","10") return ("–","–","–","–","–") pclrs={"1":LIGHT_BLUE,"2":LIGHT_GREEN,"3":LIGHT_ORANGE,"4":"D9E1F2","5":"E2EFDA", "6":"FCE4D6","7":LIGHT_BLUE,"8":YELLOW,"9":"FFD7D7","10":"D9F0D3"} dow=["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"] start=date(2026,7,13); end=date(2026,9,20); cur=start; rn=4 while cur<=end: subj,s1,s2,phase_label,pn=get_day(cur) day_name=dow[cur.weekday()] wk=((cur-start).days//7)+1 note="" if day_name=="Sunday": s2="30 MCQs only (light)\nRest & recharge"; note="LIGHT DAY – reduce intensity" elif day_name=="Friday": note="Weekly review: 100 mixed MCQs today" elif day_name=="Saturday": note="Timed MCQ block: 60 Qs in 60 min" clr=pclrs.get(pn,GREY) if day_name=="Sunday": clr="FFD7D7" for ci,v in enumerate([cur.strftime("%a %b %d"),day_name,f"Wk {wk} / {phase_label}",subj,s1,s2,note],1): c=ws2.cell(row=rn,column=ci,value=v) c.fill=fill(clr); c.font=Font(color="000000",size=8.5,name="Arial",bold=(ci<=2 or day_name=="Sunday")) c.alignment=center() if ci<=4 else left(); c.border=border() ws2.row_dimensions[rn].height=44 cur+=timedelta(days=1); rn+=1 ws2.freeze_panes="A4" # ── SHEET 3: MCQ Tracker ───────────────────────────────────── ws3=wb.create_sheet("MCQ Tracker") ws3.merge_cells("A1:H1"); ws3["A1"]="MCQ PRACTICE TRACKER – NRE Step 1" ws3["A1"].fill=fill(DARK_BLUE); ws3["A1"].font=Font(bold=True,color=WHITE,size=13,name="Arial"); ws3["A1"].alignment=center(); ws3.row_dimensions[1].height=28 ws3.merge_cells("A2:H2"); ws3["A2"]="Fill in your daily MCQ scores each evening. The % score is calculated automatically." ws3["A2"].fill=fill(MED_BLUE); ws3["A2"].font=Font(bold=True,color=WHITE,size=10,name="Arial"); ws3["A2"].alignment=center(); ws3.row_dimensions[2].height=18 hdrs3=["Week","Date Range","Subject","Qs Attempted","Qs Correct","% Score","Weak Areas","Action Plan"] w3=[8,20,18,14,14,10,36,36] for i,(h,w) in enumerate(zip(hdrs3,w3),1): c=ws3.cell(row=3,column=i,value=h); c.fill=fill(DARK_BLUE); c.font=font(bold=True,size=10) c.alignment=center(); c.border=border(); ws3.column_dimensions[get_column_letter(i)].width=w ws3.row_dimensions[3].height=24 tdata=[(1,"Jul 13–19","Anatomy"),(2,"Jul 20–26","Physiology"),(3,"Jul 27–Aug 2","Biochemistry"), (4,"Aug 3–9","Pathology"),(5,"Aug 10–16","Pharmacology"),(6,"Aug 17–23","Microbiology"), (7,"Aug 24–30","Behav. Sci."),(8,"Aug 31–Sep 7","Rapid Revision"),(9,"Sep 8–14","Mock Exams"),(10,"Sep 15–20","Final Revision")] tc=["BDD7EE","E2EFDA","FCE4D6","D9E1F2","E2EFDA","FCE4D6","BDD7EE","FFF2CC","FFD7D7","D9F0D3"] for ri,(wk,dr,subj) in enumerate(tdata,4): clr=tc[ri-4] for ci,v in enumerate([wk,dr,subj,"","","","",""],1): c=ws3.cell(row=ri,column=ci,value=v); c.fill=fill(clr) c.font=Font(color="000000",size=10,name="Arial"); c.alignment=center() if ci<=6 else left(); c.border=border() ws3.cell(row=ri,column=6).value=f"=IF(D{ri}>0,E{ri}/D{ri},\"\")" ws3.cell(row=ri,column=6).number_format="0%" ws3.row_dimensions[ri].height=22 # ── SHEET 4: Tips ──────────────────────────────────────────── ws4=wb.create_sheet("Tips & Resources") ws4.column_dimensions["A"].width=24; ws4.column_dimensions["B"].width=72 ws4.merge_cells("A1:B1"); ws4["A1"]="NRE Step 1 – Study Strategy, Tips & Resources" ws4["A1"].fill=fill(DARK_BLUE); ws4["A1"].font=Font(bold=True,color=WHITE,size=13,name="Arial"); ws4["A1"].alignment=center(); ws4.row_dimensions[1].height=28 tips=[ ("DAILY ROUTINE",""), ("Morning Session 1","08:00–10:00 AM – New content: read textbook / First Aid chapter. Make concise notes."), ("Midday Break","10:00 AM–04:00 PM – Meals, rest, short nap. Optional: light flashcard glance only."), ("Evening Session 2","04:00–06:00 PM – Timed MCQs, review wrong answers, update flashcards."), ("Night Wrap-up","15 min before sleep – Skim today's notes. No new content. Sleep 7–8 hrs."), ("",""), ("DAILY MCQ TARGETS",""), ("Anatomy (Wk 1)","50 MCQs/day – Focus: nerves, muscles, anatomical relationships"), ("Physiology (Wk 2)","50 MCQs/day – Focus: equations, graphs, organ system physiology"), ("Biochemistry (Wk 3)","50 MCQs/day – Focus: pathways, enzyme diseases, molecular biology"), ("Pathology (Wk 4)","60 MCQs/day – Focus: Robbins buzzwords, lab findings, cancer biology"), ("Pharmacology (Wk 5)","50 MCQs/day – Focus: MOA, side effects, antidotes, antibiotics"), ("Microbiology (Wk 6)","50 MCQs/day – Focus: gram stain, culture, toxins, serology"), ("Behavioral Sci (Wk 7)","40 MCQs/day – Focus: biostats formulas, ethics scenarios, psychiatry"), ("Rapid Revision (Wk 8)","80 Mixed MCQs/day – All subjects, target weakest areas"), ("Mock Exams (Wk 9)","100 Qs timed mock/day – Strict exam conditions, full review"), ("Final Week (Wk 10)","50 easy MCQs/day – Confidence building only"), ("",""), ("BOOKS & RESOURCES",""), ("First Aid NRE","PRIMARY textbook. Read twice: Phases 1–7, then re-read in Phase 8."), ("Robbins Pathology","Basic Pathology (shorter). Chapters 1–4 (general) + organ systems."), ("BRS Physiology","Best rapid physiology review with built-in MCQs at chapter ends."), ("Lippincott Biochem","Illustrated – metabolism & molecular biology chapters are best."), ("Katzung & Trevor","Pharmacology Q&A review. Excellent MOA tables."), ("Murray Microbiology","Medical Microbiology – use summary tables + gram stain charts."), ("BRS Behavioral Sci.","Concise biostats + ethics + psychiatry. Fast read."), ("",""), ("QUESTION BANKS",""), ("Amboss","Best overall QBank. Use Learning Mode with spaced repetition."), ("Marrow","Good for NRE-specific image-based and clinical MCQs."), ("NREprep.com","Pakistan-specific NRE bank. Use in Phases 9–10."), ("PMDC Past Papers","Download from pmdc.pk. Practice under strict timed conditions."), ("",""), ("KEY REMINDERS",""), ("Sundays","Reduced intensity – 30 MCQs only, rest and recharge."), ("Fridays","Weekly review day – 100 mixed MCQs + identify weak topics."), ("Phase 8 Revision","Do NOT skip First Aid cover-to-cover re-read. It consolidates everything."), ("Final Week","ZERO new topics. Mnemonics, tables, lab values only. Prioritize sleep."), ("Exam Day","Arrive early. Eat a light meal. Trust your preparation."), ] rc=2 for cat,detail in tips: if cat=="" and detail=="": ws4.row_dimensions[rc].height=6; rc+=1; continue is_h=(detail=="") ca=ws4.cell(row=rc,column=1,value=cat); cb=ws4.cell(row=rc,column=2,value=detail) if is_h: ws4.merge_cells(f"A{rc}:B{rc}") ca.fill=fill(MED_BLUE); ca.font=Font(bold=True,color=WHITE,size=11,name="Arial") ca.alignment=left(); ca.border=border(); ws4.row_dimensions[rc].height=22 else: ca.fill=fill(LIGHT_BLUE); ca.font=Font(bold=True,color=DARK_BLUE,size=10,name="Arial") ca.alignment=left(); ca.border=border() cb.fill=fill(GREY); cb.font=Font(color="000000",size=10,name="Arial") cb.alignment=left(); cb.border=border(); ws4.row_dimensions[rc].height=20 rc+=1 out="/home/daytona/nre-schedule/NRE_Step1_Study_Schedule.xlsx" wb.save(out) print(f"SAVED: {out}") EOF
NRE Step1 Study Schedule
Spreadsheet · XLSX
| # | Phase | Dates | Subject | Days |
|---|---|---|---|---|
| 1 | Phase 1 | Jul 13–19 | Anatomy | 7 |
| 2 | Phase 2 | Jul 20–26 | Physiology | 7 |
| 3 | Phase 3 | Jul 27–Aug 2 | Biochemistry | 7 |
| 4 | Phase 4 | Aug 3–9 | Pathology | 7 |
| 5 | Phase 5 | Aug 10–16 | Pharmacology | 7 |
| 6 | Phase 6 | Aug 17–23 | Microbiology | 7 |
| 7 | Phase 7 | Aug 24–30 | Behavioral Sciences & Ethics | 7 |
| 8 | Phase 8 | Aug 31–Sep 7 | Rapid Revision (all subjects) | 8 |
| 9 | Phase 9 | Sep 8–14 | Full Timed Mock Exams | 7 |
| 10 | Phase 10 | Sep 15–20 | Final Light Revision | 6 |
| Time | Session | Activity |
|---|---|---|
| 08:00–10:00 AM | Session 1 (Morning) | New content - read textbook / First Aid chapter, make notes |
| 10:00 AM–4:00 PM | Break | Meals, rest, short nap |
| 04:00–06:00 PM | Session 2 (Evening) | Timed MCQs + review wrong answers + flashcards |
| Night (15 min) | Wrap-up | Skim today's notes only - no new content |