Differences

This shows you the differences between two versions of the page.

--- psl-agile-excel:manual:scrum-approach [2024/02/23 18:51] – João Saraiva
+++ psl-agile-excel:manual:scrum-approach [2024/02/23 19:00] (current) – João Saraiva
@@ Line 109: / Line 109: @@
 ===== Sprint Backlog History =====
+{{:psl-agile-excel:manual:sprint_history.png?nolink|}}\\
+In the PSL-Agile Excel Template, the Sprint Backlog History sheet lets you maintain a comprehensive record of past sprints for reference and analysis. The Sprint Backlog History is a valuable resource for retrospective assessments, performance analysis, and historical data reference, enabling your agile project management to improve and adapt continuously based on past experiences. However, only the premium version provides more advanced features.
+==== Ribbon Actions ====
+**Set Filter to Sprint History (Premium)**: With this action, you can establish specific filters to focus on particular sets of sprints. For instance, you can filter sprints within a designated range, like Sprints 3 to 5. Alternatively, you can apply date-based filters, such as sprints started or concluded in a particular year, such as 2024 to 2025. This filtering capability streamlines your ability to analyse sprints of interest.\\
+**Sprint History Configuration (Premium)**: Customise the display of your sprint log to suit your preferences and requirements. You can configure what information is presented in the sprint log. Your configuration options include:
+  - Sprint Summary: Decide whether to include a summary of each sprint in the log, providing a high-level overview of its key details.
+  - Sprint Backlog Items: Choose whether to display a detailed list of sprint backlog items associated with each sprint. This allows for a thorough examination of the tasks completed during the sprint.
+  - Sprint Burndown Chart: Choose to include a visual representation of the sprint's burndown chart in the log. This chart visually depicts work progress throughout the sprint, showing how the team's effort evolved.
-===== Scrum Analyzer (Premium) =====
+===== Sprint Analyzer (Premium) =====
+The Sprint Analyzer feature in the PSL-Agile Excel Template empowers you to gain insights and evaluate the performance of completed sprints effectively. It provides a structured table and graphical representation of key metrics for each finished sprint, allowing for in-depth analysis based on the following information:\\
+Sprint ID: Each sprint is uniquely identified by its Sprint ID.\\
+Sprint Duration (d): This column provides the duration of the sprint in days.\\
+Number of Team Members Assigned to the Sprint: Here, you can see the count of team members allocated to the sprint.\\
+Tasks: This section includes task-related metrics:
+  - Number of Assigned Tasks: Indicates the total number of tasks assigned during the sprint.
+  - Number of Concluded Tasks: Reflects the count of tasks completed during the sprint.
+  - % Concluded Tasks: The percentage of tasks concluded concerning the total assigned tasks.
+Effort: This category tracks effort-related metrics:
+  - Assigned Effort (h): Specifies the total effort in hours initially assigned to the sprint.
+  - Actual Effort (h): Represents the actual effort in hours expended during the sprint.
+  - % Effort (h): Indicates the percentage of effort utilised concerning the initially assigned effort.
+Story Points Concluded: This column displays the total story points concluded during the sprint.
+==== Ribbon Actions ====
+**Graph Configuration (Premium)**: With this action, you can configure the graphical representation of the sprint data according to your preferences. Tailor the chart to emphasise specific metrics or trends most relevant to your analysis.\\
+**Update from SprintBacklog (Premium)**: Utilise this action to automatically update the Sprint Analyzer with data from the Sprint Backlog. This command ensures that your analysis is based on the most current and accurate information available.
+The Sprint Analyzer feature offers a broad view of completed sprints, enabling you to identify trends, assess team performance, and make data-driven decisions for future sprints.