{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["Main","Entries","Judges","Rooms","Pairings","Ballot","Confirmation","TeamAwards","SpeakerAwards","SweepStakes","ResultSheet","STATS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":122,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Middle School Public Debate Program  - Tab"]
["Tournament Name:"]
["Location:"]
["Dates:",""]
["Total Prelim Rounds:"]
[]
["Next Step…","0a. Print Confirmation Sheets"]
["2 Steps away…","0b. Confirm Data Entry"]
["3 Steps away…","1. Pair Round 1"]
[]
[]
[]
["Version: 5.04 © MSPDP/ESU (Release Date: 02/01/2017)"]

{"sheet":"Entries","index":1,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["School","School Code","Speaker1","Speaker2","Speaker3","Team Name","TeamCode","Team Active","CurrSide","Wins","Pts","Random","Assigned","Cohort"]
["ZZZ-BYE",0,"Z-Bye","ZZ-Bye","ZZZ-Bye","ZZZ-BYE",0,"N"]
["Hired/Unaffiliated",1,"H-Bye","HH-Bye","HHH-Bye","Hired",1,"N"]

{"sheet":"Judges","index":2,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Judge Name","School Code","Active","Judge Code","Round 1","Round 2","Round 3","Round 4","Round 5","Assg","O/Used","Random","Penalty Score","High Priority"]
["ZZZ-Judge",0,"N",0]

{"sheet":"Rooms","index":3,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Room Name","Active","Code"]

{"sheet":"Pairings","index":4,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Room","Proposition Team","Opposition Team","Judge Name","DebateCode","RoomCode","PropCode","OppCode","JudgeCode","WinnerCode","Prop1Speaker","Prop2Speaker","Prop3Speaker","Opp1Speaker","Opp2Speaker","Opp3Speaker"]

{"sheet":"Ballot","index":5,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":10},"Middle School Public Debate Program"]
[{"$nulls":10},"Ballot, test"]
["Judge:",null,"ZZZ-Judge (ZZZ-BYE)",{"$nulls":6},"Debate #:",44]
["Room:",null,"ZZZ",{"$nulls":6},"Ballot #:","8 of 8"]
["Round:",null,4]
[]
["***      Judges - Please rank debaters on a scale of 60-100 points and Circle the winning team     ***"]
[]
["Proposition Team",{"$nulls":5},"Opposition Team"]
[null,"ZZZ-BYE",{"$nulls":5},"sdaf wxu"]
[]
["1st",null,null,"Points:",null,null,"1st",null,null,"Points:"]
[]
["2nd",null,null,"Points:",null,null,"2nd",null,null,"Points:"]
[]
["3rd",null,null,"Points:",null,null,"3rd",null,null,"Points:"]
[]
[]
["IN MY OPINION, THE TEAM THAT WON THE DEBATE WAS THE (CIRCLE ONE)    PROP  /  OPP"]
[]
["Signature:",{"$nulls":5},"Affiliation:"]
["Please use the space below to indicate your reason for decision and to provide helpful comments to the debaters."]

{"sheet":"Confirmation","index":6,"n_rows":89,"n_cols":6,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","gchk"]
[]
["Teams"]
[null,"gchk fdg","f","df","gbvf"]
[null,"gchk fxc","fxg","xc","cvx"]
[]
["Judges"]
[null,"dfh"]
[null,"yuk"]
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","Hired/Unaffiliated"]
[]
["Teams"]
[null,"Hired","H-Bye","HH-Bye","HHH-Bye"]
[]
["Judges"]
[null,"No Judges Entered"]
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","sdaf"]
[]
["Teams"]
[null,"sdaf aaw","asdf","asd","w4"]
[null,"sdaf tgn","ty","gh","nm"]
[null,"sdaf wxu","wr","xcv","ui"]
[]
["Judges"]
[null,"adf"]
[null,"fdfa"]
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","sth"]
[]
["Teams"]
[null,"sth dad","d","acvx","dfh"]
[null,"sth dxx","dtjk","xgc","xcvn"]
[null,"sth fxx","fg","xfy","xdf"]
[]
["Judges"]
[null,"ftrhs"]
[null,"sdfh"]
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","vx"]
[]
["Teams"]
[null,"vx gax","gto","arg","xf"]
[null,"vx hxs","hyi","xcnxcv","sdg"]
[null,"vx rsz","rjys","sdfh","zxf"]
[]
["Judges"]
[null,"dfs"]
[null,"dfxcv"]
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","xf"]
[]
["Teams"]
[null,"xf dgh","d","gjc","h"]
[null,"xf sxv","sdfxf","xcv","v"]
[null,"xf xxd","xfy","xgy","drh"]
[null,"xf zxc","zd","xcgfn","cvx"]
[]
["Judges"]
[null,"fs"]
[null,"xc"]
[{"$nulls":5},"Middle School Public Debate Program"]
[{"$nulls":5},"test"]
[]
[]
["School Name:","ZZZ-BYE"]
[]
["Teams"]
[null,"ZZZ-BYE","Z-Bye","ZZ-Bye","ZZZ-Bye"]

{"sheet":"TeamAwards","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SpeakerAwards","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SweepStakes","index":9,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Tournament Sweepstakes"]
[]
["Rank","School","Total Wins",null,"Rank","School","Win %"]

{"sheet":"ResultSheet","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"STATS","index":11,"n_rows":142,"n_cols":15,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
["Number","Step","Done",null,null,null,"Round 1","Round 2","Round 3","Round 4","Round 5"]
["0a","Print Confirmation Sheets",null,null,null,"Nteams"]
["0b","Confirm Data Entry",null,null,null,"Ndebates"]
[1,"Pair Round 1",null,null,null,"Bye"]
[2,"Print Round 1 Pairings",null,null,null,"Round_Paired"]
[3,"Print Round 1 Ballots",null,null,null,"Results_In"]
[4,"Pair Round 2",null,null,null,"Top Row"]
[5,"Print Round 2 Pairings",null,null,null,"Bottom Row"]
[6,"Print Round 2 Ballots",null,null,null,"Ballot Rows",22]
[7,"Enter Round 1 Results",null,null,null,"Print Preview",true]
[8,"Enter Round 2 Results",null,null,null,"ADA",false,false]
[9,"Pair Round 3"]
[10,"Print Round 3 Pairings"]
[11,"Print Round 3 Ballots"]
[12,"Enter Round 3 Results",null,null,null,"Stats Speaker",{"$nulls":8},"Jscore"]
[13,"Pair Round 4"]
[14,"Print Round 4 Pairings"]
[15,"Print Round 4 Ballots"]
[16,"Enter Round 4 Results"]
["17a","Pair Round 5"]
["17b","Print Round 5 Pairings"]
["17c","Print Round 5 Ballots"]
["17d","Enter Round 5 Results"]
[18,"Print Team Ranking"]
[19,"Print Speaker Ranking"]
[20,"Print Result Sheets"]
[21,"Print Sweepstakes"]
[22,"All Done!!!"]
[]
[]
[]
[]
["Checking","worksheet","range"]
["worksheet","Ballot"]
["range","Ballot","Ballot_DN"]
["range","Ballot","Ballot_Judge"]
["range","Ballot","Ballot_Opp"]
["range","Ballot","Ballot_Prop"]
["range","Ballot","Ballot_Room"]
["range","Ballot","Ballot_Round"]
["range","Ballot","Ballot_TournamentName"]
["worksheet","Entries"]
["range","Entries","Assigned"]
["range","Entries","Cohort"]
["range","Entries","CurrSide"]
["range","Entries","SchoolCode"]
["range","Entries","SchoolName"]
["range","Entries","Speaker1"]
["range","Entries","Speaker2"]
["range","Entries","Speaker3"]
["range","Entries","TeamActive"]
["range","Entries","TeamCode"]
["range","Entries","TeamName"]
["range","Entries","Pts"]
["range","Entries","Random"]
["range","Entries","Wins"]
["range","Judges","J_R1"]
["range","Judges","J_R2"]
["range","Judges","J_R3"]
["range","Judges","J_R4"]
["range","Judges","J_R5"]
["range","Judges","Judge_Active"]
["range","Judges","Judge_Code"]
["range","Judges","Judge_Name"]
["range","Judges","Judge_SC"]
["range","Judges","Judge_1"]
["range","Judges","Judge_2"]
["range","Judges","Judge_Assg"]
["worksheet","Main"]
["range","Main","Current_Step"]
["range","Main","Total_Prelims"]
["range","Main","Tournament_Name"]
["worksheet","Pairings"]
["range","Pairings","P_DC"]
["range","Pairings","P_JC"]
["range","Pairings","P_Judge"]
["range","Pairings","P_OC"]
["range","Pairings","P_Opp"]
["range","Pairings","P_PC"]
["range","Pairings","P_Prop"]
["range","Pairings","P_RC"]
["range","Pairings","P_Room"]
["range","Pairings","P_Diag"]
["range","Pairings","P_O1S"]
["range","Pairings","P_O2S"]
["range","Pairings","P_O3S"]
["range","Pairings","P_P1S"]
["range","Pairings","P_P2S"]
["range","Pairings","P_P3S"]
["range","Pairings","P_WC"]
["worksheet","ResultSheet"]
["worksheet","Rooms"]
["range","Rooms","Room_Active"]
["range","Rooms","Room_ADA_Judge"]
["range","Rooms","Room_ADA_Team"]
["range","Rooms","Room_Code"]
["range","Rooms","RoomName"]
["worksheet","SpeakerAwards"]
["range","SpeakerAwards","Speak_HL"]
["range","SpeakerAwards","Speak_JVar"]
["range","SpeakerAwards","Speak_Name"]
["range","SpeakerAwards","Speak_OppW"]
["range","SpeakerAwards","Speak_Rank"]
["range","SpeakerAwards","Speak_RN"]
["range","SpeakerAwards","Speak_School"]
["range","SpeakerAwards","Speak_TeamW"]
["range","SpeakerAwards","Speak_Total"]
["range","STATS","nteams"]
["range","STATS","ADA"]
["range","STATS","Ballot_Rows"]
["range","STATS","Bottom_Row"]
["range","STATS","Bye"]
["range","STATS","Checking"]
["range","STATS","NDebates"]
["range","STATS","NTeams"]
["range","STATS","Results_In"]
["range","STATS","Round_Paired"]
["range","STATS","StepDescription"]
["range","STATS","StepDone"]
["range","STATS","Steps"]
["range","STATS","Top_Row"]
["range","STATS","PrintP"]
["range","STATS","Stats_Speaker"]
["range","STATS","JScore"]
["worksheet","SweepStakes"]
["range","SweepStakes","Sweeps_Perc"]
["range","SweepStakes","Sweeps_school1"]
["range","SweepStakes","Sweeps_School2"]
["range","SweepStakes","Sweeps_Total"]
["range","SweepStakes","Sweeps_winP"]
["range","SweepStakes","Sweeps_winsT"]
["worksheet","TeamAwards"]
["range","TeamAwards","Team_HL"]
["range","TeamAwards","Team_OppW"]
["range","TeamAwards","Team_Points"]
["range","TeamAwards","Team_Rank"]
["range","TeamAwards","Team_Rank_Name"]
["range","TeamAwards","Team_Rank_Spk1"]
["range","TeamAwards","Team_Rank_Spk2"]
["range","TeamAwards","Team_Rank_Spk3"]
["range","TeamAwards","Team_Wins"]
["worksheet","Confirmation"]