{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Cost Estimate Summary","Cost Estimate Tracking V2","Assumptions Tracking","Inflation Summary & Upload","Inflation Tables","Sliding Scales"],"not_rendered":{"charts":3,"images":5,"macros":1,"external_links":3,"defined_names":18,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,20],[9,1,9,18]]}
[]
[null,"Instructions"]
[]
[1,"The Cost Estimate Summary tab serves as the data entry tab for the workbook."]
[2,null,"When entering data, please note that green cells require input."]
[3,null,"Grey cells do not require input"]
[4,"Ensure input where required. If no value then enter \"0\""]
[5,"Complete the general information portion at the top of the sheet."]
[6,"Drop down lists are provided for County/City/State, tier level and stage of development."]
[7,"Preliminary Engineering Phase costs include all expenses charged by the design staff (VDOT or Consultant) of each discipline through the advertisement of the project. Any of the support during the CN phase would be included in the CEI estimate."]
[8,"When using discipline only contingencies, Source, Defined, Allowances, Risk Type, and Contingencies should be entered in order for the total column to be calculated."]
[9,"When a complete phase contingency is selected and discipline contingencies are both selected an error message will appear."]
[10,"Discipline costs that span project development phases are to be shown in the phase that the time is charged. It can be captured in a discipline or in oversight, depending on what is appropriate."]
[11,"Right of Way & Utilities Phase costs include all expenses for right of way acquisition and utility relocations."]
[12,"Construction Phase costs include all expenses incurred from award to construction completion."]
[13,"Defined values, Allowances and Contingencies should be entered for each of the applicable disciplines.  Refer to the contingencies shown in Chapter 5 of the Cost Estimating manual for assistance determining the correct contingency percentage. The contingencies provided in the sliding scales are provided as a cross check.  They are intended to supplement and aid the estimator's engineering and human judgment."]
[14,"Major assumptions in Defined numbers and selection of contingency percentage needs to be documented in the \"Assumptions\" column."]
[15,"Application estimates should use their submitted schedule"]
[16,"Once all applicable fields have been entered and you are comfortable with the output, select the blue button corresponding to your current project milestone to transfer your estimate to the Cost Estimate Tracking tab"]
[17,"A feature has been added on the \"Inflation Summary & Upload\" sheet that enables the transer of CEWB estimate data to your PCES Workbook."]

{"sheet":"Cost Estimate Summary","index":1,"n_rows":256,"n_cols":21,"rows_kept":256,"cut":false,"hidden":false,"merged":[[91,4,91,6],[96,1,96,3],[96,4,96,6],[30,1,30,2],[37,1,37,2],[39,1,39,6],[92,1,92,2],[93,1,93,2],[94,1,94,2],[40,1,42,1],[75,1,77,1],[65,1,65,2],[81,6,82,6],[92,4,92,5],[95,4,95,5],[91,1,91,3],[1,1,1,7],[2,2,2,3],[3,2,3,3],[9,3,9,7],[9,1,9,2],[8,1,8,2],[7,1,7,7],[8,4,8,7],[5,3,5,4],[4,2,4,3],[44,4,44,7],[24,1,24,4],[93,4,93,5],[94,4,94,5],[81,7,82,7],[81,1,82,4],[90,1,90,7],[26,1,28,1],[29,1,29,7],[30,4,30,7],[43,1,43,7],[69,1,69,2],[67,1,67,4],[38,1,38,4],[64,3,64,4],[60,3,60,4]]}
[]
[null,"SYIP PROJECTS\nDETAILED PROJECT COST ESTIMATE SUMMARY\n(Version 2.2: 7/7/2023)",null,null,null,null,null,null,null,"Green Cells require input.  Allowance / Contingency are not necessarily required. All others are auto calculating.  Estimate to be entered based on current dollars and inflation will be applied at the bottom of this workbook for informational purposes only."]
[null,"Portal ID:",null,null,null,"Project UPC:",null,null,null,null,null,null,null,null,null,"Select Phase Risk Type Here (when using different contingency values for each discipline)",null,null,null,null,"Select Phase Risk Type Here (when using one phase contingency value)"]
[null,"Prepared By:",null,null,null,"Milestone","Select",null,null,null,null,null,null,null,null,"Type 1 Percentage",null,"$",null,null,"Type 1 Percentage"]
[null,"Reviewed By:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 2 Deterministic",null,"%",null,null,"Type 2 Deterministic"]
[null,"Project Location:","Locality Type","Locality Name",null,"Tier Level","Select"]
[null,"Project Complexity Classification","Select Project Classification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 1 Percentage"]
[null,"Preliminary Engineering Phase ",null,7,"Do not enter a negative value for defined or allowance; Ensure input where required. If no value then enter \"0\" ",null,null,null,null,null,null,null,null,null,null,"Select",null,null,null,null,"Type 2 Deterministic"]
[null,"Project Estimate Component",null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage"]
[null,"Discipline","Source","Defined($)","Allowance*","Risk Type","Contingency  %           (Value of Risk)","Total",null,"Assumptions",null,null,null,null,null,"Lump Sum"]
[null,"Project Management","Select",null,null,null,null,{"$f":"IF(C12=\"Select\",0,(D12+E12))","v":0}]
[null,"Roadway","Select",null,null,null,null,{"$f":"IF(C13=\"Select\",0,(D13+E13))","v":0}]
[null,"Hydraulics","Select",null,null,null,null,0]
[null,"Utilities","Select",null,null,null,null,0,null,null,null,null,null,null,null,"CEI Environmental Inspection\n(Enter %)"]
[null,"Traffic","Select",null,null,null,null,0,null,null,null,null,null,null,null,"CEI VDOT or Locality\n(Enter %)"]
[null,"Structures/Bridges","Select",null,null,null,null,0,null,null,null,null,null,null,null,"CEI Oversight Costs\n(Enter %)"]
[null,"Materials/Geotech","Select",null,null,null,null,0]
[null,"Survey/SUE/Quality Level A SUE","Select",null,null,null,null,0]
[null,"Environmental","Select",null,null,null,null,0,null,null,null,null,null,null,null,"CEI Environmental Inspection\n(Enter Lump Sum)"]
[null,"Right of Way","Select",null,null,null,null,0,null,null,null,null,null,null,null,"CEI VDOT or Locality\n(Enter Lump Sum)"]
[null,"Other","Select",null,null,null,null,0,null,null,null,null,null,null,null,"CEI Oversight Costs\n(Enter Lump Sum)"]
[null,"VDOT PE Oversight on Local Assistance Projects","Total entered from LAD Spreadsheet",null,null,null,null,"Input Req'd"]
[null,null,"SUBTOTAL PE PHASE ESTIMATE                                                 (Without Contingency)",{"$f":"SUM(D12:D22)","v":0},{"$f":"SUM(E12:E22)","v":0},"Select Phase Risk Type Below",{"$f":"IF(F25=\"Type 1 Percentage\",\"Contingency  %                       (Value of Risk)\",IF(F25=\"Type 2 Deterministic\",\"Contingency  $                       (Value of Risk)\",\"Contingency\"))","v":"Contingency"}]
[null,"Phase Risk Type and Contingency (Value of Risk):                                                                                                                                                                                                                                                                                                                                                                                                              For Type 1 enter % amount;  For Type 2 enter $ amount",null,null,null,"Select",null,{"$f":"IF(F25=\"type 1 Percentage\",(D24+E24)*((G25/100)),IF(F25=\"type 2 Deterministic\",G25,0))","v":0},null,null,null,null,null,null,null,"CEI Environmental Inspection"]
[null,null,null,null,null,null,"TOTAL PE PHASE ESTIMATE",{"$f":"IF(F25=\"Select\",SUM(H12:H23),SUM(H12:H23,H25))","v":0},null,null,null,null,null,null,null,"CEI VDOT or Locality"]
[null,"Phase dates (XX/XX/XXXX)","PE Base Estimate Date",null,null,null,null,null,null,null,null,null,null,null,null,"CEI Oversight Costs"]
[null,null,"Start Date"]
[null,null,"End Date"]
[]
[null,"Right-of-Way & Utilities Phase",null,null,"Do not enter a negative value for defined or allowance costs; For Contingency Values please refer to the ROW Cost Estimate Guide Section 8"]
[null,"Discipline","Source","Defined ($)","Allowance*","Select Phase Risk Type Here (when using different contingency values for each discipline)",{"$f":"IF(F32=\"Type 1 Percentage\",\"Contingency                                      (% of Risk)\",IF(F32=\"Type 2 Deterministic\",\"Contingency  $                       (Value of Risk)\",\"Contingency                                    (Value of Risk)\"))","v":"Contingency                                    (Value of Risk)"},"Total",null,"Assumptions"]
[null,"Right-of-Way Acquisition","Select",null,null,null,null,{"$f":"IF(AND(C33=\"select\"),0,IF(F32=\"type 1 Percentage\",(D33+E33)*((1+(G33/100))),IF(F32=\"type 2 Deterministic\",D33+E33+G33,IF(F39=\"type 1 Percentage\",(D33+E33),IF(F39=\"type 2 Deterministic\",D33+E33,0)))))","v":0}]
[null,"Utilities","Select",null,null,null,null,{"$f":"IF(AND(C34=\"select\"),0,IF(F32=\"type 1 Percentage\",(D34+E34)*((1+(G34/100))),IF(F32=\"type 2 Deterministic\",D34+E34+G34,IF(F39=\"type 1 Percentage\",(D34+E34),IF(F39=\"type 2 Deterministic\",D34+E34,0)))))","v":0}]
[null,"VDOT Project RW/UT Oversight","Select",null,null,null,null,{"$f":"IF(AND(C35=\"select\"),0,IF(F32=\"type 1 Percentage\",(D35+E35)*((1+(G35/100))),IF(F32=\"type 2 Deterministic\",D35+E35+G35,IF(F39=\"type 1 Percentage\",(D35+E35),IF(F39=\"type 2 Deterministic\",D35+E35,0)))))","v":0}," "]
[null,"VDOT RW/UT Oversight on Local Assistance Projects","Total entered from LAD Spreadsheet",null,null,null,null,"Input Req'd"]
[]
[null,"SUBTOTAL RW PHASE ESTIMATE                                                         (Without Contingency)",null,{"$f":"SUM(D33:D35)","v":0},{"$f":"SUM(E33:E35)","v":0},"RW Contingency:",{"$f":"IF(AND(F39=\"Select Phase Risk Type Here (when using one phase contingency value)\",F32=\"Type 1 percentage\"),(SUM(H33:H35)-SUM(D38:E38))/SUM(D38:E38),IF(AND(F39=\"Select Phase Risk Type Here (when using one phase contingency value)\",F32=\"Type 2 Deterministic\"),(H33+H34+H35-D38-E38)/(D38+E38)*100,IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"Type 2 Deterministic\"),G39/(D38+E38),IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"Type 1 Percentage\"),G39/100,\"\"))))","v":""},{"$f":"ABS(SUM(H33:H35)-SUM(D33:E35))","v":0}]
[null,"Phase Risk Type and Contingency (Value of Risk):                                                                                                                                                                                                                                                                                                                                                                                                              Use only if applying one contingency to entire phase.   For Type 1 enter % amount;  For Type 2 enter $ amount",null,null,null,"Select Phase Risk Type Here (when using one phase contingency value)",null,{"$f":"IF((G38)<0, \"Complete Inputs from C33 to C35 if available\", IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"Select Phase Risk Type Here (when using one Phase contingency value)\"),SUM(H33:H35),IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"type 2 Deterministic\"),G39,IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"type 1 Percentage\"),(G39/100)*(H33+H34+H35),IF(AND(F32=\"type 1 Percentage\",F39=\"Select Phase Risk Type Here (when using one phase contingency value)\"),H33+H34+H35-D38-E38,IF(AND(F32=\"type 2 Deterministic\",F39=\"Select Phase Risk Type Here (when using one phase contingency value)\"),H33+H34+H35-D38-E38,\"Select one risk type\"))))))","v":0}]
[null,"TOTAL RW PHASE ESTIMATE",null,null,null,null,null,{"$f":"IF(AND(F32=\"Type 1 percentage\",F39=\"Select Phase Risk Type Here (when using one phase contingency value)\"),SUM(H33:H36),IF(AND(F32=\"type 2 Deterministic\",F39=\"Select Phase Risk Type Here (when using one phase contingency value)\"),SUM(H33:H36),IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"type 1 percentage\"),SUM(H33:H36,H39),IF(AND(F32=\"Select Phase Risk Type Here (when using different contingency values for each discipline)\",F39=\"type 2 Deterministic\"),SUM(H33:H36,H39),SUM(H33:H36,H39)))))","v":0}]
[null,"Phase dates (XX/XX/XXXX)","RW Base Estimate Date"]
[null,null,"Start Date"]
[null,null,"End Date"]
[]
[null,"Construction Phase",null,null,"Do not enter a negative value for defined or allowance costs;  Ensure input where required. If no value then enter \"0\"; \"0\" will result in a gray cell;                                                                          Total shown is dependent on Risk Type (Phase or Discipline)"]
[null,"Discipline","Source","Defined ($)","Allowance*","Discipline Risk Type                                          (Use when selecting many)","Contingency                         (Value of or % of Risk)","Total",null,"Assumptions"]
[null,"Mobilization/Construction Support","Select","Input Req'd","Input Req'd","Select",null,{"$f":"IF(AND(C47=\"select\"),0,IF(AND(F47=\"Select\",$F$68=\"Select\"),SUM(D47:E47),IF(AND(F47=\"Select\",$F$68<>\"Select\"),SUM(D47:E47),IF(AND(F47=\"type 1 Percentage\",$F$68=\"Select\"),(SUM(D47:E47)*((1+(G47)/100))),IF(AND($F$68=\"Select\",F47=\"type 2 Deterministic\"),SUM(D47,E47,G47),IF(AND(F47<>\"Select\",$F$68<>\"Select\"),\"Remove Phase or Change Discipline Risk type to 'Select'\"))))))","v":0}]
[null,"MOT","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Roadway","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Hydraulics","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"In-plan Utilities","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Traffic","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Structures/Bridges","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Earthwork/Geotech","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Environmental/Soundwalls","Select","Input Req'd","Input Req'd","Select",null,0]
[null,"Other","Select","Input Req'd","Input Req'd","Select",null,0]
[null,null,"Total Bid Items",{"$f":"SUM(D47:D56)","v":0},{"$f":"SUM(E47:E56)","v":0},null,0,{"$f":"SUM(H47:H56)","v":0}]
[null,"VDOT Project CN Oversight","Select","Input Req'd","Input Req'd","Select",null,{"$f":"IF(AND(C58=\"select\",F58=\"Select\"),SUM(D58:E58),IF(AND(F58=\"Select\",$F$68=\"Select\"),SUM(D58:E58),IF(AND(F58=\"Select\",$F$68<>\"Select\"),SUM(D58:E58),IF(AND(F58=\"type 1 Percentage\",$F$68=\"Select\"),(D58+E58)*((1+(G58)/100)),IF(AND($F$68=\"Select\",F58=\"type 2 Deterministic\"),D58+E58+G58,IF(AND(F58<>\"Select\",$F$68<>\"Select\"),\"Remove Phase or Change Discipline Risk type to 'Select'\"))))))","v":0}]
[null,"VDOT CN Oversight on Local Assistance Projects","Total entered from LAD Spreadsheet",null,null,null,null,"Input Req'd"]
[null,null,null,null,null,null,"Oversight Total",{"$f":"SUM(H58:H59)","v":0}]
[null,"Management Reserve / Construction Contract Contingency  Per IIM-LD-249","Select","Cell C61 is multiplied by the Total Bid Items Cost (H57) to get H61",null,null,null,{"$f":"IF(C61=\"select\",0,($H$57)*C61)","v":0}]
[null,"Railroad Flagging/Coordination",null,"Input Req'd","Input Req'd","Select",null,{"$f":"IF(AND(F62=\"Select\",$F$68=\"Select\"),SUM(D62:E62),IF(AND(F62=\"Select\",$F$68<>\"Select\"),SUM(D62:E62),IF(AND(F62=\"type 1 Percentage\",$F$68=\"Select\"),SUM(D62:E62)*((1+(G62)/100)),IF(AND($F$68=\"Select\",F62=\"type 2 Deterministic\"),SUM(D62:E62:G62),IF(AND(F62<>\"Select\",$F$68<>\"Select\"),\"Remove Phase or Change Discipline Risk type to 'Select'\")))))","v":0}]
[null,"State Forces",null,"Input Req'd","Input Req'd","Select",null,{"$f":"IF(AND(F63=\"Select\",$F$68=\"Select\"),SUM(D63:E63),IF(AND(F63=\"Select\",$F$68<>\"Select\"),SUM(D63:E63),IF(AND(F63=\"type 1 Percentage\",$F$68=\"Select\"),SUM(D63:E63)*((1+(G63)/100)),IF(AND($F$68=\"Select\",F63=\"type 2 Deterministic\"),SUM(D63:E63:G63),IF(AND(F63<>\"Select\",$F$68<>\"Select\"),\"Remove Phase or Change Discipline Risk type to 'Select'\")))))","v":0}]
[null,"State Police",null,"Input Req'd","Input Req'd","Select",null,{"$f":"IF(AND(F64=\"Select\",$F$68=\"Select\"),SUM(D64:E64),IF(AND(F64=\"Select\",$F$68<>\"Select\"),SUM(D64:E64),IF(AND(F64=\"type 1 Percentage\",$F$68=\"Select\"),SUM(D64:E64)*((1+(G64)/100)),IF(AND($F$68=\"Select\",F64=\"type 2 Deterministic\"),SUM(D64:E64:G64),IF(AND(F64<>\"Select\",$F$68<>\"Select\"),\"Remove Phase or Change Discipline Risk type to 'Select'\")))))","v":0}]
[null,"Contract Requirements\n(Incentive/Disincentive; 5% max)","Select","Cell C65 is multiplied by the Total Bid Items Cost (H57) to get H65",null,null,null,{"$f":"IF(C65=\"select\",0,($H$57)*C65)","v":0}]
[null,"Total Non-Bid Items",null,{"$f":"SUM(D61:D65)","v":0},{"$f":"SUM(E61:E65)","v":0},null,null,{"$f":"SUM(H61:H65)","v":0},null,"r"]
[]
[null,"Phase Risk Type and Contingency (Value of Risk):                                                                                                                                                                                                                                                                                                                                                                                                              Use only if applying one contingency to entire phase.   For Type 1 enter % amount;  For Type 2 enter $ amount",null,null,null,"Select",null,{"$f":"IF(F68=\"type 1 Percentage\",((SUM(H47:H56)+SUM(H62:H64)+SUM(H58)))*((G68/100)),IF(F68=\"type 2 Deterministic\",G68,0))","v":0}]
[null,null,"See Section 5.4.3 in PreCON Manual",null,null,null,"Total CN Estimate without CEI",{"$f":"SUM(H68,H66,H60,H57)","v":0}]
[null,"Construction Engineering (CEI) Source:  ",null,"Select",{"$f":"IF(D70=\"Select\",\"Please select Percentage or Lump Sum from Cell D70\",IF(D70=\"Percentage\",\"CEI is calculated as a \"&D70&\" value of the Total Bid Items Cost (H57)\",IF(D70=\"Lump Sum\",\"CEI is calculated as a Lump Sum input in Cells C71-C73 below by estimator\")))","v":"Please select Percentage or Lump Sum from Cell D70"}]
[null,{"$f":"IF($D$70=$P$9,P25,IF($D$70=$P$10,P15,P20))","v":"CEI Environmental Inspection"},null,{"$f":"IF(C71=\"\",\"\",IF($D$70=$P$10,(C71*($H$57))/100,C71))","v":""},null,"Select",0,{"$f":"IF(AND($D$70=\"select\",C71=0),0,IF(AND($D$70=$P$10,F71=\"Type 1 Percentage\",C71<>\"\"),(D71)+(D71)*(G71/100),IF(AND($D$70=$P$10,F71=\"Type 2 Deterministic\",C71<>\"\"),(D71+G71),IF(AND($D$70=$P$11,F71=\"Type 1 Percentage\",C71<>\"\"),(D71)+(D71)*(G71/100),IF(AND($D$70=$P$11,F71=\"Type 2 Deterministic\",C71<>\"\"),D71+G71,D71)))))","v":0}]
[null,{"$f":"IF($D$70=$P$9,P26,IF($D$70=$P$10,P16,P21))","v":"CEI VDOT or Locality"},null,{"$f":"IF(C72=\"\",\"\",IF($D$70=$P$10,(C72*($H$57))/100,C72))","v":""},null,"Select",0,{"$f":"IF(AND($D$70=\"select\",C72=0),0,IF(AND($D$70=$P$10,F72=\"Type 1 Percentage\",C72<>\"\"),(D72)+(D72)*(G72/100),IF(AND($D$70=$P$10,F72=\"Type 2 Deterministic\",C72<>\"\"),(D72+G72),IF(AND($D$70=$P$11,F72=\"Type 1 Percentage\",C72<>\"\"),(D72)+(D72)*(G72/100),IF(AND($D$70=$P$11,F72=\"Type 2 Deterministic\",C72<>\"\"),D72+G72,D72)))))","v":0}]
[null,"CEI Oversight Costs",null,{"$f":"IF(C73=\"\",\"\",IF($D$70=$P$10,(C73*($H$57))/100,C73))","v":""},null,"Select",0,0]
[null,null,null,null,null,null,"Total CEI",{"$f":"SUM(H71:H73)","v":0}]
[null,null,null,null,null,null,"Total CN Estimate",{"$f":"SUM(H74,H69)","v":0}]
[null,"Phase dates (XX/XX/XXXX)","CN Base Estimate Date"]
[null,null,"Start Date"]
[null,null,"End Date"]
[]
[null,null,null,null,null,null,"TOTAL PROJECT COST ESTIMATE (excluding inflation) (PE+RW+CN)",{"$f":"SUM(H26,H40,H75)","v":0}]
[]
[null,"Total Project Cost Estimate Summary",null,null,null,"Date of Current Cost"]
[null,null,null,null,null,"Enter date here"]
[null,"Phase","Estimate ($) without                   LAP OVERSIGHT COST","Contingency ($)",null,"Total Phase* "]
[null,"PE Phase Estimate",{"$f":"SUM(D24:E24)","v":0},{"$f":"IF(H23=\"input Req'd\",(H26-D24-E24),H26-D24-E24-H23)","v":0},null,{"$f":"IF(H26=(SUM(C85,D85,H23)),(SUM(C85,D85,H23)),\"Review PE Estimate\")","v":0}]
[null,"RW Phase Estimate ",{"$f":"SUM(D38:E38)","v":0},{"$f":"IF(SUM(H33:H35)=0, 0, IF(F39=\"Type 2 Deterministic\",G39,IF(F39=\"Type 1 Percentage\",H39,(SUM(H33,H34,H35-D38-E38)))))","v":0},null,{"$f":"IF(H40=(SUM(C86,D86,H36)),(SUM(C86,D86,H36)),\"Review R/W Estimate\")","v":0}]
[null,"CN Phase Estimate(without CEI)",{"$f":"SUM(D57:E58)+SUM(D66:E66)+H61+H65","v":0},{"$f":"IF($F$68=\"Type 1 Percentage\",H68,IF($F$68=\"Type 2 Deterministic\",H68,IF($F$68=\"Select\",(SUM(H57:H58,H62:H64)-(SUM(D57:E58,D62:E64))))))","v":0},null,{"$f":"IF(H69=(SUM(C87,D87,H59)),(SUM(C87,D87,H59)),\"Review CN Estimate\")","v":0}]
[null,"Total CEI",{"$f":"SUM(D71:E73)","v":0},{"$f":"H74-SUM(D71:E73)","v":0},null,{"$f":"IF(H74=(SUM(C88,D88)),(SUM(C88,D88)),\"Review CEI Estimate\")","v":0}]
[null,"CN Phase Estimate(with CEI)",{"$f":"SUM(C87:C88)","v":0},{"$f":"D87+D88","v":0},null,{"$f":"IF(H75=(SUM(C89,D89,H59)),(SUM(C89,D89,H59)),\"Review CN Estimate\")","v":0}]
[null,"Total Estimate",{"$f":"SUM(C85:C88)","v":0},{"$f":"SUM(D85:D86,D89)","v":0},null,{"$f":"IF(H80=(SUM(C90,D90,H23,H36,H59)),(SUM(C90,D90,H23,H36,H59)),\"Review Estimate\")","v":0}]
[null,"* Use combined Defined, Allowance, Contingency Costs and LAP Oversight. Total Phase includes Oversight Costs and Contract Requirements."]
[null,"Base Estimate Dollar amounts for  SMART PORTAL entry:",null,null,"Risks/Contingency/Unknowns Dollar amounts for SMART PORTAL entry"]
[null,"PE Base Estimate =",null,{"$f":"+F85-D85","v":0},"PE Phase Risk/Contingency/Unknowns =",null,{"$f":"D85","v":0}]
[null,"RW Base Estimate =",null,{"$f":"+F86-D86","v":0},"RW Phase Risk/Contingency/Unknowns =",null,{"$f":"D86","v":0}]
[null,"CN Base Estimate =",null,{"$f":"+F87-D87","v":0},"CN Phase Estimate Risk/Contingency =",null,{"$f":"D87","v":0}]
[null,null,null,null,"CEI amount = ",null,{"$f":"F88","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select"]
[null,1]
[null,2]
[null,null,"Select","Select","Select"]
[null,null,"SPLCE","Creation/Pre Scope","Non-Complex (Minor)"]
[null,null,"PCES","Final Scoping/PFI","Moderately Complex"]
[null,null,"Bristol Tool","Public Hearing/PI","Most Complex (Major)"]
[null,null,"Staunton Estimating Spreadsheet Tool","Field Inspection"]
[null,null,"AASHTO Precon","Pre Adv. Conference"]
[null,null,"Consultant"]
[null,null,"Similar Project","Select"]
[null,null,"Profess. Judgement","Aerial Photo"]
[null,null,"Norms","Tax Map"]
[null,null,"Other","Other "]
[null,null,"Aerial Photo"]
[null,null,"Tax Map","Pre-Scoping Plans"]
[null,null,"Pre-Scoping Plans","Scoping Plans"]
[null,null,"Scoping Plans","F.I. Plans"]
[null,null,"F.I. Plans","R/W Plans"]
[null,null,"R/W Plans","PAC Plans"]
[null,null,"PAC Plans"]
[]
[null,null,"Locality Type","Arlington County (00)","City of Alexandria (100)","Town of Abingdon (140)"]
[null,null,"City","Accomack County (01)","City of Bedford (141)","Town of Alberta(161)"]
[null,null,"County","Albemarle County (02)","City of Bristol (102)","Town of Alta Vista (162)"]
[null,null,"Town","Alleghany County (03)","City of Buena Vista (103)","Town of Altavista(162)"]
[null,null,null,"Amelia County (04)","City of Charlottesville (104)","Town of Appalachia(164)"]
[null,null,null,"Amherst County (05)","City of Chesapeake (131)","Town of Ashland (166)"]
[null,null,null,"Appomattox County (06)","City of Colonial Heights (105)","Town of Belle Haven(167)"]
[null,null,null,"Augusta County (07)","City of Covington (107)","Town of Berryville(168)"]
[null,null,null,"Bath County (08)","City of Danville (108)","Town of Big Stone Gap (101)"]
[null,null,null,"Bedford County (09)","City of Emporia (109)","Town of Blacksburg (150)"]
[null,null,null,"Bland County (10)","City of Fairfax (151)","Town of Blackstone (142)"]
[null,null,null,"Botetourt County (11)","City of Falls Church (110)","Town of Bluefield (143)"]
[null,null,null,"Brunswick County (12)","City of Franklin (145)","Town of Boones Mill(170)"]
[null,null,null,"Buchanan County (13)","City of Fredericksburg (111)","Town of Bridgewater (176)"]
[null,null,null,"Buckingham County (14)","City of Galax (113)","Town of Broadway(177)"]
[null,null,null,"Campbell County (15)","City of Hampton (114)","Town of Brodnax(178)"]
[null,null,null,"Caroline County (16)","City of Harrisonburg (115)","Town of Burkeville(181)"]
[null,null,null,"Carroll County (17)","City of Hopewell (116)","Town of Cape Charles(182)"]
[null,null,null,"Charles City County (18)","City of Lexington (117)","Town of Cedar Bluff(184)"]
[null,null,null,"Charlotte County (19)","City of Lynchburg (118)","Town of Charlotte C.H.(185)"]
[null,null,null,"Chesterfield County (20)","City of Manassas (155)","Town of Chase City (186)"]
[null,null,null,"Clarke County (21)","City of Manassas Park (152)","Town of Chatham(187)"]
[null,null,null,"Craig County (22)","City of Martinsville (120)","Town of Cheriton(188)"]
[null,null,null,"Culpeper County (23)","City of Newport News (121)","Town of Chilhowie(189)"]
[null,null,null,"Cumberland County (24)","City of Norfolk (122)","Town of Chincoteague (190)"]
[null,null,null,"Dickenson County (25)","City of Norton (146)","Town of Christiansburg (154)"]
[null,null,null,"Dinwiddie County (26)","City of Petersburg (123)","Town of Clarksville(192)"]
[null,null,null,"Essex County (28)","City of Poquoson (147)","Town of Clifton Forge (105)"]
[null,null,null,"Fairfax County (29)","City of Portsmouth (124)","Town of Clinchco(339)"]
[null,null,null,"Fauquier County (30)","City of Radford (126)","Town of Clintwood(196)"]
[null,null,null,"Floyd County (31)","City of Richmond (127)","Town of Coeburn(198)"]
[null,null,null,"Fluvanna County (32)","City of Roanoke (128)","Town of Colonial Beach (199)"]
[null,null,null,"Franklin County (33)","City of Salem (129)","Town of Craigsville(202)"]
[null,null,null,"Frederick County (34)","City of South Boston (130)","Town of Crewe(203)"]
[null,null,null,"Giles County (35)","City of Staunton (132)","Town of Culpeper (204)"]
[null,null,null,"Gloucester County (36)","City of Suffolk (133)","Town of Damascus(205)"]
[null,null,null,"Goochland County (37)","City of Virginia Beach (134)","Town of Dayton(206)"]
[null,null,null,"Grayson County (38)","City of Waynesboro (136)","Town of Dillwyn(208)"]
[null,null,null,"Greene County (39)","City of Williamsburg (137)","Town of Duffield(211)"]
[null,null,null,"Greensville County (40)","City of Winchester (138)","Town of Dumfries (212)"]
[null,null,null,"Halifax County (41)",null,"Town of Dungannon(213)"]
[null,null,null,"Hanover County (42)",null,"Town of Elkton (216)"]
[null,null,null,"Henrico County (43)",null,"Town of Exmore(217)"]
[null,null,null,"Henry County (44)",null,"Town of Farmville (144)"]
[null,null,null,"Highland County (45)",null,"Town of Floyd(219)"]
[null,null,null,"Isle of Wight County (46)",null,"Town of Front Royal (112)"]
[null,null,null,"James City County (47)",null,"Town of Gate City(221)"]
[null,null,null,"King George County (48)",null,"Town of Glade Spring(222)"]
[null,null,null,"King & Queen County (49)",null,"Town of Glasgow(223)"]
[null,null,null,"King William County (50)",null,"Town of Gordonsville(225)"]
[null,null,null,"Lancaster County (51)",null,"Town of Grottoes (228)"]
[null,null,null,"Lee County (52)",null,"Town of Grundy(228)"]
[null,null,null,"Loudoun County (53)",null,"Town of Hamilton(232)"]
[null,null,null,"Louisa County (54)",null,"Town of Haymarket(233)"]
[null,null,null,"Lunenburg County (55)",null,"Town of Herndon (235)"]
[null,null,null,"Madison County (56)",null,"Town of Hillsboro(236)"]
[null,null,null,"Mathews County (57)",null,"Town of Independence(240)"]
[null,null,null,"Mecklenburg County (58)",null,"Town of Irvington(242)"]
[null,null,null,"Middlesex County (59)",null,"Town of Kenbridge(247)"]
[null,null,null,"Montgomery County (60)",null,"Town of Kilmarnock(249)"]
[null,null,null,"Nelson County (62)",null,"Town of La Crosse(250)"]
[null,null,null,"New Kent County (63)",null,"Town of Lawrenceville(251)"]
[null,null,null,"Northampton County (65)",null,"Town of Lebanon (252)"]
[null,null,null,"Northumberland County (66)",null,"Town of Leesburg (253)"]
[null,null,null,"Nottoway County (67)",null,"Town of Louisa"]
[null,null,null,"Orange County (68)",null,"Town of Lovettsville(255)"]
[null,null,null,"Page County (69)",null,"Town of Luray (159)"]
[null,null,null,"Patrick County (70)",null,"Town of Madison"]
[null,null,null,"Pittsylvania County (71)",null,"Town of Marion (119)"]
[null,null,null,"Powhatan County (72)",null,"Town of Middleburg(259)"]
[null,null,null,"Prince Edward County (73)",null,"Town of Middletown(260)"]
[null,null,null,"Prince George County (74)",null,"Town of Mineral(261)"]
[null,null,null,"Prince William County (76)",null,"Town of Monterey(262)"]
[null,null,null,"Pulaski County (77)",null,"Town of Mt. Jackson(265)"]
[null,null,null,"Rappahannock County (78)",null,"Town of Narrows (266)"]
[null,null,null,"Richmond County (79)",null,"Town of New Market(269)"]
[null,null,null,"Roanoke County (80)",null,"Town of Nickelsville(271)"]
[null,null,null,"Rockbridge County (81)",null,"Town of Occoquan(272)"]
[null,null,null,"Rockingham County (82)",null,"Town of Onancock(273)"]
[null,null,null,"Russell County (83)",null,"Town of Orange (275)"]
[null,null,null,"Scott County (84)",null,"Town of Pearisburg (279)"]
[null,null,null,"Shenandoah County (85)",null,"Town of Pennington Gap(281)"]
[null,null,null,"Smyth County (86)",null,"Town of Pocahontas(283)"]
[null,null,null,"Southampton County (87)",null,"Town of Pulaski (125)"]
[null,null,null,"Spotsylvania County (88)",null,"Town of Purcellville(286)"]
[null,null,null,"Stafford County (89)",null,"Town of Quantico(287)"]
[null,null,null,"Surry County (90)",null,"Town of Remington(288)"]
[null,null,null,"Sussex County (91)",null,"Town of Rich Creek(289)"]
[null,null,null,"Tazewell County (92)",null,"Town of Richlands (148)"]
[null,null,null,"Warren County (93)",null,"Town of Rocky Mount (157)"]
[null,null,null,"Washington County (95)",null,"Town of Round Hill(291)"]
[null,null,null,"Westmoreland County (96)",null,"Town of Rural Retreat(292)"]
[null,null,null,"Wise County (97)",null,"Town of Saint Paul(394)"]
[null,null,null,"Wythe County (98)",null,"Town of Saltville (295)"]
[null,null,null,"York County (99)",null,"Town of Scottsville(298)"]
[null,null,null,null,null,"Town of Shenandoah(299)"]
[null,null,null,null,null,"Town of Smithfield (300)"]
[null,null,null,null,null,"Town of South Hill (301)"]
[null,null,null,null,null,"Town of Stanardsville(302)"]
[null,null,null,null,null,"Town of Stephens City(304)"]
[null,null,null,null,null,"Town of Strasburg (306)"]
[null,null,null,null,null,"Town of Tangier(309)"]
[null,null,null,null,null,"Town of Tazewell (158)"]
[null,null,null,null,null,"Town of The Plains(311)"]
[null,null,null,null,null,"Town of Timberville(312)"]
[null,null,null,null,null,"Town of Victoria(317)"]
[null,null,null,null,null,"Town of Vienna (153)"]
[null,null,null,null,null,"Town of Vinton (149)"]
[null,null,null,null,null,"Town of Warrenton(156)"]
[null,null,null,null,null,"Town of Warsaw(321)"]
[null,null,null,null,null,"Town of Washington"]
[null,null,null,null,null,"Town of West Point(325)"]
[null,null,null,null,null,"Town of Wise (329)"]
[null,null,null,null,null,"Town of Woodstock (330)"]
[null,null,null,null,null,"Town of Wytheville (139)"]

{"sheet":"Cost Estimate Tracking V2","index":2,"n_rows":73,"n_cols":30,"rows_kept":73,"cut":false,"hidden":false,"merged":[[70,4,70,6],[19,2,19,3],[18,2,18,3],[17,2,17,3],[29,2,29,3],[49,2,49,3],[26,29,32,29],[27,2,27,3],[66,2,68,2],[37,2,37,3],[34,2,34,3],[35,2,35,3],[26,2,26,3],[28,2,28,3],[48,2,48,3],[50,2,50,3],[59,2,59,3],[36,5,36,6],[52,4,52,5],[56,4,56,5],[2,29,3,29],[3,1,3,3],[2,24,2,28],[2,9,2,13],[2,14,2,18],[3,9,3,13],[3,14,3,18],[3,19,3,23],[2,19,2,23],[3,24,3,28],[2,4,2,8],[7,29,19,29],[22,15,23,16],[34,5,35,6],[57,2,57,3],[2,1,2,3],[26,1,32,1],[38,2,47,2],[33,2,33,3],[36,1,65,1],[7,1,20,1],[6,2,6,3],[25,2,25,3],[8,2,8,3],[9,2,9,3],[7,2,7,3],[5,2,5,3],[70,9,70,11],[70,14,70,16],[70,19,70,21],[10,2,10,3],[11,2,11,3],[22,20,23,21],[22,5,23,6],[22,2,22,3],[33,6,33,7],[12,2,12,3],[13,2,13,3],[14,2,14,3],[23,2,23,3],[15,2,15,3],[21,2,21,3],[16,2,16,3]]}
[]
[null,null,null,null,null,null,"SYIP PROJECTS\nProject Cost Estimate Tracking V2.1","UPC:",null,null,null,"SYIP PROJECTS\nProject Cost Estimate Tracking V2.1","UPC:",null,null,null,"SYIP PROJECTS\nProject Cost Estimate Tracking V2.1","UPC:",null,null,null,"SYIP PROJECTS\nProject Cost Estimate Tracking V2.1","UPC:",null,null,null,"SYIP PROJECTS\nProject Cost Estimate Tracking V2","UPC:"]
[null,"Milestone",null,null,"Creation/Pre Scope",null,null,null,null,"Final Scoping / Preliminary Field Inspection (PFI)",null,null,null,null,"Public Hearing\nTeam Meeting",null,null,null,null,"Field Inspection\nMeeting",null,null,null,null,"Pre-Advertisement\nConference Meeting",null,null,null,null,"Advertisement"]
[null,"Level of Project Development (Design Only)",null,null,null,null,null,null,null,0.2,null,null,null,null,0.4,null,null,null,null,0.75,null,null,null,null,1]
[null,"PRELIMINARY ENGINEERING PHASE"]
[null,null,"Project Estimate Component"]
[null,null,"Discipline",null,"Defined ($)","Allowance",null,null,"Total","Defined ($)","Allowance",null,null,"Total","Defined ($)","Allowance",null,null,"Total","Defined ($)","Allowance",null,null,"Total","Defined ($)","Allowance",null,null,"Total"]
[null,null,"Project Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditures"]
[null,null,"Roadway"]
[null,null,"Hydraulics"]
[null,null,"In-Plan Utilities"]
[null,null,"Traffic"]
[null,null,"Structures/Bridges"]
[null,null,"Materials/Geotech"]
[null,null,"Survey"]
[null,null,"Environmental"]
[null,null,"Right-of-Way"]
[null,null,"Other"]
[null,null,"VDOT PE Oversight on Local Assistance Projects"]
[null,null,"SUBTOTAL PE PHASE ESTIMATE",null,null,null,"Phase Risk Type Below",null,null,null,null,"- Phase Risk Type Below",null,null,null,null,"Phase Risk Type Below",null,null,null,null,"Phase Risk Type Below",null,null,null,null,"Phase Risk Type Below"]
[null,null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)"]
[null,null,"TOTAL PE PHASE ESTIMATE"]
[null,null,"PE Base Estimate Date (XX/XXXX)"]
[null,null,"PE Phase Start Date (XX/XX/XXXX)",null,null,null,null,"End Date",null,null,null,null,"End Date",null,null,null,null,"End Date",null,null,null,null,"End Date",null,null,null,null,"End Date"]
[null,"RIGHT OF WAY AND UTILITIES PHASE"]
[null,null,"Discipline",null,"Defined ($)","Allowance","Select Phase Risk Type Here (if using different contingency values for each discipline)","Contingency                                    (Value of Risk)","Total","Defined ($)","Allowance","Select Phase Risk Type Here (if using different contingency values for each discipline)",null,"Total","Defined ($)","Allowance","Select Phase Risk Type Here (if using different contingency values for each discipline)",null,"Total","Defined ($)","Allowance","Select Phase Risk Type Here (if using different contingency values for each discipline)",null,"Total","Defined ($)","Allowance","Select Phase Risk Type Here (if using different contingency values for each discipline)",{"$f":"IF(AA26=\"Type 1 Percentage\",\"Contingency  %                       (Value of Risk)\",IF(AA26=\"Type 2 Deterministic\",\"Contingency  $                       (Value of Risk)\",\"Contingency                                    (Value of Risk)\"))","v":"Contingency                                    (Value of Risk)"},"Total"]
[null,null,"Right-of-Way",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditures"]
[" ",null,"Utilities"]
[null,null,"VDOT Project RW Oversight"]
[null,null,"VDOT RW/UT Oversight on Local Assistance Projects"]
[]
[null,null,null,"SUBTOTAL RW PHASE ESTIMATE",null,null,"RW Avg Contingency:",null,null,null,null,"RW Avg Contingency:",null,null,null,null,"RW Avg Contingency:",null,null,null,null,"RW Avg Contingency:",null,null,null,null,"RW Avg Contingency:"]
[null,null,null,null,null,"Phase Contingency  (Value of Risk)","Select Phase Risk Type Here (if using one phase contingency value)",null,null,null,"Phase Contingency  (Value of Risk)","Select Phase Risk Type Here (if using one phase contingency value)",null,null,null,"Phase Contingency (Value of Risk)","Select Phase Risk Type Here (if using one phase contingency value)",null,null,null,"Phase Contingency (Value of Risk)","Select Phase Risk Type Here (if using one phase contingency value)",null,null,null,"Phase Contingency (Value of Risk)","Select Phase Risk Type Here (if using one phase contingency value)"]
[null,null,"TOTAL RW PHASE ESTIMATE"]
[null,null,"Base Estimate Date (XX/XXXX)"]
[null,null,"Planned R/W Start Date (XX/XX/XXXX)",null,null,null,null,"End Date",null,null,null,null,"End Date",null,null,null,null,"End Date",null,null,null,null,"End Date",null,null,null,null,"End Date"]
[null,null,"CONSTRUCTION PHASE"]
[null,null,"Discipline",null,"Defined ($)","Allowance","Risk Type","Contingency                         (Value of Risk)","Total","Defined ($)","Allowance","Risk Type","Contingency                         (Value of Risk)","Total","Defined ($)","Allowance","Risk Type","Contingency                         (Value of Risk)","Total","Defined ($)","Allowance","Risk Type","Contingency                         (Value of Risk)","Total","Defined ($)","Allowance","Risk Type","Contingency                         (Value of Risk)","Total"]
[null,null,"Bid Items","Mobilization/Constr. Support"]
[null,null,null,"MOT"]
[null,null,null,"Roadway"]
[null,null,null,"Hydraulics"]
[null,null,null,"In-plan Utilities"]
[null,null,null,"Traffic"]
[null,null,null,"Structures/Bridges"]
[null,null,null,"Earthwork/Geotech"]
[null,null,null,"Environmental/Soundwalls"]
[null,null,null,"Other"]
[null,null,"Total Bid Items"]
[null,null,"VDOT Project CN Oversight"]
[null,null,"VDOT CN Oversight on Local Assistance Projects"]
[null,null,null,null,null,null,null,"Oversight Total:",null,null,null,null,"Oversight Total:",null,null,null,null,"Oversight Total:",null,null,null,null,"Oversight Total:",null,null,null,null,"Oversight Total:"]
[null,null,"Management Reserve / Construction Contract Contingency  Per IIM-LD-249","Select"]
[null,null,"Railroad Flagging/Coordination"]
[null,null,"State Forces"]
[null,null,"State Police"]
[null,null,"Contract Incentive / Disincentive (5% max)","Select"]
[null,null,"Total Non-Bid Items",null,null,null,"CN Avg Contingency:",null,null,null,null,"CN Avg Contingency:",null,null,null,null,"CN Avg Contingency:",null,null,null,null,"CN Avg Contingency:",null,null,null,null,"CN Avg Contingency:"]
[null,null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)",null,null,null,null,"Phase Contingency  (Value of Risk)"]
[null,null,null,null,null,null,null,"TOTAL CN PHASE ESTIMATE (without CEI)",null,null,null,null,"TOTAL CN PHASE ESTIMATE (without CEI)",null,null,null,null,"TOTAL CN PHASE ESTIMATE (without CEI)",null,null,null,null,"TOTAL CN PHASE ESTIMATE (without CEI)",null,null,null,null,"TOTAL CN PHASE ESTIMATE (without CEI)"]
[null,null,"Construction Engineering (CEI) Source:  "]
[null,null,"CEI Environmental Inspection"]
[null,null,"CEI VDOT or Locality"]
[null,null,"CEI Oversight Costs"]
[null,null,null,null,null,null,null,"Total CEI:",null,null,null,null,"Total CEI:",null,null,null,null,"Total CEI:",null,null,null,null,"Total CEI:",null,null,null,null,"Total CEI:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total CN Estimate",null,null,null,null,null,null,null,null,null,"Total CN Estimate",null,null,null,null,"Total CN Estimate"]
[null,null,"Phase dates (XX/XX/XXXX)","CN Base Estimate Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,"Start Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,"End Date"]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Project Cost Estimate:",null,null,null,null,"Total Project Cost Estimate:",null,null,null,null,"Total Project Cost Estimate:",null,null,null,null,"Total Project Cost Estimate:",null,null,null,null,"Total Project Cost Estimate:"]

{"sheet":"Assumptions Tracking","index":3,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[21,1,21,5],[16,1,16,5]]}
["SYIP PROJECTS"]
["DOCUMENTATION OF ASSUMPTIONS AND CHANGE COMMENTS"]
[]
["Preliminary Engineering","Creation / Pre-scope (prior to project initiation)","Final Scoping / Preliminary Field Inspection (PFI)","Public Hearing Team Meeting","Field Inspection Meeting","Pre-advertisement Conference Team Meeting"]
["Project Management"]
["Roadway"]
["Hydraulics"]
["In-Plan Utilities"]
["Traffic"]
["Structures/Bridges"]
["Materials/Geotech"]
["Survey"]
["Environmental"]
["Right-of-Way"]
["Other"]
["VDOT PE Oversight on Local Assistance Projects"]
["Right-of-Way & Utilities"]
["Right-of-Way"]
["Utilities"]
["VDOT Project RW Oversight"]
["VDOT RW/UT Oversight on Local Assistance Projects"]
["Construction"]
["Mobilization/Constr. Support"]
["MOT"]
["Roadway"]
["Hydraulics"]
["In-plan Utilities"]
["Traffic"]
["Structures/Bridges"]
["Earthwork/Geotech"]
["Environmental/Soundwalls"]
["Other"]
["VDOT Project CN Oversight"]
["VDOT CN Oversight on Local Assistance Projects"]
["Management Reserve / Construction Contract Contingency  Per IIM-LD-249"]
["Railroad Flagging/Coordination"]
["State Forces"]
["State Police"]
["Contract Requirements\n(Incentive/Disincentive; 5% max)"]

{"sheet":"Inflation Summary & Upload","index":4,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,2],[21,0,21,4],[22,0,22,4],[24,0,24,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4]]}
[]
[]
[]
[null,"Inflation Factors","Future Cost (including inflation)"]
[]
[null,"Inflation**","Total Cost***"]
["PE Phase Estimate",{"$f":"IFERROR('Inflation Tables'!F4,1)","v":1},{"$f":"'Cost Estimate Summary'!F85*B7","v":0}]
["RW Phase Estimate ",{"$f":"IFERROR('Inflation Tables'!N4,1)","v":1},{"$f":"'Cost Estimate Summary'!F86*B8","v":0}]
["CN Phase Estimate(without CEI)",{"$f":"IFERROR('Inflation Tables'!X4,1)","v":1},{"$f":"'Cost Estimate Summary'!F87*B9","v":0}]
["Total CEI",{"$f":"IFERROR('Inflation Tables'!X4,1)","v":1},{"$f":"'Cost Estimate Summary'!F88*B10","v":0}]
["CN Phase Estimate(with CEI)",{"$f":"IFERROR('Inflation Tables'!X4,1)","v":1},{"$f":"'Cost Estimate Summary'!F89*B11","v":0}]
["Total Estimate","Total:",{"$f":"SUM(C7:C8)+C11","v":0}]
[]
[null,"** Inflation rates taken from VDOT Inflation/Escalation Memorandum, Dated 7/7/2023"]
[null,"*** Total Costs should match with total costs output from SMART Portal."]
[]
[]
["INSTRUCTIONS FOR TRANSFERING A CEWB ESTIMATE INTO A PCES(Workbook)"]
["1. Download the current version of the PCES workbook for your project from the PCES site and save to you computer (you do not need to open it yet) "]
["2. Click the \"Transfer CEWB to PCES\" button below."]
["3. After you click the button you will be prompted to open your PCES workbook.  After opening the workbook, the following will happen automatically:\n     a. The inflated PE, RW and CN estimate will be populated in the MANUAL tab, along with standard phase comments.\n     b. The PE, RW, Utility and CN phase will all be set to “Manual” on the SUMMARY tab.\n     c. The Ad Year and Construction End Year cells will be set to “FY2022” to avoid any inflation calculations in PCES.\n     d. The estimate shown in the SUMMARY tab should match the inflated estimate from your CEWB.\n"]
["4. Review the standard phase comments imported and adjust the comments in the \"MANUAL\" tab for specificity regarding your estimate."]
["5. Save the updated PCES workbook for upload to the PCES site."]

{"sheet":"Inflation Tables","index":5,"n_rows":114,"n_cols":24,"rows_kept":114,"cut":false,"hidden":true,"merged":[[6,24,7,24],[6,6,7,6],[1,0,1,4],[1,8,1,12],[2,16,2,17],[1,18,1,22],[6,14,7,14]]}
[]
["PE PHASE",null,null,null,null,null,null,null,"RW Phase",null,null,null,null,null,null,null,null,null,"CN Phase"]
["application fiscal year","region_code","FY for Phase Start ","Phase","Multiplier","PE Inflation Multiplier:",null,null,"application fiscal year","region_code","FY for Phase Start ","Phase","Multiplier","RW Inflation Multiplier:",null,null,null,null,"application fiscal year","region_code","FY for Phase Start ","Phase","Multiplier","CN Inflation Multiplier:"]
[2024,"V1P1",2024,"PE",1,{"$f":"INDEX(E4:E136, MATCH(1,  (F7=C4:C136) * (F8=D4:D136), 0))","v":{"$error":"#N/A"}},null,null,2024,"V1R5",2024,"RW",1,{"$f":"INDEX(M4:M128, MATCH(1,  (N7=K4:K128) * (N8=L4:L128), 0))","v":{"$error":"#N/A"}},null,null,null,null,2024,"V1C5",2024,"CN",1,{"$f":"INDEX(W4:W136, MATCH(1,  (X7=U4:U136) * (X8=V4:V136), 0))","v":{"$error":"#N/A"}}]
[2024,"V1P1",2025,"PE",1.05,null,null,null,2024,"V1R5",2025,"RW",1.05,null,null,null,null,null,2024,"V1C5",2025,"CN",1.05]
[2024,"V1P1",2026,"PE",1.1025,"Fiscal Year",null,null,2024,"V1R5",2026,"RW",1.1025,"Fiscal Year",null,null,null,null,2024,"V1C5",2026,"CN",1.1025,"Fiscal Year"]
[2024,"V1P1",2027,"PE",1.1576,{"$f":"YEAR('Cost Estimate Summary'!D28)+IF(MONTH('Cost Estimate Summary'!D28)>=7,1,0)","v":1900},null,null,2024,"V1R5",2027,"RW",1.1576,{"$f":"YEAR('Cost Estimate Summary'!D42)+IF(MONTH('Cost Estimate Summary'!D42)>=7,1,0)","v":1900},null,null,null,null,2024,"V1C5",2027,"CN",1.1576,{"$f":"YEAR('Cost Estimate Summary'!D77)+IF(MONTH('Cost Estimate Summary'!D77)>=7,1,0)","v":1900}]
[2024,"V1P1",2028,"PE",1.2155,{"$f":"IF('Cost Estimate Summary'!D28>1,\"PE\",\"\")","v":""},null,null,2024,"V1R5",2028,"RW",1.2155,{"$f":"IF('Cost Estimate Summary'!D42>1,\"RW\",\"\")","v":""},null,null,null,null,2024,"V1C5",2028,"CN",1.2155,{"$f":"IF('Cost Estimate Summary'!D77>1,\"CN\",\"\")","v":""}]
[2024,"V1P1",2029,"PE",1.2763,null,null,null,2024,"V1R5",2029,"RW",1.2763,null,null,null,null,null,2024,"V1C5",2029,"CN",1.2763]
[2024,"V1P1",2030,"PE",1.3401000000000001,null,null,null,2024,"V1R5",2030,"RW",1.3401000000000001,null,null,null,null,null,2024,"V1C5",2030,"CN",1.3401000000000001]
[2024,"V1P1",2031,"PE",1.3803000000000001,null,null,null,2024,"V1R5",2031,"RW",1.3803000000000001,null,null,null,null,null,2024,"V1C5",2031,"CN",1.3803000000000001]
[2024,"V1P1",2032,"PE",1.4217,null,null,null,2024,"V1R5",2032,"RW",1.4217,null,null,null,null,null,2024,"V1C5",2032,"CN",1.4217]
[2024,"V1P1",2033,"PE",1.4643999999999999,null,null,null,2024,"V1R5",2033,"RW",1.4643999999999999,null,null,null,null,null,2024,"V1C5",2033,"CN",1.4643999999999999]
[2024,"V1P1",2034,"PE",1.5083,null,null,null,2024,"V1R5",2034,"RW",1.5083,null,null,null,null,null,2024,"V1C5",2034,"CN",1.5083]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2021 Values","2022 Values","2023 Values"]
[null,2023,1.03,0]
[null,2024,1.0609,8.0000000000000071E-2]
[null,2025,1.092727,0.13400000000000012]
[null,2026,1.1254999999999999,0.19070000000000009]
[null,2027,1.1592740743000001,0.25023500000000021]
[null,2028,1.1940522965290001,0.3127467500000003]
[null,2029,1.2298738654248702,0.37838408750000041]
[null,2030,1.2667700813876164,0.41973561012500049]
[null,2031,1.3047731838292449,0.46232767842875044]
[null,2032,1.3439163793441222,0.50619750878161307]
[null,2033,1.3842338707244459,0.5513834340450614]
[]
[null,2023,1.03]
[null,2024,1.0609]
[null,2025,{"$f":"ROUND(1.092727,4)","v":1.0927}]
[null,2026,{"$f":"ROUND(1.12550881,4)","v":1.1254999999999999}]
[null,2027,{"$f":"ROUND(1.1592740743,4)","v":1.1593}]
[null,2028,{"$f":"ROUND(1.194052296529,4)","v":1.1940999999999999}]
[null,2029,{"$f":"ROUND(1.22987386542487,4)","v":1.2299}]
[null,2030,{"$f":"ROUND(1.26677008138762,4)","v":1.2667999999999999}]
[null,2031,{"$f":"ROUND(1.30477318382924,4)","v":1.3048}]
[null,2032,{"$f":"ROUND(1.34391637934412,4)","v":1.3439000000000001}]
[null,2033,{"$f":"ROUND(1.38423387072445,4)","v":1.3842000000000001}]
[]
[null,2023,{"$f":"ROUND(1.03718181818182,4)","v":1.0371999999999999}]
[null,2024,{"$f":"ROUND(1.07574612396694,4)","v":1.0757000000000001}]
[null,2025,{"$f":"ROUND(1.11574432075808,4)","v":1.1156999999999999}]
[null,2026,{"$f":"ROUND(1.1572297232299,4)","v":1.1572}]
[null,2027,{"$f":"ROUND(1.20025762839363,4)","v":1.2002999999999999}]
[null,2028,{"$f":"ROUND(1.2448853893039,4)","v":1.2448999999999999}]
[null,2029,{"$f":"ROUND(1.2911724915062,4)","v":1.2911999999999999}]
[null,2030,{"$f":"ROUND(1.33918063232675,4)","v":1.3391999999999999}]
[null,2031,{"$f":"ROUND(1.38897380311054,4)","v":1.389}]
[null,2032,{"$f":"ROUND(1.4406183745171,4)","v":1.4406000000000001}]
[null,2033,{"$f":"ROUND(1.49418318498778,4)","v":1.4942}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Sliding Scales","index":6,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[[24,4,24,9],[13,3,13,8],[7,3,7,8],[1,3,1,8]]}
[]
[null,null,null,"MEDIAN CONTINGENCY RANGE (Non-Complex Projects)"]
[null,null,null,null,"Pre-Scoping","Scoping /PFI Meeting ±20%","Preliminary Design / Public Hearing Team Meeting ±40%","Detailed Design / Field Inspection Meeting ±75%","Final Design / PAC 100%"]
[null,null,null,"High",55,45,30,22,15]
[null,null,null,"MLE",35,30,20,15,8]
[null,null,null,"Low",23,20,15,10,5]
[]
[null,null,null,"Moderately Complex"]
[null,null,null,null,"Pre-Scoping","Scoping /PFI Meeting ±20%","Preliminary Design / Public Hearing Team Meeting ±40%","Detailed Design / Field Inspection Meeting ±75%","Final Design / PAC 100%"]
[null,null,null,"High",75,60,40,30,18]
[null,null,null,"MLE",50,40,30,20,10]
[null,null,null,"Low",30,25,20,12,7]
[]
[null,null,null,"Most Complex (Major)"]
[null,null,null,null,"Pre-Scoping","Scoping /PFI Meeting ±20%","Preliminary Design / Public Hearing Team Meeting ±40%","Detailed Design / Field Inspection Meeting ±75%","Final Design / PAC 100%"]
[null,null,null,"High",100,75,40,30,18]
[null,null,null,"MLE",60,50,30,20,10]
[null,null,null,"Low",40,33,20,12,7]
[]
[]
[]
[]
[]
[null,null,"VDOT Generated Charts from AASHTO Data"]
[null,"Select Project Classification",null,null,"AASHTO ORIGINAL CHARTS BELOW"]
[null,"Non-Complex (Minor)",null,null,null,null,null,null,null,null,"Moderately Complex",{"$f":"INDEX(pictures,MATCH('Cost Estimate Summary'!C7:D7,Projects,0))","v":{"$error":"#VALUE!"}}]
[null,"Moderately Complex"]
[null,"Most Complex (Major)"]