Loading
Fill this in before the planning meeting, not during it.
| Person | Days in sprint | Leave | Meetings % | Hours available |
|---|---|---|---|---|
| A. Whitlock | 20% | =(B4-C4)*8*(1-0.2) | ||
| R. Osei | 30% | =(B5-C5)*8*(1-0.3) | ||
| M. Farah | 20% | =(B6-C6)*8*(1-0.2) | ||
Meetings percentage is the honest part. A team that says 0% is planning to work late.
What could go in. Ordered, estimated, and not yet promised.
| Item | Estimate (h) | Priority | Owner | In sprint |
|---|---|---|---|---|
| Import mapping for CSV | High | A. Whitlock | Yes | |
| Retry on failed webhook | High | R. Osei | Yes | |
| Export to Sheets | Medium | No | ||
An item with no estimate cannot be committed to. Estimate it or leave it out.
Formulas. Committed hours against hours available.
| Measure | Hours |
|---|---|
| Available | =SUM(Capacity!E:E) |
| Committed | =SUMIF(Backlog!E:E,"Yes",Backlog!B:B) |
| Headroom | =B4-B5 |
Negative headroom is not ambition, it is a plan to miss.
Hours here, because capacity is in hours and the two have to be comparable. If your team estimates in points, convert once at the top rather than keeping both.
Change Days in sprint on the capacity sheet. Everything downstream is a formula.