{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Main"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Main","index":0,"n_rows":17,"n_cols":107,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,6,14,65],[15,6,15,65],[16,6,16,65]]}
[null,null,null,null,null,"P 1","P 2","P 3","P 4","P 5","P 6","P 7","P 8","P 9","P 10","P 11","P 12","P 13","P 14","P 15","P 16","P 17","P 18","P 19","P 20","P 21","P 22","P 23","P 24","P 25","P 26","P 27","P 28","P 29","P 30","P 31","P 32","P 33","P 34","P 35","P 36","P 37","P 38","P 39","P 40","P 41","P 42","P 43","P 44","P 45","P 46","P 47","P 48","P 49","P 50","P 51","P 52","P 53","P 54","P 55","P 56","P 57","P 58","P 59","P 60","P 61","P 62","P 63","P 64","P 65","P 66","P 67","P 68","P 69","P 70","P 71","P 72","P 73","P 74","P 75","P 76","P 77","P 78","P 79","P 80","P 81","P 82","P 83","P 84","P 85","P 86","P 87","P 88","P 89","P 90","P 91","P 92","P 93","P 94","P 95","P 96","P 97","P 98","P 99","P 100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[]
[null,null,null,null,null,"S 1","S 2","S 3","S 4","S 5","S 6","S 7","S 8","S 9","S 10","S 11","S 12","S 13","S 14","S 15","S 16","S 17","S 18","S 19","S 20","S 21","S 22","S 23","S 24","S 25","S 26","S 27","S 28","S 29","S 30","S 31","S 32","S 33","S 34","S 35","S 36","S 37","S 38","S 39","S 40","S 41","S 42","S 43","S 44","S 45","S 46","S 47","S 48","S 49","S 50","S 51","S 52","S 53","S 54","S 55","S 56","S 57","S 58","S 59","S 60","S 61","S 62","S 63","S 64","S 65","S 66","S 67","S 68","S 69","S 70","S 71","S 72","S 73","S 74","S 75","S 76","S 77","S 78","S 79","S 80","S 81","S 82","S 83","S 84","S 85","S 86","S 87","S 88","S 89","S 90","S 91","S 92","S 93","S 94","S 95","S 96","S 97","S 98","S 99","S 100"]
[null,null,"# of Trials:",100,null,1,2,3,4,5,6,7,8,9,10,null,12,13,14,43,33,78,18,19,20,21,22,23,24,25,26,27,28,29,30,11,32,15,34,35,36,37,38,39,40,41,42,89,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,16,79,80,81,82,83,84,92,86,87,88,31,90,91,17,93,94,95,96,97,98,99,100]
[null,null,"Trial Count:",100]
[]
[null,null,"If last passenger had their seat:"]
[null,null,"Yes",47]
[null,null,"No",53]
[null,null,"Calculated probability"]
[null,null,"Yes",{"$f":"D9/D6","v":0.47},null,0.49,0.53,0.52,0.5,0.48,0.43,0.46,0.46,0.57999999999999996,0.49,0.51,0.47,0.51,0.44,0.45,0.5,0.5,0.53,0.5,0.45,0.54,0.53,0.48,0.43,0.5,0.46,0.46,0.48,0.47,0.46,0.48,0.5,0.51,0.49,0.5,0.53,0.44,0.52,0.54,0.53,0.53,0.49,0.53,0.44,0.55000000000000004,0.55000000000000004,0.43,0.45,0.53,0.55000000000000004,0.44,0.54,0.43,0.45,0.39,0.49,0.55000000000000004,0.5,0.57999999999999996,0.6,0.53,0.49,0.55000000000000004,0.53,0.51,0.49,0.5,0.55000000000000004,0.5,0.48,0.48,0.49,0.55000000000000004,0.56000000000000005,0.5,0.44,0.45,0.43,0.5,0.48,0.53,0.44,0.55000000000000004,0.55000000000000004,0.46,0.42,0.52,0.55000000000000004,0.48,0.52,0.47,0.6,0.53,0.52,0.51,0.53,0.49,0.54,0.44,0.47,null,{"$f":"AVERAGE(F12:DA12)","v":0.498}]
[null,null,"No",{"$f":"D10/D6","v":0.53},null,0.51,0.47,0.48,0.5,0.52,0.56999999999999995,0.54,0.54,0.42,0.51,0.49,0.53,0.49,0.56000000000000005,0.55000000000000004,0.5,0.5,0.47,0.5,0.55000000000000004,0.46,0.47,0.52,0.56999999999999995,0.5,0.54,0.54,0.52,0.53,0.54,0.52,0.5,0.49,0.51,0.5,0.47,0.56000000000000005,0.48,0.46,0.47,0.47,0.51,0.47,0.56000000000000005,0.45,0.45,0.56999999999999995,0.55000000000000004,0.47,0.45,0.56000000000000005,0.46,0.56999999999999995,0.55000000000000004,0.61,0.51,0.45,0.5,0.42,0.4,0.47,0.51,0.45,0.47,0.49,0.51,0.5,0.45,0.5,0.52,0.52,0.51,0.45,0.44,0.5,0.56000000000000005,0.55000000000000004,0.56999999999999995,0.5,0.52,0.47,0.56000000000000005,0.45,0.45,0.54,0.57999999999999996,0.48,0.45,0.52,0.48,0.53,0.4,0.47,0.48,0.49,0.47,0.51,0.46,0.56000000000000005,0.53,null,{"$f":"AVERAGE(F13:DA13)","v":0.50200000000000011}]
[]
[null,null,null,null,null,null,"The Puzzle: The Lost Boarding Pass - from Peter Winkler\n\nOne hundred people line up to board an airplane, but the first passenger has lost their boarding pass and takes a random seat instead. Each subsequent passenger takes his or her assigned seat if it is available , otherwise a random unoccupied seat. \n\nWhat is the probability that the last passenger to board finds their seat occupied. "]
[null,null,null,null,null,null,"The model: \n\nEach passenger (P1, P2 etc) is allocated a random seat. The first passenger is placed in a random seat (ignoring his allocated seat). Each passenger thereafter is seated according to the rules of the puzzle. If the last passenger can sit in their allocated seat a 'Yes' is recorded, otherwise a 'No' is recorded. "]
[null,null,null,null,null,null,"Instructions: \n\nEnter the number of trials you wish to run in the '# of Trials' box and then press the 'Start' button in top left corner of the worksheet. The number of trials already run is recorded in the 'Trial Count' box. "]