The Scenario
The quarterly business review is in three days and your agile coach handed you a task: build a velocity trend chart in Excel covering the last eight sprints. The numbers — sprint names, story points committed, story points completed — are in Jira. They have never been in this workbook. You have one afternoon to get the chart ready before the slide deck locks.
The bad version:
- Open Jira, navigate to Reports, find the Velocity Chart.
- Read each sprint's bar value from the chart. The axis increments in fives and the bars don't land on clean numbers.
- Type your best estimate into the workbook for each of the eight sprints.
- Realize you might have read sprint 5 wrong because the bar was partially hidden behind a tooltip.
A chart built on visual estimates from a bar chart is not a number the QBR presenter wants to defend. And next quarter, you do this again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the workbook and through the Jira integration fetches actual sprint records — not chart screenshots — and writes the numbers directly into your cells.
List the last 8 completed sprints on Jira board 42 and write sprint name, start date, end date, and total story points of completed issues into columns A, B, C, D.
What You Get
- Eight rows, one per sprint, with sprint name, start date, end date, and completed story points in columns A through D.
- Points reflect actual Done issues from each sprint — the same source Jira's velocity chart reads, not a visual estimate.
- Dates are in ISO format, ready for a chart's date axis.
- With the raw numbers in the workbook you can build whatever chart shape the QBR needs.
What If the Data Is Not Quite Ready
You need both committed and completed points for each sprint
The QBR needs to show whether the team consistently over- or under-commits.
For each of the last 8 completed sprints on Jira board 42, write the sprint name, total story points of all issues added to the sprint, and total story points of completed issues into columns A, B, and C.
The sprint names in Jira are verbose and you want shorter labels
Sprint names like "Backend Team Sprint 2025-Q1-W3" need to become "Q1 S3" in the workbook.
Fetch the last 8 completed sprints on Jira board 42 and write sprint name, start date, and completed story points into columns A, B, D. In column A, simplify each sprint name to a short label like 'Sprint 1', 'Sprint 2', numbered chronologically.
Sprint names are already in column A and you just need the story points filled in
The workbook has eight sprint labels typed in, but the point data has never been populated.
For each sprint name in column A of my Velocity sheet, search Jira for all Done issues in that sprint on board 42 and sum their story points, writing the total into column B.
Kill chain: fetch velocity, calculate rolling average, and flag declining sprints
Fetch the last 8 completed sprints on Jira board 42 and write sprint name and completed story points into columns A and B. In column C, calculate the 3-sprint rolling average. Flag any sprint where completed points are more than 20% below the rolling average with 'Declining' in column D.
One prompt pulls the data, does the math, and adds the flag — no formulas to write by hand before the QBR.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before the next quarterly review, then ask it to pull the last eight sprints from your Jira board and write the velocity numbers into rows. See also: how to pull project versions for release planning and how to export team workload by assignee.