The 14-day Sprint Backlog contains the output of a sprint planning meeting. It contains a list of tasks that the Scrum team needs to complete during the sprint in order to convert a selected set of product backlog items into deliverable functionality within a period of 14 days.

The 14-day Sprint Backlog contains identification of the various sprints, and capacity for an elapsed period of 14 days.

The spreadsheet consists of three sheets: 1) a 14-day sprint backlog table, 2) a capacity sheet, and 3) an instruction sheet providing instructions for updating the tables.

Formulas are embedded in the chart to calculate:

      Remaining Time for Work Item Each Day = Max (all previous Spent entries).
      Day Totals - total of Spent and Remain columns.

Scroll down to the Agile 14-Day Sprint Backlog example below.