Critical Tip: Cautions about changing the table - Respect the name and layout of the table. Do not add columns. Do not re-order the columns. Some macros in the workbook act on the AlterList table and changes to the table may have unexpected consequences. The goal is to achieve consistent practice in the details of how USACE accomplishes VE studies. Consistency will be important for future improvements in the USACE VE repository/VE Management System. Pre-Workshop Prepare VE Project Summary Workbook. The VEO shall provide a – copy of the Excel VE Project Summary Workbook to the VE Team Facilitator prior to the VE Workshop. Note: Verify that the version of the workbook provided is latest version as stored on the VE website. Verify that the workbook is a version. The VE Team Facilitator is responsible for setting up the workbook prior to the VE Workshop. This task includes populating the Project Information on the Data worksheet. Verify Rounding Factor under the Cost Data Presentation heading is correct. This data will be copied to all of the Alternative files when they are prepared. Workshop - Use of VE Project Summary Workbook Creative Idea Listing View The VE Team selects the Value Target Areas (VTAs) to use during the Creative Idea Phase following the Function Analysis Phase. The first step is to enter the VTA information in the Data worksheet. Record the Value Target Areas Create abbreviations for each Value Target Area. They will be used in the Creative Idea / Alternative numbering. Tip: Use the VTA column provided should the Value Target Areas need to be sorted in a non-alpha manner. If the Creative Idea View was not set prior to the workshop, set it before beginning to list the Creative Ideas, see figure 1. This will display columns: Alter. No., Creative Idea Description, Comments / Notes. Also, set the worksheet title to OF CREATIVE IDEAS” using the “LIST drop down in Cell E2, see figure 17-5.
Critical Tip: Cautions about changing the table - Respect the name and layout of the table. Do not add columns. Do not re-order the columns. Some macros in the workbook act on the AlterList table and changes to the table may have unexpected consequences. The goal is to achieve consistent practice in the details of how USACE accomplishes VE studies. Consistency will be important for future improvements in the USACE VE repository/VE Management System. Pre-Workshop – Prepare VE Project Summary Workbook. The VEO shall provide a copy of the Excel VE Project Summary Workbook to the VE Team Facilitator prior to the VE Workshop. Note: Verify that the version of the workbook provided is latest version as stored on the VE website. Verify that the workbook is a version. The VE Team Facilitator is responsible for setting up the workbook prior to the VE Workshop. This task includes populating the Project Information on the Data worksheet. Verify Rounding Factor under the Cost Data Presentation heading is correct. This data will be copied to all of the Alternative files when they are prepared. Workshop - Use of VE Project Summary Workbook Creative Idea Listing View The VE Team selects the Value Target Areas (VTAs) to use during the Creative Idea Phase following the Function Analysis Phase. The first step is to enter the VTA information in the Data worksheet. Record the Value Target Areas Create abbreviations for each Value Target Area. They will be used in the Creative Idea / Alternative numbering. Tip: Use the VTA column provided should the Value Target Areas need to be sorted in a non-alpha manner. If the Creative Idea View was not set prior to the workshop, set it before beginning to list the Creative Ideas, see figure 1. This will display columns: Alter. No., Creative Idea Description, Comments / Notes. Also, set the worksheet title to “LIST OF CREATIVE IDEAS” using the drop down in Cell E2, see figure 17-5.