{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Functional Evaluation","Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Functional Evaluation","index":0,"n_rows":33,"n_cols":23,"rows_kept":33,"merged":[[6,2,6,14],[7,2,7,3],[8,2,9,2],[13,2,13,3],[14,2,14,3],[15,2,15,3],[18,2,18,6],[19,2,19,4],[19,5,19,6],[20,2,20,4],[20,5,20,6],[21,2,21,4],[21,7,23,7],[21,9,23,9],[24,2,24,4],[26,2,35,6],[26,7,26,8],[26,9,26,10],[28,7,28,8],[28,9,28,10],[30,9,30,12],[32,7,35,12],[32,13,35,14]]}
[{"$nulls":3},0,"Do Not Meet",{"$nulls":11},"MAX",null,"Not applicable",{"v":0,"d":"0%"},{"v":0.49,"d":"49%"},"NOT MEET","0-49"]
[{"$nulls":3},1,"Partial Meet (large gap) ",{"$nulls":11},{"v":0,"d":"0%"},0,"Do Not Meet",{"v":0.5,"d":"50%"},{"v":0.59,"d":"59%"},"PARTIAL MEET","50-59"]
[{"$nulls":3},2,"Partial Meet (small gap)",{"$nulls":11},{"v":0.5,"d":"50%"},1,"Partial Meet",{"v":0.6,"d":"60%"},{"v":0.69,"d":"69%"},"PARTIAL MEET","60-69"]
[{"$nulls":3},3,"Meet",{"$nulls":11},{"v":0.75,"d":"75%"},2,"Partial Meet",{"v":0.7,"d":"70%"},{"v":1,"d":"100%"},"MEET","70-100"]
[{"$nulls":16},{"v":1,"d":"100%"},3,"Meet"]
[{"$nulls":16},{"v":1,"d":"100%"},"X","Not applicable"]
[null,null,"Functional (Technical) Evaluation Criteria for Plant Enquiry No: The Supply and delivery of OIL FYRQUEL EHC FIRE RESIST HYDRAULIC OIL"]
[null,null,"Requirements",null,"Criteria",null,"Deliverables","Weighting"," Rating","% Rating","% Rating","% Score","[ Supplier Name ] Response","[Supplier Name] Supplier Comments","Eskom Comments"]
[null,null,"1. SUPPLY OF PRODUCT",null,"Supplier must meet the delivery date as per the Koeberg requirements and initial commitment date as per the tender. ",null,"LEAD TIME\n2 – 3 weeks from order placement",{"v":0.7,"d":"70%"},null,{"v":1,"d":"100%"},{"$f":"IF(I9=$R$2,$Q$2,(IF(I9=$R$3,$Q$3,IF(I9=$R$4,$Q$4,IF(I9=$R$5,$Q$5,IF(I9=$R$6,$Q$6))))))","v":{"v":0,"d":"0%"}},{"$f":"SUM(H9*K9)","v":{"v":0,"d":"0%"}}]
[{"$nulls":4},"All supporting documents for the new Sodium Hypochlorite Electroyser must be available upon delivery of the items.",null,"Returnable = Letter of Commitment \nA letter from the supplier committing to the deliverable to be supplied.",{"v":0.3,"d":"30%"},null,{"v":1,"d":"100%"},{"$f":"IF(I10=$R$2,$Q$2,(IF(I10=$R$3,$Q$3,IF(I10=$R$4,$Q$4,IF(I10=$R$5,$Q$5,IF(I10=$R$6,$Q$6))))))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[{"$nulls":4},"TOTAL WEIGHTING",null,null,{"$f":"(SUM(H9:H10))*0.4","v":{"v":0.4,"d":"40%"}},null,{"$f":"IF(AND(K11>=$T$1,K11<=$U$1), $V$1, IF(AND(K11>=$T$2,K11<=$U$2), $V$2, IF(AND(K11>=$T$3,K11<=$U$3), $V$3, IF(K11>=$T$4,$V$4))))","v":"NOT MEET"},{"$f":"SUM(L9:L10)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,null,"2. TECHNICAL REQUIRMENTS",null,"Demonstrate ability to comply with Specifications and Requirements and user specification provided. \n\nDSG-317-012; 0110/87Q; Q4:NSF:NC:NEV; \nOIL FYRQUEL EHC FIRE RESIST HYDRAULIC OIL; \nORDER IN 208L DRUMS; \nRATING: 7071E",null,"Returnable = A letter from the supplier indicating how each specification is met and any waivers are required. \n- Technical Datasheet\n- COA upon delivery\n- SDS upon delivery",{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},{"$f":"IF(I12=$R$2,$Q$2,(IF(I12=$R$3,$Q$3,IF(I12=$R$4,$Q$4,IF(I12=$R$5,$Q$5,IF(I12=$R$6,$Q$6))))))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[{"$nulls":4},"TOTAL WEIGHTING",null,null,{"$f":"(SUM(H12:H12))*0.3","v":{"v":0.3,"d":"30%"}},null,{"$f":"IF(AND(K13>=$T$1,K13<=$U$1), $V$1, IF(AND(K13>=$T$2,K13<=$U$2), $V$2, IF(AND(K13>=$T$3,K13<=$U$3), $V$3, IF(K13>=$T$4,$V$4))))","v":"NOT MEET"},{"$f":"SUM(L12:L12)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,null,"3. QUALITY ASSURANCE PROGRAM",null,"A Quality Assurance Programme that meets the intent of a typical Quality Management System (QMS) or requirements as identified on Appendix A of 238-103 rev2 ","The returnable is a document or method statement describing the supplier Quality Programme that provide a description of the processes and supporting information that reflects how processes are managed and work/operation is prepared, reviewed, carried out, recorded, assessed and improved . Examples of processes to be described can include Resource Selection, Quality Control, Receipt Inspection, Purchasing, etc.","The returnable is a document or method statement describing the supplier Quality Programme that provide a description of the processes and supporting information that reflects how processes are managed and work/operation is prepared, reviewed, carried out, recorded, assessed and improved. Examples of processes to be described can include Resource Selection, Quality Control, Receipt Inspection, Purchasing, etc.",{"v":0.35,"d":"35%"},null,{"v":1,"d":"100%"},{"$f":"IF(I14=$R$2,$Q$2,(IF(I14=$R$3,$Q$3,IF(I14=$R$4,$Q$4,IF(I14=$R$5,$Q$5,IF(I14=$R$6,$Q$6))))))","v":{"v":0,"d":"0%"}},{"$f":"SUM(H14*K14)","v":{"v":0,"d":"0%"}}]
[null,null,"4. QUALITY CONTROL PROGRAM",null,"DSG-317-012",null,"Returnable is a sample certificate of analysis of the product requested as per DSG-317-012",{"v":0.35,"d":"35%"},null,{"v":1,"d":"100%"},{"$f":"IF(I15=$R$2,$Q$2,(IF(I15=$R$3,$Q$3,IF(I15=$R$4,$Q$4,IF(I15=$R$5,$Q$5,IF(I15=$R$6,$Q$6))))))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[null,null,"5. NONCONFORMING PRODUCT/SERVICE",null,"Control of nonconforming product and application for concession","Returnable is an example of a QCP or Quality Project Plan for a similar service or product, identifying sequential operations and indicating inspection and test points (hold and/or witness points) and areas where reports are required .","Submit a supplier Method Statement or documented procedure that defines processes followed for dealing with nonconforming product/service",{"v":0.3,"d":"30%"},null,{"v":1,"d":"100%"},{"$f":"IF(I16=$R$2,$Q$2,(IF(I16=$R$3,$Q$3,IF(I16=$R$4,$Q$4,IF(I16=$R$5,$Q$5,IF(I16=$R$6,$Q$6))))))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[{"$nulls":4},"TOTAL WEIGHTING",null,null,{"$f":"(SUM(H14:H16))*0.3","v":{"v":0.3,"d":"30%"}},null,{"$f":"IF(AND(K17>=$T$1,K17<=$U$1), $V$1, IF(AND(K17>=$T$2,K17<=$U$2), $V$2, IF(AND(K17>=$T$3,K17<=$U$3), $V$3, IF(K17>=$T$4,$V$4))))","v":"NOT MEET"},{"$f":"SUM(L14:L16)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"}]
[]
[null,null,"FINAL ANALYSIS"]
[null,null,"1. Supply of Product",{"$nulls":4},{"v":0.4,"d":"40%"},null,{"$f":"(K11*$H$20)","v":{"v":0,"d":"0%"}}]
[null,null,"2. Technical Ability",{"$nulls":4},{"v":0.3,"d":"30%"},null,{"$f":"(K13*$H$21)","v":{"v":0,"d":"0%"}}]
[null,null,"3. Quality Assurance Program",{"$nulls":4},{"v":0.3,"d":"30%"},null,{"$f":"(K17*$H$22)","v":{"v":0,"d":"0%"}}]
[null,null,"4. Quality Control Program"]
[null,null,"5. Non-Conforming Product/Service"]
[null,null,"TOTAL",{"$nulls":4},{"$f":"SUM(H20:H24)","v":{"v":1,"d":"100%"}},null,{"$f":"SUM(J20:J24)","v":{"v":0,"d":"0%"}}]
[]
[null,null,"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. Scores are allocated as follows:\n0 - 0% -    Does not meet \n1 - 50% -  Partial meet (Large gap) \n2 - 75% - Partial Meet (Small gap)\n3 - 100% - Meet\nThe score is then summed to a weighted average per category. The category scores are analysed as follows:\n0%     - 79%   - Does not meet\n80%   - 100% - Meet",{"$nulls":4},"Compile By (Technical): ",null,"Nosi Baliso               ",{"$nulls":3},"Compiled by: \n","A.Timotheus "]
[]
[{"$nulls":7},"Reviewed By (Technical) :  ",null,"Amanda Mlakalaka ",{"$nulls":3},"Signature:"]
[]
[{"$nulls":7},"Date:",{"$nulls":5},"Date: "]
[]
[{"$nulls":7},"CONCLUSION:",{"$nulls":5},"CONCLUSION:"]

{"sheet":"Sheet1","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"merged":[[2,0,2,4],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[6,0,6,2]]}
[]
[]
["FINAL ANALYSIS"]
["1. Supply of Product",{"$nulls":4},{"v":0.4,"d":"40%"}]
["2. Technical Ability",{"$nulls":4},{"v":0.3,"d":"30%"}]
["3. Quality ",{"$nulls":4},{"v":0.3,"d":"30%"}]
["TOTAL",{"$nulls":4},{"$f":"SUM(F4:F6)","v":{"v":1,"d":"100%"}}]