{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Transportation Estimator ","Public Water Estimator","Public Sewer Estimator","Transit","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Transportation Estimator ","index":0,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5],[51,1,51,4],[3,2,3,5],[4,2,4,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[5,2,5,5],[6,2,6,5],[50,1,50,4],[7,1,7,5],[14,1,14,5],[64,1,64,4],[63,1,63,4],[53,1,53,4],[12,1,13,5],[15,1,15,5],[62,1,62,4],[59,1,61,5]]}
[null,"Raleigh Department of Transportation"]
[null,"INFRASTRUCTURE SURETY ESTIMATE"]
[]
[null,"Project Name"]
[null,"Case Number (SUB-, ASR-, RCMP-)"]
[null,"Phase Number"]
[null,"Date Submitted"]
[]
[null,"Contact Person"]
[null,"Company/Firm Name"]
[null,"Phone Number"]
[null,"Email Address"]
[null,"By submitting this Engineering Estimate to the City of Raleigh I hereby acknowledge the totals given below to be an accurate representation of construction costs for work within the public Right of Way, associated with the aforementioned project."]
[]
[null,"Infrastructure Improvements "]
[null,"The purpose of this estimate is to clearly encompass ALL construction costs within public Right of Way. Each total adjacent to an “Item” shall be appropriately inclusive. It is the responsibility of the submitter to include any project specific item not originally listed below."]
[null,"ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
[null,"Clearing & Grubbing",null,"AC",11938.53,{"$f":"C18*E18","v":0}]
[null,"Erosion Control",null,"LF",7.54,{"$f":"C19*E19","v":0}]
[null,"Traffic Control (both sides)",null,"LF",17.28,0]
[null,"Common Excavation",null,"CY",14.62,0]
[null,"Catch Basins (per side)",null,"LF/Street",20.09,0]
[null,"Storm Drain Perpendicular",null,"In dia/LF-R/W",2.37,0]
[null,"Storm Drain Parallel to RW",null,"LF/Street",9.3699999999999992,0]
[null,"Rock Excavation",null,"CY",71.58,0]
[null,"30\" Curb & Gutter (per side)",null,"LF/Street",14.62,0]
[null,"18\" Median Curb (per side)",null,"LF/Street",11.04,0]
[null,"6' Sidewalk (per side)",null,"LF/Sidewalk",20.079999999999998,0]
[null,"5' Sidewalk (per side)",null,"LF/Sidewalk",16.72,{"$f":"C29*E29","v":0}]
[null,"Multi-Purpose Path (per side)",null,"LF/MUP",11.6,0]
[null,"Utility Pole Relocation",null,"EA",7616.11,0]
[null,"Fire Hydrant Relocation",null,"EA",2105.85,0]
[null,"Water Meter Relocation",null,"EA",635.54999999999995,0]
[null,"Backflow Relocation",null,"EA",6092.88,0]
[null,"Traffic Signal Upgrade",null,"Per Pole",18075.509999999998,0]
[null,"Traffic Signal Relocation",null,"Per Corner",5539.31,0]
[null,"Keystone Brick Retaining Wall",null,"SF",22.87,0]
[null,"Pour-in-place Retaining Wall",null,"CY",685.21,0]
[null,"Asphalt (Surface Layer)",null,"SY-Inch depth",2.64,0]
[null,"Asphalt (Binder Layer)",null,"SY-Inch depth",2.72,0]
[null,"Asphalt (Base Layer)",null,"SY-Inch depth",2.83,0]
[null,"Paving Stone (ABC)",null,"SY-Inch depth",0.65,0]
[null,"Seeding & Mulching ",null,"AC",2025.3,0]
[null,"Paint Striping",null,"LF",4.3,0]
[null,"Guardrail",null,"LF",32.08,0]
[null,"Street Tree (Tree Lawn)",null,"EA",2152,0]
[null,"Tree Grate (Urban Street Tree)",null,"EA",6427,0]
[null,"*Misc. Item",null,null,0,{"$f":"C48*E48","v":0}]
[null,"*Misc. Item",null,null,0,0]
[]
[null,"Total Construction Cost:",null,null,null,{"$f":"SUM(F18:F49)","v":0}]
[null,"Mobilization (4%)",null,null,null,{"$f":"F51*0.04","v":0}]
[null,"Design and Inspection (16% of construction cost)",null,null,null,{"$f":"F51 * 0.16","v":0}]
[null,"SUBTOTAL (Streets):",null,null,null,{"$f":"F51+F52+F53","v":0}]
[null,"SUBTOTAL (Public Water):",null,null,null,{"$f":"('Public Water Estimator'!E32)","v":0}]
[null,"SUBTOTAL (Public Sewer):",null,null,null,{"$f":"('Public Sewer Estimator'!E36)","v":0}]
[null,"SUBTOTAL (Transit):",null,null,null,{"$f":"(Transit!E22)","v":0}]
[null,"SUBTOTAL: ",null,null,null,{"$f":"(F51+F52+F53+F55+F56+F57)","v":0}]
[]
[null,"*If the proposed work is along a City of Raleigh maintained street, the Surety shall be adjusted to 125% of Subtotal. (UDO, Section 8.1.3.B). If along NCDOT-maintained street, the Surety shall be adjusted to 100% of Subtotal. Coordinate with the Transportation Department - Engineering reviewer to determine if the streets in question are City or State maintained.  Please select either \"City of Raleigh\" or \"NCDOT\" from the below dropdown.   "]
[]
[]
[null,"Is the proposed work along a City of Raleigh or NCDOT maintained street?",null,null,null,"City of Raleigh"]
[null,"TOTAL:",null,null,null,{"$f":"IF(F63=\"NCDOT\",F58,(F58*1.25))","v":0}]
[null,"FY23 Development Fee Schedule (effective 7/1/2022)"]
[null,"*Public Water calculation from attached \"Water Estimator\""]
[null,"**Public Sewer calculation from attached \"Sewer Estimator\""]

{"sheet":"Public Water Estimator","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,3],[2,0,2,4],[14,0,14,4],[19,0,19,4],[26,0,26,4],[29,0,29,3],[30,1,30,3]]}
["Water Infrastructure Surety Estimator"]
[]
["Water Mains"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["6-Inch",null,"LF",146,{"$f":"B5*D5","v":0}]
["6-Inch (Bore & Jack)",null,"LF",244,{"$f":"B6*D6","v":0}]
["8-Inch",null,"LF",151,0]
["8-Inch (Bore & Jack)",null,"LF",306,0]
["12-Inch",null,"LF",186,{"$f":"B9*D9","v":0}]
["12-Inch (Bore & Jack)",null,"LF",534,{"$f":"B10*D10","v":0}]
["16-Inch",null,"LF",250,0]
["16-Inch (Bore & Jack)",null,"LF",687,0]
["24-Inch",null,"LF",262,0]
["24-Inch (Bore & Jack)",null,"LF",840,0]
["Services"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["3/4-Inch",null,"EA",1550,{"$f":"B17*D17","v":0}]
["1-Inch",null,"EA",1619,{"$f":"B18*D18","v":0}]
["2-Inch",null,"EA",8557,0]
["Insertion Valves"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["2-Inch",null,"EA",6103,{"$f":"B22*D22","v":0}]
["4-Inch",null,"EA",11138,{"$f":"B23*D23","v":0}]
["6-Inch",null,"EA",14496,0]
["8-Inch",null,"EA",17851,{"$f":"B25*D25","v":0}]
["12-Inch",null,"EA",24565,0]
["Fire Hydrants"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["Fire Hydrant",null,"EA",5954,{"$f":"B29*D29","v":0}]
["Subtotal",null,null,null,{"$f":"SUM(E5:E14,E17:E19,E22:E26,E29)","v":0}]
["Design and Inspection","10% of Construction Cost",null,null,{"$f":"E30*0.1","v":0}]
["Total",null,null,null,{"$f":"SUM(E30:E31)","v":0}]

{"sheet":"Public Sewer Estimator","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,3],[2,0,2,4],[22,0,22,4],[30,0,30,4],[33,0,33,3],[34,1,34,3]]}
["Sewer Infrastructure Surety Estimator"]
[]
["Sewer Mains"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["8-Inch",null,"LF",171,{"$f":"B5*D5","v":0}]
["8-Inch (> 16' Depth)                               ",null,"LF",226,{"$f":"B6*D6","v":0}]
["8-Inch  (Bore & Jack)",null,"LF",601,0]
["12-Inch",null,"LF",182,{"$f":"B8*D8","v":0}]
["12-Inch (> 16' Depth)                               ",null,"LF",239,{"$f":"B9*D9","v":0}]
["12-Inch (Bore & Jack)",null,"LF",833,0]
["16-Inch",null,"LF",189,{"$f":"B11*D11","v":0}]
["16-Inch (> 16' Depth)                               ",null,"LF",250,{"$f":"B12*D12","v":0}]
["16-Inch (Bore & Jack)",null,"LF",1361,0]
["18-Inch",null,"LF",202,{"$f":"B14*D14","v":0}]
["18-Inch (> 16' Depth)                               ",null,"LF",262,{"$f":"B15*D15","v":0}]
["18-Inch (Bore & Jack)",null,"LF",1889,0]
["24-Inch",null,"LF",244,{"$f":"B17*D17","v":0}]
["24-Inch (> 16' Depth)                               ",null,"LF",308,{"$f":"B18*D18","v":0}]
["24-Inch (Bore & Jack)",null,"LF",2377,{"$f":"B19*D19","v":0}]
["30-Inch ",null,"LF",312,{"$f":"B20*D20","v":0}]
["30-Inch (>16' Depth)",null,"LF",330,{"$f":"B21*D21","v":0}]
["30-Inch (Bore &Jack)",null,"LF",3500,0]
["Manholes"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["4-Foot Dia. (< 16' Depth)",null,"EA",4616,{"$f":"B25*D25","v":0}]
["4-Foot Dia. (> 16' Depth)",null,"EA",10790,{"$f":"B26*D26","v":0}]
["5-Foot Dia. (< 16' Depth)",null,"EA",10073,0]
["5-Foot Dia. (> 16' Depth)",null,"EA",14159,{"$f":"B28*D28","v":0}]
["6-Foot Dia. (< 16' Depth)",null,"EA",15978,{"$f":"B29*D29","v":0}]
["6-Foot Dia. (> 16' Depth)",null,"EA",27582,0]
["Services"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["Services",null,"EA",2272,{"$f":"B33*D33","v":0}]
["Subtotal",null,null,null,{"$f":"SUM(E5:E22,E25:E30,E33)","v":0}]
["Design and Inspection","10% of Construction Cost",null,null,{"$f":"E34*0.1","v":0}]
["Total",null,null,null,{"$f":"SUM(E34:E35)","v":0}]

{"sheet":"Transit","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,1,20,3],[21,0,21,3],[19,0,19,3],[2,0,2,4],[7,0,7,4]]}
["Transit Infrastructure Estimator "]
[]
["Transit"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["Transit Shelter- Surveying",null,"LF",2200,{"$f":"B5*D5","v":0}]
["Transit Shelter- Site Design",null,"LF",5050,{"$f":"B6*D6","v":0}]
["Transit Shelter- Construction Adminstration",null,"LF",900,{"$f":"B7*D7","v":0}]
["Transit Shelter Construction"]
["ITEM","QUANT.","UNIT","PRICE","TOTAL ($)"]
["Construction of large pad for large shelter- 15ft x 20ft",null,"EA",12314,{"$f":"B10*D10","v":0}]
["Construction of slim pad for slim shelters- 6ft x 20ft size",null,"EA",6802,{"$f":"B11*D11","v":0}]
["Brasco Bus Shelter (Full size)",null,"EA",6415,0]
["Brasco Bus Shelter (Slim size)",null,"EA",5694,{"$f":"B13*D13","v":0}]
["Jericho Palm Bus Shelter",null,"EA",8746,{"$f":"B14*D14","v":0}]
["36 Gallon Trash Receptacle Concrete Mounted",null,"EA",1072,{"$f":"B15*D15","v":0}]
["Four foot metal bench with center support handle",null,"EA",1596,{"$f":"B16*D16","v":0}]
["Six foot metal bench with center support handle",null,"EA",1773,{"$f":"B17*D17","v":0}]
["Solar Light",null,"EA",1600,{"$f":"B18*D18","v":0}]
[]
["Subtotal",null,null,null,{"$f":"SUM(E10:E19,E5:E7)","v":0}]
["Design and Inspection","10% of Construction Cost",null,null,{"$f":"E20*1.1","v":0}]
["Total",null,null,null,{"$f":"E21*1.1","v":0}]

{"sheet":"Sheet1","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"City of Raleigh"]
[null,null,"NCDOT"]