{"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":-2},{"$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":-1},{"$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":2},{"$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":3},{"$f":"IF(K9<1,\"\",VLOOKUP($G9,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G9","v":0},{"$f":"BLANKS!H9","v":0},{"$f":"IF($M9=\"\",\"\",VLOOKUP($M9,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q9<1,\"\",VLOOKUP($M9,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A10","v":"Marc Leishman"},{"$f":"BLANKS!B10","v":5},{"$f":"IF($A10=\"\",\"\",VLOOKUP($A10,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(E10<1,\"\",VLOOKUP($A10,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D10","v":"Martin Kaymer"},{"$f":"BLANKS!E10","v":2},{"$f":"IF($G10=\"\",\"\",VLOOKUP($G10,webquery!S:V,2,FALSE))","v":-1},{"$f":"IF(K10<1,\"\",VLOOKUP($G10,webquery!$S:$V,4,FALSE))","v":"F"},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":3},{"$f":"IF(E11<1,\"\",VLOOKUP($A11,webquery!$S:V,4,FALSE))","v":"F"},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":-2},{"$f":"IF(K11<1,\"\",VLOOKUP($G11,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G11","v":0},{"$f":"BLANKS!H11","v":0},{"$f":"IF($M11=\"\",\"\",VLOOKUP($M11,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q11<1,\"\",VLOOKUP($M11,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A12","v":"Geoff Ogilvy"},{"$f":"BLANKS!B12","v":5},{"$f":"IF($A12=\"\",\"\",VLOOKUP($A12,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(E12<1,\"\",VLOOKUP($A12,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D12","v":"Steve Stricker"},{"$f":"BLANKS!E12","v":4},{"$f":"IF($G12=\"\",\"\",VLOOKUP($G12,webquery!S:V,2,FALSE))","v":-2},{"$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":-4},{"$f":"IF(ISERROR(C13-B7/100),\"\",C13-B7/100)","v":-4.0439999999999996},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":-5},{"$f":"IF(ISERROR(I13-H7/100),\"\",I13-H7/100)","v":-5.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":-2},{"$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":-1},{"$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":0},{"$f":"IF(E18<1,\"\",VLOOKUP($A18,webquery!$S:V,4,FALSE))","v":"F"},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":1},{"$f":"IF(K18<1,\"\",VLOOKUP($G18,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G18","v":0},{"$f":"BLANKS!H18","v":0},{"$f":"IF($M18=\"\",\"\",VLOOKUP($M18,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q18<1,\"\",VLOOKUP($M18,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
[{"$f":"BLANKS!A19","v":"Jimmy Walker"},{"$f":"BLANKS!B19","v":4},{"$f":"IF($A19=\"\",\"\",VLOOKUP($A19,webquery!S:V,2,FALSE))","v":-2},{"$f":"IF(E19<1,\"\",VLOOKUP($A19,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D19","v":"Jim Furyk"},{"$f":"BLANKS!E19","v":1},{"$f":"IF($G19=\"\",\"\",VLOOKUP($G19,webquery!S:V,2,FALSE))","v":-5},{"$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":2},{"$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":-1},{"$f":"IF(E21<1,\"\",VLOOKUP($A21,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D21","v":"Hunter Mahan"},{"$f":"BLANKS!E21","v":3},{"$f":"IF($G21=\"\",\"\",VLOOKUP($G21,webquery!S:V,2,FALSE))","v":-1},{"$f":"IF(K21<1,\"\",VLOOKUP($G21,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G21","v":0},{"$f":"BLANKS!H21","v":0},{"$f":"IF($M21=\"\",\"\",VLOOKUP($M21,webquery!S:V,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Q21<1,\"\",VLOOKUP($M21,webquery!$S:$V,4,FALSE))","v":{"$error":"#N/A"}},1.5]
["Best 3",null,{"$f":"IF(ISERROR(SMALL(C17:C21,1)+SMALL(C17:C21,2)+SMALL(C17:C21,3)),\"\",SMALL(C17:C21,1)+SMALL(C17:C21,2)+SMALL(C17:C21,3))","v":-7},{"$f":"IF(ISERROR(C22-B16/100),\"\",C22-B16/100)","v":-7.0339999999999998},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":-7},{"$f":"IF(ISERROR(I22-H16/100),\"\",I22-H16/100)","v":-7.0380000000000003},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":3},{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,5,FALSE)","v":4},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,4,FALSE)","v":3},{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,5,FALSE)","v":3},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(M16,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(M16,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick"]
[]
[{"$f":"'random picks'!D2","v":"BYRON"},{"$f":"SUM(B26:B30)/5","v":4.8},null,null,null,null,{"$f":"'random picks'!H2","v":"STUART D"},{"$f":"SUM(H26:H30)/5","v":4},null,null,null,null,{"$f":"'random picks'!L2","v":0},{"$f":"SUM(N26:N30)/5","v":0}]
[{"$f":"BLANKS!A26","v":"Henrik Stenson"},{"$f":"BLANKS!B26","v":7},{"$f":"IF($A26=\"\",\"\",VLOOKUP($A26,webquery!S:V,2,FALSE))","v":-5},{"$f":"IF(E26<1,\"\",VLOOKUP($A26,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D26","v":"Adam Scott"},{"$f":"BLANKS!E26","v":2},{"$f":"IF($G26=\"\",\"\",VLOOKUP($G26,webquery!S:V,2,FALSE))","v":0},{"$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":3},{"$f":"IF(K27<1,\"\",VLOOKUP($G27,webquery!$S:$V,4,FALSE))","v":"F"},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":-6},{"$f":"IF(E28<1,\"\",VLOOKUP($A28,webquery!$S:V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!D28","v":"Hideki Matsuyama"},{"$f":"BLANKS!E28","v":3},{"$f":"IF($G28=\"\",\"\",VLOOKUP($G28,webquery!S:V,2,FALSE))","v":0},{"$f":"IF(K28<1,\"\",VLOOKUP($G28,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G19","v":0},{"$f":"BLANKS!H28","v":0}]
[{"$f":"BLANKS!A29","v":"Ryan Moore"},{"$f":"BLANKS!B29","v":4},{"$f":"IF($A29=\"\",\"\",VLOOKUP($A29,webquery!S:V,2,FALSE))","v":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":-1},{"$f":"IF(K29<1,\"\",VLOOKUP($G29,webquery!$S:$V,4,FALSE))","v":"F"},1.5,null,{"$f":"BLANKS!G20","v":0},{"$f":"BLANKS!H29","v":0}]
[{"$f":"BLANKS!A30","v":"Jason Dufner"},{"$f":"BLANKS!B30","v":2},{"$f":"IF($A30=\"\",\"\",VLOOKUP($A30,webquery!S:V,2,FALSE))","v":"WD"},{"$f":"IF(E30<1,\"\",VLOOKUP($A30,webquery!$S:V,4,FALSE))","v":"-"},1.5,null,{"$f":"BLANKS!D30","v":"Webb Simpson"},{"$f":"BLANKS!E30","v":6},{"$f":"IF($G30=\"\",\"\",VLOOKUP($G30,webquery!S:V,2,FALSE))","v":2},{"$f":"IF(K30<1,\"\",VLOOKUP($G30,webquery!$S:$V,4,FALSE))","v":"F"},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":-9},{"$f":"IF(ISERROR(C31-B25/100),\"\",C31-B25/100)","v":-9.048},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(I26:I30,1)+SMALL(I26:I30,2)+SMALL(I26:I30,3)),\"\",SMALL(I26:I30,1)+SMALL(I26:I30,2)+SMALL(I26:I30,3))","v":-1},{"$f":"IF(ISERROR(I31-H25/100),\"\",I31-H25/100)","v":-1.04},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(O26:O30,1)+SMALL(O26:O30,2)+SMALL(O26:O30,3)),\"\",SMALL(O26:O30,1)+SMALL(O26:O30,2)+SMALL(O26:O30,3))","v":""},{"$f":"IF(ISERROR(O31-N25/100),\"\",O31-N25/100)","v":""}]
["Running position",null,{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,4,FALSE)","v":1},{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,5,FALSE)","v":1},"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":-5},{"$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":-1},{"$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":-2},{"$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":11},{"$f":"IF(E38<1,\"\",VLOOKUP($A38,webquery!$S:V,4,FALSE))","v":"F"},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":-8},{"$f":"IF(ISERROR(C40-B34/100),\"\",C40-B34/100)","v":-8.0459999999999994},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":2},{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,5,FALSE)","v":2},"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,"T1","Lee Westwood",65,"13:25:00","-","-",-6,"F",-6,65,null,null,null,null,null,null,7,{"$f":"SUBSTITUTE(INDEX($A:$J,R7,$S$2),\"*\",\"\")","v":"Lee Westwood"},{"$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":-6},{"$f":"IF(ISERROR(INDEX($A:$J,R7,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R7,$U$2)+TIME(5,0,0))","v":""},{"$f":"INDEX($A:$N,R7,$V$2)","v":"F"}]
[null,"T1","Kevin Chappell",65,"13:30:00","-","-",-6,"F",-6,65,null,null,null,null,null,null,{"$f":"R7+1","v":8},{"$f":"SUBSTITUTE(INDEX($A:$J,R8,$S$2),\"*\",\"\")","v":"Kevin Chappell"},{"$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":-6},{"$f":"IF(ISERROR(INDEX($A:$J,R8,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R8,$U$2)+TIME(5,0,0))","v":""},{"$f":"INDEX($A:$N,R8,$V$2)","v":"F"}]
[null,"T1","Ryan Palmer",65,"07:30:00","-","-",-6,"F",-6,65,null,null,null,null,null,null,{"$f":"R8+1","v":9},{"$f":"SUBSTITUTE(INDEX($A:$J,R9,$S$2),\"*\",\"\")","v":"Ryan Palmer"},{"$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":-6},{"$f":"IF(ISERROR(INDEX($A:$J,R9,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R9,$U$2)+TIME(5,0,0))","v":""},{"$f":"INDEX($A:$N,R9,$V$2)","v":"F"}]
[null,"T4","Jim Furyk",66,"14:05:00","-","-",-5,"F",-5,66,null,null,null,null,null,null,10,{"$f":"SUBSTITUTE(INDEX($A:$J,R10,$S$2),\"*\",\"\")","v":"Jim Furyk"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R10,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R10,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T4","Edoardo Molinari",66,"14:30:00","-","-",-5,"F",-5,66,null,null,null,null,null,null,11,{"$f":"SUBSTITUTE(INDEX($A:$J,R11,$S$2),\"*\",\"\")","v":"Edoardo Molinari"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R11,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R11,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T4","Henrik Stenson",66,"08:25:00","-","-",-5,"F",-5,66,null,null,null,null,null,null,12,{"$f":"SUBSTITUTE(INDEX($A:$J,R12,$S$2),\"*\",\"\")","v":"Henrik Stenson"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R12,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R12,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T4","Rory McIlroy",66,"08:35:00","-","-",-5,"F",-5,66,null,null,null,null,null,null,13,{"$f":"SUBSTITUTE(INDEX($A:$J,R13,$S$2),\"*\",\"\")","v":"Rory McIlroy"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R13,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R13,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T4","Chris Wood",66,"09:20:00","-","-",-5,"F",-5,66,null,null,null,null,null,null,14,{"$f":"SUBSTITUTE(INDEX($A:$J,R14,$S$2),\"*\",\"\")","v":"Chris Wood"},-5,{"$f":"IF(ISERROR(INDEX($A:$J,R14,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R14,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T9","Mikko Ilonen",67,"14:45:00","-","-",-4,"F",-4,67,null,null,null,null,null,null,15,{"$f":"SUBSTITUTE(INDEX($A:$J,R15,$S$2),\"*\",\"\")","v":"Mikko Ilonen"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R15,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R15,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T9","Jerry Kelly",67,"09:00:00","-","-",-4,"F",-4,67,null,null,null,null,null,null,16,{"$f":"SUBSTITUTE(INDEX($A:$J,R16,$S$2),\"*\",\"\")","v":"Jerry Kelly"},-4,{"$f":"IF(ISERROR(INDEX($A:$J,R16,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R16,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Joost Luiten",68,"12:50:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,17,{"$f":"SUBSTITUTE(INDEX($A:$J,R17,$S$2),\"*\",\"\")","v":"Joost Luiten"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R17,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R17,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Ian Poulter",68,"13:35:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,18,{"$f":"SUBSTITUTE(INDEX($A:$J,R18,$S$2),\"*\",\"\")","v":"Ian Poulter"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R18,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R18,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Bernd Wiesberger",68,"14:25:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,19,{"$f":"SUBSTITUTE(INDEX($A:$J,R19,$S$2),\"*\",\"\")","v":"Bernd Wiesberger"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R19,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R19,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Shane Lowry",68,"07:30:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,20,{"$f":"SUBSTITUTE(INDEX($A:$J,R20,$S$2),\"*\",\"\")","v":"Shane Lowry"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R20,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R20,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Danny Willett",68,"08:00:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,21,{"$f":"SUBSTITUTE(INDEX($A:$J,R21,$S$2),\"*\",\"\")","v":"Danny Willett"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R21,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R21,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Shawn Stefani",68,"08:20:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,22,{"$f":"SUBSTITUTE(INDEX($A:$J,R22,$S$2),\"*\",\"\")","v":"Shawn Stefani"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R22,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R22,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Matt Jones",68,"08:50:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,23,{"$f":"SUBSTITUTE(INDEX($A:$J,R23,$S$2),\"*\",\"\")","v":"Matt Jones"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R23,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R23,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","Seung-yul Noh",68,"08:50:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,24,{"$f":"SUBSTITUTE(INDEX($A:$J,R24,$S$2),\"*\",\"\")","v":"Seung-yul Noh"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R24,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R24,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T11","J.B. Holmes",68,"08:55:00","-","-",-3,"F",-3,68,null,null,null,null,null,null,25,{"$f":"SUBSTITUTE(INDEX($A:$J,R25,$S$2),\"*\",\"\")","v":"J.B. Holmes"},-3,{"$f":"IF(ISERROR(INDEX($A:$J,R25,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R25,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Victor Dubuisson",69,"13:15:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,26,{"$f":"SUBSTITUTE(INDEX($A:$J,R26,$S$2),\"*\",\"\")","v":"Victor Dubuisson"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R26,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R26,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Rickie Fowler",69,"13:15:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,27,{"$f":"SUBSTITUTE(INDEX($A:$J,R27,$S$2),\"*\",\"\")","v":"Rickie Fowler"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R27,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R27,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Nick Watney",69,"13:20:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,28,{"$f":"SUBSTITUTE(INDEX($A:$J,R28,$S$2),\"*\",\"\")","v":"Nick Watney"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R28,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R28,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Jason Day",69,"13:35:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,29,{"$f":"SUBSTITUTE(INDEX($A:$J,R29,$S$2),\"*\",\"\")","v":"Jason Day"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R29,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R29,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Jimmy Walker",69,"13:35:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,30,{"$f":"SUBSTITUTE(INDEX($A:$J,R30,$S$2),\"*\",\"\")","v":"Jimmy Walker"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R30,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R30,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Phil Mickelson",69,"13:45:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,31,{"$f":"SUBSTITUTE(INDEX($A:$J,R31,$S$2),\"*\",\"\")","v":"Phil Mickelson"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R31,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R31,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Jamie Donaldson",69,"14:10:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,32,{"$f":"SUBSTITUTE(INDEX($A:$J,R32,$S$2),\"*\",\"\")","v":"Jamie Donaldson"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R32,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R32,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Rafael Cabrera-Bello",69,"14:20:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,33,{"$f":"SUBSTITUTE(INDEX($A:$J,R33,$S$2),\"*\",\"\")","v":"Rafael Cabrera-Bello"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R33,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R33,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Kevin Streelman",69,"14:30:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,34,{"$f":"SUBSTITUTE(INDEX($A:$J,R34,$S$2),\"*\",\"\")","v":"Kevin Streelman"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R34,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R34,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Russell Henley",69,"14:35:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,35,{"$f":"SUBSTITUTE(INDEX($A:$J,R35,$S$2),\"*\",\"\")","v":"Russell Henley"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R35,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R35,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Alexander Levy",69,"07:50:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,36,{"$f":"SUBSTITUTE(INDEX($A:$J,R36,$S$2),\"*\",\"\")","v":"Alexander Levy"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R36,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R36,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Graham DeLaet",69,"08:05:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,37,{"$f":"SUBSTITUTE(INDEX($A:$J,R37,$S$2),\"*\",\"\")","v":"Graham DeLaet"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R37,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R37,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Steve Stricker",69,"08:15:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,38,{"$f":"SUBSTITUTE(INDEX($A:$J,R38,$S$2),\"*\",\"\")","v":"Steve Stricker"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R38,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R38,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Cameron Tringale",69,"08:30:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,39,{"$f":"SUBSTITUTE(INDEX($A:$J,R39,$S$2),\"*\",\"\")","v":"Cameron Tringale"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R39,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R39,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T20","Geoff Ogilvy",69,"09:30:00","-","-",-2,"F",-2,69,null,null,null,null,null,null,40,{"$f":"SUBSTITUTE(INDEX($A:$J,R40,$S$2),\"*\",\"\")","v":"Geoff Ogilvy"},-2,{"$f":"IF(ISERROR(INDEX($A:$J,R40,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R40,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Patrick Reed",70,"12:55:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,41,{"$f":"SUBSTITUTE(INDEX($A:$J,R41,$S$2),\"*\",\"\")","v":"Patrick Reed"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R41,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R41,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Colin Montgomerie",70,"13:05:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,42,{"$f":"SUBSTITUTE(INDEX($A:$J,R42,$S$2),\"*\",\"\")","v":"Colin Montgomerie"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R42,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R42,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Brendon Todd",70,"13:10:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,43,{"$f":"SUBSTITUTE(INDEX($A:$J,R43,$S$2),\"*\",\"\")","v":"Brendon Todd"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R43,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R43,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Ernie Els",70,"13:15:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,44,{"$f":"SUBSTITUTE(INDEX($A:$J,R44,$S$2),\"*\",\"\")","v":"Ernie Els"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R44,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R44,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Brendon de Jonge",70,"13:20:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,45,{"$f":"SUBSTITUTE(INDEX($A:$J,R45,$S$2),\"*\",\"\")","v":"Brendon de Jonge"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R45,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R45,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Louis Oosthuizen",70,"14:15:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,46,{"$f":"SUBSTITUTE(INDEX($A:$J,R46,$S$2),\"*\",\"\")","v":"Louis Oosthuizen"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R46,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R46,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Justin Rose",70,"14:15:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,47,{"$f":"SUBSTITUTE(INDEX($A:$J,R47,$S$2),\"*\",\"\")","v":"Justin Rose"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R47,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R47,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Stephen Gallacher",70,"14:20:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,48,{"$f":"SUBSTITUTE(INDEX($A:$J,R48,$S$2),\"*\",\"\")","v":"Stephen Gallacher"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R48,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R48,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Charley Hoffman",70,"07:40:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,49,{"$f":"SUBSTITUTE(INDEX($A:$J,R49,$S$2),\"*\",\"\")","v":"Charley Hoffman"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R49,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R49,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Sergio Garcia",70,"08:15:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,50,{"$f":"SUBSTITUTE(INDEX($A:$J,R50,$S$2),\"*\",\"\")","v":"Sergio Garcia"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R50,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R50,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Martin Kaymer",70,"08:35:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,51,{"$f":"SUBSTITUTE(INDEX($A:$J,R51,$S$2),\"*\",\"\")","v":"Martin Kaymer"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R51,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R51,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Bubba Watson",70,"08:35:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,52,{"$f":"SUBSTITUTE(INDEX($A:$J,R52,$S$2),\"*\",\"\")","v":"Bubba Watson"},-1,{"$f":"IF(ISERROR(INDEX($A:$J,R52,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R52,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T35","Hunter Mahan",70,"08:40:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,53,{"$f":"SUBSTITUTE(INDEX($A:$J,R53,$S$2),\"*\",\"\")","v":"Hunter Mahan"},-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":""},"F"]
[null,"T35","Luke Donald",70,"08:55:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,54,{"$f":"SUBSTITUTE(INDEX($A:$J,R54,$S$2),\"*\",\"\")","v":"Luke Donald"},-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":""},"F"]
[null,"T35","Zach Johnson",70,"09:05:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,55,{"$f":"SUBSTITUTE(INDEX($A:$J,R55,$S$2),\"*\",\"\")","v":"Zach Johnson"},-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":""},"F"]
[null,"T35","Richard Sterne",70,"09:05:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,56,{"$f":"SUBSTITUTE(INDEX($A:$J,R56,$S$2),\"*\",\"\")","v":"Richard Sterne"},-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":""},"F"]
[null,"T35","Tim Clark",70,"09:15:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,57,{"$f":"SUBSTITUTE(INDEX($A:$J,R57,$S$2),\"*\",\"\")","v":"Tim Clark"},-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":""},"F"]
[null,"T35","Daniel Summerhays",70,"09:30:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,58,{"$f":"SUBSTITUTE(INDEX($A:$J,R58,$S$2),\"*\",\"\")","v":"Daniel Summerhays"},-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":""},"F"]
[null,"T35","Chris Stroud",70,"09:35:00","-","-",-1,"F",-1,70,null,null,null,null,null,null,59,{"$f":"SUBSTITUTE(INDEX($A:$J,R59,$S$2),\"*\",\"\")","v":"Chris Stroud"},-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":""},"F"]
[null,"T54","Robert Karlsson",71,"12:45:00","-","-","E","F","E",71,null,null,null,null,null,null,60,{"$f":"SUBSTITUTE(INDEX($A:$J,R60,$S$2),\"*\",\"\")","v":"Robert Karlsson"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R60,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R60,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Hideki Matsuyama",71,"12:55:00","-","-","E","F","E",71,null,null,null,null,null,null,61,{"$f":"SUBSTITUTE(INDEX($A:$J,R61,$S$2),\"*\",\"\")","v":"Hideki Matsuyama"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R61,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R61,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Billy Horschel",71,"13:00:00","-","-","E","F","E",71,null,null,null,null,null,null,62,{"$f":"SUBSTITUTE(INDEX($A:$J,R62,$S$2),\"*\",\"\")","v":"Billy Horschel"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R62,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R62,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Brian Stuard",71,"13:10:00","-","-","E","F","E",71,null,null,null,null,null,null,63,{"$f":"SUBSTITUTE(INDEX($A:$J,R63,$S$2),\"*\",\"\")","v":"Brian Stuard"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R63,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R63,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Adam Scott",71,"13:25:00","-","-","E","F","E",71,null,null,null,null,null,null,64,{"$f":"SUBSTITUTE(INDEX($A:$J,R64,$S$2),\"*\",\"\")","v":"Adam Scott"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R64,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R64,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Jordan Spieth",71,"13:25:00","-","-","E","F","E",71,null,null,null,null,null,null,65,{"$f":"SUBSTITUTE(INDEX($A:$J,R65,$S$2),\"*\",\"\")","v":"Jordan Spieth"},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":""},"F"]
[null,"T54","Brian Harman",71,"13:50:00","-","-","E","F","E",71,null,null,null,null,null,null,66,{"$f":"SUBSTITUTE(INDEX($A:$J,R66,$S$2),\"*\",\"\")","v":"Brian Harman"},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":""},"F"]
[null,"T54","Thongchai Jaidee",71,"13:50:00","-","-","E","F","E",71,null,null,null,null,null,null,67,{"$f":"SUBSTITUTE(INDEX($A:$J,R67,$S$2),\"*\",\"\")","v":"Thongchai Jaidee"},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":""},"F"]
[null,"T54","Brooks Koepka",71,"13:55:00","-","-","E","F","E",71,null,null,null,null,null,null,68,{"$f":"SUBSTITUTE(INDEX($A:$J,R68,$S$2),\"*\",\"\")","v":"Brooks Koepka"},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":""},"F"]
[null,"T54","Kevin Stadler",71,"14:00:00","-","-","E","F","E",71,null,null,null,null,null,null,69,{"$f":"SUBSTITUTE(INDEX($A:$J,R69,$S$2),\"*\",\"\")","v":"Kevin Stadler"},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":""},"F"]
[null,"T54","Marc Leishman",71,"14:25:00","-","-","E","F","E",71,null,null,null,null,null,null,70,{"$f":"SUBSTITUTE(INDEX($A:$J,R70,$S$2),\"*\",\"\")","v":"Marc Leishman"},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":""},"F"]
[null,"T54","Marc Warren",71,"14:35:00","-","-","E","F","E",71,null,null,null,null,null,null,71,{"$f":"SUBSTITUTE(INDEX($A:$J,R71,$S$2),\"*\",\"\")","v":"Marc Warren"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R71,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R71,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Pat Perez",71,"14:40:00","-","-","E","F","E",71,null,null,null,null,null,null,72,{"$f":"SUBSTITUTE(INDEX($A:$J,R72,$S$2),\"*\",\"\")","v":"Pat Perez"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R72,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R72,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Brendan Steele",71,"14:40:00","-","-","E","F","E",71,null,null,null,null,null,null,{"$f":"R72+1","v":73},{"$f":"SUBSTITUTE(INDEX($A:$J,R73,$S$2),\"*\",\"\")","v":"Brendan Steele"},{"$f":"IF(INDEX($A:$L,R73,$T$2)=\"E\",0,IF(INDEX($A:$L,R73,$T$2)=\"MC\",100,INDEX($A:$L,R73,$T$2)))","v":0},{"$f":"IF(ISERROR(INDEX($A:$J,R73,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R73,$U$2)+TIME(5,0,0))","v":""},{"$f":"INDEX($A:$N,R73,$V$2)","v":"F"}]
[null,"T54","Scott Brown",71,"07:40:00","-","-","E","F","E",71,null,null,null,null,null,null,74,{"$f":"SUBSTITUTE(INDEX($A:$J,R74,$S$2),\"*\",\"\")","v":"Scott Brown"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R74,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R74,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Scott Stallings",71,"07:45:00","-","-","E","F","E",71,null,null,null,null,null,null,75,{"$f":"SUBSTITUTE(INDEX($A:$J,R75,$S$2),\"*\",\"\")","v":"Scott Stallings"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R75,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R75,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Jonas Blixt",71,"07:55:00","-","-","E","F","E",71,null,null,null,null,null,null,76,{"$f":"SUBSTITUTE(INDEX($A:$J,R76,$S$2),\"*\",\"\")","v":"Jonas Blixt"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R76,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R76,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Erik Compton",71,"07:55:00","-","-","E","F","E",71,null,null,null,null,null,null,77,{"$f":"SUBSTITUTE(INDEX($A:$J,R77,$S$2),\"*\",\"\")","v":"Erik Compton"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R77,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R77,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Fabrizio Zanotti",71,"08:00:00","-","-","E","F","E",71,null,null,null,null,null,null,78,{"$f":"SUBSTITUTE(INDEX($A:$J,R78,$S$2),\"*\",\"\")","v":"Fabrizio Zanotti"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R78,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R78,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Gonzalo Fernandez-Casta",71,"08:05:00","-","-","E","F","E",71,null,null,null,null,null,null,79,{"$f":"SUBSTITUTE(INDEX($A:$J,R79,$S$2),\"*\",\"\")","v":"Gonzalo Fernandez-Casta"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R79,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R79,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Bill Haas",71,"08:10:00","-","-","E","F","E",71,null,null,null,null,null,null,80,{"$f":"SUBSTITUTE(INDEX($A:$J,R80,$S$2),\"*\",\"\")","v":"Bill Haas"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R80,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R80,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Vijay Singh",71,"08:20:00","-","-","E","F","E",71,null,null,null,null,null,null,81,{"$f":"SUBSTITUTE(INDEX($A:$J,R81,$S$2),\"*\",\"\")","v":"Vijay Singh"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R81,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R81,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Thorbjorn Olesen",71,"08:40:00","-","-","E","F","E",71,null,null,null,null,null,null,82,{"$f":"SUBSTITUTE(INDEX($A:$J,R82,$S$2),\"*\",\"\")","v":"Thorbjorn Olesen"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R82,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R82,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Francesco Molinari",71,"08:55:00","-","-","E","F","E",71,null,null,null,null,null,null,83,{"$f":"SUBSTITUTE(INDEX($A:$J,R83,$S$2),\"*\",\"\")","v":"Francesco Molinari"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R83,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R83,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T54","Jason Bohn",71,"09:35:00","-","-","E","F","E",71,null,null,null,null,null,null,84,{"$f":"SUBSTITUTE(INDEX($A:$J,R84,$S$2),\"*\",\"\")","v":"Jason Bohn"},0,{"$f":"IF(ISERROR(INDEX($A:$J,R84,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R84,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Shaun Micheel",72,"13:05:00","-","-",1,"F",1,72,null,null,null,null,null,null,85,{"$f":"SUBSTITUTE(INDEX($A:$J,R85,$S$2),\"*\",\"\")","v":"Shaun Micheel"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R85,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R85,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Fredrik Jacobson",72,"13:20:00","-","-",1,"F",1,72,null,null,null,null,null,null,86,{"$f":"SUBSTITUTE(INDEX($A:$J,R86,$S$2),\"*\",\"\")","v":"Fredrik Jacobson"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R86,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R86,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","K.J. Choi",72,"13:50:00","-","-",1,"F",1,72,null,null,null,null,null,null,87,{"$f":"SUBSTITUTE(INDEX($A:$J,R87,$S$2),\"*\",\"\")","v":"K.J. Choi"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R87,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R87,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Miguel Angel Jimenez",72,"14:05:00","-","-",1,"F",1,72,null,null,null,null,null,null,88,{"$f":"SUBSTITUTE(INDEX($A:$J,R88,$S$2),\"*\",\"\")","v":"Miguel Angel Jimenez"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R88,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R88,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Charl Schwartzel",72,"14:05:00","-","-",1,"F",1,72,null,null,null,null,null,null,89,{"$f":"SUBSTITUTE(INDEX($A:$J,R89,$S$2),\"*\",\"\")","v":"Charl Schwartzel"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R89,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R89,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Stewart Cink",72,"14:10:00","-","-",1,"F",1,72,null,null,null,null,null,null,90,{"$f":"SUBSTITUTE(INDEX($A:$J,R90,$S$2),\"*\",\"\")","v":"Stewart Cink"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R90,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R90,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Ryo Ishikawa",72,"07:35:00","-","-",1,"F",1,72,null,null,null,null,null,null,91,{"$f":"SUBSTITUTE(INDEX($A:$J,R91,$S$2),\"*\",\"\")","v":"Ryo Ishikawa"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R91,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R91,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Gary Woodland",72,"08:05:00","-","-",1,"F",1,72,null,null,null,null,null,null,92,{"$f":"SUBSTITUTE(INDEX($A:$J,R92,$S$2),\"*\",\"\")","v":"Gary Woodland"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R92,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R92,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Anirban Lahiri",72,"08:10:00","-","-",1,"F",1,72,null,null,null,null,null,null,93,{"$f":"SUBSTITUTE(INDEX($A:$J,R93,$S$2),\"*\",\"\")","v":"Anirban Lahiri"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R93,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R93,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Tom Watson",72,"08:15:00","-","-",1,"F",1,72,null,null,null,null,null,null,94,{"$f":"SUBSTITUTE(INDEX($A:$J,R94,$S$2),\"*\",\"\")","v":"Tom Watson"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R94,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R94,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Davis Love III",72,"08:20:00","-","-",1,"F",1,72,null,null,null,null,null,null,95,{"$f":"SUBSTITUTE(INDEX($A:$J,R95,$S$2),\"*\",\"\")","v":"Davis Love III"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R95,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R95,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Kenny Perry",72,"08:25:00","-","-",1,"F",1,72,null,null,null,null,null,null,96,{"$f":"SUBSTITUTE(INDEX($A:$J,R96,$S$2),\"*\",\"\")","v":"Kenny Perry"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R96,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R96,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Kiradech Aphibarnrat",72,"08:30:00","-","-",1,"F",1,72,null,null,null,null,null,null,97,{"$f":"SUBSTITUTE(INDEX($A:$J,R97,$S$2),\"*\",\"\")","v":"Kiradech Aphibarnrat"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R97,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R97,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T79","Steve Schneiter",72,"09:10:00","-","-",1,"F",1,72,null,null,null,null,null,null,98,{"$f":"SUBSTITUTE(INDEX($A:$J,R98,$S$2),\"*\",\"\")","v":"Steve Schneiter"},1,{"$f":"IF(ISERROR(INDEX($A:$J,R98,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R98,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Roberto Castro",73,"12:40:00","-","-",2,"F",2,73,null,null,null,null,null,null,99,{"$f":"SUBSTITUTE(INDEX($A:$J,R99,$S$2),\"*\",\"\")","v":"Roberto Castro"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R99,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R99,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Charles Howell III",73,"12:50:00","-","-",2,"F",2,73,null,null,null,null,null,null,100,{"$f":"SUBSTITUTE(INDEX($A:$J,R100,$S$2),\"*\",\"\")","v":"Charles Howell III"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R100,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R100,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","George Coetzee",73,"13:00:00","-","-",2,"F",2,73,null,null,null,null,null,null,101,{"$f":"SUBSTITUTE(INDEX($A:$J,R101,$S$2),\"*\",\"\")","v":"George Coetzee"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R101,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R101,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Matt Every",73,"13:30:00","-","-",2,"F",2,73,null,null,null,null,null,null,102,{"$f":"SUBSTITUTE(INDEX($A:$J,R102,$S$2),\"*\",\"\")","v":"Matt Every"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R102,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R102,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Ross Fisher",73,"13:30:00","-","-",2,"F",2,73,null,null,null,null,null,null,103,{"$f":"SUBSTITUTE(INDEX($A:$J,R103,$S$2),\"*\",\"\")","v":"Ross Fisher"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R103,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R103,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Padraig Harrington",73,"13:45:00","-","-",2,"F",2,73,null,null,null,null,null,null,104,{"$f":"SUBSTITUTE(INDEX($A:$J,R104,$S$2),\"*\",\"\")","v":"Padraig Harrington"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R104,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R104,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Graeme McDowell",73,"13:55:00","-","-",2,"F",2,73,null,null,null,null,null,null,105,{"$f":"SUBSTITUTE(INDEX($A:$J,R105,$S$2),\"*\",\"\")","v":"Graeme McDowell"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R105,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R105,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Brandt Snedeker",73,"13:55:00","-","-",2,"F",2,73,null,null,null,null,null,null,106,{"$f":"SUBSTITUTE(INDEX($A:$J,R106,$S$2),\"*\",\"\")","v":"Brandt Snedeker"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R106,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R106,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Hyung-Sung Kim",73,"14:10:00","-","-",2,"F",2,73,null,null,null,null,null,null,107,{"$f":"SUBSTITUTE(INDEX($A:$J,R107,$S$2),\"*\",\"\")","v":"Hyung-Sung Kim"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R107,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R107,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Ryan Helminen",73,"14:30:00","-","-",2,"F",2,73,null,null,null,null,null,null,108,{"$f":"SUBSTITUTE(INDEX($A:$J,R108,$S$2),\"*\",\"\")","v":"Ryan Helminen"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R108,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R108,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","George McNeill",73,"14:45:00","-","-",2,"F",2,73,null,null,null,null,null,null,109,{"$f":"SUBSTITUTE(INDEX($A:$J,R109,$S$2),\"*\",\"\")","v":"George McNeill"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R109,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R109,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Webb Simpson",73,"07:55:00","-","-",2,"F",2,73,null,null,null,null,null,null,110,{"$f":"SUBSTITUTE(INDEX($A:$J,R110,$S$2),\"*\",\"\")","v":"Webb Simpson"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R110,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R110,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Ryan Moore",73,"08:25:00","-","-",2,"F",2,73,null,null,null,null,null,null,111,{"$f":"SUBSTITUTE(INDEX($A:$J,R111,$S$2),\"*\",\"\")","v":"Ryan Moore"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R111,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R111,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Scott Piercy",73,"08:30:00","-","-",2,"F",2,73,null,null,null,null,null,null,112,{"$f":"SUBSTITUTE(INDEX($A:$J,R112,$S$2),\"*\",\"\")","v":"Scott Piercy"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R112,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R112,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Branden Grace",73,"08:40:00","-","-",2,"F",2,73,null,null,null,null,null,null,113,{"$f":"SUBSTITUTE(INDEX($A:$J,R113,$S$2),\"*\",\"\")","v":"Branden Grace"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R113,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R113,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T93","Tommy Fleetwood",73,"09:00:00","-","-",2,"F",2,73,null,null,null,null,null,null,114,{"$f":"SUBSTITUTE(INDEX($A:$J,R114,$S$2),\"*\",\"\")","v":"Tommy Fleetwood"},2,{"$f":"IF(ISERROR(INDEX($A:$J,R114,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R114,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Koumei Oda",74,"12:45:00","-","-",3,"F",3,74,null,null,null,null,null,null,115,{"$f":"SUBSTITUTE(INDEX($A:$J,R115,$S$2),\"*\",\"\")","v":"Koumei Oda"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R115,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R115,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Jamie Broce",74,"13:00:00","-","-",3,"F",3,74,null,null,null,null,null,null,116,{"$f":"SUBSTITUTE(INDEX($A:$J,R116,$S$2),\"*\",\"\")","v":"Jamie Broce"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R116,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R116,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Rich Beem",74,"13:40:00","-","-",3,"F",3,74,null,null,null,null,null,null,117,{"$f":"SUBSTITUTE(INDEX($A:$J,R117,$S$2),\"*\",\"\")","v":"Rich Beem"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R117,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R117,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Tiger Woods",74,"13:45:00","-","-",3,"F",3,74,null,null,null,null,null,null,118,{"$f":"SUBSTITUTE(INDEX($A:$J,R118,$S$2),\"*\",\"\")","v":"Tiger Woods"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R118,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R118,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Harris English",74,"14:00:00","-","-",3,"F",3,74,null,null,null,null,null,null,119,{"$f":"SUBSTITUTE(INDEX($A:$J,R119,$S$2),\"*\",\"\")","v":"Harris English"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R119,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R119,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Eric Williamson",74,"07:45:00","-","-",3,"F",3,74,null,null,null,null,null,null,120,{"$f":"SUBSTITUTE(INDEX($A:$J,R120,$S$2),\"*\",\"\")","v":"Eric Williamson"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R120,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R120,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","David Hearn",74,"07:50:00","-","-",3,"F",3,74,null,null,null,null,null,null,121,{"$f":"SUBSTITUTE(INDEX($A:$J,R121,$S$2),\"*\",\"\")","v":"David Hearn"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R121,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R121,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Keegan Bradley",74,"08:45:00","-","-",3,"F",3,74,null,null,null,null,null,null,122,{"$f":"SUBSTITUTE(INDEX($A:$J,R122,$S$2),\"*\",\"\")","v":"Keegan Bradley"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R122,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R122,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Chris Kirk",74,"08:50:00","-","-",3,"F",3,74,null,null,null,null,null,null,123,{"$f":"SUBSTITUTE(INDEX($A:$J,R123,$S$2),\"*\",\"\")","v":"Chris Kirk"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R123,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R123,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Hideto Tanihara",74,"09:00:00","-","-",3,"F",3,74,null,null,null,null,null,null,124,{"$f":"SUBSTITUTE(INDEX($A:$J,R124,$S$2),\"*\",\"\")","v":"Hideto Tanihara"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R124,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R124,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Chesson Hadley",74,"09:10:00","-","-",3,"F",3,74,null,null,null,null,null,null,125,{"$f":"SUBSTITUTE(INDEX($A:$J,R125,$S$2),\"*\",\"\")","v":"Chesson Hadley"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R125,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R125,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Paul Casey",74,"09:15:00","-","-",3,"F",3,74,null,null,null,null,null,null,126,{"$f":"SUBSTITUTE(INDEX($A:$J,R126,$S$2),\"*\",\"\")","v":"Paul Casey"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R126,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R126,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Kevin Na",74,"09:15:00","-","-",3,"F",3,74,null,null,null,null,null,null,127,{"$f":"SUBSTITUTE(INDEX($A:$J,R127,$S$2),\"*\",\"\")","v":"Kevin Na"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R127,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R127,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Ben Martin",74,"09:20:00","-","-",3,"F",3,74,null,null,null,null,null,null,128,{"$f":"SUBSTITUTE(INDEX($A:$J,R128,$S$2),\"*\",\"\")","v":"Ben Martin"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R128,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R128,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Steven Bowditch",74,"09:25:00","-","-",3,"F",3,74,null,null,null,null,null,null,129,{"$f":"SUBSTITUTE(INDEX($A:$J,R129,$S$2),\"*\",\"\")","v":"Steven Bowditch"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R129,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R129,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Ben Crane",74,"09:25:00","-","-",3,"F",3,74,null,null,null,null,null,null,130,{"$f":"SUBSTITUTE(INDEX($A:$J,R130,$S$2),\"*\",\"\")","v":"Ben Crane"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R130,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R130,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T109","Rod Perry",74,"09:25:00","-","-",3,"F",3,74,null,null,null,null,null,null,131,{"$f":"SUBSTITUTE(INDEX($A:$J,R131,$S$2),\"*\",\"\")","v":"Rod Perry"},3,{"$f":"IF(ISERROR(INDEX($A:$J,R131,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R131,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T126","Russell Knox",75,"12:40:00","-","-",4,"F",4,75,null,null,null,null,null,null,132,{"$f":"SUBSTITUTE(INDEX($A:$J,R132,$S$2),\"*\",\"\")","v":"Russell Knox"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R132,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R132,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T126","Thomas Bjorn",75,"14:00:00","-","-",4,"F",4,75,null,null,null,null,null,null,133,{"$f":"SUBSTITUTE(INDEX($A:$J,R133,$S$2),\"*\",\"\")","v":"Thomas Bjorn"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R133,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R133,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T126","Bob Sowards",75,"07:30:00","-","-",4,"F",4,75,null,null,null,null,null,null,134,{"$f":"SUBSTITUTE(INDEX($A:$J,R134,$S$2),\"*\",\"\")","v":"Bob Sowards"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R134,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R134,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T126","Rory Sabbatini",75,"07:35:00","-","-",4,"F",4,75,null,null,null,null,null,null,135,{"$f":"SUBSTITUTE(INDEX($A:$J,R135,$S$2),\"*\",\"\")","v":"Rory Sabbatini"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R135,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R135,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T126","Stuart Deane",75,"07:50:00","-","-",4,"F",4,75,null,null,null,null,null,null,136,{"$f":"SUBSTITUTE(INDEX($A:$J,R136,$S$2),\"*\",\"\")","v":"Stuart Deane"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R136,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R136,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T126","John Senden",75,"08:10:00","-","-",4,"F",4,75,null,null,null,null,null,null,{"$f":"R136+1","v":137},{"$f":"SUBSTITUTE(INDEX($A:$J,R137,$S$2),\"*\",\"\")","v":"John Senden"},{"$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":4},{"$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":"F"}]
[null,"T126","Y.E. Yang",75,"08:45:00","-","-",4,"F",4,75,null,null,null,null,null,null,138,{"$f":"SUBSTITUTE(INDEX($A:$J,R138,$S$2),\"*\",\"\")","v":"Y.E. Yang"},4,{"$f":"IF(ISERROR(INDEX($A:$J,R138,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R138,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T133","John Daly",76,"13:40:00","-","-",5,"F",5,76,null,null,null,null,null,null,139,{"$f":"SUBSTITUTE(INDEX($A:$J,R139,$S$2),\"*\",\"\")","v":"John Daly"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R139,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R139,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T133","Rob Corcoran",76,"14:40:00","-","-",5,"F",5,76,null,null,null,null,null,null,140,{"$f":"SUBSTITUTE(INDEX($A:$J,R140,$S$2),\"*\",\"\")","v":"Rob Corcoran"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R140,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R140,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T133","Will MacKenzie",76,"09:10:00","-","-",5,"F",5,76,null,null,null,null,null,null,141,{"$f":"SUBSTITUTE(INDEX($A:$J,R141,$S$2),\"*\",\"\")","v":"Will MacKenzie"},5,{"$f":"IF(ISERROR(INDEX($A:$J,R141,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R141,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T136","Michael Block",77,"13:05:00","-","-",6,"F",6,77,null,null,null,null,null,null,142,{"$f":"SUBSTITUTE(INDEX($A:$J,R142,$S$2),\"*\",\"\")","v":"Michael Block"},6,{"$f":"IF(ISERROR(INDEX($A:$J,R142,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R142,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T136","David McNabb",77,"14:35:00","-","-",6,"F",6,77,null,null,null,null,null,null,143,{"$f":"SUBSTITUTE(INDEX($A:$J,R143,$S$2),\"*\",\"\")","v":"David McNabb"},6,{"$f":"IF(ISERROR(INDEX($A:$J,R143,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R143,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T138","Brian Norman",78,"12:40:00","-","-",7,"F",7,78,null,null,null,null,null,null,144,{"$f":"SUBSTITUTE(INDEX($A:$J,R144,$S$2),\"*\",\"\")","v":"Brian Norman"},7,{"$f":"IF(ISERROR(INDEX($A:$J,R144,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R144,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T138","Mark Brooks",78,"13:40:00","-","-",7,"F",7,78,null,null,null,null,null,null,145,{"$f":"SUBSTITUTE(INDEX($A:$J,R145,$S$2),\"*\",\"\")","v":"Mark Brooks"},7,{"$f":"IF(ISERROR(INDEX($A:$J,R145,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R145,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T138","John Huh",78,"14:15:00","-","-",7,"F",7,78,null,null,null,null,null,null,146,{"$f":"SUBSTITUTE(INDEX($A:$J,R146,$S$2),\"*\",\"\")","v":"John Huh"},7,{"$f":"IF(ISERROR(INDEX($A:$J,R146,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R146,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T138","Jason Kokrak",78,"14:20:00","-","-",7,"F",7,78,null,null,null,null,null,null,147,{"$f":"SUBSTITUTE(INDEX($A:$J,R147,$S$2),\"*\",\"\")","v":"Jason Kokrak"},7,{"$f":"IF(ISERROR(INDEX($A:$J,R147,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R147,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T138","Johan Kok",78,"09:20:00","-","-",7,"F",7,78,null,null,null,null,null,null,148,{"$f":"SUBSTITUTE(INDEX($A:$J,R148,$S$2),\"*\",\"\")","v":"Johan Kok"},7,{"$f":"IF(ISERROR(INDEX($A:$J,R148,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R148,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T143","Pablo Larrazabal",79,"13:10:00","-","-",8,"F",8,79,null,null,null,null,null,null,149,{"$f":"SUBSTITUTE(INDEX($A:$J,R149,$S$2),\"*\",\"\")","v":"Pablo Larrazabal"},8,{"$f":"IF(ISERROR(INDEX($A:$J,R149,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R149,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T143","Matt Pesta",79,"07:35:00","-","-",8,"F",8,79,null,null,null,null,null,null,150,{"$f":"SUBSTITUTE(INDEX($A:$J,R150,$S$2),\"*\",\"\")","v":"Matt Pesta"},8,{"$f":"IF(ISERROR(INDEX($A:$J,R150,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R150,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T143","Dave Tentis",79,"08:00:00","-","-",8,"F",8,79,null,null,null,null,null,null,151,{"$f":"SUBSTITUTE(INDEX($A:$J,R151,$S$2),\"*\",\"\")","v":"Dave Tentis"},8,{"$f":"IF(ISERROR(INDEX($A:$J,R151,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R151,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T143","Darren Clarke",79,"09:05:00","-","-",8,"F",8,79,null,null,null,null,null,null,152,{"$f":"SUBSTITUTE(INDEX($A:$J,R152,$S$2),\"*\",\"\")","v":"Darren Clarke"},8,{"$f":"IF(ISERROR(INDEX($A:$J,R152,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R152,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T147","Boo Weekley",80,"14:25:00","-","-",9,"F",9,80,null,null,null,null,null,null,153,{"$f":"SUBSTITUTE(INDEX($A:$J,R153,$S$2),\"*\",\"\")","v":"Boo Weekley"},9,{"$f":"IF(ISERROR(INDEX($A:$J,R153,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R153,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T147","Jerry Smith",80,"14:45:00","-","-",9,"F",9,80,null,null,null,null,null,null,154,{"$f":"SUBSTITUTE(INDEX($A:$J,R154,$S$2),\"*\",\"\")","v":"Jerry Smith"},9,{"$f":"IF(ISERROR(INDEX($A:$J,R154,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R154,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T147","Matteo Manassero",80,"07:45:00","-","-",9,"F",9,80,null,null,null,null,null,null,155,{"$f":"SUBSTITUTE(INDEX($A:$J,R155,$S$2),\"*\",\"\")","v":"Matteo Manassero"},9,{"$f":"IF(ISERROR(INDEX($A:$J,R155,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R155,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T150","Dustin Volk",81,"07:40:00","-","-",10,"F",10,81,null,null,null,null,null,null,156,{"$f":"SUBSTITUTE(INDEX($A:$J,R156,$S$2),\"*\",\"\")","v":"Dustin Volk"},10,{"$f":"IF(ISERROR(INDEX($A:$J,R156,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R156,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T150","David Hronek",81,"09:35:00","-","-",10,"F",10,81,null,null,null,null,null,null,157,{"$f":"SUBSTITUTE(INDEX($A:$J,R157,$S$2),\"*\",\"\")","v":"David Hronek"},10,{"$f":"IF(ISERROR(INDEX($A:$J,R157,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R157,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,152,"Angel Cabrera",82,"12:55:00","-","-",11,"F",11,82,null,null,null,null,null,null,158,{"$f":"SUBSTITUTE(INDEX($A:$J,R158,$S$2),\"*\",\"\")","v":"Angel Cabrera"},11,{"$f":"IF(ISERROR(INDEX($A:$J,R158,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R158,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T153","Frank Esposito",83,"12:45:00","-","-",12,"F",12,83,null,null,null,null,null,null,159,{"$f":"SUBSTITUTE(INDEX($A:$J,R159,$S$2),\"*\",\"\")","v":"Frank Esposito"},12,{"$f":"IF(ISERROR(INDEX($A:$J,R159,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R159,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"T153","Jim McGovern",83,"09:30:00","-","-",12,"F",12,83,null,null,null,null,null,null,160,{"$f":"SUBSTITUTE(INDEX($A:$J,R160,$S$2),\"*\",\"\")","v":"Jim McGovern"},12,{"$f":"IF(ISERROR(INDEX($A:$J,R160,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R160,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,155,"Aaron Krueger",84,"12:50:00","-","-",13,"F",13,84,null,null,null,null,null,null,161,{"$f":"SUBSTITUTE(INDEX($A:$J,R161,$S$2),\"*\",\"\")","v":"Aaron Krueger"},13,{"$f":"IF(ISERROR(INDEX($A:$J,R161,$U$2)+TIME(5,0,0)),\"\",INDEX($A:$J,R161,$U$2)+TIME(5,0,0))","v":""},"F"]
[null,"WD","Jason Dufner","WD","WD","WD","WD","WD","-","WD","WD",null,null,null,null,null,null,162,{"$f":"SUBSTITUTE(INDEX($A:$J,R162,$S$2),\"*\",\"\")","v":"Jason Dufner"},"WD",{"$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":-4},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+3)","v":-4.0439999999999996},{"$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":-7},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+3)","v":-7.0339999999999998},3,{"$f":"IF(ISERROR(RANK(E5,$E$4:$E$14,1)),\"\",RANK(E5,$E$4:$E$14,1))","v":4},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":-9},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+3)","v":-9.048},1,1,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":-8},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+3)","v":-8.0459999999999994},2,2,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":-5},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+3)","v":-5.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":-7},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+3)","v":-7.0380000000000003},3,3,null,null,"JOHN C",-5,-5.03,5,5]
[{"$f":"A9+9","v":19},7,{"$f":"INDEX(results!$A$7:$Q$42,$A10,$B10)","v":"STUART D"},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+2)","v":-1},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+3)","v":-1.04},7,7,null,null,"DEANO",-4,-4.0439999999999996,6,6]
[{"$f":"A10+9","v":28},7,{"$f":"INDEX(results!$A$7:$Q$42,$A11,$B11)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+3)","v":""},"","",null,null,"STUART D",-1,-1.04,7,7]
[1,13,{"$f":"INDEX(results!$A$7:$Q$42,$A12,$B12)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A12+6,$B12+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A12+6,$B12+3)","v":""},"",""]
[10,13,{"$f":"INDEX(results!$A$7:$Q$42,$A13,$B13)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A13+6,$B13+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A13+6,$B13+3)","v":""},"",""]
[19,{"$f":"B9+6","v":13},{"$f":"INDEX(results!$A$7:$Q$42,$A14,$B14)","v":0},{"$f":"INDEX(results!$A$7:$Q$42,$A14+6,$B14+2)","v":""},{"$f":"INDEX(results!$A$7:$Q$42,$A14+6,$B14+3)","v":""},"",""]
[]
[]
[]
[null,null,"Put sorted scores here for posting to website"]
[]
[null,7,"Player","Score","Score adj","Rank","Rank adj"]
[null,13,"BYRON",-9,-9.048,1,1]
[null,1,"STEVER",-8,-8.0459999999999994,2,2]
[null,1,"CRAIG T",-7,-7.0380000000000003,3,3]
[null,1,"TEZ",-7,-7.0339999999999998,3,4]
[null,13,"JOHN C",-5,-5.03,5,5]
[null,7,"DEANO",-4,-4.0439999999999996,6,6]
[null,1,"STUART D",-1,-1.04,7,7]
[null,7]
[null,7]
[null,13,"Dean","","","",""]
[null,null,"Shem","","","",""]
[]
[]
[]
[]
[]
[]
[null,null,"Average scores of picks","Avg","Rank"]
[null,null,"Pick 1",{"$f":"AVERAGE(results!C8,results!C17,results!C26,results!C35,results!I8,results!I17,results!I26,results!I35,results!O8,results!O17,results!O26,results!O35)","v":{"$error":"#REF!"}},{"$f":"RANK(D39,$D$39:$D$43,1)","v":{"$error":"#REF!"}}]
[null,null,"Pick 2",{"$f":"AVERAGE(results!C9,results!C18,results!C27,results!C36,results!I9,results!I18,results!I27,results!I36,results!O9,results!O18,results!O27,results!O36)","v":{"$error":"#N/A"}},{"$f":"RANK(D40,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[null,null,"Pick 3",{"$f":"AVERAGE(results!C10,results!C19,results!C28,results!C37,results!I10,results!I19,results!I28,results!I37,results!O10,results!O19,results!O28,results!O37)","v":{"$error":"#N/A"}},{"$f":"RANK(D41,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[null,null,"Pick 4",{"$f":"AVERAGE(results!C11,results!C20,results!C29,results!C38,results!I11,results!I20,results!I29,results!I38,results!O11,results!O20,results!O29,results!O38)","v":{"$error":"#N/A"}},{"$f":"RANK(D42,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[null,null,"Pick 5",{"$f":"AVERAGE(results!C12,results!C21,results!C30,results!C39,results!I12,results!I21,results!I30,results!I39,results!O12,results!O21,results!O30,results!O39)","v":{"$error":"#N/A"}},{"$f":"RANK(D43,$D$39:$D$43,1)","v":{"$error":"#N/A"}}]
[]
[null,null,"NEEDS UPDATING"]

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

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

{"sheet":"random picks","index":5,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DEANO","TEZ","BYRON","STEVER","JOHN C","CRAIG T","STUART D"]
["Random number generator for pick order"]
["R1",{"$f":"RAND()","v":0.81604331440017008},0.49938454404621757,7.4143300464672102E-2,9.8525983387066307E-2,7.5470741850102163E-3,0.33395522546633116,9.9801194370994217E-2,0.23263414483233591,0.24078592712113078,0.38975007341378842]
["R2",1.9507614284784536E-2,0.98664206920194897,0.21160839834031975,0.34729408689740948,0.39362902420848001,0.93780618151093398,0.75732187584972765,0.7136933759623203,0.4583970718768936,0.47653039673117803]
["R3",0.6633546634349391,0.44782851338039897,0.60195526783728937,0.12671771499257822,0.96715133187780422,0.43439615208760107,0.55076543571975223,0.98943021737284698,0.37939357590407075,0.42966226131281793]
["R4",0.71635418540114004,0.64943138728710614,0.43006420044829541,0.49166907241691649,6.25073312657628E-2,0.63284908718660138,0.44851817161138718,0.13233264649727938,0.40010799945533471,0.24254845008297776]
["R5",0.46609542083958944,0.96413940179142299,0.46163828033489041,0.75055908408581429,0.3666798864322327,0.1852231049983466,8.9708084279832567E-3,0.67962506771733466,0.8410652103377475,0.79497739268351986]
["R1",{"$f":"RANK(B4,$B4:$L4)","v":1},2,9,8,10,4,7,6,5,3]
["R2",{"$f":"RANK(B5,$B5:$L5)","v":10},1,9,8,7,2,3,4,6,5]
["R3",{"$f":"RANK(B6,$B6:$L6)","v":3},6,4,10,2,7,5,1,9,8]
["R4",{"$f":"RANK(B7,$B7:$L7)","v":1},2,6,4,10,3,5,9,7,8]
["R5",{"$f":"RANK(B8,$B8:$L8)","v":6},1,7,4,8,9,10,5,2,3]
[]
["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.59117780447726942},0.4066459272604388,0.75912190941058966,7.9829379962983116E-2,0.60537371729190037,0.77566382287901181,0.22283160551391346,0.2533419381165426,0.24579577655688123,0.20063144345299999,0.66454527743904934]
["R2",0.84305638957118245,0.24290378767505483,0.51884561901886084,0.27800985071051265,0.35575701610919885,0.3811095281221244,0.56528927435364351,9.0178991445588608E-3,0.23863534239403472,0.3909933559700095,0.92830384545091127]
["R3",5.711561393866782E-2,7.6105767393687129E-3,0.78431335082966636,0.56438818343736308,0.58257210919840052,0.26934522750903123,0.79935155466650598,6.0494244430834621E-2,8.2926231208398926E-3,0.1031829589687735,0.48503530354795177]
["R4",0.35480764704251178,0.99022400066723115,0.68410431324790388,0.47575054662983662,0.30128776494749121,0.96544472728543351,0.35233443026615185,1.5228973442998561E-2,9.1163205752843313E-2,0.59248557502513544,0.21480525290935226]
["R5",0.87412373920429043,0.2119357391580956,0.18430044834285098,0.64302037182999838,0.19499009283282565,0.6977709461350502,0.40514875113767479,0.43360253896586365,0.88547889935189084,8.2585041655288127E-2,0.60300062559792722]
["R1",{"$f":"RANK(B23,$B23:$L23)","v":5},6,2,11,4,1,9,7,8,{"$f":"RANK(K23,$B23:$L23)","v":10},3]
["R2",{"$f":"RANK(B24,$B24:$L24)","v":2},9,4,8,7,6,3,11,10,{"$f":"RANK(K24,$B24:$L24)","v":5},1]
["R3",{"$f":"RANK(B25,$B25:$L25)","v":9},11,2,4,3,6,1,8,10,{"$f":"RANK(K25,$B25:$L25)","v":7},5]
["R4",{"$f":"RANK(B26,$B26:$L26)","v":6},1,3,5,8,2,7,11,10,{"$f":"RANK(K26,$B26:$L26)","v":4},9]
["R5",{"$f":"RANK(B27,$B27:$L27)","v":2},8,10,4,9,3,7,6,1,{"$f":"RANK(K27,$B27:$L27)","v":11},5]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0,0,0,0,0]
["R1",0.33359727099365966,0.45668238778738524,0.61740648902467077,0.22779640510355548,0.62736326280927379,0.61481337020834548,0.38286172780295369,0.27531526805227946,0.34545208426910823,0.98098219143842458,0.39956056964178532,3.1502515173200019E-2]
["R2",0.43647171460544221,0.16828449986200311,0.80148922841208592,0.22934103129454797,0.29165388744407406,0.78579017580576604,3.0469934868212034E-2,0.44687246502774558,0.91957764667402353,0.92898147434432188,0.71060663934588675,0.69672792909485459]
["R3",0.40742883805990804,0.32147459673382139,0.43082187013957296,0.70067660449530389,0.82713811371837154,0.64893801243286331,6.1934563960440392E-2,0.66504068356338886,0.60377080220242485,0.33508534494457598,0.64321628227622363,2.4467001613299622E-2]
["R4",0.3082879889395459,0.80957323377303991,0.30037827026323172,0.70958235708044626,0.8612579196233453,0.34856465818471094,0.44479240741266757,4.3807745634395823E-2,0.28997624295667801,0.94048910153547394,0.47532646222549968,7.8949549410021191E-3]
["R5",0.70171196535525104,0.532631966419296,0.76266858976734719,0.84380990658275723,0.20207438164085978,0.71339414829676362,0.56797505630389922,0.73824499731459325,0.59066083080087672,0.55470921181476862,0.9355444065760411,0.27273994926289624]
["R1",{"$f":"RANK(B34,$B34:$M34)","v":9},5,3,11,2,4,7,10,8,{"$f":"RANK(K34,$B34:$M34)","v":1},6,12]
["R2",{"$f":"RANK(B35,$B35:$M35)","v":8},11,3,10,9,4,12,7,2,{"$f":"RANK(K35,$B35:$M35)","v":1},5,6]
["R3",{"$f":"RANK(B36,$B36:$M36)","v":8},10,7,2,1,4,11,3,6,{"$f":"RANK(K36,$B36:$M36)","v":9},5,12]
["R4",{"$f":"RANK(B37,$B37:$M37)","v":8},3,9,4,2,7,6,11,10,{"$f":"RANK(K37,$B37:$M37)","v":1},5,12]
["R5",{"$f":"RANK(B38,$B38:$M38)","v":6},10,3,2,12,5,8,4,7,{"$f":"RANK(K38,$B38:$M38)","v":9},1,11]
[]
[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.14631639859209977},0.95184266019869768,0.90970320825765028,0.46805735282207506,0.85328148719972197,0.79371158717660728,0.87493228465222816,0.85465709510192123,0.25387941790930102,2.1584997158004993E-2,0.63438717245407739,0.20370376740668361,0.36320402632198134]
["R2",0.18052710908887482,0.29359865476008773,0.46174075462045161,0.6078435429740715,0.88122061941083574,0.87259647246513294,0.94424983594276501,0.67939973950473831,0.31296330453941446,0.59102789537845313,0.63083059479480963,7.8710123229292828E-2,0.62299899850433771]
["R3",0.2191078741910395,0.51967832911597966,0.55499322901060166,0.99775024002426072,0.61949101463674694,0.21831075633359265,0.76310956878666902,0.56246581897087344,0.20273745847909208,0.16078921049163097,0.4081333414376308,0.16626124499923467,0.16882460662932719]
["R4",4.0509159253327098E-2,0.61379975910375562,0.36401340888386891,0.72776678164757092,0.89269915136649192,0.65036594671578773,0.58118012876256686,0.18504817071658686,0.9058417691536722,9.0527997763630297E-2,5.6856499332307187E-2,0.84243642402699193,0.88508219403983923]
["R5",0.88103848877941116,0.75931203816502646,0.80214625372480441,0.66570697262073353,0.87433142881639425,8.9368957375846381E-2,0.84230097741989773,0.93973338401820994,0.69269116362778826,0.17135105696543074,0.35809370703873866,0.11746643534545365,9.2485233294325231E-2]
["R1",{"$f":"RANK(B46,$B46:$N46)","v":12},1,2,8,5,6,3,4,10,{"$f":"RANK(K46,$B46:$N46)","v":13},7,11,9]
["R2",{"$f":"RANK(B47,$B47:$N47)","v":12},11,9,7,2,3,1,4,10,{"$f":"RANK(K47,$B47:$N47)","v":8},5,13,6]
["R3",{"$f":"RANK(B48,$B48:$N48)","v":8},6,5,1,3,9,2,4,10,{"$f":"RANK(K48,$B48:$N48)","v":13},7,12,11]
["R4",{"$f":"RANK(B49,$B49:$N49)","v":13},7,9,5,2,6,8,10,1,{"$f":"RANK(K49,$B49:$N49)","v":11},12,4,3]
["R5",{"$f":"RANK(B50,$B50:$N50)","v":2},6,5,8,3,13,4,1,7,{"$f":"RANK(K50,$B50:$N50)","v":10},9,11,12]
[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.55085913241600182,0.9733816792705241,0.64251092572458846,0.11409899829819492,0.40528012528626678,0.84286978913335875,0.74167812658394772,0.46541299010240433,0.32359304452198945,0.65238477445282039,0.56672111132318115,2.6484630660691622E-2,0.69460044941631915,0.8120735307075081]
["R2",0.42828392598294973,0.19152705464159836,0.84231904567420379,0.56910300074678499,0.61068626406577309,0.81337560175300982,0.17438288952331638,0.71343074388139549,0.30966432062035287,0.90314683789683481,0.78354696804310575,0.57594809489156373,0.58009849292004401,0.11055293459690996]
["R3",0.7316260140672971,0.96154802274385964,0.33690538927802849,0.11837591082005383,0.31169399576124779,0.55483027597383638,8.9198694305574477E-2,0.6966352294354734,0.53481966186853525,0.1589086888960094,0.73488821547741889,0.56325352783869054,0.67380054275684731,0.7547025322603903]
["R4",0.35077134440581004,0.69346367206076109,0.92195849498292282,0.6939397641709385,0.18515318667522207,4.276535373801682E-4,0.12730621972721179,0.41047459901965622,0.9771512117115273,0.18988856301083445,0.5191323243253757,0.41561093709994212,0.11231195430566865,0.38470418098525738]
["R5",0.4533462301334118,0.53409911258125464,0.7134853187066873,0.28443659308594771,0.13324986220603818,0.89883411779361577,0.72758621181635497,0.46014761654337366,0.17922314382766635,0.97615571016424862,0.72370648456705089,0.73889525862224426,0.14690474498873174,0.52912709327102903]
["R1",{"$f":"RANK(B57,$B57:$O57)","v":9},1,7,13,11,2,4,10,12,{"$f":"RANK(K57,$B57:$O57)","v":6},8,14,5,3]
["R2",{"$f":"RANK(B58,$B58:$O58)","v":10},12,2,9,6,3,13,5,11,{"$f":"RANK(K58,$B58:$O58)","v":1},4,8,7,14]
["R3",{"$f":"RANK(B59,$B59:$O59)","v":4},1,10,13,11,8,14,5,9,{"$f":"RANK(K59,$B59:$O59)","v":12},3,7,6,2]
["R4",{"$f":"RANK(B60,$B60:$O60)","v":9},4,2,3,11,14,12,7,1,{"$f":"RANK(K60,$B60:$O60)","v":10},5,6,13,8]
["R5",{"$f":"RANK(B61,$B61:$O61)","v":10},7,6,11,14,2,4,9,12,{"$f":"RANK(K61,$B61:$O61)","v":1},5,3,13,8]
[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.27780496208817373},0.29988390784606855,0.52102431551829964,3.4415961701733E-2,0.95989102436224183,0.70372889307079423,0.56402890245630721,0.96557858632656324,0.99764525359037115,0.27240594120407391,0.11311051977723163,0.48498060442149493,0.54039005590187106,0.33893204467103943,0.47597668548051519]
["R2",0.96546598624965319,0.3173497227277341,3.6712558471189261E-2,0.10717214261050412,8.5171268043034432E-2,0.95667322154418966,0.39230146141360467,0.43199541864368107,0.85982345915350022,0.22143122926729297,0.92656648797090391,0.92838296498250783,0.26156734793795067,0.61810002385176244,0.53196344590246136]
["R3",0.49165967089134321,0.56825676212449916,0.82690763368926967,0.96205056178504988,0.29011280260339645,0.29391878808809402,0.72665723567714902,0.27685635364193506,0.63725634598547631,0.54401404752772176,0.58108909454613089,0.73936928420832626,0.89043713741872377,0.7311036559117583,0.35685253083616886]
["R4",0.72750790074623695,0.61593178976041818,0.91162983231444983,0.85165390344679825,0.17816249436788334,0.48347991588057604,0.65213236472904501,0.99211822207854028,0.67360800747736349,0.9041837587560837,0.41838991483887544,0.91189100391977163,0.81537442301940743,6.2827021369313507E-2,0.59799272436137163]
["R5",0.70164044903045919,0.90236700764210231,0.28801712732876084,0.39026065493233741,0.33255197329786579,8.6469083090939147E-2,0.40107774943594321,0.75928446257251481,0.39120547332825328,0.5897592775260404,0.7869839430643516,0.4827857809695264,0.33800384570692255,0.3346087552170931,7.424021251109636E-2]
["R1",{"$f":"RANK(B68,$B68:$P68)","v":12},11,7,15,3,4,5,2,1,{"$f":"RANK(K68,$B68:$P68)","v":13},14,8,6,10,9]
["R2",{"$f":"RANK(B69,$B69:$P69)","v":1},10,15,13,14,2,9,8,5,{"$f":"RANK(K69,$B69:$P69)","v":12},4,3,11,6,7]
["R3",{"$f":"RANK(B70,$B70:$P70)","v":11},9,3,1,14,13,6,15,7,{"$f":"RANK(K70,$B70:$P70)","v":10},8,4,2,5,12]
["R4",{"$f":"RANK(B71,$B71:$P71)","v":7},10,3,5,14,12,9,1,8,{"$f":"RANK(K71,$B71:$P71)","v":4},13,2,6,15,11]
["R5",{"$f":"RANK(B72,$B72:$P72)","v":4},1,13,9,12,14,7,3,8,{"$f":"RANK(K72,$B72:$P72)","v":5},2,6,10,11,15]
[null,{"$f":"B2","v":"DEANO"},{"$f":"C2","v":"TEZ"},"BYRON","STEVER","JOHN C","CRAIG T","STUART D",0]
["R1",{"$f":"RAND()","v":0.32471171800663423},{"$f":"RAND()","v":0.23579126995617339},0.97318572459266006,0.53300837400295065,0.36133913688403163,0.97930699769017471,0.17785640522766299,0.21313555201672008]
["R2",0.53683466117601764,0.72473836984531059,0.58347947044063275,0.47321911323316979,0.12622868832262402,0.63128382785356485,0.7267222862583137,0.53554073369131638]
["R3",0.81133917912377718,9.0660592812976448E-2,0.19071377061286454,0.15510850258125497,0.65397894211146457,0.87175707096565747,0.12123765726728486,0.36943052396519704]
["R4",0.50201095692642517,0.54076081200800852,0.20060718356510931,0.11677195632145565,0.31175573986497995,0.72406903818213941,0.15990822059328003,0.31850793495092844]
["R5",7.2425537217377767E-2,0.48619900950093664,0.51937560691966822,0.23044075696786148,0.92350547611049694,0.5383734827279949,0.11969476153587055,0.76167959058775614]
["R1",{"$f":"RANK(B79,$B79:$L79)","v":5},6,2,3,4,1,8,7]
["R2",5,2,4,7,8,3,1,6]
["R3",2,8,5,6,3,1,7,4]
["R4",3,2,6,8,5,1,7,4]
["R5",8,5,4,6,1,3,7,2]
[]
["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.53946209607693019},{"$f":"RAND()","v":3.6496160462233029E-2},0.41534908716043351,0.35203170775973047,0.61593196918632243,0.85165979873375919,0.59755499333396345]
[null,0.81339428313000273,0.29157883343600999,0.38236191057338353,1.4504483955800063E-2,0.18607069688024969,0.31998773312005457,0.90188133426325201]
[null,0.43656805729491832,0.16208244255379012,0.24441543679311806,0.74152049693596811,0.33351468751898805,0.40879650974237769,0.95356807945943545]
[null,4.6764901285617499E-2,0.14306072521505309,4.9504155900576774E-2,0.72364560734692518,4.2504630676881927E-2,0.80034368095021058,0.95765727880570206]
[null,0.64876070881594994,0.87438947924201527,0.86641403229698433,0.29959352688948448,0.62789542157235556,0.54935830719718204,0.16277942746945817]
[null,{"$f":"RANK(B100,$B100:$L100)","v":4},7,5,6,2,1,3]
[null,{"$f":"RANK(B101,$B101:$L101)","v":2},5,3,7,6,4,1]
[null,{"$f":"RANK(B102,$B102:$L102)","v":3},7,6,2,5,4,1]
[null,{"$f":"RANK(B103,$B103:$L103)","v":6},4,5,3,7,2,1]
[null,{"$f":"RANK(B104,$B104:$L104)","v":3},1,2,6,4,5,7]

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