Unit types describe the units in a property: how many of each kind there are, how big they are, and which building they are in. HomeRun IQ uses them to split the association's contributions between unit types and between owners.
What it does
List each unit type on the Units tab: name, building, number of units, square footage, floor plan, bedrooms, bathrooms and notes.
Each unit type gets a % Contribution, its share of the association's contributions, and a % Contribution / Unit, the share for one unit, which is one owner.
With Automatic (by square footage), HomeRun IQ works out each type's share from its total square footage (number of units times square footage). With Manual, you enter the percentages yourself.
Leave a unit type out of the split, such as a guest suite or a management office. The other types share the full 100%.
Add unit types one at a time or import them from a spreadsheet, and export the list to Excel.
The study's Total Units on the Details tab comes from your unit types.
Reports can show each unit type's share of contributions and expenditures for one year, a range of years or every year of a funding plan.
How to add a unit type
Open the study in the Study Editor and click Property.
Click the Units tab.
Click Add Unit Type, then Add Single Unit Type.
Enter the Unit Type Name and # of Units. In Automatic, Square Footage is required too.
Pick a Building, or type a new building's address and click + Create building.
Fill in Floor Plan, Bedrooms, Bathrooms and Notes if you want them.
Click Save, then click the Save icon at the top of the Study Editor.
To change a unit type, click the pencil icon on its row. To remove one, click the trash icon on its row, then Yes, Remove.
How to import unit types from a spreadsheet
On the Units tab, click Add Unit Type, then Import Spreadsheet.
Click Download Excel Template and fill in one row per unit type.
Drag your .xlsx file onto the upload box.
If the study already has unit types, choose Add to them or Replace them.
Click Import File.
The template's columns are Unit (#, type, name, etc.), Building (#, name, etc.), # of Units, Percent Contribution, Square Footage, Floor Plan, Bedrooms, Bathrooms and Notes.
Only the unit name and # of Units are required.
Type Excluded in Percent Contribution to leave a unit type out of the split.
A building name that is new to the study is added as a building. A name that matches an existing building joins it.
A file exported from the Units tab imports straight back in.
If a row has a problem, the import stops, tells you which row, and imports nothing.
How to choose how % Contribution is calculated
Your company default applies to every study that has not made its own choice. Organization admins set it.
Go to Settings. Under Company, click Analysis Defaults.
Under Additional, set Contribution % Calculation to Automatic (by square footage) or Manual.
Click Save.
To set it for one study:
In the Study Editor, click Study Settings in the left menu.
Under Additional, set Contribution % Calculation.
Click Save Changes, then click the Save icon at the top of the Study Editor.
How Automatic works
Each unit type's share is its total square footage divided by the total square footage of every unit type in the split.
% Contribution is read-only, in the grid and in the unit type's window, which says Calculated automatically from square footage.
Every unit type in the split needs a Square Footage of at least 1. A unit type without one shows Required in the grid, and the study will not save until you fill it in.
Percentages update as soon as you change square footage, number of units or the exclude box, or add or remove a unit type.
How to enter percentages yourself
Set Contribution % Calculation to Manual, for your company or for the study.
Click the pencil icon on a unit type's row.
Enter its % Contribution and click Save.
When you switch a study to Manual, the percentages already on screen stay as your starting point.
If the percentages don't add up to 100, the top of the Units tab says so, for example "Contribution percentages add up to 98.50%, not 100%". You can still save, and reports show the percentages as you entered them.
How to leave a unit type out of the split
Click the pencil icon on the unit type's row.
Tick Exclude from contribution calculation.
Click Save.
The row shows Excluded in both percentage columns, and the other unit types share the full 100%. An excluded unit type doesn't need square footage.
How to edit or delete several unit types
Tick the boxes beside the unit types you want.
In the bar at the bottom, click the Edit Building (pencil) icon to move them all to one building, or the Delete (trash) icon to delete them.
To move them, tick the box beside Building, pick the building and click Save. To delete them, click Yes, Delete.
How to export unit types
In the Study Editor, click the Export to Excel (download) icon on the Units tab.
In View Analysis, open Property, click the Units tab and click Export to Excel.
Unit types in your reports
We set up the Unit Types table in your report template for you. Click Get Help to ask for one.
The table can show one year, a range of years or every year of a funding plan, with each unit type's contribution and expenditure in total and per unit.
Excluded unit types show $0 and sit outside the totals.
If a study has no unit types, the table is left out of the report.
Good to know
Total Square Footage at the top of the Units tab includes excluded unit types. The split itself uses only the unit types in it.
Percentages are shown to two decimal places, so they can add up to 99.99% or 100.01%. Dollar amounts in reports use the exact share, so identical unit types always get the same amount.
Switching a study to Automatic replaces any percentages entered by hand.
Once you choose Contribution % Calculation in a study's Study Settings, that study keeps its choice even if the company default changes later.
Bathrooms accepts halves, such as 1.5.
In View Analysis, the Units tab only shows when the study has unit types.