{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Evaluation","Requirements","Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Evaluation","index":0,"n_rows":51,"n_cols":30,"rows_kept":51,"merged":[[6,0,6,30],[7,1,7,3],[8,1,12,2],[13,1,15,2],[16,1,18,2],[20,1,20,4],[20,6,20,8],[20,11,20,13],[20,16,20,18],[20,21,20,23],[20,26,20,28],[21,1,21,3],[21,6,21,8],[21,11,21,13],[21,16,21,18],[21,21,21,23],[21,26,21,28],[22,1,22,3],[22,6,22,8],[22,11,22,13],[22,16,22,18],[22,21,22,23],[22,26,22,28],[23,1,23,3],[23,6,23,8],[23,11,23,13],[23,16,23,18],[23,21,23,23],[23,26,23,28],[24,1,24,2],[24,6,24,8],[24,11,24,13],[24,16,24,18],[24,21,24,23],[24,26,24,28],[28,6,39,7],[28,11,39,12],[28,16,39,17],[40,6,50,7],[40,11,50,12],[40,16,50,17],[40,21,50,22],[40,26,50,27],[45,1,45,4],[46,1,46,3],[47,1,47,4],[49,1,49,4]]}
[null,null,0,"Do Not Meet",{"$nulls":18},"MAX",null,null,"Not applicable",{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},null,"NOT MEET"]
[null,null,1,"Partial Meet",{"$nulls":18},{"v":0,"d":"0%"},null,0,"Do Not Meet",{"v":0.51,"d":"51%"},{"v":0.75,"d":"75%"},null,"PARTIAL MEET"]
[null,null,2,"Meet",{"$nulls":18},{"v":0.75,"d":"75%"},null,1,"Partial Meet",{"v":0.76,"d":"76%"},{"v":1,"d":"100%"},null,"MEET"]
[null,null,3,"Exceed",{"$nulls":18},{"v":1,"d":"100%"},null,2,"Meet",{"v":1.01,"d":"101%"},110,null,"EXCEED"]
[{"$nulls":22},{"v":1.1,"d":"110%"},null,3,"Exceed"]
[{"$nulls":22},{"v":1,"d":"100%"},null,"X","Not applicable"]
["TECHNICAL EVALUATION: SUPPLY AND DELIVERY OF FLOOR MONITORS\n"]
[null,"Requirements",null,null,"Weighting",null,"Vendor 1","Score","Rating","Comment",null,"Vendor 2","Score","Rating","Comment",null,"Vendor 3","Score","Rating","Comment",null,"Vendor 4","Score","Rating","Comment",null,"Vendor 5","Score","Rating","Comment"]
[null,"COMPANY PROFILE",null,"Well balanced organisational structure.",{"v":0.1,"d":"10%"},null,0,{"$f":"IF(G9=$Y$2,$W$2,(IF(G9=$Y$3,$W$3,IF(G9=$Y$4,$W$4,IF(G9=$Y$5,$W$5,IF(G9=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$9*H9","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L9=$Y$2,$W$2,(IF(L9=$Y$3,$W$3,IF(L9=$Y$4,$W$4,IF(L9=$Y$5,$W$5,IF(L9=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$9*M9","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q9=$Y$2,$W$2,(IF(Q9=$Y$3,$W$3,IF(Q9=$Y$4,$W$4,IF(Q9=$Y$5,$W$5,IF(Q9=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$9*R9","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V9=$Y$2,$W$2,(IF(V9=$Y$3,$W$3,IF(V9=$Y$4,$W$4,IF(V9=$Y$5,$W$5,IF(V9=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$9*W9","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA9=$Y$2,$W$2,(IF(AA9=$Y$3,$W$3,IF(AA9=$Y$4,$W$4,IF(AA9=$Y$5,$W$5,IF(AA9=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$9*AB9","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Proof of approved supplier for the equipment offered or demonstrate that the Supplier is the equipment manufacturer.",{"v":0.4,"d":"40%"},null,0,{"$f":"IF(G10=$Y$2,$W$2,(IF(G10=$Y$3,$W$3,IF(G10=$Y$4,$W$4,IF(G10=$Y$5,$W$5,IF(G10=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$10*H10","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L10=$Y$2,$W$2,(IF(L10=$Y$3,$W$3,IF(L10=$Y$4,$W$4,IF(L10=$Y$5,$W$5,IF(L10=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$10*M10","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q10=$Y$2,$W$2,(IF(Q10=$Y$3,$W$3,IF(Q10=$Y$4,$W$4,IF(Q10=$Y$5,$W$5,IF(Q10=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$10*R10","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V10=$Y$2,$W$2,(IF(V10=$Y$3,$W$3,IF(V10=$Y$4,$W$4,IF(V10=$Y$5,$W$5,IF(V10=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$10*W10","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA10=$Y$2,$W$2,(IF(AA10=$Y$3,$W$3,IF(AA10=$Y$4,$W$4,IF(AA10=$Y$5,$W$5,IF(AA10=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$10*AB10","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Relevant references of past experience related to supply of equipment offered or other RP Equipment.",{"v":0.3,"d":"30%"},null,0,{"$f":"IF(G11=$Y$2,$W$2,(IF(G11=$Y$3,$W$3,IF(G11=$Y$4,$W$4,IF(G11=$Y$5,$W$5,IF(G11=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$11*H11","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L11=$Y$2,$W$2,(IF(L11=$Y$3,$W$3,IF(L11=$Y$4,$W$4,IF(L11=$Y$5,$W$5,IF(L11=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$11*M11","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q11=$Y$2,$W$2,(IF(Q11=$Y$3,$W$3,IF(Q11=$Y$4,$W$4,IF(Q11=$Y$5,$W$5,IF(Q11=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$11*R11","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V11=$Y$2,$W$2,(IF(V11=$Y$3,$W$3,IF(V11=$Y$4,$W$4,IF(V11=$Y$5,$W$5,IF(V11=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$11*W11","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA11=$Y$2,$W$2,(IF(AA11=$Y$3,$W$3,IF(AA11=$Y$4,$W$4,IF(AA11=$Y$5,$W$5,IF(AA11=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$11*AB11","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Proof of personnel technical skill to supply equipment, testing, training of Purchaser and able resolve technical defects and issues.",{"v":0.2,"d":"20%"},null,0,{"$f":"IF(G12=$Y$2,$W$2,(IF(G12=$Y$3,$W$3,IF(G12=$Y$4,$W$4,IF(G12=$Y$5,$W$5,IF(G12=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$12*H12","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L12=$Y$2,$W$2,(IF(L12=$Y$3,$W$3,IF(L12=$Y$4,$W$4,IF(L12=$Y$5,$W$5,IF(L12=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$12*M12","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q12=$Y$2,$W$2,(IF(Q12=$Y$3,$W$3,IF(Q12=$Y$4,$W$4,IF(Q12=$Y$5,$W$5,IF(Q12=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"$E$12*R12","v":{"v":0,"d":"0%"}},null,null,0,{"v":0,"d":"0%"},{"$f":"$E$12*W12","v":{"v":0,"d":"0%"}},null,null,0,{"v":0,"d":"0%"},{"$f":"$E$12*AB12","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"TOTAL WEIGHTING",{"$f":"SUM(E9:E12)","v":{"v":1,"d":"100%"}},null,{"$f":"IF(AND(H13>$AA$1,H13<=$AB$1), $AD$1, IF(AND(H13>$AB$1,H13<=$AB$2), $AD$2, IF(AND(H13>$AB$2,H13<=$AB$3), $AD$3, IF(H13>$AB$3,$AD$4))))","v":false},{"$f":"SUM(H9:H12)/4","v":{"v":0,"d":"0%"}},{"$f":"SUM(I9:I12)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(M13>$AA$1,M13<=$AB$1), $AD$1, IF(AND(M13>$AB$1,M13<=$AB$2), $AD$2, IF(AND(M13>$AB$2,M13<=$AB$3), $AD$3, IF(M13>$AB$3,$AD$4))))","v":false},{"$f":"SUM(M9:M12)/4","v":{"v":0,"d":"0%"}},{"$f":"SUM(N9:N12)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(R13>$AA$1,R13<=$AB$1), $AD$1, IF(AND(R13>$AB$1,R13<=$AB$2), $AD$2, IF(AND(R13>$AB$2,R13<=$AB$3), $AD$3, IF(R13>$AB$3,$AD$4))))","v":false},{"$f":"SUM(R9:R12)/4","v":{"v":0,"d":"0%"}},{"$f":"SUM(S9:S12)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(W13>$AA$1,W13<=$AB$1), $AD$1, IF(AND(W13>$AB$1,W13<=$AB$2), $AD$2, IF(AND(W13>$AB$2,W13<=$AB$3), $AD$3, IF(W13>$AB$3,$AD$4))))","v":false},{"$f":"SUM(W9:W12)/4","v":{"v":0,"d":"0%"}},{"$f":"SUM(X9:X12)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(AB13>$AA$1,AB13<=$AB$1), $AD$1, IF(AND(AB13>$AB$1,AB13<=$AB$2), $AD$2, IF(AND(AB13>$AB$2,AB13<=$AB$3), $AD$3, IF(AB13>$AB$3,$AD$4))))","v":false},{"$f":"SUM(AB9:AB12)/4","v":{"v":0,"d":"0%"}},{"$f":"SUM(AC9:AC12)","v":{"v":0,"d":"0%"}}]
[null,"TECHNICAL SPECIFICATIONS",null,"Equipment offered complies with the technical specifications.",{"v":0.8,"d":"80%"},null,0,{"$f":"IF(G14=$Y$2,$W$2,(IF(G14=$Y$3,$W$3,IF(G14=$Y$4,$W$4,IF(G14=$Y$5,$W$5,IF(G14=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"H14*$E$14","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L14=$Y$2,$W$2,(IF(L14=$Y$3,$W$3,IF(L14=$Y$4,$W$4,IF(L14=$Y$5,$W$5,IF(L14=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"M14*$E$14","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q14=$Y$2,$W$2,(IF(Q14=$Y$3,$W$3,IF(Q14=$Y$4,$W$4,IF(Q14=$Y$5,$W$5,IF(Q14=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"R14*$E$14","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V14=$Y$2,$W$2,(IF(V14=$Y$3,$W$3,IF(V14=$Y$4,$W$4,IF(V14=$Y$5,$W$5,IF(V14=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"W14*$E$14","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA14=$Y$2,$W$2,(IF(AA14=$Y$3,$W$3,IF(AA14=$Y$4,$W$4,IF(AA14=$Y$5,$W$5,IF(AA14=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"AB14*$E$14","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Proof that equipment has been successfully used in support of Radiation Protection, in South Africa or elsewhere before.",{"v":0.2,"d":"20%"},null,0,{"$f":"IF(G15=$Y$2,$W$2,(IF(G15=$Y$3,$W$3,IF(G15=$Y$4,$W$4,IF(G15=$Y$5,$W$5,IF(G15=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"H15*$E$15","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L15=$Y$2,$W$2,(IF(L15=$Y$3,$W$3,IF(L15=$Y$4,$W$4,IF(L15=$Y$5,$W$5,IF(L15=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"M15*$E$15","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q15=$Y$2,$W$2,(IF(Q15=$Y$3,$W$3,IF(Q15=$Y$4,$W$4,IF(Q15=$Y$5,$W$5,IF(Q15=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"R15*$E$15","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V15=$Y$2,$W$2,(IF(V15=$Y$3,$W$3,IF(V15=$Y$4,$W$4,IF(V15=$Y$5,$W$5,IF(V15=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"W15*$E$15","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA15=$Y$2,$W$2,(IF(AA15=$Y$3,$W$3,IF(AA15=$Y$4,$W$4,IF(AA15=$Y$5,$W$5,IF(AA15=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"AB15*$E$15","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"TOTAL WEIGHTING",{"$f":"SUM(E14:E15)","v":{"v":1,"d":"100%"}},null,{"$f":"IF(AND(H16>$AA$1,H16<=$AB$1), $AD$1, IF(AND(H16>$AB$1,H16<=$AB$2), $AD$2, IF(AND(H16>$AB$2,H16<=$AB$3), $AD$3, IF(H16>$AB$3,$AD$4))))","v":false},{"$f":"SUM(H14:H15)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(I14:I15)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(M16>$AA$1,M16<=$AB$1), $AD$1, IF(AND(M16>$AB$1,M16<=$AB$2), $AD$2, IF(AND(M16>$AB$2,M16<=$AB$3), $AD$3, IF(M16>$AB$3,$AD$4))))","v":false},{"$f":"SUM(M14:M15)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(N14:N15)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(R16>$AA$1,R16<=$AB$1), $AD$1, IF(AND(R16>$AB$1,R16<=$AB$2), $AD$2, IF(AND(R16>$AB$2,R16<=$AB$3), $AD$3, IF(R16>$AB$3,$AD$4))))","v":false},{"$f":"SUM(R14:R15)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(S14:S15)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(W16>$AA$1,W16<=$AB$1), $AD$1, IF(AND(W16>$AB$1,W16<=$AB$2), $AD$2, IF(AND(W16>$AB$2,W16<=$AB$3), $AD$3, IF(W16>$AB$3,$AD$4))))","v":false},{"$f":"SUM(W14:W15)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(X14:X15)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(AB16>$AA$1,AB16<=$AB$1), $AD$1, IF(AND(AB16>$AB$1,AB16<=$AB$2), $AD$2, IF(AND(AB16>$AB$2,AB16<=$AB$3), $AD$3, IF(AB16>$AB$3,$AD$4))))","v":false},{"$f":"SUM(AB14:AB15)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(AC14:AC15)","v":{"v":0,"d":"0%"}}]
[null,"PLANNING",null,"Preliminary schedule supplied is realistic",{"v":0.6,"d":"60%"},null,0,{"$f":"IF(G17=$Y$2,$W$2,(IF(G17=$Y$3,$W$3,IF(G17=$Y$4,$W$4,IF(G17=$Y$5,$W$5,IF(G17=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"H17*$E$17","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L17=$Y$2,$W$2,(IF(L17=$Y$3,$W$3,IF(L17=$Y$4,$W$4,IF(L17=$Y$5,$W$5,IF(L17=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"M17*$E$17","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q17=$Y$2,$W$2,(IF(Q17=$Y$3,$W$3,IF(Q17=$Y$4,$W$4,IF(Q17=$Y$5,$W$5,IF(Q17=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"R17*$E$17","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V17=$Y$2,$W$2,(IF(V17=$Y$3,$W$3,IF(V17=$Y$4,$W$4,IF(V17=$Y$5,$W$5,IF(V17=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"W17*$E$17","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA17=$Y$2,$W$2,(IF(AA17=$Y$3,$W$3,IF(AA17=$Y$4,$W$4,IF(AA17=$Y$5,$W$5,IF(AA17=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"AB17*$E$17","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Supplier delivery date in line with required date",{"v":0.4,"d":"40%"},null,0,{"$f":"IF(G18=$Y$2,$W$2,(IF(G18=$Y$3,$W$3,IF(G18=$Y$4,$W$4,IF(G18=$Y$5,$W$5,IF(G18=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"H18*$E$18","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(L18=$Y$2,$W$2,(IF(L18=$Y$3,$W$3,IF(L18=$Y$4,$W$4,IF(L18=$Y$5,$W$5,IF(L18=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"M18*$E$18","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(Q18=$Y$2,$W$2,(IF(Q18=$Y$3,$W$3,IF(Q18=$Y$4,$W$4,IF(Q18=$Y$5,$W$5,IF(Q18=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"R18*$E$18","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(V18=$Y$2,$W$2,(IF(V18=$Y$3,$W$3,IF(V18=$Y$4,$W$4,IF(V18=$Y$5,$W$5,IF(V18=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"W18*$E$18","v":{"v":0,"d":"0%"}},null,null,0,{"$f":"IF(AA18=$Y$2,$W$2,(IF(AA18=$Y$3,$W$3,IF(AA18=$Y$4,$W$4,IF(AA18=$Y$5,$W$5,IF(AA18=$Y$6,$W$6))))))","v":{"v":0,"d":"0%"}},{"$f":"AB18*$E$18","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"TOTAL WEIGHTING",{"$f":"SUM(E17:E18)","v":{"v":1,"d":"100%"}},null,{"$f":"IF(AND(H19>$AA$1,H19<=$AB$1), $AD$1, IF(AND(H19>$AB$1,H19<=$AB$2), $AD$2, IF(AND(H19>$AB$2,H19<=$AB$3), $AD$3, IF(H19>$AB$3,$AD$4))))","v":false},{"$f":"SUM(H17:H18)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(I17:I18)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(M19>$AA$1,M19<=$AB$1), $AD$1, IF(AND(M19>$AB$1,M19<=$AB$2), $AD$2, IF(AND(M19>$AB$2,M19<=$AB$3), $AD$3, IF(M19>$AB$3,$AD$4))))","v":false},{"$f":"SUM(M17:M18)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(N17:N18)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(R19>$AA$1,R19<=$AB$1), $AD$1, IF(AND(R19>$AB$1,R19<=$AB$2), $AD$2, IF(AND(R19>$AB$2,R19<=$AB$3), $AD$3, IF(R19>$AB$3,$AD$4))))","v":false},{"$f":"SUM(R17:R18)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(S17:S18)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(W19>$AA$1,W19<=$AB$1), $AD$1, IF(AND(W19>$AB$1,W19<=$AB$2), $AD$2, IF(AND(W19>$AB$2,W19<=$AB$3), $AD$3, IF(W19>$AB$3,$AD$4))))","v":false},{"$f":"SUM(W17:W18)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(X17:X18)","v":{"v":0,"d":"0%"}},null,null,{"$f":"IF(AND(AB19>$AA$1,AB19<=$AB$1), $AD$1, IF(AND(AB19>$AB$1,AB19<=$AB$2), $AD$2, IF(AND(AB19>$AB$2,AB19<=$AB$3), $AD$3, IF(AB19>$AB$3,$AD$4))))","v":false},{"$f":"SUM(AB17:AB18)/2","v":{"v":0,"d":"0%"}},{"$f":"SUM(AC17:AC18)","v":{"v":0,"d":"0%"}}]
[]
[null,"Final Analysis"]
[null,{"$f":"B9","v":"COMPANY PROFILE"},null,null,{"v":0.15,"d":"15%"},null,{"$f":"$E22*I13","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E22*N13","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E22*S13","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E22*X13","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E22*AC13","v":{"v":0,"d":"0.0%"}}]
[null,{"$f":"B14","v":"TECHNICAL SPECIFICATIONS"},null,null,{"v":0.65,"d":"65%"},null,{"$f":"$E23*I16","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E23*N16","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E23*S16","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E23*X16","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E23*AC16","v":{"v":0,"d":"0.0%"}}]
[null,"PLANNING",null,null,{"v":0.2,"d":"20%"},null,{"$f":"$E24*I19","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E24*N19","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E24*S19","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E24*X19","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"$E24*AC19","v":{"v":0,"d":"0.0%"}}]
[null,"TOTAL",null,null,{"$f":"SUM(E22:E24)","v":{"v":1,"d":"100%"}},null,{"$f":"SUM(G22:G24)","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"SUM(L22:L24)","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"SUM(Q22:Q24)","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"SUM(V22:V24)","v":{"v":0,"d":"0.0%"}},{"$nulls":4},{"$f":"SUM(AA22:AA24)","v":{"v":0,"d":"0.0%"}}]
[null,null,"TECHNICALLY ACCEPTABLE"]
[null,null,"TECHNICALLY NOT ACCEPTABLE"]
[null,null,"RE-EVALUATE"]
[{"$nulls":6},{"$f":"G25>80%","v":false},{"$f":"AND(#REF!<80%,P3<80%,P7<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"L25>80%","v":false},{"$f":"AND(#REF!<80%,U3<80%,U7<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"Q25>80%","v":false},{"$f":"AND(#REF!<80%,Z3<80%,Z7<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"V25>80%","v":false},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AA25>80%","v":false},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Do Not Meet =",0,null,{"$f":"AND(#REF!<80%,M4<80%,M8<80%,#REF!<80%,M19<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,P4<80%,P8<80%,#REF!<80%,P19<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,R4<80%,R8<80%,#REF!<80%,R19<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,U4<80%,U8<80%,#REF!<80%,U19<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,W4<80%,W8<80%,#REF!<80%,W19<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,Z4<80%,Z8<80%,#REF!<80%,Z19<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,AB4<80%,AB8<80%,#REF!<80%,AB19<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Partial Meet =",1,null,{"$f":"AND(M1<80%,M5<80%,M9<80%,M16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P1<80%,P5<80%,P9<80%,P16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R1<80%,R5<80%,R9<80%,R16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U1<80%,U5<80%,U9<80%,U16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W1<80%,W5<80%,W9<80%,W16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z1<80%,Z5<80%,Z9<80%,Z16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB1<80%,AB5<80%,AB9<80%,AB16<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Meet = ",2,null,{"$f":"AND(M2<80%,M6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P2<80%,P6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R2<80%,R6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U2<80%,U6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W2<80%,W6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z2<80%,Z6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB2<80%,AB6<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(M3<80%,M7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P3<80%,P7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R3<80%,R7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U3<80%,U7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W3<80%,W7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z3<80%,Z7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB3<80%,AB7<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[null,"Proof of level of compliance to these items is to be submitted with the tender package. This proof is to constitute documentation / proof / comments / sufficient information, item by item. A simple “yes” or “no” will not suffice. Tenderers will be expected to score at least the minimum threshold of 80% per functional area to proceed to the next step. Tenderers will be deemed technically not acceptable if any of the functionalities score less than 80%. The final total given will be used to rank Suppliers who are technically acceptable.",{"$nulls":4},{"$f":"AND(M4<80%,M8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P4<80%,P8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R4<80%,R8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U4<80%,U8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W4<80%,W8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z4<80%,Z8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB4<80%,AB8<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(M5<80%,M9<80%,M13<80%,M19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P5<80%,P9<80%,P13<80%,P19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R5<80%,R9<80%,R13<80%,R19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U5<80%,U9<80%,U13<80%,U19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W5<80%,W9<80%,W13<80%,W19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z5<80%,Z9<80%,Z13<80%,Z19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB5<80%,AB9<80%,AB13<80%,AB19<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(M6<80%,#REF!<80%,M14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P6<80%,#REF!<80%,P14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R6<80%,#REF!<80%,R14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U6<80%,#REF!<80%,U14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W6<80%,#REF!<80%,W14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z6<80%,#REF!<80%,Z14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB6<80%,#REF!<80%,AB14<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(M7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB7<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(M8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB8<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(M9<80%,M13<80%,M16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(P9<80%,P13<80%,P16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(R9<80%,R13<80%,R16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(U9<80%,U13<80%,U16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(W9<80%,W13<80%,W16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(Z9<80%,Z13<80%,Z16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(AB9<80%,AB13<80%,AB16<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":6},{"$f":"AND(#REF!<80%,M14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,P14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,R14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,U14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,W14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,Z14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,AB14<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}},{"$f":"AND(#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%,#REF!<80%)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Do Not Meet =",0,null,{"$f":"IF(G29=TRUE,C26,C27)","v":"TECHNICALLY NOT ACCEPTABLE"},{"$nulls":4},{"$f":"IF(L29=TRUE,C26,C27)","v":"TECHNICALLY NOT ACCEPTABLE"},{"$nulls":4},{"$f":"IF(Q29=TRUE,C26,C27)","v":"TECHNICALLY NOT ACCEPTABLE"},{"$f":"IF(R29=TRUE,L26,L27)","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"IF(V29=TRUE,C26,C27)","v":"TECHNICALLY NOT ACCEPTABLE"},{"$nulls":4},{"$f":"IF(AA29=TRUE,C26,C27)","v":"TECHNICALLY NOT ACCEPTABLE"}]
[{"$nulls":3},"Partial Meet =",1,{"$nulls":11},{"$f":"IF(Q30=TRUE,K27,K28)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$nulls":3},"Meet = ",2,{"$nulls":11},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":16},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":16},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Proof of level of compliance to these items is to be submitted with the tender package. This proof is to constitute documentation / proof / comments / sufficient information, item by item. A simple “yes” or “no” will not suffice. ",{"$nulls":14},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":16},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Tenderers will be expected to score at least the minimum threshold of 70% per functional area to proceed to the next step. Tenderers will be deemed technically not acceptable if any of the functionalities score less than 80%.",{"$nulls":14},{"$f":"IF(Q37=TRUE,K34,K35)","v":{"$error":"#REF!"}},{"$f":"IF(R37=TRUE,L34,L35)","v":{"$error":"#REF!"}}]
[]
[null,"The final total given will be used to rank Suppliers who are technically acceptable.",{"$nulls":14},{"$f":"IF(Q38=TRUE,K35,K36)","v":{"$error":"#REF!"}},{"$f":"IF(R38=TRUE,L35,L36)","v":{"$error":"#REF!"}}]
[{"$nulls":16},{"$f":"IF(Q39=TRUE,K36,K37)","v":{"$error":"#REF!"}},{"$f":"IF(R39=TRUE,L36,L37)","v":{"$error":"#REF!"}}]

{"sheet":"Requirements","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"merged":[[0,0,0,5],[1,0,1,2],[2,0,7,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[8,0,10,1],[11,0,13,1],[14,0,14,5],[15,4,15,5],[18,0,19,3],[20,0,20,3]]}
["FUNCTIONAL EVALUATION CRITERIA : "]
["Requirements",null,null,"Deliverables","Criteria","Weighting"]
["COMPANY PROFILE",null,{"$f":"Evaluation!D9","v":"Well balanced organisational structure."},"Provide organisational structure highlighting key positions and how they will interface with Employer on this project.","The structure needs to show the function areas from Management down to the technical personnel and the roles each member plays in delivering the specific required services.",{"$f":"Evaluation!E9","v":{"v":0.1,"d":"10%"}}]
[null,null,{"$f":"Evaluation!D10","v":"Proof of approved supplier for the equipment offered or demonstrate that the Supplier is the equipment manufacturer."},"Submit a letter from Manufacturer confirming the Supplier isapproved as distributor.","Letter from Manufacturer that the supplier is approved to supply the equipment.",{"$f":"Evaluation!E10","v":{"v":0.4,"d":"40%"}}]
[null,null,{"$f":"Evaluation!D11","v":"Relevant references of past experience related to supply of equipment offered or other RP Equipment."},"Submit a portfolio of previous projects where this type of work was undertaken. ","The portfolio needs to show concrete works of this type of scope and magnitude.",{"$f":"Evaluation!E11","v":{"v":0.3,"d":"30%"}}]
[null,null,{"$f":"Evaluation!D12","v":"Proof of personnel technical skill to supply equipment, testing, training of Purchaser and able resolve technical defects and issues."},"Submit a list of experiences and skills of these resources, either as CVs or separately, that the supplier envisage as part of the base team. ","Demonstrate that personnel are suitably qualified to deliver the goods and services.",{"$f":"Evaluation!E12","v":{"v":0.2,"d":"20%"}}]
[]
[null,null,{"$f":"Evaluation!D13","v":"TOTAL WEIGHTING"},null,null,{"$f":"SUM(F3:F7)","v":{"v":1,"d":"100%"}}]
[{"$f":"Evaluation!B14","v":"TECHNICAL SPECIFICATIONS"},null,{"$f":"Evaluation!D14","v":"Equipment offered complies with the technical specifications."},"Provide detailed technical specifications of equipment supplied. ","Equipment supplied to meet the Purchaser's technical requirements.",{"$f":"Evaluation!E14","v":{"v":0.8,"d":"80%"}}]
[null,null,{"$f":"Evaluation!D15","v":"Proof that equipment has been successfully used in support of Radiation Protection, in South Africa or elsewhere before."},"Provide a list of organisations where the equipment has been supplied.","The list must demonstrate that the equipment is used elsewhere.",{"$f":"Evaluation!E15","v":{"v":0.2,"d":"20%"}}]
[null,null,{"$f":"Evaluation!D16","v":"TOTAL WEIGHTING"},null,null,{"$f":"SUM(F9:F10)","v":{"v":1,"d":"100%"}}]
["PLANNING",null,{"$f":"Evaluation!D17","v":"Preliminary schedule supplied is realistic"},"Provide a preliminary schedule for the delivery of the equipment.","Demonstrate that the Supplier understands the steps and timelines involved in the supply of goods.",{"$f":"Evaluation!E17","v":{"v":0.6,"d":"60%"}}]
[null,null,{"$f":"Evaluation!D18","v":"Supplier delivery date in line with required date"},"Indicate the delivery date at Koeberg.","The delivery date to meet the date the Purchaser requires the equipment.",{"$f":"Evaluation!E18","v":{"v":0.4,"d":"40%"}}]
[null,null,{"$f":"Evaluation!D19","v":"TOTAL WEIGHTING"},null,null,{"$f":"SUM(F12:F13)","v":{"v":1,"d":"100%"}}]
[]
[{"$nulls":4},"Final Analysis"]
[{"$nulls":4},{"$f":"Evaluation!B22","v":"COMPANY PROFILE"},{"$f":"Evaluation!E22","v":{"v":0.15,"d":"15%"}}]
[{"$nulls":4},{"$f":"Evaluation!B23","v":"TECHNICAL SPECIFICATIONS"},{"$f":"Evaluation!E23","v":{"v":0.65,"d":"65%"}}]
["The scoring of the Functional Evaluation is conducted as follows:\nA supplier is given a score in each of the sub-categories. These sub-categories are requirements detailed in the specification or contract for KBG2115. Scores are allocated as follows:\n0 - 0% -    Does not meet \n1 - 75% - Partial meet  \n2 -100% - Meet                                                                                                                                                                                                                                                                                                                                  Proof of level of compliance to these items is to be submitted with the tender package. This proof is to constitute documentation / proof / comments / sufficient information, item by item. A simple “yes” or “no” will not suffice. ",{"$nulls":3},{"$f":"Evaluation!B24","v":"PLANNING"},{"$f":"Evaluation!E24","v":{"v":0.2,"d":"20%"}}]
[]
["The overall score for functionality criteria is analysed as follows:\n0%     - 79%   - Does not meet\n80%   - 100% - Meet",{"$nulls":3},"TOTAL",{"$f":"SUM(F17:F20)","v":{"v":1,"d":"100%"}}]

{"sheet":"Sheet1","index":2,"n_rows":21,"n_cols":6,"rows_kept":21}
["MAX",null,"Not applicable",{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},"NOT MEET"]
[{"v":0,"d":"0%"},0,"Do Not Meet",{"v":0.51,"d":"51%"},{"v":0.75,"d":"75%"},"PARTIAL MEET"]
[{"v":0.75,"d":"75%"},1,"Partial Meet",{"v":0.76,"d":"76%"},{"v":1,"d":"100%"},"MEET"]
[{"v":1,"d":"100%"},2,"Meet",{"v":1.01,"d":"101%"},110,"EXCEED"]
[{"v":1.1,"d":"110%"},3,"Exceed"]
[{"v":1,"d":"100%"},"X","Not applicable"]
{"$rows_empty":14}
[{"$nulls":4},"Workings"]