{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Overall Localisation Schedule","OFO"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Overall Localisation Schedule","index":0,"n_rows":52,"n_cols":12,"rows_kept":52,"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,4,19,6],[18,7,19,7],[21,2,21,9],[29,4,29,5],[45,2,45,3],[47,2,47,3]]}
[]
[null,"NOTE TO TENDERERS: "]
[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 Tenderer"]
[]
[null,null,"TABLE 1: SUPPLIER DEVELOPMENT AND LOCALISATION COMPLIANCE MATRIX FOR SUPPLIERS AND CONTRACTORS"]
[null,null,"Criteria",null,"Weight (%)","Total Target (%)","Proposed Target (%)","Total Overall Weighted Score"]
[null,null,"Local Content to South Africa",null,{"v":0.5,"d":"50.00%"},{"v":1,"d":"100.00%"},null,{"$f":"IF(ISERROR(IF(G12>F12,E12,(E12*G12/F12))),\"\",(IF(G12>F12,E12,(E12*G12/F12))))","v":{"v":0,"d":"0.00%"}}]
[null,null,"Local Content Local to Site",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,{"$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 from LBS",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,{"$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 from BWO",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,{"$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 from BYO",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,{"$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,"Skills Development",null,{"v":0.5,"d":"50.00%"},null,null,{"$f":"SUM(E17)*J29","v":{"v":0,"d":"0.00%"}}]
[null,null,"Total Score",null,{"$f":"SUM(E12:E17)","v":{"v":1,"d":"100.00%"}}]
[{"$nulls":4},"Total Supplier Development and Localisation Score",null,null,{"$f":"SUM(H12:H18)","v":{"v":0,"d":"0.00%"}}]
[]
[]
[null,null,"TABLE 2: SKILLS DEVELOPMENT COMPLIANCE MATRIX"]
[null,null,"Skill Type (Occupation)","OFO Occupational Group","Weight (%)","Target Number of Persons to be Trained (Local to South Africa)","Proposed Number of Persons to be Trained \n(Local to \nSouth Africa)","Target Number of Persons to be Trained \n(Local to Site)","Proposed Number of Persons to be Trained \n(Local to Site)","Total Weighted Score"]
[null,null,"Grade C",null,{"v":0.8,"d":"80.00%"},6,{"$nulls":3},{"$f":"IF(OR(G24=\"\",I24=\"\"),0,IF(ISERROR((SUM(MIN(F24,G24),MIN(H24,I24))/SUM(F24,H24))*E24),\"\",(SUM(MIN(F24,G24),MIN(H24,I24))/SUM(F24,H24))*E24))","v":{"v":0,"d":"0.00%"}},null,"Total Weighted Score = {(Proposed Skills (Local to South Africa and Local to Site)/ Target Skills (Local to South Africa and Local to Site))*Skill Type Weight}"]
[null,null,"Site Supervisor ",null,{"v":0.2,"d":"20.00%"},1,{"$nulls":3},{"$f":"IF(OR(G25=\"\",I25=\"\"),0,IF(ISERROR((SUM(MIN(F25,G25),MIN(H25,I25))/SUM(F25,H25))*E25),\"\",(SUM(MIN(F25,G25),MIN(H25,I25))/SUM(F25,H25))*E25))","v":{"v":0,"d":"0.00%"}},null,"Total Weighted Score = {(Proposed Skills (Local to South Africa and Local to Site)/ Target Skills (Local to South Africa and Local to Site))*Skill Type Weight}"]
[{"$nulls":4},{"v":0,"d":"0.00%"},0,{"$nulls":3},{"$f":"IF(OR(G26=\"\",I26=\"\"),0,IF(ISERROR((SUM(MIN(F26,G26),MIN(H26,I26))/SUM(F26,H26))*E26),\"\",(SUM(MIN(F26,G26),MIN(H26,I26))/SUM(F26,H26))*E26))","v":{"v":0,"d":"0.00%"}},null,"Total Weighted Score = {(Proposed Skills (Local to South Africa and Local to Site)/ Target Skills (Local to South Africa and Local to Site))*Skill Type Weight}"]
[{"$nulls":4},{"v":0,"d":"0.00%"},0,{"$nulls":3},{"$f":"IF(OR(G27=\"\",I27=\"\"),0,IF(ISERROR((SUM(MIN(F27,G27),MIN(H27,I27))/SUM(F27,H27))*E27),\"\",(SUM(MIN(F27,G27),MIN(H27,I27))/SUM(F27,H27))*E27))","v":{"v":0,"d":"0.00%"}},null,"Total Weighted Score = {(Proposed Skills (Local to South Africa and Local to Site)/ Target Skills (Local to South Africa and Local to Site))*Skill Type Weight}"]
[{"$nulls":9},{"$f":"IF(OR(G28=\"\",I28=\"\"),0,IF(ISERROR((SUM(MIN(F28,G28),MIN(H28,I28))/SUM(F28,H28))*E28),\"\",(SUM(MIN(F28,G28),MIN(H28,I28))/SUM(F28,H28))*E28))","v":{"v":0,"d":"0.00%"}},null,"Total Weighted Score = {(Proposed Skills (Local to South Africa and Local to Site)/ Target Skills (Local to South Africa and Local to Site))*Skill Type Weight}"]
[{"$nulls":3},"Total",{"$f":"SUM(E24:E28)","v":{"v":1,"d":"100.00%"}},7,0,0,0,{"v":0,"d":"0.00%"}]
[{"$nulls":4},{"$f":"IF(E29>1,\"Total cannot exceed 100%\",\"\")","v":""}]
[]
[]
[null,null,"ADDITIONAL NOTES:"]
[null,null,"Local Content Local to Site refers to resourced obtained from the municipal district or province in which the project will take place."]
[null,null,"Skills Development candidates Local to Site shall be sourced from the district municipality or province in which the contracted goods or services will be consumed."]
[null,null,"Skills Development candidates Local to South Africa shall be sourced elsewhere in South Africa either than the province in which the project takes place."]
[null,null,"The targets and proposals for skills development Local to South Africa and Local to Site are exclusive."]
[]
[null,null,"To be completed by Tenderer"]
[null,null,"Number of jobs to be created as a result of this contract"]
[null,null,"Number of jobs to be retained as a result of this contract"]
[]
[]
[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":"OFO","index":1,"n_rows":23,"n_cols":3,"rows_kept":23}
[]
[null,"Legend: OFO Occupational Groups and Codes"]
[null,"OFO Occupational Group"]
[null,"Managers"]
[null,"Professionals"]
[null,"Technicians and Trade Workers"]
[null,"Community and Personal Service Workers"]
[null,"Sales Workers"]
[null,"Machinery Operators and Drivers"]
[null,"Elementary Workers"]
[null,"Example of Occupations","Code"]
[null,"Boilermaker (Welder)",322301]
[null,"Electrician(General)",341101]
[null,"Electrician (Special Class) ",341102]
[null,"Fitter",323201]
[null,"Fitter/Turner",323202]
[null,"Fitter Welder",323203]
[null,"Metal Turner ",323204]
[null,"Pressure Welder",322302]
[null,"Welder (First Class)",322303]
[null,"Product Quality Controller",839301]
[]
[null,"Website: "]