Weighted Average Calculation Methodology

Introduction (Please Read):
This document will provide you with an explanation of how REALHOUND CRM conducts Weighted Average calculations. Every effort has been made to make our reports statistically accurate. Because of this, some of our averages may calculate out different than yours, as REALHOUND CRM uses a true weighted average to determine overall averages. The example below illustrates this.

Calculation Example:
Let’s say that we have five apartment buildings for which we want to determine the overall average rent. The complexes and rents are:

Name Type Square Feet Units Low Rent High Rent Total Low Total High Total SF
Californian 2/1 850 58 $1,000 $1,100 Normal 0 false false false EN-US X-NONE X-NONE $ 58,000 $63,800 49,300
Coral Reef 1/1 650 56 $1,870 $2,015 $104,720 $112,840 36,400
Tanoan 1/1 725 28 $745 $795 $20,860 $22,260 20,300
Tanoan 2/1 875 25 $950 $950 $23,750 $23,750 21,875
Surfside 1/1 675 11 $725 $725 $7,975 $7,975 7,425
Surfside 2/1 825 39 $850 $850 $33,150 $33,150 32,175
Tropic Sands 0/1 550 4 $735 $735 $2,940 $2,940 2,200
Tropic Sands 1/1 750 53 $740 $875 $39,220 $46,375 39,750
Totals 274 $290,615 $313,090 209,425

First, you have to review all of the different unit types of all of the properties you want to average. Then, on a unit type by unit type basis, calculate the total low rent and total high rent by multiplying the respective rents by the number of units for that type. Calculate the total square feet by multiplying the unit’s square feet by the number of units. Then, sum up the total rents and total square feet columns.

Now, to calculate the average square feet per unit, divide the total square feet by the number of units. This will weight the average by the number of units, thus, the larger complexes will have more “weight” then the smaller ones.

To calculate the overall average rent, you first need to determine the average of the low and high rents. Because there are typically more low rent units than high rent ones, REALHOUND IP has an option on the Report Options screen to use a 2/3 weighting on this calculation. The calculation is ((low rent x 2) + High Rent)/3. If there is no high rent, then the low rent is substituted for it. After you have calculated the 2/3 weighted average of the total low and total high, divide this number by the total number of units. Here is the answer:

Average Rent = $1,088
Average SF = 764

Smart-links- Tenants from Google Fix

Smart-links- Tenants from Google Fix

Introduction (Please Read) Smart-links will take information from your database, automatically enter data from your database to a website of interest and generate search returns from those websites. Unfortunately, the Smart-link for “Tenants from Google Maps” was entered wrong and cannot be fixed through the upgrade process for existing database without deleted a users’ custom added Smart-links. So the fix must be done manually. (Instructions for creating your own Smart-links are at the bottom of the Custom Add-ins window. You can identify field names in your database clicking in a field and pressing the Ctrl + 1 buttons simultaneously. Or, if you are brave, review the field names in your database by table directly under the File>Administration>Table Detail…) Step 1 Select the Custom Add-ins tab form the File Menu>Administration>Settings… menu selection. Step 2 Scroll to the Tenants from Google Maps title. Step 3 Delete the entire Command Line/URL 1 (3) Step 4 Type or Paste the following information http://maps.google.com/maps?f=l&hl=en&q=%22%22&near=,+&ie=UTF8&z=13&om=1 Step 5 into the Command Line/URL field that was just deleted. Step 6 From the Type drop-down select URL Step 7 Type or Paste the Smart-link command line in the Command Line/URL field (below). Step 8 Close the window and try it out on a multi-tenant property record.
Searching History- Find key words in your contact and property history

Searching History- Find key words in your contact and property history

Introduction (Please Read) The purpose of this document is to assist you with REALHOUND’s Search History function which finds key words in your contact and property histories. This function is extremely useful for locating contacts or property records that you remember entering in certain notes on but do not remember the specific record. You can also identify calls, notes and tasks that you or a team member entered into the database within a certain time period. Step 1 Goto the Today section and click the Search History tab. Step 2 Identify the date range you want enter in the key words and click the Search button. You can generate a report by clicking the “Report” button at the bottom right of the screen. 5 (4) If you clicked on a Task Type or a User, you would narrow your seach to that Task Type and User. You can always tell if you have Users or Task Types selected because they will be highlighted in black.
Notes – Making a Global Note

Notes – Making a Global Note

Introduction (Please Read) This document will help you to understand how to make a history entry on multiple contacts or properties at once. Thus making a global note Step 1: You must start by having the contacts or properties that you want the history entry on selected. Step 2: Start with all your contacts selected then use a filter or a group to filter down all your contacts to the list you want. Untitled-1 (30) Step 3: Right click on a value you want to search by or you could type in the search field the value you want. In this example we are filtering our contacts down to those contacts in the city of “Marina Del Ray”. Right click on the city name and select Filter By Selection. Untitled-1 (31) Step 4: You can see here that we have filtered down our list from 4064 to 7 (filtered). Untitled-1 (32) Step 5: Anytime you see the word “(Filtered)” next to your number in order to be able to use this filtered list you must apply the filter before you can utilize this list properly. Untitled-1 (33) Step 6: Now to make the history note on all 7 contacts at once. First go to any of the contacts (or Properties) in the list and from the overview screen create a new history entry. We are creating a note only but the same principles apply to calls. Make sure you have the selection of All Selected Contacts (or properties) checked before you save the note. Untitled-1 (34) Step 7: When you click on Save you will get this warning message you are about to attach a history to all selected contacts. Click Yes if you are sure you want this note on all the selected contacts. Untitled-1 (35) Step 8: Here you can see the note on the contact you started from cycling through all seven contact you will find the same note on each contact record. Untitled-1 (36)

Notes – How to Expand the Size of a Field

Introduction (Please Read): This document will provide you with the step needed to expand the size of any note field within the Realhound program. Step: In order to exand the size of any text field, simply click the mouse cursor into the desired field and then press the “Shift” and “F2” keys simultaneously. This will display an expanded note field for entry. Once complete, click the Ok button to close the screen. Field Zoom
MapPoint – How to Correct a Common Problem

MapPoint – How to Correct a Common Problem

Introduction (Please Read): The purpose of this document is to assist you with common errors with Microsoft MapPoint that you may receive. Sometimes MapPoint has to be re-registered in the registry to get it to work properly with 3rd party software. You are most likely to run into this problem after an upgrade if you are using MapPoint 2006. When you try to map properties you may get a series of error screens. Untitled-1 (28) Solution Steps: 1) Close Realhound® Live! 2) To fix, select Start->Run 3) Enter the following: c:\windows\system32\regsvr32.exe “c:\program files\microsoft mappoint\mappointcontrol.ocx” Untitled-1 (29) **Note: If the mappointcontrol.ocx file is not located in a file called “microsoftmappoint” this fix will not work. You must locate the file using Windows Search function. Untitled-1 (27) In this case, you will adjust the command line from: c:\windows\system32\regsvr32.exe “c:\program files\microsoft mappoint\mappointcontrol.ocx” TO c:\windows\system32\regsvr32.exe “c:\program files\microsoft mappoint2006\mappointcontrol.ocx” 4) Press OK and try to use MapPoint with the program.