{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Housing (setup & completion)","Replacement-Displacement only","Data Validation","Validation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":38,"comments":2,"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":"Housing (setup & completion)","index":0,"n_rows":325,"n_cols":86,"rows_kept":325,"cut":false,"hidden":false,"merged":[[314,12,322,78],[91,33,91,49],[84,13,84,36],[219,16,219,37],[219,39,219,77],[206,13,207,48],[206,50,207,53],[206,56,207,59],[206,62,207,65],[206,68,207,71],[206,74,207,77],[209,13,210,48],[209,50,210,53],[212,50,213,53],[212,56,213,59],[212,62,213,65],[212,68,213,71],[219,12,219,15],[203,56,204,59],[203,62,204,65],[203,68,204,71],[192,41,192,52],[194,18,196,54],[194,55,196,79],[88,13,88,31],[324,11,325,79],[198,73,199,77],[227,11,229,17],[231,13,233,33],[212,74,213,77],[224,16,224,37],[224,39,224,77],[218,12,218,78],[221,16,221,37],[221,39,221,77],[222,16,222,37],[222,39,222,77],[223,16,223,37],[223,39,223,77],[201,68,201,71],[201,74,201,77],[227,18,229,54],[227,55,229,79],[209,56,210,59],[209,62,210,65],[209,68,210,71],[209,74,210,77],[212,13,213,48],[38,21,38,54],[52,13,53,43],[39,21,40,54],[39,11,39,20],[35,56,35,67],[192,75,192,79],[191,75,191,79],[191,21,191,27],[192,67,192,74],[192,28,192,37],[192,38,192,40],[192,64,192,66],[192,16,192,20],[36,68,37,79],[55,47,56,63],[54,47,54,63],[93,13,93,35],[117,11,119,17],[117,18,119,54],[117,55,119,79],[79,61,79,77],[92,37,92,43],[58,13,59,54],[58,55,59,77],[35,68,35,79],[36,56,37,67],[42,18,44,54],[42,55,44,79],[51,47,51,77],[52,47,53,77],[46,13,46,43],[38,56,38,71],[38,72,38,73],[38,74,38,79],[46,53,46,77],[39,72,39,79],[39,56,39,71],[48,13,48,43],[40,11,40,13],[42,11,44,17],[40,14,40,20],[40,72,40,79],[40,56,40,71],[49,13,50,43],[36,11,36,13],[36,14,36,20],[38,11,38,20],[35,21,36,54],[51,13,51,43],[79,55,79,60],[48,47,48,77],[49,47,50,77],[192,21,192,27],[191,38,191,40],[189,21,189,27],[189,41,189,52],[175,41,188,52],[190,41,190,52],[189,28,189,37],[191,41,191,52],[191,53,191,56],[192,53,192,56],[112,72,114,74],[108,64,110,66],[144,55,146,79],[144,18,146,54],[55,13,56,30],[70,15,71,36],[190,38,190,40],[75,18,77,54],[75,55,77,79],[75,11,77,17],[54,13,54,43],[79,13,79,24],[81,61,82,77],[62,47,63,77],[189,64,189,66],[175,64,188,66],[190,28,190,37],[190,21,190,27],[65,65,65,77],[61,13,61,43],[62,13,63,43],[189,75,189,79],[189,53,189,56],[84,55,84,77],[85,13,86,52],[189,67,189,74],[175,67,188,74],[166,13,188,15],[81,55,82,60],[125,13,126,47],[131,12,133,23],[108,13,110,25],[108,26,110,28],[108,30,110,50],[55,65,56,77],[190,64,190,66],[235,35,238,46],[240,35,240,46],[276,35,276,46],[276,48,276,53],[276,55,276,63],[235,48,238,53],[66,65,66,77],[244,65,244,76],[203,74,204,77],[190,67,190,74],[191,67,191,74],[198,13,199,46],[189,38,189,40],[175,38,188,40],[189,16,189,20],[190,16,190,20],[191,28,191,37],[162,11,164,17],[89,33,89,52],[88,33,88,52],[91,13,91,31],[89,13,89,31],[297,14,297,35],[299,14,299,35],[235,14,238,33],[166,12,188,12],[132,24,133,47],[92,13,92,31],[171,21,188,27],[171,28,188,37],[201,13,201,48],[99,18,101,54],[162,18,164,54],[121,12,123,36],[175,53,188,56],[112,42,114,71],[194,11,196,17],[189,13,189,15],[190,53,190,56],[198,49,199,54],[198,55,199,60],[166,16,188,20],[203,13,204,48],[203,50,204,53],[191,13,191,15],[192,13,192,15],[295,67,295,76],[282,53,282,63],[282,65,282,76],[278,65,278,76],[280,65,280,76],[303,67,303,76],[264,65,264,76],[264,53,264,63],[291,67,291,76],[276,65,276,76],[297,37,297,65],[299,67,299,76],[35,11,35,20],[46,47,46,52],[65,36,65,44],[66,13,66,33],[66,37,66,45],[66,48,66,64],[190,57,190,59],[191,57,191,59],[192,57,192,59],[99,11,101,17],[132,56,133,77],[61,47,61,76],[81,28,82,33],[81,13,82,24],[81,34,82,50],[54,65,54,77],[136,12,137,54],[99,55,101,79],[190,75,190,79],[162,55,164,79],[155,49,156,53],[152,28,153,32],[152,46,153,57],[191,16,191,20],[1,23,3,52],[1,61,3,79],[31,56,31,62],[31,26,31,54],[31,11,31,23],[32,11,32,23],[5,11,5,79],[4,11,4,79],[28,56,30,79],[25,56,27,62],[7,56,8,79],[1,55,3,60],[1,11,3,22],[34,56,34,79],[12,56,13,61],[15,62,19,67],[34,21,34,54],[9,56,11,79],[34,11,34,20],[12,62,13,67],[12,69,13,72],[25,63,27,66],[25,70,27,72],[25,73,27,79],[32,56,32,62],[32,63,32,79],[31,63,31,79],[14,11,19,54],[7,11,13,54],[20,11,28,54],[15,69,19,72],[15,73,19,79],[15,56,19,61],[166,21,170,37],[258,35,258,46],[293,14,293,35],[295,14,295,35],[289,14,289,35],[291,14,291,35],[271,14,274,33],[240,55,240,63],[276,14,276,33],[267,13,269,33],[198,61,199,66],[175,60,188,63],[189,60,189,63],[190,60,190,63],[191,60,191,63],[192,60,192,63],[175,57,188,59],[189,57,189,59],[201,50,201,53],[201,56,201,59],[201,62,201,65],[191,64,191,66],[163,85,164,98],[65,13,65,30],[271,55,274,63],[271,65,274,76],[253,14,256,33],[246,53,246,63],[260,65,260,76],[262,65,262,76],[240,65,240,76],[246,65,246,76],[258,48,258,53],[253,48,256,53],[253,55,256,63],[249,13,251,33],[79,34,79,50],[70,13,71,14],[65,47,65,63],[79,28,79,33],[235,55,238,63],[171,60,174,74],[190,13,190,15],[136,55,137,78],[240,48,240,53],[258,55,258,63],[1,81,97,83],[242,14,242,63],[244,14,244,63],[260,14,260,63],[262,14,262,63],[278,14,278,63],[280,14,280,63],[215,13,216,48],[215,50,216,53],[215,56,216,59],[215,62,216,65],[215,68,216,71],[215,74,216,77],[112,13,114,35],[112,36,114,38],[108,51,110,63],[253,65,256,76],[258,65,258,76],[271,35,274,46],[271,48,274,53],[12,73,13,79],[171,38,174,59],[198,67,199,72],[144,11,146,17],[308,67,310,76],[285,13,287,35],[231,57,233,76],[301,14,301,35],[303,14,303,35],[289,37,289,65],[289,67,289,76],[299,37,299,65],[301,37,301,65],[303,37,303,65],[293,67,293,76],[301,67,301,76],[291,37,291,65],[293,37,293,65],[295,37,295,65],[297,67,297,76],[242,65,242,76],[258,14,258,33],[253,35,256,46],[240,14,240,33],[308,52,310,65],[235,65,238,76],[305,67,305,76],[305,55,305,65],[139,38,141,48],[139,53,141,70],[139,13,141,36],[226,81,322,83],[98,81,225,83],[103,12,105,34],[152,12,153,24],[158,12,159,26],[158,28,159,32],[158,37,159,41],[158,49,159,53],[221,13,221,14],[222,13,222,14],[223,13,223,14],[224,13,224,14],[148,12,149,24],[148,43,149,55],[155,12,156,26],[155,28,156,32],[155,37,156,41],[152,36,153,42],[166,75,188,79],[166,38,170,74],[312,12,313,59]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Jurisdiction 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,"Contract #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA - CDBG PROGRAM\nCDBG Program"]
[null,null,null,null,null,null,null,null,null,null,null,"Project Setup/Completion Report"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Homeownership Assistance & Housing Rehabilitation Housing - Single Family (1-4 units)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR CDBG USE ONLY"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Completion 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mgr Initials:",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Complete this form as a Setup Report, a Completion Report or a Setup and Completion Report and submit to your CDBG Program Representative."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rep Initials:",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Department of Housing and Community Development - CDBG Program \nP.O. Box 952054\nSacramento CA, 94252-2054"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal Initials",null,null,null,null,null,null," ",null,null,null,null,null,null,"Date:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Income"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PI/RLF Only Funding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All CDBG funds used in this 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,"PI Receipt #"]
[null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PI Voucher #"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Setup",null,null,null,null,null,null,null,null,null,{"$f":"IF(L36=\"revised\",\"If Revised, Why?\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG-Assigned Numbers"]
[null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG Project Number",null,null,null,null,null,null,null,null,null,null,null,"IDIS Activity Number"]
[null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Completion",null,null,null,null,null,null,null,null,null,{"$f":"IF(L40=\"Cancelled\",\"If Cancelled, Why?\",IF(L40=\"revised\",\"If Revised, Why?\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Completion MM/YY"]
[null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 # of Beneficiaries"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Part A ",null,null,null,null,null,null,"JURISDICTION INFORMATION & PREPARER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQUIRED"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Jurisdiction Contact 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,"Preparer:",null,null,null,null,null,"Select Option"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1a. Name (Contact Person)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2a. Preparer's Name"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1b. E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2b. Organization (if not grantee)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1c. Phone/Direct Line",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2c. E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2d. Phone/Direct Line"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Subrecipient Information (Only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQUIRED if applicable"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3a. Organization 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,"3b. Complete address"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3c. Organization is categorized as:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3d. DUNS number",null,null,null,null,null,null,null,null,null,null,"3e. E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3f. Phone/Direct Line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3g. ",null,"Check all that applies to this organization"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Part B ",null,null,null,null,null,null,"PROJECT & ACTIVITY 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,null,null,"REQUIRED"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1a. Owner 1 Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last 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,"First Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1b. Owner 2 Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last 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,"First Name"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1c. Project Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  4. Activity Purpose (check all that apply)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2. National Objective",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Activity & Matrix Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LMH - Low/Mod Housing Benefit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LMH - Low/Mod Housing Benefit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Accomplishment Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6. CDBG Project Amount (Incl AD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 - Direct Homeownership Assistance"]
[null,null,null,null,null," ",null,null,null,null,null,null,null,{"$f":"IF(AND(N90=CH90,AH90=CH92),CH95,IF(AND(N90=CH90,AH90=CH94),CH96,IF(AND(N90=CH90,AH90=CH93),CH96,\"\")))","v":""},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($BN$247,$BN$265,$BN$283)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,"14A - Rehab: Single-Unit Residential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14B - Rehab: Multi-Unit Residential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04 - Households"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 - Housing Units"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2"]
[null,null,null,null,null,null,null,null,null,null,null," Part C ",null,null,null,null,null,null,"SPECIAL CHARACTERISTICS (ownership 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,null,null,{"$f":"IF(AND(N90=CH90,AH90=CH92),\"REQUIRED\",\"NOT REQUIRED\")","v":"NOT REQUIRED"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"1. Homebuyer(s) Only (check all that apply)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Households Assisted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Of the total Households assisted, Number of:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First-Time Homebuyers"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number with Down Payment Assistance/Closing Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Of the number of First time buyers, number receiving Housing Counseling"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Part D",null,null,null,null,null,null,"SPECIAL CHARACTERISTICS (rehab)",null,null,null,null,null,null,null,null,null,null,null,null,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(N90=CH90,AH90=CH93),\"REQUIRED\",IF(AND(N90=CH90,AH90=CH94),\"REQUIRED\",\"NOT REQUIRED\"))","v":"NOT REQUIRED"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"1. Housing Rehab (check all that applies)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Special Areas Where Activity is Located: (Check all that apply)"]
[]
[]
[]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"3. Other Special Characteristics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQUIRED IF APPLICABLE"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Activity Information (check all that apply)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Part E",null,null,null,null,null,null,"2-4 UNIT 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,null,null,{"$f":"IF(AND(N90=CH90,AH90=CH92),\"REQUIRED\",IF(AND(N90=CH90,AH90=CH94),\"REQUIRED\",\"NOT REQUIRED\"))","v":"NOT REQUIRED"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Multi-Unit Housing:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Includes Rental Housing:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Multi-Unit Housing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,"Occupied",null,null,null,null,null,null,null,null,null,"Occupied Low/Mod"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Units at Start"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Units Expected at Completion"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Part E ",null,null,null,null,null,null,"DIRECT BENEFIT DATA BY HOUSEHOLDS",null,null,null,null,null,null,null,null,null,null,null,null,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(N90=CH90,AH90=CH92),\"REQUIRED\",IF(AND(N90=CH90,AH90=CH93),\"REQUIRED\",IF(AND(N90=CH90,AH90=CH94),\"REQUIRED\",\"NOT REQUIRED\")))","v":"NOT REQUIRED"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Unit #","1a. # of                Bed-rooms",null,null,"1b. Occupant",null,null,null,null,"Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Household Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1k. Rental Assist."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c.  All Adult Occupant's Annual Gross  Income",null,null,null,null,null,null,"1d. % of Area Median",null,null,null,null,null,null,null,null,null,"Head of Household (HH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Household (H)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1e. Hisp.",null,null,"1f. Race",null,null,null,null,null,null,null,null,null,null,null,"1h. Female HH",null,null,null,"Disable",null,null,"1g. Veteran in H?",null,null,null,"1i. Size (#)",null,null,"1j. Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"Select Option",null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,"Select Option",null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,"Select Option",null,null,"Select Option",null,null,null,"Select Option",null,null,"Select Option",null,null,null,null,null,null,null,"Select Option"]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Part F",null,null,null,null,null,null,"PERFORMANCE MEASUREMENTS - REHAB ONLY",null,null,null,null,null,null,null,null,null,null,null,null,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(N90=CH90,AH90=CH93),\"REQUIRED\",IF(AND(N90=CH90,AH90=CH94),\"REQUIRED\",\"NOT REQUIRED\"))","v":"NOT REQUIRED"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1.                          For Each Unit, Number of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit #1",null,null,null,null,null,"Unit #2",null,null,null,null,null,"Unit #3",null,null,null,null,null,"Unit #4",null,null,null,null,null,"Totals"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Type",null,null,null,null,null,null,null,null,null,null,null,null,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":"Q190","v":"Select Option"},null,null,null,null,null,{"$f":"Q191","v":0},null,null,null,null,null,{"$f":"Q192","v":0},null,null,null,null,null,{"$f":"Q193","v":0},null,null,null,null,null,"- - -"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Years of Affordability Guaranteed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AY204,BE204,BK204,BQ204)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 504 Accessible ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AY207,BE207,BK207,BQ207)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Brought from Substandard to Standard Condition (HQS or Local Code)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AY210,BE210,BK210,BQ210)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Qualified as Energy Star",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AY213,BE213,BK213,BQ213)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Brought into complience with Lead Safety Rules (24 CFR Part 35)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AY216,BE216,BK216,BQ216)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2. *Lead safety required for a residential property built on or after January 1, 1978 or in the case of jurisdictions which banned the residential use of lead paint prior to 1978, and earlier date as HUD may designate (see §35.160)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Unit #",null,null,null,"Applicable Requirement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lead Hazard Remediation Actions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Part G",null,null,null,null,null,null,"PROJECT FUNDING SOURCE DETAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQUIRED"]
[null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1. CDBG Grant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AH90>0,AH90,\"\")","v":"Select Option"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funding Type (CDBG Funds)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan Type",null,null,null,null,null,null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,"Loan Period (months)",null,null,null,null,null,null,null,null,null,"Amount (CBDG Funds)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG - Loan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG - Grant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other/Activity Delivery"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"SUMIF($BN$241:$BY$245,\">0\")","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2. CDBG Program Income (Not RLF)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Income (PI) Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan Type",null,null,null,null,null,null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,"Loan Period (months)",null,null,null,null,null,null,null,null,null,"Amount PI Funds"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG - PI Loan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG - PI Grant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other/Activity Delivery"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"SUMIF($BN$259:$BY$263,\">0\")","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3. CDBG (RLF) Revolving Loan Fund"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Income (PI) Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan Type",null,null,null,null,null,null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,"Loan Period (months)",null,null,null,null,null,null,null,null,null," Amount RLF "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG - RLF Loan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDBG - RLF Grant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other/Activity Delivery"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"SUMIF($BN$277:$BY$281,\">0\")","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Leverage and Other Funding Sources"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funding Source ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name of 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,null,"Amount"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"SUMIF($BP$292:$BY$304,\">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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL PROJECT COST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($BN$247,$BN$283,$BN$265,$BP$306)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Comments: explain any issues with this activity or clarification of information provided in this form."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"END OF DOCUMENT"]

{"sheet":"Replacement-Displacement only","index":1,"n_rows":35,"n_cols":67,"rows_kept":35,"cut":false,"hidden":true,"merged":[[23,14,23,65],[24,14,24,65],[5,14,5,82],[22,68,22,72],[23,68,23,72],[24,68,24,72],[25,68,25,72],[12,37,12,47],[1,14,3,25],[1,26,3,55],[1,58,3,63],[1,64,3,82],[4,14,4,82],[26,14,26,65],[34,14,34,34],[30,32,30,38],[30,39,30,57],[30,59,30,65],[27,14,27,21],[26,68,26,72],[8,31,8,44],[20,14,20,50],[20,66,20,74],[15,14,15,35],[15,37,15,82],[17,72,17,82],[8,14,8,28],[10,14,10,35],[10,37,10,82],[12,72,12,82],[12,49,12,71],[17,14,17,35],[17,37,17,47],[17,49,17,71],[12,14,12,35],[25,14,25,65],[22,14,22,65],[30,66,30,72],[30,14,30,28],[34,44,34,47],[34,48,34,51],[33,35,33,38],[34,35,34,38],[34,39,34,42],[32,35,32,42],[33,39,33,42],[32,44,32,51],[33,44,33,47],[33,48,33,51],[32,14,32,33],[32,53,32,60],[33,53,33,56],[33,57,33,60],[34,53,34,56],[34,57,34,60],[35,53,35,56],[35,57,35,60],[36,53,36,56],[35,14,35,34],[35,35,35,38],[35,39,35,42],[35,44,35,47],[35,48,35,51],[36,14,36,34],[36,35,36,38],[36,39,36,42],[36,44,36,47],[36,48,36,51],[37,57,37,60],[37,14,37,34],[37,35,37,38],[37,39,37,42],[37,44,37,47],[37,48,37,51],[37,53,37,56],[36,57,36,60],[38,53,38,56],[38,57,38,60],[39,14,39,34],[39,35,39,38],[39,39,39,42],[39,44,39,47],[39,48,39,51],[39,53,39,56],[39,57,39,60],[38,14,38,34],[38,35,38,38],[38,39,38,42],[38,44,38,47],[38,48,38,51],[40,53,40,56],[40,57,40,60],[41,14,41,34],[41,35,41,38],[41,39,41,42],[41,44,41,47],[41,48,41,51],[41,53,41,56],[41,57,41,60],[40,14,40,34],[40,35,40,38],[40,39,40,42],[40,44,40,47],[40,48,40,51],[42,53,42,56],[42,57,42,60],[43,14,43,34],[43,35,43,38],[43,39,43,42],[43,44,43,47],[43,48,43,51],[43,53,43,56],[43,57,43,60],[42,14,42,34],[42,35,42,38],[42,39,42,42],[42,44,42,47],[42,48,42,51]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jurisdiction Name:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Housing (setup & completion)'!X2>0,'Housing (setup & completion)'!X2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract #",null,null,null,null,null,{"$f":"IF('Housing (setup & completion)'!BJ2>0,'Housing (setup & completion)'!BJ2,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA - CDBG PROGRAM\nCDBG Program"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Setup/Completion Report"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One-for-one Replacement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Includes Rental Housing:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demolished/Converted Property Address:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicate the number of bedroom units:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,"Grant or Loan Agreement Executed Date:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Replacement Address:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicate the number of bedroom units:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option",null,null,null,null,null,null,null,null,null,null,null,"Date Unit Will be Available:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer the questions below, if yes to \"Include Rental Housing\" above.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Units"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units Subsidized with Project-Based Rental Assistance by Another Federal, State or Local Program."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units Designated for Persons with HIV/AIDS Including Units Receiving Assistance for Operations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Of Units Designated for Persons with HIV/AIDS, Number Specifically for Chronically Homeless."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permanent Housing Units Designated for Homeless Persons and Families, Including Units Receiving Assistance for Operations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Of Permanent Housing Units Designated for Homeless, Number for the Chronically Homeless,"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Displacement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City 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,"Census Tract:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Race",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Displaced",null,null,null,null,null,null,null,null,"Remained In",null,null,null,null,null,null,null,null,"Relocated To"]
[null,null,null,null,null,null,null,null,null,null,null,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,"Hisp",null,null,null,null,"Total",null,null,null,"Hisp",null,null,null,null,"Total",null,null,null,"Hisp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]

{"sheet":"Data Validation","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["Category1",null,null,null,null,null,null,null,"SELECT OPTION"]
["A 105 (a) (15) entity as defined under the Housing & Development Act",null,null,null,null,null,null,null,"White "]
["Another unit of local Government",null,null,null,null,null,null,null,"Black/African American "]
["Another public Agency",null,null,null,null,null,null,null,"Asian "]
[null,null,null,null,null,null,null,null,"American Indian/Alaskan Native "]
[null,null,null,null,null,null,null,null,"Native Hawaiian/Other Pacific Isl. "]
["SELECT OPTION",null,null,null,null,null,null,null,"Am. Indian/Alaskan Native & White "]
[null,null,null,null,null,null,null,null,"Asian & White "]
[null,null,null,null,null,null,null,null,"Black/African Am. & White "]
[null,null,null,null,null,null,null,null,"Am. Indian/Alaskan & Blk/African "]
[null,null,null,null,null,null,null,null,"Other Multi-Racial "]

{"sheet":"Validation","index":3,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":true,"merged":[[14,7,15,7]]}
["Select Option",null,null,"Yes","Non-Profit Organization",null,"Match Leverage"]
["Original",null,null,"No","Faith-Based Organization",null,"Select Option"]
["Revised",null,null,null,"Institution of Higher Education","L000-Local Other","F000-Federal Other"]
["Cancelled",null,null,null,null,"L110-Staff Time","F100-Federal HUD"]
[null,null,null,null,null,"L120-Local-in-Kind","F200-Federal SBA"]
["FY 14/15",null,null,null,null,"L130-Local Land","F300-Federal EDA"]
["FY 15/16",null,null,"National Objective no Slum","National Objective","L200-Local Fees","F400-Federal USDA"]
["FY 16/17",null,null,"Select Option",null,"L210-Local Fee Waivers","F500-Federal FEMA"]
["FY 17/18",null,null,"LMH - Low/Mod Housing Benefit","LMH - Low/Mod Housing Benefit","L220-Local Audit","F600-Federal Housing Tax Credits"]
["FY 18/19",null,null,"URG - Urgent Need","SBA - Slum/Blight Area Benefit","L300-Local","L000-Local Other"]
["FY 19/20",null,null,null,"SBS - Slum/Blight Spot Basis","L310-PTA Cash Match","L001-Local No Match Required"]
["FY 20/21",null,null,null,"URG - Urgent Need","L600-Local RDA","L110-Staff Time"]
["FY 21/22",null,null,null,null,"P000 Private Other","L120-Local-in-Kind"]
["FY 22/23",null,null,null,null,"P100-Private Equity","L130-Local Land Contribution"]
["FY 23/24",null,null,null,"14H Rehabilitation Administration","P110-Private Sweat Equity","L200-Local Fee Waiver","What's the difference?"]
["FY 24/25",null,null,null,null,"P120-Private-in-Kind","L210-Local Fee Waivers"]
[null,null,null,null,null,"P200-Private Fees","L220-Local Audit"]
[null,"Select Option",null,null,"Grant","P320-Private Financing","L300-Local Funds"]
[null,"Grantee Employees",null,null,"Loan","P900-Private Volunteer Time","L310-PTA Cash Match General"]
[null,"Contractors",null,null,"Grant and Loan","F000-State Other","L311-PTA Cash Match ED"]
[null,"Grantee Employees & Contractors",null,null,null,"S200-State Tax Credits","L320-PTA Private Financing"]
[null,null,null,null,"Select Option",null,"L330-Bonds"]
[null,"Select Option",null,null,"11 - White",null,"L400-Goods and Services Incl."]
[null,"0-1 bedroom unit",null,null,"12 - Black/African American ",null,"L500-Gas Tax"]
[null,"2 bedroom unit",null,null,"13 - Asian","-CDBG-","L600-Local RDA"]
[null,"3 bedroom unit",null,null,"14 - American Indian/ Alaskan Native ",null,"L601-Local RDA"]
[null,"4 bedroom unit",null,null,"15 - Native Hawaiian/ Other Pacific Islander",null,"L602-Waived Interest/ Fin'e Chg"]
[null,"5+ bedroom unit",null,null,"16 - Am. Indian/Alaskan Native & White ",null,"P000 Private Other"]
[null,null,null,null,"17 - Asian & White ",null,"P100-Private Equity","Delete \"Equity\"?"]
[null,null,null,null,"18 - Black/African Am. & White",null,"P110-Private Sweat Equity"]
[null,null,null,null,"19 - Am. Indian/Alaskan & Blk/African ",null,"P120-Private-in-Kind"]
[null,null,null,null,"20 - Other Multi-Racial ",null,"P130-Private-Equity in Land/ Improve"]
[null,null,null,null,null,null,"P200-Private Fees"]
[null,null,null,"Activity Matrix Code","Income Level","Accomplishment Type","P210-Private Fee Waivers"]
[null,null,null,"Select Option","Select Option",null,"P220-Private Discounts"]
[null,null,null,"13 - Direct Homeownership Assistance","Extremely Low ( ≤ 30%)","04 - Households","P300-Private Funds"]
[null,null,null,"14A - Rehab: Single-Unit Residential","Low (31-50%)","10 - Housing Units","P310-Private Cash Match"]
[null,null,null,"14B - Rehab: Multi-Unit Residential","Moderate (51-80%)",null,"P320-Private Financing"]
[null,null,null,null,"Non-Low/ Moderate (+80%)",null,"P330-Private Loans"]
[null,null,null,null,null,null,"P340-Private Banks"]
[null,null,null,null,"Select Option",null,"P350-Private EDC"]
[null,null,null,null,"Housing constructed before 1978",null,"P400-Private Good and Services"]
[null,null,null,null,"*Exempt: Housing constructed in 1978/ later",null,"P500-Private Tax Credit Equity"]
[null,null,null,null,"Exempt: No paint disturbed",null,"P600-Private Foundation/ Nonprofit G","G?"]
[null,null,null,null,"Otherwise exempt",null,"P900-Private Volunteer Time"]
[null,null,null,null,null,null,"S000-State Other"]
[null,null,null,null,"Select Option",null,"S100-State HCD"]
[null,null,null,null,"Lead Safe Work Practices (24 CFR 35.930(b)) (Hard cost < or = to $5,000)",null,"S200-State Treasurer Tax Credits-MC"]
[null,null,null,null,"Interim Controls/ Standard Practices (24 CFR 35.930(c)) (Hard cost $5,000-$25,000)",null,"S300-State SWRCB"]
[null,null,null,null,"Abatement (24 CFR 35.930(d)) (Hard cost > $25,000)",null,"S400-State CalHFA (CHFA)"]
[null,null,null,null,"N/A",null,"S500-State CSD"]
[]
[null,null,null,"Select Option"]
[null,null,null,"A 105 (a) (15) entity",null,null,"Program Income"]
[null,null,null,"A 501 (c) 3"]
[null,null,null,"Another unit of local government",null,null,"PINC-Local Program Income"]
[null,null,null,"Another public agency"]
[null,null,null,"Select Option",null,"Occupancy","Loan/ Grant"]
[null,null,null,"Subrecipient",null,"Select Option"]
[null,null,null,"Admin Contractor/Program Operator",null,"Owner","CDBG (Grant)"]
[null,null,null,"Jurisdiction Staff",null,"Tenant","CDBG (Loan)"]
[]
[]
[null,null,null,"Program Income",null,"# of Bedrooms"]
[null,null,null,"Revolving Loan Fund",null,"Select Option"]
[null,null,null,null,null,1]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,"Loan Type",null,4,"General Admin."]
[null,null,null,"Select Option",null,"5 or More"]
[null,null,null,"Amortized",null,null,"(21A) General Administration"]
[null,null,null,"Deferred"]
[null,null,null,"Amortized / Forgivable",null,"Yes/ No","Yes/ No","Yes"]
[null,null,null,"Deferred / Forgivable",null,"Select Option"]
[null,null,null,null,null,"No","No","Yes"]
[null,null,null,null,null,"Yes","Yes*"]
[]
[null,null,null,null,null,"# Persons","No"]
[null,null,null,null,null,"Select Option","Yes**"]
[null,null,null,null,null,1]
[null,null,null,null,null,2,"Activity Delivery"]
[null,null,null,null,null,3]
[null,null,null,null,null,4,"Activity Delivery"]
[null,null,null,null,null,5]
[null,null,null,null,null,6,"Type of Household"]
[null,null,null,null,null,7,"Select Option"]
[null,null,null,null,null,8,"Single/ non-Elderly"]
[null,null,null,null,null,"Vac","Elderly"]
[null,null,null,null,null,null,"Related/ Single Parent"]
[null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,"Vacant"]
[null,null,null,null,null,null,"Related/Two Parent"]
[null,null,null,null,null,null,"Rental Assistance"]
[null,null,null,null,null,null,"Select Option"]
[null,null,null,null,null,null,"HOME TBRA"]
[null,null,null,null,null,null,"Sect. 8"]
[null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,"None"]
[null,null,null,null,null,null,"Vacant"]
[null,null,null,null,null,null,"Project Based"]