{"text_format":"3","workbook":"xls","n_sheets":22,"sheets":["Cover Page","Executive Summary"," Cost Breakdown","Inlet Works","Preliminary Treatment","Settlement Tanks","Activated Sludge","Disinfection","Clearwater Tanks","Outfall","Control Admin","Pumping Stations","Other Buildings","Sludge Treatment","Pipelines","Manholes","Service Reservoirs","Sewer Overflows","Other Works","Site Clearance","Landscaping","Project Indirects"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cover Page","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"merged":[[22,1,26,1]],"flags":["formulas_cached_only"]}
[]
[null,"Capital Works Management Framework"]
[]
[]
[null,"Costing Document (Civil Engineering Works)"]
[null,"Water Services"]
[]
[null,"CO 2.2a: Outline Cost Plan"]
[]
[]
[]
[null,"Cost Document (Civil Engineering Works) Water Services"]
[null,"Document Reference CO 2.2a V 1.1"]
[]
[null,"2013-08-14"]
[]
[]
[]
[" "]
[null,"© Department of Public Expenditure and Reform 2013"]
[]
[]
[null,"Published by:  Department of Public Expenditure and Reform\nGovernment Buildings\nMerrion Street\nDublin 2\n\n\n\n"]

{"sheet":"Executive Summary","index":1,"n_rows":40,"n_cols":4,"rows_kept":40,"merged":[[0,0,0,4],[0,5,0,10],[1,1,1,4],[3,2,3,4],[6,2,6,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[12,2,12,4],[15,2,15,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[26,2,26,3]],"flags":["formulas_cached_only"]}
["Complete blue cells on this worksheet and on the Cost Breakdown worksheet."]
["CO 2.2a: Outline Cost Plan","EXECUTIVE SUMMARY"]
[]
["Report Author"]
["Date"]
[]
["Project Title"]
["Project number"]
["Sponsoring Agency"]
["Sanctioning Authority"]
["Procurement System"]
[]
["Project Description"]
[{"$nulls":3},"m of piping"]
[]
["Project Address"]
[]
["Project Team"]
["Client's Representative"]
["Architectural"]
["Engineering"]
["Quantity Surveying"]
["Other"]
[]
[null,null,"Cost","Cost per"]
[{"$nulls":3},"m of piping"]
[null,null,"Excluding VAT"]
["Civil ",null,{"v":0,"d":"0.00"},0]
["Mechanical and Electrical",null,{"v":0,"d":"0.00"},0]
["Project Indirects",null,{"v":0,"d":"0.00"},0]
[]
["TOTAL",null,0,0]
[]
["of which",null,null,"VAT"]
["Liable for VAT @ 23%",null,null,0]
["Liable for VAT @ 0% or exempt",null,null,0]
["Liable for VAT @ 13.5%",null,0,0]
[null,null,"VAT Total",0]
[]
["Grand total including VAT",null,0]

{"sheet":" Cost Breakdown","index":2,"n_rows":31,"n_cols":13,"rows_kept":31,"merged":[[0,2,0,9],[1,2,1,8],[1,10,3,10],[1,12,3,12],[2,2,3,2],[2,6,3,6],[31,1,31,9]],"flags":["formulas_cached_only"]}
[null,null,"Cost Breakdown"]
[null,null,"VAT exclusive",{"$nulls":7},"% of total cost",null,"Notes"]
[null,null,"Civil cost",null,"Civil cost/",null,"Mechanical and electrical cost",null,"Mechanical and electrical cost/"]
[{"$nulls":4},"m of piping",{"$nulls":3},"m of piping"]
[1,"Inlet/intake works ",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[2,"Preliminary treatment",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[3,"Settlement/sedimentation tanks",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[4,"Activated sludge/filters",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[5,"Disinfection",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[6,"Clearwater/storm water tanks",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[7,"Outfall/trunkmain",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[8,"Control/administration buildings",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[9,"Pumping stations",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[10,"Other buildings",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[11,"Sludge treatment tanks and buildings",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[12,"Pipelines",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[13,"Manhole/valve chambers",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[14,"Service reservoirs",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[15,"Combined sewer overflows",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[16,"Other works ",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[17,"Site clearance ",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[18,"Landscaping",null,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[]
[null,"Subtotal",{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[]
[]
[null,"Subtotal civil, mechanical and electrical",{"v":0,"d":"0.00"}]
[]
[null,"Project Indirects"]
[]
[null,"TOTAL",{"v":0,"d":"0.00"}]

{"sheet":"Inlet Works","index":3,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Inlet/Intake Works"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Preliminary Treatment","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Preliminary Treatment"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Settlement Tanks","index":5,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Settlement/Sedimentation Tanks"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Activated Sludge","index":6,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Activated Sludge/Filters"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Disinfection","index":7,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Disinfection"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Clearwater Tanks","index":8,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Clearwater/Storm Water Tanks"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Outfall","index":9,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Outfall/Trunkmain"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Control Admin","index":10,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Control/Administration Buildings"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Pumping Stations","index":11,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Pumping Stations"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Other Buildings","index":12,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Other Buildings"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Sludge Treatment","index":13,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Sludge Treatment Tanks and Buildings"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Pipelines","index":14,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Pipelines"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Manholes","index":15,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Manhole/Valve Chambers"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Service Reservoirs","index":16,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Service Reservoirs"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Sewer Overflows","index":17,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Combined Sewer Overflows"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Other Works","index":18,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Other Works"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Site Clearance","index":19,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Site Clearance"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Landscaping","index":20,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Landscaping"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]

{"sheet":"Project Indirects","index":21,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,1,0,5],[2,1,2,3]],"flags":["formulas_cached_only"]}
[null,"Project Indirects"]
[]
[null,"Total Cost from Cost Breakdown:",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
[null,"Item",null,"Cost (excl. VAT)",null,"Notes"]