{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MRP Software Scorecard "],"not_rendered":{"charts":0,"images":1,"macros":0,"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":"MRP Software Scorecard ","index":0,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,1,65,9],[60,1,60,2],[1,13,2,13],[1,1,1,7],[2,2,3,2],[2,3,3,3],[2,5,3,5],[2,7,3,7],[2,9,3,9]]}
[null,"MRP SOFTWARE SCORECARD"]
[null,"This scorecard assumes that \"Pay-For Upgrades\" are preferable to \"In Future Release.\""]
[null,"FEATURES","PRIORITY","PRODUCT 1",null,"PRODUCT 2",null,"PRODUCT 3",null,"NOTES"]
[null,"Enter up to 50 features below",null,null,"Score",null,"Score",null,"Score"]
[null,"Flexible requirements",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D5,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F5,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H5,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,"Y"]
[null,"Advanced filtering",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D6,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F6,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H6,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,"N"]
[null,"Comprehensive drill-down capability",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D7,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F7,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H7,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,"F"]
[null,"Exception management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D8,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F8,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H8,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,"P"]
[null,"Agile order management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D9,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F9,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H9,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Aggregates requirements",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D10,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F10,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H10,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,1]
[null,"Workflow support",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D11,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F11,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H11,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,2]
[null,"Designated time frames",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D12,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F12,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H12,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,3]
[null,"Multiple quantity display",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D13,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F13,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H13,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,null,4]
[null,"Forecast consumption",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D14,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F14,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H14,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Supply-chain visibility",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D15,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F15,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H15,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Integrating into multiple environments",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D16,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F16,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H16,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Software support",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D17,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F17,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H17,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Free trials",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D18,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F18,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H18,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Encryption",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D19,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F19,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H19,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Access control",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D20,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F20,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H20,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Data policy",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D21,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F21,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H21,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Pricing",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D22,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F22,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H22,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Cloud-based",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D23,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F23,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H23,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Barcode printing",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D24,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F24,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H24,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Bills of material",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D25,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F25,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H25,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Stock management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D26,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F26,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H26,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Work-order management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D27,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F27,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H27,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Barcode support",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D28,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F28,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H28,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Vendor management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D29,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F29,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H29,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Dashboard",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D30,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F30,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H30,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Cost analysis",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D31,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F31,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H31,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Job costing",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D32,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F32,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H32,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Gantt charts",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D33,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F33,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H33,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Inventory forecasting",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D34,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F34,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H34,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Quotation management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D35,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F35,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H35,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Multi-location capability",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D36,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F36,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H36,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Planning tools",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D37,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F37,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H37,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Procurement management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D38,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F38,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H38,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Purchasing management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D39,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F39,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H39,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Rights management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D40,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F40,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H40,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Routing",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D41,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F41,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H41,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Customer database",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D42,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F42,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H42,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Order management",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D43,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F43,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H43,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"Inventory control",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D44,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F44,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H44,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"SCM",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D45,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F45,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H45,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,"CRM",null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D46,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F46,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H46,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D47,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F47,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H47,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D48,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F48,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H48,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D49,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F49,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H49,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D50,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F50,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H50,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D51,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F51,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H51,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D52,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F52,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H52,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D53,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F53,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H53,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D54,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F54,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H54,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(D55,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(F55,$L$5:$L$8,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX({1,0,0.3,0.5},MATCH(H55,$L$5:$L$8,0))","v":{"$error":"#N/A"}}]
[]
[null,"SOFTWARE SCORES","PRIORITY","PRODUCT 1",null,"PRODUCT 2",null,"PRODUCT 3"]
[null,"Total of \"Priority 1\" Features",1,{"$f":"IFERROR(SUMIF(C5:C55,\"1\",E5:E55),0)","v":0},null,{"$f":"IFERROR(SUMIF(C5:C55,\"1\",G5:G55),0)","v":0},null,{"$f":"IFERROR(SUMIF(C5:C55,\"1\",I5:I55),0)","v":0}]
[null,"Total of \"Priority 2\" Features",2,{"$f":"IFERROR(SUMIF(C5:C55,\"2\",E5:E55),0)","v":0},null,{"$f":"IFERROR(SUMIF(C5:C55,\"2\",G5:G55),0)","v":0},null,{"$f":"IFERROR(SUMIF(C5:C55,\"2\",I5:I55),0)","v":0}]
[null,"Total of \"Priority 3\" Features",3,{"$f":"IFERROR(SUMIF(C5:C55,\"3\",E5:E55),0)","v":0},null,{"$f":"IFERROR(SUMIF(C5:C55,\"3\",G5:G55),0)","v":0},null,{"$f":"IFERROR(SUMIF(C5:C55,\"3\",I5:I55),0)","v":0}]
[null,"TOTAL WEIGHTED SCORE",null,{"$f":"SUM(D58:D60)","v":0},null,{"$f":"SUM(F58:F60)","v":0},null,{"$f":"SUM(H58:H60)","v":0}]
[]
[]
[]
[null,"CLICK HERE TO CREATE MRP SOFTWARE SCORECARD TEMPLATES IN SMARTSHEET"]