{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Program","Program.a","Scope","Assumptions","PAVEMENT - REMOVAL","PAVEMENT - NEW","EXCAVATION","STRUCTURE","CABLE & BEAM GUARD","TMP","RISK_OPPORTUNITY","Real Estate Costs","JT Costs","Comp. Utilities","\"Brains\"Parameters"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":71,"comments":7,"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":"Program","index":0,"n_rows":173,"n_cols":9,"rows_kept":173,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,3,2,5],[13,2,13,5],[3,3,3,5],[7,3,7,5],[1,3,1,5],[6,3,6,5],[12,4,12,5],[1,1,7,1],[4,3,4,5],[23,6,23,7],[38,6,38,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[50,6,50,7],[51,6,51,7],[49,6,49,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[27,6,27,7],[25,6,25,7],[24,6,24,7],[26,6,26,7],[17,6,17,7],[135,6,135,7],[136,6,136,7],[137,6,137,7],[74,6,74,7],[52,6,52,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[113,6,113,7],[114,6,114,7],[115,6,115,7],[118,6,118,7],[117,6,117,7],[119,6,119,7],[129,6,129,7],[130,6,130,7],[112,6,112,7],[116,6,116,7],[172,6,172,7],[161,6,161,7],[162,6,162,7],[163,6,163,7],[164,6,164,7],[166,6,166,7],[170,6,170,7],[168,6,168,7],[139,6,139,7],[141,6,141,7],[169,6,169,7],[159,6,159,7],[160,6,160,7],[167,6,167,7],[149,6,149,7],[142,6,142,7],[148,6,148,7],[171,6,171,7],[146,6,146,7],[132,6,132,7],[133,6,133,7],[131,6,131,7],[101,6,101,7],[102,6,102,7],[103,6,103,7],[104,6,104,7],[165,6,165,7],[143,6,143,7],[144,6,144,7],[120,6,120,7],[107,6,107,7],[108,6,108,7],[109,6,109,7],[110,6,110,7],[105,6,105,7],[106,6,106,7],[138,6,138,7],[123,6,123,7],[124,6,124,7],[122,6,122,7],[83,6,83,7],[84,6,84,7],[85,6,85,7],[72,6,72,7],[73,6,73,7],[99,6,99,7],[100,6,100,7],[86,6,86,7],[87,6,87,7],[88,6,88,7],[89,6,89,7],[90,6,90,7],[91,6,91,7],[93,6,93,7],[94,6,94,7],[95,6,95,7],[96,6,96,7],[97,6,97,7],[98,6,98,7]]}
[null,"Wisconsin Department of Transportation"]
[null,"SHR/3R & Backbone                \nConceptual Total Cost \nEstimate SUMMARY                        \nVersion 2.4","Project I.D. ",null,null,null,"Today:",{"$f":"NOW()","v":"2017-01-06T15:29:07.900"},"Insert"]
[null,null,"Highway",null,null,null,null,null,"CY"]
[null,null,"Project Title",null,null,null,null,null,"EACH"]
[null,null,"Project Limits"]
[null,null,"Project Length",null,null,null,null,null,"SF"]
[null,null,"County",null,null,null,null,null,"LS"]
[null,null,"AADT",null,null,null,null,null,"LF"]
[]
[null,null,"Project Duration",{"$f":"IF((F12-F11)=1,\"Single Year\",IF((F12-F11)>1,\"Multi-Year\",IF((F12-F11)<0,\"Error: Check Dates\",\"\")))","v":""},null,null,null,null,"GAL"]
[null,null,"Current Year ",null,"Start Construction",null,null,null,"SY"]
[null,null,"Start Preliminary Design",null,"End Construction",null,null,null,"TON"]
[null,"Project Scope","Alternative #:"]
[null,"Project Assumptions "]
[null,"ITEM DESCRIPTION","UNIT","QUANTITY","UNIT PRICE in","Total","NOTES"]
[null,null,null,null,{"$f":"IF(D11>1,D11,\"\")","v":""}]
["ITEM","MAJOR ROADWAY ITEMS","Bid Express Inst.","Estimator Inst."]
[null,"REMOVING PAVEMENT (see PAVEMENT - REMOVAL tab)"]
[204.01,"REMOVING PAVEMENT","SY",{"$f":"+'PAVEMENT - REMOVAL'!H91","v":0},0,{"$f":"ROUND(D19*E19,-3)","v":0}]
[204.012,"REMOVING ASPHALTIC SURFACE MILLING","TON",{"$f":"+'PAVEMENT - REMOVAL'!C25","v":0},0,{"$f":"ROUND(D20*E20,-3)","v":0}]
[330.01,"MILL AND RELAY","TON",{"$f":"+'PAVEMENT - REMOVAL'!C48","v":0},0,0]
[335.01,"RUBBLIZING","SY",{"$f":"+'PAVEMENT - REMOVAL'!H110","v":0},0,0]
[416.09050000000002,"CONCRETE CONTINUOUS DIAMOND GRINDING","TON",{"$f":"+'PAVEMENT - REMOVAL'!C71","v":0},0,0]
[null,"EARTH WORK (see EXCAVATION tab)"]
[205.01,"COMMON","CY",{"$f":"+EXCAVATION!K16","v":0},0,0]
[205.02,"ROCK","CY",{"$f":"+EXCAVATION!K36","v":0},0,0]
[205.04,"MARSH","CY",{"$f":"+EXCAVATION!K56","v":0},0,0]
[208.01,"BORROW","CY",{"$f":"+EXCAVATION!K76","v":0},0,0]
[null,"CURB & GUTTER, SIDEWALK (see PAVEMENT - NEW tab)"]
[null,"CURB & GUTTER, SIDEWALK (see PAVEMENT REMOVAL Tab)"]
[204.01499999999999,"REMOVING CURB AND GUTTER","LF",{"$f":"+'PAVEMENT - REMOVAL'!D128","v":0},0,0]
[601.02049999999997,"CONCRETE GUTTER 24-INCH ","LF",{"$f":"'PAVEMENT - NEW'!D163","v":0},0,{"$f":"ROUND(D32*E32,-3)","v":0}]
[601.04070000000002,"CONCRETE CURB & GUTTER 18-INCH TYPE D ","LF",{"$f":"'PAVEMENT - NEW'!D146","v":0},0,{"$f":"ROUND(D33*E33,-3)","v":0}]
[601.04110000000003,"CONCRETE CURB & GUTTER 30-INCH TYPE D","LF",{"$f":"'PAVEMENT - NEW'!D180","v":0},0,0]
[204.0155,"REMOVING CONCRETE SIDEWALK","SY",{"$f":"+'PAVEMENT - REMOVAL'!F147","v":0},0,{"$f":"ROUND(D35*E35,-3)","v":0}]
[602.04049999999995,"CONCRETE SIDEWALK 4-INCH","SF",{"$f":"'PAVEMENT - NEW'!G197","v":0},0,0]
[602.04100000000005,"CONCRETE SIDEWALK 5-INCH","SF",{"$f":"'PAVEMENT - NEW'!G214","v":0},0,0]
[602.04150000000004,"CONCRETE SIDEWALK 6-INCH","SF",{"$f":"'PAVEMENT - NEW'!G231","v":0},0,{"$f":"ROUND(D38*E38,-3)","v":0}]
[null,"CONCRETE PAVEMENT (see PAVEMENT - NEW tab)"]
[415.00799999999998,"CONCRETE PAVEMENT 8-INCH","SY",{"$f":"'PAVEMENT - NEW'!H63","v":0},0,{"$f":"D40*E40","v":0}]
[415.00900000000001,"CONCRETE PAVEMENT 9-INCH","SY",{"$f":"'PAVEMENT - NEW'!H92","v":0},0,0]
[415.01,"CONCRETE PAVEMENT 10-INCH","SY",{"$f":"'PAVEMENT - NEW'!H110","v":0},0,0]
[415.012,"CONCRETE PAVEMENT 12-INCH","SY",{"$f":"'PAVEMENT - NEW'!H128","v":0},0,0]
[390.03030000000001,"BASE PATCHING CONCRETE","SY",{"$f":"'PAVEMENT - NEW'!N238","v":0},0,0]
[null,"ASPHALT PAVEMENT (see PAVEMENT - NEW tab)"]
[455.06049999999999,"TACK COAT","GAL",{"$f":"+'PAVEMENT - NEW'!N12","v":0},0,0]
[460.52229999999997,"HMA PAVEMENT 3 LT58-28 S ","TON",{"$f":"'PAVEMENT - NEW'!C19","v":0},0,0]
[460.5224,"HMA PAVEMENT 4 LT58-28 S ","TON",{"$f":"'PAVEMENT - NEW'!C32","v":0},0,0]
[460.52249999999998,"HMA PAVEMENT 5 LT58-28 S ","TON",{"$f":"'PAVEMENT - NEW'!C45","v":0},0,0]
[null,"BASE (see PAVEMENT - NEW tab)"]
[305.01100000000002,"BASE AGGREGATE DENSE 3/4 INCH (For Shoulders if mill is less than laid depth)","TON",{"$f":"'PAVEMENT - NEW'!K284","v":0},0,{"$f":"D51*E51","v":0}]
[305.012,"BASE AGGREGATE DENSE 1-1/4 INCH","TON",{"$f":"'PAVEMENT - NEW'!C273","v":0},0,{"$f":"D52*E52","v":0}]
[311.01100000000002,"SUBBASE- BREAKER RUN/SELECT","TON",{"$f":"'PAVEMENT - NEW'!M296","v":0},0,{"$f":"D53*E53","v":0}]
[645.02200000000005,"GEOGRID TYPE SR","SY",{"$f":"'PAVEMENT - NEW'!F315","v":0},0,{"$f":"D54*E54","v":0}]
[645.024,"GEOGRID TYPE MR","SY",{"$f":"'PAVEMENT - NEW'!F333","v":0},0,0]
[645.02599999999995,"GEOGRID TYPE SSR","SY",{"$f":"'PAVEMENT - NEW'!F351","v":0},0,0]
[null,"BARRIER WALL, CABLE, BEAM GUARD (see CABLE & BEAM GUARD tab)"]
[204.01650000000001,"REMOVING GUARDRAIL","LF",{"$f":"+'CABLE & BEAM GUARD'!D18:E18","v":0},0,{"$f":"ROUND(D58*E58,-3)","v":0}]
[null,"LENGTH OF 4-STRAND HT CABLE","LF",{"$f":"'CABLE & BEAM GUARD'!F18","v":0},0,{"$f":"ROUND(D59*E59,-3)","v":0}]
[null,"LENGTH OF 3-STRAND HT CABLE","LF",{"$f":"'CABLE & BEAM GUARD'!H18","v":0},0,{"$f":"ROUND(D60*E60,-3)","v":0}]
[null,"4-STRAND TERMINALS","EACH",{"$f":"'CABLE & BEAM GUARD'!J18","v":0},0,{"$f":"ROUND(D61*E61,-3)","v":0}]
[null,"3-STRAND TERMINALS","EACH",{"$f":"'CABLE & BEAM GUARD'!L18","v":0},0,{"$f":"ROUND(D62*E62,-3)","v":0}]
[603.01049999999998,"CONCRETE BARRIER SINGLE-FACED 32-INCH","LF",{"$f":"+'CABLE & BEAM GUARD'!P38","v":0},0,{"$f":"ROUND(D63*E63,-3)","v":0}]
[603.02049999999997,"CONCRETE BARRIER DOUBLE-FACED 32-INCH","LF",{"$f":"+'CABLE & BEAM GUARD'!P39","v":0},0,0]
[603.04049999999995,"CONCRETE BARRIER TRANSITION SECTION 32-INCH","LF",{"$f":"+'CABLE & BEAM GUARD'!P40","v":0},0,0]
[603.11360000000002,"CONCRETE BARRIER TYPE S36 (NEW JERSEY BARRIER)","LF",{"$f":"+'CABLE & BEAM GUARD'!P41","v":0},0,0]
[603.11419999999998,"CONCRETE BARRIER TYPE S42 (NEW JERSEY BARRIER)","LF",{"$f":"+'CABLE & BEAM GUARD'!P42","v":0},0,0]
[603.31129999999996,"CONCRETE BARRIER TRANSITION TYPE NJ32SF TO S36 (NEW JERSEY BARRIER)","EACH",{"$f":"+'CABLE & BEAM GUARD'!P43","v":0},0,0]
[614.23,"MSG GUARDRAIL 3","LF",{"$f":"'CABLE & BEAM GUARD'!F33","v":0},0,{"$f":"ROUND(D69*E69,-3)","v":0}]
[614.25,"MGS THRIE BEAM TRANSITION","LF",{"$f":"'CABLE & BEAM GUARD'!H33","v":0},0,{"$f":"ROUND(D70*E70,-3)","v":0}]
[614.26099999999997,"MSG GUARDRAIL TERMINAL EAT","EACH",{"$f":"'CABLE & BEAM GUARD'!J33","v":0},0,{"$f":"ROUND(D71*E71,-3)","v":0}]
[614.26199999999994,"MSG GUARDRAIL TERMINAL TYPE 2","EACH",{"$f":"'CABLE & BEAM GUARD'!L33","v":0},0,{"$f":"ROUND(D72*E72,-3)","v":0}]
[]
[null,"Major Roadway Item Subtotal (MRS)",null,null,null,{"$f":"SUM(F19:F73)","v":0}]
[]
[null,"ALLOWANCE ITEMS"]
[null,"DRAINAGE",null,"% of MRS",{"$f":"IF(((F32+F33+F34)/F74)>0.01,'\"Brains\"Parameters'!C3,'\"Brains\"Parameters'!B3)","v":{"$error":"#DIV/0!"}},{"$f":"E77*F74","v":{"$error":"#DIV/0!"}}]
[null,"EROSION CONTROL & RESTORATION",null,"% of MRS",{"$f":"IF(((F33+F34+F32)/F74)>0.01,'\"Brains\"Parameters'!C4,'\"Brains\"Parameters'!B4)","v":{"$error":"#DIV/0!"}},{"$f":"E78*F74","v":{"$error":"#DIV/0!"}}]
[null,"SIGNALS/LIGHTING",null,"% of MRS",{"$f":"IF(((F34+F32+F33)/F74)>0.01,'\"Brains\"Parameters'!C5,'\"Brains\"Parameters'!B5)","v":{"$error":"#DIV/0!"}},{"$f":"E79*F74","v":{"$error":"#DIV/0!"}}]
[null,"ROADWAY INCIDENTALS",null,"% of MRS",{"$f":"IF(((F32+F33+F34)/F74)>0.01,'\"Brains\"Parameters'!C6,'\"Brains\"Parameters'!B6)","v":{"$error":"#DIV/0!"}},{"$f":"E80*F74","v":{"$error":"#DIV/0!"}}]
[null,"SIGNING/MARKING",null,"% of MRS",{"$f":"IF(((F33+F34+F32)/F74)>0.01,'\"Brains\"Parameters'!C7,'\"Brains\"Parameters'!B7)","v":{"$error":"#DIV/0!"}},{"$f":"E81*F74","v":{"$error":"#DIV/0!"}}]
[null,"TRAFFIC CONTROL & STAGING",null,"% of MRS",{"$f":"IF(((F33+F34+F32)/F74)>0.01,'\"Brains\"Parameters'!C8,'\"Brains\"Parameters'!B8)","v":{"$error":"#DIV/0!"}},{"$f":"E82*F74","v":{"$error":"#DIV/0!"}}]
[null,"ITS/FTMS",null,"% of MRS",{"$f":"IF(((F33+F34+F32)/F74)>0.01,'\"Brains\"Parameters'!C9,'\"Brains\"Parameters'!B9)","v":{"$error":"#DIV/0!"}},{"$f":"E83*F74","v":{"$error":"#DIV/0!"}}]
[]
[null,"Allowance Subtotal",null,null,null,{"$f":"SUM(F77:F84)","v":{"$error":"#DIV/0!"}}]
[]
[null,"STRUCTURES (see STRUCTURE tab)","UNIT","QUANTITY","UNIT PRICE","Total","NOTES"]
[null,"BRIDGE REMOVAL","SF",{"$f":"STRUCTURE!D58","v":0},0,{"$f":"ROUND(D88*E88,-3)","v":0}]
[null,"NEW BRIDGE (SINGLE LEVEL I/C)","SF",{"$f":"STRUCTURE!E58","v":0},0,0]
[null,"NEW BRIDGE (MULTI LEVEL I/C)","SF",{"$f":"STRUCTURE!F58","v":0},0,0]
[null,"OVERLAYS","SF",{"$f":"STRUCTURE!G58","v":0},0,0]
[null,"RE-DECK","SF",{"$f":"STRUCTURE!H58","v":0},0,0]
[null,"STRUCTURE WIDENING","SF",{"$f":"STRUCTURE!O58","v":0},0,0]
[null,"PAINTING","SF",{"$f":"STRUCTURE!I58","v":0},0,0]
[null,"NEW BOX CULVERT / EXTENSION","LF",{"$f":"STRUCTURE!J58","v":0},0,0]
[null,"CULVERT REPAIR","SF",{"$f":"STRUCTURE!K58","v":0},0,0]
[null,"SIGN BRIDGE CANTELEVER","LF",{"$f":"STRUCTURE!L58","v":0},0,0]
[null,"MSE Walls","LF",{"$f":"STRUCTURE!M58","v":0},0,0]
[null,"Secant Walls","SF",{"$f":"+STRUCTURE!N58","v":0},0,0]
[null,"Pipe Culvert Extension","LF",{"$f":"STRUCTURE!P58","v":0},0,0]
[null,"    Structure Incidentals",null,"% of Structures",0.1,{"$f":"ROUND(E101*SUM(F88:F100),-3)","v":0}]
[null,"Structure Subtotal",null,null,null,{"$f":"SUM(F88:F101)","v":0}]
[]
[null,"TRAFFIC MANAGEMENT PLAN (see TMP tab)","UNIT","QUANTITY","UNIT PRICE","Total","NOTES"]
[null,"   Temporary Bridges ","Insert",0,0,{"$f":"ROUND(D105*E105,-3)","v":0}]
[null,"   Temporary Pavements","LF",0,0,0]
[null,"   Detours & Bypass/Alternate Routes","Insert",0,0,0]
[null,"   Other","Insert",0,0,0]
[null,"   Other","Insert",0,0,0]
[null,"   Other","Insert",0,0,0]
[null,"Traffic Management Plan Subtotal",null,null,null,{"$f":"SUM(F105:F110)","v":0}]
[]
[null,"SPECIAL CONSTRUCTION ELEMENTS","UNIT","QUANTITY","UNIT PRICE","Total","NOTES"]
[null,"   Environment Mitigation","Insert",0,0,{"$f":"ROUND(D114*E114,-3)","v":0}]
[null,"   Community Sensitive Design ","Insert",0,0,{"$f":"ROUND(D115*E115,-3)","v":0}]
[null,"   Hazardous Materials","Insert",0,0,{"$f":"ROUND(D116*E116,-3)","v":0}]
[null,"   TOIPs","Insert",0,0,{"$f":"ROUND(D117*E117,-3)","v":0}]
[null,"   Salt Storage Facilities","Insert",0,0,0]
[null,"   Permanent Traffic Control Items","EACH",0,0,0]
[null,"   DNR","Insert",0,0,0]
[null,"   Coordination with Tribes","Insert",0,0,0]
[null,"   Existing Culverts","EACH",0,0,0]
[null,"   Temporary Bridge Shoring","EACH",0,0,0]
[null,"Aesthetic Treatments","EACH",0,0,0]
[null,"Special Construction Elements Subtotal",null,null,null,{"$f":"SUM(F114:F124)","v":0}]
[]
[null," Construction Cost Estimate (CCE)",null,null,null,{"$f":"SUM(F74,F85,F102,F111,F125)","v":{"$error":"#DIV/0!"}}]
[]
[null,"MOBILIZATION",null,null,{"$f":"IF(((F31+F34)/F74)>0.01,'\"Brains\"Parameters'!C10,'\"Brains\"Parameters'!B10)","v":{"$error":"#DIV/0!"}},{"$f":"E129*(F127)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Base Construction Costs Estimate (BCCE) ",null,null,null,{"$f":"F127+F129","v":{"$error":"#DIV/0!"}}]
[]
[null,"SCOPE CHANGE ALLOWANCE ITEMS"]
[null,"PROJECT INCREASE ALLOWANCE",null,"% of Item BCCE",0.15,{"$f":"E134*F131","v":{"$error":"#DIV/0!"}}]
[]
[null,"ESTIMATE UNCERTAINTY"]
[null,"Uncertainty Item A",null,null,0,{"$f":"E137","v":0}]
[null,"Uncertainty Item B",null,null,0,{"$f":"E138","v":0}]
[null,"Uncertainty Item C",null,null,0,{"$f":"E139","v":0}]
[null,"Uncertainty Adjustment Subtotal",null,null,null,{"$f":"SUM(F137:F139)","v":0}]
[]
[null,"RISK AND OPPORTUNITY ADJUSTMENTS",null,null,null,null,"NOTES"]
[null,"Risk/Opportunity Item A",null,null,0,{"$f":"E143","v":0}]
[null,"Risk/Opportunity Item B",null,null,0,{"$f":"E144","v":0}]
[null,"Risk/Opportunity Item C",null,null,0,{"$f":"E145","v":0}]
[null,"Risk and Opportunity Adjustment Subtotal",null,null,null,{"$f":"SUM(F143:F145)","v":0}]
[]
[]
[null,"Estimated  Const. Let  Amount (ECLA) ",null,null,null,{"$f":"F131+F134+F140+F146","v":{"$error":"#DIV/0!"}},"report to BB Statewide Program Manager Or 3R Regional Program Manager"]
[null,"ECLA With Delivery Costs",null,null,null,{"$f":"F159+F149","v":{"$error":"#DIV/0!"}}]
[]
[null,"PROJECT DELIVERY ALLOWANCE ITEMS"]
[null,"DESIGN ENGINEERING",null,"% of ECLA",{"$f":"IF(((F30+F33)/F73)>0.01,'\"Brains\"Parameters'!C19,'\"Brains\"Parameters'!B19)","v":{"$error":"#DIV/0!"}},{"$f":"E153*$F$149","v":{"$error":"#DIV/0!"}}]
[null,"CONSTRUCTION ENGINEERING",null,"% of ECLA",{"$f":"IF(((F31+F34)/F74)>0.01,'\"Brains\"Parameters'!C20,'\"Brains\"Parameters'!B20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"CONST CHANGE ORDERS & CLAIMS ",null,"% of ECLA",{"$f":"IF(((F31+F34)/F74)>0.01,'\"Brains\"Parameters'!C21,'\"Brains\"Parameters'!B21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"TRAFFIC MITIGATION",null,"% of ECLA",{"$f":"IF(((F31+F34)/F74)>0.01,'\"Brains\"Parameters'!C22,'\"Brains\"Parameters'!B22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"PUBLIC INVOLVEMENT",null,"% of ECLA",{"$f":"IF(((F31+F34)/F74)>0.01,'\"Brains\"Parameters'!C23,'\"Brains\"Parameters'!B23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"PROJECT SCOPE INCREASE ALLOWANCE",null,"% of ECLA",{"$f":"IF(((F31+F34)/F74)>0.01,'\"Brains\"Parameters'!C24,'\"Brains\"Parameters'!B24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Delivery Allowance Subtotal",null,null,null,{"$f":"SUM(F153:F157)","v":{"$error":"#DIV/0!"}}]
[]
[null,"EXTERNAL COSTS"]
[null,"REAL ESTATE",null,null,0,{"$f":"E162","v":0}]
[null,"COMPENSABLE UTILITIES",null,null,0,0]
[null,"JURISDICTIONAL TRANSFERS ",null,null,0,0]
[null,"UTILITY NONCOMPENSABLE",null,null,0,0]
[null,"LOCAL COST-SHARE ENHANCEMENTS",null,null,0,0]
[null,"Other",null,null,0,0]
[null,"Other",null,null,0,0]
[null,"Other",null,null,0,0]
[null,"External Costs Subtotal",null,null,null,{"$f":"SUM(F162:F169)","v":0}]
[]
[]
[null,"Current Year  Total Project Cost Estimate",null,null,null,{"$f":"F170+F150","v":{"$error":"#DIV/0!"}}]

{"sheet":"Program.a","index":1,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,123527125.99000014]
[]
[]
[]
[]
[]
[]
[null,"1900-05-19"]

{"sheet":"Scope","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[6,0,26,1],[5,0,5,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["Project Scope"]

{"sheet":"Assumptions","index":3,"n_rows":83,"n_cols":1,"rows_kept":83,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["Project Assumptions "]
["# OF LANES"]
["DETOUR/OPEN"]
["ALIGNMENT"]
["RELOCATION ON ALIGN."]
["COMPLEXITY OF DRAINAGE"]
[1]
[{"$f":"1+A12","v":2}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[{"$f":"1+A72","v":62}]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]

{"sheet":"PAVEMENT - REMOVAL","index":4,"n_rows":147,"n_cols":11,"rows_kept":147,"cut":false,"hidden":false,"merged":[[5,0,5,2],[5,8,5,9],[28,4,28,5],[28,6,28,7],[28,8,28,9],[6,4,6,5],[6,6,6,7],[6,8,6,9],[5,6,5,7],[28,0,28,2],[5,4,5,5],[52,8,52,9],[29,4,29,5],[29,6,29,7],[29,8,29,9],[51,4,51,5],[51,6,51,7],[52,6,52,7],[52,4,52,5],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[79,8,79,11],[76,8,78,11],[51,8,51,9],[130,0,130,2],[112,0,112,2],[74,4,74,5],[74,6,74,7],[94,4,94,5],[94,6,94,7],[93,0,93,2],[93,4,93,5],[93,6,93,7],[74,0,74,2],[75,4,75,5],[75,6,75,7],[51,0,51,2]]}
["Wisconsin Department of Transportation"]
[{"$f":"+Program!D2","v":0}]
[{"$f":"+Program!D3","v":0}]
[{"$f":"+Program!D4","v":0}]
[{"$f":"+Program!D8","v":0}]
["Area Estimates \nREMOVING ASPHALTIC SURFACE MILLING",null,null,null,"PAVED WIDTH (ft)",null,"HMA DEPTH (in)",null,"AREA (sy)",null,"MILLING"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR","LANES","SHLDR","TONS"]
[0,null,0,{"$f":"C8-A8","v":0},0,0,0,0,{"$f":"(D8*E8)/9","v":0},{"$f":"(F8*D8)/9","v":0},{"$f":"+(I8*118*G8/2000)+(J8*118*H8/2000)","v":0}]
[0,null,0,0,0,0,0,0,{"$f":"(D9*E9)/9","v":0},{"$f":"(F9*D9)/9","v":0},{"$f":"+(I9*118*G9/2000)+(J9*118*H9/2000)","v":0}]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,{"$f":"C11-A11","v":0},0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I8:I20)","v":0},null,{"$f":"SUM(K8:K20)","v":0}]
[null,null,null,null,null,null,null,"TOTAL S.Y.",null,{"$f":"+I21+J21","v":0}]
[]
["Milling Tons=",null,{"$f":"+K21","v":0}]
[null,null,{"$f":"+ROUNDUP(C24,-1)","v":0},"TONS"]
["Milling S.Y.",null,{"$f":"+J22","v":0},"S.Y."]
[]
[]
["Area Estimates \nMILLING AND RELAY",null,null,null,"PAVED WIDTH (ft)",null,"HMA DEPTH (in)",null,"AREA (sy)",null,"MILLING"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR","LANES","SHLDR","TONS"]
[0,null,0,{"$f":"C31-A31","v":0},0,0,0,0,{"$f":"(D31*E31)/9","v":0},{"$f":"(F31*D31)/9","v":0},{"$f":"+(I31*118*G31/2000)+(J31*118*H31/2000)","v":0}]
[0,null,0,{"$f":"C32-A32","v":0},0,0,0,0,0,0,{"$f":"+(I32*118*G32/2000)+(J32*118*H32/2000)","v":0}]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I31:I43)","v":0},{"$f":"SUM(J31:J43)","v":0},{"$f":"SUM(K31:K43)","v":0}]
[null,null,null,null,null,null,null,"TOTAL S.Y.",null,{"$f":"+I44+J44","v":0}]
[]
["Milling Tons=",null,{"$f":"+K44","v":0}]
[null,null,{"$f":"+ROUNDUP(C47,-1)","v":0},"TONS"]
["Milling S.Y.",null,{"$f":"+J45","v":0},"S.Y."]
[]
[]
["DIAMOND GRINDING",null,null,null,"PAVED WIDTH (ft)",null,"HMA DEPTH (in)",null,"AREA (sy)",null,"MILLING"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR","LANES","SHLDR","TONS"]
[0,null,0,{"$f":"C54-A54","v":0},0,0,0,0,{"$f":"(D54*E54)/9","v":0},{"$f":"(F54*D54)/9","v":0},{"$f":"+(I54*118*G54/2000)+(J54*118*H54/2000)","v":0}]
[0,null,0,{"$f":"C55-A55","v":0},0,0,0,0,0,0,{"$f":"+(I55*118*G55/2000)+(J55*118*H55/2000)","v":0}]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I66)","v":0},{"$f":"SUM(J54:J66)","v":0},{"$f":"SUM(K54:K66)","v":0}]
[null,null,null,null,null,null,null,"TOTAL S.Y.",null,{"$f":"+I67+J67","v":0}]
[]
[" (Tons)=",null,{"$f":"+K67","v":0}]
[null,null,{"$f":"+ROUNDUP(C70,-1)","v":0},"TONS"]
[" (S.Y.)",null,{"$f":"+J68","v":0},"S.Y."]
[]
[]
["REMOVING CONCRETE PAVEMENT",null,null,null,"PAVED WIDTH",null,"AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR"]
[0,null,0,{"$f":"C77-A77","v":0},0,0,{"$f":"+D77*E77/9","v":0},{"$f":"+D77*F77/9","v":0},"Assumptions:\n"]
[0,null,0,{"$f":"C78-A78","v":0},0,0,0,0]
[0,null,0,{"$f":"C79-A79","v":0},0,0,0,0]
[0,null,0,{"$f":"C80-A80","v":0},0,0,0,0,"Assumptions: \n-Based on 2:1 backslope and 3' curb, additional 22' added for base and 16' for subbase to proposed paved surface width"]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G77:G89)","v":0},{"$f":"SUM(H77:H89)","v":0}]
[null,null,null,null,null,"TOTAL S.Y.",null,{"$f":"+G90+H90","v":0}]
[]
[]
["RUBBLIZING",null,null,null,"PAVED WIDTH",null,"AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR"]
[0,null,0,{"$f":"C96-A96","v":0},0,0,{"$f":"+D96*E96/9","v":0},{"$f":"+D96*F96/9","v":0}]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G96:G108)","v":0},{"$f":"SUM(H96:H108)","v":0}]
[null,null,null,null,null,"TOTAL S.Y.",null,{"$f":"+G109+H109","v":0}]
[]
[]
["REMOVING CURB & GUTTER",null,null,null,"NOTES:"]
["STA","TO","STA","Length (ft)"]
[0,null,0,{"$f":"C115-A115","v":0}]
[0,null,0,{"$f":"C116-A116","v":0}]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[null,null,null,{"$f":"SUM(D115:D127)","v":0}]
[]
[]
["REMOVING CONCRETE SIDEWALK",null,null,null,"PAVED WALK\nWIDTH","AREA (sy)"]
["STA","TO","STA","Length (ft)","FT","LANES"]
[0,null,0,{"$f":"C133-A133","v":0},0,{"$f":"+D133*E133/9","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F133:F145)","v":0}]
[null,null,null,null,"TOTAL S.Y.",{"$f":"+ROUND(F146,-2)","v":0}]

{"sheet":"PAVEMENT - NEW","index":5,"n_rows":351,"n_cols":16,"rows_kept":351,"cut":false,"hidden":false,"merged":[[335,0,335,2],[198,0,198,2],[215,0,215,2],[147,0,147,2],[299,0,299,2],[317,0,317,2],[6,0,6,2],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,12,7,15],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[20,6,20,7],[20,8,20,9],[46,0,46,2],[46,4,46,5],[46,6,46,7],[33,0,33,2],[33,4,33,5],[33,6,33,7],[33,8,33,9],[20,0,20,2],[20,4,20,5],[64,0,64,2],[64,4,64,5],[64,6,64,7],[93,0,93,2],[93,4,93,5],[93,6,93,7],[285,9,285,10],[111,0,111,2],[111,4,111,5],[111,6,111,7],[234,0,234,2],[260,0,260,2],[260,4,260,5],[276,0,276,2],[285,0,285,2],[285,5,285,6],[276,4,276,5],[181,0,181,2],[164,0,164,2],[130,0,130,2]]}
["Wisconsin Department of Transportation"]
[{"$f":"+Program!D2","v":0}]
[{"$f":"+Program!D3","v":0}]
[{"$f":"+Program!D4","v":0}]
[{"$f":"+Program!D8","v":0}]
["NOTE: User may modify the HMA type to reflect the anticipated type of HMA to be used on the project"]
["ASPHALT PAVEMENT\n3 LT 58-28",null,null,null,"PAVED WIDTH (ft)",null,"HMA DEPTH (in)",null,"AREA (sy)",null,"HMA TONS",null,"TACK COAT"]
["STA","TO","STA","Length (ft)","LANES","SHLDR","LANES","SHLDR","LANES","SHLDR"]
[0,null,0,{"$f":"(C9-A9)*100","v":0},0,0,0,0,{"$f":"(D9*E9)/9","v":0},{"$f":"(F9*D9)/9","v":0},{"$f":"+(I9*118*G9/2000)+(J9*118*H9/2000)","v":0},null,"TOTAL HMA SQ. YDS.",null,null,{"$f":"I16+J16+I29+J29","v":0}]
[0,null,0,{"$f":"(C10-A10)*100","v":0},0,0,0,0,0,{"$f":"(F10*D10)/9","v":0},{"$f":"+(I10*118*G10/2000)+(J10*118*H10/2000)","v":0},null,".025 PER SQ. YD",null,null,{"$f":"P9*0.025","v":0}]
[0,null,0,0,0,0,0,0,0,{"$f":"(F11*D11)/9","v":0},{"$f":"+(I11*118*G11/2000)+(J11*118*H11/2000)","v":0}]
[0,null,0,0,0,0,0,0,0,{"$f":"(F12*D12)/9","v":0},{"$f":"+(I12*118*G12/2000)+(J12*118*H12/2000)","v":0},null,"TOTAL ",{"$f":"P10","v":0},"GAL"]
[0,null,0,0,0,0,0,0,0,{"$f":"(F13*D13)/9","v":0},{"$f":"+(I13*118*G13/2000)+(J13*118*H13/2000)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I8:I15)","v":0},{"$f":"SUM(J8:J15)","v":0},{"$f":"SUM(K8:K15)","v":0}]
[]
["HMA=",null,{"$f":"+K16","v":0}]
[null,null,{"$f":"+ROUNDUP(C18,-1)","v":0},"tons of HMA"]
[]
["ASPHALT PAVEMENT\n4 LT 58-28",null,null,null,"PAVED WIDTH (ft)",null,"HMA DEPTH (in)",null,"AREA (sy)",null,"HMA TONS"]
["STA","TO","STA","Length (ft)","LANES","SHLDR","LANES","SHLDR","LANES","SHLDR"]
[0,null,0,{"$f":"(C23-A23)*100","v":0},0,0,0,0,{"$f":"(D23*E23)/9","v":0},{"$f":"(F23*D23)/9","v":0},{"$f":"+(I23*118*G23/2000)+(J23*118*H23/2000)","v":0}]
[0,null,0,{"$f":"(C24-A24)*100","v":0},0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I23:I28)","v":0},{"$f":"SUM(J23:J28)","v":0},{"$f":"SUM(K23:K28)","v":0}]
[]
["HMA=",null,{"$f":"+K29","v":0}]
[null,null,{"$f":"+ROUNDUP(C31,-1)","v":0},"tons of HMA"]
[]
["ASPHALT PAVEMENT\n5 LT 58-28",null,null,null,"PAVED WIDTH (ft)",null,"HMA DEPTH (in)",null,"AREA (sy)",null,"HMA TONS"]
["STA","TO","STA","Length (ft)","LANES","SHLDR","LANES","SHLDR","LANES","SHLDR"]
[0,null,0,{"$f":"(C36-A36)*100","v":0},0,0,0,0,{"$f":"(D36*E36)/9","v":0},{"$f":"(F36*D36)/9","v":0},{"$f":"+(I36*118*G36/2000)+(J36*118*H36/2000)","v":0}]
[0,null,0,{"$f":"(C37-A37)*100","v":0},0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I36:I41)","v":0},{"$f":"SUM(J36:J41)","v":0},{"$f":"SUM(K36:K41)","v":0}]
[]
["HMA=",null,{"$f":"+K42","v":0}]
[null,null,{"$f":"+ROUNDUP(C44,-1)","v":0},"tons of HMA"]
[]
["CONCRETE PAVEMENT 8-INCH",null,null,null,"PAVED WIDTH (ft)",null,"AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR"]
[0,null,0,{"$f":"C49-A49","v":0},0,0,{"$f":"+D49*E49/9","v":0},{"$f":"D49*F49/9","v":0}]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,{"$f":"+D54*E54/9","v":0},0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G49:G61)","v":0},{"$f":"SUM(H49:H61)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G62+H62","v":0}]
[]
["CONCRETE PAVEMENT 9-INCH",null,null,null,"PAVED WIDTH (ft)",null,"AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR"]
[0,null,0,{"$f":"C67-A67","v":0},0,28,{"$f":"+D67*E67/9","v":0},{"$f":"D67*F67/9","v":0}]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,{"$f":"C78-A78","v":0},0,0,0,{"$f":"D78*F78/9","v":0}]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,{"$f":"C84-A84","v":0},0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,{"$f":"D88*F88/9","v":0}]
[0,null,0,0,0,0,0,{"$f":"D89*F89/9","v":0}]
[0,null,0,0,0,0,0,{"$f":"D90*F90/9","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H67:H90)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G91+H91","v":0}]
[]
["CONCRETE PAVEMENT 10-INCH",null,null,null,"PAVED WIDTH (ft)",null,"AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR"]
[0,null,0,{"$f":"C96-A96","v":0},0,0,{"$f":"+D96*E96/9","v":0},{"$f":"D96*F96/9","v":0}]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G96:G108)","v":0},{"$f":"SUM(H96:H108)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G109+H109","v":0}]
[]
["CONCRETE PAVEMENT 12-INCH",null,null,null,"PAVED WIDTH (ft)",null,"AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","LANES","SHLDR"]
[0,null,0,{"$f":"C114-A114","v":0},0,0,{"$f":"+D114*E114/9","v":0},{"$f":"D114*F114/9","v":0}]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G114:G126)","v":0},{"$f":"SUM(H114:H126)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G127+H127","v":0}]
[]
[]
["18\" CURB & GUTTER TYPE D",null,null,null,"NOTES:"]
["STA","TO","STA","Length (ft)"]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,{"$f":"C136-A136","v":0}]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[null,null,null,{"$f":"SUM(D133:D145)","v":0}]
[]
["24\" CURB & GUTTER",null,null,null,"NOTES:"]
["STA","TO","STA","Length (ft)"]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,{"$f":"C153-A153","v":0}]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[null,null,null,{"$f":"SUM(D150:D162)","v":0}]
[]
["30\" CURB & GUTTER",null,null,null,"NOTES:"]
["STA","TO","STA","Length (ft)"]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,{"$f":"C170-A170","v":0}]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[0,null,0,0]
[null,null,null,{"$f":"SUM(D167:D179)","v":0}]
[]
["CONCRETE SIDEWALK\n4 INCH",null,null,null,"NOTES:","SIDEWALK \nWIDTH","AREA"]
["STA","TO","STA","Length (ft)",null,"FT","(SF)"]
[0,null,0,{"$f":"C184-A184","v":0},null,0,0]
[0,null,0,{"$f":"C185-A185","v":0},null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,{"$f":"D187*F187","v":0}]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[null,null,null,{"$f":"SUM(D184:D195)","v":0},null,null,{"$f":"SUM(G184:G195)","v":0}]
[null,null,null,null,null,null,{"$f":"G196","v":0}]
[]
["CONCRETE SIDEWALK\n5 INCH",null,null,null,"NOTES:","SIDEWALK \nWIDTH","AREA"]
["STA","TO","STA","Length (ft)",null,"FT","(SF)"]
[0,null,0,{"$f":"C201-A201","v":0},null,0,0]
[0,null,0,{"$f":"C202-A202","v":0},null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,{"$f":"D204*F204","v":0}]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[null,null,null,{"$f":"SUM(D201:D212)","v":0},null,null,{"$f":"SUM(G201:G212)","v":0}]
[null,null,null,null,null,null,{"$f":"G213","v":0}]
[]
["CONCRETE SIDEWALK\n6 INCH",null,null,null,"NOTES:","SIDEWALK \nWIDTH","AREA"]
["STA","TO","STA","Length (ft)",null,"FT","(SF)"]
[0,null,0,{"$f":"C218-A218","v":0},null,0,0]
[0,null,0,{"$f":"C219-A219","v":0},null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,{"$f":"D221*F221","v":0}]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[0,null,0,0,null,0,0]
[null,null,null,{"$f":"SUM(D218:D229)","v":0},null,null,{"$f":"SUM(G218:G229)","v":0}]
[null,null,null,null,null,null,{"$f":"G230","v":0}]
[]
["CABC IS BROKEN INTO PAVEMENT AREA AND SHOULDER AREA"]
[]
["CABC (PAVEMENT BASE)",null,null,null,"CABC LANES","DEPTH","AREA","VOLUME",null,null,"BASE PATCHING "]
["Station ","to","Station","Length (ft)","WIDTH (ft)","CABC (in)","LANES (sf)","(cf)","TONS",null,"Total SY of pavement",null,null,{"$f":"+'PAVEMENT - REMOVAL'!J22+'PAVEMENT - REMOVAL'!J68","v":0},"SY"]
[null,null,null,{"$f":"C237-A237","v":0},null,6,null,{"$f":"+G237*F237/12","v":0},{"$f":"+(H237/27)*2","v":0},null,"% of Total SY",null,0,{"$f":"M237*N236","v":0},"SY"]
[null,null,null,0,null,6,null,{"$f":"+G238*F238/12","v":0},{"$f":"+(H238/27)*2","v":0},null,"Base Patching Conc.",null,null,{"$f":"ROUNDUP(N237,-3)","v":0},"SY"]
[null,null,null,0,null,6,null,{"$f":"+G239*F239/12","v":0},{"$f":"+(H239/27)*2","v":0}]
[null,null,null,0,null,6,null,{"$f":"+G240*F240/12","v":0},{"$f":"+(H240/27)*2","v":0}]
[null,null,null,0,null,6,null,{"$f":"+G241*F241/12","v":0},{"$f":"+(H241/27)*2","v":0}]
[null,null,null,0,null,6,null,{"$f":"+G242*F242/12","v":0},{"$f":"+(H242/27)*2","v":0}]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,{"$f":"+G251*F251/12","v":0},0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,0,null,6,null,0,0]
[null,null,null,{"$f":"C254-A254","v":0},null,6,null,0,0]
[null,null,null,{"$f":"C255-A255","v":0},null,6,null,0,0]
[null,null,null,{"$f":"C256-A256","v":0},null,6,null,{"$f":"+G256*F256/12","v":0},{"$f":"+(H256/27)*2","v":0}]
[null,null,null,{"$f":"C257-A257","v":0},null,6,null,{"$f":"+G257*F257/12","v":0},{"$f":"+(H257/27)*2","v":0}]
[null,null,null,{"$f":"C258-A258","v":0},null,6,null,{"$f":"+G258*F258/12","v":0},{"$f":"+(H258/27)*2","v":0}]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I237:I258)","v":0}]
[]
["CABC (SHOULDER BASE)",null,null,null,"CABC SHOULDERS",null,"AVG.","DEPTH","AREA","VOLUME"]
["Station ","to","Station","Length (ft)","TOP WIDTH (ft)","SUBG WIDTH (ft)","WIDTH (ft)","CABC (in)","SHLDRS (sf)","(cf)","TONS"]
[null,null,null,{"$f":"C263-A263","v":0},null,null,null,6,{"$f":"+D263*G263","v":0},{"$f":"+I263*H263/12","v":0},{"$f":"+(J263/27)*2","v":0}]
[null,null,null,0,null,null,null,6,{"$f":"+D264*G264","v":0},0,0]
[null,null,null,0,null,null,null,6,{"$f":"+D265*G265","v":0},0,0]
[null,null,null,0,null,null,null,6,{"$f":"+D266*G266","v":0},0,0]
[null,null,null,0,null,null,null,6,{"$f":"+D267*G267","v":0},0,0]
[null,null,null,0,null,null,null,6,0,0,0]
[null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(K263:K268)","v":0}]
[]
[]
["TOTAL CABC",null,{"$f":"+I259+K269","v":0},"TONS"]
[null,null,{"$f":"+ROUNDUP(C272,-1)","v":0}]
[]
[]
[]
["SHOULDER BASE 3/4-INCH",null,null,null,"CABC SHOULDERS",null,"AVG.","DEPTH","AREA","VOLUME","TONS"]
["Station ","to","Station","Length (ft)","TOP WIDTH (ft)","SUBG WIDTH (ft)","WIDTH (ft)","CABC (in)","SHLDRS (sf)","(cf)"]
[null,null,null,{"$f":"C279-A279","v":0},null,null,{"$f":"+(E279+F279)/2","v":0},6,{"$f":"+D279*G279","v":0},{"$f":"+I279*H279/12","v":0},{"$f":"+(J279/27)*2","v":0}]
[null,null,null,{"$f":"C280-A280","v":0},null,null,{"$f":"+(E280+F280)/2","v":0},6,{"$f":"+D280*G280","v":0},{"$f":"+I280*H280/12","v":0},{"$f":"+(J280/27)*2","v":0}]
[null,null,null,{"$f":"C281-A281","v":0},null,null,{"$f":"+(E281+F281)/2","v":0},6,{"$f":"+D281*G281","v":0},{"$f":"+I281*H281/12","v":0},{"$f":"+(J281/27)*2","v":0}]
[null,null,null,{"$f":"C282-A282","v":0},null,null,{"$f":"+(E282+F282)/2","v":0},6,{"$f":"+D282*G282","v":0},{"$f":"+I282*H282/12","v":0},{"$f":"+(J282/27)*2","v":0}]
[null,null,null,{"$f":"C283-A283","v":0},null,null,{"$f":"+(E283+F283)/2","v":0},6,{"$f":"+D283*G283","v":0},{"$f":"+I283*H283/12","v":0},{"$f":"+(J283/27)*2","v":0}]
[null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(K279:K283)","v":0}]
[]
["SUBBASE for PAVEMENT AREA AND SHOULDER AREA",null,null,null,"CABC LANES","CABC SHOULDERS",null,"AVG.Shoulder","DEPTH","AREA",null,"VOLUME"]
["Station ","to","Station","Length (ft)","WIDTH (ft)","TOP WIDTH (ft)","SUBG WIDTH (ft)","WIDTH (ft)","CABC (in)","LANES (sf)","SHLDRS (sf)","(cf)","TONS"]
[0,null,0,{"$f":"C288-A288","v":0},0,0,0,{"$f":"+(F288+G288)/2","v":0},16,{"$f":"+D288*E288","v":0},{"$f":"+D288*H288","v":0},{"$f":"+((J288+K288)*I288)/12","v":0},{"$f":"+(L288/27)*2","v":0}]
[0,null,0,{"$f":"C289-A289","v":0},0,0,0,0,16,{"$f":"+D289*E289","v":0},{"$f":"+D289*H289","v":0},0,0]
[0,null,0,0,0,0,0,0,0,{"$f":"+D290*I290","v":0},{"$f":"+F290*I290","v":0},0,0]
[0,null,0,0,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0,0,0]
[0,null,0,{"$f":"C295-A295","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(M288:M295)","v":0}]
[]
[]
[]
["GEOGRID TYPE SR",null,null,null,"PAVED WIDTH (ft)","AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","LANES"]
[0,null,0,{"$f":"C302-A302","v":0},0,{"$f":"+C302*D302/9","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F302:F314)","v":0}]
[]
[]
["GEOGRID TYPE MR",null,null,null,"PAVED WIDTH (ft)","AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","LANES"]
[0,null,0,{"$f":"C320-A320","v":0},0,{"$f":"+C320*D320/9","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F320:F332)","v":0}]
[]
[]
["GEOGRID TYPE SSR",null,null,null,"PAVED WIDTH (ft)","AREA (sy)"]
["STA","TO","STA","Length (ft)","LANES","LANES"]
[0,null,0,{"$f":"C338-A338","v":0},0,{"$f":"+C338*D338/9","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F338:F350)","v":0}]

{"sheet":"EXCAVATION","index":6,"n_rows":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,4,12],[38,0,38,2],[38,4,38,5],[38,8,38,9],[58,0,58,2],[58,4,58,5],[58,8,58,9],[5,0,5,2],[5,4,5,5],[5,8,5,9],[18,0,18,2],[18,4,18,5],[18,8,18,9]]}
["Wisconsin Department of Transportation"]
[{"$f":"+Program!D2","v":0}]
[{"$f":"+Program!D3","v":0}]
[{"$f":"+Program!D4","v":0}]
[{"$f":"+Program!D8","v":0}]
["EXCAVATION\nCOMMON",null,null,null,"ROADWAY WIDTH (ft)",null,null,"DEPTH","AREA",null,"TOTAL"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","TOTAL","(ft)","LANES","SHLDR","(cy)"]
[null,null,null,{"$f":"C8-A8","v":0},null,null,{"$f":"SUM(E8:F8)","v":0},null,{"$f":"(D8*E8)/9","v":0},{"$f":"(F8*D8)/9","v":0},{"$f":"+(D8*G8*H8)/27","v":0}]
[null,null,null,{"$f":"C9-A9","v":0},null,null,{"$f":"SUM(E9:F9)","v":0},null,{"$f":"(D9*E9)/9","v":0},{"$f":"(F9*D9)/9","v":0},{"$f":"+(D9*G9*H9)/27","v":0}]
[null,null,null,{"$f":"C10-A10","v":0},null,null,{"$f":"SUM(E10:F10)","v":0},null,{"$f":"(D10*E10)/9","v":0},{"$f":"(F10*D10)/9","v":0},{"$f":"+(D10*G10*H10)/27","v":0}]
[]
[]
[null,null,null,{"$f":"C13-A13","v":0},0,0,{"$f":"SUM(E13:F13)","v":0},0,{"$f":"(D13*E13)/9","v":0},{"$f":"(F13*D13)/9","v":0},{"$f":"+(D13*G13*H13)/27","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I8:I13)","v":0},{"$f":"SUM(J8:J13)","v":0},{"$f":"SUM(K8:K13)","v":0}]
[null,null,null,null,null,null,null,null,"C.Y. Excavation",null,{"$f":"+K14","v":0}]
[null,null,null,null,null,null,null,null,"or",null,{"$f":"+ROUNDUP(K15,-2)","v":0}]
[]
[]
["EXCAVATION\nROCK",null,null,null,"ROADWAY WIDTH (ft)",null,null,"DEPTH","AREA",null,"TOTAL"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","TOTAL","(ft)","LANES","SHLDR","(cy)"]
[0,null,0,{"$f":"C21-A21","v":0},0,0,{"$f":"SUM(E21:F21)","v":0},0,{"$f":"(D21*E21)/9","v":0},{"$f":"(F21*D21)/9","v":0},{"$f":"+(D21*G21*H21)/27","v":0}]
[0,null,0,{"$f":"C22-A22","v":0},0,0,{"$f":"SUM(E22:F22)","v":0},0,0,0,0]
[0,null,0,0,0,0,{"$f":"SUM(E23:F23)","v":0},0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I33)","v":0},{"$f":"SUM(J21:J33)","v":0},{"$f":"SUM(K21:K33)","v":0}]
[null,null,null,null,null,null,null,null,"C.Y. Excavation",null,{"$f":"+K34","v":0}]
[null,null,null,null,null,null,null,null,"or",null,{"$f":"+ROUNDUP(K35,-2)","v":0}]
[]
[]
["EXCAVATION\nMARSH",null,null,null,"ROADWAY WIDTH (ft)",null,null,"DEPTH","AREA",null,"TOTAL"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","TOTAL","(ft)","LANES","SHLDR","(cy)"]
[0,null,0,{"$f":"C41-A41","v":0},0,0,{"$f":"SUM(E41:F41)","v":0},0,{"$f":"(D41*E41)/9","v":0},{"$f":"(F41*D41)/9","v":0},{"$f":"+(D41*G41*H41)/27","v":0}]
[0,null,0,{"$f":"C42-A42","v":0},0,0,{"$f":"SUM(E42:F42)","v":0},0,0,0,0]
[0,null,0,0,0,0,{"$f":"SUM(E43:F43)","v":0},0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I41:I53)","v":0},{"$f":"SUM(J41:J53)","v":0},{"$f":"SUM(K41:K53)","v":0}]
[null,null,null,null,null,null,null,null,"C.Y. Excavation",null,{"$f":"+K54","v":0}]
[null,null,null,null,null,null,null,null,"or",null,{"$f":"+ROUNDUP(K55,-2)","v":0}]
[]
[]
["EXCAVATION\nBORROW",null,null,null,"ROADWAY WIDTH (ft)",null,null,"DEPTH","AREA",null,"TOTAL"]
["STA","TO","STA","Length (ft)","LANES","SHLDRS","TOTAL","(ft)","LANES","SHLDR","(cy)"]
[0,null,0,{"$f":"C61-A61","v":0},0,0,{"$f":"SUM(E61:F61)","v":0},0,{"$f":"(D61*E61)/9","v":0},{"$f":"(F61*D61)/9","v":0},{"$f":"+(D61*G61*H61)/27","v":0}]
[0,null,0,{"$f":"C62-A62","v":0},0,0,{"$f":"SUM(E62:F62)","v":0},0,0,0,0]
[0,null,0,0,0,0,{"$f":"SUM(E63:F63)","v":0},0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[0,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I73)","v":0},{"$f":"SUM(J61:J73)","v":0},{"$f":"SUM(K61:K73)","v":0}]
[null,null,null,null,null,null,null,null,"C.Y. Excavation",null,{"$f":"+K74","v":0}]
[null,null,null,null,null,null,null,null,"or",null,{"$f":"+ROUNDUP(K75,-2)","v":0}]

{"sheet":"STRUCTURE","index":7,"n_rows":156,"n_cols":16,"rows_kept":156,"cut":false,"hidden":false,"merged":[[142,0,143,5],[107,0,107,8],[124,0,124,8],[88,0,88,2],[88,6,88,8],[89,6,89,8],[0,0,0,18],[28,0,28,2],[90,0,90,8],[60,0,60,2],[60,5,60,7],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[37,0,37,2],[57,0,57,2]]}
["Wisconsin Department of Transportation"]
[{"$f":"+Program!D2","v":0}]
[{"$f":"+Program!D3","v":0}]
[{"$f":"+Program!D4","v":0}]
[{"$f":"+Program!D8","v":0}]
["ITEM DESCRIPTION","Number","SEGMENT","BRIDGE REMOVAL","NEW BRIDGE (SINGLE LEVEL I/C)","NEW BRIDGE (MULTI LEVEL I/C)","OVERLAYS","RE-DECK","PAINTING","NEW BOX CULVERT / EXTENSION","CULVERT REPAIR","SIGN BRIDGE CANTELEVER","MSE Walls","Secant Walls","Structure Widening","Pipe Culvert Extension"]
[null,null,null,"SF","SF","SF","SF","SF","SF","LF",null,"EACH","SF","SF","SF","LF"]
["MAINLINE & SYSTEM RAMPS"]
["B-XX-XXXX",null,null,0]
["B-XX-XXXX",null,null,0]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["MAINLINE & SYSTEM RAMPS TOTALS",null,null,{"$f":"SUM(D9:D19)","v":0},{"$f":"SUM(E9:E19)","v":0},0,{"$f":"SUM(G9:G19)","v":0},{"$f":"SUM(H9:H19)","v":0},{"$f":"SUM(I9:I19)","v":0},0,{"$f":"SUM(K9:K19)","v":0},0,0,0,{"$f":"SUM(O9:O19)","v":0},0]
[]
["SERVICE RAMPS"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["SERVICE RAMPS TOTALS",null,null,{"$f":"SUM(D23:D28)","v":0},{"$f":"SUM(E23:E28)","v":0},0,{"$f":"SUM(G23:G28)","v":0},{"$f":"SUM(H23:H28)","v":0},{"$f":"SUM(I23:I28)","v":0},0,0,0,0,0,{"$f":"SUM(O23:O28)","v":0},0]
[]
["CROSSROAD"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["CROSSROAD TOTALS",null,null,{"$f":"SUM(D31:D37)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M31:M37)","v":0},{"$f":"SUM(N31:N37)","v":0},{"$f":"SUM(O31:O37)","v":0},{"$f":"SUM(P31:P37)","v":0}]
[]
["FRONTAGE ROADS"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["FRONTAGE ROADS TOTALS",null,null,{"$f":"SUM(D40:D46)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M40:M46)","v":0},{"$f":"SUM(N40:N46)","v":0},{"$f":"SUM(O40:O46)","v":0},{"$f":"SUM(P40:P46)","v":0}]
[]
["LOCAL ROADS"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["B-XX-XXXX"]
["LOCAL ROADS TOTALS",null,null,{"$f":"SUM(D49:D55)","v":0},0,0,null,null,null,0,null,0,{"$f":"SUM(M49:M55)","v":0},{"$f":"SUM(N49:N55)","v":0},{"$f":"SUM(O49:O55)","v":0},{"$f":"SUM(P49:P55)","v":0}]
[]
["GRAND TOTALS",null,null,{"$f":"SUM(D20,D29,D38,D47,D56)","v":0},{"$f":"SUM(E20,E29,E38,E47,E56)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O20,O29,O38,O47,O56)","v":0},0]
[]
[]
["REMOVING RETAINING WALL\n (LINEAR FOOT)",null,null,null,null,"REMOVING NOISE BARRIER\n (LINEAR FOOT)"]
["STA","TO","STA","Length (ft)",null,"STA","TO","STA","Length (ft)"]
[0,null,0,{"$f":"C63-A63","v":0},null,0,null,0,{"$f":"H63-F63","v":0}]
[0,null,0,{"$f":"C64-A64","v":0},null,0,null,0,{"$f":"H64-F64","v":0}]
[0,null,0,{"$f":"C65-A65","v":0},null,0,null,0,{"$f":"H65-F65","v":0}]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[0,null,0,0,null,0,null,0,0]
[]
[null,null,"TOTAL",{"$f":"SUM(D63:D84)","v":0},null,null,null,"TOTAL",{"$f":"SUM(I63:I84)","v":0}]
[]
[]
["NEW RETAINING WALL (SF)",null,null,null,null,"Total","NOTES:"]
["STA","TO","STA","Length (ft)","Height (ft)","Sq. ft"]
["RETAINING WALLS < 10 '"]
[0,null,0,{"$f":"C92-A92","v":0},0,{"$f":"D92*E92","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F92:F105)","v":0}]
[]
["RETAINING WALLS  10' TO 20'"]
[0,null,0,{"$f":"C109-A109","v":0},0,{"$f":"D109*E109","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F109:F122)","v":0}]
[]
["RETAINING WALLS >20 '"]
[0,null,0,{"$f":"C126-A126","v":0},0,{"$f":"D126*E126","v":0}]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[0,null,0,0,0,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F126:F137)","v":0}]
[]
[]
[]
["NOISE BARRIERS DS SOUND ABSORPTIVE "]
[null,null,null,null,null,null,"UNIT","SF QUANTITY","LF QUANTITY","NUMBER"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0001. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0002. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0003. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0004. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0005. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0006. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0007. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0008. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0009. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0010. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
["531.0300.S","NOISE BARRIERS DS SOUND ABSORPTIVE 0011. ",null,null,null,null,"SF/LF",null,null,"N-XX-XXX"]
[null,null,null,null,null,null,null,{"$f":"SUM(H145:H155)","v":0},{"$f":"SUM(I145:I155)","v":0},"TOTAL"]

{"sheet":"CABLE & BEAM GUARD","index":8,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,5,35,13],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[29,3,29,4],[32,3,32,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[29,9,29,10],[29,11,29,12],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[17,3,17,4],[21,3,21,4],[22,3,22,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[9,7,9,8],[9,9,9,10],[23,3,23,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[17,5,17,6],[17,7,17,8],[17,9,17,10],[23,5,23,6],[23,7,23,8],[23,9,23,10],[8,11,8,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,4,12],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,11,9,12],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[9,5,9,6],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[12,11,12,12],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[17,11,17,12],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[23,11,23,12],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,5,29,6],[29,7,29,8]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["CABLE GUARD"]
["ITEM DESCRIPTION","DESCRIPTION","SEGMENT","REMOVAL",null,"LENGTH OF 4-STRAND HT CABLE",null,"LENGTH OF 3-STRAND HT CABLE",null,"4-STRAND TERMINALS",null,"3-STRAND TERMINALS"]
["MAINLINE",null,null,"LF",null,"LF",null,"LF",null,"EACH",null,"EACH"]
[1.01,null,null,0,null,0,null,0,null,0,null,0]
[1.02,null,null,0,null,0,null,0,null,0,null,0]
[1.03,null,null,0,null,0,null,0,null,0,null,0]
[1.04,null,null,0,null,0,null,0,null,0,null,0]
[1.05,null,null,0,null,0,null,0,null,0,null,0]
[1.06,null,null,0,null,0,null,0,null,0,null,0]
["MAINLINE TOTAL",null,null,{"$f":"SUM(D9:D14)","v":0},null,{"$f":"SUM(F9:F14)","v":0},null,{"$f":"SUM(H9:H14)","v":0},null,{"$f":"SUM(J9:J14)","v":0},null,{"$f":"SUM(L9:L14)","v":0}]
[]
[]
["GRAND TOTALS",null,null,{"$f":"SUM(D15)","v":0},null,{"$f":"SUM(F15)","v":0},null,{"$f":"SUM(H15)","v":0},null,{"$f":"SUM(J15)","v":0},null,{"$f":"SUM(L15)","v":0}]
[]
[]
["BEAM GUARD"]
["ITEM DESCRIPTION","DESCRIPTION","SEGMENT","REMOVAL",null,"MSG GUARDRAIL 3",null,"MGS THRIE BEAM TRANSITION",null,"MSG GUARDRAIL TERMINAL EAT",null,"MSG GUARDRAIL TERMINAL TYPE 2"]
["MAINLINE",null,null,"LF",null,"LF",null,"LF",null,"EACH",null,"EACH"]
[null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0]
[1.03,null,null,0,null,0,null,0,null,0,null,0]
[1.04,null,null,0,null,0,null,0,null,0,null,0]
[1.05,null,null,0,null,0,null,0,null,0,null,0]
[1.06,null,null,0,null,0,null,0,null,0,null,0]
["MAINLINE TOTAL",null,null,{"$f":"SUM(D24:D29)","v":0},null,{"$f":"SUM(F24:F29)","v":0},null,{"$f":"SUM(H24:H29)","v":0},null,{"$f":"SUM(J24:J29)","v":0},null,{"$f":"SUM(L24:L29)","v":0}]
[]
[]
["GRAND TOTALS",null,null,{"$f":"SUM(D30)","v":0},null,{"$f":"SUM(F30)","v":0},null,{"$f":"SUM(H30)","v":0},null,{"$f":"SUM(J30)","v":0},null,{"$f":"SUM(L30)","v":0}]
[]
[]
["CONCRETE BARRIER","DESCRIPTION","SEGMENT","REMOVAL",null,"NEW BARRIER TYPE",null,null,null,null,null,null,null,null,null,"QUANTITY"]
[null,null,null,"LF",null,null,null,null,null,null,null,null,null,null,"UNIT"]
[603.01049999999998,null,null,0,null,"CONCRETE BARRIER SINGLE-FACED 32-INCH",null,null,null,null,null,null,null,null,"LF",0]
[603.02049999999997,null,null,0,null,"CONCRETE BARRIER DOUBLE-FACED 32-INCH",null,null,null,null,null,null,null,null,"LF",0]
[603.04049999999995,null,null,0,null,"CONCRETE BARRIER TRANSITION SECTION 32-INCH",null,null,null,null,null,null,null,null,"LF",0]
[603.11360000000002,null,null,0,null,"CONCRETE BARRIER TYPE S36 (NEW JERSEY BARRIER)",null,null,null,null,null,null,null,null,"LF",0]
[603.11419999999998,null,null,0,null,"CONCRETE BARRIER TYPE S42 (NEW JERSEY BARRIER)",null,null,null,null,null,null,null,null,"LF",0]
[603.31129999999996,null,null,0,null,"CONCRETE BARRIER TRANSITION TYPE NJ32SF TO S36 (NEW JERSEY BARRIER)",null,null,null,null,null,null,null,null,"EA",0]

{"sheet":"TMP","index":9,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,0,7,8],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["TMP Costs"]
[]
["Input project options for TMP including items, quantities and associated costs. Perferred option should be carried-over to the \"Program\" tab. "]

{"sheet":"RISK_OPPORTUNITY","index":10,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,0,7,9],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["RISK & OPPORTUNITY COSTS"]
[]
["Identify all of the project risks and opportunity costs. Review the probabilty of these occuring (options are a Monte Carlo simulation). Carry-over only those to the \"Program\" tab that analysis states should be part of the project estimate. "]

{"sheet":"Real Estate Costs","index":11,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["Real Estate Costs"]

{"sheet":"JT Costs","index":12,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["Jurisdictional Transfers"]

{"sheet":"Comp. Utilities","index":13,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13]]}
["Wisconsin Department of Transportation"]
[{"$f":"Program!D2","v":0}]
[{"$f":"Program!D3","v":0}]
[{"$f":"Program!D4","v":0}]
[{"$f":"Program!D8","v":0}]
["Compensable Utilities"]

{"sheet":"\"Brains\"Parameters","index":14,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,0,17,0]]}
[null,"CG ≤ 1%","CG > 1%"]
["Construction Allowance Factors","Set 1","Set 2"]
["DRAINAGE",8.1000000000000003E-2,0.127]
["EROSION CONTROL & RESTORATION",4.9000000000000002E-2,5.7000000000000002E-2]
["SIGNALS/LIGHTING",5.0999999999999997E-2,4.5999999999999999E-2]
["ROADWAY INCIDENTALS",0.125,0.122]
["SIGNING/MARKING",8.4000000000000005E-2,5.8000000000000003E-2]
["TRAFFIC CONTROL & STAGING",0.11,7.2999999999999995E-2]
["ITS/FTMS",8.0000000000000002E-3,5.0000000000000001E-3]
["MOBILIZATION",7.0999999999999994E-2,5.2999999999999999E-2]
[]
[]
[]
[]
[]
[]
["Project Delivery Allowance Factors","CG ≤ 1%","CG > 1%"]
[null,"Set 1","Set 2"]
["DESIGN ENGINEERING",0.14000000000000001,0.16999999999999998]
["CONSTRUCTION ENGINEERING",0.10166666666666668,0.11666666666666665]
["CONST CHANGE ORDERS & CLAIMS ",8.2500000000000004E-2,8.7500000000000008E-2]
["TRAFFIC MITIGATION",8.0000000000000002E-3,1.1333333333333334E-2]
["PUBLIC INVOLVEMENT",0.01,1.8749999999999999E-2]
["PROJECT SCOPE INCREASE ALLOWANCE",0.19999999999999998,0.23333333333333331]