{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["3 Stage Method","3 Stage Summary","3 Stage Guidelines"],"not_rendered":{"images":2,"external_links":1,"defined_names":63},"read":"whole","date_system":"1900"}

{"sheet":"3 Stage Method","index":0,"n_rows":73,"n_cols":25,"rows_kept":73,"merged":[[1,1,1,24],[3,1,3,24],[5,2,5,3],[6,2,6,3],[7,2,7,3],[9,1,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,24],[10,1,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[11,1,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[12,1,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[13,1,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[14,1,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[15,1,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,24],[19,1,19,24],[21,2,21,3],[24,1,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[24,15,24,16],[24,17,24,18],[24,19,24,20],[24,21,24,22],[24,23,24,24],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[29,6,32,6],[29,8,32,8],[29,10,32,10],[29,12,32,12],[29,14,32,14],[29,16,32,16],[29,18,32,18],[29,20,32,20],[29,22,32,22],[29,24,32,24],[30,1,32,3],[34,1,34,3],[34,6,37,6],[34,8,37,8],[34,10,37,10],[34,12,37,12],[34,14,37,14],[34,16,37,16],[34,18,37,18],[34,20,37,20],[34,22,37,22],[34,24,37,24],[35,1,37,3],[39,1,39,3],[39,6,42,6],[39,8,42,8],[39,10,42,10],[39,12,42,12],[39,14,42,14],[39,16,42,16],[39,18,42,18],[39,20,42,20],[39,22,42,22],[39,24,42,24],[40,1,42,3],[44,1,44,3],[44,6,47,6],[44,8,47,8],[44,10,47,10],[44,12,47,12],[44,14,47,14],[44,16,47,16],[44,18,47,18],[44,20,47,20],[44,22,47,22],[44,24,47,24],[45,1,47,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[49,17,49,18],[49,19,49,20],[49,21,49,22],[49,23,49,24],[50,1,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[50,17,50,18],[50,19,50,20],[50,21,50,22],[50,23,50,24],[51,1,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[51,17,51,18],[51,19,51,20],[51,21,51,22],[51,23,51,24],[55,1,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[55,17,55,18],[55,19,55,20],[55,21,55,22],[55,23,55,24],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[56,17,56,18],[56,19,56,20],[56,21,56,22],[56,23,56,24],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[57,15,57,16],[57,17,57,18],[57,19,57,20],[57,21,57,22],[57,23,57,24],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[58,15,58,16],[58,17,58,18],[58,19,58,20],[58,21,58,22],[58,23,58,24],[59,5,70,6],[59,7,70,8],[59,9,70,10],[59,11,70,12],[59,13,70,14],[59,15,70,16],[59,17,70,18],[59,19,70,20],[59,21,70,22],[59,23,70,24]]}
[]
[]
[]
[null,"EVALUATION PANEL MEMBERS"]
[]
[]
[]
[]
[]
[null,"STAGE 1 - MANDATORY CRITERIA",{"$nulls":3},"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>",null,"<< Enter Supplier >>"]
[null,"Does the supplier agree to comply with Insurance Requirements (Section 8 of the RFQ)"]
[null,"Does the Supplier declare that they comply with the QLD Government’s Ethical Supplier Threshold? (Section 8 of the RFQ)"]
[null,"<< Enter additional mandatory criteria or leave blank >>"]
[null,"<< Enter additional mandatory criteria or leave blank >>"]
[null,"<< Enter additional mandatory criteria or leave blank >>"]
[null,"A pass will progress through to Stage 2",{"$nulls":3},{"$f":"IF(COUNTBLANK(F11:F15)=5,\"\",IF(COUNTIF(F11:F15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(H11:H15)=5,\"\",IF(COUNTIF(H11:H15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(J11:J15)=5,\"\",IF(COUNTIF(J11:J15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(L11:L15)=5,\"\",IF(COUNTIF(L11:L15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(N11:N15)=5,\"\",IF(COUNTIF(N11:N15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(P11:P15)=5,\"\",IF(COUNTIF(P11:P15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(R11:R15)=5,\"\",IF(COUNTIF(R11:R15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(T11:T15)=5,\"\",IF(COUNTIF(T11:T15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(V11:V15)=5,\"\",IF(COUNTIF(V11:V15,\"No\")>0,\"Fail\",\"Pass\"))","v":""},null,{"$f":"IF(COUNTBLANK(X11:X15)=5,\"\",IF(COUNTIF(X11:X15,\"No\")>0,\"Fail\",\"Pass\"))","v":""}]
[]
[]
[]
[null,"MINIMUM WEIGHTING SCORE"]
[]
[null,null,{"v":0.6,"d":"60%"}]
[]
[]
[null,"STAGE 2 - QUALITATIVE CRITERIA",{"$nulls":3},{"$f":"$F$10","v":"<< Enter Supplier >>"},null,{"$f":"$H$10","v":"<< Enter Supplier >>"},null,{"$f":"$J$10","v":"<< Enter Supplier >>"},null,{"$f":"$L$10","v":"<< Enter Supplier >>"},null,{"$f":"$N$10","v":"<< Enter Supplier >>"},null,{"$f":"$P$10","v":"<< Enter Supplier >>"},null,{"$f":"$R$10","v":"<< Enter Supplier >>"},null,{"$f":"$T$10","v":"<< Enter Supplier >>"},null,{"$f":"$V$10","v":"<< Enter Supplier >>"},null,{"$f":"$X$10","v":"<< Enter Supplier >>"}]
[{"$nulls":5},{"$f":"IFERROR(F27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(H27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(J27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(L27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(N27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(P27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(R27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(T27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(V27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(X27/(1*10),\"\")","v":{"v":0,"d":"0.0%"}}]
[null,"Local supplier",null,null,{"v":0.1,"d":"10%"},null,{"$f":"IF(F27=\"\",\"\",$E$27/5*F27)","v":""},null,{"$f":"IF(H27=\"\",\"\",$E$27/5*H27)","v":""},null,{"$f":"IF(J27=\"\",\"\",$E$27/5*J27)","v":""},null,{"$f":"IF(L27=\"\",\"\",$E$27/5*L27)","v":""},null,{"$f":"IF(N27=\"\",\"\",$E$27/5*N27)","v":""},null,{"$f":"IF(P27=\"\",\"\",$E$27/5*P27)","v":""},null,{"$f":"IF(R27=\"\",\"\",$E$27/5*R27)","v":""},null,{"$f":"IF(T27=\"\",\"\",$E$27/5*T27)","v":""},null,{"$f":"IF(V27=\"\",\"\",$E$27/5*V27)","v":""},null,{"$f":"IF(X27=\"\",\"\",$E$27/5*X27)","v":""}]
[null,"Small to Medium Size Enterprise (SME)",null,null,{"v":0.05,"d":"5%"},null,{"$f":"IF(OR(F28=\"Yes\", F28=\"No\"), IF(F28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(H28=\"Yes\", H28=\"No\"), IF(H28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(J28=\"Yes\", J28=\"No\"), IF(J28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(L28=\"Yes\", L28=\"No\"), IF(L28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(N28=\"Yes\", N28=\"No\"), IF(N28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(P28=\"Yes\", P28=\"No\"), IF(P28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(R28=\"Yes\", R28=\"No\"), IF(R28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(T28=\"Yes\", T28=\"No\"), IF(T28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(V28=\"Yes\", V28=\"No\"), IF(V28=\"Yes\", $E$28, 0), \"\")","v":""},null,{"$f":"IF(OR(X28=\"Yes\", X28=\"No\"), IF(X28=\"Yes\", $E$28, 0), \"\")","v":""}]
[null,"Social Enterprise Supplier or First Nation Business",null,null,{"v":0.1,"d":"10%"},null,{"$f":"IF(OR(F29=\"Yes\", F29=\"No\"), IF(F29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(H29=\"Yes\", H29=\"No\"), IF(H29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(J29=\"Yes\", J29=\"No\"), IF(J29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(L29=\"Yes\", L29=\"No\"), IF(L29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(N29=\"Yes\", N29=\"No\"), IF(N29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(P29=\"Yes\", P29=\"No\"), IF(P29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(R29=\"Yes\", R29=\"No\"), IF(R29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(T29=\"Yes\", T29=\"No\"), IF(T29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(V29=\"Yes\", V29=\"No\"), IF(V29=\"Yes\", $E$29, 0), \"\")","v":""},null,{"$f":"IF(OR(X29=\"Yes\", X29=\"No\"), IF(X29=\"Yes\", $E$29, 0), \"\")","v":""}]
[null,"Conformance to Requirements",null,null,"<<enter weighting>>",{"$f":"IFERROR(F34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(F30*$E$30),\"\")","v":""},{"$f":"IFERROR(H34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(H30*$E$30),\"\")","v":""},{"$f":"IFERROR(J34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(J30*$E$30),\"\")","v":""},{"$f":"IFERROR(L34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(L30*$E$30),\"\")","v":""},{"$f":"IFERROR(N34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(N30*$E$30),\"\")","v":""},{"$f":"IFERROR(P34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(P30*$E$30),\"\")","v":""},{"$f":"IFERROR(R34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(R30*$E$30),\"\")","v":""},{"$f":"IFERROR(T34/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(T30*$E$30),\"\")","v":""},"",{"$f":"IFERROR(SUM(V30*$E$30),\"\")","v":""},"",{"$f":"IFERROR(SUM(X30*$E$30),\"\")","v":""}]
[null,"Detail how the Supplier will meet the requirements specified in Section 1, Part 6.",null,null,{"$f":"$C$6","v":0}]
[{"$nulls":4},{"$f":"$C$7","v":0}]
[{"$nulls":4},{"$f":"$C$8","v":0}]
[{"$nulls":5},{"$f":"AVERAGE(F31:F33)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(H31:H33)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(J31:J33)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(L31:L33)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(N31:N33)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(V31:V33)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(X31:X33)","v":{"$error":"#DIV/0!"}}]
[null,"Capability and Experience",null,null,"<<enter weighting>>",{"$f":"IFERROR(F39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(F35*$E$35),\"\")","v":""},{"$f":"IFERROR(H39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(H35*$E$35),\"\")","v":""},{"$f":"IFERROR(J39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(J35*$E$35),\"\")","v":""},{"$f":"IFERROR(L39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(L35*$E$35),\"\")","v":""},{"$f":"IFERROR(N39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(N35*$E$35),\"\")","v":""},{"$f":"IFERROR(P39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(P35*$E$35),\"\")","v":""},{"$f":"IFERROR(R39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(R35*$E$35),\"\")","v":""},{"$f":"IFERROR(T39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(T35*$E$35),\"\")","v":""},{"$f":"IFERROR(V39/(1*5),\"\")","v":""},"",{"$f":"IFERROR(X39/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(X35*$E$35),\"\")","v":""}]
[null,"Provide detail of the capability and experience of the Supplier and of any Key Personnel/subcontractors (if applicable) in delivering goods/services of this type?",null,null,{"$f":"$C$6","v":0}]
[{"$nulls":4},{"$f":"$C$7","v":0}]
[{"$nulls":4},{"$f":"$C$8","v":0}]
[{"$nulls":5},{"$f":"AVERAGE(F36:F38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(H36:H38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(J36:J38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(L36:L38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(N36:N38)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(V36:V38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(X36:X38)","v":{"$error":"#DIV/0!"}}]
[null,"Ability to meet Timeframes",null,null,"<<enter weighting>>",{"$f":"IFERROR(F44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(F40*$E$40),\"\")","v":""},{"$f":"IFERROR(H44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(H40*$E$40),\"\")","v":""},{"$f":"IFERROR(J44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(J40*$E$40),\"\")","v":""},{"$f":"IFERROR(L44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(L40*$E$40),\"\")","v":""},{"$f":"IFERROR(N44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(N40*$E$40),\"\")","v":""},{"$f":"IFERROR(P44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(P40*$E$40),\"\")","v":""},{"$f":"IFERROR(R44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(R40*$E$40),\"\")","v":""},{"$f":"IFERROR(T44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(T40*$E$40),\"\")","v":""},{"$f":"IFERROR(V44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(V40*$E$40),\"\")","v":""},{"$f":"IFERROR(X44/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(X40*$E$40),\"\")","v":""}]
[null,"Please confirm that the Supplier has the resources available and capacity to commence on the specified contract start date as per Section 1, Part 6.",null,null,{"$f":"$C$6","v":0}]
[{"$nulls":4},{"$f":"$C$7","v":0}]
[{"$nulls":4},{"$f":"$C$8","v":0}]
[{"$nulls":5},{"$f":"AVERAGE(F41:F43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(H41:H43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(J41:J43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(L41:L43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(N41:N43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(P41:P43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(R41:R43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(T41:T43)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$error":"#DIV/0!"},"TOTAL ",{"$error":"#DIV/0!"},"TOTAL "]
[null,"Project Methodology",null,null,"<<enter weighting>>",{"$f":"IFERROR(F49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(F45*$E$45),\"\")","v":""},{"$f":"IFERROR(H49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(H45*$E$45),\"\")","v":""},{"$f":"IFERROR(J49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(J45*$E$45),\"\")","v":""},{"$f":"IFERROR(L49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(L45*$E$45),\"\")","v":""},{"$f":"IFERROR(N49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(N45*$E$45),\"\")","v":""},{"$f":"IFERROR(P49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(P45*$E$45),\"\")","v":""},{"$f":"IFERROR(R49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(R45*$E$45),\"\")","v":""},{"$f":"IFERROR(T49/(1*5),\"\")","v":""},{"$f":"IFERROR(SUM(T45*$E$45),\"\")","v":""},"",{"$f":"IFERROR(SUM(V45*$E$45),\"\")","v":""},"",{"$f":"IFERROR(SUM(X45*$E$45),\"\")","v":""}]
[null,"Please advise of the Suppliers methodology for meeting the timeframes detailed in the Specification?",null,null,{"$f":"$C$6","v":0}]
[{"$nulls":4},{"$f":"$C$7","v":0}]
[{"$nulls":4},{"$f":"$C$8","v":0}]
[{"$nulls":5},{"$f":"AVERAGE(F46:F48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(H46:H48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(J46:J48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(L46:L48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(N46:N48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(P46:P48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(R46:R48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(T46:T48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(V46:V48)","v":{"$error":"#DIV/0!"}},"TOTAL ",{"$f":"AVERAGE(X46:X48)","v":{"$error":"#DIV/0!"}},"TOTAL "]
[{"$nulls":5},{"$f":"SUM(G27:G49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(I27:I49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(K27:K49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(M27:M49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(O27:O49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(Q27:Q49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(S27:S49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(U27:U49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(W27:W49)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(Y27:Y49)","v":{"v":0,"d":"0%"}}]
[null,"STAGE 2 SCORE",{"$nulls":3},{"$f":"IF(F50=0,\"\",F50)","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,"A pass will progress through to Stage 3",{"$nulls":3},{"$f":"IF(F51=\"\",\"\",IF(F51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(H51=\"\",\"\",IF(H51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(J51=\"\",\"\",IF(J51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(L51=\"\",\"\",IF(L51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(N51=\"\",\"\",IF(N51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(P51=\"\",\"\",IF(P51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(R51=\"\",\"\",IF(R51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(T51=\"\",\"\",IF(T51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(V51=\"\",\"\",IF(V51>=$C$22,\"PASS\",\"FAIL\"))","v":""},null,{"$f":"IF(X51=\"\",\"\",IF(X51>=$C$22,\"PASS\",\"FAIL\"))","v":""}]
[]
[{"$nulls":5},"NOTE: If a tenderer passes Stage 2 - they are deemed capable of completing the services or delivering the goods to scope requirements. "]
[]
[null,"STAGE 3 - PRICING",{"$nulls":3},{"$f":"$F$10","v":"<< Enter Supplier >>"},null,{"$f":"$H$10","v":"<< Enter Supplier >>"},null,{"$f":"$J$10","v":"<< Enter Supplier >>"},null,{"$f":"$L$10","v":"<< Enter Supplier >>"},null,{"$f":"$N$10","v":"<< Enter Supplier >>"},null,{"$f":"$P$10","v":"<< Enter Supplier >>"},null,{"$f":"$R$10","v":"<< Enter Supplier >>"},null,{"$f":"$T$10","v":"<< Enter Supplier >>"},null,{"$f":"$V$10","v":"<< Enter Supplier >>"},null,{"$f":"$X$10","v":"<< Enter Supplier >>"}]
[{"$nulls":3},"Enter Suppliers Ex GST Price"]
[{"$nulls":3},"Ranking (1 = preferred supplier)",null,{"$f":"IF(F57=\"\",\"\",_xlfn.RANK.EQ(F57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(H57=\"\",\"\",_xlfn.RANK.EQ(H57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(J57=\"\",\"\",_xlfn.RANK.EQ(J57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(L57=\"\",\"\",_xlfn.RANK.EQ(L57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(N57=\"\",\"\",_xlfn.RANK.EQ(N57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(P57=\"\",\"\",_xlfn.RANK.EQ(P57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(R57=\"\",\"\",_xlfn.RANK.EQ(R57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(T57=\"\",\"\",_xlfn.RANK.EQ(T57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(V57=\"\",\"\",_xlfn.RANK.EQ(V57,$F$57:$Y$57,1))","v":""},null,{"$f":"IF(X57=\"\",\"\",_xlfn.RANK.EQ(X57,$F$57:$Y$57,1))","v":""}]
[{"$nulls":5},"Comments",null,"Comments",null,"Comments",null,"Comments",null,"Comments",null,"Comments",null,"Comments",null,"Comments",null,"Comments",null,"Comments"]
{"$rows_empty":13}
[null,"FMPM711.06 RFQ Three Stage Evaluation Method Template Version 1.0 January 2024"]

{"sheet":"3 Stage Summary","index":1,"n_rows":18,"n_cols":17,"rows_kept":18,"merged":[[3,1,5,1],[3,4,3,12],[4,2,5,2],[4,12,5,12],[4,14,5,14],[4,16,5,16]]}
[]
[]
[]
[null,"Supplier","STAGE 1",null,"STAGE 2",{"$nulls":9},"STAGE 3",null,"OUTCOME"]
[null,null,"Mandatory Criteria",null,{"$f":"'3 Stage Method'!$B$27","v":"Local supplier"},{"$f":"'3 Stage Method'!$B$28","v":"Small to Medium Size Enterprise (SME)"},{"$f":"'3 Stage Method'!$B$29","v":"Social Enterprise Supplier or First Nation Business"},{"$f":"'3 Stage Method'!$B$30","v":"Conformance to Requirements"},{"$f":"'3 Stage Method'!$B$35","v":"Capability and Experience"},{"$f":"'3 Stage Method'!$B$40","v":"Ability to meet Timeframes"},{"$f":"'3 Stage Method'!$B$45","v":"Project Methodology"},"Total Score\n\nPassing Threshold","Outcome",null,"Pricing",null,"Ranking"]
[{"$nulls":4},{"$f":"'3 Stage Method'!$E$27","v":{"v":0.1,"d":"10%"}},{"$f":"'3 Stage Method'!$E$28","v":{"v":0.05,"d":"5%"}},{"$f":"'3 Stage Method'!$E$29","v":{"v":0.1,"d":"10%"}},{"$f":"'3 Stage Method'!$E$30","v":"<<enter weighting>>"},{"$f":"'3 Stage Method'!$E$35","v":"<<enter weighting>>"},{"$f":"'3 Stage Method'!$E$40","v":"<<enter weighting>>"},{"$f":"'3 Stage Method'!$E$45","v":"<<enter weighting>>"},{"$f":"'3 Stage Method'!$C$22","v":{"v":0.6,"d":"60%"}}]
[null,{"$f":"'3 Stage Method'!$F$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$F$16","v":""},null,{"$f":"'3 Stage Method'!$G$27","v":""},{"$f":"'3 Stage Method'!$G$28","v":""},{"$f":"'3 Stage Method'!G29","v":""},{"$f":"'3 Stage Method'!G30","v":""},{"$f":"'3 Stage Method'!G35","v":""},{"$f":"'3 Stage Method'!G40","v":""},{"$f":"'3 Stage Method'!G45","v":""},{"$f":"'3 Stage Method'!F51","v":""},{"$f":"'3 Stage Method'!F52","v":""},null,{"$f":"'3 Stage Method'!F57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!F58","v":""}]
[null,{"$f":"'3 Stage Method'!$H$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$H$16","v":""},null,{"$f":"'3 Stage Method'!$I$27","v":""},{"$f":"'3 Stage Method'!I28","v":""},{"$f":"'3 Stage Method'!I29","v":""},{"$f":"'3 Stage Method'!I30","v":""},{"$f":"'3 Stage Method'!I35","v":""},{"$f":"'3 Stage Method'!I40","v":""},{"$f":"'3 Stage Method'!I45","v":""},{"$f":"'3 Stage Method'!H51","v":""},{"$f":"'3 Stage Method'!H52","v":""},null,{"$f":"'3 Stage Method'!H57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!H58","v":""}]
[null,{"$f":"'3 Stage Method'!$J$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$J$16","v":""},null,{"$f":"'3 Stage Method'!$K$27","v":""},{"$f":"'3 Stage Method'!K28","v":""},{"$f":"'3 Stage Method'!K29","v":""},{"$f":"'3 Stage Method'!K30","v":""},{"$f":"'3 Stage Method'!K35","v":""},{"$f":"'3 Stage Method'!K40","v":""},{"$f":"'3 Stage Method'!K45","v":""},{"$f":"'3 Stage Method'!J51","v":""},{"$f":"'3 Stage Method'!J52","v":""},null,{"$f":"'3 Stage Method'!J57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!J58","v":""}]
[null,{"$f":"'3 Stage Method'!$L$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$L$16","v":""},null,{"$f":"'3 Stage Method'!$M$27","v":""},{"$f":"'3 Stage Method'!M28","v":""},{"$f":"'3 Stage Method'!M29","v":""},{"$f":"'3 Stage Method'!M30","v":""},{"$f":"'3 Stage Method'!M35","v":""},{"$f":"'3 Stage Method'!M40","v":""},{"$f":"'3 Stage Method'!M45","v":""},{"$f":"'3 Stage Method'!L51","v":""},{"$f":"'3 Stage Method'!L52","v":""},null,{"$f":"'3 Stage Method'!L57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!L58","v":""}]
[null,{"$f":"'3 Stage Method'!$N$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$N$16","v":""},null,{"$f":"'3 Stage Method'!$O$27","v":""},{"$f":"'3 Stage Method'!O28","v":""},{"$f":"'3 Stage Method'!O29","v":""},{"$f":"'3 Stage Method'!O30","v":""},{"$f":"'3 Stage Method'!O35","v":""},{"$f":"'3 Stage Method'!O40","v":""},{"$f":"'3 Stage Method'!O45","v":""},{"$f":"'3 Stage Method'!N51","v":""},{"$f":"'3 Stage Method'!N52","v":""},null,{"$f":"'3 Stage Method'!N57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!N58","v":""}]
[null,{"$f":"'3 Stage Method'!$P$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$P$16","v":""},null,{"$f":"'3 Stage Method'!$Q$27","v":""},{"$f":"'3 Stage Method'!Q28","v":""},{"$f":"'3 Stage Method'!Q29","v":""},{"$f":"'3 Stage Method'!Q30","v":""},{"$f":"'3 Stage Method'!Q35","v":""},{"$f":"'3 Stage Method'!Q40","v":""},{"$f":"'3 Stage Method'!Q45","v":""},{"$f":"'3 Stage Method'!P51","v":""},{"$f":"'3 Stage Method'!P52","v":""},null,{"$f":"'3 Stage Method'!P57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!P58","v":""}]
[null,{"$f":"'3 Stage Method'!$R$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$R$16","v":""},null,{"$f":"'3 Stage Method'!$S$27","v":""},{"$f":"'3 Stage Method'!S28","v":""},{"$f":"'3 Stage Method'!S29","v":""},{"$f":"'3 Stage Method'!S30","v":""},{"$f":"'3 Stage Method'!S35","v":""},{"$f":"'3 Stage Method'!S40","v":""},{"$f":"'3 Stage Method'!S45","v":""},{"$f":"'3 Stage Method'!R51","v":""},{"$f":"'3 Stage Method'!R52","v":""},null,{"$f":"'3 Stage Method'!R57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!R58","v":""}]
[null,{"$f":"'3 Stage Method'!$T$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$T$16","v":""},null,{"$f":"'3 Stage Method'!$U$27","v":""},{"$f":"'3 Stage Method'!U28","v":""},{"$f":"'3 Stage Method'!U29","v":""},{"$f":"'3 Stage Method'!U30","v":""},{"$f":"'3 Stage Method'!U35","v":""},{"$f":"'3 Stage Method'!U40","v":""},{"$f":"'3 Stage Method'!U45","v":""},{"$f":"'3 Stage Method'!T51","v":""},{"$f":"'3 Stage Method'!T52","v":""},null,{"$f":"'3 Stage Method'!T57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!T58","v":""}]
[null,{"$f":"'3 Stage Method'!$V$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$V$16","v":""},null,{"$f":"'3 Stage Method'!$W$27","v":""},{"$f":"'3 Stage Method'!W28","v":""},{"$f":"'3 Stage Method'!W29","v":""},{"$f":"'3 Stage Method'!W30","v":""},{"$f":"'3 Stage Method'!W35","v":""},{"$f":"'3 Stage Method'!W40","v":""},{"$f":"'3 Stage Method'!W45","v":""},{"$f":"'3 Stage Method'!V51","v":""},{"$f":"'3 Stage Method'!V52","v":""},null,{"$f":"'3 Stage Method'!V57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!V58","v":""}]
[null,{"$f":"'3 Stage Method'!$X$25","v":"<< Enter Supplier >>"},{"$f":"'3 Stage Method'!$X$16","v":""},null,{"$f":"'3 Stage Method'!$Y$27","v":""},{"$f":"'3 Stage Method'!Y28","v":""},{"$f":"'3 Stage Method'!Y29","v":""},{"$f":"'3 Stage Method'!Y30","v":""},{"$f":"'3 Stage Method'!Y35","v":""},{"$f":"'3 Stage Method'!Y40","v":""},{"$f":"'3 Stage Method'!Y45","v":""},{"$f":"'3 Stage Method'!X51","v":""},{"$f":"'3 Stage Method'!X52","v":""},null,{"$f":"'3 Stage Method'!X57","v":{"v":0,"d":"$0"}},null,{"$f":"'3 Stage Method'!X58","v":""}]
[]
[null,{"$f":"'3 Stage Method'!B73","v":"FMPM711.06 RFQ Three Stage Evaluation Method Template Version 1.0 January 2024"}]

{"sheet":"3 Stage Guidelines","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"merged":[[1,1,1,9],[2,1,2,9],[3,1,3,9],[5,1,5,9],[6,1,6,9],[8,1,8,9],[9,1,9,9],[11,1,11,9],[12,1,12,6],[12,7,12,9],[13,1,13,6],[13,7,13,9],[14,1,14,6],[14,7,14,9],[15,1,15,6],[15,7,15,9],[16,1,16,6],[16,7,16,9],[17,1,17,6],[17,7,17,9],[19,1,19,9],[20,1,20,6],[20,7,20,9],[21,1,21,6],[21,7,21,9],[23,1,23,9],[24,1,24,6],[24,7,24,9],[25,1,25,6],[25,7,25,9],[27,1,27,9],[28,1,29,6],[28,7,28,9],[29,7,29,9],[30,1,31,6],[30,7,30,9],[31,7,31,9],[32,1,33,6],[32,7,32,9],[33,7,33,9],[34,1,35,6],[34,7,34,9],[35,7,35,9],[36,1,37,6],[36,7,36,9],[37,7,37,9],[38,1,38,6],[38,7,38,9],[40,1,40,9],[41,1,41,9],[43,1,43,5]]}
[]
[]
[null,"This method excludes price as a consideration until a stage that the evaluation team are satisfied that one or more tenderers have the capability to provide the goods/services.  \n\nThe stages in this evaluation are:\n1. Mandatory criteria;\n2.  Qualitative criteria (minimum “hurdle rate” (threshold) must be achieved for tenders to proceed to stage 3); and\n3. Price (tenders achieving stage 2 minimum “hurdle rate” (threshold) score will be ranked solely by price) "]
[null,"For any assistance, please contact the Strategic Procurement Group"]
[]
[null,"STAGE 1 - MANDATORY CRITERIA"]
[null,"1.\tMandatory criteria must be carefully considered before being used in an evaluation process.   Mandatory criteria is expressed as a positive obligation in the tender documents, i.e. the tenderer must \ndo a particular action.  A failure to comply with a mandatory criterion will, generally, lead to exclusion of the tenderer from further consideration.\n\n2.\tMandatory criteria may be appropriate when a license or other pre-requisite is required to perform the services or a particular geographic location is required.  Responses that do not meet the mandatory criteria may be rejected without further consideration.\n\n3.\tIt is recommended NOT to have tender site visits or tender documentation compliance as mandatory criteria."]
[]
[null,"STAGE 2 - QUALATATIVE CRITERIA"]
[null,"The objective of this method is to ensure that only those tenders that are considered as capable of providing the goods/services will progress to the final stage of evaluation.  \n\nThe tender evaluation team must agree upon a minimum “hurdle rate” for a tenderer to be considered for inclusion in stage three of evaluation.  This is be set with reference to the scoring table and associated narrative descriptors below.  \n\nNote: It is recommended to set the “hurdle rate at 60%.   The higher the hurdle rate, the less tenderers will move onto stage 3 and therefore reduce pricing competition opportunities."]
[]
[null,"HOW TO SCORE LOCAL SUPPLIER"]
[null,"Head office is located within 125km where the goods or services are to be supplied.",{"$nulls":5},5]
[null,"Branch office within 125km where the goods or services are to be supplied. Established for a minimum of 6 months directly employing a minimum of 10 Full Time Equivalents staff (FTEs).    A branch office must constitute a physical address, not a post office box",{"$nulls":5},4]
[null,"Branch office within 125km where the goods or services are to be supplied. Established for a minimum of 6 months directly employing a less than 10 Full Time Equivalents staff (FTEs).    \nA branch office must constitute a physical address, not a post office box",{"$nulls":5},3]
[null,"Queensland business (determined by the head office location of the business)",{"$nulls":5},2]
[null,"Interstate business (determined by the head office location of the business)",{"$nulls":5},1]
[null,"Overseas business (determined by the head office location of the business)",{"$nulls":5},0]
[]
[null,"HOW TO SCORE SMALL TO MEDIUM SIZE ENTERPRISE (SME)"]
[null,"☐ Small business (less than 20 employees)\n☐ Medium Enterprise (20 or more but less than 200 employees)",{"$nulls":5},"Yes"]
[null,"☐ Large Enterprise (200 or more employees)",{"$nulls":5},"No"]
[]
[null,"HOW TO SCORE SOCIAL ENTERPRISES / FIRST NATIONS BUSINESS"]
[null,"☐ Classified as a First Nation Business?",{"$nulls":5},"Yes"]
[null,"☐ Classified as a Social Enterprise",{"$nulls":5},"Yes"]
[]
[null,"STANDARD SCORING GUIDE"]
[null,"Highly convincing and credible.  Offer demonstrates excellent capability, capacity and experience relevant to, or understanding of the requirements of the Evaluation Criteria.  No identifiable weaknesses or deficiencies.",{"$nulls":5},5]
[{"$nulls":7},4.5,null,4.5]
[null,"Offer complies, is convincing and credible.  Offer demonstrates very good capability, capacity and experience relevant to, or understanding of the requirements of the evaluation criteria.  Any deficiencies are minor and do not affect essential aspects of service delivery.",{"$nulls":5},4,null,4]
[{"$nulls":7},3.5,null,3.5]
[null,"Offer complies and is credible.  Offer demonstrates satisfactory capability, capacity and experience, relevant to or understanding of the requirements of the evaluation criteria.  Contains errors, risks, weakness or omission which are possible to overcome and to make acceptable with some effort.",{"$nulls":5},3,null,3]
[{"$nulls":7},2.5,null,2.5]
[null,"Credible but not completely convincing.  Offer demonstrates only a marginal capability, capacity and experience relevant to, or understanding of the requirements of the evaluation criteria.  Contains numerous errors, risks, weakness or omissions which may be difficult to overcome and to make acceptable with significant effort.",{"$nulls":5},2,null,2]
[{"$nulls":7},1.5,null,1.5]
[null,"Barley convincing.  Offer has shortcomings and deficiencies in demonstrating the respondent's capability, capacity and experience relevant to, or understanding of the requirements of the evaluation criteria.  Contains numerous errors, risks, weakness or omissions which will be difficult to overcome and to make acceptable.",{"$nulls":5},1,null,1]
[{"$nulls":7},0.5,null,0.5]
[null,"Totally deficient and non-compliant offer",{"$nulls":5},0,null,0]
[]
[null,"PRICING"]
[null,"Enter total Ex GST pricing from each supplier.   Consider not only the upfront purchase price but also ongoing costs, such as length of engagement, maintenance, support, and any hidden fees associated with the product or service.  Pricing will be ranked from lowest to highest.  The supplier with the lowest ranking will be the successful supplier."]
[]
[null,{"$f":"'3 Stage Method'!B73","v":"FMPM711.06 RFQ Three Stage Evaluation Method Template Version 1.0 January 2024"}]