{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Coversheet","Year1","Year2","Year3","Total","GoalsPriorities","Needs","Services","Outcomes","Tools","Reporting"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":133,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":414,"n_cols":9,"rows_kept":414,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]

{"sheet":"Coversheet","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[21,5,21,8],[38,5,38,8],[24,5,24,8],[27,5,27,8],[40,5,40,8],[26,5,26,8],[32,5,32,8],[45,5,45,8],[30,4,30,5],[28,5,28,8],[29,5,29,8],[37,4,37,5],[42,4,42,10],[43,5,43,8],[36,5,36,8],[33,5,33,8],[31,5,31,8],[14,5,14,8],[15,5,15,8],[44,5,44,8],[35,5,35,8],[20,2,20,3],[10,5,10,8],[18,5,18,8],[20,5,20,8],[39,5,39,8],[23,5,23,8],[0,0,0,10],[9,4,9,5],[19,4,19,5],[1,4,1,6],[11,5,11,8],[2,2,8,10],[16,5,16,8],[17,5,17,8],[12,5,12,8],[13,5,13,8]]}
["2011 eLogic Model®  Information Coversheet "]
[null,null,null,null,"Instructions"]
[null,null,"When completing this section there are \"mandatory\" fields that must be completed. These fields are highlighted in yellow.  The required data must be entered correctly to complete an eLogic Model®.  After completing all mandatory fields on the coversheet click on the “Check Errors” button at the top of this page. Applicant Legal Name must match box 8a in the SF-424 in your application.  Enter the legal name by which you are incorporated and pay taxes. CCR Doing Business is new for 2010 eLogic Model®.  Only complete this field if your registration at CCR includes an entry in Doing Business as: (dba).  Enter the DUNS # as entered into box 8c of the SF-424 Application for Federal Assistance form.  Enter the City where your organization is located, this information must match the SF-424 data in your application. Use the dropdown to enter the State where your organization is located, this information must match the SF-424 data in your application.  This information must match the SF-424 data in your application. Enter the Grantee Contact Name and email address in the field provided.  Enter the name of the person that completed the eLogic Model® and their email address in the field provided. When completing the Project Information Section, applicants except Indian Tribes must enter their Project Name, Project Location City/County/Parish, State, Project Type, and Construction Type. If there are multiple locations, enter the location where the majority of the work will be done.  Indian tribes, including multi-state tribes, should enter the City or County associated with their business address location. For Indian Tribes, enter the state applicable to the business address of the Tribal entity."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Program Information"]
[null,null,null,null,"HUD Program","Sustainable Communities Regional Planning Grants "]
[null,null,null,null,"Program CFDA #","14.703"]
[null,null,null,null,null,"Program Component"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Grantee Information"]
[null,null,null,null,"Applicant Legal Name","South Florida Regional Planning Council"]
[null,null,null,null,"CCR Doing Business As Name"]
[null,null,null,null,"DUNS Number","072235286","­"]
[null,null,null,null,"City","Hollywood"]
[null,null,null,null,"State","Florida"]
[null,null,null,null,"Zip Code",33021,"­","6900"]
[null,null,null,null,"Grantee Contact Name","James F. Murley"]
[null,null,null,null,"Grantee Contact email","jmurley@sfrpc.com"]
[null,null,null,null,"Logic Model Contact Name","isabel cosio-carballo"]
[null,null,null,null,"Logic Model Contact email","isabelc@sfrpc.com"]
[null,null,null,null,"Project Information"]
[null,null,null,null,"Project Name","South Florida Regional Partnership - Sustainable Communities Initiative"]
[null,null,null,null,"Project Location City/County/Parish ","Hollywood"]
[null,null,null,null,"Project Location State","Florida"]
[null,null,null,null,"Zip Code",33021,"­","6900"]
[null,null,null,null,"Project Type","Planning - Category 1"]
[null,null,null,null,"Construction Type"]
[]
[]
[]
[]
[]
[null,null,null,null,"Additional Information for Reporting (Leave Blank At the Time of Application)"]
[null,null,null,null,"Grants.gov Application Number"]
[null,null,null,null,"HUD Award Number"]
[null,null,null,null,"Logic Model Amendment Number"]

{"sheet":"Year1","index":2,"n_rows":224,"n_cols":15,"rows_kept":224,"cut":false,"hidden":false,"merged":[[6,6,6,8],[6,10,6,13],[15,9,16,9],[25,10,25,13],[21,10,21,13],[14,12,14,13],[9,9,10,9],[15,10,15,13],[23,10,23,13],[18,12,18,13],[7,10,7,13],[8,12,8,13],[9,10,9,13],[21,6,21,8],[19,9,20,9],[17,9,18,9],[17,10,17,13],[13,10,13,13],[13,9,14,9],[12,12,12,13],[104,12,104,13],[106,12,106,13],[224,12,224,13],[220,12,220,13],[218,12,218,13],[221,10,221,13],[219,10,219,13],[223,10,223,13],[222,12,222,13],[174,12,174,13],[22,12,22,13],[78,12,78,13],[53,10,53,13],[50,12,50,13],[73,10,73,13],[65,10,65,13],[76,12,76,13],[45,10,45,13],[54,12,54,13],[62,12,62,13],[102,12,102,13],[82,12,82,13],[96,12,96,13],[147,9,148,9],[142,12,142,13],[108,12,108,13],[134,12,134,13],[132,12,132,13],[131,9,132,9],[117,9,118,9],[199,9,200,9],[199,10,199,13],[200,12,200,13],[129,10,129,13],[137,10,137,13],[136,12,136,13],[159,10,159,13],[160,12,160,13],[151,10,151,13],[152,12,152,13],[215,10,215,13],[111,10,111,13],[125,10,125,13],[124,12,124,13],[123,10,123,13],[112,12,112,13],[114,12,114,13],[154,12,154,13],[130,12,130,13],[133,9,134,9],[131,6,131,8],[107,9,108,9],[119,10,119,13],[107,10,107,13],[113,9,114,9],[111,9,112,9],[105,9,106,9],[103,9,104,9],[169,9,170,9],[116,12,116,13],[110,12,110,13],[121,10,121,13],[127,10,127,13],[128,12,128,13],[99,9,100,9],[99,6,99,8],[97,6,97,8],[97,9,98,9],[177,9,178,9],[135,9,136,9],[137,9,138,9],[101,9,102,9],[119,9,120,9],[115,9,116,9],[129,6,129,8],[127,6,127,8],[125,6,125,8],[121,6,121,8],[123,6,123,8],[93,6,93,8],[95,6,95,8],[119,6,119,8],[117,6,117,8],[103,4,104,4],[103,6,103,8],[101,6,101,8],[107,6,107,8],[105,6,105,8],[113,4,114,4],[115,6,115,8],[121,4,122,4],[111,4,112,4],[109,4,110,4],[119,4,120,4],[113,6,113,8],[111,6,111,8],[109,6,109,8],[127,4,128,4],[93,3,104,3],[95,4,96,4],[93,4,94,4],[123,4,124,4],[117,4,118,4],[101,4,102,4],[129,4,130,4],[129,3,140,3],[135,4,136,4],[139,4,140,4],[91,4,92,4],[99,4,100,4],[117,3,128,3],[107,4,108,4],[105,4,106,4],[125,4,126,4],[105,3,116,3],[97,4,98,4],[115,4,116,4],[45,4,46,4],[87,4,88,4],[89,4,90,4],[65,4,66,4],[71,4,72,4],[49,6,49,8],[75,4,76,4],[77,4,78,4],[41,4,42,4],[43,6,43,8],[41,6,41,8],[61,4,62,4],[69,4,70,4],[59,4,60,4],[67,4,68,4],[91,6,91,8],[19,10,19,13],[21,9,22,9],[20,12,20,13],[27,6,27,8],[33,6,33,8],[31,6,31,8],[49,10,49,13],[83,6,83,8],[81,6,81,8],[33,4,34,4],[29,4,30,4],[31,4,32,4],[57,4,58,4],[89,6,89,8],[87,6,87,8],[83,4,84,4],[85,4,86,4],[85,6,85,8],[81,4,82,4],[21,3,32,3],[9,3,20,3],[27,4,28,4],[25,4,26,4],[11,4,12,4],[7,1,7,2],[8,1,8,2],[17,4,18,4],[19,4,20,4],[9,4,10,4],[37,10,37,13],[26,12,26,13],[24,12,24,13],[37,9,38,9],[31,10,31,13],[33,10,33,13],[38,12,38,13],[11,10,11,13],[23,4,24,4],[35,4,36,4],[16,12,16,13],[28,12,28,13],[35,10,35,13],[36,12,36,13],[30,12,30,13],[32,12,32,13],[34,12,34,13],[10,12,10,13],[13,4,14,4],[52,12,52,13],[64,12,64,13],[63,10,63,13],[55,10,55,13],[58,12,58,13],[60,12,60,13],[57,10,57,13],[45,9,46,9],[33,3,44,3],[45,3,56,3],[55,4,56,4],[37,4,38,4],[39,4,40,4],[43,4,44,4],[53,4,54,4],[47,4,48,4],[51,4,52,4],[49,4,50,4],[47,9,48,9],[43,9,44,9],[53,6,53,8],[56,12,56,13],[55,6,55,8],[51,10,51,13],[55,9,56,9],[51,6,51,8],[47,6,47,8],[49,9,50,9],[59,10,59,13],[59,6,59,8],[61,9,62,9],[61,6,61,8],[61,10,61,13],[68,12,68,13],[67,10,67,13],[63,6,63,8],[72,12,72,13],[74,12,74,13],[71,10,71,13],[65,9,66,9],[69,9,70,9],[65,6,65,8],[69,6,69,8],[67,6,67,8],[66,12,66,13],[69,10,69,13],[73,6,73,8],[70,12,70,13],[71,9,72,9],[145,6,145,8],[145,10,145,13],[131,10,131,13],[133,10,133,13],[123,9,124,9],[77,6,77,8],[79,6,79,8],[105,10,105,13],[117,10,117,13],[143,4,144,4],[143,9,144,9],[143,10,143,13],[143,6,143,8],[144,12,144,13],[141,6,141,8],[139,10,139,13],[131,4,132,4],[137,6,137,8],[135,6,135,8],[133,4,134,4],[137,4,138,4],[135,10,135,13],[138,12,138,13],[173,10,173,13],[171,9,172,9],[171,6,171,8],[171,10,171,13],[172,12,172,13],[141,4,142,4],[141,9,142,9],[141,10,141,13],[146,12,146,13],[168,12,168,13],[165,9,166,9],[165,6,165,8],[165,10,165,13],[166,12,166,13],[161,10,161,13],[162,12,162,13],[163,10,163,13],[164,12,164,13],[161,9,162,9],[157,4,158,4],[159,4,160,4],[159,9,160,9],[169,10,169,13],[170,12,170,13],[167,4,168,4],[167,9,168,9],[167,6,167,8],[167,10,167,13],[165,4,166,4],[157,10,157,13],[158,12,158,13],[177,10,177,13],[157,9,158,9],[173,6,173,8],[171,4,172,4],[173,9,174,9],[163,6,163,8],[161,4,162,4],[178,12,178,13],[175,9,176,9],[175,6,175,8],[175,10,175,13],[176,12,176,13],[177,6,177,8],[181,10,181,13],[182,12,182,13],[179,9,180,9],[179,6,179,8],[179,10,179,13],[180,12,180,13],[181,6,181,8],[181,9,182,9],[185,10,185,13],[186,12,186,13],[183,9,184,9],[183,6,183,8],[183,10,183,13],[184,12,184,13],[185,9,186,9],[185,6,185,8],[189,10,189,13],[190,12,190,13],[187,9,188,9],[187,6,187,8],[187,10,187,13],[188,12,188,13],[189,9,190,9],[189,6,189,8],[213,3,224,3],[141,3,152,3],[215,6,215,8],[217,9,218,9],[219,4,220,4],[221,4,222,4],[201,6,201,8],[213,9,214,9],[191,9,192,9],[223,4,224,4],[208,12,208,13],[202,12,202,13],[211,9,212,9],[211,10,211,13],[211,6,211,8],[212,12,212,13],[209,10,209,13],[193,10,193,13],[213,10,213,13],[214,12,214,13],[205,6,205,8],[194,12,194,13],[209,6,209,8],[207,6,207,8],[199,6,199,8],[210,12,210,13],[207,10,207,13],[206,12,206,13],[217,6,217,8],[213,6,213,8],[216,12,216,13],[191,10,191,13],[192,12,192,13],[201,9,202,9],[201,10,201,13],[198,12,198,13],[195,9,196,9],[223,9,224,9],[219,9,220,9],[221,6,221,8],[219,6,219,8],[223,6,223,8],[217,4,218,4],[193,6,193,8],[191,6,191,8],[195,6,195,8],[221,9,222,9],[207,9,208,9],[209,9,210,9],[193,9,194,9],[197,6,197,8],[203,6,203,8],[205,9,206,9],[217,10,217,13],[215,9,216,9],[195,10,195,13],[196,12,196,13],[197,9,198,9],[197,10,197,13],[203,9,204,9],[205,10,205,13],[203,10,203,13],[204,12,204,13],[165,3,176,3],[177,3,188,3],[173,4,174,4],[169,4,170,4],[177,4,178,4],[179,4,180,4],[183,4,184,4],[185,4,186,4],[181,4,182,4],[175,4,176,4],[201,3,212,3],[189,3,200,3],[193,4,194,4],[189,4,190,4],[197,4,198,4],[195,4,196,4],[215,4,216,4],[213,4,214,4],[211,4,212,4],[191,4,192,4],[209,4,210,4],[203,4,204,4],[201,4,202,4],[207,4,208,4],[205,4,206,4],[199,4,200,4],[187,4,188,4],[153,4,154,4],[153,9,154,9],[153,6,153,8],[161,6,161,8],[157,6,157,8],[163,4,164,4],[159,6,159,8],[169,6,169,8],[155,4,156,4],[155,9,156,9],[155,6,155,8],[57,3,68,3],[69,3,80,3],[81,3,92,3],[57,6,57,8],[63,4,64,4],[71,6,71,8],[73,4,74,4],[79,4,80,4],[57,9,58,9],[63,9,64,9],[59,9,60,9],[95,9,96,9],[93,9,94,9],[91,9,92,9],[75,9,76,9],[85,9,86,9],[73,9,74,9],[67,9,68,9],[75,6,75,8],[89,9,90,9],[153,3,164,3],[151,4,152,4],[151,9,152,9],[129,9,130,9],[149,9,150,9],[163,9,164,9],[149,4,150,4],[149,6,149,8],[147,4,148,4],[156,12,156,13],[147,6,147,8],[147,10,147,13],[148,12,148,13],[153,10,153,13],[155,10,155,13],[151,6,151,8],[149,10,149,13],[150,12,150,13],[99,10,99,13],[95,10,95,13],[139,6,139,8],[140,12,140,13],[145,4,146,4],[145,9,146,9],[126,12,126,13],[139,9,140,9],[127,9,128,9],[133,6,133,8],[101,10,101,13],[100,12,100,13],[121,9,122,9],[125,9,126,9],[109,9,110,9],[88,12,88,13],[103,10,103,13],[89,10,89,13],[92,12,92,13],[91,10,91,13],[122,12,122,13],[120,12,120,13],[118,12,118,13],[113,10,113,13],[115,10,115,13],[93,10,93,13],[94,12,94,13],[98,12,98,13],[109,10,109,13],[97,10,97,13],[87,9,88,9],[77,9,78,9],[79,9,80,9],[81,9,82,9],[83,9,84,9],[81,10,81,13],[84,12,84,13],[79,10,79,13],[11,9,12,9],[1,4,1,9],[90,12,90,13],[75,10,75,13],[80,12,80,13],[85,10,85,13],[86,12,86,13],[77,10,77,13],[83,10,83,13],[87,10,87,13],[7,6,7,8],[9,6,9,8],[11,6,11,8],[0,6,0,8],[27,10,27,13],[29,10,29,13],[29,9,30,9],[23,6,23,8],[25,6,25,8],[23,9,24,9],[19,6,19,8],[39,9,40,9],[33,9,34,9],[37,6,37,8],[27,9,28,9],[35,6,35,8],[35,9,36,9],[39,6,39,8],[25,9,26,9],[29,6,29,8],[42,12,42,13],[41,10,41,13],[48,12,48,13],[43,10,43,13],[2,4,2,9],[15,4,16,4],[13,6,13,8],[21,4,22,4],[15,6,15,8],[17,6,17,8],[51,9,52,9],[31,9,32,9],[45,6,45,8],[53,9,54,9],[41,9,42,9],[39,10,39,13],[44,12,44,13],[40,12,40,13],[47,10,47,13],[46,12,46,13]]}
[null,"eLogic Model® ",null,null,null,null,"Year 1",null,null,null,null,null,null,null,"OMB Approval 2535-0114 exp. 08/31/2014"]
[null,null,null,"Applicant Legal Name",{"$f":"Coversheet!F21","v":"South Florida Regional Planning Council"}]
[null,null,null,"CCR Doing Business As Name",{"$f":"Coversheet!F22","v":0}]
[null,null,null,"HUD Program",{"$f":"Coversheet!F11","v":"Sustainable Communities Regional Planning Grants "},null,null,null,"Reporting Period"]
[null,null,null,"Program Component",null,null,null,null,"Reporting Start Date",null,"DUNS No.",{"$f":"Coversheet!F23","v":"072235286"},"­",{"$f":"Coversheet!H23","v":0}]
[null,null,null,"Project Name",{"$f":"Coversheet!F32","v":"South Florida Regional Partnership - Sustainable Communities Initiative"},null,null,null,"Reporting End Date",null,null,null,null,null,2011]
[null,"HUD Goals","Policy Priority","Needs","Services/Activities","Output Goal","Measures",null,null,"Outcomes ","Measures",null,null,null,"Evaluation Tools"]
[null,1,null,2,3,4,4,null,null,5,6,null,null,null,7]
[null,"Policy",null,"Planning","Programming","Measure","Pre","Post","YTD","Impact","Pre","Post","YTD",null,"Accountability"]
[null,null,null,"There is a need for multijurisdictional planning efforts that integrate housing, land use, economic and workforce development, transportation, and infrastructure investments to direct long-term development, reinvestment, and issues of regional significance.","Governance-Establish intergovernmental planning and cooperation mechanisms-Agreements Secured |Agreements Secured",null,{"$f":"RIGHT(E10,(LEN(E10)-FIND(\"|\",E10)))","v":"Agreements Secured"},null,null,null,{"$f":"RIGHT(J10,(LEN(J10)-FIND(\"|\",J10)))","v":{"$error":"#VALUE!"}}]
[null,"4E","2f",null,null,null,133,null,null,null,null,null,null,null,"A. Tools for Measurement"]
[null,null,null,null,null,null,{"$f":"RIGHT(E12,(LEN(E12)-FIND(\"|\",E12)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J12,(LEN(J12)-FIND(\"|\",J12)))","v":{"$error":"#VALUE!"}},null,null,null,"Plans"]
[null,null,"2i",null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,"Governance-Establish intergovernmental planning and cooperation mechanisms-Jurisdictions Represented |Jurisdictions Represented",null,{"$f":"RIGHT(E14,(LEN(E14)-FIND(\"|\",E14)))","v":"Jurisdictions Represented"},null,null,null,{"$f":"RIGHT(J14,(LEN(J14)-FIND(\"|\",J14)))","v":{"$error":"#VALUE!"}},null,null,null,"Outcome scale(s)"]
[null,null,"4b",null,null,null,42,null,null,null,null,null,null,null,"Survey"]
[null,null,null,null,null,null,{"$f":"RIGHT(E16,(LEN(E16)-FIND(\"|\",E16)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J16,(LEN(J16)-FIND(\"|\",J16)))","v":{"$error":"#VALUE!"}},null,null,null,"Program specific form(s)"]
[null,null,"6a",null,null,null,null,null,null,null,null,null,null,null,"B.  Where Data Maintained"]
[null,null,null,null,"Governance-Provide training to strengthen management and decision-making capacities of applicable partners-Training sessions |Training Sessions",null,{"$f":"RIGHT(E18,(LEN(E18)-FIND(\"|\",E18)))","v":"Training Sessions"},null,null,null,{"$f":"RIGHT(J18,(LEN(J18)-FIND(\"|\",J18)))","v":{"$error":"#VALUE!"}},null,null,null,"Centralized database"]
[null,null,null,null,null,null,7,null,null,null,null,null,null,null,"Specialized database"]
[null,null,null,null,null,null,{"$f":"RIGHT(E20,(LEN(E20)-FIND(\"|\",E20)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J20,(LEN(J20)-FIND(\"|\",J20)))","v":{"$error":"#VALUE!"}},null,null,null,"Specialized database"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specialized database"]
[null,null,null,"There is a need for development of a strong governance structure to address costs and responsibilities for sustainable regional economic growth, development, and operation of associated shared services. ","Governance-Provide training to strengthen management and decision-making capacities of applicable partners-Persons Completing Training |Persons",null,{"$f":"RIGHT(E22,(LEN(E22)-FIND(\"|\",E22)))","v":"Persons"},null,null,null,{"$f":"RIGHT(J22,(LEN(J22)-FIND(\"|\",J22)))","v":{"$error":"#VALUE!"}},null,null,null,"Specialized database"]
[null,null,null,null,null,null,50,null,null,null,null,null,null,null,"C.  Source of Data"]
[null,null,null,null,null,null,{"$f":"RIGHT(E24,(LEN(E24)-FIND(\"|\",E24)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J24,(LEN(J24)-FIND(\"|\",J24)))","v":{"$error":"#VALUE!"}},null,null,null,"Work plan reports"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statistics"]
[null,null,null,null,"Outreach-Citizen/Resident Participation-Resident participation in plan development and governance-Number of Persons on Planning Committees |Persons",null,{"$f":"RIGHT(E26,(LEN(E26)-FIND(\"|\",E26)))","v":"Persons"},null,null,null,{"$f":"RIGHT(J26,(LEN(J26)-FIND(\"|\",J26)))","v":{"$error":"#VALUE!"}},null,null,null,"Statistics"]
[null,null,null,null,null,null,50,null,null,null,null,null,null,null,"Statistics"]
[null,null,null,null,null,null,{"$f":"RIGHT(E28,(LEN(E28)-FIND(\"|\",E28)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J28,(LEN(J28)-FIND(\"|\",J28)))","v":{"$error":"#VALUE!"}},null,null,null,"Statistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D. Frequency of Collection"]
[null,null,null,null,"Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-Agencies Contacted |Agencies Contacted",null,{"$f":"RIGHT(E30,(LEN(E30)-FIND(\"|\",E30)))","v":"Agencies Contacted"},null,null,null,{"$f":"RIGHT(J30,(LEN(J30)-FIND(\"|\",J30)))","v":{"$error":"#VALUE!"}},null,null,null,"Upon incident"]
[null,null,null,null,null,null,100,null,null,null,null,null,null,null,"Annually"]
[null,null,null,null,"Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-New Entities Joining |New Entities Joining",null,{"$f":"RIGHT(E32,(LEN(E32)-FIND(\"|\",E32)))","v":"New Entities Joining"},null,null,null,{"$f":"RIGHT(J32,(LEN(J32)-FIND(\"|\",J32)))","v":{"$error":"#VALUE!"}},null,null,null,"Annually"]
[null,null,null,null,null,null,50,null,null,null,null,null,null,null,"Annually"]
[null,null,null,"There is a need for public engagement which includes populations typically marginalized from the public planning processes and creates opportunities for meaningful decision making leading to adoption of a shared regional vision.",null,null,{"$f":"RIGHT(E34,(LEN(E34)-FIND(\"|\",E34)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J34,(LEN(J34)-FIND(\"|\",J34)))","v":{"$error":"#VALUE!"}},null,null,null,"Upon incident"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.  Processing of Data"]
[null,null,null,null,"Regional Planning-Review existing long-range community, local, and regional plans  |Date Completed",null,{"$f":"RIGHT(E36,(LEN(E36)-FIND(\"|\",E36)))","v":"Date Completed"},null,null,null,{"$f":"RIGHT(J36,(LEN(J36)-FIND(\"|\",J36)))","v":{"$error":"#VALUE!"}},null,null,null,"Computer spreadsheets"]
[null,null,null,null,null,null,"2011-12-01",null,null,null,null,null,null,null,"Statistical database"]
[null,null,null,null,null,null,{"$f":"RIGHT(E38,(LEN(E38)-FIND(\"|\",E38)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J38,(LEN(J38)-FIND(\"|\",J38)))","v":{"$error":"#VALUE!"}},null,null,null,"Statistical database"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statistical database"]
[null,null,null,null,null,null,{"$f":"RIGHT(E40,(LEN(E40)-FIND(\"|\",E40)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J40,(LEN(J40)-FIND(\"|\",J40)))","v":{"$error":"#VALUE!"}},null,null,null,"Computer spreadsheets"]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E42,(LEN(E42)-FIND(\"|\",E42)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J42,(LEN(J42)-FIND(\"|\",J42)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E44,(LEN(E44)-FIND(\"|\",E44)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J44,(LEN(J44)-FIND(\"|\",J44)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need to transform isolated, racially, and economically segregated areas into communities of opportunity that reduce social disparities so all have access to quality jobs, schools, affordable housing, transportation, and cultural and physical amenities.",null,null,{"$f":"RIGHT(E46,(LEN(E46)-FIND(\"|\",E46)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J46,(LEN(J46)-FIND(\"|\",J46)))","v":{"$error":"#VALUE!"}}]
[null,"4C","2a"]
[null,null,null,null,"Outreach-Citizen/Resident Participation-Resident participation in plan development and governance-Number of Public meetings held |Meetings Held",null,{"$f":"RIGHT(E48,(LEN(E48)-FIND(\"|\",E48)))","v":"Meetings Held"},null,null,null,{"$f":"RIGHT(J48,(LEN(J48)-FIND(\"|\",J48)))","v":{"$error":"#VALUE!"}}]
[null,null,"2b",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E50,(LEN(E50)-FIND(\"|\",E50)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J50,(LEN(J50)-FIND(\"|\",J50)))","v":{"$error":"#VALUE!"}}]
[null,null,"2f"]
[null,null,null,null,null,null,{"$f":"RIGHT(E52,(LEN(E52)-FIND(\"|\",E52)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J52,(LEN(J52)-FIND(\"|\",J52)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Outreach-Consult with area Public Housing Authorities |Agencies Contacted",null,{"$f":"RIGHT(E54,(LEN(E54)-FIND(\"|\",E54)))","v":"Agencies Contacted"},null,null,null,{"$f":"RIGHT(J54,(LEN(J54)-FIND(\"|\",J54)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,23]
[null,null,null,null,null,null,{"$f":"RIGHT(E56,(LEN(E56)-FIND(\"|\",E56)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J56,(LEN(J56)-FIND(\"|\",J56)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for public engagement which includes populations typically marginalized from the public planning processes and creates opportunities for meaningful decision making leading to adoption of a shared regional vision.","Outreach-Education and training on sustainability-Number of outreach sessions held |Sessions",null,{"$f":"RIGHT(E58,(LEN(E58)-FIND(\"|\",E58)))","v":"Sessions"},null,null,null,{"$f":"RIGHT(J58,(LEN(J58)-FIND(\"|\",J58)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E60,(LEN(E60)-FIND(\"|\",E60)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J60,(LEN(J60)-FIND(\"|\",J60)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Outreach-Education and training on sustainability-Number of persons attending education or training sessions |Persons ",null,{"$f":"RIGHT(E62,(LEN(E62)-FIND(\"|\",E62)))","v":"Persons "},null,null,null,{"$f":"RIGHT(J62,(LEN(J62)-FIND(\"|\",J62)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,50]
[null,null,null,null,null,null,{"$f":"RIGHT(E64,(LEN(E64)-FIND(\"|\",E64)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J64,(LEN(J64)-FIND(\"|\",J64)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E66,(LEN(E66)-FIND(\"|\",E66)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J66,(LEN(J66)-FIND(\"|\",J66)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E68,(LEN(E68)-FIND(\"|\",E68)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J68,(LEN(J68)-FIND(\"|\",J68)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E70,(LEN(E70)-FIND(\"|\",E70)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J70,(LEN(J70)-FIND(\"|\",J70)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E72,(LEN(E72)-FIND(\"|\",E72)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J72,(LEN(J72)-FIND(\"|\",J72)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E74,(LEN(E74)-FIND(\"|\",E74)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J74,(LEN(J74)-FIND(\"|\",J74)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E76,(LEN(E76)-FIND(\"|\",E76)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J76,(LEN(J76)-FIND(\"|\",J76)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E78,(LEN(E78)-FIND(\"|\",E78)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J78,(LEN(J78)-FIND(\"|\",J78)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E80,(LEN(E80)-FIND(\"|\",E80)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J80,(LEN(J80)-FIND(\"|\",J80)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E82,(LEN(E82)-FIND(\"|\",E82)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J82,(LEN(J82)-FIND(\"|\",J82)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E84,(LEN(E84)-FIND(\"|\",E84)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J84,(LEN(J84)-FIND(\"|\",J84)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E86,(LEN(E86)-FIND(\"|\",E86)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J86,(LEN(J86)-FIND(\"|\",J86)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E88,(LEN(E88)-FIND(\"|\",E88)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J88,(LEN(J88)-FIND(\"|\",J88)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E90,(LEN(E90)-FIND(\"|\",E90)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J90,(LEN(J90)-FIND(\"|\",J90)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E92,(LEN(E92)-FIND(\"|\",E92)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J92,(LEN(J92)-FIND(\"|\",J92)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E94,(LEN(E94)-FIND(\"|\",E94)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J94,(LEN(J94)-FIND(\"|\",J94)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E96,(LEN(E96)-FIND(\"|\",E96)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J96,(LEN(J96)-FIND(\"|\",J96)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E98,(LEN(E98)-FIND(\"|\",E98)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J98,(LEN(J98)-FIND(\"|\",J98)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E100,(LEN(E100)-FIND(\"|\",E100)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J100,(LEN(J100)-FIND(\"|\",J100)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E102,(LEN(E102)-FIND(\"|\",E102)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J102,(LEN(J102)-FIND(\"|\",J102)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E104,(LEN(E104)-FIND(\"|\",E104)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J104,(LEN(J104)-FIND(\"|\",J104)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E106,(LEN(E106)-FIND(\"|\",E106)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J106,(LEN(J106)-FIND(\"|\",J106)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E108,(LEN(E108)-FIND(\"|\",E108)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J108,(LEN(J108)-FIND(\"|\",J108)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E110,(LEN(E110)-FIND(\"|\",E110)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J110,(LEN(J110)-FIND(\"|\",J110)))","v":{"$error":"#VALUE!"}},null,null,null,"Program Component"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F14","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E112,(LEN(E112)-FIND(\"|\",E112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J112,(LEN(J112)-FIND(\"|\",J112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F16","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E114,(LEN(E114)-FIND(\"|\",E114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J114,(LEN(J114)-FIND(\"|\",J114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F18","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E116,(LEN(E116)-FIND(\"|\",E116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J116,(LEN(J116)-FIND(\"|\",J116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F19","v":0}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E118,(LEN(E118)-FIND(\"|\",E118)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J118,(LEN(J118)-FIND(\"|\",J118)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E120,(LEN(E120)-FIND(\"|\",E120)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J120,(LEN(J120)-FIND(\"|\",J120)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E122,(LEN(E122)-FIND(\"|\",E122)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J122,(LEN(J122)-FIND(\"|\",J122)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E124,(LEN(E124)-FIND(\"|\",E124)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J124,(LEN(J124)-FIND(\"|\",J124)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E126,(LEN(E126)-FIND(\"|\",E126)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J126,(LEN(J126)-FIND(\"|\",J126)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E128,(LEN(E128)-FIND(\"|\",E128)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J128,(LEN(J128)-FIND(\"|\",J128)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E130,(LEN(E130)-FIND(\"|\",E130)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J130,(LEN(J130)-FIND(\"|\",J130)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E132,(LEN(E132)-FIND(\"|\",E132)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J132,(LEN(J132)-FIND(\"|\",J132)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E134,(LEN(E134)-FIND(\"|\",E134)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J134,(LEN(J134)-FIND(\"|\",J134)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E136,(LEN(E136)-FIND(\"|\",E136)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J136,(LEN(J136)-FIND(\"|\",J136)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E138,(LEN(E138)-FIND(\"|\",E138)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J138,(LEN(J138)-FIND(\"|\",J138)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E140,(LEN(E140)-FIND(\"|\",E140)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J140,(LEN(J140)-FIND(\"|\",J140)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E142,(LEN(E142)-FIND(\"|\",E142)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J142,(LEN(J142)-FIND(\"|\",J142)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E144,(LEN(E144)-FIND(\"|\",E144)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J144,(LEN(J144)-FIND(\"|\",J144)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E146,(LEN(E146)-FIND(\"|\",E146)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J146,(LEN(J146)-FIND(\"|\",J146)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E148,(LEN(E148)-FIND(\"|\",E148)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J148,(LEN(J148)-FIND(\"|\",J148)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E150,(LEN(E150)-FIND(\"|\",E150)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J150,(LEN(J150)-FIND(\"|\",J150)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E152,(LEN(E152)-FIND(\"|\",E152)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J152,(LEN(J152)-FIND(\"|\",J152)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E154,(LEN(E154)-FIND(\"|\",E154)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J154,(LEN(J154)-FIND(\"|\",J154)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E156,(LEN(E156)-FIND(\"|\",E156)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J156,(LEN(J156)-FIND(\"|\",J156)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E158,(LEN(E158)-FIND(\"|\",E158)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J158,(LEN(J158)-FIND(\"|\",J158)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E160,(LEN(E160)-FIND(\"|\",E160)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J160,(LEN(J160)-FIND(\"|\",J160)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E162,(LEN(E162)-FIND(\"|\",E162)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J162,(LEN(J162)-FIND(\"|\",J162)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E164,(LEN(E164)-FIND(\"|\",E164)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J164,(LEN(J164)-FIND(\"|\",J164)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E166,(LEN(E166)-FIND(\"|\",E166)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J166,(LEN(J166)-FIND(\"|\",J166)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E168,(LEN(E168)-FIND(\"|\",E168)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J168,(LEN(J168)-FIND(\"|\",J168)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E170,(LEN(E170)-FIND(\"|\",E170)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J170,(LEN(J170)-FIND(\"|\",J170)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E172,(LEN(E172)-FIND(\"|\",E172)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J172,(LEN(J172)-FIND(\"|\",J172)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E174,(LEN(E174)-FIND(\"|\",E174)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J174,(LEN(J174)-FIND(\"|\",J174)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E176,(LEN(E176)-FIND(\"|\",E176)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J176,(LEN(J176)-FIND(\"|\",J176)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E178,(LEN(E178)-FIND(\"|\",E178)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J178,(LEN(J178)-FIND(\"|\",J178)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E180,(LEN(E180)-FIND(\"|\",E180)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J180,(LEN(J180)-FIND(\"|\",J180)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E182,(LEN(E182)-FIND(\"|\",E182)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J182,(LEN(J182)-FIND(\"|\",J182)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E184,(LEN(E184)-FIND(\"|\",E184)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J184,(LEN(J184)-FIND(\"|\",J184)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E186,(LEN(E186)-FIND(\"|\",E186)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J186,(LEN(J186)-FIND(\"|\",J186)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E188,(LEN(E188)-FIND(\"|\",E188)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J188,(LEN(J188)-FIND(\"|\",J188)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E190,(LEN(E190)-FIND(\"|\",E190)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J190,(LEN(J190)-FIND(\"|\",J190)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E192,(LEN(E192)-FIND(\"|\",E192)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J192,(LEN(J192)-FIND(\"|\",J192)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E194,(LEN(E194)-FIND(\"|\",E194)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J194,(LEN(J194)-FIND(\"|\",J194)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E196,(LEN(E196)-FIND(\"|\",E196)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J196,(LEN(J196)-FIND(\"|\",J196)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E198,(LEN(E198)-FIND(\"|\",E198)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J198,(LEN(J198)-FIND(\"|\",J198)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E200,(LEN(E200)-FIND(\"|\",E200)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J200,(LEN(J200)-FIND(\"|\",J200)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E202,(LEN(E202)-FIND(\"|\",E202)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J202,(LEN(J202)-FIND(\"|\",J202)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E204,(LEN(E204)-FIND(\"|\",E204)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J204,(LEN(J204)-FIND(\"|\",J204)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E206,(LEN(E206)-FIND(\"|\",E206)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J206,(LEN(J206)-FIND(\"|\",J206)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E208,(LEN(E208)-FIND(\"|\",E208)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J208,(LEN(J208)-FIND(\"|\",J208)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E210,(LEN(E210)-FIND(\"|\",E210)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J210,(LEN(J210)-FIND(\"|\",J210)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E212,(LEN(E212)-FIND(\"|\",E212)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J212,(LEN(J212)-FIND(\"|\",J212)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E214,(LEN(E214)-FIND(\"|\",E214)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J214,(LEN(J214)-FIND(\"|\",J214)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E216,(LEN(E216)-FIND(\"|\",E216)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J216,(LEN(J216)-FIND(\"|\",J216)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E218,(LEN(E218)-FIND(\"|\",E218)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J218,(LEN(J218)-FIND(\"|\",J218)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E220,(LEN(E220)-FIND(\"|\",E220)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J220,(LEN(J220)-FIND(\"|\",J220)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E222,(LEN(E222)-FIND(\"|\",E222)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J222,(LEN(J222)-FIND(\"|\",J222)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E224,(LEN(E224)-FIND(\"|\",E224)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J224,(LEN(J224)-FIND(\"|\",J224)))","v":{"$error":"#VALUE!"}}]

{"sheet":"Year2","index":3,"n_rows":224,"n_cols":15,"rows_kept":224,"cut":false,"hidden":false,"merged":[[201,3,212,3],[223,4,224,4],[223,6,223,8],[223,9,224,9],[221,4,222,4],[219,4,220,4],[213,3,224,3],[213,4,214,4],[209,6,209,8],[209,9,210,9],[217,4,218,4],[213,6,213,8],[215,6,215,8],[215,4,216,4],[213,9,214,9],[217,6,217,8],[215,9,216,9],[219,6,219,8],[219,10,219,13],[219,9,220,9],[221,6,221,8],[221,10,221,13],[220,12,220,13],[213,10,213,13],[214,12,214,13],[210,12,210,13],[209,10,209,13],[211,10,211,13],[224,12,224,13],[222,12,222,13],[216,12,216,13],[217,9,218,9],[215,10,215,13],[223,10,223,13],[217,10,217,13],[218,12,218,13],[221,9,222,9],[206,12,206,13],[212,12,212,13],[201,4,202,4],[201,6,201,8],[201,9,202,9],[205,4,206,4],[205,6,205,8],[205,9,206,9],[201,10,201,13],[207,4,208,4],[211,4,212,4],[211,6,211,8],[211,9,212,9],[203,4,204,4],[203,6,203,8],[203,9,204,9],[209,4,210,4],[207,6,207,8],[207,9,208,9],[207,10,207,13],[208,12,208,13],[192,12,192,13],[193,10,193,13],[194,12,194,13],[198,12,198,13],[202,12,202,13],[203,10,203,13],[204,12,204,13],[205,10,205,13],[189,3,200,3],[189,4,190,4],[189,6,189,8],[189,9,190,9],[193,4,194,4],[193,6,193,8],[193,9,194,9],[197,4,198,4],[197,6,197,8],[197,9,198,9],[185,9,186,9],[185,10,185,13],[195,4,196,4],[195,6,195,8],[195,9,196,9],[191,4,192,4],[191,6,191,8],[191,9,192,9],[195,10,195,13],[196,12,196,13],[186,12,186,13],[187,4,188,4],[187,6,187,8],[187,9,188,9],[187,10,187,13],[188,12,188,13],[185,4,186,4],[185,6,185,8],[181,9,182,9],[199,4,200,4],[199,6,199,8],[199,9,200,9],[199,10,199,13],[200,12,200,13],[189,10,189,13],[190,12,190,13],[191,10,191,13],[197,10,197,13],[173,6,173,8],[173,9,174,9],[183,4,184,4],[183,6,183,8],[183,9,184,9],[179,4,180,4],[179,6,179,8],[179,9,180,9],[181,4,182,4],[181,6,181,8],[179,10,179,13],[180,12,180,13],[175,10,175,13],[176,12,176,13],[165,3,176,3],[165,4,166,4],[165,6,165,8],[165,9,166,9],[169,4,170,4],[173,4,174,4],[177,3,188,3],[177,4,178,4],[177,6,177,8],[177,9,178,9],[183,10,183,13],[184,12,184,13],[181,10,181,13],[182,12,182,13],[178,12,178,13],[177,10,177,13],[163,6,163,8],[171,4,172,4],[171,6,171,8],[167,9,168,9],[167,4,168,4],[167,6,167,8],[169,6,169,8],[169,9,170,9],[169,10,169,13],[170,12,170,13],[171,10,171,13],[172,12,172,13],[175,4,176,4],[175,6,175,8],[175,9,176,9],[171,9,172,9],[173,10,173,13],[174,12,174,13],[167,10,167,13],[168,12,168,13],[165,10,165,13],[166,12,166,13],[159,4,160,4],[159,6,159,8],[159,9,160,9],[159,10,159,13],[160,12,160,13],[163,9,164,9],[163,10,163,13],[164,12,164,13],[161,10,161,13],[162,12,162,13],[157,10,157,13],[158,12,158,13],[153,3,164,3],[153,4,154,4],[153,6,153,8],[153,9,154,9],[157,4,158,4],[161,4,162,4],[161,6,161,8],[161,9,162,9],[155,4,156,4],[163,4,164,4],[151,4,152,4],[151,6,151,8],[151,9,152,9],[151,10,151,13],[152,12,152,13],[149,4,150,4],[149,6,149,8],[149,9,150,9],[149,10,149,13],[145,9,146,9],[153,10,153,13],[154,12,154,13],[157,6,157,8],[157,9,158,9],[155,6,155,8],[155,9,156,9],[150,12,150,13],[155,10,155,13],[156,12,156,13],[137,6,137,8],[137,9,138,9],[147,4,148,4],[147,6,147,8],[147,9,148,9],[143,4,144,4],[143,6,143,8],[143,9,144,9],[145,4,146,4],[145,6,145,8],[143,10,143,13],[144,12,144,13],[139,10,139,13],[140,12,140,13],[129,3,140,3],[129,4,130,4],[129,6,129,8],[129,9,130,9],[133,4,134,4],[137,4,138,4],[141,3,152,3],[141,4,142,4],[141,6,141,8],[141,9,142,9],[147,10,147,13],[148,12,148,13],[145,10,145,13],[146,12,146,13],[142,12,142,13],[141,10,141,13],[127,6,127,8],[135,4,136,4],[135,6,135,8],[131,9,132,9],[131,4,132,4],[131,6,131,8],[133,6,133,8],[133,9,134,9],[133,10,133,13],[134,12,134,13],[135,10,135,13],[136,12,136,13],[139,4,140,4],[139,6,139,8],[139,9,140,9],[135,9,136,9],[137,10,137,13],[138,12,138,13],[131,10,131,13],[132,12,132,13],[129,10,129,13],[130,12,130,13],[123,4,124,4],[123,6,123,8],[123,9,124,9],[123,10,123,13],[124,12,124,13],[127,9,128,9],[127,10,127,13],[128,12,128,13],[125,10,125,13],[126,12,126,13],[121,10,121,13],[122,12,122,13],[117,3,128,3],[117,4,118,4],[117,6,117,8],[117,9,118,9],[121,4,122,4],[125,4,126,4],[125,6,125,8],[125,9,126,9],[119,4,120,4],[127,4,128,4],[115,4,116,4],[115,6,115,8],[115,9,116,9],[115,10,115,13],[116,12,116,13],[113,4,114,4],[113,6,113,8],[113,9,114,9],[113,10,113,13],[109,9,110,9],[117,10,117,13],[118,12,118,13],[121,6,121,8],[121,9,122,9],[119,6,119,8],[119,9,120,9],[114,12,114,13],[119,10,119,13],[120,12,120,13],[101,6,101,8],[101,9,102,9],[111,4,112,4],[111,6,111,8],[111,9,112,9],[107,4,108,4],[107,6,107,8],[107,9,108,9],[109,4,110,4],[109,6,109,8],[107,10,107,13],[108,12,108,13],[103,10,103,13],[104,12,104,13],[93,3,104,3],[93,4,94,4],[93,6,93,8],[93,9,94,9],[97,4,98,4],[101,4,102,4],[105,3,116,3],[105,4,106,4],[105,6,105,8],[105,9,106,9],[111,10,111,13],[112,12,112,13],[109,10,109,13],[110,12,110,13],[106,12,106,13],[105,10,105,13],[91,6,91,8],[99,4,100,4],[99,6,99,8],[95,9,96,9],[95,4,96,4],[95,6,95,8],[97,6,97,8],[97,9,98,9],[97,10,97,13],[98,12,98,13],[99,10,99,13],[100,12,100,13],[103,4,104,4],[103,6,103,8],[103,9,104,9],[99,9,100,9],[101,10,101,13],[102,12,102,13],[95,10,95,13],[96,12,96,13],[93,10,93,13],[94,12,94,13],[87,4,88,4],[87,6,87,8],[87,9,88,9],[87,10,87,13],[88,12,88,13],[91,9,92,9],[91,10,91,13],[92,12,92,13],[89,10,89,13],[90,12,90,13],[85,10,85,13],[86,12,86,13],[81,3,92,3],[81,4,82,4],[81,6,81,8],[81,9,82,9],[85,4,86,4],[89,4,90,4],[89,6,89,8],[89,9,90,9],[83,4,84,4],[91,4,92,4],[79,4,80,4],[79,6,79,8],[79,9,80,9],[79,10,79,13],[80,12,80,13],[77,4,78,4],[77,6,77,8],[77,9,78,9],[77,10,77,13],[73,9,74,9],[81,10,81,13],[82,12,82,13],[85,6,85,8],[85,9,86,9],[83,6,83,8],[83,9,84,9],[78,12,78,13],[83,10,83,13],[84,12,84,13],[65,6,65,8],[65,9,66,9],[75,4,76,4],[75,6,75,8],[75,9,76,9],[71,4,72,4],[71,6,71,8],[71,9,72,9],[73,4,74,4],[73,6,73,8],[71,10,71,13],[72,12,72,13],[67,10,67,13],[68,12,68,13],[57,3,68,3],[57,4,58,4],[57,6,57,8],[57,9,58,9],[61,4,62,4],[65,4,66,4],[69,3,80,3],[69,4,70,4],[69,6,69,8],[69,9,70,9],[75,10,75,13],[76,12,76,13],[73,10,73,13],[74,12,74,13],[70,12,70,13],[69,10,69,13],[55,4,56,4],[55,6,55,8],[63,4,64,4],[63,6,63,8],[59,9,60,9],[59,4,60,4],[59,6,59,8],[61,6,61,8],[61,9,62,9],[61,10,61,13],[62,12,62,13],[63,10,63,13],[64,12,64,13],[67,4,68,4],[67,6,67,8],[67,9,68,9],[63,9,64,9],[65,10,65,13],[66,12,66,13],[59,10,59,13],[60,12,60,13],[57,10,57,13],[58,12,58,13],[51,4,52,4],[51,6,51,8],[51,9,52,9],[51,10,51,13],[52,12,52,13],[55,9,56,9],[55,10,55,13],[56,12,56,13],[45,3,56,3],[45,4,46,4],[45,6,45,8],[45,9,46,9],[49,4,50,4],[53,4,54,4],[53,6,53,8],[53,9,54,9],[47,4,48,4],[47,6,47,8],[47,9,48,9],[53,10,53,13],[45,10,45,13],[46,12,46,13],[49,6,49,8],[49,9,50,9],[43,4,44,4],[43,6,43,8],[43,9,44,9],[43,10,43,13],[44,12,44,13],[54,12,54,13],[49,10,49,13],[50,12,50,13],[47,10,47,13],[48,12,48,13],[39,6,39,8],[31,10,31,13],[32,12,32,13],[33,10,33,13],[41,9,42,9],[41,10,41,13],[39,9,40,9],[30,12,30,13],[42,12,42,13],[35,10,35,13],[36,12,36,13],[37,10,37,13],[39,10,39,13],[40,12,40,13],[38,12,38,13],[28,12,28,13],[33,4,34,4],[33,6,33,8],[33,9,34,9],[31,9,32,9],[34,12,34,13],[29,4,30,4],[29,6,29,8],[31,6,31,8],[29,10,29,13],[19,10,19,13],[20,12,20,13],[21,10,21,13],[26,12,26,13],[21,6,21,8],[21,9,22,9],[24,12,24,13],[35,4,36,4],[35,6,35,8],[35,9,36,9],[33,3,44,3],[37,4,38,4],[37,6,37,8],[37,9,38,9],[41,4,42,4],[41,6,41,8],[39,4,40,4],[25,10,25,13],[25,6,25,8],[22,12,22,13],[23,10,23,13],[21,3,32,3],[29,9,30,9],[25,9,26,9],[31,4,32,4],[27,10,27,13],[27,6,27,8],[19,6,19,8],[13,6,13,8],[25,4,26,4],[27,9,28,9],[23,9,24,9],[23,4,24,4],[27,4,28,4],[23,6,23,8],[9,3,20,3],[9,4,10,4],[19,4,20,4],[15,9,16,9],[13,9,14,9],[21,4,22,4],[19,9,20,9],[17,4,18,4],[17,9,18,9],[17,6,17,8],[17,10,17,13],[18,12,18,13],[0,15,1,16],[2,15,3,16],[15,10,15,13],[7,1,7,2],[7,6,7,8],[15,4,16,4],[15,6,15,8],[8,1,8,2],[7,10,7,13],[2,4,2,9],[9,6,9,8],[11,9,12,9],[12,12,12,13],[16,12,16,13],[13,10,13,13],[14,12,14,13],[11,6,11,8],[13,4,14,4],[11,4,12,4],[6,10,6,13],[0,6,0,8],[1,4,1,9],[10,12,10,13],[11,10,11,13],[9,9,10,9],[6,6,6,8],[9,10,9,13],[8,12,8,13]]}
[null,"eLogic Model® ",null,null,null,null,"Year 2",null,null,null,null,null,null,null,"OMB Approval 2535-0114 exp. 08/31/2014"]
[null,null,null,"Applicant Legal Name",{"$f":"Coversheet!F21","v":"South Florida Regional Planning Council"}]
[null,null,null,"CCR Doing Business As Name",{"$f":"Coversheet!F22","v":0}]
[null,null,null,"HUD Program",{"$f":"Coversheet!F11","v":"Sustainable Communities Regional Planning Grants "},null,null,null,"Reporting Period"]
[null,null,null,"Program Component",null,null,null,null,"Reporting Start Date",null,"DUNS No.",{"$f":"Coversheet!F23","v":"072235286"},"­",{"$f":"Coversheet!H23","v":0}]
[null,null,null,"Project Name",{"$f":"Coversheet!F32","v":"South Florida Regional Partnership - Sustainable Communities Initiative"},null,null,null,"Reporting End Date",null,null,null,null,null,2011]
[null,"HUD Goals","Policy Priority","Needs","Services/Activities","Output Goal","Measures",null,null,"Outcomes ","Measures",null,null,null,"Evaluation Tools"]
[null,1,null,2,3,4,4,null,null,5,6,null,null,null,7]
[null,"Policy",null,"Planning","Programming","Measure","Pre","Post","YTD","Impact","Pre","Post","YTD",null,"Accountability"]
[null,null,null,null,null,null,{"$f":"RIGHT(E10,(LEN(E10)-FIND(\"|\",E10)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Nontraditional representatives incorporated into the Governance Board-Nontraditional Members |Persons",{"$f":"RIGHT(J10,(LEN(J10)-FIND(\"|\",J10)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,2,null,null,null,"A. Tools for Measurement"]
[null,null,null,null,null,null,{"$f":"RIGHT(E12,(LEN(E12)-FIND(\"|\",E12)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J12,(LEN(J12)-FIND(\"|\",J12)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E14,(LEN(E14)-FIND(\"|\",E14)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Nontraditional representatives incorporated into the Governance Board-Nontraditional Members |Persons",{"$f":"RIGHT(J14,(LEN(J14)-FIND(\"|\",J14)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,{"$f":"RIGHT(E16,(LEN(E16)-FIND(\"|\",E16)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J16,(LEN(J16)-FIND(\"|\",J16)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B.  Where Data Maintained"]
[null,null,null,null,null,null,{"$f":"RIGHT(E18,(LEN(E18)-FIND(\"|\",E18)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J18,(LEN(J18)-FIND(\"|\",J18)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E20,(LEN(E20)-FIND(\"|\",E20)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J20,(LEN(J20)-FIND(\"|\",J20)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E22,(LEN(E22)-FIND(\"|\",E22)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J22,(LEN(J22)-FIND(\"|\",J22)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100,null,null,null,"C.  Source of Data"]
[null,null,null,null,null,null,{"$f":"RIGHT(E24,(LEN(E24)-FIND(\"|\",E24)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J24,(LEN(J24)-FIND(\"|\",J24)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E26,(LEN(E26)-FIND(\"|\",E26)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J26,(LEN(J26)-FIND(\"|\",J26)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E28,(LEN(E28)-FIND(\"|\",E28)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J28,(LEN(J28)-FIND(\"|\",J28)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D. Frequency of Collection"]
[null,null,null,null,null,null,{"$f":"RIGHT(E30,(LEN(E30)-FIND(\"|\",E30)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J30,(LEN(J30)-FIND(\"|\",J30)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E32,(LEN(E32)-FIND(\"|\",E32)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J32,(LEN(J32)-FIND(\"|\",J32)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E34,(LEN(E34)-FIND(\"|\",E34)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J34,(LEN(J34)-FIND(\"|\",J34)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.  Processing of Data"]
[null,null,null,null,null,null,{"$f":"RIGHT(E36,(LEN(E36)-FIND(\"|\",E36)))","v":{"$error":"#VALUE!"}},null,null,"new- Completion of Data analyses/studies |Date Completed",{"$f":"RIGHT(J36,(LEN(J36)-FIND(\"|\",J36)))","v":"Date Completed"}]
[null,null,null,null,null,null,null,null,null,null,"2012-12-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E38,(LEN(E38)-FIND(\"|\",E38)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J38,(LEN(J38)-FIND(\"|\",J38)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E40,(LEN(E40)-FIND(\"|\",E40)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J40,(LEN(J40)-FIND(\"|\",J40)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E42,(LEN(E42)-FIND(\"|\",E42)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J42,(LEN(J42)-FIND(\"|\",J42)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E44,(LEN(E44)-FIND(\"|\",E44)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J44,(LEN(J44)-FIND(\"|\",J44)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E46,(LEN(E46)-FIND(\"|\",E46)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J46,(LEN(J46)-FIND(\"|\",J46)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E48,(LEN(E48)-FIND(\"|\",E48)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J48,(LEN(J48)-FIND(\"|\",J48)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E50,(LEN(E50)-FIND(\"|\",E50)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J50,(LEN(J50)-FIND(\"|\",J50)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E52,(LEN(E52)-FIND(\"|\",E52)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J52,(LEN(J52)-FIND(\"|\",J52)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E54,(LEN(E54)-FIND(\"|\",E54)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J54,(LEN(J54)-FIND(\"|\",J54)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E56,(LEN(E56)-FIND(\"|\",E56)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J56,(LEN(J56)-FIND(\"|\",J56)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E58,(LEN(E58)-FIND(\"|\",E58)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J58,(LEN(J58)-FIND(\"|\",J58)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E60,(LEN(E60)-FIND(\"|\",E60)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J60,(LEN(J60)-FIND(\"|\",J60)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E62,(LEN(E62)-FIND(\"|\",E62)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J62,(LEN(J62)-FIND(\"|\",J62)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E64,(LEN(E64)-FIND(\"|\",E64)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J64,(LEN(J64)-FIND(\"|\",J64)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E66,(LEN(E66)-FIND(\"|\",E66)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J66,(LEN(J66)-FIND(\"|\",J66)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E68,(LEN(E68)-FIND(\"|\",E68)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J68,(LEN(J68)-FIND(\"|\",J68)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need to transform isolated, racially, and economically segregated areas into communities of opportunity that reduce social disparities so all have access to quality jobs, schools, affordable housing, transportation, and cultural and physical amenities.","Regional Planning-Conduct scenario planning-Economic Development-Participating jurisdictions |Participating Jurisdictions",null,{"$f":"RIGHT(E70,(LEN(E70)-FIND(\"|\",E70)))","v":"Participating Jurisdictions"},null,null,null,{"$f":"RIGHT(J70,(LEN(J70)-FIND(\"|\",J70)))","v":{"$error":"#VALUE!"}}]
[null,"4A","1c",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E72,(LEN(E72)-FIND(\"|\",E72)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J72,(LEN(J72)-FIND(\"|\",J72)))","v":{"$error":"#VALUE!"}}]
[null,null,"4b"]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Economic Development |Scenarios  Developed",null,{"$f":"RIGHT(E74,(LEN(E74)-FIND(\"|\",E74)))","v":"Scenarios  Developed"},null,null,null,{"$f":"RIGHT(J74,(LEN(J74)-FIND(\"|\",J74)))","v":{"$error":"#VALUE!"}}]
[null,null,"6a",null,null,null,3]
[null,null,null,null,null,null,{"$f":"RIGHT(E76,(LEN(E76)-FIND(\"|\",E76)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J76,(LEN(J76)-FIND(\"|\",J76)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Affordable  Housing Opportunities |Scenarios  Developed",null,{"$f":"RIGHT(E78,(LEN(E78)-FIND(\"|\",E78)))","v":"Scenarios  Developed"},null,null,null,{"$f":"RIGHT(J78,(LEN(J78)-FIND(\"|\",J78)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,3]
[null,null,null,null,null,null,{"$f":"RIGHT(E80,(LEN(E80)-FIND(\"|\",E80)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J80,(LEN(J80)-FIND(\"|\",J80)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for economic development activities focusing on reuse/expansion/creation of commercial/industrial centers that create jobs for residents of all income levels and create a strong regional economy. ","Regional Planning-Conduct scenario planning-Affordable Housing-Participating Jurisdictions |Participating Jurisdictions",null,{"$f":"RIGHT(E82,(LEN(E82)-FIND(\"|\",E82)))","v":"Participating Jurisdictions"},null,null,null,{"$f":"RIGHT(J82,(LEN(J82)-FIND(\"|\",J82)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E84,(LEN(E84)-FIND(\"|\",E84)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J84,(LEN(J84)-FIND(\"|\",J84)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Transportation-Participating Jurisdictions |Participating Jurisdictions",null,{"$f":"RIGHT(E86,(LEN(E86)-FIND(\"|\",E86)))","v":"Participating Jurisdictions"},null,null,null,{"$f":"RIGHT(J86,(LEN(J86)-FIND(\"|\",J86)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E88,(LEN(E88)-FIND(\"|\",E88)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J88,(LEN(J88)-FIND(\"|\",J88)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Transportation |Scenarios Developed",null,{"$f":"RIGHT(E90,(LEN(E90)-FIND(\"|\",E90)))","v":"Scenarios Developed"},null,null,null,{"$f":"RIGHT(J90,(LEN(J90)-FIND(\"|\",J90)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,3]
[null,null,null,null,null,null,{"$f":"RIGHT(E92,(LEN(E92)-FIND(\"|\",E92)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J92,(LEN(J92)-FIND(\"|\",J92)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Perform technical planning studies |Date Completed",null,{"$f":"RIGHT(E94,(LEN(E94)-FIND(\"|\",E94)))","v":"Date Completed"},null,null,null,{"$f":"RIGHT(J94,(LEN(J94)-FIND(\"|\",J94)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"2012-12-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E96,(LEN(E96)-FIND(\"|\",E96)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J96,(LEN(J96)-FIND(\"|\",J96)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E98,(LEN(E98)-FIND(\"|\",E98)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J98,(LEN(J98)-FIND(\"|\",J98)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E100,(LEN(E100)-FIND(\"|\",E100)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J100,(LEN(J100)-FIND(\"|\",J100)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E102,(LEN(E102)-FIND(\"|\",E102)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J102,(LEN(J102)-FIND(\"|\",J102)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E104,(LEN(E104)-FIND(\"|\",E104)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J104,(LEN(J104)-FIND(\"|\",J104)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E106,(LEN(E106)-FIND(\"|\",E106)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J106,(LEN(J106)-FIND(\"|\",J106)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E108,(LEN(E108)-FIND(\"|\",E108)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J108,(LEN(J108)-FIND(\"|\",J108)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E110,(LEN(E110)-FIND(\"|\",E110)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J110,(LEN(J110)-FIND(\"|\",J110)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F14","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E112,(LEN(E112)-FIND(\"|\",E112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J112,(LEN(J112)-FIND(\"|\",J112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F16","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E114,(LEN(E114)-FIND(\"|\",E114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J114,(LEN(J114)-FIND(\"|\",J114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F18","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E116,(LEN(E116)-FIND(\"|\",E116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J116,(LEN(J116)-FIND(\"|\",J116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F19","v":0}]
[]
[null,null,null,"There is a need for integrated environmental planning for air, water, and land use to  ensure healthy environments and to avoid adverse environmental impacts. ","Environment-Develop strategies for integrating air, water and land use to ensure a healthy living environment and avoiding adverse environmental impacts |Strategies",null,{"$f":"RIGHT(E118,(LEN(E118)-FIND(\"|\",E118)))","v":"Strategies"},null,null,null,{"$f":"RIGHT(J118,(LEN(J118)-FIND(\"|\",J118)))","v":{"$error":"#VALUE!"}}]
[null,"4B","6a",null,null,null,1]
[null,null,null,null,null,null,{"$f":"RIGHT(E120,(LEN(E120)-FIND(\"|\",E120)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J120,(LEN(J120)-FIND(\"|\",J120)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E122,(LEN(E122)-FIND(\"|\",E122)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J122,(LEN(J122)-FIND(\"|\",J122)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E124,(LEN(E124)-FIND(\"|\",E124)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J124,(LEN(J124)-FIND(\"|\",J124)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E126,(LEN(E126)-FIND(\"|\",E126)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J126,(LEN(J126)-FIND(\"|\",J126)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E128,(LEN(E128)-FIND(\"|\",E128)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J128,(LEN(J128)-FIND(\"|\",J128)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E130,(LEN(E130)-FIND(\"|\",E130)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J130,(LEN(J130)-FIND(\"|\",J130)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E132,(LEN(E132)-FIND(\"|\",E132)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J132,(LEN(J132)-FIND(\"|\",J132)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E134,(LEN(E134)-FIND(\"|\",E134)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J134,(LEN(J134)-FIND(\"|\",J134)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E136,(LEN(E136)-FIND(\"|\",E136)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J136,(LEN(J136)-FIND(\"|\",J136)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E138,(LEN(E138)-FIND(\"|\",E138)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J138,(LEN(J138)-FIND(\"|\",J138)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E140,(LEN(E140)-FIND(\"|\",E140)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J140,(LEN(J140)-FIND(\"|\",J140)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E142,(LEN(E142)-FIND(\"|\",E142)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J142,(LEN(J142)-FIND(\"|\",J142)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E144,(LEN(E144)-FIND(\"|\",E144)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J144,(LEN(J144)-FIND(\"|\",J144)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E146,(LEN(E146)-FIND(\"|\",E146)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J146,(LEN(J146)-FIND(\"|\",J146)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E148,(LEN(E148)-FIND(\"|\",E148)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J148,(LEN(J148)-FIND(\"|\",J148)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E150,(LEN(E150)-FIND(\"|\",E150)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J150,(LEN(J150)-FIND(\"|\",J150)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E152,(LEN(E152)-FIND(\"|\",E152)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J152,(LEN(J152)-FIND(\"|\",J152)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E154,(LEN(E154)-FIND(\"|\",E154)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J154,(LEN(J154)-FIND(\"|\",J154)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E156,(LEN(E156)-FIND(\"|\",E156)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J156,(LEN(J156)-FIND(\"|\",J156)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E158,(LEN(E158)-FIND(\"|\",E158)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J158,(LEN(J158)-FIND(\"|\",J158)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E160,(LEN(E160)-FIND(\"|\",E160)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J160,(LEN(J160)-FIND(\"|\",J160)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E162,(LEN(E162)-FIND(\"|\",E162)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J162,(LEN(J162)-FIND(\"|\",J162)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E164,(LEN(E164)-FIND(\"|\",E164)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J164,(LEN(J164)-FIND(\"|\",J164)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E166,(LEN(E166)-FIND(\"|\",E166)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J166,(LEN(J166)-FIND(\"|\",J166)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E168,(LEN(E168)-FIND(\"|\",E168)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J168,(LEN(J168)-FIND(\"|\",J168)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E170,(LEN(E170)-FIND(\"|\",E170)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J170,(LEN(J170)-FIND(\"|\",J170)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E172,(LEN(E172)-FIND(\"|\",E172)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J172,(LEN(J172)-FIND(\"|\",J172)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E174,(LEN(E174)-FIND(\"|\",E174)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J174,(LEN(J174)-FIND(\"|\",J174)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E176,(LEN(E176)-FIND(\"|\",E176)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J176,(LEN(J176)-FIND(\"|\",J176)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E178,(LEN(E178)-FIND(\"|\",E178)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J178,(LEN(J178)-FIND(\"|\",J178)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E180,(LEN(E180)-FIND(\"|\",E180)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J180,(LEN(J180)-FIND(\"|\",J180)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E182,(LEN(E182)-FIND(\"|\",E182)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J182,(LEN(J182)-FIND(\"|\",J182)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E184,(LEN(E184)-FIND(\"|\",E184)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J184,(LEN(J184)-FIND(\"|\",J184)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E186,(LEN(E186)-FIND(\"|\",E186)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J186,(LEN(J186)-FIND(\"|\",J186)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E188,(LEN(E188)-FIND(\"|\",E188)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J188,(LEN(J188)-FIND(\"|\",J188)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E190,(LEN(E190)-FIND(\"|\",E190)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J190,(LEN(J190)-FIND(\"|\",J190)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E192,(LEN(E192)-FIND(\"|\",E192)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J192,(LEN(J192)-FIND(\"|\",J192)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E194,(LEN(E194)-FIND(\"|\",E194)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J194,(LEN(J194)-FIND(\"|\",J194)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E196,(LEN(E196)-FIND(\"|\",E196)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J196,(LEN(J196)-FIND(\"|\",J196)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E198,(LEN(E198)-FIND(\"|\",E198)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J198,(LEN(J198)-FIND(\"|\",J198)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E200,(LEN(E200)-FIND(\"|\",E200)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J200,(LEN(J200)-FIND(\"|\",J200)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E202,(LEN(E202)-FIND(\"|\",E202)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J202,(LEN(J202)-FIND(\"|\",J202)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E204,(LEN(E204)-FIND(\"|\",E204)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J204,(LEN(J204)-FIND(\"|\",J204)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E206,(LEN(E206)-FIND(\"|\",E206)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J206,(LEN(J206)-FIND(\"|\",J206)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E208,(LEN(E208)-FIND(\"|\",E208)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J208,(LEN(J208)-FIND(\"|\",J208)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E210,(LEN(E210)-FIND(\"|\",E210)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J210,(LEN(J210)-FIND(\"|\",J210)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E212,(LEN(E212)-FIND(\"|\",E212)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J212,(LEN(J212)-FIND(\"|\",J212)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E214,(LEN(E214)-FIND(\"|\",E214)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J214,(LEN(J214)-FIND(\"|\",J214)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E216,(LEN(E216)-FIND(\"|\",E216)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J216,(LEN(J216)-FIND(\"|\",J216)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E218,(LEN(E218)-FIND(\"|\",E218)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J218,(LEN(J218)-FIND(\"|\",J218)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E220,(LEN(E220)-FIND(\"|\",E220)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J220,(LEN(J220)-FIND(\"|\",J220)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E222,(LEN(E222)-FIND(\"|\",E222)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J222,(LEN(J222)-FIND(\"|\",J222)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E224,(LEN(E224)-FIND(\"|\",E224)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J224,(LEN(J224)-FIND(\"|\",J224)))","v":{"$error":"#VALUE!"}}]

{"sheet":"Year3","index":4,"n_rows":224,"n_cols":15,"rows_kept":224,"cut":false,"hidden":false,"merged":[[201,3,212,3],[223,4,224,4],[223,6,223,8],[223,9,224,9],[221,4,222,4],[219,4,220,4],[213,3,224,3],[213,4,214,4],[209,6,209,8],[209,9,210,9],[217,4,218,4],[213,6,213,8],[215,6,215,8],[215,4,216,4],[213,9,214,9],[217,6,217,8],[215,9,216,9],[219,6,219,8],[219,10,219,13],[219,9,220,9],[221,6,221,8],[221,10,221,13],[220,12,220,13],[213,10,213,13],[214,12,214,13],[210,12,210,13],[209,10,209,13],[211,10,211,13],[224,12,224,13],[222,12,222,13],[216,12,216,13],[217,9,218,9],[215,10,215,13],[223,10,223,13],[217,10,217,13],[218,12,218,13],[221,9,222,9],[206,12,206,13],[212,12,212,13],[201,4,202,4],[201,6,201,8],[201,9,202,9],[205,4,206,4],[205,6,205,8],[205,9,206,9],[201,10,201,13],[207,4,208,4],[211,4,212,4],[211,6,211,8],[211,9,212,9],[203,4,204,4],[203,6,203,8],[203,9,204,9],[209,4,210,4],[207,6,207,8],[207,9,208,9],[207,10,207,13],[208,12,208,13],[192,12,192,13],[193,10,193,13],[194,12,194,13],[198,12,198,13],[202,12,202,13],[203,10,203,13],[204,12,204,13],[205,10,205,13],[189,3,200,3],[189,4,190,4],[189,6,189,8],[189,9,190,9],[193,4,194,4],[193,6,193,8],[193,9,194,9],[197,4,198,4],[197,6,197,8],[197,9,198,9],[185,9,186,9],[185,10,185,13],[195,4,196,4],[195,6,195,8],[195,9,196,9],[191,4,192,4],[191,6,191,8],[191,9,192,9],[195,10,195,13],[196,12,196,13],[186,12,186,13],[187,4,188,4],[187,6,187,8],[187,9,188,9],[187,10,187,13],[188,12,188,13],[185,4,186,4],[185,6,185,8],[181,9,182,9],[199,4,200,4],[199,6,199,8],[199,9,200,9],[199,10,199,13],[200,12,200,13],[189,10,189,13],[190,12,190,13],[191,10,191,13],[197,10,197,13],[173,6,173,8],[173,9,174,9],[183,4,184,4],[183,6,183,8],[183,9,184,9],[179,4,180,4],[179,6,179,8],[179,9,180,9],[181,4,182,4],[181,6,181,8],[179,10,179,13],[180,12,180,13],[175,10,175,13],[176,12,176,13],[165,3,176,3],[165,4,166,4],[165,6,165,8],[165,9,166,9],[169,4,170,4],[173,4,174,4],[177,3,188,3],[177,4,178,4],[177,6,177,8],[177,9,178,9],[183,10,183,13],[184,12,184,13],[181,10,181,13],[182,12,182,13],[178,12,178,13],[177,10,177,13],[163,6,163,8],[171,4,172,4],[171,6,171,8],[167,9,168,9],[167,4,168,4],[167,6,167,8],[169,6,169,8],[169,9,170,9],[169,10,169,13],[170,12,170,13],[171,10,171,13],[172,12,172,13],[175,4,176,4],[175,6,175,8],[175,9,176,9],[171,9,172,9],[173,10,173,13],[174,12,174,13],[167,10,167,13],[168,12,168,13],[165,10,165,13],[166,12,166,13],[159,4,160,4],[159,6,159,8],[159,9,160,9],[159,10,159,13],[160,12,160,13],[163,9,164,9],[163,10,163,13],[164,12,164,13],[161,10,161,13],[162,12,162,13],[157,10,157,13],[158,12,158,13],[153,3,164,3],[153,4,154,4],[153,6,153,8],[153,9,154,9],[157,4,158,4],[161,4,162,4],[161,6,161,8],[161,9,162,9],[155,4,156,4],[163,4,164,4],[151,4,152,4],[151,6,151,8],[151,9,152,9],[151,10,151,13],[152,12,152,13],[149,4,150,4],[149,6,149,8],[149,9,150,9],[149,10,149,13],[145,9,146,9],[153,10,153,13],[154,12,154,13],[157,6,157,8],[157,9,158,9],[155,6,155,8],[155,9,156,9],[150,12,150,13],[155,10,155,13],[156,12,156,13],[137,6,137,8],[137,9,138,9],[147,4,148,4],[147,6,147,8],[147,9,148,9],[143,4,144,4],[143,6,143,8],[143,9,144,9],[145,4,146,4],[145,6,145,8],[143,10,143,13],[144,12,144,13],[139,10,139,13],[140,12,140,13],[129,3,140,3],[129,4,130,4],[129,6,129,8],[129,9,130,9],[133,4,134,4],[137,4,138,4],[141,3,152,3],[141,4,142,4],[141,6,141,8],[141,9,142,9],[147,10,147,13],[148,12,148,13],[145,10,145,13],[146,12,146,13],[142,12,142,13],[141,10,141,13],[127,6,127,8],[135,4,136,4],[135,6,135,8],[131,9,132,9],[131,4,132,4],[131,6,131,8],[133,6,133,8],[133,9,134,9],[133,10,133,13],[134,12,134,13],[135,10,135,13],[136,12,136,13],[139,4,140,4],[139,6,139,8],[139,9,140,9],[135,9,136,9],[137,10,137,13],[138,12,138,13],[131,10,131,13],[132,12,132,13],[129,10,129,13],[130,12,130,13],[123,4,124,4],[123,6,123,8],[123,9,124,9],[123,10,123,13],[124,12,124,13],[127,9,128,9],[127,10,127,13],[128,12,128,13],[125,10,125,13],[126,12,126,13],[121,10,121,13],[122,12,122,13],[117,3,128,3],[117,4,118,4],[117,6,117,8],[117,9,118,9],[121,4,122,4],[125,4,126,4],[125,6,125,8],[125,9,126,9],[119,4,120,4],[127,4,128,4],[115,4,116,4],[115,6,115,8],[115,9,116,9],[115,10,115,13],[116,12,116,13],[113,4,114,4],[113,6,113,8],[113,9,114,9],[113,10,113,13],[109,9,110,9],[117,10,117,13],[118,12,118,13],[121,6,121,8],[121,9,122,9],[119,6,119,8],[119,9,120,9],[114,12,114,13],[119,10,119,13],[120,12,120,13],[101,6,101,8],[101,9,102,9],[111,4,112,4],[111,6,111,8],[111,9,112,9],[107,4,108,4],[107,6,107,8],[107,9,108,9],[109,4,110,4],[109,6,109,8],[107,10,107,13],[108,12,108,13],[103,10,103,13],[104,12,104,13],[93,3,104,3],[93,4,94,4],[93,6,93,8],[93,9,94,9],[97,4,98,4],[101,4,102,4],[105,3,116,3],[105,4,106,4],[105,6,105,8],[105,9,106,9],[111,10,111,13],[112,12,112,13],[109,10,109,13],[110,12,110,13],[106,12,106,13],[105,10,105,13],[91,6,91,8],[99,4,100,4],[99,6,99,8],[95,9,96,9],[95,4,96,4],[95,6,95,8],[97,6,97,8],[97,9,98,9],[97,10,97,13],[98,12,98,13],[99,10,99,13],[100,12,100,13],[103,4,104,4],[103,6,103,8],[103,9,104,9],[99,9,100,9],[101,10,101,13],[102,12,102,13],[95,10,95,13],[96,12,96,13],[93,10,93,13],[94,12,94,13],[87,4,88,4],[87,6,87,8],[87,9,88,9],[87,10,87,13],[88,12,88,13],[91,9,92,9],[91,10,91,13],[92,12,92,13],[89,10,89,13],[90,12,90,13],[85,10,85,13],[86,12,86,13],[81,3,92,3],[81,4,82,4],[81,6,81,8],[81,9,82,9],[85,4,86,4],[89,4,90,4],[89,6,89,8],[89,9,90,9],[83,4,84,4],[91,4,92,4],[79,4,80,4],[79,6,79,8],[79,9,80,9],[79,10,79,13],[80,12,80,13],[77,4,78,4],[77,6,77,8],[77,9,78,9],[77,10,77,13],[73,9,74,9],[81,10,81,13],[82,12,82,13],[85,6,85,8],[85,9,86,9],[83,6,83,8],[83,9,84,9],[78,12,78,13],[83,10,83,13],[84,12,84,13],[65,6,65,8],[65,9,66,9],[75,4,76,4],[75,6,75,8],[75,9,76,9],[71,4,72,4],[71,6,71,8],[71,9,72,9],[73,4,74,4],[73,6,73,8],[71,10,71,13],[72,12,72,13],[67,10,67,13],[68,12,68,13],[57,3,68,3],[57,4,58,4],[57,6,57,8],[57,9,58,9],[61,4,62,4],[65,4,66,4],[69,3,80,3],[69,4,70,4],[69,6,69,8],[69,9,70,9],[75,10,75,13],[76,12,76,13],[73,10,73,13],[74,12,74,13],[70,12,70,13],[69,10,69,13],[55,4,56,4],[55,6,55,8],[63,4,64,4],[63,6,63,8],[59,9,60,9],[59,4,60,4],[59,6,59,8],[61,6,61,8],[61,9,62,9],[61,10,61,13],[62,12,62,13],[63,10,63,13],[64,12,64,13],[67,4,68,4],[67,6,67,8],[67,9,68,9],[63,9,64,9],[65,10,65,13],[66,12,66,13],[59,10,59,13],[60,12,60,13],[57,10,57,13],[58,12,58,13],[51,4,52,4],[51,6,51,8],[51,9,52,9],[51,10,51,13],[52,12,52,13],[55,9,56,9],[55,10,55,13],[56,12,56,13],[45,3,56,3],[45,4,46,4],[45,6,45,8],[45,9,46,9],[49,4,50,4],[53,4,54,4],[53,6,53,8],[53,9,54,9],[47,4,48,4],[47,6,47,8],[47,9,48,9],[53,10,53,13],[45,10,45,13],[46,12,46,13],[49,6,49,8],[49,9,50,9],[43,4,44,4],[43,6,43,8],[43,9,44,9],[43,10,43,13],[44,12,44,13],[54,12,54,13],[49,10,49,13],[50,12,50,13],[47,10,47,13],[48,12,48,13],[39,6,39,8],[31,10,31,13],[32,12,32,13],[33,10,33,13],[41,9,42,9],[41,10,41,13],[39,9,40,9],[30,12,30,13],[42,12,42,13],[35,10,35,13],[36,12,36,13],[37,10,37,13],[39,10,39,13],[40,12,40,13],[38,12,38,13],[28,12,28,13],[33,4,34,4],[33,6,33,8],[33,9,34,9],[31,9,32,9],[34,12,34,13],[29,4,30,4],[29,6,29,8],[31,6,31,8],[29,10,29,13],[19,10,19,13],[20,12,20,13],[21,10,21,13],[26,12,26,13],[21,6,21,8],[21,9,22,9],[24,12,24,13],[35,4,36,4],[35,6,35,8],[35,9,36,9],[33,3,44,3],[37,4,38,4],[37,6,37,8],[37,9,38,9],[41,4,42,4],[41,6,41,8],[39,4,40,4],[25,10,25,13],[25,6,25,8],[22,12,22,13],[23,10,23,13],[21,3,32,3],[29,9,30,9],[25,9,26,9],[31,4,32,4],[27,10,27,13],[27,6,27,8],[19,6,19,8],[13,6,13,8],[25,4,26,4],[27,9,28,9],[23,9,24,9],[23,4,24,4],[27,4,28,4],[23,6,23,8],[9,3,20,3],[9,4,10,4],[19,4,20,4],[15,9,16,9],[13,9,14,9],[21,4,22,4],[19,9,20,9],[17,4,18,4],[17,9,18,9],[17,6,17,8],[17,10,17,13],[18,12,18,13],[0,15,1,16],[2,15,3,16],[15,10,15,13],[7,1,7,2],[7,6,7,8],[15,4,16,4],[15,6,15,8],[8,1,8,2],[7,10,7,13],[2,4,2,9],[9,6,9,8],[11,9,12,9],[12,12,12,13],[16,12,16,13],[13,10,13,13],[14,12,14,13],[11,6,11,8],[13,4,14,4],[11,4,12,4],[6,10,6,13],[0,6,0,8],[1,4,1,9],[10,12,10,13],[11,10,11,13],[9,9,10,9],[6,6,6,8],[9,10,9,13],[8,12,8,13]]}
[null,"eLogic Model® ",null,null,null,null,"Year 3",null,null,null,null,null,null,null,"OMB Approval 2535-0114 exp. 08/31/2014"]
[null,null,null,"Applicant Legal Name",{"$f":"Coversheet!F21","v":"South Florida Regional Planning Council"}]
[null,null,null,"CCR Doing Business As Name",{"$f":"Coversheet!F22","v":0}]
[null,null,null,"HUD Program",{"$f":"Coversheet!F11","v":"Sustainable Communities Regional Planning Grants "},null,null,null,"Reporting Period"]
[null,null,null,"Program Component",null,null,null,null,"Reporting Start Date",null,"DUNS No.",{"$f":"Coversheet!F23","v":"072235286"},"­",{"$f":"Coversheet!H23","v":0}]
[null,null,null,"Project Name",{"$f":"Coversheet!F32","v":"South Florida Regional Partnership - Sustainable Communities Initiative"},null,null,null,"Reporting End Date",null,null,null,null,null,2011]
[null,"HUD Goals","Policy Priority","Needs","Services/Activities","Output Goal","Measures",null,null,"Outcomes","Measures",null,null,null,"Evaluation Tools"]
[null,1,null,2,3,4,4,null,null,5,6,null,null,null,7]
[null,"Policy",null,"Planning","Programming","Measure","Pre","Post","YTD","Impact","Pre","Post","YTD",null,"Accountability"]
[null,null,null,null,null,null,{"$f":"RIGHT(E10,(LEN(E10)-FIND(\"|\",E10)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J10,(LEN(J10)-FIND(\"|\",J10)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A. Tools for Measurement"]
[null,null,null,null,null,null,{"$f":"RIGHT(E12,(LEN(E12)-FIND(\"|\",E12)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J12,(LEN(J12)-FIND(\"|\",J12)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E14,(LEN(E14)-FIND(\"|\",E14)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J14,(LEN(J14)-FIND(\"|\",J14)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E16,(LEN(E16)-FIND(\"|\",E16)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Private and non-federal funding secured and used as leverage to federal funds to support local planning efforts. |Dollars",{"$f":"RIGHT(J16,(LEN(J16)-FIND(\"|\",J16)))","v":"Dollars"}]
[null,null,null,null,null,null,null,null,null,null,500000,null,null,null,"B.  Where Data Maintained"]
[null,null,null,null,null,null,{"$f":"RIGHT(E18,(LEN(E18)-FIND(\"|\",E18)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J18,(LEN(J18)-FIND(\"|\",J18)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E20,(LEN(E20)-FIND(\"|\",E20)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J20,(LEN(J20)-FIND(\"|\",J20)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E22,(LEN(E22)-FIND(\"|\",E22)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J22,(LEN(J22)-FIND(\"|\",J22)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100,null,null,null,"C.  Source of Data"]
[null,null,null,null,null,null,{"$f":"RIGHT(E24,(LEN(E24)-FIND(\"|\",E24)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J24,(LEN(J24)-FIND(\"|\",J24)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E26,(LEN(E26)-FIND(\"|\",E26)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J26,(LEN(J26)-FIND(\"|\",J26)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E28,(LEN(E28)-FIND(\"|\",E28)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J28,(LEN(J28)-FIND(\"|\",J28)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100,null,null,null,"D. Frequency of Collection"]
[null,null,null,null,null,null,{"$f":"RIGHT(E30,(LEN(E30)-FIND(\"|\",E30)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J30,(LEN(J30)-FIND(\"|\",J30)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,{"$f":"RIGHT(E32,(LEN(E32)-FIND(\"|\",E32)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J32,(LEN(J32)-FIND(\"|\",J32)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,{"$f":"RIGHT(E34,(LEN(E34)-FIND(\"|\",E34)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J34,(LEN(J34)-FIND(\"|\",J34)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.  Processing of Data"]
[null,null,null,null,null,null,{"$f":"RIGHT(E36,(LEN(E36)-FIND(\"|\",E36)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J36,(LEN(J36)-FIND(\"|\",J36)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E38,(LEN(E38)-FIND(\"|\",E38)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J38,(LEN(J38)-FIND(\"|\",J38)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E40,(LEN(E40)-FIND(\"|\",E40)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J40,(LEN(J40)-FIND(\"|\",J40)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E42,(LEN(E42)-FIND(\"|\",E42)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J42,(LEN(J42)-FIND(\"|\",J42)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E44,(LEN(E44)-FIND(\"|\",E44)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J44,(LEN(J44)-FIND(\"|\",J44)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E46,(LEN(E46)-FIND(\"|\",E46)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J46,(LEN(J46)-FIND(\"|\",J46)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E48,(LEN(E48)-FIND(\"|\",E48)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Percent increase in the number of persons attending scenario and public meetings on regional planning as a result of attending education and training sessions |% Increase",{"$f":"RIGHT(J48,(LEN(J48)-FIND(\"|\",J48)))","v":"% Increase"}]
[null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,{"$f":"RIGHT(E50,(LEN(E50)-FIND(\"|\",E50)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J50,(LEN(J50)-FIND(\"|\",J50)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E52,(LEN(E52)-FIND(\"|\",E52)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J52,(LEN(J52)-FIND(\"|\",J52)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E54,(LEN(E54)-FIND(\"|\",E54)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J54,(LEN(J54)-FIND(\"|\",J54)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E56,(LEN(E56)-FIND(\"|\",E56)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J56,(LEN(J56)-FIND(\"|\",J56)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E58,(LEN(E58)-FIND(\"|\",E58)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J58,(LEN(J58)-FIND(\"|\",J58)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,{"$f":"RIGHT(E60,(LEN(E60)-FIND(\"|\",E60)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J60,(LEN(J60)-FIND(\"|\",J60)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E62,(LEN(E62)-FIND(\"|\",E62)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J62,(LEN(J62)-FIND(\"|\",J62)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,{"$f":"RIGHT(E64,(LEN(E64)-FIND(\"|\",E64)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J64,(LEN(J64)-FIND(\"|\",J64)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E66,(LEN(E66)-FIND(\"|\",E66)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J66,(LEN(J66)-FIND(\"|\",J66)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E68,(LEN(E68)-FIND(\"|\",E68)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J68,(LEN(J68)-FIND(\"|\",J68)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E70,(LEN(E70)-FIND(\"|\",E70)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J70,(LEN(J70)-FIND(\"|\",J70)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E72,(LEN(E72)-FIND(\"|\",E72)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J72,(LEN(J72)-FIND(\"|\",J72)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E74,(LEN(E74)-FIND(\"|\",E74)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J74,(LEN(J74)-FIND(\"|\",J74)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E76,(LEN(E76)-FIND(\"|\",E76)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J76,(LEN(J76)-FIND(\"|\",J76)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E78,(LEN(E78)-FIND(\"|\",E78)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J78,(LEN(J78)-FIND(\"|\",J78)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E80,(LEN(E80)-FIND(\"|\",E80)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J80,(LEN(J80)-FIND(\"|\",J80)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E82,(LEN(E82)-FIND(\"|\",E82)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J82,(LEN(J82)-FIND(\"|\",J82)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E84,(LEN(E84)-FIND(\"|\",E84)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J84,(LEN(J84)-FIND(\"|\",J84)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E86,(LEN(E86)-FIND(\"|\",E86)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J86,(LEN(J86)-FIND(\"|\",J86)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E88,(LEN(E88)-FIND(\"|\",E88)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J88,(LEN(J88)-FIND(\"|\",J88)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E90,(LEN(E90)-FIND(\"|\",E90)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J90,(LEN(J90)-FIND(\"|\",J90)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E92,(LEN(E92)-FIND(\"|\",E92)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J92,(LEN(J92)-FIND(\"|\",J92)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for multijurisdictional planning efforts that integrate housing, land use, economic and workforce development, transportation, and infrastructure investments to direct long-term development, reinvestment, and issues of regional significance.",null,null,{"$f":"RIGHT(E94,(LEN(E94)-FIND(\"|\",E94)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J94,(LEN(J94)-FIND(\"|\",J94)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E96,(LEN(E96)-FIND(\"|\",E96)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J96,(LEN(J96)-FIND(\"|\",J96)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Develop a Comprehensive Regional Plan for Sustainable Development-Plan completed |Date Completed",null,{"$f":"RIGHT(E98,(LEN(E98)-FIND(\"|\",E98)))","v":"Date Completed"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J98,(LEN(J98)-FIND(\"|\",J98)))","v":"Measures Amended/Added"}]
[null,"4E","2f",null,null,null,"2014-02-01",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E100,(LEN(E100)-FIND(\"|\",E100)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Private and non-federal funding secured and used as leverage to federal funds to support local planning efforts. |Dollars",{"$f":"RIGHT(J100,(LEN(J100)-FIND(\"|\",J100)))","v":"Dollars"}]
[null,null,"2i",null,null,null,null,null,null,null,500000]
[null,null,null,null,null,null,{"$f":"RIGHT(E102,(LEN(E102)-FIND(\"|\",E102)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Private and non-federal funding secured and used as leverage to federal funds to support the integration of local plans into a comprehensive regional plan |Dollars",{"$f":"RIGHT(J102,(LEN(J102)-FIND(\"|\",J102)))","v":"Dollars"}]
[null,null,null,null,null,null,null,null,null,null,500000]
[null,null,null,null,null,null,{"$f":"RIGHT(E104,(LEN(E104)-FIND(\"|\",E104)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J104,(LEN(J104)-FIND(\"|\",J104)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E106,(LEN(E106)-FIND(\"|\",E106)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J106,(LEN(J106)-FIND(\"|\",J106)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E108,(LEN(E108)-FIND(\"|\",E108)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J108,(LEN(J108)-FIND(\"|\",J108)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E110,(LEN(E110)-FIND(\"|\",E110)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J110,(LEN(J110)-FIND(\"|\",J110)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F14","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E112,(LEN(E112)-FIND(\"|\",E112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J112,(LEN(J112)-FIND(\"|\",J112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F16","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E114,(LEN(E114)-FIND(\"|\",E114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J114,(LEN(J114)-FIND(\"|\",J114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F18","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E116,(LEN(E116)-FIND(\"|\",E116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J116,(LEN(J116)-FIND(\"|\",J116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F19","v":0}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E118,(LEN(E118)-FIND(\"|\",E118)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions",{"$f":"RIGHT(J118,(LEN(J118)-FIND(\"|\",J118)))","v":"Jurisdictions"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E120,(LEN(E120)-FIND(\"|\",E120)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date",{"$f":"RIGHT(J120,(LEN(J120)-FIND(\"|\",J120)))","v":"Date"}]
[null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E122,(LEN(E122)-FIND(\"|\",E122)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J122,(LEN(J122)-FIND(\"|\",J122)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E124,(LEN(E124)-FIND(\"|\",E124)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J124,(LEN(J124)-FIND(\"|\",J124)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E126,(LEN(E126)-FIND(\"|\",E126)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J126,(LEN(J126)-FIND(\"|\",J126)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E128,(LEN(E128)-FIND(\"|\",E128)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J128,(LEN(J128)-FIND(\"|\",J128)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for pro-active short- and long-term urban design strategies that consider risks from disasters and climate change while harmonizing land use for sustainable development/conservation/transportation and water infrastructure.  ","Environment-Conduct analysis to develop meaningful climate adaptation strategies and define adaption actions |Date Completed",null,{"$f":"RIGHT(E130,(LEN(E130)-FIND(\"|\",E130)))","v":"Date Completed"},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions",{"$f":"RIGHT(J130,(LEN(J130)-FIND(\"|\",J130)))","v":"Jurisdictions"}]
[null,"4D","2b",null,null,null,"2014-02-01",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E132,(LEN(E132)-FIND(\"|\",E132)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date",{"$f":"RIGHT(J132,(LEN(J132)-FIND(\"|\",J132)))","v":"Date"}]
[null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E134,(LEN(E134)-FIND(\"|\",E134)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J134,(LEN(J134)-FIND(\"|\",J134)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Environment-Develop meaningful climate adaptation plan |Date Completed",null,{"$f":"RIGHT(E136,(LEN(E136)-FIND(\"|\",E136)))","v":"Date Completed"},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date",{"$f":"RIGHT(J136,(LEN(J136)-FIND(\"|\",J136)))","v":"Date"}]
[null,null,null,null,null,null,"2014-02-01",null,null,null,"2014-02-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E138,(LEN(E138)-FIND(\"|\",E138)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions",{"$f":"RIGHT(J138,(LEN(J138)-FIND(\"|\",J138)))","v":"Jurisdictions"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E140,(LEN(E140)-FIND(\"|\",E140)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J140,(LEN(J140)-FIND(\"|\",J140)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E142,(LEN(E142)-FIND(\"|\",E142)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J142,(LEN(J142)-FIND(\"|\",J142)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E144,(LEN(E144)-FIND(\"|\",E144)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J144,(LEN(J144)-FIND(\"|\",J144)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E146,(LEN(E146)-FIND(\"|\",E146)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J146,(LEN(J146)-FIND(\"|\",J146)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E148,(LEN(E148)-FIND(\"|\",E148)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J148,(LEN(J148)-FIND(\"|\",J148)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E150,(LEN(E150)-FIND(\"|\",E150)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J150,(LEN(J150)-FIND(\"|\",J150)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E152,(LEN(E152)-FIND(\"|\",E152)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J152,(LEN(J152)-FIND(\"|\",J152)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E154,(LEN(E154)-FIND(\"|\",E154)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J154,(LEN(J154)-FIND(\"|\",J154)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E156,(LEN(E156)-FIND(\"|\",E156)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J156,(LEN(J156)-FIND(\"|\",J156)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E158,(LEN(E158)-FIND(\"|\",E158)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J158,(LEN(J158)-FIND(\"|\",J158)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E160,(LEN(E160)-FIND(\"|\",E160)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J160,(LEN(J160)-FIND(\"|\",J160)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E162,(LEN(E162)-FIND(\"|\",E162)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J162,(LEN(J162)-FIND(\"|\",J162)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E164,(LEN(E164)-FIND(\"|\",E164)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J164,(LEN(J164)-FIND(\"|\",J164)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E166,(LEN(E166)-FIND(\"|\",E166)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J166,(LEN(J166)-FIND(\"|\",J166)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E168,(LEN(E168)-FIND(\"|\",E168)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J168,(LEN(J168)-FIND(\"|\",J168)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E170,(LEN(E170)-FIND(\"|\",E170)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J170,(LEN(J170)-FIND(\"|\",J170)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E172,(LEN(E172)-FIND(\"|\",E172)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J172,(LEN(J172)-FIND(\"|\",J172)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E174,(LEN(E174)-FIND(\"|\",E174)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J174,(LEN(J174)-FIND(\"|\",J174)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E176,(LEN(E176)-FIND(\"|\",E176)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J176,(LEN(J176)-FIND(\"|\",J176)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E178,(LEN(E178)-FIND(\"|\",E178)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J178,(LEN(J178)-FIND(\"|\",J178)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E180,(LEN(E180)-FIND(\"|\",E180)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J180,(LEN(J180)-FIND(\"|\",J180)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E182,(LEN(E182)-FIND(\"|\",E182)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J182,(LEN(J182)-FIND(\"|\",J182)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E184,(LEN(E184)-FIND(\"|\",E184)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J184,(LEN(J184)-FIND(\"|\",J184)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E186,(LEN(E186)-FIND(\"|\",E186)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J186,(LEN(J186)-FIND(\"|\",J186)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E188,(LEN(E188)-FIND(\"|\",E188)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J188,(LEN(J188)-FIND(\"|\",J188)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E190,(LEN(E190)-FIND(\"|\",E190)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J190,(LEN(J190)-FIND(\"|\",J190)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E192,(LEN(E192)-FIND(\"|\",E192)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J192,(LEN(J192)-FIND(\"|\",J192)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E194,(LEN(E194)-FIND(\"|\",E194)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J194,(LEN(J194)-FIND(\"|\",J194)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E196,(LEN(E196)-FIND(\"|\",E196)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J196,(LEN(J196)-FIND(\"|\",J196)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E198,(LEN(E198)-FIND(\"|\",E198)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J198,(LEN(J198)-FIND(\"|\",J198)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E200,(LEN(E200)-FIND(\"|\",E200)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J200,(LEN(J200)-FIND(\"|\",J200)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E202,(LEN(E202)-FIND(\"|\",E202)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J202,(LEN(J202)-FIND(\"|\",J202)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E204,(LEN(E204)-FIND(\"|\",E204)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J204,(LEN(J204)-FIND(\"|\",J204)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E206,(LEN(E206)-FIND(\"|\",E206)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J206,(LEN(J206)-FIND(\"|\",J206)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E208,(LEN(E208)-FIND(\"|\",E208)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J208,(LEN(J208)-FIND(\"|\",J208)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E210,(LEN(E210)-FIND(\"|\",E210)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J210,(LEN(J210)-FIND(\"|\",J210)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E212,(LEN(E212)-FIND(\"|\",E212)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J212,(LEN(J212)-FIND(\"|\",J212)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E214,(LEN(E214)-FIND(\"|\",E214)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J214,(LEN(J214)-FIND(\"|\",J214)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E216,(LEN(E216)-FIND(\"|\",E216)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J216,(LEN(J216)-FIND(\"|\",J216)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E218,(LEN(E218)-FIND(\"|\",E218)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J218,(LEN(J218)-FIND(\"|\",J218)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E220,(LEN(E220)-FIND(\"|\",E220)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J220,(LEN(J220)-FIND(\"|\",J220)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E222,(LEN(E222)-FIND(\"|\",E222)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J222,(LEN(J222)-FIND(\"|\",J222)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E224,(LEN(E224)-FIND(\"|\",E224)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J224,(LEN(J224)-FIND(\"|\",J224)))","v":{"$error":"#VALUE!"}}]

{"sheet":"Total","index":5,"n_rows":224,"n_cols":15,"rows_kept":224,"cut":false,"hidden":false,"merged":[[0,6,0,8],[1,4,1,9],[2,4,2,9],[91,10,91,13],[73,10,73,13],[71,10,71,13],[86,12,86,13],[52,12,52,13],[48,12,48,13],[21,9,22,9],[75,10,75,13],[56,12,56,13],[72,12,72,13],[67,10,67,13],[74,12,74,13],[59,10,59,13],[62,12,62,13],[166,12,166,13],[103,10,103,13],[133,10,133,13],[111,10,111,13],[107,10,107,13],[120,12,120,13],[108,12,108,13],[152,12,152,13],[127,10,127,13],[114,12,114,13],[119,10,119,13],[126,12,126,13],[110,12,110,13],[129,10,129,13],[165,10,165,13],[135,10,135,13],[131,10,131,13],[128,12,128,13],[134,12,134,13],[132,12,132,13],[123,10,123,13],[124,12,124,13],[115,10,115,13],[116,12,116,13],[98,12,98,13],[117,10,117,13],[130,12,130,13],[112,12,112,13],[105,10,105,13],[106,12,106,13],[109,10,109,13],[77,10,77,13],[90,12,90,13],[70,12,70,13],[71,9,72,9],[69,9,70,9],[125,10,125,13],[121,10,121,13],[118,12,118,13],[122,12,122,13],[113,10,113,13],[93,10,93,13],[79,10,79,13],[79,9,80,9],[85,9,86,9],[93,9,94,9],[78,12,78,13],[95,9,96,9],[103,9,104,9],[94,12,94,13],[104,12,104,13],[99,10,99,13],[102,12,102,13],[101,10,101,13],[95,10,95,13],[84,12,84,13],[81,10,81,13],[111,9,112,9],[73,9,74,9],[82,12,82,13],[97,10,97,13],[96,12,96,13],[85,10,85,13],[100,12,100,13],[80,12,80,13],[125,6,125,8],[123,6,123,8],[85,4,86,4],[92,12,92,13],[83,10,83,13],[81,6,81,8],[81,4,82,4],[87,10,87,13],[88,12,88,13],[89,10,89,13],[117,6,117,8],[113,9,114,9],[115,9,116,9],[115,6,115,8],[117,9,118,9],[119,6,119,8],[89,9,90,9],[91,9,92,9],[101,9,102,9],[107,9,108,9],[97,9,98,9],[113,6,113,8],[99,6,99,8],[111,6,111,8],[105,9,106,9],[99,9,100,9],[83,6,83,8],[93,4,94,4],[139,4,140,4],[101,4,102,4],[103,4,104,4],[97,4,98,4],[127,4,128,4],[87,4,88,4],[91,4,92,4],[89,4,90,4],[107,4,108,4],[109,4,110,4],[95,4,96,4],[83,4,84,4],[135,4,136,4],[143,4,144,4],[87,6,87,8],[105,4,106,4],[97,6,97,8],[99,4,100,4],[93,6,93,8],[95,6,95,8],[103,6,103,8],[119,4,120,4],[163,4,164,4],[161,4,162,4],[159,4,160,4],[157,4,158,4],[155,4,156,4],[121,4,122,4],[137,4,138,4],[125,4,126,4],[141,3,152,3],[147,4,148,4],[151,4,152,4],[149,4,150,4],[145,4,146,4],[165,4,166,4],[117,3,128,3],[153,3,164,3],[141,4,142,4],[133,4,134,4],[117,4,118,4],[129,3,140,3],[129,4,130,4],[131,4,132,4],[153,4,154,4],[123,4,124,4],[175,4,176,4],[173,4,174,4],[177,3,188,3],[179,4,180,4],[177,4,178,4],[165,3,176,3],[181,4,182,4],[171,4,172,4],[169,4,170,4],[167,4,168,4],[189,3,200,3],[201,3,212,3],[207,4,208,4],[201,4,202,4],[205,4,206,4],[209,4,210,4],[211,4,212,4],[191,4,192,4],[211,6,211,8],[209,6,209,8],[199,4,200,4],[195,4,196,4],[201,6,201,8],[199,6,199,8],[197,4,198,4],[207,6,207,8],[197,6,197,8],[203,4,204,4],[215,6,215,8],[219,6,219,8],[219,10,219,13],[218,12,218,13],[217,10,217,13],[219,9,220,9],[215,10,215,13],[220,12,220,13],[213,3,224,3],[213,4,214,4],[215,4,216,4],[222,12,222,13],[221,9,222,9],[221,10,221,13],[216,12,216,13],[215,9,216,9],[219,4,220,4],[223,10,223,13],[221,6,221,8],[223,6,223,8],[221,4,222,4],[217,9,218,9],[217,6,217,8],[223,4,224,4],[217,4,218,4],[212,12,212,13],[214,12,214,13],[213,10,213,13],[210,12,210,13],[224,12,224,13],[223,9,224,9],[200,12,200,13],[199,9,200,9],[201,10,201,13],[201,9,202,9],[202,12,202,13],[199,10,199,13],[211,9,212,9],[209,9,210,9],[207,9,208,9],[209,10,209,13],[203,10,203,13],[204,12,204,13],[205,10,205,13],[205,9,206,9],[211,10,211,13],[208,12,208,13],[193,4,194,4],[193,9,194,9],[193,10,193,13],[213,6,213,8],[213,9,214,9],[205,6,205,8],[203,6,203,8],[207,10,207,13],[206,12,206,13],[203,9,204,9],[197,9,198,9],[197,10,197,13],[198,12,198,13],[195,9,196,9],[195,10,195,13],[195,6,195,8],[193,6,193,8],[192,12,192,13],[188,12,188,13],[189,4,190,4],[189,9,190,9],[196,12,196,13],[187,4,188,4],[187,9,188,9],[187,10,187,13],[187,6,187,8],[186,12,186,13],[185,10,185,13],[183,9,184,9],[191,9,192,9],[191,10,191,13],[191,6,191,8],[190,12,190,13],[189,6,189,8],[189,10,189,13],[174,12,174,13],[176,12,176,13],[183,4,184,4],[184,12,184,13],[194,12,194,13],[185,6,185,8],[185,4,186,4],[183,6,183,8],[183,10,183,13],[185,9,186,9],[179,9,180,9],[181,9,182,9],[171,9,172,9],[180,12,180,13],[169,10,169,13],[170,12,170,13],[172,12,172,13],[171,10,171,13],[175,10,175,13],[173,10,173,13],[169,6,169,8],[173,9,174,9],[173,6,173,8],[182,12,182,13],[181,10,181,13],[167,6,167,8],[167,9,168,9],[167,10,167,13],[168,12,168,13],[177,9,178,9],[165,6,165,8],[161,9,162,9],[161,6,161,8],[177,6,177,8],[175,6,175,8],[178,12,178,13],[177,10,177,13],[171,6,171,8],[175,9,176,9],[169,9,170,9],[160,12,160,13],[159,10,159,13],[155,9,156,9],[156,12,156,13],[157,10,157,13],[181,6,181,8],[179,6,179,8],[179,10,179,13],[161,10,161,13],[165,9,166,9],[151,10,151,13],[164,12,164,13],[163,6,163,8],[163,10,163,13],[159,6,159,8],[162,12,162,13],[153,10,153,13],[158,12,158,13],[155,10,155,13],[154,12,154,13],[153,6,153,8],[155,6,155,8],[163,9,164,9],[151,9,152,9],[159,9,160,9],[157,9,158,9],[157,6,157,8],[153,9,154,9],[150,12,150,13],[148,12,148,13],[144,12,144,13],[145,10,145,13],[149,10,149,13],[141,10,141,13],[143,10,143,13],[147,10,147,13],[146,12,146,13],[138,12,138,13],[137,9,138,9],[140,12,140,13],[137,10,137,13],[136,12,136,13],[142,12,142,13],[139,10,139,13],[143,9,144,9],[149,6,149,8],[151,6,151,8],[145,9,146,9],[147,9,148,9],[145,6,145,8],[147,6,147,8],[149,9,150,9],[143,6,143,8],[121,6,121,8],[121,9,122,9],[133,9,134,9],[135,6,135,8],[127,9,128,9],[129,6,129,8],[131,9,132,9],[131,6,131,8],[125,9,126,9],[127,6,127,8],[141,6,141,8],[139,9,140,9],[139,6,139,8],[133,6,133,8],[141,9,142,9],[135,9,136,9],[137,6,137,8],[119,9,120,9],[123,9,124,9],[129,9,130,9],[69,3,80,3],[93,3,104,3],[115,4,116,4],[105,3,116,3],[111,4,112,4],[113,4,114,4],[87,9,88,9],[45,4,46,4],[57,4,58,4],[75,4,76,4],[49,4,50,4],[51,4,52,4],[47,4,48,4],[81,3,92,3],[79,4,80,4],[67,9,68,9],[77,9,78,9],[83,9,84,9],[69,4,70,4],[73,6,73,8],[81,9,82,9],[79,6,79,8],[85,6,85,8],[65,4,66,4],[77,4,78,4],[73,4,74,4],[63,4,64,4],[59,4,60,4],[61,4,62,4],[71,4,72,4],[67,4,68,4],[53,6,53,8],[51,6,51,8],[47,6,47,8],[49,6,49,8],[49,9,50,9],[53,4,54,4],[33,4,34,4],[31,4,32,4],[7,6,7,8],[9,6,9,8],[23,6,23,8],[15,6,15,8],[17,6,17,8],[25,4,26,4],[27,4,28,4],[25,6,25,8],[29,4,30,4],[43,6,43,8],[29,6,29,8],[37,4,38,4],[35,4,36,4],[39,4,40,4],[43,4,44,4],[13,4,14,4],[15,4,16,4],[11,4,12,4],[9,3,20,3],[21,4,22,4],[23,4,24,4],[57,6,57,8],[57,3,68,3],[63,6,63,8],[67,6,67,8],[45,6,45,8],[7,1,7,2],[8,1,8,2],[17,4,18,4],[19,4,20,4],[9,4,10,4],[21,3,32,3],[41,4,42,4],[109,9,110,9],[101,6,101,8],[91,6,91,8],[107,6,107,8],[109,6,109,8],[89,6,89,8],[105,6,105,8],[65,6,65,8],[59,6,59,8],[77,6,77,8],[75,6,75,8],[69,6,69,8],[71,6,71,8],[33,3,44,3],[61,6,61,8],[45,3,56,3],[55,4,56,4],[55,6,55,8],[7,10,7,13],[35,6,35,8],[33,6,33,8],[19,6,19,8],[10,12,10,13],[30,12,30,13],[11,6,11,8],[25,9,26,9],[23,9,24,9],[27,10,27,13],[39,9,40,9],[31,6,31,8],[29,9,30,9],[37,9,38,9],[35,9,36,9],[6,6,6,8],[11,9,12,9],[27,9,28,9],[40,12,40,13],[29,10,29,13],[32,12,32,13],[33,10,33,13],[34,12,34,13],[35,10,35,13],[39,10,39,13],[41,6,41,8],[13,6,13,8],[13,9,14,9],[21,6,21,8],[27,6,27,8],[15,9,16,9],[17,9,18,9],[37,6,37,8],[33,9,34,9],[39,6,39,8],[9,10,9,13],[19,9,20,9],[9,9,10,9],[11,10,11,13],[12,12,12,13],[16,12,16,13],[20,12,20,13],[13,10,13,13],[26,12,26,13],[41,9,42,9],[41,10,41,13],[24,12,24,13],[42,12,42,13],[31,10,31,13],[31,9,32,9],[38,12,38,13],[37,10,37,13],[36,12,36,13],[15,10,15,13],[6,10,6,13],[44,12,44,13],[21,10,21,13],[17,10,17,13],[19,10,19,13],[25,10,25,13],[23,10,23,13],[22,12,22,13],[28,12,28,13],[45,10,45,13],[46,12,46,13],[47,10,47,13],[54,12,54,13],[43,10,43,13],[0,15,1,16],[2,15,3,16],[8,12,8,13],[18,12,18,13],[14,12,14,13],[75,9,76,9],[53,10,53,13],[76,12,76,13],[65,10,65,13],[61,10,61,13],[69,10,69,13],[68,12,68,13],[65,9,66,9],[63,9,64,9],[63,10,63,13],[45,9,46,9],[43,9,44,9],[64,12,64,13],[58,12,58,13],[55,9,56,9],[55,10,55,13],[57,10,57,13],[60,12,60,13],[57,9,58,9],[51,9,52,9],[47,9,48,9],[53,9,54,9],[66,12,66,13],[51,10,51,13],[50,12,50,13],[59,9,60,9],[61,9,62,9],[49,10,49,13]]}
[null,"eLogic Model® ",null,null,null,null,"Total",null,null,null,null,null,null,null,"OMB Approval 2535-0114 exp. 08/31/2014"]
[null,null,null,"Applicant Legal Name",{"$f":"Coversheet!F21","v":"South Florida Regional Planning Council"}]
[null,null,null,"CCR Doing Business As Name",{"$f":"Coversheet!F22","v":0}]
[null,null,null,"HUD Program",{"$f":"Coversheet!F11","v":"Sustainable Communities Regional Planning Grants "},null,null,null,"Reporting Period"]
[null,null,null,"Program Component",null,null,null,null,"Reporting Start Date",null,"DUNS No.",{"$f":"Coversheet!F23","v":"072235286"},"­",{"$f":"Coversheet!H23","v":0}]
[null,null,null,"Project Name",{"$f":"Coversheet!F32","v":"South Florida Regional Partnership - Sustainable Communities Initiative"},null,null,null,"Reporting End Date",null,null,null,null,null,2011]
[null,"HUD Goals","Policy Priority","Needs","Services/Activities","Output Goal","Measures",null,null,"Outcomes","Measures",null,null,null,"Evaluation Tools"]
[null,1,null,2,3,4,4,null,null,5,6,null,null,null,7]
[null,"Policy",null,"Planning","Programming",null,"Pre","Post","YTD","Impact","Pre","Post","YTD",null,"Accountability"]
[null,null,null,"There is a need for multijurisdictional planning efforts that integrate housing, land use, economic and workforce development, transportation, and infrastructure investments to direct long-term development, reinvestment, and issues of regional significance.","Governance-Establish intergovernmental planning and cooperation mechanisms-Agreements Secured |Agreements Secured",null,{"$f":"RIGHT(E10,(LEN(E10)-FIND(\"|\",E10)))","v":"Agreements Secured"},null,null,"Governance-Nontraditional representatives incorporated into the Governance Board-Organizations |Organizations",{"$f":"RIGHT(J10,(LEN(J10)-FIND(\"|\",J10)))","v":"Organizations"}]
[null,"4E","2f",null,null,null,133,null,null,null,2,null,null,null,"A. Tools for Measurement"]
[null,null,null,null,null,null,{"$f":"RIGHT(E12,(LEN(E12)-FIND(\"|\",E12)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J12,(LEN(J12)-FIND(\"|\",J12)))","v":{"$error":"#VALUE!"}}]
[null,null,"2i"]
[null,null,null,null,"Governance-Establish intergovernmental planning and cooperation mechanisms-Jurisdictions Represented |Jurisdictions Represented",null,{"$f":"RIGHT(E14,(LEN(E14)-FIND(\"|\",E14)))","v":"Jurisdictions Represented"},null,null,"Governance-Nontraditional representatives incorporated into the Governance Board-Organizations |Organizations",{"$f":"RIGHT(J14,(LEN(J14)-FIND(\"|\",J14)))","v":"Organizations"}]
[null,null,"4b",null,null,null,42,null,null,null,2]
[null,null,null,null,null,null,{"$f":"RIGHT(E16,(LEN(E16)-FIND(\"|\",E16)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Private and non-federal funding secured and used as leverage to federal funds to support local planning efforts. |Dollars",{"$f":"RIGHT(J16,(LEN(J16)-FIND(\"|\",J16)))","v":"Dollars"}]
[null,null,"6a",null,null,null,null,null,null,null,500000,null,null,null,"B.  Where Data Maintained"]
[null,null,null,null,"Governance-Provide training to strengthen management and decision-making capacities of applicable partners-Training sessions |Training Sessions",null,{"$f":"RIGHT(E18,(LEN(E18)-FIND(\"|\",E18)))","v":"Training Sessions"},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J18,(LEN(J18)-FIND(\"|\",J18)))","v":"Persons"}]
[null,null,null,null,null,null,7,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E20,(LEN(E20)-FIND(\"|\",E20)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J20,(LEN(J20)-FIND(\"|\",J20)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for development of a strong governance structure to address costs and responsibilities for sustainable regional economic growth, development, and operation of associated shared services. ","Governance-Provide training to strengthen management and decision-making capacities of applicable partners-Persons Completing Training |Persons",null,{"$f":"RIGHT(E22,(LEN(E22)-FIND(\"|\",E22)))","v":"Persons"},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J22,(LEN(J22)-FIND(\"|\",J22)))","v":"Persons"}]
[null,null,null,null,null,null,50,null,null,null,100,null,null,null,"C.  Source of Data"]
[null,null,null,null,null,null,{"$f":"RIGHT(E24,(LEN(E24)-FIND(\"|\",E24)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J24,(LEN(J24)-FIND(\"|\",J24)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Outreach-Citizen/Resident Participation-Resident participation in plan development and governance-Number of Persons on Planning Committees |Persons",null,{"$f":"RIGHT(E26,(LEN(E26)-FIND(\"|\",E26)))","v":"Persons"},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J26,(LEN(J26)-FIND(\"|\",J26)))","v":"Persons"}]
[null,null,null,null,null,null,50,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E28,(LEN(E28)-FIND(\"|\",E28)))","v":{"$error":"#VALUE!"}},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J28,(LEN(J28)-FIND(\"|\",J28)))","v":"Persons"}]
[null,null,null,null,null,null,null,null,null,null,100,null,null,null,"D. Frequency of Collection"]
[null,null,null,null,"Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-Agencies Contacted |Agencies Contacted",null,{"$f":"RIGHT(E30,(LEN(E30)-FIND(\"|\",E30)))","v":"Agencies Contacted"},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J30,(LEN(J30)-FIND(\"|\",J30)))","v":"Persons"}]
[null,null,null,null,null,null,100,null,null,null,100]
[null,null,null,null,"Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-New Entities Joining |New Entities Joining",null,{"$f":"RIGHT(E32,(LEN(E32)-FIND(\"|\",E32)))","v":"New Entities Joining"},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J32,(LEN(J32)-FIND(\"|\",J32)))","v":"Persons"}]
[null,null,null,null,null,null,50,null,null,null,100]
[null,null,null,"There is a need for public engagement which includes populations typically marginalized from the public planning processes and creates opportunities for meaningful decision making leading to adoption of a shared regional vision.",null,null,{"$f":"RIGHT(E34,(LEN(E34)-FIND(\"|\",E34)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J34,(LEN(J34)-FIND(\"|\",J34)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.  Processing of Data"]
[null,null,null,null,"Regional Planning-Review existing long-range community, local, and regional plans  |Date Completed",null,{"$f":"RIGHT(E36,(LEN(E36)-FIND(\"|\",E36)))","v":"Date Completed"},null,null,"new- Completion of Data analyses/studies |Date Completed",{"$f":"RIGHT(J36,(LEN(J36)-FIND(\"|\",J36)))","v":"Date Completed"}]
[null,null,null,null,null,null,"2011-12-01",null,null,null,"2012-12-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E38,(LEN(E38)-FIND(\"|\",E38)))","v":{"$error":"#VALUE!"}},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J38,(LEN(J38)-FIND(\"|\",J38)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E40,(LEN(E40)-FIND(\"|\",E40)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J40,(LEN(J40)-FIND(\"|\",J40)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E42,(LEN(E42)-FIND(\"|\",E42)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J42,(LEN(J42)-FIND(\"|\",J42)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E44,(LEN(E44)-FIND(\"|\",E44)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J44,(LEN(J44)-FIND(\"|\",J44)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need to transform isolated, racially, and economically segregated areas into communities of opportunity that reduce social disparities so all have access to quality jobs, schools, affordable housing, transportation, and cultural and physical amenities.",null,null,{"$f":"RIGHT(E46,(LEN(E46)-FIND(\"|\",E46)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J46,(LEN(J46)-FIND(\"|\",J46)))","v":{"$error":"#VALUE!"}}]
[null,"4C","2a"]
[null,null,null,null,"Outreach-Education and training on sustainability-Number of outreach sessions held |Sessions",null,{"$f":"RIGHT(E48,(LEN(E48)-FIND(\"|\",E48)))","v":"Sessions"},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J48,(LEN(J48)-FIND(\"|\",J48)))","v":"Persons"}]
[null,null,"2b",null,null,null,7,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E50,(LEN(E50)-FIND(\"|\",E50)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J50,(LEN(J50)-FIND(\"|\",J50)))","v":{"$error":"#VALUE!"}}]
[null,null,"2f"]
[null,null,null,null,null,null,{"$f":"RIGHT(E52,(LEN(E52)-FIND(\"|\",E52)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J52,(LEN(J52)-FIND(\"|\",J52)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Outreach-Consult with area Public Housing Authorities |Agencies Contacted",null,{"$f":"RIGHT(E54,(LEN(E54)-FIND(\"|\",E54)))","v":"Agencies Contacted"},null,null,"Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons",{"$f":"RIGHT(J54,(LEN(J54)-FIND(\"|\",J54)))","v":"Persons"}]
[null,null,null,null,null,null,23,null,null,null,10]
[null,null,null,null,null,null,{"$f":"RIGHT(E56,(LEN(E56)-FIND(\"|\",E56)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J56,(LEN(J56)-FIND(\"|\",J56)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for public engagement which includes populations typically marginalized from the public planning processes and creates opportunities for meaningful decision making leading to adoption of a shared regional vision.","Outreach-Education and training on sustainability-Number of outreach sessions held |Sessions",null,{"$f":"RIGHT(E58,(LEN(E58)-FIND(\"|\",E58)))","v":"Sessions"},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J58,(LEN(J58)-FIND(\"|\",J58)))","v":"Persons"}]
[null,null,null,null,null,null,7,null,null,null,100]
[null,null,null,null,null,null,{"$f":"RIGHT(E60,(LEN(E60)-FIND(\"|\",E60)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J60,(LEN(J60)-FIND(\"|\",J60)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Outreach-Education and training on sustainability-Number of persons attending education or training sessions |Persons ",null,{"$f":"RIGHT(E62,(LEN(E62)-FIND(\"|\",E62)))","v":"Persons "},null,null,"Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons",{"$f":"RIGHT(J62,(LEN(J62)-FIND(\"|\",J62)))","v":"Persons"}]
[null,null,null,null,null,null,50,null,null,null,100]
[null,null,null,null,null,null,{"$f":"RIGHT(E64,(LEN(E64)-FIND(\"|\",E64)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J64,(LEN(J64)-FIND(\"|\",J64)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E66,(LEN(E66)-FIND(\"|\",E66)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J66,(LEN(J66)-FIND(\"|\",J66)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E68,(LEN(E68)-FIND(\"|\",E68)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J68,(LEN(J68)-FIND(\"|\",J68)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need to transform isolated, racially, and economically segregated areas into communities of opportunity that reduce social disparities so all have access to quality jobs, schools, affordable housing, transportation, and cultural and physical amenities.","Regional Planning-Conduct scenario planning-Economic Development-Participating jurisdictions |Participating Jurisdictions",null,{"$f":"RIGHT(E70,(LEN(E70)-FIND(\"|\",E70)))","v":"Participating Jurisdictions"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J70,(LEN(J70)-FIND(\"|\",J70)))","v":"Measures Amended/Added"}]
[null,"4A","1c",null,null,null,7,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E72,(LEN(E72)-FIND(\"|\",E72)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J72,(LEN(J72)-FIND(\"|\",J72)))","v":{"$error":"#VALUE!"}}]
[null,null,"4b"]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Economic Development |Scenarios  Developed",null,{"$f":"RIGHT(E74,(LEN(E74)-FIND(\"|\",E74)))","v":"Scenarios  Developed"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J74,(LEN(J74)-FIND(\"|\",J74)))","v":"Measures Amended/Added"}]
[null,null,"6a",null,null,null,3,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E76,(LEN(E76)-FIND(\"|\",E76)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J76,(LEN(J76)-FIND(\"|\",J76)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Affordable  Housing Opportunities |Scenarios  Developed",null,{"$f":"RIGHT(E78,(LEN(E78)-FIND(\"|\",E78)))","v":"Scenarios  Developed"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J78,(LEN(J78)-FIND(\"|\",J78)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,3,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E80,(LEN(E80)-FIND(\"|\",E80)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J80,(LEN(J80)-FIND(\"|\",J80)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for economic development activities focusing on reuse/expansion/creation of commercial/industrial centers that create jobs for residents of all income levels and create a strong regional economy. ","Regional Planning-Conduct scenario planning-Affordable Housing-Participating Jurisdictions |Participating Jurisdictions",null,{"$f":"RIGHT(E82,(LEN(E82)-FIND(\"|\",E82)))","v":"Participating Jurisdictions"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J82,(LEN(J82)-FIND(\"|\",J82)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,7,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E84,(LEN(E84)-FIND(\"|\",E84)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J84,(LEN(J84)-FIND(\"|\",J84)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Transportation-Participating Jurisdictions |Participating Jurisdictions",null,{"$f":"RIGHT(E86,(LEN(E86)-FIND(\"|\",E86)))","v":"Participating Jurisdictions"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J86,(LEN(J86)-FIND(\"|\",J86)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,7,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E88,(LEN(E88)-FIND(\"|\",E88)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J88,(LEN(J88)-FIND(\"|\",J88)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Conduct scenario planning-Transportation |Scenarios Developed",null,{"$f":"RIGHT(E90,(LEN(E90)-FIND(\"|\",E90)))","v":"Scenarios Developed"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J90,(LEN(J90)-FIND(\"|\",J90)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,3,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E92,(LEN(E92)-FIND(\"|\",E92)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J92,(LEN(J92)-FIND(\"|\",J92)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for multijurisdictional planning efforts that integrate housing, land use, economic and workforce development, transportation, and infrastructure investments to direct long-term development, reinvestment, and issues of regional significance.","Regional Planning-Perform technical planning studies |Date Completed",null,{"$f":"RIGHT(E94,(LEN(E94)-FIND(\"|\",E94)))","v":"Date Completed"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J94,(LEN(J94)-FIND(\"|\",J94)))","v":"Measures Amended/Added"}]
[null,null,null,null,null,null,"2014-02-01",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E96,(LEN(E96)-FIND(\"|\",E96)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J96,(LEN(J96)-FIND(\"|\",J96)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Regional Planning-Develop a Comprehensive Regional Plan for Sustainable Development-Plan completed |Date Completed",null,{"$f":"RIGHT(E98,(LEN(E98)-FIND(\"|\",E98)))","v":"Date Completed"},null,null,"Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added",{"$f":"RIGHT(J98,(LEN(J98)-FIND(\"|\",J98)))","v":"Measures Amended/Added"}]
[null,"4E","2f",null,null,null,"2014-02-01",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E100,(LEN(E100)-FIND(\"|\",E100)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Private and non-federal funding secured and used as leverage to federal funds to support local planning efforts. |Dollars",{"$f":"RIGHT(J100,(LEN(J100)-FIND(\"|\",J100)))","v":"Dollars"}]
[null,null,"2i",null,null,null,null,null,null,null,500000]
[null,null,null,null,null,null,{"$f":"RIGHT(E102,(LEN(E102)-FIND(\"|\",E102)))","v":{"$error":"#VALUE!"}},null,null,"Governance-Private and non-federal funding secured and used as leverage to federal funds to support the integration of local plans into a comprehensive regional plan |Dollars",{"$f":"RIGHT(J102,(LEN(J102)-FIND(\"|\",J102)))","v":"Dollars"}]
[null,null,"6a",null,null,null,null,null,null,null,500000]
[null,null,null,null,null,null,{"$f":"RIGHT(E104,(LEN(E104)-FIND(\"|\",E104)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J104,(LEN(J104)-FIND(\"|\",J104)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E106,(LEN(E106)-FIND(\"|\",E106)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J106,(LEN(J106)-FIND(\"|\",J106)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E108,(LEN(E108)-FIND(\"|\",E108)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J108,(LEN(J108)-FIND(\"|\",J108)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E110,(LEN(E110)-FIND(\"|\",E110)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J110,(LEN(J110)-FIND(\"|\",J110)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F14","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E112,(LEN(E112)-FIND(\"|\",E112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J112,(LEN(J112)-FIND(\"|\",J112)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F16","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E114,(LEN(E114)-FIND(\"|\",E114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J114,(LEN(J114)-FIND(\"|\",J114)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Coversheet!F18","v":0}]
[null,null,null,null,null,null,{"$f":"RIGHT(E116,(LEN(E116)-FIND(\"|\",E116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J116,(LEN(J116)-FIND(\"|\",J116)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Coversheet!F19","v":0}]
[]
[null,null,null,"There is a need for integrated environmental planning for air, water, and land use to  ensure healthy environments and to avoid adverse environmental impacts. ","Environment-Develop strategies for integrating air, water and land use to ensure a healthy living environment and avoiding adverse environmental impacts |Strategies",null,{"$f":"RIGHT(E118,(LEN(E118)-FIND(\"|\",E118)))","v":"Strategies"},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions",{"$f":"RIGHT(J118,(LEN(J118)-FIND(\"|\",J118)))","v":"Jurisdictions"}]
[null,"4B","6a",null,null,null,1,null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E120,(LEN(E120)-FIND(\"|\",E120)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date",{"$f":"RIGHT(J120,(LEN(J120)-FIND(\"|\",J120)))","v":"Date"}]
[null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E122,(LEN(E122)-FIND(\"|\",E122)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J122,(LEN(J122)-FIND(\"|\",J122)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E124,(LEN(E124)-FIND(\"|\",E124)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J124,(LEN(J124)-FIND(\"|\",J124)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E126,(LEN(E126)-FIND(\"|\",E126)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J126,(LEN(J126)-FIND(\"|\",J126)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E128,(LEN(E128)-FIND(\"|\",E128)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J128,(LEN(J128)-FIND(\"|\",J128)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"There is a need for pro-active short- and long-term urban design strategies that consider risks from disasters and climate change while harmonizing land use for sustainable development/conservation/transportation and water infrastructure.  ","Environment-Conduct analysis to develop meaningful climate adaptation strategies and define adaption actions |Date Completed",null,{"$f":"RIGHT(E130,(LEN(E130)-FIND(\"|\",E130)))","v":"Date Completed"},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions",{"$f":"RIGHT(J130,(LEN(J130)-FIND(\"|\",J130)))","v":"Jurisdictions"}]
[null,"4D","2h",null,null,null,"2014-02-01",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E132,(LEN(E132)-FIND(\"|\",E132)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date",{"$f":"RIGHT(J132,(LEN(J132)-FIND(\"|\",J132)))","v":"Date"}]
[null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E134,(LEN(E134)-FIND(\"|\",E134)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J134,(LEN(J134)-FIND(\"|\",J134)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Environment-Develop meaningful climate adaptation plan |Date Completed",null,{"$f":"RIGHT(E136,(LEN(E136)-FIND(\"|\",E136)))","v":"Date Completed"},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions",{"$f":"RIGHT(J136,(LEN(J136)-FIND(\"|\",J136)))","v":"Jurisdictions"}]
[null,null,null,null,null,null,"2014-02-01",null,null,null,7]
[null,null,null,null,null,null,{"$f":"RIGHT(E138,(LEN(E138)-FIND(\"|\",E138)))","v":{"$error":"#VALUE!"}},null,null,"Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date",{"$f":"RIGHT(J138,(LEN(J138)-FIND(\"|\",J138)))","v":"Date"}]
[null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,{"$f":"RIGHT(E140,(LEN(E140)-FIND(\"|\",E140)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J140,(LEN(J140)-FIND(\"|\",J140)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E142,(LEN(E142)-FIND(\"|\",E142)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J142,(LEN(J142)-FIND(\"|\",J142)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E144,(LEN(E144)-FIND(\"|\",E144)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J144,(LEN(J144)-FIND(\"|\",J144)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E146,(LEN(E146)-FIND(\"|\",E146)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J146,(LEN(J146)-FIND(\"|\",J146)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E148,(LEN(E148)-FIND(\"|\",E148)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J148,(LEN(J148)-FIND(\"|\",J148)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E150,(LEN(E150)-FIND(\"|\",E150)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J150,(LEN(J150)-FIND(\"|\",J150)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E152,(LEN(E152)-FIND(\"|\",E152)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J152,(LEN(J152)-FIND(\"|\",J152)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E154,(LEN(E154)-FIND(\"|\",E154)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J154,(LEN(J154)-FIND(\"|\",J154)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E156,(LEN(E156)-FIND(\"|\",E156)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J156,(LEN(J156)-FIND(\"|\",J156)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E158,(LEN(E158)-FIND(\"|\",E158)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J158,(LEN(J158)-FIND(\"|\",J158)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E160,(LEN(E160)-FIND(\"|\",E160)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J160,(LEN(J160)-FIND(\"|\",J160)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E162,(LEN(E162)-FIND(\"|\",E162)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J162,(LEN(J162)-FIND(\"|\",J162)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E164,(LEN(E164)-FIND(\"|\",E164)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J164,(LEN(J164)-FIND(\"|\",J164)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E166,(LEN(E166)-FIND(\"|\",E166)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J166,(LEN(J166)-FIND(\"|\",J166)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E168,(LEN(E168)-FIND(\"|\",E168)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J168,(LEN(J168)-FIND(\"|\",J168)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E170,(LEN(E170)-FIND(\"|\",E170)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J170,(LEN(J170)-FIND(\"|\",J170)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E172,(LEN(E172)-FIND(\"|\",E172)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J172,(LEN(J172)-FIND(\"|\",J172)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E174,(LEN(E174)-FIND(\"|\",E174)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J174,(LEN(J174)-FIND(\"|\",J174)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E176,(LEN(E176)-FIND(\"|\",E176)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J176,(LEN(J176)-FIND(\"|\",J176)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E178,(LEN(E178)-FIND(\"|\",E178)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J178,(LEN(J178)-FIND(\"|\",J178)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E180,(LEN(E180)-FIND(\"|\",E180)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J180,(LEN(J180)-FIND(\"|\",J180)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E182,(LEN(E182)-FIND(\"|\",E182)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J182,(LEN(J182)-FIND(\"|\",J182)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E184,(LEN(E184)-FIND(\"|\",E184)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J184,(LEN(J184)-FIND(\"|\",J184)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E186,(LEN(E186)-FIND(\"|\",E186)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J186,(LEN(J186)-FIND(\"|\",J186)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E188,(LEN(E188)-FIND(\"|\",E188)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J188,(LEN(J188)-FIND(\"|\",J188)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E190,(LEN(E190)-FIND(\"|\",E190)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J190,(LEN(J190)-FIND(\"|\",J190)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E192,(LEN(E192)-FIND(\"|\",E192)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J192,(LEN(J192)-FIND(\"|\",J192)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E194,(LEN(E194)-FIND(\"|\",E194)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J194,(LEN(J194)-FIND(\"|\",J194)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E196,(LEN(E196)-FIND(\"|\",E196)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J196,(LEN(J196)-FIND(\"|\",J196)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E198,(LEN(E198)-FIND(\"|\",E198)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J198,(LEN(J198)-FIND(\"|\",J198)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E200,(LEN(E200)-FIND(\"|\",E200)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J200,(LEN(J200)-FIND(\"|\",J200)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E202,(LEN(E202)-FIND(\"|\",E202)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J202,(LEN(J202)-FIND(\"|\",J202)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E204,(LEN(E204)-FIND(\"|\",E204)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J204,(LEN(J204)-FIND(\"|\",J204)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E206,(LEN(E206)-FIND(\"|\",E206)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J206,(LEN(J206)-FIND(\"|\",J206)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E208,(LEN(E208)-FIND(\"|\",E208)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J208,(LEN(J208)-FIND(\"|\",J208)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E210,(LEN(E210)-FIND(\"|\",E210)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J210,(LEN(J210)-FIND(\"|\",J210)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E212,(LEN(E212)-FIND(\"|\",E212)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J212,(LEN(J212)-FIND(\"|\",J212)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E214,(LEN(E214)-FIND(\"|\",E214)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J214,(LEN(J214)-FIND(\"|\",J214)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E216,(LEN(E216)-FIND(\"|\",E216)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J216,(LEN(J216)-FIND(\"|\",J216)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E218,(LEN(E218)-FIND(\"|\",E218)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J218,(LEN(J218)-FIND(\"|\",J218)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E220,(LEN(E220)-FIND(\"|\",E220)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J220,(LEN(J220)-FIND(\"|\",J220)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E222,(LEN(E222)-FIND(\"|\",E222)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J222,(LEN(J222)-FIND(\"|\",J222)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,{"$f":"RIGHT(E224,(LEN(E224)-FIND(\"|\",E224)))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"RIGHT(J224,(LEN(J224)-FIND(\"|\",J224)))","v":{"$error":"#VALUE!"}}]

{"sheet":"GoalsPriorities","index":6,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,25,2]]}
[null,"HUD Goals",null,null,"HUD Priorities"]
["1A","Strengthen the Nation’s Housing Market to Bolster the Economy and Protect Consumers (1A) Stem the foreclosure crisis.",null,"1a","Job Creation/Employment (1a) Improving access to job opportunities through information sharing, coordination with federal, state, and local entities, and other means."]
["1B","Strengthen the Nation’s Housing Market to Bolster the Economy and Protect Consumer (1B) Protect and educate consumers when they buy, refinance or rent a home.",null,"1b","Job Creation/Employment (1b) Increasing access to job training, career services, and work, supports through coordination with federal, state, and local entities."]
["1C","Strengthen the Nation’s Housing Market to Bolster the Economy and Protect Consumers (1C) Create financially sustainable homeownership opportunities.",null,"1c","Job Creation/Employment (1c) Expanding economic and job creation opportunities for low-income residents and creating better transportation access to those jobs and other economic opportunities by partnering with federal and nonprofit agencies, private industry, and planning and economic development organizations and by leveraging federal and private resources."]
["1D","Strengthen the Nation’s Housing Market to Bolster the Economy and Protect Consumers (1D) Establish an accountable and sustainable housing finance system.",null,"2a","Sustainability (2a) Promote and preserve community assets including small businesses, fresh food markets, parks, hospitals, and quality schools by incentivizing comprehensive and inclusive local economic development planning."]
["2A","Meet the Need for Quality Affordable Rental Homes (2A) End homelessness and substantially reduce the number of families and individuals with severe housing needs.",null,"2b","Sustainability (2b) Give consumers more information about the true cost of living by incorporating both housing and transportation costs into measures of affordability."]
["2B","Meet the Need for Quality Affordable Rental Homes (2B) Expand the supply of affordable rental homes where most needed.",null,"2c","Sustainability (2c) Improve residents’ health and safety, particularly that of children and other vulnerable populations, by promoting green and healthy design, construction, rehabilitation, and maintenance of housing and communities."]
["2C","Meet the Need for Quality Affordable Rental Homes (2C) Preserve the affordability and improve the quality of federally assisted and private unassisted affordable rental homes.",null,"2d","Sustainability (2d) Support and promote an energy-efficient, green, and healthy housing market by retrofitting existing housing, supporting energy-efficient new construction, improving home energy labeling, and promoting financing products that reduce the carbon footprint of non-HUD-supported residential buildings."]
["2D","Meet the Need for Quality Affordable Rental Homes (2D) Expand families' choices of affordable rental homes located in a broad range of communities.",null,"2e","Sustainability (2e) Reduce energy consumption and incorporate green building practices in the design and operation of HUD-supported affordable housing."]
["3A","Utilize Housing as a Platform for Improving Quality of Life (3A) Utilize HUD assistance to improve educational outcomes and early learning and development.",null,"2f","Sustainability (2f) Promote coordinated planning, integrating federal resources, and targeting technical assistance at the local, state, and regional levels for sustainable housing and communities."]
["3B","Utilize Housing as a Platform for Improving Quality of Life (3B) Utilize HUD assistance to improve health outcomes.",null,"2g","Sustainability (2g) Promote the design and construction of buildings and communities that are accessible and visitable by people with disabilities."]
["3C","Utilize Housing as a Platform for Improving Quality of Life (3C) Utilize HUD assistance to increase economic security and self-sufficiency.",null,"2h","Sustainability (2h) Promote the use of climate-resilient and disaster-resistant building design, construction and siting."]
["3D","Utilize Housing as a Platform for Improving Quality of Life (3D) Utilize HUD assistance to improve housing stability through supportive services for vulnerable populations including the elderly, people with disabilities, homeless people, and those individuals and families at risk of becoming homeless.",null,"2i","Sustainability (2i) Encourage metropolitan and regional focus in planning and community development."]
["3E","Utilize Housing as a Platform for Improving Quality of Life (3E) Utilize HUD assistance to improve public safety.",null,"3a","Affirmatively Furthering Fair Housing (3a) Regional coordination of affirmatively furthering fair housing plans, including such activities as developing regional analyses of impediments."]
["4A","Build Inclusive and Sustainable Communities Free from Discrimination (4A) Catalyze economic development and job creation, while enhancing and preserving community assets.",null,"3b","Affirmatively Furthering Fair Housing (3b) Regional strategies to reduce racially segregated living patterns and other effects of formely de jure segregated public or assisted housing in metropolitan areas with a year 2000 dissimilarity index of 70 or higher and where the minority population is at least 20,000 or 3 percent of the total population in the Core Based Statistical Area (CBSA), whichever is greater."]
["4B","Build Inclusive and Sustainable Communities Free from Discrimination (4B) Promote energy efficient buildings and location efficient communities that are healthy, affordable and diverse.",null,"3c","Affirmatively Furthering Fair Housing (3c) Decreasing the concentration of poverty and racial segregation in neighborhoods and communities through strategic targeting of resources."]
["4C","Build Inclusive and Sustainable Communities Free from Discrimination (4C) Ensure open, diverse, and equitable communities.",null,"3d","Affirmatively Furthering Fair Housing (3d) Promoting visitability for persons with disabilities in single-family housing."]
["4D","Build Inclusive and Sustainable Communities Free from Discrimination (4D) Facilitate disaster preparedness, recovery and resiliency.",null,"4a","Capacity Building and Knowledge Sharing (4a) Develop, target and deliver technical assistance for increasing affordability in areas experiencing increased rental costs due to development."]
["4E","Build Inclusive and Sustainable Communities Free from Discrimination (4E) Build the capacity of local, state and regional public and private organizations.",null,"4b","Capacity Building and Knowledge Sharing (4b) Strengthen the capacity of state and local partners, including governments and nonprofit organizations, to implement HUD programs, participate in decision making and planning processes, and coordinate on cross-programmatic, place-based approaches through grantmaking and technical assistance."]
["5A","Transform the Way HUD Does Business (5A) Build Capacity: Create a flexible and high performing learning organization with a motivated, skilled workforce.",null,"4c","Capacity Building and Knowledge Sharing (4c) Support knowledge sharing and innovation by disseminating best practices, encouraging peer learning, publishing data analysis and research, and helping to incubate and test new ideas."]
["5B","Transform the Way HUD Does Business (5B) Focus on Results: Create an empowered organization that is customer-centered, place based, collaborative, and responsive to employee feedback and focused on results.",null,"5a","Using Housing as a Platform for Improving Other Outcomes (5a) Increasing access to high quality early learning programs and services through coordination with local programs."]
["5C","Transform the Way HUD Does Business (5C) Bureaucracy Busting: Create flexible, modern rules and systems that promote responsiveness, openness and transparency.",null,"5b","Using Housing as a Platform for Improving Other Outcomes (5b) Providing physical space to co-locate healthcare and wellness services with housing (e.g., on-site health clinics)."]
["5D","Transform the Way HUD Does Business (5D) Culture Change: Create a healthy, open, flexible work environment that reflects the values of HUD’s mission.",null,"5c","Using Housing as a Platform for Improving Other Outcomes (5c) Increasing access to public benefits (such as Temporary Assistance to Needy Families and Supplemental Security Income) through outreach and other means."]
[null,null,null,"5d","Using Housing as a Platform for Improving Other Outcomes (5d) Maintaining or improving the physical environment and design of HUD-assisted residences, giving attention to physical safety and crime prevention."]
[null,null,null,"5e","Using Housing as a Platform for Improving Other Outcomes (5e) Providing mobility counseling to increase access to neighborhoods of opportunity."]
[null,null,null,"6a","Expand Cross-Cutting Policy Knowledge (6a) Support knowledge sharing and innovation by disseminating best practices, encouraging peer learning, publishing data analysis and research, and helping to incubate and test new ideas."]

{"sheet":"Needs","index":7,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["                                        CAMP eLogic  Model®"]
["Column 2"]
["NEEDS"]
["There is a need for multijurisdictional planning efforts that integrate housing, land use, economic and workforce development, transportation, and infrastructure investments to direct long-term development, reinvestment, and issues of regional significance."]
["There is a need to transform isolated, racially, and economically segregated areas into communities of opportunity that reduce social disparities so all have access to quality jobs, schools, affordable housing, transportation, and cultural and physical amenities."]
["There is a need to create a full range of housing that is affordable to all income ranges throughout the region, which is connected to high-functioning transportation networks and accessible to persons with disabilities."]
["There is a need to affirmatively create housing opportunities throughout the area without discrimination due to race, color, national origin, sex, religion, disability, or familial status, while eliminating the effects of discriminatory housing patterns. "]
["There is a need for public engagement which includes populations typically marginalized from the public planning processes and creates opportunities for meaningful decision making leading to adoption of a shared regional vision."]
["There is a need for transportation networks that expand mode choices, address infrastructure investments, reduce particulate emissions, improve service for historically marginalized populations, and minimize residential and small business displacement.  "]
["There is a need for economic development activities focusing on reuse/expansion/creation of commercial/industrial centers that create jobs for residents of all income levels and create a strong regional economy. "]
["There is a need for pro-active short- and long-term urban design strategies that consider risks from disasters and climate change while harmonizing land use for sustainable development/conservation/transportation and water infrastructure.  "]
["There is a need for comprehensive planning to avoid adverse environmental impacts on neighborhoods and redress persistent environmental justice concerns in communities."]
["There is a need for development of a strong governance structure to address costs and responsibilities for sustainable regional economic growth, development, and operation of associated shared services. "]
["There is a need for improved educational and job training opportunities to prepare the workforce of the future and attract industry looking for a qualified workforce."]
["There is a need to improve public safety, cultural opportunities, and access to health care and to living environments that provide opportunities for healthy living and support healthy lifestyles by meeting the needs of existing residents and attracting multicultural, economically diverse, and multi-ethnic populations for a diverse living environment."]
["There is a need for integrated environmental planning for air, water, and land use to  ensure healthy environments and to avoid adverse environmental impacts. "]
["There is a need for transportation planning that provides for coordination of transportation planning  with economic development and housing plans."]

{"sheet":"Services","index":8,"n_rows":92,"n_cols":2,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["                                         CAMP eLogic  Model®","Click here to allow deletion of 'New' Activities"]
["Column 3"]
["SERVICES/ACTIVITIES","UNITS"]
["Affirmatively Furthering Fair Housing-Develop regional analysis of impediments to fair housing |Date Completed","Date Completed"]
["Affirmatively Furthering Fair Housing-Develop regional analysis of impediments to fair housing-Jurisdictions participating in Analysis of Impediments-Jurisdictions Participating |Jurisdictions Participating ","Jurisdictions Participating "]
["Affirmatively Furthering Fair Housing-Develop regional analysis of impediments to fair housing-Jurisdictions participating in Analysis of Impediments-Adoption of Analysis of Impediments |Jurisdictions Adopting ","Jurisdictions Adopting "]
["Affirmatively Furthering Fair Housing-Implement strategies to eliminate the effects of discriminatory housing patterns-Number of jurisdictions participating in regional Analysis of Impediments implementation |Jurisdictions Implementing ","Jurisdictions Implementing "]
["Affirmatively Furthering Fair Housing-Resources committed to strategies to eliminate the effects of discriminatory housing patterns-Planned Dollars |Dollars","Dollars"]
["Cultural Environment-Development of strategies to build upon the cultural assets of the regional planning area |Strategies ","Strategies "]
["Cultural Environment-Seek investment dollars in support of strategies that build upon cultural assets-Federal funding dollars |Dollars","Dollars"]
["Cultural Environment-Seek investment dollars in support of strategies that build upon cultural assets-Non-federal funding dollars |Dollars","Dollars"]
["Economic Development-Business Opportunities-Other-Businesses |Businesses","Businesses"]
["Economic Development-Business Opportunities-Other-Dollars |Dollars","Dollars"]
["Economic Development-Business Opportunities-Section 3-Businesses |Businesses","Businesses"]
["Economic Development-Business Opportunities-Section 3-Dollars |Dollars","Dollars"]
["Economic Development-Number of low-and moderate-income persons that completed workforce development training |Persons ","Persons "]
["Economic Development-Reinvest in existing commercial and industrial centers-Number of sites |Sites ","Sites "]
["Environment-Conduct analysis to develop meaningful climate adaptation strategies and define adaption actions |Date Completed","Date Completed"]
["Environment-Develop strategies for integrating air, water and land use to ensure a healthy living environment and avoiding adverse environmental impacts |Strategies","Strategies"]
["Environment-Develop meaningful climate adaptation plan |Date Completed","Date Completed"]
["Environment-Develop strategies to address environmental justice issues and avoid adverse environmental impacts-Strategies developed |Strategies Developed","Strategies Developed"]
["Environment-Develop strategies to address environmental justice issues and avoid adverse environmental impacts-Number of jurisdictions adopting strategies |Jurisdictions Adopting ","Jurisdictions Adopting "]
["Environment-Develop strategies to address environmental justice issues and avoid adverse environmental impact-Investments made to improve environments |Dollars","Dollars"]
["Environment-Identify and codify statutes or regulations necessary to implement climate adaption plan |Date Implemented","Date Implemented"]
["Environment-Protect land to preserve natural areas-Planned Square Feet |Square Feet","Square Feet"]
["Governance-Establish intergovernmental planning and cooperation mechanisms-Agreements Secured |Agreements Secured","Agreements Secured"]
["Governance-Establish intergovernmental planning and cooperation mechanisms-Jurisdictions Represented |Jurisdictions Represented","Jurisdictions Represented"]
["Governance-Establish intergovernmental planning and cooperation mechanisms-Funding Secured |Dollars","Dollars"]
["Governance-Establish intergovernmental planning and cooperation mechanisms-Establish private and non-federal funding agreements |Dollars","Dollars"]
["Governance-Provide training to strengthen management and decision-making capacities of applicable partners-Training sessions |Training Sessions","Training Sessions"]
["Governance-Provide training to strengthen management and decision-making capacities of applicable partners-Persons Completing Training |Persons","Persons"]
["Health-Conduct baseline spatial analysis of health status indicators by census tract for the region (e.g., cardiovascular disease mortality, obesity, homicide, violent crime, life expectancy, infant mortality, respiratory disease, and pedestrian injury) |Date Completed","Date Completed"]
["Health-Conduct baseline spatial assessment of health behavior indicators by census tract for the region (high priority indicators include: physical activity and fruit/vegetable consumption) |Date Completed","Date Completed"]
["Health-Include representative(s) from public health sector (e.g., state, county, or local health commissioner(s), environmental health specialist(s), or other designee(s)) on steering committee |Date Completed","Date Completed"]
["Health-Include representative(s) from public health sector (e.g., state, county, or local health commissioner(s), environmental health specialist(s), or other designee(s) in consortium and work group(s)) |Date Completed","Date Completed"]
["Health-Ongoing spatial assessment of health status indicators by census tract (e.g., cardiovascular disease mortality, obesity, violent crime rates, life expectancy, infant mortality, respiratory disease, and pedestrian injury) during implementation |Date Completed","Date Completed"]
["Investment-Align infrastructure investment for equitable land use planning-Budgeted  |Dollars","Dollars"]
["Investment-Projects in Adopted Regional Housing Plans initiated-Planned Number of Units |Units ","Units "]
["Investment-Projects in Adopted Regional Housing Plans Initiated-Planned Number of Projects |Projects","Projects"]
["Investment-Projects in Adopted Regional Plans initiated-Dollars Budgeted |Dollars","Dollars"]
["Investment-Projects in Adopted Regional Transportation Plans initiated-Dollars Budgeted |Dollars","Dollars"]
["Land Use-Analysis conducted for land acquisition and assembly for site specific projects-Number of Analyses Completed |Analyses Completed","Analyses Completed"]
["Land Use-Area of land assembled for site specific projects-Acres |Acres","Acres"]
["Land Use-Establish cultural facilities-Number of planned cultural facilities |Facilities Planned ","Facilities Planned "]
["Land Use-Land acquired for site specific projects-Acres |Acres ","Acres "]
["Land Use-Land acquired for site specific projects-Dollars |Dollars","Dollars"]
["Land Use-Land Banking-Land Banks established to hold property for future development or preservation areas-Acres |Acres","Acres"]
["Land Use-Land Banking-Creation of Land Bank Fund to purchase property for future development or preservation-Dollars |Dollars","Dollars"]
["Land Use-Land Banking-Creation of Land Bank Fund to purchase property for future development or preservation-Jurisdictions participating |Jurisdictions ","Jurisdictions "]
["Land Use-Land Banking-Projected number of new housing units along a corridor planning area  |Analyses Completed","Analyses Completed"]
["Land Use-Land Banking- Area of land assembled for site specific projects-Acres |Acres","Acres"]
["Land Use-Parcels of land assembled for site specific projects-Number of Parcels |Parcels","Parcels"]
["Land Use-Scenarios developed for land acquisition and assembly for site specific projects-Number of scenarios developed |Scenarios Developed","Scenarios Developed"]
["Land Use-Site specific planning and design of capital projects-Number of Site Plans Adopted |Site Plans","Site Plans"]
["Land Use-Site specific planning and design of capital projects-Planned Dollars Invested |Dollars","Dollars"]
["Land Use-Studies conducted  for development of corridor plans |Studies","Studies"]
["Land Use-Policies developed in support of spatial planning |Policies","Policies"]
["Land Use-Studies conducted supporting spatial development strategies |Studies ","Studies "]
["Land Use-Development of tools to measure and determine future development impacts. |Tools","Tools"]
["Land Use-Develop or amend land use regulations to streamline regulations-Number of jurisdictions  |Jurisdictions ","Jurisdictions "]
["Land Use-Develop or amend land use regulations to streamline regulations-Number of regulations  |Regulations","Regulations"]
["Land Use-Corridor Planning-Population in the planning area |Population","Population"]
["Land Use-Corridor Planning-Jurisdictions along the planning corridor |Jurisdictions","Jurisdictions"]
["Land Use-Corridor Planning-Transportation modes planned  |Modes","Modes"]
["Outreach-Citizen/Resident Participation-Resident participation in plan development and governance-Number of Persons on Planning Committees |Persons","Persons"]
["Outreach-Citizen/Resident Participation-Resident participation in plan development and governance-Number of Persons attending meetings |Persons","Persons"]
["Outreach-Citizen/Resident Participation-Resident participation in plan development and governance-Number of Public meetings held |Meetings Held","Meetings Held"]
["Outreach-Consult with area Public Housing Authorities |Agencies Contacted","Agencies Contacted"]
["Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-Agencies Contacted |Agencies Contacted","Agencies Contacted"]
["Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-New Entities Contacted |New Entities Contacted","New Entities Contacted"]
["Outreach-Outreach to expand consortium membership and participation including public authorities and special districts-New Entities Joining |New Entities Joining","New Entities Joining"]
["Outreach-Education and training on sustainability-Number of different types of training materials developed  |Training Materials","Training Materials"]
["Outreach-Education and training on sustainability-Number of outreach sessions held |Sessions","Sessions"]
["Outreach-Education and training on sustainability-Number of persons attending education or training sessions |Persons ","Persons "]
["Policy and Legislation-Preparation of administrative and regulatory measures to support Regional Sustainable Comprehensive Plans and Strategies-Number of measures |Measures","Measures"]
["Regional Planning-Adopt a regional sustainable housing plan |Date Completed","Date Completed"]
["Regional Planning-Adopt a regional sustainable housing plan-Increase the number of census tracts with increased housing choices |Census Tracts","Census Tracts"]
["Regional Planning-Adopt a regional sustainable housing plan-Net planned increase in units |Units Increased","Units Increased"]
["Regional Planning-Comprehensive Regional Plan for Sustainable Development-Plan adopted |Date Adopted","Date Adopted"]
["Regional Planning-Conduct scenario planning-Affordable  Housing Opportunities |Scenarios  Developed","Scenarios  Developed"]
["Regional Planning-Conduct scenario planning-Affordable Housing-Participating Jurisdictions |Participating Jurisdictions","Participating Jurisdictions"]
["Regional Planning-Conduct scenario planning-Economic Development |Scenarios  Developed","Scenarios  Developed"]
["Regional Planning-Conduct scenario planning-Economic Development-Participating jurisdictions |Participating Jurisdictions","Participating Jurisdictions"]
["Regional Planning-Conduct scenario planning-Transportation |Scenarios Developed","Scenarios Developed"]
["Regional Planning-Conduct scenario planning-Transportation-Participating Jurisdictions |Participating Jurisdictions","Participating Jurisdictions"]
["Regional Planning-Conduct scenario planning-Water Infrastructure |Scenarios  Developed","Scenarios  Developed"]
["Regional Planning-Conduct scenario planning-Water Infrastructure-Regional water infrastructure, wastewater needs, and long-term cost burdens-Dollars saved |Dollars","Dollars"]
["Regional Planning-Conduct scenario planning-Water infrastructure-Participating jurisdictions |Participating Jurisdictions","Participating Jurisdictions"]
["Regional Planning-Develop a Comprehensive Regional Plan for Sustainable Development-Plan completed |Date Completed","Date Completed"]
["Regional Planning-Perform technical planning studies |Date Completed","Date Completed"]
["Regional Planning-Review existing long-range community, local, and regional plans  |Date Completed","Date Completed"]
[" Other |Other","Other"]

{"sheet":"Outcomes","index":9,"n_rows":109,"n_cols":2,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["                                         CAMP eLogic  Model®","Click here to allow deletion of 'New' Outcomes"]
["Column 5"]
["OUTCOMES","UNITS"]
["Affirmatively Furthering Fair Housing-Change in the number of census tracts covered by inclusionary zoning |Census Tracts","Census Tracts"]
["new- Completion of Data analyses/studies |Date Completed","Date Completed"]
["Affirmatively Furthering Fair Housing-Decreased number of census tracts in the planning area with high concentrations of poverty and minority segregation-Average Percent Reduction Per Tract |Average % Reduction","Average % Reduction"]
["Affirmatively Furthering Fair Housing-Projected change in  number of census tracts with children enrolled in school lunch program-Number of census tracts |Census Tracts","Census Tracts"]
["Affirmatively Furthering Fair Housing-Projected change in number of census tracts in the planning area with high concentrations of poverty and minority segregation-Number of Census Tracts |Census Tracts","Census Tracts"]
["Affirmatively Furthering Fair Housing-Projected change in the Dissimilarity Index for census tracts in the planning area-Median Dissimilarity Index |% Change","% Change"]
["Affirmatively Furthering Fair Housing-Projected change in the dissimilarity index for census tracts in the planning area-Percentage decrease change of tracts with Dissimilarity Index |% Change","% Change"]
["Affirmatively Furthering Fair Housing-Projected change in the Dissimilarity Index for census tracts in the planning area-Increased employment rates for existing residents |Employment Rate","Employment Rate"]
["Cultural Environment-Strategic Plans adopted to implement activities in support of cultural  assets-Activities  |Activities ","Activities "]
["Cultural Environment-Strategic Plans adopted for investments in support of cultural  assets-Dollars |Dollars","Dollars"]
["Economic Development-Business Opportunities-Section 3-Businesses |Businesses","Businesses"]
["Economic Development-Change in the share of commercial and industrial facilities constructed on underutilized infill sites-Number of commercial and industrial facilities on underutilized infill sites |Infill Facilities","Infill Facilities"]
["Economic Development-Dollars invested in existing commercial and industrial facilities |Dollars","Dollars"]
["Economic Development-Employment-Other |Persons","Persons"]
["Economic Development-Employment-Section 3 |Persons","Persons"]
["Economic Development-Number of persons employed as a result of investing in commercial and industrial centers |Persons","Persons"]
["Economic Development-Number of persons employed as a result of investing in transportation |Persons","Persons"]
["Economic Development-Number of persons employed as a result of investing in housing |Persons","Persons"]
["Economic Development-Number of persons employed as a result of investing in infrastructure such as projects to improve air and water quality |Persons","Persons"]
["Economic Development-Projected apprenticeship positions created as a result of partnerships with an existing Workforce Investment Board (WIB) to establish apprenticeship programs and/or job opportunities |Apprenticeships","Apprenticeships"]
["Economic Development-Projected change in the number of FTE jobs filled by low-and moderate-income persons as a result of partnerships with an existing Workforce Investment Board (WIB) |FTE Jobs","FTE Jobs"]
["Economic Development-Projected number of low-and moderate-income persons who completed workforce development training and obtained a FTE job |Persons ","Persons "]
["Economic Development-Projected number of new job opportunities created as a result of reuse of existing commercial and industrial centers |FTE Jobs","FTE Jobs"]
["Economic Development-Projected number of new job opportunities for low- and moderate-income residents as a result of implementation of infrastructure improvements |FTE Jobs","FTE Jobs"]
["Environment-Brownfield sites identified for redevelopment |Sites","Sites"]
["Environment-Brownfield sites identified for remediation |Sites","Sites"]
["Environment-Brownfield sites in predominately low-income and/or minority communities identified for remediation |Sites","Sites"]
["Environment-Brownfield sites in predominately low-income and/or minority communities identified for redevelopment |Sites","Sites"]
["Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions-Jurisdictions |Jurisdictions","Jurisdictions"]
["Environment-Comprehensive integrated water, air and land use plans adopted by participating jurisdictions as part of the regional plan-Date |Date","Date"]
["Environment-Decrease in per capita VMT and transportation-related emissions for the region as a result of planning and implementation efforts- Regional Planning Area |% Change","% Change"]
["Environment-Projected change in per capita VMT and transportation-related emissions |% Change","% Change"]
["Governance-Nontraditional representatives incorporated into the Governance Board-Nontraditional Members |Persons","Persons"]
["Governance-Nontraditional representatives incorporated into the Governance Board-Organizations |Organizations","Organizations"]
["Governance-Private and non-federal funding secured and used as leverage to federal funds to support local planning efforts. |Dollars","Dollars"]
["Governance-Private and non-federal funding secured and used as leverage to federal funds to support the integration of local plans into a comprehensive regional plan |Dollars","Dollars"]
["Health-Conduct baseline spatial analysis of health status indicators by census tract for the region (e.g., cardiovascular disease mortality, obesity, homicide, violent crime, life expectancy, infant mortality, respiratory disease, and pedestrian injury) |% of Census Tracts","% of Census Tracts"]
["Health-Conduct baseline spatial analysis of health status indicators by census tract for the region (e.g., cardiovascular disease mortality, obesity, homicide, violent crime, life expectancy, infant mortality, respiratory disease, and pedestrian injury) |# of Health Indicators","# of Health Indicators"]
["Health-Conduct baseline spatial assessment of health behavior indicators by census tract for the region (high priority indicators include: physical activity and fruit/vegetable consumption) |% of Census Tracts","% of Census Tracts"]
["Health-Conduct baseline spatial assessment of health behavior indicators by census tract for the region (high priority indicators include: physical activity and fruit/vegetable consumption) |# Health Behaviors","# Health Behaviors"]
["Health-Include representative(s) from public health sector (e.g., state, county, or local health commissioner(s), environmental health specialist(s), or other designee(s)) on steering committee-Number of persons |Persons","Persons"]
["Health-Include representative(s) from public health sector (e.g., state, county, or local health commissioner(s), environmental health specialist(s), or other designee(s)) in consortium and work group(s)-Number of persons |Persons","Persons"]
["Health-Incorporate health considerations (based on baseline spatial assessment of health status indicators) into planning process |# Plan Elements","# Plan Elements"]
["Health-Ongoing spatial assessment of health status indicators by census tract (e.g., cardiovascular disease mortality, obesity, violent crime rates, life expectancy, infant mortality, respiratory disease, and pedestrian injury) during implementation |% of Census Tracts","% of Census Tracts"]
["Health-Increased number of households within one mile of a healthy food source |Households","Households"]
["Health-Projected change in the availability of fresh food-Retail Food Environment Index |Index","Index"]
["Health-Projected change in the number or share of people living in census tracts with poverty rates exceeding 40 percent |% Population ","% Population "]
["Health-Projected change in the proportion of commute trips made by public transit, biking, and/or walking- Alternative transportation mode share |% Change Mode Share","% Change Mode Share"]
["Housing-Increased proportion of affordable housing units that have high access to a supermarket or grocery store that provides quality fresh foods |Units","Units"]
["Housing-Planned number of housing units constructed on underutilized infill sites-Sites reused |Sites Reused","Sites Reused"]
["Housing-Planned number of housing units constructed on underutilized infill sites-Housing units |Units","Units"]
["Housing-Projected change in median combined housing and transportation costs for low-income populations in the planning area |Dollars","Dollars"]
["Housing-Projected change in median combined housing and transportation costs for minority populations in the planning area |Dollars","Dollars"]
["Housing-Projected change in the number of affordable housing units close to high performing schools-Net increase in units |Housing Units","Housing Units"]
["Housing-Projected change in the number of affordable housing units close to health care facilities-Net increase in units  |Housing Units","Housing Units"]
["Housing-Projected change in the number of affordable housing units close to parks-Net increase in units |Housing Units","Housing Units"]
["Housing-Projected change in total combined housing and transportation costs for low-income populations in the planning area |Dollars","Dollars"]
["Housing-Projected change in total combined housing and transportation costs for minority populations in the planning area |Dollars","Dollars"]
["Housing-Projected number of affordable housing units close to high-quality transit service in urban areas |Units","Units"]
["Housing-Projected number of affordable housing units close to high-quality transit service within rural town centers |Units","Units"]
["Investment-Projected federal investment aligned with Regional Plan for Sustainable Development |Dollars","Dollars"]
["Land Use-Change in the average units per acre of residential development |% Change","% Change"]
["Land Use-Corridor Plan adopted-Date |Date","Date"]
["Land Use-Corridor Plan adopted-Number of Jurisdictions |Jurisdictions ","Jurisdictions "]
["Land Use-Corridor Plan-Economic Development-Projected change in dollars invested in businesses along the corridor |"]
[" |Dollars","Dollars"]
["Land Use-Corridor Plan-Economic Development-Projected number of new businesses along the corridor |"]
[" |New Businesses","New Businesses"]
["Land Use-Corridor Plan-Economic Development-Projected number of new FTE jobs along the corridor |"]
[" |New FTE Jobs","New FTE Jobs"]
["Land Use-Corridor Plan-Projected number of new housing units along the corridor |"]
[" |Units ","Units "]
["Land Use-Corridor Plan-Transportation-Projected percent change in pedestrian mode share along the corridor-Percent Change  |"]
[" |% Change","% Change"]
["Land Use-Corridor Plan-Transportation-Projected percent change in bicycle mode share along the corridor |"]
[" | % Change"," % Change"]
["Land Use-Corridor Plan-Transportation-Projected percent change in transit mode share along the corridor |"]
[" |% Change","% Change"]
["Land Use-Corridor Plan-Transportation-Projected percent change in automobile mode share along the corridor |"]
[" |% Change ","% Change "]
["Land Use-Land Banking-Properties purchased asa result of creation of land bank fund-Dollars |Dollars","Dollars"]
["Land Use-Land Banking-Properties purchased as a result of creation of land bank fund-Properties |Properties","Properties"]
["Land Use-Land Banking-Projected affordable housing units on land acquired through land banking  |"]
[" |Units","Units"]
["Land Use-Land Banking-Projected investment in mixed-use development on land acquired through land banking-Dollars |"]
[" |Dollars","Dollars"]
["Land Use-Land Banking-Projected investment in mixed-use development on land acquired through land banking-acres |"]
[" |Acres","Acres"]
["Land Use-Planned change in the acres of land dedicated to commercial use with a FAR of more than 0.8 |Acres","Acres"]
["Land Use-Planned change in the number of acres of land with more than 12 housing units per acre |Acres","Acres"]
["Land Use-Planned change in the number of census tracts containing Green Space as a result of the adoption of the Regional Plan for Sustainable Development |Census Tracts","Census Tracts"]
["Land Use-Planned change in the number of housing units per acre of existing commercial development-Mixed use development |Housing units","Housing units"]
["Land Use-Planned change in the share of already developed land in rural areas that is tied to existing infrastructure systems-Dollars Saved |Dollars","Dollars"]
["Land Use-Planned Green Space preserved as a result of the adoption of the Regional Plan for Sustainable Development |Acres","Acres"]
["Land Use-Projected change in the average Floor Area Ratio per parcel of land dedicated to industrial development |% Change","% Change"]
["Land Use-Reduction in facilities that cause environmental or public health hazards sited near residential areas |Facilities Remediated","Facilities Remediated"]
["Land Use-Reduction in facilities that cause environmental or public health hazards sited near predominately low-income and/or minority residential areas |Facilities Remediated","Facilities Remediated"]
["Outreach-Percent increase in the number of persons attending scenario and public meetings on regional planning as a result of attending education and training sessions |% Increase","% Increase"]
["Outreach-Number of persons interested in participating in an active role in the governance structure of the regional planning partnership as a result of the education and outreach sessions  |Persons","Persons"]
["Outreach-Citizen Participation-Persons in decision making roles traditionally marginalized in public planning processes |Persons","Persons"]
["Policy and Legislation-Number of measures amended or added to State and local statutes to support the Regional Plan for Sustainable Development |Measures Amended/Added","Measures Amended/Added"]
["Transportation-Health-Planned increase in miles of bike/pedestrian infrastructure |Miles","Miles"]
["Transportation-Health-Planned increase in percentage of streets served by bike/pedestrian infrastructure |% Increase Streets","% Increase Streets"]
["Transportation-Health-Projected decrease change in bike/pedestrian accidents/fatalities |% Decreased Change","% Decreased Change"]
["Transportation-Projected increased change in the number of low and very low-income households within a 30-minute transit commute of employment centers |% Increased Changed ","% Increased Changed "]
[" Other |Other"]

{"sheet":"Tools","index":10,"n_rows":77,"n_cols":1,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["                    CAMP eLogic  Model®"]
["A. Tools For Measurement"]
["Bank accounts"]
["Construction log"]
["Database"]
["Enforcement log"]
["Financial aid log"]
["Intake log"]
["Interviews"]
["Mgt. Info. System-automated"]
["Mgt. Info. System-manual"]
["Outcome scale(s)"]
["Phone log"]
["Plans"]
["Pre-post tests"]
["Post tests"]
["Program specific form(s)"]
["Questionnaire"]
["Recruitment log"]
["Survey"]
["Technical assistance log"]
["Time sheets"]
["B.  Where Data  Maintained"]
["Agency database"]
["Centralized database"]
["Individual case records"]
["Local precinct"]
["Public database"]
["School"]
["Specialized database"]
["Tax Assessor database"]
["Training center"]
["C.  Source of Data"]
["Audit report"]
["Business licenses"]
["Certificate of Occupancy"]
["Code violation reports"]
["Counseling reports"]
["Employment records"]
["Engineering reports"]
["Environmental reports"]
["Escrow accounts"]
["Financial reports"]
["GED certification/diploma"]
["Health records"]
["HMIS"]
["Inspection results"]
["Lease agreements"]
["Legal documents"]
["Loan monitoring reports"]
["Mortgage documents"]
["Payment vouchers"]
["Permits issued"]
["Placements"]
["Progress reports"]
["Referrals"]
["Sale documents"]
["Site reports"]
["Statistics"]
["Tax assessments"]
["Testing results"]
["Waiting lists"]
["Work plan reports"]
["D.  Frequency of  Collection"]
["Daily"]
["Weekly"]
["Monthly"]
["Quarterly"]
["Biannually"]
["Annually"]
["Upon incident"]
["E.  Processing of Data"]
["Computer spreadsheets"]
["Flat file database"]
["Manual tallies"]
["Relational database"]
["Statistical database"]

{"sheet":"Reporting","index":11,"n_rows":596,"n_cols":10,"rows_kept":596,"cut":false,"hidden":false,"merged":[[301,2,301,3],[302,2,302,3],[303,2,303,3],[304,2,304,3],[316,2,316,3],[316,4,316,6],[311,2,311,3],[312,2,312,3],[305,4,305,6],[307,4,307,6],[309,2,309,3],[310,2,310,3],[306,4,306,6],[305,2,305,3],[306,2,306,3],[307,2,307,3],[308,2,308,3],[314,1,329,1],[317,2,317,3],[318,2,318,3],[325,2,325,3],[327,2,327,3],[319,4,319,6],[321,2,321,3],[322,2,322,3],[321,4,321,6],[325,4,325,6],[319,2,319,3],[295,2,295,3],[296,2,296,3],[297,2,297,3],[318,4,318,6],[314,2,314,3],[315,2,315,3],[303,4,303,6],[304,4,304,6],[308,4,308,6],[329,4,329,6],[328,2,328,3],[326,4,326,6],[327,4,327,6],[328,4,328,6],[320,2,320,3],[322,4,322,6],[320,4,320,6],[323,2,323,3],[324,2,324,3],[286,4,286,6],[287,4,287,6],[314,4,314,6],[315,4,315,6],[311,4,311,6],[309,4,309,6],[290,4,290,6],[291,4,291,6],[280,4,280,6],[299,2,299,3],[300,2,300,3],[289,2,289,3],[290,2,290,3],[291,2,291,3],[292,2,292,3],[293,2,293,3],[294,2,294,3],[298,2,298,3],[282,4,282,6],[283,4,283,6],[286,2,286,3],[287,2,287,3],[272,2,272,3],[273,2,273,3],[274,2,274,3],[275,2,275,3],[284,2,284,3],[285,2,285,3],[276,2,276,3],[277,2,277,3],[284,4,284,6],[285,4,285,6],[278,2,278,3],[279,2,279,3],[280,2,280,3],[281,2,281,3],[282,2,282,3],[283,2,283,3],[278,4,278,6],[279,4,279,6],[276,4,276,6],[277,4,277,6],[274,4,274,6],[275,4,275,6],[305,7,305,8],[306,7,306,8],[307,7,307,8],[295,7,295,8],[291,7,291,8],[292,7,292,8],[293,7,293,8],[294,7,294,8],[302,7,302,8],[282,7,282,8],[283,7,283,8],[281,7,281,8],[273,7,273,8],[274,7,274,8],[287,7,287,8],[284,7,284,8],[275,7,275,8],[276,7,276,8],[277,7,277,8],[278,7,278,8],[279,7,279,8],[280,7,280,8],[285,7,285,8],[286,7,286,8],[299,7,299,8],[300,7,300,8],[289,7,289,8],[290,7,290,8],[296,7,296,8],[297,7,297,8],[298,7,298,8],[288,7,288,8],[303,7,303,8],[304,7,304,8],[308,7,308,8],[309,7,309,8],[288,4,288,6],[313,1,313,6],[312,7,312,8],[301,7,301,8],[310,4,310,6],[301,4,301,6],[310,7,310,8],[311,7,311,8],[336,2,336,3],[337,2,337,3],[326,2,326,3],[329,2,329,3],[331,2,331,3],[331,4,331,6],[332,2,332,3],[332,4,332,6],[333,4,333,6],[334,4,334,6],[335,4,335,6],[333,2,333,3],[334,2,334,3],[295,4,295,6],[296,4,296,6],[302,4,302,6],[323,4,323,6],[324,4,324,6],[348,1,358,1],[351,2,351,3],[358,2,358,3],[357,4,357,6],[358,4,358,6],[352,2,352,3],[356,2,356,3],[349,2,349,3],[350,2,350,3],[349,4,349,6],[356,4,356,6],[354,2,354,3],[355,2,355,3],[351,4,351,6],[357,2,357,3],[300,4,300,6],[350,4,350,6],[330,1,330,6],[312,4,312,6],[317,4,317,6],[341,2,341,3],[342,2,342,3],[343,2,343,3],[344,2,344,3],[354,4,354,6],[355,4,355,6],[345,2,345,3],[269,1,312,1],[289,4,289,6],[297,4,297,6],[298,4,298,6],[299,4,299,6],[288,2,288,3],[331,1,346,1],[338,2,338,3],[336,4,336,6],[341,4,341,6],[342,4,342,6],[343,4,343,6],[344,4,344,6],[345,4,345,6],[346,4,346,6],[260,2,260,3],[265,2,265,3],[267,2,267,3],[268,2,268,3],[337,4,337,6],[338,4,338,6],[294,4,294,6],[292,4,292,6],[293,4,293,6],[335,2,335,3],[353,2,353,3],[352,4,352,6],[353,4,353,6],[339,2,339,3],[340,2,340,3],[264,2,264,3],[339,4,339,6],[340,4,340,6],[348,2,348,3],[348,4,348,6],[347,1,347,6],[269,4,269,6],[269,2,269,3],[270,4,270,6],[271,4,271,6],[270,2,270,3],[271,2,271,3],[272,4,272,6],[281,4,281,6],[346,2,346,3],[273,4,273,6],[266,1,266,8],[267,7,267,8],[268,7,268,8],[267,4,267,6],[268,4,268,6],[270,7,270,8],[269,7,269,8],[271,7,271,8],[272,7,272,8],[236,1,265,1],[240,2,240,3],[241,2,241,3],[243,2,243,3],[244,2,244,3],[247,2,247,3],[248,2,248,3],[256,2,256,3],[257,2,257,3],[259,2,259,3],[261,2,261,3],[262,2,262,3],[263,2,263,3],[258,2,258,3],[242,2,242,3],[245,2,245,3],[246,2,246,3],[249,2,249,3],[250,2,250,3],[251,2,251,3],[227,2,227,3],[235,1,235,4],[236,2,236,3],[237,2,237,3],[238,2,238,3],[255,2,255,3],[252,2,252,3],[253,2,253,3],[254,2,254,3],[239,2,239,3],[226,2,226,3],[234,2,234,3],[212,2,212,3],[213,2,213,3],[214,2,214,3],[215,2,215,3],[216,2,216,3],[217,2,217,3],[218,2,218,3],[233,2,233,3],[228,2,228,3],[230,2,230,3],[231,2,231,3],[224,2,224,3],[229,2,229,3],[210,2,210,3],[211,2,211,3],[219,2,219,3],[220,2,220,3],[221,2,221,3],[204,1,204,6],[207,2,207,3],[208,2,208,3],[209,2,209,3],[205,2,205,3],[206,2,206,3],[205,1,234,1],[222,2,222,3],[223,2,223,3],[225,2,225,3],[232,2,232,3],[8,1,17,1],[31,1,36,1],[38,1,98,1],[100,1,129,1],[131,1,191,1],[193,1,203,1],[194,2,194,6],[191,4,191,6],[203,2,203,6],[201,2,201,6],[202,2,202,6],[195,2,195,6],[196,2,196,6],[197,2,197,6],[198,2,198,6],[199,2,199,6],[200,2,200,6],[187,4,187,6],[190,7,190,8],[192,1,192,6],[181,7,181,8],[188,7,188,8],[191,7,191,8],[182,7,182,8],[183,7,183,8],[184,7,184,8],[181,2,181,3],[169,7,169,8],[170,7,170,8],[171,7,171,8],[172,7,172,8],[193,2,193,6],[185,7,185,8],[186,7,186,8],[187,7,187,8],[189,7,189,8],[185,4,185,6],[173,7,173,8],[174,7,174,8],[175,7,175,8],[176,7,176,8],[178,7,178,8],[164,7,164,8],[165,7,165,8],[166,7,166,8],[167,7,167,8],[168,7,168,8],[175,2,175,3],[176,2,176,3],[164,4,164,6],[165,4,165,6],[166,4,166,6],[167,4,167,6],[168,4,168,6],[169,4,169,6],[170,4,170,6],[171,4,171,6],[172,4,172,6],[173,4,173,6],[174,4,174,6],[175,4,175,6],[179,4,179,6],[180,4,180,6],[191,2,191,3],[178,2,178,3],[185,2,185,3],[189,2,189,3],[190,2,190,3],[179,2,179,3],[180,2,180,3],[182,2,182,3],[183,2,183,3],[188,4,188,6],[189,4,189,6],[190,4,190,6],[187,2,187,3],[177,7,177,8],[188,2,188,3],[181,4,181,6],[179,7,179,8],[180,7,180,8],[186,4,186,6],[182,4,182,6],[183,4,183,6],[184,4,184,6],[163,2,163,3],[163,4,163,6],[169,2,169,3],[170,2,170,3],[171,2,171,3],[172,2,172,3],[176,4,176,6],[186,2,186,3],[164,2,164,3],[165,2,165,3],[166,2,166,3],[177,2,177,3],[167,2,167,3],[168,2,168,3],[184,2,184,3],[173,2,173,3],[174,2,174,3],[162,7,162,8],[162,4,162,6],[160,4,160,6],[161,4,161,6],[163,7,163,8],[156,7,156,8],[157,7,157,8],[177,4,177,6],[178,4,178,6],[146,7,146,8],[147,7,147,8],[148,7,148,8],[158,7,158,8],[159,7,159,8],[160,7,160,8],[161,7,161,8],[156,4,156,6],[162,2,162,3],[149,7,149,8],[150,7,150,8],[151,7,151,8],[157,4,157,6],[155,4,155,6],[154,7,154,8],[155,7,155,8],[158,4,158,6],[159,4,159,6],[152,7,152,8],[153,7,153,8],[154,4,154,6],[138,4,138,6],[139,4,139,6],[151,4,151,6],[152,4,152,6],[142,4,142,6],[143,4,143,6],[144,4,144,6],[136,7,136,8],[137,7,137,8],[145,4,145,6],[146,4,146,6],[147,4,147,6],[136,4,136,6],[137,4,137,6],[153,4,153,6],[144,7,144,8],[131,2,131,3],[133,4,133,6],[134,4,134,6],[135,4,135,6],[131,7,131,8],[140,4,140,6],[141,4,141,6],[131,4,131,6],[148,4,148,6],[149,4,149,6],[150,4,150,6],[138,7,138,8],[141,7,141,8],[142,7,142,8],[143,7,143,8],[145,7,145,8],[139,7,139,8],[140,7,140,8],[133,7,133,8],[134,7,134,8],[135,7,135,8],[96,3,96,7],[97,3,97,7],[98,3,98,7],[132,2,132,3],[132,4,132,6],[132,7,132,8],[99,1,99,8],[100,4,100,5],[130,1,130,8],[74,3,74,7],[75,3,75,7],[81,3,81,7],[82,3,82,7],[90,3,90,7],[91,3,91,7],[92,3,92,7],[93,3,93,7],[76,3,76,7],[77,3,77,7],[94,3,94,7],[88,3,88,7],[89,3,89,7],[95,3,95,7],[86,3,86,7],[87,3,87,7],[83,3,83,7],[84,3,84,7],[85,3,85,7],[78,3,78,7],[79,3,79,7],[80,3,80,7],[54,3,54,7],[71,3,71,7],[72,3,72,7],[68,3,68,7],[69,3,69,7],[66,3,66,7],[73,3,73,7],[70,3,70,7],[35,3,35,7],[67,3,67,7],[60,3,60,7],[61,3,61,7],[53,3,53,7],[51,3,51,7],[55,3,55,7],[50,3,50,7],[40,3,40,7],[52,3,52,7],[64,3,64,7],[65,3,65,7],[63,3,63,7],[56,3,56,7],[57,3,57,7],[58,3,58,7],[59,3,59,7],[62,3,62,7],[36,3,36,7],[21,3,21,7],[27,3,27,7],[28,3,28,7],[29,3,29,7],[31,3,31,7],[32,3,32,7],[34,3,34,7],[26,3,26,7],[49,3,49,7],[43,3,43,7],[44,3,44,7],[45,3,45,7],[47,3,47,7],[48,3,48,7],[41,3,41,7],[42,3,42,7],[11,3,11,7],[17,3,17,7],[16,3,16,7],[25,3,25,7],[46,3,46,7],[39,3,39,7],[30,1,30,8],[37,1,37,8],[38,3,38,7],[33,3,33,7],[5,3,5,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[10,3,10,7],[9,3,9,7],[18,3,18,7],[12,3,12,7],[13,3,13,7],[24,3,24,7],[14,3,14,7],[15,3,15,7],[19,3,19,7],[20,3,20,7],[22,3,22,7],[23,3,23,7]]}
[null,"Carter-Richmond Methodology "]
[null,"The Management Questions developed for your program are based on the Carter-Richmond Methodology.*   A description of the Carter-Richmond Methodology appears in the General Section of the NOFA."]
[null,"* © The Accountable Agency – How to Evaluate the Effectiveness of Public and Private Programs,” Reginald Carter, ISBN Number 9780978724924"]
[]
[]
[null,"Response to Management Questions","Measure","Answer"]
[1,"What was the total Federal investment aligned with Regional Plans for Sustainable Development during the planning process? ","Dollars"]
[2,"What Federal resources have you identified to invest in implementation of the Regional Plan for Sustainable Development? Identify up to 10 federal resources. ","List of Federal Resources","Dollars (s)"]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[3,"How many residents participated in decision making roles? ","Persons"]
[4,"How many housing units are expected to be made available as a result of plans that call for reuse of infill sites? ","Units"]
[5," How many units of affordable housing are expected to become available as a result of the planning process? ","Units"]
[6," How many commercial facilities are expected to be made available as a result of plans that call for reuse of infill sites? ","Facilities"]
[7,"What is the estimated dollar value of the projected economic development as a result of plans that call for commercial facilities on underutilized infill sites? ","Dollars"]
[8," How many industrial facilities are expected to be made available as a result of plans that call for reuse of infill sites? ","Facilities"]
[9,"How many new jobs are expected to be created as a result of the plans that have been adopted? ","FTE's"]
[10,"What was the average hourly wage of persons employed that will be retained as a result of investment in existing commercial and industrial centers? ","Dollars"]
[11,"What was the average median combined cost of housing and transportation for low-income populations in the regional planning area prior to the planning grant?","Dollars"]
[12," What was the average length of travel time to and from work prior to the Sustainable Communities Regional Planning Grant? ","Minutes"]
[13,"What was the average travel cost to and from work prior to the Sustainable Communities Regional Planning Grant? ","Dollars"]
[14," What was the average vehicle miles traveled to and from work prior to the Sustainable Communities Regional Planning Grant? ","Miles"]
[15,"The Sustainable Communities Regional Planning Grant is required to address all elements of multijurisdictional planning including developing specific plans for: • Housing • Land Use • Economic and Workforce Development • Transportation • Infrastructure Investments In Column 2 using the numbers 1, 2, 3, 4 and 5, with 1 the greatest financial investment and 5 the least financial investment, enter the number that best represents the magnitude of the financial investment for the five plans. Use all five numbers but only use each number once. In Column 3, identify the number of jurisdictions participating in each plan.\n\n"]
[15,null,"Plans (1) ","Investment (2) ",null,null,null,null,"Jurisdictions (3)"]
[15,null,"Housing"]
[15,null,"Land use "]
[15,null,"Economic and workforce development "]
[15,null,"Transportation "]
[15,null,"Infrastructure investments  "]
["16a","Below, list the names of the jurisdictions participating in the planning process. For those jurisdictions that participated in the planning process from the beginning, enter their names under “Original Jurisdictions.” For those jurisdictions that joined after the planning process had already begun, enter their names under “Joining Jurisdictions in the second table.” Please start with Column 1. If additional space is needed go to Column 2 then Column 3. Do not re-enter the information you entered in Column 1 in Column 2 or Column 3. There is sufficient space to enter 105 jurisdictions. "]
["16a",null,"Original Jurisdictions (1) ","Original Jurisdictions (2)",null,null,null,null,"Original Jurisdictions (3)"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16a"]
["16b",null,"Joining Jurisdictions (1)","Joining Jurisdictions (2)",null,null,null,null,"Joining Jurisdictions (3)"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
["16b"]
[17,"In Column 1 enter the names of the jurisdictions/communities that adopted the plans and enter the corresponding date that the plan was adopted. There are 33 rows for each of Columns 1, 2 and 3. If there are additional jurisdictions/communities that adopted the plans, enter them in Column 3 with the corresponding date that the plan was adopted. Use Column 5 if additional space is needed. A total of 99 jurisdictions may be entered."]
[17,null,"Jurisdictions (1)","Date ","Jurisdictions (3)",null,"Date ","Jurisdictions (5)","Date "]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[17]
[18,"If changes were made to State and local statues to support the Regional Plan for Sustainable Development, please identify up to 30 changes below and the number of jurisdictions affected.  In the first table, enter information for the state statue. In the second table, enter information for the local statue. \nIn Column 1 for either table, enter the name or number of the statutes changed.In Column 2 for either table, identify the changes made.In Column 3 for either table, identify the number of jurisdictions affected.If no state or local statutes were affected, please leave the cell blank.\n"]
["18a",null,"State Statute(1)",null,"Change(s) Made (2)",null,null,"# Jurisdictions Affected (3)"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18a"]
["18b",null,"Local Statute(1)",null,"Change(s) Made (2)",null,null,"# Jurisdictions Affected (3)"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
["18b"]
[19,"What obstacles if any did you have to overcome to get the plan(s) adopted? Please list up to ten obstacles encountered that were addressed or resolved."]
[19,null,"Obstacles"]
[19]
[19]
[19]
[19]
[19]
[19]
[19]
[19]
[19]
[19]
[20,"What were the total dollars needed to develop the plan? For each year of the process (where applicable), please enter the total dollars expended. If dollars were expended in more than one year, please use the Year 2 and Year 3 tables below.  "]
[20,null,"Year 1-Plan",null,"Dollars "]
[20,null,"Housing"]
[20,null,"Land use "]
[20,null,"Economic and Workforce Development "]
[20,null,"Transportation "]
[20,null,"Infrastructure Investments  "]
[20,null,"Water Infrastructure"]
[20,null,"Energy"]
[20,null,"Environment "]
[20,null,"Other"]
[20,null,"Year 2-Plan",null,"Dollars "]
[20,null,"Housing"]
[20,null,"Land use "]
[20,null,"Economic and Workforce Development "]
[20,null,"Transportation "]
[20,null,"Infrastructure Investments  "]
[20,null,"Water Infrastructure"]
[20,null,"Energy"]
[20,null,"Environment "]
[20,null,"Other"]
[20,null,"Year 3-Plan",null,"Dollars "]
[20,null,"Housing"]
[20,null,"Land use "]
[20,null,"Economic and Workforce Development "]
[20,null,"Transportation "]
[20,null,"Infrastructure Investments  "]
[20,null,"Water Infrastructure"]
[20,null,"Energy"]
[20,null,"Environment "]
[20,null,"Other"]
[21,"What were the total dollars other than HUD funds that were leveraged in support of plan development? For each year of the process (where applicable), please enter the total dollars leveraged. If dollars were leveraged in more than one year, please use the Year 2 and Year 3 tables below.  "]
[21,null,"Year 1-Plan",null,"Dollars "]
[21,null,"Housing"]
[21,null,"Land use "]
[21,null,"Economic and Workforce Development "]
[21,null,"Transportation "]
[21,null,"Infrastructure Investments  "]
[21,null,"Water Infrastructure"]
[21,null,"Energy"]
[21,null,"Environment "]
[21,null,"Other"]
[21,null,"Year 2-Plan",null,"Dollars "]
[21,null,"Housing"]
[21,null,"Land use "]
[21,null,"Economic and Workforce Development "]
[21,null,"Transportation "]
[21,null,"Infrastructure Investments  "]
[21,null,"Water Infrastructure"]
[21,null,"Energy"]
[21,null,"Environment "]
[21,null,"Other"]
[21,null,"Year 3-Plan",null,"Dollars "]
[21,null,"Housing"]
[21,null,"Land use "]
[21,null,"Economic and Workforce Development "]
[21,null,"Transportation "]
[21,null,"Infrastructure Investments  "]
[21,null,"Water Infrastructure"]
[21,null,"Energy"]
[21,null,"Environment "]
[21,null,"Other"]
[22,"Identify long-term impact measures that you will be using to determine the success of your regional planning effort.  Please fill in measures for 5, 10, 15 and 20 year intervals, In Column 1, enter the measure of progress. In Column 2, enter the % change you expect to accomplish. In Column 3, enter the anticipated date that the target will be it will be met. You may choose to track a measure across the entire time horizon (in which case it would show up in each 5-year increment below), or you may choose to look at a particular measure at a specific point (e.g. if you think you will achieve a reduction in the disparity of a particular health outcome in Year 15, you may choose to show it in the table forecasting Year 15 outcomes only). Please note that the zero date is 2010.\nFor Example: \n\n"]
[null,null,"5-Year Measure Of Progress      ",null," % Change in Given Measure   ",null,null," Date Anticipated that Target Will Be Met"]
[null,null,"VMT Per Capita Reduction ",null,7.5,null,null," 7/2015 ",null,"     "]
[22,null,"5-Year Measure Of Progress  ",null,"% Change in Given Measure",null,null,"Date Anticipated that Target Will Be Met  "]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22,null,"10-Year Measure Of Progress  ",null,"% Change in Given Measure",null,null,"Date Anticipated that Target Will Be Met  "]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22,null,"15-Year Measure Of Progress  ",null,"% Change in Given Measure",null,null,"Date Anticipated that Target Will Be Met  "]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22,null,"20-Year Measure Of Progress  ",null,"% Change in Given Measure",null,null,"Date Anticipated that Target Will Be Met  "]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[22]
[23,"On a regional basis, in Column 1, identify up to 15 impediments that were identified in the Sustainable Communities Regional Planning Grant process. In Column 2, identify the associated strategies that were undertaken to address and ameliorate each identified impediment."]
[23,null,"Impediments to Regional Planning (1)",null,"Strategies to Ameliorate Impediments (2)"]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[23]
[24,"In Column 1 identify up to 15 impediments to Fair Housing that were identified as a result of the Sustainable Communities Regional Planning Grant planning process. In Column 2, identify the associated strategies that were undertaken to address and ameliorate each identified impediment."]
[24,null,"Impediments to Fair Housing (1)",null,"Strategies to Ameliorate Impediments (2)"]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[24]
[25,"Economic Development: Identify up to ten ways that land use policies, programs and/or practices in your region do not support economic growth and development and up to five strategies targeted to location-efficiency and improving ‘quality of place’ that will address those impediments and help spur greater regional economic growth and job creation. In Column 1, identify the land use impediments. In Column identify the strategies to ameliorate those impediments."]
[25,null,"Land Use Impediments to Economic Development (1)",null,"Strategies to Ameliorate Impediments (2)"]
[25]
[25]
[25]
[25]
[25]
[25]
[25]
[25]
[25]
[25]
["end"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ALABAMA"]
[null,"ALASKA"]
[null,"AMERICAN SAMOA"]
[null,"ARIZONA"]
[null,"ARKANSAS"]
[null,"CALIFORNIA"]
[null,"COLORADO"]
[null,"CONNECTICUT"]
[null,"DELAWARE"]
[null,"DISTRICT OF COLUMBIA"]
[null,"FEDERATED STATES OF MICRONESIA"]
[null,"FLORIDA"]
[null,"GEORGIA"]
[null,"GUAM"]
[null,"HAWAII"]
[null,"IDAHO"]
[null,"ILLINOIS"]
[null,"INDIANA"]
[null,"IOWA"]
[null,"KANSAS"]
[null,"KENTUCKY"]
[null,"LOUISIANA"]
[null,"MAINE"]
[null,"MARSHALL ISLANDS"]
[null,"MARYLAND"]
[null,"MASSACHUSETTS"]
[null,"MICHIGAN"]
[null,"MINNESOTA"]
[null,"MISSISSIPPI"]
[null,"MISSOURI"]
[null,"MONTANA"]
[null,"NEBRASKA"]
[null,"NEVADA"]
[null,"NEW HAMPSHIRE"]
[null,"NEW JERSEY"]
[null,"NEW MEXICO"]
[null,"NEW YORK"]
[null,"NORTH CAROLINA"]
[null,"NORTH DAKOTA"]
[null,"NORTHERN MARIANA ISLANDS"]
[null,"OHIO"]
[null,"OKLAHOMA"]
[null,"OREGON"]
[null,"PALAU"]
[null,"PENNSYLVANIA"]
[null,"PUERTO RICO"]
[null,"RHODE ISLAND"]
[null,"SOUTH CAROLINA"]
[null,"SOUTH DAKOTA"]
[null,"TENNESSEE"]
[null,"TEXAS"]
[null,"UTAH"]
[null,"VERMONT"]
[null,"VIRGIN ISLANDS"]
[null,"VIRGINIA"]
[null,"WASHINGTON"]
[null,"WEST VIRGINIA"]
[null,"WISCONSIN"]
[null,"WYOMING"]