{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Simulation","Shuffle Record"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Simulation","index":0,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Position","Stats",null,null,"replicate",30000]
[1,657,null,null,"offset",1]
[2,723,null,null,"repeat",7]
[3,693,null,null,"p",0.5,null,"The switch probability p shown on the Shuffle Record page is ",null,null,null,null,null,{"$f":"'Shuffle Record'!AI5","v":0.30457516339869284}]
[4,734,null,null,"Q",{"$f":"52*51*SUM(B:B)/(Reps*(52-Offset)^2)","v":1.219043137254902}]
[5,711]
[6,706]
[7,694]
[8,722]
[9,691]
[10,719]
[11,700]
[12,727]
[13,717]
[14,703]
[15,699]
[16,707]
[17,689]
[18,699]
[19,713]
[20,720]
[21,687]
[22,696]
[23,706]
[24,703]
[25,710]
[26,727]
[27,686]
[28,745]
[29,684]
[30,705]
[31,699]
[32,730]
[33,709]
[34,729]
[35,713]
[36,690]
[37,684]
[38,689]
[39,699]
[40,697]
[41,693]
[42,724]
[43,696]
[44,681]
[45,683]
[46,690]
[47,658]
[48,700]
[49,707]
[50,725]
[51,699]

{"sheet":"Shuffle Record","index":1,"n_rows":56,"n_cols":41,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[25,30,1,1,1,1,25,1,27,1,1,27,1,1,25,29,1,1,1,1,1,20,23,23,1,25,1,25,1,26,null,0.23790322580645162]
[26,31,2,2,2,2,26,28,1,2,21,1,30,2,1,1,2,2,2,2,2,21,24,1,2,26,23,1,26,1,null,0.23185483870967741,"average clot size>> ",null,{"$f":"52/AI4","v":3.1451612903225805}]
[1,32,29,3,3,3,1,29,2,3,2,2,31,3,2,2,3,3,3,29,3,22,1,2,3,27,2,2,2,2,null,0.20161290322580644,"average size last clot",null,4.6333333333333337]
[2,1,3,21,4,24,2,2,3,25,3,3,2,4,26,3,25,28,4,3,23,23,2,24,4,1,3,26,3,3,null,0.11693548387096774,"average clots",null,{"$f":"AVERAGE(Clots)","v":16.533333333333335}]
[3,2,4,22,5,25,3,3,4,26,22,28,3,5,3,4,26,4,5,4,24,1,25,3,26,2,24,27,4,27,null,8.4677419354838704E-2,"switch probability p",null,{"$f":"(AI4-1)/51","v":0.30457516339869284}]
[4,3,5,4,6,4,4,4,5,27,23,4,4,6,4,30,4,5,28,30,4,2,26,4,5,28,25,28,5,28,null,5.6451612903225805E-2]
[5,33,6,5,7,5,27,5,6,4,4,5,5,7,5,31,5,29,29,31,5,3,3,25,27,29,4,29,27,4,null,2.8225806451612902E-2]
[6,34,7,6,27,6,5,6,7,5,5,6,6,25,6,32,6,6,6,5,25,24,4,26,6,30,5,3,28,5,null,1.8145161290322582E-2]
[7,35,8,7,28,7,6,7,8,6,6,7,7,26,7,33,7,30,7,6,26,25,5,27,7,31,6,4,29,6,null,4.0322580645161289E-3]
[27,4,9,23,29,8,28,8,9,7,7,29,32,8,27,34,8,7,8,7,6,26,27,5,8,32,7,30,30,7,null,8.0645161290322578E-3]
[28,5,10,24,8,26,29,30,10,8,8,30,33,9,28,35,27,8,9,8,7,4,28,6,28,33,8,31,31,8,null,6.0483870967741934E-3]
[29,36,11,25,9,27,30,31,11,9,9,31,34,10,29,5,28,31,10,9,8,5,29,7,29,3,26,32,6,29,null,0,null,null,null,null,null,null,null,null,3]
[30,37,12,8,30,28,31,9,28,28,10,32,35,11,8,6,29,9,30,10,27,27,30,28,30,4,27,33,32,30,null,2.0161290322580645E-3]
[31,38,13,9,10,9,7,10,29,29,11,33,8,12,9,7,30,32,31,11,9,28,31,29,31,5,28,5,33,31,null,4.0322580645161289E-3]
[32,39,14,10,31,10,8,11,30,10,24,34,9,13,10,8,31,10,11,32,28,29,32,30,9,34,29,34,7,9,null,0]
[8,40,15,26,11,11,9,12,31,11,25,8,10,27,11,9,9,11,12,33,29,30,6,31,32,35,30,6,34,32,null,0]
[9,6,30,27,32,29,10,13,32,12,26,9,11,28,12,10,10,33,32,12,30,31,7,8,33,36,9,35,8,33,null,0]
[33,7,31,28,12,30,11,14,12,13,27,10,12,29,13,11,11,34,33,13,10,32,8,9,10,37,10,36,9,34,null,0]
[34,8,32,11,13,12,32,15,13,30,28,11,36,14,30,12,12,35,34,14,11,6,9,10,11,38,31,37,10,10,null,0]
[10,9,33,29,14,13,33,32,14,31,29,12,13,15,31,36,13,12,13,15,31,33,33,11,12,6,32,38,11,11,null,0]
[11,10,34,30,15,31,34,33,15,32,30,35,14,16,14,37,14,13,35,34,32,34,34,32,13,39,11,39,35,35,null,0]
[12,11,16,31,33,32,35,34,16,14,12,36,15,17,15,13,32,14,36,35,33,35,35,33,34,40,12,40,36,12,null,0]
[13,12,17,12,34,33,36,35,33,15,13,37,37,30,16,14,33,36,14,16,12,7,36,34,14,41,13,41,37,36,null,0]
[35,13,18,13,35,14,12,36,34,33,14,13,38,31,32,38,34,37,37,17,13,8,10,35,15,42,33,7,38,13,null,0]
[36,14,19,14,36,15,13,16,35,34,15,14,39,32,33,39,35,38,15,18,14,9,11,36,35,43,34,8,39,37,null,0]
[37,15,20,32,37,34,14,17,36,35,16,38,40,33,34,40,36,39,16,19,15,36,12,37,36,44,35,42,40,14,null,0]
[38,16,21,33,16,35,15,18,37,36,31,39,41,34,35,15,37,15,38,20,34,37,37,38,37,7,36,43,41,15,null,0]
[14,41,35,15,38,36,37,19,38,37,32,15,42,18,17,16,38,16,39,21,35,38,38,12,38,45,37,44,12,38,null,0]
[15,42,36,34,17,16,38,20,39,16,33,16,16,35,18,17,39,17,40,36,36,39,39,39,39,8,38,9,42,39,null,0]
[39,43,37,35,18,17,39,37,40,38,34,17,17,36,36,41,40,40,41,37,37,40,40,40,40,9,39,45,13,40,null,0]
[40,44,38,36,39,18,16,38,17,17,35,40,43,37,37,18,41,41,42,38,38,10,41,41,41,46,40,10,14,41,null,0]
[16,17,39,37,40,37,17,39,18,39,36,18,18,38,38,19,15,42,17,22,16,41,13,13,42,47,14,46,43,42,null,0]
[17,18,40,38,19,38,40,40,19,18,37,19,44,39,39,20,16,18,18,23,17,42,42,14,16,10,15,47,44,43,null,0]
[41,19,22,39,41,39,41,41,20,40,38,20,19,40,40,42,17,19,43,24,18,11,43,15,43,48,16,11,15,44,null,0]
[42,20,23,40,42,40,42,42,21,19,17,41,20,41,41,43,18,20,44,25,39,43,44,42,17,11,41,12,45,45,null,0]
[18,45,24,41,43,41,18,43,22,20,18,42,45,42,42,44,42,43,19,39,40,44,14,43,18,12,42,13,46,16,null,0]
[43,46,41,42,44,42,19,44,41,41,19,43,46,43,19,21,43,44,20,40,41,12,15,44,44,13,43,14,47,17,null,0]
[44,21,42,43,45,43,20,45,42,42,20,44,21,44,20,22,44,45,21,41,42,45,45,16,19,49,17,48,48,18,null,0]
[45,22,43,16,46,44,21,46,43,43,39,21,22,19,43,23,45,46,45,42,43,13,46,17,20,50,44,49,16,46,null,0]
[46,23,44,17,47,45,43,47,44,44,40,22,47,20,44,24,46,47,46,43,44,46,16,45,45,14,45,15,17,47,null,0]
[19,24,45,18,20,46,44,21,45,45,41,23,48,21,21,25,19,21,47,44,19,14,17,46,46,15,46,16,18,48,null,0]
[20,25,46,19,21,19,45,22,46,21,42,24,49,45,45,45,20,22,22,45,20,15,18,47,47,16,47,50,19,49,null,0]
[21,47,47,20,22,20,46,23,47,22,43,25,23,46,46,46,21,23,23,46,21,47,47,18,48,17,48,17,49,19,null,0]
[47,48,25,44,23,21,22,48,48,23,44,26,24,22,22,26,22,24,24,47,22,48,48,19,49,18,49,18,50,20,null,0]
[48,49,26,45,48,47,23,49,49,24,45,45,25,23,23,27,23,48,25,48,45,16,19,20,50,51,18,19,20,21,null,0]
[49,26,27,46,24,48,24,24,23,46,46,46,26,24,24,28,24,49,48,49,46,17,20,21,21,52,19,51,51,22,null,0]
[22,27,28,47,49,22,47,25,24,47,47,47,50,47,47,47,47,25,49,50,47,18,21,22,22,19,20,20,21,50,null,0]
[23,28,48,48,25,23,48,26,25,48,48,48,51,48,48,48,48,26,26,51,48,19,22,48,23,20,21,21,52,23,null,0]
[24,29,49,49,50,49,49,27,26,49,49,49,52,49,49,49,49,27,50,52,49,49,49,49,24,21,22,22,22,51,null,0]
[50,50,50,50,51,50,50,50,50,50,50,50,27,50,50,50,50,50,27,26,50,50,50,50,25,22,50,23,23,24,null,0]
[51,51,51,51,52,51,51,51,51,51,51,51,28,51,51,51,51,51,51,27,51,51,51,51,51,23,51,24,24,25,null,0]
[52,52,52,52,26,52,52,52,52,52,52,52,29,52,52,52,52,52,52,28,52,52,52,52,52,24,52,52,25,52,null,0]
[]
[35,28,23,17,8,8,6,4,4,3,3,2,2,2,3,4,4,2,2,2,2,2,2,2,3,3,2,3,2,2,"<<1-matches as the riffles are applied sequentially"]
[30,240,494,75,360,132,2346,48,200,1224,37,123,1365,145,46,918,1330,2436,126,480,148,96,1656,510,1288,210,48,230,3861,1560,"<<cycle length"]
[17,13,10,14,23,16,15,12,9,18,10,15,19,12,17,15,10,22,22,13,16,21,17,17,20,18,16,23,23,23,"<<clots"]