To Do List
Troubleshooting:
***IMPORTANT NOTE: This is the Excel version of the file meant for Excel only. For the Google Shees version please cl
https://docs.google.com/spreadsheets/d/1lGCxvRSSa_wEdxwLqvlcaK5usEZTCPQU94xpngr9gQY/edit?usp=sharing
***If you are seeing #NAME? or #VALUE? in the spreadsheet this means that you have an older version of Excel that
does not support filter and sort functions. To fix this issue you will need to either update your Excel or use the Google
Sheets version. To use the Google Sheets version, please click on this link:
https://docs.google.com/spreadsheets/d/1lGCxvRSSa_wEdxwLqvlcaK5usEZTCPQU94xpngr9gQY/edit?usp=sharing
***If you are seeing ##### in certain cells, you will need to adjust the column width by right clicking on the tab at the
bottom and clicking Unprotect Sheet... You will then be able to adjust the column width.
***If the charts are overlapping each other, you will need to adjust their size by clicking on them then using the corners
to resize them.
1. Setup
-Go to setup
-The information you enter here will update the dropdown lists
throughout the workbook.
2. Assignment Tracker
- Go to the 'To Do List' tab
- Enter all of the tasks that you need or want to accomplish.
- You can use the to do list as a Brain Dump
- Once you have entered your task you can sort it by
category, priority and status
- Enter duration and due date
- Choose the person that will be accomplishing the task
- Enter notes about the task if needed
Sort function
- Use the sort function to categorize your tasks how you want them.
3. Daily Planner
- Go to the 'Daily Planner' tab
- Choose the Week you wish to plan for. This will
highlight the days for that week in the mini calendar.
- Enter the Year and Month by selecting them from the
drop down menu.
- Enter the Start of your day
- Select if you would like the planner to start on
Monday or Sunday.
- Beside the time use the Drop Down to select the task
you want to accomplish
**** You can Duplicate the Daily Planner tab in order to
plan for several weeks at a time.
This can be done by Right Clicking on the Daily
Planner tab at the bottom, then selecting "Move or
Copy"
In the menu, Select the Create a copy checkbox then
click ok.
4. Monthly Calendar
- Go to the 'Monthly Calendar' tab
- Choose the Month and enter the Year
- Use the Drop Down to select the tasks you want to accomplish each day
- You can enter a maximum of 7 tasks per day
- Use the check boxes once you have completed the
Task
ogle Shees version please click on this link:
ngr9gQY/edit?usp=sharing
older version of Excel that
r Excel or use the Google
ngr9gQY/edit?usp=sharing
clicking on the tab at the
hem then using the corners
Setup
Category Priority Status
Personal Urgent Not Started
Home High In-Progress
Cleaning Medium Cancelled
Organization Low Complete
work Overdue
Business
Learning
School
Pets
Kids
Holidays
Gardening
Food
Travel
Wellness
Meals
Person
Person 1
Person 2
Person 3
Person 4
Person 5
Person 6
Person 7
Person 8
Total Tasks: Completed:
To Do List 6 3
Date: January 24, 2025
Tasks Per Category
Status #NAME? #NAME?
12 #NAME? #NAME?
10 #NAME? #NAME?
8
6
4
2
0
#NAME? #NAME? #NAME?
#NAME?
# x Task Category Priority Status Duration
### 1 x Task 1 Personal Urgent Overdue 1 hour
2 x Task 2 Home High In-Progress
3 x Task 3 Cleaning Medium Cancelled
4 Task 4 Organization Low Complete
5 Task 5 work Urgent Overdue
6 Task 6 Business High
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
To do: Overdue:
3 2
Progress
Priority
12
AME? #NAME?
10
AME? #NAME?
AME? #NAME? 8 3 50% 3
#NAME? #NAME? #NAME? #NAME?
Due Date Days Left Person Notes
Oct 1, 2023 Person 1
Oct 2, 2023
Oct 3, 2023
Oct 4, 2023
Oct 5, 2023 -477
Oct 6, 2023 -476
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
Monday, September 25 Tuesday, September 26
Daily Planner
Time Task Time Task
5:32 AM 7:00 AM 7:00 AM
7:30 AM 7:30 AM
Oct Week 1 8:00 AM 8:00 AM
1 2 3 4 5 6 7 8 8:30 AM 8:30 AM
October 2023 9:00 AM 9:00 AM
M T W T F S S 9:30 AM 9:30 AM
25 26 27 28 29 30 01 10:00 AM 10:00 AM
02 03 04 05 06 07 08 10:30 AM 10:30 AM
09 10 11 12 13 14 15 11:00 AM 11:00 AM
16 17 18 19 20 21 22 11:30 AM 11:30 AM
23 24 25 26 27 28 29 12:00 PM 12:00 PM
30 31 01 02 03 04 05 12:30 PM 12:30 PM
1:00 PM 1:00 PM
Year 2023 1:30 PM 1:30 PM
Month October 2:00 PM 2:00 PM
Day Start 7:00 AM 2:30 PM 2:30 PM
3:00 PM 3:00 PM
Monday / Sunday Start 3:30 PM 3:30 PM
Monday 4:00 PM 4:00 PM
4:30 PM 4:30 PM
Reminders 5:00 PM 5:00 PM
###
✘ 5:30 PM 5:30 PM
✘ 6:00 PM 6:00 PM
✘ 6:30 PM 6:30 PM
✘ 7:00 PM 7:00 PM
✘ 7:30 PM 7:30 PM
✘ 8:00 PM 8:00 PM
✘ 8:30 PM 8:30 PM
✘ 9:00 PM 9:00 PM
✘ 9:30 PM 9:30 PM
✘ 10:00 PM 10:00 PM
✘ 10:30 PM 10:30 PM
✘ 11:00 PM 11:00 PM
✘ 11:30 PM 11:30 PM
✘ 12:00 AM 12:00 AM
✘ 12:30 AM 12:30 AM
✘ 1:00 AM 1:00 AM
✘ 1:30 AM 1:30 AM
✘ 2:00 AM 2:00 AM
✘ 2:30 AM 2:30 AM
✘ 3:00 AM 3:00 AM
✘ 3:30 AM 3:30 AM
✘ 4:00 AM 4:00 AM
✘ 4:30 AM 4:30 AM
✘ 5:00 AM 5:00 AM
✘ 5:30 AM 5:30 AM
✘ 6:00 AM 6:00 AM
✘ 6:30 AM 6:30 AM
✘
Wednesday, September 27 Thursday, September 28 Friday, September 29
Time Task Time Task Time
7:00 AM 7:00 AM 7:00 AM
7:30 AM 7:30 AM 7:30 AM
8:00 AM 8:00 AM 8:00 AM
8:30 AM 8:30 AM 8:30 AM
9:00 AM 9:00 AM 9:00 AM
9:30 AM 9:30 AM 9:30 AM
10:00 AM 10:00 AM 10:00 AM
10:30 AM 10:30 AM 10:30 AM
11:00 AM 11:00 AM 11:00 AM
11:30 AM 11:30 AM 11:30 AM
12:00 PM 12:00 PM 12:00 PM
12:30 PM 12:30 PM 12:30 PM
1:00 PM 1:00 PM 1:00 PM
1:30 PM 1:30 PM 1:30 PM
2:00 PM 2:00 PM 2:00 PM
2:30 PM 2:30 PM 2:30 PM
3:00 PM 3:00 PM 3:00 PM
3:30 PM 3:30 PM 3:30 PM
4:00 PM 4:00 PM 4:00 PM
4:30 PM 4:30 PM 4:30 PM
5:00 PM 5:00 PM 5:00 PM
5:30 PM 5:30 PM 5:30 PM
6:00 PM 6:00 PM 6:00 PM
6:30 PM 6:30 PM 6:30 PM
7:00 PM 7:00 PM 7:00 PM
7:30 PM 7:30 PM 7:30 PM
8:00 PM 8:00 PM 8:00 PM
8:30 PM 8:30 PM 8:30 PM
9:00 PM 9:00 PM 9:00 PM
9:30 PM 9:30 PM 9:30 PM
10:00 PM 10:00 PM 10:00 PM
10:30 PM 10:30 PM 10:30 PM
11:00 PM 11:00 PM 11:00 PM
11:30 PM 11:30 PM 11:30 PM
12:00 AM 12:00 AM 12:00 AM
12:30 AM 12:30 AM 12:30 AM
1:00 AM 1:00 AM 1:00 AM
1:30 AM 1:30 AM 1:30 AM
2:00 AM 2:00 AM 2:00 AM
2:30 AM 2:30 AM 2:30 AM
3:00 AM 3:00 AM 3:00 AM
3:30 AM 3:30 AM 3:30 AM
4:00 AM 4:00 AM 4:00 AM
4:30 AM 4:30 AM 4:30 AM
5:00 AM 5:00 AM 5:00 AM
5:30 AM 5:30 AM 5:30 AM
6:00 AM 6:00 AM 6:00 AM
6:30 AM 6:30 AM 6:30 AM
Friday, September 29 Saturday, September 30 Sunday, October 1
Task Time Task Time Task
7:00 AM 7:00 AM
7:30 AM 7:30 AM
8:00 AM 8:00 AM
8:30 AM 8:30 AM
9:00 AM 9:00 AM
9:30 AM 9:30 AM
10:00 AM 10:00 AM
10:30 AM 10:30 AM
11:00 AM 11:00 AM
11:30 AM 11:30 AM
12:00 PM 12:00 PM
12:30 PM 12:30 PM
1:00 PM 1:00 PM
1:30 PM 1:30 PM
2:00 PM 2:00 PM
2:30 PM 2:30 PM
3:00 PM 3:00 PM
3:30 PM 3:30 PM
4:00 PM 4:00 PM
4:30 PM 4:30 PM
5:00 PM 5:00 PM
5:30 PM 5:30 PM
6:00 PM 6:00 PM
6:30 PM 6:30 PM
7:00 PM 7:00 PM
7:30 PM 7:30 PM
8:00 PM 8:00 PM
8:30 PM 8:30 PM
9:00 PM 9:00 PM
9:30 PM 9:30 PM
10:00 PM 10:00 PM
10:30 PM 10:30 PM
11:00 PM 11:00 PM
11:30 PM 11:30 PM
12:00 AM 12:00 AM
12:30 AM 12:30 AM
1:00 AM 1:00 AM
1:30 AM 1:30 AM
2:00 AM 2:00 AM
2:30 AM 2:30 AM
3:00 AM 3:00 AM
3:30 AM 3:30 AM
4:00 AM 4:00 AM
4:30 AM 4:30 AM
5:00 AM 5:00 AM
5:30 AM 5:30 AM
6:00 AM 6:00 AM
6:30 AM 6:30 AM
October2023 1 ### 12 AM 12 AM 12 AM 12 AM 12 AM ###
1
October 2023
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
✘0 1 ### 2 ### 3 ### 4 ### 5 ### 6 ### 7
### ### ### ✘ ✘ ✘ ✘
### ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
### 8 ### 9 ✘ 10### 11### 12### 13 ✘ 14
✘ ✘ ✘ ### ### ✘ ✘
✘ ✘ ✘ ✘ ### ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 15### 16### 17### 18### 19### 20### 21
✘ ### ### ### ### ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ### ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 22 ✘ 23 ✘ 24 ✘ 25### 26 ✘ 27 ✘ 28
✘ ✘ ### ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 29 ✘ 30 ✘ 31 ✘ 1 ✘ 2 ### 3 ✘ 4
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 5 ✘ 6 ✘ 7 ✘ 8 ✘ 9 ✘ 10 ✘ 11
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ### ✘ ✘ ✘ ✘
January2023 1 12 AM 1 12 AM 12 AM 12 AM 12 AM 12 AM ###
1
January 2023
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
✘ 1### 2 ✘ 3 ✘ 4✘ 5 ✘ 6 ✘ 7
✘ ### ✘ ✘ ### ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 8### 9 ✘ 10### 11### 12### 13 ✘ 14
✘ ✘ ✘ ### ✘ ✘ ✘
✘ ✘ ✘ ✘ ### ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 15### 16 ✘ 17### 18 ✘ 19### 20 ✘ 21
✘ ### ✘ ### ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ### ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 22 ✘ 23 ✘ 24 ✘ 25### 26 ✘ 27 ✘ 28
✘ ✘ ### ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 29 ✘ 30 ✘ 31 ✘ 1 ✘ 2### 3 ✘ 4
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ 5 ✘ 6 ✘ 7 ✘ 8 ✘ 9 ✘ 10 ✘ 11
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ✘ ✘ ✘ ✘ ✘
✘ ✘ ### ✘ ✘ ✘ ✘
