Home

User Manual - Virginia Department of Transportation

1. Contract Requirements State Police Railroad TRNS PORT Estimates Date Constr Total 0 Constr Contingency 0 Bridge Total 0 Bridge Contingency 0 CEI Road HD CEI Bridge HD Total 0 Figure 30 TRAN PORT Estimates date TRNS PORT prime project identification 1s reported to the datawarehouse for this UPC Date changes each and every time any values change Construction Total total L amp D construction contract estimate for all TRANS PORT PCNs in prime excluding bridges Includes total value of all line items Construction Contingency usually 10 of the Const Total Total L amp D contract estimate for only TRAN PORT bridge PCNs in prime Usually 10 of the Bridge Total An estimate of VDOT s internal construction engineering costs during construction for all TRAN PORT PCNs in prime with the exclusion of bridges An estimate of VDOT s internal construction engineering costs during construction for all TRAN PORT bridge PCNs in prime Whatever amount is entered into TRNS PORT as item 25885 Not in production yet Amount in TRNS PORT for this item Not in production yet Amount in TRNS PORT for this item Not in production yet 26 PCES Version 3 1 User Manual Date 4 9 14 State Forces Amount in TRNS PORT for this item Not in production yet ron All Construction costs Bridge and other Contingency Bridge and other and CEI Bridge and Other TRANS PORT estimates reflect changes inpu
2. iS Select Surface Treatment Option RRR Guidelines Enter Yes or No Select Surface Only For Mew Hard Surface Treat Only MN Surface and Rural Rustic Roads Programs Number of and other Surface Treatment Projects not Project Length Surface Only requiring roadbed reconstruction Additional Lanes IGE RW UTIL COMMA Select Surface Plus For Surface Treatment Projects requiring the Full reconstruction of the Roadbed Surface Plus M4 gt MS DRAFT 4 SUMMARY CONST h CONST 1 CON Project Length mi The project manager designer is to enter the length of the project in miles This length 1s typically associated with the project length found on the title sheet ES Microsoft Excel gt File Edit View Insert Format Tools Data Window Help DAA GAZA A a Ao a oe o RE ci proj length fe 1 E PCES Draft Enter Project Length Enter the Length of the Number of Length Project Mainline in Miles ie Project Length mi ad dde ys ean in PEMS io AA AAA J of Project to End of Project CEES DRAFT SUMMARY CONST 5 CONST 1 CONST 2 f CONST MISC BRIDGE RW UTIL COMMENTS drial Marrow 31 4 Aj fed Fe Reply with Changes End Review Total Length Adding or Building Two Lanes mi This field is for the project manager designer to enter the length in miles of two lane roadway to be constructed For example if a project has a section in the middl
3. Numbers identifying jobs that relate to each of the phases of a project VIA PTE securise Y or N indicator that the project is funded by an action of the general assembly using funds earmarked for priority projects 15 PCES User Manual Version 3 1 Date 4 9 14 NTA OP amo Y or N indicator that the project is funded by an action of the general assembly using general funds Comments 000008 Comments related to the project entered via Project Pool by an authorized person Primary Consultant Name of the primary consultant from Project Pool Misc Tab Misc section Change Project Manager Users with Administrator rights can assign the Project Manager from the Project Information screen To change the Project Manager do the following 1 Press the 2 Find the person from the list of VDOT employees by navigating through the list or by entering a name in the Name search field at the top of the page and click Search VDOT Employee Search zz stauntontest Russell Martin 11Camp Thirty Tony Layne Kimberly William Chuck Baber Aziz Khanzadeh Cheryl Byrd Angelica Logan A MeGarrity A Agron Angela Brown A Cargill Andy Hetzer A Hill Email Address 1 WDOT Virginia gov Russell Marting ivdot virginia gov 11campthiryEnwDOT Virginia gov Tony Layne VDOT Virginia gov Kimberly Williama VinginiaDOT ong Chuck Baber VirginiaDOT org Aziz Khanzadeh VDOT Virginia gov Cheryl Byrd Wirginia DOT ong
4. Infor RW F Final 7 25 2011 Stanley Murphy 2 81 Award 7 25 2011 Stanley Murphy AWARD c a Expenditures 4 8 2011 CRD ite Projec timate a VDOT Project Cost Estimating System Windows Internet Explorer Expenditure Estimate Expenditures 0 lar HIE Expenditures 0000 0101041440404 o Project Closeout Expenditures For more information pertaining to the Project Closeout process here is the link to the Project Closeout Manual https insidevdot cov virginia gov div km COP PC Financial 20Management 200f 20Project s 20Documents PCPv7 pdf User Feedback Users may submit feedback by clicking on the Feedback in the Header A window similar to the following will be displayed a2 PCES Version 3 1 User Manual Date 4 9 14 IPMIPCES Feedback Please fill out your name email address feedback type and message below The feedback page should be used for relaying general questions providing enhancement suggestions or reporting non critical issues If there is a critical system problem please immediately contact the Help Desk at Helpbeskiaivdotvirginia goy or via phone at 604 766 3000 email John Doe VDOT Virginia gov Feedback Type C Business 2 Technical Message Send Feedback Figure 38 Feedback screen Complete the form and click Se or as necessary Technical feedback goes directly to IT Applications with a copy to the Scheduling amp Contract Division Business
5. BRIDGE RW UTIL COMMENTS Number of Left Turn Lanes Undivided Only Project manager designer is to enter the total number of left turn lanes for undivided roadways only The cost of this feature takes into consideration the transitions based on design speed criteria the necessary taper and storage of the left turn lane and average costs associated with connection reconstruction ES Microsoft Excel i File Edit View Insert Format Tools Data Window Help MBESA M RE ILNA oe mcr ere e a a a a Aj By 0 Ve Reply with Changes End Review ci_If turn_lan X Y fe 1 EY PCES_Draft i Arial Narrow Enter Number of Left Turn Lanes Enter the Number of Left Turn Lanes to aa be provided on the Project Note This is Number of Left Turn Lanes Undivided Only a for Undivided Highways ONLY Enter 1 not 2 For Crossroads as each LTL mn 3 includes both Lane Shift Tapers and LTL Number of New Traffic Signals Required i Construction Costs Tapers amp Storage in both directions Number of Traffic Signals Requiring Adjustment gt Base 1 PCES 4 pI DRAFT Z SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL f COMMENTS Cost of Large Drainage Structures This field is to capture the lump sum cost of large drainage structures The per mile cost of roadway has captured the average drainage cost This lump sum cost should include drainage structure
6. r J i 3 SS 04 Ay a We Reply with Changes End Review Y Xy 2000 5 PCES Draft Enter Length of Gurb amp Gutter IF prompted For input fbexk at lefty Median Type Graded Raised or None G dormal Lane Width ft enter the Total Length of Curb amp Gutter fin feet for the Project Left Number of Crossovers Divided Highways ONLY 14 SES SUE Meine Stel Length Curb amp Gutter Left PLUS Right Side ft E E E A E e A e Y Moa ob AA DRAFT 4 SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS Length of Sidewalk Left Plus Right Side ft This field should include the total length of sidewalk on both sides of the roadway Cost for sidewalk includes the average cost of concrete for sidewalk and additional excavation for sidewalk benching This length is to be shown in feet ES Microsoft Excel File Edit view Insert Format Tools Data Window Help Ts BOWEN Pewee Wied EAN CE EN ial Bit ee Mr MEN ci sidewalk ft Fe E PCES_ Draft Number of Crossovers Divided Highways ONLY Length Curb amp Gutter Left PLUS Right Side ft Length Sidewalk Left PLUS Right Side ft 1 CEES A DRAFT SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS SOME M2 Da F Reply with Changes End Review Enter Length of Sidewalk IF prompted For input bext at left enter th
7. uf total item A ELECTRICAL Transmission Computed Aw or or User Const Computed FW Computed FW Computed FIU Mo Entry Humber Rural Percent Total to RW to Const Required of Poles or Urban DOT Project Project A A A T g Column 9 to RW project This is the cost associated with the Right of Way phase based on the percentage entered in column 7 This column will only show a cost if RW is the selected choice in column 2 A sub total is computed for each type of utility 1 e electrical transmission A total cost all of sub totals will automatically be computed for each utility section such as electrical CATV telephone etc Ed Microsoft Excel Test PCES Project 157 File Edit wiew Insert Format Tools Data Window Help la x ufitem_cost m A ELECTRICAL Transmission Computed Aw or Ko Entry Required of Poles or Urban DOT Cost Project Project Humber Rural Percent Total to Aw to Const or User Const Computed RW Computed FW Computed Ri Computed F MAA SUMMARY UTIL Ready CE TT O E E T 45 PCES Version 3 1 User Manual Date 4 9 14 Column 10 to Const Project This is the cost associated with the Construction phase based on the percentage entered in column 7 This column will only show a cost if Const is the selected choice in column 2 A sub total is computed for each type of utility i e electrical transmission A total cost of all sub
8. 0064 002 FO7 Figure 20 Project Estimates Summary WO acia The identification numbers the FMSII system assigns to projects This number is used across the enterprise to identify projects It is unique to the project and will never be assigned to any other project Description A textual narrative briefly describing the project for quick identification and reference purposes State Project The state project number is 10 alphanumeric characters long with a format of 19 PCES Version 3 1 User Manual Date 4 9 14 XXXX XXX XXX Route County City Section Estimates Estimates section 1s divided into four areas Menu bar PCES Estimates List TRANS PORT Estimates RUMS Estimates Menu Bar mi Estimate History Download Blank Estimate Upload Estimate gy Select Estimate Split Estimate Figure 21 Project Estimates Estimates Menu Bar ill Estimate History Clicking the Estimate History button will open up a window listing worksheets All estimate workbooks MS Excel format entered by Project Management are placed in the project s Estimate History files These estimates cannot be changed They are for read only By clicking on to download a listed worksheet or click to close the window Estimate History 000000000052338 Class Data Source PE Ri CH otal Upload Date wersion Author Scoping CES 264 000 3 500 000 3 764 000 51272005 11 38 40 AM 2 1 on S Giometti
9. Angelica Logang VirginiaDOT ong A Peter McGarnity VDOT Virginia gov A AaronT VvDOT Virginia gov A Brown DOT Virginia gov A Cangill VirginiaDOT ong A Heten VirginiaDOT ong AAV DOT Virginia gov First Previous 1 of 1014 Next Last Logon 1 Russell Martin 11 campthirty tony layne kimberly william chuck baber aziz khanzadeh cheryl byrd angelica logan A Peter MecGarrity A Aaron A Brown A Cargill A Hetzer A Hill Cancel Figure 17 Change Project Manager 3 Click on the row to select and assign the Project Manager 16 PCES Version 3 1 User Manual Date 4 9 14 Location Location as the name implies provides project location related information Location District Lynchburg Residency Appomattox County Campbell County Priority MA Road System Primary Route 0029 Road Name 0 139 MILE SOUTH EXISTINS ROUTE 460 ECL LYNCHBURG 0 354 MILE NORTH EXISTING ROUTE 460 MCL LYNCHBURG Length mi 0 49 Start Location End Location Figure 18 Project Information Location District sessetsccanceseenncs The primary construction district responsible for a project Residency The VDOT Residency in whose jurisdiction the project takes place COUNTY cossirs The County which represents the jurisdiction in which the project takes place County Priority From Project Pool Road System Drop down division of funding groups e g primary urban seconda
10. Click selection to the left of the estimate you desire and click Select or click close the window with no changes To keep an estimate in the black without revising it click w Select the Estimate do not change the selected estimate and click Seen The estimate date will not change But the date on the search screen will change to indicate the date the estimate was last selected 23 PCES Version 3 1 User Manual Date 4 9 14 Split Estimate Estimate Information UPC 15950 District Richmond Author John Doe Date 10 20 2006 5 22 49 Phi Esti mate Type Final Submission wersion 2 40 Esti mates TELU CH e o 0 0 0 0 0 0 0 0 0 0 0 Project Total 15988 1 556 993 F665 300 35 178 525 F6 020 816 Jobs Total 0 0 0 Balance 1 556 993 685 300 3 778 523 6 020 816 Figure 27 Split an Estimate 1 Select the Estimate Type Pre Scoping PH Scoping Final Submission PFI 2 Enter the appropriate information and click Aee 24 PCES Version 3 1 User Manual Date 4 9 14 PCES Estimates List A check mark to the left of an estimate indicates it has been selected as the Recommended Estimate Type Date Author version PE A CH Total Pre Scoping Scoping P FFI PH FI P n fa Final Submission P Financial Plan 71312006 Avery McClellan 1 770 430 0 44 021 766 46 792 196 e Yo Award 11 29 2005 Chris Blevins AWARD 1 770 430 0 43 267 750 45 038 130 e Ex
11. End Review Select Project Terrain Level Typical Coastal Tidewater Region Topography w Gently Rolling Nearly Ideal Conditions Lowest Cost Rolling Typical Piedmont valley Foothills Topography Approx DH Light Mountainous Typical Highlands Minimum Topography Mountainous True Mountainside di Design Spe i Topography Design Year Project Terrain Light Mountains Mountainous 4 Moa e bX DRAFT SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE Rv UTIL COMMENTS Design Year ADT or Current Recent ADT If no design year ADT is available the project manager designer can manually enter current ADT for the project Data entered into either of these fields will determine the defaults for design speed and lane width PCES Version 3 1 User Manual Date 4 9 14 ES Microsoft Excel File Edit View Insert Format Tools Data window Help DAA Als 23341340 4 0 0 4 4d e Reply with Changes End Reviews fe 4000 on i Arial Narrow ci_design_adt E PCES Draft Geometric Standard Urban Minor Arterial Enter the Design Year ADT Enter the Design Year Average Ad Date 2007 Design Year Daily Traffic Count IF this is mot available leave this cell blank and Design Year ADT 4 000 Project Terrain enter a Current Recent Traffic Fox Must Be Empty Approx DHY Count below Minimum Moa gt AA DRAFT Y SUMMARY CONST CONST
12. Industrial Buildings Costs 1 000 4 4 ep SUMMARY CONST 4 BRIDGE ARW UTIL 4 COMMENTS Ready E 3 Other Improvements Other improvements are any tangible items in the taking that are compensable such as landscaping trees retaining walls subdivision signs other signs outbuildings walkways parking areas wells water systems etc When Computed Costs is used in the Residential Building Value section a figure will appear in the computed costs area for Other Improvements and this may be used or a user defined figure may be substituted If user defined cost is used in Residential Building Value then user defined must be used under Other Improvements Commercial Industrial Building Value requires user defined thus user defined must be used on Other Improvements E4 Microsoft Excel Test PCES Project Read Only Eo F E Ioj x File Edit View Insert Format Tools Data Window Help AIS HS Computed T Total Omer ran E Sit Estimator s Total Other Improvements Costs qQEN Hid LS SUMMARY CONST 4 BRIDGE RW UTIL 4 COMMENTS Ready CTTO TTO a T T 35 PCES Version 3 1 User Manual Date 4 9 14 4 Damages It allows the user to enter a lump sum cost for damages In order to get the correct sum of sections 1 4 all fields in these sections be completed 1687 File Edit wiew Insert Format Tools Data Window Help al x E fi Peo
13. Select Cost Definition Select Computed or User Defined Costs Computed Costs Choose Computed Costs to base Estimate on Worksheet s Tables and Formulas Choose User Defined Costs to base Estimate on Estimator s Input Na Cost p st t Mote IF User Defined Costs is specified A e Computed Costs will be used unless ULA COMME overridden by Estimator s Input PCES Version 3 1 User Manual Date 4 9 14 PCES and User Defined Cost allows the user to enter unit cost 1 Land Value The values for the items in blue need to be entered by the user Proposed Right of Way Temporary Easements and Permanent amp Utility Easements This information will be used to determine the Land Value cost of the project It is important for the user to complete the percentages on the right to total 100 otherwise system will not compute a Land Value cost The drop down menus for the existing and proposed right of way widths can be overridden When using User Defined costs the right of way user needs to enter a per square foot cost for the Proposed Right of Way Temporary Easements and Permanent amp Utility Easements blocks If no value is entered no Land Value cost will be generated Note Areas circled in RED below need to be completed by Project Manager designer E4 Microsoft Excel Test PCES Project Read Only o 627 File Edit View Insert Format Tools Data Window Help
14. download and upload estimates initiate PD 1 process select recommended estimate update award estimate download and upload documents images and videos document division comments delete documents images and videos edit project information manage schedule build team internal and external members assign action items setting 5 CEP milestone meetings PCES User Manual assign estimators and guests Super User Includes project manager individual amp district rights Includes administrator rights Includes estimator rights Includes managing access level rights Version 3 1 Date 4 9 14 PCES Version 3 1 User Manual Date 4 9 14 PCES View Header The top of the Project List page is the header Virginia Departmani of Transportador VA II We Keep Virginia Mov Figure 1 Project List Header Feedback User s Guide About e Clicking the VDOT logo will take the user to the official external VDOT web site e Clicking on the Project Cost Estimating System link of the header will take the user to the main page of the application the project list e Clicking on Feedback link will take the user to the User Feedback screen see page 32 e Clicking on the User s Guide link will route user to the most current version of this manual e Clicking on the About link will list version information about this application Initial Screen The initial screen lists available projects and allows the user to li
15. iej x AIS HS Prop Right of Way i Comp Temp Ease Cost isai 048 lt Enter Right of Way Estimators Temp Ease Cost per sqft t 0 sqft 01000 Ac Comp Liity Fase Cost saff 0 00 Rill Eats Utility Ease Cost p AA ll sy tt to Canesten a Temp Ease Perm amp Util Ease COST OF LAND item 1 EXI CINC RW UTIL A COMMENTS Ready CCO T O a DE T g 34 PCES Version 3 1 User Manual Date 4 9 14 2 Building Value When using User Defined cost in this category the right of way user will need to enter two values if applicable In the Estimator s Total Residential Dwelling Costs field the user 1s to enter the lump sum total residential relocations Costs for the entire project In the Estimator s Total Commercial Industrial Building Costs field the user is to enter the lump sum total commercial industrial relocation cost for the entire pe ject Ed Microsoft Excel Test PCES Project Read Only a E g O x 1647 File Edit View Insert Format Tools Data Window Help AIS HS Residential Dwellings Computed Total Residential Dwelling Costs 750 000 Estimator s Total Residential Dwelling Costs E j TEE Y E ee A a a Cee eee bo oy a i L 7 A T3 A r L Eg L Enter the total estimated cost of ALL MERCIAL amp INDUSTRIAL BUILDINGS to be taken Note No a ea Availabe Use User Defined Costs Below Estimator s Total Commercial
16. 000 115 CONSTRUCTION END YEAR FY2018 UPC RATE OF AD YEAR FY2015 Jaon 1 80 ESTIMATE YEAR FY2014 en 2 96 Nate of nevis estmate N A Figure 39 Summary Worksheet Summary Tab There are four estimate fields on the summary sheet preliminary engineering construction right of way and utilities The project manager can select the appropriate estimate source to use for each field The preliminary engineering field has two data sources to select from MANUAL which will collect the data from the Manual worksheet in PCES and PCES which will use the data created in the CONSTRUCTION and BRIDGE worksheets for preliminary engineering PCES Version 3 1 User Manual Date 4 9 14 ES Microsoft Excel t File Edit View Insert Format Tools Data window Help RANIA On mew ATAR ie MN select pee SH PCES Draft 21 4 By ied e Reply with Changes Preliminary Engineering Estimate Construction Estima Right of Way Estimate PCES Utilities Estimate PCES Ja a e WS DRAFT 5 SUMMARY CONST 4 CONST 1 f CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS The construction field has three data sources in which to choose estimates Manual PCES and TRNS PORT Manual will collect the data from the Manual worksheet in PCES If PCES is selected it will use the data entered in the CONSTRUCTION and BRIDGE worksheets in PCES When TRNS PORT is the selected source PCES will compute the cons
17. 4 oI DRAFT SUMMARY CONST CONST 1 CONST OGE RW UTIL COMMENTS Otherwise leave this cell blank Median Type Graded Raised or None The project manager designer should always select the type of median being used for the project The project manager designer shall select the appropriate type of median from the pull down menu Also when raised median is selected the user should populate for the total length of median ES Microsoft Excel Bile Edit View Insert Format Tools Data Window Help OA TEE IEA ENE Be Ane mae PTE Eo o i Ee E MOS cl median ty pegi G Ey PCES Draft Select Median Option A E IF you are prompted to make a Total Length Building Ramps and Loops mi a selection text at left choose o for Graded Median shoulder or Curb amp Gutter Select or C amp G Enter Lane Width ft gt R For Raised Median N For Mo Median Median Type Graded Raised or None lommal Lane Width M oa o MA DRAFT SUMMARY CONST 5 CONST 1 CONS IGE A RW UTIL 4 COMMENTS be used Note F Flush Median should mot 14 PCES Version 3 1 User Manual Date 4 9 14 Number of Crossovers Divided Highways Only This box prompts the project manager designer for the number of cro
18. Const CE Cost gt O Adjustment for Unusual Construction Costs 4 CE 18 9 826 Estimate 2007 364 416 fia a e DRAFT SUMMARY CONST h CONST 1 COMST 2 4 CONST MISC 4 BRIDGE RW UTIL COMMENTS Adjustment for Unusual Construction Costs The lump sum for unusual construction costs shall include any unusual cost not associated with a typical roadway project These costs can include but are not limited to landscaping items bicycle facilities retaining walls wetland mitigation sites excessive excavation costs high number of entrances and in plan utilities cost if not already included Documentation of unusual construction costs should be addressed on the Comments worksheet or uploaded to the PCES website as supporting documentation This is captured under the Misc Const tab See appendix A page 44 for current 2014 unit cost to use for unusual construction cost 19 PCES Version 3 1 User Manual Date 4 9 14 PCES Draft UPC Project Cost Estimating System Miscellaneous Cost Estimates AYDOT WYDOT JA Ti NASA F ry A Pintle I A Fer i e l bal E a iets Le Li Ls Wm 7 a 1 my l ri E L E ha a A A FOR UNUSUAL GUN a I LL On LA to E on m a l Pe cri p ti on A Moa gt HA DRAFT SUMMARY CONST CONST 1 CONST 2 5 CONST MISC BRIDGE PR UTIL COMMENTS Additional or Unusual P E Cost The preliminary engineering cost comp
19. D ioj xj File Edit View Insert Format Tools Data Window Help laj x Moderate Computed Admimstative Costs Incidental Expenses 11 500 8 Demolition Contracts It allows the user to enter a lump sum cost for Demolition Contracts The user must know 1f the demolition costs are to be handled by the Right of Way Section by contract or 1f the demolition costs are to be included in the construction estimate If these costs are to be included in the construction contract this cost should be provided to the project manager to incorporate into the construction portion of the estimate Ed Microsoft Excel Test PCES Project Read Only O ioj xj File Edit View Insert Format Tools Data Window Help a xj AL o Anticipated Relative Cost Impact of Demol ct Computed Costs of Demolition Contracts 40 050 i Estimator s Total Cost of Demolition Contracts a 4 4 eb SUMMARY CONST 4 BRIDGE ARW UTIL 4 COMMENTS Ready A um TT g 9 Hazardous Materials Removal It allows the user to enter a lump sum cost for Hazardous Materials Removal Ed Microsoft Excel Test PCES Project Read Only O joj x 1687 File Edit View Insert Format Tools Data Window Help xj F6 BER Computed Cost of Hazardous Materiais Removal sid Estimators Total Costs of Hazardous Materials Removal Pa M4 PL SUMMARY A CONST 4 BRIDGE ARW UTIL A COMMENTS Ready A TT Se T T g 10 Property Management
20. E If additional lines are needed for the comment continue to enter the comment in the same comment field The field will expand Since the field will only show the first two lines in the comment field the viewer can see all the comments in that field by either double clicking the field with left mouse button or view the comment in the data entry field at the top of the worksheet EA Microsoft Excel Test PCES Project Read Only File Edit View Insert Format Tools Data Window Help lej x Construction was revised to show additional cost to i construct additional lanes and detour Right of way and utility estimates were revised to Incorporate cost for additional construction Construction was revised to show additional cost to construct additional lanes and detour Right of way and utility estimates 4 were revised to incorporate cost for additional construction ha poi summary const Z BRIDGE AW UTIL COMMENTS E lel The original comment sheet provides the user and viewer with 15 comment name amp section and date fields If additional fields are needed please forward a copy of the PCES workbook to the PCES section They will coordinate with the Information Technology Applications Division ITAD and return the workbook Do not try to add more sheets 48 PCES Version 3 1 User Manual Date 4 9 14 Manual Worksheet One of the new enhancements for version 2 1 1s the ability to input a manual project estim
21. Estimate in Mid F 2007 a 2 675 459 a Primary Highway 2 675 459 Geometrie Standard O A Construction Bas oa Bridge Remove o cE A Construction Estimate 2007 _ nation Rate Ps ay Preliminary Engineering Cost A 443 000 O 443 000 CONSTRUCTION PE TOTALS 0 Total Construction Estimate PCES Roadway plus Bridge Total Preliminary Engineering Estimate Roadway plus Bridge Virginia Department of Transportation 2005 Today s Date 02 16 07 Version 2 4 Mo 4b WS DRAFT 4 SUMMARY CONST CONST 1 4 CONST 2 CONST MISC BRIDGE 4 RW UTIL COMMENTS Constr 1 Constr 2 and Misc Constr Worksheet The purpose of the construction worksheet is to collect data about the project to determine the road construction estimate Some data fields are automatically populated based on data PCES has collected from other systems such as iPM iS YP or Project Pool while other fields need data entered by the project manager designer A brief explanation of each field is provided below Project UPC Automatically populated from other sources PCES Version 3 1 User Manual Date 4 9 14 Interstate Project Project Manager must select yes or no This cell may be yes even if the roadway will not carry an Interstate designation If physical features of construction mimic Interstate design standards 1 e limited access grade separated interchanges etc the interstate stand
22. Figure 22 Estimate History list 4 i Download Blank Estimate Clicking Download Blank Estimate will download a blank worksheet pre populated with some project information Download Draft Estimate Workbook Figure 23 Download Blank Estimate The alternate RW Utility work sheets can be downloaded by checking use alternate R W Utility worksheet when you download a workbook 20 PCES Version 3 1 User Manual Date 4 9 14 Select PCNs to use for TRNS PORT estimate Default is all PCNs and current coding requires a prime project be build in TRNS PORT before any estimate can be imported P Upload Estimate A Before a new project estimate is uploaded for recommendation the Project Manager needs to consider whether or not the funding for the project 1s adequate If the project phase is within the 36 month advertisement window and the total estimate is greater than 50 000 or 10 the user uploading the estimate will be immediately routed to the Project Pool application to apply for a change in funding by completing a PD 1 form Warning Clicking the Upload Estimate button will open form to select an Estimate Worksheet to upload Upload Estimate Worksheet Please navigate to a valid file Excel only by clicking on the Browse button Upload Version 2 4 Worksheet Esti mate Type Select Type Ww Figure 24 Upload Estimate Worksheet 1 Click Browse navigate to the location of the appropriate worksheet and
23. It allows the user to enter a lump sum cost for Property Management 37 PCES Version 3 1 User Manual Date 4 9 14 wD In order to get the correct sum of sections 5 10 all fields in these sections be Note completed Ed Microsoft Excel Test PCES Project Read Only O ioj x 1687 File Edit View Insert Format Tools Data Window Help 8 xj Goa Ao lative Cost Impact of Property Management lt Moderate Computed Costs of Property Management 7 800 Hd 4 b bl SUMMARY CONST 4 BRIDGE ARW UTIL A COMMENTS Ready E VE E P JA 11 Relocation Assistance It allows the user to enter lump sum costs for Relocation Assistance in two locations The first location is for Total Residential Relocation Costs and the second 1s for Total Commercial Industrial Relocation Costs The boxes for Total Displacements Farms Families Non profit Businesses and Personal Property Only are for documentation proposes only E4 Microsoft Excel Test PCES Project Read Only ae ioj xj 1647 File Edit View Insert Format Tools Data Window Help a xj Note No Com mp uted Costs Availabe Use User Defined Costs Reflow Estimator s Total Comm Indust Relocation Costs 1 000 Total Displacements Farmms __ Families y Non Profit __ es Personal Property Only Fi OCATION ASE CONNECT RW OESTE Ready E E J EI Pr JE VE 12 Year of Right
24. Pendrive 271 Es mate Supportins Documents airis Sansiaiadin viet ven tdetna tout uenenabenetes 271 PD ia ccscios 299 O A amateur A E A seaeaeci nats 30 Project EOS is 31 Eundins and Author ZatlOW ear APORTA FI Atos rica ae 32 User Pecados 332 PEES AV OKS ICO Sunset il l A O l Project Budgeting Consideras ai l POPS COM I a N l UMAS WOE DOO ea N 2 Construction Works hectareas 6 Constr 1 Constr 2 and Misc Constr Worksheet oocooccoccoccocnccnocnncnnccncnncnnccncnnccnccnccnccnccanons 6 bao orc UPC T AA O OS 6 TGC T State a OlC E T E tant ee Met Sanne cagida 7 PCES Version 3 1 User Manual Date 4 9 14 VMamtenance ro Could cocaleros 7 Rone A A A E 7 Geometria 7 AMD oia 8 Project Era rada 8 Desten Year ADT or Current Recent ADT ida 8 Enter DeSeT 5 peed MEE pun eds case 9 Normal vano W dieen aa A lense Steals atee edo iahe tates 9 Potr Lane A O aoe 9 RRR Guidelines Enter Yes ONO 10 Select Surface Treatment puns arnir 11 Project Lensth a D AA A AI 11 Total Length Adding or Building Two Lanes M1 cccccoccoonnnnnnnnnnnnnnononnnnnnnnnnnnnnnannnnnnnnnnos 11 Total Length Adding or Building Four Lanes M1 cccoononoccnnnnnnnnnnnnnnncnnnnnnnonononanonannnnnnnos 12 Total Length Adding or Building Ramps and Loops Ml cccccccnncnoncnnnnnnnnnnnnnnnannnnnnnnnnos 12 Number of Additional Lanes amp Length of Additional Lanes M1 oooocccncncccnononnnnnnnnnnnnno 13 Shoulder or Curb Gutter Sele
25. Project Page TRNS PORT Estimate area modifications a Error message conveyed no TRNS PORT estimate when UPC number is Embedded in more than one prime project number in TRNS PORT b Prime project number is displayed c Date of last L amp D TRNS PORT estimate is displayed d Bridge Construction and Road Construction work estimates are separated and subtotaled e The categories for Contract Requirements State Police State Forces and Railroad totals which mirror those in TRNS PORT are now indicated PCES v 2 41 CHANGES TO THE WORKBOOK 1 Version name was changed from 2 4 to 2 41 2 SUMMARY Worksheet Ad Year choices are now limited to the current fiscal year and beyond SUMMARY Worksheet Estimate Year is now fixed to the current fiscal year 4 Inflation Rate 12 58 is the current compounded inflation rate for FY 2008 This incorporates the 2007 rate This was required to maintain the same dollar value of your estimate when the fiscal year changed It is anticipated that when new inflation rates are established by the Financial Division later this year the 12 58 and any adjustments made to it will be absorbed into PCES project workbook value tables and the inflation rate will be set to 0 for the current fiscal year 60 PCES Version 3 1 User Manual Date 4 9 14 Appendix E Summary of Changes from Version 2 41 to 2 5 PCES v 2 5 CHANGES TO THE WORKBOOK 1 All lane mile bridge square foot traffic signal and
26. Transportation MVA We Keep Virginia Moving Feedback User s Guide About lad Proje ct Search Project Project Information Estimates Y Expand All Collapse All Project Summary UPC 52338 Description RTE 64 UPGRADE SEWER SYSTEM PE ONLY WB REST AREA State Project 0064 002 F07 Estimates lal Estimate History 5 Download Blank Estimate Upload Estimate Select Estimate Split Estimate Type Date Author Version PE Rv CN Total Pre Scoping gt Y Scoping 5 27 2005 John Giometti 240 254 000 0 3 500 000 3 754 000 E PFI P PH P Fi P RW P Final Submission P Award Expenditures 34 7 2004 FMS 29 656 0 0 29 656 TANS PORT Estinstes RUMS Estimates Date Date 1147 2006 Constr Total 0 RW Acquisition 60 000 Constr Contingency 0 RW Relocation 0 Bridge Total 0 RW Utility 0 Bridge Contingency 0 Cons Utility 0 CEI Road 0 Total 60 000 CEI Bridge 0 Total 0 Pending Approval ul Approval History Type Date Author Status PE Rw CN Total No Records Estimate Supporting Documents Fundings and Authorizations Copyright 2006 Virginia Department of Transportation All Rights Reserved Figure 10 PCES Project Cost Estimating System v2 4 11 PCES Version 3 1 User Manual Date 4 9 14 Application Bar Virginia Deparimeni of Transporation VEDUT a E W Vve Keep Vir Sila Moving A eee Cod Dack User o COR MA Project Search UPC 11872 Figure 11 Applicatio
27. associated with the project This feature only works with geometric standards GS 3 GS 4 GS 7 and GS 8 EJ Microsoft Excel i File Edit View Insert Format Tools Data Window Help Type a AA MEE AU MESA A ASIAN i Arial Narrow ne Wt ae ee MEMES ci_is_rrr X fe PCES Draft A A 0 Pe Reply with Changes End Review Select RRR Option If you are prompted to make a selection text at left choose YES only if RRR Guidelines Enter Yes or No Surface Treat O 0 ro RRR Guidelines will be Project Length mi A Pei applied to this project M 4 gt A DRAFT Z SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMER 10 PCES Version 3 1 User Manual Date 4 9 14 Select Surface Treatment Options This block will prompt the project manager designer for type of roadway surface If Surface Only is selected this is considering no or minimal roadbed construction is needed and is the appropriate selection for projects that fall into the Rural Rustic Roads category Surface Plus is for projects requiring full depth pavement construction Selecting Surface Only or Surface Plus takes into account minimal grading for the project grading of shoulders and ditches ES Microsoft Excel File Edit wiew Insert Format Tools Data Window Help Type Ee ee ee ci_is surf treat Fe 5 PCES_Draft Arial Narrow 10 gt a End Review Y Reply with Changes
28. generated will change if CN estimate has changed B Manual no change RW Estimate A PCES generated will change only if costs from the Utilities worksheet are charged to RW instead of CN B RUMS extraction no change C Manual no change CN Estimate A PCES generated an approximate 4 2 decrease B TRNS PORT generated estimate no change C Manual no change 66 PCES User Manual Version 3 1 Date 4 9 14 Appendix K Summary of Changes from Version 2 62 to 2 7 PCES v 2 62 CHANGES TO THE WORKBOOK l 2 3 Version name changed from 2 62 to 2 7 The statewide cost of building a GS 5 standard roadway was reduced by 10 The following District Cost Factors changed A Bristol from 90 to 95 B Salem from 95 to 90 C Hampton Roads from 1 25 to 1 10 D Culpeper from 1 10 to 90 E Staunton from 95 to 90 The cost of water line generated on the utilities tab was reduced by 14 5 Inflation factors were updated 67 PCES Version 3 1 User Manual Date 4 9 14 Appendix L Summary of Changes from Version 2 7 to 2 91 PCES v2 7 2 91 1 Versions 2 7 2 91 dealt with inflation costs in July 1 and December 1 of the fiscal year 2 July updates reflected the addition of any cost to the PCES base if the December inflation called for inflation during the ad year 68 PCES User Manual Version 3 1 Date 4 9 14 Appendix M Summary of Changes from Version 2 91 to 2 94 PCES v
29. i gF E EI A js Approximate Mumber of Parcels Affected 1 Computed Cost of Damages to Remainder 73 000 lt Mab SUMMARY X CONST BRIDGE ARW UTIL COMMENTS Ready COCE 0 NA O 5 Administrative Settlements It allows the user to enter a lump sum cost for Administrative Settlements ES Microsoft Excel Test PCES Project Read Only eS joj xj 1647 File Edit View Insert Format Tools Data Window Help 5 x Fes 1 o Aticipated Relative act of Administrative poo Moderate Estimator s Total Cost of Administrative Settlements Mial HP SUMMARY a CONST BRIDGE RW UTIL A COMMENTS Ready a A e e iaa E E E Approximate Number of Parcels Affected 1 Computed Cost of Administrative Setilemepts 2 300 lt el 6 Condemnation Increases Allows the user to enter a lump sum cost for Condemnation Increases Ed Microsoft Excel Test PCES Project Read Only ae Dj x File Edit View Insert Format Tools Data Window Help a xj rs Y o o l Approximate Humber of Parcels Affected Computed Cost of Condemnation increases 27 000 Estimator s Total Cost of Condemnation Increases Mia le SUMMARY CONST BRIDGE A RW UTIL COMMENTS Ready CTTO T TO aM T T 36 PCES Version 3 1 User Manual Date 4 9 14 7 Administrative Costs amp Incidental Expenses It allows the user to enter a lump sum cost for Administrative Costs amp Incidental Increases ES Microsoft Excel Test PCES Project Read Only
30. item either Computed or User Percent Total 4 to RW of Pole Defined Costs DOT Cost Project O 100 0 0 Po Note Selection of User Defined Costs 100 0 0 requires the entry of a Loaded unit cost pg 0 0 TOY For this item at right 100 0 0 i H WA RA SUMMARY 4 CONST BRIDGE UTIL COMMENTS Ready AA A MT A Cg Column 2 Right of Way or Construction This drop down menu allows the user to select which phase of the project estimate this particular utility cost will be charged The user 1s to select RW 1f cost associated with this utility are to be added to the Right of Way phase and Const 1f the costs are to be added to the construction phase The default is set for RW ES Microsoft Excel Test PCES Project Read Only AS 1647 File Edit wiew Insert Format Tools Data Window Help 5 ui funding so y A ELEC TRICAL Cost to RW or Const Project El 3 Transmission Select the Source of Funding For the Computed RV or Type relocation of this particular item Percent Total 4 to RW or User Const of Pole DOT Cost Project Computed FM Tre Mote The sourceforthisitemis f 100 0 Computed A normally the Ry Project E 700 0 0 Computed MESAS E 100 0 0 D Computed Ril IA J ao ti 0 Ma e SUMMARY A CONST BRIDGE Ar UTIL E COMMENTS Ready Bum TT g 42 PCES Version 3 1 User Manual Date 4 9 14 Column 3 Description of Utility This column consi
31. of Way Authorization The user is to select the year in which right of way authorization 1s anticipated for the project through the drop down menu An inflation factor is applied to the right of way cost based on today s cost to generate a right of way cost to the year selected 38 PCES Version 3 1 User Manual Date 4 9 14 Ea Microsoft Excel Test PCES Project Read Only ae EE ioj xj E File Edit View Insert Format Tools Data Window Help r_year_of rw l E a Jr Ja E Manual Inflation Factor The user can enter an annual inflation factor to be used in computing the right of way cost If no inflation rate is entered no inflation will be applied to the estimate Ed Microsoft Excel Culpeper_O00000000018697 697 File Edit View Insert Format Tools Data Window Help xj ri year_of rw y 2007 Cl E AFI 1 CI El 207 E 10 00 ERR E aw UT COMETS WA T II O E YS E Ready Sub Total Right of Way Costs are automatically computed based on data Note entered This worksheet will pull the utilities cost from the Utilities worksheet only if the Utilities worksheet has been completed or RUMS selected on the Summary worksheet as the estimate source The Sub Total Right of Way Costs and Utility Costs are today s cost and are added together and multiplied by the inflation factor per year to the authorization year to create a total right of way cost E1 Microsoft Excel Culpeper _o0000000001848497
32. other related cost tables have been updated 2 The cost for left turn lanes has been changed The results will be that PCES will generate a lower cost for this feature 3 The Construction Engineering CE cost table for roadways has been updated 4 Inflation factors have been updated Inflation will not be added to the cost estimate if it goes to advertisement in the current fiscal year only for future fiscal years 5 On the right of way sheets the range of values has been increased for residential and agricultural zoned property 6 Also on the right of way sheet the range of allowable charges for damages and administrative settlements has been increased 7 On the utility sheet the system generated cost for overhead power lines and for sanitary sewer lines have been increased 8 On the bridge sheet the calculation for PE cost has been changed PE cost will increase from that generated by the previous version of PCES 61 PCES Version 3 1 User Manual Date 4 9 14 Appendix F Summary of Changes from Version 2 5 to 2 51 PCES v 2 51 CHANGES TO THE WORKBOOK 1 Version name changed from 2 5 to 2 51 2 Added Bike and Pedestrian facilities to the workbook on the Construction 1 Construction 2 and the Bridge sheets 62 PCES Version 3 1 User Manual Date 4 9 14 Appendix G Summary of Changes from Version 2 51 to 2 53 PCES v 2 53 CHANGES TO THE WORKBOOK 1 Version name changed from 2 51 to 2 53 2 The Constructio
33. page is filtered by SYIP and sorted by state project number The list can be sorted by clicking on any of the column headings which allows the user to sort the list by column in ascending or descending order Only one field may be sorted at a time Ey Download Draft Estimate Workbook Esti mate Version State Project Description Route LUPE District Project Migr Date Source Total Esti mate 0001 106 FO7 RTE 1 4 LLANES WITH CURB 0001 459 4 Richmond harrin Tart 11 006 Award So S64 S466 SUTTER amp SIDEWALK QOR 002 FO RTE G4 UPGRADE SEWER 0064 19656 Culpeper Jacob Porter FIFIRZD0O6 2 10 coping 3 790 000 STSTEM PE ONLY EB REST AREA QOG 002 FOe RTE G4 UPGRADE SEWER 0064 52338 Culpeper Jacob Porter SrV2O0G 2 10 Scoping 3 754 000 STYTSTEM PE ONLY WB REST AREA 60249 118 FOT RTE 9 LACABURmMabIs on 0024 Lynchburg John Canmile e al 4527 503 HEISHTS BYPASS ROUTE 460 Expenditures INTRICH ly 6029 118 FO7 RTE 9 LYNCHBURG MADISON OO29 18195 Lynchburg John Camile 1129 2006 AWARD 9 080 145 HEIGHTS BYPASS RTE 460 Award IN TCHS Figure 6 Project Search Screen selecting the project PCES Version 3 1 User Manual Date 4 9 14 The following details are displayed State Project The state project number is 10 alphanumeric characters long with a format of XXXX XXX XXX Route County City and Section Descripti0N A textual narrative briefly describing the project for quick identifica
34. section See file 56103 xls 3 000 000 see file 551 50road xls Fee Be Be ot 01 04 01 00 Ra Bo Ra hd Po 0 Sm oot o See file 56150 bridge xls A3 WALH SUMMARY 4 CONST 4 BRIDGE A RW UTIL A COMMENTS MANUAL jal Er Ready Pop Mmf f f zg The fields shown below are populated based on the information entered in the job number fields The Ad Year fields will add all related phases together PE RW and CN to create a total for each phase From that information a total project estimate will be created using the inflation factor 1f applicable Ei Microsoft Excel Culpeper_000000000056130 File Edit View Insert Format Tools Data Window Help al x E ee AM E E A ES Se SS EE O ES AA ESTIMATE YEAR AD YEAR Baa 15 Fy 4005 F Y22005 ce Pa 17 1 300 000 PE 1 300 000 14 500 000 Rv 500 000 pE 000 000 CH 6 000 000 e U0 000 TOTAL 7 800 000 24 aS es MAL Ub SUMMARY CONST BRIDGE RW UTIL COMMENTS MANUAL la qe Ready OE T a T T g Cu 50 PCES Version 3 1 User Manual Date 4 9 14 Appendix A PCES Generated Project Costs LANE MILE COSTS 3 28 07 Items Automatically Included Excluded Items costs must be in Lane Mile Cost or added on CONST MISC Description Calculated by PCES worksheet 00000 Mobilization and mobilization surveying clearing excessive excavation rock Infrastructure and grubbing regular excavation excavat
35. total bridge preliminary engineering estimate ae 577 462 637 340 a A A Cee A O AL DOICLICO CSliialtt Mc ne 551 327 31 PCES Version 3 1 User Manual Date 4 9 14 Right of Way Worksheet Right of Way project costs can be entered two ways in the PCES The first avenue is to use the Computed Costs in the system This method uses preset costs in the worksheet The other method is to use User Defined Costs This method allows the user to enter the unit costs based on known or historic unit costs When the preferred method is selected a lt will show up on the right of side of the individual fields requiring data These are also color coded The User Defined Costs symbol lt is blue and the Computed Costs symbol lt is green Directions are provided below for each method When Computed Costs is chosen the user still has many choices to make as most fields are divided into values with a wide range The user of the system must have a good working knowledge of the values they are choosing The user cannot rely on PCES to give them a reasonable estimate without choosing the appropriate value ranges Whichever method selected look for the lt symbol on the right side of the fields needing data to compute the estimate for that portion of the right of way estimate Many of the fields require data regardless 1f Computed Cost or User Defined Cost is the selected method for compu
36. totals will automatically be computed for each utility section such as electrical CATV telephone etc Et Microsoft Excel Test PCES Project 17 File Edit View Insert Format Tools Data Window Help la x uifunding so A ELECTRICAL a Transmission om Computed RW or Mo Entry Number Rural Percent Total to RW toConst 8 or User Const Required of Poles or Urban OOT Cost Project Project Computed FM MA SUMMARY UTIL Ready A A A A E Additional Costs The user can add additional utility cost in the appropriate utility cost fields These costs are to be cost that cannot be captured elsewhere on the utility worksheet Be sure to add the additional cost in the appropriate fields so they will be computed correctly Ed Microsoft Excel Culpeper_000000000018897 File Edit View Insert Format Tools Data Window Help x S267 I ADDITIONAL COSTS Additional Utility Costs to Right of Way Project Comments Additional Utility Costs to Construction Project Additional Utility Costs to Utility Owners Others Comments Ready The utility subtotals for right of way cost construction and utility owner cost are all based on today s cost no inflation applied as 1s the Grand Total Utility Costs The costs associated with each field will populate the appropriate fields in the other worksheets 1 e utility cost associated with right of way will populate the utilities field of the right of wa
37. 00 MANUAL 0 Total 29 656 3 754 000 3 754 000 3 754 000 0 Figure 36 PD 1 Detail Fundings and Authorizations Fund Source previous FY 2008 Fy 2009 FY2O10 Fv2014 FY2O012 Fv2013 TOTAL Interstate 1 309 000 0 0 0 0 0 0 51 309 000 PE iyi CH TOTAL Authorized 554 000 0 0 564 000 gt 5 26 0 00 0 00 5 26 Expended Figure 37 Fundings and Authorizations Project Award Once a project is awarded and entered into Site Manager it is the responsibility of the Project Manager or Area Construction Engineer to enter the Award date and Award amount in POOL This process will initiate the E or edit button in PCES The PM or ACE will choose manual next to CN and enter the actual Award amount Choose submit and this becomes the estimate of record The estimate can then be updated in the same manner while the project is under construction Work orders and any other estimate changes must be entered here until the project is closed out 30 PCES Version 3 1 User Manual Date 4 9 14 Poo o PM PCES af Scheouie Live SYP DASHBOARD ES ec PE Manual v RW RUMS v 0 Manual v 1470000 State Project Estimates lu Estimate Type ss 4 Fl 4 16 2013 Anthony Revelle 2 94 140 000 0 1 523 050 1 663 050 gt Q Final Submission 11 18 2013 Anthony Revelle 3 00 130 000 0 1 470 000 1 600 000 E Award 1 10 2014 Corey Bourne AWARD 130 000 0 1 470 000 1 600 000 e Expenditures 11 2 201
38. 1 CONST 2 f CONST MISC BRIDGE Rv LUTIL f COMMENTS Enter Design Speed MPH If the designated speed computed from the ADT s is not correct the project manager designer can select the appropriate design speed from the drop down menu ES Microsoft Excel File Edit View Insert Format Tools Data Window Help Type a que BO CF DS Bh PE arial narrow r 89 92 E y Ay gt 4 241 802 Ye Reply with Changes End Review ci_min_des s v fe 40 EY PCES_Draft Minimum Select a Design Speed Design Speed 2 40 MPH If you are prompted to enter Enter Design Speed MPH 30 40 45 50 or 60 a Design Speed text at left Box Must Be Box MustBe E make an appropriate selection From the drop down list Otherwise leave this cell blank Number of Length of Add Additional Lanes Lanes mi M 4 gt AA DRAFT Z SUMMARY CONST CONST 1 CONST 2 f CONST MISC BRIDGE RW UTIL COMMENTS Normal Lane Width This field 1s determined by the geometric standard and design speed selected Enter Lane Width This allows Project Managers to override the lane width associated with the Geometric Standard ADT and Design Speed Enter Lane Width ft a lormal Lane Width ft 44 PCES Version 3 1 User Manual Date 4 9 14 RRR Guidelines Enter Yes or No In this field project manager designer is to select Yes or No from the drop down menu When Yes is selected a different cost factor is
39. 1647 File Edit View Insert Format Tools Data Window Help required Fo e ii NA TA SUB TOTAL Sa E m m gilig pm g sh p o A LATA Jh Jh A j Ji i j f gpd amp rth IIL FE E rtf te ay 1 e 1 4 l E UY A Y LUSIis Utility Data display requires completion of Utilities Estimate Worksheet tab below rr SUMMARY CONST BRIDGE RW UTIL COMMENTS MANUAL So y Ready Comments Comment box is provided for documentation purposes 39 PCES Version 3 1 User Manual Date 4 9 14 Ed Microsoft Excel Test PCES Project Read Only Pe olx File Edit View Insert Format Tools Data Window Help Ej xj E CO a ola Lar ee e a e pI SUMMARY CONST 4 BRIDGE RW UTIL 4 COMMENTS Ready E E el JA RW 238 Data Right of way Estimate Date User to enter date that data was entered in to Right of Way worksheet Based on Approved Unapproved Plans From drop down menu the user shall select 1f the plans used for the estimate are approved or unapproved Participating Cost Non Participating Cost From the drop down menu the user shall select if the project has federal funding associated with Right of Way If project does have federal funds for Right of Way the user 1s to select Participating Cost if no federal funds is allocated to Right of Way the user is to select Non Participating Ed Microsoft Excel Test PCES Project Read Only loj x File Edit Vie
40. 2 93 November 1 2012 de 2 Version name changed from v2 91 to v2 93 Added a tab to the Constr 1 sheet that will allow a Project Manager to choose if a project is a Maintenance project such as regional guardrail overlay typically projects that are in the system for a short time before they are advertised it would not add inflation to a project if the estimate and the project ad were in the same year These projects usually have a set amount of money and inflation would not be calculated v 2 92 Revised the Bridge sheet to allow a space to write in the Federal Structure D Number Also added three additional areas to write in comments for Misc Cost CE and PE v 2 93 Revised 2 93 to 2 94 to reflect new inflation factors December 2012 69 Version 3 1 PCES Date 4 9 14 User Manual Appendix N Summary of Changes from Version 2 94 to 3 1 PCES v2 94 July 1 2013 and Dec 1 2013 1 Version name changed from v2 94 to v3 0 2 Added inflation to base cost factors July 1 2013 3 Revised 3 0 to 3 1 to reflect new inflation factors December 2013 70 PCES User Manual Version 3 1 Date 4 9 14 Index for Web Page Accomplishment ccccccccceeeneeeeeeees 18 PNG tii is 18 ASSISTANCE ceaiorie aora a 2 Author PCES Estimates List 0 0 e eens 25 Bridge Contingency TRANS PORT Estimates oocccncccnno 26 Bridge Total TRANS PORT Estimates occcncccnnc 26 CEI Brid
41. 3 CRD 2 373 0 661 3 034 E TRNS PORT Estimate jm a Project Award Project Closeout The final stage of a PCES estimate is project closeout Once a project has reached an end where there are no more charges anticipated the ACE or PM must select the estimate and choose Expenditures Since the project is completed and Expenditures is the recommended estimate please select expenditures using this process included in the Project Closeout section on page 31 of the PCES User Manual 1 Find the project in PCES click Select Estimate 2 To select Expenditures as the Recommended Estimate on the Expenditures line select the E button 3 Anew window should open and then from the dropdown select Expenditures for the phase s you are updating Include any documentation in the Comment block and click Submit 4 Then click Select Be sure the check mark is beside Expenditures Also don t forget to check the project in Cardinal to be sure it s closed to charges If it is still open contact CO Programming Openings and Closings 31 PCES Version 3 1 User Manual Date 4 9 14 2 Select Recommended Estimate Windows Internet Explorer vigi Select Recommended Estimate Type Date Author i PE RW CN Pre Scoping 828 2009 Stanley Murphy 32 000 Scoping 219 2010 Stanley Murphy A 2 000 Pool PFI W31 2010 Stanley Murphy 3 2 000 B project PH 21 2011 Stanley Murphy r 52 000 Pre
42. 7 3 GS 8 13 Interstate 23 e New Non Construction filter e All search filters are now visible binoculars removed e New traffic signals and adjusted signal values increased by 3 e District cost factors are adjusted to the following Bristol 85 Salem 95 Lynchburg 90 Richmond 1 05 Hampton Roads 1 20 Fredericksburg 1 00 Culpeper 1 00 Staunton 1 00 Northern Virginia 1 05 58 PCES Version 3 1 User Manual Date 4 9 14 e The cost of left turn lanes increased by 13 e The default terrain was corrected to Gently Rolling and the following terrain factors are adjusted to the values indicated below Gently Rolling 0 00 Rolling 0 10 Light Mountainous 0 15 e Bridge removal costs increased by 3 e The base value for the raised median is now 37 44 LF e The base value for curb and gutter is now 48 30 LF e The base value for a 4 sidewalk is now 23 94 LF e The base value per crossover is now 86 520 each e The base value per right turn lane is now 43 260 each e The base bridge cost is now 70 918 and 105 SF e The bridge formula has been corrected to include the following values relative to the base cost of the bridge lt 500 000 additional 25 750 and 5 500 000 2 000 000 additional 41 200 and 2 gt 2 000 000 additional 61 800 and 1 59 PCES Version 3 1 User Manual Date 4 9 14 Appendix D Summary of Changes from Version 2 4 to 2 41 PCES v 2 41 CHANGES TO THE WEBSITE 1
43. 87 File Edit View Insert Format Tools Data Window Help vi number_p Computed RW or Tape Mo Entry Humber Rural Percent z or User Const of Pole Required of Poles or Urban OOT Quantity A Computed Ry OTC I p 10 B Computed Pm Y TP tt Enter the C Computed RW f Ooo ee oo Quantity For this D Computed Ri m a De line of input M AlI H SUMMARY CONST BRIDGE UTIL COMMENTS i Ready SSSA um TT Column 6 Rural or Urban This column is only associated with the Transmission and Distribution Aerial portions of the Electrical section of the worksheet The user 1s to determine 1f the cost associated with these 43 PCES Version 3 1 User Manual Date 4 9 14 utilities should be based on urban or rural costs and select the appropriate choice from the pull down menu This menu defaults to Urban This menu will only allow the user to select an option if Computed is the choice for computing cost Et File Edit View Insert Format Tools Data Window Help ui_rural_or_ur al Computed RW or Tape Mo Entry Humber Rural Percent or User Const of Pole Required of Poles or Urban OOT Rural or Urban A Computed FW PP 100 B compte RW i sd SSS 100 Select Rural or C Computed Fl Urban 100 Urban From the drop gt i E D Computed Rin 00 cee i this J line of input Wd BS SUMMARY 4 CONST BRIDGE UTIL COMMENTS Ready A ae Colu
44. Commonwealth of Virginia Virginia Department of Transportation VDOT Construction Division PCES User Manual Version 3 1 April 9 2014 This material is the exclusive property of the Virginia Department of Transportation This material may not be used in any way for creation of derivative works including but not limited to documents computer programs prototypes and programming code is forbidden without the express permission of VDOT ITD PCES Version 3 1 User Manual Date 4 9 14 Table of Contents PCES OVOTVIC W erea l Sensitive and Confidential Informati0N oocccccccncnnnnnocncnnnnnnnnononnnnnnnnnnonononnnncnnnnnnnnnonnnnnnncnnnnnnns l PESA SSO a E E or O sa Mauanerteainss 2 U TrA ss and MS a teeta 2 Access Levels and Permissions cil 2 PECES WC Winds ias 5 Head Poena ee reer een Ne re eee eam ESPN Ne pees ee EE a NE ea eee EE Nee reer 5 O 5 Proe Scarc ARESU land cli id 6 MN E E a Tee are 7 Drait Estimate Work DOOK aio in 7 PROPECUS Caco Resta iris aio pea 8 Pago Navi Sati OM atados 9 PrO CU CM T A on E ER 11 APpicaloOn Da o diodos 12 O Baba a caaatiecieadi E adie ont ead eee adianatiueeatieenie 12 Project Detalle Tabs last 12 SHOW ide Second tal A on 12 Prorectintomation Lab ta 15 A AS 15 Dit odds 15 Loci OM dida 17 RS 18 Project Estimates Tab A ti 19 Selecting Cost estimate figures by Project Managers occccccccccnonoocncnnononononnnnonnnnnnnnnononananononss 19 PrO AIM asas 19 ES cisco ico 20
45. D EQUIPMENT Ad Date eee The Ad date is the date that the project advertises This date must be the same as the Pool CN Start date and the same as the Schedule planned end date for Activity 80 or 80Z unless an actual end date exists If an actual end date for Activity 80 exists then this date becomes the ad date 18 PCES Version 3 1 User Manual Date 4 9 14 Project Estimates Tab Selecting Cost estimate figures by Project Managers PCES estimates should not be forced to match TRNS PORT figures If before advertisement there is a wide gap greater than 20 in the cost figures between PCES and TRNS PORT the Project Manager should determine and document the reason for the variance and adjust his her recommended project estimate accordingly Final Submission cost estimates should always be based on the fully detailed TRNS PORT construction estimates A Before selecting PCES as estimate source all applicable tabs of f the PCES Warning estimate workbook must be fully completed If TRNS PORT and or RUMS are then selected PCES data will still be accessible but overridden Project Estimates has project specific information grouped in the categories Project Summary Estimates TRNS PORT Estimates RUMS Estimates Pending Approval Estimate Supporting Documents PD 1 Fundings and Authorizations Project Summary UPC 52330 Description RTE 64 UPGRADE SEMER SYSTEM PE ONLY WWE REST AREA State Project
46. Date 4 9 14 Project Information Tab Project Information has project specific information grouped in the categories Summary Details Location Status Summary The summary provides a summary to remind the user of the project currently being viewed summary UFE 11612 Description RTE 29 LYNCHBURG MADISON HEIGHTS BYPASS ROUTE 460 INTRCH state Project 60 29 115 FOF scope of Work NEY CONSTRUCTION Figure 15 Project Information Summary UPC asar The identification numbers the FMSII system assigns to projects This number is used across the enterprise to identify projects It is unique to the project and will never be assigned to any other project Description A textual narrative briefly describing the project for quick identification and reference purposes State Project The state project number is 10 alphanumeric characters long with a format of XXXX XXX XXX Route County City and Section Scope of Work Broad category describing the work proposed in the project Details Project Type PRIMARY TAO HEARING DESIGN Job Humber s P101 R201 Project Manager John Doe YTA GF TA FTF Comments GOES VID 13178 P100 ID 181 96 CN Primary Consultant Figure 16 Project Information Details Project Manager The person named to be responsible for the management of the project Project Type Schedule Type from Project Pool Job Number s
47. Esi Maes acts aia 39 Scope Of Work ooooooccccccncccnononincnononnnnnos 14 o eea 23 Select Manager button oooooonnnncnnnnnos 16 Show Hide Section details 12 SPU Estate eet aad 24 Stare LOCA ON iia 17 State Project Tc 9 15 19 Total TRANS PORT Estimates 26 Total PCES Estimates List eee eee 25 Total RUMS SUMS somo 26 Total Estimate Project Search Results o o o 9 Type PCES Estimates List eee eee 25 A ete mre eRe meee rere nears 6 9 15 19 PCES User Manual O aie et ci A icel et deals 12 Upload ESTO uni 21 Version PCES Estimates Sas ntasis 25 72 Version 3 1 Date 4 9 14 Verson S QUIECO heri 9 VEAD ororen AR 16 NTA PUB rata addict 15
48. S RIVER 6029 118 FOF Lynchburg RTE 95 RICHMOND Richmond 1242006 PF 335 365 PETERSBURG TRNPE BRIDGE REHABILITATION 7095 020 FO ary Martin Expenditures Figure 3 3 Search Results Totals Bar A blue bar listing the total number of projects in the list after all searches and filters are supplied is displayed before the list of search results Project Search Results 7 projects found Figure 4 Projects Search Results Totals Bar Draft Estimate Workbook nm Clicking LES Download Draft Estimate Workbook enables the user to download an empty PCES Worksheet where they may create a draft estimate PCES Version 3 1 User Manual Date 4 9 14 File Download Do you want to open or save this file Mame PCES Draft xls E Type Microsoft Excel Worksheet From isyp aT While files from the Internet can be useful some files can potentially harm Your computer IF you do not trust the source do not open or save this file What s the risk Figure 5 Draft PCES Worksheet Select Open Save or Cancel as appropriate If you encounter problems while trying to upload estimates from an earlier version of PCES it may be helpful to 1 download a blank workbook in Version 3 1 2 enter the project information and 3 upload the workbook Project Search Results This page element is a list of all the projects that satisfy the filter criteria set in the controls above Please note that the default opening
49. User Level on a district by district basis which allows the user to modify the project information Following training VDOT users must fill out form ITD 35A Appendix A requesting permission for PCES User rights and the level desired External local government users must fill out form ITD 35E and ITD 36E Appendix B Access Levels and Permissions Local Access view project details download blank project estimates download documents images and videos upload project estimates for VDOT Project Manager review approval download documents images and videos PCES Version 3 1 User Manual Date 4 9 14 Administrator View project details Assign project managers download estimates download documents images and videos Estimator View project details download and upload estimates initiate PD 1 process select recommended estimate update split estimate screen download and upload documents images and videos document division comments Project Manager Individual Projects View project details download and upload estimates initiate PD 1 process select recommended estimate update award estimate download and upload documents images and videos document division comments delete documents images and videos edit project information manage schedule build team internal and external members assign action items setting 5 CEP milestone meetings assign estimators and guests Project Manager District View project details
50. a aa aa a aa 35 Se Dic TMpProve MEM S ecen a ea os 35 d DO a E R taeeeeee 36 IS D EI E E A E E EAT E E E A renee rye Tr ree 40 Utilities Worksheet sata dabas 41 Column 1 Comp ted or US rastas 42 11 PCES Version 3 1 User Manual Date 4 9 14 Column 2 Right of Way or Construction ccccccccccccesssseseeeceeeeeeaeeeeeecceeeessaaeeeseseeeeeeeaaas 42 Coumi Descaptiornot UUN cece E aE 43 Comi AA Ost per UNo E E 43 Coumo Unir Lone N 43 C Olin Rural Ol Urbana 43 Columna 7 Percent VDOT icteric cnc ate eee esas a a ee 44 Colino O as int DU More 45 Comi LO RIP E 45 Colima OSO Con des ne e ed 46 CO AA A E E S EO 46 Comment Nee hennis id 47 Mangal Works hec Psese A AAA 49 Appendix A PCES Generated Project Cots siccin E 51 Appendix B Changes an PEES VW 2 L102 aiii 55 Appendix Chansesan PCES T 23 02 plis 57 Appendix D Chanees in PCED 17 24 TO 2A ir AS 60 Appendix E Chang s in PCES Vs 241102 Jairen n a O EN E 6l Appendix F Changesin PCES V 2 10 21 id en a a 62 Appendix G Chances IM PCRS Va 250295 ta oc ota 63 Appendix H Changes in PCES v 2 53 to 2 60 ii A A 64 Appendix T Changes nm PCES v 200 t02 0l surcar ln 65 Appendix Changes im PCES Y 2 6110 2 02 sico cr ici 66 Appendix K Changes ta PCES V2 202102 susan seas 67 Appendix Ie Chanees in PCES V2 7 O29 Laine 68 Appendix Me Changes mM PGES v2 9 10 2 94 lira 69 Appendix N Changes in PCES v 2 94 to 3 1 0 ccc cece cece soenen e cece eee e
51. ach bridge Cathodic ray protection scour protection on existing structures expansion joint removal paint removal stairways observation posts Work bridges drilled shafts special or custom railings operable bridges and all associated equipment work coffer dams rip rap lighting sound walls painting non normal bridge features Environmental issues amp permit work restrictions when working over water access restrictions due to location asbestos abatement working over heavily trafficked PCES Version 3 1 User Manual Date 4 9 14 Appendix B Summary of Changes from Version 2 1 to 2 3 PCES v2 3 Cost Factor Changes The following cost factor changes have been made to the PCES Construction PE Bridge worksheet These factors will be in place when the PCES worksheet is downloaded from the PCES website In order for these factors to become effective a new PCES worksheet should be downloaded from the system and saved District Factors District factors for the following districts have been increased The rest will remain at their current factor Fredericksburg remained the district used as the baseline e Salem e Hampton Roads e Culpeper e Staunton Flush Median This option has been removed from the worksheet If the project has a flush median please treat it as an additional lane Interstate Cost Factors These cost factors have been adjusted to increase the lane mile cost Surface Only and Surfa
52. additional PE Cost over and above amount calculated by the system Construction Engineering This field is may be manually populated to override CE calculated by PCES or imported from TRNS PORT Bridge Job This optional field maybe populated with a Job for the bridge E Microsoft Excel gt File Edit View Insert Format Tools Data Window Help A MENS Y EE A A A ES OE O SIENA e cf brl_ const Fx SH PCES_Draft a Arial Marrow 10 Reply with Changes End Review H 4 FOX DRAFT 4 SUMMARY CONSTA CONST 1 4 CONST 2 4 CONST MISC BRIDGE EY UTIL COMMENTS 28 PCES Version 3 1 User Manual Date 4 9 14 Removal of Existing Structure Length and width in feet of existing bridge is entered into most fields to determine total square footage of structure Cost of bridge removal is based on preset square foot cost The cost values generated should be adequate for all types of bridges that can be dismantled with normal contractor equipment and procedures Existing Bridge Length Enter the Length in feet of the Existing Bridge to be Removed Miscellaneous Bridge Cost The bridge engineer designer may add additional funding to the cost of the bridge in this field based on past history and good engineering judgment A negative number may be entered should the bridge engineer designer feel the cost is too high The bridge engineer designer should document the adjustment on the comment worksh
53. amps and Loops mi laa gt WI DRAFT SUMMARY CONST Y CONST 1 CONST 2 CONST MISC f BRIDGE RW UTIL COMMENTS 12 PCES Version 3 1 User Manual Date 4 9 14 Number of Additional Lanes amp Length of Additional Lanes mi The project manager designer can enter additional lane information and the length in these fields for the two lane four lane and ramps amp loops For the two lane and ramps amp loops the project manager designer can only select one additional lane For the four lane the project manager designer can select up to four additional lanes The length is to be entered in miles The length of additional lanes is used to multiply by the total number of additional lanes selected See additional lane illustrations below for two lane four lane and ramps amp loops choices The additional lane costs are not adequate for stand alone projects These costs are to be used in conjunction with Adding or Building 2 or 4 lanes and ramps amp loops Two Lanes Additional Lanes i File Edit View Insert Format Tools Data Window Help Type ac SF A RFE MIA Re Dw M We nt ee gt Y ci two lane v fe None a Arial Narrow Ye ee i lt r O S A 0 Pe Reply with Changes End Review sy PCES Draft Number of Additional Lanes EA E AAA 4 on Two Lane Improvements Only Total Length Adding or Building Two Lanes mi A N
54. ard should be selected Maintenance Project Maintenance Project is selected when a project such as emergency contract is entered into PCES but is only in the system for a short period of time Selecting Maintenance removes any estimate year inflation on that project Route Number Project Manager must populate the fields Project No MISSING DATA Interstate Project po Select Enter Data into All Applicable White Boxes in order from Top to Maintenance Project po 4 Bottom Route Number po Geometric Standard Uses the roadway geometric standard selected to determine the lane mile cost of the project Consists of the nine geometric standards Interstate GS 1 to GS 8 found in the Road Design Manual This block has a drop down menu to allow the project manager designer to select the appropriate Geometric Standard for the project ES Microsoft Excel Ele Edit View Insert Format Tools Data Window Help drial B 7 UJ AEREA IES eee a ee Eir B 93 03 ie 57 21 4 Ay fed We Reply with Changes End Review KAU Fe PCES Draft Route Number 2 Primary Highway Geometric Standard Urban Minor Arterial Street System Ad Date 2007 Design Year 2029 Pia a HA DRAFT SUMMARY CONSTA CONST 1 CONST 2 f CONST MISC BRIDGE RW UTIL COMMENTS PCES Version 3 1 User Manual Date 4 9 14 Ad Date This will automatically populated from the FY advertisement year shown
55. ate 4 9 14 Enter the Width of the Bridge Enter the width in feet Note For bridge widening enter width of widening not total width Complexity Type of New Bridge The construction complexity of the proposed bridge is to be determined by the bridge engineer This field has a drop down menu with five levels of complexity from which to choose Complex Moderate Simple Widening of Existing Bridge WEB Includes costs to widen an existing bridge and maintenance of traffic The length and width shown should only be for the proposed widening portion of the structure e Superstructure Replacement Only SRO Includes cost to replace superstructure and average maintenance of traffic costs Good engineering judgment should be applied in selecting the bridge complexity In deciding the complexity level of the bridge the bridge engineer should take into consideration the geometry and type of structure The complexity level should be increased if some of the factors listed below are involved in the construction of the bridge There may be other factors not mentioned Curved or splayed girders Phased Construction Cofferdam Causeway or temporary work bridge Skew gt 45 degrees 26 PCES Version 3 1 User Manual Date 4 9 14 Construction over body of water Urban setting with construction limitations availability of staging area Superstructure erection over traffic Longer span or pile lengths require larger cranes and hi
56. ate into PCES for projects that cannot be developed from the construction bridge right of way and utility worksheets With this added feature all project estimates can be captured in PCES The intent of the feature is not to just capture the total project estimate but to allow the user to enter estimates for each job number or phase AND to provide documentation as to how the estimates were developed The documentation can be captured in different ways First each job number has a field to enter comments or documentation Second the user may elect to enter this information in the Comments worksheet Last if documentation has been created in a separate file the user can upload the file through the PCES website under Estimate Supporting Documents If the last way is used please provide the file name in the comment field so future users or people viewing the estimates can easily retrieve and view this document It is recommended the name of the user and the date be entered on the Comments worksheet for future reference These fields will not automatically populate the job number breakdown on the website The user is still required to enter this information The first portion of the Manual worksheet shows data populated from other sources Ed Microsoft Excel Culpeper_000000000056130 Oy x ES File Edit wiew Insert Format Tools Data Window Help x ee A e A eee ce eee ee ee eee AVDOT Project Cost Estimatin
57. ce Plus Cost Factors These factors have been reduced to more closely match the data collected for Rural Rustic Roads projects These factors should typically be applied to projects not using plant mix Lane Mile Cost Factors These factors have been adjusted increased for all geometric standards to more closely reflect the data collected This applies to projects with curb and gutter as well as shoulders This also includes the additional lane cost factors 55 PCES User Manual Version 3 1 Date 4 9 14 Feature Cost Factors The following features have been adjusted increased Raised Median Curb amp Gutter Sidewalk Crossover Right Turn Lane Left Turn Lane New Signal Costs 2 lane and 4 lane Adjust Existing Signal Costs 2 lane and 4 lane 56 PCES Version 3 1 User Manual Date 4 9 14 Appendix C Summary of Changes from Version 2 3 to 2 4 PCES v 2 4 CHANGES TO THE WEBSITE Search Page e New expired estimate and SYP logic o Projects selected are in current LIVE or current working 1S YP scenario Programming Division to determine project category o Excludes district wide and budget line items o Expired definition expanded to include estimates older than 90 days old as well as estimates where expenditures exceed the estimates e The reason for the expired status is now shown when you mouse over the estimate total column and is also shown on exported report e The exported listing no lon
58. cta natos 14 Median Type Graded Raised Or NONG ti iia 14 Number of Crossovers Divided Highways Only oooooocccccnnccccnononccnnnnncnnnnnnnanonocnnnnnnos 15 Length of curb amp gutter Left Plus Right Side EL ooooooncnnnnncccnonnnoccnnnnnnnnnonononononnnnnnnos 15 Length of Sidewalk Left Plus Right Side ft occoooononnnncccnnnnconnonccnnnonononononancnnnnnnnnnos 15 Bike Pedesthian TYDE ai cntusheeuanecedayeuata secenanweewmnecedauustanesesannuawaneacdans 16 Total Lensth Raised Medran Hoi id 16 Number of Right Turn Lanes Left Plus Right Side oooocccccccccnoonooncnnnnnnnononnnncnnnnnnnnnos 17 Number of Left Turn Lanes Undivided Only cooooooonnccnnnnnononononcnnnnnnnnonononanononnnnnnnos 17 Cost Ol Laree Drainace Stuctures dla ansia 18 PUNY COSS odon 18 Adjustment for Unusual Construction Costs cccccccccccssssscccceeessssceeceeeesseeeceeeesssseeeeeeens 19 Additonal or Unusta PE Costilla 20 Select Yo ot PE to be performed by Consultants ZA Signals ITS Signs and Lighting Cost Worksheet 0 ccc cece ence cece eee e een e cece ees 23 Bride VV Oi KS NS dde 23 Proposed Bridge InlOrn aon ralla 24 Remy alr Existe Structural 29 Miscellaneous Brdset Osuna dd tea 29 Other Fields Automatically Populatd in 31 Rientot Way Worksheet 5 tccss tscccadecedowespnadinzanendentauesciind a a aa aeaa 32 LAA NAO e E N 34 yas A O O 35 PARE BUNOS V alU PACA PE on o
59. dow 18 x Project Location CULPEPER 700 of Statewide Avg DO 0o ee f eee Base Estimate 1 A total of the roadway construction costs in PCES based on current cost factors When TRNS PORT is the recommended estimate source the estimate includes line items plus any contingency specified in TRNS PORT but not construction engineering CE Base Estimate 2 Same information as Base 1 as reported on Const 2 tab The function of the Const 2 worksheet is exactly the same as the Const 1 worksheet The purpose of the Const 2 worksheet is to allow a user to estimate 21 PCES Version 3 1 User Manual Date 4 9 14 o two different roadway sections on one project Enter Const CE Cost This field enables a user to specify an amount for CE This field can be populated when using PCES or E TO TA BRA TRNS PORT as the estimate source The amount i Base 1 PCES enforced here will over ride any value from PCES or Base 2 TRNS PORT Enter Const CE Costa m i CE 18 9 826 This field will show CE cost calculated by PCES or on Construction Costs the CE amount in the TRNS PORT estimate when Estimate 2007 364 416 TRNS PORT is selected as the estimate source on the Inflation Rate 10 37 summary page of the workbook Estimate in Hid FY2007 71 096 Estimate Year This field will show the estimate in the year the estimate was prepared The year will be the same year as the estimate year as reported on the
60. e adjustments to existing infrastructure removal of drainage structures 51 PCES Version 3 1 User Manual Date 4 9 14 Excluded Items costs must be added on CONST MISC worksheet Items Automatically Included in Lane Mile Cost or Description Calculated by PCES 25000 Field field office schedule updates Office Contract Partnering Items 26000 RipRap ptr routed and non grouted 27000 Environmental seeding fertilizer lime topsoil cofferdams stormwater stabilization mat protective management construction items covering diversion channels well closings landscaping items dewatering basins excavation trees bushes shrubs flowers siltation control fencing mulch for plantings wetland geotextile fabric filter barriers mitigation removal of landscaping and stone items underground storage tank removal 40000 Water and Sewer supply and sanitary lines input valves boxes hydrants meters LF next to dia on UTIL asbestos line and equipment per ft worksheet cost removal asbestos containing material removal and connections to manholes encasement piping indicate cost on UTIL worksheet under additional costs for water and sewer 50000 Signage permanent vertical support sign panels and construction signs posts bases OH counter lever and Bridge Mount input on the Signals Tab Signals electronics electrical services concrete foundations poles cables hanger assembly installation si
61. e Average District From the Drop very High down List M41 pi SUMMARY CONT A BRIDGE ARM UTIL A COMMENTS 7 UM Define Project Land Use Characteristics The user has four options in this category Agricultural Residential Industrial and Commercial The user must select the percentage that best fits the amount of each zoning class of land impacted by the project Each land use description has a drop down menu to select the percentage to be applied to that particular land use The percentages need to total 100 before the system will provide a total cost Ed Microsoft Excel Test PCES Project Read Only o Joj x B File Edit View Insert Format Tools Data Window Help a x ri_use_reside y Residential Select Project Area Real Estate Costs LLL Define Project Land Use Characteristics Agricultural 25 Jj Select the he ee on j i i i 41 Project that is within Instructions Please fillin all applicable White Boxes Industrial y TE or make a choice from the Drop down Lists Commercial i as Residential in use HLS SUMMARY Ready RW Enter the Approximate Number of Parcels on the Project The user enters the number of parcels to be used to compute the right of way cost Select Computed or User Defined Costs There is a drop down menu for the user to choose the recommended cost process for the project Computed Cost uses the cost associated with
62. e Total Length of Concrete Sidewalk fin Feet For the Project Left Side PLUS Right Side where applicable 15 PCES Version 3 1 User Manual Date 4 9 14 Bike Pedestrian Type Project manager designer is to enter the type of Bike Pedestrian facility on the project Two and four foot wide curb lanes extend the existing roadway to accommodate these features Shoulder types use the same material that would be used for a shoulder on the project plus the costs for striping and signing Shared use paths are typically aggregate base and surface course unless otherwise specified Number of Crossovers Divided Highways ONLY Length Curb amp Gutter Left PLUS Right Side Ft Bike Ped Construction Costs Statewide Avg Length Sidewalk LeftPLUSRightSide ft Length ft 4 000 Bike Pedestrian Type h 2 wide curb Lane CE Cost 7 345 4 wide curb Lane Total Length Raised Media Shoulder paved PE Cost 7 000 10 shared use path Inflated Const Cost 52 793 Number of Right Turn Lanes Left PLUS Righi Variable shared use path Number of Left Turn Lanes Undivided Only FREDERICKSBURG Total Length Raised Median ft Project manager designer is to enter the length of raised median in this field This length is to be shown in feet 16 PCES Version 3 1 User Manual Date 4 9 14 ES Mic Seen alee E Bile Edit View Insert Format Tools Data window Help J j fu e Rep
63. e of the project that will be overlaid this section should not be included in the length but the cost for the overlay area should be entered on the Misc Const field 11 PCES Version 3 1 User Manual Date 4 9 14 ES Microsoft Excel i File Edit View Insert Format Tools Data Window Help Type BOY OF AS BF A d Ea R A cs E arial Narrow AAA ds ci_ two _lane_mi fe 1 PCES Draft A 0 i Fe Reply with Changes End Review Length of Two Lane Improvements Enter the Total Length in Miles of Two Lane Improvements to be constructed Include all Connections that will be improved beyond the flares Include any location where two lanes are being added to an existing roadway Do NOT include Turn Lanes here Total Length Adding or Building Two Lanes mi One Add Lane Total Length Adding or Building Four Lanes mi i Total Length Building Ramps and Loops mi _ M 4 AA DRAFT Z SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COM Total Length Adding or Building Four Lanes mi This field is for the project manager designer to enter the length in miles of four lane roadway to be constructed For example if a project has a section in the middle of the project that will be overlaid this section should not be included in the length but the cost for the overlay area should be entered on the Misc Const field ES Microsoft Excel gt File Edit w
64. e was a bug or if the PD 1 is never submitted or if it is deleted before being submitted the new estimate is allowed to be selected but it is not approved The key event in PCES is the selection of the estimate whether it is a new estimate or an existing estimate That is what is supposed to drive the PD 1 generation If it is not happening or happening intermittently then there may be a problem PD 1 section contains Status List and PD 1 detail information Status Request Date Requested By Rejected 12 05 2006 Steven McNeely Mew 12 18 2006 Franklin Shue Figure 35 PD 1 Status List To view a printable version of the PD 1 click on amp on the right side of screen The PD 1 area when expanded automatically includes the Project Manager s Selected or Recommended Estimate If the Project Manager s Recommended Estimate has triggered a PD 1 in the Pool the status of the PD 1 will be listed If a PD 1 or other revision request is pending approval in the Pool no changes can be made to the Recommended Estimate until the PD 1 or other revision request is approved or rejected 29 PCES Version 3 1 User Manual Date 4 9 14 Expenditures Budget Esti mate Approved Esti mate Recommended Esti mate Esti mate FMS S5YIF FF MS5 E Scoping Increases Decrease Date 3517 2004 T2006 10 20 2004 4 2006 HE 29 556 254 000 254 000 254 000 MANGAL 0 Fe 0 0 0 0 MANUAL 0 CH 0 3 500 000 3 500 000 3 500 0
65. ect it Select the appropriate Category Asset Management Local Assistance Structure amp Bridge Construction Location amp Design SUrvey Correspondence Materials System Operations Environmental Operations Management TBA Estimate Supporting Document Programming Traffic Engineering General Public Hearings Transportation amp Mobility Planning Hydraulics Residency Office Utilities Image Right of Way Video L amp D TE Design Scheduling amp Contract 4 Select the appropriate Phase SP Field Inspection Scoping Pre Advertisement Conference Preliminary Field Inspection Construction Engineering Public Hearing or Involvement 5 Select the appropriate Status Completed Mew Revised 6 Click to upload the document or to cancel and close the window 28 PCES Version 3 1 User Manual Date 4 9 14 PD 1 The PD 1 Process should work like the following 1 An estimate is uploaded into PCES 2 The estimate is selected 3 The system checks to see if the estimate requires approval 4 If the estimate does not require approval it 1s auto approved 5 If the estimate does require approval the system checks to see if it can generate a PD 1 There must not be an outstanding revision that is new pending in approval to block the new PD 1 6 Once the PD 1 is generated submitted and approved the recommended estimate becomes the approved estimate If for any reason the PD 1 is not generated because it was blocked or if ther
66. eeeeeeeeeeeeeneeeees 70 TCX cca at acts Seat ante ones anes A OR 71 111 PCES Version 3 1 User Manual Date 4 9 14 PCES Overview VDOT s Project Cost Estimating System PCES is designed to e Collect and store cost estimates for specific projects in the Six Year Improvement Plan S YIP and the Secondary Six Year Improvement Plan SSIP e Enable project managers to generate update and view project cost estimates for projects that have been scoped e Import cost estimates from TRNS PORT and RUMS as well as allows for manual entry of costs PCES is linked to IPM and FMSII through the Data Warehouse and some data fields throughout the system are automatically populated by pre existing data or as soon as UPC numbers are assigned For example any VDOT project with a UPC number automatically appears in the system as a project within the purview of a VDOT district whether or not it has been assigned to a project manager or has any cost estimates attached Mandatory PCES usage by Project Managers VDOT s Project Managers PM are responsible for entering and updating project cost estimates in PCES and managing the resulting budgets for their projects All project cost estimates must be reviewed and updated by the PM at every project milestone Project Managers decide based on input from supporting VDOT divisions when TRNS PORT and or RUMS should be selected for the cost estimates with the exception of the Final Submissi
67. eet When a miscellaneous cost is added for a bridge this cost is automatically Note added to the bridge construction total 29 PCES User Manual Misc Cost Br Enter explanation for cost modification Enter date Enter Team member amp section 30 Version 3 1 Date 4 9 14 PCES Version 3 1 User Manual Date 4 9 14 Other Fields Automatically Populated Bridge Totals The fields Bridge Estimate today Total Bridge Estimate for Ad Date and Total Bridge P E costs are automatically populated based on data entered in the Bridge Construction worksheet A breakdown of the bridge cost has been added to show the total estimate of all bridges in the Bridge Construction Base cost total estimate of bridges to be removed and the total Construction Engineering CE estiamte for bridges Bridge Estimate Current Year This field adds the individual new bridge construction costs and bridge removal costs together to create a total bridge construction cost in today s dollars Inflation Rate The number reported in this field will be the compound inflation rate to advertisement year as reported in the Summary page of the workbook Total Bridge Estimate for Ad Date This multiplies the total of today s bridge construction estimate by a pre determined yearly inflation factor to establish advertisement date cost Total Bridge P E Costs This adds all individual bridge preliminary engineering costs together to establish a
68. eet are determined by the source from which the data is collected and multiplied by a set inflation factor to the anticipated advertisement date for the construction and acquisition date for Right of Way and Utilities These individual estimates are tallied to determine the project estimate See the breakdown in the Const tab The advertisement date can be selected on the Summary Worksheet EJ Microsoft Excel File Edit view Insert Format Tools Data Window Help 06d aaa 7614 naa Aire 233034946 49 0 0 4 4 04 Reply with Changes End Review select pee fe PCES 5 PCES_Draft Preliminary Engineering Estimate Construction Estimate Right of Way Estimate Utilities Estimate DATE 2 15 2007 Moa gt bt DRAFT Y SUMMARY CONST 4 CONST 1 4 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS When using TRNS PORT or RUMS as the estimate source please allow 24 48 hours for this information to be backed up by the Data Warehouse PCES User Manual Construction Worksheet This worksheet summarizes all cost information from the Constr 1 Constr 2 Misc Constr and Bridge worksheets Its table format is self explanatory At the bottom of this sheet the total Construction Estimate and Total Preliminary Engineering Version 3 1 Date 4 9 14 Estimate are summarized These are the same numbers that are reported on the Summary Worksheet Interstate Project Route Number Construction
69. ercentage of preliminary engineering to be performed by consultants Project manager designer shall survey and collect feedback from all divisions associated with the preliminary engineering of the project and determine the appropriate percentage to apply to the project The P E cost will be increased by 50 over normal in house design costs The appropriate percentage can be selected from the drop down menu gt File Edit wiew Insert Format Tools Data Window Help AIRIS eee ape een E i r dd ce 5 el ud e Na vs Reply with Changes End Review cl consultant Fe EH PCES Draft Yo of PE Outsource A Select the anticipated Total Additional or Unusual P E Costs Percentage of Preliminary Engineering activities on Selects of PE to be performed by Consultants I PE Cost this Project Roadway portion ONLY which will be 19 70 Designed by Engineering 2 Consultants Note Do Not Include Bridge P E Costs E Roadway Const AAA E Se L IGE R UTIL COMMENTS raa een ea a rre do Moa oh AA DRAFT 4 SUMMARY CONST CONST 1 CONS of Statewide Average Cost factor associated with each district in determining the base construction estimate In PCES FREDERICKSBURG DISTRICT is considered to be the base cost Other Districts either have greater lesser or the same cost factor as Fredericksburg Ed Microsoft Excel Test PCES Project File Edit View Insert Format Tools Data Win
70. ess the to view the result Clicking the will clear all entries from the search fields Project Search Results The next part of the page is the Projects Search Results comprised of a Totals Bar Listing and Page Navigation PCES User Manual Version 3 1 Date 4 9 14 VII We yl District o wee es Cities Towns 2 state Proj 07 UPC Project Search Results 7 projects found User s Guide About 0 CMA System Fro T Status Pro ae z oe les gt Esti mate Source All Foote Description Download Draft Estimate Workbook Esti mate Date wersion Source Award District Project Mor Total Esti mate Miamin Tart State Project Description UFC 0001 106 FO 7 RTE 1 4 L4SNES5 WITH CURB 4594 GUTTER amp SIDEWALK Richmond 1472006 9 S64 466 RTE 64 UPGRADE SEWER Jacob Porter 72006 SYSTEM PE ONLY EB REST AREA O064 002 FOF Culpeper 2 10 Scoping 3 790 000 RTE 64 UPGRADE SEWER Jacob Porter Sf 2006 SYSTEM PE ONLY We REST AREA O064 002 FO7 Culpeper 2 10 Scoping 3 754 000 6029 118 FOF 6029 118 FOF RTE 29 LYNCHBURG MADISON HEIGHTS BYPASS ROUTE 460 INTREH RTE 29 LYNCHBURG MADISON Lynchburg Lynchburg John Canile John Canile 11 29 2006 11 29 2006 2 10 Expenditures AWARD 4527 2035 9 080 146 HEIGHTS BYPASS RTE 460 IN TCHS ceard 11 29 2006 AWARD Award RTE 29 CYNCHEUR GS MADISON John Canile 21 146 693 HEIGHTS BYPASS JAME
71. feedback goes to the Scheduling amp Contract Division with a copy to IT Applications 33 PCES Version 3 1 User Manual Date 4 9 14 PCES Worksheets Objective The purpose of the Project Cost Estimating System or PCES is to collect data for a specific project and based on the data entered determine a budget for that project This budget is to be used for the Six Year Plan SYP until a detailed estimate can be generated using actual project quantities and unit prices PCES is a budgeting tool not a detailed project estimate The data entered needs to be based on a good project scoping Think of PCES as a budget placeholder until such time a detailed estimate can be created The following information about the individual worksheets is based on PCES version 3 1 Project Budgeting Considerations Persons assigned to manage projects are responsible for maintaining the project budgets for those projects Project estimates should be reviewed and updated every 90 days or at every project milestone whichever is less It will be the project manager s discretion based on input from other divisions when TRNS PORT and or RUMS should be the selected estimate with the exception of the Final Submission stage Final Submission estimates should use TRNS PORT as the source for the construction estimate Before selecting TRNS PORT or RUMS make sure all portions of the estimate have been included 1 e bridge drainage traffic etc for TRNS PORT and ri
72. g System QypoTl Yo MANUAL ESTIMATE DATE 6 EXPENDITURES 0810 04 005 023 204 004 473 160 RUMS 05 17 04 451 600 EJ TRNS PORT 5 099 511 Esa AWARD 03 29 04 3 440 211 PROJECTION 08 12 04 2 928 047 MA I SUMMARY CONST BRIDGE RW UTIL A COMMENTS MANUAL Ready Pop Mmf f zg The user can enter the individual job information in the fields shown below job number phase comment and estimate The worksheet can accommodate up to 18 different job numbers for a given project The data for the job number field is to be entered using four characters 1 e P101 R201 C501 and B601 The phase field has a pull down menu to allow the user to select the appropriate phase for the estimate 1 e PE RW and CN The comment field will allow the user to enter comments related to the job number 49 PCES Version 3 1 User Manual Date 4 9 14 The estimate field will allow the user to enter the dollar amount for the job number Note This information does not automatically populate the split estimate window on the PCES website Ed Microsoft Excel Culpeper_000000000056130 Mel Ei File Edit View Insert Format Tools Data Window Help x La ES EEC SAVE DAES ME SSS SSN SS AS Job Phase Comment Estimate This budget was developed using the current 1 300 000 expenditures in Phi Il f1 million and estimated amount needed to complete PE 300k 5500 000 Budget was developed using data provided by RAN
73. ge TRANS PORT Estimates oocccnnccnno 26 CEI Road TRANS PORT Estimates oocccnnccnno 26 Change Project Managet ccccseeeeeee 15 CN PCES Estimates Litunia 25 collapse sections See Show Hide Section details Comments Project Detalla aaa 15 Constr Contingency TRANS PORT Estimates oocccnnccnnc 26 Constr Total TRANS PORT Estimates oocccnccnnc 26 COUN Vi ga Sisto ic 17 County PAOI y oia 17 Date PCES Estimates List eee eens 25 TRANS PORT Estimates 26 Description Pro usaste dios 9 15 18 Ds A Mate Pe ene even te tre nT 9 17 Download Blank Estimate 00 20 Editan ESTIMA bane anes 26 End Loca a a A 17 Estimate Dileas a E 9 Es mate Histol seia 20 Estimate Supporting Documents Zi expand sections See Show Hide Section details JOD Numbers iia raid 15 71 A eens E S 17 PCES ASSIS FAN CC al esas 2 A ee ee 29 PE PCES Estimates List wo eee eee 23 Primary Consultant cccccccocoocnncnnnnnnnnnnnnns 16 Project Wana Clannad 9 16 Chal G eeen a 16 Project Mer cs See Project Manager Project Stat aid 18 Project Dy DC rare aac O etal 17 RESINA Geedonmainm econ 17 R dd Nimes 17 Road Syse nenna doi 17 A a se tote es tea 9 17 RW PCES Estimates List wo eee ees 20 RW Acquisition RUMS EstimMates ooccnocnnccnnccnnccnoconocono 32 RW Relocation RUMS EstimMates ooccnocnnccnnccnnncniconocono 38 RW Utility RUMS
74. ger includes the HR Planning data Instead it now includes the estimate date version and expiration reason e New numerical selection for searching Project Information and Estimates e Slightly different format e Only the currently selected estimate is shown click on Show All Estimates just below Estimate History to show the estimates in phases e TRNS PORT and RUMS estimates data has been compressed to take up less room no change in data content e The Pending Approval section is hidden by default but will be displayed if there are pending estimates e The PD 1 process is now linked with the Project Pool dependent on the release of the Pool working feature may be delayed PCES v 2 4 CHANGES TO THE WORKBOOK Summary Page e The Advertisement and Estimate years now default to 2007 CONST 1 Page e The choices for Total Length Raised Median ft and Number of Crossovers Divided Highways ONLY are now always visible 57 PCES Version 3 1 User Manual Date 4 9 14 CONST 2 Page e The choices for Total Length Raised Median ft and Number of Crossovers Divided Highways ONLY are now always visible e A box text has been added so that the user may manually change the lane width as on the CONST 1 Page Values and Cost Factors e The lane mile values changed according to the following GS types GS 1 3 GS 2 13 GS 3 3 GS 4 3 GS 5 13 GS 6 13 GS
75. gher transportation costs Level and type of aesthetics treatments Above normal riprap Curved alignment Select the level of complexity of construction based upon anticipated cost Options are C Complex M Moderate 5 Simple WEB Widening of Existing Bridge SRO Superstructure Replacement Only Bridge Construction Cost Field is automatically populated using data provided in the Length Width Complexity Type and district factor of new Bridge 27 PCES Version 3 1 User Manual Date 4 9 14 of Consultants The bridge engineer is to determine the percentage of the bridge preliminary engineering work to be outsourced The P E outsource percentage will be increased by 50 over normal in house design costs to determine the total bridge preliminary engineering cost ES Microsoft Excel File Edit View Insert Format Tools Data Window Help Arial Narrow A EEN UA EEN A AAN da ado a4 120 0 47853 cl_bridge 1p ie a Draft BG OIL GE Reply with Changes End Review Yo of PE Outsource Comp Select the anticipated Total Percentage of Preliminary Engineering activities which will be Designed by Engineering Consulkants y mM Bridge P E Cost Field is automatically populated using formulas that incorporate the bridge construction cost and percentage of outsourced bridge preliminary engineering Misc PE Bridge User may populate the field with an
76. ght of way and utilities for RUMS Once TRNS PORT or RUMS is selected it will override the data in PCES PCES Contacts The Scheduling amp Contract Division has been assigned the responsibility of maintaining and updating PCES Anyone having comments questions about PCES can contact Corey Bourne at 804 786 2538 PCES Version 3 1 User Manual Date 4 9 14 Summary Worksheet The purpose of the Summary worksheet is to summarize the costs of each phase of the project construction right of way amp utilities and preliminary engineering In addition it provides the reviewer with other essential information such as District Project number UPC number and project manager These fields are automatically populated from other systems and cannot be changed The Estimate Year is automatically populated but the AD year and Construction End Year can be changed These Years are based on the State Fiscal Year If the project has an advertisement date of March 2014 the fiscal year is FY2015 If the project has an advertisement date of October 2014 the fiscal year is FY2015 Inflation is added to the AD year as well as the Construction End year Construction End year inflation is calculated when a project is under construction for more than two years It is recommended the advertisement year is not to be changed and uploaded onto the website until a schedule change is approved SUMMARY PAGE DISTRICT FREDERICKSBURG PROJECT NUMBER 000
77. gnal heads Temporary Signals input no of new and modified intersections on the Signals Tab a Additional Utility input items on UTIL worksheet Services 54000 Pavement Marking 56000 Lighting lights poles foundations electrical service conduit trenching electronics 70000 Misc Enter data info on RW worksheet All misc clearing demo items not Demolition Clearing If applicable to RW covered by RW 32 PCES Version 3 1 User Manual Date 4 9 14 Items Automatically Included Excluded Items costs must be in Lane Mile Cost or added on CONST MISC Description Calculated by PCES worksheet e Watch for excessive item quantities 53 PCES User Manual N S Dismantling amp remove exist Structure 67900 BRIDGE COSTS 3 28 07 Bridge SF Cost Pre cast and cast in place concrete non repair deck grooving temporary structures expansion material demolition disposal of existing bridges input length width complexity and length width of bridge demo on Bridge worksheet Structure excavation Piling steel or pre cast A 3 concrete re bar plain or epoxy standard beams of steel or pre cast joint work standard railings A 4 concrete deck drainage Removal and disposal of all bridge elements to include deck piers abutments working over land including type B structures 54 Version 3 1 Date 4 9 14 Excluded Items costs must be added on MISC COST as applicable for e
78. icking the arrow A collapsed section will display a downward pointing arrow This functionality allows the user to show or hide each section 13 PCES User Manual Virginia Department of Transportation A We keep Virg se oject Search Project Summary UPC Description State Project Estimates 52338 0064 002 FO7 _ Feedback User s Guide About Y Expand All Collapse All RTE 64 UPGRADE SEWER SYSTEM PE ONLY WB REST AREA Wl Estimate History fy Download Blank Estimate Upload Estimate wW Select Estimate Split Estimate Type Date Pre Scoping Scoping PFI PH FI RAA Final Submission Award Expenditures 3 17 2004 TRNS PORT Estimates Date Constr Total Constr Contingency Bridge Total Bridge Contingency CEl Road CEl Bridge Total Pending Approval lil Approval History Type No Records Date Estimate Supporting Documents PD 1 Fundings and Authorizations 5 27 2005 John Giometti Author Version 2 10 254 000 0 PE RW CN Total O 3 500 000 3 754 000 P P z T P P P 29 656 0 0 29 656 Date 1147 2006 RW Acquisition 60 000 RW Relocation 0 RW Utility 0 Cons Utility 0 Total 60 000 Copyright 2006 Virginia Department of Transportation All Rights Reserved Figure 14 Show Hide functionality 14 Project Cost Estimating System v2 4 Version 3 1 Date 4 9 14 Expanded Collapsed PCES Version 3 1 User Manual
79. iew Insert Format Tools Data Window Help Ty faved eve AAA ner 334 4 T A SS 8 he Reply with Changes End Review ci_four_lane_mi fe 1 o Ey PCES Draft Length of Four Lane Improwements sss Enter the Total Length in Miles of Four Lane E rier i Improvements to be constructed This Figure Total Length Adding or Building Two Lanes mi w should include any location where Four lanes are being added to an existing roadway Total Length Adding or Building Four Lanes mi r Total Length Building Ramps and Loops mi __ M 4 WS DRAFT SUMMARY CONST Y CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS Total Length Adding or Building Ramps and Loops mi This field is for the project manager designer to enter the length in miles of ramps and loops to be constructed ES Microsoft Excel File Edit View Insert Format Tools Data window Help ee 1313 11 15 see eee eee a oe Arial Narrow Se ial id EE ee O EA Dal e Reply with Changes End Review ci loops ram de 1 2h PCES Draft Length of Ramps and Loops 2 Enter the Total Length in Miles of N ade Pee aL Ramps and Loops to be Total Length Adding or Building Two Lanes mi w constructed Mote This figure should NOT include any turning Total Length Adding or Building Four Lanes mi auxillary lanes which are accounted For elsewhere Total Length Building R
80. ion excessive select minor structure pipe excavation material borrow box geotextile fabric select and culverts excavation bedding backfill material grading concrete steel etc Class 20 bedding aggregate and erosion concrete reinforcing steel A3 control stone moderate shoulder concrete elliptical pipe piping and widening drop inlets associated work gt 60 dia and underdrains drainage storm sewer work drop inlets piping associated work lt 60 dia manholes paved ditches and manholes paved ditches on underdrains etc on rural projects urban projects 10000 Asphalt Paving aggregates sealcoating liquid overlay aggregate and asphalt not asphalt and asphalt concrete full full depth paving and depth pavement items only planing milling 11000 Concrete Paving entrances urban projects only bridge approach slabs reinforcing saw cutting shot blasting 13000 Incidental Items Guardrail in excess of 5 of project length and impact attenuators permanent concrete barriers retaining walls soundwalls detectable warning surfaces ee removal of concrete sidewalk curb gutter and paving items fencing bracing gates allaying dust barricades signs detours law enforcement aggregate channelizing devices assistance arrows flagging barrier service truck mounted attenuators warning lights Demolition and obscuring roadway pavement Adjustments demo guardrail removal and reus
81. ly with Changes End Rewiew cLraised me e EN PCES Draft Enter Length of Raised Median IF prompted For input text at left Length Sidewalk Left PLUS Right Side ft enter the Total Length of the Raised Median in Feet For the Project Total Length Raised Median t 1 Number of Right Turn Lanes Left PLUS Right Side gt Moa Ft DRAFT 4 SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS 17 PCES Version 3 1 User Manual Date 4 9 14 Number of Right Turn Lanes Left Plus Right Side The project manager designer is to enter the total number of right turn lanes on both sides of the mainline including right turn lanes on connections Do not include turn lanes associated with crossovers unless the project includes new turn lanes at an existing crossover ES Microsoft Excel i File Edit view Insert Format Tools Data Window Help OF PEIE FAA AI 00 02M aval Narrow r Ya iy wy 1 2 Ba Reply with Changes End Review ci_rt turn_lan fe 1 E PCES Draft Enter Number of Right Turn Lanes Enter the Number of Right Turn Lanes to be provided on the Project Include RTL s Total Length Raised Median ft e on both sides of the Mainline and on all Connections Number of Right Turn Lanes Left PLUS Right Side 1 J gt Number of Left Turn Lanes Undivided Only i E M 4 gt AA DRAFT Z SUMMARY CONST CONST 1 CONST 2 CONST MISC
82. mit the list by use of filter or search criteria The initial page of PCES is the Project Search screen From here you can locate any project within the system using the filters and search criteria at the top of the page The search results show the information about the State Project number Description Route UPC District Project Manager and estimate source The project filters include the standard District Counties Residencies Cities Towns Road System project status projects and roles The system also has filters by Project and Role Table 1 Projects status filters options In addition the project list can be reduced down using the Projects Roles filters PCES Version 3 1 User Manual Date 4 9 14 Table 2 Roles filter options All Roles All Roles Projects where you are the individual assigned to approve an estimate Project Manager Projects where you are the assigned Project Manager PM Projects where you are a contact The search criteria include Route State project number UPC Code UPC is the identification number that the FMSII system assigns to projects This number is used across the enterprise to identify projects It is unique to the project and will never be assigned to any other project Description Project Manager Estimate Source All e Figure 2 PCES Search Criteria You may search by Route number State Project number or UPC code by entering data in the appropriate fields and pr
83. mn 7 Percent VDOT This column allows the user to enter a percentage of the cost that will be charged to the project The user is to manually enter the percentage The costs will be charged to either Right of Way or Construction depending on the selection in Column 2 Costs for a particular row cannot be split between Right of Way and Construction Default percentage is 100 El Microsoft Excel Test PCES Project Read Only AE B File Edit wiew Insert Format Tools Data Window Help xj ui pot vdot by sl Po Entry Required Humber of Poles Rural or Urban Percent OOT 0 of of This Item to DOT Proj Choose Enter the Percentage of the Cost E of This Item which will be paid For by WOOT under Right of Way Project or Construction Project Costs the pa remainder to be paid by the Utility M14 gt pi SUMMARY CONST Z BRIDGE RW UTIL COMMENTS Company Municipality etc Ready NUM ft 44 PCES Version 3 1 User Manual Date 4 9 14 Column 8 Total Cost This is the total cost automatically computed based on data entered for each individual utility row A sub total is computed for each type of utility 1 e electrical transmission A total cost of all sub totals will automatically be computed for each utility section such as electrical CATV telephone etc Et Microsoft Excel Test PCES Project B File Edit wiew Insert Format Tools Data Window Help le x
84. n Bar The PCES Project Estimates Screen has an application bar located just below the VDOT logo to indicate to the user the current application PCES Clicking on any other application button will navigate the user to the application selected Search Bar le Project Search Figure 12 Project Details Screen Search Bar The search bar contains an area for Project Search and UPC By clicking on Project Search the user is taken to the Initial PCES Project Screen see Initial Screen page 5 where a more detailed search may be performed Users can perform a UPC search from the Project Details screen by entering the UPC and click the small arrow to the right of the field Project Details Tab The project details are divided into two screens Project Information Project Estimates Use the tabs at the top of the page under the PCES tab to navigate between these screens Project Project Information Estimates Figure 13 Project Details Tabs Common to all screens accessed by the Project Details Tabs are the Project Summary and the Show Hide Feature Show Hide Section details The default view of each section is in the expanded view to show all details as indicated by the upward pointing arrow ki to the right of all blue section title bars 12 PCES Version 3 1 User Manual Date 4 9 14 The user may expand or collapse all sections by clicking on Mi Each section may be collapsed or again expanded by cl
85. n End Year Validation message was added to the Summary worksheet 63 PCES User Manual Version 3 1 Date 4 9 14 Appendix H Summary of Changes from Version 2 53 to 2 6 PCES v 2 6 CHANGES TO THE WORKBOOK 1 Version name changed from 2 53 to 2 6 2 All lane mile bridge square foot traffic signal curb and gutter median sidewalk crossover turn lane utilities and other related cost tables have been updated 3 The following District Cost Factors changed a b Bristol from 85 to 90 Lynchburg from 90 to 1 0 Hampton Roads from 1 2 to 1 25 Culpeper from 1 0 to 1 1 Staunton from 1 0 to 95 Northern Virginia from 1 05 to 1 2 4 Inflation factors were updated 64 PCES Version 3 1 User Manual Date 4 9 14 Appendix I Summary of Changes from Version 2 6 to 2 61 PCES v 2 61 CHANGES TO THE WORKBOOK 1 Version name changed from 2 6 to 2 61 2 Added Traffic Tab worksheet 3 Eliminated New and Modified signal boxes from Construction 1 65 PCES Version 3 1 User Manual Date 4 9 14 Appendix J Summary of Changes from Version 2 61 to 2 62 PCES v 2 62 CHANGES TO THE WORKBOOK 1 Version name changed from 2 61 to 2 62 2 Due to the current bidding climate reduction in costs for numerous bid items the 4 2 inflation for projected for FY2010 has not been absorbed into PCES construction value The summary of changes to each estimate phase from v2 61 to v2 62 is as follows PE Estimate A PCES
86. n contained in PCES is intentionally and PCES Version 3 1 User Manual Date 4 9 14 specifically limited to VDOT employees and local government employees and representatives granted access to the system by VDOT A Use of the system implies that the user will safeguard the information to the Wa A 2 advantage of VDOT and its local government partners PCES Assistance The Scheduling amp Contract Division is responsible for maintaining and updating PCES Comments questions regarding the utilization and performance of PCES may be addressed to Corey Bourne at 804 786 2538 Local government users with access problems may call the IT Help Desk at 1 866 637 8482 for assistance User Access and Rights Any person listed with an e mail address on VDOT s intranet should be able to access PCES VDOT users may access the system via the VDOT intranet at http isyp scoping ces search asp Local government users may access the system via an external access portal at https ss vpn vita virginia gov vdot Access by local government users requires issuance of a user name and password by VDOT s Information Technology Division each time the user accesses the system To enter upload approve or change project information in PCES a training class must be attended by the user prior to being granted additional user rights These users are either assigned as project managers on specific projects and or assigned a
87. n or historic unit costs Directions are provided on the following pages for each method Because the worksheet has a similar set up for each type of utility it will be easier to describe what is expected for each column vertical Any exceptions to this approach will be described in more detail Ed Microsoft Excel Test PCES Project 1697 File Edit View Insert Format Tools Data Window Help ui funding so Computed Aw or Mo Entry Number Rural Percent Total to RW to Const or User Const Required of Poles or Urban DOT Cost Project Project 22 500 0 0 E E O 41 PCES Version 3 1 User Manual Date 4 9 14 Column 1 Computed or User Two methods of developing a cost are available Computed and User The user is to select how they want this particular utility cost computed by selecting the appropriate choice from the drop down menu To give the user more latitude this worksheet has been developed to allow the user to use both methods of computing costs in the same utility section For example the user may elect to use the Computed cost for wooden electrical transmission poles and the User El Microsoft Excel Test PCES Project Read Only ae EN File Edit View Insert Format Tools Data Window Help l x ui_cost_defini A ELEC TRICAL Computed or User Defined Costs al w i Transmission Select the method of Unit Cost Definition Computed RY or Type For this
88. nual and RUMS PCES data source gathers data entered into the latest PCES workbook Manual will collect the data from the Manual worksheet on PCES The last source RUMS gathers data from the RUMS program ES Microsoft Excel E File Edit view Insert Format Tools Data window Help DAA A ALO _select_rw_e fe RUMS E PCES Draft MANILAL Moa AA DRAFT b SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS When using TRNS PORT or RUMS as the estimate source please allow 24 48 hours for this information to be backed up by the Data Warehouse The date shown under the data source blocks 1s the current date not the date in which the estimate data was entered and uploaded The actual date of the estimate upload can be found on either the PCES website or in the project data history window PCES Version 3 1 User Manual Date 4 9 14 E Microsoft Excel File A AAA meee ee Aes EP Mr Mur EEF ey A E Da F Reply with Changes End Review select pee PCES E PCES Draft Edit view Insert Format Tools Data Window Help Arial Preliminary Engineering Estimate Construction Estimate Right of Way Estimate Utilities Estimate PCES DATE 2 15 2007 Moa gt WA DRAFT SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS The estimate values at the bottom of the summary sh
89. on cost estimate Before selecting TRNS PORT make sure that all portions of the estimate have been included ie bridge drainage traffic etc and a prime project identifier has been created for the project PCES estimates should not be forced to match TRNS PORT figures Final submission cost estimates should always be based on the fully detailed TRNS PORT construction estimate If there is a wide gap in the cost figures between PCES and TRNS PORT before advertisement the PM should determine and document the reason for the variance and adjust his her recommended project estimate accordingly When TRNS PORT and or RUMS are selected as estimate source PCES data will still be accessible but overridden It is critical to VDOT s project management program that the PCES program is fully understood and utilized thoroughly and correctly PCES is not a complementary or supplementary program Rather it is an integral component VDOT s project management program providing a central repository of project cost data for budgeting and funding purposes as well as tracking projects and managing information needed for an efficient and cost effective construction program Sensitive and Confidential Information All PCES program rights as well as the data contained within and linked to and are the exclusive property of VDOT In addition due to the sensitive and confidential budgetary and cost estimate information contained in PCES access to the informatio
90. on the PCES Summary worksheet It is used to determine the inflation for the project The ad date shown is the Fiscal Year the project will go to advertisement For projects with unscheduled construction the Project Manager should select an advertisement year based on funding and other applicable constraints This Ad Date will be used to determine the number years to inflate the construction estimate ES Microsoft Excel File Edit View Insert Format Tools Data Window Help AA EFEC EEN AAA Pe o Bt E ES ROS SA KAD kd ie E PCES_Draft E cu 7 buy m 00 il Y Reply with Changes Ad Date 2007 Design Year 2029 Moa gt FS DRAFT E SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS Project Terrain This feature allows the project manager designer to select the appropriate terrain for the project through a drop down menu In addition to the standard level flat rolling light mountainous and mountainous terrain options found in the Road Design Manual this feature includes gently rolling and light mountainous Rolling terrain is the base cost factor and will automatically default to this if no terrain is selected ES Microsoft Excel File Edit view Insert Format Tools Data Window Help BWA RE We he Be SRA E AI gt PEA EEES emer Br ue Be ME F A cl terrain fhe Ralling Pces_Draft e Fl a F Reply with Changes
91. one O Select One Addl Lane to add a Third Total Length Adding or Building Four Lanes mi e e Total Length Building Ramps and Loops mi i i Then Enter a Length for this Third Lane at gt MN DRAFT SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS J 9 Note Do not enter occasional turn lanes here Four Lanes Additional Lanes ES Microsoft Excel File Edit View Insert Format Tools Data Window Help Type a qui IA ENE AU EF AAA IAN a Mo Ma ee MEMES Y ci four lane v fe None i Arial Narrow 5E pi HJA z 0 1 Pa Reply with Changes End Review eh PCES Draft Number of Additional Lanes on Four Lane Improvements Only Total Length Adding or Building Two Lanes mi ____ select the Number of Lanes to add to the Four Lane Roadway described at left lt Total Length Adding or Building Four Lanes mi Noe M m Example For a Six Lane Roadway select Total Length Building Ramps and Loops mi oOneAdd Lane _ Two Add Lanes M gt N DRAFT Z SUMMARY CONST CONST 1 CONST 2 Z consT misc Wo Adal Lanes Then Enter a Lenath for these Lanes at right Four Add Lanes Do not enter turn lanes here 13 PCES Version 3 1 User Manual Date 4 9 14 Ramps amp Loops Additional Lanes i File Edit View Insert Format Tools Data Window Help AAA AGA ZA AAA dd 174 1 4 ci_loop_ramp fe None Arial Narr
92. ow AD S A j Y Reply with Changes End Review 5 PCES Draft Number of Additional Lanes on Ramps amp Loops Only Total Length Adding or Building Two Lanes mi Si select One Addi Lane to add a Second Lane to the Ramp s or Loop s Total Length Adding or Building Four Lanes mi __ described at left lt Total Length Building Ramps and Loops mi None r ee E a M 4 gt MN DRAFT Z SUMMARY CONST CONST 1 CONST 2 CONST MISC j A A Note Do not enter occasional turn lanes here Shoulder or Curb amp Gutter Select C amp G This feature prompts the project manager designer to select whether this project is utilizing curb amp gutter or shoulder on any of the project If project is rural but has some curb amp gutter populate the length of curb and gutter in the field below to incorporate this cost into your estimate ES Microsoft Excel File Edit View Insert Format Tools Data Window Help T ra S oo Ze cl_shoulder_o dE SH PCES Draft Select Curb Gutter Option _ A A SRA TF you are prompted to make a ae E selection text at left choose Total Length Building Ramps and Loops mi w E S For Shoulders or d Shoulder or Curb amp Gutter Select 5 or C amp G u g Enter Lane Width gt o Ch for Curb and Gutter on all applicable Urban Projects Median Type Graded Raised or N lormal Lane Width ft ra
93. penditures 12 8 2006 FMS 1 770 430 0 44 248 234 46 013 664 The type of estimate selected is defined by the concurrent engineering process Figure 28 Project Estimates Estimates PCES Estimates List Teee Type of estimate Drac coles Date estimate was uploaded into the system Author occccc Name the individual uploading the estimate PE n A dollar amount representing the Preliminary Engineering amount needed for the project Version ossos PCES version or system previous to PCES POAN riere A dollar amount representing the Right of Way amount needed to complete the project 6 eee eee A dollar amount representing the Construction amount needed to complete the project Totales A dollar amount representing the total PE RW and CN amounts needed to complete the project 25 PCES User Manual Edit an Estimate Version 3 1 Date 4 9 14 You may edit an estimate by clicking on the Edit A form is displayed similar to the one below that enables the user to edit relevant information Edit Financial Plan Estimates PE Estimate 1270430 CN Esti mate 4401766 Figure 29 Edit Estimate Click L BAate to save changes or to cancel and close the window TRNS PORT Estimates Numbers in this section will not reflect TRNS PORT after the estimate is transferred to the Scheduling amp Contract Division control group Const Contingency Bridge Total Bridge Contingency CETRO dust CEI Bridge
94. rust the source do not open or save this file What s the risk Figure 7 Export to MS Excel Select Open Save or Cancel as appropriate Page Navigation Long lists of projects are broken up into pages to make it easier for the user to browse Below the project list is a paging control which will allow the user to navigate through the project result set PCES User Manual Hi lt lt Figure 8 Page Navigation 10 Version 3 1 Date 4 9 14 PCES Version 3 1 User Manual Date 4 9 14 Project Screen From the Project Search Results see page 6 select a project by moving the cursor over the project on the list project is highlighted and clicking on the row Esti mate Version State Project Description Route WFC Di Strict Project Mar Date Source Total Esti mate 00071 106 F07 RTE 1 4 L4HES WITH CURB 4001 4594 Richmond hiarvin Tart 112006 Award 3 S64 466 SUTTER amp SIDEWALK 006400 FO RTE 64 UPGRADE SEWER 0064 14656 Culpeper Jacob Porter T0068 2 10 Scoping 3 790 000 SYSTEM FE ONLY EB REST AREA A AS RTE64 UPGRADE SEWER TIGGE Eo 7 Culpeper John Doe A f 2 10 Scoping SYSTEM PE ONLY We REST Ww AREA 6029 1138 FO7 RTE 29 LNACEABURMmMab s0on 0029 11812 Lynchburg John Canile 11 29 2006 2 10 4 527 703 HEIGHTS BYPASS ROUTE 460 Expenditures INTREH Figure 9 Select Project The PCES Project Estimates screen displays with the Project Estimates Tab selected as a default Virginia Department of
95. ry etc ROU E sccscrcaccdarsavoccsess The Route number of the road where the project will take place This value is used in determining the state project number Road Name Street Name from Project Pool Start Location Description of the physical starting point for the project End Location Description of the physical end point for the project Length eee peene ero ee A measurement expressing the distance between the starting point From Location to the finish point To Location Miles Kilometers Feet Meters etc 17 PCES Version 3 1 User Manual Date 4 9 14 Status Project Status CONSTRUCTION STARTED Accomplishment MOT SPPLICABLE Ad Date Figure 19 Project Information Status Project Status ACTIVITY DATES SET NO DATES SET YET ADVERTISED NOT IN CURRENT SYP AWARDED PPTA PROJECT BUDGET ITEM ONLY PRELIMINARY WORK COMPLETED CLOSED CLAIMS PAID RAILROAD FORCE AUTHORIZATION CONSTRUCTION COMPLETED RW MONITORING ONLY CONSTRUCTION STARTED STORAGE INACTIVE FILE MICROFILMED STUDY ONLY INDEF DEFER DECISION TEMP DEFER DECISION MAINTENANCE ONLY TRAINING PROJECT ONLY MISC FUNDS MONITORING UNSCHEDULED CONSTRUCTION NEED PROG amp PLAN DIR ACTION ZEROED Accomplishment CAPITAL OUTLAY NOT APPLICABLE CITY CONTRACT RAILROAD FORCES CONTRACT REGIONAL CONTRACT COUNTIES DEVELOPERS ETC SAAP CONTRACT DESIGN BUILD STATE FORCES HIRED EQUIPMENT DISTRICT CONTRACT WORKORDER HIRE
96. s in excess of 60 inches in diameter This includes drainage structures requiring a separate project number 1 e D 601 These costs should include pay items associated with the drainage structure i e bedding material minor structure excavation endwalls headwalls etc The project manager designer should communicate with the drainage engineer designer to collect any additional and unusual drainage costs Good engineering judgment is to be used in determining if drainage costs should be included in the per mile roadway cost or added to the Large Drainage Structures lump sum cost Documentation of large drainage costs should be 18 PCES Version 3 1 User Manual Date 4 9 14 addressed on the Comments worksheet or uploaded to the PCES website as supporting documentation This is captured under the Misc Const tab In Plan Utility Costs In plan utility costs can be captured and shown on the Construction worksheet two ways The first is to have the utility engineer complete the Utilities worksheet in PCES PCES should be the data source selected on the Summary worksheet The other is to select RUMS on the Summary worksheet as the data source if Right of Way estimate has been completed and entered into RUMS ES Microsoft Excel 3 File Edit View Insert Format Tools Data Window Help AAA AAA PF 7 ey TE d 03 F Reply with Changes End Review cf large drain fe ETA Arial Narrow In Plan Utility Costs Enter
97. select it 2 Select the Estimate Type Pre scoping PH Final Submission Scoping Fl FFI Rv 3 Click the to upload the worksheet or cancel to cancel and close the window 4 After uploading an estimate the user will encounter the following status window asking the user whether to Recommend this Estimate Upload Supporting Docs and finally Finish 21 PCES Version 3 1 User Manual Date 4 9 14 Upload Status Uploaded Estimate Richrnond_00000000001 5958 13 Version 24 Esti mate Type PFI Result SUCCESS Estimate Details FE Rey CH Total 1 554 376 566 200 3 762 844 5 903 417 Recommend this Estimate Upload Supporting Docs Figure 25 Estimate Upload Status window 5 If Recommend this Estimate is selected a Revision Detail screen will be displayed and the user will be asked to provide comments and answer questions prior to submitting the revision 22 PCES Version 3 1 User Manual Date 4 9 14 Select Estimate Clicking the Select Estimate button will open form to select a Recommended Estimate A Select Recommended Estimate Windows Internet Explorer Select Recommended Estimate Aulhor Fara CH Nicholas 8 52 010 000 2 410 000 Deborah Mangiaracina 30 240 000 300 000 Final Submission 4 23 2009 Deborah Mangiaracina 2 61 20 000 0 238 751 Award 1 11 2011 Annette Adams AWARD 9 851 0 445 001 Expenditures 212112012 8 851 50 434 670 Figure 26 Select Recommended Estimate 1
98. ssovers needed for the project This cost is averaging the cost of two left turn lanes plus the cost of the crossover The left turn lanes on a cross over are not to be included as normal left turn lanes in the workbook ES Microsoft Excel File Edit View Insert Format Tools Data Window Help T E Ada a ee po da Xx Ea ae a ft a E Arial Narrow 33 6541 ly Da F Reply with Changes End Review ci crossover fe 1 Enter Number of Crossovers IF you are prompted to enter data text at left enter the Number of Crossovers to be provided on the Shoulder or Curb amp Gutter Select or C amp G A Enter Lane Width gt Project Mote This worksheet adds Median Type Graded Raised or None ea dormal Lane Width ft Baul the cost of two left turn lanes For each crossover specified here Number of Crossovers Divided Highways ONLY 1 1 Moa eo WH DRAFT SUMMARY CONST 5 CONST 1 7 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS EH PCES Draft Length of curb amp gutter Left Plus Right Side Ft This field should include the total C amp G or curbing on both sides of the roadway Cost for curb amp gutter includes average storm sewer system costs and urban design entrances This length is to be shown in feet ES Microsoft Excel File Edit view Insert Format Tools Data Window Help Type m ME En m ag ak dk uA Wj fe aaa Arial Marrow
99. sts of a drop down menu for a particular type or size and the menu choices vary depending on the utility The user is to select the most appropriate choice El Microsoft Excel Test PCES Project Read Only ai olx 7 File Edit View Insert Format Tools Data Window Help gt xj ui pole type Computed AW or Tape Mo Entry N Percent Total to RW or User Const ot Pole Required of DOT Cost Project A E a ee ConciSteal Item Description For E H wond EA this line of input From ee a a D PO a 100 fi a Other H H CIC UTIL Ready EE a TT e Column 4 Cost per Unit This column will only allow the user to enter a unit cost when User 1s selected The header for this column will change from No Entry Required to Loaded per Depending on the unit for that utility Unit cost should be based on historic data or good judgment Ed Microsoft Excel Test PCES Project Read Only A ES B File Edit View Insert Format Tools Data Window Help x ui loaded uni m Computed AW or Tape Percent Total to RW or User Const ot Pole DOT Cost Project User w 100 0 q Computed RW 100 0 0 Computed RW e 100 0 0 Computed Ril 100 0 0 OO Cost here 30 a Wd SUMMARY 4 CONST BRIDGE UTIL COMMENTS Ready m NUM 2 Column 5 Unit Total The user is to enter to the total number of units in this column Ed Microsoft Excel Test PCES Project Read Only 6
100. summary page of the workbook Inflation Rate The number reported in this field will be the compound inflation rate to the advertisement year this will be the same as reported in the summary page of the workbook Estimate in Mid FY year This field will report the estimate in the year of advertisement 22 PCES Version 3 1 User Manual Date 4 9 14 Signals ITS Signs and Lighting Cost Worksheet a SIGNALS ITS SIGNS and LIGHTING COST WORKSHEET fueros New Tee vom 2 soup a eat 3 wes 4 tam os vas sama 10 3 AAA AAA MS ay 4p 8 42 5 8 13 A A E E 7l ls H 4 bl DRAFT 3 n a 3 E Sianals Con sturio Subtotal SUMMARY CONST CONST 1 CONST 2 CONST MISC TRAFFIC BRIDGE RW UTIL COMMEN toa MANUAL Fs Users can input multiple locations as well as multiple types of signals with new or modified equipment The worksheet also has costs for New and Modified Temporary Signals i MAJOR SIGN STRUCTURES N MN IN Signs Construction Subtotal Users can enter lump sum cost for ITS Large signs such as Bridge Mount and Overhead signs are inputted on this screen 23 PCES Version 3 1 User Manual Date 4 9 14 me A Ve N 3 ee P O S S O E S E E N a i Signs Construction Subtotal Conventional Lighting Construction Subtotal 471 716 Lighting costs are captured here Bridge Worksheet PCES version 3 1 allows for the project manager designer
101. t before the close of business on the previous day Pending Approval Pending Approval is used by localities to upload estimates for VDOT review and approval Pending Approval mi Approwal History Type Date Anthor Status PE En CH Total Mo Records Figure 31 Pending Approval Upload Status Uploaded Esti mate Richrnond_00000000001 5988 13 Version 24 Esti mate Type PFI Result SUCCESS Estimate Details FE Rey CH Total 1 554 376 586 200 3 762 644 5 903 417 Recommend this Estimate Upload Supporting Docs Figure 32 Locality Estimate Upload Status window 1 After uploading an estimate the user will encounter the following status window asking the user whether to Recommend this Estimate Upload Supporting Docs and finally Finish If the upload was successful the Result should display Success Estimate Supporting Documents This is a repository of documents quotations independent estimates notes etc to support estimates 27 PCES Version 3 1 User Manual Date 4 9 14 Estimate Supporting Documents Upload Document Name Description Mo Estimate Documents Figure 33 Estimate Supporting Documents 1 Click 5 Upload Document an upload form similar to the one below opens Document Upload Category select One Phase select One Status Select One Description Figure 34 Document Upload 2 Click Browse navigate to the location of the appropriate document and sel
102. ting the cost Project amp UPC numbers Automatically provided based on project information from another system VDOT Construction District Automatically provided based on project information from another system Ed Microsoft Excel Test PCES Project Read Only i 5 xj B File Edit View Insert Format Tools Data Window Help _ gt xj Project amp PPMS Numbers 28030707 VDOT Construction District CULPEPER 7 gt M4 e SUMMARY CONST 4 BRIDGE ARW UTIL 4 COMMENTS Ready MA Si a Select Project Area Real Estate Costs The user has seven options from which to choose the most appropriate real estate cost These options are very low well below average somewhat below average average somewhat above average well above average very high The user 1s to select the option that best fits the overall cost for their particular district and project location a2 PCES Version 3 1 User Manual Date 4 9 14 Ed Microsoft Excel Test PCES Project Read Only 1647 File Edit View Insert Format Tools Data Window Help ri real estate y Select Project Area Real Estate Costs Define Project Land Use Characteristics Select the Most Accurate Well Below Average Description of the Real Somewhat Below Average Estate Gack ortho Instructions Please fillin all applicable White Boxes Average Immediate Project rea vs or make a choice from the Drop down Lists somewhat Above Average the Average For the entire well Abov
103. tion and reference purposes ROUE susto laos The Route number of the road where the project will take place This value 1s used in determining the state project number PPP The identification numbers the FMSII system assigns to projects This number is used across the enterprise to identify projects It is unique to the project and will never be assigned to any other project Discos The primary construction district responsible for a project Project Mgr The person named to be responsible for the management of the project Estimate Date Date estimate was selected Version Source PCES version or system previous to PCES Total Estimate A dollar amount representing the total PE RW and CN amounts needed to complete the project A Total Estimate numbers in RED indicate the project estimate needs immediate attention The project expenditures exceed the recommended estimate for PE Warning RW or CN totals or the project has a zero estimate You may export the results of the search to MS Excel by clicking on ii to the right of the search bar A dialog box similar to the one below will appear File Download Do you want to open or save this file Mame ces search xls Hl Type Microsoft Excel Worksheet 9 00 KB From isyp Always ask before opening this type of file While files from the Internet can be useful some files can potentially harm your computer Ifyou do not t
104. to enter data in the Bridge worksheet for up to twenty four 24 separate bridges A square foot cost has been developed based on closed out projects In addition to the square foot cost the district location and construction complexity applies a cost factor in determining the final construction cost of the proposed bridge Proposed Bridge Information Length ft Length of proposed bridge 1s to be entered in this field Unit of measurement is feet 24 PCES Version 3 1 User Manual Date 4 9 14 Enter the Length of the Bridge Enter the Length in feet BRIDGE BRIDGE CONSTRUCTION PE Proposed BRIDGE 1 Length ft Bridge Job Width ft Complexity Type of New Bridge C M WEB or SRO Federal Structure ID Bike Pedestrian Path Width Lf Bike Pedestrian Type mm PED CE ma PED PE Bike Pedestrian Bridge Area Sq Ft A _ Sr Br Misc Cost for Bike Pedestrian facility eae PE Removal of Existing Structure 1 a Length of Existing Structure ft rm Misc F E Bridge 1 Width of Existing Structure ft 70 783 OOo Misc Cost Bridge 1 Constr Br 1 PE Bridge 1 1 229 009 152 326 Constr Bike Ped 1 986 309 Width ft Width of proposed bridge is to be entered in this field Unit of measurement is feet Width of proposed Bike Pedestrian facility entered in measurement of feet Bike Pedestrian Type and total square feet 25 PCES Version 3 1 User Manual D
105. truction estimate based on the total of the bid items plus the contingency in TRNS PORT usually 10 The Construction Engineering estimate CEI will come in from your TRNS PORT estimate This can be a of Construction or a Lump Sum ES Microsoft Excel 2 File Edit View Insert Format Tools Data Window Help Oem BERENE MORA A E E Ae _select_cn_e fm PCES E PCES_Draft Preliminary Engineering Estimate PCES Construction Estimate Right of Way Estim TRHS PORT Utilities Estimate PCES Ho 4 e WS DRAFT SUMMARY CONST f CONST 1 CONST 2 f CONST MISC BRIDGE RW UTIL COMMENTS The Right of Way estimate is selected from three data sources PCES Manual and RUMS PCES data source gathers data entered into the Right of Way PCES workbook Manual will collect the data from the Manual worksheet on PCES The last source RUMS gathers data from the RUMS program PCES Version 3 1 User Manual Date 4 9 14 ES Microsoft Excel 3 File Edit View Insert Format Tools Data Window Help RWS a We We ite MEW A AA is select pve SH PCES Draft Utilities Estim 44 e DRAFT SUMMARY CONST CONST 1 CONST 2 CONST MISC BRIDGE RW UTIL COMMENTS When using TRNS PORT or RUMS as the estimate source please allow 24 48 hours for this information to be backed up by the Data Warehouse The Utilities estimate 1s selected from three data sources PCES Ma
106. uted by PCES is based on a percentage of the construction cost associated with the Construction PE worksheet Project manager designer should review this percentage for accuracy and take into consideration P E expenditures to date FMS ID and any unusual design work needed and will be charged to preliminary engineering Again good engineering judgment should be applied and documentation provided on the Comments worksheet or uploaded to the PCES website as supporting documentation Ed Microsoft Excel File Edit view Insert Format Tools Data Window Help Ty OA enn ae ERC ee Oo Arial Narrow Sa Ea Y Reply with Changes End Review EEP Mu ee A ci extra pe e Fe Ey PCES Draft Additional Unusual P E Costs Enter the Cost fin s of Unusual eee aa F E Costs that do not vary directly Additional or Unusual P E Costs Eb with the Construction Estimate eh ae including all Special Environmental Select of PE to be performed by Consultants PE Cost Studies Phase I or II Arch Hazmat ea l laa IA l etc and the cost of all P E Note Do Not Include Bridge P E Costs Here Roadway F E Roadway Const 19 7 Consultant Services anticipated Moa e WO DRAFT Z SUMMARY CONST 5 CONST 1 CONST 2 Z CONST MISC BRIDGE RW UTIL COMMENTS l 20 PCES Version 3 1 User Manual Date 4 9 14 Select of P E to be performed by Consultants Project manager designer shall determine the p
107. w Insert Format Tools Data Window Help xj ri comments y Based on Approved Unapproved Flans IO Participating Cost Non Partcipating Cost tc tC eC A LS SUMMARY RW UTIL 4 COMMENTS Ready E Jr 0 E 40 PCES Version 3 1 User Manual Date 4 9 14 Utilities Worksheet The purpose for the Utilities worksheet is to allow the user to create a utilities estimate for the utilities being impacted or having anticipated impacts The worksheet has been created to allow the user to enter data for typical utilities impacted by projects Unusual utility costs should be manually entered into the worksheet in the miscellaneous boxes at the bottom of the appropriate utility 1 e electric telephone CATV water sanitary sewer natural gas propane and petroleum and in the correct box related to the costs construction vs Right of Way charges with the exceptions being Cellular and Additional Costs Cellular and Additional Costs are to be entered as lump sum cost as they relate to the project It is recommended the user provide documentation of the unusual utility costs on the Comments worksheet Utility data can be entered two ways in the PCES The first avenue is to use the Computed Costs in the system This method uses pre determined unit costs based on data entered into the worksheet The other method is to use User Defined Costs This method allows the user to enter the unit costs based on know
108. y worksheet and utility cost for construction will populate the in plan utilities field in the construction worksheet 46 PCES Version 3 1 User Manual Date 4 9 14 Ed Microsoft Excel Culpeper_000000000018897 B File Edit View Insert Format Tools Data Window Help _ e x ui_pct_vdot_b X v TOTAL UTILITY COST RIGHT OF WAY PROJECT TOTAL UTILITY COST CONSTRUCTION PROJECT TOTAL UTILITY COST UTILITY OW HER OTHERS GRAND TOTAL UTILITY COSTS M4 bi SUMMARY 4 CONST BRIDGE 4 RW UTIL Edit 14 gt l Do e 0 E NN 47 PCES Version 3 1 User Manual Date 4 9 14 Comment Sheet The comment sheet is provided for the users to provide documentation for any project related comments estimate revision notes comments related to unusual cost large drainage structures project descriptions right of way and utility cost notes Anyone entering comments are requested to enter their name and section and the date entered so anyone viewing the workbook will see who provided the comments and when the comments were entered Ed Microsoft Excel Test PCES Project Read Only o AE 1687 File Edit View Insert Format Tools Data Window Help comments_m T s cellaneous Co sake ents from Team it fe a er Date a W A UTILIT Wo si eae ti nte fll quantity add clearing for RAM amp high difficulty of MOT _ L ale Lbs SUMMARY CONST BRIDGE RW UTIL COMMENTS Ready E SS Ss ea a a

User Manual - Virginia Department of Transportation

Contents

Download Pdf Manuals

Related Search

Related Contents