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.
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.
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.
Dates that matter, days away (red when past, yellow within two weeks), and how many tasks in the milestone's phase are done.
Timeline start, today's date (fixed or =TODAY()), statuses and owners as named ranges.
Twelve formulas explained, including the three conditional-format rules that draw the bars.
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.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
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.
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 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.
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.
First release
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.
Names down the side, days across, one letter per cell — P, A, L, E, H — from a dropdown, coloured. Counts per person, attendance % that counts Late as present and leaves holidays out, present per day, weekends shaded. Pro adds a Summary with bars and flags, holidays from Setup, and a formulas walkthrough. No macros.
An expense log for Excel and Google Sheets that totals itself: this month by category with data bars, twelve months back, and spending against the limits you set — every formula visible. Pro adds the Monthly and Limits sheets, a Setup sheet with limits, and a formulas walkthrough.