I find this template quite simple, yet powerful. Examine the formulas in hidden column to understand this better. Download this todo list templateĬlick here to download this template and chase that todo list in style. Read weighted averages in Excel to understand more. A mapping table telling us how much each priority weighs.That means the weight enjoyed by priority 1 task is twice that of priority 2 task. In this approach, we are assuming that doing one priority 1 task gives same output (%done) as doing two priority 2 tasks, three priority 3 tasks etc. The total of this column gives us how much % of all tasks are done. For this, we just need to multiply 100% weights with TRUE or FALSE values. Now, we just use TRUE / FALSE values generated by the check boxes to calculate % done. Step 3: Calculate % done only if a task is marked as done To do this, we just divide a task’s weight by total of all task weights. Next, we adjust the weights so that their total is 100%. This is a simple job of inverting priority values (1/priority value). To understand this problem, lets imagine, we have 5 tasks & priorities like below:įirst step is to calculate how much weight each task should get. Calculating % completion based on priorities: Since first 4 items are already explained on, let me focus on the formula part. Formulas – to calculate % done based on how many activities are done & their priorities.Thermo-meter chart – to show the progress as you mark each activity done.Conditional Formatting – to highlight a row when the activity is marked as done.Data validation – to assign priority (1 to 5) to each activity.Check boxes – to mark each activity as done (or not done).The basic components of this todo list are,

Pretty neat eh?!? Personal Todo list with Priorities – Demo With his new version, progress is measured based on how much priority we assigned that particular task. As you finish each task, you can see overall progress too. The original template had tasks and completion check marks. During last week, Peppe, one of our readers from Italy, took this template and made it even more awesome. This was a hit with our readers with thousands of you downloading it. A while ago, we published a new year resolution template.

To do list sheet