{"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":30,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,7,2,14],[1,28,3,30],[2,18,3,25],[4,7,5,14],[8,26,8,27],[8,18,8,19],[8,20,8,21],[8,22,8,23],[8,24,8,25],[8,7,8,8],[4,28,4,30],[8,29,9,29],[17,18,17,23],[22,4,22,9],[9,1,11,1],[12,1,14,1],[15,1,17,1],[18,1,20,1]]}
[]
[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,"B"]
[null,null,null,null,"EVENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-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,"Locarno",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,"Total",null,null,"RANK"]
[null,"   rnd 1",1,{"$f":"R11","v":"R McPherson"},{"$f":"IF(H10-I10=2,5)+IF(H10-I10=1,4)+IF(H10<I10,0)","v":4},{"$f":"H10-I10","v":1},{"$f":"H10","v":2},2,1,{"$f":"I10","v":1},{"$f":"IF(I10-H10=2,5)+IF(I10-H10=1,4)+IF(I10<H10,0)","v":0},{"$f":"I10-H10","v":-1},{"$f":"R12","v":"D Greig"},2,null,null,null,null,"pts","fd","pts","fd","pts","fd","pts","fd","pts","fd","fs"]
[null,null,3,{"$f":"R13","v":"D Gillbertson"},{"$f":"IF(H11-I11=2,5)+IF(H11-I11=1,4)+IF(H11<I11,0)","v":0},{"$f":"H11-I11","v":-2},{"$f":"H11","v":0},0,2,{"$f":"I11","v":2},{"$f":"IF(I11-H11=2,5)+IF(I11-H11=1,4)+IF(I11<H11,0)","v":5},{"$f":"I11-H11","v":2},{"$f":"R14","v":"C Coxen"},4,null,null,1,"R McPherson",{"$f":"SUMIF(round1home,R11,round1homepts)+SUMIF(round1away,R11,round1awaypts)","v":4},{"$f":"SUMIF(round1home,R11,round1homefd)+SUMIF(round1away,R11,round1awayfd)","v":1},{"$f":"SUMIF(round2home,R11,round2homepts)+SUMIF(round2away,R11,round2awaypts)","v":5},{"$f":"SUMIF(round2home,R11,round2homefd)+SUMIF(round2away,R11,round2awayfd)","v":2},{"$f":"SUMIF(round3home,R11,round3homepts)+SUMIF(round3away,R11,round3awaypts)","v":5},{"$f":"SUMIF(round3home,R11,round3homefd)+SUMIF(round3away,R11,round3awayfd)","v":2},{"$f":"SUMIF(round4home,R11,round4homepts)+SUMIF(round4away,R11,round4awaypts)","v":0},{"$f":"SUMIF(round4home,R11,round4homefd)+SUMIF(round4away,R11,round4awayfd)","v":-2},{"$f":"SUM(S11+U11+W11+Y11)","v":14},{"$f":"SUM(T11+V11+X11+Z11)","v":3},{"$f":"SUMIF(alanHOME,R11,fsHOME)+SUMIF(paulAWAY,R11,fsAWAY)","v":6}]
[null,null,5,{"$f":"R15","v":"R Pawer"},5,2,2,2,0,0,0,-2,{"$f":"R16","v":"R McGregor"},6,null,null,2,"D Greig",0,-1,5,2,4,1,4,1,{"$f":"SUM(S12+U12+W12+Y12)","v":13},{"$f":"SUM(T12+V12+X12+Z12)","v":3},7]
[null,"   rnd 2",2,{"$f":"R12","v":"D Greig"},5,2,2,2,0,0,0,-2,{"$f":"R13","v":"D Gillbertson"},3,null,null,3,"D Gillbertson",0,-2,0,-2,5,2,5,2,10,0,4]
[null,null,4,{"$f":"R14","v":"C Coxen"},5,2,2,2,0,0,0,-2,{"$f":"R15","v":"R Pawer"},5,null,null,4,"C Coxen",5,2,5,2,0,-2,5,2,15,4,6]
[null,null,1,{"$f":"R11","v":"R McPherson"},5,2,2,2,0,0,0,-2,{"$f":"R16","v":"R McGregor"},6,null,null,5,"R Pawer",5,2,0,-2,0,-2,0,-1,5,-3,3]
[null,"   rnd 3",3,{"$f":"R13","v":"D Gillbertson"},5,2,2,2,0,0,0,-2,{"$f":"R15","v":"R Pawer"},5,null,null,6,"R McGregor",0,-2,0,-2,0,-1,0,-2,0,-7,1]
[null,null,1,{"$f":"R11","v":"R McPherson"},5,2,2,2,0,0,0,-2,{"$f":"R14","v":"C Coxen"},4]
[null,null,2,{"$f":"R12","v":"D Greig"},4,1,2,2,1,1,0,-1,{"$f":"R16","v":"R McGregor"},6,null,null,null,null,"GROUP TABLE"]
[null,"   rnd 4",4,{"$f":"R14","v":"C Coxen"},5,2,2,2,0,0,0,-2,{"$f":"R16","v":"R McGregor"},6]
[null,null,1,{"$f":"R11","v":"R McPherson"},0,-2,0,0,2,2,5,2,{"$f":"R13","v":"D Gillbertson"},3,null,null,null,"insert names in GROUP TABLE "]
[null,null,2,{"$f":"R12","v":"D Greig"},4,1,2,2,1,1,0,-1,{"$f":"R15","v":"R Pawer"},5,null,null,null,"match scores in FIXTURES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and final positions in GROUP TABLE"]
[null,null,null,null,"FIXTURES"]