{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Lowest Price","Lowest Price Summary","Lowest Price Guidelines","Calc Info"],"not_rendered":{"images":1,"external_links":1,"defined_names":70},"read":"whole","date_system":"1900"}

{"sheet":"Lowest Price","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"merged":[[1,1,1,13],[2,1,2,13],[3,1,3,13],[5,2,5,3],[6,2,6,3],[7,2,7,3],[9,1,9,13],[11,2,11,3],[12,2,12,3],[13,2,13,3],[16,1,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[21,1,21,2],[22,1,22,2]]}
[]
[]
[]
[null,"EVALUATION PANEL MEMBERS"]
[]
[]
[]
[]
[]
[null,"MANDATORY CRITERIA"]
[]
[]
[]
[]
[]
[]
[null,"EVALUATION AND PRICING",null,null,"Supplier 1","Supplier 2","Supplier 3","Supplier 4","Supplier 5","Supplier 6","Supplier 7","Supplier 8","Supplier 9","Supplier 10"]
[null,null,"1. Starting with the first supplier do they meet mandatory criteria."]
[null,null,"2. Suppliers Price (Ex GST)"]
[null,null,"Ranking (supplier ranked 1 is the successful supplier)",null,{"$f":"IFERROR(RANK(E19,$E$19:$N$19,1),\"\")","v":""},"","","","","","","","",""]
[]
[{"$nulls":4},"Comments","Comments","Comments","Comments","Comments","Comments","Comments","Comments","Comments","Comments"]
[]
[]
[null,"FMPM711.05 Lowest Price Conforming Evaluation Template Version 1.0 January 2024"]

{"sheet":"Lowest Price Summary","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[1,1,1,4]]}
[]
[null,"FMPM711.05 LOWEST PRICE CONFORMING EVALUATION SUMMARY"]
[]
[null,"SUPPLIER NAME","MANDATORY CRITERIA MET","PRICING","RANKING"]
[null,{"$f":"'Lowest Price'!E17","v":"Supplier 1"},{"$f":"'Lowest Price'!E$18","v":0},{"$f":"'Lowest Price'!E$19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!E20","v":""}]
[null,{"$f":"'Lowest Price'!F17","v":"Supplier 2"},{"$f":"'Lowest Price'!F18","v":0},{"$f":"'Lowest Price'!F19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!F20","v":""}]
[null,{"$f":"'Lowest Price'!G17","v":"Supplier 3"},{"$f":"'Lowest Price'!G18","v":0},{"$f":"'Lowest Price'!G19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!G20","v":""}]
[null,{"$f":"'Lowest Price'!H17","v":"Supplier 4"},{"$f":"'Lowest Price'!H18","v":0},{"$f":"'Lowest Price'!H19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!H20","v":""}]
[null,{"$f":"'Lowest Price'!I17","v":"Supplier 5"},{"$f":"'Lowest Price'!I18","v":0},{"$f":"'Lowest Price'!I19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!I20","v":""}]
[null,{"$f":"'Lowest Price'!J17","v":"Supplier 6"},{"$f":"'Lowest Price'!J18","v":0},{"$f":"'Lowest Price'!J19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!J20","v":""}]
[null,{"$f":"'Lowest Price'!K17","v":"Supplier 7"},{"$f":"'Lowest Price'!K18","v":0},{"$f":"'Lowest Price'!K19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!K20","v":""}]
[null,{"$f":"'Lowest Price'!L17","v":"Supplier 8"},{"$f":"'Lowest Price'!L18","v":0},{"$f":"'Lowest Price'!L19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!L20","v":""}]
[null,{"$f":"'Lowest Price'!M17","v":"Supplier 9"},{"$f":"IF(OR(ISBLANK('Lowest Price'!M18)),\"\",'Lowest Price'!M18)","v":""},{"$f":"'Lowest Price'!M19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!M20","v":""}]
[null,{"$f":"'Lowest Price'!N17","v":"Supplier 10"},{"$f":"IF(OR(ISBLANK('Lowest Price'!N18)),\"\",'Lowest Price'!N18)","v":""},{"$f":"'Lowest Price'!N19","v":{"v":0,"d":"$0"}},{"$f":"'Lowest Price'!N20","v":""}]
[]
[null,{"$f":"'Lowest Price'!B25","v":"FMPM711.05 Lowest Price Conforming Evaluation Template Version 1.0 January 2024"}]

{"sheet":"Lowest Price Guidelines","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[1,1,1,8],[3,1,3,8],[4,1,4,8]]}
[]
[null,"FMPM711.05 LOWEST PRICE CONFORMING EVALUATION"]
[]
[null,"This method should only be used for purchases less than $200,000, or if you are utilising a pre-established panel or arrangement. The preferred supplier is the supplier that offers the lowest price and meets the minimum mandatory requirements of the RFQ document, i.e. submits a conforming submission.\n\nINSTRUCTIONS\n1. Enter your evaluation team members (minimum of two)\n2. Enter your mandatory criteria (up to three)\n3. Enter supplier names who submitted a response to your RFQ\n4. Starting with the first supplier, select YES if all mandatory criteria as been met, otherwise select NO.  This supplier is then eliminated from the evaluation.\n5. Enter pricing for all suppliers that remain in the evaluation.\n6. The supplier with the cheapest pricing will be ranked as number 1 and will be the successful supplier."]
[null,"For any assistance please contact the Strategic Procurement Group."]
[]
[null,{"$f":"'Lowest Price'!B25","v":"FMPM711.05 Lowest Price Conforming Evaluation Template Version 1.0 January 2024"}]

{"sheet":"Calc Info","index":3,"n_rows":9,"n_cols":1,"rows_kept":9,"hidden":true}
["Please select"]
["Supplier within 125km from wehre the goods/services are to be supplied"]
["Social Enterprise Supplier"]
["Indigenous Supplier"]
["Small to Medium Enterprise"]
["Conformance to Requirements"]
["Capability and Experience"]
["Ability to Meet Timeframes"]
["Project Methodology"]