{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","GP Exp","MC Exp","LSQ","Zoning","Syndication","Impact Fees","Architect","HERS Rater","Accessibility","Farmworker","Data","Lists"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":84,"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":"Instructions","index":0,"n_rows":165,"n_cols":18,"rows_kept":165,"cut":false,"hidden":false,"merged":[[162,1,162,11],[164,2,165,11],[147,1,147,11],[1,4,1,8],[127,1,127,11],[131,2,132,11],[136,1,136,11],[140,2,141,11],[117,2,118,11],[123,1,123,11],[112,2,114,11],[115,2,115,11],[66,2,68,11],[138,2,138,11],[43,2,43,11],[159,2,160,11],[0,0,0,12],[110,1,110,11],[98,1,98,11],[102,2,106,11],[107,2,108,11],[3,1,3,11],[45,4,45,9],[39,2,39,11],[95,2,96,11],[47,2,48,11],[5,1,8,11],[84,1,84,11],[9,4,9,8],[100,2,101,11],[8,16,8,21],[50,2,53,11],[147,14,147,16],[149,2,150,11],[157,1,157,11],[86,2,88,11],[90,2,94,11],[143,2,145,11],[152,1,152,11],[152,14,152,16],[154,2,155,11],[35,2,37,11],[21,16,21,21],[120,2,121,11]]}
["Instructions"]
[null,null,null,null,"Version 5.2"]
[]
[null,"Linking to your E-application"]
[]
[null,"This workbook is linked to and dependent upon the current CTCAC 9% e-application or Attachment 40. This is intended to reduce duplicate data entry and perform calculations for applicants. Only a limited amount of data is required for this workbook to populate. Please see the list to the right. \nWe greatly value your feedback and suggestions for improving the application process. Please send your thoughts to TCACdocs@treasurer.ca.gov with the subject “Linked Workbook Feedback”."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required Data to Populate Exhibit B"]
[null,null,null,null,{"$f":"HYPERLINK(\"mailto:tcacdocs@treasurer.ca.gov?subject=Linked Workbook Feedback\",\"mailto: TCACdocs@treasurer.ca.gov\")","v":"mailto: TCACdocs@treasurer.ca.gov"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Project Name"]
[null,"1)","You must be on the Instructions tab to point this workbook to your e-application.",null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Set-Aside"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Housing Type"]
[null,"2)","Select the “Workbook Links” icon within the “Data” menu in the ribbon above ([Alt + A] then [Alt + K]).",null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Applicant Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","General Partner Info"]
[null,"3)","On the right side of your workbook, the Workbook Links side bar will appear.",null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Developer Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Management Company Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Site Info (Address, City, County, Census Tract)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Total Unit Count (not Unit Mix)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optional Data to Populate Exhibit B"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"•","Federal & State Credit Requests"]
[]
[null,"4)","Select \"...\" to the right of the linked file. Select \"Change source\" from the dropdown."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CAUTION: Always use the \"Open Workbook\" option from this dropdown to open the e-application while this linked workbook is open. Navigating to the source e-application in File Explorer and opening there will cause REF errors."]
[]
[]
[]
[null,"5)","In the Change Source dialogue box, navigate to and select your e-application then click the “Open” button. "]
[]
[null,"6)","After the linked cells have updated, “Close” the Workbook Links side bar."]
[]
[null,"7)","If the links were successfully updated, your project name should appear below. "]
[]
[null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[null,"8)","Cells with grey backgrounds are pulled from (or based on data from) your e-application. Applicants should only provide information in cells with yellow backgrounds. All sheets in this workbook are intended to be completed, printed or PDF'd, and signed physically or digitally to be submitted in PDF form with your application."]
[]
[]
[null,"9)","While working with linked workbooks you may be prompted with one of the following warnings. You will be required to “Enable Content” or “Update” linked cells to keep the workbooks in sync. When you make changes to the e-application you should open, update linked cells, and save all other linked workbooks. It is the applicant’s responsibility to ensure all information provided is consistent."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10)","If you move or rename the e-application or its folder, you may be notified that linked cells can’t be updated. While on the Instructions tab, you should be able to “Edit Links” and “Change Source” to communicate the correct file path."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"GP (General Partner) Exp tab"]
[]
[null,"1)","Select the name for the General Partner requesting points. For Tribal Applicants only, select the Developer entity. Select \"TRUE\" if requesting points for special needs through Nonprofit or Special Needs set-aside, or select \"TRUE\" for Tribal Applicants. Make sure to enter the correct application deadline."]
[]
[]
[]
[null,"2)","Enter Project Name and Address. Enter a project ID number (typically a CTCAC number, but not always). Select \"TRUE\" if a CTCAC project. Enter the number of Low Income Units. Select \"TRUE\" if a Special Needs Project. Enter the number of Special Needs Unit if applicable. Enter the Date Placed in Service, Date GP Participation Began, and Date GP Participation Ended if applicable. The sheet will calculate the full number of years managed."]
[]
[]
[]
[]
[null,"3)","Once completed, either print physically or to PDF and have the form signed physically or digitally by a Principal of the General Partner, or Developer Entity and Tribal Applicant, named therein."]
[]
[]
[null,"MC (Management Company) Exp tab"]
[]
[null,"1)","Select the name for the Management Company name requesting points. Select \"TRUE\" if requesting points for special needs through Nonprofit or Special Needs set-aside."]
[]
[null,"2)","Enter Project Name and Address. Enter a project ID number (typically a CTCAC number, but not always). Select \"TRUE\" if a CTCAC project. Enter the number of Low Income Units. Select \"TRUE\" if a Special Needs Project. Enter the number of Special Needs Unit if applicable. Enter the Date Placed in Service, Date Management Began, and Date Management Ended, if applicable. The sheet will calculate the full number of years managed."]
[]
[]
[]
[]
[null,"3)","Once completed, either print physically or to PDF and have the form signed physically or digitally by a Principal of the Management Company named therein."]
[]
[]
[null,"LSQ (Legal Status Questionnaire) tab"]
[]
[null,"1)","This tab contains a Legal Status Questionnaires for each relevant member of the development team - Applicant, Developer, Property Management Company or Companies, General Contractor, and up to 3 General Partners as listed in the application."]
[]
[]
[null,"2)","Select either \"Nothing to Disclose\" or \"Disclosure provided in tab 5.\""]
[]
[null,"3)","If you selected \"Disclosure provided in tab 5\" for any member of the team, please provide the disclosure in tab 5 and include a cover page or header indicating  the company or individual it is for."]
[]
[]
[null,"4)","Once completed, either print physically or to PDF and have the form signed physically or digitally by a Principal of each entity named therein."]
[]
[]
[null,"Zoning tab"]
[]
[null,"1)","The Zoning tab should be completed by an agent of the City or County in which the project is to be located."]
[]
[null,"Syndication tab"]
[]
[null,"1)","Enter the amount of credits requested for allocation and the estimated gross proceeds."]
[]
[null,"2)","Enter all expenses, specifying what they are if using the \"Other\" rows. Total expenses and net equity will be calculated for you."]
[]
[]
[null,"3)","The Syndication tab should be signed by an agent of the investor named as an interested party."]
[]
[null,"Impact Fees tab"]
[]
[null,"1)","You may duplicate this tab if you have multiple assessing entities that are responsible for different impact fees."]
[]
[null,"2)","To do so, right-click the tab and select \"Move or Copy...\", highlight \"Architect\", and check \"Create a copy\" before selecting \"Okay\"."]
[]
[]
[null,"3)","The Impact Fees tab should be signed by an agent of the assessing entity. If the assessing entity does not complete \"Impact Fees\" tab, then the applicant must provide a completed copy of this tab along with other evidence from the assessing entity, such as current fee schedules."]
[]
[]
[]
[null,"Architect tab"]
[]
[null,"1)","The Architect tab should be completed by the project's architect. The items checked should match any threshold basis limit increases requested in your e-application."]
[]
[]
[null,"HERS Rater tab"]
[]
[null,"1)","The HERS Rater tab should be completed by the project's third-party certified HERS Rater, if applicable. The items checked should match any threshold basis limit increases requested in your e-application."]
[]
[]
[null,"Accessibility tab"]
[]
[null,"1)","If requesting points under Reg. § 10325(c)(8)(B), the Accessibility tab should be completed by the project's architect."]
[]
[]
[null,"Farmworker tab"]
[]
[null,"1)","If requesting State Tax Credits for Farmworker Housing, the Farmworker tab should be signed by the applicant."]

{"sheet":"GP Exp","index":1,"n_rows":47,"n_cols":66,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,9,43,24],[46,9,46,14],[40,33,40,48],[32,9,32,24],[33,9,33,24],[33,31,33,36],[35,1,39,47],[46,33,46,38],[40,9,41,24],[42,33,42,48],[42,9,42,24],[13,1,13,12],[19,50,19,52],[14,26,14,28],[13,34,13,38],[13,39,13,43],[14,39,14,43],[14,44,14,48],[13,26,13,28],[14,29,14,33],[14,13,14,16],[13,13,13,16],[13,44,13,48],[13,29,13,33],[9,1,9,12],[15,50,15,52],[30,9,31,24],[14,34,14,38],[13,23,13,25],[14,23,14,25],[16,50,16,52],[17,50,17,52],[18,50,18,52],[14,1,14,12],[19,1,20,48],[26,1,29,43],[26,44,26,48],[14,17,14,19],[13,20,13,22],[14,20,14,22],[6,58,9,58],[10,23,10,25],[0,56,9,56],[11,39,11,43],[0,55,9,55],[3,31,3,33],[3,43,3,48],[4,26,4,30],[0,52,9,52],[0,53,9,53],[0,54,9,54],[3,8,4,23],[10,20,10,22],[9,20,9,22],[11,20,11,22],[9,26,9,28],[13,17,13,19],[6,61,9,61],[9,44,9,48],[10,44,10,48],[11,44,11,48],[6,59,9,59],[6,60,9,60],[0,57,9,57],[0,50,9,50],[0,51,9,51],[0,0,0,48],[6,46,6,48],[9,39,9,43],[9,29,9,33],[9,23,9,25],[9,34,9,38],[12,13,12,16],[10,17,10,19],[12,34,12,38],[12,20,12,22],[12,26,12,28],[12,23,12,25],[11,26,11,28],[7,46,7,48],[12,29,12,33],[12,39,12,43],[5,46,5,48],[11,29,11,33],[10,1,10,12],[11,1,11,12],[9,17,9,19],[11,17,11,19],[12,44,12,48],[10,39,10,43],[10,29,10,33],[10,34,10,38],[12,17,12,19],[12,1,12,12],[11,34,11,38],[11,23,11,25],[10,26,10,28],[10,13,10,16],[9,13,9,16],[11,13,11,16]]}
["Attachment 21 - General Partner Experience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for GP tab »","Necessary identification information provided","Has more than 10 affordable units","Participation didn't end 10 years ago","3+years","3+years & CTCAC","5+years","3+years & SN","3+years & active & CTCAC"]
[]
[null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,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,null,null,1," is missing its Project Identification Number."]
[null,null,null,null,null,null,null,{"$f":"IF(AU8,\"Developer Entity Name:\",\"General Partner Name:\")","v":"General Partner Name:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points earned:",null,null,null,null,{"$f":"BG21","v":0},null,null,null,null,null,null,null,null,null,null,"Application deadline:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2," does not have more than 10 affordable 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,"10325(c)(1)(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3," had participation end too long ago."]
[null,null,null,null,null,null,null,"Parent Company:",{"$f":"IFERROR(INDEX(GeneralPartners[ParentOrNA],MATCH(I4,GeneralPartners[GPs],0)),\"\")","v":"No parent company entered"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER((SEARCH(\"Tribal applicants\",I4))),IF(AU8,\"\",\"!\"),\"\")","v":""},{"$f":"IF(Y6=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nonprofit or Special Needs set-aside:",{"$f":"OR(INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"Nonprofit (qualified nonprofit organization)\",INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"Nonprofit (Homeless assistance)\",INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"Special Needs\",INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"At-Risk and Special Needs\")","v":false},null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,null,4," has less than 3 full years of participation."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Needs housing type:",null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"t_HousingType\",ref,0))=\"Special Needs\"","v":false},null,null,null,null,null,null,null,null,null,null,null,"info warning","units warning","participation warning","below 3 warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tribal Application:"]
[]
[null,"Project Name\nand Address",null,null,null,null,null,null,null,null,null,null,null,"Project ID. Number",null,null,null,"CTCAC Project ",null,null,"Low Income Units",null,null,"Special Needs Project",null,null,"Special Needs Units",null,null,"Date Placed in Service",null,null,null,null,"Date GP Participation Began",null,null,null,null,"Date GP Participation Ended",null,null,null,null,"Full Years of GP Participation"]
[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,null,null,null,null,null,null,{"$f":"IF(OR(AD11=\"\",AI11=\"\"),0,DATEDIF(MAX(AD11,AI11),MIN(AN11,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK11>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B11=\"\",N11=\"\"))","v":false},{"$f":"U11>10","v":false},{"$f":"OR(AN11=\"\",DATEDIF(AN11,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS11>=3,AND(AY11:BA11))","v":0},{"$f":"--AND(BB11,R11=TRUE)","v":0},{"$f":"--AND(AS11>=5,AND(AY11:BA11))","v":0},{"$f":"IFERROR(--AND(BB11,X11=TRUE,AA11/U11>=45%),0)","v":0},{"$f":"--AND(BC11,AN11=\"\")","v":0},{"$f":"AND(NOT(AY11),B11<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ11),$B11<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA11),$B11<>\"\")*$BI$6","v":0},{"$f":"AND(AS11<3,$B11<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG11:BJ11)","v":0},{"$f":"COUNTIFS($BK$11:BK11,\">0\")*(BK11>0)","v":0},{"$f":"IF(BK11>0,\"Project \"&A11&INDEX($BM$3:$BM$6,BK11),\"\")","v":""},{"$f":"IF(AN11<>\"\",1,0)","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,null,null,null,null,null,null,{"$f":"IF(OR(AD12=\"\",AI12=\"\"),0,DATEDIF(MAX(AD12,AI12),MIN(AN12,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK12>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B12=\"\",N12=\"\"))","v":false},{"$f":"U12>10","v":false},{"$f":"OR(AN12=\"\",DATEDIF(AN12,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS12>=3,AND(AY12:BA12))","v":0},{"$f":"--AND(BB12,R12=TRUE)","v":0},{"$f":"--AND(AS12>=5,AND(AY12:BA12))","v":0},{"$f":"IFERROR(--AND(BB12,X12=TRUE,AA12/U12>=45%),0)","v":0},{"$f":"--AND(BC12,AN12=\"\")","v":0},{"$f":"AND(NOT(AY12),B12<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ12),$B12<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA12),$B12<>\"\")*$BI$6","v":0},{"$f":"AND(AS12<3,$B12<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG12:BJ12)","v":0},{"$f":"COUNTIFS($BK$11:BK12,\">0\")*(BK12>0)","v":0},{"$f":"IF(BK12>0,\"Project \"&A12&INDEX($BM$3:$BM$6,BK12),\"\")","v":""},{"$f":"IF(AN12<>\"\",1,0)","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,null,null,null,null,null,null,{"$f":"IF(OR(AD13=\"\",AI13=\"\"),0,DATEDIF(MAX(AD13,AI13),MIN(AN13,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK13>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B13=\"\",N13=\"\"))","v":false},{"$f":"U13>10","v":false},{"$f":"OR(AN13=\"\",DATEDIF(AN13,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS13>=3,AND(AY13:BA13))","v":0},{"$f":"--AND(BB13,R13=TRUE)","v":0},{"$f":"--AND(AS13>=5,AND(AY13:BA13))","v":0},{"$f":"IFERROR(--AND(BB13,X13=TRUE,AA13/U13>=45%),0)","v":0},{"$f":"--AND(BC13,AN13=\"\")","v":0},{"$f":"AND(NOT(AY13),B13<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ13),$B13<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA13),$B13<>\"\")*$BI$6","v":0},{"$f":"AND(AS13<3,$B13<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG13:BJ13)","v":0},{"$f":"COUNTIFS($BK$11:BK13,\">0\")*(BK13>0)","v":0},{"$f":"IF(BK13>0,\"Project \"&A13&INDEX($BM$3:$BM$6,BK13),\"\")","v":""},{"$f":"IF(AN13<>\"\",1,0)","v":0}]
[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,null,null,null,null,null,null,{"$f":"IF(OR(AD14=\"\",AI14=\"\"),0,DATEDIF(MAX(AD14,AI14),MIN(AN14,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK14>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B14=\"\",N14=\"\"))","v":false},{"$f":"U14>10","v":false},{"$f":"OR(AN14=\"\",DATEDIF(AN14,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS14>=3,AND(AY14:BA14))","v":0},{"$f":"--AND(BB14,R14=TRUE)","v":0},{"$f":"--AND(AS14>=5,AND(AY14:BA14))","v":0},{"$f":"IFERROR(--AND(BB14,X14=TRUE,AA14/U14>=45%),0)","v":0},{"$f":"--AND(BC14,AN14=\"\")","v":0},{"$f":"AND(NOT(AY14),B14<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ14),$B14<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA14),$B14<>\"\")*$BI$6","v":0},{"$f":"AND(AS14<3,$B14<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG14:BJ14)","v":0},{"$f":"COUNTIFS($BK$11:BK14,\">0\")*(BK14>0)","v":0},{"$f":"IF(BK14>0,\"Project \"&A14&INDEX($BM$3:$BM$6,BK14),\"\")","v":""},{"$f":"IF(AN14<>\"\",1,0)","v":0}]
[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,null,null,null,null,null,null,{"$f":"IF(OR(AD15=\"\",AI15=\"\"),0,DATEDIF(MAX(AD15,AI15),MIN(AN15,$AR$4,TODAY()),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BK15>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B15=\"\",N15=\"\"))","v":false},{"$f":"U15>10","v":false},{"$f":"OR(AN15=\"\",DATEDIF(AN15,$AR$4,\"y\")<10)","v":true},{"$f":"--AND(AS15>=3,AND(AY15:BA15))","v":0},{"$f":"--AND(BB15,R15=TRUE)","v":0},{"$f":"--AND(AS15>=5,AND(AY15:BA15))","v":0},{"$f":"IFERROR(--AND(BB15,X15=TRUE,AA15/U15>=45%),0)","v":0},{"$f":"--AND(BC15,AN15=\"\")","v":0},{"$f":"AND(NOT(AY15),B15<>\"\")*BG$6","v":0},{"$f":"AND(NOT(AZ15),$B15<>\"\")*$BH$6","v":0},{"$f":"AND(NOT(BA15),$B15<>\"\")*$BI$6","v":0},{"$f":"AND(AS15<3,$B15<>\"\")*$BJ$6","v":0},{"$f":"MAX(BG15:BJ15)","v":0},{"$f":"COUNTIFS($BK$11:BK15,\">0\")*(BK15>0)","v":0},{"$f":"IF(BK15>0,\"Project \"&A15&INDEX($BM$3:$BM$6,BK15),\"\")","v":""},{"$f":"IF(AN15<>\"\",1,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,"Total:",null,null,{"$f":"SUM(BB11:BB15)","v":0},{"$f":"SUM(BC11:BC15)","v":0},{"$f":"SUM(BD11:BD15)","v":0},{"$f":"SUM(BE11:BE15)","v":0},{"$f":"SUM(BF11:BF15)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(BN11:BN15)","v":0}]
[null,{"$f":"IFERROR(INDEX($BM$11:$BM$15,MATCH(ROW(1:1),$BL$11:$BL$15,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH17&\"-points requires:\"","v":"5-points requires:"},null,null,3,2,1,0,"NA",{"$f":"AND($BB$16>=BB17,$BC$16>=BC17,$BD$16>=BD17,$BE$16>=BE17)*BH17","v":0},5,"3-4 projects in service more than 3 years, of which 1 shall be in service more than 5 years and 2 shall be California Low Income Housing Tax Credit projects 5 points"]
[null,{"$f":"IFERROR(INDEX($BM$11:$BM$15,MATCH(ROW(3:3),$BL$11:$BL$15,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH18&\"-points requires:\"","v":"7-points requires:"},null,null,5,2,1,0,"NA",{"$f":"AND($BB$16>=BB18,$BC$16>=BC18,$BD$16>=BD18,$BE$16>=BE18)*BH18","v":0},7,"5 or more projects in service more than 3 years, of which 1 shall be in service more than 5 years and 2 shall be California Low Income Housing Tax Credit projects 7 points"]
[null,{"$f":"IFERROR(INDEX($BM$11:$BM$15,MATCH(ROW(4:4),$BL$11:$BL$15,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH19&\"-points requires:\"","v":"5-points requires:"},null,null,0,1,0,3,"NA",{"$f":"AND($BB$16>=BB19,$BC$16>=BC19,$BD$16>=BD19,$BE$16>=BE19)*BH19*($AU$6=\"Yes\")","v":0},5,"3 Special Needs projects in service more than 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the 3 special needs projects 5 points"]
[null,"Projects must have more than 10 affordable units and be subject to a recorded regulatory agreement. GP Experience does not start accumulating until after each project is placed in service.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BH20&\"-points requires:\"","v":"7-points requires:"},null,null,0,1,0,4,"NA",{"$f":"AND($BB$16>=BB20,$BC$16>=BC20,$BD$16>=BD20,$BE$16>=BE20)*BH20*($AU$6=\"Yes\")","v":0},7,"4 or more Special Needs projects in service more than 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the 4 special needs projects 7 points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MAX(BG17:BG20)","v":0}]
[]
[null,{"$f":"IF(BN16>4,\"Fewer than two active projects listed, must contract with a bona-fide management company. See below.\",\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(AND(AU6=\"Yes\",BF16>=1),AND(B8=\"\",BF16>=2))","v":false},"Hide bona-fide management company requirement"]
[]
[]
[]
[null,"General partners with fewer than two active California Low Income Housing Tax Credit projects in service more than three years, and general partners for projects applying through the Nonprofit or Special Needs set-aside with no active California Low Income Tax Credit projects in service more than three years, shall contract with a bona-fide management company currently managing two California Low Income Housing Tax Credit projects in service more than three years and which itself earns a minimum combined total of two points at the time of 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,null,null,null,null,null,"N/A"]
[]
[]
[]
[null,"General Partner Entity:",null,null,null,null,null,null,null,{"$f":"I4","v":0}]
[]
[null,"Signatory 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,"GP Signature:"]
[null,"Signatory Title:",null,null,null,null,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:"]
[]
[null,"TRIBAL APPLICANTS ONLY, may contract with a developer who will not be a general partner and receive points commensurate with the developer's experience pursuant to CTCAC Regulations 10325(c)(1)(A)(i and ii). The developer may include an entity pre-approved by CTCAC that has developed but not owned the requisite number of projects described in 10325(c)(1)(A)(i). The contract shall be in effect at least until the issuance of 8609 tax forms. Tribal applicants contracting with a developer who will not be a general partner shall also contract for asset management for at least the term of the 15-year federal compliance period with an entity that has asset managed at least two Low-Income Housing Tax Credit projects for at least three years."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Developer Entity:",{"$f":"I4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tribal 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,"Signatory Name:"]
[null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signatory Title:"]
[null,null,null,null,null,null,null,null,"Signatory Title:"]
[]
[null,null,null,null,null,null,null,null,"Developer Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant Signature:"]
[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,"Date:"]

{"sheet":"MC Exp","index":2,"n_rows":37,"n_cols":63,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,56,8,56],[5,57,8,57],[5,58,8,58],[5,59,8,59],[8,1,8,12],[8,13,8,16],[8,17,8,19],[8,20,8,22],[8,23,8,25],[0,55,8,55],[2,31,2,33],[2,43,2,48],[3,44,3,48],[6,46,6,48],[8,26,8,28],[0,0,0,48],[0,50,8,50],[0,51,8,51],[0,52,8,52],[0,53,8,53],[0,54,8,54],[8,29,8,33],[8,44,8,48],[8,34,8,38],[9,17,9,19],[9,20,9,22],[9,23,9,25],[9,26,9,28],[9,29,9,33],[9,34,9,38],[9,39,9,43],[33,11,33,25],[12,1,12,12],[12,13,12,16],[12,17,12,19],[12,20,12,22],[12,23,12,25],[12,26,12,28],[12,29,12,33],[12,34,12,38],[12,39,12,43],[8,39,8,43],[9,44,9,48],[10,44,10,48],[11,1,11,12],[11,13,11,16],[11,17,11,19],[11,20,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,33],[11,34,11,38],[11,39,11,43],[11,44,11,48],[10,1,10,12],[10,13,10,16],[10,17,10,19],[10,20,10,22],[10,23,10,25],[10,26,10,28],[10,29,10,33],[10,34,10,38],[10,39,10,43],[9,1,9,12],[9,13,9,16],[36,11,36,25],[36,33,36,38],[13,44,13,48],[20,50,20,52],[21,50,21,52],[22,50,22,52],[23,50,23,52],[24,50,24,52],[12,44,12,48],[13,1,13,12],[13,13,13,16],[13,17,13,19],[13,20,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,33],[13,34,13,38],[13,39,13,43],[14,34,14,38],[14,39,14,43],[14,44,14,48],[15,34,15,38],[15,39,15,43],[15,44,15,48],[3,10,3,23],[14,1,14,12],[14,13,14,16],[14,17,14,19],[14,20,14,22],[14,23,14,25],[14,26,14,28],[14,29,14,33],[35,11,35,25],[15,1,15,12],[15,13,15,16],[15,17,15,19],[15,20,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,33],[16,1,16,12],[16,13,16,16],[16,17,16,19],[16,20,16,22],[16,23,16,25],[16,26,16,28],[16,29,16,33],[18,1,18,12],[16,44,16,48],[17,1,17,12],[17,13,17,16],[17,17,17,19],[17,20,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,33],[17,34,17,38],[17,39,17,43],[17,44,17,48],[5,46,5,48],[27,1,27,2],[27,3,32,48],[18,34,18,38],[18,39,18,43],[18,44,18,48],[19,1,19,12],[19,13,19,16],[19,17,19,19],[19,20,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,33],[18,13,18,16],[18,17,18,19],[18,20,18,22],[18,23,18,25],[18,26,18,28],[18,29,18,33],[19,34,19,38],[19,39,19,43],[19,44,19,48],[16,34,16,38],[16,39,16,43]]}
["Attachment 22 - Management Company Experience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for MC tab »","Necessary identification information provided","Has more than 10 affordable units","Participation didn't end 10 years ago","3+years","3+years & CTCAC","3+years & SN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1," is missing its Project Identification Number."]
[null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points earned:",null,null,null,null,{"$f":"BE26","v":0},null,null,null,null,null,null,null,null,null,null,"Application deadline:",{"$f":"'GP Exp'!AR4","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2," does not have more than 10 affordable units."]
[null,null,null,null,null,null,null,null,null,"Management Company Name:",{"$f":"Lists!AL2","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,"10325(c)(1)(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3," had management end too long ago."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,null,4," has less than 3 full years of management."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nonprofit or Special Needs set-aside:",{"$f":"OR(INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"Nonprofit (qualified nonprofit organization)\",INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"Nonprofit (Homeless assistance)\",INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"Special Needs\",INDEX(val,MATCH(\"t_SetAside\",ref,0))=\"At-Risk and Special Needs\")","v":false},null,null,null,null,null,null,null,null,null,"info warning","units warning","participation warning","below 3 warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Needs housing type:",{"$f":"INDEX(val,MATCH(\"t_HousingType\",ref,0))=\"Special Needs\"","v":false}]
[]
[null,"Project Name\nand Address",null,null,null,null,null,null,null,null,null,null,null,"Project ID. Number",null,null,null,"CTCAC Project",null,null,"Low Income Units",null,null,"Special Needs Project",null,null,"Special Needs Units",null,null,"Date Placed in Service",null,null,null,null,"Date Management Began",null,null,null,null,"Date Management Ended",null,null,null,null,"Full Years of Management"]
[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,null,null,null,null,null,null,{"$f":"IF(OR(AD10=\"\",AI10=\"\"),0,DATEDIF(MAX(AD10,AI10),MIN(AN10,IF($AR$3=\"\",TODAY(),$AR$3)),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BI10>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B10=\"\",N10=\"\"))","v":false},{"$f":"U10>10","v":false},{"$f":"OR(AN10=\"\",DATEDIF(AN10,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS10>=3,AND(AY10:BA10))","v":0},{"$f":"--AND(BB10,R10=TRUE)","v":0},{"$f":"IFERROR(--AND(BB10,X10=TRUE,AA10/U10>=45%),0)","v":0},{"$f":"AND(NOT(AY10),B10<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ10),$B10<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA10),$B10<>\"\")*$BG$5","v":0},{"$f":"AND(AS10<3,$B10<>\"\")*$BH$5","v":0},{"$f":"MAX(BE10:BH10)","v":0},{"$f":"COUNTIFS($BI$10:BI10,\">0\")*(BI10>0)","v":0},{"$f":"IF(BI10>0,\"Project \"&A10&INDEX($BK$2:$BK$5,BI10),\"\")","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,null,null,null,null,null,null,{"$f":"IF(OR(AD11=\"\",AI11=\"\"),0,DATEDIF(MAX(AD11,AI11),MIN(AN11,IF($AR$3=\"\",TODAY(),$AR$3)),\"y\"))","v":0},null,null,null,null,{"$f":"IF(BI11>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B11=\"\",N11=\"\"))","v":false},{"$f":"U11>10","v":false},{"$f":"OR(AN11=\"\",DATEDIF(AN11,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS11>=3,AND(AY11:BA11))","v":0},{"$f":"--AND(BB11,R11=TRUE)","v":0},{"$f":"IFERROR(--AND(BB11,X11=TRUE,AA11/U11>=45%),0)","v":0},{"$f":"AND(NOT(AY11),B11<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ11),$B11<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA11),$B11<>\"\")*$BG$5","v":0},{"$f":"AND(AS11<3,$B11<>\"\")*$BH$5","v":0},{"$f":"MAX(BE11:BH11)","v":0},{"$f":"COUNTIFS($BI$10:BI11,\">0\")*(BI11>0)","v":0},{"$f":"IF(BI11>0,\"Project \"&A11&INDEX($BK$2:$BK$5,BI11),\"\")","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,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(BI12>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B12=\"\",N12=\"\"))","v":false},{"$f":"U12>10","v":false},{"$f":"OR(AN12=\"\",DATEDIF(AN12,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS12>=3,AND(AY12:BA12))","v":0},{"$f":"--AND(BB12,R12=TRUE)","v":0},{"$f":"IFERROR(--AND(BB12,X12=TRUE,AA12/U12>=45%),0)","v":0},{"$f":"AND(NOT(AY12),B12<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ12),$B12<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA12),$B12<>\"\")*$BG$5","v":0},{"$f":"AND(AS12<3,$B12<>\"\")*$BH$5","v":0},{"$f":"MAX(BE12:BH12)","v":0},{"$f":"COUNTIFS($BI$10:BI12,\">0\")*(BI12>0)","v":0},{"$f":"IF(BI12>0,\"Project \"&A12&INDEX($BK$2:$BK$5,BI12),\"\")","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,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(BI13>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B13=\"\",N13=\"\"))","v":false},{"$f":"U13>10","v":false},{"$f":"OR(AN13=\"\",DATEDIF(AN13,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS13>=3,AND(AY13:BA13))","v":0},{"$f":"--AND(BB13,R13=TRUE)","v":0},{"$f":"IFERROR(--AND(BB13,X13=TRUE,AA13/U13>=45%),0)","v":0},{"$f":"AND(NOT(AY13),B13<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ13),$B13<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA13),$B13<>\"\")*$BG$5","v":0},{"$f":"AND(AS13<3,$B13<>\"\")*$BH$5","v":0},{"$f":"MAX(BE13:BH13)","v":0},{"$f":"COUNTIFS($BI$10:BI13,\">0\")*(BI13>0)","v":0},{"$f":"IF(BI13>0,\"Project \"&A13&INDEX($BK$2:$BK$5,BI13),\"\")","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,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(BI14>0,\"!\",\"\")","v":""},{"$f":"NOT(OR(B14=\"\",N14=\"\"))","v":false},{"$f":"U14>10","v":false},{"$f":"OR(AN14=\"\",DATEDIF(AN14,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS14>=3,AND(AY14:BA14))","v":0},{"$f":"--AND(BB14,R14=TRUE)","v":0},{"$f":"IFERROR(--AND(BB14,X14=TRUE,AA14/U14>=45%),0)","v":0},{"$f":"AND(NOT(AY14),B14<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ14),$B14<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA14),$B14<>\"\")*$BG$5","v":0},{"$f":"AND(AS14<3,$B14<>\"\")*$BH$5","v":0},{"$f":"MAX(BE14:BH14)","v":0},{"$f":"COUNTIFS($BI$10:BI14,\">0\")*(BI14>0)","v":0},{"$f":"IF(BI14>0,\"Project \"&A14&INDEX($BK$2:$BK$5,BI14),\"\")","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,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"NOT(OR(B15=\"\",N15=\"\"))","v":false},{"$f":"U15>10","v":false},{"$f":"OR(AN15=\"\",DATEDIF(AN15,$AR$3,\"y\")<10)","v":true},{"$f":"--AND(AS15>=3,AND(AY15:BA15))","v":0},{"$f":"--AND(BB15,R15=TRUE)","v":0},{"$f":"IFERROR(--AND(BB15,X15=TRUE,AA15/U15>=45%),0)","v":0},{"$f":"AND(NOT(AY15),B15<>\"\")*BE$5","v":0},{"$f":"AND(NOT(AZ15),$B15<>\"\")*$BF$5","v":0},{"$f":"AND(NOT(BA15),$B15<>\"\")*$BG$5","v":0},{"$f":"AND(AS15<3,$B15<>\"\")*$BH$5","v":0},{"$f":"MAX(BE15:BH15)","v":0},{"$f":"COUNTIFS($BI$10:BI15,\">0\")*(BI15>0)","v":0},{"$f":"IF(BI15>0,\"Project \"&A15&INDEX($BK$2:$BK$5,BI15),\"\")","v":""}]
[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,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI16,\">0\")*(BI16>0)","v":0},{"$f":"IF(BI16>0,\"Project \"&A16&INDEX($BK$2:$BK$5,BI16),\"\")","v":""}]
[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,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI17,\">0\")*(BI17>0)","v":0},{"$f":"IF(BI17>0,\"Project \"&A17&INDEX($BK$2:$BK$5,BI17),\"\")","v":""}]
[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,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI18,\">0\")*(BI18>0)","v":0},{"$f":"IF(BI18>0,\"Project \"&A18&INDEX($BK$2:$BK$5,BI18),\"\")","v":""}]
[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,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI19,\">0\")*(BI19>0)","v":0},{"$f":"IF(BI19>0,\"Project \"&A19&INDEX($BK$2:$BK$5,BI19),\"\")","v":""}]
[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,null,null,null,null,null,null,0,null,null,null,null,null,false,false,true,0,0,0,0,0,0,0,0,{"$f":"COUNTIFS($BI$10:BI20,\">0\")*(BI20>0)","v":0},{"$f":"IF(BI20>0,\"Project \"&A20&INDEX($BK$2:$BK$5,BI20),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,null,{"$f":"SUM(BB10:BB20)","v":0},{"$f":"SUM(BC10:BC20)","v":0},{"$f":"SUM(BD10:BD20)","v":0}]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(1:1),$BJ$10:$BJ$20,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF22&\"-points requires:\"","v":"2-points requires:"},null,null,6,2,0,{"$f":"AND($BB$21>=BB22,$BC$21>=BC22,$BD$21>=BD22)*BF22","v":0},2,"6-10 projects managed over 3 years, of which 2 shall be California Low Income Housing Tax Credit projects 2 points"]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(2:2),$BJ$10:$BJ$20,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF23&\"-points requires:\"","v":"3-points requires:"},null,null,11,2,0,{"$f":"AND($BB$21>=BB23,$BC$21>=BC23,$BD$21>=BD23)*BF23","v":0},3,"11 or more projects managed over 3 years, of which 2 shall be California Low Income Housing Tax Credit projects 3 points"]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(3:3),$BJ$10:$BJ$20,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF24&\"-points requires:\"","v":"2-points requires:"},null,null,0,1,2,{"$f":"AND($BB$21>=BB24,$BC$21>=BC24,$BD$21>=BD24)*BF24*$AU$6*$AU$7","v":0},2,"2-3 Special Needs projects managed over 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the special needs projects 2 points"]
[null,{"$f":"IFERROR(INDEX($BK$10:$BK$20,MATCH(ROW(4:4),$BJ$10:$BJ$20,0)),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF25&\"-points requires:\"","v":"3-points requires:"},null,null,0,1,4,{"$f":"AND($BB$21>=BB25,$BC$21>=BC25,$BD$21>=BD25)*BF25*$AU$6*$AU$7","v":0},3,"4 or more Special Needs projects managed over 3 years and one California Low Income Housing Tax Credit project which may or may not be one of the special needs projects 3 points"]
[null,"Projects must have more than 10 affordable units and be subject to a recorded regulatory agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MAX(BE22:BE25)","v":0}]
[]
[null,null,null,"Management Companies managing less than two active California Low-Income Housing Tax Credit projects for more than three years, and management companies for projects requesting points under the special needs categories and managing no active California Low-Income Housing Tax Credit projects for more than three years, shall contract with a bona-fide management company currently managing two California Low Income Housing Tax Credit projects for more than three years and which itself earns a minimum combined total of two points at the time of application. Please provide a separate Attachment 22 form for the bona-fide management company that currently operates tax credit projects in California and which itself earns a minimum combined total of two points at the time of application."]
[]
[]
[]
[]
[]
[null,"Management Company Name: ",null,null,null,null,null,null,null,null,null,{"$f":"K4","v":0}]
[]
[null,"Management Principal 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,"Principal Signature:"]
[null,"Management Principal Title:",null,null,null,null,null,null,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":"LSQ","index":3,"n_rows":357,"n_cols":50,"rows_kept":357,"cut":false,"hidden":false,"merged":[[352,10,353,25],[354,10,354,25],[354,31,354,48],[355,10,355,25],[355,31,355,36],[323,4,330,45],[332,4,338,45],[339,2,342,46],[346,6,346,7],[348,6,348,7],[309,10,309,25],[309,31,309,48],[310,10,310,25],[310,31,310,36],[316,19,316,34],[287,4,293,45],[294,2,297,46],[301,6,301,7],[303,6,303,7],[307,0,308,9],[307,10,308,25],[265,10,265,25],[265,31,265,36],[262,0,263,9],[271,19,271,34],[278,4,285,45],[249,2,252,46],[256,6,256,7],[258,6,258,7],[262,10,263,25],[264,10,264,25],[264,31,264,48],[136,19,136,34],[181,19,181,34],[226,19,226,34],[233,4,240,45],[242,4,248,45],[174,10,174,25],[174,31,174,48],[175,10,175,25],[175,31,175,36],[0,0,0,48],[2,19,2,34],[152,4,158,45],[159,2,162,46],[166,6,166,7],[168,6,168,7],[172,10,173,25],[129,10,129,25],[129,31,129,48],[130,10,130,25],[130,31,130,36],[143,4,150,45],[107,4,113,45],[114,2,117,46],[121,6,121,7],[123,6,123,7],[127,10,128,25],[84,10,84,25],[84,31,84,48],[85,10,85,25],[85,31,85,36],[98,4,105,45],[91,19,91,34],[62,4,68,45],[69,2,72,46],[76,6,76,7],[78,6,78,7],[82,10,83,25],[31,6,31,7],[8,4,15,45],[17,4,23,45],[24,2,27,46],[53,4,60,45],[33,6,33,7],[37,10,38,25],[39,10,39,25],[40,10,40,25],[40,31,40,36],[39,31,39,48],[46,19,46,34],[213,6,213,7],[188,4,195,45],[197,4,203,45],[204,2,207,46],[211,6,211,7],[217,10,218,25],[219,10,219,25],[219,31,219,48],[220,10,220,25],[220,31,220,36]]}
["Attachment 5 - Legal Status Questionnaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for LSQ tab »"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[null,null,null,"APPLICANT’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G32=\"X\",G34=\"X\"),\"!\",\"\")","v":""},{"$f":"IF(V33=\"!\",\"Both boxes cannot be selected.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Applicant Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],5),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A42=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y42=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"DEVELOPER’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Developer Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],4),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Developer"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A87=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y87=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"GENERAL PARTNER’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"General Partner Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],1),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Partner"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A132=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y132=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"GENERAL PARTNER’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"General Partner Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],2),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Partner"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,{"$f":"IF(A179=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y179=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"GENERAL PARTNER’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the applicant/borrower/developer/project sponsor is or has been a party and which might have a material impact on the financial viability of the project or the applicant/ borrower/developer/project sponsor. Such disclosures should include any parent, subsidiary, or affiliate of the applicant/borrower/developer/project sponsor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the applicant/borrower/developer/project sponsor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"General Partner Name:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],3),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Partner"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A222=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(Y222=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"PROPERTY MANAGEMENT COMPANY’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the property managment company is or has been a party and which might have a material impact on the financial viability of the project or the property managment company. Such disclosures should include any parent, subsidiary, or affiliate of the property managment company that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the property managment company, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
["Property Management Company:",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],7),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Management Company"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(B267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(C267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(D267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(E267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(F267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(G267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(H267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(I267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(J267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(K267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(L267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(M267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(N267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(O267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(P267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(Q267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(R267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(S267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(T267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(U267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(V267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(W267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(X267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(Y267=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"PROPERTY MANAGEMENT COMPANY’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the property managment company is or has been a party and which might have a material impact on the financial viability of the project or the property managment company. Such disclosures should include any parent, subsidiary, or affiliate of the property managment company that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the property managment company, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
["Property Management Company:",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],8),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Management Company"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(B312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(C312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(D312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(E312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(F312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(G312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(H312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(I312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(J312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(K312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(L312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(M312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(N312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(O312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(P312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(Q312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(R312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(S312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(T312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(U312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(V312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(W312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(X312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(Y312=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
[null,null,null,"GENERAL CONTRACTOR’S DISCLOSURE"]
[]
[null,null,null,"1.","Financial Viability"]
[]
[null,null,null,null,"Disclose material information relating to any legal or regulatory proceeding or investigation in which the general contractor is or has been a party and which might have a material impact on the financial viability of the project or the general contractor. Such disclosures should include any parent, subsidiary, or affiliate of the general contractor that is involved in the management, operation, or development of the project."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.","Fraud, Corruption, or Serious Harm"]
[null,null,null,null,"Disclose any civil, criminal, or regulatory action in which the general contractor, or any current board members (not including volunteer board members of non-profit entities), partners, limited liability corporation members, senior officers, or senior management personnel has been named a defendant in such action in the past ten years involving fraud or corruption, matters related to employment conditions (including, but not limited to wage claims, discrimination, or harassment), or matters involving health and safety where there are allegations of serious harm to employees, the public or the environment."]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosures should include civil or criminal cases filed in state or federal court; civil or criminal investigations by local, state, or federal law enforcement authorities; and enforcement proceedings or investigations by local, state or federal regulatory agencies. The information provided must include relevant dates, the nature of the allegation(s), charges, complaint or filing, and the outcome.\n\nI/We attest that we have provided full disclosure as indicated in response to the items #1 and #2 above."]
[]
[]
[]
[]
[null,null,null,"Select only one:"]
[]
[null,null,null,null,null,null,null,null,null,"Nothing to Disclose"]
[]
[null,null,null,null,null,null,null,null,null,"Disclosure provided in tab 5"]
[null,null,null,null,null,null,null,null,null,null,"Disclosure narratives should be saved as a separate file for each entity that has items to disclose."]
[]
[]
[null,null,null,null,null,null,null,null,null,"General Contractor:",{"$f":"IFERROR(INDEX(GeneralPartners[LSQoptions],6),\"\")","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," Signature:"]
[null,null,null,null,null,null,null,null,null,"Signatory Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Contractor"]
[null,null,null,null,null,null,null,null,null,"Signatory Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,{"$f":"IF(A357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(B357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(C357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(D357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(E357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(F357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(G357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(H357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(I357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(J357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(K357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(L357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(M357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(N357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(O357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(P357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(Q357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(R357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(S357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(T357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(U357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(V357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(W357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(X357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""},{"$f":"IF(Y357=\"!\",\"Only tribal applicants may use developer experience\",\"\")","v":""}]

{"sheet":"Zoning","index":4,"n_rows":47,"n_cols":47,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,12,36,13],[46,4,49,39],[0,45,0,55],[0,0,1,43],[11,32,11,42],[12,32,12,42],[16,33,16,34],[42,7,42,26],[42,31,42,40],[43,7,43,26],[38,9,38,40],[19,36,19,37],[21,23,21,24],[30,2,32,41],[23,16,23,23],[19,26,19,33],[5,28,5,41],[6,28,6,41],[7,28,7,41],[4,7,5,20],[7,7,7,20],[6,7,6,20],[11,9,11,20],[21,14,21,21],[26,3,27,43],[28,3,28,43],[25,30,25,43],[25,3,25,21],[12,9,14,20],[23,25,23,26],[25,22,25,29],[21,2,21,13],[19,2,19,25],[18,2,18,41],[13,32,14,42]]}
["Attachment 14 - \nVerification of Zoning and Land Use Entitlement Approvals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Zoning tab »"]
[]
[]
[]
[null,"Agency Name:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:"]
[null,"City:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:"]
[]
[]
[]
[null,"Project Name:",null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Number of Units:",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_UnitsTotal\",ref,0))","v":0}]
[null,"Project Address/Site:",null,null,null,null,null,null,null,{"$f":"CONCATENATE(INDEX(val,MATCH(\"g_ProjectAddress\",ref,0)),\", \",CHAR(10),INDEX(val,MATCH(\"g_City\",ref,0)),\", CA \",INDEX(val,MATCH(\"g_ZipCode\",ref,0)),CHAR(10),INDEX(val,MATCH(\"g_County\",ref,0)),\" County\")","v":"0, \n0, CA 0\n(select one) County"},null,null,null,null,null,null,null,null,null,null,null,null,"Census Tract Number(s):",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_CensusTract\",ref,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,"Assessor Parcel Number(s):"]
[]
[]
[null,null,"Is this project, as proposed, zoned for the intended use or existing legal non-conforming?"]
[]
[null,null,"Are all necessary* public or tribal approvals subject to the discretion of local or tribal elected officials necessary to "]
[null,null,"begin construction are either finally approved or not applicable as of ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GP Exp'!AR4","v":"00:00:00"},null,null,null,null,null,null,null,"?",null,null,null,null,null,null,null,null,null,{"$f":"IF(AA20=0,\"!\",\"\")","v":"!"},{"$f":"IF(AS20=\"!\",\" Enter application deadline on GP Exp tab\",\"\")","v":" Enter application deadline on GP Exp tab"}]
[]
[null,null,"Are all appeal periods expired by ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GP Exp'!AR4","v":"00:00:00"},null,null,null,null,null,null,null,"?"]
[]
[null,null,null,"If no, will all appeal periods expire by",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('GP Exp'!AR4+30)","v":"1900-01-30"},null,null,null,null,null,null,null,"?"]
[]
[null,null,null,"Applicant must re-submit Attachment 14 to CTCAC by ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24+7","v":"1900-02-06"},null,null,null,null,null,null,null,"as proof that either no appeals were "]
[null,null,null,"filed, or that any appeals filed during that time period were resolved within that 30-day period and the project is ready to proceed. \n"]
[]
[null,null,null,"Email proof to TCACdocs@treasurer.ca.gov."]
[]
[null,null,"*Please note, the following approvals, even if they are discretionary, are not required (by CDLAC and CTCAC) to be obtained at the time of the CDLAC and CTCAC applications: design review, initial environmental study assessments, variances, and development agreements."]
[]
[]
[]
[null,null,"Are you aware of any outstanding approvals required from the Planning Commission, City Council, Board of "]
[null,null,"Supervisors, or other agency for this project that may delay meeting 180/194 day readiness requirements,"]
[null,null,"excluding building permits?"]
[]
[null,null,"If yes, please list:"]
[]
[]
[]
[null,null,null,null,null,null,"Completed by:",null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"IF(OR(AH17=\"No\",AK20=\"No\",Z24=\"No\",M37=\"Yes\"),\"!\",\"\")","v":""},{"$f":"IF(AT43=\"!\",\"Some responses selected indicate that the project may not meet readiness requirements\",\"\")","v":""}]
[null,null,null,null,null,null,null,"(signature)"]
[]
[]
[null,null,null,null,"Note: When the appeal period, if any, is concluded, the applicant must submit proof within 7 days to TCACdocs@treasurer.ca.gov that either no appeals were filed, or that any appeals filed during that time period were resolved within that 30-day period and the project is ready to proceed."]

{"sheet":"Syndication","index":5,"n_rows":50,"n_cols":50,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,17,10,25],[16,3,16,14],[22,3,22,14],[23,3,23,5],[0,0,0,48],[2,30,2,45],[8,3,8,15],[8,17,8,25],[8,26,8,34],[8,35,8,43],[5,17,6,25],[5,26,6,34],[2,1,2,13],[23,6,23,14],[17,3,17,5],[17,6,17,14],[20,3,20,14],[10,3,10,15],[12,3,12,14],[23,17,23,25],[13,17,13,25],[14,17,14,25],[15,17,15,25],[16,17,16,25],[17,17,17,25],[18,17,18,25],[20,17,20,25],[21,17,21,25],[22,17,22,25],[21,3,21,14],[13,3,13,14],[14,3,14,14],[15,3,15,14],[28,35,28,43],[24,35,24,43],[5,35,6,43],[18,35,18,43],[20,35,20,43],[21,35,21,43],[22,35,22,43],[23,35,23,43],[10,35,10,43],[13,35,13,43],[14,35,14,43],[15,35,15,43],[16,35,16,43],[27,35,27,43],[17,35,17,43],[18,26,18,34],[20,26,20,34],[21,26,21,34],[22,26,22,34],[23,26,23,34],[0,49,0,50],[48,11,48,31],[49,11,49,31],[46,36,46,45],[32,3,34,45],[38,3,38,12],[40,3,40,12],[39,3,39,13],[29,35,29,43],[30,17,30,25],[30,26,30,34],[30,35,30,43],[46,11,46,31],[29,17,29,25],[29,26,29,34],[27,17,27,25],[2,14,2,29],[38,15,38,22],[39,15,39,22],[40,15,40,22],[41,15,41,22],[27,26,27,34],[24,17,24,25],[28,17,28,25],[28,26,28,34],[24,26,24,34],[17,26,17,34],[10,26,10,34],[13,26,13,34],[14,26,14,34],[15,26,15,34],[16,26,16,34]]}
["Attachment 16 - Terms of Syndication Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Syndication tab »"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"is interested in purchasing an interest in ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"Estimated net syndication proceeds may be calculated as follows:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal LIHTC",null,null,null,null,null,null,null,null,"State LIHTC",null,null,null,null,null,null,null,null,"Solar or Historical Tax Credit"]
[]
[]
[null,null,null,"Tax Credit Allocated (100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"t_FederalCreditsAnnual\",ref,0))","v":0},null,null,null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"t_FederalCreditsAnnual\",ref,0))","v":0},null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Gross Equity Proceeds (100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Expenses"]
[null,null,null,"Investor fees",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Organizational and offering ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Reserves or working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total Investor Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R14:Z18)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA14:AI18)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ14:AR18)","v":0}]
[]
[null,null,null,"Partnership expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Legal ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Accounting ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total Partnership Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R21:Z24)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA21:AI24)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ21:AR24)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenses",{"$f":"SUM(R19,R25)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA19,AA25)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AJ19,AJ25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Equity Proceeds",{"$f":"R11-R28","v":0},null,null,null,null,null,null,null,null,{"$f":"AA11-AA28","v":0},null,null,null,null,null,null,null,null,{"$f":"AJ11-AJ28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenses/Gross Proceeds",{"$f":"IFERROR(R28/R11,\"%\")","v":"%"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA28/AA11,\"%\")","v":"%"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AJ28/AJ11,\"%\")","v":"%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Proceeds Tax Credit Factor (100%)",{"$f":"IFERROR(R29/R9,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA29/AA9,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(AJ29/AJ9,0)","v":0}]
[]
[null,null,null,"None of the above fees earned by the investor will be included in the project’s eligible basis.  Consistent with CTCAC Regulation Section 10322(h)(19), the syndicator shall not pay any fees or provide any other financial or other substantive benefit to a partnership developer."]
[]
[]
[]
[null,null,null,"The estimated pay-in schedule is as follows:"]
[]
[null,null,null,"Limited Partner admission",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Permanent Loan conversion",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Receipt of IRS Form 8609",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P39:V41)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(NOT(P42=(R29+AA29)),\"!\",\"\")","v":""},{"$f":"IF(Y42=\"!\",\"Total paid-in does not equal sum of net federal and state equity.\",\"\")","v":""}]
[]
[null,null,null,"If there are any questions regarding these estimates please contact the undersigned."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Authorized Signatory:",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:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Name of Signatory:"]
[null,null,null,null,null,null,null,null,null,null,"Title of Signatory:"]

{"sheet":"Impact Fees","index":6,"n_rows":47,"n_cols":50,"rows_kept":47,"cut":false,"hidden":false,"merged":[[19,8,19,27],[19,28,19,38],[20,8,20,27],[18,28,18,38],[0,0,0,48],[3,9,3,43],[5,3,6,44],[8,3,11,45],[12,3,13,45],[16,8,16,27],[16,28,16,38],[17,8,17,27],[17,28,17,38],[18,8,18,27],[20,28,20,38],[46,11,46,31],[43,36,43,45],[41,11,41,31],[41,36,41,45],[42,36,42,45],[42,11,42,31],[43,11,43,31],[21,8,21,27],[21,28,21,38],[32,8,32,27],[32,28,32,38],[30,8,30,27],[30,28,30,38],[31,8,31,27],[31,28,31,38],[28,8,28,27],[28,28,28,38],[27,28,27,38],[22,8,22,27],[33,28,33,38],[34,28,34,38],[22,28,22,38],[23,8,23,27],[23,28,23,38],[24,8,24,27],[24,28,24,38],[25,8,25,27],[25,28,25,38],[29,8,29,27],[29,28,29,38],[26,8,26,27],[26,28,26,38],[27,8,27,27],[0,49,0,50],[38,8,38,27],[38,28,38,38],[33,8,33,10],[33,11,33,27],[34,8,34,10],[34,11,34,27],[35,8,35,10],[35,11,35,27],[36,8,36,10],[36,11,36,27],[35,28,35,38],[36,28,36,38],[37,28,37,38],[37,8,37,10],[37,11,37,27]]}
["Attachment 18A - Local Development Impact 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Impact Fees tab »"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[null,null,null,"Itemize all local impact fees to be paid. The total must correspond with the total local impact fees line item shown in the development budget of the application.\n"]
[]
[]
[null,null,null,"Pursuant to Regulation Section 10302(bb), Local development impact fees are defined as: The amount of impact fees, mitigation fees, or capital facilities fees imposed by municipalities, county agencies, or other jurisdictions such as public utility districts, school districts, water agencies, resource conservation districts, etc."]
[]
[]
[]
[null,null,null,"NOTE: Permit processing fees, building permit fees, and plan check fees are NOT considered local development impact fees.\n"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Type of Fees to be Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount of Fee"]
[null,null,null,null,null,null,null,null,"Community Development Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Drainage Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Facilities Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Fire Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"General Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Governmental/Environmental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Law Enforcement Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Library Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Parks & Recreation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Public Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Schools",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Streets & Signals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Traffic Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Waste Water Collection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Waste Water Treatment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Water Facilities ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total Local Development Impact Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC18:AM38)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Agency/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,"Phone:"]
[null,null,null,null,null,null,null,null,null,null,"Name of Signatory:",null,null,null,null,null,null,null,null,null,null,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,"Title of Signatory:",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:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Signature:"]

{"sheet":"Architect","index":7,"n_rows":60,"n_cols":50,"rows_kept":60,"cut":false,"hidden":false,"merged":[[56,36,56,45],[54,31,55,35],[25,6,26,45],[40,3,40,4],[43,6,44,45],[43,3,43,4],[54,36,55,45],[25,3,25,4],[28,3,28,4],[28,6,30,45],[32,6,34,45],[32,3,32,4],[36,3,36,4],[55,9,55,29],[59,9,59,29],[7,3,7,4],[7,6,8,45],[10,3,10,4],[12,6,14,45],[12,3,12,4],[54,9,54,29],[40,6,41,45],[16,3,16,4],[18,3,18,4],[20,3,20,4],[20,6,21,45],[56,9,56,29],[48,0,48,48],[49,3,52,45],[36,6,38,44],[0,49,0,50],[0,0,0,48],[3,9,3,43],[5,3,6,44],[23,3,23,4]]}
["Attachment 18B - Architect Threshold Basis Limit Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Architect tab »"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[null,null,null,"CHECK THE RELEVANT/APPROPRIATE BOXES TO THE PROJECT AND SIGN AS INDICATED:"]
[]
[null,null,null,null,null,null,"Provide parking beneath residential units (but not “tuck under” parking) or through construction of an on-site parking structure of two or more levels."]
[]
[]
[null,null,null,null,null,null,"Day care center is part of the project."]
[]
[null,null,null,null,null,null,"Project requires seismic upgrading of existing structures, and/ or projects requiring toxic or other environmental mitigation.\n(Must attach additional verification of estimated cost from project architect or seismic engineer.)"]
[]
[]
[]
[null,null,null,null,null,null,"At least 95% of upper floor units are serviced by elevator(s)."]
[]
[null,null,null,null,null,null,"At least 95% of the building(s) is constructed as Type I as defined in the California Building Code."]
[]
[null,null,null,null,null,null,"At least 95% of the building(s) is constructed as either a Type III as defined in the California Building Code, or a Type III/Type I combination."]
[]
[]
[null,null,null,null,null,null,"Project is all electric."]
[]
[null,null,null,null,null,null,"For rehabilitation projects, electric ready as defined in Section 160.9 of the 2022 Building Energy Efficiency Standards."]
[]
[]
[null,null,null,null,null,null,"Irrigate only with reclaimed water, greywater, or rainwater (excepting water used for Community Gardens) or irrigate with reclaimed water, greywater, or rainwater in an amount that annually equals or exceeds 20,000 gallons or 300 gallons per unit, whichever is less.\n"]
[]
[]
[]
[null,null,null,null,null,null,"Community Gardens of at least 60 square feet per unit. Permanent site improvements that provide a viable growing space within the project including solar access, fencing, watering systems, secure storage space for tools, and pedestrian access.\n"]
[]
[]
[]
[null,null,null,null,null,null,"Install bamboo, stained concrete, cork, salvaged or FSC-Certified wood, natural linoleum, natural rubber, or ceramic tile in all kitchens, living rooms, and bathrooms (where no VOC adhesives or backing is also used)."]
[]
[]
[]
[null,null,null,null,null,null,"Install bamboo, stained concrete, cork, salvaged or FSC-Certified wood, natural linoleum, natural rubber, or ceramic tile in all common areas (where no VOC adhesives or backing is also used)."]
[]
[]
[null,null,null,null,null,null,"For new construction projects, meet all requirements of the U.S. Environmental Protection Agency Indoor Air Plus Program."]
[]
[]
[]
[]
["ARCHITECT CERTIFICATION"]
[null,null,null,"I/We, as the architectural firm contractually responsible for the design and supervision (if applicable) of the above referenced project, certify as defined by Business and Professions Code Section 5536.26, under penalty of perjury, that each of the individual items identified in the threshold basis limit section of this application will be incorporated into the design of the project to which this application applies."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Firm Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State and License # :"]
[null,null,null,null,null,null,null,null,"Architect Name:"]
[null,null,null,null,null,null,null,null,"Architect Title:",null,null,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:"]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Signature:"]

{"sheet":"HERS Rater","index":8,"n_rows":44,"n_cols":50,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,9,43,29],[22,6,23,45],[13,6,14,45],[39,35,39,44],[33,0,33,48],[34,3,37,45],[39,9,39,29],[40,9,40,29],[29,3,29,4],[29,6,31,45],[16,3,16,4],[16,6,21,45],[25,3,25,4],[25,6,27,45],[40,35,40,44],[0,0,0,48],[0,49,0,50],[3,9,3,43],[5,3,6,44],[7,3,7,4],[7,6,12,45]]}
["Attachment 18C - HERS Rater Threshold Basis Limit Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for HERS Rater tab »"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[null,null,null,"CHECK THE RELEVANT/APPROPRIATE BOXES TO THE PROJECT AND SIGN AS INDICATED:"]
[]
[null,null,null,null,null,null,"Projects shall have onsite renewable generation estimated to produce 50% or more of annual tenant electricity use. If the combined available roof area of the project structures, including carports, is insufficient for provision of 50% of annual electricity use, then the project shall have onsite renewable generation based on at least 90%* of the available solar accessible roof area. Available solar accessible area is defined as roof area less north facing roof area for sloped roofs, equipment, solar thermal hot water, and required local or state fire department set-backs and access routes."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"*A project not availing itself of the 90% roof area exception may also receive the following increase only if the renewable generation used to calculate each basis increase does not overlap."]
[]
[]
[null,null,null,null,null,null,"Project shall have onsite renewable generation estimated to produce 75% or more of annual common area electricity use. If the combined available roof area of the project structures including carports is insufficient for provision of 75% of annual electricity use, then the project shall have onsite renewable generation based on at least 90%* of the available solar accessible roof area. Available solar accessible area is defined as roof area less north facing roof area for sloped roofs, equipment, solar thermal hot water, and required local or state fire department set-backs and access routes."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"*A project not availing itself of the 90% roof area exception may also receive the preceding increase only if the renewable generation used to calculate each basis increase does not overlap."]
[]
[]
[null,null,null,null,null,null,"Newly constructed project buildings shall be 15% more energy efficient than the applicable Building Energy Efficiency Standards (Energy Code, California Code of Regulations, Title 24) for energy efficiency alone (not counting solar)."]
[]
[]
[]
[null,null,null,null,null,null,"Rehabilitation project buildings shall have an 80% decrease in TDV energy use (or improvement in energy efficiency) post rehabilitation as demonstrated using the appropriate performance module of CEC approved software."]
[]
[]
[]
["HERS RATER CERTIFICATION"]
[null,null,null,"I/We, as the third-party HERS rater responsible for the review of the above referenced project, certify under penalty of perjury, that each of the individual items identified in the threshold basis limit section of this application will be incorporated into the design of the project to which this application applies."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Firm 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,"Rater ID :"]
[null,null,null,null,null,null,null,null,"HERS Rater 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:"]
[]
[]
[null,null,null,null,null,null,null,null,"HERS Rater Signature:"]

{"sheet":"Accessibility","index":9,"n_rows":40,"n_cols":50,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,49,0,50],[0,0,0,48],[3,9,3,43],[5,3,6,44],[7,3,7,4],[7,6,8,45],[36,9,36,29],[36,36,36,45],[39,9,39,29],[9,8,10,45],[12,8,13,45],[14,8,15,45],[16,8,19,45],[22,8,23,45],[24,8,25,45],[28,0,28,48],[29,3,32,45],[34,9,34,29],[34,31,35,35],[34,36,35,45],[35,9,35,29]]}
["Attachment 27 - Enhanced Accessibility and Visitability Architect Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Accessibility tab »"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[null,null,null,"CHECK THE RELEVANT/APPROPRIATE BOXES TO THE PROJECT AND SIGN AS INDICATED:"]
[]
[null,null,null,null,null,null,"Project design incorporates accessibility provisions of the Housing and Accessibility Requirements and the principles of Universal Design in at least half of the project's Low-Income Units, including: "]
[]
[null,null,null,null,null,null,null,"•","Accessible routes of travel to the dwelling units with accessible 34” minimum clear-opening-width entry, and 34” clear width for all doors on an accessible path.\n"]
[]
[null,null,null,null,null,null,null,"•","Interior doors with lever hardware and 42” minimum width hallways"]
[null,null,null,null,null,null,null,"•","Fully accessible bathrooms complying with CBC 11B. In addition, a 30”x48” clearance parallel to and centered on the bathroom vanity. "]
[]
[null,null,null,null,null,null,null,"•","Accessible kitchens with 30” x 48” clearance parallel to and centered on front of all major appliances and fixtures (refrigerator, oven, dishwasher and sink).\n"]
[]
[null,null,null,null,null,null,null,"•","Accessible primary bedroom size shall be at least 120 square feet (excluding the closet), shall accommodate a queen size bed, shall provide 36” in clearance around three sides of the bed, and shall provide required accessible clearances, free of all furnishings, at bedroom and closet doors. The primary bedroom closet shall be on an accessible path.\n"]
[]
[]
[]
[null,null,null,null,null,null,null,"•","Wiring for audio and visual doorbells required by UFAS shall be installed."]
[null,null,null,null,null,null,null,"•","Closets, balconies, shall be located on an accessible route."]
[null,null,null,null,null,null,null,"•","These units shall, to the maximum extent feasible and subject to reasonable health and safety requirements, be distributed throughout the project consistent with 24 CFR Section 8.26."]
[]
[null,null,null,null,null,null,null,"•","Applicant must commit to obtaining certification from a CASp or architect with demonstrated experience meeting federal accessibility requirements. "]
[]
[]
[]
["ARCHITECT CERTIFICATION"]
[null,null,null,"I/We, as the architectural firm contractually responsible for the design and supervision (if applicable) of the above referenced project, certify as defined by Business and Professions Code Section 5536.26, under penalty of perjury, that each of the individual items identified in the miscellaneous Federal and State Policies section of this application will be incorporated into the design of the project to which this application applies."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Firm Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State and License # :"]
[null,null,null,null,null,null,null,null,"Architect Name:"]
[null,null,null,null,null,null,null,null,"Architect Title:",null,null,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:"]
[]
[]
[null,null,null,null,null,null,null,null,"Architect Signature:"]

{"sheet":"Farmworker","index":10,"n_rows":17,"n_cols":50,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,9,15,29],[16,9,16,29],[15,36,15,45],[0,49,0,50],[6,0,6,48],[0,0,0,48],[3,9,3,43],[14,9,14,29],[7,3,10,45]]}
["Attachment 28 - Farmworker State Credit Eligibility Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Farmworker tab »"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10302(bb), 10302(cc), 10317(h), and 10317(j)"]
[]
[null,null,null,"Project Name:",null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_ProjectName\",ref,0))","v":0}]
[]
[]
["APPLICANT CERTIFICATION"]
[null,null,null,"I/We, who are authorized to legally act on the applicant’s behalf, certify and guarantee, under penalty of perjury, that the proposed development of permanent housing will be housing in which at least 50 percent of the units are available to and occupied by farmworkers and their families (as defined by California Labor Code Section 1140.4(b))."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Authorized Signature:"]
[null,null,null,null,null,null,null,null,"Name of Signatory:",null,null,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:"]
[null,null,null,null,null,null,null,null,"Applicant Name:",{"$f":"INDEX(val,MATCH(\"g_TcacApplicant\",ref,0))","v":0}]

{"sheet":"Data","index":11,"n_rows":195,"n_cols":21,"rows_kept":195,"cut":false,"hidden":true,"merged":[]}
["Reference","Value","Description",null,null,"Bedroom Type","Number of Units","Average Sq Ft","Net Rent","Monthly Utility","Targeted % AMI","Count SpN Units","Market Rate",null,"Average Affordability by AMI Actual Rents - SpN",null,null,null,"Average Affordability by AMI Actual Rents - Non-SpN SRO"]
[null,"Project Location",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B723=\"\",\"\",[1]Application!$B723),IF([1]Application!$B703=\"\",\"\",[1]Application!$B703))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G723=\"\",\"\",[1]Application!$G723),IF([1]Application!$G703=\"\",\"\",[1]Application!$G703))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K723=\"\",\"\",[1]Application!$K723),IF([1]Application!$K703=\"\",\"\",[1]Application!$K703))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O723=\"\",\"\",[1]Application!$O723),IF([1]Application!$O703=\"\",\"\",[1]Application!$O703))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T723=\"\",\"\",[1]Application!$T723),IF([1]Application!$Y703=\"\",\"\",[1]Application!$Y703))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC723,[1]Application!$AH703)","v":0},null,null,null,"Units","Unit % of Total","Pro Rata Target %",null,"Units","Unit % of Total","Pro Rata Target %"]
["g_ProjectName",{"$f":"IF(CreditType=4,[1]Application!$H$18,IF(CreditType=9,[1]Application!$H$17,\"Use a current e-app in order to link\"))","v":0},"Name of the project",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B724=\"\",\"\",[1]Application!$B724),IF([1]Application!$B704=\"\",\"\",[1]Application!$B704))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G724=\"\",\"\",[1]Application!$G724),IF([1]Application!$G704=\"\",\"\",[1]Application!$G704))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K724=\"\",\"\",[1]Application!$K724),IF([1]Application!$K704=\"\",\"\",[1]Application!$K704))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O724=\"\",\"\",[1]Application!$O724),IF([1]Application!$O704=\"\",\"\",[1]Application!$O704))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T724=\"\",\"\",[1]Application!$T724),IF([1]Application!$Y704=\"\",\"\",[1]Application!$Y704))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC724,[1]Application!$AH704)","v":0},null,null,null,{"$f":"IF(OR(L2=\"\",L2=0),\"\",L2)","v":""},{"$f":"IF(OR(O3=\"\",O3=0),\"\",O3/$O$37)","v":""},{"$f":"IF(OR(P3=0,P3=\"\"),\"\",P3*K2)","v":""},null,{"$f":"IF(F2=\"SRO/Studio\",G2-L2,\"\")","v":""},{"$f":"IF(OR(S3=\"\",S3=0),\"\",S3/$S$37)","v":""},{"$f":"IF(OR(T3=0,T3=\"\"),\"\",T3*$K2)","v":""}]
["g_ProjectAddress",{"$f":"IF([1]Application!$I$185=\"\",[1]Application!$E$187,[1]Application!$I$185)","v":0},"Primary address of site",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B725=\"\",\"\",[1]Application!$B725),IF([1]Application!$B705=\"\",\"\",[1]Application!$B705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G725=\"\",\"\",[1]Application!$G725),IF([1]Application!$G705=\"\",\"\",[1]Application!$G705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K725=\"\",\"\",[1]Application!$K725),IF([1]Application!$K705=\"\",\"\",[1]Application!$K705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O725=\"\",\"\",[1]Application!$O725),IF([1]Application!$O705=\"\",\"\",[1]Application!$O705))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T725=\"\",\"\",[1]Application!$T725),IF([1]Application!$Y705=\"\",\"\",[1]Application!$Y705))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC725,[1]Application!$AH705)","v":0},null,null,null,{"$f":"IF(OR(L3=\"\",L3=0),\"\",L3)","v":""},{"$f":"IF(OR(O4=\"\",O4=0),\"\",O4/$O$37)","v":""},{"$f":"IF(OR(P4=0,P4=\"\"),\"\",P4*K3)","v":""},null,{"$f":"IF(F3=\"SRO/Studio\",G3-L3,\"\")","v":""},{"$f":"IF(OR(S4=\"\",S4=0),\"\",S4/$S$37)","v":""},{"$f":"IF(OR(T4=0,T4=\"\"),\"\",T4*$K3)","v":""}]
["g_City",{"$f":"[1]Application!$I$189","v":0},"City",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B726=\"\",\"\",[1]Application!$B726),IF([1]Application!$B706=\"\",\"\",[1]Application!$B706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G726=\"\",\"\",[1]Application!$G726),IF([1]Application!$G706=\"\",\"\",[1]Application!$G706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K726=\"\",\"\",[1]Application!$K726),IF([1]Application!$K706=\"\",\"\",[1]Application!$K706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O726=\"\",\"\",[1]Application!$O726),IF([1]Application!$O706=\"\",\"\",[1]Application!$O706))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T726=\"\",\"\",[1]Application!$T726),IF([1]Application!$Y706=\"\",\"\",[1]Application!$Y706))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC726,[1]Application!$AH706)","v":0},null,null,null,"","","",null,"","",""]
["g_ZipCode",{"$f":"[1]Application!$I$190","v":0},"Zip Code",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B727=\"\",\"\",[1]Application!$B727),IF([1]Application!$B707=\"\",\"\",[1]Application!$B707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G727=\"\",\"\",[1]Application!$G727),IF([1]Application!$G707=\"\",\"\",[1]Application!$G707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K727=\"\",\"\",[1]Application!$K727),IF([1]Application!$K707=\"\",\"\",[1]Application!$K707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O727=\"\",\"\",[1]Application!$O727),IF([1]Application!$O707=\"\",\"\",[1]Application!$O707))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T727=\"\",\"\",[1]Application!$T727),IF([1]Application!$Y707=\"\",\"\",[1]Application!$Y707))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC727,[1]Application!$AH707)","v":0},null,null,null,"","","",null,"","",""]
["g_ScatteredSite",{"$f":"IF(CreditType=4,[1]Application!$T$197=\"Yes\",[1]Application!$AI$194=\"Yes\")","v":false},"If the project involves multiple scattered sites",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B728=\"\",\"\",[1]Application!$B728),IF([1]Application!$B708=\"\",\"\",[1]Application!$B708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G728=\"\",\"\",[1]Application!$G728),IF([1]Application!$G708=\"\",\"\",[1]Application!$G708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K728=\"\",\"\",[1]Application!$K728),IF([1]Application!$K708=\"\",\"\",[1]Application!$K708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O728=\"\",\"\",[1]Application!$O728),IF([1]Application!$O708=\"\",\"\",[1]Application!$O708))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T728=\"\",\"\",[1]Application!$T728),IF([1]Application!$Y708=\"\",\"\",[1]Application!$Y708))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC728,[1]Application!$AH708)","v":0},null,null,null,"","","",null,"","",""]
["g_CensusTract",{"$f":"[1]Application!$T$190","v":0},"Census tract project resides in",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B729=\"\",\"\",[1]Application!$B729),IF([1]Application!$B709=\"\",\"\",[1]Application!$B709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G729=\"\",\"\",[1]Application!$G729),IF([1]Application!$G709=\"\",\"\",[1]Application!$G709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K729=\"\",\"\",[1]Application!$K729),IF([1]Application!$K709=\"\",\"\",[1]Application!$K709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O729=\"\",\"\",[1]Application!$O729),IF([1]Application!$O709=\"\",\"\",[1]Application!$O709))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T729=\"\",\"\",[1]Application!$T729),IF([1]Application!$Y709=\"\",\"\",[1]Application!$Y709))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC729,[1]Application!$AH709)","v":0},null,null,null,"","","",null,"","",""]
["g_County",{"$f":"[1]Application!$T$189","v":"(select one)"},"County project resides in",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B730=\"\",\"\",[1]Application!$B730),IF([1]Application!$B710=\"\",\"\",[1]Application!$B710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G730=\"\",\"\",[1]Application!$G730),IF([1]Application!$G710=\"\",\"\",[1]Application!$G710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K730=\"\",\"\",[1]Application!$K730),IF([1]Application!$K710=\"\",\"\",[1]Application!$K710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O730=\"\",\"\",[1]Application!$O730),IF([1]Application!$O710=\"\",\"\",[1]Application!$O710))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T730=\"\",\"\",[1]Application!$T730),IF([1]Application!$Y710=\"\",\"\",[1]Application!$Y710))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC730,[1]Application!$AH710)","v":0},null,null,null,"","","",null,"","",""]
["g_DdaStatus",{"$f":"IF(CreditType=4,[1]Application!$T$195=\"Yes\",[1]Application!$T$193=\"Yes\")","v":false},"TRUE if designated a Difficult Development Area",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B731=\"\",\"\",[1]Application!$B731),IF([1]Application!$B711=\"\",\"\",[1]Application!$B711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G731=\"\",\"\",[1]Application!$G731),IF([1]Application!$G711=\"\",\"\",[1]Application!$G711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K731=\"\",\"\",[1]Application!$K731),IF([1]Application!$K711=\"\",\"\",[1]Application!$K711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O731=\"\",\"\",[1]Application!$O731),IF([1]Application!$O711=\"\",\"\",[1]Application!$O711))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T731=\"\",\"\",[1]Application!$T731),IF([1]Application!$Y711=\"\",\"\",[1]Application!$Y711))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC731,[1]Application!$AH711)","v":0},null,null,null,"","","",null,"","",""]
["g_QctStatus",{"$f":"IF(CreditType=4,[1]Application!$T$196=\"Yes\",[1]Application!$T$194=\"Yes\")","v":false},"TRUE if in a Qualified Census Tract",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B732=\"\",\"\",[1]Application!$B732),IF([1]Application!$B712=\"\",\"\",[1]Application!$B712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G732=\"\",\"\",[1]Application!$G732),IF([1]Application!$G712=\"\",\"\",[1]Application!$G712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K732=\"\",\"\",[1]Application!$K732),IF([1]Application!$K712=\"\",\"\",[1]Application!$K712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O732=\"\",\"\",[1]Application!$O732),IF([1]Application!$O712=\"\",\"\",[1]Application!$O712))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T732=\"\",\"\",[1]Application!$T732),IF([1]Application!$Y712=\"\",\"\",[1]Application!$Y712))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC732,[1]Application!$AH712)","v":0},null,null,null,"","","",null,"","",""]
["g_OpportunityArea",{"$f":"IF(CreditType=4,[1]Application!$T$193,[1]Application!$R$199)","v":"(select one)"},"Opportunity map designation",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B733=\"\",\"\",[1]Application!$B733),IF([1]Application!$B713=\"\",\"\",[1]Application!$B713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G733=\"\",\"\",[1]Application!$G733),IF([1]Application!$G713=\"\",\"\",[1]Application!$G713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K733=\"\",\"\",[1]Application!$K733),IF([1]Application!$K713=\"\",\"\",[1]Application!$K713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O733=\"\",\"\",[1]Application!$O733),IF([1]Application!$O713=\"\",\"\",[1]Application!$O713))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T733=\"\",\"\",[1]Application!$T733),IF([1]Application!$Y713=\"\",\"\",[1]Application!$Y713))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC733,[1]Application!$AH713)","v":0},null,null,null,"","","",null,"","",""]
["g_DistrictFederalCongressional",{"$f":"IF(CreditType=4,[1]Application!$AH$195,[1]Application!$O$225)","v":0},"Federal Congressional District",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B734=\"\",\"\",[1]Application!$B734),IF([1]Application!$B714=\"\",\"\",[1]Application!$B714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G734=\"\",\"\",[1]Application!$G734),IF([1]Application!$G714=\"\",\"\",[1]Application!$G714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K734=\"\",\"\",[1]Application!$K734),IF([1]Application!$K714=\"\",\"\",[1]Application!$K714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O734=\"\",\"\",[1]Application!$O734),IF([1]Application!$O714=\"\",\"\",[1]Application!$O714))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T734=\"\",\"\",[1]Application!$T734),IF([1]Application!$Y714=\"\",\"\",[1]Application!$Y714))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC734,[1]Application!$AH714)","v":0},null,null,null,"","","",null,"","",""]
["g_DistrictStateAssembly",{"$f":"IF(CreditType=4,[1]Application!$AH$196,[1]Application!$O$226)","v":0},"State Assembly District",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B735=\"\",\"\",[1]Application!$B735),IF([1]Application!$B715=\"\",\"\",[1]Application!$B715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G735=\"\",\"\",[1]Application!$G735),IF([1]Application!$G715=\"\",\"\",[1]Application!$G715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K735=\"\",\"\",[1]Application!$K735),IF([1]Application!$K715=\"\",\"\",[1]Application!$K715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O735=\"\",\"\",[1]Application!$O735),IF([1]Application!$O715=\"\",\"\",[1]Application!$O715))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T735=\"\",\"\",[1]Application!$T735),IF([1]Application!$Y715=\"\",\"\",[1]Application!$Y715))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC735,[1]Application!$AH715)","v":0},null,null,null,"","","",null,"","",""]
["g_DistrictStateSenate",{"$f":"IF(CreditType=4,[1]Application!$AH$197,[1]Application!$O$227)","v":0},"State Senate District",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B736=\"\",\"\",[1]Application!$B736),IF([1]Application!$B716=\"\",\"\",[1]Application!$B716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G736=\"\",\"\",[1]Application!$G736),IF([1]Application!$G716=\"\",\"\",[1]Application!$G716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K736=\"\",\"\",[1]Application!$K736),IF([1]Application!$K716=\"\",\"\",[1]Application!$K716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O736=\"\",\"\",[1]Application!$O736),IF([1]Application!$O716=\"\",\"\",[1]Application!$O716))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T736=\"\",\"\",[1]Application!$T736),IF([1]Application!$Y716=\"\",\"\",[1]Application!$Y716))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC736,[1]Application!$AH716)","v":0},null,null,null,"","","",null,"","",""]
["g_GeographicArea",{"$f":"IF(CreditType=4,IF(ISNUMBER(SEARCH(\":\",[1]Application!$D$220)),LEFT([1]Application!$D$220,SEARCH(\":\",[1]Application!$D$220)-1),[1]Application!$D$220),IF(ISNUMBER(SEARCH(\":\",[1]Application!$D$223)),LEFT([1]Application!$D$223,SEARCH(\":\",[1]Application!$D$223)-1),[1]Application!$D$223))","v":"(select one)"},"Geographic Region",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B737=\"\",\"\",[1]Application!$B737),IF([1]Application!$B717=\"\",\"\",[1]Application!$B717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G737=\"\",\"\",[1]Application!$G737),IF([1]Application!$G717=\"\",\"\",[1]Application!$G717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K737=\"\",\"\",[1]Application!$K737),IF([1]Application!$K717=\"\",\"\",[1]Application!$K717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O737=\"\",\"\",[1]Application!$O737),IF([1]Application!$O717=\"\",\"\",[1]Application!$O717))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T737=\"\",\"\",[1]Application!$T737),IF([1]Application!$Y717=\"\",\"\",[1]Application!$Y717))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC737,[1]Application!$AH717)","v":0},null,null,null,"","","",null,"","",""]
[null,"Project Characteristics",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B738=\"\",\"\",[1]Application!$B738),IF([1]Application!$B718=\"\",\"\",[1]Application!$B718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G738=\"\",\"\",[1]Application!$G738),IF([1]Application!$G718=\"\",\"\",[1]Application!$G718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K738=\"\",\"\",[1]Application!$K738),IF([1]Application!$K718=\"\",\"\",[1]Application!$K718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O738=\"\",\"\",[1]Application!$O738),IF([1]Application!$O718=\"\",\"\",[1]Application!$O718))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T738=\"\",\"\",[1]Application!$T738),IF([1]Application!$Y718=\"\",\"\",[1]Application!$Y718))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC738,[1]Application!$AH718)","v":0},null,null,null,"","","",null,"","",""]
["g_TaxCredits",{"$f":"[1]Application!$AS$1","v":4},"Type of tax credits",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B739=\"\",\"\",[1]Application!$B739),IF([1]Application!$B719=\"\",\"\",[1]Application!$B719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G739=\"\",\"\",[1]Application!$G739),IF([1]Application!$G719=\"\",\"\",[1]Application!$G719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K739=\"\",\"\",[1]Application!$K739),IF([1]Application!$K719=\"\",\"\",[1]Application!$K719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O739=\"\",\"\",[1]Application!$O739),IF([1]Application!$O719=\"\",\"\",[1]Application!$O719))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T739=\"\",\"\",[1]Application!$T739),IF([1]Application!$Y719=\"\",\"\",[1]Application!$Y719))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC739,[1]Application!$AH719)","v":0},null,null,null,"","","",null,"","",""]
["g_Rural",{"$f":"IF(CreditType=4,\nIF([1]Application!$T$199=\"Yes\",TRUE,FALSE),\nIF(OR(\n[1]Application!$D$211=\"Rural\",\n[1]Application!$D$211=\"Rural apportionment (Section 514)\",\n[1]Application!$D$211=\"Rural apportionment (CDBG-DR)\",\n[1]Application!$D$211=\"Rural apportionment (Section 515)\",\n[1]Application!$D$211=\"Rural apportionment (HOME)\",\n[1]Application!$D$211=\"Rural apportionment (Native American apportionment)\",\n[1]Application!$D$223=\"N/A\"),TRUE,FALSE))","v":false},"Rural",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B740=\"\",\"\",[1]Application!$B740),IF([1]Application!$B720=\"\",\"\",[1]Application!$B720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G740=\"\",\"\",[1]Application!$G740),IF([1]Application!$G720=\"\",\"\",[1]Application!$G720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K740=\"\",\"\",[1]Application!$K740),IF([1]Application!$K720=\"\",\"\",[1]Application!$K720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O740=\"\",\"\",[1]Application!$O740),IF([1]Application!$O720=\"\",\"\",[1]Application!$O720))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T740=\"\",\"\",[1]Application!$T740),IF([1]Application!$Y720=\"\",\"\",[1]Application!$Y720))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC740,[1]Application!$AH720)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesResUnitDemolition",{"$f":"IF(CreditType=4,\nAND([1]Application!$AJ$364=\"Yes\",[1]Application!$AJ$365>0),\nAND([1]Application!$AJ$357=\"Yes\",[1]Application!$AJ$358>0))","v":false},"Demolition of existing residential units",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B741=\"\",\"\",[1]Application!$B741),IF([1]Application!$B721=\"\",\"\",[1]Application!$B721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G741=\"\",\"\",[1]Application!$G741),IF([1]Application!$G721=\"\",\"\",[1]Application!$G721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K741=\"\",\"\",[1]Application!$K741),IF([1]Application!$K721=\"\",\"\",[1]Application!$K721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O741=\"\",\"\",[1]Application!$O741),IF([1]Application!$O721=\"\",\"\",[1]Application!$O721))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T741=\"\",\"\",[1]Application!$T741),IF([1]Application!$Y721=\"\",\"\",[1]Application!$Y721))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC741,[1]Application!$AH721)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesTenantRelocation",{"$f":"IF(CreditType=4,[1]Application!$AJ$366=\"Yes\",[1]Application!$AJ$359=\"Yes\")","v":false},"Relocation of existing residential tenants",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B742=\"\",\"\",[1]Application!$B742),IF([1]Application!$B722=\"\",\"\",[1]Application!$B722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G742=\"\",\"\",[1]Application!$G742),IF([1]Application!$G722=\"\",\"\",[1]Application!$G722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K742=\"\",\"\",[1]Application!$K742),IF([1]Application!$K722=\"\",\"\",[1]Application!$K722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O742=\"\",\"\",[1]Application!$O742),IF([1]Application!$O722=\"\",\"\",[1]Application!$O722))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T742=\"\",\"\",[1]Application!$T742),IF([1]Application!$Y722=\"\",\"\",[1]Application!$Y722))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC742,[1]Application!$AH722)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesRehabilitation",{"$f":"IF(CreditType=4,OR([1]Application!$M$366=\"Yes\",[1]Application!$M$367=\"Yes\"),OR([1]Application!$M$359=\"Yes\",[1]Application!$M$360=\"Yes\"))","v":false},"Rehab of existing residential buildings",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B743=\"\",\"\",[1]Application!$B743),IF([1]Application!$B723=\"\",\"\",[1]Application!$B723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G743=\"\",\"\",[1]Application!$G743),IF([1]Application!$G723=\"\",\"\",[1]Application!$G723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K743=\"\",\"\",[1]Application!$K743),IF([1]Application!$K723=\"\",\"\",[1]Application!$K723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O743=\"\",\"\",[1]Application!$O743),IF([1]Application!$O723=\"\",\"\",[1]Application!$O723))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T743=\"\",\"\",[1]Application!$T743),IF([1]Application!$Y723=\"\",\"\",[1]Application!$Y723))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC743,[1]Application!$AH723)","v":0},null,null,null,"","","",null,"","",""]
["g_Resyndication",{"$f":"IF(CreditType=4,[1]Application!$X$180=\"Yes\",[1]Application!$Y$180=\"Yes\")","v":false},"Resyndication",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B744=\"\",\"\",[1]Application!$B744),IF([1]Application!$B724=\"\",\"\",[1]Application!$B724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G744=\"\",\"\",[1]Application!$G744),IF([1]Application!$G724=\"\",\"\",[1]Application!$G724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K744=\"\",\"\",[1]Application!$K744),IF([1]Application!$K724=\"\",\"\",[1]Application!$K724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O744=\"\",\"\",[1]Application!$O744),IF([1]Application!$O724=\"\",\"\",[1]Application!$O724))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T744=\"\",\"\",[1]Application!$T744),IF([1]Application!$Y724=\"\",\"\",[1]Application!$Y724))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC744,[1]Application!$AH724)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesHomeOwnership",null,"Eventual home ownership",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B745=\"\",\"\",[1]Application!$B745),IF([1]Application!$B725=\"\",\"\",[1]Application!$B725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G745=\"\",\"\",[1]Application!$G745),IF([1]Application!$G725=\"\",\"\",[1]Application!$G725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K745=\"\",\"\",[1]Application!$K745),IF([1]Application!$K725=\"\",\"\",[1]Application!$K725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O745=\"\",\"\",[1]Application!$O745),IF([1]Application!$O725=\"\",\"\",[1]Application!$O725))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T745=\"\",\"\",[1]Application!$T745),IF([1]Application!$Y725=\"\",\"\",[1]Application!$Y725))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC745,[1]Application!$AH725)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesElevators",{"$f":"IF(CreditType=4,[1]Application!$R$420=\"Yes\",[1]Application!$R$412=\"Yes\")","v":false},"Elevators",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B746=\"\",\"\",[1]Application!$B746),IF([1]Application!$B726=\"\",\"\",[1]Application!$B726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G746=\"\",\"\",[1]Application!$G746),IF([1]Application!$G726=\"\",\"\",[1]Application!$G726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K746=\"\",\"\",[1]Application!$K746),IF([1]Application!$K726=\"\",\"\",[1]Application!$K726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O746=\"\",\"\",[1]Application!$O746),IF([1]Application!$O726=\"\",\"\",[1]Application!$O726))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T746=\"\",\"\",[1]Application!$T746),IF([1]Application!$Y726=\"\",\"\",[1]Application!$Y726))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC746,[1]Application!$AH726)","v":0},null,null,null,"","","",null,"","",""]
["g_OnTribalTrustLand",null,"Tribal trust land",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B747=\"\",\"\",[1]Application!$B747),IF([1]Application!$B727=\"\",\"\",[1]Application!$B727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G747=\"\",\"\",[1]Application!$G747),IF([1]Application!$G727=\"\",\"\",[1]Application!$G727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K747=\"\",\"\",[1]Application!$K747),IF([1]Application!$K727=\"\",\"\",[1]Application!$K727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O747=\"\",\"\",[1]Application!$O747),IF([1]Application!$O727=\"\",\"\",[1]Application!$O727))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T747=\"\",\"\",[1]Application!$T747),IF([1]Application!$Y727=\"\",\"\",[1]Application!$Y727))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC747,[1]Application!$AH727)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesCommercial",null,"Commercial space",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B748=\"\",\"\",[1]Application!$B748),IF([1]Application!$B728=\"\",\"\",[1]Application!$B728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G748=\"\",\"\",[1]Application!$G748),IF([1]Application!$G728=\"\",\"\",[1]Application!$G728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K748=\"\",\"\",[1]Application!$K748),IF([1]Application!$K728=\"\",\"\",[1]Application!$K728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O748=\"\",\"\",[1]Application!$O748),IF([1]Application!$O728=\"\",\"\",[1]Application!$O728))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T748=\"\",\"\",[1]Application!$T748),IF([1]Application!$Y728=\"\",\"\",[1]Application!$Y728))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC748,[1]Application!$AH728)","v":0},null,null,null,"","","",null,"","",""]
["g_IncludesCommunityServiceFacilities",null,"Community Service Facilities",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B749=\"\",\"\",[1]Application!$B749),IF([1]Application!$B729=\"\",\"\",[1]Application!$B729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G749=\"\",\"\",[1]Application!$G749),IF([1]Application!$G729=\"\",\"\",[1]Application!$G729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K749=\"\",\"\",[1]Application!$K749),IF([1]Application!$K729=\"\",\"\",[1]Application!$K729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O749=\"\",\"\",[1]Application!$O749),IF([1]Application!$O729=\"\",\"\",[1]Application!$O729))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T749=\"\",\"\",[1]Application!$T749),IF([1]Application!$Y729=\"\",\"\",[1]Application!$Y729))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC749,[1]Application!$AH729)","v":0},null,null,null,"","","",null,"","",""]
["g_PartOfSimultaneousPhases",null,"Multiple simultaneous phases",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B750=\"\",\"\",[1]Application!$B750),IF([1]Application!$B730=\"\",\"\",[1]Application!$B730))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G750=\"\",\"\",[1]Application!$G750),IF([1]Application!$G730=\"\",\"\",[1]Application!$G730))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K750=\"\",\"\",[1]Application!$K750),IF([1]Application!$K730=\"\",\"\",[1]Application!$K730))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O750=\"\",\"\",[1]Application!$O750),IF([1]Application!$O730=\"\",\"\",[1]Application!$O730))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T750=\"\",\"\",[1]Application!$T750),IF([1]Application!$Y730=\"\",\"\",[1]Application!$Y730))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC750,[1]Application!$AH730)","v":0},null,null,null,"","","",null,"","",""]
["g_FulfillsInclusionaryReq",null,"Fulfills inclusionary requirements",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B751=\"\",\"\",[1]Application!$B751),IF([1]Application!$B731=\"\",\"\",[1]Application!$B731))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G751=\"\",\"\",[1]Application!$G751),IF([1]Application!$G731=\"\",\"\",[1]Application!$G731))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K751=\"\",\"\",[1]Application!$K751),IF([1]Application!$K731=\"\",\"\",[1]Application!$K731))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O751=\"\",\"\",[1]Application!$O751),IF([1]Application!$O731=\"\",\"\",[1]Application!$O731))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T751=\"\",\"\",[1]Application!$T751),IF([1]Application!$Y731=\"\",\"\",[1]Application!$Y731))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC751,[1]Application!$AH731)","v":0},null,null,null,"","","",null,"","",""]
["g_IsHybrid",{"$f":"IF(CreditType=4,\n[1]Application!$T$200=\"Yes\",\nAND('[1]Tie Breaker'!$Q$46>0,'[1]Tie Breaker'!$G$66>0))","v":false},"Multiple simultaneous phase with differing credit types",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B752=\"\",\"\",[1]Application!$B752),IF([1]Application!$B732=\"\",\"\",[1]Application!$B732))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G752=\"\",\"\",[1]Application!$G752),IF([1]Application!$G732=\"\",\"\",[1]Application!$G732))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K752=\"\",\"\",[1]Application!$K752),IF([1]Application!$K732=\"\",\"\",[1]Application!$K732))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O752=\"\",\"\",[1]Application!$O752),IF([1]Application!$O732=\"\",\"\",[1]Application!$O732))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T752=\"\",\"\",[1]Application!$T752),IF([1]Application!$Y732=\"\",\"\",[1]Application!$Y732))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC752,[1]Application!$AH732)","v":0},null,null,null,"","","",null,"","",""]
["g_Historical",null,"Includes an historical building",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B753=\"\",\"\",[1]Application!$B753),IF([1]Application!$B733=\"\",\"\",[1]Application!$B733))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G753=\"\",\"\",[1]Application!$G753),IF([1]Application!$G733=\"\",\"\",[1]Application!$G733))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K753=\"\",\"\",[1]Application!$K753),IF([1]Application!$K733=\"\",\"\",[1]Application!$K733))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O753=\"\",\"\",[1]Application!$O753),IF([1]Application!$O733=\"\",\"\",[1]Application!$O733))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T753=\"\",\"\",[1]Application!$T753),IF([1]Application!$Y733=\"\",\"\",[1]Application!$Y733))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC753,[1]Application!$AH733)","v":0},null,null,null,"","","",null,"","",""]
[null,"Partnership Contacts",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B754=\"\",\"\",[1]Application!$B754),IF([1]Application!$B734=\"\",\"\",[1]Application!$B734))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G754=\"\",\"\",[1]Application!$G754),IF([1]Application!$G734=\"\",\"\",[1]Application!$G734))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K754=\"\",\"\",[1]Application!$K754),IF([1]Application!$K734=\"\",\"\",[1]Application!$K734))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O754=\"\",\"\",[1]Application!$O754),IF([1]Application!$O734=\"\",\"\",[1]Application!$O734))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T754=\"\",\"\",[1]Application!$T754),IF([1]Application!$Y734=\"\",\"\",[1]Application!$Y734))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC754,[1]Application!$AH734)","v":0},null,null,null,"","","",null,"","",""]
["g_EventualOwnershipEntity",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B755=\"\",\"\",[1]Application!$B755),IF([1]Application!$B735=\"\",\"\",[1]Application!$B735))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G755=\"\",\"\",[1]Application!$G755),IF([1]Application!$G735=\"\",\"\",[1]Application!$G735))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K755=\"\",\"\",[1]Application!$K755),IF([1]Application!$K735=\"\",\"\",[1]Application!$K735))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O755=\"\",\"\",[1]Application!$O755),IF([1]Application!$O735=\"\",\"\",[1]Application!$O735))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T755=\"\",\"\",[1]Application!$T755),IF([1]Application!$Y735=\"\",\"\",[1]Application!$Y735))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC755,[1]Application!$AH735)","v":0},null,null,null,"","","",null,"","",""]
["g_TcacApplicant",{"$f":"IF(CreditType=4,[1]Application!$H$16,[1]Application!$H$15)","v":0},"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B756=\"\",\"\",[1]Application!$B756),IF([1]Application!$B736=\"\",\"\",[1]Application!$B736))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G756=\"\",\"\",[1]Application!$G756),IF([1]Application!$G736=\"\",\"\",[1]Application!$G736))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K756=\"\",\"\",[1]Application!$K756),IF([1]Application!$K736=\"\",\"\",[1]Application!$K736))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O756=\"\",\"\",[1]Application!$O756),IF([1]Application!$O736=\"\",\"\",[1]Application!$O736))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T756=\"\",\"\",[1]Application!$T756),IF([1]Application!$Y736=\"\",\"\",[1]Application!$Y736))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC756,[1]Application!$AH736)","v":0},null,null,null,"","","",null,"","",""]
["g_LeadDeveloper",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$B757=\"\",\"\",[1]Application!$B757),IF([1]Application!$B737=\"\",\"\",[1]Application!$B737))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$G757=\"\",\"\",[1]Application!$G757),IF([1]Application!$G737=\"\",\"\",[1]Application!$G737))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$K757=\"\",\"\",[1]Application!$K757),IF([1]Application!$K737=\"\",\"\",[1]Application!$K737))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O757=\"\",\"\",[1]Application!$O757),IF([1]Application!$O737=\"\",\"\",[1]Application!$O737))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T757=\"\",\"\",[1]Application!$T757),IF([1]Application!$Y737=\"\",\"\",[1]Application!$Y737))","v":""},{"$f":"IF(CreditType=4,[1]Application!$AC757,[1]Application!$AH737)","v":0},null,null,null,"","","",null,"","",""]
["g_ManagingGeneralPartner",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J795=\"\",\"\",[1]Application!$J795),IF([1]Application!$J774=\"\",\"\",[1]Application!$J774))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O795=\"\",\"\",[1]Application!$O795),IF([1]Application!$O774=\"\",\"\",[1]Application!$O774))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T795=\"\",\"\",[1]Application!$T795),IF([1]Application!$T774=\"\",\"\",[1]Application!$T774))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X795=\"\",\"\",[1]Application!$X795),IF([1]Application!$X774=\"\",\"\",[1]Application!$X774))","v":""},null,null,0,true,null,{"$f":"SUM(O3:O36)","v":0},{"$f":"SUM(P3:P36)","v":0},{"$f":"SUM(Q3:Q36)","v":0},null,{"$f":"SUM(S3:S36)","v":0},{"$f":"SUM(T3:T36)","v":0},{"$f":"SUM(U3:U36)","v":0}]
["g_AdministrativeGeneralPartner",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J796=\"\",\"\",[1]Application!$J796),IF([1]Application!$J775=\"\",\"\",[1]Application!$J775))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O796=\"\",\"\",[1]Application!$O796),IF([1]Application!$O775=\"\",\"\",[1]Application!$O775))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T796=\"\",\"\",[1]Application!$T796),IF([1]Application!$T775=\"\",\"\",[1]Application!$T775))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X796=\"\",\"\",[1]Application!$X796),IF([1]Application!$X775=\"\",\"\",[1]Application!$X775))","v":""},null,null,0,true]
["g_ProjectSponsor",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J797=\"\",\"\",[1]Application!$J797),IF([1]Application!$J776=\"\",\"\",[1]Application!$J776))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O797=\"\",\"\",[1]Application!$O797),IF([1]Application!$O776=\"\",\"\",[1]Application!$O776))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T797=\"\",\"\",[1]Application!$T797),IF([1]Application!$T776=\"\",\"\",[1]Application!$T776))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X797=\"\",\"\",[1]Application!$X797),IF([1]Application!$X776=\"\",\"\",[1]Application!$X776))","v":""},null,null,0,true]
["g_PrimaryContact",null,"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J798=\"\",\"\",[1]Application!$J798),IF([1]Application!$J777=\"\",\"\",[1]Application!$J777))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O798=\"\",\"\",[1]Application!$O798),IF([1]Application!$O777=\"\",\"\",[1]Application!$O777))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T798=\"\",\"\",[1]Application!$T798),IF([1]Application!$T777=\"\",\"\",[1]Application!$T777))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X798=\"\",\"\",[1]Application!$X798),IF([1]Application!$X777=\"\",\"\",[1]Application!$X777))","v":""},null,null,0,true]
["g_PrimaryMgmt",{"$f":"IF(CreditType=4,[1]Application!$AA$344,[1]Application!$AA$329)","v":0},"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J799=\"\",\"\",[1]Application!$J799),IF([1]Application!$J778=\"\",\"\",[1]Application!$J778))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O799=\"\",\"\",[1]Application!$O799),IF([1]Application!$O778=\"\",\"\",[1]Application!$O778))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T799=\"\",\"\",[1]Application!$T799),IF([1]Application!$T778=\"\",\"\",[1]Application!$T778))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X799=\"\",\"\",[1]Application!$X799),IF([1]Application!$X778=\"\",\"\",[1]Application!$X778))","v":""},null,null,0,true]
["g_SecondMgmt",{"$f":"IF(CreditType=4,[1]Application!$P$352,[1]Application!$AA$337)","v":0},"Company name of key entity in Contacts table",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J800=\"\",\"\",[1]Application!$J800),IF([1]Application!$J779=\"\",\"\",[1]Application!$J779))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O800=\"\",\"\",[1]Application!$O800),IF([1]Application!$O779=\"\",\"\",[1]Application!$O779))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T800=\"\",\"\",[1]Application!$T800),IF([1]Application!$T779=\"\",\"\",[1]Application!$T779))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X800=\"\",\"\",[1]Application!$X800),IF([1]Application!$X779=\"\",\"\",[1]Application!$X779))","v":""},null,null,0,true]
[null,"Sources Information",null,null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J801=\"\",\"\",[1]Application!$J801),IF([1]Application!$J780=\"\",\"\",[1]Application!$J780))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O801=\"\",\"\",[1]Application!$O801),IF([1]Application!$O780=\"\",\"\",[1]Application!$O780))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T801=\"\",\"\",[1]Application!$T801),IF([1]Application!$T780=\"\",\"\",[1]Application!$T780))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X801=\"\",\"\",[1]Application!$X801),IF([1]Application!$X780=\"\",\"\",[1]Application!$X780))","v":""},null,null,0,true]
["g_SourcesPermanent",null,"Sum of Sources[PermAmount] rounded down",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J802=\"\",\"\",[1]Application!$J802),IF([1]Application!$J781=\"\",\"\",[1]Application!$J781))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O802=\"\",\"\",[1]Application!$O802),IF([1]Application!$O781=\"\",\"\",[1]Application!$O781))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T802=\"\",\"\",[1]Application!$T802),IF([1]Application!$T781=\"\",\"\",[1]Application!$T781))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X802=\"\",\"\",[1]Application!$X802),IF([1]Application!$X781=\"\",\"\",[1]Application!$X781))","v":""},null,null,0,true]
["g_SourcesConstruction",null,"Sum of Sources[ConAmount] rounded down",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J803=\"\",\"\",[1]Application!$J803),IF([1]Application!$J782=\"\",\"\",[1]Application!$J782))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O803=\"\",\"\",[1]Application!$O803),IF([1]Application!$O782=\"\",\"\",[1]Application!$O782))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T803=\"\",\"\",[1]Application!$T803),IF([1]Application!$T782=\"\",\"\",[1]Application!$T782))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X803=\"\",\"\",[1]Application!$X803),IF([1]Application!$X782=\"\",\"\",[1]Application!$X782))","v":""},null,null,0,true]
["g_SourcesDebtService",null,"Sum of Sources[DebtService] rounded down",null,null,{"$f":"IF(CreditType=4,IF([1]Application!$J804=\"\",\"\",[1]Application!$J804),IF([1]Application!$J783=\"\",\"\",[1]Application!$J783))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$O804=\"\",\"\",[1]Application!$O804),IF([1]Application!$O783=\"\",\"\",[1]Application!$O783))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$T804=\"\",\"\",[1]Application!$T804),IF([1]Application!$T783=\"\",\"\",[1]Application!$T783))","v":""},{"$f":"IF(CreditType=4,IF([1]Application!$X804=\"\",\"\",[1]Application!$X804),IF([1]Application!$X783=\"\",\"\",[1]Application!$X783))","v":""},null,null,0,true]
["g_TaxExemptFinPerm",null,"Sum of perm sources labeled Tax-Exempt Loan",null,null,0,{"$f":"[1]Application!$O$786","v":0},0,0,0,0,0]
["g_TaxExemptFinCon",null,"Sum of construction sources labeled Tax-Exempt Loan"]
["g_SourcesCommittedPerm",null,"Sum of committed permanent financing"]
["g_SourcesCommittedCon",null,"Sum of committed construction period financing"]
[null,"Cost Information"]
["g_TotalProjectCost",{"$f":"IF(CreditType=4,'[1]Sources and Uses Budget'!$B$105,'[1]Sources and Uses Budget'!$B$104)","v":0},"Sum of Uses[Use] individually rounded down, excluding headings"]
["g_TotalResidentialCost",{"$f":"IF(CreditType=4,'[1]Sources and Uses Budget'!$C$105,'[1]Sources and Uses Budget'!$C$104)","v":0},"Total Residential Project Cost from S&U"]
["g_LandCost",{"$f":"'[1]Sources and Uses Budget'!$B$4","v":0},"Land Cost from Sources and Uses Budget"]
["g_HoldingCost",{"$f":"'[1]Sources and Uses Budget'!$B$13","v":0},"Holding Cost from Sources and Uses Budget"]
["g_ImprovementsValue",{"$f":"'[1]Sources and Uses Budget'!$B$9","v":0},"Existing Improvements Value from Sources and Uses Budget"]
["g_CostRehab",{"$f":"'[1]Sources and Uses Budget'!$C$26","v":0},"Site, Structures, and Prevailing Wage for Rehabilitation from S&U Budget"]
["g_BasisEligible",null,"Sum of Uses[EligibleBasis] individually rounded down, excluding headings"]
["g_BasisAcquisition",null,"Sum of Uses[Acquisition Basis] individually rounded down, excluding headings"]
["g_CostCommercial",null,"Sum of Uses[Commercial Portion] individually rounded down, excluding headings"]
["g_CostCommunityService",null,"Sum of Uses[CSF Portion] individually rounded down, excluding headings"]
["g_CostResidential",null,"TotalProjectCost minus CostCommercial and CostCommunityService"]
["g_CapitalizedOperatingReserve",null,"Capitalized Operating Reserve from Uses table"]
["g_StatePrevailingWages",null,"Paying state prevailing wages"]
["g_FederalDavisBaconActWages",null,"Paying federal Davis Bacon Act wages"]
["g_TotalServicesBudget",{"$f":"'[1]15 Year Pro Forma'!$E$27","v":0},"Year 1 Services Cost from 15 Year Pro Forma"]
[null,"Square Footage Information"]
["g_SqFtTotal",null,"Total of all square footages"]
["g_SqFtResidential",null,"Sumproduce of Quantity and Square Feet in UnitsTbl"]
["g_SqFtLowIncome",null,"Includes only units with Gen AMI <= 80%"]
["g_SqFtExemptUnits",null,"Includes only units with Exempt Unit = TRUE"]
["g_SqFtCommon",null,"Exempt common area square footage"]
["g_SqFtCommunity",null,"Exempt community area square footage"]
["g_SqFtStructuredParking",null,"Structured parking square footage"]
["g_SqFtCommercial",null,"Commercial space square footage"]
["g_SqFtCommunityService",null,"Community service facility square footage"]
["g_SqFtSite",null,"Site size in acres * 43560"]
[null,"Unit Information"]
["g_UnitsRental",{"$f":"IF(CreditType=4,[1]Application!$AG$448,[1]Application!$AG$440)","v":0},"total number of units excluding managers units"]
["g_UnitsTotal",{"$f":"IF(CreditType=4,[1]Application!$AG$446,[1]Application!$AG$438)","v":0},"total of all units - low income, manager, and market-rate"]
["g_UnitsTaxCredit",{"$f":"IF(CreditType=4,[1]Application!$G$761+[1]Application!$O$785,[1]Application!$G$738+[1]Application!$O$764)","v":0},"UnitsLowIncome plus UnitsExempt"]
["g_UnitsNonTaxCredit",{"$f":"IF(CreditType=4,[1]Application!$O$7805,[1]Application!$O$784)","v":0},"UnitsResidential minus UnitsTaxCredit ( market rate)"]
["g_UnitsExempt",{"$f":"IF(CreditType=4,[1]Application!$O$785,[1]Application!$O$764)","v":0},"Sum of Exempt Units (manager units)",null,{"$f":"IF(CreditType=4,[1]Application!$Y$211,ROUNDUP(([1]Application!$AE$215*[1]Application!$AG$433),0))","v":0}]
["g_UnitsSubsidized",null,"Sum of Residential Unit with Contract Rent"]
["g_UnitsLowIncome",{"$f":"IF(CreditType=4,[1]Application!$G$761,[1]Application!$G$738)","v":0},"Sum of Res. Units at/below 80% AMI"]
["g_UnitsSpecialNeeds",null,"Sum of Special Needs units"]
["g_UnitsSpecialNeedsEapp",{"$f":"IF(CreditType=4,[1]Application!$Q$212,[1]Application!$S$215)","v":0},"Count of SpN units entered by applicant in e-app"]
["g_UnitsPsh",null,"Sum of Permanent Supportive Housing Units"]
["g_UnitsHomeless",{"$f":"IF(CreditType=4,[1]Application!$W$473,[1]Application!$W$468)","v":0},"Sum of Homeless Housing Units"]
["g_UnitsHomeOwnership",null,"Sum of Home Ownership units"]
["g_UnitsAgeRestricted",null,"Sum of Age Restricted units"]
["g_AmiAvgLowIncomeUnits",null,"Sum of Rental AMIs under 80% divided by UnitsLowIncome"]
["g_UnitsDemolished",null,"Count of existing units to be demolished"]
["g_UnitsRetained",null,"Count of existing units to be retained"]
["g_Units0",null,"Count all low-income studio units"]
["g_Units1",null,"Count all low-income 1-BR units"]
["g_Units2",null,"Count all low-income 2-BR units"]
["g_Units3",null,"Count all low-income 3-BR units"]
["g_Units4",null,"Count all low-income 4-BR units"]
["g_Units5",null,"Count all low-income 5-BR units"]
["g_SpNe0",null,"Count of Special Needs studio units"]
["g_SpNe1",null,"Count of Special Needs 1-BR units"]
["g_SpNe2",null,"Count of Special Needs 2-BR units"]
["g_SpNe3",null,"Count of Special Needs 3-BR units"]
["g_SpNe4",null,"Count of Special Needs 4-BR units"]
["g_SpNe5",null,"Count of Special Needs 5-BR units"]
["g_MktUnits0",null,"Count of Market Rate studio units"]
["g_MktUnits1",null,"Count of Market Rate 1-BR units"]
["g_MktUnits2",null,"Count of Market Rate 2-BR units"]
["g_MktUnits3",null,"Count of Market Rate 3-BR units"]
["g_MktUnits4",null,"Count of Market Rate 4-BR units"]
["g_MktUnits5",null,"Count of Market Rate 5-BR units"]
[null,"Product Information"]
["g_BuildingsResidential",null,"Quantity of residential buildings in the project"]
["g_BuildingsNonResidential",null,"Quantity of non-residential buildings in the project"]
["g_BuildingStories",{"$f":"IF(CreditType=4,\nIF(AND([1]Application!$AD$420>0,[1]Application!$AD$421>0),MAX([1]Application!$AD$420,[1]Application!$AD$421),IF([1]Application!$AD$420>0,[1]Application!$AD$420,IF([1]Application!$AD$421>0,[1]Application!$AD$421,1))),\n\nIF(AND([1]Application!$AD$412>0,[1]Application!$AD$413>0),MAX([1]Application!$AD$412,[1]Application!$AD$413),IF([1]Application!$AD$412>0,[1]Application!$AD$412,IF([1]Application!$AD$413>0,[1]Application!$AD$413,1))))","v":1},"Number of stories in buildings"]
["g_ParkingCount",null,"Parking spaces provided on site"]
["g_BedroomsTotal",{"$f":"SUM(((B95+B107)*1),((B96+B108)*1),((B97+B109)*2),((B98+B110)*3),((B99+B111)*4),((B100+B112)*5))","v":0},"Sum of unit bedrooms counting 1 per studio"]
["g_BedroomsSpecialNeeds",{"$f":"SUM((B101*1),(B102*1),(B103*2),(B104*3),(B105*4),(B106*5))","v":0},"Same calculation as above but requiring Special Needs designation"]
["g_LaundryWashersCount",null,"Community washing machines available for tenant use"]
["g_LaundryDryersCount",null,"Community clothes dryers available fore tenant use"]
["g_eAppBedroomsSpN",{"$f":"IF(CreditType=4,[1]Application!$AG$764,[1]Application!$AG$741)","v":0},"Number of Special Needs bedrooms listed in e-app"]
[null,"Cash Flow Information"]
["g_ResidentialIncomeMonthly",null,"Monthly residential rental income"]
["g_ContractRentIncomeMonthly",null,"Monthly rental subsidy income"]
["g_GrossPotentialIncome",null,"All income, excluding in-kind services, projected in Year 1"]
["g_TotalAnnualIncome",null,"All income projected in Year 1 after vacancy"]
["g_TotalAnnualExpenses",null,"Sum of Annual Expenses from ExpenseTbl"]
["g_AnnExpensesForTcacMin",null,"Sum of Annual Expenses that qualify towards TCAC minimum expenses"]
["g_AnnualReplacementReserves",null,"Annual Replacement Reserve funding from Expenese table"]
["g_AnnRepResPerUnit",null,"Annual Replacement Reserve per unit"]
["g_NetOperatingIncome",null,"Net Operating Income in Year 1"]
["g_TotalDebtService",null,"Total debt service in Year 1"]
["g_Lowest15YearCashFlow",null,"Minimum of first 15 years of cash flow after debt service"]
[null,"County Data"]
["tcd_RentLimits",null,"Year rent limits were published"]
["tcd_BasisLimits9",null,"Year basis limits were published"]
["tcd_BasisLimits4",null,"Year basis limits were published"]
["tcd_MinAnExp",null,"Year minimum operating expenses were published"]
["tcd_Version",null,"The version number for this file"]
[null,"Tax Credits"]
["t_FederalCreditsAnnual",null,"Maximum allowed Federal tax credits"]
["t_StateCreditsTotal",null,"Maximum allowed State tax credits"]
[null,"Developer Fee"]
["t_DeveloperFeeLimit",null,"Overall limit on developer fee"]
["t_MinDevFeeDeferral",null,"Minimum required deferral/contribution of developer fee"]
["t_DeveloperFeeLimitCapitalized",null,"Maximum allowable developer fee payments from sources"]
["t_TotalDeveloperFee",{"$f":"IF(CreditType=4,'[1]Sources and Uses Budget'!$B$104,'[1]Sources and Uses Budget'!$B$103)","v":0},"Total sum of all Developer fee"]
[null,"Threshold Basis Limits"]
["t_ThresholdBasisLimit"]
["t_UnAdjustedThresholdBasisLimit"]
["t_TblDeeperTargetingBoosts"]
[null,"Compliance"]
["t_HighCostPercentage"]
["t_ApplicableFraction"]
["t_TaxCreditUnits"]
["t_LowIncomeUnits"]
["t_MinOperatingExpenses"]
[null,"Application Characteristics"]
["t_CreditType",{"$f":"[1]Application!$AS$1","v":4}]
["t_SubmittalType"]
["t_IsBipocJv"]
["t_Is4percent"]
["t_Is9percent"]
["t_ResyndOriginalNumber1",{"$f":"IF(CreditType=4,CONCATENATE(\"CA-\",[1]Application!$S$385,\"-\",[1]Application!$V$385),CONCATENATE(\"CA-\",[1]Application!$S$378,\"-\",[1]Application!$V$378))","v":"CA--"}]
["t_ResyndOriginalNumber2",{"$f":"IF(CreditType=4,CONCATENATE(\"CA-\",[1]Application!$AD$385,\"-\",[1]Application!$AG$385),CONCATENATE(\"CA-\",[1]Application!$AD$378,\"-\",[1]Application!$AG$378))","v":"CA--"}]
["t_Is9snBothBoost"]
["t_IsLowValueRehab"]
["t_IsFarmworker"]
["t_Isg1B"]
["t_Isg1A"]
["t_IsNewConstruction",{"$f":"IF(CreditType=4,[1]Application!$M364=\"Yes\",[1]Application!$M357=\"Yes\")","v":false}]
["t_IsAdaptiveReuse",{"$f":"IF(CreditType=4,[1]Application!$M365=\"Yes\",[1]Application!$M358=\"Yes\")","v":false}]
["t_IsRehabOnly",{"$f":"IF(CreditType=4,[1]Application!$M366=\"Yes\",[1]Application!$M359=\"Yes\")","v":false}]
["t_IsAcqAndRehab",{"$f":"IF(CreditType=4,[1]Application!$M367=\"Yes\",[1]Application!$M360=\"Yes\")","v":false}]
["t_IsBoosted"]
["t_IsBoostedPartial"]
["t_StateCreditType"]
["t_FederalCreditElection"]
["t_MaximumElectionAMI"]
["t_HousingType",{"$f":"IF(CreditType=4,[1]Application!$D$211,[1]Application!$D$214)","v":"(select one)"}]
["t_RequiresSecondaryHousingType",{"$f":"IF(CreditType=4,AND(B181=\"Special Needs\",[1]Application!$T$212<75%),AND(B181=\"Special Needs\",([1]Application!$V$215<75%)))","v":false}]
["t_SecondaryHousingType",{"$f":"IF(CreditType=4,[1]Application!$D$214,[1]Application!$E$217)","v":"N/A"}]
["t_SetAside",{"$f":"IF(CreditType=4,\"N/A\",[1]Application!$D$211)","v":"N/A"}]
["t_SpecialNeedsPercentage",{"$f":"IF(CreditType=4,[1]Application!$T$212,[1]Application!$V$215)","v":0}]
["t_AppStage"]
["t_FederalCreditFactor",{"$f":"IF(CreditType=4,'[1]Basis & Credits'!$AB$50,'[1]Basis & Credits'!$AB$49)","v":0}]
["t_StateCreditFactor",{"$f":"IF(CreditType=4,'[1]Basis & Credits'!$AB$72,'[1]Basis & Credits'!$AB$70)","v":0}]
[null,"Points Info"]
["t_HasServiceCoordinator",{"$f":"IF(CreditType=4,OR('[1]Points System'!$C$394=\"Yes\",'[1]Points System'!$C$455=\"Yes\"),OR('[1]Points System'!$C$389=\"Yes\",'[1]Points System'!$C$454=\"Yes\"))","v":false}]
["t_HasCaseManager",{"$f":"IF(CreditType=4,'[1]Points System'!$C$443=\"Yes\",'[1]Points System'!$C$442=\"Yes\")","v":false}]
["t_HasOtherServiceSpecialist",{"$f":"IF(CreditType=4,OR('[1]Points System'!$C$402=\"Yes\",'[1]Points System'!$C$455=\"Yes\"),OR('[1]Points System'!$C$454=\"Yes\",'[1]Points System'!$C$399=\"Yes\"))","v":false}]
["t_PointsAddlHousingType",{"$f":"IF(CreditType=4,OR('[1]Points System'!$B$26=\"Yes\",'[1]Points System'!$B$187=\"Large Family\",'[1]Points System'!$B$187=\"Special Needs\",'[1]Points System'!$B$187=\"Senior\",'[1]Points System'!$B$187=\"SRO\"),'[1]Points System'!$AK$68>0)","v":false}]
[]
["t_AvgAMITarget",{"$f":"IF(CreditType=4,[1]Application!$AC$761,[1]Application!$AH$738)","v":0}]

{"sheet":"Lists","index":12,"n_rows":44,"n_cols":46,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Don't delete or insert columns or rows",null,null,null,null,null,"ü","IsTrue",null,null,null,"M",{"$f":"ROW(#REF!)","v":{"$error":"#REF!"}},{"$f":"ROW(#REF!)","v":{"$error":"#REF!"}},null,null,null,"ProviderContacts",null,null,null,null,null,null,null,null,null,"ListProviders",null,"ListReferences",null,"GPs","Parent Co","ParentOrNA","LSQoptions","Type",null,"ListManagementCo",null,null,null,"SC1Parcels","SC2Parcels","SC3Parcels","SC4Parcels","SC5Parcels"]
[null,null,null,null,null,null,"û","IsFalse","Row Starts",null,null,1,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L2&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L2&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,"Company Name","Contact","Title","Email","Phone","Provider","R-Provider","Reference","R-Reference",null,null,null,null,null,{"$f":"IF(CreditType=4,[1]Application!$M$252,[1]Application!$M$245)","v":0},{"$f":"IF(CreditType=4,[1]Application!$AA$258,[1]Application!$AA$251)","v":0},{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"No parent company entered\",GeneralPartners[[#This Row],[Parent Co]])","v":"No parent company entered"},{"$f":"IF(CreditType=4,[1]Application!$M$252,[1]Application!$M$245)","v":0},"General Partner",null,{"$f":"IF(CreditType=4,[1]Application!$AA$344,[1]Application!$AA$329)","v":0}]
[null,null,null,null,null,null,null,null,"Column",null,null,2,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L3&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L3&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(1:1),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(1:1),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,{"$f":"IF(CreditType=4,[1]Application!$M$260,[1]Application!$M$253)","v":0},{"$f":"IF(CreditType=4,[1]Application!$AA$266,[1]Application!$AA$259)","v":0},{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"No parent company entered\",GeneralPartners[[#This Row],[Parent Co]])","v":"No parent company entered"},{"$f":"IF(CreditType=4,[1]Application!$M$260,[1]Application!$M$253)","v":0},"General Partner",null,{"$f":"IF(CreditType=4,IF([1]Application!$P$343=\"\",\"\",[1]Application!$P$343),IF([1]Application!$AA$337=\"\",\"\",[1]Application!$AA$337))","v":""}]
[null,null,null,null,null,null,null,"YesNoNa",null,null,null,3,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L4&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L4&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(2:2),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(2:2),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,{"$f":"IF(CreditType=4,[1]Application!$M$268,[1]Application!$M$261)","v":0},{"$f":"IF(CreditType=4,[1]Application!$AA$274,[1]Application!$AA$267)","v":0},{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"No parent company entered\",GeneralPartners[[#This Row],[Parent Co]])","v":"No parent company entered"},{"$f":"IF(CreditType=4,[1]Application!$M$268,[1]Application!$M$261)","v":0},"General Partner"]
[null,null,null,null,null,null,null,"Yes",null,null,null,4,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L5&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L5&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(3:3),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(3:3),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,{"$f":"_xlfn.CONCAT(IF(CreditType=4,[1]Application!$H$296,[1]Application!$H$289)&\"- Tribal Applicants Only\")","v":"- Tribal Applicants Only"},null,{"$f":"IF(OR(GeneralPartners[[#This Row],[Parent Co]]=\"\",GeneralPartners[[#This Row],[Parent Co]]=0),\"N/A - Developer Entity\",GeneralPartners[[#This Row],[Parent Co]])","v":"N/A - Developer Entity"},{"$f":"IF(CreditType=4,[1]Application!$H$296,[1]Application!$H$289)","v":0},"Developer"]
[null,null,null,null,null,null,null,"No",null,null,null,5,{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L6&\"'!\"&$L$1&M$1),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'Site Control \"&$L6&\"'!\"&$L$1&N$1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(4:4),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(4:4),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_TCACApplicant\",ref,0))","v":0},"Applicant"]
[null,null,null,null,null,null,null,"NA",null,null,null,"SiteControlTotalCost",{"$f":"SUM(M2:M6)","v":0},{"$f":"SUM(N2:N6)","v":0},"HoldingTotalCost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(5:5),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(5:5),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,null,null,null,{"$f":"IF(CreditType=4,[1]Application!$AA$304,[1]Application!$AA$297)","v":0},"General Contractor"]
[null,null,null,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(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(6:6),ProviderContactsTbl[R-Provider],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(ProviderContactsTbl[Company Name],MATCH(ROW(6:6),ProviderContactsTbl[R-Reference],0)),\"\")","v":""},null,null,null,null,{"$f":"IF(CreditType=4,[1]Application!$AA$344,[1]Application!$AA$329)","v":0},"Property Management Company"]
[null,null,null,null,null,null,null,"ListAgreementTypes","ListAppraisalRequired",null,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(CreditType=4,[1]Application!$P$352,[1]Application!$AA$337)","v":0},"Property Management Company (Secondary)"]
[null,null,null,null,null,null,null,"Grant Deed",false]
[null,null,null,null,null,null,null,"Lease Agreement",true]
[null,null,null,null,null,null,null,"Purchase and Sales Agreement",false]
[null,null,null,null,null,null,null,"Purchase Option Agreement",false]
[null,null,null,null,null,null,null,"Lease Option",true]
[null,null,null,null,null,null,null,"Disposition and Development Agreement",true]
[null,null,null,null,null,null,null,"Donation Agreement",true]
[]
[]
[null,null,null,null,null,null,null,"ListDocumentTypes"]
[null,null,null,null,null,null,null,"Amends"]
[null,null,null,null,null,null,null,"Assigns"]
[null,null,null,null,null,null,null,"Authorizes"]
[null,null,null,null,null,null,null,"Clarifies"]
[null,null,null,null,null,null,null,"Expounds"]
[null,null,null,null,null,null,null,"Extends"]
[null,null,null,null,null,null,null,"Restates"]
[null,null,null,null,null,null,null,"Site Control"]
[null,null,null,null,null,null,null,"Supports"]
[null,null,null,null,null,null,null,"Title Information"]
[]
[null,null,null,null,null,null,null,"ListCostDocTypes"]
[null,null,null,null,null,null,null,"Site Control Document"]
[null,null,null,null,null,null,null,"Settlement Statement"]
[null,null,null,null,null,null,null,"Appraisal"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(val,MATCH(\"g_County\",ref,0))","v":"(select one)"},"County"]
[null,null,null,null,null,null,null,"CountyRow"]
[]
[null,null,null,null,null,null,null,"LowIncomeUnits"]
[null,null,null,null,null,null,null,"TotalUnits"]
[]
[null,null,null,null,null,null,null,"ListCreditType"]
[null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,0.09]