{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":61,"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":"Sheet1","index":0,"n_rows":23,"n_cols":32,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,4,21,9],[18,1,19,1],[9,26,9,27],[9,28,9,29],[9,18,9,19],[9,20,9,21],[9,22,9,23],[9,24,9,25],[9,7,9,8],[10,1,11,1],[12,1,13,1],[14,1,15,1],[16,1,17,1],[17,18,17,23],[9,31,10,31],[4,28,4,30],[1,7,2,14],[1,28,3,30],[4,7,5,14],[2,18,3,25]]}
[]
[null,null,null,null,null,null,null,"Main Tour 1 qualifier",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,"EVENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"               DATE"]
[null,null,null,null,null,null,null,"Q Club Glasgow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROUP"]
[null,null,null,null,"VENUE"]
[]
[]
[]
[null,null,null,"name","pts","fd","fs","score",null,"fs","pts","fd","name",null,"table",null,null,null,"rnd 1",null,"rnd 2",null,"rnd 3",null,"rnd 4",null,"rnd 5",null,"Total",null,null,"RANK"]
[null," rnd 1",1,{"$f":"R12","v":"Hugh Adams"},{"$f":"IF(H11-I11=2,5)+IF(H11-I11=1,4)+IF(H11<I11,0)","v":4},{"$f":"H11-I11","v":1},{"$f":"H11","v":2},2,1,{"$f":"I11","v":1},{"$f":"IF(I11-H11=2,5)+IF(I11-H11=1,4)+IF(I11<H11,0)","v":0},{"$f":"I11-H11","v":-1},{"$f":"R13","v":"Lewis Murphy"},2,null,null,null,null,"pts","fd","pts","fd","pts","fd","pts","fd","pts","fd","pts","fd","fs"]
[null,null,3,{"$f":"R14","v":"Gary Campbell"},{"$f":"IF(H12-I12=2,5)+IF(H12-I12=1,4)+IF(H12<I12,0)","v":5},{"$f":"H12-I12","v":2},{"$f":"H12","v":2},2,0,{"$f":"I12","v":0},{"$f":"IF(I12-H12=2,5)+IF(I12-H12=1,4)+IF(I12<H12,0)","v":0},{"$f":"I12-H12","v":-2},{"$f":"R15","v":"Ayaan Iqbal"},4,null,null,1,"Hugh Adams",{"$f":"SUMIF(round1home,R12,round1homepts)+SUMIF(round1away,R12,round1awaypts)","v":4},{"$f":"SUMIF(round1home,R12,round1homefd)+SUMIF(round1away,R12,round1awayfd)","v":1},{"$f":"SUMIF(round2home,R12,round2homepts)+SUMIF(round2away,R12,round2awaypts)","v":0},{"$f":"SUMIF(round2home,R12,round2homefd)+SUMIF(round2away,R12,round2awayfd)","v":0},{"$f":"SUMIF(round3home,R12,round3homepts)+SUMIF(round3away,R12,round3awaypts)","v":5},{"$f":"SUMIF(round3home,R12,round3homefd)+SUMIF(round3away,R12,round3awayfd)","v":2},{"$f":"SUMIF(round4home,R12,round4homepts)+SUMIF(round4away,R12,round4awaypts)","v":0},{"$f":"SUMIF(round4home,R12,round4homefd)+SUMIF(round4away,R12,round4awayfd)","v":-2},{"$f":"SUMIF(round5home,R12,round5homepts)+SUMIF(round5away,R12,round5awaypts)","v":0},{"$f":"SUMIF(round5home,R12,round5homefd)+SUMIF(round5away,R12,round5awayfd)","v":-1},{"$f":"SUM(S12+U12+W12+Y12+AA12)","v":9},{"$f":"SUM(T12+V12+X12+Z12+AB12)","v":0},{"$f":"SUMIF(HOMEPLAYERS,R12,fsHOMERANGE)+SUMIF(AWAYPLAYERS,R12,fsAWAYRANGE)","v":5},3]
[null," rnd 2",2,{"$f":"R13","v":"Lewis Murphy"},0,-1,1,1,2,2,4,1,{"$f":"R14","v":"Gary Campbell"},3,null,null,2,"Lewis Murphy",{"$f":"SUMIF(round1home,R13,round1homepts)+SUMIF(round1away,R13,round1awaypts)","v":0},{"$f":"SUMIF(round1home,R13,round1homefd)+SUMIF(round1away,R13,round1awayfd)","v":-1},{"$f":"SUMIF(round2home,R13,round2homepts)+SUMIF(round2away,R13,round2awaypts)","v":0},{"$f":"SUMIF(round2home,R13,round2homefd)+SUMIF(round2away,R13,round2awayfd)","v":-1},{"$f":"SUMIF(round3home,R13,round3homepts)+SUMIF(round3away,R13,round3awaypts)","v":0},{"$f":"SUMIF(round3home,R13,round3homefd)+SUMIF(round3away,R13,round3awayfd)","v":0},{"$f":"SUMIF(round4home,R13,round4homepts)+SUMIF(round4away,R13,round4awaypts)","v":5},{"$f":"SUMIF(round4home,R13,round4homefd)+SUMIF(round4away,R13,round4awayfd)","v":2},{"$f":"SUMIF(round5home,R13,round5homepts)+SUMIF(round5away,R13,round5awaypts)","v":0},{"$f":"SUMIF(round5home,R13,round5homefd)+SUMIF(round5away,R13,round5awayfd)","v":-2},{"$f":"SUM(S13+U13+W13+Y13+AA13)","v":5},{"$f":"SUM(T13+V13+X13+Z13+AB13)","v":-2},{"$f":"SUMIF(HOMEPLAYERS,R13,fsHOMERANGE)+SUMIF(AWAYPLAYERS,R13,fsAWAYRANGE)","v":4}]
[null,null,4,{"$f":"R15","v":"Ayaan Iqbal"},0,-2,0,0,2,2,5,2,{"$f":"R16","v":"Barry Lee"},5,null,null,3,"Gary Campbell",{"$f":"SUMIF(round1home,R14,round1homepts)+SUMIF(round1away,R14,round1awaypts)","v":5},{"$f":"SUMIF(round1home,R14,round1homefd)+SUMIF(round1away,R14,round1awayfd)","v":2},{"$f":"SUMIF(round2home,R14,round2homepts)+SUMIF(round2away,R14,round2awaypts)","v":4},{"$f":"SUMIF(round2home,R14,round2homefd)+SUMIF(round2away,R14,round2awayfd)","v":1},{"$f":"SUMIF(round3home,R14,round3homepts)+SUMIF(round3away,R14,round3awaypts)","v":0},{"$f":"SUMIF(round3home,R14,round3homefd)+SUMIF(round3away,R14,round3awayfd)","v":-2},{"$f":"SUMIF(round4home,R14,round4homepts)+SUMIF(round4away,R14,round4awaypts)","v":0},{"$f":"SUMIF(round4home,R14,round4homefd)+SUMIF(round4away,R14,round4awayfd)","v":0},{"$f":"SUMIF(round5home,R14,round5homepts)+SUMIF(round5away,R14,round5awaypts)","v":4},{"$f":"SUMIF(round5home,R14,round5homefd)+SUMIF(round5away,R14,round5awayfd)","v":1},13,2,{"$f":"SUMIF(HOMEPLAYERS,R14,fsHOMERANGE)+SUMIF(AWAYPLAYERS,R14,fsAWAYRANGE)","v":6},2]
[null," rnd 3",3,{"$f":"R14","v":"Gary Campbell"},0,-2,0,0,2,2,5,2,{"$f":"R16","v":"Barry Lee"},5,null,null,4,"Ayaan Iqbal",{"$f":"SUMIF(round1home,R15,round1homepts)+SUMIF(round1away,R15,round1awaypts)","v":0},{"$f":"SUMIF(round1home,R15,round1homefd)+SUMIF(round1away,R15,round1awayfd)","v":-2},{"$f":"SUMIF(round2home,R15,round2homepts)+SUMIF(round2away,R15,round2awaypts)","v":0},{"$f":"SUMIF(round2home,R15,round2homefd)+SUMIF(round2away,R15,round2awayfd)","v":-2},{"$f":"SUMIF(round3home,R15,round3homepts)+SUMIF(round3away,R15,round3awaypts)","v":0},{"$f":"SUMIF(round3home,R15,round3homefd)+SUMIF(round3away,R15,round3awayfd)","v":-2},{"$f":"SUMIF(round4home,R15,round4homepts)+SUMIF(round4away,R15,round4awaypts)","v":0},{"$f":"SUMIF(round4home,R15,round4homefd)+SUMIF(round4away,R15,round4awayfd)","v":-2},{"$f":"SUMIF(round5home,R15,round5homepts)+SUMIF(round5away,R15,round5awaypts)","v":0},{"$f":"SUMIF(round5home,R15,round5homefd)+SUMIF(round5away,R15,round5awayfd)","v":0},0,-8,{"$f":"SUMIF(HOMEPLAYERS,R15,fsHOMERANGE)+SUMIF(AWAYPLAYERS,R15,fsAWAYRANGE)","v":0}]
[null,null,1,{"$f":"R12","v":"Hugh Adams"},5,2,2,2,0,0,0,-2,{"$f":"R15","v":"Ayaan Iqbal"},4,null,null,5,"Barry Lee",{"$f":"SUMIF(round1home,R16,round1homepts)+SUMIF(round1away,R16,round1awaypts)","v":0},{"$f":"SUMIF(round1home,R16,round1homefd)+SUMIF(round1away,R16,round1awayfd)","v":0},{"$f":"SUMIF(round2home,R16,round2homepts)+SUMIF(round2away,R16,round2awaypts)","v":5},{"$f":"SUMIF(round2home,R16,round2homefd)+SUMIF(round2away,R16,round2awayfd)","v":2},{"$f":"SUMIF(round3home,R16,round3homepts)+SUMIF(round3away,R16,round3awaypts)","v":5},{"$f":"SUMIF(round3home,R16,round3homefd)+SUMIF(round3away,R16,round3awayfd)","v":2},{"$f":"SUMIF(round4home,R16,round4homepts)+SUMIF(round4away,R16,round4awaypts)","v":5},{"$f":"SUMIF(round4home,R16,round4homefd)+SUMIF(round4away,R16,round4awayfd)","v":2},{"$f":"SUMIF(round5home,R16,round5homepts)+SUMIF(round5away,R16,round5awaypts)","v":5},{"$f":"SUMIF(round5home,R16,round5homefd)+SUMIF(round5away,R16,round5awayfd)","v":2},{"$f":"SUM(S16+U16+W16+Y16+AA16)","v":20},{"$f":"SUM(T16+V16+X16+Z16+AB16)","v":8},{"$f":"SUMIF(HOMEPLAYERS,R16,fsHOMERANGE)+SUMIF(AWAYPLAYERS,R16,fsAWAYRANGE)","v":8},1]
[null," rnd 4",1,{"$f":"R12","v":"Hugh Adams"},0,-2,0,0,2,2,5,2,{"$f":"R16","v":"Barry Lee"},5]
[null,null,2,{"$f":"R13","v":"Lewis Murphy"},5,2,2,2,0,0,0,-2,{"$f":"R15","v":"Ayaan Iqbal"},4,null,null,null,null,"GROUP TABLE"]
[null," rnd 5",1,{"$f":"R12","v":"Hugh Adams"},0,-1,1,1,2,2,4,1,{"$f":"R14","v":"Gary Campbell"},3]
[null,null,2,{"$f":"R13","v":"Lewis Murphy"},0,-2,0,0,2,2,5,2,{"$f":"R16","v":"Barry Lee"},5,null,null,null,"insert names in GROUP TABLE "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"match scores in FIXTURES"]
[null,null,null,null,"FIXTURES",null,null,null,null,null,null,null,null,null,null,null,null,"and final positions in GROUP TABLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]