How to use it
- Add each open estimate, or start with your ten largest.
- Work the list top down. Mark each one won, lost or still open.
- Fill in your company fields once and every template updates.
Fictional example: Ridgeline Roofing
Ridgeline lists 14 open estimates totaling $168,000. Five are over 90 days old. The list puts a $24,000 estimate from three weeks ago ahead of a $9,000 one from last spring. Ridgeline does not count the $168,000 as money coming. Most of it may never sell.
Checklist
How the math works
- Open value is the sum of estimates marked open.
- Age is days since sent.
- Priority is amount divided by (1 + age in days / 30), so large, recent estimates rise.
- Potential is blank unless you enter your own win-back rate.
Good to know. Open value is what you have quoted, not what you will collect. A stale estimate is not recoverable by default. Potential only shows when you enter your own rate, and it is a scenario.
Want the 5-day series?
Optional. Your results above are yours either way, and your numbers are never sent.