{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Information and Overview","Contract Information","SUMMARY ","TECHNICIAN"," SECTION B- SHE REQUIREMNTS ","Sheet1"],"not_rendered":{"images":1,"external_links":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Information and Overview","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"hidden":true}
[]
[]
[]
[]
[]
[null,"Non-destructive Testing Total Cost of Ownership Tool"]
[null,"Tab Colour","Contents","Instructions"]
[null,null,"Contract Information","Input the names of suppliers "]
[null,null,"1. Tender Input - Skills ","Input rates for skills"]
[null,null,"2. Tender Input - Equipment ","Input rates for equipment"]
[null,null,"3. Tender Input - Consumables ","Input rates for consumables"]
[null,null,"4. Input - Site Establishment","Input rates for site establishment"]
[null,null,"5. Accomodation","Only when necessary"]
[null,null,"6. Transport (15 seater and 22 seater)","Only when necessary"]

{"sheet":"Contract Information","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"hidden":true}
[]
[]
[]
[]
[]
[null,"Non-destructive Testing Total Cost of Ownership Tool"]
[]
[null,"Supplier ","Supplier 1"]
[null,"Supplier Name ","Company A"]
[]
[null,"Outage duration (days)"]
[null,"Shift duration (hours)"]

{"sheet":"SUMMARY ","index":2,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,0,4,2],[5,0,5,2]]}
["Client ","Rand Water "]
["Date","2024-12-09"]
["Tender Number ","RW 10403094/25 PACKAGE H"]
["Description ","The Provision of Non Destructive Testing Services  for a period of 60 Months"]
["PACKAGE H- -BILL OF QUANTITY"]
[]
["Section","Description","Amount"]
[]
["A","TECHNICIAN",{"$f":"+TECHNICIAN!F14","v":0}]
[]
["B","SHE REQUIREMENTS ",{"$f":"' SECTION B- SHE REQUIREMNTS '!E14:H14","v":0},0,0,0]
[]
[]
[]
[]
[null,"SUBTOTAL",{"$f":"SUM(C9:C11)","v":0}]
[]
[null,"Vat at 15%",{"$f":"C16*0.15","v":0}]
[{"$nulls":5},160,2,6,{"$f":"F19*G19*H19","v":1920}]
[]
[null,"TOTAL",{"$f":"C16+C18","v":0}]
[]
[null,"SECTION B CARRIED FORWARD TO TENDER SUMMARY",{"$f":"C21","v":0}]

{"sheet":"TECHNICIAN","index":3,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[1,2,1,8],[2,2,2,8],[3,2,3,8],[4,2,4,8],[5,2,5,8],[13,1,13,2],[13,5,13,8],[18,1,18,8]]}
[]
[null,"Client ","Rand Water "]
[null,"Date","2024-12-09"]
[null,"Tender Number ","RW 10403094-25 PACKAGE H"]
[null,"Description ","The Provision of Non Destructive Testing Services  for a period of 60 Months"]
[null,"Section ","D :Technician/Personel"]
[null,"ITEM","DESCRIPTION","Quantity ","Unit ","(B) Hours ","(C)RATE","(D)MONTHS ","AMOUNT "]
[null,{"v":1,"d":"1.00"},"The contractor shall provide the Team Leader /Supervisor to coordinate and manage  the Non Destructive testing team and work  ",1,"Rate/hour ",189,null,60,{"$f":"+D8*F8*G8*H8","v":0}]
[null,{"v":2,"d":"2.00"},"The contractor shall provide a Level II NDT technician  to approve ,interpret ,review and sign off the report ",3,"Rate/hour ",80,null,60,0,null,{"$f":"0.065","v":0.065}]
[null,{"v":3,"d":"3.00"},{"$f":"'[1]SECTION A-PERSONELL'!C9","v":"The contractor shall provide atleast  Welding Inspector Level I to conduct weld inspection on site "},{"v":6,"d":"6 "},"Rate/hour ",{"$f":"'[1]SECTION A-PERSONELL'!F9","v":189},null,60,0]
[null,{"v":4,"d":"4.00"},{"$f":"'[1]SECTION A-PERSONELL'!C10","v":"The contractor shall provide atleast  Welding Inspector Level II to conduct weld inspection on site "},{"v":6,"d":"6 "},"Rate/hour ",{"$f":"'[1]SECTION A-PERSONELL'!F10","v":189},null,60,0]
[null,{"v":5,"d":"5.00"},{"$f":"'[1]SECTION A-PERSONELL'!C11","v":"The contractor shall provide atleast Coating Inspector level 1 to conduct the coating and lining inspection "},{"v":6,"d":"6 "},"Rate/hour ",{"$f":"'[1]SECTION A-PERSONELL'!F11","v":189},null,60,0]
[null,{"v":6,"d":"6.00"},{"$f":"'[1]SECTION A-PERSONELL'!C12","v":"The contractor to provide a qualified Metallurgist "},{"v":2,"d":"2 "},"Rate/hour ",{"$f":"'[1]SECTION A-PERSONELL'!F12","v":160},null,60,0]
[null,"TOTAL",{"$nulls":3},{"$f":"SUM(I8:I13)","v":0}]
[{"$nulls":5},8]
[null,"* The number of Technician is not a commitment by Rand Water  it  shall depend on the need as this is an as and when required service."]
[null,"** Overtime shall be paid as per the Department of Labour guide -The maximum permissible overtime as per section 10 of the Basic Conditions of Employment Act is 10 hours in any 1 week. "]
[null,"*** Travel Shall be reimbursed as per AA Guide for the vehicles approved by Rand Water to a maximum of R6.50 per kilometer "]

{"sheet":" SECTION B- SHE REQUIREMNTS ","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"merged":[[0,2,0,7],[1,2,1,7],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[13,1,13,2],[13,4,13,7]]}
[null,"Client ","Rand Water "]
[null,"Date ","9 Dece,ber 2024"]
[null,"Tender Number :","RW 10403094/25"]
[null,"Description ","The Provision of Non Destructive Testing Services  for a period of 60 Months"]
[null,"Section ","E :SHE"]
[null,null,"PACKAGE  H"]
[null,"ITEM","DESCRIPTION","Unit ","Quantity ","Amount ","Duration ","TOTAL "]
[null,{"v":1,"d":"1.00"},"Preparation and Submission of the Health and Safety File (hard and soft copies)","Lump Sum ",1,null,1,{"$f":"+E8*F8*G8","v":0}]
[null,{"v":2,"d":"2.00"},"Cost of medical certificates and medical surveillance",{"$nulls":8},{"$f":"+E152","v":0}]
[null,null,"(a) Initial (baseline) medical examinations","Sum",24,null,1,{"$f":"+E10*F10*G10","v":0}]
[null,null,"(b) Periodic  examinations","Sum",24,null,3,{"$f":"+E11*F11*G11","v":0}]
[null,null,"(c)Exit examinations","Sum",24,null,1,{"$f":"+E12*F12*G12","v":0}]
[null,{"v":3,"d":"3.00"},"Provision of Personal Protective Equipment (PPE)","Sum",24,null,5,{"$f":"+E13*F13*G13","v":0}]
[null,"TOTAL ",null,null,{"$f":"SUM(H8:H13)","v":0}]

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