Confluence - FullstackCodingGuy/Developer-Fundamentals GitHub Wiki

Absolutely! You can definitely create a smart, visual, and interactive capacity planning table in Confluence for your team. While Confluence isn't a spreadsheet tool like Excel, it does offer great flexibility through tables, macros, templates, and third-party plugins.

Here’s a structured approach to do capacity planning for team members in Confluence, including smart enhancements:

Create a table like this:

• Focus Factor = Time for project work (accounts for meetings, interruptions)

• Actual Capacity = Adjusted for both availability and productivity

• Use Confluence templates to create a reusable “Capacity Planning” page for each sprint.

• Use @mentions and tasks to assign updates to team members.

• Consider using Confluence Forms (Confiforms) to create a structured input form for team availability.

Would you like a template you can copy-paste directly into Confluence or a downloadable format (like Excel or CSV) that can be embedded?

Here’s a structured approach to do capacity planning for team members in Confluence, including smart enhancements:

Create a table like this:

📝 You can manually compute the last column (Available Hours) or use an advanced table macro.

This plugin allows:

• Excel-like formulas inside Confluence tables
• Interactive filters, dropdowns, aggregations
• Real-time charts and summaries

You can:

1. Create a table like the one above.
2. Use the Table Spreadsheet macro to apply Excel-style formulas for calculations.
3. Add filters for team members or sprints.
4. Add a bar chart or pie chart to visualize total and available capacity.

🔌 Plugin link: [Table Filter and Charts for Confluence](https://marketplace.atlassian.com/apps/1210934)

With Team Calendars, you can:

• Track each team member’s leave, public holidays, and sprint periods
• Overlay calendars to avoid conflicts
• Link to Jira sprint dates if integrated

Then calculate capacity based on the number of working days and export to a table.

If you're using Jira with Advanced Roadmaps, you can:

• Use Team Capacity Planning View
• Automatically factor in leaves, holidays (via linked calendars), sprint lengths
• Reflect each team member’s allocation per sprint

Then embed the Jira capacity view in Confluence using the Jira Issues macro or a live dashboard.

• Focus Factor = Time for project work (accounts for meetings, interruptions)
• Actual Capacity = Adjusted for both availability and productivity

• Use Confluence templates to create a reusable “Capacity Planning” page for each sprint.
• Use @mentions and tasks to assign updates to team members.
• Consider using Confluence Forms (Confiforms) to create a structured input form for team availability.

Great! Here’s a copy-paste friendly Confluence table template for capacity planning per sprint, along with a downloadable Excel version (linked below) you can embed or attach to your Confluence page for easier calculations.

You can paste this directly into a Confluence page using the table editor:

|| Team Member || Sprint || Working Days || Hours/Day || Base Hours || Leaves || Holidays || Focus Factor || Available Hours || Notes ||
| Alice        | Sprint 12 | 10          | 8         | =10×8=80    | 1      | 1        | 0.8           | = (80 - (1+1)×8)×0.8 = 51.2 |   |
| Bob          | Sprint 12 | 10          | 7         | =10×7=70    | 2      | 0        | 0.75          | = (70 - 2×7)×0.75 = 45.0   |   |
| Charlie      | Sprint 12 | 10          | 6         | =60         | 0      | 2        | 0.85          | = (60 - 2×6)×0.85 = 42.5   |   |

🔢 You can use the Table Spreadsheet macro (if installed) to calculate directly in the table.

Here’s a link to download the Excel version: 👉 [Download Excel: Capacity_Planning_Template.xlsx](sandbox:/mnt/data/Capacity_Planning_Template.xlsx)

If you want to go next level:

• Use Team Calendars to calculate Working Days excluding weekends/holidays.
• Connect this table to Jira sprint boards to automate sprint durations.
• Use filters and charts (with Table Filter and Charts macro) to visualize capacity burn.

Your automated Excel tool for Sprint Planning is ready! It includes:

• ✅ Team Definition
• 📅 Sprint Availability
• 🧮 Capacity Planning
• 📋 Story Point Allocation
• 📈 Efficiency Planning
• 🔥 Burndown Chart with Line Graph

Sprint_Planning_Tool.xlsx

Great question!

The Focus Factor column in sprint capacity planning represents a realistic productivity ratio for each team member. It accounts for the fact that not all working hours are spent on focused, sprint-related tasks due to:

• Meetings (daily stand-ups, grooming, retros)

• Emails, context switching

• Support tasks, production issues

• Unplanned work

Focus Factor is typically a decimal between 0.6 and 1.0 (i.e., 60% to 100%).

If a team member is available for 40 hours, and their focus factor is 0.8, then their effective availability for sprint tasks is:

Effective Hours = 40 × 0.8 = 32 hours

Would you like a slider or calculator in the Excel tool to help decide the right focus factor per person?