{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Product Backlog","Iterations","Interruptions","HiddenCapacityTab","LocalizeableStrings"],"not_rendered":{"charts":1,"macros":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Product Backlog","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Iterations","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[1,0,1,7],[2,0,2,7],[6,5,8,8],[7,2,7,4],[23,6,23,7]]}
["Iterations"]
["Use this worksheet to balance your team’s workload between iterations.  For detailed instructions on how to use this workbook, see Product Backlog Workbook at http://go.microsoft.com/fwlink/?LinkId=145657."]
["  Step 1:  For each iteration, fill in a row of the Story Ponits per Iteration table. Select  an Iteration and then type the Start Date, End Date, and the Team Size for that iteration. (The Days column is calculated based on the start and end dates. The Planned and Delivered Story Points columns are calculated from the product backlog worksheet).\n  Step 2:  Enter holidays and vacation in to the Interruptions worksheet. The number of days in each iteration in the Interations worksheet will be updated to reflect those interruptions.\n  Step 3:  Switch to the Product Backlog worksheet to assign user stories to different iterations in order to balance the workload between iterations.\n"]
[null,{"$f":"IF(1, IF(ISERR(MacrosEnabled()), \"This workbook will not behave correctly with macros disabled.  Review the Security Warning in the Message Bar above.\", \"\"), TODAY())","v":""}]
[]
[null,"Area Filter"]
[null,"Area Filter"]
[null,"Area:","\\"]
{"$rows_empty":15}
[null,"Story Points per Iteration"]
[null,"Iteration","Start Date","End Date","Team Size","Days","Planned","Delivered"]
[null,"\\Iteration 1",{"$nulls":3},{"$f":"IF(AND(ISNUMBER(PlannedIterations[[#This Row],[Start Date]]),ISNUMBER(PlannedIterations[[#This Row],[End Date]])),NETWORKDAYS(PlannedIterations[[#This Row],[Start Date]],PlannedIterations[[#This Row],[End Date]],Holidays[Date]),\"\")","v":""}]
[null,"\\Iteration 2",{"$nulls":3},{"$f":"IF(AND(ISNUMBER(PlannedIterations[[#This Row],[Start Date]]),ISNUMBER(PlannedIterations[[#This Row],[End Date]])),NETWORKDAYS(PlannedIterations[[#This Row],[Start Date]],PlannedIterations[[#This Row],[End Date]],Holidays[Date]),\"\")","v":""}]
[null,"\\Iteration 3",{"$nulls":3},{"$f":"IF(AND(ISNUMBER(PlannedIterations[[#This Row],[Start Date]]),ISNUMBER(PlannedIterations[[#This Row],[End Date]])),NETWORKDAYS(PlannedIterations[[#This Row],[Start Date]],PlannedIterations[[#This Row],[End Date]],Holidays[Date]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(ISNUMBER(PlannedIterations[[#This Row],[Start Date]]),ISNUMBER(PlannedIterations[[#This Row],[End Date]])),NETWORKDAYS(PlannedIterations[[#This Row],[Start Date]],PlannedIterations[[#This Row],[End Date]],Holidays[Date]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(ISNUMBER(PlannedIterations[[#This Row],[Start Date]]),ISNUMBER(PlannedIterations[[#This Row],[End Date]])),NETWORKDAYS(PlannedIterations[[#This Row],[Start Date]],PlannedIterations[[#This Row],[End Date]],Holidays[Date]),\"\")","v":""}]

{"sheet":"Interruptions","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"merged":[[1,0,1,9],[2,0,2,9]]}
["Interruptions"]
["Use this worksheet to describe planned interruptions to your team’s schedule."]
["  Step 1:  Add holidays that the entire team will take in the Holidays table.  The Days column on the Iterations worksheet will not count these days toward the total number of days in the iteration."]
[]
[null,"Holidays"]
[null,"Description","Date"]

{"sheet":"HiddenCapacityTab","index":3,"n_rows":2,"n_cols":5,"rows_kept":2,"hidden":true}
["Iteration List","Area List",null,"Formulas Updated Flags"]
["\\","\\",null,"Iteration Planning",0]

{"sheet":"LocalizeableStrings","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"hidden":true}
["Messages","Fields","Other"]
["The Product Backlog query was not bound to this workbook.  Use the Team tab and create a new list.","Area Path","Active"]
["One or more required fields are not present in the Product Backlog query results: {0}","Iteration Path"]
["Show Guidance","Title"]
["Hide Guidance","Story Points"]
[null,"State"]