Manage pipeline by next action
A pipeline is only useful when every active opportunity has a concrete next action and date. Use stages for reporting, but use next actions for daily execution.
Weight pipeline instead of counting every deal equally
A new lead and an under-contract client should not carry the same forecast weight. Probability-weighted transaction value gives a more realistic pipeline view, while still remaining an estimate.
Track activity-to-result conversion
Calls alone are activity, not outcome. Conversation-to-appointment conversion helps identify whether prospecting quality is improving.
Commission is not take-home pay
The workbook estimates commission from transaction value, rate, split and transaction expenses. Brokerage fees, taxes and other business costs can require separate accounting.