Project Management Template for Excel, Automatic Gantt Chart, RAID Log, Dashboard

Seller's description

Plan a project in working days and let the Gantt chart draw itself.

Type your tasks, link each one to the task that must finish first, and the start and end dates, Gantt bars, status, resource load and dashboard all update by themselves. Weekends and your holidays are skipped.

WHAT IT DOES
- Type tasks with a duration in working days; start and end dates are calculated
- Real dependencies: finish-to-start links to the task that must finish first, with lag or overlap
- Working week of your choice (Mon-Fri, Mon-Sat, Sun-Thu, Sat-Wed or 7 days) and your own holiday list, for any country
- Automatic Gantt chart: day or week view, % done shading, milestones, today line, shaded non-working days
- Status updates itself: Done, On track, Behind, Overdue, Not started, compared with the plan on your status date
- Phases roll up dates and % done from their tasks
- RAID log: risks, assumptions, issues and dependencies with probability x impact scoring and overdue flags
- Resource load: work days per person per week and % of their capacity, red when overloaded
- One-page dashboard: actual vs planned progress, overdue tasks, upcoming milestones, phase progress, open risks, charts

WHAT'S INSIDE
- Project-Planner-Gantt-Template.xlsx: filled example (a 4-phase website relaunch, 20 tasks and milestones, 6 people)
- Project-Planner-Gantt-Template-Blank.xlsx: the same workbook, empty, for your project
- Project-Planner-Quick-Start-Guide.pdf: 4 pages
Tabs: Instructions, Setup, Tasks (150 rows), Gantt (70 days or weeks), RAID log (80 rows), Resource load (12 people x 20 weeks), Dashboard

WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice.
No macros, no add-ins. Formula cells are protected without a password, so you can't break them by accident, and you can still unlock them. Best edited on a computer; phone apps can view.

GOOD TO KNOW
- Instant digital download: a .zip with the filled example, a blank copy and a PDF guide. Nothing is shipped.
- Licence: for your own use and use inside your own business. Please do not resell or share the files.
- A problem opening the file? Message us and we'll help.
- Planning aid only: check dates, durations and resources with your team. No warranty of fitness for any purpose.

HOW THIS WAS MADE
We designed these workbooks and wrote the formulas, guide text and the scripts that build the files with the help of AI tools. Scripts recalculated each file in LibreOffice and compared it with a separate Python calculation across 7 test cases, including edge cases. The listing photos are real screenshots of the files (no AI-generated images).