{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["SUMMARY","Kendal","Kusile ","Medupi Ash &Coal","Medupi Auxillary &WTP","Grootvlei MMD","Majuba","Tutuka","BWH","Lethabo","Sheet2"],"not_rendered":{"external_links":2},"read":"whole","date_system":"1900"}

{"sheet":"SUMMARY","index":0,"n_rows":14,"n_cols":10,"rows_kept":14}
[{"$nulls":3},{"v":0.05,"d":"5%"}]
[null,"SITE","TOTAL ","CPA Estimate",null,null,"FY1","FY2","FY3"]
[]
[null,"KUSILE",{"$f":"'Kusile '!I64","v":0},{"$f":"C4*$D$1","v":0},null,"Budget",{"$f":"C10*0.165","v":0},{"$f":"C10*0.5","v":0},{"$f":"C10*0.335","v":0},{"$f":"G4+H4+I4","v":0}]
[null,"MAJUBA",{"$f":"Majuba!I55","v":0},{"$f":"C5*$D$1","v":0},null,"Contingency",0,0,{"$f":"C12","v":0},{"$f":"G5+H5+I5","v":0}]
[null,"TUTUKA",{"$f":"Tutuka!I57","v":0},0,null,"CPA",0,{"$f":"C14*0.33","v":0},{"$f":"C14*0.67","v":0},{"$f":"G6+H6+I6","v":0}]
[null,"BWH",{"$f":"BWH!I44","v":0},0,null,null,{"$f":"SUM(G4:G6)","v":0},{"$f":"SUM(H4:H6)","v":0},0,0]
[null,"LETHABO",{"$f":"Lethabo!I40","v":0},0]
[null,"MEDUPI",{"$f":"'Medupi Ash &Coal'!I54","v":0},0]
[null,"TOTAL",{"$f":"SUM(C4:C9)","v":0},{"$f":"SUM(D4:D9)","v":0}]
[]
[null,"Contingency 10%",{"$f":"C10*0.1","v":0}]
[null,"Grand Total",{"$f":"C10+C12","v":0}]
[null,"CPA Estimate",{"$f":"D10","v":0}]

{"sheet":"Kendal","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"hidden":true,"merged":[[12,3,12,7],[35,3,35,7],[36,3,36,7]]}
[]
[null,"KUSILE POWER STATION "]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","TOTAL 24 MONTHS"]
["A1.1","Site Establishment",null,"Sum",1,1,{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"E5*F5*G5*H5","v":{"$error":"#REF!"}}]
["A1.2","ablution ( Space for change house and locker rooms.",null,"Sum",1,1,{"$f":"#REF!","v":{"$error":"#REF!"}},3,{"$error":"#REF!"}]
["A1.3","Transport",null,"Month ",1,2,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"E7*F7*G7*H7","v":{"$error":"#REF!"}}]
["A1.4","Double Cab Bakkie",null,"Month ",1,1,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"E8*F8*G8*H8","v":{"$error":"#REF!"}}]
["A1.5","Safety Training",null,"Annual",1,32,{"$f":"[1]RATES!C17","v":{"v":3500,"d":"R 3,500.00"}},3,{"$f":"E9*F9*G9*H9","v":{"v":336000,"d":"R 336,000.00"}}]
["A1.6","Annual Medical + Exit Medical",null,"Annual",1,32,{"$f":"[1]RATES!C19","v":{"v":800,"d":"R 800.00"}},4,{"v":102400,"d":"R 102,400.00"}]
["A1.7","PPE",null,"Annual",1,32,{"$f":"[1]RATES!C20","v":{"v":1200,"d":"R 1,200.00"}},3,{"v":115200,"d":"R 115,200.00"}]
["A1.8","Site De-establishment (once-off)- N/A",null,"Sum",1,1,{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"E12*F12*G12*H12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I12)","v":{"$error":"#REF!"}}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  36 MONTHS"]
["B1.1","Site Manager","M14","Hours ",173,1,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"E17*F17*G17*H17","v":{"$error":"#REF!"}}]
["B1.2","Senior Supervisor Technical  shifts","T13","Hours ",198,4,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.3","Senior supervisor shift allowance @ 15%","T13","Hours ",198,4,{"$f":"SUM(G18*0.15)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.4","Senior Supervisor Overtime @2,0","T13","Hours ",24,2,{"$f":"SUM(G18*2)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.5","Mechanical Technician Day Shift","T12","Hours ",198,2,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.6","Mechanical Technician Overtime @1,5","T12","Hours ",30,2,{"$f":"SUM(G21*1.5)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.7","Mechanical technician overtime @2,0","T12","Hours ",12,2,{"$f":"SUM(G21*2)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.8","Safety officer Day","T12","Hours ",173,1,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"E24*F24*G24*H24","v":{"$error":"#REF!"}}]
["B1.9","Safety officer Overtime @ 1,5","T12","Hours ",20,1,{"$f":"SUM(G24*1.5)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.10","Safety officer Overtime @ 2.0","T12","Hours ",20,1,{"$f":"SUM(G24*2)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.11","Fitter Artisan (shifts)","T09","Hours ",198,8,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"E27*F27*G27*H27","v":{"$error":"#REF!"}}]
["B1.12","Shift allowance Fitter Artisan @15%","T09","Hours ",198,8,{"$f":"SUM(G27*0.15)","v":{"$error":"#REF!"}},36,{"$f":"E28*F28*G28*H28","v":{"$error":"#REF!"}}]
["B1.13","Fitter Artisan (shifts) Overtime @ 2.0","T09","Hours ",24,2,{"$f":"G27*2","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.14","Boilermaker Shifts","T09","Hours ",198,4,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.15","Shift allowance Boilermaker Overtime @15%","T09","Hours ",198,4,{"$f":"SUM(G30*15%)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.16","Boilermaker Shifts overtime @ 2.0","T09","Hours ",24,1,{"$f":"(G30*2)","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.17","Utility man Shifts","T04","Hours ",198,12,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"E33*F33*G33*H33","v":{"$error":"#REF!"}}]
["B1.18","Shift allowance Utility man @15%","T04","Hours ",198,12,{"$f":"SUM(G33*0.15)","v":{"$error":"#REF!"}},36,{"$f":"E34*F34*G34*H34","v":{"$error":"#REF!"}}]
["B1.19","Utility man Shifts Overtime @ 2.0","T04","Hours ",24,4,{"$f":"G33*2","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",{"$nulls":4},{"$f":"SUM(I17:I35)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I36,I13)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor                                                           2. Contractor to supply their own furniture and storage lockers"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office Space\n"]
["Note3 Training will be listed as part of SOW"]

{"sheet":"Kusile ","index":2,"n_rows":73,"n_cols":9,"rows_kept":73,"merged":[[20,3,20,7],[62,3,62,7],[63,3,63,7]]}
[]
[null,"KUSILE POWER STATION "]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","Total 24 months "]
["A1.1","Site Establishment (Furniture only, office space will be provided by ERI)",null,"Sum",1,1,null,1,{"$f":"E5*F5*G5*H5","v":0}]
["A1.2","Change house and locker rooms with lockers ( Once Off )",null,"Sum",1,2,null,1,0]
["A1.3","Transport",null,"Month ",1,2,null,24,{"$f":"E7*F7*G7*H7","v":0}]
["A1.4","Double cab Bakkie",null,"Month ",1,2,null,24,{"$f":"E8*F8*G8*H8","v":0}]
["A1.5","Safety Training",null,"Annual",1,{"$f":"F25+F28+F31+F34+F37+F41+F51+F55+F45+F48","v":82},null,2,{"$f":"E9*F9*G9*H9","v":0}]
["A1.6","Annual Medical + Exit Medical",null,"Annual",1,81,null,3,0]
["A1.7","PPE",null,"Annual",1,81,null,2,0]
["A1.8","Winter Jackets",null,"2 Yearly ",1,81,null,2,0]
["A1.9","Rain Coats ",null,"Annual",1,81,null,1,0]
["A1.10","Standby Allowance",null,"Days ",14,{"$f":"F45+F55+F51+F41","v":59},null,24,0]
["A1.11","Cellphone Allowances",null,"Month ",1,7,null,24,0]
["A1.12","Other allowances ( RP)",null,"Month ",1,22,null,24,0]
["A1.13","Travelling ( for MIE)",null,"KM",1,1200,null,12,0]
["A1.14","Tools and consumables ( for MIE)",null,"As and when",1,1,null,12,0]
["A1.15","Issuing of Certificate of Compliance",null,"Each",60,1,null,6,0]
["A1.16","Site De-establishment (once-off)",null,"Sum",1,1,null,1,{"$f":"E20*F20*G20*H20","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I20)","v":0}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","Total 24 months "]
["B1.1","Senior Supervisor Technical ","T13","Hours ",173,1,null,24,{"$f":"E25*F25*G25*H25","v":0}]
["B1.2","Senior supervisor Overtime @1,5","T13","Hours ",40,1,null,24,0]
["B1.3","Senior Supervisor Overtime @2,0","T13","Hours ",24,1,null,24,0]
["B1.4","Technician Mechanical  & C&I Day Shift","T12","Hours ",173,5,null,24,0]
["B1.5","Technician Mechanical  & C&I  Overtime @1,5","T12","Hours ",24,5,null,24,0]
["B1.6","Technician Mechanical  & C&I overtime @2,0","T12","Hours ",24,5,null,24,0]
["B1.7","Quality Controller Day Shift","T12","Hours ",173,2,null,24,0]
["B1.8","Quality Controller Overtime @1,5","T12","Hours ",24,2,null,24,0]
["B1.9","Quality Controller  overtime @2,0","T12","Hours ",24,2,null,24,0]
["B1.10","Safety officer Day","T12","Hours ",173,1,null,24,0]
["B1.11","Safety officer Overtime @ 1,5","T12","Hours ",20,1,null,24,0]
["B1.12","Safety officer Overtime @ 2.0","T12","Hours ",20,1,null,24,0]
["B1.13","Fitter Artisan (shifts)","T09","Hours ",183,12,null,24,0]
["B1.14","Shift allowance Fitter Artisan @15%","T09","Hours ",183,12,null,24,0]
["B1.15","Fitter Artisan (shifts) overtime @ 1,5","T09","Hours",24,12,null,24,0]
["B1.16","Fitter Artisan (shifts) overtime @ 2.0","T09","Hours ",36,12,null,24,0]
["B1.17","Boilermaker shifts","T09","Hours ",183,4,null,24,0]
["B1.18","Boilermaker shifts allowance @ 15%","T09","Hours ",183,4,null,24,0]
["B1.19","Boilermaker shifts overtime @ 1,5","T09","Hours",24,4,null,24,0]
["B1.20","Boilermaker shifts overtime @ 2.0","T09","Hours ",36,4,null,24,0]
["B1.21","Fitter Artisan ","T09","Hours",173,18,null,24,0]
["B1.22","Fitter Artisan overtime @ 1,5","T09","Hours",40,18,null,24,0]
["B1.23","Fitter Artisan overtime @ 2.0","T09","Hours",24,18,null,24,0]
["B1.24","Rigger ","T09","Hours",173,2,null,24,0]
["B1.25","Rigger Overtime @1,5","T09","Hours",40,2,null,24,0]
["B1.26","Rigger Overtime @2","T09","Hours",24,2,null,24,0]
["B1.27","Electrical Artisan Shifts","T09","Hours ",183,7,null,24,0]
["B1.28","Electrical Artisan  Shift Allowance @15%","T09","Hours ",183,7,null,24,0]
["B1.29","ElectricalArtisan Overtime @ 1,5","T09","Hours ",24,7,null,24,0]
["B1.30","Electrical Artisan  Overtime @ 2.0","T09","Hours ",36,7,null,24,0]
["B1.31","Utility man Shifts","T04","Hours ",183,30,null,24,0]
["B1.32","Shift allowance Utility man @15%","T04","Hours ",183,30,null,24,0]
["B1.33","Utility man Shifts Overtime@1,5","T04","Hours",24,30,null,24,0]
["B1.34","Utility man Shifts Overtime@2.0","T04","Hours ",36,30,null,24,0]
["B1.35","Master installation electrician",null,"Hours ",1500,1,null,6,0]
[]
[]
[]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I25:I59)","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I63,I21)","v":0}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor. A list of minimum tools the artisans require is attached\n2. Contractor to supply their own furniture and storage lockers"]
["Note 2 ","All facilities will be supplied by the Employer \n1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note 3 ","Training will be listed as part of SOW"]
[]
["Note 4","Contractor to purchase 2 x change houses with lockers . The  change houses will become the property of ERI upon completion of the contract"]
[]
["Note 5","RP allowance must be paid in line with what ERI is paying .  The rate is as provided and will be escalated based on how ERI escaates theirs. "]

{"sheet":"Medupi Ash &Coal","index":3,"n_rows":61,"n_cols":9,"rows_kept":61,"merged":[[52,3,52,7],[53,3,53,7]]}
[]
[null,"MEDUPI POWER STATION"]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","Total 24 months "]
["A1.1","Site Establishment (Furniture only, office space will be provided by ERI)",null,"Sum",1,1,null,1,{"$f":"E5*F5*G5*H5","v":0}]
["A1.2","Transport (22 Seater)",null,"Month ",1,3,null,24,{"$f":"E6*F6*G6*H6","v":0}]
["A1.3","Safety Training",null,"Annual",1,{"$f":"F21+F22+F23+F26+F29+F32+F35+F38+F41+F44+F47+F50","v":116},null,2,0]
["A1.4","Annual Medical + Exit Medical",null,"Annual",1,116,null,3,0]
["A1.5","PPE",null,"Annual",1,116,null,2,0]
["A1.6","Winter Jackets",null,"2 Yearly ",1,116,null,1,0]
["A1.7","Rain Coats ",null,"Annual",1,116,null,2,0]
["A1.8","Standby Allowance",null,"Days ",14,{"$f":"F23+F26+F29+F32+F35+F38+F41+F44+F47+F50","v":114},null,24,0]
["A1.9","Cellphone Allowances",null,"Month ",1,{"$f":"F21+F22+F23+F26+F29","v":13},null,24,0]
["A1.10","Other allowances ( RP)",null,"Month ",1,{"$f":"F24+F27+F29+F32+F35+F38+F44","v":49},null,24,0]
["A1.11","Site De-establishment (once-off)",null,"Sum",1,1,null,1,0]
[]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I15)","v":0}]
[]
[{"$nulls":5},{"$f":"F21+F22+F23+F26+F29+F32+F35+F38+F41+F44+F47+F50","v":116}]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number","Rate","Period","Total 24 months "]
["B1.1","Project  Manager ","M15","Hours ",173,1,null,24,{"$f":"G21*H21*E21*F21","v":0}]
["B1.2","HR/IR Practioner ","T12","Hours ",173,1,null,24,0]
["B1.3","Snr Mech/Elec Supervisor","T13","Hours ",173,2,null,24,0]
["B1.4","Snr Supervisor overtime @ 1,5","T13","Hours ",40,2,null,24,0]
["B1.5","Snr Supervisor overtime @ 2.0","T13","Hours ",24,1,null,24,0]
["B1.6","Snr  Supervisor C &I and Electrical","T13","Hours ",173,2,null,24,0]
["B1.7","Snr  Supervisor C &I and Electrical overtime @ 1,5","T13","Hours ",40,2,null,24,0]
["B1.8","Snr  Supervisor C &I overtime @ 2.0","T13","Hours ",24,2,null,24,0]
["B1.9","C&I Technician","T12","Hours ",173,7,null,24,0]
["B1.10","C&I Technician overtime @ 1,5","T12","Hours ",40,7,null,24,0]
["B1.11","C&I Technician overtime @ 2","T12","Hours ",24,7,null,24,0]
["B1.12","Electrician","T09","Hours ",173,15,null,24,0]
["B1.13","Electrician overtime @ 1,5","T09","Hours ",40,15,null,24,0]
["B1.14","Electrician overtime @ 2.0","T09","Hours ",24,15,null,24,0]
["B1.15","C&I Artisan","T09","Hours ",173,5,null,24,0]
["B1.16","C&I Artisan overtime @ 1,5","T09","Hours ",40,5,null,24,0]
["B1.17","C&I Artisan overtime @ 2.0","T09","Hours ",24,5,null,24,0]
["B1.18","Fitter Artisan","T09","Hours ",173,14,null,24,0]
["B1.19","Fitter Artisan overtime @ 1,5","T09","Hours ",40,14,null,24,0]
["B1.20","Fitter Artisan overtime @ 2.0","T09","Hours ",24,14,null,24,0]
["B1.21","Rigger","T09","Hours ",173,16,null,24,0]
["B1.22","Rigger overtime @ 1,5","T09","Hours ",40,16,null,24,0]
["B1.23","Rigger overtime @ 2.0","T09","Hours ",24,16,null,24,0]
["B1.24","Welder","T09","Hours ",173,4,null,24,0]
["B1.25","Welder overtime @ 1,5","T09","Hours ",40,4,null,24,0]
["B1.26","Welder overtime @ 2,0","T09","Hours ",24,4,null,24,0]
["B1.27","Crane Operators","T05","Hours",173,3,null,24,0]
["B1.28","Crane Operators Overtime @1,5","T05","Hours",40,3,null,24,0]
["B1.29","Crane OperatorsOvertime @2,0","T05","Hours",24,3,null,24,0]
["B1.30","Semi-skilled","T04","Hours ",173,46,null,24,0]
["B1.31","Semi-Skilled Shifts Overtime@1,5","T04","Hours ",40,46,null,24,0]
["B1.32","Semi-Skilled Shifts Overtime@2.0","T04","Hours ",24,46,null,24,0]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I21:I52)","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I53,I17)","v":0}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor 2.  A list of minimum tools the artisans require is attached. \nContractor to supply  furniture and storage lockers"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note3 Training will be listed as part of SOW"]
[]
[null,"RP allownace must be paid in line with what ERI is paying .  The rate is as provided and will be escalated based on how ERI escaates theirs. "]

{"sheet":"Medupi Auxillary &WTP","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"hidden":true,"merged":[[30,3,30,7],[31,3,31,7]]}
[]
[null,"MEDUPI POWER STATION -MAINTENANCE AUXILLARY"]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","TOTAL 36 MONTHS"]
["A1.1","Site Establishment",null,"Sum",1,1,{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"F5*G5*H5*E5","v":{"$error":"#REF!"}}]
["A1.2","Transport (22 Seater)",null,"Month ",1,2,{"$f":"#REF!","v":{"$error":"#REF!"}},3,{"$f":"F6*G6*H6*E6","v":{"$error":"#REF!"}}]
["A1.3","Safety Training",null,"Annual",1,35,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["A1.4","Annual Medical + Exit Medical",null,"Annual",1,{"$f":"F21+F24+F27+F30","v":42},{"$f":"#REF!","v":{"$error":"#REF!"}},3,{"$error":"#REF!"}]
["A1.5","PPE",null,"Annual",1,42,{"$f":"#REF!","v":{"$error":"#REF!"}},3,{"$error":"#REF!"}]
["A1.6","Winter Jackets",null,"2 Yearly ",1,42,{"$f":"[1]RATES!C19","v":{"v":800,"d":"R 800.00"}},4,{"v":134400,"d":"R 134,400.00"}]
["A1.7","Rain Coats ",null,"Annual",1,42,{"v":400,"d":"R 400.00"},3,{"v":50400,"d":"R 50,400.00"}]
["A1.8","Standby Allowance",null,"Days",14,41,{"v":95,"d":"R 95.00"},36,{"v":1963080,"d":"R 1,963,080.00"}]
["A1.9","Cellphone Allowances",null,"Monthly",1,42,{"v":650,"d":"R 650.00"},36,{"v":982800,"d":"R 982,800.00"}]
["A1.10","Other allowances ( RP)",null,"Month ",1,11,{"v":650,"d":"R 650.00"},36,{"v":257400,"d":"R 257,400.00"}]
["A1.11","Rain Coats ",null,"Annual",1,42,{"v":400,"d":"R 400.00"},36,{"v":604800,"d":"R 604,800.00"}]
["A1.12","Site De-establishment (once-off)",null,"Sum",1,1,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I16)","v":{"$error":"#REF!"}}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  36 MONTHS"]
["B1.1","Electrician","T09","Hours ",173,11,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"H21*E21*F21*G21","v":{"$error":"#REF!"}}]
["B1.2","Electrician overtime @ 1,5","T09","Hours ",40,11,{"$f":"#REF!*1.5","v":{"$error":"#REF!"}},36,{"$f":"H22*E22*F22*G22","v":{"$error":"#REF!"}}]
["B1.3","Electrician overtime @ 2.0","T09","Hours ",24,11,{"$f":"#REF!*2","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.4","Rigger","T09","Hours ",173,8,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.5","Rigger overtime @ 1,5","T09","Hours ",40,8,{"$f":"#REF!*1.5","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.6","Rigger overtime @ 2.0","T09","Hours ",24,8,{"$f":"#REF!*2","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.7","Semi-skilled","T04","Hours ",173,22,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.8","Semi-Skilled Shifts Overtime@1,5","T04","Hours ",40,22,{"$f":"#REF!*1.5","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.9","Semi-Skilled Shifts Overtime@2.0","T04","Hours ",24,22,{"$f":"#REF!*2","v":{"$error":"#REF!"}},36,{"$error":"#REF!"}]
["B1.10","Site Clerck","T05","Hours ",173,1,{"$f":"#REF!","v":{"$error":"#REF!"}},36,{"$f":"H30*E30*F30*G30","v":{"$error":"#REF!"}}]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I21:I30)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"I31+I17","v":{"$error":"#REF!"}}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor 2. Contractor to supply their own furniture and storage lockers"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note3 Training will be listed as part of SOW"]

{"sheet":"Grootvlei MMD","index":5,"n_rows":69,"n_cols":9,"rows_kept":69,"hidden":true,"merged":[[19,3,19,7],[62,3,62,7],[63,3,63,7]]}
[]
[null,"GROOTVLEI POWER STATION - MMD"]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","TOTAL 24 MONTHS"]
["A1.1","Site Establishment",null,"Sum",1,1,{"$f":"[2]RATES!C22","v":{"v":8000,"d":"R 8,000.00"}},1,{"$f":"E5*F5*G5*H5","v":{"v":8000,"d":"R 8,000.00"}}]
["A1.2","ablution ( Space for change house and locker rooms.",null,"Sum",1,1,{"$f":"[2]RATES!C19","v":{"v":200000,"d":"R 200,000.00"}},3,{"v":600000,"d":"R 600,000.00"}]
["A1.3","Transport",null,"Month ",1,1,{"$f":"[2]RATES!C16","v":{"v":45000,"d":"R 45,000.00"}},36,{"$f":"E7*F7*G7*H7","v":{"v":1620000,"d":"R 1,620,000.00"}}]
["A1.4","Double cab Bakkie",null,"Month ",1,3,{"$f":"[2]RATES!C23","v":{"v":30000,"d":"R 30,000.00"}},36,{"$f":"E8*F8*G8*H8","v":{"v":3240000,"d":"R 3,240,000.00"}}]
["A1.5","Safety Training",null,"Annual",1,52,{"$f":"[1]RATES!C17","v":{"v":3500,"d":"R 3,500.00"}},3,{"$f":"E9*F9*G9*H9","v":{"v":546000,"d":"R 546,000.00"}}]
["A1.6","Annual Medical + Exit Medical",null,"Annual",1,52,{"$f":"[1]RATES!C19","v":{"v":800,"d":"R 800.00"}},4,{"v":166400,"d":"R 166,400.00"}]
["A1.7","PPE",null,"Annual",1,52,{"$f":"[1]RATES!C20","v":{"v":1200,"d":"R 1,200.00"}},3,{"v":187200,"d":"R 187,200.00"}]
["A1.8","Site De-establishment (once-off)- N/A",null,"Sum",1,1,{"$f":"[2]RATES!C22","v":{"v":8000,"d":"R 8,000.00"}},1,{"$f":"E12*F12*G12*H12","v":{"v":8000,"d":"R 8,000.00"}}]
["A1.9","Safety file",null,"Sum",1,1,null,1,{"$f":"E13*F13*G13*H13","v":0}]
["A1.10","Arc flash suits",null,"Each",1,19,null,3,0]
["A1.11","Masks (2 per person – cloths)",null,"Each",1,52,null,5,0]
["A1.12","Cellphone allowance - Manager",null,"Month ",1,2,{"v":850,"d":"R 850.00"},36,{"v":61200,"d":"R 61,200.00"}]
["A1.13","Cellphone allowance - Supervisor",null,"Month ",1,5,{"v":650,"d":"R 650.00"},36,{"v":117000,"d":"R 117,000.00"}]
["A1.14","Winter Jackets",null,"Bi-annual",1,52,null,2.5,0]
[]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I12)","v":{"v":6375600,"d":"R 6,375,600.00"}}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  36 MONTHS"]
["B1.1","Project  Manager ","M15","Hours",173,0.25,null,36]
["B1.2","Site Manager","M14","Hours",173,1,{"$f":"[2]RATES!C14","v":387.16},36,{"$f":"E25*F25*G25*H25","v":{"v":2411232.4800000004,"d":"R 2,411,232.48"}}]
["B1.3","Diesel Mechanic ","T09","Hours",173,1,{"$f":"[2]RATES!C9","v":180.35},36,{"v":1123219.8,"d":"R 1,123,219.80"}]
["B1.4","Diesel Mechanic Standby allowance","T09","Hours",35,1,{"v":94,"d":"94.00"},36,{"v":118440,"d":"R 118,440.00"}]
["B1.5","Diesel Mechanic Overtime @1,5","T09","Hours",10,1,{"$f":"SUM(G26*1.5)","v":{"v":270.525,"d":"270.53"}},36,{"v":97389,"d":"R 97,389.00"}]
["B1.6","Diesel Mechanic Overtime @2,0","T09","Hours",20,1,{"$f":"SUM(G26*2)","v":{"v":360.7,"d":"360.70"}},36,{"v":259704,"d":"R 259,704.00"}]
["B1.7","Senior Supervisor Technical ","T13","Hours ",173,4,{"$f":"[2]RATES!C12","v":237.19},36,{"v":5908877.28,"d":"R 5,908,877.28"}]
["B1.8","Senior supervisor Standby allowance ","T13","Hours ",35,4,{"v":94,"d":"94.00"},36,{"v":473760,"d":"R 473,760.00"}]
["B1.9","Senior Supervisor Overtime @1,5","T13","Hours ",85,4,{"$f":"SUM(G30*1.5)","v":{"v":355.78499999999997,"d":"355.79"}},36,{"v":4354808.399999999,"d":"R 4,354,808.40"}]
["B1.10","Senior Supervisor Overtime @2,0","T13","Hours ",45,4,{"$f":"SUM(G30*2)","v":474.38},36,{"v":3073982.4,"d":"R 3,073,982.40"}]
["B1.11","Administrator Day ","T05","Hours ",173,1,{"$f":"[2]RATES!C5","v":86.65},36,{"v":539656.2000000001,"d":"R 539,656.20"}]
["B1.12","Storeman ","T05","Hours ",173,1,{"$f":"[2]RATES!C6","v":86.65},36,{"v":539656.2000000001,"d":"R 539,656.20"}]
["B1.13","Storeman Standby allowance","T05","Hours ",35,1,{"v":94,"d":"94.00"},36,{"v":118440,"d":"R 118,440.00"}]
["B1.14","Storeman Overtime @1,5","T05","Hours ",30,1,{"$f":"SUM(G35*1.5)","v":{"v":129.97500000000002,"d":"129.98"}},36,{"v":140373.00000000003,"d":"R 140,373.00"}]
["B1.15","Storeman Overtime @2.0","T05","Hours ",20,1,{"$f":"SUM(G35*2)","v":{"v":173.3,"d":"173.30"}},36,{"v":124776,"d":"R 124,776.00"}]
["B1.16","Safety officer Day","T12","Hours ",173,1,{"$f":"[2]RATES!C11","v":224.13},36,{"v":1395881.64,"d":"R 1,395,881.64"}]
["B1.17","Safety officer Standby allowance","T12","Hours ",35,1,{"v":94,"d":"94.00"},36,{"v":118440,"d":"R 118,440.00"}]
["B1.18","Safety officer Overtime @ 1,5","T12","Hours ",20,1,{"$f":"SUM(G39*1.5)","v":{"v":336.195,"d":"336.20"}},36,{"v":242060.4,"d":"R 242,060.40"}]
["B1.19","Safety officer Overtime @ 2.0","T12","Hours ",20,1,{"$f":"SUM(G39*2)","v":448.26},36,{"v":322747.2,"d":"R 322,747.20"}]
["B1.20","Fitter Artisan","T09","Hours ",173,15,{"$f":"[2]RATES!C9","v":180.35},36,{"v":16848297,"d":"R 16,848,297.00"}]
["B1.21","Fitter Artisan Standby allowance","T09","Hours ",35,15,{"v":94,"d":"94.00"},36,{"v":1776600,"d":"R 1,776,600.00"}]
["B1.22","Fitter Artisan overtime @ 1,5","T09","Hours ",90,15,{"$f":"SUM(G43*1.5)","v":{"v":270.525,"d":"270.53"}},36,{"v":13147514.999999998,"d":"R 13,147,515.00"}]
["B1.23","Fitter Artisan overtime @ 2.0","T09","Hours ",40,15,{"$f":"SUM(G43*2)","v":{"v":360.7,"d":"360.70"}},36,{"v":7791120,"d":"R 7,791,120.00"}]
["B1.24","Rigger","T09","Hours ",173,2,{"$f":"[2]RATES!C9","v":180.35},36,{"v":2246439.6,"d":"R 2,246,439.60"}]
["B1.25","Rigger standby allowance ","T09","Hours ",35,2,{"v":94,"d":"94.00"},36,{"v":236880,"d":"R 236,880.00"}]
["B1.26","Rigger overtime @ 1,5","T09","Hours ",60,2,{"$f":"SUM(G47*1.5)","v":{"v":270.525,"d":"270.53"}},36,{"v":1168667.9999999998,"d":"R 1,168,668.00"}]
["B1.27","Rigger overtime @ 2.0","T09","Hours ",20,2,{"$f":"SUM(G47*2)","v":{"v":360.7,"d":"360.70"}},36,{"v":519408,"d":"R 519,408.00"}]
["B1.28","Boilermaker ","T09","Hours ",173,2,{"$f":"[2]RATES!C11","v":224.13},36,{"v":2791763.28,"d":"R 2,791,763.28"}]
["B1.29","Boilermaker standby allowance ","T09","Hours ",35,2,{"v":94,"d":"94.00"},36,{"v":236880,"d":"R 236,880.00"}]
["B1.30","Boilermaker overtime @ 1,5","T09","Hours ",40,2,{"$f":"SUM(G51*1.5)","v":{"v":336.195,"d":"336.20"}},36,{"v":968241.6,"d":"R 968,241.60"}]
["B1.31","Boilermaker overtime @ 2.0","T09","Hours ",20,2,{"$f":"SUM(G51*2)","v":448.26},36,{"v":645494.4,"d":"R 645,494.40"}]
["B1.32","Welder","T09","Hours ",173,2,{"$f":"[2]RATES!C9","v":180.35},36,{"v":2246439.6,"d":"R 2,246,439.60"}]
["B1.33","Welder standby allowance ","T09","Hours ",35,2,{"v":94,"d":"94.00"},36,{"v":236880,"d":"R 236,880.00"}]
["B1.34","Welder overtime @ 1,5","T09","Hours ",30,2,{"$f":"SUM(G55*1.5)","v":{"v":270.525,"d":"270.53"}},36,{"v":584333.9999999999,"d":"R 584,334.00"}]
["B1.35","Welder overtime @ 2,0","T09","Hours ",20,2,{"$f":"SUM(G55*2)","v":{"v":360.7,"d":"360.70"}},36,{"v":519408,"d":"R 519,408.00"}]
["B1.36","Utility man ","T04","Hours ",173,21,{"$f":"[2]RATES!C4","v":80.75},36,{"v":10561131,"d":"R 10,561,131.00"}]
["B1.37","Utility man Standby allowance  ","T04","Hours ",35,21,{"v":94,"d":"94.00"},36,{"v":2487240,"d":"R 2,487,240.00"}]
["B1.38","Utility man Shifts Overtime@1,5","T04","Hours ",45,21,{"$f":"SUM(G59*1.5)","v":{"v":121.125,"d":"121.13"}},36,{"v":4120672.5,"d":"R 4,120,672.50"}]
["B1.39","Utility man Shifts Overtime@2.0","T04","Hours ",45,21,{"$f":"SUM(G59*2)","v":{"v":161.5,"d":"161.50"}},36,{"v":5494230,"d":"R 5,494,230.00"}]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I25:I62)","v":{"v":95991085.97999999,"d":"R 95,991,085.98"}}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I63,I20)","v":{"v":102366685.97999999,"d":"R 102,366,685.98"}}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor 2. Contractor to supply their own furniture and storage lockers"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note3 Training will be listed as part of SOW"]

{"sheet":"Majuba","index":6,"n_rows":62,"n_cols":13,"rows_kept":62,"merged":[[17,3,17,7],[53,3,53,7],[54,3,54,7]]}
[]
[null,"MAJUBA POWER STATION - "]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","Total 24 months "]
["A1.1","Site Establishment",null,"Sum",1,1,null,1,{"$f":"E5*F5*G5*H5","v":0}]
["A1.2","Transport ( 14 Seater)",null,"Month ",1,2,null,24,0]
["A1.3","Double cab Bakkie",null,"Month ",1,2,null,24,0]
["A1.4","Annual Medical + Exit Medical",null,"Annual",1,46,null,3,0]
["A1.5","PPE",null,"Annual",1,46,null,2,0]
["A1.6","Winter Jackets",null,"2 Yearly ",1,46,null,2,0,{"$nulls":3},"We need to as at times these employees work in the cold especially in winter "]
["A1.7","Rain Coats ",null,"Annual",1,46,null,2,0]
["A1.8","Standby Allowance",null,"Days",14,46,null,24,0]
["A1.9","Cellphone Allowances",null,"Month ",1,2,null,24,0,{"$nulls":3},"Supervisors, SHE Officer SM"]
["A1.10","Other allowances ( RP)",null,"Month ",1,39,null,24,0]
["A1.11","Site De-establishment (once-off)",null,"Sum",1,1,null,2,0]
[]
[]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I16)","v":0}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  24 MONTHS"]
["B1.1","Site Manager","M14","Hours",176,0,null,24,{"$f":"E22*F22*G22*H22","v":0}]
["B1.2","Senior Supervisor Technical ","T13","Hours ",176,3,null,24,0]
["B1.3","Senior Supervisor Overtime @1,5","T13","Hours ",40,3,null,24,0]
["B1.4","Senior Supervisor Overtime @2,0","T13","Hours ",24,3,null,24,0]
["B1.5","Electrical Technician","T12","Hours",176,3,null,24,0]
["B1.6","Electrical TechnicianOvertime @1,5","T12","Hours",40,3,null,24,0]
["B1.7","Electrical Technician Overtime @2,0","T12","Hours",24,3,null,24,0]
["B1.8","Safety officer Day","T12","Hours ",176,1,null,24,0]
["B1.9","Safety officer Overtime @ 1,5","T12","Hours ",40,1,null,24,0]
["B1.10","Safety officer Overtime @ 2.0","T12","Hours ",24,1,null,24,0]
["B1.11","Planner","T10","Hours ",176,1,null,24,0]
["B1.12","Planner overtime @ 1,5","T10","Hours ",40,1,null,24,0]
["B1.13","Planner overtime @ 2.0","T10","Hours ",24,1,null,24,0]
["B1.14","Electrical Artisans","T09","Hours ",176,11,null,24,0]
["B1.15","Electrical Artisans overtime @ 1,5","T09","Hours ",40,11,null,24,0]
["B1.16","Electrical Artisans overtime @ 2.0","T09","Hours ",24,11,null,24,0]
["B1.17","Electrian","T09","Hours ",176,1,null,24,0]
["B1.18","Electrian overtime @ 1,5","T09","Hours ",40,1,null,24,0]
["B1.19","Electrian overtime @ 2,0","T09","Hours ",24,1,null,24,0]
["B1.20","Storeman ","T05","Hours ",176,1,null,24,0]
["B1.21","Storeman Overtime @1,5","T05","Hours ",40,1,null,24,0]
["B1.22","Storeman Overtime @2","T05","Hours ",24,1,null,24,0]
["B1.23","Administrator Day ","T05","Hours ",176,1,null,24,0]
["B1.24","Driver","T05","Hours ",176,2,null,24,0]
["B1.25","Driver @1.5","T05","Hours ",40,2,null,24,0]
["B1.26","Driver @2","T05","Hours ",24,2,null,24,0]
["B1.27","General worker office/ Yard cleaner","T02","Hours ",176,2,null,24,0]
["B1.28","General worker office/ Yard cleaner @1.5","T02","Hours ",40,2,null,24,0]
["B1.29","General worker office/ Yard cleaner @2","T02","Hours ",24,2,null,24,0]
["B1.24","Utility man ","T04","Hours ",176,12,null,24,0]
["B1.25","Utility man  Overtime@1,5","T04","Hours ",40,12,null,24,0]
["B1.26","Utility man  Overtime@2.0","T04","Hours ",24,12,null,24,0]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I22:I53)","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I54,I18)","v":0}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor 2.   A list of minimum tools the artisans require is attached"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note3 "," Any training required by the Employer will be provided e.g. Ethics, HIRA, etc however, any other training additional that the Contractor will need, the training costs will be for the Contractor. Training may not be conducted during working hours, unless permission is given by the Employer."]
[]
[null,"RP allowance must be paid in line with what ERI is paying .  The rate is as provided and will be escalated based on how ERI escalates theirs. "]

{"sheet":"Tutuka","index":7,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[17,3,17,7],[55,3,55,7],[56,3,56,7]]}
[]
[null,"TUTUKA POWER STATION "]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","Total 24 months "]
["A1.1","Site Establishment",null,"Sum",1,1,null,1,{"$f":"E5*F5*G5*H5","v":0}]
["A1.2","Transport ( 14 Seater)",null,"Month ",1,1,null,24,0]
["A1.3","Double cab Bakkie",null,"Month ",1,3,null,24,0]
["A1.4","Annual Medical + Exit Medical",null,"Annual",1,1,null,3,0]
["A1.5","PPE",null,"Annual",1,34,null,2,0]
["A1.6","Winter Jackets",null,"2 Yearly ",1,34,null,2,0,{"$nulls":3},"We need to as at times these employees work in the cold especially in winter "]
["A1.7","Rain Coats ",null,"Annual",1,34,null,2,0]
["A1.8","Standby Allowance",null,"Days",14,33,null,24,0]
["A1.9","Cellphone Allowances",null,"Month ",1,5,null,24,0,{"$nulls":3},"Supervisors, SHE Officer SM"]
["A1.10","Other allowances ( RP)",null,"Month ",1,18,null,24,0]
["A1.11","Site De-establishment (once-off)",null,"Sum",1,1,null,1,0]
[]
[]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I16)","v":0}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  24 MONTHS"]
["B1.1","Senior Supervisor Technical ","T13","Hours",173,4,null,24,{"$f":"E22*F22*G22*H22","v":0}]
["B1.2","Senior Supervisor Overtime @1,5","T13","Hours ",173,4,null,24,0]
["B1.3","Senior Supervisor Overtime @2,0","T13","Hours ",40,4,null,24,0]
["B1.4","Electrical Technician","T12","Hours ",24,3,null,24,0]
["B1.5","Electrical TechnicianOvertime @1,5","T12","Hours",173,3,null,24,0]
["B1.6","Electrical Technician Overtime @2,0","T12","Hours",40,3,null,24,0]
["B1.7","Safety officer Day","T12","Hours",24,3,null,24,0]
["B1.8","Safety officer Overtime @ 1,5","T12","Hours ",173,3,null,24,0]
["B1.9","Safety officer Overtime @ 2.0","T12","Hours ",40,3,null,24,0]
["B1.10","Planner","T10","Hours ",24,2,null,24,0]
["B1.11","Planner overtime @ 1,5","T10","Hours ",173,2,null,24,0]
["B1.12","Planner overtime @ 2.0","T10","Hours ",40,2,null,24,0]
["B1.13","Electrical Artisans","T09","Hours ",24,4,null,24,0]
["B1.14","Electrical Artisans overtime @ 1,5","T09","Hours ",173,4,null,24,0]
["B1.15","Electrical Artisans overtime @ 2.0","T09","Hours ",40,4,null,24,0]
["B1.16","Storeman ","T05","Hours ",24,1,null,24,0]
["B1.17","Storeman Overtime @1,5","T05","Hours ",173,1,null,24,0]
["B1.18","Storeman Overtime @2","T05","Hours ",40,1,null,24,0]
["B1.19","Administrator Day ","T05","Hours ",24,1,null,24,0]
["B1.20","Utility man ","T04","Hours ",173,26,null,24,0]
["B1.21","Utility man  Overtime@1,5","T04","Hours ",40,26,null,24,0]
["B1.22","Utility man  Overtime@2.0","T04","Hours ",24,26,null,24,0]
["B1.23","Fitter","T09","Hours ",173,12,null,24,0]
["B1.24","Fitter  Overtime@1,5","T09","Hours ",40,12,null,24,0]
["B1.25","Fitter  Overtime@2.0","T09","Hours ",24,12,null,24,0]
["B1.26","Rigger","T09","Hours ",173,1,null,24,0]
["B1.27","Rigger  Overtime@1,5","T09","Hours ",40,1,null,24,0]
["B1.28","Rigger  Overtime@2.0","T09","Hours ",24,1,null,24,0]
["B1.26","Welder","T09","Hours ",173,4,null,24,0]
["B1.27","Welder  Overtime@1,5","T09","Hours ",40,4,null,24,0]
["B1.28","Welder Overtime@2.0","T09","Hours ",24,4,null,24,0]
["B1.29","Mechanician","T09","Hours ",173,6,null,24,0]
["B1.30","Mechanician Overtime@1,5","T09","Hours ",40,6,null,24,0]
["B1.31","Mechanician Overtime@2,0","T09","Hours ",24,6,null,24,0]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I22:I50)","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I56,I18)","v":0}]
[]
[]
["Note 1","Mechanician Overtime@2.0","T05"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note3 "," Any training required by the Employer will be provided e.g. Ethics, HIRA, etc however, any other training additional that the Contractor will need, the training costs will be for the Contractor. Training may not be conducted during working hours, unless permission is given by the Employer."]
[]
[null,"RP allowance must be paid in line with what ERI is paying .  The rate is as provided and will be escalated based on how ERI escalates theirs. "]

{"sheet":"BWH","index":8,"n_rows":51,"n_cols":9,"rows_kept":51,"merged":[[16,3,16,7],[42,3,42,7],[43,3,43,7]]}
[]
[null,"BULK WATER HANDLING"]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","TOTAL 24 MONTHS"]
["A1.1","Site Establishment",null,"Sum",1,1,null,1,{"$f":"E5*F5*G5*H5","v":0}]
["A1.2","Transport ( 14 Seater)",null,"Month ",1,2,null,24,{"$f":"E6*F6*G6*H6","v":0}]
["A1.3","Double cab Bakkie",null,"Month ",1,2,null,24,0]
["A1.4","Safety Training",null,"Annual",1,27,null,2,0]
["A1.5","Annual Medical + Exit Medical",null,"Annual",1,{"$f":"F21+F24+F27+F30+F33+F36+F37+F40","v":28},null,3,0]
["A1.6","PPE",null,"Annual",1,28,null,2,0]
["A1.7","Winter Jackets",null,"2 Yearly ",1,28,null,2,0]
["A1.8","Rain Coats ",null,"Annual",1,28,null,2,0]
["A1.9","Standby Allowance",null,"Days",14,{"$f":"F21+F27+F24+F30+F33+F37+F39","v":27},null,24,0]
["A1.10","Cellphone Allowances",null,"Monthly",1,3,null,24,0]
["A1.11","Other allowances ( RP)",null,"Month ",1,{"$f":"F27+F30+F21","v":6},null,24,0]
["A1.12","Site De-establishment (once-off)",null,"Sum",1,1,null,1,0]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I16)","v":0}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  24 MONTHS"]
["B1.1","Senior Supervisor Technical","T13","Hours ",173,2,null,24,{"$f":"E21*F21*G21*H21","v":0}]
["B1.2","Senior Supervisor Overtime @1.5","T13","Hours ",20,2,null,24,0]
["B1.3","Senior Supervisor Overtime @2,0","T13","Hours ",20,2,null,24,0]
["B1.4","Safety officer","T12","Hours ",173,1,null,24,0]
["B1.5","Safety officer Overtime @ 1,5","T12","Hours ",20,1,null,24,0]
["B1.6","Safety officer Overtime @ 2.0","T12","Hours ",20,1,null,24,0]
["B1.7","Electrician Artisan","T09","Hours ",173,2,null,24,0]
["B1.8","Electrician Artisan  overtime @ 1.5","T09","Hours ",20,2,null,24,0]
["B1.9","Electrician Artisan  overtime @ 2.0","T09","Hours ",20,2,null,24,0]
["B1.10","Fitter Artisan","T09","Hours ",173,2,null,24,0]
["B1.11","Fitter Artisan  overtime @ 1.5","T09","Hours ",20,2,null,24,0]
["B1.12","Fitter Artisan  overtime @ 2.0","T09","Hours ",20,2,null,24,0]
["B1.13","Team Leader","T07","Hours ",173,2,null,24,0]
["B1.14","Team Leader Overtime @ 1.5","T07","Hours ",20,2,null,24,0]
["B1.15","Team Leader Overtime @ 2.0","T07","Hours ",20,2,null,24,0]
["B1.16","Administrator","T07","Hours ",173,1,null,24,0]
["B1.17","Utility man","T04","Hours ",173,9,null,24,0]
["B1.18","Utility man Overtime@1.5","T04","Hours ",20,9,null,24,0]
["B1.19","Utility man Overtime@2.0","T04","Hours ",20,9,null,24,0]
["B1.20","General Worker","T02","Hours ",173,9,null,24,0]
["B1.21","General Worker Overtime@1.5","T02","Hours ",20,9,null,24,0]
["B1.22","General Worker Overtime@2.0","T02","Hours ",20,9,null,24,0]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I21:I42)","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I43,I17)","v":0}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor 2. Contractor to supply their own furniture and storage lockers.  A list of minimum tools the artisans require is attached"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
["Note3 Training will be listed as part of SOW"]
[]
[null,"RP allowance must be paid in line with what ERI is paying .  The rate is as provided and will be escalated based on how ERI escaates theirs. "]

{"sheet":"Lethabo","index":9,"n_rows":48,"n_cols":9,"rows_kept":48,"merged":[[17,3,17,7],[38,3,38,7],[39,3,39,7]]}
[]
[null,"LETHABO POWER STATION"]
[]
["A1","P&Gs",null,"Unit of measure","Quantity","Number","Rate","Period","TOTAL 24 MONTHS"]
["A1.1","Site Establishment",null,"Sum",1,1,null,1,{"$f":"E5*F5*G5*H5","v":0}]
["A1.2","Transport ( 22 Seater) ( including Driver) ",null,"Month ",1,3,null,24,{"$f":"E6*F6*G6*H6","v":0}]
["A1.3","Double cab Bakkie",null,"Month ",1,2,null,24,0]
["A1.4","Single cab Bakkie",null,"Month ",1,2,null,24,0]
["A1.5","Sedan ",null,"Month ",1,1,null,24,0]
["A1.6","Annual Medical + Exit Medical",null,"Annual",1,24,null,3,0]
["A1.7","PPE",null,"Annual",1,24,null,2,0]
["A1.8","Winter Jackets",null,"2 Yearly ",1,24,null,2,0]
["A1.9","Rain Coats ",null,"Annual",1,24,null,1,0]
["A1.10","Cellphone Allowances",null,"Month ",1,3,null,24,0]
["A1.11","Standby Allowance",null,"Daily",1,17,null,24,0]
["A1.12","Other allowances ( RP)",null,"Month ",1,17,null,24,0]
["A1.13","Site De-establishment (once-off)",null,"Sum",1,1,null,1,0]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I5:I17)","v":0}]
[]
[]
["B1","SKILL TYPE","GRADE","Unit of measure","Quantity","Number of people","Rate","Period","TOTAL  24 MONTHS"]
["B1.1","Snr Mech/Elec Supervisor","T13","Hours ",173,1,null,24,{"$f":"E22*F22*G22*H22","v":0}]
["B1.2","Snr Supervisor overtime @ 1,5","T13","Hours ",40,1,null,24,0]
["B1.3","Snr Supervisor overtime @ 2.0","T13","Hours ",24,1,null,24,0]
["B1.4","Artisans","T09","Hours ",183,17,null,24,0]
["B1.5","Artisans Shift Allowance @ 15%","T09","Hours ",183,17,null,24,0]
["B1.6","Artisans overtime @1,5","T09","Hours ",24,17,null,24,0]
["B1.7","Artisans overtime @2,0","T09","Hours ",36,17,null,24,0]
["B1.8","Storeman ","T05","Hours ",173,1,null,24,0]
["B1.9","Storeman overtime @1.5","T05","Hours ",40,1,null,24,0]
["B1.10","Storeman overtime @2","T05","Hours ",24,1,null,24,0]
["B1.11","Bus Drivers","T05","Hours ",183,2,null,24,0]
["B1.12","Bus Drivers Shift Allowance @ 15%","T05","Hours ",183,2,null,24,0]
["B1.13","Bus Drivers Overtime @ 2.0","T05","Hours ",36,2,null,24,0]
["B1.14","Utility Man ","T04","Hours ",183,16,null,24,0]
["B1.15","Utility Man Shift Allowance @ 15%","T04","Hours ",183,16,null,24,0]
["B1.16","Utility Man overtime @1,5","T04","Hours ",24,16,null,24,0]
["B1.17","Utility Man overtime @2","T04","Hours ",36,16,null,24,0]
[{"$nulls":3},"SUB-TOTAL SKILL TYPE",null,"SUB-TOTAL",null,null,{"$f":"SUM(I22:I38)","v":0}]
[{"$nulls":3},"SUB-TOTAL EXCLUDING VAT",{"$nulls":4},{"$f":"SUM(I39,I18)","v":0}]
[]
[]
["Note 1","1. All tools required to execute the scope will be supplied by the Contractor.  A list of minimum tools the artisans require is attached"]
["Note 2 ","All facilities will be supplied by the Employer 1. Water and Electricity\n2. Lighting and Ventilation\n3. Office space"]
[]
[null,"RP allowance must be paid in line with what ERI is paying .  The rate is as provided and will be escalated based on how ERI escaates theirs. "]
[]
[null," Any training required by the Employer will be provided e.g. Ethics, HIRA, etc however, any other training additional that the Contractor will need, the training costs will be for the Contractor. Training may not be conducted during working hours, unless permission is given by the Employer."]

{"sheet":"Sheet2","index":10,"n_rows":11,"n_cols":6,"rows_kept":11,"hidden":true,"merged":[[8,0,8,1]]}
[]
["Site ","Cost Centre","Amount","2023-24","2024-25","2025-26"]
["Duvha",105113,{"v":99160645.08,"d":"R99,160,645.08"},{"v":16526774.18,"d":"R16,526,774.18"},{"v":41316935.45,"d":"R41,316,935.45"},{"v":41316935.45,"d":"R41,316,935.45"}]
["Medupi",105122,{"$f":"SUMMARY!C9","v":{"v":0,"d":"R0.00"}},{"v":33883567.93746666,"d":"R33,883,567.94"},{"v":84708919.84366666,"d":"R84,708,919.84"},{"v":84708919.84366666,"d":"R84,708,919.84"}]
["Grootvlei",105136,{"v":71480566.38,"d":"R71,480,566.38"},{"v":11913427.729999999,"d":"R11,913,427.73"},{"v":29783569.325,"d":"R29,783,569.33"},{"v":29783569.325,"d":"R29,783,569.33"}]
["Kusile",105139,{"v":156274326.38,"d":"R156,274,326.38"},{"v":26045721.063333333,"d":"R26,045,721.06"},{"v":65114302.65833333,"d":"R65,114,302.66"},{"v":65114302.65833333,"d":"R65,114,302.66"}]
["BWH",105141,{"v":39579036.68,"d":"R39,579,036.68"},{"v":6596506.113333333,"d":"R6,596,506.11"},{"v":16491265.283333333,"d":"R16,491,265.28"},{"v":16491265.283333333,"d":"R16,491,265.28"}]
["Total ",null,{"$f":"SUM(C3:C7)","v":{"v":366494574.52,"d":"R366,494,574.52"}},{"$f":"SUM(D3:D7)","v":{"v":94965997.02413331,"d":"R94,965,997.02"}},{"v":237414992.5603333,"d":"R237,414,992.56"},{"v":237414992.5603333,"d":"R237,414,992.56"}]
["Contingency @ 15%",null,{"$f":"C8*0.15","v":{"v":54974186.177999996,"d":"R54,974,186.18"}},{"v":14244899.553619998,"d":"R14,244,899.55"},{"v":35612248.88405,"d":"R35,612,248.88"},{"v":35612248.88405,"d":"R35,612,248.88"}]
["Estimated CPA",null,{"$f":"SUMMARY!C14","v":0},{"v":3429268.285869475,"d":"R3,429,268.29"},{"v":8573170.714673687,"d":"R8,573,170.71"},{"v":8573170.714673687,"d":"R8,573,170.71"}]
["Total ",null,{"$f":"C8+C9","v":{"v":421468760.69799995,"d":"R421,468,760.70"}},{"$f":"D8+D9","v":{"v":109210896.5777533,"d":"R109,210,896.58"}},{"v":273027241.4443833,"d":"R273,027,241.44"},{"v":273027241.4443833,"d":"R273,027,241.44"}]