IPMAT Excel Tracker Creation

You are to create my IPMAT Excel tracker as a complete .xlsx file with ALL features exactly as described below. Compatible with google sheets too
Do not leave out ANY detail.

Refer to the uploaded planner screenshots/PDFs for:

Exact day-by-day topics for PCM (Class 11 first, then Class 12, based on latest reduced CBSE syllabus available on the internet)

Exact day-by-day topics for IPMAT prep sections (VARC, QA, LRDI, Current Affairs)

Exact placement of mock tests and revision periods

TABS:

Daily Plan:

Columns: Date, Day, PCM Topic, DPP Status, IPMAT Topic, Certificates / Misc, Status (tick / cross / Backlog dropdown), Notes.

DPP Status column dropdown options: Done, Missed, No DPP (default for non-class days).

Pre-fill DPP Status as "No DPP" for all non-class days.

If DPP is missed , auto-shift to next backlog day, count toward DPP backlog meter, and distribute recovery across lighter days that week.

Status column for main task completion: done / missed / Backlog dropdown.

Auto-highlight “Today” row.

Auto-highlight exam weeks in purple.

Overdue alerts: Yellow for normal, Orange for high-priority.

Include "Backlog Sundays" for catch-up work.

Dashboard:

Branding watermark: “IPMAT 2026 – Amogh Bajoria” on all tabs.

% completion meters for PCM, IPMAT, Certificates, and DPP.

Backlog severity meters (flashing red in critical zone) for PCM, IPMAT, Certificates, and DPP.

Weekly Recovery Goal for all backlog types with smart backlog distribution.

Backlog Cleared This Week counters for all backlog types.

Best Backlog Week records with trophy icons and confetti animation.

Milestone tracker with clickable navigation to milestone dates + prep window highlight (2 days before, 2 days after).

Quick Jump navigation (month/week) with auto-highlight.

This Week’s Focus (clickable to jump to relevant week in Daily Plan).

Workload intensity meter.

Motivational quote of the week.

Freshness indicator (traffic light for last update).

Mock Tracker:

Columns: Date, Mock/Test Name, Type, Section Scores (VARC, QA, LRDI), Total Score, Percentile, Rank, Analysis Notes.

Countdown:

Automatic day countdown to IPMAT Indore, IPMAT Rohtak, JIPMAT.

Updates daily.

Weekly Notes:

Space for reflections, learning notes, backlog action items.

DPP SYSTEM:

DPP assigned only on class days.

“No DPP” auto-filled on non-class days.

Missed DPP triggers DPP backlog recovery like PCM backlog:

Backlog severity meter for DPP.

Weekly recovery goal for DPP.

Best backlog week record for DPP with trophy/confetti.

DPP Backlog Cleared This Week counter.

DPP auto-shifts missed work into lighter upcoming class days.

AUTOMATION & FORMATTING:

Backlog auto-shifting for PCM, IPMAT, Certificates, and DPP.

Smart backlog distribution across available days.

Exam week purple highlighting.

Today auto-highlight.

Alternate row shading + calendar borders.

Conditional formatting for workload levels.

Navigation buttons: Go to Today, Go to Next Milestone, Quick Jump to month/week.

INTERACTIVITY:

Clickable dashboard widgets jump to relevant rows in Daily Plan.

Prep window auto-highlight for milestones.

PDF DELIVERABLES AFTER EXCEL:

Quick Guide (PDF):

Step-by-step instructions for using all tracker features.

How to update progress, use dashboard, understand backlog meters, recover backlog, navigate, read workload meter, interpret milestones.

DPP tracking explained.

Backlog automation explained.

Weekly maintenance tips.

One-Page Visual Cheat Sheet (PDF):

Color-coded quick reference.

Navigation button guide.

Dashboard meter explanations.

Status icon meanings.

Weekly focus.

Backlog recovery process.

Milestone prep window meaning.

DPP tracking quick reference.

FINAL REQUIREMENTS:

File name: IPMAT_Tracker.xlsx

Maintain exact branding and formatting discussed.

Use uploaded planner screenshots/PDFs to pre-fill exact daily topics in the Daily Plan.

Send .xlsx file to download once complete, then follow with the two PDF deliverables.