{"text_format":"3","workbook":"xlsx","n_sheets":20,"sheets":["Info","Cover","Sheet3","Supplier1","Supplier2","Supplier3","Supplier4","Supplier5","Supplier6","Supplier7","Supplier8","Supplier9","Supplier10","Scorecard","Evaluation Report","Requirements","Re-Evaluation ","Returnables","Sheet1","Sheet2"],"not_rendered":{"images":4,"defined_names":6,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,14,7]]}
["Information on how to use this template:\n1) On 'Cover' Tab, please select the relevant  Category by typing a 1 on one of the marked boxes (on Column D). Only one box at a time, otherwise there will be an error. \n2) Move to 'Returnables' Tab.  Applicable  requirements for the selected category will automatically be denoted by 1, whereas  the un-applicable requirements  will be denoted  by 0.(on Column D)\n3) You may hide the rows with un-applicable requirements.\n4) Complete  the  rest of the required details. \n5) Save in PDF and sign. Or preferably  you may sign and lock the sheet before sending to the buyer.\nNB: Print-area might shift as information is populated. Adjustment may be made  to fit to 1  page."]

{"sheet":"Cover","index":1,"n_rows":86,"n_cols":83,"rows_kept":86,"merged":[[2,31,2,32],[2,55,2,56],[2,70,2,71],[2,78,2,79],[5,7,6,21],[7,7,8,21],[9,7,10,21],[11,7,12,21],[27,31,27,32],[27,55,27,56],[27,70,27,71],[27,78,27,79],[29,31,29,32],[29,55,29,56],[29,70,29,71],[29,78,29,79],[35,0,35,5],[35,6,35,9],[36,0,37,9],[38,0,38,4],[39,0,39,8],[40,0,40,8],[41,0,41,8],[42,0,42,8],[43,0,43,4],[44,0,45,8],[44,9,45,9],[46,0,46,8],[47,0,47,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,4],[56,0,56,8],[57,0,57,4],[58,0,58,8],[59,0,59,8],[60,0,60,8],[61,0,61,8],[62,0,62,8],[63,0,63,8],[64,0,64,8],[65,0,65,8],[66,0,66,4],[68,0,69,9],[70,0,70,8],[71,0,71,8],[72,0,72,4],[74,0,75,9],[76,0,76,8],[77,0,77,8],[78,0,78,4],[80,0,81,9],[82,0,82,4],[83,0,83,8],[84,0,84,8],[85,0,85,4]]}
[{"$nulls":3},"TYPES OF CATEGORY",{"$nulls":18},0,null,null,"Scoring criteria",{"$f":"IF(SUM($D$6:$D$24)=0,0,(AA6*$D$6)+(AA8*$D$8)+(AA10*$D$10)+(AA12*$D$12)+(AA14*$D$14)+(AA16*$D$16)+(AA18*$D$18)+(AA20*$D$20)+(AA22*$D$22)+(AA24*$D$24))","v":0},{"$f":"IF(SUM($D$6:$D$24)=0,0,(AB6*$D$6)+(AB8*$D$8)+(AB10*$D$10)+(AB12*$D$12)+(AB14*$D$14)+(AB16*$D$16)+(AB18*$D$18)+(AB20*$D$20)+(AB22*$D$22)+(AB24*$D$24))","v":0},0,0,1,1,1,0,0,0,0,0,1,1,{"$f":"IF(SUM($D$6:$D$24)=0,0,(AO6*$D$6)+(AO8*$D$8)+(AO10*$D$10)+(AO12*$D$12)+(AO14*$D$14)+(AO16*$D$16)+(AO18*$D$18)+(AO20*$D$20)+(AO22*$D$22)+(AO24*$D$24))","v":0},{"$f":"IF(SUM($D$6:$D$24)=0,0,(AP6*$D$6)+(AP8*$D$8)+(AP10*$D$10)+(AP12*$D$12)+(AP14*$D$14)+(AP16*$D$16)+(AP18*$D$18)+(AP20*$D$20)+(AP22*$D$22)+(AP24*$D$24))","v":0},{"$f":"IF(SUM($D$6:$D$24)=0,0,(AQ6*$D$6)+(AQ8*$D$8)+(AQ10*$D$10)+(AQ12*$D$12)+(AQ14*$D$14)+(AQ16*$D$16)+(AQ18*$D$18)+(AQ20*$D$20)+(AQ22*$D$22)+(AQ24*$D$24))","v":0},0,0,0,{"$f":"IF(SUM($D$6:$D$24)=0,0,(AU6*$D$6)+(AU8*$D$8)+(AU10*$D$10)+(AU12*$D$12)+(AU14*$D$14)+(AU16*$D$16)+(AU18*$D$18)+(AU20*$D$20)+(AU22*$D$22)+(AU24*$D$24))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM($D$6:$D$24)=0,0,(BN6*$D$6)+(BN8*$D$8)+(BN10*$D$10)+(BN12*$D$12)+(BN14*$D$14)+(BN16*$D$16)+(BN18*$D$18)+(BN20*$D$20)+(BN22*$D$22)+(BN24*$D$24))","v":0},0,0,0,0,0,0,0,1,1,0,0,0,"n/a","n/a","n/a","n/a","n/a"]
[{"$nulls":22},1]
[{"$nulls":3},"Type 1 in the block to select the applicable  type of Category ",{"$nulls":7},"(Select only one box or you will see \"Error\" in colum B)",{"$nulls":17},"Section A",null,{"$f":"IF($K$30=1,AF30,AF28)","v":{"v":0.25,"d":"25%"}},{"$nulls":10},"Section B",null,null,{"$f":"IF($K$30=1,AT30,AT28)","v":{"v":0.25,"d":"25%"}},{"$nulls":6},"Section C",null,null,{"$f":"IF($K$30=1,BD30,BD28)","v":{"v":0.2,"d":"20%"}},{"$nulls":11},"Section D",null,null,{"$f":"IF($K$30=1,BS30,BS28)","v":{"v":0.2,"d":"20%"}},{"$nulls":4},"Section E",null,null,{"$f":"IF($K$30=1,CA30,CA28)","v":{"v":0.09999999999999998,"d":"10%"}}]
[{"$nulls":27},"Option 1",{"$nulls":3},"Option 2"]
[{"$nulls":26},"A.1","A.2","A3","A4","A.1","A.2","A.3","A.4","A.5","A.6","A.7","A.8","B.1","B.2","B3","B4","B5","B.6","B.7","B.8","C.1","C.2","C.3","C.4","C.5","C.6","C.7","C.8","C.9","C.10","C.11","C.12","C.13","C.14","C.15","C.16","C.17","C.18","C.19","D.1","D.2","D3","D4","D5","D.6","D.7","D.8","E.1","E.2","E3","E4","E5","E.6","E.7","E.8","E.9","E.10"]
[null,{"$f":"IF(AND(D6=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,null,"Category 1",null,"Form A,  ISO certificate, Internal and External management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports), Draft CQP and IPT as per Scope of Works (Ref ISO 10005),   information for defined roles, responsibilities and authorities.",{"$nulls":14},{"$f":"IF(D6=1,\"Y\",\"\")","v":""},"Category 1",null,null,1,1,1,1,0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D8=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,null,"Category 2",null,"Form A, Implemented Quality Management System, Internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports), Draft CQP and IPT  as per Scope of Works (Ref ISO 10005),  information for defined roles, responsibilities and authorities.",{"$nulls":14},{"$f":"IF(D8=1,\"Y\",\"\")","v":""},"Category 2",null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D10=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,null,"Category 3",null,"Form A, Implemented Quality Management System, Internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports), Draft CQP and IPT  as per Scope of Works (Ref ISO 10005),  information for defined roles, responsibilities and authorities.",{"$nulls":14},{"$f":"IF(D10=1,\"Y\",\"\")","v":""},"Category 3",null,null,0,0,0,0,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D12=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},1,null,"Category 4",null,"Form A,  Method Statement based on Scope of Work, information for defined roles, responsibilities and authorities, Quality Objectives and Quality Policy",{"$nulls":14},{"$f":"IF(D12=1,\"Y\",\"\")","v":"Y"},"Category 4",null,null,0,0,0,0,1,1,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D14=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,{"$nulls":18},{"$f":"IF(D14=1,\"Y\",\"\")","v":""},{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D16=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,{"$nulls":22},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":74},1]
[null,{"$f":"IF(AND(D18=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,{"$nulls":18},{"$f":"IF(D18=1,\"Y\",\"\")","v":""},{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D20=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,{"$nulls":18},{"$f":"IF(D20=1,\"Y\",\"\")","v":""},{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D22=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,{"$nulls":22},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"IF(AND(D24=1,SUM($D$6:$D$24)>1)=TRUE,\"Error\",\"\")","v":""},{"$f":"IF((SUM($D$6:$D$24))=0,\"?\",\"\")","v":""},0,{"$nulls":18},{"$f":"IF(D24=1,\"Y\",\"\")","v":""},{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Do you need to change the weights of any of the sections",{"$nulls":9},"SECTIONS","A","B","C","D","E",{"$nulls":8},"Standard weights",{"$nulls":3},"Section A",null,{"v":0.25,"d":"25%"},{"$nulls":9},"Section B",{"$nulls":3},{"v":0.25,"d":"25%"},{"$nulls":6},"Section C",null,null,{"v":0.2,"d":"20%"},{"$nulls":11},"Section D",null,null,{"v":0.2,"d":"20%"},{"$nulls":4},"Section E",null,null,{"$f":"1-AF28-AT28-BD28-BS28","v":{"v":0.09999999999999998,"d":"10%"}}]
[{"$nulls":11},"The following are the standard weightings per Section that would apply unless  altered ==>",{"$f":"AF3","v":{"v":0.25,"d":"25%"}},{"$f":"AT3","v":{"v":0.25,"d":"25%"}},{"$f":"BD3","v":{"v":0.2,"d":"20%"}},{"$f":"BS3","v":{"v":0.2,"d":"20%"}},{"$f":"CA3","v":{"v":0.09999999999999998,"d":"10%"}}]
[{"$nulls":9},"Select 0 to use normal weights. Select 1 to modify section weights:",0,"New weights",{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"$f":"IF(K30=1,IF(SUM(M30:Q30)=1,100%,\"Incorrect weights\"),\"\")","v":""},{"$nulls":7},"Revised weights",{"$nulls":5},{"$f":"IF(AND($K$30=1,$R$30=1)=TRUE,M30,AF28)","v":{"v":0.25,"d":"25%"}},{"$nulls":13},{"$f":"IF(AND($K$30=1,$R$30=1)=TRUE,N30,AT28)","v":{"v":0.25,"d":"25%"}},{"$nulls":9},{"$f":"IF(AND($K$30=1,$R$30=1)=TRUE,O30,BD28)","v":{"v":0.2,"d":"20%"}},{"$nulls":14},{"$f":"IF(AND($K$30=1,$R$30=1)=TRUE,P30,BS28)","v":{"v":0.2,"d":"20%"}},{"$nulls":7},{"$f":"IF(AND($K$30=1,$R$30=1)=TRUE,Q30,CA28)","v":{"v":0.09999999999999998,"d":"10%"}}]
[]
[]
[null,"Do you need to change any scoring indicators"]
[{"$nulls":9},"Select 0 to use applicable indicatiors. Select 1 to modify scoring indicators:",0]
[{"$nulls":11},"Important "]
["QUALITY REQUIREMENTS",{"$nulls":5},"Deliverables to be submitted = 1",{"$nulls":4},"If you have selected 1 to change scoring indicators,"]
["SECTION A\nQuality Management System Requirements ISO 9001:2015 (Ref 240-105658000 or 240-51544462)",{"$nulls":10},"then you need to select 0 to the relevant boxes below that is not relevant"]
[]
[{"$nulls":9},"Apply (Yes=1)",null,"Please ensure that you can explain to auditors why you excluded any of the indicators"]
["A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":8},{"$f":"AA1","v":0},0]
["A.2 Certificate by Approved and Authorized certification authority",{"$nulls":8},{"$f":"AB1","v":0},0]
["A.3 Certification  Authority is has Recognized International Accreditation ",{"$nulls":8},{"$f":"AC1","v":0},0]
["A.4 Validity (expiry date) of certificate",{"$nulls":8},{"$f":"AD1","v":0},0]
["Sub-Section A Score Option 1",{"$nulls":8},{"$f":"SUM(J40:J43)","v":0}]
["SECTION A\nQuality Management System Requirements ISO 9001 2015 (Ref 240-105658000 or 240-51544462)",{"$nulls":8},"OR"]
[]
["A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement.",{"$nulls":8},{"$f":"AE1","v":1},0]
["A.2 Quality Policy Approved by top management.",{"$nulls":8},{"$f":"AF1","v":1},0]
["A.3 Quality Objectives Approved by top management.",{"$nulls":8},{"$f":"AG1","v":1},0]
["A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":8},0,0]
["A.4 Control of documented information (i.e. document and record control) \nClause 7.5 of ISO 9001:2015",{"$nulls":8},{"$f":"AI1","v":0},0]
["A.5 Documented information for Control of nonconforming outputs \nClause 8.7 of ISO 9001:2015",{"$nulls":8},{"$f":"AJ1","v":0},0]
["A.6 Documented information for Nonconformity and Corrective action \nClause 10.2 of ISO 9001:2015",{"$nulls":8},{"$f":"AK1","v":0},0]
["A.7 Documented information for Internal audit \nClause 9.2 of ISO 9001:2015",{"$nulls":8},{"$f":"AL1","v":0},0]
["Sub-Section A Score Option 2",{"$nulls":8},{"$f":"SUM(J47:J54)","v":3}]
[]
["SECTION B\nEvidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":9},"Apply (Yes=1)"]
["B.1 Documented information for defined roles, responsibilities and authorities - Organization chart and Responsibility matrix (must include but not limitted to quality management function/role) \n(Clause 5.3 of ISO 9001:2015) ",{"$nulls":8},{"$f":"AM1","v":1},0]
["B.2 Documented information for Control of Externally Provided Processes, Products and Services  - Must include criteria for evaluation, selection, monitoring of performance, and re-evaluation of external providers (Clause 8.4 of ISO 9001:2015)",{"$nulls":8},{"$f":"AN1","v":1},0]
["B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports) - Report must include but not limited to Objective, Scope, Criteria and outcomes  of the audit.  \n(Clause 9.2 of ISO 9001:2015)",{"$nulls":8},{"$f":"AO1","v":0},0]
["B.4 Latest copy of a certification management system audit report not older  than 12 months (with Nonconformity, Correction and/ or Corrective Action Reports)B.4 Latest copy of a certification management system audit report not older  than 12 months (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":8},{"$f":"AP1","v":0},0,null," "]
["B.5 Records of Management Review meetings (minutes, attendance registers etc)",{"$nulls":8},{"$f":"AQ1","v":0},0]
[{"$nulls":10},0]
[{"$nulls":10},0]
[{"$nulls":10},0]
["Section B Score",{"$nulls":8},{"$f":"SUM(J59:J66)","v":2}]
[]
["SECTION C\nContract Quality Plan Requirements (Ref 240-105658000 and 240-109253698). "]
[]
["Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)",{"$nulls":8},"Apply (Yes=1)"]
["NB!   Draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":8},{"$f":"AU1","v":0},0]
["Section C Score",{"$nulls":8},{"$f":"SUM(J72:J72)","v":0}]
[]
["SECTION D\nQuality Control Plan Requirements (Ref 240-105658000 Annexure I or 240-51544462)"]
[]
["QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)",{"$nulls":8},"Apply (Yes=1)"]
["NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done",{"$nulls":8},{"$f":"BN1","v":0},0]
["Section D Score",{"$nulls":8},{"$f":"SUM(J78:J78)","v":0}]
[]
["SECTION E\nUser defined additional Requirements & miscellaneous (Ref 240-105658000)\nCustomer specific requirements & other standards and required can be listed and evaluated here"]
[]
[{"$nulls":9},"Apply (Yes=1)"]
["E.1 Form A is completed and signed.",{"$nulls":8},{"$f":"BV1","v":1},0]
["Certification of accredited workshop or an agreement that confirms access to an accredited workshop with capacity to provide service to Gauteng, Limpopo and Mpumalanga regions",{"$nulls":8},1,0]
["Section E Score",{"$nulls":8},{"$f":"SUM(J84:J85)","v":2}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Supplier1","index":3,"n_rows":85,"n_cols":14,"rows_kept":85,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,3,13,6],[13,7,13,8],[14,1,14,2],[14,3,14,6],[14,7,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[17,3,17,6],[17,7,17,8],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,40,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,8],[30,9,31,9],[31,1,31,8],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[44,2,44,8],[44,9,45,9],[44,10,45,10],[46,1,46,5],[46,11,46,15],[47,1,47,5],[47,10,51,10],[47,11,47,15],[48,1,48,5],[48,11,48,15],[49,1,49,5],[49,11,49,15],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[57,2,57,8],[58,1,58,7],[58,8,59,8],[58,9,59,9],[58,10,59,10],[59,1,59,7],[60,1,60,5],[61,1,61,5],[61,10,63,10],[62,1,62,5],[63,1,63,5],[65,2,65,8],[66,1,66,7],[66,8,68,8],[66,9,68,9],[66,10,68,10],[67,1,67,7],[68,1,68,7],[69,1,69,5],[70,1,70,5],[70,10,71,10],[71,1,71,5],[72,1,72,5],[74,2,74,8],[75,1,75,7],[75,8,76,8],[75,9,76,9],[75,10,76,10],[76,1,76,7],[77,1,77,5],[78,1,78,5],[78,10,79,10],[79,1,79,5],[80,1,80,5],[81,1,81,5],[84,1,84,5],[85,1,85,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,"240-12248652",null,null,"Select 0 if N/A","Score","Rev 1 for 1st Desktop Evaluation"]
[{"$nulls":6},"Additional Specification",null,"240-105658000",null,null,0,0,"Rev 2 for 2nd Desktop Evaluation (Clarifications)"]
[{"$nulls":3},"Supplier Quality Management",null,null,"Quality Scorecard\nRev 7",null,"Effective Date 21/01/2022","Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"DATE(2022,1,12)","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,"*","PQA Representative(s):",null,"*"]
[null,"Eskom Buyer",null,"*",null,null,"eg: Senior Advisor: Supplier Quality Management",null,null,"Important Notice"]
[null,"Eskom Project Manager",{"$nulls":4},"Report Revision",null,1,"Scoring for Section A"]
[null,"Project",null,"*",{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,"*",{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor/Supplier Name",null,"*",{"$nulls":3},"Quality Representative",null," will display value = FALSE"]
[null,"Project Manager Name",{"$nulls":7}," or if all scores = 0 then value = 0"]
[null,"Supplier Address"]
[null,"Contact details:           email",{"$nulls":3},"Phone & Fax:"]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$nulls":3},{"$f":"I3","v":"240-105658000"}]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Cover!AF30","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001 ",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Yes=1","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Requirements!G10","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Requirements!G11","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Requirements!G12","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Requirements!G13","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},0,{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G29=0,0,H29/$G$29/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G29=0,0,I29/$G$29/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements: Ref 240-105658000)"]
[{"$nulls":6},"Apply Yes=1","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Requirements!G19","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Requirements!G20","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Requirements!G21","v":1},null,null," "]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},0,null,null," ",null," "]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Requirements!G23","v":0},null,null," "]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Requirements!G24","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Requirements!G25","v":0},null,null," "]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Requirements!G26","v":0},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G34:G41)","v":3},{"$f":"($G34*H34)+($G36*H36)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+(G35*H35)","v":0},{"$f":"($G34*I34)+($G36*I36)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+(G35*I35)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G42=0,0,H42/$G$42/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G42=0,0,I42/$G$42/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B: Evidence of QMS in operation (Tender Quality Requirements: Ref 240-105658000)",{"$nulls":6},{"$f":"Cover!AT30","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Yes=1","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Requirements!G31","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Requirements!G32","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Requirements!G33","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Requirements!G34","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Cover!J63","v":0},null,null," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G48:G52)","v":2},{"$f":"($G48*H48)+($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)","v":0},{"$f":"($G48*I48)+($G49*I49)+($G50*I50)+($G51*I51)","v":0}]
[null,"Section B: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G55=0,0,H55/$G$55/2*100%*$I$46)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G55=0,0,I55/$G$55/2*100%*$I$46)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-109253698 CQP). ",{"$nulls":6},{"$f":"Cover!BD30","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Yes=1","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!   Draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Requirements!G47","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G62)","v":0},{"$f":"($G62*H62)","v":0},{"$f":"($G62*I62)","v":0}]
[null,"Section C: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G63=0,0,H63/$G$63/2*100%*$I$59)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G63=0,0,I63/$G$63/2*100%*$I$59)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Cover!BS30","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Yes=1","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Requirements!G53","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G71)","v":0},{"$f":"($G71*H71)","v":0},{"$f":"($G71*I71)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G72=0,0,H72/$G$72/2*100%*$I$67)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G72=0,0,I72/$G$72/2*100%*$I$67)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I46-I59-I67","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Yes=1","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Requirements!G59","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Requirements!G60","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G79:G80)","v":2},{"$f":"($G79*H79)+($G80*H80)","v":0},{"$f":"($G79*I79)+($G80*I80)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G81=0,0,H81/$G$81/2*100%*$I$76)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G81=0,0,I81/$G$81/2*100%*$I$76)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier2","index":4,"n_rows":90,"n_cols":13,"rows_kept":90,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,20,8],[21,1,21,4],[21,5,21,7],[22,1,22,8],[22,9,23,9],[22,10,23,10],[23,1,23,8],[24,1,24,5],[25,1,25,5],[25,10,41,10],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[89,1,89,5],[90,1,90,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier1!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier1!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier1!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier1!G8","v":"Report Revision"},null,{"$f":"Supplier1!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:"]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier1!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001 ",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0},null,null," "]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0},null,null," "]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G26:G29)","v":0},{"$f":"($G26*H26)+($G27*H27)+($G28*H28)+($G29*H29)","v":0},{"$f":"($G26*I26)+($G27*I27)+($G28*I28)+($G29*I29)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$22)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$22)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001 ",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":10}," "]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1},null,null," "]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0},null,null," "]
[null,"A.4Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0},null,null," "]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0},null,null," "]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0},null,null," "]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$22)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$22)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,{"$f":"Supplier1!B46","v":"SECTION B: Evidence of QMS in operation (Tender Quality Requirements: Ref 240-105658000)"},{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0},null,null," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,{"$f":"Supplier1!B59","v":"SECTION C: Contract Quality Plan Requirements (Ref 240-109253698 CQP). "},{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,{"$f":"Supplier1!B67","v":"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)"},{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,{"$f":"Supplier1!B69","v":"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,{"$f":"Supplier1!B76","v":"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )"},{"$nulls":6},{"$f":"1-I22-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier3","index":5,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier2!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier2!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier1!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier2!G8","v":"Report Revision"},null,{"$f":"Supplier2!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:"]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier2!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001 ",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0},null,null," "]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0},null,null," "]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0}]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0}]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0}]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0}]
[]
[]
[]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier4","index":6,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier3!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier3!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier3!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier3!G8","v":"Report Revision"},null,{"$f":"Supplier3!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:"]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier3!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0},null,null," "]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0},null,null," "]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0},null,null," "]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0},null,null," "]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0},null,null," "]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0},null,null," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9},"Extensive list of similar projects"]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier5","index":7,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier4!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier4!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier4!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier4!G8","v":"Report Revision"},null,{"$f":"Supplier4!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",{"$nulls":7}," or if all scores = 0 then value = 0"]
[null,"Supplier Address"]
[null,"Contact details:           email",{"$nulls":3},"Phone & Fax:"]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier4!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0},null,null," "]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0},null,null," "]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0},null,null," "]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0},null,null," "]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0},null,null," "]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0},null,null," "]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0},null,null," "]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0},null,null," "]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0},null,null," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier6","index":8,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier5!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier5!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier5!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier5!G8","v":"Report Revision"},null,{"$f":"Supplier5!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:"]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier5!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0}]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0}]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0}]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0}]
[]
[]
[]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier7","index":9,"n_rows":90,"n_cols":13,"rows_kept":90,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[89,1,89,5],[90,1,90,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier6!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier6!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier6!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier6!G8","v":"Report Revision"},null,{"$f":"Supplier6!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:",null," "," "]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier6!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0}]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0}]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0}]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0}]
[]
[]
[]
[{"$nulls":6},{"$f":"Supplier1!G52","v":0},null,null," "]
[{"$nulls":6},{"$f":"Supplier1!G53","v":0},null,null," "]
[{"$nulls":6},{"$f":"Supplier1!G54","v":0}]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier8","index":10,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier7!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier7!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier7!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier7!G8","v":"Report Revision"},null,{"$f":"Supplier7!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:",null," "," "]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier7!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0}]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0}]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0}]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0}]
[]
[]
[]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier9","index":11,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,2,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier8!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier8!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier8!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier8!G8","v":"Report Revision"},null,{"$f":"Supplier8!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:",null," "," "]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier8!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0}]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0}]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0}]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0}]
[]
[]
[]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Supplier10","index":12,"n_rows":89,"n_cols":13,"rows_kept":89,"hidden":true,"merged":[[1,1,4,2],[1,3,1,5],[1,6,1,7],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[5,6,5,8],[6,1,6,2],[6,3,6,5],[6,6,6,8],[7,1,7,2],[7,3,7,5],[7,6,7,7],[8,1,8,2],[8,3,8,8],[9,1,11,2],[9,3,11,8],[12,1,12,8],[13,1,13,2],[13,3,13,5],[13,6,13,8],[14,1,14,2],[14,3,14,5],[14,6,14,8],[15,1,15,2],[15,3,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[17,1,17,2],[18,2,18,8],[19,1,19,8],[20,1,20,4],[20,5,20,7],[21,1,21,8],[21,9,22,9],[21,10,22,10],[22,1,22,8],[23,1,23,5],[24,1,24,5],[24,10,41,10],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[30,1,30,5],[31,1,31,8],[31,9,32,9],[32,1,32,8],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[45,2,45,8],[45,9,46,9],[45,10,46,10],[47,1,47,5],[48,1,48,5],[48,10,55,10],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[62,2,62,8],[63,1,63,7],[63,8,64,8],[63,9,64,9],[63,10,64,10],[64,1,64,7],[65,1,65,5],[66,1,66,5],[66,10,68,10],[67,1,67,5],[68,1,68,5],[70,2,70,8],[71,1,71,7],[71,8,73,8],[71,9,73,9],[71,10,73,10],[72,1,72,7],[73,1,73,7],[74,1,74,5],[75,1,75,5],[75,10,76,10],[76,1,76,5],[77,1,77,5],[79,2,79,8],[80,1,80,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[81,1,81,7],[82,1,82,5],[83,1,83,5],[83,10,84,10],[84,1,84,5],[85,1,85,5],[86,1,86,5],[88,1,88,5],[89,1,89,5]]}
[]
[{"$nulls":3},"Quality Management",null,null,"Unique ID",null,{"$f":"Supplier9!I2","v":"240-12248652"},null,null,"Select 0 if N/A","Score"]
[{"$nulls":6},"Additional Specification",null,{"$f":"Supplier9!I3","v":"240-105658000"},null,null,0,0]
[{"$nulls":3},"Supplier Quality Management",null,null,{"$f":"Supplier1!G4:H4","v":"Quality Scorecard\nRev 7"},null,{"$f":"Supplier1!I4","v":"Effective Date 21/01/2022"},"Access only to                                      \nUNPROTECTED INPUT FIELDS",null,1,1]
[{"$nulls":3},"Tender Evaluation Scorecard ",null,null,"Evaluation done on…",null,{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},2]
[null,"Tender No",null,{"$f":"Supplier1!D6","v":"*"},"PQA Representative(s):",null,{"$f":"Supplier1!G6","v":"*"}]
[null,"Eskom Buyer",null,{"$f":"Supplier1!$D$7","v":"*"},null,null,{"$f":"Supplier9!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"Important Notice"]
[null,"Eskom Project Manager",null,{"$f":"Supplier1!$D$8","v":0},null,null,{"$f":"Supplier9!G8","v":"Report Revision"},null,{"$f":"Supplier9!I8","v":1},"Scoring for Section A"]
[null,"Project",null,{"$f":"Supplier1!$D$9","v":"*"},{"$nulls":5},"Choose only the relevant"]
[null,"Scope of Work",null,{"$f":"Supplier1!$D$10","v":"*"},{"$nulls":5},"option 1 or 2, to do the rating."]
[{"$nulls":9},"(If more options of Section A has"]
[{"$nulls":9},"scores ,  then the score column G"]
[null,"CONTRACTOR / SUPPLIER",{"$nulls":7}," in the Integrated scorecard matrix "]
[null,"Contractor  Supplier Details",{"$nulls":4},"Quality Representative",null,null," will display value = FALSE"]
[null,"Project manager",null," ",{"$nulls":5}," or if all scores = 0 then value = 0"]
[null,"Supplier Address",null," "]
[null,"Contact details:           email",null," ",null,"Phone & Fax:",null," "," "]
[null,"Reference Documents",null,"Supplier Contract Quality Requirements Specification ",{"$f":"Supplier9!E18","v":0},"QM28 request Y/N","N","Valuation report Y/N","Y"]
[null,null,"Supplier Quality Management, Tender Evaluation, Section A"]
[null,"The tender evaluation weighted scores below indicate the criteria to be used for the evaluation of quality documentation to be submitted with tender"]
[null,"DOCUMENT REQUIREMENTS",{"$nulls":3},"WEIGHT AND SCORE % RESULTS",null,null,{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body as per the scope of works"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"Supplier1!G25","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Supplier1!G26","v":0}]
[null,"A.3 Certification  Authority is has Recognized International Accreditation.",{"$nulls":4},{"$f":"Supplier1!G27","v":0}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Supplier1!G28","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"Supplier1!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G25:G28)","v":0},{"$f":"($G25*H25)+($G26*H26)+($G27*H27)+($G28*H28)","v":0},{"$f":"($G25*I25)+($G26*I26)+($G27*I27)+($G28*I28)","v":0}]
[null,"Sub-Section A (Option 1) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G30=0,0,H30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G30=0,0,I30/$G$30/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":7},"Please list your observations during evaluation of the tender deliverables"]
[null,"(Option 2)    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables"]
[null,"A.1 QMS Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on scope.",{"$nulls":4},{"$f":"Supplier1!G34","v":1}]
[null,"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G35","v":1}]
[null,"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Supplier1!G36","v":1}]
[null,"A.4 Records required by ISO 9001 standard (List of Records)",{"$nulls":4},{"$f":"Supplier1!G37","v":0}]
[null,"A.4 Control of documented information",{"$nulls":4},{"$f":"Supplier1!G38","v":0}]
[null,"A.5 Documented information for Control of nonconforming outputs",{"$nulls":4},{"$f":"Supplier1!G39","v":0}]
[null,"A.6 Documented information for Nonconformity and Corrective action ",{"$nulls":4},{"$f":"Supplier1!G40","v":0}]
[null,"A.7 Documented information for Internal audit ",{"$nulls":4},{"$f":"Supplier1!G41","v":0}]
[null,"Sub-Section A Score",{"$nulls":4},{"$f":"SUM(G35:G42)","v":3},{"$f":"($G35*H35)+($G37*H37)+($G38*H38)+($G39*H39)+($G40*H40)+($G41*H41)+($G42*H42)+(G36*H36)","v":0},{"$f":"($G35*I35)+($G37*I37)+($G38*I38)+($G39*I39)+($G40*I40)+($G41*I41)+($G42*I42)+(G36*I36)","v":0}]
[null,"Sub-Section A (Option 2) Result as Percentage = Score Obtained over Maximum Score Allocated x 100 % X Weight",{"$nulls":5},{"$f":"IF(G43=0,0,H43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G43=0,0,I43/$G$43/2*100%*$I$21)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section B",{"$nulls":6},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"SECTION B :           Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000 or 240-51544462)",{"$nulls":6},{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}}]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"B.1 Documented information for defined roles, responsibilities and authorities",{"$nulls":4},{"$f":"Supplier1!G48","v":1}]
[null,"B.2 Documented information for Control of Externally Provided Processes, Products and Services",{"$nulls":4},{"$f":"Supplier1!G49","v":1}]
[null,"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G50","v":0}]
[null,"B.4 Latest copy of an external management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Supplier1!G51","v":0}]
[null,{"$f":"Cover!A63","v":"B.5 Records of Management Review meetings (minutes, attendance registers etc)"},{"$nulls":4},{"$f":"Supplier1!G52","v":0}]
[]
[]
[]
[{"$nulls":9}," "]
[{"$nulls":9}," "]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G49:G59)","v":2},{"$f":"($G49*H49)+($G50*H50)+($G51*H51)+($G52*H52)+($G53*H53)+($G55*H55)+($G56*H56)+($G57*H57)+(G54*H54)","v":0},{"$f":"($G49*I49)+($G50*I50)+($G51*I51)+($G52*I52)+($G53*I53)+($G55*I55)+($G56*I56)+($G57*I57)+(G54*I54)","v":0}]
[null,"Section B:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G60=0,0,H60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G60=0,0,I60/$G$60/2*100%*$I$47)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section C"]
[null,"SECTION C: Contract Quality Plan Requirements (Ref 240-105658000 and 240-109253698 CQP). ",{"$nulls":6},{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Draft Contract Quality Plan specific to the scope of work as described in the tender documents (Ref ISO 10005)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Supplier1!G62","v":0}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G67:G67)","v":0},{"$f":"($G67*H67)","v":0},{"$f":"($G67*I67)","v":0}]
[null,"Section C:       Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G68=0,0,H68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G68=0,0,I68/$G$68/2*100%*$I$64)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section D"]
[null,"SECTION D : Quality Control Plan Requirements (Ref 240-105658000 or 240-109253302 ITP)",{"$nulls":6},{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"NB! Example of an Inspection and Test Plan (ITP) or Quality Control Plan (QCP) on similar and/ or previous work done"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & 240-105658000)"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"Supplier1!G71","v":0}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G76:G76)","v":0},{"$f":"($G76*H76)","v":0},{"$f":"($G76*I76)","v":0}]
[null,"Section D:    Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G77=0,0,H77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G77=0,0,I77/$G$77/2*100%*$I$72)","v":{"v":0,"d":"0.0%"}}]
[]
[null,null,"Supplier Quality Management, Tender Evaluation, Section E"]
[null,"SECTION E: User defined additional Requirements & miscellaneous (Ref 240-105658000 )",{"$nulls":6},{"$f":"1-I21-I47-I64-I72","v":{"v":0.09999999999999998,"d":"10%"}},"Please list your observations during evaluation of the tender deliverables","Please list your Summary of Evaluation Results"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated in this section"]
[{"$nulls":6},"Apply Y/N","First score","Final","Observations from tender deliverables","Summary of Evaluation Results"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Supplier1!G79","v":1}]
[null,"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Supplier1!G80","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G84:G85)","v":2},{"$f":"($G84*H84)+($G85*H85)","v":0},{"$f":"($G84*I84)+($G85*I85)","v":0}]
[null,"Section E: Result Percentage = Score obtained over Maximum Score allocated X 100 % X Weight",{"$nulls":5},{"$f":"IF(G86=0,0,H86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(G86=0,0,I86/$G$86/2*100%*$I$81)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Clarification Items list  (List  clarifications requested and response of suppliers)"]

{"sheet":"Scorecard","index":13,"n_rows":19,"n_cols":21,"rows_kept":19,"hidden":true,"merged":[[0,16,0,17],[0,18,0,20],[1,2,1,5],[1,8,1,9],[1,11,1,12],[1,14,1,15],[1,17,1,18]]}
[null,"QM 58   Scorecard",{"$nulls":4},"(NO Access  All fields are protected fields)",{"$nulls":9},"Tender Nr:",null,{"$f":"Supplier1!$D$6","v":"*"}]
[null,"Supplier Info","SECTION A                                                                                                                                                              ISO 9001 : 2015 or documented QMS that is ISO 9001 compliant                                                                                                                               You can only score one of the options, others must be zero ",{"$nulls":3},{"$f":"Supplier1!$I$21","v":{"v":0.25,"d":"25%"}},null,"SECTION  B                                                                      Additional Tender Requirements",null,{"$f":"Supplier1!$I$46","v":{"v":0.25,"d":"25%"}},"SECTION  C                               Contract Quality Plan",null,{"$f":"Supplier1!$I$59","v":{"v":0.2,"d":"20%"}},"SECTION  D                             Quality Control Plan ",null,{"$f":"Supplier1!$I$67","v":{"v":0.2,"d":"20%"}},"SECTION  E                           Miscellaneous Quality Requirements",null,{"$f":"Supplier1!I76","v":{"v":0.09999999999999998,"d":"10%"}},"Total 100%"]
[null,null,"Clause 3.2 Option 1","Score","Clause 3.2 Option 2 ","Score","Total for Section A","logic for Section A","Clause 3.2.1","Score","Total for Section B","Clause 3.2.2","Score","Total for Section C","Clause 3.2.2 ","Score","Total for Section D","Clause 3.2 ","Score","Total for Section E","Total score"]
[1,{"$f":"Supplier1!$D$14","v":"*"},{"$f":"Supplier1!$G$29","v":0},{"$f":"IF(Supplier1!$I$30>0,Supplier1!$I$29,IF(Supplier1!$H$30>0,Supplier1!$H$29,0))/2","v":0},{"$f":"Supplier1!$G$42","v":3},{"$f":"IF(Supplier1!$I$43>0,Supplier1!$I$42,IF(Supplier1!$H$43>0,Supplier1!$H$42,0))/2","v":0},{"$f":"IF(H4=0,0,IF(H4=1,D4/C4*$G$2,IF(H4=2,F4/E4*$G$2,IF(C4=0,0,IF(E4=0,0,0)))))","v":{"v":0,"d":"0.0%"}},{"$f":"IF(AND(D4>0,F4=0),1,IF(AND(F4>0,D4=0),2,IF(AND(D4=0,F4=0),0)))","v":0},{"$f":"Supplier1!$G$55","v":2},{"$f":"IF(Supplier1!$I$56>0,Supplier1!$I$55,IF(Supplier1!$H$56>0,Supplier1!$H$55,0))/2","v":0},{"$f":"IF(I4=0,0,(J4/I4*$K$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier1!$G$63","v":0},{"$f":"IF(Supplier1!$I$64>0,Supplier1!$I$63,IF(Supplier1!$H$64>0,Supplier1!$H$63,0))/2","v":0},{"$f":"IF(L4=0,0,(M4/L4*$N$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier1!$G$72","v":0},{"$f":"IF(Supplier1!$I$73>0,Supplier1!$I$72,IF(Supplier1!$H$73>0,Supplier1!$H$72,0))/2","v":0},{"$f":"IF(O4=0,0,(P4/O4*$Q$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier1!$G$81","v":2},{"$f":"IF(Supplier1!$I$82>0,Supplier1!$I$81,IF(Supplier1!$H$82>0,Supplier1!$H$81,0))/2","v":0},{"$f":"IF(R4=0,0,(S4/R4*$T$2))","v":{"v":0,"d":"0.0%"}},{"$f":"G4+K4+N4+Q4+T4","v":{"v":0,"d":"0.0%"}}]
[2,{"$f":"Supplier2!$D$14","v":0},{"$f":"Supplier2!$G$30","v":0},{"$f":"IF(Supplier2!$I$31>0,Supplier2!$I$30,IF(Supplier2!$H$31>0,Supplier2!$H$30,0))/2","v":0},{"$f":"Supplier2!$G$43","v":3},{"$f":"IF(Supplier2!$I$44>0,Supplier2!$I$43,IF(Supplier2!$H$44>0,Supplier2!$H$43,0))/2","v":0},{"$f":"IF(H5=0,0,IF(H5=1,D5/C5*$G$2,IF(H5=2,F5/E5*$G$2,IF(C5=0,0,IF(E5=0,0,0)))))","v":{"v":0,"d":"0.0%"}},{"$f":"IF(AND(D5>0,F5=0),1,IF(AND(F5>0,D5=0),2,IF(AND(D5=0,F5=0),0)))","v":0},{"$f":"Supplier2!$G$60","v":2},{"$f":"IF(Supplier2!$I$61>0,Supplier2!$I$60,IF(Supplier2!$H$61>0,Supplier2!$H$60,0))/2","v":0},{"$f":"IF(I5=0,0,(J5/I5*$K$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier2!$G$68","v":0},{"$f":"IF(Supplier2!$I$69>0,Supplier2!$I$68,IF(Supplier2!$H$69>0,Supplier2!$H$68,0))/2","v":0},{"$f":"IF(L5=0,0,(M5/L5*$N$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier2!$G$77","v":0},{"$f":"IF(Supplier2!$I$78>0,Supplier2!$I$77,IF(Supplier2!$H$78>0,Supplier2!$H$77,0))/2","v":0},{"$f":"IF(O5=0,0,(P5/O5*$Q$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier2!$G$86","v":2},{"$f":"IF(Supplier2!$I$87>0,Supplier2!$I$86,IF(Supplier2!$H$87>0,Supplier2!$H$86,0))/2","v":0},{"$f":"IF(R5=0,0,(S5/R5*$T$2))","v":{"v":0,"d":"0.0%"}},{"$f":"G5+K5+N5+Q5+T5","v":{"v":0,"d":"0.0%"}}]
[3,{"$f":"Supplier3!$D$14","v":0},{"$f":"Supplier3!$G$30","v":0},{"$f":"IF(Supplier3!$I$31>0,Supplier3!$I$30,IF(Supplier3!$H$31>0,Supplier3!$H$30,0))/2","v":0},{"$f":"Supplier3!$G$43","v":3},{"$f":"IF(Supplier3!$I$44>0,Supplier3!$I$43,IF(Supplier3!$H$44>0,Supplier3!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"IF(AND(D6>0,F6=0),1,IF(AND(F6>0,D6=0),2,IF(AND(D6=0,F6=0),0)))","v":0},{"$f":"Supplier3!$G$60","v":2},{"$f":"IF(Supplier3!$I$61>0,Supplier3!$I$60,IF(Supplier3!$H$61>0,Supplier3!$H$60,0))/2","v":0},{"$f":"IF(I6=0,0,(J6/I6*$K$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier3!$G$68","v":0},{"$f":"IF(Supplier3!$I$69>0,Supplier3!$I$68,IF(Supplier3!$H$69>0,Supplier3!$H$68,0))/2","v":0},{"$f":"IF(L6=0,0,(M6/L6*$N$2))","v":{"v":0,"d":"0.0%"}},{"$f":"Supplier3!$G$77","v":0},{"$f":"IF(Supplier3!$I$78>0,Supplier3!$I$77,IF(Supplier3!$H$78>0,Supplier3!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier3!$G$86","v":2},{"$f":"IF(Supplier3!$I$87>0,Supplier3!$I$86,IF(Supplier3!$H$87>0,Supplier3!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[4,{"$f":"Supplier4!$D$14","v":0},{"$f":"Supplier4!$G$30","v":0},{"$f":"IF(Supplier4!$I$31>0,Supplier4!$I$30,IF(Supplier4!$H$31>0,Supplier4!$H$30,0))/2","v":0},{"$f":"Supplier4!$G$43","v":3},{"$f":"IF(Supplier4!$I$44>0,Supplier4!$I$43,IF(Supplier4!$H$44>0,Supplier4!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier4!$G$60","v":2},{"$f":"IF(Supplier4!$I$61>0,Supplier4!$I$60,IF(Supplier4!$H$61>0,Supplier4!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier4!$G$68","v":0},{"$f":"IF(Supplier4!$I$69>0,Supplier4!$I$68,IF(Supplier4!$H$69>0,Supplier4!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier4!$G$77","v":0},{"$f":"IF(Supplier4!$I$78>0,Supplier4!$I$77,IF(Supplier4!$H$78>0,Supplier4!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier4!$G$86","v":2},{"$f":"IF(Supplier4!$I$87>0,Supplier4!$I$86,IF(Supplier4!$H$87>0,Supplier4!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[5,{"$f":"Supplier5!$D$14","v":0},{"$f":"Supplier5!$G$30","v":0},{"$f":"IF(Supplier5!$I$31>0,Supplier5!$I$30,IF(Supplier5!$H$31>0,Supplier5!$H$30,0))/2","v":0},{"$f":"Supplier5!$G$43","v":3},{"$f":"IF(Supplier5!$I$44>0,Supplier5!$I$43,IF(Supplier5!$H$44>0,Supplier5!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier5!$G$60","v":2},{"$f":"IF(Supplier5!$I$61>0,Supplier5!$I$60,IF(Supplier5!$H$61>0,Supplier5!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier5!$G$68","v":0},{"$f":"IF(Supplier5!$I$69>0,Supplier5!$I$68,IF(Supplier5!$H$69>0,Supplier5!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier5!$G$77","v":0},{"$f":"IF(Supplier5!$I$78>0,Supplier5!$I$77,IF(Supplier5!$H$78>0,Supplier5!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier5!$G$86","v":2},{"$f":"IF(Supplier5!$I$87>0,Supplier5!$I$86,IF(Supplier5!$H$87>0,Supplier5!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[6,{"$f":"Supplier6!$D$14","v":0},{"$f":"Supplier6!$G$30","v":0},{"$f":"IF(Supplier6!$I$31>0,Supplier6!$I$30,IF(Supplier6!$H$31>0,Supplier6!$H$30,0))/2","v":0},{"$f":"Supplier6!$G$43","v":3},{"$f":"IF(Supplier6!$I$44>0,Supplier6!$I$43,IF(Supplier6!$H$44>0,Supplier6!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier6!$G$60","v":2},{"$f":"IF(Supplier6!$I$61>0,Supplier6!$I$60,IF(Supplier6!$H$61>0,Supplier6!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier6!$G$68","v":0},{"$f":"IF(Supplier6!$I$69>0,Supplier6!$I$68,IF(Supplier6!$H$69>0,Supplier6!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier6!$G$77","v":0},{"$f":"IF(Supplier6!$I$78>0,Supplier6!$I$77,IF(Supplier6!$H$78>0,Supplier6!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier6!$G$86","v":2},{"$f":"IF(Supplier6!$I$87>0,Supplier6!$I$86,IF(Supplier6!$H$87>0,Supplier6!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[7,{"$f":"Supplier7!$D$14","v":0},{"$f":"Supplier7!$G$30","v":0},{"$f":"IF(Supplier7!$I$31>0,Supplier7!$I$30,IF(Supplier7!$H$31>0,Supplier7!$H$30,0))/2","v":0},{"$f":"Supplier7!$G$43","v":3},{"$f":"IF(Supplier7!$I$44>0,Supplier7!$I$43,IF(Supplier7!$H$44>0,Supplier7!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier7!$G$60","v":2},{"$f":"IF(Supplier7!$I$61>0,Supplier7!$I$60,IF(Supplier7!$H$61>0,Supplier7!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier7!$G$68","v":0},{"$f":"IF(Supplier7!$I$69>0,Supplier7!$I$68,IF(Supplier7!$H$69>0,Supplier7!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier7!$G$77","v":0},{"$f":"IF(Supplier7!$I$78>0,Supplier7!$I$77,IF(Supplier7!$H$78>0,Supplier7!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier7!$G$86","v":2},{"$f":"IF(Supplier7!$I$87>0,Supplier7!$I$86,IF(Supplier7!$H$87>0,Supplier7!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[8,{"$f":"Supplier8!$D$14","v":0},{"$f":"Supplier8!$G$30","v":0},{"$f":"IF(Supplier8!$I$31>0,Supplier8!$I$30,IF(Supplier8!$H$31>0,Supplier8!$H$30,0))/2","v":0},{"$f":"Supplier8!$G$43","v":3},{"$f":"IF(Supplier8!$I$44>0,Supplier8!$I$43,IF(Supplier8!$H$44>0,Supplier8!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier8!$G$60","v":2},{"$f":"IF(Supplier8!$I$61>0,Supplier8!$I$60,IF(Supplier8!$H$61>0,Supplier8!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier8!$G$68","v":0},{"$f":"IF(Supplier8!$I$69>0,Supplier8!$I$68,IF(Supplier8!$H$69>0,Supplier8!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier8!$G$77","v":0},{"$f":"IF(Supplier8!$I$78>0,Supplier8!$I$77,IF(Supplier8!$H$78>0,Supplier8!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier8!$G$86","v":2},{"$f":"IF(Supplier8!$I$87>0,Supplier8!$I$86,IF(Supplier8!$H$87>0,Supplier8!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[9,{"$f":"Supplier9!$D$14","v":0},{"$f":"Supplier9!$G$30","v":0},{"$f":"IF(Supplier9!$I$31>0,Supplier9!$I$30,IF(Supplier9!$H$31>0,Supplier9!$H$30,0))/2","v":0},{"$f":"Supplier9!$G$43","v":3},{"$f":"IF(Supplier9!$I$44>0,Supplier9!$I$43,IF(Supplier9!$H$44>0,Supplier9!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier9!$G$60","v":2},{"$f":"IF(Supplier9!$I$61>0,Supplier9!$I$60,IF(Supplier9!$H$61>0,Supplier9!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier9!$G$68","v":0},{"$f":"IF(Supplier9!$I$69>0,Supplier9!$I$68,IF(Supplier9!$H$69>0,Supplier9!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier9!$G$77","v":0},{"$f":"IF(Supplier9!$I$78>0,Supplier9!$I$77,IF(Supplier9!$H$78>0,Supplier9!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier9!$G$86","v":2},{"$f":"IF(Supplier9!$I$87>0,Supplier9!$I$86,IF(Supplier9!$H$87>0,Supplier9!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[10,{"$f":"Supplier10!$D$14","v":0},{"$f":"Supplier10!$G$30","v":0},{"$f":"IF(Supplier10!$I$31>0,Supplier10!$I$30,IF(Supplier10!$H$31>0,Supplier10!$H$30,0))/2","v":0},{"$f":"Supplier10!$G$43","v":3},{"$f":"IF(Supplier10!$I$44>0,Supplier10!$I$43,IF(Supplier10!$H$44>0,Supplier10!$H$43,0))/2","v":0},{"v":0,"d":"0.0%"},0,{"$f":"Supplier10!$G$60","v":2},{"$f":"IF(Supplier10!$I$61>0,Supplier10!$I$60,IF(Supplier10!$H$61>0,Supplier10!$H$60,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier10!$G$68","v":0},{"$f":"IF(Supplier10!$I$69>0,Supplier10!$I$68,IF(Supplier10!$H$69>0,Supplier10!$H$68,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier10!$G$77","v":0},{"$f":"IF(Supplier10!$I$78>0,Supplier10!$I$77,IF(Supplier10!$H$78>0,Supplier10!$H$77,0))/2","v":0},{"v":0,"d":"0.0%"},{"$f":"Supplier10!$G$86","v":2},{"$f":"IF(Supplier10!$I$87>0,Supplier10!$I$86,IF(Supplier10!$H$87>0,Supplier10!$H$86,0))/2","v":0},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[]
[]
[null,"NB      Score only one of the options out of 2 options in Section A",{"$nulls":6},"  Section B: Historic & ",null,null,"Section C: Contract Quality Plan"]
[null,null,"See below for explanation of options",{"$nulls":5},"       other information",{"$nulls":3},"(CQP)",null,"Section D: Quality Contol Plan"]
[null,null,"Option 1","Supplier has a valid ISO 9001 certificate by an accredited body.",{"$nulls":10},"         ","(QCP/ITP)",null,"Section E:   Miscellaneous Quality "]
[null,null,"Option 2","Supplier doesn't have ISO 9001 certificate but documented QMS compliant with ISO 9001.",{"$nulls":13},"         ","Requirements, (NDE, AIA etc)"]

{"sheet":"Evaluation Report","index":14,"n_rows":170,"n_cols":23,"rows_kept":170,"hidden":true,"merged":[[1,4,5,8],[1,9,1,10],[1,11,1,12],[1,14,2,14],[2,9,2,10],[2,11,2,12],[3,9,3,10],[3,11,3,12],[4,9,4,10],[4,11,4,12],[4,14,11,14],[5,9,5,10],[5,11,5,12],[7,2,7,4],[7,5,7,8],[7,9,7,10],[7,11,7,12],[8,2,8,4],[8,5,8,8],[8,9,8,10],[8,11,8,12],[9,2,9,4],[9,5,9,8],[9,9,9,10],[9,11,9,12],[10,2,10,4],[10,5,10,7],[10,8,10,9],[10,10,10,12],[11,2,11,4],[11,5,11,7],[11,8,11,9],[11,10,11,12],[12,2,12,4],[12,5,12,7],[12,8,12,9],[12,10,12,12],[13,2,13,4],[13,5,13,7],[13,8,13,9],[13,10,13,12],[14,2,14,4],[14,5,14,7],[14,8,14,9],[14,10,14,12],[15,7,15,10],[16,2,16,4],[16,5,16,6],[16,8,16,9],[16,10,16,12],[18,2,18,11],[19,2,19,11],[20,3,20,11],[21,2,21,11],[22,3,22,11],[23,3,23,11],[24,3,24,11],[25,3,25,11],[26,3,26,11],[27,3,27,11],[28,3,28,11],[29,3,29,11],[30,3,30,11],[31,3,31,11],[32,2,32,11],[34,2,34,11],[35,2,35,11],[36,2,36,11],[37,3,37,15],[39,3,39,8],[39,9,39,11],[39,20,39,21],[39,22,39,23],[40,3,40,8],[40,9,40,11],[40,20,40,21],[40,22,40,23],[41,3,41,8],[41,9,41,11],[41,20,41,21],[41,22,41,23],[42,3,42,8],[42,9,42,11],[42,20,42,21],[42,22,42,23],[43,3,43,8],[43,9,43,11],[43,20,43,21],[43,22,43,23],[44,3,44,8],[44,9,44,11],[44,20,44,21],[44,22,44,23],[48,2,48,9],[48,10,48,11],[49,2,49,9],[49,10,49,11],[50,2,50,9],[50,10,50,11],[51,2,51,9],[51,10,51,11],[55,2,55,9],[55,10,55,11],[56,2,56,9],[56,10,56,11],[57,2,57,9],[57,10,57,11],[58,2,58,9],[58,10,58,11],[60,2,60,12],[62,2,62,12],[63,2,63,6],[64,2,65,5],[64,6,64,10],[64,11,66,11],[64,12,67,12],[66,2,66,5],[67,2,67,5],[68,2,68,5],[68,15,72,23],[69,2,69,5],[70,2,70,5],[71,2,71,5],[72,2,72,5],[73,2,73,5],[73,15,75,24],[74,2,74,5],[75,2,75,5],[76,2,76,5],[77,2,77,5],[78,2,78,11],[79,2,79,11],[81,2,81,12],[82,2,82,12],[83,2,83,3],[83,4,83,12],[84,2,84,3],[84,4,84,12],[85,2,85,3],[85,4,85,12],[86,2,86,3],[86,4,86,12],[87,2,87,3],[87,4,87,12],[88,2,88,3],[88,4,88,12],[89,2,89,3],[89,4,89,12],[90,2,90,3],[90,4,90,12],[91,2,91,3],[91,4,91,12],[92,2,92,3],[92,4,92,12],[94,2,94,12],[95,2,95,12],[96,2,96,3],[96,4,96,12],[97,2,97,3],[97,4,97,12],[98,2,98,3],[98,4,98,12],[99,2,99,3],[99,4,99,12],[100,2,100,3],[100,4,100,12],[101,2,101,3],[101,4,101,12],[102,2,102,3],[102,4,102,12],[103,2,103,3],[103,4,103,12],[104,2,104,3],[104,4,104,12],[105,2,105,3],[105,4,105,12],[107,2,107,12],[108,2,108,12],[109,2,109,3],[109,4,109,12],[110,2,110,3],[110,4,110,12],[111,2,111,3],[111,4,111,12],[112,2,112,3],[112,4,112,12],[113,2,113,3],[113,4,113,12],[114,2,114,3],[114,4,114,12],[115,2,115,3],[115,4,115,12],[116,2,116,3],[116,4,116,12],[117,2,117,3],[117,4,117,12],[118,2,118,3],[118,4,118,12],[120,2,120,12],[121,2,121,12],[122,2,122,3],[122,4,122,12],[123,2,123,3],[123,4,123,12],[124,2,124,3],[124,4,124,12],[125,2,125,3],[125,4,125,12],[126,2,126,3],[126,4,126,12],[127,2,127,3],[127,4,127,12],[128,2,128,3],[128,4,128,12],[129,2,129,3],[129,4,129,12],[130,2,130,3],[130,4,130,12],[131,2,131,3],[131,4,131,12],[133,2,133,12],[134,2,134,12],[135,2,135,3],[135,4,135,12],[136,2,136,3],[136,4,136,12],[137,2,137,3],[137,4,137,12],[138,2,138,3],[138,4,138,12],[139,2,139,3],[139,4,139,12],[140,2,140,3],[140,4,140,12],[141,2,141,3],[141,4,141,12],[142,2,142,3],[142,4,142,12],[143,2,143,3],[143,4,143,12],[143,16,143,21],[144,2,144,3],[144,4,144,12],[146,2,146,12],[147,2,147,12],[148,2,148,3],[148,4,148,12],[149,2,149,3],[149,4,149,12],[150,2,150,3],[150,4,150,12],[151,2,151,3],[151,4,151,12],[152,2,152,3],[152,4,152,12],[153,2,153,3],[153,4,153,12],[154,2,154,3],[154,4,154,12],[155,2,155,3],[155,4,155,12],[156,2,156,3],[156,4,156,12],[157,2,157,3],[157,4,157,12],[159,2,159,12],[160,2,160,12],[160,15,160,25],[161,2,161,12],[162,2,162,12],[162,15,162,25],[164,8,164,9],[168,3,168,5]]}
[]
[{"$nulls":4},"Supplier Quality Management:         \nTender Evaluation Report",{"$nulls":4},"Unique Identifier",null,{"$f":"Supplier10!I2","v":"240-12248652"},null,null,"To Print the report:"]
[{"$nulls":9},"Revision",null,"8"]
[{"$nulls":9},{"$f":"Supplier10!G8","v":"Report Revision"},null,{"$f":"Supplier10!I8","v":1}]
[{"$nulls":9},"Effective Date",null,{"$f":"RIGHT(Supplier1!I4,10)","v":"21/01/2022"},null,null,"Please print only area from B1 to L198 or use Print_Area.\n\n To select the print_area, you click on little black down arrow in the white box above cell address A1"]
[{"$nulls":9},"Additional Specification",null,{"$f":"Supplier10!I3","v":"240-105658000"}]
[]
[null,null,"Document Type:",null,null,"Contractual Requirements Evaluations",{"$nulls":3},"Tender Nr.",null,{"$f":"Supplier1!D6","v":"*"}]
[null,null," Discipline /Area:",null,null,"Supplier Quality Assurance ",{"$nulls":3},"Date of Evaluation: ",null,{"$f":"Supplier10!I5","v":"2022-01-12"}]
[null,null,"Title: ",null,null,"Evaluation Report of Quality deliverables on tender submissions.",{"$nulls":3},"Number of reports:",null," *eg. 1 of 3"]
[{"$nulls":5},"EVALUATION REPORT COMPILED BY",null,null,"REVIEWED BY(where applicable)",null,"AUTHORIZED BY"]
[null,null,"Signature:"]
[null,null,"Name:",null,null,{"$f":"Supplier1!G6","v":"*"},null,null,"*",null,"*"]
[null,null,"Position/ Designation:",null,null,{"$f":"Supplier1!G7","v":"eg: Senior Advisor: Supplier Quality Management"},null,null,"*",null,"*"]
[null,null,"Date:",null,null,"*",null,null,"*",null,"*"]
[]
[null,null,"Procurement Officer:",null,null,{"$f":"Supplier1!D7","v":"*"},null,null,"Division: ",null,"*"]
[]
[null,null,"1. Introduction"]
[null,null,"Quality Evaluations were performed on the tenders returnables received for the following scope of works/works information:  "]
[null,null,"Scope:",{"$f":"Supplier1!D10","v":"*"}]
[null,null,"Evaluations were therefore performed on the tender submissions of the following Suppliers:"]
[null,null,"Supplier 1",{"$f":"Supplier1!D14","v":"*"}]
[null,null,"Supplier 2",{"$f":"Supplier2!D14","v":0}]
[null,null,"Supplier 3",{"$f":"Supplier3!D14","v":0}]
[null,null,"Supplier 4",{"$f":"Supplier4!D14","v":0}]
[null,null,"Supplier 5",{"$f":"Supplier5!D14","v":0}]
[null,null,"Supplier 6",{"$f":"Supplier6!D14","v":0}]
[null,null,"Supplier 7",{"$f":"Supplier7!D14","v":0}]
[null,null,"Supplier 8",{"$f":"Supplier8!D14","v":0}]
[null,null,"Supplier 9",{"$f":"Supplier9!D14","v":0}]
[null,null,"Supplier 10",{"$f":"Supplier10!D14","v":0}]
[null,null,"This report contains the results of these evaluations and is to be submitted to the User/Project Manager as one of the required disciplines for evaluation of OBJECTIVE CRITERIA."]
[]
[null,null,"2. Quality Scoring Criteria"]
[null,null,"In the approved contract strategy, the following allocations were made in respect of evaluation of tender deliverables. The weightings allocated for the separate evaluations are as follows:"]
[null,null,"The following evaluation criteria were establish during the contract strategy and applied during tender evaluation."]
[null,null,{"$f":"Requirements!B6","v":"Category 4"}," 240-105658000 Quality assessment criteria"]
[]
[{"$nulls":3},"Description",{"$nulls":5},"240-105658000 References",{"$nulls":10},"240-105658000 References",null,"240-51544462 clauses"]
[null,null,"Section A:","Quality Management System. (ISO 9001 or other QMS implimented)",{"$nulls":5},"3.1, 3.5",{"$nulls":10},"3.2.1.5",null,"7.1.3"]
[null,null,"Section B:","Evidence of QMS in operation: defined roles, responsibilities & authorities; Control of Externally Provided Processes, Products and Services;  Audit reports,NCR's, CA and Records of management reviews.",{"$nulls":5},"3.1,  3.5",{"$nulls":10},"3.2.1.4/6/7/9/10",null,"7.1.5, 7.1.6, 7.1.29, 7.1.30, 7.1.31"]
[null,null,"Section C:","Proposed project/contract quality plan (ISO 10005 guidelines) ",{"$nulls":5},"3.2,  3.3, 3.5",{"$nulls":10},"3.2.1.8/11/12/14 & 3.2.2",null,"7.1.3 c), 7.4.3"]
[null,null,"Section D:","Draft Quality Control plan (QCP) as per  and ISO 10005",{"$nulls":5},"3.2, 3.4, 3.5",{"$nulls":10},"3.5.1.2",null,"7.4.5, 7.5.2"]
[null,null,"Section E:","Customized requirements. 240-105658000  Form A, and other requirements as per Scope of work",{"$nulls":5},"3 and 3.5",{"$nulls":10},"3.2.1.1 / 2/13",null,"7.1, 7.2, 7.3, 7.4, 7.5"]
[null,null,"The criteria used to evaluate the tenders regarding Quality are as per tables below."]
[null,null,"2.1  Evaluation scoring of individual  quality deliverables:"]
[]
[null,null,"Description",{"$nulls":7},"Score"]
[null,null,"Deliverable meets Employer's Quality Requirements .",{"$nulls":7},2]
[null,null,"Deliverable meets Employer's Quality Requirements with some qualifications.",{"$nulls":7},1]
[null,null,"Deliverable doesn't meets Employer's Quality Requirements / No submission.",{"$nulls":7},0]
[]
[null,null,"2.2  Evaluation scoring for the selected quality criteria."]
[]
[null,null,"Description",{"$nulls":7},"Rating"]
[null,null,"Supplier meets Employer's Quality Requirements: No errors, risks, weaknesses or omissions. Fully Compliant ",{"$nulls":7},{"v":1,"d":"100%"}]
[null,null,"Supplier meets Employer's Quality Requirements with qualifications (Some qualifications required from tenderer to eliminate the errors, risks, weaknesses or omissions. Partially Compliant ",{"$nulls":7},"0%<100%"]
[null,null,"Non-Compliant/non-responsive",{"$nulls":7},{"v":0,"d":"0%"}]
[]
[null,null,"The evaluation of Quality Requirements has NO individual threshold, since it forms part of the Contractual Requirements. The outcomes of this evaluation will not influence the ranking.\n"]
[]
[null,null,"3. Summary of Evaluation Results:"]
[null,null,"The following results are not presented in rank order;"]
[null,null,"Name of Tenderer",{"$nulls":3},"Section  Quality Criteria",{"$nulls":4},"Total Weighted % Score","Outcome"]
[{"$nulls":6},"Section A","Section B","Section C","Section D","Section E"]
[null,null,"Criteria weights",{"$nulls":3},{"$f":"Supplier1!I21","v":{"v":0.25,"d":"25%"}},{"$f":"Supplier1!I46","v":{"v":0.25,"d":"25%"}},{"$f":"Supplier1!I59","v":{"v":0.2,"d":"20%"}},{"$f":"Supplier1!I67","v":{"v":0.2,"d":"20%"}},{"$f":"Supplier1!I76","v":{"v":0.09999999999999998,"d":"10%"}}]
[null,null,"Criteria description",{"$nulls":3},"QMS Requirements","QMS Evidence Requirements","Contract Quality plan","Quality Control plan","Customised Requirements","Total weight score(%)"]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},{"$nulls":3},{"$f":"Scorecard!G4","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K4","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N4","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q4","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T4","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U4","v":{"v":0,"d":"0.0%"}},{"$f":"IF(L69=0%,\"Non Compliant\",IF(L69=100%,\"Fully Compliant\",\"Partially Compliant\"))","v":"Non Compliant"}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},{"$nulls":3},{"$f":"Scorecard!G5","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K5","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N5","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q5","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T5","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U5","v":{"v":0,"d":"0.0%"}},{"$f":"IF(L70=0%,\"Non Compliant\",IF(L70=100%,\"Fully Compliant\",\"Partially Compliant\"))","v":"Non Compliant"}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},{"$nulls":3},{"$f":"Scorecard!G6","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K6","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N6","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q6","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T6","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U6","v":{"v":0,"d":"0.0%"}},{"$f":"IF(L71=0%,\"Non Compliant\",IF(L71=100%,\"Fully Compliant\",\"Partially Compliant\"))","v":"Non Compliant"}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},{"$nulls":3},{"$f":"Scorecard!G7","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K7","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N7","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q7","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T7","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U7","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},{"$nulls":3},{"$f":"Scorecard!G8","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K8","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N8","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q8","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T8","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U8","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},{"$nulls":3},{"$f":"Scorecard!G9","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K9","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N9","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q9","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T9","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U9","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},{"$nulls":3},{"$f":"Scorecard!G10","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K10","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N10","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q10","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T10","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U10","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},{"$nulls":3},{"$f":"Scorecard!G11","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K11","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N11","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q11","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T11","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U11","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},{"$nulls":3},{"$f":"Scorecard!G12","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K12","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N12","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q12","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T12","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U12","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},{"$nulls":3},{"$f":"Scorecard!G13","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!K13","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!N13","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!Q13","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!T13","v":{"v":0,"d":"0.0%"}},{"$f":"Scorecard!U13","v":{"v":0,"d":"0.0%"}},"Non Compliant"]
[]
[null,null,"4.  Summary of evaluation findings:"]
[]
[null,null,"Section A: Quality Management system"]
[null,null,"A valid  ISO 9001:2015 Certificate with relevant scope of work. If not ISO 9001 certified, a credible proof of ISO 9001:2015 compliant Quality Management System including, a specimen of the Quality Manual or a document that defines and describes the QMS and its scope or Quality Method statement based on the scope of this tender;  Quality Policy and Quality Objectives signed  by Top Management(MD/CEO),  Control of documented information, Nonconforming outputs, Nonconformity and Corrective Action and Internal Audit."]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},null,{"$f":"Supplier1!K25","v":0}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},null,{"$f":"Supplier2!K26","v":0}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},null,{"$f":"Supplier3!K25","v":0}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},null,{"$f":"Supplier4!K25","v":0}]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},null,{"$f":"Supplier5!K25","v":0}]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},null,{"$f":"Supplier6!K25","v":0}]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},null,{"$f":"Supplier7!K25","v":0}]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},null,{"$f":"Supplier8!K25","v":0}]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},null,{"$f":"Supplier9!K25","v":0}]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},null,{"$f":"Supplier10!K25","v":0}]
[]
[null,null,"Section B: Additional Quality requirements (structure, suppliers, audits)"]
[null,null,"Defined roles, responsibilities & authorities; Control of Externally Provided Processes, Products and Services(A copy of process/procedure regarding the assessment, selection, management and auditing of suppliers and subcontractors) ; Audit reports,NCR's, CA and records of Management Review meetings (minutes, attendance registers etc)"]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},null,{"$f":"Supplier1!K48","v":0}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},null,{"$f":"Supplier2!K49","v":0}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},null,{"$f":"Supplier3!K49","v":0}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},null,{"$f":"Supplier4!K49","v":0}]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},null,{"$f":"Supplier5!K49","v":0}]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},null,{"$f":"Supplier6!K49","v":0}]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},null,{"$f":"Supplier7!K49","v":0}]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},null,{"$f":"Supplier8!K49","v":0}]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},null,{"$f":"Supplier9!K49","v":0}]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},null,{"$f":"Supplier10!K49","v":0}]
[]
[null,null,"Section C: Contract Quality Plan"]
[null,null,"A provisional CQP for the project. The CQP provide a comprehensive strategy to demonstrate how consistency of design and philosophies across all the units during the overall project implementation will be ensured. Clearly identify roles, responsibilities and expectations throughout the project and the tenderer to demonstrate correct allocation of experienced resources throughout the project period. "]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},null,{"$f":"Supplier1!K62","v":0}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},null,{"$f":"Supplier2!K67","v":0}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},null,{"$f":"Supplier3!K67","v":0}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},null,{"$f":"Supplier4!K67","v":0}]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},null,{"$f":"Supplier5!K67","v":0}]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},null,{"$f":"Supplier6!K67","v":0}]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},null,{"$f":"Supplier7!K67","v":0}]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},null,{"$f":"Supplier8!K67","v":0}]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},null,{"$f":"Supplier9!K67","v":0}]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},null,{"$f":"Supplier10!K67","v":0}]
[]
[null,null,"Section D: Quality Control Plan"]
[null,null,"A provisional QCP for the project. The QCP provide a comprehensive Quality control process, to ensure world-class engineering practice will be achieved during the implementation of the project, by others to be overseen by the tenderer as well as any subcontractors forming part of the project. Methodologies must be provided to demonstrate how installation practices will be managed and  carried out to ensure compliance to the details designs and the Employer’s requirements."]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},null,{"$f":"Supplier1!K71","v":0}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},null,{"$f":"Supplier2!K76","v":0}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},null,{"$f":"Supplier3!K76","v":0}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},null,{"$f":"Supplier4!K76","v":0}]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},null,{"$f":"Supplier5!K76","v":0}]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},null,{"$f":"Supplier6!K76","v":0}]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},null,{"$f":"Supplier7!K76","v":0}]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},null,{"$f":"Supplier8!K76","v":0}]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},null,{"$f":"Supplier9!K76","v":0}]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},null,{"$f":"Supplier10!K76","v":0}]
[]
[null,null,"Section E: User defined & addional Quality requirements"]
[null,null,"Signed enquiry/contract/order quality requirements form (240-105658000  Form A). Any other quality requirements such as transportation and shipping or storage and preservation, quality management accreditations  that are specically required, such as AIA, NDE, PSIRA , CIDB or RBI auditor certification etc. Provide a list of standards that exceeds the standards referenced in the Works Information to which the works provided by the Tenderer, adheres to. "]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},null,{"$f":"Supplier1!K79","v":0}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},null,{"$f":"Supplier2!K84","v":0}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},null,{"$f":"Supplier3!K84","v":0}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},null,{"$f":"Supplier4!K84","v":0}]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},null,{"$f":"Supplier5!K84","v":0}]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},null,{"$f":"Supplier6!K84","v":0}]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},null,{"$f":"Supplier7!K84","v":0}]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},null,{"$f":"Supplier8!K84","v":0}]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},null,{"$f":"Supplier9!K84","v":0}]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},null,{"$f":"Supplier10!K84","v":0}]
[]
[null,null,"5. Clarification Items list  (List  clarifications requested and response of suppliers)"]
[null,null,"Clarifications requests are to clarify information not submitted and tenderer (s) should be offered an opportunity to submit deliverables that haven't been submitted. Improper conduct in clarifications may make the tender non-responsive."]
[null,null,{"$f":"IF($D$23>0,$D$23,\"Supplier 1\")","v":"*"},null,{"$f":"Supplier1!B86","v":0}]
[null,null,{"$f":"IF($D$24>0,$D$24,\"Supplier 2\")","v":"Supplier 2"},null,{"$f":"Supplier2!B91","v":0}]
[null,null,{"$f":"IF($D$25>0,$D$25,\"Supplier 3\")","v":"Supplier 3"},null,{"$f":"Supplier3!B90","v":0}]
[null,null,{"$f":"IF($D$26>0,$D$26,\"Supplier 4\")","v":"Supplier 4"},null,{"$f":"Supplier4!B90","v":0}]
[null,null,{"$f":"IF($D$27>0,$D$27,\"Supplier 5\")","v":"Supplier 5"},null,{"$f":"Supplier5!B90","v":0}]
[null,null,{"$f":"IF($D$28>0,$D$28,\"Supplier 6\")","v":"Supplier 6"},null,{"$f":"Supplier6!B90","v":0}]
[null,null,{"$f":"IF($D$29>0,$D$29,\"Supplier 7\")","v":"Supplier 7"},null,{"$f":"Supplier7!B91","v":0}]
[null,null,{"$f":"IF($D$30>0,$D$30,\"Supplier 8\")","v":"Supplier 8"},null,{"$f":"Supplier8!B90","v":0}]
[null,null,{"$f":"IF($D$31>0,$D$31,\"Supplier 9\")","v":"Supplier 9"},null,{"$f":"Supplier9!B90","v":0}]
[null,null,{"$f":"IF($D$32>0,$D$32,\"Supplier 10\")","v":"Supplier 10"},null,{"$f":"Supplier10!B90","v":0}]
[]
[null,null,"6.  Conclusion:"]
[]
[null,null,"Quality forms part of the Contractual Requirements that suppliers have to meet. From a Quality perspective: The suppliers to be considered for further negotiations (if applicable) and contract award, are the suppliers that meet the Quality requirements. However, further clarifications must be offered to all suppliers in this report to resubmit any outstanding documentation to improve on the results before contract award. Also if required an on-site assessment for the suppliers can be performed by Eskom Quality department, to established whether the submitted documentation/ requirements are the true reflection of the QMS on site."]
[]
[]
[]
[]
[]
[null,null," ","____________________________________"]
[null,null,"Name:",{"$f":"Supplier1!G6","v":"*"}]
[null,null,"Position:","*"]

{"sheet":"Requirements","index":15,"n_rows":62,"n_cols":9,"rows_kept":62,"hidden":true,"merged":[[1,2,4,3],[1,4,1,5],[1,6,1,8],[2,4,2,5],[2,6,2,8],[3,4,3,5],[3,6,3,8],[4,4,4,5],[4,6,4,8],[5,1,5,2],[5,3,5,5],[5,6,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,6],[16,1,16,6],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[29,1,29,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[43,1,43,7],[44,1,44,7],[45,1,45,5],[46,1,46,5],[47,1,47,5],[49,1,49,7],[49,8,50,8],[50,1,50,7],[51,1,51,5],[52,1,52,5],[53,1,53,5],[55,1,55,7],[55,8,56,8],[56,1,56,7],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,8]]}
[]
[null,null,"Procurement Quality Assurance:                 List of tender deliverables",null,"Unique Identifier",null,"240-12248652"]
[{"$nulls":4},"Revision",null,{"$f":"'Evaluation Report'!L3","v":"8"}]
[{"$nulls":4},"Effective Date",null,{"$f":"'Evaluation Report'!L5","v":"21/01/2022"}]
[{"$nulls":4},"Additional Specification",null,{"$f":"Supplier1!I3","v":"240-105658000"}]
[null,{"$f":"VLOOKUP(1,Cover!D6:F24,3,FALSE)","v":"Category 4"},null,"Deliverables to be evaluated indicator = 1",null,null,"Weights"]
[null,"SECTION A : Quality Management System Requirements ISO 9001"]
[null,"(Option 1)      Valid certification of Quality Management System by an ISO accredited body "]
[{"$nulls":6},"Apply (Yes=1)"]
[null,"A.1 Product / Service Scoping on ISO certificate is defined and relevant ",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J40*Cover!K40,Cover!J40)","v":0}]
[null,"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J41*Cover!K41,Cover!J41)","v":0}]
[null,"A.3 Certification  Authority has Recognized International Accreditation ",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J42*Cover!K42,Cover!J42)","v":0},null,{"$f":"Supplier1!I21","v":{"v":0.25,"d":"25%"}}]
[null,"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J43*Cover!K43,Cover!J43)","v":0}]
[null,"A.5  Quality Policy signed by top management.",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!#REF!*Cover!#REF!,Cover!#REF!)","v":{"$error":"#REF!"}}]
[null,"Sub-Section A Score Option 1",{"$nulls":4},{"$f":"SUM(G10:G13)","v":0}]
[null,"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":6},"OR"]
[null,"(Option 2) Objective evidence of documented QMS that is not certified but complies with ISO9001"]
[{"$nulls":6},"Apply (Yes=1)"]
[null,"A.1 Quality Manual /or Quality Method statement ",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J47*Cover!K47,Cover!J47)","v":1}]
[null,"A.2  Copy of Quality Policy signed by top management.",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J48*Cover!K48,Cover!J48)","v":1},null,{"$f":"Supplier1!I21","v":{"v":0.25,"d":"25%"}}]
[null,"A.3 Procedure for Control of Documents",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J49*Cover!K49,Cover!J49)","v":1}]
[null,"A.4 Procedure for Control of Records",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J50*Cover!K50,Cover!J50)","v":0}]
[null,"A.5 Internal Audits Procedure",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J51*Cover!K51,Cover!J51)","v":0}]
[null,"A.6 Procedures for Control of Nonconforming product or services",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J52*Cover!K52,Cover!J52)","v":0}]
[null,"A.7 Corrective Action Procedure ",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J53*Cover!K53,Cover!J53)","v":0}]
[null,"A.8 Preventive Action Procedure.",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J54*Cover!K54,Cover!J54)","v":0}]
[null,"Sub-Section A Score Option 2",{"$nulls":4},{"$f":"SUM(G19:G26)","v":3}]
[]
[null,"SECTION B :    Evidence of QMS in operation (Tender Quality Requirements -Ref QM-58 or 240-51544462)"]
[{"$nulls":6},"Apply (Yes=1)"]
[null,"B.1 Copy of appointment letter & CV/ resume of a Quality Representative for the project",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J59*Cover!K59,Cover!J59)","v":1}]
[null,"B.2 Signed Organisational structure & Quality dept reporting structure.",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J60*Cover!K60,Cover!J60)","v":1}]
[null,"B.3 Copy of procedure for control of suppliers & subcontractors",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J61*Cover!K61,Cover!J61)","v":0}]
[null,"B.4 Copy of an internal management system audit report (with NCR, corrective & preventive report)",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J62*Cover!K62,Cover!J62)","v":0}]
[null,"B.5 Copy of an external management system audit report (with NCR, corrective & preventive report)",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J63*Cover!K63,Cover!J63)","v":0},null,{"$f":"Supplier1!I46","v":{"v":0.25,"d":"25%"}}]
[null,"B.6 Copy of Customer satisfaction surveys",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J64*Cover!K64,Cover!J64)","v":0}]
[null,"B.7 Copy of a Quality Plan (incl ITP's) on previous project < 2yrs",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J65*Cover!K65,Cover!J65)","v":0}]
[null,"B.8 Historical Information (list) of similar work performed < 2yrs",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J66*Cover!K66,Cover!J66)","v":0}]
[]
[]
[]
[null,"Section B Score",{"$nulls":4},{"$f":"SUM(G31:G38)","v":2}]
[]
[null,"SECTION C :               Contract Quality Plan Requirements (Ref QM-58 and 240-109253698 CQP). "]
[null,"Contract Quality Plan as per Scope of Works (Ref ISO 10005)"]
[{"$nulls":6},"Apply (Yes=1)"]
[null,"NB!!!!    draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J72*Cover!K72,Cover!J72)","v":0},null,{"$f":"Supplier1!I59","v":{"v":0.2,"d":"20%"}}]
[null,"Section C Score",{"$nulls":4},{"$f":"SUM(G47:G47)","v":0}]
[]
[null,"SECTION D       : Quality Control Plan Requirements (Ref QM-58 or 240-109253302 ITP)"]
[null,"QCP /Checklist/ ITP (Quality Control Plans) as per Scope of Works (Ref ISO 10005 & QM 58)"]
[{"$nulls":6},"Apply (Yes=1)"]
[null,"NB!!!!    draft QCP/ITP (jobcards)  haves important QC deliverables",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J78*Cover!K78,Cover!J78)","v":0},null,{"$f":"Supplier1!I67","v":{"v":0.2,"d":"20%"}}]
[null,"Section D Score",{"$nulls":4},{"$f":"SUM(G53:G53)","v":0}]
[]
[null,"SECTION   E  : User defined additional Requirements & miscellaneous (Ref QM-58)"]
[null,"Customer specific requirements & other standards and required can be listed and evaluated here"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},"Apply (Yes=1)"]
[null,"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J84*Cover!K84,Cover!J84)","v":1},null,{"$f":"Supplier1!I76","v":{"v":0.09999999999999998,"d":"10%"}}]
[null,"E.2 Preliminary manufacturing/installation schedule includes quality events",{"$nulls":4},{"$f":"IF(Cover!$K$34=1,Cover!J85*Cover!K85,Cover!J85)","v":1}]
[null,"Section E Score",{"$nulls":4},{"$f":"SUM(G59:G60)","v":2}]
[null,"Tender Quality Requirements -Ref QM-58 or 240-51544462"]

{"sheet":"Re-Evaluation ","index":16,"n_rows":41,"n_cols":13,"rows_kept":41,"hidden":true,"merged":[[2,4,6,8],[2,9,2,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[8,2,8,4],[8,5,8,8],[8,9,8,10],[9,2,9,4],[9,5,9,8],[9,9,9,10],[10,9,10,10],[11,3,11,11],[12,4,12,7],[12,8,12,9],[12,10,12,11],[13,4,13,7],[13,8,13,9],[13,10,13,11],[14,2,14,3],[14,4,14,7],[14,8,14,9],[14,10,14,11],[15,2,15,3],[15,4,15,7],[15,8,15,9],[15,10,15,11],[16,2,16,3],[16,4,16,7],[16,8,16,9],[16,10,16,11],[17,7,17,10],[18,2,18,4],[18,5,18,6],[18,8,18,9],[18,10,18,11],[21,2,21,11],[22,2,22,11],[23,3,23,11],[25,3,25,6],[25,7,25,11],[26,2,28,3],[26,4,26,8],[26,9,26,11],[27,5,27,8],[27,10,27,11],[28,5,28,8],[28,10,28,11],[29,2,29,3],[29,4,29,8],[29,9,29,11],[30,2,30,3],[30,4,30,8],[30,9,30,11],[31,2,31,3],[31,4,31,8],[31,9,31,11],[32,2,32,3],[32,4,32,8],[32,9,32,11],[33,2,33,3],[33,4,33,8],[33,9,33,11],[34,2,34,3],[34,4,34,8],[34,9,34,11],[35,2,35,3],[35,4,35,8],[35,9,35,11],[36,2,36,3],[36,4,36,8],[36,9,36,11],[37,2,37,3],[37,4,37,8],[37,9,37,11],[38,2,38,3],[38,4,38,8],[38,9,38,11],[39,2,39,11],[40,2,40,11]]}
[]
[]
[{"$nulls":4},"Supplier Quality Management:         \nTender Re-Evaluation Report",{"$nulls":4},"Unique Identifier",null,"240-xxxxxxx"]
[{"$nulls":9},"Revision",null,"8"]
[{"$nulls":9},{"$f":"Supplier1!G8","v":"Report Revision"},null,{"$f":"Supplier1!I8","v":1}]
[{"$nulls":9},"Effective Date",null,"21/01/2022"]
[{"$nulls":9},"Additional Specification",null,{"$f":"Supplier1!I3","v":"240-105658000"}]
[]
[null,null,"DOCUMENT TYPE:",null,null,"Contractual Requirements Evaluations",{"$nulls":3},"Tender Nr.",null,{"$f":"Supplier1!D6","v":"*"}]
[null,null,"DISCIPLINE/AREA: ",null,null,"Supplier Quality Assurance ",{"$nulls":3},"DATE of Evaluation: "]
[{"$nulls":9},"Number of reports:",null,{"$f":"'Evaluation Report'!L10:M10","v":" *eg. 1 of 3"},0]
[null,null,"Title: ","Evaluation Report of Quality deliverables of tender  submissions for Contractual Requirements."]
[{"$nulls":4},"EVALUATION REPORT COMPILED BY",{"$nulls":3},"REVIEWED BY(where applicable)",null,"AUTHORIZED BY"]
[null,null,"Signature"]
[null,null,"Name",null,{"$f":"Supplier1!G6","v":"*"},{"$nulls":3}," "]
[null,null,"Position",null,{"$f":"Supplier1!G7","v":"eg: Senior Advisor: Supplier Quality Management"}]
[null,null,"Date",null,{"$f":"L10","v":"00:00:00"}]
[]
[null,null,"Procurement Officer:",null,null,{"$f":"Supplier1!D7","v":"*"},null,null,"Division",null,{"$f":"Supplier1!D8","v":0}]
[]
[]
[null,null,"1. Introduction"]
[null,null,"Quality Evaluations were performed on the tenders returnables received for the following scope of works/works information:  "]
[null,null,"Scope:",{"$f":"Supplier1!D10","v":"*"}]
[]
[null,null,{"$f":"'Evaluation Report'!C38","v":"Category 4"},{"$f":"'Evaluation Report'!D38","v":" 240-105658000 Quality assessment criteria"},{"$nulls":3},"For 2nd  evaluation, Please indicate if Supplier has submitted all outstanding documents and or list the outstanding documents."]
[null,null,"Supplier Name",null,"Clarification Items list from 1st Evaluation",{"$nulls":4},"Clarification Items list from 2nd Evaluation"]
[{"$nulls":4},"Evaluator's Name",{"$f":"Supplier1!G6","v":"*"},{"$nulls":3},"Evaluator's Name","*"]
[{"$nulls":4},"Evaluation Date",{"$f":"Supplier1!I5","v":"2022-01-12"},{"$nulls":3},"Evaluation Date",{"$f":"L10","v":"00:00:00"}]
[null,null,{"$f":"Scorecard!B4","v":"*"},null,{"$f":"Supplier1!B86","v":0}]
[null,null,{"$f":"Scorecard!B5","v":0},null,{"$f":"Supplier2!B91","v":0}]
[null,null,{"$f":"Scorecard!B6","v":0},null,{"$f":"Supplier3!B90","v":0}]
[null,null,{"$f":"Scorecard!B7","v":0},null,{"$f":"Supplier4!B90","v":0}]
[null,null,{"$f":"Scorecard!B8","v":0},null,{"$f":"Supplier5!B90","v":0}]
[null,null,{"$f":"Scorecard!B9","v":0},null,{"$f":"Supplier6!B90","v":0}]
[null,null,{"$f":"Scorecard!B10","v":0},null,{"$f":"Supplier7!B91","v":0}]
[null,null,{"$f":"Scorecard!B11","v":0},null,{"$f":"Supplier8!B90","v":0}]
[null,null,{"$f":"Scorecard!B12","v":0},null,{"$f":"Supplier9!B90","v":0}]
[null,null,{"$f":"Scorecard!B13","v":0},null,{"$f":"Supplier10!B90","v":0}]
[null,null,"Conclusion:"]
[null,null,"Quality forms part of the Contractual Requirements that suppliers have to meet. The suppliers that have submitted all the outsanding documention and meet the quality requirements may be considered for further negotiations (if applicable), and contract award. If required an on-site assessment for the suppliers can be performed by Eskom Quality department, to established whether the submitted documentation/ requirements are the true reflection of the QMS on site."]

{"sheet":"Returnables","index":17,"n_rows":65,"n_cols":19,"rows_kept":65,"merged":[[0,4,3,5],[0,6,0,7],[1,6,1,7],[2,6,2,7],[4,5,4,7],[5,3,5,8],[6,3,6,8],[7,3,7,7],[8,3,8,7],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[14,4,14,7],[15,3,15,7],[15,13,15,17],[16,3,16,7],[16,13,16,17],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[26,3,26,7],[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,3,32,7],[34,3,34,7],[35,3,35,7],[36,3,36,7],[37,3,37,7],[38,3,38,7],[39,3,39,7],[40,3,40,7],[41,3,41,7],[42,3,42,7],[43,3,43,7],[44,3,44,7],[45,3,45,7],[46,3,46,7],[47,3,47,7],[48,3,48,7],[49,3,49,7],[50,3,50,7],[51,3,51,7],[52,3,52,7],[53,3,53,7],[54,3,54,7],[55,3,55,7],[56,3,56,7],[57,3,57,7],[58,3,58,7],[59,3,59,7],[61,3,61,5],[61,6,61,8],[62,3,62,5],[62,6,62,8],[63,3,63,5],[63,6,63,8],[64,3,64,5],[64,6,64,8]]}
[{"$nulls":4},"Supplier Quality Management:                 List of Tender Returnables Documents",null,"Unique Identifier",null,"240-12248652"]
[{"$nulls":6},"Revision",null,7]
[{"$nulls":6},"Effective Date",null,"2022-01-26"]
[{"$nulls":6},"Specification",null,"240-105658000"]
[{"$nulls":3},{"$f":"VLOOKUP(1,Cover!D6:F24,3,FALSE)","v":"Category 4"},": Quality Requirements","Deliverables to be evaluated indicator = 1"]
[{"$nulls":3},"SECTION A : Quality Management System Requirements ISO 9001"]
[{"$nulls":3},"(Option 1)  Valid certification of Quality Management System by an ISO accredited body "]
[{"$nulls":8},"Apply =1"]
[{"$nulls":3},"A.1 Product / Service Scoping on ISO 9001 certificate is defined and relevant ",{"$nulls":4},{"$f":"Cover!J40","v":0}]
[{"$nulls":3},"A.2 Certificate by Approved and Authorized certification authority",{"$nulls":4},{"$f":"Cover!J41","v":0}]
[{"$nulls":3},"A.3 Certification  Authority has Recognized International Accreditation ",{"$nulls":4},{"$f":"Cover!J42","v":0}]
[{"$nulls":3},"A.4 Validity (expiry date) of certificate",{"$nulls":4},{"$f":"Cover!J43","v":0}]
[{"$nulls":3},"Section A Score  Option 1",{"$nulls":4},{"$f":"SUM(I9:I12)","v":0}]
[{"$nulls":3},"SECTION A : Quality Management System Requirements ISO 9001",{"$nulls":11},"(Option 2) "]
[{"$nulls":3},{"$f":"IF(D5=\"Category 2\",P14,\"\")","v":""},"Objective evidence of documented QMS that is not certified but complies with ISO 9001"]
[{"$nulls":8},"Apply =1",{"$nulls":3},"1 _3","A.1 QMS Manual or a document that defines and describes the QMS and its scope "]
[{"$nulls":3},{"$f":"IF(D5=\"Category 4\",N17,N16)","v":"A.1 Quality Method statement based on scope.(Method Statement Template-Ref  240-126469599)"},{"$nulls":4},{"$f":"Cover!J47","v":1},{"$nulls":3},4,"A.1 Quality Method statement based on scope.(Method Statement Template-Ref  240-126469599)",{"$nulls":4},"Quality Method statement based on scope.(Method statement Template - Ref 240-126469599)"]
[{"$nulls":3},"A.2 Quality Policy Approved by top management.",{"$nulls":4},{"$f":"Cover!J48","v":1}]
[{"$nulls":3},"A.3 Quality Objectives Approved by top management.",{"$nulls":4},{"$f":"Cover!J49","v":1}]
[{"$nulls":3},"A.4 Control of documented information (i.e. document and record control) \nClause 7.5 of ISO 9001:2015",{"$nulls":4},{"$f":"Cover!J51","v":0}]
[{"$nulls":3},"A.5 Documented information for Control of nonconforming outputs \nClause 8.7 of ISO 9001:2015",{"$nulls":4},{"$f":"Cover!J51","v":0}]
[{"$nulls":3},"A.6 Documented information for Nonconformity and Corrective action \nClause 10.2 of ISO 9001:2015",{"$nulls":4},{"$f":"Cover!J52","v":0}]
[{"$nulls":3},"A.7 Documented information for Internal audit \nClause 9.2 of ISO 9001:2015",{"$nulls":4},{"$f":"Cover!J53","v":0}]
[{"$nulls":3},"Section A Score Option 2",{"$nulls":4},{"$f":"SUM(I17:I23)","v":3}]
[]
[{"$nulls":3},"SECTION B :    Evidence of QMS in operation (Tender Quality Requirements -Ref 240-105658000)"]
[{"$nulls":8},"Apply =1"]
[{"$nulls":3},"B.1 Documented information for defined roles, responsibilities and authorities - Organization chart and Responsibility matrix (must include but not limited to quality management function/role) \n(Clause 5.3 of ISO 9001:2015) ",{"$nulls":4},{"$f":"Cover!J59","v":1}]
[{"$nulls":3},"B.2 Documented information for Control of Externally Provided Processes, Products and Services  - Must include criteria for evaluation, selection, monitoring of performance, and re-evaluation of external providers (Clause 8.4 of ISO 9001:2015)",{"$nulls":4},{"$f":"Cover!J60","v":1}]
[{"$nulls":3},"B.3 Latest copy of an internal management system audit report (with Nonconformity, Correction and/ or Corrective Action Reports) - Report must include but not limited to Objective, Scope, Criteria and outcomes  of the audit.  \n(Clause 9.2 of ISO 9001:2015)",{"$nulls":4},{"$f":"Cover!J61","v":0}]
[{"$nulls":3},"B.4 Latest copy of a certification management system audit report not older  than 12 months (with Nonconformity, Correction and/ or Corrective Action Reports)",{"$nulls":4},{"$f":"Cover!J62","v":0}]
[{"$nulls":3},"B.5 Records of Management Review meetings (minutes, attendance registers e.t.c)",{"$nulls":4},{"$f":"Cover!J63","v":0}]
[{"$nulls":3},"Section B Score",{"$nulls":4},{"$f":"SUM(I28:I32)","v":2}]
[]
[{"$nulls":8},"Apply (Yes=1)"]
[{"$nulls":3},"NB!   Draft Contract/Project Quality Plan has important QA deliverables",{"$nulls":4},{"$f":"Cover!J72","v":0}]
{"$rows_empty":18}
[{"$nulls":3},"Section C Score",{"$nulls":4},{"$f":"SUM(I36:I54)","v":0}]
[{"$nulls":8},"Apply (Yes=1)"]
[{"$nulls":3},"E.1 Form A is completed and signed.",{"$nulls":4},{"$f":"Cover!J84","v":1}]
[{"$nulls":3},"E.2 Add other requirements (if applicable) as per the scope of work and/ or specification",{"$nulls":4},{"$f":"Cover!J85","v":1}]
[{"$nulls":3},"Section E Score",{"$nulls":4},{"$f":"SUM(I57:I58)","v":2}]
[{"$nulls":3},"Certification of accredited workshop or an agreement that confirms access to an accredited workshop with capacity to provide service to Gauteng, Limpopo and Mpumalanga regions"]
[]
[{"$nulls":3},"NAME OF ESKOM REPPRESENTATIVE"]
[{"$nulls":3},"DATE ISSUED"]
[{"$nulls":3},"PROJECT: TENDER TITLE "]
[{"$nulls":3},"SIGNATURE"]

{"sheet":"Sheet1","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Sheet2","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}