{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sh1(bw) ","Flights Sheet","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Sh1(bw) ","index":0,"n_rows":245,"n_cols":40,"rows_kept":245,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"The Spreadsheet is set for 3 Win Pts."]
[]
[null,null,null,"               2019 SCD Mens Pairs"]
[]
[]
[null,null,null,null,"Game # 1",null,null,null,"Game # 2",null,null,null,"Game # 3",null,null,null,"Game # 4",null,null,null,null,"EVENT SUMMARY           "]
[null,"Team",null,"   Points",null,"Win","Plus","   Points",null,"Win","Plus","   Points",null,"Win","Plus","   Points",null,"Win","Plus","Points",null,"Win","Plus","PW",null,null,"Game # 1",null,null,null,"Game # 2",null,null,null,"Game # 3",null,null,null,"Game # 4"]
[null,"#","       SKIP","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","PW+PL","POS"]
[1,null,null,null,null,{"$f":"IF((D11+E11)<1,0,IF(D11>E11,3,IF(D11=E11,1,0)))","v":0},{"$f":"IF(D11>(E11+7),7,IF((D11+7)<E11,-7,D11-E11))","v":0},null,null,{"$f":"IF((H11+I11)<1,0,IF(H11>I11,3,IF(H11=I11,1,0)))","v":0},{"$f":"IF(H11>(I11+7),7,IF((H11+7)<I11,-7,H11-I11))","v":0},null,null,{"$f":"IF((L11+M11)<1,0,IF(L11>M11,3,IF(L11=M11,1,0)))","v":0},{"$f":"IF(L11>(M11+7),7,IF((L11+7)<M11,-7,L11-M11))","v":0},null,null,{"$f":"IF((P11+Q11)<1,0,IF(P11>Q11,3,IF(P11=Q11,1,0)))","v":0},{"$f":"IF(P11>(Q11+7),7,IF((P11+7)<Q11,-7,P11-Q11))","v":0},{"$f":"+D11+H11+L11+P11","v":0},{"$f":"+E11+I11+M11+Q11","v":0},{"$f":"+F11+J11+N11+R11+Z11","v":-1},{"$f":"G11+K11+O11+S11","v":0},{"$f":"IF((T11+U11)<1,0,+T11/(T11+U11))","v":0},1,{"$f":"IF((X11)<0.01,-1,0)","v":-1},{"$f":"+IF((D11<E11),FALSE,D11-IF((D11=E11),D11/2))","v":0},{"$f":"IF((E11>D11),FALSE,E11)-IF((D11=E11),E11/2,0)","v":0},null,null,{"$f":"+IF((H11<I11),FALSE,H11-IF((H11=I11),H11/2))","v":0},{"$f":"IF((I11>H11),FALSE,I11)-IF((H11=I11),I11/2,0)","v":0},null,null,{"$f":"+IF((L11<M11),FALSE,L11-IF((L11=M11),L11/2))","v":0},{"$f":"IF((M11>L11),FALSE,M11)-IF((L11=M11),M11/2,0)","v":0},null,null,{"$f":"+IF((P11<Q11),FALSE,P11-IF((P11=Q11),P11/2))","v":0},{"$f":"IF((Q11>P11),FALSE,Q11)-IF((P11=Q11),Q11/2,0)","v":0}]
[2,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,2,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[3,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,3,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[4,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,4,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[5,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,5,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[6,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,6,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[7,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,7,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[8,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,8,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[9,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,9,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[10,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,10,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[11,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,11,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[12,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,12,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[13,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,13,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[14,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,14,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[15,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,15,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[16,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,16,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[17,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,17,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[18,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,18,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[19,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,19,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[20,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,20,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[21,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,21,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[22,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,22,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[23,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,23,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[24,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,24,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[25,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,25,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[26,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,26,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[27,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,27,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[28,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,28,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[29,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,29,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[30,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,30,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[31,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,31,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[32,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,32,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[33,null,null,null,null,{"$f":"IF((D43+E43)<1,0,IF(D43>E43,3,IF(D43=E43,1,0)))","v":0},{"$f":"IF(D43>(E43+7),7,IF((D43+7)<E43,-7,D43-E43))","v":0},null,null,{"$f":"IF((H43+I43)<1,0,IF(H43>I43,3,IF(H43=I43,1,0)))","v":0},{"$f":"IF(H43>(I43+7),7,IF((H43+7)<I43,-7,H43-I43))","v":0},null,null,{"$f":"IF((L43+M43)<1,0,IF(L43>M43,3,IF(L43=M43,1,0)))","v":0},{"$f":"IF(L43>(M43+7),7,IF((L43+7)<M43,-7,L43-M43))","v":0},null,null,{"$f":"IF((P43+Q43)<1,0,IF(P43>Q43,3,IF(P43=Q43,1,0)))","v":0},{"$f":"IF(P43>(Q43+7),7,IF((P43+7)<Q43,-7,P43-Q43))","v":0},{"$f":"+D43+H43+L43+P43","v":0},{"$f":"+E43+I43+M43+Q43","v":0},{"$f":"+F43+J43+N43+R43+Z43","v":-1},{"$f":"G43+K43+O43+S43","v":0},{"$f":"IF((T43+U43)<1,0,+T43/(T43+U43))","v":0},33,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[34,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,34,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[35,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,35,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[36,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,36,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[37,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,37,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[38,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,38,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[39,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,39,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[40,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,40,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[41,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,41,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[42,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,42,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[43,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,43,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[44,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,44,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[45,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,45,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[46,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,46,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[47,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,47,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[48,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,48,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[49,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,49,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[50,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,50,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[51,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,51,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[52,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,52,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[53,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,53,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[54,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,54,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[55,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,55,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[56,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,56,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[57,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,57,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[58,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,58,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[59,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,59,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[60,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,60,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[61,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,61,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[62,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,62,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[63,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,63,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[64,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,64,{"$f":"IF((X74)<0.01,-1,0)","v":-1},0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["a white # in any box in this row indicates an error",null,null,null,null,null,{"$f":"SUM(D11:D74)-SUM(E11:E74)","v":0},null,null,null,{"$f":"SUM(H11:H74)-SUM(I11:I74)","v":0},null,null,null,{"$f":"SUM(L11:L74)-SUM(M11:M74)","v":0},null,null,null,{"$f":"SUM(P11:P74)-SUM(Q11:Q74)","v":0}]
["OR  A BYE",null,null,null,"game 1",null,null,null,"game 2",null,null,null,"game 3",null,null,null,"game 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total points",null,null,null,null,null,null,{"$f":"SUM(AA11:AA74)","v":0},{"$f":"SUM(AB11:AB74)","v":0},null,null,{"$f":"SUM(AE11:AE74)","v":0},{"$f":"SUM(AF11:AF74)","v":0},null,null,{"$f":"SUM(AI11:AI74)","v":0},{"$f":"SUM(AJ11:AJ74)","v":0},null,null,{"$f":"SUM(AM11:AM74)","v":0},{"$f":"SUM(AN11:AN74)","v":0}]
[]
[null,null,null,{"$f":"+AA79","v":0},{"$f":"+AB79","v":0},null,null,{"$f":"+AE79","v":0},{"$f":"+AF79","v":0},null,null,{"$f":"+AI79","v":0},{"$f":"+AJ79","v":0},null,null,{"$f":"+AM79","v":0},{"$f":"+AN79","v":0},null,null,null,null,null,null,null,null,null,{"$f":"COUNT(AA11:AA74)-COUNTIF(F11:F74,1)/2-COUNTIF(AA11:AA74,0)","v":0},{"$f":"COUNT(AB11:AB74)-COUNTIF(F11:F74,1)/2-COUNTIF(AB11:AB74,0)","v":0},null,null,{"$f":"COUNT(AE11:AE74)-COUNTIF(J11:J74,1)/2-COUNTIF(AE11:AE74,0)","v":0},{"$f":"COUNT(AF11:AF74)-COUNTIF(J11:J74,1)/2-COUNTIF(AF11:AF74,0)","v":0},null,{"$f":"COUNT(AH11:AH74)","v":0},{"$f":"COUNT(AI11:AI74)-COUNTIF(N11:N74,1)/2-COUNTIF(AI11:AI74,0)","v":0},{"$f":"COUNT(AJ11:AJ74)-COUNTIF(N11:N74,1)/2-COUNTIF(AJ11:AJ74,0)","v":0},null,{"$f":"COUNT(AL11:AL74)","v":0},{"$f":"COUNT(AM11:AM74)-COUNTIF(R11:R74,1)/2-COUNTIF(AM11:AM74,0)","v":0},{"$f":"COUNT(AN11:AN74)-COUNTIF(R11:R74,1)/2-COUNTIF(AN11:AN74,0)","v":0}]
["                      Total points won",null,null,{"$f":"+SUM(D11:D74)","v":0},null,null,null,{"$f":"+SUM(H11:H74)","v":0},null,null,null,{"$f":"+SUM(L11:L74)","v":0},null,null,null,{"$f":"+SUM(P11:P74)","v":0},null,null,null,{"$f":"+SUM(T11:T74)","v":0}]
["                        Total points lost",null,null,null,{"$f":"+SUM(E11:E74)","v":0},null,null,null,{"$f":"+SUM(I11:I74)","v":0},null,null,null,{"$f":"+SUM(M11:M74)","v":0},null,null,null,{"$f":"+SUM(Q11:Q74)","v":0},null,null,null,{"$f":"+SUM(U11:U74)","v":0}]
["                       Total win points",null,null,null,null,{"$f":"+SUM(F11:F74)","v":0},null,null,null,{"$f":"+SUM(J11:J74)","v":0},null,null,null,{"$f":"+SUM(N11:N74)","v":0},null,null,null,{"$f":"+SUM(R11:R74)","v":0}]
["average winning/losing score",null,null,{"$f":"IF(D80=0,0,AA77/AA79)","v":0},{"$f":"IF(E81=0,0,AB77/AB79)","v":0},null,null,{"$f":"IF(H80=0,0,AE77/AE79)","v":0},{"$f":"IF(I81=0,0,AF77/AF79)","v":0},null,null,{"$f":"IF(L80=0,0,AI77/AI79)","v":0},{"$f":"IF(M81=0,0,AJ77/AJ79)","v":0},null,null,{"$f":"IF(P80=0,0,AM77/AM79)","v":0},{"$f":"IF(Q81=0,0,AN77/AN79)","v":0}]
["The numbers in the above yellow areas are to be used  when a team has a BYE game in that round. "]
[null,"Hopefully when players drew cards before the start of play, the Team #s were recorded. When someone forgets to put there name on the card you have a way to identify them."]
[null,"Here is what you need to do:",null,"VERY IMPORTANT!"]
[null," If you are using more then 1 GREEN{each green will be a group that only plays each other) separate the score cards by the green. Enter the 1st group(team # 1 to 12 or whatever)."]
[null," Use the tab key(not enter) after each entry to go to the next cell. Now check the RED BOXES at the bottom of the spreadsheet. If there is a number there it indicates an error in the numbers."]
[null,null,"It can be scorecards didn't record the correct score or they didn't get copied on the scoresheet correctly."]
[null,null,"Resolve the problem. Then enter scores for the next green(team 13 to 26 for example). Again see if there's a number in any of the red boxes."]
[null,null,"If so resolve the problem and continue. A lot of time can be wasted if 2 or more groups are entered before checking for errors."]
[null,null," If there was a bye, you will need to enter the average score.  Let's say it was 7 to 3. Now at the bottom of that same column enter the same score but enter it  3 to 7. "]
[null,null,"           This will make sure the columns both add up equally."]
[null,1,"Luke ",64,1,null,null,64,1,null,null,64,1,null,null,64,1]
[null,2,"Frazer",63,2,null,null,63,2,null,null,63,2,null,null,63,2]
[null,3,"Fair",62,3,null,null,62,3,null,null,62,3,null,null,62,3]
[null,4,"Downs",61,4,null,null,61,4,null,null,61,4,null,null,61,4]
[null,5,"Wall",60,5,null,null,60,5,null,null,60,5,null,null,60,5]
[null,6,"Enockson",59,6,null,null,59,6,null,null,59,6,null,null,59,6]
[null,7,"White",58,7,null,null,58,7,null,null,58,7,null,null,58,7]
[null,8,"Gary",57,8,null,null,57,8,null,null,57,8,null,null,57,8]
[null,9,"Good",56,9,null,null,56,9,null,null,56,9,null,null,56,9]
[null,10,"Wright",55,10,null,null,55,10,null,null,55,10,null,null,55,10]
[null,11,"Banares",54,11,null,null,54,11,null,null,54,11,null,null,54,11]
[null,12,"Foley",53,12,null,null,53,12,null,null,53,12,null,null,53,12]
[null,13,"Johnson",52,13,null,null,52,13,null,null,52,13,null,null,52,13]
[null,14,"Cloud",51,14,null,null,51,14,null,null,51,14,null,null,51,14]
[null,15,"Duff",50,15,null,null,50,15,null,null,50,15,null,null,50,15]
[null,16,"Smith",49,16,null,null,49,16,null,null,49,16,null,null,49,16]
[null,17,"Brown",48,17,null,null,48,17,null,null,48,17,null,null,48,17]
[null,18,"Watson",47,18,null,null,47,18,null,null,47,18,null,null,47,18]
[null,19,"Hollingsworth",46,19,null,null,46,19,null,null,46,19,null,null,46,19]
[null,20,"Matyskiela",45,20,null,null,45,20,null,null,45,20,null,null,45,20]
[null,21,"Carson",44,21,null,null,44,21,null,null,44,21,null,null,44,21]
[null,22,"Jones",43,22,null,null,43,22,null,null,43,22,null,null,43,22]
[null,23,"Woods",42,23,null,null,42,23,null,null,42,23,null,null,42,23]
[null,24,"Anast",41,24,null,null,41,24,null,null,41,24,null,null,41,24]
[null,25,"Wagers",40,25,null,null,40,25,null,null,40,25,null,null,40,25]
[null,26,"Ruggles",39,26,null,null,39,26,null,null,39,26,null,null,39,26]
[null,27,"Kidd",38,27,null,null,38,27,null,null,38,27,null,null,38,27]
[null,28,"Roliz",37,28,null,null,37,28,null,null,37,28,null,null,37,28]
[null,29,"Dusablon",36,29,null,null,36,29,null,null,36,29,null,null,36,29]
[null,30,"Broad",35,30,null,null,35,30,null,null,35,30,null,null,35,30]
[null,31,"Birkinshaw",34,31,null,null,34,31,null,null,34,31,null,null,34,31]
[null,32,"Jackson",33,32,null,null,33,32,null,null,33,32,null,null,33,32]
[null,33,"Roth",32,33,null,null,32,33,null,null,32,33,null,null,32,33]
[null,34,"Gardner",31,34,null,null,31,34,null,null,31,34,null,null,31,34]
[null,35,"Wagner",30,35,null,null,30,35,null,null,30,35,null,null,30,35]
[null,36,"Roliz M",29,36,null,null,29,36,null,null,29,36,null,null,29,36]
[null,37,"Covell",28,37,null,null,28,37,null,null,28,37,null,null,28,37]
[null,38,"Strueby",27,38,null,null,27,38,null,null,27,38,null,null,27,38]
[null,39,"Wolterman",26,39,null,null,26,39,null,null,26,39,null,null,26,39]
[null,40,"Fladung",25,40,null,null,25,40,null,null,25,40,null,null,25,40]
[null,41,"Behncke",24,41,null,null,24,41,null,null,24,41,null,null,24,41]
[null,42,"Llewellyn",23,42,null,null,23,42,null,null,23,42,null,null,23,42]
[null,43,"Smalluk",22,43,null,null,22,43,null,null,22,43,null,null,22,43]
[null,44,"Foxhall",21,44,null,null,21,44,null,null,21,44,null,null,21,44]
[null,45,"Douglas",20,45,null,null,20,45,null,null,20,45,null,null,20,45]
[null,46,"Perry",19,46,null,null,19,46,null,null,19,46,null,null,19,46]
[null,47,"Nelson",18,47,null,null,18,47,null,null,18,47,null,null,18,47]
[null,48,"Filipiak",17,48,null,null,17,48,null,null,17,48,null,null,17,48]
[null,49,"Rollick",16,49,null,null,16,49,null,null,16,49,null,null,16,49]
[null,50,"Friedman",15,50,null,null,15,50,null,null,15,50,null,null,15,50]
[null,51,"Duvall",14,51,null,null,14,51,null,null,14,51,null,null,14,51]
[null,52,"VanBastelaere",13,52,null,null,13,52,null,null,13,52,null,null,13,52]
[null,53,"Hitchcock",12,53,null,null,12,53,null,null,12,53,null,null,12,53]
[null,54,"Callum",11,54,null,null,11,54,null,null,11,54,null,null,11,54]
[null,55,"Moss",10,55,null,null,10,55,null,null,10,55,null,null,10,55]
[null,56,"Roney",9,56,null,null,9,56,null,null,9,56,null,null,9,56]
[null,57,"Shaner",8,57,null,null,8,57,null,null,8,57,null,null,8,57]
[null,58,"Adams",7,58,null,null,7,58,null,null,7,58,null,null,7,58]
[null,59,"Herbert",6,59,null,null,6,59,null,null,6,59,null,null,6,59]
[null,60,"Davis",5,60,null,null,5,60,null,null,5,60,null,null,5,60]
[null,61,"Brault",4,61,null,null,4,61,null,null,4,61,null,null,4,61]
[null,62,"Bezanson ",3,62,null,null,3,62,null,null,3,62,null,null,3,62]
[null,63,"Klubberud",2,63,null,null,2,63,null,null,2,63,null,null,2,63]
[null,64,"Fall",1,64,null,null,1,64,null,null,1,64,null,null,1,64]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"  Your Tournament Name Here"]
[]
[]
[null,null,null,null,"Game # 1",null,null,null,"Game # 2",null,null,null,"Game # 3",null,null,null,"Game # 4",null,null,null,null,"EVENT SUMMARY           "]
[null,"Team",null,"   Points",null,"Win","Plus","   Points",null,"Win","Plus","   Points",null,"Win","Plus","   Points",null,"Win","Plus","Points",null,"Win","Plus","PW",null,null,"Game # 1",null,null,null,"Game # 2",null,null,null,"Game # 3",null,null,null,"Game # 4"]
[null,"#","       SKIP","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","Won","Lost","PTS","PTS","PW+PL","POS"]
[1,null,null,null,null,{"$f":"IF((D174+E174)<1,0,IF(D174>E174,3,IF(D174=E174,1,0)))","v":0},{"$f":"IF(D174>(E174+11),10,IF((D174+10)<E174,-10,D174-E174))","v":0},null,null,{"$f":"IF((H174+I174)<1,0,IF(H174>I174,3,IF(H174=I174,1,0)))","v":0},{"$f":"IF(H174>(I174+11),10,IF((H174+10)<I174,-10,H174-I174))","v":0},null,null,{"$f":"IF((L174+M174)<1,0,IF(L174>M174,3,IF(L174=M174,1,0)))","v":0},{"$f":"IF(L174>(M174+11),10,IF((L174+10)<M174,-10,L174-M174))","v":0},null,null,{"$f":"IF((P174+Q174)<1,0,IF(P174>Q174,3,IF(P174=Q174,1,0)))","v":0},{"$f":"IF(P174>(Q174+11),10,IF((P174+10)<Q174,-10,P174-Q174))","v":0},{"$f":"+D174+H174+L174+P174","v":0},{"$f":"+E174+I174+M174+Q174","v":0},{"$f":"+F174+J174+N174+R174+Z174","v":-1},{"$f":"G174+K174+O174+S174","v":0},{"$f":"IF((T174+U174)<1,0,+T174/(T174+U174))","v":0},null,{"$f":"IF((X174)<0.01,-1,0)","v":-1},{"$f":"+IF((D174<E174),FALSE,D174-IF((D174=E174),D174/2))","v":0},{"$f":"IF((E174>D174),FALSE,E174)-IF((D174=E174),E174/2,0)","v":0},null,null,{"$f":"+IF((H174<I174),FALSE,H174-IF((H174=I174),H174/2))","v":0},{"$f":"IF((I174>H174),FALSE,I174)-IF((H174=I174),I174/2,0)","v":0},null,null,{"$f":"+IF((L174<M174),FALSE,L174-IF((L174=M174),L174/2))","v":0},{"$f":"IF((M174>L174),FALSE,M174)-IF((L174=M174),M174/2,0)","v":0},null,null,{"$f":"+IF((P174<Q174),FALSE,P174-IF((P174=Q174),P174/2))","v":0},{"$f":"IF((Q174>P174),FALSE,Q174)-IF((P174=Q174),Q174/2,0)","v":0}]
[2,null,null,null,null,0,{"$f":"IF(D175>(E175+11),10,IF((D175+10)<E175,-10,D175-E175))","v":0},null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[3,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[4,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[5,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[6,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[7,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[8,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[9,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[10,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[11,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[12,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[13,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[14,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[15,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[16,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[17,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[18,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[19,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[20,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[21,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[22,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[23,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[24,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[25,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[26,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[27,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[28,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[29,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[30,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[31,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[32,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[33,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[34,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[35,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[36,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[37,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[38,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[39,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[40,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[41,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[42,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[43,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[44,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[45,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[46,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[47,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[48,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[49,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[50,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[51,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[52,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[53,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[54,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[55,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[56,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[57,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[58,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[59,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[60,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[61,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[62,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[63,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[64,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,0,0,-1,0,0,null,-1,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["a white # in any box in this row indicates an error",null,null,null,null,null,{"$f":"SUM(G174:G237)","v":0},null,null,null,{"$f":"SUM(K174:K237)","v":0},null,null,null,{"$f":"SUM(O174:O237)","v":0},null,null,null,{"$f":"SUM(S174:S237)","v":0}]
["OR  A BYE",null,null,null,"game 1",null,null,null,"game 2",null,null,null,"game 3",null,null,null,"game 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total points",null,null,null,null,null,null,{"$f":"SUM(AA174:AA237)","v":0},{"$f":"SUM(AB174:AB237)","v":0},null,null,{"$f":"SUM(AE174:AE237)","v":0},{"$f":"SUM(AF174:AF237)","v":0},null,null,{"$f":"SUM(AI174:AI237)","v":0},{"$f":"SUM(AJ174:AJ237)","v":0},null,null,{"$f":"SUM(AM174:AM237)","v":0},{"$f":"SUM(AN174:AN237)","v":0}]
[]
[null,null,null,{"$f":"+AA242","v":0},{"$f":"+AB242","v":0},null,null,{"$f":"+AE242","v":0},{"$f":"+AF242","v":0},null,null,{"$f":"+AI242","v":0},{"$f":"+AJ242","v":0},null,null,{"$f":"+AM242","v":0},{"$f":"+AN242","v":0},null,null,null,null,null,null,null,null,null,{"$f":"COUNT(AA174:AA237)-COUNTIF(F174:F237,1)/2-COUNTIF(AA174:AA237,0)","v":0},{"$f":"COUNT(AB174:AB237)-COUNTIF(F174:F237,1)/2-COUNTIF(AB174:AB237,0)","v":0},null,null,{"$f":"COUNT(AE174:AE237)-COUNTIF(J174:J237,1)/2-COUNTIF(AE174:AE237,0)","v":0},{"$f":"COUNT(AF174:AF237)-COUNTIF(J174:J237,1)/2-COUNTIF(AF174:AF237,0)","v":0},null,{"$f":"COUNT(AH174:AH237)","v":0},{"$f":"COUNT(AI174:AI237)-COUNTIF(N174:N237,1)/2-COUNTIF(AI174:AI237,0)","v":0},{"$f":"COUNT(AJ174:AJ237)-COUNTIF(N174:N237,1)/2-COUNTIF(AJ174:AJ237,0)","v":0},null,{"$f":"COUNT(AL174:AL237)","v":0},{"$f":"COUNT(AM174:AM237)-COUNTIF(R174:R237,1)/2-COUNTIF(AM174:AM237,0)","v":0},{"$f":"COUNT(AN174:AN237)-COUNTIF(R174:R237,1)/2-COUNTIF(AN174:AN237,0)","v":0}]
["                      Total points won",null,null,{"$f":"+SUM(D174:D237)","v":0},null,null,null,{"$f":"+SUM(H174:H237)","v":0},null,null,null,{"$f":"+SUM(L174:L237)","v":0},null,null,null,{"$f":"+SUM(P174:P237)","v":0},null,null,null,{"$f":"+SUM(T174:T237)","v":0}]
["                        Total points lost",null,null,null,{"$f":"+SUM(E174:E237)","v":0},null,null,null,{"$f":"+SUM(I174:I237)","v":0},null,null,null,{"$f":"+SUM(M174:M237)","v":0},null,null,null,{"$f":"+SUM(Q174:Q237)","v":0},null,null,null,{"$f":"+SUM(U174:U237)","v":0}]
["                       Total win points",null,null,null,null,{"$f":"+SUM(F174:F237)","v":0},null,null,null,{"$f":"+SUM(J174:J237)","v":0},null,null,null,{"$f":"+SUM(N174:N237)","v":0},null,null,null,{"$f":"+SUM(R174:R237)","v":0}]

{"sheet":"Flights Sheet","index":1,"n_rows":155,"n_cols":10,"rows_kept":155,"cut":false,"hidden":false,"merged":[]}
[null,"Rink Assignments may need to be checked"]
[null,null,null,null,null,"Sheet needs to be unprotected for clear names macro to work."]
[null,{"$f":"A4","v":"Luke "},null,null,null,null,null,null,"for each group of 8 here's the bracket"]
["Luke ","RINK 10"]
["Frazer","loser to201",null,null,null,null,null,null,1]
["Fair",{"$f":"A11","v":"Gary"},"RINK 14"]
["Downs",null,"loser to 204",null,null,null,null,null,8]
["Wall",{"$f":"A7","v":"Downs"}]
["Enockson","RINK 11",null,null,null,null,null,null,4]
["White","loser to 201",null,null,null,null,"Champion"]
["Gary",{"$f":"A8","v":"Wall"},null,null,"RINK 13",null,null,null,5]
["Good",{"$f":"A5","v":"Frazer"},null,null,null,null,"2nd place"]
["Wright",null,null,null,null,null,null,null,2]
["Banares","RINK 14"]
["Foley","loser to 202",null,null,null,null,null,null,7]
["Johnson",{"$f":"A10","v":"White"},"RINK 10"]
["Cloud",{"$f":"A6","v":"Fair"},"loser to 204",null,null,null,null,null,3]
["Duff"]
["Smith","RINK 15",null,null,null,null,null,null,6]
["Brown","loser to 202",null,null,"RINK 12",null,"3rd place"]
["Watson",{"$f":"A9","v":"Enockson"},null,null,204,null,"4th place",null,null,"    Change the rink #s as needed."]
["Hollingsworth",null,null,null,null,null,null,null,"dotted lines show the page breaks"]
["Matyskiela",null,"RINK 12",null,null,null,null,null,"To see the page breaks better"]
["Carson",null,"201            loser out",null,null,null,null,null,"go to VIEW/PAGE BREAK PREVIEW  above"]
["Jones","2nd flight",null,null,null,null,"2nd flight 1st"]
["Woods",null,null,null,"** RINK 10 or11",null," 2nd flight 2nd",null,"Formulas are in all the cells for the team name in the first game"]
["Anast",null,"RINK 13",null,null,null,null,null,"When you do a xfer to flights on the scoresheets it places the teams"]
["Wagers",null,"202          loser out",null,null,null,null,null,"in the proper position on this sheet."]
["Ruggles",null,null,null,"** Use whichever rink neither team has played on"]
["Kidd",{"$f":"A12","v":"Good"}]
["Roliz",null,null,null,"3rd Flight",null,null,null,"Challenge flights allow 2 games minimum for all on last day"]
["Dusablon","RINK 2"]
["Broad","loser to 301",null,null,null,null,null,null,"The sheet is unprotected to allow changes to be made"]
["Birkinshaw",{"$f":"A19","v":"Smith"},"RINK 6"]
["Jackson",{"$f":"A15","v":"Foley"},"loser out",null,null,null,null,null,"Good Practices"]
["Roth",null,null,null,null,null,null,null,"don't use end rinks for  flights 1, 2 & 3"]
["Gardner","RINK 3"]
["Wagner","loser to 301",null,null,null,null,"3rd flight 1st",null,"Minimize changing greens for teams"]
["Roliz M",{"$f":"A16","v":"Johnson"},null,null,"RINK 4"]
["Covell",{"$f":"A13","v":"Wright"},null,null,null,null,"3rd flight 2nd",null,"Note how in champ flt, each 2nd game uses a rink used from the other half of the bracket"]
["Strueby",null,null,null,null,null,null,null," the top 4 teams only used 4 rinks for the 1st 2 games, 10,11,14,15. it's easy to find a good rink for champ game and 3rd/4th"]
["Wolterman","RINK 4"]
["Fladung","loser to 302"]
["Behncke",{"$f":"A18","v":"Duff"},"RINK 2",null,null,null,null,null,"To delete lines in the bracket, highlight a box which has all the lines you want to delete"]
["Llewellyn",{"$f":"A14","v":"Banares"},"loser out",null,null,null,null,null,"Put the cursor in a cell for 1 corner of the box"]
["Smalluk",null,null,null,null,null,null,null,"while holding the cursor down slide slide your finger to create a box"]
["Foxhall","RINK 5",null,null,null,null,null,null,"right click format cells/border/none"]
["Douglas","loser to 302"]
["Perry",{"$f":"A17","v":"Cloud"}]
["Nelson",null,null,null,null,null,null,null,"If green 1 is  better than green 2, subtract 8 for rinks 9 to 16 and add 8 to rinks 1 to 8"]
["Filipiak",null,"RINK 7"]
["Rollick",null,"301      loser out",null,null,null,"challenge",null,"Never change the name of the tabs at the bottom because the macros refer to them by that name."]
["Friedman","3rd fl",null,null,null,null,"winner",null,"Also be careful adding or deleting rows or columns because the macros could get messed up."]
["Duvall","challenge",null,null,"RINK 5",null,null,null,"Any thing else should be ok to add or change."]
["VanBastelaere",null,"RINK 3"]
["Hitchcock",null,"302      loser out",null,null,null,null,null," When you save a file do SAVE AS-select your desired folder AND be sure to select at the bottom EXCEL MACRO ENABLED FILE"]
["Callum"]
["Moss",{"$f":"A20","v":"Brown"},null,null,null,null,null,null,"If you get a warning anytime using a macro, choose enable macro."]
["Roney",null,null,null,"4th Flight"]
["Shaner","RINK 9"]
["Adams","loser to 401"]
["Herbert",{"$f":"A27","v":"Anast"},"RINK 15"]
["Davis",{"$f":"A23","v":"Matyskiela"},"loser out"]
["Brault"]
["Bezanson ","RINK 16",null,null,null,null,"4th fl 1st"]
["Klubberud","loser to 401",null,null,"RINK 14"]
["Fall",{"$f":"A24","v":"Carson"}]
[null,{"$f":"A21","v":"Watson"},null,null,null,null,"4th fl 2nd"]
[]
[null,"RINK 12"]
[null,"loser to 402"]
[null,{"$f":"A26","v":"Woods"},"RINK 9"]
[null,{"$f":"A22","v":"Hollingsworth"},"loser out"]
[]
[null,"RINK 13"]
[null,"loser to 402"]
[null,{"$f":"A25","v":"Jones"}]
[]
[null,null,"RINK 11"]
[null,null,"401       loser out",null,null,null,"challenge"]
[null,"4th fl",null,null,null,null,"winner"]
[null,"challenge",null,null,"RINK 15"]
[null,null,"RINK 16"]
[null,null,"402       loser out"]
[]
[null,{"$f":"+A28","v":"Wagers"}]
[null,null,null,null,"5th Flight"]
[null,"RINK 1"]
[null,"loser to 501"]
[null,{"$f":"A35","v":"Jackson"},"RINK 4"]
[null,{"$f":"A31","v":"Roliz"},"loser out"]
[]
[null,"RINK 8"]
[null,"loser to 501",null,null,"RINK 6",null,"5th fl 1st"]
[null,{"$f":"A32","v":"Dusablon"}]
[null,{"$f":"+A29","v":"Ruggles"},null,null,null,null,"5th fl 2nd"]
[]
[null,"RINK 4"]
[null,"loser to 502"]
[null,{"$f":"+A34","v":"Birkinshaw"},"RINK 1"]
[null,{"$f":"+A30","v":"Kidd"},"loser out"]
[]
[null,"RINK 5"]
[null,"loser to 502"]
[null,{"$f":"A33","v":"Broad"}]
[]
[null,null,"RINK 5"]
[null,null,"501         loser out",null,null,null,"challenge"]
[null,"5th fl",null,null,null,null,"winner"]
[null,"challenge",null,null,"RINK 7"]
[null,null,"RINK 8"]
[null,null,"502      loser out"]
[]
[null,{"$f":"A36","v":"Roth"}]
[null,null,null,null,"6th Flight"]
[null,"RINK"]
[null,"loser out"]
[null,{"$f":"A43","v":"Fladung"},"RINK"]
[null,{"$f":"A39","v":"Roliz M"},"loser out"]
[]
[null,"RINK"]
[null,"loser out",null,null,null,null,"6th fl 1st"]
[null,{"$f":"A40","v":"Covell"},null,null,"RINK"]
[null,{"$f":"A37","v":"Gardner"},null,null,null,null,"6th fl 2nd"]
[]
[null,"RINK"]
[null,"loser out"]
[null,{"$f":"A42","v":"Wolterman"},"RINK"]
[null,{"$f":"A38","v":"Wagner"},"loser out"]
[]
[null,"RINK"]
[null,"loser out"]
[null,{"$f":"A41","v":"Strueby"}]
[]
[]
[null,{"$f":"A44","v":"Behncke"}]
[]
[]
[]
[null,{"$f":"A51","v":"Filipiak"}]
[null,{"$f":"A47","v":"Foxhall"},"loser out"]
[]
[null,"RINK"]
[null,"loser out",null,null,null,null,"7th flt 1st"]
[null,{"$f":"A48","v":"Douglas"},null,null,"RINK"]
[null,{"$f":"A45","v":"Llewellyn"},null,null,null,null,"7th flt 2nd"]
[]
[null,"RINK"]
[null,"loser out"]
[null,{"$f":"A50","v":"Nelson"},"RINK"]
[null,{"$f":"A46","v":"Smalluk"},"loser out"]
[]
[null,"RINK"]
[null,"loser out"]
[null,{"$f":"A49","v":"Perry"}]

{"sheet":"Instructions","index":2,"n_rows":68,"n_cols":2,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[null,"This information is available at www.bowlsaz.com"]
[null,"Scoresheet exercise(PRINT THIS OUT TO BE EASIER TO FOLLOW)"]
[]
[null,"If at any time you think you have a corrupt file, download a fresh copy from the website."]
[null,"Click on the Sh1(bw) tab below."]
[null,"Make sure the file is saved as Excel macro-enabled worksbook."]
[null,"To check. Go to the colored microsoft symbol in the upper left corner."]
[null,"Click file/save as. Rename the file test- (for this exercise)."]
[null,"On the line below the file name it shows"]
[null,"save as type- It should indicate Excel macro-enabled workbook"]
[null,"If it doesn't, click the down arrow at the right to display all the file type options."]
[null,"Click on Excel macro-enabled workbook and save in the folder you have selected above."]
[]
[null,"Macros are used. Macros let you do a series of strokes with 1 click."]
[null,"The macros \"buttons\" are the rectangular tabs at the top of the scoresheet."]
[null,"The scoresheet should always be \"protected\". That means certain cells which"]
[null,"contain formulas can't accidently be changed. Let's try some of them."]
[null,"The protect/unprotect Macro button  is green as unprotected when unprotect is clicked."]
[null,"Click protect and it turns red."]
[]
[null,"Now only cells to be used to input data are accessible. All others are protected and can't be altered."]
[null,"This is a good time to change the tournament name. The cell is accessable. Type in a name."]
[]
[null,"Click the fill scores macro to add 64 teams and scores to play with."]
[null,"Granted 64 teams is not realistic and scores of 64 to 1 aren't either."]
[null,"But the program can handle it and doesn't care."]
[null,"This scoresheet is set up for 3 pts for a win and 1 for a tie  & +/- 7 plus points max each game as the 1st tiebreak."]
[null,"It also calculates the fraction pts won/ (pts won +pts lost) as the 2nd tiebreak."]
[]
[null,"Click the sort team names macro to put teams in alphabetical order."]
[null,"Scroll down so only Teams 61,62,63 & 64 are shown."]
[null,"If there is a number in the red cells, there is an error in the scoring, the pts won and lost aren't equal."]
[]
[null,"Error checking"]
[null,"These scores are ok, but let's put in an error. Change White's score from 58 to 55 in game 1."]
[null,"Notice an error appears  in the red box. In a real situation it would be necessary"]
[null,"to go through all 64 scores and find the winning and losing scores that don't match."]
[null,"That's not an easy task for 64 teams- not that you would ever have 64 teams."]
[]
[null,"Let's say you have 34 teams. Typically that would be 17 rinks on 3 greens. "]
[null,"There would be 3 groups of 10, 12 and 12 teams . Use the draw charts on this website and put each group"]
[null,"on a different green.  When preparing to record the results, put the score cards in 3 piles 1-10, 11-22 and 23-34."]
[null,"Each group only plays each other so the pts won and lost must match within a group."]
[]
[null,"If there were any byes, do not enter those scores yet."]
[null,"The best way to input scores is to use the tab key rather than the enter key to go directly to the next cell."]
[null,"Input only 1-10 cards 1st. Then check for errors in the red boxes. Find any errors and resolve."]
[null,"Add scores for 11-22. If there are any errors they will be in the 11-22 group. Resolve errors."]
[null,"Add scores for 23-34. If there are any errors they will be in the 23-34 group. Resolve errors."]
[]
[null,"Now to determine any bye scores. Again scroll down to show only the last 4 teams and the cells below it."]
[null,"The bye score for a team is the average winning and average losing score for the round that team had a bye."]
[null,"It's shown (always rounded off) in the yellow box."]
[null,"Add in the bye score in the scoresheet now. An error will now show in the red box but that's ok"]
[]
[null,"Click sort team names macro. Now the teams are ready to sort in the standings."]
[null,"Next click the sort pts macro. The=at sorts the teams in order."]
[null,"Notice there are no plus pts over 7 and with these fictional scores half"]
[null," the teams have 12 win pts and half have 0. The 1st tiebreak column also shows mostly 7's for plus points."]
[null,"So the 2nd tiebreak comes into play. The scores show the program works when"]
[null,"it's necessary to go to the 2nd tiebreak when sorting."]
[]
[null,"Click the transfer 8 team flight macro. The teams are transferred to the flights sheet in order in col A."]
[null,"Click the 2nd tab from the left at the bottom to see the flight sheet.."]
[null,"Teams are also put in the correct position in the bracket for game 1 since formulas are in the bracket cells."]
[]
[null,"To see how to create the rink assignments for the bracket sheet, download the"]
[null,"rink template for flights sheet file from the website."]