{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Sheet1","1. SCATT ITT Returnable","2. Job Creation","3. Designated Sectors","4. Localisation_subcontracting","5. Skills Development","6. Annex C","7. Annex D","8. Annex E","9. Returnables","Sheet5"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":14,"n_cols":18,"rows_kept":14,"hidden":true,"merged":[[1,1,1,17],[2,1,2,17],[3,1,3,9],[4,1,5,1],[4,2,4,3],[4,4,4,9],[4,10,4,17],[6,10,6,17],[7,4,7,9],[7,10,7,17],[8,4,8,17],[9,4,9,17],[11,1,11,9],[12,1,12,17],[13,1,13,17]]}
[]
[null,"Analysis sheet"]
[null,"SD&L Process"]
[null,"PPPFA process"]
[null,"Scope of Work / BOM","Total Spend  R",null,"% R Local spend on B-BBEE",{"$nulls":5},"Generic Process: Areas of opportunity for local participation "]
[null,null,"R foreign","R local","BO","BWO","BY","BPLwD","EME","Other","Design","Construction","Installation","Manufacture","Assembly","Testing","Commision","O&M services"]
[null,1,{"$nulls":8},"Skills Development Plan"]
[null,2,null,null,"Vendor Management: Valid B-BBEE criteria",{"$nulls":5},"Component Development Plan"]
[null,3,null,null,"                                                                   Approved Suppliers List (Koeberg)"]
[null,4,null,null,"                                                   Vendor Management: Supplier Capability & Capacity"]
[null,6]
[null,"                                                Tactical sourcing process ????"]
[null,"                                                                                                                         Commodity Sourcing process ?????"]
[null,"                                                                                                                         Project Sourcing Process ??????"]

{"sheet":"1. SCATT ITT Returnable","index":1,"n_rows":35,"n_cols":20,"rows_kept":35,"merged":[[3,1,3,19],[4,1,4,9],[4,10,4,19],[5,1,6,1],[5,2,5,3],[5,4,5,9],[5,10,5,19],[23,4,23,19],[24,4,24,19]]}
[]
[null,"Diagram 1: SCATT Methodology Addressing local development transformation requirements"]
[]
[null,"B-BBEE Transformation Analysis Sheet"]
[null,"Government Procurement Lever: Designations",{"$nulls":8},"Systems Engineering Approach (Industry value chain)"]
[null,"Scope of Work / BOM","Total Spend (R)",null,"% R Local Spend                                directed to B-BBEE",{"$nulls":5},"Area of Influence for local participation within the below Industry value chain"]
[null,null,"(R) foreign","(R) local","BO","BWO","BYO","BPwD","EME / QSE","OTHER","Design","Materials","NNR Approval","Manufacture","Assembly","Testing","Construction","Installation","Commision","Operate & Maintain"]
[null,"Resources/ Manpower costs"]
[null,"Detail design as stipulated in the TRS"]
[null,"Any engineering studies associated with providing the scope of works"]
[null,"Support of submittals to the National Nuclear Regulator (NNR) for detail design approval"]
[null,"Factory acceptance testing if required"]
[null,"Procurement and Manufacturing of the associated KIS equipment"]
[null,"Procurement of the associated installation hardware, including Prelimineries and General and all site cost"]
[null,"Installation of the new KIS equipment"]
[null,"The identification, dismantling and removal of the obsolete equipment to the scrap yard"]
[null,"Testing and Commissioning of the new KIS systems"]
[null,"Supply all special tools and equipment required to perform the prescribed maintenance on the proposed KIS system"]
[null,"Compile and Submit design documents, all revised and new documents and maintenance manuals as required by the TRS"]
[null,"Operator and Maintenance training"]
[null,"Materials"]
[null,"Manufacturing, Procurement and Supply of all material"]
[null,"Equipment delivery to Koeberg NPP"]
[{"$nulls":4},"Supplier Development Plan"]
[null,"TOTAL",null,"R","Central Supplier Database"]
[]
[null,"Notes:"]
[null,"1. The diagram above is referred to as the SCATT (Supply Chain and Transformation Tool) Methodology that addresses the South African government's local development and transformation requirements."]
[null,"2. The tenderer completes SCATT as part of the required tender returnable list."]
[null,"3. The tender, per scope of work element, needs to be unpacked by the tenderer to the relevant level of detail."]
[null,"4. The scope of work is required to be detailed by the tenderer in a specific way to address the “what” that the percentage local content entails."]
[null,"    - That is, for the needed transformation imperatives to progress into the detail, the package needs to be unpacked by the tenderer to the relevant level of detail, "]
[null,"      showing the sub-contracting elements and components, as applicable."]
[null,"    - The detail of local spend needs to be guided to the transformation (B-BBEE) spend(s), both as the main contractor and valid sub-contractors. "]
[null,"5. The reference to percentage local content is a reflection of the spend profile which is a financial breakdown only (R local = R total – R foreign)."]

{"sheet":"2. Job Creation","index":2,"n_rows":23,"n_cols":3,"rows_kept":23,"merged":[[0,0,0,1],[16,0,16,1],[18,0,18,1]]}
["Table 2 - Job creation"]
[]
["Tenderer to indicate the number of jobs to be created and/or retained as a direct result of being awarded this contract."]
[]
[]
["To be completed by Tenderer","Number of jobs created","Number of jobs retained"]
["Managerial Positions"]
["Expert Positions"]
["Skilled Positions"]
["Semi-skilled Positions"]
["Unskilled Positions"]
["Total number of jobs to be created or retained as a result of this contract"]
[]
[]
["To be completed by Bidder"]
[]
["Company:___________________________________________"]
[]
["Designation:_________________________________________"]
[]
["Signature:___________________________________________"]
[]
["Date:_______________________________________________"]

{"sheet":"3. Designated Sectors","index":3,"n_rows":24,"n_cols":4,"rows_kept":24}
["Table 3: Local Content and Production"]
["A.  Designated Sectors"]
[]
["Designated Sector/Sub sector/Industry","Component Description","the dtic Minimum Local Content Threshold (%)","Suppliers Proposal %"]
["Textile, Clothing, Leather, and Footwear","PPE Clothing",{"v":1,"d":"100%"}]
["Electrical and Telecom Cables","Electrical and Telecom Cables",{"v":0.9,"d":"90%"}]
["Steel Products and Components","Frames",{"v":1,"d":"100%"}]
[]
["NOTE: The Tender Returnable Annexures required to be submitted as a tender returnable (but due prior to contract award) are:"]
["1.    The Declaration Certificate for Local Content (SBD 6.2) and"]
["2.    Corresponding annexures C, D and E must be completed and duly signed (attached hereto)"]
["The above MUST be completed, duly signed, and submitted by the bidder prior to contract award."]
[]
["B. Process when requesting exemption letters (generic process)."]
["1. If the required input materials cannot be wholly sourced from South Africa, bidders should request and obtain a written exemption letter from the dtic. "]
["2. The exemption letter should then be submitted, and approvals obtained prior to the closure of the bid(s). "]
["3. The dtic together with the procuring organ of state and the winning bidder will consider the exemption on a case-by-case basis."]
["Link to the “Process when requesting exemption letters” on the dtic’s website:"]
["http://www.thedtic.gov.za/wp-content/uploads/IP-Exemption_letters.pdf"]
[]
["C. Note the following documents are included in the ITT for ease of reference:"]
["√ Guidance Document on the Calculation of Local Content"]
["√ Process to follow to request an ememption"]
["√ Technical specification number SATS 1286: 2011"]

{"sheet":"4. Localisation_subcontracting","index":4,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[1,1,1,2],[2,2,2,7],[3,1,3,2],[4,2,4,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[9,2,9,7],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,4,20,6],[19,7,20,7],[26,2,26,3],[28,2,28,3]]}
[]
[null,"NOTE TO BIDDERS: "]
[null,null,"1. The criteria, weightings and targets are set by Eskom.   \n2.  Industrialisation : Localisation includes proposed investment in plant through the establishment of new or expand existing capacity and capability. Suppliers proposing to increase local content through investment in plant must complete a separate template (commitment plan). "]
[null,"Legend"]
[null,null,"To be completed by Supplier Development and Localisation Representative"]
[null,null,"Automatically calculated or no calculation required",{"$nulls":8},"Comments"]
[null,null,"To be completed by Supplier Development and Localisation Representative"]
[null,null,"To be completed by BIDDER"]
[]
[null,null,"TABLE 1: SDL & I COMPLIANCE MATRIX for BATTERY ENERGY STORAGE SYSTEM"]
[null,null,"Criteria",null,"Weight (%)","Total Target (%)","Proposed Target (%)","Total Overall Weighted Score"]
[null,null,"** Local Content to South Africa",null,{"v":1,"d":"100.00%"},{"v":0.2,"d":"20.00%"}]
[null,null,"Local Content: Local to Site & Province",{"$nulls":4},{"$f":"IF(ISERROR((IF(G13>F13,1*E13,(G13/F13)*E13))*(IF($G$12>$F$12,1,($G$12/$F$12)))),\"\",((IF(G13>F13,1*E13,(G13/F13)*E13))*(IF($G$12>$F$12,1,($G$12/$F$12)))))","v":""}]
[null,null,"Procurement / Sub Contracting from BPwD",{"$nulls":4},{"$f":"IF(ISERROR((IF(G14>F14,1*E14,(G14/F14)*E14))*(IF($G$12>$F$12,1,($G$12/$F$12)))),\"\",((IF(G14>F14,1*E14,(G14/F14)*E14))*(IF($G$12>$F$12,1,($G$12/$F$12)))))","v":""}]
[null,null,"Procurement/ Sub Contracting from BWO",{"$nulls":4},{"$f":"IF(ISERROR((IF(G15>F15,1*E15,(G15/F15)*E15))*(IF($G$12>$F$12,1,($G$12/$F$12)))),\"\",((IF(G15>F15,1*E15,(G15/F15)*E15))*(IF($G$12>$F$12,1,($G$12/$F$12)))))","v":""}]
[null,null,"Procurement / Sub Contracting from BYO",{"$nulls":4},{"$f":"IF(ISERROR((IF(G16>F16,1*E16,(G16/F16)*E16))*(IF($G$12>$F$12,1,($G$12/$F$12)))),\"\",((IF(G16>F16,1*E16,(G16/F16)*E16))*(IF($G$12>$F$12,1,($G$12/$F$12)))))","v":""}]
[null,null,"Procurement/Sub Contracting from BO",{"$nulls":4},""]
[null,null,"Skills Development",{"$nulls":4},""]
[null,null,"Total Score",null,{"$f":"SUM(E12:E18)","v":{"v":1,"d":"100.00%"}}]
[{"$nulls":4},"Total Supplier Development and Localisation Score",null,null,{"$f":"SUM(H12:H19)","v":{"v":0,"d":"0.00%"}}]
[]
[]
[]
[]
[null,null,"To be completed by Tenderer",{"$nulls":4},"Supplier Development and Localisation Representative"]
[]
[null,null,"Company:_________________________________________________",{"$nulls":4},"Name:____________________________________"]
[]
[null,null,"Designation:______________________________________________"]
[{"$nulls":7},"Signature:_________________________________"]
[null,null,"Signature:________________________________________________"]
[{"$nulls":7},"Date:____________________________________"]
[null,null,"Date:__________________________________________________"]

{"sheet":"5. Skills Development","index":5,"n_rows":4,"n_cols":6,"rows_kept":4}
["SKILLS DEVELOPMENT"]
[]
[null,"Skills Category","Eskom Target","Entry","*","Tenderers Proposal"]
[null,"Instrumentation and Control (I&C) Engineering Technician Students",2,"N. Dip (I&C)","See below"]

{"sheet":"6. Annex C","index":6,"n_rows":30,"n_cols":17,"rows_kept":30,"merged":[[6,5,6,8],[6,15,7,16],[7,5,7,8],[8,5,8,8],[9,5,9,8],[10,5,10,8],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5]]}
[]
[{"$nulls":16},"SATS 1286.2011"]
[{"$nulls":3},"Annex C"]
[]
[{"$nulls":3},"Local Content Declaration - Summary Schedule "]
[]
[null,null,"(C1)","Tender No.",{"$nulls":11},"Note: VAT to be excluded from all calculations"]
[null,null,"(C2)","Tender description: "]
[null,null,"(C3)","Designated product(s)"]
[null,null,"(C4)","Tender Authority:"]
[null,null,"(C5)","Tendering Entity name:"]
[null,null,"(C6)","Tender Exchange Rate:",null,"Pula",null,"EU",null,"GBP"]
[null,null,"(C7)","Specified local content %"]
[{"$nulls":6},"Calculation of local content",{"$nulls":6},"Tender  summary"]
[{"$nulls":3},"Tender item no's","List of items",null,"Tender price - each \n(excl VAT)","Exempted imported value","Tender value  net of exempted imported  content","Imported value","Local value","Local content % (per item)",null,"Tender Qty","Total tender value","Total exempted imported content","Total Imported content"]
[{"$nulls":3},"(C8)","(C9)",null,"(C10)","(C11)","(C12)","(C13)","(C14)","(C15)",null,"(C16)","(C17)","(C18)","(C19)"]
{"$rows_empty":8}
[{"$nulls":13}," (C20)  Total tender  value",{"$f":"SUM(O17:O24)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},"Signature of tenderer from Annex B",{"$nulls":10},"(C21) Total Exempt imported content",{"$f":"SUM(P17:P25)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":14},"(C22) Total Tender value net of exempt imported content",{"$f":"+O25-P26","v":{"v":0,"d":"R  0"}}]
[{"$nulls":15},"(C23) Total Imported content",{"$f":"SUM(Q17:Q24)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":15},"(C24) Total local content",{"$f":"+P27-Q28","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},"Date: ",{"$nulls":11},"(C25) Average local content % of tender"]

{"sheet":"7. Annex D","index":7,"n_rows":59,"n_cols":16,"rows_kept":59,"merged":[[6,10,8,11],[13,2,13,6],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[20,13,21,15],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[36,2,36,6],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[47,6,47,7],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[57,13,58,15]]}
[]
[{"$nulls":15},"SATS 1286.2011"]
[null,null,"Annex D"]
[]
[null,null,"Imported Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(D1)","Tender No.",{"$nulls":7},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: "]
[null,"(D3)","Designated Products:"]
[null,"(D4)","Tender Authority:"]
[null,"(D5)","Tendering Entity name:"]
[null,"(D6)","Tender Exchange Rate:",null,"Pula",null,"EU",{"v":9,"d":"R  9.00"},"GBP",{"v":12,"d":"R  12.00"}]
[]
[null,null,"A. Exempted imported content",{"$nulls":4},"Calculation of imported content",{"$nulls":6},"Summary"]
[null,null,"Tender item no's","Description of imported content",null,"Local supplier","Overseas Supplier","Forign currency value as per Commercial Invoice","Tender   Exchange Rate","Local value of imports","Freight costs to port of entry","All locally incurred landing costs & duties","Total landed cost excl VAT",null,"Tender Qty","Exempted imported value"]
[null,null,"(D7)","(D8)",null,"(D9)","(D10)","(D11)","(D12)","(D13)","(D14)","(D15)","(D16)",null,"(D17)","(D18)"]
[]
[]
[]
[{"$nulls":14}," (D19) Total exempt imported value",{"$f":"SUM(P17:P18)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":13},"This total must correspond with Annex C - C 21"]
[]
[]
[null,null,"B. Imported directly by the Tenderer",{"$nulls":4},"Calculation of imported content",{"$nulls":6},"Summary"]
[null,null,"Tender item no's","Description of imported content",null,"Unit of measure","Overseas Supplier","Forign currency value as per Commercial Invoice","Tender Rate of Exchange","Local value of imports","Freight costs to port of entry","All locally incurred landing costs & duties","Total landed cost excl VAT",null,"Tender Qty","Total imported value"]
[null,null,"(D20)","(D21)",null,"(D22)","(D23)","(D24)","(D25)","(D26)","(D27)","(D28)","(D29)",null,"(D30)","(D31)"]
{"$rows_empty":7}
[{"$nulls":3},"`"]
[{"$nulls":14},"(D32)Total imported value by tenderer",{"$f":"SUM(P27:P34)","v":{"v":0,"d":"R  0"}}]
[]
[null,null,"C. Imported by a 3rd party and supplied to the Tenderer",{"$nulls":4},"Calculation of imported content",{"$nulls":6},"Summary"]
[null,null,"Description of imported content",null,"Unit of measure","Local supplier","Overseas Supplier","Forign currency value as per Commercial Invoice","Tender Rate of Exchange","Local value of imports","Freight costs to port of entry","All locally incurred landing costs & duties","Total landed cost excl VAT",null,"Quantity imported","Total imported value"]
[null,null,"(D33)",null,"(D34)","(D35)","(D36)","(D37)","(D38)","(D39)","(D40)","(D41)","(D42)",null,"(D43)","(D44)"]
[]
[]
[]
[]
[]
[null,null,"`"]
[{"$nulls":14},"(D45) Total imported value by 3rd party",{"$f":"SUM(P40:P45)","v":{"v":0,"d":"R  0"}}]
[]
[null,null,"D. Other foreign currency payments",{"$nulls":3},"Calculation of foreign currency payments",{"$nulls":8},"Summary of payments"]
[null,null,"Type of payment",null,"Local supplier making the payment","Overseas beneficiary","Foreign currency value paid","Tender Rate of Exchange",{"$nulls":7},"Local value of payments"]
[null,null,"(D46)",null,"(D47)","(D48)","(D49)","(D50)",{"$nulls":7},"(D51)"]
[]
[]
[]
[]
[{"$nulls":14},"(D52) Total of  foreign currency payments declared by tenderer and/or 3rd party"]
[null,null,"Signature of tenderer from Annex B"]
[{"$nulls":14},"(D53) Total of imported content & foreign currency payments - (D32), (D45) & (D52) above",{"$f":"+P35+P46+P55","v":{"v":0,"d":"R  0"}}]
[{"$nulls":13},"This total must correspond with Annex C  - C 23"]
[null,null,"Date: "]

{"sheet":"8. Annex E","index":8,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[2,2,2,8],[4,2,4,9],[6,7,7,8],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[36,7,36,8]]}
[]
[{"$nulls":8},"SATS 1286.2011"]
[null,null,"Annex E"]
[]
[null,null,"Local Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(E1)","Tender No.",{"$nulls":4},"Note: VAT to be excluded from all calculations"]
[null,"(E2)","Tender description: "]
[null,"(E3)","Designated products:"]
[null,"(E4)","Tender Authority:"]
[null,"(E5)","Tendering Entity name:"]
[]
[]
[{"$nulls":3},"Local Products (Goods, Services and Works)","Description of items purchased",null,null,"Local suppliers","Value","% of LC"]
[{"$nulls":4},"(E6)",null,null,"(E7)","(E8)"]
{"$rows_empty":12}
[{"$nulls":7},"(E9) Total local products (Goods, Services and Works)",{"$f":"SUM(I16:I27)","v":{"v":0,"d":"R 0"}}]
[]
[null,null,"(E10)","Manpower costs","( Tenderer's manpower cost)",{"$nulls":3},{"v":0,"d":"R 0"}]
[]
[null,null,"(E11)","Factory overheads","(Rental, depreciation & amortisation, utility costs, consumables etc.)",{"$nulls":3},{"v":0,"d":"R 0"}]
[]
[null,null,"(E12)","Administration overheads and mark-up",null,"(Marketing, insurance, financing, interest etc.)",null,null,{"v":0,"d":"R 0"}]
[]
[{"$nulls":7},"(E13)  Total local content",{"v":0,"d":"R 0"}]
[{"$nulls":7},"This total must correspond with Annex C  - C24"]
[]
[null,null,"Signature of tenderer from Annex B"]
[]
[]
[]
[null,null,"Date: "]

{"sheet":"9. Returnables","index":9,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[1,0,2,0],[3,0,9,0]]}
["Item","Returnables","Tender Closing","Contract Award"]
["A.1","Signed and completed Table 1: Supplier Chain and Transformation Tool (SCATT-Phase1)","√"]
[null,"Signed letter of Intent to sub-contract as per requirements listed. ",null,"√"]
["A.2","The following source of evidence for sub-contractors will be required from the main contractor:",null,"√"]
[null,"Signed subcontracting agreement between main contractor and subcontractor/s."]
[null,"Proof of subcontractor Central Supplier Database (CSD) registration."]
[null,"SANAS Accredited valid B-BBEE certificate or sworn affidavits (refer to bidding document volume 4 - supplementary information) Company registration documents"]
[null,"Share certificate for subcontractors (where applicable)"]
[null,"Proof of business address of subcontractor/s."]
[null,"Plan to develop sub-contractor/s."]
["B.1","Completed Table 2: Job Creation commitments",null,"√"]
["B.2","Completed Table 4: Localisation (subcontracting)",null,"√"]
["B.3.1","Completed Table 5: Skills Development",null,"√"]
["B.4","Table 3: Indicate Local threshold for designated sectors",null,"√"]
["B.4.1","Submit completed and duly signed Annex C,D,E",null,"√"]

{"sheet":"Sheet5","index":10,"n_rows":0,"n_cols":0,"rows_kept":0}