{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Tools","MBA Ratings","Fannie Mae Ratings","General Info","Physical Condition & DM","Photos","Rent Roll","Mgmt Interview","Multifamily","Fannie Mae Assmt Addendum","FRE Assmt Addendum","Repairs Verification","Senior Supplement","Hospitals","Data","Resources"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":3151,"comments":4,"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":"Tools","index":0,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,1,9,34],[6,1,6,34],[0,1,1,19],[4,1,4,35]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"\"Version: \"&Version","v":"Version: 3.03"}]
[]
[null,"Tools"]
[]
[null,"Company Logo"]
[]
[]
[null,"General Purpose Tools"]
[]
[null,null,null,null,null,null,null,null,null,"Run Excel's spell checker on all Inspection Report tabs"]
[]
[null,null,null,null,null,null,null,null,null,"Print the Inspection Report tabs or save all as a single PDF"]
[]
[null,null,null,null,null,null,null,null,null,"Extract Photos and save to computer"]
[]
[]
[]
[null,"Inspection Report Tabs and Scope presets"]
[]
[]
[]
[]
[null,"    Select Report Tabs to be shown based on the scope of the inspection"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Rating Scale Tabs"]

{"sheet":"MBA Ratings","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[7,1,7,2],[10,1,10,7],[9,1,9,7],[7,3,7,35],[10,8,10,35],[9,8,9,35],[1,1,1,35],[3,3,3,35],[4,3,4,35],[5,1,5,2],[6,1,6,2],[6,3,6,35],[5,3,5,35],[3,1,3,2],[4,1,4,2]]}
[]
[null,"MBA Rating Scale Definitions"]
[]
[null,1,null,"•  New or like new condition\n•  All major building components are new or like new\n•  All vacant units/space are rent ready & reflect the highest current market standards\n•  No Deferred Maintenance items (only Routine Maintenance)\n•  No Life Safety or code violations exist\n•  Positive impact to marketability\n•  Deferred Maintenance and Life Safety – No actions are required"]
[null,2,null,"•  Above average condition for the property’s age and market, minimal wear and tear\n•  All major building components in functional condition\n•  All vacant units/space are rent ready or in the process of being made rent ready\n•  No Deferred Maintenance items (only Routine Maintenance)\n•  No Life Safety or code violations exist\n•  No impact to marketability\n•  Deferred Maintenance and Life Safety – No actions are required"]
[null,3,null,"•  Normal condition for the property’s age and market, general wear and tear.\n•  All major building components in functional condition\n•  Most vacant units or space are rent ready or in the process of being made rent ready\n•  No/minor Life Safety or code violations exist\n•  No impact to marketability\n•  Deferred Maintenance and Life Safety - Appropriate actions are planned or in progress"]
[null,4,null,"•  Deteriorating condition for the property’s age and market\n•  A building component is not in fully functional condition\n•  Few rent-ready units or space\n•  Limited major Deferred Maintenance and/or numerous minor Deferred Maintenance items\n•  Some Life Safety or code violations exist\n•  Negative impact to marketability\n•  Deferred Maintenance and Life Safety - Actions are not addressed as quickly as required and/or further action is necessary, additional monitoring may be appropriate"]
[null,5,null,"•  Inferior conditions\n•  Multiple building components non-functional\n•  Vacant units or space are in poor to down condition\n•  Severe Deferred Maintenance items\n•  Multiple Life Safety or code violations exist\n•  Negative impact to marketability\n•  Deferred Maintenance and Life Safety – No Action taken and/or further action is necessary – additional monitoring is appropriate"]
[]
[null,"Not Applicable",null,null,null,null,null,null," No components exist (therefore, no rating is possible)"]
[null,"Not Accessible",null,null,null,null,null,null,"•  No component was visible due to inability to view the condition based on access, Life Safety, weather conditions or other blockages.\n•  Deferred Maintenance items can not be determined based on lack of access. Further action or review may be required."]
[]
[null,"Refer to the MBA Reference Guide for Commercial and Multifamily Property Inspection Reports for more information."]

{"sheet":"Fannie Mae Ratings","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,1,9,7],[9,8,9,35],[10,1,10,7],[10,8,10,35],[5,1,5,2],[5,3,5,35],[6,1,6,2],[6,3,6,35],[7,1,7,2],[7,3,7,35],[1,1,1,35],[3,1,3,2],[3,3,3,35],[4,1,4,2],[4,3,4,35]]}
[]
[null,"Fannie Mae Rating Scale Definitions"]
[]
[null,1,null,"No concerns observed. No further action required.\n•  Excellent condition; typically newer property or property with recent major rehab/significant investment\n•  No observed or reported Deferred Maintenance issues\n•  No Life Safety issues observed\n•  Superior RM practices that are extending the RUL of systems and components\n•  Capital needs are addressed; major components and systems are like new, in excellent condition and high probability they will significantly exceed the loan term"]
[null,2,null,"Some minor issues noted. Limited follow-up required.\n•  Very Good/Good condition with isolated and relatively minor issues that are unlikely to negatively impact operations and can be addressed in-house\n•  No/minor Life Safety issues observed\n•  Isolated or minor Deferred Maintenance can be addressed in-house and/or at limited expense\n•  Proactive RM practices ensuring good overall system performance and functionality\n•  Majority of capital needs are being addressed, property performance does not appear to be impacted; components and systems in good condition and very likely will exceed the loan term"]
[null,3,null,"Overall declining condition or isolated deterioration.  Documented follow-up required.\n•  Average to Fair condition; requiring investment\n•  Some Life Safety issues observed requiring immediate attention; but no capital expenditure\n•  Deferred Maintenance of heightened concern; likely not addressed in house\n•  Some reactive RM practices impacting a limited number of components requiring attention\n•  Critical capital needs are being addressed as needed, but additional capital required to maintain asset quality and system functionality; RUL of major systems/components may not meet or exceed the loan term"]
[null,4,null,"Substantial issues noted.  Documented follow-up with possible action plan required.\n•  Deteriorated overall conditions, substandard materials and practices, or major issues have not been addressed since prior inspection; requiring significant investment\n•  Life Safety issues observed that require immediate attention and possible capital expenditure\n•  Substantial Deferred Maintenance affecting major/several property areas/systems, requiring significant investment\n•  Reactive RM practices that do not address concerns in a timely manner\n•  Some critical capital needs are not being addressed, and property performance may be negatively impacted; very likely that the RUL of major systems/components will not meet or exceed the loan term"]
[null,5,null,"Severe Deferred Maintenance observed. Follow-up and substantial action plan required.\n•  Unacceptable overall conditions. Widespread neglect or casualty event; condition materially impacts marketability. Functionality of systems and components is compromised.\n•  Significant Life Safety issues requiring capital expenditure\n•  Excessive Deferred Maintenance affecting multiple areas/property systems, requiring significant investment;\nimpacting collateral value\n•  Inadequate RM practices that do not ensure reasonable functionality of the property systems and components and may impact collateral value\n•  Major and pervasive issues with major components and systems; critical capital needs are not being addressed, property performance is being impacted and RUL of major systems/components has been exceeded"]
[]
[null,"Not Applicable",null,null,null,null,null,null," No components exist (therefore, no rating is possible)"]
[null,"Not Accessible",null,null,null,null,null,null,"•  No component was visible due to inability to view the condition based on access, life safety, weather conditions or other blockages.\n•  Deferred Maintenance items can not be determined based on lack of access. Further action or review may be required."]
[]
[null,"Refer to the MBA Reference Guide for Commercial and Multifamily Property Inspection Reports for more information."]

{"sheet":"General Info","index":3,"n_rows":137,"n_cols":33,"rows_kept":137,"cut":false,"hidden":false,"merged":[[11,32,11,35],[104,1,104,26],[103,1,103,26],[102,1,102,26],[101,27,101,31],[73,12,73,17],[70,12,70,17],[67,12,67,17],[66,32,66,35],[104,32,104,35],[100,32,100,35],[101,32,101,35],[101,1,101,26],[100,1,100,26],[104,27,104,31],[102,32,102,35],[36,7,36,10],[36,12,36,17],[28,19,28,35],[19,8,19,17],[80,31,80,35],[90,1,90,18],[99,27,99,31],[97,27,97,31],[137,1,137,35],[64,32,65,35],[73,19,74,35],[90,19,90,27],[90,28,90,35],[86,19,86,27],[84,1,84,17],[86,1,86,18],[87,1,87,18],[87,19,87,27],[87,28,87,35],[88,1,88,18],[88,19,88,27],[88,28,88,35],[84,19,84,27],[84,28,84,35],[69,32,69,35],[70,27,70,30],[100,27,100,31],[102,27,102,31],[99,32,99,35],[72,12,72,17],[89,28,89,35],[77,12,77,17],[25,26,25,35],[86,28,86,35],[40,1,40,35],[69,27,69,30],[24,31,24,35],[49,1,49,35],[35,28,35,35],[38,32,38,35],[127,1,127,35],[96,1,96,25],[79,22,79,35],[79,12,79,17],[89,1,89,18],[89,19,89,27],[67,32,67,35],[32,1,32,6],[30,7,30,10],[31,19,31,25],[32,26,32,35],[30,26,30,29],[38,7,38,17],[111,27,111,31],[93,1,94,35],[59,12,59,17],[60,12,60,17],[61,12,61,17],[62,12,62,17],[59,30,59,35],[60,30,60,35],[61,30,61,35],[62,30,62,35],[63,12,63,17],[70,32,70,35],[76,12,76,17],[75,12,75,17],[75,19,77,35],[80,9,80,17],[97,32,97,35],[99,1,99,26],[64,12,64,17],[63,30,63,35],[67,27,67,30],[66,12,66,17],[69,12,69,17],[20,26,20,35],[30,19,30,25],[34,1,34,35],[29,7,29,17],[30,12,30,17],[13,32,13,35],[13,7,13,17],[14,26,14,35],[29,19,29,25],[18,26,18,35],[30,1,30,6],[24,8,24,17],[31,1,31,6],[15,13,15,15],[26,8,26,11],[17,1,17,17],[20,8,20,17],[21,26,21,35],[22,26,22,35],[30,31,30,35],[28,1,28,17],[22,8,22,17],[24,26,24,29],[26,13,26,17],[124,19,124,25],[123,19,123,25],[112,27,112,31],[113,27,113,31],[103,32,103,35],[103,27,103,31],[105,27,105,31],[107,27,107,31],[107,32,107,35],[110,27,110,31],[121,32,121,35],[120,32,120,35],[119,32,119,35],[118,32,118,35],[117,32,117,35],[116,32,116,35],[108,27,108,31],[109,27,109,31],[105,32,105,35],[121,8,121,25],[120,8,120,25],[118,8,118,25],[117,8,117,25],[105,1,105,26],[2,1,3,19],[37,28,37,35],[37,7,37,17],[31,7,31,17],[32,7,32,17],[12,31,12,32],[21,19,21,25],[22,19,22,25],[14,7,14,17],[8,1,8,35],[15,26,15,35],[15,16,15,17],[11,26,11,27],[11,7,11,17],[11,1,11,6],[13,26,13,30],[14,1,14,6],[35,7,35,17],[23,8,23,17],[15,1,15,6],[18,8,18,17],[31,26,31,35],[12,7,12,17],[12,1,12,6],[15,7,15,11],[29,1,29,6],[21,8,21,17],[26,26,26,35],[29,26,29,35],[111,32,111,35],[112,32,112,35],[113,32,113,35],[108,32,108,35],[109,32,109,35],[110,32,110,35],[113,1,113,26],[112,1,112,26],[111,1,111,26],[110,1,110,26],[109,1,109,26],[108,1,108,26],[106,32,106,35],[106,27,106,31],[107,1,107,26],[106,1,106,26],[36,28,36,35],[42,1,42,35],[19,26,19,35]]}
[]
[]
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF(TRIM(PropertyName)<>\"\",TRIM(LEFT(TRIM(PropertyName),30)),\"\")&IF(AND(TRIM(PropertyName)<>\"\",PropertyCity<>\"\",PropertyState<>\"\"),\", \"&TRIM(LEFT(TRIM(PropertyCity),12))&\", \"&PropertyState,\"\")&IF(AND(LoanIdentifier<>\"\",TRIM(PropertyName)<>\"\"),\" (Loan \"&LoanIdentifier&\")\",\"\")","v":""}]
[null,{"$f":"IF(AND(MBAOverallPropertyRatingType<>\"\",MBAOverallPropertyRatingScale<>\"\"),\"Overall Rating: \"&MBAOverallPropertyRatingScale&\" \"&MBAOverallPropertyRatingType,\"\")&IF(AND(TotalPhysicalOccupancyPercent<>\"\",ISERROR(TotalPhysicalOccupancyPercent)<>TRUE,TotalPhysicalOccupancyPercent<>\"sum<>parts\",MBAOverallPropertyRatingType<>\"\",MBAOverallPropertyRatingScale<>\"\"),\", \"&ROUND(TotalPhysicalOccupancyPercent*100,1)&\"% Occupied\",\"\")","v":""}]
[null,{"$f":"DMSummaryText","v":""}]
[]
[null,"General Information"]
[]
[null,"Subject Property"]
[null,"Property Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Property Rating",null,null,null,null,null,null,null,null,null,null,null,"Rating Scale ","MBA"]
[null,"Property Address"]
[null,"Street Address 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Date / Time",null,null,null,null,null,null,null,null,null,null,null,"/"]
[null,"Property City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Property Type"]
[null,"State/Zip/Country",null,null,null,null,null,null,null,null,null,null,"/",null,null,null,{"$f":"IF(PropertyState=\"\",\"\",VLOOKUP(PropertyState,nrStateCountry,2,FALSE))","v":""},null,null,"Secondary Type"]
[]
[null,"Servicer and Loan Information"]
[null,"Servicer Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner of Loan"]
[null,"Loan Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investor Number"]
[null,"Property ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investor Loan Number"]
[null,"Servicer Inspection ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Addt'l ID #1 (editable)"]
[null,"Original Loan Amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Addt'l ID #2 (editable)"]
[null,"Loan Balance (UPB)"]
[null,"Loan Balance Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Manager Name",null,null,null,null,null,null,null,null,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Manager Phone"]
[null,"Report Reviewed By",null,null,null,null,null,null,null,null,null,null,"/",null,null,null,null,null,null,"Asset Manager Email"]
[]
[null,"Inspection Scheduling Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector Information"]
[null,"Contact Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Company"]
[null,"Contact Name",null,null,null,null,null,null,null,null,null,"/",null,null,null,null,null,null,null,"Inspector's Name",null,null,null,null,null,null,null,null,null,null,"/"]
[null,"Contact Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Co. Phone"]
[null,"Contact Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector's ID"]
[]
[null,"Management Company Information / On-Site Contact"]
[null,"Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number"]
[null,"On-Site Contact",null,null,null,null,null,null,null,null,null,"/",null,null,null,null,null,null,null,"Mgmt Interview"]
[null,"Role or Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length of time at property"]
[null,"Mgmt Affiliation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mgmt company change since last inspection"]
[]
[null,"Servicer and Inspector Comments"]
[null,"Lender's or Servicer's General Comments or Instructions to Inspector for Subject Property:"]
[]
[]
[]
[]
[]
[]
[null,"Property Inspector's General Comments or Suggestions to Lender or Servicer on the Subject Property:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Property Profile and Occupancy"]
[null,"Number of Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Occupancy"]
[null,"Number of Floors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Turn Over"]
[null,"Number of Elevators",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rent Roll Obtained"]
[null,"Number of Parking Spaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rent Roll Date"]
[null,"Year Built",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is Property Affordable Housing?"]
[null,"Year Renovated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentages"]
[]
[null,"Unit of Measurement Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Percent Occupied",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(MeasurementUnitType=\"\",\"\",IF(+VacantSpaceValue+OccupiedSpaceValue=IF(MeasurementUnitType=nrSqFeet,NetRentableSquareFootage,NumberOfUnitsRoomsBedsCount),IF(MeasurementUnitType=nrSqFeet,OccupiedSpaceValue/NetRentableSquareFootage,OccupiedSpaceValue/NumberOfUnitsRoomsBedsCount),\"sum<>parts\")),\"\")","v":""}]
[null,"Number of Units/Rooms/Beds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Inspected",null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(OccupiedUnitsInspectedCount),ISBLANK(VacantUnitsInspectedCount)),\"\",OccupiedUnitsInspectedCount+VacantUnitsInspectedCount)","v":""},null,null,null,null,{"$f":"IF(OR(MeasurementUnitType=\"\",MeasurementUnitType=\"Sq. Feet\"),\"\",IF(MeasurementUnitType=\"\",\"\",IF(OR(OccupiedVacantTotalUnitsInspectedCount=\"\",NumberOfUnitsRoomsBedsCount=\"\"),\"\",(OccupiedVacantTotalUnitsInspectedCount/NumberOfUnitsRoomsBedsCount))))","v":""}]
[]
[null,"Occupied Space",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupied Units Inspected",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(MeasurementUnitType=\"\",MeasurementUnitType=\"Sq. Feet\"),\"\",IF(OR(OccupiedSpaceValue=\"\",OccupiedUnitsInspectedCount=\"\"),\"\",(OccupiedUnitsInspectedCount/OccupiedSpaceValue))),\"\")","v":""}]
[null,"Vacant Space",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vacant Units Inspected",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(MeasurementUnitType=\"\",MeasurementUnitType=\"Sq. Feet\"),\"\",IF(MeasurementUnitType=\"\",\"\",IF(OR(VacantSpaceValue=\"\",VacantUnitsInspectedCount=\"\"),\"\",(VacantUnitsInspectedCount/VacantSpaceValue)))),\"\")","v":""}]
[]
[null,"Total Square Feet (Gross)"]
[null,"Total Square Feet (Net / Rentable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If any Dark or Down space, describe:"]
[]
[null,"Is there any Dark space?"]
[null,"Is there any Down space?"]
[null,"Number of Down Units/Rooms/Beds"]
[]
[null,"Property Offers Rental Concessions?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Describe:"]
[null,"Franchise Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Franchise change since last inspection?"]
[]
[null,"Operations and Maintenance plans (O&M)"]
[null,"Plans such as, but not limited to, Operations and Maintenance, Moisture Management and Environmental Remediation."]
[null,"List of O&M Plan(s) Required in Loan Documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Management Aware of Plan?",null,null,null,null,null,null,null,null,"Plan Available?"]
[]
[1]
[2]
[3]
[4]
[5]
[]
[null,"Specify additional O&M plans, and/or describe any observed O&M plan non-compliance."]
[]
[]
[]
[null,"Capital Expenditures"]
[null,"Repairs, Replacements or Capital Improvements within the past 12 or future 12 months.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identified Cost",null,null,null,null,"Status"]
[]
[1,""]
[2,""]
[3,""]
[4,""]
[5,""]
[6,""]
[7,""]
[8,""]
[9,""]
[10,""]
[11,""]
[12,""]
[13,""]
[14,""]
[15,""]
[]
[null,"Neighborhood and Site Comparison Data"]
[null,null,null,null,null,null,null,null,"Top 2 Major Competitors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Use"]
[null,"1. Name or Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family"]
[null,null,"Distance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifamily"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial"]
[null,"2. Name or Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrial"]
[null,null,"Distance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Undeveloped",null,null,null,null,{"$f":"1-nrUsePct","v":1}]
[]
[null,"Is the area declining or distressed?"]
[null,"Is there any new construction in the area?"]
[]
[null,"Describe area, visibility, access, surrounding land use & overall trends (including location in relation to subject N, S, E, W)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Collateral Description Information"]

{"sheet":"Physical Condition & DM","index":4,"n_rows":144,"n_cols":33,"rows_kept":144,"cut":false,"hidden":false,"merged":[[143,32,143,35],[96,32,96,35],[95,32,95,35],[94,32,94,35],[93,32,93,35],[92,32,92,35],[101,32,101,35],[100,32,100,35],[99,32,99,35],[98,32,98,35],[97,32,97,35],[106,32,106,35],[105,32,105,35],[104,32,104,35],[103,32,103,35],[102,32,102,35],[111,32,111,35],[110,32,110,35],[109,32,109,35],[108,32,108,35],[107,32,107,35],[116,32,116,35],[115,32,115,35],[114,32,114,35],[113,32,113,35],[112,32,112,35],[121,32,121,35],[120,32,120,35],[119,32,119,35],[118,32,118,35],[117,32,117,35],[126,32,126,35],[125,32,125,35],[124,32,124,35],[123,32,123,35],[122,32,122,35],[92,30,92,31],[141,32,141,35],[140,32,140,35],[139,32,139,35],[138,32,138,35],[137,32,137,35],[136,32,136,35],[135,32,135,35],[134,32,134,35],[133,32,133,35],[132,32,132,35],[131,32,131,35],[130,32,130,35],[129,32,129,35],[128,32,128,35],[127,32,127,35],[97,30,97,31],[96,30,96,31],[95,30,95,31],[94,30,94,31],[93,30,93,31],[102,30,102,31],[101,30,101,31],[100,30,100,31],[99,30,99,31],[98,30,98,31],[107,30,107,31],[106,30,106,31],[105,30,105,31],[104,30,104,31],[103,30,103,31],[112,30,112,31],[111,30,111,31],[110,30,110,31],[109,30,109,31],[108,30,108,31],[117,30,117,31],[116,30,116,31],[115,30,115,31],[114,30,114,31],[113,30,113,31],[122,30,122,31],[121,30,121,31],[120,30,120,31],[119,30,119,31],[118,30,118,31],[127,30,127,31],[126,30,126,31],[125,30,125,31],[124,30,124,31],[123,30,123,31],[93,28,93,29],[92,28,92,29],[141,30,141,31],[140,30,140,31],[139,30,139,31],[138,30,138,31],[137,30,137,31],[136,30,136,31],[135,30,135,31],[134,30,134,31],[133,30,133,31],[132,30,132,31],[131,30,131,31],[130,30,130,31],[129,30,129,31],[128,30,128,31],[98,28,98,29],[97,28,97,29],[96,28,96,29],[95,28,95,29],[94,28,94,29],[103,28,103,29],[102,28,102,29],[101,28,101,29],[100,28,100,29],[99,28,99,29],[108,28,108,29],[107,28,107,29],[106,28,106,29],[105,28,105,29],[104,28,104,29],[113,28,113,29],[112,28,112,29],[111,28,111,29],[110,28,110,29],[109,28,109,29],[118,28,118,29],[117,28,117,29],[116,28,116,29],[115,28,115,29],[114,28,114,29],[123,28,123,29],[122,28,122,29],[121,28,121,29],[120,28,120,29],[119,28,119,29],[128,28,128,29],[127,28,127,29],[126,28,126,29],[125,28,125,29],[124,28,124,29],[94,26,94,27],[93,26,93,27],[92,26,92,27],[141,28,141,29],[140,28,140,29],[139,28,139,29],[138,28,138,29],[137,28,137,29],[136,28,136,29],[135,28,135,29],[134,28,134,29],[133,28,133,29],[132,28,132,29],[131,28,131,29],[130,28,130,29],[129,28,129,29],[99,26,99,27],[98,26,98,27],[97,26,97,27],[96,26,96,27],[95,26,95,27],[104,26,104,27],[103,26,103,27],[102,26,102,27],[101,26,101,27],[100,26,100,27],[109,26,109,27],[108,26,108,27],[107,26,107,27],[106,26,106,27],[105,26,105,27],[114,26,114,27],[113,26,113,27],[112,26,112,27],[111,26,111,27],[110,26,110,27],[119,26,119,27],[118,26,118,27],[117,26,117,27],[116,26,116,27],[115,26,115,27],[124,26,124,27],[123,26,123,27],[122,26,122,27],[121,26,121,27],[120,26,120,27],[129,26,129,27],[128,26,128,27],[127,26,127,27],[126,26,126,27],[125,26,125,27],[131,1,131,25],[130,1,130,25],[129,1,129,25],[128,1,128,25],[132,26,132,27],[131,26,131,27],[130,26,130,27],[136,1,136,25],[135,1,135,25],[134,1,134,25],[133,1,133,25],[132,1,132,25],[141,1,141,25],[140,1,140,25],[139,1,139,25],[138,1,138,25],[137,1,137,25],[141,26,141,27],[140,26,140,27],[139,26,139,27],[138,26,138,27],[137,26,137,27],[136,26,136,27],[135,26,135,27],[134,26,134,27],[133,26,133,27],[114,1,114,25],[113,1,113,25],[112,1,112,25],[111,1,111,25],[110,1,110,25],[94,1,94,25],[93,1,93,25],[92,1,92,25],[127,1,127,25],[126,1,126,25],[125,1,125,25],[124,1,124,25],[123,1,123,25],[122,1,122,25],[121,1,121,25],[120,1,120,25],[119,1,119,25],[118,1,118,25],[117,1,117,25],[116,1,116,25],[115,1,115,25],[99,1,99,25],[98,1,98,25],[97,1,97,25],[96,1,96,25],[95,1,95,25],[104,1,104,25],[103,1,103,25],[102,1,102,25],[101,1,101,25],[100,1,100,25],[109,1,109,25],[108,1,108,25],[107,1,107,25],[106,1,106,25],[105,1,105,25],[0,1,1,19],[6,1,6,35],[15,1,16,35],[22,1,23,35],[29,1,30,35],[10,9,10,16],[17,9,17,16],[24,9,24,16],[31,9,31,16],[17,28,17,35],[10,28,10,35],[31,28,31,35],[12,9,12,35],[19,9,19,35],[26,9,26,35],[33,9,33,35],[70,1,71,35],[42,1,43,35],[49,1,50,35],[56,1,57,35],[72,9,72,16],[67,9,67,35],[37,9,37,16],[44,9,44,16],[51,9,51,16],[58,9,58,16],[65,9,65,16],[81,9,81,35],[84,1,84,35],[87,1,87,35],[89,32,90,35],[89,30,90,31],[89,28,90,29],[89,26,90,27],[79,9,79,16],[24,28,24,35],[79,28,79,35],[77,1,78,35],[74,9,74,35],[39,9,39,35],[46,9,46,35],[53,9,53,35],[60,9,60,35],[63,1,64,35],[36,1,36,35],[37,28,37,35],[44,28,44,35],[51,28,51,35],[58,28,58,35],[65,28,65,35],[72,28,72,35]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[]
[]
[null,"Physical Condition Assessment and Deferred Maintenance"]
[]
[null,"Curb Appeal"]
[null,"Comparison to Neighborhood; First Impression / Appearance"]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Site"]
[null,"Property Appearance; Signage; Ingress / Egress; Landscaping; Site Lighting; Parking Lot; Striping; Garage / Carports; Irrigation System; Drainage; Retaining Walls; Walkways; Fencing; Refuse Containment & Cleanliness; Hazardous Material Storage"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Building / Mechanical Systems"]
[null,"HVAC; Electrical; Boilers; Water Heaters; Fire Protection; Sprinklers; Plumbing; Sewer; Solar Systems; Elevators / Escalators; Chiller Plant; Cooling Towers; Building Oxygen Systems; Intercom System; PA System; Security Systems "]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Building Exteriors"]
[null,"Siding; Trim; Paint; Windows; Exterior Entry Ways; Stairs; Railings; Balconies; Patios; Gutters; Downspouts; Foundations; Doors; Façade; Structure (Beam/Joist)"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Building Roofs"]
[null,"Roof Condition; Roof Access; Top Floor Ceilings; Shingles / Membrane; Skylights; Flashing; Parapet Walls; Mansard Roofs"]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Occupied Units / Space"]
[null,"HVAC; Ceiling; Floors; Walls; Painting; Wall Cover; Floor Cover; Tiles; Windows; Countertop; Cabinets; Appliances; Lighting; Electrical; Bathroom Accessories; Plumbing Fixtures; Storage; Basements / Attics"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Vacant Units / Space / Hotel Rooms"]
[null,"HVAC; Ceiling; Floors; Walls; Painting; Wall Cover; Floor Cover; Tiles; Windows; Countertop; Cabinets; Appliances; Lighting; Electrical; Bathroom Accessories; Plumbing Fixtures; Storage; Basements / Attics"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Down Units / Space / Hotel Rooms"]
[null,"HVAC; Ceiling; Floors; Walls; Painting; Wall Cover; Floor Cover; Tiles; Windows; Countertop; Cabinets; Appliances; Lighting; Electrical; Bathroom Accessories; Plumbing Fixtures; Storage; Basements / Attics"]
[]
[null,null,"Down Units",null,null,null,null,null,null,{"$f":"IF(DownSpaceIndicator=\"\",\"\",DownSpaceIndicator)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Interior Common Areas  "]
[null,"Mailboxes; Reception Area; Lobby; Food Courts; Dining Areas; Kitchen; Halls; Stairways; Meeting Rooms; Public Restrooms; Storage; Basement; Healthcare Assistance Rooms; Pharmacy / Medication Storage; Nurses Station"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Amenities"]
[null,"Pool; Clubhouse; Gym; Laundry Area / Rooms; Playground; Wireless Access; Restaurant / Bar; Business Center; Sport Courts; Spa; Store; Media Center"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Environmental"]
[null,"Reported spills or leaks; Evidence of spills or leaks; Evidence of distressed vegetation; Evidence of mold; Evidence of O&M non-compliance"]
[]
[null,null,"Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend"]
[]
[null,null,"Inspector Comments"]
[]
[null,"Exterior - Additional description of the property conditions:"]
[]
[]
[null,"Interior - Additional description of the property conditions:"]
[]
[]
[null,{"$f":"\"Deferred Maintenance Items (\"&DMCountPopulated&\") \"&DMSummaryTextOption2","v":"Deferred Maintenance Items (0) "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating",null,"Life Safety",null,"Photo",null,"Estimated Cost"]
[null,"Identify Item and Describe Condition (including location)"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Estimated Cost: ",{"$f":"SUM('Physical Condition & DM'!AG93:AG142)","v":0}]

{"sheet":"Photos","index":5,"n_rows":30,"n_cols":34,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,1,6,34],[0,1,1,19]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[null,{"$f":"IF('General Info'!B7=\"\",\"\",'General Info'!B7)","v":""}]
[]
[null,{"$f":"\"Photos (\"&PicCount&\")\"","v":"Photos (0)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\" DM \"&INDEX('Physical Condition & DM'!$A$93:$A$143,MATCH(VALUE(TRIM(RIGHT(D29,2))),'Physical Condition & DM'!$AE$93:$AE$143,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\" RV \"&INDEX('Repairs Verification'!$A$29:$A$336,MATCH(VALUE(TRIM(RIGHT(D29,2))),'Repairs Verification'!$AP$29:$AP$336,0)),\"\")","v":""}]

{"sheet":"Rent Roll","index":6,"n_rows":23,"n_cols":33,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,32,15,35],[15,28,15,31],[15,24,15,27],[15,20,15,23],[15,16,15,19],[20,32,20,35],[19,32,19,35],[18,32,18,35],[17,32,17,35],[16,32,16,35],[20,28,20,31],[19,28,19,31],[18,28,18,31],[17,28,17,31],[16,28,16,31],[20,24,20,27],[19,24,19,27],[18,24,18,27],[17,24,17,27],[16,24,16,27],[20,20,20,23],[19,20,19,23],[18,20,18,23],[17,20,17,23],[16,20,16,23],[16,1,16,15],[20,16,20,19],[19,16,19,19],[18,16,18,19],[17,16,17,19],[16,16,16,19],[6,1,6,35],[0,1,1,19],[22,1,22,34],[9,15,9,23],[12,20,12,22],[12,33,12,35],[11,20,11,23],[11,11,11,13],[12,11,12,13],[12,27,12,29],[9,11,9,13],[10,11,10,13],[20,1,20,15],[19,1,19,15],[18,1,18,15],[17,1,17,15]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[null,{"$f":"IF('General Info'!B7=\"\",\"\",'General Info'!B7)","v":""}]
[]
[null,"Rent Roll"]
[]
[]
["   ","Rent Roll Attached",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Select One)"]
[null,"Rent Roll Summary Attached"]
[null,"Single Tenant Property",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lease expires:"]
[null,"Hospitality Property",null,null,null,null,null,null,null,null,null,null,null,null,null,"YTD ADR:",null,null,null,null,null,null,null,null,"RevPAR: ",null,null,null,null,null,null,"ADO: "]
[]
[null,"Largest Commercial Tenants"]
[null,"Tenant Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiration",null,null,null,"Sq. Ft.",null,null,null,"%NRA",null,null,null,"Annual Rent",null,null,null,"Rent/Sq. Ft."]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC17<>\"\",U17<>\"\"),AC17/U17,\"\")","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC18<>\"\",U18<>\"\"),AC18/U18,\"\")","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC19<>\"\",U19<>\"\"),AC19/U19,\"\")","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC20<>\"\",U20<>\"\"),AC20/U20,\"\")","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC21<>\"\",U21<>\"\"),AC21/U21,\"\")","v":""}]
[]
[null,"Rent Roll"]

{"sheet":"Mgmt Interview","index":7,"n_rows":83,"n_cols":34,"rows_kept":83,"cut":false,"hidden":false,"merged":[[59,1,59,35],[64,1,64,35],[69,1,69,35],[74,1,74,35],[83,1,83,35],[71,1,71,5],[66,1,66,5],[76,1,76,5],[80,1,80,35],[76,7,77,35],[0,1,1,19],[15,1,15,5],[44,1,44,5],[26,1,26,5],[35,1,35,5],[40,1,40,5],[39,1,39,5],[38,1,38,5],[37,1,37,5],[36,1,36,5],[32,19,32,23],[31,19,31,23],[17,1,17,5],[46,1,46,5],[32,1,32,5],[34,1,34,5],[34,19,34,23],[35,19,35,23],[39,19,39,23],[38,19,38,23],[37,19,37,23],[36,19,36,23],[49,1,49,35],[54,1,54,35],[61,1,61,5],[6,1,6,35],[51,1,51,5],[56,1,56,5],[40,19,40,23],[9,1,9,10],[9,23,9,27],[8,1,8,10],[8,11,8,21],[8,23,8,27],[9,11,9,14],[8,28,8,35],[9,28,9,35],[9,16,9,21],[11,33,11,35],[10,31,10,35],[24,1,24,35],[31,1,31,5],[10,1,10,10],[10,11,10,21],[11,1,11,10],[11,11,11,21],[19,1,19,5],[21,1,21,5],[29,1,29,35]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[null,{"$f":"IF('General Info'!B7=\"\",\"\",'General Info'!B7)","v":""}]
[]
[null,"Management Information & Interview"]
[]
[null,"Management Company Name",null,null,null,null,null,null,null,null,null,{"$f":"IF(PartyRoleManagementCompanyName=\"\",\"\",PartyRoleManagementCompanyName)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Phone Number"]
[null,"Name of Information Source",null,null,null,null,null,null,null,null,null,null,null,null,null,"/",null,null,null,null,null,null,null,"Email Address"]
[null,"Role or Title of Information Source",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length of time at property"]
[null,"Management Affiliation",null,null,null,null,null,null,null,null,null,{"$f":"IF(ManagementAffiliationType = \"\",\"\",ManagementAffiliationType)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Mgmt change from last inspection",null,null,null,null,null,null,null,null,null,{"$f":"IF(ManagementCompanyChangeIndicator=\"\",\"\",ManagementCompanyChangeIndicator)","v":""}]
[]
[null,"Neighborhood and Rental Market"]
[]
[null,null,null,null,null,null,null,"In your opinion, how does the property perform compared to similar properties in the area?"]
[]
[null,null,null,null,null,null,null,"In your opinion, what is the average percentage of vacancy in similar properties in the area?"]
[]
[null,null,null,null,null,null,null,"What is the current average rent paid in the area ($ per square foot/units/beds)?"]
[]
[null,null,null,null,null,null,null,"How does the current vacancy compare to last year at this time?"]
[]
[null,"In your opinion, explain the reason for any variance on vacancy, and rents between the market and the subject property:"]
[]
[]
[null,null,null,null,null,null,null,"Any change to a major employer in the area, or major commercial/retail operation in the area?"]
[]
[null,"If yes, describe:"]
[]
[]
[null,null,null,null,null,null,null,"Amount of the last rental increase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Number of Administration Employees"]
[null,null,null,null,null,null,null,"Date of last rental increase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Number of Maintenance Employees"]
[]
[null,"Utilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenant Profile"]
[null,null,null,null,null,null,null,"Heat at the Property",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Corporate"]
[null,null,null,null,null,null,null,"Water at the Property",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Military"]
[null,null,null,null,null,null,null,"Electric at the Property",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Seasonal"]
[null,null,null,null,null,null,null,"Gas at the Property",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Seniors"]
[null,null,null,null,null,null,null,"Trash at the Property",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Students"]
[null,null,null,null,null,null,null,"Cable at the Property",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1 - (CorporateUsePercent+MilitaryUsePercent+SeasonalUsePercent+SeniorsUsePercent+StudentsUsePercent)","v":1},null,null,null,null,"   Other"]
[]
[null,"Property Events"]
[]
[null,null,null,null,null,null,null,"In the past 12 months, has there been any key employee turnover or any key employee replaced?"]
[]
[null,null,null,null,null,null,null,"In the past 12 months, have there been any fires, significant water intrusion or other property damage?"]
[]
[null,"If yes, explain the location on the property, costs associated, any insurance claims submitted, resolution and leaseability:"]
[]
[]
[null,null,null,null,null,null,null,"In the past 12 months, to the best of your knowledge, have any code violations been received?"]
[]
[null,"If yes, please describe the violation, the costs associated, and any resolution or outstanding issues:"]
[]
[]
[null,null,null,null,null,null,null,"Is the property undergoing any significant rehab/construction?"]
[]
[null,"If yes, explain the location, size and estimated costs:"]
[]
[]
[null,null,null,null,null,null,null,"Any change or violations of a Franchise Agreement or License(s)?"]
[]
[null,"If yes, please explain any change or  violation, costs and any resolution or outstanding issues:"]
[]
[]
[null,null,null,null,null,null,null,"To the best of your knowledge, are there any lawsuits pending that may negatively impact the property?"]
[]
[null,"If yes, please explain:"]
[]
[]
[null,null,null,null,null,null,null,"If a Co-op, has the corporation had the need to use special assessments to cover expenses?"]
[]
[null,"If yes, please explain:"]
[]
[]
[null,null,null,null,null,null,null,"Are there units or corporate leases for the purposes of home sharing (home sharing can be defined as short-term (<1 month) rentals generally marketed through an online platform such as Airbnb)?"]
[]
[]
[null,"If yes, please explain:"]
[]
[]
[null,"Other Information and Management Evaluation Comments:"]

{"sheet":"Multifamily","index":8,"n_rows":116,"n_cols":34,"rows_kept":116,"cut":false,"hidden":false,"merged":[[116,1,116,35],[26,1,26,3],[26,4,26,6],[26,7,26,9],[26,10,26,13],[26,14,26,17],[26,19,26,21],[26,22,26,24],[26,25,26,27],[26,28,26,30],[112,1,112,5],[112,6,112,9],[112,10,112,12],[112,13,112,16],[112,17,112,20],[112,21,112,29],[112,30,112,35],[113,1,113,5],[113,6,113,9],[113,10,113,12],[113,13,113,16],[113,17,113,20],[113,21,113,29],[113,30,113,35],[110,1,110,5],[110,6,110,9],[110,10,110,12],[110,13,110,16],[110,17,110,20],[110,21,110,29],[110,30,110,35],[111,1,111,5],[111,6,111,9],[111,10,111,12],[111,13,111,16],[111,17,111,20],[111,21,111,29],[111,30,111,35],[108,1,108,5],[108,6,108,9],[108,10,108,12],[108,13,108,16],[108,17,108,20],[108,21,108,29],[108,30,108,35],[109,1,109,5],[109,6,109,9],[109,10,109,12],[109,13,109,16],[109,17,109,20],[109,21,109,29],[109,30,109,35],[106,1,106,5],[106,6,106,9],[106,10,106,12],[106,13,106,16],[106,17,106,20],[106,21,106,29],[106,30,106,35],[107,1,107,5],[107,6,107,9],[107,10,107,12],[107,13,107,16],[107,17,107,20],[107,21,107,29],[107,30,107,35],[104,1,104,5],[104,6,104,9],[104,10,104,12],[104,13,104,16],[104,17,104,20],[104,21,104,29],[104,30,104,35],[105,1,105,5],[105,6,105,9],[105,10,105,12],[105,13,105,16],[105,17,105,20],[105,21,105,29],[105,30,105,35],[102,1,102,5],[102,6,102,9],[102,10,102,12],[102,13,102,16],[102,17,102,20],[102,21,102,29],[102,30,102,35],[103,1,103,5],[103,6,103,9],[103,10,103,12],[103,13,103,16],[103,17,103,20],[103,21,103,29],[103,30,103,35],[100,1,100,5],[100,6,100,9],[100,10,100,12],[100,13,100,16],[100,17,100,20],[100,21,100,29],[100,30,100,35],[101,1,101,5],[101,6,101,9],[101,10,101,12],[101,13,101,16],[101,17,101,20],[101,21,101,29],[101,30,101,35],[98,1,98,5],[98,6,98,9],[98,10,98,12],[98,13,98,16],[98,17,98,20],[98,21,98,29],[98,30,98,35],[99,1,99,5],[99,6,99,9],[99,10,99,12],[99,13,99,16],[99,17,99,20],[99,21,99,29],[99,30,99,35],[96,1,96,5],[96,6,96,9],[96,10,96,12],[96,13,96,16],[96,17,96,20],[96,21,96,29],[96,30,96,35],[97,1,97,5],[97,6,97,9],[97,10,97,12],[97,13,97,16],[97,17,97,20],[97,21,97,29],[97,30,97,35],[94,1,94,5],[94,6,94,9],[94,10,94,12],[94,13,94,16],[94,17,94,20],[94,21,94,29],[94,30,94,35],[95,1,95,5],[95,6,95,9],[95,10,95,12],[95,13,95,16],[95,17,95,20],[95,21,95,29],[95,30,95,35],[92,1,92,5],[92,6,92,9],[92,10,92,12],[92,13,92,16],[92,17,92,20],[92,21,92,29],[92,30,92,35],[93,1,93,5],[93,6,93,9],[93,10,93,12],[93,13,93,16],[93,17,93,20],[93,21,93,29],[93,30,93,35],[90,1,90,5],[90,6,90,9],[90,10,90,12],[90,13,90,16],[90,17,90,20],[90,21,90,29],[90,30,90,35],[91,1,91,5],[91,6,91,9],[91,10,91,12],[91,13,91,16],[91,17,91,20],[91,21,91,29],[91,30,91,35],[88,1,88,5],[88,6,88,9],[88,10,88,12],[88,13,88,16],[88,17,88,20],[88,21,88,29],[88,30,88,35],[89,1,89,5],[89,6,89,9],[89,10,89,12],[89,13,89,16],[89,17,89,20],[89,21,89,29],[89,30,89,35],[86,1,86,5],[86,6,86,9],[86,10,86,12],[86,13,86,16],[86,17,86,20],[86,21,86,29],[86,30,86,35],[87,1,87,5],[87,6,87,9],[87,10,87,12],[87,13,87,16],[87,17,87,20],[87,21,87,29],[87,30,87,35],[84,1,84,5],[84,6,84,9],[84,10,84,12],[84,13,84,16],[84,17,84,20],[84,21,84,29],[84,30,84,35],[85,1,85,5],[85,6,85,9],[85,10,85,12],[85,13,85,16],[85,17,85,20],[85,21,85,29],[85,30,85,35],[82,1,82,5],[82,6,82,9],[82,10,82,12],[82,13,82,16],[82,17,82,20],[82,21,82,29],[82,30,82,35],[83,1,83,5],[83,6,83,9],[83,10,83,12],[83,13,83,16],[83,17,83,20],[83,21,83,29],[83,30,83,35],[80,1,80,5],[80,6,80,9],[80,10,80,12],[80,13,80,16],[80,17,80,20],[80,21,80,29],[80,30,80,35],[81,1,81,5],[81,6,81,9],[81,10,81,12],[81,13,81,16],[81,17,81,20],[81,21,81,29],[81,30,81,35],[78,1,78,5],[78,6,78,9],[78,10,78,12],[78,13,78,16],[78,17,78,20],[78,21,78,29],[78,30,78,35],[79,1,79,5],[79,6,79,9],[79,10,79,12],[79,13,79,16],[79,17,79,20],[79,21,79,29],[79,30,79,35],[76,1,76,5],[76,6,76,9],[76,10,76,12],[76,13,76,16],[76,17,76,20],[76,21,76,29],[76,30,76,35],[77,1,77,5],[77,6,77,9],[77,10,77,12],[77,13,77,16],[77,17,77,20],[77,21,77,29],[77,30,77,35],[74,1,74,5],[74,6,74,9],[74,10,74,12],[74,13,74,16],[74,17,74,20],[74,21,74,29],[74,30,74,35],[75,1,75,5],[75,6,75,9],[75,10,75,12],[75,13,75,16],[75,17,75,20],[75,21,75,29],[75,30,75,35],[72,1,72,5],[72,6,72,9],[72,10,72,12],[72,13,72,16],[72,17,72,20],[72,21,72,29],[72,30,72,35],[73,1,73,5],[73,6,73,9],[73,10,73,12],[73,13,73,16],[73,17,73,20],[73,21,73,29],[73,30,73,35],[70,1,70,5],[70,6,70,9],[70,10,70,12],[70,13,70,16],[70,17,70,20],[70,21,70,29],[70,30,70,35],[71,1,71,5],[71,6,71,9],[71,10,71,12],[71,13,71,16],[71,17,71,20],[71,21,71,29],[71,30,71,35],[69,13,69,16],[69,17,69,20],[69,21,69,29],[69,30,69,35],[23,1,23,3],[23,4,23,6],[23,7,23,9],[23,10,23,13],[23,14,23,17],[23,19,23,21],[23,22,23,24],[23,25,23,27],[23,28,23,30],[23,33,23,35],[24,1,24,3],[24,4,24,6],[24,7,24,9],[24,10,24,13],[24,14,24,17],[25,1,25,3],[25,4,25,6],[25,7,25,9],[25,10,25,13],[25,14,25,17],[68,6,68,9],[65,10,65,12],[66,10,66,12],[67,10,67,12],[68,10,68,12],[14,4,14,6],[14,1,14,3],[69,1,69,5],[69,6,69,9],[69,10,69,12],[45,10,45,12],[37,6,37,9],[39,10,39,12],[30,7,30,9],[28,7,28,9],[39,1,39,5],[37,1,37,5],[22,4,22,6],[59,6,59,9],[60,6,60,9],[61,6,61,9],[62,6,62,9],[63,6,63,9],[64,6,64,9],[13,7,13,9],[6,1,6,35],[0,1,1,19],[60,1,60,5],[59,1,59,5],[58,1,58,5],[57,1,57,5],[56,1,56,5],[55,1,55,5],[54,1,54,5],[53,1,53,5],[52,1,52,5],[51,1,51,5],[50,1,50,5],[49,1,49,5],[46,10,46,12],[44,6,44,9],[44,10,44,12],[43,13,43,16],[43,10,43,12],[25,19,25,21],[25,22,25,24],[25,25,25,27],[25,28,25,30],[41,13,41,16],[41,17,41,20],[43,6,43,9],[40,6,40,9],[39,6,39,9],[68,21,68,29],[65,30,65,35],[66,30,66,35],[46,1,46,5],[68,1,68,5],[67,1,67,5],[66,1,66,5],[65,1,65,5],[64,1,64,5],[63,1,63,5],[62,1,62,5],[61,1,61,5],[61,13,61,16],[62,13,62,16],[63,13,63,16],[64,13,64,16],[65,6,65,9],[66,6,66,9],[67,6,67,9],[37,17,37,20],[41,10,41,12],[40,30,40,35],[37,30,37,35],[44,21,44,29],[47,21,47,29],[37,21,37,29],[39,21,39,29],[43,21,43,29],[43,30,43,35],[42,30,42,35],[41,30,41,35],[42,21,42,29],[40,21,40,29],[41,21,41,29],[43,17,43,20],[42,13,42,16],[42,17,42,20],[42,10,42,12],[37,13,37,16],[40,10,40,12],[39,17,39,20],[40,17,40,20],[40,13,40,16],[52,30,52,35],[51,30,51,35],[50,30,50,35],[49,30,49,35],[48,30,48,35],[47,30,47,35],[46,30,46,35],[45,30,45,35],[44,30,44,35],[17,33,17,35],[16,33,16,35],[22,33,22,35],[21,33,21,35],[20,33,20,35],[19,33,19,35],[18,33,18,35],[28,33,28,35],[16,28,16,30],[24,28,24,30],[24,33,24,35],[25,33,25,35],[26,33,26,35],[17,28,17,30],[21,28,21,30],[20,28,20,30],[19,28,19,30],[19,14,19,17],[28,10,28,18],[30,28,30,30],[22,14,22,17],[22,22,22,24],[20,19,20,21],[19,19,19,21],[20,10,20,13],[19,10,19,13],[21,22,21,24],[20,22,20,24],[19,22,19,24],[28,25,28,27],[24,19,24,21],[24,22,24,24],[28,28,28,30],[20,25,20,27],[19,25,19,27],[22,25,22,27],[24,25,24,27],[20,14,20,17],[28,22,28,24],[21,25,21,27],[14,33,14,35],[13,14,13,17],[15,28,15,30],[16,25,16,27],[15,25,15,27],[15,33,15,35],[9,13,9,17],[8,13,8,17],[10,13,10,17],[14,14,14,17],[14,22,14,24],[13,22,13,24],[14,25,14,27],[14,19,14,21],[13,10,13,13],[14,10,14,13],[15,14,15,17],[16,14,16,17],[16,22,16,24],[15,22,15,24],[16,19,16,21],[15,19,15,21],[16,10,16,13],[14,28,14,30],[19,1,19,3],[20,1,20,3],[15,7,15,9],[21,7,21,9],[20,7,20,9],[19,7,19,9],[18,7,18,9],[17,7,17,9],[16,7,16,9],[15,4,15,6],[19,4,19,6],[18,4,18,6],[17,4,17,6],[15,1,15,3],[21,4,21,6],[20,4,20,6],[18,19,18,21],[17,19,17,21],[18,25,18,27],[17,25,17,27],[16,1,16,3],[18,10,18,13],[17,10,17,13],[17,14,17,17],[18,22,18,24],[17,22,17,24],[18,14,18,17],[14,7,14,9],[16,4,16,6],[17,1,17,3],[18,1,18,3],[15,10,15,13],[18,28,18,30],[55,21,55,29],[51,10,51,12],[53,17,53,20],[55,13,55,16],[52,13,52,16],[53,13,53,16],[55,10,55,12],[54,10,54,12],[52,10,52,12],[52,21,52,29],[52,17,52,20],[54,13,54,16],[54,17,54,20],[51,13,51,16],[54,21,54,29],[55,30,55,35],[54,30,54,35],[53,30,53,35],[51,21,51,29],[55,17,55,20],[50,21,50,29],[50,13,50,16],[46,17,46,20],[44,17,44,20],[46,13,46,16],[48,21,48,29],[46,21,46,29],[45,21,45,29],[45,17,45,20],[45,13,45,16],[48,13,48,16],[49,13,49,16],[47,13,47,16],[44,13,44,16],[48,17,48,20],[53,21,53,29],[47,17,47,20],[51,17,51,20],[50,17,50,20],[49,17,49,20],[49,21,49,29],[22,7,22,9],[36,1,36,35],[21,19,21,21],[32,33,32,35],[28,19,28,21],[22,19,22,21],[37,10,37,12],[39,30,39,35],[32,25,32,27],[32,22,32,24],[32,19,32,21],[39,13,39,16],[22,10,22,13],[30,16,30,17],[32,28,32,30],[22,1,22,3],[21,10,21,13],[21,1,21,3],[30,33,30,35],[30,25,30,27],[30,22,30,24],[30,19,30,21],[22,28,22,30],[21,14,21,17],[45,1,45,5],[44,1,44,5],[43,1,43,5],[42,1,42,5],[41,1,41,5],[40,1,40,5],[45,6,45,9],[46,6,46,9],[41,6,41,9],[42,6,42,9],[48,1,48,5],[47,1,47,5],[56,10,56,12],[57,10,57,12],[58,10,58,12],[59,10,59,12],[60,10,60,12],[61,10,61,12],[62,10,62,12],[55,6,55,9],[54,6,54,9],[53,6,53,9],[51,6,51,9],[48,6,48,9],[50,10,50,12],[47,10,47,12],[50,6,50,9],[47,6,47,9],[49,6,49,9],[52,6,52,9],[48,10,48,12],[49,10,49,12],[53,10,53,12],[63,10,63,12],[64,10,64,12],[56,6,56,9],[57,6,57,9],[58,6,58,9],[63,21,63,29],[64,21,64,29],[65,13,65,16],[66,13,66,16],[65,21,65,29],[66,21,66,29],[67,13,67,16],[68,13,68,16],[56,17,56,20],[57,17,57,20],[58,17,58,20],[59,17,59,20],[60,17,60,20],[61,17,61,20],[62,17,62,20],[63,17,63,20],[64,17,64,20],[65,17,65,20],[66,17,66,20],[67,17,67,20],[68,17,68,20],[56,13,56,16],[57,13,57,16],[58,13,58,16],[59,13,59,16],[60,13,60,16],[67,21,67,29],[67,30,67,35],[68,30,68,35],[56,21,56,29],[57,21,57,29],[58,21,58,29],[59,21,59,29],[60,21,60,29],[61,21,61,29],[62,21,62,29],[56,30,56,35],[57,30,57,35],[58,30,58,35],[59,30,59,35],[60,30,60,35],[61,30,61,35],[62,30,62,35],[63,30,63,35],[64,30,64,35]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[null,{"$f":"IF('General Info'!B7=\"\",\"\",'General Info'!B7)","v":""}]
[]
[null,"Multifamily, Mobile Homes, Cooperative Housing, Student Housing"]
[]
[null,"Any Commercial Units?"]
[null,"If yes, how many?"]
[null,"Number Commercial units Inspected:"]
[]
[null,"Multifamily Unit Breakdown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status by unit type"]
[null,null,null,null,null,null,null,"Units of",null,null,"Avg. Square",null,null,null,"Avg. Monthly",null,null,null,null,null,null,null,"Non-"]
[null,"Bedrooms",null,null,"Baths",null,null,"this type",null,null,"Feet / Unit",null,null,null,"Rent",null,null,null,null,"Occupied",null,null,"Revenue",null,null,"Vacant",null,null,"Down",null,null,null,null,"Inspected"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totals:",null,null,null,null,null,{"$f":"SUM(H16:J27)","v":0},null,null,{"$f":"\"(Status by unit type totals \"&SUM(T29:AE29)&\")\"","v":"(Status by unit type totals 0)"},null,null,null,null,null,null,null,null,{"$f":"SUM(T16:V27)","v":0},null,null,{"$f":"SUM(W16:Y27)","v":0},null,null,{"$f":"SUM(Z16:AB27)","v":0},null,null,{"$f":"SUM(AC16:AE27)","v":0},null,null,null,null,{"$f":"SUM(AH16:AJ27)","v":0}]
[]
[null,"General Info:",null,null,null,null,null,{"$f":"NumberOfUnitsRoomsBedsCount","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"OccupiedSpaceValue","v":0},null,null,null,null,null,{"$f":"VacantSpaceValue","v":0},null,null,{"$f":"NumberOfDownUnitsCount","v":0},null,null,null,null,{"$f":"OccupiedUnitsInspectedCount+VacantUnitsInspectedCount","v":0}]
[]
[null,"Detailed Report of Units Inspected:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V40:AD114,\"Occupied*\")","v":0},null,null,{"$f":"COUNTIF(V40:AD114,\"Non-Revenue\")","v":0},null,null,{"$f":"COUNTIF(V40:AD114,\"Vacant*\")","v":0},null,null,{"$f":"COUNTIF(V40:AD114,\"Down Unit\")","v":0},null,null,null,null,{"$f":"T33+W33+Z33+AC33","v":0}]
[]
[]
[]
[null,{"$f":"\"Detailed Report of Units Inspected (\"&AH33&\")\"","v":"Detailed Report of Units Inspected (0)"}]
[null,"Unit Number",null,null,null,null,"Bedrooms",null,null,null,"Baths",null,null,"Square Feet",null,null,null,"Asking Rent",null,null,null,"Current Use",null,null,null,null,null,null,null,null,"Overall Condition"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[]
[null,"General Comments:"]

{"sheet":"Fannie Mae Assmt Addendum","index":9,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[19,1,19,5],[39,11,40,35],[42,1,42,35],[30,1,31,5],[35,1,36,5],[40,1,41,5],[32,1,32,35],[37,1,37,35],[29,11,30,35],[34,11,35,35],[0,1,1,19],[6,1,6,35],[11,1,11,5],[14,1,14,5],[17,1,17,5],[14,7,15,34],[17,7,18,34],[12,1,12,5],[66,8,66,21],[62,8,62,21],[63,8,63,21],[20,1,20,5],[25,1,25,35],[23,1,24,10],[44,11,45,35],[45,1,46,5],[47,1,47,35],[50,11,51,35],[53,1,53,35],[60,17,60,21],[58,1,58,35],[55,11,55,14],[64,8,64,21],[65,8,65,21]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[null,{"$f":"IF('General Info'!B7=\"\",\"\",'General Info'!B7)","v":""}]
[]
[null,"Fannie Mae Assessment Addendum"]
[]
[null,"Limitations of Field Assessment"]
[null,"Did you experience any of the following limitations to performing this field assessment:  (Choose Yes/No)"]
[]
[null,null,null,null,null,null,null,"Management unavailable for interview?"]
[null,null,null,null,null,null,null,"Management experience on the property is less than six months?"]
[]
[null,null,null,null,null,null,null,"Occupied units were unavailable for assessment, or the total number of units available (occupied or unoccupied) was insufficient?"]
[]
[]
[null,null,null,null,null,null,null,"Significant portions of the common areas, amenities or basements, etc. were unavailable for assessment?"]
[]
[null,null,null,null,null,null,null,"Snow was covering most exterior areas (parking lots, roofs, landscape areas)?"]
[null,null,null,null,null,null,null,"Other Limitation"]
[]
[]
[null,"Limitation Comment:"]
[]
[]
[]
[null,"Comprehensive Property Assessment Ratings"]
[]
[null,"Life Safety"]
[null,"Comment:"]
[]
[]
[]
[null,"Deferred Maintenance"]
[null,"Comment:"]
[]
[]
[]
[null,"Routine Maintenance"]
[null,"Comment:"]
[]
[]
[]
[null,"Capital Needs"]
[null,"Comment:"]
[]
[]
[]
[null,"Level/Volume of issues noted and appropriate follow-up recommendations"]
[]
[null,"Comment:"]
[]
[]
[]
[null,"Overall Property Rating:"]
[]
[null,"Additional Comments"]
[]
[]
[null,"Seller/Servicer Certification",null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"First Name:"]
[null,"Last name:"]
[null,"Title:"]
[null,"Phone Number:"]
[null,"Email Address:"]

{"sheet":"FRE Assmt Addendum","index":10,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,32,24,35],[16,2,17,30],[12,1,12,35],[20,1,20,35],[26,1,26,35],[0,1,1,19],[6,1,6,35],[8,32,8,35],[19,2,19,14],[16,32,16,35],[10,2,11,30]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"'General Info'!$B$5","v":""}]
[null,{"$f":"'General Info'!$B$6","v":""}]
[null,{"$f":"'General Info'!$B$7","v":""}]
[]
[null,"Physical Inspection Additional Questions"]
[]
[null,"1.","Are any deferred maintenance items outstanding from the last inspection?"]
[]
[null,null,"If Yes, please specify items that remain outstanding and include impact of outstanding items on overall property appeal and condition:"]
[]
[]
[]
[]
[]
[null,"2.","Was a harmful environmental condition observed which is not covered by an existing O&M plan (such as mold)?"]
[]
[]
[null,null,"If Yes, please discuss below:"]
[]
[]
[]
[]
[null,"3.","Is the property out of compliance with any applicable ADA requirements?"]
[null,null,"If Yes, please discuss below:"]

{"sheet":"Repairs Verification","index":11,"n_rows":336,"n_cols":49,"rows_kept":336,"cut":false,"hidden":false,"merged":[[14,16,14,20],[14,43,14,47],[43,41,43,43],[44,21,44,40],[44,41,44,43],[44,1,44,20],[45,41,45,43],[45,1,45,20],[45,21,45,40],[38,41,38,43],[39,41,39,43],[40,41,40,43],[41,41,41,43],[42,41,42,43],[42,21,42,40],[43,21,43,40],[38,1,38,20],[39,1,39,20],[40,1,40,20],[41,1,41,20],[42,1,42,20],[43,1,43,20],[16,1,16,48],[20,1,24,48],[28,1,28,20],[28,21,28,40],[27,41,27,43],[27,44,27,48],[18,1,19,21],[33,41,33,43],[35,1,35,20],[36,1,36,20],[338,44,338,48],[339,44,339,48],[338,41,338,43],[339,41,339,43],[338,1,338,20],[339,1,339,20],[338,21,338,40],[339,21,339,40],[336,44,336,48],[337,44,337,48],[336,41,336,43],[337,41,337,43],[336,1,336,20],[337,1,337,20],[336,21,336,40],[337,21,337,40],[334,44,334,48],[335,44,335,48],[334,41,334,43],[335,41,335,43],[334,1,334,20],[335,1,335,20],[334,21,334,40],[335,21,335,40],[332,44,332,48],[333,44,333,48],[332,41,332,43],[333,41,333,43],[332,1,332,20],[333,1,333,20],[332,21,332,40],[333,21,333,40],[330,44,330,48],[331,44,331,48],[330,41,330,43],[331,41,331,43],[330,1,330,20],[331,1,331,20],[330,21,330,40],[331,21,331,40],[326,44,326,48],[327,44,327,48],[326,41,326,43],[327,41,327,43],[326,1,326,20],[327,1,327,20],[326,21,326,40],[327,21,327,40],[328,44,328,48],[329,44,329,48],[328,41,328,43],[329,41,329,43],[328,1,328,20],[329,1,329,20],[328,21,328,40],[329,21,329,40],[324,44,324,48],[325,44,325,48],[324,41,324,43],[325,41,325,43],[324,1,324,20],[325,1,325,20],[324,21,324,40],[325,21,325,40],[322,44,322,48],[323,44,323,48],[322,41,322,43],[323,41,323,43],[322,1,322,20],[323,1,323,20],[322,21,322,40],[323,21,323,40],[320,44,320,48],[321,44,321,48],[320,41,320,43],[321,41,321,43],[320,1,320,20],[321,1,321,20],[320,21,320,40],[321,21,321,40],[318,44,318,48],[319,44,319,48],[318,41,318,43],[319,41,319,43],[318,1,318,20],[319,1,319,20],[318,21,318,40],[319,21,319,40],[316,44,316,48],[317,44,317,48],[316,41,316,43],[317,41,317,43],[316,1,316,20],[317,1,317,20],[316,21,316,40],[317,21,317,40],[314,44,314,48],[315,44,315,48],[314,41,314,43],[315,41,315,43],[314,1,314,20],[315,1,315,20],[314,21,314,40],[315,21,315,40],[312,44,312,48],[313,44,313,48],[312,41,312,43],[313,41,313,43],[312,1,312,20],[313,1,313,20],[312,21,312,40],[313,21,313,40],[310,44,310,48],[311,44,311,48],[310,41,310,43],[311,41,311,43],[310,1,310,20],[311,1,311,20],[310,21,310,40],[311,21,311,40],[308,44,308,48],[309,44,309,48],[308,41,308,43],[309,41,309,43],[308,1,308,20],[309,1,309,20],[308,21,308,40],[309,21,309,40],[306,44,306,48],[307,44,307,48],[306,41,306,43],[307,41,307,43],[306,1,306,20],[307,1,307,20],[306,21,306,40],[307,21,307,40],[304,44,304,48],[305,44,305,48],[304,41,304,43],[305,41,305,43],[304,1,304,20],[305,1,305,20],[304,21,304,40],[305,21,305,40],[302,44,302,48],[303,44,303,48],[302,41,302,43],[303,41,303,43],[302,1,302,20],[303,1,303,20],[302,21,302,40],[303,21,303,40],[300,44,300,48],[301,44,301,48],[300,41,300,43],[301,41,301,43],[300,1,300,20],[301,1,301,20],[300,21,300,40],[301,21,301,40],[298,44,298,48],[299,44,299,48],[298,41,298,43],[299,41,299,43],[298,1,298,20],[299,1,299,20],[298,21,298,40],[299,21,299,40],[296,44,296,48],[297,44,297,48],[296,41,296,43],[297,41,297,43],[296,1,296,20],[297,1,297,20],[296,21,296,40],[297,21,297,40],[294,44,294,48],[295,44,295,48],[294,41,294,43],[295,41,295,43],[294,1,294,20],[295,1,295,20],[294,21,294,40],[295,21,295,40],[292,44,292,48],[293,44,293,48],[292,41,292,43],[293,41,293,43],[292,1,292,20],[293,1,293,20],[292,21,292,40],[293,21,293,40],[290,44,290,48],[291,44,291,48],[290,41,290,43],[291,41,291,43],[290,1,290,20],[291,1,291,20],[290,21,290,40],[291,21,291,40],[288,44,288,48],[289,44,289,48],[288,41,288,43],[289,41,289,43],[288,1,288,20],[289,1,289,20],[288,21,288,40],[289,21,289,40],[286,44,286,48],[287,44,287,48],[286,41,286,43],[287,41,287,43],[286,1,286,20],[287,1,287,20],[286,21,286,40],[287,21,287,40],[284,44,284,48],[285,44,285,48],[284,41,284,43],[285,41,285,43],[284,1,284,20],[285,1,285,20],[284,21,284,40],[285,21,285,40],[282,44,282,48],[283,44,283,48],[282,41,282,43],[283,41,283,43],[282,1,282,20],[283,1,283,20],[282,21,282,40],[283,21,283,40],[280,44,280,48],[281,44,281,48],[280,41,280,43],[281,41,281,43],[280,1,280,20],[281,1,281,20],[280,21,280,40],[281,21,281,40],[278,44,278,48],[279,44,279,48],[278,41,278,43],[279,41,279,43],[278,1,278,20],[279,1,279,20],[278,21,278,40],[279,21,279,40],[276,44,276,48],[277,44,277,48],[276,41,276,43],[277,41,277,43],[276,1,276,20],[277,1,277,20],[276,21,276,40],[277,21,277,40],[274,44,274,48],[275,44,275,48],[274,41,274,43],[275,41,275,43],[274,1,274,20],[275,1,275,20],[274,21,274,40],[275,21,275,40],[272,44,272,48],[273,44,273,48],[272,41,272,43],[273,41,273,43],[272,1,272,20],[273,1,273,20],[272,21,272,40],[273,21,273,40],[270,44,270,48],[271,44,271,48],[270,41,270,43],[271,41,271,43],[270,1,270,20],[271,1,271,20],[270,21,270,40],[271,21,271,40],[268,44,268,48],[269,44,269,48],[268,41,268,43],[269,41,269,43],[268,1,268,20],[269,1,269,20],[268,21,268,40],[269,21,269,40],[266,44,266,48],[267,44,267,48],[266,41,266,43],[267,41,267,43],[266,1,266,20],[267,1,267,20],[266,21,266,40],[267,21,267,40],[264,44,264,48],[265,44,265,48],[264,41,264,43],[265,41,265,43],[264,1,264,20],[265,1,265,20],[264,21,264,40],[265,21,265,40],[262,44,262,48],[263,44,263,48],[262,41,262,43],[263,41,263,43],[262,1,262,20],[263,1,263,20],[262,21,262,40],[263,21,263,40],[260,44,260,48],[261,44,261,48],[260,41,260,43],[261,41,261,43],[260,1,260,20],[261,1,261,20],[260,21,260,40],[261,21,261,40],[258,44,258,48],[259,44,259,48],[258,41,258,43],[259,41,259,43],[258,1,258,20],[259,1,259,20],[258,21,258,40],[259,21,259,40],[256,44,256,48],[257,44,257,48],[256,41,256,43],[257,41,257,43],[256,1,256,20],[257,1,257,20],[256,21,256,40],[257,21,257,40],[254,44,254,48],[255,44,255,48],[254,41,254,43],[255,41,255,43],[254,1,254,20],[255,1,255,20],[254,21,254,40],[255,21,255,40],[252,44,252,48],[253,44,253,48],[252,41,252,43],[253,41,253,43],[252,1,252,20],[253,1,253,20],[252,21,252,40],[253,21,253,40],[250,44,250,48],[251,44,251,48],[250,41,250,43],[251,41,251,43],[250,1,250,20],[251,1,251,20],[250,21,250,40],[251,21,251,40],[248,44,248,48],[249,44,249,48],[248,41,248,43],[249,41,249,43],[248,1,248,20],[249,1,249,20],[248,21,248,40],[249,21,249,40],[246,44,246,48],[247,44,247,48],[246,41,246,43],[247,41,247,43],[246,1,246,20],[247,1,247,20],[246,21,246,40],[247,21,247,40],[244,44,244,48],[245,44,245,48],[244,41,244,43],[245,41,245,43],[244,1,244,20],[245,1,245,20],[244,21,244,40],[245,21,245,40],[242,44,242,48],[243,44,243,48],[242,41,242,43],[243,41,243,43],[242,1,242,20],[243,1,243,20],[242,21,242,40],[243,21,243,40],[240,44,240,48],[241,44,241,48],[240,41,240,43],[241,41,241,43],[240,1,240,20],[241,1,241,20],[240,21,240,40],[241,21,241,40],[238,44,238,48],[239,44,239,48],[238,41,238,43],[239,41,239,43],[238,1,238,20],[239,1,239,20],[238,21,238,40],[239,21,239,40],[236,44,236,48],[237,44,237,48],[236,41,236,43],[237,41,237,43],[236,1,236,20],[237,1,237,20],[236,21,236,40],[237,21,237,40],[234,44,234,48],[235,44,235,48],[234,41,234,43],[235,41,235,43],[234,1,234,20],[235,1,235,20],[234,21,234,40],[235,21,235,40],[232,44,232,48],[233,44,233,48],[232,41,232,43],[233,41,233,43],[232,1,232,20],[233,1,233,20],[232,21,232,40],[233,21,233,40],[230,44,230,48],[231,44,231,48],[230,41,230,43],[231,41,231,43],[230,1,230,20],[231,1,231,20],[230,21,230,40],[231,21,231,40],[228,44,228,48],[229,44,229,48],[228,41,228,43],[229,41,229,43],[228,1,228,20],[229,1,229,20],[228,21,228,40],[229,21,229,40],[226,44,226,48],[227,44,227,48],[226,41,226,43],[227,41,227,43],[226,1,226,20],[227,1,227,20],[226,21,226,40],[227,21,227,40],[224,44,224,48],[225,44,225,48],[224,41,224,43],[225,41,225,43],[224,1,224,20],[225,1,225,20],[224,21,224,40],[225,21,225,40],[222,44,222,48],[223,44,223,48],[222,41,222,43],[223,41,223,43],[222,1,222,20],[223,1,223,20],[222,21,222,40],[223,21,223,40],[220,44,220,48],[221,44,221,48],[220,41,220,43],[221,41,221,43],[220,1,220,20],[221,1,221,20],[220,21,220,40],[221,21,221,40],[218,44,218,48],[219,44,219,48],[218,41,218,43],[219,41,219,43],[218,1,218,20],[219,1,219,20],[218,21,218,40],[219,21,219,40],[216,44,216,48],[217,44,217,48],[216,41,216,43],[217,41,217,43],[216,1,216,20],[217,1,217,20],[216,21,216,40],[217,21,217,40],[214,44,214,48],[215,44,215,48],[214,41,214,43],[215,41,215,43],[214,1,214,20],[215,1,215,20],[214,21,214,40],[215,21,215,40],[212,44,212,48],[213,44,213,48],[212,41,212,43],[213,41,213,43],[212,1,212,20],[213,1,213,20],[212,21,212,40],[213,21,213,40],[210,44,210,48],[211,44,211,48],[210,41,210,43],[211,41,211,43],[210,1,210,20],[211,1,211,20],[210,21,210,40],[211,21,211,40],[208,44,208,48],[209,44,209,48],[208,41,208,43],[209,41,209,43],[208,1,208,20],[209,1,209,20],[208,21,208,40],[209,21,209,40],[206,44,206,48],[207,44,207,48],[206,41,206,43],[207,41,207,43],[206,1,206,20],[207,1,207,20],[206,21,206,40],[207,21,207,40],[204,44,204,48],[205,44,205,48],[204,41,204,43],[205,41,205,43],[204,1,204,20],[205,1,205,20],[204,21,204,40],[205,21,205,40],[202,44,202,48],[203,44,203,48],[202,41,202,43],[203,41,203,43],[202,1,202,20],[203,1,203,20],[202,21,202,40],[203,21,203,40],[200,44,200,48],[201,44,201,48],[200,41,200,43],[201,41,201,43],[200,1,200,20],[201,1,201,20],[200,21,200,40],[201,21,201,40],[198,44,198,48],[199,44,199,48],[198,41,198,43],[199,41,199,43],[198,1,198,20],[199,1,199,20],[198,21,198,40],[199,21,199,40],[196,44,196,48],[197,44,197,48],[196,41,196,43],[197,41,197,43],[196,1,196,20],[197,1,197,20],[196,21,196,40],[197,21,197,40],[194,44,194,48],[195,44,195,48],[194,41,194,43],[195,41,195,43],[194,1,194,20],[195,1,195,20],[194,21,194,40],[195,21,195,40],[192,44,192,48],[193,44,193,48],[192,41,192,43],[193,41,193,43],[192,1,192,20],[193,1,193,20],[192,21,192,40],[193,21,193,40],[190,44,190,48],[191,44,191,48],[190,41,190,43],[191,41,191,43],[190,1,190,20],[191,1,191,20],[190,21,190,40],[191,21,191,40],[188,44,188,48],[189,44,189,48],[188,41,188,43],[189,41,189,43],[188,1,188,20],[189,1,189,20],[188,21,188,40],[189,21,189,40],[186,44,186,48],[187,44,187,48],[186,41,186,43],[187,41,187,43],[186,1,186,20],[187,1,187,20],[186,21,186,40],[187,21,187,40],[184,44,184,48],[185,44,185,48],[184,41,184,43],[185,41,185,43],[184,1,184,20],[185,1,185,20],[184,21,184,40],[185,21,185,40],[182,44,182,48],[183,44,183,48],[182,41,182,43],[183,41,183,43],[182,1,182,20],[183,1,183,20],[182,21,182,40],[183,21,183,40],[180,44,180,48],[181,44,181,48],[180,41,180,43],[181,41,181,43],[180,1,180,20],[181,1,181,20],[180,21,180,40],[181,21,181,40],[178,44,178,48],[179,44,179,48],[178,41,178,43],[179,41,179,43],[178,1,178,20],[179,1,179,20],[178,21,178,40],[179,21,179,40],[176,44,176,48],[177,44,177,48],[176,41,176,43],[177,41,177,43],[176,1,176,20],[177,1,177,20],[176,21,176,40],[177,21,177,40],[174,44,174,48],[175,44,175,48],[174,41,174,43],[175,41,175,43],[174,1,174,20],[175,1,175,20],[174,21,174,40],[175,21,175,40],[172,44,172,48],[173,44,173,48],[172,41,172,43],[173,41,173,43],[172,1,172,20],[173,1,173,20],[172,21,172,40],[173,21,173,40],[170,44,170,48],[171,44,171,48],[170,41,170,43],[171,41,171,43],[170,1,170,20],[171,1,171,20],[170,21,170,40],[171,21,171,40],[168,44,168,48],[169,44,169,48],[168,41,168,43],[169,41,169,43],[168,1,168,20],[169,1,169,20],[168,21,168,40],[169,21,169,40],[166,44,166,48],[167,44,167,48],[166,41,166,43],[167,41,167,43],[166,1,166,20],[167,1,167,20],[166,21,166,40],[167,21,167,40],[164,44,164,48],[165,44,165,48],[164,41,164,43],[165,41,165,43],[164,1,164,20],[165,1,165,20],[164,21,164,40],[165,21,165,40],[162,44,162,48],[163,44,163,48],[162,41,162,43],[163,41,163,43],[162,1,162,20],[163,1,163,20],[162,21,162,40],[163,21,163,40],[160,44,160,48],[161,44,161,48],[160,41,160,43],[161,41,161,43],[160,1,160,20],[161,1,161,20],[160,21,160,40],[161,21,161,40],[158,44,158,48],[159,44,159,48],[158,41,158,43],[159,41,159,43],[158,1,158,20],[159,1,159,20],[158,21,158,40],[159,21,159,40],[156,44,156,48],[157,44,157,48],[156,41,156,43],[157,41,157,43],[156,1,156,20],[157,1,157,20],[156,21,156,40],[157,21,157,40],[154,44,154,48],[155,44,155,48],[154,41,154,43],[155,41,155,43],[154,1,154,20],[155,1,155,20],[154,21,154,40],[155,21,155,40],[152,44,152,48],[153,44,153,48],[152,41,152,43],[153,41,153,43],[152,1,152,20],[153,1,153,20],[152,21,152,40],[153,21,153,40],[150,44,150,48],[151,44,151,48],[150,41,150,43],[151,41,151,43],[150,1,150,20],[151,1,151,20],[150,21,150,40],[151,21,151,40],[148,44,148,48],[149,44,149,48],[148,41,148,43],[149,41,149,43],[148,1,148,20],[149,1,149,20],[148,21,148,40],[149,21,149,40],[146,44,146,48],[147,44,147,48],[146,41,146,43],[147,41,147,43],[146,1,146,20],[147,1,147,20],[146,21,146,40],[147,21,147,40],[144,44,144,48],[145,44,145,48],[144,41,144,43],[145,41,145,43],[144,1,144,20],[145,1,145,20],[144,21,144,40],[145,21,145,40],[142,44,142,48],[143,44,143,48],[142,41,142,43],[143,41,143,43],[142,1,142,20],[143,1,143,20],[142,21,142,40],[143,21,143,40],[140,44,140,48],[141,44,141,48],[140,41,140,43],[141,41,141,43],[140,1,140,20],[141,1,141,20],[140,21,140,40],[141,21,141,40],[138,44,138,48],[139,44,139,48],[138,41,138,43],[139,41,139,43],[138,1,138,20],[139,1,139,20],[138,21,138,40],[139,21,139,40],[136,44,136,48],[137,44,137,48],[136,41,136,43],[137,41,137,43],[136,1,136,20],[137,1,137,20],[136,21,136,40],[137,21,137,40],[134,44,134,48],[135,44,135,48],[134,41,134,43],[135,41,135,43],[134,1,134,20],[135,1,135,20],[134,21,134,40],[135,21,135,40],[132,44,132,48],[133,44,133,48],[132,41,132,43],[133,41,133,43],[132,1,132,20],[133,1,133,20],[132,21,132,40],[133,21,133,40],[130,44,130,48],[131,44,131,48],[130,41,130,43],[131,41,131,43],[130,1,130,20],[131,1,131,20],[130,21,130,40],[131,21,131,40],[128,44,128,48],[129,44,129,48],[128,41,128,43],[129,41,129,43],[128,1,128,20],[129,1,129,20],[128,21,128,40],[129,21,129,40],[126,44,126,48],[127,44,127,48],[126,41,126,43],[127,41,127,43],[126,1,126,20],[127,1,127,20],[126,21,126,40],[127,21,127,40],[124,44,124,48],[125,44,125,48],[124,41,124,43],[125,41,125,43],[124,1,124,20],[125,1,125,20],[124,21,124,40],[125,21,125,40],[122,44,122,48],[123,44,123,48],[122,41,122,43],[123,41,123,43],[122,1,122,20],[123,1,123,20],[122,21,122,40],[123,21,123,40],[120,44,120,48],[121,44,121,48],[120,41,120,43],[121,41,121,43],[120,1,120,20],[121,1,121,20],[120,21,120,40],[121,21,121,40],[118,44,118,48],[119,44,119,48],[118,41,118,43],[119,41,119,43],[118,1,118,20],[119,1,119,20],[118,21,118,40],[119,21,119,40],[116,44,116,48],[117,44,117,48],[116,41,116,43],[117,41,117,43],[116,1,116,20],[117,1,117,20],[116,21,116,40],[117,21,117,40],[114,44,114,48],[115,44,115,48],[114,41,114,43],[115,41,115,43],[114,1,114,20],[115,1,115,20],[114,21,114,40],[115,21,115,40],[112,44,112,48],[113,44,113,48],[112,41,112,43],[113,41,113,43],[112,1,112,20],[113,1,113,20],[112,21,112,40],[113,21,113,40],[110,44,110,48],[111,44,111,48],[110,41,110,43],[111,41,111,43],[110,1,110,20],[111,1,111,20],[110,21,110,40],[111,21,111,40],[108,44,108,48],[109,44,109,48],[108,41,108,43],[109,41,109,43],[108,1,108,20],[109,1,109,20],[108,21,108,40],[109,21,109,40],[106,44,106,48],[107,44,107,48],[106,41,106,43],[107,41,107,43],[106,1,106,20],[107,1,107,20],[106,21,106,40],[107,21,107,40],[104,44,104,48],[105,44,105,48],[104,41,104,43],[105,41,105,43],[104,1,104,20],[105,1,105,20],[104,21,104,40],[105,21,105,40],[102,44,102,48],[103,44,103,48],[102,41,102,43],[103,41,103,43],[102,1,102,20],[103,1,103,20],[102,21,102,40],[103,21,103,40],[100,44,100,48],[101,44,101,48],[100,41,100,43],[101,41,101,43],[100,1,100,20],[101,1,101,20],[100,21,100,40],[101,21,101,40],[98,44,98,48],[99,44,99,48],[98,41,98,43],[99,41,99,43],[98,1,98,20],[99,1,99,20],[98,21,98,40],[99,21,99,40]],"merged_total":1288,"flags":["merged_cut"]}
[null,"MBA Standard Inspection Form"]
[]
[]
[null,null,"Subject Property",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Scheduling Contact Information"]
[null,null,"Property 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,"Contact Company"]
[null,null,"Property Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name",null,null,null,null,null,null,null,null,null,null,null,"/"]
[null,null,"Street Address 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Phone"]
[null,null,"Property City",null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Email"]
[null,null,"State/Zip/Country",null,null,null,null,null,null,null,null,null,null,null,"/",null,null,null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,nrStateCountry,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Company"]
[null,null,"Servicer 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,"Inspector's Name",null,null,null,null,null,null,null,null,null,null,null,"/"]
[null,null,"Loan Number",null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Co. Phone"]
[null,null,"Primary Property Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Date / Time",null,null,null,null,null,null,null,null,null,null,null,"/"]
[]
[null,null,"Expected percentage completed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall observed percentage completed:"]
[]
[null,"Repairs Verification"]
[]
[null,"General description of improvements and summary comments:"]
[]
[]
[]
[]
[]
[]
[null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,{"$f":"\"Verification Items\"&\" (\"&RVrowsPopulated&\")\"","v":"Verification Items (0)"}]
[null,"Item Description and Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Photo ",null,null,"Repair Status"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]

{"sheet":"Senior Supplement","index":12,"n_rows":230,"n_cols":41,"rows_kept":230,"cut":false,"hidden":false,"merged":[[147,1,147,40],[151,1,151,40],[93,1,93,40],[96,1,96,40],[38,30,41,32],[39,21,41,23],[35,9,35,14],[37,9,37,14],[69,21,69,24],[68,21,68,24],[45,33,45,40],[44,33,44,40],[43,33,43,40],[67,21,67,24],[76,16,76,20],[75,16,75,20],[68,16,68,20],[67,16,67,20],[76,25,76,40],[75,25,75,40],[74,25,74,40],[73,25,73,40],[81,16,81,20],[82,16,82,20],[23,9,23,14],[33,9,33,14],[24,9,24,14],[15,9,15,14],[34,9,34,14],[25,9,25,14],[16,9,16,14],[139,1,139,40],[143,1,143,40],[72,25,72,40],[70,25,70,40],[69,25,69,40],[68,25,68,40],[67,25,67,40],[66,25,66,40],[71,25,71,40],[76,21,76,24],[75,21,75,24],[74,21,74,24],[73,21,73,24],[72,21,72,24],[71,21,71,24],[70,21,70,24],[77,21,77,40],[229,37,229,40],[231,1,231,40],[20,1,21,39],[222,26,222,40],[221,26,221,40],[220,26,220,40],[219,26,219,40],[218,26,218,40],[217,26,217,40],[225,37,225,40],[227,1,227,40],[222,16,222,20],[221,16,221,20],[220,16,220,20],[219,16,219,20],[218,16,218,20],[217,16,217,20],[222,21,222,25],[221,21,221,25],[220,21,220,25],[219,21,219,25],[218,21,218,25],[217,21,217,25],[192,21,192,40],[203,16,203,20],[202,16,202,20],[203,21,203,40],[202,21,202,40],[210,16,210,20],[215,16,215,20],[214,16,214,20],[213,16,213,20],[212,16,212,20],[211,16,211,20],[210,21,210,40],[215,21,215,40],[214,21,214,40],[213,21,213,40],[212,21,212,40],[211,21,211,40],[205,37,205,40],[200,21,200,40],[199,21,199,40],[198,21,198,40],[197,21,197,40],[196,21,196,40],[195,21,195,40],[194,21,194,40],[193,21,193,40],[192,16,192,20],[200,16,200,20],[199,16,199,20],[198,16,198,20],[197,16,197,20],[196,16,196,20],[195,16,195,20],[194,16,194,20],[193,16,193,20],[182,1,182,40],[187,16,187,40],[186,16,186,40],[185,16,185,40],[190,16,190,20],[156,23,157,40],[175,15,175,18],[175,19,175,27],[175,28,175,40],[180,1,180,14],[179,1,179,14],[178,1,178,14],[177,1,177,14],[176,1,176,14],[180,15,180,18],[179,15,179,18],[178,15,178,18],[177,15,177,18],[176,15,176,18],[180,19,180,27],[179,19,179,27],[178,19,178,27],[177,19,177,27],[176,19,176,27],[180,28,180,40],[179,28,179,40],[178,28,178,40],[177,28,177,40],[176,28,176,40],[169,23,169,40],[168,23,168,40],[166,23,166,40],[165,23,165,40],[164,23,164,40],[163,23,163,40],[162,23,162,40],[161,23,161,40],[160,23,160,40],[159,23,159,40],[158,23,158,40],[169,18,169,22],[168,18,168,22],[166,18,166,22],[165,18,165,22],[164,18,164,22],[163,18,163,22],[162,18,162,22],[161,18,161,22],[160,18,160,22],[159,18,159,22],[158,18,158,22],[156,18,157,22],[0,1,1,19],[39,27,41,29],[41,33,41,40],[88,21,88,25],[74,16,74,20],[73,16,73,20],[72,16,72,20],[71,16,71,20],[70,16,70,20],[69,16,69,20],[77,16,77,20],[43,21,43,23],[42,21,42,23],[45,16,45,20],[44,16,44,20],[43,16,43,20],[42,16,42,20],[49,21,49,23],[47,21,47,23],[46,21,46,23],[44,21,44,23],[42,33,42,40],[49,27,49,29],[6,1,6,40],[15,16,17,40],[33,16,35,40],[24,16,26,40],[29,1,30,40],[41,16,41,20],[52,1,53,14],[52,16,52,20],[52,21,54,40],[50,30,50,32],[50,24,50,26],[47,16,47,20],[46,16,46,20],[43,30,43,32],[42,30,42,32],[49,30,49,32],[47,33,47,40],[46,33,46,40],[47,30,47,32],[46,30,46,32],[45,30,45,32],[44,30,44,32],[43,24,43,26],[42,24,42,26],[9,1,9,40],[45,21,45,23],[65,16,65,20],[65,21,65,24],[65,25,65,40],[66,21,66,24],[49,24,49,26],[47,24,47,26],[46,24,46,26],[45,24,45,26],[44,24,44,26],[61,1,61,40],[47,27,47,29],[46,27,46,29],[45,27,45,29],[44,27,44,29],[43,27,43,29],[42,27,42,29],[38,24,41,26],[66,16,66,20],[26,9,26,14],[17,9,17,14],[14,9,14,14],[32,9,32,14],[82,21,82,40],[83,16,83,20],[83,21,83,40],[81,21,81,40],[80,16,80,20],[79,16,79,20],[78,16,78,20],[80,21,80,40],[79,21,79,40],[78,21,78,40],[91,16,91,20],[90,16,90,20],[89,16,89,20],[91,21,91,40],[90,21,90,40],[89,21,89,40],[100,16,100,18],[104,16,104,18],[103,16,103,18],[102,16,102,18],[101,16,101,18],[104,19,104,21],[84,16,84,20],[87,21,87,40],[86,21,86,40],[85,21,85,40],[84,21,84,40],[87,16,87,20],[86,16,86,20],[85,16,85,20],[88,16,88,20],[110,21,110,40],[103,19,103,21],[102,19,102,21],[101,19,101,21],[100,19,100,21],[101,22,101,24],[100,22,100,24],[104,25,104,40],[103,25,103,40],[102,25,102,40],[101,25,101,40],[100,25,100,40],[104,22,104,24],[103,22,103,24],[102,22,102,24],[124,16,124,20],[124,21,124,40],[128,21,128,40],[127,21,127,40],[126,21,126,40],[125,21,125,40],[106,1,106,40],[110,16,110,20],[118,16,118,20],[117,16,117,20],[116,16,116,20],[115,16,115,20],[114,16,114,20],[113,16,113,20],[112,16,112,20],[111,16,111,20],[118,21,118,40],[117,21,117,40],[116,21,116,40],[115,21,115,40],[114,21,114,40],[113,21,113,40],[112,21,112,40],[111,21,111,40],[207,2,208,15],[207,16,208,40],[56,1,57,14],[56,16,57,40],[59,21,59,40],[134,1,135,23],[134,25,135,40],[171,1,172,20],[171,22,172,40],[154,1,154,40],[132,16,132,20],[131,16,131,20],[132,36,132,40],[131,36,131,40],[122,16,122,20],[121,16,121,20],[120,16,120,20],[120,21,120,40],[122,21,122,40],[121,21,121,40],[128,16,128,20],[127,16,127,20],[126,16,126,20],[125,16,125,20]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"'General Info'!$B$5","v":""}]
[null,{"$f":"'General Info'!$B$6","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PartyRoleManagementCompanyName=\"\",\"Name of Operator:                                          \",\"Name of Operator: \"&PartyRoleManagementCompanyName)","v":"Name of Operator:                                          "}]
[]
[]
[null,"Senior Housing Supplement"]
[]
[null,"Part I:  Physical Inspection"]
[null,"Indicate condition of seniors housing components below. Any identified repair costs are strictly for seniors housing components and should not have already been identified on the Physical Condition/DM tab. "]
[]
[null,"Site (Seniors)"]
[null,"Bus-Van-Handicapped Parking; Building Accessibility; Outdoor Activity Area; Generator"]
[]
[null,"Current Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector Comments"]
[null,"Trend"]
[null,"Repair Cost"]
[null,"Life safety"]
[]
[null,"Interior Common Areas (Seniors)"]
[null,"Healthcare Assistance Rooms; Pharmacy/Medication Storage; Nurses Station; Bathing Assistance Areas; Employee Restroom; Facility Furniture; Kitchen; Pantry-Supplies Storage; Common/Private Dining Areas"]
[]
[]
[null,"Current Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector Comments"]
[null,"Trend"]
[null,"Repair Cost"]
[null,"Life safety"]
[]
[null,"Amenities (Seniors)"]
[null,"Television-Sitting Areas; Exercise-Wellness Room; Game-Entertainment Room; Library-Reading Room; Craft-Activity Room; Beauty/Barber Shop; Sundry Shop; Family-Meeting Area; Garden; Wheelchairs-Walkers"]
[]
[]
[null,"Current Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector Comments"]
[null,"Trend"]
[null,"Repair Cost"]
[null,"Life safety"]
[]
[null,"Total Repair Cost",null,null,null,null,null,null,null,{"$f":"IF((SHSInspectionSiteRepairCost+SHSInspectionInteriorRepairCost+SHSInspectionAmenitiesRepairCost)>0,(SHSInspectionSiteRepairCost+SHSInspectionInteriorRepairCost+SHSInspectionAmenitiesRepairCost),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Units Currently Occupied",null,null,null,null,null,"# of Beds Currently Occupied"]
[null,"Part II:  Resident Rooms/Occupancy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total # \nof units",null,null,null,null,null,"Total #\nof Beds"]
[]
[null,"Types of Services Provided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resident Payor Type"]
[null,"Independent Living"]
[null,"Congregate Care Retirement Community (CCRC)"]
[null,"Assisted Living"]
[null,"Alzheimer's/Memory Care"]
[null,"Skilled Nursing"]
[null,"Other (specify)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",null,null,null,null,null,{"$f":"IF(SUM(V43:V48)=0,\"\",SUM(V43:V48))","v":""},null,null,{"$f":"IF(SUM(Y43:Y48)=0,\"\",SUM(Y43:Y48))","v":""},null,null,{"$f":"IF(SUM(AB43:AB48)=0,\"\",SUM(AB43:AB48))","v":""},null,null,{"$f":"IF(SUM(AE43:AE48)=0,\"\",SUM(AE43:AE48))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupancy %: ",null,null,null,null,null,null,null,null,{"$f":"IF(ISERR(Y50/V50),\"\",Y50/V50)","v":""},null,null,null,null,null,{"$f":"IF(ISERR(AE50/AB50),\"\",AE50/AB50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit mix comment:"]
[null,"Does the current unit mix comply with the unit mix specified in the Mortgage?"]
[]
[]
[]
[null,"How many days does it take to turn a resident unit? Explain if more than 2 days."]
[]
[]
[null,"How many units are currently being prepared for re-tenanting?"]
[]
[null,"Part III:  Resident Services"]
[]
[null,"Indicate which services are included in resident's basic fee and frequency of service, where applicable."]
[]
[null,"Resident Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Frequency",null,null,null,"Comments"]
[null,"24-hour nursing care"]
[null,"Physician service"]
[null,"Medication assistance"]
[null,"Specialized dietary services"]
[null,"Meals"]
[null,"Regular health assessments"]
[null,"Scheduled transportation"]
[null,"Unscheduled transportation"]
[null,"Social and activity programs"]
[null,"Housekeeping"]
[null,"Laundry service"]
[null,"Safety & Security",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"Exit doors alarmed"]
[null,"Wandergard/Elopement system"]
[null,"Dementia unit secured"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantity",null,null,null,null,"Locations"]
[null,"Nurses stations"]
[null,"Meal Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"Licensed dietician on staff"]
[null,"Menu choices available"]
[null,"Snacks available"]
[null,"Meals delivered to units"]
[null,"Medication Administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"Staff utilizes medication aides"]
[null,"Staff utilizes medication cart"]
[null,"Medication room secured"]
[null,"List staff that is permitted to administer resident medication:"]
[]
[]
[null,"Indicate how resident medication is documented:"]
[]
[]
[]
[]
[null,"Direct Care Personnel  (Staff on Duty)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day",null,null,"Evening",null,null,"Night",null,null,"Comments"]
[null,"RN's"]
[null,"LPN's"]
[null,"Other"]
[null,"Administrative Personnel"]
[]
[null,"Part IV:  Management"]
[]
[null,"Are there written Policies & Procedures in place for the following:"]
[null,"Inspector's Discussion with Management Staff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"ADA & Fair Housing"]
[null,"Contracting & purchasing"]
[null,"Emergency evacuation"]
[null,"Employee performance"]
[null,"Incident reporting"]
[null,"Resident care"]
[null,"Transferring resident to/from assisted living"]
[null,"Transferring resident to/from health care facility"]
[]
[null,"Property Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"Property annual budget (attach copy)"]
[null,"Planned capital improvements in next 12 months"]
[]
[null,"Property Staffing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"If Yes, how often?"]
[null,"Scheduled meetings with staff"]
[null,"Scheduled meetings with residents"]
[null,"Social & Activities program for residents"]
[null,"Employee training opportunities"]
[]
[null,"Estimated Annual Employee Turnover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Turnover",null,null,null,null,null,"Staffing experience of key personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Years Experience"]
[null,"Direct care givers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Administrative/Executive Director"]
[null,"Administrative personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Head Care Giver/Resident Assistant"]
[]
[null,"List any key employee turnover (such as Executive Director, Director of Marketing, Director of Social Activities, Director of Resident Care, Head Chef.)"]
[]
[]
[null,"Inspector's Comments on Management Performance"]
[null,"Staff interaction with residents:"]
[]
[]
[]
[null,"Appearance of residents/suitability for time of day:"]
[]
[]
[]
[null,"Attire and demeanor of staff:"]
[]
[]
[]
[null,"Overall cleanliness of facility; any odors present:"]
[]
[]
[]
[null,"Part V:  Marketing"]
[]
[null,"Inspector's Discussion with Marketing Staff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[]
[null,"Is there a written marketing plan?"]
[null,"Potential resident list/waiting list?"]
[null,"Networking with religious organizations, hospitals, etc.?"]
[null,"Marketing material distribution/outreach?"]
[null,"Are telemarketing or other marketing tools used?"]
[null,"Property brochure and application (attach copy)"]
[null,"Resident handbook (attach copy)"]
[null,"Model unit available?"]
[null,"Rent concessions?"]
[]
[null,"Number of marketing personnel"]
[null,"Combined years experience of marketing personnel"]
[]
[null,"How do the unit design, square footage, and amenities compare with comparable seniors housing properties in this market?"]
[]
[]
[null,"Competitor Analysis"]
[null,"Name of Facility",null,null,null,null,null,null,null,null,null,null,null,null,null,"# of units",null,null,null,"Type of Property",null,null,null,null,null,null,null,null,"Name of Operator"]
[]
[]
[]
[]
[]
[]
[null,"Part VI:  Regulatory Compliance"]
[]
[null,"Regulatory / Licensing Agency"]
[null,"Name of Regulatory or Licensing Agency"]
[null,"Regulatory Agency Contact Person"]
[null,"Expiration Date of Operating License"]
[]
[null,"Regulatory / Licensing Agency Inspection"]
[null,"Date of Last Agency Visit"]
[]
[null,"Purpose of Visit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"Certification/Licensure"]
[null,"Life/Safety"]
[null,"Follow-up"]
[null,"Other (describe)"]
[null,"Were deficiencies cited?"]
[null,"Were non-monetary penalties assessed?"]
[null,"Were monetary penalties/fines assessed?"]
[null,"Agency considers property in compliance?"]
[]
[null,"Copy of regulatory agency's report received?"]
[null,"Copy of operator's plan of correction received?"]
[]
[null,"Were any of the corrective actions related to the resident care and/or criminal background checks?"]
[]
[null,null,"If yes, what is the plan(s) of correction and status of such corrective actions?"]
[]
[]
[null,"Changes in Regulatory Oversight?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Comments"]
[null,"Staffing Requirements"]
[null,"Physical Design"]
[null,"Health & Safety Codes"]
[null,"Government Subsidies"]
[null,"Reimbursement Programs"]
[]
[null,"Other Required Property Licenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zYes / No / N/Az",null,null,null,null,"Expire Date",null,null,null,null,"Comments"]
[null,"Commercial Kitchen/Food & Beverage Permit"]
[null,"Commercial Vehicle"]
[null,"Elevator"]
[null,"Third Party Healthcare"]
[null,"Other (describe)"]
[]
[null,"Miscellaneous"]
[null,"Are there any material violations, lawsuits or judgments against any licensed professional employed by the operator?"]
[]
[]
[]
[null,"Are there any material violations, lawsuits or judgments against any other personnel at the property?"]

{"sheet":"Hospitals","index":13,"n_rows":87,"n_cols":34,"rows_kept":87,"cut":false,"hidden":false,"merged":[[68,30,68,35],[67,30,67,35],[66,30,66,35],[65,30,65,35],[64,30,64,35],[63,30,63,35],[62,30,62,35],[61,30,61,35],[60,30,60,35],[77,30,77,35],[76,30,76,35],[75,30,75,35],[74,30,74,35],[73,30,73,35],[72,30,72,35],[71,30,71,35],[70,30,70,35],[69,30,69,35],[86,30,86,35],[85,30,85,35],[84,30,84,35],[83,30,83,35],[82,30,82,35],[81,30,81,35],[80,30,80,35],[79,30,79,35],[78,30,78,35],[68,22,68,29],[67,22,67,29],[66,22,66,29],[65,22,65,29],[64,22,64,29],[63,22,63,29],[62,22,62,29],[61,22,61,29],[60,22,60,29],[77,22,77,29],[76,22,76,29],[75,22,75,29],[74,22,74,29],[73,22,73,29],[72,22,72,29],[71,22,71,29],[70,22,70,29],[69,22,69,29],[86,22,86,29],[85,22,85,29],[84,22,84,29],[83,22,83,29],[82,22,82,29],[81,22,81,29],[80,22,80,29],[79,22,79,29],[78,22,78,29],[86,18,86,21],[73,18,73,21],[85,18,85,21],[82,18,82,21],[79,18,79,21],[81,18,81,21],[80,18,80,21],[70,18,70,21],[69,18,69,21],[75,18,75,21],[83,18,83,21],[78,18,78,21],[62,18,62,21],[77,18,77,21],[86,14,86,17],[84,14,84,17],[65,14,65,17],[61,14,61,17],[70,14,70,17],[72,14,72,17],[64,14,64,17],[69,14,69,17],[85,14,85,17],[73,14,73,17],[74,14,74,17],[78,14,78,17],[79,14,79,17],[80,14,80,17],[66,14,66,17],[76,14,76,17],[75,14,75,17],[67,14,67,17],[62,14,62,17],[84,18,84,21],[61,18,61,21],[68,18,68,21],[82,14,82,17],[83,14,83,17],[81,14,81,17],[77,14,77,17],[63,14,63,17],[68,14,68,17],[71,14,71,17],[71,18,71,21],[76,18,76,21],[74,18,74,21],[72,18,72,21],[64,18,64,21],[66,18,66,21],[63,18,63,21],[67,18,67,21],[65,18,65,21],[66,10,66,13],[65,10,65,13],[64,10,64,13],[63,10,63,13],[62,10,62,13],[60,10,60,13],[59,10,59,13],[61,10,61,13],[59,14,59,17],[60,14,60,17],[63,7,63,9],[62,7,62,9],[60,7,60,9],[59,7,59,9],[86,10,86,13],[85,10,85,13],[84,10,84,13],[83,10,83,13],[82,10,82,13],[81,10,81,13],[80,10,80,13],[79,10,79,13],[78,10,78,13],[77,10,77,13],[76,10,76,13],[75,10,75,13],[74,10,74,13],[73,10,73,13],[72,10,72,13],[71,10,71,13],[70,10,70,13],[69,10,69,13],[68,10,68,13],[67,10,67,13],[63,1,63,6],[86,7,86,9],[85,7,85,9],[84,7,84,9],[83,7,83,9],[82,7,82,9],[81,7,81,9],[80,7,80,9],[79,7,79,9],[78,7,78,9],[77,7,77,9],[76,7,76,9],[75,7,75,9],[74,7,74,9],[73,7,73,9],[72,7,72,9],[71,7,71,9],[70,7,70,9],[69,7,69,9],[68,7,68,9],[67,7,67,9],[66,7,66,9],[65,7,65,9],[64,7,64,9],[86,1,86,6],[85,1,85,6],[84,1,84,6],[83,1,83,6],[82,1,82,6],[81,1,81,6],[80,1,80,6],[62,1,62,6],[79,1,79,6],[78,1,78,6],[77,1,77,6],[76,1,76,6],[75,1,75,6],[74,1,74,6],[73,1,73,6],[72,1,72,6],[71,1,71,6],[70,1,70,6],[69,1,69,6],[68,1,68,6],[67,1,67,6],[66,1,66,6],[65,1,65,6],[64,1,64,6],[61,7,61,9],[57,1,57,6],[57,7,57,9],[57,10,57,13],[57,14,57,17],[57,18,57,21],[61,1,61,6],[60,1,60,6],[59,1,59,6],[59,18,59,21],[60,18,60,21],[54,10,54,35],[57,22,57,29],[57,30,57,35],[59,22,59,29],[59,30,59,35],[43,1,43,35],[46,12,46,18],[47,12,47,18],[48,12,48,18],[49,12,49,18],[46,29,46,35],[47,29,47,35],[48,29,48,35],[52,1,52,35],[0,1,1,19],[6,1,6,35],[11,29,11,35],[10,29,10,35],[25,31,25,35],[26,31,26,35],[38,13,38,18],[39,13,39,18],[40,13,40,18],[37,9,37,18],[38,32,38,35],[39,32,39,35],[40,32,40,35],[37,26,37,29],[37,31,37,35],[14,1,14,11],[15,33,15,35],[15,30,15,32],[15,19,15,21],[15,22,15,25],[15,26,15,29],[15,12,15,14],[9,33,9,35],[9,14,9,17],[10,14,10,17],[11,14,11,17],[14,22,14,25],[14,30,14,32],[14,15,14,18],[14,33,14,35],[15,15,15,18],[16,15,16,18],[16,19,16,21],[16,22,16,25],[16,26,16,29],[16,33,16,35],[16,30,16,32],[14,12,14,14],[14,26,14,29],[14,19,14,21],[18,22,18,25],[18,30,18,32],[18,19,18,21],[18,33,18,35],[18,26,18,29],[18,12,18,14],[18,15,18,18],[16,12,16,14],[17,33,17,35],[17,22,17,25],[17,30,17,32],[17,26,17,29],[17,12,17,14],[17,15,17,18],[17,19,17,21],[18,1,18,11],[17,1,17,11],[16,1,16,11],[15,1,15,11],[23,33,23,35],[23,22,23,25],[23,12,23,14],[23,15,23,18],[23,19,23,21],[21,33,21,35],[21,12,21,14],[21,22,21,25],[21,15,21,18],[21,26,21,29],[21,30,21,32],[21,19,21,21],[20,30,20,32],[20,19,20,21],[20,22,20,25],[20,33,20,35],[20,12,20,14],[20,26,20,29],[20,15,20,18],[19,12,19,14],[25,15,25,20],[25,10,25,13],[26,10,26,13],[26,15,26,20],[21,1,21,11],[20,1,20,11],[19,1,19,11],[19,33,19,35],[19,30,19,32],[19,22,19,25],[19,26,19,29],[19,15,19,18],[19,19,19,21],[29,10,29,12],[28,19,28,35],[31,19,31,35],[32,19,32,35],[29,19,29,35],[30,19,30,35],[34,13,34,15],[34,10,34,12],[32,10,32,12],[31,10,31,12],[30,10,30,12],[34,16,34,18],[31,16,31,18],[30,13,30,15],[30,16,30,18],[29,13,29,15],[32,16,32,18],[31,13,31,15],[32,13,32,15],[29,16,29,18]]}
[null,"MBA Standard Inspection Form"]
[]
[null,{"$f":"IF('General Info'!B5=\"\",\"\",'General Info'!B5)","v":""}]
[null,{"$f":"IF('General Info'!B6=\"\",\"\",'General Info'!B6)","v":""}]
[null,{"$f":"IF('General Info'!B7=\"\",\"\",'General Info'!B7)","v":""}]
[]
[null,"Hospitals, Dedicated Healthcare, & Dedicated Nursing Homes"]
[]
[null,"General Property Information"]
[null,"Total Number of Beds",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NumberOfMeasurementBedsTotalCount=0,\"\",NumberOfMeasurementBedsTotalCount)","v":""},null,null,null,null,null,"New Patients Currently being Accepted"]
[null,"Number of Beds Occupied",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NumberOfMeasurementOccupiedBedsTotalCount=0,\"\",NumberOfMeasurementOccupiedBedsTotalCount)","v":""},null,null,null,null,null,"Admission Waiting Period"]
[null,"% Occupied",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(NumberOfMeasurementBedsTotalCount=0,NumberOfMeasurementOccupiedBedsTotalCount=0),\"\",NumberOfMeasurementOccupiedBedsTotalCount/NumberOfMeasurementBedsTotalCount)","v":""},null,null,null,null,null,"Proximity to a Hospital"]
[]
[null,"Level of Care Breakdown"]
[null,"Unit Type",null,null,null,null,null,null,null,null,null,null,"Total Beds",null,null,"Total Beds Occupied",null,null,null,"Total Units",null,null,"Total Units Occupied",null,null,null,"Avg. Square Feet / Unit",null,null,null,"Monthly Rent",null,null,"Beds Vacant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P16=\"\",M16=\"\"),\"\",M16-P16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Totals:  ",{"$f":"SUM(Hospitals!M16:M22)","v":0},null,null,{"$f":"SUM(Hospitals!P16:P22)","v":0},null,null,null,{"$f":"SUM(Hospitals!T16:T22)","v":0},null,null,{"$f":"SUM(Hospitals!W16:W22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Hospitals!AH16:AH22)","v":0}]
[]
[null,"Administrator's Name",null,null,null,null,null,null,null,null,null,null,null,null,"/",null,null,null,null,null,null,null,"Length of Time at Property"]
[null,"Director of Nursing's Name",null,null,null,null,null,null,null,null,null,null,null,null,"/",null,null,null,null,null,null,null,"Length of Time at Property"]
[]
[null,"Direct Care Staff Numbers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments"]
[null,"Nurses - RNs"]
[null,"Nurses - LPNs"]
[null,"Other Direct Care"]
[null,"Non Direct Care Personnel"]
[]
[null,null,null,null,null,null,null,null,null,"Total Staff:  ",{"$f":"SUM(K30:K33)","v":0},null,null,{"$f":"SUM(N30:N33)","v":0},null,null,{"$f":"SUM(Q30:Q33)","v":0}]
[]
[null,"Regulatory / Licensing Agency Information"]
[null,"Name of the Agency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Person",null,null,null,null,null,null,null,null,null,"/"]
[null,"Expiration Date of Operating License",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Licenses Current"]
[null,"Date of last Medicare inspection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Medicare Certified"]
[null,"Date of last Medicaid inspection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Medicaid Certified"]
[]
[null,"Please describe any violations, costs associated, resolution or outstanding issues:"]
[]
[]
[null,"Property Condition"]
[null,"Handrails in the halls",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exits clearly marked"]
[null,"Grab bars present in rest rooms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intercom System"]
[null,"Staff interacts well with residents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Generator Function"]
[null,"Facility looks and smells clean"]
[]
[null,"Additional description of any safety or deficiency issues observed:"]
[]
[]
[null,"Down Units (List the unit #)"]
[]
[null,"Detailed Report of Units Inspected"]
[null,"Unit Number",null,null,null,null,null,"Bedrooms",null,null,"Baths",null,null,null,"Square Feet",null,null,null,"Asking Rent",null,null,null,"Current Use",null,null,null,null,null,null,null,"Overall Condition"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]

{"sheet":"Data","index":14,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["PicCount",null,"Max Comment Lengths"]
[0,null,"General Tab",null,"MaxLen"]
["PicAddLocation",null,null,"Inspector Comments",1500,null,"O&M plan comments",244]
["P10",null,null,"Concessions",50,null,"Servicer's Comments to inspector",1500]
["LogoPswd",null,null,"Area Description",1500,null,"Down and Dark Comments",180]
[null,null,null,"Addional Collateral",1500]
["nrUsePct",null,"Physical Conditions Tab"]
[{"$f":"SingleFamilyUsePercent+MultifamilyUsePercent+CommericalUsePercent+IndustrialUsePercent","v":0},null,null,"Inspector Comments",185,null,"DM grid Caption",175]
["nrTntPro",null,null,"Exterior",1100]
[{"$f":"CorporateUsePercent+MilitaryUsePercent+SeasonalUsePercent+SeniorsUsePercent+StudentsUsePercent","v":0},null,null,"Interior",1100]
["Version",null,null,"Condition",170]
["3.03",null,"Comp Assmt Tab"]
["ChrPerRow",null,null,"Comments",1500]
[124,null,null,"Additional Comments",3000]
["ChrPerRowSRS",null,"Management Interview Tab"]
[129,null,null,"Comments",1100]
["DmCount (Rows visible)",null,null,"OtherInformation",1100]
[1,null,"MultiFamily Tab"]
["CapExCount",null,null,"General Comments",1100]
[1,null,"Hospitals Tab"]
["DMLifeSafetyCount",null,null,"Regulatory Comments",800]
[{"$f":"COUNTIF('Physical Condition & DM'!$AC$93:$AC$142,\"Yes\")","v":0},null,null,"SafetyOrDeficiencyComment",800]
["DMMajorCount",null,"Repairs Verification"]
[{"$f":"COUNTIF('Physical Condition & DM'!$AA$93:$AB$142,\"Major\")","v":0},null,null,"Item Description",400,null,"General Comments",830]
["DMMajorMinusLS",null,null,"Inspector Comments",400]
[{"$f":"IF(A24-A22<0,0,A24-A22)","v":0},null,"FRE Assmt Addendum"]
["DMMinorCount",null,null,"Comments",1100]
[{"$f":"COUNTIF('Physical Condition & DM'!$AA$93:$AB$142,\"Minor\")","v":0},null,"Srs Supplement I"]
["DMSummaryText",null,null,"Comments",250]
[{"$f":"IF(A22=0,\"\",A22&\" Life Safety\")","v":""},null,"Srs Supplement II & III"]
[{"$f":"IF(A26=0,\"\",A26&\" Major\")","v":""},null,null,"Short Comments",30,null,"Unit mix comment",200]
[{"$f":"IF(AND(A31=\"\",A30=\"\"),\"\",IF(AND(A31<>\"\",A30<>\"\"),\"Deferred Maintenance: \"&A30&\", \"&A31,IF(AND(A30<>\"\",A31=\"\"),\"DM: \"&A30,\"Deferred Maintenance: \"&A31)))","v":""},null,null,"Medium Comments",52,null,"ResidentRoomsTurnaround",170]
[{"$f":"IF(AND(A31=\"\",A30=\"\"),\"\",IF(AND(A31<>\"\",A30<>\"\"),\"\"&A30&\", \"&A31,IF(AND(A30<>\"\",A31=\"\"),\"\"&A30,\"\"&A31)))","v":""},null,null,"Long Comments",70]
[null,null,null,"Staff List",285]
["OandMCount",null,null,"Resident Meds Documented",426]
[1,null,"Srs Supplement IV"]
[null,null,null,"Short Comments",52,null,"Key Employee turnover",105]
["DMCount (Rows populated)",null,null,"Medium Comments",61]
[{"$f":"MAX(COUNTA('Physical Condition & DM'!$B$93:$B$142),COUNTA('Physical Condition & DM'!$AA$93:$AA$142),COUNTA('Physical Condition & DM'!$AC$93:$AC$142),COUNTA('Physical Condition & DM'!$AE$93:$AE$142),COUNTA('Physical Condition & DM'!$AG$93:$AG$142))","v":0},null,null,"Large Comments",266]
[null,null,"Srs Supplement V"]
[null,null,null,"Comments",115,null,"Inspector comments large",270]
["RepairsRowsShown",null,null,"Unit design comments",130,null,"Full Width Comments",625]
[2,null,null,"Facility And Operator Name",115]
["RepairsPagesShown",null,"Srs Supplement VI"]
[1,null,null,"Short Comments",48]
["RV rows populated",null,null,"Medium Comments",63]
[{"$f":"MAX(COUNTA('Repairs Verification'!$B$29:$B$336),COUNTA('Repairs Verification'!$V$29:$V$336),COUNTA('Repairs Verification'!$AP$29:$AP$336),COUNTA('Repairs Verification'!$AS$29:$AS$336))","v":0},null,null,"Long Comments",80]
[]
["MFunitsInspectedRows"]
[10]
[]
["Password"]
["MBAv3BB"]
[]
["UpdateIntervalPhotoButtons"]
["2019-07-01T12:47:09"]
[]
["PropertyTypePlaceholder"]

{"sheet":"Resources","index":15,"n_rows":177,"n_cols":51,"rows_kept":177,"cut":false,"hidden":true,"merged":[[19,4,24,4],[31,5,35,5],[19,5,23,5],[0,13,8,13],[175,20,175,28],[35,13,40,13],[176,20,177,28],[175,29,177,49]]}
[null,"State","Country",null,null,null,"PropTypePrimary",null,null,"PropertyType:Primary",null,"PropertyType-Secondary",null,"nrOverallRating","nrPropRating"]
[null,null,null,null,null,null,null,0,null,"<none>",null,"Blank"]
[null,"AK","US",null,null,null,"Health Care","1",null,null,null,null,null,null,1]
[null,"AL","US",null,null,null,"Industrial","2",null,"PropTypePrimary",null,"PropTypeSecondary1",null,null,2]
[null,"AR","US",null,null,null,"Lodging","3",null,"Health Care",null,"Assisted Living/Congregate Care",null,null,3]
[null,"AZ","US",null,null,null,"Multifamily","4",null,"Health Care",null,"Hospital",null,null,4]
[null,"CA","US",null,null,null,"Mobile Home Park","5",null,"Health Care",null,"Nursing Home, Unskilled",null,null,5]
[null,"CO","US",null,null,null,"Mixed Use","6",null,"Health Care",null,"Nursing Home, Skilled",null,null,"Not Applicable"]
[null,"CT","US",null,null,null,"Office","7",null,"Health Care",null,"Specialty Health Care",null,null,"Not Accessible"]
[null,"DC","US",null,null,null,"Other","8"]
[null,"DE","US",null,null,null,"Retail","9",null,null,null,"PropTypeSecondary2",null,null,"nrTrend"]
[null,"FL","US",null,null,null,"Self Storage","10",null,"Industrial",null,"Flex Industrial/Office"]
[null,"GA","US",null,null,null,null,null,null,"Industrial",null,"R&D",null,null,"Improving"]
[null,"HI","US",null,null,null,"nrYesSBNoUnknown",null,null,"Industrial",null,"Industrial Showroom",null,null,"Stable"]
[null,"IA","US",null,null,null,null,null,null,"Industrial",null,"Light Industrial/Manufacturing",null,null,"Declining"]
[null,"ID","US",null,null,null,"Yes, Specified Below",null,null,"Industrial",null,"Heavy Manufacturing Facility",null,null,"Unknown"]
[null,"IL","US",null,null,null,"No",null,null,"Industrial",null,"Warehouse/Distribution"]
[null,"IN","US",null,null,null,"Unknown",null,null,null,null,null,null,null,"nrMajMin"]
[null,"KS","US",null,null,null,null,null,null,null,null,"PropTypeSecondary3"]
[null,"KY","US",null,"nrYesNoNotApplUnknwn","nrYesNoNA","nrYesNo",null,null,"Lodging",null,"Extended Stay Hotel",null,null,"Major"]
[null,"LA","US",null,null,null,null,null,null,"Lodging",null,"Full Service Hotel",null,null,"Minor"]
[null,"MA","US",null,null,null,"Yes",null,null,"Lodging",null,"Limited Service Hotel"]
[null,"MD","US",null,null,null,"No",null,null,"Lodging",null,"Resort Hotel",null,null,"nrYesNoNAP"]
[null,"ME","US",null,null,null,"Not Applicable",null,null,"Lodging",null,"Motel"]
[null,"MI","US",null,null,null,"Unknown",null,null,null,null,null,null,null,"Yes"]
[null,"MN","US",null,null,null,null,null,null,null,null,"PropTypeSecondary4",null,null,"No"]
[null,"MO","US",null,null,null,"nrYesDescBelowNo",null,null,"Multifamily",null,"Cooperative Housing",null,null,"NAP"]
[null,"MS","US",null,null,null,null,null,null,"Multifamily",null,"Condominiums/Townhouses"]
[null,"MT","US",null,null,null,"Yes, Described Below",null,null,"Multifamily",null,"Garden Apartment",null,null,"nrQualRating"]
[null,"NC","US",null,null,null,"No",null,null,"Multifamily",null,"Retirement/Independent Living"]
[null,"ND","US",null,null,null,null,null,null,"Multifamily",null,"Affordable Housing",null,null,"Superior"]
[null,"NE","US",null,null,"nrYesNoDescBelowNA","nrYesNoDescBelow",null,null,"Multifamily",null,"Student Housing",null,null,"Average"]
[null,"NH","US",null,null,null,null,null,null,"Multifamily",null,"High Rise Multifamily (≥ 7 stories)",null,null,"Below Average"]
[null,"NJ","US",null,null,null,"Yes",null,null,"Multifamily",null,"Mid-Rise Multifamily (4-6 stories)",null,null,"Poor"]
[null,"NM","US",null,null,null,"No, Describe Below",null,null,"Multifamily",null,"Small (≤ 8 Units) Multifamily"]
[null,"NV","US",null,null,null,"Not Applicable",null,null,null,null,null,null,"nrPaidByPlusNA","nrPaidBy"]
[null,"NY","US",null,null,null,null,null,null,null,null,"PropTypeSecondary5"]
[null,"OH","US",null,null,null,"nrYesNoUnknown",null,null,"Mobile Home Park",null,"Mobile Home Park",null,null,"Paid by Tenant"]
[null,"OK","US",null,null,null,null,null,null,null,null,null,null,null,"Paid by Owner"]
[null,"OR","US",null,null,null,"Yes",null,null,null,null,"PropTypeSecondary6",null,null,"Not Applicable"]
[null,"PA","US",null,null,null,"No",null,null,"Mixed Use",null,"Mixed Predominately Office"]
[null,"RI","US",null,null,null,"Unknown",null,null,"Mixed Use",null,"Mixed Predominately Multifamily"]
[null,"SC","US",null,null,null,null,null,null,"Mixed Use",null,"Mixed Predominately Industrial",null,null,"nrCurrUseComplete"]
[null,"SD","US",null,null,null,"nrUOM",null,null,"Mixed Use",null,"Mixed Predominately Retail"]
[null,"TN","US",null,null,null,null,null,null,null,null,null,null,null,"Occupied Unfurnished"]
[null,"TX","US",null,null,null,"Units",null,null,null,null,"PropTypeSecondary7",null,null,"Occupied Furnished"]
[null,"UT","US",null,null,null,"Rooms",null,null,"Office",null,"Office Condo",null,null,"Down Unit"]
[null,"VA","US",null,null,null,"Beds",null,null,"Office",null,"High Rise Office (≥ 7 stories)",null,null,"Vacant Unfurnished, Ready"]
[null,"VT","US",null,null,null,"Sq. Feet",null,null,"Office",null,"Mid-Rise Office (4-6 stories)",null,null,"Vacant Unfurnished"]
[null,"WA","US",null,null,null,null,null,null,"Office",null,"Low-Rise Office (1-3 stories)",null,null,"Vacant Furnished, Ready"]
[null,"WI","US",null,null,null,"nrCompPlanInProc",null,null,"Office",null,"Office Campus",null,null,"Vacant Furnished"]
[null,"WV","US",null,null,null,null,null,null,"Office",null,"Medical Office",null,null,"Non-Revenue"]
[null,"WY","US",null,null,null,"Completed",null,null,"Office",null,"Single Tenant Office",null,null,"Commercial Unit"]
[null,"PR","PR",null,null,null,"Planned",null,null,"Other"]
[null,"VI","VI",null,null,null,"In Process",null,null,"Other",null,"PropTypeSecondary8"]
[null,"Antigua & Barbuda","AG",null,null,null,null,null,null,"Other",null,"Church"]
[null,"Anguilla","AI",null,null,null,"nrPctBy5",null,null,"Other",null,"Day Care"]
[null,"Bonaire","AN",null,null,null,null,null,null,null,null,"Golf Course"]
[null,"Curaçao","AN",null,null,null,0,null,null,null,null,"Parking Garage",null,null,"nrOverallCond"]
[null,"Saba","AN",null,null,null,0.05,null,null,"Other",null,"Land with Site Improvements - Office"]
[null,"St Eustatius","AN",null,null,null,0.1,null,null,"Other",null,"Land with Site Improvements - Industrial",null,null,1]
[null,"St Maarten","AN",null,null,null,0.15,null,null,"Other",null,"Land with Site Improvements - Retail",null,null,2]
[null,"AS","AS",null,null,null,0.2,null,null,"Other",null,"Land with Site Improvements - Multifamily",null,null,3]
[null,"Aruba","AW",null,null,null,0.25,null,null,"Other",null,"Raw Land",null,null,4]
[null,"Barbados","BB",null,null,null,0.3,null,null,"Other",null,"Recreation/Athletic Club",null,null,5]
[null,"Bermuda","BM",null,null,null,0.35,null,null,"Other",null,"School",null,null,"Not Applicable"]
[null,"Bahamas","BS",null,null,null,0.4,null,null,"Other",null,"Special Purpose",null,null,"Not Accessible"]
[null,"Belize","BZ",null,null,null,0.45,null,null,null,null,null,null,null,"Not Inspected"]
[null,"AB","CA",null,null,null,0.5,null,null,null,null,"PropTypeSecondary9"]
[null,"BC","CA",null,null,null,0.55000000000000004,null,null,"Retail",null,"Anchored Retail Center",null,null,"nrWaitPeriod"]
[null,"MB","CA",null,null,null,0.6,null,null,"Retail",null,"Neighborhood Center"]
[null,"NB","CA",null,null,null,0.65,null,null,"Retail",null,"Power Center",null,null,"Yes, 1-15 days"]
[null,"NL","CA",null,null,null,0.7,null,null,"Retail",null,"Regional Mall",null,null,"Yes, 16-30 days"]
[null,"NS","CA",null,null,null,0.75,null,null,"Retail",null,"Restaurant",null,null,"Yes, 31-60 days"]
[null,"NT","CA",null,null,null,0.8,null,null,"Retail",null,"Shadow Anchored Retail",null,null,"Yes, 61-120 days"]
[null,"NU","CA",null,null,null,0.85,null,null,"Retail",null,"Single Tenant Retail",null,null,"Yes, 121+ days"]
[null,"ON","CA",null,null,null,0.9,null,null,"Retail",null,"Specialty Shopping Center",null,null,"No waiting period"]
[null,"PE","CA",null,null,null,0.95,null,null,"Retail",null,"Outlet Mall"]
[null,"QC","CA",null,null,null,1,null,null,"Retail",null,"Warehouse Retail",null,null,"nrHospitalProx"]
[null,"SK","CA",null,null,null,"NAP",null,null,"Retail",null,"Unanchored/Strip Retail"]
[null,"YT","CA",null,null,null,null,null,null,null,null,null,null,null,"On site"]
[null,"Cuba","CU",null,null,null,"nrAffiliation",null,null,null,null,"PropTypeSecondary10",null,null,"Less than 1 mile"]
[null,"Dominica","DM",null,null,null,null,null,null,"Self Storage",null,"Self Storage",null,null,"1 to < 5 miles"]
[null,"Dominican Republic","DO",null,null,null,"Affiliated with the Borrower",null,null,null,null,null,null,null,"5 to <10 miles"]
[null,"FM","FM",null,null,null,"Nonaffiliated, Third Party",null,null,null,null,"PropTypeSecondary4",null,null,"10 or more miles"]
[null,"Grenada","GD",null,null,null,null,null,null,null,null,"Cooperative Housing"]
[null,"Guadeloupe","GP",null,null,null,"nrMgtInterview",null,null,"nrCurrCondition",null,"Condominiums/Townhouses",null,null,"nrIntercomStatus"]
[null,"St Barts","GP",null,null,null,null,null,null,1,null,"Garden Apartment"]
[null,"GU","GU",null,null,null,"Yes, on Site",null,null,2,null,"Retirement/Independent Living",null,null,"Working"]
[null,"Guyana","GY",null,null,null,"Yes, Prior to Visit",null,null,3,null,"Affordable Housing",null,null,"Not Working, Describe Below"]
[null,"Haiti","HT",null,null,null,"Yes, Prior to and Onsite",null,null,4,null,"Student Housing",null,null,"Not Present"]
[null,"Jamaica","JM",null,null,null,"No, Not Required",null,null,5,null,"High Rise Multifamily (≥ 7 stories)"]
[null,"St Kitts & Nevis","KN",null,null,null,null,null,null,"Not Applicable",null,"Mid-Rise Multifamily (4-6 stories)",null,null,"nrGeneratorStatus"]
[null,"Cayman Islands","KY",null,null,null,"nrLenOfStay",null,null,"Not Accessible",null,"Small (≤ 8 Units) Multifamily"]
[null,"St Lucia","LC",null,null,null,null,null,null,null,null,"Rent Subsidy",null,null,"Entire Electric Load"]
[null,"St Martin","MF",null,null,null,"< 6 mos",null,null,"nrSHSHowOften_short",null,null,null,null,"Life Safety Only"]
[null,"MH","MH",null,null,null,"6 m to < 1 yr",null,null,"nrSHSHowOften",null,"nrRepair Verification Completion",null,null,"None"]
[null,"MP","MP",null,null,null,"1 to < 3 yrs",null,null,"Hourly",null,"Repairs Complete"]
[null,"Martinique","MQ",null,null,null,"3 to < 5 yrs",null,null,"Daily",null,"Partially - In Process",null,null,"nrNoRentRollReason"]
[null,"Montserrat","MS",null,null,null,"5 yrs or longer",null,null,"Weekly",null,"Partially - Halted",null,null,"(Select One)"]
[null,"AG","MX",null,null,null,null,null,null,"Bi-Weekly",null,"Repairs Scheduled",null,null,"Hard copy to follow"]
[null,"BC","MX",null,null,null,null,null,null,"Monthly",null,"Repairs Planned",null,null,"Requested but not provided"]
[null,"BS","MX",null,null,null,null,null,null,"Quarterly",null,"No Repairs Planned",null,null,"Requested but declined"]
[null,"CH","MX",null,null,null,null,null,null,"Yearly",null,"Unknown",null,null,"Not Applicable"]
[null,"CL","MX",null,null,null,null,null,null,"(Other)"]
[null,"CM","MX",null,null,null,null,null,null,null,null,"nrMIVacancyCompare",null,null,"nrSrsDocs"]
[null,"CO","MX",null,null,null,null,null,null,"nrSHSHowOften_short"]
[null,"CS","MX",null,null,null,null,null,null,"Daily",null,"Similar",null,null,"Hard copy to follow"]
[null,"DF","MX",null,null,null,null,null,null,"Weekly",null,"Increased",null,null,"Requested but not provided"]
[null,"DG","MX",null,null,null,null,null,null,"Monthly",null,"Decreased",null,null,"Requested but declined"]
[null,"EM","MX",null,null,null,null,null,null,"Yearly",null,"Unknown"]
[null,"GR","MX"]
[null,"GT","MX",null,null,null,"nrLifeSafeyOpts"]
[null,"HG","MX",null,null,null,"1. No Life Safety issues observed",null,null,null,null,null,null,null,"Rating Type"]
[null,"JA","MX",null,null,null,"2. No/minor Life Safety issues observed"]
[null,"MI","MX",null,null,null,"3. Some Life Safety issues observed requiring immediate attention; but no capital expenditure",null,null,null,null,null,null,null,"MBA"]
[null,"MO","MX",null,null,null,"4. Life Safety issues observed that require immediate attention and possible capital expenditure",null,null,null,null,null,null,null,"Fannie Mae"]
[null,"NA","MX",null,null,null,"5. Significant Life Safety issues requiring capital expenditure"]
[null,"NL","MX",null,null,null,"nrDefMntOpts"]
[null,"OA","MX",null,null,null,"1. No observed or reported Deferred Maintenance issues"]
[null,"PU","MX",null,null,null,"2. Isolated or minor Deferred Maintenance can be addressed in-house and/or at limited expense"]
[null,"QR","MX",null,null,null,"3. Deferred Maintenance of heightened concern; likely not addressed in house"]
[null,"QT","MX",null,null,null,"4. Substantial Deferred Maintenance affecting major/several property areas/systems, requiring significant investment"]
[null,"SI","MX",null,null,null,"5. Excessive Deferred Maintenance affecting multiple areas/property systems, requiring significant investment; impacting collateral value"]
[null,"SL","MX"]
[null,"SO","MX",null,null,null,"nrRoutineMntOpts"]
[null,"TB","MX",null,null,null,"1. Superior RM practices that are extending the RUL of systems and components"]
[null,"TL","MX",null,null,null,"2. Proactive RM practices ensuring good overall system performance and functionality"]
[null,"TM","MX",null,null,null,"3. Some reactive RM practices impacting a limited number of components requiring attention"]
[null,"VE","MX",null,null,null,"4. Reactive RM practices that do not address concerns in a timely manner"]
[null,"YU","MX",null,null,null,"5. Inadequate RM practices that do not ensure reasonable functionality of the property systems and components and may impact collateral value"]
[null,"ZA","MX"]
[null,"PW","PW",null,null,null,"nrCapNeedsOpts"]
[null,"Suriname","SR",null,null,null,"1. Capital needs are addressed; major components and systems are like new, in excellent condition and high probability they will significantly exceed the loan term"]
[null,"Turks & Caicos","TC",null,null,null,"2. Majority of capital needs are being addressed, property performance does not appear to be impacted; components and systems in good condition and very likely will exceed the loan term"]
[null,"Trinidad & Tobago","TT",null,null,null,"3. Critical capital needs are being addressed as needed, but additional capital required to maintain asset quality and system functionality; RUL of major systems/components may not meet or exceed the loan term"]
[null,"St Vincent","VC",null,null,null,"4. Some critical capital needs are not being addressed, and property performance may be negatively impacted; very likely that the RUL of major systems/components will not meet or exceed the loan term"]
[null,"British Virgin Islands","VG",null,null,null,"5. Major and pervasive issues with major components and systems; critical capital needs are not being addressed, property performance is being impacted and RUL of major systems/components has been exceeded"]
[]
[null,null,null,null,null,null,"nrLvlVolOpts"]
[null,null,null,null,null,null,"1. No concerns observed. No further action required."]
[null,null,null,null,null,null,"2. Some minor issues noted. Limited follow-up required."]
[null,null,null,null,null,null,"3. Overall declining condition or isolated deterioration. Documented follow-up required."]
[null,null,null,null,null,null,"4. Substantial issues noted. Documented follow-up with possible action plan required."]
[null,null,null,null,null,null,"5. Severe Deferred Maintenance observed. Follow-up and substantial action plan required."]
[]
[null,null,null,null,null,null,"nrOAndMPlanType",null,null,"nrEnvironmentalRating",null,"nrPhotoCat"]
[]
[null,null,null,null,null,null,"Asbestos",null,null,"No",null,"Exterior"]
[null,null,null,null,null,null,"Lead Paint",null,null,"Minor",null,"Interior"]
[null,null,null,null,null,null,"Moisture/Mold",null,null,"Major",null,"Roof"]
[null,null,null,null,null,null,"Radon",null,null,null,null,"Neighborhood",null,null,null,null,null,null,"Photo Worksheet Resource. The Area bordered below is our PhotoCell range copied in with each photo"]
[null,null,null,null,null,null,"Storage Tanks",null,null,null,null,"Routine Maintenance"]
[null,null,null,null,null,null,"PCB (polychlorinated biphenyl)",null,null,null,null,"Deferred Maintenance"]
[null,null,null,null,null,null,"Other, specified below",null,null,null,null,"Life Safety"]
[null,null,null,null,null,null,"Unknown"]
[null,null,null,null,null,null,null,null,null,null,null,"nrPhotoCat2"]
[null,null,null,null,null,null,null,null,null,null,null,"Exterior"]
[null,null,null,null,null,null,null,null,null,null,null,"Interior"]
[null,null,null,null,null,null,null,null,null,null,null,"Roof"]
[null,null,null,null,null,null,"nrOAndMPlanAvailable",null,null,null,null,"Neighborhood"]
[null,null,null,null,null,null,null,null,null,null,null,"Routine Maintenance"]
[null,null,null,null,null,null,"Yes, on-site",null,null,null,null,"Deferred Maintenance"]
[null,null,null,null,null,null,"Yes, off-site",null,null,null,null,"Life Safety"]
[null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,"Unknown"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Photo 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\" DM \"&INDEX('Physical Condition & DM'!$A$93:$A$143,MATCH(VALUE(TRIM(RIGHT(U176,2))),'Physical Condition & DM'!$AE$93:$AE$143,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(\" RV \"&INDEX('Repairs Verification'!$A$29:$A$336,MATCH(VALUE(TRIM(RIGHT(U176,2))),'Repairs Verification'!$AP$29:$AP$336,0)),\"\")","v":""}]