{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[27,3,27,6],[32,3,32,5],[33,3,33,5]]}
["DUVHA COAL AND ASH HANDLING - Contract- PROVISION OF SUPPLY, DELIVERY AND INSTALLATION OF PIEZOMETERS FOR 36 MTHS"]
[]
[null,"Description","UoM","QTY","Rate","Total","Periods","Contract Total"]
["A","Preliminary and General"]
["A1","Site Establishment","Day",{"v":1,"d":"1.00"},null,{"$f":"E5*D5","v":0},{"v":8,"d":"8.00"},{"$f":"F5*G5","v":0}]
["A2","Accomodation","Day",{"v":10,"d":"10.00"},null,{"$f":"E6*D6","v":0},{"v":8,"d":"8.00"},{"$f":"F6*G6","v":0}]
["A3","Medicals & Police Clearance","no",{"v":6,"d":"6.00"},null,{"$f":"E7*D7","v":0},{"v":3,"d":"3.00"},{"$f":"F7*G7","v":0}]
["A4","Travelling","km",{"v":1500,"d":"1500.00"},null,{"$f":"E8*D8","v":0},{"v":8,"d":"8.00"},{"$f":"F8*G8","v":0}]
["A5","Consumables (oil, pvc glue, rags, anti-sieze, drill bits, thread tape, grease, rope, sand paper, cutting disks)","no",{"v":1,"d":"1.00"},null,{"$f":"E9*D9","v":0},{"v":8,"d":"8.00"},{"$f":"F9*G9","v":0}]
[]
[null,"Sub-Total",{"$nulls":5},{"$f":"SUM(H5:H10)","v":0}]
[]
["B","Activity Schedule","UoM","QTY",null,"Total","Periods","Contract Total"]
[]
["B1","Metres to Drill","m",{"v":350,"d":"350.00"},null,{"$f":"E15*D15","v":0},{"v":8,"d":"8.00"},{"$f":"G15*F15","v":0}]
["B2","PVC Pizo Flilters - Gasagrande","ea",{"v":8,"d":"8.00"},null,0,{"v":8,"d":"8.00"},0]
["B3","Outside filter with galvanised tip","ea",{"v":8,"d":"8.00"},null,0,{"v":8,"d":"8.00"},0]
["B4","PVC stop ends","ea",{"v":50,"d":"50.00"},null,0,{"v":8,"d":"8.00"},0]
["B5","PVC pipes","m",{"v":50,"d":"50.00"},null,0,{"v":8,"d":"8.00"},0]
["B6","PVC sockets","ea",{"v":8,"d":"8.00"},null,0,{"v":8,"d":"8.00"},0]
["B7","Bentonite and river sand","no",{"v":8,"d":"8.00"},null,0,{"v":8,"d":"8.00"},0]
["B8","Labour (Materials off loading on site)","no",{"v":8,"d":"8.00"},null,0,{"v":8,"d":"8.00"},0]
[]
[null,"Sub-Total",{"$nulls":5},{"$f":"SUM(H15:H22)","v":0}]
[]
[null,"TOTAL COSTS FOR SUPPLY, DELIVERY AND INSTALLATION OF PIEZOMETERS EXCL. VAT",{"$nulls":5},{"$f":"H24+H11","v":0}]
[]
[{"$nulls":3},"TOTAL EXCLUDING VAT FOR 12 MONTHS ",{"$nulls":3},{"$f":"H26/3","v":0}]
[]
["TOTAL ",null,null,"Total for year one",{"$nulls":3},{"$f":"H28","v":0}]
["CPI July 2022 = 105.8 June 2023 = 109.8 =3.7%",null,null,"Total for year two",null,null,{"v":0.037,"d":"3.70%"},{"$f":"H30+H30*$G$31","v":0},{"$f":"H31-H30","v":0}]
[{"$nulls":3},"Total for year three",null,null,{"v":0.037,"d":"3.70%"},{"$f":"H31+H31*$G$32","v":0},{"$f":"H32-H31","v":0}]
["Total  ",null,null,"Total  including CPA",{"$nulls":3},{"$f":"SUM(H30:H32)","v":0},{"$f":"SUM(I31:I32)","v":0}]
[{"$nulls":7},{"$f":"H33*0.1","v":0}]
["Total ",null,null,"Total including CPA ",{"$nulls":3},{"$f":"H34+H33","v":0}]