[sprint doc](https://setseg.sharepoint.com/:x:/r/sites/DevelopmentTeam/_layouts/15/Doc.aspx?sourcedoc=%7B03274F1A-12FE-4CCC-993E-0FE53243F509%7D&file=Sprint%20Metrics.xlsx&action=default&mobileredirect=true) 1. tickets rows -> all tickets sheet 2. add sprint row at top for completed sprint, fil in columns with department % and totals 3. delete tickets content 4. fill in team member hours (PTO, flex, holiday) 5. 15 min before sprint meeting: - pull [unfished tickets report](https://setseg.atlassian.net/issue s/?filter=10305) -> paste into *Rollover Tickets sheet* - pull [prod support hours](https://setseg.atlassian.net/issues/?filter=10073) -> `sprint summary table` on *Overview sheet* 6. during closing sprint review: - update *Rollover Tickets sheet*, hours worked and add notes for ticket specific or sprint level rationale - identify & confirm `closed sprint highlights list` & `closed sprint holdups list` on *Overview sheet* 7. after closing sprint review, pull hours complete numbers from burnup reports [IAS](https://setseg.atlassian.net/jira/software/projects/IAS/boards/17/reports/burnup), [ITD](https://setseg.atlassian.net/jira/software/projects/ITDEV/boards/5/reports/burnup), [ITDT](https://setseg.atlassian.net/jira/software/projects/ITDATA/boards/15/reports/burnup) 8. during new sprint review: - identify & confirm `new sprint priorities list` on *Overview sheet* 9. during sprint retro: - identify & confirm `closed sprint highlights list` & `closed sprint holdups list` on *summary sheet* 10. pull new tickets from [BI Open Sprint](https://setseg.atlassian.net/issues/?filter=10306) into *tickets sheet* ```dv dv.paragraph(("https://jimr.fyi/" + dv.currentFilePath.replace(/\.md$/, "").replace(/ /g, "+"))) ```