{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Organizational Priorities","Buckets of Work","Task Identification","Decision","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":137,"n_cols":2,"rows_kept":137,"cut":false,"hidden":false,"merged":[[29,0,31,11],[0,0,2,11],[7,1,7,11],[6,1,6,11],[9,1,9,11],[11,0,13,11],[3,0,3,11]]}
["Prioritizing Impact and Maximizing Efficiency Recommendation Framework"]
[]
[]
["Purpose:  This tool empowers departments to evaluate their work against strategic priorities, allowing them to make informed decisions to optimize efforts and reallocate resources effectively."]
["Steps to Use the Tool:"]
["Step #1: Type In College/Unit Organizational Priorities","Defined by the College/Unit"]
["Step #2:  Identify Team Strategic Priorities","Defined by the Department in alignment with the College/Unit Strategic Priorities"]
["Step #3: Idenfity Buckets of Work","Individuals/Teams provide insight on the buckets of work to meet the strategic priorities"]
["Step #4: Task Identification","Identify the tasks required to accomplish the work that fall into each bucket"]
["Step # 5: Decision","Determine who will lead next steps to put together a formal recommendation for review and approval by College/Unit Leadership to move forward"]
[]
["General Notes to use this tool effectively"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet Specific Instructions"]
[]
[]
["Organizational Priorities Sheet (Steps #1 & 2)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Buckets of Work Sheet (Step #3)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Task Identification Sheet (Step #4)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Decision Sheet (Step #5)"]

{"sheet":"Organizational Priorities","index":1,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Step #1: College/Unit Organizational Priorities"]
["Strategic Priorities"]
["College/Unit Organizational Priority #1"]
["College/Unit Organizational Priority #2"]
["College/Unit Organizational Priority #3"]
[]
[]
[]
[]
[]
["Step #2: Identify Team Strategic Priorities"]
["Strategic Priorities"]
["Team Priority #1"]
["Team Priority #2"]
["Team Priority #3"]
["Non Priority Specific"]

{"sheet":"Buckets of Work","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[24,3,25,7]]}
["Step #3: Identify the team's work"]
["#","Team Strategic Priority","Big Buckets of Work"]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":1}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":2}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":3}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":4}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":5}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":6}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":7}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":8}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":9}]
[{"$f":"ROW() - ROW(step26[[#Headers],['#]])","v":10}]

{"sheet":"Task Identification","index":3,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Step #4 Identify Tasks Within Buckets"]
["#","Bucket of Work","Strategic Priority","Task/Project","Types of Work","Impact on Customer  (1-low to 10 high)","Effort to accomplish work   (1-low to 10 high)","Recommendation to the Decision Maker","Level of Impact on Other Department, College or Unit"]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":1},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B3,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":2},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B4,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":3},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B5,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":4},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B6,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":5},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B7,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":6},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B8,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":7},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B9,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":8},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B10,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":9},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B11,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":10},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B12,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":11},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B13,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":12},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B14,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":13},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B15,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":14},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B16,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":15},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B17,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":16},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B18,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":17},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B19,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":18},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B20,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":19},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B21,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":20},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B22,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":21},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B23,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":22},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B24,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":23},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B25,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":24},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B26,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":25},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B27,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":26},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B28,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":27},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B29,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":28},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B30,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":29},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B31,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":30},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B32,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]
[{"$f":"ROW() - ROW(Table3[#Headers])","v":31},null,{"$f":"_xlfn.LET(_xlpm.result, _xlfn.XLOOKUP(B33,'Buckets of Work'!C:C,'Buckets of Work'!B:B,\"Not Found\"), IF(_xlpm.result=0, \"\", _xlpm.result))","v":""}]

{"sheet":"Decision","index":4,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Step # 5 Determine Leads/Decision Makers"]
["#","Strategic Priority","Bucket of Work","Task/Project","Lead (responsible for the task/project status and communication plan)","Decision Maker","Recommendation to the Decision Maker","Decision Maker Determination (Stop, Delegate, Optimize, Keep)","Notes (Details, Assumptions, Communications planning, Next steps)"]
[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,""]

{"sheet":"Data","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Team Priority #1","Degree of Impact","Recommendation Submitted","Completion Status",null,"Type of Work","Decision Maker Determination ","Return on Investment"]
["Team Priority #2","High - Positive","Yes","Not Started",null,"Program (Strategic, Ongoing)","Stop","Low"]
["Team Priority #3","Medium - Positive","No","In Progress",null,"Service (Operational, Continuous)","Delegate","Medium"]
["Non Priority Specific","Low - Positive",null,"Complete",null,"Initiative (Strategic, Time-bound, Experimental)","Optimize","High"]
[null,"Neutral",null,null,null,"Project (Tactical, Temporary)","Keep"]
[null,"Low - Negative"]
[null,"Medium - Negative"]
[null,"High - Negative"]