{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Status Quo","With Constraint","Statistics","Spreadsheet Usage"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Status Quo","index":0,"n_rows":155,"n_cols":16,"rows_kept":155,"cut":false,"hidden":false,"merged":[[0,15,2,15],[1,8,1,9],[0,8,0,9],[0,10,0,11],[1,10,1,11],[0,13,2,13],[0,14,2,14],[0,12,2,12],[0,6,0,7],[0,2,0,3],[1,2,1,3],[0,0,2,0],[1,4,1,5],[0,4,0,5],[1,6,1,7]]}
["Day",{"$f":"RANDBETWEEN(1,6)","v":5},{"$f":"RANDBETWEEN(1,6)","v":6},null,{"$f":"RANDBETWEEN(1,6)","v":5},null,{"$f":"RANDBETWEEN(1,6)","v":2},null,{"$f":"RANDBETWEEN(1,6)","v":1},null,{"$f":"RANDBETWEEN(1,6)","v":3},null,"Closed","Planned Average Throughput","Actual Throughput","Work in Progress"]
[null,"Gatekeeper","A",null,"B",null,"C",null,"D",null,"E"]
[null,"Rolled","WIP","Rolled","WIP","Rolled","WIP","Rolled","WIP","Rolled","WIP","Rolled"]
["Start",0,4,null,4,null,4,null,4,null,4,null,null,null,null,{"$f":"K4+I4+G4+E4+C4","v":20}]
[1,1,1,5,5,3,6,1,1,4,5,3,3,{"$f":"N4+3.25","v":3.25},{"$f":"IF(ISBLANK(A5),\"\",M5+O4)","v":3},{"$f":"IF(ISBLANK(A5),\"\",K5+I5+G5+E5+C5)","v":18}]
[2,6,1,6,1,6,9,2,2,5,4,2,2,{"$f":"IF(ISBLANK(A6),\"\",N5+$N$5)","v":6.5},5,{"$f":"IF(ISBLANK(A6),\"\",K6+I6+G6+E6+C6)","v":17}]
[3,2,2,3,1,2,8,2,2,4,4,2,2,{"$f":"IF(ISBLANK(A7),\"\",N6+$N$5)","v":9.75},7,17]
[4,3,4,1,1,2,5,4,4,5,2,6,4,13,11,16]
[5,3,3,6,4,6,5,1,4,1,1,4,2,16.25,13,17]
[6,4,4,6,3,5,5,4,4,4,4,5,1,19.5,14,20]
[7,3,3,5,4,3,3,6,5,4,5,3,3,22.75,17,20]
[8,6,7,2,2,4,4,5,5,3,6,2,2,26,19,24]
[9,2,8,1,2,1,4,1,2,4,8,2,2,29.25,21,24]
[10,3,6,5,5,6,2,5,4,5,6,4,4,32.5,25,23]
[11,5,9,2,5,2,2,6,2,6,4,6,6,35.75,31,22]
[12,4,11,2,2,6,5,4,2,4,5,1,1,39,32,25]
[13,5,15,1,1,3,3,4,4,5,2,5,5,42.25,37,25]
[14,1,12,4,4,6,1,5,4,3,3,4,2,45.5,39,24]
[15,6,13,5,5,6,4,2,1,6,4,3,3,48.75,42,27]
[16,6,18,1,4,2,5,1,1,5,1,6,4,52,46,29]
[17,4,16,6,6,4,4,5,5,2,1,4,1,55.25,47,32]
[18,4,17,3,7,2,2,4,4,6,5,5,1,58.5,48,35]
[19,3,18,2,7,2,2,2,2,6,8,1,1,61.75,49,37]
[20,2,17,3,6,4,5,1,2,1,8,1,1,65,50,38]
[null,{"$f":"IF(ISBLANK(A25),\"\",$B$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(D25>C24,0,(C24-D25))+IF(B25>A24,A24,B25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$C$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(F25>E24,0,(E24-F25))+IF(D25>C24,C24,D25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$E$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(H25>G24,0,(G24-H25))+IF(F25>E24,E24,F25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$G$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(J25>I24,0,(I24-J25))+IF(H25>G24,G24,H25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$I$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(L25>K24,0,(K24-L25))+IF(J25>I24,I24,J25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$K$1)","v":""},{"$f":"IF(ISBLANK(A25),\"\",MIN(K24,L25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",N24+ 3.5)","v":""},"",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,null,"Silo Averages",{"$f":"AVERAGE(D5:D24)","v":3.45},null,{"$f":"AVERAGE(F5:F24)","v":3.75},null,{"$f":"AVERAGE(H5:H24)","v":3.25},null,{"$f":"AVERAGE(J5:J24)","v":4.1500000000000004},null,{"$f":"AVERAGE(L5:L24)","v":3.45}]
[null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(M5:M22)","v":2.6666666666666665}]
[null,null,null,null,null,null,null,null,null,null,null,"Std Dev",{"$f":"STDEV(M5:M22)","v":1.4552137502179978}]
[null,null,null,null,null,null,null,null,null,null,null,"WIP Impact",null,null,null,{"$f":"(P24-P4)/P4","v":0.9}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 1",{"$f":"SUM(M5:M9)","v":13},{"$f":"3.25*5","v":16.25},{"$f":"(M35-N35)/N35","v":-0.2}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 2",{"$f":"SUM(M10:M14)","v":12},{"$f":"3.25*5","v":16.25},{"$f":"(M36-N36)/N36","v":-0.26153846153846155}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 3",{"$f":"SUM(M15:M19)","v":17},{"$f":"3.25*5","v":16.25},{"$f":"(M37-N37)/N37","v":4.6153846153846156E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 3",{"$f":"SUM(M20:M24)","v":8},{"$f":"3.25*5","v":16.25},{"$f":"(M38-N38)/N38","v":-0.50769230769230766}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M35:M38)","v":50},{"$f":"SUM(N35:N38)","v":65},{"$f":"(M39-N39)/N39","v":-0.23076923076923078}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Description of the system"]
[null,null,null,null,null,"Each team/process step can complete between 1 and 6 tasks every day"]
[null,null,null,null,null,"Random number generated indicates completed tasks for each day"]
[null,null,null,null,null,"In a 4 week period (without working weekends), 3.5 tasks should be completed on average"]
[null,null,null,null,null,"Goal is to completed between 65 and 70 tasks in 20 days"]
[null,null,null,null,null,"Work moves to the next step at the end of the day"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Improvement opportunities"]
[null,null,null,null,null,"Move dependency out a sprint"]
[null,null,null,null,null,"QE involved sizing and commitment"]
[null,null,null,null,null,"Break items down into small pieces"]
[null,null,null,null,null,"Stick your bottleneck in the front"]
[null,null,null,null,null,"feeding at a pace that downstream can handle"]
[null,null,null,null,null,"bring slack in the system"]
[null,null,null,null,null,"increase capacity"]
[null,null,null,null,null,"improve estimates"]

{"sheet":"With Constraint","index":1,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,12,2,12],[0,13,2,13],[0,14,2,14],[0,15,2,15],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[0,10,0,11],[0,0,2,0],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9]]}
["Day",{"$f":"RANDBETWEEN(1,6)","v":4},{"$f":"RANDBETWEEN(1,6)+RANDBETWEEN(1,6)","v":7},null,{"$f":"RANDBETWEEN(1,6)+RANDBETWEEN(1,6)","v":5},null,{"$f":"B1","v":4},null,{"$f":"RANDBETWEEN(1,6)+RANDBETWEEN(1,6)","v":7},null,{"$f":"RANDBETWEEN(1,6)+RANDBETWEEN(1,6)","v":4},null,"Closed","Planned Average Throughput","Actual Throughput","Work in Progress"]
[null,"Gatekeeper","A",null,"B",null,"C",null,"D",null,"E"]
[null,"Rolled","WIP","Rolled","WIP","Rolled","WIP","Rolled","WIP","Rolled","WIP","Rolled"]
["Start",0,4,null,4,null,12,null,4,null,4,null,null,null,null,{"$f":"K4+I4+G4+E4+C4","v":28}]
[1,1,1,10,4,9,15,1,1,9,4,9,4,{"$f":"N4+3.25","v":3.25},{"$f":"IF(ISBLANK(A5),\"\",M5+O4)","v":4},{"$f":"IF(ISBLANK(A5),\"\",K5+I5+G5+E5+C5)","v":25}]
[2,1,1,7,1,5,18,1,1,10,1,7,4,{"$f":"IF(ISBLANK(A6),\"\",N5+$N$5)","v":6.5},8,{"$f":"IF(ISBLANK(A6),\"\",K6+I6+G6+E6+C6)","v":22}]
[3,1,1,9,1,7,18,1,1,7,1,6,1,{"$f":"IF(ISBLANK(A7),\"\",N6+$N$5)","v":9.75},9,22]
[4,1,1,11,1,4,18,1,1,2,1,9,1,13,10,22]
[5,4,4,6,1,8,15,4,4,7,1,6,1,16.25,11,25]
[6,3,3,8,4,7,13,3,3,8,4,4,1,19.5,12,27]
[7,5,5,11,3,10,12,5,5,5,3,6,4,22.75,16,28]
[8,5,7,3,3,10,10,5,5,7,5,10,3,26,19,30]
[9,4,4,10,7,12,9,4,5,4,4,8,5,29.25,24,29]
[10,5,5,4,4,11,11,5,5,8,5,6,4,32.5,28,30]
[11,6,6,6,5,6,9,6,6,9,5,8,5,35.75,33,31]
[12,6,6,8,6,5,8,6,6,7,6,10,5,39,38,32]
[13,3,3,8,9,3,8,3,3,6,6,6,6,42.25,44,29]
[14,1,1,7,6,6,13,1,1,5,3,6,6,45.5,50,24]
[15,1,1,7,3,4,16,1,1,9,1,7,3,48.75,53,22]
[16,6,6,6,1,8,13,6,6,6,1,6,1,52,54,27]
[17,1,1,8,6,7,13,1,1,6,6,6,1,55.25,55,27]
[18,6,6,8,2,5,12,6,6,8,2,5,5,58.5,60,28]
[19,1,1,8,6,4,13,1,4,3,3,12,2,61.75,62,27]
[20,3,3,7,1,7,16,3,3,8,4,4,3,65,65,27]
[null,{"$f":"IF(ISBLANK(A25),\"\",$B$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(D25>C24,0,(C24-D25))+IF(B25>A24,A24,B25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$C$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(F25>E24,0,(E24-F25))+IF(D25>C24,C24,D25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$E$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(H25>G24,0,(G24-H25))+IF(F25>E24,E24,F25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$G$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(J25>I24,0,(I24-J25))+IF(H25>G24,G24,H25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$I$1)","v":""},{"$f":"IF(ISBLANK($A25),\"\",IF(L25>K24,0,(K24-L25))+IF(J25>I24,I24,J25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",$K$1)","v":""},{"$f":"IF(ISBLANK(A25),\"\",MIN(K24,L25))","v":""},{"$f":"IF(ISBLANK(A25),\"\",N24+ 3.5)","v":""},"",""]
[null,{"$f":"IF(ISBLANK(A26),\"\",$B$1)","v":""},{"$f":"IF(ISBLANK($A26),\"\",IF(D26>C25,0,(C25-D26))+IF(B26>A25,A25,B26))","v":""},{"$f":"IF(ISBLANK(A26),\"\",$C$1)","v":""},{"$f":"IF(ISBLANK($A26),\"\",IF(F26>E25,0,(E25-F26))+IF(D26>C25,C25,D26))","v":""},{"$f":"IF(ISBLANK(A26),\"\",$E$1)","v":""},{"$f":"IF(ISBLANK($A26),\"\",IF(H26>G25,0,(G25-H26))+IF(F26>E25,E25,F26))","v":""},{"$f":"IF(ISBLANK(A26),\"\",$G$1)","v":""},{"$f":"IF(ISBLANK($A26),\"\",IF(J26>I25,0,(I25-J26))+IF(H26>G25,G25,H26))","v":""},{"$f":"IF(ISBLANK(A26),\"\",$I$1)","v":""},{"$f":"IF(ISBLANK($A26),\"\",IF(L26>K25,0,(K25-L26))+IF(J26>I25,I25,J26))","v":""},{"$f":"IF(ISBLANK(A26),\"\",$K$1)","v":""},{"$f":"IF(ISBLANK(A26),\"\",MIN(K25,L26))","v":""},"","",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","",""]
[null,null,"Silo Average",{"$f":"AVERAGE(D5:D24)","v":7.6},null,{"$f":"AVERAGE(F5:F24)","v":6.9},null,{"$f":"AVERAGE(H5:H24)","v":3.2},null,{"$f":"AVERAGE(J5:J24)","v":6.7},null,{"$f":"AVERAGE(L5:L24)","v":7.05}]
[null,null,"Std Dev",{"$f":"_xlfn.STDEV.S(D5:D24)","v":2.0621909656836745},null,{"$f":"_xlfn.STDEV.S(F5:F24)","v":2.531901719220055},null,{"$f":"_xlfn.STDEV.S(H5:H24)","v":2.0672890969882065},null,{"$f":"_xlfn.STDEV.S(J5:J24)","v":2.1051315748352701},null,{"$f":"_xlfn.STDEV.S(L5:L24)","v":2.0894471693929506}]
[null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"AVERAGE(M5:M22)","v":3.3333333333333335}]
[null,null,null,null,null,null,null,null,null,null,null,"Std Dev",{"$f":"STDEV(M5:M22)","v":1.8786728732554485}]
[null,null,null,null,null,null,null,null,null,null,null,"WIP Impact",null,null,null,{"$f":"(P24-P4)/P4","v":-3.5714285714285712E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 1",{"$f":"SUM(M5:M9)","v":11},{"$f":"3.25*5","v":16.25},{"$f":"(M36-N36)/N36","v":-0.32307692307692309}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 2",{"$f":"SUM(M10:M14)","v":17},{"$f":"3.25*5","v":16.25},{"$f":"(M37-N37)/N37","v":4.6153846153846156E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 3",{"$f":"SUM(M15:M19)","v":25},{"$f":"3.25*5","v":16.25},{"$f":"(M38-N38)/N38","v":0.53846153846153844}]
[null,null,null,null,null,null,null,null,null,null,null,"Week 3",{"$f":"SUM(M20:M24)","v":12},{"$f":"3.25*5","v":16.25},{"$f":"(M39-N39)/N39","v":-0.26153846153846155}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M36:M39)","v":65},{"$f":"SUM(N36:N39)","v":65},{"$f":"(M40-N40)/N40","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Description of the system"]
[null,null,null,null,null,null,null,"Each team/process step can complete between 1 and 6 tasks every day"]
[null,null,null,null,null,null,null,"Random number generated indicates completed tasks for each day"]
[null,null,null,null,null,null,null,"In a 4 week period (without working weekends), 3.5 tasks should be completed on average"]
[null,null,null,null,null,null,null,"Goal is to completed between 65 and 70 tasks in 20 days"]
[null,null,null,null,null,null,null,"Work moves to the next step at the end of the day"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Improvement opportunities"]
[null,null,null,null,null,null,null,"Move dependency out a sprint"]
[null,null,null,null,null,null,null,"QE involved sizing and commitment"]
[null,null,null,null,null,null,null,"Break items down into small pieces"]
[null,null,null,null,null,null,null,"Stick your bottleneck in the front"]
[null,null,null,null,null,null,null,"feeding at a pace that downstream can handle"]
[null,null,null,null,null,null,null,"bring slack in the system"]
[null,null,null,null,null,null,null,"increase capacity"]
[null,null,null,null,null,null,null,"improve estimates"]

{"sheet":"Statistics","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Simulation #","Planned","Status Quo","With Constraint",null,null,"Status Quo","With Constraint"]
[1,65,59,69,null,"Average",{"$f":"AVERAGE(C2:C43)","v":52.928571428571431},{"$f":"AVERAGE(D2:D43)","v":63.428571428571431}]
[2,65,54,67,null,"Std Dev",{"$f":"_xlfn.STDEV.P(C2:C43)","v":3.9120866259206846},{"$f":"_xlfn.STDEV.P(D2:D43)","v":4.1926401339152646}]
[3,65,51,61,null,"Median",{"$f":"MEDIAN(C2:C43)","v":53},{"$f":"MEDIAN(D2:D43)","v":64}]
[4,65,51,65]
[5,65,49,64]
[6,65,50,62]
[7,65,46,63]
[8,65,47,62]
[9,65,49,65]
[10,65,58,59]
[11,65,47,57]
[12,65,58,64]
[13,65,57,64]
[14,65,58,64]
[15,65,57,61]
[16,65,52,57]
[17,65,53,58]
[18,65,47,67]
[19,65,56,69]
[20,65,56,66]
[21,65,54,67]
[22,65,45,59]
[23,65,57,67]
[24,65,55,69]
[25,65,56,57]
[26,65,51,63]
[27,65,55,58]
[28,65,55,67]
[29,65,49,60]
[30,65,55,69]
[31,65,59,61]
[32,65,57,57]
[33,65,52,65]
[34,65,53,61]
[35,65,50,62]
[36,65,53,57]
[37,65,49,68]
[38,65,47,67]
[39,65,57,60]
[40,65,53,66]
[41,65,56,75]
[42,65,50,65]

{"sheet":"Spreadsheet Usage","index":3,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["In order to start a new simulation, copy cells \"A25 to M25\" and paste into \"A5 to M24\""]
["Only key in the days in column A. All other cells from B to M will populate automatically"]
["Click on the \"Paste Value\" button to ensure that the current row values are static and prevent change when new random number is generated"]
["Do not enter anything in column A after A30. The macro is quite basic and will get messed up. "]
["Enable macros so that you can use the \"Paste Value\" button. The alternative is to copy and \"paste special-->values\" for every day you want to simulate. "]