Differences

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

--- psl-agile-excel:manual:scrum-approach [2024/02/23 17:26] – João Saraiva
+++ psl-agile-excel:manual:scrum-approach [2024/02/23 19:00] (current) – João Saraiva
@@ Line 36: / Line 36: @@
 Item Name and Description: The item shall have a concise name and a comprehensive description outlining what needs to be done or achieved.\\
 Type: The type of item is defined, distinguishing between new user stories, features, enhancements, or bug fixes.\\
-Planned and Actual Efforts: This section measures the estimated and actual efforts required to complete the item. (1) Planned (in hours): The planned time expected to be spent to complete the product item. (2) Actual (in hours): The actual time spent on the item, tracked as it progresses.\\
+Planned and Actual Efforts: This section measures the estimated and actual efforts required to complete the item.
-Priority: The product item's priority is critical in determining when it should be worked on. It is assessed based on two criteria: (1) Priority (VLo to VHi): A subjective rating indicating the item's importance, ranging from Very Low (VLo) to Very High (VHi); or (2) a numerical value indicating the item's importance in a more flexible scale (e.g., 1 to 10 scale).\\
+  - Planned (in hours): The planned time expected to be spent to complete the product item.
-Sprint: This section defines the sprint-related details for the item: (1) Initial: The sprint in which the item was initially planned to be worked on; and (2) Final: The sprint in which the item was expected to be completed.\\
+  - Actual (in hours): The actual time spent on the item, tracked as it progresses.
-Dates: Tracking the timing of items is crucial for managing the project. Two dates are provided: (1) Created: When the item was added to the Product Backlog; and (2) Last Updated: The date when the item was last modified or updated.\\
+Priority: The product item's priority is critical in determining when it should be worked on. It is assessed based on two criteria:
-Status: This field reflects the item's current state within the backlog. It can be one of the following: (1) Backlog: The item is in the backlog, awaiting prioritisation; (2) In-Progress: The item is actively being worked on by the development team; and (3) Done: The item has been completed and meets the definition of done for the sprint.
+  - Priority (VLo to VHi): A subjective rating indicating the item's importance, ranging from Very Low (VLo) to Very High (VHi); or
+  - a numerical value indicating the item's importance in a more flexible scale (e.g., 1 to 10 scale).
+Sprint: This section defines the sprint-related details for the item:
+  - Initial: The sprint in which the item was initially planned to be worked on; and
+  - Final: The sprint in which the item was expected to be completed.
+Dates: Tracking the timing of items is crucial for managing the project. Two dates are provided:
+  - Created: When the item was added to the Product Backlog; and
+  - Last Updated: The date when the item was last modified or updated.
+Status: This field reflects the item's current state within the backlog. It can be one of the following:
+  - Backlog: The item is in the backlog, awaiting prioritisation;
+  - In-Progress: The item is actively being worked on by the development team; and
+  - Done: The item has been completed and meets the definition of done for the sprint.
 ==== Actions ====
@@ Line 51: / 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.