Tasks of the Project Manager

$X is the number of the previous sprint.
$Y is the number of the current sprint.
$NAME(Z) is the name of sprint Z.
$DIAGRAMS(Z) is the sheet storing the diagrams for sprint Z.

  • At the moment, these sheets are called Diagramme $Z - $NAME(Z) $TIMES(Z) is the sheet storing the times worked in sprint Z.

  • At the moment, these sheets are called Zeiten $Z - $NAME(Z)

First Day of the Sprint

  • Copy the most important statistics from $DIAGRAMS(X) to the last row of Sprints

  • Create an issue with 0 storypoints that is closed immediately

  • Copy $DIAGRAMS(X) to $DIAGRAMS(Y)

  • Protect $DIAGRAMS(Y)

  • In $DIAGRAMS(Y)!K2, select the new sprint this sheet should track

  • Add last row to sheet Sprints with the new Sprint name, the sprint starting date (inclusive), the sprint ending date (inclusive, so use a day prior).
    All rows that are not automatically filled can be copied from the row above except every occurence of $DIAGRAMS(X) should be replaced with $DIAGRAMS(Y)

  • Archive and protect the sheet $DIAGRAMS(X)

  • Copy the sheet Zeiten to the archived and protected sheet $TIMES(X)

  • Clear the sheet Zeiten except for the first row (columns) and potential times that were entered for the next sprint already

  • Make sure there is a entry which gives the invisible worker 0 minutes today

  • Add the entry ;'TIMES(Y)'!A$2:F to the end of the array in sheet Gesamtzeiten!A1

  • Enjoy everything working correctly

Last Day of the Sprint

  • Create an issue with 0 storypoints that is closed immediately

  • One-time-setup for the automation script: Execute git clone https://Gamify-IT/issues.git; cd issues; python -m venv venv; . venv/bin/activate && pip install -r requirements.txt && cp $GOOGLE_OAUTH_SECRETS_FILE secrets.json && cp $GOOGLE_SHEET_ID_FILE sheet-id.txt. Optional: cp $GITHUB_PAT_FILE github-pat.txt

  • Setup automation script: Execute . venv/bin/activate

  • Execute automation script: Execute python spreadsheet-issue-updater.py

  • Manually enter the current sprint in the sheet Issues!G for all issues that were worked on in this sprint

  • Close all remaining open issues that were worked on in this sprint in GitHub

  • IMPORTANT: Do not execute script above anymore after the previous step, or the diagrams will be wrong!

  • Prepare the rest of the review presentation

  • Name both the latest versions of the presentation and of the sheets to be able to find them later again