{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Bid Tabulation PD17-18.088","Totals"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Bid Tabulation PD17-18.088","index":0,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[0,0,0,5],[2,0,2,5],[29,2,29,3],[29,4,29,5],[32,1,33,5]]}
["Attachment A"]
[]
["CR 292 Barrancas Avenue Beautification Project"]
[]
["Bid Item No.","Description","Quantity","Units","Unit Price ","Item Price"]
[1,"Mobilization",1,"LS",null,{"$f":"C6*E6","v":{"v":0,"d":"$0.00"}}]
[2,"Maintenance of Traffic (Includes Plan, Notification, Implementation, and PCMS's - 7 days prior to start of construction)",1,"LS",null,{"$f":"C7*E7","v":{"v":0,"d":"$0.00"}}]
[3,"Erosion Control (Includes SWPPP Plan, Implementation, maintenance, replacement, etc.)",1,"LS",null,{"v":0,"d":"$0.00"}]
[4,"Clearing and Grubbing (Includes all above grade and below grade improvements as indicated and as necessary to facilitate new construction, and other work as indicated)",1,"LS",null,{"v":0,"d":"$0.00"}]
[5,"Irrigation (Includes all necessary connections and fittings)",1,"LS",null,{"v":0,"d":"$0.00"}]
[6,"Welcome Sign (Includes construction and installation)",1,"LS",null,{"v":0,"d":"$0.00"}]
[7,"Directional Bores",5,"EA",null,{"v":0,"d":"$0.00"}]
[8,"Backflow Preventer w/ Concrete Enclosure (Includes all necessary connections and fittings)",3,"EA",null,{"v":0,"d":"$0.00"}]
[9,"Install Water Meters provided by Peoples Water (Includes all necessary connections and fittings)",3,"EA",null,{"v":0,"d":"$0.00"}]
[10,"Mushroom Compost",103,"CY",null,{"v":0,"d":"$0.00"}]
[11,"Chaste Tree",1,"EA",null,{"v":0,"d":"$0.00"}]
[12,"Blue Sedge",249,"EA",null,{"v":0,"d":"$0.00"}]
[13,"Perennial Peanut",{"v":8410,"d":"8,410"},"SF",null,{"v":0,"d":"$0.00"}]
[14,"Blue Chip Budleia",{"v":1776,"d":"1,776"},"EA",null,{"v":0,"d":"$0.00"}]
[15,"Coontie",229,"EA",null,{"v":0,"d":"$0.00"}]
[16,"Live Oak",2,"EA",null,{"v":0,"d":"$0.00"}]
[17,"Tiger Eye Daisy",288,"EA",null,{"v":0,"d":"$0.00"}]
[18,"Society Garlic",35,"EA",null,{"v":0,"d":"$0.00"}]
[19,"Rose",96,"EA",null,{"v":0,"d":"$0.00"}]
[20,"Blue Rug Juniper",427,"EA",null,{"$f":"C25*E25","v":{"v":0,"d":"$0.00"}}]
[21,"Dwarf Fountain Grass",452,"EA",null,{"$f":"C26*E26","v":{"v":0,"d":"$0.00"}}]
[22,"Pine Straw Mulch",{"v":23112,"d":"23,112"},"SF",null,{"v":0,"d":"$0.00"}]
[]
[]
[null,null,"BID TOTAL =",null,{"$f":"SUM(F6:F27)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[" NOTE:","County reserves the right to add or delete up to 25% of the plant material quantity based upon the unit prices during the shop drawing review process."]

{"sheet":"Totals","index":1,"n_rows":65,"n_cols":6,"rows_kept":65,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[3,0,3,5],[64,2,64,3],[64,4,64,5]]}
["Rebel Road Drainage Improvements"]
["ENG1853"]
[]
[" Rebel Road Drainage Improvements"]
["Bid Item No.","Description","Quantity","Units","Unit Price ","Item Price"]
[1,"Mobilization",1,"LS",{"v":1800,"d":"$1,800.00"},{"$f":"C6*E6","v":{"v":1800,"d":"$1,800.00"}}]
[{"$f":"A6+1","v":2},"Maintenance of Traffic (Includes Plan, Notification, and Implementation)",1,"LS",{"v":10000,"d":"$10,000.00"},{"$f":"C7*E7","v":{"v":10000,"d":"$10,000.00"}}]
[{"$f":"A7+1","v":3},"Erosion Control (Includes SWPPP Plan, Implementation, NPDES General Permit, NOI, NOT, monitoring, replacement, etc.)",1,"LS",{"v":1500,"d":"$1,500.00"},{"v":1500,"d":"$1,500.00"}]
[4,"Clearing and Grubbing (Includes Removal of Existing Trees)",1,"LS",{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"}]
[5,"Remove and Re-Install Existing Concrete pad and Mail Kiosk",1,"EA",{"v":750,"d":"$750.00"},{"v":750,"d":"$750.00"}]
[6,"Remove and Re-Install Existing Brick Mailbox",2,"EA",{"v":1350,"d":"$1,350.00"},{"v":2700,"d":"$2,700.00"}]
[7,"Remove Existing Brick Mailbox and Replace with FDOT approved Heavy Duty Plastic Mailbox w/ Rear Door and Post (use if existing brick mailbox cannot be re-installed after removal)",2,"EA",{"v":435,"d":"$435.00"},{"v":870,"d":"$870.00"}]
[8,"Relocate Existing Mailbox",{"$f":"10+2+4+5","v":21},"EA",{"v":155,"d":"$155.00"},{"v":3255,"d":"$3,255.00"}]
[9,"Earthwork Fill (Borrow, FDOT Specification 120-2.2.2)",125,"CY",{"v":12,"d":"$12.00"},{"v":1500,"d":"$1,500.00"}]
[10,"Earthwork Establishing Grade",3860,"SY",{"v":1.9,"d":"$1.90"},{"v":7334,"d":"$7,334.00"}]
[11,"Remove and Replace Unsuitable Materials",100,"CY",{"v":14.5,"d":"$14.50"},{"v":1450,"d":"$1,450.00"}]
[12,"2\" County Spec 2500 Type SP 12.5 Asphalt",202,"SY",{"v":10.25,"d":"$10.25"},{"v":2070.5,"d":"$2,070.50"}]
[13,"Lateral Pavement Patch as per County Detail (6\" GAB)",{"$f":"24+36+30+68+50","v":208},"SY",{"v":46,"d":"$46.00"},{"v":9568,"d":"$9,568.00"}]
[14,"Remove Existing Asphalt (Includes roadway, driveways, swales, ditches, flumes, etc.)",{"$f":"26+24+16+174+36+4+54+87+30+64+6+42+79+15+96+68+15+124+30+68+26+8+122+165+23+21+17","v":1440},"SY",{"v":3,"d":"$3.00"},{"v":4320,"d":"$4,320.00"}]
[15,"Saw cut Existing Asphalt",420,"LF",{"v":2.35,"d":"$2.35"},{"v":987,"d":"$987.00"}]
[16,"6\" Stabilized Subgrade, County Spec 2300 (For Driveways)",942,"SY",{"v":3.25,"d":"$3.25"},{"v":3061.5,"d":"$3,061.50"}]
[17,"12\" Stabilized Subgrade, County Spec 2300",202,"SY",{"v":3.85,"d":"$3.85"},{"v":777.7,"d":"$777.70"}]
[18,"6\" Graded Aggregate Base, County Spec 2400",202,"SY",{"v":13.4,"d":"$13.40"},{"v":2706.8,"d":"$2,706.80"}]
[19,"Type SP 12.5 Asphalt Overlay (110 lbs.per SY) ",135,"TON",{"v":120,"d":"$120.00"},{"v":16200,"d":"$16,200.00"}]
[20,"Remove Existing Roadway Base",165,"SY",{"v":3.5,"d":"$3.50"},{"v":577.5,"d":"$577.50"}]
[21,"Relocate Existing Traffic Signs",3,"EA",{"v":43,"d":"$43.00"},{"v":129,"d":"$129.00"}]
[22,"FDOT Type F Curb",80,"LF",{"v":17.25,"d":"$17.25"},{"$f":"C27*E27","v":{"v":1380,"d":"$1,380.00"}}]
[23,"1' Ribbon Curb, per County Detail",{"$f":"1050+1175","v":2225},"LF",{"v":12,"d":"$12.00"},{"v":26700,"d":"$26,700.00"}]
[24,"4' Fiber Reinforced Concrete Driveway ",{"$f":"767+26+23+22+21+22+21+21+19","v":942},"SY",{"v":34.5,"d":"$34.50"},{"v":32499,"d":"$32,499.00"}]
[25,"Fiber Reinforced Concrete Flume (Includes Concrete Flume around Type E Modified Inlet #25)",52,"SY",{"v":57,"d":"$57.00"},{"v":2964,"d":"$2,964.00"}]
[26,"Remove Existing Concrete (Includes Driveways, Ditches, Swales, Flumes, etc.)",{"$f":"44+73+36+24+43+9+33+30+29+29+50+11+23","v":434},"SY",{"v":4,"d":"$4.00"},{"v":1736,"d":"$1,736.00"}]
[27,"Remove Existing Dirt/Gravel Driveway",{"$f":"42+42+48+45+28+25+31+40+56+26+19+19+13+19","v":453},"SY",{"v":1.75,"d":"$1.75"},{"v":792.75,"d":"$792.75"}]
[28,"Remove Existing Curb",2190,"LF",{"v":1.25,"d":"$1.25"},{"v":2737.5,"d":"$2,737.50"}]
[29,"Misc. Concrete",35,"CY",{"v":350,"d":"$350.00"},{"v":12250,"d":"$12,250.00"}]
[30,"Ditch Bottom Inlet, Type C, 0'-6' Depth",5,"EA",{"v":1850,"d":"$1,850.00"},{"v":9250,"d":"$9,250.00"}]
[31,"Ditch Bottom Inlet, Type C, 6'-12' Depth",3,"EA",{"v":2750,"d":"$2,750.00"},{"v":8250,"d":"$8,250.00"}]
[32,"Ditch Bottom Inlet, Type E, 0'-6' Depth",5,"EA",{"v":2750,"d":"$2,750.00"},{"v":13750,"d":"$13,750.00"}]
[33,"Ditch Bottom Inlet, Type E, 6'-12' Depth",14,"EA",{"v":4200,"d":"$4,200.00"},{"v":58800,"d":"$58,800.00"}]
[34,"County Type A-1 Curb Inlet, 0'-6' Depth",2,"EA",{"v":2900,"d":"$2,900.00"},{"v":5800,"d":"$5,800.00"}]
[35,"Junction Box with Manhole, 6'-12' Depth",1,"EA",{"v":3100,"d":"$3,100.00"},{"v":3100,"d":"$3,100.00"}]
[36,"Remove Existing Ditch Bottom Inlet (Includes Top and Bottom)",1,"EA",{"v":420,"d":"$420.00"},{"v":420,"d":"$420.00"}]
[37,"Remove Existing Curb Inlet (Includes Top and Bottom)",2,"EA",{"v":650,"d":"$650.00"},{"v":1300,"d":"$1,300.00"}]
[38,"Remove Existing Concrete Slab Spanning Ditch with Concrete Block Centerline Pier",1,"EA",{"v":1100,"d":"$1,100.00"},{"v":1100,"d":"$1,100.00"}]
[39,"18\" HDPE DW Pipe, 0'-6'  Depth",{"$f":"139+133+104+113+64+92+166","v":811},"LF",{"v":30.5,"d":"$30.50"},{"v":24735.5,"d":"$24,735.50"}]
[40,"24\" HDPE DW Pipe, 0'-6' Depth",{"$f":"372+240","v":612},"LF",{"v":37.5,"d":"$37.50"},{"v":22950,"d":"$22,950.00"}]
[41,"30\" HDPE DW Pipe, 0'-6'  Depth",479,"LF",{"v":51.5,"d":"$51.50"},{"$f":"C46*E46","v":{"v":24668.5,"d":"$24,668.50"}}]
[42,"30\" HDPE DW Pipe, 6'-12'  Depth",941,"LF",{"v":61.5,"d":"$61.50"},{"v":57871.5,"d":"$57,871.50"}]
[43,"36\" HDPE DW Pipe, 0'-6'  Depth",1190,"LF",{"v":59.5,"d":"$59.50"},{"v":70805,"d":"$70,805.00"}]
[44,"42\" HDPE DW Pipe, 0'-6'  Depth",32,"LF",{"v":82.5,"d":"$82.50"},{"v":2640,"d":"$2,640.00"}]
[45,"18\" RCP Pipe, 0'-6' Depth",{"$f":"43+48","v":91},"LF",{"v":36.5,"d":"$36.50"},{"v":3321.5,"d":"$3,321.50"}]
[46,"24\" RCP Pipe, 0'-6' Depth",{"$f":"90+117","v":207},"LF",{"v":45.5,"d":"$45.50"},{"v":9418.5,"d":"$9,418.50"}]
[47,"36\" RCP Pipe, 0'-6' Depth",{"$f":"92+62","v":154},"LF",{"v":77.5,"d":"$77.50"},{"v":11935,"d":"$11,935.00"}]
[48,"18\" Mitered End Section (Includes Concrete Apron)",2,"EA",{"v":1000,"d":"$1,000.00"},{"v":2000,"d":"$2,000.00"}]
[49,"42\" RCP Mitered End Section (Includes Concrete Splash Pad with Rebar and Welded Wire Mesh)",1,"EA",{"v":4200,"d":"$4,200.00"},{"v":4200,"d":"$4,200.00"}]
[50,"Remove Existing Pipe",983,"LF",{"v":20,"d":"$20.00"},{"v":19660,"d":"$19,660.00"}]
[51,"Remove Existing Headwall (Includes Concrete and Sandbag Headwalls)",24,"EA",{"v":625,"d":"$625.00"},{"v":15000,"d":"$15,000.00"}]
[52,"Dewatering",1,"DAY",{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"}]
[53,"Relocate Existing Water Meter, Service, & Flush Hydrant",19,"EA",{"v":435,"d":"$435.00"},{"$f":"C58*E58","v":{"v":8265,"d":"$8,265.00"}}]
[54,"Centipede Sod",3860,"SY",{"v":3.1,"d":"$3.10"},{"v":11966,"d":"$11,966.00"}]
[55,"18\" Depth Rip Rap Rubble with 4\" Bedding Stone and Filter Fabric",20,"SY",{"v":125,"d":"$125.00"},{"v":2500,"d":"$2,500.00"}]
[56,"Remove Existing Rip Rap",28,"SY",{"v":25,"d":"$25.00"},{"v":700,"d":"$700.00"}]
[57,"Remove and Replace Existing Wood Landscaping",20,"LF",{"v":15,"d":"$15.00"},{"v":300,"d":"$300.00"}]
[58,"Remove and Replace Existing Wood Privacy Fence",105,"LF",{"v":15,"d":"$15.00"},{"v":1575,"d":"$1,575.00"}]
[]
[null,null,"BID TOTAL =",null,{"$f":"SUM(F6:F63)","v":{"v":550397.75,"d":"$550,397.75"}}]