{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Prioritization_Criteria","Task_List","Summary_of_Priorities","Lists"],"not_rendered":{"images":1,"macros":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Prioritization_Criteria","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[2,1,2,7],[4,1,4,2],[6,5,25,5],[6,7,25,7]]}
[]
[null,"Introduction to this Tool"]
[null,"Welcome! This tool is different from a standard to-do list. It’s not just for managing tasks; it’s for clarifying your thinking around how and why you prioritize some tasks over others. The goal is to help you build a personal, repeatable system for making smart decisions, so you can focus on what truly matters from day-to-day.\n\nThink of this process in four phases: defining your values, Aligning this criteria to your specific tasks, and then reflect on what you truly see as a priority, did you complete it and why or why not. Lastly there are a few reflection questions to help you create 1-3 actions you will implement to increase productivity and enhance your feeling of accomlishment at the end of the day."]
[null,"Step 1",{"$nulls":3},"Step 2",null,"Step 3"]
[null,"Before you can prioritize tasks, you must first understand the \"rules\" you use to judge them. We all have these rules, but they are often hidden and subconscious. This step is about making them visible. When your decision-making criteria are clear, you are more equipt to avoid distractions and other people's \"urgent\" requests.\n\nIn the spaces below, list everything you consider when you decide what to work on. Place the most importat criteria to you, your job or your organization at top in Rank #1, and rank each criteria down the list. It is recommended that you come up with at least 7-10 criteria, and this tool caps this step at 20 because I think most of us could go on forever about all the nuances to these criteria that must be considered when prioritizing our day-to-day.\n\nTo help your thinking, consider these areas:\n\nValue: Does this make money? Does it make a key customer happy? Does it improve our reputation?\n\nEffort: How much time will this take? How much stress or complexity is involved? Does it require resources we don't have?\n\nStrategy: Does this align with our main goal for the quarter? Will I learn a valuable new skill? Does it reduce future problems (like technical debt)?\n\nConstraints: Is there a hard deadline? Is this blocking someone else's work? Is there a budget?",{"$nulls":3},"Think about your own personal values that come into play in how you make decisions and prioritize things. Often times its our desire to be seen as someone who is trusted, who comes through on commitments, who is ethical or who is fiscally responsible. What are the things that, if you chose to prioritize something that went against them, you would feel that you let your self down or comprimised your personal values?",null,"Last step for phase one of this exercise is to list out those things that you know will come up that are pure distraction from your tasks at hand OR that you know about yourself that might derail you from being as productive as you might like.\n\nExample Distration - I work at home and sometimes my dog won't stop barking when people walk by the house. I have to constantly break my train of thought to get her to stop.\n\nExample Derailer - I hate writing customer reports summarizing project progress. I often procrastinate on doing this until the last minute and I only just barely get them done in time.\n\nWhen you have completed all three steps on this page, click on the \"Phase 2 - Create a Task List\" button."]
[null,"Rank","Prioritization Criteria","Weight",null,"What Are Your Non-Negotiables",null,"What Are Your Potential Distractions or Derailers?"]
[null,1,null,20]
[null,2,null,19]
[null,3,null,18]
[null,4,null,17]
[null,5,null,16]
[null,6,null,15]
[null,7,null,14]
[null,8,null,13]
[null,9,null,12]
[null,10,null,11]
[null,11,null,10]
[null,12,null,9]
[null,13,null,8]
[null,14,null,7]
[null,15,null,6]
[null,16,null,5]
[null,17,null,4]
[null,18,null,3]
[null,19,null,2]
[null,20,null,1]

{"sheet":"Task_List","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"merged":[[0,3,0,5],[2,1,2,7]]}
[{"$nulls":3},"Prioritization Tool"]
[null,"Phase 2"]
[null,"For phase 2, thinking about your day today, or any recent work day, list out all of the work tasks that you had to accomplish. These can be planned (i.e., you had them on your calendar or a to do list), or unplanned (i.e., someone came to you with something and you chose to work on it in the moment or at some point in the day). These can be things you started, but didn't complete or things you planned to do, but never got to during this one day. These can be captured in any order. Simply brainstorm them on the page and ensure you feel like the list is reflective of your day. The list stops at 20 because there is, like most of us, this list could go on forever if we thought about it long enough.\n\nFor each task, select the top 3 prioritization criteria that are most relevant to it from the dropdown lists generated by what you entered on the previous page. Every task may not have 3. It is OK to have 2 or even 1. It's about identifying the primary drivers for why a task is on your list in the first place. Is this task mostly about satisfying a key customer? Or is it primarily about hitting a strategic goal? If the primary driver is not in your list, you can always go back and add it on the previous page, but consider why that driver didn't occur to you in the first place before just adding something.\n\nClick on the \"Submit & Summarize button when you have complete yourt ask list."]
[null,"Task","Is This Task Typically Planned or Unplanned?","Prioritization Criteria #1","Criteria 1 Weight","Prioritization Criteria #2","Criteria 2 Weight","Prioritization Criteria #3","Criteria 3 Weight","Total Weight"]
[null,"Task 1",null,null,{"$f":"IF(ISBLANK(D5), \"\", _xlfn.XLOOKUP(D5, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F5), \"\", _xlfn.XLOOKUP(F5, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H5), \"\", _xlfn.XLOOKUP(H5, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E5), \" \",SUM(E5,G5,I5))","v":0}]
[null,"Task 2",null,null,{"$f":"IF(ISBLANK(D6), \"\", _xlfn.XLOOKUP(D6, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F6), \"\", _xlfn.XLOOKUP(F6, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H6), \"\", _xlfn.XLOOKUP(H6, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E6), \" \",SUM(E6,G6,I6))","v":0}]
[null,"Task 3",null,null,{"$f":"IF(ISBLANK(D7), \"\", _xlfn.XLOOKUP(D7, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F7), \"\", _xlfn.XLOOKUP(F7, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H7), \"\", _xlfn.XLOOKUP(H7, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E7),\" \",SUM(E7,G7,I7))","v":0}]
[null,"Task 4",null,null,{"$f":"IF(ISBLANK(D8), \"\", _xlfn.XLOOKUP(D8, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F8), \"\", _xlfn.XLOOKUP(F8, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H8), \"\", _xlfn.XLOOKUP(H8, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E8),\" \",SUM(E8,G8,I8))","v":0}]
[null,"Task 5",null,null,{"$f":"IF(ISBLANK(D9), \"\", _xlfn.XLOOKUP(D9, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F9), \"\", _xlfn.XLOOKUP(F9, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H9), \"\", _xlfn.XLOOKUP(H9, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E9),\" \",SUM(E9,G9,I9))","v":0}]
[null,"Task 6",null,null,{"$f":"IF(ISBLANK(D10), \"\", _xlfn.XLOOKUP(D10, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F10), \"\", _xlfn.XLOOKUP(F10, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H10), \"\", _xlfn.XLOOKUP(H10, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E10),\" \",SUM(E10,G10,I10))","v":0}]
[null,"Task 7",null,null,{"$f":"IF(ISBLANK(D11), \"\", _xlfn.XLOOKUP(D11, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F11), \"\", _xlfn.XLOOKUP(F11, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H11), \"\", _xlfn.XLOOKUP(H11, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E11),\" \",SUM(E11,G11,I11))","v":0}]
[null,"Task 8",null,null,{"$f":"IF(ISBLANK(D12), \"\", _xlfn.XLOOKUP(D12, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F12), \"\", _xlfn.XLOOKUP(F12, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H12), \"\", _xlfn.XLOOKUP(H12, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E12),\" \",SUM(E12,G12,I12))","v":0}]
[null,"Task 9",null,null,{"$f":"IF(ISBLANK(D13), \"\", _xlfn.XLOOKUP(D13, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F13), \"\", _xlfn.XLOOKUP(F13, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H13), \"\", _xlfn.XLOOKUP(H13, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E13),\" \",SUM(E13,G13,I13))","v":0}]
[null,"Task 10",null,null,{"$f":"IF(ISBLANK(D14), \"\", _xlfn.XLOOKUP(D14, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F14), \"\", _xlfn.XLOOKUP(F14, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H14), \"\", _xlfn.XLOOKUP(H14, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E14),\" \",SUM(E14,G14,I14))","v":0}]
[null,"Task 11",null,null,{"$f":"IF(ISBLANK(D15), \"\", _xlfn.XLOOKUP(D15, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F15), \"\", _xlfn.XLOOKUP(F15, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H15), \"\", _xlfn.XLOOKUP(H15, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E15),\" \",SUM(E15,G15,I15))","v":0}]
[null,"Task 12",null,null,{"$f":"IF(ISBLANK(D16), \"\", _xlfn.XLOOKUP(D16, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F16), \"\", _xlfn.XLOOKUP(F16, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H16), \"\", _xlfn.XLOOKUP(H16, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E16),\" \",SUM(E16,G16,I16))","v":0}]
[null,"Task 13",null,null,{"$f":"IF(ISBLANK(D17), \"\", _xlfn.XLOOKUP(D17, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F17), \"\", _xlfn.XLOOKUP(F17, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H17), \"\", _xlfn.XLOOKUP(H17, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E17),\" \",SUM(E17,G17,I17))","v":0}]
[null,"Task 14",null,null,{"$f":"IF(ISBLANK(D18), \"\", _xlfn.XLOOKUP(D18, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F18), \"\", _xlfn.XLOOKUP(F18, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H18), \"\", _xlfn.XLOOKUP(H18, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E18),\" \",SUM(E18,G18,I18))","v":0}]
[null,"Task 15",null,null,{"$f":"IF(ISBLANK(D19), \"\", _xlfn.XLOOKUP(D19, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F19), \"\", _xlfn.XLOOKUP(F19, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H19), \"\", _xlfn.XLOOKUP(H19, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E19),\" \",SUM(E19,G19,I19))","v":0}]
[null,"Task 16",null,null,{"$f":"IF(ISBLANK(D20), \"\", _xlfn.XLOOKUP(D20, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F20), \"\", _xlfn.XLOOKUP(F20, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H20), \"\", _xlfn.XLOOKUP(H20, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E20),\" \",SUM(E20,G20,I20))","v":0}]
[null,"Task 17",null,null,{"$f":"IF(ISBLANK(D21), \"\", _xlfn.XLOOKUP(D21, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F21), \"\", _xlfn.XLOOKUP(F21, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H21), \"\", _xlfn.XLOOKUP(H21, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E21),\" \",SUM(E21,G21,I21))","v":0}]
[null,"Task 18",null,null,{"$f":"IF(ISBLANK(D22), \"\", _xlfn.XLOOKUP(D22, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F22), \"\", _xlfn.XLOOKUP(F22, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H22), \"\", _xlfn.XLOOKUP(H22, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E22),\" \",SUM(E22,G22,I22))","v":0}]
[null,"Task 19",null,null,{"$f":"IF(ISBLANK(D23), \"\", _xlfn.XLOOKUP(D23, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F23), \"\", _xlfn.XLOOKUP(F23, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H23), \"\", _xlfn.XLOOKUP(H23, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E23),\" \",SUM(E23,G23,I23))","v":0}]
[null,"Task 20",null,null,{"$f":"IF(ISBLANK(D24), \"\", _xlfn.XLOOKUP(D24, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(F24), \"\", _xlfn.XLOOKUP(F24, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},null,{"$f":"IF(ISBLANK(H24), \"\", _xlfn.XLOOKUP(H24, Prioritization_Criteria!$C$7:$C$26, Prioritization_Criteria!$D$7:$D$26))","v":""},{"$f":"IF(ISBLANK(E24),\" \",SUM(E24,G24,I24))","v":0}]

{"sheet":"Summary_of_Priorities","index":2,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[0,4,0,5],[2,1,2,9],[4,7,23,7],[4,9,23,9],[25,1,25,9],[27,1,27,4],[28,1,28,4],[30,1,30,4],[31,1,31,4]]}
[]
[null,"Phase 3"]
[null,"Below you will see a list of your tasks now ranked based on the prioritization criteria you assigned to each task. The higher you ranked the prioritization criteria, the more weight it had on how high of a priority each task should be. Included is the #1 prioritization criteria you selected for each task as well. Review the list. What surprises you about how using these specific criteria impacted how much of a priority each task was, or should have been? Is this the order that you placed each task in the course of your day?\n\nIn the \"reflection\" section below, there are a number of prompts to get you thinking about this list and the exercise as a whole. Take some time to honestly reflect on what is going well and where you might want to put more focus on sticking to your criteria - whether that means moving a task up on your criteria or potentially moving it down. How does this all change the way you think about how you prioritize?"]
[null,"Priority","Task","Planned or Unplanned?","Prioritization Criteria #1","Sum of Total Weight",null,"What Are Your Non-Negotiables",null,"What Are Your Potential Distractions or Derailers?"]
[null,1,"Task 5","(blank)","(blank)",0,null,{"$f":"Prioritization_Criteria!F7","v":null},null,{"$f":"Prioritization_Criteria!H7","v":null}]
[null,2,"Task 2","(blank)","(blank)",0]
[null,3,"Task 9","(blank)","(blank)",0]
[null,4,"Task 10","(blank)","(blank)",0]
[null,5,"Task 3","(blank)","(blank)",0]
[null,6,"Task 11","(blank)","(blank)",0]
[null,7,"Task 7","(blank)","(blank)",0]
[null,8,"Task 12","(blank)","(blank)",0]
[null,9,"Task 19","(blank)","(blank)",0]
[null,10,"Task 13","(blank)","(blank)",0]
[null,11,"Task 20","(blank)","(blank)",0]
[null,12,"Task 14","(blank)","(blank)",0]
[null,13,"Task 4","(blank)","(blank)",0]
[null,14,"Task 15","(blank)","(blank)",0]
[null,15,"Task 6","(blank)","(blank)",0]
[null,16,"Task 16","(blank)","(blank)",0]
[null,17,"Task 8","(blank)","(blank)",0]
[null,18,"Task 17","(blank)","(blank)",0]
[null,19,"Task 1","(blank)","(blank)",0]
[null,20,"Task 18","(blank)","(blank)",0]
[]
[null,"Reflection"]
[]
[null,"Looking at your #1 priority task, does it genuinely feel like the most important thing you should be doing? If there's a mismatch between the logical ranking obtained in this tool and your intuition, what does that tell you about the criteria you chose?",{"$nulls":5},"Count the number of Planned and the number of Unplanned tasks. Where are you spending most of your time? If it's mostly unplanned, what can you do to better anticipate the unplanned tasks you listed?",null,"If you could only complete one thing from your task list today to have the biggest positive impact on your main goal for this week or your sense of accomplishment for the day, is it the task at the top?"]
[]
[]
[null,"Now, look at the very last item on your list. What is the realistic consequence of not doing it at all? Is this a task you can delegate, defer indefinitely, or simply delete?",{"$nulls":5},"Thinking about your non-negotiables, how well does your prioritized task list align to those values and what could you do to better improve that alignment?",null,"Which of your tasks were not completed due to a distractor or derailer? How could this have been avoided and what is one thing you could do differently going forward?"]

{"sheet":"Lists","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
[]
["Planned"]
["Unplanned"]