{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pugh Screening Matrix","Weighted Selection Matrix"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":23,"comments":1,"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":"Pugh Screening Matrix","index":0,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[5,2,5,3],[5,14,5,15],[9,14,9,15]]}
[]
[]
[null,null,"Pugh Screening Matrix",null,null,null,null,"Concepts"]
[null,null,null,null,"1 - Datum",{"$f":"COLUMN()-COLUMN(PSM_Concept_Index)+1","v":2},3,4,5,6,7]
[]
[null,null,"Criteria",null,null,null,null,null,null,null,null,"Comments",null,null,"Concept Scoring"]
[null,null,{"$f":"ROW()-ROW(PSM_Criteria_Index)+1","v":1},null,"S",null,null,null,null,null,null,null,null,null,"+","Better Performance than Datum"]
[null,null,2,null,"S",null,null,null,null,null,null,null,null,null,"S","Same Performance as Datum"]
[null,null,3,null,"S",null,null,null,null,null,null,null,null,null,"-","Worse Performance than Datum"]
[null,null,4,null,"S",null,null,null,null,null,null,null,null,null,"All Scored vs. Datum"]
[null,null,5,null,"S"]
[null,null,6,null,"S"]
[null,null,7,null,"S"]
[null,null,8,null,"S"]
[null,null,9,null,"S"]
[null,null,10,null,"S"]
[null,null,null,"Total S +",{"$f":"COUNTIF(E$7:E$16,\"+\")","v":0},{"$f":"IF(SUM(IF(F7:F16=\"\",0,1))=0,\"\",COUNTIF(F$7:F$16,\"+\"))","v":""},{"$f":"IF(SUM(IF(G7:G16=\"\",0,1))=0,\"\",COUNTIF(G$7:G$16,\"+\"))","v":""},{"$f":"IF(SUM(IF(H7:H16=\"\",0,1))=0,\"\",COUNTIF(H$7:H$16,\"+\"))","v":""},{"$f":"IF(SUM(IF(I7:I16=\"\",0,1))=0,\"\",COUNTIF(I$7:I$16,\"+\"))","v":""},null,{"$f":"IF(SUM(IF(K7:K16=\"\",0,1))=0,\"\",COUNTIF(K$7:K$16,\"+\"))","v":""}]
[null,null,null,"Total S -",{"$f":"COUNTIF(E$7:E$16,\"-\")","v":0},{"$f":"IF(SUM(IF(F7:F16=\"\",0,1))=0,\"\",COUNTIF(F$7:F$16,\"-\"))","v":""},{"$f":"IF(SUM(IF(G7:G16=\"\",0,1))=0,\"\",COUNTIF(G$7:G$16,\"-\"))","v":""},{"$f":"IF(SUM(IF(H7:H16=\"\",0,1))=0,\"\",COUNTIF(H$7:H$16,\"-\"))","v":""},{"$f":"IF(SUM(IF(I7:I16=\"\",0,1))=0,\"\",COUNTIF(I$7:I$16,\"-\"))","v":""},null,{"$f":"IF(SUM(IF(K7:K16=\"\",0,1))=0,\"\",COUNTIF(K$7:K$16,\"-\"))","v":""}]
[null,null,null,"Total S S",{"$f":"COUNTIF(E$7:E$16,\"S\")","v":10},{"$f":"IF(SUM(IF(F7:F16=\"\",0,1))=0,\"\",COUNTIF(F$7:F$16,\"S\"))","v":""},{"$f":"IF(SUM(IF(G7:G16=\"\",0,1))=0,\"\",COUNTIF(G$7:G$16,\"S\"))","v":""},{"$f":"IF(SUM(IF(H7:H16=\"\",0,1))=0,\"\",COUNTIF(H$7:H$16,\"S\"))","v":""},{"$f":"IF(SUM(IF(I7:I16=\"\",0,1))=0,\"\",COUNTIF(I$7:I$16,\"S\"))","v":""},null,{"$f":"IF(SUM(IF(K7:K16=\"\",0,1))=0,\"\",COUNTIF(K$7:K$16,\"S\"))","v":""}]
[null,null,null,"Total",{"$f":"E17-E18","v":0},{"$f":"IFERROR(F17-F18,\"\")","v":""},{"$f":"IFERROR(G17-G18,\"\")","v":""},"","",null,""]
[null,null,null,"Rank",{"$f":"IF(SUM($F17:$K19)=0,\" \",IFERROR(RANK(E20,$E$20:$K$20),\"\"))","v":" "},{"$f":"IF(SUM($F17:$K19)=0,\" \",IFERROR(RANK(F20,$E$20:$K$20),\"\"))","v":" "},{"$f":"IF(SUM($F17:$K19)=0,\" \",IFERROR(RANK(G20,$E$20:$K$20),\"\"))","v":" "},{"$f":"IF(SUM($F17:$K19)=0,\" \",IFERROR(RANK(H20,$E$20:$K$20),\"\"))","v":" "},{"$f":"IF(SUM($F17:$K19)=0,\" \",IFERROR(RANK(I20,$E$20:$K$20),\"\"))","v":" "},null,{"$f":"IF(SUM($F17:$K19)=0,\" \",IFERROR(RANK(K20,$E$20:$K$20),\"\"))","v":" "}]
[]
[null,null,null,"Date:"]
[]
[null,null,null,"Attendees: "]
[]
[]
[null,null,null,"Note: New Rows and Columns will be added to end."]
[]
[]
[]
[null,null,null,"Note: Ranking is color coded "]
[null,null,null,"1--- Green"]
[null,null,null,"2--- Blue"]
[null,null,null,"3---- Yellow"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"S"]

{"sheet":"Weighted Selection Matrix","index":1,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[19,3,19,5],[3,2,3,5],[5,2,5,3],[5,16,5,17],[17,3,17,5],[18,3,18,5]]}
[]
[]
[null,null,"Weighted Selection Matrix",null,null,null,null,null,null,null,"Concepts"]
[null,null,null,null,null,null,"1 - Datum",{"$f":"COLUMN()-COLUMN(WSM_Concept_Index)+1","v":2},3,4,5,6,7]
[]
[null,null,"Criteria",null,"Importance Weighting","Percent\nContribution",null,null,null,null,null,null,null,"Comments",null,null,"Concept Scoring"]
[null,null,{"$f":"ROW()-ROW(WSM_Criteria_Index)+1","v":1},null,null,{"$f":"IF(E$17<>\"\",E7/E$17,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,10,"Best Performance"]
[null,null,2,null,null,"",null,null,null,null,null,null,null,null,null,null,7,"Somewhat Poorer Performance"]
[null,null,3,null,null,"",null,null,null,null,null,null,null,null,null,null,4,"Significantly Poorer Performance"]
[null,null,4,null,null,"",null,null,null,null,null,null,null,null,null,null,1,"Drastically Poorer Performance"]
[null,null,5,null,null,""]
[null,null,6,null,null,""]
[null,null,7,null,null,""]
[null,null,8,null,null,""]
[null,null,9,null,null,""]
[null,null,10,null,null,""]
[null,null,null,"Total Importance Weight ",{"$f":"IF(SUM(E7:E16)>0,SUM(E7:E16),\"\")","v":""},{"$f":"IF(E17<>\"\",SUM(F7:F16),\"\")","v":""}]
[null,null,null,"Total Score",null,null,{"$f":"IF(SUMPRODUCT(G7:G16,$E7:$E16)=0,\"\",SUMPRODUCT(G7:G16,$E7:$E16))","v":""},"","","","","",""]
[null,null,null,"Performance vs. Datum",null,null,"Datum",{"$f":"IFERROR((H18-$G$18)/$G$18,\"\")","v":""},"","","","",""]
[null,null,null,"Rank",null,null,{"$f":"IFERROR(RANK(G18,$G18:$M18),\"\")","v":""},"","","","","",""]
[]
[null,null,null,"Date:"]
[]
[null,null,null,"Attendees: "]
[]
[]
[null,null,null,"Note: New Rows and Columns will be added to end."]
[]
[]
[]
[null,null,null,"Note: Ranking is color coded "]
[null,null,null,"1--- Green"]
[null,null,null,"2--- Yellow"]
[null,null,null,"3---- Red"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Estimated Time:"]