Operations template
KPI Tracker Template
Follow the numbers that matter. Each KPI shows progress against target and is flagged when it's behind.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | KPI | Target | Actual | Progress | Status |
| 2 | New customers | 200 | 172 | =C2/B2 | =IF(D2>=0.9,"On track","Behind") |
| 3 | Revenue | 1,500,000 | 1,420,000 | =C3/B3 | =IF(D3>=0.9,"On track","Behind") |
| 4 | NPS | 50 | 41 | =C4/B4 | =IF(D4>=0.9,"On track","Behind") |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =C2/B2
Actual divided by target.
E2 =IF(D2>=0.9,"On track","Behind")
On track at 90% of target or more.
Make it yours by asking
Try a request like this in Tabstra:
"Create a KPI tracker with KPI, target, actual, progress and an on track or behind status"