{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Recommended Criteria","Round 1","Example Round 1","Example Round 2","Example Round 3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,2]]}
[]
["Decision Matrix Instructions"]
["Entering options",null,"Enter the options you want to choose between in the columns on the 'Round 1' tab. If you have a 'current state' or 'do nothing' option, that option should be used as the baseline. Once you've added all the options being considered, delete any unused columns that remain. "]
["Choosing your criteria ",null,"Choose what criteria you want to use to evaluate these options and enter that criteria on the rows provided. Delete any unused rows when you're finished. See the 'Recommended Criteria' tab for suggestions of what criteria to include when you're prioritizing Lean projects or selecting a solution. "]
["Adjusting weights ",null,"Adjust the weight of any criteria that are deemed more important than the others. For example assigning a 3 to a criterion means that it's three times more important than a criterion that's assigned a 1. "]
["Assigning scores",null,"Assign scores ranging between -2 and +2 for each option by asking \"Is this option better or worse than the baseline for this criterion?\". Positive numbers mean the option is better than the baseline while negative numbers mean it is worse. Use a zero if the option is the same as the baseline. "]
["Proceding to the \nnext round",null,"After you have assigned a score for all options, click on the 'Next Round' button. Clicking this button will eliminate the options that aren't best, highlight the winner of the current round, and make the current round's winner the baseline for the next round."]
["When to stop",null,"You should stop assigning scores when an option is identified as the best option."]

{"sheet":"Recommended Criteria","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[]
["Recommended criteria"]
[]
[null,"Project prioritization criteria",null,null,null,"Description"]
[null,"Occurs frequently",null,null,null,"Does this problem occur more often than the baseline problem? "]
[null,"Affects many people",null,null,null,"Does this problem affect more people than the baseline problem?"]
[null,"Wastes time or money",null,null,null,"Does this problem waste more time or money than the baseline?"]
[null,"Demoralizes employees",null,null,null,"Does it cause lower job satisfaction than the baseline?"]
[null,"Limits performace",null,null,null,"Does it limit your agency’s performance on key goals more than the baseline?"]
[null,"Causes complaints",null,null,null,"Does it result in more complaints from the public or other sources?"]
[null,"Can be improved easily",null,null,null,"Does it show more potential for dramatic improvement? "]
[]
[null,"Solution selection criteria",null,null,null,"Description"]
[null,"Low cost",null,null,null,"Will this solution cost less than the baseline solution?"]
[null,"Effectiveness",null,null,null,"Will this solution solve the problem more effectively than the baseline solution?"]
[null,"Ease of implementation",null,null,null,"Will this solution be easier to implement than the baseline solution?"]
[null,"Longevity",null,null,null,"Will this solution remain effective longer than the baseline solution?"]
[null,"Stakeholder support",null,null,null,"Does this solution have stronger support from your stakeholders?"]
[null,"Sponsor support",null,null,null,"Does this solution have greater support from your project sponsor?"]
[null,"Integration",null,null,null,"Will this solution integrate better with other related systems and processes?"]
[null,"Ease of maintenance",null,null,null,"Will this solution be easier to maintain in the future?"]

{"sheet":"Round 1","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["[Insert Title]"]
[]
[null,null,"Baseline"]
["Criteria","Weight","[Option 1]","[Option 2]","[Option 3]","[Option 4]","[Option 5]","[Option 6]","[Option 7]","[Option 8]","[Option 9]","[Option 10]"]
["-","-","-","-","-","-","-","-","-","-","-","-"]
["Criteria 1",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 2",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 3",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 4",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 5",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 6",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 7",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 8",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 9",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 10",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 11",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 12",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 13",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 14",1,0,"-","-","-","-","-","-","-","-","-"]
["Criteria 15",1,0,"-","-","-","-","-","-","-","-","-"]
["Totals",null,{"$f":"SUMPRODUCT($B$7:$B$21,C7:C21)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Example Round 1","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["Deciding where to go on vacation next"]
[]
[null,null,"Baseline",null,null,null,null,null,"New baseline"]
["Criteria","Weight","Stay home","Door County","Wisconsin Dells","Camping","Chicago","Las Vegas","Paris"]
["-","-","-","-","-","-","-","-","-"]
["Low cost ",3,0,-1,-1,-1,-1,-2,-2]
["Destination",2,0,1,1,1,1,2,2]
["Small crowd sizes",1,0,-1,-2,1,-2,-2,-2]
["Nature",1,0,1,1,2,-1,-1,0]
["Culture",2,0,0,1,0,1,1,2]
["Cuisine",2,0,0,1,0,2,1,2]
["Travel time",1,0,-1,-1,-1,-1,-2,-2]
["Totals",null,{"$f":"SUMPRODUCT($B$7:$B$13,C7:C13)","v":0},-2,1,1,1,-3,2]

{"sheet":"Example Round 2","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["Deciding where to go on vacation next"]
[]
[null,null,"Not best option","Not best option","New baseline",null,null,"Not best option","Baseline"]
["Criteria","Weight","Stay home","Door County","Wisconsin Dells","Camping","Chicago","Las Vegas","Paris"]
["-","-","-","-","-","-","-","-","-"]
["Low cost ",3,"-","-",2,2,1,"-",0]
["Destination",2,"-","-",-1,-2,-1,"-",0]
["Small crowd sizes",1,"-","-",-1,2,0,"-",0]
["Nature",1,"-","-",0,2,-1,"-",0]
["Culture",2,"-","-",-1,-2,-1,"-",0]
["Cuisine",2,"-","-",-1,-2,0,"-",0]
["Travel time",1,"-","-",2,1,1,"-",0]
["Totals",null,-100,-100,{"$f":"SUMPRODUCT($B$7:$B$13,E7:E13)","v":1},{"$f":"SUMPRODUCT($B$7:$B$13,F7:F13)","v":-1},{"$f":"SUMPRODUCT($B$7:$B$13,G7:G13)","v":-1},-100,{"$f":"SUMPRODUCT($B$7:$B$13,I7:I13)","v":0}]

{"sheet":"Example Round 3","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["Deciding where to go on vacation next"]
[]
[null,null,"Not best option","Not best option","Best option","Not best option","Not best option","Not best option","Not best option"]
["Criteria","Weight","Stay home","Door County","Wisconsin Dells","Camping","Chicago","Las Vegas","Paris"]
["-","-","-","-","-","-","-","-","-"]
["Low cost ",3,"-","-",2,"-","-","-","-"]
["Destination",2,"-","-",-1,"-","-","-","-"]
["Small crowd sizes",1,"-","-",-1,"-","-","-","-"]
["Nature",1,"-","-",0,"-","-","-","-"]
["Culture",2,"-","-",-1,"-","-","-","-"]
["Cuisine",2,"-","-",-1,"-","-","-","-"]
["Travel time",1,"-","-",2,"-","-","-","-"]
["Totals",null,-100,-100,{"$f":"SUMPRODUCT($B$7:$B$13,E7:E13)","v":1},-100,-100,-100,-100]