Differences

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

--- psl-agile-excel:manual:scrum-approach [2024/02/23 17:28] – [Product Backlog Item Properties] João Saraiva
+++ psl-agile-excel:manual:scrum-approach [2024/02/23 19:00] (current) – João Saraiva
@@ Line 62: / Line 62: @@
 ===== Sprint Backlog =====
+{{:psl-agile-excel:manual:sprint_backlog.png?nolink|}}\\
+The Sprint Backlog in the PSL-Agile Excel Template is designed to facilitate effective sprint management. These are the key functionalities for this section: Start New Sprint; Manage Current Sprint; and Finish Sprint.
+==== Start New Sprint ====
+The command “Start New Sprint” (available from  SprintBacklog group) enables you to initiate a new sprint with precise configuration parameters:\\
+**Sprint Number**: Assign a unique number to the sprint for identification purposes.\\
+**Number of Team Members**: Specify the count of team members participating in the sprint.\\
+**Start Date**: Set the commencement date of the sprint.\\
+**Team Member Allocation %**: Define the percentage of each team member's time allocated to this sprint.
+**Duration (d)**: Determine the duration of the sprint in days.\\
+**Daily Work Hours (h)**: Set the number of daily work hours for the sprint.\\
+**Keep Not Completed Tasks from Current Sprint**: Choose whether to copy tasks not completed from the current sprint to this new sprint.
+=== Sprint Backlog Item Properties ===
+ID: Each task in the Sprint Backlog is assigned a unique identification number (ID) for tracking and reference.\\
+Task Name and Description: A brief name and informative task description.\\
+Product Backlog Item: Link the task to the corresponding Product Backlog Item, establishing a clear relationship.\\
+Assigned To (Team Member(s)): Specify which team member(s) are responsible for executing the task.\\
+Planned Effort (h): Estimate the effort required to complete the task in hours.\\
+Remaining Effort (h): Reflect the remaining effort necessary to finish the task, updated regularly, such as at the end of each day. Write here the Remainder Effort Per Task each day (It can be higher): A field to note any additional effort required for a task on specific days. The "Waiting" status indicates that the day has not been reached yet.\\
+Actual Effort (h): Record the actual time spent on the task, with updates made, for example, at the end of each day.\\
+Status (Backlog (or To-Do), In-Progress, Done): Define the current status of the task within the sprint, whether it is still in the backlog, actively being worked on, or completed.\\
+Total Row: This row calculates the "Actual" values in the chart, allowing for easy tracking and summing of efforts.
+==== Manage Current Sprint ====
+=== Table-Based Actions ===
+**Add new line (Task) to table**: Insert a new task line and fill the relevant cells with task details.\\
+**Edit Task**: Modify task details directly within the respective line cells, such as task name, description, or planned effort (h).\\
+**Assign Resources to Task**: Assign team members to tasks by double-clicking on the "Assigned to" cell, streamlining task allocation.\\
+**Delete Task(s)**: Select and delete specific task lines as needed, maintaining a clean and organised Sprint Backlog.
+=== Ribbon Actions ===
+**Generate IDs**: Automatically assign unique identification numbers to new tasks, ensuring orderly tracking.\\
+**Update from Kanban in Progress (Premium)**: Sync task progress with the Kanban In-Progress section, ensuring accurate and up-to-date information.\\
+**Update from Product Backlog (Premium)**: Streamline task management by updating tasks directly from the Product Backlog.
+==== Finish Sprint ====
+When the current sprint concludes, you can utilise the "Finish Sprint" command (a ribbon action). This action transitions the sprint's status to "Closed", and all related sprint backlog items are moved to the "SprintHistory" worksheet. This archival process is crucial for future reference, analysis, and retrospective assessments of completed sprints.
 ===== 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.
+===== 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 ====
-===== Scrum Analyzer (Premium) =====
+**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.