realtor-team-ops
Rank your team's agents by production and see what each split plan really costs — feed an agent deals CSV (agent, deals closed, total volume, avg commission %) plus a split config and get per-agent GCI, split-adjusted brokerage net and agent net, and a ranking table. Use when reviewing team performance, comparing comp plans, or onboarding a new agent.
$ skillbank install realtor-team-ops@1.0.0 # pins exactly 1.0.0 · README + changelog included
Realtor Team Ops
Overview
A team productivity calculator that speaks comp plans. You keep one CSV of agent production (deals closed, total volume, average commission %) and one JSON split config supporting three plan types: fixed split (70/30), graduated split with a cap (80/20 with an $18,000 cap), and 100% with a flat desk fee. The script computes each agent's GCI, applies their plan, and prints a ranking table with split-adjusted brokerage net and agent net, plus team totals. All data stays local — nothing is uploaded.
Installation
1. Copy the realtor-team-ops/ directory anywhere convenient. 2. Make the script executable (Unix):
chmod +x scripts/productivity.py
No pip install needed — standard library only.
Configuration
Two files. The deals CSV must have exactly these columns (order does not matter):
| Column | Format | |----------------------|-------------------------------| | agent | Agent's name. | | deals_closed | Whole number. | | total_volume | Sales volume in dollars. | | avg_commission_pct | e.g. 2.5 for 2.5%. |
The split config is JSON:
{
"default": {"type": "split", "brokerage_pct": 30},
"agents": {
"Alice Morgan": {"type": "split", "brokerage_pct": 30},
"Bob Chen": {"type": "cap", "agent_split_pct": 80, "cap": 18000},
"Carol Diaz": {"type": "desk", "fee": 1200}
}
}
| Plan | Fields | Brokerage net | |--------|----------------------------------------------------|-----------------------------------| | split | brokerage_pct | GCI × brokerage % | | cap | agent_split_pct, cap | min(cap, GCI × (100 − agent %) / 100) | | desk | fee | Flat fee per period |
Agents not named in agents fall back to default. See references/split-structures.md for how each plan works in practice.
Inputs
productivity.py <deals.csv> --config <splits.json>
Returns, on stdout: a ranking table by GCI with per-agent deals, volume, commission %, GCI, plan, brokerage net, agent net, and a team totals row. Missing or invalid input produces a clear Error: message on stderr and exit code 2 — never a raw traceback.
Worked example
Four sample agents on three different plans:
cat > deals.csv <<'EOF'
agent,deals_closed,total_volume,avg_commission_pct
Alice Morgan,12,4200000,2.5
Bob Chen,8,2900000,2.5
Carol Diaz,15,5100000,2.4
Dave Ortiz,5,1650000,2.75
EOF
cat > splits.json <<'EOF'
{
"default": {"type": "split", "brokerage_pct": 30},
"agents": {
"Alice Morgan": {"type": "split", "brokerage_pct": 30},
"Bob Chen": {"type": "cap", "agent_split_pct": 80, "cap": 18000},
"Carol Diaz": {"type": "desk", "fee": 1200},
"Dave Ortiz": {"type": "split", "brokerage_pct": 40}
}
}
EOF
./scripts/productivity.py deals.csv --config splits.json
Output:
Team productivity ranking (by GCI)
Agent Deals Volume Comm% GCI Plan Brokerage net Agent net
---------------------------------------------------------------------------------------------------------
Carol Diaz 15 $5,100,000.00 2.40% $122,400.00 100% + $1,200.00 desk $1,200.00 $121,200.00
Alice Morgan 12 $4,200,000.00 2.50% $105,000.00 70/30 split $31,500.00 $73,500.00
Bob Chen 8 $2,900,000.00 2.50% $72,500.00 80% w/ $18,000.00 cap $14,500.00 $58,000.00
Dave Ortiz 5 $1,650,000.00 2.75% $45,375.00 60/40 split $18,150.00 $27,225.00
---------------------------------------------------------------------------------------------------------
TOTAL 40 $13,850,000.00 $345,275.00 $65,350.00 $279,925.00
Carol is your top producer on GCI — but on a desk plan she contributes the least to the brokerage. That tension is the point of the table: GCI measures production, the split-adjusted column measures what the brokerage actually keeps.
Version history
Changelog
1.0.0 — 2026-09-27
- Initial public release.
scripts/productivity.py: agent deals CSV + split config JSON → GCI ranking table with split-adjusted brokerage net and agent net (supports fixed split, split-with-cap, and 100%-plus-desk-fee plans).references/split-structures.md: 70/30, 80/20 with cap, and 100% with desk fee explained, plus guidance on picking between them.- Zero dependencies; tested with 4 sample agents on three plan types plus bad-input cases (bad number, missing default plan, missing config).