{"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":-14},{"$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":-3},{"$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":-9},{"$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":-1},{"$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":-11},{"$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":-16},{"$f":"IF(ISERROR(C13-B7/100),\"\",C13-B7/100)","v":-16.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":5},{"$f":"VLOOKUP(G7,ranks!$C$4:$G$14,5,FALSE)","v":5},"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":-15},{"$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":-8},{"$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":-9},{"$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":-11},{"$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":-12},{"$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":3},{"$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":-10},{"$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":-2},{"$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":-11},{"$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":-28},{"$f":"IF(ISERROR(C22-B16/100),\"\",C22-B16/100)","v":-28.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":-33},{"$f":"IF(ISERROR(I22-H16/100),\"\",I22-H16/100)","v":-33.037999999999997},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":2},{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,5,FALSE)","v":2},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,4,FALSE)","v":1},{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,5,FALSE)","v":1},"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":-14},{"$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":-9},{"$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":-9},{"$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":-3},{"$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":-2},{"$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":5},{"$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":-25},{"$f":"IF(ISERROR(C31-B25/100),\"\",C31-B25/100)","v":-25.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":-7},{"$f":"IF(ISERROR(I31-H25/100),\"\",I31-H25/100)","v":-7.04},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(O26:O30,1)+SMALL(O26:O30,2)+SMALL(O26:O30,3)),\"\",SMALL(O26:O30,1)+SMALL(O26:O30,2)+SMALL(O26:O30,3))","v":""},{"$f":"IF(ISERROR(O31-N25/100),\"\",O31-N25/100)","v":""}]
["Running position",null,{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,4,FALSE)","v":4},{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,5,FALSE)","v":4},"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":-16},{"$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":3},{"$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":-11},{"$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":-27},{"$f":"IF(ISERROR(C40-B34/100),\"\",C40-B34/100)","v":-27.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":3},{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,5,FALSE)","v":3},"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,68,-3,"F",-16,268,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":-16},{"$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,"Phil Mickelson",69,67,67,66,-5,"F",-15,269,null,null,null,null,null,null,{"$f":"R7+1","v":8},{"$f":"SUBSTITUTE(INDEX($A:$J,R8,$S$2),\"*\",\"\")","v":"Phil Mickelson"},{"$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":-15},{"$f":"IF(ISERROR(INDEX($A:$J,R8,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R8,$U$2)+TIME(5,0,0))","v":67.208333333333329},{"$f":"INDEX($A:$N,R8,$V$2)","v":"F"}]
[null,"T3","Henrik Stenson",66,71,67,66,-5,"F",-14,270,null,null,null,null,null,null,{"$f":"R8+1","v":9},{"$f":"SUBSTITUTE(INDEX($A:$J,R9,$S$2),\"*\",\"\")","v":"Henrik Stenson"},{"$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":-14},{"$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,"T3","Rickie Fowler",69,66,67,68,-3,"F",-14,270,null,null,null,null,null,null,10,{"$f":"SUBSTITUTE(INDEX($A:$J,R10,$S$2),\"*\",\"\")","v":"Rickie Fowler"},-14,{"$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,"T5","Jim Furyk",66,68,72,66,-5,"F",-12,272,null,null,null,null,null,null,11,{"$f":"SUBSTITUTE(INDEX($A:$J,R11,$S$2),\"*\",\"\")","v":"Jim Furyk"},-12,{"$f":"IF(ISERROR(INDEX($A:$J,R11,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R11,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T5","Ryan Palmer",65,70,69,68,-3,"F",-12,272,null,null,null,null,null,null,12,{"$f":"SUBSTITUTE(INDEX($A:$J,R12,$S$2),\"*\",\"\")","v":"Ryan Palmer"},-12,{"$f":"IF(ISERROR(INDEX($A:$J,R12,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R12,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T7","Ernie Els",70,70,68,65,-6,"F",-11,273,null,null,null,null,null,null,13,{"$f":"SUBSTITUTE(INDEX($A:$J,R13,$S$2),\"*\",\"\")","v":"Ernie Els"},-11,{"$f":"IF(ISERROR(INDEX($A:$J,R13,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R13,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T7","Jimmy Walker",69,71,68,65,-6,"F",-11,273,null,null,null,null,null,null,14,{"$f":"SUBSTITUTE(INDEX($A:$J,R14,$S$2),\"*\",\"\")","v":"Jimmy Walker"},-11,{"$f":"IF(ISERROR(INDEX($A:$J,R14,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R14,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T7","Victor Dubuisson",69,68,70,66,-5,"F",-11,273,null,null,null,null,null,null,15,{"$f":"SUBSTITUTE(INDEX($A:$J,R15,$S$2),\"*\",\"\")","v":"Victor Dubuisson"},-11,{"$f":"IF(ISERROR(INDEX($A:$J,R15,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R15,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T7","Hunter Mahan",70,71,65,67,-4,"F",-11,273,null,null,null,null,null,null,16,{"$f":"SUBSTITUTE(INDEX($A:$J,R16,$S$2),\"*\",\"\")","v":"Hunter Mahan"},-11,{"$f":"IF(ISERROR(INDEX($A:$J,R16,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R16,$U$2)+TIME(5,0,0))","v":65.208333333333329},"F"]
[null,"T7","Steve Stricker",69,68,68,68,-3,"F",-11,273,null,null,null,null,null,null,17,{"$f":"SUBSTITUTE(INDEX($A:$J,R17,$S$2),\"*\",\"\")","v":"Steve Stricker"},-11,{"$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,"T7","Mikko Ilonen",67,68,69,69,-2,"F",-11,273,null,null,null,null,null,null,18,{"$f":"SUBSTITUTE(INDEX($A:$J,R18,$S$2),\"*\",\"\")","v":"Mikko Ilonen"},-11,{"$f":"IF(ISERROR(INDEX($A:$J,R18,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R18,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T13","Brandt Snedeker",73,68,66,67,-4,"F",-10,274,null,null,null,null,null,null,19,{"$f":"SUBSTITUTE(INDEX($A:$J,R19,$S$2),\"*\",\"\")","v":"Brandt Snedeker"},-10,{"$f":"IF(ISERROR(INDEX($A:$J,R19,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R19,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T13","Kevin Chappell",65,74,67,68,-3,"F",-10,274,null,null,null,null,null,null,20,{"$f":"SUBSTITUTE(INDEX($A:$J,R20,$S$2),\"*\",\"\")","v":"Kevin Chappell"},-10,{"$f":"IF(ISERROR(INDEX($A:$J,R20,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R20,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T15","Charl Schwartzel",72,68,69,66,-5,"F",-9,275,null,null,null,null,null,null,21,{"$f":"SUBSTITUTE(INDEX($A:$J,R21,$S$2),\"*\",\"\")","v":"Charl Schwartzel"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R21,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R21,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T15","Brooks Koepka",71,71,66,67,-4,"F",-9,275,null,null,null,null,null,null,22,{"$f":"SUBSTITUTE(INDEX($A:$J,R22,$S$2),\"*\",\"\")","v":"Brooks Koepka"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R22,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R22,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T15","Marc Warren",71,71,66,67,-4,"F",-9,275,null,null,null,null,null,null,23,{"$f":"SUBSTITUTE(INDEX($A:$J,R23,$S$2),\"*\",\"\")","v":"Marc Warren"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R23,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R23,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T15","Lee Westwood",65,72,69,69,-2,"F",-9,275,null,null,null,null,null,null,24,{"$f":"SUBSTITUTE(INDEX($A:$J,R24,$S$2),\"*\",\"\")","v":"Lee Westwood"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R24,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R24,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T15","Adam Scott",71,69,66,69,-2,"F",-9,275,null,null,null,null,null,null,25,{"$f":"SUBSTITUTE(INDEX($A:$J,R25,$S$2),\"*\",\"\")","v":"Adam Scott"},-9,{"$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,"T15","Graham DeLaet",69,68,68,70,-1,"F",-9,275,null,null,null,null,null,null,26,{"$f":"SUBSTITUTE(INDEX($A:$J,R26,$S$2),\"*\",\"\")","v":"Graham DeLaet"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R26,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R26,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T15","Jason Day",69,65,69,72,1,"F",-9,275,null,null,null,null,null,null,27,{"$f":"SUBSTITUTE(INDEX($A:$J,R27,$S$2),\"*\",\"\")","v":"Jason Day"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R27,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R27,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T15","Louis Oosthuizen",70,67,67,71,"E","F",-9,275,null,null,null,null,null,null,28,{"$f":"SUBSTITUTE(INDEX($A:$J,R28,$S$2),\"*\",\"\")","v":"Louis Oosthuizen"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R28,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R28,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T15","Bernd Wiesberger",68,68,65,74,3,"F",-9,275,null,null,null,null,null,null,29,{"$f":"SUBSTITUTE(INDEX($A:$J,R29,$S$2),\"*\",\"\")","v":"Bernd Wiesberger"},-9,{"$f":"IF(ISERROR(INDEX($A:$J,R29,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R29,$U$2)+TIME(5,0,0))","v":65.208333333333329},"F"]
[null,"T24","Justin Rose",70,72,67,67,-4,"F",-8,276,null,null,null,null,null,null,30,{"$f":"SUBSTITUTE(INDEX($A:$J,R30,$S$2),\"*\",\"\")","v":"Justin Rose"},-8,{"$f":"IF(ISERROR(INDEX($A:$J,R30,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R30,$U$2)+TIME(5,0,0))","v":67.208333333333329},"F"]
[null,"T24","Jamie Donaldson",69,70,66,71,"E","F",-8,276,null,null,null,null,null,null,31,{"$f":"SUBSTITUTE(INDEX($A:$J,R31,$S$2),\"*\",\"\")","v":"Jamie Donaldson"},-8,{"$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,26,"Joost Luiten",68,69,69,71,"E","F",-7,277,null,null,null,null,null,null,32,{"$f":"SUBSTITUTE(INDEX($A:$J,R32,$S$2),\"*\",\"\")","v":"Joost Luiten"},-7,{"$f":"IF(ISERROR(INDEX($A:$J,R32,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R32,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T27","Jerry Kelly",67,74,70,67,-4,"F",-6,278,null,null,null,null,null,null,33,{"$f":"SUBSTITUTE(INDEX($A:$J,R33,$S$2),\"*\",\"\")","v":"Jerry Kelly"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R33,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R33,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T27","Kenny Perry",72,69,69,68,-3,"F",-6,278,null,null,null,null,null,null,34,{"$f":"SUBSTITUTE(INDEX($A:$J,R34,$S$2),\"*\",\"\")","v":"Kenny Perry"},-6,{"$f":"IF(ISERROR(INDEX($A:$J,R34,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R34,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T27","Bill Haas",71,68,68,71,"E","F",-6,278,null,null,null,null,null,null,35,{"$f":"SUBSTITUTE(INDEX($A:$J,R35,$S$2),\"*\",\"\")","v":"Bill Haas"},-6,{"$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,"T30","Thorbjorn Olesen",71,71,70,67,-4,"F",-5,279,null,null,null,null,null,null,36,{"$f":"SUBSTITUTE(INDEX($A:$J,R36,$S$2),\"*\",\"\")","v":"Thorbjorn Olesen"},-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":70.208333333333329},"F"]
[null,"T30","Alexander Levy",69,71,68,71,"E","F",-5,279,null,null,null,null,null,null,37,{"$f":"SUBSTITUTE(INDEX($A:$J,R37,$S$2),\"*\",\"\")","v":"Alexander Levy"},-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":68.208333333333329},"F"]
[null,"T30","Danny Willett",68,73,66,72,1,"F",-5,279,null,null,null,null,null,null,38,{"$f":"SUBSTITUTE(INDEX($A:$J,R38,$S$2),\"*\",\"\")","v":"Danny Willett"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R38,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R38,$U$2)+TIME(5,0,0))","v":66.208333333333329},"F"]
[null,"T33","Cameron Tringale",69,71,71,69,-2,"F",-4,280,null,null,null,null,null,null,39,{"$f":"SUBSTITUTE(INDEX($A:$J,R39,$S$2),\"*\",\"\")","v":"Cameron Tringale"},-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":71.208333333333329},"F"]
[null,"T33","Daniel Summerhays",70,72,68,70,-1,"F",-4,280,null,null,null,null,null,null,40,{"$f":"SUBSTITUTE(INDEX($A:$J,R40,$S$2),\"*\",\"\")","v":"Daniel Summerhays"},-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":68.208333333333329},"F"]
[null,"T33","Nick Watney",69,69,70,72,1,"F",-4,280,null,null,null,null,null,null,41,{"$f":"SUBSTITUTE(INDEX($A:$J,R41,$S$2),\"*\",\"\")","v":"Nick Watney"},-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":70.208333333333329},"F"]
[null,"T36","Hideki Matsuyama",71,72,70,68,-3,"F",-3,281,null,null,null,null,null,null,42,{"$f":"SUBSTITUTE(INDEX($A:$J,R42,$S$2),\"*\",\"\")","v":"Hideki Matsuyama"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R42,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R42,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T36","Vijay Singh",71,68,73,69,-2,"F",-3,281,null,null,null,null,null,null,43,{"$f":"SUBSTITUTE(INDEX($A:$J,R43,$S$2),\"*\",\"\")","v":"Vijay Singh"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R43,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R43,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T36","Richard Sterne",70,69,72,70,-1,"F",-3,281,null,null,null,null,null,null,44,{"$f":"SUBSTITUTE(INDEX($A:$J,R44,$S$2),\"*\",\"\")","v":"Richard Sterne"},-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":72.208333333333329},"F"]
[null,"T36","Jonas Blixt",71,70,68,72,1,"F",-3,281,null,null,null,null,null,null,45,{"$f":"SUBSTITUTE(INDEX($A:$J,R45,$S$2),\"*\",\"\")","v":"Jonas Blixt"},-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,"T36","Sergio Garcia",70,72,66,73,2,"F",-3,281,null,null,null,null,null,null,46,{"$f":"SUBSTITUTE(INDEX($A:$J,R46,$S$2),\"*\",\"\")","v":"Sergio Garcia"},-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":66.208333333333329},"F"]
[null,"T41","Koumei Oda",74,68,71,69,-2,"F",-2,282,null,null,null,null,null,null,47,{"$f":"SUBSTITUTE(INDEX($A:$J,R47,$S$2),\"*\",\"\")","v":"Koumei Oda"},-2,{"$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,"T41","Jason Bohn",71,71,71,69,-2,"F",-2,282,null,null,null,null,null,null,48,{"$f":"SUBSTITUTE(INDEX($A:$J,R48,$S$2),\"*\",\"\")","v":"Jason Bohn"},-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":71.208333333333329},"F"]
[null,"T41","Brendon de Jonge",70,70,72,70,-1,"F",-2,282,null,null,null,null,null,null,49,{"$f":"SUBSTITUTE(INDEX($A:$J,R49,$S$2),\"*\",\"\")","v":"Brendon de Jonge"},-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":72.208333333333329},"F"]
[null,"T41","Luke Donald",70,72,68,72,1,"F",-2,282,null,null,null,null,null,null,50,{"$f":"SUBSTITUTE(INDEX($A:$J,R50,$S$2),\"*\",\"\")","v":"Luke Donald"},-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":68.208333333333329},"F"]
[null,"T41","Brian Harman",71,69,69,73,2,"F",-2,282,null,null,null,null,null,null,51,{"$f":"SUBSTITUTE(INDEX($A:$J,R51,$S$2),\"*\",\"\")","v":"Brian Harman"},-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":69.208333333333329},"F"]
[null,"T41","Ryan Moore",73,68,67,74,3,"F",-2,282,null,null,null,null,null,null,52,{"$f":"SUBSTITUTE(INDEX($A:$J,R52,$S$2),\"*\",\"\")","v":"Ryan Moore"},-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":67.208333333333329},"F"]
[null,"T47","Shane Lowry",68,74,74,67,-4,"F",-1,283,null,null,null,null,null,null,53,{"$f":"SUBSTITUTE(INDEX($A:$J,R53,$S$2),\"*\",\"\")","v":"Shane Lowry"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R53,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R53,$U$2)+TIME(5,0,0))","v":74.208333333333329},"F"]
[null,"T47","Robert Karlsson",71,69,74,69,-2,"F",-1,283,null,null,null,null,null,null,54,{"$f":"SUBSTITUTE(INDEX($A:$J,R54,$S$2),\"*\",\"\")","v":"Robert Karlsson"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R54,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R54,$U$2)+TIME(5,0,0))","v":74.208333333333329},"F"]
[null,"T47","Marc Leishman",71,71,72,69,-2,"F",-1,283,null,null,null,null,null,null,55,{"$f":"SUBSTITUTE(INDEX($A:$J,R55,$S$2),\"*\",\"\")","v":"Marc Leishman"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R55,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R55,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T47","Graeme McDowell",73,70,71,69,-2,"F",-1,283,null,null,null,null,null,null,56,{"$f":"SUBSTITUTE(INDEX($A:$J,R56,$S$2),\"*\",\"\")","v":"Graeme McDowell"},-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":71.208333333333329},"F"]
[null,"T47","Pat Perez",71,71,71,70,-1,"F",-1,283,null,null,null,null,null,null,57,{"$f":"SUBSTITUTE(INDEX($A:$J,R57,$S$2),\"*\",\"\")","v":"Pat Perez"},-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":71.208333333333329},"F"]
[null,"T47","Fabrizio Zanotti",71,70,71,71,"E","F",-1,283,null,null,null,null,null,null,58,{"$f":"SUBSTITUTE(INDEX($A:$J,R58,$S$2),\"*\",\"\")","v":"Fabrizio Zanotti"},-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,"T47","Matt Jones",68,71,72,72,1,"F",-1,283,null,null,null,null,null,null,59,{"$f":"SUBSTITUTE(INDEX($A:$J,R59,$S$2),\"*\",\"\")","v":"Matt Jones"},-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":72.208333333333329},"F"]
[null,"T47","Scott Brown",71,70,70,72,1,"F",-1,283,null,null,null,null,null,null,60,{"$f":"SUBSTITUTE(INDEX($A:$J,R60,$S$2),\"*\",\"\")","v":"Scott Brown"},-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":70.208333333333329},"F"]
[null,"T47","Geoff Ogilvy",69,71,71,72,1,"F",-1,283,null,null,null,null,null,null,61,{"$f":"SUBSTITUTE(INDEX($A:$J,R61,$S$2),\"*\",\"\")","v":"Geoff Ogilvy"},-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":71.208333333333329},"F"]
[null,"T47","Branden Grace",73,70,68,72,1,"F",-1,283,null,null,null,null,null,null,62,{"$f":"SUBSTITUTE(INDEX($A:$J,R62,$S$2),\"*\",\"\")","v":"Branden Grace"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R62,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R62,$U$2)+TIME(5,0,0))","v":68.208333333333329},"F"]
[null,"T47","Edoardo Molinari",66,73,71,73,2,"F",-1,283,null,null,null,null,null,null,63,{"$f":"SUBSTITUTE(INDEX($A:$J,R63,$S$2),\"*\",\"\")","v":"Edoardo Molinari"},-1,{"$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,"T47","Chris Wood",66,73,70,74,3,"F",-1,283,null,null,null,null,null,null,64,{"$f":"SUBSTITUTE(INDEX($A:$J,R64,$S$2),\"*\",\"\")","v":"Chris Wood"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R64,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R64,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T59","Brendan Steele",71,70,73,70,-1,"F","E",284,null,null,null,null,null,null,65,{"$f":"SUBSTITUTE(INDEX($A:$J,R65,$S$2),\"*\",\"\")","v":"Brendan Steele"},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":73.208333333333329},"F"]
[null,"T59","Gonzalo Fernandez-Casta",71,70,72,71,"E","F","E",284,null,null,null,null,null,null,66,{"$f":"SUBSTITUTE(INDEX($A:$J,R66,$S$2),\"*\",\"\")","v":"Gonzalo Fernandez-Casta"},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":72.208333333333329},"F"]
[null,"T59","Francesco Molinari",71,71,71,71,"E","F","E",284,null,null,null,null,null,null,67,{"$f":"SUBSTITUTE(INDEX($A:$J,R67,$S$2),\"*\",\"\")","v":"Francesco Molinari"},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":71.208333333333329},"F"]
[null,"T59","Ian Poulter",68,73,71,72,1,"F","E",284,null,null,null,null,null,null,68,{"$f":"SUBSTITUTE(INDEX($A:$J,R68,$S$2),\"*\",\"\")","v":"Ian Poulter"},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":71.208333333333329},"F"]
[null,"T59","Patrick Reed",70,71,70,73,2,"F","E",284,null,null,null,null,null,null,69,{"$f":"SUBSTITUTE(INDEX($A:$J,R69,$S$2),\"*\",\"\")","v":"Patrick Reed"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R69,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R69,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,"T59","Billy Horschel",71,68,69,76,5,"F","E",284,null,null,null,null,null,null,70,{"$f":"SUBSTITUTE(INDEX($A:$J,R70,$S$2),\"*\",\"\")","v":"Billy Horschel"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R70,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R70,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,"T65","Chris Stroud",70,73,73,71,"E","F",3,287,null,null,null,null,null,null,71,{"$f":"SUBSTITUTE(INDEX($A:$J,R71,$S$2),\"*\",\"\")","v":"Chris Stroud"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R71,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R71,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T65","Bubba Watson",70,72,73,72,1,"F",3,287,null,null,null,null,null,null,72,{"$f":"SUBSTITUTE(INDEX($A:$J,R72,$S$2),\"*\",\"\")","v":"Bubba Watson"},3,{"$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,"T65","Kevin Stadler",71,70,72,74,3,"F",3,287,null,null,null,null,null,null,{"$f":"R72+1","v":73},{"$f":"SUBSTITUTE(INDEX($A:$J,R73,$S$2),\"*\",\"\")","v":"Kevin Stadler"},{"$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":3},{"$f":"IF(ISERROR(INDEX($A:$J,R73,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R73,$U$2)+TIME(5,0,0))","v":72.208333333333329},{"$f":"INDEX($A:$N,R73,$V$2)","v":"F"}]
[null,"T65","J.B. Holmes",68,72,69,78,7,"F",3,287,null,null,null,null,null,null,74,{"$f":"SUBSTITUTE(INDEX($A:$J,R74,$S$2),\"*\",\"\")","v":"J.B. Holmes"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R74,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R74,$U$2)+TIME(5,0,0))","v":69.208333333333329},"F"]
[null,69,"Shawn Stefani",68,75,72,73,2,"F",4,288,null,null,null,null,null,null,75,{"$f":"SUBSTITUTE(INDEX($A:$J,R75,$S$2),\"*\",\"\")","v":"Shawn Stefani"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R75,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R75,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T70","Fredrik Jacobson",72,69,73,75,4,"F",5,289,null,null,null,null,null,null,76,{"$f":"SUBSTITUTE(INDEX($A:$J,R76,$S$2),\"*\",\"\")","v":"Fredrik Jacobson"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R76,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R76,$U$2)+TIME(5,0,0))","v":73.208333333333329},"F"]
[null,"T70","Colin Montgomerie",70,72,72,75,4,"F",5,289,null,null,null,null,null,null,77,{"$f":"SUBSTITUTE(INDEX($A:$J,R77,$S$2),\"*\",\"\")","v":"Colin Montgomerie"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R77,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R77,$U$2)+TIME(5,0,0))","v":72.208333333333329},"F"]
[null,"T70","Zach Johnson",70,72,70,77,6,"F",5,289,null,null,null,null,null,null,78,{"$f":"SUBSTITUTE(INDEX($A:$J,R78,$S$2),\"*\",\"\")","v":"Zach Johnson"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R78,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R78,$U$2)+TIME(5,0,0))","v":70.208333333333329},"F"]
[null,73,"Brendon Todd",70,73,75,75,4,"F",9,293,null,null,null,null,null,null,79,{"$f":"SUBSTITUTE(INDEX($A:$J,R79,$S$2),\"*\",\"\")","v":"Brendon Todd"},9,{"$f":"IF(ISERROR(INDEX($A:$J,R79,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R79,$U$2)+TIME(5,0,0))","v":75.208333333333329},"F"]
[null,74,"Rafael Cabrera-Bello",69,71,74,80,9,"F",10,294,null,null,null,null,null,null,80,{"$f":"SUBSTITUTE(INDEX($A:$J,R80,$S$2),\"*\",\"\")","v":"Rafael Cabrera-Bello"},10,{"$f":"IF(ISERROR(INDEX($A:$J,R80,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R80,$U$2)+TIME(5,0,0))","v":74.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":-16},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+3)","v":-16.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":-28},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+3)","v":-28.033999999999999},2,{"$f":"IF(ISERROR(RANK(E5,$E$4:$E$14,1)),\"\",RANK(E5,$E$4:$E$14,1))","v":2},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":-25},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+3)","v":-25.047999999999998},4,4,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":-27},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+3)","v":-27.045999999999999},3,3,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},5,5,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":-33},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+3)","v":-33.037999999999997},1,1,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":-7},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+3)","v":-7.04},7,7,null,null,"DEANO",-4,-4.0439999999999996,6,6]
[{"$f":"A10+9","v":28},7,{"$f":"INDEX(results!$A$7:$Q$42,$A11,$B11)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+3)","v":""},"","",null,null,"STUART D",-1,-1.04,7,7]
[1,13,{"$f":"INDEX(results!$A$7:$Q$42,$A12,$B12)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A12+6,$B12+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A12+6,$B12+3)","v":""},"",""]
[10,13,{"$f":"INDEX(results!$A$7:$Q$42,$A13,$B13)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A13+6,$B13+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A13+6,$B13+3)","v":""},"",""]
[19,{"$f":"B9+6","v":13},{"$f":"INDEX(results!$A$7:$Q$42,$A14,$B14)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A14+6,$B14+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A14+6,$B14+3)","v":""},"","",null,"round 2","Player","Score","Score adj","Rank","Rank adj"]
[null,null,null,null,null,null,null,null,null,"STEVER",-14,-14.045999999999999,1,1]
[null,null,null,null,null,null,null,null,null,"JOHN C",-13,-13.03,2,2]
[null,null,null,null,null,null,null,null,null,"BYRON",-11,-11.048,3,3]
[null,null,"Put sorted scores here for posting to website",null,null,null,null,null,null,"CRAIG T",-11,-11.038,3,4]
[null,null,null,null,null,null,null,null,null,"TEZ",-10,-10.034000000000001,5,5]
[null,7,"Player","Score","Score adj","Rank","Rank adj",null,null,"DEANO",-9,-9.0440000000000005,6,6]
[null,13,"CRAIG T",-33,-33.037999999999997,1,1,null,null,"STUART D",-1,-1.04,7,7]
[null,1,"TEZ",-28,-28.033999999999999,2,2]
[null,1,"STEVER",-27,-27.045999999999999,3,3,null,"round 3","Player","Score","Score adj","Rank","Rank adj"]
[null,1,"BYRON",-25,-25.047999999999998,4,4,null,null,"JOHN C",-23,-23.03,1,1]
[null,13,"JOHN C",-23,-23.03,5,5,null,null,"BYRON",-21,-21.047999999999998,2,2]
[null,7,"DEANO",-16,-16.044,6,6,null,null,"CRAIG T",-20,-20.038,3,3]
[null,1,"STUART D",-7,-7.04,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,null,null,null,null,null,null,"round 4","Player","Score","Score adj","Rank","Rank adj"]
[null,null,null,null,null,null,null,null,null,"CRAIG T",-33,-33.037999999999997,1,1]
[null,null,null,null,null,null,null,null,null,"TEZ",-28,-28.033999999999999,2,2]
[null,null,null,null,null,null,null,null,null,"STEVER",-27,-27.045999999999999,3,3]
[null,null,null,null,null,null,null,null,null,"BYRON",-25,-25.047999999999998,4,4]
[null,null,null,null,null,null,null,null,null,"JOHN C",-23,-23.03,5,5]
[null,null,"Average scores of picks","Avg","Rank",null,null,null,null,"DEANO",-16,-16.044,6,6]
[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,null,null,"STUART D",-7,-7.04,7,7]
[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.90817429868019905},0.69129119976177289,0.36919692941289539,0.48122586786320409,0.23770647403107981,0.48373634770658158,0.96344824082169311,0.23382557793383729,0.407716008739617,0.56550461155042531]
["R2",0.11004551358977122,0.13588313936370044,0.86514495787712475,0.15849199911691414,0.29271430383232555,0.25376508595439429,0.22297278336614657,0.81404186130201617,0.94521992480902717,0.5720951599032944]
["R3",0.52416156327613561,0.96615262495615062,0.80111085380687264,0.36791795004210071,0.67159076660015571,8.0819725550649757E-2,0.28414568533932882,0.79492694294286603,0.59088404150510199,8.6829363334091081E-3]
["R4",0.29755108651441475,0.98929299576374385,0.4475611803906332,0.50493454485617695,0.40246406365513876,0.87673980278721331,0.49617897065001881,0.45079876566931776,0.97728395368257115,0.16740079890557491]
["R5",0.11884330001273502,0.13966120843484453,7.7579014080243369E-2,0.61364274851779566,0.1937967846027584,0.6668116568791318,0.71186467428734557,9.7658378967222514E-3,0.75578689535111565,0.8529011812174494]
["R1",{"$f":"RANK(B4,$B4:$L4)","v":2},3,8,6,9,5,1,10,7,4]
["R2",{"$f":"RANK(B5,$B5:$L5)","v":10},9,2,8,5,6,7,3,1,4]
["R3",{"$f":"RANK(B6,$B6:$L6)","v":6},1,2,7,4,9,8,3,5,10]
["R4",{"$f":"RANK(B7,$B7:$L7)","v":9},1,7,4,8,3,5,6,2,10]
["R5",{"$f":"RANK(B8,$B8:$L8)","v":8},7,9,5,6,4,3,10,2,1]
[]
["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.64125206570123727},0.49345944815004794,0.60817679608934261,0.83611812406616959,0.4116440719782436,0.71639728207691888,0.82941447231815446,0.5116396858412201,0.94229139698520115,0.10666170251166263,0.93261547501977071]
["R2",0.66533095157643218,0.5657303945161295,0.708941722498865,0.71016791321491368,4.8893989359113266E-2,3.4666738255341167E-3,8.0611115905190878E-2,0.88788047821377802,0.25672414061704063,0.9792482130139728,0.27868009361025703]
["R3",0.25393029354654828,0.53570935071627135,0.4765224450419191,0.90468556494074648,3.5723193476267845E-2,0.25956505524610562,0.75100860009546566,0.508918027250994,0.14737164440963679,7.1615003530805854E-2,0.39398690151172977]
["R4",0.19526385649728484,0.69237897895732281,0.17587411727428226,0.50797496690453492,0.67420132445279768,0.10712319696599426,0.2383652494719336,0.233473610281274,9.587601733363682E-2,0.3329666530046349,7.2735363415953325E-3]
["R5",0.74168526001499668,0.26958674164406049,0.99906500276554089,0.51118429033847479,0.35732920487501352,0.1709095979739641,0.45974458495259185,0.17339700543927306,0.85625170049292165,0.40598199983980843,0.13298089284023873]
["R1",{"$f":"RANK(B23,$B23:$L23)","v":6},9,7,3,10,5,4,8,1,{"$f":"RANK(K23,$B23:$L23)","v":11},2]
["R2",{"$f":"RANK(B24,$B24:$L24)","v":5},6,4,3,10,11,9,2,8,{"$f":"RANK(K24,$B24:$L24)","v":1},7]
["R3",{"$f":"RANK(B25,$B25:$L25)","v":8},3,5,1,11,7,2,4,9,{"$f":"RANK(K25,$B25:$L25)","v":10},6]
["R4",{"$f":"RANK(B26,$B26:$L26)","v":7},1,8,3,2,9,5,6,10,{"$f":"RANK(K26,$B26:$L26)","v":4},11]
["R5",{"$f":"RANK(B27,$B27:$L27)","v":3},8,1,4,7,10,5,9,2,{"$f":"RANK(K27,$B27:$L27)","v":6},11]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0]
["R1",0.93658856524832834,0.10905819622410751,0.15720541815766587,0.189516198294712,9.9838174035301264E-2,0.89063452642856644,0.73729747155518244,7.4207145599913815E-2,0.41164398652623202,0.56799685021858137,0.59960530360029285,0.21964739002746225]
["R2",0.85930191975012349,0.53054448118169539,0.73940639940071229,0.39210626194921994,0.27164027192092566,0.2631207830077178,0.41292676966466002,0.11961685806849698,0.72834248764620524,0.64410762239650088,0.78509173804672361,0.35523961358023926]
["R3",7.8262999890993834E-2,0.99530108899125735,0.11801134068508534,8.8688265862203464E-2,0.51618681665899468,0.397965595560554,1.9321946617468555E-2,0.90364922454661956,0.86760315209808725,0.83981621389608474,0.92240833985732751,0.763318269092366]
["R4",0.78409719036002046,0.53433755704559904,0.56456558638293186,0.90558388339298246,0.61345634345298128,0.91832853519883628,0.15676172402118338,0.70519421043670882,0.67509880627204721,0.91765748760232912,0.9684822867864209,0.94356171831703806]
["R5",0.64301885168094852,0.95529249170422859,0.64211168974798194,0.89083126968887305,0.611177550710438,0.48332241237372775,1.4807924723928334E-2,0.67855861390718208,0.75227396757325171,0.36090774777639978,0.1703079852696513,0.67834633811447353]
["R1",{"$f":"RANK(B34,$B34:$M34)","v":1},10,9,8,11,2,3,12,6,{"$f":"RANK(K34,$B34:$M34)","v":5},4,7]
["R2",{"$f":"RANK(B35,$B35:$M35)","v":1},6,3,8,10,11,7,12,4,{"$f":"RANK(K35,$B35:$M35)","v":5},2,9]
["R3",{"$f":"RANK(B36,$B36:$M36)","v":11},1,9,10,7,8,12,3,4,{"$f":"RANK(K36,$B36:$M36)","v":5},2,6]
["R4",{"$f":"RANK(B37,$B37:$M37)","v":6},11,10,5,9,3,12,7,8,{"$f":"RANK(K37,$B37:$M37)","v":4},1,2]
["R5",{"$f":"RANK(B38,$B38:$M38)","v":6},1,7,2,8,9,12,4,3,{"$f":"RANK(K38,$B38:$M38)","v":10},11,5]
[]
[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.69417014544835276},0.11922866751800887,0.34376464327063228,8.5976567585078767E-3,0.23967519417294236,0.87254167251648995,0.33684150726224227,0.25865070065685236,0.17692374948133194,0.93448645441101275,0.69856151823037316,0.22604811994292762,0.41234930655632651]
["R2",0.87881223099037542,0.6862349917420183,0.16399493901668982,0.5732649013839054,0.40538453517472994,6.5104377018315285E-2,0.56048323964944646,0.87071811460369464,0.13710690409100701,7.166168444993104E-2,0.7242848224772539,0.48913591227407804,0.99958311172131054]
["R3",0.47044689630272396,0.75275219306869556,0.14858066081756904,0.1929296564171854,0.58937707826738639,0.5620953347632589,0.63264771050771607,0.43242927300029865,0.41121604862056782,0.33870689744923144,0.18919331991487298,0.92575799198567843,0.55922611188490579]
["R4",0.39892859422115678,0.79898911727069166,0.34238371061080008,0.9981711222970393,0.5814718587986033,0.95397936630596125,0.84781968938282048,4.0996390733248456E-2,0.55930163594899063,0.98962033740057975,0.88260827118707719,1.3959848016109944E-2,0.33708341586520285]
["R5",0.88685775783400911,0.71452075382779323,0.69604040385157595,0.38074871490112305,0.14168151668375839,0.32155407374792666,0.84089039182208813,9.7549054646100863E-2,0.75926797669817148,0.60212465606539101,0.54723363232958522,7.7488068182804626E-2,5.3165856912353981E-2]
["R1",{"$f":"RANK(B46,$B46:$N46)","v":4},12,6,13,9,2,7,8,11,{"$f":"RANK(K46,$B46:$N46)","v":1},3,10,5]
["R2",{"$f":"RANK(B47,$B47:$N47)","v":2},5,10,6,9,13,7,3,11,{"$f":"RANK(K47,$B47:$N47)","v":12},4,8,1]
["R3",{"$f":"RANK(B48,$B48:$N48)","v":7},2,13,11,4,5,3,8,9,{"$f":"RANK(K48,$B48:$N48)","v":10},12,1,6]
["R4",{"$f":"RANK(B49,$B49:$N49)","v":9},6,10,1,7,3,5,12,8,{"$f":"RANK(K49,$B49:$N49)","v":2},4,13,11]
["R5",{"$f":"RANK(B50,$B50:$N50)","v":1},4,5,8,10,9,2,11,3,{"$f":"RANK(K50,$B50:$N50)","v":6},7,12,13]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0,0,0]
["R1",0.60672308342259051,5.8161196766998158E-2,0.85992470682800082,0.10887700672363898,0.12999579891549995,0.62342218794734106,0.42538657106446209,0.57101920814422991,0.81055420575119719,6.4889491568093649E-2,0.35821556530793786,0.61172434857548907,7.1032223961466578E-2,0.45809090357618332]
["R2",0.41668114649521271,0.13852261353981132,0.48329231429488129,0.14386587832154174,0.4935461870618415,0.65694748203755482,0.17107891810071096,0.62790774589933507,0.79718214148006661,0.91492961641797732,0.81621333600680313,0.81702416032757252,0.90672892884294343,0.41597507087778574]
["R3",0.11721004045841843,0.62448970260897918,0.18303652165420714,0.14676651197153512,5.0553086519939283E-2,1.1862991878723528E-2,0.83233970741536145,0.96378382085429659,0.56294126147714141,0.40153546423423492,0.70634230385073049,0.76647040861743299,0.68879157802545343,0.4032801180073653]
["R4",8.5207108236100226E-2,0.64940973189412432,0.27447430372137038,0.980915725548552,0.51697198315319703,0.28913900752557697,9.6644872078649802E-2,0.51631351037963424,0.77878104300334383,1.7846871500834305E-2,0.47532125273126347,0.62346068229730689,0.79196777138396213,0.74915574370972449]
["R5",2.5665084016686435E-2,0.22672577336727229,0.60609501638879615,0.70016351696136514,0.85836683551324489,0.3131899154146387,0.58876268882745286,0.46511405292215113,0.76067727027455634,0.55721335394824978,9.7563797875847902E-2,0.35171239949632771,0.11082791523729052,0.96286741949828714]
["R1",{"$f":"RANK(B57,$B57:$O57)","v":5},14,1,11,10,3,8,6,2,{"$f":"RANK(K57,$B57:$O57)","v":13},9,4,12,7]
["R2",{"$f":"RANK(B58,$B58:$O58)","v":10},14,9,13,8,6,12,7,5,{"$f":"RANK(K58,$B58:$O58)","v":1},4,3,2,11]
["R3",{"$f":"RANK(B59,$B59:$O59)","v":12},6,10,11,13,14,2,1,7,{"$f":"RANK(K59,$B59:$O59)","v":9},4,3,5,8]
["R4",{"$f":"RANK(B60,$B60:$O60)","v":13},5,11,1,7,10,12,8,3,{"$f":"RANK(K60,$B60:$O60)","v":14},9,6,2,4]
["R5",{"$f":"RANK(B61,$B61:$O61)","v":14},11,5,4,2,10,6,8,3,{"$f":"RANK(K61,$B61:$O61)","v":7},13,9,12,1]
[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.26457036646269472},0.79486986078630362,0.71361866503140259,0.74758249422686429,0.82521138744372158,0.9433113749774813,0.84484635993588353,6.4915015734664516E-2,0.39643626557404377,4.0697532709256024E-2,0.77382144703435407,0.50453631243411823,0.29705984169355382,0.62506500975424484,0.26356299582655263]
["R2",0.64940457182960154,0.26455861320609153,0.98376127789483525,0.5544834436721332,0.78440443768979862,0.15676409596675089,0.69980033598656843,0.20101777884435312,0.5647436072448796,0.52870580622233587,0.5245177077837857,5.7000368360974107E-2,0.51087516463740956,0.22988729198914126,0.62516500812587272]
["R3",0.16498453471472796,0.72980183142011557,6.1218748603208972E-5,0.25677931592377401,0.4162174384230769,0.39659079979246781,0.32575746885317602,0.10225418852676404,0.76695281581266983,0.64844107714073995,0.49042997309673519,0.80796465012452146,0.76024958047759539,0.8892429200471943,0.87340466580477183]
["R4",0.95874528742732246,0.32430263142040816,0.35958677329121647,0.86088958547957672,0.50784424256463234,0.687190470310032,0.36527510886207937,0.49405696433776081,0.68412491766752237,0.45492045142209203,0.68484691185555768,0.73159639746693939,0.29523867374149071,0.36288599719187042,0.1859248123455669]
["R5",0.15300061048727187,0.95794422946537128,0.52308672783212395,0.77574964574056737,0.34912732355261722,0.45882566120357149,0.92094554253289018,8.3749297849507243E-2,0.14358653240181418,7.5602996274176326E-2,0.54116558087623168,0.54181992638268228,5.6733466012101164E-2,0.82976480002192909,0.48494860046938137]
["R1",{"$f":"RANK(B68,$B68:$P68)","v":12},4,7,6,3,1,2,14,10,{"$f":"RANK(K68,$B68:$P68)","v":15},5,9,11,8,13]
["R2",{"$f":"RANK(B69,$B69:$P69)","v":4},11,1,7,2,14,3,13,6,{"$f":"RANK(K69,$B69:$P69)","v":8},9,15,10,12,5]
["R3",{"$f":"RANK(B70,$B70:$P70)","v":13},6,15,12,9,10,11,14,4,{"$f":"RANK(K70,$B70:$P70)","v":7},8,3,5,1,2]
["R4",{"$f":"RANK(B71,$B71:$P71)","v":1},13,12,2,7,4,10,8,6,{"$f":"RANK(K71,$B71:$P71)","v":9},5,3,14,11,15]
["R5",{"$f":"RANK(B72,$B72:$P72)","v":11},1,7,4,10,9,2,13,12,{"$f":"RANK(K72,$B72:$P72)","v":14},6,5,15,3,8]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0]
["R1",{"$f":"RAND()","v":0.49826508870528896},{"$f":"RAND()","v":0.27005809126663072},0.95189624813821538,0.37193320183717871,0.11432708300642302,0.6153454903134925,0.87317043661274985,0.4824898240969957]
["R2",0.7267051669656972,0.48904938255858732,0.50031444857228802,0.17673299969313283,0.30595880568577227,0.36261484897943708,0.49694682783744371,0.9448877685017496]
["R3",0.4660279985718393,0.54140462278968671,0.20160030587008781,0.75126882869045797,0.81875690475015495,0.15970095043046817,0.69941441003810034,0.32619229843660702]
["R4",0.35067235702520339,0.21287174168023848,0.54757384582605162,0.59578134683322259,9.5044090891549415E-2,0.60822240376373304,0.91018380142495892,5.6910663232417225E-2]
["R5",0.326961894244993,0.22068398448180526,0.58899512211726335,0.7684379593678945,0.48545702366657772,0.64860246807893018,0.62663524178564023,0.93930609677585053]
["R1",{"$f":"RANK(B79,$B79:$L79)","v":4},7,1,6,8,3,2,5]
["R2",2,5,3,8,7,6,4,1]
["R3",5,4,7,2,1,8,3,6]
["R4",5,6,4,3,7,2,1,8]
["R5",7,8,5,2,6,3,4,1]
[]
["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.52233499626520585},{"$f":"RAND()","v":0.10811160706737177},0.88297268434828657,0.70163038424193958,0.11097444028738845,0.41192146146642061,0.72357152974531336]
[null,0.80547357262146846,0.98618025773088158,0.67366232510842938,0.96271179372320004,0.93698554807405066,0.75277357980981452,0.16152083617784907]
[null,0.71312783457820506,0.97417933581963967,0.78721180957059145,0.64546675549485699,0.95995553230475394,6.372342332964831E-2,0.45946761229382493]
[null,0.91876111403631888,0.37559774546907765,0.12008416523717236,0.73513339688501489,4.1193140213085844E-2,0.43763878812344803,0.92904168268421961]
[null,0.12930784388115435,0.63893115120011246,0.19016452856858401,0.8161691903189906,0.58718079853481231,0.8991129721589004,0.72391782535164595]
[null,{"$f":"RANK(B100,$B100:$L100)","v":4},7,1,3,6,5,2]
[null,{"$f":"RANK(B101,$B101:$L101)","v":4},1,6,2,3,5,7]
[null,{"$f":"RANK(B102,$B102:$L102)","v":4},1,3,5,2,7,6]
[null,{"$f":"RANK(B103,$B103:$L103)","v":2},5,6,3,7,4,1]
[null,{"$f":"RANK(B104,$B104:$L104)","v":7},4,6,2,5,1,3]

{"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}]