{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Introduction","1. Stakeholders","2. Goals","3. Property Inventory","4. Property Characteristics","5. Land Use Characteristics","6. Environmental","7. Community","8. Demographics","9. Market Assessment","10. Revitalization Summary","11. Constraints","12. Pro Forma Data Inputs","13. Pro Forma Tool","14. Sources and Uses"],"not_rendered":{"images":2,"defined_names":7,"comments":7},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":51,"n_cols":3,"rows_kept":51,"merged":[[20,0,20,9],[23,0,23,8],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[40,0,40,9],[44,0,44,1],[44,2,44,9],[46,2,46,9],[48,2,48,9],[50,2,50,9]]}
{"$rows_empty":18}
["Office of Land and Emergency Management (5101T)│EPA-560-F-21-193│November 2021│www.epa.gov/brownfields"]
[]
["This Revitalization-Ready Workbook and the accompanying Revitalization-Ready Manual are companions to the Revitalization Ready Guide. "]
["Revitalization-Ready How-to Manual"]
["Revitalization-Ready Guide"]
["These are intended to support and facilitate the decision-making process for the redevelopment of underutilized and/or abandoned properties that may be contaminated. This Revitalization Ready Workbook consists of fourteen property-related tabs. It is designed to guide the collection of data to support land use decision making and to compare the viability of reuse options against one another. The purpose of this Workbook is not to identify a single land use, but to highlight strengths and weaknesses associated with particular land uses. Links to the sections in this Workbook are below:"]
[]
["1.     Stakeholders"]
["2.     Goals"]
["3.     Property Inventory"]
["4.     Property Characteristics"]
["5.     Land use characteristics"]
["6.     Environmental"]
["7.     Community"]
["8.     Demographics"]
["9.     Market Assessment"]
["10.   Revitalization Summary"]
["11.   Constraints"]
["12.   Pro Forma Data Inputs"]
["13.   Pro Forma tool"]
["14.   Sources and Uses Chart"]
[]
["Developers and end users commonly ask the questions presented in this Revitalization-Ready Workbook before embarking on a new development. By collecting the data needed to respond to each question, communities will be equipped with the key information and terminology needed to move sites forward in the development process."]
[]
["This Revitalization-Ready Workbook includes four types of questions:"]
[]
["Project specific",null,"These questions document information about the project and support the organization of the effort to revitalize a property."]
[]
["Data specific",null,"These questions require you to collect and enter specific data about the property, region and real estate market. Some of this data will directly feed into other sections of the workbook. This data should be evaluated when you determine the potential scope and size of the future development."]
[]
["Land Use Criteria ",null,"Certain questions directly affect the feasibility of a particular land use. The questions are intended to draw out the strengths and weaknesses associated with particular land uses at a particular site. Land Use Criteria questions may reflect site conditions or location, rely on data or require subjective input. These questions often directly affect the Tool scoring."]
[]
["Subjective",null,"These questions ask you to rely on your knowledge of the property, community and region to provide insight into the potential land use options. While these questions are often not scored, the information should be used in evaluating potential reuse options."]

{"sheet":"1. Stakeholders","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"merged":[[0,0,0,5],[3,1,3,5]]}
["Enter Stakeholder Information in the cells below that are formatted in red dots similar to the format in this cell.",{"$nulls":15},"ready"]
[{"$f":"IF(B4=\"\",\"\",B4)","v":""}]
["Stakeholders"]
["Project Name/Identifier"]
["Stakeholder Name","Stakeholder Category","Stakeholder Type","Address","Phone","Email",{"$nulls":10},"Stakeholder Type"]
[{"$nulls":16},"Advisor"]
[{"$nulls":16},"Stakeholder"]
[]
[{"$nulls":16},"Stakeholder Category"]
[{"$nulls":16},"Property Owner"]
[{"$nulls":16},"Developer/Developer Team"]
[{"$nulls":16},"Equity Investor (Fund or a Wealthy Investor)"]
[{"$nulls":16},"Potential Buyers"]
[{"$nulls":16},"Local Government"]
[{"$nulls":16},"Regional Government"]
[{"$nulls":16},"Neighborhood Associations"]
[{"$nulls":16},"Community Groups"]
[{"$nulls":16},"NGO/Nonprofit Organization"]
[{"$nulls":16},"Public Sector Other"]
[{"$nulls":16},"Investors"]
[{"$nulls":16},"Lenders"]
[{"$nulls":16},"Insurers"]
[{"$nulls":16},"Private Sector Other"]
[{"$nulls":16},"State and Federal Regulators"]
[{"$nulls":16},"Environmental Support"]
[{"$nulls":16},"Legal Support"]
[{"$nulls":16},"Local Business"]
[{"$nulls":16},"Business Organization"]
[{"$nulls":16},"Educational Institutions"]
[{"$nulls":16},"Real Estate Professional"]
[{"$nulls":16},"Religious Organizations"]
[{"$nulls":16},"Other"]

{"sheet":"2. Goals","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[0,0,0,1]]}
["Enter Goal Information in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Goal"]
["What do you hope to accomplish?",null,null,"Measurable: Quantify your goal. How will you know if you’ve achieved it or not?"]
["What are the reasons for the project?"]
["What are the needs of the community to be addressed?",null,null,"Specific: Don’t be vague. Exactly what do you want?"]
["What are the potential benefits?",null,null,"Attainable: Be honest with yourself about what you can reasonably accomplish at this point in your life while taking into consideration your current responsibilities."]
["What are potential obstacles?"]
["What are your priorities?"]
["What is your anticipate timing or schedule to achieve results?"]
["What are the short-term components (What needs to be accomplished first)?"]
["What are the medium-term components?"]
["What are the long-term components?"]
[]
["Goal Statement"]

{"sheet":"3. Property Inventory","index":3,"n_rows":75,"n_cols":19,"rows_kept":75,"merged":[[0,0,0,10]]}
["Enter Property Information in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Property Parcels (Enter Individual Parcel Information in Columns Across Row 4) "]
["Property ID (Name)"]
["Address (Primary Street)"]
["Tax Map Parcel Number(s)"]
["Owner Name"]
["Owner Address"]
["Owner City"]
["Owner State"]
["Owner Type"]
["Parcel Size (Total Acres)"]
["Appraised Value ($) "]
["Annual Tax ($)"]
["Tax Status"]
["Tax Delinquent Amount"]
["Current/Recent Past Property Use "]
["Property Status"]
["Property Condition"]
["Structure Type"]
["Structure Occupancy"]
["Structure Condition"]
["Historical Significance"]
["Priority "]
[]
[]
[]
[]
[]
[]
[{"$nulls":16},"Owner Type"]
[{"$nulls":16},"Private"]
[{"$nulls":16},"Municipal"]
[{"$nulls":16},"NGO/Non-profit"]
[{"$nulls":16},"Other Government entity"]
[{"$nulls":16},"Unknown"]
[]
[{"$nulls":16},"Tax Status"]
[{"$nulls":16},"Current"]
[{"$nulls":16},"Delinquent"]
[{"$nulls":16},"Exempt"]
[{"$nulls":16},"Unknown"]
[]
[{"$nulls":16},"Current/Recent Past Use",null,"HistoricalSignificance"]
[{"$nulls":16},"Residential",null,"Listed on federal or state register"]
[{"$nulls":16},"Commercial-Retail",null,"Other designation"]
[{"$nulls":16},"Commercial-Other",null,"None"]
[{"$nulls":16},"Manufacturing",null,"Unknown"]
[{"$nulls":16},"Industrial"]
[{"$nulls":16},"Warehouse"]
[]
[{"$nulls":16},"Structure Occupancy",null,"Property Occupancy"]
[{"$nulls":16},"No Structure",null,"Vacant"]
[{"$nulls":16},"Unoccupied",null,"Unoccupied"]
[{"$nulls":16},"Occupied",null,"Occupied"]
[{"$nulls":16},"Unknown"]
[]
[{"$nulls":16},"Structure Condition",null,"Priority"]
[{"$nulls":16},"No Structure",null,"High Priority Reuse"]
[{"$nulls":16},"Excellent",null,"Medium Priority Reuse"]
[{"$nulls":16},"Good",null,"Low Priority Reuse"]
[{"$nulls":16},"Fair"]
[{"$nulls":16},"Poor"]
[{"$nulls":16},"Demolition"]
[{"$nulls":16},"Unusable"]
[]
[{"$nulls":16},"Structure Type"]
[{"$nulls":16},"No Structure",null,"Property Condition"]
[{"$nulls":16},"Residential-Single Family",null,"Maintained"]
[{"$nulls":16},"Residential-Multi-Family",null,"Overgrown"]
[{"$nulls":16},"Commercial-Retail",null,"Trash/Debris"]
[{"$nulls":16},"Commercial"]
[{"$nulls":16},"Industrial"]
[{"$nulls":16},"Warehouse"]
[{"$nulls":16},"Other"]

{"sheet":"4. Property Characteristics","index":4,"n_rows":79,"n_cols":17,"rows_kept":79,"merged":[[0,0,0,11],[51,3,51,11],[52,3,52,11],[53,3,53,11],[54,3,54,11],[55,3,55,11],[56,3,56,11],[57,3,57,11],[58,3,58,11],[59,3,59,11],[60,3,60,11]]}
["Enter Property Characteristics in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Property ",{"$nulls":12},"Acreage Calculation",null,null,"Validation Lists"]
[{"$nulls":16},"Yes"]
["Property size",null,"acres",{"$nulls":10},"Total acreage",{"$f":"B5","v":{"v":0,"d":"0.0"}},null,"No"]
[{"$nulls":16},"Unknown"]
["For the remaining property questions, if restricted acreage falls into more than one category, report it only one time "]
["Does any portion of the property contain wetlands?",{"$nulls":15},"Building Type"]
[{"$f":"IF(B8=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B8=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less wetlands",{"$f":"IF(B9>0,O5-B9,IF(B11>0,(O5-($O$5*B11)),O5))","v":0},null,"Residential"]
[{"$f":"IF(B8=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B8=\"Yes\",\" Or what percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both",{"$nulls":12},"Office"]
[{"$nulls":16},"Industrial"]
["Is any portion of the property in a 100 year flood plain?",{"$nulls":15},"Retail"]
[{"$f":"IF(B13=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B13=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less flood plain",{"$f":"IF(B14>0,O9-B14,IF(B16>0,(O9-($O$5*B16)),O9))","v":0},null,"Mixed Use"]
[{"$f":"IF(B13=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B13=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both",{"$nulls":12},"Other"]
[{"$f":"IF(B13=\"Yes\",\"Do state and local building codes allow structures in flood plain areas?\",\"\")","v":""},null,{"$f":"IF(AND(B17=\"Yes\",OR(D17=0,D17<>\"\")),\"Briefly describe limitations:\",\"\")","v":""}]
[]
["Does any portion of the property contain endangered species or protected habitat?",{"$nulls":15},"Building Condition"]
[{"$f":"IF(B19=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B19=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less habitat",{"$f":"IF(B20>0,O14-B20,IF(B22>0,(O14-($O$5*B22)),O14))","v":0},null,"Poor"]
[{"$f":"IF(B19=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B19=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both",{"$nulls":12},"Fair"]
[{"$nulls":16},"Good"]
["Does any portion of the property contain archaeologically sensitive areas?",{"$nulls":15},"Excellent"]
[{"$f":"IF(B24=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B24=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less archaeologically",{"$f":"IF(B25>0,O20-B25,IF(B27>0,(O20-($O$5*B27)),O20))","v":0}]
[{"$f":"IF(B24=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B24=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both",{"$nulls":12},"Residential"]
[{"$nulls":16},"Commercial (Professional/Office)"]
["Does any portion of the property contain slopes greater than 15%?",{"$nulls":15},"Retail"]
[{"$f":"IF(B29=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B29=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less slopes",{"$f":"IF(B30>0,O25-B30,IF(B32>0,(O25-($O$5*B32)),O25))","v":0},null,"Industrial (excluding warehouse)"]
[{"$f":"IF(B29=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B29=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both",{"$nulls":12},"Warehouse Distribution"]
[{"$nulls":16},"Hotel/Hospitality"]
["Does any portion of the property contain easements preventing development?",{"$nulls":15},"Mixed Use"]
[{"$f":"IF(B34=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B34=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less easements",{"$f":"IF(B35>0,O30-B35,IF(B37>0,(O30-($O$5*B37)),O30))","v":0},null,"Energy"]
[{"$f":"IF(B34=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B34=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both",{"$nulls":12},"Greenspace"]
[{"$nulls":16},"Government"]
["Does any portion of the property contain deed restrictions (engineering controls or land use restrictions) preventing all types of development?"]
[{"$f":"IF(B39=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B39=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less deed",{"$f":"IF(B40>0,O35-B40,IF(B42>0,(O35-($O$5*B42)),O35))","v":0}]
[{"$f":"IF(B39=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B39=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both"]
[]
["Are there other areas of land that are not available for development (e.g., narrow portions of the site that will not support development)?"]
[{"$f":"IF(B44=\"Yes\",\"How much acreage?\",\"\")","v":""},null,{"$f":"IF(B44=\"Yes\",\"acres\",\"\")","v":""},"<=Please report data as acres OR as a percentage, not both",{"$nulls":9},"Less other areas",{"$f":"IF(B45>0,O40-B45,IF(B47>0,(O40-($O$5*B47)),O40))","v":0}]
[{"$f":"IF(B44=\"Yes\",\"-OR-\",\"\")","v":""}]
[{"$f":"IF(B44=\"Yes\",\" What percentage of the property?\",\"\")","v":""},null,null,"<=Please report data as acres OR as a percentage, not both"]
[]
["Usable acreage available for development",{"$f":"IF(O45>=0,O45,\"\")","v":0},{"$f":"IF(B49=\"\",\"\",\"acres\")","v":"acres"}]
[]
["Is the remaining acreage available for development viable for any land use type?  (see General Planning Considerations section of handbook)"]
[{"$f":"IF($B$51=\"Yes\",Q27,\"\")","v":""},null,{"$f":"IF(AND(B52=\"Yes\",D52=0),\"Provide rationale:\",IF(AND(B52=\"yes\",D52<>\"\"),\"Rationale:\",\"\"))","v":""}]
[{"$f":"IF($B$51=\"Yes\",Q28,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q29,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q30,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q32,\"\")","v":""},null,{"$f":"IF(AND(B56=\"Yes\",D56=0),\"Provide rationale:\",IF(AND(B56=\"yes\",D56<>\"\"),\"Rationale:\",\"\"))","v":""}]
[{"$f":"IF($B$51=\"Yes\",Q33,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q34,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q35,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q37,\"\")","v":""},null,""]
[{"$f":"IF($B$51=\"Yes\",Q38,\"\")","v":""},null,""]
[]
["Buildings and Miscellaneous Structures"]
["Are there buildings or structures onsite?"]
[{"$f":"IF(B64=\"Yes\",\"How many buildings or structures are onsite? (Can enter up to ten)\",\"\")","v":""},null,{"$f":"IF(AND(B64=\"Yes\",B65>10),\"Enter the ten most significant buildings/structures onsite\",\"\")","v":""}]
[]
[null,"Structure type/use","Approximate structure size (SF)","Number of floors","Building age (Years)","Structure condition","Demolition required?","Does structure contain asbestos, lead paint or other hazardous building components?","Abatement cost\n(only enter if building contain asbestos, lead paint, mercury containing light ballasts, or other hazardous building components)","Number of existing parking spaces","Amount of existing parking area (SF)","Building eligible for historic tax credits?"]
[{"$f":"IF($B$65>=1,\"Building/structure #1\",\"\")","v":""}]
[{"$f":"IF($B$65>1,\"Building/structure #2\",\"\")","v":""}]
[{"$f":"IF($B$65>2,\"Building/structure #3\",\"\")","v":""}]
[{"$f":"IF($B$65>3,\"Building/structure #4\",\"\")","v":""}]
[{"$f":"IF($B$65>3,\"Building/structure #5\",\"\")","v":""}]
[{"$f":"IF($B$65>5,\"Building/structure #6\",\"\")","v":""}]
[{"$f":"IF($B$65>6,\"Building/structure #7\",\"\")","v":""}]
[{"$f":"IF($B$65>7,\"Building/structure #8\",\"\")","v":""}]
[{"$f":"IF($B$65>8,\"Building/structure #9\",\"\")","v":""}]
[{"$f":"IF($B$65>9,\"Building/structure #10\",\"\")","v":""}]
[]
["TOTAL for all buildings/structures",null,{"$f":"SUM(C68:C77)","v":0},{"$nulls":5},{"$f":"SUM(I68:I77)","v":{"v":0,"d":"$0"}},{"$f":"SUM(J68:J77)","v":0},{"$f":"SUM(K68:K77)","v":0}]

{"sheet":"5. Land Use Characteristics","index":5,"n_rows":106,"n_cols":17,"rows_kept":106,"merged":[[0,0,0,2]]}
["Enter land use characteristics in in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Utilities",{"$nulls":3},"Validation Lists",null,null,"Residential","Commercial (Professional/Office)","Retail","Industrial (excluding warehouse)","Warehouse Distribution","Hotel/Hospitality","Mixed Use","Energy","Greenspace","Government"]
["Is electricity available onsite?",{"$nulls":3},"Yes",null,"SUBTOTAL",{"$f":"IF(MAX(H5:H119)=999,999,SUM(H5:H119))","v":0},{"$f":"IF(MAX(I5:I119)=999,999,SUM(I5:I119))","v":0},0,0,0,0,0,0,0,0]
[{"$f":"IF(B4=\"No\",\"If not, how far away is the nearest electricity connection?\",\"\")","v":""},{"$nulls":3},"No",null,null,{"$f":"IF($B4=\"Yes\",1,0)","v":0},0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Unavailable in community",null,null,{"$f":"IF($B5=$E$8,0,IF($B5=$E$9,-1,0))","v":0},0,0,0,0,0,0,0,{"$f":"IF($B5=$E$8,0,IF($B5=$E$9,0,0))","v":0},0]
["Are there opportunities for renewable energy production on the property such as wind, solar, or water?",{"$nulls":9},{"$f":"IF($B$7=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B$7=\"Yes\",1,0)","v":0}]
[{"$nulls":4},"Less than 0.5 miles"]
["Is potable water available onsite?",{"$nulls":3},"Greater than 0.5 miles",null,null,{"$f":"IF($B9=\"Yes\",1,IF($B9=\"No\",0,IF($B9=$E$6,-2,0)))","v":0},{"$f":"IF($B9=\"Yes\",1,IF($B9=\"No\",0,IF($B9=$E$6,-2,0)))","v":0},0,0,0,0,0,0,{"$f":"IF($B9=\"Yes\",1,IF($B9=\"No\",0,IF($B9=$E$6,-1,0)))","v":0},0]
[{"$f":"IF(B9=\"No\",\"If not, how far away is the nearest public water access?\",\"\")","v":""},{"$nulls":6},{"$f":"IF($B10=$E$8,-1,IF($B10=$E$9,-2,0))","v":0},{"$f":"IF($B10=$E$8,-1,IF($B10=$E$9,-2,0))","v":0},0,0,0,0,0,0,{"$f":"IF($B10=$E$8,-1,IF($B10=$E$9,-1,0))","v":0},0]
[{"$f":"IF(OR(B9=\"Unavailable in Community\",B9=\"No\"),\"Is there potable well water onsite?\",\"\")","v":""},{"$nulls":3},"Low",null,null,{"$f":"IF($B11=\"Yes\",1,IF($B11=\"No\",-1,0))","v":0},{"$f":"IF($B11=\"Yes\",1,IF($B11=\"No\",-1,0))","v":0},{"$f":"IF($B11=\"Yes\",1,IF($B11=\"No\",-1,0))","v":0},{"$f":"IF($B11=\"Yes\",-1,IF($B11=\"no\",-1,0))","v":0},{"$f":"IF($B11=\"Yes\",-1,IF($B11=\"no\",-1,0))","v":0},{"$f":"IF($B11=\"Yes\",1,IF($B11=\"No\",-1,0))","v":0},{"$f":"IF($B11=\"Yes\",1,IF($B11=\"No\",-1,0))","v":0},null,null,{"$f":"IF($B11=\"Yes\",1,IF($B11=\"No\",-1,0))","v":0}]
[{"$nulls":4},"Medium to high"]
["Is non-potable (industrial) water available onsite?",{"$nulls":3},"Extremely high",{"$nulls":5},{"$f":"IF($B13=\"Yes\",1,IF($B13=\"No\",0,IF($B13=$E$6,-2,0)))","v":0}]
[{"$f":"IF(B13=\"No\",\"If not, how far away is the nearest water access?\",\"\")","v":""},{"$nulls":9},{"$f":"IF($B14=$E$8,-1,IF($B14=$E$9,-2,0))","v":0}]
[{"$f":"IF(OR(B13=\"Unavailable in Community\",B13=\"No\"),\"Is there industrial well water onsite?\",\"\")","v":""},{"$nulls":3},"<0.25 mile",{"$nulls":5},{"$f":"IF($B15=\"Yes\",-1,IF($B15=\"no\",-1,0))","v":0}]
[{"$nulls":4},"0.25 – 1 mile"]
["Is a sanitary sewer connections available onsite?",{"$nulls":3}," 1 mile or more",null,null,{"$f":"IF($B17=\"Yes\",1,IF($B17=\"No\",0,IF($B17=$E$6,-2,0)))","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B17=\"No\",\"If not, how far away is the nearest sanitary sewer capacity?\",\"\")","v":""},{"$nulls":6},{"$f":"IF($B18=$E$8,-1,IF($B18=$E$9,-2,0))","v":0},{"$f":"IF($B18=$E$8,-1,IF($B18=$E$9,-2,0))","v":0},0,0,0,0,0,0,0,0]
[{"$f":"IF(B17=\"Unavailable in Community\",\"If sanitary sewer is unavailable in the community, is there an existing sanitary septic system onsite?\",\"\")","v":""},{"$nulls":6},{"$f":"IF($B19=\"Yes\",1,IF($B19=\"No\",-1,0))","v":0},{"$f":"IF($B19=\"Yes\",1,IF($B19=\"No\",-1,0))","v":0},{"$f":"IF($B19=\"Yes\",1,IF($B19=\"No\",-1,0))","v":0},{"$f":"IF($B19=\"Yes\",-1,IF($B19=\"no\",-1,0))","v":0},{"$f":"IF($B19=\"Yes\",-1,IF($B19=\"no\",-1,0))","v":0},{"$f":"IF($B19=\"Yes\",1,IF($B19=\"No\",-1,0))","v":0},{"$f":"IF($B19=\"Yes\",1,IF($B19=\"No\",-1,0))","v":0},null,null,{"$f":"IF($B19=\"Yes\",1,IF($B19=\"No\",-1,0))","v":0}]
[]
["Is cable, fiber optics, T1 or other digital service available onsite?",{"$nulls":6},{"$f":"IF($B21=\"Yes\",1,0)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B21=\"No\",\"If not, how far away to nearest cable, fiber optics, T1 or other digital service connection?\",\"\")","v":""},{"$nulls":6},{"$f":"IF($B22=$E$8,0,IF($B22=$E$9,-1,0))","v":0},0,0,0,0,0,0,0,0,0]
[]
["What are the average costs per KWh for electricity in the area?",null,"cents per KWh",{"$nulls":5},{"$f":"IF($B24=0,0,IF($B24<8.75,1,IF(AND($B24>8.75,$B24<10.75),0,IF($B24>10.75,-1,0))))","v":0},null,{"$f":"IF($B24=0,0,IF($B24<8.75,1,IF(AND($B24>8.75,$B24<10.75),0,IF($B24>10.75,-1,0))))","v":0},{"$f":"IF($B24=0,0,IF($B24<8.75,1,IF(AND($B24>8.75,$B24<10.75),0,IF($B24>10.75,-1,0))))","v":0},null,null,{"$f":"IF($B24>10.75,1,0)","v":0}]
[]
[]
["Zoning"]
["What is the current zoning on the property? (enter name of zoning code)"]
[]
["What are the allowable use(s) under the zone? (select Yes or No for each)"]
["Residential",{"$nulls":6},{"$f":"IF($B31=\"Yes\",1,IF($B31=\"No\",-1,0))","v":0}]
["Commercial (Professional/Office)",{"$nulls":7},{"$f":"IF($B32=\"Yes\",1,IF($B32=\"No\",-1,0))","v":0}]
["Retail",{"$nulls":8},{"$f":"IF($B33=\"Yes\",1,IF($B33=\"No\",-1,0))","v":0}]
["Industrial (excluding warehouse)",{"$nulls":9},{"$f":"IF($B34=\"Yes\",1,IF($B34=\"No\",-1,0))","v":0}]
["Warehouse Distribution",{"$nulls":10},{"$f":"IF($B35=\"Yes\",1,IF($B35=\"No\",-1,0))","v":0}]
["Hotel/Hospitality",{"$nulls":11},{"$f":"IF($B36=\"Yes\",1,IF($B36=\"No\",-1,0))","v":0}]
["Mixed Use",{"$nulls":12},{"$f":"IF($B37=\"Yes\",1,IF($B37=\"No\",-1,0))","v":0}]
["Energy",{"$nulls":13},{"$f":"IF($B38=\"Yes\",1,IF($B38=\"No\",-1,0))","v":0}]
["Greenspace",{"$nulls":14},{"$f":"IF($B39=\"Yes\",1,IF($B39=\"No\",-1,0))","v":0}]
["Government",{"$nulls":15},{"$f":"IF($B40=\"Yes\",1,IF($B40=\"No\",-1,0))","v":0}]
[]
["What future land uses are supported by local development plans and initiatives? (select Yes or No for each)"]
["Residential",{"$nulls":6},{"$f":"IF($B43=\"Yes\",1,IF($B43=\"No\",-1,0))","v":0}]
["Commercial (Professional/Office)",{"$nulls":7},{"$f":"IF($B44=\"Yes\",1,IF($B44=\"No\",-1,0))","v":0}]
["Retail",{"$nulls":8},{"$f":"IF($B45=\"Yes\",1,IF($B45=\"No\",-1,0))","v":0}]
["Industrial (excluding warehouse)",{"$nulls":9},{"$f":"IF($B46=\"Yes\",1,IF($B46=\"No\",-1,0))","v":0}]
["Warehouse Distribution",{"$nulls":10},{"$f":"IF($B47=\"Yes\",1,IF($B47=\"No\",-1,0))","v":0}]
["Hotel/Hospitality",{"$nulls":11},{"$f":"IF($B48=\"Yes\",1,IF($B48=\"No\",-1,0))","v":0}]
["Mixed Use",{"$nulls":12},{"$f":"IF($B49=\"Yes\",1,IF($B49=\"No\",-1,0))","v":0}]
["Energy",{"$nulls":13},{"$f":"IF($B50=\"Yes\",1,IF($B50=\"No\",-1,0))","v":0}]
["Greenspace",{"$nulls":14},{"$f":"IF($B51=\"Yes\",1,IF($B51=\"No\",-1,0))","v":0}]
["Government",{"$nulls":15},{"$f":"IF($B52=\"Yes\",1,IF($B52=\"No\",-1,0))","v":0}]
[]
["Based upon your knowledge of land use policies and the community, should any use be designated as May Not be Viable? (select Yes or No for each)"]
["Residential",null,{"$f":"IF(AND(B55=\"Yes\",D55=0),\"Rationale:\",IF(AND(B55=\"yes\",D55<>\"\"),\"Rationale:\",\"\"))","v":""},{"$nulls":4},{"$f":"IF($B55=\"Yes\",999,0)","v":0}]
["Commercial (Professional/Office)",null,{"$f":"IF(AND(B56=\"Yes\",D56=0),\"Rationale:\",IF(AND(B56=\"yes\",D56<>\"\"),\"Rationale:\",\"\"))","v":""},{"$nulls":5},{"$f":"IF($B56=\"Yes\",999,0)","v":0}]
["Retail",null,"",{"$nulls":6},{"$f":"IF($B57=\"Yes\",999,0)","v":0}]
["Industrial (excluding warehouse)",null,"",{"$nulls":7},{"$f":"IF($B58=\"Yes\",999,0)","v":0}]
["Warehouse Distribution",null,"",{"$nulls":8},{"$f":"IF($B59=\"Yes\",999,0)","v":0}]
["Hotel/Hospitality",null,"",{"$nulls":9},{"$f":"IF($B60=\"Yes\",999,0)","v":0}]
["Mixed Use",null,"",{"$nulls":10},{"$f":"IF($B61=\"Yes\",999,0)","v":0}]
["Energy",null,"",{"$nulls":11},{"$f":"IF($B62=\"Yes\",999,0)","v":0}]
["Greenspace",null,"",{"$nulls":12},{"$f":"IF($B63=\"Yes\",999,0)","v":0}]
["Government",null,"",{"$nulls":13},{"$f":"IF($B64=\"Yes\",999,0)","v":0}]
[]
["Maximum allowable lot coverage under local land use regulations (%)",null,{"$f":"IF(B66=1,\"Maximum allowable lot coverage of 100% is unusual. Recheck data entry.\",\"\")","v":""}]
[]
["Floor to area ratio under local land use regulations "]
["Or maximum allowable height under local land use regulations ",null,"stories"]
[]
["Required number of parking spaces per allowable use under local land use regulations"]
[]
["Location",{"$nulls":6},"Residential","Commercial (Professional/Office)","Retail","Industrial (excluding warehouse)","Warehouse Distribution","Hotel/Hospitality","Mixed Use","Energy","Greenspace","Government"]
["Are access roads in good condition?",{"$nulls":7},{"$f":"IF($B74=\"No\",-1,0)","v":0},null,{"$f":"IF($B74=\"No\",-1,0)","v":0},{"$f":"IF($B74=\"No\",-1,0)","v":0},{"$f":"IF($B74=\"No\",-1,0)","v":0}]
[]
["What traffic volume can access roads support?",{"$nulls":6},{"$f":"IF($B76=\"Extremely high\",-1,0)","v":0},{"$f":"IF($B76=\"Low\",-1,IF($B76=\"Extremely high\",1,0))","v":0},{"$f":"IF($B76=\"Low\",-1,IF($B76=\"Extremely high\",1,0))","v":0},{"$f":"IF($B76=\"Low\",-1,IF($B76=\"Extremely high\",1,0))","v":0},{"$f":"IF($B76=\"Low\",999,IF($B76=\"Extremely high\",1,0))","v":0},{"$f":"IF($B76=\"Low\",-1,0)","v":0},{"$f":"IF($B76=\"Low\",-1,IF($B76=\"Extremely high\",1,0))","v":0}]
[]
["What is the daily traffic count on the primary access road?",{"$nulls":6},{"$f":"IF($B78>20000,-1,0)","v":0},null,{"$f":"IF(AND($B78<1000,$B78>0),999,IF(AND($B78<10000,$B78>0),-1,0))","v":0},null,null,{"$f":"IF(AND($B78<10000,$B78>0),-1,0)","v":0}]
[]
["What is the daily traffic count at the nearest intersection?"]
[]
["What are the neighboring land uses? (select Yes or No for each)"]
["Residential",{"$nulls":6},{"$f":"IF($B83=\"Yes\",1,0)","v":0},{"$f":"IF($B83=\"Yes\",-1,0)","v":0},null,{"$f":"IF($B83=\"Yes\",-1,0)","v":0},{"$f":"IF($B83=\"Yes\",-1,0)","v":0},null,null,{"$f":"IF($B83=\"Yes\",-1,0)","v":0}]
["Office or Retail",{"$nulls":12},{"$f":"IF($B84=\"Yes\",1,0)","v":0}]
["Industrial",{"$nulls":6},{"$f":"IF($B85=\"Yes\",-1,0)","v":0},null,null,{"$f":"IF($B85=\"Yes\",1,0)","v":0},{"$f":"IF($B85=\"Yes\",1,0)","v":0},null,{"$f":"IF($B85=\"Yes\",-1,0)","v":0},{"$f":"IF($B85=\"Yes\",1,0)","v":0}]
["Mixed Use",{"$nulls":11},{"$f":"IF($B86=\"Yes\",1,0)","v":0}]
[]
["Access and Visibility"]
["Is the property centrally located in the community?",{"$nulls":8},{"$f":"IF($B89=\"No\",-1,0)","v":0},{"$f":"IF($B89=\"Yes\",-1,0)","v":0},{"$f":"IF($B89=\"Yes\",-1,0)","v":0},{"$f":"IF($B89=\"No\",-1,0)","v":0},{"$f":"IF($B89=\"No\",-1,IF($B89=\"Yes\",1,0))","v":0},{"$f":"IF($B89=\"Yes\",-1,0)","v":0}]
[]
["Is property located on a major (multi-lane) roadway?",{"$nulls":6},{"$f":"IF($B91=\"Yes\",-1,0)","v":0},{"$f":"IF($B91=\"Yes\",1,0)","v":0},{"$f":"IF($B91=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B91=\"Yes\",1,0)","v":0},null,{"$f":"IF($B91=\"Yes\",-1,0)","v":0}]
["Is the property located at a major intersection?",{"$nulls":6},{"$f":"IF($B92=\"Yes\",-1,0)","v":0},{"$f":"IF($B92=\"Yes\",1,0)","v":0},{"$f":"IF($B92=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B92=\"Yes\",1,0)","v":0},null,{"$f":"IF($B92=\"Yes\",-1,0)","v":0}]
["What is the distance to an Interstate?",{"$nulls":6},{"$f":"IF($B93=$E$15,-1,0)","v":0},{"$f":"IF($B93=$E$16,1,0)","v":0},null,null,{"$f":"IF($B93=$E$17,999,0)","v":0}]
["Is the property visible from a major multi-lane roadway?",{"$nulls":7},{"$f":"IF($B94=\"Yes\",1,0)","v":0},{"$f":"IF($B94=\"Yes\",1,IF($B94=\"No\",-1,0))","v":0}]
[]
["Is the property within close proximity to passenger rail access?",{"$nulls":7},{"$f":"IF($B96=\"Yes\",1,0)","v":0},{"$nulls":4},{"$f":"IF($B96=\"Yes\",1,0)","v":0}]
["Does the property have cargo rail spurs onsite?",{"$nulls":9},{"$f":"IF($B97=\"Yes\",1,0)","v":0},{"$f":"IF($B97=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B97=\"Yes\",1,0)","v":0}]
["Is the property within close proximity to cargo rail access?",{"$nulls":9},{"$f":"IF($B98=\"Yes\",1,0)","v":0},{"$f":"IF($B98=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B98=\"Yes\",1,0)","v":0}]
[]
["Is public transportation available?",{"$nulls":6},{"$f":"IF($B100=\"Yes\",1,0)","v":0},{"$f":"IF($B100=\"Yes\",1,0)","v":0},{"$nulls":4},{"$f":"IF($B100=\"Yes\",1,0)","v":0}]
["Can the public easily walk or bike to the property?",{"$nulls":6},{"$f":"IF($B101=\"Yes\",1,0)","v":0},{"$nulls":4},{"$f":"IF($B101=\"Yes\",1,0)","v":0},{"$f":"IF($B101=\"Yes\",1,0)","v":0},null,{"$f":"IF($B101=\"Yes\",1,0)","v":0}]
[]
["Does the property border a navigable waterway?",{"$nulls":6},{"$f":"IF($B103=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B103=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B103=\"Yes\",1,0)","v":0},{"$f":"IF($B103=\"Yes\",1,0)","v":0},{"$f":"IF($B103=\"Yes\",1,0)","v":0}]
["Does the property border an attractive waterway?",{"$nulls":6},{"$f":"IF($B104=\"Yes\",1,0)","v":0},{"$nulls":4},{"$f":"IF($B104=\"Yes\",1,0)","v":0},{"$f":"IF($B104=\"Yes\",1,0)","v":0},null,{"$f":"IF($B104=\"Yes\",1,0)","v":0}]
[]
["Is the property close to a commercial airport (regional or larger)?",{"$nulls":7},{"$f":"IF($B106=\"Yes\",1,0)","v":0},null,{"$f":"IF($B106=\"Yes\",1,0)","v":0},null,{"$f":"IF($B106=\"Yes\",1,0)","v":0},{"$f":"IF($B106=\"Yes\",1,0)","v":0}]

{"sheet":"6. Environmental","index":6,"n_rows":42,"n_cols":17,"rows_kept":42,"merged":[[0,0,0,2]]}
["Enter Environmental Characteristics in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""},{"$nulls":6},"Residential","Commercial (Professional/Office)","Retail","Industrial (excluding warehouse)","Warehouse Distribution","Hotel/Hospitality","Mixed Use","Energy","Greenspace","Government"]
["Environmental",{"$nulls":3},"Validation Lists",null,"SUBTOTAL",{"$f":"IF(MAX(H5:H46)=999,999,SUM(H5:H46))","v":0},{"$f":"IF(MAX(I5:I46)=999,999,SUM(I5:I46))","v":0},0,0,{"$f":"IF(MAX(L5:L46)=999,999,SUM(L5:L46))","v":0},0,0,0,0,0]
["Has a Phase I Environmental Site Assessment been conducted?",{"$nulls":3},"Yes"]
[{"$f":"IF(OR(B4=\"No\",B4=\"\"),\"\",\"Does the Phase I ESA meet All Appropriate Inquiry Requirements?\")","v":""},{"$nulls":3},"No"]
[{"$f":"IF(OR(B4=\"No\", B5=\"No\"),\"If the property is to be purchased or sold, a Phase I ESA meeting All Appropriate Inquiry requirements is needed to take advantage of potential liability protection for a buyer.\",\"\")","v":""}]
[{"$nulls":4},"Unknown"]
["Have site investigations been conducted on the property?",{"$nulls":3},"Limited investigations conducted"]
[{"$f":"IF(B8=\"No\",\"A brownfield property that has not been assessed is a deterrent to potential developers.\",IF(B8=\"Yes\",\"To what extent has the property been assessed?\",\"\"))","v":""},{"$nulls":3},"Investigations in process"]
[{"$f":"IF(B8=\"No\",\"An undefined risk exists that cannot be quantified by interested parties.\",\"\")","v":""},{"$nulls":3},"Fully characterized (no additional testing recommended)"]
[{"$f":"IF($B$8=\"Yes\",\"Is there known environmental contamination?\",\"\")","v":""}]
[{"$f":"IF(OR(B8=\"No\",B11=\"No\"),\"Continue data entry on next spreadsheet tab.\",\"\")","v":""},{"$nulls":3},"No"]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF($B$8=\"Yes\",\"Has the contamination been addressed (remedial action implemented)?\",\"\"))","v":""},{"$nulls":3},"Remedial Action Plan Approved"]
[{"$nulls":4},"Remedial Action Implemented"]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF($B$8=\"Yes\",\"Have land use restrictions resulted from this environmental condition or will land use restrictions likely result in the future?\",\"\"))","v":""},null,null,{"$f":"IF(B15=\"No\",\"<=You selected No, so jump to questions in row 28.\",\"\")","v":""},"Remedial Action Complete"]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",B15=\"yes\"),\"What uses are likely to be restricted on the useable acreage of the site? (check all that apply)\",\"\"))","v":""}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),H2,\"\"))","v":""},null,null,{"$f":"IF(B17=\"Yes\",\"Use not viable unless restriction removed\",\"\")","v":""},{"$nulls":3},{"$f":"IF($B17=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),I2,\"\"))","v":""},null,null,"",{"$nulls":4},{"$f":"IF($B18=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),J2,\"\"))","v":""},null,null,"",{"$nulls":5},{"$f":"IF($B19=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),K2,\"\"))","v":""},null,null,"",{"$nulls":6},{"$f":"IF($B20=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),L2,\"\"))","v":""},null,null,"",{"$nulls":7},{"$f":"IF($B21=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),M2,\"\"))","v":""},null,null,"",{"$nulls":8},{"$f":"IF($B22=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),N2,\"\"))","v":""},null,null,"",{"$nulls":9},{"$f":"IF($B23=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),O2,\"\"))","v":""},null,null,"",{"$nulls":10},{"$f":"IF($B24=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),P2,\"\"))","v":""},null,null,"",{"$nulls":11},{"$f":"IF($B25=\"Yes\",999,0)","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$15=\"yes\"),Q2,\"\"))","v":""},null,null,"",{"$nulls":12},{"$f":"IF($B26=\"Yes\",999,0)","v":0}]
[]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF($B$8=\"Yes\",\"Have groundwater restrictions resulted from this environmental condition or will groundwater restrictions likely result in the future?\",\"\"))","v":""},{"$nulls":6},{"$f":"IF($B28=\"Yes\",-1,0)","v":0},{"$nulls":4},{"$f":"IF($B28=\"Yes\",-1,0)","v":0}]
[]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF($B$8=\"Yes\",\"Is indoor air likely to be an issue for new construction?\",\"\"))","v":""},{"$nulls":6},{"$f":"IF($B30=\"Yes\",-1,0)","v":0},{"$f":"IF($B30=\"Yes\",-1,0)","v":0},{"$f":"IF($B30=\"Yes\",-1,0)","v":0},null,null,{"$f":"IF($B30=\"Yes\",-1,0)","v":0},{"$f":"IF($B30=\"Yes\",-1,0)","v":0},null,null,{"$f":"IF($B30=\"Yes\",-1,0)","v":0}]
[]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF($B$8=\"Yes\",\"Will remediation be completed prior to development or property transfer?\",\"\"))","v":""},{"$nulls":6},{"$f":"IF($B$32=\"\",0,IF($B$32=\"Yes\",0,-1))","v":0}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$32=\"No\"),\"Will operation, maintenance or monitoring be required after development or property transfer?\",\"\"))","v":""}]
[{"$f":"IF(AND($B$8=\"Yes\",OR($B$11=\"No\",$B$11=\"\")),\"\",IF(AND($B$8=\"Yes\",$B$32=\"No\"),\"Is post-closure monitoring required (i.e., closed impoundment)?\",\"\"))","v":""}]
[]
[]
[{"$f":"IF(OR($B$32=\"Yes\",$B$32=\"\"),\"\",\"Environmental Cost Estimates\")","v":""}]
[{"$f":"IF(OR($B$32=\"Yes\",$B$32=\"\"),\"\",\"Soil Remediation\")","v":""}]
[{"$f":"IF(OR($B$32=\"Yes\",$B$32=\"\"),\"\",\"Groundwater Remediation\")","v":""}]
[{"$f":"IF(OR($B$32=\"Yes\",$B$32=\"\"),\"\",\"Other Remediation\")","v":""}]
[{"$f":"IF(OR($B$33=\"No\",$B$33=\"\"),\"\",\"Ongoing operation, maintenance, or monitoring\")","v":""}]
[{"$f":"IF(OR($B$34=\"No\",$B$34=\"\"),\"\",\"Impoundment or other solid waste management unit closure\")","v":""}]

{"sheet":"7. Community","index":7,"n_rows":62,"n_cols":18,"rows_kept":62,"merged":[[0,0,0,2]]}
["Enter community information in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""},{"$nulls":7},"Residential","Commercial (professional / office)","Retail","Industrial","Warehouse","Hotel/Hospitality","Mixed Use","Energy","Greenspace","Government"]
["Community",{"$nulls":3},"Validation Lists",null,null,"SUBTOTAL",{"$f":"IF(MAX(I4:I124)=999,999,SUM(I4:I124))","v":0},0,0,0,0,0,0,0,0,0]
["How would you describe your community?",{"$nulls":3},"Struggling and declining in population",{"$nulls":3},{"$f":"IF($B4=$E$4,-1,IF($B4=$E$7,1,0))","v":0},{"$f":"IF($B4=$E$4,-1,IF($B4=$E$7,1,0))","v":0},{"$f":"IF($B4=$E$4,-1,IF($B4=$E$7,1,0))","v":0},{"$f":"IF($B4=$E$7,1,0)","v":0},0,0,0,0,0,0]
[{"$nulls":4},"Stagnant and in risk of declining"]
["How attractive is your community to developers?",{"$nulls":3},"Stagnant but healthy"]
[{"$nulls":4},"Growing and dynamic"]
["Does your community have a comprehensive master plan?"]
[{"$f":"IF(B8=\"Yes\",\"If yes, what land use does the plan call for? (check all that apply)\",\"\")","v":""},{"$nulls":3},"Developers never come into our community"]
[{"$f":"IF($B$8=\"Yes\",$I$2,\"\")","v":""},{"$nulls":3},"A few developers look at our community each year",{"$nulls":3},{"$f":"IF($B10=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$J$2,\"\")","v":""},{"$nulls":3},"Developers are regularly proposing new projects",{"$nulls":4},{"$f":"IF($B11=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$K$2,\"\")","v":""},{"$nulls":9},{"$f":"IF($B12=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$L$2,\"\")","v":""},{"$nulls":3},"Office",{"$nulls":6},{"$f":"IF($B13=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$M$2,\"\")","v":""},{"$nulls":3},"Retail",{"$nulls":7},{"$f":"IF($B14=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$N$2,\"\")","v":""},{"$nulls":3},"Manufacturing",{"$nulls":8},{"$f":"IF($B15=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$O$2,\"\")","v":""},{"$nulls":3},"Recreation",{"$nulls":9},{"$f":"IF($B16=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$P$2,\"\")","v":""},{"$nulls":3},"Public/Government Use",{"$nulls":10},{"$f":"IF($B17=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$Q$2,\"\")","v":""},{"$nulls":15},{"$f":"IF($B18=\"Yes\",1,0)","v":0}]
[{"$f":"IF($B$8=\"Yes\",$R$2,\"\")","v":""},{"$nulls":16},{"$f":"IF($B19=\"Yes\",1,0)","v":0}]
[]
["Are there unique economic drivers in the region?"]
[{"$f":"IF(B21=\"Yes\",\"If yes, what types of drivers? (check all that apply)\",\"\")","v":""}]
[{"$f":"IF($B$21=\"Yes\",E23,\"\")","v":""},{"$nulls":3},"Abundance of natural resources",{"$nulls":6},{"$f":"IF($B23=\"Yes\",1,0)","v":0},{"$nulls":4},{"$f":"IF($B23=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Tourism, hospitality, conventions",{"$nulls":8},{"$f":"IF($B24=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B24=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Outdoor recreational resources",{"$nulls":8},{"$f":"IF($B25=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Universities or colleges",{"$nulls":3},{"$f":"IF($B26=\"Yes\",1,0)","v":0},0,0,{"$nulls":3},{"$f":"IF($B26=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Religious and/or other culture institutions",{"$nulls":3},0,0,0]
["",{"$nulls":3},"Major government presence",{"$nulls":3},{"$f":"IF($B28=\"Yes\",1,0)","v":0},{"$f":"IF($B28=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Major employers or employment sectors",{"$nulls":3},{"$f":"IF($B29=\"Yes\",1,0)","v":0},{"$f":"IF($B29=\"Yes\",1,0)","v":0},null,{"$f":"IF($B29=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Transportation hub",{"$nulls":6},{"$f":"IF($B30=\"Yes\",1,0)","v":0},{"$f":"IF($B30=\"Yes\",1,0)","v":0},null,{"$f":"IF($B30=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Significant utilities / infrastructure",{"$nulls":6},{"$f":"IF($B31=\"Yes\",1,0)","v":0},{"$f":"IF($B31=\"Yes\",1,0)","v":0},{"$f":"IF($B31=\"Yes\",1,0)","v":0},{"$f":"IF($B31=\"Yes\",1,0)","v":0},{"$f":"IF($B31=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Large population density",{"$nulls":3},{"$f":"IF($B32=\"Yes\",1,0)","v":0},{"$f":"IF($B32=\"Yes\",1,0)","v":0},{"$f":"IF($B32=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B32=\"Yes\",1,0)","v":0}]
[]
["Does your community/region/state promote certain economic clusters?"]
[{"$f":"IF(B34=\"Yes\",\"If yes, for what type of activities? (check all that apply)\",\"\")","v":""}]
[{"$f":"IF($B$34=\"Yes\",E36,\"\")","v":""},{"$nulls":3},"Professional / office",{"$nulls":4},{"$f":"IF($B36=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Retail",{"$nulls":5},{"$f":"IF($B37=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Research and development",{"$nulls":4},{"$f":"IF($B38=\"Yes\",1,0)","v":0},null,{"$f":"IF($B38=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Logistics, fulfillment, warehousing and distribution",{"$nulls":6},{"$f":"IF($B39=\"Yes\",1,0)","v":0},{"$f":"IF($B39=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Healthcare / Medical (operations, research, manufacturing)",{"$nulls":3},{"$f":"IF($B40=\"Yes\",1,0)","v":0},{"$f":"IF($B40=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Tourism, hospitality, conventions",{"$nulls":5},{"$f":"IF($B41=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B41=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B41=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Arts and entertainment",{"$nulls":8},{"$f":"IF($B42=\"Yes\",1,0)","v":0},{"$f":"IF($B42=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Manufacturing",{"$nulls":6},{"$f":"IF($B43=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Energy (fossil fuels, renewable, green technologies)",{"$nulls":6},{"$f":"IF($B44=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B44=\"Yes\",1,0)","v":0}]
[]
["Do economic incentives exist for your community?",{"$nulls":3},"In town"]
[{"$f":"IF(B46=\"Yes\",\"If yes, for what type of activities? (check all that apply)\",\"\")","v":""},{"$nulls":3},"Out of town 0-10 miles"]
[{"$f":"IF($B$46=\"Yes\",E36,\"\")","v":""},{"$nulls":3},"Out of town 10+ miles",{"$nulls":4},{"$f":"IF($B48=\"Yes\",1,0)","v":0}]
["",{"$nulls":9},{"$f":"IF($B49=\"Yes\",1,0)","v":0}]
["",{"$nulls":8},{"$f":"IF($B50=\"Yes\",1,0)","v":0},null,{"$f":"IF($B50=\"Yes\",1,0)","v":0}]
["",{"$nulls":10},{"$f":"IF($B51=\"Yes\",1,0)","v":0},{"$f":"IF($B51=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"In town",{"$nulls":3},{"$f":"IF($B52=\"Yes\",1,0)","v":0},{"$f":"IF($B52=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Less than 10 miles from town",{"$nulls":5},{"$f":"IF($B53=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B53=\"Yes\",1,0)","v":0},null,null,{"$f":"IF($B53=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"Between 10 and 25 miles from town",{"$nulls":8},{"$f":"IF($B54=\"Yes\",1,0)","v":0},{"$f":"IF($B54=\"Yes\",1,0)","v":0}]
["",{"$nulls":3},"More than 25 miles from town",{"$nulls":6},{"$f":"IF($B55=\"Yes\",1,0)","v":0}]
["",{"$nulls":10},{"$f":"IF($B56=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B56=\"Yes\",1,0)","v":0}]
[{"$nulls":4},"Yes"]
["How far does a majority of the population travel to shop for everyday goods?",{"$nulls":3},"No",{"$nulls":5},{"$f":"IF(OR($B58=$E$47),1,IF($B58=$E$48,2,0))","v":0}]
[]
["How far does a majority of the population travel to shop for specialty purchases?",{"$nulls":9},{"$f":"IF(OR($B60=$E$48,$B60=$E$48),1,0)","v":0}]
[]
["How far does a majority of the population travel to work?",{"$nulls":9},{"$f":"IF($B62=$E$55,-1,0)","v":0}]

{"sheet":"8. Demographics","index":8,"n_rows":163,"n_cols":17,"rows_kept":163,"merged":[[0,0,0,2]]}
["Enter Demographic Information in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Population",{"$nulls":3},"Validation Lists",null,null,"Residential","Commercial (professional / office)","Retail","Industrial","Warehouse","Hotel/Hospitality","Mixed Use","Energy","Greenspace","Government"]
["What is the population of the town/city?",{"$nulls":3},"Yes",null,"SUBTOTAL",{"$f":"IF(MAX(H5:H177)=999,999,SUM(H5:H177))","v":0},0,0,0,0,0,0,0,0,0]
["What is the population of the Metropolitan Statistical Area (MSA)?",{"$nulls":3},"No"]
["How many households are in the town/city?",{"$nulls":3},"Residents"]
["How many households are in the MSA?",{"$nulls":3},"Percent"]
[{"$nulls":4},"Dollars"]
["Population Age"]
["What is the median age of the town/city?",{"$nulls":3},"Government"]
["What is the median age of the MSA?",{"$nulls":3},"Manufacturing"]
["Is the elderly population larger than the population of children?",{"$nulls":3},"Wholesale / Retail Trade"]
[{"$nulls":4},"Finance / Professional and Business"]
["Population Change",{"$nulls":3},"Education and Healthcare"]
["What was the population change of the town/city from 2000-2010?",{"$nulls":3},"Logistics and Distribution",null,null,{"$f":"IF($B15>0,1,IF($B15<0,-1,0))","v":0},{"$f":"IF($B15>0,1,IF($B15<0,-1,0))","v":0},0,0,0,0,0,0,0,0]
["What is the estimated population change of the town/city from 2010-present?",{"$nulls":3},"High tech Equipment and Services",null,null,{"$f":"IF($B16>0,1,IF($B16<0,-1,0))","v":0},0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Hotel / Hospitality / Tourism"]
["What was the population change of the MSA from 2000-2010?",{"$nulls":3},"Other (Type in a sector not included in the above list)",null,null,{"$f":"IF($B18>0,1,IF($B18<0,-1,0))","v":0},{"$f":"IF($B18>0,1,IF($B18<0,-1,0))","v":0},0,0,0,0,0,0,0,0]
["What is the estimated population change of the MSA from 2010-present?",{"$nulls":6},{"$f":"IF($B19>0,1,IF($B19<0,-1,0))","v":0},0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Per Household"]
["Have people been moving into the community in the past few years?",{"$nulls":3},"Total",null,null,{"$f":"IF($B21=\"Yes\",1,IF($B21=\"No\",-1,0))","v":0},{"$f":"IF($B21=\"Yes\",1,IF($B21=\"No\",-1,0))","v":0},{"$f":"IF($B21=\"Yes\",1,IF($B21=\"No\",-1,0))","v":0},{"$f":"IF($B21=\"Yes\",1,0)","v":0},0,0,0,0,0,0]
[]
["Educational Attainment"]
["What percentage of the town/city population over 25 has a high school diploma?"]
["What percentage of the town/city population over 25 has a college degree?"]
[]
["What percentage of the MSA population over 25 has a high school diploma?"]
["What percentage of the MSA population over 25 has a college degree?"]
[]
["Are vocational schools and colleges located in the MSA?"]
["Are vocational schools and colleges located in the MSA offering specialty degree programs?",{"$nulls":7},{"$f":"IF($B31=\"Yes\",1,0)","v":0},null,{"$f":"IF($B31=\"Yes\",1,0)","v":0},{"$f":"IF($B31=\"Yes\",1,0)","v":0}]
[]
["Consider the educational attainment levels: is there a large professional workforce?",{"$nulls":7},{"$f":"IF($B33=\"Yes\",1,0)","v":0}]
["Consider the educational attainment levels: is there a large skilled or semi-skilled workforce?",{"$nulls":9},{"$f":"IF($B34=\"Yes\",1,0)","v":0}]
[]
["Employment"]
["What is the size of the workforce in the town/city?"]
["What is the current unemployment rate of the town/city? "]
["What is the 10-year average unemployment rate of the town/city?"]
[]
["What is the size of the workforce in the MSA?"]
["What is the current unemployment rate of the MSA?"]
["What is the 10-year average unemployment rate of the MSA?"]
[]
["How far do people currently commute to work?",null,"miles"]
[]
["Consider the employment levels in the region and the typical distance people commute: is there available workforce (5% unemployment of greater)?",{"$nulls":7},{"$f":"IF($B47=\"Yes\",1,0)","v":0},null,0,0]
["Consider the employment levels in the region: is the current workforce suitable for technology and service industries?",{"$nulls":7},0]
["Considering the employment levels in the region, is there available  unskilled or lower skilled workers?",{"$nulls":8},0,null,0,0,0]
[]
["Income"]
["What is the median household income in the town/city?"]
["What was the change in median household income from 2000-2010 of the town/city?"]
["What was the change in median household income from 2010-present of the town/city?"]
[]
["What is the median household income in the MSA?"]
["What was the change in median household income from 2000-2010 of the MSA?"]
["What was the change in median household income from 2010-present of the MSA?"]
[]
["What is the current per capita income of the town/city?"]
["What was the change in per capita income from 2000-2010 of the town/city?",null,"Percent"]
["What was the change in per capita income from 2010-present of the town/city?",null,"Dollars"]
[]
["What is the current per capita income of the MSA?"]
["What was the change in per capita income from 2000-2010 of the MSA?",null,"Percent"]
["What was the change in per capita income from 2010-present of the MSA?",null,"Dollars"]
[]
["Consider the income levels in the town/city: are income levels growing?",{"$nulls":6},{"$f":"IF($B68=\"Yes\",1,0)","v":0},0,0,{"$f":"IF($B68=\"Yes\",-1,0)","v":0}]
["Consider the income levels in the town/city: are income levels high for the area?",{"$nulls":6},0,{"$f":"IF($B69=\"Yes\",-1,0)","v":0},0,{"$f":"IF($B69=\"Yes\",-1,0)","v":0}]
[]
["Expenditures"]
["What is the estimated disposable income of the town/city?"]
["What is the estimated disposable income of the MSA?"]
[]
["What is the percentage of households that own their own home in the town/city?"]
["What is the percentage of households that own their own home in the MSA?"]
[]
["Consider the spending habits indicated: do area residents have disposable income?",{"$nulls":6},{"$f":"IF($B78=\"Yes\",1,IF($B78=\"No\",-1,0))","v":0},null,{"$f":"IF($B78=\"Yes\",1,IF($B78=\"No\",-1,0))","v":0}]
[]
["Employment Sectors"]
["How many major employers does the town/city have?"]
[]
["What is the top employment sector in the town/city?"]
["What is the second largest employment sector in the town/city?"]
["What is the third largest employment sector in the town/city?"]
[]
["What are the fastest growing sectors of employment in the town/city?",{"$nulls":6},"Residential","Commercial (professional / office)","Retail","Industrial","Warehouse","Hotel/Hospitality","Mixed Use","Energy","Greenspace","Government"]
[{"$f":"E10","v":"Government"}]
["Manufacturing",null,{"$f":"IF(AND(B88=\"yes\",B89=\"yes\"),\", \"&A89,IF(B89=\"yes\",A89,\"\"))","v":""},{"$nulls":7},{"$f":"IF($B89=\"Yes\",1,0)","v":0}]
["Wholesale / Retail Trade",null,{"$f":"IF(AND(B90=\"yes\",OR(B88=\"yes\",B89=\"yes\")),\", \"&A90,IF(B90=\"yes\",A90,\"\"))","v":""},{"$nulls":6},{"$f":"IF($B90=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B90=\"Yes\",1,0)","v":0}]
["Finance / Professional and Business",null,{"$f":"IF(AND(B91=\"yes\",OR(B88=\"yes\",B89=\"yes\",B90=\"yes\")),\", \"&A91,IF(B91=\"yes\",A91,\"\"))","v":""},{"$nulls":5},{"$f":"IF($B91=\"Yes\",1,0)","v":0}]
["Education and Healthcare",null,{"$f":"IF(AND(B92=\"yes\",OR(B88=\"yes\",B89=\"yes\",B90=\"yes\",B91=\"yes\")),\", \"&A92,IF(B92=\"yes\",A92,\"\"))","v":""},{"$nulls":5},{"$f":"IF($B92=\"Yes\",1,0)","v":0}]
["Logistics and Distribution",null,{"$f":"IF(AND(B93=\"yes\",OR(B88=\"yes\",B89=\"yes\",B90=\"yes\",B91=\"yes\",B92=\"yes\")),\", \"&A93,IF(B93=\"yes\",A93,\"\"))","v":""},{"$nulls":8},{"$f":"IF($B93=\"Yes\",1,0)","v":0},{"$f":"IF($B93=\"Yes\",1,0)","v":0}]
["High tech Equipment and Services",null,{"$f":"IF(AND(B94=\"yes\",OR(B88=\"yes\",B89=\"yes\",B90=\"yes\",B91=\"yes\",B92=\"yes\",B93=\"yes\")),\", \"&A94,IF(B94=\"yes\",A94,\"\"))","v":""},{"$nulls":7},{"$f":"IF($B94=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B94=\"Yes\",1,0)","v":0}]
["Hotel / Hospitality / Tourism",null,{"$f":"IF(AND(B95=\"yes\",OR(B88=\"yes\",B89=\"yes\",B90=\"yes\",B91=\"yes\",B92=\"yes\",B93=\"yes\",B94=\"yes\")),\", \"&A95,IF(B95=\"yes\",A95,\"\"))","v":""},{"$nulls":9},{"$f":"IF($B95=\"Yes\",1,0)","v":0}]
["Other (Type in a sector not included in the above list)",null,{"$f":"IF(AND(B96<>0,OR(B88=\"yes\",B89=\"yes\",B90=\"yes\",B91=\"yes\",B92=\"yes\",B93=\"yes\",B94=\"yes\",B95=\"yes\")),\", \"&A96,IF(B96=\"yes\",A96,\"\"))","v":""}]
[]
["What are the fastest declining sectors of employment in the town/city?"]
[{"$f":"E10","v":"Government"},null,{"$f":"IF(B99=\"yes\",A99,\"\")","v":""}]
["Manufacturing",null,{"$f":"IF(AND(B99=\"yes\",B100=\"yes\"),\", \"&A100,IF(B100=\"yes\",A100,\"\"))","v":""},{"$nulls":7},{"$f":"IF($B100=\"Yes\",1,0)","v":0}]
["Wholesale / Retail Trade",null,{"$f":"IF(AND(B101=\"yes\",OR(B99=\"yes\",B100=\"yes\")),\", \"&A101,IF(B101=\"yes\",A101,\"\"))","v":""},{"$nulls":6},{"$f":"IF($B101=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B101=\"Yes\",1,0)","v":0}]
["Finance / Professional and Business",null,{"$f":"IF(AND(B102=\"yes\",OR(B99=\"yes\",B100=\"yes\",B101=\"yes\")),\", \"&A102,IF(B102=\"yes\",A102,\"\"))","v":""},{"$nulls":5},{"$f":"IF($B102=\"Yes\",1,0)","v":0}]
["Education and Healthcare",null,{"$f":"IF(AND(B103=\"yes\",OR(B99=\"yes\",B100=\"yes\",B101=\"yes\",B102=\"yes\")),\", \"&A103,IF(B103=\"yes\",A103,\"\"))","v":""},{"$nulls":5},{"$f":"IF($B103=\"Yes\",1,0)","v":0}]
["Logistics and Distribution",null,{"$f":"IF(AND(B104=\"yes\",OR(B99=\"yes\",B100=\"yes\",B101=\"yes\",B102=\"yes\",B103=\"yes\")),\", \"&A104,IF(B104=\"yes\",A104,\"\"))","v":""},{"$nulls":8},{"$f":"IF($B104=\"Yes\",1,0)","v":0},{"$f":"IF($B104=\"Yes\",1,0)","v":0}]
["High tech Equipment and Services",null,{"$f":"IF(AND(B105<>0,OR(B97=\"yes\",B98=\"yes\",B99=\"yes\",B100=\"yes\",B101=\"yes\",B102=\"yes\",B103=\"yes\",B104=\"yes\")),\", \"&A105,IF(B105=\"yes\",A105,\"\"))","v":""},{"$nulls":7},{"$f":"IF($B105=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B105=\"Yes\",1,0)","v":0}]
["Hotel / Hospitality / Tourism",null,{"$f":"IF(AND(B106<>0,OR(B98=\"yes\",B99=\"yes\",B100=\"yes\",B101=\"yes\",B102=\"yes\",B103=\"yes\",B104=\"yes\",B105=\"yes\")),\", \"&A106,IF(B106=\"yes\",A106,\"\"))","v":""},{"$nulls":9},{"$f":"IF($B106=\"Yes\",1,0)","v":0}]
["Other (Type in a sector not included in the above list)",null,{"$f":"IF(AND(B107<>0,OR(B99=\"yes\",B100=\"yes\",B101=\"yes\",B102=\"yes\",B103=\"yes\",B104=\"yes\",B105=\"yes\",B106=\"yes\")),\", \"&A107,IF(B107=\"yes\",A107,\"\"))","v":""}]
[]
["Looking at employment trends in the town/city, are there multiple sectors growing that would suggest a mixed-used development?",{"$nulls":12},{"$f":"IF($B109=\"Yes\",1,IF($B109=\"No\",-1,0))","v":0}]
[]
["How many major employers does the MSA have?"]
[]
["What is the top employment sector in the MSA?"]
["What is the second largest employment sector in the MSA?"]
["What is the third largest employment sector in the MSA?"]
[]
["What are the fastest growing areas of employment in the MSA?"]
[{"$f":"E10","v":"Government"}]
["Manufacturing",{"$nulls":9},{"$f":"IF($B119=\"Yes\",1,0)","v":0}]
["Wholesale / Retail Trade",{"$nulls":8},{"$f":"IF($B120=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B120=\"Yes\",1,0)","v":0}]
["Finance / Professional and Business",{"$nulls":7},{"$f":"IF($B121=\"Yes\",1,0)","v":0}]
["Education and Healthcare",{"$nulls":7},{"$f":"IF($B122=\"Yes\",1,0)","v":0}]
["Logistics and Distribution",{"$nulls":10},{"$f":"IF($B123=\"Yes\",1,0)","v":0},{"$f":"IF($B123=\"Yes\",1,0)","v":0}]
["High tech Equipment and Services",{"$nulls":9},{"$f":"IF($B124=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B124=\"Yes\",1,0)","v":0}]
["Hotel / Hospitality / Tourism",{"$nulls":11},{"$f":"IF($B125=\"Yes\",1,0)","v":0}]
["Other (Type in a sector not included in the above list)"]
[]
["What are the fastest declining areas of employment in the MSA?"]
[{"$f":"E10","v":"Government"}]
["Manufacturing",{"$nulls":9},{"$f":"IF($B130=\"Yes\",1,0)","v":0}]
["Wholesale / Retail Trade",{"$nulls":8},{"$f":"IF($B131=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B131=\"Yes\",1,0)","v":0}]
["Finance / Professional and Business",{"$nulls":7},{"$f":"IF($B132=\"Yes\",1,0)","v":0}]
["Education and Healthcare",{"$nulls":7},{"$f":"IF($B133=\"Yes\",1,0)","v":0}]
["Logistics and Distribution",{"$nulls":10},{"$f":"IF($B134=\"Yes\",1,0)","v":0},{"$f":"IF($B134=\"Yes\",1,0)","v":0}]
["High tech Equipment and Services",{"$nulls":9},{"$f":"IF($B135=\"Yes\",1,0)","v":0},{"$nulls":3},{"$f":"IF($B135=\"Yes\",1,0)","v":0}]
["Hotel / Hospitality / Tourism",{"$nulls":11},{"$f":"IF($B136=\"Yes\",1,0)","v":0}]
["Other (Type in a sector not included in the above list)"]
[]
["Looking at employment trends in the MSA, are there multiple sectors growing that would suggest a mixed-used development?",{"$nulls":12},{"$f":"IF($B139=\"Yes\",1,IF($B139=\"No\",-1,0))","v":0}]
[]
["What sectors are vibrant and growing?"]
["Residential",null,{"$f":"IF(B142=\"yes\",A142,\"\")","v":""},{"$nulls":4},{"$f":"IF($B142=\"Yes\",1,0)","v":0}]
["Commercial (professional / office / technology)",null,{"$f":"IF(AND(B142=\"yes\",B143=\"yes\"),\", \"&A143,IF(B143=\"yes\",A143,\"\"))","v":""},{"$nulls":5},{"$f":"IF($B143=\"Yes\",1,0)","v":0}]
["Retail",null,{"$f":"IF(AND(B144=\"yes\",OR(B142=\"yes\",B143=\"yes\")),\", \"&A144,IF(B144=\"yes\",A144,\"\"))","v":""},{"$nulls":6},{"$f":"IF($B144=\"Yes\",1,0)","v":0}]
["Industrial",null,{"$f":"IF(AND(B145=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\")),\", \"&A145,IF(B145=\"yes\",A145,\"\"))","v":""},{"$nulls":7},{"$f":"IF($B145=\"Yes\",1,0)","v":0}]
["Logistics and distribution",null,{"$f":"IF(AND(B146=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\",B145=\"yes\")),\", \"&A146,IF(B146=\"yes\",A146,\"\"))","v":""},{"$nulls":8},{"$f":"IF($B146=\"Yes\",1,0)","v":0}]
["Hotel/hospitality/tourism",null,{"$f":"IF(AND(B147=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\",B145=\"yes\",B146=\"yes\")),\", \"&A147,IF(B147=\"yes\",A147,\"\"))","v":""},{"$nulls":9},{"$f":"IF($B147=\"Yes\",1,0)","v":0}]
["Mixed Use",null,{"$f":"IF(AND(B148=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\",B145=\"yes\",B146=\"yes\",B147=\"yes\")),\", \"&A148,IF(B148=\"yes\",A148,\"\"))","v":""},{"$nulls":10},{"$f":"IF($B148=\"Yes\",1,0)","v":0}]
["Energy (renewable, fossil fuels, green technologies)",null,{"$f":"IF(AND(B149=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\",B145=\"yes\",B146=\"yes\",B147=\"yes\",B148=\"yes\")),\", \"&A149,IF(B149=\"yes\",A149,\"\"))","v":""},{"$nulls":11},{"$f":"IF($B149=\"Yes\",1,0)","v":0}]
["Greenspace / recreation",null,{"$f":"IF(AND(B150=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\",B145=\"yes\",B146=\"yes\",B147=\"yes\",B148=\"yes\",B149=\"yes\")),\", \"&A150,IF(B150=\"yes\",A150,\"\"))","v":""},{"$nulls":12},{"$f":"IF($B150=\"Yes\",1,0)","v":0}]
["Government",null,{"$f":"IF(AND(B151=\"yes\",OR(B142=\"yes\",B143=\"yes\",B144=\"yes\",B145=\"yes\",B146=\"yes\",B147=\"yes\",B148=\"yes\",B149=\"yes\",B150=\"yes\")),\", \"&A151,IF(B151=\"yes\",A151,\"\"))","v":""},{"$nulls":13},{"$f":"IF($B151=\"Yes\",1,0)","v":0}]
[]
["Considering the information above and your knowledge of the local economy, should any of these sectors be completely avoided and therefore May Not be Viable?"]
["Residential",null,{"$f":"IF(AND(B154=\"Yes\",D154=0),\"Provide rationale:\",IF(AND(B154=\"yes\",D154<>\"\"),\"Rationale:\",\"\"))","v":""},{"$nulls":4},{"$f":"IF($B154=\"Yes\",999,0)","v":0}]
["Commercial (professional / office / technology)",null,{"$f":"IF(AND(B155=\"Yes\",D155=0),\"Provide rationale:\",IF(AND(B155=\"yes\",D155<>\"\"),\"Rationale:\",\"\"))","v":""},{"$nulls":5},{"$f":"IF($B155=\"Yes\",999,0)","v":0}]
["Retail",null,"",{"$nulls":6},{"$f":"IF($B156=\"Yes\",999,0)","v":0}]
["Industrial",null,"",{"$nulls":7},{"$f":"IF($B157=\"Yes\",999,0)","v":0}]
["Logistics and distribution",null,"",{"$nulls":8},{"$f":"IF($B158=\"Yes\",999,0)","v":0}]
["Hotel/hospitality/tourism",null,"",{"$nulls":9},{"$f":"IF($B159=\"Yes\",999,0)","v":0}]
["Mixed Use",null,"",{"$nulls":10},{"$f":"IF($B160=\"Yes\",999,0)","v":0}]
["Energy (renewable, fossil fuels, green technologies)",null,"",{"$nulls":11},{"$f":"IF($B161=\"Yes\",999,0)","v":0}]
["Greenspace / recreation",null,"",{"$nulls":12},{"$f":"IF($B162=\"Yes\",999,0)","v":0}]
["Government",null,"",{"$nulls":13},{"$f":"IF($B163=\"Yes\",999,0)","v":0}]

{"sheet":"9. Market Assessment","index":9,"n_rows":129,"n_cols":7,"rows_kept":129,"merged":[[0,0,0,4]]}
["Enter Market Assessment information in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Raw Undeveloped Land",{"$nulls":5},"Yes"]
["What is the average price per acre of residential land?",null,"per acre",{"$nulls":3},"No"]
["What is the average price per acre of industrial land?",null,"per acre",{"$nulls":3},"Neutral"]
["What is the average price per acre of commercial land?",null,"per acre"]
["What percentage of land in your community is vacant?",{"$nulls":5},"Upward"]
[{"$nulls":6},"Downward"]
["Residential Market",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$H$3+'5. Land Use Characteristics'!$H$4+'7. Community'!$I$3+'8. Demographics'!$H$4)>=399,\"Use May Not be Viable\",(SUM('6. Environmental'!$H$3+'5. Land Use Characteristics'!$H$4+'7. Community'!$I$3+'8. Demographics'!$H$4)+C29))","v":0},{"$f":"IF(E9=\"Fatal Flaw: Unviable Use\",LEFT(A9, LEN(A9)-7),\"\")","v":""}]
[{"$f":"IF(E9=\"Use May Not be Viable\",\"Because the \"&A9&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["How many homes currently exist in the community?"]
["How many new homes are currently permitted for construction?"]
[]
["What is the median housing price?"]
["What is the median housing price trend (upward or downward)?"]
[]
["What is the foreclosure rate?"]
["What is the foreclosure trend (upward or downward)?"]
["What percentage of sales are distressed (foreclosures, short sales)?"]
[]
["What is the average price per home (per SF)?",null,"per SF"]
["What is the average number of days on the market?"]
[]
["What is the median rental rate for two bedroom unit?"]
["What is the vacancy rate for residential properties?"]
["What was the growth in housing construction in the last two years?"]
["What was the growth in housing construction between 2000-present?"]
[]
["Considering the score and the answers above, is housing a growing market?",null,{"$f":"IF(B29=\"Yes\",2,IF(B29=\"No\",-1,0))","v":0}]
[]
["Commercial (Professional/Office) Market",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$I$3+'5. Land Use Characteristics'!$I$4+'7. Community'!$J$3+'8. Demographics'!$I$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$I$3+'5. Land Use Characteristics'!$I$4+'7. Community'!$J$3+'8. Demographics'!$I$4)+C41)","v":0},{"$f":"IF(AND(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\"),\", \"&LEFT(A31, LEN(A31)-7),IF(E31=\"Fatal Flaw: Unviable Use\",LEFT(A31, LEN(A31)-7),\"\"))","v":""}]
[{"$f":"IF(E31=\"Use May Not be Viable\",\"Because the \"&A31&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["What is the total square footage of existing office space?"]
["What is the vacancy rate of existing office space?"]
["How much office space has been built in past two years (SF)?",null,"SF"]
["How much office space is currently under development (SF)?",null,"SF"]
["What is the average sale price for office space (per SF)?",null,"per SF"]
["What percentage of office space is owner occupied?"]
["What is the average triple-net (NNN) lease rate for office space (per SF)?",null,"NNN, per SF"]
[]
["Considering the score and the answers above, is commercial (professional/office) a growing market?",null,{"$f":"IF(B41=\"Yes\",2,IF(B41=\"No\",-1,0))","v":0}]
[]
["Retail Market",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$J$3+'5. Land Use Characteristics'!$J$4+'7. Community'!$K$3+'8. Demographics'!$J$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$J$3+'5. Land Use Characteristics'!$J$4+'7. Community'!$K$3+'8. Demographics'!$J$4)+C61)","v":0},{"$f":"IF(AND(E43=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\")),\", \"&LEFT(A43, LEN(A43)-7),IF(E43=\"Fatal Flaw: Unviable Use\",LEFT(A43, LEN(A43)-7),\"\"))","v":""}]
[{"$f":"IF(E43=\"Use May Not be Viable\",\"Because the \"&A43&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["What is the total square footage of existing retail space?"]
["What is the vacancy rate of existing retail space?"]
["What has the vacancy rate of existing retail space been between 2000-present?"]
[]
["How much retail space is currently under development (SF)?",null,"SF"]
["How much retail space has been built in past two years (SF)?",null,"SF"]
["How much retail space has been built between 2000-present (SF)?",null,"SF"]
[]
["What is the average sale price for retail space (per SF)?",null,"per SF"]
["What is the average lease rate for retail space (NNN, per SF)?",null,"per SF"]
[]
["How many square feet of new retail leases were signed in the past two years?"]
["What percentage of existing retailers closed in the last two years?"]
[]
["Are there known retail demands in the market such services residents must drive a long distance for, or niches that are not currently served?",null,{"$f":"IF(B59=\"Yes\",1,0)","v":0}]
[]
["Considering the score and the answers above, is retail a growing market?",null,{"$f":"IF(B61=\"Yes\",2,IF(B61=\"No\",-1,0))+C59","v":0}]
[]
["Industrial Market (excluding warehouse)",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$K$3+'5. Land Use Characteristics'!$K$4+'7. Community'!$L$3+'8. Demographics'!$K$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$K$3+'5. Land Use Characteristics'!$K$4+'7. Community'!$L$3+'8. Demographics'!$K$4)+C73)","v":0},{"$f":"IF(AND(E63=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\")),\", Industrial (excluding warehouse)\",IF(E63=\"Fatal Flaw: Unviable Use\",\"Industrial (excluding warehouse)\",\"\"))","v":""}]
[{"$f":"IF(E63=\"Use May Not be Viable\",\"Because the \"&A63&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["What is the total square footage of existing industrial space?"]
["What is the vacancy rate of existing industrial space?"]
["How much industrial space has been built in past two years (SF)?",null,"SF"]
["How much industrial space is currently under development (SF)?",null,"SF"]
["What is the average sale price for industrial space (per SF)?",null,"per SF"]
["What percentage of industrial space is owner occupied?"]
["What is the average lease rate for industrial space (NNN)?",null,"NNN, per SF"]
[]
["Considering the score and the answers above, is industrial a growing market?",null,{"$f":"IF(B73=\"Yes\",2,IF(B73=\"No\",-1,0))","v":0}]
[]
["Warehouse Distribution Market",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$L$3+'5. Land Use Characteristics'!$L$4+'7. Community'!$M$3+'8. Demographics'!$L$4)>=399,\"Use May Not be Viable\",IF(AND('4. Property Characteristics'!$B$49<1,'4. Property Characteristics'!$B$49>0),\"Unviable Use\",SUM('6. Environmental'!$L$3+'5. Land Use Characteristics'!$L$4+'7. Community'!$M$3+'8. Demographics'!$L$4)+C85))","v":0},{"$f":"IF(AND(E75=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\",E63=\"Fatal Flaw: Unviable Use\")),\", \"&LEFT(A75, LEN(A75)-7),IF(E75=\"Fatal Flaw: Unviable Use\",LEFT(A75, LEN(A75)-7),\"\"))","v":""}]
[{"$f":"IF(E75=\"Use May Not be Viable\",\"Because the \"&A75&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["What is the total square footage of existing warehouse space?"]
["What is the vacancy rate of existing warehouse space?"]
["How much warehouse space has been built in past two years (SF)?",null,"SF"]
["How much warehouse space is currently under development (SF)?",null,"SF"]
["What is the average sale price for warehouse space (per SF)?",null,"per SF"]
["What percentage of warehouse space is owner occupied?"]
["What is the average lease rate for warehouse space (NNN)?",null,"NNN, per SF"]
[]
["Considering the score and the answers above, is warehouse distribution a growing market?",null,{"$f":"IF(B85=\"Yes\",2,IF(B85=\"No\",-1,0))","v":0}]
[]
["Hotel/Hospitality Market",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$M$3+'5. Land Use Characteristics'!$M$4+'7. Community'!$N$3+'8. Demographics'!$M$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$M$3+'5. Land Use Characteristics'!$M$4+'7. Community'!$N$3+'8. Demographics'!$M$4)+C93)","v":0},{"$f":"IF(AND(E87=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\",E63=\"Fatal Flaw: Unviable Use\",E75=\"Fatal Flaw: Unviable Use\")),\", \"&LEFT(A87, LEN(A87)-7),IF(E87=\"Fatal Flaw: Unviable Use\",LEFT(A87, LEN(A87)-7),\"\"))","v":""}]
[{"$f":"IF(E87=\"Use May Not be Viable\",\"Because the \"&A87&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["How many hotel rooms have been built in the past five years?"]
["What is the occupancy rate of local hotels?"]
["What is the average price per room at local hotels?",null,"per night"]
[]
["Considering the score and the answers above, is a hotel/hospitality a growing market?",null,{"$f":"IF(B93=\"Yes\",2,IF(B93=\"No\",-1,0))","v":0}]
[]
["Mixed Use Market",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$N$3+'5. Land Use Characteristics'!$N$4+'7. Community'!$O$3+'8. Demographics'!$N$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$N$3+'5. Land Use Characteristics'!$N$4+'7. Community'!$O$3+'8. Demographics'!$N$4)+C102)","v":0},{"$f":"IF(AND(E95=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\",E63=\"Fatal Flaw: Unviable Use\",E75=\"Fatal Flaw: Unviable Use\",E87=\"Fatal Flaw: Unviable Use\")),\", \"&LEFT(A95, LEN(A95)-7),IF(E95=\"Fatal Flaw: Unviable Use\",LEFT(A95, LEN(A95)-7),\"\"))","v":""}]
[{"$f":"IF(E95=\"Use May Not be Viable\",\"Because the \"&A95&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["Is the property of sufficient size and layout for multiple uses?"]
["Is there an existing building that could be occupied by more than one type of user?"]
["Look at the scores for other land uses above: did more than one land use have a positive score?  Are those land uses synergistic?"]
["Does your community promote mixed use, pedestrian friendly or transit oriented development?"]
[]
["Considering the score and the answers above, is mixed use a growing market?",null,{"$f":"IF(B102=\"Yes\",2,IF(B102=\"No\",-1,0))","v":0}]
[]
["Energy",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$O$3+'5. Land Use Characteristics'!$O$4+'7. Community'!$P$3+'8. Demographics'!$O$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$O$3+'5. Land Use Characteristics'!$O$4+'7. Community'!$P$3+'8. Demographics'!$O$4)+C112)","v":0},{"$f":"IF(AND(E104=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\",E63=\"Fatal Flaw: Unviable Use\",E75=\"Fatal Flaw: Unviable Use\",E87=\"Fatal Flaw: Unviable Use\",E95=\"Fatal Flaw: Unviable Use\")),\", \"&A104,IF(E104=\"Fatal Flaw: Unviable Use\",A104,\"\"))","v":""}]
[{"$f":"IF(E104=\"Use May Not be Viable\",\"Because \"&A104&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["Is this property within close proximity to electric transmission lines?"]
["Is there a substation on site?"]
["Are there renewable natural resources, such as wind or water, in close proximity?"]
["Is there demand for new power generation?"]
["Is there local support for the development of energy facilities?"]
[]
["Considering the score and the answers above, is energy a viable use for this property?",null,{"$f":"IF(B112=\"Yes\",2,IF(B112=\"No\",-1,0))","v":0}]
[]
["Greenspace",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$P$3+'5. Land Use Characteristics'!$P$4+'7. Community'!$Q$3+'8. Demographics'!$P$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$P$3+'5. Land Use Characteristics'!$P$4+'7. Community'!$Q$3+'8. Demographics'!$P$4)+C121)","v":0},{"$f":"IF(AND(E114=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\",E63=\"Fatal Flaw: Unviable Use\",E75=\"Fatal Flaw: Unviable Use\",E87=\"Fatal Flaw: Unviable Use\",E95=\"Fatal Flaw: Unviable Use\",E104=\"Fatal Flaw: Unviable Use\")),\", \"&A114,IF(E114=\"Fatal Flaw: Unviable Use\",A114,\"\"))","v":""}]
[{"$f":"IF(E114=\"Use May Not be Viable\",\"Because \"&A114&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["Does this property contain high quality ecological features or habitats?"]
["Is there a need or demand for open space in your community?"]
["Is there a need for passive and active recreation venues?"]
["Does the property have a greater value to the community as open space than developed?"]
[]
["Considering the score and the answers above, is greenspace a viable use for this property?",null,{"$f":"IF(B121=\"Yes\",2,IF(B121=\"No\",-1,0))","v":0}]
[]
["Government",null,null,"SCORE",{"$f":"IF(SUM('6. Environmental'!$Q$3+'5. Land Use Characteristics'!$Q$4+'7. Community'!$R$3+'8. Demographics'!$Q$4)>=399,\"Use May Not be Viable\",SUM('6. Environmental'!$Q$3+'5. Land Use Characteristics'!$Q$4+'7. Community'!$R$3+'8. Demographics'!$Q$4)+C129)","v":0},{"$f":"IF(AND(E123=\"Fatal Flaw: Unviable Use\",OR(E9=\"Fatal Flaw: Unviable Use\",E31=\"Fatal Flaw: Unviable Use\",E43=\"Fatal Flaw: Unviable Use\",E63=\"Fatal Flaw: Unviable Use\",E75=\"Fatal Flaw: Unviable Use\",E87=\"Fatal Flaw: Unviable Use\",E95=\"Fatal Flaw: Unviable Use\",E104=\"Fatal Flaw: Unviable Use\",E114=\"Fatal Flaw: Unviable Use\")),\", \"&A123,IF(E123=\"Fatal Flaw: Unviable Use\",A123,\"\"))","v":""}]
[{"$f":"IF(E123=\"Use May Not be Viable\",\"Because \"&A123&\" is an unviable use for this site, the following questions are optional.\",\"\")","v":""}]
["Is there a known need for new government facilities?"]
["Is there a long term plan that calls for new government facilities?"]
["Is this property in a location suitable for government use?"]
[]
["Considering the score and the answers above, is a government use a viable use for this property?",null,{"$f":"IF(B129=\"Yes\",2,IF(B129=\"No\",-1,0))","v":0}]

{"sheet":"10. Revitalization Summary","index":10,"n_rows":75,"n_cols":8,"rows_kept":75}
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)&\": Results Summary\"","v":": Results Summary"}]
["Tool Summary",{"$f":"IF('3. Property Inventory'!B4=\"\",\"\",'3. Property Inventory'!B4)","v":""},"Potential Constraints"]
[]
["Property Name",{"$f":"IF('3. Property Inventory'!B4=\"\",\"No data\",'3. Property Inventory'!B4)","v":"No data"}]
["Address",{"$f":"IF('3. Property Inventory'!B5=\"\",\"No data\",'3. Property Inventory'!B5)","v":"No data"}]
["Town, State",{"$f":"IF('3. Property Inventory'!B9=\"\",\"No data\",'3. Property Inventory'!B9&\", \"&'3. Property Inventory'!B10)","v":"No data"}]
["Point of contact",{"$f":"IF('3. Property Inventory'!B7=\"\",\"No data\",'3. Property Inventory'!B7)","v":"No data"}]
[]
["Property size",{"$f":"IF('4. Property Characteristics'!B5=0,\"No data\",TEXT('4. Property Characteristics'!B5,\"#,###\")&\" acres\")","v":"No data"}]
["Developable acreage",{"$f":"IF('4. Property Characteristics'!B49=0,\"No data\",TEXT('4. Property Characteristics'!B49,\"#,###\")&\" acres\")","v":"No data"},{"$f":"IF(OR('4. Property Characteristics'!B8=\"Yes\",'4. Property Characteristics'!B13=\"Yes\",'4. Property Characteristics'!B19=\"Yes\",'4. Property Characteristics'!B24=\"Yes\",'4. Property Characteristics'!B29=\"Yes\",'4. Property Characteristics'!B34=\"Yes\",'4. Property Characteristics'!B39=\"Yes\",'4. Property Characteristics'!B44=\"Yes\"),\"One or more constraints affecting useable acerage are present\",\"\")","v":""}]
["Maximum allowable lot coverage",{"$f":"IF('5. Land Use Characteristics'!B66=0,\"No data\",'5. Land Use Characteristics'!B66)","v":"No data"}]
["Floor to area ratio (FAR)",{"$f":"IF('5. Land Use Characteristics'!B68=0,\"No data\",'5. Land Use Characteristics'!B68)","v":"No data"}]
["Maximum building height",{"$f":"IF('5. Land Use Characteristics'!B69=0,\"No data\",'5. Land Use Characteristics'!B69)","v":"No data"}]
[]
["Number of buildings/structures onsite",{"$f":"IF('4. Property Characteristics'!B64=\"No\",\"None\",IF('4. Property Characteristics'!B65=0,\"No data\",'4. Property Characteristics'!B65))","v":"No data"},{"$f":"IF(COUNTIF('4. Property Characteristics'!G68:G78,\"Yes\")>0,\"One or more buildings will require demolition\",\"\")","v":""}]
["Total square footage of buildings/structures onsite",{"$f":"IF(B15=\"None\",\"N/A\",IF('4. Property Characteristics'!C79=0,\"No data\",TEXT('4. Property Characteristics'!C79,\"#,###\")&\" SF\"))","v":"No data"}]
["Are asbestos containing materials in any structures?",{"$f":"IF(COUNTIF('4. Property Characteristics'!H68:H78,\"Yes\")>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTIF('4. Property Characteristics'!H68:H78,\"Yes\")>0,\"Asbestos will need to be investigated and abated\",\"\")","v":""}]
[]
["Has a Phase I Environmental Assessment ",{"$f":"IF('6. Environmental'!B4=0,\"No data\",'6. Environmental'!B4)","v":"No data"},{"$f":"IF('6. Environmental'!B4=\"No\",\"A Phase I Environmental site Assessment may be needed\",\"\")","v":""}]
["Have All Appropriate Inquiries been conducted",{"$f":"IF('6. Environmental'!B5=0,\"No data\",'6. Environmental'!B5)","v":"No data"},{"$f":"IF('6. Environmental'!B5=\"No\",\"An All Appropriate Inquiries may be needed\",IF('6. Environmental'!B4=\"Yes\",IF(OR('6. Environmental'!B5=\"No\",'6. Environmental'!B5=0),\"All Appropriate Inquiries Not Complete\",\"\"),\"\"))","v":""}]
["Has the property been assessed?",{"$f":"IF('6. Environmental'!B8=0,\"No data\",IF('6. Environmental'!B8=\"Yes\",'6. Environmental'!B8&\": \"&'6. Environmental'!B9,'6. Environmental'!B8))","v":"No data"},{"$f":"IF('6. Environmental'!B8=0,\"\",IF(OR('6. Environmental'!B8=\"No\",'6. Environmental'!B9<>\"Fully characterized (no additional testing recommended)\"),\"Completing a property assessment can facilitate redevelopment\",\"\"))","v":""}]
["Is there known contamination?",{"$f":"IF('6. Environmental'!B11=0,\"No data\",'6. Environmental'!B11)","v":"No data"},{"$f":"IF('6. Environmental'!B11=\"Yes\",\"The environmental condition of the property will need to be addressed\",\"\")","v":""}]
["Has remedial action been conducted",{"$f":"IF('6. Environmental'!B13=0,\"No data\",IF(AND('6. Environmental'!B11=\"Yes\",'6. Environmental'!B13<>\"Remedial Action Complete\"),'6. Environmental'!B13,\"Remedial Action Not Required\"))","v":"No data"},{"$f":"IF(AND('6. Environmental'!B11=\"Yes\",'6. Environmental'!B13<>\"Remedial Action Complete\"),\"Remedial Action May be Required\",\"\")","v":""}]
["Will  investigation or remedial action be required after development or property transfer?",{"$f":"IF(OR('6. Environmental'!B32=\"No\",'6. Environmental'!B33=\"Yes\",'6. Environmental'!B34=\"Yes\"),\"Yes\",\"\")","v":""},{"$f":"IF(B24=\"Yes\",\"Responsibility for environmental condition will need to be addressed\",\"\")","v":""}]
["Estimated remediation cost",{"$f":"IF('12. Pro Forma Data Inputs'!B8=0,\"No data\",SUM('6. Environmental'!B38:B42))","v":"No data"},{"$f":"IF(AND('6. Environmental'!B12=\"Yes\",'6. Environmental'!B15=\"No\"),\"Remedial Action May be Required\",\"\")","v":""}]
[]
["Is there public water onsite?",{"$f":"IF('5. Land Use Characteristics'!B9=0,\"No data\",'5. Land Use Characteristics'!B9)","v":"No data"},{"$f":"IF('5. Land Use Characteristics'!B9=\"No\",\"May be a constraint for development\",\"\")","v":""}]
["Is there sanitary sewer onsite?",{"$f":"IF('5. Land Use Characteristics'!B17=0,\"No data\",'5. Land Use Characteristics'!B17)","v":"No data"},{"$f":"IF('5. Land Use Characteristics'!B17=\"No\",\"May be a constraint for development\",\"\")","v":""}]
["Current zoning",{"$f":"IF('5. Land Use Characteristics'!B28=0,\"No data\",'5. Land Use Characteristics'!B28)","v":"No data"}]
[]
["Are access roads in good condition?",{"$f":"IF('5. Land Use Characteristics'!B74=0,\"No data\",'5. Land Use Characteristics'!B74)","v":"No data"},{"$f":"IF('5. Land Use Characteristics'!B74=\"No\",\"May be a constraint for development\",\"\")","v":""}]
["Is the property centrally located?",{"$f":"IF('5. Land Use Characteristics'!B89=0,\"No data\",'5. Land Use Characteristics'!B89)","v":"No data"}]
["Is the property within close proximity to passenger rail access?",{"$f":"IF('5. Land Use Characteristics'!B96=0,\"No data\",'5. Land Use Characteristics'!B96)","v":"No data"}]
["Is the property within close proximity to cargo rail access?",{"$f":"IF('5. Land Use Characteristics'!B98=0,\"No data\",'5. Land Use Characteristics'!B98)","v":"No data"}]
["Does the property border a navigable waterway?",{"$f":"IF('5. Land Use Characteristics'!B103=0,\"No data\",'5. Land Use Characteristics'!B103)","v":"No data"}]
[]
["Town/city population",{"$f":"IF('8. Demographics'!B4=0,\"No data\",'8. Demographics'!B4)","v":"No data"}]
["How would you describe your community?",{"$f":"IF('7. Community'!B4=0,\"No data\",'7. Community'!B4)","v":"No data"}]
["Are there unique economic drivers in the region?",{"$f":"IF('7. Community'!B21=0,\"No data\",'7. Community'!B21)","v":"No data"}]
["Do economic incentives exist for your community?",{"$f":"IF('7. Community'!B46=0,\"No data\",'7. Community'!B46)","v":"No data"}]
["What are the fastest growing areas of employment in the town/city?",{"$f":"IF(COUNTIF('8. Demographics'!B88:B96,\"Yes\")=0,\"No data\",('8. Demographics'!C88&'8. Demographics'!C89&'8. Demographics'!C90&'8. Demographics'!C91&'8. Demographics'!C92&'8. Demographics'!C93&'8. Demographics'!C94&'8. Demographics'!C95&'8. Demographics'!C96))","v":"No data"}]
["What are the fastest declining areas of employment in the town/city?",{"$f":"IF(COUNTIF('8. Demographics'!B99:B107,\"Yes\")=0,\"No data\",('8. Demographics'!C99&'8. Demographics'!C100&'8. Demographics'!C101&'8. Demographics'!C102&'8. Demographics'!C103&'8. Demographics'!C104&'8. Demographics'!C105&'8. Demographics'!C106&'8. Demographics'!C107))","v":"No data"}]
["What sectors are vibrant and growing?",{"$f":"IF(COUNTIF('8. Demographics'!B142:B151,\"Yes\")=0,\"No data\",('8. Demographics'!C142&'8. Demographics'!C143&'8. Demographics'!C144&'8. Demographics'!C145&'8. Demographics'!C146&'8. Demographics'!C147&'8. Demographics'!C148&'8. Demographics'!C149&'8. Demographics'!C150&'8. Demographics'!C151))","v":"No data"}]
[]
["Is there a large professional workforce?",{"$f":"IF('8. Demographics'!B33=0,\"No data\",'8. Demographics'!B33)","v":"No data"}]
["Is there a large skilled or semi-skilled workforce?",{"$f":"IF('8. Demographics'!B34=0,\"No data\",'8. Demographics'!B34)","v":"No data"}]
["Current unemployment rate of the town/city",{"$f":"IF('8. Demographics'!B38=0,\"No data\",'8. Demographics'!B38)","v":"No data"}]
[]
["Reuse Summary"]
[]
["Uses that may be viable at the site:",null,"Property","Land Use","Environmental","Community","Demographics","Market"]
[{"$f":"IF('9. Market Assessment'!E9=\"Fatal Flaw: Unviable Use\",\"\",'9. Market Assessment'!A9)","v":"Residential Market"},{"$f":"IF(OR('4. Property Characteristics'!B52=\"Yes\", '9. Market Assessment'!E9=\"Yes\"),\"Use May Not be Viable - See Below\",'9. Market Assessment'!E9)","v":0},{"$f":"IF('4. Property Characteristics'!B52=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!H$4","v":0},{"$f":"'6. Environmental'!H$3","v":0},{"$f":"'7. Community'!I$3","v":0},{"$f":"'8. Demographics'!H$4","v":0},{"$f":"IF('9. Market Assessment'!E9=\"Use May Not Be Viable\",999,'9. Market Assessment'!C29)","v":0}]
[{"$f":"'9. Market Assessment'!A31","v":"Commercial (Professional/Office) Market"},{"$f":"IF(OR('4. Property Characteristics'!B53=\"Yes\", '9. Market Assessment'!E31=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E31)","v":0},{"$f":"IF('4. Property Characteristics'!B53=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!I$4","v":0},{"$f":"'6. Environmental'!I$3","v":0},{"$f":"'7. Community'!J$3","v":0},{"$f":"'8. Demographics'!I$4","v":0},{"$f":"IF('9. Market Assessment'!E31=\"Use May Not Be Viable\",999,'9. Market Assessment'!C41)","v":0}]
[{"$f":"'9. Market Assessment'!A43","v":"Retail Market"},{"$f":"IF(OR('4. Property Characteristics'!B54=\"Yes\", '9. Market Assessment'!E43=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E43)","v":0},{"$f":"IF('4. Property Characteristics'!B54=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!J$4","v":0},{"$f":"'6. Environmental'!J$3","v":0},{"$f":"'7. Community'!K$3","v":0},{"$f":"'8. Demographics'!J$4","v":0},{"$f":"IF('9. Market Assessment'!E43=\"Use May Not Be Viable\",999,'9. Market Assessment'!C61)","v":0}]
[{"$f":"'9. Market Assessment'!A63","v":"Industrial Market (excluding warehouse)"},{"$f":"IF(OR('4. Property Characteristics'!B55=\"Yes\", '9. Market Assessment'!E63=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E63)","v":0},{"$f":"IF('4. Property Characteristics'!B55=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!K$4","v":0},{"$f":"'6. Environmental'!K$3","v":0},{"$f":"'7. Community'!L3","v":0},{"$f":"'8. Demographics'!K$4","v":0},{"$f":"IF('9. Market Assessment'!E63=\"Use May Not Be Viable\",999,'9. Market Assessment'!C73)","v":0}]
[{"$f":"'9. Market Assessment'!A75","v":"Warehouse Distribution Market"},{"$f":"IF(OR('4. Property Characteristics'!B56=\"Yes\", '9. Market Assessment'!E75=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E75)","v":0},{"$f":"IF('4. Property Characteristics'!B56=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!L$4","v":0},{"$f":"'6. Environmental'!L$3","v":0},{"$f":"'7. Community'!M$3","v":0},{"$f":"'8. Demographics'!L$4","v":0},{"$f":"IF('9. Market Assessment'!E75=\"Use May Not Be Viable\",999,'9. Market Assessment'!C85)","v":0}]
[{"$f":"'9. Market Assessment'!A87","v":"Hotel/Hospitality Market"},{"$f":"IF(OR('4. Property Characteristics'!B57=\"Yes\", '9. Market Assessment'!E87=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E87)","v":0},{"$f":"IF('4. Property Characteristics'!B57=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!M$4","v":0},{"$f":"'6. Environmental'!M$3","v":0},{"$f":"'7. Community'!N$3","v":0},{"$f":"'8. Demographics'!M$4","v":0},{"$f":"IF('9. Market Assessment'!E87=\"Use May Not Be Viable\",999,'9. Market Assessment'!C93)","v":0}]
[{"$f":"'9. Market Assessment'!A95","v":"Mixed Use Market"},{"$f":"IF(OR('4. Property Characteristics'!B58=\"Yes\", '9. Market Assessment'!E95=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E95&\" - See List of Uses That Might Not Be Viable Below\")","v":"0 - See List of Uses That Might Not Be Viable Below"},{"$f":"IF('4. Property Characteristics'!B58=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!N$4","v":0},{"$f":"'6. Environmental'!N$3","v":0},{"$f":"'7. Community'!O$3","v":0},{"$f":"'8. Demographics'!N$4","v":0},{"$f":"IF('9. Market Assessment'!E95=\"Use May Not Be Viable\",999,'9. Market Assessment'!C102)","v":0}]
[{"$f":"'9. Market Assessment'!A104","v":"Energy"},{"$f":"IF(OR('4. Property Characteristics'!B59=\"Yes\", '9. Market Assessment'!E104=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E104)","v":0},{"$f":"IF('4. Property Characteristics'!B59=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!O$4","v":0},{"$f":"'6. Environmental'!O$3","v":0},{"$f":"'7. Community'!P$3","v":0},{"$f":"'8. Demographics'!O$4","v":0},{"$f":"IF('9. Market Assessment'!E104=\"Use May Not Be Viable\",999,'9. Market Assessment'!C112)","v":0}]
[{"$f":"'9. Market Assessment'!A114","v":"Greenspace"},{"$f":"IF(OR('4. Property Characteristics'!B60=\"Yes\", '9. Market Assessment'!E114=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E114)","v":0},{"$f":"IF('4. Property Characteristics'!B60=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!P$4","v":0},{"$f":"'6. Environmental'!P$3","v":0},{"$f":"'7. Community'!Q$3","v":0},{"$f":"'8. Demographics'!P$4","v":0},{"$f":"IF('9. Market Assessment'!E114=\"Use May Not Be Viable\",999,'9. Market Assessment'!C121)","v":0}]
[{"$f":"'9. Market Assessment'!A123","v":"Government"},{"$f":"IF(OR('4. Property Characteristics'!B61=\"Yes\", '9. Market Assessment'!E123=\"Yes\"), \"Use May Not be Viable - See Below\",'9. Market Assessment'!E123)","v":0},{"$f":"IF('4. Property Characteristics'!B61=\"Yes\",999, 0)","v":0},{"$f":"'5. Land Use Characteristics'!Q$4","v":0},{"$f":"'6. Environmental'!Q$3","v":0},{"$f":"'7. Community'!R$3","v":0},{"$f":"'8. Demographics'!Q$4","v":0},{"$f":"IF('9. Market Assessment'!E123=\"Use May Not Be Viable\",999,'9. Market Assessment'!C129)","v":0}]
["NOTE: Land use scores can vary from a negative number (i.e. -5) to a positive number as high as 40.  The values will depend on whether or not all questions are answered, as well as the answers themselves.  These scores are not intended to be a ranking. Instead, the scores are intended to help communities identify land uses that more likely to be successful as compared to other potential land uses on the same property.  Land uses scoring within one or two points of each other have similar potential for success.  Likewise, when land use scores vary substantially, the higher scoring land uses have the most potential for success."]
[]
[]
["Uses that may not be viable at the site and the rationale behind the designation:"]
[{"$f":"IF(AND('9. Market Assessment'!E9=\"Use May Not be Viable\",C66=\"\",E66=\"\",D66=\"\",G66=\"\"),'9. Market Assessment'!A9&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E9=\"Use May Not be Viable\",'4. Property Characteristics'!B52=\"yes\"),'9. Market Assessment'!A9&\": \"&C66&D66&E66&G66,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B52=\"yes\",'4. Property Characteristics'!D52<>\"\"),'4. Property Characteristics'!D52&\".  \",IF('4. Property Characteristics'!B52=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B55=\"yes\",'5. Land Use Characteristics'!D55<>\"\"),'5. Land Use Characteristics'!D55&\".  \",IF('5. Land Use Characteristics'!B55=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B17=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B154=\"yes\",'8. Demographics'!D154<>\"\"),'8. Demographics'!D154&\".  \",IF('8. Demographics'!B154=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E9=\"Use May Not be Viable\",'9. Market Assessment'!E9,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E31=\"Use May Not be Viable\",C67=\"\",E67=\"\",D67=\"\",G67=\"\"),'9. Market Assessment'!A31&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E31=\"Use May Not be Viable\",'4. Property Characteristics'!B53=\"yes\"),'9. Market Assessment'!A31&\": \"&C67&D67&E67&G67,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B53=\"yes\",'4. Property Characteristics'!D53<>\"\"),'4. Property Characteristics'!D53&\".  \",IF('4. Property Characteristics'!B53=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B56=\"yes\",'5. Land Use Characteristics'!D56<>\"\"),'5. Land Use Characteristics'!D56&\".  \",IF('5. Land Use Characteristics'!B56=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B18=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B155=\"yes\",'8. Demographics'!D155<>\"\"),'8. Demographics'!D155&\".  \",IF('8. Demographics'!B155=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E31=\"Use May Not be Viable\",'9. Market Assessment'!E31,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E43=\"Use May Not be Viable\",C68=\"\",E68=\"\",D68=\"\",G68=\"\"),'9. Market Assessment'!A43&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E43=\"Use May Not be Viable\",'4. Property Characteristics'!B54=\"yes\"),'9. Market Assessment'!A43&\": \"&C68&D68&E68&G68,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B54=\"yes\",'4. Property Characteristics'!D54<>\"\"),'4. Property Characteristics'!D54&\".  \",IF('4. Property Characteristics'!B54=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B57=\"yes\",'5. Land Use Characteristics'!D57<>\"\"),'5. Land Use Characteristics'!D57&\".  \",IF('5. Land Use Characteristics'!B57=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B19=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B156=\"yes\",'8. Demographics'!D156<>\"\"),'8. Demographics'!D156&\".  \",IF('8. Demographics'!B156=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E43=\"Use May Not be Viable\",'9. Market Assessment'!E43,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E63=\"Use May Not be Viable\",C69=\"\",E69=\"\",D69=\"\",G69=\"\"),'9. Market Assessment'!A63&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E63=\"Use May Not be Viable\",'4. Property Characteristics'!B55=\"yes\"),'9. Market Assessment'!A63&\": \"&C69&D69&E69&G69,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B55=\"yes\",'4. Property Characteristics'!D55<>\"\"),'4. Property Characteristics'!D55&\".  \",IF('4. Property Characteristics'!B55=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B58=\"yes\",'5. Land Use Characteristics'!D58<>\"\"),'5. Land Use Characteristics'!D58&\".  \",IF('5. Land Use Characteristics'!B58=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B20=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B157=\"yes\",'8. Demographics'!D157<>\"\"),'8. Demographics'!D157&\".  \",IF('8. Demographics'!B157=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E63=\"Use May Not be Viable\",'9. Market Assessment'!E63,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E75=\"Use May Not be Viable\",C70=\"\",D70=\"\",E70=\"\",G70=\"\"),'9. Market Assessment'!A75&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E75=\"Use May Not be Viable\",'4. Property Characteristics'!B56=\"yes\"),'9. Market Assessment'!A75&\": \"&C70&D70&E70&G70,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!$B$49>0,'4. Property Characteristics'!$B$49<1),\"Warehouse use restricted because property size is less than one acre.  ,\", IF(AND('4. Property Characteristics'!B56=\"yes\",'4. Property Characteristics'!D56<>\"\"),'4. Property Characteristics'!D56&\".  \",IF('4. Property Characteristics'!B56=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\")))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B59=\"yes\",'5. Land Use Characteristics'!D59<>\"\"),'5. Land Use Characteristics'!D59&\".  \",IF('5. Land Use Characteristics'!B59=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B21=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B158=\"yes\",'8. Demographics'!D158<>\"\"),'8. Demographics'!D158&\".  \",IF('8. Demographics'!B158=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E75=\"Use May Not be Viable\",'9. Market Assessment'!E75,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E87=\"Use May Not be Viable\",C71=\"\",E71=\"\",D71=\"\",G71=\"\"),'9. Market Assessment'!A87&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E87=\"Use May Not be Viable\",'4. Property Characteristics'!B57=\"yes\"),'9. Market Assessment'!A87&\": \"&C71&D71&E71&G71,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B57=\"yes\",'4. Property Characteristics'!D57<>\"\"),'4. Property Characteristics'!D57&\".  \",IF('4. Property Characteristics'!B57=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B60=\"yes\",'5. Land Use Characteristics'!D60<>\"\"),'5. Land Use Characteristics'!D60&\".  \",IF('5. Land Use Characteristics'!B60=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B22=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B159=\"yes\",'8. Demographics'!D159<>\"\"),'8. Demographics'!D159&\".  \",IF('8. Demographics'!B159=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E87=\"Use May Not be Viable\",'9. Market Assessment'!E87,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E95=\"Use May Not be Viable\",C72=\"\",E72=\"\",D72=\"\",G72=\"\"),'9. Market Assessment'!A95&\": Tool designated fatal flaw.  \",IF(OR('9. Market Assessment'!E95=\"Use May Not be Viable\",'4. Property Characteristics'!B58=\"yes\"),'9. Market Assessment'!A95&\": \"&C72&D72&E72&G72,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B58=\"yes\",'4. Property Characteristics'!D58<>\"\"),'4. Property Characteristics'!D58&\".  \",IF('4. Property Characteristics'!B58=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B61=\"yes\",'5. Land Use Characteristics'!D61<>\"\"),'5. Land Use Characteristics'!D61&\".  \",IF('5. Land Use Characteristics'!B61=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B23=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B160=\"yes\",'8. Demographics'!D160<>\"\"),'8. Demographics'!D160&\".  \",IF('8. Demographics'!B160=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E95=\"Use May Not be Viable\",'9. Market Assessment'!E95,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E104=\"Use May Not be Viable\",C73=\"\",E73=\"\",D73=\"\",G73=\"\"),'9. Market Assessment'!A104&\": Tool designated fatal flaw.  \",IF('9. Market Assessment'!E104=\"Use May Not be Viable\",'9. Market Assessment'!A104&\": \"&C73&D73&E73&G73,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B59=\"yes\",'4. Property Characteristics'!D59<>\"\"),'4. Property Characteristics'!D59&\".  \",IF('4. Property Characteristics'!B59=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B62=\"yes\",'5. Land Use Characteristics'!D62<>\"\"),'5. Land Use Characteristics'!D62&\".  \",IF('5. Land Use Characteristics'!B62=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B24=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B161=\"yes\",'8. Demographics'!D161<>\"\"),'8. Demographics'!D161&\".  \",IF('8. Demographics'!B161=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E104=\"Use May Not be Viable\",'9. Market Assessment'!E104,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E114=\"Use May Not be Viable\",C74=\"\",E74=\"\",D74=\"\",G74=\"\"),'9. Market Assessment'!A114&\": Tool designated fatal flaw.  \",IF('9. Market Assessment'!E114=\"Use May Not be Viable\",'9. Market Assessment'!A114&\": \"&C74&E74&D74&G74,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B60=\"yes\",'4. Property Characteristics'!D60<>\"\"),'4. Property Characteristics'!D60&\".  \",IF('4. Property Characteristics'!B60=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B63=\"yes\",'5. Land Use Characteristics'!D63<>\"\"),'5. Land Use Characteristics'!D63&\".  \",IF('5. Land Use Characteristics'!B63=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B25=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B162=\"yes\",'8. Demographics'!D162<>\"\"),'8. Demographics'!D162&\".  \",IF('8. Demographics'!B162=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E114=\"Use May Not be Viable\",'9. Market Assessment'!E114,\"\")","v":""}]
[{"$f":"IF(AND('9. Market Assessment'!E123=\"Use May Not be Viable\",C75=\"\",E75=\"\",D75=\"\",G75=\"\"),'9. Market Assessment'!A123&\": Tool designated fatal flaw.  \",IF('9. Market Assessment'!E123=\"Use May Not be Viable\",'9. Market Assessment'!A123&\": \"&C75&E75&D75&G75,\"\"))","v":""},null,{"$f":"IF(AND('4. Property Characteristics'!B61=\"yes\",'4. Property Characteristics'!D61<>\"\"),'4. Property Characteristics'!D61&\".  \",IF('4. Property Characteristics'!B61=\"yes\",\"User-identified not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF(AND('5. Land Use Characteristics'!B64=\"yes\",'5. Land Use Characteristics'!D64<>\"\"),'5. Land Use Characteristics'!D64&\".  \",IF('5. Land Use Characteristics'!B64=\"yes\",\"User identified land use policy not viable, no detailed rationale provided.  \",\"\"))","v":""},{"$f":"IF('6. Environmental'!B26=\"Yes\",\"Land use restricted by environmental contamination.  \",\"\")","v":""},null,{"$f":"IF(AND('8. Demographics'!B163=\"yes\",'8. Demographics'!D163<>\"\"),'8. Demographics'!D163&\".  \",IF('8. Demographics'!B163=\"yes\",\"User identified local economy not viable, no detail provided.  \",\"\"))","v":""},{"$f":"IF('9. Market Assessment'!E123=\"Use May Not be Viable\",'9. Market Assessment'!E123,\"\")","v":""}]

{"sheet":"11. Constraints","index":11,"n_rows":3,"n_cols":3,"rows_kept":3,"merged":[[0,0,0,2]]}
["Enter constraint information information in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)","v":""}]
["Constraint","Potential Liabilites and Risks","Opportunity"]

{"sheet":"12. Pro Forma Data Inputs","index":12,"n_rows":66,"n_cols":4,"rows_kept":66,"merged":[[0,0,0,2]]}
["Enter Pro Forma Data in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)&\": Pro Forma Inputs\"","v":": Pro Forma Inputs"}]
["Site Cleanup"]
["Estimated Cost of Building Abatement (lead based paint, asbestos, or other hazardous materials)",{"$f":"'4. Property Characteristics'!$I$79","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Soil Remediation ($)",{"$f":"'6. Environmental'!B38","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Groundwater Remediation ($)",{"$f":"'6. Environmental'!B39","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Other Remediation ($)",{"$f":"'6. Environmental'!B42+'6. Environmental'!B40","v":{"v":0,"d":"$0"}}]
["Total Remediation Cost",{"$f":"SUM(B4:B7)","v":{"v":0,"d":"$0"}}]
[]
[]
["Ongoing remediation O&M ($)",{"$f":"'6. Environmental'!B41","v":{"v":0,"d":"$0"}},"per year"]
["Environmental Insurance (if required) ($)",{"v":0,"d":"$0"},"annual premium"]
[]
["Construction Costs "]
[null,"Cost/SF ($)"]
["Demolition",{"$f":"IF('4. Property Characteristics'!B64=\"No\",\"No existing buildings/structures onsite\",\"\")","v":""}]
["Buildings/structures",null,"per SF"]
["Concrete pad/parking",null,"per SF"]
[]
["Building Reuse-Renovation",{"$f":"IF('4. Property Characteristics'!B64=\"No\",\"No existing buildings/structures onsite\",\"\")","v":""}]
["Residential",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$9=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Commercial (Professional/Office)",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$31=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Retail",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$43=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Industrial",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$63=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Warehouse",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$75=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Hotel/Hospitality",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$87=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[]
["New Construction"]
["Residential",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$9=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Commercial (Professional/Office)",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$31=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Retail",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$43=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Industrial",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$63=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Warehouse",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$75=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Hotel/Hospitality",null,"per SF",{"$f":"IF('9. Market Assessment'!$E$87=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[]
["Parking","Cost/Parking Spot ($)"]
["Cost per parking spot including preparation, submaterials and pavement",null,"per parking spot"]
[]
["Soft Costs"]
[{"v":0.2,"d":"20%"},"of hard costs"]
["See page 28 of the Tool Handbook for information related to estimation of soft costs"]
[]
["Carrying Costs"]
["Period (months)",null,"months"]
["Interest Rate (%)"]
["See page 29 of the Tool Handbook for information related to estimation of carrying costs"]
[]
["Income"]
["Residential",null,"rent per 2 bedroom apartment per month",{"$f":"IF('9. Market Assessment'!$E$9=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Commercial (Professional/Office)",null,"per SF NNN",{"$f":"IF('9. Market Assessment'!$E$31=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Retail",null,"per SF NNN",{"$f":"IF('9. Market Assessment'!$E$43=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Industrial",null,"per SF NNN",{"$f":"IF('9. Market Assessment'!$E$63=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Warehouse",null,"per SF NNN",{"$f":"IF('9. Market Assessment'!$E$75=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Hotel/Hospitality",null,"per room per night",{"$f":"IF('9. Market Assessment'!$E$87=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[]
["Vacancy Rate"]
["Residential",null,null,{"$f":"IF('9. Market Assessment'!$E$9=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Commercial (Professional/Office)",null,null,{"$f":"IF('9. Market Assessment'!$E$31=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Retail",null,null,{"$f":"IF('9. Market Assessment'!$E$43=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Industrial",null,null,{"$f":"IF('9. Market Assessment'!$E$63=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Warehouse",null,null,{"$f":"IF('9. Market Assessment'!$E$75=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
["Hotel/Hospitality",null,null,{"$f":"IF('9. Market Assessment'!$E$87=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[]
["Capitalization Rate"]
["Capitalization Rate (%)"]
["See pages 3-4 of the Tool Handbook for information related to capitalization rates"]

{"sheet":"13. Pro Forma Tool","index":13,"n_rows":93,"n_cols":6,"rows_kept":93,"merged":[[0,0,0,5],[74,1,74,2],[74,3,74,4]]}
["Enter Pro Forma Data in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)&\": Pro Forma Output Page 1\"","v":": Pro Forma Output Page 1"}]
["Purchase Price",{"$nulls":4},{"$f":"B4","v":{"v":0,"d":"$0"}}]
["Purchase Price ($)"]
[]
["Remediation Costs For Project",{"$nulls":4},{"$f":"B15","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Building Abatement ($)",{"$f":"'12. Pro Forma Data Inputs'!B4","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Soil Remediation ($)",{"$f":"'12. Pro Forma Data Inputs'!B5","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Groundwater Remediation ($)",{"$f":"'12. Pro Forma Data Inputs'!B6","v":{"v":0,"d":"$0"}}]
["Estimated Cost of Other Remediation ($)",{"$f":"'12. Pro Forma Data Inputs'!B7","v":{"v":0,"d":"$0"}}]
["Total Remediation Cost",{"$f":"SUM(B7:B10)","v":{"v":0,"d":"$0"}}]
[]
["Remediation costs paid for through incentives or other programs"]
[]
["Adjusted Remediation Cost",{"$f":"IF(B11-B13<0,\"Incentives are greater than cost of remediation; check data entry\",B11-B13)","v":{"v":0,"d":"$0"}}]
[]
["Hard Costs / Construction Costs based on Selected Redevelopment Concept",{"$nulls":4},{"$f":"E38+E55","v":{"v":0,"d":"$0"}}]
["Existing Building Summary",{"$f":"IF('4. Property Characteristics'!B64=\"No\",\"No existing buildings/structures onsite\",\"\")","v":""},null,"Existing Parking Summary"]
["Existing building/structure # 1",{"$f":"('4. Property Characteristics'!C68)","v":0},"SF","Parking",{"$f":"'4. Property Characteristics'!K79","v":0},"SF"]
["Existing building/structure # 2",{"$f":"('4. Property Characteristics'!C69)","v":0},"SF","Parking spaces",{"$f":"'4. Property Characteristics'!J79","v":0},"spaces"]
["Existing building/structure # 3",{"$f":"('4. Property Characteristics'!C70)","v":0},"SF"]
["Existing building/structure # 4",{"$f":"('4. Property Characteristics'!C71)","v":0},"SF"]
["Existing building/structure # 5",{"$f":"('4. Property Characteristics'!C72)","v":0},"SF"]
["Existing building/structure # 6",{"$f":"('4. Property Characteristics'!C73)","v":0},"SF"]
["Existing building/structure # 7",{"$f":"('4. Property Characteristics'!C74)","v":0},"SF"]
["Existing building/structure # 8",{"$f":"('4. Property Characteristics'!C75)","v":0},"SF"]
["Existing building/structure # 9",{"$f":"('4. Property Characteristics'!C76)","v":0},"SF"]
["Existing building/structure # 10",{"$f":"('4. Property Characteristics'!C77)","v":0},"SF"]
["Total building/structure SF",{"$f":"SUM(B19:B28)","v":0},"SF"]
[]
["Reuse/Renovation of Existing Buildings","Square Footage","Cost/SF ($)","Number of Finished Units","Subtotal"]
[{"$f":"\"Renovate for \"&'12. Pro Forma Data Inputs'!A21","v":"Renovate for Residential"},null,{"$f":"'12. Pro Forma Data Inputs'!B21","v":{"v":0,"d":"$0"}},null,{"$f":"B32*C32","v":{"v":0,"d":"$0"}}]
[{"$f":"\"Renovate for \"&'12. Pro Forma Data Inputs'!A22","v":"Renovate for Commercial (Professional/Office)"},null,{"$f":"'12. Pro Forma Data Inputs'!B22","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
[{"$f":"\"Renovate for \"&'12. Pro Forma Data Inputs'!A23","v":"Renovate for Retail"},null,{"$f":"'12. Pro Forma Data Inputs'!B23","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
[{"$f":"\"Renovate for \"&'12. Pro Forma Data Inputs'!A24","v":"Renovate for Industrial"},null,{"$f":"'12. Pro Forma Data Inputs'!B24","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
[{"$f":"\"Renovate for \"&'12. Pro Forma Data Inputs'!A25","v":"Renovate for Warehouse"},null,{"$f":"'12. Pro Forma Data Inputs'!B25","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
[{"$f":"\"Renovate for \"&'12. Pro Forma Data Inputs'!A26","v":"Renovate for Hotel/Hospitality"},null,{"$f":"'12. Pro Forma Data Inputs'!B26","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"}]
[{"$nulls":3},"Subtotal Hard Costs Existing Buildings",{"$f":"SUM(E32:E37)","v":{"v":0,"d":"$0"}}]
[null,{"$f":"IF(SUM(B32:B37)>B29,\"Proposed renovation SF exceeds SF of existing buildings. Check data entry.\",\"\")","v":""}]
[]
["New Construction","Square Footage","Cost/SF ($)","Number of Finished Units","Subtotal"]
["Demolish Existing Building/Structure(s)",null,{"$f":"'12. Pro Forma Data Inputs'!B17","v":{"v":0,"d":"$0"}},null,{"$f":"B42*C42","v":{"v":0,"d":"$0"}}]
["Demolish Concrete Pads/Parking",null,{"$f":"'12. Pro Forma Data Inputs'!B18","v":{"v":0,"d":"$0"}},null,{"$f":"B43*C43","v":{"v":0,"d":"$0"}}]
[]
[{"$f":"\"Construct New \"&'12. Pro Forma Data Inputs'!A29","v":"Construct New Residential"},null,{"$f":"'12. Pro Forma Data Inputs'!B29","v":{"v":0,"d":"$0"}},null,{"$f":"B45*C45","v":{"v":0,"d":"$0"}},{"$f":"IF('9. Market Assessment'!$E$9=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[{"$f":"\"Construct New \"&'12. Pro Forma Data Inputs'!A30","v":"Construct New Commercial (Professional/Office)"},null,{"$f":"'12. Pro Forma Data Inputs'!B30","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"IF('9. Market Assessment'!$E$31=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[{"$f":"\"Construct New \"&'12. Pro Forma Data Inputs'!A31","v":"Construct New Retail"},null,{"$f":"'12. Pro Forma Data Inputs'!B31","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"IF('9. Market Assessment'!$E$43=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[{"$f":"\"Construct New \"&'12. Pro Forma Data Inputs'!A32","v":"Construct New Industrial"},null,{"$f":"'12. Pro Forma Data Inputs'!B32","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"IF('9. Market Assessment'!$E$63=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[{"$f":"\"Construct New \"&'12. Pro Forma Data Inputs'!A33","v":"Construct New Warehouse"},null,{"$f":"'12. Pro Forma Data Inputs'!B33","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"IF('9. Market Assessment'!$E$75=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[{"$f":"\"Construct New \"&'12. Pro Forma Data Inputs'!A34","v":"Construct New Hotel/Hospitality"},null,{"$f":"'12. Pro Forma Data Inputs'!B34","v":{"v":0,"d":"$0"}},null,{"v":0,"d":"$0"},{"$f":"IF('9. Market Assessment'!$E$87=\"Fatal Flaw: Unviable Use\",\"Fatal Flaw: Unviable Use\",\"\")","v":""}]
[]
["Parking"]
[null,"Number of Parking Spots","Cost/Parking Spot ($)",null,"Subtotal"]
["Construct New Parking",null,{"$f":"'12. Pro Forma Data Inputs'!B37","v":{"v":0,"d":"$0"}},null,{"$f":"B54*C54","v":{"v":0,"d":"$0"}}]
[{"$nulls":3},"Subtotal Hard Costs New Construction",{"$f":"SUM(E45:E54)","v":{"v":0,"d":"$0"}}]
[]
[{"$f":"IF('4. Property Characteristics'!#REF!=\"\",\"\",'4. Property Characteristics'!#REF!)&\": Pro Forma Output Page 2\"","v":{"$error":"#REF!"}}]
["Soft Costs",{"$nulls":4},{"$f":"(F17+F6)*B59","v":{"v":0,"d":"$0"}}]
["Percentage of hard costs and remediation costs",{"$f":"'12. Pro Forma Data Inputs'!A40","v":{"v":0.2,"d":"20%"}}]
[]
["Carrying Costs",{"$nulls":4},{"$f":"SUM(C64+C68)","v":{"v":0,"d":"$0"}}]
["Purchase Price ",{"$f":"F3","v":{"v":0,"d":"$0"}}]
["Months",{"$f":"VALUE('12. Pro Forma Data Inputs'!B44)","v":0}]
["Interest Rate",{"$f":"VALUE('12. Pro Forma Data Inputs'!B45)","v":{"v":0,"d":"0.00%"}},{"$f":"(B62*(B64/12))*B63","v":{"v":0,"d":"$0"}},"Interest"]
[]
["Soft Costs + Hard Costs + Remediation",{"$f":"F58+F17+F6","v":{"v":0,"d":"$0"}}]
["Months",{"$f":"VALUE('12. Pro Forma Data Inputs'!B44)","v":0}]
["Interest Rate",{"$f":"VALUE('12. Pro Forma Data Inputs'!B45)","v":{"v":0,"d":"0.00%"}},{"$f":"(B66*(B68/12))*B67","v":{"v":0,"d":"$0"}},"Interest"]
[]
["TOTAL DEVELOPMENT COST",{"$nulls":4},{"$f":"F3+F6+F17+F58+F61","v":{"v":0,"d":"$0"}}]
[]
[]
["Adjusted Net Operating Income",{"$nulls":4},{"$f":"F82-F84-F85-F86","v":{"v":0,"d":"$0"}}]
[]
["Net Operating Income","Units, SF, Rooms",null,"Income",null,"Annual Income \n(100% Occupancy)"]
[{"$f":"'12. Pro Forma Data Inputs'!A49","v":"Residential"},{"$f":"D32+D45","v":0},"units",{"$f":"'12. Pro Forma Data Inputs'!B49","v":{"v":0,"d":"$0"}},"per unit per month",{"$f":"+B76*D76*12","v":{"v":0,"d":"$0"}}]
[{"$f":"'12. Pro Forma Data Inputs'!A50","v":"Commercial (Professional/Office)"},{"$f":"B33+B46","v":0},"SF",{"$f":"'12. Pro Forma Data Inputs'!B50","v":{"v":0,"d":"$0"}},"per SF NNN",{"$f":"+B77*D77","v":{"v":0,"d":"$0"}}]
[{"$f":"'12. Pro Forma Data Inputs'!A51","v":"Retail"},{"$f":"B34+B47","v":0},"SF",{"$f":"'12. Pro Forma Data Inputs'!B51","v":{"v":0,"d":"$0"}},"per SF NNN",{"$f":"+B78*D78","v":{"v":0,"d":"$0"}}]
[{"$f":"'12. Pro Forma Data Inputs'!A52","v":"Industrial"},{"$f":"B35+B48","v":0},"SF",{"$f":"'12. Pro Forma Data Inputs'!B52","v":{"v":0,"d":"$0"}},"per SF NNN",{"$f":"+B79*D79","v":{"v":0,"d":"$0"}}]
[{"$f":"'12. Pro Forma Data Inputs'!A53","v":"Warehouse"},{"$f":"B36+B49","v":0},"SF",{"$f":"'12. Pro Forma Data Inputs'!B53","v":{"v":0,"d":"$0"}},"per SF NNN",{"$f":"+B80*D80","v":{"v":0,"d":"$0"}}]
[{"$f":"'12. Pro Forma Data Inputs'!A54","v":"Hotel/Hospitality"},{"$f":"D37+D50","v":0},"rooms",{"$f":"'12. Pro Forma Data Inputs'!B54","v":{"v":0,"d":"$0"}},"per room per night",{"$f":"+B81*D81*365","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},{"$f":"SUM(F76:F81)","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":4}," - Vacancy Value",{"$f":"('12. Pro Forma Data Inputs'!B57*'13. Pro Forma Tool'!F76)+('12. Pro Forma Data Inputs'!B58*'13. Pro Forma Tool'!F77)+('12. Pro Forma Data Inputs'!B59*'13. Pro Forma Tool'!F78)+('12. Pro Forma Data Inputs'!B60*'13. Pro Forma Tool'!F79)+('12. Pro Forma Data Inputs'!B61*'13. Pro Forma Tool'!F80)+('12. Pro Forma Data Inputs'!B62*'13. Pro Forma Tool'!F81)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4}," - Annual Long Term Remediation Operating Expenses",{"$f":"VALUE('12. Pro Forma Data Inputs'!B11)","v":{"v":0,"d":"$0"}}]
[{"$nulls":4}," - Annual Premium for Environmental Insurance",{"$f":"VALUE('12. Pro Forma Data Inputs'!B12)","v":{"v":0,"d":"$0"}}]
[]
["PROJECT VALUE ( = Adjusted Net Operating Income / Capitalization Rate)",{"$nulls":4},{"$f":"IF(B89=0,0,F73/B89)","v":{"v":0,"d":"$0"}}]
["Capitalization Rate",{"$f":"'12. Pro Forma Data Inputs'!B65","v":{"v":0,"d":"0.00%"}}]
[]
["PROFIT ( = Project Value - Total Development Cost)",{"$nulls":4},{"$f":"IF(F88=\"\",0,F88-F70)","v":{"v":0,"d":"$0"}}]
[]
["CASH ON CASH RETURN ( = Profit / Total Development Cost)",{"$nulls":4},{"$f":"IF(F70 = 0,0,F91/F70)","v":{"v":0,"d":"0.00%"}}]

{"sheet":"14. Sources and Uses","index":14,"n_rows":48,"n_cols":7,"rows_kept":48,"merged":[[0,0,0,5],[4,0,4,2],[4,4,4,5]]}
["Enter Sources and Uses Data in the cells below that are formatted in red dots similar to the format in this cell."]
[{"$f":"IF('1. Stakeholders'!B4=\"\",\"\",'1. Stakeholders'!B4)&\": Sources and Uses\"","v":": Sources and Uses"}]
["SOURCES AND USES OF FUNDS"]
[]
["USES OF FUNDS",{"$nulls":3},"SOURCES OF FUNDS"]
[]
["Acquisition",null,{"$f":"'13. Pro Forma Tool'!B4","v":{"v":0,"d":"$0"}},null,"Construction Sources of Funds"]
["Transaction Costs",null,{"$f":"+C7*0.05","v":{"v":0,"d":"$0"}}]
["Total Acquisition Costs",null,{"$f":"SUM(C7:C8)","v":{"v":0,"d":"$0"}},null,"1st Construction Loan"]
[{"$nulls":4},"2nd Construction Loan "]
["Hard Costs",null," ",null,"Developer Equity"]
["Construction",null,{"$f":"'13. Pro Forma Tool'!E38+SUM('13. Pro Forma Tool'!E45:E50)","v":{"v":0,"d":"$0"}},null,"Equity from Federal Tax Credits",null,"Applicable to private development projects"]
["General Conditions",null,{"$f":"+C12*0.025","v":{"v":0,"d":"$0"}},null,"Equity from State Tax Credits",null,"Applicable to private development projects"]
["Developer fee",null,{"$f":"(+C12+C13)*0.05","v":{"v":0,"d":"$0"}},null,"Grant Source #1"]
["Demolition/Property Improvement",null,{"$f":"'13. Pro Forma Tool'!E42+'13. Pro Forma Tool'!E43","v":{"v":0,"d":"$0"}},null,"Grant Source #2"]
["Remediation",null,{"$f":"'12. Pro Forma Data Inputs'!B8","v":{"v":0,"d":"$0"}},null,"Other"]
["Hard Cost Contingency",{"v":0.1,"d":"10%"},{"$f":"+C12*0.1","v":{"v":0,"d":"$0"}},null,"Deferred Developer Fee"]
["Total Building Loan Hard Cost",null,{"$f":"SUM(C12:C17)","v":{"v":0,"d":"$0"}},null,"TOTAL CONSTRUCTION SOURCES",{"$f":"SUM(F9:F17)","v":{"v":0,"d":"$0"}}]
[]
["Project's Soft Costs",{"$nulls":3},"Permanent Sources of Funds"]
["Borrower's A/E Fee",null,{"$f":"+C12*0.035","v":{"v":0,"d":"$0"}}]
["Bank Engineer",null,{"$f":"+C21*0.1","v":{"v":0,"d":"$0"}},null,"Ist Permanent Mortgage"]
["Developer Owner's Representative",{"$nulls":3},"2nd Permanent Mortgage"]
["Bank Legal",{"$nulls":3},"Developer Equity"]
["Developer Legal",{"$nulls":3},"Equity from Federal Tax Credits",null,"Applicable to private development projects"]
["Accounting",{"$nulls":3},"Equity from State Tax Credits",null,"Applicable to private development projects"]
["Environmental Phase I",{"$nulls":3},"Grant Source #1"]
["Environmental Phase II and III",{"$nulls":3},"Grant Source #2"]
["Other Environmental Professional Fees",{"$nulls":3},"Other"]
["Survey",{"$nulls":3},"Deferred Developer Fee"]
["Title Insurance",{"$nulls":3},"TOTAL PERMANENT SOURCES",{"$f":"SUM(F22:F30)","v":{"v":0,"d":"$0"}}]
["Appraisal"]
["Bank Commitment Fee"]
["Construction Interest"]
["Insurance"]
["Real Estate Taxes"]
["Building Permits"]
["Other"]
["Letter of Credit/Bond Fee"]
["Soft Cost Contingency",{"v":0.1,"d":"10%"}]
["Other"]
["Total Building Loan Soft Costs",null,{"$f":"SUM(C21:C41)","v":{"v":0,"d":"$0"}}]
[" "]
["Developer Fee"]
[]
["Operating and Lease-up Reserve"]
[" "]
["TOTAL USES OF FUNDS",null,{"$f":"C46+C44+C42+C18+C9","v":{"v":0,"d":"$0"}}]