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

{"sheet":"BOQ","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"merged":[[0,0,3,5],[0,6,0,7],[0,8,0,9],[1,6,1,7],[1,8,1,9],[2,6,2,7],[2,8,2,9],[3,6,3,7],[3,8,3,9],[4,0,4,9],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5]]}
["National Transmission Company of South Africa\nBill of Quantities",{"$nulls":5},"Template Identifier"]
[{"$nulls":6},"Document Identifier"]
[{"$nulls":6},"Effective Date"]
[{"$nulls":6},"Review Date"]
["Project  Name: BULK WATER SUPPLY\n"]
["ITEM NO","PAYMENT REFERS TO","ERP Number","SHORT DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[{"$f":"CONCATENATE(N7,O7)","v":""},{"$nulls":8},{"$f":"IF(AND(OR(H7=0,I7=0)),\"\",(H7*I7))","v":""}]
[{"$nulls":3},"Preambles"]
[{"$nulls":3},"Bulk water that has been properly treated or is naturally suitable for  hygiene, and other household purposes"]
[]
[]
[{"v":1,"d":"1.00"},null,null,"Transport"]
[]
[{"v":1.1,"d":"1.10"},null,null,"Truck Water: 15 000 to 25000 Litre: Rate per kilometre",null,null,"Km",1,null,{"$f":"SUM(H14*I14)","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"v":1.2,"d":"1.20"},null,null,"Water"]
[]
["1.2.1",null,null,"Bulk Water",null,null,"L",1,null,{"$f":"SUM(H19*I19)","v":{"v":0,"d":"0.00"}}]
[{"$f":"CONCATENATE(N20,O20)","v":""},{"$nulls":8},{"$f":"IF(AND(OR(H20=0,I20=0)),\"\",(H20*I20))","v":""}]
[{"$nulls":3},"TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"IF(MAX(J7:J20)>0,SUM(J7:J20),\"\")","v":""}]