{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TR2 Running Order"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":26,"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":"TR2 Running Order","index":0,"n_rows":58,"n_cols":102,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,18,0,19],[1,11,1,16],[1,26,1,30],[0,21,0,22]]}
["Race #","Division","Left Lane","Right Lane","Format",null,null,null,null,null,null,null,null,null,null,null,null,null,"Races per lane",null,null,"Gaps"]
[1,"Div 1","Unleashed Power","Norwest Thunderdogs 5",{"$f":"LOOKUP(B2,$G$2:$G$7,$H$2:$H$7)","v":"Handicap"},null,"Div 1","Handicap",null,"DIVISION","TEAM","RACE NUMBERS",null,null,null,null,null,null,"Left","Right",null,"Mininum","Maximum",null,"Average","From Start","From Previous",null,null,null,null,null,"# less than 5","# greater than 4"]
[2,"Div 2","City Slickers","Rocky Hill Racers","Regular",null,"Div 2","Regular",null,"Div 1","Norwest Thunderdogs 5",1,16,23,36,42,54,null,{"$f":"COUNTIF(C:C,K3)","v":3},{"$f":"COUNTIF(D:D,K3)","v":3},null,{"$f":"MIN((AA3:AE3))","v":5},{"$f":"MAX(AA3:AE3)","v":14},null,{"$f":"AVERAGE(Z3:AE3)","v":8},{"$f":"L3-1","v":0},{"$f":"(M3-L3)-1","v":14},6,12,5,11,null,{"$f":"+COUNTIF(Z3:AE3,\"<5\")","v":1},{"$f":"COUNTIF(Z3:AE3,\">4\")","v":5}]
[3,"Div 3","Shooting Stars","DragonSlayers","Regular",null,"Div 3","Regular",null,"Div 1","Unleashed Power",1,7,16,31,42,48,null,3,3,null,{"$f":"MIN((AA4:AE4))","v":5},{"$f":"MAX(AA4:AE4)","v":14},null,{"$f":"AVERAGE(Z4:AE4)","v":7},0,5,8,14,10,5,null,{"$f":"+COUNTIF(Z4:AE4,\"<5\")","v":1},{"$f":"COUNTIF(Z4:AE4,\">4\")","v":5}]
[4,"Open 1","Thunderdog Stormchasers","X-posed","Handicap",null,"Div 4","Handicap",null,"Div 1","Tidal Wave",7,23,31,37,48,54,null,3,3,null,5,15,null,8,6,15,7,5,10,5,null,0,6]
[5,"Open 1","MAD Flyers","Zoomies","Handicap",null,"Open 1","Handicap",null,"Div 2","Unleashed Speed",10,24,33,38,45,56,null,3,3,null,4,13,null,8.3333333333333339,9,13,8,4,6,10,null,1,5]
[6,"Open 2","Crate Escapers","Ruff and Ready","Handicap",null,"Open 2","Handicap",null,"Div 2","Rocky Hill Racers",2,10,17,33,45,51,null,3,3,null,5,15,null,7.5,1,7,6,15,11,5,null,1,5]
[7,"Div 1","Unleashed Power","Tidal Wave","Handicap",null,null,null,null,"Div 2","City Slickers",2,17,24,38,51,56,null,3,3,null,4,14,null,8.3333333333333339,1,14,6,13,12,4,null,2,4]
[8,"Open 2","New Wave","The Panzers","Handicap",null,null,null,null,"Div 3","Norwest Thunderdogs 7",9,25,32,39,50,57,null,3,3,null,6,15,null,8.5,8,15,6,6,10,6,null,0,6]
[9,"Div 3","Norwest Thunderdogs 7","DragonSlayers",{"$f":"LOOKUP(B11,$G$2:$G$7,$H$2:$H$7)","v":"Regular"},null,null,null,null,"Div 3","DragonSlayers",3,9,18,32,44,50,null,3,3,null,5,13,null,7.333333333333333,2,5,8,13,11,5,null,1,5]
[10,"Div 2","Unleashed Speed","Rocky Hill Racers",{"$f":"LOOKUP(B10,$G$2:$G$7,$H$2:$H$7)","v":"Regular"},null,null,null,null,"Div 3","Shooting Stars",3,18,25,39,44,57,null,3,3,null,4,14,null,8.5,2,14,6,13,4,12,null,2,4]
[11,"Open 1","Zoomies","X-posed",{"$f":"LOOKUP(B12,$G$2:$G$7,$H$2:$H$7)","v":"Handicap"},null,null,null,null,"Div 4","Widdle Woofers",15,26,37,43,49,55,null,3,3,null,5,10,null,8.1666666666666661,14,10,10,5,5,5,null,0,6]
[12,"Open 1","Thunderdog Stormchasers","MAD Flyers","Handicap",null,null,null,null,"Div 4","Spud Dogs",15,26,37,43,49,55,null,3,3,null,5,10,null,8.1666666666666661,14,10,10,5,5,5,null,0,6,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,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,null,null,null,null,null,"Magic","542D",null,"Karen Shields","Koolie  "]
[13,"Open 2","Ruff and Ready","New Wave","Handicap",null,null,null,null,"Open 1","Thunderdog Stormchasers",4,12,20,28,41,47,null,3,3,null,5,12,null,6.833333333333333,3,7,7,7,12,5,null,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,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,null,null,null,null,null,null,null,null,"Cookie","535D",9,"Brian Lindsay","Koolie x "]
[14,"Open 2","The Panzers","Crate Escapers","Handicap",null,null,null,null,"Open 1","X-posed",4,11,19,28,34,53,null,3,3,null,5,18,null,7.833333333333333,3,6,7,8,5,18,null,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,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,null,null,null,null,null,null,null,null,"Bandit","531D","Null","Lydia Markham","Whippet     "]
[15,"Div 4","Widdle Woofers","Spud Dogs","Handicap",null,null,null,null,"Open 1","MAD Flyers",5,12,19,28,41,53,null,3,3,null,6,12,null,7.833333333333333,4,6,6,8,12,11,null,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,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,null,null,null,null,null,null,null,null,"Dash","660D","Null","Jessica Mellon","Border Collie     "]
[16,"Div 1","Norwest Thunderdogs 5","Unleashed Power","Handicap",null,null,null,null,"Open 1","Zoomies",5,11,20,27,34,47,null,3,3,null,{"$f":"MIN((Z17:AE17))","v":4},12,null,6.833333333333333,4,5,8,6,6,12,null,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,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,null,null,null,null,null,null,null,null,"Layla","3115A",null,"Emma Milharcic","Border Collie"]
[17,"Div 2","Rocky Hill Racers","City Slickers","Regular",null,null,null,null,"Open 2","Crate Escapers",6,14,21,30,35,52,null,3,3,null,{"$f":"MIN((Z18:AE18))","v":4},16,null,7.666666666666667,5,7,6,8,4,16,null,1,5]
[18,"Div 3","DragonSlayers","Shooting Stars","Regular",null,null,null,null,"Open 2","New Wave",8,13,21,29,46,52,null,3,3,null,4,16,null,7.666666666666667,7,4,7,7,16,5,null,1,5]
[19,"Open 1","X-posed","MAD Flyers","Handicap",null,null,null,null,"Open 2","The Panzers",8,14,22,29,35,40,null,3,3,null,4,7,null,5.666666666666667,7,5,7,6,5,4,null,1,5]
[20,"Open 1","Zoomies","Thunderdog Stormchasers","Handicap",null,null,null,null,"Open 2","Ruff and Ready",6,13,22,30,40,46,null,3,3,null,{"$f":"MIN((AA21:AE21))","v":5},{"$f":"MAX(AA21:AE21)","v":9},null,{"$f":"AVERAGE(Z21:AE21)","v":6.666666666666667},{"$f":"L21-1","v":5},{"$f":"(M21-L21)-1","v":6},{"$f":"(N21-M21)-1","v":8},{"$f":"(O21-N21)-1","v":7},{"$f":"(P21-O21)-1","v":9},{"$f":"(Q21-P21)-1","v":5},null,{"$f":"+COUNTIF(Z21:AE21,\"<5\")","v":0},{"$f":"COUNTIF(Z21:AE21,\">4\")","v":6}]
[21,"Open 2","Crate Escapers","New Wave","Handicap"]
[22,"Open 2","The Panzers","Ruff and Ready","Handicap"]
[23,"Div 1","Tidal Wave","Norwest Thunderdogs 5","Handicap"]
[24,"Div 2","City Slickers","Unleashed Speed","Regular"]
[25,"Div 3","Shooting Stars","Norwest Thunderdogs 7","Regular"]
[26,"Div 4","Spud Dogs","Widdle Woofers","Handicap"]
[27,"Open 1","Zoomies","MAD Flyers","Handicap"]
[28,"Open 1","X-posed","Thunderdog Stormchasers","Handicap"]
[29,"Open 2","The Panzers","New Wave","Handicap"]
[30,"Open 2","Ruff and Ready","Crate Escapers","Handicap"]
[31,"Div 1","Tidal Wave","Unleashed Power","Handicap"]
[32,"Div 3","DragonSlayers","Norwest Thunderdogs 7","Regular"]
[33,"Div 2","Rocky Hill Racers","Unleashed Speed","Regular"]
[34,"Open 1","X-posed","Zoomies","Handicap"]
[35,"Open 2","Crate Escapers","The Panzers","Handicap"]
[36,"Div 1","Norwest Thunderdogs 5","Tidal Wave","Handicap"]
[37,"Div 4","Widdle Woofers","Spud Dogs","Handicap"]
[38,"Div 2","Unleashed Speed","City Slickers","Regular"]
[39,"Div 3","Norwest Thunderdogs 7","Shooting Stars","Regular"]
[40,"Open 2","Ruff and Ready","The Panzers","Handicap"]
[41,"Open 1","MAD Flyers","Thunderdog Stormchasers","Handicap"]
[42,"Div 1","Norwest Thunderdogs 5","Unleashed Power","Handicap"]
[43,"Div 4","Spud Dogs","Widdle Woofers","Handicap"]
[44,"Div 3","DragonSlayers","Shooting Stars","Regular"]
[45,"Div 2","Unleashed Speed","Rocky Hill Racers","Regular"]
[46,"Open 2","New Wave","Ruff and Ready","Handicap"]
[47,"Open 1","Thunderdog Stormchasers","Zoomies","Handicap"]
[48,"Div 1","Unleashed Power","Tidal Wave","Handicap"]
[49,"Div 4","Widdle Woofers","Spud Dogs","Handicap"]
[50,"Div 3","Norwest Thunderdogs 7","DragonSlayers","Regular"]
[51,"Div 2","Rocky Hill Racers","City Slickers","Regular"]
[52,"Open 2","New Wave","Crate Escapers","Handicap"]
[53,"Open 1","MAD Flyers","X-posed","Handicap"]
[54,"Div 1","Tidal Wave","Norwest Thunderdogs 5","Handicap"]
[55,"Div 4","Spud Dogs","Widdle Woofers","Handicap"]
[56,"Div 2","City Slickers","Unleashed Speed","Regular"]
[57,"Div 3","Shooting Stars","Norwest Thunderdogs 7","Regular"]