Project Action Tracker Excel | Task, Owner & Deadline Tracker | Priority, Completion, Overdue Executive Dashboard

PROJECT ACTION TRACKER — EXCEL WORKBOOK

Record project actions, owners, priorities, deadlines and blockers, then review workload and upcoming work from linked summaries.

WHAT YOU RECEIVE
One .xlsx workbook with 10 worksheets: Start Here, Action Dashboard, Project Setup, Action Register, Owner Workload, Deadline Planner, Priority Analysis, Escalation Log, Exec Report and Lists.

CAPACITY AND SETUP
196 action rows (5–200), all included in the linked deadline planner and dashboard. Set the reporting date in Project Setup B7 and the due-soon window in B10. Dates use that fixed reporting snapshot, not an automatic daily refresh. Replace fictional examples and maintain unique IDs.

ACTION CALCULATIONS
Days to Due, Overdue, RAG and Escalation are calculated. Complete and Cancelled statuses close these indicators. Missing or invalid dates show Check date. Past-due or Blocked actions are Red/Escalate; due-soon or High/Critical actions are Amber/Watch; other active actions are Green/No. These are illustrative management rules that you should adapt to your workflow.

Completion percentage and Closed Date are manual. Neither changes the action Status automatically. Enter percentages from 0 to 100% and valid Excel dates in 2000–2100. Closed-date example fields are blank for you to complete.

SUMMARIES
Three dashboard charts show status, priority and deadline groups. Owner Workload matches exact names entered in its owner list against the Action Register; add new owners manually. Priority weights for open Critical/High/Medium/Low actions are 4/3/2/1. Workload labels are illustrative and do not measure available working hours.

Deadline Planner is a linked view rather than a second input register. Escalation Log is manually maintained and does not receive automatic entries; its due-status calculation uses Target Resolution and the reporting date. Executive Report combines live counts with space for your own narrative.

IMPORTANT LIMITS
No automated reminders, external integrations or automatic task assignment. Extend formulas and dashboard ranges together before exceeding prepared capacity. This is a project record template, not a compliance or certification assessment.

Designed and checked in desktop Microsoft Excel. Other spreadsheet applications have not been verified. No macros. Digital download only; no physical item is supplied.