foldout
Free + Pro 5-sheet workbook no macros

Stride — project tracker spreadsheet with Gantt chart

A task list with a Gantt chart drawn entirely by conditional formatting — no shapes, no macros. Start and end dates make the bar, Done % fills it, Blocked turns it red, a line marks this week. Pro adds a 26-week timeline, a Dashboard, Milestones and a formulas walkthrough.

  • XLSX
  • No macros
  • Gantt
  • Conditional formatting
  • Google Sheets

The sheets

  1. 01
    Tasks

    Phase, task, owner, start, end, status, done %. Days and days left calculated. Gantt: light for planned, solid for the done share, red for blocked, a red line on this week. 12 weeks free, 26 in Pro.

    Free + Pro
  2. 02
    Dashboard

    Tasks by status, overdue, due in the next 7 days, blocked, overall progress weighted by task length, project end, and open tasks and days of work left per owner.

    Pro
  3. 03
    Milestones

    Dates that matter, days away (red when past, yellow within two weeks), and how many tasks in the milestone's phase are done.

    Pro
  4. 04
    Setup

    Timeline start, today's date (fixed or =TODAY()), statuses and owners as named ranges.

    Pro
  5. 05
    Formulas

    Twelve formulas explained, including the three conditional-format rules that draw the bars.

    Pro

Built for

  • Excel 2016+
  • Google Sheets
  • Numbers

Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.

What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.

Pro

$5

Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.

Tasks with Gantt
26 weeks
Owner dropdown from Setup
yes
Dashboard
yes
Milestones
yes
Formulas walkthrough sheet
yes
Credit line on the sheet
not required
Updates and support
12 months, email

Licence

Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.

Full licence terms →

A Gantt chart you can actually edit

Most Gantt templates are shapes on a grid, or a macro that redraws them. Change a date and the bar doesn’t move. Stride’s bars are conditional formatting: each week column tests whether its week overlaps the task’s dates, and shades itself if so. Change the date, the bar moves. Type 40% in Done and the first 40% of the bar goes solid. Set the status to Blocked and it turns red. There is a red line on the column that contains today.

Pro: where the project stands, in numbers

The Dashboard counts tasks by status, flags anything past its end date, lists what’s due in the next week, and gives an overall progress figure weighted by task length — so a three-week task counts three times a one-week one. Per owner: open tasks and the days of work left in them. Milestones shows the dates that matter, how far away they are, and how much of the phase behind each is done.

The three rules, written down

The Formulas sheet shows the exact conditional-format formulas that draw the planned bar, the done bar and the blocked bar, and explains the “progress front” arithmetic. Extend the timeline by copying the last week column; the rules come with it.

Checked, not just built

The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample plan and compares fifteen values — durations, days left, status counts, weighted progress, per-owner load — against numbers computed outside Excel.

Free download

  • stride.xlsx · Tasks sheet
  • README.md · LICENCE.txt

Pro download

  • stride-pro.xlsx · Tasks, Dashboard, Milestones,
  • Setup, Formulas
  • README.md · LICENCE.txt (Pro)

Read before you build

Version history

  • 1.0.02026-09-11

    First release

  • 0
    shapes or macros in the Gantt
  • 3
    conditional-format rules draw it
  • 15
    checks the build runs
  • 26
    weeks in Pro

Related spreadsheets

Tick — task checklist spreadsheet preview

A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.

  • XLSX
  • No macros
  • COUNTIFS
live demo →
Vow — wedding planner spreadsheet preview

A wedding budget by category — estimated, actual, paid — with what's still to pay, over or under, and the honest budget left. Pro adds vendors with quotes, contracts, deposits and balance-due flags that feed the actuals, and a timeline whose dates follow the wedding date. No macros.

  • XLSX
  • No macros
  • SUMIF
live demo →
Invite — guest list and event planner spreadsheet preview

One row per invitation: adults and kids, RSVP, meal, table, gift and thank-you. Invited, responded, coming, meals per choice and what's missing for each Yes are counted. Pro adds tables with free seats, a budget with cost per head, and a timeline of tasks with what's late. No macros.

  • XLSX
  • No macros
  • SUMIFS
live demo →

Tell us what happened

Goes straight to a person. No account, no ticket number.

What is this about?

We keep the message and the page it came from. Nothing else — not your IP, not your browser. Privacy.