{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Backstage","Introduction","ProjectInformation","Freeway","ManagedLanes","GPRoadway","InterchangeGSep","Intersections","Bridge","NonMotorized","Walls","ITS","ROW","Calculations","CalculationSpreadsheet","FinalCostEstimation","ROWDatabase","AssumptionPage","UnitCostSpreadsheet","GDOT_Prices"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":239,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Backstage","index":0,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"flagDeveloperMode",true]
[null,null,null,"stringLastProcessRun"]
[]
[]
[null,null,null,"CHECK BOX REPEATER FLAGS",null,null,"PROCESS SHEET ASSOCIATIONS"]
[null,null,null,"cbPROCESS1",false,null,"shnamPROCESS1","Freeway"]
[null,null,null,"cbPROCESS2",false,null,"shnamPROCESS2","ManagedLanes"]
[null,null,null,"cbPROCESS3",false,null,"shnamPROCESS3","GPRoadway"]
[null,null,null,"cbPROCESS4",false,null,"shnamPROCESS4","InterchangeGSep"]
[null,null,null,"cbPROCESS5",false,null,"shnamPROCESS5","Intersections"]
[null,null,null,"cbPROCESS6",false,null,"shnamPROCESS6","Bridge"]
[null,null,null,"cbPROCESS7",false,null,"shnamPROCESS7","NonMotorized"]
[null,null,null,"cbPROCESS8",false,null,"shnamPROCESS8","Walls"]
[null,null,null,"cbPROCESS9",false,null,"shnamPROCESS9","ITS"]
[null,null,null,"cbPROCESS10",false,null,"shnamPROCESS10","ROW"]
[]
[null,null,null,"PROCESS STATUS FLAGS",null,null,null,null,null,null,"BackPass","Mode",null,null,null,null,null,null,"ReverseOrder"]
[null,null,null,"schPROCESS1",false,null,null,null,null,null,{"$f":"shnamPROCESS10","v":"ROW"},{"$f":"IF(cbPROCESS10,K18,\"Blank\")","v":"Blank"},1,{"$f":"IF(L18<>\"Blank\",M18)","v":false},0,{"$f":"MATCH(O18,$N$18:$N$28,-1)","v":11},{"$f":"COUNT($N$18:$N$28)","v":1},{"$f":"INDEX($P$18:$P$28,Q18)","v":11},{"$f":"IFERROR(INDEX($K$18:$K$28,R18),\"Null\")","v":"ProjectInformation"}]
[null,null,null,"schPROCESS2",false,null,null,null,null,null,{"$f":"shnamPROCESS9","v":"ITS"},{"$f":"IF(cbPROCESS9,K19,\"Blank\")","v":"Blank"},2,false,{"$f":"P18-1","v":10},{"$f":"MATCH(O19,$N$18:$N$28,1)","v":{"$error":"#N/A"}},{"$f":"Q18-1","v":0},{"$error":"#N/A"},"Null"]
[null,null,null,"schPROCESS3",false,null,null,null,null,null,{"$f":"shnamPROCESS8","v":"Walls"},{"$f":"IF(cbPROCESS8,K20,\"Blank\")","v":"Blank"},3,false,{"$error":"#N/A"},{"$error":"#N/A"},-1,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS4",false,null,null,null,null,null,{"$f":"shnamPROCESS7","v":"NonMotorized"},{"$f":"IF(cbPROCESS7,K21,\"Blank\")","v":"Blank"},4,false,{"$error":"#N/A"},{"$error":"#N/A"},-2,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS5",false,null,null,null,null,null,{"$f":"shnamPROCESS6","v":"Bridge"},{"$f":"IF(cbPROCESS6,K22,\"Blank\")","v":"Blank"},5,false,{"$error":"#N/A"},{"$error":"#N/A"},-3,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS6",false,null,null,null,null,null,{"$f":"shnamPROCESS5","v":"Intersections"},{"$f":"IF(cbPROCESS5,K23,\"Blank\")","v":"Blank"},6,false,{"$error":"#N/A"},{"$error":"#N/A"},-4,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS7",false,null,null,null,null,null,{"$f":"shnamPROCESS4","v":"InterchangeGSep"},{"$f":"IF(cbPROCESS4,K24,\"Blank\")","v":"Blank"},7,false,{"$error":"#N/A"},{"$error":"#N/A"},-5,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS8",false,null,null,null,null,null,{"$f":"shnamPROCESS3","v":"GPRoadway"},{"$f":"IF(cbPROCESS3,K25,\"Blank\")","v":"Blank"},8,false,{"$error":"#N/A"},{"$error":"#N/A"},-6,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS9",false,null,null,null,null,null,{"$f":"shnamPROCESS2","v":"ManagedLanes"},{"$f":"IF(cbPROCESS2,K26,\"Blank\")","v":"Blank"},9,false,{"$error":"#N/A"},{"$error":"#N/A"},-7,{"$error":"#VALUE!"},"Null"]
[null,null,null,"schPROCESS10",false,null,null,null,null,null,{"$f":"shnamPROCESS1","v":"Freeway"},{"$f":"IF(cbPROCESS1,K27,\"Blank\")","v":"Blank"},10,{"$f":"IF(L27<>\"Blank\",M27)","v":false},{"$f":"P26-1","v":{"$error":"#N/A"}},{"$f":"MATCH(O27,$N$18:$N$28,1)","v":{"$error":"#N/A"}},{"$f":"Q26-1","v":-8},{"$f":"INDEX($P$18:$P$28,Q27)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($K$18:$K$28,R27),\"Null\")","v":"Null"}]
[null,null,null,null,null,null,null,null,null,null,"ProjectInformation",{"$f":"K28","v":"ProjectInformation"},11,11,{"$error":"#N/A"},{"$error":"#N/A"},-9,{"$error":"#VALUE!"},"Null"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Null"]

{"sheet":"Introduction","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,0,4,17],[19,0,19,17],[13,2,13,3],[13,4,13,11],[14,4,14,11],[15,4,15,11],[11,0,11,17],[12,0,12,17]]}
["ATLANTA REGIONAL COMMISSION"]
["PLANNING LEVEL COST ESTIMATION TOOL"]
[]
[]
["This tool was developed by the ARC for purposes of estimating planning-level, long-range cost estimates for proposed projects including the following 10 elements: \n\n\n"]
["(1) Freeway Widening",null,null,null,null,null,null,null,null,"(6) Bridges"]
["(2) Managed Lanes (HOV, HOT, TOT)                                                              ",null,null,null,null,null,null,null,null,"(7) Non-Motorized Elements (Sidewalks, Trails, Bike Lanes)"]
["(3) General Purpose Roadway Capacity                                                          ",null,null,null,null,null,null,null,null,"(8) Walls (Sound Barrier, Retaining)"]
["(4) Interchanges and Grade Sepearations                                                       ",null,null,null,null,null,null,null,null,"(9) Intelligent Transportation Systems (ITS)                     "]
["(5) Intersection Improvements                                                                         ",null,null,null,null,null,null,null,null,"(10) Right-of-Way Acquisition"]
[]
["The tool provides an approximate cost for a project based on standard and customary elements typically assumed in engineering.  Costs are based upon recent lettings for similar projects and are updated on a quarterly basis.\nThese cost estimates should be regarded as planning-level and preliminary in nature.  Variations from actual project costs will result from additional factors such as design exceptions, value engineering, utility relocation, and environmental impacts.  As projects move forward in the project development process, emerging details will support the refinement of these costs."]
[]
[null,null,"Contact info:",null,"Mr. Dahshi Marshall"]
[null,null,null,null,"404-463-3131"]
[null,null,null,null,"DMarshall@atlantaregional.com"]
[]
[]
["© 2010 Atlanta Regional Commission"]
["DUE TO THEIR CONCEPTUAL NATURE, COST ESTIMATES ARE PRELIMINARY AND SUBJECT TO CHANGE"]

{"sheet":"ProjectInformation","index":2,"n_rows":121,"n_cols":6,"rows_kept":121,"cut":false,"hidden":false,"merged":[[17,1,17,2],[13,4,13,5],[14,4,14,5],[15,4,15,5],[17,4,17,5],[3,0,3,5],[16,4,16,5],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[4,1,4,5]]}
["ATLANTA REGIONAL COMMISSION"]
["PLANNING LEVEL COST ESTIMATION TOOL"]
["Project Information Page"]
["On this page, the user is required to enter the general information of the project, including project name, ID, From/To limit, County and Area Type."]
[]
["Project Name:",null,null,"ARC Project ID/GDOT PI Number:",null,"(if applicable)"]
[]
["From Limit:",null,null,"To Limit:"]
[]
["County:","Hall",null,"Area (Urban/Rural):"]
["Please choose the County from the drop-down list above."]
["PLEASE CHECK ALL ELEMENTS THAT ARE INCLUDED IN THIS PROJECT"]
[]
[null,"Freeway Widening",null,null,"Bridges"]
[null,"Managed Lanes (HOV, HOT, TOT)",null,null,"Non-Motorized Elements (Sidewalks, Trails, Bike Lanes)"]
[null,"General Purpose Roadway Capacity",null,null,"Walls (Noise, Retaining)"]
[null,"Interchanges & Grade Separations",null,null,"Intelligent Transportation Systems (ITS)"]
[null," Intersection Improvements",null,null,"Right-of-Way Acquisition"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"ROWDatabase!B6","v":"Barrow"}]
[{"$f":"ROWDatabase!B7","v":"Bartow"}]
[{"$f":"ROWDatabase!B8","v":"Carroll"}]
[{"$f":"ROWDatabase!B9","v":"Cherokee"}]
[{"$f":"ROWDatabase!B10","v":"Clayton"}]
[{"$f":"ROWDatabase!B11","v":"Cobb"}]
[{"$f":"ROWDatabase!B12","v":"Coweta"}]
[{"$f":"ROWDatabase!B13","v":"DeKalb"}]
[{"$f":"ROWDatabase!B14","v":"Douglas"}]
[{"$f":"ROWDatabase!B15","v":"Fayette"}]
[{"$f":"ROWDatabase!B16","v":"Forsyth"}]
[{"$f":"ROWDatabase!B17","v":"Fulton - North"}]
[{"$f":"ROWDatabase!B18","v":"Fulton - City of Atlanta"}]
[{"$f":"ROWDatabase!B19","v":"Fulton - South"}]
[{"$f":"ROWDatabase!B20","v":"Gwinnett"}]
[{"$f":"ROWDatabase!B21","v":"Hall"}]
[{"$f":"ROWDatabase!B22","v":"Henry"}]
[{"$f":"ROWDatabase!B23","v":"Newton"}]
[{"$f":"ROWDatabase!B24","v":"Paulding"}]
[{"$f":"ROWDatabase!B25","v":"Rockdale"}]
[{"$f":"ROWDatabase!B26","v":"Spalding"}]
[{"$f":"ROWDatabase!B27","v":"Walton"}]

{"sheet":"Freeway","index":3,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,0,44,5],[35,0,35,5],[8,0,8,6],[22,0,22,6],[12,0,12,6],[16,0,16,6],[9,1,9,2],[21,0,21,6]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Freeway"}]
["Freeway Widening",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Please choose the type of Freeway Widening in the following drop-down list."]
["Freeway Widening Type","N/A"]
[null,{"$f":"B10 & \" \" &G7","v":"N/A 0"}]
[]
["Enter length of project and number of lanes in each direction before construction (No Build Condition) and after construction (Build Condition)."]
[null,"No Build Condition","Build Condition",null,null,null,"Length (Mile)"]
["Number of Lanes in each Dir.",0,0,null,null,null,0]
[]
["You can use default per lane-mile cost or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(FreewayDefault=\"Use default per mile cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total Freeway Widening Cost"]
[null,"Use default per mile cost",{"$f":"IF(fr_type_area=$C$53,UnitCostSpreadsheet!E5,IF(fr_type_area=$C$54,UnitCostSpreadsheet!E6,IF(fr_type_area=$C$56,UnitCostSpreadsheet!E8,IF(fr_type_area=$C$57,UnitCostSpreadsheet!E9,UnitCostSpreadsheet!E4))))*I19","v":0},null,null,null,{"$f":"IF(FreewayDefault=\"Use default per mile cost\",C19*(C15-B15)*G15,G45*(C15-B15)*G15)","v":0},null,{"$f":"IF(FreewayDefault=\"Use default per mile cost\",1,0)","v":1}]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per mile unit cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A43,IF(fr_type_area=$C$54,Calculations!E43,IF(fr_type_area=$C$56,Calculations!J43,(IF(fr_type_area=$C$57,Calculations!N43)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B43,IF(fr_type_area=$C$54,Calculations!F43,IF(fr_type_area=$C$56,Calculations!K43,(IF(fr_type_area=$C$57,Calculations!O43)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C43,IF(fr_type_area=$C$54,Calculations!G43,IF(fr_type_area=$C$56,Calculations!L43,(IF(fr_type_area=$C$57,Calculations!P43)))))","v":false},null,{"$f":"IF(AND(D26>0,F26>0)=TRUE,D26*F26,IF(D26>0,D26*E26,IF(F26>0,F26*C26,C26*E26)))","v":0}]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A44,IF(fr_type_area=$C$54,Calculations!E44,IF(fr_type_area=$C$56,Calculations!J44,(IF(fr_type_area=$C$57,Calculations!N44)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B44,IF(fr_type_area=$C$54,Calculations!F44,IF(fr_type_area=$C$56,Calculations!K44,(IF(fr_type_area=$C$57,Calculations!O44)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C44,IF(fr_type_area=$C$54,Calculations!G44,IF(fr_type_area=$C$56,Calculations!L44,(IF(fr_type_area=$C$57,Calculations!P44)))))","v":false},null,{"$f":"IF(AND(D27>0,F27>0)=TRUE,D27*F27,IF(D27>0,D27*E27,IF(F27>0,F27*C27,C27*E27)))","v":0}]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A45,IF(fr_type_area=$C$54,Calculations!E45,IF(fr_type_area=$C$56,Calculations!J45,(IF(fr_type_area=$C$57,Calculations!N45)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B45,IF(fr_type_area=$C$54,Calculations!F45,IF(fr_type_area=$C$56,Calculations!K45,(IF(fr_type_area=$C$57,Calculations!O45)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C45,IF(fr_type_area=$C$54,Calculations!G45,IF(fr_type_area=$C$56,Calculations!L45,(IF(fr_type_area=$C$57,Calculations!P45)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A46,IF(fr_type_area=$C$54,Calculations!E46,IF(fr_type_area=$C$56,Calculations!J46,(IF(fr_type_area=$C$57,Calculations!N46)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B46,IF(fr_type_area=$C$54,Calculations!F46,IF(fr_type_area=$C$56,Calculations!K46,(IF(fr_type_area=$C$57,Calculations!O46)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C46,IF(fr_type_area=$C$54,Calculations!G46,IF(fr_type_area=$C$56,Calculations!L46,(IF(fr_type_area=$C$57,Calculations!P46)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A47,IF(fr_type_area=$C$54,Calculations!E47,IF(fr_type_area=$C$56,Calculations!J47,(IF(fr_type_area=$C$57,Calculations!N47)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B47,IF(fr_type_area=$C$54,Calculations!F47,IF(fr_type_area=$C$56,Calculations!K47,(IF(fr_type_area=$C$57,Calculations!O47)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C47,IF(fr_type_area=$C$54,Calculations!G47,IF(fr_type_area=$C$56,Calculations!L47,(IF(fr_type_area=$C$57,Calculations!P47)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A48,IF(fr_type_area=$C$54,Calculations!E48,IF(fr_type_area=$C$56,Calculations!J48,(IF(fr_type_area=$C$57,Calculations!N48)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B48,IF(fr_type_area=$C$54,Calculations!F48,IF(fr_type_area=$C$56,Calculations!K48,(IF(fr_type_area=$C$57,Calculations!O48)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C48,IF(fr_type_area=$C$54,Calculations!G48,IF(fr_type_area=$C$56,Calculations!L48,(IF(fr_type_area=$C$57,Calculations!P48)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A49,IF(fr_type_area=$C$54,Calculations!E49,IF(fr_type_area=$C$56,Calculations!J49,(IF(fr_type_area=$C$57,Calculations!N49)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B49,IF(fr_type_area=$C$54,Calculations!F49,IF(fr_type_area=$C$56,Calculations!K49,(IF(fr_type_area=$C$57,Calculations!O49)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C49,IF(fr_type_area=$C$54,Calculations!G49,IF(fr_type_area=$C$56,Calculations!L49,(IF(fr_type_area=$C$57,Calculations!P49)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A50,IF(fr_type_area=$C$54,Calculations!E50,IF(fr_type_area=$C$56,Calculations!J50,(IF(fr_type_area=$C$57,Calculations!N50)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B50,IF(fr_type_area=$C$54,Calculations!F50,IF(fr_type_area=$C$56,Calculations!K50,(IF(fr_type_area=$C$57,Calculations!O50)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C50,IF(fr_type_area=$C$54,Calculations!G50,IF(fr_type_area=$C$56,Calculations!L50,(IF(fr_type_area=$C$57,Calculations!P50)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A51,IF(fr_type_area=$C$54,Calculations!E51,IF(fr_type_area=$C$56,Calculations!J51,(IF(fr_type_area=$C$57,Calculations!N51)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B51,IF(fr_type_area=$C$54,Calculations!F51,IF(fr_type_area=$C$56,Calculations!K51,(IF(fr_type_area=$C$57,Calculations!O51)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C51,IF(fr_type_area=$C$54,Calculations!G51,IF(fr_type_area=$C$56,Calculations!L51,(IF(fr_type_area=$C$57,Calculations!P51)))))","v":false},null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A52,IF(fr_type_area=$C$54,Calculations!E52,IF(fr_type_area=$C$56,Calculations!J52,(IF(fr_type_area=$C$57,Calculations!N52)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B52,IF(fr_type_area=$C$54,Calculations!F52,IF(fr_type_area=$C$56,Calculations!K52,(IF(fr_type_area=$C$57,Calculations!O52)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!C52,IF(fr_type_area=$C$54,Calculations!G52,IF(fr_type_area=$C$56,Calculations!L52,(IF(fr_type_area=$C$57,Calculations!P52)))))","v":false},null,0]
["Subtotal = ",null,null,null,null,null,{"$f":"SUM(G26:G35)","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override Percentage",null,"Costs"]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A54,IF(fr_type_area=$C$54,Calculations!E54,IF(fr_type_area=$C$56,Calculations!J54,(IF(fr_type_area=$C$57,Calculations!N54)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B54,IF(fr_type_area=$C$54,Calculations!F54,IF(fr_type_area=$C$56,Calculations!K54,(IF(fr_type_area=$C$57,Calculations!O54)))))","v":false},null,null,null,{"$f":"IF(E38>0, E38*$G$36, C38*$G$36)","v":0}]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A55,IF(fr_type_area=$C$54,Calculations!E55,IF(fr_type_area=$C$56,Calculations!J55,(IF(fr_type_area=$C$57,Calculations!N55)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B55,IF(fr_type_area=$C$54,Calculations!F55,IF(fr_type_area=$C$56,Calculations!K55,(IF(fr_type_area=$C$57,Calculations!O55)))))","v":false},null,null,null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A56,IF(fr_type_area=$C$54,Calculations!E56,IF(fr_type_area=$C$56,Calculations!J56,(IF(fr_type_area=$C$57,Calculations!N56)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B56,IF(fr_type_area=$C$54,Calculations!F56,IF(fr_type_area=$C$56,Calculations!K56,(IF(fr_type_area=$C$57,Calculations!O56)))))","v":false},null,null,null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A57,IF(fr_type_area=$C$54,Calculations!E57,IF(fr_type_area=$C$56,Calculations!J57,(IF(fr_type_area=$C$57,Calculations!N57)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B57,IF(fr_type_area=$C$54,Calculations!F57,IF(fr_type_area=$C$56,Calculations!K57,(IF(fr_type_area=$C$57,Calculations!O57)))))","v":false},null,null,null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A58,IF(fr_type_area=$C$54,Calculations!E58,IF(fr_type_area=$C$56,Calculations!J58,(IF(fr_type_area=$C$57,Calculations!N58)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B58,IF(fr_type_area=$C$54,Calculations!F58,IF(fr_type_area=$C$56,Calculations!K58,(IF(fr_type_area=$C$57,Calculations!O58)))))","v":false},null,null,null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A59,IF(fr_type_area=$C$54,Calculations!E59,IF(fr_type_area=$C$56,Calculations!J59,(IF(fr_type_area=$C$57,Calculations!N59)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B59,IF(fr_type_area=$C$54,Calculations!F59,IF(fr_type_area=$C$56,Calculations!K59,(IF(fr_type_area=$C$57,Calculations!O59)))))","v":false},null,null,null,0]
[{"$f":"IF(fr_type_area=$C$53,Calculations!A60,IF(fr_type_area=$C$54,Calculations!E60,IF(fr_type_area=$C$56,Calculations!J60,(IF(fr_type_area=$C$57,Calculations!N60)))))","v":false},null,{"$f":"IF(fr_type_area=$C$53,Calculations!B60,IF(fr_type_area=$C$54,Calculations!F60,IF(fr_type_area=$C$56,Calculations!K60,(IF(fr_type_area=$C$57,Calculations!O60)))))","v":false},null,null,null,0]
["Sum =",null,null,null,null,null,{"$f":"ROUND(SUM(G38:G44)+G36,-3)","v":0}]
[]
[{"$f":"I47","v":0},{"$f":"J47","v":0},{"$f":"K47","v":0}]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B4","v":"N/A"},{"$f":"UnitCostSpreadsheet!C4","v":" Urban"},{"$f":"UnitCostSpreadsheet!D4","v":"N/A Urban"}]
[{"$f":"UnitCostSpreadsheet!B5","v":"Interstate Widening - Asphalt"},{"$f":"UnitCostSpreadsheet!C5","v":" Urban"},{"$f":"UnitCostSpreadsheet!D5","v":"Interstate Widening - Asphalt Urban"}]
[{"$f":"UnitCostSpreadsheet!B6","v":"Interstate Widening - Concrete"},{"$f":"UnitCostSpreadsheet!C6","v":" Urban"},{"$f":"UnitCostSpreadsheet!D6","v":"Interstate Widening - Concrete Urban"}]
[null,{"$f":"UnitCostSpreadsheet!C7","v":"Rural"},{"$f":"UnitCostSpreadsheet!D7","v":"N/ARural"}]
[null,{"$f":"UnitCostSpreadsheet!C8","v":"Rural"},{"$f":"UnitCostSpreadsheet!D8","v":"Interstate Widening - Asphalt Rural"}]
[null,{"$f":"UnitCostSpreadsheet!C9","v":"Rural"},{"$f":"UnitCostSpreadsheet!D9","v":"Interstate Widening - Concrete Rural"}]

{"sheet":"ManagedLanes","index":4,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,0,8,3],[44,0,44,5],[16,0,16,6],[9,1,9,2],[12,0,12,6],[21,0,21,6],[35,0,35,5],[22,0,22,7]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"ManagedLanes"}]
["Managed Lanes (HOV, HOT, TOT) ",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Please choose the type of managed lane in the following drop-down list."]
["Managed Lane Type","N/A"]
[]
[]
["Enter length of project and number of managed lanes in each direction before construction (No Build Condition) and after construction (Build Condition)."]
[null,"No Build Condition","Build Condition",null,null,null,"Length (Mile)"]
["Managed Lanes in each Dir.",0,0,null,null,null,0]
[]
["You can use default per lane-mile cost or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(MLDefault=\"Use default per mile cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total Managed Lane Cost"]
[null,"Use default per mile cost",{"$f":"IF(ml_type=$C$52,UnitCostSpreadsheet!E11,IF(ml_type=$C$53,UnitCostSpreadsheet!E12,IF(ml_type=$C$54,UnitCostSpreadsheet!E13,IF(ml_type=$C$55,UnitCostSpreadsheet!E14,UnitCostSpreadsheet!E10))))*I19","v":0},null,null,null,{"$f":"IF(MLDefault=\"Use default per mile cost\",C19*(C15-B15)*G15,F45*(C15-B15)*G15)","v":0},null,{"$f":"IF(MLDefault=\"Use default per mile cost\",1,0)","v":1}]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per mile unit cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(ml_type=$C$52,Calculations!A76,IF(ml_type=$C$53,Calculations!E76,IF(ml_type=$C$54,Calculations!I76,IF(ml_type=$C$55,Calculations!M76))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B76,IF(ml_type=$C$53,Calculations!F76,IF(ml_type=$C$54,Calculations!J76,IF(ml_type=$C$55,Calculations!N76))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C76,IF(ml_type=$C$53,Calculations!G76,IF(ml_type=$C$54,Calculations!K76,IF(ml_type=$C$55,Calculations!O76))))","v":false},null,{"$f":"IF(AND(D26>0,F26>0)=TRUE,D26*F26,IF(D26>0,D26*E26,IF(F26>0,F26*C26,C26*E26)))","v":0}]
[{"$f":"IF(ml_type=$C$52,Calculations!A77,IF(ml_type=$C$53,Calculations!E77,IF(ml_type=$C$54,Calculations!I77,IF(ml_type=$C$55,Calculations!M77))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B77,IF(ml_type=$C$53,Calculations!F77,IF(ml_type=$C$54,Calculations!J77,IF(ml_type=$C$55,Calculations!N77))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C77,IF(ml_type=$C$53,Calculations!G77,IF(ml_type=$C$54,Calculations!K77,IF(ml_type=$C$55,Calculations!O77))))","v":false},null,{"$f":"IF(AND(D27>0,F27>0)=TRUE,D27*F27,IF(D27>0,D27*E27,IF(F27>0,F27*C27,C27*E27)))","v":0}]
[{"$f":"IF(ml_type=$C$52,Calculations!A78,IF(ml_type=$C$53,Calculations!E78,IF(ml_type=$C$54,Calculations!I78,IF(ml_type=$C$55,Calculations!M78))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B78,IF(ml_type=$C$53,Calculations!F78,IF(ml_type=$C$54,Calculations!J78,IF(ml_type=$C$55,Calculations!N78))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C78,IF(ml_type=$C$53,Calculations!G78,IF(ml_type=$C$54,Calculations!K78,IF(ml_type=$C$55,Calculations!O78))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A79,IF(ml_type=$C$53,Calculations!E79,IF(ml_type=$C$54,Calculations!I79,IF(ml_type=$C$55,Calculations!M79))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B79,IF(ml_type=$C$53,Calculations!F79,IF(ml_type=$C$54,Calculations!J79,IF(ml_type=$C$55,Calculations!N79))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C79,IF(ml_type=$C$53,Calculations!G79,IF(ml_type=$C$54,Calculations!K79,IF(ml_type=$C$55,Calculations!O79))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A80,IF(ml_type=$C$53,Calculations!E80,IF(ml_type=$C$54,Calculations!I80,IF(ml_type=$C$55,Calculations!M80))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B80,IF(ml_type=$C$53,Calculations!F80,IF(ml_type=$C$54,Calculations!J80,IF(ml_type=$C$55,Calculations!N80))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C80,IF(ml_type=$C$53,Calculations!G80,IF(ml_type=$C$54,Calculations!K80,IF(ml_type=$C$55,Calculations!O80))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A81,IF(ml_type=$C$53,Calculations!E81,IF(ml_type=$C$54,Calculations!I81,IF(ml_type=$C$55,Calculations!M81))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B81,IF(ml_type=$C$53,Calculations!F81,IF(ml_type=$C$54,Calculations!J81,IF(ml_type=$C$55,Calculations!N81))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C81,IF(ml_type=$C$53,Calculations!G81,IF(ml_type=$C$54,Calculations!K81,IF(ml_type=$C$55,Calculations!O81))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A82,IF(ml_type=$C$53,Calculations!E82,IF(ml_type=$C$54,Calculations!I82,IF(ml_type=$C$55,Calculations!M82))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B82,IF(ml_type=$C$53,Calculations!F82,IF(ml_type=$C$54,Calculations!J82,IF(ml_type=$C$55,Calculations!N82))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C82,IF(ml_type=$C$53,Calculations!G82,IF(ml_type=$C$54,Calculations!K82,IF(ml_type=$C$55,Calculations!O82))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A83,IF(ml_type=$C$53,Calculations!E83,IF(ml_type=$C$54,Calculations!I83,IF(ml_type=$C$55,Calculations!M83))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B83,IF(ml_type=$C$53,Calculations!F83,IF(ml_type=$C$54,Calculations!J83,IF(ml_type=$C$55,Calculations!N83))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C83,IF(ml_type=$C$53,Calculations!G83,IF(ml_type=$C$54,Calculations!K83,IF(ml_type=$C$55,Calculations!O83))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A84,IF(ml_type=$C$53,Calculations!E84,IF(ml_type=$C$54,Calculations!I84,IF(ml_type=$C$55,Calculations!M84))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B84,IF(ml_type=$C$53,Calculations!F84,IF(ml_type=$C$54,Calculations!J84,IF(ml_type=$C$55,Calculations!N84))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C84,IF(ml_type=$C$53,Calculations!G84,IF(ml_type=$C$54,Calculations!K84,IF(ml_type=$C$55,Calculations!O84))))","v":false},null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A85,IF(ml_type=$C$53,Calculations!E85,IF(ml_type=$C$54,Calculations!I85,IF(ml_type=$C$55,Calculations!M85))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B85,IF(ml_type=$C$53,Calculations!F85,IF(ml_type=$C$54,Calculations!J85,IF(ml_type=$C$55,Calculations!N85))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!C85,IF(ml_type=$C$53,Calculations!G85,IF(ml_type=$C$54,Calculations!K85,IF(ml_type=$C$55,Calculations!O85))))","v":false},null,0]
["Subtotal = ",null,null,null,null,{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(G26:G35)","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override Percentage",null,"Costs"]
[{"$f":"IF(ml_type=$C$52,Calculations!A87,IF(ml_type=$C$53,Calculations!E87,IF(ml_type=$C$54,Calculations!I87,IF(ml_type=$C$55,Calculations!M87))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B87,IF(ml_type=$C$53,Calculations!F87,IF(ml_type=$C$54,Calculations!J87,IF(ml_type=$C$55,Calculations!N87))))","v":false},null,null,null,{"$f":"IF(E38>0, E38*$F$36, C38*$F$36)","v":0}]
[{"$f":"IF(ml_type=$C$52,Calculations!A88,IF(ml_type=$C$53,Calculations!E88,IF(ml_type=$C$54,Calculations!I88,IF(ml_type=$C$55,Calculations!M88))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B88,IF(ml_type=$C$53,Calculations!F88,IF(ml_type=$C$54,Calculations!J88,IF(ml_type=$C$55,Calculations!N88))))","v":false},null,null,null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A89,IF(ml_type=$C$53,Calculations!E89,IF(ml_type=$C$54,Calculations!I89,IF(ml_type=$C$55,Calculations!M89))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B89,IF(ml_type=$C$53,Calculations!F89,IF(ml_type=$C$54,Calculations!J89,IF(ml_type=$C$55,Calculations!N89))))","v":false},null,null,null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A90,IF(ml_type=$C$53,Calculations!E90,IF(ml_type=$C$54,Calculations!I90,IF(ml_type=$C$55,Calculations!M90))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B90,IF(ml_type=$C$53,Calculations!F90,IF(ml_type=$C$54,Calculations!J90,IF(ml_type=$C$55,Calculations!N90))))","v":false},null,null,null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A91,IF(ml_type=$C$53,Calculations!E91,IF(ml_type=$C$54,Calculations!I91,IF(ml_type=$C$55,Calculations!M91))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B91,IF(ml_type=$C$53,Calculations!F91,IF(ml_type=$C$54,Calculations!J91,IF(ml_type=$C$55,Calculations!N91))))","v":false},null,null,null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A92,IF(ml_type=$C$53,Calculations!E92,IF(ml_type=$C$54,Calculations!I92,IF(ml_type=$C$55,Calculations!M92))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B92,IF(ml_type=$C$53,Calculations!F92,IF(ml_type=$C$54,Calculations!J92,IF(ml_type=$C$55,Calculations!N92))))","v":false},null,null,null,0]
[{"$f":"IF(ml_type=$C$52,Calculations!A93,IF(ml_type=$C$53,Calculations!E93,IF(ml_type=$C$54,Calculations!I93,IF(ml_type=$C$55,Calculations!M93))))","v":false},null,{"$f":"IF(ml_type=$C$52,Calculations!B93,IF(ml_type=$C$53,Calculations!F93,IF(ml_type=$C$54,Calculations!J93,IF(ml_type=$C$55,Calculations!N93))))","v":false},null,null,null,0]
["Sum =",null,null,null,null,{"$f":"ROUND(SUM(G38:G44)+F36,-3)","v":0},{"$f":"ROUND(SUM(G38:G44)+G36,-3)","v":0}]
[]
[{"$f":"I47","v":0},{"$f":"J47","v":0},{"$f":"K47","v":0}]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B10","v":"N/A"},{"$f":"UnitCostSpreadsheet!C10","v":0},{"$f":"UnitCostSpreadsheet!D10","v":"N/A"}]
[{"$f":"UnitCostSpreadsheet!B11","v":"Managed Lane Buffer Separated - Asphalt"},{"$f":"UnitCostSpreadsheet!C11","v":0},{"$f":"UnitCostSpreadsheet!D11","v":"Managed Lane Buffer Separated - Asphalt"}]
[{"$f":"UnitCostSpreadsheet!B12","v":"Managed Lane Buffer Separated - Concrete"},{"$f":"UnitCostSpreadsheet!C12","v":0},{"$f":"UnitCostSpreadsheet!D12","v":"Managed Lane Buffer Separated - Concrete"}]
[{"$f":"UnitCostSpreadsheet!B13","v":"Managed Lane Barrier Separated - Asphalt"},{"$f":"UnitCostSpreadsheet!C13","v":0},{"$f":"UnitCostSpreadsheet!D13","v":"Managed Lane Barrier Separated - Asphalt"}]
[{"$f":"UnitCostSpreadsheet!B14","v":"Managed Lane Barrier Separated - Concrete"},{"$f":"UnitCostSpreadsheet!C14","v":0},{"$f":"UnitCostSpreadsheet!D14","v":"Managed Lane Barrier Separated - Concrete"}]

{"sheet":"GPRoadway","index":5,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[44,0,44,5],[8,0,8,2],[35,0,35,5],[13,0,13,6],[10,1,10,2],[18,0,18,6],[22,0,22,7]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"GPRoadway"}]
["General Purpose Roadway Capacity",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Please choose General Purpose Roadway Capacity type in the following drop-down list."]
[]
["General Purpose Roadway Types","N/A"]
[null,{"$f":"B11 & \" \" &G7","v":"N/A 0"}]
[]
["Enter length of project and number of lanes in each direction before construction (No Build Condition) and after construction (Build Condition)."]
[]
[null,"No Build Condition","Build Condition",null,null,null,"Length (Mile)"]
["Number of Lanes in each Dir.",0,0,null,null,null,0]
[]
["You can use default per lane-mile cost or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(SurStreetDefault=\"Use default per mile cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total General Purpose Roadway Capacity Cost"]
[null,"Use default per mile cost",{"$f":"IF(ss_type_area=$C$53,UnitCostSpreadsheet!E16,IF(ss_type_area=$C$54,UnitCostSpreadsheet!E17,IF(ss_type_area=$C$55,UnitCostSpreadsheet!E18,IF(ss_type_area=$C$56,UnitCostSpreadsheet!E19,IF(ss_type_area=$C$58,UnitCostSpreadsheet!E21,IF(ss_type_area=$C$59,UnitCostSpreadsheet!E22,IF(ss_type_area=$C$60,UnitCostSpreadsheet!E23,IF(ss_type_area=$C$61,UnitCostSpreadsheet!E24,UnitCostSpreadsheet!E15))))))))*I21","v":0},null,null,null,{"$f":"IF(SurStreetDefault=\"Use default per mile cost\",C21*(C17-B17)*G17,F45*(C17-B17)*G17)","v":0},null,{"$f":"IF(SurStreetDefault=\"Use default per mile cost\",1,0)","v":1}]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per mile unit cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A109,IF(ss_type_area=$C$54,Calculations!E109,IF(ss_type_area=$C$55,Calculations!I109,IF(ss_type_area=$C$56,Calculations!M109,IF(ss_type_area=$C$58,Calculations!A141,IF(ss_type_area=$C$59,Calculations!E141,IF(ss_type_area=$C$60,Calculations!I141,IF(ss_type_area=$C$61,Calculations!M141))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B109,IF(ss_type_area=$C$54,Calculations!F109,IF(ss_type_area=$C$55,Calculations!J109,IF(ss_type_area=$C$56,Calculations!N109,IF(ss_type_area=$C$58,Calculations!B141,IF(ss_type_area=$C$59,Calculations!F141,IF(ss_type_area=$C$60,Calculations!J141,IF(ss_type_area=$C$61,Calculations!N141))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C109,IF(ss_type_area=$C$54,Calculations!G109,IF(ss_type_area=$C$55,Calculations!K109,IF(ss_type_area=$C$56,Calculations!O109,IF(ss_type_area=$C$58,Calculations!C141,IF(ss_type_area=$C$59,Calculations!G141,IF(ss_type_area=$C$60,Calculations!K141,IF(ss_type_area=$C$61,Calculations!O141))))))))","v":false},null,{"$f":"IF(AND(D26>0,F26>0)=TRUE,D26*F26,IF(D26>0,D26*E26,IF(F26>0,F26*C26,C26*E26)))","v":0}]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A110,IF(ss_type_area=$C$54,Calculations!E110,IF(ss_type_area=$C$55,Calculations!I110,IF(ss_type_area=$C$56,Calculations!M110,IF(ss_type_area=$C$58,Calculations!A142,IF(ss_type_area=$C$59,Calculations!E142,IF(ss_type_area=$C$60,Calculations!I142,IF(ss_type_area=$C$61,Calculations!M142))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B110,IF(ss_type_area=$C$54,Calculations!F110,IF(ss_type_area=$C$55,Calculations!J110,IF(ss_type_area=$C$56,Calculations!N110,IF(ss_type_area=$C$58,Calculations!B142,IF(ss_type_area=$C$59,Calculations!F142,IF(ss_type_area=$C$60,Calculations!J142,IF(ss_type_area=$C$61,Calculations!N142))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C110,IF(ss_type_area=$C$54,Calculations!G110,IF(ss_type_area=$C$55,Calculations!K110,IF(ss_type_area=$C$56,Calculations!O110,IF(ss_type_area=$C$58,Calculations!C142,IF(ss_type_area=$C$59,Calculations!G142,IF(ss_type_area=$C$60,Calculations!K142,IF(ss_type_area=$C$61,Calculations!O142))))))))","v":false},null,{"$f":"IF(AND(D27>0,F27>0)=TRUE,D27*F27,IF(D27>0,D27*E27,IF(F27>0,F27*C27,C27*E27)))","v":0}]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A111,IF(ss_type_area=$C$54,Calculations!E111,IF(ss_type_area=$C$55,Calculations!I111,IF(ss_type_area=$C$56,Calculations!M111,IF(ss_type_area=$C$58,Calculations!A143,IF(ss_type_area=$C$59,Calculations!E143,IF(ss_type_area=$C$60,Calculations!I143,IF(ss_type_area=$C$61,Calculations!M143))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B111,IF(ss_type_area=$C$54,Calculations!F111,IF(ss_type_area=$C$55,Calculations!J111,IF(ss_type_area=$C$56,Calculations!N111,IF(ss_type_area=$C$58,Calculations!B143,IF(ss_type_area=$C$59,Calculations!F143,IF(ss_type_area=$C$60,Calculations!J143,IF(ss_type_area=$C$61,Calculations!N143))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C111,IF(ss_type_area=$C$54,Calculations!G111,IF(ss_type_area=$C$55,Calculations!K111,IF(ss_type_area=$C$56,Calculations!O111,IF(ss_type_area=$C$58,Calculations!C143,IF(ss_type_area=$C$59,Calculations!G143,IF(ss_type_area=$C$60,Calculations!K143,IF(ss_type_area=$C$61,Calculations!O143))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A112,IF(ss_type_area=$C$54,Calculations!E112,IF(ss_type_area=$C$55,Calculations!I112,IF(ss_type_area=$C$56,Calculations!M112,IF(ss_type_area=$C$58,Calculations!A144,IF(ss_type_area=$C$59,Calculations!E144,IF(ss_type_area=$C$60,Calculations!I144,IF(ss_type_area=$C$61,Calculations!M144))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B112,IF(ss_type_area=$C$54,Calculations!F112,IF(ss_type_area=$C$55,Calculations!J112,IF(ss_type_area=$C$56,Calculations!N112,IF(ss_type_area=$C$58,Calculations!B144,IF(ss_type_area=$C$59,Calculations!F144,IF(ss_type_area=$C$60,Calculations!J144,IF(ss_type_area=$C$61,Calculations!N144))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C112,IF(ss_type_area=$C$54,Calculations!G112,IF(ss_type_area=$C$55,Calculations!K112,IF(ss_type_area=$C$56,Calculations!O112,IF(ss_type_area=$C$58,Calculations!C144,IF(ss_type_area=$C$59,Calculations!G144,IF(ss_type_area=$C$60,Calculations!K144,IF(ss_type_area=$C$61,Calculations!O144))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A113,IF(ss_type_area=$C$54,Calculations!E113,IF(ss_type_area=$C$55,Calculations!I113,IF(ss_type_area=$C$56,Calculations!M113,IF(ss_type_area=$C$58,Calculations!A145,IF(ss_type_area=$C$59,Calculations!E145,IF(ss_type_area=$C$60,Calculations!I145,IF(ss_type_area=$C$61,Calculations!M145))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B113,IF(ss_type_area=$C$54,Calculations!F113,IF(ss_type_area=$C$55,Calculations!J113,IF(ss_type_area=$C$56,Calculations!N113,IF(ss_type_area=$C$58,Calculations!B145,IF(ss_type_area=$C$59,Calculations!F145,IF(ss_type_area=$C$60,Calculations!J145,IF(ss_type_area=$C$61,Calculations!N145))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C113,IF(ss_type_area=$C$54,Calculations!G113,IF(ss_type_area=$C$55,Calculations!K113,IF(ss_type_area=$C$56,Calculations!O113,IF(ss_type_area=$C$58,Calculations!C145,IF(ss_type_area=$C$59,Calculations!G145,IF(ss_type_area=$C$60,Calculations!K145,IF(ss_type_area=$C$61,Calculations!O145))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A114,IF(ss_type_area=$C$54,Calculations!E114,IF(ss_type_area=$C$55,Calculations!I114,IF(ss_type_area=$C$56,Calculations!M114,IF(ss_type_area=$C$58,Calculations!A146,IF(ss_type_area=$C$59,Calculations!E146,IF(ss_type_area=$C$60,Calculations!I146,IF(ss_type_area=$C$61,Calculations!M146))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B114,IF(ss_type_area=$C$54,Calculations!F114,IF(ss_type_area=$C$55,Calculations!J114,IF(ss_type_area=$C$56,Calculations!N114,IF(ss_type_area=$C$58,Calculations!B146,IF(ss_type_area=$C$59,Calculations!F146,IF(ss_type_area=$C$60,Calculations!J146,IF(ss_type_area=$C$61,Calculations!N146))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C114,IF(ss_type_area=$C$54,Calculations!G114,IF(ss_type_area=$C$55,Calculations!K114,IF(ss_type_area=$C$56,Calculations!O114,IF(ss_type_area=$C$58,Calculations!C146,IF(ss_type_area=$C$59,Calculations!G146,IF(ss_type_area=$C$60,Calculations!K146,IF(ss_type_area=$C$61,Calculations!O146))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A115,IF(ss_type_area=$C$54,Calculations!E115,IF(ss_type_area=$C$55,Calculations!I115,IF(ss_type_area=$C$56,Calculations!M115,IF(ss_type_area=$C$58,Calculations!A147,IF(ss_type_area=$C$59,Calculations!E147,IF(ss_type_area=$C$60,Calculations!I147,IF(ss_type_area=$C$61,Calculations!M147))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B115,IF(ss_type_area=$C$54,Calculations!F115,IF(ss_type_area=$C$55,Calculations!J115,IF(ss_type_area=$C$56,Calculations!N115,IF(ss_type_area=$C$58,Calculations!B147,IF(ss_type_area=$C$59,Calculations!F147,IF(ss_type_area=$C$60,Calculations!J147,IF(ss_type_area=$C$61,Calculations!N147))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C115,IF(ss_type_area=$C$54,Calculations!G115,IF(ss_type_area=$C$55,Calculations!K115,IF(ss_type_area=$C$56,Calculations!O115,IF(ss_type_area=$C$58,Calculations!C147,IF(ss_type_area=$C$59,Calculations!G147,IF(ss_type_area=$C$60,Calculations!K147,IF(ss_type_area=$C$61,Calculations!O147))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A116,IF(ss_type_area=$C$54,Calculations!E116,IF(ss_type_area=$C$55,Calculations!I116,IF(ss_type_area=$C$56,Calculations!M116,IF(ss_type_area=$C$58,Calculations!A148,IF(ss_type_area=$C$59,Calculations!E148,IF(ss_type_area=$C$60,Calculations!I148,IF(ss_type_area=$C$61,Calculations!M148))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B116,IF(ss_type_area=$C$54,Calculations!F116,IF(ss_type_area=$C$55,Calculations!J116,IF(ss_type_area=$C$56,Calculations!N116,IF(ss_type_area=$C$58,Calculations!B148,IF(ss_type_area=$C$59,Calculations!F148,IF(ss_type_area=$C$60,Calculations!J148,IF(ss_type_area=$C$61,Calculations!N148))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C116,IF(ss_type_area=$C$54,Calculations!G116,IF(ss_type_area=$C$55,Calculations!K116,IF(ss_type_area=$C$56,Calculations!O116,IF(ss_type_area=$C$58,Calculations!C148,IF(ss_type_area=$C$59,Calculations!G148,IF(ss_type_area=$C$60,Calculations!K148,IF(ss_type_area=$C$61,Calculations!O148))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A117,IF(ss_type_area=$C$54,Calculations!E117,IF(ss_type_area=$C$55,Calculations!I117,IF(ss_type_area=$C$56,Calculations!M117,IF(ss_type_area=$C$58,Calculations!A149,IF(ss_type_area=$C$59,Calculations!E149,IF(ss_type_area=$C$60,Calculations!I149,IF(ss_type_area=$C$61,Calculations!M149))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B117,IF(ss_type_area=$C$54,Calculations!F117,IF(ss_type_area=$C$55,Calculations!J117,IF(ss_type_area=$C$56,Calculations!N117,IF(ss_type_area=$C$58,Calculations!B149,IF(ss_type_area=$C$59,Calculations!F149,IF(ss_type_area=$C$60,Calculations!J149,IF(ss_type_area=$C$61,Calculations!N149))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C117,IF(ss_type_area=$C$54,Calculations!G117,IF(ss_type_area=$C$55,Calculations!K117,IF(ss_type_area=$C$56,Calculations!O117,IF(ss_type_area=$C$58,Calculations!C149,IF(ss_type_area=$C$59,Calculations!G149,IF(ss_type_area=$C$60,Calculations!K149,IF(ss_type_area=$C$61,Calculations!O149))))))))","v":false},null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A118,IF(ss_type_area=$C$54,Calculations!E118,IF(ss_type_area=$C$55,Calculations!I118,IF(ss_type_area=$C$56,Calculations!M118,IF(ss_type_area=$C$58,Calculations!A150,IF(ss_type_area=$C$59,Calculations!E150,IF(ss_type_area=$C$60,Calculations!I150,IF(ss_type_area=$C$61,Calculations!M150))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B118,IF(ss_type_area=$C$54,Calculations!F118,IF(ss_type_area=$C$55,Calculations!J118,IF(ss_type_area=$C$56,Calculations!N118,IF(ss_type_area=$C$58,Calculations!B150,IF(ss_type_area=$C$59,Calculations!F150,IF(ss_type_area=$C$60,Calculations!J150,IF(ss_type_area=$C$61,Calculations!N150))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!C118,IF(ss_type_area=$C$54,Calculations!G118,IF(ss_type_area=$C$55,Calculations!K118,IF(ss_type_area=$C$56,Calculations!O118,IF(ss_type_area=$C$58,Calculations!C150,IF(ss_type_area=$C$59,Calculations!G150,IF(ss_type_area=$C$60,Calculations!K150,IF(ss_type_area=$C$61,Calculations!O150))))))))","v":false},null,0]
["Subtotal = ",null,null,null,null,{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(G26:G35)","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override Percentage",null,"Costs"]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A120,IF(ss_type_area=$C$54,Calculations!E120,IF(ss_type_area=$C$55,Calculations!I120,IF(ss_type_area=$C$56,Calculations!M120,IF(ss_type_area=$C$58,Calculations!A152,IF(ss_type_area=$C$59,Calculations!E152,IF(ss_type_area=$C$60,Calculations!I152,IF(ss_type_area=$C$61,Calculations!M152))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B120,IF(ss_type_area=$C$54,Calculations!F120,IF(ss_type_area=$C$55,Calculations!J120,IF(ss_type_area=$C$56,Calculations!N120,IF(ss_type_area=$C$58,Calculations!B152,IF(ss_type_area=$C$59,Calculations!F152,IF(ss_type_area=$C$60,Calculations!J152,IF(ss_type_area=$C$61,Calculations!N152))))))))","v":false},null,null,null,{"$f":"IF(E38>0, E38*$F$36, C38*$F$36)","v":0}]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A121,IF(ss_type_area=$C$54,Calculations!E121,IF(ss_type_area=$C$55,Calculations!I121,IF(ss_type_area=$C$56,Calculations!M121,IF(ss_type_area=$C$58,Calculations!A153,IF(ss_type_area=$C$59,Calculations!E153,IF(ss_type_area=$C$60,Calculations!I153,IF(ss_type_area=$C$61,Calculations!M153))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B121,IF(ss_type_area=$C$54,Calculations!F121,IF(ss_type_area=$C$55,Calculations!J121,IF(ss_type_area=$C$56,Calculations!N121,IF(ss_type_area=$C$58,Calculations!B153,IF(ss_type_area=$C$59,Calculations!F153,IF(ss_type_area=$C$60,Calculations!J153,IF(ss_type_area=$C$61,Calculations!N153))))))))","v":false},null,null,null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A122,IF(ss_type_area=$C$54,Calculations!E122,IF(ss_type_area=$C$55,Calculations!I122,IF(ss_type_area=$C$56,Calculations!M122,IF(ss_type_area=$C$58,Calculations!A154,IF(ss_type_area=$C$59,Calculations!E154,IF(ss_type_area=$C$60,Calculations!I154,IF(ss_type_area=$C$61,Calculations!M154))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B122,IF(ss_type_area=$C$54,Calculations!F122,IF(ss_type_area=$C$55,Calculations!J122,IF(ss_type_area=$C$56,Calculations!N122,IF(ss_type_area=$C$58,Calculations!B154,IF(ss_type_area=$C$59,Calculations!F154,IF(ss_type_area=$C$60,Calculations!J154,IF(ss_type_area=$C$61,Calculations!N154))))))))","v":false},null,null,null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A123,IF(ss_type_area=$C$54,Calculations!E123,IF(ss_type_area=$C$55,Calculations!I123,IF(ss_type_area=$C$56,Calculations!M123,IF(ss_type_area=$C$58,Calculations!A155,IF(ss_type_area=$C$59,Calculations!E155,IF(ss_type_area=$C$60,Calculations!I155,IF(ss_type_area=$C$61,Calculations!M155))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B123,IF(ss_type_area=$C$54,Calculations!F123,IF(ss_type_area=$C$55,Calculations!J123,IF(ss_type_area=$C$56,Calculations!N123,IF(ss_type_area=$C$58,Calculations!B155,IF(ss_type_area=$C$59,Calculations!F155,IF(ss_type_area=$C$60,Calculations!J155,IF(ss_type_area=$C$61,Calculations!N155))))))))","v":false},null,null,null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A124,IF(ss_type_area=$C$54,Calculations!E124,IF(ss_type_area=$C$55,Calculations!I124,IF(ss_type_area=$C$56,Calculations!M124,IF(ss_type_area=$C$58,Calculations!A156,IF(ss_type_area=$C$59,Calculations!E156,IF(ss_type_area=$C$60,Calculations!I156,IF(ss_type_area=$C$61,Calculations!M156))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B124,IF(ss_type_area=$C$54,Calculations!F124,IF(ss_type_area=$C$55,Calculations!J124,IF(ss_type_area=$C$56,Calculations!N124,IF(ss_type_area=$C$58,Calculations!B156,IF(ss_type_area=$C$59,Calculations!F156,IF(ss_type_area=$C$60,Calculations!J156,IF(ss_type_area=$C$61,Calculations!N156))))))))","v":false},null,null,null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A125,IF(ss_type_area=$C$54,Calculations!E125,IF(ss_type_area=$C$55,Calculations!I125,IF(ss_type_area=$C$56,Calculations!M125,IF(ss_type_area=$C$58,Calculations!A157,IF(ss_type_area=$C$59,Calculations!E157,IF(ss_type_area=$C$60,Calculations!I157,IF(ss_type_area=$C$61,Calculations!M157))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B125,IF(ss_type_area=$C$54,Calculations!F125,IF(ss_type_area=$C$55,Calculations!J125,IF(ss_type_area=$C$56,Calculations!N125,IF(ss_type_area=$C$58,Calculations!B157,IF(ss_type_area=$C$59,Calculations!F157,IF(ss_type_area=$C$60,Calculations!J157,IF(ss_type_area=$C$61,Calculations!N157))))))))","v":false},null,null,null,0]
[{"$f":"IF(ss_type_area=$C$53,Calculations!A126,IF(ss_type_area=$C$54,Calculations!E126,IF(ss_type_area=$C$55,Calculations!I126,IF(ss_type_area=$C$56,Calculations!M126,IF(ss_type_area=$C$58,Calculations!A158,IF(ss_type_area=$C$59,Calculations!E158,IF(ss_type_area=$C$60,Calculations!I158,IF(ss_type_area=$C$61,Calculations!M158))))))))","v":false},null,{"$f":"IF(ss_type_area=$C$53,Calculations!B126,IF(ss_type_area=$C$54,Calculations!F126,IF(ss_type_area=$C$55,Calculations!J126,IF(ss_type_area=$C$56,Calculations!N126,IF(ss_type_area=$C$58,Calculations!B158,IF(ss_type_area=$C$59,Calculations!F158,IF(ss_type_area=$C$60,Calculations!J158,IF(ss_type_area=$C$61,Calculations!N158))))))))","v":false},null,null,null,0]
["Sum =",null,null,null,null,{"$f":"ROUND(SUM(G38:G44)+F36,-3)","v":0},{"$f":"ROUND(SUM(G38:G44)+G36,-3)","v":0}]
[]
[{"$f":"I47","v":0},{"$f":"J47","v":0},{"$f":"K47","v":0}]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B15","v":"N/A"},{"$f":"UnitCostSpreadsheet!C15","v":" Urban"},{"$f":"UnitCostSpreadsheet!D15","v":"N/A Urban"}]
[{"$f":"UnitCostSpreadsheet!B16","v":"General Purpose Roadway Widening with Median"},{"$f":"UnitCostSpreadsheet!C16","v":" Urban"},{"$f":"UnitCostSpreadsheet!D16","v":"General Purpose Roadway Widening with Median Urban"}]
[{"$f":"UnitCostSpreadsheet!B17","v":"General Purpose Roadway Widening without Median"},{"$f":"UnitCostSpreadsheet!C17","v":" Urban"},{"$f":"UnitCostSpreadsheet!D17","v":"General Purpose Roadway Widening without Median Urban"}]
[{"$f":"UnitCostSpreadsheet!B18","v":"New Alignments"},{"$f":"UnitCostSpreadsheet!C18","v":" Urban"},{"$f":"UnitCostSpreadsheet!D18","v":"New Alignments Urban"}]
[{"$f":"UnitCostSpreadsheet!B19","v":"Frontage Rd / Passing Lanes"},{"$f":"UnitCostSpreadsheet!C19","v":" Urban"},{"$f":"UnitCostSpreadsheet!D19","v":"Frontage Rd / Passing Lanes Urban"}]
[null,{"$f":"UnitCostSpreadsheet!C20","v":" Rural"},{"$f":"UnitCostSpreadsheet!D20","v":"N/A Rural"}]
[null,{"$f":"UnitCostSpreadsheet!C21","v":" Rural"},{"$f":"UnitCostSpreadsheet!D21","v":"General Purpose Roadway Widening with Median Rural"}]
[null,{"$f":"UnitCostSpreadsheet!C22","v":" Rural"},{"$f":"UnitCostSpreadsheet!D22","v":"General Purpose Roadway Widening without Median Rural"}]
[null,{"$f":"UnitCostSpreadsheet!C23","v":" Rural"},{"$f":"UnitCostSpreadsheet!D23","v":"New Alignments Rural"}]
[null,{"$f":"UnitCostSpreadsheet!C24","v":" Rural"},{"$f":"UnitCostSpreadsheet!D24","v":"Frontage Rd / Passing Lanes Rural"}]

{"sheet":"InterchangeGSep","index":6,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[8,0,8,3],[55,0,55,5],[56,0,56,5],[44,0,44,5],[10,0,10,1],[35,0,35,5],[22,0,22,6],[12,0,12,6]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"InterchangeGSep"}]
["Interchanges & Grade Separations",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Please select interchange types and enter number of interchanges to be built as part of the project."]
["Interchanges & Grade Separations Type",null,null,null,null,null,"# of Interchanges\n/Grade Separations"]
["N/A",null,null,null,null,null,0]
[]
["You can use default interchange costs or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(IntGDefault=\"Use default per unit cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total Interchange Cost"]
[null,"Use default per unit cost",{"$f":"IF(intg_type=$C$76,UnitCostSpreadsheet!E26,IF(intg_type=$C$77,UnitCostSpreadsheet!E27,IF(intg_type=$C$78,UnitCostSpreadsheet!E28,IF(intg_type=$C$79,UnitCostSpreadsheet!E29,IF(intg_type=$C$80,UnitCostSpreadsheet!E30,IF(intg_type=$C$81,UnitCostSpreadsheet!E31,IF(intg_type=$C$82,UnitCostSpreadsheet!E32,UnitCostSpreadsheet!E25)))))))*I15","v":0},null,null,null,{"$f":"IF(IntGDefault=\"Use default per unit cost\",intg_df_ucost*intg_number,G57*intg_number)","v":0},null,{"$f":"IF(IntGDefault=\"Use default per unit cost\",1,0)","v":1}]
[]
[]
[]
[]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default interchange cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(intg_type=$C$76,Calculations!A176,IF(intg_type=$C$77,Calculations!E176,IF(intg_type=$C$78,Calculations!I176,IF(intg_type=$C$79,Calculations!M176,IF(intg_type=$C$80,Calculations!Q176,IF(intg_type=$C$81,Calculations!U176,IF(intg_type=$C$82,Calculations!Y176)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B176,IF(intg_type=$C$77,Calculations!F176,IF(intg_type=$C$78,Calculations!J176,IF(intg_type=$C$79,Calculations!N176,IF(intg_type=$C$80,Calculations!R176,IF(intg_type=$C$81,Calculations!V176,IF(intg_type=$C$82,Calculations!Z176)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C176,IF(intg_type=$C$77,Calculations!G176,IF(intg_type=$C$78,Calculations!K176,IF(intg_type=$C$79,Calculations!O176,IF(intg_type=$C$80,Calculations!S176,IF(intg_type=$C$81,Calculations!W176,IF(intg_type=$C$82,Calculations!AA176)))))))","v":false},null,{"$f":"IF(AND(D26>0,F26>0)=TRUE,D26*F26,IF(D26>0,D26*E26,IF(F26>0,F26*C26,C26*E26)))","v":0}]
[{"$f":"IF(intg_type=$C$76,Calculations!A177,IF(intg_type=$C$77,Calculations!E177,IF(intg_type=$C$78,Calculations!I177,IF(intg_type=$C$79,Calculations!M177,IF(intg_type=$C$80,Calculations!Q177,IF(intg_type=$C$81,Calculations!U177,IF(intg_type=$C$82,Calculations!Y177)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B177,IF(intg_type=$C$77,Calculations!F177,IF(intg_type=$C$78,Calculations!J177,IF(intg_type=$C$79,Calculations!N177,IF(intg_type=$C$80,Calculations!R177,IF(intg_type=$C$81,Calculations!V177,IF(intg_type=$C$82,Calculations!Z177)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C177,IF(intg_type=$C$77,Calculations!G177,IF(intg_type=$C$78,Calculations!K177,IF(intg_type=$C$79,Calculations!O177,IF(intg_type=$C$80,Calculations!S177,IF(intg_type=$C$81,Calculations!W177,IF(intg_type=$C$82,Calculations!AA177)))))))","v":false},null,{"$f":"IF(AND(D27>0,F27>0)=TRUE,D27*F27,IF(D27>0,D27*E27,IF(F27>0,F27*C27,C27*E27)))","v":0}]
[{"$f":"IF(intg_type=$C$76,Calculations!A178,IF(intg_type=$C$77,Calculations!E178,IF(intg_type=$C$78,Calculations!I178,IF(intg_type=$C$79,Calculations!M178,IF(intg_type=$C$80,Calculations!Q178,IF(intg_type=$C$81,Calculations!U178,IF(intg_type=$C$82,Calculations!Y178)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B178,IF(intg_type=$C$77,Calculations!F178,IF(intg_type=$C$78,Calculations!J178,IF(intg_type=$C$79,Calculations!N178,IF(intg_type=$C$80,Calculations!R178,IF(intg_type=$C$81,Calculations!V178,IF(intg_type=$C$82,Calculations!Z178)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C178,IF(intg_type=$C$77,Calculations!G178,IF(intg_type=$C$78,Calculations!K178,IF(intg_type=$C$79,Calculations!O178,IF(intg_type=$C$80,Calculations!S178,IF(intg_type=$C$81,Calculations!W178,IF(intg_type=$C$82,Calculations!AA178)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A179,IF(intg_type=$C$77,Calculations!E179,IF(intg_type=$C$78,Calculations!I179,IF(intg_type=$C$79,Calculations!M179,IF(intg_type=$C$80,Calculations!Q179,IF(intg_type=$C$81,Calculations!U179,IF(intg_type=$C$82,Calculations!Y179)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B179,IF(intg_type=$C$77,Calculations!F179,IF(intg_type=$C$78,Calculations!J179,IF(intg_type=$C$79,Calculations!N179,IF(intg_type=$C$80,Calculations!R179,IF(intg_type=$C$81,Calculations!V179,IF(intg_type=$C$82,Calculations!Z179)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C179,IF(intg_type=$C$77,Calculations!G179,IF(intg_type=$C$78,Calculations!K179,IF(intg_type=$C$79,Calculations!O179,IF(intg_type=$C$80,Calculations!S179,IF(intg_type=$C$81,Calculations!W179,IF(intg_type=$C$82,Calculations!AA179)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A180,IF(intg_type=$C$77,Calculations!E180,IF(intg_type=$C$78,Calculations!I180,IF(intg_type=$C$79,Calculations!M180,IF(intg_type=$C$80,Calculations!Q180,IF(intg_type=$C$81,Calculations!U180,IF(intg_type=$C$82,Calculations!Y180)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B180,IF(intg_type=$C$77,Calculations!F180,IF(intg_type=$C$78,Calculations!J180,IF(intg_type=$C$79,Calculations!N180,IF(intg_type=$C$80,Calculations!R180,IF(intg_type=$C$81,Calculations!V180,IF(intg_type=$C$82,Calculations!Z180)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C180,IF(intg_type=$C$77,Calculations!G180,IF(intg_type=$C$78,Calculations!K180,IF(intg_type=$C$79,Calculations!O180,IF(intg_type=$C$80,Calculations!S180,IF(intg_type=$C$81,Calculations!W180,IF(intg_type=$C$82,Calculations!AA180)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A181,IF(intg_type=$C$77,Calculations!E181,IF(intg_type=$C$78,Calculations!I181,IF(intg_type=$C$79,Calculations!M181,IF(intg_type=$C$80,Calculations!Q181,IF(intg_type=$C$81,Calculations!U181,IF(intg_type=$C$82,Calculations!Y181)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B181,IF(intg_type=$C$77,Calculations!F181,IF(intg_type=$C$78,Calculations!J181,IF(intg_type=$C$79,Calculations!N181,IF(intg_type=$C$80,Calculations!R181,IF(intg_type=$C$81,Calculations!V181,IF(intg_type=$C$82,Calculations!Z181)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C181,IF(intg_type=$C$77,Calculations!G181,IF(intg_type=$C$78,Calculations!K181,IF(intg_type=$C$79,Calculations!O181,IF(intg_type=$C$80,Calculations!S181,IF(intg_type=$C$81,Calculations!W181,IF(intg_type=$C$82,Calculations!AA181)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A182,IF(intg_type=$C$77,Calculations!E182,IF(intg_type=$C$78,Calculations!I182,IF(intg_type=$C$79,Calculations!M182,IF(intg_type=$C$80,Calculations!Q182,IF(intg_type=$C$81,Calculations!U182,IF(intg_type=$C$82,Calculations!Y182)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B182,IF(intg_type=$C$77,Calculations!F182,IF(intg_type=$C$78,Calculations!J182,IF(intg_type=$C$79,Calculations!N182,IF(intg_type=$C$80,Calculations!R182,IF(intg_type=$C$81,Calculations!V182,IF(intg_type=$C$82,Calculations!Z182)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C182,IF(intg_type=$C$77,Calculations!G182,IF(intg_type=$C$78,Calculations!K182,IF(intg_type=$C$79,Calculations!O182,IF(intg_type=$C$80,Calculations!S182,IF(intg_type=$C$81,Calculations!W182,IF(intg_type=$C$82,Calculations!AA182)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A183,IF(intg_type=$C$77,Calculations!E183,IF(intg_type=$C$78,Calculations!I183,IF(intg_type=$C$79,Calculations!M183,IF(intg_type=$C$80,Calculations!Q183,IF(intg_type=$C$81,Calculations!U183,IF(intg_type=$C$82,Calculations!Y183)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B183,IF(intg_type=$C$77,Calculations!F183,IF(intg_type=$C$78,Calculations!J183,IF(intg_type=$C$79,Calculations!N183,IF(intg_type=$C$80,Calculations!R183,IF(intg_type=$C$81,Calculations!V183,IF(intg_type=$C$82,Calculations!Z183)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C183,IF(intg_type=$C$77,Calculations!G183,IF(intg_type=$C$78,Calculations!K183,IF(intg_type=$C$79,Calculations!O183,IF(intg_type=$C$80,Calculations!S183,IF(intg_type=$C$81,Calculations!W183,IF(intg_type=$C$82,Calculations!AA183)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A184,IF(intg_type=$C$77,Calculations!E184,IF(intg_type=$C$78,Calculations!I184,IF(intg_type=$C$79,Calculations!M184,IF(intg_type=$C$80,Calculations!Q184,IF(intg_type=$C$81,Calculations!U184,IF(intg_type=$C$82,Calculations!Y184)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B184,IF(intg_type=$C$77,Calculations!F184,IF(intg_type=$C$78,Calculations!J184,IF(intg_type=$C$79,Calculations!N184,IF(intg_type=$C$80,Calculations!R184,IF(intg_type=$C$81,Calculations!V184,IF(intg_type=$C$82,Calculations!Z184)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C184,IF(intg_type=$C$77,Calculations!G184,IF(intg_type=$C$78,Calculations!K184,IF(intg_type=$C$79,Calculations!O184,IF(intg_type=$C$80,Calculations!S184,IF(intg_type=$C$81,Calculations!W184,IF(intg_type=$C$82,Calculations!AA184)))))))","v":false},null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A185,IF(intg_type=$C$77,Calculations!E185,IF(intg_type=$C$78,Calculations!I185,IF(intg_type=$C$79,Calculations!M185,IF(intg_type=$C$80,Calculations!Q185,IF(intg_type=$C$81,Calculations!U185,IF(intg_type=$C$82,Calculations!Y185)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B185,IF(intg_type=$C$77,Calculations!F185,IF(intg_type=$C$78,Calculations!J185,IF(intg_type=$C$79,Calculations!N185,IF(intg_type=$C$80,Calculations!R185,IF(intg_type=$C$81,Calculations!V185,IF(intg_type=$C$82,Calculations!Z185)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C185,IF(intg_type=$C$77,Calculations!G185,IF(intg_type=$C$78,Calculations!K185,IF(intg_type=$C$79,Calculations!O185,IF(intg_type=$C$80,Calculations!S185,IF(intg_type=$C$81,Calculations!W185,IF(intg_type=$C$82,Calculations!AA185)))))))","v":false},null,0]
["Subtotal = ",null,null,null,null,null,{"$f":"SUM(G26:G35)","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override",null,"Costs"]
[{"$f":"IF(intg_type=$C$76,Calculations!A187,IF(intg_type=$C$77,Calculations!E187,IF(intg_type=$C$78,Calculations!I187,IF(intg_type=$C$79,Calculations!M187,IF(intg_type=$C$80,Calculations!Q187,IF(intg_type=$C$81,Calculations!U187,IF(intg_type=$C$82,Calculations!Y187)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B187,IF(intg_type=$C$77,Calculations!F187,IF(intg_type=$C$78,Calculations!J187,IF(intg_type=$C$79,Calculations!N187,IF(intg_type=$C$80,Calculations!R187,IF(intg_type=$C$81,Calculations!V187,IF(intg_type=$C$82,Calculations!Z187)))))))","v":false},null,null,null,{"$f":"IF(E38>0, E38*$G$36, C38*$G$36)","v":0}]
[{"$f":"IF(intg_type=$C$76,Calculations!A188,IF(intg_type=$C$77,Calculations!E188,IF(intg_type=$C$78,Calculations!I188,IF(intg_type=$C$79,Calculations!M188,IF(intg_type=$C$80,Calculations!Q188,IF(intg_type=$C$81,Calculations!U188,IF(intg_type=$C$82,Calculations!Y188)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B188,IF(intg_type=$C$77,Calculations!F188,IF(intg_type=$C$78,Calculations!J188,IF(intg_type=$C$79,Calculations!N188,IF(intg_type=$C$80,Calculations!R188,IF(intg_type=$C$81,Calculations!V188,IF(intg_type=$C$82,Calculations!Z188)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A189,IF(intg_type=$C$77,Calculations!E189,IF(intg_type=$C$78,Calculations!I189,IF(intg_type=$C$79,Calculations!M189,IF(intg_type=$C$80,Calculations!Q189,IF(intg_type=$C$81,Calculations!U189,IF(intg_type=$C$82,Calculations!Y189)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B189,IF(intg_type=$C$77,Calculations!F189,IF(intg_type=$C$78,Calculations!J189,IF(intg_type=$C$79,Calculations!N189,IF(intg_type=$C$80,Calculations!R189,IF(intg_type=$C$81,Calculations!V189,IF(intg_type=$C$82,Calculations!Z189)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A190,IF(intg_type=$C$77,Calculations!E190,IF(intg_type=$C$78,Calculations!I190,IF(intg_type=$C$79,Calculations!M190,IF(intg_type=$C$80,Calculations!Q190,IF(intg_type=$C$81,Calculations!U190,IF(intg_type=$C$82,Calculations!Y190)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B190,IF(intg_type=$C$77,Calculations!F190,IF(intg_type=$C$78,Calculations!J190,IF(intg_type=$C$79,Calculations!N190,IF(intg_type=$C$80,Calculations!R190,IF(intg_type=$C$81,Calculations!V190,IF(intg_type=$C$82,Calculations!Z190)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A191,IF(intg_type=$C$77,Calculations!E191,IF(intg_type=$C$78,Calculations!I191,IF(intg_type=$C$79,Calculations!M191,IF(intg_type=$C$80,Calculations!Q191,IF(intg_type=$C$81,Calculations!U191,IF(intg_type=$C$82,Calculations!Y191)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B191,IF(intg_type=$C$77,Calculations!F191,IF(intg_type=$C$78,Calculations!J191,IF(intg_type=$C$79,Calculations!N191,IF(intg_type=$C$80,Calculations!R191,IF(intg_type=$C$81,Calculations!V191,IF(intg_type=$C$82,Calculations!Z191)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A192,IF(intg_type=$C$77,Calculations!E192,IF(intg_type=$C$78,Calculations!I192,IF(intg_type=$C$79,Calculations!M192,IF(intg_type=$C$80,Calculations!Q192,IF(intg_type=$C$81,Calculations!U192,IF(intg_type=$C$82,Calculations!Y192)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B192,IF(intg_type=$C$77,Calculations!F192,IF(intg_type=$C$78,Calculations!J192,IF(intg_type=$C$79,Calculations!N192,IF(intg_type=$C$80,Calculations!R192,IF(intg_type=$C$81,Calculations!V192,IF(intg_type=$C$82,Calculations!Z192)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A193,IF(intg_type=$C$77,Calculations!E193,IF(intg_type=$C$78,Calculations!I193,IF(intg_type=$C$79,Calculations!M193,IF(intg_type=$C$80,Calculations!Q193,IF(intg_type=$C$81,Calculations!U193,IF(intg_type=$C$82,Calculations!Y193)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B193,IF(intg_type=$C$77,Calculations!F193,IF(intg_type=$C$78,Calculations!J193,IF(intg_type=$C$79,Calculations!N193,IF(intg_type=$C$80,Calculations!R193,IF(intg_type=$C$81,Calculations!V193,IF(intg_type=$C$82,Calculations!Z193)))))))","v":false},null,null,null,0]
["Subtotal = ",null,null,null,null,null,{"$f":"SUM(G36:G44)","v":0}]
["New Bridge","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(intg_type=$C$76,Calculations!A199,IF(intg_type=$C$77,Calculations!E199,IF(intg_type=$C$78,Calculations!I199,IF(intg_type=$C$79,Calculations!M199,IF(intg_type=$C$80,Calculations!Q199,IF(intg_type=$C$81,Calculations!U199,IF(intg_type=$C$82,Calculations!Y199)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B199,IF(intg_type=$C$77,Calculations!F199,IF(intg_type=$C$78,Calculations!J199,IF(intg_type=$C$79,Calculations!N199,IF(intg_type=$C$80,Calculations!R199,IF(intg_type=$C$81,Calculations!V199,IF(intg_type=$C$82,Calculations!Z199)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!C199,IF(intg_type=$C$77,Calculations!G199,IF(intg_type=$C$78,Calculations!K199,IF(intg_type=$C$79,Calculations!O199,IF(intg_type=$C$80,Calculations!S199,IF(intg_type=$C$81,Calculations!W199,IF(intg_type=$C$82,Calculations!AA199)))))))","v":false},null,{"$f":"IF(AND(D47>0,F47>0)=TRUE,D47*F47,IF(D47>0,D47*E47,IF(F47>0,F47*C47,C47*E47)))","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override",null,"Costs"]
[{"$f":"IF(intg_type=$C$76,Calculations!A200,IF(intg_type=$C$77,Calculations!E200,IF(intg_type=$C$78,Calculations!I200,IF(intg_type=$C$79,Calculations!M200,IF(intg_type=$C$80,Calculations!Q200,IF(intg_type=$C$81,Calculations!U200,IF(intg_type=$C$82,Calculations!Y200)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B200,IF(intg_type=$C$77,Calculations!F200,IF(intg_type=$C$78,Calculations!J200,IF(intg_type=$C$79,Calculations!N200,IF(intg_type=$C$80,Calculations!R200,IF(intg_type=$C$81,Calculations!V200,IF(intg_type=$C$82,Calculations!Z200)))))))","v":false},null,null,null,{"$f":"IF(E49>0, E49*$G$47, C49*$G$47)","v":0}]
[{"$f":"IF(intg_type=$C$76,Calculations!A201,IF(intg_type=$C$77,Calculations!E201,IF(intg_type=$C$78,Calculations!I201,IF(intg_type=$C$79,Calculations!M201,IF(intg_type=$C$80,Calculations!Q201,IF(intg_type=$C$81,Calculations!U201,IF(intg_type=$C$82,Calculations!Y201)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B201,IF(intg_type=$C$77,Calculations!F201,IF(intg_type=$C$78,Calculations!J201,IF(intg_type=$C$79,Calculations!N201,IF(intg_type=$C$80,Calculations!R201,IF(intg_type=$C$81,Calculations!V201,IF(intg_type=$C$82,Calculations!Z201)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A202,IF(intg_type=$C$77,Calculations!E202,IF(intg_type=$C$78,Calculations!I202,IF(intg_type=$C$79,Calculations!M202,IF(intg_type=$C$80,Calculations!Q202,IF(intg_type=$C$81,Calculations!U202,IF(intg_type=$C$82,Calculations!Y202)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B202,IF(intg_type=$C$77,Calculations!F202,IF(intg_type=$C$78,Calculations!J202,IF(intg_type=$C$79,Calculations!N202,IF(intg_type=$C$80,Calculations!R202,IF(intg_type=$C$81,Calculations!V202,IF(intg_type=$C$82,Calculations!Z202)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A203,IF(intg_type=$C$77,Calculations!E203,IF(intg_type=$C$78,Calculations!I203,IF(intg_type=$C$79,Calculations!M203,IF(intg_type=$C$80,Calculations!Q203,IF(intg_type=$C$81,Calculations!U203,IF(intg_type=$C$82,Calculations!Y203)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B203,IF(intg_type=$C$77,Calculations!F203,IF(intg_type=$C$78,Calculations!J203,IF(intg_type=$C$79,Calculations!N203,IF(intg_type=$C$80,Calculations!R203,IF(intg_type=$C$81,Calculations!V203,IF(intg_type=$C$82,Calculations!Z203)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A204,IF(intg_type=$C$77,Calculations!E204,IF(intg_type=$C$78,Calculations!I204,IF(intg_type=$C$79,Calculations!M204,IF(intg_type=$C$80,Calculations!Q204,IF(intg_type=$C$81,Calculations!U204,IF(intg_type=$C$82,Calculations!Y204)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B204,IF(intg_type=$C$77,Calculations!F204,IF(intg_type=$C$78,Calculations!J204,IF(intg_type=$C$79,Calculations!N204,IF(intg_type=$C$80,Calculations!R204,IF(intg_type=$C$81,Calculations!V204,IF(intg_type=$C$82,Calculations!Z204)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A205,IF(intg_type=$C$77,Calculations!E205,IF(intg_type=$C$78,Calculations!I205,IF(intg_type=$C$79,Calculations!M205,IF(intg_type=$C$80,Calculations!Q205,IF(intg_type=$C$81,Calculations!U205,IF(intg_type=$C$82,Calculations!Y205)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B205,IF(intg_type=$C$77,Calculations!F205,IF(intg_type=$C$78,Calculations!J205,IF(intg_type=$C$79,Calculations!N205,IF(intg_type=$C$80,Calculations!R205,IF(intg_type=$C$81,Calculations!V205,IF(intg_type=$C$82,Calculations!Z205)))))))","v":false},null,null,null,0]
[{"$f":"IF(intg_type=$C$76,Calculations!A206,IF(intg_type=$C$77,Calculations!E206,IF(intg_type=$C$78,Calculations!I206,IF(intg_type=$C$79,Calculations!M206,IF(intg_type=$C$80,Calculations!Q206,IF(intg_type=$C$81,Calculations!U206,IF(intg_type=$C$82,Calculations!Y206)))))))","v":false},null,{"$f":"IF(intg_type=$C$76,Calculations!B206,IF(intg_type=$C$77,Calculations!F206,IF(intg_type=$C$78,Calculations!J206,IF(intg_type=$C$79,Calculations!N206,IF(intg_type=$C$80,Calculations!R206,IF(intg_type=$C$81,Calculations!V206,IF(intg_type=$C$82,Calculations!Z206)))))))","v":false},null,null,null,0]
["Subtotal = ",null,null,null,null,null,{"$f":"G47+SUM(G48:G55)","v":0}]
["Sum =",null,null,null,null,null,{"$f":"ROUND(G45+G56,-3)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type",null,null,"Per Unit Cost"]
[{"$f":"UnitCostSpreadsheet!B25","v":"N/A"},{"$f":"UnitCostSpreadsheet!C25","v":0},{"$f":"UnitCostSpreadsheet!D25","v":"N/A"},null,null,{"$f":"UnitCostSpreadsheet!E25","v":0}]
[{"$f":"UnitCostSpreadsheet!B26","v":"Compressed Diamond"},{"$f":"UnitCostSpreadsheet!C26","v":0},{"$f":"UnitCostSpreadsheet!D26","v":"Compressed Diamond"},null,null,{"$f":"UnitCostSpreadsheet!E26","v":13606000}]
[{"$f":"UnitCostSpreadsheet!B27","v":"Single Point Urban"},{"$f":"UnitCostSpreadsheet!C27","v":0},{"$f":"UnitCostSpreadsheet!D27","v":"Single Point Urban"},null,null,{"$f":"UnitCostSpreadsheet!E27","v":24258000}]
[{"$f":"UnitCostSpreadsheet!B28","v":"Diamond"},{"$f":"UnitCostSpreadsheet!C28","v":0},{"$f":"UnitCostSpreadsheet!D28","v":"Diamond"},null,null,{"$f":"UnitCostSpreadsheet!E28","v":15951000}]
[{"$f":"UnitCostSpreadsheet!B29","v":"Half Diamond"},{"$f":"UnitCostSpreadsheet!C29","v":0},{"$f":"UnitCostSpreadsheet!D29","v":"Half Diamond"},null,null,{"$f":"UnitCostSpreadsheet!E29","v":9021000}]
[{"$f":"UnitCostSpreadsheet!B30","v":"HOV/Managed Lanes Direct Access Interchange"},null,{"$f":"UnitCostSpreadsheet!D30","v":"HOV/Managed Lanes Direct Access Interchange"},null,null,{"$f":"UnitCostSpreadsheet!E30","v":13616000}]
[{"$f":"UnitCostSpreadsheet!B31","v":"Grade Sep - 4 lanes"},{"$f":"UnitCostSpreadsheet!C31","v":0},{"$f":"UnitCostSpreadsheet!D31","v":"Grade Sep - 4 lanes"},null,null,{"$f":"UnitCostSpreadsheet!E31","v":5920000}]
[{"$f":"UnitCostSpreadsheet!B32","v":"Grade Sep - 2 lanes"},{"$f":"UnitCostSpreadsheet!C32","v":0},{"$f":"UnitCostSpreadsheet!D32","v":"Grade Sep - 2 lanes"},null,null,{"$f":"UnitCostSpreadsheet!E32","v":4189000}]

{"sheet":"Intersections","index":7,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,0,8,2],[43,0,43,2],[16,0,16,4],[34,0,34,2],[20,0,20,4],[15,0,15,3],[9,0,9,4]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,H3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Intersections"}]
["Intersection Improvements",null,null,null,null,null,null,{"$f":"MATCH(H2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Choose intersection improvement types and enter length of turning lanes and number of signals and roundabouts if applicable.\n"]
["It should include improvements of all intersections across the entire length of the project."]
["Improvement Type","Length (ft)","Number of Improvements \n(including all approaches)","Default Unit Cost","Total Cost"]
["Turning Lanes - Left",0,0,{"$f":"UnitCostSpreadsheet!E34","v":1200},{"$f":"ints_lt_length*ints_lt_number*ints_lt_df_ucost","v":0}]
["Turning Lanes - Right",0,0,{"$f":"UnitCostSpreadsheet!E35","v":1870},{"$f":"ints_rt_length*ints_rt_number*ints_rt_df_ucost","v":0}]
["Roundabout",null,0,{"$f":"UnitCostSpreadsheet!E36","v":927000},{"$f":"ints_rb_number*ints_rb_df_ucost","v":0}]
["Signal",null,0,{"$f":"UnitCostSpreadsheet!E37","v":200000},{"$f":"ints_sig_number*ints_rt_sig_ucost","v":0}]
["Sum =",null,null,null,{"$f":"SUM(E12:E15)","v":0}]
["You can use projects specific components for cost estimation. "]
[null,null,null,null,"Roundabout Cost"]
["         Use project specific components for Roundabout",null,null,null,{"$f":"D44","v":927000}]
[]
["Please enter descriptions, unit cost and quantities of any additional items you would like to include in the project. Please note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
[]
["Specific Components","Cost/Unit","Qty","Costs"]
[{"$f":"Calculations!I221","v":"Pavement (SY)"},{"$f":"Calculations!J221","v":83.824550000000002},{"$f":"Calculations!K221","v":4000},{"$f":"B25*C25","v":335298.2}]
[{"$f":"Calculations!I222","v":"Curb & Gutter (LF)"},{"$f":"Calculations!J222","v":33.767777777777781},{"$f":"Calculations!K222","v":2200},{"$f":"B26*C26","v":74289.111111111124}]
[{"$f":"Calculations!I223","v":"Conc. Median 4\" (SY)"},{"$f":"Calculations!J223","v":32.06},{"$f":"Calculations!K223","v":75},2404.5]
[{"$f":"Calculations!I224","v":"User-Defined Item"},{"$f":"Calculations!J224","v":0},{"$f":"Calculations!K224","v":0},0]
[{"$f":"Calculations!I225","v":"User-Defined Item"},{"$f":"Calculations!J225","v":0},{"$f":"Calculations!K225","v":0},0]
[{"$f":"Calculations!I226","v":"User-Defined Item"},{"$f":"Calculations!J226","v":0},{"$f":"Calculations!K226","v":0},0]
[{"$f":"Calculations!I227","v":"User-Defined Item"},{"$f":"Calculations!J227","v":0},{"$f":"Calculations!K227","v":0},0]
[{"$f":"Calculations!I228","v":"User-Defined Item"},{"$f":"Calculations!J228","v":0},{"$f":"Calculations!K228","v":0},0]
[{"$f":"Calculations!I229","v":"User-Defined Item"},{"$f":"Calculations!J229","v":0},{"$f":"Calculations!K229","v":0},0]
[{"$f":"Calculations!I230","v":"User-Defined Item"},{"$f":"Calculations!J230","v":0},{"$f":"Calculations!K230","v":0},0]
["Sum = ",null,null,{"$f":"SUM(D25:D34)","v":411991.81111111114}]
["Mark-up Items","Default Percentage","Override","Costs"]
[{"$f":"Calculations!I232","v":"Earthwork"},{"$f":"Calculations!J232","v":0.65},null,{"$f":"IF(C37>0,C37*D$35,B37*D$35)","v":267794.67722222226}]
[{"$f":"Calculations!I233","v":"Drainage"},{"$f":"Calculations!J233","v":0.18},null,{"$f":"IF(C38>0,C38*D$35,B38*D$35)","v":74158.525999999998}]
[{"$f":"Calculations!I234","v":"Erosion Control"},{"$f":"Calculations!J234","v":0.12},null,49439.017333333337]
[{"$f":"Calculations!I235","v":"Signs"},{"$f":"Calculations!J235","v":0.04},null,16479.672444444444]
[{"$f":"Calculations!I236","v":"Pavement Marking"},{"$f":"Calculations!J236","v":0.08},null,32959.344888888889]
[{"$f":"Calculations!I237","v":"Traffic Control"},{"$f":"Calculations!J237","v":0.15},null,61798.771666666667]
[{"$f":"Calculations!I238","v":"Utility"},{"$f":"Calculations!J238","v":0.03},null,12359.754333333334]
["Total = ",null,null,{"$f":"ROUND(SUM(D37:D43)+D35,-3)","v":927000}]
[]
[]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B33","v":"N/A"},{"$f":"UnitCostSpreadsheet!C33","v":0},{"$f":"UnitCostSpreadsheet!D33","v":"N/A"}]
[{"$f":"UnitCostSpreadsheet!B34","v":"Turning Lanes - Left"},{"$f":"UnitCostSpreadsheet!C34","v":0},{"$f":"UnitCostSpreadsheet!D34","v":"Turning Lanes - Left"}]
[{"$f":"UnitCostSpreadsheet!B35","v":"Turning Lanes - Right"},{"$f":"UnitCostSpreadsheet!C35","v":0},{"$f":"UnitCostSpreadsheet!D35","v":"Turning Lanes - Right"}]
[{"$f":"UnitCostSpreadsheet!B36","v":"Roundabout"},{"$f":"UnitCostSpreadsheet!C36","v":0},{"$f":"UnitCostSpreadsheet!D36","v":"Roundabout"}]
[{"$f":"UnitCostSpreadsheet!B37","v":"Signal"},{"$f":"UnitCostSpreadsheet!C37","v":0},{"$f":"UnitCostSpreadsheet!D37","v":"Signal"}]

{"sheet":"Bridge","index":8,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[44,0,44,5],[22,0,22,6],[8,0,8,6],[16,0,16,6],[10,0,10,1],[12,0,12,6],[21,0,21,6],[35,0,35,5]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Bridge"}]
["Bridges",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Enter description and unit of bridge to be built/replaced."]
["Bridge Project Types"]
["N/A"]
[]
["Enter length and width of the bridge; and number of bridges to be built as part of the project."]
[null,"Bridge Length (ft)","Bridge Width (ft)",null,null,null,"# of Bridges"]
[null,0,0,null,null,null,0]
[]
["You can use default bridge costs or enter project specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(BgDefault=\"Use default per sq ft cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total Bridge Cost"]
[null,"Use default per sq ft cost",{"$f":"IF(bg_type=$C$55,UnitCostSpreadsheet!E39,IF(bg_type=$C$56,UnitCostSpreadsheet!E40,UnitCostSpreadsheet!E38))*I19","v":0},null,null,null,{"$f":"IF(BgDefault=\"Use default per sq ft cost\",bg_df_ucost*bg_length*bg_width*bg_number,G45*bg_length*bg_width*bg_number)","v":0},null,{"$f":"IF(BgDefault=\"Use default per sq ft cost\",1,0)","v":1}]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per square bridge cost.\nIf you wish to customize the project specific components for unit cost estimates, please revise unit cost and quantities in the cells shaded in yellow. You can also add additional items in the User-Defined Item cells.\nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(bg_type=$C$55,Calculations!A253,IF(bg_type=$C$56,Calculations!E253))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B253,IF(bg_type=$C$56,Calculations!F253))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C253,IF(bg_type=$C$56,Calculations!G253))","v":false},null,{"$f":"IF(AND(D26>0,F26>0)=TRUE,D26*F26,IF(D26>0,D26*E26,IF(F26>0,F26*C26,C26*E26)))","v":0}]
[{"$f":"IF(bg_type=$C$55,Calculations!A254,IF(bg_type=$C$56,Calculations!E254))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B254,IF(bg_type=$C$56,Calculations!F254))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C254,IF(bg_type=$C$56,Calculations!G254))","v":false},null,{"$f":"IF(AND(D27>0,F27>0)=TRUE,D27*F27,IF(D27>0,D27*E27,IF(F27>0,F27*C27,C27*E27)))","v":0}]
[{"$f":"IF(bg_type=$C$55,Calculations!A255,IF(bg_type=$C$56,Calculations!E255))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B255,IF(bg_type=$C$56,Calculations!F255))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C255,IF(bg_type=$C$56,Calculations!G255))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A256,IF(bg_type=$C$56,Calculations!E256))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B256,IF(bg_type=$C$56,Calculations!F256))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C256,IF(bg_type=$C$56,Calculations!G256))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A257,IF(bg_type=$C$56,Calculations!E257))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B257,IF(bg_type=$C$56,Calculations!F257))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C257,IF(bg_type=$C$56,Calculations!G257))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A258,IF(bg_type=$C$56,Calculations!E258))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B258,IF(bg_type=$C$56,Calculations!F258))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C258,IF(bg_type=$C$56,Calculations!G258))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A259,IF(bg_type=$C$56,Calculations!E259))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B259,IF(bg_type=$C$56,Calculations!F259))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C259,IF(bg_type=$C$56,Calculations!G259))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A260,IF(bg_type=$C$56,Calculations!E260))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B260,IF(bg_type=$C$56,Calculations!F260))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C260,IF(bg_type=$C$56,Calculations!G260))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A261,IF(bg_type=$C$56,Calculations!E261))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B261,IF(bg_type=$C$56,Calculations!F261))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C261,IF(bg_type=$C$56,Calculations!G261))","v":false},null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A262,IF(bg_type=$C$56,Calculations!E262))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B262,IF(bg_type=$C$56,Calculations!F262))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!C262,IF(bg_type=$C$56,Calculations!G262))","v":false},null,0]
["Sum = ",null,null,null,null,null,{"$f":"SUM(G26:G35)","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override Percentage",null,"Costs"]
[{"$f":"IF(bg_type=$C$55,Calculations!A264,IF(bg_type=$C$56,Calculations!E264))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B264,IF(bg_type=$C$56,Calculations!F264))","v":false},null,null,null,{"$f":"IF(E38>0,E38*G$36,C38*G$36)","v":0}]
[{"$f":"IF(bg_type=$C$55,Calculations!A265,IF(bg_type=$C$56,Calculations!E265))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B265,IF(bg_type=$C$56,Calculations!F265))","v":false},null,null,null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A266,IF(bg_type=$C$56,Calculations!E266))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B266,IF(bg_type=$C$56,Calculations!F266))","v":false},null,null,null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A267,IF(bg_type=$C$56,Calculations!E267))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B267,IF(bg_type=$C$56,Calculations!F267))","v":false},null,null,null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A268,IF(bg_type=$C$56,Calculations!E268))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B268,IF(bg_type=$C$56,Calculations!F268))","v":false},null,null,null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A269,IF(bg_type=$C$56,Calculations!E269))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B269,IF(bg_type=$C$56,Calculations!F269))","v":false},null,null,null,0]
[{"$f":"IF(bg_type=$C$55,Calculations!A270,IF(bg_type=$C$56,Calculations!E270))","v":false},null,{"$f":"IF(bg_type=$C$55,Calculations!B270,IF(bg_type=$C$56,Calculations!F270))","v":false},null,null,null,0]
["Sum =",null,null,null,null,null,{"$f":"ROUND(G36+SUM(G37:G44),-1)","v":0}]
[]
[{"$f":"I47","v":0},{"$f":"J47","v":0},{"$f":"K47","v":0}]
[]
[]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B38","v":"N/A"},{"$f":"UnitCostSpreadsheet!C38","v":0},{"$f":"UnitCostSpreadsheet!D38","v":"N/A"}]
[{"$f":"UnitCostSpreadsheet!B39","v":"Bridge Replacements"},{"$f":"UnitCostSpreadsheet!C39","v":0},{"$f":"UnitCostSpreadsheet!D39","v":"Bridge Replacements"}]
[{"$f":"UnitCostSpreadsheet!B40","v":"New Bridge"},{"$f":"UnitCostSpreadsheet!C40","v":0},{"$f":"UnitCostSpreadsheet!D40","v":"New Bridge"}]

{"sheet":"NonMotorized","index":9,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,0,44,5],[8,0,8,6],[12,0,12,6],[10,0,10,1],[35,0,35,5],[22,0,22,7]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"NonMotorized"}]
["Non-Motorized Elements (Sidewalks, Trails, Bike Lanes)",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Enter the unit of  multi-use trail or sidewalk to be built in the project."]
["Non-Motorized Elements",null,null,null,null,null,"Length (Mile)"]
["N/A",null,null,null,null,null,0]
[]
["You can use default per lane-mile cost or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(NvDefault=\"Use default per mile cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total Non-Motorized Elements Cost"]
[null,"Use default per mile cost",{"$f":"IF(nv_type=$C$54,UnitCostSpreadsheet!E42,IF(nv_type=$C$55,UnitCostSpreadsheet!E43,IF(nv_type=$C$56,UnitCostSpreadsheet!E44,IF(nv_type=$C$57,UnitCostSpreadsheet!E45)))*I15)","v":0},null,null,null,{"$f":"IF(NvDefault=\"Use default per mile cost\",nv_df_ucost*nv_length,G45*nv_length)","v":0},null,{"$f":"IF(NvDefault=\"Use default per mile cost\",1,0)","v":1}]
[]
[]
[]
[]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per mile unit cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(nv_type=$C$54,Calculations!A285,IF(nv_type=$C$55,Calculations!E285,IF(nv_type=$C$56,Calculations!I285,IF(nv_type=$C$57,Calculations!M285))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B285,IF(nv_type=$C$55,Calculations!F285,IF(nv_type=$C$56,Calculations!J285,IF(nv_type=$C$57,Calculations!N285))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C285,IF(nv_type=$C$55,Calculations!G285,IF(nv_type=$C$56,Calculations!K285,IF(nv_type=$C$57,Calculations!O285))))","v":false},null,{"$f":"IF(AND(D26>0,F26>0)=TRUE,D26*F26,IF(D26>0,D26*E26,IF(F26>0,F26*C26,C26*E26)))","v":0}]
[{"$f":"IF(nv_type=$C$54,Calculations!A286,IF(nv_type=$C$55,Calculations!E286,IF(nv_type=$C$56,Calculations!I286,IF(nv_type=$C$57,Calculations!M286))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B286,IF(nv_type=$C$55,Calculations!F286,IF(nv_type=$C$56,Calculations!J286,IF(nv_type=$C$57,Calculations!N286))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C286,IF(nv_type=$C$55,Calculations!G286,IF(nv_type=$C$56,Calculations!K286,IF(nv_type=$C$57,Calculations!O286))))","v":false},null,{"$f":"IF(AND(D27>0,F27>0)=TRUE,D27*F27,IF(D27>0,D27*E27,IF(F27>0,F27*C27,C27*E27)))","v":0}]
[{"$f":"IF(nv_type=$C$54,Calculations!A287,IF(nv_type=$C$55,Calculations!E287,IF(nv_type=$C$56,Calculations!I287,IF(nv_type=$C$57,Calculations!M287))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B287,IF(nv_type=$C$55,Calculations!F287,IF(nv_type=$C$56,Calculations!J287,IF(nv_type=$C$57,Calculations!N287))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C287,IF(nv_type=$C$55,Calculations!G287,IF(nv_type=$C$56,Calculations!K287,IF(nv_type=$C$57,Calculations!O287))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A288,IF(nv_type=$C$55,Calculations!E288,IF(nv_type=$C$56,Calculations!I288,IF(nv_type=$C$57,Calculations!M288))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B288,IF(nv_type=$C$55,Calculations!F288,IF(nv_type=$C$56,Calculations!J288,IF(nv_type=$C$57,Calculations!N288))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C288,IF(nv_type=$C$55,Calculations!G288,IF(nv_type=$C$56,Calculations!K288,IF(nv_type=$C$57,Calculations!O288))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A289,IF(nv_type=$C$55,Calculations!E289,IF(nv_type=$C$56,Calculations!I289,IF(nv_type=$C$57,Calculations!M289))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B289,IF(nv_type=$C$55,Calculations!F289,IF(nv_type=$C$56,Calculations!J289,IF(nv_type=$C$57,Calculations!N289))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C289,IF(nv_type=$C$55,Calculations!G289,IF(nv_type=$C$56,Calculations!K289,IF(nv_type=$C$57,Calculations!O289))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A290,IF(nv_type=$C$55,Calculations!E290,IF(nv_type=$C$56,Calculations!I290,IF(nv_type=$C$57,Calculations!M290))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B290,IF(nv_type=$C$55,Calculations!F290,IF(nv_type=$C$56,Calculations!J290,IF(nv_type=$C$57,Calculations!N290))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C290,IF(nv_type=$C$55,Calculations!G290,IF(nv_type=$C$56,Calculations!K290,IF(nv_type=$C$57,Calculations!O290))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A291,IF(nv_type=$C$55,Calculations!E291,IF(nv_type=$C$56,Calculations!I291,IF(nv_type=$C$57,Calculations!M291))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B291,IF(nv_type=$C$55,Calculations!F291,IF(nv_type=$C$56,Calculations!J291,IF(nv_type=$C$57,Calculations!N291))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C291,IF(nv_type=$C$55,Calculations!G291,IF(nv_type=$C$56,Calculations!K291,IF(nv_type=$C$57,Calculations!O291))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A292,IF(nv_type=$C$55,Calculations!E292,IF(nv_type=$C$56,Calculations!I292,IF(nv_type=$C$57,Calculations!M292))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B292,IF(nv_type=$C$55,Calculations!F292,IF(nv_type=$C$56,Calculations!J292,IF(nv_type=$C$57,Calculations!N292))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C292,IF(nv_type=$C$55,Calculations!G292,IF(nv_type=$C$56,Calculations!K292,IF(nv_type=$C$57,Calculations!O292))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A293,IF(nv_type=$C$55,Calculations!E293,IF(nv_type=$C$56,Calculations!I293,IF(nv_type=$C$57,Calculations!M293))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B293,IF(nv_type=$C$55,Calculations!F293,IF(nv_type=$C$56,Calculations!J293,IF(nv_type=$C$57,Calculations!N293))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C293,IF(nv_type=$C$55,Calculations!G293,IF(nv_type=$C$56,Calculations!K293,IF(nv_type=$C$57,Calculations!O293))))","v":false},null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A294,IF(nv_type=$C$55,Calculations!E294,IF(nv_type=$C$56,Calculations!I294,IF(nv_type=$C$57,Calculations!M294))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B294,IF(nv_type=$C$55,Calculations!F294,IF(nv_type=$C$56,Calculations!J294,IF(nv_type=$C$57,Calculations!N294))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!C294,IF(nv_type=$C$55,Calculations!G294,IF(nv_type=$C$56,Calculations!K294,IF(nv_type=$C$57,Calculations!O294))))","v":false},null,0]
["Sum = ",null,null,null,null,null,{"$f":"SUM(G26:G35)","v":0}]
["Mark-up Items",null,"Default Percentage",null,"Override Percentage",null,"Costs"]
[{"$f":"IF(nv_type=$C$54,Calculations!A296,IF(nv_type=$C$55,Calculations!E296,IF(nv_type=$C$56,Calculations!I296,IF(nv_type=$C$57,Calculations!M296))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B296,IF(nv_type=$C$55,Calculations!F296,IF(nv_type=$C$56,Calculations!J296,IF(nv_type=$C$57,Calculations!N296))))","v":false},null,null,null,{"$f":"IF(E38>0, E38*G$36, C38*G$36)","v":0}]
[{"$f":"IF(nv_type=$C$54,Calculations!A297,IF(nv_type=$C$55,Calculations!E297,IF(nv_type=$C$56,Calculations!I297,IF(nv_type=$C$57,Calculations!M297))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B297,IF(nv_type=$C$55,Calculations!F297,IF(nv_type=$C$56,Calculations!J297,IF(nv_type=$C$57,Calculations!N297))))","v":false},null,null,null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A298,IF(nv_type=$C$55,Calculations!E298,IF(nv_type=$C$56,Calculations!I298,IF(nv_type=$C$57,Calculations!M298))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B298,IF(nv_type=$C$55,Calculations!F298,IF(nv_type=$C$56,Calculations!J298,IF(nv_type=$C$57,Calculations!N298))))","v":false},null,null,null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A299,IF(nv_type=$C$55,Calculations!E299,IF(nv_type=$C$56,Calculations!I299,IF(nv_type=$C$57,Calculations!M299))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B299,IF(nv_type=$C$55,Calculations!F299,IF(nv_type=$C$56,Calculations!J299,IF(nv_type=$C$57,Calculations!N299))))","v":false},null,null,null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A300,IF(nv_type=$C$55,Calculations!E300,IF(nv_type=$C$56,Calculations!I300,IF(nv_type=$C$57,Calculations!M300))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B300,IF(nv_type=$C$55,Calculations!F300,IF(nv_type=$C$56,Calculations!J300,IF(nv_type=$C$57,Calculations!N300))))","v":false},null,null,null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A301,IF(nv_type=$C$55,Calculations!E301,IF(nv_type=$C$56,Calculations!I301,IF(nv_type=$C$57,Calculations!M301))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B301,IF(nv_type=$C$55,Calculations!F301,IF(nv_type=$C$56,Calculations!J301,IF(nv_type=$C$57,Calculations!N301))))","v":false},null,null,null,0]
[{"$f":"IF(nv_type=$C$54,Calculations!A302,IF(nv_type=$C$55,Calculations!E302,IF(nv_type=$C$56,Calculations!I302,IF(nv_type=$C$57,Calculations!M302))))","v":false},null,{"$f":"IF(nv_type=$C$54,Calculations!B302,IF(nv_type=$C$55,Calculations!F302,IF(nv_type=$C$56,Calculations!J302,IF(nv_type=$C$57,Calculations!N302))))","v":false},null,null,null,0]
["Sum =",null,null,null,null,null,{"$f":"ROUND(SUM(G38:G44)+G36,-3)","v":0}]
[]
[{"$f":"I47","v":0},{"$f":"J47","v":0},{"$f":"K47","v":0}]
[]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B41","v":"N/A"},{"$f":"UnitCostSpreadsheet!C41","v":0},{"$f":"UnitCostSpreadsheet!D41","v":"N/A"}]
[{"$f":"UnitCostSpreadsheet!B42","v":"Multi-Use Trails (Assume 10' wide) - Asphalt"},{"$f":"UnitCostSpreadsheet!C42","v":0},{"$f":"UnitCostSpreadsheet!D42","v":"Multi-Use Trails (Assume 10' wide) - Asphalt"}]
[{"$f":"UnitCostSpreadsheet!B43","v":"Multi-Use Trails (Assume 10' Wide) - Concrete"},{"$f":"UnitCostSpreadsheet!C43","v":0},{"$f":"UnitCostSpreadsheet!D43","v":"Multi-Use Trails (Assume 10' Wide) - Concrete"}]
[{"$f":"UnitCostSpreadsheet!B44","v":"Sidewalks Along Project"},{"$f":"UnitCostSpreadsheet!C44","v":0},{"$f":"UnitCostSpreadsheet!D44","v":"Sidewalks Along Project"}]
[{"$f":"UnitCostSpreadsheet!B45","v":"Bike Lanes"},{"$f":"UnitCostSpreadsheet!C45","v":0},{"$f":"UnitCostSpreadsheet!D45","v":"Bike Lanes"}]

{"sheet":"Walls","index":10,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,0,8,5],[10,0,10,1],[31,0,31,5],[12,0,12,6],[18,0,18,6]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,I3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Walls"}]
["Walls (Sound Barrier, Retaining)",null,null,null,null,null,null,null,{"$f":"MATCH(I2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Enter description and unit of walls to be built."]
["Walls",null,null,null,null,null,"Length (Mile)"]
["N/A",null,null,null,null,null,0]
[]
["You can use default per lane-mile cost or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(WallDefault=\"Use default per mile cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total Wall Cost"]
[null,"Use default per mile cost",{"$f":"IF(wall_type=$C$38,UnitCostSpreadsheet!E47,IF(wall_type=$C$39,UnitCostSpreadsheet!E48,UnitCostSpreadsheet!E46))*H15","v":0},null,null,null,{"$f":"IF(WallDefault=\"Use default per mile cost\",wall_df_ucost*wall_length,G32*wall_length)","v":0},{"$f":"IF(WallDefault=\"Use default per mile cost\",1,0)","v":1}]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per mile unit cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(wall_type=$C$38,Calculations!A318,IF(wall_type=$C$39,Calculations!E318))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B318,IF(wall_type=$C$39,Calculations!F318))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C318,IF(wall_type=$C$39,Calculations!G318))","v":false},null,{"$f":"IF(AND(D22>0,F22>0)=TRUE,D22*F22,IF(D22>0,D22*E22,IF(F22>0,F22*C22,C22*E22)))","v":0}]
[{"$f":"IF(wall_type=$C$38,Calculations!A319,IF(wall_type=$C$39,Calculations!E319))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B319,IF(wall_type=$C$39,Calculations!F319))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C319,IF(wall_type=$C$39,Calculations!G319))","v":false},null,{"$f":"IF(AND(D23>0,F23>0)=TRUE,D23*F23,IF(D23>0,D23*E23,IF(F23>0,F23*C23,C23*E23)))","v":0}]
[{"$f":"IF(wall_type=$C$38,Calculations!A320,IF(wall_type=$C$39,Calculations!E320))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B320,IF(wall_type=$C$39,Calculations!F320))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C320,IF(wall_type=$C$39,Calculations!G320))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A321,IF(wall_type=$C$39,Calculations!E321))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B321,IF(wall_type=$C$39,Calculations!F321))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C321,IF(wall_type=$C$39,Calculations!G321))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A322,IF(wall_type=$C$39,Calculations!E322))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B322,IF(wall_type=$C$39,Calculations!F322))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C322,IF(wall_type=$C$39,Calculations!G322))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A323,IF(wall_type=$C$39,Calculations!E323))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B323,IF(wall_type=$C$39,Calculations!F323))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C323,IF(wall_type=$C$39,Calculations!G323))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A324,IF(wall_type=$C$39,Calculations!E324))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B324,IF(wall_type=$C$39,Calculations!F324))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C324,IF(wall_type=$C$39,Calculations!G324))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A325,IF(wall_type=$C$39,Calculations!E325))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B325,IF(wall_type=$C$39,Calculations!F325))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C325,IF(wall_type=$C$39,Calculations!G325))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A326,IF(wall_type=$C$39,Calculations!E326))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B326,IF(wall_type=$C$39,Calculations!F326))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C326,IF(wall_type=$C$39,Calculations!G326))","v":false},null,0]
[{"$f":"IF(wall_type=$C$38,Calculations!A327,IF(wall_type=$C$39,Calculations!E327))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!B327,IF(wall_type=$C$39,Calculations!F327))","v":false},null,{"$f":"IF(wall_type=$C$38,Calculations!C327,IF(wall_type=$C$39,Calculations!G327))","v":false},null,0]
["Sum = ",null,null,null,null,null,{"$f":"SUM(G22:G31)","v":0}]
[{"$f":"IF(wall_type=$C$38,\"Sound Barrier Walls are assumed to be 15' in height\",IF(wall_type=$C$39,\"Retaining Walls are assumed to be 12' in height\"))","v":false}]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B46","v":"N/A"},{"$f":"UnitCostSpreadsheet!C46","v":0},{"$f":"UnitCostSpreadsheet!D46","v":"N/A"}]
[{"$f":"UnitCostSpreadsheet!B47","v":"Sound Barrier Walls"},{"$f":"UnitCostSpreadsheet!C47","v":0},{"$f":"UnitCostSpreadsheet!D47","v":"Sound Barrier Walls"}]
[{"$f":"UnitCostSpreadsheet!B48","v":"Retaining Walls"},{"$f":"UnitCostSpreadsheet!C48","v":0},{"$f":"UnitCostSpreadsheet!D48","v":"Retaining Walls"}]

{"sheet":"ITS","index":11,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[13,0,13,6],[19,0,19,6],[8,0,8,6],[10,0,10,1],[32,0,32,5]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,J3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"ITS"}]
["Intelligent Transportation Systems (ITS)   ",null,null,null,null,null,null,null,null,{"$f":"MATCH(J2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Enter description and unit of ITS to be built."]
["ITS",null,null,null,null,null,"Length (Mile)"]
["N/A",null,null,null,null,null,0]
[]
[]
["You can use default per lane-mile cost or enter projects specific components for cost estimation. Please select one of the options in the cell highlighted in green below."]
[null,"Make Selection Below",{"$f":"IF(ITSDefault=\"Use default per mile cost\", \"Default Unit Cost is\", \"\")","v":"Default Unit Cost is"},null,null,null,"Total ITS Cost"]
[null,"Use default per mile cost",{"$f":"IF(its_type=$C$42,UnitCostSpreadsheet!E50,IF(its_type=$C$43,UnitCostSpreadsheet!E51,UnitCostSpreadsheet!E49))*I16","v":0},null,null,null,{"$f":"IF(ITSDefault=\"Use default per mile cost\",its_length*its_df_ucost,its_length*G33)","v":0},null,{"$f":"IF(ITSDefault=\"Use default per mile cost\",1,0)","v":1}]
[]
[]
[]
["The following table provides the detailed information (specific components, cost/unit and quantities) used to develop the default per mile unit cost.\nIf you wish to customize the default unit cost estimates, please revise specific components, unit costs and quantities in the override cells shaded in yellow. \nPlease note that the tool will add markups to the overall project cost. Adjust percentages as appropriate."]
[]
["Specific Components","Specific Components Override","Cost/Unit","Cost/Unit Override","Quantity","Quantity Override","Costs"]
[{"$f":"IF(its_type=$C$42,Calculations!A341,IF(its_type=$C$43,Calculations!E341))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B341,IF(its_type=$C$43,Calculations!F341))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C341,IF(its_type=$C$43,Calculations!G341))","v":false},null,{"$f":"IF(AND(D23>0,F23>0)=TRUE,D23*F23,IF(D23>0,D23*E23,IF(F23>0,F23*C23,C23*E23)))","v":0}]
[{"$f":"IF(its_type=$C$42,Calculations!A342,IF(its_type=$C$43,Calculations!E342))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B342,IF(its_type=$C$43,Calculations!F342))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C342,IF(its_type=$C$43,Calculations!G342))","v":false},null,{"$f":"IF(AND(D24>0,F24>0)=TRUE,D24*F24,IF(D24>0,D24*E24,IF(F24>0,F24*C24,C24*E24)))","v":0}]
[{"$f":"IF(its_type=$C$42,Calculations!A343,IF(its_type=$C$43,Calculations!E343))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B343,IF(its_type=$C$43,Calculations!F343))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C343,IF(its_type=$C$43,Calculations!G343))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A344,IF(its_type=$C$43,Calculations!E344))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B344,IF(its_type=$C$43,Calculations!F344))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C344,IF(its_type=$C$43,Calculations!G344))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A345,IF(its_type=$C$43,Calculations!E345))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B345,IF(its_type=$C$43,Calculations!F345))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C345,IF(its_type=$C$43,Calculations!G345))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A346,IF(its_type=$C$43,Calculations!E346))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B346,IF(its_type=$C$43,Calculations!F346))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C346,IF(its_type=$C$43,Calculations!G346))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A347,IF(its_type=$C$43,Calculations!E347))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B347,IF(its_type=$C$43,Calculations!F347))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C347,IF(its_type=$C$43,Calculations!G347))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A348,IF(its_type=$C$43,Calculations!E348))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B348,IF(its_type=$C$43,Calculations!F348))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C348,IF(its_type=$C$43,Calculations!G348))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A349,IF(its_type=$C$43,Calculations!E349))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B349,IF(its_type=$C$43,Calculations!F349))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C349,IF(its_type=$C$43,Calculations!G349))","v":false},null,0]
[{"$f":"IF(its_type=$C$42,Calculations!A350,IF(its_type=$C$43,Calculations!E350))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!B350,IF(its_type=$C$43,Calculations!F350))","v":false},null,{"$f":"IF(its_type=$C$42,Calculations!C350,IF(its_type=$C$43,Calculations!G350))","v":false},null,0]
["Sum = ",null,null,null,null,null,{"$f":"SUM(G23:G32)","v":0}]
[]
[]
[]
[]
[]
[]
["List of Project Type","Area Type","Project Type + Urban Type"]
[{"$f":"UnitCostSpreadsheet!B49","v":"N/A"},{"$f":"UnitCostSpreadsheet!C49","v":0},{"$f":"UnitCostSpreadsheet!D49","v":"N/A"}]
[{"$f":"UnitCostSpreadsheet!B50","v":"ITS - Freeway"},{"$f":"UnitCostSpreadsheet!C50","v":0},{"$f":"UnitCostSpreadsheet!D50","v":"ITS - Freeway"}]
[{"$f":"UnitCostSpreadsheet!B51","v":"ITS - Arterial"},{"$f":"UnitCostSpreadsheet!C51","v":0},{"$f":"UnitCostSpreadsheet!D51","v":"ITS - Arterial"}]

{"sheet":"ROW","index":12,"n_rows":126,"n_cols":8,"rows_kept":126,"cut":false,"hidden":false,"merged":[[36,0,36,1],[8,0,8,3],[23,0,24,1]]}
["ATLANTA REGIONAL COMMISSION",null,null,null,null,null,null,{"$f":"INDEX(ReverseOrder,H3)","v":{"$error":"#N/A"}}]
["PLANNING LEVEL COST ESTIMATION TOOL",null,null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"ROW"}]
["Right-of-Way Acquisition",null,null,null,null,null,null,{"$f":"MATCH(H2,ReverseOrder,0)+1","v":{"$error":"#N/A"}}]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
["Enter amount of right-of-way take and percentage of land use type impacted by the project. "]
["Area = ",0,"Acre"]
[]
["Right-of-Way Factor"]
[]
["ROW - Land Use Type\n& Land Use Type","Cost/Acre","% Usage","Cost"]
["Commercial",{"$f":"VLOOKUP(H15,A39:B118,2,FALSE)","v":350000},0,{"$f":"ROUND(B$10*B15*C15,-3)","v":0},null,null,null,{"$f":"B7 & \"_\" & A15","v":"Hall_Commercial"}]
["Residential",{"$f":"VLOOKUP(H16,A39:B118,2,FALSE)","v":50000},0,{"$f":"ROUND(B$10*B16*C16,-3)","v":0},null,null,null,{"$f":"B7 & \"_\" & A16","v":"Hall_Residential"}]
["Agricultural",{"$f":"VLOOKUP(H17,A39:B118,2,FALSE)","v":25000},0,{"$f":"ROUND(B$10*B17*C17,-3)","v":0},null,null,null,{"$f":"B7 & \"_\" & A17","v":"Hall_Agricultural"}]
["Industrial",{"$f":"VLOOKUP(H18,A39:B126,2,FALSE)","v":150000},0,{"$f":"ROUND(B$10*B18*C18,-3)","v":0},null,null,null,{"$f":"B7 & \"_\" & A18","v":"Hall_Industrial"}]
["Total % of Usage",null,{"$f":"SUM(C15:C18)","v":0}]
["Displacements","Cost/Unit","Units","Cost"]
["Residential",null,null,{"$f":"B21*C21","v":0}]
["Business",null,null,{"$f":"B22*C22","v":0}]
[null,null,"ROW Costs =",{"$f":"SUM(D15:D18) +SUM(D21:D22)","v":0}]
["Right-of-Way Factor (including scheduling contingency,admin/court costs, and inflation factor)",null,"Default Factor",{"$f":"AssumptionPage!B81","v":2.5}]
[null,null,"Factor Override"]
[null,null,"ROW Total Costs =",{"$f":"IF(row_fac>0,D23*row_fac,row_cost*D24)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Right of Way Assumption"]
["County & Land Use Type","Cost"]
[{"$f":"ROWDatabase!B6&\"_\"&ROWDatabase!$C$5","v":"Barrow_Commercial"},{"$f":"ROWDatabase!C6","v":400000}]
[{"$f":"ROWDatabase!B7&\"_\"&ROWDatabase!$C$5","v":"Bartow_Commercial"},{"$f":"ROWDatabase!C7","v":300000}]
[{"$f":"ROWDatabase!B8&\"_\"&ROWDatabase!$C$5","v":"Carroll_Commercial"},{"$f":"ROWDatabase!C8","v":400000}]
[{"$f":"ROWDatabase!B9&\"_\"&ROWDatabase!$C$5","v":"Cherokee_Commercial"},{"$f":"ROWDatabase!C9","v":400000}]
[{"$f":"ROWDatabase!B10&\"_\"&ROWDatabase!$C$5","v":"Clayton_Commercial"},{"$f":"ROWDatabase!C10","v":400000}]
[{"$f":"ROWDatabase!B11&\"_\"&ROWDatabase!$C$5","v":"Cobb_Commercial"},{"$f":"ROWDatabase!C11","v":700000}]
[{"$f":"ROWDatabase!B12&\"_\"&ROWDatabase!$C$5","v":"Coweta_Commercial"},{"$f":"ROWDatabase!C12","v":200000}]
[{"$f":"ROWDatabase!B13&\"_\"&ROWDatabase!$C$5","v":"DeKalb_Commercial"},{"$f":"ROWDatabase!C13","v":700000}]
[{"$f":"ROWDatabase!B14&\"_\"&ROWDatabase!$C$5","v":"Douglas_Commercial"},{"$f":"ROWDatabase!C14","v":250000}]
[{"$f":"ROWDatabase!B15&\"_\"&ROWDatabase!$C$5","v":"Fayette_Commercial"},{"$f":"ROWDatabase!C15","v":300000}]
[{"$f":"ROWDatabase!B16&\"_\"&ROWDatabase!$C$5","v":"Forsyth_Commercial"},{"$f":"ROWDatabase!C16","v":400000}]
[{"$f":"ROWDatabase!B17&\"_\"&ROWDatabase!$C$5","v":"Fulton - North_Commercial"},{"$f":"ROWDatabase!C17","v":700000}]
[{"$f":"ROWDatabase!B18&\"_\"&ROWDatabase!$C$5","v":"Fulton - City of Atlanta_Commercial"},{"$f":"ROWDatabase!C18","v":2000000}]
[{"$f":"ROWDatabase!B19&\"_\"&ROWDatabase!$C$5","v":"Fulton - South_Commercial"},{"$f":"ROWDatabase!C19","v":400000}]
[{"$f":"ROWDatabase!B20&\"_\"&ROWDatabase!$C$5","v":"Gwinnett_Commercial"},{"$f":"ROWDatabase!C20","v":400000}]
[{"$f":"ROWDatabase!B21&\"_\"&ROWDatabase!$C$5","v":"Hall_Commercial"},{"$f":"ROWDatabase!C21","v":350000}]
[{"$f":"ROWDatabase!B22&\"_\"&ROWDatabase!$C$5","v":"Henry_Commercial"},{"$f":"ROWDatabase!C22","v":350000}]
[{"$f":"ROWDatabase!B23&\"_\"&ROWDatabase!$C$5","v":"Newton_Commercial"},{"$f":"ROWDatabase!C23","v":350000}]
[{"$f":"ROWDatabase!B24&\"_\"&ROWDatabase!$C$5","v":"Paulding_Commercial"},{"$f":"ROWDatabase!C24","v":250000}]
[{"$f":"ROWDatabase!B25&\"_\"&ROWDatabase!$C$5","v":"Rockdale_Commercial"},{"$f":"ROWDatabase!C25","v":350000}]
[{"$f":"ROWDatabase!B26&\"_\"&ROWDatabase!$C$5","v":"Spalding_Commercial"},{"$f":"ROWDatabase!C26","v":350000}]
[{"$f":"ROWDatabase!B27&\"_\"&ROWDatabase!$C$5","v":"Walton_Commercial"},{"$f":"ROWDatabase!C27","v":300000}]
[{"$f":"ROWDatabase!B6&\"_\"&ROWDatabase!$D$5","v":"Barrow_Residential"},{"$f":"ROWDatabase!D6","v":50000}]
[{"$f":"ROWDatabase!B7&\"_\"&ROWDatabase!$D$5","v":"Bartow_Residential"},{"$f":"ROWDatabase!D7","v":50000}]
[{"$f":"ROWDatabase!B8&\"_\"&ROWDatabase!$D$5","v":"Carroll_Residential"},{"$f":"ROWDatabase!D8","v":25000}]
[{"$f":"ROWDatabase!B9&\"_\"&ROWDatabase!$D$5","v":"Cherokee_Residential"},{"$f":"ROWDatabase!D9","v":100000}]
[{"$f":"ROWDatabase!B10&\"_\"&ROWDatabase!$D$5","v":"Clayton_Residential"},{"$f":"ROWDatabase!D10","v":40000}]
[{"$f":"ROWDatabase!B11&\"_\"&ROWDatabase!$D$5","v":"Cobb_Residential"},{"$f":"ROWDatabase!D11","v":150000}]
[{"$f":"ROWDatabase!B12&\"_\"&ROWDatabase!$D$5","v":"Coweta_Residential"},{"$f":"ROWDatabase!D12","v":50000}]
[{"$f":"ROWDatabase!B13&\"_\"&ROWDatabase!$D$5","v":"DeKalb_Residential"},{"$f":"ROWDatabase!D13","v":150000}]
[{"$f":"ROWDatabase!B14&\"_\"&ROWDatabase!$D$5","v":"Douglas_Residential"},{"$f":"ROWDatabase!D14","v":75000}]
[{"$f":"ROWDatabase!B15&\"_\"&ROWDatabase!$D$5","v":"Fayette_Residential"},{"$f":"ROWDatabase!D15","v":40000}]
[{"$f":"ROWDatabase!B16&\"_\"&ROWDatabase!$D$5","v":"Forsyth_Residential"},{"$f":"ROWDatabase!D16","v":100000}]
[{"$f":"ROWDatabase!B17&\"_\"&ROWDatabase!$D$5","v":"Fulton - North_Residential"},{"$f":"ROWDatabase!D17","v":150000}]
[{"$f":"ROWDatabase!B18&\"_\"&ROWDatabase!$D$5","v":"Fulton - City of Atlanta_Residential"},{"$f":"ROWDatabase!D18","v":500000}]
[{"$f":"ROWDatabase!B19&\"_\"&ROWDatabase!$D$5","v":"Fulton - South_Residential"},{"$f":"ROWDatabase!D19","v":75000}]
[{"$f":"ROWDatabase!B20&\"_\"&ROWDatabase!$D$5","v":"Gwinnett_Residential"},{"$f":"ROWDatabase!D20","v":100000}]
[{"$f":"ROWDatabase!B21&\"_\"&ROWDatabase!$D$5","v":"Hall_Residential"},{"$f":"ROWDatabase!D21","v":50000}]
[{"$f":"ROWDatabase!B22&\"_\"&ROWDatabase!$D$5","v":"Henry_Residential"},{"$f":"ROWDatabase!D22","v":50000}]
[{"$f":"ROWDatabase!B23&\"_\"&ROWDatabase!$D$5","v":"Newton_Residential"},{"$f":"ROWDatabase!D23","v":50000}]
[{"$f":"ROWDatabase!B24&\"_\"&ROWDatabase!$D$5","v":"Paulding_Residential"},{"$f":"ROWDatabase!D24","v":75000}]
[{"$f":"ROWDatabase!B25&\"_\"&ROWDatabase!$D$5","v":"Rockdale_Residential"},{"$f":"ROWDatabase!D25","v":100000}]
[{"$f":"ROWDatabase!B26&\"_\"&ROWDatabase!$D$5","v":"Spalding_Residential"},{"$f":"ROWDatabase!D26","v":50000}]
[{"$f":"ROWDatabase!B27&\"_\"&ROWDatabase!$D$5","v":"Walton_Residential"},{"$f":"ROWDatabase!D27","v":100000}]
[{"$f":"ROWDatabase!B6&\"_\"&ROWDatabase!$E$5","v":"Barrow_Agricultural"},{"$f":"ROWDatabase!E6","v":15000}]
[{"$f":"ROWDatabase!B7&\"_\"&ROWDatabase!$E$5","v":"Bartow_Agricultural"},{"$f":"ROWDatabase!E7","v":20000}]
[{"$f":"ROWDatabase!B8&\"_\"&ROWDatabase!$E$5","v":"Carroll_Agricultural"},{"$f":"ROWDatabase!E8","v":15000}]
[{"$f":"ROWDatabase!B9&\"_\"&ROWDatabase!$E$5","v":"Cherokee_Agricultural"},{"$f":"ROWDatabase!E9","v":50000}]
[{"$f":"ROWDatabase!B10&\"_\"&ROWDatabase!$E$5","v":"Clayton_Agricultural"},{"$f":"ROWDatabase!E10","v":25000}]
[{"$f":"ROWDatabase!B11&\"_\"&ROWDatabase!$E$5","v":"Cobb_Agricultural"},{"$f":"ROWDatabase!E11","v":75000}]
[{"$f":"ROWDatabase!B12&\"_\"&ROWDatabase!$E$5","v":"Coweta_Agricultural"},{"$f":"ROWDatabase!E12","v":20000}]
[{"$f":"ROWDatabase!B13&\"_\"&ROWDatabase!$E$5","v":"DeKalb_Agricultural"},{"$f":"ROWDatabase!E13","v":100000}]
[{"$f":"ROWDatabase!B14&\"_\"&ROWDatabase!$E$5","v":"Douglas_Agricultural"},{"$f":"ROWDatabase!E14","v":25000}]
[{"$f":"ROWDatabase!B15&\"_\"&ROWDatabase!$E$5","v":"Fayette_Agricultural"},{"$f":"ROWDatabase!E15","v":20000}]
[{"$f":"ROWDatabase!B16&\"_\"&ROWDatabase!$E$5","v":"Forsyth_Agricultural"},{"$f":"ROWDatabase!E16","v":25000}]
[{"$f":"ROWDatabase!B17&\"_\"&ROWDatabase!$E$5","v":"Fulton - North_Agricultural"},{"$f":"ROWDatabase!E17","v":100000}]
[{"$f":"ROWDatabase!B18&\"_\"&ROWDatabase!$E$5","v":"Fulton - City of Atlanta_Agricultural"},{"$f":"ROWDatabase!E18","v":25000}]
[{"$f":"ROWDatabase!B19&\"_\"&ROWDatabase!$E$5","v":"Fulton - South_Agricultural"},{"$f":"ROWDatabase!E19","v":25000}]
[{"$f":"ROWDatabase!B20&\"_\"&ROWDatabase!$E$5","v":"Gwinnett_Agricultural"},{"$f":"ROWDatabase!E20","v":25000}]
[{"$f":"ROWDatabase!B21&\"_\"&ROWDatabase!$E$5","v":"Hall_Agricultural"},{"$f":"ROWDatabase!E21","v":25000}]
[{"$f":"ROWDatabase!B22&\"_\"&ROWDatabase!$E$5","v":"Henry_Agricultural"},{"$f":"ROWDatabase!E22","v":15000}]
[{"$f":"ROWDatabase!B23&\"_\"&ROWDatabase!$E$5","v":"Newton_Agricultural"},{"$f":"ROWDatabase!E23","v":15000}]
[{"$f":"ROWDatabase!B24&\"_\"&ROWDatabase!$E$5","v":"Paulding_Agricultural"},{"$f":"ROWDatabase!E24","v":20000}]
[{"$f":"ROWDatabase!B25&\"_\"&ROWDatabase!$E$5","v":"Rockdale_Agricultural"},{"$f":"ROWDatabase!E25","v":20000}]
[{"$f":"ROWDatabase!B26&\"_\"&ROWDatabase!$E$5","v":"Spalding_Agricultural"},{"$f":"ROWDatabase!E26","v":15000}]
[{"$f":"ROWDatabase!B27&\"_\"&ROWDatabase!$E$5","v":"Walton_Agricultural"},{"$f":"ROWDatabase!E27","v":15000}]
[{"$f":"ROWDatabase!B6&\"_\"&ROWDatabase!$F$5","v":"Barrow_Industrial"},{"$f":"ROWDatabase!F6","v":75000}]
[{"$f":"ROWDatabase!B7&\"_\"&ROWDatabase!$F$5","v":"Bartow_Industrial"},{"$f":"ROWDatabase!F7","v":30000}]
[{"$f":"ROWDatabase!B8&\"_\"&ROWDatabase!$F$5","v":"Carroll_Industrial"},{"$f":"ROWDatabase!F8","v":20000}]
[{"$f":"ROWDatabase!B9&\"_\"&ROWDatabase!$F$5","v":"Cherokee_Industrial"},{"$f":"ROWDatabase!F9","v":75000}]
[{"$f":"ROWDatabase!B10&\"_\"&ROWDatabase!$F$5","v":"Clayton_Industrial"},{"$f":"ROWDatabase!F10","v":50000}]
[{"$f":"ROWDatabase!B11&\"_\"&ROWDatabase!$F$5","v":"Cobb_Industrial"},{"$f":"ROWDatabase!F11","v":200000}]
[{"$f":"ROWDatabase!B12&\"_\"&ROWDatabase!$F$5","v":"Coweta_Industrial"},{"$f":"ROWDatabase!F12","v":25000}]
[{"$f":"ROWDatabase!B13&\"_\"&ROWDatabase!$F$5","v":"DeKalb_Industrial"},{"$f":"ROWDatabase!F13","v":150000}]
[{"$f":"ROWDatabase!B14&\"_\"&ROWDatabase!$F$5","v":"Douglas_Industrial"},{"$f":"ROWDatabase!F14","v":100000}]
[{"$f":"ROWDatabase!B15&\"_\"&ROWDatabase!$F$5","v":"Fayette_Industrial"},{"$f":"ROWDatabase!F15","v":35000}]
[{"$f":"ROWDatabase!B16&\"_\"&ROWDatabase!$F$5","v":"Forsyth_Industrial"},{"$f":"ROWDatabase!F16","v":30000}]
[{"$f":"ROWDatabase!B17&\"_\"&ROWDatabase!$F$5","v":"Fulton - North_Industrial"},{"$f":"ROWDatabase!F17","v":200000}]
[{"$f":"ROWDatabase!B18&\"_\"&ROWDatabase!$F$5","v":"Fulton - City of Atlanta_Industrial"},{"$f":"ROWDatabase!F18","v":1167000}]
[{"$f":"ROWDatabase!B19&\"_\"&ROWDatabase!$F$5","v":"Fulton - South_Industrial"},{"$f":"ROWDatabase!F19","v":100000}]
[{"$f":"ROWDatabase!B20&\"_\"&ROWDatabase!$F$5","v":"Gwinnett_Industrial"},{"$f":"ROWDatabase!F20","v":200000}]
[{"$f":"ROWDatabase!B21&\"_\"&ROWDatabase!$F$5","v":"Hall_Industrial"},{"$f":"ROWDatabase!F21","v":150000}]
[{"$f":"ROWDatabase!B22&\"_\"&ROWDatabase!$F$5","v":"Henry_Industrial"},{"$f":"ROWDatabase!F22","v":75000}]
[{"$f":"ROWDatabase!B23&\"_\"&ROWDatabase!$F$5","v":"Newton_Industrial"},{"$f":"ROWDatabase!F23","v":75000}]
[{"$f":"ROWDatabase!B24&\"_\"&ROWDatabase!$F$5","v":"Paulding_Industrial"},{"$f":"ROWDatabase!F24","v":100000}]
[{"$f":"ROWDatabase!B25&\"_\"&ROWDatabase!$F$5","v":"Rockdale_Industrial"},{"$f":"ROWDatabase!F25","v":125000}]
[{"$f":"ROWDatabase!B26&\"_\"&ROWDatabase!$F$5","v":"Spalding_Industrial"},{"$f":"ROWDatabase!F26","v":75000}]
[{"$f":"ROWDatabase!B27&\"_\"&ROWDatabase!$F$5","v":"Walton_Industrial"},{"$f":"ROWDatabase!F27","v":75000}]

{"sheet":"Calculations","index":13,"n_rows":351,"n_cols":28,"rows_kept":351,"cut":false,"hidden":false,"merged":[[1,0,4,0],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[7,0,7,6],[7,8,7,14],[7,16,7,22],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,9,8,10],[8,11,8,12],[8,13,8,14],[8,17,8,18],[8,19,8,20],[8,21,8,22],[15,0,15,4],[15,8,15,12],[15,16,15,20],[17,0,17,6],[17,16,17,22],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,17,18,18],[18,19,18,20],[18,21,18,22],[22,0,22,4],[22,16,22,20],[24,0,24,6],[24,8,24,14],[28,0,28,4],[28,8,28,12],[31,0,31,7],[40,0,40,3],[40,4,40,7],[31,9,31,16],[40,9,40,12],[40,13,40,16],[52,0,52,2],[52,4,52,6],[60,0,60,2],[60,4,60,6],[65,0,65,15],[73,0,73,3],[73,4,73,7],[73,8,73,11],[73,12,73,15],[85,0,85,2],[85,4,85,6],[85,8,85,10],[85,12,85,14],[106,0,106,3],[106,4,106,7],[106,8,106,11],[106,12,106,15],[118,4,118,6],[93,0,93,2],[93,4,93,6],[93,8,93,10],[93,12,93,14],[118,0,118,2],[118,8,118,10],[118,12,118,14],[173,24,173,27],[126,0,126,2],[126,4,126,6],[126,8,126,10],[126,12,126,14],[150,8,150,10],[150,12,150,14],[173,0,173,3],[173,4,173,7],[173,8,173,11],[173,12,173,15],[173,16,173,19],[173,20,173,23],[158,8,158,10],[158,12,158,14],[158,0,158,2],[158,4,158,6],[163,0,163,27],[138,0,138,3],[138,4,138,7],[138,8,138,11],[138,12,138,15],[193,20,193,22],[193,24,193,26],[185,0,185,2],[185,4,185,6],[185,8,185,10],[185,12,185,14],[185,16,185,18],[185,20,185,22],[194,8,194,11],[194,12,194,15],[194,16,194,19],[194,20,194,23],[185,24,185,26],[193,0,193,2],[193,4,193,6],[193,8,193,10],[193,12,193,14],[193,16,193,18],[194,24,194,27],[194,0,194,3],[194,4,194,7],[206,0,206,2],[206,4,206,6],[206,8,206,10],[206,12,206,14],[206,16,206,18],[206,20,206,22],[206,24,206,26],[207,24,207,26],[207,0,207,2],[207,4,207,6],[207,20,207,22],[270,4,270,6],[303,0,303,2],[282,4,282,7],[282,12,282,15],[294,12,294,14],[207,16,207,18],[315,4,315,7],[282,8,282,11],[303,12,303,14],[303,4,303,6],[210,0,210,15],[218,0,218,3],[218,4,218,7],[218,8,218,11],[218,12,218,15],[207,8,207,10],[207,12,207,14],[230,8,230,10],[230,12,230,14],[230,0,230,2],[230,4,230,6],[262,4,262,6],[303,8,303,10],[282,0,282,3],[338,0,338,3],[338,4,338,7],[350,0,350,2],[350,4,350,6],[98,0,98,16],[130,0,130,16],[327,0,327,2],[327,4,327,6],[150,0,150,2],[150,4,150,6],[250,0,250,3],[250,4,250,7],[238,0,238,2],[238,4,238,6],[238,8,238,10],[238,12,238,14],[330,0,330,7],[294,0,294,2],[294,4,294,6],[294,8,294,10],[262,0,262,2],[315,0,315,3],[307,0,307,7],[270,0,270,2]]}
[]
["Color\nCode","to be used in Calculations"]
[null,"Final Costs"]
[null,"Default Numbers"]
[null,"GDOT COSTS PER UNIT"]
[]
[]
["Interstate - Asphalt",null,null,null,null,null,null,null,"Surface Street - Asphalt",null,null,null,null,null,null,null,"Multi-use Pathway - Asphalt"]
["Material","Unit",null,"Cost/Unit",null,"Totals",null,null,"Material","Unit",null,"Cost/Unit",null,"Totals",null,null,"Material","Unit",null,"Cost/Unit",null,"Totals"]
["PEM",135,"Lb/SY",{"$f":"GDOT_Prices!$C$6","v":169.51},"$/Ton",{"$f":"(B10/2000)*D10","v":11.441924999999999},"$/SY",null,"12.5 mm",165,"Lb/SY",{"$f":"GDOT_Prices!$C$8","v":69.02},"$/Ton",{"$f":"(J10/2000)*L10","v":5.6941499999999996},"$/SY",null,"12.5 mm",220,"Lb/SY",{"$f":"GDOT_Prices!$C$8","v":69.02},"$/Ton",{"$f":"(R10/2000)*T10","v":7.5921999999999992},"$/SY"]
["SMA",220,"Lb/SY",{"$f":"GDOT_Prices!$C$5","v":155.81},"$/Ton",{"$f":"(B11/2000)*D11","v":17.139099999999999},"$/SY",null,"19 mm",220,"Lb/SY",{"$f":"GDOT_Prices!$C$9","v":81.040000000000006},"$/Ton",{"$f":"(J11/2000)*L11","v":8.9144000000000005},"$/SY",null,"6 GAB",6,"In",{"$f":"GDOT_Prices!$C$3","v":13.43},"$/SY",{"$f":"T11","v":13.43},"$/SY"]
["19 mm",440,"Lb/SY",{"$f":"GDOT_Prices!$C$9","v":81.040000000000006},"$/Ton",{"$f":"(B12/2000)*D12","v":17.828800000000001},"$/SY",null,"25 mm",440,"Lb/SY",{"$f":"GDOT_Prices!$C$7","v":74.66},"$/Ton",{"$f":"(J12/2000)*L12","v":16.4252},"$/SY"]
["25 mm",1100,"Lb/SY",{"$f":"GDOT_Prices!$C$7","v":74.66},"$/Ton",{"$f":"(B13/2000)*D13","v":41.063000000000002},"$/SY",null,"12 GAB",12,"In",{"$f":"GDOT_Prices!$C$4","v":52.48},"$/SY",{"$f":"L13","v":52.48},"$/SY"]
["12 GAB",12,"In",{"$f":"GDOT_Prices!$C$4","v":52.48},"$/SY",{"$f":"D14","v":52.48},"$/SY",null,"Bitum Tack",0.06,"Gal/SY",{"$f":"GDOT_Prices!$C$10","v":2.59},"$/Gal",{"$f":"J14*L14*2","v":0.31079999999999997},"$/SY"]
["Bitum Tack",0.06,"Gal/SY",{"$f":"GDOT_Prices!$C$10","v":2.59},"$/Gal",{"$f":"B15*D15*2","v":0.31079999999999997},"$/SY"]
["SUM =",null,null,null,null,{"$f":"SUM(F10:F15)","v":140.26362499999999},"$/SY",null,"SUM =",null,null,null,null,{"$f":"SUM(N10:N15)","v":83.824550000000002},"$/SY",null,"SUM =",null,null,null,null,{"$f":"SUM(V10:V15)","v":21.022199999999998},"$/SY"]
[]
["Interstate - Concrete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-use Pathway - Concrete"]
["Material","Unit",null,"Cost/Unit",null,"Totals",null,null,null,null,null,null,null,null,null,null,"Material","Unit",null,"Cost/Unit",null,"Totals"]
["Concrete",12,"In",{"$f":"GDOT_Prices!$C$13","v":104.12},"$/SY",{"$f":"D20","v":104.12},"$/SY",null,null,null,null,null,null,null,null,null,"Concrete",6,"In",{"$f":"GDOT_Prices!$C$15","v":37.700000000000003},"$/SY",{"$f":"T20","v":37.700000000000003},"$/SY"]
["19 mm",330,"Lb/SY",{"$f":"GDOT_Prices!$C$9","v":81.040000000000006},"$/Ton",{"$f":"(B21/2000)*D21","v":13.371600000000001},"$/SY",null,null,null,null,null,null,null,null,null,"6 GAB",6,"In",{"$f":"GDOT_Prices!$C$3","v":13.43},"$/SY",{"$f":"T21","v":13.43},"$/SY"]
["12 GAB",12,"In",{"$f":"GDOT_Prices!$C$4","v":52.48},"$/SY",{"$f":"D22","v":52.48},"$/SY"]
["SUM =",null,null,null,null,{"$f":"SUM(F20:F22)","v":169.9716},"$/SY",null,null,null,null,null,null,null,null,null,"SUM =",null,null,null,null,{"$f":"SUM(V20:V22)","v":51.13},"$/SY"]
[]
["Interstate - Overlay",null,null,null,null,null,null,null,"Surface Street - Overlay"]
["Mill","Variable","SY",{"$f":"GDOT_Prices!$C$11","v":3.35},"$/SY",{"$f":"D26","v":3.35},"$/SY",null,"Mill","Variable","SY",{"$f":"GDOT_Prices!$C$11","v":3.35},"$/SY",{"$f":"L26","v":3.35},"$/SY"]
["SMA",302.5,"Lb/SY",{"$f":"GDOT_Prices!$C$5","v":155.81},"$/Ton",{"$f":"(B27/2000)*D27","v":23.566262500000001},"$/SY",null,"12.5 mm",220,"Lb/SY",{"$f":"GDOT_Prices!$C$8","v":69.02},"$/Ton",{"$f":"(J27/2000)*L27","v":7.5921999999999992},"$/SY"]
["PEM",135,"Lb/SY",{"$f":"GDOT_Prices!$C$6","v":169.51},"$/Ton",{"$f":"(B28/2000)*D28","v":11.441924999999999},"$/SY"]
["SUM =",null,null,null,null,{"$f":"SUM(F26:F28)","v":38.3581875},"$/SY",null,"SUM =",null,null,null,null,{"$f":"SUM(N26:N28)","v":10.9422},"$/SY"]
[]
[]
["Urban Interstate Widening",null,null,null,null,null,null,null,null,"Rural Interstate Widening"]
["Length of Roadway",1,null,{"$f":"IF(C33>0,C33,B33)","v":1},"Miles",{"$f":"D33*5280","v":5280},"LF",null,null,"Length of Roadway",1,null,{"$f":"IF(L33>0,L33,K33)","v":1},"Miles",{"$f":"M33*5280","v":5280},"LF"]
["Existing Number of Lanes",6,null,{"$f":"IF(C34>0,C34,B34)","v":6},"Ea",{"$f":"D34*12","v":72},"Feet",null,null,"Existing Number of Lanes",4,null,{"$f":"IF(L34>0,L34,K34)","v":4},"Ea",{"$f":"M34*12","v":48},"Feet"]
["Number of Lanes to add",2,null,{"$f":"IF(C35>0,C35,B35)","v":2},"Ea",{"$f":"D35*12","v":24},"Feet",null,null,"Number of Lanes to add",2,null,{"$f":"IF(L35>0,L35,K35)","v":2},"Ea",{"$f":"M35*12","v":24},"Feet"]
["Inside Shoulder Width =",10,null,{"$f":"IF(C36>0,C36,B36)","v":10},"LF",{"$f":"D36*2","v":20},"Feet",null,null,"Inside Shoulder Width =",10,null,{"$f":"IF(L36>0,L36,K36)","v":10},"LF",{"$f":"M36*2","v":20},"Feet"]
["Outside Shoulder Width =",12,null,{"$f":"IF(C37>0,C37,B37)","v":12},"LF",{"$f":"D37*2","v":24},"Feet",null,null,"Outside Shoulder Width =",12,null,{"$f":"IF(L37>0,L37,K37)","v":12},"LF",{"$f":"M37*2","v":24},"Feet"]
[]
[]
[]
["Asphalt",null,null,null,"Concrete",null,null,null,null,"Asphalt",null,null,null,"Concrete"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY)",{"$f":"$F$16","v":140.26362499999999},{"$f":"($F$33*($F$35+$F$36+$F$37))/9","v":39893.333333333336},{"$f":"B43*C43","v":5595583.5466666669},"Pavement (SY)",{"$f":"$F$23","v":169.9716},{"$f":"($F$33*($F$35+$F$36+$F$37))/9","v":39893.333333333336},{"$f":"F43*G43","v":6780733.6960000005},null,"Pavement (SY)",{"$f":"$F$16","v":140.26362499999999},{"$f":"(O$33*O$35)/9","v":14080},{"$f":"K43*L43","v":1974911.8399999999},"Pavement (SY)",{"$f":"$F$23","v":169.9716},{"$f":"(O$33*$F$35)/9","v":14080},{"$f":"O43*P43","v":2393200.128}]
["Remove Shoulder (SF)",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"$F$33*$F$36","v":105600},448800,"Remove Shoulder (SF)",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"$F$33*$F$36*2","v":211200},897600,null,"Remove Shoulder (SF)",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"O$33*4","v":21120},89760,"Remove Shoulder (SF)",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"O$33*4","v":21120},89760]
["Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"($F$33*($F$34+$F$37))/9","v":56320},2160333.12,"Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"($F$33*($F$34+$F$37))/9","v":56320},2160333.12,null,"Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"(O$33*O$34)/9","v":28160},1080166.56,"Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"(O$33*O$34)/9","v":28160},1080166.56]
["Median Barrier",{"$f":"GDOT_Prices!$C$19","v":50.75},{"$f":"$F$33","v":5280},267960,"Median Barrier",{"$f":"GDOT_Prices!$C$19","v":50.75},{"$f":"$F$33","v":5280},267960,null,"Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"O$33","v":5280},174979.20000000001,"Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"O$33","v":5280},174979.20000000001]
["Glare Screen (LF)",{"$f":"GDOT_Prices!$C$26","v":32.659999999999997},{"$f":"$F$33","v":5280},172444.79999999999,"Glare Screen (LF)",{"$f":"GDOT_Prices!$C$26","v":32.659999999999997},{"$f":"$F$33","v":5280},172444.79999999999,null,"Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(L$46/500,0)","v":11},21099.98,"Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(P$46/500,0)","v":11},21099.98]
["Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"$F$33/2","v":2640},87489.600000000006,"Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"$F$33/2","v":2640},87489.600000000006,null,"Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"L47","v":11},7737.4,"Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"P47","v":11},7737.4]
["Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(C$48/500,0)","v":5},9590.9,"Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(G$48/500,0)","v":5},9590.9,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"C49","v":5},3517,"Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"G49","v":5},3517,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D43:D52)","v":8745718.9666666687},"Sum =",null,null,{"$f":"SUM(H43:H52)","v":10379669.116},null,"Sum = ",null,null,{"$f":"SUM(M43:M52)","v":3348654.98},"Sum =",null,null,{"$f":"SUM(Q43:Q52)","v":3766943.2680000002}]
["Earthwork",{"$f":"AssumptionPage!B6","v":0.15},null,{"$f":"B54*D$53","v":1311857.8450000002},"Earthwork",{"$f":"AssumptionPage!B6","v":0.15},null,{"$f":"F54*H$53","v":1556950.3674000001},null,"Earthwork",{"$f":"AssumptionPage!C6","v":0.15},null,{"$f":"K54*M$53","v":502298.24699999997},"Earthwork",{"$f":"AssumptionPage!C6","v":0.15},null,{"$f":"O54*Q$53","v":565041.4902}]
["Drainage",{"$f":"AssumptionPage!B7","v":0.05},null,{"$f":"B55*D$53","v":437285.94833333348},"Drainage",{"$f":"AssumptionPage!B7","v":0.05},null,{"$f":"F55*H$53","v":518983.45580000005},null,"Drainage",{"$f":"AssumptionPage!C7","v":0.05},null,167432.74900000001,"Drainage",{"$f":"AssumptionPage!C7","v":0.05},null,{"$f":"O55*Q$53","v":188347.16340000002}]
["Erosion Control",{"$f":"AssumptionPage!B8","v":0.05},null,437285.94833333348,"Erosion Control",{"$f":"AssumptionPage!B8","v":0.05},null,518983.45580000005,null,"Erosion Control",{"$f":"AssumptionPage!C8","v":0.05},null,167432.74900000001,"Erosion Control",{"$f":"AssumptionPage!C8","v":0.05},null,188347.16340000002]
["Signs",{"$f":"AssumptionPage!B9","v":0.06},null,524743.13800000015,"Signs",{"$f":"AssumptionPage!B9","v":0.06},null,622780.14696000004,null,"Signs",{"$f":"AssumptionPage!C9","v":0.06},null,200919.29879999999,"Signs",{"$f":"AssumptionPage!C9","v":0.06},null,226016.59607999999]
["Pavement Marking",{"$f":"AssumptionPage!B10","v":0.03},null,262371.56900000008,"Pavement Marking",{"$f":"AssumptionPage!B10","v":0.03},null,311390.07348000002,null,"Pavement Marking",{"$f":"AssumptionPage!C10","v":0.03},null,100459.64939999999,"Pavement Marking",{"$f":"AssumptionPage!C10","v":0.03},null,113008.29803999999]
["Traffic Control",{"$f":"AssumptionPage!B11","v":0.25},null,2186429.7416666672,"Traffic Control",{"$f":"AssumptionPage!B11","v":0.25},null,2594917.2790000001,null,"Traffic Control",{"$f":"AssumptionPage!C11","v":0.25},null,837163.745,"Traffic Control",{"$f":"AssumptionPage!C11","v":0.25},null,941735.81700000004]
["Utility",{"$f":"AssumptionPage!B12","v":0.03},null,262371.56900000008,"Utility",{"$f":"AssumptionPage!B12","v":0.03},null,311390.07348000002,null,"Utility",{"$f":"AssumptionPage!C12","v":0.03},null,100459.64939999999,"Utility",{"$f":"AssumptionPage!C12","v":0.03},null,113008.29803999999]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D53:D60),-3)","v":14168000},"Subtotal =",null,null,{"$f":"ROUND(SUM(H53:H60),-3)","v":16815000},null,"Subtotal =",null,null,{"$f":"ROUND(SUM(M53:M60),-3)","v":5425000},"Subtotal =",null,null,{"$f":"ROUND(SUM(Q53:Q60),-3)","v":6102000}]
[null,null,"Cost / Mile =",{"$f":"D61","v":14168000},null,null,"Cost / Mile =",{"$f":"H61","v":16815000},null,null,null,"Cost / Mile =",{"$f":"M61","v":5425000},null,null,"Cost / Mile =",{"$f":"Q61","v":6102000}]
[null,null,"Cost / LN Mile =",{"$f":"D61/$D33/$D35","v":7084000},null,null,"Cost / LN Mile =",{"$f":"H61/$D33/$D35","v":8407500},null,null,null,"Cost / LN Mile =",{"$f":"M61/$D33/$D35","v":2712500},null,null,"Cost / LN Mile =",{"$f":"Q61/$D33/$D35","v":3051000}]
[]
[]
["Managed Lanes"]
["Length of Roadway",1,null,{"$f":"IF(C67>0,C67,B67)","v":1},"Miles",{"$f":"D67*5280","v":5280},"LF"]
["Existing Number of Lns",6,null,6,"Ea",{"$f":"D68*(12)","v":72},"Feet"]
["Number of Managed Lns",2,null,2,"Ea",{"$f":"D69*(12)","v":24},"Feet"]
["Outside GP shoulder width",12,null,12,"LF",{"$f":"D70*2","v":24},"Feet"]
["Inside GP Shoulder Width",10,null,10,"LF",{"$f":"D71*2","v":20},"Feet"]
["Outside ML Shoulder Width",12,null,12,"LF",{"$f":"D72*2","v":24},"Feet"]
["Inside ML Shoulder Width",10,null,10,"LF",{"$f":"D73*2","v":20},"Feet"]
["Managed Lane Buffer Seperated - Asphalt",null,null,null,"Managed Lane Buffer seperated - Concrete",null,null,null,"Managed Lane Barrier Separated - Asphalt",null,null,null,"Managed Lane Barrier Separated - Concrete"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY)",{"$f":"$F$16","v":140.26362499999999},{"$f":"$F$67*($F$69+$F$70)/9","v":28160},{"$f":"B76*C76","v":3949823.6799999997},"Pavement (SY)",{"$f":"$F$23","v":169.9716},{"$f":"$F$67*($F$69+$F$70)/9","v":28160},{"$f":"F76*G76","v":4786400.2560000001},"Pavement (SY)",{"$f":"$F$16","v":140.26362499999999},{"$f":"$F$67*($F$69+$F$70+$F$71+$F$72)/9","v":53973.333333333336},{"$f":"J76*K76","v":7570495.3866666667},"Pavement (SY)",{"$f":"$F$23","v":169.9716},{"$f":"$F$67*($F$69+$F$70+$F$71+$F$72)/9","v":53973.333333333336},{"$f":"N76*O76","v":9173933.824000001}]
["Remove Shoulder",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"$F$67*$F$71","v":105600},448800,"Remove Shoulder",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"$F$67*$F$71","v":105600},448800,"Remove Shoulder",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"$F$67","v":5280},22440,"Remove Shoulder",{"$f":"GDOT_Prices!$C$18","v":4.25},{"$f":"$F$67","v":5280},22440]
["Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"$F$67*($F$68+$F$73)/9","v":53973.333333333336},2070319.24,"Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"$F$67*($F$68+$F$73)/9","v":53973.333333333336},2070319.24,"Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"$F$67*($F$68+$F$71+$F$72+$F$73)/9","v":79786.666666666672},3060471.9200000004,"Mill & Overlay (SY)",{"$f":"$F$29","v":38.3581875},{"$f":"$F$67*($F$68+$F$71+$F$72+$F$73)/9","v":79786.666666666672},3060471.9200000004]
["Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"$F$33/2","v":2640},87489.600000000006,"Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"$F$33/2","v":2640},87489.600000000006,"Median Barrier",{"$f":"GDOT_Prices!$C$19","v":50.75},{"$f":"$F$67*2","v":10560},535920,"Median Barrier",{"$f":"GDOT_Prices!$C$19","v":50.75},{"$f":"$F$67*2","v":10560},535920]
["Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(C$48/500,0)","v":5},9590.9,"Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(G$48/500,0)","v":5},9590.9,"Glare Screen (LF)",{"$f":"GDOT_Prices!$C$26","v":32.659999999999997},{"$f":"$F$67*2","v":10560},344889.59999999998,"Glare Screen (LF)",{"$f":"GDOT_Prices!$C$26","v":32.659999999999997},{"$f":"$F$67*2","v":10560},344889.59999999998]
["Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"C80","v":5},3517,"Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"G80","v":5},3517,"Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"$F$33/2","v":2640},87489.600000000006,"Guardrail (LF)",{"$f":"GDOT_Prices!$C$22+GDOT_Prices!$C$12","v":33.14},{"$f":"$F$33/2","v":2640},87489.600000000006]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(K$49/500,0)","v":0},0,"Type 12 Anchor (ea)",{"$f":"GDOT_Prices!$C$25","v":1918.18},{"$f":"ROUND(O$49/500,0)","v":0},0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"K82","v":0},0,"Type 1 Anchor (ea)",{"$f":"GDOT_Prices!$C$23","v":703.4},{"$f":"O82","v":0},0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D76:D85)","v":6569540.4199999999},"Sum = ",null,null,{"$f":"SUM(H76:H85)","v":7406116.9960000003},"Sum = ",null,null,{"$f":"SUM(L76:L85)","v":11621706.506666666},"Sum = ",null,null,{"$f":"SUM(P76:P85)","v":13225144.944}]
["Earthwork",{"$f":"AssumptionPage!B17","v":0.2},null,{"$f":"B87*D$86","v":1313908.084},"Earthwork",{"$f":"AssumptionPage!B17","v":0.2},null,{"$f":"F87*H$86","v":1481223.3992000001},"Earthwork",{"$f":"AssumptionPage!C17","v":0.25},null,{"$f":"J87*L$86","v":2905426.6266666665},"Earthwork",{"$f":"AssumptionPage!C17","v":0.25},null,{"$f":"N87*P$86","v":3306286.236}]
["Drainage",{"$f":"AssumptionPage!B18","v":7.0000000000000007E-2},null,{"$f":"B88*D$86","v":459867.82940000005},"Drainage",{"$f":"AssumptionPage!B18","v":7.0000000000000007E-2},null,{"$f":"F88*H$86","v":518428.18972000008},"Drainage",{"$f":"AssumptionPage!C18","v":7.0000000000000007E-2},null,{"$f":"J88*L$86","v":813519.45546666672},"Drainage",{"$f":"AssumptionPage!C18","v":7.0000000000000007E-2},null,{"$f":"N88*P$86","v":925760.14608000009}]
["Erosion Control",{"$f":"AssumptionPage!B19","v":0.05},null,{"$f":"B89*D$86","v":328477.02100000001},"Erosion Control",{"$f":"AssumptionPage!B19","v":0.05},null,370305.84980000003,"Erosion Control",{"$f":"AssumptionPage!C19","v":0.05},null,581085.32533333334,"Erosion Control",{"$f":"AssumptionPage!C19","v":0.05},null,661257.2472000001]
["Signs",{"$f":"AssumptionPage!B20","v":0.08},null,525563.23360000004,"Signs",{"$f":"AssumptionPage!B20","v":0.08},null,592489.35967999999,"Signs",{"$f":"AssumptionPage!C20","v":0.05},null,581085.32533333334,"Signs",{"$f":"AssumptionPage!C20","v":0.05},null,661257.2472000001]
["Pavement Marking",{"$f":"AssumptionPage!B21","v":0.06},null,394172.4252,"Pavement Marking",{"$f":"AssumptionPage!B21","v":0.06},null,444367.01976,"Pavement Marking",{"$f":"AssumptionPage!C21","v":0.06},null,697302.39039999992,"Pavement Marking",{"$f":"AssumptionPage!C21","v":0.06},null,793508.69663999998]
["Traffic Control",{"$f":"AssumptionPage!B22","v":0.2},null,1313908.084,"Traffic Control",{"$f":"AssumptionPage!B22","v":0.2},null,1481223.3992000001,"Traffic Control",{"$f":"AssumptionPage!C22","v":0.25},null,2905426.6266666665,"Traffic Control",{"$f":"AssumptionPage!C22","v":0.25},null,3306286.236]
["Utility",{"$f":"AssumptionPage!B23","v":0.03},null,197086.2126,"Utility",{"$f":"AssumptionPage!B23","v":0.03},null,222183.50988,"Utility",{"$f":"AssumptionPage!C23","v":0.03},null,348651.19519999996,"Utility",{"$f":"AssumptionPage!C23","v":0.03},null,396754.34831999999]
["Subtotal =",null,null,{"$f":"ROUND(SUM(D86:D93),-3)","v":11103000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H86:H93),-3)","v":12516000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(L86:L93),-3)","v":20454000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(P86:P93),-3)","v":23276000}]
[null,null,"Cost / Mile =",{"$f":"D94","v":11103000},null,null,"Cost / Mile =",{"$f":"H94","v":12516000},null,null,"Cost / Mile =",{"$f":"L94","v":20454000},null,1,"Cost / Mile =",{"$f":"P94","v":23276000}]
[null,null,"Cost / LN Mile =",{"$f":"D94/$D67/$D69","v":5551500},null,null,"Cost / LN Mile =",{"$f":"H94/$D67/$D69","v":6258000},null,null,"Cost / LN Mile =",{"$f":"L94/$D67/$D69","v":10227000},null,null,"Cost / LN Mile =",{"$f":"P94/$D67/$D69","v":11638000}]
[]
[]
["General Purpose Roadway Capacity - Urban"]
["Length of Roadway",1,null,{"$f":"IF(C100>0,C100,B100)","v":1},"Miles",{"$f":"D100*5280","v":5280},"LF"]
["Existing Number of Lns",4,null,{"$f":"IF(C101>0,C101,B101)","v":4},"Ea",{"$f":"D101*12","v":48},"Feet"]
["Number of Lanes to add",2,null,{"$f":"IF(C102>0,C102,B102)","v":2},"Ea",{"$f":"D102*12","v":24},"Feet"]
["Median Width",20,null,{"$f":"IF(C103>0,C103,B103)","v":20},"Feet"]
["Sidewalk Width",5,null,{"$f":"IF(C104>0,C104,B104)","v":5},"Feet"]
[]
[]
["General Purpose Roadway Widening with Median - Urban",null,null,null,"General Purpose Roadway Widening without Median - Urban",null,null,null,"New Alignments - Urban",null,null,null,"Frontage Rd / Passing Lanes - Urban"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"F100*F102/9","v":14080},{"$f":"B109*C109","v":1180249.6640000001},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"F100*F102/9","v":14080},{"$f":"F109*G109","v":1180249.6640000001},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"F100*24/9","v":14080},{"$f":"J109*K109","v":1180249.6640000001},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"F100*F102/9","v":14080},{"$f":"N109*O109","v":1180249.6640000001}]
["Mill & Overlay (SY)",{"$f":"$N$29","v":10.9422},{"$f":"($F$100*$F$101)/9","v":28160},{"$f":"B110*C110","v":308132.35200000001},"Mill & Overlay (SY)",{"$f":"$N$29","v":10.9422},{"$f":"($F$100*$F$101)/9","v":28160},{"$f":"F110*G110","v":308132.35200000001},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$100*2","v":10560},{"$f":"J110*K110","v":356587.73333333334},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$100*2","v":10560},{"$f":"N110*O110","v":356587.73333333334}]
["Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$100*4","v":21120},{"$f":"B111*C111","v":713175.46666666667},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$100*2","v":10560},{"$f":"F111*G111","v":356587.73333333334},"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$100*$D$104)/9*2","v":5866.666666666667},{"$f":"J111*K111","v":250389.33333333334},"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$100*$D$104)/9*2","v":5866.666666666667},{"$f":"N111*O111","v":250389.33333333334}]
["Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$100*($D$103-2.5*2)/9","v":8800},{"$f":"B112*C112","v":282128},"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$100*$D$104)/9*2","v":5866.666666666667},{"$f":"F112*G112","v":250389.33333333334},"User-Defined Item",null,null,null,"User-Defined Item"]
["Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$100*$D$104)/9*2","v":5866.666666666667},{"$f":"B113*C113","v":250389.33333333334},"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D109:D118)","v":2734074.8160000001},"Sum = ",null,null,{"$f":"SUM(H109:H118)","v":2095359.0826666667},"Sum = ",null,null,{"$f":"SUM(L109:L118)","v":1787226.7306666668},"Sum = ",null,null,{"$f":"SUM(P109:P118)","v":1787226.7306666668}]
["Earthwork",{"$f":"AssumptionPage!B28","v":0.75},null,{"$f":"B120*D$119","v":2050556.1120000002},"Earthwork",{"$f":"AssumptionPage!B28","v":0.75},null,{"$f":"F120*H$119","v":1571519.3119999999},"Earthwork",{"$f":"AssumptionPage!C28","v":0.75},null,{"$f":"J120*L$119","v":1340420.048},"Earthwork",{"$f":"AssumptionPage!D28","v":0.65},null,{"$f":"N120*P$119","v":1161697.3749333334}]
["Drainage",{"$f":"AssumptionPage!B29","v":0.18},null,{"$f":"B121*D$119","v":492133.46688000002},"Drainage",{"$f":"AssumptionPage!B29","v":0.18},null,{"$f":"F121*H$119","v":377164.63487999997},"Drainage",{"$f":"AssumptionPage!C29","v":0.18},null,{"$f":"J121*L$119","v":321700.81151999999},"Drainage",{"$f":"AssumptionPage!D29","v":0.18},null,{"$f":"N121*P$119","v":321700.81151999999}]
["Erosion Control",{"$f":"AssumptionPage!B30","v":0.12},null,328088.97791999998,"Erosion Control",{"$f":"AssumptionPage!B30","v":0.12},null,251443.08992,"Erosion Control",{"$f":"AssumptionPage!C30","v":0.12},null,214467.20767999999,"Erosion Control",{"$f":"AssumptionPage!D30","v":0.12},null,214467.20767999999]
["Signs",{"$f":"AssumptionPage!B31","v":0.01},null,27340.748160000003,"Signs",{"$f":"AssumptionPage!B31","v":0.01},null,20953.590826666667,"Signs",{"$f":"AssumptionPage!C31","v":0.02},null,35744.534613333337,"Signs",{"$f":"AssumptionPage!D31","v":0.05},null,89361.33653333335]
["Pavement Marking",{"$f":"AssumptionPage!B32","v":0.04},null,109362.99264000001,"Pavement Marking",{"$f":"AssumptionPage!B32","v":0.04},null,83814.363306666666,"Pavement Marking",{"$f":"AssumptionPage!C32","v":0.04},null,71489.069226666674,"Pavement Marking",{"$f":"AssumptionPage!D32","v":0.04},null,71489.069226666674]
["Traffic Control",{"$f":"AssumptionPage!B33","v":0.15},null,410111.22240000003,"Traffic Control",{"$f":"AssumptionPage!B33","v":0.15},null,314303.86239999998,"Traffic Control",{"$f":"AssumptionPage!C33","v":0.05},null,89361.33653333335,"Traffic Control",{"$f":"AssumptionPage!D33","v":0.2},null,357445.3461333334]
["Utility",{"$f":"AssumptionPage!B34","v":0.03},null,82022.244479999994,"Utility",{"$f":"AssumptionPage!B34","v":0.03},null,62860.77248,"Utility",{"$f":"AssumptionPage!C34","v":0.03},null,53616.801919999998,"Utility",{"$f":"AssumptionPage!D34","v":0.03},null,53616.801919999998]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D119:D126),-3)","v":6234000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H119:H126),-3)","v":4777000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(L119:L126),-3)","v":3914000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(P119:P126),-3)","v":4057000}]
[null,null,"Cost / Mile =",{"$f":"D127","v":6234000},null,null,"Cost / Mile =",{"$f":"H127","v":4777000},null,null,"Cost / Mile =",{"$f":"L127","v":3914000},null,null,"Cost / Mile =",{"$f":"P127","v":4057000}]
[null,null,"Cost / LN Mile =",{"$f":"D127/$D100/$D102","v":3117000},null,null,"Cost / LN Mile =",{"$f":"H127/$D100/$D102","v":2388500},null,null,"Cost / LN Mile =",{"$f":"L127/$D100","v":3914000},null,null,"Cost / LN Mile =",{"$f":"P127/$D100/$D102","v":2028500}]
[]
["General Purpose Roadway Capacity - Rural"]
["Length of Roadway",1,null,{"$f":"IF(C132>0,C132,B132)","v":1},"Miles",{"$f":"D132*5280","v":5280},"LF"]
["Number of Exist Lanes",2,null,{"$f":"IF(C133>0,C133,B133)","v":2},"Ea",{"$f":"D133*12","v":24},"Feet"]
["Number of Lanes to add",2,null,{"$f":"IF(C134>0,C134,B134)","v":2},"Ea",{"$f":"D134*12","v":24},"Feet"]
["Median Width",24,null,{"$f":"IF(C135>0,C135,B135)","v":24},"Feet"]
["Shoulder Width",6.5,null,{"$f":"IF(C136>0,C136,B136)","v":6.5},"Feet"]
[]
[]
["General Purpose Roadway Widening with Median - Rural",null,null,null,"General Purpose Roadway Widening without Median - Rural",null,null,null,"New Alignments - Rural",null,null,null,"Frontage Rd / Passing Lanes - Rural"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"($F132*($F134+$D136))/9","v":17893.333333333332},{"$f":"B141*C141","v":1499900.6146666666},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"($F132*($F134+$D136))/9","v":17893.333333333332},{"$f":"F141*G141","v":1499900.6146666666},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"($F132*(24+$D136))/9","v":17893.333333333332},{"$f":"J141*K141","v":1499900.6146666666},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"($F132*($F134+$D136))/9","v":17893.333333333332},{"$f":"N141*O141","v":1499900.6146666666}]
["Mill & Overlay (SY)",{"$f":"$N$29","v":10.9422},{"$f":"($F132*$F133)/9","v":14080},{"$f":"B142*C142","v":154066.17600000001},"Mill & Overlay (SY)",{"$f":"$N$29","v":10.9422},{"$f":"($F132*$F133)/9","v":14080},{"$f":"F142*G142","v":154066.17600000001},"User-Defined Item",null,null,null,"User-Defined Item"]
["Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F132*2","v":10560},{"$f":"B143*C143","v":356587.73333333334},"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F132*($D135-2.5*2)/9","v":11146.666666666666},{"$f":"B144*C144","v":357362.13333333336},"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D141:D150)","v":2367916.6573333335},"Sum = ",null,null,{"$f":"SUM(H141:H150)","v":1653966.7906666666},"Sum = ",null,null,{"$f":"SUM(L141:L150)","v":1499900.6146666666},"Sum = ",null,null,{"$f":"SUM(P141:P150)","v":1499900.6146666666}]
["Earthwork",{"$f":"AssumptionPage!B28","v":0.75},null,{"$f":"B152*D$151","v":1775937.4930000002},"Earthwork",{"$f":"AssumptionPage!B28","v":0.75},null,{"$f":"F152*H$151","v":1240475.0929999999},"Earthwork",{"$f":"AssumptionPage!C28","v":0.75},null,{"$f":"J152*L$151","v":1124925.4609999999},"Earthwork",{"$f":"AssumptionPage!D28","v":0.65},null,{"$f":"N152*P$151","v":974935.39953333337}]
["Drainage",{"$f":"AssumptionPage!B29","v":0.18},null,{"$f":"B153*D$151","v":426224.99832000001},"Drainage",{"$f":"AssumptionPage!B29","v":0.18},null,{"$f":"F153*H$151","v":297714.02231999999},"Drainage",{"$f":"AssumptionPage!C29","v":0.18},null,{"$f":"J153*L$151","v":269982.11063999997},"Drainage",{"$f":"AssumptionPage!D29","v":0.18},null,{"$f":"N153*P$151","v":269982.11063999997}]
["Erosion Control",{"$f":"AssumptionPage!B30","v":0.12},null,284149.99888000003,"Erosion Control",{"$f":"AssumptionPage!B30","v":0.12},null,198476.01487999997,"Erosion Control",{"$f":"AssumptionPage!C30","v":0.12},null,179988.07376,"Erosion Control",{"$f":"AssumptionPage!D30","v":0.12},null,179988.07376]
["Signs",{"$f":"AssumptionPage!B31","v":0.01},null,23679.166573333336,"Signs",{"$f":"AssumptionPage!B31","v":0.01},null,16539.667906666666,"Signs",{"$f":"AssumptionPage!C31","v":0.02},null,29998.012293333333,"Signs",{"$f":"AssumptionPage!D31","v":0.05},null,74995.030733333333]
["Pavement Marking",{"$f":"AssumptionPage!B32","v":0.04},null,94716.666293333343,"Pavement Marking",{"$f":"AssumptionPage!B32","v":0.04},null,66158.671626666663,"Pavement Marking",{"$f":"AssumptionPage!C32","v":0.04},null,59996.024586666666,"Pavement Marking",{"$f":"AssumptionPage!D32","v":0.04},null,59996.024586666666]
["Traffic Control",{"$f":"AssumptionPage!B33","v":0.15},null,355187.49859999999,"Traffic Control",{"$f":"AssumptionPage!B33","v":0.15},null,248095.01859999998,"Traffic Control",{"$f":"AssumptionPage!C33","v":0.05},null,74995.030733333333,"Traffic Control",{"$f":"AssumptionPage!D33","v":0.2},null,299980.12293333333]
["Utility",{"$f":"AssumptionPage!B34","v":0.03},null,71037.499720000007,"Utility",{"$f":"AssumptionPage!B34","v":0.03},null,49619.003719999993,"Utility",{"$f":"AssumptionPage!C34","v":0.03},null,44997.01844,"Utility",{"$f":"AssumptionPage!D34","v":0.03},null,44997.01844]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D151:D158),-3)","v":5399000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H151:H158),-3)","v":3771000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(L151:L158),-3)","v":3285000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(P151:P158),-3)","v":3405000}]
[null,null,"Cost / Mile =",{"$f":"D159","v":5399000},null,null,"Cost / Mile =",{"$f":"H159","v":3771000},null,null,"Cost / Mile =",{"$f":"L159","v":3285000},null,null,"Cost / Mile =",{"$f":"P159","v":3405000}]
[null,null,"Cost / LN Mile =",{"$f":"D159/$D132/$D134","v":2699500},null,null,"Cost / LN Mile =",{"$f":"H159/$D132/$D134","v":1885500},null,null,"Cost / LN Mile =",{"$f":"L159/$D132/$D134","v":1642500},null,null,"Cost / LN Mile =",{"$f":"P159/$D132/$D134","v":1702500}]
[]
[]
["Interchanges & Grade Separations"]
[null,null,"On Ramp (LF)","Off Ramp (LF)","Ramp Width (LF)","Side Rd Length (LF)","Side Rd Width (LF)"]
["Compressed Diamond Interchange",null,2275,1200,{"$f":"16+8+4","v":28},{"$f":"1000+1000","v":2000},{"$f":"12*4","v":48}]
["Single Pt Urban Interchange",null,2300,2875,{"$f":"16+8+4","v":28},{"$f":"1000+1000","v":2000},{"$f":"12*4","v":48}]
["Diamond Interchange",null,2800,1950,{"$f":"16+8+4","v":28},2000,48]
["Half Diamond",null,2275,1200,{"$f":"16+8+4","v":28},2000,48]
["Hov/ML Direct Access Interchange",null,1400,1400,{"$f":"12+4+4","v":20},2000,48]
["Grade Sep - 4 Lanes",null,0,0,0,2000,48]
["Grade Sep - 2 Lanes",null,0,0,0,2000,48]
["Bridge Cost per SF",null,120,null,{"$f":"IF(D173>0,D173,C173)","v":120},"$/SF"]
["Compressed Diamond Interchange",null,null,null,"Single Point Urban Interchange",null,null,null,"Diamond Interchange",null,null,null,"Half Diamond Interchange",null,null,null,"HOV/Managed Lanes Direct Access Interchange",null,null,null,"Grade Sep - 4 Lanes",null,null,null,"Grade Sep - 2 Lanes"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},{"$f":"(((C166+D166)*2)*E166)/9","v":21622.222222222223},{"$f":"B176*C176","v":3675163.7066666665},"Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},{"$f":"(((C167+D167)*2)*E167)/9","v":32200},{"$f":"F176*G176","v":5473085.5199999996},"Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},{"$f":"(((C168+D168)*2)*E168)/9","v":29555.555555555555},{"$f":"J176*K176","v":5023605.0666666664},"Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},{"$f":"(((C169+D169))*E169)/9","v":10811.111111111111},{"$f":"N176*O176","v":1837581.8533333333},"Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},{"$f":"(((C170+D170)*2)*E170)/9","v":12444.444444444445},{"$f":"R176*S176","v":2115202.1333333333},"Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},0,{"$f":"V176*W176","v":0},"Pavement (SY) - Interstate",{"$f":"$F$23","v":169.9716},0,{"$f":"Z176*AA176","v":0}]
["Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F166*$G166/9","v":10666.666666666666},894128.53333333333,"Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F167*$G167/9","v":10666.666666666666},894128.53333333333,"Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F168*$G168/9","v":10666.666666666666},{"$f":"J177*K177","v":894128.53333333333},"Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F169*$G169/9","v":10666.666666666666},894128.53333333333,"Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F170*$G170/9","v":10666.666666666666},894128.53333333333,"Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F171*$G171/9","v":10666.666666666666},{"$f":"V177*W177","v":894128.53333333333},"Pavement (SY) - Surface St",{"$f":"$N$16","v":83.824550000000002},{"$f":"$F172*$G172/9","v":10666.666666666666},{"$f":"Z177*AA177","v":894128.53333333333}]
["Retaining Wall (SF)",{"$f":"GDOT_Prices!$C$21","v":45.77},{"$f":"(500*25/2)*4","v":25000},1144250,"Retaining Wall (SF)",{"$f":"GDOT_Prices!$C$21","v":45.77},{"$f":"(500*25/2)*4","v":25000},1144250,"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$168*4","v":8000},{"$f":"J178*K178","v":270142.22222222225},"Retaining Wall (SF)",{"$f":"GDOT_Prices!$C$21","v":45.77},{"$f":"(500*25/2)*2","v":12500},572125,"Retaining Wall (SF)",{"$f":"GDOT_Prices!$C$21","v":45.77},{"$f":"(500*25/2)*4","v":25000},1144250,"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$171*4","v":8000},{"$f":"V178*W178","v":270142.22222222225},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$172*4","v":8000},{"$f":"Z178*AA178","v":270142.22222222225}]
["Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$166*4","v":8000},270142.22222222225,"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$167*4","v":8000},270142.22222222225,"Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$168*(15)/9","v":3333.3333333333335},{"$f":"J179*K179","v":106866.66666666669},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$169*4","v":8000},270142.22222222225,"Median Barrier (LF)",{"$f":"GDOT_Prices!$C$19","v":50.75},{"$f":"($C$170+$D$170)*2","v":5600},284200,"Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$171*(15)/9","v":3333.3333333333335},{"$f":"V179*W179","v":106866.66666666669},"Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$172*(15)/9","v":3333.3333333333335},{"$f":"Z179*AA179","v":106866.66666666669}]
["Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$166*(15)/9","v":3333.3333333333335},106866.66666666669,"Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$167*(15)/9","v":3333.3333333333335},106866.66666666669,"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$168*5)/9*2","v":2222.2222222222222},{"$f":"J180*K180","v":94844.444444444438},"Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$169*(15)/9","v":3333.3333333333335},106866.66666666669,"Glare Screen (LF)",{"$f":"GDOT_Prices!$C$26","v":32.659999999999997},{"$f":"($C$170+$D$170)*2","v":5600},182895.99999999997,"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$171*5)/9*2","v":2222.2222222222222},{"$f":"V180*W180","v":94844.444444444438},"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$172*5)/9*2","v":2222.2222222222222},{"$f":"Z180*AA180","v":94844.444444444438}]
["Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$166*5)/9*2","v":2222.2222222222222},94844.444444444438,"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$167*5)/9*2","v":2222.2222222222222},94844.444444444438,"User-Defined Item",null,null,null,"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$169*5)/9*2","v":2222.2222222222222},94844.444444444438,"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$F$170*4","v":8000},270142.22222222225,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"$F$170*(15)/9","v":3333.3333333333335},106866.66666666669,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($F$170*5)/9*2","v":2222.2222222222222},94844.444444444438,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D176:D185)","v":6185395.5733333332},"Sum =",null,null,{"$f":"SUM(H176:H185)","v":7983317.3866666658},"Sum =",null,null,{"$f":"SUM(L176:L185)","v":6389586.9333333327},"Sum =",null,null,{"$f":"SUM(P176:P185)","v":3775688.7199999997},"Sum =",null,null,{"$f":"SUM(T176:T185)","v":5092529.9999999991},"Sum =",null,null,{"$f":"SUM(X176:X185)","v":1365981.8666666669},"Sum =",null,null,{"$f":"SUM(AB176:AB185)","v":1365981.8666666669}]
["Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"B187*D$186","v":2474158.2293333332},"Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"F187*H$186","v":3193326.9546666667},"Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"J187*L$186","v":2555834.7733333334},"Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"N187*P$186","v":1510275.4879999999},"Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"R187*T$186","v":2037011.9999999998},"Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"V187*X$186","v":546392.74666666682},"Earthwork",{"$f":"AssumptionPage!B39","v":0.4},null,{"$f":"Z187*AB$186","v":546392.74666666682}]
["Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"B188*D$186","v":309269.77866666665},"Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"F188*H$186","v":399165.86933333334},"Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"J188*L$186","v":319479.34666666668},"Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"N188*P$186","v":188784.43599999999},"Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"R188*T$186","v":254626.49999999997},"Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"V188*X$186","v":68299.093333333352},"Drainage",{"$f":"AssumptionPage!B40","v":0.05},null,{"$f":"Z188*AB$186","v":68299.093333333352}]
["Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,309269.77866666665,"Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,399165.86933333334,"Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,319479.34666666668,"Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,188784.43599999999,"Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,254626.49999999997,"Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,68299.093333333352,"Erosion Control",{"$f":"AssumptionPage!B41","v":0.05},null,68299.093333333352]
["Signs",{"$f":"AssumptionPage!B42","v":0.01},null,61853.955733333336,"Signs",{"$f":"AssumptionPage!B42","v":0.01},null,79833.173866666664,"Signs",{"$f":"AssumptionPage!B42","v":0.01},null,63895.869333333329,"Signs",{"$f":"AssumptionPage!B42","v":0.01},null,37756.887199999997,"Signs",{"$f":"AssumptionPage!B42","v":0.01},null,50925.299999999988,"Signs",{"$f":"AssumptionPage!B42","v":0.01},null,13659.81866666667,"Signs",{"$f":"AssumptionPage!B42","v":0.01},null,13659.81866666667]
["Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,61853.955733333336,"Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,79833.173866666664,"Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,63895.869333333329,"Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,37756.887199999997,"Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,50925.299999999988,"Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,13659.81866666667,"Pavement Marking",{"$f":"AssumptionPage!B43","v":0.01},null,13659.81866666667]
["Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,1546348.8933333333,"Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,1995829.3466666664,"Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,1597396.7333333332,"Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,943922.17999999993,"Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,1273132.4999999998,"Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,341495.46666666673,"Traffic Control",{"$f":"AssumptionPage!B44","v":0.25},null,341495.46666666673]
["Utility",{"$f":"AssumptionPage!B45","v":0.03},null,185561.86719999998,"Utility",{"$f":"AssumptionPage!B45","v":0.03},null,239499.52159999998,"Utility",{"$f":"AssumptionPage!B45","v":0.03},null,191687.60799999998,"Utility",{"$f":"AssumptionPage!B45","v":0.03},null,113270.66159999999,"Utility",{"$f":"AssumptionPage!B45","v":0.03},null,152775.89999999997,"Utility",{"$f":"AssumptionPage!B45","v":0.03},null,40979.456000000006,"Utility",{"$f":"AssumptionPage!B45","v":0.03},null,40979.456000000006]
["Sum = ",null,null,{"$f":"SUM(D186:D193)","v":11133712.031999996},"Sum = ",null,null,{"$f":"SUM(H186:H193)","v":14369971.296000002},"Sum = ",null,null,{"$f":"SUM(L186:L193)","v":11501256.479999999},"Sum = ",null,null,{"$f":"SUM(P186:P193)","v":6796239.6959999986},"Sum = ",null,null,{"$f":"SUM(T186:T193)","v":9166553.9999999981},"Sum = ",null,null,{"$f":"SUM(X186:X193)","v":2458767.3600000003},"Sum = ",null,null,{"$f":"SUM(AB186:AB193)","v":2458767.3600000003}]
["New Bridge Cost",null,null,null,"New Bridge Cost",null,null,null,"New Bridge Cost",null,null,null,"New Bridge Cost",null,null,null,"New Bridge Cost",null,null,null,"New Bridge Cost",null,null,null,"New Bridge Cost"]
["Length (LF)",250,null,{"$f":"IF(C196>0,C196,B196)","v":250},"Length (LF)",200,null,{"$f":"IF(G196>0,G196,F196)","v":200},"Length (LF)",450,null,{"$f":"IF(K196>0,K196,J196)","v":450},"Length (LF)",450,null,{"$f":"IF(O196>0,O196,N196)","v":450},"Length (LF)",450,null,{"$f":"IF(S196>0,S196,R196)","v":450},"Length (LF)",350,null,{"$f":"IF(W196>0,W196,V196)","v":350},"Length (LF)",350,null,{"$f":"IF(AA196>0,AA196,Z196)","v":350}]
["Width (LF)",80,null,{"$f":"IF(C197>0,C197,B197)","v":80},"Width (LF)",400,null,{"$f":"IF(G197>0,G197,F197)","v":400},"Width (LF)",80,null,{"$f":"IF(K197>0,K197,J197)","v":80},"Width (LF)",40,null,{"$f":"IF(O197>0,O197,N197)","v":40},"Width (LF)",80,null,{"$f":"IF(S197>0,S197,R197)","v":80},"Width (LF)",80,null,{"$f":"IF(W197>0,W197,V197)","v":80},"Width (LF)",40,null,{"$f":"IF(AA197>0,AA197,Z197)","v":40}]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"D196*D197","v":20000},{"$f":"B199*C199","v":2400000},"Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"H196*H197","v":80000},{"$f":"F199*G199","v":9600000},"Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"L196*L197","v":36000},{"$f":"J199*K199","v":4320000},"Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"P196*P197","v":18000},{"$f":"N199*O199","v":2160000},"Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"T196*T197","v":36000},{"$f":"R199*S199","v":4320000},"Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"X196*X197","v":28000},{"$f":"V199*W199","v":3360000},"Bridge (SF)",{"$f":"$E$173","v":120},{"$f":"AB196*AB197","v":14000},{"$f":"Z199*AA199","v":1680000}]
["Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"B200*D$199","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"F200*H$199","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"J200*L$199","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"N200*P$199","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"R200*T$199","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"V200*X$199","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"Z200*AB$199","v":0}]
["Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"B201*D$199","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"F201*H$199","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"J201*L$199","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"N201*P$199","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"R201*T$199","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"V201*X$199","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"Z201*AB$199","v":0}]
["Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0]
["Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,{"$f":"Z203*AB$199","v":0}]
["Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0]
["Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0]
["Utility",{"$f":"AssumptionPage!B67","v":0.03},null,72000,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,288000,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,129600,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,64800,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,129600,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,100800,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,50400]
["Sum = ",null,null,{"$f":"SUM(D199:D206)","v":2472000},"Sum = ",null,null,{"$f":"SUM(H199:H206)","v":9888000},"Sum = ",null,null,{"$f":"SUM(L199:L206)","v":4449600},"Sum = ",null,null,{"$f":"SUM(P199:P206)","v":2224800},"Sum = ",null,null,{"$f":"SUM(T199:T206)","v":4449600},"Sum = ",null,null,{"$f":"SUM(X199:X206)","v":3460800},"Sum = ",null,null,{"$f":"SUM(AB199:AB206)","v":1730400}]
["Subtotal =",null,null,{"$f":"ROUND(D194+D207,-3)","v":13606000},"Subtotal =",null,null,{"$f":"ROUND(H194+H207,-3)","v":24258000},"Subtotal =",null,null,{"$f":"ROUND(L194+L207,-3)","v":15951000},"Subtotal =",null,null,{"$f":"ROUND(P194+P207,-3)","v":9021000},"Subtotal =",null,null,{"$f":"ROUND(T194+T207,-3)","v":13616000},"Subtotal =",null,null,{"$f":"ROUND(X194+X207,-3)","v":5920000},"Subtotal =",null,null,{"$f":"ROUND(AB194+AB207,-3)","v":4189000}]
[]
[]
["Intersections"]
["Left Turn Bay Queue Length",null,300,null,{"$f":"IF(D212>0,D212,C212)","v":300},"LF"]
["Left Turn Lanes",null,1,null,{"$f":"IF(D213>0,D213,C213)","v":1},"Ea"]
["Right Turn Bay Queue Length",null,100,null,{"$f":"IF(D214>0,D214,C214)","v":100},"LF"]
["Right Turn Lanes",null,1,null,{"$f":"IF(D215>0,D215,C215)","v":1},"Ea"]
[]
[]
[]
["Turning Lanes - Left",null,null,null,"Turning Lanes - Right",null,null,null,"Roundabout",null,null,null,"Signal"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"((E212*E213*12)+(465*E213*12))/9","v":1020},{"$f":"B221*C221","v":85501.040999999997},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},{"$f":"((E214*E215*12)+(465*E215*12))/9","v":753.33333333333337},{"$f":"F221*G221","v":63147.827666666672},"Pavement (SY)",{"$f":"$N$16","v":83.824550000000002},4000,{"$f":"J221*K221","v":335298.2},"Signal Cost (EA)",200000,1,{"$f":"N221*O221","v":200000}]
["Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"(E212+465)*2","v":1530},{"$f":"B222*C222","v":51664.700000000004},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"E214+465","v":565},{"$f":"F222*G222","v":19078.794444444447},"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},2200,{"$f":"J222*K222","v":74289.111111111124},"User-Defined Item"]
["Conc. Median (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},{"$f":"(E212+465-100)*8/9+600/9","v":657.77777777777771},{"$f":"B223*C223","v":21088.355555555554},"User-Defined Item",null,null,null,"Conc. Median 4\" (SY)",{"$f":"GDOT_Prices!$C$16","v":32.06},75,{"$f":"J223*K223","v":2404.5},"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D221:D230)","v":158254.09655555556},"Sum =",null,null,{"$f":"SUM(H221:H230)","v":82226.622111111123},"Sum =",null,null,{"$f":"SUM(L221:L230)","v":411991.81111111114},"Sum =",null,null,{"$f":"SUM(P221:P230)","v":200000}]
["Earthwork",{"$f":"AssumptionPage!B50","v":0.75},null,{"$f":"B232*D$231","v":118690.57241666666},"Earthwork",{"$f":"AssumptionPage!B50","v":0.75},null,{"$f":"F232*H$231","v":61669.966583333342},"Earthwork",{"$f":"AssumptionPage!C50","v":0.65},null,{"$f":"J232*L$231","v":267794.67722222226},"Earthwork"]
["Drainage",{"$f":"AssumptionPage!B51","v":0.18},null,{"$f":"B233*D$231","v":28485.737379999999},"Drainage",{"$f":"AssumptionPage!B51","v":0.18},null,{"$f":"F233*H$231","v":14800.791980000002},"Drainage",{"$f":"AssumptionPage!C51","v":0.18},null,{"$f":"J233*L$231","v":74158.525999999998},"Drainage"]
["Erosion Control",{"$f":"AssumptionPage!B52","v":0.12},null,18990.491586666667,"Erosion Control",{"$f":"AssumptionPage!B52","v":0.12},null,9867.1946533333339,"Erosion Control",{"$f":"AssumptionPage!C52","v":0.12},null,49439.017333333337,"Erosion Control"]
["Signs",{"$f":"AssumptionPage!B53","v":0.01},null,1582.5409655555557,"Signs",{"$f":"AssumptionPage!B53","v":0.01},null,822.26622111111124,"Signs",{"$f":"AssumptionPage!C53","v":0.04},null,16479.672444444444,"Signs"]
["Pavement Marking",{"$f":"AssumptionPage!B54","v":0.04},null,6330.1638622222226,"Pavement Marking",{"$f":"AssumptionPage!B54","v":0.04},null,3289.0648844444449,"Pavement Marking",{"$f":"AssumptionPage!C54","v":0.08},null,32959.344888888889,"Pavement Marking"]
["Traffic Control",{"$f":"AssumptionPage!B55","v":0.15},null,23738.114483333335,"Traffic Control",{"$f":"AssumptionPage!B55","v":0.15},null,12333.993316666669,"Traffic Control",{"$f":"AssumptionPage!C55","v":0.15},null,61798.771666666667,"Traffic Control"]
["Utility",{"$f":"AssumptionPage!B56","v":0.03},null,4747.6228966666667,"Utility",{"$f":"AssumptionPage!B56","v":0.03},null,2466.7986633333335,"Utility",{"$f":"AssumptionPage!C56","v":0.03},null,12359.754333333334,"Utility"]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D231:D238),-3)","v":361000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H231:H238),-3)","v":187000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(L231:L238),-3)","v":927000},"Total = ",null,null,{"$f":"SUM(P231:P238)","v":200000}]
[null,null,"Cost / LF =",{"$f":"ROUND(D239/$C212,-2)","v":1200},null,null,"Cost / LF =",{"$f":"H239/C214","v":1870}]
[]
[]
["Bridges"]
["Bridge Cost per SF",null,120,null,{"$f":"IF(D244>0,D244,C244)","v":120}]
["Bridge Length",null,1,"LF"]
["Bridge Width",null,1,"LF"]
[]
[]
[]
[]
["Bridge Replacements",null,null,null,"New Bridge"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Bridge (SF)",{"$f":"$E$244","v":120},{"$f":"C245*C246","v":1},{"$f":"B253*C253","v":120},"Bridge (SF)",{"$f":"$E$244","v":120},{"$f":"C245*C246","v":1},{"$f":"F253*G253","v":120}]
["Bridge Removal",{"$f":"B253*0.2","v":24},{"$f":"C253","v":1},24,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["Sum =",null,null,{"$f":"SUM(D253:D262)","v":144},"Sum =",null,null,{"$f":"SUM(H253:H262)","v":120}]
["Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"B264*D$263","v":0},"Earthwork",{"$f":"AssumptionPage!B61","v":0},null,{"$f":"F264*H$263","v":0}]
["Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"B265*D$263","v":0},"Drainage",{"$f":"AssumptionPage!B62","v":0},null,{"$f":"F265*H$263","v":0}]
["Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0,"Erosion Control",{"$f":"AssumptionPage!B63","v":0},null,0]
["Signs",{"$f":"AssumptionPage!B64","v":0},null,0,"Signs",{"$f":"AssumptionPage!B64","v":0},null,0]
["Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0,"Pavement Marking",{"$f":"AssumptionPage!B65","v":0},null,0]
["Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0,"Traffic Control",{"$f":"AssumptionPage!B66","v":0},null,0]
["Utility",{"$f":"AssumptionPage!B67","v":0.03},null,4.32,"Utility",{"$f":"AssumptionPage!B67","v":0.03},null,{"$f":"F270*H$263","v":3.5999999999999996}]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D263:D270),-1)","v":150},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H263:H270),-1)","v":120}]
[null,null,"Cost / SF =",{"$f":"D271/C253","v":150},null,null,"Cost / SF =",{"$f":"H271/G253","v":120}]
[]
[]
["Non-Motorized Elements"]
["Length of Sidewalk / Multi-use Trail",null,1,"Miles",{"$f":"C276*5280","v":5280},"LF"]
["Sidewalk Stand Along Project Width",null,5,null,{"$f":"IF(D277>0,D277,C277)","v":5},"Feet"]
["Width of bike lane (incl gutter)",null,5,null,{"$f":"IF(D278>0,D278,C278)-2","v":3},"Feet"]
[]
[]
[]
[]
["Multi-Use Trails (Assume 10' wide) - Asphalt",null,null,null,"Multi-Use Trails (Assume 10' Wide) - Concrete",null,null,null,"Sidewalk stand along project",null,null,null,"Bike Lanes"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Pavement (SY)",{"$f":"$V$16","v":21.022199999999998},{"$f":"$E$276*10/9","v":5866.666666666667},{"$f":"B285*C285","v":123330.23999999999},"Pavement (SY)",{"$f":"$V$23","v":51.13},{"$f":"$E$276*10/9","v":5866.666666666667},{"$f":"F285*G285","v":299962.66666666669},"Sidewalk  (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($E$276*$E$277)/9","v":2933.3333333333335},{"$f":"J285*K285","v":125194.66666666667},"Pavement (SY)",{"$f":"Calculations!N16","v":83.824550000000002},{"$f":"($E$276*$E$278/9)*2","v":3520},{"$f":"N285*O285","v":295062.41600000003}]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$E$276","v":5280},{"$f":"J286*K286","v":178293.86666666667},"Sidewalk (SY)",{"$f":"GDOT_Prices!$C$14","v":42.68},{"$f":"($E$276*$E$277)/9*2","v":5866.666666666667},{"$f":"N286*O286","v":250389.33333333334}]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"Curb & Gutter (LF)",{"$f":"GDOT_Prices!$C$17+(GDOT_Prices!$C$4*2.5/9)","v":33.767777777777781},{"$f":"$E$276*2","v":10560},{"$f":"N287*O287","v":356587.73333333334}]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item",null,null,null,"User-Defined Item"]
["Sum = ",null,null,{"$f":"SUM(D285:D294)","v":123330.23999999999},"Sum = ",null,null,{"$f":"SUM(H285:H294)","v":299962.66666666669},"Sum = ",null,null,{"$f":"SUM(L285:L294)","v":303488.53333333333},"Sum = ",null,null,{"$f":"SUM(P285:P294)","v":902039.48266666662}]
["Earthwork",{"$f":"AssumptionPage!B72","v":0.4},null,{"$f":"B296*D$295","v":49332.095999999998},"Earthwork",{"$f":"AssumptionPage!B72","v":0.4},null,{"$f":"F296*H$295","v":119985.06666666668},"Earthwork",{"$f":"AssumptionPage!C72","v":0.18},null,{"$f":"J296*L$295","v":54627.935999999994},"Earthwork",{"$f":"AssumptionPage!D72","v":0.75},null,{"$f":"N296*P$295","v":676529.61199999996}]
["Drainage",{"$f":"AssumptionPage!B73","v":0.12},null,{"$f":"B297*D$295","v":14799.628799999999},"Drainage",{"$f":"AssumptionPage!B73","v":0.12},null,{"$f":"F297*H$295","v":35995.520000000004},"Drainage",{"$f":"AssumptionPage!C73","v":0},null,{"$f":"J297*L$295","v":0},"Drainage",{"$f":"AssumptionPage!D73","v":0.18},null,{"$f":"N297*P$295","v":162367.10687999998}]
["Erosion Control",{"$f":"AssumptionPage!B74","v":0.12},null,14799.628799999999,"Erosion Control",{"$f":"AssumptionPage!B74","v":0.12},null,35995.520000000004,"Erosion Control",{"$f":"AssumptionPage!C74","v":2.1999999999999999E-2},null,6676.7477333333327,"Erosion Control",{"$f":"AssumptionPage!D74","v":0.12},null,108244.73791999999]
["Signs",{"$f":"AssumptionPage!B75","v":0.01},null,1233.3024,"Signs",{"$f":"AssumptionPage!B75","v":0.01},null,2999.626666666667,"Signs",{"$f":"AssumptionPage!C75","v":0.04},null,12139.541333333333,"Signs",{"$f":"AssumptionPage!D75","v":0.01},null,9020.3948266666666]
["Pavement Marking",{"$f":"AssumptionPage!B76","v":3.0000000000000001E-3},null,369.99071999999995,"Pavement Marking",{"$f":"AssumptionPage!B76","v":3.0000000000000001E-3},null,899.88800000000003,"Pavement Marking",{"$f":"AssumptionPage!C76","v":0.1},null,30348.853333333333,"Pavement Marking",{"$f":"AssumptionPage!D76","v":0.04},null,36081.579306666667]
["Traffic Control",{"$f":"AssumptionPage!B77","v":0.03},null,3699.9071999999996,"Traffic Control",{"$f":"AssumptionPage!B77","v":0.03},null,8998.880000000001,"Traffic Control",{"$f":"AssumptionPage!C77","v":7.0000000000000007E-2},null,21244.197333333334,"Traffic Control",{"$f":"AssumptionPage!D77","v":0.15},null,135305.92239999998]
["Miscellaneous",{"$f":"AssumptionPage!B78","v":0.25},null,30832.559999999998,"Miscellaneous",{"$f":"AssumptionPage!B78","v":0.25},null,74990.666666666672,"Miscellaneous",{"$f":"AssumptionPage!C78","v":0.3},null,91046.56,"Miscellaneous",{"$f":"AssumptionPage!D78","v":0.03},null,27061.184479999996]
["Utility",{"$f":"AssumptionPage!B79","v":0},null,{"$f":"B303*D$295","v":0},"Utility",{"$f":"AssumptionPage!B79","v":0},null,0,"Utility",{"$f":"AssumptionPage!C79","v":0},null,0,"Utility",{"$f":"AssumptionPage!D79","v":0},null,0]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D295:D303),-3)","v":238000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H295:H303),-3)","v":580000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(L295:L303),-3)","v":520000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(P295:P303),-3)","v":2057000}]
[null,null,"Cost / Mile =",{"$f":"D304/$C276","v":238000},null,null,"Cost / Mile =",{"$f":"H304/$C276","v":580000},null,null,"Cost / Mile =",{"$f":"L304/$C276","v":520000},null,null,"Cost / Mile =",{"$f":"P304/$C276","v":2057000}]
[]
[]
["Walls"]
["Length of Sound Barrier Walls (15' Ht)",null,5280,"LF"]
["Length of Retaining Walls (12' Ht)",null,5280,"LF"]
[]
[]
[]
[]
[]
["Sound Barrier Walls",null,null,null,"Retaining Walls"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Sound Walls (SF)",{"$f":"GDOT_Prices!$C$20","v":19.25},{"$f":"C309*15","v":79200},{"$f":"B318*C318","v":1524600},"Retaining Walls (SF)",{"$f":"GDOT_Prices!$C$21","v":45.77},{"$f":"C310*12","v":63360},{"$f":"F318*G318","v":2899987.2}]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["User-Defined Item",null,null,null,"User-Defined Item"]
["Total =",null,null,{"$f":"ROUND(D318,-3)","v":1525000},"Total =",null,null,{"$f":"ROUND(H318,-3)","v":2900000}]
[]
[]
["ITS"]
["ITS - Freeway",null,1,"Mile"]
["ITS - Arterial",null,1,"Mile"]
[]
[]
[]
[]
[]
["ITS - Freeway",null,null,null,"ITS - Arterial"]
[null,"Cost/Unit","Qty","Costs",null,"Cost/Unit","Qty","Costs"]
["Fiber/Conduit",310000,1,{"$f":"B341*C341","v":310000},"Fiber/Conduit",265000,1,{"$f":"F341*G341","v":265000}]
["Closed Circuit TV Camera ",70000,1,{"$f":"B342*C342","v":70000},"Closed Circuit TV Camera ",35000,1,{"$f":"F342*G342","v":35000}]
["Changeable Message Sign ",60000,1,{"$f":"B343*C343","v":60000},"Changeable Message Sign ",35000,1,35000]
["Video Detection System ",105000,1,{"$f":"B344*C344","v":105000},"User-Defined Item",null,null,0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,0]
["User-Defined Item",null,null,null,"User-Defined Item",null,null,0]
["Subtotal = ",null,null,{"$f":"ROUND(SUM(D341:D350),-3)","v":545000},"Subtotal = ",null,null,{"$f":"ROUND(SUM(H341:H350),-3)","v":335000}]

{"sheet":"CalculationSpreadsheet","index":14,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,0,18,0],[8,0,8,6]]}
["ATLANTA REGIONAL COMMISSION"]
["PLANNING LEVEL COST ESTIMATION TOOL"]
["Input Data Verification"]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,null,null,"ARC Project ID:",{"$f":"PI_ID","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,null,null,"To Limit:",{"$f":"PI_To","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,null,null,"Area:",{"$f":"PI_Area","v":0}]
[]
["You have entered the following information for the project. Please verify if all information is accurate. If you would like to modify any of the elements, click the arrow to go back."]
[]
["Project Elements","Detailed Project Type","Unit","Total Construction Cost","Contingency%","Contingency% Override","Contingency $"]
["Freeway Widening",{"$f":"Freeway!B10","v":"N/A"},{"$f":"IF(B12=\"N/A\",0,Freeway!G15)","v":0},{"$f":"Freeway!G19","v":0},{"$f":"IF(B12<>\"N/A\",AssumptionPage!F6,0)","v":0},null,{"$f":"IF(F12>0, D12*F12, D12*E12)","v":0}]
["Managed Lanes (HOV, HOT, TOT) ",{"$f":"ManagedLanes!B10","v":"N/A"},{"$f":"IF(B13=\"N/A\",0,ManagedLanes!G15)","v":0},{"$f":"ManagedLanes!G19","v":0},{"$f":"IF(B13<>\"N/A\",AssumptionPage!F7,0)","v":0},null,{"$f":"IF(F13>0, D13*F13, D13*E13)","v":0}]
["General Purpose Roadway Capacity",{"$f":"GPRoadway!B11","v":"N/A"},{"$f":"IF(B14=\"N/A\",0,GPRoadway!G17)","v":0},{"$f":"GPRoadway!G21","v":0},{"$f":"IF(B14<>\"N/A\",AssumptionPage!F8,0)","v":0},null,0]
["Interchanges & \nGrade Separations",{"$f":"InterchangeGSep!A11","v":"N/A"},{"$f":"IF(B15=\"N/A\",0,InterchangeGSep!G11)","v":0},{"$f":"InterchangeGSep!G15","v":0},{"$f":"IF(B15<>\"N/A\",AssumptionPage!F9,0)","v":0},null,0]
["Intersection Improvements",{"$f":"Intersections!A12","v":"Turning Lanes - Left"},{"$f":"ints_lt_number","v":0},{"$f":"ints_lt_tcost","v":0},{"$f":"IF(C16<>0,AssumptionPage!F10,0)","v":0},null,0]
[null,{"$f":"Intersections!A13","v":"Turning Lanes - Right"},{"$f":"ints_rt_number","v":0},{"$f":"ints_lt_tcost","v":0},{"$f":"IF(C17<>0,AssumptionPage!F10,0)","v":0},null,0]
[null,{"$f":"Intersections!A14","v":"Roundabout"},{"$f":"ints_rb_number","v":0},{"$f":"ints_lt_tcost","v":0},{"$f":"IF(C18<>0,AssumptionPage!F10,0)","v":0},null,0]
[null,{"$f":"Intersections!A15","v":"Signal"},{"$f":"ints_sig_number","v":0},{"$f":"ints_lt_tcost","v":0},{"$f":"IF(D19<0,AssumptionPage!F10,0)","v":0},null,0]
["Bridges",{"$f":"Bridge!A11","v":"N/A"},{"$f":"IF(B20=\"N/A\",0,bg_number)","v":0},{"$f":"Bridge!G19","v":0},{"$f":"IF(B20<>\"N/A\",AssumptionPage!F10,0)","v":0},null,0]
["Non-Motorized Elements \n(Sidewalks, Trails, Bike Lanes)",{"$f":"NonMotorized!A11","v":"N/A"},{"$f":"IF(B21=\"N/A\",0,NonMotorized!G11)","v":0},{"$f":"NonMotorized!G15","v":0},{"$f":"IF(B21<>\"N/A\",AssumptionPage!F11,0)","v":0},null,0]
["Walls (Sound Barrier, Retaining)",{"$f":"Walls!A11","v":"N/A"},{"$f":"IF(B22=\"N/A\",0,Walls!G11)","v":0},{"$f":"Walls!G15","v":0},{"$f":"IF(B22<>\"N/A\",AssumptionPage!F12,0)","v":0},null,0]
["Intelligent Transportation \nSystems (ITS)",{"$f":"ITS!A11","v":"N/A"},{"$f":"IF(B23=\"N/A\",0,ITS!G11)","v":0},{"$f":"ITS!G16","v":0},{"$f":"IF(B23<>\"N/A\",AssumptionPage!F13,0)","v":0},null,0]
[]
["ROW",null,"Unit (acres)","Total ROW Cost"]
["Right-of-Way Acquisition",null,{"$f":"row_area","v":0},{"$f":"row_tcost","v":0}]

{"sheet":"FinalCostEstimation","index":15,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,0,9,4],[11,0,11,1],[20,0,20,2],[33,0,33,4]]}
["ATLANTA REGIONAL COMMISSION"]
["PLANNING LEVEL COST ESTIMATION TOOL"]
["Planning Level Cost Estimate Summary "]
[]
["Project Name:",{"$f":"ProjectInformation!B6","v":0},null,"ARC Project ID:",{"$f":"ProjectInformation!E6","v":0}]
["From Limit:",{"$f":"ProjectInformation!B8","v":0},null,"To Limit:",{"$f":"ProjectInformation!E8","v":0}]
["County:",{"$f":"ProjectInformation!B10","v":"Hall"},null,"Area:",{"$f":"ProjectInformation!E10","v":0}]
[]
[]
["Enter proposed project implementation schedule below.  Adjust the default inflation rate as appropriate."]
[]
["IMPLEMENTATION SCHEDULE",null,null,"Default Annual Inflation Rate","Annual Inflation Rate Override"]
["Activity","Begin (Year)",null,{"$f":"DefaultAnnualInfRate","v":0.04}]
["Preliminary Engineering"]
[null,null,null,"Current Year"]
["Right of Way",null,null,{"$f":"YEAR(NOW())","v":2011}]
[]
["Construction"]
[]
[]
["ESTIMATED PROJECT COST"]
["Activity","Base Estimate","Year of Expenditure"]
["Preliminary Engineering",{"$f":"B27*0.1","v":0},{"$f":"IF($E$13>0,ROUND(B23*(1+$E$13)^(B14-D16),-3),ROUND(B23*(1+$D$13)^(B14-D16),-3))","v":0}]
[]
["Right of Way",{"$f":"ROW!D26","v":0},{"$f":"IF($E$13>0,ROUND(B25*(1+$E$13)^(B16-D16),-3),ROUND(B25*(1+$D$13)^(B16-D16),-3))","v":0},null,null,"Start Over"]
[null,null,null,null,null,"Start Over"]
["Construction",{"$f":"SUM(CalculationSpreadsheet!D12:D23)","v":0},{"$f":"IF($E$13>0,ROUND(B27*(1+$E$13)^(B18-D16),-3),ROUND(B27*(1+$D$13)^(B18-D16),-3))","v":0},null,null,"Start Over"]
[]
["Contingency",{"$f":"SUM(CalculationSpreadsheet!G12:G23)","v":0},{"$f":"ROUND((C23+C25+C27)/(B23+B25+B27)*B29,-3)","v":{"$error":"#DIV/0!"}}]
[]
["Total",{"$f":"B23+B25+B27+B29","v":0},{"$f":"C23+C25+C27+C29","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Cost Estimating Worksheet"]

{"sheet":"ROWDatabase","index":16,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,1,4,1],[1,1,1,5]]}
[]
[null,"Right of Way Assumption"]
[]
[null,"County Name","Cost Per Acre ($) by Area Type"]
[null,null,"Commercial","Residential","Agricultural","Industrial"]
[1,"Barrow",400000,50000,15000,75000]
[2,"Bartow",300000,50000,20000,30000]
[3,"Carroll",400000,25000,15000,20000]
[4,"Cherokee",400000,100000,50000,75000]
[5,"Clayton",400000,40000,25000,50000]
[6,"Cobb",700000,150000,75000,200000]
[7,"Coweta",200000,50000,20000,25000]
[8,"DeKalb",700000,150000,100000,150000]
[9,"Douglas",250000,75000,25000,100000]
[10,"Fayette",300000,40000,20000,35000]
[11,"Forsyth",400000,100000,25000,30000]
[12,"Fulton - North",{"$f":"MAX(C11,C13,C20)","v":700000},{"$f":"MAX(D11,D13,D20)","v":150000},{"$f":"MAX(E11,E13,E20)","v":100000},{"$f":"MAX(F11,F13,F20)","v":200000}]
[null,"Fulton - City of Atlanta",2000000,500000,25000,1167000]
[null,"Fulton - South",{"$f":"MAX(C10,C14)","v":400000},{"$f":"MAX(D10,D14)","v":75000},{"$f":"MAX(E10,E14)","v":25000},{"$f":"MAX(F10,F14)","v":100000}]
[13,"Gwinnett",400000,100000,25000,200000]
[14,"Hall",350000,50000,25000,150000]
[15,"Henry",350000,50000,15000,75000]
[16,"Newton",350000,50000,15000,75000]
[17,"Paulding",250000,75000,20000,100000]
[18,"Rockdale",350000,100000,20000,125000]
[19,"Spalding",350000,50000,15000,75000]
[20,"Walton",300000,100000,15000,75000]
[null,"Source: GDOT RUCEST Tool"]

{"sheet":"AssumptionPage","index":17,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[[47,0,48,0],[47,1,47,2],[69,0,70,0],[69,1,69,3],[58,0,59,0],[58,1,59,1],[36,0,37,0],[36,1,37,1],[3,1,3,2],[3,0,4,0],[14,0,15,0],[14,1,14,2],[25,0,26,0],[25,1,25,3]]}
["Mark-Up Items Assumption",null,null,null,"Contingency Assumption"]
[]
["Freeway Widening"]
["Mark-up Items","Default Percentages",null,null,"Project Elements","Contingency Assumptions"]
[null,"Urban ","Rural",null,"Freeway Widening",0.35]
["Earthwork",0.15,0.15,null,"Managed Lanes",0.35]
["Drainage",0.05,0.05,null,"Surface Street New/Widening",0.2]
["Erosion Control",0.05,0.05,null,"Interchanges & Grade Separations",0.3]
["Signs",0.06,0.06,null,"Intersections",0.1]
["Pavement Marking",0.03,0.03,null,"Bridges",0.1]
["Traffic Control",0.25,0.25,null,"Non-Motorized Elements",0.1]
["Utility",0.03,0.03,null,"Walls",0.1]
[null,null,null,null,"ITS",0.05]
["Managed Lanes"]
["Mark-up Items","Default Percentages",null,null,"Inflation Rate Assumption"]
[null,"Buffer Separated","Barrier Separated",null,"Default Annual Inflation Rate:",0.04]
["Earthwork",0.2,0.25]
["Drainage",7.0000000000000007E-2,7.0000000000000007E-2]
["Erosion Control",0.05,0.05]
["Signs",0.08,0.05]
["Pavement Marking",0.06,0.06]
["Traffic Control",0.2,0.25]
["Utility",0.03,0.03]
[]
["Surface Street New/Widening"]
["Mark-up Items","Default Percentages"]
[null,"Widening ","New Alignment","Passing Lanes/Frontage Roads/Auxiliary Lanes"]
["Earthwork",0.75,0.75,0.65]
["Drainage",0.18,0.18,0.18]
["Erosion Control",0.12,0.12,0.12]
["Signs",0.01,0.02,0.05]
["Pavement Marking",0.04,0.04,0.04]
["Traffic Control",0.15,0.05,0.2]
["Utility",0.03,0.03,0.03]
[]
["Interchanges & Grade Separations"]
["Mark-up Items","Default Percentages"]
[]
["Earthwork",0.4]
["Drainage",0.05]
["Erosion Control",0.05]
["Signs",0.01]
["Pavement Marking",0.01]
["Traffic Control",0.25]
["Utility",0.03]
[]
["Intersection Improvements"]
["Mark-up Items","Default Percentages"]
[null,"Turning Lanes","Roundabout"]
["Earthwork",0.75,0.65]
["Drainage",0.18,0.18]
["Erosion Control",0.12,0.12]
["Signs",0.01,0.04]
["Pavement Marking",0.04,0.08]
["Traffic Control",0.15,0.15]
["Utility",0.03,0.03]
[]
["Bridges"]
["Mark-up Items","Default Percentages"]
[]
["Earthwork",0]
["Drainage",0]
["Erosion Control",0]
["Signs",0]
["Pavement Marking",0]
["Traffic Control",0]
["Utility",0.03]
[]
["Non-Motorized Elements (Sidewalks, Trails, Bike Lanes)"]
["Mark-up Items","Default Percentages"]
[null,"Multi-Use Trails","Sidewalk","Bike Lanes"]
["Earthwork",0.4,0.18,0.75]
["Drainage",0.12,0,0.18]
["Erosion Control",0.12,2.1999999999999999E-2,0.12]
["Signs",0.01,0.04,0.01]
["Pavement Marking",3.0000000000000001E-3,0.1,0.04]
["Traffic Control",0.03,7.0000000000000007E-2,0.15]
["Utility",0.25,0.3,0.03]
[]
["Right-of-Way Acquisition"]
["ROW Default Factor",2.5]

{"sheet":"UnitCostSpreadsheet","index":18,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[45,0,47,0],[40,0,44,0],[48,0,50,0],[3,0,8,0],[9,0,13,0],[14,0,23,0],[24,0,31,0],[32,0,36,0],[37,0,39,0]]}
["Project Type List with Unit Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M4:M52)","v":0}]
["Categories/Elements","List of Project Type","Area Type","Project Type + Urban Type","Per Unit Cost","Unit","Assumed ROW"]
["Freeway Widening","N/A"," Urban",{"$f":"B4 &C4","v":"N/A Urban"},0,"Per Mile (1-Lane each Dir)",null,null,{"$f":"cbPROCESS1","v":false},{"$f":"IF(D4=fr_type_area,TRUE,FALSE)","v":false},{"$f":"AND(I4,J4)","v":false},{"$f":"IF(K4,G4,0)","v":0},{"$f":"L4*fr_length","v":0}]
[null,"Interstate Widening - Asphalt"," Urban",{"$f":"B5 &C5","v":"Interstate Widening - Asphalt Urban"},{"$f":"Calculations!D61","v":14168000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F33*Calculations!F35)/43560","v":2.9090909090909092},null,false,false,{"$f":"AND(I5,J5)","v":false},{"$f":"IF(K5,G5,0)","v":0},0]
[null,"Interstate Widening - Concrete"," Urban",{"$f":"B6 &C6","v":"Interstate Widening - Concrete Urban"},{"$f":"Calculations!H62","v":16815000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F33*Calculations!F35)/43560","v":2.9090909090909092},null,false,false,false,0,0]
[null,null,"Rural",{"$f":"B4 & C7","v":"N/ARural"},0,"Per Mile (1-Lane each Dir)",null,null,false,false,false,0,0]
[null,null,"Rural",{"$f":"B5 & \" \" & C8","v":"Interstate Widening - Asphalt Rural"},{"$f":"Calculations!M62","v":5425000},"Per Mile (1-Lane each Dir)",0,null,false,false,false,0,0]
[null,null,"Rural",{"$f":"B6 & \" \" & C9","v":"Interstate Widening - Concrete Rural"},{"$f":"Calculations!Q62","v":6102000},"Per Mile (1-Lane each Dir)",0,null,false,false,false,0,0]
["Managed Lanes","N/A",null,{"$f":"B10 &C10","v":"N/A"},0,"Per Mile (1-Lane each Dir)"]
[null,"Managed Lane Buffer Separated - Asphalt",null,"Managed Lane Buffer Separated - Asphalt",{"$f":"Calculations!D95","v":11103000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F67*Calculations!F69)/43560","v":2.9090909090909092}]
[null,"Managed Lane Buffer Separated - Concrete",null,"Managed Lane Buffer Separated - Concrete",{"$f":"Calculations!H95","v":12516000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F67*Calculations!F69)/43560","v":2.9090909090909092}]
[null,"Managed Lane Barrier Separated - Asphalt",null,"Managed Lane Barrier Separated - Asphalt",{"$f":"Calculations!L95","v":20454000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F67*(Calculations!F69+Calculations!F71+Calculations!F73))/43560","v":7.7575757575757578}]
[null,"Managed Lane Barrier Separated - Concrete",null,"Managed Lane Barrier Separated - Concrete",{"$f":"Calculations!P95","v":23276000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F67*(Calculations!F69+Calculations!F71+Calculations!F73))/43560","v":7.7575757575757578}]
["General Purpose Roadway Capacity","N/A"," Urban","N/A Urban",0,"Per Mile (1-Lane each Dir)"]
[null,"General Purpose Roadway Widening with Median"," Urban","General Purpose Roadway Widening with Median Urban",{"$f":"Calculations!D128","v":6234000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!C109+Calculations!C112)/4840","v":4.7272727272727275}]
[null,"General Purpose Roadway Widening without Median"," Urban","General Purpose Roadway Widening without Median Urban",{"$f":"Calculations!H128","v":4777000},"Per Mile (1-Lane each Dir)",{"$f":"Calculations!G109/4840","v":2.9090909090909092}]
[null,"New Alignments"," Urban","New Alignments Urban",{"$f":"Calculations!L128","v":3914000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F100*50)/9/4840","v":6.0606060606060606}]
[null,"Frontage Rd / Passing Lanes"," Urban","Frontage Rd / Passing Lanes Urban",{"$f":"Calculations!P128","v":4057000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F100*50)/9/4840","v":6.0606060606060606}]
[null,null," Rural",{"$f":"B15 &C20","v":"N/A Rural"},0,"Per Mile (1-Lane each Dir)"]
[null,null," Rural",{"$f":"B16 &C21","v":"General Purpose Roadway Widening with Median Rural"},{"$f":"Calculations!D160","v":5399000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!C141+Calculations!C144)/4840","v":6}]
[null,null," Rural",{"$f":"B17 &C22","v":"General Purpose Roadway Widening without Median Rural"},{"$f":"Calculations!H160","v":3771000},"Per Mile (1-Lane each Dir)",{"$f":"Calculations!G141/4840","v":3.6969696969696968}]
[null,null," Rural",{"$f":"B18 &C23","v":"New Alignments Rural"},{"$f":"Calculations!L160","v":3285000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F132*50)/9/4840","v":6.0606060606060606}]
[null,null," Rural",{"$f":"B19 &C24","v":"Frontage Rd / Passing Lanes Rural"},{"$f":"Calculations!P160","v":3405000},"Per Mile (1-Lane each Dir)",{"$f":"(Calculations!F132*50)/9/4840","v":6.0606060606060606}]
["Interchanges & Grade Separations","N/A",null,{"$f":"B25 &C25","v":"N/A"},0,"Per Each"]
[null,"Compressed Diamond",null,"Compressed Diamond",{"$f":"Calculations!D208","v":13606000},"Per Each",{"$f":"98010/43560","v":2.25}]
[null,"Single Point Urban",null,"Single Point Urban",{"$f":"Calculations!H208","v":24258000},"Per Each",{"$f":"359370/43560","v":8.25}]
[null,"Diamond",null,"Diamond",{"$f":"Calculations!L208","v":15951000},"Per Each",{"$f":"816750/43560","v":18.75}]
[null,"Half Diamond",null,"Half Diamond",{"$f":"Calculations!P208","v":9021000},"Per Each",{"$f":"54450/43560","v":1.25}]
[null,"HOV/Managed Lanes Direct Access Interchange",null,"HOV/Managed Lanes Direct Access Interchange",{"$f":"Calculations!T208","v":13616000},"Per Each",{"$f":"108900/43560","v":2.5}]
[null,"Grade Sep - 4 lanes",null,"Grade Sep - 4 lanes",{"$f":"Calculations!X208","v":5920000},"Per Each",{"$f":"87120/43560","v":2}]
[null,"Grade Sep - 2 lanes",null,"Grade Sep - 2 lanes",{"$f":"Calculations!AB208","v":4189000},"Per Each",{"$f":"87120/43560","v":2}]
["Intersection Improvements","N/A",null,"N/A",0]
[null,"Turning Lanes - Left",null,"Turning Lanes - Left",{"$f":"Calculations!D240","v":1200},"Per Feet (Bay Queue Length)",{"$f":"(Calculations!C221+Calculations!C223)/4840","v":0.34664830119375573}]
[null,"Turning Lanes - Right",null,"Turning Lanes - Right",{"$f":"Calculations!H240","v":1870},"Per Feet (Bay Queue Length)",{"$f":"Calculations!G221/4840","v":0.15564738292011021}]
[null,"Roundabout",null,"Roundabout",{"$f":"Calculations!L239","v":927000},"Per Each",{"$f":"31124/4840","v":6.4305785123966945}]
[null,"Signal",null,"Signal",{"$f":"Calculations!P239","v":200000},"Per Each",0]
["Bridges","N/A",null,"N/A",0,"Per Each"]
[null,"Bridge Replacements",null,"Bridge Replacements",{"$f":"Calculations!D272","v":150},"Per Square Feet",0]
[null,"New Bridge",null,"New Bridge",{"$f":"Calculations!H272","v":120},"Per Square Feet",0]
["Non-Motorized Elements (Sidewalks, Trails, Bike Lanes)","N/A",null,"N/A",0,"Per Mile"]
[null,"Multi-Use Trails (Assume 10' wide) - Asphalt",null,"Multi-Use Trails (Assume 10' wide) - Asphalt",{"$f":"Calculations!D305","v":238000},"Per Mile",{"$f":"Calculations!C285/4840","v":1.2121212121212122}]
[null,"Multi-Use Trails (Assume 10' Wide) - Concrete",null,"Multi-Use Trails (Assume 10' Wide) - Concrete",{"$f":"Calculations!H305","v":580000},"Per Mile",{"$f":"Calculations!G285/4840","v":1.2121212121212122}]
[null,"Sidewalks Along Project",null,{"$f":"B44 &C44","v":"Sidewalks Along Project"},{"$f":"Calculations!L305","v":520000},"Per Mile",{"$f":"Calculations!K285/4840","v":0.60606060606060608}]
[null,"Bike Lanes",null,{"$f":"B45 &C45","v":"Bike Lanes"},{"$f":"Calculations!P305","v":2057000},"Per Mile (1-Lane each Dir)",{"$f":"Calculations!O285/4840","v":0.72727272727272729}]
["Walls (Sound Barrier, Retaining)","N/A",null,"N/A",0,"Per Mile"]
[null,"Sound Barrier Walls",null,"Sound Barrier Walls",{"$f":"Calculations!D328","v":1525000},"Per Mile",0]
[null,"Retaining Walls",null,"Retaining Walls",{"$f":"Calculations!H328","v":2900000},"Per Mile",0]
["Intelligent Transportation Systems (ITS)","N/A",null,"N/A",0,"Per Mile"]
[null,"ITS - Freeway",null,{"$f":"B50","v":"ITS - Freeway"},{"$f":"Calculations!D351","v":545000},"Per Mile",0]
[null,"ITS - Arterial",null,"ITS - Arterial",{"$f":"Calculations!H351","v":335000},"Per Mile",0]

{"sheet":"GDOT_Prices","index":19,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Costs from GDOT's Mean Item Summary (Date)"]
["Item #","Description","Price","Unit"]
["310-5060","GR AGGR BASE CRS, 6 INCH, INCL MATL",13.43,"SY"]
["310-5120","GR AGGR BASE CRS, 12 INCH, INCL MATL",52.48,"SY"]
["400-3604","ASPH CONC 12.5 MM SMA, GP 2 ONLY, INCL POLYMER-MODIFIED",155.81,"TN"]
["400-3624","ASPH CONC 12.5 MM PEM, GP 2 ONLY, INCL POLYMER-MODIFIED",169.51,"TN"]
["402-3121","RECYCLED ASPH CONC 25 MM SUPERPAVE, GP 1 OR 2, INCL BITUM",74.66,"TN"]
["402-3130","RECYCLED ASPH CONC 12.5 MM SUPERPAVE, GP 2 ONLY, INCL BITUM",69.02,"TN"]
["402-3190","RECYCLED ASPH CONC 19 MM SUPERPAVE, GP 1 OR 2,INCL BITUM",81.040000000000006,"TN"]
["413-1000","BITUM TACK COAT",2.59,"GL"]
["432-5010","MILL ASPH CONC PVMT, VARIABLE DEPTH",3.35,"SY"]
["436-1000","ASPHALTIC CONCRETE CURB",13.41,"LF"]
["439-0026","PLAIN PC CONC PVMT, CL 3 CONC, 12 INCH THK",104.12,"SY"]
["441-0104","CONC SIDEWALK, 4 IN",42.68,"SY"]
["441-0106","CONC SIDEWALK, 6 IN",37.700000000000003,"SY"]
["441-0740","CONCRETE MEDIAN, 4 IN",32.06,"SY"]
["441-6222","CONC CURB & GUTTER, 8 IN X 30 IN, TP 2",19.190000000000001,"LF"]
["610-2700","REM CONCRETE",4.25,"SY"]
["621-3020","CONCRETE BARRIER, TYPE 20",50.75,"LF"]
["624-0400","SOUND BARRIER, TYPE-",19.25,"SF"]
["627-1010","MSE WALL FACE, 10 - 20 FT HT, WALL NO",45.77,"SF"]
["641-1200","GUARDRAIL, TP W",19.73,"LF"]
["641-5001","GUARDRAIL ANCHORAGE, TP 1",703.4,"EA"]
["641-5006","GUARDRAIL ANCHORAGE, TP 6",356,"EA"]
["641-5012","GUARDRAIL ANCHORAGE, TP 12",1918.18,"EA"]
["649-0018","CONCRETE GLARE SCREEN, 27 INCH",32.659999999999997,"LF"]