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

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 →

Get the next free tool

One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.

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