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

{"sheet":"Cost Estimate","index":0,"n_rows":97,"n_cols":7,"rows_kept":97,"merged":[[0,1,0,6],[1,1,1,6],[23,7,23,10],[23,11,23,14],[92,1,94,6],[93,8,93,9]]}
[null,"SUBMITTAL PROPOSAL FORM /"]
[null,"SCHEDULE OF VALUES"]
[null,"IFB TITLE:","ALLISON ROAD PEDESTRIAN CONNECTOR "]
[null,"IFB NUMBER:","2024-107"]
[null,"PAY ITEM","DESCRIPTION","QUANTITY","UNIT","UNIT PRICE","TOTAL PRICE"]
[null,1031000,"MOBILIZATION",1,"LS  ",null,{"$f":"D6*F6","v":0}]
[null,1032010,"BONDS AND INSURANCE",1,"LS  ",null,{"$f":"D7*F7","v":0}]
[null,1050800,"CONSTRUCTION STAKES, LINES & GRADES",1,"EA",null,0]
[null,1052110,"LARGE PUBLIC WATER RELOCATION NO. (001)",1,"EA",null,0]
[null,1052210,"LARGE PUBLIC SEWER RELOCATION NO. (001)",1,"EA",null,0]
[null,1071000,"TRAFFIC CONTROL",1,"LS  ",null,0]
[null,1090200,"AS-BUILT CONSTRUCTION PLANS",1,"LS  ",null,0]
[null,2011000,"CLEARING & GRUBBING WITHIN RIGHT OF WAY",1,"LS  ",null,0]
[null,2021010,"REMOVAL & DISPOSAL OF EXISTING DROP INLET",1,"EA  ",null,0]
[null,2023000,"REMOVAL & DISPOSAL OF EXISTING PAVEMENT",285,"SY",null,0]
[null,2024100,"REMOVAL & DISPOSAL OF EXISTING CURB",{"v":16.459,"d":"16"},"LF",null,0]
[null,2027000,"REMOVAL & DISPOSAL OF EXISTING CONCRETE",5,"CY",null,0]
[null,2031000,"UNCLASSIFIED EXCAVATION",5,"CY",null,0]
[null,2033000,"BORROW EXCAVATION",241,"CY",null,0]
[null,2081001,"FINE GRADING",989,"SY",null,0]
[null,2103000,"FLOWABLE FILL",120,"CY",null,0]
[null,3069900,"MAINTENANCE STONE",97,"TON",null,0]
[null,4011004,"LIQUID ASPHALT BINDER PG64-22",23,"TON",null,0]
[null,4013990,"MILLING EXISTING ASPHALT PAVEMENT (VARIABLE)",{"v":1267,"d":"1,267"},"SY",null,0]
[null,4030340,"HOT MIX ASPHALT SURFACE COURSE TYPE C",361,"TON ",null,0]
[null,6021120,"PERMANENT CONSTRUCTION SIGNS (GROUND MOUNTED)",418,"SF",null,0]
[null,6021125,"PERMANENT CONSTRUCTION SIGNS (BARRICADE MOUNTED)",{"$f":"35*2","v":70},"SF",null,0]
[null,6021130,"DETOUR SIGNS",299,"SF",null,0]
[null,6041200,"BARRICADE - TYPE 3",84,"LF",null,0]
[null,"608100B","TYPE B - FLASHING LIGHT",{"$f":"8*2","v":16},"EA",null,0]
[null,6250005,"4\" WHITE BROKEN LINES -(GAPS EXCLUDED)-FAST DRY PAINT",{"$f":"171.567*(2/7)","v":{"v":49.01914285714285,"d":"49"}},"LF",null,0]
[null,6250010,"4\" WHITE SOLID LINES (PVT. EDGE LINES)-FAST DRY PAINT",{"v":36.319,"d":"36"},"LF",null,0]
[null,6250015,"8\"WHITE SOLID LINES(CROSSWALK&CHANNELIZATION)FAST DRY PAINT",{"v":294.429,"d":"294"},"LF",null,0]
[null,6250025,"24\" WHITE SOLID LINES (STOP/DIAGONAL LINES)-FAST DRY PAINT",{"$f":"(13*4)+17+11+11+16+21","v":128},"LF",null,0]
[null,6250030,"WHITE SINGLE ARROW (LEFT, STRAIGHT, RIGHT)-FAST DRY PAINT",1,"EA  ",null,0]
[null,6250040,"WHITE COMBINATION ARROW(STR.& RT.OR STR.& LT.)FAST DRY PAINT",1,"EA  ",null,0]
[null,6250110,"4\"YELLOW SOLID LINE(PVT.EDGE&NO PASSING ZONE)-FAST DRY PAINT",{"$f":"1029.616*2","v":{"v":2059.232,"d":"2,059"}},"LF",null,0]
[null,6271005,"4\" WHITE BROKEN LINES(GAPS EXCL.)THERMOPLASTIC- 90 MIL.",{"$f":"D31","v":{"v":49.01914285714285,"d":"49"}},"LF",null,0]
[null,6271010,"4\" WHITE SOLID LINES (PVT. EDGE LINES) THERMO.- 90 MIL.",{"$f":"D32","v":{"v":36.319,"d":"36"}},"LF",null,0]
[null,6271015,"8\" WHITE SOLID LINES THERMOPLASTIC - 125 MIL.",{"v":294.429,"d":"294"},"LF",null,0]
[null,6271025,"24\" WHITE SOLID LINES (STOP/DIAG LINES)-THERMO.-125 MIL",128,"LF",null,0]
[null,6271030,"WHITE SINGLE ARROWS (LT, STRGHT, RT) THERMO.-125 MIL.",1,"EA  ",null,0]
[null,6271040,"WHITE COMBINATION ARROWS(STR&RT.OR STR&LT)THERMO-125MIL",1,"EA  ",null,0]
[null,6271074,"4\" YELLOW SOLID LINES(PVT.EDGE LINES) THERMO-90 MIL.",{"v":2059.232,"d":"2,059"},"LF",null,0]
[null,6301100,"PERMANENT YELLOWPAVEMENT MARKERS BI-DIR. -4\"X4\"",13,"EA",null,0]
[null,6510105,"FLAT SHEET,TYPE III,FIXED SIZE",{"$f":"9+9+5+5+6.25+2.67+1.89*3","v":{"v":42.59,"d":"43"}},"SF",null,0]
[null,6531210,"U-SECTION POST FOR SIGN SUPPORTS - 3P",{"$f":"14*6","v":84},"LF",null,0]
[null,6650900,"FURNISH & INSTALL ELECTRICAL SERVICE CONNECTIONS",1,"EA",null,0]
[null,6651091,"SINGLE DECORATIVE LIGHT POLE WITH SINGLE LIGHT",14,"EA",null,0]
[null,"6750213","2.0\" SCHEDULE 40 PVC CONDUIT",5537,"LF",null,0]
[null,"6750224","4.0\" SCHEDULE 40 PVC CONDUIT",842,"LF",null,0]
[null,"675027Y","FURNISH & INSTALL 4.0\" SCHD 80 PVC CONDUIT(DIRECTION BORED)",100,"LF",null,0]
[null,6760020,"2\" SCHEDULE 80 HDPE CONDUIT",1435,"LF",null,0]
[null,6770319,"NO. 8 COPPER WIRE, 1 CONDUCTOR, 600V,TYPE RHH,RHW,USE",6005,"LF",null,0]
[null,6770413,"FURNISH & INSTL NO. 14 COPPER WIRE,1-CONDUCTOR FOR LOOP WIRE",204,"LF",null,0]
[null,6780495,"SAWCUT FOR LOOP DETECTOR",204,"LF",null,0]
[null,6800530,"17\"X30\"X28\"D.ELEC.FLUSH UNDGRD.ENCLOSURE-(STR.POLY.CONC.)HD",2,"EA",null,0]
[null,6885993,"TEMPORARY ADJUSTMENT OF TRAFFIC SIGNAL EQUIPMENT",1,"EA",null,0]
[null,6888110,"INSTALL STREET LIGHT LUMINAIRE",14,"EA",null,0]
[null,7143618,"18\" SMOOTH WALL PIPE",176,"LF  ",null,0]
[null,7143642,"42\" SMOOTH WALL PIPE",12,"LF",null,0]
[null,7143648,"48\" SMOOTH WALL PIPE",576,"LF",null,0]
[null,7192021,"DROP INLET (24\" X 36\") WITH STANDARD 4' X 4' BOX",8,"EA  ",null,0]
[null,7192108,"MANHOLE WITH STANDARD 5' X 5' BOX",1,"EA",null,0]
[null,7196000,"EXTRA DEPTH OF BOX",41,"LF",null,0]
[null,7204100,"CONCRETE SIDEWALK (4\" UNIFORM)",{"$f":"8861.7265/9","v":{"v":984.6362777777779,"d":"985"}},"SY",null,0]
[null,7204900,"DETECTABLE WARNING MATERIAL",{"v":25.38,"d":"25"},"SF  ",null,0]
[null,7209000,"PEDESTRIAN RAMP CONSTRUCTION",{"$f":"135.5718/9","v":{"v":15.063533333333332,"d":"15"}},"SY",null,0]
[null,8041020,"RIP-RAP (CLASS B)",63,"TON",null,0]
[null,8048210,"GEOTEXTILE FOR EROSION CONTROL UNDER RIPRAP(CLASS 2)TYPE C",84,"SY",null,0]
[null,8091010,"RIGHT OF WAY MARKER (REBAR AND CAP)",2,"EA",null,0]
[null,8091050,"RIGHT OF WAY PLAT",1,"LS  ",null,{"$f":"D72*F72","v":0}]
[null,8100100,"PERMANENT COVER",{"v":0.6723,"d":"0.67"},"ACRE",null,0]
[null,8100200,"TEMPORARY COVER",{"$f":"D73/2","v":{"v":0.33615,"d":"0.34"}},"ACRE",null,0]
[null,8101105,"COMPOST",181,"CY",null,0]
[null,8104005,"FERTILIZER (NITROGEN)",{"$f":"0.1*1000*$D$73","v":{"v":67.23,"d":"67"}},"LB",null,0]
[null,8104010,"FERTILIZER (PHOSPHORIC ACID)",{"$f":"0.1*1000*$D$73","v":{"v":67.23,"d":"67"}},"LB",null,0]
[null,8104015,"FERTILIZER (POTASH)",{"$f":"0.1*1000*$D$73","v":{"v":67.23,"d":"67"}},"LB",null,0]
[null,8105005,"AGRICULTURAL GRANULAR LIME",{"$f":"2000*$D$73","v":{"v":1344.6,"d":"1,345"}},"LB",null,0]
[null,8109050,"SELECTIVE WATERING",54300,"GAL",null,0]
[null,8109901,"MOWING",{"$f":"(SUM(D73:D74))*2","v":{"v":2.0169,"d":"2"}},"ACRE",null,0]
[null,8110001,"LANDSCAPING",1,"LS  ",null,0]
[null,8152004,"INLET STRUCTURE FILTER - TYPE F (WEIGHTED)",{"$f":"(8*26)","v":208},"LF",null,0]
[null,8152006,"INLET STRUCTURE FILTER- TYPE F (NON-WEIGHTED)",{"$f":"(8*26)","v":208},"LF",null,0]
[null,8153000,"SILT FENCE",{"v":2502.87,"d":"2,503"},"LF",null,0]
[null,8153090,"REPLACE/REPAIR SILT FENCE",{"$f":"D85*0.1","v":{"v":250.287,"d":"250"}},"LF",null,0]
[null,8154050,"REMOVAL OF SILT RETAINED BY SILT FENCE",{"$f":"D85*0.25","v":{"v":625.7175,"d":"626"}},"LF",null,0]
[null,8156200,"CLEANING INLET STRUCTURE FILTERS",{"v":16,"d":"16.00"},"EA",null,0]
[null,8156490,"STABILIZED CONSTRUCTION ENTRANCE",550,"SY",null,0]
[null,null,"ELECTRICAL & COMMUNICATIONS SERVICE CONVERSIONS (OVERHEAD TO UNDERGROUND)",18,"EA",null,0]
[null,null,"* RED FONT INDICATIVE OF REVISION",null,null,"TOTAL",{"$f":"SUM(G6:G90)","v":0}]
[]
[null,"***Invitation for Bid (IFB) signature page must be signed and submitted with the above Schedule of Values Bid Form to verify the total bid amount as indicated herein, is inclusive of all costs, including all labor, supervision, materials, supplies, equipment, taxes, insurance, permits and any other costs incidental or otherwise.***"]
[]
[]
[]
[null,"*Grey shaded cells indicate locked cells"]