{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Macro Instructions","Section A","Section B","Section C","Save and Upload","FileMaker Format","Administrators"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"Macro Instructions","index":0,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,2,36,13],[0,8,1,13]]}
[null,null,null,null,null,null,null,null,"Impact Fund Household Demographic/ Project Information Form\nMacro Instructions"]
[]
[]
[null,null,"Please enable macros prior to completing this form.\n\nTo enable Macros in Excel:\n\n1. In Excel 2000 or 2003:\n      - Navigate to the 'Tools' tab > 'Macro' > Security\n      - Select an appropriate setting to allow completion of this form.\n\n2. In Excel 2007:\n      - Click on the 'Office' button.\n      - Click on 'Excel Options'\n      - Select 'Trust Center' > 'Trust Center Settings'. Choose a  security setting (see explanation of Macro Settings below).\n\n3. In Excel 2010 or 2013:\n      - Navigate to the 'File' Tab > 'Options'\n      - Click on 'Trust Center' > Trust Center Settings'\n      - Click on 'Macro Settings'. Choose a security setting (see explanation of Macro Settings below).\n     -  Check the box 'Trust access to the VBA project object model'\n\nExplanation of Macro (Security) Settings in Excel 2007, 2010 and 2013:\n\n1. Disable all macros without notification: Blocks all macros without notifying the user.\n2. Disable all macros with notification: RECOMMENDED WHEN COMPLETING THIS WORKSHEET: Macros are disabled, but when you open a workbook Excel will ask whether you want to run the macro.\n\n\n3. Disable all macros except digitally signed macros: Same as #2 above, except that macros are automatically allowed if they're signed by trusted publishers. (The macros in this worksheet are not digitally signed.)\n4. Enable all macros (not recommended, potentially dangerous code can run): Not recommended; will allow all macros to run without prompting the user.\n\nWhen saving, please save as a Macro-enabled Workbook.\n\n\n\n"]

{"sheet":"Section A","index":1,"n_rows":101,"n_cols":30,"rows_kept":101,"cut":false,"hidden":false,"merged":[[51,13,51,14],[16,13,16,14],[17,13,17,14],[9,9,9,13],[24,13,24,14],[25,13,25,14],[42,13,42,14],[31,11,31,12],[47,13,47,14],[48,13,48,14],[48,9,48,11],[47,9,47,11],[50,13,50,14],[47,2,47,4],[32,17,33,17],[31,6,31,8],[41,13,41,14],[42,2,42,4],[45,13,45,14],[44,13,44,14],[44,2,44,4],[32,14,33,14],[31,2,31,4],[42,9,42,10],[38,13,38,14],[39,13,39,14],[24,2,24,4],[27,2,27,4],[44,9,44,11],[38,2,38,4],[41,2,41,4],[41,9,41,11],[39,9,39,10],[24,6,24,7],[27,6,27,7],[38,9,38,11],[1,7,1,18],[2,2,2,17],[16,6,16,7],[19,6,19,7],[6,9,6,13],[6,6,6,7],[6,2,6,4],[9,2,9,4],[13,4,13,6],[16,2,16,4],[19,2,19,4],[9,6,9,7]]}
[]
[null,null,null,null,null,null,null,"Community Homeownership Impact Fund \n(Impact Fund) Program                                                                                                                                           Household Demographic/Project Information Form"]
[null,null,"Instructions:  Please complete this Household Demographic/Project Information Form for each Project completed under an Impact Fund Award.  Complete both Section A, Section B and Section C, save the form, then use Minnesota Housing's Secure File Upload tool to submit this form to the Impact Fund team at impact.fund.mhfa@state.mn.us. You can find Instructions and a link to the Secure Upload tool on Section B of this form, and on Minnesota Housing's website.  You can find much of the information needed to fill out this form from the following documents: the Settlement Statement (e.g., HUD-1) or Closing Disclosure, the Uniform Residential Appraisal Report, Borrower's Application, and your Impact Fund  Agreement or Contract. This form must not be modified without advance, specific written authorization from Minnesota Housing.  \n\nContact the Impact Fund team at impact.fund.mhfa@state.mn.us with any questions or concerns. "]
[]
[null,"Administrator Information"]
[]
[null,null,"Administrator's  Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,"Click to Select"]
[null,null,"Administrator's  Name",null,null,null,"Award ID#",null,null,"Contact Person",null,null,null,null,null,null,null,null,null,null,null,"Male ",null,"Married"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Female",null,"Separated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chose not to identify",null,"Not Married (Includes Single, Divorced, Widowed)"]
[null,null,"Administrator's Address",null,null,null,"Phone Number",null,null,"Contact Person's Email Address",null,null,null,null,null,null,null,"Date Form Completed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select"]
[null,"Activity Type",null,null,"Click to Select",null,null,"Is borrower receiving a deferred loan (to be) assigned to Minnesota Housing?",null,null,null,null,null,null,null,null,null,"Click to Select",null,null,"Yes"]
[null,"Household Demographic Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,"Click to Select",null,null,"MN","Aitkin"]
[null,null,"Primary borrower, homebuyer or homeowner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chose not to identify",null,null,null,null,"Yes",null,null,"AK","Anoka"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,null,"No",null,null,"AL","Becker"]
[null,null,"Borrower Last Name",null,null,null,"Borrower's First Name",null,null,"MI",null,null,null,"Borrower's Gender",null,null,null,"Borrower's Date of Birth",null,null,null,null,null,null,null,null,null,null,"AR","Beltrami"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ","Benton"]
[null,null,null,null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA","Big Stone"]
[null,null,"Borrower's Social Security #",null,null,null,"Borrower's Marital Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO","Blue Earth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CT","Brown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE","Carlton"]
[null,null,"Co-borrower, spouse of the primary borrower who also occupies the Property, or an additonal homebuyer or homeowner, if any:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL","Carver"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA","Cass"]
[null,null,"Coborrower Last Name",null,null,null,"Coborrower's First Name",null,null,"MI",null,null,null,"Coborrower's Gender",null,null,null,"Coborrower's Date of Birth",null,null,null,null,null,null,null,null,null,null,"HI","Chippewa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,"Click to Select",null,"Click to Select",null,null,"IA","Chisago"]
[null,null,null,null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupied ",null,"Site Built",null,"Condominium",null,null,"ID","Clay"]
[null,null,"Coborrower's Social Security #",null,null,null,"Coborrower's Marital Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vacant",null,"Manufactured",null,"Community Land Trust",null,null,"IL","Clearwater"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modular",null,"Contract for Deed",null,null,"IN","Cook"]
[null,null,"Household:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract for Title",null,null,"KS","Cottonwood"]
[null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fee Simple",null,null,"KY","Crow Wing"]
[null,null,"Gross Annual Household Income",null,null,null,"Previous City of Residence ",null,null,"State",null,"Disability?",null,null,"Number of Residents Over Age 18 ",null,null,"Number of Residents Under Age 18",null,null,null,"Visitability Elements",null,"Click to Select",null,"Tribal Trust/Allotted",null,null,"LA","Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No-Step",false,"Single Family",null,null,null,null,"MA","Dodge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32-in Doors",false,"Duplex",null,"Click to Select",null,null,"MD","Douglas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main floor bath",false,"Triplex",null,"Minnesota Housing Start Up",null,null,"ME","Faribault"]
[null,"Property and Unit Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quad",null,"Minnesota Housing Step Up",null,null,"MI","Fillmore"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",null,"FHA",null,null,"MN","Freeborn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,"Click to Select",null,"Townhome",null,"Conventional",null,null,"MO","Goodhue"]
[null,null,"Property Address",null,null,null,"City ",null,null,"Zip Code",null,null,null,"County",null,null,null,"Type of 1st Position Mortgage / Financing on Property",null,null,null,"New Construction",null,"Accessory Dwelling",null,"VA",null,null,"MS","Grant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing",null,"Manufactured Home Taxed as Personal Property",null,"USDA",null,null,"MT","Hennepin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Manufactured home Taxed as Real Property",null,"Tribal Indian Housing Program",null,null,"NC","Houston"]
[null,null,"Year Property Built",null,null,null,"Number of Units",null,null,"Bedrooms",null,null,null,"Square Footage",null,null,null,"1st Position Mortgage / Financing Amount",null,null,null,null,null,null,null,"Contract for Deed",null,null,"ND","Hubbard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract for Title",null,null,"NE","Isanti"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,0,null,null,null,null,null,null,null,"Other",null,null,"NH","Itasca"]
[null,null,"Date of Closing",null,null,null,"Appraised Value",null,null,"Purchase Price",null,null,null,"Ownership Type",null,null,null,"Settlement Charges to Borrower",null,null,null,null,null,null,null,"None",null,null,"NJ","Jackson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM","Kanabec"]
[null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV","Kandiyohi"]
[null,null,"Borrower Phone",null,null,null,"Coborrower Phone",null,null,"Structure Type",null,null,null,"Construction Type",null,null,null,"Housing ratio ",null,null,null,null,null,null,null,null,null,null,"NY","Kittson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH","Koochiching"]
[null,null,"Visitability: Please indicate which of the following Visitability elements the Property contains, if known:",null,null,null,null,null,null,null,null,null,null,"Click to Select",null,null,null,"Click to Select",null,null,null,null,null,null,null,null,null,null,"OK","Lac Qui Parle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prevailing Wage applied?",null,null,null,"Property Type",null,null,null,null,null,null,null,null,null,null,"OR","Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA","Lake of the Woods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tribal Indian Housing Program First Mortgage Sources",null,null,null,null,null,null,null,null,null,null,null,null,null,"RI","Le Sueur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN Housing Impact Fund",null,null,null,null,null,null,null,null,null,null,null,null,null,"SC","Lincoln"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,"SD","Lyon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ",null,null,{"$f":"SUM(R55:R56)","v":0},null,null,null,null,null,null,null,null,null,null,"TN","McLeod"]
[null,null,{"$f":"C7&\"_\"&G7&\"_\"&C17","v":"Administrator's  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,"TX","Mahnomen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v. 5.27.21",null,null,null,null,null,null,null,null,null,"UT","Marshall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA","Martin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A'!R10),\"\",\"Form completed \"& TEXT('Section A'!R10,\"MM/DD/YYYY\"))","v":""},null,null,null,null,null,null,null,null,null,"VT","Meeker"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA","Mille Lacs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI","Morrison"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV","Mower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY","Murray"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR","Nicollet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC","Nobles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-US","Norman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Olmsted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otter Tail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pennington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipestone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ramsey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Redwood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roseau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saint Louis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scott"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sherburne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sibley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stearns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steele"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stevens"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swift"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traverse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wabasha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wadena"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waseca"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watonwan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilkin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winona"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wright"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow Medicine"]

{"sheet":"Section B","index":2,"n_rows":278,"n_cols":32,"rows_kept":278,"cut":false,"hidden":false,"merged":[[66,8,66,9],[43,7,44,7],[43,8,44,8],[3,3,3,4],[19,2,19,3],[58,2,58,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3]]}
[]
[null,null,"Unit Development Costs and Leverage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to Select","New Construction","Acquisition, Rehab, Resale","Stand-Alone Affordability Gap","Owner-Occupied Rehab","Tribal Indian Housing Program"]
[null,null,"Activity Type",{"$f":"IF('Section A'!E14=\"Click to Select\",\"Please select in Section A\",'Section A'!E14)","v":"Please select in Section A"},null,null,null,"Owner Occupied Rehab (OOR (Only))",null,null,null,null,null,"Click to Select","CDBG - Federal Government","City Government","County Government","Developer","Employer","Family Housing Fund","Federal Home Loan Bank","Foundation","Gift Funds","GMHF","HUD - Federal Government","Local Federal Government","Metropolitan Council","State - Non-MHFA","Bank/Lender","Private Loan - Owner/Developer","RD - Federal Government","Third-Party Seller"]
["Applies?",null,null,null,null,null,null,"Accessibility",0,null,null,null,null,"Click to Select","DEED Small Cities","CDBG - Federal Government","City Government","County Government","Foundation","GMHF","RD - Federal Government","Other State Funds - Non-MHFA","Gift Funds","Bank/Lender","Federal Home Loan Bank"]
[{"$f":"IFERROR(INDEX(field_lookup,MATCH($C6,$N$9:$N$28,0),MATCH($D$4,$N$9:$P$9,0)),\"\")","v":""},null,"Land Acquisition Costs",null,0,null,null,"Site Work",0]
[{"$f":"IFERROR(INDEX(field_lookup,MATCH($C7,$N$9:$N$28,0),MATCH($D$4,$N$9:$P$9,0)),\"\")","v":""},null,"Structure Acquisition Costs",null,0,null,null,"Building Envelope",0,null,null,null,null,"This table is used to determine which hard costs apply to the selected activity type. This is referenced in Column A."]
[{"$f":"IFERROR(INDEX(field_lookup,MATCH($C8,$N$9:$N$28,0),MATCH($D$4,$N$9:$P$9,0)),\"\")","v":""},null,"General Construction",null,0,null,null,"Electrical",0,null,null,null,null,"Enter Y for applicable fields:"]
["",null,"Site Work",null,0,null,null,"Garage",0,null,null,null,null,"Hard Cost/Activity","New Construction","Acquisition, Rehab, Resale"]
["",null,"Demolition Costs",null,0,null,null,"Heating,  Vent., & Air Conditioning",0,null,null,null,null,"Land Acquisition Costs","Y","Y"]
["",null,"Garage",null,0,null,null,"Interior Finishing",0,null,null,null,null,"Property Acquisition Costs","Y","Y"]
["",null,"Visitability",null,0,null,null,"Interior Remodel Alterations",0,null,null,null,null,"General Construction","Y","N"]
["",null,"Accessibility ",null,0,null,null,"Plumbing",0,null,null,null,null,"Site Work","Y","Y"]
["",null,"Building Envelope",null,0,null,null,"Lead-Related Work",0,null,null,null,null,"Demolition Costs","Y","N"]
["",null,"Electrical",null,0,null,null,"Weatherization",0,null,null,null,null,"Garage","Y","Y"]
["",null,"Lead-Related Work",null,0,null,null,"Windows",0,null,null,null,null,"Visitability","Y","N"]
["",null,"Plumbing",null,0,null,null,"Other Hard Costs",0,null,null,null,null,"Accessibility ","N","Y"]
["",null,"Interior Remodel/Alteration",null,0,null,null,"Total Hard Costs",{"$f":"SUM(I5:I17)","v":0},null,null,null,null,"Building Envelope","N","Y"]
["",null,"Interior Finishing",null,0,null,null,null,null,null,null,null,null,"Electrical","N","Y"]
["",null,"Heating,  Vent., & Air Conditioning",null,0,null,null,"Administration Fee",0,null,null,null,null,"Lead-Related Work","N","Y"]
["",null,"Windows ",null,0,null,null,"Other Professional Fees",0,null,null,null,null,"Plumbing","N","Y"]
["",null,"Weatherization",null,0,null,null,"Total Soft Costs",{"$f":"SUM(I20:I21)","v":0},null,null,null,null,"Heating and Ventilation","N","Y"]
["",null,"Other Hard Costs",null,0,null,null,null,null,null,null,null,null,"Interior Remodel/Alteration","N","Y"]
[null,null,"Total Hard Costs",null,{"$f":"SUM(E6:E23)","v":0},null,null,"Total OOR Costs",{"$f":"I18+I22","v":0},null,null,null,null,"Interior Finishing","N","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Heating,  Vent., & Air Conditioning","N","Y"]
[null,null,"Soft Costs",null,null,null,null,null,null,null,null,null,null,"Windows ","N","Y"]
[null,null,"Holding Costs",null,0,null,null,"Owner Occupied Rehab Sources",null,null,null,null,null,"Weatherization","N","Y"]
[null,null,"Developer Fee",null,0,null,null,"Minnesota Housing Impact Fund",0,null,null,null,null,"Other Hard Costs","Y","Y"]
[null,null,"Realtor Fees",null,0,null,null,"Homeowner's Own Funds",0]
[null,null,"Other Professional Fees",null,0,null,null,"Click to Select",0]
[null,null,"Total Soft Costs",null,{"$f":"SUM(E27:E30)","v":0},null,null,"Click to Select",0,null,null,null,null,"Column A (hidden) contains a formula for the conditional formatting in cells C6:E23"]
[null,null,null,null,null,null,null,"Click to Select",0]
[null,null,"Total Development Costs",null,{"$f":"E24+E31","v":0},null,null,"Minnesota Housing Fix Up Fund",0]
[null,null,null,null,null,null,null,"Minnesota Housing RLP/ELP",0,null,null,null,null,"Payment Number","Payment","Principal","Interest","Balance"]
[null,null,"Total Value Gap Need",null,{"$f":"IF((E33-'Section A'!J45)<0,0,E33-'Section A'!J45)","v":0},null,null,"Total  OOR Sources",{"$f":"IF(SUM(I28:I34)>I24*1.01,\"MUST EQUAL NEED; Current Sum $\"&SUM(I28:I34),IF(SUM(I28:I34)<I24*0.99,\"MUST EQUAL NEED; Current Sum $\"&SUM(I28:I34),SUM(I28:I34)))","v":0},null,null,null,null,1,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N35,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N35,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"$I$40+P35","v":{"$error":"#NUM!"}}]
[null,null,"Total Affordability Gap Need",null,{"$f":"IF(('Section A'!J45 -'Section A'!R42+'Section A'!R45)<0,0,'Section A'!J45 -'Section A'!R42+'Section A'!R45)","v":0},null,null,null,null,null,null,null,null,2,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"R35+P36","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"R36+P37","v":{"$error":"#NUM!"}}]
[null,null,"Value Gap Sources ",null,null,null,null,"Community Fix Up Loan Interest Rate ",null,null,null,null,null,4,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Minnesota Housing Impact Fund",null,0,null,null,"Writedown (Only)",null,null,null,null,null,5,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Minnesota Housing Bond Proceeds",null,0,null,null,"CFUL Loan Amount",0,null,null,null,null,6,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,"Percentage Points Discounted",0,null,null,null,null,7,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,"Resulting CFUL Mortgage Rate",0,null,null,null,null,8,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,"CFUL Term (months)",0,null,null,null,null,9,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,"Discount Amount: Impact Fund Grant Funds used",0,null,null,null,null,10,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Total Value Gap",null,{"$f":"IF(SUM(E39:E44)>E35+0.01,\"MUST EQUAL NEED; Current Sum $\"&SUM(E39:E44),IF(SUM(E39:E44)<E35-0.01,\"MUST EQUAL NEED; Current Sum $\"&SUM(E39:E44),SUM(E39:E44)))","v":0},null,null,null,null,null,null,null,null,11,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,"Disount Amount: Other Sources",0,null,null,null,null,12,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Affordability Gap Sources",null,null,null,null,"Total Discount Amount",{"$f":"I44+I46","v":0},null,null,null,null,13,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Minnesota Housing Impact Fund",null,0,null,null,null,null,null,null,null,null,14,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Minnesota Housing Bond Proceeds",null,0,null,null,null,null,null,null,null,null,15,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Minnesota Housing DPA",null,0,null,null,null,null,null,null,null,null,16,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Borrower's Own Funds",null,0,null,null,null,null,null,null,null,null,17,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,null,null,null,null,null,null,18,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,null,null,null,null,null,null,19,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Click to Select",null,0,null,null,null,null,null,null,null,null,20,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Total Affordability Gap ",null,{"$f":"IF(SUM(E48:E54)>E36+0.01,\"MUST EQUAL NEED; Current Sum $\"&SUM(E48:E54),IF(SUM(E48:E54)<E36-0.01,\"MUST EQUAL NEED; Current Sum $\"&SUM(E48:E54),SUM(E48:E54)))","v":0},null,null,null,null,null,null,null,null,21,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Admin Fee from Grant Funds",null,0,null,null,null,null,null,null,null,null,22,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Construction Financing ",null,null,null,null,null,null,null,null,null,null,23,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Minnesota Housing Impact Funds",null,0,null,null,null,null,null,null,null,null,24,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"<Enter Other Source (if any) Here>",null,0,null,null,null,null,null,null,null,null,25,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Total Construction Financing",null,{"$f":"SUM(E58:E59)","v":0},null,null,null,null,null,null,null,null,26,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N62,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N62,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"R60+P62","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N63,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N63,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N66,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N66,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"R63+P66","v":{"$error":"#NUM!"}}]
[null,null,"*Grey text indicates that the category is not applicable for the activity type*",null,null,null,null,null,"v. 5.27.21",null,null,null,null,30,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,{"$f":"'Section A'!C7&\"_\"&'Section A'!G7&\"_\"&'Section A'!C17","v":"Administrator's  Name__"},null,null,null,null,null,null,{"$f":"IF(ISBLANK('Section A'!R10),\"\",\"Form completed \"& TEXT('Section A'!R10,\"MM/DD/YYYY\"))","v":""},null,null,null,32,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,51,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,52,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,53,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,54,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,55,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,56,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,57,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,58,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,59,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,60,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,61,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,62,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,63,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,64,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,65,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,67,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"R103+P104","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,68,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,69,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,70,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,71,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,72,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,73,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,74,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,75,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,76,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,77,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,78,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,79,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,80,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,81,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,82,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,83,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,84,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,85,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,86,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,87,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,88,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,89,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,90,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,91,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,92,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,93,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N130,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N130,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,94,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,95,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,96,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,97,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,98,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,99,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,100,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,101,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,102,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,103,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,104,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,105,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,106,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,107,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,108,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,109,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,110,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,111,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,112,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,113,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,114,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,117,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,118,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,119,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,121,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,122,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,123,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,124,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"R167+P168","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,133,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,134,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,135,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,136,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,137,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,138,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,139,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,140,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,141,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,142,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,143,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,144,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,145,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,146,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,147,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,148,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,149,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,150,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,151,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,152,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,153,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,154,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,155,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,156,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,157,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N194,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N194,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,158,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,159,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,160,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,161,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,162,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,163,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,164,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,165,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,166,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,167,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,168,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,169,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,170,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,171,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,172,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,173,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,174,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,175,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,176,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,177,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,178,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,179,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,180,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,181,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,182,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,183,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,184,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,185,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,186,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,187,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,188,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,189,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,190,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,191,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,192,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,193,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,194,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,195,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"R231+P232","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,196,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,197,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,198,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,199,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,200,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,201,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,202,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,203,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,204,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,205,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,206,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,207,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,208,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,209,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,210,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,211,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,212,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,213,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,214,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,215,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,216,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,217,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,218,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,219,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,220,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,221,{"$f":"PMT($I$41/12,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"PPMT($I$41/12,N258,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$f":"IPMT($I$41/12,N258,$I$43,$I$40,0)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,222,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,223,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,224,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,225,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,226,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,227,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,228,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,229,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,230,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,231,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,232,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,233,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,234,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,235,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,236,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,237,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,238,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,239,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,240,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"SUMIF(O35:O277,\"<>#NUM!\",O35:O277)","v":0},{"$f":"SUMIF(P35:P277,\"<>#NUM!\",P35:P277)","v":0},{"$f":"SUMIF(Q35:Q277,\"<>#NUM!\",Q35:Q277)","v":0},{"$f":"0","v":0}]

{"sheet":"Section C","index":3,"n_rows":85,"n_cols":29,"rows_kept":85,"cut":false,"hidden":false,"merged":[[11,6,11,9],[76,4,76,9],[26,4,26,9],[41,4,41,9],[54,4,54,9],[64,4,64,9],[76,14,76,19],[11,16,11,19],[26,14,26,19],[41,14,41,19],[54,14,54,19],[64,14,64,19]]}
[]
["Borrower's Race and Ethnicity",null,null,null,null,null,"Page 1",null,null,null,"CoBorrower's Race and Ethnicity",null,null,null,null,null,"Page 1",null,null,null,null,"Borrower Race","Co Race","Borrower Ethnicity","Co Ethnicity","Borrower Specify","Co Specify","Borrower SubCat","Co SubCat"]
["(Select as many of the categories and subcategories that apply)",null,null,null,null,null,null,null,null,null,"(Select as many of the categories and subcategories that apply)",null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(X5,Z5,X6,Z6,X17,Z17,X30,Z30,X48,Z48,X58,Z58,X68)","v":""},{"$f":"CONCATENATE(Y5,AA5,Y6,AA6,Y17,AA17,Y30,AA30,Y48,AA48,Y58,AA58,Y68)","v":""},{"$f":"CONCATENATE(X9,Z9,X10,Z10,X11,Z11,X20,Z20,X23,Z23,X24,Z24,X25,Z25,X26,Z26,X28,Z28,X33,Z33,X34,Z34,X35,Z35,X36,Z36,X37,Z37,X38,Z38,X39,Z39,X40,Z40,X41,Z41,X43,Z43,X51,Z51,X52,Z52,X53,Z53,X54,Z54,X56,Z56,X61,Z61,X62,Z62,X63,Z63,X64,Z64,X66,Z66,X72,Z72,X73,Z73,,X74,Z74,X75,Z75,X76,Z76,X78)","v":""},{"$f":"CONCATENATE(Y9,AA9,Y10,AA10,Y11,AA11,Y20,AA20,Y23,AA23,Y24,AA24,Y25,AA25,Y26,AA26,Y28,AA28,Y33,AA33,Y34,AA34,Y35,AA35,Y36,AA36,Y37,AA37,Y38,AA38,Y39,AA39,Y40,AA40,Y41,AA41,Y43,AA43,Y51,AA51,Y52,AA52,Y53,AA53,Y54,AA54,Y56,AA56,Y61,AA61,Y62,AA62,Y63,AA63,Y64,AA64,Y66,AA66,Y72,AA72,Y73,AA73,,Y74,AA74,Y75,AA75,Y76,AA76,Y78)","v":""},{"$f":"CONCATENATE(X12,Z12,X27,Z27,X42,Z42,X55,Z55,X65,Z65,X77)","v":""},{"$f":"CONCATENATE(Y12,AA12,Y27,AA27,Y42,AA42,Y55,AA55,Y65,AA65,Y77)","v":""},{"$f":"CONCATENATE(X13,Z13,X14,Z14,X15)","v":""},{"$f":"CONCATENATE(Y13,AA13,Y14,AA14,Y15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Race / Ethnicity","Borrower checked?","CoBorrower checked?","Borrower Label Checked?","Co Borrower Label Checked?","Borrower Comma","CoBorrower Comma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose not to identify",false,false,{"$f":"IF(V5=TRUE,$U5,\"\")","v":""},{"$f":"IF(W5=TRUE,$U5,\"\")","v":""},{"$f":"IF(AND(V5=TRUE,OR(V$6=TRUE,V$17=TRUE,V$30=TRUE,V$48=TRUE,V$58=TRUE,V$68=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W5=TRUE,OR(W$6=TRUE,W$17=TRUE,W$30=TRUE,W$48=TRUE,W$58=TRUE,W$68=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"American Indian / Alaska Native",false,false,{"$f":"IF(V6=TRUE,$U6,\"\")","v":""},{"$f":"IF(W6=TRUE,$U6,\"\")","v":""},{"$f":"IF(AND(V6=TRUE,OR(V$17=TRUE,V$30=TRUE,V$48=TRUE,V$58=TRUE,V$68=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W6=TRUE,OR(W$17=TRUE,W$30=TRUE,W$48=TRUE,W$58=TRUE,W$68=TRUE)),\", \",\"\")","v":""}]
[null,null,"(people having origins in any of the original people of North, Central or South America)",null,null,null,null,null,null,null,null,null,"(people having origins in any of the original people of North, Central or South America)"]
[null,null," – select all subcategories that apply:",null,null,null,null,null,null,null,null,null," – select all subcategories that apply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anishinaabe / Ojibwe",false,false,{"$f":"IF(V9=TRUE,$U9,\"\")","v":""},"",{"$f":"IF(AND(V9=TRUE,OR(V$10=TRUE,V$11=TRUE,V$20=TRUE,V$23=TRUE,V$24=TRUE,V$25=TRUE,V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W9=TRUE,OR(W$10=TRUE,W$11=TRUE,W$20=TRUE,W$23=TRUE,W$24=TRUE,W$25=TRUE,W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dakota / Lakota",false,false,"","",{"$f":"IF(AND(V10=TRUE,OR(V$11=TRUE,V$20=TRUE,V$23=TRUE,V$24=TRUE,V$25=TRUE,V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W10=TRUE,OR(W$11=TRUE,W$20=TRUE,W$23=TRUE,W$24=TRUE,W$25=TRUE,W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,"","Other North American Indian Tribal Affiliation",false,false,"","",{"$f":"IF(AND(V11=TRUE,OR(V$20=TRUE,V$23=TRUE,V$24=TRUE,V$25=TRUE,V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W11=TRUE,OR(W$20=TRUE,W$23=TRUE,W$24=TRUE,W$25=TRUE,W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"Please specify enrolled or principal tribe:",null,null,null,null,null,null,null,null,null,"Please specify enrolled or principal tribe:",null,null,null,null,null,null,null,null,{"$f":"IF('Section C'!G12<>\"\",TRUE,FALSE)","v":false},{"$f":"IF('Section C'!Q12<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(V12=TRUE,G12,\"\")","v":""},{"$f":"IF(W12=TRUE,Q12,\"\")","v":""},{"$f":"IF(AND(V12=TRUE,OR(V$27=TRUE,V$42=TRUE,V$55=TRUE,V$65=TRUE,V$77=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W12=TRUE,OR(W$27=TRUE,W$42=TRUE,W$55=TRUE,W$65=TRUE,W$77=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central American Indian",false,false,{"$f":"IF(V13=TRUE,$U13,\"\")","v":""},"",{"$f":"IF(AND(V13=TRUE,OR(V$14=TRUE,V$15=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W13=TRUE,OR(W$14=TRUE,W$15=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South American Indian",false,false,"","",{"$f":"IF(AND(V14=TRUE,OR(V$15=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W14=TRUE,OR(W$15=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown (American Indian / Alaska Native)",false,false,"",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Black / African-American",false,false,{"$f":"IF(V17=TRUE,$U17,\"\")","v":""},{"$f":"IF(W17=TRUE,$U17,\"\")","v":""},{"$f":"IF(AND(V17=TRUE,OR(V$30=TRUE,V$48=TRUE,V$58=TRUE,V$68=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W17=TRUE,OR(W$30=TRUE,W$48=TRUE,W$58=TRUE,W$68=TRUE)),\", \",\"\")","v":""}]
[null,null,"(people having origins in any of the black racial groups of Africa)",null,null,null,null,null,null,null,null,null,"(people having origins in any of the black racial groups of Africa)"]
[null,null," – select all subcategories that apply:",null,null,null,null,null,null,null,null,null," – select all subcategories that apply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"African American",false,false,{"$f":"IF(V20=TRUE,$U20,\"\")","v":""},{"$f":"IF(W20=TRUE,$U20,\"\")","v":""},{"$f":"IF(AND(V20=TRUE,OR(V$23=TRUE,V$24=TRUE,V$25=TRUE,V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W20=TRUE,OR(W$23=TRUE,W$24=TRUE,W$25=TRUE,W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"(often referring to black individuals whose families have been in the country for ",null,null,null,null,null,null,null,null,null,"(often referring to black individuals whose families have been in the country for "]
[null,null,"generations and are often descendants of enslaved people)",null,null,null,null,null,null,null,null,null,"generations and are often descendants of enslaved people)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V22=TRUE,#REF!,\"\")","v":""},{"$f":"IF(W22=TRUE,#REF!,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somali",false,false,{"$f":"IF(V23=TRUE,$U23,\"\")","v":""},{"$f":"IF(W23=TRUE,$U23,\"\")","v":""},{"$f":"IF(AND(V23=TRUE,OR(V$24=TRUE,V$25=TRUE,V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W23=TRUE,OR(W$24=TRUE,W$25=TRUE,W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethiopian",false,false,{"$f":"IF(V24=TRUE,$U24,\"\")","v":""},{"$f":"IF(W24=TRUE,$U24,\"\")","v":""},{"$f":"IF(AND(V24=TRUE,OR(V$25=TRUE,V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W24=TRUE,OR(W$25=TRUE,W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liberian",false,false,"","",{"$f":"IF(AND(V25=TRUE,OR(V$26=TRUE,V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W25=TRUE,OR(W$26=TRUE,W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,"","Other Black / African American",false,false,"","",{"$f":"IF(AND(V26=TRUE,OR(V$28=TRUE,V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W26=TRUE,OR(W$28=TRUE,W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"Please specify origin: ",null,null,null,null,null,null,null,null,null,"Please specify origin: ",null,null,null,null,null,null,null,null,{"$f":"IF('Section C'!E27<>\"\",TRUE,FALSE)","v":false},{"$f":"IF('Section C'!O27<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(V27=TRUE,E27,\"\")","v":""},{"$f":"IF(W27=TRUE,O27,\"\")","v":""},{"$f":"IF(AND(V27=TRUE,OR(V$42=TRUE,V$55=TRUE,V$65=TRUE,V$77=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W27=TRUE,OR(W$42=TRUE,W$55=TRUE,W$65=TRUE,W$77=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown (Black / African-American)",false,false,{"$f":"IF(V28=TRUE,$U28,\"\")","v":""},{"$f":"IF(W28=TRUE,$U28,\"\")","v":""},{"$f":"IF(AND(V28=TRUE,OR(V$33=TRUE,V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W28=TRUE,OR(W$33=TRUE,W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asian",false,false,{"$f":"IF(V30=TRUE,$U30,\"\")","v":""},{"$f":"IF(W30=TRUE,$U30,\"\")","v":""},{"$f":"IF(AND(V30=TRUE,OR(V$48=TRUE,V$58=TRUE,V$68=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W30=TRUE,OR(W$48=TRUE,W$58=TRUE,W$68=TRUE)),\", \",\"\")","v":""}]
[null,"(people having origins in the Far East, Southeast Asia or the Indian subcontinents)",null,null,null,null,null,null,null,null,null,"(people having origins in the Far East, Southeast Asia or the Indian subcontinents)"]
[null," – select all subcategories that apply:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V32=TRUE,#REF!,\"\")","v":""},{"$f":"IF(W32=TRUE,#REF!,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hmong",false,false,{"$f":"IF(V33=TRUE,$U33,\"\")","v":""},{"$f":"IF(W33=TRUE,$U33,\"\")","v":""},{"$f":"IF(AND(V33=TRUE,OR(V$34=TRUE,V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W33=TRUE,OR(W$34=TRUE,W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asian Indian",false,false,"","",{"$f":"IF(AND(V34=TRUE,OR(V$35=TRUE,V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W34=TRUE,OR(W$35=TRUE,W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chinese",false,false,"","",{"$f":"IF(AND(V35=TRUE,OR(V$36=TRUE,V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W35=TRUE,OR(W$36=TRUE,W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vietnamese",false,false,"","",{"$f":"IF(AND(V36=TRUE,OR(V$37=TRUE,V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W36=TRUE,OR(W$37=TRUE,W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korean",false,false,"","",{"$f":"IF(AND(V37=TRUE,OR(V$38=TRUE,V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W37=TRUE,OR(W$38=TRUE,W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lao",false,false,"","",{"$f":"IF(AND(V38=TRUE,OR(V$39=TRUE,V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W38=TRUE,OR(W$39=TRUE,W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filipino",false,false,"","",{"$f":"IF(AND(V39=TRUE,OR(V$40=TRUE,V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W39=TRUE,OR(W$40=TRUE,W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Japanese",false,false,"","",{"$f":"IF(AND(V40=TRUE,OR(V$41=TRUE,V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W40=TRUE,OR(W$41=TRUE,W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,"","Other Asian",false,false,"","",{"$f":"IF(AND(V41=TRUE,OR(V$43=TRUE,V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W41=TRUE,OR(W$43=TRUE,W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"Please specify origin: ",null,null,null,null,null,null,null,null,null,"Please specify origin:",null,null,null,null,null,null,null,null,{"$f":"IF('Section C'!E42<>\"\",TRUE,FALSE)","v":false},{"$f":"IF('Section C'!O42<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(V42=TRUE,E42,\"\")","v":""},{"$f":"IF(W42=TRUE,O42,\"\")","v":""},{"$f":"IF(AND(V42=TRUE,OR(V$55=TRUE,V$65=TRUE,V$77=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W42=TRUE,OR(W$55=TRUE,W$65=TRUE,W$77=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown (Asian)",false,false,{"$f":"IF(V43=TRUE,$U43,\"\")","v":""},{"$f":"IF(W43=TRUE,$U43,\"\")","v":""},{"$f":"IF(AND(V43=TRUE,OR(V$51=TRUE,V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W43=TRUE,OR(W$51=TRUE,W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[]
["Borrower's Race and Ethnicity",null,null,null,null,null,"Page 2",null,null,null,"CoBorrower's Race and Ethnicity",null,null,null,null,null,"Page 2"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pacific Islander",false,false,{"$f":"IF(V48=TRUE,$U48,\"\")","v":""},{"$f":"IF(W48=TRUE,$U48,\"\")","v":""},{"$f":"IF(AND(V48=TRUE,OR(V$58=TRUE,V$68=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W48=TRUE,OR(W$58=TRUE,W$68=TRUE)),\", \",\"\")","v":""}]
[null,"(people having origins in Hawaii, Guam, Samoa or other Pacific islands)",null,null,null,null,null,null,null,null,null,"(people having origins in Hawaii, Guam, Samoa or other Pacific islands)"]
[null," – select all subcategories that apply:",null,null,null,null,null,null,null,null,null," – select all subcategories that apply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Hawaiian",false,false,{"$f":"IF(V51=TRUE,$U51,\"\")","v":""},{"$f":"IF(W51=TRUE,$U51,\"\")","v":""},{"$f":"IF(AND(V51=TRUE,OR(V$52=TRUE,V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W51=TRUE,OR(W$52=TRUE,W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guamanian / Chamorro",false,false,"","",{"$f":"IF(AND(V52=TRUE,OR(V$53=TRUE,V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W52=TRUE,OR(W$53=TRUE,W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Samoan",false,false,"","",{"$f":"IF(AND(V53=TRUE,OR(V$54=TRUE,V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W53=TRUE,OR(W$54=TRUE,W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,"","Other Pacific Islander",false,false,"","",{"$f":"IF(AND(V54=TRUE,OR(V$56=TRUE,V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W54=TRUE,OR(W$56=TRUE,W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"Please specify origin:",null,null,null,null,null,null,null,null,null,"Please specify origin:",null,null,null,null,null,null,null,null,{"$f":"IF('Section C'!E55<>\"\",TRUE,FALSE)","v":false},{"$f":"IF('Section C'!O55<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(V55=TRUE,E55,\"\")","v":""},{"$f":"IF(W55=TRUE,O55,\"\")","v":""},{"$f":"IF(AND(V55=TRUE,OR(V$65=TRUE,V$77=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W55=TRUE,OR(W$65=TRUE,W$77=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown (Pacific Islander)",false,false,{"$f":"IF(V56=TRUE,$U56,\"\")","v":""},{"$f":"IF(W56=TRUE,$U56,\"\")","v":""},{"$f":"IF(AND(V56=TRUE,OR(V$61=TRUE,V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W56=TRUE,OR(W$61=TRUE,W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",false,false,{"$f":"IF(V58=TRUE,$U58,\"\")","v":""},{"$f":"IF(W58=TRUE,$U58,\"\")","v":""},{"$f":"IF(AND(V58=TRUE,OR(V$68=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W58=TRUE,OR(W$68=TRUE)),\", \",\"\")","v":""}]
[null," (people having origins in Europe, Middle East or North Africa, excluding black racial groups)",null,null,null,null,null,null,null,null,null," (people having origins in Europe, Middle East or North Africa, excluding black racial groups)"]
[null," – select all subcategories that apply:",null,null,null,null,null,null,null,null,null," – select all subcategories that apply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"European",false,false,{"$f":"IF(V61=TRUE,$U61,\"\")","v":""},{"$f":"IF(W61=TRUE,$U61,\"\")","v":""},{"$f":"IF(AND(V61=TRUE,OR(V$62=TRUE,V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W61=TRUE,OR(W$62=TRUE,W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Middle Eastern",false,false,"","",{"$f":"IF(AND(V62=TRUE,OR(V$63=TRUE,V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W62=TRUE,OR(W$63=TRUE,W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North African",false,false,"","",{"$f":"IF(AND(V63=TRUE,OR(V$64=TRUE,V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W63=TRUE,OR(W$64=TRUE,W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,"","Other White",false,false,"","",{"$f":"IF(AND(V64=TRUE,OR(V$66=TRUE,V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W64=TRUE,OR(W$66=TRUE,W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"Please specify origin:           ",null,null,null,null,null,null,null,null,null,"Please specify origin:           ",null,null,null,null,null,null,null,null,{"$f":"IF('Section C'!E65<>\"\",TRUE,FALSE)","v":false},{"$f":"IF('Section C'!O65<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(V65=TRUE,E65,\"\")","v":""},{"$f":"IF(W65=TRUE,O65,\"\")","v":""},{"$f":"IF(AND(V65=TRUE,OR(V$77=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W65=TRUE,OR(W$77=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown (White)",false,false,{"$f":"IF(V66=TRUE,$U66,\"\")","v":""},{"$f":"IF(W66=TRUE,$U66,\"\")","v":""},{"$f":"IF(AND(V66=TRUE,OR(V$72=TRUE,V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W66=TRUE,OR(W$72=TRUE,W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hispanic / Latinx / Spanish Origin",false,false,{"$f":"IF(V68=TRUE,$U68,\"\")","v":""},{"$f":"IF(W68=TRUE,$U68,\"\")","v":""}]
[null,"(people of Mexican, Puerto Rican, Cuban, South or Central American, or other Spanish culture ",null,null,null,null,null,null,null,null,null,"(people of Mexican, Puerto Rican, Cuban, South or Central American, or other Spanish culture "]
[null,"or origin, regardless of race)",null,null,null,null,null,null,null,null,null,"or origin, regardless of race)"]
[null," – select all subcategories that apply:",null,null,null,null,null,null,null,null,null," – select all subcategories that apply:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mexican / Mexican American / Chicano",false,false,{"$f":"IF(V72=TRUE,$U72,\"\")","v":""},{"$f":"IF(W72=TRUE,$U72,\"\")","v":""},{"$f":"IF(AND(V72=TRUE,OR(V$73=TRUE,V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W72=TRUE,OR(W$73=TRUE,W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puerto Rican",false,false,"","",{"$f":"IF(AND(V73=TRUE,OR(V$74=TRUE,V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W73=TRUE,OR(W$74=TRUE,W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuban",false,false,"","",{"$f":"IF(AND(V74=TRUE,OR(V$75=TRUE,V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W74=TRUE,OR(W$75=TRUE,W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spaniard / Spanish / Spanish American",false,false,"","",{"$f":"IF(AND(V75=TRUE,OR(V$76=TRUE,V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W75=TRUE,OR(W$76=TRUE,W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Hispanic / Latinx",false,false,"","",{"$f":"IF(AND(V76=TRUE,OR(V$78=TRUE)),\", \",\"\")","v":""},{"$f":"IF(AND(W76=TRUE,OR(W$78=TRUE)),\", \",\"\")","v":""}]
[null,null,"Please specify origin:           ",null,null,null,null,null,null,null,null,null,"Please specify origin:           ",null,null,null,null,null,null,null,null,{"$f":"IF('Section C'!E77<>\"\",TRUE,FALSE)","v":false},{"$f":"IF('Section C'!O77<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(V77=TRUE,'Section C'!E77,\"\")","v":""},{"$f":"IF(W77=TRUE,O77,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown (Hispanic / Latinx / Spanish Origin)",false,false,{"$f":"IF(V78=TRUE,$U78,\"\")","v":""},{"$f":"IF(W78=TRUE,$U78,\"\")","v":""}]
[]
["[INTERNAL MINNESOTA HOUSING NOTE:",null,null,null,null,null,null,null,null,null,"[INTERNAL MINNESOTA HOUSING NOTE:"]
["Subpopulations are individually listed if they are either a separate check box on the Census ",null,null,null,null,null,null,null,null,null,"Subpopulations are individually listed if they are either a separate check box on the Census "]
["Bureau’s American Community Survey or identified as a cultural group in Minnesota from ",null,null,null,null,null,null,null,null,null,"Bureau’s American Community Survey or identified as a cultural group in Minnesota from "]
["an analysis from the State Demographer’s Office.  We also disaggregated the white population.]",null,null,null,null,null,null,null,null,null,"an analysis from the State Demographer’s Office.  We also disaggregated the white population.]"]
[]
[null,null,null,null,null,null,null,null,null,"v. 5.27.21"]

{"sheet":"Save and Upload","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[4,1,4,3],[4,5,4,8]]}
["When saving and sending this form, please use the format \"Administrator_Award ID_Borrower Last Name\", or click the \"Save Form\" button below.\n\n\n\n"]
["Important! You must maintain documentation to support all information submitted through this form. It is your responsibility to ensure all information submitted to Minnesota Housing is accurate and complete. Minnesota Housing reserves the right to test all information submitted for compliance with the Loan/Grant Agreement."]
[]
[]
[null,"Secure File Upload ",null,null,null,"Secure File Upload Instructions"]

{"sheet":"FileMaker Format","index":5,"n_rows":2,"n_cols":140,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["32 Door","Accessibility","Accessibility ARR","Acquisition","Activity Type","Admin Name","Affordability Gap","Agreement ID#","Appraised Value of Unit","Bath on Main Level","Bond Proceeds","Borrower DOB","Borrower Ethnicity","Borrower Ethnicity Specify","Borrower Ethnicity SubCat","Borrower First Name","Borrower Gender","Borrower Last Name","Borrower Marital Status","Borrower MI","Borrower Phone","Borrower Race","Borrower SS","Building Envelope ARR","Co Ethnicity","Co Ethnicity Specify","Co Ethnicity SubCat","Co First Name","Co Gender","Co Last Name","Co Marital Status","Co MI","Co Race","Co SS","Coborrower DOB","CoBorrower Phone","Construction Type","Date Form Completed","Date of Closing","Date of Entry","Demolition","Devel Admin Fee Taken","Disability HH","Electrical","Electrical ARR","Energy Conservation","Energy Conservation ARR","First Mortgage Funds","First Mortgage Funds1","First Mortgage Source","First Mortgage Source1","FU/CFU IR write-down","Garage","Garage ARR","Garage NC","General Construction NC","Gross Household Income","Hard Costs Other","Hard Costs Other NC","Heating","Heating Ven AC ARR","Holding Costs","Housing Ratio","Interim Constr Financing","Interior Finishing","Interior Finishing ARR","Interior Remodel/Alterations","Interior Remodel/Alterations ARR","Lead Related Work","Lead Related Work ARR","Marketing Realtor","Miscellaneous","No Step","Non MHFA Funds 1A","Non MHFA Funds 1V","Non MHFA Funds 2A","Non MHFA Funds 2V","Non MHFA Funds 3A","Non MHFA Funds 3V","Non MHFA Funds 4A","Non MHFA Funds 4V","Non MHFA Funds Source 1","Non MHFA Funds Source 2","Non MHFA Funds Source 3","Non MHFA Funds Source 4","Non MHFA Funds Source 5","Non MHFA Funds Source 6","Non MHFA Funds Source 7","Non MHFA Funds Source 8","Non MHFA Int Constr Fin Funds","Non MHFA Interim Constr Fin Source","Non MHFA OOR Funds 1","Non MHFA OOR Funds 2","Non MHFA OOR Funds 3","Non MHFA OOR Funds 4","Non MHFA OOR Source 1","Non MHFA OOR Source 2","Non MHFA OOR Source 3","Non MHFA OOR Source 4","Number Adults","Number Bedrooms","Number Children","Number of Units","Other Developer fee soft costs","Other MHFA Funds 1A","Other MHFA Funds 2A","Other MHFA Funds 3A","Other MHFA Funds Source 1","Other MHFA Funds Source 2","Other MHFA Funds Source 3","Other Prof'l Fees","Owner Occupied Rehab","Ownership Type","Plumbing","Plumbing ARR","Prevailing Wage Applied?","Previous City Residence","Previous State Residence","Programs","Property Acquisition ARR","Property City","Property County","Property Street Address","Property Type","Property Zip Code","Purchase (sales) Price of Unit","Round","Settlement Charge to Borr","Site Work","Site Work ARR","Site Work NC","Square Footage","Structural Additions Alterations","Structure Type","Tribal First Mtg","Value Gap","Visitability NC","Windows","Windows ARR","Year Property Built"]
[{"$f":"IF('Section A'!W35=TRUE,\"Yes\",\"\")","v":""},{"$f":"'Section B'!I5","v":0},{"$f":"'Section B'!E13","v":0},{"$f":"IF('Section B'!D4<>\"Acquisition, Rehab, Resale\",'Section B'!E6+'Section B'!E7,0)","v":0},{"$f":"IF('Section A'!E14=\"Click to Select\",\"\",'Section A'!E14)","v":""},{"$f":"IF(ISBLANK('Section A'!C7),\"\",'Section A'!C7)","v":"Administrator's  Name"},{"$f":"'Section B'!E48","v":0},{"$f":"IF(ISBLANK('Section A'!G7),\"\",'Section A'!G7)","v":""},{"$f":"'Section A'!G45","v":0},{"$f":"IF('Section A'!W36=TRUE,\"Yes\",\"\")","v":""},{"$f":"'Section B'!E49+'Section B'!E40","v":0},{"$f":"IF(ISBLANK('Section A'!R17),\"\",'Section A'!R17)","v":""},{"$f":"'Section C'!X3","v":""},{"$f":"IF(ISBLANK('Section C'!Z3),\"\",'Section C'!Z3)","v":""},{"$f":"IF(ISBLANK('Section C'!AB3),\"\",'Section C'!AB3)","v":""},{"$f":"IF(ISBLANK('Section A'!G17),\"\",'Section A'!G17)","v":""},{"$f":"IF(OR(ISBLANK('Section A'!N17),'Section A'!N17=\"Click to Select\"),\"\",'Section A'!N17)","v":""},{"$f":"IF(ISBLANK('Section A'!C17),\"\",'Section A'!C17)","v":""},{"$f":"IF(OR(ISBLANK('Section A'!G20),'Section A'!G20=\"Click to Select\"),\"\",'Section A'!G20)","v":""},{"$f":"IF(ISBLANK('Section A'!J17),\"\",'Section A'!J17)","v":""},{"$f":"IF(ISBLANK('Section A'!C48),\"\",'Section A'!C48)","v":""},{"$f":"IF(ISBLANK('Section C'!V3),\"\",'Section C'!V3)","v":""},{"$f":"IF(ISBLANK('Section A'!C20),\"\",'Section A'!C20)","v":""},{"$f":"'Section B'!E14","v":0},{"$f":"IF(ISBLANK('Section C'!Y3),\"\",'Section C'!Y3)","v":""},{"$f":"IF(ISBLANK('Section C'!AA3),\"\",'Section C'!AA3)","v":""},{"$f":"IF(ISBLANK('Section C'!AC3),\"\",'Section C'!AC3)","v":""},{"$f":"IF(ISBLANK('Section A'!G25),\"\",'Section A'!G25)","v":""},{"$f":"IF(OR(ISBLANK('Section A'!N25),'Section A'!N25=\"Click to Select\"),\"\",'Section A'!N25)","v":""},{"$f":"IF(ISBLANK('Section A'!C25),\"\",'Section A'!C25)","v":""},{"$f":"IF(OR(ISBLANK('Section A'!G28),'Section A'!G28=\"Click to Select\"),\"\",'Section A'!G28)","v":""},{"$f":"IF(ISBLANK('Section A'!J25),\"\",'Section A'!J25)","v":""},{"$f":"IF(ISBLANK('Section C'!W3),\"\",'Section C'!W3)","v":""},{"$f":"IF(ISBLANK('Section A'!C28),\"\",'Section A'!C28)","v":""},{"$f":"IF(ISBLANK('Section A'!R25),\"\",'Section A'!R25)","v":""},{"$f":"IF(ISBLANK('Section A'!G48),\"\",'Section A'!G48)","v":""},{"$f":"IF('Section A'!N48=\"Click to Select\",\"\",'Section A'!N48)","v":""},{"$f":"IF(ISBLANK('Section A'!R10),\"\",'Section A'!R10)","v":""},{"$f":"IF(ISBLANK('Section A'!C45),\"\",'Section A'!C45)","v":""},{"$f":"NOW()","v":"2026-03-20T10:18:11.910"},{"$f":"'Section B'!E10","v":0},{"$f":"'Section B'!E56","v":0},{"$f":"IF('Section A'!L32=\"Click to Select\",\"\",'Section A'!L32)","v":""},{"$f":"'Section B'!I8","v":0},{"$f":"'Section B'!E15","v":0},{"$f":"'Section B'!I15","v":0},{"$f":"'Section B'!E22","v":0},{"$f":"IF('Section A'!R55=0,'Section A'!R42,'Section A'!R55)","v":0},{"$f":"IF('Section A'!R55>0,'Section A'!R56,\"\")","v":""},{"$f":"IF('Section A'!R39=\"Click to Select\",\"\",IF('Section A'!R55>0,\"Impact Fund\",'Section A'!R39))","v":""},{"$f":"IF(AND('Section A'!R55>0,'Section A'!R56>0),\"Other\",\"\")","v":""},{"$f":"IF(ISBLANK('Section B'!I44),\"\",'Section B'!I44)","v":0},{"$f":"'Section B'!I9","v":0},{"$f":"IF('Section B'!D4=\"Acquisition, Rehab, Resale\",'Section B'!E11,\"\")","v":""},{"$f":"IF('Section B'!$D$4<>\"Acquisition, Rehab, Resale\",'Section B'!E11,\"\")","v":0},{"$f":"IF('Section B'!$D$4<>\"Acquisition, Rehab, Resale\",'Section B'!E8,\"\")","v":0},{"$f":"'Section A'!C32","v":0},{"$f":"IF('Section B'!$D$4=\"Acquisition, Rehab, Resale\",'Section B'!E23,\"\")","v":""},{"$f":"IF('Section B'!$D$4<>\"Acquisition, Rehab, Resale\",'Section B'!E23,\"\")","v":0},{"$f":"'Section B'!I10","v":0},{"$f":"'Section B'!E20","v":0},{"$f":"'Section B'!E27","v":0},{"$f":"IF(ISBLANK('Section A'!R48),\"\",'Section A'!R48)","v":""},{"$f":"'Section B'!E58","v":0},{"$f":"'Section B'!I11","v":0},{"$f":"'Section B'!E19","v":0},{"$f":"'Section B'!I12","v":0},{"$f":"'Section B'!E18","v":0},{"$f":"'Section B'!I14","v":0},{"$f":"'Section B'!E16","v":0},{"$f":"'Section B'!E29","v":0},{"$f":"'Section B'!I17","v":0},{"$f":"IF('Section A'!W34=TRUE,\"Yes\",\"\")","v":""},{"$f":"'Section B'!E51","v":0},{"$f":"'Section B'!E41","v":0},{"$f":"'Section B'!E52","v":0},{"$f":"'Section B'!E42","v":0},{"$f":"'Section B'!E53","v":0},{"$f":"'Section B'!E43","v":0},{"$f":"'Section B'!E54","v":0},{"$f":"'Section B'!E44","v":0},{"$f":"IF(AND('Section B'!C41=\"Click to Select\",'Section B'!E41>0),\"Unknown\",IF(AND('Section B'!C41=\"Click to Select\",'Section B'!E41=0),\"\",'Section B'!C41))","v":""},{"$f":"IF(AND('Section B'!C42=\"Click to Select\",'Section B'!E42>0),\"Unknown\",IF(AND('Section B'!C42=\"Click to Select\",'Section B'!E42=0),\"\",'Section B'!C42))","v":""},{"$f":"IF(AND('Section B'!C43=\"Click to Select\",'Section B'!E43>0),\"Unknown\",IF(AND('Section B'!C43=\"Click to Select\",'Section B'!E43=0),\"\",'Section B'!C43))","v":""},{"$f":"IF(AND('Section B'!C44=\"Click to Select\",'Section B'!E44>0),\"Unknown\",IF(AND('Section B'!C44=\"Click to Select\",'Section B'!E44=0),\"\",'Section B'!C44))","v":""},{"$f":"IF('Section B'!E51>0,\"Homeowner\",\"\")","v":""},{"$f":"IF(AND('Section B'!E52>0,'Section B'!C52=\"Click to Select\"),\"Unknown\",IF(AND('Section B'!E52=0,'Section B'!C52=\"Click to Select\"),\"\",'Section B'!C52))","v":""},{"$f":"IF(AND('Section B'!E53>0,'Section B'!C53=\"Click to Select\"),\"Unknown\",IF(AND('Section B'!E53=0,'Section B'!C53=\"Click to Select\"),\"\",'Section B'!C53))","v":""},{"$f":"IF(AND('Section B'!E54>0,'Section B'!C54=\"Click to Select\"),\"Unknown\",IF(AND('Section B'!E54=0,'Section B'!C54=\"Click to Select\"),\"\",'Section B'!C54))","v":""},{"$f":"'Section B'!E59","v":0},{"$f":"IF('Section B'!C59<>\"<Enter Other Source (if any) Here>\",'Section B'!C59,\"\")","v":""},{"$f":"'Section B'!I29","v":0},{"$f":"'Section B'!I30","v":0},{"$f":"'Section B'!I31","v":0},{"$f":"'Section B'!I32","v":0},{"$f":"IF(CN2>0,\"Homeowner\",\"\")","v":""},{"$f":"IF('Section B'!H30=\"Click to Select\",\"\",'Section B'!H30)","v":""},{"$f":"IF('Section B'!H31=\"Click to Select\",\"\",'Section B'!H31)","v":""},{"$f":"IF('Section B'!H32=\"Click to Select\",\"\",'Section B'!H32)","v":""},{"$f":"'Section A'!O32","v":0},{"$f":"'Section A'!J42","v":0},{"$f":"'Section A'!R32","v":0},{"$f":"'Section A'!G42","v":0},{"$f":"'Section B'!E28+'Section B'!I20+'Section B'!E56","v":0},{"$f":"'Section B'!E50","v":0},{"$f":"IF('Section B'!I33>0,'Section B'!I33,IF('Section B'!I40>0,'Section B'!I40,\"\"))","v":""},{"$f":"IF('Section B'!I34>0,'Section B'!I34,\"\")","v":""},{"$f":"IF('Section B'!E50>0,\"MHFA DPA\",\"\")","v":""},{"$f":"IF(OR('Section B'!I33>0,'Section B'!I40>0),\"Fix Up/CFUL\",\"\")","v":""},{"$f":"IF('Section B'!I34>0,\"RLP/ELP\",\"\")","v":""},{"$f":"'Section B'!E30+'Section B'!I21","v":0},{"$f":"'Section B'!I28","v":0},{"$f":"IF(OR('Section A'!N45=\"Click to Select\",ISBLANK('Section A'!N45)),\"\",'Section A'!N45)","v":""},{"$f":"'Section B'!I13","v":0},{"$f":"'Section B'!E17","v":0},{"$f":"IF('Section A'!N51=\"Click to Select\",\"\",'Section A'!N51)","v":""},{"$f":"IF(ISBLANK('Section A'!G32),\"\",'Section A'!G32)","v":""},{"$f":"IF('Section A'!J32=\"Select\",\"\",'Section A'!J32)","v":0},null,{"$f":"IF('Section B'!D4=\"Acquisition, Rehab, Resale\",'Section B'!E6+'Section B'!E7,0)","v":0},{"$f":"IF(ISBLANK('Section A'!G39),\"\",'Section A'!G39)","v":""},{"$f":"IF(ISBLANK('Section A'!N39),\"\",'Section A'!N39)","v":""},{"$f":"IF(ISBLANK('Section A'!C39),\"\",'Section A'!C39)","v":""},{"$f":"IF('Section A'!R51=\"Click to Select\",\"\",'Section A'!R51)","v":""},{"$f":"IF(ISBLANK('Section A'!J39),\"\",'Section A'!J39)","v":""},{"$f":"'Section A'!J45","v":0},{"$f":"CHOOSE(MONTH(LEFT(H2,2)*29),\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\")&\" \"&(MID(H2,4,4))","v":{"$error":"#VALUE!"}},{"$f":"'Section A'!R45","v":0},{"$f":"'Section B'!I6","v":0},{"$f":"IF('Section B'!D4=\"Acquisition, Rehab, Resale\",'Section B'!E9, \"\")","v":""},{"$f":"IF('Section B'!D4=\"New Construction\",'Section B'!E9,\"\")","v":""},{"$f":"IF(ISBLANK('Section A'!N42),\"\",'Section A'!N42)","v":""},{"$f":"'Section B'!I7","v":0},{"$f":"IF('Section A'!J48=\"Click to Select\",\"\",'Section A'!J48)","v":""},{"$f":"'Section A'!R55","v":0},{"$f":"'Section B'!E39","v":0},{"$f":"IF('Section B'!D4=\"New Construction\",'Section B'!E12,\"\")","v":""},{"$f":"'Section B'!I16","v":0},{"$f":"'Section B'!E21","v":0},{"$f":"IF(ISBLANK('Section A'!C42),\"\",'Section A'!C42)","v":""}]

{"sheet":"Administrators","index":6,"n_rows":94,"n_cols":1,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
[]
["Age Well at Home"]
["Alexandria HRA"]
["Amani Construction & Development "]
["American Indian Dev Corp (AICDC)"]
["Anoka County CAP"]
["Anoka HRA"]
["Arrowhead EOA"]
["Bi-County CAP"]
["Bloomington HRA"]
["Bluff County HRA"]
["Brainerd HRA"]
["Build Wealth MN Inc"]
["Carver County CDA "]
["Carver County HRA"]
["Cass Clay Community Land Trust"]
["Center for Energy & Environment"]
["Central MN Habitat for Humanity"]
["City of Big Lake"]
["City of Lakes Community Land Trust"]
["City of Mankato"]
["City of Minneapolis CPED"]
["City of Moorhead"]
["City of St James"]
["City of Thief River Falls"]
["City of Winona"]
["Community Neighborhood Housing Services"]
["Dakota County CDA"]
["Dayton's Bluff NHS"]
["Duluth HRA"]
["Edina Housing and Redevelopment Authority"]
["Family Housing Fund"]
["First Homes Properties"]
["GMMHC"]
["Golden Valley HRA"]
["Greater Metropolitan Housing Corporation"]
["Habitat for Humanity of Minnesota"]
["Headwaters HDC"]
["Headwaters RDC"]
["Hennepin County HRA"]
["Historic Saint Paul"]
["Housing and Redevelopment Authority of Itasca County"]
["Hutchinson HRA"]
["Itasca HRA"]
["Josh Hanson"]
["Lake Agassiz Habitat for Humanity"]
["Lakes and Pines Community Action"]
["Leech Lake Band of Ojibwe"]
["Leech Lake Development Corporation"]
["Lower Sioux Indian Community"]
["Lyndale Boulevard Development Company LLC"]
["Mankato Economic Development Authority"]
["Midwest Minnesota Community Development Corp"]
["Minnesota Valley Action Council"]
["Model Cities CDC/MCASA"]
["Neighborhood Development Alliance"]
["Northcountry CF"]
["Northside Home LLC"]
["North Star Neighbors"]
["NW Community Action"]
["NW MN Foundation"]
["One Roof Community Housing"]
["Otter Tail Housing and Redevelopment Authority"]
["OtterTail County CDA"]
["Park Plaza Cooperative"]
["Partnership Community Land Trust"]
["Perham HRA"]
["PPL Homes LLC"]
["PRG Inc"]
["Project for Pride in Living"]
["Rebuilding Together Twin Cities"]
["Red Lake Housing Finance Corporation"]
["Red Lake HRA"]
["Richfield HFA"]
["Richfield HRA"]
["Robert Engstrom Capital Management LLC"]
["Rondo Community Land Trust"]
["Saint Paul HRA"]
["Scott County Community Development Agency"]
["Semcac"]
["SW MN Housing Partnership"]
["Three Rivers Community Action"]
["Twin Cities Community Land Bank"]
["Twin Cities Habitat for Humanity"]
["Twin Cities Habitat for Humanity Lending"]
["Two Rivers Community Land Trust"]
["United Community Action Partnership"]
["Upper Sioux of MN Indian Housing Authority"]
["Urban Homeworks"]
["W Hennepin Affordable Housing Land Trust"]
["Washington County CDA"]
["West Central MN CA"]
["White Earth Reservation Housing Authority"]
["White Earth Reservation Tribal Council"]