{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Iteration Backlog","Settings","Interruptions","HiddenCapacityData","Capacity","Burndown","BurndownData","LocalizableStrings"],"not_rendered":{"charts":3,"macros":1,"defined_names":60,"pivot_tables":1},"read":"whole","date_system":"1900"}

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

{"sheet":"Settings","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[1,0,1,16],[2,0,2,16],[7,2,7,7],[8,2,8,7],[18,1,21,7],[18,8,21,11]]}
["Settings"]
["Use this worksheet to begin your iteration planning.  For detailed instructions on how to use this workbook visit:  http://go.microsoft.com/fwlink/?LinkId=145659"]
["  Step 1:  Select the appropriate Area and Iteration.   \n  Step 2:  Enter the Start Date and End Date for the iteration. \n  Step 3:  Switch to the Interruptions worksheet to enter interruptions to the iteration."]
[null,{"$f":"IF(1, IF(ISERR(MacrosEnabled()), LocalizableStrings!A13, \"\"), TODAY())","v":""}]
[]
[null,"Area & Iteration"]
[null,"Step 1"]
[null,"Area","\\"]
[null,"Iteration","\\Iteration 1"]
[]
[null,"Dates"]
[null,"Step 2"]
[null,"Start Date",null,{"$f":"IF(OR(ISNUMBER(IterationStart),ISBLANK(IterationStart)), \"\", LocalizableStrings!A16)","v":""}]
[null,"End Date",null,{"$f":"IF(OR(ISNUMBER(IterationEnd),ISBLANK(IterationEnd)), \"\", LocalizableStrings!A16)","v":""}]
[null,"Days*",{"$f":"IF(AND(ISNUMBER(IterationStart),ISNUMBER(IterationEnd)),IF(IterationStart>IterationEnd,0,NETWORKDAYS(IterationStart,IterationEnd,Holidays[Date])), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(IterationStart),ISNUMBER(IterationEnd)),\n        IF(IterationStart>IterationEnd, LocalizableStrings!$A$12,IF(ISERROR(IterationDays), LocalizableStrings!$A$20, \"\")),\n        \"\"\n)","v":""}]
[]
[null,"  * Accounts for holidays entered for the Team in the Interruptions tab."]

{"sheet":"Interruptions","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[1,0,1,6],[2,0,2,6],[21,1,24,5]]}
["Interruptions"]
["Use this worksheet to describe planned interruptions in your team’s schedule for this iteration."]
["  Step 1:  Add Days that individuals plan to be off work in the Planned Interruptions table.\n  Step 2:  Add holidays or days when the entire team will not be working during in this iteration in the Holidays table.  The Days column on the Settings worksheet will not count these days toward the total number of days in the iteration. \n  Step 3:  Switch to the Capacity worksheet to continue."]
[null,{"$f":"IF(1, IF(ISERR(MacrosEnabled()), LocalizableStrings!A13, \"\"), TODAY())","v":""}]
[]
[null,"Planned Interruptions"]
[null,"Team Member","Description","Start Date","End Date","Days","Remaining Days"]
[{"$nulls":5},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),NETWORKDAYS(PlannedInterruptions[[#This Row],[Start Date]],PlannedInterruptions[[#This Row],[End Date]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),IF(OR(IterationStart>PlannedInterruptions[[#This Row],[End Date]],PlannedInterruptions[[#This Row],[Start Date]]>IterationEnd,PlannedInterruptions[[#This Row],[Start Date]]>PlannedInterruptions[[#This Row],[End Date]],TODAY()>MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]])), 0, NETWORKDAYS(MAX(IterationStart,PlannedInterruptions[[#This Row],[Start Date]],TODAY()),MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]]),Holidays[Date])),\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),NETWORKDAYS(PlannedInterruptions[[#This Row],[Start Date]],PlannedInterruptions[[#This Row],[End Date]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),IF(OR(IterationStart>PlannedInterruptions[[#This Row],[End Date]],PlannedInterruptions[[#This Row],[Start Date]]>IterationEnd,PlannedInterruptions[[#This Row],[Start Date]]>PlannedInterruptions[[#This Row],[End Date]],TODAY()>MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]])), 0, NETWORKDAYS(MAX(IterationStart,PlannedInterruptions[[#This Row],[Start Date]],TODAY()),MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]]),Holidays[Date])),\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),NETWORKDAYS(PlannedInterruptions[[#This Row],[Start Date]],PlannedInterruptions[[#This Row],[End Date]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),IF(OR(IterationStart>PlannedInterruptions[[#This Row],[End Date]],PlannedInterruptions[[#This Row],[Start Date]]>IterationEnd,PlannedInterruptions[[#This Row],[Start Date]]>PlannedInterruptions[[#This Row],[End Date]],TODAY()>MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]])), 0, NETWORKDAYS(MAX(IterationStart,PlannedInterruptions[[#This Row],[Start Date]],TODAY()),MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]]),Holidays[Date])),\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),NETWORKDAYS(PlannedInterruptions[[#This Row],[Start Date]],PlannedInterruptions[[#This Row],[End Date]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(PlannedInterruptions[[#This Row],[Start Date]]),ISNUMBER(PlannedInterruptions[[#This Row],[End Date]]), PlannedInterruptions[[#This Row],[Start Date]]<=PlannedInterruptions[[#This Row],[End Date]]),IF(OR(IterationStart>PlannedInterruptions[[#This Row],[End Date]],PlannedInterruptions[[#This Row],[Start Date]]>IterationEnd,PlannedInterruptions[[#This Row],[Start Date]]>PlannedInterruptions[[#This Row],[End Date]],TODAY()>MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]])), 0, NETWORKDAYS(MAX(IterationStart,PlannedInterruptions[[#This Row],[Start Date]],TODAY()),MIN(IterationEnd,PlannedInterruptions[[#This Row],[End Date]]),Holidays[Date])),\"\")","v":""}]
[]
[null,"Holidays"]
[null,"Description","Date"]
{"$rows_empty":7}
[null,"The Iteration Backlog query was not bound to this workbook.  Use the Team tab and create a new list."]

{"sheet":"HiddenCapacityData","index":3,"n_rows":3,"n_cols":9,"rows_kept":3,"hidden":true}
["From Iteration Backlog Query results:",{"$nulls":6},"From Cube:"]
["Users","Iterations","Areas",null,"Formulas",null,null,"Iterations","Areas"]
[null,"\\Iteation 1","\\",null,"Capacity Updated",0,null,"\\","\\"]

{"sheet":"Capacity","index":4,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[1,0,1,8],[2,0,2,8],[34,1,37,7],[34,8,37,8]]}
["Capacity"]
["Use this worksheet to balance the load between the members of your team."]
["  Step 1:  Add each team member and the expected hours that team member will work on this project per day.  The Team Capacity chart updates to reflect your team's capacity versus versus work assigned for this iteration. \n  Step 2:  Switch to the Iteration Backlog worksheet to add new tasks to this iteration, returning to this sheet to see how the load is being distributed.\n  Step 3:  Reassign tasks to balance the workload as necessary to ensure that no team member has more work assigned than that team member’s available capacity."]
[null,{"$f":"IF(1, IF(ISERR(MacrosEnabled()), LocalizableStrings!A13, \"\"), TODAY())","v":""}]
[]
[null,"Team Capacity"]
[null,"Totals","Hours"]
[null,"Remaining Work"]
[null,"Remaining Capacity",{"$f":"SUM(IndividualCapacity[Capacity])","v":0}]
[null,"Utilized",{"$f":"IF(AND(ISNUMBER(TeamRemainingWork),ISNUMBER(TeamRemainingCapacity)),IF(TeamRemainingWork>=TeamRemainingCapacity, TeamRemainingCapacity,TeamRemainingWork),\"\")","v":""}]
[null,"Over",{"$f":"IF(AND(ISNUMBER(TeamRemainingWork),ISNUMBER(TeamRemainingCapacity)),IF(TeamRemainingWork>=TeamRemainingCapacity,TeamRemainingWork-TeamRemainingCapacity,0),\"\")","v":""}]
[null,"Under",{"$f":"IF(AND(ISNUMBER(TeamRemainingWork),ISNUMBER(TeamRemainingCapacity)),IF(TeamRemainingCapacity>=TeamRemainingWork,TeamRemainingCapacity-TeamRemainingWork,0),\"\")","v":""}]
{"$rows_empty":14}
[null,"Individual Capacity",{"$f":"IF(AND(ISNUMBER(IterationStart), ISNUMBER(IterationEnd)), \"\", LocalizableStrings!A11)","v":"The Iteration dates are not set.  Switch back to the Settings tab and update the Start and End date for this Iteration."}]
[null,"Team Member","Hours/Day","Days","Capacity","Assigned","Utilized","Over","Under"]
[{"$nulls":3},{"$f":"IF(ISBLANK(IndividualCapacity[[#This Row],[Team Member]]), \"\", IF(TODAY()<=IterationStart,IterationDays,IF(TODAY()<=IterationEnd, NETWORKDAYS(TODAY(),IterationEnd, Holidays[Date]),0))-SUMIF(PlannedInterruptions[Team Member], IndividualCapacity[[#This Row],[Team Member]], PlannedInterruptions[Remaining Days]))","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Hours/Day]]), ISNUMBER(IndividualCapacity[[#This Row],[Days]])), IndividualCapacity[[#This Row],[Hours/Day]]*IndividualCapacity[[#This Row],[Days]], \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Capacity]]),ISNUMBER(IndividualCapacity[[#This Row],[Assigned]])),MIN(IndividualCapacity[[#This Row],[Capacity]],IndividualCapacity[[#This Row],[Assigned]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]>=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Assigned]]-IndividualCapacity[[#This Row],[Capacity]], 0),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]<=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Capacity]]-IndividualCapacity[[#This Row],[Assigned]], 0),\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(ISBLANK(IndividualCapacity[[#This Row],[Team Member]]), \"\", IF(TODAY()<=IterationStart,IterationDays,IF(TODAY()<=IterationEnd, NETWORKDAYS(TODAY(),IterationEnd, Holidays[Date]),0))-SUMIF(PlannedInterruptions[Team Member], IndividualCapacity[[#This Row],[Team Member]], PlannedInterruptions[Remaining Days]))","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Hours/Day]]), ISNUMBER(IndividualCapacity[[#This Row],[Days]])), IndividualCapacity[[#This Row],[Hours/Day]]*IndividualCapacity[[#This Row],[Days]], \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Capacity]]),ISNUMBER(IndividualCapacity[[#This Row],[Assigned]])),MIN(IndividualCapacity[[#This Row],[Capacity]],IndividualCapacity[[#This Row],[Assigned]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]>=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Assigned]]-IndividualCapacity[[#This Row],[Capacity]], 0),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]<=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Capacity]]-IndividualCapacity[[#This Row],[Assigned]], 0),\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(ISBLANK(IndividualCapacity[[#This Row],[Team Member]]), \"\", IF(TODAY()<=IterationStart,IterationDays,IF(TODAY()<=IterationEnd, NETWORKDAYS(TODAY(),IterationEnd, Holidays[Date]),0))-SUMIF(PlannedInterruptions[Team Member], IndividualCapacity[[#This Row],[Team Member]], PlannedInterruptions[Remaining Days]))","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Hours/Day]]), ISNUMBER(IndividualCapacity[[#This Row],[Days]])), IndividualCapacity[[#This Row],[Hours/Day]]*IndividualCapacity[[#This Row],[Days]], \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Capacity]]),ISNUMBER(IndividualCapacity[[#This Row],[Assigned]])),MIN(IndividualCapacity[[#This Row],[Capacity]],IndividualCapacity[[#This Row],[Assigned]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]>=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Assigned]]-IndividualCapacity[[#This Row],[Capacity]], 0),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]<=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Capacity]]-IndividualCapacity[[#This Row],[Assigned]], 0),\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(ISBLANK(IndividualCapacity[[#This Row],[Team Member]]), \"\", IF(TODAY()<=IterationStart,IterationDays,IF(TODAY()<=IterationEnd, NETWORKDAYS(TODAY(),IterationEnd, Holidays[Date]),0))-SUMIF(PlannedInterruptions[Team Member], IndividualCapacity[[#This Row],[Team Member]], PlannedInterruptions[Remaining Days]))","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Hours/Day]]), ISNUMBER(IndividualCapacity[[#This Row],[Days]])), IndividualCapacity[[#This Row],[Hours/Day]]*IndividualCapacity[[#This Row],[Days]], \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Capacity]]),ISNUMBER(IndividualCapacity[[#This Row],[Assigned]])),MIN(IndividualCapacity[[#This Row],[Capacity]],IndividualCapacity[[#This Row],[Assigned]]),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]>=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Assigned]]-IndividualCapacity[[#This Row],[Capacity]], 0),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(IndividualCapacity[[#This Row],[Assigned]]),ISNUMBER(IndividualCapacity[[#This Row],[Capacity]])),IF(IndividualCapacity[[#This Row],[Assigned]]<=IndividualCapacity[[#This Row],[Capacity]], IndividualCapacity[[#This Row],[Capacity]]-IndividualCapacity[[#This Row],[Assigned]], 0),\"\")","v":""}]

{"sheet":"Burndown","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[1,0,1,9],[2,0,2,9],[38,1,41,7]]}
["Burndown"]
["Use this worksheet to track your progress during the iteration."]
["  Step 1:  Enter the date that you will start the iteration in the Trend Start Date cell.\n  Step 2:  Click the Update Now link or check the Automatic Chart Update option to have the chart updated whenever you make changes in the other worksheets.\n\nNote: When you modify the Iteration Backlog query, you might want to update the filters that control the Burndown chart. To modify these filters, right-click any worksheet tab, click Unhide, and then click BurndownData. On the BurndownData worksheet, you can add or modify the filters in the pivot table. "]
[null,{"$f":"IF(1, IF(ISERR(MacrosEnabled()), LocalizableStrings!A13, \"\"), TODAY())","v":""}]
[]
[null,"Burndown Settings"]
[null,"Trend Start Date"]

{"sheet":"BurndownData","index":6,"n_rows":38356,"n_cols":7,"rows_kept":38356,"hidden":true}
["Previous Start:",null,null,"Team Project Hierarchy","Unknown"]
["Previous End:",null,null,"Work Item.Area Hierarchy","All"]
["Previous Today:",null,null,"Work Item.Iteration Hierarchy","All"]
[{"$nulls":3},"Work Item.Work Item Type","Task"]
["Iteration Days:",{"$f":"IterationEnd - IterationStart + 1","v":1},null,"Work Item.State","All"]
["Trend Offset:",{"$f":"IF(ISNUMBER(Burndown!TrendStartDate), Burndown!TrendStartDate - CubeStartDate, 0)","v":0}]
["Trend Remaining:",{"$f":"OFFSET(FirstRemainingHours, TrendOffset, 0)","v":{"v":0,"d":"0.0"}},null,null,"Values"]
["Average Velocity:",{"$f":"TrendRemainingStart/(MAX(BurndownNumDays-TrendOffset - 1, 1))","v":{"v":0,"d":"0.00"}},null,"Date","Date Value","Remaining Work","Completed Work"]
[{"$nulls":3},"8/1/2009","2009-08-01"]
["Trend Line",null,null,"8/2/2009","2009-08-02"]
[{"$f":"TrendRemainingStart","v":{"v":0,"d":"0.00"}},null,null,"8/3/2009","2009-08-03"]
[{"$f":"A11-AverageVelocity","v":{"v":0,"d":"0.00"}},null,null,"8/4/2009","2009-08-04"]
[{"v":0,"d":"0.00"},null,null,"8/5/2009","2009-08-05"]
[{"v":0,"d":"0.00"},null,null,"8/6/2009","2009-08-06"]
[{"v":0,"d":"0.00"},null,null,"8/7/2009","2009-08-07"]
[{"v":0,"d":"0.00"},null,null,"8/8/2009","2009-08-08"]
[{"v":0,"d":"0.00"},null,null,"8/9/2009","2009-08-09"]
[{"v":0,"d":"0.00"},null,null,"8/10/2009","2009-08-10"]
[{"v":0,"d":"0.00"},null,null,"8/11/2009","2009-08-11"]
[{"v":0,"d":"0.00"},null,null,"8/12/2009","2009-08-12"]
[{"v":0,"d":"0.00"},null,null,"8/13/2009","2009-08-13"]
[{"v":0,"d":"0.00"},null,null,"8/14/2009","2009-08-14"]
[{"v":0,"d":"0.00"},null,null,"8/15/2009","2009-08-15"]
[{"v":0,"d":"0.00"},null,null,"8/16/2009","2009-08-16"]
[{"v":0,"d":"0.00"},null,null,"8/17/2009","2009-08-17"]
[{"v":0,"d":"0.00"},null,null,"8/18/2009","2009-08-18"]
[{"v":0,"d":"0.00"},null,null,"8/19/2009","2009-08-19"]
[{"v":0,"d":"0.00"},null,null,"8/20/2009","2009-08-20"]
[{"v":0,"d":"0.00"},null,null,"8/21/2009","2009-08-21"]
[{"v":0,"d":"0.00"},null,null,"8/22/2009","2009-08-22"]
[{"v":0,"d":"0.00"},null,null,"8/23/2009","2009-08-23"]
[{"v":0,"d":"0.00"},null,null,"8/24/2009","2009-08-24"]
[{"v":0,"d":"0.00"},null,null,"8/25/2009","2009-08-25"]
[{"v":0,"d":"0.00"},null,null,"8/26/2009","2009-08-26"]
[{"v":0,"d":"0.00"},null,null,"8/27/2009","2009-08-27"]
[{"v":0,"d":"0.00"},null,null,"8/28/2009","2009-08-28"]
[{"v":0,"d":"0.00"},null,null,"8/29/2009","2009-08-29"]
[{"v":0,"d":"0.00"},null,null,"8/30/2009","2009-08-30"]
[{"v":0,"d":"0.00"},null,null,"8/31/2009","2009-08-31"]
[{"v":0,"d":"0.00"},null,null,"9/1/2009","2009-09-01"]
[{"v":0,"d":"0.00"}]
[{"v":0,"d":"0.00"}]
{"$rows_empty":38313}
[{"$f":"TrendRemainingStart","v":{"v":0,"d":"0.00"}}]

{"sheet":"LocalizableStrings","index":7,"n_rows":22,"n_cols":4,"rows_kept":22,"hidden":true}
["Messages","Fields","Pivot Table Filters/Measures","Other"]
["Connecting to cube on Analysis Server '{0}'…","Area Path","Team Project Hierarchy","Active"]
["Retrieving areas and iterations from cube...","Assigned To","Work Item.Area Hierarchy"]
["Retrieving previous iterations Completed Hours…","Completed Work","Work Item.Iteration Hierarchy"]
["Could not connect to the server '{0}'. Ensure SQL Server Analysis Services is running.","Iteration","Date"]
["The Iteration Backlog query was not bound to this workbook.  Use the Team tab and create a new list.","Iteration Path","Remaining Work"]
["One or more required fields are not present in the Iteration Backlog query results: {0}. ","Original Estimate","Completed Work"]
["One or more document properties are not present: {0}. ","Priority"]
["Show Guidance","Remaining Work"]
["Hide Guidance","State"]
["The Iteration dates are not set.  Switch back to the Settings tab and update the Start and End date for this Iteration.","Sum of Original Estimate"]
["The Iteration Start Date should be before the End Date.","Team Member"]
["This workbook will not behave correctly with macros disabled.  Review the Security Warning in the Message Bar above.","Team Project"]
["Updating Burndown chart…","Total Estimated Work"]
["The Iteration dates are not valid. Switch back to the Settings tab and enter valid dates.","Title 1"]
["This is not a valid date.","Work Item Type"]
["This could be because Reporting Sevices is not installed for this TFS instance.","Total Remaining Work"]
["One or more required fields filters are not present in the BurndownData pivot table: {0}. ","Task"]
["One or more required values are not present in the BurndownData pivot table: {0}. "]
["One or more of the dates is not valid in the Holidays table on the Iterruptions tab."]
["The iteration path '{0}' is not in the cube. Try again after you have a work item with this iteration path and the cube has been processed."]
["The area path '{0}' is not in the cube. Try again after you have a work item with this area path and the cube has been processed."]