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

{"sheet":"cover page","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"merged":[[17,0,17,9],[18,0,18,9],[19,0,19,9]]}
{"$rows_empty":17}
["PROPOSED TEMPORARY FENCE "]
[]
["AT LOT 22313 HULHUMALE'"]

{"sheet":"Summary","index":1,"n_rows":41,"n_cols":3,"rows_kept":41,"merged":[[1,0,1,2],[4,0,4,2]]}
[]
["Proposed Temporary Fence\nat LOT 22313 Hulhumale'"]
[]
[]
["SUMMARY OF BILL OF QUANTITIES"]
["NO","BILL","AMOUNT (MRF)"]
[]
[1,"PRELIMINARIES",{"$f":"BOQ!F66","v":0}]
[2,{"$f":"BOQ!B68","v":"CONCRETE & WORKS BELOW GROUND"},{"$f":"BOQ!F128","v":0}]
[3,{"$f":"BOQ!B130","v":"METAL WORKS"},{"$f":"BOQ!F185","v":0}]
{"$rows_empty":10}
[null,"SUB TOTAL",{"$f":"SUM(C8:C13)","v":0}]
[null,"GST 8%",{"$f":"C21*0.08","v":0}]
{"$rows_empty":10}
[" "," "]
[null," GRAND TOTAL ",{"$f":"SUM(C20:C26)","v":0}]
[]
[]
[]
[null,"area",{"$f":"12.8*10.49-1.63*8.2","v":120.90600000000002}]
[null,"x3 floor",{"$f":"C38*3","v":{"v":362.7180000000001,"d":"362.72"}}]
[null,"sqft",{"$f":"C39*10.764","v":{"v":3904.2965520000007,"d":"3,904.30"}}]
[null,"cost/ sqft",{"$f":"C21/C40","v":0}]

{"sheet":"BOQ","index":2,"n_rows":185,"n_cols":6,"rows_kept":185}
[]
["Item","Description","Qty","Unit","Rate","Amount"]
[null,"BILL No: 01"]
[null,"PRELIMINARIES"]
[]
[1.1,"GENERAL NOTES"]
[{"v":1,"d":"(1)"},"Abbreviations "]
[null,"m - metre"]
[null,"Nos - numbers"]
[null,"m³ - cubic metre"]
[null,"m² - square metre"]
[null,"m - metre"]
[null,"kg - kilogram"]
[null,"incl - including"]
[null,"mm - millimetre"]
[null,"dia - diametre"]
[null,"SS - Staiinless Steel"]
[null,"GI - Galvinised Iron"]
[]
[1.2,"SITE MANAGEMENT COSTS"]
[null,"Allow for all on and off site management costs including costs of foreman and assistants, and similar items.",1,"Item",null,{"$f":"E21*C21","v":0}]
[]
[1.3,"SITE ESTABLISHMENT"]
[null,"Allow for mobilization and demobilization",1,"Item",null,{"$f":"E24*C24","v":0}]
[]
[1.4,"SERVICES AND FACILITIES"]
[null,"Provision and maintenance of services and facilities such as  Water,  power supply, lighting  and fuel required for the project.",1,"item",null,0]
[]
[1.5,"CLEANING UPON COMPLETION"]
[null,"Cleaning the site upon completion of all works",1,"Item",null,{"$f":"E30*C30","v":0}]
{"$rows_empty":34}
[null,"BILL No: 01 - PRELIMINARIES"]
[null,"TOTAL OF BILL No: 01 - Carried over to summary",{"$nulls":3},{"$f":"SUM(F21:F64)","v":0}]
[null,"BILL No: 02"]
[null,"CONCRETE & WORKS BELOW GROUND"]
[]
[2.1,"GENERAL"]
[null,"(a) Rates shall include for: provision to place in position; casting of all required items and finishing after removal of formwork and  additional concrete required to conform to structural and excavated tolerances."]
[null,"(b) Rates shall include supply of all formwork item including form oil, timber, plywood, nails etc."]
[null,"(c) Mix ratio for  reinforced concrete shall be 1:2:3 unless otherwise specified and lean concrete shall be 1:3:6 by volume"]
[]
[2.2,"EXCAVATION"]
[{"v":1,"d":"(1)"},"Excavation for GI pipes embedded in ground",{"v":1,"d":"1.00"},"m³",null,{"$f":"E76*C76","v":0}]
[]
[2.3,"PCC CONCRETE"]
[" ","In-situ PCC concrete to; rates are inclusive of formwork & all other requirements"]
[{"v":1,"d":"(1)"},"PCC Mass Concrete - 450mm x 450mm x 450mm",{"v":2.6,"d":"2.60"},"m³",null,{"$f":"E80*C80","v":0}]
[{"v":2,"d":"(2)"},"PCC Mass Concrete - 300mm x 300mm x 300mm",{"v":1,"d":"1.00"},"m³",null,{"$f":"E81*C81","v":0}]
{"$rows_empty":45}
[null,"BILL No: 02 - CONCRETE & WORKS BELOW GROUND"]
[null,"TOTAL OF BILL No: 02 - Carried over to summary",{"$nulls":3},{"$f":"SUM(F75:F126)","v":0}]
[null,"BILL No: 03"]
[null,"METAL WORKS"]
[]
[3.1,"METAL FENCE"]
[null,"(a) Rates shall include for: all fabrication work, welding, marking, drilling for bolts including those securing timbers, steel plates, bolts, nuts and any type of washer, riveted work, counter sinking and tapping for bolts or machine screws."]
[null,"(b) Rates shall include for all painting and finishing."]
[null,"(c) Rates shall include for fabrication and erection of temporary supports and fixing into position"]
[" ","Supply and Installation of Metal Fence, with GI pipe supports and corrugated roofing sheets"]
[{"v":1,"d":"(1)"},"Metal Fence, 1900mm High",{"v":307.6,"d":"307.60"},"m³",null,{"$f":"E137*C137","v":0}]
[]
[3.2,"FENCE SUPPORT FRAMEWORK"]
[{"v":1,"d":"(1)"},"Dia. 38mm GI pipe embedded in concrete block",{"v":49.7,"d":"49.70"},"m",null,{"$f":"E140*C140","v":0}]
[{"v":2,"d":"(2)"},"Dia. 38mm GI pipe for bracing",{"v":9.8,"d":"9.80"},"m",null,0]
[{"v":3,"d":"(3)"},"Dia. 38mm GI pipe to support brace pipe",{"v":37,"d":"37.00"},"m",null,0]
[{"v":4,"d":"(4)"},"Dia. 38mm GI pipe embedded in concrete in ground",{"v":82.6,"d":"82.60"},"m",null,0]
[{"v":5,"d":"(5)"},"Dia. 38mm GI pipe horizontal support pipe",{"v":170.9,"d":"170.90"},"m",null,0]
[]
[3.3,"GATES & OPENINGS"]
["3.3.1","GENERAL"]
[null," (a) Rates shall include for locks, latches, closures, push plates, pull handles, bolts, kick plates, hinges and all door & window hardware. These materials should brass and of superior quality."]
[null,"(b) Rates shall include for door frames, mullions, transoms, trims, glazing, tinting, timber panels, boarding, framing, lining, fastenings and all fixings"]
[null,"(c) Rates shall include for painting "]
[null,"(d) All doors shall be in accordance with drawings (doors and windows schedule) and specifications"]
[null,"(e) All measurements shall be checked on site by the contractor before fabrication."]
[]
["3.3.2","METAL GATES"]
[{"v":1,"d":"(1)"},"Metal Gate - (1019mm x 1800mm)",2,"Nos",null,{"$f":"E155*C155","v":0}]
[{"v":2,"d":"(2)"},"Sliding Metal Gate - (5790mm x 1550mm)",1,"Nos",null,0]
{"$rows_empty":27}
[null,"BILL No: 03 METAL WORKS"]
[null,"TOTAL OF BILL No: 03 - Carried over to summary",{"$nulls":3},{"$f":"SUM(F132:F183)","v":0}]