{"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":-11},{"$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":-5},{"$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":1},{"$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":-10},{"$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":-8},{"$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":-12},{"$f":"IF(ISERROR(C13-B7/100),\"\",C13-B7/100)","v":-12.044},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":-23},{"$f":"IF(ISERROR(I13-H7/100),\"\",I13-H7/100)","v":-23.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":1},{"$f":"VLOOKUP(G7,ranks!$C$4:$G$14,5,FALSE)","v":1},"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":-10},{"$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":-4},{"$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":-4},{"$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":-5},{"$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":-7},{"$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":-4},{"$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":-6},{"$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":-3},{"$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":-7},{"$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":-19},{"$f":"IF(ISERROR(C22-B16/100),\"\",C22-B16/100)","v":-19.033999999999999},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":-20},{"$f":"IF(ISERROR(I22-H16/100),\"\",I22-H16/100)","v":-20.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":4},{"$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":3},"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":-9},{"$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":-7},{"$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":-7},{"$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":0},{"$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":-5},{"$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":-1},{"$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":-21},{"$f":"IF(ISERROR(C31-B25/100),\"\",C31-B25/100)","v":-21.047999999999998},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":-8},{"$f":"IF(ISERROR(I31-H25/100),\"\",I31-H25/100)","v":-8.0399999999999991},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":2},{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,5,FALSE)","v":2},"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":-13},{"$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":2},{"$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":-6},{"$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":-19},{"$f":"IF(ISERROR(C40-B34/100),\"\",C40-B34/100)","v":-19.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":4},{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,5,FALSE)","v":4},"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,67,"14:55:00",-4,"F",-13,200,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":-13},{"$f":"IF(ISERROR(INDEX($A:$J,R7,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R7,$U$2)+TIME(5,0,0))","v":67.208333333333329},{"$f":"INDEX($A:$N,R7,$V$2)","v":"F"}]
[null,2,"Bernd Wiesberger",68,68,65,"14:55:00",-6,"F",-12,201,null,null,null,null,null,null,{"$f":"R7+1","v":8},{"$f":"SUBSTITUTE(INDEX($A:$J,R8,$S$2),\"*\",\"\")","v":"Bernd Wiesberger"},{"$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":-12},{"$f":"IF(ISERROR(INDEX($A:$J,R8,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R8,$U$2)+TIME(5,0,0))","v":65.208333333333329},{"$f":"INDEX($A:$N,R8,$V$2)","v":"F"}]
[null,3,"Rickie Fowler",69,66,67,"14:45:00",-4,"F",-11,202,null,null,null,null,null,null,{"$f":"R8+1","v":9},{"$f":"SUBSTITUTE(INDEX($A:$J,R9,$S$2),\"*\",\"\")","v":"Rickie Fowler"},{"$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":-11},{"$f":"IF(ISERROR(INDEX($A:$J,R9,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R9,$U$2)+TIME(5,0,0))","v":67.208333333333329},{"$f":"INDEX($A:$N,R9,$V$2)","v":"F"}]
[null,"T4","Phil Mickelson",69,67,67,"14:45:00",-4,"F",-10,203,null,null,null,null,null,null,10,{"$f":"SUBSTITUTE(INDEX($A:$J,R10,$S$2),\"*\",\"\")","v":"Phil Mickelson"},-10,{"$f":"IF(ISERROR(INDEX($A:$J,R10,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R10,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T4","Jason Day",69,65,69,"14:35:00",-2,"F",-10,203,null,null,null,null,null,null,11,{"$f":"SUBSTITUTE(INDEX($A:$J,R11,$S$2),\"*\",\"\")","v":"Jason Day"},-10,{"$f":"IF(ISERROR(INDEX($A:$J,R11,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R11,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T6","Louis Oosthuizen",70,67,67,"14:35:00",-4,"F",-9,204,null,null,null,null,null,null,12,{"$f":"SUBSTITUTE(INDEX($A:$J,R12,$S$2),\"*\",\"\")","v":"Louis Oosthuizen"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R12,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R12,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T6","Henrik Stenson",66,71,67,"14:25:00",-4,"F",-9,204,null,null,null,null,null,null,13,{"$f":"SUBSTITUTE(INDEX($A:$J,R13,$S$2),\"*\",\"\")","v":"Henrik Stenson"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R13,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R13,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T6","Mikko Ilonen",67,68,69,"14:25:00",-2,"F",-9,204,null,null,null,null,null,null,14,{"$f":"SUBSTITUTE(INDEX($A:$J,R14,$S$2),\"*\",\"\")","v":"Mikko Ilonen"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R14,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R14,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T6","Ryan Palmer",65,70,69,"14:15:00",-2,"F",-9,204,null,null,null,null,null,null,15,{"$f":"SUBSTITUTE(INDEX($A:$J,R15,$S$2),\"*\",\"\")","v":"Ryan Palmer"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R15,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R15,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T10","Jamie Donaldson",69,70,66,"14:15:00",-5,"F",-8,205,null,null,null,null,null,null,16,{"$f":"SUBSTITUTE(INDEX($A:$J,R16,$S$2),\"*\",\"\")","v":"Jamie Donaldson"},-8,{"$f":"IF(ISERROR(INDEX($A:$J,R16,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R16,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T10","Graham DeLaet",69,68,68,"14:05:00",-3,"F",-8,205,null,null,null,null,null,null,17,{"$f":"SUBSTITUTE(INDEX($A:$J,R17,$S$2),\"*\",\"\")","v":"Graham DeLaet"},-8,{"$f":"IF(ISERROR(INDEX($A:$J,R17,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R17,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T10","Steve Stricker",69,68,68,"14:05:00",-3,"F",-8,205,null,null,null,null,null,null,18,{"$f":"SUBSTITUTE(INDEX($A:$J,R18,$S$2),\"*\",\"\")","v":"Steve Stricker"},-8,{"$f":"IF(ISERROR(INDEX($A:$J,R18,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R18,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T13","Hunter Mahan",70,71,65,"13:55:00",-6,"F",-7,206,null,null,null,null,null,null,19,{"$f":"SUBSTITUTE(INDEX($A:$J,R19,$S$2),\"*\",\"\")","v":"Hunter Mahan"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R19,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R19,$U$2)+TIME(5,0,0))","v":65.208333333333329},"F"]
[null,"T13","Adam Scott",71,69,66,"13:55:00",-5,"F",-7,206,null,null,null,null,null,null,20,{"$f":"SUBSTITUTE(INDEX($A:$J,R20,$S$2),\"*\",\"\")","v":"Adam Scott"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R20,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R20,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T13","Kevin Chappell",65,74,67,"13:45:00",-4,"F",-7,206,null,null,null,null,null,null,21,{"$f":"SUBSTITUTE(INDEX($A:$J,R21,$S$2),\"*\",\"\")","v":"Kevin Chappell"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R21,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R21,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T13","Lee Westwood",65,72,69,"13:45:00",-2,"F",-7,206,null,null,null,null,null,null,22,{"$f":"SUBSTITUTE(INDEX($A:$J,R22,$S$2),\"*\",\"\")","v":"Lee Westwood"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R22,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R22,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T13","Joost Luiten",68,69,69,"13:25:00",-2,"F",-7,206,null,null,null,null,null,null,23,{"$f":"SUBSTITUTE(INDEX($A:$J,R23,$S$2),\"*\",\"\")","v":"Joost Luiten"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R23,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R23,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T13","Jim Furyk",66,68,72,"13:25:00",1,"F",-7,206,null,null,null,null,null,null,24,{"$f":"SUBSTITUTE(INDEX($A:$J,R24,$S$2),\"*\",\"\")","v":"Jim Furyk"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R24,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R24,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T19","Brandt Snedeker",73,68,66,"13:15:00",-5,"F",-6,207,null,null,null,null,null,null,25,{"$f":"SUBSTITUTE(INDEX($A:$J,R25,$S$2),\"*\",\"\")","v":"Brandt Snedeker"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R25,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R25,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T19","Danny Willett",68,73,66,"13:15:00",-5,"F",-6,207,null,null,null,null,null,null,26,{"$f":"SUBSTITUTE(INDEX($A:$J,R26,$S$2),\"*\",\"\")","v":"Danny Willett"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R26,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R26,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T19","Bill Haas",71,68,68,"13:05:00",-3,"F",-6,207,null,null,null,null,null,null,27,{"$f":"SUBSTITUTE(INDEX($A:$J,R27,$S$2),\"*\",\"\")","v":"Bill Haas"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R27,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R27,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T19","Victor Dubuisson",69,68,70,"13:05:00",-1,"F",-6,207,null,null,null,null,null,null,28,{"$f":"SUBSTITUTE(INDEX($A:$J,R28,$S$2),\"*\",\"\")","v":"Victor Dubuisson"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R28,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R28,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T23","Marc Warren",71,71,66,"12:55:00",-5,"F",-5,208,null,null,null,null,null,null,29,{"$f":"SUBSTITUTE(INDEX($A:$J,R29,$S$2),\"*\",\"\")","v":"Marc Warren"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R29,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R29,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T23","Brooks Koepka",71,71,66,"12:55:00",-5,"F",-5,208,null,null,null,null,null,null,30,{"$f":"SUBSTITUTE(INDEX($A:$J,R30,$S$2),\"*\",\"\")","v":"Brooks Koepka"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R30,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R30,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T23","Sergio Garcia",70,72,66,"12:45:00",-5,"F",-5,208,null,null,null,null,null,null,31,{"$f":"SUBSTITUTE(INDEX($A:$J,R31,$S$2),\"*\",\"\")","v":"Sergio Garcia"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R31,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R31,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T23","Ryan Moore",73,68,67,"12:45:00",-4,"F",-5,208,null,null,null,null,null,null,32,{"$f":"SUBSTITUTE(INDEX($A:$J,R32,$S$2),\"*\",\"\")","v":"Ryan Moore"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R32,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R32,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T23","Jimmy Walker",69,71,68,"12:35:00",-3,"F",-5,208,null,null,null,null,null,null,33,{"$f":"SUBSTITUTE(INDEX($A:$J,R33,$S$2),\"*\",\"\")","v":"Jimmy Walker"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R33,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R33,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T23","Ernie Els",70,70,68,"12:35:00",-3,"F",-5,208,null,null,null,null,null,null,34,{"$f":"SUBSTITUTE(INDEX($A:$J,R34,$S$2),\"*\",\"\")","v":"Ernie Els"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R34,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R34,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T23","Alexander Levy",69,71,68,"12:25:00",-3,"F",-5,208,null,null,null,null,null,null,35,{"$f":"SUBSTITUTE(INDEX($A:$J,R35,$S$2),\"*\",\"\")","v":"Alexander Levy"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R35,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R35,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T23","Billy Horschel",71,68,69,"12:25:00",-2,"F",-5,208,null,null,null,null,null,null,36,{"$f":"SUBSTITUTE(INDEX($A:$J,R36,$S$2),\"*\",\"\")","v":"Billy Horschel"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R36,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R36,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T23","Nick Watney",69,69,70,"12:15:00",-1,"F",-5,208,null,null,null,null,null,null,37,{"$f":"SUBSTITUTE(INDEX($A:$J,R37,$S$2),\"*\",\"\")","v":"Nick Watney"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R37,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R37,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T32","Justin Rose",70,72,67,"12:15:00",-4,"F",-4,209,null,null,null,null,null,null,38,{"$f":"SUBSTITUTE(INDEX($A:$J,R38,$S$2),\"*\",\"\")","v":"Justin Rose"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R38,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R38,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T32","Jonas Blixt",71,70,68,"11:55:00",-3,"F",-4,209,null,null,null,null,null,null,39,{"$f":"SUBSTITUTE(INDEX($A:$J,R39,$S$2),\"*\",\"\")","v":"Jonas Blixt"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R39,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R39,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T32","Brian Harman",71,69,69,"11:55:00",-2,"F",-4,209,null,null,null,null,null,null,40,{"$f":"SUBSTITUTE(INDEX($A:$J,R40,$S$2),\"*\",\"\")","v":"Brian Harman"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R40,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R40,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T32","Charl Schwartzel",72,68,69,"11:45:00",-2,"F",-4,209,null,null,null,null,null,null,41,{"$f":"SUBSTITUTE(INDEX($A:$J,R41,$S$2),\"*\",\"\")","v":"Charl Schwartzel"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R41,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R41,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T32","J.B. Holmes",68,72,69,"11:45:00",-2,"F",-4,209,null,null,null,null,null,null,42,{"$f":"SUBSTITUTE(INDEX($A:$J,R42,$S$2),\"*\",\"\")","v":"J.B. Holmes"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R42,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R42,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T32","Chris Wood",66,73,70,"11:35:00",-1,"F",-4,209,null,null,null,null,null,null,43,{"$f":"SUBSTITUTE(INDEX($A:$J,R43,$S$2),\"*\",\"\")","v":"Chris Wood"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R43,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R43,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T38","Daniel Summerhays",70,72,68,"11:35:00",-3,"F",-3,210,null,null,null,null,null,null,44,{"$f":"SUBSTITUTE(INDEX($A:$J,R44,$S$2),\"*\",\"\")","v":"Daniel Summerhays"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R44,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R44,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T38","Luke Donald",70,72,68,"11:25:00",-3,"F",-3,210,null,null,null,null,null,null,45,{"$f":"SUBSTITUTE(INDEX($A:$J,R45,$S$2),\"*\",\"\")","v":"Luke Donald"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R45,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R45,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T38","Kenny Perry",72,69,69,"11:25:00",-2,"F",-3,210,null,null,null,null,null,null,46,{"$f":"SUBSTITUTE(INDEX($A:$J,R46,$S$2),\"*\",\"\")","v":"Kenny Perry"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R46,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R46,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T38","Edoardo Molinari",66,73,71,"11:15:00","E","F",-3,210,null,null,null,null,null,null,47,{"$f":"SUBSTITUTE(INDEX($A:$J,R47,$S$2),\"*\",\"\")","v":"Edoardo Molinari"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R47,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R47,$U$2)+TIME(5,0,0))","v":71.208333333333329},"F"]
[null,"T42","Branden Grace",73,70,68,"11:15:00",-3,"F",-2,211,null,null,null,null,null,null,48,{"$f":"SUBSTITUTE(INDEX($A:$J,R48,$S$2),\"*\",\"\")","v":"Branden Grace"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R48,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R48,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T42","Patrick Reed",70,71,70,"11:05:00",-1,"F",-2,211,null,null,null,null,null,null,49,{"$f":"SUBSTITUTE(INDEX($A:$J,R49,$S$2),\"*\",\"\")","v":"Patrick Reed"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R49,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R49,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T42","Jerry Kelly",67,74,70,"11:05:00",-1,"F",-2,211,null,null,null,null,null,null,50,{"$f":"SUBSTITUTE(INDEX($A:$J,R50,$S$2),\"*\",\"\")","v":"Jerry Kelly"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R50,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R50,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T42","Scott Brown",71,70,70,"10:55:00",-1,"F",-2,211,null,null,null,null,null,null,51,{"$f":"SUBSTITUTE(INDEX($A:$J,R51,$S$2),\"*\",\"\")","v":"Scott Brown"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R51,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R51,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T42","Geoff Ogilvy",69,71,71,"10:55:00","E","F",-2,211,null,null,null,null,null,null,52,{"$f":"SUBSTITUTE(INDEX($A:$J,R52,$S$2),\"*\",\"\")","v":"Geoff Ogilvy"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R52,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R52,$U$2)+TIME(5,0,0))","v":71.208333333333329},"F"]
[null,"T42","Cameron Tringale",69,71,71,"10:45:00","E","F",-2,211,null,null,null,null,null,null,53,{"$f":"SUBSTITUTE(INDEX($A:$J,R53,$S$2),\"*\",\"\")","v":"Cameron Tringale"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R53,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R53,$U$2)+TIME(5,0,0))","v":71.208333333333329},"F"]
[null,"T42","Matt Jones",68,71,72,"10:45:00",1,"F",-2,211,null,null,null,null,null,null,54,{"$f":"SUBSTITUTE(INDEX($A:$J,R54,$S$2),\"*\",\"\")","v":"Matt Jones"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R54,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R54,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T42","Richard Sterne",70,69,72,"10:25:00",1,"F",-2,211,null,null,null,null,null,null,55,{"$f":"SUBSTITUTE(INDEX($A:$J,R55,$S$2),\"*\",\"\")","v":"Richard Sterne"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R55,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R55,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T50","Zach Johnson",70,72,70,"10:25:00",-1,"F",-1,212,null,null,null,null,null,null,56,{"$f":"SUBSTITUTE(INDEX($A:$J,R56,$S$2),\"*\",\"\")","v":"Zach Johnson"},-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":70.208333333333329},"F"]
[null,"T50","Thorbjorn Olesen",71,71,70,"10:15:00",-1,"F",-1,212,null,null,null,null,null,null,57,{"$f":"SUBSTITUTE(INDEX($A:$J,R57,$S$2),\"*\",\"\")","v":"Thorbjorn Olesen"},-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":70.208333333333329},"F"]
[null,"T50","Ian Poulter",68,73,71,"10:15:00","E","F",-1,212,null,null,null,null,null,null,58,{"$f":"SUBSTITUTE(INDEX($A:$J,R58,$S$2),\"*\",\"\")","v":"Ian Poulter"},-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":71.208333333333329},"F"]
[null,"T50","Fabrizio Zanotti",71,70,71,"10:05:00","E","F",-1,212,null,null,null,null,null,null,59,{"$f":"SUBSTITUTE(INDEX($A:$J,R59,$S$2),\"*\",\"\")","v":"Fabrizio Zanotti"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R59,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R59,$U$2)+TIME(5,0,0))","v":71.208333333333329},"F"]
[null,"T50","Brendon de Jonge",70,70,72,"10:05:00",1,"F",-1,212,null,null,null,null,null,null,60,{"$f":"SUBSTITUTE(INDEX($A:$J,R60,$S$2),\"*\",\"\")","v":"Brendon de Jonge"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R60,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R60,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T50","Vijay Singh",71,68,73,"09:55:00",2,"F",-1,212,null,null,null,null,null,null,61,{"$f":"SUBSTITUTE(INDEX($A:$J,R61,$S$2),\"*\",\"\")","v":"Vijay Singh"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R61,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R61,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T56","Hideki Matsuyama",71,72,70,"09:55:00",-1,"F","E",213,null,null,null,null,null,null,62,{"$f":"SUBSTITUTE(INDEX($A:$J,R62,$S$2),\"*\",\"\")","v":"Hideki Matsuyama"},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":70.208333333333329},"F"]
[null,"T56","Pat Perez",71,71,71,"09:45:00","E","F","E",213,null,null,null,null,null,null,63,{"$f":"SUBSTITUTE(INDEX($A:$J,R63,$S$2),\"*\",\"\")","v":"Pat Perez"},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":71.208333333333329},"F"]
[null,"T56","Jason Bohn",71,71,71,"09:45:00","E","F","E",213,null,null,null,null,null,null,64,{"$f":"SUBSTITUTE(INDEX($A:$J,R64,$S$2),\"*\",\"\")","v":"Jason Bohn"},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":71.208333333333329},"F"]
[null,"T56","Koumei Oda",74,68,71,"09:35:00","E","F","E",213,null,null,null,null,null,null,65,{"$f":"SUBSTITUTE(INDEX($A:$J,R65,$S$2),\"*\",\"\")","v":"Koumei Oda"},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":71.208333333333329},"F"]
[null,"T56","Francesco Molinari",71,71,71,"09:35:00","E","F","E",213,null,null,null,null,null,null,66,{"$f":"SUBSTITUTE(INDEX($A:$J,R66,$S$2),\"*\",\"\")","v":"Francesco Molinari"},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":71.208333333333329},"F"]
[null,"T56","Kevin Stadler",71,70,72,"09:25:00",1,"F","E",213,null,null,null,null,null,null,67,{"$f":"SUBSTITUTE(INDEX($A:$J,R67,$S$2),\"*\",\"\")","v":"Kevin Stadler"},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":72.208333333333329},"F"]
[null,"T56","Gonzalo Fernandez-Casta",71,70,72,"09:25:00",1,"F","E",213,null,null,null,null,null,null,68,{"$f":"SUBSTITUTE(INDEX($A:$J,R68,$S$2),\"*\",\"\")","v":"Gonzalo Fernandez-Casta"},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":72.208333333333329},"F"]
[null,"T63","Graeme McDowell",73,70,71,"09:15:00","E","F",1,214,null,null,null,null,null,null,69,{"$f":"SUBSTITUTE(INDEX($A:$J,R69,$S$2),\"*\",\"\")","v":"Graeme McDowell"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R69,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R69,$U$2)+TIME(5,0,0))","v":71.208333333333329},"F"]
[null,"T63","Marc Leishman",71,71,72,"09:15:00",1,"F",1,214,null,null,null,null,null,null,70,{"$f":"SUBSTITUTE(INDEX($A:$J,R70,$S$2),\"*\",\"\")","v":"Marc Leishman"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R70,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R70,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T63","Colin Montgomerie",70,72,72,"09:05:00",1,"F",1,214,null,null,null,null,null,null,71,{"$f":"SUBSTITUTE(INDEX($A:$J,R71,$S$2),\"*\",\"\")","v":"Colin Montgomerie"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R71,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R71,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T63","Brendan Steele",71,70,73,"09:05:00",2,"F",1,214,null,null,null,null,null,null,72,{"$f":"SUBSTITUTE(INDEX($A:$J,R72,$S$2),\"*\",\"\")","v":"Brendan Steele"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R72,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R72,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T63","Fredrik Jacobson",72,69,73,"08:55:00",2,"F",1,214,null,null,null,null,null,null,{"$f":"R72+1","v":73},{"$f":"SUBSTITUTE(INDEX($A:$J,R73,$S$2),\"*\",\"\")","v":"Fredrik Jacobson"},{"$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":1},{"$f":"IF(ISERROR(INDEX($A:$J,R73,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R73,$U$2)+TIME(5,0,0))","v":73.208333333333329},{"$f":"INDEX($A:$N,R73,$V$2)","v":"F"}]
[null,"T63","Rafael Cabrera-Bello",69,71,74,"08:55:00",3,"F",1,214,null,null,null,null,null,null,74,{"$f":"SUBSTITUTE(INDEX($A:$J,R74,$S$2),\"*\",\"\")","v":"Rafael Cabrera-Bello"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R74,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R74,$U$2)+TIME(5,0,0))","v":74.208333333333329},"F"]
[null,"T63","Robert Karlsson",71,69,74,"08:45:00",3,"F",1,214,null,null,null,null,null,null,75,{"$f":"SUBSTITUTE(INDEX($A:$J,R75,$S$2),\"*\",\"\")","v":"Robert Karlsson"},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":74.208333333333329},"F"]
[null,"T70","Shawn Stefani",68,75,72,"08:45:00",1,"F",2,215,null,null,null,null,null,null,76,{"$f":"SUBSTITUTE(INDEX($A:$J,R76,$S$2),\"*\",\"\")","v":"Shawn Stefani"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R76,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R76,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T70","Bubba Watson",70,72,73,"08:35:00",2,"F",2,215,null,null,null,null,null,null,77,{"$f":"SUBSTITUTE(INDEX($A:$J,R77,$S$2),\"*\",\"\")","v":"Bubba Watson"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R77,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R77,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T72","Chris Stroud",70,73,73,"08:35:00",2,"F",3,216,null,null,null,null,null,null,78,{"$f":"SUBSTITUTE(INDEX($A:$J,R78,$S$2),\"*\",\"\")","v":"Chris Stroud"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R78,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R78,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T72","Shane Lowry",68,74,74,"08:25:00",3,"F",3,216,null,null,null,null,null,null,79,{"$f":"SUBSTITUTE(INDEX($A:$J,R79,$S$2),\"*\",\"\")","v":"Shane Lowry"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R79,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R79,$U$2)+TIME(5,0,0))","v":74.208333333333329},"F"]
[null,74,"Brendon Todd",70,73,75,"08:25:00",4,"F",5,218,null,null,null,null,null,null,80,{"$f":"SUBSTITUTE(INDEX($A:$J,R80,$S$2),\"*\",\"\")","v":"Brendon Todd"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R80,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R80,$U$2)+TIME(5,0,0))","v":75.208333333333329},"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","Tim Clark",70,74,"MC","MC","-","-","-",144,null,null,null,null,null,null,82,{"$f":"SUBSTITUTE(INDEX($A:$J,R82,$S$2),\"*\",\"\")","v":"Tim Clark"},"-",{"$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","Tommy Fleetwood",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,84,{"$f":"SUBSTITUTE(INDEX($A:$J,R84,$S$2),\"*\",\"\")","v":"Tommy Fleetwood"},"-",{"$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","Padraig Harrington",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,85,{"$f":"SUBSTITUTE(INDEX($A:$J,R85,$S$2),\"*\",\"\")","v":"Padraig Harrington"},"-",{"$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","Ryan Helminen",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,86,{"$f":"SUBSTITUTE(INDEX($A:$J,R86,$S$2),\"*\",\"\")","v":"Ryan Helminen"},"-",{"$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","Russell Henley",69,75,"MC","MC","-","-","-",144,null,null,null,null,null,null,87,{"$f":"SUBSTITUTE(INDEX($A:$J,R87,$S$2),\"*\",\"\")","v":"Russell Henley"},"-",{"$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","Charley Hoffman",70,74,"MC","MC","-","-","-",144,null,null,null,null,null,null,88,{"$f":"SUBSTITUTE(INDEX($A:$J,R88,$S$2),\"*\",\"\")","v":"Charley Hoffman"},"-",{"$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","Martin Kaymer",70,74,"MC","MC","-","-","-",144,null,null,null,null,null,null,89,{"$f":"SUBSTITUTE(INDEX($A:$J,R89,$S$2),\"*\",\"\")","v":"Martin Kaymer"},"-",{"$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","Scott Piercy",73,71,"MC","MC","-","-","-",144,null,null,null,null,null,null,90,{"$f":"SUBSTITUTE(INDEX($A:$J,R90,$S$2),\"*\",\"\")","v":"Scott Piercy"},"-",{"$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","Gary Woodland",72,72,"MC","MC","-","-","-",144,null,null,null,null,null,null,91,{"$f":"SUBSTITUTE(INDEX($A:$J,R91,$S$2),\"*\",\"\")","v":"Gary Woodland"},"-",{"$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","Matt Every",73,72,"MC","MC","-","-","-",145,null,null,null,null,null,null,92,{"$f":"SUBSTITUTE(INDEX($A:$J,R92,$S$2),\"*\",\"\")","v":"Matt Every"},"-",{"$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","Russell Knox",75,70,"MC","MC","-","-","-",145,null,null,null,null,null,null,93,{"$f":"SUBSTITUTE(INDEX($A:$J,R93,$S$2),\"*\",\"\")","v":"Russell Knox"},"-",{"$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","Johan Kok",78,67,"MC","MC","-","-","-",145,null,null,null,null,null,null,94,{"$f":"SUBSTITUTE(INDEX($A:$J,R94,$S$2),\"*\",\"\")","v":"Johan Kok"},"-",{"$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","Anirban Lahiri",72,73,"MC","MC","-","-","-",145,null,null,null,null,null,null,95,{"$f":"SUBSTITUTE(INDEX($A:$J,R95,$S$2),\"*\",\"\")","v":"Anirban Lahiri"},"-",{"$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","Davis Love III",72,73,"MC","MC","-","-","-",145,null,null,null,null,null,null,96,{"$f":"SUBSTITUTE(INDEX($A:$J,R96,$S$2),\"*\",\"\")","v":"Davis Love III"},"-",{"$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","Seung-yul Noh",68,77,"MC","MC","-","-","-",145,null,null,null,null,null,null,98,{"$f":"SUBSTITUTE(INDEX($A:$J,R98,$S$2),\"*\",\"\")","v":"Seung-yul Noh"},"-",{"$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","Kevin Streelman",69,76,"MC","MC","-","-","-",145,null,null,null,null,null,null,99,{"$f":"SUBSTITUTE(INDEX($A:$J,R99,$S$2),\"*\",\"\")","v":"Kevin Streelman"},"-",{"$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","Brian Stuard",71,74,"MC","MC","-","-","-",145,null,null,null,null,null,null,100,{"$f":"SUBSTITUTE(INDEX($A:$J,R100,$S$2),\"*\",\"\")","v":"Brian Stuard"},"-",{"$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","Tom Watson",72,73,"MC","MC","-","-","-",145,null,null,null,null,null,null,101,{"$f":"SUBSTITUTE(INDEX($A:$J,R101,$S$2),\"*\",\"\")","v":"Tom Watson"},"-",{"$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","Steven Bowditch",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,102,{"$f":"SUBSTITUTE(INDEX($A:$J,R102,$S$2),\"*\",\"\")","v":"Steven Bowditch"},"-",{"$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","Keegan Bradley",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,103,{"$f":"SUBSTITUTE(INDEX($A:$J,R103,$S$2),\"*\",\"\")","v":"Keegan Bradley"},"-",{"$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","Jamie Broce",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,104,{"$f":"SUBSTITUTE(INDEX($A:$J,R104,$S$2),\"*\",\"\")","v":"Jamie Broce"},"-",{"$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","Paul Casey",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,105,{"$f":"SUBSTITUTE(INDEX($A:$J,R105,$S$2),\"*\",\"\")","v":"Paul Casey"},"-",{"$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","Roberto Castro",73,73,"MC","MC","-","-","-",146,null,null,null,null,null,null,106,{"$f":"SUBSTITUTE(INDEX($A:$J,R106,$S$2),\"*\",\"\")","v":"Roberto Castro"},"-",{"$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","Stuart Deane",75,71,"MC","MC","-","-","-",146,null,null,null,null,null,null,107,{"$f":"SUBSTITUTE(INDEX($A:$J,R107,$S$2),\"*\",\"\")","v":"Stuart Deane"},"-",{"$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","Harris English",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,108,{"$f":"SUBSTITUTE(INDEX($A:$J,R108,$S$2),\"*\",\"\")","v":"Harris English"},"-",{"$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","Ross Fisher",73,73,"MC","MC","-","-","-",146,null,null,null,null,null,null,109,{"$f":"SUBSTITUTE(INDEX($A:$J,R109,$S$2),\"*\",\"\")","v":"Ross Fisher"},"-",{"$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","David Hearn",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,110,{"$f":"SUBSTITUTE(INDEX($A:$J,R110,$S$2),\"*\",\"\")","v":"David Hearn"},"-",{"$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","Ryo Ishikawa",72,74,"MC","MC","-","-","-",146,null,null,null,null,null,null,111,{"$f":"SUBSTITUTE(INDEX($A:$J,R111,$S$2),\"*\",\"\")","v":"Ryo Ishikawa"},"-",{"$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","Chris Kirk",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,112,{"$f":"SUBSTITUTE(INDEX($A:$J,R112,$S$2),\"*\",\"\")","v":"Chris Kirk"},"-",{"$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","Kevin Na",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,113,{"$f":"SUBSTITUTE(INDEX($A:$J,R113,$S$2),\"*\",\"\")","v":"Kevin Na"},"-",{"$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","Rory Sabbatini",75,71,"MC","MC","-","-","-",146,null,null,null,null,null,null,114,{"$f":"SUBSTITUTE(INDEX($A:$J,R114,$S$2),\"*\",\"\")","v":"Rory Sabbatini"},"-",{"$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","Hideto Tanihara",74,72,"MC","MC","-","-","-",146,null,null,null,null,null,null,115,{"$f":"SUBSTITUTE(INDEX($A:$J,R115,$S$2),\"*\",\"\")","v":"Hideto Tanihara"},"-",{"$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","Y.E. Yang",75,71,"MC","MC","-","-","-",146,null,null,null,null,null,null,116,{"$f":"SUBSTITUTE(INDEX($A:$J,R116,$S$2),\"*\",\"\")","v":"Y.E. Yang"},"-",{"$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","Stewart Cink",72,75,"MC","MC","-","-","-",147,null,null,null,null,null,null,117,{"$f":"SUBSTITUTE(INDEX($A:$J,R117,$S$2),\"*\",\"\")","v":"Stewart Cink"},"-",{"$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","George Coetzee",73,74,"MC","MC","-","-","-",147,null,null,null,null,null,null,118,{"$f":"SUBSTITUTE(INDEX($A:$J,R118,$S$2),\"*\",\"\")","v":"George Coetzee"},"-",{"$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","Stephen Gallacher",70,77,"MC","MC","-","-","-",147,null,null,null,null,null,null,119,{"$f":"SUBSTITUTE(INDEX($A:$J,R119,$S$2),\"*\",\"\")","v":"Stephen Gallacher"},"-",{"$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","Chesson Hadley",74,73,"MC","MC","-","-","-",147,null,null,null,null,null,null,120,{"$f":"SUBSTITUTE(INDEX($A:$J,R120,$S$2),\"*\",\"\")","v":"Chesson Hadley"},"-",{"$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","Charles Howell III",73,74,"MC","MC","-","-","-",147,null,null,null,null,null,null,121,{"$f":"SUBSTITUTE(INDEX($A:$J,R121,$S$2),\"*\",\"\")","v":"Charles Howell III"},"-",{"$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","Webb Simpson",73,74,"MC","MC","-","-","-",147,null,null,null,null,null,null,122,{"$f":"SUBSTITUTE(INDEX($A:$J,R122,$S$2),\"*\",\"\")","v":"Webb Simpson"},"-",{"$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","Eric Williamson",74,73,"MC","MC","-","-","-",147,null,null,null,null,null,null,123,{"$f":"SUBSTITUTE(INDEX($A:$J,R123,$S$2),\"*\",\"\")","v":"Eric Williamson"},"-",{"$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","John Daly",76,72,"MC","MC","-","-","-",148,null,null,null,null,null,null,125,{"$f":"SUBSTITUTE(INDEX($A:$J,R125,$S$2),\"*\",\"\")","v":"John Daly"},"-",{"$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","Hyung-Sung Kim",73,75,"MC","MC","-","-","-",148,null,null,null,null,null,null,126,{"$f":"SUBSTITUTE(INDEX($A:$J,R126,$S$2),\"*\",\"\")","v":"Hyung-Sung Kim"},"-",{"$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","Pablo Larrazabal",79,69,"MC","MC","-","-","-",148,null,null,null,null,null,null,127,{"$f":"SUBSTITUTE(INDEX($A:$J,R127,$S$2),\"*\",\"\")","v":"Pablo Larrazabal"},"-",{"$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","George McNeill",73,75,"MC","MC","-","-","-",148,null,null,null,null,null,null,128,{"$f":"SUBSTITUTE(INDEX($A:$J,R128,$S$2),\"*\",\"\")","v":"George McNeill"},"-",{"$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","Jordan Spieth",71,77,"MC","MC","-","-","-",148,null,null,null,null,null,null,129,{"$f":"SUBSTITUTE(INDEX($A:$J,R129,$S$2),\"*\",\"\")","v":"Jordan Spieth"},"-",{"$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","Tiger Woods",74,74,"MC","MC","-","-","-",148,null,null,null,null,null,null,130,{"$f":"SUBSTITUTE(INDEX($A:$J,R130,$S$2),\"*\",\"\")","v":"Tiger Woods"},"-",{"$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","Miguel Angel Jimenez",72,77,"MC","MC","-","-","-",149,null,null,null,null,null,null,131,{"$f":"SUBSTITUTE(INDEX($A:$J,R131,$S$2),\"*\",\"\")","v":"Miguel Angel Jimenez"},"-",{"$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","Rod Perry",74,75,"MC","MC","-","-","-",149,null,null,null,null,null,null,132,{"$f":"SUBSTITUTE(INDEX($A:$J,R132,$S$2),\"*\",\"\")","v":"Rod Perry"},"-",{"$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","John Senden",75,74,"MC","MC","-","-","-",149,null,null,null,null,null,null,133,{"$f":"SUBSTITUTE(INDEX($A:$J,R133,$S$2),\"*\",\"\")","v":"John Senden"},"-",{"$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","Scott Stallings",71,78,"MC","MC","-","-","-",149,null,null,null,null,null,null,134,{"$f":"SUBSTITUTE(INDEX($A:$J,R134,$S$2),\"*\",\"\")","v":"Scott Stallings"},"-",{"$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","Thomas Bjorn",75,75,"MC","MC","-","-","-",150,null,null,null,null,null,null,135,{"$f":"SUBSTITUTE(INDEX($A:$J,R135,$S$2),\"*\",\"\")","v":"Thomas Bjorn"},"-",{"$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","Thongchai Jaidee",71,79,"MC","MC","-","-","-",150,null,null,null,null,null,null,136,{"$f":"SUBSTITUTE(INDEX($A:$J,R136,$S$2),\"*\",\"\")","v":"Thongchai Jaidee"},"-",{"$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","Will MacKenzie",76,74,"MC","MC","-","-","-",150,null,null,null,null,null,null,{"$f":"R136+1","v":137},{"$f":"SUBSTITUTE(INDEX($A:$J,R137,$S$2),\"*\",\"\")","v":"Will MacKenzie"},{"$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","Steve Schneiter",72,78,"MC","MC","-","-","-",150,null,null,null,null,null,null,138,{"$f":"SUBSTITUTE(INDEX($A:$J,R138,$S$2),\"*\",\"\")","v":"Steve Schneiter"},"-",{"$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","Bob Sowards",75,75,"MC","MC","-","-","-",150,null,null,null,null,null,null,139,{"$f":"SUBSTITUTE(INDEX($A:$J,R139,$S$2),\"*\",\"\")","v":"Bob Sowards"},"-",{"$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","K.J. Choi",72,79,"MC","MC","-","-","-",151,null,null,null,null,null,null,141,{"$f":"SUBSTITUTE(INDEX($A:$J,R141,$S$2),\"*\",\"\")","v":"K.J. Choi"},"-",{"$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","John Huh",78,73,"MC","MC","-","-","-",151,null,null,null,null,null,null,142,{"$f":"SUBSTITUTE(INDEX($A:$J,R142,$S$2),\"*\",\"\")","v":"John Huh"},"-",{"$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","Jason Kokrak",78,73,"MC","MC","-","-","-",151,null,null,null,null,null,null,143,{"$f":"SUBSTITUTE(INDEX($A:$J,R143,$S$2),\"*\",\"\")","v":"Jason Kokrak"},"-",{"$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","Shaun Micheel",72,79,"MC","MC","-","-","-",151,null,null,null,null,null,null,144,{"$f":"SUBSTITUTE(INDEX($A:$J,R144,$S$2),\"*\",\"\")","v":"Shaun Micheel"},"-",{"$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","Mark Brooks",78,79,"MC","MC","-","-","-",157,null,null,null,null,null,null,148,{"$f":"SUBSTITUTE(INDEX($A:$J,R148,$S$2),\"*\",\"\")","v":"Mark Brooks"},"-",{"$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","Matteo Manassero",80,77,"MC","MC","-","-","-",157,null,null,null,null,null,null,149,{"$f":"SUBSTITUTE(INDEX($A:$J,R149,$S$2),\"*\",\"\")","v":"Matteo Manassero"},"-",{"$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","Jim McGovern",83,74,"MC","MC","-","-","-",157,null,null,null,null,null,null,150,{"$f":"SUBSTITUTE(INDEX($A:$J,R150,$S$2),\"*\",\"\")","v":"Jim McGovern"},"-",{"$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","David Hronek",81,77,"MC","MC","-","-","-",158,null,null,null,null,null,null,152,{"$f":"SUBSTITUTE(INDEX($A:$J,R152,$S$2),\"*\",\"\")","v":"David Hronek"},"-",{"$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","Jerry Smith",80,78,"MC","MC","-","-","-",158,null,null,null,null,null,null,153,{"$f":"SUBSTITUTE(INDEX($A:$J,R153,$S$2),\"*\",\"\")","v":"Jerry Smith"},"-",{"$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","Dave Tentis",79,79,"MC","MC","-","-","-",158,null,null,null,null,null,null,154,{"$f":"SUBSTITUTE(INDEX($A:$J,R154,$S$2),\"*\",\"\")","v":"Dave Tentis"},"-",{"$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,"WD","WD","WD","-","-","-",72,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,"Ben Crane",74,"WD","WD","WD","-","-","-",74,null,null,null,null,null,null,160,{"$f":"SUBSTITUTE(INDEX($A:$J,R160,$S$2),\"*\",\"\")","v":"Ben Crane"},"-",{"$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,"Boo Weekley",80,"WD","WD","WD","-","-","-",80,null,null,null,null,null,null,161,{"$f":"SUBSTITUTE(INDEX($A:$J,R161,$S$2),\"*\",\"\")","v":"Boo Weekley"},"-",{"$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,"Angel Cabrera",82,"WD","WD","WD","-","-","-",82,null,null,null,null,null,null,162,{"$f":"SUBSTITUTE(INDEX($A:$J,R162,$S$2),\"*\",\"\")","v":"Angel Cabrera"},"-",{"$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":-12},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+3)","v":-12.044},{"$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":-19},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+3)","v":-19.033999999999999},4,{"$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":-21},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+3)","v":-21.047999999999998},2,2,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":-19},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+3)","v":-19.045999999999999},4,4,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":-23},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+3)","v":-23.03},1,1,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":-20},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+3)","v":-20.038},3,3,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":-8},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+3)","v":-8.0399999999999991},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,"JOHN C",-23,-23.03,1,1,null,null,"STUART D",-1,-1.04,7,7]
[null,1,"BYRON",-21,-21.047999999999998,2,2]
[null,1,"CRAIG T",-20,-20.038,3,3,null,"round 3","Player","Score","Score adj","Rank","Rank adj"]
[null,1,"STEVER",-19,-19.045999999999999,4,4,null,null,"JOHN C",-23,-23.03,1,1]
[null,13,"TEZ",-19,-19.033999999999999,4,5,null,null,"BYRON",-21,-21.047999999999998,2,2]
[null,7,"DEANO",-12,-12.044,6,6,null,null,"CRAIG T",-20,-20.038,3,3]
[null,1,"STUART D",-8,-8.0399999999999991,7,7,null,null,"STEVER",-19,-19.045999999999999,4,4]
[null,7,0,"","","","",null,null,"TEZ",-19,-19.033999999999999,4,5]
[null,7,0,"","","","",null,null,"DEANO",-12,-12.044,6,6]
[null,13,"Dean","","","","",null,null,"STUART D",-8,-8.0399999999999991,7,7]
[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.99763416230798196},0.70434032056060647,0.96263451243283782,0.10354722468304323,0.89620581074232875,0.17871646130934604,0.18689602287991958,0.1162253320642096,1.2438289747082276E-2,0.76772824074035706]
["R2",0.12001521835347195,0.55609372933405365,0.54770966200385818,6.1124397385721396E-2,0.17159727740793596,0.84456073108882335,0.55371882105309955,0.46433113706564788,0.54132433041971861,0.8065169607206053]
["R3",0.3086854771403732,7.1317175297548996E-2,0.64431973266639908,0.88367328541384382,0.52408301892587905,0.7652470755146541,0.6869962228381874,6.8336150851349919E-2,0.15884075929989105,0.44670686962452866]
["R4",0.33440822598267206,0.4509332444589782,0.48052483737679685,0.63647283862906567,0.91003088394212295,0.8005355833020853,5.3608179561971836E-2,0.40609746381799561,0.69849657145269728,0.73012785869884589]
["R5",0.47782591205439118,0.53236946307875355,4.2178442068282251E-2,0.96488729191408462,0.51943536231996468,0.1664761033427028,0.49148426430697856,6.7380945985922147E-2,0.25821639465164459,0.78529732774242889]
["R1",{"$f":"RANK(B4,$B4:$L4)","v":1},5,2,9,3,7,6,8,10,4]
["R2",{"$f":"RANK(B5,$B5:$L5)","v":9},3,5,10,8,1,4,7,6,2]
["R3",{"$f":"RANK(B6,$B6:$L6)","v":7},9,4,1,5,2,3,10,8,6]
["R4",{"$f":"RANK(B7,$B7:$L7)","v":9},7,6,5,1,2,10,8,4,3]
["R5",{"$f":"RANK(B8,$B8:$L8)","v":6},3,10,1,4,8,5,9,7,2]
[]
["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.76714218104435772},0.34173196815408524,0.83206430661331998,0.11182764450601612,0.13293851299718229,0.82035605356585317,9.9729960958864439E-2,0.97050537777619683,0.37331962491372739,0.43555950280444855,0.97379558547314937]
["R2",0.25247157982446355,0.82092760863636627,0.3592618601963905,0.54989680373421979,0.46532153818213651,9.963435919373409E-2,0.98320101679187211,0.55767755485552417,0.71767635273574693,2.0634085567519556E-2,1.0131249428776079E-2]
["R3",0.78275434475558303,0.25779494620298993,0.47177531086629731,0.289754185797097,0.86694960403140886,0.29480382978763287,0.76423044008608709,0.70489739833581821,0.83925844871970046,0.27676365122723501,0.22619850945228193]
["R4",0.22788594452376609,4.1534808990315586E-2,0.97648365215011557,0.95456085022314019,0.49418854689461578,7.2135953426727517E-2,8.3960325996291663E-2,0.12109154300174552,0.9294007989677544,0.17140481475285152,0.35227615217844299]
["R5",0.1256205097487102,0.10237483306016282,0.89196137412942134,0.51292196621206487,0.75532107355038136,0.65588549926635709,0.26737093922821542,0.80356972198291132,0.25748108086190902,0.99457316530099948,0.76856240970167577]
["R1",{"$f":"RANK(B23,$B23:$L23)","v":5},8,3,10,9,4,11,2,7,{"$f":"RANK(K23,$B23:$L23)","v":6},1]
["R2",{"$f":"RANK(B24,$B24:$L24)","v":8},2,7,5,6,9,1,4,3,{"$f":"RANK(K24,$B24:$L24)","v":10},11]
["R3",{"$f":"RANK(B25,$B25:$L25)","v":3},10,6,8,1,7,4,5,2,{"$f":"RANK(K25,$B25:$L25)","v":9},11]
["R4",{"$f":"RANK(B26,$B26:$L26)","v":6},11,1,2,4,10,9,8,3,{"$f":"RANK(K26,$B26:$L26)","v":7},5]
["R5",{"$f":"RANK(B27,$B27:$L27)","v":10},11,2,7,5,6,8,3,9,{"$f":"RANK(K27,$B27:$L27)","v":1},4]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0]
["R1",0.62158245207514262,0.72287110713841363,0.9442668107739387,0.23928096936665899,0.81028417405066278,3.3408901900710886E-2,0.70609647295277078,0.81217143507141676,0.27376310718389463,0.62354799839371178,0.97516887403067587,0.36262636500604883]
["R2",0.21460642975029631,0.54423980074375788,0.52487418156266497,0.41330264506749248,0.14158060454419286,0.55080230530398866,6.3877242314125948E-2,0.59329301553203606,0.97731117179859761,0.76378865037916899,0.58515794004058042,0.67399931101651966]
["R3",0.34104326549549158,0.87832161733144098,0.16756610080500911,9.7602083448218413E-2,0.26787299908476558,0.83508842154032104,2.2491644828156798E-2,0.27020850260477192,5.7543060503358778E-2,0.39607538849989032,7.4300107579888808E-2,0.85137996575798514]
["R4",0.34569183964793004,0.70522309362872715,0.52824346319311932,0.73897092234246142,0.37096569070978602,0.76224945156299606,0.72321299622316282,0.22215150599821221,0.89437295324627286,0.24758911360468083,0.60864567250297419,0.87182304617571893]
["R5",0.8957182788496566,0.58541000332733495,0.38880250730015442,0.67723992906247998,0.89717947840615853,0.3896931476295008,0.98464079341498822,0.31821137648130549,0.87504145952301016,0.29619901131755388,0.84890272747883933,0.8394028070935563]
["R1",{"$f":"RANK(B34,$B34:$M34)","v":8},5,2,11,4,12,6,3,10,{"$f":"RANK(K34,$B34:$M34)","v":7},1,9]
["R2",{"$f":"RANK(B35,$B35:$M35)","v":10},7,8,9,11,6,12,4,1,{"$f":"RANK(K35,$B35:$M35)","v":2},5,3]
["R3",{"$f":"RANK(B36,$B36:$M36)","v":5},1,8,9,7,3,12,6,11,{"$f":"RANK(K36,$B36:$M36)","v":4},10,2]
["R4",{"$f":"RANK(B37,$B37:$M37)","v":10},6,8,4,9,3,5,12,1,{"$f":"RANK(K37,$B37:$M37)","v":11},7,2]
["R5",{"$f":"RANK(B38,$B38:$M38)","v":3},8,10,7,2,9,1,11,4,{"$f":"RANK(K38,$B38:$M38)","v":12},5,6]
[]
[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.88431065602528791},3.6984231610375229E-2,0.42112654605680278,0.56726302103787951,6.7854187803825128E-2,0.6551870151021697,0.16484854537595472,0.64564898858462805,0.40593244863616529,0.34568954102852778,0.89295431232587641,0.58569484844472097,8.0171751433565031E-2]
["R2",0.45293115705285825,0.22507553760479204,0.76794164730067682,0.9936654974200112,0.4271312276124386,0.65613145924053806,0.45011933247583591,0.52646371115469948,0.45411233146520236,0.70670059108792682,8.0059016894293955E-2,0.9347679880830092,0.72328532828491998]
["R3",0.47781500270873845,0.34907160497672318,0.85173333582382826,0.74105566678105472,0.64900459869267679,0.48684943396343761,0.5788559957301147,0.62760548827188434,0.12480951858518696,0.51870243829390117,0.82372156875147395,7.1528386341364492E-2,4.9480275487621128E-2]
["R4",0.26092036888135295,0.77691197846757953,0.7140820051641833,4.2989238638413418E-4,0.27904258638021517,0.47737788737295517,0.8344982302809214,0.70184118207369894,0.38104031633740454,0.1430093210412825,0.36821553019141828,5.5747700426937774E-2,0.54844398446970721]
["R5",0.39168976762755991,0.26896172716138378,2.9718924249513834E-2,0.55678225849483565,4.8063044080300266E-2,0.89741338875215926,0.3231764699191807,0.33316097718788773,0.74909533218421842,0.45912160249963152,0.74381264274876546,0.3796207648179345,0.74544228850869942]
["R1",{"$f":"RANK(B46,$B46:$N46)","v":2},13,7,6,12,3,10,4,8,{"$f":"RANK(K46,$B46:$N46)","v":9},1,5,11]
["R2",{"$f":"RANK(B47,$B47:$N47)","v":9},12,3,1,11,6,10,7,8,{"$f":"RANK(K47,$B47:$N47)","v":5},13,2,4]
["R3",{"$f":"RANK(B48,$B48:$N48)","v":9},10,1,3,4,8,6,5,11,{"$f":"RANK(K48,$B48:$N48)","v":7},2,12,13]
["R4",{"$f":"RANK(B49,$B49:$N49)","v":10},2,3,13,9,6,1,4,7,{"$f":"RANK(K49,$B49:$N49)","v":11},8,12,5]
["R5",{"$f":"RANK(B50,$B50:$N50)","v":7},11,13,5,12,1,10,9,2,{"$f":"RANK(K50,$B50:$N50)","v":6},4,8,3]
[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.71673792510245948,0.7089072993397213,0.93746474031340066,0.20646028436508135,0.31072457105723628,0.68205762284029359,3.7771220528568961E-2,5.6548364844559718E-2,0.28582034289184322,0.2334643744998155,0.85804650589564657,0.6388558600871973,0.43779944500594437,0.55239152552351622]
["R2",3.6346492430873845E-2,0.86697567775420847,0.11045167583860671,0.75843463396848354,0.57567083383093987,0.45101698934468426,0.46809675618221014,0.91482398676676402,0.47646654786447484,0.60674516672784551,0.84557567783604137,0.94028566569998706,9.2817595872653036E-2,0.66063337698947144]
["R3",0.81669511624561653,0.90124605633164623,0.51828814132165124,0.74105826692663412,0.52854034577404618,0.73337711858199361,0.31440339544325069,0.22564831236213811,4.7274813173047825E-2,0.15453457940829896,0.93501130982330372,0.86108841423430327,0.68197874656097746,0.81293157474622868]
["R4",0.84433001471960911,0.74035060221283433,0.9873298017701484,0.95746755945526973,0.19408993350313131,0.9830141760592086,0.48511805100256922,0.94713254989118512,0.11207594971709578,0.50122657641041679,0.10399262422037969,0.77596028256968785,0.87935325796689101,0.1994994606682402]
["R5",0.74629175004179071,0.58773646473467833,6.2744780927380339E-2,0.48074731573967044,0.29368613064716154,0.65966167208459825,0.58738317840841314,0.62787615339049463,0.3099795232349134,0.52880086619440403,0.93550773169783685,0.34976307543298024,0.23778384236294059,5.117659327905788E-2]
["R1",{"$f":"RANK(B57,$B57:$O57)","v":3},4,1,12,9,5,14,13,10,{"$f":"RANK(K57,$B57:$O57)","v":11},2,6,8,7]
["R2",{"$f":"RANK(B58,$B58:$O58)","v":14},3,12,5,8,11,10,2,9,{"$f":"RANK(K58,$B58:$O58)","v":7},4,1,13,6]
["R3",{"$f":"RANK(B59,$B59:$O59)","v":4},2,10,6,9,7,11,12,14,{"$f":"RANK(K59,$B59:$O59)","v":13},1,3,8,5]
["R4",{"$f":"RANK(B60,$B60:$O60)","v":6},8,1,3,12,2,10,4,13,{"$f":"RANK(K60,$B60:$O60)","v":9},14,7,5,11]
["R5",{"$f":"RANK(B61,$B61:$O61)","v":2},5,13,8,11,3,6,4,10,{"$f":"RANK(K61,$B61:$O61)","v":7},1,9,12,14]
[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.8477192223160237},0.88023781758802833,0.76450031610205049,0.86752421369224408,0.75232403865351372,0.71782126882039821,0.63755707292838371,0.53703253431783926,0.34596658155421456,0.20091255226906024,2.8424922853327761E-2,0.55947915876448162,1.2364452712916307E-3,0.74943044933215697,0.7986784626967337]
["R2",0.46331217839223593,0.862310384622063,4.2840791873504203E-2,0.1619444146911454,8.0369305013920034E-2,0.15059680005023002,0.49876472704755093,0.22947395106460833,3.6857150773293545E-2,0.40261542673130579,0.72601439634628151,0.27949619553197336,0.86789423017463119,0.91839865783898844,0.9942243045141802]
["R3",0.42489666623078626,0.46496769285160733,0.99051277915587166,0.55923459165042966,0.77440623412969611,2.9774879543339905E-2,0.47667670131767259,0.36931070091829588,0.98082681353359102,0.23390477187822079,0.96838460036173934,0.19195866162906194,8.5798541761447744E-2,0.41538349717149137,0.71274864266258098]
["R4",0.72998077206795686,0.96039793868537326,0.89958305937382477,0.92316169851561303,0.68381260119447163,0.99274324407676773,0.31579153269912219,0.93925154780430353,0.14301603909840921,0.35522765933526868,0.84730949645350739,0.69086485233770767,0.50998159632550299,0.15773584473177771,0.2669304477042036]
["R5",0.1274579869421264,0.81906626133401383,0.17074711597524128,0.7806283255186629,2.8579900469053565E-2,0.45734986774833553,0.637750039454412,0.17267533614772945,0.66977725242761688,0.4981193388949674,0.29879477324880432,0.13644488842406388,0.12971088194670055,0.84847974796776071,0.59412357733660914]
["R1",{"$f":"RANK(B68,$B68:$P68)","v":3},1,5,2,6,8,9,11,12,{"$f":"RANK(K68,$B68:$P68)","v":13},14,10,15,7,4]
["R2",{"$f":"RANK(B69,$B69:$P69)","v":7},4,14,11,13,12,6,10,15,{"$f":"RANK(K69,$B69:$P69)","v":8},5,9,3,2,1]
["R3",{"$f":"RANK(B70,$B70:$P70)","v":9},8,1,6,4,15,7,11,2,{"$f":"RANK(K70,$B70:$P70)","v":12},3,13,14,10,5]
["R4",{"$f":"RANK(B71,$B71:$P71)","v":7},2,5,4,9,1,12,3,15,{"$f":"RANK(K71,$B71:$P71)","v":11},6,8,10,14,13]
["R5",{"$f":"RANK(B72,$B72:$P72)","v":14},2,11,3,15,8,5,10,4,{"$f":"RANK(K72,$B72:$P72)","v":7},9,12,13,1,6]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0]
["R1",{"$f":"RAND()","v":1.519248953201835E-2},{"$f":"RAND()","v":0.27696587634294922},0.50627151472714127,3.1142014378007232E-2,0.32622365477633131,0.62635053228633231,0.61206163971442018,0.84258006032421773]
["R2",0.5667056868642304,0.25543846658955116,0.66709601532059748,0.64500239670677084,0.69504809507867826,0.18208411772668076,0.95770672598274387,5.6066995674855846E-2]
["R3",0.3053626984161274,0.4843105051198372,0.54231277374074616,0.43539703413747566,0.67173351195266828,0.94963220829655426,0.56494617263848257,0.70433901617633532]
["R4",0.63886241375806441,0.25670594356106846,5.9515541504803759E-2,0.75576520744081188,0.7150254888575075,0.43759755722072768,0.63109018335774036,0.41786292714038309]
["R5",0.93102308012879731,0.63073554599549364,0.86396003047477399,0.51439055117947119,0.60778528171223278,0.9850234970182169,0.61435009784173356,0.42409169685514569]
["R1",{"$f":"RANK(B79,$B79:$L79)","v":8},6,4,7,5,2,3,1]
["R2",5,6,3,4,2,7,1,8]
["R3",8,6,5,7,3,1,4,2]
["R4",3,7,8,1,2,5,4,6]
["R5",2,4,3,7,6,1,5,8]
[]
["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.9264101487138483},{"$f":"RAND()","v":0.37087867973135868},0.47117206126118505,0.83106781787528627,0.64790074603127146,0.66062397502039594,0.50696232056508983]
[null,0.82970347531964195,0.76994897693891295,0.24722262626813396,0.46022086290134945,0.14995114349962058,0.29508791535217882,0.22701369079741673]
[null,0.75868925990160474,5.3691945200537994E-2,0.13273351475090245,0.56411011506815856,0.66950431654068687,0.66965374243966957,0.59273966939724554]
[null,0.18849088401400371,0.45216418726788932,0.97105979345009963,0.355435853684823,0.90688699309785803,0.36841137634485022,0.36404877515264367]
[null,0.68253916669004566,0.93545568528114731,0.56404981730335757,0.45527397395075286,0.76526029586848476,0.3574130665895191,0.82806993183873878]
[null,{"$f":"RANK(B100,$B100:$L100)","v":1},7,6,2,4,3,5]
[null,{"$f":"RANK(B101,$B101:$L101)","v":1},2,5,3,7,4,6]
[null,{"$f":"RANK(B102,$B102:$L102)","v":1},7,6,5,3,2,4]
[null,{"$f":"RANK(B103,$B103:$L103)","v":7},3,1,6,2,4,5]
[null,{"$f":"RANK(B104,$B104:$L104)","v":4},1,5,6,3,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}]