{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["results","webquery","ranks","BLANKS","PAYERS","random picks","Round order"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"results","index":0,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["The US pga 2014"]
[]
[]
["Day",0]
[]
[null,"Pick","Total","Hole","T off time",null,null,"Pick","Total","Hole","T off time",null,null,"Pick","Total","Hole","T off time"]
[{"$f":"'random picks'!B2","v":"DEANO"},{"$f":"SUM(B8:B12)/5","v":4.4000000000000004},null,null,null,null,{"$f":"'random picks'!F2","v":"JOHN C"},{"$f":"SUM(H8:H12)/5","v":3},null,null,null,null,{"$f":"'random picks'!J2","v":0},{"$f":"SUM(N8:N12)/5","v":0}]
[{"$f":"BLANKS!A8","v":"Rickie Fowler"},{"$f":"BLANKS!B8","v":3},{"$f":"IF($A8=\"\",\"\",VLOOKUP($A8,webquery!S:V,2,FALSE))","v":-7},{"$f":"IF(E8<1,\"\",VLOOKUP($A8,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D8","v":"Sergio Garcia"},{"$f":"BLANKS!E8","v":5},{"$f":"IF($G8=\"\",\"\",VLOOKUP($G8,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(K8<1,\"\",VLOOKUP($G8,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G8","v":0},{"$f":"BLANKS!H8","v":0},{"$f":"IF($M8=\"\",\"\",VLOOKUP($M8,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q8<1,\"\",VLOOKUP($M8,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A9","v":"Graeme McDowell"},{"$f":"BLANKS!B9","v":4},{"$f":"IF($A9=\"\",\"\",VLOOKUP($A9,webquery!S:V,2,FALSE))","v":1},{"$f":"IF(E9<1,\"\",VLOOKUP($A9,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,"Tiger Woods",{"$f":"BLANKS!E9","v":3},{"$f":"IF($G9=\"\",\"\",VLOOKUP($G9,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(K9<1,\"\",VLOOKUP($G9,webquery!$S:$V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!G9","v":0},{"$f":"BLANKS!H9","v":0},{"$f":"IF($M9=\"\",\"\",VLOOKUP($M9,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q9<1,\"\",VLOOKUP($M9,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A10","v":"Marc Leishman"},{"$f":"BLANKS!B10","v":5},{"$f":"IF($A10=\"\",\"\",VLOOKUP($A10,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(E10<1,\"\",VLOOKUP($A10,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D10","v":"Martin Kaymer"},{"$f":"BLANKS!E10","v":2},{"$f":"IF($G10=\"\",\"\",VLOOKUP($G10,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(K10<1,\"\",VLOOKUP($G10,webquery!$S:$V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!G10","v":0},{"$f":"BLANKS!H10","v":0},{"$f":"IF($M10=\"\",\"\",VLOOKUP($M10,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q10<1,\"\",VLOOKUP($M10,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A11","v":"Harris English"},{"$f":"BLANKS!B11","v":5},{"$f":"IF($A11=\"\",\"\",VLOOKUP($A11,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(E11<1,\"\",VLOOKUP($A11,webquery!$S:V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!D11","v":"Jason Day"},{"$f":"BLANKS!E11","v":1},{"$f":"IF($G11=\"\",\"\",VLOOKUP($G11,webquery!S:V,2,FALSE))","v":-8},{"$f":"IF(K11<1,\"\",VLOOKUP($G11,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G11","v":0},{"$f":"BLANKS!H11","v":0},{"$f":"IF($M11=\"\",\"\",VLOOKUP($M11,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q11<1,\"\",VLOOKUP($M11,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A12","v":"Geoff Ogilvy"},{"$f":"BLANKS!B12","v":5},{"$f":"IF($A12=\"\",\"\",VLOOKUP($A12,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(E12<1,\"\",VLOOKUP($A12,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D12","v":"Steve Stricker"},{"$f":"BLANKS!E12","v":4},{"$f":"IF($G12=\"\",\"\",VLOOKUP($G12,webquery!S:V,2,FALSE))","v":-5},{"$f":"IF(K12<1,\"\",VLOOKUP($G12,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G12","v":0},{"$f":"BLANKS!H12","v":0},{"$f":"IF($M12=\"\",\"\",VLOOKUP($M12,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q12<1,\"\",VLOOKUP($M12,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
["Best 3",null,{"$f":"IF(ISERROR(SMALL(C8:C12,1)+SMALL(C8:C12,2)+SMALL(C8:C12,3)),\"\",SMALL(C8:C12,1)+SMALL(C8:C12,2)+SMALL(C8:C12,3))","v":-9},{"$f":"IF(ISERROR(C13-B7/100),\"\",C13-B7/100)","v":-9.0440000000000005},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(I8:I12,1)+SMALL(I8:I12,2)+SMALL(I8:I12,3)),\"\",SMALL(I8:I12,1)+SMALL(I8:I12,2)+SMALL(I8:I12,3))","v":-13},{"$f":"IF(ISERROR(I13-H7/100),\"\",I13-H7/100)","v":-13.03},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(O8:O12,1)+SMALL(O8:O12,2)+SMALL(O8:O12,3)),\"\",SMALL(O8:O12,1)+SMALL(O8:O12,2)+SMALL(O8:O12,3))","v":""},{"$f":"IF(ISERROR(O13-N7/100),\"\",O13-N7/100)","v":""}]
["Running position",null,{"$f":"VLOOKUP(A7,ranks!$C$4:$G$14,4,FALSE)","v":6},{"$f":"VLOOKUP(A7,ranks!$C$4:$G$14,5,FALSE)","v":6},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G7,ranks!$C$4:$G$14,4,FALSE)","v":2},{"$f":"VLOOKUP(G7,ranks!$C$4:$G$14,5,FALSE)","v":2},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(M7,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(M7,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick"]
[]
[{"$f":"'random picks'!C2","v":"TEZ"},{"$f":"SUM(B17:B21)/5","v":3.4},null,null,null,null,{"$f":"'random picks'!G2","v":"CRAIG T"},{"$f":"SUM(H17:H21)/5","v":3.8},null,null,null,null,{"$f":"'random picks'!K2","v":0},{"$f":"SUM(N17:N21)/5","v":0}]
[{"$f":"BLANKS!A17","v":"Phil Mickelson"},{"$f":"BLANKS!B17","v":4},{"$f":"IF($A17=\"\",\"\",VLOOKUP($A17,webquery!S:V,2,FALSE))","v":-6},{"$f":"IF(E17<1,\"\",VLOOKUP($A17,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D17","v":"Justin Rose"},{"$f":"BLANKS!E17","v":6},{"$f":"IF($G17=\"\",\"\",VLOOKUP($G17,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(K17<1,\"\",VLOOKUP($G17,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G17","v":0},{"$f":"BLANKS!H17","v":0},{"$f":"IF($M17=\"\",\"\",VLOOKUP($M17,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q17<1,\"\",VLOOKUP($M17,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A18","v":"Jordan Spieth"},{"$f":"BLANKS!B18","v":1},{"$f":"IF($A18=\"\",\"\",VLOOKUP($A18,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(E18<1,\"\",VLOOKUP($A18,webquery!$S:V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!D18","v":"Charl Schwartzel"},{"$f":"BLANKS!E18","v":7},{"$f":"IF($G18=\"\",\"\",VLOOKUP($G18,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(K18<1,\"\",VLOOKUP($G18,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G18","v":0},{"$f":"BLANKS!H18","v":0},{"$f":"IF($M18=\"\",\"\",VLOOKUP($M18,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q18<1,\"\",VLOOKUP($M18,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A19","v":"Jimmy Walker"},{"$f":"BLANKS!B19","v":4},{"$f":"IF($A19=\"\",\"\",VLOOKUP($A19,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(E19<1,\"\",VLOOKUP($A19,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D19","v":"Jim Furyk"},{"$f":"BLANKS!E19","v":1},{"$f":"IF($G19=\"\",\"\",VLOOKUP($G19,webquery!S:V,2,FALSE))","v":-8},{"$f":"IF(K19<1,\"\",VLOOKUP($G19,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G19","v":0},{"$f":"BLANKS!H19","v":0},{"$f":"IF($M19=\"\",\"\",VLOOKUP($M19,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q19<1,\"\",VLOOKUP($M19,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A20","v":"J.B. Holmes"},{"$f":"BLANKS!B20","v":7},{"$f":"IF($A20=\"\",\"\",VLOOKUP($A20,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(E20<1,\"\",VLOOKUP($A20,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D20","v":"Brandt Snedeker"},{"$f":"BLANKS!E20","v":2},{"$f":"IF($G20=\"\",\"\",VLOOKUP($G20,webquery!S:V,2,FALSE))","v":-1},{"$f":"IF(K20<1,\"\",VLOOKUP($G20,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G20","v":0},{"$f":"BLANKS!H20","v":0},{"$f":"IF($M20=\"\",\"\",VLOOKUP($M20,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q20<1,\"\",VLOOKUP($M20,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A21","v":"Luke Donald"},{"$f":"BLANKS!B21","v":1},{"$f":"IF($A21=\"\",\"\",VLOOKUP($A21,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(E21<1,\"\",VLOOKUP($A21,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D21","v":"Hunter Mahan"},{"$f":"BLANKS!E21","v":3},{"$f":"IF($G21=\"\",\"\",VLOOKUP($G21,webquery!S:V,2,FALSE))","v":-1},{"$f":"IF(K21<1,\"\",VLOOKUP($G21,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G21","v":0},{"$f":"BLANKS!H21","v":0},{"$f":"IF($M21=\"\",\"\",VLOOKUP($M21,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q21<1,\"\",VLOOKUP($M21,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
["Best 3",null,{"$f":"IF(ISERROR(SMALL(C17:C21,1)+SMALL(C17:C21,2)+SMALL(C17:C21,3)),\"\",SMALL(C17:C21,1)+SMALL(C17:C21,2)+SMALL(C17:C21,3))","v":-10},{"$f":"IF(ISERROR(C22-B16/100),\"\",C22-B16/100)","v":-10.034000000000001},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(I17:I21,1)+SMALL(I17:I21,2)+SMALL(I17:I21,3)),\"\",SMALL(I17:I21,1)+SMALL(I17:I21,2)+SMALL(I17:I21,3))","v":-11},{"$f":"IF(ISERROR(I22-H16/100),\"\",I22-H16/100)","v":-11.038},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(O17:O21,1)+SMALL(O17:O21,2)+SMALL(O17:O21,3)),\"\",SMALL(O17:O21,1)+SMALL(O17:O21,2)+SMALL(O17:O21,3))","v":""},{"$f":"IF(ISERROR(O22-N16/100),\"\",O22-N16/100)","v":""}]
["Running position",null,{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,4,FALSE)","v":5},{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,5,FALSE)","v":5},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,4,FALSE)","v":3},{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,5,FALSE)","v":4},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(M16,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(M16,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick"]
[]
[{"$f":"'random picks'!D2","v":"BYRON"},{"$f":"SUM(B26:B30)/5","v":4.8},null,null,null,null,{"$f":"'random picks'!H2","v":"STUART D"},{"$f":"SUM(H26:H30)/5","v":4},null,null,null,null,{"$f":"'random picks'!L2","v":0},{"$f":"SUM(N26:N30)/5","v":0}]
[{"$f":"BLANKS!A26","v":"Henrik Stenson"},{"$f":"BLANKS!B26","v":7},{"$f":"IF($A26=\"\",\"\",VLOOKUP($A26,webquery!S:V,2,FALSE))","v":-5},{"$f":"IF(E26<1,\"\",VLOOKUP($A26,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D26","v":"Adam Scott"},{"$f":"BLANKS!E26","v":2},{"$f":"IF($G26=\"\",\"\",VLOOKUP($G26,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(K26<1,\"\",VLOOKUP($G26,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G17","v":0},{"$f":"BLANKS!H26","v":0}]
[{"$f":"BLANKS!A27","v":"Matt Kuchar"},{"$f":"BLANKS!B27","v":5},"DNS","DNS",1.5,null,{"$f":"BLANKS!D27","v":"Keegan Bradley"},{"$f":"BLANKS!E27","v":6},{"$f":"IF($G27=\"\",\"\",VLOOKUP($G27,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(K27<1,\"\",VLOOKUP($G27,webquery!$S:$V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!G18","v":0},{"$f":"BLANKS!H27","v":0}]
[{"$f":"BLANKS!A28","v":"Lee Westwood"},{"$f":"BLANKS!B28","v":6},{"$f":"IF($A28=\"\",\"\",VLOOKUP($A28,webquery!S:V,2,FALSE))","v":-5},{"$f":"IF(E28<1,\"\",VLOOKUP($A28,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D28","v":"Hideki Matsuyama"},{"$f":"BLANKS!E28","v":3},{"$f":"IF($G28=\"\",\"\",VLOOKUP($G28,webquery!S:V,2,FALSE))","v":1},{"$f":"IF(K28<1,\"\",VLOOKUP($G28,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G19","v":0},{"$f":"BLANKS!H28","v":0}]
[{"$f":"BLANKS!A29","v":"Ryan Moore"},{"$f":"BLANKS!B29","v":4},{"$f":"IF($A29=\"\",\"\",VLOOKUP($A29,webquery!S:V,2,FALSE))","v":-1},{"$f":"IF(E29<1,\"\",VLOOKUP($A29,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D29","v":"Zach Johnson"},{"$f":"BLANKS!E29","v":3},{"$f":"IF($G29=\"\",\"\",VLOOKUP($G29,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(K29<1,\"\",VLOOKUP($G29,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G20","v":0},{"$f":"BLANKS!H29","v":0}]
[{"$f":"BLANKS!A30","v":"Jason Dufner"},{"$f":"BLANKS!B30","v":2},{"$f":"IF($A30=\"\",\"\",VLOOKUP($A30,webquery!S:V,2,FALSE))","v":"WD"},{"$f":"IF(E30<1,\"\",VLOOKUP($A30,webquery!$S:V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!D30","v":"Webb Simpson"},{"$f":"BLANKS!E30","v":6},{"$f":"IF($G30=\"\",\"\",VLOOKUP($G30,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(K30<1,\"\",VLOOKUP($G30,webquery!$S:$V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!G21","v":0},{"$f":"BLANKS!H30","v":0}]
["Best 3",null,{"$f":"IF(ISERROR(SMALL(C26:C30,1)+SMALL(C26:C30,2)+SMALL(C26:C30,3)),\"\",SMALL(C26:C30,1)+SMALL(C26:C30,2)+SMALL(C26:C30,3))","v":-11},{"$f":"IF(ISERROR(C31-B25/100),\"\",C31-B25/100)","v":-11.048},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(I26:I30,1)+SMALL(I26:I30,2)+SMALL(I26:I30,3)),\"\",SMALL(I26:I30,1)+SMALL(I26:I30,2)+SMALL(I26:I30,3))","v":-1},{"$f":"IF(ISERROR(I31-H25/100),\"\",I31-H25/100)","v":-1.04},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(O26:O30,1)+SMALL(O26:O30,2)+SMALL(O26:O30,3)),\"\",SMALL(O26:O30,1)+SMALL(O26:O30,2)+SMALL(O26:O30,3))","v":""},{"$f":"IF(ISERROR(O31-N25/100),\"\",O31-N25/100)","v":""}]
["Running position",null,{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,4,FALSE)","v":3},{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,5,FALSE)","v":3},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G25,ranks!$C$4:$G$14,4,FALSE)","v":7},{"$f":"VLOOKUP(G25,ranks!$C$4:$G$14,5,FALSE)","v":7},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(M25,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(M25,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick"]
[]
[{"$f":"'random picks'!E2","v":"STEVER"},{"$f":"SUM(B35:B39)/5","v":4.5999999999999996},null,null,null,null,{"$f":"'random picks'!I2","v":0},{"$f":"SUM(H35:H39)/5","v":0},null,null,null,null,0]
[{"$f":"BLANKS!A35","v":"Rory McILroy"},{"$f":"BLANKS!B35","v":1},{"$f":"IF($A35=\"\",\"\",VLOOKUP($A35,webquery!S:V,2,FALSE))","v":-9},{"$f":"IF(E35<1,\"\",VLOOKUP($A35,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D35","v":0},{"$f":"BLANKS!E35","v":0},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,webquery!S:V,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(K35<1,\"\",VLOOKUP(#REF!,webquery!$S:$V,4,FALSE))","v":{"$error":"#REF!"}},1.5,null,{"$f":"BLANKS!G35","v":0}]
[{"$f":"BLANKS!A36","v":"Bubba Watson"},{"$f":"BLANKS!B36","v":2},{"$f":"IF($A36=\"\",\"\",VLOOKUP($A36,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(E36<1,\"\",VLOOKUP($A36,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D36","v":0},{"$f":"BLANKS!E36","v":0},{"$f":"IF($G35=\"\",\"\",VLOOKUP($G35,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(K36<1,\"\",VLOOKUP($G35,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5,null,{"$f":"BLANKS!G36","v":0}]
[{"$f":"BLANKS!A37","v":"Victor Dubuisson"},{"$f":"BLANKS!B37","v":7},{"$f":"IF($A37=\"\",\"\",VLOOKUP($A37,webquery!S:V,2,FALSE))","v":-5},{"$f":"IF(E37<1,\"\",VLOOKUP($A37,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D37","v":0},{"$f":"BLANKS!E37","v":0},{"$f":"IF($G37=\"\",\"\",VLOOKUP($G37,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(K37<1,\"\",VLOOKUP($G37,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5,null,{"$f":"BLANKS!G37","v":0}]
[{"$f":"BLANKS!A38","v":"Angel Cabrera"},{"$f":"BLANKS!B38","v":6},{"$f":"IF($A38=\"\",\"\",VLOOKUP($A38,webquery!S:V,2,FALSE))","v":"-"},{"$f":"IF(E38<1,\"\",VLOOKUP($A38,webquery!$S:V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!D38","v":0},{"$f":"BLANKS!E38","v":0},{"$f":"IF($G38=\"\",\"\",VLOOKUP($G38,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(K38<1,\"\",VLOOKUP($G38,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5,null,{"$f":"BLANKS!G38","v":0}]
[{"$f":"BLANKS!A39","v":"Francesco Molinari"},{"$f":"BLANKS!B39","v":7},{"$f":"IF($A39=\"\",\"\",VLOOKUP($A39,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(E39<1,\"\",VLOOKUP($A39,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D39","v":0},{"$f":"BLANKS!E39","v":0},{"$f":"IF($G39=\"\",\"\",VLOOKUP($G39,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(K39<1,\"\",VLOOKUP($G39,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5,null,{"$f":"BLANKS!G39","v":0}]
["Best 3",null,{"$f":"IF(ISERROR(SMALL(C35:C39,1)+SMALL(C35:C39,2)+SMALL(C35:C39,3)),\"\",SMALL(C35:C39,1)+SMALL(C35:C39,2)+SMALL(C35:C39,3))","v":-14},{"$f":"IF(ISERROR(C40-B34/100),\"\",C40-B34/100)","v":-14.045999999999999},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(I35:I39,1)+SMALL(I35:I39,2)+SMALL(I35:I39,3)),\"\",SMALL(I35:I39,1)+SMALL(I35:I39,2)+SMALL(I35:I39,3))","v":""},{"$f":"IF(ISERROR(I40-H34/100),\"\",I40-H34/100)","v":""},null,null,"Best 3"]
["Running position",null,{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,4,FALSE)","v":1},{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,5,FALSE)","v":1},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G34,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(G34,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick",null,"Running position"]
[]
["To get the correct tee-times you need to make sure you enter the right day of play at the top"]
["Click on The Open logo to update"]

{"sheet":"webquery","index":1,"n_rows":162,"n_cols":23,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,null,null,11,null,null,null,10,null,11,12,13,14,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index:",3,10,6,9]
[null,null,"Search Sports",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total","t-off","thru"]
[null,null,"Search Web",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"SUBSTITUTE(INDEX($A:$J,R4,$S$2),\"*\",\"\")","v":"Search Web"},{"$f":"IF(INDEX($A:$L,R4,$T$2)=\"E\",0,IF(INDEX($A:$L,R4,$T$2)=\"MC\",100,INDEX($A:$L,R4,$T$2)))","v":0},{"$f":"IF(ISERROR(INDEX($A:$J,R4,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R4,$U$2)+TIME(5,0,0))","v":"05:00:00"},{"$f":"INDEX($A:$N,R4,$V$2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"SUBSTITUTE(INDEX($A:$J,R5,$S$2),\"*\",\"\")","v":""},{"$f":"IF(INDEX($A:$L,R5,$T$2)=\"E\",0,IF(INDEX($A:$L,R5,$T$2)=\"MC\",100,INDEX($A:$L,R5,$T$2)))","v":0},{"$f":"IF(ISERROR(INDEX($A:$J,R5,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R5,$U$2)+TIME(5,0,0))","v":"05:00:00"},{"$f":"INDEX($A:$N,R5,$V$2)","v":0}]
[null,"Pos","Name",1,2,3,4,"Today","Thru","Total","Strokes",null,null,null,null,null,null,6,{"$f":"SUBSTITUTE(INDEX($A:$J,R6,$S$2),\"*\",\"\")","v":"Name"},{"$f":"IF(INDEX($A:$L,R6,$T$2)=\"E\",0,IF(INDEX($A:$L,R6,$T$2)=\"MC\",100,INDEX($A:$L,R6,$T$2)))","v":"Total"},{"$f":"IF(ISERROR(INDEX($A:$J,R6,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R6,$U$2)+TIME(5,0,0))","v":3.2083333333333335},{"$f":"INDEX($A:$N,R6,$V$2)","v":"Thru"}]
[null,1,"Rory McIlroy",66,67,"15:00:00","-",-4,"F",-9,133,null,null,null,null,null,null,7,{"$f":"SUBSTITUTE(INDEX($A:$J,R7,$S$2),\"*\",\"\")","v":"Rory McIlroy"},{"$f":"IF(INDEX($A:$L,R7,$T$2)=\"E\",0,IF(INDEX($A:$L,R7,$T$2)=\"MC\",100,INDEX($A:$L,R7,$T$2)))","v":-9},{"$f":"IF(ISERROR(INDEX($A:$J,R7,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R7,$U$2)+TIME(5,0,0))","v":"20:00:00"},{"$f":"INDEX($A:$N,R7,$V$2)","v":"F"}]
[null,"T2","Jason Day",69,65,"15:00:00","-",-6,"F",-8,134,null,null,null,null,null,null,{"$f":"R7+1","v":8},{"$f":"SUBSTITUTE(INDEX($A:$J,R8,$S$2),\"*\",\"\")","v":"Jason Day"},{"$f":"IF(INDEX($A:$L,R8,$T$2)=\"E\",0,IF(INDEX($A:$L,R8,$T$2)=\"MC\",100,INDEX($A:$L,R8,$T$2)))","v":-8},{"$f":"IF(ISERROR(INDEX($A:$J,R8,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R8,$U$2)+TIME(5,0,0))","v":"20:00:00"},{"$f":"INDEX($A:$N,R8,$V$2)","v":"F"}]
[null,"T2","Jim Furyk",66,68,"14:50:00","-",-3,"F",-8,134,null,null,null,null,null,null,{"$f":"R8+1","v":9},{"$f":"SUBSTITUTE(INDEX($A:$J,R9,$S$2),\"*\",\"\")","v":"Jim Furyk"},{"$f":"IF(INDEX($A:$L,R9,$T$2)=\"E\",0,IF(INDEX($A:$L,R9,$T$2)=\"MC\",100,INDEX($A:$L,R9,$T$2)))","v":-8},{"$f":"IF(ISERROR(INDEX($A:$J,R9,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R9,$U$2)+TIME(5,0,0))","v":"19:50:00"},{"$f":"INDEX($A:$N,R9,$V$2)","v":"F"}]
[null,"T4","Ryan Palmer",65,70,"14:50:00","-",-1,"F",-7,135,null,null,null,null,null,null,10,{"$f":"SUBSTITUTE(INDEX($A:$J,R10,$S$2),\"*\",\"\")","v":"Ryan Palmer"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R10,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R10,$U$2)+TIME(5,0,0))","v":"19:50:00"},"F"]
[null,"T4","Rickie Fowler",69,66,"14:40:00","-",-5,"F",-7,135,null,null,null,null,null,null,11,{"$f":"SUBSTITUTE(INDEX($A:$J,R11,$S$2),\"*\",\"\")","v":"Rickie Fowler"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R11,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R11,$U$2)+TIME(5,0,0))","v":"19:40:00"},"F"]
[null,"T4","Mikko Ilonen",67,68,"14:40:00","-",-3,"F",-7,135,null,null,null,null,null,null,12,{"$f":"SUBSTITUTE(INDEX($A:$J,R12,$S$2),\"*\",\"\")","v":"Mikko Ilonen"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R12,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R12,$U$2)+TIME(5,0,0))","v":"19:40:00"},"F"]
[null,"T7","Phil Mickelson",69,67,"14:30:00","-",-4,"F",-6,136,null,null,null,null,null,null,13,{"$f":"SUBSTITUTE(INDEX($A:$J,R13,$S$2),\"*\",\"\")","v":"Phil Mickelson"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R13,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R13,$U$2)+TIME(5,0,0))","v":"19:30:00"},"F"]
[null,"T7","Bernd Wiesberger",68,68,"14:30:00","-",-3,"F",-6,136,null,null,null,null,null,null,14,{"$f":"SUBSTITUTE(INDEX($A:$J,R14,$S$2),\"*\",\"\")","v":"Bernd Wiesberger"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R14,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R14,$U$2)+TIME(5,0,0))","v":"19:30:00"},"F"]
[null,"T9","Graham DeLaet",69,68,"14:20:00","-",-3,"F",-5,137,null,null,null,null,null,null,15,{"$f":"SUBSTITUTE(INDEX($A:$J,R15,$S$2),\"*\",\"\")","v":"Graham DeLaet"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R15,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R15,$U$2)+TIME(5,0,0))","v":"19:20:00"},"F"]
[null,"T9","Steve Stricker",69,68,"14:20:00","-",-3,"F",-5,137,null,null,null,null,null,null,16,{"$f":"SUBSTITUTE(INDEX($A:$J,R16,$S$2),\"*\",\"\")","v":"Steve Stricker"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R16,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R16,$U$2)+TIME(5,0,0))","v":"19:20:00"},"F"]
[null,"T9","Henrik Stenson",66,71,"14:10:00","-","E","F",-5,137,null,null,null,null,null,null,17,{"$f":"SUBSTITUTE(INDEX($A:$J,R17,$S$2),\"*\",\"\")","v":"Henrik Stenson"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R17,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R17,$U$2)+TIME(5,0,0))","v":"19:10:00"},"F"]
[null,"T9","Joost Luiten",68,69,"14:10:00","-",-2,"F",-5,137,null,null,null,null,null,null,18,{"$f":"SUBSTITUTE(INDEX($A:$J,R18,$S$2),\"*\",\"\")","v":"Joost Luiten"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R18,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R18,$U$2)+TIME(5,0,0))","v":"19:10:00"},"F"]
[null,"T9","Victor Dubuisson",69,68,"14:00:00","-",-3,"F",-5,137,null,null,null,null,null,null,19,{"$f":"SUBSTITUTE(INDEX($A:$J,R19,$S$2),\"*\",\"\")","v":"Victor Dubuisson"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R19,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R19,$U$2)+TIME(5,0,0))","v":"19:00:00"},"F"]
[null,"T9","Lee Westwood",65,72,"14:00:00","-",1,"F",-5,137,null,null,null,null,null,null,20,{"$f":"SUBSTITUTE(INDEX($A:$J,R20,$S$2),\"*\",\"\")","v":"Lee Westwood"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R20,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R20,$U$2)+TIME(5,0,0))","v":"19:00:00"},"F"]
[null,"T9","Louis Oosthuizen",70,67,"13:50:00","-",-4,"F",-5,137,null,null,null,null,null,null,21,{"$f":"SUBSTITUTE(INDEX($A:$J,R21,$S$2),\"*\",\"\")","v":"Louis Oosthuizen"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R21,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R21,$U$2)+TIME(5,0,0))","v":"18:50:00"},"F"]
[null,16,"Nick Watney",69,69,"13:50:00","-",-2,"F",-4,138,null,null,null,null,null,null,22,{"$f":"SUBSTITUTE(INDEX($A:$J,R22,$S$2),\"*\",\"\")","v":"Nick Watney"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R22,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R22,$U$2)+TIME(5,0,0))","v":"18:50:00"},"F"]
[null,"T17","Bill Haas",71,68,"13:30:00","-",-3,"F",-3,139,null,null,null,null,null,null,23,{"$f":"SUBSTITUTE(INDEX($A:$J,R23,$S$2),\"*\",\"\")","v":"Bill Haas"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R23,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R23,$U$2)+TIME(5,0,0))","v":"18:30:00"},"F"]
[null,"T17","Vijay Singh",71,68,"13:30:00","-",-3,"F",-3,139,null,null,null,null,null,null,24,{"$f":"SUBSTITUTE(INDEX($A:$J,R24,$S$2),\"*\",\"\")","v":"Vijay Singh"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R24,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R24,$U$2)+TIME(5,0,0))","v":"18:30:00"},"F"]
[null,"T17","Matt Jones",68,71,"13:20:00","-","E","F",-3,139,null,null,null,null,null,null,25,{"$f":"SUBSTITUTE(INDEX($A:$J,R25,$S$2),\"*\",\"\")","v":"Matt Jones"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R25,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R25,$U$2)+TIME(5,0,0))","v":"18:20:00"},"F"]
[null,"T17","Richard Sterne",70,69,"13:20:00","-",-2,"F",-3,139,null,null,null,null,null,null,26,{"$f":"SUBSTITUTE(INDEX($A:$J,R26,$S$2),\"*\",\"\")","v":"Richard Sterne"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R26,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R26,$U$2)+TIME(5,0,0))","v":"18:20:00"},"F"]
[null,"T17","Chris Wood",66,73,"13:10:00","-",2,"F",-3,139,null,null,null,null,null,null,27,{"$f":"SUBSTITUTE(INDEX($A:$J,R27,$S$2),\"*\",\"\")","v":"Chris Wood"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R27,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R27,$U$2)+TIME(5,0,0))","v":"18:10:00"},"F"]
[null,"T17","Billy Horschel",71,68,"13:10:00","-",-3,"F",-3,139,null,null,null,null,null,null,28,{"$f":"SUBSTITUTE(INDEX($A:$J,R28,$S$2),\"*\",\"\")","v":"Billy Horschel"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R28,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R28,$U$2)+TIME(5,0,0))","v":"18:10:00"},"F"]
[null,"T17","Kevin Chappell",65,74,"13:00:00","-",3,"F",-3,139,null,null,null,null,null,null,29,{"$f":"SUBSTITUTE(INDEX($A:$J,R29,$S$2),\"*\",\"\")","v":"Kevin Chappell"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R29,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R29,$U$2)+TIME(5,0,0))","v":"18:00:00"},"F"]
[null,"T17","Jamie Donaldson",69,70,"13:00:00","-",-1,"F",-3,139,null,null,null,null,null,null,30,{"$f":"SUBSTITUTE(INDEX($A:$J,R30,$S$2),\"*\",\"\")","v":"Jamie Donaldson"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R30,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R30,$U$2)+TIME(5,0,0))","v":"18:00:00"},"F"]
[null,"T17","Edoardo Molinari",66,73,"12:50:00","-",2,"F",-3,139,null,null,null,null,null,null,31,{"$f":"SUBSTITUTE(INDEX($A:$J,R31,$S$2),\"*\",\"\")","v":"Edoardo Molinari"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R31,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R31,$U$2)+TIME(5,0,0))","v":"17:50:00"},"F"]
[null,"T26","Alexander Levy",69,71,"12:50:00","-","E","F",-2,140,null,null,null,null,null,null,32,{"$f":"SUBSTITUTE(INDEX($A:$J,R32,$S$2),\"*\",\"\")","v":"Alexander Levy"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R32,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R32,$U$2)+TIME(5,0,0))","v":"17:50:00"},"F"]
[null,"T26","Cameron Tringale",69,71,"12:40:00","-","E","F",-2,140,null,null,null,null,null,null,33,{"$f":"SUBSTITUTE(INDEX($A:$J,R33,$S$2),\"*\",\"\")","v":"Cameron Tringale"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R33,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R33,$U$2)+TIME(5,0,0))","v":"17:40:00"},"F"]
[null,"T26","J.B. Holmes",68,72,"12:40:00","-",1,"F",-2,140,null,null,null,null,null,null,34,{"$f":"SUBSTITUTE(INDEX($A:$J,R34,$S$2),\"*\",\"\")","v":"J.B. Holmes"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R34,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R34,$U$2)+TIME(5,0,0))","v":"17:40:00"},"F"]
[null,"T26","Geoff Ogilvy",69,71,"12:30:00","-","E","F",-2,140,null,null,null,null,null,null,35,{"$f":"SUBSTITUTE(INDEX($A:$J,R35,$S$2),\"*\",\"\")","v":"Geoff Ogilvy"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R35,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R35,$U$2)+TIME(5,0,0))","v":"17:30:00"},"F"]
[null,"T26","Robert Karlsson",71,69,"12:30:00","-",-2,"F",-2,140,null,null,null,null,null,null,36,{"$f":"SUBSTITUTE(INDEX($A:$J,R36,$S$2),\"*\",\"\")","v":"Robert Karlsson"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R36,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R36,$U$2)+TIME(5,0,0))","v":"17:30:00"},"F"]
[null,"T26","Ernie Els",70,70,"12:20:00","-",-1,"F",-2,140,null,null,null,null,null,null,37,{"$f":"SUBSTITUTE(INDEX($A:$J,R37,$S$2),\"*\",\"\")","v":"Ernie Els"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R37,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R37,$U$2)+TIME(5,0,0))","v":"17:20:00"},"F"]
[null,"T26","Brendon de Jonge",70,70,"12:20:00","-",-1,"F",-2,140,null,null,null,null,null,null,38,{"$f":"SUBSTITUTE(INDEX($A:$J,R38,$S$2),\"*\",\"\")","v":"Brendon de Jonge"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R38,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R38,$U$2)+TIME(5,0,0))","v":"17:20:00"},"F"]
[null,"T26","Adam Scott",71,69,"12:00:00","-",-2,"F",-2,140,null,null,null,null,null,null,39,{"$f":"SUBSTITUTE(INDEX($A:$J,R39,$S$2),\"*\",\"\")","v":"Adam Scott"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R39,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R39,$U$2)+TIME(5,0,0))","v":"17:00:00"},"F"]
[null,"T26","Jimmy Walker",69,71,"12:00:00","-","E","F",-2,140,null,null,null,null,null,null,40,{"$f":"SUBSTITUTE(INDEX($A:$J,R40,$S$2),\"*\",\"\")","v":"Jimmy Walker"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R40,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R40,$U$2)+TIME(5,0,0))","v":"17:00:00"},"F"]
[null,"T26","Brian Harman",71,69,"11:50:00","-",-2,"F",-2,140,null,null,null,null,null,null,41,{"$f":"SUBSTITUTE(INDEX($A:$J,R41,$S$2),\"*\",\"\")","v":"Brian Harman"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R41,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R41,$U$2)+TIME(5,0,0))","v":"16:50:00"},"F"]
[null,"T26","Charl Schwartzel",72,68,"11:50:00","-",-3,"F",-2,140,null,null,null,null,null,null,42,{"$f":"SUBSTITUTE(INDEX($A:$J,R42,$S$2),\"*\",\"\")","v":"Charl Schwartzel"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R42,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R42,$U$2)+TIME(5,0,0))","v":"16:50:00"},"F"]
[null,"T26","Rafael Cabrera-Bello",69,71,"11:40:00","-","E","F",-2,140,null,null,null,null,null,null,43,{"$f":"SUBSTITUTE(INDEX($A:$J,R43,$S$2),\"*\",\"\")","v":"Rafael Cabrera-Bello"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R43,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R43,$U$2)+TIME(5,0,0))","v":"16:40:00"},"F"]
[null,"T38","Scott Brown",71,70,"11:40:00","-",-1,"F",-1,141,null,null,null,null,null,null,44,{"$f":"SUBSTITUTE(INDEX($A:$J,R44,$S$2),\"*\",\"\")","v":"Scott Brown"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R44,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R44,$U$2)+TIME(5,0,0))","v":"16:40:00"},"F"]
[null,"T38","Jonas Blixt",71,70,"11:30:00","-",-1,"F",-1,141,null,null,null,null,null,null,45,{"$f":"SUBSTITUTE(INDEX($A:$J,R45,$S$2),\"*\",\"\")","v":"Jonas Blixt"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R45,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R45,$U$2)+TIME(5,0,0))","v":"16:30:00"},"F"]
[null,"T38","Danny Willett",68,73,"11:20:00","-",2,"F",-1,141,null,null,null,null,null,null,46,{"$f":"SUBSTITUTE(INDEX($A:$J,R46,$S$2),\"*\",\"\")","v":"Danny Willett"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R46,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R46,$U$2)+TIME(5,0,0))","v":"16:20:00"},"F"]
[null,"T38","Fabrizio Zanotti",71,70,"11:30:00","-",-1,"F",-1,141,null,null,null,null,null,null,47,{"$f":"SUBSTITUTE(INDEX($A:$J,R47,$S$2),\"*\",\"\")","v":"Fabrizio Zanotti"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R47,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R47,$U$2)+TIME(5,0,0))","v":"16:30:00"},"F"]
[null,"T38","Gonzalo Fernandez-Casta",71,70,"11:20:00","-",-1,"F",-1,141,null,null,null,null,null,null,48,{"$f":"SUBSTITUTE(INDEX($A:$J,R48,$S$2),\"*\",\"\")","v":"Gonzalo Fernandez-Casta"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R48,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R48,$U$2)+TIME(5,0,0))","v":"16:20:00"},"F"]
[null,"T38","Ryan Moore",73,68,"11:10:00","-",-3,"F",-1,141,null,null,null,null,null,null,49,{"$f":"SUBSTITUTE(INDEX($A:$J,R49,$S$2),\"*\",\"\")","v":"Ryan Moore"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R49,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R49,$U$2)+TIME(5,0,0))","v":"16:10:00"},"F"]
[null,"T38","Kenny Perry",72,69,"11:10:00","-",-2,"F",-1,141,null,null,null,null,null,null,50,{"$f":"SUBSTITUTE(INDEX($A:$J,R50,$S$2),\"*\",\"\")","v":"Kenny Perry"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R50,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R50,$U$2)+TIME(5,0,0))","v":"16:10:00"},"F"]
[null,"T38","Hunter Mahan",70,71,"11:00:00","-","E","F",-1,141,null,null,null,null,null,null,51,{"$f":"SUBSTITUTE(INDEX($A:$J,R51,$S$2),\"*\",\"\")","v":"Hunter Mahan"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R51,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R51,$U$2)+TIME(5,0,0))","v":"16:00:00"},"F"]
[null,"T38","Jerry Kelly",67,74,"11:00:00","-",3,"F",-1,141,null,null,null,null,null,null,52,{"$f":"SUBSTITUTE(INDEX($A:$J,R52,$S$2),\"*\",\"\")","v":"Jerry Kelly"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R52,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R52,$U$2)+TIME(5,0,0))","v":"16:00:00"},"F"]
[null,"T38","Patrick Reed",70,71,"10:50:00","-","E","F",-1,141,null,null,null,null,null,null,53,{"$f":"SUBSTITUTE(INDEX($A:$J,R53,$S$2),\"*\",\"\")","v":"Patrick Reed"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R53,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R53,$U$2)+TIME(5,0,0))","v":"15:50:00"},"F"]
[null,"T38","Fredrik Jacobson",72,69,"10:50:00","-",-2,"F",-1,141,null,null,null,null,null,null,54,{"$f":"SUBSTITUTE(INDEX($A:$J,R54,$S$2),\"*\",\"\")","v":"Fredrik Jacobson"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R54,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R54,$U$2)+TIME(5,0,0))","v":"15:50:00"},"F"]
[null,"T38","Ian Poulter",68,73,"10:30:00","-",2,"F",-1,141,null,null,null,null,null,null,55,{"$f":"SUBSTITUTE(INDEX($A:$J,R55,$S$2),\"*\",\"\")","v":"Ian Poulter"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R55,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R55,$U$2)+TIME(5,0,0))","v":"15:30:00"},"F"]
[null,"T38","Brandt Snedeker",73,68,"10:30:00","-",-3,"F",-1,141,null,null,null,null,null,null,56,{"$f":"SUBSTITUTE(INDEX($A:$J,R56,$S$2),\"*\",\"\")","v":"Brandt Snedeker"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R56,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R56,$U$2)+TIME(5,0,0))","v":"15:30:00"},"F"]
[null,"T38","Kevin Stadler",71,70,"10:20:00","-",-1,"F",-1,141,null,null,null,null,null,null,57,{"$f":"SUBSTITUTE(INDEX($A:$J,R57,$S$2),\"*\",\"\")","v":"Kevin Stadler"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R57,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R57,$U$2)+TIME(5,0,0))","v":"15:20:00"},"F"]
[null,"T38","Brendan Steele",71,70,"10:20:00","-",-1,"F",-1,141,null,null,null,null,null,null,58,{"$f":"SUBSTITUTE(INDEX($A:$J,R58,$S$2),\"*\",\"\")","v":"Brendan Steele"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R58,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R58,$U$2)+TIME(5,0,0))","v":"15:20:00"},"F"]
[null,"T53","Shane Lowry",68,74,"10:10:00","-",3,"F","E",142,null,null,null,null,null,null,59,{"$f":"SUBSTITUTE(INDEX($A:$J,R59,$S$2),\"*\",\"\")","v":"Shane Lowry"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R59,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R59,$U$2)+TIME(5,0,0))","v":"15:10:00"},"F"]
[null,"T53","Sergio Garcia",70,72,"10:10:00","-",1,"F","E",142,null,null,null,null,null,null,60,{"$f":"SUBSTITUTE(INDEX($A:$J,R60,$S$2),\"*\",\"\")","v":"Sergio Garcia"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R60,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R60,$U$2)+TIME(5,0,0))","v":"15:10:00"},"F"]
[null,"T53","Bubba Watson",70,72,"10:00:00","-",1,"F","E",142,null,null,null,null,null,null,61,{"$f":"SUBSTITUTE(INDEX($A:$J,R61,$S$2),\"*\",\"\")","v":"Bubba Watson"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R61,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R61,$U$2)+TIME(5,0,0))","v":"15:00:00"},"F"]
[null,"T53","Thorbjorn Olesen",71,71,"10:00:00","-","E","F","E",142,null,null,null,null,null,null,62,{"$f":"SUBSTITUTE(INDEX($A:$J,R62,$S$2),\"*\",\"\")","v":"Thorbjorn Olesen"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R62,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R62,$U$2)+TIME(5,0,0))","v":"15:00:00"},"F"]
[null,"T53","Luke Donald",70,72,"09:50:00","-",1,"F","E",142,null,null,null,null,null,null,63,{"$f":"SUBSTITUTE(INDEX($A:$J,R63,$S$2),\"*\",\"\")","v":"Luke Donald"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R63,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R63,$U$2)+TIME(5,0,0))","v":"14:50:00"},"F"]
[null,"T53","Francesco Molinari",71,71,"09:50:00","-","E","F","E",142,null,null,null,null,null,null,64,{"$f":"SUBSTITUTE(INDEX($A:$J,R64,$S$2),\"*\",\"\")","v":"Francesco Molinari"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R64,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R64,$U$2)+TIME(5,0,0))","v":"14:50:00"},"F"]
[null,"T53","Zach Johnson",70,72,"09:40:00","-",1,"F","E",142,null,null,null,null,null,null,65,{"$f":"SUBSTITUTE(INDEX($A:$J,R65,$S$2),\"*\",\"\")","v":"Zach Johnson"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R65,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R65,$U$2)+TIME(5,0,0))","v":"14:40:00"},"F"]
[null,"T53","Daniel Summerhays",70,72,"09:40:00","-",1,"F","E",142,null,null,null,null,null,null,66,{"$f":"SUBSTITUTE(INDEX($A:$J,R66,$S$2),\"*\",\"\")","v":"Daniel Summerhays"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R66,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R66,$U$2)+TIME(5,0,0))","v":"14:40:00"},"F"]
[null,"T53","Jason Bohn",71,71,"09:30:00","-","E","F","E",142,null,null,null,null,null,null,67,{"$f":"SUBSTITUTE(INDEX($A:$J,R67,$S$2),\"*\",\"\")","v":"Jason Bohn"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R67,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R67,$U$2)+TIME(5,0,0))","v":"14:30:00"},"F"]
[null,"T53","Koumei Oda",74,68,"09:30:00","-",-3,"F","E",142,null,null,null,null,null,null,68,{"$f":"SUBSTITUTE(INDEX($A:$J,R68,$S$2),\"*\",\"\")","v":"Koumei Oda"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R68,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R68,$U$2)+TIME(5,0,0))","v":"14:30:00"},"F"]
[null,"T53","Colin Montgomerie",70,72,"09:20:00","-",1,"F","E",142,null,null,null,null,null,null,69,{"$f":"SUBSTITUTE(INDEX($A:$J,R69,$S$2),\"*\",\"\")","v":"Colin Montgomerie"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R69,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R69,$U$2)+TIME(5,0,0))","v":"14:20:00"},"F"]
[null,"T53","Brooks Koepka",71,71,"09:20:00","-","E","F","E",142,null,null,null,null,null,null,70,{"$f":"SUBSTITUTE(INDEX($A:$J,R70,$S$2),\"*\",\"\")","v":"Brooks Koepka"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R70,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R70,$U$2)+TIME(5,0,0))","v":"14:20:00"},"F"]
[null,"T53","Justin Rose",70,72,"09:10:00","-",1,"F","E",142,null,null,null,null,null,null,71,{"$f":"SUBSTITUTE(INDEX($A:$J,R71,$S$2),\"*\",\"\")","v":"Justin Rose"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R71,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R71,$U$2)+TIME(5,0,0))","v":"14:10:00"},"F"]
[null,"T53","Marc Leishman",71,71,"09:10:00","-","E","F","E",142,null,null,null,null,null,null,72,{"$f":"SUBSTITUTE(INDEX($A:$J,R72,$S$2),\"*\",\"\")","v":"Marc Leishman"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R72,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R72,$U$2)+TIME(5,0,0))","v":"14:10:00"},"F"]
[null,"T53","Marc Warren",71,71,"09:00:00","-","E","F","E",142,null,null,null,null,null,null,{"$f":"R72+1","v":73},{"$f":"SUBSTITUTE(INDEX($A:$J,R73,$S$2),\"*\",\"\")","v":"Marc Warren"},{"$f":"IF(INDEX($A:$L,R73,$T$2)=\"E\",0,IF(INDEX($A:$L,R73,$T$2)=\"MC\",100,INDEX($A:$L,R73,$T$2)))","v":0},{"$f":"IF(ISERROR(INDEX($A:$J,R73,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R73,$U$2)+TIME(5,0,0))","v":"14:00:00"},{"$f":"INDEX($A:$N,R73,$V$2)","v":"F"}]
[null,"T53","Pat Perez",71,71,"09:00:00","-","E","F","E",142,null,null,null,null,null,null,74,{"$f":"SUBSTITUTE(INDEX($A:$J,R74,$S$2),\"*\",\"\")","v":"Pat Perez"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R74,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R74,$U$2)+TIME(5,0,0))","v":"14:00:00"},"F"]
[null,"T69","Shawn Stefani",68,75,"08:50:00","-",4,"F",1,143,null,null,null,null,null,null,75,{"$f":"SUBSTITUTE(INDEX($A:$J,R75,$S$2),\"*\",\"\")","v":"Shawn Stefani"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R75,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R75,$U$2)+TIME(5,0,0))","v":"13:50:00"},"F"]
[null,"T69","Branden Grace",73,70,"08:50:00","-",-1,"F",1,143,null,null,null,null,null,null,76,{"$f":"SUBSTITUTE(INDEX($A:$J,R76,$S$2),\"*\",\"\")","v":"Branden Grace"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R76,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R76,$U$2)+TIME(5,0,0))","v":"13:50:00"},"F"]
[null,"T69","Chris Stroud",70,73,"08:40:00","-",2,"F",1,143,null,null,null,null,null,null,77,{"$f":"SUBSTITUTE(INDEX($A:$J,R77,$S$2),\"*\",\"\")","v":"Chris Stroud"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R77,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R77,$U$2)+TIME(5,0,0))","v":"13:40:00"},"F"]
[null,"T69","Hideki Matsuyama",71,72,"08:40:00","-",1,"F",1,143,null,null,null,null,null,null,78,{"$f":"SUBSTITUTE(INDEX($A:$J,R78,$S$2),\"*\",\"\")","v":"Hideki Matsuyama"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R78,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R78,$U$2)+TIME(5,0,0))","v":"13:40:00"},"F"]
[null,"T69","Brendon Todd",70,73,"08:30:00","-",2,"F",1,143,null,null,null,null,null,null,79,{"$f":"SUBSTITUTE(INDEX($A:$J,R79,$S$2),\"*\",\"\")","v":"Brendon Todd"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R79,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R79,$U$2)+TIME(5,0,0))","v":"13:30:00"},"F"]
[null,"T69","Graeme McDowell",73,70,"08:30:00","-",-1,"F",1,143,null,null,null,null,null,null,80,{"$f":"SUBSTITUTE(INDEX($A:$J,R80,$S$2),\"*\",\"\")","v":"Graeme McDowell"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R80,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R80,$U$2)+TIME(5,0,0))","v":"13:30:00"},"F"]
[null,"WD","Jason Dufner","WD","WD","WD","WD","WD","-","WD","WD",null,null,null,null,null,null,81,{"$f":"SUBSTITUTE(INDEX($A:$J,R81,$S$2),\"*\",\"\")","v":"Jason Dufner"},"WD",{"$f":"IF(ISERROR(INDEX($A:$J,R81,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R81,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Charley Hoffman",70,74,"MC","MC","-","-","-",144,null,null,null,null,null,null,82,{"$f":"SUBSTITUTE(INDEX($A:$J,R82,$S$2),\"*\",\"\")","v":"Charley Hoffman"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R82,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R82,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Erik Compton",71,73,"MC","MC","-","-","-",144,null,null,null,null,null,null,83,{"$f":"SUBSTITUTE(INDEX($A:$J,R83,$S$2),\"*\",\"\")","v":"Erik Compton"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R83,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R83,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Gary Woodland",72,72,"MC","MC","-","-","-",144,null,null,null,null,null,null,84,{"$f":"SUBSTITUTE(INDEX($A:$J,R84,$S$2),\"*\",\"\")","v":"Gary Woodland"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R84,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R84,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Scott Piercy",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,85,{"$f":"SUBSTITUTE(INDEX($A:$J,R85,$S$2),\"*\",\"\")","v":"Scott Piercy"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R85,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R85,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Martin Kaymer",70,74,"MC","MC","-","-","-",144,null,null,null,null,null,null,86,{"$f":"SUBSTITUTE(INDEX($A:$J,R86,$S$2),\"*\",\"\")","v":"Martin Kaymer"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R86,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R86,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Tommy Fleetwood",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,87,{"$f":"SUBSTITUTE(INDEX($A:$J,R87,$S$2),\"*\",\"\")","v":"Tommy Fleetwood"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R87,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R87,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Tim Clark",70,74,"MC","MC","-","-","-",144,null,null,null,null,null,null,88,{"$f":"SUBSTITUTE(INDEX($A:$J,R88,$S$2),\"*\",\"\")","v":"Tim Clark"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R88,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R88,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Padraig Harrington",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,89,{"$f":"SUBSTITUTE(INDEX($A:$J,R89,$S$2),\"*\",\"\")","v":"Padraig Harrington"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R89,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R89,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Ryan Helminen",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,90,{"$f":"SUBSTITUTE(INDEX($A:$J,R90,$S$2),\"*\",\"\")","v":"Ryan Helminen"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R90,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R90,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T75","Russell Henley",69,75,"MC","MC","-","-","-",144,null,null,null,null,null,null,91,{"$f":"SUBSTITUTE(INDEX($A:$J,R91,$S$2),\"*\",\"\")","v":"Russell Henley"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R91,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R91,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Anirban Lahiri",72,73,"MC","MC","-","-","-",145,null,null,null,null,null,null,92,{"$f":"SUBSTITUTE(INDEX($A:$J,R92,$S$2),\"*\",\"\")","v":"Anirban Lahiri"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R92,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R92,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Tom Watson",72,73,"MC","MC","-","-","-",145,null,null,null,null,null,null,93,{"$f":"SUBSTITUTE(INDEX($A:$J,R93,$S$2),\"*\",\"\")","v":"Tom Watson"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R93,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R93,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Davis Love III",72,73,"MC","MC","-","-","-",145,null,null,null,null,null,null,94,{"$f":"SUBSTITUTE(INDEX($A:$J,R94,$S$2),\"*\",\"\")","v":"Davis Love III"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R94,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R94,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Seung-yul Noh",68,77,"MC","MC","-","-","-",145,null,null,null,null,null,null,95,{"$f":"SUBSTITUTE(INDEX($A:$J,R95,$S$2),\"*\",\"\")","v":"Seung-yul Noh"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R95,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R95,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Johan Kok",78,67,"MC","MC","-","-","-",145,null,null,null,null,null,null,96,{"$f":"SUBSTITUTE(INDEX($A:$J,R96,$S$2),\"*\",\"\")","v":"Johan Kok"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R96,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R96,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Ben Martin",74,71,"MC","MC","-","-","-",145,null,null,null,null,null,null,97,{"$f":"SUBSTITUTE(INDEX($A:$J,R97,$S$2),\"*\",\"\")","v":"Ben Martin"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R97,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R97,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Russell Knox",75,70,"MC","MC","-","-","-",145,null,null,null,null,null,null,98,{"$f":"SUBSTITUTE(INDEX($A:$J,R98,$S$2),\"*\",\"\")","v":"Russell Knox"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R98,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R98,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Brian Stuard",71,74,"MC","MC","-","-","-",145,null,null,null,null,null,null,99,{"$f":"SUBSTITUTE(INDEX($A:$J,R99,$S$2),\"*\",\"\")","v":"Brian Stuard"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R99,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R99,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Matt Every",73,72,"MC","MC","-","-","-",145,null,null,null,null,null,null,100,{"$f":"SUBSTITUTE(INDEX($A:$J,R100,$S$2),\"*\",\"\")","v":"Matt Every"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R100,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R100,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T85","Kevin Streelman",69,76,"MC","MC","-","-","-",145,null,null,null,null,null,null,101,{"$f":"SUBSTITUTE(INDEX($A:$J,R101,$S$2),\"*\",\"\")","v":"Kevin Streelman"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R101,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R101,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Ryo Ishikawa",72,74,"MC","MC","-","-","-",146,null,null,null,null,null,null,102,{"$f":"SUBSTITUTE(INDEX($A:$J,R102,$S$2),\"*\",\"\")","v":"Ryo Ishikawa"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R102,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R102,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Rory Sabbatini",75,71,"MC","MC","-","-","-",146,null,null,null,null,null,null,103,{"$f":"SUBSTITUTE(INDEX($A:$J,R103,$S$2),\"*\",\"\")","v":"Rory Sabbatini"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R103,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R103,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Stuart Deane",75,71,"MC","MC","-","-","-",146,null,null,null,null,null,null,104,{"$f":"SUBSTITUTE(INDEX($A:$J,R104,$S$2),\"*\",\"\")","v":"Stuart Deane"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R104,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R104,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","David Hearn",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,105,{"$f":"SUBSTITUTE(INDEX($A:$J,R105,$S$2),\"*\",\"\")","v":"David Hearn"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R105,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R105,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Keegan Bradley",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,106,{"$f":"SUBSTITUTE(INDEX($A:$J,R106,$S$2),\"*\",\"\")","v":"Keegan Bradley"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R106,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R106,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Y.E. Yang",75,71,"MC","MC","-","-","-",146,null,null,null,null,null,null,107,{"$f":"SUBSTITUTE(INDEX($A:$J,R107,$S$2),\"*\",\"\")","v":"Y.E. Yang"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R107,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R107,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Chris Kirk",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,108,{"$f":"SUBSTITUTE(INDEX($A:$J,R108,$S$2),\"*\",\"\")","v":"Chris Kirk"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R108,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R108,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Hideto Tanihara",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,109,{"$f":"SUBSTITUTE(INDEX($A:$J,R109,$S$2),\"*\",\"\")","v":"Hideto Tanihara"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R109,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R109,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Paul Casey",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,110,{"$f":"SUBSTITUTE(INDEX($A:$J,R110,$S$2),\"*\",\"\")","v":"Paul Casey"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R110,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R110,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Kevin Na",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,111,{"$f":"SUBSTITUTE(INDEX($A:$J,R111,$S$2),\"*\",\"\")","v":"Kevin Na"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R111,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R111,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Steven Bowditch",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,112,{"$f":"SUBSTITUTE(INDEX($A:$J,R112,$S$2),\"*\",\"\")","v":"Steven Bowditch"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R112,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R112,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Roberto Castro",73,73,"MC","MC","-","-","-",146,null,null,null,null,null,null,113,{"$f":"SUBSTITUTE(INDEX($A:$J,R113,$S$2),\"*\",\"\")","v":"Roberto Castro"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R113,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R113,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Jamie Broce",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,114,{"$f":"SUBSTITUTE(INDEX($A:$J,R114,$S$2),\"*\",\"\")","v":"Jamie Broce"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R114,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R114,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Ross Fisher",73,73,"MC","MC","-","-","-",146,null,null,null,null,null,null,115,{"$f":"SUBSTITUTE(INDEX($A:$J,R115,$S$2),\"*\",\"\")","v":"Ross Fisher"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R115,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R115,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T95","Harris English",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,116,{"$f":"SUBSTITUTE(INDEX($A:$J,R116,$S$2),\"*\",\"\")","v":"Harris English"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R116,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R116,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","Eric Williamson",74,73,"MC","MC","-","-","-",147,null,null,null,null,null,null,117,{"$f":"SUBSTITUTE(INDEX($A:$J,R117,$S$2),\"*\",\"\")","v":"Eric Williamson"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R117,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R117,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","Webb Simpson",73,74,"MC","MC","-","-","-",147,null,null,null,null,null,null,118,{"$f":"SUBSTITUTE(INDEX($A:$J,R118,$S$2),\"*\",\"\")","v":"Webb Simpson"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R118,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R118,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","Chesson Hadley",74,73,"MC","MC","-","-","-",147,null,null,null,null,null,null,119,{"$f":"SUBSTITUTE(INDEX($A:$J,R119,$S$2),\"*\",\"\")","v":"Chesson Hadley"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R119,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R119,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","Charles Howell III",73,74,"MC","MC","-","-","-",147,null,null,null,null,null,null,120,{"$f":"SUBSTITUTE(INDEX($A:$J,R120,$S$2),\"*\",\"\")","v":"Charles Howell III"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R120,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R120,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","George Coetzee",73,74,"MC","MC","-","-","-",147,null,null,null,null,null,null,121,{"$f":"SUBSTITUTE(INDEX($A:$J,R121,$S$2),\"*\",\"\")","v":"George Coetzee"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R121,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R121,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","Stewart Cink",72,75,"MC","MC","-","-","-",147,null,null,null,null,null,null,122,{"$f":"SUBSTITUTE(INDEX($A:$J,R122,$S$2),\"*\",\"\")","v":"Stewart Cink"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R122,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R122,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T110","Stephen Gallacher",70,77,"MC","MC","-","-","-",147,null,null,null,null,null,null,123,{"$f":"SUBSTITUTE(INDEX($A:$J,R123,$S$2),\"*\",\"\")","v":"Stephen Gallacher"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R123,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R123,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","Darren Clarke",79,69,"MC","MC","-","-","-",148,null,null,null,null,null,null,124,{"$f":"SUBSTITUTE(INDEX($A:$J,R124,$S$2),\"*\",\"\")","v":"Darren Clarke"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R124,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R124,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","Pablo Larrazabal",79,69,"MC","MC","-","-","-",148,null,null,null,null,null,null,125,{"$f":"SUBSTITUTE(INDEX($A:$J,R125,$S$2),\"*\",\"\")","v":"Pablo Larrazabal"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R125,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R125,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","Jordan Spieth",71,77,"MC","MC","-","-","-",148,null,null,null,null,null,null,126,{"$f":"SUBSTITUTE(INDEX($A:$J,R126,$S$2),\"*\",\"\")","v":"Jordan Spieth"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R126,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R126,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","John Daly",76,72,"MC","MC","-","-","-",148,null,null,null,null,null,null,127,{"$f":"SUBSTITUTE(INDEX($A:$J,R127,$S$2),\"*\",\"\")","v":"John Daly"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R127,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R127,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","Tiger Woods",74,74,"MC","MC","-","-","-",148,null,null,null,null,null,null,128,{"$f":"SUBSTITUTE(INDEX($A:$J,R128,$S$2),\"*\",\"\")","v":"Tiger Woods"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R128,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R128,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","Hyung-Sung Kim",73,75,"MC","MC","-","-","-",148,null,null,null,null,null,null,129,{"$f":"SUBSTITUTE(INDEX($A:$J,R129,$S$2),\"*\",\"\")","v":"Hyung-Sung Kim"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R129,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R129,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T117","George McNeill",73,75,"MC","MC","-","-","-",148,null,null,null,null,null,null,130,{"$f":"SUBSTITUTE(INDEX($A:$J,R130,$S$2),\"*\",\"\")","v":"George McNeill"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R130,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R130,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T124","Scott Stallings",71,78,"MC","MC","-","-","-",149,null,null,null,null,null,null,131,{"$f":"SUBSTITUTE(INDEX($A:$J,R131,$S$2),\"*\",\"\")","v":"Scott Stallings"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R131,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R131,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T124","John Senden",75,74,"MC","MC","-","-","-",149,null,null,null,null,null,null,132,{"$f":"SUBSTITUTE(INDEX($A:$J,R132,$S$2),\"*\",\"\")","v":"John Senden"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R132,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R132,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T124","Rod Perry",74,75,"MC","MC","-","-","-",149,null,null,null,null,null,null,133,{"$f":"SUBSTITUTE(INDEX($A:$J,R133,$S$2),\"*\",\"\")","v":"Rod Perry"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R133,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R133,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T124","Miguel Angel Jimenez",72,77,"MC","MC","-","-","-",149,null,null,null,null,null,null,134,{"$f":"SUBSTITUTE(INDEX($A:$J,R134,$S$2),\"*\",\"\")","v":"Miguel Angel Jimenez"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R134,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R134,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T128","Bob Sowards",75,75,"MC","MC","-","-","-",150,null,null,null,null,null,null,135,{"$f":"SUBSTITUTE(INDEX($A:$J,R135,$S$2),\"*\",\"\")","v":"Bob Sowards"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R135,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R135,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T128","Will MacKenzie",76,74,"MC","MC","-","-","-",150,null,null,null,null,null,null,136,{"$f":"SUBSTITUTE(INDEX($A:$J,R136,$S$2),\"*\",\"\")","v":"Will MacKenzie"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R136,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R136,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T128","Steve Schneiter",72,78,"MC","MC","-","-","-",150,null,null,null,null,null,null,{"$f":"R136+1","v":137},{"$f":"SUBSTITUTE(INDEX($A:$J,R137,$S$2),\"*\",\"\")","v":"Steve Schneiter"},{"$f":"IF(INDEX($A:$L,R137,$T$2)=\"E\",0,IF(INDEX($A:$L,R137,$T$2)=\"MC\",100,INDEX($A:$L,R137,$T$2)))","v":"-"},{"$f":"IF(ISERROR(INDEX($A:$J,R137,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R137,$U$2)+TIME(5,0,0))","v":""},{"$f":"INDEX($A:$N,R137,$V$2)","v":"-"}]
[null,"T128","Thongchai Jaidee",71,79,"MC","MC","-","-","-",150,null,null,null,null,null,null,138,{"$f":"SUBSTITUTE(INDEX($A:$J,R138,$S$2),\"*\",\"\")","v":"Thongchai Jaidee"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R138,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R138,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T128","Thomas Bjorn",75,75,"MC","MC","-","-","-",150,null,null,null,null,null,null,139,{"$f":"SUBSTITUTE(INDEX($A:$J,R139,$S$2),\"*\",\"\")","v":"Thomas Bjorn"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R139,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R139,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T133","Michael Block",77,74,"MC","MC","-","-","-",151,null,null,null,null,null,null,140,{"$f":"SUBSTITUTE(INDEX($A:$J,R140,$S$2),\"*\",\"\")","v":"Michael Block"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R140,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R140,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T133","Shaun Micheel",72,79,"MC","MC","-","-","-",151,null,null,null,null,null,null,141,{"$f":"SUBSTITUTE(INDEX($A:$J,R141,$S$2),\"*\",\"\")","v":"Shaun Micheel"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R141,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R141,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T133","K.J. Choi",72,79,"MC","MC","-","-","-",151,null,null,null,null,null,null,142,{"$f":"SUBSTITUTE(INDEX($A:$J,R142,$S$2),\"*\",\"\")","v":"K.J. Choi"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R142,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R142,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T133","John Huh",78,73,"MC","MC","-","-","-",151,null,null,null,null,null,null,143,{"$f":"SUBSTITUTE(INDEX($A:$J,R143,$S$2),\"*\",\"\")","v":"John Huh"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R143,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R143,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T133","Jason Kokrak",78,73,"MC","MC","-","-","-",151,null,null,null,null,null,null,144,{"$f":"SUBSTITUTE(INDEX($A:$J,R144,$S$2),\"*\",\"\")","v":"Jason Kokrak"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R144,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R144,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,138,"Brian Norman",78,74,"MC","MC","-","-","-",152,null,null,null,null,null,null,145,{"$f":"SUBSTITUTE(INDEX($A:$J,R145,$S$2),\"*\",\"\")","v":"Brian Norman"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R145,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R145,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T139","Rich Beem",74,79,"MC","MC","-","-","-",153,null,null,null,null,null,null,146,{"$f":"SUBSTITUTE(INDEX($A:$J,R146,$S$2),\"*\",\"\")","v":"Rich Beem"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R146,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R146,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T139","Rob Corcoran",76,77,"MC","MC","-","-","-",153,null,null,null,null,null,null,147,{"$f":"SUBSTITUTE(INDEX($A:$J,R147,$S$2),\"*\",\"\")","v":"Rob Corcoran"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R147,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R147,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T141","Matteo Manassero",80,77,"MC","MC","-","-","-",157,null,null,null,null,null,null,148,{"$f":"SUBSTITUTE(INDEX($A:$J,R148,$S$2),\"*\",\"\")","v":"Matteo Manassero"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R148,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R148,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T141","Jim McGovern",83,74,"MC","MC","-","-","-",157,null,null,null,null,null,null,149,{"$f":"SUBSTITUTE(INDEX($A:$J,R149,$S$2),\"*\",\"\")","v":"Jim McGovern"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R149,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R149,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T141","Mark Brooks",78,79,"MC","MC","-","-","-",157,null,null,null,null,null,null,150,{"$f":"SUBSTITUTE(INDEX($A:$J,R150,$S$2),\"*\",\"\")","v":"Mark Brooks"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R150,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R150,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T141","David McNabb",77,80,"MC","MC","-","-","-",157,null,null,null,null,null,null,151,{"$f":"SUBSTITUTE(INDEX($A:$J,R151,$S$2),\"*\",\"\")","v":"David McNabb"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R151,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R151,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T145","Dave Tentis",79,79,"MC","MC","-","-","-",158,null,null,null,null,null,null,152,{"$f":"SUBSTITUTE(INDEX($A:$J,R152,$S$2),\"*\",\"\")","v":"Dave Tentis"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R152,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R152,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T145","David Hronek",81,77,"MC","MC","-","-","-",158,null,null,null,null,null,null,153,{"$f":"SUBSTITUTE(INDEX($A:$J,R153,$S$2),\"*\",\"\")","v":"David Hronek"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R153,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R153,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T145","Jerry Smith",80,78,"MC","MC","-","-","-",158,null,null,null,null,null,null,154,{"$f":"SUBSTITUTE(INDEX($A:$J,R154,$S$2),\"*\",\"\")","v":"Jerry Smith"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R154,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R154,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T148","Frank Esposito",83,78,"MC","MC","-","-","-",161,null,null,null,null,null,null,155,{"$f":"SUBSTITUTE(INDEX($A:$J,R155,$S$2),\"*\",\"\")","v":"Frank Esposito"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R155,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R155,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,"T148","Aaron Krueger",84,77,"MC","MC","-","-","-",161,null,null,null,null,null,null,156,{"$f":"SUBSTITUTE(INDEX($A:$J,R156,$S$2),\"*\",\"\")","v":"Aaron Krueger"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R156,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R156,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,150,"Dustin Volk",81,82,"MC","MC","-","-","-",163,null,null,null,null,null,null,157,{"$f":"SUBSTITUTE(INDEX($A:$J,R157,$S$2),\"*\",\"\")","v":"Dustin Volk"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R157,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R157,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,151,"Matt Pesta",79,89,"MC","MC","-","-","-",168,null,null,null,null,null,null,158,{"$f":"SUBSTITUTE(INDEX($A:$J,R158,$S$2),\"*\",\"\")","v":"Matt Pesta"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R158,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R158,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,152,"Kiradech Aphibarnrat",72,32,"WD","WD","-","-","-",104,null,null,null,null,null,null,159,{"$f":"SUBSTITUTE(INDEX($A:$J,R159,$S$2),\"*\",\"\")","v":"Kiradech Aphibarnrat"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R159,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R159,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,153,"Boo Weekley",80,23,"WD","WD","-","-","-",103,null,null,null,null,null,null,160,{"$f":"SUBSTITUTE(INDEX($A:$J,R160,$S$2),\"*\",\"\")","v":"Boo Weekley"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R160,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R160,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,154,"Angel Cabrera",82,47,"WD","WD","-","-","-",129,null,null,null,null,null,null,161,{"$f":"SUBSTITUTE(INDEX($A:$J,R161,$S$2),\"*\",\"\")","v":"Angel Cabrera"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R161,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R161,$U$2)+TIME(5,0,0))","v":""},"-"]
[null,155,"Ben Crane",74,"WD","WD","WD","-","-","-",74,null,null,null,null,null,null,162,{"$f":"SUBSTITUTE(INDEX($A:$J,R162,$S$2),\"*\",\"\")","v":"Ben Crane"},"-",{"$f":"IF(ISERROR(INDEX($A:$J,R162,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R162,$U$2)+TIME(5,0,0))","v":""},"-"]

{"sheet":"ranks","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,"Positions"]
[]
["row","col","Player","Score","Score adj","Rank","Rank adj"]
[1,1,{"$f":"INDEX(results!$A$7:$Q$42,$A4,$B4)","v":"DEANO"},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+2)","v":-9},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+3)","v":-9.0440000000000005},{"$f":"IF(ISERROR(RANK(D4,$D$4:$D$14,1)),\"\",RANK(D4,$D$4:$D$14,1))","v":6},{"$f":"IF(ISERROR(RANK(E4,$E$4:$E$14,1)),\"\",RANK(E4,$E$4:$E$14,1))","v":6},null,"round 1","Player","Score","Score adj","Rank","Rank adj"]
[{"$f":"A4+9","v":10},1,{"$f":"INDEX(results!$A$7:$Q$42,$A5,$B5)","v":"TEZ"},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+2)","v":-10},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+3)","v":-10.034000000000001},5,{"$f":"IF(ISERROR(RANK(E5,$E$4:$E$14,1)),\"\",RANK(E5,$E$4:$E$14,1))","v":5},null,null,"BYRON",-9,-9.048,1,1]
[{"$f":"A5+9","v":19},1,{"$f":"INDEX(results!$A$7:$Q$42,$A6,$B6)","v":"BYRON"},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+2)","v":-11},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+3)","v":-11.048},3,3,null,null,"STEVER",-8,-8.0459999999999994,2,2]
[{"$f":"A6+9","v":28},1,{"$f":"INDEX(results!$A$7:$Q$42,$A7,$B7)","v":"STEVER"},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+2)","v":-14},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+3)","v":-14.045999999999999},1,1,null,null,"CRAIG T",-7,-7.0380000000000003,3,3]
[1,{"$f":"B4+6","v":7},{"$f":"INDEX(results!$A$7:$Q$42,$A8,$B8)","v":"JOHN C"},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+2)","v":-13},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+3)","v":-13.03},2,2,null,null,"TEZ",-7,-7.0339999999999998,3,4]
[{"$f":"A8+9","v":10},7,{"$f":"INDEX(results!$A$7:$Q$42,$A9,$B9)","v":"CRAIG T"},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+2)","v":-11},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+3)","v":-11.038},3,4,null,null,"JOHN C",-5,-5.03,5,5]
[{"$f":"A9+9","v":19},7,{"$f":"INDEX(results!$A$7:$Q$42,$A10,$B10)","v":"STUART D"},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+2)","v":-1},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+3)","v":-1.04},7,7,null,null,"DEANO",-4,-4.0439999999999996,6,6]
[{"$f":"A10+9","v":28},7,{"$f":"INDEX(results!$A$7:$Q$42,$A11,$B11)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+3)","v":""},"","",null,null,"STUART D",-1,-1.04,7,7]
[1,13,{"$f":"INDEX(results!$A$7:$Q$42,$A12,$B12)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A12+6,$B12+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A12+6,$B12+3)","v":""},"",""]
[10,13,{"$f":"INDEX(results!$A$7:$Q$42,$A13,$B13)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A13+6,$B13+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A13+6,$B13+3)","v":""},"",""]
[19,{"$f":"B9+6","v":13},{"$f":"INDEX(results!$A$7:$Q$42,$A14,$B14)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A14+6,$B14+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A14+6,$B14+3)","v":""},"","",null,"round 2","Player","Score","Score adj","Rank","Rank adj"]
[null,null,null,null,null,null,null,null,null,"STEVER",-14,-14.045999999999999,1,1]
[null,null,null,null,null,null,null,null,null,"JOHN C",-13,-13.03,2,2]
[null,null,null,null,null,null,null,null,null,"BYRON",-11,-11.048,3,3]
[null,null,"Put sorted scores here for posting to website",null,null,null,null,null,null,"CRAIG T",-11,-11.038,3,4]
[null,null,null,null,null,null,null,null,null,"TEZ",-10,-10.034000000000001,5,5]
[null,7,"Player","Score","Score adj","Rank","Rank adj",null,null,"DEANO",-9,-9.0440000000000005,6,6]
[null,13,"STEVER",-14,-14.045999999999999,1,1,null,null,"STUART D",-1,-1.04,7,7]
[null,1,"JOHN C",-13,-13.03,2,2]
[null,1,"BYRON",-11,-11.048,3,3]
[null,1,"CRAIG T",-11,-11.038,3,4]
[null,13,"TEZ",-10,-10.034000000000001,5,5]
[null,7,"DEANO",-9,-9.0440000000000005,6,6]
[null,1,"STUART D",-1,-1.04,7,7]
[null,7]
[null,7]
[null,13,"Dean","","","",""]
[null,null,"Shem","","","",""]
[]
[]
[]
[]
[]
[]
[null,null,"Average scores of picks","Avg","Rank"]
[null,null,"Pick 1",{"$f":"AVERAGE(results!C8,results!C17,results!C26,results!C35,results!I8,results!I17,results!I26,results!I35,results!O8,results!O17,results!O26,results!O35)","v":{"$error":"#REF!"}},{"$f":"RANK(D39,$D$39:$D$43,1)","v":{"$error":"#REF!"}}]
[null,null,"Pick 2",{"$f":"AVERAGE(results!C9,results!C18,results!C27,results!C36,results!I9,results!I18,results!I27,results!I36,results!O9,results!O18,results!O27,results!O36)","v":{"$error":"#N/A"}},{"$f":"RANK(D40,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[null,null,"Pick 3",{"$f":"AVERAGE(results!C10,results!C19,results!C28,results!C37,results!I10,results!I19,results!I28,results!I37,results!O10,results!O19,results!O28,results!O37)","v":{"$error":"#N/A"}},{"$f":"RANK(D41,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[null,null,"Pick 4",{"$f":"AVERAGE(results!C11,results!C20,results!C29,results!C38,results!I11,results!I20,results!I29,results!I38,results!O11,results!O20,results!O29,results!O38)","v":{"$error":"#N/A"}},{"$f":"RANK(D42,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[null,null,"Pick 5",{"$f":"AVERAGE(results!C12,results!C21,results!C30,results!C39,results!I12,results!I21,results!I30,results!I39,results!O12,results!O21,results!O30,results!O39)","v":{"$error":"#N/A"}},{"$f":"RANK(D43,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[]
[null,null,"NEEDS UPDATING"]

{"sheet":"BLANKS","index":3,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["The US PGA 2014"]
[]
[]
["Day 0"]
[]
[{"$f":"results!A7","v":"DEANO"},"Pick",null,{"$f":"results!G7","v":"JOHN C"},"Pick",null,{"$f":"results!M7","v":0},"Pick"]
[null,{"$f":"SUM(B8:B12)/5","v":4.4000000000000004},null,null,{"$f":"SUM(E8:E12)/5","v":3},null,null,{"$f":"SUM(H8:H12)/5","v":0}]
["Rickie Fowler",{"$f":"'random picks'!B90","v":3},null,"Sergio Garcia",{"$f":"'random picks'!F90","v":5},null,null,{"$f":"'random picks'!J90","v":0}]
["Graeme McDowell",{"$f":"'random picks'!B91","v":4},null,"Tiger / Pat Reed",{"$f":"'random picks'!F91","v":3},null,null,{"$f":"'random picks'!J91","v":0}]
["Marc Leishman",{"$f":"'random picks'!B92","v":5},null,"Martin Kaymer",{"$f":"'random picks'!F92","v":2},null,null,{"$f":"'random picks'!J92","v":0}]
["Harris English",{"$f":"'random picks'!B93","v":5},null,"Jason Day",{"$f":"'random picks'!F93","v":1},null,null,{"$f":"'random picks'!J93","v":0}]
["Geoff Ogilvy",{"$f":"'random picks'!B94","v":5},null,"Steve Stricker",{"$f":"'random picks'!F94","v":4},null,null,{"$f":"'random picks'!J94","v":0}]
["Best 3",null,null,"Best 3",null,null,"Best 3"]
["Running position",null,null,"Running position",null,null,"Running position"]
[{"$f":"results!A16","v":"TEZ"},null,null,{"$f":"results!G16","v":"CRAIG T"},null,null,{"$f":"results!M16","v":0}]
[null,{"$f":"SUM(B17:B21)/5","v":3.4},null,null,{"$f":"SUM(E17:E21)/5","v":3.8},null,null,{"$f":"SUM(H17:H21)/5","v":0}]
["Phil Mickelson",{"$f":"'random picks'!C90","v":4},null,"Justin Rose",{"$f":"'random picks'!G90","v":6},null,null,{"$f":"'random picks'!K90","v":0}]
["Jordan Spieth",{"$f":"'random picks'!C91","v":1},null,"Charl Schwartzel",{"$f":"'random picks'!G91","v":7},null,null,{"$f":"'random picks'!K91","v":0}]
["Jimmy Walker",{"$f":"'random picks'!C92","v":4},null,"Jim Furyk",{"$f":"'random picks'!G92","v":1},null,null,{"$f":"'random picks'!K92","v":0}]
["J.B. Holmes",{"$f":"'random picks'!C93","v":7},null,"Brandt Snedeker",{"$f":"'random picks'!G93","v":2},null,null,{"$f":"'random picks'!K93","v":0}]
["Luke Donald",{"$f":"'random picks'!C94","v":1},null,"Hunter Mahan",{"$f":"'random picks'!G94","v":3},null,null,{"$f":"'random picks'!K94","v":0}]
["Best 3",null,null,"Best 3",null,null,"Best 3"]
["Running position",null,null,"Running position",null,null,"Running position"]
[{"$f":"results!A25","v":"BYRON"},null,null,{"$f":"results!G25","v":"STUART D"},null,null,{"$f":"results!M25","v":0}]
[null,{"$f":"SUM(B26:B30)/5","v":4.8},null,null,{"$f":"SUM(E26:E30)/5","v":4},null,null,{"$f":"SUM(H26:H30)/5","v":0}]
["Henrik Stenson",{"$f":"'random picks'!D90","v":7},null,"Adam Scott",{"$f":"'random picks'!H90","v":2},null,null,{"$f":"'random picks'!L90","v":0}]
["Matt Kuchar",{"$f":"'random picks'!D91","v":5},null,"Keegan Bradley",{"$f":"'random picks'!H91","v":6},null,null,{"$f":"'random picks'!L91","v":0}]
["Lee Westwood",{"$f":"'random picks'!D92","v":6},null,"Hideki Matsuyama",{"$f":"'random picks'!H92","v":3},null,null,{"$f":"'random picks'!L92","v":0}]
["Ryan Moore",{"$f":"'random picks'!D93","v":4},null,"Zach Johnson",{"$f":"'random picks'!H93","v":3},null,null,{"$f":"'random picks'!L93","v":0}]
["Jason Dufner",{"$f":"'random picks'!D94","v":2},null,"Webb Simpson",{"$f":"'random picks'!H94","v":6},null,null,{"$f":"'random picks'!L94","v":0}]
["Best 3",null,null,"Best 3",null,null,"Best 3"]
["Running position",null,null,"Running position",null,null,"Running position"]
[{"$f":"results!A34","v":"STEVER"},null,null,{"$f":"results!G34","v":0},null,null,{"$f":"results!M34","v":0}]
[null,{"$f":"SUM(B35:B39)/5","v":4.5999999999999996},null,null,{"$f":"SUM(E35:E39)/5","v":0},null,null,{"$f":"SUM(H35:H39)/5","v":0}]
["Rory McILroy",{"$f":"'random picks'!E90","v":1},null,null,{"$f":"'random picks'!I90","v":0},null,null,{"$f":"'random picks'!M90","v":0}]
["Bubba Watson",{"$f":"'random picks'!E91","v":2},null,null,{"$f":"'random picks'!I91","v":0},null,null,{"$f":"'random picks'!M91","v":0}]
["Victor Dubuisson",{"$f":"'random picks'!E92","v":7},null,null,{"$f":"'random picks'!I92","v":0},null,null,{"$f":"'random picks'!M92","v":0}]
["Angel Cabrera",{"$f":"'random picks'!E93","v":6},null,null,{"$f":"'random picks'!I93","v":0},null,null,{"$f":"'random picks'!M93","v":0}]
["Francesco Molinari",{"$f":"'random picks'!E94","v":7},null,null,{"$f":"'random picks'!I94","v":0},null,null,{"$f":"'random picks'!M94","v":0}]
["Best 3",null,null,"Best 3"]
["Running position",null,null,"Running position"]

{"sheet":"PAYERS","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["WHO","PAID","TO PAY","ATTEND","PICKS"]
[]
[{"$f":"results!A7","v":"DEANO"},"NO","YES","YES","-"]
[{"$f":"results!A16","v":"TEZ"},"YES",null,"YES","-"]
[{"$f":"results!A25","v":"BYRON"},"NO","YES","NO","NO"]
[{"$f":"results!A34","v":"STEVER"},"NO","YES","YES","-"]
[{"$f":"results!G7","v":"JOHN C"},"NO","YES","NO","NO"]
[{"$f":"results!G16","v":"CRAIG T"},"YES",null,"NO","NO"]
[{"$f":"results!G25","v":"STUART D"},"YES",null,"NO","NO"]
[{"$f":"results!G34","v":0},"YES",null,"YES","-"]

{"sheet":"random picks","index":5,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DEANO","TEZ","BYRON","STEVER","JOHN C","CRAIG T","STUART D"]
["Random number generator for pick order"]
["R1",{"$f":"RAND()","v":0.78297767347883018},0.9124723707802227,0.87341749156196091,0.22356649784194293,0.54999121425247233,0.32925923793109524,0.47341272185931671,0.67817652997096767,6.0152042568330288E-2,9.2298738703094463E-2]
["R2",0.81667220607738766,0.93324495692420406,0.23369116964217296,0.59515213439065695,0.28267090150236385,0.74545191640912045,0.9681652320256412,0.21722802286403353,0.97691540633368501,0.41659284535206198]
["R3",0.66169092003108443,0.81867010839658205,0.35271130193901912,7.2588799597946174E-2,4.5107488384643402E-2,0.74624764316437575,0.87465121952298708,0.26359745841827043,0.66342966424269301,0.51137346943699136]
["R4",0.57426206150748593,0.22552077322866582,0.50348924711125809,0.63267792975277715,0.63203820606389638,6.7401637531898873E-2,0.44890785787615739,0.4548696656846769,0.53900762560167614,0.11472612901324308]
["R5",0.13434512786393149,0.16055256423525299,0.98953537384026413,0.57751729793410445,0.55390872368046462,0.34208943407087855,1.567115082364301E-2,0.20424519104224603,0.11265960410075671,0.4655849051832559]
["R1",{"$f":"RANK(B4,$B4:$L4)","v":3},1,2,8,5,7,6,4,10,9]
["R2",{"$f":"RANK(B5,$B5:$L5)","v":4},3,9,6,8,5,2,10,1,7]
["R3",{"$f":"RANK(B6,$B6:$L6)","v":5},2,7,9,10,3,1,8,4,6]
["R4",{"$f":"RANK(B7,$B7:$L7)","v":3},8,5,1,2,10,7,6,4,9]
["R5",{"$f":"RANK(B8,$B8:$L8)","v":8},7,1,2,3,5,10,6,9,4]
[]
["Paste special for main sheet"]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0]
["R1",5,9,7,6,8,2,3,1,4]
["R2",4,1,3,5,6,8,7,9,2]
["R3",7,9,1,3,8,6,5,2,4]
["R4",4,6,1,3,5,9,7,2,8]
["R5",9,4,6,5,7,2,3,1,8]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0]
["R1",{"$f":"RAND()","v":0.89191436232884491},0.64820585584646973,0.17614863281609827,0.35863917999683081,0.65733390202516573,0.68901027003297088,0.64875611815903633,0.38019175292002561,0.65513086774790041,0.30332549948022314,0.16463218364279919]
["R2",0.5078965773141253,0.54840641607814988,0.85900840235138232,0.58444886740193536,0.88980176225583374,4.5591867258836793E-2,5.3699731647485538E-2,0.63959958864230915,0.20107719453333039,0.54206520780802903,0.92918801511749505]
["R3",0.39246475624568988,0.23223243249752468,0.84119474576255815,0.85324939252406795,0.97223722072819474,0.29262983970573853,0.81151915572167699,0.55749787969103393,0.79088411846998585,0.4362336353891797,0.30565643763245998]
["R4",0.38962042767315852,0.6257233809173991,4.9188063638382906E-2,0.41218185431124543,3.7472341467402304E-2,0.68376806032159987,0.51197385183004818,0.87494295694589186,0.44476052599845128,0.15338156605670283,0.28868246298600964]
["R5",0.96733958066131975,0.25527723997739848,0.94912089841831493,0.71727451080804461,7.1873946888747708E-2,0.62730402377086047,0.5617961649823906,0.25103628645800202,0.54030556139171615,0.67454751355999076,0.93032684837969459]
["R1",{"$f":"RANK(B23,$B23:$L23)","v":1},6,10,8,3,2,5,7,4,{"$f":"RANK(K23,$B23:$L23)","v":9},11]
["R2",{"$f":"RANK(B24,$B24:$L24)","v":8},6,3,5,2,11,10,4,9,{"$f":"RANK(K24,$B24:$L24)","v":7},1]
["R3",{"$f":"RANK(B25,$B25:$L25)","v":8},11,3,2,1,10,4,6,5,{"$f":"RANK(K25,$B25:$L25)","v":7},9]
["R4",{"$f":"RANK(B26,$B26:$L26)","v":7},3,10,6,11,2,4,1,5,{"$f":"RANK(K26,$B26:$L26)","v":9},8]
["R5",{"$f":"RANK(B27,$B27:$L27)","v":1},9,2,4,11,6,7,10,8,{"$f":"RANK(K27,$B27:$L27)","v":5},3]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0]
["R1",0.42390000453028476,0.55948173273172852,0.97499229344967209,0.14640393913330996,0.21127173445625869,0.8910843111565121,0.12493699897371546,2.834593171883526E-2,5.1346100750490065E-2,0.45553272046848137,0.93660464413416267,0.14145624654307365]
["R2",0.15957253064585886,0.56523645533668376,2.4912821657336992E-2,0.51708631467357946,0.56332520834335065,0.24469459924025216,0.96128442234160283,0.11531048968281266,0.41801402972913837,0.47897084859966721,0.82487326178810449,0.38375620921205444]
["R3",0.60671689393032679,0.68384431263699719,0.63923731432455955,0.60559089372360697,0.13653042343244171,0.57688832087478192,0.38658692314231557,2.7451431127831882E-2,0.44386464052806063,0.51782342298253492,0.85676835088755221,0.57027017767833155]
["R4",0.92833784106680117,0.68088710227012295,0.42298348550932607,0.36330973019615487,0.52696772413149973,0.91486146240739052,0.96718868956310255,0.71887709100180441,9.6669514029371517E-2,0.10186796503377404,0.48918197622410409,0.2408477934838068]
["R5",0.85882788105443852,0.12809831376746228,0.46117540112664379,0.82959944999839297,0.7296003007819083,0.49852376959254596,0.12484263843994725,0.61256053471020611,3.2295709175340748E-2,0.1496162599037465,0.56089390323591959,0.85613986544188103]
["R1",{"$f":"RANK(B34,$B34:$M34)","v":6},4,1,8,7,3,10,12,11,{"$f":"RANK(K34,$B34:$M34)","v":5},2,9]
["R2",{"$f":"RANK(B35,$B35:$M35)","v":10},3,12,5,4,9,1,11,7,{"$f":"RANK(K35,$B35:$M35)","v":6},2,8]
["R3",{"$f":"RANK(B36,$B36:$M36)","v":4},2,3,5,11,6,10,12,9,{"$f":"RANK(K36,$B36:$M36)","v":8},1,7]
["R4",{"$f":"RANK(B37,$B37:$M37)","v":2},5,8,9,6,3,1,4,12,{"$f":"RANK(K37,$B37:$M37)","v":11},7,10]
["R5",{"$f":"RANK(B38,$B38:$M38)","v":1},10,8,3,4,7,11,5,12,{"$f":"RANK(K38,$B38:$M38)","v":9},6,2]
[]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0,0]
["R1",{"$f":"RAND()","v":0.33725744862601559},0.45023864679655323,0.56112250376399275,0.8437317907680848,0.42745634840115576,0.5083901153967697,0.2067148051767953,3.3364684706994829E-2,0.47381249973970363,0.44975564456054706,0.36724221135981683,0.16451429937634099,1.5926034154419844E-3]
["R2",0.94435204438463705,0.55019468786417647,0.85301325155120078,0.65070256778049995,0.33645093279560867,0.63742322621214809,0.73709058766484015,0.28013585358171056,0.55304762296861221,0.11932734205993656,0.55486087384812066,0.54183358868311693,0.36675605980509418]
["R3",0.95413986840874498,0.48566964058888917,0.19747653389340114,6.9183620982135374E-2,0.30195796682677523,0.56356344033164674,0.54279397698600806,0.51166429494863541,0.743959328400291,0.22876964218858953,0.83762442260379089,0.55317471552163255,0.33669129570536083]
["R4",0.79058566546989517,0.84748962677489015,0.13800917823672409,0.55689724607310653,0.74926851460739752,0.15012769704768303,0.34389395444705451,0.99604208951203799,0.16963529893989548,0.88637865658870385,0.34208623612490341,0.95400902828118817,0.23531943848973835]
["R5",3.074263315808845E-2,0.71210936475293429,0.41150589685626138,1.7130830863263946E-2,0.4024773761939785,9.7701295724803572E-3,6.818068838395086E-3,0.70672757237037243,7.1605307529177598E-2,0.32684787896198608,0.90832754129069626,0.52414377965458825,0.56895077359586443]
["R1",{"$f":"RANK(B46,$B46:$N46)","v":9},5,2,1,7,3,10,12,4,{"$f":"RANK(K46,$B46:$N46)","v":6},8,11,13]
["R2",{"$f":"RANK(B47,$B47:$N47)","v":1},8,2,4,11,5,3,12,7,{"$f":"RANK(K47,$B47:$N47)","v":13},6,9,10]
["R3",{"$f":"RANK(B48,$B48:$N48)","v":1},8,12,13,10,4,6,7,3,{"$f":"RANK(K48,$B48:$N48)","v":11},2,5,9]
["R4",{"$f":"RANK(B49,$B49:$N49)","v":5},4,13,7,6,12,8,1,11,{"$f":"RANK(K49,$B49:$N49)","v":3},9,2,10]
["R5",{"$f":"RANK(B50,$B50:$N50)","v":10},2,6,11,7,12,13,3,9,{"$f":"RANK(K50,$B50:$N50)","v":8},1,5,4]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0,0,0]
["R1",0.18833122260297264,0.6676166576589625,0.18527873362328373,0.61247014768425434,9.4860676033052593E-2,0.35175418536336434,0.39898463168664344,0.53348921822064499,0.88100330507884117,0.71085095587293734,0.33547690921938189,3.3547479665446134E-2,0.2683849193953658,0.1481626803736007]
["R2",0.43687990673139976,0.11408094508373545,0.55005600546972933,0.73791876024804148,0.81533369969773084,0.80086048062614523,0.6571170691946171,4.6022735202876919E-2,0.22318243799955018,0.22845904793452487,0.619628621019641,0.75729701596092802,0.36600276418985245,0.53412098334611391]
["R3",0.93443611113121616,0.37603569870853903,0.25518087829350811,6.4930297960191563E-2,0.87503956598082566,0.64634131483648782,0.36050414409112685,0.53221021686152215,0.51901453326079938,0.38640889661424094,0.11470902820249296,0.3411997187043555,0.24798201722947966,0.71665968517256717]
["R4",0.49825292775961394,9.6176057111132418E-2,0.85584563944824621,0.85379329002890536,0.81073293462755847,4.9525159865184465E-2,0.2817895679499216,0.16992609872683395,0.5731467896301955,0.8971093507357002,0.98681532797494231,0.19118027639659985,0.17963747270136976,5.3911096028469108E-2]
["R5",0.78617111896400749,0.90795725443930697,0.86975211401440211,0.66814667736603162,0.81399802480873129,0.32784632586135598,1.624705523292036E-2,0.12599555520179484,0.38835067855239425,6.9624057373265491E-2,0.40870912301462625,0.32409388181848364,0.36570494563154932,5.0751424620529617E-2]
["R1",{"$f":"RANK(B57,$B57:$O57)","v":10},3,11,4,13,7,6,5,1,{"$f":"RANK(K57,$B57:$O57)","v":2},8,14,9,12]
["R2",{"$f":"RANK(B58,$B58:$O58)","v":9},13,7,4,1,2,5,14,12,{"$f":"RANK(K58,$B58:$O58)","v":11},6,3,10,8]
["R3",{"$f":"RANK(B59,$B59:$O59)","v":1},8,11,14,2,4,9,5,6,{"$f":"RANK(K59,$B59:$O59)","v":7},13,10,12,3]
["R4",{"$f":"RANK(B60,$B60:$O60)","v":7},12,3,4,5,14,8,11,6,{"$f":"RANK(K60,$B60:$O60)","v":2},1,9,10,13]
["R5",{"$f":"RANK(B61,$B61:$O61)","v":4},1,2,5,3,9,14,11,7,{"$f":"RANK(K61,$B61:$O61)","v":12},6,10,8,13]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0,0,0,0]
["R1",{"$f":"RAND()","v":0.32172163586156899},0.46152001695687694,0.64383239198611375,0.87008301788984566,0.27881907620656043,6.4741669461293894E-2,0.72820740734376499,0.95292657474999409,0.83535861052760163,0.35046277633086609,0.33988896367168897,0.57159199542471673,0.18665392569883754,0.92327264581911717,0.32494538494466085]
["R2",0.83207729584995826,0.31906051668540636,0.59648623685116398,0.23363876492606461,0.37147208169706336,0.5846261122815265,0.81969384468950335,0.47101319718912682,0.761408838316874,0.21016927175630162,0.93537177694596163,0.5877851080666574,0.67230641257998092,1.7504632790690255E-3,0.92159660008764288]
["R3",0.40931088766087409,0.77268544439027909,0.35568008586799704,4.9380056651087689E-2,0.46954041136705316,6.7116844928998276E-2,0.99904032523238417,0.3060004881901921,0.11548168925031976,0.77739793659392908,0.67137652601713527,0.36790606530367953,0.62277265240250756,0.67020871650902603,0.12623341202397198]
["R4",0.68942511141356555,0.43028362480578408,0.69966646031214297,9.6245257546262453E-2,0.98959731275297358,0.90294361329383577,0.43686208080433808,0.46049238892706368,0.68812539603196932,0.50097718077450293,0.41874813701283475,0.29910852372856678,0.62132012707599427,0.44475605762147774,0.35733540664712593]
["R5",0.96655201101556287,0.97470249517152108,8.2518211883269355E-2,0.67178017869680839,0.96323017380585696,0.25584573468527128,0.16766559150811222,0.23544925001201167,0.24459853385839925,0.10007548354699614,0.66914574560833351,0.2496532049812844,0.84779017944839286,0.82482682455073675,0.48304933919538828]
["R1",{"$f":"RANK(B68,$B68:$P68)","v":12},8,6,3,13,15,5,1,4,{"$f":"RANK(K68,$B68:$P68)","v":9},10,7,14,2,11]
["R2",{"$f":"RANK(B69,$B69:$P69)","v":3},12,7,13,11,9,4,10,5,{"$f":"RANK(K69,$B69:$P69)","v":14},1,8,6,15,2]
["R3",{"$f":"RANK(B70,$B70:$P70)","v":8},3,10,15,7,14,1,11,13,{"$f":"RANK(K70,$B70:$P70)","v":2},4,9,6,5,12]
["R4",{"$f":"RANK(B71,$B71:$P71)","v":4},11,3,15,1,2,10,8,5,{"$f":"RANK(K71,$B71:$P71)","v":7},12,14,6,9,13]
["R5",{"$f":"RANK(B72,$B72:$P72)","v":2},1,15,6,3,9,13,12,11,{"$f":"RANK(K72,$B72:$P72)","v":14},7,10,4,5,8]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0]
["R1",{"$f":"RAND()","v":0.45223964742109712},{"$f":"RAND()","v":0.78537769040575822},0.66695409981974774,9.7140880024011556E-2,0.47046655530080417,0.69571966972350785,0.40847258497563999,0.45058570262812925]
["R2",0.85390939827675771,0.60988926889419126,0.44641912217711144,0.52679937226574114,0.23266348987068008,0.96208794804976439,0.4559284513898062,0.38723963903758973]
["R3",0.47096018541849227,0.89411349163652964,0.46582429360143585,0.43498876243539153,0.54994935537948175,0.62329082994425844,0.86111507430232193,0.12326938683803979]
["R4",0.53340181753364058,0.37922740679090594,0.82249639884558656,0.58359990225465963,0.20934018014194244,0.47878235023025295,0.20279474104453832,9.6973905955355377E-3]
["R5",0.41281839768270523,1.4801606545504553E-2,0.35422545730778676,0.66248172053750176,0.51624662823837364,0.65220347758252983,0.95031722696127241,0.40098378501868415]
["R1",{"$f":"RANK(B79,$B79:$L79)","v":5},1,3,8,4,2,7,6]
["R2",2,3,6,4,8,1,5,7]
["R3",5,1,6,7,4,3,2,8]
["R4",3,5,1,2,6,4,7,8]
["R5",5,8,7,2,4,3,1,6]
[]
["HERE->",3,4,7,1,5,6,2]
[null,4,1,5,2,3,7,6]
[null,5,4,6,7,2,1,3]
[null,5,7,4,6,1,2,3]
[null,5,1,2,7,4,3,6]
[]
[null,"CUT RANDOM NUMBERS & PASTE VALUES HERE TO BE PICKED UP BY OTHER SHEETS"]
[null,null,"DESIGNED FOR EIGHT PLAYERS - CAN BE EXPANDED"]
[]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D"]
[null,{"$f":"RAND()","v":0.9922964724405634},{"$f":"RAND()","v":0.30273175794115259},0.90495195602185252,0.11941247284851653,0.27516907002577407,0.63788822437915094,6.2175162723768995E-2]
[null,0.81061599415470187,0.38605258507076301,0.63689103327742957,0.40425492576034761,0.33966155309902701,0.13742905891377555,0.38608727336755555]
[null,0.30276736215085132,0.59715025147042977,4.3701410851674227E-2,0.90625342865273839,0.38118756263615472,0.94797747194288062,0.27502793906328049]
[null,0.14150348789121847,2.847890411755738E-2,0.40611250836542856,0.44665390222054813,0.30221853073254301,0.13176829133181611,0.34243193966142615]
[null,0.89450540020013025,0.47712270090887543,0.20802105976188634,0.11273293072030954,0.22376232238991334,5.7632659688938492E-2,0.7334717068496065]
[null,{"$f":"RANK(B100,$B100:$L100)","v":1},4,2,6,5,3,7]
[null,{"$f":"RANK(B101,$B101:$L101)","v":1},5,2,3,6,7,4]
[null,{"$f":"RANK(B102,$B102:$L102)","v":5},3,7,2,4,1,6]
[null,{"$f":"RANK(B103,$B103:$L103)","v":5},7,2,1,4,6,3]
[null,{"$f":"RANK(B104,$B104:$L104)","v":1},3,5,6,4,7,2]

{"sheet":"Round order","index":6,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,1,2,3,4,5,6,7,8]
["R1",{"$f":"IF('random picks'!$B90=1,'random picks'!$B$78,IF('random picks'!$C90=1,'random picks'!$C$78,IF('random picks'!$D90=1,'random picks'!$D$78,IF('random picks'!$E90=1,'random picks'!$E$78,IF('random picks'!$F90=1,'random picks'!$F$78,IF('random picks'!$G90=1,'random picks'!$G$78,IF('random picks'!$H90=1,'random picks'!$H$78,IF('random picks'!$I90=1,'random picks'!$I$78))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B90=2,'random picks'!$B$78,IF('random picks'!$C90=2,'random picks'!$C$78,IF('random picks'!$D90=2,'random picks'!$D$78,IF('random picks'!$E90=2,'random picks'!$E$78,IF('random picks'!$F90=2,'random picks'!$F$78,IF('random picks'!$G90=2,'random picks'!$G$78,IF('random picks'!$H90=2,'random picks'!$H$78,IF('random picks'!$I90=2,'random picks'!$I$78))))))))","v":"STUART D"},{"$f":"IF('random picks'!$B90=3,'random picks'!$B$78,IF('random picks'!$C90=3,'random picks'!$C$78,IF('random picks'!$D90=3,'random picks'!$D$78,IF('random picks'!$E90=3,'random picks'!$E$78,IF('random picks'!$F90=3,'random picks'!$F$78,IF('random picks'!$G90=3,'random picks'!$G$78,IF('random picks'!$H90=3,'random picks'!$H$78,IF('random picks'!$I90=3,'random picks'!$I$78))))))))","v":"DEANO"},{"$f":"IF('random picks'!$B90=4,'random picks'!$B$78,IF('random picks'!$C90=4,'random picks'!$C$78,IF('random picks'!$D90=4,'random picks'!$D$78,IF('random picks'!$E90=4,'random picks'!$E$78,IF('random picks'!$F90=4,'random picks'!$F$78,IF('random picks'!$G90=4,'random picks'!$G$78,IF('random picks'!$H90=4,'random picks'!$H$78,IF('random picks'!$I90=4,'random picks'!$I$78))))))))","v":"TEZ"},{"$f":"IF('random picks'!$B90=5,'random picks'!$B$78,IF('random picks'!$C90=5,'random picks'!$C$78,IF('random picks'!$D90=5,'random picks'!$D$78,IF('random picks'!$E90=5,'random picks'!$E$78,IF('random picks'!$F90=5,'random picks'!$F$78,IF('random picks'!$G90=5,'random picks'!$G$78,IF('random picks'!$H90=5,'random picks'!$H$78,IF('random picks'!$I90=5,'random picks'!$I$78))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B90=6,'random picks'!$B$78,IF('random picks'!$C90=6,'random picks'!$C$78,IF('random picks'!$D90=6,'random picks'!$D$78,IF('random picks'!$E90=6,'random picks'!$E$78,IF('random picks'!$F90=6,'random picks'!$F$78,IF('random picks'!$G90=6,'random picks'!$G$78,IF('random picks'!$H90=6,'random picks'!$H$78,IF('random picks'!$I90=6,'random picks'!$I$78))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B90=7,'random picks'!$B$78,IF('random picks'!$C90=7,'random picks'!$C$78,IF('random picks'!$D90=7,'random picks'!$D$78,IF('random picks'!$E90=7,'random picks'!$E$78,IF('random picks'!$F90=7,'random picks'!$F$78,IF('random picks'!$G90=7,'random picks'!$G$78,IF('random picks'!$H90=7,'random picks'!$H$78,IF('random picks'!$I90=7,'random picks'!$I$78))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B90=8,'random picks'!$B$78,IF('random picks'!$C90=8,'random picks'!$C$78,IF('random picks'!$D90=8,'random picks'!$D$78,IF('random picks'!$E90=8,'random picks'!$E$78,IF('random picks'!$F90=8,'random picks'!$F$78,IF('random picks'!$G90=8,'random picks'!$G$78,IF('random picks'!$H90=8,'random picks'!$H$78,IF('random picks'!$I90=8,'random picks'!$I$78))))))))","v":false}]
["R2",{"$f":"IF('random picks'!$B91=1,'random picks'!$B$78,IF('random picks'!$C91=1,'random picks'!$C$78,IF('random picks'!$D91=1,'random picks'!$D$78,IF('random picks'!$E91=1,'random picks'!$E$78,IF('random picks'!$F91=1,'random picks'!$F$78,IF('random picks'!$G91=1,'random picks'!$G$78,IF('random picks'!$H91=1,'random picks'!$H$78,IF('random picks'!$I91=1,'random picks'!$I$78))))))))","v":"TEZ"},{"$f":"IF('random picks'!$B91=2,'random picks'!$B$78,IF('random picks'!$C91=2,'random picks'!$C$78,IF('random picks'!$D91=2,'random picks'!$D$78,IF('random picks'!$E91=2,'random picks'!$E$78,IF('random picks'!$F91=2,'random picks'!$F$78,IF('random picks'!$G91=2,'random picks'!$G$78,IF('random picks'!$H91=2,'random picks'!$H$78,IF('random picks'!$I91=2,'random picks'!$I$78))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B91=3,'random picks'!$B$78,IF('random picks'!$C91=3,'random picks'!$C$78,IF('random picks'!$D91=3,'random picks'!$D$78,IF('random picks'!$E91=3,'random picks'!$E$78,IF('random picks'!$F91=3,'random picks'!$F$78,IF('random picks'!$G91=3,'random picks'!$G$78,IF('random picks'!$H91=3,'random picks'!$H$78,IF('random picks'!$I91=3,'random picks'!$I$78))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B91=4,'random picks'!$B$78,IF('random picks'!$C91=4,'random picks'!$C$78,IF('random picks'!$D91=4,'random picks'!$D$78,IF('random picks'!$E91=4,'random picks'!$E$78,IF('random picks'!$F91=4,'random picks'!$F$78,IF('random picks'!$G91=4,'random picks'!$G$78,IF('random picks'!$H91=4,'random picks'!$H$78,IF('random picks'!$I91=4,'random picks'!$I$78))))))))","v":"DEANO"},{"$f":"IF('random picks'!$B91=5,'random picks'!$B$78,IF('random picks'!$C91=5,'random picks'!$C$78,IF('random picks'!$D91=5,'random picks'!$D$78,IF('random picks'!$E91=5,'random picks'!$E$78,IF('random picks'!$F91=5,'random picks'!$F$78,IF('random picks'!$G91=5,'random picks'!$G$78,IF('random picks'!$H91=5,'random picks'!$H$78,IF('random picks'!$I91=5,'random picks'!$I$78))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B91=6,'random picks'!$B$78,IF('random picks'!$C91=6,'random picks'!$C$78,IF('random picks'!$D91=6,'random picks'!$D$78,IF('random picks'!$E91=6,'random picks'!$E$78,IF('random picks'!$F91=6,'random picks'!$F$78,IF('random picks'!$G91=6,'random picks'!$G$78,IF('random picks'!$H91=6,'random picks'!$H$78,IF('random picks'!$I91=6,'random picks'!$I$78))))))))","v":"STUART D"},{"$f":"IF('random picks'!$B91=7,'random picks'!$B$78,IF('random picks'!$C91=7,'random picks'!$C$78,IF('random picks'!$D91=7,'random picks'!$D$78,IF('random picks'!$E91=7,'random picks'!$E$78,IF('random picks'!$F91=7,'random picks'!$F$78,IF('random picks'!$G91=7,'random picks'!$G$78,IF('random picks'!$H91=7,'random picks'!$H$78,IF('random picks'!$I91=7,'random picks'!$I$78))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B91=8,'random picks'!$B$78,IF('random picks'!$C91=8,'random picks'!$C$78,IF('random picks'!$D91=8,'random picks'!$D$78,IF('random picks'!$E91=8,'random picks'!$E$78,IF('random picks'!$F91=8,'random picks'!$F$78,IF('random picks'!$G91=8,'random picks'!$G$78,IF('random picks'!$H91=8,'random picks'!$H$78,IF('random picks'!$I91=8,'random picks'!$I$78))))))))","v":false}]
["R3",{"$f":"IF('random picks'!$B92=1,'random picks'!$B$78,IF('random picks'!$C92=1,'random picks'!$C$78,IF('random picks'!$D92=1,'random picks'!$D$78,IF('random picks'!$E92=1,'random picks'!$E$78,IF('random picks'!$F92=1,'random picks'!$F$78,IF('random picks'!$G92=1,'random picks'!$G$78,IF('random picks'!$H92=1,'random picks'!$H$78,IF('random picks'!$I92=1,'random picks'!$I$78))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B92=2,'random picks'!$B$78,IF('random picks'!$C92=2,'random picks'!$C$78,IF('random picks'!$D92=2,'random picks'!$D$78,IF('random picks'!$E92=2,'random picks'!$E$78,IF('random picks'!$F92=2,'random picks'!$F$78,IF('random picks'!$G92=2,'random picks'!$G$78,IF('random picks'!$H92=2,'random picks'!$H$78,IF('random picks'!$I92=2,'random picks'!$I$78))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B92=3,'random picks'!$B$78,IF('random picks'!$C92=3,'random picks'!$C$78,IF('random picks'!$D92=3,'random picks'!$D$78,IF('random picks'!$E92=3,'random picks'!$E$78,IF('random picks'!$F92=3,'random picks'!$F$78,IF('random picks'!$G92=3,'random picks'!$G$78,IF('random picks'!$H92=3,'random picks'!$H$78,IF('random picks'!$I92=3,'random picks'!$I$78))))))))","v":"STUART D"},{"$f":"IF('random picks'!$B92=4,'random picks'!$B$78,IF('random picks'!$C92=4,'random picks'!$C$78,IF('random picks'!$D92=4,'random picks'!$D$78,IF('random picks'!$E92=4,'random picks'!$E$78,IF('random picks'!$F92=4,'random picks'!$F$78,IF('random picks'!$G92=4,'random picks'!$G$78,IF('random picks'!$H92=4,'random picks'!$H$78,IF('random picks'!$I92=4,'random picks'!$I$78))))))))","v":"TEZ"},{"$f":"IF('random picks'!$B92=5,'random picks'!$B$78,IF('random picks'!$C92=5,'random picks'!$C$78,IF('random picks'!$D92=5,'random picks'!$D$78,IF('random picks'!$E92=5,'random picks'!$E$78,IF('random picks'!$F92=5,'random picks'!$F$78,IF('random picks'!$G92=5,'random picks'!$G$78,IF('random picks'!$H92=5,'random picks'!$H$78,IF('random picks'!$I92=5,'random picks'!$I$78))))))))","v":"DEANO"},{"$f":"IF('random picks'!$B92=6,'random picks'!$B$78,IF('random picks'!$C92=6,'random picks'!$C$78,IF('random picks'!$D92=6,'random picks'!$D$78,IF('random picks'!$E92=6,'random picks'!$E$78,IF('random picks'!$F92=6,'random picks'!$F$78,IF('random picks'!$G92=6,'random picks'!$G$78,IF('random picks'!$H92=6,'random picks'!$H$78,IF('random picks'!$I92=6,'random picks'!$I$78))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B92=7,'random picks'!$B$78,IF('random picks'!$C92=7,'random picks'!$C$78,IF('random picks'!$D92=7,'random picks'!$D$78,IF('random picks'!$E92=7,'random picks'!$E$78,IF('random picks'!$F92=7,'random picks'!$F$78,IF('random picks'!$G92=7,'random picks'!$G$78,IF('random picks'!$H92=7,'random picks'!$H$78,IF('random picks'!$I92=7,'random picks'!$I$78))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B92=8,'random picks'!$B$78,IF('random picks'!$C92=8,'random picks'!$C$78,IF('random picks'!$D92=8,'random picks'!$D$78,IF('random picks'!$E92=8,'random picks'!$E$78,IF('random picks'!$F92=8,'random picks'!$F$78,IF('random picks'!$G92=8,'random picks'!$G$78,IF('random picks'!$H92=8,'random picks'!$H$78,IF('random picks'!$I92=8,'random picks'!$I$78))))))))","v":false}]
["R4",{"$f":"IF('random picks'!$B93=1,'random picks'!$B$78,IF('random picks'!$C93=1,'random picks'!$C$78,IF('random picks'!$D93=1,'random picks'!$D$78,IF('random picks'!$E93=1,'random picks'!$E$78,IF('random picks'!$F93=1,'random picks'!$F$78,IF('random picks'!$G93=1,'random picks'!$G$78,IF('random picks'!$H93=1,'random picks'!$H$78,IF('random picks'!$I93=1,'random picks'!$I$78))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B93=2,'random picks'!$B$78,IF('random picks'!$C93=2,'random picks'!$C$78,IF('random picks'!$D93=2,'random picks'!$D$78,IF('random picks'!$E93=2,'random picks'!$E$78,IF('random picks'!$F93=2,'random picks'!$F$78,IF('random picks'!$G93=2,'random picks'!$G$78,IF('random picks'!$H93=2,'random picks'!$H$78,IF('random picks'!$I93=2,'random picks'!$I$78))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B93=3,'random picks'!$B$78,IF('random picks'!$C93=3,'random picks'!$C$78,IF('random picks'!$D93=3,'random picks'!$D$78,IF('random picks'!$E93=3,'random picks'!$E$78,IF('random picks'!$F93=3,'random picks'!$F$78,IF('random picks'!$G93=3,'random picks'!$G$78,IF('random picks'!$H93=3,'random picks'!$H$78,IF('random picks'!$I93=3,'random picks'!$I$78))))))))","v":"STUART D"},{"$f":"IF('random picks'!$B93=4,'random picks'!$B$78,IF('random picks'!$C93=4,'random picks'!$C$78,IF('random picks'!$D93=4,'random picks'!$D$78,IF('random picks'!$E93=4,'random picks'!$E$78,IF('random picks'!$F93=4,'random picks'!$F$78,IF('random picks'!$G93=4,'random picks'!$G$78,IF('random picks'!$H93=4,'random picks'!$H$78,IF('random picks'!$I93=4,'random picks'!$I$78))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B93=5,'random picks'!$B$78,IF('random picks'!$C93=5,'random picks'!$C$78,IF('random picks'!$D93=5,'random picks'!$D$78,IF('random picks'!$E93=5,'random picks'!$E$78,IF('random picks'!$F93=5,'random picks'!$F$78,IF('random picks'!$G93=5,'random picks'!$G$78,IF('random picks'!$H93=5,'random picks'!$H$78,IF('random picks'!$I93=5,'random picks'!$I$78))))))))","v":"DEANO"},{"$f":"IF('random picks'!$B93=6,'random picks'!$B$78,IF('random picks'!$C93=6,'random picks'!$C$78,IF('random picks'!$D93=6,'random picks'!$D$78,IF('random picks'!$E93=6,'random picks'!$E$78,IF('random picks'!$F93=6,'random picks'!$F$78,IF('random picks'!$G93=6,'random picks'!$G$78,IF('random picks'!$H93=6,'random picks'!$H$78,IF('random picks'!$I93=6,'random picks'!$I$78))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B93=7,'random picks'!$B$78,IF('random picks'!$C93=7,'random picks'!$C$78,IF('random picks'!$D93=7,'random picks'!$D$78,IF('random picks'!$E93=7,'random picks'!$E$78,IF('random picks'!$F93=7,'random picks'!$F$78,IF('random picks'!$G93=7,'random picks'!$G$78,IF('random picks'!$H93=7,'random picks'!$H$78,IF('random picks'!$I93=7,'random picks'!$I$78))))))))","v":"TEZ"},{"$f":"IF('random picks'!$B93=8,'random picks'!$B$78,IF('random picks'!$C93=8,'random picks'!$C$78,IF('random picks'!$D93=8,'random picks'!$D$78,IF('random picks'!$E93=8,'random picks'!$E$78,IF('random picks'!$F93=8,'random picks'!$F$78,IF('random picks'!$G93=8,'random picks'!$G$78,IF('random picks'!$H93=8,'random picks'!$H$78,IF('random picks'!$I93=8,'random picks'!$I$78))))))))","v":false}]
["R5",{"$f":"IF('random picks'!$B94=1,'random picks'!$B$78,IF('random picks'!$C94=1,'random picks'!$C$78,IF('random picks'!$D94=1,'random picks'!$D$78,IF('random picks'!$E94=1,'random picks'!$E$78,IF('random picks'!$F94=1,'random picks'!$F$78,IF('random picks'!$G94=1,'random picks'!$G$78,IF('random picks'!$H94=1,'random picks'!$H$78,IF('random picks'!$I94=1,'random picks'!$I$78))))))))","v":"TEZ"},{"$f":"IF('random picks'!$B94=2,'random picks'!$B$78,IF('random picks'!$C94=2,'random picks'!$C$78,IF('random picks'!$D94=2,'random picks'!$D$78,IF('random picks'!$E94=2,'random picks'!$E$78,IF('random picks'!$F94=2,'random picks'!$F$78,IF('random picks'!$G94=2,'random picks'!$G$78,IF('random picks'!$H94=2,'random picks'!$H$78,IF('random picks'!$I94=2,'random picks'!$I$78))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B94=3,'random picks'!$B$78,IF('random picks'!$C94=3,'random picks'!$C$78,IF('random picks'!$D94=3,'random picks'!$D$78,IF('random picks'!$E94=3,'random picks'!$E$78,IF('random picks'!$F94=3,'random picks'!$F$78,IF('random picks'!$G94=3,'random picks'!$G$78,IF('random picks'!$H94=3,'random picks'!$H$78,IF('random picks'!$I94=3,'random picks'!$I$78))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B94=4,'random picks'!$B$78,IF('random picks'!$C94=4,'random picks'!$C$78,IF('random picks'!$D94=4,'random picks'!$D$78,IF('random picks'!$E94=4,'random picks'!$E$78,IF('random picks'!$F94=4,'random picks'!$F$78,IF('random picks'!$G94=4,'random picks'!$G$78,IF('random picks'!$H94=4,'random picks'!$H$78,IF('random picks'!$I94=4,'random picks'!$I$78))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B94=5,'random picks'!$B$78,IF('random picks'!$C94=5,'random picks'!$C$78,IF('random picks'!$D94=5,'random picks'!$D$78,IF('random picks'!$E94=5,'random picks'!$E$78,IF('random picks'!$F94=5,'random picks'!$F$78,IF('random picks'!$G94=5,'random picks'!$G$78,IF('random picks'!$H94=5,'random picks'!$H$78,IF('random picks'!$I94=5,'random picks'!$I$78))))))))","v":"DEANO"},{"$f":"IF('random picks'!$B94=6,'random picks'!$B$78,IF('random picks'!$C94=6,'random picks'!$C$78,IF('random picks'!$D94=6,'random picks'!$D$78,IF('random picks'!$E94=6,'random picks'!$E$78,IF('random picks'!$F94=6,'random picks'!$F$78,IF('random picks'!$G94=6,'random picks'!$G$78,IF('random picks'!$H94=6,'random picks'!$H$78,IF('random picks'!$I94=6,'random picks'!$I$78))))))))","v":"STUART D"},{"$f":"IF('random picks'!$B94=7,'random picks'!$B$78,IF('random picks'!$C94=7,'random picks'!$C$78,IF('random picks'!$D94=7,'random picks'!$D$78,IF('random picks'!$E94=7,'random picks'!$E$78,IF('random picks'!$F94=7,'random picks'!$F$78,IF('random picks'!$G94=7,'random picks'!$G$78,IF('random picks'!$H94=7,'random picks'!$H$78,IF('random picks'!$I94=7,'random picks'!$I$78))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B94=8,'random picks'!$B$78,IF('random picks'!$C94=8,'random picks'!$C$78,IF('random picks'!$D94=8,'random picks'!$D$78,IF('random picks'!$E94=8,'random picks'!$E$78,IF('random picks'!$F94=8,'random picks'!$F$78,IF('random picks'!$G94=8,'random picks'!$G$78,IF('random picks'!$H94=8,'random picks'!$H$78,IF('random picks'!$I94=8,'random picks'!$I$78))))))))","v":false}]