{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["About this Tool","How to Use","Mission Based Priority","Prioritized List","Buckets","Legend"],"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":"About this Tool","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Mission Based Prioitization - 20 Aug 19"]
[]
[]
["For more information, please see:  "]
["https://insights.sei.cmu.edu/sei_blog/2020/11/mission-based-prioritization-a-new-method-to-sequence-features-capabilities-and-epics.html"]
[]
["Any questions about this document should be directed to Keith Korzec at the Software Engineering Institute (kkorzec@sei.cmu.edu)"]
[]
[]
["Copyright 2019 Carnegie Mellon University. All Rights Reserved."]
["This material is based upon work funded and supported by the Department of Defense under Contract No. FA8702-15-D-0002 with Carnegie Mellon University for the operation of the Software Engineering Institute, a federally funded research and development center."]
["The view, opinions, and/or findings contained in this material are those of the author(s) and should not be construed as an official Government position, policy, or decision, unless designated by other documentation."]
["NO WARRANTY. THIS CARNEGIE MELLON UNIVERSITY AND SOFTWARE ENGINEERING INSTITUTE MATERIAL IS FURNISHED ON AN \"AS-IS\" BASIS. CARNEGIE MELLON UNIVERSITY MAKES NO WARRANTIES OF ANY KIND, EITHER EXPRESSED OR IMPLIED, AS TO ANY MATTER INCLUDING, BUT NOT LIMITED TO, WARRANTY OF FITNESS FOR PURPOSE OR MERCHANTABILITY, EXCLUSIVITY, OR RESULTS OBTAINED FROM USE OF THE MATERIAL. CARNEGIE MELLON UNIVERSITY DOES NOT MAKE ANY WARRANTY OF ANY KIND WITH RESPECT TO FREEDOM FROM PATENT, TRADEMARK, OR COPYRIGHT INFRINGEMENT."]
["[DISTRIBUTION STATEMENT A] This material has been approved for public release and unlimited distribution.  Please see Copyright notice for non-US Government use and distribution."]
["Internal use:* Permission to reproduce this material and to prepare derivative works from this material for internal use is granted, provided the copyright and “No Warranty” statements are included with all reproductions and derivative works."]
["External use:* This material may be reproduced in its entirety, without modification, and freely distributed in written or electronic form without requesting formal permission. Permission is required for any other external and/or commercial use. Requests for permission should be directed to the Software Engineering Institute at permission@sei.cmu.edu."]
["* These restrictions do not apply to U.S. government entities."]
["DM19-0809"]
[]
["[DISTRIBUTION STATEMENT A] Approved for public release and unlimited distribution."]

{"sheet":"How to Use","index":1,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"The process to use this tool is simple. Steps 1,2,3 are done only the first time the tool is used."]
[]
["1.","Review parameters for applicability to your program. Add, remove, or modify any of the parameters and agree on the definitions to fit the program’s context."]
[]
[]
["2.","Apply relative weight factors and calibrate. This means ranking the importance of the parameter to the goals of the program. The easiest method I found for groups is dot voting. Enter the number of “dots” in the weight column on the Legend tab."]
[]
[null,"Be careful if any parameter receives a significantly larger vote because that will skew all development toward that parameter. When this happens, I have the team continue and assess the final prioritized list. If it does not accurately reflect the program’s objectives, I give them each one more “dot” to vote for anything except the top parameter. We update the weights in the Legend tab. The priorities automatically update, and this new list is now aligned with the group’s expectations."]
[]
[]
["3.","Define difficulty and uncertainty. Two factors serve as a proxy for job size in the WSJF formula. They are the difficulty to implement and uncertainty parameters. The members need to define and agree to these and document their definition on the Legend tab."]
[]
[]
["4.","Optional—size penalty. A later addition to the tool was a prioritization penalty applied when a feature was too large. By enabling this penalty, the team encouraged smaller features in the backlog. This had the added benefit of more features that do not continue into the next program increment. If you do not wish to use this feature, skip this step."]
[]
[null,"a.       Select “Y” in the add large feature penalty."]
[null,"b.       Enter the number of iterations within your standard program increment."]
[null,"c.       Decide when to apply the penalty. The default is any feature larger than 45 percent of the total program increment."]
[]
[]
["5.","Prioritize the backlog."]
[null,"a.       Add the items to be prioritized to column A on the Mission Based Priority tab."]
[null,"b.       For each feature, determine whether each parameter applies to that individual feature. If it does, place a “Y” in the cell, if not leave blank. (This is significantly different from the WSJF method where features are compared to each other.)"]
[null,"c.       Rank the difficulty to implement and the uncertainty from 1 to 5."]
[null,"d.       Enter the number of iterations (sprints) it will take to implement. Even without the large feature penalty enabled, documenting the size encourages breaking down features into smaller pieces."]
[]
[]
[null,"If you use this tool, please reach out to me at info@sei.cmu.edu. I am especially interested in your experience using the tool along with any parameters that did not apply to your program, any you added or changed, and what domain you are working in."]
[]
[]
[]
[]
[]
[null,"[DISTRIBUTION STATEMENT A] Approved for public release and unlimited distribution."]

{"sheet":"Mission Based Priority","index":2,"n_rows":36,"n_cols":28,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1]]}
["Feature","Priority",null,"Provides strategic or tactical advantage","Foundational (other features depend on this feature)","Replaces deficient functionality","Supplies missing functionality in existing system ","High sponsorship / visibility","Fulfills direct user request","Required to field","Hardens security","Time Critical / Urgent","Previously de-prioritized","Difficulty to implement","Uncertainty","# of iterations to implement","Penalty",null,null,"Add large feature penalty? (Y/N)","N"]
[null,null,null,{"$f":"Legend!D6","v":1},{"$f":"Legend!D7","v":1},{"$f":"Legend!D8","v":1},{"$f":"Legend!D9","v":1},{"$f":"Legend!D10","v":1},{"$f":"Legend!D11","v":1},{"$f":"Legend!D12","v":1},{"$f":"Legend!D13","v":1},{"$f":"Legend!D14","v":1},{"$f":"Legend!D15","v":1},"1 easy - 5 hard","1 solution well known - 5 high uncertain",null,null,null,null,"Number of iterations in a PI",4,null,null,null,null,null,"Denominator","Weighted score"]
[null,{"$f":"SUMPRODUCT((AB3<AB$3:AB$31)/COUNTIF(AB$3:AB$31,AB$3:AB$31))+1","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(A3)<>0,IF($U$1=\"Y\",IF($P3>$U$2*$U$3,\"Y\",\"N\"),\"N/A\"),\"\")","v":""},null,null,"When to apply penalty\n% of iterations (default > 45%)",0.45,null,null,null,null,null,{"$f":"IF( $U$2=\"Y\", IF($P3>$U$1*$U$3,1+(((N3+O3+(P3*4)/3))/10),1+(((N3+O3+P3/3))/10)), 1+(((N3+O3+P3/3))/10))","v":1},{"$f":"IF(LEN(A3)<>0,   (IF(UPPER(D3)=\"Y\", D$2,0)+IF(UPPER(E3)=\"Y\", E$2,0)+IF(UPPER(F3)=\"Y\", F$2,0)+IF(UPPER(G3)=\"Y\", G$2,0)+IF(UPPER(H3)=\"Y\", H$2,0)+IF(UPPER(I3)=\"Y\", I$2,0)+IF(UPPER(J3)=\"Y\", J$2,0)+IF(UPPER(K3)=\"Y\", K$2,0)+IF(UPPER(L3)=\"Y\",L$2,0)+IF(UPPER(M3)=\"Y\",M$2,0)+1)/$AA3,-1)","v":-1}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(A4)<>0,IF($U$1=\"Y\",IF($P4>$U$2*$U$3,\"Y\",\"N\"),\"N/A\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF( $U$2=\"Y\", IF($P4>$U$1*$U$3,1+(((N4+O4+(P4*4)/3))/10),1+(((N4+O4+P4/3))/10)), 1+(((N4+O4+P4/3))/10))","v":1},-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,{"$f":"SUMPRODUCT((AB12<AB$3:AB$31)/COUNTIF(AB$3:AB$31,AB$3:AB$31))+1","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,1,-1]
[]
[]
[]
[]
["[DISTRIBUTION STATEMENT A] Approved for public release and unlimited distribution."]

{"sheet":"Prioritized List","index":3,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Feature","Priority"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["[DISTRIBUTION STATEMENT A] Approved for public release and unlimited distribution."]

{"sheet":"Buckets","index":4,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"Feature","Priority"]
["Provides strategic or tactical advantage"]
[]
[]
[]
["Foundational (other features depend on this feature)"]
[]
[]
[]
["Replaces deficient functionality"]
[]
[]
[]
[]
[]
["Supplies missing functionality in existing system "]
[]
[]
["High sponsorship / visibility"]
[]
[]
[]
["Fulfills direct user request"]
[]
[]
[]
["Required to field"]
[]
[]
[]
["Hardens security"]
[]
[]
[]
[]
[]
["Time Critical / Urgent"]
[]
[]
[]
[]
["Previously de-prioritized"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["[DISTRIBUTION STATEMENT A] Approved for public release and unlimited distribution."]

{"sheet":"Legend","index":5,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,0,17,0],[0,0,0,2],[5,0,14,0]]}
["The term \"Features\" in this tool could easily be epics, capabilities, functionalities, etc.  However only similar items should be ranked against each other.  The tool only uses \"y\" or \"Y\" in the calculations.  Any parameter that does not apply can have the weight changed to zero, \"n\" placed in the fields, or the column hidden."]
[]
[]
[]
[null,"Parameter","Explanation","Weight"]
["Yes or No","Provides strategic or tactical advantage","A feature that takes advantage of an adversary's weakness",1]
[null,"Foundational (other features depend on this feature)","A feature or enabler that is necessary in order to create additional functionality.  This is highly dependent on the roadmap for when this parameter is relevant.",1]
[null,"Replaces deficient functionality","This option identifies features that correct/modify/supplement existing fielded systems.  These deficiencies can occur due to hardware refreshes, COTS upgrades, changes to drivers, etc.",1]
[null,"Supplies missing functionality in existing system ","A feature that will be added to a currently fielded system that fulfills an immediate need.  Examples would be a new threat has been identified, new or better hardware/sensor has become available, mission scope has changed, etc.",1]
[null,"High sponsorship / visibility","Very senior levels of DoD or congress has an interest in the development of this particular portion of the system. ",1]
[null,"Fulfills direct user request","A feature that has been requested by the actual users of the system.  These types of features can make the system easier to use, more efficient, more intuitive, etc.",1]
[null,"Required to field","A feature that is necessary to secure ATT, ATO, ATC, DT/OT, etc.",1]
[null,"Hardens security","A feature that will provide a stronger cyber resiliency.  This may not be the sole objective of the feature.",1]
[null,"Time Critical / Urgent","This option allows for development of features when there is a time/funding deadline.  Examples include funds or contracts that are going to expire, SMEs that will not be available beyond a certain date, options that are due, etc.",1]
[null,"Previously de-prioritized","A feature that got bumped lower in priority at least once after being submitted into a backlog at any level (i.e., Solution Backlog, Program Backlog, Team Backlog).\n\nThe reason would be to raise visibility of such features that keep getting delayed from delivery. On some programs, I’ve seen such reprioritization delays routinely occur without rationale provided (usually, the underlying reasons were red flags). Management at some SAFe level  should be cognizant of such occurrences to question the reasons.",1]
[]
["Scale","Difficulty to implement","This is valued on a scale of 1 - 5.  1 being the easiest to implement and 5 being the hardest.  The specific definitions of easy -> hardest is left to the portfolio/solution/product team"]
[null,"Uncertainty","This is valued on a scale of 1 - 5.  1 being the solution is well known and 5 being the solution is highly uncertain.  The specific definitions of easy -> hardest is left to the portfolio/solution/product team"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["[DISTRIBUTION STATEMENT A] Approved for public release and unlimited distribution."]