project_schedule_by_planyway.xlsx

	B	D
1
2
3	Project Schedule Template
4	A structured task list with dates, owners, and dependencies. No Gantt bars — just clear, sortable, searchable schedule data.
5
6	To download an Excel file, go to File —> Download —> Microsoft Excel
7
8	What this template does	Schedule vs Timeline
9	Lists every task with a start date, due date, owner, and phase.	Use this template when you want structured data: who does what, by when.
10	Shows dependencies as plain text (e.g. "T-003, T-005") so you know what to unblock first.	Use the Project Timeline template when you want a visual Gantt chart.
11	Colour-coded by status: Done / In Progress / Not started / At risk.	Both cover the same project — different angles for different audiences.
12	Summary section at the top shows overall progress and counts by phase.	Share the Schedule with the team. Share the Timeline with stakeholders.
13	Sortable by any column — filter by owner, phase, or due date.
14
15	How to fill it in	How to use dependencies
16	1. One row per task. Fill in Phase, Task, Owner, Start date, Due date.	The Depends on column lists task IDs that must be completed before this task can start.
17	2. Add Dependencies as task IDs (e.g. "T-001, T-004"). This tells you what must finish before this task can start.	If a task is blocked, check its dependencies first — something upstream is probably not done.
18	3. Update Status as work progresses. The row colour updates automatically.	Critical path: tasks where a delay causes a delay to the final delivery date.
19	4. Add notes for blockers, context, or decisions.	Mark critical path tasks with "Critical path" in the Notes column.
20
21	Summary section	Tips for keeping it up to date
22	The summary at the top of the Schedule tab shows: total tasks, done, in progress, not started, overdue.	Update once a week — 10 minutes before standup.
23	It uses COUNTIF formulas — updates automatically as you change status.	If a due date changes, update it here and in your project tool.
24	Use it as a quick health check at the start of every standup.	When a task is done: change status to Done. Date it in the Notes column.
25		If a task is blocked: change status to At risk. Add the blocker to Notes.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100