{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Info","Teams","Running Order","Store","2 & 5","2 & 4","2 & 3","2 & 2","SEVEN","SIX","FIVE","FOUR","THREE","TWO","TeamDetails"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Info","index":0,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[8,20,9,20],[10,20,11,20],[12,20,13,20],[14,20,15,20],[7,12,7,20],[14,16,15,16],[14,17,15,17],[14,18,15,18],[14,15,15,15],[8,19,9,19],[10,19,11,19],[12,19,13,19],[14,19,15,19],[10,18,11,18],[8,18,9,18],[14,5,15,5],[14,8,15,8],[14,13,15,13],[14,14,15,14],[14,10,15,10],[2,14,2,15],[10,13,11,13],[10,16,11,16],[10,17,11,17],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[10,14,11,14],[2,4,2,5],[8,5,9,5],[10,5,11,5],[12,5,13,5],[0,0,0,12],[8,8,9,8],[10,8,11,8],[12,8,13,8],[8,11,9,11],[10,11,11,11],[12,11,13,11],[8,10,9,10],[10,10,11,10],[12,10,13,10],[8,9,9,9],[10,9,11,9],[12,9,13,9],[14,9,15,9],[12,18,13,18],[12,13,13,13],[12,14,13,14],[12,15,13,15],[12,16,13,16],[12,17,13,17],[14,11,15,11]]}
["FLYBALL RUNNING ORDER GENERATOR\nMaximum Seven Divisions\n 3 TO 7 TEAMS PER DIVISION - 36 TO 40 HEATS PER TEAM \n\n",null,null,null,null,null,null,null,null,null,null,null,null,"ver 2.01 -  13/8/2014"]
[null,null,null,null,"run combined divisions separately first then combine",null,null,null,null,null,null,null,null,null,"run combined divisions as ONE division"]
[null,null,"No of teams in Div","No of round robins","Team Race format",null,"TOTAL RACES / TEAM","TOTAL HEATS /TEAM","TOTAL RACES / DIV","Race Time (min)","No Sets per Draw",null,"No of teams in Div","No of round robins","Team Race format",null,"TOTAL RACES / TEAM","TOTAL HEATS /TEAM","TOTAL RACES / DIV","Race Time (min)","No Sets per Draw"]
[null,null,3,4,"(2Rx5H)  +  (2Rx5H)  +  (2Rx5H) + (2Rx5H)",null,8,40,12,58,12]
[null,null,4,3,"(3R x 5H)  + (3R x 5H) + (3R X 3H)",null,9,39,18,84,12,null,null,"greyed font indicates selection is not available"]
[null,null,5,2,"(4Rx5H)  +  (4Rx5H)",null,8,40,20,120,12]
[null,null,6,2,"(5Rx5H) + (5Rx3H)",null,10,40,30,120,12]
[null,null,7,2,"(6Rx3H) + (6Rx3H)",null,12,36,42,120,14,null,"To select these you need tick the \"ONE DIVISION\" for the combined divsions, - \"Teams\" page"]
[null,null,2,"2 + 1 comb","(1Rx5H) + (1Rx5H)","+  comb(3Rx5H)",5,1,10,80,9,"OR",2,"2 (comb)","(3R x 5H)  + (3R x 3H)",null,6,24,12,84,9]
[null,null,2,"2 + 1 comb","(1Rx5H) + (1Rx5H)",null,5,25,null,null,null,null,2]
[null,null,2,"2 + 1 comb","(1Rx3H) + (1Rx3H)","+  comb(4Rx5H)",6,26,15,110,9,"OR",2,"2 (comb)","(4Rx3H)  +  (4Rx3H)",null,8,24,20,120,10]
[null,null,3,"1 + 1 comb","(2Rx3H)",null,6,26,null,null,null,null,3]
[null,null,2,"2 + 1 comb","(1Rx5H) + (1Rx5H)"," +  comb(5Rx3H)",7,25,23,142,9,"OR",2,"1 (comb)","(5Rx5H)",null,5,25,15,120,9]
[null,null,4,"1 + 1 comb","(3Rx3H)",null,8,24,null,null,null,null,4]
[null,null,2,"2 + 1 comb","(1Rx3H) + (1Rx3H)"," +  comb(6Rx3H)",8,24,33,188,12,"OR",2,"1 (comb)","(6Rx3/5H)",null,6,"av 24\n(18-30)",21,136,9]
[null,null,5,"1 + 1 comb","(4Rx2/3H)",null,10,"Av 28\n26 - 30",null,null,null,null,5]
[null,null,"ver 2  changes - see below"]
[null,null,"Allows for a 2 team division to be combined with another 2, 3, 4 or 5 team division",null,null,null,null,null,null,null,null,null,"*3/5= FIRST TO 3 HEATS"]
[null,null,"Can only combine with another division immediately below or immediately above, ",null,null,null,null,null,null,null,null,null,"*2/3=FIRST TO 2 HEATS"]
[null,null,"eg div 3 with div 2 or div 4, but not with div 1 or div 5"]
[null,null,null,"On the \"Teams\" sheet, enter the division number which is being combined in the column \"Combine with Div. No\""]
[null,null,null,"This MUST be done for both combined divisions"]
[null,null,"In combined divisions, the round robin within each division is run first, and then the combined round robin. This ensures"]
[null,null,"that if the competition is shortened (eg weather interruption) then the individual round robins are completed."]
[]
[null,null,"The division with 5 teams in it has an extra set of races to complete the round robin.  To overcome two sets of races"]
[null,null,"being run adjacent to each other, select a sort order which has this division as the first division in the sort."]
[null,null,"This will then also finish off with that division as it will be the first (and only) set in the final group of races."]
[null,null,"If there is more than one 5 team division, you will have to do a manual sort or a custom sort in excel. (see below)"]
[]
[null,null,"SORTING: In a six division competition, there are several hundred possible combinations of organising the division order."]
[null,null,"This program offers seven choices. They are",null,null,null,null,null,"Order of Sort"]
[null,null,null,null,"up","U",1,2,3,null,4,5,6,7,7]
[null,null,null,null,"down","D",7,6,5,null,4,3,2,1,1]
[null,null,null,null,"down, beginning with div 5",5,5,4,3,null,2,1,7,6,6]
[null,null,null,null,"down, beginning with div 4",4,4,3,2,null,1,7,6,5,5]
[null,null,null,null,"down, beginning with div 3",3,3,2,1,null,7,6,5,4,4]
[null,null,null,null,"down, beginning with div 2",2,2,1,7,null,6,5,4,3,3]
[null,null,null,null,"down, beginning with div 1",1,1,7,6,null,5,4,3,2,2]
[]
[null,null,"If you know some excel, you may do your own custom sort."]
[null,null,"Sort using:",null,"first key: Set (smallest to largest)"]
[null,null,null,null,"second key: Div (this is the one to do a custom sort on)"]
[null,null,null,null,"third key: race (smallest to largest)"]
[null,null,"IF YOU WISH TO DO A CUSTOM SORT, ANSWER NO TO THE PROMPT BOX WHICH ASKS WHETHER TO ADD THE RACE NUMBER"]
[]
[null,null,"end"]
[null,null,"Bill Reynolds"]
[null,null,"May 2011"]
[]
[null,null,"ver 2"]
[null,1,"Added a another division so that a two team division can be combined with a five team division. Had to use first to 3, max 5 heats"]
[null,null,"to maintain similar heats for all teams. However, due to the number of races involved, it is best to run as one combined"]
[null,null,"division of seven (cannot guarantee exact number of heats). "]
[null,null,"DUE TO THE HIGH NUMBER OF ROUNDS WITHIN THIS DRAW, YOU MAY HAVE TO MANUALLY ARRANGE SOME RACES TO ENSURE "]
[null,null," AN EVEN TIME DISTRIBUTION BETWEEN RACES. TRY TO AVOID THE 7 TEAM DIVISION IF POSSIBLE."]
[null,2,"Included on this sheet total race times for each division (excludes lunch break) based on 90 sec changeovers"]
[null,3,"Included on this sheet the number of sets (round) in each draw. Always start your sort order with the higher number of sets."]
[null,4,"Included option for combined divisions"]
[null,null,null,"(a) run one or more round robins, then combine for a final round robin, OR"]
[null,null,null,"(b) run as one combined division (Refer to tick box on teams page)"]
[null,5,"Included a page which lists the details for each team. Just click the \"Get Team Details\" button."]
[null,null," Handy to see when they are running and the time between races"]
[]
[null,null,"end"]
[null,null,"Bill Reynolds"]
[null,null,"May 2013"]

{"sheet":"Teams","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,10,0,16],[1,10,1,16],[50,1,56,1],[50,4,56,4],[50,5,56,5],[0,1,0,6],[42,5,48,5],[42,1,48,1],[42,4,48,4],[18,1,24,1],[18,4,24,4],[26,1,32,1],[26,4,32,4],[34,1,40,1],[34,4,40,4],[18,5,24,5],[2,1,8,1],[2,5,8,5],[2,4,8,4],[26,5,32,5],[34,5,40,5],[10,1,16,1],[10,4,16,4],[10,5,16,5]]}
[null,"FLYBALL \nRUNNING ORDER GENERATOR",null,null,null,null,null,null,"ver 2.01 -  13/8/2014",null,"40 HEAT /TEAM DRAW"]
[null,"DIVISION","#","TEAM NAME","No. of Teams","Combine with Div. No","Combined  Divisions\nRun as",null,null,null,"Program has been partly modified for 40 heats/team draw.\nWill not automatically combine divisions."]
[null,1,1,"T-Keilor Gold",{"$f":"COUNTA(D3:D10)","v":4},null,{"$f":"IF(F3=\"\",0,B3 & F3)","v":0},null,"INSTRUCTIONS:"]
[null,null,2,"Fly'D Over",null,null,false,null,"1.","ENTER TEAM NAMES FOR EACH DIVISION"]
[null,null,3,"Para Ball Busters",null,null,null,null,">","These may be copied and pasted from another excel file if desired "]
[null,null,4,"Para Troopers",null,null,null,null,">","Enter combined division number if combining divisions, else leave blank"]
[null,null,5,null,null,null,null,null,">","Select whether to run the combined divisions as one division"]
[null,null,6]
[null,null,7,null,null,null,null,null,"2.","CLICK THE \"CREATE RUNNING ORDER\" BUTTON"]
[null,null,null,null,null,null,null,null,">","You will be asked to choose a sort order "]
[null,2,1,"Para Gliders",{"$f":"COUNTA(D11:D17)","v":3},null,{"$f":"IF(F11=\"\",0,B11 & F11)","v":0},null,">","You will be asked whether to add race numbers"]
[null,null,2,"Para Shooters",null,null,false,null,null,"(click yes unless you plan to do a custom sort in excel - refer \"INFO\" page)"]
[null,null,3,"T-Keilor Laidbacks",null,null,null,null,null,"You can add race numbers at any time later  by clicking the  \"ADD RACE NUMBERS\" "]
[null,null,4,null,null,null,null,null,null,"button on the \"Running Order\" sheet"]
[null,null,5,null,null,null,null,null,null,"You will now be taken to the \"Running Order\" sheet."]
[null,null,6,null,null,null,null,null,"That's it! "]
[null,null,7]
[null,null,null,null,null,null,null,null,null,"However, you may like to do some further refinements, as below"]
[null,3,1,null,{"$f":"COUNTA(D19:D25)","v":0},null,{"$f":"IF(F19=\"\",0,B19 & F19)","v":0},null,"\"Running Order\" sheet"]
[null,null,2,null,null,null,false,null,"A.","CHECK THE RUNNING ORDER FOR CLUB BACK TO BACK CLASHES"]
[null,null,3,null,null,null,null,null,">","If you need to rearrange races by a few places  to avoid clashes, then"]
[null,null,4,null,null,null,null,null,null," change (swap) the race numbers (column\"C\"). "]
[null,null,5,null,null,null,null,null,">","Click the \"SORT INTO RACE ORDER\" button (races are resorted by the (new) number"]
[null,null,6,null,null,null,null,null,null,"You can do this at any time or any number of times to rearrange the races in order"]
[null,null,7,null,null,null,null,null,null,"If you have not made any changes, there is no need to do this."]
[]
[null,4,1,null,{"$f":"COUNTA(D27:D33)","v":0},null,{"$f":"IF(F27=\"\",0,B27 & F27)","v":0},null,null,"It is important that changes be within the same set, defined by Column \"B\", (\"SET\")"]
[null,null,2,null,null,null,false,null,null,"Column B must be in ascending order or the race sequence will be thrown out of order"]
[null,null,3,null,null,null,null,null,null,"Be aware of the effects on other teams if changing the race order."]
[null,null,4]
[null,null,5,null,null,null,null,null,"After race order is finalised:"]
[null,null,6,null,null,null,null,null,"B.","INSERT ROW WHERE THE LUNCH BREAK IS REQUIRED"]
[null,null,7,null,null,null,null,null,">","Insert row and type the word LUNCH in each of the team name columns"]
[null,null,null,null,null,null,null,null,">","Add the lunch break time (in minutes) in the changeover column"]
[null,5,1,null,{"$f":"COUNTA(D35:D41)","v":0},null,{"$f":"IF(F35=\"\",0,B35 & F35)","v":0}]
[null,null,2,null,null,null,false,null,"C.","INSERT CHANGEOVER TIME, JUDGES & STEWARDS ROSTER FOR EACH RACE"]
[null,null,3,null,null,null,null,null,">","Changeover time In minutes, numbers only, no letters"]
[null,null,4]
[null,null,5,null,null,null,null,null,"D.","CLICK THE \"CALCULATE TIMES\" BUTTON"]
[null,null,6,null,null,null,null,null,">","If you alter the changeover time, start time or length of lunch break (column \"I\"), "]
[null,null,7,null,null,null,null,null,null,"then simply click the \"Calculate times\" button again to recalculate."]
[null,null,null,null,null,5]
[null,6,1,null,{"$f":"COUNTA(D43:D49)","v":0},null,{"$f":"IF(F43=\"\",0,B43 & F43)","v":0},null,"E","Go to the team Details page. "]
[null,null,2,null,null,null,false,null,">","Click the \"GetTeam Details\" button.  A list of teams (alphabetical) is produced"]
[null,null,3,null,null,null,null,null,null,"showing their times, heats and lane. Check these times to make sure there is"]
[null,null,4,null,null,null,null,null,null,"adequate times between races for each team. (You may have to go back and "]
[null,null,5,null,null,null,null,null,null,"readjust the race order)."]
[null,null,6]
[null,null,7,null,null,null,null,null,"You may now copy the running order and paste into another spreadsheet or word document"]
[]
[null,7,1,null,{"$f":"COUNTA(D51:D57)","v":0},null,{"$f":"IF(F51=\"\",0,B51 & F51)","v":0}]
[null,null,2,null,null,null,false]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]

{"sheet":"Running Order","index":2,"n_rows":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"START TIME","RACE","DIV","LEFT","RIGHT","No heats","Judge","Change over time (min)","Stewards\nx 5"]
[null,"09:00:00",1,2,"T-Keilor Laidbacks","Para Gliders",5,"Cat",3,null,null,"DO NOT MERGE CELLS IN THE RUNNING ORDER TABLE"]
[null,"09:09:30.096",2,1,"T-Keilor Gold","Fly'D Over",5,"Cat",3]
[null,"09:19:00.192",3,2,"Para Shooters","T-Keilor Laidbacks",5,"Cat",3,null,null,"IAN K",{"$f":"SUM(N4:S4)","v":152},34,40,24,30,24]
[null,"09:28:30.288",4,1,"Fly'D Over","Para Ball Busters",5,"Cat",3]
[null,"09:38:00.384",5,1,"Para Troopers","T-Keilor Gold",5,"Cat",3,null,null,"IAN G",{"$f":"SUM(N6:S6)","v":152},30,36,26,36,24]
[null,"09:47:30.480",6,2,"Para Gliders","Para Shooters",5,"Cat",3]
[null,"09:57:00.576",7,1,"Para Ball Busters","Para Troopers",5,"Cat",3,null,null,"EMMA",{"$f":"SUM(N8:S8)","v":150},32,36,20,32,30]
[null,"10:06:30.672",8,2,"Para Gliders","T-Keilor Laidbacks",5,"Cat",3]
[null,"10:16:00.768",9,1,"T-Keilor Gold","Para Ball Busters",5,"Cat",3]
[null,"10:25:30.864",10,1,"Para Troopers","Fly'D Over",5,"Cat",3]
[null,"10:35:00.960",10.5,null,"Morning tea","Morning tea",null,null,20]
[null,"10:55:00.960",11,2,"T-Keilor Laidbacks","Para Shooters",5,"Cat",3]
[null,"11:04:31.056",12,1,"Fly'D Over","T-Keilor Gold",5,"Cat",3]
[null,"11:14:01.152",13,2,"Para Shooters","Para Gliders",5,"Cat",3]
[null,"11:23:31.248",14,1,"Para Ball Busters","Fly'D Over",5,"Cat",3]
[null,"11:33:01.344",15,1,"T-Keilor Gold","Para Troopers",5,"Cat",3]
[null,"11:42:31.440",16,2,"T-Keilor Laidbacks","Para Gliders",5,"Cat",3]
[null,"11:52:01.536",17,1,"Para Troopers","Para Ball Busters",5,"Cat",3]
[null,"12:01:31.632",18,2,"Para Shooters","T-Keilor Laidbacks",5,"Cat",3]
[null,"12:11:01.728",19,1,"Para Ball Busters","T-Keilor Gold",5,"Cat",3]
[null,"12:20:31.824",20,1,"Fly'D Over","Para Troopers",5,"Cat",3]
[null,"12:30:01.920",20.5,null,"Lunch","Lunch",null,null,60]
[null,"13:30:01.920",21,2,"Para Gliders","Para Shooters",5,"Cat",3]
[null,"13:39:32.016",22,1,"T-Keilor Gold","Fly'D Over",3,"Cat",3]
[null,"13:47:02.016",23,2,"Para Gliders","T-Keilor Laidbacks",5,"Cat",3]
[null,"13:56:32.112",24,1,"Fly'D Over","Para Ball Busters",3,"Cat",3]
[null,"14:04:02.112",25,1,"Para Troopers","T-Keilor Gold",3,"Cat",3]
[null,"14:11:32.112",26,2,"T-Keilor Laidbacks","Para Shooters",5,"Cat",3]
[null,"14:21:02.208",27,1,"Para Ball Busters","Para Troopers",3,"Cat",3]
[null,"14:28:32.208",28,2,"Para Shooters","Para Gliders",5,"Cat",3]
[null,"14:38:02.304",29,1,"T-Keilor Gold","Para Ball Busters",3,"Cat",3]
[null,"14:45:32.304",30,1,"Para Troopers","Fly'D Over",3,"Cat",3]
[null,"14:53:02.304"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"70 RACES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"20 TEAMS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.5 RACES PER TEAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"HANDLERS","STEWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BALLARAT",13,10.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,"FRANKSTON",13,10.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,"EASTSIDE",10,10.5,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"WONDOGS",13,10.5,11]
[null,null,null,null,null,null,null,null,null,null,null,null,"KEILOR",13,7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,"BELLARINE",7,7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,"WEINERS",7,7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,"BERWICK",6,3.5,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"4PR",6,3.5,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N59:N67)","v":88},{"$f":"SUM(O59:O67)","v":70},70]

{"sheet":"Store","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,1,0,9],[2,2,8,2]]}
[null,"RUNNING ORDER GENERATOR\nWORK PAGE\n\n"]
["DIV","TEAMS IN DIVISION","No. of Teams",{"$f":"COUNTA(B3:B8)","v":3},"rowcount",{"$f":"COUNTA('Running Order'!E1:E206)","v":33},"time formula",{"$f":"H1+IF(M1=3,0.003125,IF(M1=5,0.004515,0))+O1/60/24","v":"00:00:00"}]
[2,"Para Gliders"]
[2,"Para Shooters"]
[2,"T-Keilor Laidbacks"]
[]
[]
[]
[]
[]
["comb Div",{"$f":"IF(A4<A5,A4 &\" & \" & A5,A5 &\" & \" & A4)","v":"2 & 2"}]
["tabname",{"$f":"2 &\" & \"& COUNTA(B5:B9)","v":"2 & 1"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BALLARAT EUREKA DIGGERS"]
[null,"HOT DOGS"]
[null,"SPITFIRES"]
[null,"BERWICK BLITZ"]

{"sheet":"2 & 5","index":4,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":true,"merged":[[6,0,15,0],[17,0,37,0]]}
[null,{"$f":"Store!A4","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0}]
[null,"Combined 2 team division and 4 team division",null,null,null,"TOTAL: 15 RACES","2/3",null,"RIGHT",{"$f":"COUNTIF(J6:J96,\"R\")","v":4},4,5,5,5,5,{"$f":"COUNTIF(P6:P96,\"R\")","v":5}]
[null,null,null,null,null,null,null,null,"LEFT",{"$f":"COUNTIF(J6:J96,\"L\")","v":4},4,5,5,5,5,{"$f":"COUNTIF(P6:P96,\"L\")","v":5}]
[null,null,null,null,null,null,null,null,"No RACES",{"$f":"COUNTA(J6:J96)","v":8},8,10,10,10,10,{"$f":"COUNTA(P6:P96)","v":10}]
[null,"SET","Race","Division","LEFT","RIGHT","HEATS","L","R",1,2,3,4,5,6,7,"TEAM","ROW"]
["double",1,1,{"$f":"Store!$A$4","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,1,2,"L","R"]
["single",1,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$6","v":"00:00:00"},{"$f":"Store!$B$9","v":"00:00:00"},{"$f":"G$2","v":"2/3"},4,7,null,null,null,"L",null,null,"R"]
[null,1,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$7","v":"00:00:00"},{"$f":"Store!$B$8","v":"00:00:00"},{"$f":"G$2","v":"2/3"},5,6,null,null,null,null,"L","R",null,3,5,1]
[null,2,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$9","v":"00:00:00"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},"2/3",7,3,null,null,"R",null,null,null,"L",5,7,3]
[null,2,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$8","v":"00:00:00"},{"$f":"Store!$B$6","v":"00:00:00"},"2/3",6,4,null,null,null,"R",null,"L",null,4,6,2]
[null,3,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$8","v":"00:00:00"},"2/3",3,6,null,null,"L",null,null,"R",null,6,null,4]
[null,3,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$6","v":"00:00:00"},{"$f":"Store!$B$7","v":"00:00:00"},"2/3",4,5,null,null,null,"L","R",null,null,7,null,5]
[null,4,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$7","v":"00:00:00"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},"2/3",5,3,null,null,"R",null,"L"]
[null,4,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$8","v":"00:00:00"},{"$f":"Store!$B$9","v":"00:00:00"},"2/3",6,7,null,null,null,null,null,"L","R"]
[null,5,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":"00:00:00"},"2/3",3,4,null,null,"L","R"]
[null,5,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$9","v":"00:00:00"},{"$f":"Store!$B$7","v":"00:00:00"},"2/3",7,5,null,null,null,null,"R",null,"L"]
["double",3,2,{"$f":"Store!A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},3,2,1,"R","L"]
["SINGLE ROUND ROBIN",6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$8","v":0},3,1,6,"L",null,null,null,null,"R"]
[null,6,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":"00:00:00"},{"$f":"Store!$B$7","v":0},3,7,5,null,null,null,null,"R",null,"L"]
[null,6,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,2,3,null,"L","R"]
[null,7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":"00:00:00"},{"$f":"Store!$B$3","v":"Para Gliders"},3,7,1,"R",null,null,null,null,null,"L"]
[null,7,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,5,2,null,"R",null,null,"L"]
[null,7,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},3,3,4,null,null,"L","R"]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$9","v":"00:00:00"},3,2,7,null,"L",null,null,null,null,"R"]
[null,8,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,6,3,null,null,"R",null,null,"L"]
[null,8,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$7","v":0},3,4,5,null,null,null,"L","R"]
[null,9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,5,1,"R",null,null,null,"L"]
[null,9,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":"00:00:00"},{"$f":"Store!$B$8","v":"00:00:00"},3,4,6,null,null,null,"L",null,"R"]
[null,9,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":"00:00:00"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,7,3,null,null,"R",null,null,null,"L"]
[null,10,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},3,1,4,"L",null,null,"R"]
[null,10,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$7","v":0},3,3,5,null,null,"L",null,"R"]
[null,10,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,6,2,null,"R",null,null,null,"L"]
[null,11,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},3,3,1,"R",null,"L"]
[null,11,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},3,2,4,null,"L",null,"R"]
[null,11,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$9","v":"00:00:00"},3,6,7,null,null,null,null,null,"L","R"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,1,2,"L","R"]
[null,12,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$9","v":"00:00:00"},3,4,7,null,null,null,"L",null,null,"R"]
[null,12,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$8","v":0},3,5,6,null,null,null,null,"L","R"]

{"sheet":"2 & 4","index":5,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[[13,0,27,0],[6,0,11,0]]}
[null,{"$f":"Store!A4","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0}]
[null,"Combined 2 team division and 4 team division",null,null,null,"TOTAL: 15 RACES",null,null,"RIGHT",{"$f":"COUNTIF(J6:J92,\"R\")","v":3},4,4,4,4,4]
[null,null,null,null,null,null,null,null,"LEFT",{"$f":"COUNTIF(J6:J92,\"L\")","v":4},3,4,4,4,4]
[null,null,null,null,null,null,null,null,"No RACES",{"$f":"COUNTA(J6:J92)","v":7},7,8,8,8,8]
[null,"SET","Race","Division","LEFT","RIGHT","HEATS","L","R",1,2,3,4,5,6]
["double",1,1,{"$f":"Store!$A$4","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5,1,2,"L","R"]
["single",1,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$7","v":0},3,6,5,null,null,null,null,"R","L"]
[null,1,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},3,3,4,null,null,"L","R"]
[null,2,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,6,3,null,null,"R",null,null,"L"]
[null,2,2,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$6","v":0},3,5,4,null,null,null,"R","L"]
[null,3,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$7","v":0},3,3,5,null,null,"L",null,"R"]
[null,3,1,{"$f":"Store!$A$5","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$8","v":0},3,4,6,null,null,null,"L",null,"R"]
["double",3,2,{"$f":"Store!A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5,2,1,"R","L"]
["6 TEAM SINGLE",4,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$8","v":"00:00:00"},3,6,1,"L",null,null,null,null,"R"]
[null,4,2,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,5,2,null,"R",null,null,"L"]
[null,4,3,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,4,3,null,null,"R","L"]
[null,5,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$7","v":0},3,1,5,"L",null,null,null,"R"]
[null,5,2,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},3,2,4,null,"L",null,"R"]
[null,5,3,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$8","v":0},3,3,6,null,null,"L",null,null,"R"]
[null,6,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,4,1,"R",null,null,"L"]
[null,6,2,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,6,2,null,"R",null,null,null,"L"]
[null,6,3,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,5,3,null,null,"R",null,"L"]
[null,7,2,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$6","v":0},3,6,4,null,null,null,"R",null,"L"]
[null,7,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},3,3,1,"R",null,"L"]
[null,8,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,2,3,null,"L","R"]
[null,8,2,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$7","v":0},3,4,5,null,null,null,"L","R"]
[null,9,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,1,2,"L","R"]
[null,9,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$8","v":0},3,5,6,null,null,null,null,"L","R"]

{"sheet":"2 & 3","index":6,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":true,"merged":[[10,0,19,0],[6,0,8,0]]}
[]
[null,"2 team division and 3 team division",null,null,null,"TOTAL: 15 RACES",null,null,"RIGHT",{"$f":"COUNTIF(J6:J91,\"R\")","v":3},{"$f":"COUNTIF(K6:K91,\"R\")","v":3},{"$f":"COUNTIF(L6:L91,\"R\")","v":3},{"$f":"COUNTIF(M6:M91,\"R\")","v":3},{"$f":"COUNTIF(N6:N91,\"R\")","v":3}]
[null,null,null,null,null,null,null,null,"LEFT",{"$f":"COUNTIF(J6:J91,\"L\")","v":3},{"$f":"COUNTIF(K6:K91,\"L\")","v":3},{"$f":"COUNTIF(L6:L91,\"L\")","v":3},{"$f":"COUNTIF(M6:M91,\"L\")","v":3},{"$f":"COUNTIF(N6:N91,\"L\")","v":3}]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(J6:J91)","v":6},{"$f":"COUNTA(K6:K91)","v":6},{"$f":"COUNTA(L6:L91)","v":6},{"$f":"COUNTA(M6:M91)","v":6},{"$f":"COUNTA(N6:N91)","v":6}]
[null,"SET","Race","Division","LEFT","RIGHT","HEATS","L","R",1,2,3,4,5]
["double",1,1,{"$f":"Store!A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},3,2,1,"R","L"]
["single",1,1,{"$f":"Store!A$5","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},3,3,4,null,null,"L","R"]
[null,2,1,{"$f":"Store!A$5","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$7","v":0},3,4,5,null,null,null,"L","R"]
[null,3,1,{"$f":"Store!A$5","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,5,3,null,null,"R",null,"L"]
["double",4,1,{"$f":"Store!A$3","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,1,2,"L","R"]
["5 TEAM SINGLE",5,1,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$7","v":0},5,2,5,null,"L",null,null,"R"]
[null,5,2,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,4,3,null,null,"R","L"]
[null,6,1,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},5,3,1,"R",null,"L"]
[null,6,2,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$6","v":0},5,5,4,null,null,null,"R","L"]
[null,7,1,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,5,1,"R",null,null,null,"L"]
[null,7,2,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},5,4,2,null,"R",null,"L"]
[null,8,1,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},5,1,4,"L",null,null,"R"]
[null,8,2,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,2,3,null,"L","R"]
[null,9,1,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5,1,2,"L","R"]
[null,9,2,{"$f":"Store!B$11","v":"2 & 2"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$7","v":0},5,3,5,null,null,"L",null,"R"]

{"sheet":"2 & 2","index":7,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,0,14,0]]}
[]
[null,"Combined 2 team division and 2 team division",null,null,null,"TOTAL: 10 RACES",null,null,"RIGHT",{"$f":"COUNTIF(J6:J96,\"R\")","v":3},{"$f":"COUNTIF(K6:K96,\"R\")","v":2},{"$f":"COUNTIF(L6:L96,\"R\")","v":3},{"$f":"COUNTIF(M6:M96,\"R\")","v":2}]
[null,null,null,null,null,null,null,null,"LEFT",{"$f":"COUNTIF(J6:J96,\"L\")","v":2},{"$f":"COUNTIF(K6:K96,\"L\")","v":3},{"$f":"COUNTIF(L6:L96,\"L\")","v":2},{"$f":"COUNTIF(M6:M96,\"L\")","v":3}]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(J6:J96)","v":5},{"$f":"COUNTA(K6:K96)","v":5},{"$f":"COUNTA(L6:L96)","v":5},{"$f":"COUNTA(M6:M96)","v":5}]
[null,"SET","Race","Division","LEFT","RIGHT","HEATS","L","R",1,2,3,4]
["double 1",1,1,{"$f":"Store!A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5,2,1,"R","L"]
["double 2",2,2,{"$f":"Store!A$5","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},5,3,4,null,null,"L","R"]
["double 1",3,1,{"$f":"Store!A$3","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5,1,2,"L","R"]
["double 2",4,1,{"$f":"Store!A$5","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,4,3,null,null,"R","L"]
["4 TEAM SINGLE",5,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,2,3,null,"L","R"]
[null,6,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,4,1,"R",null,null,"L"]
[null,7,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5,1,2,"R","L"]
[null,8,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},5,3,4,null,null,"L","R"]
[null,9,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,1,3,"L",null,"R"]
[null,9,1,{"$f":"Store!$B$11","v":"2 & 2"},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},5,4,2,null,"R",null,"L"]

{"sheet":"SEVEN","index":8,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":true,"merged":[[5,0,25,0],[26,0,46,0]]}
[null,{"$f":"Store!A3","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0},null,null,"No of heats",null,null,null,null,"6 sets",null,null,null,null,null,null,null,"5 sets"]
[null,null,null,null,null,"First Round robin = ",6,null,null,null,null,"GOOD","4/6",null,null,null,null,null,null,"AFA","1/6"]
[]
[]
[null,"SET","Race","Division","LEFT","RIGHT","heats",null,null,1,2,3,4,5,6,7,null,1,2,3,4,5,6]
["SINGLE ROUND ROBIN",1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$8","v":0},3,1,6,"L",null,null,null,null,"R"]
[null,1,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":0},{"$f":"Store!$B$7","v":0},3,7,5,null,null,null,null,"R",null,"L"]
[null,1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,2,3,null,"L","R"]
[null,2,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,7,1,"R",null,null,null,null,null,"L"]
[null,2,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,5,2,null,"R",null,null,"L"]
[null,2,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},3,3,4,null,null,"L","R"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$9","v":0},3,2,7,null,"L",null,null,null,null,"R"]
[null,3,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,6,3,null,null,"R",null,null,"L"]
[null,3,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$7","v":0},3,4,5,null,null,null,"L","R"]
[null,4,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,5,1,"R",null,null,null,"L"]
[null,4,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$6","v":0},3,6,4,null,null,null,"L",null,"R"]
[null,4,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,7,3,null,null,"R",null,null,null,"L"]
[null,5,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},3,1,4,"L",null,null,"R"]
[null,5,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$7","v":0},3,3,5,null,null,"L",null,"R"]
[null,5,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,6,2,null,"R",null,null,null,"L"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},3,3,1,"R",null,"L"]
[null,6,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},3,2,4,null,"L",null,"R"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$9","v":0},3,6,7,null,null,null,null,null,"L","R"]
[null,7,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,1,2,"L","R"]
[null,7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$9","v":0},3,4,7,null,null,null,"L",null,null,"R"]
[null,7,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$8","v":0},3,5,6,null,null,null,null,"L","R"]
["SECOND ROUND ROBIN",8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,6,1,"L",null,null,null,null,"R"]
[null,8,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$9","v":0},3,5,7,null,null,null,null,"R",null,"L"]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},3,3,2,null,"L","R"]
[null,9,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$9","v":0},3,1,7,"R",null,null,null,null,null,"L"]
[null,9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$7","v":0},3,2,5,null,"R",null,null,"L"]
[null,9,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,4,3,null,null,"L","R"]
[null,10,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,7,2,null,"L",null,null,null,null,"R"]
[null,10,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$8","v":0},3,3,6,null,null,"R",null,null,"L"]
[null,10,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$6","v":0},3,5,4,null,null,null,"L","R"]
[null,11,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$7","v":0},3,1,5,"R",null,null,null,"L"]
[null,11,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$8","v":0},3,4,6,null,null,null,"L",null,"R"]
[null,11,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$9","v":0},3,3,7,null,null,"R",null,null,null,"L"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,4,1,"L",null,null,"R"]
[null,12,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,5,3,null,null,"L",null,"R"]
[null,12,3,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$8","v":0},3,2,6,null,"R",null,null,null,"L"]
[null,13,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,1,3,"R",null,"L"]
[null,13,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,4,2,null,"L",null,"R"]
[null,13,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":0},{"$f":"Store!$B$8","v":0},3,7,6,null,null,null,null,null,"L","R"]
[null,14,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},3,2,1,"L","R"]
[null,14,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$9","v":0},{"$f":"Store!$B$6","v":0},3,7,4,null,null,null,"L",null,null,"R"]
[null,14,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$7","v":0},3,6,5,null,null,null,null,"L","R"]

{"sheet":"SIX","index":9,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":true,"merged":[[5,0,19,0],[20,0,34,0]]}
[null,{"$f":"Store!A3","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0},null,null,"No of heats",null,null,null,null,"6 sets",null,null,null,null,null,null,null,"5 sets"]
[null,null,null,null,null,"First Round robin = ",5,null,null,null,null,"GOOD","4/6",null,null,null,null,null,null,"AFA","1/6"]
[null,null,null,null,null,"Second Round Robin=",3]
[]
[null,"SET","Race","Division","LEFT","RIGHT","heats",null,null,1,2,3,4,5,6,null,null,1,2,3,4,5,6]
["SINGLE ROUND ROBIN",1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$8","v":0},{"$f":"G$2","v":5},1,6,"L",null,null,null,null,"R",2,3,null,"L","R"]
[null,1,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$7","v":0},{"$f":"G$2","v":5},2,5,null,"L",null,null,"R",null,6,1,"R",null,null,null,null,"L"]
[null,1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},5,3,4,null,null,"L","R",null,null,4,5,null,null,null,"L","R"]
[null,2,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,5,1,"R",null,null,null,"L",null,3,6,null,null,"L",null,null,"R"]
[null,2,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},5,4,2,null,"R",null,"L",null,null,4,2,null,"R",null,"L"]
[null,2,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,6,3,null,null,"R",null,null,"L",5,1,"R",null,null,null,"L"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},5,1,4,"L",null,null,"R",null,null,2,6,null,"L",null,null,null,"R"]
[null,3,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$8","v":0},5,2,6,null,"L",null,null,null,"R",1,4,"L",null,null,"R"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$7","v":0},5,3,5,null,null,"L",null,"R",null,5,3,null,null,"R",null,"L"]
[null,4,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$8","v":0},5,4,6,null,null,null,"L",null,"R",6,4,null,null,null,"R",null,"L"]
[null,4,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,1,3,"L",null,"R",null,null,null,2,5,null,"L",null,null,"R"]
[null,5,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},5,3,2,null,"R","L",null,null,null,3,1,"R",null,"L"]
[null,5,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$6","v":0},5,5,4,null,null,null,"R","L",null,5,6,null,null,null,null,"L","R"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5,2,1,"R","L",null,null,null,null,4,3,null,null,"R","L"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$7","v":0},5,6,5,null,null,null,null,"R","L",1,2,"L","R"]
["DOUBLE ROUND ROBIN",7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"G$3","v":3},6,1,"R",null,null,null,null,"L"]
[null,7,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$3","v":3},5,2,null,"R",null,null,"L"]
[null,7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,4,3,null,null,"R","L"]
[null,8,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$7","v":0},3,1,5,"L",null,null,null,"R"]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},3,2,4,null,"L",null,"R"]
[null,8,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$8","v":0},3,3,6,null,null,"L",null,null,"R"]
[null,9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,4,1,"R",null,null,"L"]
[null,9,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,6,2,null,"R",null,null,null,"L",2,3,null,"L","R"]
[null,9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,5,3,null,null,"R",null,"L",null,6,1,"R",null,null,null,null,"L"]
[null,10,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$8","v":0},{"$f":"Store!$B$6","v":0},3,6,4,null,null,null,"R",null,"L",4,5,null,null,null,"L","R"]
[null,10,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},3,3,1,"R",null,"L",null,null,null,3,6,null,null,"L",null,null,"R"]
[null,11,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,2,3,null,"L","R",null,null,null,4,2,null,"R",null,"L"]
[null,11,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$7","v":0},3,4,5,null,null,null,"L","R",null,5,1,"R",null,null,null,"L"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,1,2,"L","R",null,null,null,null,2,6,null,"L",null,null,null,"R"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$8","v":0},3,5,6,null,null,null,null,"L","R",1,4,"L",null,null,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,3,null,null,"R",null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,4,null,null,null,"R",null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,5,null,"L",null,null,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,"R",null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,null,null,null,null,"L","R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3,null,null,"R","L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,"L","R"]

{"sheet":"FIVE","index":10,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":true,"merged":[[5,0,14,0],[15,0,24,0]]}
[null,{"$f":"Store!A3","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0},null,null,"No of heats",null,null,null,null,6,null,null,null,null,null,null,5]
[null,null,null,null,null,"First Round robin = ",5]
[null,null,null,null,null,"Second Round robin = ",5,null,null,null,null,null,null,null,null,null,null,null,"AFA"]
[]
[null,"SET","Race","Division","LEFT","RIGHT","heats","L","R",1,2,3,4,5,null,null,1,2,3,4,5]
["SINGLE ROUND ROBIN",1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$7","v":0},{"$f":"G$2","v":5},2,5,null,"L",null,null,"R",5,2,null,"R",null,null,"L"]
[null,2,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},{"$f":"G$2","v":5},3,4,null,null,"L","R",null,4,1,"R",null,null,"L"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,5,1,"R",null,null,null,"L",3,5,null,null,"L",null,"R"]
[null,3,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},5,4,2,null,"R",null,"L",null,2,4,null,"L",null,"R"]
[null,4,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},5,1,4,"L",null,null,"R",null,1,3,"L",null,"R"]
[null,4,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,2,3,null,"L","R",null,null,4,5,null,null,null,"L","R"]
[null,5,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},5,3,1,"R",null,"L",null,null,2,3,null,"L","R"]
[null,5,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$7","v":0},5,4,5,null,null,null,"L","R",5,1,"R",null,null,null,"L"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5,1,2,"L","R",null,null,null,3,4,null,null,"L","R"]
[null,6,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,5,3,null,null,"R",null,"L",1,2,"L","R"]
["DOUBLE ROUND ROBIN",7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$3","v":5},5,2,null,"R",null,null,"L"]
[null,7,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"G$3","v":5},4,3,null,null,"R","L"]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$7","v":0},5,1,5,"L",null,null,null,"R"]
[null,8,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},5,2,4,null,"L",null,"R",null,null,null,null,null,null,"ONLY 2 OUT OF THE 5 TEAMS HAVE \"PERFECT\" ALTERNATIONS"]
[null,9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,4,1,"R",null,null,"L"]
[null,9,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},5,3,2,null,"R","L"]
[null,10,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,1,3,"L",null,"R"]
[null,10,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$7","v":0},{"$f":"Store!$B$6","v":0},5,5,4,null,null,null,"R","L"]
[null,11,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5,2,1,"R","L"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$7","v":0},5,3,5,null,null,"L",null,"R"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"5 OUT OF THE 5 TEAMS HAVE \"PERFECT\" ALTERNATIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"5 sets"]

{"sheet":"FOUR","index":11,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":true,"merged":[[5,0,10,0],[11,0,16,0],[26,0,31,0],[32,0,37,0],[17,0,22,0]]}
[null,{"$f":"Store!A3","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0},null,null,"No of heats",null,"4 SETS PER DRAW",null,null,"each team: 3 races per ROUND ROBIN"]
[null,null,null,null,null,"First Round robin = ",5,null,"1 & 2 RACES PER SET",null,null,null,4,null,null,null,null,null,3]
[null,null,null,null,null,"Second Round robin = ",3,null,null,null,null,null,null,null,null,null,null,null,"AFA"]
[]
[null,"SET","Race","Division","LEFT","RIGHT","heats",null,"L","R",1,2,3,4,null,null,null,1,2,3,4,5]
["SINGLE ROUND ROBIN",1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$2","v":5},null,1,2,"L","R",null,null,null,4,1,"R",null,null,"L"]
[null,2,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,null,2,3,null,"L","R",null,null,2,3,null,"L","R"]
[null,2,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,null,4,1,"R",null,null,"L",null,1,3,"L",null,"R"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},5,null,3,4,null,null,"L","R",null,4,2,null,"R",null,"L"]
[null,4,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,null,1,3,"L",null,"R",null,null,3,4,null,null,"L","R"]
[null,4,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},5,null,4,2,null,"R",null,"L",null,1,2,"L","R"]
["DOUBLE ROUND ROBIN",5,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5,null,2,1,"R","L"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},5,null,3,2,null,"R","L",null,null,null,null,null,null,"NO TEAMS HAVE \"PERFECT\" ALTERNATIONS"]
[null,6,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},5,null,1,4,"L",null,null,"R"]
[null,7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,null,4,3,null,null,"R","L",null,null,null,null,3]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},5,null,3,1,"R",null,"L"]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},5,null,2,4,null,"L",null,"R"]
["TRIPLE ROUND ROBIN",9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},3,null,1,2,"L","R"]
[null,10,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,null,2,3,null,"L","R"]
[null,10,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},3,null,4,1,"R",null,null,"L"]
[null,11,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},3,null,3,4,null,null,"L","R"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,null,1,3,"L",null,"R"]
[null,12,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},3,null,4,2,null,"R",null,"L"]
[]
[null,null,null,null,"if no 5 team division, use this  order"]
[null,"SET","Race","Division","LEFT","RIGHT","heats",null,"L","R",1,2,3,4]
["SINGLE ROUND ROBIN",1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"G$2","v":5},null,1,3,"L",null,"R"]
[null,1,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$4","v":"Para Shooters"},5,null,4,2,null,"R",null,"L",null,1,3,"L",null,"R"]
[null,2,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$3","v":"Para Gliders"},5,null,4,1,"R",null,null,"L",null,4,2,null,"R",null,"L"]
[null,2,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},5,null,2,3,null,"L","R",null,null,4,1,"R",null,null,"L"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$6","v":0},5,null,3,4,null,null,"L","R",null,2,3,null,"L","R"]
[null,3,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5,null,1,2,"L","R",null,null,null,3,4,null,null,"L","R"]
["DOUBLE ROUND ROBIN",4,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"G$3","v":3},null,3,1,"R",null,"L",null,null,1,2,"L","R"]
[null,4,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$6","v":0},3,null,2,4,null,"L",null,"R"]
[null,5,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$6","v":0},3,null,1,4,"L",null,null,"R"]
[null,5,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},3,null,3,2,null,"R","L"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$6","v":0},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},3,null,4,3,null,null,"R","L"]
[null,6,2,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},3,null,2,1,"R","L"]

{"sheet":"THREE","index":12,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[8,0,10,0],[11,0,13,0],[5,0,7,0],[14,0,16,0]]}
["3 ROUNDS PER DRAW",{"$f":"Store!A3","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0},null,null,"No of heats"]
["1 RACE PER ROUND",null,null,null,null,"First Round robin = ",5]
["TRIPLE ROUND ROBIN",null,null,null,null,"Second Round robin = ",5,null,null,null,"AFA"]
[null,null,null,null,"Third Round robin = ","Third Round robin = ",5]
[null,"SET","Race","Division","LEFT","RIGHT","heats","L","R",1,2,3]
["SINGLE ROUND ROBIN",1,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"G$2","v":5},3,1,"R",null,"L"]
[null,2,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"G$2","v":5},2,3,null,"L","R"]
[null,3,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$2","v":5},1,2,"L","R",null,"X"]
["DOUBLE ROUND ROBIN",4,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"G$3","v":5},1,3,"L",null,"R"]
[null,5,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$3","v":5},3,2,null,"R","L"]
[null,6,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"G$3","v":5},2,1,"R","L",null,null,null,40]
["TRIPLE ROUND ROBIN",7,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"G$4","v":5},3,1,"R",null,"L",null,null,18]
[null,8,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"G$4","v":5},2,3,null,"L","R","X"]
[null,9,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$4","v":5},1,2,"L","R"]
["QUAD ROUND ROBIN",10,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"G$3","v":5},1,3,"L",null,"R"]
[null,11,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$5","v":"T-Keilor Laidbacks"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$3","v":5},3,2,null,"R","L"]
[null,12,1,{"$f":"IF($D$1=0,$B$1,Store!$B$11)","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"G$3","v":5},2,1,"R","L"]
[]
[null,null,null,null,null,null,null,null,"2&2 comb"]
[null,null,null,null,null,null,null,null,"2&4 comb",null,3]
[null,null,null,null,null,null,null,null,"2&3 comb"]
[null,null,null,null,null,"No teams",5,"4,6","4, 3, 6"]
[null,null,null,null,null,"sets",10,8,9]
[null,null,null,null,null,null,1,null,1]
[null,null,null,null,null,null,2,2,2]
[null,null,null,null,null,null,3,3,3]
[null,null,null,null,null,null,4,4,4]
[null,null,null,null,null,null,5,5,5]
[null,null,null,null,null,null,6,6,6]
[null,null,null,null,null,null,7,7,7]
[null,null,null,null,null,null,8,8,8]
[null,null,null,null,null,null,9,9,9]
[null,null,null,null,null,null,10]

{"sheet":"TWO","index":13,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["3 ROUNDS PER DRAW",{"$f":"Store!A3","v":2},{"$f":"Store!A5","v":2},{"$f":"B1-C1","v":0},null,null,"No of heats"]
["1 RACE PER ROUND",null,null,null,null,null,5]
["TRIPLE ROUND ROBIN",null,null,null,null,null,null,null,null,null,"AFA"]
[]
[null,"SET","Race","Division","LEFT","RIGHT","heats","L","R",1,2,3]
["one",1,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"G$2","v":5},1,2,"R",null,"L"]
["two",2,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5]
["three",3,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5]
["four",5,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5]
["five",7,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5]
["six",9,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$4","v":"Para Shooters"},{"$f":"Store!$B$3","v":"Para Gliders"},5,"All Teams have perfect alternations"]
["seven",11,1,{"$f":"Store!$A$3","v":2},{"$f":"Store!$B$3","v":"Para Gliders"},{"$f":"Store!$B$4","v":"Para Shooters"},5]
["eight",12,1,{"$f":"Store!$B$4","v":"Para Shooters"},2,1,5]

{"sheet":"TeamDetails","index":14,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Time since start of last race      (hr : min)","Scheduled race start time","RACE","DIV","TEAM","No heats","Lane"]
[null,"09:09:30.096",2,1,"Fly'D Over",5,"R"]
["00:19:00.192","09:28:30.288",4,1,"Fly'D Over",5,"L"]
["00:57:00.576","10:25:30.864",10,1,"Fly'D Over",5,"R"]
["00:39:00.192","11:04:31.056",12,1,"Fly'D Over",5,"L"]
["00:19:00.192","11:23:31.248",14,1,"Fly'D Over",5,"R"]
["00:57:00.576","12:20:31.824",20,1,"Fly'D Over",5,"L",null,null,"Time is the time from the start of a teams previous race,"]
["01:19:00.192","13:39:32.016",22,1,"Fly'D Over",3,"R",null,null,"Hence must deduct about 10 minutes to get the time from the end of the last race."]
["00:17:00.096","13:56:32.112",24,1,"Fly'D Over",3,"L"]
["00:49:00.192","14:45:32.304",30,1,"Fly'D Over",3,"R"]
[null,"12:30:01.920",20.5,null,"Lunch",null,"L"]
["00:00:00","12:30:01.920",20.5,null,"Lunch",null,"R"]
[null,"10:35:00.960",10.5,null,"Morning tea",null,"L"]
["00:00:00","10:35:00.960",10.5,null,"Morning tea",null,"R"]
[null,"09:28:30.288",4,1,"Para Ball Busters",5,"R"]
["00:28:30.288","09:57:00.576",7,1,"Para Ball Busters",5,"L"]
["00:19:00.192","10:16:00.768",9,1,"Para Ball Busters",5,"R"]
["01:07:30.480","11:23:31.248",14,1,"Para Ball Busters",5,"L"]
["00:28:30.288","11:52:01.536",17,1,"Para Ball Busters",5,"R"]
["00:19:00.192","12:11:01.728",19,1,"Para Ball Busters",5,"L"]
["01:45:30.384","13:56:32.112",24,1,"Para Ball Busters",3,"R"]
["00:24:30.096","14:21:02.208",27,1,"Para Ball Busters",3,"L"]
["00:17:00.096","14:38:02.304",29,1,"Para Ball Busters",3,"R"]
[null,"09:00:00",1,2,"Para Gliders",5,"R"]
["00:47:30.480","09:47:30.480",6,2,"Para Gliders",5,"L"]
["00:19:00.192","10:06:30.672",8,2,"Para Gliders",5,"L"]
["01:07:30.480","11:14:01.152",13,2,"Para Gliders",5,"R"]
["00:28:30.288","11:42:31.440",16,2,"Para Gliders",5,"R"]
["01:47:30.480","13:30:01.920",21,2,"Para Gliders",5,"L"]
["00:17:00.096","13:47:02.016",23,2,"Para Gliders",5,"L"]
["00:41:30.192","14:28:32.208",28,2,"Para Gliders",5,"R"]
[null,"09:19:00.192",3,2,"Para Shooters",5,"L"]
["00:28:30.288","09:47:30.480",6,2,"Para Shooters",5,"R"]
["01:07:30.480","10:55:00.960",11,2,"Para Shooters",5,"R"]
["00:19:00.192","11:14:01.152",13,2,"Para Shooters",5,"L"]
["00:47:30.480","12:01:31.632",18,2,"Para Shooters",5,"L"]
["01:28:30.288","13:30:01.920",21,2,"Para Shooters",5,"R"]
["00:41:30.192","14:11:32.112",26,2,"Para Shooters",5,"R"]
["00:17:00.096","14:28:32.208",28,2,"Para Shooters",5,"L"]
[null,"09:38:00.384",5,1,"Para Troopers",5,"L"]
["00:19:00.192","09:57:00.576",7,1,"Para Troopers",5,"R"]
["00:28:30.288","10:25:30.864",10,1,"Para Troopers",5,"L"]
["01:07:30.480","11:33:01.344",15,1,"Para Troopers",5,"R"]
["00:19:00.192","11:52:01.536",17,1,"Para Troopers",5,"L"]
["00:28:30.288","12:20:31.824",20,1,"Para Troopers",5,"R"]
["01:43:30.288","14:04:02.112",25,1,"Para Troopers",3,"L"]
["00:17:00.096","14:21:02.208",27,1,"Para Troopers",3,"R"]
["00:24:30.096","14:45:32.304",30,1,"Para Troopers",3,"L"]
[null,"09:09:30.096",2,1,"T-Keilor Gold",5,"L"]
["00:28:30.288","09:38:00.384",5,1,"T-Keilor Gold",5,"R"]
["00:38:00.384","10:16:00.768",9,1,"T-Keilor Gold",5,"L"]
["00:48:30.288","11:04:31.056",12,1,"T-Keilor Gold",5,"R"]
["00:28:30.288","11:33:01.344",15,1,"T-Keilor Gold",5,"L"]
["00:38:00.384","12:11:01.728",19,1,"T-Keilor Gold",5,"R"]
["01:28:30.288","13:39:32.016",22,1,"T-Keilor Gold",3,"L"]
["00:24:30.096","14:04:02.112",25,1,"T-Keilor Gold",3,"R"]
["00:34:00.192","14:38:02.304",29,1,"T-Keilor Gold",3,"L"]
[null,"09:00:00",1,2,"T-Keilor Laidbacks",5,"L"]
["00:19:00.192","09:19:00.192",3,2,"T-Keilor Laidbacks",5,"R"]
["00:47:30.480","10:06:30.672",8,2,"T-Keilor Laidbacks",5,"R"]
["00:48:30.288","10:55:00.960",11,2,"T-Keilor Laidbacks",5,"L"]
["00:47:30.480","11:42:31.440",16,2,"T-Keilor Laidbacks",5,"L"]
["00:19:00.192","12:01:31.632",18,2,"T-Keilor Laidbacks",5,"R"]
["01:45:30.384","13:47:02.016",23,2,"T-Keilor Laidbacks",5,"R"]
["00:24:30.096","14:11:32.112",26,2,"T-Keilor Laidbacks",5,"L"]