the ai pm akash’s Post

Alternatively, you can also use below prompt for a detailed capacity planning tracker. Prompt: Act as an Agile expert in sprint capacity planning. Create a Sprint Capacity Planning Tracker for a Scrum team in an Agile software development project for [insert sprint duration: e.g., 2 weeks / 10 working days]. The tracker should estimate team capacity in both hours and Story Points, considering factors such as: [insert team size: e.g., 5 members] [insert individual availability: e.g., 8/10 working days] [insert planned leaves: e.g., 1 day off for member X] [insert public holidays: e.g., 1 holiday during sprint] [insert focus factor: e.g., 0.8 (80% productive capacity)] Present the tracker in a structured table format (Excel/Google Sheets friendly), including formulas or logic to auto-calculate effective capacity for each team member and the overall team. Show both raw capacity and effective capacity. Include sample data for a 2-week sprint as an example, and also provide clear instructions on how the team can update and adapt this tracker for future sprints.