{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Into","Part I - WIP Control","Part II - Execution Control"],"not_rendered":{"charts":3,"images":8,"macros":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"Into","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
["TameFlow-Scrum"]
[" Edition J. Ross"]
[]
["    click on the diagram to calculate the probability",{"$nulls":4},"      click on the diagram to go to execution control"]
["    of success",{"$nulls":4},"      and drawing fever curves"]
{"$rows_empty":16}
["     This excel file is protected by the creative commons license (CC BY-SA 3.0)"]
[]
[null,null,"http://creativecommons.org/licenses/by-sa/3.0/"]
[]
[{"$nulls":10}," "]
["     Do you have the most actual version of the excel file?"]
[]
[null,null,"http://reliable-scrum.de/P1V31.html"]

{"sheet":"Part I - WIP Control","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"merged":[[3,0,3,7]]}
["TameFlow-Scrum"]
["Part I - WIP Control"]
[]
["The goal of Part I - WIP-Control is to make sure, that the probability to fulfill the expectations of the stakeholder is in a realistic range. There are two factors that define the probability of success a) the amount of story points in the backlog that has to be burned down and b) the mean velocity until the due-date. If you take both as probabilities you'll get a good estimate on the overall success-rate at a specific time. A calculated success rate of greater than 80% will lead, in practice, to a success of the project/release."]
[]
["expected Load - BACKLOG (regarding probability)","total"]
["optimistic Load (Story Points)",{"v":500,"d":"500 "},"baseline, the current known backlog items"]
["realistic Load (Story Points)",{"$f":"B7*(1+C8)","v":{"v":600,"d":"600 "}},{"v":0.2,"d":"20%"},"estimate on how many backlog items usually occur"]
["pessimistic Load (Story Points)",{"$f":"B7*(1+C9)","v":{"v":700,"d":"700 "}},{"v":0.4,"d":"40%"},"estimate on how many backlog items in worts case occur"]
[]
["expected VELOCITY (regarding probability)","mean"]
["pessimistic velocity (Story Points per Week)",{"$f":"ROUND(B13*(1+C12),0)","v":{"v":20,"d":"20 "}},{"v":-0.2,"d":"-20%"},"estimate on how much the velocity can drop in worst case"]
["realistic velocity (Story Points per Week)",{"v":25,"d":"25 "}]
["optimistic velocity (Story Points per Week)",{"$f":"ROUND(B13*(1+C14),0)","v":{"v":30,"d":"30 "}},{"v":0.2,"d":"20%"},"estimate on how much the velocity can increase in best case"]
[]
["start of burn down","2013-01-01","date when the burn down of the backlog really started"]
[]
["Results"]
["sucess probability based on wished Due-Date"]
["due date","2013-07-03"]
["absolute probability of success to deliver at due date",{"$f":"ReliableScrumProbabilityByDuration(B7,B8,B9,B14/7,B13/7,B12/7,(B20-B16))","v":{"v":0.7917735170039789,"d":"79%"}},"above 80% will typically lead to a successful project"]
[]
["Due-Date based on a given probability of success"]
["reasonable absolute probability",{"v":0.8,"d":"80%"}]
["reasonable due date ",{"$f":"B16+ReliableScrumDurationByProbability(B7,B8,B9,B14/7,B13/7,B12/7,B24)","v":"2013-07-03T15:57:30.050"}]
[]
[]
[]
[]
[]
[]
["Success-Curve"]
[]
[{"$nulls":5},"Due-Date","Probability"]
[{"$nulls":5},{"$f":"B$16+ReliableScrumDurationByProbability(B$7,B$8,B$9,B$14/7,B$13/7,B$12/7,G35)","v":"2013-04-27T16:00:00"},{"v":0,"d":"0%"}]
[{"$nulls":5},"2013-05-22T00:22:19.230",{"v":0.05,"d":"5%"}]
[{"$nulls":5},"2013-05-27T14:05:10.803",{"v":0.1,"d":"10%"}]
[{"$nulls":5},"2013-06-03T18:45:12.143",{"v":0.2,"d":"20%"}]
[{"$nulls":5},"2013-06-13T17:54:49.202",{"v":0.4,"d":"40%"}]
[{"$nulls":5},"2013-06-22T08:59:10.066",{"v":0.6,"d":"60%"}]
[{"$nulls":5},"2013-07-03T15:57:30.050",{"v":0.8,"d":"80%"}]
[{"$nulls":5},"2013-07-12T20:54:42.511",{"v":0.9,"d":"90%"}]
[{"$nulls":5},"2013-07-20T17:13:00.650",{"v":0.95,"d":"95%"}]
[{"$nulls":5},"2013-07-27T07:57:07.845",{"v":0.975,"d":"98%"}]
[{"$nulls":5},"2013-09-03",{"v":0.996,"d":"100%"}]

{"sheet":"Part II - Execution Control","index":2,"n_rows":46,"n_cols":11,"rows_kept":46}
["TameFlow-Scrum"]
["Part II - Execution Control"]
[]
["start of project/release",null,"2013-01-01",null,"it's also the start of the burn-down s. cell C11"]
["start of the buffer",null,{"$f":"C4+0.77*(C6-C4)","v":"2013-05-21T21:50:24"},{"$f":"(C6-C5)/(C6-C4)","v":{"v":0.22999999999998091,"d":"23%"}},"percentage of buffer to the whol duration of the release project"]
["commited due date",null,"2013-07-03"]
[]
["# sprint","date of status","elapsed time \n[week]","story point in backlog \n[story points]","calculated velocity \n[story points/week]","estimated/ set velocity \n[story points/week]","estimed date\nof finishing","progress over time","buffer consumption","remaining duration [days]","remaining duration [workdays]"]
["-",{"$f":"C4","v":"2013-01-01"},0,{"v":500,"d":"500 "},0,{"v":25,"d":"25 "},{"$f":"IF(F9=\"\",\"\",B9+D9/(F9/7))","v":"2013-05-21"},{"$f":"IF(G9=\"\",\"\",(B9-$C$4)/(G9-$C$4))","v":{"v":0,"d":"0%"}},{"$f":"IF((G9-$C$5)/($C$6-$C$5)>0,(G9-$C$5)/($C$6-$C$5),0)","v":{"v":0,"d":"0%"}},{"$f":"G9-B9","v":{"v":140,"d":"140 "}},{"$f":"NETWORKDAYS(B9,G9)","v":101}]
[1,{"$f":"B9+14","v":"2013-01-15"},{"$f":"(B10-B$9)/7","v":{"v":2,"d":"2 "}},{"$f":"D9-5","v":{"v":495,"d":"495 "}},0,{"v":25,"d":"25 "},{"$f":"IF(F10=\"\",\"\",B10+D10/(F10/7))","v":"2013-06-02T14:24:00"},{"$f":"IF(G10=\"\",\"\",(B10-$C$4)/(G10-$C$4))","v":{"v":0.09174311926605593,"d":"9%"}},{"$f":"IF((G10-$C$5)/($C$6-$C$5)>0,(G10-$C$5)/($C$6-$C$5),0)","v":{"v":0.27773818009018825,"d":"28%"}},{"$f":"G10-B10","v":{"v":138.59999999999854,"d":"139 "}},{"$f":"NETWORKDAYS(B10,G10)","v":99}]
[2,{"$f":"B10+14","v":"2013-01-29"},{"$f":"(B11-B$9)/7","v":{"v":4,"d":"4 "}},{"$f":"D10-20","v":{"v":475,"d":"475 "}},{"$f":"IF(D11=\"\",\"\",(-1)*LINEST(D$9:D11,C$9:C11))","v":{"v":6.249999999999998,"d":"6 "}},{"v":25,"d":"25 "},"2013-06-11",{"v":0.17391304347826086,"d":"17%"},{"v":0.4773105250652928,"d":"48%"},{"v":133,"d":"133 "},96]
[3,{"$f":"B11+14","v":"2013-02-12"},{"v":6,"d":"6 "},{"$f":"D11-40","v":{"v":435,"d":"435 "}},{"$f":"IF(D12=\"\",\"\",(-1)*LINEST(D$9:D12,C$9:C12))","v":{"v":10.749999999999996,"d":"11 "}},{"v":25,"d":"25 "},{"$f":"IF(F12=\"\",\"\",B12+D12/(F12/7))","v":"2013-06-13T19:12:00"},{"v":0.25641025641025184,"d":"26%"},{"$f":"IF((G12-$C$5)/($C$6-$C$5)>0,(G12-$C$5)/($C$6-$C$5),0)","v":{"v":0.543834640057052,"d":"54%"}},{"v":121.80000000000291,"d":"122 "},88]
[4,"2013-02-26",{"v":8,"d":"8 "},null,{"$f":"IF(D13=\"\",\"\",(-1)*LINEST(D$10:D13,C$10:C13))","v":""}]
[5,"2013-03-12",{"v":10,"d":"10 "},null,{"$f":"IF(D14=\"\",\"\",(-1)*LINEST(D$10:D14,C$10:C14))","v":""}]
[6,"2013-03-26",{"v":12,"d":"12 "}]
{"$rows_empty":28}
[{"$nulls":5},"Colour-Sheme","BC@0%LCC","BC@100%LCC"]
[{"$nulls":5},"green-yellow-line",{"v":0.3,"d":"30%"},{"v":0.8,"d":"80%"}]
[{"$nulls":5},"yellow-red-lne",{"v":0.5,"d":"50%"},{"v":0.9,"d":"90%"}]