{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","General Info","Staff Exp & Training","Outreach Plan","Demonstrated Exp.","Client Demographics","Current & Projected Goals","Leverage","Budget"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,5,10],[1,0,1,19]]}
[]
["Instructions"]
[]
[]
[null,"How to Use this Workbook"]
[null,"• This workbook requires Excel 2013 or newer. \n• The document is best viewed at 90% zoom; or YOU MAY NEED TO SCROLL RIGHT to enter all information.  \n• All \"Applicants\" must complete all eight (8) tabs; General Info, Staff Exp & Training, Outreach Plan, Demonstrated Exp., Client Demographics, Current & Projected Goals, Leverage and Budget tabs.\n• Do not attempt to modify this workbook or override formulas. Agency will consider any Application that has attempted to be or succeeded in being modified as non-responsive. Any Application found to be non-responsive will not be considered for funding. \nNOTE: Provide an answer for all sections.  There are drop-down pre-filled areas, auto-populating fields (i.e. Organization name), and locked formulas and unrestricted areas for answers. \n\n"]
[]
[]
[null,"revised 04/14/2021"]

{"sheet":"General Info","index":1,"n_rows":96,"n_cols":7,"rows_kept":96,"cut":false,"hidden":false,"merged":[[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[0,0,0,6],[1,0,1,1],[19,0,19,1],[20,0,21,1],[19,2,19,3],[18,0,18,3],[20,2,20,3],[21,2,21,3],[17,0,17,5],[2,0,2,6],[1,2,1,5],[11,0,11,4],[26,2,26,3],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3]]}
["Homeownership Center: General Information"]
["Legal name of Applicant \"Organization\" "]
["Geographic Location of Services: OHCS strives for an equitable geographic distribution of funds in order to meet the needs of consumers, while ensuring that Services will be provided throughout the state.  List all the county (ies) your Organization has a physical office location that provides Full Time, Full Services to clients (Eligible Branch Office).  A Full Time location is a location that has at minimum one (1) Certified Counselor available to provide Full Services for a minimum  of thirty two (32) hours per week .  Full Service is to be able to provide all the required core services (see full definition in RFA under \"Definition of Terms\").                                                                                                                                                                                                                                                                                                                                "]
["County of Eligible Branch Office(s)","Location Type","Federal Tax ID#","Secretary of State Business Registry ID#","Year (yyyy) Organization/Branch was established ","Number of hours location is open per week","Certified Counselor available at this location?"]
[]
[null,null,"n/a","n/a"]
[null,null,"n/a","n/a"]
[null,null,"n/a","n/a"]
[null,null,"n/a","n/a"]
[null,null,"n/a","n/a"]
[null,null,"n/a","n/a"]
["Organization and Contacts\nThe HOAP-Homeownership Center notifications will be sent electronically, list the primary contact persons at your Organization that should receive Award notifications and/or the Grant Agreement. \n- Executive Director Information: The person that will be listed as the Authorized Representative in the Agreement.\n"]
[" Name","Title","Email","Address","Phone Number"]
[null,"Executive Director"]
[]
[]
[]
["Application and Funding Request\nINSTRUCTIONS: Enter the number of Eligible Branch Offices you are requesting \"Base Funding\" for (the total amount requested will add up on line 22 based on number of Eligible Branch Offices and county amounts) (Definition of \"Eligible Branch Office\" is listed in the RFA under \"Definition of Terms\", county allocation amounts are listed in the Funding Guidelines and Allocations Section)\nIndicate the county you are applying to provide Program Services in, with or without an Eligible Branch Office.  For Program descriptions, please see the RFA.                                                                                                                                                                                                                                                                        Disclaimer: Additional Rural County allocation of $5,000 is not included in the county allocation amounts listed below.  The HOAP 2021/2022 amount projected may not be the final amount Awarded based on Section 2.3.2 through 2.3.2.5.      "]
["HOAP-Homeownership Center Funding Request (July 1, 2021 through June 30, 2022)",null,null,null,{"$f":"SUM(E24:E31)+E22","v":0}]
["Branch Locations",null,null,null,"Total Branch Allocation"]
["Number of \"Eligible\" Branch Office Locations",null," # Locations"]
[null,null,"$45,000 per Eligible Branch Office Location",null,{"$f":"E21*45000","v":0}]
["Service Area",null," Select County",null,"County Allocation"]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C24=A59,F59,IF(C24=A60,F60,IF(C24=A61,F61,IF(C24=A62,F62,IF(C24=A63,F63,IF(C24=A64,F64,IF(C24=A65,F65,IF(C24=A66,F66,IF(C24=A67,F67,IF(C24=A68,F68,IF(C24=A69,F69,IF(C24=A70,F70,IF(C24=A71,F71,IF(C24=A72,F72,IF(C24=A73,F73,IF(C24=A74,F74,IF(C24=A75,F75,IF(C24=A76,F76,IF(C24=A77,F77,IF(C24=A78,F78,IF(C24=A79,F79,IF(C24=A80,F80,IF(C24=A81,F81,IF(C24=A82,F82,IF(C24=A83,F83,IF(C24=A84,F84,IF(C24=A85,F85,IF(C24=A86,F86,IF(C24=A87,F87,IF(C24=A88,F88,IF(C24=A89,F89,IF(C24=A90,F90,IF(C24=A91,F91,IF(C24=A92,F92,IF(C24=A93,F93,IF(C24=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C25=A59,F59,IF(C25=A60,F60,IF(C25=A61,F61,IF(C25=A62,F62,IF(C25=A63,F63,IF(C25=A64,F64,IF(C25=A65,F65,IF(C25=A66,F66,IF(C25=A67,F67,IF(C25=A68,F68,IF(C25=A69,F69,IF(C25=A70,F70,IF(C25=A71,F71,IF(C25=A72,F72,IF(C25=A73,F73,IF(C25=A74,F74,IF(C25=A75,F75,IF(C25=A76,F76,IF(C25=A77,F77,IF(C25=A78,F78,IF(C25=A79,F79,IF(C25=A80,F80,IF(C25=A81,F81,IF(C25=A82,F82,IF(C25=A83,F83,IF(C25=A84,F84,IF(C25=A85,F85,IF(C25=A86,F86,IF(C25=A87,F87,IF(C25=A88,F88,IF(C25=A89,F89,IF(C25=A90,F90,IF(C25=A91,F91,IF(C25=A92,F92,IF(C25=A93,F93,IF(C25=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C26=A59,F59,IF(C26=A60,F60,IF(C26=A61,F61,IF(C26=A62,F62,IF(C26=A63,F63,IF(C26=A64,F64,IF(C26=A65,F65,IF(C26=A66,F66,IF(C26=A67,F67,IF(C26=A68,F68,IF(C26=A69,F69,IF(C26=A70,F70,IF(C26=A71,F71,IF(C26=A72,F72,IF(C26=A73,F73,IF(C26=A74,F74,IF(C26=A75,F75,IF(C26=A76,F76,IF(C26=A77,F77,IF(C26=A78,F78,IF(C26=A79,F79,IF(C26=A80,F80,IF(C26=A81,F81,IF(C26=A82,F82,IF(C26=A83,F83,IF(C26=A84,F84,IF(C26=A85,F85,IF(C26=A86,F86,IF(C26=A87,F87,IF(C26=A88,F88,IF(C26=A89,F89,IF(C26=A90,F90,IF(C26=A91,F91,IF(C26=A92,F92,IF(C26=A93,F93,IF(C26=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C27=A59,F59,IF(C27=A60,F60,IF(C27=A61,F61,IF(C27=A62,F62,IF(C27=A63,F63,IF(C27=A64,F64,IF(C27=A65,F65,IF(C27=A66,F66,IF(C27=A67,F67,IF(C27=A68,F68,IF(C27=A69,F69,IF(C27=A70,F70,IF(C27=A71,F71,IF(C27=A72,F72,IF(C27=A73,F73,IF(C27=A74,F74,IF(C27=A75,F75,IF(C27=A76,F76,IF(C27=A77,F77,IF(C27=A78,F78,IF(C27=A79,F79,IF(C27=A80,F80,IF(C27=A81,F81,IF(C27=A82,F82,IF(C27=A83,F83,IF(C27=A84,F84,IF(C27=A85,F85,IF(C27=A86,F86,IF(C27=A87,F87,IF(C27=A88,F88,IF(C27=A89,F89,IF(C27=A90,F90,IF(C27=A91,F91,IF(C27=A92,F92,IF(C27=A93,F93,IF(C27=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C28=A59,F59,IF(C28=A60,F60,IF(C28=A61,F61,IF(C28=A62,F62,IF(C28=A63,F63,IF(C28=A64,F64,IF(C28=A65,F65,IF(C28=A66,F66,IF(C28=A67,F67,IF(C28=A68,F68,IF(C28=A69,F69,IF(C28=A70,F70,IF(C28=A71,F71,IF(C28=A72,F72,IF(C28=A73,F73,IF(C28=A74,F74,IF(C28=A75,F75,IF(C28=A76,F76,IF(C28=A77,F77,IF(C28=A78,F78,IF(C28=A79,F79,IF(C28=A80,F80,IF(C28=A81,F81,IF(C28=A82,F82,IF(C28=A83,F83,IF(C28=A84,F84,IF(C28=A85,F85,IF(C28=A86,F86,IF(C28=A87,F87,IF(C28=A88,F88,IF(C28=A89,F89,IF(C28=A90,F90,IF(C28=A91,F91,IF(C28=A92,F92,IF(C28=A93,F93,IF(C28=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C29=A59,F59,IF(C29=A60,F60,IF(C29=A61,F61,IF(C29=A62,F62,IF(C29=A63,F63,IF(C29=A64,F64,IF(C29=A65,F65,IF(C29=A66,F66,IF(C29=A67,F67,IF(C29=A68,F68,IF(C29=A69,F69,IF(C29=A70,F70,IF(C29=A71,F71,IF(C29=A72,F72,IF(C29=A73,F73,IF(C29=A74,F74,IF(C29=A75,F75,IF(C29=A76,F76,IF(C29=A77,F77,IF(C29=A78,F78,IF(C29=A79,F79,IF(C29=A80,F80,IF(C29=A81,F81,IF(C29=A82,F82,IF(C29=A83,F83,IF(C29=A84,F84,IF(C29=A85,F85,IF(C29=A86,F86,IF(C29=A87,F87,IF(C29=A88,F88,IF(C29=A89,F89,IF(C29=A90,F90,IF(C29=A91,F91,IF(C29=A92,F92,IF(C29=A93,F93,IF(C29=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C30=A59,F59,IF(C30=A60,F60,IF(C30=A61,F61,IF(C30=A62,F62,IF(C30=A63,F63,IF(C30=A64,F64,IF(C30=A65,F65,IF(C30=A66,F66,IF(C30=A67,F67,IF(C30=A68,F68,IF(C30=A69,F69,IF(C30=A70,F70,IF(C30=A71,F71,IF(C30=A72,F72,IF(C30=A73,F73,IF(C30=A74,F74,IF(C30=A75,F75,IF(C30=A76,F76,IF(C30=A77,F77,IF(C30=A78,F78,IF(C30=A79,F79,IF(C30=A80,F80,IF(C30=A81,F81,IF(C30=A82,F82,IF(C30=A83,F83,IF(C30=A84,F84,IF(C30=A85,F85,IF(C30=A86,F86,IF(C30=A87,F87,IF(C30=A88,F88,IF(C30=A89,F89,IF(C30=A90,F90,IF(C30=A91,F91,IF(C30=A92,F92,IF(C30=A93,F93,IF(C30=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
["List the county your Organization will provide service to: ",null,null,null,{"$f":"IF(C31=A59,F59,IF(C31=A60,F60,IF(C31=A61,F61,IF(C31=A62,F62,IF(C31=A63,F63,IF(C31=A64,F64,IF(C31=A65,F65,IF(C31=A66,F66,IF(C31=A67,F67,IF(C31=A68,F68,IF(C31=A69,F69,IF(C31=A70,F70,IF(C31=A71,F71,IF(C31=A72,F72,IF(C31=A73,F73,IF(C31=A74,F74,IF(C31=A75,F75,IF(C31=A76,F76,IF(C31=A77,F77,IF(C31=A78,F78,IF(C31=A79,F79,IF(C31=A80,F80,IF(C31=A81,F81,IF(C31=A82,F82,IF(C31=A83,F83,IF(C31=A84,F84,IF(C31=A85,F85,IF(C31=A86,F86,IF(C31=A87,F87,IF(C31=A88,F88,IF(C31=A89,F89,IF(C31=A90,F90,IF(C31=A91,F91,IF(C31=A92,F92,IF(C31=A93,F93,IF(C31=A94,F94,\"\"))))))))))))))))))))))))))))))))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Drop down lists - do not alter or delete",null,"Drop down lists - do not alter or delete"]
[null,"Drop down lists - do not alter or delete",null,null,null,"Drop down lists - do not alter or delete"]
["Region","Location Type","Yes"]
["Baker","Main ","No",null,null,11309.59]
["Benton","Branch",null,null,null,19502.52]
["Clackamas",null,null,null,null,42198.75]
["Clatsop",null,null,null,null,13176.56]
["Columbia",null,null,null,null,4240.01]
["Coos",null,null,null,null,11240.63]
["Crook",null,null,null,null,6665.29]
["Curry",null,null,null,null,10112.33]
["Deschutes",null,null,null,null,25426.639999999999]
["Douglas",null,null,null,null,11718.89]
["Gilliam",null,null,null,null,20910.12]
["Grant",null,null,null,null,3000]
["Harney",null,null,null,null,3822.91]
["Hood River",null,null,null,null,11660.19]
["Jackson",null,null,null,null,27294.97]
["Jefferson",null,null,null,null,5621.23]
["Josephine",null,null,null,null,13772.5]
["Klamath",null,null,null,null,12318.35]
["Lake",null,null,null,null,5868]
["Lane",null,null,null,null,51390.85]
["Lincoln",null,null,null,null,11985.89]
["Linn",null,null,null,null,19304.07]
["Malheur",null,null,null,null,9916.58]
["Marion ",null,null,null,null,52218.720000000001]
["Morrow",null,null,null,null,5837.84]
["Multnomah",null,null,null,null,130862.76]
["Polk",null,null,null,null,16586.740000000002]
["Sherman",null,null,null,null,7732.8]
["Tillamook",null,null,null,null,12587.83]
["Umatilla",null,null,null,null,11546.77]
["Union",null,null,null,null,9631.5]
["Wallowa",null,null,null,null,3000]
["Wasco",null,null,null,null,7901]
["Washington",null,null,null,null,83327.31]
["Wheeler",null,null,null,null,3000]
["Yamhill",null,null,null,null,17325.400000000001]
[]
[null,null,null,null,null,{"$f":"SUM(F59:F95)","v":714015.54000000015}]

{"sheet":"Staff Exp & Training","index":2,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,5,1],[2,1,2,8],[1,0,1,8],[0,0,0,8]]}
["Homeownership Center: Staff Experience and Training"]
["Instructions: Complete the information for each Homeownership Counselor (coach, counselor, educator) who provides direct Services to clients. \n     • Do not list staff that are solely providing management or administrative support. \n     • Complete one row for each Counselor and Service type/Program in which that person provides Services  (see example below). \n     • Enter the languages spoken fluently by each Counselor as a list separated by commas (e.g. English, Somali, Arabic)\n     • The Program/Certification Type called Homebuyer Counseling applies to both types of 1:1 Homebuyer Services (Financial Literacy and Homebuyer Counseling) \n     • If a new counselor is not yet certified, include the anticipated date of certification. \n     • Enter number of hours of continuing education completed in the past year for each staff and Program/Certification type. "]
["Organization Name:",{"$f":"'General Info'!C2","v":0}]
[]
["Staff Name","Languages Spoken","Hire Date","Years Experience ","Program/ \nCertification Type","Certifying Entity","Original Date of Certification\n(or anticipated date)","Certification Expiration Date","Continuing Education Hours Past 12 months"]
[null,null,"(mm/dd/yyyy)","(# years)","(Program Area)","(Name of Entity)","(mm/dd/yyyy)","(mm/dd/yyyy)","(# hours)"]
["Sara Example","English, Spanish","2014-04-01",6,"Homebuyer Counseling","NeighborWorks America - NCHEC","2015-06-22","2021-06-22",13]
["David Sample","English","2019-11-15",0.5,"Foreclosure Counseling","Anticipated/TBD","2021-06-15",null,3.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Drop down lists - do not alter or delete"]
["Homebuyer Education ",null,null,null,null,"Drop down lists - do not alter or delete"]
["Homebuyer Counseling",null,null,null,null,"NeighborWorks America - NCHEC"]
["Foreclosure Counseling",null,null,null,null,"Rural Community Assistance Corp.- RCAC"]
["Financial Literacy",null,null,null,null,"UnidosUS - formerly NCLR"]
[null,null,null,null,null,"HUD (HECM counseling only)"]
[null,null,null,null,null,"Anticipated/TBD"]

{"sheet":"Outreach Plan","index":3,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,1,2,4]]}
["Homeownership Center 2021/2022: Outreach Plan "]
["Instructions: Complete the worksheet to describe your Outreach Plan. Complete columns A-E for each Outreach activity (see examples below in green). Describe three (3) or more activites that will be conducted for each Program area during the upcoming Program year (July 1, 2021 - June 30, 2022).  This should be your complete Outreach Plan, this Plan will be used for one of your Performance Measures and may be negotiated at Award, and subject to OHCS approval.   Include outreach to industry partners and methods that reach low-income and under-served populations, such as Communities of Color.  Indicate methods that encourage consumers to participate early in the process (e.g., before a purchase agreement is signed, at onset of rent or mortgage default). "]
["Organization Name:",{"$f":"'General Info'!C2","v":0}]
[]
["Outreach Activity \n(Describe the outreach activity in detail)","Identify Program(s) \n(Select from the drop-down list to identify Program areas for each outreach activity)","Target Population                                         \n (List the target client population to be reached by the outreach activity)","# Events \n(List the number of events that will be conducted)","Estimate # Reached \n(Estimate the total number to reach and clients to serve)"]
["Individual meetings with 6 realtor offices in Marion County to promote homebuyer education & counseling programs. ","Homebuyer Services (Education and/or 1:1 Services)","Realtors in Salem who work with first-time homebuyers and low to moderate income households.","6 meetings","12 realtors, 24 client referrals."]
["Include inserts with foreclosure counseling information with monthly water bills, for households who are behind on utility payments.","Default Counseling","Homeowners in Harney county who are delinquent on utilities.","4 bill inserts (once per quarter)","1000 inserts, 20 clients"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Drop down lists - do not alter or delete"]
["Homebuyer Services (Education and/or 1:1 Counseling)"]
["Default and Post-purchase Counseling"]
["Financial Literacy (Education and/or 1:1 Counseling)"]
["All Programs"]

{"sheet":"Demonstrated Exp.","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,0,8,0],[2,1,2,2],[0,0,0,2],[5,0,6,0],[1,0,1,2]]}
["Homeownership Center 2020: Demonstrated Experience"]
["Instructions: All Applicants applying for funding must complete this chart. Enter your Program results from Jan. 1, 2020 through Dec. 31, 2020 in the \"Achieved\" column.  If you did not provide any of the Services listed during the time period, please enter; \"N/A-not offered\" in the \"Achieved\" column."]
["Organization Name:",{"$f":"'General Info'!C2","v":0}]
[]
["Education Activity","Events","Achieved \n(Jan. 1, 2020 - Dec. 31, 2020)"]
["Homebuyer Education \n"," # Workshops held"]
[null," # Households completed workshop"]
["Financial Literacy Education \n"," # Workshops held"]
[null," # Households completed workshop"]
["Counseling Activity","Events","Achieved \n(Jan. 1, 2020 - Dec. 31, 2020)"]
["Financial Literacy\n"," # Households counseled"]
["Homebuyer Counseling\n"," # Households counseled "]
["Post-Purchase Counseling                            OR Similar Program"," # Households counseled "]
["Default/Foreclosure Counseling                                   "," # Households counseled"]

{"sheet":"Client Demographics","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,1],[2,2,2,5]]}
["Homeownership Center Client Demographic Projections"]
["In an effort to achieve our Statewide Housing Plan Priority for Equity and Racial Justice, OHCS is seeking Organizations and Culturally Specific Organizations to provide Services throughout the state.  To do this, your Demographic projections and a \"Representative Sample\" (using the 2013-2017 CHAS Data) for each County, will be used to determine your Demographic Goals for serving Communities of Color as one of the Performance Measures, and may be negotiated at Award, and subject to OHCS approval.                                                                                                                                                                                                     Instructions: For each county you intend on providing Services, input the number of clients* you will serve in each Demographic Category during the Program year; July 1, 2021 through June 30, 2022.  Your totals here should equal your total client/households projections in the next tab (Current & Projected Goals).  \n • It is expected, Organizations Certified as a \"Culturally Specific Organization\" would have a majority of their projected clients listed in one Demographic Category.                                                                                                                                                                           *Projected clients should be from specific Homeownership Center Programs only; Homebuyer/Pre-purchase, Financial Literacy, Post-purchase and Default (not Oregon Foreclosure Avoidance) for counseling and education Services.                                                                                                                        \n     "]
["Organization Name:",null,null,null,null,null,"\"Representative Sample\" Data Link"]
[]
["Service County","American Indian/Alaska Native","Asian","Black or African American","Native Hawaiian/Pacific Islander","Other Not Listed","Two or more races","Hispanic or Latino","White"]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals",{"$f":"SUM(B6:B13)","v":0},0,0,0,0,0,0,0]

{"sheet":"Current & Projected Goals","index":6,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[14,0,14,3],[1,0,1,3],[2,1,2,3],[0,0,0,3],[5,0,6,0],[7,0,8,0]]}
["Homeownership Center : Current & Projected Goals"]
["Instructions: All Applicants must complete this worksheet.  In Column C, list your 2021 Program goals.  In Column D, list your \"projected\" Program goals for the 2021/2022 Program year.  Your total amount of households/clients projected should equal the Demographic Goal  below.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               -The goals being proposed for the 2021/2022 Program year will be used for one of your Performance Measures and may be negotiated at time of Award, and subject to OHCS approval. \n-If 2021/2022 projected goals differ greatly from either your current year or your past performance (Demonstrated Exp.), OHCS evaluators may request an explanation during the application review."]
["Organization Name:",{"$f":"'General Info'!C2","v":0}]
[]
["Group Education","Events","Current Year Goals\n(Jan. 1, 2021 through Dec. 31, 2021)","Projected Goal    Program Year\n(July 1, 2021 through June 30, 2022)"]
["Homebuyer Education \n(Workshops)"," # Workshops"]
[null," # Households completed workshop"]
["Financial Literacy Education \n(Workshops)"," # Workshops"]
[null," # Households completed workshop"]
["Counseling","Events","Current Year Goals\n(Jan. 1, 2021 through Dec. 31, 2021)","Projected Goal    Program Year\n(July 1, 2021 through June 30, 2022)"]
["1:1 Homebuyer Services \n"," # Households counseled"]
["1:1 Financial Literacy\n "," # Households counseled "]
["1:1 Post-Purchase"," # Households counseled"]
["1:1 Default/Foreclosure"," # Households counseled"]
["Demographic Goals                                                                                                                                  Using your client data of households served/achieved (Demonstrated Exp.), list the number of clients served for each Demographic category listed below in Column C .  In Column D, your Projected \"Client Demographics\" from the previous tab will auto-populate your Goal for the 2021/2022 Program year.                                                                                                                                                                                      - The \"Client Demographic\" goals for each county proposed in the previous tab will populate the aggregated goal for the 2021/2022 Program year.  A \"Representative Sample\" of each County will be used to determine your baseline Demographic Goals for serving Communities of Color as one of your Performance Measures and may be negotiated at time of Award, and subject to OHCS approval."]
["Demographic Goals                   ",null,"Achieved Previous Year\n(Jan. 1, 2020 through Dec. 31, 2020)","Projected Goal    Program Year\n(July 1, 2021 through June 30, 2022)"]
["American Indian/Alaska Native"," # Households served",null,{"$f":"'Client Demographics'!B14","v":0}]
["Asian"," # Households served ",null,{"$f":"'Client Demographics'!C14","v":0}]
["Black or African American"," # Households served",null,{"$f":"'Client Demographics'!D14","v":0}]
["Native Hawaiian/Pacific Islander"," # Households served ",null,{"$f":"'Client Demographics'!E14","v":0}]
["Other Not Listed"," # Households served",null,{"$f":"'Client Demographics'!F14","v":0}]
["Two or more races"," # Households served ",null,{"$f":"'Client Demographics'!G14","v":0}]
["Hispanic or Latino"," # Households served ",null,{"$f":"'Client Demographics'!H14","v":0}]
["White"," # Households served ",null,{"$f":"'Client Demographics'!I14","v":0}]

{"sheet":"Leverage","index":7,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,1,2,5],[0,0,0,5],[1,0,1,5],[4,0,4,5]]}
["Homeownership 2021/2022: Program Leverage "]
["Instructions: Complete the Pending and Committed Leverage charts below.                                                                                                                                                                                         *Only list the amount available during the upcoming Homeownership Center Program year of July 1, 2021 - June 30, 2022. Leverage sources that do not overlap the entire Homeownership Center Program year should be pro-rated, as shown in the \"ABC Mortgage\" example below.                                                                                                                                                                                                                             \n     • Complete one row for each source of leverage.\n     • Do not list your requested Homeownership Center grant in this chart.      \n     • Only list sources that relate to the required core Homeownership Center Services.\n     • By filling out this leverage chart your Organization is self-certifying the amount of leverage expected from all sources.  If an explanation is             needed, include your comments in the \"additional information\" section.  No additional documentation is required to submit with Application, but may be requested anytime between evaluation and Agreement negotiation."]
["Organization Name:",{"$f":"'General Info'!C2","v":0}]
[]
["Leverage (available during 7/01/2021 - 6/30/2022)"]
["Name of Source","Type\n(select from dropdown list)  ","Amount \n(available during 7/01/2021 - 6/30/2022)","Commitment Date\n(current or anticipated)","Length of Time Receiving\n(select from dropdown list)     ","Additional Information"]
["ABC Mortgage","Corporate",6000,"2021-01-01","New source","Total grant amount = $8000\ngrant period 6/1/21 - 10/31/21"]
["Homeownership Capacity ","Government",26500,"2021-07-01","1 year"]
["Volunteer Presenters","In-Kind",4800,"2021-07-01","2 years"]
["Workshop fees","Earned Income",3200,"2021-01-01","3+ years","Amount matches projected goals"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["TOTAL Leverage",null,{"$f":"SUM(C11:C26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Drop down list - do not alter or delete"]
["Government"]
["Corporate"]
["In-kind"]
["Earned Income"]
["Other"]
["New source"]
["1 year"]
["2 years"]
["3+ years"]

{"sheet":"Budget","index":8,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,4,12,5],[21,1,21,2],[13,1,13,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[14,1,14,2],[0,0,0,6],[11,0,11,2],[6,4,6,5],[4,0,4,2],[5,4,5,5],[4,4,4,5],[3,0,3,6],[5,0,5,2],[7,4,7,5],[11,4,11,5],[34,1,34,2],[2,1,2,5],[1,0,1,5],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[12,1,12,2]]}
["Homeownership Center 2021/2022: Budget "]
["Instructions: Complete the budget below (rows 14 - 33) for all Homeownership related Programs. The budget should cover July 1, 2021 through June 30, 2022. \n     • The Homeownership Center 2021/2022 request, and Leverage will auto-populate from the other tabs. If any are blank, go to the corresponding tab to make updates.\n     • Do not include any non-homeownership related Programs in your budget. For example, if you are a Community Action Agency, do not include those Program expenses here.                                                                                                                                                                                     \n     • Only use the eligible budget items listed, or use the \"other\" category and specify the item, within the constraints of this document only.  Do not include additional documents to include additional budget items beyond eligible items listed below.             *The HOAP 2021/2022 amount projected may not be the final amount Awarded based on Section 2.3.2 through 2.3.2.5."]
["Organization Name:",{"$f":"'General Info'!C2","v":0}]
[]
["Homeownership Center Budget",null,null,null,"HOAP Budget/Request"]
["INCOME",null,null,null,"INCOME"]
["Source","Amount","Percentage of Total",null,"Amount\nNote: The amount will carry over from column B."]
["HOAP 2021/2022* (General Info tab)",{"$f":"'General Info'!E19","v":0},{"$f":"IF(B8,B8/B10,0)","v":0},null,{"$f":"B8","v":0}]
["Leverage (Leverage tab)",{"$f":"Leverage!C27","v":0},{"$f":"IF(B9,B9/B10,0)","v":0}]
["Total Income",{"$f":"SUM(B8:B9)","v":0}]
[]
[" Total Expenses",null,null,null,"HOAP Funding Expenses"]
["Homeownership Center Eligible Expenses","Instructions: Enter the total amount allocated to Homeownership Programs for each eligible expense.",null,null,"Instructions: Enter the portion of the amount listed in column B/C that will be paid with HOAP funds.  The percentage will auto calculate based off the amount listed in column E and the amount listed in column B/C."]
["Staff Salaries",0,null,null,0,{"$f":"IF(E14,E14/$B14,\" \")","v":" "}]
["Insurance, benefits, and other related taxes (fringe)",0,null,null,0,{"$f":"IF(E15,E15/$B14,\" \")","v":" "}]
["Consultant or professional fees",0,null,null,0,{"$f":"IF(E16,E16/$B16,\" \")","v":" "}]
["Marketing and advertising ",0,null,null,0," "]
["Travel",0,null,null,0," "]
["Equipment ",0,null,null,0," "]
["Materials (handouts, manuals, etc.)",0,null,null,0," "]
["Supplies",0,null,null,0," "]
["Printing and copying",0,null,null,0," "]
["Telephone and Internet",0,null,null,0," "]
["Postage and delivery",0,null,null,0," "]
["Rent and utilities",0,null,null,0," "]
["Staff development/training",0,null,null,0," "]
["Credit report expenses",0,null,null,0," "]
["In-direct expenses",0,null,null,0," "]
["Disbursements (to partner organizations)",0,null,null,0," "]
["Other (specify):",0,null,null,0," "]
["Other (specify):",0,null,null,0," "]
["Other (specify):",0,null,null,0," "]
["Other (specify):",0,null,null,0," "]
["Total Expenses",{"$f":"SUM(B14:B33)","v":0},null,null,{"$f":"SUM(E14:E33)","v":0}]
["Difference (Income less Expense)",{"$f":"B10-B34","v":0},null,null,{"$f":"E8-E34","v":0}]