{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Scores","20_Tables","25_Tables","30_Tables","40_Tables"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":87,"n_cols":7,"rows_kept":87,"cut":false,"hidden":false,"merged":[[86,2,86,18],[64,2,64,19],[70,2,70,19],[75,6,75,10],[82,2,82,18],[83,2,83,18],[49,2,49,19],[52,2,52,19],[58,2,58,19],[0,0,1,19],[3,2,3,19],[39,2,39,24],[5,2,5,24]]}
["How to use this Scoreboard."]
[]
[]
[null,null,"We assume that the score keeper is using a laptop and a large screen to display to the room. Be sure to extend the two screens, do not duplicate."]
[]
[1,null,"The first thing you want to do after opening the Trivia_Night_Scoreboard.xlsm file is to save a copy under a different name."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,null,"Click on View and New Window to open a second copy of this spreadsheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,null,"Move the New Window onto the large screen. Be sure that screens are extended and not duplicated."]
[]
[]
[4,null,"Maximize the new window on the large screen."]
[]
[]
[]
[]
[]
[5,null,"On the new window, select the tab that will show all of your tables."]
[]
[]
[]
[]
[]
[6,null,"On the laptop screen, select the Scores tab."]
[]
[]
[]
[]
[]
[7,null,"Click on the Start button, then answer the question, Is there a Table 13? "]
[]
[]
[]
[]
[null,null,null,null,null,null,"If you answer No, then the score box for Table 13 will be blacked out."]
[]
[]
[]
[]
[]
[]
[8,null,"After entering the scores for each round, click on the Post button for that round. This will update the scores on the Tables tabs."]
[null,null,"Note: During subsequent rounds you may notice a strike thru of the scores. This will go away once you click Post."]
[]
[]
[9,null,"That's it."]

{"sheet":"Scores","index":1,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,7,43,8]]}
[null,null,null,null,null,null,null,null,null,null,null,0]
["Table #","Round 1","Round 2","Round 3","Round 4","Round 5","Round 6","Round 7","Round 8","Round 9","Round 10","Total","Prediction"]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:K3)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B27:K27)","v":0}]
[26,null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"First Place",null,"Second Place",null,"Third Place",null,"Last Place"]

{"sheet":"20_Tables","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,4,7,6],[7,7,7,9]]}
["Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score"]
[1,{"$f":"VLOOKUP(1,Scores!A3:L42,12,FALSE)","v":0},null,6,{"$f":"VLOOKUP(6,Scores!A3:L42,12,FALSE)","v":0},null,11,{"$f":"VLOOKUP(11,Scores!A3:L42,12,FALSE)","v":0},null,16,{"$f":"VLOOKUP(16,Scores!A3:L42,12,FALSE)","v":0}]
[2,{"$f":"VLOOKUP(2,Scores!A3:L42,12,FALSE)","v":0},null,7,{"$f":"VLOOKUP(7,Scores!A3:L42,12,FALSE)","v":0},null,12,{"$f":"VLOOKUP(12,Scores!A3:L42,12,FALSE)","v":0},null,17,{"$f":"VLOOKUP(17,Scores!A3:L42,12,FALSE)","v":0}]
[3,{"$f":"VLOOKUP(3,Scores!A3:L42,12,FALSE)","v":0},null,8,{"$f":"VLOOKUP(8,Scores!A3:L42,12,FALSE)","v":0},null,13,{"$f":"VLOOKUP(13,Scores!A3:L42,12,FALSE)","v":0},null,18,{"$f":"VLOOKUP(18,Scores!A3:L42,12,FALSE)","v":0}]
[4,{"$f":"VLOOKUP(4,Scores!A3:L42,12,FALSE)","v":0},null,9,{"$f":"VLOOKUP(9,Scores!A3:L42,12,FALSE)","v":0},null,14,{"$f":"VLOOKUP(14,Scores!A3:L42,12,FALSE)","v":0},null,19,{"$f":"VLOOKUP(19,Scores!A3:L42,12,FALSE)","v":0}]
[5,{"$f":"VLOOKUP(5,Scores!A3:L42,12,FALSE)","v":0},null,10,{"$f":"VLOOKUP(10,Scores!A3:L42,12,FALSE)","v":0},null,15,{"$f":"VLOOKUP(15,Scores!A3:L42,12,FALSE)","v":0},null,20,{"$f":"VLOOKUP(20,Scores!A3:L42,12,FALSE)","v":0}]
[]
[null,"First Place",null,null,"Second Place",null,null,"Third Place",null,null,{"$f":"_xlfn.CONCAT(\"Totals as of Round \"&Scores!$L$1)","v":"Totals as of Round 0"}]

{"sheet":"25_Tables","index":3,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,4,7,6],[7,7,7,9],[7,11,7,13]]}
["Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score"]
[1,{"$f":"VLOOKUP(1,Scores!A3:L42,12,FALSE)","v":0},null,6,{"$f":"VLOOKUP(6,Scores!A3:L42,12,FALSE)","v":0},null,11,{"$f":"VLOOKUP(11,Scores!A3:L42,12,FALSE)","v":0},null,16,{"$f":"VLOOKUP(16,Scores!A3:L42,12,FALSE)","v":0},null,21,{"$f":"VLOOKUP(21,Scores!A3:L42,12,FALSE)","v":0}]
[2,{"$f":"VLOOKUP(2,Scores!A3:L42,12,FALSE)","v":0},null,7,{"$f":"VLOOKUP(7,Scores!A3:L42,12,FALSE)","v":0},null,12,{"$f":"VLOOKUP(12,Scores!A3:L42,12,FALSE)","v":0},null,17,{"$f":"VLOOKUP(17,Scores!A3:L42,12,FALSE)","v":0},null,22,{"$f":"VLOOKUP(22,Scores!A3:L42,12,FALSE)","v":0}]
[3,{"$f":"VLOOKUP(3,Scores!A3:L42,12,FALSE)","v":0},null,8,{"$f":"VLOOKUP(8,Scores!A3:L42,12,FALSE)","v":0},null,13,{"$f":"VLOOKUP(13,Scores!A3:L42,12,FALSE)","v":0},null,18,{"$f":"VLOOKUP(18,Scores!A3:L42,12,FALSE)","v":0},null,23,{"$f":"VLOOKUP(23,Scores!A3:L42,12,FALSE)","v":0}]
[4,{"$f":"VLOOKUP(4,Scores!A3:L42,12,FALSE)","v":0},null,9,{"$f":"VLOOKUP(9,Scores!A3:L42,12,FALSE)","v":0},null,14,{"$f":"VLOOKUP(14,Scores!A3:L42,12,FALSE)","v":0},null,19,{"$f":"VLOOKUP(19,Scores!A3:L42,12,FALSE)","v":0},null,24,{"$f":"VLOOKUP(24,Scores!A3:L42,12,FALSE)","v":0}]
[5,{"$f":"VLOOKUP(5,Scores!A3:L42,12,FALSE)","v":0},null,10,{"$f":"VLOOKUP(10,Scores!A3:L42,12,FALSE)","v":0},null,15,{"$f":"VLOOKUP(15,Scores!A3:L42,12,FALSE)","v":0},null,20,{"$f":"VLOOKUP(20,Scores!A3:L42,12,FALSE)","v":0},null,25,{"$f":"VLOOKUP(25,Scores!A3:L42,12,FALSE)","v":0}]
[]
[null,"First Place",null,null,"Second Place",null,null,"Third Place",null,null,null,{"$f":"_xlfn.CONCAT(\"Totals as of Round \"&Scores!$L$1)","v":"Totals as of Round 0"}]

{"sheet":"30_Tables","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,3],[8,4,8,6],[8,7,8,9],[8,11,8,13]]}
["Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score"]
[1,{"$f":"VLOOKUP(1,Scores!A3:L42,12,FALSE)","v":0},null,7,{"$f":"VLOOKUP(7,Scores!A3:L42,12,FALSE)","v":0},null,13,{"$f":"VLOOKUP(13,Scores!A3:L42,12,FALSE)","v":0},null,19,{"$f":"VLOOKUP(19,Scores!A3:L42,12,FALSE)","v":0},null,25,{"$f":"VLOOKUP(25,Scores!A3:L42,12,FALSE)","v":0}]
[2,{"$f":"VLOOKUP(2,Scores!A3:L42,12,FALSE)","v":0},null,8,{"$f":"VLOOKUP(8,Scores!A3:L42,12,FALSE)","v":0},null,14,{"$f":"VLOOKUP(14,Scores!A3:L42,12,FALSE)","v":0},null,20,{"$f":"VLOOKUP(20,Scores!A3:L42,12,FALSE)","v":0},null,26,{"$f":"VLOOKUP(26,Scores!A3:L42,12,FALSE)","v":0}]
[3,{"$f":"VLOOKUP(3,Scores!A3:L42,12,FALSE)","v":0},null,9,{"$f":"VLOOKUP(9,Scores!A3:L42,12,FALSE)","v":0},null,15,{"$f":"VLOOKUP(15,Scores!A3:L42,12,FALSE)","v":0},null,21,{"$f":"VLOOKUP(21,Scores!A3:L42,12,FALSE)","v":0},null,27,{"$f":"VLOOKUP(27,Scores!A3:L42,12,FALSE)","v":0}]
[4,{"$f":"VLOOKUP(4,Scores!A3:L42,12,FALSE)","v":0},null,10,{"$f":"VLOOKUP(10,Scores!A3:L42,12,FALSE)","v":0},null,16,{"$f":"VLOOKUP(16,Scores!A3:L42,12,FALSE)","v":0},null,22,{"$f":"VLOOKUP(22,Scores!A3:L42,12,FALSE)","v":0},null,28,{"$f":"VLOOKUP(28,Scores!A3:L42,12,FALSE)","v":0}]
[5,{"$f":"VLOOKUP(5,Scores!A3:L42,12,FALSE)","v":0},null,11,{"$f":"VLOOKUP(11,Scores!A3:L42,12,FALSE)","v":0},null,17,{"$f":"VLOOKUP(17,Scores!A3:L42,12,FALSE)","v":0},null,23,{"$f":"VLOOKUP(23,Scores!A3:L42,12,FALSE)","v":0},null,29,{"$f":"VLOOKUP(29,Scores!A3:L42,12,FALSE)","v":0}]
[6,{"$f":"VLOOKUP(6,Scores!A3:L42,12,FALSE)","v":0},null,12,{"$f":"VLOOKUP(12,Scores!A3:L42,12,FALSE)","v":0},null,18,{"$f":"VLOOKUP(18,Scores!A3:L42,12,FALSE)","v":0},null,24,{"$f":"VLOOKUP(24,Scores!A3:L42,12,FALSE)","v":0},null,30,{"$f":"VLOOKUP(30,Scores!A3:L42,12,FALSE)","v":0}]
[]
[null,"First Place",null,null,"Second Place",null,null,"Third Place",null,null,null,{"$f":"_xlfn.CONCAT(\"Totals as of Round \"&Scores!$L$1)","v":"Totals as of Round 0"}]

{"sheet":"40_Tables","index":5,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,3],[10,4,10,6],[10,7,10,9],[10,11,10,13]]}
["Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score",null,"Table","Score"]
[1,{"$f":"VLOOKUP(1,Scores!A3:L42,12,FALSE)","v":0},null,9,{"$f":"VLOOKUP(9,Scores!A3:L42,12,FALSE)","v":0},null,17,{"$f":"VLOOKUP(17,Scores!A3:L42,12,FALSE)","v":0},null,25,{"$f":"VLOOKUP(25,Scores!A3:L42,12,FALSE)","v":0},null,33,{"$f":"VLOOKUP(33,Scores!A3:L42,12,FALSE)","v":0}]
[2,{"$f":"VLOOKUP(2,Scores!A3:L42,12,FALSE)","v":0},null,10,{"$f":"VLOOKUP(10,Scores!A3:L42,12,FALSE)","v":0},null,18,{"$f":"VLOOKUP(18,Scores!A3:L42,12,FALSE)","v":0},null,26,{"$f":"VLOOKUP(26,Scores!A3:L42,12,FALSE)","v":0},null,34,{"$f":"VLOOKUP(34,Scores!A3:L42,12,FALSE)","v":0}]
[3,{"$f":"VLOOKUP(3,Scores!A3:L42,12,FALSE)","v":0},null,11,{"$f":"VLOOKUP(11,Scores!A3:L42,12,FALSE)","v":0},null,19,{"$f":"VLOOKUP(19,Scores!A3:L42,12,FALSE)","v":0},null,27,{"$f":"VLOOKUP(27,Scores!A3:L42,12,FALSE)","v":0},null,35,{"$f":"VLOOKUP(35,Scores!A3:L42,12,FALSE)","v":0}]
[4,{"$f":"VLOOKUP(4,Scores!A3:L42,12,FALSE)","v":0},null,12,{"$f":"VLOOKUP(12,Scores!A3:L42,12,FALSE)","v":0},null,20,{"$f":"VLOOKUP(20,Scores!A3:L42,12,FALSE)","v":0},null,28,{"$f":"VLOOKUP(28,Scores!A3:L42,12,FALSE)","v":0},null,36,{"$f":"VLOOKUP(36,Scores!A3:L42,12,FALSE)","v":0}]
[5,{"$f":"VLOOKUP(5,Scores!A3:L42,12,FALSE)","v":0},null,13,{"$f":"VLOOKUP(13,Scores!A3:L42,12,FALSE)","v":0},null,21,{"$f":"VLOOKUP(21,Scores!A3:L42,12,FALSE)","v":0},null,29,{"$f":"VLOOKUP(29,Scores!A3:L42,12,FALSE)","v":0},null,37,{"$f":"VLOOKUP(37,Scores!A3:L42,12,FALSE)","v":0}]
[6,{"$f":"VLOOKUP(6,Scores!A3:L42,12,FALSE)","v":0},null,14,{"$f":"VLOOKUP(14,Scores!A3:L42,12,FALSE)","v":0},null,22,{"$f":"VLOOKUP(22,Scores!A3:L42,12,FALSE)","v":0},null,30,{"$f":"VLOOKUP(30,Scores!A3:L42,12,FALSE)","v":0},null,38,{"$f":"VLOOKUP(38,Scores!A3:L42,12,FALSE)","v":0}]
[7,{"$f":"VLOOKUP(7,Scores!A3:L42,12,FALSE)","v":0},null,15,{"$f":"VLOOKUP(15,Scores!A3:L42,12,FALSE)","v":0},null,23,{"$f":"VLOOKUP(23,Scores!A3:L42,12,FALSE)","v":0},null,31,{"$f":"VLOOKUP(31,Scores!A3:L42,12,FALSE)","v":0},null,39,{"$f":"VLOOKUP(39,Scores!A3:L42,12,FALSE)","v":0}]
[8,{"$f":"VLOOKUP(8,Scores!A3:L42,12,FALSE)","v":0},null,16,{"$f":"VLOOKUP(16,Scores!A3:L42,12,FALSE)","v":0},null,24,{"$f":"VLOOKUP(24,Scores!A3:L42,12,FALSE)","v":0},null,32,{"$f":"VLOOKUP(32,Scores!A3:L42,12,FALSE)","v":0},null,40,{"$f":"VLOOKUP(40,Scores!A3:L42,12,FALSE)","v":0}]
[]
[null,"First Place",null,null,"Second Place",null,null,"Third Place",null,null,null,{"$f":"_xlfn.CONCAT(\"Totals as of Round \"&Scores!$L$1)","v":"Totals as of Round 0"}]