{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","User Instructions","Input Page","1. Planning","2. Programming","3. Prelim. Eng.","4. Final Eng.","5. Constr.","6. O&M","Review Result","Report","Default_Ref"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":17,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,6,1],[0,2,6,2]]}
["Project Bundling"]
["Saves Bundles!        ",null,null,"(Ctrl + PgDn)                                             First time users, go to the next tab for user instructions to navigate the self-assessment tool."]
[null,null,null,"(Ctrl + PgDn + PgDn)"]
["Agency Capability                          Self-Assessment Tool "]
[" A Capability Matrix"]
[" Every Day Counts | Innovation Initiative"]

{"sheet":"User Instructions","index":1,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,0,18,0],[1,1,35,1]]}
["              Instructions for Users for Self-Assessment","The contents of this tool do not necessarily reflect the official policy of the Department of Transportation. The contents do not have the force and effect of law and are not meant to bind the public in any way."]
[]
["Organizational Capability Background"]
["This Federal Highway Administration (FHWA) tool is designed for an agency to assess its current project bundling practices, to inform users of the range of bundling practices used by others, to identify practices and action steps for improvement, and to evaluate practices being used on a bundling project or program. It uses the organizational capability approach where capability is defined as the level to which an organization has institutionalized its policies, processes, and procedures, documenting them so that they can be consistently applied across the agency."]
["Therefore, it is important to understand that a low capability score is merely a sign that the agency's practices may not be properly institutionalized and as a result may be inconsistent in their application. Inconsistency leads to uncertainty and uncertainty costs time and money as both internal stakeholders and the agency's design and construction industry partners struggle with determining exactly when a given bundled project will be developed and delivered."]
["This tool provides a structured format in which to conduct an organizational capability assessment workshop. The agency will relate its own practices to a set of effective practices that was developed from a national study of project bundling. Some of those may not directly apply to the agency and the tool will allow the agency to eliminate those from the assessment. However, it is recommended that a discussion of why a specific practice does not apply occur before dropping it from the analysis to ensure that there is a strong justification for doing so, such as lack of enabling legislation."]
[]
["Detailed Instructions"]
["The tool consists of a series of worksheets (tabs) that carry the workshop participants through each step of the self-assessment. The process is started with the \"Input Page\" where the list of effective practices from Tables 2 through 7 in the FHWA Project Bundling Quick Start Reference are found. The participants are able to indicate which ones apply to the agency, as well as to identify those phases of the project development and delivery process where it would apply the given practice. This is then followed by a worksheet for each project phase where the participants will assess their capability using the given criteria. This is followed by a summary page that provides a consolidated picture of the final self-assessment. If desired, a button on the Results page can be clicked and it will generate a report that lists those practices where the agency could enhance its capability by taking action to better define and document those practices."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Input Page Instructions (see images to the right)"]
["Figure 1 is a screenshot from the Input tab and shows the first step in the self-assessment process. Two actions are required to start the process."]
["      1. Review each of the practices in the table and discuss its meaning in the agency's context. The definition of each practice is included as a comment and can be seen by hovering the cursor over the practice. "]
["     2. Once the participants have a consensus definition for each practice, indicate in the right column on the drop-down menu whether each practice applies to the agency. The first four are considered mandatory practices for an agency with a mature project bundling process."]
["Figure 2 is a screenshot from the Input Page and shows the second step in the self-assessment process.  It breaks out the project development and delivery process into six generic stages. The participants should consider each practice and check the stages in which it would be applied. Since projects are different, more than one stage can be checked. The operations and maintenance stage (O&M) is for bundled projects delivered using public-private partnerships (P3s)."]
["Figure 3 is a screenshot of capability definitions that will be used in the third step. Before moving on to the self-assessment ratings, the participants should discuss each of the capability levels and agree on how they will be applied in the subsequent worksheets."]
["Figure 4 is a screenshot of the Planning Stage Worksheet which will appear after clicking \"Next\" on the Input Page after completing the above steps. There is a similar \"Next\" button for each stage in the project development and delivery process."]
["The tool copies the practices from the input sheet into each stage worksheet based on the Step 2 input. On this sheet, the participants will discuss each practice shown and rate themselves by clicking on the capability cell and selecting a number from the drop-down menu"]
["When complete, click \"Next\" and move to the next stage until all stages have been rated."]
[]
["Results Page Instructions (see images to the right)"]
["Figure 5 is a screenshot of the Results Page. Organizational Capability Theory states that the organization's overall capability in each step is the lowest of all ratings. "]
["In the example at the right, practice 1 is rated at 1 overall, but the agency rated itself higher in the planning stage. In these cases the participants should first review whether the stages were checked and capabilities were scored correctly. If it is correct, then this practice may become an improvement action item for the future."]
["Figure 6 is a screenshot of the Bundling Organizational Capability Practices Report that is produced when the \"Bundling Organizational Capability Practices Report\" button is clicked. This report list those practices that the agency can consider including in future bundled projects as a means of improving their process and institutionalizing by developing appropriate implementation documents."]
["Final Capability Results "]
["The tool takes the rated capability for each practice and develops an overall capability rating based on the mode of all the practice ratings (most frequently observed value)."]

{"sheet":"Input Page","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,12]]}
["Self-Assessment Questionnaire Answer Sheet"]
["Basic Effective Bundling Practices Set"]
["Step 1 - Indicate if each practice is applicable for bundling in your agency (practices 1-4 are required, for practices 5-25 use pull-down menu to select yes or no if applicable to your agency).",null,null,"Step 2 - Select the project stage(s) in which the practice would be applied in your agency (the checked project stages should be adjusted to meet your agency practice stage).\nWhen completed press \"Populate\"  button below or Ctrl+Shift+R.",null,null,null,null,null,"Step 3 - Assign stage-specific capability levels in the next series of pages.\nTo complete press \"Next\" button on the right or Ctrl + Shift + P."]
[]
["Practice #          (Step 1)","Practice                                                                                                                   (Step 1)","Applicable? (Step 1)","Planning                (Step 2)","Programming (Step 2)","Prelim Engineering        (Step 2)","Final Engineering              (Step 2)","Construction (Step 2)","O&M Stage                (Step 2)","Capability Level Criteria"]
[1,{"$f":"VLOOKUP(A6,Default_Ref!A5:B30,2,FALSE)","v":"Early bundling decision during planning/programming"},"Required",true,true,false,false,false,false,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[{"$f":"A6+1","v":2},{"$f":"VLOOKUP(A7,Default_Ref!A6:B31,2,FALSE)","v":"Determine optimum bundle size"},"Required",false,true,true,true,false,false,1,"Not Implementing","The agency is not pursuing innovation anywhere and is not interested in pursuing innovation","Project bundling is not considered."]
[{"$f":"A7+1","v":3},{"$f":"VLOOKUP(A8,Default_Ref!A7:B32,2,FALSE)","v":"Limit bundle by work type"},"Required",false,true,true,true,false,false,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process.","No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[4,{"$f":"VLOOKUP(A9,Default_Ref!A8:B33,2,FALSE)","v":"Limit bundle by geographic proximity"},"Required",false,true,true,false,false,false,3,"Demonstration Stage","The agency is testing and piloting the innovation","Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[5,{"$f":"VLOOKUP(A10,Default_Ref!A9:B34,2,FALSE)","v":"Outreach - Industry"},"YES",false,true,true,false,false,false,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[6,{"$f":"VLOOKUP(A11,Default_Ref!A10:B35,2,FALSE)","v":"Outreach - stakeholders"},"YES",false,true,true,false,false,false,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and regularly uses it on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established and documented."]
[7,{"$f":"VLOOKUP(A12,Default_Ref!A11:B36,2,FALSE)","v":"Local partnering"},"YES",false,true,true,false,false,false,6,"Optimized","- not applicable - ","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[8,{"$f":"VLOOKUP(A13,Default_Ref!A12:B37,2,FALSE)","v":"Identify Federal-aid eligible work types "},"YES",true,true,true,true,false,false]
[9,{"$f":"VLOOKUP(A14,Default_Ref!A13:B38,2,FALSE)","v":"Use innovative finance"},"NO",false,false,false,false,false,false]
[10,{"$f":"VLOOKUP(A15,Default_Ref!A14:B39,2,FALSE)","v":"Use state funding only"},"YES",true,true,false,false,false,false]
[11,{"$f":"VLOOKUP(A16,Default_Ref!A15:B40,2,FALSE)","v":"Bundle to reduce number permit actions"},"YES",false,true,true,false,false,false]
[12,{"$f":"VLOOKUP(A17,Default_Ref!A16:B41,2,FALSE)","v":"Programmatic permit"},"NO",false,false,false,false,false,false]
[13,{"$f":"VLOOKUP(A18,Default_Ref!A17:B42,2,FALSE)","v":"Assign permitting tasks to industry"},"NO",false,false,false,false,false,false]
[14,{"$f":"VLOOKUP(A19,Default_Ref!A18:B43,2,FALSE)","v":"Consolidated utility agreement"},"YES",false,false,true,true,false,false]
[15,{"$f":"VLOOKUP(A20,Default_Ref!A19:B44,2,FALSE)","v":"Assign utility coordination to industry"},"NO",false,false,false,false,false,false]
[16,{"$f":"VLOOKUP(A21,Default_Ref!A20:B45,2,FALSE)","v":"Stage ROW acquisition sequence"},"YES",false,true,true,true,false,false]
[17,{"$f":"VLOOKUP(A22,Default_Ref!A21:B46,2,FALSE)","v":"Use IDIQ to stage ROW/permits/utilities"},"YES",false,false,true,true,false,false]
[18,{"$f":"VLOOKUP(A23,Default_Ref!A22:B47,2,FALSE)","v":"Assign ROW tasks to industry"},"YES",false,false,true,true,false,false]
[19,{"$f":"VLOOKUP(A24,Default_Ref!A23:B48,2,FALSE)","v":"Use ACM"},"YES",false,true,true,true,true,true]
[20,{"$f":"VLOOKUP(A25,Default_Ref!A24:B49,2,FALSE)","v":"Use ATC"},"YES",false,false,false,true,true,false]
[21,{"$f":"VLOOKUP(A26,Default_Ref!A25:B50,2,FALSE)","v":"Coordinate construction staging"},"YES",false,false,true,true,true,false]
[22,{"$f":"VLOOKUP(A27,Default_Ref!A26:B51,2,FALSE)","v":"Coordinate MOT"},"YES",false,false,true,true,true,false]
[23,{"$f":"VLOOKUP(A28,Default_Ref!A27:B52,2,FALSE)","v":"Progressive GMP"},"NO",false,false,false,false,false,false]
[24,{"$f":"VLOOKUP(A29,Default_Ref!A28:B53,2,FALSE)","v":"Open-end contract"},"NO",false,false,false,false,false,false]
[25,{"$f":"VLOOKUP(A30,Default_Ref!A29:B54,2,FALSE)","v":"Use IDIQ for emergency contracts"},"YES",false,false,false,true,true,false]

{"sheet":"1. Planning","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,3,17,4],[0,0,0,6],[2,0,2,2],[3,3,3,6],[3,0,3,2],[5,3,5,6]]}
["Self-Assessment Questionnaire Answer Sheet"]
[]
["Click on cell to get drop-down menu of possible answers."]
["Questionnaire Set I - Planning Stage"]
["Practice #","Question","Capability\n(from 1 to 6)"]
[1,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!$A$6:$B$30,2),\"\")","v":"Early bundling decision during planning/programming"},3,"Capability Level Criteria"]
[8,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!$A$6:$B$30,2),\"\")","v":"Identify Federal-aid eligible work types "},5,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[10,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use state funding only"},4,1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[null,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[null,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[null,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[null,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[null,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,6,"Optimized","- not applicable -","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[null,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A29,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A30,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A31,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]

{"sheet":"2. Programming","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,0,2,2],[0,0,0,6],[14,3,17,4],[5,3,5,6],[3,0,3,2]]}
["Self-Assessment Questionnaire Answer Sheet"]
[]
["Click on cell to get drop-down menu of possible answers."]
["Questionnaire Set II - Programming Stage"]
["Practice #","Question","Capability\n(from 1 to 6)"]
[1,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!$A$6:$B$30,2),\"\")","v":"Early bundling decision during planning/programming"},1,"Capability Level Criteria"]
[2,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!$A$6:$B$30,2),\"\")","v":"Determine optimum bundle size"},2,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[3,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!$A$6:$B$30,2),\"\")","v":"Limit bundle by work type"},4,1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[4,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!$A$6:$B$30,2),\"\")","v":"Limit bundle by geographic proximity"},4,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[5,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!$A$6:$B$30,2),\"\")","v":"Outreach - Industry"},2,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[6,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!$A$6:$B$30,2),\"\")","v":"Outreach - stakeholders"},2,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[7,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!$A$6:$B$30,2),\"\")","v":"Local partnering"},1,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[8,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!$A$6:$B$30,2),\"\")","v":"Identify Federal-aid eligible work types "},4,6,"Optimized","- not applicable -","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[10,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use state funding only"},4]
[11,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!$A$6:$B$30,2),\"\")","v":"Bundle to reduce number permit actions"},3]
[16,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!$A$6:$B$30,2),\"\")","v":"Stage ROW acquisition sequence"},3]
[19,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ACM"},4]
[null,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A29,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A30,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A31,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]

{"sheet":"3. Prelim. Eng.","index":5,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,2],[3,0,3,2],[5,3,5,6]]}
["Self-Assessment Questionnaire Answer Sheet"]
[]
["Click on cell to get drop-down menu of possible answers."]
["Questionnaire Set III - Preliminary Engineering Stage"]
["Practice #","Question","Capability\n(from 1 to 6)"]
[2,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!$A$6:$B$30,2),\"\")","v":"Determine optimum bundle size"},2,"Capability Level Criteria"]
[3,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!$A$6:$B$30,2),\"\")","v":"Limit bundle by work type"},4,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[4,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!$A$6:$B$30,2),\"\")","v":"Limit bundle by geographic proximity"},4,1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[5,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!$A$6:$B$30,2),\"\")","v":"Outreach - Industry"},3,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[6,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!$A$6:$B$30,2),\"\")","v":"Outreach - stakeholders"},3,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[7,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!$A$6:$B$30,2),\"\")","v":"Local partnering"},1,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[8,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!$A$6:$B$30,2),\"\")","v":"Identify Federal-aid eligible work types "},5,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[11,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!$A$6:$B$30,2),\"\")","v":"Bundle to reduce number permit actions"},4,6,"Optimized","- not applicable -","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[14,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!$A$6:$B$30,2),\"\")","v":"Consolidated utility agreement"},3]
[16,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!$A$6:$B$30,2),\"\")","v":"Stage ROW acquisition sequence"},3]
[17,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use IDIQ to stage ROW/permits/utilities"},3]
[18,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!$A$6:$B$30,2),\"\")","v":"Assign ROW tasks to industry"},3]
[19,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ACM"},4]
[21,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!$A$6:$B$30,2),\"\")","v":"Coordinate construction staging"},5]
[22,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!$A$6:$B$30,2),\"\")","v":"Coordinate MOT"},5]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A29,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A30,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A31,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]

{"sheet":"4. Final Eng.","index":6,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,2],[3,0,3,2],[5,3,5,6]]}
["Self-Assessment Questionnaire Answer Sheet"]
[]
["Click on cell to get drop-down menu of possible answers."]
["Questionnaire Set IV - Final Engineering Stage"]
["Practice #","Question","Capability\n(from 1 to 6)"]
[2,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!$A$6:$B$30,2),\"\")","v":"Determine optimum bundle size"},2,"Capability Level Criteria"]
[3,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!$A$6:$B$30,2),\"\")","v":"Limit bundle by work type"},4,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[8,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!$A$6:$B$30,2),\"\")","v":"Identify Federal-aid eligible work types "},5,1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[14,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!$A$6:$B$30,2),\"\")","v":"Consolidated utility agreement"},4,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[16,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!$A$6:$B$30,2),\"\")","v":"Stage ROW acquisition sequence"},4,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[17,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use IDIQ to stage ROW/permits/utilities"},4,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[18,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!$A$6:$B$30,2),\"\")","v":"Assign ROW tasks to industry"},4,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[19,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ACM"},5,6,"Optimized","- not applicable -","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[20,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ATC"},5]
[21,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!$A$6:$B$30,2),\"\")","v":"Coordinate construction staging"},5]
[22,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!$A$6:$B$30,2),\"\")","v":"Coordinate MOT"},5]
[25,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use IDIQ for emergency contracts"},5]
[null,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A29,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A30,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A31,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]

{"sheet":"5. Constr.","index":7,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,2],[3,0,3,2],[5,3,5,6]]}
["Self-Assessment Questionnaire Answer Sheet"]
[]
["Click on cell to get drop-down menu of possible answers."]
["Questionnaire Set V - Construction Stage"]
["Practice #","Question","Capability\n(from 1 to 6)"]
[19,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ACM"},5,"Capability Level Criteria"]
[20,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ATC"},5,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[21,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!$A$6:$B$30,2),\"\")","v":"Coordinate construction staging"},5,1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[22,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!$A$6:$B$30,2),\"\")","v":"Coordinate MOT"},5,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[25,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use IDIQ for emergency contracts"},5,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[null,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[null,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[null,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,6,"Optimized","- not applicable -","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[null,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A29,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A30,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A31,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]

{"sheet":"6. O&M","index":8,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,2],[5,3,5,6],[3,0,3,2]]}
["Self-Assessment Questionnaire Answer Sheet"]
[]
["Click on cell to get drop-down menu of possible answers."]
["Questionnaire Set VI - Operation and Maintenance Stage"]
["Practice #","Question","Capability\n(from 1 to 6)"]
[19,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!$A$6:$B$30,2),\"\")","v":"Use ACM"},5,"Capability Level Criteria"]
[null,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[null,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[null,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[null,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[null,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[null,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[null,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!$A$6:$B$30,2),\"\")","v":""},null,6,"Optimized","- not applicable -","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[null,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A29,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A30,'Input Page'!$A$6:$B$30,2),\"\")","v":""}]

{"sheet":"Review Result","index":9,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,9,2,12],[0,0,0,7]]}
["Capability Assessment Result Review Sheet"]
[]
["Practice #","Practice","Planning","Program","Prelim. Eng.","Final Eng.","Constr.","O&M","Capability for Each Practice","Capability Level Criteria"]
[1,{"$f":"IFERROR(VLOOKUP(A4,'Input Page'!A6:B30,2,),\"\")","v":"Early bundling decision during planning/programming"},{"$f":"IFERROR(VLOOKUP($A4,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A4,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":1},{"$f":"IFERROR(VLOOKUP($A4,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IF(MIN(C4:H4)=0,\"\",MIN(C4:H4))","v":1},"Level","Description","EDC Definition","Definition applied specifically to bundling"]
[2,{"$f":"IFERROR(VLOOKUP(A5,'Input Page'!A7:B31,2,),\"\")","v":"Determine optimum bundle size"},{"$f":"IFERROR(VLOOKUP($A5,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":2},{"$f":"IFERROR(VLOOKUP($A5,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":2},{"$f":"IFERROR(VLOOKUP($A5,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":2},{"$f":"IFERROR(VLOOKUP($A5,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IF(MIN(C5:H5)=0,\"\",MIN(C5:H5))","v":2},1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[3,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!A8:B32,2,),\"\")","v":"Limit bundle by work type"},{"$f":"IFERROR(VLOOKUP($A6,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A6,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A6,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A6,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},4,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[4,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!A9:B33,2,),\"\")","v":"Limit bundle by geographic proximity"},{"$f":"IFERROR(VLOOKUP($A7,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A7,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A7,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},4,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[5,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!A10:B34,2,),\"\")","v":"Outreach - Industry"},{"$f":"IFERROR(VLOOKUP($A8,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":2},{"$f":"IFERROR(VLOOKUP($A8,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A8,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},2,4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[6,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!A11:B35,2,),\"\")","v":"Outreach - stakeholders"},{"$f":"IFERROR(VLOOKUP($A9,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":2},{"$f":"IFERROR(VLOOKUP($A9,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A9,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},2,5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[7,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!A12:B36,2,),\"\")","v":"Local partnering"},{"$f":"IFERROR(VLOOKUP($A10,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":1},{"$f":"IFERROR(VLOOKUP($A10,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":1},{"$f":"IFERROR(VLOOKUP($A10,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},1,6,"Optimized","- not applicable - ","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[8,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!A13:B37,2,),\"\")","v":"Identify Federal-aid eligible work types "},{"$f":"IFERROR(VLOOKUP($A11,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A11,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A11,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A11,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A11,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},4]
[10,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!A14:B38,2,),\"\")","v":"Use state funding only"},{"$f":"IFERROR(VLOOKUP($A12,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A12,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A12,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A12,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A12,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A12,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},4,"Practice Category","Quick Start Reference Table"]
[11,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!A15:B39,2,),\"\")","v":"Bundle to reduce number permit actions"},{"$f":"IFERROR(VLOOKUP($A13,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A13,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A13,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A13,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A13,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A13,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},3,"Policy",2]
[14,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!A16:B40,2,),\"\")","v":"Consolidated utility agreement"},{"$f":"IFERROR(VLOOKUP($A14,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A14,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A14,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A14,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A14,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A14,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},3,"Communications",3]
[16,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!A17:B41,2,),\"\")","v":"Stage ROW acquisition sequence"},{"$f":"IFERROR(VLOOKUP($A15,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A15,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A15,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A15,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A15,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A15,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},3,"Finance",4]
[17,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!A18:B42,2,),\"\")","v":"Use IDIQ to stage ROW/permits/utilities"},{"$f":"IFERROR(VLOOKUP($A16,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A16,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A16,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A16,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A16,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A16,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},3,"Environmental",5]
[18,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!A19:B43,2,),\"\")","v":"Assign ROW tasks to industry"},{"$f":"IFERROR(VLOOKUP($A17,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A17,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A17,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP($A17,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A17,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A17,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},3,"Utilities & ROW",6]
[19,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!A20:B44,2,),\"\")","v":"Use ACM"},{"$f":"IFERROR(VLOOKUP($A18,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A18,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A18,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP($A18,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A18,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A18,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":5},4,"Contracting",7]
[20,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!A21:B45,2,),\"\")","v":"Use ATC"},{"$f":"IFERROR(VLOOKUP($A19,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A19,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A19,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A19,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A19,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A19,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},5]
[21,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!A22:B46,2,),\"\")","v":"Coordinate construction staging"},{"$f":"IFERROR(VLOOKUP($A20,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A20,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A20,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A20,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A20,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A20,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},5]
[22,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!A23:B47,2,),\"\")","v":"Coordinate MOT"},{"$f":"IFERROR(VLOOKUP($A21,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A21,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A21,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A21,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A21,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A21,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},5]
[25,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!A24:B48,2,),\"\")","v":"Use IDIQ for emergency contracts"},{"$f":"IFERROR(VLOOKUP($A22,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A22,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A22,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A22,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A22,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP($A22,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},5]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!A25:B49,2,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A23,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A23,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A23,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A23,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A23,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A23,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!A26:B50,2,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A24,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A24,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A24,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A24,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A24,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A24,'6. O&M'!$A$6:$C$30,3,FALSE),\"\")","v":""},""]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!A27:B51,2,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A25,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A25,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A25,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A25,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A25,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!A28:B52,2,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A26,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A26,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A26,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A26,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A26,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!A29:B53,2,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A27,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A27,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A27,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A27,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A27,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},null,{"$f":"IF(MIN(C27:H27)=0,\"\",MIN(C27:H27))","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!A30:B54,2,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A28,'1. Planning'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A28,'2. Programming'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A28,'3. Prelim. Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A28,'4. Final Eng.'!$A$6:$C$30,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A28,'5. Constr.'!$A$6:$C$30,3,FALSE),\"\")","v":""},null,{"$f":"IF(MIN(C28:H28)=0,\"\",MIN(C28:H28))","v":""}]
[null,null,null,null,null,null,null,null,"Overall Capability Level"]
[null,null,null,null,null,null,null,null,{"$f":"MODE(I4:I27)","v":4}]

{"sheet":"Report","index":10,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,3,28,4],[14,5,14,8],[0,0,0,8],[2,5,2,8],[13,5,13,8],[1,0,1,4],[12,5,12,8],[11,5,11,8]]}
["Capability Bundling Practices Report"]
["Based on the Organizational Self-Assessment Tool, the following highlighted bundling practices are currently at low capability levels (1 or 2) in the organization:"]
["Practice #","Practice","Capability \n(from 1 to 5)","Capability Level Goal (enter desired level)","Action Plan to Raise Capability Level*\n(Enters  action steps to reach desired  level.)","Capability Level Criteria"]
[1,{"$f":"IFERROR(VLOOKUP(A4,'Input Page'!A6:B30,2,FALSE),\"\")","v":"Early bundling decision during planning/programming"},{"$f":"IFERROR(VLOOKUP(A4,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":1},4,"1. Develop a draft policy & process (business rules) to provide guidance on including bundling program development.\n2. Coordinate with asset managers for piloting process, refine as necessary, adopt.","Level","Description","EDC definition","Definition applied specifically to bundling"]
[2,{"$f":"IFERROR(VLOOKUP(A5,'Input Page'!A7:B31,2,FALSE),\"\")","v":"Determine optimum bundle size"},{"$f":"IFERROR(VLOOKUP(A5,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":2},4,"1. Develop a draft policy & process (business rules) for determining optimum bundles sizes.\n2. Coordinate with asset managers for piloting process, refine as necessary, adopt.",1,"Not Implementing","The agency is not using the innovation anywhere and is not interested in pursuing the innovation."," Project bundling is not considered."]
[3,{"$f":"IFERROR(VLOOKUP(A6,'Input Page'!A8:B32,2,FALSE),\"\")","v":"Limit bundle by work type"},{"$f":"IFERROR(VLOOKUP(A6,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":4},null,null,2,"Development Stage","The agency is collecting guidance and best practices, building support with partners and stakeholders, and developing an implementation process."," No formal policy, process or tools. Ad hoc approach to project bundling is applied when required."]
[4,{"$f":"IFERROR(VLOOKUP(A7,'Input Page'!A9:B33,2,FALSE),\"\")","v":"Limit bundle by geographic proximity"},{"$f":"IFERROR(VLOOKUP(A7,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":4},null,null,3,"Demonstration Stage","The agency is testing and piloting the innovation."," Basic project bundling process and tools are repeatedly used but not standardized. Approach varies from project to project."]
[5,{"$f":"IFERROR(VLOOKUP(A8,'Input Page'!A10:B34,2,FALSE),\"\")","v":"Outreach - Industry"},{"$f":"IFERROR(VLOOKUP(A8,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":2},3,"Formalize an outreach plan template for industry input on potential bundles projects.",4,"Assessment Stage","The agency is assessing the performance of and process for carrying out the innovation and making adjustments to prepare for full deployment.","Draft organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are being assessed."]
[6,{"$f":"IFERROR(VLOOKUP(A9,'Input Page'!A11:B35,2,FALSE),\"\")","v":"Outreach - stakeholders"},{"$f":"IFERROR(VLOOKUP(A9,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":2},3,"Formalize an outreach process for internal stakeholders to provide input on potential bundles projects.",5,"Institutionalized","The agency has adopted the innovation as a standard process or practice and uses it regularly on projects.","Organizational standard process for developing project bundling strategy is documented. Supporting methods, tools, and staff training are established an documented."]
[7,{"$f":"IFERROR(VLOOKUP(A10,'Input Page'!A12:B36,2,FALSE),\"\")","v":"Local partnering"},{"$f":"IFERROR(VLOOKUP(A10,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":1},3,"1. Identify one or more local public agencies to pilot a bundle project with.\n2. Local Public Project Group educates local agencies on benefits of bundling, identify pilot project between local agencies.",6,"Optimized","- not applicable - ","Lessons learned and best practices are applied for continuous improvement. Performance metrics have been established to enable quantitative feedback."]
[8,{"$f":"IFERROR(VLOOKUP(A11,'Input Page'!A13:B37,2,FALSE),\"\")","v":"Identify Federal-aid eligible work types "},{"$f":"IFERROR(VLOOKUP(A11,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":4}]
[10,{"$f":"IFERROR(VLOOKUP(A12,'Input Page'!A14:B38,2,FALSE),\"\")","v":"Use state funding only"},{"$f":"IFERROR(VLOOKUP(A12,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":4},null,null,"Each of these practices are opportunities to increase the institutionization of bundling in your agency."]
[11,{"$f":"IFERROR(VLOOKUP(A13,'Input Page'!A15:B39,2,FALSE),\"\")","v":"Bundle to reduce number permit actions"},{"$f":"IFERROR(VLOOKUP(A13,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":3},4,"1. Consider permit actions in bundling decision.\n2. Consider bundling permit actions independently from bundled projects.","The group that provided the ratings for these practices should go back to the input page and determine if there is an opportunity to implement each practice in the project stage where it was rated 1 or 2."]
[14,{"$f":"IFERROR(VLOOKUP(A14,'Input Page'!A16:B40,2,FALSE),\"\")","v":"Consolidated utility agreement"},{"$f":"IFERROR(VLOOKUP(A14,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":3},4,"Pilot one overall agreement for a bundled project (as opposed to individual location permits).","     1. If yes, then a plan to increase the use can be developed."]
[16,{"$f":"IFERROR(VLOOKUP(A15,'Input Page'!A17:B41,2,FALSE),\"\")","v":"Stage ROW acquisition sequence"},{"$f":"IFERROR(VLOOKUP(A15,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":3},null,null,"     2. If no, then the applicable low-rated stage should be unchecked to obtain a more appropriate capability rating."]
[17,{"$f":"IFERROR(VLOOKUP(A16,'Input Page'!A18:B42,2,FALSE),\"\")","v":"Use IDIQ to stage ROW/permits/utilities"},{"$f":"IFERROR(VLOOKUP(A16,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":3}]
[18,{"$f":"IFERROR(VLOOKUP(A17,'Input Page'!A19:B43,2,FALSE),\"\")","v":"Assign ROW tasks to industry"},{"$f":"IFERROR(VLOOKUP(A17,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":3}]
[19,{"$f":"IFERROR(VLOOKUP(A18,'Input Page'!A20:B44,2,FALSE),\"\")","v":"Use ACM"},{"$f":"IFERROR(VLOOKUP(A18,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":4}]
[20,{"$f":"IFERROR(VLOOKUP(A19,'Input Page'!A21:B45,2,FALSE),\"\")","v":"Use ATC"},{"$f":"IFERROR(VLOOKUP(A19,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":5}]
[21,{"$f":"IFERROR(VLOOKUP(A20,'Input Page'!A22:B46,2,FALSE),\"\")","v":"Coordinate construction staging"},{"$f":"IFERROR(VLOOKUP(A20,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":5}]
[22,{"$f":"IFERROR(VLOOKUP(A21,'Input Page'!A23:B47,2,FALSE),\"\")","v":"Coordinate MOT"},{"$f":"IFERROR(VLOOKUP(A21,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":5}]
[25,{"$f":"IFERROR(VLOOKUP(A22,'Input Page'!A24:B48,2,FALSE),\"\")","v":"Use IDIQ for emergency contracts"},{"$f":"IFERROR(VLOOKUP(A22,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":5}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Input Page'!A25:B49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A23,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Input Page'!A26:B50,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A24,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Input Page'!A27:B51,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A25,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Input Page'!A28:B52,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A26,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Input Page'!A29:B53,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A27,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Input Page'!A30:B54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A28,'Review Result'!$A$4:$I$28,9,FALSE),\"\")","v":""}]
[null,null,null,"* The tool does not automatically populate these columns; user enters desired capability level and action steps to reach that level. See the FHWA Project Bundling Resource Database for examples and tools to assist in developing agency action plans. https://www.fhwa.dot.gov/innovation/everydaycounts/edc_5/project_bundling.cfm"]

{"sheet":"Default_Ref","index":11,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Practice #","Policy","Planning Phase","Programming Phase","Prelim Eng Phase","Final Eng Phase","Construction Phase","O&M Phase"]
[1,"Early bundling decision during planning/programming","x","x"]
[{"$f":"A6+1","v":2},"Determine optimum bundle size",null,"x","x","x"]
[{"$f":"A7+1","v":3},"Limit bundle by work type",null,"x","x"]
[4,"Limit bundle by geographic proximity",null,"x","x"]
[5,"Outreach - Industry","x","x"]
[6,"Outreach - stakeholders","x","x"]
[7,"Local partnering","x","x"]
[8,"Identify Federal-aid eligible work types ","x","x","x"]
[9,"Use innovative finance",null,"x"]
[10,"Use state funding only",null,"x"]
[11,"Bundle to reduce number permit actions",null,"x","x"]
[12,"Programmatic permit",null,"x","x"]
[13,"Assign permitting tasks to industry",null,null,"x","x"]
[14,"Consolidated utility agreement",null,"x"]
[15,"Assign utility coordination to industry",null,"x","x","x"]
[16,"Stage ROW acquisition sequence",null,"x","x","x"]
[17,"Use IDIQ to stage ROW/permits/utilities",null,null,"x","x"]
[18,"Assign ROW tasks to industry",null,null,"x","x"]
[19,"Use ACM",null,"x","x","x","x","x"]
[20,"Use ATC",null,null,null,"x","x"]
[21,"Coordinate construction staging",null,null,null,"x","x"]
[22,"Coordinate MOT",null,null,null,"x","x"]
[23,"Progressive GMP",null,null,null,null,"x"]
[24,"Open-end contract",null,null,null,"x","x"]
[25,"Use IDIQ for emergency contracts",null,null,null,"x","x"]