Sprint Planning
Our department uses it's own flavor of Agile and the teams are geo-located around the world. Some of the nuances include 8 vs. 9 hour workdays and varying statutory holidays depending on locale. 1SP is also equivalent to 6.4 hours. I created a capacity planning Excel workbook to facilitate iteration planning.
You enter the number of working days, holidays, and vacation and the workbook will automatically calculate the capacity per team member.
We have several streams (components) of developers: front end, back end, AEM, SAP Hybris. To avoid overloading any specific stream the workbook also calculates the capacity per component.
We're unable to add custom fields to our JIRA instance so we capture the component estimates in comments. The workbook also includes a macro which will crawl through a Jira report and extract the per stream estimates from each ticket. It creates a new worksheet with the total SP estimate per component. This can then be pasted into the main worksheet to compare against the per component capacity. If the load to capacity ratio falls outside a configurable threshold it will highlight those components in red.