Set your rules on the left. The right side reads your contact list and adds it up.
WHAT YOU HAVE
People in the database—
Tier A relationships—
Tier B relationships—
Tier C and D relationships—
Average relationship score—
WHO IS SLIPPING
Overdue right now—
Due in the next seven days—
No last-contact date entered—
Share of the database on track—
Longest silence, in days—
WHAT THE DATABASE IS WORTH
Expected referrals a year—
Expected closings a year—
EXPECTED COMMISSION A YEAR—
People in the database per closing—
What one name is worth a year—
WHAT IT COSTS YOU
Touches a year at this cadence—
Touches a week—
Hours a week on the database—
Commission per hour of touching—
Contact Database
One row per person. Score the four blue columns 1-5, add the last contact date, and the rest fills itself in.
Contact
How you know them
Closeness 1-5
Trust in your work 1-5
Their reach 1-5
Likely to move or refer 1-5
Last contact
Touches last 12 mo
Deals from them so far
Score
Tier
Touch every (days)
Next touch due
Days overdue
Status
Expected referrals / yr
What to talk about next time
1
—
—
—
—
—
—
—
2
—
—
—
—
—
—
—
3
—
—
—
—
—
—
—
4
—
—
—
—
—
—
—
5
—
—
—
—
—
—
—
6
—
—
—
—
—
—
—
7
—
—
—
—
—
—
—
8
—
—
—
—
—
—
—
9
—
—
—
—
—
—
—
10
—
—
—
—
—
—
—
11
—
—
—
—
—
—
—
12
—
—
—
—
—
—
—
13
—
—
—
—
—
—
—
14
—
—
—
—
—
—
—
15
—
—
—
—
—
—
—
Where that leaves you
—
Want it as a spreadsheet you own?
The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts,
and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.
Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.
One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.
Done — you are on the list.
Something went wrong. Please try again.
Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.