{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Instructions","Total Project Summary","Alignment 1 Summary","Alignment 1 Calculation","Alignment 2  Summary","Alignment 2 Calculation","Alignment 3 Summary","Alignment 3 Calculation","Alignment 4 Summary","Alignment 4 Calculation","Alignment 5 Summary","Alignment 5 Calculation","Alignment 6 Summary","Alignment 6 Calculation","MOT Ranking Criteria","Field Data Collection","Item Checklist","Volume Matrix "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":15,"comments":13,"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":"Instructions","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,0,3,1],[14,0,14,1],[0,0,0,1],[1,0,2,1]]}
["Bristol District L&D Scoping Estimating Tool"]
["This is a tool dependent on quality engineering estimates of quantities.  This tool should NOT be used as a substitute for a field observation estimate.  The overall cost of a project can be modified by adjusting the itemized contingency percentages in the Summary Sheet.  Also, the Earthwork quantity formulas are conservative estimates.  If you have any questions regarding the estimating tool contact Chase Buchanan at 276-696-3251."]
[]
["Instructions for the Summary Sheet"]
[]
["1) ","Contingency % can be adjusted based on your comfort level with item quantity"]
["2) ","Unit prices can be adjusted.  Use current unit prices as a guide."]
["3) ","CEI % can be adjusted"]
["4) ","Add any additional items that are important to the estimate in Misc. Section"]
["5) ","All items in \"green\" are formulas that are locked"]
["6) ","Cells with RED tabs include comments for clarifications"]
["7) ","Staunton Bid-Tab Query is hyperlinked from the \"For Recent Bid History Click Link\" link at the top of the page"]
["8) ","PE or RW cost is not included in this estimate "]
[]
["Instructions for the Calculation Sheet"]
[]
["1) ","All Cells Highlighted \"Yellow\" requires data input"]
["2) ","All Cells in \"Green\" are formulas that are locked"]
["3) ","The \"Proposed Full Depth Roadway\" is hyperlinked to the Road Design Manual"]
["4) ","The \"Proposed Bridge\" is hyperlinked to Structure and Bridge Vol. V - Part 2 Geometrics"]
["5) ","Earthwork inputs will require field data"]
["6) ","Drainage Breaks is the number of times the water flow changes direction on the vertical alignment"]
["7) ","Mitigation input is for mitigation that will be included in Construction Only.  Most mitigation is included in PE Cost."]
["8) ","A preliminary pavement design should be used for pavement inputs "]
["9) ","MOT cost can be changed in the \"MOT Ranking Criteria\" Tab"]

{"sheet":"Total Project Summary","index":1,"n_rows":110,"n_cols":5,"rows_kept":110,"cut":false,"hidden":false,"merged":[[95,0,95,3],[97,0,97,4],[99,1,99,2],[64,0,64,4],[72,0,72,4],[77,0,77,4],[80,0,80,4],[93,0,93,3],[94,0,94,3],[60,0,60,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[8,0,8,4],[12,0,12,4],[21,0,21,4],[30,0,30,4],[40,0,40,4],[47,0,47,4],[53,0,53,4]]}
["Project :","0000-000-000"]
["UPC:","XXXXX"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:","Name"]
[]
["For Recent Bid History Click Link"]
[]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E96<=1000000,((E96-200000)*0.075)+20000,((E96-1000000)*0.05)+80000)","v":5000},{"$f":"C11*D11","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E96*0.015,-3)","v":0},{"$f":"C12*D12","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 1 Summary'!C15+'Alignment 2  Summary'!C15+'Alignment 3 Summary'!C15+'Alignment 4 Summary'!C15+'Alignment 5 Summary'!C15+'Alignment 6 Summary'!C15","v":0},20000,0]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 1 Summary'!C16+'Alignment 2  Summary'!C16+'Alignment 3 Summary'!C16+'Alignment 4 Summary'!C16+'Alignment 5 Summary'!C16+'Alignment 6 Summary'!C16","v":0},17,0]
["BORROW EXCAVATION","CY",{"$f":"'Alignment 1 Summary'!C17+'Alignment 2  Summary'!C17+'Alignment 3 Summary'!C17+'Alignment 4 Summary'!C17+'Alignment 5 Summary'!C17+'Alignment 6 Summary'!C17","v":0},15,0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"'Alignment 1 Summary'!C18+'Alignment 2  Summary'!C18+'Alignment 3 Summary'!C18+'Alignment 4 Summary'!C18+'Alignment 5 Summary'!C18+'Alignment 6 Summary'!C18","v":0},17,0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"'Alignment 1 Summary'!C19+'Alignment 2  Summary'!C19+'Alignment 3 Summary'!C19+'Alignment 4 Summary'!C19+'Alignment 5 Summary'!C19+'Alignment 6 Summary'!C19","v":0},20,0]
["DRY RIPRAP ","TONS",{"$f":"'Alignment 1 Summary'!C20+'Alignment 2  Summary'!C20+'Alignment 3 Summary'!C20+'Alignment 4 Summary'!C20+'Alignment 5 Summary'!C20+'Alignment 6 Summary'!C20","v":0},40,{"$f":"C19*D19","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E14:E19)","v":0}]
["Grading Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E22+'Alignment 2  Summary'!E22+'Alignment 3 Summary'!E22+'Alignment 4 Summary'!E22+'Alignment 5 Summary'!E22+'Alignment 6 Summary'!E22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 1 Summary'!C24+'Alignment 2  Summary'!C24+'Alignment 3 Summary'!C24+'Alignment 4 Summary'!C24+'Alignment 5 Summary'!C24+'Alignment 6 Summary'!C24","v":0},2500,{"$f":"C23*D23","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 1 Summary'!C25+'Alignment 2  Summary'!C25+'Alignment 3 Summary'!C25+'Alignment 4 Summary'!C25+'Alignment 5 Summary'!C25+'Alignment 6 Summary'!C25","v":0},125,0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 1 Summary'!C26+'Alignment 2  Summary'!C26+'Alignment 3 Summary'!C26+'Alignment 4 Summary'!C26+'Alignment 5 Summary'!C26+'Alignment 6 Summary'!C26","v":0},250,0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 1 Summary'!C27+'Alignment 2  Summary'!C27+'Alignment 3 Summary'!C27+'Alignment 4 Summary'!C27+'Alignment 5 Summary'!C27+'Alignment 6 Summary'!C27","v":0},300,0]
["DROP INLETS","EA",{"$f":"'Alignment 1 Summary'!C28+'Alignment 2  Summary'!C28+'Alignment 3 Summary'!C28+'Alignment 4 Summary'!C28+'Alignment 5 Summary'!C28+'Alignment 6 Summary'!C28","v":0},1000,0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 1 Summary'!C29+'Alignment 2  Summary'!C29+'Alignment 3 Summary'!C29+'Alignment 4 Summary'!C29+'Alignment 5 Summary'!C29+'Alignment 6 Summary'!C29","v":0},35,0]
["Sub-Total",null,null,null,{"$f":"SUM(E23:E28)","v":0}]
["Drainage Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E31+'Alignment 2  Summary'!E31+'Alignment 3 Summary'!E31+'Alignment 4 Summary'!E31+'Alignment 5 Summary'!E31+'Alignment 6 Summary'!E31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"'Alignment 1 Summary'!C33+'Alignment 2  Summary'!C33+'Alignment 3 Summary'!C33+'Alignment 4 Summary'!C33+'Alignment 5 Summary'!C33+'Alignment 6 Summary'!C33","v":0},110,{"$f":"C32*D32","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"'Alignment 1 Summary'!C34+'Alignment 2  Summary'!C34+'Alignment 3 Summary'!C34+'Alignment 4 Summary'!C34+'Alignment 5 Summary'!C34+'Alignment 6 Summary'!C34","v":0},100,0]
["BASE COURSE","TONS",{"$f":"'Alignment 1 Summary'!C35+'Alignment 2  Summary'!C35+'Alignment 3 Summary'!C35+'Alignment 4 Summary'!C35+'Alignment 5 Summary'!C35+'Alignment 6 Summary'!C35","v":0},90,0]
["SUBBASE COURSE","TONS",{"$f":"'Alignment 1 Summary'!C36+'Alignment 2  Summary'!C36+'Alignment 3 Summary'!C36+'Alignment 4 Summary'!C36+'Alignment 5 Summary'!C36+'Alignment 6 Summary'!C36","v":0},20,0]
["No.1 STONE","TONS",{"$f":"'Alignment 1 Summary'!C37+'Alignment 2  Summary'!C37+'Alignment 3 Summary'!C37+'Alignment 4 Summary'!C37+'Alignment 5 Summary'!C37+'Alignment 6 Summary'!C37","v":0},25,0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"'Alignment 1 Summary'!C38+'Alignment 2  Summary'!C38+'Alignment 3 Summary'!C38+'Alignment 4 Summary'!C38+'Alignment 5 Summary'!C38+'Alignment 6 Summary'!C38","v":0},10,0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"'Alignment 1 Summary'!C39+'Alignment 2  Summary'!C39+'Alignment 3 Summary'!C39+'Alignment 4 Summary'!C39+'Alignment 5 Summary'!C39+'Alignment 6 Summary'!C39","v":0},2,0]
["Sub-Total",null,null,null,{"$f":"SUM(E32:E38)","v":0}]
["Pavement Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E41+'Alignment 2  Summary'!E41+'Alignment 3 Summary'!E41+'Alignment 4 Summary'!E41+'Alignment 5 Summary'!E41+'Alignment 6 Summary'!E41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"'Alignment 1 Summary'!C43+'Alignment 2  Summary'!C43+'Alignment 3 Summary'!C43+'Alignment 4 Summary'!C43+'Alignment 5 Summary'!C43+'Alignment 6 Summary'!C43","v":0},400,{"$f":"C42*D42","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 1 Summary'!C44+'Alignment 2  Summary'!C44+'Alignment 3 Summary'!C44+'Alignment 4 Summary'!C44+'Alignment 5 Summary'!C44+'Alignment 6 Summary'!C44","v":0},2000,{"$f":"C43*D43","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 1 Summary'!C45+'Alignment 2  Summary'!C45+'Alignment 3 Summary'!C45+'Alignment 4 Summary'!C45+'Alignment 5 Summary'!C45+'Alignment 6 Summary'!C45","v":0},5000,0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 1 Summary'!C46+'Alignment 2  Summary'!C46+'Alignment 3 Summary'!C46+'Alignment 4 Summary'!C46+'Alignment 5 Summary'!C46+'Alignment 6 Summary'!C46","v":0},10000,0]
["Sub-Total",null,null,null,{"$f":"SUM(E42:E45)","v":0}]
["Incidental Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E48+'Alignment 2  Summary'!E48+'Alignment 3 Summary'!E48+'Alignment 4 Summary'!E48+'Alignment 5 Summary'!E48+'Alignment 6 Summary'!E48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"'Alignment 1 Summary'!D50+'Alignment 2  Summary'!D50+'Alignment 3 Summary'!D50+'Alignment 4 Summary'!D50+'Alignment 5 Summary'!D50+'Alignment 6 Summary'!D50","v":0},{"$f":"'Alignment 1 Summary'!E50+'Alignment 2  Summary'!E50+'Alignment 3 Summary'!E50+'Alignment 4 Summary'!E50+'Alignment 5 Summary'!E50+'Alignment 6 Summary'!E50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 1 Summary'!C51","v":0},2000,{"$f":"D50*C50","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 1 Summary'!C52+'Alignment 2  Summary'!C52+'Alignment 3 Summary'!C52+'Alignment 4 Summary'!C52+'Alignment 5 Summary'!C52+'Alignment 6 Summary'!C52","v":0},90,{"$f":"C51*D51","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E49:E51)","v":0}]
["Protective Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E54+'Alignment 2  Summary'!E54+'Alignment 3 Summary'!E54+'Alignment 4 Summary'!E54+'Alignment 5 Summary'!E54+'Alignment 6 Summary'!E54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA","-","-",{"$f":"'Alignment 1 Summary'!E56+'Alignment 2  Summary'!E56+'Alignment 3 Summary'!E56+'Alignment 4 Summary'!E56+'Alignment 5 Summary'!E56+'Alignment 6 Summary'!E56","v":0}]
["SEEDING ","LB",{"$f":"'Alignment 1 Summary'!C57+'Alignment 2  Summary'!C57+'Alignment 3 Summary'!C57+'Alignment 4 Summary'!C57+'Alignment 5 Summary'!C57+'Alignment 6 Summary'!C57","v":0},15,{"$f":"C56*D56","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 1 Summary'!C58+'Alignment 2  Summary'!C58+'Alignment 3 Summary'!C58+'Alignment 4 Summary'!C58+'Alignment 5 Summary'!C58+'Alignment 6 Summary'!C58","v":0},4,{"$f":"C57*D57","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 1 Summary'!C59+'Alignment 2  Summary'!C59+'Alignment 3 Summary'!C59+'Alignment 4 Summary'!C59+'Alignment 5 Summary'!C59+'Alignment 6 Summary'!C59","v":0},500,{"$f":"C58*D58","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E55:E58)","v":0}]
["E&S Control Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E61+'Alignment 2  Summary'!E61+'Alignment 3 Summary'!E61+'Alignment 4 Summary'!E61+'Alignment 5 Summary'!E61+'Alignment 6 Summary'!E61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 1 Summary'!C63+'Alignment 2  Summary'!C63+'Alignment 3 Summary'!C63+'Alignment 4 Summary'!C63+'Alignment 5 Summary'!C63+'Alignment 6 Summary'!C63","v":0},75,{"$f":"C62*D62","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E62:E62)","v":0}]
["Right of Way Contingency (XX%)",null,"-",null,{"$f":"'Alignment 1 Summary'!E65+'Alignment 2  Summary'!E65+'Alignment 3 Summary'!E65+'Alignment 4 Summary'!E65+'Alignment 5 Summary'!E65+'Alignment 6 Summary'!E65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 1 Summary'!C67+'Alignment 2  Summary'!C67+'Alignment 3 Summary'!C67+'Alignment 4 Summary'!C67+'Alignment 5 Summary'!C67+'Alignment 6 Summary'!C67","v":0},300000,{"$f":"C66*D66","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 1 Summary'!C68+'Alignment 2  Summary'!C68+'Alignment 3 Summary'!C68+'Alignment 4 Summary'!C68+'Alignment 5 Summary'!C68+'Alignment 6 Summary'!C68","v":0},1,{"$f":"C67*D67","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 1 Summary'!C69+'Alignment 2  Summary'!C69+'Alignment 3 Summary'!C69+'Alignment 4 Summary'!C69+'Alignment 5 Summary'!C69+'Alignment 6 Summary'!C69","v":0},25,{"$f":"C68*D68","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 1 Summary'!C70+'Alignment 2  Summary'!C70+'Alignment 3 Summary'!C70+'Alignment 4 Summary'!C70+'Alignment 5 Summary'!C70+'Alignment 6 Summary'!C70","v":0},2500,{"$f":"C69*D69","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 1 Summary'!C71+'Alignment 2  Summary'!C71+'Alignment 3 Summary'!C71+'Alignment 4 Summary'!C71+'Alignment 5 Summary'!C71+'Alignment 6 Summary'!C71","v":0},2000,{"$f":"C70*D70","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E66:E70)","v":0}]
["Traffic Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E73+'Alignment 2  Summary'!E73+'Alignment 3 Summary'!E73+'Alignment 4 Summary'!E73+'Alignment 5 Summary'!E73+'Alignment 6 Summary'!E73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 1 Summary'!C75+'Alignment 2  Summary'!C75+'Alignment 3 Summary'!C75+'Alignment 4 Summary'!C75+'Alignment 5 Summary'!C75+'Alignment 6 Summary'!C75","v":0},400,{"$f":"C74*D74","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 1 Summary'!C76+'Alignment 2  Summary'!C76+'Alignment 3 Summary'!C76+'Alignment 4 Summary'!C76+'Alignment 5 Summary'!C76+'Alignment 6 Summary'!C76","v":0},18,{"$f":"C75*D75","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E74:E75)","v":0}]
["Bridge Items Contingency ",null,"-",null,{"$f":"'Alignment 1 Summary'!E78+'Alignment 2  Summary'!E78+'Alignment 3 Summary'!E78+'Alignment 4 Summary'!E78+'Alignment 5 Summary'!E78+'Alignment 6 Summary'!E78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 1 Summary'!C80+'Alignment 2  Summary'!C80+'Alignment 3 Summary'!C80+'Alignment 4 Summary'!C80+'Alignment 5 Summary'!C80+'Alignment 6 Summary'!C80","v":0},700,{"$f":"C79*D79","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 1 Summary'!C81+'Alignment 2  Summary'!C81+'Alignment 3 Summary'!C81+'Alignment 4 Summary'!C81+'Alignment 5 Summary'!C81+'Alignment 6 Summary'!C81","v":0},75000,{"$f":"C80*D80","v":0}]
["MISCELLANEOUS ITEMS SUMMARY FROM ALIGNMENT SUMMARY TABS                                               *Indivdual Misc. Items, Units, Quantity, and Unit Price must be input in \"Alignment Summary Tabs\""]
["Alignment 1","LS",null,0,{"$f":"'Alignment 1 Summary'!E83+'Alignment 1 Summary'!E84+'Alignment 1 Summary'!E85+'Alignment 1 Summary'!E86+'Alignment 1 Summary'!E87+'Alignment 1 Summary'!E88+'Alignment 1 Summary'!E89+'Alignment 1 Summary'!E90+'Alignment 1 Summary'!E91+'Alignment 1 Summary'!E92","v":0}]
["Alignment 2","LS",null,0,{"$f":"'Alignment 2  Summary'!E83+'Alignment 2  Summary'!E84+'Alignment 2  Summary'!E85+'Alignment 2  Summary'!E86+'Alignment 2  Summary'!E87+'Alignment 2  Summary'!E88+'Alignment 2  Summary'!E89+'Alignment 2  Summary'!E90+'Alignment 2  Summary'!E91+'Alignment 2  Summary'!E92","v":0}]
["Alignment 3","LS",null,0,{"$f":"'Alignment 3 Summary'!E83+'Alignment 3 Summary'!E84+'Alignment 3 Summary'!E85+'Alignment 3 Summary'!E86+'Alignment 3 Summary'!E87+'Alignment 3 Summary'!E88+'Alignment 3 Summary'!E89+'Alignment 3 Summary'!E90+'Alignment 3 Summary'!E91+'Alignment 3 Summary'!E92","v":0}]
["Alignment 4","LS",null,0,{"$f":"'Alignment 4 Summary'!E83+'Alignment 4 Summary'!E84+'Alignment 4 Summary'!E85+'Alignment 4 Summary'!E86+'Alignment 4 Summary'!E87+'Alignment 4 Summary'!E88+'Alignment 4 Summary'!E89+'Alignment 4 Summary'!E90+'Alignment 4 Summary'!E91+'Alignment 4 Summary'!E92","v":0}]
["Alignment 5","LS",null,0,{"$f":"'Alignment 5 Summary'!E83+'Alignment 5 Summary'!E84+'Alignment 5 Summary'!E85+'Alignment 5 Summary'!E86+'Alignment 5 Summary'!E87+'Alignment 5 Summary'!E88+'Alignment 5 Summary'!E89+'Alignment 5 Summary'!E90+'Alignment 5 Summary'!E91+'Alignment 5 Summary'!E92","v":0}]
["Alignment 6","LS",null,0,{"$f":"'Alignment 6 Summary'!E83+'Alignment 6 Summary'!E84+'Alignment 6 Summary'!E85+'Alignment 6 Summary'!E86+'Alignment 6 Summary'!E87+'Alignment 6 Summary'!E88+'Alignment 6 Summary'!E89+'Alignment 6 Summary'!E90+'Alignment 6 Summary'!E91+'Alignment 6 Summary'!E92","v":0}]
[null,null,null,0,{"$f":"C88*D88","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E64+E72+E77","v":0}]
["Mobilization",null,null,null,{"$f":"E11","v":5000}]
["Construction Survey",null,null,null,{"$f":"E12","v":0}]
["Sub-Total",null,null,null,{"$f":"E20+E29+E39+E46+E52+E59+E71+E76+E79+E80+E82+E83+E84+E90+E91+E63+E85+E86+E87+E88+E89","v":0}]
["Total ",null,null,null,{"$f":"E96+E93+E11+E12","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E97*D99","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E97<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E97<5000000,0.05,0.1)","v":0.05},{"$f":"E96*D100","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E97+E99+E100)*((1+0.028)^('Alignment 1 Calculation'!B6-'Alignment 1 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 1 Summary","index":2,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[96,0,96,3],[98,0,98,4],[100,1,100,2],[65,0,65,4],[73,0,73,4],[78,0,78,4],[81,0,81,4],[94,0,94,3],[95,0,95,3],[61,0,61,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[9,0,9,4],[13,0,13,4],[22,0,22,4],[31,0,31,4],[41,0,41,4],[48,0,48,4],[54,0,54,4]]}
["Project :",{"$f":"'Alignment 1 Calculation'!B1","v":"0000-000-000"}]
["UPC:",{"$f":"'Alignment 1 Calculation'!B2","v":"XXXXX"}]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:",{"$f":"'Alignment 1 Calculation'!B4","v":"Name"}]
[]
["For Recent Bid History Click Link"]
["*Unit Prices can be changed in the \"Total Project Summary\" tab. "]
["Those Unit Prices are reflected in the \"Alignment Summaries\" tab."]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E97<=1000000,((E97-200000)*0.075)+20000,((E97-1000000)*0.05)+80000)","v":5000},{"$f":"C12*D12","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E97*0.015,-3)","v":0},{"$f":"C13*D13","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 1 Calculation'!K41","v":0},{"$f":"'Total Project Summary'!D14","v":20000},{"$f":"C15*D15","v":0}]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 1 Calculation'!I76","v":0},{"$f":"'Total Project Summary'!D15","v":17},0]
["BORROW EXCAVATION","CY",{"$f":"IF(('Alignment 1 Calculation'!I76*1.1)>'Alignment 1 Calculation'!I50,0,'Alignment 1 Calculation'!I50-('Alignment 1 Calculation'!I76*1.1))","v":0},{"$f":"'Total Project Summary'!D16","v":15},0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"('Alignment 1 Calculation'!F101*'Alignment 1 Calculation'!F102*'Alignment 1 Calculation'!F103)/27","v":0},{"$f":"'Total Project Summary'!D17","v":17},0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"C18*2.025","v":0},{"$f":"'Total Project Summary'!D18","v":20},0]
["DRY RIPRAP ","TONS",{"$f":"(('Alignment 1 Calculation'!B102*'Alignment 1 Calculation'!B103*'Alignment 1 Calculation'!B104)/27)*2.025","v":0},{"$f":"'Total Project Summary'!D19","v":40},{"$f":"C20*D20","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E15:E20)","v":0}]
["Grading Items Contingency (XX%)",null,0.05,null,{"$f":"E21*C22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 1 Calculation'!J34","v":0},{"$f":"'Total Project Summary'!D23","v":2500},{"$f":"C24*D24","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 1 Calculation'!J30","v":0},{"$f":"'Total Project Summary'!D24","v":125},0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 1 Calculation'!J31","v":0},{"$f":"'Total Project Summary'!D25","v":250},0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 1 Calculation'!J32","v":0},{"$f":"'Total Project Summary'!D26","v":300},0]
["DROP INLETS","EA",{"$f":"'Alignment 1 Calculation'!J33","v":0},{"$f":"'Total Project Summary'!D27","v":1000},0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 1 Calculation'!B21*2","v":0},{"$f":"'Total Project Summary'!D28","v":35},0]
["Sub-Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Drainage Items Contingency (XX%)",null,0.05,null,{"$f":"E30*C31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"(((('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*(('Alignment 1 Calculation'!B14+('Alignment 1 Calculation'!B18+'Alignment 1 Calculation'!B17)))/9))*(('Alignment 1 Calculation'!B25*110)/2000))+((('Alignment 1 Calculation'!B32*'Alignment 1 Calculation'!B33)/9)*220)/2000","v":0},{"$f":"'Total Project Summary'!D32","v":110},{"$f":"C33*D33","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"IF('Alignment 1 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*'Alignment 1 Calculation'!B14)/9)*('Alignment 1 Calculation'!B26*115))/2000),(('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*('Alignment 1 Calculation'!B14+('Alignment 1 Calculation'!B18+'Alignment 1 Calculation'!B17))/9)*('Alignment 1 Calculation'!B26*115)/2000)","v":0},{"$f":"'Total Project Summary'!D33","v":100},0]
["BASE COURSE","TONS",{"$f":"IF('Alignment 1 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*'Alignment 1 Calculation'!B14)/9)*('Alignment 1 Calculation'!B27*115))/2000),(('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*('Alignment 1 Calculation'!B14+('Alignment 1 Calculation'!B18+'Alignment 1 Calculation'!B17))/9)*('Alignment 1 Calculation'!B27*115)/2000)","v":0},{"$f":"'Total Project Summary'!D34","v":90},0]
["SUBBASE COURSE","TONS",{"$f":"IF('Alignment 1 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*('Alignment 1 Calculation'!B14+'Alignment 1 Calculation'!B15+'Alignment 1 Calculation'!B16)*('Alignment 1 Calculation'!B28/12))+(('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*(('Alignment 1 Calculation'!B25+'Alignment 1 Calculation'!B26+'Alignment 1 Calculation'!B27)/12)*('Alignment 1 Calculation'!B15+'Alignment 1 Calculation'!B16)))/27)*2.025),((((('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*('Alignment 1 Calculation'!B14+'Alignment 1 Calculation'!B15+'Alignment 1 Calculation'!B16)*('Alignment 1 Calculation'!B28/12))+(('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*(('Alignment 1 Calculation'!B25+'Alignment 1 Calculation'!B26+'Alignment 1 Calculation'!B27)/12)*(('Alignment 1 Calculation'!B15-'Alignment 1 Calculation'!B17)+('Alignment 1 Calculation'!B16-'Alignment 1 Calculation'!B18))))/27)*2.025))*1.06","v":0},{"$f":"'Total Project Summary'!D35","v":20},0]
["No.1 STONE","TONS",{"$f":"((('Alignment 1 Calculation'!B11+'Alignment 1 Calculation'!F20+'Alignment 1 Calculation'!F21)*('Alignment 1 Calculation'!B14+('Alignment 1 Calculation'!B15*2))*('Alignment 1 Calculation'!B29/12))/27)*2.025","v":0},{"$f":"'Total Project Summary'!D36","v":25},0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"('Alignment 1 Calculation'!F16*'Alignment 1 Calculation'!F17)/9","v":0},{"$f":"'Total Project Summary'!D37","v":10},0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"('Alignment 1 Calculation'!B32*'Alignment 1 Calculation'!B33)/9","v":0},{"$f":"'Total Project Summary'!D38","v":2},0]
["Sub-Total",null,null,null,{"$f":"SUM(E33:E39)","v":0}]
["Pavement Items Contingency (XX%)",null,0.05,null,{"$f":"E40*C41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"('Alignment 1 Calculation'!F40*'Alignment 1 Calculation'!F41)/27","v":0},{"$f":"'Total Project Summary'!D42","v":400},{"$f":"C43*D43","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 1 Calculation'!F34","v":0},{"$f":"'Total Project Summary'!D43","v":2000},{"$f":"C44*D44","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 1 Calculation'!F35","v":0},{"$f":"'Total Project Summary'!D44","v":5000},0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 1 Calculation'!F36","v":0},{"$f":"'Total Project Summary'!D45","v":10000},0]
["Sub-Total",null,null,null,{"$f":"SUM(E43:E46)","v":0}]
["Incidental Items Contingency (XX%)",null,0.05,null,{"$f":"E47*C48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"IF('Alignment 1 Calculation'!B43=0,'MOT Ranking Criteria'!D4,IF('Alignment 1 Calculation'!B43=1,'MOT Ranking Criteria'!D5,IF('Alignment 1 Calculation'!B43=2,'MOT Ranking Criteria'!D6,IF('Alignment 1 Calculation'!B43=3,'MOT Ranking Criteria'!D7,IF('Alignment 1 Calculation'!B43=4,'MOT Ranking Criteria'!D8,IF('Alignment 1 Calculation'!B43=5,'MOT Ranking Criteria'!D9,IF('Alignment 1 Calculation'!B43=6,'MOT Ranking Criteria'!D10,IF('Alignment 1 Calculation'!B43=7,'MOT Ranking Criteria'!D11,IF('Alignment 1 Calculation'!B43=8,'MOT Ranking Criteria'!D12,IF('Alignment 1 Calculation'!B43=9,'MOT Ranking Criteria'!D13,IF('Alignment 1 Calculation'!B43=10,'MOT Ranking Criteria'!D14)))))))))))","v":0},{"$f":"C50*D50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 1 Calculation'!B7","v":0},{"$f":"'Total Project Summary'!D50","v":2000},{"$f":"D51*C51","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 1 Calculation'!B36*'Alignment 1 Calculation'!B37/9","v":0},{"$f":"'Total Project Summary'!D51","v":90},{"$f":"C52*D52","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E50:E52)","v":0}]
["Protective Items Contingency (XX%)",null,0.05,null,{"$f":"E53*C54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA",{"$f":"'Alignment 1 Calculation'!K38","v":1},{"$f":"IF('Alignment 1 Calculation'!K40=\"Yes\",0,IF('Alignment 1 Calculation'!K41>5,250000,IF('Alignment 1 Calculation'!K41>0.75,150000,0)))","v":0},{"$f":"C56*D56","v":0}]
["SEEDING ","LB",{"$f":"ROUNDUP(('Alignment 1 Calculation'!K41*350)*1.6,-2)","v":0},{"$f":"'Total Project Summary'!D56","v":15},{"$f":"C57*D57","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 1 Calculation'!B11*2","v":0},{"$f":"'Total Project Summary'!D57","v":4},{"$f":"C58*D58","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 1 Calculation'!B11/50","v":0},{"$f":"'Total Project Summary'!D58","v":500},{"$f":"C59*D59","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E56:E59)","v":0}]
["E&S Control Items Contingency (XX%)",null,0.05,null,{"$f":"E60*C61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 1 Calculation'!J26+'Alignment 1 Calculation'!J27","v":0},{"$f":"'Total Project Summary'!D62","v":75},{"$f":"C63*D63","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E63:E63)","v":0}]
["Right of Way Contingency (XX%)",null,0.05,null,{"$f":"E64*C65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 1 Calculation'!B42","v":0},{"$f":"'Total Project Summary'!D66","v":300000},{"$f":"C67*D67","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 1 Calculation'!B11*4","v":0},{"$f":"'Total Project Summary'!D67","v":1},{"$f":"C68*D68","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 1 Calculation'!B40","v":0},{"$f":"'Total Project Summary'!D68","v":25},{"$f":"C69*D69","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 1 Calculation'!B41","v":0},{"$f":"'Total Project Summary'!D69","v":2500},{"$f":"C70*D70","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 1 Calculation'!F31","v":0},{"$f":"'Total Project Summary'!D70","v":2000},{"$f":"C71*D71","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E67:E71)","v":0}]
["Traffic Items Contingency (XX%)",null,0.05,null,{"$f":"E72*C73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 1 Calculation'!F29*'Alignment 1 Calculation'!F30","v":0},{"$f":"'Total Project Summary'!D74","v":400},{"$f":"C75*D75","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 1 Calculation'!F25*'Alignment 1 Calculation'!F26","v":0},{"$f":"'Total Project Summary'!D75","v":18},{"$f":"C76*D76","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E75:E76)","v":0}]
["Bridge Items Contingency (XX%)",null,0.05,null,{"$f":"E77*C78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 1 Calculation'!J22","v":0},{"$f":"'Total Project Summary'!D79","v":700},{"$f":"C80*D80","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 1 Calculation'!J23","v":0},{"$f":"'Total Project Summary'!D80","v":75000},{"$f":"C81*D81","v":0}]
["MISCELLANEOUS ITEMS NOT IN SPREADSHEET CAN BE ADDED HERE"]
["Saw Cut","LF",null,0,{"$f":"C83*D83","v":0}]
["Demo of Buildings/Clearing Parcels","LS",null,0,{"$f":"C84*D84","v":0}]
[null,"SF",null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E22+E31+E41+E48+E54+E61+E65+E73+E78","v":0}]
["Mobilization",null,null,null,{"$f":"E12","v":5000}]
["Construction Survey",null,null,null,{"$f":"E13","v":0}]
["Sub-Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E72+E77+E80+E81+E83+E84+E85+E91+E92+E64+E86+E87+E88+E89+E90","v":0}]
["Total ",null,null,null,{"$f":"E94+E97+E12+E13","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E98*D100","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E98<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E98<5000000,0.05,0.1)","v":0.05},{"$f":"E97*D101","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E98+E100+E101)*((1+0.028)^('Alignment 1 Calculation'!B6-'Alignment 1 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted in the \"Total Project Summary\" Tab.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 1 Calculation","index":3,"n_rows":104,"n_cols":11,"rows_kept":104,"cut":false,"hidden":false,"merged":[[115,14,119,15],[119,0,119,3],[119,5,119,9],[92,4,92,6],[99,0,100,2],[99,4,99,6],[106,0,106,3],[106,5,106,9],[110,14,113,15],[74,0,74,2],[74,3,97,3],[74,4,74,6],[74,7,97,7],[75,8,97,8],[80,0,80,2],[80,4,80,6],[86,0,86,2],[86,4,86,6],[92,0,92,2],[73,0,73,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,2],[48,3,71,3],[48,4,48,6],[48,7,71,7],[49,8,71,8],[54,0,54,2],[54,4,54,6],[60,0,60,2],[60,4,60,6],[66,0,66,2],[66,4,66,6],[40,8,40,9],[24,8,24,10],[27,4,27,6],[28,8,28,10],[30,0,30,2],[32,4,32,6],[34,0,34,2],[36,8,36,10],[37,4,37,6],[37,8,38,9],[38,0,38,2],[39,8,39,9],[16,8,16,10],[17,8,17,10],[18,4,18,6],[20,8,20,10],[23,0,23,2],[23,4,23,6],[15,8,15,10],[0,3,0,6],[1,3,1,6],[9,0,9,2],[9,4,9,6],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,4,14,6],[14,8,14,10]]}
["Project :  ",{"$f":"'Total Project Summary'!B1:E1","v":"0000-000-000"},null,null,null,null,null,null,"Data Input Required"]
["UPC:",{"$f":"'Total Project Summary'!B2:E2","v":"XXXXX"},null,null,null,null,null,null,"Calculated Information That"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"},null,null,null,null,null,null,"Is Locked"]
["Estimator:",{"$f":"'Total Project Summary'!B4:E4","v":"Name"}]
["Current Year:",2020]
["Proposed Ad Date Year:",2020]
["Construction Duration:",0,"Months"]
[]
[]
["Proposed Full Depth Roadway Typical Section",null,null,null,"Existing Roadway",null,null,null,"Questions to Ask Yourself"]
["Length",0,"ft",null,"Length",0,"ft",null,"Have you requested Pre-Pave. Design?"]
["Number of Lanes",0,null,null,"Rdway Width",0,"ft",null,"Are Multiple GS Standards Required?"]
["Paved Lane Width",0,"ft",null,"Shldr Width",0,"ft",null,"Type of existing material?"]
["Paved Roadway Width",{"$f":"B12*B13","v":0},"ft",null,null,null,null,null,"Is Rock Fill Required"]
["Right Total Shoulder Width",0,"ft",null,"Demolition of Existing Pavement",null,null,null,"What (Run:Rise) are existing cut slopes?"]
["Left Total Shoulder Width",0,"ft",null,"Length",0,"ft",null,"How much right of way will be required?"]
["Right Paved Shoulder Width",0,"ft",null,"Pavement Width",0,"ft",null,"Are there relocations?"]
["Left Paved Shoulder Width",0,"ft",null,null,null,null,null,"Is there stream/wetlands mitigation?"]
["Paved Shoulder Type","Full Pave.Depth",null,null,"Connections"]
["Curb and Gutter Required?","No",null,null,"Connection 1 Length",0,"ft"]
["Length of C&G (if Required) ",0,"ft",null,"Connection 2 Length",0,"ft",null,"Mitigation "]
["% of New Horizontal Alignment",0,null,null,"*Length is added to mainline length",null,null,null,"Stream",0,"LF"]
[null,null,null,null,null,null,null,null,"Wetland",0,"acre"]
["Pavement Design",null,null,null,"Existing Bridge"]
["Surface Mix (SM) Pave. Depth",0,"in",null,"Length",0,"ft",null,"Utility Impacts"]
["Intermediate Mix (IM) Pave. Depth",0,"in",null,"Width",0,"ft",null,"Water",0,"LF"]
["Base Mix (BM) Pave. Depth",0,"in",null,null,null,null,null,"Sewer",0,"LF"]
["No. 21B Stone Depth",0,"in",null,"Proposed Bridge"]
["No. 1 Stone depth",0,"in",null,"Length",0,"ft",null,"Drainage Items"]
[null,null,null,null,"Width",0,"ft",null,"Pipes 18\"-36\"",0,"LF"]
["Overlay Only Sections",null,null,null,"# of FOAs",0,"ea",null,"Pipes > 36\"",0,"LF"]
["Length",0,"ft",null,null,null,null,null,"End Walls for Pipes Over 36\"",0,"ea"]
["Pavement Width",0,"ft",null,"Entrances",null,null,null,"Drop Inlets ",0,"ea"]
[null,null,null,null,"Rural Private",0,"#/project",null,"Concrete Box Culvert Length",0,"LF"]
["Sidewalk",null,null,null,"Urban Private",0,"#/project"]
["Length ",0,"ft",null,"Commercial",0,"#/project"]
["Width ",0,"ft",null,null,null,null,null,"SWM Facility Questions"]
[null,null,null,null,"Retaining Wall RW-3",null,null,null,"How many Drainage Breaks are on the Project?",null,1]
["Traffic Items",null,null,null,"Avg. Height",0,"ft"]
["Guardrail Length",0,"ft",null,"Length",0,"ft",null,"Can SWM Facilities be Avoided?",null,"No"]
["End Treatments",0,"ea",null,"Area",{"$f":"LOOKUP(F39,{0,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,4.83,7.43,10.63,14.43,18.83,23.83,29.43,35.63,42.98,51.03,59.78,69.23,79.38})","v":0},"sf",null,"Land Disturbance/acre",null,{"$f":"(((B50*(IF(B52='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B52<>'Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B52='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B52='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B52='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B52='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B52='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B52='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B52='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B52='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+((B56*(IF(B58='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B58='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B58='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B58='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B58='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B58='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B58='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B58='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B58='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B58='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B62*(IF(B64='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B64='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B64='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B64='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B64='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B64='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B64='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B64='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B64='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B64='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B68*(IF(B70='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B70='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B70='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B70='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B70='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B70='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B70='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B70='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B70='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B70='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+(B76*(IF(B78='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B78='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B78='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B78='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B78='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B78='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B78='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B78='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B78='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B78='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B82*(IF(B84='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B84='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B84='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B84='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B84='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B84='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B84='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B84='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B84='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B84='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B88*(IF(B90='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B90='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B90='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B90='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B90='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B90='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B90='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B90='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B90='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B90='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B94*(IF(B96='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B96='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B96='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B96='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B96='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B96='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B96='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B96='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B96='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B96='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))/43560)+(((($B$15-$F$13)*2*$B$11)+((($B$14-$F$12)*$B$11)))/43560)+(((($B$11*($B$14+$B$15))*$B$22))/43560)","v":0}]
["Permanent Traffic Signal",0,"ea"]
["How complex is MOT?   (0-10)      (See MOT Ranking Tab)",0]
[]
["Earthwork"]
["* Recommend Using Google Earth to Obtain Elevations/Offsets/Profiles"]
["* Cut and Fill Quantities for the Left and Right Sections Are Figured Using a Triangular Calculation. If Using a Rectangular Assumption, Double the \"W\" Value."]
["Fill "]
["Fill Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length of Fill",0,"ft",null,"Length",0,"ft",null,{"$f":"B54+B60+B66+B72+F54+F60+F66+F72","v":0}]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B52,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B51,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B50/100)*B53","v":0},"CY",null,"Total",{"$f":"(F50*F51*F52)/27","v":0},"cu. ft"]
["Fill Section 2",null,null,null,"Mid Section 2"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B58,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B57,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B56/100)*B59","v":0},"CY",null,"Total",{"$f":"(F56*F57*F58)/27","v":0},"cu. ft"]
["Fill Section 3",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B64,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B63,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B62/100)*B65","v":0},"CY",null,"Total",{"$f":"(F62*F63*F64)/27","v":0},"cu. ft"]
["Fill Section 4",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B70,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B69,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B68/100)*B71","v":0},"CY",null,"Total",{"$f":"(F68*F69*F70)/27","v":0},"cu. ft"]
[]
["Cut"]
["Cut Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length",0,"ft",null,"Length",0,"ft",null,{"$f":"B80+B86+B92+B98+F80+F86+F92+F98","v":0}]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","20' - 30'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B78,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B77,'Volume Matrix '!$B$4:$H$4,0))","v":450},"CY"]
["Section 1 Total",{"$f":"(B76/100)*B79","v":0},"CY",null,"Total",{"$f":"(F76*F77*F78)/27","v":0},"CY"]
["Cut Section 2",null,null,null,"Mid Section 2"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B84,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B83,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B82/100)*B85","v":0},"CY",null,"Total",{"$f":"(F82*F83*F84)/27","v":0},"CY"]
["Cut Section 3",null,null,null,"Mid Section 3"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B90,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B89,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B88/100)*B91","v":0},"CY",null,"Total",{"$f":"(F88*F89*F90)/27","v":0},"CY"]
["Cut Section 4",null,null,null,"Mid Section 4"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 1 Calculation'!B96,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 1 Calculation'!B95,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Section 1 Total",{"$f":"(B94/100)*B97","v":0},"CY",null,"Total",{"$f":"(F94*F95*F96)/27","v":0},"CY"]
[]
["Fills that will be Constructed out of Commercial Rock Material",null,null,null,"Unsuitable Material",null,null,null,"Length:","Length of Section"]
[null,null,null,null,"Length",0,"ft",null,"W:","See Examples"]
["Length",0,"ft",null,"Width",0,"ft",null,"H:","See Examples"]
["W",0,"ft",null,"Depth",0,"ft",null,"* Mid Sections are a Rectangular Calculations"]
["H",0,"ft",null,null,null,null,null,"*Right/Left Sections are Triangular Calculations"]

{"sheet":"Alignment 2  Summary","index":4,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[96,0,96,3],[98,0,98,4],[100,1,100,2],[65,0,65,4],[73,0,73,4],[78,0,78,4],[81,0,81,4],[94,0,94,3],[95,0,95,3],[61,0,61,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[9,0,9,4],[13,0,13,4],[22,0,22,4],[31,0,31,4],[41,0,41,4],[48,0,48,4],[54,0,54,4]]}
["Project :",{"$f":"'Alignment 2 Calculation'!B1","v":"0000-000-000"}]
["UPC:",{"$f":"'Alignment 2 Calculation'!B2","v":"XXXXX"}]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:",{"$f":"'Alignment 2 Calculation'!B4","v":"Name"}]
[]
["For Recent Bid History Click Link"]
["*Unit Prices can be changed in the \"Total Project Summary\" tab. "]
["Those Unit Prices are reflected in the \"Alignment Summaries\" tab."]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E97<=1000000,((E97-200000)*0.075)+20000,((E97-1000000)*0.05)+80000)","v":5000},{"$f":"C12*D12","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E97*0.015,-3)","v":0},{"$f":"C13*D13","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 2 Calculation'!K41","v":0},{"$f":"'Total Project Summary'!D14","v":20000},{"$f":"C15*D15","v":0}]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 2 Calculation'!I76","v":0},{"$f":"'Total Project Summary'!D15","v":17},0]
["BORROW EXCAVATION","CY",{"$f":"IF(('Alignment 2 Calculation'!I76*1.1)>'Alignment 2 Calculation'!I50,0,'Alignment 2 Calculation'!I50-('Alignment 2 Calculation'!I76*1.1))","v":0},{"$f":"'Total Project Summary'!D16","v":15},0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"('Alignment 2 Calculation'!F101*'Alignment 2 Calculation'!F102*'Alignment 2 Calculation'!F103)/27","v":0},{"$f":"'Total Project Summary'!D17","v":17},0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"C18*2.025","v":0},{"$f":"'Total Project Summary'!D18","v":20},0]
["DRY RIPRAP ","TONS",{"$f":"(('Alignment 2 Calculation'!B102*'Alignment 2 Calculation'!B103*'Alignment 2 Calculation'!B104)/27)*2.025","v":0},{"$f":"'Total Project Summary'!D19","v":40},{"$f":"C20*D20","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E15:E20)","v":0}]
["Grading Items Contingency (XX%)",null,0.05,null,{"$f":"E21*C22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 2 Calculation'!J34","v":0},{"$f":"'Total Project Summary'!D23","v":2500},{"$f":"C24*D24","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 2 Calculation'!J30","v":0},{"$f":"'Total Project Summary'!D24","v":125},0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 2 Calculation'!J31","v":0},{"$f":"'Total Project Summary'!D25","v":250},0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 2 Calculation'!J32","v":0},{"$f":"'Total Project Summary'!D26","v":300},0]
["DROP INLETS","EA",{"$f":"'Alignment 2 Calculation'!J33","v":0},{"$f":"'Total Project Summary'!D27","v":1000},0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 2 Calculation'!B21*2","v":0},{"$f":"'Total Project Summary'!D28","v":35},0]
["Sub-Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Drainage Items Contingency (XX%)",null,0.05,null,{"$f":"E30*C31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"(((('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*(('Alignment 2 Calculation'!B14+('Alignment 2 Calculation'!B18+'Alignment 2 Calculation'!B17)))/9))*(('Alignment 2 Calculation'!B25*110)/2000))+((('Alignment 2 Calculation'!B32*'Alignment 2 Calculation'!B33)/9)*220)/2000","v":0},{"$f":"'Total Project Summary'!D32","v":110},{"$f":"C33*D33","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"IF('Alignment 2 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*'Alignment 2 Calculation'!B14)/9)*('Alignment 2 Calculation'!B26*115))/2000),(('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*('Alignment 2 Calculation'!B14+('Alignment 2 Calculation'!B18+'Alignment 2 Calculation'!B17))/9)*('Alignment 2 Calculation'!B26*115)/2000)","v":0},{"$f":"'Total Project Summary'!D33","v":100},0]
["BASE COURSE","TONS",{"$f":"IF('Alignment 2 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*'Alignment 2 Calculation'!B14)/9)*('Alignment 2 Calculation'!B27*115))/2000),(('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*('Alignment 2 Calculation'!B14+('Alignment 2 Calculation'!B18+'Alignment 2 Calculation'!B17))/9)*('Alignment 2 Calculation'!B27*115)/2000)","v":0},{"$f":"'Total Project Summary'!D34","v":90},0]
["SUBBASE COURSE","TONS",{"$f":"IF('Alignment 2 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*('Alignment 2 Calculation'!B14+'Alignment 2 Calculation'!B15+'Alignment 2 Calculation'!B16)*('Alignment 2 Calculation'!B28/12))+(('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*(('Alignment 2 Calculation'!B25+'Alignment 2 Calculation'!B26+'Alignment 2 Calculation'!B27)/12)*('Alignment 2 Calculation'!B15+'Alignment 2 Calculation'!B16)))/27)*2.025),((((('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*('Alignment 2 Calculation'!B14+'Alignment 2 Calculation'!B15+'Alignment 2 Calculation'!B16)*('Alignment 2 Calculation'!B28/12))+(('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*(('Alignment 2 Calculation'!B25+'Alignment 2 Calculation'!B26+'Alignment 2 Calculation'!B27)/12)*(('Alignment 2 Calculation'!B15-'Alignment 2 Calculation'!B17)+('Alignment 2 Calculation'!B16-'Alignment 2 Calculation'!B18))))/27)*2.025))*1.06","v":0},{"$f":"'Total Project Summary'!D35","v":20},0]
["No.1 STONE","TONS",{"$f":"((('Alignment 2 Calculation'!B11+'Alignment 2 Calculation'!F20+'Alignment 2 Calculation'!F21)*('Alignment 2 Calculation'!B14+('Alignment 2 Calculation'!B15*2))*('Alignment 2 Calculation'!B29/12))/27)*2.025","v":0},{"$f":"'Total Project Summary'!D36","v":25},0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"('Alignment 2 Calculation'!F16*'Alignment 2 Calculation'!F17)/9","v":0},{"$f":"'Total Project Summary'!D37","v":10},0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"('Alignment 2 Calculation'!B32*'Alignment 2 Calculation'!B33)/9","v":0},{"$f":"'Total Project Summary'!D38","v":2},0]
["Sub-Total",null,null,null,{"$f":"SUM(E33:E39)","v":0}]
["Pavement Items Contingency (XX%)",null,0.05,null,{"$f":"E40*C41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"('Alignment 2 Calculation'!F40*'Alignment 2 Calculation'!F41)/27","v":0},{"$f":"'Total Project Summary'!D42","v":400},{"$f":"C43*D43","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 2 Calculation'!F34","v":0},{"$f":"'Total Project Summary'!D43","v":2000},{"$f":"C44*D44","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 2 Calculation'!F35","v":0},{"$f":"'Total Project Summary'!D44","v":5000},0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 2 Calculation'!F36","v":0},{"$f":"'Total Project Summary'!D45","v":10000},0]
["Sub-Total",null,null,null,{"$f":"SUM(E43:E46)","v":0}]
["Incidental Items Contingency (XX%)",null,0.05,null,{"$f":"E47*C48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"IF('Alignment 2 Calculation'!B43=0,'MOT Ranking Criteria'!D4,IF('Alignment 2 Calculation'!B43=1,'MOT Ranking Criteria'!D5,IF('Alignment 2 Calculation'!B43=2,'MOT Ranking Criteria'!D6,IF('Alignment 2 Calculation'!B43=3,'MOT Ranking Criteria'!D7,IF('Alignment 2 Calculation'!B43=4,'MOT Ranking Criteria'!D8,IF('Alignment 2 Calculation'!B43=5,'MOT Ranking Criteria'!D9,IF('Alignment 2 Calculation'!B43=6,'MOT Ranking Criteria'!D10,IF('Alignment 2 Calculation'!B43=7,'MOT Ranking Criteria'!D11,IF('Alignment 2 Calculation'!B43=8,'MOT Ranking Criteria'!D12,IF('Alignment 2 Calculation'!B43=9,'MOT Ranking Criteria'!D13,IF('Alignment 2 Calculation'!B43=10,'MOT Ranking Criteria'!D14)))))))))))","v":0},{"$f":"C50*D50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 2 Calculation'!B7","v":0},{"$f":"'Total Project Summary'!D50","v":2000},{"$f":"D51*C51","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 2 Calculation'!B36*'Alignment 2 Calculation'!B37/9","v":0},{"$f":"'Total Project Summary'!D51","v":90},{"$f":"C52*D52","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E50:E52)","v":0}]
["Protective Items Contingency (XX%)",null,0.05,null,{"$f":"E53*C54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA",{"$f":"'Alignment 2 Calculation'!K38","v":1},{"$f":"IF('Alignment 2 Calculation'!K40=\"Yes\",0,IF('Alignment 2 Calculation'!K41>5,250000,IF('Alignment 2 Calculation'!K41>0.75,150000,0)))","v":0},{"$f":"C56*D56","v":0}]
["SEEDING ","LB",{"$f":"ROUNDUP(('Alignment 2 Calculation'!K41*350)*1.6,-2)","v":0},{"$f":"'Total Project Summary'!D56","v":15},{"$f":"C57*D57","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 2 Calculation'!B11*2","v":0},{"$f":"'Total Project Summary'!D57","v":4},{"$f":"C58*D58","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 2 Calculation'!B11/50","v":0},{"$f":"'Total Project Summary'!D58","v":500},{"$f":"C59*D59","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E56:E59)","v":0}]
["E&S Control Items Contingency (XX%)",null,0.05,null,{"$f":"E60*C61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 2 Calculation'!J26+'Alignment 2 Calculation'!J27","v":0},{"$f":"'Total Project Summary'!D62","v":75},{"$f":"C63*D63","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E63:E63)","v":0}]
["Right of Way Contingency (XX%)",null,0.05,null,{"$f":"E64*C65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 2 Calculation'!B42","v":0},{"$f":"'Total Project Summary'!D66","v":300000},{"$f":"C67*D67","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 2 Calculation'!B11*4","v":0},{"$f":"'Total Project Summary'!D67","v":1},{"$f":"C68*D68","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 2 Calculation'!B40","v":0},{"$f":"'Total Project Summary'!D68","v":25},{"$f":"C69*D69","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 2 Calculation'!B41","v":0},{"$f":"'Total Project Summary'!D69","v":2500},{"$f":"C70*D70","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 2 Calculation'!F31","v":0},{"$f":"'Total Project Summary'!D70","v":2000},{"$f":"C71*D71","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E67:E71)","v":0}]
["Traffic Items Contingency (XX%)",null,0.05,null,{"$f":"E72*C73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 2 Calculation'!F29*'Alignment 2 Calculation'!F30","v":0},{"$f":"'Total Project Summary'!D74","v":400},{"$f":"C75*D75","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 2 Calculation'!F25*'Alignment 2 Calculation'!F26","v":0},{"$f":"'Total Project Summary'!D75","v":18},{"$f":"C76*D76","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E75:E76)","v":0}]
["Bridge Items Contingency (XX%)",null,0.05,null,{"$f":"E77*C78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 2 Calculation'!J22","v":0},{"$f":"'Total Project Summary'!D79","v":700},{"$f":"C80*D80","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 2 Calculation'!J23","v":0},{"$f":"'Total Project Summary'!D80","v":75000},{"$f":"C81*D81","v":0}]
["MISCELLANEOUS ITEMS NOT IN SPREADSHEET CAN BE ADDED HERE"]
["Saw Cut","LF",null,0,{"$f":"C83*D83","v":0}]
["Demo of Buildings/Clearing Parcels","LS",null,0,{"$f":"C84*D84","v":0}]
[null,null,null,0,{"$f":"C85*D85","v":0}]
[null,null,null,0,0]
[null,"LS",null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E22+E31+E41+E48+E54+E61+E65+E73+E78","v":0}]
["Mobilization",null,null,null,{"$f":"E12","v":5000}]
["Construction Survey",null,null,null,{"$f":"E13","v":0}]
["Sub-Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E72+E77+E80+E81+E83+E84+E85+E91+E92+E64+E86+E87+E88+E89+E90","v":0}]
["Total ",null,null,null,{"$f":"E97+E94+E12+E13","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E98*D100","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E98<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E98<5000000,0.05,0.1)","v":0.05},{"$f":"E97*D101","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E98+E100+E101)*((1+0.028)^('Alignment 2 Calculation'!B6-'Alignment 2 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 2 Calculation","index":5,"n_rows":104,"n_cols":11,"rows_kept":104,"cut":false,"hidden":false,"merged":[[115,14,119,15],[119,0,119,3],[119,5,119,9],[92,4,92,6],[99,0,100,2],[99,4,99,6],[106,0,106,3],[106,5,106,9],[110,14,113,15],[74,0,74,2],[74,3,97,3],[74,4,74,6],[74,7,97,7],[75,8,97,8],[80,0,80,2],[80,4,80,6],[86,0,86,2],[86,4,86,6],[92,0,92,2],[73,0,73,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,2],[48,3,71,3],[48,4,48,6],[48,7,71,7],[49,8,71,8],[54,0,54,2],[54,4,54,6],[60,0,60,2],[60,4,60,6],[66,0,66,2],[66,4,66,6],[40,8,40,9],[24,8,24,10],[27,4,27,6],[28,8,28,10],[30,0,30,2],[32,4,32,6],[34,0,34,2],[36,8,36,10],[37,4,37,6],[37,8,38,9],[38,0,38,2],[39,8,39,9],[16,8,16,10],[17,8,17,10],[18,4,18,6],[20,8,20,10],[23,0,23,2],[23,4,23,6],[15,8,15,10],[0,3,0,6],[1,3,1,6],[9,0,9,2],[9,4,9,6],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,4,14,6],[14,8,14,10]]}
["Project :  ",{"$f":"'Total Project Summary'!B1:E1","v":"0000-000-000"},null,null,null,null,null,null,"Data Input Required"]
["UPC:",{"$f":"'Total Project Summary'!B2:E2","v":"XXXXX"},null,null,null,null,null,null,"Calculated Information That"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"},null,null,null,null,null,null,"Is Locked"]
["Estimator:",{"$f":"'Total Project Summary'!B4:E4","v":"Name"}]
["Current Year:",2020]
["Proposed Ad Date Year:",2020]
["Construction Duration:",0,"Months"]
[]
[]
["Proposed Full Depth Roadway Typical Section",null,null,null,"Existing Roadway",null,null,null,"Questions to Ask Yourself"]
["Length",0,"ft",null,"Length",0,"ft",null,"Have you requested Pre-Pave. Design?"]
["Number of Lanes",0,null,null,"Rdway Width",0,"ft",null,"Are Multiple GS Standards Required?"]
["Paved Lane Width",0,"ft",null,"Shldr Width",0,"ft",null,"Type of existing material?"]
["Paved Roadway Width",{"$f":"B12*B13","v":0},"ft",null,null,null,null,null,"Is Rock Fill Required"]
["Right Total Shoulder Width",0,"ft",null,"Demolition of Existing Pavement",null,null,null,"What (Run:Rise) are existing cut slopes?"]
["Left Total Shoulder Width",0,"ft",null,"Length",0,"ft",null,"How much right of way will be required?"]
["Right Paved Shoulder Width",0,"ft",null,"Pavement Width",0,"ft",null,"Are there relocations?"]
["Left Paved Shoulder Width",0,"ft",null,null,null,null,null,"Is there stream/wetlands mitigation?"]
["Paved Shoulder Type","Full Pave.Depth",null,null,"Connections"]
["Curb and Gutter Required?","No",null,null,"Connection 1 Length",0,"ft"]
["Length of C&G (if Required) ",0,"ft",null,"Connection 2 Length",0,"ft",null,"Mitigation "]
["% of New Horizontal Alignment",0,null,null,"*Length is added to mainline length",null,null,null,"Stream",0,"LF"]
[null,null,null,null,null,null,null,null,"Wetland",0,"acre"]
["Pavement Design",null,null,null,"Existing Bridge"]
["Surface Mix (SM) Pave. Depth",0,"in",null,"Length",0,"ft",null,"Utility Impacts"]
["Intermediate Mix (IM) Pave. Depth",0,"in",null,"Width",0,"ft",null,"Water",0,"LF"]
["Base Mix (BM) Pave. Depth",0,"in",null,null,null,null,null,"Sewer",0,"LF"]
["No. 21B Stone Depth",0,"in",null,"Proposed Bridge"]
["No. 1 Stone depth",0,"in",null,"Length",0,"ft",null,"Drainage Items"]
[null,null,null,null,"Width",0,"ft",null,"Pipes 18\"-36\"",0,"LF"]
["Overlay Only Sections",null,null,null,"# of FOAs",0,"ea",null,"Pipes > 36\"",0,"LF"]
["Length",0,"ft",null,null,null,null,null,"End Walls for Pipes Over 36\"",0,"ea"]
["Pavement Width",0,"ft",null,"Entrances",null,null,null,"Drop Inlets ",0,"ea"]
[null,null,null,null,"Rural Private",0,"#/project",null,"Concrete Box Culvert Length",0,"LF"]
["Sidewalk",null,null,null,"Urban Private",0,"#/project"]
["Length ",0,"ft",null,"Commercial",0,"#/project"]
["Width ",0,"ft",null,null,null,null,null,"SWM Facility Questions"]
[null,null,null,null,"Retaining Wall RW-3",null,null,null,"How many Drainage Breaks are on the Project?",null,1]
["Traffic Items",null,null,null,"Avg. Height",0,"ft"]
["Guardrail Length",0,"ft",null,"Length",0,"ft",null,"Can SWM Facilities be Avoided?",null,"No"]
["End Treatments",0,"ea",null,"Area",{"$f":"LOOKUP(F39,{0,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,4.83,7.43,10.63,14.43,18.83,23.83,29.43,35.63,42.98,51.03,59.78,69.23,79.38})","v":0},"sf",null,"Land Disturbance/acre",null,{"$f":"(((B50*(IF(B52='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B52<>'Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B52='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B52='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B52='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B52='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B52='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B52='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B52='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B52='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+((B56*(IF(B58='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B58='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B58='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B58='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B58='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B58='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B58='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B58='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B58='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B58='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B62*(IF(B64='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B64='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B64='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B64='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B64='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B64='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B64='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B64='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B64='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B64='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B68*(IF(B70='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B70='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B70='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B70='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B70='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B70='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B70='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B70='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B70='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B70='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+(B76*(IF(B78='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B78='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B78='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B78='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B78='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B78='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B78='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B78='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B78='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B78='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B82*(IF(B84='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B84='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B84='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B84='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B84='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B84='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B84='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B84='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B84='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B84='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B88*(IF(B90='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B90='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B90='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B90='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B90='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B90='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B90='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B90='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B90='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B90='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B94*(IF(B96='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B96='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B96='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B96='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B96='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B96='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B96='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B96='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B96='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B96='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))/43560)+(((($B$15-$F$13)*2*$B$11)+((($B$14-$F$12)*$B$11)))/43560)+(((($B$11*($B$14+$B$15))*$B$22))/43560)","v":0}]
["Permanent Traffic Signal",0,"ea"]
["How complex is MOT?   (0-10)      (See MOT Ranking Tab)",0]
[]
["Earthwork"]
["* Recommend Using Google Earth to Obtain Elevations/Offsets/Profiles"]
["* Cut and Fill Quantities for the Left and Right Sections Are Figured Using a Triangular Calculation. If Using a Rectangular Assumption, Double the \"W\" Value."]
["Fill "]
["Fill Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length of Fill",0,"ft",null,"Length",0,"ft",null,{"$f":"B54+B60+B66+B72+F54+F60+F66+F72","v":0}]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B52,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B51,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B50/100)*B53","v":0},"CY",null,"Total",{"$f":"(F50*F51*F52)/27","v":0},"cu. ft"]
["Fill Section 2",null,null,null,"Mid Section 2"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B58,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B57,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B56/100)*B59","v":0},"CY",null,"Total",{"$f":"(F56*F57*F58)/27","v":0},"cu. ft"]
["Fill Section 3",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B64,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B63,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B62/100)*B65","v":0},"CY",null,"Total",{"$f":"(F62*F63*F64)/27","v":0},"cu. ft"]
["Fill Section 4",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B70,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B69,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B68/100)*B71","v":0},"CY",null,"Total",{"$f":"(F68*F69*F70)/27","v":0},"cu. ft"]
[]
["Cut"]
["Cut Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length",0,"ft",null,"Length",0,"ft",null,{"$f":"B80+B86+B92+B98+F80+F86+F92+F98","v":0}]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B78,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B77,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B76/100)*B79","v":0},"CY",null,"Total",{"$f":"(F76*F77*F78)/27","v":0},"CY"]
["Cut Section 2",null,null,null,"Mid Section 2"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B84,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B83,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B82/100)*B85","v":0},"CY",null,"Total",{"$f":"(F82*F83*F84)/27","v":0},"CY"]
["Cut Section 3",null,null,null,"Mid Section 3"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B90,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B89,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B88/100)*B91","v":0},"CY",null,"Total",{"$f":"(F88*F89*F90)/27","v":0},"CY"]
["Cut Section 4",null,null,null,"Mid Section 4"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 2 Calculation'!B96,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 2 Calculation'!B95,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Section 1 Total",{"$f":"(B94/100)*B97","v":0},"CY",null,"Total",{"$f":"(F94*F95*F96)/27","v":0},"CY"]
[]
["Fills that will be Constructed out of Commercial Rock Material",null,null,null,"Unsuitable Material",null,null,null,"Length:","Length of Section"]
[null,null,null,null,"Length",0,"ft",null,"W:","See Examples"]
["Length",0,"ft",null,"Width",0,"ft",null,"H:","See Examples"]
["W",0,"ft",null,"Depth",0,"ft",null,"* Mid Sections are a Rectangular Calculations"]
["H",0,"ft",null,null,null,null,null,"*Right/Left Sections are Triangular Calculations"]

{"sheet":"Alignment 3 Summary","index":6,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[96,0,96,3],[98,0,98,4],[100,1,100,2],[65,0,65,4],[73,0,73,4],[78,0,78,4],[81,0,81,4],[94,0,94,3],[95,0,95,3],[61,0,61,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[9,0,9,4],[13,0,13,4],[22,0,22,4],[31,0,31,4],[41,0,41,4],[48,0,48,4],[54,0,54,4]]}
["Project :",{"$f":"'Alignment 3 Calculation'!B1","v":"0000-000-000"}]
["UPC:",{"$f":"'Alignment 3 Calculation'!B2","v":"XXXXX"}]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:",{"$f":"'Alignment 3 Calculation'!B4","v":"Name"}]
[]
["For Recent Bid History Click Link"]
["*Unit Prices can be changed in the \"Total Project Summary\" tab. "]
["Those Unit Prices are reflected in the \"Alignment Summaries\" tab."]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E97<=1000000,((E97-200000)*0.075)+20000,((E97-1000000)*0.05)+80000)","v":5000},{"$f":"C12*D12","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E97*0.015,-3)","v":0},{"$f":"C13*D13","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 3 Calculation'!K41","v":0},{"$f":"'Total Project Summary'!D14","v":20000},{"$f":"C15*D15","v":0}]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 3 Calculation'!I76","v":0},{"$f":"'Total Project Summary'!D15","v":17},0]
["BORROW EXCAVATION","CY",{"$f":"IF(('Alignment 3 Calculation'!I76*1.1)>'Alignment 3 Calculation'!I50,0,'Alignment 3 Calculation'!I50-('Alignment 3 Calculation'!I76*1.1))","v":0},{"$f":"'Total Project Summary'!D16","v":15},0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"('Alignment 3 Calculation'!F101*'Alignment 3 Calculation'!F102*'Alignment 3 Calculation'!F103)/27","v":0},{"$f":"'Total Project Summary'!D17","v":17},0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"C18*2.025","v":0},{"$f":"'Total Project Summary'!D18","v":20},0]
["DRY RIPRAP ","TONS",{"$f":"(('Alignment 3 Calculation'!B102*'Alignment 3 Calculation'!B103*'Alignment 3 Calculation'!B104)/27)*2.025","v":0},{"$f":"'Total Project Summary'!D19","v":40},{"$f":"C20*D20","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E15:E20)","v":0}]
["Grading Items Contingency (XX%)",null,0.05,null,{"$f":"E21*C22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 3 Calculation'!J34","v":0},{"$f":"'Total Project Summary'!D23","v":2500},{"$f":"C24*D24","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 3 Calculation'!J30","v":0},{"$f":"'Total Project Summary'!D24","v":125},0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 3 Calculation'!J31","v":0},{"$f":"'Total Project Summary'!D25","v":250},0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 3 Calculation'!J32","v":0},{"$f":"'Total Project Summary'!D26","v":300},0]
["DROP INLETS","EA",{"$f":"'Alignment 3 Calculation'!J33","v":0},{"$f":"'Total Project Summary'!D27","v":1000},0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 3 Calculation'!B21*2","v":0},{"$f":"'Total Project Summary'!D28","v":35},0]
["Sub-Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Drainage Items Contingency (XX%)",null,0.05,null,{"$f":"E30*C31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"(((('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*(('Alignment 3 Calculation'!B14+('Alignment 3 Calculation'!B18+'Alignment 3 Calculation'!B17)))/9))*(('Alignment 3 Calculation'!B25*110)/2000))+((('Alignment 3 Calculation'!B32*'Alignment 3 Calculation'!B33)/9)*220)/2000","v":0},{"$f":"'Total Project Summary'!D32","v":110},{"$f":"C33*D33","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"IF('Alignment 3 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*'Alignment 3 Calculation'!B14)/9)*('Alignment 3 Calculation'!B26*115))/2000),(('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*('Alignment 3 Calculation'!B14+('Alignment 3 Calculation'!B18+'Alignment 3 Calculation'!B17))/9)*('Alignment 3 Calculation'!B26*115)/2000)","v":0},{"$f":"'Total Project Summary'!D33","v":100},0]
["BASE COURSE","TONS",{"$f":"IF('Alignment 3 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*'Alignment 3 Calculation'!B14)/9)*('Alignment 3 Calculation'!B27*115))/2000),(('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*('Alignment 3 Calculation'!B14+('Alignment 3 Calculation'!B18+'Alignment 3 Calculation'!B17))/9)*('Alignment 3 Calculation'!B27*115)/2000)","v":0},{"$f":"'Total Project Summary'!D34","v":90},0]
["SUBBASE COURSE","TONS",{"$f":"IF('Alignment 3 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*('Alignment 3 Calculation'!B14+'Alignment 3 Calculation'!B15+'Alignment 3 Calculation'!B16)*('Alignment 3 Calculation'!B28/12))+(('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*(('Alignment 3 Calculation'!B25+'Alignment 3 Calculation'!B26+'Alignment 3 Calculation'!B27)/12)*('Alignment 3 Calculation'!B15+'Alignment 3 Calculation'!B16)))/27)*2.025),((((('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*('Alignment 3 Calculation'!B14+'Alignment 3 Calculation'!B15+'Alignment 3 Calculation'!B16)*('Alignment 3 Calculation'!B28/12))+(('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*(('Alignment 3 Calculation'!B25+'Alignment 3 Calculation'!B26+'Alignment 3 Calculation'!B27)/12)*(('Alignment 3 Calculation'!B15-'Alignment 3 Calculation'!B17)+('Alignment 3 Calculation'!B16-'Alignment 3 Calculation'!B18))))/27)*2.025))*1.06","v":0},{"$f":"'Total Project Summary'!D35","v":20},0]
["No.1 STONE","TONS",{"$f":"((('Alignment 3 Calculation'!B11+'Alignment 3 Calculation'!F20+'Alignment 3 Calculation'!F21)*('Alignment 3 Calculation'!B14+('Alignment 3 Calculation'!B15*2))*('Alignment 3 Calculation'!B29/12))/27)*2.025","v":0},{"$f":"'Total Project Summary'!D36","v":25},0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"('Alignment 3 Calculation'!F16*'Alignment 3 Calculation'!F17)/9","v":0},{"$f":"'Total Project Summary'!D37","v":10},0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"('Alignment 3 Calculation'!B32*'Alignment 3 Calculation'!B33)/9","v":0},{"$f":"'Total Project Summary'!D38","v":2},0]
["Sub-Total",null,null,null,{"$f":"SUM(E33:E39)","v":0}]
["Pavement Items Contingency (XX%)",null,0.05,null,{"$f":"E40*C41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"('Alignment 3 Calculation'!F40*'Alignment 3 Calculation'!F41)/27","v":0},{"$f":"'Total Project Summary'!D42","v":400},{"$f":"C43*D43","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 3 Calculation'!F34","v":0},{"$f":"'Total Project Summary'!D43","v":2000},{"$f":"C44*D44","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 3 Calculation'!F35","v":0},{"$f":"'Total Project Summary'!D44","v":5000},0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 3 Calculation'!F36","v":0},{"$f":"'Total Project Summary'!D45","v":10000},0]
["Sub-Total",null,null,null,{"$f":"SUM(E43:E46)","v":0}]
["Incidental Items Contingency (XX%)",null,0.05,null,{"$f":"E47*C48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"IF('Alignment 3 Calculation'!B43=0,'MOT Ranking Criteria'!D4,IF('Alignment 3 Calculation'!B43=1,'MOT Ranking Criteria'!D5,IF('Alignment 3 Calculation'!B43=2,'MOT Ranking Criteria'!D6,IF('Alignment 3 Calculation'!B43=3,'MOT Ranking Criteria'!D7,IF('Alignment 3 Calculation'!B43=4,'MOT Ranking Criteria'!D8,IF('Alignment 3 Calculation'!B43=5,'MOT Ranking Criteria'!D9,IF('Alignment 3 Calculation'!B43=6,'MOT Ranking Criteria'!D10,IF('Alignment 3 Calculation'!B43=7,'MOT Ranking Criteria'!D11,IF('Alignment 3 Calculation'!B43=8,'MOT Ranking Criteria'!D12,IF('Alignment 3 Calculation'!B43=9,'MOT Ranking Criteria'!D13,IF('Alignment 3 Calculation'!B43=10,'MOT Ranking Criteria'!D14)))))))))))","v":0},{"$f":"C50*D50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 3 Calculation'!B7","v":0},{"$f":"'Total Project Summary'!D50","v":2000},{"$f":"D51*C51","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 3 Calculation'!B36*'Alignment 3 Calculation'!B37/9","v":0},{"$f":"'Total Project Summary'!D51","v":90},{"$f":"C52*D52","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E50:E52)","v":0}]
["Protective Items Contingency (XX%)",null,0.05,null,{"$f":"E53*C54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA",{"$f":"'Alignment 3 Calculation'!K38","v":1},{"$f":"IF('Alignment 3 Calculation'!K40=\"Yes\",0,IF('Alignment 3 Calculation'!K41>5,250000,IF('Alignment 3 Calculation'!K41>0.75,150000,0)))","v":0},{"$f":"C56*D56","v":0}]
["SEEDING ","LB",{"$f":"ROUNDUP(('Alignment 3 Calculation'!K41*350)*1.6,-2)","v":0},{"$f":"'Total Project Summary'!D56","v":15},{"$f":"C57*D57","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 3 Calculation'!B11*2","v":0},{"$f":"'Total Project Summary'!D57","v":4},{"$f":"C58*D58","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 3 Calculation'!B11/50","v":0},{"$f":"'Total Project Summary'!D58","v":500},{"$f":"C59*D59","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E56:E59)","v":0}]
["E&S Control Items Contingency (XX%)",null,0.05,null,{"$f":"E60*C61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 3 Calculation'!J26+'Alignment 3 Calculation'!J27","v":0},{"$f":"'Total Project Summary'!D62","v":75},{"$f":"C63*D63","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E63:E63)","v":0}]
["Right of Way Contingency (XX%)",null,0.05,null,{"$f":"E64*C65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 3 Calculation'!B42","v":0},{"$f":"'Total Project Summary'!D66","v":300000},{"$f":"C67*D67","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 3 Calculation'!B11*4","v":0},{"$f":"'Total Project Summary'!D67","v":1},{"$f":"C68*D68","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 3 Calculation'!B40","v":0},{"$f":"'Total Project Summary'!D68","v":25},{"$f":"C69*D69","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 3 Calculation'!B41","v":0},{"$f":"'Total Project Summary'!D69","v":2500},{"$f":"C70*D70","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 3 Calculation'!F31","v":0},{"$f":"'Total Project Summary'!D70","v":2000},{"$f":"C71*D71","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E67:E71)","v":0}]
["Traffic Items Contingency (XX%)",null,0.05,null,{"$f":"E72*C73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 3 Calculation'!F29*'Alignment 3 Calculation'!F30","v":0},{"$f":"'Total Project Summary'!D74","v":400},{"$f":"C75*D75","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 3 Calculation'!F25*'Alignment 3 Calculation'!F26","v":0},{"$f":"'Total Project Summary'!D75","v":18},{"$f":"C76*D76","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E75:E76)","v":0}]
["Bridge Items Contingency (XX%)",null,0.05,null,{"$f":"E77*C78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 3 Calculation'!J22","v":0},{"$f":"'Total Project Summary'!D79","v":700},{"$f":"C80*D80","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 3 Calculation'!J23","v":0},{"$f":"'Total Project Summary'!D80","v":75000},{"$f":"C81*D81","v":0}]
["MISCELLANEOUS ITEMS NOT IN SPREADSHEET CAN BE ADDED HERE"]
["Saw Cut","LF",null,0,{"$f":"C83*D83","v":0}]
["Demo of Buildings/Clearing Parcels","LS",null,0,{"$f":"C84*D84","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E22+E31+E41+E48+E54+E61+E65+E73+E78","v":0}]
["Mobilization",null,null,null,{"$f":"E12","v":5000}]
["Construction Survey",null,null,null,{"$f":"E13","v":0}]
["Sub-Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E72+E77+E80+E81+E83+E84+E85+E91+E92+E64+E86+E87+E88+E89+E90","v":0}]
["Total ",null,null,null,{"$f":"E97+E94+E12+E13","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E98*D100","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E98<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E98<5000000,0.05,0.1)","v":0.05},{"$f":"E97*D101","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E98+E100+E101)*((1+0.028)^('Alignment 3 Calculation'!B6-'Alignment 3 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 3 Calculation","index":7,"n_rows":104,"n_cols":11,"rows_kept":104,"cut":false,"hidden":false,"merged":[[115,14,119,15],[119,0,119,3],[119,5,119,9],[92,4,92,6],[99,0,100,2],[99,4,99,6],[106,0,106,3],[106,5,106,9],[110,14,113,15],[74,0,74,2],[74,3,97,3],[74,4,74,6],[74,7,97,7],[75,8,97,8],[80,0,80,2],[80,4,80,6],[86,0,86,2],[86,4,86,6],[92,0,92,2],[73,0,73,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,2],[48,3,71,3],[48,4,48,6],[48,7,71,7],[49,8,71,8],[54,0,54,2],[54,4,54,6],[60,0,60,2],[60,4,60,6],[66,0,66,2],[66,4,66,6],[40,8,40,9],[24,8,24,10],[27,4,27,6],[28,8,28,10],[30,0,30,2],[32,4,32,6],[34,0,34,2],[36,8,36,10],[37,4,37,6],[37,8,38,9],[38,0,38,2],[39,8,39,9],[16,8,16,10],[17,8,17,10],[18,4,18,6],[20,8,20,10],[23,0,23,2],[23,4,23,6],[15,8,15,10],[0,3,0,6],[1,3,1,6],[9,0,9,2],[9,4,9,6],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,4,14,6],[14,8,14,10]]}
["Project :  ",{"$f":"'Total Project Summary'!B1:E1","v":"0000-000-000"},null,null,null,null,null,null,"Data Input Required"]
["UPC:",{"$f":"'Total Project Summary'!B2:E2","v":"XXXXX"},null,null,null,null,null,null,"Calculated Information That"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"},null,null,null,null,null,null,"Is Locked"]
["Estimator:",{"$f":"'Total Project Summary'!B4:E4","v":"Name"}]
["Current Year:",2020]
["Proposed Ad Date Year:",2020]
["Construction Duration:",0,"Months"]
[]
[]
["Proposed Full Depth Roadway Typical Section",null,null,null,"Existing Roadway",null,null,null,"Questions to Ask Yourself"]
["Length",0,"ft",null,"Length",0,"ft",null,"Have you requested Pre-Pave. Design?"]
["Number of Lanes",0,null,null,"Rdway Width",0,"ft",null,"Are Multiple GS Standards Required?"]
["Paved Lane Width",0,"ft",null,"Shldr Width",0,"ft",null,"Type of existing material?"]
["Paved Roadway Width",{"$f":"B12*B13","v":0},"ft",null,null,null,null,null,"Is Rock Fill Required"]
["Right Total Shoulder Width",0,"ft",null,"Demolition of Existing Pavement",null,null,null,"What (Run:Rise) are existing cut slopes?"]
["Left Total Shoulder Width",0,"ft",null,"Length",0,"ft",null,"How much right of way will be required?"]
["Right Paved Shoulder Width",0,"ft",null,"Pavement Width",0,"ft",null,"Are there relocations?"]
["Left Paved Shoulder Width",0,"ft",null,null,null,null,null,"Is there stream/wetlands mitigation?"]
["Paved Shoulder Type","Full Pave.Depth",null,null,"Connections"]
["Curb and Gutter Required?","No",null,null,"Connection 1 Length",0,"ft"]
["Length of C&G (if Required) ",0,"ft",null,"Connection 2 Length",0,"ft",null,"Mitigation "]
["% of New Horizontal Alignment",0,null,null,"*Length is added to mainline length",null,null,null,"Stream",0,"LF"]
[null,null,null,null,null,null,null,null,"Wetland",0,"acre"]
["Pavement Design",null,null,null,"Existing Bridge"]
["Surface Mix (SM) Pave. Depth",0,"in",null,"Length",0,"ft",null,"Utility Impacts"]
["Intermediate Mix (IM) Pave. Depth",0,"in",null,"Width",0,"ft",null,"Water",0,"LF"]
["Base Mix (BM) Pave. Depth",0,"in",null,null,null,null,null,"Sewer",0,"LF"]
["No. 21B Stone Depth",0,"in",null,"Proposed Bridge"]
["No. 1 Stone depth",0,"in",null,"Length",0,"ft",null,"Drainage Items"]
[null,null,null,null,"Width",0,"ft",null,"Pipes 18\"-36\"",0,"LF"]
["Overlay Only Sections",null,null,null,"# of FOAs",0,"ea",null,"Pipes > 36\"",0,"LF"]
["Length",0,"ft",null,null,null,null,null,"End Walls for Pipes Over 36\"",0,"ea"]
["Pavement Width",0,"ft",null,"Entrances",null,null,null,"Drop Inlets ",0,"ea"]
[null,null,null,null,"Rural Private",0,"#/project",null,"Concrete Box Culvert Length",0,"LF"]
["Sidewalk",null,null,null,"Urban Private",0,"#/project"]
["Length ",0,"ft",null,"Commercial",0,"#/project"]
["Width ",0,"ft",null,null,null,null,null,"SWM Facility Questions"]
[null,null,null,null,"Retaining Wall RW-3",null,null,null,"How many Drainage Breaks are on the Project?",null,1]
["Traffic Items",null,null,null,"Avg. Height",0,"ft"]
["Guardrail Length",0,"ft",null,"Length",0,"ft",null,"Can SWM Facilities be Avoided?",null,"No"]
["End Treatments",0,"ea",null,"Area",{"$f":"LOOKUP(F39,{0,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,4.83,7.43,10.63,14.43,18.83,23.83,29.43,35.63,42.98,51.03,59.78,69.23,79.38})","v":0},"sf",null,"Land Disturbance/acre",null,{"$f":"(((B50*(IF(B52='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B52<>'Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B52='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B52='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B52='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B52='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B52='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B52='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B52='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B52='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+((B56*(IF(B58='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B58='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B58='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B58='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B58='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B58='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B58='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B58='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B58='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B58='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B62*(IF(B64='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B64='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B64='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B64='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B64='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B64='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B64='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B64='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B64='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B64='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B68*(IF(B70='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B70='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B70='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B70='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B70='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B70='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B70='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B70='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B70='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B70='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+(B76*(IF(B78='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B78='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B78='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B78='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B78='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B78='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B78='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B78='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B78='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B78='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B82*(IF(B84='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B84='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B84='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B84='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B84='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B84='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B84='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B84='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B84='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B84='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B88*(IF(B90='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B90='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B90='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B90='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B90='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B90='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B90='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B90='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B90='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B90='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B94*(IF(B96='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B96='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B96='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B96='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B96='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B96='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B96='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B96='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B96='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B96='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))/43560)+(((($B$15-$F$13)*2*$B$11)+((($B$14-$F$12)*$B$11)))/43560)+(((($B$11*($B$14+$B$15))*$B$22))/43560)","v":0}]
["Permanent Traffic Signal",0,"ea"]
["How complex is MOT?   (0-10)      (See MOT Ranking Tab)",0]
[]
["Earthwork"]
["* Recommend Using Google Earth to Obtain Elevations/Offsets/Profiles"]
["* Cut and Fill Quantities for the Left and Right Sections Are Figured Using a Triangular Calculation. If Using a Rectangular Assumption, Double the \"W\" Value."]
["Fill "]
["Fill Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length of Fill",0,"ft",null,"Length",0,"ft",null,{"$f":"B54+B60+B66+B72+F54+F60+F66+F72","v":0}]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B52,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B51,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B50/100)*B53","v":0},"CY",null,"Total",{"$f":"(F50*F51*F52)/27","v":0},"cu. ft"]
["Fill Section 2",null,null,null,"Mid Section 2"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B58,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B57,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B56/100)*B59","v":0},"CY",null,"Total",{"$f":"(F56*F57*F58)/27","v":0},"cu. ft"]
["Fill Section 3",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B64,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B63,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B62/100)*B65","v":0},"CY",null,"Total",{"$f":"(F62*F63*F64)/27","v":0},"cu. ft"]
["Fill Section 4",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B70,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B69,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B68/100)*B71","v":0},"CY",null,"Total",{"$f":"(F68*F69*F70)/27","v":0},"cu. ft"]
[]
["Cut"]
["Cut Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length",0,"ft",null,"Length",0,"ft",null,{"$f":"B80+B86+B92+B98+F80+F86+F92+F98","v":0}]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B78,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B77,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B76/100)*B79","v":0},"CY",null,"Total",{"$f":"(F76*F77*F78)/27","v":0},"CY"]
["Cut Section 2",null,null,null,"Mid Section 2"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B84,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B83,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B82/100)*B85","v":0},"CY",null,"Total",{"$f":"(F82*F83*F84)/27","v":0},"CY"]
["Cut Section 3",null,null,null,"Mid Section 3"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B90,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B89,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B88/100)*B91","v":0},"CY",null,"Total",{"$f":"(F88*F89*F90)/27","v":0},"CY"]
["Cut Section 4",null,null,null,"Mid Section 4"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 3 Calculation'!B96,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 3 Calculation'!B95,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Section 1 Total",{"$f":"(B94/100)*B97","v":0},"CY",null,"Total",{"$f":"(F94*F95*F96)/27","v":0},"CY"]
[]
["Fills that will be Constructed out of Commercial Rock Material",null,null,null,"Unsuitable Material",null,null,null,"Length:","Length of Section"]
[null,null,null,null,"Length",0,"ft",null,"W:","See Examples"]
["Length",0,"ft",null,"Width",0,"ft",null,"H:","See Examples"]
["W",0,"ft",null,"Depth",0,"ft",null,"* Mid Sections are a Rectangular Calculations"]
["H",0,"ft",null,null,null,null,null,"*Right/Left Sections are Triangular Calculations"]

{"sheet":"Alignment 4 Summary","index":8,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[96,0,96,3],[98,0,98,4],[100,1,100,2],[65,0,65,4],[73,0,73,4],[78,0,78,4],[81,0,81,4],[94,0,94,3],[95,0,95,3],[61,0,61,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[9,0,9,4],[13,0,13,4],[22,0,22,4],[31,0,31,4],[41,0,41,4],[48,0,48,4],[54,0,54,4]]}
["Project :",{"$f":"'Alignment 4 Calculation'!B1","v":"0000-000-000"}]
["UPC:",{"$f":"'Alignment 4 Calculation'!B2","v":"XXXXX"}]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:",{"$f":"'Alignment 4 Calculation'!B4","v":"Name"}]
[]
["For Recent Bid History Click Link"]
["*Unit Prices can be changed in the \"Total Project Summary\" tab. "]
["Those Unit Prices are reflected in the \"Alignment Summaries\" tab."]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E97<=1000000,((E97-200000)*0.075)+20000,((E97-1000000)*0.05)+80000)","v":5000},{"$f":"C12*D12","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E97*0.015,-3)","v":0},{"$f":"C13*D13","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 4 Calculation'!K41","v":0},{"$f":"'Total Project Summary'!D14","v":20000},{"$f":"C15*D15","v":0}]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 4 Calculation'!I76","v":0},{"$f":"'Total Project Summary'!D15","v":17},0]
["BORROW EXCAVATION","CY",{"$f":"IF(('Alignment 4 Calculation'!I76*1.1)>'Alignment 4 Calculation'!I50,0,'Alignment 4 Calculation'!I50-('Alignment 4 Calculation'!I76*1.1))","v":0},{"$f":"'Total Project Summary'!D16","v":15},0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"('Alignment 4 Calculation'!F101*'Alignment 4 Calculation'!F102*'Alignment 4 Calculation'!F103)/27","v":0},{"$f":"'Total Project Summary'!D17","v":17},0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"C18*2.025","v":0},{"$f":"'Total Project Summary'!D18","v":20},0]
["DRY RIPRAP ","TONS",{"$f":"(('Alignment 4 Calculation'!B102*'Alignment 4 Calculation'!B103*'Alignment 4 Calculation'!B104)/27)*2.025","v":0},{"$f":"'Total Project Summary'!D19","v":40},{"$f":"C20*D20","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E15:E20)","v":0}]
["Grading Items Contingency (XX%)",null,0.05,null,{"$f":"E21*C22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 4 Calculation'!J34","v":0},{"$f":"'Total Project Summary'!D23","v":2500},{"$f":"C24*D24","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 4 Calculation'!J30","v":0},{"$f":"'Total Project Summary'!D24","v":125},0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 4 Calculation'!J31","v":0},{"$f":"'Total Project Summary'!D25","v":250},0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 4 Calculation'!J32","v":0},{"$f":"'Total Project Summary'!D26","v":300},0]
["DROP INLETS","EA",{"$f":"'Alignment 4 Calculation'!J33","v":0},{"$f":"'Total Project Summary'!D27","v":1000},0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 4 Calculation'!B21*2","v":0},{"$f":"'Total Project Summary'!D28","v":35},0]
["Sub-Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Drainage Items Contingency (XX%)",null,0.05,null,{"$f":"E30*C31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"(((('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*(('Alignment 4 Calculation'!B14+('Alignment 4 Calculation'!B18+'Alignment 4 Calculation'!B17)))/9))*(('Alignment 4 Calculation'!B25*110)/2000))+((('Alignment 4 Calculation'!B32*'Alignment 4 Calculation'!B33)/9)*220)/2000","v":0},{"$f":"'Total Project Summary'!D32","v":110},{"$f":"C33*D33","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"IF('Alignment 4 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*'Alignment 4 Calculation'!B14)/9)*('Alignment 4 Calculation'!B26*115))/2000),(('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*('Alignment 4 Calculation'!B14+('Alignment 4 Calculation'!B18+'Alignment 4 Calculation'!B17))/9)*('Alignment 4 Calculation'!B26*115)/2000)","v":0},{"$f":"'Total Project Summary'!D33","v":100},0]
["BASE COURSE","TONS",{"$f":"IF('Alignment 4 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*'Alignment 4 Calculation'!B14)/9)*('Alignment 4 Calculation'!B27*115))/2000),(('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*('Alignment 4 Calculation'!B14+('Alignment 4 Calculation'!B18+'Alignment 4 Calculation'!B17))/9)*('Alignment 4 Calculation'!B27*115)/2000)","v":0},{"$f":"'Total Project Summary'!D34","v":90},0]
["SUBBASE COURSE","TONS",{"$f":"IF('Alignment 4 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*('Alignment 4 Calculation'!B14+'Alignment 4 Calculation'!B15+'Alignment 4 Calculation'!B16)*('Alignment 4 Calculation'!B28/12))+(('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*(('Alignment 4 Calculation'!B25+'Alignment 4 Calculation'!B26+'Alignment 4 Calculation'!B27)/12)*('Alignment 4 Calculation'!B15+'Alignment 4 Calculation'!B16)))/27)*2.025),((((('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*('Alignment 4 Calculation'!B14+'Alignment 4 Calculation'!B15+'Alignment 4 Calculation'!B16)*('Alignment 4 Calculation'!B28/12))+(('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*(('Alignment 4 Calculation'!B25+'Alignment 4 Calculation'!B26+'Alignment 4 Calculation'!B27)/12)*(('Alignment 4 Calculation'!B15-'Alignment 4 Calculation'!B17)+('Alignment 4 Calculation'!B16-'Alignment 4 Calculation'!B18))))/27)*2.025))*1.06","v":0},{"$f":"'Total Project Summary'!D35","v":20},0]
["No.1 STONE","TONS",{"$f":"((('Alignment 4 Calculation'!B11+'Alignment 4 Calculation'!F20+'Alignment 4 Calculation'!F21)*('Alignment 4 Calculation'!B14+('Alignment 4 Calculation'!B15*2))*('Alignment 4 Calculation'!B29/12))/27)*2.025","v":0},{"$f":"'Total Project Summary'!D36","v":25},0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"('Alignment 4 Calculation'!F16*'Alignment 4 Calculation'!F17)/9","v":0},{"$f":"'Total Project Summary'!D37","v":10},0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"('Alignment 4 Calculation'!B32*'Alignment 4 Calculation'!B33)/9","v":0},{"$f":"'Total Project Summary'!D38","v":2},0]
["Sub-Total",null,null,null,{"$f":"SUM(E33:E39)","v":0}]
["Pavement Items Contingency (XX%)",null,0.05,null,{"$f":"E40*C41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"('Alignment 4 Calculation'!F40*'Alignment 4 Calculation'!F41)/27","v":0},{"$f":"'Total Project Summary'!D42","v":400},{"$f":"C43*D43","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 4 Calculation'!F34","v":0},{"$f":"'Total Project Summary'!D43","v":2000},{"$f":"C44*D44","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 4 Calculation'!F35","v":0},{"$f":"'Total Project Summary'!D44","v":5000},0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 4 Calculation'!F36","v":0},{"$f":"'Total Project Summary'!D45","v":10000},0]
["Sub-Total",null,null,null,{"$f":"SUM(E43:E46)","v":0}]
["Incidental Items Contingency (XX%)",null,0.05,null,{"$f":"E47*C48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"IF('Alignment 4 Calculation'!B43=0,'MOT Ranking Criteria'!D4,IF('Alignment 4 Calculation'!B43=1,'MOT Ranking Criteria'!D5,IF('Alignment 4 Calculation'!B43=2,'MOT Ranking Criteria'!D6,IF('Alignment 4 Calculation'!B43=3,'MOT Ranking Criteria'!D7,IF('Alignment 4 Calculation'!B43=4,'MOT Ranking Criteria'!D8,IF('Alignment 4 Calculation'!B43=5,'MOT Ranking Criteria'!D9,IF('Alignment 4 Calculation'!B43=6,'MOT Ranking Criteria'!D10,IF('Alignment 4 Calculation'!B43=7,'MOT Ranking Criteria'!D11,IF('Alignment 4 Calculation'!B43=8,'MOT Ranking Criteria'!D12,IF('Alignment 4 Calculation'!B43=9,'MOT Ranking Criteria'!D13,IF('Alignment 4 Calculation'!B43=10,'MOT Ranking Criteria'!D14)))))))))))","v":0},{"$f":"C50*D50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 4 Calculation'!B7","v":0},{"$f":"'Total Project Summary'!D50","v":2000},{"$f":"D51*C51","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 4 Calculation'!B36*'Alignment 4 Calculation'!B37/9","v":0},{"$f":"'Total Project Summary'!D51","v":90},{"$f":"C52*D52","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E50:E52)","v":0}]
["Protective Items Contingency (XX%)",null,0.05,null,{"$f":"E53*C54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA",{"$f":"'Alignment 4 Calculation'!K38","v":1},{"$f":"IF('Alignment 4 Calculation'!K40=\"Yes\",0,IF('Alignment 4 Calculation'!K41>5,250000,IF('Alignment 4 Calculation'!K41>0.75,150000,0)))","v":0},{"$f":"C56*D56","v":0}]
["SEEDING ","LB",{"$f":"ROUNDUP(('Alignment 4 Calculation'!K41*350)*1.6,-2)","v":0},{"$f":"'Total Project Summary'!D56","v":15},{"$f":"C57*D57","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 4 Calculation'!B11*2","v":0},{"$f":"'Total Project Summary'!D57","v":4},{"$f":"C58*D58","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 4 Calculation'!B11/50","v":0},{"$f":"'Total Project Summary'!D58","v":500},{"$f":"C59*D59","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E56:E59)","v":0}]
["E&S Control Items Contingency (XX%)",null,0.05,null,{"$f":"E60*C61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 4 Calculation'!J26+'Alignment 4 Calculation'!J27","v":0},{"$f":"'Total Project Summary'!D62","v":75},{"$f":"C63*D63","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E63:E63)","v":0}]
["Right of Way Contingency (XX%)",null,0.05,null,{"$f":"E64*C65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 4 Calculation'!B42","v":0},{"$f":"'Total Project Summary'!D66","v":300000},{"$f":"C67*D67","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 4 Calculation'!B11*4","v":0},{"$f":"'Total Project Summary'!D67","v":1},{"$f":"C68*D68","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 4 Calculation'!B40","v":0},{"$f":"'Total Project Summary'!D68","v":25},{"$f":"C69*D69","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 4 Calculation'!B41","v":0},{"$f":"'Total Project Summary'!D69","v":2500},{"$f":"C70*D70","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 4 Calculation'!F31","v":0},{"$f":"'Total Project Summary'!D70","v":2000},{"$f":"C71*D71","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E67:E71)","v":0}]
["Traffic Items Contingency (XX%)",null,0.05,null,{"$f":"E72*C73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 4 Calculation'!F29*'Alignment 4 Calculation'!F30","v":0},{"$f":"'Total Project Summary'!D74","v":400},{"$f":"C75*D75","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 4 Calculation'!F25*'Alignment 4 Calculation'!F26","v":0},{"$f":"'Total Project Summary'!D75","v":18},{"$f":"C76*D76","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E75:E76)","v":0}]
["Bridge Items Contingency (XX%)",null,0.05,null,{"$f":"E77*C78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 4 Calculation'!J22","v":0},{"$f":"'Total Project Summary'!D79","v":700},{"$f":"C80*D80","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 4 Calculation'!J23","v":0},{"$f":"'Total Project Summary'!D80","v":75000},{"$f":"C81*D81","v":0}]
["MISCELLANEOUS ITEMS NOT IN SPREADSHEET CAN BE ADDED HERE"]
["Saw Cut","LF",null,0,{"$f":"C83*D83","v":0}]
["Demo of Buildings/Clearing Parcels","LS",null,0,{"$f":"C84*D84","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E22+E31+E41+E48+E54+E61+E65+E73+E78","v":0}]
["Mobilization",null,null,null,{"$f":"E12","v":5000}]
["Construction Survey",null,null,null,{"$f":"E13","v":0}]
["Sub-Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E72+E77+E80+E81+E83+E84+E85+E91+E92+E64+E86+E87+E88+E89+E90","v":0}]
["Total ",null,null,null,{"$f":"E97+E94+E12+E13","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E98*D100","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E98<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E98<5000000,0.05,0.1)","v":0.05},{"$f":"E97*D101","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E98+E100+E101)*((1+0.028)^('Alignment 4 Calculation'!B6-'Alignment 4 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 4 Calculation","index":9,"n_rows":104,"n_cols":11,"rows_kept":104,"cut":false,"hidden":false,"merged":[[115,14,119,15],[119,0,119,3],[119,5,119,9],[92,4,92,6],[99,0,100,2],[99,4,99,6],[106,0,106,3],[106,5,106,9],[110,14,113,15],[74,0,74,2],[74,3,97,3],[74,4,74,6],[74,7,97,7],[75,8,97,8],[80,0,80,2],[80,4,80,6],[86,0,86,2],[86,4,86,6],[92,0,92,2],[73,0,73,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,2],[48,3,71,3],[48,4,48,6],[48,7,71,7],[49,8,71,8],[54,0,54,2],[54,4,54,6],[60,0,60,2],[60,4,60,6],[66,0,66,2],[66,4,66,6],[40,8,40,9],[24,8,24,10],[27,4,27,6],[28,8,28,10],[30,0,30,2],[32,4,32,6],[34,0,34,2],[36,8,36,10],[37,4,37,6],[37,8,38,9],[38,0,38,2],[39,8,39,9],[16,8,16,10],[17,8,17,10],[18,4,18,6],[20,8,20,10],[23,0,23,2],[23,4,23,6],[15,8,15,10],[0,3,0,6],[1,3,1,6],[9,0,9,2],[9,4,9,6],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,4,14,6],[14,8,14,10]]}
["Project :  ",{"$f":"'Total Project Summary'!B1:E1","v":"0000-000-000"},null,null,null,null,null,null,"Data Input Required"]
["UPC:",{"$f":"'Total Project Summary'!B2:E2","v":"XXXXX"},null,null,null,null,null,null,"Calculated Information That"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"},null,null,null,null,null,null,"Is Locked"]
["Estimator:",{"$f":"'Total Project Summary'!B4:E4","v":"Name"}]
["Current Year:",2020]
["Proposed Ad Date Year:",2020]
["Construction Duration:",0,"Months"]
[]
[]
["Proposed Full Depth Roadway Typical Section",null,null,null,"Existing Roadway",null,null,null,"Questions to Ask Yourself"]
["Length",0,"ft",null,"Length",0,"ft",null,"Have you requested Pre-Pave. Design?"]
["Number of Lanes",0,null,null,"Rdway Width",0,"ft",null,"Are Multiple GS Standards Required?"]
["Paved Lane Width",0,"ft",null,"Shldr Width",0,"ft",null,"Type of existing material?"]
["Paved Roadway Width",{"$f":"B12*B13","v":0},"ft",null,null,null,null,null,"Is Rock Fill Required"]
["Right Total Shoulder Width",0,"ft",null,"Demolition of Existing Pavement",null,null,null,"What (Run:Rise) are existing cut slopes?"]
["Left Total Shoulder Width",0,"ft",null,"Length",0,"ft",null,"How much right of way will be required?"]
["Right Paved Shoulder Width",0,"ft",null,"Pavement Width",0,"ft",null,"Are there relocations?"]
["Left Paved Shoulder Width",0,"ft",null,null,null,null,null,"Is there stream/wetlands mitigation?"]
["Paved Shoulder Type","Full Pave.Depth",null,null,"Connections"]
["Curb and Gutter Required?","No",null,null,"Connection 1 Length",0,"ft"]
["Length of C&G (if Required) ",0,"ft",null,"Connection 2 Length",0,"ft",null,"Mitigation "]
["% of New Horizontal Alignment",0,null,null,"*Length is added to mainline length",null,null,null,"Stream",0,"LF"]
[null,null,null,null,null,null,null,null,"Wetland",0,"acre"]
["Pavement Design",null,null,null,"Existing Bridge"]
["Surface Mix (SM) Pave. Depth",0,"in",null,"Length",0,"ft",null,"Utility Impacts"]
["Intermediate Mix (IM) Pave. Depth",0,"in",null,"Width",0,"ft",null,"Water",0,"LF"]
["Base Mix (BM) Pave. Depth",0,"in",null,null,null,null,null,"Sewer",0,"LF"]
["No. 21B Stone Depth",0,"in",null,"Proposed Bridge"]
["No. 1 Stone depth",0,"in",null,"Length",0,"ft",null,"Drainage Items"]
[null,null,null,null,"Width",0,"ft",null,"Pipes 18\"-36\"",0,"LF"]
["Overlay Only Sections",null,null,null,"# of FOAs",0,"ea",null,"Pipes > 36\"",0,"LF"]
["Length",0,"ft",null,null,null,null,null,"End Walls for Pipes Over 36\"",0,"ea"]
["Pavement Width",0,"ft",null,"Entrances",null,null,null,"Drop Inlets ",0,"ea"]
[null,null,null,null,"Rural Private",0,"#/project",null,"Concrete Box Culvert Length",0,"LF"]
["Sidewalk",null,null,null,"Urban Private",0,"#/project"]
["Length ",0,"ft",null,"Commercial",0,"#/project"]
["Width ",0,"ft",null,null,null,null,null,"SWM Facility Questions"]
[null,null,null,null,"Retaining Wall RW-3",null,null,null,"How many Drainage Breaks are on the Project?",null,1]
["Traffic Items",null,null,null,"Avg. Height",0,"ft"]
["Guardrail Length",0,"ft",null,"Length",0,"ft",null,"Can SWM Facilities be Avoided?",null,"No"]
["End Treatments",0,"ea",null,"Area",{"$f":"LOOKUP(F39,{0,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,4.83,7.43,10.63,14.43,18.83,23.83,29.43,35.63,42.98,51.03,59.78,69.23,79.38})","v":0},"sf",null,"Land Disturbance/acre",null,{"$f":"(((B50*(IF(B52='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B52<>'Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B52='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B52='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B52='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B52='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B52='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B52='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B52='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B52='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+((B56*(IF(B58='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B58='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B58='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B58='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B58='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B58='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B58='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B58='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B58='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B58='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B62*(IF(B64='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B64='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B64='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B64='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B64='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B64='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B64='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B64='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B64='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B64='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B68*(IF(B70='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B70='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B70='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B70='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B70='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B70='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B70='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B70='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B70='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B70='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+(B76*(IF(B78='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B78='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B78='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B78='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B78='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B78='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B78='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B78='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B78='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B78='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B82*(IF(B84='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B84='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B84='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B84='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B84='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B84='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B84='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B84='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B84='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B84='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B88*(IF(B90='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B90='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B90='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B90='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B90='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B90='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B90='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B90='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B90='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B90='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B94*(IF(B96='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B96='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B96='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B96='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B96='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B96='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B96='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B96='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B96='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B96='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))/43560)+(((($B$15-$F$13)*2*$B$11)+((($B$14-$F$12)*$B$11)))/43560)+(((($B$11*($B$14+$B$15))*$B$22))/43560)","v":0}]
["Permanent Traffic Signal",0,"ea"]
["How complex is MOT?   (0-10)      (See MOT Ranking Tab)",0]
[]
["Earthwork"]
["* Recommend Using Google Earth to Obtain Elevations/Offsets/Profiles"]
["* Cut and Fill Quantities for the Left and Right Sections Are Figured Using a Triangular Calculation. If Using a Rectangular Assumption, Double the \"W\" Value."]
["Fill "]
["Fill Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length of Fill",0,"ft",null,"Length",0,"ft",null,{"$f":"B54+B60+B66+B72+F54+F60+F66+F72","v":0}]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B52,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B51,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B50/100)*B53","v":0},"CY",null,"Total",{"$f":"(F50*F51*F52)/27","v":0},"cu. ft"]
["Fill Section 2",null,null,null,"Mid Section 2"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B58,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B57,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B56/100)*B59","v":0},"CY",null,"Total",{"$f":"(F56*F57*F58)/27","v":0},"cu. ft"]
["Fill Section 3",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B64,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B63,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B62/100)*B65","v":0},"CY",null,"Total",{"$f":"(F62*F63*F64)/27","v":0},"cu. ft"]
["Fill Section 4",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B70,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B69,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B68/100)*B71","v":0},"CY",null,"Total",{"$f":"(F68*F69*F70)/27","v":0},"cu. ft"]
[]
["Cut"]
["Cut Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length",0,"ft",null,"Length",0,"ft",null,{"$f":"B80+B86+B92+B98+F80+F86+F92+F98","v":0}]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B78,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B77,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B76/100)*B79","v":0},"CY",null,"Total",{"$f":"(F76*F77*F78)/27","v":0},"CY"]
["Cut Section 2",null,null,null,"Mid Section 2"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B84,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B83,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B82/100)*B85","v":0},"CY",null,"Total",{"$f":"(F82*F83*F84)/27","v":0},"CY"]
["Cut Section 3",null,null,null,"Mid Section 3"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B90,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B89,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B88/100)*B91","v":0},"CY",null,"Total",{"$f":"(F88*F89*F90)/27","v":0},"CY"]
["Cut Section 4",null,null,null,"Mid Section 4"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 4 Calculation'!B96,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 4 Calculation'!B95,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Section 1 Total",{"$f":"(B94/100)*B97","v":0},"CY",null,"Total",{"$f":"(F94*F95*F96)/27","v":0},"CY"]
[]
["Fills that will be Constructed out of Commercial Rock Material",null,null,null,"Unsuitable Material",null,null,null,"Length:","Length of Section"]
[null,null,null,null,"Length",0,"ft",null,"W:","See Examples"]
["Length",0,"ft",null,"Width",0,"ft",null,"H:","See Examples"]
["W",0,"ft",null,"Depth",0,"ft",null,"* Mid Sections are a Rectangular Calculations"]
["H",0,"ft",null,null,null,null,null,"*Right/Left Sections are Triangular Calculations"]

{"sheet":"Alignment 5 Summary","index":10,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[96,0,96,3],[98,0,98,4],[100,1,100,2],[65,0,65,4],[73,0,73,4],[78,0,78,4],[81,0,81,4],[94,0,94,3],[95,0,95,3],[61,0,61,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[9,0,9,4],[13,0,13,4],[22,0,22,4],[31,0,31,4],[41,0,41,4],[48,0,48,4],[54,0,54,4]]}
["Project :",{"$f":"'Alignment 5 Calculation'!B1","v":"0000-000-000"}]
["UPC:",{"$f":"'Alignment 5 Calculation'!B2","v":"XXXXX"}]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:",{"$f":"'Alignment 5 Calculation'!B4","v":"Name"}]
[]
["For Recent Bid History Click Link"]
["*Unit Prices can be changed in the \"Total Project Summary\" tab. "]
["Those Unit Prices are reflected in the \"Alignment Summaries\" tab."]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E97<=1000000,((E97-200000)*0.075)+20000,((E97-1000000)*0.05)+80000)","v":5000},{"$f":"C12*D12","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E97*0.015,-3)","v":0},{"$f":"C13*D13","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 5 Calculation'!K41","v":0},{"$f":"'Total Project Summary'!D14","v":20000},{"$f":"C15*D15","v":0}]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 5 Calculation'!I76","v":0},{"$f":"'Total Project Summary'!D15","v":17},0]
["BORROW EXCAVATION","CY",{"$f":"IF(('Alignment 5 Calculation'!I76*1.1)>'Alignment 5 Calculation'!I50,0,'Alignment 5 Calculation'!I50-('Alignment 5 Calculation'!I76*1.1))","v":0},{"$f":"'Total Project Summary'!D16","v":15},0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"('Alignment 5 Calculation'!F101*'Alignment 5 Calculation'!F102*'Alignment 5 Calculation'!F103)/27","v":0},{"$f":"'Total Project Summary'!D17","v":17},0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"C18*2.025","v":0},{"$f":"'Total Project Summary'!D18","v":20},0]
["DRY RIPRAP ","TONS",{"$f":"(('Alignment 5 Calculation'!B102*'Alignment 5 Calculation'!B103*'Alignment 5 Calculation'!B104)/27)*2.025","v":0},{"$f":"'Total Project Summary'!D19","v":40},{"$f":"C20*D20","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E15:E20)","v":0}]
["Grading Items Contingency (XX%)",null,0.05,null,{"$f":"E21*C22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 5 Calculation'!J34","v":0},{"$f":"'Total Project Summary'!D23","v":2500},{"$f":"C24*D24","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 5 Calculation'!J30","v":0},{"$f":"'Total Project Summary'!D24","v":125},0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 5 Calculation'!J31","v":0},{"$f":"'Total Project Summary'!D25","v":250},0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 5 Calculation'!J32","v":0},{"$f":"'Total Project Summary'!D26","v":300},0]
["DROP INLETS","EA",{"$f":"'Alignment 5 Calculation'!J33","v":0},{"$f":"'Total Project Summary'!D27","v":1000},0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 5 Calculation'!B21*2","v":0},{"$f":"'Total Project Summary'!D28","v":35},0]
["Sub-Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Drainage Items Contingency (XX%)",null,0.05,null,{"$f":"E30*C31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"(((('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*(('Alignment 5 Calculation'!B14+('Alignment 5 Calculation'!B18+'Alignment 5 Calculation'!B17)))/9))*(('Alignment 5 Calculation'!B25*110)/2000))+((('Alignment 5 Calculation'!B32*'Alignment 5 Calculation'!B33)/9)*220)/2000","v":0},{"$f":"'Total Project Summary'!D32","v":110},{"$f":"C33*D33","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"IF('Alignment 5 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*'Alignment 5 Calculation'!B14)/9)*('Alignment 5 Calculation'!B26*115))/2000),(('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*('Alignment 5 Calculation'!B14+('Alignment 5 Calculation'!B18+'Alignment 5 Calculation'!B17))/9)*('Alignment 5 Calculation'!B26*115)/2000)","v":0},{"$f":"'Total Project Summary'!D33","v":100},0]
["BASE COURSE","TONS",{"$f":"IF('Alignment 5 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*'Alignment 5 Calculation'!B14)/9)*('Alignment 5 Calculation'!B27*115))/2000),(('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*('Alignment 5 Calculation'!B14+('Alignment 5 Calculation'!B18+'Alignment 5 Calculation'!B17))/9)*('Alignment 5 Calculation'!B27*115)/2000)","v":0},{"$f":"'Total Project Summary'!D34","v":90},0]
["SUBBASE COURSE","TONS",{"$f":"IF('Alignment 5 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*('Alignment 5 Calculation'!B14+'Alignment 5 Calculation'!B15+'Alignment 5 Calculation'!B16)*('Alignment 5 Calculation'!B28/12))+(('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*(('Alignment 5 Calculation'!B25+'Alignment 5 Calculation'!B26+'Alignment 5 Calculation'!B27)/12)*('Alignment 5 Calculation'!B15+'Alignment 5 Calculation'!B16)))/27)*2.025),((((('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*('Alignment 5 Calculation'!B14+'Alignment 5 Calculation'!B15+'Alignment 5 Calculation'!B16)*('Alignment 5 Calculation'!B28/12))+(('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*(('Alignment 5 Calculation'!B25+'Alignment 5 Calculation'!B26+'Alignment 5 Calculation'!B27)/12)*(('Alignment 5 Calculation'!B15-'Alignment 5 Calculation'!B17)+('Alignment 5 Calculation'!B16-'Alignment 5 Calculation'!B18))))/27)*2.025))*1.06","v":0},{"$f":"'Total Project Summary'!D35","v":20},0]
["No.1 STONE","TONS",{"$f":"((('Alignment 5 Calculation'!B11+'Alignment 5 Calculation'!F20+'Alignment 5 Calculation'!F21)*('Alignment 5 Calculation'!B14+('Alignment 5 Calculation'!B15*2))*('Alignment 5 Calculation'!B29/12))/27)*2.025","v":0},{"$f":"'Total Project Summary'!D36","v":25},0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"('Alignment 5 Calculation'!F16*'Alignment 5 Calculation'!F17)/9","v":0},{"$f":"'Total Project Summary'!D37","v":10},0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"('Alignment 5 Calculation'!B32*'Alignment 5 Calculation'!B33)/9","v":0},{"$f":"'Total Project Summary'!D38","v":2},0]
["Sub-Total",null,null,null,{"$f":"SUM(E33:E39)","v":0}]
["Pavement Items Contingency (XX%)",null,0.05,null,{"$f":"E40*C41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"('Alignment 5 Calculation'!F40*'Alignment 5 Calculation'!F41)/27","v":0},{"$f":"'Total Project Summary'!D42","v":400},{"$f":"C43*D43","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 5 Calculation'!F34","v":0},{"$f":"'Total Project Summary'!D43","v":2000},{"$f":"C44*D44","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 5 Calculation'!F35","v":0},{"$f":"'Total Project Summary'!D44","v":5000},0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 5 Calculation'!F36","v":0},{"$f":"'Total Project Summary'!D45","v":10000},0]
["Sub-Total",null,null,null,{"$f":"SUM(E43:E46)","v":0}]
["Incidental Items Contingency (XX%)",null,0.05,null,{"$f":"E47*C48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"IF('Alignment 5 Calculation'!B43=0,'MOT Ranking Criteria'!D4,IF('Alignment 5 Calculation'!B43=1,'MOT Ranking Criteria'!D5,IF('Alignment 5 Calculation'!B43=2,'MOT Ranking Criteria'!D6,IF('Alignment 5 Calculation'!B43=3,'MOT Ranking Criteria'!D7,IF('Alignment 5 Calculation'!B43=4,'MOT Ranking Criteria'!D8,IF('Alignment 5 Calculation'!B43=5,'MOT Ranking Criteria'!D9,IF('Alignment 5 Calculation'!B43=6,'MOT Ranking Criteria'!D10,IF('Alignment 5 Calculation'!B43=7,'MOT Ranking Criteria'!D11,IF('Alignment 5 Calculation'!B43=8,'MOT Ranking Criteria'!D12,IF('Alignment 5 Calculation'!B43=9,'MOT Ranking Criteria'!D13,IF('Alignment 5 Calculation'!B43=10,'MOT Ranking Criteria'!D14)))))))))))","v":0},{"$f":"C50*D50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 5 Calculation'!B7","v":0},{"$f":"'Total Project Summary'!D50","v":2000},{"$f":"D51*C51","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 5 Calculation'!B36*'Alignment 5 Calculation'!B37/9","v":0},{"$f":"'Total Project Summary'!D51","v":90},{"$f":"C52*D52","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E50:E52)","v":0}]
["Protective Items Contingency (XX%)",null,0.05,null,{"$f":"E53*C54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA",{"$f":"'Alignment 5 Calculation'!K38","v":1},{"$f":"IF('Alignment 5 Calculation'!K40=\"Yes\",0,IF('Alignment 5 Calculation'!K41>5,250000,IF('Alignment 5 Calculation'!K41>0.75,150000,0)))","v":0},{"$f":"C56*D56","v":0}]
["SEEDING ","LB",{"$f":"ROUNDUP(('Alignment 5 Calculation'!K41*350)*1.6,-2)","v":0},{"$f":"'Total Project Summary'!D56","v":15},{"$f":"C57*D57","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 5 Calculation'!B11*2","v":0},{"$f":"'Total Project Summary'!D57","v":4},{"$f":"C58*D58","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 5 Calculation'!B11/50","v":0},{"$f":"'Total Project Summary'!D58","v":500},{"$f":"C59*D59","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E56:E59)","v":0}]
["E&S Control Items Contingency (XX%)",null,0.05,null,{"$f":"E60*C61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 5 Calculation'!J26+'Alignment 5 Calculation'!J27","v":0},{"$f":"'Total Project Summary'!D62","v":75},{"$f":"C63*D63","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E63:E63)","v":0}]
["Right of Way Contingency (XX%)",null,0.05,null,{"$f":"E64*C65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 5 Calculation'!B42","v":0},{"$f":"'Total Project Summary'!D66","v":300000},{"$f":"C67*D67","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 5 Calculation'!B11*4","v":0},{"$f":"'Total Project Summary'!D67","v":1},{"$f":"C68*D68","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 5 Calculation'!B40","v":0},{"$f":"'Total Project Summary'!D68","v":25},{"$f":"C69*D69","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 5 Calculation'!B41","v":0},{"$f":"'Total Project Summary'!D69","v":2500},{"$f":"C70*D70","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 5 Calculation'!F31","v":0},{"$f":"'Total Project Summary'!D70","v":2000},{"$f":"C71*D71","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E67:E71)","v":0}]
["Traffic Items Contingency (XX%)",null,0.05,null,{"$f":"E72*C73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 5 Calculation'!F29*'Alignment 5 Calculation'!F30","v":0},{"$f":"'Total Project Summary'!D74","v":400},{"$f":"C75*D75","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 5 Calculation'!F25*'Alignment 5 Calculation'!F26","v":0},{"$f":"'Total Project Summary'!D75","v":18},{"$f":"C76*D76","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E75:E76)","v":0}]
["Bridge Items Contingency (XX%)",null,0.05,null,{"$f":"E77*C78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 5 Calculation'!J22","v":0},{"$f":"'Total Project Summary'!D79","v":700},{"$f":"C80*D80","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 5 Calculation'!J23","v":0},{"$f":"'Total Project Summary'!D80","v":75000},{"$f":"C81*D81","v":0}]
["MISCELLANEOUS ITEMS NOT IN SPREADSHEET CAN BE ADDED HERE"]
["Saw Cut","LF",null,0,{"$f":"C83*D83","v":0}]
["Demo of Buildings/Clearing Parcels","LS",null,0,{"$f":"C84*D84","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E22+E31+E41+E48+E54+E61+E65+E73+E78","v":0}]
["Mobilization",null,null,null,{"$f":"E12","v":5000}]
["Construction Survey",null,null,null,{"$f":"E13","v":0}]
["Sub-Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E72+E77+E80+E81+E83+E84+E85+E91+E92+E64+E86+E87+E88+E89+E90","v":0}]
["Total ",null,null,null,{"$f":"E97+E94+E12+E13","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E98*D100","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E98<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E98<5000000,0.05,0.1)","v":0.05},{"$f":"E97*D101","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E98+E100+E101)*((1+0.028)^('Alignment 5 Calculation'!B6-'Alignment 5 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 5 Calculation","index":11,"n_rows":104,"n_cols":11,"rows_kept":104,"cut":false,"hidden":false,"merged":[[115,14,119,15],[119,0,119,3],[119,5,119,9],[92,4,92,6],[99,0,100,2],[99,4,99,6],[106,0,106,3],[106,5,106,9],[110,14,113,15],[74,0,74,2],[74,3,97,3],[74,4,74,6],[74,7,97,7],[75,8,97,8],[80,0,80,2],[80,4,80,6],[86,0,86,2],[86,4,86,6],[92,0,92,2],[73,0,73,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,2],[48,3,71,3],[48,4,48,6],[48,7,71,7],[49,8,71,8],[54,0,54,2],[54,4,54,6],[60,0,60,2],[60,4,60,6],[66,0,66,2],[66,4,66,6],[40,8,40,9],[24,8,24,10],[27,4,27,6],[28,8,28,10],[30,0,30,2],[32,4,32,6],[34,0,34,2],[36,8,36,10],[37,4,37,6],[37,8,38,9],[38,0,38,2],[39,8,39,9],[16,8,16,10],[17,8,17,10],[18,4,18,6],[20,8,20,10],[23,0,23,2],[23,4,23,6],[15,8,15,10],[0,3,0,6],[1,3,1,6],[9,0,9,2],[9,4,9,6],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,4,14,6],[14,8,14,10]]}
["Project :  ",{"$f":"'Total Project Summary'!B1:E1","v":"0000-000-000"},null,null,null,null,null,null,"Data Input Required"]
["UPC:",{"$f":"'Total Project Summary'!B2:E2","v":"XXXXX"},null,null,null,null,null,null,"Calculated Information That"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"},null,null,null,null,null,null,"Is Locked"]
["Estimator:",{"$f":"'Total Project Summary'!B4:E4","v":"Name"}]
["Current Year:",2020]
["Proposed Ad Date Year:",2020]
["Construction Duration:",0,"Months"]
[]
[]
["Proposed Full Depth Roadway Typical Section",null,null,null,"Existing Roadway",null,null,null,"Questions to Ask Yourself"]
["Length",0,"ft",null,"Length",0,"ft",null,"Have you requested Pre-Pave. Design?"]
["Number of Lanes",0,null,null,"Rdway Width",0,"ft",null,"Are Multiple GS Standards Required?"]
["Paved Lane Width",0,"ft",null,"Shldr Width",0,"ft",null,"Type of existing material?"]
["Paved Roadway Width",{"$f":"B12*B13","v":0},"ft",null,null,null,null,null,"Is Rock Fill Required"]
["Right Total Shoulder Width",0,"ft",null,"Demolition of Existing Pavement",null,null,null,"What (Run:Rise) are existing cut slopes?"]
["Left Total Shoulder Width",0,"ft",null,"Length",0,"ft",null,"How much right of way will be required?"]
["Right Paved Shoulder Width",0,"ft",null,"Pavement Width",0,"ft",null,"Are there relocations?"]
["Left Paved Shoulder Width",0,"ft",null,null,null,null,null,"Is there stream/wetlands mitigation?"]
["Paved Shoulder Type","Full Pave.Depth",null,null,"Connections"]
["Curb and Gutter Required?","No",null,null,"Connection 1 Length",0,"ft"]
["Length of C&G (if Required) ",0,"ft",null,"Connection 2 Length",0,"ft",null,"Mitigation "]
["% of New Horizontal Alignment",0,null,null,"*Length is added to mainline length",null,null,null,"Stream",0,"LF"]
[null,null,null,null,null,null,null,null,"Wetland",0,"acre"]
["Pavement Design",null,null,null,"Existing Bridge"]
["Surface Mix (SM) Pave. Depth",0,"in",null,"Length",0,"ft",null,"Utility Impacts"]
["Intermediate Mix (IM) Pave. Depth",0,"in",null,"Width",0,"ft",null,"Water",0,"LF"]
["Base Mix (BM) Pave. Depth",0,"in",null,null,null,null,null,"Sewer",0,"LF"]
["No. 21B Stone Depth",0,"in",null,"Proposed Bridge"]
["No. 1 Stone depth",0,"in",null,"Length",0,"ft",null,"Drainage Items"]
[null,null,null,null,"Width",0,"ft",null,"Pipes 18\"-36\"",0,"LF"]
["Overlay Only Sections",null,null,null,"# of FOAs",0,"ea",null,"Pipes > 36\"",0,"LF"]
["Length",0,"ft",null,null,null,null,null,"End Walls for Pipes Over 36\"",0,"ea"]
["Pavement Width",0,"ft",null,"Entrances",null,null,null,"Drop Inlets ",0,"ea"]
[null,null,null,null,"Rural Private",0,"#/project",null,"Concrete Box Culvert Length",0,"LF"]
["Sidewalk",null,null,null,"Urban Private",0,"#/project"]
["Length ",0,"ft",null,"Commercial",0,"#/project"]
["Width ",0,"ft",null,null,null,null,null,"SWM Facility Questions"]
[null,null,null,null,"Retaining Wall RW-3",null,null,null,"How many Drainage Breaks are on the Project?",null,1]
["Traffic Items",null,null,null,"Avg. Height",0,"ft"]
["Guardrail Length",0,"ft",null,"Length",0,"ft",null,"Can SWM Facilities be Avoided?",null,"No"]
["End Treatments",0,"ea",null,"Area",{"$f":"LOOKUP(F39,{0,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,4.83,7.43,10.63,14.43,18.83,23.83,29.43,35.63,42.98,51.03,59.78,69.23,79.38})","v":0},"sf",null,"Land Disturbance/acre",null,{"$f":"(((B50*(IF(B52='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B52<>'Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B52='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B52='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B52='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B52='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B52='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B52='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B52='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B52='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+((B56*(IF(B58='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B58='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B58='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B58='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B58='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B58='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B58='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B58='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B58='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B58='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B62*(IF(B64='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B64='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B64='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B64='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B64='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B64='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B64='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B64='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B64='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B64='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B68*(IF(B70='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B70='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B70='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B70='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B70='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B70='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B70='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B70='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B70='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B70='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+(B76*(IF(B78='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B78='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B78='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B78='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B78='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B78='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B78='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B78='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B78='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B78='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B82*(IF(B84='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B84='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B84='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B84='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B84='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B84='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B84='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B84='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B84='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B84='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B88*(IF(B90='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B90='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B90='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B90='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B90='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B90='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B90='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B90='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B90='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B90='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B94*(IF(B96='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B96='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B96='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B96='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B96='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B96='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B96='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B96='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B96='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B96='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))/43560)+(((($B$15-$F$13)*2*$B$11)+((($B$14-$F$12)*$B$11)))/43560)+(((($B$11*($B$14+$B$15))*$B$22))/43560)","v":0}]
["Permanent Traffic Signal",0,"ea"]
["How complex is MOT?   (0-10)      (See MOT Ranking Tab)",0]
[]
["Earthwork"]
["* Recommend Using Google Earth to Obtain Elevations/Offsets/Profiles"]
["* Cut and Fill Quantities for the Left and Right Sections Are Figured Using a Triangular Calculation. If Using a Rectangular Assumption, Double the \"W\" Value."]
["Fill "]
["Fill Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length of Fill",0,"ft",null,"Length",0,"ft",null,{"$f":"B54+B60+B66+B72+F54+F60+F66+F72","v":0}]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B52,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B51,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B50/100)*B53","v":0},"CY",null,"Total",{"$f":"(F50*F51*F52)/27","v":0},"cu. ft"]
["Fill Section 2",null,null,null,"Mid Section 2"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B58,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B57,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B56/100)*B59","v":0},"CY",null,"Total",{"$f":"(F56*F57*F58)/27","v":0},"cu. ft"]
["Fill Section 3",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B64,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B63,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B62/100)*B65","v":0},"CY",null,"Total",{"$f":"(F62*F63*F64)/27","v":0},"cu. ft"]
["Fill Section 4",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B70,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B69,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B68/100)*B71","v":0},"CY",null,"Total",{"$f":"(F68*F69*F70)/27","v":0},"cu. ft"]
[]
["Cut"]
["Cut Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length",0,"ft",null,"Length",0,"ft",null,{"$f":"B80+B86+B92+B98+F80+F86+F92+F98","v":0}]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B78,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B77,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B76/100)*B79","v":0},"CY",null,"Total",{"$f":"(F76*F77*F78)/27","v":0},"CY"]
["Cut Section 2",null,null,null,"Mid Section 2"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B84,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B83,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B82/100)*B85","v":0},"CY",null,"Total",{"$f":"(F82*F83*F84)/27","v":0},"CY"]
["Cut Section 3",null,null,null,"Mid Section 3"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B90,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B89,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B88/100)*B91","v":0},"CY",null,"Total",{"$f":"(F88*F89*F90)/27","v":0},"CY"]
["Cut Section 4",null,null,null,"Mid Section 4"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 5 Calculation'!B96,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 5 Calculation'!B95,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Section 1 Total",{"$f":"(B94/100)*B97","v":0},"CY",null,"Total",{"$f":"(F94*F95*F96)/27","v":0},"CY"]
[]
["Fills that will be Constructed out of Commercial Rock Material",null,null,null,"Unsuitable Material",null,null,null,"Length:","Length of Section"]
[null,null,null,null,"Length",0,"ft",null,"W:","See Examples"]
["Length",0,"ft",null,"Width",0,"ft",null,"H:","See Examples"]
["W",0,"ft",null,"Depth",0,"ft",null,"* Mid Sections are a Rectangular Calculations"]
["H",0,"ft",null,null,null,null,null,"*Right/Left Sections are Triangular Calculations"]

{"sheet":"Alignment 6 Summary","index":12,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[98,0,98,4],[100,1,100,2],[54,0,54,4],[61,0,61,4],[65,0,65,4],[73,0,73,4],[81,0,81,4],[78,0,78,4],[94,0,94,3],[95,0,95,3],[96,0,96,3],[48,0,48,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[9,0,9,4],[13,0,13,4],[22,0,22,4],[31,0,31,4],[41,0,41,4]]}
["Project :",{"$f":"'Alignment 6 Calculation'!B1","v":"0000-000-000"}]
["UPC:",{"$f":"'Alignment 6 Calculation'!B2","v":"XXXXX"}]
["Date:",{"$f":"TODAY()","v":"2020-03-18"}]
["Estimator:",{"$f":"'Alignment 6 Calculation'!B4","v":"Name"}]
[]
["For Recent Bid History Click Link"]
["*Unit Prices can be changed in the \"Total Project Summary\" tab. "]
["Those Unit Prices are reflected in the \"Alignment Summaries\" tab."]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Quantity","Unit Price","Amount"]
["MOBILIZATION ","LS",1,{"$f":"IF(E97<=1000000,((E97-200000)*0.075)+20000,((E97-1000000)*0.05)+80000)","v":5000},{"$f":"C12*D12","v":5000}]
["CONSTRUCTION SURVEYING","LS",1,{"$f":"ROUNDUP(E97*0.015,-3)","v":0},{"$f":"C13*D13","v":0}]
["GRADING ITEMS"]
["CLEARING AND GRUBBING","ACRE",{"$f":"'Alignment 6 Calculation'!K41","v":0},{"$f":"'Total Project Summary'!D14","v":20000},{"$f":"C15*D15","v":0}]
["REGULAR EXCAVATION ","CY",{"$f":"'Alignment 6 Calculation'!I76","v":0},{"$f":"'Total Project Summary'!D15","v":17},0]
["BORROW EXCAVATION","CY",{"$f":"IF(('Alignment 6 Calculation'!I76*1.1)>'Alignment 6 Calculation'!I50,0,'Alignment 6 Calculation'!I50-('Alignment 6 Calculation'!I76*1.1))","v":0},{"$f":"'Total Project Summary'!D16","v":15},0]
["UNSUITABLE MAT'l. (paid as Regular Excav.)","CY",{"$f":"('Alignment 6 Calculation'!F101*'Alignment 6 Calculation'!F102*'Alignment 6 Calculation'!F103)/27","v":0},{"$f":"'Total Project Summary'!D17","v":17},0]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS",{"$f":"C18*2.025","v":0},{"$f":"'Total Project Summary'!D18","v":20},0]
["DRY RIPRAP ","TONS",{"$f":"(('Alignment 6 Calculation'!B102*'Alignment 6 Calculation'!B103*'Alignment 6 Calculation'!B104)/27)*2.025","v":0},{"$f":"'Total Project Summary'!D19","v":40},{"$f":"C20*D20","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E15:E20)","v":0}]
["Grading Items Contingency (XX%)",null,0.05,null,{"$f":"E21*C22","v":0}]
["DRAINAGE ITEMS"]
["CONCRETE BOX CULVERT","LF",{"$f":"'Alignment 6 Calculation'!J34","v":0},{"$f":"'Total Project Summary'!D23","v":2500},{"$f":"C24*D24","v":0}]
["PIPES UNDER 36\" ","LF",{"$f":"'Alignment 6 Calculation'!J30","v":0},{"$f":"'Total Project Summary'!D24","v":125},0]
["PIPES OVER 36\" ","LF",{"$f":"'Alignment 6 Calculation'!J31","v":0},{"$f":"'Total Project Summary'!D25","v":250},0]
["END WALLS FOR PIPES OVER 36\"","EA",{"$f":"'Alignment 6 Calculation'!J32","v":0},{"$f":"'Total Project Summary'!D26","v":300},0]
["DROP INLETS","EA",{"$f":"'Alignment 6 Calculation'!J33","v":0},{"$f":"'Total Project Summary'!D27","v":1000},0]
["CURB AND GUTTER ","LF",{"$f":"'Alignment 6 Calculation'!B21*2","v":0},{"$f":"'Total Project Summary'!D28","v":35},0]
["Sub-Total",null,null,null,{"$f":"SUM(E24:E29)","v":0}]
["Drainage Items Contingency (XX%)",null,0.05,null,{"$f":"E30*C31","v":0}]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS",{"$f":"(((('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*(('Alignment 6 Calculation'!B14+('Alignment 6 Calculation'!B18+'Alignment 6 Calculation'!B17)))/9))*(('Alignment 6 Calculation'!B25*110)/2000))+((('Alignment 6 Calculation'!B32*'Alignment 6 Calculation'!B33)/9)*220)/2000","v":0},{"$f":"'Total Project Summary'!D32","v":110},{"$f":"C33*D33","v":0}]
["INTERMEDIATE COURSE","TONS",{"$f":"IF('Alignment 6 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*'Alignment 6 Calculation'!B14)/9)*('Alignment 6 Calculation'!B26*115))/2000),(('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*('Alignment 6 Calculation'!B14+('Alignment 6 Calculation'!B18+'Alignment 6 Calculation'!B17))/9)*('Alignment 6 Calculation'!B26*115)/2000)","v":0},{"$f":"'Total Project Summary'!D33","v":100},0]
["BASE COURSE","TONS",{"$f":"IF('Alignment 6 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*'Alignment 6 Calculation'!B14)/9)*('Alignment 6 Calculation'!B27*115))/2000),(('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*('Alignment 6 Calculation'!B14+('Alignment 6 Calculation'!B18+'Alignment 6 Calculation'!B17))/9)*('Alignment 6 Calculation'!B27*115)/2000)","v":0},{"$f":"'Total Project Summary'!D34","v":90},0]
["SUBBASE COURSE","TONS",{"$f":"IF('Alignment 6 Calculation'!B19=\"Surface Mix Only\",((((('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*('Alignment 6 Calculation'!B14+'Alignment 6 Calculation'!B15+'Alignment 6 Calculation'!B16)*('Alignment 6 Calculation'!B28/12))+(('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*(('Alignment 6 Calculation'!B25+'Alignment 6 Calculation'!B26+'Alignment 6 Calculation'!B27)/12)*('Alignment 6 Calculation'!B15+'Alignment 6 Calculation'!B16)))/27)*2.025),((((('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*('Alignment 6 Calculation'!B14+'Alignment 6 Calculation'!B15+'Alignment 6 Calculation'!B16)*('Alignment 6 Calculation'!B28/12))+(('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*(('Alignment 6 Calculation'!B25+'Alignment 6 Calculation'!B26+'Alignment 6 Calculation'!B27)/12)*(('Alignment 6 Calculation'!B15-'Alignment 6 Calculation'!B17)+('Alignment 6 Calculation'!B16-'Alignment 6 Calculation'!B18))))/27)*2.025))*1.06","v":0},{"$f":"'Total Project Summary'!D35","v":20},0]
["No.1 STONE","TONS",{"$f":"((('Alignment 6 Calculation'!B11+'Alignment 6 Calculation'!F20+'Alignment 6 Calculation'!F21)*('Alignment 6 Calculation'!B14+('Alignment 6 Calculation'!B15*2))*('Alignment 6 Calculation'!B29/12))/27)*2.025","v":0},{"$f":"'Total Project Summary'!D36","v":25},0]
["DEMOLITON OF PAVEMENT","SY",{"$f":"('Alignment 6 Calculation'!F16*'Alignment 6 Calculation'!F17)/9","v":0},{"$f":"'Total Project Summary'!D37","v":10},0]
["PLANNING 0\"- 2\" FOR OVERLAY SECTION ","SY",{"$f":"('Alignment 6 Calculation'!B32*'Alignment 6 Calculation'!B33)/9","v":0},{"$f":"'Total Project Summary'!D38","v":2},0]
["Sub-Total",null,null,null,{"$f":"SUM(E33:E39)","v":0}]
["Pavement Items Contingency (XX%)",null,0.05,null,{"$f":"E40*C41","v":0}]
["INCIDENTAL ITEMS"]
["RETAINING WALLS (CONC.)","CY",{"$f":"('Alignment 6 Calculation'!F40*'Alignment 6 Calculation'!F41)/27","v":0},{"$f":"'Total Project Summary'!D42","v":400},{"$f":"C43*D43","v":0}]
["RURAL PRIVATE ENTRANCE","EA",{"$f":"'Alignment 6 Calculation'!F34","v":0},{"$f":"'Total Project Summary'!D43","v":2000},{"$f":"C44*D44","v":0}]
["URBAN PRIVATE ENTRANCE","EA",{"$f":"'Alignment 6 Calculation'!F35","v":0},{"$f":"'Total Project Summary'!D44","v":5000},0]
["COMMERCIAL ENTRANCE","EA",{"$f":"'Alignment 6 Calculation'!F36","v":0},{"$f":"'Total Project Summary'!D45","v":10000},0]
["Sub-Total",null,null,null,{"$f":"SUM(E43:E46)","v":0}]
["Incidental Items Contingency (XX%)",null,0.05,null,{"$f":"E47*C48","v":0}]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS",1,{"$f":"IF('Alignment 6 Calculation'!B43=0,'MOT Ranking Criteria'!D4,IF('Alignment 6 Calculation'!B43=1,'MOT Ranking Criteria'!D5,IF('Alignment 6 Calculation'!B43=2,'MOT Ranking Criteria'!D6,IF('Alignment 6 Calculation'!B43=3,'MOT Ranking Criteria'!D7,IF('Alignment 6 Calculation'!B43=4,'MOT Ranking Criteria'!D8,IF('Alignment 6 Calculation'!B43=5,'MOT Ranking Criteria'!D9,IF('Alignment 6 Calculation'!B43=6,'MOT Ranking Criteria'!D10,IF('Alignment 6 Calculation'!B43=7,'MOT Ranking Criteria'!D11,IF('Alignment 6 Calculation'!B43=8,'MOT Ranking Criteria'!D12,IF('Alignment 6 Calculation'!B43=9,'MOT Ranking Criteria'!D13,IF('Alignment 6 Calculation'!B43=10,'MOT Ranking Criteria'!D14)))))))))))","v":0},{"$f":"C50*D50","v":0}]
["FIELD OFFICE","MO",{"$f":"'Alignment 6 Calculation'!B7","v":0},{"$f":"'Total Project Summary'!D50","v":2000},{"$f":"D51*C51","v":0}]
["SIDEWALK ","SY",{"$f":"'Alignment 6 Calculation'!B36*'Alignment 6 Calculation'!B37/9","v":0},{"$f":"'Total Project Summary'!D51","v":90},{"$f":"C52*D52","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E50:E52)","v":0}]
["Protective Items Contingency (XX%)",null,0.05,null,{"$f":"E53*C54","v":0}]
["EROSION CONTROL"]
["STORM WATER MANAGEMENT FACILITY","EA",{"$f":"'Alignment 6 Calculation'!K38","v":1},{"$f":"IF('Alignment 6 Calculation'!K40=\"Yes\",0,IF('Alignment 6 Calculation'!K41>5,250000,IF('Alignment 6 Calculation'!K41>0.75,150000,0)))","v":0},{"$f":"C56*D56","v":0}]
["SEEDING ","LB",{"$f":"ROUNDUP(('Alignment 6 Calculation'!K41*350)*1.6,-2)","v":0},{"$f":"'Total Project Summary'!D56","v":15},{"$f":"C57*D57","v":0}]
["TEMP. SILT FENCE","LF",{"$f":"'Alignment 6 Calculation'!B11*2","v":0},{"$f":"'Total Project Summary'!D57","v":4},{"$f":"C58*D58","v":0}]
["CHECK DAMS TY. I OR II","EA",{"$f":"'Alignment 6 Calculation'!B11/50","v":0},{"$f":"'Total Project Summary'!D58","v":500},{"$f":"C59*D59","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E56:E59)","v":0}]
["E&S Control Items Contingency (XX%)",null,0.05,null,{"$f":"E60*C61","v":0}]
["UTILITIES"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LF",{"$f":"'Alignment 6 Calculation'!J26+'Alignment 6 Calculation'!J27","v":0},{"$f":"'Total Project Summary'!D62","v":75},{"$f":"C63*D63","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E63:E63)","v":0}]
["Right of Way Contingency (XX%)",null,0.05,null,{"$f":"E64*C65","v":0}]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","EA",{"$f":"'Alignment 6 Calculation'!B42","v":0},{"$f":"'Total Project Summary'!D66","v":300000},{"$f":"C67*D67","v":0}]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF",{"$f":"'Alignment 6 Calculation'!B11*4","v":0},{"$f":"'Total Project Summary'!D67","v":1},{"$f":"C68*D68","v":0}]
["GUARDRAIL","LF",{"$f":"'Alignment 6 Calculation'!B40","v":0},{"$f":"'Total Project Summary'!D68","v":25},{"$f":"C69*D69","v":0}]
["GUARDRAIL END TREATMENT","EA",{"$f":"'Alignment 6 Calculation'!B41","v":0},{"$f":"'Total Project Summary'!D69","v":2500},{"$f":"C70*D70","v":0}]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA",{"$f":"'Alignment 6 Calculation'!F31","v":0},{"$f":"'Total Project Summary'!D70","v":2000},{"$f":"C71*D71","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E67:E71)","v":0}]
["Traffic Items Contingency (XX%)",null,0.05,null,{"$f":"E72*C73","v":0}]
["BRIDGE"]
["NS BRIDGE ","SF",{"$f":"'Alignment 6 Calculation'!F29*'Alignment 6 Calculation'!F30","v":0},{"$f":"'Total Project Summary'!D74","v":400},{"$f":"C75*D75","v":0}]
["DEMOLITION OF EXISTING BRIDGE","LS",{"$f":"'Alignment 6 Calculation'!F25*'Alignment 6 Calculation'!F26","v":0},{"$f":"'Total Project Summary'!D75","v":18},{"$f":"C76*D76","v":0}]
["Sub-Total",null,null,null,{"$f":"SUM(E75:E76)","v":0}]
["Bridge Items Contingency (XX%)",null,0.05,null,{"$f":"E77*C78","v":0}]
["STREAM/WETLAND MITIGATION THAT IS INCLUDED IN CONSTRUCTION"]
["Stream Mitigation","LF",{"$f":"'Alignment 6 Calculation'!J22","v":0},{"$f":"'Total Project Summary'!D79","v":700},{"$f":"C80*D80","v":0}]
["Wetland Mitigation","Acre",{"$f":"'Alignment 6 Calculation'!J23","v":0},{"$f":"'Total Project Summary'!D80","v":75000},{"$f":"C81*D81","v":0}]
["MISCELLANEOUS ITEMS NOT IN SPREADSHEET CAN BE ADDED HERE"]
["Saw Cut","LF",null,0,{"$f":"C83*D83","v":0}]
["Demo of Buildings/Clearing Parcels","LS",null,0,{"$f":"C84*D84","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
["Contingency Total",null,null,null,{"$f":"E22+E31+E41+E48+E54+E61+E65+E73+E78","v":0}]
["Mobilization",null,null,null,{"$f":"E12","v":5000}]
["Construction Survey",null,null,null,{"$f":"E13","v":0}]
["Sub-Total",null,null,null,{"$f":"E21+E30+E40+E47+E53+E60+E72+E77+E80+E81+E83+E84+E85+E91+E92+E64+E86+E87+E88+E89+E90","v":0}]
["Total ",null,null,null,{"$f":"E97+E94+E12+E13","v":5000}]
["CEI & CONTIGENCY"]
["CEI OF AT LEAST 12% AS A LUMP SUM ITEM","LS",1,0.12,{"$f":"E98*D100","v":600}]
["PROJECT CONTINGENCY",{"$f":"IF(E98<5000000,\"Tier I\",\"Tier II\")","v":"Tier I"},null,{"$f":"IF(E98<5000000,0.05,0.1)","v":0.05},{"$f":"E97*D101","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"ROUNDUP((E98+E100+E101)*((1+0.028)^('Alignment 6 Calculation'!B6-'Alignment 6 Calculation'!B5)),-4)","v":10000}]
[]
["Summary Notes"]
["Contingency % can be adjusted based on your comfort level with item quantity"]
["Unit prices can be adjusted.  Use current unit prices as a guide"]
["CEI % can be adjusted"]
["Add any additional items that are important to the estimate in Misc. Section"]
["All items in \"green\" are locked"]
["PE or RW cost is not included in this estimate "]
["Cells with RED tabs include comments for clarifications"]

{"sheet":"Alignment 6 Calculation","index":13,"n_rows":104,"n_cols":11,"rows_kept":104,"cut":false,"hidden":false,"merged":[[39,8,39,9],[24,8,24,10],[37,8,38,9],[38,0,38,2],[34,0,34,2],[36,8,36,10],[110,14,113,15],[115,14,119,15],[1,3,1,6],[17,8,17,10],[15,8,15,10],[16,8,16,10],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[20,8,20,10],[28,8,28,10],[40,8,40,9],[14,4,14,6],[0,3,0,6],[48,0,48,2],[48,4,48,6],[9,0,9,2],[9,4,9,6],[37,4,37,6],[47,0,47,8],[46,0,46,8],[44,0,44,8],[45,0,45,8],[30,0,30,2],[23,0,23,2],[23,4,23,6],[27,4,27,6],[32,4,32,6],[18,4,18,6],[99,4,99,6],[54,0,54,2],[54,4,54,6],[86,0,86,2],[80,4,80,6],[86,4,86,6],[74,4,74,6],[92,4,92,6],[74,3,97,3],[66,0,66,2],[66,4,66,6],[49,8,71,8],[48,7,71,7],[48,3,71,3],[73,0,73,8],[119,0,119,3],[119,5,119,9],[74,0,74,2],[80,0,80,2],[92,0,92,2],[75,8,97,8],[74,7,97,7],[106,0,106,3],[106,5,106,9],[99,0,100,2],[60,0,60,2],[60,4,60,6]]}
["Project :  ",{"$f":"'Total Project Summary'!B1:E1","v":"0000-000-000"},null,null,null,null,null,null,"Data Input Required"]
["UPC:",{"$f":"'Total Project Summary'!B2:E2","v":"XXXXX"},null,null,null,null,null,null,"Calculated Information That"]
["Date:",{"$f":"TODAY()","v":"2020-03-18"},null,null,null,null,null,null,"Is Locked"]
["Estimator:",{"$f":"'Total Project Summary'!B4:E4","v":"Name"}]
["Current Year:",2020]
["Proposed Ad Date Year:",2020]
["Construction Duration:",0,"Months"]
[]
[]
["Proposed Full Depth Roadway Typical Section",null,null,null,"Existing Roadway",null,null,null,"Questions to Ask Yourself"]
["Length",0,"ft",null,"Length",0,"ft",null,"Have you requested Pre-Pave. Design?"]
["Number of Lanes",0,null,null,"Rdway Width",0,"ft",null,"Are Multiple GS Standards Required?"]
["Paved Lane Width",0,"ft",null,"Shldr Width",0,"ft",null,"Type of existing material?"]
["Paved Roadway Width",{"$f":"B12*B13","v":0},"ft",null,null,null,null,null,"Is Rock Fill Required"]
["Right Total Shoulder Width",0,"ft",null,"Demolition of Existing Pavement",null,null,null,"What (Run:Rise) are existing cut slopes?"]
["Left Total Shoulder Width",0,"ft",null,"Length",0,"ft",null,"How much right of way will be required?"]
["Right Paved Shoulder Width",0,"ft",null,"Pavement Width",0,"ft",null,"Are there relocations?"]
["Left Paved Shoulder Width",0,"ft",null,null,null,null,null,"Is there stream/wetlands mitigation?"]
["Paved Shoulder Type","Full Pave.Depth",null,null,"Connections"]
["Curb and Gutter Required?","No",null,null,"Connection 1 Length",0,"ft"]
["Length of C&G (if Required) ",0,"ft",null,"Connection 2 Length",0,"ft",null,"Mitigation "]
["% of New Horizontal Alignment",0,null,null,"*Length is added to mainline length",null,null,null,"Stream",0,"LF"]
[null,null,null,null,null,null,null,null,"Wetland",0,"acre"]
["Pavement Design",null,null,null,"Existing Bridge"]
["Surface Mix (SM) Pave. Depth",0,"in",null,"Length",0,"ft",null,"Utility Impacts"]
["Intermediate Mix (IM) Pave. Depth",0,"in",null,"Width",0,"ft",null,"Water",0,"LF"]
["Base Mix (BM) Pave. Depth",0,"in",null,null,null,null,null,"Sewer",0,"LF"]
["No. 21B Stone Depth",0,"in",null,"Proposed Bridge"]
["No. 1 Stone depth",0,"in",null,"Length",0,"ft",null,"Drainage Items"]
[null,null,null,null,"Width",0,"ft",null,"Pipes 18\"-36\"",0,"LF"]
["Overlay Only Sections",null,null,null,"# of FOAs",0,"ea",null,"Pipes > 36\"",0,"LF"]
["Length",0,"ft",null,null,null,null,null,"End Walls for Pipes Over 36\"",0,"ea"]
["Pavement Width",0,"ft",null,"Entrances",null,null,null,"Drop Inlets ",0,"ea"]
[null,null,null,null,"Rural Private",0,"#/project",null,"Concrete Box Culvert Length",0,"LF"]
["Sidewalk",null,null,null,"Urban Private",0,"#/project"]
["Length ",0,"ft",null,"Commercial",0,"#/project"]
["Width ",0,"ft",null,null,null,null,null,"SWM Facility Questions"]
[null,null,null,null,"Retaining Wall RW-3",null,null,null,"How many Drainage Breaks are on the Project?",null,1]
["Traffic Items",null,null,null,"Avg. Height",0,"ft"]
["Guardrail Length",0,"ft",null,"Length",0,"ft",null,"Can SWM Facilities be Avoided?",null,"No"]
["End Treatments",0,"ea",null,"Area",{"$f":"LOOKUP(F39,{0,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,4.83,7.43,10.63,14.43,18.83,23.83,29.43,35.63,42.98,51.03,59.78,69.23,79.38})","v":0},"sf",null,"Land Disturbance/acre",null,{"$f":"(((B50*(IF(B52='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B52<>'Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B52='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B52='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B52='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B52='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B52='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B52='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B52='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B52='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+((B56*(IF(B58='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B58='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B58='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B58='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B58='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B58='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B58='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B58='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B58='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B58='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B62*(IF(B64='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B64='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B64='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B64='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B64='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B64='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B64='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B64='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B64='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B64='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+((B68*(IF(B70='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B70='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B70='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B70='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B70='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B70='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B70='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B70='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B70='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B70='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))+(B76*(IF(B78='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B78='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B78='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B78='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B78='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B78='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B78='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B78='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B78='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B78='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B82*(IF(B84='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B84='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B84='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B84='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B84='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B84='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B84='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B84='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B84='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B84='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B88*(IF(B90='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B90='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B90='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B90='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B90='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B90='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B90='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B90='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B90='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B90='Volume Matrix '!$B$14,'Volume Matrix '!$J$14))))))))))))+(B94*(IF(B96='Volume Matrix '!$B$5,'Volume Matrix '!$J$5,IF(B96='Volume Matrix '!$B$6,'Volume Matrix '!$J$6,IF(B96='Volume Matrix '!$B$7,'Volume Matrix '!$J$7,IF(B96='Volume Matrix '!$B$8,'Volume Matrix '!$J$8,IF(B96='Volume Matrix '!$B$9,'Volume Matrix '!$J$9,IF(B96='Volume Matrix '!$B$10,'Volume Matrix '!J10,IF(B96='Volume Matrix '!$B$11,'Volume Matrix '!$J$11,IF(B96='Volume Matrix '!$B$12,'Volume Matrix '!$J$12,IF(B96='Volume Matrix '!$B$13,'Volume Matrix '!$J$13,IF(B96='Volume Matrix '!$B$14,'Volume Matrix '!$J$14)))))))))))))/43560)+(((($B$15-$F$13)*2*$B$11)+((($B$14-$F$12)*$B$11)))/43560)+(((($B$11*($B$14+$B$15))*$B$22))/43560)","v":0}]
["Permanent Traffic Signal",0,"ea"]
["How complex is MOT?   (0-10)      (See MOT Ranking Tab)",0]
[]
["Earthwork"]
["* Recommend Using Google Earth to Obtain Elevations/Offsets/Profiles"]
["* Cut and Fill Quantities for the Left and Right Sections Are Figured Using a Triangular Calculation. If Using a Rectangular Assumption, Double the \"W\" Value."]
["Fill "]
["Fill Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length of Fill",0,"ft",null,"Length",0,"ft",null,{"$f":"B54+B60+B66+B72+F54+F60+F66+F72","v":0}]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B52,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B51,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B50/100)*B53","v":0},"CY",null,"Total",{"$f":"(F50*F51*F52)/27","v":0},"cu. ft"]
["Fill Section 2",null,null,null,"Mid Section 2"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B58,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B57,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Total",{"$f":"(B56/100)*B59","v":0},"CY",null,"Total",{"$f":"(F56*F57*F58)/27","v":0},"cu. ft"]
["Fill Section 3",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B64,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B63,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B62/100)*B65","v":0},"CY",null,"Total",{"$f":"(F62*F63*F64)/27","v":0},"cu. ft"]
["Fill Section 4",null,null,null,"Mid Section 3"]
["Length of Fill",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Fill - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Fill - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B70,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B69,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Total",{"$f":"(B68/100)*B71","v":0},"CY",null,"Total",{"$f":"(F68*F69*F70)/27","v":0},"cu. ft"]
[]
["Cut"]
["Cut Section 1",null,null,null,"Mid Section 1",null,null,null,"Total (CY)"]
["Length",0,"ft",null,"Length",0,"ft",null,{"$f":"B80+B86+B92+B98+F80+F86+F92+F98","v":0}]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B78,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B77,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B76/100)*B79","v":0},"CY",null,"Total",{"$f":"(F76*F77*F78)/27","v":0},"CY"]
["Cut Section 2",null,null,null,"Mid Section 2"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B84,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B83,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B82/100)*B85","v":0},"CY",null,"Total",{"$f":"(F82*F83*F84)/27","v":0},"CY"]
["Cut Section 3",null,null,null,"Mid Section 3"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","0 - 5'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B90,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B89,'Volume Matrix '!$B$4:$H$4,0))","v":100},"CY"]
["Section 1 Total",{"$f":"(B88/100)*B91","v":0},"CY",null,"Total",{"$f":"(F88*F89*F90)/27","v":0},"CY"]
["Cut Section 4",null,null,null,"Mid Section 4"]
["Length",0,"ft",null,"Length",0,"ft"]
["Distance Shifted into Cut - W","10'-15'","ft",null,"W",{"$f":"B14+B15+B15","v":0},"ft"]
["(Existing Slope) Prop. Height of Cut - D","0' - 10'","ft",null,"D",0,"ft"]
["Volume(CY)/100(LF)",{"$f":"INDEX('Volume Matrix '!$B$4:'Volume Matrix '!$H$14,MATCH('Alignment 6 Calculation'!B96,'Volume Matrix '!$B$4:$B$14,0),MATCH('Alignment 6 Calculation'!B95,'Volume Matrix '!$B$4:$H$4,0))","v":300},"CY"]
["Section 1 Total",{"$f":"(B94/100)*B97","v":0},"CY",null,"Total",{"$f":"(F94*F95*F96)/27","v":0},"CY"]
[]
["Fills that will be Constructed out of Commercial Rock Material",null,null,null,"Unsuitable Material",null,null,null,"Length:","Length of Section"]
[null,null,null,null,"Length",0,"ft",null,"W:","See Examples"]
["Length",0,"ft",null,"Width",0,"ft",null,"H:","See Examples"]
["W",0,"ft",null,"Depth",0,"ft",null,"* Mid Sections are a Rectangular Calculations"]
["H",0,"ft",null,null,null,null,null,"*Right/Left Sections are Triangular Calculations"]

{"sheet":"MOT Ranking Criteria","index":14,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,3],[11,0,12,0],[9,0,10,0],[7,0,8,0],[5,0,6,0],[11,1,12,1],[5,1,6,1],[7,1,8,1],[9,1,10,1]]}
[]
["MOT Rankings"]
["Category","Examples","Category","Cost"]
[null,"No MOT Required",0,0]
["M","Maintenance",1,50000]
["I","Bridge and Approach or Low AADT Roadway Only",2,100000]
[null,null,3,150000]
["II","Complex Bridge and Approach or Medium AADT Roadway Only",4,200000]
[null,null,5,300000]
["III","High AADT on Primary or Urban Roadway Project  < 1 mile",6,500000]
[null,null,7,750000]
["IV","Interstate or High AADT Primary that is > 1 mile",8,1000000]
[null,null,9,2000000]
["V","Mega Project",10,4000000]

{"sheet":"Field Data Collection","index":15,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":false,"merged":[[90,2,90,5],[97,2,97,5],[65,2,65,5],[71,2,71,5],[84,2,84,5],[0,0,0,8],[23,5,24,5],[59,2,59,5],[78,2,78,5],[3,2,3,5]]}
["Field Data Collection Sheet (To Be Used as a Print Out for Data Collection in the Field)"]
[]
["Items Required Before Data Input"]
[null,"Pre-Pavement Design","Pavement Depth"]
[null,null,"SM-12.5","IM-19.0 ","BM-25.0 ","No. 21B  (daylight)"]
[]
[]
[null,"Determine GS Standard","GS- Standard","Lane Width","Avg. Shoulder Width","Ditch Width"]
[]
[]
[]
["1)","Existing Pavement Width?",null,"ft"]
["2)","Existing Shoulder Width?",null,"ft"]
["3)","Proposed Project Length?",null,"ft"]
[]
["4)","Number of Entrances","Rural PE","Urban PE","Commercial"]
[]
[]
["4a)","Size and Length (ft) of Entrance Pipes","Pipe Size","How Many?","Avg. Pipe Length"]
[null,null,"<=36\""]
[null,null,">36\""]
[]
["5)","Size and Length (ft) of Cross Pipes ","Pipe Size","How Many?","Avg. Pipe Length","Drop Inlets (ea)"]
[null,"and/or Storm Sewer Pipes, # of Drop Inlets","<=36\""]
[null,null,">36\""]
[]
["6)","Is there a Box Culvert?","Width (ft)","Height (ft)","Length (ft)"]
[]
[]
["7)","How many Drainage Breaks are on Project?",null,"each"]
["8)","Percent of Roadway Proposed on New Alignment",null,"%"]
[]
["9)","Connection Length (ft)","Connection 1","Connection 2"]
[]
[]
["10)","Guardrail Length",null,"ft"]
["11)","Number of Guardrail End Treatments",null,"each"]
[]
["12)","Existing Bridge","Length","Width"]
[]
[]
["13)","Proposed Bridge Length",null,"ft"]
[]
["14)","Will a RW-3 retaining wall be required?","Length","Height"]
[]
[]
["15)","Is there a Sidewalk Required?","Length","Width"]
[]
[]
["16)","Are there Water and Sewer Line Impacts? How Long?","Water (LF)","Sewer (LF)"]
[]
[]
["17)","Will there be impact to Streams or Wetlands?","Streams (LF)","Wetland (Acre)"]
[null," Included in PE cost unless in Big Sandy watershed"]
[]
["18)","Will a Perm. Traffic Signal be Required? How Many?",null,"each"]
[]
["19)","How complex will MOT be? (See MOT Ranking Criteria)"]
[]
["20)","Will Fill Material be Required? ","Left of Centerline Fill  Sections"]
[null,"             Will it be made of Rock? Or Earthwork?","Section","Length (ft)","W (ft)","Distance (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[null,null,"Mid Sections (Use for Vertical Grade Increase)"]
[null,null,"Section","Length (ft)","W (ft)","Distance (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[null,null,"Right of Centerline Fill Sections"]
[null,null,"Section","Length (ft)","W (ft)","Distance (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[]
["21)","Will Excavation be Required?","Left of Centerline Cut  Sections"]
[null,"              Is Existing Material Rock or Clay?","Section","Length (ft)","W (ft)","Distance (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[null,null,"Mid Sections (Use for Vertical Grade Decrease)"]
[null,null,"Section","Length (ft)","W (ft)","Distance (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[null,null,"Right of Centerline Cut Sections"]
[null,null,"Section","Length (ft)","W (ft)","Distance (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
["22)","Is there potential for Unsuitable Material?"]
[null,null,"Unsuitable Material"]
[null,null,"Section","Length (ft)","W (ft)","Depth (ft)"]
[null,null,1]
[null,null,2]
[null,null,3]

{"sheet":"Item Checklist","index":16,"n_rows":111,"n_cols":3,"rows_kept":111,"cut":false,"hidden":false,"merged":[[0,0,0,2],[106,0,106,2],[2,0,2,2],[77,0,77,2],[86,0,86,2],[101,0,101,2],[13,0,13,2],[4,0,4,2],[41,0,41,2],[48,0,48,2],[54,0,54,2],[67,0,67,2]]}
["Scoping Items Checklist"]
[" FOR USE IN PRE-SCOPING AND SCOPING CONSTRUCTION ESTIMATES"]
["(This is not intended to be a detailed pay item breakdown. It is intended to be tool that assists users in preparing early estimates prior to having developed plans. TRNSPRT should be utilized by the PFI stage.)"]
["ITEM","Unit","Needed on Project (Yes or No)"]
["GRADING ITEMS"]
["MOBILIZATION ","LS"]
["CONSTRUCTION SURVEYING","LS"]
["CLEARING AND GRUBBING","LS"]
["ANTICIPATED REGULAR EXCAVATION ","CY"]
["ANTICIPATED BORROW EXCAVATION","CY"]
["ANTICIPATED MINOR STR. EXCAV. (PIPE & BOX CULVERT)","CY"]
["ANTICIPATED UNSUITABLE MAT'l. (paid as Regular Excav.)","CY"]
["BACKFILL STONE (NO. 1) FOR UNSUITABLE MATL. AREAS","TONS"]
["DRAINAGE ITEMS"]
["BEDDING MATERIAL NO. 25 OR 26","TONS"]
["CONCRETE CLASS A4 BOX CULVERT","CY"]
["CONCRETE CLASS A3 MISC. ","CY"]
["\"EPOXY COATED\"? REINF. STEEL","LB"]
["PIPES UNDER 36\" ","LF"]
["PIPES OVER 36\"","LF"]
["CONC. PIPES UNDER 36\" ","LF"]
["CONC. PIPES OVER 36\"","LF"]
["ALL END SECTIONS ON PLANS","EA"]
["EROSION CONTROL STONE ","TONS"]
["SLOPE DRAINS","EA"]
["STORM WATER MANAGEMENT FACILITY","EA"]
["UNDER DRAINS","LF"]
["SMALL ENDWALLS ","EA"]
["LARGE ENDWALLS","EA"]
["CURB AND GUTTER CG-7","LF"]
["RADIAL CURB AND GUTTER  CG-7","LF"]
["CURB AND GUTTER CG-12 ","EA"]
["CG ENTRANCES","LS"]
["DROP INLETS","EA"]
["PAVED DITCHES (AVERAGE)","SY"]
["REMOVE EXISTING DROP INLET","EA"]
["REMOVE EXISTING ENDWALLS ","EA"]
["SHEET PILING","SF"]
["FLOWABLE BACKFILL","CY"]
["POST INSTALLATION INSPECTION","LF"]
["MANHOLES","LF"]
["PAVEMENT ITEMS"]
["SURFACE COURSE","TONS"]
["INTERMEDIATE COURSE","TONS"]
["BASE COURSE","TONS"]
["SUBBASE COURSE","TONS"]
["SAW CUT","LF"]
["FLEXIBLE PAVEMENT PLANING","SY"]
["INCIDENTAL ITEMS"]
["R/W MONUMENTS","EA"]
["RETAINING WALL EXCAVATION","CY"]
["RETAINING WALLS (CONC.)","CY"]
["FENCING ","LF"]
["CG-12 (LUMP SUM)","EA"]
["PROTECTIVE ITEMS"]
["MAINTENANCE OF TRAFFIC (LUMP SUM)","LS"]
["ALLAYING DUST","HR"]
["OBSCURING ROADWAY","SY"]
["FIELD OFFICE","MO"]
["SIDEWALK ","SY"]
["TRAFFIC BARRIER SERVICE","LF"]
["WARNING LIGHTS","DAY"]
["GR. 2 CHANN. DEVICES","DAY"]
["FLAGGER SERVICE","HR"]
["DEMOLITION OF PAVEMENT","SY"]
["RUMBLE STRIPS","LF"]
["CR. RUN NO. 25 OR 26","TONS"]
["EROSION CONTROL"]
["SEEDING (LUMP SUM)","LS"]
["LIME AND FERTILIZER (LUMP SUM)","LS"]
["DRY RIPRAP","TONS"]
["DEWATERING BASIN (IF REQ'D.)","EA"]
["SILTATION CONTROL EXCAVATION","CY"]
["TEMP. SILT FENCE","LF"]
["TEMP. FILTER BARRIER","LF"]
["GEOTEXTILE FABRIC","SY"]
["CHECK DAMS TY. I OR II","EA"]
["RIGHT OF WAY & UTILITIES"]
["DEMO. OF BUILDING","LS"]
["CLEARING OF PARCELS","LS"]
["WATER LINES","LF"]
["SEWER LINES","LF"]
["GAS LINES","LF"]
["CLOSING OF WELLS","EA"]
["SPRING BOX","EA"]
["BELOW GROUND UTILITIES (LUMP SUM $$$$)","LS"]
["TRAFFIC AND SAFETY"]
["PERMANENT SIGNAL (LUMP SUM)","LS"]
["TEMPORARY SIGNALIZATION (LUMP SUM)","LS"]
["CONSTRUCTION SIGNS","SF"]
["PERMANENT SIGNS","SF"]
["PAVEMENT MARKINGS (IF APPLICABLE)","LF"]
["ERADICATION OF EXISTING PAVEMENT MARKINGS","LF"]
["SNOW PLOW. RAISED PAVE. MARKER","EA"]
["GUARDRAIL GR-2","LF"]
["RADIAL GUARDRAIL GR-2","LF"]
["END TREATMENT GR-9","EA"]
["END TREATMENT GR-6","EA"]
["GR-FOA'S IF BRIDGE IS ON PROJECT","EA"]
["REMOVE EXISTING GUARDRAIL","LF"]
["GR-9 SITE PREP.","EA"]
["BRIDGE"]
["NS BRIDGE (LUMP SUM $) (USE $300 PER S.F.)","SF"]
["COFFERDAMS (IF BRIDGE OR LARGE BOX IS ON PLANS)","EA"]
["DEMOLITION OF EXISTING BRIDGE","LS"]
["APPROACH SLABS","LS"]
["STREAM/WETLAND MITIGATION"]
["Stream Mitigation","LF"]
["Wetland Mitigation","Acre"]
["Stream Mitigation","LF"]
["Wetland Mitigation","Acre"]

{"sheet":"Volume Matrix ","index":17,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,7],[4,0,13,0],[14,2,14,7],[14,0,14,1]]}
[]
[]
["Yardage Calculated by assumeing proposed cut/fill slope = existing"]
[null,null,"0 - 5'","5'-10'","10'-15'","15'-20'","20'-25'","25' +"]
["Height of Cut","0' - 10'",100,200,300,400,500,800,null,10]
[null,"10' - 20'",300,550,800,1100,1400,2100,null,20]
[null,"20' - 30'",450,925,1400,1850,2300,3400,null,30]
[null,"30' - 40'",650,1300,2000,2600,3250,4800,null,40]
[null,"40' - 50'",850,1675,2500,3350,4200,6200,null,50]
[null,"50' - 75'",1150,2300,3500,4650,5800,8700,null,75]
[null,"75' - 100'",1600,3250,4800,6500,8100,12000,null,100]
[null,"100' - 150'",2300,4600,7000,9300,10500,15000,null,150]
[null,"150' - 200'",3250,6500,9725,13000,16200,24300,null,200]
[null,"200' +",4050,8125,12200,16250,20250,30375,null,250]
[null,null,"Cubic Yard/100'"]