WB WorkbookBarn All workbooks

Free calculator · nothing to download

Sphere of Influence Tracker

Set your rules on the left. The right side reads your contact list and adds it up.

TOUCH CADENCE — DAYS BETWEEN CONTACTS
REFERRALS PER PERSON PER YEAR
YOUR OWN NUMBERS

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.

ContactHow you know themCloseness 1-5Trust in your work 1-5Their reach 1-5Likely to move or refer 1-5Last contactTouches last 12 moDeals from them so farScoreTierTouch every (days)Next touch dueDays overdueStatusExpected referrals / yrWhat 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.

Get the workbook · $19.99

See what is inside the workbook

Keep it

Sphere of Influence Tracker: the full workbook

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.

Buy on Etsy · $19.99What is inside →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

Last updated: October 2026

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.

WorkbookBarn · All free calculators · Workbooks