{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Ranking","Auto Manage","Sched","Table","Set-up","Players","Games","S-Data","Data","Player Import"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":106,"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":"Ranking","index":0,"n_rows":17,"n_cols":25,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Mike","George","Andy","Nick","Bob","Fred","Mary","Victoria","Sue","Sandra","Alison","Ivan","Alan","Fiona","Charlie","Games Played","Games Won","Net Hoops","% Wins","Win Grouping","GP 1 Wins","GP 2 Wins","Other Wins","Ranking"]
["Mike",null,"26",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,10,1,1,null,1,null,1]
["George","16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,-10,0,2,null,null,null,2]
["Andy",null,null,null,"L2-P",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,3]
["Nick",null,null,"L2-P",null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,4]
["Bob",null,null,null,null,null,"L3-P",null,null,null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,5]
["Fred",null,null,null,null,"L3-P",null,null,null,null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,6]
["Mary",null,null,null,null,null,null,null,"L2-S",null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,7]
["Victoria",null,null,null,null,null,null,"L2-S",null,null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,8]
["Sue",null,null,null,null,null,null,null,null,null,"L4-S",null,null,null,null,null,0,0,0,0,2,null,null,null,9]
["Sandra",null,null,null,null,null,null,null,null,"L4-S",null,null,null,null,null,null,0,0,0,0,2,null,null,null,10]
["Alison",null,null,null,null,null,null,null,null,null,null,null,"L3-S",null,null,null,0,0,0,0,2,null,null,null,11]
["Ivan",null,null,null,null,null,null,null,null,null,null,"L3-S",null,null,null,null,0,0,0,0,2,null,null,null,12]
["Alan",null,null,null,null,null,null,null,null,null,null,null,null,null,"L5-P",null,0,0,0,0,2,null,null,null,13]
["Fiona",null,null,null,null,null,null,null,null,null,null,null,null,"L5-P",null,null,0,0,0,0,2,null,null,null,14]
["Charlie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,2,null,null,null,15]
[null,null,"15 players not yet reached threshold of 3 games"]

{"sheet":"Auto Manage","index":1,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[26,3,27,17],[1,2,2,13],[4,3,4,13]]}
[{"$f":"A_CEsta","v":11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto Mgt Mode Instructions:"]
[{"$f":"S_Game_Sta_Ch","v":2},null,{"$f":"'Set-up'!O12","v":"Test 26pt AC Tournament"},null,null,null,null,null,null,null,null,null,null,null,null,"Follow Prompt instructions to enter a result"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on  a Waiting or Resting Player to swap their status"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on 'Clear Selection' to reset result entry selection"]
[null,null,null,"Select a game for result entry",null,null,null,null,null,null,null,null,null,null,null,"Click on 'Schedule Games' to schedule Waiting players"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on 'Manger Needed' if somethng is wrong!"]
[null,null,"In Progress Games",null,null,null,"Player 1",null,"Player 2",null,"Result",null,null,null,null,"Players Waiting",3,"Tournament Status Summary"]
[null,null,null,null,null,null,"Score",null,"Score",null,"Type",null,null,null,null,null,null,"Rank:Games:Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Players Resting",0]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Action Status :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Game_Thresh = 0, \"\", \"Threshold # Games for Ranking is : \" & Game_Thresh)","v":"Threshold # Games for Ranking is : 3"}]
[]
[null,null,null,{"$f":"'Set-up'!O15","v":"Enjoy Yourself and don't give the manager any hassle!"}]
[null,null,"Manager Message:"]

{"sheet":"Sched","index":2,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[21,4,21,10]]}
[]
[null,"Auto Scheduling Options",null,"Players avail for Scheduling",null,null,null,"Avail Players for Selected Player",null,null,"Provisionally Scheduled Games",null,null,"Available Lawns"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Players to omit from schedule",null,null,null,null,null,"Unavail Lawns"]
[]
[]
[]
[]
[]
[]
[null,null,"Status Msg:"]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(S_Game_Sta_Ch = 0, \"\", \"Note: Game Status has changed since schedule data was last reset\")","v":"Note: Game Status has changed since schedule data was last reset"}]

{"sheet":"Table","index":3,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Mike","George","Andy","Nick","Bob","Fred","Mary","Victoria","Sue","Sandra","Alison","Ivan","Alan","Fiona","Charlie","Games Played","Games Won","Net Hoops"]
["Mike",null,"26",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,10]
["George","16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,-10]
["Andy",null,null,null,"L2-P",null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Nick",null,null,"L2-P",null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Bob",null,null,null,null,null,"L3-P",null,null,null,null,null,null,null,null,null,0,0,0]
["Fred",null,null,null,null,"L3-P",null,null,null,null,null,null,null,null,null,null,0,0,0]
["Mary",null,null,null,null,null,null,null,"L2-S",null,null,null,null,null,null,null,0,0,0]
["Victoria",null,null,null,null,null,null,"L2-S",null,null,null,null,null,null,null,null,0,0,0]
["Sue",null,null,null,null,null,null,null,null,null,"L4-S",null,null,null,null,null,0,0,0]
["Sandra",null,null,null,null,null,null,null,null,"L4-S",null,null,null,null,null,null,0,0,0]
["Alison",null,null,null,null,null,null,null,null,null,null,null,"L3-S",null,null,null,0,0,0]
["Ivan",null,null,null,null,null,null,null,null,null,null,"L3-S",null,null,null,null,0,0,0]
["Alan",null,null,null,null,null,null,null,null,null,null,null,null,null,"L5-P",null,0,0,0]
["Fiona",null,null,null,null,null,null,null,null,null,null,null,null,"L5-P",null,null,0,0,0]
["Charlie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]

{"sheet":"Set-up","index":4,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,2],[11,14,12,18],[14,14,15,18],[1,1,1,2],[1,8,1,9],[1,12,1,15]]}
[]
[null,"Set before games are scheduled",null,null,null,"Parameters that impact scheduling",null,null,"Parameters that impact data display",null,null,null,"Miscellaneous Functions"]
[]
[]
[null,null,null,null,null,null,null,1,null,"Min # Players for Auto Sched"]
[]
[null,null,null,null,null,null,null,4,null,"Ranking Game Threshold"]
[]
[null,null,null,null,null,null,null,3,null,"Ranking Group Count"]
[3]
[null,null,null,null,null,null,null,null,"12345","Manager Password"]
[5,"# Lawns",null,null,null,null,null,null,null,null,null,null,"Tournament Name:",null,"Test 26pt AC Tournament"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manager Message:",null,"Enjoy Yourself and don't give the manager any hassle!"]
[1]
[]
[26,"Points/Game"]
[]
[]
[]
[]
[]
[null,"Action Status :",null,null,"ERROR: Lawn config can only be changed before games are scheduled"]

{"sheet":"Players","index":5,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["ID","Player Name","Handicap","A","Played","Won","Last Event Time","Last Lawn","# Times","Swiss Pos"]
[1,"Mike",null,"A",1,1,"2024-06-19T17:57:07",1,1,1]
[2,"George",4,"A",1,0,"2024-06-19T17:57:08",1,1,2]
[3,"Andy",null,"P",0,0,"2024-06-19T17:57:07",2,1,3]
[4,"Nick",20,"P",0,0,"2024-06-19T17:57:07",2,1,4]
[5,"Bob",null,"P",0,0,"2024-06-19T17:57:07",3,1,5]
[6,"Fred",null,"P",0,0,"2024-06-19T17:57:07",3,1,6]
[7,"Mary",null,"P",0,0,"2024-06-19T17:57:07",2,1,7]
[8,"Victoria",null,"P",0,0,"2024-06-19T17:57:07",2,1,8]
[9,"Sue",null,"P",0,0,"2024-06-19T17:57:07",4,1,9]
[10,"Sandra",null,"P",0,0,"2024-06-19T17:57:07",4,1,10]
[11,"Alison",null,"P",0,0,"2024-06-19T17:57:07",3,1,11]
[12,"Ivan",null,"P",0,0,"2024-06-19T17:57:07",3,1,12]
[13,"Alan",null,"P",0,0,"2024-06-19T17:57:07",5,1,13]
[14,"Fiona",null,"P",0,0,"2024-06-19T17:57:07",5,1,14]
[15,"Charlie",0,"A",0,0,null,null,null,15]

{"sheet":"Games","index":6,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["id","P1-index","Player 1","P1 score","Type","P2-Score","Player 2","P2-index","Lawn-id","Status","Time Scheduled","Time Result Entered"]
[1,1,"Mike",26,null,16,"George",2,"L1-S","C","2024-06-19T17:57:07","2024-06-19T17:57:15"]
[2,3,"Andy",null,null,null,"Nick",4,"L2-P","P","2024-06-19T17:57:07"]
[3,5,"Bob",null,null,null,"Fred",6,"L3-P","P","2024-06-19T17:57:07"]
[4,7,"Mary",null,null,null,"Victoria",8,"L2-S","P","2024-06-19T17:57:07"]
[5,9,"Sue",null,null,null,"Sandra",10,"L4-S","P","2024-06-19T17:57:07"]
[6,11,"Alison",null,null,null,"Ivan",12,"L3-S","P","2024-06-19T17:57:07"]
[7,13,"Alan",null,null,null,"Fiona",14,"L5-P","P","2024-06-19T17:57:07"]

{"sheet":"S-Data","index":7,"n_rows":361,"n_cols":70,"rows_kept":361,"cut":false,"hidden":true,"merged":[]}
["Msg #","P1","P2","Message",null,"Rank","Plays","Top Sch","Top Rk","Bot Sch","Bot Rk","P-Name","P-Ind","P-won-played","Sch_sta","Played","Time","Priority","Random",null,"Players Available For Scheduling","R",null,"Players to Omit from Scheduling","R",null,"Players Available for P1","R",null,"R1"," Player 1","R2","Player 2","Lawn","P1-id","P2","Lawn_id"," Provisionally Scheduled Games Text",null,"Id","Name",null,"id","Name",null,"id","Name",null,"id","Name","Game",null,"Game","P1","P2","Av_Ln","R_Ln","11","AL1","AL2","AL3","AL4","AL5","AL6","AL7","AL8","AL9","AL10","AL11","AL12"]
[1,15,null,"# Players to Schedule is",null,1,null,1,2,null,15,"Mike",1," - 0/0","P",0,null,1,0.57418155670166016,null,"R-15  Charlie - 0/0",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"L4-S",null,1,"---",null,2,"L1-P",null,null,null,null,null,1,1,2,5,5,3,2,5,3,4,1]
[2,15,null,"Odd number of players selected ",null,2,null,null,1,null,15,"George",2," - 0/0","P",0,null,2,0.70663565397262573,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"L5-S",null,11,"L5-S",null,8,"L4-P",null,null,null,null,null,2,3,4,5,5,4,3,5,1,4,2]
[3,null,null,"Sorting by last available player ",null,3,null,2,4,null,15,"Andy",3," - 0/0","P",0,null,3,0.535042405128479,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"L2-S",null,null,null,null,null,null,null,3,"L1-S",1,null,3,5,6,5,5,6,2,4,5,3,1]
[4,15,null,"Player to leave out",null,4,null,null,1,null,15,"Nick",4," - 0/0","P",0,null,4,0.56001502275466919,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"L2-P",null,null,null,null,null,null,null,4,"L2-P",2,null,4,7,8,5,5,5,4,3,1,5,2]
[5,7,null,"Games to Schedule",null,5,null,3,6,null,15,"Bob",5," - 0/0","P",0,null,5,0.39201855659484863,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"L1-S",null,null,null,null,null,null,null,5,"L2-S",4,null,5,9,10,5,5,9,3,2,5,1,4]
[6,1,2,"Match Scheduled from top: 1",null,6,null,null,1,null,15,"Fred",6," - 0/0","P",0,null,6,0.8627437949180603,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"L3-S",null,null,null,null,null,null,null,6,"L3-P",3,null,6,11,12,5,5,7,1,4,5,2,3]
[7,14,13,"Match Scheduled from bottom: 2",null,7,null,4,8,null,15,"Mary",7," - 0/0","P",0,null,7,0.48786056041717529,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"L5-P",null,null,null,null,null,null,null,7,"L3-S",6,null,7,13,14,5,5,10,4,5,2,1,3]
[8,3,4,"Match Scheduled from top: 3",null,8,null,null,1,null,15,"Victoria",8," - 0/0","P",0,null,8,0.68813282251358032,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"L3-P"]
[9,12,11,"Match Scheduled from bottom: 4",null,9,null,null,1,null,15,"Sue",9," - 0/0","P",0,null,9,0.29794836044311523,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,9,"L4-S",5]
[10,5,6,"Match Scheduled from top: 5",null,10,null,null,1,3,9,"Sandra",10," - 0/0","P",0,null,10,0.5241047739982605,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,10,"L5-P",7]
[11,10,9,"Match Scheduled from bottom: 6",null,11,null,null,1,null,15,"Alison",11," - 0/0","P",0,null,11,0.61632645130157471,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,11,"L5-S"]
[12,7,8,"Match Scheduled from top: 7",null,12,null,null,1,2,11,"Ivan",12," - 0/0","P",0,null,12,0.21508866548538208]
[13,null,null,"Matches scheduled after: 4 iterations",null,13,null,null,1,null,15,"Alan",13," - 0/0","P",0,null,13,0.23002028465270996]
[null,null,null,null,null,14,null,null,1,1,13,"Fiona",14," - 0/0","P",0,null,14,0.43907064199447632]
[null,null,null,null,null,15,"L",null,1,null,15,"Charlie",15," - 0/0","A",0,null,15,0.98788392543792725]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"X"]

{"sheet":"Data","index":8,"n_rows":75,"n_cols":72,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["Sheet","Label","Value","Column1",null,"ID","Description","Name","Status","Selection Text",null,"id","P1-index","Player 1","Res 1","Res Type","Res 2","Player 2","P2-index","Lawn","Status","Games Status",null,"P-id","P-Name",null,"P-id","P-Name",null,"Row","Col",null,"Score","Type",null,"Player","Rank","Group","Thresh","Played","Won","Win %","Win-1","Win-2","Win-3","Win-4","Win-5","Win-6","Win-7","Win-8","Win-other","Net-hoops","Ranking Text","Swiss_Order",null,"ID","Description","Name","P","S-state",null,"State","B1_text","B1_C","B2_text","B2_C","B3_text","B3_C","B4_text","B4_C","B5_text","B5_C"]
[null,"Player Count",15,null,null,1,"Unspecified","---","U",{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":"U  ---"},null,2,"XX3","XXAndy","XX","XX","XX","XXNick","XX4","XXL2-P","XXP","P L2-P Andy VS Nick",null,1,"Mike",null,null,null,null,"0","A",null,26,"<blank>",null,1,1,1,"N",1,1,1,null,1,null,null,null,null,null,null,null,10,"R  1 -   1/  1   Mike",1,null,1,"Unspecified","---","U","U",null,1,null,null,"Schedule Games","5","Add Player","5",null,null,"Manager Needed","3"]
[null,"Game Count",7,null,null,2,"Lawn 1 Primary","L1-P","U",{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":"U  L1-P"},null,3,"XX5","XXBob","XX","XX","XX","XXFred","XX6","XXL3-P","XXP","P L3-P Bob VS Fred",null,2,"George",null,null,null,null,"1","B",null,25,"t",null,2,2,2,"N",1,0,0,null,null,null,null,null,null,null,null,null,-10,"R  2 -   0/  1   George",2,null,2,"Lawn 1 Primary","L1-P","U","U",null,2,null,null,null,null,null,null,"Clear Selection","1","Manager Needed","3"]
[null,"Game Record",7,null,null,3,"Lawn 1 Secondary","L1-S","A",{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":"A  L1-S"},null,4,"XX7","XXMary","XX","XX","XX","XXVictoria","XX8","XXL2-S","XXP","P L2-S Mary VS Victoria",null,15,"Charlie",null,null,null,null,"2","C",null,24,"TP",null,3,3,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  3 -   0/  0   Andy",3,null,3,"Lawn 1 Secondary","L1-S","A","P",null,3,"Confirm Result","1",null,null,null,null,"Clear Selection","1","Manager Needed","3"]
[null,null,null,null,null,8,"Lawn 4 Primary","L4-P","U",{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":"U  L4-P"},null,5,"XX9","XXSue","XX","XX","XX","XXSandra","XX10","XXL4-S","XXP","P L4-S Sue VS Sandra",null,null,null,null,null,null,null,"3","D",null,23,"TPO",null,4,4,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  4 -   0/  0   Nick",4,null,4,"Lawn 2 Primary","L2-P","P","P",null,4]
[null,null,null,null,null,11,"Lawn 5 Secondary","L5-S","A",{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":"A  L5-S"},null,6,"XX11","XXAlison","XX","XX","XX","XXIvan","XX12","XXL3-S","XXP","P L3-S Alison VS Ivan",null,null,null,null,null,null,null,"4","E",null,22,"OTP",null,5,5,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  5 -   0/  0   Bob",5,null,5,"Lawn 2 Secondary","L2-S","P","P",null,5]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,7,"XX13","XXAlan","XX","XX","XX","XXFiona","XX14","XXL5-P","XXP","P L5-P Alan VS Fiona",null,null,null,null,null,null,null,"5","F",null,21,"STP",null,6,6,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  6 -   0/  0   Fred",6,null,6,"Lawn 3 Primary","L3-P","P","P",null,6]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6","G",null,20,"QP",null,7,7,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  7 -   0/  0   Mary",7,null,7,"Lawn 3 Secondary","L3-S","P","P",null,7]
["Auto","Game - id",1,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7","H",null,19,"QPO",null,8,8,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  8 -   0/  0   Victoria",8,null,8,"Lawn 4 Primary","L4-P","U","U",null,8]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8","I",null,18,"OQP",null,9,9,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R  9 -   0/  0   Sue",9,null,9,"Lawn 4 Secondary","L4-S","P","P",null,9]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9","J",null,17,"SQP",null,10,10,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R10 -   0/  0   Sandra",10,null,10,"Lawn 5 Primary","L5-P","P","P",null,10]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10","K",null,16,"QnP",null,11,11,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R11 -   0/  0   Alison",11,null,11,"Lawn 5 Secondary","L5-S","A","A",null,11,"Lawn Management","5","Schedule Games","5","Add Player","5",null,null,"Set Auto Mode","5"]
["Auto","Player 1 Score - List",0,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11","L",null,15,"SxP",null,12,12,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R12 -   0/  0   Ivan",12,null,12,"Lawn 6 Primary","L6-P","X","A",null,12,null,null,"Suspend Game","1","Cancel Game","1","Clear Selection","1","Set Auto Mode","5"]
["Auto","Player 2 Score - List",0,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12","M",null,14,"OCP",null,13,13,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R13 -   0/  0   Alan",13,null,13,"Lawn 6 Secondary","L6-S","X","A",null,13,null,null,null,null,"Cancel Game","1","Clear Selection","1","Set Auto Mode","5"]
["Auto","Result Type - List",0,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13","N",null,13,null,null,14,14,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R14 -   0/  0   Fiona",14,null,14,"Lawn 7 Primary","L7-P","X","U",null,14,"Confirm Result","1",null,null,null,null,"Clear Selection","1","Set Auto Mode","5"]
["Auto","Games List - Mode","R",null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14","O",null,12,null,null,15,15,2,"N",0,0,0,null,null,null,null,null,null,null,null,null,0,"R15 -   0/  0   Charlie",15,null,15,"Lawn 7 Secondary","L7-S","X","U",null,15,"Game Management","5"]
["Auto","Player - List",0,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15","P",null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Lawn 8 Primary","L8-P","X","X",null,16]
["Sched","Include Players",1,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16","Q",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Lawn 8 Secondary","L8-S","X","P",null,17]
["Sched","Odd # handling",1,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17","R",null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Lawn 9 Primary","L9-P","X","X",null,18]
["Sched","Lawn Allocation",2,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18","S",null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Lawn 9 Secondary","L9-S","X","P",null,19]
["Sched","Game Count",101,"?",null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19","T",null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Lawn 10 Primary","L10-P","X","X",null,20]
["Set-up","Lawn Count",11,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20","U",null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Lawn 10 Secondary","L10-S","X","P",null,21,"Delete Player","3",null,null,"Amend Player","5","Show In-Progress Games","5","Set Auto Mode","5"]
["Set-up","Lawn Mode",3,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21","V",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Lawn 11 Primary","L11-P","X",null,null,22,null,null,"Suspend Game","1","Cancel Game","1","Clear Selection","1","Set Auto Mode","5"]
["Set-up","Random Initial Draw",false,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22","W",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Lawn 11 Secondary","L11-S","X",null,null,23,null,null,null,null,"Cancel Game","1","Clear Selection","1","Set Auto Mode","5"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23","X",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Lawn 12 Primary","L12-P","X",null,null,24,"Confirm Result","1",null,null,null,null,"Clear Selection","1","Set Auto Mode","5"]
["Set-up","Scoring Mode","A",null,null,null,null,null,null,{"$f":"IF(Lawn_Sel[[#This Row],[ID]]=\"\",\"\",Lawn_Sel[[#This Row],[Status]] & \"  \" & Lawn_Sel[[#This Row],[Name]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24","Y",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Lawn 12 Secondary","L12-S","X",null,null,25,"Amend   Result","1",null,null,null,null,"Clear Selection","1","Set Auto Mode","5"]
["Set-up","Points per game",26,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,"25","Z",null,1]
["Table","Col Games Played",{"$f":"Player_Count+2","v":17},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,"26","AA",null,0]
["Table","Col Games Won",{"$f":"C28+1","v":18},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,"27","AB"]
["Table","Col Net Hoops",{"$f":"C29+1","v":19},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,"28","AC"]
["Table","Col % Wins",{"$f":"C30+1","v":20},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,"29","AD"]
["Table","Col Grouping",{"$f":"C31+1","v":21},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,"30","AE"]
["Table","Col Wins Gp 1",{"$f":"C32+1","v":22},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,"31","AF"]
["Table","Num Groups",{"$f":"S_New_Grp_num - 1","v":2},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,"32","AG"]
["Table","Col Ranking",{"$f":"C33+C_num_grps + 1","v":25},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,"33","AH"]
["Config","Max Groups",8,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,"34","AI"]
["Config","Max Players",50,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,"35","AJ"]
["Config","Max Lawns",12,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,"36","AK"]
["Sched","Avail Player Select",0,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,"37","AL"]
["Sched","Omit Player Select",0,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,"38","AM"]
["Sched","Avail Player Opp Select",0,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,"39","AN"]
["Sched","Avail Lawn Select",0,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,"40","AO"]
["Sched","Prov Sched Game Sel",0,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,"41","AP"]
["General","Program Version","V7.1.5",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,"42","AQ"]
["Auto","Avail Player Select",0,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,"43","AR"]
["Auto","Rest Player Select",0,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,"44","AS"]
["Auto","Selected Game",0,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,"45","AT"]
["Auto","Auto Mode","N",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,"46","AU"]
[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,"47","AV"]
["Auto","T'mnt Status Select",0,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,"48","AW"]
["Auto","Result Details Comp","N",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,"49","AX"]
["Sched","Call from Auto/Manul","M",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,"50","AY"]
["Set-up","Auto Player add option",1,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,"51","AZ"]
[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,"52","BA"]
[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,"53","BB"]
[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,"54","BC"]
[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,"55","BD"]
[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,"56","BE"]
["Auto","Current Entry State",11,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,"57","BF"]
["Auto","Player_id select",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,"58","BG"]
["Auto","New Entry State",11,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,"59","BH"]
["Sched","Unavail Lawn Sel",0,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,"60","BI"]
["Sched","Game Status Changed",2]
["Set-up","Tournament Type",2]
["Set-up","Score Range","Data!$AG$2:$AG$28"]
["Auto","Game/Lawn Mode","G"]
["Set-up","Auto_Sched_Option",2]
["Set-up","Allow_Unalloc_Games",1]
["Set-up","Ranking Group Count",{"$f":"S_New_Grp_num - 1","v":2}]
["Set-up","Ranking Game Threshold",{"$f":"S_New_Thresh - 1","v":3}]
["Set-up","Min # Players for Auto Sched",{"$f":"S_New_min_players + 1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-16T17:19:29"]
["Set-up","Request Player Hcp",false]
["Set-up","Request Player Avail",false]
["Set-up","Show Data Tabs",false]
["Set-up","Ranking: Show Nett Hoops",true]

{"sheet":"Player Import","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,3,7,9]]}
["Player Name","Handicap"]
[null,2,null,"Enter the players names and, optionally their handicaps, in the table.  Players can be typed in individually or 'pasted' from another application. Select the 'Import player' button to add the players to the tournament.  The players will be added to any players that have already been defined - either on the Auto_Manage tab or by previous import.  Select the 'Exit Import' Button to return to the set-up tab"]
["Mary"]
["Victoria"]
[]
["Sue"]
["Sandra"]
[]
[]
["Alison"]
[]
["Ivan"]