Unit Detail Summary

The Unit Lease Summary table allows a user to import the subject's "Used in Excel" instance into a horizontal table format. Further, a user can hand-enter data or make adjustments to the imported data for display in a report. 

Import data from the Web

Verify that you have selected the correct instance by checking the "Used in Excel" checkbox in the MF lease page of your subject property record. 

Enter the subject ID in the File Info worksheet and click the Import Subject Data From DB button. 

Import Unit Lease Data

Navigate to the Subject Unit Lease Summary and click the Populate Subject Info button. The Individual Unit Type data will automatically populate and the table will reformat to hide those rows and columns where there is not any data. Further, the columns will automatically resize to auto-fit the data populated. 

Click the Clear Subject Data button and the Unit Lease data will be removed.

Customize the table

Now that the data is imported, individual Unit data can be edited. Note that at this time, subject Unit lease data does not write back to the Database.

Adjust this table to suit your needs with the caveat that you must cut and paste the column header and column anchor range name for the data to auto-populate from web.

Utilize the Show/Hide dropdowns in the column/rows to customize the table.