{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","1. Chklst, Certification","2. Assisted","3. Non-Assisted","4. Commercial Space","5. Summary","6. State Income Limits Chart"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":95,"n_cols":1,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,0,3,5],[4,0,4,5],[2,0,2,5],[93,0,93,4],[86,0,86,5],[82,0,82,5],[56,0,56,5],[60,0,60,5],[58,0,58,5],[46,0,46,5],[92,0,92,5],[45,0,45,5],[30,0,30,5],[32,0,32,5],[34,0,34,5],[94,0,94,5],[88,0,88,5],[72,0,72,5],[53,0,53,5],[70,0,70,5],[68,0,68,5],[76,0,76,5],[78,0,78,5],[80,0,80,5],[62,0,62,5],[64,0,64,5],[66,0,66,5],[90,0,90,5],[84,0,84,5],[73,0,73,1],[67,0,67,5],[20,0,20,5],[39,0,39,5],[29,0,29,5],[35,0,35,5],[37,0,37,5],[36,0,36,5],[31,0,31,5],[33,0,33,5],[38,0,38,5],[21,0,21,5],[23,0,23,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[11,0,11,5],[19,0,19,5],[12,0,12,5],[13,0,13,5],[14,0,14,2],[16,0,16,3],[18,0,18,5],[15,0,15,5],[17,0,17,5],[9,0,9,5],[10,0,10,5],[8,0,8,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[63,0,63,5],[50,0,50,5],[41,0,41,5],[48,0,48,5],[44,0,44,5],[43,0,43,5],[51,0,51,5],[47,0,47,5],[49,0,49,5],[61,0,61,5],[40,0,40,5],[42,0,42,5],[22,0,22,5],[24,0,24,5],[28,0,28,5],[52,0,52,5],[54,0,54,5],[55,0,55,5],[57,0,57,5],[59,0,59,5],[87,0,87,5],[91,0,91,3],[89,0,89,1],[65,0,65,5],[75,0,75,5],[77,0,77,5],[71,0,71,5],[74,0,74,5],[69,0,69,5],[83,0,83,5],[79,0,79,5],[81,0,81,5]]}
["ASSET MANAGEMENT AND COMPLIANCE SECTION"]
[{"$f":"'1. Chklst, Certification'!A4","v":"Rev. 4/10/23"}]
["WORKBOOK INSTRUCTIONS FOR THE COMPLETION OF THE MPROP / MPAP "]
["PROGRAM OF ASSISTANCE ANALYSIS CHART  "]
["SCHEDULE OF SPACE / RENT ASSESSMENT  "]
["Workbook Information:  These instructions are written to help you complete and electronically submit the Mobilehome Park Assistance Program (MPAP), and the Mobilehome Park Resident Ownership Program (MPROP) Assistance Analysis Chart and the Schedule of Assessments, form MPAP/MPROP 151.  "]
["The Excel workbook is comprised of five sections.  With the exception of the Instructions and the State Income Limits Chart, each section has its own worksheet.  Enter information on all applicable sections shaded in light yellow for the following tabbed worksheets:  1) Checklist and Certification, 2) Assisted, 3) Non-Assisted, 4) Commercial Space, and 5) Summary."]
["Instructions. If you have questions or concerns after reading or following the instructions below, please contact your Asset Management Representative.  If you do not know who your Representative is, please call (916) 263-2771.  "]
["CHECKLIST, CERTIFICATION AND APPROVAL - Tab #1"]
["A.  General Information:  Note that once the General Information has been entered, it will auto populate cells in the other worksheets.  Please enter the Project MPROP / MPAP  contract number, Park name, Management Company, preparer's name and date prepared.  Use the drop down box to obtain the report's Fiscal Year and the Project's beginning and ending fiscal year.   If the Park's fiscal year is not listed, select \"Other\" and indicate the fiscal year in the space to the right of the drop down box."]
["B.  State Income Limits"]
["Enter the name of the County in which the Park is located."]
["C.  Checklist of Required Items"]
["Items 1 thru 4 must be completed for all projects. Check the boxes to indicate that each worksheet has been completed. "]
["D.  Certification"]
["Select the appropriate radio button once the worksheets are complete and ready for submission.  Read the certification statement and type in the date, name and title of the person who is authorized to sign and certify this report. "]
["E.  Department Approval"]
["Once the HCD has reviewed the worksheets submitted, a representative of the Department will approve the reports by signing and dating the report here and may add comments in the designated area provided."]
["SECTION I - ASSISTED (ASSISTANCE ANALYSIS CHART - ASSISTED UNITS) - Tab #2"]
["Page Headings: The General Information previously entered from the worksheet on Tab #1, Checklist, Certification, and Approval, will auto populate the upper left cells on this worksheet."]
["Rent Adjustment Factor:  Insert the requested Assessment / Rental increase into this space.  The percentage of increase entered should be used to calculate section G - Proposed Monthly Space Assessment on this worksheet."]
["A.  Space Number"]
["Indicate the space number of the household applying to the Park for assessment assistance.  Note that the total number of spaces indicated will appear on the fourth worksheet (Summary of Annual Income) under Assisted Units."]
["B.  Number of Persons in the Household"]
["Indicate the total number of people residing in the mobilehome."]
["C.  Household ID"]
["Enter the Special ID (Tenant Code) that your property management software assigned to the household. If none, assign a Tenant Code to each household. Do not use the tenant's names or SS#."]
["D.  Low Income Limit for this Size Household"]
["The worksheet will automatically input the appropriate household income limit from the table previously completed under Section B - State Income Limits."]
["E.  Household Annual Gross Income"]
["Enter the gross annual income of all the occupants residing in the mobilehome.  Remember, all income must be documented and verified by a third-party entity.  "]
["F.  Household Monthly Gross Income"]
["The worksheet will automatically convert the gross annual income into a monthly figure.  Note that the total monthly gross income will appear on the fourth worksheet (Summary of Annual Income) under as Proposed Total Annual Tenant Rent - Assisted Units."]
["G.  Proposed Monthly Space Assessment"]
["Enter the total of the current space assessment plus the proposed percent increase.  Do not include fees for incidentals such as storage or additional parking space.  NOTE: The total at the bottom of this column (F) will reflect the proposed total monthly space assistance.  This amount should be converted to reflect an annual amount on line 1 (Rent Revenue - Gross Potential / Assisted Units) of the Proposed Cash Flow Analysis when completing the Park's proposed budget report."]
["H.  Monthly Utility / Maintenance "]
["Indicate the monthly average utility (water, gas, electric) and maintenance fee for the household.  Resident maybe required to supply copies of their utility bills to substantiate the monthly amount indicated."]
["I.  Monthly Mobilehome Insurance"]
["Review the resident's mobilehome insurance binder and enter the monthly cost to cover the replacement of the mobilehome if damaged.  Do not include coverage for personal property, extended liability, auto, earthquake, or life insurance.  Flood insurance maybe included if the mobilehome is on a HUD designated flood zone.  "]
["J.  Monthly Registration / Taxes"]
["Review the resident's current mobilehome registration and property tax bill.  Enter the total amount on a monthly basis in this section."]
["K.  Monthly Mobilehome Loan Payment"]
["Obtain from the resident (must be owner occupied) a current monthly statement or bill from their lender.  Enter the monthly payment (excluding any required escrow deposit) in this section."]
["L.  Total Monthly Housing Costs"]
["The worksheet will automatically add columns G - J to indicate the resident's total monthly housing cost.  "]
["M.  Housing Ratio (before assistance)"]
["The worksheet will automatically calculate the resident's total monthly housing costs compared to their monthly income - also known as Housing Ratio."]
["N.  Proposed Monthly Assistance"]
["Indicate the proposed monthly assistance the Park will provide to the household.  The total proposed monthly assistance will appear on the fourth worksheet (Summary of Annual Income) under as Proposed Total Annual Tenant Subsidy - Assisted Units.  Note:  The total monthly assistance on the bottom of this column, (M), should be reflected as a negative annual figure on line 2 (Tenant Assistance Payments) Assisted Units in the Proposed Cash Flow Analysis worksheet.  "]
["O.  Adjusted Housing Ratio (with assistance)"]
["The worksheet will automatically calculate the resident's total adjusted monthly housing costs to their monthly income.  "]
["P.  Comment"]
["Use this section to include any comment or to clarify the amount(s) that was inputted on this Chart or you may use the space at the bottom of the Chart for detailed comments.  "]
["SECTION II - NON-ASSISTED ( UNIT, LOT, RENTAL, SPACE ) - Tab #3"]
["Page Headings. The General Information previously entered from the worksheet on Tab #1, Checklist, Certification, and Approval, will auto populate the cells on this worksheet."]
["A.  Assessment Type"]
["The object of this section is to group all non-assisted types by assessment amount (e.g., 27 Space Assessments at $498.12 per month; 8 RV / Boat rental space at $50 per month).   Using the \"drop-down\" box, select the from the list of assessment type.  As a reminder, only indicate units, lots, rentals, and spaces that are non-assisted.  If \"other\" is selected, please provide an explanation of the assessment in the comments section.  "]
["B.  Current Monthly Assessment"]
["Indicate the current monthly assessment for this assessment type."]
["C.  Number of Rentals"]
["Indicate the number of rental assessment for this assessment type and amount.  Note that the total number of assessment types indicated will appear on the Summary of Annual Income (the fourth worksheet in the Chart) under the Non-Assisted Units."]
["D.  Total Monthly Assessment"]
["The worksheet will calculate the total monthly assessment for all the specific assessment type indicated.  Note that the total monthly assessment for each specific assessment type will appear on the fourth worksheet (Summary of Annual Income) as Total Annual Tenant Rent Non-Assisted Units."]
["E.  Number of Months"]
["Indicate the proposed number of months the assessment type will be charged for the new assessment amount."]
["F.  Total Current Assessment"]
["The worksheet will calculate the total assessment for the time period indicated for the specific type of assessment indicated.  "]
["G.  Proposed Percent Increase"]
["Indicate the percentage of increase proposed for this type of assessment.  Note that the percent increase for each specific assessment type will appear on the Summary of Annual Income (the fourth worksheet in the Chart) as Average Increase Non-Assisted Units."]
["H.  Proposed Total Annual Assessment"]
["The worksheet will automatically calculate the new total assessment for the time period indicated for the specific type of assessment indicated."]
["The subtotals at the bottom of the page are automatic sums of the amounts in the above columns.   "]
["SECTION III - COMMERCIAL SPACE - Tab #4"]
[]
["The General Information previously entered from the worksheet on Tab #1, Checklist, Certification, and Approval, will auto populate the cells on this worksheet."]
["A.  Name of Lessor"]
["Enter the name of the business / service provider in this area."]
["B. Unit Designation or Address"]
["Enter the complete physical address and unit number of the business in this area."]
["C. Type of Business or Other Use"]
["Describe the services provided by this business entity in this area.  "]
["D.  Total Monthly Rent"]
["Enter the proposed monthly rent in this area.  "]
["E.  Number of Months"]
["Enter the total number of months in which the business entity will be renting the space during the budget year here.  "]
["F.  Total Annual Rental Income"]
["From the information entered in columns [D] and [E], the worksheet will automatically calculate the anticipated total annual rental income from the commercial space.  "]
["The amounts from this worksheet will auto-populate to the fourth worksheet in the Chart (Summary of Annual Rental Income) in the section entitled Commercial Space.  "]
["SECTION IV - SUMMARY OF ANNUAL RENTAL INCOME - Tab #5"]
[]
["The General Information previously entered from the worksheet on Tab #1, Checklist, Certification, and Approval, will auto populate the cells on this worksheet."]
["Column Information"]
["This page will automatically summarize all applicable data collected from prior three workbook pages (Sections I, II, III).  "]
["Certification"]
["After completing and reviewing the four (4) pages of the Schedule of Rental Income Workbook, please have an authorized Board Member or the Park's property management agent sign, indicate the respective title, and date to certify that the information submitted is true, an accurate representation of the resident's obligations and rent being paid, and that the proper approval(s) have been received relative to the proposed increase in assessment / rent."]

{"sheet":"1. Chklst, Certification","index":1,"n_rows":41,"n_cols":50,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,0,2,9],[9,0,9,1],[4,0,4,4],[12,0,12,1],[12,2,12,3],[6,0,6,1],[11,0,11,1],[4,6,4,9],[7,0,7,1],[1,0,1,9],[3,1,3,9],[12,8,12,9],[12,5,12,7],[8,0,8,1],[10,0,10,1],[15,4,15,7],[17,1,17,2],[16,7,16,9],[25,1,25,4],[17,5,17,6],[17,3,17,4],[24,0,24,9],[17,7,17,8],[16,1,16,3],[19,0,19,8],[26,1,26,4],[27,1,27,4],[31,5,31,8],[32,5,32,8],[31,0,31,1],[31,2,31,4],[28,1,28,4],[30,0,30,9],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[14,0,14,9],[39,1,39,4],[39,5,39,8],[40,1,40,4],[40,5,40,8],[32,2,32,4],[33,2,33,4],[33,6,33,9],[34,1,34,5],[32,0,32,1],[37,4,37,9]]}
["Mobilehome Park Resident Ownership Program (MPROP)\nMobilehome Park Assistance Program (MPAP)"]
["1. Checklist, Certification and Approval"]
["Complete all areas highlighted in yellow.  Small red triangles indicate that an instruction will appear when cursor is over the cell.                                                                                                                                                                                     "]
["Rev. 4/10/23"]
["A. GENERAL INFORMATION"]
[]
["Contract Number:",null,null,null,null,null,null,null,null,null,null,null,null,"January 1 - December 31"]
["Park Name:",null,null,null,null,null,null,null,null,null,null,null,null,"April 1 - March 31"]
["Management Company:",null,null,null,null,null,null,null,null,null,null,null,null,"July 1 - June 30"]
["Prepared By:","Prepared By:",null,null,null,null,null,null,null,null,null,null,null,"October 1 - September 30"]
["Date Prepared:","Date Prepared:",null,null,null,null,null,null,null,null,null,null,null,"Other"]
["Fiscal Year:",null,2023]
["FY Start -- Finish:","F",null,null,null,null,null,null,"If \"Other\" FY, describe"]
[]
["B. STATE INCOME LIMITS:  Enter the name of the County in which your Park is located."]
[]
[null,"Select County in which the park is located from drop-down list"]
["County:",null,null,null,null,"HCD Memorandum Date:",null,"2022-05-13"]
[]
["       Income Limits by Household Size"]
["Income Level /         # Persons",1,2,3,4,5,6,7,8]
["80% Low",{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,3,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,4,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,5,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,6,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,7,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,8,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,9,FALSE))","v":""},{"$f":"IF($B$18=\"\",\"\",VLOOKUP($B$18,'6. State Income Limits Chart'!$A$1:$J$59,10,FALSE))","v":""}]
[]
[]
["C. CHECKLIST OF REQUIRED ITEMS:  Items 1. through 4. must be completed for all projects.  Check box to indicate you have completed each of them. The worksheet on Tab #5, Summary, will auto-fill."]
[null,"1. Checklist, Certification, Approval and Instructions"]
[null,"2. Assisted Units Incomes and Rents"]
[null,"3. Non-Assisted Units Rents"]
[null,"4. Commercial Space Rents"]
[]
["D. CERTIFICATION:   By selecting the appropriate radio button, below, and completing the remainder of this certification block, I certify that: 1) the current tenant rents and other information submitted on the Schedules of Rental Income are a true and accurate representation; 2) tenants will be given the appropriate notification required by law of the rent adjustments approved by HCD; 3) I am authorized to provide this information, and; 4) it is accurate to the best of my knowledge."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yolo"]
["Certifier Type",null,"Certifier's Name",null,null,"Certifier's Title",null,null,null,"Cert Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yuba"]
[null,"Phone No:",null,null,null,"Email:"]
["Certifier Other:"]
[]
[]
["E. HCD Approval (HCD use only)",null,null,null,"By selecting \"Yes\", I hereby approve this Schedule of Rental Income"]
[]
[]
[null,"HCD Rep's Name",null,null,null,"Title",null,null,null,"Approval Date"]

{"sheet":"2. Assisted","index":2,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,1],[2,2,2,4],[109,1,109,15],[8,9,8,12],[108,0,108,9],[3,2,3,4],[3,0,3,1],[6,2,6,4],[4,2,4,4],[107,1,107,2],[8,2,8,4],[7,0,7,1],[8,0,8,1],[7,2,7,4],[4,0,4,1],[5,2,5,4],[5,0,5,1],[6,0,6,1]]}
["Mobilehome Park Resident Ownership Program (MPROP)\nMobilehome Park Assistance Program (MPAP)"]
["2. Assistance Analysis Chart  - Assisted Units"]
["Contract Number:",null,{"$f":"'1. Chklst, Certification'!C7","v":0},null,null,{"$f":"'1. Chklst, Certification'!A4","v":"Rev. 4/10/23"}]
[" Park Name:",null,{"$f":"'1. Chklst, Certification'!C8","v":0}]
["Management Co.:",null,{"$f":"'1. Chklst, Certification'!C9","v":0}]
["Prepared By:",null,{"$f":"'1. Chklst, Certification'!C10","v":0}]
["Date Prepared:",null,{"$f":"'1. Chklst, Certification'!C11","v":"00:00:00"}]
["Fiscal Year:",null,{"$f":"'1. Chklst, Certification'!C12","v":2023}]
["FY Start-- Finish:",null,{"$f":"'1. Chklst, Certification'!C13","v":0},null,null,null,null,null,null,"Proposed Rent Adjustment Factor:"]
["[A]","[B]","[C]","[D]","[E]","[F]","[G]","(H)","[I]","[J]","[K]","[L]","[M]","[N]","[O]","[P]"]
["Space Number","Number of Persons in Household","Household ID","Household Low Income Limit","Household Annual Gross Income","Household Monthly Gross Income","Proposed Monthly Space Assessment","Monthly Mobilehome Utility & Maintenance","Monthly Mobilehome Insurance","Monthly  Mobilehome Registration & Taxes","Monthly Mobilehome Loan Payment","Monthly Housing Costs","Housing Ratio","Proposed Monthly Assistance","Adjusted Housing Ratio","Comment"]
[null,null,null,{"$f":"IF(B12>=1,HLOOKUP(B12,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,{"$f":"IF(E12=0,\"\",(E12/12))","v":""},null,null,null,null,null,{"$f":"IF(E12=0,\"\",SUM(G12:K12))","v":""},{"$f":"IF(E12=0,\"\",(L12/F12))","v":""},null,{"$f":"IF(E12=0,\"\",(L12-N12)/F12)","v":""}]
[null,null,null,{"$f":"IF(B13>=1,HLOOKUP(B13,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,{"$f":"IF(E13=0,\"\",SUM(G13:K13))","v":""},"",null,""]
[null,null,null,{"$f":"IF(B14>=1,HLOOKUP(B14,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B15>=1,HLOOKUP(B15,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B16>=1,HLOOKUP(B16,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B17>=1,HLOOKUP(B17,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B18>=1,HLOOKUP(B18,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B19>=1,HLOOKUP(B19,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,{"$f":"IF(E19=0,\"\",(E19/12))","v":""},null,null,null,null,null,"",{"$f":"IF(E19=0,\"\",(L19/F19))","v":""},null,{"$f":"IF(E19=0,\"\",(L19-N19)/F19)","v":""}]
[null,null,null,{"$f":"IF(B20>=1,HLOOKUP(B20,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B21>=1,HLOOKUP(B21,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B22>=1,HLOOKUP(B22,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B23>=1,HLOOKUP(B23,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B24>=1,HLOOKUP(B24,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B25>=1,HLOOKUP(B25,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B26>=1,HLOOKUP(B26,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B27>=1,HLOOKUP(B27,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B28>=1,HLOOKUP(B28,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B29>=1,HLOOKUP(B29,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,{"$f":"IF(E29=0,\"\",(E29/12))","v":""},null,null,null,null,null,"",{"$f":"IF(E29=0,\"\",(L29/F29))","v":""},null,{"$f":"IF(E29=0,\"\",(L29-N29)/F29)","v":""}]
[null,null,null,{"$f":"IF(B30>=1,HLOOKUP(B30,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B31>=1,HLOOKUP(B31,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B32>=1,HLOOKUP(B32,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B33>=1,HLOOKUP(B33,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B34>=1,HLOOKUP(B34,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B35>=1,HLOOKUP(B35,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B36>=1,HLOOKUP(B36,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B37>=1,HLOOKUP(B37,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B38>=1,HLOOKUP(B38,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B39>=1,HLOOKUP(B39,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B40>=1,HLOOKUP(B40,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B41>=1,HLOOKUP(B41,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B42>=1,HLOOKUP(B42,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B43>=1,HLOOKUP(B43,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B44>=1,HLOOKUP(B44,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B45>=1,HLOOKUP(B45,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B46>=1,HLOOKUP(B46,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B47>=1,HLOOKUP(B47,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B48>=1,HLOOKUP(B48,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B49>=1,HLOOKUP(B49,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B50>=1,HLOOKUP(B50,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B51>=1,HLOOKUP(B51,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B52>=1,HLOOKUP(B52,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B53>=1,HLOOKUP(B53,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B54>=1,HLOOKUP(B54,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B55>=1,HLOOKUP(B55,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,{"$f":"IF(E55=0,\"\",(E55/12))","v":""},null,null,null,null,null,"",{"$f":"IF(E55=0,\"\",(L55/F55))","v":""},null,{"$f":"IF(E55=0,\"\",(L55-N55)/F55)","v":""}]
[null,null,null,{"$f":"IF(B56>=1,HLOOKUP(B56,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B57>=1,HLOOKUP(B57,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B58>=1,HLOOKUP(B58,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B59>=1,HLOOKUP(B59,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B60>=1,HLOOKUP(B60,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B61>=1,HLOOKUP(B61,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B62>=1,HLOOKUP(B62,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B63>=1,HLOOKUP(B63,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B64>=1,HLOOKUP(B64,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B65>=1,HLOOKUP(B65,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B66>=1,HLOOKUP(B66,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B67>=1,HLOOKUP(B67,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B68>=1,HLOOKUP(B68,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B69>=1,HLOOKUP(B69,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B70>=1,HLOOKUP(B70,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B71>=1,HLOOKUP(B71,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B72>=1,HLOOKUP(B72,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B73>=1,HLOOKUP(B73,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B74>=1,HLOOKUP(B74,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B75>=1,HLOOKUP(B75,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B76>=1,HLOOKUP(B76,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B77>=1,HLOOKUP(B77,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,{"$f":"IF(E77=0,\"\",SUM(G77:K77))","v":""},"",null,""]
[null,null,null,{"$f":"IF(B78>=1,HLOOKUP(B78,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B79>=1,HLOOKUP(B79,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B80>=1,HLOOKUP(B80,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,{"$f":"IF(E80=0,\"\",(E80/12))","v":""},null,null,null,null,null,"",{"$f":"IF(E80=0,\"\",(L80/F80))","v":""},null,{"$f":"IF(E80=0,\"\",(L80-N80)/F80)","v":""}]
[null,null,null,{"$f":"IF(B81>=1,HLOOKUP(B81,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B82>=1,HLOOKUP(B82,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B83>=1,HLOOKUP(B83,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B84>=1,HLOOKUP(B84,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B85>=1,HLOOKUP(B85,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B86>=1,HLOOKUP(B86,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B87>=1,HLOOKUP(B87,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B88>=1,HLOOKUP(B88,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B89>=1,HLOOKUP(B89,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B90>=1,HLOOKUP(B90,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B91>=1,HLOOKUP(B91,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B92>=1,HLOOKUP(B92,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B93>=1,HLOOKUP(B93,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B94>=1,HLOOKUP(B94,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B95>=1,HLOOKUP(B95,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B96>=1,HLOOKUP(B96,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B97>=1,HLOOKUP(B97,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B98>=1,HLOOKUP(B98,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B99>=1,HLOOKUP(B99,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B100>=1,HLOOKUP(B100,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B101>=1,HLOOKUP(B101,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B102>=1,HLOOKUP(B102,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B103>=1,HLOOKUP(B103,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B104>=1,HLOOKUP(B104,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B105>=1,HLOOKUP(B105,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B106>=1,HLOOKUP(B106,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[null,null,null,{"$f":"IF(B107>=1,HLOOKUP(B107,'1. Chklst, Certification'!$B$21:$I$22,2,FALSE),\"\")","v":""},null,"",null,null,null,null,null,"","",null,""]
[{"$f":"COUNTA(A12:A107)","v":0},"Total",null,null,null,"Assessments Before Assistance:",{"$f":"SUM(G12:G107)","v":0},null,null,null,null,null,"Total Assistance:",{"$f":"SUM(N12:N107)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(M12:M107)","v":{"$error":"#DIV/0!"}},"Average",{"$f":"AVERAGE(O12:O107)","v":{"$error":"#DIV/0!"}}]
["Comments:"]

{"sheet":"3. Non-Assisted","index":3,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[[78,0,78,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[6,1,6,3],[6,5,6,7],[4,1,4,3],[5,1,5,3],[3,0,3,7],[4,5,4,7],[5,5,5,7]]}
["Mobilehome Park Resident Ownership Program (MPROP)\nMobilehome Park Assistance Program (MPAP)"]
["3. Schedule of Assessments - Non-Assisted Units / Lots / Rental Units / Spaces"]
[{"$f":"'1. Chklst, Certification'!A4","v":"Rev. 4/10/23"}]
["(Group by assessment and income level type)"]
["Contract Number:",{"$f":"'2. Assisted'!C3","v":0},null,null,"Prepared By:",{"$f":"+'2. Assisted'!C6","v":0}]
["Project Name:",{"$f":"'2. Assisted'!C4","v":0},null,null,"Date Prepared:",{"$f":"'2. Assisted'!C7","v":"00:00:00"}]
["Management Co.:",{"$f":"'2. Assisted'!C5","v":0},null,null,"Fiscal Year:",{"$f":"'2. Assisted'!C8","v":2023}]
[]
["[A]","[B]","[C]","[D]","[E]","[F]","[G]","[H]"]
["Assessment Type","Current Individual Monthly Assessment","Number of Simular assessments","Total Monthly Assessment","Number of Months","Total Current Annual Assessment","Proposed Percent Increase","Proposed Total Annual Assessment"]
[null,null,null,{"$f":"IF(C11=0,\"\",(B11*C11))","v":""},null,{"$f":"IF(C11=0,\"\",SUM(D11*E11))","v":""},null,{"$f":"IF(C11=0,\"\",SUM((F11*G11)+F11))","v":""}]
[null,null,null,{"$f":"IF(C12=0,\"\",(B12*C12))","v":""},null,{"$f":"IF(C12=0,\"\",SUM(D12*E12))","v":""},null,{"$f":"IF(C12=0,\"\",SUM((F12*G12)+F12))","v":""},null,"Drop Down Box Code"]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,"",null,"Space Assessment"]
[null,null,null,"",null,"",null,"",null,"Lot"]
[null,null,null,"",null,"",null,"",null,"Rental Unit"]
[null,null,null,"",null,"",null,"",null,"RV / Boat Space"]
[null,null,null,"",null,"",null,"",null,"Vehicle Parking"]
[null,null,null,"",null,"",null,"",null,"Storage"]
[null,null,null,"",null,"",null,"",null,"Other"]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,{"$f":"IF(C76=0,\"\",(B76*C76))","v":""},null,{"$f":"IF(C76=0,\"\",SUM(D76*E76))","v":""},null,{"$f":"IF(C76=0,\"\",SUM((F76*G76)+F76))","v":""}]
[null,"TOTALS",{"$f":"SUM(C11:C76)","v":0},{"$f":"SUM(D11:D76)","v":0},null,{"$f":"SUM(F11:F76)","v":0},null,{"$f":"SUM(H11:H76)","v":0}]
["Comments:"]

{"sheet":"4. Commercial Space","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,0,8,2],[8,3,8,4],[10,3,10,4],[13,0,13,2],[13,3,13,4],[11,3,11,4],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[9,3,9,4],[12,3,12,4],[0,0,0,8],[1,0,1,8],[3,0,3,1],[4,0,4,1],[7,3,7,4],[3,7,3,8],[6,0,6,8],[5,0,5,1],[5,2,5,5],[7,0,7,2],[4,7,4,8],[5,7,5,8],[3,2,3,5],[4,2,4,5],[20,0,20,2],[23,0,23,8],[21,0,21,5],[14,0,14,2],[15,0,15,2],[16,0,16,2],[19,3,19,4],[16,3,16,4],[20,3,20,4],[14,3,14,4],[17,0,17,2],[18,0,18,2],[19,0,19,2],[18,3,18,4],[15,3,15,4],[17,3,17,4]]}
["Mobilehome Park Resident Ownership Program (MPROP)\n Mobilehome Park Assistance Program (MPAP)"]
["4. Schedule of Rental Income - Commercial Space"]
[null,{"$f":"'1. Chklst, Certification'!A4","v":"Rev. 4/10/23"}]
["Contract Number:",null,{"$f":"'2. Assisted'!C3","v":0},null,null,null,"Prepared By:",{"$f":"'2. Assisted'!C6","v":0}]
["Park Name:",null,{"$f":"'2. Assisted'!C4","v":0},null,null,null,"Date Prepared:",{"$f":"'2. Assisted'!C7","v":"00:00:00"}]
["Management Co.:",null,{"$f":"+'2. Assisted'!C5:E5","v":0},null,null,null,"Fiscal Year:",{"$f":"'2. Assisted'!C8","v":2023}]
[]
["[A]",null,null,"[B]",null,"[C]","[D]","[E]","[F]"]
["Name of Lessor",null,null,"Unit Designation or Address",null,"Type of Business or Other Uses","Total Monthly Rent","Number of Months","Total Annual Rental Income"]
[null,null,null,null,null,null,null,null,{"$f":"G10*H10","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
["TOTALS ",null,null,null,null,null,{"$f":"SUM(G10:G21)","v":0},{"$f":"SUM(H10:H21)","v":0},{"$f":"SUM(I10:I21)","v":0}]
["Comments:"]

{"sheet":"5. Summary","index":5,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,5,7,6],[8,7,8,8],[0,0,0,10],[1,0,1,10],[3,0,3,1],[4,0,4,1],[2,0,2,10],[5,0,5,1],[6,0,6,10],[3,8,3,10],[4,8,4,10],[5,8,5,10],[3,2,3,4],[4,2,4,4],[7,9,7,10],[14,0,14,2],[8,9,8,10],[9,9,9,10],[13,7,13,8],[9,5,9,6],[9,7,9,8],[10,9,10,10],[10,7,10,8],[10,5,10,6],[13,9,13,10],[14,9,14,10],[13,0,13,2],[17,9,17,10],[19,9,19,10],[16,5,16,6],[16,9,16,10],[16,7,16,8],[19,5,19,6],[15,7,15,8],[16,0,16,2],[13,5,13,6],[5,2,5,4],[10,0,10,2],[14,7,14,8],[8,0,8,2],[8,5,8,6],[15,0,15,2],[7,0,7,2],[9,0,9,2],[7,7,7,8],[14,5,14,6],[15,5,15,6],[11,0,11,10],[12,0,12,10],[29,9,29,10],[29,0,29,6],[23,9,23,10],[25,0,25,2],[25,5,25,6],[25,7,25,8],[25,9,25,10],[29,7,29,8],[26,5,27,8],[27,9,27,10],[27,0,27,2],[26,0,26,2],[26,9,26,10],[23,0,23,2],[18,0,18,2],[18,9,18,10],[20,0,20,2],[22,0,22,2],[18,5,18,6],[22,9,22,10],[21,0,21,2],[20,5,20,6],[18,7,18,8],[19,0,19,2],[15,9,15,10],[28,0,28,10],[24,0,24,10],[23,7,23,8],[23,5,23,6],[21,5,21,6],[21,9,21,10],[21,7,21,8],[17,0,17,2],[20,9,20,10],[22,5,22,6],[22,7,22,8],[17,7,17,8],[19,7,19,8],[17,5,17,6],[20,7,20,8]]}
["Mobilehome Park Resident Ownership Program (MPROP)\nMobilehome Park Assistance Program (MPAP)"]
["5. Summary of Annual Income"]
[{"$f":"'1. Chklst, Certification'!A4","v":"Rev. 4/10/23"}]
["Contract Number:",null,{"$f":"'2. Assisted'!C3","v":0},null,null,null,null,"Prepared By:",{"$f":"'2. Assisted'!C6","v":0}]
["Park Name:",null,{"$f":"'2. Assisted'!C4","v":0},null,null,null,null,"Date Prepared:",{"$f":"'2. Assisted'!C7","v":"00:00:00"}]
["Management Co.:",null,{"$f":"+'2. Assisted'!C5","v":0},null,null,null,null,"Fiscal Year:",{"$f":"'2. Assisted'!C8","v":2023}]
["ASSISTED UNITS"]
["Number of Bedrooms/\nTargeted Income Level or\nManager Unit",null,null,"Number of Units","Regulatory Agreement\nPark Distribution","Proposed Total Annual Tenant Rent",null,"Proposed Total Annual Subsidy Income",null,"Approved Total Annual Rental Income\n(HCD use only)"]
["Assisted Units",null,null,{"$f":"COUNTIF('2. Assisted'!N12:N107,\">1\")","v":0},null,{"$f":"SUM('2. Assisted'!G108*12)","v":0},null,{"$f":"SUM('2. Assisted'!N108*12)","v":0},null,{"$f":"SUM(F9-H9)","v":0}]
[]
["Total Assisted\nResidental Spaces",null,null,{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0},{"$f":"SUM(F9:G10)","v":0},null,{"$f":"H9","v":0},null,{"$f":"J9","v":0}]
[]
["NON-ASSISTED UNITS"]
["Number of Bedrooms/\nTargeted Income Level or\nManager Unit",null,null,"Number of Units","Regulatory Agreement\nPark Distribution","Total Annual Tenant Rent",null,"Average Increase",null,"Approved Total Annual Rental Income\n(HCD use only)"]
["Space Assessment",null,null,{"$f":"SUMIF('3. Non-Assisted'!11:76,\"Space Assessment\", '3. Non-Assisted'!C11:C76)","v":0},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Space Assessment\",'3. Non-Assisted'!F11:F76)","v":0},null,{"$f":"IF(D15=0,\"\",(J15/F15)-100%)","v":""},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Space Assessment\",'3. Non-Assisted'!H$11:H$76)","v":0}]
["Lot",null,null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Lot\", '3. Non-Assisted'!C11:C76)","v":0},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Lot\",'3. Non-Assisted'!F11:F76)","v":0},null,{"$f":"IF(D16=0,\"\",(J16/F16)-100%)","v":""},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Lot\",'3. Non-Assisted'!H$11:H$76)","v":0}]
["Rental Unit",null,null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Rental Unit\", '3. Non-Assisted'!C11:C76)","v":0},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Rental Unit\",'3. Non-Assisted'!F11:F76)","v":0},null,"",null,{"$f":"SUMIF('3. Non-Assisted'!A$11:A$76,\"Rental Unit\",'3. Non-Assisted'!H$11:H$76)","v":0}]
["RV / Boat Space",null,null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"RV / Boat Space\", '3. Non-Assisted'!C11:C76)","v":0}," ",{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"RV / Boat Space\",'3. Non-Assisted'!F11:F76)","v":0},null,"",null,{"$f":"SUMIF('3. Non-Assisted'!A$11:A$76,\"RV / Boat Space\",'3. Non-Assisted'!H$11:H$76)","v":0}]
["Vehicle Parking",null,null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Vehicle Parking\", '3. Non-Assisted'!C11:C76)","v":0},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Vehicle Parking\",'3. Non-Assisted'!F11:F76)","v":0},null,"",null,{"$f":"SUMIF('3. Non-Assisted'!A$12:A$76,\"Vehicle Parking\",'3. Non-Assisted'!H$11:H$76)","v":0}]
["Storage",null,null,{"$f":"SUMIF('3. Non-Assisted'!A$11:A76,\"Storage\", '3. Non-Assisted'!C11:C76)","v":0},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Storage\",'3. Non-Assisted'!F11:F76)","v":0},null,"",null,{"$f":"SUMIF('3. Non-Assisted'!A$11:A$76,\"Storage\",'3. Non-Assisted'!H$11:H$76)","v":0}]
["Other",null,null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Other\",'3. Non-Assisted'!C11:C76)","v":0},null,{"$f":"SUMIF('3. Non-Assisted'!A11:A76,\"Other\",'3. Non-Assisted'!F11:F76)","v":0},null,"",null,{"$f":"SUMIF('3. Non-Assisted'!A$11:A$76,\"Other\",'3. Non-Assisted'!H$11:H$76)","v":0}]
[]
["Total Non-Assisted\nResidential Space",null,null,{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:G22)","v":0},null,{"$f":"IF(D23=0,\"\",(J23/F23)-100%)","v":""},null,{"$f":"SUM(J15:K22)","v":0}]
["Total Park\nResidential Space",null,null,{"$f":"SUM(D11+D23)","v":0},{"$f":"SUM(E11+E23)","v":0},null,null,null,null,{"$f":"J11+J23","v":0}]
[]
["COMMERICAL SPACE"]
[null,null,null,"Total Number of Spaces","Regulatory Agreement\nPark Distribution",null,null,null,null,"Approved Total Annual Rental Income\n(HCD use only)"]
["Total",null,null,{"$f":"COUNTA('4. Commercial Space'!B10:C21)","v":0},null,null,null,null,null,{"$f":"'4. Commercial Space'!I22:I22","v":0}]
[]
[null,null,null,null,null,null,null,"Grand Total",null,{"$f":"J24+J28","v":0}]

{"sheet":"6. State Income Limits Chart","index":6,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["2022 State Income Limits","Income Category",1,2,3,4,5,6,7,8]
["Alameda","Low Income",76750,87700,98650,109600,118400,127150,135950,144700]
["Alpine","Low Income",50900,58150,65400,72650,78500,84300,90100,95900]
["Amador","Low Income",48550,55450,62400,69300,74850,80400,85950,91500]
["Butte","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Calaveras","Low Income",50400,57600,64800,72000,77800,83550,89300,95050]
["Colusa","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Contra Costa","Low Income",76750,87700,98650,109600,118400,127150,135950,144700]
["Del Norte","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["El Dorado","Low Income",56750,64850,72950,81050,87550,94050,100550,107000]
["Fresno","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Glenn","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Humboldt","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Imperial","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Inyo","Low Income",46350,52950,59550,66150,71450,76750,82050,87350]
["Kern","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Kings","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Lake","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Lassen","Low Income",45000,51400,57850,64250,69400,74550,79700,84850]
["Los Angeles","Low Income",66750,76250,85800,95300,102950,110550,118200,125800]
["Madera","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Marin","Low Income",104400,119300,134200,149100,161050,173000,184900,196850]
["Merced","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Modoc","Low Income",45000,51400,57850,64250,69400,74550,79700,84850]
["Mono","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Monterey","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Napa","Low Income",45300,51800,58250,64700,69900,75100,80250,85450]
["Mariposa","Low Income",63700,72800,81900,91000,98300,105600,112850,120150]
["Mendocino","Low Income",70550,80600,90700,100750,108850,116900,124950,133000]
["Nevada","Low Income",55100,63000,70850,78700,85000,91300,97600,103900]
["Orange","Low Income",75900,86750,97600,108400,117100,125750,134450,143100]
["Placer","Low Income",56750,64850,72950,81050,87550,94050,100550,107000]
["Plumas","Low Income",45750,52300,58850,65350,70600,75850,81050,86300]
["Riverside","Low Income",49300,56350,63400,70400,76050,81700,87300,92950]
["Sacramento","Low Income",56750,64850,72950,81050,87550,94050,100550,107000]
["San Benito","Low Income",58900,67300,75700,84100,90850,97600,104300,111050]
["San Bernardino","Low Income",49300,56350,63400,70400,76050,81700,87300,92950]
["San Diego","Low Income",72900,83300,93700,104100,112450,120800,129100,137450]
["San Francisco","Low Income",104400,119300,134200,149100,161050,173000,184900,196850]
["San Joaquin","Low Income",46350,53000,59600,66200,71500,76800,82100,87400]
["San Luis Obispo","Low Income",61250,70000,78750,87500,94500,101500,108500,115500]
["San Mateo","Low Income",104400,119300,134200,149100,161050,173000,184900,196850]
["Santa Barbara","Low Income",78350,89550,100750,111900,120900,129850,138800,147750]
["Santa Clara","Low Income",92250,105400,118600,131750,142300,152850,163400,173950]
["Santa Cruz","Low Income",87350,99800,112300,124750,134750,144750,154700,164700]
["Shasta","Low Income",44450,50800,57150,63500,68600,73700,78750,83850]
["Sierra","Low Income",50400,57600,64800,72000,77800,83550,89300,95050]
["Siskiyou","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Solano","Low Income",60800,69450,78150,86800,93750,100700,107650,114600]
["Sonoma","Low Income",66550,76050,85550,95050,102700,110300,117900,125500]
["Stanislaus","Low Income",44650,51000,57400,63750,68850,73950,79050,84150]
["Sutter","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Tehama","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Trinity","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Tulare","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]
["Tuolumne","Low Income",46600,53250,59900,66550,71900,77200,82550,87850]
["Ventura","Low Income",70250,80300,90350,100350,108400,116450,124450,132500]
["Yolo","Low Income",55550,63450,71400,79300,85650,92000,98350,104700]
["Yuba","Low Income",43650,49850,56100,62300,67300,72300,77300,82250]