BUY WITH CONFIDENCE
BENEFITS OF DOCUMENT
DESCRIPTION
An editable MS Excel template for an Agile Burn Down and Burn Up chart in situations where other technologies are unavailable.
This Excel spreadsheet may be customised to fit your Agile Scrum project as needed.
The Agile Sprint burn-down chart table of points burnt for a certain Sprint is located on Tab 1. The shown sprint has a period of 6 days, which is a common scenario for a sprint duration. Change this to reflect the sprint length and, if necessary, add the tasks' context and points per task. Simply duplicate this tab, increment to the next Sprint cycle, and continue for each Sprint in the Agile project.
Tab 1: The table on Tab 1 is the Sprint burn-down parameters. This gives the sprint's representation of the predicted and actual narrative points burned, Sotry Points, and Backlog Tasks. Make a new worksheet tab and copy and rename to the next Sprint if needed.
Tab 2: The burn-up table and chart represent the forecast and actuals, estimated points and total completed across the whole Agile Scrum project.
Tab 3: An alternate Burn Down chart covering a period of 30 days
Tab 4: A visualization of the Sprint POaP and Sprint Data
Tab 5: A 16-Day Sprint, with editable parameters of Total Allocated Dev Resources, Total Scrum Meetings Planned During Project, Total number of days During Sprint, Story Points accepted by team(s) within a given Sprint Period, Number of user stories accepted by team during period
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Agile, Scrum Excel: Agile Scrum Sprint Burn Down Chart Burn Up Chart Template x3 Excel (XLSX) Spreadsheet, Willcox PMO
OVERVIEW
As a senior Project Manager at Willcox PMO I oversee all functions relating to the development of the company, and as a previous network architect at Cisco; I also oversee all aspects of the company's IT development. [read more]
Ask the Author a Question
Agile Scrum Core Competencies Competitive Advantage Organizational Design Business Transformation Product Management Project Management Value Chain Analysis Analytics Business Continuity Planning Shareholder Value Business Impact Analysis Account Management Sales PowerPoint Diagrams Compilation ESG Strategy Development Example Organizational Structure Matrix Organization Kanban
Download our FREE Digital Transformation Templates
Download our free compilation of 50+ Digital Transformation slides and templates. DX concepts covered include Digital Leadership, Digital Maturity, Digital Value Chain, Customer Experience, Customer Journey, RPA, etc. |