{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Getitng Started","1. Funding & Financing Need","2. Institutional Knowledge","3. Regulatory Environment","4. Agency Staff","5. Stakeholder Environment","CMMResults","SAVED","Table 1","Internal Developer","Internal READme"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Getitng Started","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Instructions for Getting Started on the Self Assessment"]
["Objectives and Background"]
["Help public agencies, public-private partnerships, and coalitions assess their readiness to implement value-capture strategies, according to project needs and benefits, magnitude of funding needs, experience with value capture, staff capacity and technical skills, regulatory environment, stakeholder support, and opportunities for stakeholder cooperation.\n"]
["Help FHWA understand the range of capacity for value capture among agencies and identify areas of need so it can tailor future outreach to meet those needs."]
["Depending on agencies’ responses, provide resources to assist with implementing value-capture strategies."]
["Upon completion of the Self-Assessment, you will have identified areas that your agency needs to develop and strengthen. The Capability-Maturity Matrix results table (at the end of the Self Assessment) can then be used to guide your agency, step-by-step through the processes needed to build capacity in areas of need and advance your agency’s use of value capture."]
["For users only using keyboards, the drop down menu answer options can be selected by using the Alt and Down Arrow keys"]
["Click here to begin the Value Capture Agency Self Assessment "]

{"sheet":"1. Funding & Financing Need","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,10],[6,1,6,10],[9,1,9,10],[11,1,11,10],[13,1,13,10],[16,0,16,1],[15,1,15,10],[5,0,5,10],[3,0,3,1],[4,0,4,1],[7,0,7,1],[8,0,8,1],[10,0,10,1],[12,0,12,1],[14,0,14,1],[10,2,10,7],[12,2,12,9]]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Funding or Financing Needs "]
["1."," How would you characterize the level of funding available to your agency to meet transportation infrastructure needs—in terms of capital costs and construction, and operations and maintenance?"]
["Q1 Answer: for Capital Costs and Construction"]
["Q1 Answer: for Operations and Maintenance"]
["Definitions: \nSufficient funds available — Funding for transportation infrastructure is not significantly limited and competition for funding among projects is mild. High-priority projects are usually funded in a timely manner; funding is available for projects beyond top priorities; funding is available to meet safety, operations, and maintenance needs.\nModerately limited—Funding for transportation infrastructure is limited, with moderate competition among projects. High-priority projects are sometimes delayed because of funding gaps, but need is met eventually; funding is available to meet safety needs; funding can be difficult to secure for projects of local importance that are not top priorities; maintenance and operations funding can be inconsistent.\nHighly competitive—Significant funding gaps delay and/or sideline high-priority projects; the majority of funding is allocated to safety projects, with little availability of funds for projects focused on improving reliability, accessibility, and/or intermodal connectivity; funding for maintenance and operations is difficult to secure. Competition among projects is significant."]
["2. ","Please provide an estimate of your agency’s annual funding gap for highway or roadway transportation projects:"]
["Q2 Answer: for Captial Costs and Construction"]
["Q2 Answer: for Operations and Maintenance"]
["3.","How would you characterize the magnitude of the total funding gap as a proportion of total project need or cost? (Choose the option that most closely describes the typical funding gap.)"]
["  Q3 Answer:  "]
["4.","To what extent does your agency’s project identification, selection and prioritization process (e.g., long-range plan or STIP) integrate local and regional public policy goals such as land use planning, economic development, affordable housing, equity, and environmental preservation? (select the option that best describes your agency’s portfolio):"]
["Q4 Answer: "]
["5.","Are there planned or proposed transportation projects in your agency’s portfolio that create economic value for identifiable groups of stakeholders such as major employers, institutions, workforce development officials, real estate developers, or businesses relying on transportation improvements? "]
["Q5 Answer: "]
["6.","If yes to #5, to what degree might these stakeholder groups be willing to contribute a portion of the value they expect to receive from the project to close funding gaps and ensure that the project is completed?"]
["Q6 Answer: "]
["Continue to next question"]

{"sheet":"2. Institutional Knowledge","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,0,10,1],[12,0,12,1],[4,2,4,6],[6,2,6,9],[2,1,2,10],[5,1,5,10],[7,1,7,10],[9,1,9,10],[11,1,11,10],[4,0,4,1],[6,0,6,1],[8,0,8,1]]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Interest in and Institutional Knowledge of Value Capture "]
["7.","Has there been interest in value capture, either in individual techniques or as a concept, at any level in the agency (staff and leadership)? "]
["(See Table 1 for value-capture techniques.) "]
["Q7 Answer:"]
["8.","Has the agency used or attempted to use value capture as a revenue source? "]
["Q8 Answer:"]
["9.","Has the agency engaged in long-term public-private partnerships before for non-capital projects? (These arrangements require some of the same institutional competencies as some forms of value capture.) "]
["Q9 Answer: "]
["10.","How receptive is your agency to adopting broad and competing goals such as social policy, equity, sustainability, planning, and economic development into project delivery? "]
["Q10 Answer:"]
["11. ","Responsibility for administering ongoing funding and financing follows a process and is clearly designated?"]
["Q11 Answer:"]
["Continue to next question"]

{"sheet":"3. Regulatory Environment","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,2,23,12],[4,2,4,10],[7,2,7,11],[12,2,12,13],[2,1,2,14],[5,1,5,14],[8,1,8,14],[13,1,13,14],[15,1,15,14],[23,0,23,1],[22,1,22,14],[3,0,3,14],[4,0,4,1],[6,0,6,14],[7,0,7,1],[9,0,9,1],[18,0,18,14],[19,0,19,1],[20,0,20,14],[21,0,21,1],[11,0,11,2],[12,0,12,1],[14,0,14,1],[16,0,16,14],[17,0,17,1]]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Regulatory Environment  "]
["12.","Has the state enacted enabling legislation to allow any of the value-capture techniques listed in Table 1 [adjust hyperlink when online]?"]
["(See Table 1 for value-capture techniques.) "]
["Q12 Answer: "]
["13.","Have there been efforts by your agency or other agencies or stakeholders to encourage your state legislature to pass enabling legislation to allow any of the value-capture techniques listed in Table 1?"]
["(See Table 1 for value-capture techniques.) "]
["Q13 Answer: "]
["14.","\tIf enabling legislation exists, have reservations been raised about implementation due to possible litigation?"]
["Q14 Answer:"]
["15.","If yes, why?"]
["See for more information on: ",null,null,"Fifth Amendment ","Fourteenth Amendment"]
["Q15 Answer: "]
["16.","\tDo local government entities (e.g., transportation authorities, taxing authorities, planning or land use authorities) cooperate and coordinate on existing projects to improve outcomes?"]
["Q16 Answer: "]
["17."," In general, land use planning and zoning regulations that increase land and property values can support the use of value capture. To what extent do local land use, taxation and public works officials in your jurisdiction:"]
["17a. Discuss or consider zoning and regulatory impacts on land values? "]
["Q17a Answer:"]
["17b. Support value capture to fund infrastructure?"]
["Q17b Answer: "]
["17c. Support value capture as a means of fiscal sustainability, avoid private windfalls, reduce land speculation, discourage displacement, support transportation-efficient development patterns, increase equity and regulatory efficacy? "]
["Q17c Answer: "]
["18.","\tHow would you describe your zoning or land use regulation environment? "]
["Q18 Answer:"]
["continue to next question"]

{"sheet":"4. Agency Staff","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,2,11,6],[13,2,13,8],[12,1,12,9],[10,1,10,9],[2,1,2,9],[11,0,11,1],[13,0,13,1]]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Agency Staff Capacity, Skills, and Experience"]
["19. ","To what extent does the implementing agencies (transportation, taxing authority, or administrative) have staff with the technical analysis and project management skills and experience to perform the following tasks? "]
["Select one experience level for each value-capture task."]
["Task","Staff does not have sufficient experience to perform the task or supervise a consultant to perform the task.","Staff does not have sufficient experience to perform the task but is able to supervise a consultant hired to perform the task.","Staff has the experience to perform the task and to supervise a consultant to perform the task.","A consultant or partner agency (such as county assessor, nonprofit civic or business organization) would perform this task.","Unsure","User Message if Errror in completing form"]
["Evaluate the impact of infrastructure projects on nearby land values?",null,null,null,null,null,{"$f":"IF(COUNTA(B6:F6)>1,\"Please select one value for each row\", \"-\")","v":"-"}]
["Determine the potential benefits and risks of a given project and value-capture method and allocate the benefits and risks fairly among public sector and private sector participants and other stakeholders?",null,null,null,null,null,{"$f":"IF(COUNTA(B7:F7)>1,\"Please select one value for each row\", \"-\")","v":"-"}]
["Develop a financing plan?",null,null,null,null,null,{"$f":"IF(COUNTA(B8:F8)>1,\"Please select one value for each row\", \"-\")","v":"-"}]
["Conduct market or financial feasibility and risk analysis?",null,null,null,null,null,{"$f":"IF(COUNTA(B9:F9)>1,\"Please select one value for each row\", \"-\")","v":"-"}]
["Manage revenue collection and monitor and report on revenue captured?",null,null,null,null,null,{"$f":"IF(COUNTA(B10:F10)>1,\"Please select one value for each row\", \"-\")","v":"-"}]
["20.","Does your agency have sufficient staffing capacity to begin research, coordination, or implementation of a value-capture strategy? "]
["Q20 Answer: "]
["21.","Does the agency have access to and/or the ability to collect data about assessments; determine benefit area; determine fee or tax level; analyze impacts of the transportation investment on land value; demographic, economic, and real estate market trends?"]
["Q21 Answer: "]
[{"$f":"IF(OR(G6=\"Please select one value for each row\",G7=\"Please select one value for each row\",G8=\"Please select one value for each row\",G9=\"Please select one value for each row\",G10=\"Please select one value for each row\"),\"go back to question 19 and address any errors\",\"Proceed to the next question\")","v":"Proceed to the next question"}]
["Continue to next question"]

{"sheet":"5. Stakeholder Environment","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,2,21,11],[2,1,2,14],[4,1,4,14],[6,1,6,14],[8,1,8,14],[20,1,20,14],[3,2,3,13],[5,2,5,13],[7,2,7,11],[21,0,21,1],[7,0,7,1],[5,0,5,1],[3,0,3,1]]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Institutional, Civic, and Stakeholder Environment "]
["22.","Does your jurisdiction have a history or culture of cooperation among agencies and across levels of government for projects related to transportation?"]
["Q22 Answer: "]
["23."," Does your jurisdiction have experience in long-term revenue sharing with other local governments and taxing authorities? "]
["Q23 Answer: "]
["24.","Have the local business community or other stakeholders expressed interest or support for using value capture for transportation improvements or investments?"]
["Q24 Answer:"]
["25.","To what extent does your agency engage with other agencies and stakeholder groups in your community/region?  (Select one engagement level per resource)."]
["Resource","Little to No Engagement","Some or Passive Engagement","Active Engagement  ","User Message if Errror in completing form"]
["State transportation agency",null,null,null,{"$f":"IF(COUNTA(B11:D11)>1,\"Please select one value for each row\", \"-\")","v":"-"}]
["Regional transportation authority, transit authority",null,null,null,"-"]
["Municipality, neighboring municipalities",null,null,null,"-"]
["Elected officials (including State legislature, city council, county governance board)",null,null,null,"-"]
["Economic development agency, tourism bureau",null,null,null,"-"]
["Neighborhood and community groups",null,null,null,"-"]
["Developers, Real Estate sales community, site selectors ",null,null,null,"-"]
["Major employers, industry groups, chamber of commerce",null,null,null,"-"]
["Other civic partners (hospitals, community colleges and universities, nonprofit organizations, charitable foundations)",null,null,null,"-"]
["Taxpayers",null,null,null,"-"]
["26.","To what extent has your agency engaged with public and private sector stakeholder groups about value capture? (select all that apply)"]
["Q26 Answer: "]
[{"$f":"IF(OR(E11=\"Please select one value for each row\",E12=\"Please select one value for each row\",E13=\"Please select one value for each row\", E14=\"Please select one value for each row\",E15=\"Please select one value for each row\",E16=\"Please select one value for each row\",E17=\"Please select one value for each row\",E18=\"Please select one value for each row\",E19=\"Please select one value for each row\",E20=\"Please select one value for each row\"),\"go back to question 25 and address any errors\",\"No errors, procced to the next question:\")","v":"No errors, procced to the next question:"}]
["continue to results"]

{"sheet":"CMMResults","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["CMM Self-Assessment Results"]
["Component ","Level 1. Informal understanding","Level 2. Implementation Planning","Level 3. Active Adoption","Level 4. Institutional Maturity"]
["Component 1. Policy: appointed leadership and senior staff ","No familiarity with value capture mechanisms.","Value capture concepts have been introduced to senior policymakers, but interest is limited.","Policymakers have been briefed on full range of value capture options; understand and are ready to move forward with implementation.","Committed to support and understand role of value capture in project funding."]
["Component 1 Placement",{"$f":"IF('Internal Developer'!D41=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D42=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D43=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D44=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D45=TRUE,\"Current Maturity Level\",\"-\")","v":"-"}]
["Component 2. Enabling legislation: legislatures and other elected officials","No legislative initiatives undertaken for enabling value capture.","Reliance on one or limited number of value capture tools (e.g., TIFs).","Legislative advocates have been identified and enabling legislation is pending or recently passed.","Full suite of value capture options enabling legislation is available to state and local agencies."]
["Component 2 Placement",{"$f":"IF('Internal Developer'!D83=TRUE, \"-\",IF('Internal Developer'!D87=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D88=TRUE,\"Current Maturity Level\",\"-\")))","v":"-"},{"$f":"IF('Internal Developer'!D83=TRUE, \"\",IF('Internal Developer'!D89=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D83=TRUE, \"\",IF('Internal Developer'!D90=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D83=TRUE,\"Current Maturity Level\",\"-\")","v":"-"}]
["Component 3. Communications: private sector relations—financially interested stakeholders; and public communications—community leaders and interested stakeholders. ","No experience in engaging with private sector stakeholders (developers); public stakeholder engagement limited to those required by policy and planning requirements.","Discussions with interested private sector representatives have begun; public sector stakeholders are aware of and have demonstrated interest in and understanding of value capture concepts.","Committed private sector interests have been identified and potential utilization of value capture options have been fully discussed; public sector stakeholders are comfortable with value capture concepts and are willing to advocate for them and assist in communicating with constituencies.","Ongoing working relationships with both private sector interests and public stakeholders on project involving value capture mechanisms."]
["Component 3 Placement",{"$f":"IF('Internal Developer'!D266=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D271=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D267=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D268=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D269=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D270=TRUE,\"Current Maturity Level\",\"-\")","v":"-"}]
["Component 4. \nStaff skills assessment and training: legal, planning, development, contact administration, finance and revenue. ","Staffing and skills required for implementation are only vaguely understood; Little or no emphasis on learning environment other than basic professional certifications (e.g., P.E., AICP, PMP).","Staffing skills required for value capture implementation have been surveyed, deficiencies understood, and training programs in place.","Robust program of targeted learning and professional recognition and rewards for advancement serving value capture implementing needs.","Organizational commitment to training and skill enhancement is funded and rewarded for all required skills consistent with policy and legislative foundations."]
["Component  4 Placement",{"$f":"IF('Internal Developer'!D154=\"x\",\"Current Maturity Level\",IF('Internal Developer'!D158=\"x\",\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D155=\"x\",\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D157=\"x\",\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D156=\"x\",\"Current Maturity Level\",\"-\")","v":"-"}]
["Component 5. \nStaff management: turnover and institutional memory","Value capture options not clearly understood or embraced by management or staff; responsibility for value capture program implementation is not clear within organization.","Staff managers are committed to understanding and implementing value capture methods; Responsibility highly dispersed or compartmentalized and housed in legacy organizational silos.","Organizational and management structure is in place to foster use and implementation of value capture as part of project planning and delivery.","Responsibility for administering ongoing funding and financing for value capture techniques is clearly designated and known throughout organization."]
["Component 5 Placement",{"$f":"IF('Internal Developer'!D74=TRUE,\"-\",IF('Internal Developer'!D49=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D50=TRUE,\"Current Maturity Level\",\"-\")))","v":"-"},{"$f":"IF('Internal Developer'!D74=TRUE,\"-\",IF('Internal Developer'!D51=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D52=TRUE,\"Current Maturity Level\",\"-\")))","v":"-"},{"$f":"IF('Internal Developer'!D74=TRUE,\"-\",IF('Internal Developer'!D53=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D74=TRUE,\"Current Maturity Level\",\"-\")","v":"-"}]
["Component 6. Interagency coordination: across departments, municipalities, counties, or regions","Limited to coordinating project prioritization under STIP or similar programs.","Working relationships have been developed with MPOs and LPAs in areas other than value capture and cooperative finance; discussions about coordination of value capture issues have not been undertaken.","Discussion and interest around value capture use and implementation has been undertaken with initial interest and use as funding for potential projects (e.g., STIP) as part of the planning process.","Ongoing coordination on projects implemented using value capture methods at multiple levels of regional and local government."]
["Component 6 Placement",{"$f":"IF('Internal Developer'!D195=TRUE,\"Current Maturity Level\",IF('Internal Developer'!D196=TRUE,\"Current Maturity Level\",\"-\"))","v":"-"},{"$f":"IF('Internal Developer'!D197=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D198=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D199=TRUE,\"Current Maturity Level\",\"-\")","v":"-"}]
["Component 7. Experience in long-term revenue sharing with local governments: management, finance and accounting ","Business and financial accounting focused on internal budget management and grant administration.","Administration of federal grants and support is well developed and relationships with potential value capture partners are in place.","Financial mechanisms are supported by interlocal agreements/MOUs focused on administration and revenue sharing are in place; specific projects linked to ongoing project prioritization and funding are identified.","Ongoing collaborative management of revenue sharing and funding support for value capture projects within agency jurisdiction."]
["Component 7 Placement",{"$f":"IF('Internal Developer'!D207=TRUE,\"-\",IF(OR('Internal Developer'!D203=TRUE,'Internal Developer'!D115=TRUE),\"Current Maturity Level\",IF('Internal Developer'!D204=TRUE,\"Current Maturity Level\",\"-\")))","v":"-"},{"$f":"IF('Internal Developer'!D205=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D206=TRUE,\"Current Maturity Level\",\"-\")","v":"-"},{"$f":"IF('Internal Developer'!D207=TRUE,\"Current Maturity Level\",\"-\")","v":"-"}]
["Save Results","Clear Old Results","View Results"]

{"sheet":"SAVED","index":7,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Saved CMM Self-Assessment Results"]
["Component ","Level 1. Informal understanding","Level 2. Implementation Planning","Level 3. Active Adoption","Level 4. Institutional Maturity"]
["Component 1. Policy: appointed leadership and senior staff "]
["Component 1 Placement"]
["Component 2. Enabling legislation: legislatures and other elected officials"]
["Component 2 Placement"]
["Component 3. Communications: private sector relations—financially interested stakeholders; and public communications—community leaders and interested stakeholders. "]
["Component 3 Placement"]
["Component 4. \nStaff skills assessment and training: legal, planning, development, contact administration, finance and revenue. "]
["Component  4 Placement"]
["Component 5. \nStaff management: turnover and institutional memory"]
["Component 5 Placement"]
["Component 6. Interagency coordination: across departments, municipalities, counties, or regions"]
["Component 6 Placement"]
["Component 7. Experience in long-term revenue sharing with local governments: management, finance and accounting "]
["Component 7 Placement"]
["Print Results","Date:",{"$f":"TODAY()","v":"2024-04-05"}]

{"sheet":"Table 1","index":8,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,4,0],[6,0,9,0],[10,0,11,0],[12,0,14,0]]}
["Public Agency Self-Assessment Tool for Value Capture Implementation"]
["Overview of Value-Capture Categories, Techniques, and Definitions"]
["Category","Technique","Category & Technique","Definition"]
["Developer contributions","Impact fees","Developer contributions: Impact fees","Fees imposed on developers to help fund additional public services, infrastructure, or transportation facilities required due to the new development."]
[null,"Negotiated exactions","Developer contributions: Negotiated exactions","Negotiated charges imposed on developers to mitigate the cost of public services or infrastructure required as a result of the new development."]
["Transportation utility fees","Transportation utility fees","Transportation utility fees: Transportation utility fees","Fees paid by property owners or building occupants to a municipality based on estimated use of the transportation system."]
["Special taxes and fees","Special assessment districts","Special taxes and fees: Special assessment districts","Fees charged on property owners in a designated district whose properties are the primary beneficiaries of an infrastructure improvement."]
[null,"Business improvement districts","Special taxes and fees: Business improvement districts","Fees or levies charged on businesses in a designated district to fund or finance projects or services in the district's boundaries."]
[null,"Land value taxes or split-rate taxes","Special taxes and fees: Land value taxes or split-rate taxes","A lower property tax rate applied to privately created building values and a higher rate applied to publicly created land values."]
[null,"Sales tax districts","Special taxes and fees: Sales tax districts","Additional sales taxes levied on all transactions or purchases in a designated area that benefits from an infrastructure improvement."]
["Tax increment financing","Tax increment financing","Tax increment financing: Tax increment financing","Charges that capture incremental property tax value increases from an investment in a designated district to fund or finance the investment."]
[null,"Transportation reinvestment zones","Tax increment financing: Transportation reinvestment zones","Transportation reinvestment zones allow for a broader range of transportation projects. The local governing body designates a zone in which it will promote a transportation project. The zone does not require the local entity to create a board."]
["Joint development","At-grade joint development","Joint development: At-grade joint development","Projects that occur within the existing development rights of a transportation project."]
[null,"Above-grade joint development","Joint development: Above-grade joint development","Projects that involve the transfer of air rights, which are development rights above or below transportation infrastructure."]
[null,"Utility joint development","Joint development: Utility joint development","Projects that take advantage of the synergies of broadband and other utilities with highway right-of-way."]
["Tax increment financing","Asset recycling","Tax increment financing: Asset recycling","Involves the recycling of existing public infrastructure assets through sale or lease to the private sector, with all funds received being invested in new infrastructure."]
["Naming rights","Naming rights","Naming rights: Naming rights","A transaction that involves an agency selling the rights to name infrastructure to a private company."]
["Return to Question 7"]
["Return to Quesiton 12"]
["Return to Question 13"]

{"sheet":"Internal Developer","index":9,"n_rows":271,"n_cols":16,"rows_kept":271,"cut":false,"hidden":false,"merged":[]}
["Self assessemnt Results - Background connections"]
[]
["questions","Index",null,"Values (a)","Values (b)","Modified Drop Down Box","Connection to CMM",null,"Tab","Developer notes","Error Check","Error Message (1)","Error Message (2)","Additional Drop down menus"]
[1,null,null,null,null,null,null,null,"Funding & Financing Need",null,null,null,null,"x"]
[null,null,null,"Sufficient Funds Available"]
[null,null,"Capital costs and construction",{"$f":"'1. Funding & Financing Need'!C4","v":0},null,null,null,null,null,null,null,null,null,"Sufficient Funds Available","Funding is Moderately Limited","Funding is Highly Competitive"]
[null,null,"Operations and maintenance",{"$f":"'1. Funding & Financing Need'!C5","v":0}]
[]
[2,null,null,null,null,null,null,null,"Funding & Financing Need"]
[null,null,null,"Checkmark","$"]
[null,null,"Capital Costs and construction",false,{"$f":"'1. Funding & Financing Need'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Operation and Maintenance Costs",false,{"$f":"'1. Funding & Financing Need'!#REF!","v":{"$error":"#REF!"}}]
[]
[3,null,null,null,null,null,null,null,"Funding & Financing Need"]
[null,null,null,"Checkmark",null,{"$f":"'1. Funding & Financing Need'!C11","v":0}]
[null,null," 0–10%",{"$f":"$F$15=C16","v":false},null,null,null,null,null,null,{"$f":"IF(D16=TRUE,1,0)","v":0},{"$f":"IF(SUM(K16:K19)>1,\"Please select one option\",\"\")","v":"Please select one option"}]
[null,null,"11–25%",true,null,null,null,null,null,null,{"$f":"IF(D17=TRUE,1,0)","v":1}]
[null,null,"26–50%",true,null,null,null,null,null,null,1]
[null,null,"Many high-priority projects face a funding gap of 50% or greater",{"$f":"$F$15=C19","v":false},null,null,null,null,null,null,0]
[]
[4,null,null,null,null,null,null,null,"Funding & Financing Need"]
[null,null,null,"Checkmark",null,{"$f":"'1. Funding & Financing Need'!C13","v":0}]
[null,null,"The project selection process is focused on safety, state of good repair, and addressing access and mobility issues from an engineering perspective; regional public policy goals have very limited influence on project selection and prioritization.",{"$f":"$F$22=C23","v":false},null,null,null,null,null,null,{"$f":"IF(D23=TRUE,1,0)","v":0},{"$f":"IF(SUM(K23:K25)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"The project selection process is oriented toward safety, state of good repair, and addressing access and mobility issues from an engineering perspective, but there is some formal consideration of other regional public policy goals, and some transportation projects are selected or prioritized primarily on the basis of these other goals.",{"$f":"$F$22=C24","v":false},null,null,null,null,null,null,{"$f":"IF(D24=TRUE,1,0)","v":0}]
[null,null,"Public policy factors such as land use, economic development, affordable housing, equity, and environmental preservation play a key role in transportation project selection; transportation projects that support and promote other local or regional public policy goals are a significant proportion of planned and proposed projects (e.g., STIP or long-range plan projects).",true,null,null,null,null,null,null,1]
[]
[5,null,null,null,null,null,null,null,"Funding & Financing Need"]
[null,null,null,"Checkmark",null,{"$f":"'1. Funding & Financing Need'!C15","v":0}]
[null,null,"Yes",{"$f":"$F$28=C29","v":false},null,null,null,null,null,null,{"$f":"IF(D29=TRUE,1,0)","v":0},{"$f":"IF(SUM(K29:K30)>1,\"Please select one option\",\"\")","v":""},{"$f":"IF(D29=TRUE,\"Skip to question 7\", \"\")","v":""}]
[null,null,"No",true,null,null,null,null,null,null,{"$f":"IF(D30=TRUE,1,0)","v":1}]
[]
[6,null,null,null,null,null,null,null,"Funding & Financing Need"]
[null,null,null,"Checkmark",null,{"$f":"'1. Funding & Financing Need'!C17","v":0}]
[null,null,"Low",{"$f":"C34=$F$33","v":false},null,null,null,null,null,null,{"$f":"IF(D34=TRUE,1,0)","v":0},{"$f":"IF(SUM(K34:K37)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Moderate",{"$f":"C35=$F$33","v":false},null,null,null,null,null,null,{"$f":"IF(D35=TRUE,1,0)","v":0}]
[null,null,"High",false,null,null,null,null,null,null,0]
[null,null,"Unsure",false,null,null,null,null,null,null,0]
[]
[7,null,null,null,null,null,null,null,"Institutional Knowledge"]
[null,null,null,"Checkmark",null,{"$f":"'2. Institutional Knowledge'!C5","v":0}]
[null,null,"No awareness or familiarity ",{"$f":"$F$40=C41","v":false},null,null,"C1, L1",null,null,null,{"$f":"IF(D41=TRUE,1,0)","v":0},{"$f":"IF(SUM(K41:K45)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some familiarity, but little to no interest ",{"$f":"$F$40=C42","v":false},null,null,"C1, L2",null,null,null,{"$f":"IF(D42=TRUE,1,0)","v":0}]
[null,null,"Some curiosity or interest, informal at this point ",false,null,null,"C1, L2",null,null,null,0]
[null,null,"Moderate to high level of familiarity and motivation to move forward with implementation ",false,null,null,"C1, L3",null,null,null,0]
[null,null,"Fully support and understand the role of value capture in project funding ",false,null,null,"C1, L4",null,null,null,0]
[]
[8,null,null,null,null,null,null,null,"Institutional Knowledge"]
[null,null,null,"Checkmark",null,{"$f":"'2. Institutional Knowledge'!C7","v":0}]
[null,null,"Agency has NOT taken steps to investigate the use of value capture.",{"$f":"$F$48=C49","v":false},null,null,"C5, L1",null,null,null,{"$f":"IF(D49=TRUE,1,0)","v":0},{"$f":"IF(SUM(K49:K56)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Agency has started to investigate possible use of value capture.",false,null,null,"C5, L1",null,null,null,{"$f":"IF(D50=TRUE,1,0)","v":0}]
[null,null,"Agency has identified candidate projects, available value-capture techniques, and/or possible barriers to implementation.",false,null,null,"C5, L2",null,null,null,0]
[null,null,"Agency attempted to overcome barriers to value capture implementation, but barriers remain.",false,null,null,"C5, L2",null,null,null,0]
[null,null,"Agency has successfully overcome barriers to value capture and is ready to begin implementation.",false,null,null,"C5, L3",null,null,null,0]
[null,null,"Agency has successfully implemented value capture for transit projects but has not yet attempted value capture for highway or roadway projects.",false,null,null,null,null,null,null,0]
[null,null,"Agency has successfully implemented value capture for highway or roadway projects.",false,null,null,null,null,null,null,0]
[null,null,"Not sure.",false,null,null,null,null,null,null,0]
[]
[9,null,null,null,null,null,null,null,"Institutional Knowledge"]
[null,null,null,"Checkmark",null,{"$f":"'2. Institutional Knowledge'!C9","v":0}]
[null,null,"Yes",{"$f":"$F$59=C60","v":false},null,null,null,null,null,null,{"$f":"IF(D60=TRUE,1,0)","v":0},{"$f":"IF(SUM(K60:K62)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"No",{"$f":"$F$59=C61","v":false},null,null,null,null,null,null,{"$f":"IF(D61=TRUE,1,0)","v":0}]
[null,null,"Unsure",false,null,null,null,null,null,null,0]
[]
[10,null,null,null,null,null,null,null,"Institutional Knowledge"]
[null,null,null,"Checkmark",null,{"$f":"'2. Institutional Knowledge'!C11","v":0}]
[null,null,"Unreceptive",{"$f":"C66=$F$65","v":false},null,null,null,null,null,null,{"$f":"IF(D66=TRUE,1,0)","v":0},{"$f":"IF(SUM(K66:K70)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Mildly receptive",{"$f":"C67=$F$65","v":false},null,null,null,null,null,null,{"$f":"IF(D67=TRUE,1,0)","v":0}]
[null,null,"Moderately receptive",{"$f":"C68=$F$65","v":false},null,null,null,null,null,null,0]
[null,null,"Highly receptive",{"$f":"C69=$F$65","v":false},null,null,null,null,null,null,0]
[null,null,"Unknown",{"$f":"C70=$F$65","v":false},null,null,null,null,null,null,0]
[]
[11,null,null,null,null,null,null,null,"Institutional Knowledge"]
[null,null,null,null,null,{"$f":"'2. Institutional Knowledge'!C13","v":0}]
[null,null,"Yes",{"$f":"$F$73=C74","v":false},null,null,"C5, L4",null,null,null,{"$f":"IF(D74=TRUE,1,0)","v":0},{"$f":"IF(SUM(K74:K78)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"No",{"$f":"$F$73=C75","v":false},null,null,null,null,null,null,0]
[null,null,"Unsure",false,null,null,null,null,null,null,0]
[]
[12]
[null,null,null,"Checkmark",null,{"$f":"'3. Regulatory Environment'!C5","v":0},null,null,{"$f":"'3. Regulatory Environment'!A2","v":"Regulatory Environment  "}]
[null,null,"I do not know or unsure.",{"$f":"$F$79=C80","v":false},null,null,null,null,null,null,{"$f":"IF(D80=TRUE,1,0)","v":0},{"$f":"IF(SUM(K80:K84)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Limited enabling legislation exists, allowing use of one or two value-capture techniques.",false,null,null,null,null,null,null,0]
[null,null,"Enabling legislation exists that allows several of the techniques presented in Table 1.",false,null,null,null,null,null,null,0]
[null,null,"Enabling legislation exists that allows most or all of the techniques presented in Table 1. ",false,null,null,"C2, L4",null,null,null,0]
[]
[13]
[null,null,null,"Checkmark",null,{"$f":"'3. Regulatory Environment'!C8","v":0},null,null,"Regulatory Environment  "]
[null,null,"I do not know or unsure",{"$f":"$F$86=C87","v":false},null,null,"C2, L1",null,null,null,{"$f":"IF(D87=TRUE,1,0)","v":0},{"$f":"IF(SUM(K87:K90)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"There have not been any initiatives to enact enabling legislation for value capture",{"$f":"$F$86=C88","v":false},null,null,"C2, L1",null,null,null,0]
[null,null,"Initiatives to enact enabling legislation for value capture have not yet been successful",false,null,null,"C2, L2",null,null,null,0]
[null,null,"Legislative advocates have successfully introduced enabling legislation for value capture, and it is pending or has been successfully enacted",false,null,null,"C2, L3",null,null,null,0]
[]
[14]
[null,null,null,"Checkmark",null,{"$f":"'3. Regulatory Environment'!C10","v":0},null,null,"Regulatory Environment  "]
[null,null,"Yes",{"$f":"$F$93=C94","v":false},null,null,null,null,null,null,{"$f":"IF(D94=TRUE,1,0)","v":0},{"$f":"IF(SUM(K94:K96)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"No",{"$f":"$F$93=C95","v":false},null,null,null,null,null,null,0,null,{"$f":"IF(OR(D95=TRUE,D96=TRUE)*AND(SUM(K94:K96)<2),\"Skip question 15\",\"\")","v":""}]
[null,null,"Unsure",false,null,null,null,null,null,null,0]
[]
[15,null,null,null,null,null,null,null,"Regulatory Environment  "]
[null,null,null,"Checkmark",null,{"$f":"'3. Regulatory Environment'!C13","v":0}]
[null,null,"Possible taking (in violation of the Fifth Amendment to the U.S. Constitution).",{"$f":"$F$99=C100","v":false},null,null,null,null,null,null,{"$f":"IF(D100=TRUE,1,0)","v":0},{"$f":"IF(SUM(K100:K110)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Due process (compliance with procedural and substantive requirements under the Fifth and Fourteenth Amendments).",{"$f":"$F$99=C101","v":false},null,null,null,null,null,null,0]
[null,null,"Rational nexus (a clear connection between a proposed private development and an associated need for additional public facilities and/or services).",false,null,null,null,null,null,null,0]
[null,null,"Proportional (is the fee paid by the developer proportionate to the cost of the infrastructure?).",true,null,null,null,null,null,null,1]
[null,null,"“But for” finding (i.e., development will not occur without the proposed infrastructure project).",false,null,null,null,null,null,null,0]
[null,null,"Complexity of calculating benefits (magnitude and boundaries).",false,null,null,null,null,null,null,0]
[null,null,"Complexity of calculating the impact of new development on infrastructure capacity.",false,null,null,null,null,null,null,0]
[null,null,"Uniformity (all similar property must be treated equally).",false,null,null,null,null,null,null,0]
[null,null,"Conflict or inconsistency with tax policies.",false,null,null,null,null,null,null,0]
[null,null,"Other",false,{"$f":"'3. Regulatory Environment'!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,0]
[null,null,"Unkown",false,null,null,null,null,null,null,0]
[]
[16,null,null,null,null,null,null,null,"Regulatory Environment  "]
[null,null,null,"Checkmark",null,{"$f":"'3. Regulatory Environment'!C15","v":0}]
[null,null,"Yes",{"$f":"$F$113=C114","v":false}]
[null,null,"No",{"$f":"$F$113=C115","v":false},null,null,"C7, L1"]
[null,null,"Unsure",{"$f":"$F$113=C116","v":false}]
[]
[17,null,null,null,null,null,null,null,"Regulatory Environment  "]
[null,null,null,"Checkmark"]
[null,null,"Discuss or consider zoning and regulatory impacts on land values? (Circle one)",null,null,{"$f":"'3. Regulatory Environment'!C18","v":0}]
[null,null,"rarely or never",true]
[null,null,"sometimes",{"$f":"$F$120=C122","v":false}]
[null,null,"often ",false]
[null,null,"frequently or always",false]
[null,null,"Support value capture to fund infrastructure? (Circle one)",null,null,{"$f":"'3. Regulatory Environment'!C20","v":0}]
[null,null,"rarely or never",{"$f":"$F$125=C126","v":false}]
[null,null,"sometimes",{"$f":"$F$125=C127","v":false}]
[null,null,"often ",false]
[null,null,"frequently or always",false]
[null,null,"Support value capture to support other public policy goals such as fiscal sustainability, avoid private windfalls, reduce land speculation, support transportation-efficient development patterns, increase equity and increase regulatory efficacy? (Circle one)",null,null,{"$f":"'3. Regulatory Environment'!C22","v":0}]
[null,null,"rarely or never",{"$f":"$F$130=C131","v":false}]
[null,null,"sometimes",{"$f":"$F$130=C132","v":false}]
[null,null,"often ",false]
[null,null,"frequently or always",false]
[]
[18,null,null,null,null,null,null,null,"Regulatory Environment  "]
[null,null,null,"Checkmark",null,{"$f":"'3. Regulatory Environment'!C24","v":0}]
[null,null,"Zoning and land use policies are highly restrictive and/or are at odds with market demand or appropriate development density.",true,null,null,null,null,null,null,{"$f":"IF(D138=TRUE,1,0)","v":1},{"$f":"IF(SUM(K138:K143)>1,\"Please select one option\",\"\")","v":"Please select one option"}]
[null,null,"Zoning and land use policies are restrictive in some areas but permissive in targeted areas (e.g., through use of special overlay zones such as transportation districts or incentive zones).",true,null,null,null,null,null,null,1]
[null,null,"Zoning and land use policies throughout the jurisdiction are generally consistent with market demand and allow appropriate development density.",{"$f":"$F$137=C140","v":false},null,null,null,null,null,null,0]
[null,null,"Zoning and land use policies are closely aligned with market demand or are permissive, allowing developers to construct development types and densities they perceive to be in demand.",false,null,null,null,null,null,null,0]
[null,null,"Zoning and land use decisions are largely conditional and require Zoning Board approval.",false,null,null,null,null,null,null,0]
[null,null,"Not familiar with zoning and land use decision making processes.",false,null,null,null,null,null,null,0]
[]
[19,null,null,null,null,null,null,null,"Agency Staff"]
[]
[null,null,"Evaluate the impact of infrastructure projects on nearby land values?"]
[null,null,"Staff does not have sufficient experience to perform the task or supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!B6","v":0},null,null,null,null,null,null,{"$f":"IF(D148=\"x\",1,0)","v":0},{"$f":"IF(SUM(K148:K152)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Staff does not have sufficient experience to perform the task but is able to supervise a consultant hired to perform the task.",{"$f":"'4. Agency Staff'!C6","v":0},null,null,null,null,null,null,{"$f":"IF(D149=\"x\",1,0)","v":0}]
[null,null,"Staff has the experience to perform the task and to supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!D6","v":0},null,null,null,null,null,null,0]
[null,null,"A consultant or partner agency (such as county assessor, nonprofit civic or business organization) would perform this task.",{"$f":"'4. Agency Staff'!E6","v":0},null,null,null,null,null,null,0]
[null,null,"Unsure",{"$f":"'4. Agency Staff'!F6","v":0},null,null,null,null,null,null,0]
[null,null,"Determine the potential benefits and risks of a given project and value-capture method and allocate the benefits and risks fairly among public sector and private sector participants and other stakeholders?"]
[null,null,"Staff does not have sufficient experience to perform the task or supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!B7","v":0},null,null,"C4, L1",null,null,null,{"$f":"IF(D154=\"x\",1,0)","v":0},{"$f":"IF(SUM(K154:K158)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Staff does not have sufficient experience to perform the task but is able to supervise a consultant hired to perform the task.",{"$f":"'4. Agency Staff'!C7","v":0},null,null,"C4, L2",null,null,null,{"$f":"IF(D155=\"x\",1,0)","v":0}]
[null,null,"Staff has the experience to perform the task and to supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!D7","v":0},null,null,"C4, L4",null,null,null,0]
[null,null,"A consultant or partner agency (such as county assessor, nonprofit civic or business organization) would perform this task.",{"$f":"'4. Agency Staff'!E7","v":0},null,null,"C4, L3",null,null,null,0]
[null,null,"Unsure",{"$f":"'4. Agency Staff'!F7","v":0},null,null,"C4, L1",null,null,null,0]
[null,null,"Develop a financing plan?"]
[null,null,"Staff does not have sufficient experience to perform the task or supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!B8","v":0},null,null,null,null,null,null,{"$f":"IF(D160=\"x\",1,0)","v":0},{"$f":"IF(SUM(K160:K164)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Staff does not have sufficient experience to perform the task but is able to supervise a consultant hired to perform the task.",{"$f":"'4. Agency Staff'!C8","v":0},null,null,null,null,null,null,{"$f":"IF(D161=\"x\",1,0)","v":0}]
[null,null,"Staff has the experience to perform the task and to supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!D8","v":0},null,null,null,null,null,null,0]
[null,null,"A consultant or partner agency (such as county assessor, nonprofit civic or business organization) would perform this task.",{"$f":"'4. Agency Staff'!E8","v":0},null,null,null,null,null,null,0]
[null,null,"Unsure",{"$f":"'4. Agency Staff'!F8","v":0},null,null,null,null,null,null,0]
[null,null,"Conduct market or financial feasibility and risk analysis?"]
[null,null,"Staff does not have sufficient experience to perform the task or supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!B9","v":0},null,null,null,null,null,null,{"$f":"IF(D166=\"x\",1,0)","v":0},{"$f":"IF(SUM(K166:K170)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Staff does not have sufficient experience to perform the task but is able to supervise a consultant hired to perform the task.",{"$f":"'4. Agency Staff'!C9","v":0},null,null,null,null,null,null,{"$f":"IF(D167=\"x\",1,0)","v":0}]
[null,null,"Staff has the experience to perform the task and to supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!D9","v":0},null,null,null,null,null,null,0]
[null,null,"A consultant or partner agency (such as county assessor, nonprofit civic or business organization) would perform this task.",{"$f":"'4. Agency Staff'!E9","v":0},null,null,null,null,null,null,0]
[null,null,"Unsure",{"$f":"'4. Agency Staff'!F9","v":0},null,null,null,null,null,null,0]
[null,null,"Manage revenue collection and monitor and report on revenue captured?"]
[null,null,"Staff does not have sufficient experience to perform the task or supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!B10","v":0},null,null,null,null,null,null,{"$f":"IF(D172=\"x\",1,0)","v":0},{"$f":"IF(SUM(K172:K176)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Staff does not have sufficient experience to perform the task but is able to supervise a consultant hired to perform the task.",{"$f":"'4. Agency Staff'!C10","v":0},null,null,null,null,null,null,{"$f":"IF(D173=\"x\",1,0)","v":0}]
[null,null,"Staff has the experience to perform the task and to supervise a consultant to perform the task.",{"$f":"'4. Agency Staff'!D10","v":0},null,null,null,null,null,null,0]
[null,null,"A consultant or partner agency (such as county assessor, nonprofit civic or business organization) would perform this task.",{"$f":"'4. Agency Staff'!E10","v":0},null,null,null,null,null,null,0]
[null,null,"Unsure",{"$f":"'4. Agency Staff'!F10","v":0},null,null,null,null,null,null,0]
[]
[20,null,null,null,null,null,null,null,"Agency Staff"]
[null,null,null,"Checkmark",null,{"$f":"'4. Agency Staff'!C12","v":0}]
[null,null,"Agency is short-staffed on an ongoing basis.",{"$f":"$F$179=C180","v":false},null,null,null,null,null,null,{"$f":"IF(D180=TRUE,1,0)","v":0},{"$f":"IF(SUM(K180:K184)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Agency is somewhat understaffed or periodically short-staffed.",{"$f":"$F$179=C181","v":false},null,null,null,null,null,null,0]
[null,null,"Agency is adequately staffed to meet current program needs but does not have excess capacity to assume these new duties.",false,null,null,null,null,null,null,0]
[null,null,"Agency is sufficiently staffed with some additional capacity to assume these new duties.",false,null,null,null,null,null,null,0]
[null,null,"Agency staff has adequate capacity to assume these new duties.",false,null,null,null,null,null,null,0]
[]
[21,null,null,null,null,null,null,null,"Agency Staff"]
[null,null,null,"Checkmark",null,{"$f":"'4. Agency Staff'!C14","v":0}]
[null,null,"Yes",true,null,null,null,null,null,null,{"$f":"IF(D188=TRUE,1,0)","v":1},{"$f":"IF(SUM(K188:K191)>1,\"Please select one option\",\"\")","v":"Please select one option"}]
[null,null,"No, but there is an institutional partner in the region with access to and ability to collect this data on our behalf OR the agency intends to hire a consultant to perform these tasks.",{"$f":"$F$187=C189","v":false},null,null,null,null,null,null,0]
[null,null,"No",false,null,null,null,null,null,null,0]
[null,null,"Unsure",true,null,null,null,null,null,null,1]
[]
[22,null,null,null,null,null,null,null,"Stakeholder Environment"]
[null,null,null,"Checkmark",null,{"$f":"'5. Stakeholder Environment'!C4","v":0}]
[null,null,"Cooperation is rare or non-existent, or regulations prevent substantive cooperation",{"$f":"$F$194=C195","v":false},null,null,"C6, L1",null,null,null,{"$f":"IF(D195=TRUE,1,0)","v":0},{"$f":"IF(SUM(K195:K199)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"When cooperation occurs, it tends to be approached tentatively/with reservations ",{"$f":"$F$194=C196","v":false},null,null,"C6, L1",null,null,null,0]
[null,null,"The agencies (finance, economic development, land use planning) in our jurisdiction, governments of neighboring jurisdictions, and other levels of government (MPO, state DOT) in our region are generally collaborative and are accustomed to working together to achieve shared regional goals, though collaboration for value capture has not yet been attempted ",{"$f":"$F$194=C197","v":false},null,null,"C6, L2",null,null,null,0]
[null,null,"The agencies (finance, economic development, land use planning) in our jurisdiction, governments of neighboring jurisdictions, and other levels of government (MPO, state DOT) in our region are generally collaborative and are accustomed to working together to achieve shared regional goals, and initial discussions around value capture have taken place ",{"$f":"$F$194=C198","v":false},null,null,"C6, L3",null,null,null,0]
[null,null,"The agencies (finance, economic development, land use planning) in our jurisdiction, governments of neighboring jurisdictions, and other levels of government (MPO, state DOT) in our region participate in on-going coordination for value capture implementation ",{"$f":"$F$194=C199","v":false},null,null,"C6, L4",null,null,null,0]
[]
[23,null,null,null,null,null,null,null,"Stakeholder Environment"]
[null,null,null,"Checkmark",null,{"$f":"'5. Stakeholder Environment'!C6","v":0}]
[null,null,"Unknown",{"$f":"$F$202=C203","v":false},null,null,"C7,L1",null,null,null,{"$f":"IF(D203=TRUE,1,0)","v":0},{"$f":"IF(SUM(K203:K207)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Revenue sharing is rare or non-existent, or prevented by policies or regulation",{"$f":"$F$202=C204","v":false},null,null,"C7,L1",null,null,null,0]
[null,null,"Substantive revenue sharing has taken place and relationships with potential partner agencies have been established ",{"$f":"$F$202=C205","v":false},null,null,"C7,L2",null,null,null,0]
[null,null,"Financial mechanisms needed for value capture revenue sharing are in place under interlocal agreements/MOUs and specific projects to be funded under these agreements have been identified ",{"$f":"$F$202=C206","v":false},null,null,"C7,L3",null,null,null,0]
[null,null,"Agency participates in on-going collaborative management of value capture revenue sharing and funding support for transportation projects within agency jurisdiction ",{"$f":"$F$202=C207","v":false},null,null,"C7,L4",null,null,null,0]
[]
[24,null,null,null,null,null,null,null,"Stakeholder Environment"]
[null,null,null,"Checkmark",null,{"$f":"'5. Stakeholder Environment'!C8","v":0}]
[null,null," Strong support",false,null,null,null,null,null,null,{"$f":"IF(D211=TRUE,1,0)","v":0},{"$f":"IF(SUM(K211:K219)>1,\"Please select one option\",\"\")","v":"Please select one option"}]
[null,null,"Moderate support",{"$f":"$F$210=C212","v":false},null,null,null,null,null,null,0]
[null,null,"Weak support",true,null,null,null,null,null,null,1]
[null,null,"Mixed support and opposition",false,null,null,null,null,null,null,0]
[null,null,"Lack of understanding/familiarity or interest (neither support nor opposition)",true,null,null,null,null,null,null,1]
[null,null,"Weak opposition",false,null,null,null,null,null,null,0]
[null,null,"Moderate opposition",false,null,null,null,null,null,null,0]
[null,null,"Strong opposition",false,null,null,null,null,null,null,0]
[null,null,"Unsure or unknown",false,null,null,null,null,null,null,0]
[]
[25]
[null,null,null,null,null,null,null,null,"Stakeholder Environment"]
[null,null,"State transportation agency"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B11","v":0},null,null,null,null,null,null,{"$f":"IF(D224=\"x\",1,0)","v":0},{"$f":"IF(SUM(K224:K226)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C11","v":0},null,null,null,null,null,null,{"$f":"IF(D225=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D11","v":0},null,null,null,null,null,null,0]
[null,null,"Regional transportation authority, transit authority"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B12","v":0},null,null,null,null,null,null,{"$f":"IF(D228=\"x\",1,0)","v":0},{"$f":"IF(SUM(K228:K230)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C12","v":0},null,null,null,null,null,null,{"$f":"IF(D229=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D12","v":0},null,null,null,null,null,null,0]
[null,null,"Municipality, neighboring municipalities"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B13","v":0},null,null,null,null,null,null,{"$f":"IF(D232=\"x\",1,0)","v":0},{"$f":"IF(SUM(K232:K234)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C13","v":0},null,null,null,null,null,null,{"$f":"IF(D233=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D13","v":0},null,null,null,null,null,null,0]
[null,null,"Elected officials (including State legislature, city council, county governance board)"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B14","v":0},null,null,null,null,null,null,{"$f":"IF(D236=\"x\",1,0)","v":0},{"$f":"IF(SUM(K236:K238)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C14","v":0},null,null,null,null,null,null,{"$f":"IF(D237=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D14","v":0},null,null,null,null,null,null,0]
[null,null,"Economic development agency, tourism bureau"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B15","v":0},null,null,null,null,null,null,{"$f":"IF(D240=\"x\",1,0)","v":0},{"$f":"IF(SUM(K240:K242)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C15","v":0},null,null,null,null,null,null,{"$f":"IF(D241=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D15","v":0},null,null,null,null,null,null,0]
[null,null,"Neighborhood and community groups"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B16","v":0},null,null,null,null,null,null,{"$f":"IF(D244=\"x\",1,0)","v":0},{"$f":"IF(SUM(K244:K246)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C16","v":0},null,null,null,null,null,null,{"$f":"IF(D245=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D16","v":0},null,null,null,null,null,null,0]
[null,null,"Developers, Real Estate sales community, site selectors "]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B17","v":0},null,null,null,null,null,null,{"$f":"IF(D248=\"x\",1,0)","v":0},{"$f":"IF(SUM(K248:K250)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C17","v":0},null,null,null,null,null,null,{"$f":"IF(D249=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D17","v":0},null,null,null,null,null,null,0]
[null,null,"Major employers, industry groups, chamber of commerce"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B18","v":0},null,null,null,null,null,null,{"$f":"IF(D252=\"x\",1,0)","v":0},{"$f":"IF(SUM(K252:K254)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C18","v":0},null,null,null,null,null,null,{"$f":"IF(D253=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D18","v":0},null,null,null,null,null,null,0]
[null,null,"Other civic partners (hospitals, community colleges and universities, nonprofit organizations, charitable foundations)"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B19","v":0},null,null,null,null,null,null,{"$f":"IF(D256=\"x\",1,0)","v":0},{"$f":"IF(SUM(K256:K258)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C19","v":0},null,null,null,null,null,null,{"$f":"IF(D257=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D19","v":0},null,null,null,null,null,null,0]
[null,null,"Taxpayers"]
[null,null,"Little to No Engagement",{"$f":"'5. Stakeholder Environment'!B20","v":0},null,null,null,null,null,null,{"$f":"IF(D260=\"x\",1,0)","v":0},{"$f":"IF(SUM(K260:K262)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Some or Passive Engagement",{"$f":"'5. Stakeholder Environment'!C20","v":0},null,null,null,null,null,null,{"$f":"IF(D261=\"x\",1,0)","v":0}]
[null,null,"Active Engagement  ",{"$f":"'5. Stakeholder Environment'!D20","v":0},null,null,null,null,null,null,0]
[]
[26,null,null,null,null,null,null,null,"Stakeholder Environment"]
[null,null,null,"Checkmark",null,{"$f":"'5. Stakeholder Environment'!C22","v":0}]
[null,null,"No engagement related to value capture ",{"$f":"$F$265=C266","v":false},null,null,"C3,L1",null,null,null,{"$f":"IF(D266=TRUE,1,0)","v":0},{"$f":"IF(SUM(K266:K274)>1,\"Please select one option\",\"\")","v":""}]
[null,null,"Initial discussions with interested private sector stakeholders and/or some engagement with other agencies regarding value capture",{"$f":"$F$265=C267","v":false},null,null,"C3,L2",null,null,null,0]
[null,null,"Have substantively engaged with private sector stakeholders about value capture and identified private sector supporters",false,null,null,"C3,L2",null,null,null,0]
[null,null,"Have substantively engaged with public sector stakeholders and identified willing advocates to assist in communicating value capture to constituencies ",false,null,null,"C3, L3",null,null,null,0]
[null,null,"Agency has established ongoing working relationships with both public and private sector stakeholders on projects involving value capture",false,null,null,"C3, L4",null,null,null,0]
[null,null,"Other ",false,null,null,"C3, L1",null,null,null,0]

{"sheet":"Internal READme","index":10,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"NOTES: "]
[1,"Column AA in each question sheet has all list references hidden (white background, white text). For drop down boxes and citations for CMM directly linked questions"]
[null,"All links in \"Internal Developer\""]
[2,"Tab Names shouldn't be changed or will break macros"]
[3,"Unlock via macros. Set password."]