{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["CalHome Coverpage","Overview","MAPPING","MA - Article 4","OOR - Article 5","SHTA - Article 6","SHP - Article 7","PDL - Article 8","PDL Budgets - Article 8","Applicant Cert & Commitment","Application Support","Dropdowns","Tables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":134,"comments":7,"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":"CalHome Coverpage","index":0,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[37,0,37,22],[38,0,38,22],[39,0,39,22],[48,0,48,2],[44,0,44,22],[46,0,46,8],[46,9,46,13],[41,0,41,22],[42,0,42,22],[35,0,35,22],[36,0,36,22],[2,0,2,22],[3,0,3,22],[5,0,5,22],[25,0,25,22],[26,0,26,22],[4,0,4,22],[28,0,28,22],[29,0,29,22],[31,0,31,22],[32,0,32,22]]}
[]
[]
["CalHome Program Disaster Assistance"]
["Round 2 Application (Amended)"]
[]
["NOTICE OF FUNDING AVAILABILITY (NOFA)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Gavin Newsom, Governor "]
["State of California"]
[]
["Alexis Podesta, Secretary"]
["Business, Consumer Services and Housing Agency"]
[]
["Ben Metcalf, Director"]
["Department of Housing and Community Development"]
[]
[]
["2020 West El Camino Avenue, Suite 500"]
["Sacramento, CA 95833"]
["Phone: (916) 263-2771   "]
["email: calhome@hcd.ca.gov"]
["http://www.hcd.ca.gov/grants-funding/nofas.shtml"]
[]
["Application Technical Support email:"]
["AppSupport@hcd.ca.gov"]
[]
["May 2019"]
[]
["Application Due Date:",null,null,null,null,null,null,null,null,"2019-10-03",null,null,null,null,{"$f":"DATE(YEAR(J47)-4,MONTH(J47),DAY(J47))","v":"2015-10-03"}]
[]
["Rev. 8/14/19"]

{"sheet":"Overview","index":1,"n_rows":73,"n_cols":40,"rows_kept":73,"cut":false,"hidden":false,"merged":[[5,30,5,31],[6,30,6,31],[5,32,5,37],[6,32,6,37],[5,19,5,20],[6,19,6,20],[5,21,5,29],[6,21,6,29],[41,33,41,37],[35,15,35,21],[7,36,7,37],[19,36,19,37],[6,13,6,18],[36,0,36,14],[36,15,36,21],[36,22,36,28],[36,29,36,37],[41,0,41,17],[41,18,41,20],[41,21,41,23],[41,24,41,26],[35,22,35,28],[41,27,41,29],[41,30,41,32],[40,0,40,17],[40,18,40,20],[40,21,40,23],[40,24,40,26],[40,27,40,29],[40,30,40,32],[40,33,40,37],[39,0,39,17],[39,27,39,29],[46,27,46,29],[46,30,46,32],[46,33,46,37],[45,0,45,17],[45,18,45,20],[45,21,45,23],[45,24,45,26],[45,27,45,29],[45,30,45,32],[45,33,45,37],[53,3,53,9],[53,10,53,29],[53,30,53,35],[53,36,53,37],[61,30,61,35],[49,0,49,35],[51,3,51,9],[53,0,53,2],[60,3,60,9],[59,36,59,37],[61,36,61,37],[60,36,60,37],[61,3,61,9],[48,0,48,37],[55,0,55,7],[55,8,55,37],[56,36,56,37],[11,12,11,13],[11,14,11,24],[51,0,51,2],[51,36,51,37],[52,36,52,37],[56,0,56,2],[56,3,56,9],[56,10,56,29],[56,30,56,35],[12,0,12,1],[31,0,31,14],[28,0,28,14],[29,0,29,14],[30,0,30,14],[39,30,39,32],[39,33,39,37],[35,0,35,14],[39,18,39,20],[39,21,39,23],[39,24,39,26],[5,0,5,3],[6,0,6,3],[7,0,7,35],[16,14,16,24],[12,14,12,24],[54,0,54,37],[9,0,9,37],[10,0,10,11],[12,27,12,37],[11,2,11,11],[12,2,12,11],[43,33,43,37],[10,25,10,37],[17,14,17,24],[17,25,17,26],[17,27,17,37],[16,0,16,1],[16,2,16,11],[12,12,12,13],[17,0,17,1],[17,2,17,11],[17,12,17,13],[34,29,34,37],[27,0,27,37],[4,2,4,16],[6,4,6,11],[49,36,49,37],[63,8,63,29],[66,36,66,37],[71,30,71,35],[71,36,71,37],[65,3,65,9],[72,3,72,9],[72,10,72,29],[72,0,72,2],[64,36,64,37],[65,36,65,37],[66,10,66,29],[67,10,67,29],[68,36,68,37],[64,10,64,29],[67,3,67,9],[69,30,69,35],[69,36,69,37],[62,10,62,29],[59,0,59,35],[62,0,62,2],[63,0,63,2],[2,23,3,28],[50,30,50,35],[50,36,50,37],[3,35,3,37],[58,0,58,35],[58,36,58,37],[50,0,50,2],[50,3,50,9],[50,10,50,29],[57,0,57,35],[57,36,57,37],[2,0,3,3],[2,35,2,37],[12,25,12,26],[2,29,3,34],[4,18,4,24],[5,4,5,11],[4,25,4,26],[4,0,4,1],[11,0,11,1],[11,25,11,26],[16,25,16,26],[16,27,16,37],[16,12,16,13],[70,36,70,37],[32,15,32,21],[25,25,25,37],[26,25,26,37],[33,29,33,37],[71,0,71,2],[66,30,66,35],[67,30,67,35],[29,22,29,28],[30,22,30,28],[31,22,31,28],[70,0,70,2],[33,0,33,14],[29,29,29,37],[30,29,30,37],[31,29,31,37],[32,29,32,37],[30,15,30,21],[28,29,28,37],[69,0,69,2],[46,0,46,17],[46,18,46,20],[46,21,46,23],[46,24,46,26],[0,0,0,34],[2,4,3,18],[2,19,3,22],[4,27,4,30],[47,0,47,37],[37,0,37,37],[72,30,72,35],[38,0,38,37],[5,13,5,18],[32,0,32,14],[0,35,0,37],[71,10,71,29],[69,3,69,9],[63,36,63,37],[63,3,63,7],[67,36,67,37],[65,10,65,29],[62,36,62,37],[34,0,34,14],[25,0,26,18],[25,19,25,24],[26,19,26,24],[31,15,31,21],[64,30,64,35],[64,3,64,9],[66,3,66,9],[62,3,62,9],[70,3,70,9],[70,10,70,29],[71,3,71,9],[70,30,70,35],[69,10,69,29],[65,30,65,35],[65,0,65,2],[66,0,66,2],[64,0,64,2],[67,0,67,2],[18,0,18,35],[18,36,18,37],[19,0,19,35],[68,0,68,2],[68,3,68,9],[68,10,68,29],[68,30,68,35],[51,10,51,29],[51,30,51,35],[52,0,52,2],[52,3,52,9],[52,10,52,29],[52,30,52,35],[60,30,60,35],[60,0,60,2],[60,10,60,29],[61,10,61,29],[61,0,61,2],[62,30,62,35],[63,30,63,35],[72,36,72,37],[4,31,4,32],[8,0,8,2],[8,3,8,9],[8,10,8,29],[8,30,8,35],[8,36,8,37],[20,0,20,35],[20,36,20,37],[11,27,11,37],[10,12,10,24],[44,0,44,17],[44,18,44,20],[44,21,44,23],[44,24,44,26],[44,27,44,29],[44,30,44,32],[44,33,44,37],[43,0,43,17],[43,18,43,20],[43,21,43,23],[43,24,43,26],[43,27,43,29],[43,30,43,32],[1,0,1,37],[23,6,23,37],[23,0,23,5],[24,6,24,37],[24,0,24,5],[4,35,4,37],[42,33,42,37],[42,0,42,17],[42,18,42,20],[42,21,42,23],[42,24,42,26],[42,27,42,29],[42,30,42,32],[35,29,35,37],[33,15,33,21],[34,15,34,21],[28,22,28,28],[34,22,34,28],[28,15,28,21],[29,15,29,21],[32,22,32,28],[33,22,33,28],[22,0,22,37],[21,0,21,37],[15,0,15,1],[15,2,15,11],[15,12,15,13],[15,14,15,24],[15,25,15,26],[15,27,15,37],[13,0,13,1],[13,2,13,11],[13,12,13,13],[13,14,13,24],[13,25,13,26],[13,27,13,37],[14,0,14,1],[14,2,14,11],[14,12,14,13],[14,14,14,24],[14,25,14,26],[14,27,14,37]]}
["Overview - Activity Type and Applicant Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"},null,null,null,false]
["When opening this file, a yellow banner at the top may appear with a button that says \"Enable Content\" or \"Enable Editing\".  It is essential for full worksheet functionality that you click this box so that the macros are enabled.  Macros do not work with Microsoft's Excel version for Apple Mac.  Please complete this form using a PC."]
["Applicant Name:\n§7750(a) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant\nType: §7716(c)",null,null,null,null,null,null,null,null,null,"FEMA Disaster Declarations:",null,null,null,null,null,null,null,null,null,false]
[]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"County",null,null,null,null,null,"State",null,null,"Zip"]
["Auth Rep: Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact: Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,"Phone"]
["§7750(c) Applicant certifies it has the authority to undertake the activities applied for; that it does not have any unresolved HCD audit findings nor pending lawsuits; that if the application is for a construction project, construction work has not yet begun; and that it agrees to comply with all program requirements."]
["File Name:",null,null,"App - Eligibility 7750(c)",null,null,null,null,null,null,"If you answered \"No\" above, explain details on a separate sheet of paper.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(a) Indicate all Legislators who represent any portion of the proposed service area. If you have vacancies in your legislative seats, list your district number and address. "]
["Members of the State Assembly",null,null,null,null,null,null,null,null,null,null,null,"Members of the State Senate",null,null,null,null,null,null,null,null,null,null,null,null,"Members of the of the U.S. House of Representatives"]
["District #",null,"Name",null,null,null,null,null,null,null,null,null,"District #",null,"Name",null,null,null,null,null,null,null,null,null,null,"District #",null,"Name"]
[]
[]
[]
[]
[]
[]
["§7719 Applicant certifies CalHome funds will not be used for any of the costs in §7719 that may be incurred in the local program or the project."]
["§7720 Applicant certifies individual households who receive benefits of CalHome funds will meet the eligibility requirements of §7720. AB 101 modified Health & Safety Code (HSC) §50650.3 to allow the CalHome program to provide assistance to households with incomes at or below 120 percent of area median income (AMI) that are victims of one of the four qualifying disasters."]
["§7721 Applicant certifies it will implement the proposed local programs or projects and also be responsible for the activity requirements of §7721."]
["Eligible Activities §7718"]
["Applicants may include Project activities or up to two Program activities in an application. Applicants may not apply for both Project activities and Program activities. If applying for the Technical Assistance to Self-Help Housing Project activity, the Applicant must also apply for the Homeownership Project Development Loan activity. (See NOFA)"]
["Program Activities:"]
["Project Activities:"]
["Eligible Activities must assist counties impacted by the disasters outlined in the NOFA. Please select the county activities proposed in this application will assist to the right.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assisted County:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximate Allocation:",null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Overview!Z26,Tables!A2:B13,2,FALSE),\"\")","v":""}]
["Total Uses of Funds §7719"]
["Activity Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CalHome Funds Request:",null,null,null,null,null,null,"CalHome Funds Eligible:",null,null,null,null,null,null,"Approximate Allocation Remaining:"]
["First-Time Homebuyer for Mortgage Assistance §7718(a)(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!S6,0)","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!Z6,0)","v":0}]
["Owner-Occupied Rehabilitation §7718(a)(2) & HSC §50650.3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!S9,0)","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!Z9,0)","v":0}]
["Technical Assistance for Shared Housing Programs §7718(a)(4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!S5,0)","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!Z5,0)","v":0}]
["PROGRAM ACTIVITY TOTAL:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P30:V32)","v":0},null,null,null,null,null,null,{"$f":"SUM(W30:AC32)","v":0},null,null,null,null,null,null,{"$f":"IF(AND(ProgramActivities<>\"\",ProjectActivities=\"\"),IF(Z26=\"\",0,Z27-P33),0)","v":0}]
["Homeownership Project Development Loans §7718(b)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!S5,0)","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!Z5,0)","v":0}]
["Technical Assistance for Self-Help Housing Projects §7718(a)(3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!S5,0)","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!Z5,0)","v":0}]
["PROJECT ACTIVITY TOTAL:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P34:V35)","v":0},null,null,null,null,null,null,{"$f":"SUM(W34:AC35)","v":0},null,null,null,null,null,null,{"$f":"IF(AND(ProjectActivities<>\"\",ProgramActivities=\"\"),IF(Z26=\"\",0,Z27-P36),0)","v":0}]
["TOTAL FUNDS REQUEST:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P36,P33)","v":0},null,null,null,null,null,null,{"$f":"SUM(W33,W36)","v":0},null,null,null,null,null,null,{"$f":"SUM(AD36,AD33)","v":0}]
["Selection Criteria §7751"]
["(minimum points required = 550; max points = 1,000)"]
["Rating Factors (red shading indicates minimum score has not been achieved)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA",null,null,"OOR",null,null,"SHP",null,null,"PDL",null,null,"SHTA",null,null,"Self-Score Points"]
["Capability §7751(b)(1) - 400 Points Max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!AJ61,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!AJ52,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!AJ44,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!AJ153,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!AJ65,0)","v":0},null,null,{"$f":"IFERROR(ROUND(AVERAGEIF($S$47:$AG$47,\">0\",S41:AG41),2),0)","v":0}]
["Community Need §7751(b)(2) - 150 Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!AJ62,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!AJ53,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!AJ45,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!AJ154,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!AJ66,0)","v":0},null,null,0]
["Feasibility §7751(b)(3) - 250 Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!AJ63,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!AJ54,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!AJ46,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!AJ155,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!AJ67,0)","v":0},null,null,0]
["Community Revitalization §7751(b)(4) - 100 Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!AJ64,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!AJ55,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!AJ47,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!AJ156,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!AJ68,0)","v":0},null,null,0]
["Volunteer, Self-Help Labor or Youth Construction §7751(b)(5) - 100 Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!AJ65,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!AJ56,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!AJ48,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!AJ157,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!AJ69,0)","v":0},null,null,0]
["Performance Penalty §7751(c) - Negative 50 Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(SEARCH(4,ProgramActivities)),'MA - Article 4'!AJ66,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(5,ProgramActivities)),'OOR - Article 5'!AJ57,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(7,ProgramActivities)),'SHP - Article 7'!AJ49,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(8,ProjectActivities)),'PDL - Article 8'!AJ158,0)","v":0},null,null,{"$f":"IF(ISNUMBER(SEARCH(6,ProjectActivities)),'SHTA - Article 6'!AJ70,0)","v":0},null,null,0]
["Self-Scoring Total - (Minimum 550)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S41:U46)","v":0},null,null,{"$f":"SUM(V41:X46)","v":0},null,null,{"$f":"SUM(Y41:AA46)","v":0},null,null,{"$f":"SUM(AB41:AD46)","v":0},null,null,{"$f":"SUM(AE41:AG46)","v":0},null,null,{"$f":"IFERROR(ROUND(AVERAGEIF(S47:AG47,\">0\"),2),0)","v":0}]
["General Applicant Eligibility Requirements §7717"]
["Locality Applicant"]
["(b)(1)-(2) Has the applicant been operating as a housing developer or housing program administrator for a minimum of two years prior to the date of application?"]
["File Name:",null,null,"App - Resolution",null,null,null,null,null,null,"Provide a copy of the County Resolution §7750(b). (Sample linked in cell to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - STD-204",null,null,null,null,null,null,"All payees must submit a Payee Data Record (STD-204). (Sample linked in cell to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Government TIN Form",null,null,null,null,null,null,"Locality Applicants must submit a Government TIN Form. (Form linked in cell to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Reuse Acct Plan",null,null,null,null,null,null,"Provide a Reuse Account Plan that complies with §7724 requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Nonprofit Corporation Applicant"]
["(a)(2) indicate qualifying experience:"]
["File Name:",null,null,"App - Experience",null,null,null,null,null,null,"Provide copy of Grant's Agreement, Memorandum of Understanding, Contract with Locality to demonstrate how Applicant meets the §7717(a)(2) requirement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["(b)(1)-(2) Has the Applicant been operating as a housing developer or housing program administrator for a minimum of two years prior to the date of application?"]
["(b)(3) Has Applicant's tax exempt purposes for the two years prior to the date of application included the activity for which it is applying?"]
["(b)(4) The Applicant certifies they are financially stable to administer funds for activities in which they are applying?"]
["File Name:",null,null,"App - Financial Stmnts",null,null,null,null,null,null,"§7717(b)(4) Financial Statements (for last 2 fiscal years, one of which must be audited)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Articles of Inc",null,null,null,null,null,null,"Articles of Incorporation (Corp. Code §154, 200 & 202) as certified by CA Secretary of State.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Cert of Amend Articles",null,null,null,null,null,null,"Cert. of Amendment of Articles of Inc. - Corp. Code §5810-5820 (public benefit and religious corps.), §7810-7820 (mutual benefit corps.), or §12500-12510 (general cooperative corps.).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Restated Articles",null,null,null,null,"Restated Articles of Inc. - Corp. Code §5811, 5815, 5819 (public benefit and religious corps.), §7811, 7815 and 7819 (mutual benefit corps.) and §12501, 12506 and 12510 (general cooperative corps).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Bylaws",null,null,null,null,null,null,"Bylaws and any amendments thereto - Corp. Code §207(b), 211 and 212",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - IRS 501C3 ",null,null,null,null,null,null,"IRS Approval of 501(c)(3) Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - SOS Letter",null,null,null,null,null,null,"Secretary of State Letter of Good Standing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Board of Directors",null,null,null,null,null,null,"List of Name of Board of Directors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Signature Block",null,null,null,null,null,null,"Signature Block in MS Word. Will be used in HCD legal docs such as Standard Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Cert  and Legal",null,null,null,null,null,null,"A completed and signed Certification and Legal Disclosure is required. In addition, a wet signature original of each signed Certification & Legal Disclosure must be submitted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - STD-204",null,null,null,null,null,null,"All payees must submit a Payee Data Record (STD-204). (Sample linked in cell to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Reuse Acct Plan",null,null,null,null,null,null,"Provide a Reuse Account Plan that complies with §7724 requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"App - Resolution",null,null,null,null,null,null,"§7750(b) Provide a Nonprofit Governing Board Resolution. (Sample linked in cell to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]

{"sheet":"MAPPING","index":2,"n_rows":5,"n_cols":133,"rows_kept":5,"cut":false,"hidden":true,"merged":[[2,92,2,98],[2,99,2,105],[2,106,2,112],[2,68,3,68],[2,69,3,75],[2,76,3,76],[2,77,3,77],[2,78,2,84],[2,85,2,91],[2,67,3,67],[2,56,3,56],[2,57,3,57],[2,58,3,58],[2,59,3,59],[2,60,3,60],[2,61,3,61],[2,62,3,62],[2,63,3,63],[2,64,3,64],[2,65,3,65],[2,66,3,66],[2,55,3,55],[2,44,3,44],[2,45,3,45],[2,46,3,46],[2,47,3,47],[2,48,3,48],[2,49,3,49],[2,50,3,50],[2,51,3,51],[2,52,3,52],[2,53,3,53],[2,54,3,54],[2,43,3,43],[2,32,3,32],[2,33,3,33],[2,34,3,34],[2,35,3,35],[2,36,3,36],[2,37,3,37],[2,38,3,38],[2,39,3,39],[2,40,3,40],[2,41,3,41],[2,42,3,42],[0,127,1,132],[1,19,3,19],[1,20,3,20],[1,23,1,24],[1,25,1,26],[1,27,1,28],[1,29,1,30],[1,31,1,32],[1,33,1,34],[1,35,1,36],[0,44,1,51],[0,52,1,55],[0,56,1,59],[0,60,1,114],[0,115,1,120],[2,26,3,26],[0,121,1,126],[0,18,3,18],[0,19,0,20],[0,21,3,21],[0,22,3,22],[0,23,0,38],[0,39,1,43],[1,37,1,38],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,31,3,31],[2,27,3,27],[2,28,3,28],[2,29,3,29],[2,30,3,30],[0,17,3,17],[0,6,3,6],[0,7,3,7],[0,8,3,8],[0,9,3,9],[0,10,3,10],[0,11,3,11],[0,12,3,12],[0,13,3,13],[0,14,3,14],[0,15,3,15],[0,16,3,16],[0,5,3,5],[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,3,4]]}
["Count","HCD Contract #","CAPES App#","Received Date","Applicant Name","Applicant Type","Applicant Street Address","Applicant City","State","Applicant Zip Code","Applicant County","Authorized\nRep Name","Authorized\nRep Title","Authorized\nRep Email","Authorized\nRep Phone #","Contact Person\nName","Contact Person\nTitle","Contact Person\nEmail","Contact Person Phone Number","Eligible Activities §7718",null,"Assisted County","Approx. Allocation","Total Uses of Funds §7719: Activity Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA - Article 4",null,null,null,null,"OOR - Article 5",null,null,null,null,null,null,null,"SHP - Article 7",null,null,null,"SHTA - Article 6",null,null,null,"PDL - Article 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Assembly",null,null,null,null,null,"State Senate",null,null,null,null,null,"U.S. House of Representatives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Activities","Project Activities",null,null,"First-Time Homebuyer for Mortgage Assistance §7718(a)(1)",null,"Owner-Occupied Rehabilitation §7718(a)(2)",null,"Technical Assistance for Shared Housing Program §7718(a)(4)",null,"Program Activity Total",null,"Homeownership Project Development Loans §7718(b)",null,"Technical Assistance for Self-Help Housing Projects §7718(a)(3)",null,"Project Activity Total",null,"TOTAL FUNDS REQUEST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CalHome Funds Request","CalHome Funds Eligible","CalHome Funds Request","CalHome Funds Eligible","CalHome Funds Request","CalHome Funds Eligible","Total CalHome Funds Request","Total CalHome Funds Eligible","CalHome Funds Request","CalHome Funds Eligible","CalHome Funds Request","CalHome Funds Eligible","Total CalHome Funds Request","Total CalHome Funds Eligible","Total CalHome Funds Request","Total CalHome Funds Eligible","No. of Assisted units","MA Funds Requested","MA Activity Delivery Fee","Total MA Funds","QCT?","OOR Activity 1","OOR Activity 2","Proposed # of Assisted non-manufactured units","Proposed # of Assisted manufactured units","OOR Funds Requested","OOR Activity Delivery Fee","Total OOR Funds","QCT?","No. of Assisted units","SHP Funds Requested","Total SHP Funds","QCT?","No. of Assisted units","SHTA Funds Requested","Total SHTA Funds","QCT?","No. of Assisted units","PDL Funds Requested","Total PDL Funds","QCT?","Development Name","Address","City ","County","Zip","APN(s)",null,null,null,null,null,null,"Proposed Development total units","Unit Type","Unit Breakdown 1",null,null,null,null,null,null,"Unit Breakdown 2",null,null,null,null,null,null,"Unit Breakdown 3",null,null,null,null,null,null,"Unit Breakdown 4",null,null,null,null,null,null,"Unit Breakdown 5",null,null,null,null,null,null,null,null,"District No.","Name","District No.","Name","District No.","Name","District No.","Name","District No.","Name","District No.","Name","District No.","Name","District No.","Name","District No.","Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model No.","Number units","Sq footage","No. bedrooms","No. bathrooms","Total Liens","Proposed Sales Price*","Model No.","Number units","Sq footage","No. bedrooms","No. bathrooms","Total Liens","Proposed Sales Price*","Model No.","Number units","Sq footage","No. bedrooms","No. bathrooms","Total Liens","Proposed Sales Price*","Model No.","Number units","Sq footage","No. bedrooms","No. bathrooms","Total Liens","Proposed Sales Price*","Model No.","Number units","Sq footage","No. bedrooms","No. bathrooms","Total Liens","Proposed Sales Price*","Proposed annual household income","County Median Income"]
[null,null,null,null,{"$f":"Overview!$E$3","v":0},{"$f":"Overview!$X$3","v":0},{"$f":"Overview!$C$5","v":0},{"$f":"Overview!$S$5","v":0},{"$f":"Overview!$AH$5","v":0},{"$f":"Overview!$AJ$5","v":0},{"$f":"Overview!$AB$5","v":0},{"$f":"Overview!$E$6","v":0},{"$f":"Overview!$N$6","v":0},{"$f":"Overview!$X$6","v":0},{"$f":"Overview!$AI$6","v":0},{"$f":"Overview!$E$7","v":0},{"$f":"Overview!$N$7","v":0},{"$f":"Overview!$X$7","v":0},{"$f":"Overview!$AI$7","v":0},{"$f":"Overview!$G$24","v":0},{"$f":"Overview!$G$25","v":0},{"$f":"Overview!$Z$26","v":0},{"$f":"Overview!$Z$27","v":""},{"$f":"Overview!$P$30","v":0},{"$f":"Overview!$W$30","v":0},{"$f":"Overview!$P$31","v":0},{"$f":"Overview!$W$31","v":0},{"$f":"Overview!$P$32","v":0},{"$f":"Overview!$W$32","v":0},{"$f":"Overview!$P$33","v":0},{"$f":"Overview!$W$33","v":0},{"$f":"Overview!$P$34","v":0},{"$f":"Overview!$W$34","v":0},{"$f":"Overview!$P$35","v":0},{"$f":"Overview!$W$35","v":0},{"$f":"Overview!$P$36","v":0},{"$f":"Overview!$W$36","v":0},{"$f":"Overview!$P$37","v":0},{"$f":"Overview!$W$37","v":0},{"$f":"'MA - Article 4'!$S$2","v":0},{"$f":"'MA - Article 4'!$S$4","v":0},{"$f":"'MA - Article 4'!$S$5","v":0},{"$f":"'MA - Article 4'!$S$6","v":0},{"$f":"'MA - Article 4'!$O$9","v":0},{"$f":"'OOR - Article 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'OOR - Article 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'OOR - Article 5'!$AJ$2","v":0},{"$f":"'OOR - Article 5'!$AJ$4","v":0},{"$f":"'OOR - Article 5'!$S$7","v":0},{"$f":"'OOR - Article 5'!$S$8","v":0},{"$f":"'OOR - Article 5'!$S$9","v":0},{"$f":"'OOR - Article 5'!$O$10","v":0},{"$f":"'SHP - Article 7'!$S$2","v":0},{"$f":"'SHP - Article 7'!$S$4","v":0},{"$f":"'SHP - Article 7'!$S$5","v":0},{"$f":"'SHP - Article 7'!$O$6","v":0},{"$f":"'SHTA - Article 6'!$S$2","v":0},{"$f":"'SHTA - Article 6'!$S$4","v":0},{"$f":"'SHTA - Article 6'!$S$5","v":0},{"$f":"'SHTA - Article 6'!$O$8","v":0},{"$f":"'PDL - Article 8'!$S$2","v":0},{"$f":"'PDL - Article 8'!$S$4","v":0},{"$f":"'PDL - Article 8'!$S$5","v":0},{"$f":"'PDL - Article 8'!$O$8","v":0},{"$f":"'PDL - Article 8'!$F$23","v":0},{"$f":"'PDL - Article 8'!$C$24","v":0},{"$f":"'PDL - Article 8'!$W$24","v":0},{"$f":"'PDL - Article 8'!$AF$24","v":0},{"$f":"'PDL - Article 8'!$AJ$24","v":0},{"$f":"'PDL - Article 8'!$C$31","v":0},{"$f":"'PDL - Article 8'!$G$31","v":0},{"$f":"'PDL - Article 8'!$L$31","v":0},{"$f":"'PDL - Article 8'!$Q$31","v":0},{"$f":"'PDL - Article 8'!$V$31","v":0},{"$f":"'PDL - Article 8'!$AA$31","v":0},{"$f":"'PDL - Article 8'!$AF$31","v":0},{"$f":"'PDL - Article 8'!$Q$40","v":0},{"$f":"'PDL - Article 8'!$AG$40","v":0},{"$f":"'PDL - Article 8'!$A$43","v":0},{"$f":"'PDL - Article 8'!$E$43","v":0},{"$f":"'PDL - Article 8'!$I$43","v":0},{"$f":"'PDL - Article 8'!$M$43","v":0},{"$f":"'PDL - Article 8'!$P$43","v":0},{"$f":"'PDL - Article 8'!$S$43","v":0},{"$f":"'PDL - Article 8'!$W$43","v":0},{"$f":"'PDL - Article 8'!$A$44","v":0},{"$f":"'PDL - Article 8'!$E$44","v":0},{"$f":"'PDL - Article 8'!$I$44","v":0},{"$f":"'PDL - Article 8'!$M$44","v":0},{"$f":"'PDL - Article 8'!$P$44","v":0},{"$f":"'PDL - Article 8'!$S$44","v":0},{"$f":"'PDL - Article 8'!$W$44","v":0},{"$f":"'PDL - Article 8'!$A$45","v":0},{"$f":"'PDL - Article 8'!$E$45","v":0},{"$f":"'PDL - Article 8'!$I$45","v":0},{"$f":"'PDL - Article 8'!$M$45","v":0},{"$f":"'PDL - Article 8'!$P$45","v":0},{"$f":"'PDL - Article 8'!$S$45","v":0},{"$f":"'PDL - Article 8'!$W$45","v":0},{"$f":"'PDL - Article 8'!$A$46","v":0},{"$f":"'PDL - Article 8'!$E$46","v":0},{"$f":"'PDL - Article 8'!$I$46","v":0},{"$f":"'PDL - Article 8'!$M$46","v":0},{"$f":"'PDL - Article 8'!$P$46","v":0},{"$f":"'PDL - Article 8'!$S$46","v":0},{"$f":"'PDL - Article 8'!$W$46","v":0},{"$f":"'PDL - Article 8'!$A$47","v":0},{"$f":"'PDL - Article 8'!$E$47","v":0},{"$f":"'PDL - Article 8'!$I$47","v":0},{"$f":"'PDL - Article 8'!$M$47","v":0},{"$f":"'PDL - Article 8'!$P$47","v":0},{"$f":"'PDL - Article 8'!$S$47","v":0},{"$f":"'PDL - Article 8'!$W$47","v":0},{"$f":"'PDL - Article 8'!$Q$51","v":0},{"$f":"'PDL - Article 8'!$Q$54","v":0},{"$f":"Overview!$A$13","v":0},{"$f":"Overview!$C$13","v":0},{"$f":"Overview!$A$17","v":0},{"$f":"Overview!$C$17","v":0},{"$f":"Overview!$A$18","v":0},{"$f":"Overview!$C$18","v":0},{"$f":"Overview!$M$13","v":0},{"$f":"Overview!$O$13","v":0},{"$f":"Overview!$M$17","v":0},{"$f":"Overview!$O$17","v":0},{"$f":"Overview!$M$18","v":0},{"$f":"Overview!$O$18","v":0},{"$f":"Overview!$Z$13","v":0},{"$f":"Overview!$AB$13","v":0},{"$f":"Overview!$Z$17","v":0},{"$f":"Overview!$AB$17","v":0},{"$f":"Overview!$Z$18","v":0},{"$f":"Overview!$AB$18","v":0}]

{"sheet":"MA - Article 4","index":3,"n_rows":66,"n_cols":41,"rows_kept":66,"cut":false,"hidden":true,"merged":[[8,0,10,13],[8,14,10,15],[8,16,10,25],[3,18,3,24],[4,18,4,24],[5,18,5,24],[2,25,2,31],[3,25,3,31],[4,25,4,31],[5,25,5,31],[3,0,3,17],[4,0,4,17],[5,0,5,17],[45,30,45,33],[46,30,46,33],[20,0,20,33],[8,26,8,29],[8,30,8,33],[9,26,9,29],[10,26,10,29],[10,30,10,33],[6,0,6,35],[42,31,42,33],[36,25,36,27],[37,25,37,27],[38,25,38,27],[39,25,39,27],[40,25,40,27],[41,25,41,27],[41,0,41,20],[36,21,36,24],[37,21,37,24],[36,0,37,20],[30,1,30,28],[42,0,42,20],[41,21,41,24],[42,21,42,24],[47,30,47,33],[55,0,55,35],[56,0,56,35],[56,36,56,37],[50,3,50,9],[50,10,50,29],[50,30,50,35],[50,36,50,37],[51,0,51,2],[51,3,51,9],[51,10,51,29],[51,30,51,35],[51,36,51,37],[52,0,52,34],[52,35,52,37],[53,0,53,2],[53,3,53,9],[53,10,53,29],[53,30,53,35],[53,36,53,37],[48,10,48,29],[48,30,48,35],[48,36,48,37],[60,0,60,34],[39,21,39,24],[40,21,40,24],[38,0,38,20],[40,0,40,20],[39,0,39,20],[59,35,59,37],[43,0,43,37],[48,0,48,2],[48,3,48,9],[44,0,47,13],[44,26,44,29],[49,0,49,2],[49,3,49,9],[49,10,49,29],[49,30,49,35],[49,36,49,37],[50,0,50,2],[47,14,47,25],[47,26,47,29],[47,34,47,37],[60,35,60,37],[42,25,42,27],[57,0,57,37],[65,0,65,34],[65,35,65,37],[61,0,61,34],[61,35,61,37],[62,0,62,34],[62,35,62,37],[63,35,63,37],[63,0,63,34],[64,0,64,34],[64,35,64,37],[0,35,0,37],[55,36,55,37],[54,0,54,35],[54,36,54,37],[58,0,58,34],[59,0,59,34],[34,0,34,35],[34,36,34,37],[35,0,35,37],[9,34,9,37],[8,34,8,37],[22,0,22,37],[58,35,58,37],[41,28,41,30],[36,34,36,37],[37,34,37,37],[42,28,42,30],[40,31,40,33],[41,31,41,33],[30,29,30,34],[31,1,31,28],[31,29,31,34],[29,35,29,37],[0,0,0,34],[39,28,39,30],[39,31,39,33],[40,28,40,30],[23,0,23,37],[32,0,32,37],[33,0,33,37],[1,21,1,31],[1,32,1,37],[1,0,1,17],[1,18,1,20],[25,35,25,37],[26,35,26,37],[25,29,25,34],[26,1,26,28],[25,0,25,28],[26,29,26,34],[10,34,10,37],[11,0,11,35],[11,36,11,37],[12,0,12,35],[12,36,12,37],[9,30,9,33],[6,36,6,37],[2,18,2,24],[21,36,21,37],[14,35,14,37],[15,0,15,34],[15,35,15,37],[16,0,16,33],[16,35,16,37],[17,0,17,33],[19,0,19,33],[38,28,38,30],[38,31,38,33],[46,14,46,25],[46,26,46,29],[46,34,46,37],[39,34,39,37],[36,28,36,33],[37,28,37,30],[24,0,24,37],[19,35,19,37],[37,31,37,33],[27,1,27,28],[27,35,27,37],[30,35,30,37],[31,35,31,37],[28,35,28,37],[40,34,40,37],[38,21,38,24],[29,1,29,28],[29,29,29,34],[38,34,38,37],[42,34,42,37],[41,34,41,37],[44,30,44,33],[44,34,44,37],[45,14,45,25],[45,26,45,29],[45,34,45,37],[17,35,17,37],[18,0,18,33],[18,35,18,37],[7,0,7,2],[7,3,7,9],[7,10,7,29],[7,30,7,35],[7,36,7,37],[13,0,13,2],[13,3,13,9],[13,10,13,29],[13,30,13,35],[13,36,13,37],[27,29,27,34],[28,1,28,28],[28,29,28,34],[14,0,14,34],[20,35,20,37],[21,0,21,2],[21,3,21,9],[21,10,21,29],[21,30,21,35]]}
["First-Time Homebuyers for Mortgage Assistance (MA) Program - Article 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["Number of Assisted units to be assisted with this application for CalHome funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximate Allocation Remaining:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z27=\"\",\"\",IF(ISNUMBER(SEARCH(4,ProgramActivities)),Overview!Z27-Overview!P33,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA Funds Request",null,null,null,null,null,null,"MA Maximum Eligible"]
["MA Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S2*100000,0)","v":0}]
["MA Activity Delivery Fee:  §7729(d) (see NOFA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(S4=\"\",Z4*0.1,S4*0.1),0)","v":0}]
["Total MA Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S4:Y5)","v":0},null,null,null,null,null,null,{"$f":"SUM(Z4:AF5)","v":0}]
["Does the applicant currently provide homebuyer education classes?"]
["File Name:",null,null,"MA Homebuyer Education",null,null,null,null,null,null,"If not currently providing classes describe arrangements for providing homebuyer education.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Will the program be operated entirely within federally defined Qualified Census Tracts (QCT)? (Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in QCTs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the program will be operated entirely within a QCT, specify those tracts to the right."]
[]
[]
["Will the program be operated entirely within a formerly designated redevelopment area previously under the jurisdiction of a local Redevelopment Agency?\n(Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in a formerly designated redevelopment area)"]
["Does the program meet a legislatively mandated priority for funds allocated to the CalHome Program?"]
["File Name:",null,null,"MA Community Revitalization",null,null,null,null,null,null,"Documentation verifying the QCTs listed are current and federally recognized, or redevelopment area map that indicates property location(s), or documentation verifying the project meets a legislatively mandated priority.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7751(b)(1)(C) Do you have prior experience with loan servicing or a plan to provide loan servicing / management?"]
["If Yes, how many homebuyer loans underwritten & closed on projects it's developed, which included preparation of loan documents within the last four (4) years?"]
[" a. Total number of homebuyer loans closed for which the applicant was the named beneficiary on the documents within the past four (4) years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[" b. As of the CalHome NOFA issuance date, the total number of homebuyer loans in the applicant's portfolio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[" c. Number of loans identified in (b) above that are being directly serviced by the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[" d. Number of loans identified in (b) above that are being serviced by a third party on behalf of the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d."]
[" e. As of the CalHome NOFA issuance date, the total number of homebuyer loans the applicant is servicing for another entity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e."]
["File Name:",null,null,"MA Loan Servicing",null,null,null,null,null,null,"Submit a narrative identifying how loans will be serviced, how servicing activities will be funded or provided and procedures for implementing loan servicing operations. In addition to the narrative, attach either:  1) a budget that provides an identified source of financing, for a period of at least 5 years, for contracting loan servicing with a third party who is in the business of loan servicing; 2) a commitment letter from a third party, who is in the business of loan servicing, willing to provide loan servicing at no cost to the applicant; or 3) the résumé of a current employee(s) of the applicant that describes the employee(s)’s experience in homeowner loan servicing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(d) Provide a brief description of the proposed program including: amount applied for, number of units or households to be assisted, income levels of households to be assisted, description of prior experience with the type of program applied for, and geographic location of the activities."]
[]
[" §7750(d)  Include Non-CalHome MA funding sources, descriptions, proposed lien positions, and amount in lines 1 through 6 below:"]
["Non-CalHome MA Funding Sources and Source/Description of contributed labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["§7750(f) Provide a brief description of how you will comply with the requirements for local administration set forth in §7721 applicable to the program or project being applied for."]
[]
["§7725(a)(1) Applicant certifies the CalHome Program loans to individual borrowers when considered with other available financing and assistance shall not exceed the minimum amount necessary to ensure affordable monthly housing costs as defined by the first mortgage lender."]
["§7728 The applicant shall have successfully administered a homebuyer program for a minimum of two years within the four years immediately preceding the application. Indicate qualifying experience below: (include the county where the program was administered in the dropdown under header Admin Years Assisted County)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
["Describe the homebuyer program you have successfully administered within the last four years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Years Assisted County",null,null,null,"Units Assisted",null,null,"Administration within last four years",null,null,null,null,null,"Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AN39:AN43)<=0,0,SUM(AN39:AN43))","v":0},null,null,null,{"$f":"SUM(AM39:AM43)","v":0},null,null,"Begin Date",null,null,"End Date",null,null,{"$f":"IF(SUM(AO39:AO43)<=0,0,SUM(AO39:AO43))","v":0},null,null,null,null,"Admin Years in Assisted County","Total Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF39>=$AM$36,AO39,0)","v":0},null,null,null,{"$f":"IF(AF39>=$AM$36,Z39,0)","v":0},{"$f":"IF(AF39=\"\",0,IF(AC39=\"\",0,IF(V39=Overview!$Z$26,IF(AC39<$AM$36,(AF39-$AM$36)/365,(AF39-AC39)/365),0)))","v":0},{"$f":"IF(AF39=\"\",0,IF(AC39=\"\",0,IF(AC39<$AM$36,(AF39-$AM$36)/365,(AF39-AC39)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF40>=$AM$36,AO40,0)","v":0},null,null,null,{"$f":"IF(AF40>=$AM$36,Z40,0)","v":0},{"$f":"IF(AF40=\"\",0,IF(AC40=\"\",0,IF(V40=Overview!$Z$26,IF(AC40<$AM$36,(AF40-$AM$36)/365,(AF40-AC40)/365),0)))","v":0},{"$f":"IF(AF40=\"\",0,IF(AC40=\"\",0,IF(AC40<$AM$36,(AF40-$AM$36)/365,(AF40-AC40)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF41>=$AM$36,AO41,0)","v":0},null,null,null,{"$f":"IF(AF41>=$AM$36,Z41,0)","v":0},{"$f":"IF(AF41=\"\",0,IF(AC41=\"\",0,IF(V41=Overview!$Z$26,IF(AC41<$AM$36,(AF41-$AM$36)/365,(AF41-AC41)/365),0)))","v":0},{"$f":"IF(AF41=\"\",0,IF(AC41=\"\",0,IF(AC41<$AM$36,(AF41-$AM$36)/365,(AF41-AC41)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF42>=$AM$36,AO42,0)","v":0},null,null,null,{"$f":"IF(AF42>=$AM$36,Z42,0)","v":0},{"$f":"IF(AF42=\"\",0,IF(AC42=\"\",0,IF(V42=Overview!$Z$26,IF(AC42<$AM$36,(AF42-$AM$36)/365,(AF42-AC42)/365),0)))","v":0},{"$f":"IF(AF42=\"\",0,IF(AC42=\"\",0,IF(AC42<$AM$36,(AF42-$AM$36)/365,(AF42-AC42)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF43>=$AM$36,AO43,0)","v":0},null,null,null,{"$f":"IF(AF43>=$AM$36,Z43,0)","v":0},{"$f":"IF(AF43=\"\",0,IF(AC43=\"\",0,IF(V43=Overview!$Z$26,IF(AC43<$AM$36,(AF43-$AM$36)/365,(AF43-AC43)/365),0)))","v":0},{"$f":"IF(AF43=\"\",0,IF(AC43=\"\",0,IF(AC43<$AM$36,(AF43-$AM$36)/365,(AF43-AC43)/365)))","v":0}]
["(Important Note:  Only complete this section, if the applicant meets the two-year minimum experience requirement for developing a project, which involves this type of contributed labor and all homeownership development units in the proposed project will utilize this type of construction.)"]
[" §7751(b)(5) Enter hours of Volunteer Labor, Self-Help Labor, Youth Construction Skills Training Program to the right:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours",null,null,null,"# Assisted Units utilizing this type of construction",null,null,null,"Hours per Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volunteer Labor §7751(b)(5)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA46/AE46,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-Help Construction Labor §7751(b)(5)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA47/AE47,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor provided by Youth Participating in a Construction Skills Training Program §7751(b)(5)(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA48/AE48,0)","v":0}]
["File Name:",null,null,"MA Labor Program Criteria",null,null,null,null,null,null,"As an attachment, describe the criteria for participation in your contributed labor program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"MA Labor Program Agreement",null,null,null,null,null,null,"Attach a copy of the agreement form used for the contributed labor program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"MA Labor Program Activities",null,null,null,null,null,null,"As an attachment, provide a description of activities performed by contributed labor participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"MA Labor Program Contracted",null,null,null,null,null,null,"As an attachment, provide a description of activities normally contracted out.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["What percentage of total onsite construction labor per unit will be performed by contributed labor?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["File Name:",null,null,"MA Contributed Labor Program",null,null,null,null,null,null,"Please provide evidence of previous administration of the type of contributed labor program proposed in this application.  This includes documentation of completed projects; a copy of the board resolution authorizing the program, supported by completed projects; or copies of contracts with contributed labor participants. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7729 Applicant certifies the CalHome funds in support of an MA program will be only be used for these eligible costs?"]
["§7730 Applicant certifies it will be responsible for these MA administrative activities?"]
["§7731 Applicant certifies it will develop and employ MA program underwriting guidelines as required in §7731(a) and shall comply with any additional underwriting requirements as deemed necessary by HCD. The MA guidelines must be submitted to and approved by HCD prior to execution of the Standard Agreement."]
["Selection Criteria §7751"]
["Total Self Score (minimum points required = 550; max points without bonus = 1,000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ61:AL66)","v":0}]
["Rating Factors (red shading indicates minimum score has not been achieved)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points"]
["Capability §7751(b)(1) - 400 Points Max (see NOFA)\nCapability to operate the local the proposed program, administer and conduct the self-help technical assistance project, or develop the type of homeownership project proposed in the application as follows (up to 400 points):\n(A) prior experience with administration/implementation of the type of program proposed in the application; or\n(B) prior experience in developing the type of homeownership development project or self-help technical assistance homeownership project as proposed in the application; and\n(C) prior experience with loan servicing or a plan to provide loan servicing/management capabilities. Number of rehab/reconstructed units assisted within the last four years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(AJ15=\"Yes\",AK22=\"Yes\"),AI38>=2),AM61,0)","v":0},null,null,{"$f":"IF(Z38>=11,400,IF(Z38>=6,300,IF(Z38>=1,200,0)))","v":0}]
["Community Need §7751(b)(2) - 150 Points\nCommunity need in a geographic area of the proposed local program or project will be based on one or more of the following factors: poverty level and overpayment for housing by low-income households, age of housing stock in the jurisdiction, numbers and percentages of substandard housing units, overcrowding of housing by tenure (including rental and ownership housing) in the jurisdiction, and percentages of households that are below poverty level and who are overcrowded and living in substandard housing Approved Regulations by tenure, as reflected in U.S. Census data; and the ratio between the median home sales price and the median household income in the jurisdiction. The specific community need factors that will apply to each activity will be identified in the NOFA. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",150)","v":"0"}]
["Feasibility §7751(b)(3) - 250 Points\nFeasibility for applications proposing a homeownership development project or a self-help technical assistance homeownership project will be based on U.S. Census Bureau data regarding percentage of low-income homeownership in a jurisdiction and the ratio of the CalHome appraised value limits relative to the CalHome median income for a four person household. The higher the percentage of low-income homeowners, the higher the points awarded. The higher the ratio of housing cost to income, the higher the points awarded.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",250)","v":"0"}]
["Community Revitalization §7751(b)(4) - 100 Points\nContributes to community revitalization defined as a program or project will be considered to contribute towards community revitalization if all units to be assisted with CalHome Program funds are, or will be, located within a federally defined Qualified Census Tract or a designated redevelopment area under the jurisdiction of a successor to a local redevelopment agency or meets a legislatively mandated priority for funds allocated to the CalHome Program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O9=\"Yes\",AK12=\"Yes\",AK13=\"Yes\"),100,0)","v":0}]
["Volunteer Labor, Self-Help Labor or Youth Construction Skills Training Program §7751(b)(5) - 100 Points\nApplications applying for homeownership development projects, self-help technical assistance homeownership projects, or a mortgage assistance local program for new construction housing or acquisition with rehabilitation when the recipient is acquiring and rehabilitating properties for sale to first-time homebuyers, will receive up to 100 points to the extent that they are utilizing:\n(A) volunteer or self-help construction labor, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided; or\n(B) labor provided by youth participating in a construction skills training program, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided. The five hundred (500) hours of construction training labor must be provided by the 16 to 24 year old program participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AI46:AL47)>=500,100,IF(AI48>=500,100,0))","v":0}]
["Performance Penalty §7751(c) - A deduction to the total score will be applied for failure to meet CalHome Program Performance Goals pursuant to §7755.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"OOR - Article 5","index":4,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":true,"merged":[[25,0,25,37],[27,1,27,28],[27,29,27,34],[27,35,27,37],[40,31,40,33],[39,25,39,27],[40,25,40,27],[36,0,37,20],[36,21,36,24],[37,21,37,24],[38,21,38,24],[39,21,39,24],[40,21,40,24],[38,0,38,20],[36,25,36,27],[37,25,37,27],[38,31,38,33],[39,28,39,30],[40,28,40,30],[39,31,39,33],[30,35,30,37],[31,1,31,28],[31,29,31,34],[40,34,40,37],[18,0,18,33],[18,35,18,37],[19,0,19,33],[19,35,19,37],[20,0,20,33],[20,35,20,37],[21,0,21,33],[21,35,21,37],[22,0,22,2],[22,3,22,9],[22,36,22,37],[56,0,56,34],[56,35,56,37],[54,0,54,34],[44,0,44,35],[44,36,44,37],[54,35,54,37],[46,0,46,35],[46,36,46,37],[45,0,45,35],[45,36,45,37],[47,36,47,37],[55,0,55,34],[55,35,55,37],[51,0,51,34],[51,35,51,37],[52,0,52,34],[52,35,52,37],[53,0,53,34],[53,35,53,37],[39,34,39,37],[38,34,38,37],[49,0,49,34],[50,0,50,34],[50,35,50,37],[36,34,36,37],[41,34,41,37],[48,0,48,37],[37,34,37,37],[49,35,49,37],[47,0,47,35],[43,36,43,37],[38,25,38,27],[41,31,41,33],[42,31,42,33],[41,25,41,27],[42,25,42,27],[41,0,41,20],[42,0,42,20],[42,28,42,30],[41,28,41,30],[41,21,41,24],[42,21,42,24],[36,28,36,33],[39,0,39,20],[40,0,40,20],[43,0,43,35],[0,0,0,34],[0,35,0,37],[4,0,4,17],[4,18,4,20],[42,34,42,37],[28,1,28,28],[28,29,28,34],[28,35,28,37],[29,1,29,28],[29,29,29,34],[29,35,29,37],[30,1,30,28],[30,29,30,34],[31,35,31,37],[32,1,32,28],[32,29,32,34],[32,35,32,37],[33,0,33,37],[34,0,34,37],[37,28,37,30],[37,31,37,33],[10,34,10,37],[11,26,11,29],[11,30,11,33],[11,34,11,37],[38,28,38,30],[4,21,4,31],[4,32,4,37],[9,26,9,29],[9,30,9,33],[9,34,9,37],[22,10,22,29],[22,30,22,35],[35,0,35,37],[23,0,23,37],[24,0,24,37],[26,0,26,28],[26,29,26,34],[26,35,26,37],[15,0,15,34],[15,35,15,37],[16,0,16,34],[16,35,16,37],[17,0,17,33],[17,35,17,37],[1,0,3,6],[1,7,1,13],[1,35,1,37],[3,7,3,13],[3,35,3,37],[2,7,2,13],[2,35,2,37],[1,14,1,34],[2,14,2,34],[3,14,3,34],[14,0,14,2],[14,3,14,9],[14,10,14,29],[14,30,14,35],[14,36,14,37],[12,0,12,35],[12,36,12,37],[13,0,13,35],[13,36,13,37],[6,0,6,17],[7,0,7,17],[8,0,8,17],[9,0,11,13],[9,14,11,15],[9,16,11,25],[5,25,5,31],[6,25,6,31],[7,25,7,31],[8,25,8,31],[5,18,5,24],[6,18,6,24],[7,18,7,24],[8,18,8,24],[10,26,10,29],[10,30,10,33]]}
["Owner-Occupied Rehabilitation (OOR) Program - Article 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["OOR Activity(ies) §7718(a)(2)",null,null,null,null,null,null,"OOR Activity #1",null,null,null,null,null,null,"Proposed # of Assisted units other than accessory dwelling units or manufactured housing units"]
[null,null,null,null,null,null,null,"OOR Activity #2",null,null,null,null,null,null,"Proposed # of Assisted manufactured units"]
[null,null,null,null,null,null,null,"OOR Activity #3",null,null,null,null,null,null,"Proposed # of Assisted accessory dwelling units and/or Assisted junior accessory dwelling units"]
["Number of Assisted units to be assisted with this application for CalHome funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ2:AL4)","v":0},null,null,"Approximate Allocation Remaining:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z27=\"\",\"\",IF(ISNUMBER(SEARCH(5,ProgramActivities)),Overview!Z27-Overview!P33,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OOR Funds Request",null,null,null,null,null,null,"OOR Maximum Eligible"]
["OOR Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S5*150000,0)","v":0}]
["OOR Activity Delivery Fee: §7729(d) (see NOFA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(S7=\"\",Z7*0.24,S7*0.24),0)","v":0}]
["Total OOR Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S7:Y8)","v":0},null,null,null,null,null,null,{"$f":"SUM(Z7:AF8)","v":0}]
["Will the program be operated entirely within federally defined Qualified Census Tracts (QCT)? (Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in QCTs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the program will be operated entirely within a QCT, specify those tracts to the right."]
[]
[]
["Will the program be operated entirely within a formerly designated redevelopment area previously under the jurisdiction of a local Redevelopment Agency?\n(Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in a formerly designated redevelopment area)"]
["Does the program meet a legislatively mandated priority for funds allocated to the CalHome Program?"]
["File Name:",null,null,"OOR Community Revitalization",null,null,null,null,null,null,"Documentation verifying the QCTs listed are current and federally recognized, or redevelopment area map that indicates property location(s), or documentation verifying the project meets a legislatively mandated priority.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7751(b)(1)(C) Do you have prior experience with or a plan to provide loan servicing / management?"]
["If Yes, how many homebuyer loans underwritten & closed on projects it's developed, which included preparation of loan documents within the last four (4) years?"]
[" a. Total number of homebuyer loans closed for which the applicant was the named beneficiary on the documents within the past four (4) years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[" b. As of the CalHome NOFA issuance date, the total number of homebuyer loans in the applicant's portfolio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[" c. Number of loans identified in (b) above that are being serviced by the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[" d. Number of loans identified in (b) above that are being serviced by a third party on behalf of the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d."]
[" e. As of the CalHome NOFA issuance date, the total number of homebuyer loans the applicant is servicing for another entity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e."]
["File Name:",null,null,"OOR Loan Servicing",null,null,null,null,null,null,"Submit a narrative identifying how loans will be serviced, how servicing activities will be funded or provided and procedures for implementing loan servicing operations. In addition to the narrative, attach either:  1) a budget that provides an identified source of financing, for a period of at least 5 years, for contracting loan servicing with a third party who is in the business of loan servicing; 2) a commitment letter from a third party, who is in the business of loan servicing, willing to provide loan servicing at no cost to the applicant; or 3) the résumé of a current employee(s) of the applicant that describes the employee(s)’s experience in homeowner loan servicing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(d) Provide a brief description of the proposed program including: amount applied for, number of units or households to be assisted, income levels of households to be assisted, description of prior experience with the type of program applied for, and geographic location of the activities."]
[]
[" §7750(d)  Include Non-CalHome MA funding sources, descriptions, proposed lien positions, and amount in lines 1 through 6 below:"]
["Non-CalHome OOR Funding Sources and Source",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["§7750(f) Provide a brief description of how you will comply with the requirements for local administration set forth in §7721 applicable to the program or project being applied for."]
[]
["§7732 Applicant must have successfully administered a local owner-occupied rehabilitation (OOR) program for a minimum of two years within the four years preceding the application. Indicate qualifying experience below, include county where the program was administered in yellow shaded cells under 'Admin Years Assisted County'.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
["Describe the OOR Program(s) you have successfully administered within the last four years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Years Assisted County",null,null,null,"Rehabs Completed",null,null,"Administration within last four years",null,null,null,null,null,"Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AN39:AN43)<=0,0,SUM(AN39:AN43))","v":0},null,null,null,{"$f":"SUM(AM39:AM43)","v":0},null,null,"Begin Date",null,null,"End Date",null,null,{"$f":"IF(SUM(AO39:AO43)<=0,0,SUM(AO39:AO43))","v":0},null,null,null,null,"Admin Years in Assisted County","Total Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF39>=$AM$36,AO39,0)","v":0},null,null,null,{"$f":"IF(AF39>=$AM$36,Z39,0)","v":0},{"$f":"IF(AF39=\"\",0,IF(AC39=\"\",0,IF(V39=Overview!$Z$26,IF(AC39<$AM$36,(AF39-$AM$36)/365,(AF39-AC39)/365),0)))","v":0},{"$f":"IF(AF39=\"\",0,IF(AC39=\"\",0,IF(AC39<$AM$36,(AF39-$AM$36)/365,(AF39-AC39)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF40>=$AM$36,AO40,0)","v":0},null,null,null,{"$f":"IF(AF40>=$AM$36,Z40,0)","v":0},{"$f":"IF(AF40=\"\",0,IF(AC40=\"\",0,IF(V40=Overview!$Z$26,IF(AC40<$AM$36,(AF40-$AM$36)/365,(AF40-AC40)/365),0)))","v":0},{"$f":"IF(AF40=\"\",0,IF(AC40=\"\",0,IF(AC40<$AM$36,(AF40-$AM$36)/365,(AF40-AC40)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF41>=$AM$36,AO41,0)","v":0},null,null,null,{"$f":"IF(AF41>=$AM$36,Z41,0)","v":0},{"$f":"IF(AF41=\"\",0,IF(AC41=\"\",0,IF(V41=Overview!$Z$26,IF(AC41<$AM$36,(AF41-$AM$36)/365,(AF41-AC41)/365),0)))","v":0},{"$f":"IF(AF41=\"\",0,IF(AC41=\"\",0,IF(AC41<$AM$36,(AF41-$AM$36)/365,(AF41-AC41)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF42>=$AM$36,AO42,0)","v":0},null,null,null,{"$f":"IF(AF42>=$AM$36,Z42,0)","v":0},{"$f":"IF(AF42=\"\",0,IF(AC42=\"\",0,IF(V42=Overview!$Z$26,IF(AC42<$AM$36,(AF42-$AM$36)/365,(AF42-AC42)/365),0)))","v":0},{"$f":"IF(AF42=\"\",0,IF(AC42=\"\",0,IF(AC42<$AM$36,(AF42-$AM$36)/365,(AF42-AC42)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF43>=$AM$36,AO43,0)","v":0},null,null,null,{"$f":"IF(AF43>=$AM$36,Z43,0)","v":0},{"$f":"IF(AF43=\"\",0,IF(AC43=\"\",0,IF(V43=Overview!$Z$26,IF(AC43<$AM$36,(AF43-$AM$36)/365,(AF43-AC43)/365),0)))","v":0},{"$f":"IF(AF43=\"\",0,IF(AC43=\"\",0,IF(AC43<$AM$36,(AF43-$AM$36)/365,(AF43-AC43)/365)))","v":0}]
["§7725(a)(2) We certify the OOR CalHome Program loans to individual borrowers when considered with other available financing and assistance shall not exceed the minimum amount necessary to fund eligible rehabilitation costs only, in accordance with program requirements."]
["§7733 Applicant certifies the CalHome funds in support of an OOR program will be only be used for these eligible costs?"]
["§7734 Applicant certifies it will be responsible for these OOR administrative activities?"]
["§7735 Applicant certifies it will develop and employ OOR underwriting guidelines as required in §7735(a) and shall comply with any additional underwriting requirements as deemed necessary by HCD. The OOR guidelines must be submitted to and approved by HCD prior to execution of the Standard Agreement."]
["§7735(b) Prior to commencement of rehabilitation work, Applicant will obtain an appraisal meeting all these requirements?"]
["Selection Criteria §7751"]
["Total Self Score (minimum points required = 550; max points without bonus = 1,000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ52:AL57)","v":0}]
["Rating Factors (red shading indicates minimum score has not been achieved)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points",null,null,{"$f":"IF(Z38>=11,400,IF(Z38>=6,300,IF(Z38>=1,300,0)))","v":0}]
["Capability §7751(b)(1) - 400 Points Max (see NOFA)\nCapability to operate the local the proposed program, administer and conduct the self-help technical assistance project, or develop the type of homeownership project proposed in the application as follows (up to 400 points):\n(A) prior experience with administration/implementation of the type of program proposed in the application; or\n(B) prior experience in developing the type of homeownership development project or self-help technical assistance homeownership project as proposed in the application; and\n(C) prior experience with loan servicing or a plan to provide loan servicing/management capabilities. Number of rehab/reconstructed units assisted within the last four years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(AJ16=\"Yes\",AK23=\"Yes\"),AI38>=2),AM51,0)","v":0}]
["Community Need §7751(b)(2) - 150 Points\nCommunity need in a geographic area of the proposed local program or project will be based on one or more of the following factors: poverty level and overpayment for housing by low-income households, age of housing stock in the jurisdiction, numbers and percentages of substandard housing units, overcrowding of housing by tenure (including rental and ownership housing) in the jurisdiction, and percentages of households that are below poverty level and who are overcrowded and living in substandard housing Approved Regulations by tenure, as reflected in U.S. Census data; and the ratio between the median home sales price and the median household income in the jurisdiction. The specific community need factors that will apply to each activity will be identified in the NOFA. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",150)","v":"0"}]
["Feasibility §7751(b)(3) - 250 Points\nFeasibility for applications proposing a homeownership development project or a self-help technical assistance homeownership project will be based on U.S. Census Bureau data regarding percentage of low-income homeownership in a jurisdiction and the ratio of the CalHome appraised value limits relative to the CalHome median income for a four person household. The higher the percentage of low-income homeowners, the higher the points awarded. The higher the ratio of housing cost to income, the higher the points awarded.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",250)","v":"0"}]
["Community Revitalization §7751(b)(4) - 100 Points\nContributes to community revitalization defined as a program or project will be considered to contribute towards community revitalization if all units to be assisted with CalHome Program funds are, or will be, located within a federally defined Qualified Census Tract or a designated redevelopment area under the jurisdiction of a successor to a local redevelopment agency or meets a legislatively mandated priority for funds allocated to the CalHome Program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O10=\"Yes\",AK13=\"Yes\",AK14=\"Yes\"),100,0)","v":0}]
["Volunteer Labor, Self-Help Labor or Youth Construction Skills Training Program §7751(b)(5) - 100 Points\nApplications applying for homeownership development projects, self-help technical assistance homeownership projects, or a mortgage assistance local program for new construction housing or acquisition with rehabilitation when the recipient is acquiring and rehabilitating properties for sale to first-time homebuyers, will receive up to 100 points to the extent that they are utilizing:\n(A) volunteer or self-help construction labor, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided; or\n(B) labor provided by youth participating in a construction skills training program, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided. The five hundred (500) hours of construction training labor must be provided by the 16 to 24 year old program participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Performance Penalty §7751(c) - A deduction to the total score will be applied for failure to meet CalHome Program Performance Goals pursuant to §7755.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"SHTA - Article 6","index":5,"n_rows":70,"n_cols":43,"rows_kept":70,"cut":false,"hidden":true,"merged":[[33,0,33,35],[33,36,33,37],[59,0,59,35],[59,36,59,37],[36,35,36,37],[37,35,37,37],[34,21,34,31],[35,21,35,31],[36,21,36,31],[37,21,37,31],[34,1,34,20],[35,1,35,20],[36,1,36,20],[37,1,37,20],[38,0,38,3],[38,4,38,9],[38,10,38,31],[38,32,38,35],[38,36,38,37],[37,32,37,34],[35,32,35,34],[36,32,36,34],[35,35,35,37],[34,35,34,37],[34,32,34,34],[69,0,69,34],[69,35,69,37],[62,35,62,37],[65,0,65,34],[65,35,65,37],[54,0,54,2],[54,3,54,9],[54,10,54,29],[54,30,54,35],[54,36,54,37],[66,0,66,34],[66,35,66,37],[67,35,67,37],[67,0,67,34],[68,0,68,34],[68,35,68,37],[62,0,62,34],[63,0,63,34],[63,35,63,37],[64,0,64,34],[64,35,64,37],[61,0,61,37],[56,35,56,37],[43,34,43,37],[42,34,42,37],[39,0,39,37],[40,28,40,33],[41,28,41,30],[41,31,41,33],[42,28,42,30],[40,25,40,27],[46,25,46,27],[40,21,40,24],[41,21,41,24],[43,28,43,30],[44,28,44,30],[45,28,45,30],[46,28,46,30],[43,21,43,24],[44,21,44,24],[45,21,45,24],[46,21,46,24],[41,25,41,27],[42,25,42,27],[43,25,43,27],[44,25,44,27],[46,34,46,37],[48,0,51,13],[49,14,49,25],[50,14,50,25],[51,14,51,25],[48,26,48,29],[47,0,47,37],[48,34,48,37],[49,34,49,37],[50,34,50,37],[51,34,51,37],[41,34,41,37],[45,34,45,37],[7,26,7,29],[7,30,7,33],[7,34,7,37],[30,0,30,37],[31,0,31,37],[24,29,24,34],[24,35,24,37],[25,1,25,28],[25,29,25,34],[25,35,25,37],[26,1,26,28],[26,29,26,34],[20,36,20,37],[15,0,15,33],[15,35,15,37],[16,0,16,33],[16,35,16,37],[17,0,17,33],[29,29,29,34],[29,35,29,37],[27,29,27,34],[27,35,27,37],[0,0,0,34],[0,35,0,37],[32,0,32,35],[32,36,32,37],[58,0,58,35],[58,36,58,37],[23,0,23,28],[23,29,23,34],[23,35,23,37],[21,0,21,37],[22,0,22,37],[44,34,44,37],[48,30,48,33],[49,26,49,29],[50,26,50,29],[51,26,51,29],[9,30,9,33],[9,34,9,37],[28,1,28,28],[28,29,28,34],[28,35,28,37],[11,0,11,35],[11,36,11,37],[24,1,24,28],[60,0,60,35],[60,36,60,37],[27,1,27,28],[1,0,1,17],[1,18,1,20],[1,21,1,31],[1,32,1,37],[2,25,2,31],[5,36,5,37],[6,0,6,2],[6,3,6,9],[6,10,6,29],[6,30,6,35],[6,36,6,37],[10,0,10,35],[20,0,20,2],[20,3,20,9],[20,10,20,29],[20,30,20,35],[10,36,10,37],[8,26,8,29],[8,30,8,33],[8,34,8,37],[9,26,9,29],[17,35,17,37],[18,0,18,33],[18,35,18,37],[19,0,19,33],[19,35,19,37],[12,0,12,2],[12,3,12,9],[12,10,12,29],[12,30,12,35],[12,36,12,37],[13,0,13,34],[13,35,13,37],[14,0,14,34],[14,35,14,37],[52,0,52,2],[52,3,52,9],[52,10,52,29],[52,30,52,35],[52,36,52,37],[26,35,26,37],[42,0,42,20],[43,0,43,20],[44,0,44,20],[45,0,45,20],[46,0,46,20],[40,0,41,20],[42,31,42,33],[43,31,43,33],[44,31,44,33],[45,31,45,33],[46,31,46,33],[42,21,42,24],[49,30,49,33],[50,30,50,33],[51,30,51,33],[45,25,45,27],[40,34,40,37],[29,1,29,28],[57,3,57,9],[57,10,57,29],[57,30,57,35],[57,36,57,37],[56,0,56,34],[53,0,53,2],[53,3,53,9],[53,10,53,29],[53,30,53,35],[53,36,53,37],[55,0,55,2],[55,3,55,9],[55,10,55,29],[55,30,55,35],[55,36,55,37],[57,0,57,2],[4,25,4,31],[2,18,2,24],[3,18,3,24],[4,18,4,24],[3,0,3,17],[4,0,4,17],[7,0,9,13],[7,14,9,15],[7,16,9,25],[3,25,3,31],[5,0,5,35]]}
["Self-Help Technical Assistance Project (SHTA) - Article 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["Number of Assisted units to be assisted with this application for CalHome funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximate Allocation Remaining:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z27=\"\",\"\",IF(ISNUMBER(SEARCH(6,ProjectActivities)),Overview!Z27-Overview!P36,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHTA Funds Request",null,null,null,null,null,null,"SHTA Maximum Eligible"]
["SHTA Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S2*100000,0)","v":0}]
["Total SHTA Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S4","v":0},null,null,null,null,null,null,{"$f":"Z4","v":0}]
["Does the applicant currently provide homebuyer education classes?"]
["File Name:",null,null,"SHTA Homebuyer Education",null,null,null,null,null,null,"If not currently providing classes describe arrangements for providing homebuyer education.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Will the program be operated entirely within federally defined Qualified Census Tracts (QCT)? (Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in QCTs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the program will be operated entirely within a QCT, specify those tracts to the right."]
[]
[]
["Will the entire project be within a formerly designated redevelopment area previously under the jurisdiction of a local Redevelopment Agency?\n(Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in a formerly designated redevelopment area)"]
["Does the program meet a legislatively mandated priority for funds allocated to the CalHome Program?"]
["File Name:",null,null,"SHTA Community Revitalization",null,null,null,null,null,null,"Documentation verifying the QCTs listed are current and federally recognized, or redevelopment area map that indicates property location(s), or documentation verifying the project meets a legislatively mandated priority.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7751(b)(1)(C) Do you have prior experience with or a plan to provide loan servicing / management?"]
["If Yes, how many homebuyer loans underwritten & closed on projects it's developed, which included preparation of loan documents within the last four (4) years?"]
[" a. Total number of homebuyer loans closed for which the applicant was the named beneficiary on the documents within the past four (4) years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[" b. As of the CalHome NOFA issuance date, the total number of homebuyer loans in the applicant's portfolio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[" c. Number of loans identified in (b) above that are being serviced by the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[" d. Number of loans identified in (b) above that are being serviced by a third party on behalf of the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d."]
[" e. As of the CalHome NOFA issuance date, the total number of homebuyer loans the applicant is servicing for another entity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e."]
["File Name:",null,null,"SHTA Loan Servicing",null,null,null,null,null,null,"Submit a narrative identifying how loans will be serviced, how servicing activities will be funded or provided and procedures for implementing loan servicing operations. In addition to the narrative, attach either:  1) a budget that provides an identified source of financing, for a period of at least 5 years, for contracting loan servicing with a third party who is in the business of loan servicing; 2) a commitment letter from a third party, who is in the business of loan servicing, willing to provide loan servicing at no cost to the applicant; or 3) the résumé of a current employee(s) of the applicant that describes the employee(s)’s experience in homeowner loan servicing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(d) Provide a brief description of the proposed program including: amount applied for, number of units or households to be assisted, income levels of households to be assisted, description of prior experience with the type of program applied for, and geographic location of the activities."]
[]
["§7750(d) Non-CalHome SHTA Funding Sources and Source/Description of contributed labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["§7750(f) Provide a brief description of how you will comply with the requirements for local administration set forth in §7721 applicable to the program or project being applied for."]
[]
["§7736 We certify the applying entity meets the criteria set forth in CCR, Title 25, Division 1, Chapter 7, Subchapter 6.5, Article 1, §7532 \"Eligible Sponsors\"."]
["§7736 Applicant certifies they successfully completed a minimum of two self-help, new construction projects within the four years preceding the application?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
[null,"Name and describe the self-help new construction projects you have successfully administered/completed within the last four years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Address and City",null,null,null,null,null,null,null,null,null,null,"County",null,null,"End Date",null,null,null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M36=\"Yes\",AN36=1,R36>$AN$25,P36>=5,$AI$8>=0.7),1,0)","v":0},{"$f":"IF(B36<>\"\",1,0)","v":0},null,{"$f":"IF(AJ36=\"\",0,IF(AJ36<$AP$35,1,0))","v":0},{"$f":"IF(AG36=\"\",0,IF(AG36=Overview!$Z$26,0,1))","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M37=\"Yes\",AN37=1,R37>$AN$25,P37>=5,$AI$8>=0.7),1,0)","v":0},{"$f":"IF(B37<>\"\",1,0)","v":0},null,{"$f":"IF(AJ37=\"\",0,IF(AJ37<$AP$35,1,0))","v":0},{"$f":"IF(AG37=\"\",0,IF(AG37=Overview!$Z$26,0,1))","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M38=\"Yes\",AN38=1,R38>$AN$25,P38>=5,$AI$8>=0.7),1,0)","v":0},{"$f":"IF(B38<>\"\",1,0)","v":0},null,{"$f":"IF(AJ38=\"\",0,IF(AJ38<$AP$35,1,0))","v":0},{"$f":"IF(AG38=\"\",0,IF(AG38=Overview!$Z$26,0,1))","v":0}]
["File Name:",null,null,null,"Dev Compl. 1, 2, 3, etc",null,null,null,null,null,"*Document with Notice of Completion, Placed in Service, Certificate of Occupancy or equivalent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["§7736 The applicant shall have successfully completed a minimum of two self-help, new construction projects within the four years immediately preceding the application. Indicate qualifying experience below: (include the county where the program was administered in the dropdown under header Admin Years Assisted County)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
["Describe the Self-Help Projects you have successfully administered within the last four years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Years Assisted County",null,null,null,"Units Assisted",null,null,"Completion within last four years",null,null,null,null,null,"Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AN43:AN47)<=0,0,SUM(AN43:AN47))","v":0},null,null,null,{"$f":"SUM(AM43:AM47)","v":0},null,null,"Begin Date",null,null,"End Date",null,null,{"$f":"SUM(AO43:AO47)","v":0},null,null,null,null,"Admin Years in Assisted County","Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF43>=$AM$40,AO43,0)","v":0},null,null,null,{"$f":"IF(AF43>=$AM$40,Z43,0)","v":0},{"$f":"IF(AF43=\"\",0,IF(AC43=\"\",0,IF(V43=Overview!$Z$26,IF(AC43<$AM$40,(AF43-$AM$40)/365,(AF43-AC43)/365),0)))","v":0},{"$f":"IF(AF43=\"\",0,IF(AC43=\"\",0,IF(AC43<$AM$40,(AF43-$AM$40)/365,(AF43-AC43)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF44>=$AM$40,AO44,0)","v":0},null,null,null,{"$f":"IF(AF44>=$AM$40,Z44,0)","v":0},{"$f":"IF(AF44=\"\",0,IF(AC44=\"\",0,IF(V44=Overview!$Z$26,IF(AC44<$AM$40,(AF44-$AM$40)/365,(AF44-AC44)/365),0)))","v":0},{"$f":"IF(AF44=\"\",0,IF(AC44=\"\",0,IF(AC44<$AM$40,(AF44-$AM$40)/365,(AF44-AC44)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF45>=$AM$40,AO45,0)","v":0},null,null,null,{"$f":"IF(AF45>=$AM$40,Z45,0)","v":0},{"$f":"IF(AF45=\"\",0,IF(AC45=\"\",0,IF(V45=Overview!$Z$26,IF(AC45<$AM$40,(AF45-$AM$40)/365,(AF45-AC45)/365),0)))","v":0},{"$f":"IF(AF45=\"\",0,IF(AC45=\"\",0,IF(AC45<$AM$40,(AF45-$AM$40)/365,(AF45-AC45)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF46>=$AM$40,AO46,0)","v":0},null,null,null,{"$f":"IF(AF46>=$AM$40,Z46,0)","v":0},{"$f":"IF(AF46=\"\",0,IF(AC46=\"\",0,IF(V46=Overview!$Z$26,IF(AC46<$AM$40,(AF46-$AM$40)/365,(AF46-AC46)/365),0)))","v":0},{"$f":"IF(AF46=\"\",0,IF(AC46=\"\",0,IF(AC46<$AM$40,(AF46-$AM$40)/365,(AF46-AC46)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF47>=$AM$40,AO47,0)","v":0},null,null,null,{"$f":"IF(AF47>=$AM$40,Z47,0)","v":0},{"$f":"IF(AF47=\"\",0,IF(AC47=\"\",0,IF(V47=Overview!$Z$26,IF(AC47<$AM$40,(AF47-$AM$40)/365,(AF47-AC47)/365),0)))","v":0},{"$f":"IF(AF47=\"\",0,IF(AC47=\"\",0,IF(AC47<$AM$40,(AF47-$AM$40)/365,(AF47-AC47)/365)))","v":0}]
["(Important Note:  Only complete this section, if the applicant meets the two-year minimum experience requirement for developing a project, which involves this type of contributed labor and all homeownership development units in the proposed project will utilize this type of construction.)"]
[" §7751(b)(5) Enter hours of Volunteer Labor, Self-Help Labor, Youth Construction Skills Training Program to the right:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours",null,null,null,"# Assisted Units",null,null,null,"Hours per Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volunteer Labor §7751(b)(5)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA50/AE50,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-Help Construction Labor §7751(b)(5)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA51/AE51,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor provided by Youth Participating in a Construction Skills Training Program §7751(b)(5)(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA52/AE52,0)","v":0}]
["File Name:",null,null,"SHTA Labor Program Criteria",null,null,null,null,null,null,"As an attachment, describe the criteria for participation in your contributed labor program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"SHTA Labor Program Agreement",null,null,null,null,null,null,"Attach a copy of the agreement form used for the contributed labor program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"SHTA Labor Program Activities",null,null,null,null,null,null,"As an attachment, provide a description of activities performed by contributed labor participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"SHTA Labor Program Contracted",null,null,null,null,null,null,"As an attachment, provide a description of activities normally contracted out.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["What percentage of total onsite construction labor per unit will be performed by contributed labor?"]
["File Name:",null,null,"SHTA Contributed Labor Program",null,null,null,null,null,null,"Please provide evidence of previous administration of the type of contributed labor program proposed in this application.  This includes documentation of completed projects; a copy of the board resolution authorizing the program, supported by completed projects; or copies of contracts with contributed labor participants. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7737 Applicant certifies the CalHome funds in support of a SHTA project will be only be used for these eligible costs?"]
["§7738 Applicant certifies it will develop and employ SHTA underwriting guidelines as required in §7738(a) and shall comply with any additional underwriting requirements as deemed necessary by HCD. The SHTA guidelines must be submitted to and approved by HCD prior to execution of the Standard Agreement."]
["§7738 Applicant certifies it will develop and employ SHTA underwriting guidelines as required in §7738(a) and shall comply with any additional underwriting requirements as deemed necessary by HCD. The SHTA guidelines must be submitted to and approved by HCD prior to execution of the Standard Agreement."]
["Selection Criteria §7751"]
["Total Self Score (minimum points required = 550; max points without bonus = 1,000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ65:AL70)","v":0},null,null,{"$f":"IF(Z42>=21,400,IF(Z42>=11,300,IF(Z42>=1,200,0)))","v":0}]
["Rating Factors (red shading indicates minimum score has not been achieved)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points"]
["Capability §7751(b)(1) - 400 Points Max (see NOFA)\nCapability to operate the local the proposed program, administer and conduct the self-help technical assistance project, or develop the type of homeownership project proposed in the application as follows (up to 400 points):\n(A) prior experience with administration/implementation of the type of program proposed in the application; or\n(B) prior experience in developing the type of homeownership development project or self-help technical assistance homeownership project as proposed in the application; and\n(C) prior experience with loan servicing or a plan to provide loan servicing/management capabilities. Number of rehab/reconstructed units assisted within the last four years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(AJ14=\"Yes\",AK21=\"Yes\"),AI42>=2),AM63,0)","v":0}]
["Community Need §7751(b)(2) - 150 Points\nCommunity need in a geographic area of the proposed local program or project will be based on one or more of the following factors: poverty level and overpayment for housing by low-income households, age of housing stock in the jurisdiction, numbers and percentages of substandard housing units, overcrowding of housing by tenure (including rental and ownership housing) in the jurisdiction, and percentages of households that are below poverty level and who are overcrowded and living in substandard housing Approved Regulations by tenure, as reflected in U.S. Census data; and the ratio between the median home sales price and the median household income in the jurisdiction. The specific community need factors that will apply to each activity will be identified in the NOFA. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",150)","v":"0"}]
["Feasibility §7751(b)(3) - 250 Points\nFeasibility for applications proposing a homeownership development project or a self-help technical assistance homeownership project will be based on U.S. Census Bureau data regarding percentage of low-income homeownership in a jurisdiction and the ratio of the CalHome appraised value limits relative to the CalHome median income for a four person household. The higher the percentage of low-income homeowners, the higher the points awarded. The higher the ratio of housing cost to income, the higher the points awarded.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",250)","v":"0"}]
["Community Revitalization §7751(b)(4) - 100 Points\nContributes to community revitalization defined as a program or project will be considered to contribute towards community revitalization if all units to be assisted with CalHome Program funds are, or will be, located within a federally defined Qualified Census Tract or a designated redevelopment area under the jurisdiction of a successor to a local redevelopment agency or meets a legislatively mandated priority for funds allocated to the CalHome Program.\n(If Yes, attach supporting documentation.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O8=\"Yes\",AK11=\"Yes\",AK12=\"Yes\"),100,0)","v":0}]
["Volunteer Labor, Self-Help Labor or Youth Construction Skills Training Program §7751(b)(5) - 100 Points\nApplications applying for homeownership development projects, self-help technical assistance homeownership projects, or a mortgage assistance local program for new construction housing or acquisition with rehabilitation when the recipient is acquiring and rehabilitating properties for sale to first-time homebuyers, will receive up to 100 points to the extent that they are utilizing:\n(A) volunteer or self-help construction labor, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided; or\n(B) labor provided by youth participating in a construction skills training program, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided. The five hundred (500) hours of construction training labor must be provided by the 16 to 24 year old program participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AI50:AL51)>=500,100,IF(AI52>=500,100,0))","v":0}]
["Performance Penalty §7751(c) - A deduction to the total score will be applied for failure to meet CalHome Program Performance Goals pursuant to §7755.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"SHP - Article 7","index":6,"n_rows":49,"n_cols":41,"rows_kept":49,"cut":false,"hidden":true,"merged":[[1,21,1,31],[1,32,1,37],[18,0,18,2],[18,3,18,9],[18,10,18,29],[18,30,18,35],[18,36,18,37],[13,0,13,33],[31,0,32,20],[24,35,24,37],[25,1,25,28],[25,29,25,34],[26,1,26,28],[26,29,26,34],[26,35,26,37],[27,1,27,28],[27,29,27,34],[7,26,7,29],[7,30,7,33],[7,34,7,37],[16,0,16,33],[16,35,16,37],[17,0,17,33],[17,35,17,37],[35,31,35,33],[35,25,35,27],[31,34,31,37],[32,34,32,37],[34,34,34,37],[31,28,31,33],[35,21,35,24],[0,0,0,34],[0,35,0,37],[25,35,25,37],[19,0,19,37],[20,0,20,37],[24,1,24,28],[21,0,21,28],[21,29,21,34],[21,35,21,37],[22,1,22,28],[22,29,22,34],[22,35,22,37],[23,1,23,28],[5,26,5,29],[1,0,1,17],[1,18,1,20],[24,29,24,34],[48,0,48,34],[48,35,48,37],[45,0,45,34],[45,35,45,37],[46,35,46,37],[46,0,46,34],[47,0,47,34],[47,35,47,37],[38,36,38,37],[43,0,43,34],[43,35,43,37],[44,0,44,34],[44,35,44,37],[42,0,42,34],[42,35,42,37],[41,35,41,37],[41,0,41,34],[37,0,37,20],[40,0,40,37],[37,28,37,30],[37,31,37,33],[37,25,37,27],[37,21,37,24],[39,0,39,35],[39,36,39,37],[38,0,38,35],[37,34,37,37],[36,31,36,33],[27,35,27,37],[28,0,28,37],[29,0,29,37],[32,28,32,30],[32,31,32,33],[33,28,33,30],[33,31,33,33],[34,28,34,30],[34,31,34,33],[31,25,31,27],[32,25,32,27],[33,25,33,27],[34,25,34,27],[36,34,36,37],[35,34,35,37],[35,28,35,30],[36,21,36,24],[36,0,36,20],[36,28,36,30],[36,25,36,27],[33,0,33,20],[34,0,34,20],[35,0,35,20],[3,0,3,17],[4,0,4,17],[5,0,7,13],[5,14,7,15],[5,16,7,25],[5,30,5,33],[33,21,33,24],[34,21,34,24],[8,0,8,35],[9,0,9,35],[10,0,10,2],[10,3,10,9],[10,10,10,29],[10,30,10,35],[11,0,11,34],[11,35,11,37],[12,0,12,34],[12,35,12,37],[13,35,13,37],[14,0,14,33],[30,0,30,37],[33,34,33,37],[23,29,23,34],[23,35,23,37],[5,34,5,37],[6,26,6,29],[6,30,6,33],[6,34,6,37],[31,21,32,24],[2,25,2,31],[3,25,3,31],[4,25,4,31],[2,18,2,24],[3,18,3,24],[4,18,4,24],[8,36,8,37],[9,36,9,37],[10,36,10,37],[14,35,14,37],[15,0,15,33],[15,35,15,37]]}
["Shared Housing Program (SHP) - Article 7  (Technical Assistance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["Number of Assisted units to be assisted with this application for CalHome funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximate Allocation Remaining:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z27=\"\",\"\",IF(ISNUMBER(SEARCH(7,ProgramActivities)),Overview!Z27-Overview!P33,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHP Funds Request",null,null,null,null,null,null,"SHP Maximum Eligible"]
["SHP Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S2*100000,0)","v":0}]
["Total SHP Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S4","v":0},null,null,null,null,null,null,{"$f":"Z4","v":0}]
["Will the program be operated entirely within federally defined Qualified Census Tracts (QCT)? (Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in QCTs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the program will be operated entirely within a QCT, specify those tracts to the right."]
[]
[]
["Will the program be operated entirely within a formerly designated redevelopment area previously under the jurisdiction of a local Redevelopment Agency?\n(Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in a formerly designated redevelopment area)"]
["Does the program meet a legislatively mandated priority for funds allocated to the CalHome Program?"]
["File Name:",null,null,"SHP Community Revitalization",null,null,null,null,null,null,"Documentation verifying the QCTs listed are current and federally recognized, or redevelopment area map that indicates property location(s), or documentation verifying the project meets a legislatively mandated priority.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7751(b)(1)(C) Do you have prior experience with or a plan to provide loan servicing / management?"]
["If Yes, how many homebuyer loans underwritten & closed on projects it's developed, which included preparation of loan documents within the last four (4) years?"]
[" a. Total number of homebuyer loans closed for which the applicant was the named beneficiary on the documents within the past four (4) years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[" b. As of the CalHome NOFA issuance date, the total number of homebuyer loans in the applicant's portfolio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[" c. Number of loans identified in (b) above that are being serviced by the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[" d. Number of loans identified in (b) above that are being serviced by a third party on behalf of the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d."]
[" e. As of the CalHome NOFA issuance date, the total number of homebuyer loans the applicant is servicing for another entity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e."]
["File Name:",null,null,"SHP Loan Servicing",null,null,null,null,null,null,"Submit a narrative identifying how loans will be serviced, how servicing activities will be funded or provided and procedures for implementing loan servicing operations. In addition to the narrative, attach either:  1) a budget that provides an identified source of financing, for a period of at least 5 years, for contracting loan servicing with a third party who is in the business of loan servicing; 2) a commitment letter from a third party, who is in the business of loan servicing, willing to provide loan servicing at no cost to the applicant; or 3) the résumé of a current employee(s) of the applicant that describes the employee(s)’s experience in homeowner loan servicing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(d) Provide a brief description of the proposed program including: amount applied for, number of units or households to be assisted, income levels of households to be assisted, description of prior experience with the type of program applied for, geographic location of the activities, financing sources and uses, and description of any contributed labor."]
[]
["§7750(d) Non-CalHome SHP Funding Sources and Source/Description of contributed labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["§7750(f) Provide a brief description of how you will comply with the requirements for local administration set forth in §7721 applicable to the program or project being applied for."]
[]
["§7739 The applicant shall have successfully administered a shared housing program for a minimum of two years immediately preceding the application. Indicate qualifying experience below, include county where the program was administered in yellow shaded cells under 'Admin Years Assisted County'.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
["Describe the Shared Housing Programs you have successfully administered immediately preceding the application",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Years Assisted County",null,null,null,"Units Assisted",null,null,"Administration within last two years",null,null,null,null,null,"Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AM34:AM38)","v":0},null,null,"Begin Date",null,null,"End Date",null,null,{"$f":"SUM(AI34:AL38)","v":0},null,null,null,null,"Admin Years in Assisted County","Total Admin Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AC34=\"\",AF34=\"\"),0,AF34-AC34)/365","v":0},null,null,null,{"$f":"IF(AF34>=$AM$31,Z34,0)","v":0},{"$f":"IF(AF34=\"\",0,IF(AC34=\"\",0,IF(V34=Overview!$Z$26,IF(AC34<$AM$31,(AF34-$AM$31)/365,(AF34-AC34)/365),0)))","v":0},{"$f":"IF(AF34=\"\",0,IF(AC34=\"\",0,IF(AC34<$AM$31,(AF34-$AM$31)/365,(AF34-AC34)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AC35=\"\",AF35=\"\"),0,AF35-AC35)/365","v":0},null,null,null,{"$f":"IF(AF35>=$AM$31,Z35,0)","v":0},{"$f":"IF(AF35=\"\",0,IF(AC35=\"\",0,IF(V35=Overview!$Z$26,IF(AC35<$AM$31,(AF35-$AM$31)/365,(AF35-AC35)/365),0)))","v":0},{"$f":"IF(AF35=\"\",0,IF(AC35=\"\",0,IF(AC35<$AM$31,(AF35-$AM$31)/365,(AF35-AC35)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AF36>=$AM$31,Z36,0)","v":0},{"$f":"IF(AF36=\"\",0,IF(AC36=\"\",0,IF(V36=Overview!$Z$26,IF(AC36<$AM$31,(AF36-$AM$31)/365,(AF36-AC36)/365),0)))","v":0},{"$f":"IF(AF36=\"\",0,IF(AC36=\"\",0,IF(AC36<$AM$31,(AF36-$AM$31)/365,(AF36-AC36)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AF37>=$AM$31,Z37,0)","v":0},{"$f":"IF(AF37=\"\",0,IF(AC37=\"\",0,IF(V37=Overview!$Z$26,IF(AC37<$AM$31,(AF37-$AM$31)/365,(AF37-AC37)/365),0)))","v":0},{"$f":"IF(AF37=\"\",0,IF(AC37=\"\",0,IF(AC37<$AM$31,(AF37-$AM$31)/365,(AF37-AC37)/365)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AF38>=$AM$31,Z38,0)","v":0},{"$f":"IF(AF38=\"\",0,IF(AC38=\"\",0,IF(V38=Overview!$Z$26,IF(AC38<$AM$31,(AF38-$AM$31)/365,(AF38-AC38)/365),0)))","v":0},{"$f":"IF(AF38=\"\",0,IF(AC38=\"\",0,IF(AC38<$AM$31,(AF38-$AM$31)/365,(AF38-AC38)/365)))","v":0}]
["§7740 Applicant certifies the CalHome funds in support of a SHP program will be only be used for the eligible costs in §7740?"]
["§7741 Applicant certifies it will follow these administrative requirements and comply with any additional underwriting requirements as deemed necessary by HCD? "]
["Selection Criteria §7751"]
["Total Self Score (minimum points required = 550; max points without bonus = 1,000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ44:AL49)","v":0}]
["Rating Factors (red shading indicates minimum score has not been achieved)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points"]
["Capability §7751(b)(1) - 400 Points Max (see NOFA)\nCapability to operate the local the proposed program, administer and conduct the self-help technical assistance project, or develop the type of homeownership project proposed in the application as follows (up to 400 points):\n(A) prior experience with administration/implementation of the type of program proposed in the application; or\n(B) prior experience in developing the type of homeownership development project or self-help technical assistance homeownership project as proposed in the application; and\n(C) prior experience with loan servicing or a plan to provide loan servicing/management capabilities. Number of rehab/reconstructed units assisted within the last four years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(AJ12=\"Yes\",AK19=\"Yes\"),AI33>=2),AM44,0)","v":0},null,null,{"$f":"IF(Z33>=5,400,IF(Z33>=3,300,IF(Z33>=1,200,0)))","v":0}]
["Community Need §7751(b)(2) - 150 Points\nCommunity need in a geographic area of the proposed local program or project will be based on one or more of the following factors: poverty level and overpayment for housing by low-income households, age of housing stock in the jurisdiction, numbers and percentages of substandard housing units, overcrowding of housing by tenure (including rental and ownership housing) in the jurisdiction, and percentages of households that are below poverty level and who are overcrowded and living in substandard housing Approved Regulations by tenure, as reflected in U.S. Census data; and the ratio between the median home sales price and the median household income in the jurisdiction. The specific community need factors that will apply to each activity will be identified in the NOFA. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",150)","v":"0"}]
["Feasibility §7751(b)(3) - 250 Points\nFeasibility for applications proposing a homeownership development project or a self-help technical assistance homeownership project will be based on U.S. Census Bureau data regarding percentage of low-income homeownership in a jurisdiction and the ratio of the CalHome appraised value limits relative to the CalHome median income for a four person household. The higher the percentage of low-income homeowners, the higher the points awarded. The higher the ratio of housing cost to income, the higher the points awarded.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",250)","v":"0"}]
["Community Revitalization §7751(b)(4) - 100 Points\nContributes to community revitalization defined as a program or project will be considered to contribute towards community revitalization if all units to be assisted with CalHome Program funds are, or will be, located within a federally defined Qualified Census Tract or a designated redevelopment area under the jurisdiction of a successor to a local redevelopment agency or meets a legislatively mandated priority for funds allocated to the CalHome Program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O6=\"Yes\",AK9=\"Yes\",AK10=\"Yes\"),100,0)","v":0}]
["Volunteer Labor, Self-Help Labor or Youth Construction Skills Training Program §7751(b)(5) - 100 Points\nApplications applying for homeownership development projects, self-help technical assistance homeownership projects, or a mortgage assistance local program for new construction housing or acquisition with rehabilitation when the recipient is acquiring and rehabilitating properties for sale to first-time homebuyers, will receive up to 100 points to the extent that they are utilizing:\n(A) volunteer or self-help construction labor, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided; or\n(B) labor provided by youth participating in a construction skills training program, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided. The five hundred (500) hours of construction training labor must be provided by the 16 to 24 year old program participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Performance Penalty §7751(c) - A deduction to the total score will be applied for failure to meet CalHome Program Performance Goals pursuant to §7755.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"PDL - Article 8","index":7,"n_rows":158,"n_cols":41,"rows_kept":158,"cut":false,"hidden":true,"merged":[[93,36,93,37],[91,19,91,21],[97,0,97,2],[84,12,84,19],[85,12,85,19],[115,25,116,28],[107,34,107,37],[108,34,108,37],[109,34,109,37],[110,34,110,37],[111,34,111,37],[112,34,112,37],[106,34,106,37],[113,34,113,37],[106,0,106,33],[107,0,107,33],[108,0,108,33],[109,0,109,33],[110,0,110,33],[111,0,111,33],[112,0,112,33],[84,20,84,23],[85,20,85,23],[97,10,97,29],[93,0,93,2],[93,3,93,9],[93,10,93,29],[93,30,93,35],[95,24,95,25],[95,26,95,31],[146,0,146,2],[146,3,146,9],[146,10,146,29],[146,30,146,35],[115,29,115,33],[119,21,119,24],[103,8,104,9],[103,0,104,7],[120,25,120,28],[121,25,121,28],[116,29,116,33],[117,29,117,33],[118,29,118,33],[119,29,119,33],[120,29,120,33],[121,29,121,33],[117,25,117,28],[118,25,118,28],[146,36,146,37],[136,0,136,35],[136,36,136,37],[127,34,127,37],[145,36,145,37],[137,25,137,33],[144,0,144,2],[144,3,144,9],[145,0,145,2],[144,30,144,35],[145,3,145,9],[145,10,145,29],[145,30,145,35],[139,14,139,24],[139,26,139,36],[142,0,142,37],[143,0,143,37],[137,34,137,37],[144,36,144,37],[134,0,134,35],[144,10,144,29],[135,0,135,35],[141,18,141,20],[141,0,141,17],[119,25,119,28],[113,0,113,33],[120,0,120,20],[103,10,104,15],[80,0,80,37],[71,0,71,37],[73,0,73,37],[72,0,72,37],[75,0,75,2],[75,3,75,9],[75,10,75,29],[75,30,75,35],[75,36,75,37],[90,0,90,37],[91,32,91,35],[96,26,96,31],[98,0,98,37],[99,8,99,9],[99,0,99,7],[99,10,100,15],[99,16,100,37],[97,3,97,9],[97,30,97,35],[97,36,97,37],[37,0,37,35],[37,36,37,37],[74,0,74,4],[74,5,74,18],[74,19,74,20],[39,16,39,18],[39,19,39,31],[39,32,39,37],[35,0,35,2],[36,0,36,37],[39,0,39,15],[70,0,70,37],[60,16,60,34],[45,15,45,17],[45,8,45,11],[45,12,45,14],[50,28,50,33],[50,34,50,37],[51,28,51,33],[51,34,51,37],[49,0,49,37],[50,0,52,15],[50,16,52,19],[50,20,54,27],[141,36,141,37],[141,21,141,35],[140,0,140,6],[140,7,140,10],[140,11,140,17],[118,21,118,24],[117,0,117,20],[118,0,118,20],[119,34,119,37],[120,34,120,37],[134,36,134,37],[137,0,137,10],[137,11,137,24],[121,21,121,24],[121,0,121,20],[133,30,133,35],[133,36,133,37],[132,35,132,37],[132,0,132,34],[130,0,130,2],[130,3,130,9],[130,10,130,29],[122,36,122,37],[124,0,127,13],[124,30,124,33],[124,34,124,37],[125,34,125,37],[121,34,121,37],[149,0,149,37],[147,0,147,35],[147,36,147,37],[0,0,0,34],[0,35,0,37],[21,0,21,37],[23,0,23,1],[23,2,23,20],[23,22,23,28],[23,29,23,30],[23,31,23,33],[23,35,23,37],[9,26,9,29],[9,30,9,33],[9,34,9,37],[30,16,30,20],[30,21,30,25],[30,26,30,30],[30,31,30,37],[148,0,148,35],[148,36,148,37],[117,34,117,37],[118,34,118,37],[117,21,117,24],[157,0,157,34],[157,35,157,37],[150,35,150,37],[153,0,153,34],[153,35,153,37],[154,0,154,34],[154,35,154,37],[155,35,155,37],[151,0,151,34],[151,35,151,37],[156,0,156,34],[156,35,156,37],[152,0,152,34],[152,35,152,37],[150,0,150,34],[155,0,155,34],[135,36,135,37],[122,0,122,2],[122,3,122,9],[122,10,122,29],[1,0,1,17],[1,18,1,20],[1,21,1,31],[1,32,1,37],[2,25,2,31],[3,25,3,31],[68,0,68,37],[69,0,69,37],[38,36,38,37],[38,0,38,35],[25,31,25,33],[32,0,32,37],[28,35,28,37],[29,0,29,37],[30,0,30,1],[30,2,30,5],[30,6,30,10],[5,36,5,37],[5,0,5,35],[20,10,20,29],[20,30,20,35],[20,36,20,37],[30,11,30,15],[24,0,24,8],[24,9,24,10],[10,36,10,37],[10,0,10,35],[11,0,11,35],[11,36,11,37],[24,11,24,37],[25,0,25,1],[25,2,25,20],[7,26,7,29],[7,30,7,33],[7,34,7,37],[8,26,8,29],[8,30,8,33],[8,34,8,37],[17,35,17,37],[18,0,18,33],[18,35,18,37],[19,0,19,33],[19,35,19,37],[20,0,20,2],[20,3,20,9],[6,0,6,2],[6,3,6,9],[6,10,6,29],[6,30,6,35],[6,36,6,37],[22,5,22,37],[25,22,25,28],[25,29,25,30],[22,0,22,4],[25,35,25,37],[12,0,12,2],[12,3,12,9],[12,10,12,29],[12,30,12,35],[12,36,12,37],[13,0,13,34],[13,35,13,37],[14,0,14,34],[14,35,14,37],[15,0,15,33],[15,35,15,37],[16,0,16,33],[16,35,16,37],[17,0,17,33],[26,35,26,37],[27,0,27,1],[27,2,27,20],[27,22,27,28],[27,29,27,30],[27,31,27,33],[27,35,27,37],[26,0,26,1],[26,2,26,20],[26,22,26,28],[26,29,26,30],[26,31,26,33],[28,0,28,1],[28,2,28,20],[28,22,28,28],[28,29,28,30],[28,31,28,33],[31,0,31,37],[35,3,35,9],[35,10,35,29],[35,30,35,35],[35,36,35,37],[33,0,33,8],[33,9,33,10],[34,0,34,8],[34,9,34,10],[34,24,34,26],[34,11,34,23],[33,11,33,23],[34,36,34,37],[34,27,34,35],[33,36,33,37],[33,27,33,35],[122,30,122,35],[120,21,120,24],[119,0,119,20],[76,0,76,37],[77,0,77,37],[114,0,114,37],[115,34,115,37],[116,34,116,37],[115,0,116,20],[115,21,115,24],[116,21,116,24],[79,0,79,37],[94,0,94,37],[81,0,81,37],[86,0,86,2],[86,3,86,9],[86,10,86,29],[89,0,89,37],[101,8,101,9],[100,0,100,6],[100,7,100,9],[95,13,95,23],[96,13,96,23],[96,24,96,25],[95,11,96,12],[140,18,140,21],[140,22,140,36],[126,34,126,37],[138,0,138,7],[138,8,138,15],[138,17,138,25],[138,27,138,36],[139,0,139,12],[128,0,128,2],[128,3,128,9],[128,10,128,29],[128,30,128,35],[128,36,128,37],[129,0,129,2],[129,3,129,9],[129,10,129,29],[129,30,129,35],[129,36,129,37],[133,0,133,2],[133,3,133,9],[133,10,133,29],[130,30,130,35],[130,36,130,37],[131,0,131,2],[92,0,92,13],[92,14,92,15],[86,30,86,35],[86,36,86,37],[52,28,52,33],[52,34,52,37],[53,28,53,33],[53,34,53,37],[55,0,55,37],[56,0,56,8],[56,9,56,15],[56,35,56,37],[57,35,57,37],[58,35,58,37],[59,35,59,37],[60,35,60,37],[57,0,60,15],[56,16,56,34],[57,16,57,34],[58,16,58,34],[59,16,59,34],[54,34,54,37],[53,0,54,15],[41,4,41,7],[41,8,41,11],[41,12,41,14],[41,15,41,17],[41,18,41,21],[41,22,41,25],[47,0,47,37],[42,0,42,3],[42,4,42,7],[42,8,42,11],[42,12,42,14],[42,15,42,17],[42,18,42,21],[42,22,42,25],[43,0,43,3],[43,4,43,7],[43,8,43,11],[43,12,43,14],[43,15,43,17],[43,18,43,21],[43,22,43,25],[53,16,54,19],[54,28,54,33],[95,0,96,10],[95,32,95,37],[96,32,96,37],[64,28,64,37],[65,28,65,37],[66,28,66,37],[91,9,91,11],[91,12,91,13],[91,14,91,16],[91,17,91,18],[82,34,82,37],[83,34,83,37],[84,34,84,37],[83,24,83,33],[84,24,84,33],[85,24,85,33],[88,0,88,37],[87,0,87,37],[85,34,85,37],[82,24,82,33],[82,0,85,11],[82,20,82,23],[40,0,40,25],[40,26,40,37],[41,26,41,37],[43,26,45,37],[48,0,48,37],[46,0,46,3],[46,4,46,7],[46,8,46,11],[46,12,46,14],[46,15,46,17],[46,18,46,21],[46,22,46,25],[44,0,44,3],[44,4,44,7],[44,8,44,11],[44,12,44,14],[44,15,44,17],[44,18,44,21],[44,22,44,25],[45,0,45,3],[45,4,45,7],[45,18,45,21],[45,22,45,25],[41,0,41,3],[83,20,83,23],[91,0,91,8],[91,22,91,23],[91,24,91,26],[91,27,91,28],[91,29,91,31],[91,36,91,37],[82,12,82,19],[83,12,83,19],[131,3,131,9],[131,10,131,29],[131,30,131,35],[131,36,131,37],[67,7,67,37],[61,0,67,6],[124,27,124,29],[125,27,125,29],[126,27,126,29],[127,27,127,29],[125,14,125,26],[126,14,126,26],[127,14,127,26],[123,0,123,37],[78,0,78,2],[78,3,78,9],[78,10,78,29],[78,30,78,35],[78,36,78,37],[103,16,104,37],[105,0,105,37],[102,0,102,6],[102,7,102,9],[101,10,102,15],[125,30,125,33],[126,30,126,33],[127,30,127,33],[4,25,4,31],[2,18,2,24],[3,18,3,24],[4,18,4,24],[3,0,3,17],[4,0,4,17],[7,0,9,13],[7,14,9,15],[7,16,9,25],[33,24,33,26],[101,16,102,37],[101,0,101,7],[61,8,61,27],[62,8,62,27],[63,8,63,27],[64,8,64,27],[65,8,65,27],[66,8,66,27],[61,28,61,37],[62,28,62,37],[63,28,63,37]]}
["Project Development Loan (PDL) - Article 8  (Homeownership Project)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["Number of Assisted units to be assisted with this application for CalHome funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximate Allocation Remaining:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z27=\"\",\"\",IF(ISNUMBER(SEARCH(8,ProjectActivities)),Overview!Z27-Overview!P36,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDL Funds Request",null,null,null,null,null,null,"PDL Max Eligible Funds"]
["PDL Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S2*100000,0)","v":0}]
["Total PDL Funds:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S4:X4)","v":0},null,null,null,null,null,null,{"$f":"SUM(Z4:AE4)","v":0}]
["Does the applicant currently provide homebuyer education classes?"]
["File Name:",null,null,"PDL Homebuyer Education",null,null,null,null,null,null,"If not currently providing classes describe arrangements for providing homebuyer education.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Will the project be located entirely within federally defined Qualified Census Tracts (QCT)? (Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in QCTs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the project will be located entirely within a QCT, specify those tracts to the right."]
[]
[]
["Will the project be located entirely within a formerly designated redevelopment area previously under the jurisdiction of a local Redevelopment Agency?\n(Only select 'Yes' if ALL units to be assisted with CalHome funds shall be located in a formerly designated redevelopment area)"]
["Does the project meet a legislatively mandated priority for funds allocated to the CalHome Program?"]
["File Name:",null,null,"PDL Community Revitalization",null,null,null,null,null,null,"Documentation verifying the QCTs listed are current and federally recognized, or redevelopment area map that indicates property location(s), or documentation verifying the project meets a legislatively mandated priority.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7751(b)(1)(C) Do you have prior experience with or a plan to provide loan servicing / management?"]
["If Yes, how many homebuyer loans underwritten & closed on projects it's developed, which included preparation of loan documents within the last four (4) years?"]
[" a. Total number of homebuyer loans closed for which the applicant was the named beneficiary on the documents within the past four (4) years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[" b. As of the CalHome NOFA issuance date, the total number of homebuyer loans in the applicant's portfolio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[" c. Number of loans identified in (b) above that are being serviced by the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[" d. Number of loans identified in (b) above that are being serviced by a third party on behalf of the applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d."]
[" e. As of the CalHome NOFA issuance date, the total number of homebuyer loans the applicant is servicing for another entity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e."]
["File Name:",null,null,"PDL Loan Servicing",null,null,null,null,null,null,"Submit a narrative identifying how loans will be serviced, how servicing activities will be funded or provided and procedures for implementing loan servicing operations. In addition to the narrative, attach either:  1) a budget that provides an identified source of financing, for a period of at least 5 years, for contracting loan servicing with a third party who is in the business of loan servicing; 2) a commitment letter from a third party, who is in the business of loan servicing, willing to provide loan servicing at no cost to the applicant; or 3) the résumé of a current employee(s) of the applicant that describes the employee(s)’s experience in homeowner loan servicing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Site Information"]
["Development Name"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"County",null,null,null,null,"Zip"]
["Does the project include multiple parcels?",null,null,null,null,null,null,null,null,null,null,"If the project includes multiple parcels please include additional addresses below:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"County",null,null,null,null,"Zip"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"County",null,null,null,null,"Zip"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"County",null,null,null,null,"Zip"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"County",null,null,null,null,"Zip"]
["Please include the APN(s) of all parcels below."]
["APN(s)"]
["Describe any special circumstances or describe additional site information below including lot numbers if applicable.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE137>=$AM$116,X137,\"\")","v":""}]
[]
["Has the Tentative Map been approved?",null,null,null,null,null,null,null,null,null,null,"Provide approval date or estimated date of approval:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the development being phased?"]
["Has the Final Map been recorded?",null,null,null,null,null,null,null,null,null,null,"Provide recorded date or estimated date of recordation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Yes, what phase are subject lots in?"]
["File Name:",null,null,"PDL Site Map",null,null,null,null,null,null,"Provide a site map of proposed site.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Proposed Development"]
["Was the development APPLICATION SUBMITTED to the local jurisdiction Pursuant to GC 65913.4(b)?  (SB-35 Streamlined Ministerial Approval Process)"]
["Was the development APPROVED by the local jurisdiction Pursuant to GC 65913.4(b)?  (SB-35 Streamlined Ministerial Approval Process)"]
["How many total units is the proposed development, include CalHome assisted and non-assisted units in this total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What type of building are the proposed units:"]
["Unit Breakdown and Descriptions of units to be available to CalHome eligible buyers:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provide the data source used to set sales prices:"]
["Model Number",null,null,null,"Number of Units",null,null,null,"Square Footage (Living Space)",null,null,null,"Number of Bedrooms",null,null,"Number of Bathrooms",null,null,"Total Amount of Permanent Liens",null,null,null,"Proposed Sales Price*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Proposed sales price cannot exceed the estimated appraised value using the sales of comparable properties approach to determine value."]
[]
[]
[]
["Market Affordability Data"]
["Summarize the local area market data which demonstrates the need for the development of additional affordable housing and the targeted households are both willing and able to pay the proposed housing costs."]
[]
["Proposed annual household income range to be served:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Estimated Housing Costs for assisted households:",null,null,null,null,null,null,null,"Mortgages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxes/Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities"]
["County Median Income:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"HOA Fees (if applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,{"$f":"SUM(AI51:AL54)","v":0}]
["Project Financing & Affordability"]
["Proposed Unit Permanent Financing:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source of Financing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Lien Position"]
["Describe the financing structure, first mortgage and any subordinate financing in addition to CalHome that will finance the purchase of the properties:"]
[]
[]
[]
["Projected Average Housing Cost and Affordability:",null,null,null,null,null,null,"1.","Expected Average Sales Price, Less Homebuyer Equity:"]
[null,null,null,null,null,null,null,"2.","Less Average CalHome Mortgage Assistance to be given:"]
[null,null,null,null,null,null,null,"3.","Less Average Other Subsidies to be received, if any:"]
[null,null,null,null,null,null,null,"4.","Average First Mortgage:"]
[null,null,null,null,null,null,null,"5.","Estimated Monthly Payment on First Mortgage (PITI)"]
[null,null,null,null,null,null,null,"6.","Annual Income Needed to Support Above Payment:"]
[null,null,null,null,null,null,null,"(Based on the homebuyer paying 30% of gross annual income for PITI (PITI payment should include HOA dues or rental space))"]
["§7750(d) Provide a brief description of the proposed project including: income levels of households to be assisted, description of prior experience with the type of program applied for, building type description, and geographic location of the activities."]
[]
["Describe the project's feasibility and potential obstacles to that feasibility. How will you overcome those obstacles?"]
[]
["Describe the terms and conditions of funding, other than HCD, that is being proposed and the current status of each funding source. Provide information on total development costs per unit and per square foot."]
[]
["Resale Restrictions:",null,null,null,null,"Are you planning to implement resale or recapture restrictions?"]
["File Name:",null,null,"PDL Resale Restrictions",null,null,null,null,null,null,"If you are planning to implement resale or recapture restrictions summarize relevant features of these covenants and indicate if there are other sources of financing in addition to CalHome. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(e) Provide a how the applicant has site control; the status of all local government approvals; availability of on and off site improvements and utilities; soil condition and environmental conditions; project costs; unit description in terms of size, number of bedrooms; per unit construction cost; estimated sales price and sources of financing; estimated monthly housing costs of purchasers; and description of the homebuyer education program."]
[]
["File Name:",null,null,"PDL Executive Summary",null,null,null,null,null,null,"Provide an executive summary describing the proposed project (no more than 1 page).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7750(f) Provide a description of how you will comply with the requirements for local administration set forth in §7721 applicable to the program or project being applied for."]
[]
["Planning Information"]
["Have the following local approvals been obtained?",null,null,null,null,null,null,null,null,null,null,null,"General Plan amendment",null,null,null,null,null,null,null,null,null,null,null,"Variances"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Zoning approval or Zoning Map",null,null,null,null,null,null,null,null,null,null,null,"Environmental clearance (CEQA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Current Zoning Classification:",null,null,null,null,null,null,null,null,null,null,null,"Other required discretionary approvals"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Conditional use permits",null,null,null,null,null,null,null,null,null,null,null,"Has the subdivision been approved?"]
["File Name:",null,null,"PDL Local Approvals",null,null,null,null,null,null,"Provide documentation from a local government official confirming the status of each of the above approvals. (Sample linked in cell to the left)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["If the subdivision has not been approved, explain current project status in the approval process, including anticipated date of approval:"]
[]
["Opposition/Obstacles (Identify known opposition or obstacles to this project):"]
[]
["What utilities are available to the site?",null,null,null,null,null,null,null,null,"Water:",null,null,null,null,"Gas:",null,null,null,null,"Sewer:",null,null,null,null,"Electric:",null,null,null,null,"Other:",null,null,"(describe utility)"]
["Has a soils/engineering/geotechnical report been prepared?"]
["File Name:",null,null,"PDL Soils_Engineering_ Geotechnical Report",null,null,null,null,null,null,"Attach the Soils, Engineering, or Geotechnical report if completed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Environmental"]
["Has the Phase I Environmental Assessment been prepared?",null,null,null,null,null,null,null,null,null,null,null,null,"Is the property located in a Seismic Hazard Area?",null,null,null,null,null,null,null,null,null,null,null,null,"If yes, zone designation:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the property located in a Flood Hazard Area?",null,null,null,null,null,null,null,null,null,null,null,null,"Flood Zone designation:"]
["File Name:",null,null,"PDL Phase I Environmental",null,null,null,null,null,null,"Attach the Phase I Environmental Assessment if completed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Offsite/On Site Improvements"]
["Are offsite improvements needed?",null,null,null,null,null,null,null,null,null,"If yes, please give details:"]
["Estimated date of Completion:"]
["Are onsite improvements needed?",null,null,null,null,null,null,null,null,null,"If yes, please give details:"]
["Estimated date of Completion:"]
["Has work started on the project?",null,null,null,null,null,null,null,null,null,"If yes, please describe what work has begun:"]
[]
["Milestones"]
["Estimated date of project completion:"]
["1. Permanent financing commitments will be obtained by:"]
["2. Site option will expire on:"]
["3. Title will transfer by:"]
["4. Site development will begin by:"]
["5. Unit construction will be completed by:"]
["6. Construction will be completed by:"]
["7. Full occupancy will be accomplished by:"]
["§7742 To be eligible to apply for a development loan the applicant shall have successfully developed a minimum of two similar projects within the four years immediately preceding the application. Indicate qualifying experience below: (include the county where the program was administered in the dropdown under header Qualified Developments Assisted County)"]
["Describe the development loan projects you have successfully developed within the last four years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qualified Developments Assisted County",null,null,null,"Completed Developments",null,null,null,"Developed within last four years",null,null,null,null,"Qualified Developments",null,null,null,{"$f":"DATE(2019,10,3)-(4*365)","v":"2015-10-04"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AN118:AN122)<=0,0,SUM(AN118:AN122))","v":0},null,null,null,null,null,null,null,"Occupancy Date",null,null,null,null,{"$f":"SUM(AO118:AO152)","v":0},null,null,null,null,"Qualified Developments Assisted County","Qualified Developments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD118>=$AM$116,AO118,0)","v":0},null,null,null,{"$f":"IF(AD118>=$AM$116,Z118,0)","v":0},{"$f":"IF(AD118=\"\",0,IF(V118=Overview!$Z$26,IF(AD118>=$AM$116,Z118,0),0))","v":0},{"$f":"IF(AD118=\"\",0,IF(AD118>=$AM$116,Z118,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD119>=$AM$116,AO119,0)","v":0},null,null,null,{"$f":"IF(AD119>=$AM$116,Z119,0)","v":0},{"$f":"IF(AD119=\"\",0,IF(V119=Overview!$Z$26,IF(AD119>=$AM$116,Z119,0),0))","v":0},{"$f":"IF(AD119=\"\",0,IF(AD119>=$AM$116,Z119,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD120>=$AM$116,AO120,0)","v":0},null,null,null,{"$f":"IF(AD120>=$AM$116,Z120,0)","v":0},{"$f":"IF(AD120=\"\",0,IF(V120=Overview!$Z$26,IF(AD120>=$AM$116,Z120,0),0))","v":0},{"$f":"IF(AD120=\"\",0,IF(AD120>=$AM$116,Z120,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD121>=$AM$116,AO121,0)","v":0},null,null,null,{"$f":"IF(AD121>=$AM$116,Z121,0)","v":0},{"$f":"IF(AD121=\"\",0,IF(V121=Overview!$Z$26,IF(AD121>=$AM$116,Z121,0),0))","v":0},{"$f":"IF(AD121=\"\",0,IF(AD121>=$AM$116,Z121,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AD122>=$AM$116,Z122,0)","v":0},{"$f":"IF(AD122=\"\",0,IF(V122=Overview!$Z$26,IF(AD122>=$AM$116,Z122,0),0))","v":0},{"$f":"IF(AD122=\"\",0,IF(AD122>=$AM$116,Z122,0))","v":0}]
["File Name:",null,null,"PDL Construction Lender Reference",null,null,null,null,null,null,"For each project identified above provide written references from the construction lenders that describe the type of funding provided, total units funded, whether the project was completed in a timely fashion and any delays or problems that occurred with the financing. The letters must include contact names, addresses and phone numbers.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["(Important Note:  Only complete this section, if the applicant meets the two-year minimum experience requirement for developing a project, which involves this type of contributed labor and all homeownership development units in the proposed project will utilize this type of construction.)"]
[" §7751(b)(5) Enter hours of Volunteer Labor, Self-Help Labor, Youth Construction Skills Training Program to the right:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours",null,null,"# Assisted Units",null,null,null,"Hours per Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volunteer Labor §7751(b)(5)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AB126/AE126,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-Help Construction Labor §7751(b)(5)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AB127/AE127,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor provided by Youth Participating in a Construction Skills Training Program (Ages 16-24 only) §7751(b)(5)(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AB128/AE128,0)","v":0}]
["File Name:",null,null,"PDL Labor Program Criteria",null,null,null,null,null,null,"As an attachment, describe the criteria for participation in your contributed labor program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"PDL Labor Program Agreement",null,null,null,null,null,null,"Attach a copy of the agreement form used for the contributed labor program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"PDL Labor Program Activities",null,null,null,null,null,null,"As an attachment, provide a description of activities performed by contributed labor participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"PDL Labor Program Contracted",null,null,null,null,null,null,"As an attachment, provide a description of activities normally contracted out.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["What percentage of total onsite construction labor per unit will be performed by contributed labor?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["File Name:",null,null,"PDL Contributed Labor Program",null,null,null,null,null,null,"Please provide evidence of previous administration of the type of contributed labor program proposed in this application.  This includes documentation of completed projects; a copy of the board resolution authorizing the program, supported by completed projects; or copies of contracts with contributed labor participants. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7742 We certify the applicant has staff that will be committed to the proposed project that possesses the knowledge, skills and ability to perform the tasks required in a homeownership development project."]
["§7743 Applicant certifies the CalHome funds in support of a PDL project will be only be used for these eligible costs?"]
["§7744 Does the applicant of the Project have Site Control for the PDL Project?  If yes, enter form of site control and most recent execution date below."]
["Form of site control (See Site Control §7744):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most recent document execution date:"]
["If leasehold estate, answer the following:",null,null,null,null,null,null,null,"Is rent based on restricted land value?",null,null,null,null,null,null,null,null,"Is acquisition cost $0 in Development Budget?",null,null,null,null,null,null,null,null,null,"Prepaid lease loan used?  If so answer below (a-c)"]
["(a) Funding amount based on the Present Value of lease payments?",null,null,null,null,null,null,null,null,null,null,null,null,null,"(b) Lender requesting Res. Receipts\n(not permissible)",null,null,null,null,null,null,null,null,null,null,null,"(c) Has loan amount been entered as a finance cost?"]
["Purchase price of the site(s):",null,null,null,null,null,null,null,null,null,null,"Appraised value of the site(s):",null,null,null,null,null,null,null,null,null,null,"Has applicant completed any other units in this subdivision?"]
["If applicant has completed other units in this subdivision, provide date completed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If applicant completed other units, how many units were completed?"]
["Describe any special circumstances regarding site control:"]
[]
["File Name:",null,null,"PDL Site Control",null,null,null,null,null,null,"Provide appropriate documentation to demonstrate the form of site control indicated above.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"PDL Prelim",null,null,null,null,null,null,"Provide the Preliminary Title Report to verify the accuracy of the site control document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["File Name:",null,null,"PDL Appraisal",null,null,null,null,null,null,"If available, provide a current appraisal of the site(s).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["§7748(b) We certify the developer borrower will develop the project without any co-developer, as is consistent with the capacity requirements of §7717 and §7742."]
["§7750(c) We certify that construction work has not begun as of the application deadline set forth in the NOFA."]
["Selection Criteria §7751"]
["Total Self Score (minimum points required = 550; max points without bonus = 1,000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ153:AL158)","v":0}]
["Rating Factors (red shading indicates minimum score has not been achieved)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points"]
["Capability §7751(b)(1) - 400 Points Max (see NOFA)\nCapability to operate the local the proposed program, administer and conduct the self-help technical assistance project, or develop the type of homeownership project proposed in the application as follows (up to 400 points):\n(A) prior experience with administration/implementation of the type of program proposed in the application; or\n(B) prior experience in developing the type of homeownership development project or self-help technical assistance homeownership project as proposed in the application; and\n(C) prior experience with loan servicing or a plan to provide loan servicing/management capabilities. Number of rehab/reconstructed units assisted within the last four years.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(AJ14=\"Yes\",AK21=\"Yes\"),AI117>=2),AM153,0)","v":0},null,null,{"$f":"IF(V117>=5,400,IF(V117>=3,300,IF(V117>=1,200,0)))","v":0}]
["Community Need §7751(b)(2) - 150 Points\nCommunity need in a geographic area of the proposed local program or project will be based on one or more of the following factors: poverty level and overpayment for housing by low-income households, age of housing stock in the jurisdiction, numbers and percentages of substandard housing units, overcrowding of housing by tenure (including rental and ownership housing) in the jurisdiction, and percentages of households that are below poverty level and who are overcrowded and living in substandard housing Approved Regulations by tenure, as reflected in U.S. Census data; and the ratio between the median home sales price and the median household income in the jurisdiction. The specific community need factors that will apply to each activity will be identified in the NOFA. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",150)","v":"0"}]
["Feasibility §7751(b)(3) - 250 Points\nFeasibility for applications proposing a homeownership development project or a self-help technical assistance homeownership project will be based on U.S. Census Bureau data regarding percentage of low-income homeownership in a jurisdiction and the ratio of the CalHome appraised value limits relative to the CalHome median income for a four person household. The higher the percentage of low-income homeowners, the higher the points awarded. The higher the ratio of housing cost to income, the higher the points awarded.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overview!Z26=\"\",\"0\",250)","v":"0"}]
["Community Revitalization §7751(b)(4) - 100 Points\nContributes to community revitalization defined as a program or project will be considered to contribute towards community revitalization if all units to be assisted with CalHome Program funds are, or will be, located within a federally defined Qualified Census Tract or a designated redevelopment area under the jurisdiction of a successor to a local redevelopment agency or meets a legislatively mandated priority for funds allocated to the CalHome Program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O8=\"Yes\",AK11=\"Yes\",AK12=\"Yes\"),100,0)","v":0}]
["Volunteer Labor, Self-Help Labor or Youth Construction Skills Training Program §7751(b)(5) - 100 Points\nApplications applying for homeownership development projects, self-help technical assistance homeownership projects, or a mortgage assistance local program for new construction housing or acquisition with rehabilitation when the recipient is acquiring and rehabilitating properties for sale to first-time homebuyers, will receive up to 100 points to the extent that they are utilizing:\n(A) volunteer or self-help construction labor, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided; or\n(B) labor provided by youth participating in a construction skills training program, where a minimum of five hundred (500) hours of on-site construction labor per assisted unit is provided. The five hundred (500) hours of construction training labor must be provided by the 16 to 24 year old program participants.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AI126:AL127)>=500,100,IF(AI128>=500,100,0))","v":0}]
["Performance Penalty §7751(c) - A deduction to the total score will be applied for failure to meet CalHome Program Performance Goals pursuant to §7755.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"PDL Budgets - Article 8","index":8,"n_rows":82,"n_cols":36,"rows_kept":82,"cut":false,"hidden":true,"merged":[[23,34,23,37],[25,10,25,13],[25,14,25,17],[25,18,25,21],[25,22,25,25],[25,26,25,29],[25,30,25,33],[25,34,25,37],[23,10,23,13],[23,14,23,17],[23,18,23,21],[23,22,23,25],[23,26,23,29],[23,30,23,33],[24,26,24,29],[24,30,24,33],[21,34,21,37],[22,10,22,13],[22,14,22,17],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,33],[22,34,22,37],[21,10,21,13],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,33],[19,34,19,37],[20,10,20,13],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,33],[20,34,20,37],[19,10,19,13],[19,14,19,17],[19,18,19,21],[19,22,19,25],[19,26,19,29],[19,30,19,33],[18,10,18,13],[18,14,18,17],[18,18,18,21],[18,22,18,25],[18,26,18,29],[18,30,18,33],[18,34,18,37],[17,10,17,13],[17,14,17,17],[17,18,17,21],[17,22,17,25],[17,26,17,29],[17,30,17,33],[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[13,34,13,37],[14,10,14,13],[14,14,14,17],[14,18,14,21],[14,22,14,25],[14,26,14,29],[14,30,14,33],[14,34,14,37],[13,26,13,29],[15,26,15,29],[15,30,15,33],[15,34,15,37],[16,10,16,13],[16,14,16,17],[16,18,16,21],[16,22,16,25],[16,26,16,29],[16,30,16,33],[16,34,16,37],[17,34,17,37],[13,0,13,9],[26,0,26,37],[0,0,0,34],[0,35,0,37],[12,0,12,37],[13,30,13,33],[3,0,3,37],[21,0,21,9],[22,0,22,9],[23,0,23,9],[1,0,1,37],[2,0,2,37],[25,0,25,9],[13,10,13,13],[13,14,13,17],[13,18,13,21],[13,22,13,25],[15,10,15,13],[15,14,15,17],[15,18,15,21],[15,22,15,25],[14,0,14,9],[15,0,15,9],[16,0,16,9],[10,24,10,27],[9,28,9,33],[10,28,10,33],[7,34,7,37],[8,34,8,37],[7,24,7,27],[8,24,8,27],[7,28,7,33],[8,28,8,33],[27,0,27,37],[28,0,28,23],[28,24,28,27],[28,28,28,33],[28,34,28,37],[4,24,4,27],[4,28,4,33],[4,34,4,37],[5,34,5,37],[6,34,6,37],[5,24,5,27],[6,24,6,27],[5,28,5,33],[6,28,6,33],[4,0,4,23],[5,1,5,23],[6,1,6,23],[7,1,7,23],[8,1,8,23],[9,1,9,23],[10,1,10,23],[9,34,9,37],[10,34,10,37],[9,24,9,27],[31,1,31,23],[31,24,31,27],[31,28,31,33],[31,34,31,37],[32,1,32,23],[32,24,32,27],[32,28,32,33],[32,34,32,37],[29,1,29,23],[29,24,29,27],[29,28,29,33],[29,34,29,37],[30,1,30,23],[30,24,30,27],[30,28,30,33],[30,34,30,37],[36,0,36,37],[33,1,33,23],[33,24,33,27],[33,28,33,33],[33,34,33,37],[34,1,34,23],[34,24,34,27],[34,28,34,33],[34,34,34,37],[35,3,35,9],[35,10,35,29],[35,30,35,35],[35,36,35,37],[38,26,38,29],[38,30,38,33],[38,34,38,37],[39,0,39,9],[39,10,39,13],[39,14,39,17],[39,18,39,21],[39,22,39,25],[39,26,39,29],[39,30,39,33],[39,34,39,37],[38,0,38,9],[38,10,38,13],[38,14,38,17],[38,18,38,21],[38,22,38,25],[40,26,40,29],[40,30,40,33],[40,34,40,37],[41,0,41,9],[41,10,41,13],[41,14,41,17],[41,18,41,21],[41,22,41,25],[41,26,41,29],[41,30,41,33],[41,34,41,37],[40,0,40,9],[40,10,40,13],[40,14,40,17],[40,18,40,21],[40,22,40,25],[42,26,42,29],[42,30,42,33],[42,34,42,37],[43,0,43,9],[43,10,43,13],[43,14,43,17],[43,18,43,21],[43,22,43,25],[43,26,43,29],[43,30,43,33],[43,34,43,37],[42,0,42,9],[42,10,42,13],[42,14,42,17],[42,18,42,21],[42,22,42,25],[44,34,44,37],[45,0,45,9],[45,10,45,13],[45,14,45,17],[45,18,45,21],[45,22,45,25],[45,26,45,29],[45,30,45,33],[45,34,45,37],[44,0,44,9],[44,10,44,13],[44,14,44,17],[44,18,44,21],[44,22,44,25],[50,22,50,25],[50,26,50,29],[50,30,50,33],[50,34,50,37],[49,0,49,9],[49,10,49,13],[49,14,49,17],[49,18,49,21],[49,22,49,25],[53,0,53,37],[54,0,54,37],[46,30,46,33],[46,34,46,37],[52,26,52,29],[52,30,52,33],[52,34,52,37],[11,0,11,2],[11,3,11,9],[11,10,11,29],[11,30,11,35],[11,36,11,37],[52,0,52,9],[52,10,52,13],[52,14,52,17],[52,18,52,21],[52,22,52,25],[49,26,49,29],[49,30,49,33],[49,34,49,37],[50,0,50,9],[50,10,50,13],[50,14,50,17],[50,18,50,21],[37,30,37,33],[37,34,37,37],[48,0,48,9],[48,10,48,13],[48,14,48,17],[48,18,48,21],[48,22,48,25],[48,26,48,29],[48,30,48,33],[48,34,48,37],[46,0,46,9],[46,10,46,13],[46,14,46,17],[46,18,46,21],[46,22,46,25],[46,26,46,29],[37,10,37,13],[37,14,37,17],[37,18,37,21],[37,22,37,25],[37,26,37,29],[37,0,37,9],[44,26,44,29],[44,30,44,33],[55,0,55,23],[55,24,55,27],[55,28,55,33],[55,34,55,37],[56,1,56,23],[56,24,56,27],[56,28,56,33],[56,34,56,37],[47,26,47,29],[47,30,47,33],[47,34,47,37],[51,0,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21],[51,22,51,25],[51,26,51,29],[51,30,51,33],[51,34,51,37],[47,0,47,9],[47,10,47,13],[47,14,47,17],[47,18,47,21],[47,22,47,25],[59,1,59,23],[59,24,59,27],[59,28,59,33],[59,34,59,37],[60,1,60,23],[60,24,60,27],[60,28,60,33],[60,34,60,37],[57,1,57,23],[57,24,57,27],[57,28,57,33],[57,34,57,37],[58,1,58,23],[58,24,58,27],[58,28,58,33],[58,34,58,37],[61,1,61,23],[61,24,61,27],[61,28,61,33],[61,34,61,37],[63,0,63,37],[62,0,62,2],[62,3,62,9],[62,10,62,29],[62,30,62,35],[62,36,62,37],[64,26,64,29],[64,30,64,33],[64,34,64,37],[65,0,65,9],[65,10,65,13],[65,14,65,17],[65,18,65,21],[65,22,65,25],[65,26,65,29],[65,30,65,33],[65,34,65,37],[64,0,64,9],[64,10,64,13],[64,14,64,17],[64,18,64,21],[64,22,64,25],[66,26,66,29],[66,30,66,33],[66,34,66,37],[67,0,67,9],[67,10,67,13],[67,14,67,17],[67,18,67,21],[67,22,67,25],[67,26,67,29],[67,30,67,33],[67,34,67,37],[66,0,66,9],[66,10,66,13],[66,14,66,17],[66,18,66,21],[66,22,66,25],[68,26,68,29],[68,30,68,33],[68,34,68,37],[69,0,69,9],[69,10,69,13],[69,14,69,17],[69,18,69,21],[69,22,69,25],[69,26,69,29],[69,30,69,33],[69,34,69,37],[68,0,68,9],[68,10,68,13],[68,14,68,17],[68,18,68,21],[68,22,68,25],[70,26,70,29],[70,30,70,33],[70,34,70,37],[71,0,71,9],[71,10,71,13],[71,14,71,17],[71,18,71,21],[71,22,71,25],[71,26,71,29],[71,30,71,33],[71,34,71,37],[70,0,70,9],[70,10,70,13],[70,14,70,17],[70,18,70,21],[70,22,70,25],[72,26,72,29],[72,30,72,33],[72,34,72,37],[73,0,73,9],[73,10,73,13],[73,14,73,17],[73,18,73,21],[73,22,73,25],[73,26,73,29],[73,30,73,33],[73,34,73,37],[72,0,72,9],[72,10,72,13],[72,14,72,17],[72,18,72,21],[72,22,72,25],[75,22,75,25],[75,26,75,29],[75,30,75,33],[75,34,75,37],[74,26,74,29],[74,30,74,33],[74,34,74,37],[74,0,74,9],[74,10,74,13],[74,14,74,17],[74,18,74,21],[74,22,74,25],[75,0,75,9],[75,10,75,13],[75,14,75,17],[75,18,75,21],[76,26,76,29],[76,30,76,33],[76,34,76,37],[77,0,77,9],[77,10,77,13],[77,14,77,17],[77,18,77,21],[77,22,77,25],[77,26,77,29],[77,30,77,33],[77,34,77,37],[76,0,76,9],[76,10,76,13],[76,14,76,17],[76,18,76,21],[76,22,76,25],[81,25,81,27],[81,35,81,37],[81,28,81,34],[81,14,81,24],[79,13,79,37],[80,13,81,13],[81,0,81,8],[81,9,81,12],[24,34,24,37],[78,0,78,37],[79,9,79,12],[80,9,80,12],[79,0,79,8],[80,0,80,8],[80,28,80,34],[80,35,80,37],[80,14,80,24],[80,25,80,27],[24,0,24,9],[24,10,24,13],[24,14,24,17],[24,18,24,21],[24,22,24,25],[35,0,35,2]]}
["Project Development Loan (PDL) - Article 8  (Homeownership Project)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["PDL Predevelopment Budgets"]
["Provide a copy of a line item development budget, which includes all costs necessary to complete the project. (Estimate, if actuals not available)"]
["Predevelopment Sources"]
["§7750(d) Non-CalHome PDL Funding Sources and Source/Description of contributed labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status",null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["File Name:",null,null,"PDL Predevelopment EFCs",null,null,null,null,null,null,"Provide enforceable funding commitments for committed predevelopment funding sources if separate from construction financing.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Predevelopment Sources & Uses"]
["Uses",null,null,null,null,null,null,null,null,null,"CalHome",null,null,null,"(Source #2)",null,null,null,"(Source #3)",null,null,null,"(Source #4)",null,null,null,"(Source #5)",null,null,null,"(Source #6)",null,null,null,"Total"]
["Land Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:AH15)","v":0}]
["Soils Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K16:AH16)","v":0}]
["Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Architecture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Legal - Real Estate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Accounting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Appraisal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Application Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Permits & Other Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K25:AH25)","v":0}]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:N25)","v":0},null,null,null,{"$f":"SUM(O15:R25)","v":0},null,null,null,{"$f":"SUM(S15:V25)","v":0},null,null,null,{"$f":"SUM(W15:Z25)","v":0},null,null,null,{"$f":"SUM(AA15:AD25)","v":0},null,null,null,{"$f":"SUM(AE15:AH25)","v":0},null,null,null,{"$f":"SUM(AI15:AL25)","v":0}]
["PDL Construction Budgets"]
["Construction Sources"]
["§7750(d) Non-CalHome PDL Funding Sources and Source/Description of contributed labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status",null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["File Name:",null,null,"PDL Construction EFCs",null,null,null,null,null,null,"Provide enforceable funding commitments for committed construction funding sources. If project utilizes USDA Rural Development funds provide a current 523 technical services agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Construction Sources & Uses"]
["Uses",null,null,null,null,null,null,null,null,null,"CalHome",null,null,null,"(Source #2)",null,null,null,"(Source #3)",null,null,null,"(Source #4)",null,null,null,"(Source #5)",null,null,null,"(Source #6)",null,null,null,"Total"]
["Payoff Pre-Development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K39:AH39)","v":0}]
["Land Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K40:AH40)","v":0}]
["Permits & Other Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Off-Site Improvements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Site Improvements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Contingency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Architecture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K47:AH47)","v":0}]
["Legal - Real Estate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K48:AH48)","v":0}]
["Accounting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K49:AH49)","v":0}]
["Construction Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K52:AH52)","v":0}]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K39:N52)","v":0},null,null,null,{"$f":"SUM(O39:R52)","v":0},null,null,null,{"$f":"SUM(S39:V52)","v":0},null,null,null,{"$f":"SUM(W39:Z52)","v":0},null,null,null,{"$f":"SUM(AA39:AD52)","v":0},null,null,null,{"$f":"SUM(AE39:AH52)","v":0},null,null,null,{"$f":"SUM(AI39:AL52)","v":0}]
["PDL Permanent Budgets"]
["Permanent Sources"]
["§7750(d) Non-CalHome PDL Funding Sources and Source/Description of contributed labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status",null,null,null,"Proposed Lien Position",null,null,null,null,null,"Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
["File Name:",null,null,"PDL Permanent EFCs",null,null,null,null,null,null,"Provide enforceable funding commitments for committed Permanent funding sources other than the CalHome funds being requested. If project utilizes USDA Rural Development funds provide a current 523 technical services agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["Permanent Sources & Uses"]
["Uses",null,null,null,null,null,null,null,null,null,"CalHome",null,null,null,"(Source #2)",null,null,null,"(Source #3)",null,null,null,"(Source #4)",null,null,null,"(Source #5)",null,null,null,"(Source #6)",null,null,null,"Total"]
["Payoff Construction Loan #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K66:AH66)","v":0}]
["Payoff Construction Loan #2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K67:AH67)","v":0}]
["Payoff Construction Loan #3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Payoff Construction Loan #4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Payoff HCD Construction Loan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Rollover Equity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Rollover FWHG Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Permanent Loan Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Developer Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Audit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K66:N77)","v":0},null,null,null,{"$f":"SUM(O66:R77)","v":0},null,null,null,{"$f":"SUM(S66:V77)","v":0},null,null,null,{"$f":"SUM(W66:Z77)","v":0},null,null,null,{"$f":"SUM(AA66:AD77)","v":0},null,null,null,{"$f":"SUM(AE66:AH77)","v":0},null,null,null,{"$f":"SUM(AI66:AL77)","v":0}]
["Permanent Funding Summary"]
["Grand Total Permanent Finance:",null,null,null,null,null,null,null,null,{"$f":"AI78","v":0}]
["Less CalHome Funds:",null,null,null,null,null,null,null,null,{"$f":"-K78","v":0},null,null,null,null,"Number of Assisted Units:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('PDL - Article 8'!S2=\"\",0,'PDL - Article 8'!S2)","v":0},null,null,"Total Cost Per Unit:",null,null,null,null,null,null,{"$f":"IFERROR(AI78/Z81,0)","v":0}]
["Total:",null,null,null,null,null,null,null,null,{"$f":"SUM(J80:M81)","v":0},null,null,null,null,"Average CalHome cost per Assisted Unit:",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K78/Z81,0)","v":0},null,null,"Total Per Square Foot:",null,null,null,null,null,null,0]

{"sheet":"Applicant Cert & Commitment","index":9,"n_rows":39,"n_cols":36,"rows_kept":39,"cut":false,"hidden":false,"merged":[[19,0,19,37],[23,2,23,37],[5,0,5,37],[0,0,0,34],[0,35,0,37],[1,0,1,37],[2,5,2,37],[3,0,3,37],[7,0,7,37],[9,0,9,37],[11,0,11,37],[13,0,13,37],[15,0,15,37],[38,3,38,25],[38,26,38,27],[38,28,38,37],[27,1,27,37],[29,1,29,37],[31,1,31,37],[33,0,33,37],[35,3,35,21],[35,22,35,23],[35,24,35,37]]}
["Applicant Certification and Commitment of Responsibility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["As the official designate by the governing body, I hereby certify that if approved by HCD for a CalHome Program funding allocation, the "]
["(applicant name)"]
["assumes the responsibilities specified in the CalHome Program Regulations and certifies that:"]
[]
["A. It possesses the legal authority to apply for the allocation and to execute their proposed program or project §7750(c);"]
[]
["B. Before committing funds to a homebuyer/homeowner, it will evaluate the funding eligibility in accordance with CalHome Program Regulations and will not invest any more CalHome funds in combination with other governmental assistance than is necessary to provide affordable housing;"]
[]
["C. The Applicant does not have any unresolved audit findings for prior HCD or federally-funded housing or community development projects or programs §7750(c);"]
[]
["D. There are no pending lawsuits that would impact the implementation of this program or project §7750(c);"]
[]
["E. It will comply with all requirements as set forth in the NOFA and the statutes and regulations governing the CalHome Program including, but not limit to, Housing Element, Climate Adaptation (specifically Executive Order B-30-15), Long-Term Resiliency Standards and Fire and Flood Requirements;"]
[]
["F. The information, statements, and attachments contained in this application are, to the best of my knowledge and belief, true and correct;"]
[]
["G. It has the ability to perform the duties for the activity(s) applied for in accordance with §7718;"]
[]
["H. Construction work has not begun, and will not begin, prior to the date that HCD makes an award of CalHome Funds §7718(c);"]
[]
["I.","If awarded, the Recipient, shall implement the local program or project and be responsible for all the activities outlined in §7721(a), including items I(1) & I(2) below;"]
[]
[null,"1.","§7721(a)(5) Maintain complete and accurate records of all CalHome Program loan disbursements and repayments to ensure adherence to proper accounting procedures for the CalHome Program loans, which may be verified by the Department and may be subject to a fiscal and programmatic audit;"]
[]
[null,"2.","§7721(a)(6) Comply with reporting requirements pursuant to §7754;"]
[]
["J.","§7725(a) CalHome Program loans to individual borrowers shall not exceed the amount published in the current NOFA or, when considered with other available financing and assistance, the minimum amount necessary;"]
[]
["K.","Homeowner and Homebuyer Loan Terms and Loan-to-Value Limits shall follow the regulations outlined in §7726 and §7727."]
[]
["L.","The information, statements, and attachments contained in this application are, to the best of my knowledge and belief, true and correct."]
[]
["I authorize the Department of Housing and Community Development to contact any agency, whether or not named in this application, which may assist in determining the capability of the Applicant. All information contained in this application is acknowledge to be public information. (This certification must be signed by the person authorized in the Resolution)."]
[]
["*Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:"]
[" *Must be signed by authorized signatory per the resolution."]
[]
["Type Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Application Support","index":10,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,3],[3,4,3,14],[3,15,3,16],[3,17,3,27],[3,28,3,31],[3,32,3,37],[0,0,0,34],[0,35,0,37],[1,0,1,37],[2,0,2,2],[2,3,2,21],[2,22,2,25],[2,26,2,29],[2,30,2,33],[2,34,2,37],[4,0,4,37],[5,0,5,1],[5,2,5,4],[5,5,5,8],[5,9,5,14],[5,15,5,16],[5,17,5,28],[5,29,5,31],[5,32,5,34],[5,35,5,37],[6,29,6,31],[6,32,6,34],[6,35,6,37],[7,0,7,1],[7,2,7,4],[7,5,7,8],[7,9,7,14],[7,15,7,16],[7,17,7,28],[7,29,7,31],[6,0,6,1],[6,2,6,4],[6,5,6,8],[6,9,6,14],[6,15,6,16],[6,17,6,28],[7,32,7,34],[7,35,7,37],[8,0,8,1],[8,2,8,4],[8,5,8,8],[8,9,8,14],[8,15,8,16],[8,17,8,28],[8,29,8,31],[8,32,8,34],[8,35,8,37],[9,0,9,1],[9,2,9,4],[9,5,9,8],[9,9,9,14],[9,15,9,16],[9,17,9,28],[9,29,9,31],[9,32,9,34],[9,35,9,37],[10,29,10,31],[10,32,10,34],[10,35,10,37],[11,0,11,1],[11,2,11,4],[11,5,11,8],[11,9,11,14],[11,15,11,16],[11,17,11,28],[11,29,11,31],[10,0,10,1],[10,2,10,4],[10,5,10,8],[10,9,10,14],[10,15,10,16],[10,17,10,28],[11,32,11,34],[11,35,11,37],[12,0,12,1],[12,2,12,4],[12,5,12,8],[12,9,12,14],[12,15,12,16],[12,17,12,28],[12,29,12,31],[12,32,12,34],[12,35,12,37],[13,0,13,1],[13,2,13,4],[13,5,13,8],[13,9,13,14],[13,15,13,16],[13,17,13,28],[13,29,13,31],[13,32,13,34],[13,35,13,37],[14,29,14,31],[14,32,14,34],[14,35,14,37],[15,0,15,1],[15,2,15,4],[15,5,15,8],[15,9,15,14],[15,15,15,16],[15,17,15,28],[15,29,15,31],[14,0,14,1],[14,2,14,4],[14,5,14,8],[14,9,14,14],[14,15,14,16],[14,17,14,28],[15,32,15,34],[15,35,15,37],[16,0,16,1],[16,2,16,4],[16,5,16,8],[16,9,16,14],[16,15,16,16],[16,17,16,28],[16,29,16,31],[16,32,16,34],[16,35,16,37],[17,0,17,1],[17,2,17,4],[17,5,17,8],[17,9,17,14],[17,15,17,16],[17,17,17,28],[17,29,17,31],[17,32,17,34],[17,35,17,37],[18,29,18,31],[18,32,18,34],[18,35,18,37],[19,0,19,1],[19,2,19,4],[19,5,19,8],[19,9,19,14],[19,15,19,16],[19,17,19,28],[19,29,19,31],[18,0,18,1],[18,2,18,4],[18,5,18,8],[18,9,18,14],[18,15,18,16],[18,17,18,28],[19,32,19,34],[19,35,19,37],[20,0,20,1],[20,2,20,4],[20,5,20,8],[20,9,20,14],[20,15,20,16],[20,17,20,28],[20,29,20,31],[20,32,20,34],[20,35,20,37],[21,0,21,1],[21,2,21,4],[21,5,21,8],[21,9,21,14],[21,15,21,16],[21,17,21,28],[21,29,21,31],[21,32,21,34],[21,35,21,37],[22,29,22,31],[22,32,22,34],[22,35,22,37],[23,0,23,1],[23,2,23,4],[23,5,23,8],[23,9,23,14],[23,15,23,16],[23,17,23,28],[23,29,23,31],[22,0,22,1],[22,2,22,4],[22,5,22,8],[22,9,22,14],[22,15,22,16],[22,17,22,28],[23,32,23,34],[23,35,23,37],[24,0,24,1],[24,2,24,4],[24,5,24,8],[24,9,24,14],[24,15,24,16],[24,17,24,28],[24,29,24,31],[24,32,24,34],[24,35,24,37],[25,0,25,1],[25,2,25,4],[25,5,25,8],[25,9,25,14],[25,15,25,16],[25,17,25,28],[25,29,25,31],[25,32,25,34],[25,35,25,37],[26,29,26,31],[26,32,26,34],[26,35,26,37],[27,0,27,1],[27,2,27,4],[27,5,27,8],[27,9,27,14],[27,15,27,16],[27,17,27,28],[27,29,27,31],[26,0,26,1],[26,2,26,4],[26,5,26,8],[26,9,26,14],[26,15,26,16],[26,17,26,28],[27,32,27,34],[27,35,27,37],[28,0,28,1],[28,2,28,4],[28,5,28,8],[28,9,28,14],[28,15,28,16],[28,17,28,28],[28,29,28,31],[28,32,28,34],[28,35,28,37],[29,0,29,1],[29,2,29,4],[29,5,29,8],[29,9,29,14],[29,15,29,16],[29,17,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[30,29,30,31],[30,32,30,34],[30,35,30,37],[30,0,30,1],[30,2,30,4],[30,5,30,8],[30,9,30,14],[30,15,30,16],[30,17,30,28]]}
["Application Development Team (ADT) Support Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CalHome Coverpage'!A49","v":"Rev. 8/14/19"}]
["Please complete the \"yellow\" cells in the form below and email a copy to: AppSupport@hcd.ca.gov. A member of the Application Development Team will respond to your request within ASAP. "]
["Full Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Requested:",null,null,null,null,null,null,null,"Application Version Date:"]
["Organization:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,"Contact Phone:"]
["Justification:"]
["Issue #",null,"Program Name & Round",null,null,"Tab",null,null,null,"Section",null,null,null,null,null,"Cell#",null,"Update/Comment",null,null,null,null,null,null,null,null,null,null,null,"Urgency ",null,null,"ADT Status",null,null,"Status Date",null,null,"Requestor","Email","Phone","App Version"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",$D$3)","v":""},{"$f":"IF(C7=\"\",\"\",$R$4)","v":""},{"$f":"IF(C7=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C7=\"\",\"\",$AI$3)","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C8=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C8=\"\",\"\",$AI$3)","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C9=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C9=\"\",\"\",$AI$3)","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C10=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C10=\"\",\"\",$AI$3)","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C11=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C11=\"\",\"\",$AI$3)","v":""}]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]

{"sheet":"Dropdowns","index":11,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["First-Time Homebuyer for Mortgage Assistance (Article 4)","Homeownership Project Development Loans (Article 8)","Technical Assistance for Self-Help Housing Projects (Article 6)","DR-4344","Applying for funds in a county in which it has developed a homeownership project within the county the last four years","Butte","OOR - other than accessory dwelling units or manufactured housing units","Fee Title","Alameda","First-Time Homebuyer for Mortgage Assistance (Article 4)","Townhouse","Conventional"]
["Owner-Occupied Rehabilitation (Article 5)",null,null,"DR-4353","Applying for funds in a county in which it has operated a housing program within the county the last four years","Lake","OOR - accessory dwelling units","Option to Purchase","Alpine","First-Time Homebuyer for Mortgage Assistance (Article 4) & Owner-Occupied Rehabilitation (Article 5)","Single Family","FHA"]
["Technical Assistance for Shared Housing Programs (Article 7)",null,null,"DR-4382","Applicant has an existing 523 Self-Help Technical Assistance Grant Agreement with United States Department of Agriculture (USDA)","Los Angeles","OOR - junior accessory dwelling units","Disposition and Development Agreement (DDA)","Amador","First-Time Homebuyer for Mortgage Assistance (Article 4) & Technical Assistance for Shared Housing Programs (Article 7)","Condominium","CalHFA"]
[null,null,null,"DR-4407",null,"Mendocino","OOR - manufactured housing","Sales Contract","Butte","Owner-Occupied Rehabilitation (Article 5)","Duplex/Triplex","USDA-Rural Development"]
[null,null,null,null,null,"Napa",null,"Leasehold Interest","Calaveras","Owner-Occupied Rehabilitation (Article 5) & Technical Assistance for Shared Housing Programs (Article 7)","Manufactured Housing","Federal HOME"]
[null,null,null,null,null,"Nevada",null,"Other (Describe Below)","Colusa","Technical Assistance for Shared Housing Programs (Article 7)","Other (describe in narrative below)","Redevelopment Agency"]
[null,null,null,null,null,"Orange",null,null,"Contra Costa",null,null,"Other"]
[null,null,null,null,null,"San Diego",null,null,"Del Norte","Homeownership Project Development Loans (Article 8)"]
[null,null,null,null,null,"Santa Barbara",null,null,"El Dorado","Homeownership Project Development Loans (Article 8) & Technical Assistance for Self-Help Housing Projects (Article 6)"]
[null,null,null,null,null,"Shasta",null,null,"Fresno"]
[null,null,null,null,null,"Sonoma",null,null,"Glenn"]
[null,null,null,null,null,"Ventura",null,null,"Humboldt"]
[null,null,null,null,null,null,null,null,"Imperial"]
[null,null,null,null,null,null,null,null,"Inyo"]
[null,null,null,null,null,null,null,null,"Kern"]
[null,null,null,null,null,null,null,null,"Kings"]
[null,null,null,null,null,null,null,null,"Lake"]
[null,null,null,null,null,null,null,null,"Lassen"]
[null,null,null,null,null,null,null,null,"Los Angeles"]
[null,null,null,null,null,null,null,null,"Madera"]
[null,null,null,null,null,null,null,null,"Marin"]
[null,null,null,null,null,null,null,null,"Mariposa"]
[null,null,null,null,null,null,null,null,"Mendocino"]
[null,null,null,null,null,null,null,null,"Merced"]
[null,null,null,null,null,null,null,null,"Modoc"]
[null,null,null,null,null,null,null,null,"Mono"]
[null,null,null,null,null,null,null,null,"Monterey"]
[null,null,null,null,null,null,null,null,"Napa"]
[null,null,null,null,null,null,null,null,"Nevada"]
[null,null,null,null,null,null,null,null,"Orange"]
[null,null,null,null,null,null,null,null,"Placer"]
[null,null,null,null,null,null,null,null,"Plumas"]
[null,null,null,null,null,null,null,null,"Riverside"]
[null,null,null,null,null,null,null,null,"Sacramento"]
[null,null,null,null,null,null,null,null,"San Benito"]
[null,null,null,null,null,null,null,null,"San Bernardino"]
[null,null,null,null,null,null,null,null,"San Diego"]
[null,null,null,null,null,null,null,null,"San Francisco"]
[null,null,null,null,null,null,null,null,"San Joaquin"]
[null,null,null,null,null,null,null,null,"San Luis Obispo"]
[null,null,null,null,null,null,null,null,"San Mateo"]
[null,null,null,null,null,null,null,null,"Santa Barbara"]
[null,null,null,null,null,null,null,null,"Santa Clara"]
[null,null,null,null,null,null,null,null,"Santa Cruz"]
[null,null,null,null,null,null,null,null,"Shasta"]
[null,null,null,null,null,null,null,null,"Sierra"]
[null,null,null,null,null,null,null,null,"Siskiyou"]
[null,null,null,null,null,null,null,null,"Solano"]
[null,null,null,null,null,null,null,null,"Sonoma"]
[null,null,null,null,null,null,null,null,"Stanislaus"]
[null,null,null,null,null,null,null,null,"Sutter"]
[null,null,null,null,null,null,null,null,"Tehama"]
[null,null,null,null,null,null,null,null,"Trinity"]
[null,null,null,null,null,null,null,null,"Tulare"]
[null,null,null,null,null,null,null,null,"Tuolumne"]
[null,null,null,null,null,null,null,null,"Ventura"]
[null,null,null,null,null,null,null,null,"Yolo"]
[null,null,null,null,null,null,null,null,"Yuba"]

{"sheet":"Tables","index":12,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["County","Approx. Allocation"]
["Butte",34000000]
["Lake",5000000]
["Los Angeles",7000000]
["Mendocino",5000000]
["Napa",7000000]
["Nevada",1000000]
["Orange",1000000]
["San Diego",3000000]
["Santa Barbara",3000000]
["Shasta",7000000]
["Sonoma",20000000]
["Ventura",7000000]
["Total",{"$f":"SUM(B2:O13)","v":100000000}]