{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Seating Plan"],"not_rendered":{"charts":0,"images":1,"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":"Seating Plan","index":0,"n_rows":17,"n_cols":29,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,3,9,3],[10,2,11,2],[12,1,13,1],[3,5,6,14],[1,11,1,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"TNBT Finalists' Tour - Seat Booking System"]
[]
[null,null,null,null,null,"Stage",null,null,null,null,null,null,null,null,null,null,null,null,null,"Seat discount codes",null,null,null,null,"Income from seat sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","Name","Discount","% of Adult price",null,null,"Adults","Students","Children","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Adult",0,{"$f":"100%-V6","v":1},null,"Premium",{"$f":"Y13*U13","v":195},45,7.5,{"$f":"SUM(AA6:AB6)","v":52.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","Student",0.25,{"$f":"100%-V7","v":0.75},null,"Standard",60,18,30,{"$f":"SUM(AA7:AB7)","v":48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Child",0.5,0.5,null,"Economy",40,54,20,74]
[null,null,null,"Premium",null,null,"A","A","S","S",null,"A","A","A","S","S",null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(AC6:AC8)","v":174.5}]
[null,null,null,null,null,"C","A","A","A",null,"A","A","A","A","A"]
[null,null,"Standard",null,"A","A",null,null,"S","S",null,null,null,null,null,null,null,null,null,"Seat prices",null,null,null,null,"Number of seats sold"]
[null,null,null,"C","C","C","A",null,null,null,"C","C","A","A",null,null,null,null,null,"Seat","Adult Price","Student price","Child price",null,"Adults","Students","Children","Total","Seats remaining"]
[null,"Economy",null,null,null,"C","S","C",null,null,null,"A","S",null,"S","S",null,null,null,"Premium",15,{"$f":"W7*U13","v":11.25},{"$f":"W8*U13","v":7.5},null,{"$f":"COUNTIF(E9:P10,\"A\")","v":13},{"$f":"COUNTIF(E9:P10,\"S\")","v":4},{"$f":"COUNTIF(E9:P10,\"C\")","v":1},{"$f":"SUM(Y13:AA13)","v":18},{"$f":"24-AB13","v":6}]
[null,null,null,"A","C","C","C",null,"S","S","S","S","S",null,"A","A","A",null,null,"Standard",12,{"$f":"W7*U14","v":9},{"$f":"W8*U14","v":6},null,{"$f":"COUNTIF(D11:Q12,\"A\")","v":5},{"$f":"COUNTIF(D11:Q12,\"S\")","v":2},{"$f":"COUNTIF(D11:Q12,\"C\")","v":5},{"$f":"SUM(Y14:AA14)","v":12},{"$f":"28-AB14","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Economy",8,{"$f":"W7*U15","v":6},{"$f":"W8*U15","v":4},null,{"$f":"COUNTIF(C13:R14,\"A\")","v":5},{"$f":"COUNTIF(C13:R14,\"S\")","v":9},{"$f":"COUNTIF(C13:R14,\"C\")","v":5},{"$f":"SUM(Y15:AA15)","v":19},{"$f":"32-AB15","v":13}]
[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,"TOTAL",{"$f":"SUM(AC13:AC15)","v":35}]
[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,{"$f":"IF(AC16=0,\"Full House\",\"\")","v":""}]