{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["EXCEL WITH FORMULAS","PDF FOR HAND WRITTEN"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"EXCEL WITH FORMULAS","index":0,"n_rows":73,"n_cols":11,"rows_kept":73,"merged":[[1,2,1,10],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[8,3,8,6],[9,3,9,6],[10,3,10,6],[11,2,11,9],[38,2,38,9],[39,2,39,10],[65,2,65,9],[66,2,66,10],[68,3,68,6],[69,3,69,6],[70,2,70,9],[72,2,72,9]]}
[{"$nulls":4},"PRICE SCHEDULE"]
[null,null,"PROJECT NAME Provision of cleaning sevices on the Dust and Ash Plant at Matla Power station"]
[]
[]
[null,null,"Item","Description",{"$nulls":3},"Unit","Quantity","Rate","Amount"]
[{"$nulls":3},"SECTION 1 - PRELIMINARIES & GENERAL"]
[null,null,1,"Site Establishment",{"$nulls":3},"Sum",1,null,{"$f":"I7*J7","v":0}]
[null,null,2,"Site De-establishment",{"$nulls":3},"Sum",1,null,{"$f":"I8*J8","v":0}]
[null,null,3,"Transport",{"$nulls":3},"Monthly",60,null,{"$f":"I9*J9","v":0}]
[null,null,4,"SHEQ File",{"$nulls":3},"Sum",1,null,{"$f":"I10*J10","v":0}]
[null,null,6,"Meeting all SHEQ requirements(PPE, Medicals, Police Clearance etc.)",{"$nulls":3},"Sum",1,null,{"$f":"I11*J11","v":0}]
[null,null,"Total Preliminaries and General",{"$nulls":7},{"$f":"SUM(K7:K11)","v":0}]
[]
[null,null,"Item","Description","Unit","No of Employees","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[{"$nulls":3},"SECTION 2 - LABOUR"]
[{"$nulls":3},"NORMAL TIME DAY SHIT"]
[null,null,1,"General Workers","Hrs",{"v":48,"d":"48.00"},{"$f":"5*12","v":60},{"$f":"8*22","v":176},{"$f":"F17*G17*H17","v":506880},null,{"$f":"I17*J17","v":0}]
[null,null,2,"Opperators","Hrs",{"v":12,"d":"12.00"},60,{"$f":"8*22","v":176},{"$f":"F18*G18*H18","v":126720},null,{"$f":"I18*J18","v":0}]
[null,null,3,"Supervisor","Hrs",{"v":4,"d":"4.00"},60,{"$f":"8*22","v":176},42240,null,0]
[null,null,4,"Site Manager","Hrs",{"v":1,"d":"1.00"},60,176,10560,null,0]
[null,null,5,"Safety Officer","Hrs",{"v":1,"d":"1.00"},60,176,10560,null,0]
[{"$nulls":3},"Sub-Total (Normal Time Day Shift)",{"$nulls":6},{"$f":"SUM(K17:K21)","v":0}]
[]
[null,null,"Item","Description","Unit","No of Employees","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[{"$nulls":3},"NORMAL OVERTIME AND SATURDAYS"]
[null,null,1,"General Workers","Hrs",{"v":48,"d":"48.00"},60,60,{"$f":"F26*G26*H26","v":172800},null,{"$f":"I26*J26","v":0}]
[null,null,2,"Opperators","Hrs",{"v":12,"d":"12.00"},60,60,{"$f":"F27*G27*H27","v":43200},null,{"$f":"I27*J27","v":0}]
[null,null,3,"Supervisor","Hrs",{"v":4,"d":"4.00"},60,30,7200,null,{"$f":"I28*J28","v":0}]
[null,null,4,"Safety Officer","Hrs",{"v":1,"d":"1.00"},60,30,1800,null,{"$f":"I29*J29","v":0}]
[{"$nulls":3},"Sub-Total (Normal Overtime and Saturdays)",{"$nulls":6},{"$f":"SUM(K26:K29)","v":0}]
[]
[null,null,"Item","Description","Unit","No of Employees","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[{"$nulls":3},"OVERTIME SUNDAY/ HOLIDAYS"]
[null,null,1,"General Workers","Hrs",48,60,40,{"$f":"F34*G34*H34","v":115200},null,{"$f":"F34*G34*H34*J34","v":0}]
[null,null,2,"Opperators","Hrs",12,60,40,{"$f":"F35*G35*H35","v":28800},null,{"$f":"F35*G35*H35*J35","v":0}]
[null,null,3,"Supervisor","Hrs",4,60,40,9600,null,0]
[null,null,4,"Safety Officer","Hrs",1,60,40,2400,null,0]
[{"$nulls":3},"Sub-Total (Overtime Sunday/Holidays)",{"$nulls":6},{"$f":"SUM(K34:K37)","v":0}]
[null,null,"Total Labour (Normal Time Day Shift, Normal Overtime and Saturday)",{"$nulls":7},{"$f":"K38+K30+K22","v":0}]
[]
[null,null,"Item","Description","Unit","No of Plant","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[{"$nulls":3},"SECTION 3 - PLANT"]
[{"$nulls":3},"NORMAL TIME DAY SHIFT "]
[null,null,1,"10 m3 Tipper Truck","month",6,60,{"$f":"22*8","v":176},{"$f":"F44*G44*H44","v":63360},null,{"$f":"I44*J44","v":0}]
[null,null,2,"TLB","month",2,60,{"$f":"22*8","v":176},{"$f":"F45*G45*H45","v":21120},null,{"$f":"I45*J45","v":0}]
[null,null,3,"Bobcat","month",2,60,176,21120,null,0]
[null,null,4,"Vacum Truck","month",2,60,176,21120,null,0]
[{"$nulls":3},"Sub-Total (Normal Time Day Shift ) ",{"$nulls":6},{"$f":"SUM(K44:K47)","v":0}]
[]
[null,null,"Item","Description","Unit","No of Plant","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[{"$nulls":3},"NORMAL OVERTIME AND SATURDAYS"]
[null,null,1,"10 m3 Tipper Truck","month",6,60,60,{"$f":"F52*G52*H52","v":21600},null,{"$f":"I52*J52","v":0}]
[null,null,2,"TLB","month",2,60,60,{"$f":"F53*G53*H53","v":7200},null,{"$f":"I53*J53","v":0}]
[null,null,3,"Bobcat","month",2,60,60,7200,null,{"$f":"I54*J54","v":0}]
[null,null,4,"Vacum Truck","month",2,60,60,7200,null,{"$f":"I55*J55","v":0}]
[{"$nulls":3},"Sub-Total (Normal Overtme and satureday ) ",{"$nulls":6},{"$f":"SUM(K52:K55)","v":0}]
[]
[null,null,"Item","Description","Unit","No of Plant","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[{"$nulls":3},"OVERTIME SUNDAYS AND HOLIDAYS"]
[null,null,1,"10 m3 Tipper Truck","month",6,60,40,{"$f":"F60*G60*H60","v":14400},null,{"$f":"I60*J60","v":0}]
[null,null,2,"TLB","month",2,60,40,{"$f":"F61*G61*H61","v":4800},null,{"$f":"I61*J61","v":0}]
[null,null,3,"Bobcat","month",2,60,40,4800,null,{"$f":"I62*J62","v":0}]
[null,null,4,"Vacum Truck","month",2,60,40,4800,null,{"$f":"I63*J63","v":0}]
[{"$nulls":3},"Sub-Total (Overtme Sundays and Holidays) ",{"$nulls":6},{"$f":"SUM(K60:K63)","v":0}]
[]
[null,null,"Total (Plant)",{"$nulls":7},{"$f":"K48+K56+K64","v":0}]
[]
[null,null,"Item","Description",{"$nulls":3},"Unit","Quantity","Rate ","Amount"]
[{"$nulls":3},"SECTION 4 - TOOLS AND EQUIPMENT"]
[null,null,1,"Cleaning Equipment",{"$nulls":3},"Sum",5,null,{"$f":"I70*J70","v":0}]
[null,null,"Total (Tools and Equipment)",{"$nulls":7},{"$f":"K70","v":0}]
[]
[null,null,"TOTAL EXCLUDING VAT",{"$nulls":7},{"$f":"K71+K66+K39+K12","v":0}]

{"sheet":"PDF FOR HAND WRITTEN","index":1,"n_rows":75,"n_cols":10,"rows_kept":75,"merged":[[0,1,0,9],[1,1,1,9],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,1,13,8],[40,1,40,8],[41,1,41,9],[67,1,67,8],[68,1,68,9],[70,2,70,5],[71,2,71,5],[72,1,72,8],[74,1,74,8]]}
[null,"PRICE SCHEDULE"]
[null,"PROJECT NAME Provision of cleaning sevices on the Dust and Ash Plant at Matla Power station"]
[]
[]
[]
[]
[null,"Item","Description",{"$nulls":3},"Unit","Quantity","Rate","Amount"]
[null,null,"SECTION 1 - PRELIMINARIES & GENERAL"]
[null,1,"Site Establishment",{"$nulls":3},"Sum",1]
[null,2,"Site De-establishment",{"$nulls":3},"Sum",1]
[null,3,"Transport",{"$nulls":3},"Monthly",60]
[null,4,"SHEQ File",{"$nulls":3},"Sum",1]
[null,6,"Meeting all SHEQ requirements(PPE, Medicals, Police Clearance etc.)",{"$nulls":3},"Sum",1]
[null,"Total Preliminaries and General"]
[]
[null,"Item","Description","Unit","No of Employees","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[null,null,"SECTION 2 - LABOUR"]
[null,null,"NORMAL TIME DAY SHIT"]
[null,1,"General Workers","Hrs",{"v":48,"d":"48.00"},{"$f":"5*12","v":60},{"$f":"8*22","v":176},{"$f":"E19*F19*G19","v":506880}]
[null,2,"Opperators","Hrs",{"v":12,"d":"12.00"},60,{"$f":"8*22","v":176},{"$f":"E20*F20*G20","v":126720}]
[null,3,"Supervisor","Hrs",{"v":4,"d":"4.00"},60,{"$f":"8*22","v":176},42240]
[null,4,"Site Manager","Hrs",{"v":1,"d":"1.00"},60,176,10560]
[null,5,"Safety Officer","Hrs",{"v":1,"d":"1.00"},60,176,10560]
[null,null,"Sub-Total (Normal Time Day Shift)"]
[]
[null,"Item","Description","Unit","No of Employees","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[null,null,"NORMAL OVERTIME AND SATURDAYS"]
[null,1,"General Workers","Hrs",{"v":48,"d":"48.00"},60,60,{"$f":"E28*F28*G28","v":172800}]
[null,2,"Opperators","Hrs",{"v":12,"d":"12.00"},60,60,{"$f":"E29*F29*G29","v":43200}]
[null,3,"Supervisor","Hrs",{"v":4,"d":"4.00"},60,30,7200]
[null,4,"Safety Officer","Hrs",{"v":1,"d":"1.00"},60,30,1800]
[null,null,"Sub-Total (Normal Overtime and Saturdays)"]
[]
[null,"Item","Description","Unit","No of Employees","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[null,null,"OVERTIME SUNDAY/ HOLIDAYS"]
[null,1,"General Workers","Hrs",48,60,40,{"$f":"E36*F36*G36","v":115200}]
[null,2,"Opperators","Hrs",12,60,40,{"$f":"E37*F37*G37","v":28800}]
[null,3,"Supervisor","Hrs",4,60,40,9600]
[null,4,"Safety Officer","Hrs",1,60,40,2400]
[null,null,"Sub-Total (Overtime Sunday/Holidays)"]
[null,"Total Labour (Normal Time Day Shift, Normal Overtime and Saturday)",{"$nulls":7},{"$f":"J40+J32+J24","v":0}]
[]
[null,"Item","Description","Unit","No of Plant","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[null,null,"SECTION 3 - PLANT"]
[null,null,"NORMAL TIME DAY SHIFT "]
[null,1,"10 m3 Tipper Truck","month",6,60,{"$f":"22*8","v":176},{"$f":"E46*F46*G46","v":63360}]
[null,2,"TLB","month",2,60,{"$f":"22*8","v":176},{"$f":"E47*F47*G47","v":21120}]
[null,3,"Bobcat","month",2,60,176,21120]
[null,4,"Vacum Truck","month",2,60,176,21120]
[null,null,"Sub-Total (Normal Time Day Shift ) "]
[]
[null,"Item","Description","Unit","No of Plant","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[null,null,"NORMAL OVERTIME AND SATURDAYS"]
[null,1,"10 m3 Tipper Truck","month",6,60,60,{"$f":"E54*F54*G54","v":21600}]
[null,2,"TLB","month",2,60,60,{"$f":"E55*F55*G55","v":7200}]
[null,3,"Bobcat","month",2,60,60,7200]
[null,4,"Vacum Truck","month",2,60,60,7200]
[null,null,"Sub-Total (Normal Overtme and satureday ) "]
[]
[null,"Item","Description","Unit","No of Plant","Months","Hours in a month","(A)                       Total Hours","(B)               Rate per hour","(C= A X B)                                         Totals"]
[null,null,"OVERTIME SUNDAYS AND HOLIDAYS"]
[null,1,"10 m3 Tipper Truck","month",6,60,40,{"$f":"E62*F62*G62","v":14400}]
[null,2,"TLB","month",2,60,40,{"$f":"E63*F63*G63","v":4800}]
[null,3,"Bobcat","month",2,60,40,4800]
[null,4,"Vacum Truck","month",2,60,40,4800]
[null,null,"Sub-Total (Overtme Sundays and Holidays) "]
[]
[null,"Total (Plant)"]
[]
[null,"Item","Description",{"$nulls":3},"Unit","Quantity","Rate ","Amount"]
[null,null,"SECTION 4 - TOOLS AND EQUIPMENT"]
[null,1,"Cleaning Equipment",{"$nulls":3},"Sum",5]
[null,"Total (Tools and Equipment)"]
[]
[null,"TOTAL EXCLUDING VAT"]