{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,1,2,12]]}
["Karbon Prioritization Template",null,null,"* please copy and paste into your own Google Doc or Excel spreadsheet; Sample data included for a 5 vendor and 5 criteria evaluation"]
[]
[null,"Evaluation Scoring Metrics"]
["Segments to Prioritize","Process Fit","Ease of Use","Service & Support","Performance","Price","Metric #6","Metric #7","Metric #8","Metric #9","Metric #10","Metric #11","Metric #12",null,"Priority Score",null,"Harvey Ball"]
["Vendor #1",5.0,3.0,5.0,2.0,3.0,{"$nulls":8},{"$f":"$B$27*B34+$C$27*C34+$D$27*D34+$E$27*E34+$F$27*F34+$G$27*G34+$H$27*H34+$I$27*I34+$J$27*J34+$K$27*K34+$L$27*L34+$M$27*M34","v":0.75},null,"Quantitative"]
["Vendor #2",4.0,4.0,3.0,1.0,4.0,{"$nulls":8},0.7,null,"Yes"]
["Vendor #3",3.0,1.0,4.0,3.0,2.0,{"$nulls":8},0.47,null,"No"]
["Vendor #4",2.0,2.0,2.0,4.0,1.0,{"$nulls":8},0.44]
["Vendor #5",1.0,5.0,1.0,5.0,5.0,{"$nulls":8},0.64]
["Vendor #6",{"$nulls":13},0]
["Vendor #7",{"$nulls":13},0]
["Vendor #8",{"$nulls":13},0]
["Vendor #9",{"$nulls":13},0]
["Vendor #10",{"$nulls":13},0]
["Vendor #11",{"$nulls":13},0]
["Vendor #12",{"$nulls":13},0]
["Vendor #13",{"$nulls":13},0]
["Vendor #14",{"$nulls":13},0]
["Vendor #15",{"$nulls":13},0]
["Vendor #16",{"$nulls":13},0]
["Vendor #17",{"$nulls":13},0]
["Vendor #18",{"$nulls":13},0]
["Vendor #19",{"$nulls":13},0]
["Vendor #20",{"$nulls":13},0]
[]
["Data Type","Harvey Ball","Harvey Ball","Harvey Ball","Harvey Ball","Harvey Ball"]
["Weighting %",0.4,0.3,0.05,0.15,0.1,0.0,0.0,0.0,0.0,0.0,0.0,0.0,null,{"$f":"sum(B27:M27)","v":1}]
[]
["Max",5.0,{"$f":"max(C5:C24)","v":5},5,5,5,0,0,0,0,0,0,0]
["Min",{"$f":"min(B5:B24)","v":1},1,1,1,1,0,0,0,0,0,0,0]
["Reverse?","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
["Normalized Data Table"]
["Vendor #1",{"$f":"If($B$31=\"Yes\",1-(If($B$26=\"Quantitative\",B5/$B$29,If($B$26=\"Harvey Ball\",B5/5,\"Select Data Type\"))),If($B$26=\"Quantitative\",B5/$B$29,If($B$26=\"Harvey Ball\",B5/5,0)))","v":1},{"$f":"If($C$31=\"Yes\",1-(If($C$26=\"Quantitative\",C5/$C$29,If($C$26=\"Harvey Ball\",C5/5,\"Select Data Type\"))),If($C$26=\"Quantitative\",C5/$C$29,If($C$26=\"Harvey Ball\",C5/5,0)))","v":0.6},{"$f":"If($D$31=\"Yes\",1-(If($D$26=\"Quantitative\",D5/$D$29,If($D$26=\"Harvey Ball\",D5/5,\"Select Data Type\"))),If($D$26=\"Quantitative\",D5/$D$29,If($D$26=\"Harvey Ball\",D5/5,0)))","v":1},{"$f":"If($E$31=\"Yes\",1-(If($E$26=\"Quantitative\",E5/$E$29,If($E$26=\"Harvey Ball\",E5/5,\"Select Data Type\"))),If($E$26=\"Quantitative\",E5/$E$29,If($E$26=\"Harvey Ball\",E5/5,0)))","v":0.4},{"$f":"If($F$31=\"Yes\",1-(If($F$26=\"Quantitative\",F5/$F$29,If($F$26=\"Harvey Ball\",F5/5,\"Select Data Type\"))),If($F$26=\"Quantitative\",F5/$F$29,If($F$26=\"Harvey Ball\",F5/5,0)))","v":0.6},{"$f":"If($G$31=\"Yes\",1-(If($G$26=\"Quantitative\",G5/$G$29,If($G$26=\"Harvey Ball\",G5/5,\"Select Data Type\"))),If($G$26=\"Quantitative\",G5/$G$29,If($G$26=\"Harvey Ball\",G5/5,0)))","v":0},{"$f":"If($H$31=\"Yes\",1-(If($H$26=\"Quantitative\",H5/$H$29,If($H$26=\"Harvey Ball\",H5/5,\"Select Data Type\"))),If($H$26=\"Quantitative\",H5/$H$29,If($H$26=\"Harvey Ball\",H5/5,0)))","v":0},{"$f":"If($I$31=\"Yes\",1-(If($I$26=\"Quantitative\",I5/$I$29,If($I$26=\"Harvey Ball\",I5/5,\"Select Data Type\"))),If($I$26=\"Quantitative\",I5/$I$29,If($I$26=\"Harvey Ball\",I5/5,0)))","v":0},{"$f":"If($J$31=\"Yes\",1-(If($J$26=\"Quantitative\",J5/$J$29,If($J$26=\"Harvey Ball\",J5/5,\"Select Data Type\"))),If($J$26=\"Quantitative\",J5/$J$29,If($J$26=\"Harvey Ball\",J5/5,0)))","v":0},{"$f":"If($K$31=\"Yes\",1-(If($K$26=\"Quantitative\",K5/$K$29,If($K$26=\"Harvey Ball\",K5/5,\"Select Data Type\"))),If($K$26=\"Quantitative\",K5/$K$29,If($K$26=\"Harvey Ball\",K5/5,0)))","v":0},{"$f":"If($L$31=\"Yes\",1-(If($L$26=\"Quantitative\",L5/$L$29,If($L$26=\"Harvey Ball\",L5/5,\"Select Data Type\"))),If($L$26=\"Quantitative\",L5/$L$29,If($L$26=\"Harvey Ball\",L5/5,0)))","v":0},{"$f":"If($M$31=\"Yes\",1-(If($M$26=\"Quantitative\",M5/$M$29,If($M$26=\"Harvey Ball\",M5/5,\"Select Data Type\"))),If($M$26=\"Quantitative\",M5/$M$29,If($M$26=\"Harvey Ball\",M5/5,0)))","v":0}]
["Vendor #2",0.8,0.8,0.6,0.2,0.8,0,0,0,0,0,0,0]
["Vendor #3",0.6,0.2,0.8,0.6,0.4,0,0,0,0,0,0,0]
["Vendor #4",0.4,0.4,0.4,0.8,0.2,0,0,0,0,0,0,0]
["Vendor #5",0.2,1,0.2,1,1,0,0,0,0,0,0,0]
["Vendor #6",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #7",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #8",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #9",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #10",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #11",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #12",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #13",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #14",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #15",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #16",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #17",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #18",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #19",0,0,0,0,0,0,0,0,0,0,0,0]
["Vendor #20",0,0,0,0,0,0,0,0,0,0,0,0]