{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["random picks","Round order","BLANKS","ranks","PAYERS","webquery","results"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":"random picks","index":0,"n_rows":123,"n_cols":16,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
[null,"BYRON","JOHN C","MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D"]
["Random number generator for pick order"]
[null,{"$f":"B2","v":"BYRON"},{"$f":"C2","v":"JOHN C"},"MIKE H","STEVER","ROB W","CRAIG T"]
["R1",{"$f":"RAND()","v":5.7027286426887924E-2},{"$f":"RAND()","v":0.49557442143080788},8.9197954528915546E-2,0.11364680814245487,0.51152065806160452,0.7834757027307665]
["R2",0.94565760195798232,0.19090242551011505,0.95725475048065822,0.32558669924599004,0.23067182839559652,0.72716298442425364]
["R3",0.93011750378535574,0.26947478098132016,0.60693776664342447,4.2320980677485576E-2,0.84979374091595494,0.73588405309039584]
["R4",0.71599100253640502,0.762545996017298,0.86884014141221555,0.3622970143500327,0.34551452924102877,0.18847321706892139]
["R5",0.85733884196695487,0.65081961078984618,0.25967648433889778,0.66896883956956255,0.81955937659981082,9.356991616444299E-2]
["R1",{"$f":"RANK(B5,$B5:$L5)","v":6},3,5,4,2,1]
["R2",2,6,1,4,5,3]
["R3",1,5,4,6,2,3]
["R4",3,2,1,4,5,6]
["R5",1,4,5,3,2,6]
[null,{"$f":"B2","v":"BYRON"},{"$f":"C2","v":"JOHN C"},"MIKE H","STEVER","ROB W","CRAIG T","ANDY W"]
["R1",{"$f":"RAND()","v":0.15625351176705848},{"$f":"RAND()","v":0.18968580582833461},0.15974154488540981,0.28367441835609386,0.59978023027853189,0.19965427945693826,0.78114823242470399]
["R2",0.18684933434687023,6.8115185037822212E-2,4.7045801132802434E-2,7.7393147029528819E-2,0.33105222634079168,0.30174278547646438,0.94961107250647114]
["R3",0.23524610717979222,0.56425537310460105,0.37101271783437173,0.56427733225142818,0.60145623390783898,0.90034477283942294,0.21935335859208449]
["R4",0.41437190418454539,0.60940248371990935,0.11566133683050006,0.71483124591857472,0.27979409921112408,0.15872731747797764,0.84162978441555336]
["R5",0.55604734659407584,0.37839184702240725,0.64136597069742018,0.40667421095717671,0.72519420736715468,0.51948860174125566,0.2186203486326892]
["R1",{"$f":"RANK(B16,$B16:$L16)","v":7},5,6,3,2,4,1]
["R2",4,6,7,5,2,3,1]
["R3",6,4,5,3,2,1,7]
["R4",4,3,7,2,5,6,1]
["R5",3,6,2,5,1,4,7]
[null,{"$f":"B2","v":"BYRON"},{"$f":"C2","v":"JOHN C"},"MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D"]
["R1",{"$f":"RAND()","v":0.13521125540247692},{"$f":"RAND()","v":0.31564629789576448},0.70979471260817062,0.95738990380493205,0.46775341576136176,0.84742909432070002,0.79426542593302263,0.602025420406331]
["R2",0.80714187570079632,0.1783054632235288,0.26790858756885649,0.30053582409180213,2.2174130932210545E-2,0.47120637222926309,0.95025693560238633,0.44111534830764154]
["R3",0.26897687214456545,0.95468066718659494,0.38364052971765605,0.59083717132447555,0.57793289787661994,4.881510444492021E-2,0.82280842493710427,0.32441921546394226]
["R4",0.26736973769957084,0.24872940754953576,0.78951146941927308,0.9988834948621208,0.80605779036055047,0.48474930586808096,0.35753691720578629,0.21460150134488853]
["R5",0.93160283507433284,0.32453052477335698,0.75488007433036219,5.9416713497355778E-2,0.41950338724528491,0.88607215449598786,4.5509553977471917E-2,0.84640387939582062]
["R1",{"$f":"RANK(B27,$B27:$L27)","v":8},7,4,1,6,2,3,{"$f":"RANK(I27,$B27:$L27)","v":5}]
["R2",2,7,6,5,8,3,1,4]
["R3",7,1,5,3,4,8,2,6]
["R4",6,7,3,1,2,4,5,8]
["R5",1,6,4,7,5,2,8,3]
[null,{"$f":"B2","v":"BYRON"},{"$f":"C2","v":"JOHN C"},"MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0]
["R1",{"$f":"RAND()","v":0.58522106217955772},0.24276828885900403,0.48543174511458598,0.82099853358186126,0.46253497028342927,0.55040793960780565,0.42381077026615399,0.93692999615798789,0.60341209538599705]
["R2",0.54312794929459851,0.96070213326721876,0.51364052956035311,0.19669353706392245,0.51705951860860278,0.44617628550832744,0.60768143236781069,0.11580043053595368,0.63842511532927004]
["R3",0.17805762030404937,0.82802190638343409,0.88244185888134641,0.45128851760664179,0.57809293736920797,0.13194359821946011,0.76201135914622387,0.32166378207449997,2.5071116213304934E-2]
["R4",0.45826770604210343,0.92792663854052726,0.70097002352490156,0.33610858910890073,0.23420766662615344,0.21971201735310564,0.76046107322667111,0.25002394803800654,4.4839891575646718E-2]
["R5",0.6680761730659116,0.51833941431424502,0.93980097570421572,0.55005676670297188,0.65486575056372565,0.20169031067236143,0.21217187635844614,0.80489649528593687,8.0615780939045201E-2]
["R1",{"$f":"RANK(B38,$B38:$L38)","v":4},9,6,2,7,5,8,1,3]
["R2",{"$f":"RANK(B39,$B39:$L39)","v":4},1,6,8,5,7,3,9,2]
["R3",{"$f":"RANK(B40,$B40:$L40)","v":7},2,1,5,4,8,3,6,9]
["R4",{"$f":"RANK(B41,$B41:$L41)","v":4},1,3,5,7,8,2,6,9]
["R5",{"$f":"RANK(B42,$B42:$L42)","v":3},6,1,5,4,8,7,2,9]
[null,{"$f":"B2","v":"BYRON"},{"$f":"C2","v":"JOHN C"},"MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0,{"$f":"K2","v":0}]
["R1",{"$f":"RAND()","v":0.14278351108091847},7.9844137455341246E-2,0.52571146086375031,0.47170882274763637,0.62529523122884134,0.91836642977977789,0.55344099822225146,0.80499231557749529,4.8507870020805588E-2,0.17561321152079434]
["R2",0.4457604778311044,0.25938619573694588,0.66465380520062178,0.90524745271097806,0.40318811161703383,0.53190012236982265,0.57939140026291247,9.1749708149953979E-2,0.78810400740571906,0.77081808022645348]
["R3",0.30074500156233452,0.64500502593649256,2.6078887430660225E-2,8.5999283233007651E-2,0.89992907440781866,0.3190982229404381,0.22015829821005128,0.92218957087598397,0.86733519027194528,0.98527318271695363]
["R4",0.62796605461305099,0.30138157529121179,0.62746940594703771,0.90656356107901059,8.7777383426094979E-2,0.22824912455748703,0.56676728121776399,0.40794952280932784,1.6175238567245342E-2,0.59981074504650678]
["R5",0.48308776448188029,4.1002753584663765E-2,0.39137566667676726,0.64021223109619396,0.71772191777234495,0.37679809215310078,0.83474773964104132,0.51066578790549344,0.63581720478961856,0.38872463356715103]
["R1",{"$f":"RANK(B49,$B49:$L49)","v":8},9,5,6,3,1,4,2,10,{"$f":"RANK(K49,$B49:$L49)","v":7}]
["R2",{"$f":"RANK(B50,$B50:$L50)","v":7},9,4,1,8,6,5,10,2,{"$f":"RANK(K50,$B50:$L50)","v":3}]
["R3",{"$f":"RANK(B51,$B51:$L51)","v":7},5,10,9,3,6,8,2,4,{"$f":"RANK(K51,$B51:$L51)","v":1}]
["R4",{"$f":"RANK(B52,$B52:$L52)","v":2},7,3,1,9,8,5,6,10,{"$f":"RANK(K52,$B52:$L52)","v":4}]
["R5",{"$f":"RANK(B53,$B53:$L53)","v":6},10,7,3,2,9,1,5,4,{"$f":"RANK(K53,$B53:$L53)","v":8}]
[null,{"$f":"B2","v":"BYRON"},"JOHN C","MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0,{"$f":"K2","v":0},0]
["R1",{"$f":"RAND()","v":2.842105292313668E-2},6.2332722922762707E-2,0.71407613518925483,0.58996557581112197,0.946258712974829,0.30963809822974153,0.55063355187837892,0.75173242693739262,0.23548184100583969,0.81345755867237646,0.57956598904564283]
["R2",0.84505380526251439,0.60892407331771936,0.21424580459589815,0.33023473500084044,0.23489240344970141,0.61320551030473014,7.2316411894853716E-2,0.47912100603632657,0.72005395712559717,0.70250361923757365,0.16451154931148437]
["R3",0.79583941428731697,0.20923337366639061,0.67907792916542042,0.9754164634458582,0.7202049774249204,0.70023106918475964,0.39241934684665525,0.15257077383503737,4.868217171834055E-2,0.36895492122849027,0.95597212219395322]
["R4",0.83916908768548937,0.74234987621096959,0.58793250065640368,0.1262379881155119,0.44999189297784148,0.69639693468511876,0.88289570703527953,0.10883491991770344,0.54750626315595241,0.41987746303935047,0.25942219561366442]
["R5",0.16232045473318979,0.74952208056084979,0.38593544375528488,0.40496965434947862,0.93311538112087034,0.66704708967757453,0.60100327852958046,0.22376418536753717,0.66508614550072287,0.69776138714405778,0.80531640808713512]
["R1",{"$f":"RANK(B60,$B60:$L60)","v":11},10,4,5,1,8,7,3,9,{"$f":"RANK(K60,$B60:$L60)","v":2},6]
["R2",{"$f":"RANK(B61,$B61:$L61)","v":1},5,9,7,8,4,11,6,2,{"$f":"RANK(K61,$B61:$L61)","v":3},10]
["R3",{"$f":"RANK(B62,$B62:$L62)","v":3},9,6,1,4,5,7,10,11,{"$f":"RANK(K62,$B62:$L62)","v":8},2]
["R4",{"$f":"RANK(B63,$B63:$L63)","v":2},3,5,10,7,4,1,11,6,{"$f":"RANK(K63,$B63:$L63)","v":8},9]
["R5",{"$f":"RANK(B64,$B64:$L64)","v":11},3,9,8,1,5,7,10,6,{"$f":"RANK(K64,$B64:$L64)","v":4},2]
[null,{"$f":"B2","v":"BYRON"},"JOHN C","MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0,{"$f":"K2","v":0},0,0]
["R1",0.11740432725750394,0.6173843788353055,0.87744221023961022,0.59939056257278089,0.20649853364158777,0.19107669913032876,0.25917806215978167,0.54231156148247905,0.41294093437727275,0.27851512897649944,0.9404610515629831,0.10014767767455113]
["R2",0.62762431766812143,0.77947644125981785,0.88662792250107803,0.49694648641922123,0.78095147574491719,0.71204649106274809,0.29885700291024997,0.13434749078518005,0.26245556696948746,0.83010112831630323,0.37589185672355574,0.42233598955948892]
["R3",0.50855336465920009,0.11948189955966337,0.33989025478953649,0.83346372002428493,0.74742627809374451,0.55523455315641257,0.72400866708703249,0.47039826202425483,0.958280494229383,0.66090044185622554,0.8774188448068857,0.28320934084150018]
["R4",0.35444584482405705,0.41461996830994585,0.17306147871263478,0.9884237919264971,0.64382477201327981,0.14808354435206905,0.21578261687345568,0.13821968329169643,0.29077079228813485,0.49930775310648046,0.16311179844163159,5.1690059664702748E-2]
["R5",0.6020822247088965,0.5876393444225938,0.19480727481466797,3.9823975355776309E-2,0.50856899350325269,0.94819434816867154,0.27333823224513487,0.59034553108740495,0.16092710934531174,0.95347563942329261,0.27948631269455881,3.3010214617486322E-2]
["R1",{"$f":"RANK(B71,$B71:$M71)","v":11},3,2,4,9,10,8,5,6,{"$f":"RANK(K71,$B71:$M71)","v":7},1,12]
["R2",{"$f":"RANK(B72,$B72:$M72)","v":6},4,1,7,3,5,10,12,11,{"$f":"RANK(K72,$B72:$M72)","v":2},9,8]
["R3",{"$f":"RANK(B73,$B73:$M73)","v":8},12,10,3,4,7,5,9,1,{"$f":"RANK(K73,$B73:$M73)","v":6},2,11]
["R4",{"$f":"RANK(B74,$B74:$M74)","v":5},4,8,1,2,10,7,11,6,{"$f":"RANK(K74,$B74:$M74)","v":3},9,12]
["R5",{"$f":"RANK(B75,$B75:$M75)","v":3},5,9,11,6,2,8,4,10,{"$f":"RANK(K75,$B75:$M75)","v":1},7,12]
[]
[null,{"$f":"B2","v":"BYRON"},"JOHN C","MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0,{"$f":"K2","v":0},0,0,0]
["R1",{"$f":"RAND()","v":0.59705493873785986},0.83513596232954368,0.65670663607664848,0.82435387013794836,0.3560403930854128,0.56770054521572344,0.34676366333267539,0.35135453119372562,0.45943060653741141,0.44446601973071287,0.64835477910750483,9.6672966334106047E-2,0.3435083020930364]
["R2",0.30543594607403268,0.88053109798226314,0.83958646361176847,0.35773452799240912,0.70386686827699541,0.32335607032004565,0.98611313576351356,0.14295850077722394,0.83527783731070515,0.10962757750456276,0.64480022243270341,0.15271755475428439,0.14667236637799175]
["R3",0.27528496620091769,0.70048430684560348,0.64736846546752924,0.40621187975534723,0.22705194276151552,0.85157822536126848,0.80585443282021474,0.25678488650937348,0.67868651968864413,0.50587642348891459,4.2142560525297856E-2,0.80976626168900956,0.35475640417558696]
["R4",0.48944687210727189,0.61452576419018667,0.50802410999688186,0.32103297895184535,0.92188274851428664,0.97730694853593791,3.6344609582089626E-2,0.14336222034713841,0.12337803153343496,0.63445414281820012,0.72957321763155536,0.66749995506309412,0.80672778217099972]
["R5",0.64225287958967436,1.2787353436340076E-2,0.83564931295995892,0.57181066759543531,0.53596763885075915,0.88865309343980381,0.38051309857422988,0.43886573114626648,0.43926029001335742,0.86873154659305718,0.55048062957354371,0.2632505947589141,0.53795123135231304]
["R1",{"$f":"RANK(B83,$B83:$N83)","v":5},1,3,2,9,6,11,10,7,{"$f":"RANK(K83,$B83:$N83)","v":8},4,13,12]
["R2",{"$f":"RANK(B84,$B84:$N84)","v":9},2,3,7,5,8,1,12,4,{"$f":"RANK(K84,$B84:$N84)","v":13},6,10,11]
["R3",{"$f":"RANK(B85,$B85:$N85)","v":10},4,6,8,12,1,3,11,5,{"$f":"RANK(K85,$B85:$N85)","v":7},13,2,9]
["R4",{"$f":"RANK(B86,$B86:$N86)","v":9},7,8,10,2,1,13,11,12,{"$f":"RANK(K86,$B86:$N86)","v":6},4,5,3]
["R5",{"$f":"RANK(B87,$B87:$N87)","v":4},13,3,5,8,1,11,10,9,{"$f":"RANK(K87,$B87:$N87)","v":2},6,12,7]
[null,{"$f":"B2","v":"BYRON"},"JOHN C","MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0,{"$f":"K2","v":0},0,0,0,0]
["R1",7.3911410345100959E-2,0.64216423254417232,0.39920386875171254,0.19608170455915197,0.54372493030482716,0.42373054489267425,4.1717831415174711E-2,0.69610715292954217,0.48582638505775133,0.85771657945843816,0.22670485100067805,0.68401698656742038,0.36255538185321945,0.84396341149634124]
["R2",9.3331808335855193E-2,0.55200353253558587,0.13831254333522158,0.82886400007525551,0.47275349183901649,0.79021998780584501,0.19984644105707294,9.2975087553208269E-2,0.9502716752467002,0.55229648926348529,0.66925962009378848,0.79965613126250701,0.14951272841560115,0.50781521104568117]
["R3",0.53201082849491133,0.71287911509822632,0.57591686031880118,0.19924859195495359,0.1468345169199845,0.24570920656767647,0.71751072595626553,0.85971894062915555,0.30512365217241577,0.50290407945623261,0.89695333327503324,0.37374549688582603,0.44962471059481968,0.50855186273573916]
["R4",0.6308622588552204,0.34556048273846351,0.56693782980151253,0.94566353542478376,0.70428912372367236,0.74196980233899945,0.6117597929556674,0.99576480998994255,0.61873009117521605,0.31363996235028513,0.79057242805791839,0.75298662346252476,0.76006808762507949,0.30690800497652682]
["R5",0.53257562550027149,0.78013909392132086,0.70819647298347943,1.7685306721915151E-2,0.37107124570887573,0.3965916370546525,0.10798809549798427,0.34125919550795802,8.2539630311013856E-2,0.98791879777302949,0.84590188742522443,0.61977173690281984,0.70845131498007308,0.30782972904377781]
["R1",{"$f":"RANK(B94,$B94:$O94)","v":13},5,9,12,6,8,14,3,7,{"$f":"RANK(K94,$B94:$O94)","v":1},11,4,10,2]
["R2",{"$f":"RANK(B95,$B95:$O95)","v":13},7,12,2,9,4,10,14,1,{"$f":"RANK(K95,$B95:$O95)","v":6},5,3,11,8]
["R3",{"$f":"RANK(B96,$B96:$O96)","v":6},4,5,13,14,12,3,2,11,{"$f":"RANK(K96,$B96:$O96)","v":8},1,10,9,7]
["R4",{"$f":"RANK(B97,$B97:$O97)","v":8},12,11,2,7,6,10,1,9,{"$f":"RANK(K97,$B97:$O97)","v":13},3,5,4,14]
["R5",{"$f":"RANK(B98,$B98:$O98)","v":7},3,5,14,9,8,12,10,13,{"$f":"RANK(K98,$B98:$O98)","v":1},2,6,4,11]
[null,{"$f":"B2","v":"BYRON"},"JOHN C","MIKE H","STEVER","ROB W","CRAIG T","ANDY W","STU D",0,{"$f":"K2","v":0},0,0,0,0,0]
["R1",{"$f":"RAND()","v":6.0000342489679559E-2},0.39568479612285445,0.71669025921963359,0.25191456166355708,0.42094464199245618,0.64639503170169499,0.70292022079842686,0.30010805167166743,0.608963556814336,0.28436072765005127,0.69415096008059574,0.60169191316977733,0.22283432095245315,0.50336441261151588,8.8042038793150867E-2]
["R2",0.53356487793239804,0.19806273954511844,3.450751486859982E-2,0.93698685074550803,0.61570850154213363,0.56350566553331194,0.91232012181780842,0.65542708075356482,2.7296515746600414E-2,0.7513530247433623,0.72617202595177577,0.98921089224996195,0.60261926324414272,0.46212397297587948,0.14658685677548777]
["R3",0.51567555052185121,0.29391924956621096,0.19858508269817465,0.5555476133577304,0.88220047150738234,0.51016582099877239,0.69457657661630245,6.6211195328892969E-2,0.81718507973877208,0.88906956599505771,0.46963447904886024,0.56467481699444211,0.90428178531351011,0.59686719963904533,0.33103691941700153]
["R4",0.43126964523404709,0.48189303351851087,0.50712376602524278,0.11193340758668879,0.75553323121410398,0.98487825022680187,0.34275320138884013,0.81679280903295748,0.36932968824422008,0.50182895678298745,0.11311652480587953,0.45220241729938071,6.6458707839914033E-2,0.36906331005531412,6.5447873613741603E-2]
["R5",0.49067681637660709,0.13316472606473706,0.65307584756871595,0.30033672537639844,0.95094050146542763,0.79766805649434303,0.47458717325990496,0.12008371110347238,0.57481592419301253,0.16332818624653067,0.34808087298368307,0.18070561487404546,0.96369346408826839,0.48965012624276194,0.23727731605372349]
["R1",{"$f":"RANK(B105,$B105:$P105)","v":15},9,1,12,8,4,2,10,5,{"$f":"RANK(K105,$B105:$P105)","v":11},3,6,13,7,14]
["R2",{"$f":"RANK(B106,$B106:$P106)","v":10},12,14,2,7,9,3,6,15,{"$f":"RANK(K106,$B106:$P106)","v":4},5,1,8,11,13]
["R3",{"$f":"RANK(B107,$B107:$P107)","v":9},13,14,8,3,10,5,15,4,{"$f":"RANK(K107,$B107:$P107)","v":2},11,7,1,6,12]
["R4",{"$f":"RANK(B108,$B108:$P108)","v":8},6,4,13,3,1,11,2,9,{"$f":"RANK(K108,$B108:$P108)","v":5},12,7,14,10,15]
["R5",{"$f":"RANK(B109,$B109:$P109)","v":6},14,4,10,2,3,8,15,5,{"$f":"RANK(K109,$B109:$P109)","v":13},9,12,1,7,11]
[]
["HERE->",3,5,4,8,7,1,2,6]
[null,3,6,4,1,2,8,7,5]
[null,6,4,5,7,8,3,2,1]
[null,2,3,5,7,6,1,8,4]
[null,2,4,5,6,7,8,1,3]
[]
[null,"CUT RANDOM NUMBERS & PASTE VALUES HERE TO BE PICKED UP BY OTHER SHEETS"]
[null,null,"DESIGNED FOR EIGHT PLAYERS - CAN BE EXPANDED"]

{"sheet":"Round order","index":1,"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'!$B116=1,'random picks'!$B$2,IF('random picks'!$C116=1,'random picks'!$C$2,IF('random picks'!$D116=1,'random picks'!$D$2,IF('random picks'!$E116=1,'random picks'!$E$2,IF('random picks'!$F116=1,'random picks'!$F$2,IF('random picks'!$G116=1,'random picks'!$G$2,IF('random picks'!$H116=1,'random picks'!$H$2,IF('random picks'!$I116=1,'random picks'!$I$2))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B116=2,'random picks'!$B$2,IF('random picks'!$C116=2,'random picks'!$C$2,IF('random picks'!$D116=2,'random picks'!$D$2,IF('random picks'!$E116=2,'random picks'!$E$2,IF('random picks'!$F116=2,'random picks'!$F$2,IF('random picks'!$G116=2,'random picks'!$G$2,IF('random picks'!$H116=2,'random picks'!$H$2,IF('random picks'!$I116=2,'random picks'!$I$2))))))))","v":"ANDY W"},{"$f":"IF('random picks'!$B116=3,'random picks'!$B$2,IF('random picks'!$C116=3,'random picks'!$C$2,IF('random picks'!$D116=3,'random picks'!$D$2,IF('random picks'!$E116=3,'random picks'!$E$2,IF('random picks'!$F116=3,'random picks'!$F$2,IF('random picks'!$G116=3,'random picks'!$G$2,IF('random picks'!$H116=3,'random picks'!$H$2,IF('random picks'!$I116=3,'random picks'!$I$2))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B116=4,'random picks'!$B$2,IF('random picks'!$C116=4,'random picks'!$C$2,IF('random picks'!$D116=4,'random picks'!$D$2,IF('random picks'!$E116=4,'random picks'!$E$2,IF('random picks'!$F116=4,'random picks'!$F$2,IF('random picks'!$G116=4,'random picks'!$G$2,IF('random picks'!$H116=4,'random picks'!$H$2,IF('random picks'!$I116=4,'random picks'!$I$2))))))))","v":"MIKE H"},{"$f":"IF('random picks'!$B116=5,'random picks'!$B$2,IF('random picks'!$C116=5,'random picks'!$C$2,IF('random picks'!$D116=5,'random picks'!$D$2,IF('random picks'!$E116=5,'random picks'!$E$2,IF('random picks'!$F116=5,'random picks'!$F$2,IF('random picks'!$G116=5,'random picks'!$G$2,IF('random picks'!$H116=5,'random picks'!$H$2,IF('random picks'!$I116=5,'random picks'!$I$2))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B116=6,'random picks'!$B$2,IF('random picks'!$C116=6,'random picks'!$C$2,IF('random picks'!$D116=6,'random picks'!$D$2,IF('random picks'!$E116=6,'random picks'!$E$2,IF('random picks'!$F116=6,'random picks'!$F$2,IF('random picks'!$G116=6,'random picks'!$G$2,IF('random picks'!$H116=6,'random picks'!$H$2,IF('random picks'!$I116=6,'random picks'!$I$2))))))))","v":"STU D"},{"$f":"IF('random picks'!$B116=7,'random picks'!$B$2,IF('random picks'!$C116=7,'random picks'!$C$2,IF('random picks'!$D116=7,'random picks'!$D$2,IF('random picks'!$E116=7,'random picks'!$E$2,IF('random picks'!$F116=7,'random picks'!$F$2,IF('random picks'!$G116=7,'random picks'!$G$2,IF('random picks'!$H116=7,'random picks'!$H$2,IF('random picks'!$I116=7,'random picks'!$I$2))))))))","v":"ROB W"},{"$f":"IF('random picks'!$B116=8,'random picks'!$B$2,IF('random picks'!$C116=8,'random picks'!$C$2,IF('random picks'!$D116=8,'random picks'!$D$2,IF('random picks'!$E116=8,'random picks'!$E$2,IF('random picks'!$F116=8,'random picks'!$F$2,IF('random picks'!$G116=8,'random picks'!$G$2,IF('random picks'!$H116=8,'random picks'!$H$2,IF('random picks'!$I116=8,'random picks'!$I$2))))))))","v":"STEVER"}]
["R2",{"$f":"IF('random picks'!$B117=1,'random picks'!$B$2,IF('random picks'!$C117=1,'random picks'!$C$2,IF('random picks'!$D117=1,'random picks'!$D$2,IF('random picks'!$E117=1,'random picks'!$E$2,IF('random picks'!$F117=1,'random picks'!$F$2,IF('random picks'!$G117=1,'random picks'!$G$2,IF('random picks'!$H117=1,'random picks'!$H$2,IF('random picks'!$I117=1,'random picks'!$I$2))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B117=2,'random picks'!$B$2,IF('random picks'!$C117=2,'random picks'!$C$2,IF('random picks'!$D117=2,'random picks'!$D$2,IF('random picks'!$E117=2,'random picks'!$E$2,IF('random picks'!$F117=2,'random picks'!$F$2,IF('random picks'!$G117=2,'random picks'!$G$2,IF('random picks'!$H117=2,'random picks'!$H$2,IF('random picks'!$I117=2,'random picks'!$I$2))))))))","v":"ROB W"},{"$f":"IF('random picks'!$B117=3,'random picks'!$B$2,IF('random picks'!$C117=3,'random picks'!$C$2,IF('random picks'!$D117=3,'random picks'!$D$2,IF('random picks'!$E117=3,'random picks'!$E$2,IF('random picks'!$F117=3,'random picks'!$F$2,IF('random picks'!$G117=3,'random picks'!$G$2,IF('random picks'!$H117=3,'random picks'!$H$2,IF('random picks'!$I117=3,'random picks'!$I$2))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B117=4,'random picks'!$B$2,IF('random picks'!$C117=4,'random picks'!$C$2,IF('random picks'!$D117=4,'random picks'!$D$2,IF('random picks'!$E117=4,'random picks'!$E$2,IF('random picks'!$F117=4,'random picks'!$F$2,IF('random picks'!$G117=4,'random picks'!$G$2,IF('random picks'!$H117=4,'random picks'!$H$2,IF('random picks'!$I117=4,'random picks'!$I$2))))))))","v":"MIKE H"},{"$f":"IF('random picks'!$B117=5,'random picks'!$B$2,IF('random picks'!$C117=5,'random picks'!$C$2,IF('random picks'!$D117=5,'random picks'!$D$2,IF('random picks'!$E117=5,'random picks'!$E$2,IF('random picks'!$F117=5,'random picks'!$F$2,IF('random picks'!$G117=5,'random picks'!$G$2,IF('random picks'!$H117=5,'random picks'!$H$2,IF('random picks'!$I117=5,'random picks'!$I$2))))))))","v":"STU D"},{"$f":"IF('random picks'!$B117=6,'random picks'!$B$2,IF('random picks'!$C117=6,'random picks'!$C$2,IF('random picks'!$D117=6,'random picks'!$D$2,IF('random picks'!$E117=6,'random picks'!$E$2,IF('random picks'!$F117=6,'random picks'!$F$2,IF('random picks'!$G117=6,'random picks'!$G$2,IF('random picks'!$H117=6,'random picks'!$H$2,IF('random picks'!$I117=6,'random picks'!$I$2))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B117=7,'random picks'!$B$2,IF('random picks'!$C117=7,'random picks'!$C$2,IF('random picks'!$D117=7,'random picks'!$D$2,IF('random picks'!$E117=7,'random picks'!$E$2,IF('random picks'!$F117=7,'random picks'!$F$2,IF('random picks'!$G117=7,'random picks'!$G$2,IF('random picks'!$H117=7,'random picks'!$H$2,IF('random picks'!$I117=7,'random picks'!$I$2))))))))","v":"ANDY W"},{"$f":"IF('random picks'!$B117=8,'random picks'!$B$2,IF('random picks'!$C117=8,'random picks'!$C$2,IF('random picks'!$D117=8,'random picks'!$D$2,IF('random picks'!$E117=8,'random picks'!$E$2,IF('random picks'!$F117=8,'random picks'!$F$2,IF('random picks'!$G117=8,'random picks'!$G$2,IF('random picks'!$H117=8,'random picks'!$H$2,IF('random picks'!$I117=8,'random picks'!$I$2))))))))","v":"CRAIG T"}]
["R3",{"$f":"IF('random picks'!$B118=1,'random picks'!$B$2,IF('random picks'!$C118=1,'random picks'!$C$2,IF('random picks'!$D118=1,'random picks'!$D$2,IF('random picks'!$E118=1,'random picks'!$E$2,IF('random picks'!$F118=1,'random picks'!$F$2,IF('random picks'!$G118=1,'random picks'!$G$2,IF('random picks'!$H118=1,'random picks'!$H$2,IF('random picks'!$I118=1,'random picks'!$I$2))))))))","v":"STU D"},{"$f":"IF('random picks'!$B118=2,'random picks'!$B$2,IF('random picks'!$C118=2,'random picks'!$C$2,IF('random picks'!$D118=2,'random picks'!$D$2,IF('random picks'!$E118=2,'random picks'!$E$2,IF('random picks'!$F118=2,'random picks'!$F$2,IF('random picks'!$G118=2,'random picks'!$G$2,IF('random picks'!$H118=2,'random picks'!$H$2,IF('random picks'!$I118=2,'random picks'!$I$2))))))))","v":"ANDY W"},{"$f":"IF('random picks'!$B118=3,'random picks'!$B$2,IF('random picks'!$C118=3,'random picks'!$C$2,IF('random picks'!$D118=3,'random picks'!$D$2,IF('random picks'!$E118=3,'random picks'!$E$2,IF('random picks'!$F118=3,'random picks'!$F$2,IF('random picks'!$G118=3,'random picks'!$G$2,IF('random picks'!$H118=3,'random picks'!$H$2,IF('random picks'!$I118=3,'random picks'!$I$2))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B118=4,'random picks'!$B$2,IF('random picks'!$C118=4,'random picks'!$C$2,IF('random picks'!$D118=4,'random picks'!$D$2,IF('random picks'!$E118=4,'random picks'!$E$2,IF('random picks'!$F118=4,'random picks'!$F$2,IF('random picks'!$G118=4,'random picks'!$G$2,IF('random picks'!$H118=4,'random picks'!$H$2,IF('random picks'!$I118=4,'random picks'!$I$2))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B118=5,'random picks'!$B$2,IF('random picks'!$C118=5,'random picks'!$C$2,IF('random picks'!$D118=5,'random picks'!$D$2,IF('random picks'!$E118=5,'random picks'!$E$2,IF('random picks'!$F118=5,'random picks'!$F$2,IF('random picks'!$G118=5,'random picks'!$G$2,IF('random picks'!$H118=5,'random picks'!$H$2,IF('random picks'!$I118=5,'random picks'!$I$2))))))))","v":"MIKE H"},{"$f":"IF('random picks'!$B118=6,'random picks'!$B$2,IF('random picks'!$C118=6,'random picks'!$C$2,IF('random picks'!$D118=6,'random picks'!$D$2,IF('random picks'!$E118=6,'random picks'!$E$2,IF('random picks'!$F118=6,'random picks'!$F$2,IF('random picks'!$G118=6,'random picks'!$G$2,IF('random picks'!$H118=6,'random picks'!$H$2,IF('random picks'!$I118=6,'random picks'!$I$2))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B118=7,'random picks'!$B$2,IF('random picks'!$C118=7,'random picks'!$C$2,IF('random picks'!$D118=7,'random picks'!$D$2,IF('random picks'!$E118=7,'random picks'!$E$2,IF('random picks'!$F118=7,'random picks'!$F$2,IF('random picks'!$G118=7,'random picks'!$G$2,IF('random picks'!$H118=7,'random picks'!$H$2,IF('random picks'!$I118=7,'random picks'!$I$2))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B118=8,'random picks'!$B$2,IF('random picks'!$C118=8,'random picks'!$C$2,IF('random picks'!$D118=8,'random picks'!$D$2,IF('random picks'!$E118=8,'random picks'!$E$2,IF('random picks'!$F118=8,'random picks'!$F$2,IF('random picks'!$G118=8,'random picks'!$G$2,IF('random picks'!$H118=8,'random picks'!$H$2,IF('random picks'!$I118=8,'random picks'!$I$2))))))))","v":"ROB W"}]
["R4",{"$f":"IF('random picks'!$B119=1,'random picks'!$B$2,IF('random picks'!$C119=1,'random picks'!$C$2,IF('random picks'!$D119=1,'random picks'!$D$2,IF('random picks'!$E119=1,'random picks'!$E$2,IF('random picks'!$F119=1,'random picks'!$F$2,IF('random picks'!$G119=1,'random picks'!$G$2,IF('random picks'!$H119=1,'random picks'!$H$2,IF('random picks'!$I119=1,'random picks'!$I$2))))))))","v":"CRAIG T"},{"$f":"IF('random picks'!$B119=2,'random picks'!$B$2,IF('random picks'!$C119=2,'random picks'!$C$2,IF('random picks'!$D119=2,'random picks'!$D$2,IF('random picks'!$E119=2,'random picks'!$E$2,IF('random picks'!$F119=2,'random picks'!$F$2,IF('random picks'!$G119=2,'random picks'!$G$2,IF('random picks'!$H119=2,'random picks'!$H$2,IF('random picks'!$I119=2,'random picks'!$I$2))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B119=3,'random picks'!$B$2,IF('random picks'!$C119=3,'random picks'!$C$2,IF('random picks'!$D119=3,'random picks'!$D$2,IF('random picks'!$E119=3,'random picks'!$E$2,IF('random picks'!$F119=3,'random picks'!$F$2,IF('random picks'!$G119=3,'random picks'!$G$2,IF('random picks'!$H119=3,'random picks'!$H$2,IF('random picks'!$I119=3,'random picks'!$I$2))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B119=4,'random picks'!$B$2,IF('random picks'!$C119=4,'random picks'!$C$2,IF('random picks'!$D119=4,'random picks'!$D$2,IF('random picks'!$E119=4,'random picks'!$E$2,IF('random picks'!$F119=4,'random picks'!$F$2,IF('random picks'!$G119=4,'random picks'!$G$2,IF('random picks'!$H119=4,'random picks'!$H$2,IF('random picks'!$I119=4,'random picks'!$I$2))))))))","v":"STU D"},{"$f":"IF('random picks'!$B119=5,'random picks'!$B$2,IF('random picks'!$C119=5,'random picks'!$C$2,IF('random picks'!$D119=5,'random picks'!$D$2,IF('random picks'!$E119=5,'random picks'!$E$2,IF('random picks'!$F119=5,'random picks'!$F$2,IF('random picks'!$G119=5,'random picks'!$G$2,IF('random picks'!$H119=5,'random picks'!$H$2,IF('random picks'!$I119=5,'random picks'!$I$2))))))))","v":"MIKE H"},{"$f":"IF('random picks'!$B119=6,'random picks'!$B$2,IF('random picks'!$C119=6,'random picks'!$C$2,IF('random picks'!$D119=6,'random picks'!$D$2,IF('random picks'!$E119=6,'random picks'!$E$2,IF('random picks'!$F119=6,'random picks'!$F$2,IF('random picks'!$G119=6,'random picks'!$G$2,IF('random picks'!$H119=6,'random picks'!$H$2,IF('random picks'!$I119=6,'random picks'!$I$2))))))))","v":"ROB W"},{"$f":"IF('random picks'!$B119=7,'random picks'!$B$2,IF('random picks'!$C119=7,'random picks'!$C$2,IF('random picks'!$D119=7,'random picks'!$D$2,IF('random picks'!$E119=7,'random picks'!$E$2,IF('random picks'!$F119=7,'random picks'!$F$2,IF('random picks'!$G119=7,'random picks'!$G$2,IF('random picks'!$H119=7,'random picks'!$H$2,IF('random picks'!$I119=7,'random picks'!$I$2))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B119=8,'random picks'!$B$2,IF('random picks'!$C119=8,'random picks'!$C$2,IF('random picks'!$D119=8,'random picks'!$D$2,IF('random picks'!$E119=8,'random picks'!$E$2,IF('random picks'!$F119=8,'random picks'!$F$2,IF('random picks'!$G119=8,'random picks'!$G$2,IF('random picks'!$H119=8,'random picks'!$H$2,IF('random picks'!$I119=8,'random picks'!$I$2))))))))","v":"ANDY W"}]
["R5",{"$f":"IF('random picks'!$B120=1,'random picks'!$B$2,IF('random picks'!$C120=1,'random picks'!$C$2,IF('random picks'!$D120=1,'random picks'!$D$2,IF('random picks'!$E120=1,'random picks'!$E$2,IF('random picks'!$F120=1,'random picks'!$F$2,IF('random picks'!$G120=1,'random picks'!$G$2,IF('random picks'!$H120=1,'random picks'!$H$2,IF('random picks'!$I120=1,'random picks'!$I$2))))))))","v":"ANDY W"},{"$f":"IF('random picks'!$B120=2,'random picks'!$B$2,IF('random picks'!$C120=2,'random picks'!$C$2,IF('random picks'!$D120=2,'random picks'!$D$2,IF('random picks'!$E120=2,'random picks'!$E$2,IF('random picks'!$F120=2,'random picks'!$F$2,IF('random picks'!$G120=2,'random picks'!$G$2,IF('random picks'!$H120=2,'random picks'!$H$2,IF('random picks'!$I120=2,'random picks'!$I$2))))))))","v":"BYRON"},{"$f":"IF('random picks'!$B120=3,'random picks'!$B$2,IF('random picks'!$C120=3,'random picks'!$C$2,IF('random picks'!$D120=3,'random picks'!$D$2,IF('random picks'!$E120=3,'random picks'!$E$2,IF('random picks'!$F120=3,'random picks'!$F$2,IF('random picks'!$G120=3,'random picks'!$G$2,IF('random picks'!$H120=3,'random picks'!$H$2,IF('random picks'!$I120=3,'random picks'!$I$2))))))))","v":"STU D"},{"$f":"IF('random picks'!$B120=4,'random picks'!$B$2,IF('random picks'!$C120=4,'random picks'!$C$2,IF('random picks'!$D120=4,'random picks'!$D$2,IF('random picks'!$E120=4,'random picks'!$E$2,IF('random picks'!$F120=4,'random picks'!$F$2,IF('random picks'!$G120=4,'random picks'!$G$2,IF('random picks'!$H120=4,'random picks'!$H$2,IF('random picks'!$I120=4,'random picks'!$I$2))))))))","v":"JOHN C"},{"$f":"IF('random picks'!$B120=5,'random picks'!$B$2,IF('random picks'!$C120=5,'random picks'!$C$2,IF('random picks'!$D120=5,'random picks'!$D$2,IF('random picks'!$E120=5,'random picks'!$E$2,IF('random picks'!$F120=5,'random picks'!$F$2,IF('random picks'!$G120=5,'random picks'!$G$2,IF('random picks'!$H120=5,'random picks'!$H$2,IF('random picks'!$I120=5,'random picks'!$I$2))))))))","v":"MIKE H"},{"$f":"IF('random picks'!$B120=6,'random picks'!$B$2,IF('random picks'!$C120=6,'random picks'!$C$2,IF('random picks'!$D120=6,'random picks'!$D$2,IF('random picks'!$E120=6,'random picks'!$E$2,IF('random picks'!$F120=6,'random picks'!$F$2,IF('random picks'!$G120=6,'random picks'!$G$2,IF('random picks'!$H120=6,'random picks'!$H$2,IF('random picks'!$I120=6,'random picks'!$I$2))))))))","v":"STEVER"},{"$f":"IF('random picks'!$B120=7,'random picks'!$B$2,IF('random picks'!$C120=7,'random picks'!$C$2,IF('random picks'!$D120=7,'random picks'!$D$2,IF('random picks'!$E120=7,'random picks'!$E$2,IF('random picks'!$F120=7,'random picks'!$F$2,IF('random picks'!$G120=7,'random picks'!$G$2,IF('random picks'!$H120=7,'random picks'!$H$2,IF('random picks'!$I120=7,'random picks'!$I$2))))))))","v":"ROB W"},{"$f":"IF('random picks'!$B120=8,'random picks'!$B$2,IF('random picks'!$C120=8,'random picks'!$C$2,IF('random picks'!$D120=8,'random picks'!$D$2,IF('random picks'!$E120=8,'random picks'!$E$2,IF('random picks'!$F120=8,'random picks'!$F$2,IF('random picks'!$G120=8,'random picks'!$G$2,IF('random picks'!$H120=8,'random picks'!$H$2,IF('random picks'!$I120=8,'random picks'!$I$2))))))))","v":"CRAIG T"}]

{"sheet":"BLANKS","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["US MASTERS 2017"]
[]
["Day 0"]
[]
[{"$f":"results!A7","v":"BYRON"},"Pick",null,{"$f":"results!G7","v":"ROB W"},"Pick",null,{"$f":"results!M7","v":0},"Pick"]
[null,{"$f":"SUM(B7:B11)/5","v":3.2},null,null,{"$f":"SUM(E7:E11)/5","v":6},null,null,{"$f":"SUM(H7:H11)/5","v":0}]
["Rory McIlroy",{"$f":"'random picks'!B116","v":3},null,"Justin Rose",{"$f":"'random picks'!F116","v":7},null,null,{"$f":"'random picks'!J116","v":0}]
["Henrik Stenson",{"$f":"'random picks'!B117","v":3},null,"Jon Rahm",{"$f":"'random picks'!F117","v":2},null,null,{"$f":"'random picks'!J117","v":0}]
["Matthew Fitzpatrick",{"$f":"'random picks'!B118","v":6},null,"Marc Leishman",{"$f":"'random picks'!F118","v":8},null,null,{"$f":"'random picks'!J118","v":0}]
["Adam Hadwin",{"$f":"'random picks'!B119","v":2},null,"Lee Westwood",{"$f":"'random picks'!F119","v":6},null,null,{"$f":"'random picks'!J119","v":0}]
["Gary Woodland",{"$f":"'random picks'!B120","v":2},null,"Charley Hoffman",{"$f":"'random picks'!F120","v":7},null,null,{"$f":"'random picks'!J120","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":"JOHN C"},null,null,{"$f":"results!G16","v":"CRAIG T"},null,null,{"$f":"results!M16","v":0}]
[null,{"$f":"SUM(B16:B20)/5","v":4.4000000000000004},null,null,{"$f":"SUM(E16:E20)/5","v":4.2},null,null,{"$f":"SUM(H16:H20)/5","v":0}]
["Rickie Fowler",{"$f":"'random picks'!C116","v":5},null,"Dustin Johnson",{"$f":"'random picks'!G116","v":1},null,null,{"$f":"'random picks'!K116","v":0}]
["Louis Oosthuizen",{"$f":"'random picks'!C117","v":6},null,"Sergio Garcia",{"$f":"'random picks'!G117","v":8},null,null,{"$f":"'random picks'!K117","v":0}]
["Patrick Reed",{"$f":"'random picks'!C118","v":4},null,"Brooks Koepka",{"$f":"'random picks'!G118","v":3},null,null,{"$f":"'random picks'!K118","v":0}]
["Jimmy Walker",{"$f":"'random picks'!C119","v":3},null,"Matt Kuchar",{"$f":"'random picks'!G119","v":1},null,null,{"$f":"'random picks'!K119","v":0}]
["Zach Johnson",{"$f":"'random picks'!C120","v":4},null,"Danny Willett",{"$f":"'random picks'!G120","v":8},null,null,{"$f":"'random picks'!K120","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":"MIKE H"},null,null,{"$f":"results!G25","v":"ANDY W"},null,null,{"$f":"results!M25","v":0}]
[null,{"$f":"SUM(B25:B29)/5","v":4.5999999999999996},null,null,{"$f":"SUM(E25:E29)/5","v":4},null,null,{"$f":"SUM(H25:H29)/5","v":0}]
["Hideki Matsuyama",{"$f":"'random picks'!D116","v":4},null,"Jordan Spieth",{"$f":"'random picks'!H116","v":2},null,null,{"$f":"'random picks'!L116","v":0}]
["Bubba Watson",{"$f":"'random picks'!D117","v":4},null,"Paul Casey",{"$f":"'random picks'!H117","v":7},null,null,{"$f":"'random picks'!L117","v":0}]
["Thomas Pieters",{"$f":"'random picks'!D118","v":5},null,"Brandt Snedeker",{"$f":"'random picks'!H118","v":2},null,null,{"$f":"'random picks'!L118","v":0}]
["Daniel Berger",{"$f":"'random picks'!D119","v":5},null,"J.B. Holmes",{"$f":"'random picks'!H119","v":8},null,null,{"$f":"'random picks'!L119","v":0}]
["Shane Lowry",{"$f":"'random picks'!D120","v":5},null,"Kevin Kisner",{"$f":"'random picks'!H120","v":1},null,null,{"$f":"'random picks'!L120","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":"STU D"},null,null,{"$f":"results!M34","v":0}]
[null,{"$f":"SUM(B34:B38)/5","v":5.8},null,null,{"$f":"SUM(E34:E38)/5","v":3.8},null,null,{"$f":"SUM(H34:H38)/5","v":0}]
["Phil Mickelson",{"$f":"'random picks'!E116","v":8},null,"Jason Day",{"$f":"'random picks'!I116","v":6},null,null,{"$f":"'random picks'!M116","v":0}]
["Adam Scott",{"$f":"'random picks'!E117","v":1},null,"Justin Thomas",{"$f":"'random picks'!I117","v":5},null,null,{"$f":"'random picks'!M117","v":0}]
["Charl Schwartzel",{"$f":"'random picks'!E118","v":7},null,"Tyrrell Hatton",{"$f":"'random picks'!I118","v":1},null,null,{"$f":"'random picks'!M118","v":0}]
["Bill Haas",{"$f":"'random picks'!E119","v":7},null,"Tommy Fleetwood",{"$f":"'random picks'!I119","v":4},null,null,{"$f":"'random picks'!M119","v":0}]
["Alex Noren",{"$f":"'random picks'!E120","v":6},null,"Soren Kjeldsen",{"$f":"'random picks'!I120","v":3},null,null,{"$f":"'random picks'!M120","v":0}]
["Best 3",null,null,"Best 3"]
["Running position",null,null,"Running position"]

{"sheet":"ranks","index":3,"n_rows":45,"n_cols":7,"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":"BYRON"},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+2)","v":11},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+3)","v":10.968},{"$f":"IF(ISERROR(RANK(D4,$D$4:$D$14,1)),\"\",RANK(D4,$D$4:$D$14,1))","v":7},{"$f":"IF(ISERROR(RANK(E4,$E$4:$E$14,1)),\"\",RANK(E4,$E$4:$E$14,1))","v":7}]
[{"$f":"A4+9","v":10},1,{"$f":"INDEX(results!$A$7:$Q$42,$A5,$B5)","v":"JOHN C"},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+2)","v":3},{"$f":"INDEX(results!$A$7:$Q$42,$A5+6,$B5+3)","v":2.956},4,{"$f":"IF(ISERROR(RANK(E5,$E$4:$E$14,1)),\"\",RANK(E5,$E$4:$E$14,1))","v":4}]
[{"$f":"A5+9","v":19},1,{"$f":"INDEX(results!$A$7:$Q$42,$A6,$B6)","v":"MIKE H"},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+2)","v":4},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+3)","v":3.9540000000000002},5,5]
[{"$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":2},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+3)","v":1.9419999999999999},3,3]
[1,{"$f":"B4+6","v":7},{"$f":"INDEX(results!$A$7:$Q$42,$A8,$B8)","v":"ROB W"},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+2)","v":-6},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+3)","v":-6.06},1,1]
[{"$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":0},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+3)","v":-4.2000000000000003E-2},2,2]
[{"$f":"A9+9","v":19},7,{"$f":"INDEX(results!$A$7:$Q$42,$A10,$B10)","v":"ANDY W"},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+2)","v":8},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+3)","v":7.96},6,6]
[{"$f":"A10+9","v":28},7,{"$f":"INDEX(results!$A$7:$Q$42,$A11,$B11)","v":"STU D"},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+2)","v":12},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+3)","v":11.962},8,8]
[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,"ROB W",-6,-6.06,1,1]
[null,1,"CRAIG T",0,-4.2000000000000003E-2,2,2]
[null,1,"STEVER",2,1.9419999999999999,3,3]
[null,1,"JOHN C",3,2.956,4,4]
[null,13,"MIKE H",4,3.9540000000000002,5,5]
[null,7,"ANDY W",8,7.96,6,6]
[null,1,"BYRON",11,10.968,7,7]
[null,7,"STU D",12,11.962,8,8]
[null,7,"Tim",24,24,9,9]
[null,13,"Dean","","","",""]
[null,null,"Shem","","","",""]
[]
[]
[]
[]
[]
[]
[null,null,"Average scores of picks","Avg","Rank"]
[null,null,"Pick 1",{"$f":"AVERAGE(results!C8,results!#REF!,results!#REF!,results!#REF!,results!#REF!,results!#REF!,results!#REF!,results!#REF!,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!C17,results!C26,results!C35,results!I8,results!I17,results!I26,results!I35,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":"PAYERS","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["WHO","PAID","TO PAY","ATTEND","PICKS"]
[{"$f":"results!A7","v":"BYRON"},"NO","YES","YES","NO"]
[{"$f":"results!A16","v":"JOHN C"},"NO","YES","YES","NO"]
[{"$f":"results!A25","v":"MIKE H"},"NO","YES","YES","NO"]
[{"$f":"results!A34","v":"STEVER"},"NO","YES","YES","NO"]
[{"$f":"results!G7","v":"ROB W"},"NO","YES","YES","NO"]
[{"$f":"results!G16","v":"CRAIG T"},"NO","YES","NO","NO"]
[{"$f":"results!G25","v":"ANDY W"},"NO","YES","YES","NO"]
[{"$f":"results!G34","v":"STU D"},"NO","YES","NO","NO"]

{"sheet":"webquery","index":5,"n_rows":159,"n_cols":23,"rows_kept":159,"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,"from","https://www.msn.com/en-us/sports/golf/leaderboard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Index:",3,4,6,5]
[null,"2017 Round 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total","t-off","thru"]
[null,"Pos","Name","Total","Thru","Today","R1","R2","R3","R4","S","Strokes",null,null,null,null,null,1,{"$f":"SUBSTITUTE(INDEX($A$4:$J$159,R4,$S$2),\"*\",\"\")","v":"Name"},{"$f":"IF(SUBSTITUTE(INDEX($A$4:$L$159,R4,$T$2),\"+\",\"\")=\"E\",0,IF(SUBSTITUTE(INDEX($A$4:$L$159,R4,$T$2),\"+\",\"\")=\"MC\",100,SUBSTITUTE(INDEX($A$4:$L$159,R4,$T$2),\"+\",\"\")))","v":"Total"},{"$f":"IF(ISERROR(INDEX($A$4:$J$159,R4,$U$2)+TIME(5,0,0)),\"\",INDEX($A$4:$J$159,R4,$U$2)+TIME(5,0,0))","v":""},{"$f":"INDEX($A$4:$N$159,R4,$V$2)","v":"Thru"}]
[null,1,"Charley Hoffman","-4","18","3","65","75","-","-","140","-",null,null,null,null,null,2,{"$f":"SUBSTITUTE(INDEX($A$4:$J$159,R5,$S$2),\"*\",\"\")","v":"Charley Hoffman"},{"$f":"IF(SUBSTITUTE(INDEX($A$4:$L$159,R5,$T$2),\"+\",\"\")=\"E\",0,IF(SUBSTITUTE(INDEX($A$4:$L$159,R5,$T$2),\"+\",\"\")=\"MC\",100,SUBSTITUTE(INDEX($A$4:$L$159,R5,$T$2),\"+\",\"\")))","v":"-4"},{"$f":"IF(ISERROR(INDEX($A$4:$J$159,R5,$U$2)+TIME(5,0,0)),\"\",INDEX($A$4:$J$159,R5,$U$2)+TIME(5,0,0))","v":3.2083333333333335},{"$f":"INDEX($A$4:$N$159,R5,$V$2)","v":"18"}]
[null,1,"Sergio Garcia","-4","18","-3","71","69","-","-","140","-",null,null,null,null,null,3,"Sergio Garcia","-4",-2.7916666666666665,"18"]
[null,1,"Thomas Pieters","-4","18","-4","72","68","-","-","140","-",null,null,null,null,null,4,"Thomas Pieters","-4",-3.7916666666666665,"18"]
[null,1,"Rickie Fowler","-4","18","-5","73","67","-","-","140","-",null,null,null,null,null,5,"Rickie Fowler","-4",-4.791666666666667,"18"]
[null,5,"William McGirt","-2","18","1","69","73","-","-","142","-",null,null,null,null,null,6,"William McGirt","-2",1.2083333333333333,"18"]
[null,6,"Ryan Moore","-1","18","-3","74","69","-","-","143","-",null,null,null,null,null,7,"Ryan Moore","-1",-2.7916666666666665,"18"]
[null,6,"Jon Rahm","-1","18","-2","73","70","-","-","143","-",null,null,null,null,null,8,"Jon Rahm","-1",-1.7916666666666667,"18"]
[null,6,"Fred Couples","-1","18","-2","73","70","-","-","143","-",null,null,null,null,null,9,"Fred Couples","-1",-1.7916666666666667,"18"]
[null,6,"Justin Rose","-1","18","E","71","72","-","-","143","-",null,null,null,null,null,10,"Justin Rose","-1","","18"]
[null,10,"Adam Scott","E","18","-3","75","69","-","-","144","-",null,null,null,null,null,11,"Adam Scott",0,-2.7916666666666665,"18"]
[null,10,"Jordan Spieth","E","18","-3","75","69","-","-","144","-",null,null,null,null,null,12,"Jordan Spieth",0,-2.7916666666666665,"18"]
[null,10,"Phil Mickelson","E","18","1","71","73","-","-","144","-",null,null,null,null,null,13,"Phil Mickelson",0,1.2083333333333333,"18"]
[null,13,"Matt Kuchar","1","18","1","72","73","-","-","145","-",null,null,null,null,null,14,"Matt Kuchar","1",1.2083333333333333,"18"]
[null,13,"Rory McIlroy","1","18","1","72","73","-","-","145","-",null,null,null,null,null,15,"Rory McIlroy","1",1.2083333333333333,"18"]
[null,13,"Soren Kjeldsen","1","18","1","72","73","-","-","145","-",null,null,null,null,null,16,"Soren Kjeldsen","1",1.2083333333333333,"18"]
[null,16,"Charl Schwartzel","2","18","E","74","72","-","-","146","-",null,null,null,null,null,17,"Charl Schwartzel","2","","18"]
[null,16,"Hideki Matsuyama","2","18","-2","76","70","-","-","146","-",null,null,null,null,null,18,"Hideki Matsuyama","2",-1.7916666666666667,"18"]
[null,16,"Martin Kaymer","2","18","-4","78","68","-","-","146","-",null,null,null,null,null,19,"Martin Kaymer","2",-3.7916666666666665,"18"]
[null,19,"Jason Dufner","3","18","4","71","76","-","-","147","-",null,null,null,null,null,20,"Jason Dufner","3",4.208333333333333,"18"]
[null,19,"Ernie Els","3","18","3","72","75","-","-","147","-",null,null,null,null,null,21,"Ernie Els","3",3.2083333333333335,"18"]
[null,19,"Lee Westwood","3","18","5","70","77","-","-","147","-",null,null,null,null,null,22,"Lee Westwood","3",5.208333333333333,"18"]
[null,19,"Bill Haas","3","18","E","75","72","-","-","147","-",null,null,null,null,null,23,"Bill Haas","3","","18"]
[null,19,"Marc Leishman","3","18","2","73","74","-","-","147","-",null,null,null,null,null,24,"Marc Leishman","3",2.2083333333333335,"18"]
[null,19,"Jimmy Walker","3","18","-1","76","71","-","-","147","-",null,null,null,null,null,25,"Jimmy Walker","3",-0.79166666666666663,"18"]
[null,19,"Russell Henley","3","18","4","71","76","-","-","147","-",null,null,null,null,null,26,"Russell Henley","3",4.208333333333333,"18"]
[null,19,"Brendan Steele","3","18","1","74","73","-","-","147","-",null,null,null,null,null,27,"Brendan Steele","3",1.2083333333333333,"18"]
[null,19,"Stewart Hagestad","3","18","1","74","73","-","-","147","-",null,null,null,null,null,28,"Stewart Hagestad","3",1.2083333333333333,"18"]
[null,19,"Brian Stuard","3","18","-2","77","70","-","-","147","-",null,null,null,null,null,29,"Brian Stuard","3",-1.7916666666666667,"18"]
[null,19,"Kevin Chappell","3","18","4","71","76","-","-","147","-",null,null,null,null,null,30,"Kevin Chappell","3",4.208333333333333,"18"]
[null,19,"Paul Casey","3","18","3","72","75","-","-","147","-",null,null,null,null,null,31,"Paul Casey","3",3.2083333333333335,"18"]
[null,19,"Brooks Koepka","3","18","1","74","73","-","-","147","-",null,null,null,null,null,32,"Brooks Koepka","3",1.2083333333333333,"18"]
[null,32,"Pat Perez","4","18","2","74","74","-","-","148","-",null,null,null,null,null,33,"Pat Perez","4",2.2083333333333335,"18"]
[null,32,"Steve Stricker","4","18","1","75","73","-","-","148","-",null,null,null,null,null,34,"Steve Stricker","4",1.2083333333333333,"18"]
[null,32,"Louis Oosthuizen","4","18","-1","77","71","-","-","148","-",null,null,null,null,null,35,"Louis Oosthuizen","4",-0.79166666666666663,"18"]
[null,35,"Byeong-Hun An","5","18","1","76","73","-","-","149","-",null,null,null,null,null,36,"Byeong-Hun An","5",1.2083333333333333,"18"]
[null,35,"Bernd Wiesberger","5","18","E","77","72","-","-","149","-",null,null,null,null,null,37,"Bernd Wiesberger","5","","18"]
[null,35,"Emiliano Grillo","5","18","-2","79","70","-","-","149","-",null,null,null,null,null,38,"Emiliano Grillo","5",-1.7916666666666667,"18"]
[null,35,"Justin Thomas","5","18","4","73","76","-","-","149","-",null,null,null,null,null,39,"Justin Thomas","5",4.208333333333333,"18"]
[null,35,"Daniel Summerhays","5","18","3","74","75","-","-","149","-",null,null,null,null,null,40,"Daniel Summerhays","5",3.2083333333333335,"18"]
[null,35,"Adam Hadwin","5","18","2","75","74","-","-","149","-",null,null,null,null,null,41,"Adam Hadwin","5",2.2083333333333335,"18"]
[null,35,"Kevin Kisner","5","18","3","74","75","-","-","149","-",null,null,null,null,null,42,"Kevin Kisner","5",3.2083333333333335,"18"]
[null,35,"Andy Sullivan","5","18","6","71","78","-","-","149","-",null,null,null,null,null,43,"Andy Sullivan","5",6.208333333333333,"18"]
[null,35,"Matthew Fitzpatrick","5","18","6","71","78","-","-","149","-",null,null,null,null,null,44,"Matthew Fitzpatrick","5",6.208333333333333,"18"]
[null,35,"Brandt Snedeker","5","18","2","75","74","-","-","149","-",null,null,null,null,null,45,"Brandt Snedeker","5",2.2083333333333335,"18"]
[null,45,"James Hahn","6","18","3","75","75","-","-","150","-",null,null,null,null,null,46,"James Hahn","6",3.2083333333333335,"18"]
[null,45,"Ross Fisher","6","18","2","76","74","-","-","150","-",null,null,null,null,null,47,"Ross Fisher","6",2.2083333333333335,"18"]
[null,45,"Curtis Luck","6","18","E","78","72","-","-","150","-",null,null,null,null,null,48,"Curtis Luck","6","","18"]
[null,45,"Larry Mize","6","18","4","74","76","-","-","150","-",null,null,null,null,null,49,"Larry Mize","6",4.208333333333333,"18"]
[null,45,"J.B. Holmes","6","18","E","78","72","-","-","150","-",null,null,null,null,null,50,"J.B. Holmes","6","","18"]
[null,45,"Daniel Berger","6","18","1","77","73","-","-","150","-",null,null,null,null,null,51,"Daniel Berger","6",1.2083333333333333,"18"]
[null,45,"Francesco Molinari","6","18","E","78","72","-","-","150","-",null,null,null,null,null,52,"Francesco Molinari","6","","18"]
[null,45,"Branden Grace","6","18","2","76","74","-","-","150","-",null,null,null,null,null,53,"Branden Grace","6",2.2083333333333335,"18"]
[null,45,"Jason Day","6","18","4","74","76","-","-","150","-",null,null,null,null,null,54,"Jason Day","6",4.208333333333333,"18"]
[null,null,"Danny Willett","7","18","6","73","78","-","-","151","-",null,null,null,null,null,55,"Danny Willett","7",6.208333333333333,"18"]
[null,null,"Yuta Ikeda","7","18","5","74","77","-","-","151","-",null,null,null,null,null,56,"Yuta Ikeda","7",5.208333333333333,"18"]
[null,null,"Chris Wood","7","18","5","74","77","-","-","151","-",null,null,null,null,null,57,"Chris Wood","7",5.208333333333333,"18"]
[null,null,"Shane Lowry","7","18","7","72","79","-","-","151","-",null,null,null,null,null,58,"Shane Lowry","7",7.208333333333333,"18"]
[null,null,"Billy Hurley III","7","18","4","75","76","-","-","151","-",null,null,null,null,null,59,"Billy Hurley III","7",4.208333333333333,"18"]
[null,null,"Jim Furyk","7","18","1","78","73","-","-","151","-",null,null,null,null,null,60,"Jim Furyk","7",1.2083333333333333,"18"]
[null,null,"Zach Johnson","7","18","2","77","74","-","-","151","-",null,null,null,null,null,61,"Zach Johnson","7",2.2083333333333335,"18"]
[null,null,"Kevin Na","7","18","3","76","75","-","-","151","-",null,null,null,null,null,62,"Kevin Na","7",3.2083333333333335,"18"]
[null,null,"Rod Pampling","8","18","6","74","78","-","-","152","-",null,null,null,null,null,63,"Rod Pampling","8",6.208333333333333,"18"]
[null,null,"Webb Simpson","8","18","5","75","77","-","-","152","-",null,null,null,null,null,64,"Webb Simpson","8",5.208333333333333,"18"]
[null,null,"Henrik Stenson","8","18","3","77","75","-","-","152","-",null,null,null,null,null,65,"Henrik Stenson","8",3.2083333333333335,"18"]
[null,null,"Alex Noren","8","18","6","74","78","-","-","152","-",null,null,null,null,null,66,{"$f":"SUBSTITUTE(INDEX($A$4:$J$159,R69,$S$2),\"*\",\"\")","v":"Alex Noren"},{"$f":"IF(SUBSTITUTE(INDEX($A$4:$L$159,R69,$T$2),\"+\",\"\")=\"E\",0,IF(SUBSTITUTE(INDEX($A$4:$L$159,R69,$T$2),\"+\",\"\")=\"MC\",100,SUBSTITUTE(INDEX($A$4:$L$159,R69,$T$2),\"+\",\"\")))","v":"8"},{"$f":"IF(ISERROR(INDEX($A$4:$J$159,R69,$U$2)+TIME(5,0,0)),\"\",INDEX($A$4:$J$159,R69,$U$2)+TIME(5,0,0))","v":6.208333333333333},{"$f":"INDEX($A$4:$N$159,R69,$V$2)","v":"18"}]
[null,null,"Bubba Watson","8","18","6","74","78","-","-","152","-",null,null,null,null,null,67,"Bubba Watson","8",6.208333333333333,"18"]
[null,null,"Scott Piercy","8","18","7","73","79","-","-","152","-",null,null,null,null,null,68,"Scott Piercy","8",7.208333333333333,"18"]
[null,null,"Tommy Fleetwood","8","18","2","78","74","-","-","152","-",null,null,null,null,null,69,"Tommy Fleetwood","8",2.2083333333333335,"18"]
[null,null,"Russell Knox","8","18","4","76","76","-","-","152","-",null,null,null,null,null,70,"Russell Knox","8",4.208333333333333,"18"]
[null,null,"Rafa Cabrera Bello","8","18","5","75","77","-","-","152","-",null,null,null,null,null,71,"Rafa Cabrera Bello","8",5.208333333333333,"18"]
[null,null,"Hudson Swafford","9","18","4","77","76","-","-","153","-",null,null,null,null,null,72,"Hudson Swafford","9",4.208333333333333,"18"]
[null,null,"Brad Dalke","9","18","3","78","75","-","-","153","-",null,null,null,null,null,73,"Brad Dalke","9",3.2083333333333335,"18"]
[null,null,"Jose Maria Olazabal","9","18","4","77","76","-","-","153","-",null,null,null,null,null,74,"Jose Maria Olazabal","9",4.208333333333333,"18"]
[null,null,"Vijay Singh","9","18","3","78","75","-","-","153","-",null,null,null,null,null,75,"Vijay Singh","9",3.2083333333333335,"18"]
[null,null,"Patrick Reed","9","18","5","76","77","-","-","153","-",null,null,null,null,null,76,"Patrick Reed","9",5.208333333333333,"18"]
[null,null,"Bernhard Langer","9","18","6","75","78","-","-","153","-",null,null,null,null,null,77,"Bernhard Langer","9",6.208333333333333,"18"]
[null,null,"Sean O'Hair","9","18","5","76","77","-","-","153","-",null,null,null,null,null,78,"Sean O'Hair","9",5.208333333333333,"18"]
[null,null,"Ian Woosnam","10","18","6","76","78","-","-","154","-",null,null,null,null,null,79,"Ian Woosnam","10",6.208333333333333,"18"]
[null,null,"Angel Cabrera","10","18","3","79","75","-","-","154","-",null,null,null,null,null,80,"Angel Cabrera","10",3.2083333333333335,"18"]
[null,null,"Jhonattan Vegas","10","18","4","78","76","-","-","154","-",null,null,null,null,null,81,"Jhonattan Vegas","10",4.208333333333333,"18"]
[null,null,"Trevor Immelman","11","18","4","79","76","-","-","155","-",null,null,null,null,null,82,"Trevor Immelman","11",4.208333333333333,"18"]
[null,null,"Mike Weir","11","18","7","76","79","-","-","155","-",null,null,null,null,null,83,"Mike Weir","11",7.208333333333333,"18"]
[null,null,"Gary Woodland","11","18","8","75","80","-","-","155","-",null,null,null,null,null,84,"Gary Woodland","11",8.2083333333333339,"18"]
[null,null,"Mark O'Meara","12","18","6","78","78","-","-","156","-",null,null,null,null,null,85,"Mark O'Meara","12",6.208333333333333,"18"]
[null,null,"Hideto Tanihara","12","18","8","76","80","-","-","156","-",null,null,null,null,null,86,"Hideto Tanihara","12",8.2083333333333339,"18"]
[null,null,"Jeung-hun Wang","12","18","6","78","78","-","-","156","-",null,null,null,null,null,87,"Jeung-hun Wang","12",6.208333333333333,"18"]
[null,null,"Si Woo Kim","12","18","9","75","81","-","-","156","-",null,null,null,null,null,88,"Si Woo Kim","12",9.2083333333333339,"18"]
[null,87,"Dustin Johnson","-","2:03 PM","-","-","-","-","-","-","-",null,null,null,null,null,89,"Dustin Johnson","-","","2:03 PM"]
[null,null,"Roberto Castro","13","18","6","79","78","-","-","157","-",null,null,null,null,null,90,"Roberto Castro","13",6.208333333333333,"18"]
[null,null,"Scott Gregory","13","18","3","82","75","-","-","157","-",null,null,null,null,null,91,"Scott Gregory","13",3.2083333333333335,"18"]
[null,null,"Tyrrell Hatton","14","18","6","80","78","-","-","158","-",null,null,null,null,null,92,"Tyrrell Hatton","14",6.208333333333333,"18"]
[null,null,"Mackenzie Hughes","15","18","8","79","80","-","-","159","-",null,null,null,null,null,93,"Mackenzie Hughes","15",8.2083333333333339,"18"]
[null,null,"Sandy Lyle","16","18","11","77","83","-","-","160","-",null,null,null,null,null,94,"Sandy Lyle","16",11.208333333333334,"18"]
[null,null,"Toto Gana","17","18","8","81","80","-","-","161","-",null,null,null,null,null,95,"Toto Gana","17",8.2083333333333339,"18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"SUBSTITUTE(INDEX($A$4:$J$159,R133,$S$2),\"*\",\"\")","v":""},{"$f":"IF(SUBSTITUTE(INDEX($A$4:$L$159,R133,$T$2),\"+\",\"\")=\"E\",0,IF(SUBSTITUTE(INDEX($A$4:$L$159,R133,$T$2),\"+\",\"\")=\"MC\",100,SUBSTITUTE(INDEX($A$4:$L$159,R133,$T$2),\"+\",\"\")))","v":""},{"$f":"IF(ISERROR(INDEX($A$4:$J$159,R133,$U$2)+TIME(5,0,0)),\"\",INDEX($A$4:$J$159,R133,$U$2)+TIME(5,0,0))","v":"05:00:00"},{"$f":"INDEX($A$4:$N$159,R133,$V$2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,"","","05:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156,"","","05:00:00",0]

{"sheet":"results","index":6,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["US MASTERS 2017"]
[]
[]
["Day",1]
[]
[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":"BYRON"},{"$f":"SUM(B8:B12)/5","v":3.2},null,null,null,null,{"$f":"'random picks'!F2","v":"ROB W"},{"$f":"SUM(H8:H12)/5","v":6},null,null,null,null,{"$f":"'random picks'!J2","v":0},{"$f":"SUM(N8:N12)/5","v":0}]
[{"$f":"BLANKS!A7","v":"Rory McIlroy"},{"$f":"BLANKS!B7","v":3},{"$f":"VALUE(IF($A8=\"\",\"\",VLOOKUP($A8,webquery!S:V,2,FALSE)))","v":1},{"$f":"VLOOKUP($A8,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D7","v":"Justin Rose"},{"$f":"BLANKS!E7","v":7},{"$f":"VALUE(IF($G8=\"\",\"\",VLOOKUP($G8,webquery!S:V,2,FALSE)))","v":-1},{"$f":"VLOOKUP($G8,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G7","v":0},{"$f":"BLANKS!H7","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!A8","v":"Henrik Stenson"},{"$f":"BLANKS!B8","v":3},{"$f":"VALUE(IF($A9=\"\",\"\",VLOOKUP($A9,webquery!S:V,2,FALSE)))","v":8},{"$f":"VLOOKUP($A9,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D8","v":"Jon Rahm"},{"$f":"BLANKS!E8","v":2},{"$f":"VALUE(IF($G9=\"\",\"\",VLOOKUP($G9,webquery!S:V,2,FALSE)))","v":-1},{"$f":"VLOOKUP($G9,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G8","v":0},{"$f":"BLANKS!H8","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!A9","v":"Matthew Fitzpatrick"},{"$f":"BLANKS!B9","v":6},{"$f":"VALUE(IF($A10=\"\",\"\",VLOOKUP($A10,webquery!S:V,2,FALSE)))","v":5},{"$f":"VLOOKUP($A10,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D9","v":"Marc Leishman"},{"$f":"BLANKS!E9","v":8},{"$f":"VALUE(IF($G10=\"\",\"\",VLOOKUP($G10,webquery!S:V,2,FALSE)))","v":3},{"$f":"VLOOKUP($G10,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G9","v":0},{"$f":"BLANKS!H9","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!A10","v":"Adam Hadwin"},{"$f":"BLANKS!B10","v":2},{"$f":"VALUE(IF($A11=\"\",\"\",VLOOKUP($A11,webquery!S:V,2,FALSE)))","v":5},{"$f":"VLOOKUP($A11,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D10","v":"Lee Westwood"},{"$f":"BLANKS!E10","v":6},{"$f":"VALUE(IF($G11=\"\",\"\",VLOOKUP($G11,webquery!S:V,2,FALSE)))","v":3},{"$f":"VLOOKUP($G11,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G10","v":0},{"$f":"BLANKS!H10","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!A11","v":"Gary Woodland"},{"$f":"BLANKS!B11","v":2},{"$f":"VALUE(IF($A12=\"\",\"\",VLOOKUP($A12,webquery!S:V,2,FALSE)))","v":11},{"$f":"VLOOKUP($A12,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D11","v":"Charley Hoffman"},{"$f":"BLANKS!E11","v":7},{"$f":"VALUE(IF($G12=\"\",\"\",VLOOKUP($G12,webquery!S:V,2,FALSE)))","v":-4},{"$f":"VLOOKUP($G12,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G11","v":0},{"$f":"BLANKS!H11","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":11},{"$f":"IF(ISERROR(C13-B7/100),\"\",C13-B7/100)","v":10.968},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":-6},{"$f":"IF(ISERROR(I13-H7/100),\"\",I13-H7/100)","v":-6.06},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":7},{"$f":"VLOOKUP(A7,ranks!$C$4:$G$14,5,FALSE)","v":7},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G7,ranks!$C$4:$G$14,4,FALSE)","v":1},{"$f":"VLOOKUP(G7,ranks!$C$4:$G$14,5,FALSE)","v":1},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(M7,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(M7,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick"]
[]
[{"$f":"'random picks'!C2","v":"JOHN C"},{"$f":"SUM(B17:B21)/5","v":4.4000000000000004},null,null,null,null,{"$f":"'random picks'!G2","v":"CRAIG T"},{"$f":"SUM(H17:H21)/5","v":4.2},null,null,null,null,{"$f":"'random picks'!K2","v":0},{"$f":"SUM(N17:N21)/5","v":0}]
[{"$f":"BLANKS!A16","v":"Rickie Fowler"},{"$f":"BLANKS!B16","v":5},{"$f":"VALUE(IF($A17=\"\",\"\",VLOOKUP($A17,webquery!S:V,2,FALSE)))","v":-4},{"$f":"VLOOKUP($A17,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D16","v":"Dustin Johnson"},{"$f":"BLANKS!E16","v":1},null,null,1.5,null,{"$f":"BLANKS!G16","v":0},{"$f":"BLANKS!H16","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!A17","v":"Louis Oosthuizen"},{"$f":"BLANKS!B17","v":6},{"$f":"VALUE(IF($A18=\"\",\"\",VLOOKUP($A18,webquery!S:V,2,FALSE)))","v":4},{"$f":"VLOOKUP($A18,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D17","v":"Sergio Garcia"},{"$f":"BLANKS!E17","v":8},{"$f":"VALUE(IF($G18=\"\",\"\",VLOOKUP($G18,webquery!S:V,2,FALSE)))","v":-4},{"$f":"VLOOKUP($G18,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G17","v":0},{"$f":"BLANKS!H17","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!A18","v":"Patrick Reed"},{"$f":"BLANKS!B18","v":4},{"$f":"VALUE(IF($A19=\"\",\"\",VLOOKUP($A19,webquery!S:V,2,FALSE)))","v":9},{"$f":"VLOOKUP($A19,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D18","v":"Brooks Koepka"},{"$f":"BLANKS!E18","v":3},{"$f":"VALUE(IF($G19=\"\",\"\",VLOOKUP($G19,webquery!S:V,2,FALSE)))","v":3},{"$f":"VLOOKUP($G19,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G18","v":0},{"$f":"BLANKS!H18","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!A19","v":"Jimmy Walker"},{"$f":"BLANKS!B19","v":3},{"$f":"VALUE(IF($A20=\"\",\"\",VLOOKUP($A20,webquery!S:V,2,FALSE)))","v":3},{"$f":"VLOOKUP($A20,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D19","v":"Matt Kuchar"},{"$f":"BLANKS!E19","v":1},{"$f":"VALUE(IF($G20=\"\",\"\",VLOOKUP($G20,webquery!S:V,2,FALSE)))","v":1},{"$f":"VLOOKUP($G20,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G19","v":0},{"$f":"BLANKS!H19","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!A20","v":"Zach Johnson"},{"$f":"BLANKS!B20","v":4},{"$f":"VALUE(IF($A21=\"\",\"\",VLOOKUP($A21,webquery!S:V,2,FALSE)))","v":7},{"$f":"VLOOKUP($A21,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D20","v":"Danny Willett"},{"$f":"BLANKS!E20","v":8},{"$f":"VALUE(IF($G21=\"\",\"\",VLOOKUP($G21,webquery!S:V,2,FALSE)))","v":7},{"$f":"VLOOKUP($G21,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G20","v":0},{"$f":"BLANKS!H20","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":3},{"$f":"IF(ISERROR(C22-B16/100),\"\",C22-B16/100)","v":2.956},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":0},{"$f":"IF(ISERROR(I22-H16/100),\"\",I22-H16/100)","v":-4.2000000000000003E-2},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(O17:O21,1)+SMALL(O17:O21,2)+SMALL(O17:O21,3)),\"\",SMALL(O17:O21,1)+SMALL(O17:O21,2)+SMALL(O17:O21,3))","v":""},{"$f":"IF(ISERROR(O22-N16/100),\"\",O22-N16/100)","v":""}]
["Running position",null,{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,4,FALSE)","v":4},{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,5,FALSE)","v":4},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,4,FALSE)","v":2},{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,5,FALSE)","v":2},"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":"MIKE H"},{"$f":"SUM(B26:B30)/5","v":4.5999999999999996},null,null,null,null,{"$f":"'random picks'!H2","v":"ANDY W"},{"$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!A25","v":"Hideki Matsuyama"},{"$f":"BLANKS!B25","v":4},{"$f":"VALUE(IF($A26=\"\",\"\",VLOOKUP($A26,webquery!S:V,2,FALSE)))","v":2},{"$f":"VLOOKUP($A26,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D25","v":"Jordan Spieth"},{"$f":"BLANKS!E25","v":2},{"$f":"VALUE(IF($G26=\"\",\"\",VLOOKUP($G26,webquery!S:V,2,FALSE)))","v":0},{"$f":"VLOOKUP($G26,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G16","v":0},{"$f":"BLANKS!H25","v":0}]
[{"$f":"BLANKS!A26","v":"Bubba Watson"},{"$f":"BLANKS!B26","v":4},{"$f":"VALUE(IF($A27=\"\",\"\",VLOOKUP($A27,webquery!S:V,2,FALSE)))","v":8},{"$f":"VLOOKUP($A27,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D26","v":"Paul Casey"},{"$f":"BLANKS!E26","v":7},{"$f":"VALUE(IF($G27=\"\",\"\",VLOOKUP($G27,webquery!S:V,2,FALSE)))","v":3},{"$f":"VLOOKUP($G27,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G17","v":0},{"$f":"BLANKS!H26","v":0}]
[{"$f":"BLANKS!A27","v":"Thomas Pieters"},{"$f":"BLANKS!B27","v":5},{"$f":"VALUE(IF($A28=\"\",\"\",VLOOKUP($A28,webquery!S:V,2,FALSE)))","v":-4},{"$f":"VLOOKUP($A28,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D27","v":"Brandt Snedeker"},{"$f":"BLANKS!E27","v":2},{"$f":"VALUE(IF($G28=\"\",\"\",VLOOKUP($G28,webquery!S:V,2,FALSE)))","v":5},{"$f":"VLOOKUP($G28,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G18","v":0},{"$f":"BLANKS!H27","v":0}]
[{"$f":"BLANKS!A28","v":"Daniel Berger"},{"$f":"BLANKS!B28","v":5},{"$f":"VALUE(IF($A29=\"\",\"\",VLOOKUP($A29,webquery!S:V,2,FALSE)))","v":6},{"$f":"VLOOKUP($A29,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D28","v":"J.B. Holmes"},{"$f":"BLANKS!E28","v":8},{"$f":"VALUE(IF($G29=\"\",\"\",VLOOKUP($G29,webquery!S:V,2,FALSE)))","v":6},{"$f":"VLOOKUP($G29,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G19","v":0},{"$f":"BLANKS!H28","v":0}]
[{"$f":"BLANKS!A29","v":"Shane Lowry"},{"$f":"BLANKS!B29","v":5},{"$f":"VALUE(IF($A30=\"\",\"\",VLOOKUP($A30,webquery!S:V,2,FALSE)))","v":7},{"$f":"VLOOKUP($A30,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D29","v":"Kevin Kisner"},{"$f":"BLANKS!E29","v":1},{"$f":"VALUE(IF($G30=\"\",\"\",VLOOKUP($G30,webquery!S:V,2,FALSE)))","v":5},{"$f":"VLOOKUP($G30,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G20","v":0},{"$f":"BLANKS!H29","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":4},{"$f":"IF(ISERROR(C31-B25/100),\"\",C31-B25/100)","v":3.9540000000000002},null,null,"Best 3",null,{"$f":"IF(ISERROR(SMALL(I26:I30,1)+SMALL(I26:I30,2)+SMALL(I26:I30,3)),\"\",SMALL(I26:I30,1)+SMALL(I26:I30,2)+SMALL(I26:I30,3))","v":8},{"$f":"IF(ISERROR(I31-H25/100),\"\",I31-H25/100)","v":7.96},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":5},{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,5,FALSE)","v":5},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G25,ranks!$C$4:$G$14,4,FALSE)","v":6},{"$f":"VLOOKUP(G25,ranks!$C$4:$G$14,5,FALSE)","v":6},"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":5.8},null,null,null,null,{"$f":"'random picks'!I2","v":"STU D"},{"$f":"SUM(H35:H39)/5","v":3.8},null,null,null,null,0]
[{"$f":"BLANKS!A34","v":"Phil Mickelson"},{"$f":"BLANKS!B34","v":8},{"$f":"VALUE(IF($A35=\"\",\"\",VLOOKUP($A35,webquery!S:V,2,FALSE)))","v":0},{"$f":"VLOOKUP($A35,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D34","v":"Jason Day"},{"$f":"BLANKS!E34","v":6},{"$f":"VALUE(IF($G35=\"\",\"\",VLOOKUP($G35,webquery!S:V,2,FALSE)))","v":6},{"$f":"VLOOKUP($G35,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G34","v":0}]
[{"$f":"BLANKS!A35","v":"Adam Scott"},{"$f":"BLANKS!B35","v":1},{"$f":"VALUE(IF($A36=\"\",\"\",VLOOKUP($A36,webquery!S:V,2,FALSE)))","v":0},{"$f":"VLOOKUP($A36,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D35","v":"Justin Thomas"},{"$f":"BLANKS!E35","v":5},{"$f":"VALUE(IF($G36=\"\",\"\",VLOOKUP($G36,webquery!S:V,2,FALSE)))","v":5},{"$f":"VLOOKUP($G36,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G35","v":0}]
[{"$f":"BLANKS!A36","v":"Charl Schwartzel"},{"$f":"BLANKS!B36","v":7},{"$f":"VALUE(IF($A37=\"\",\"\",VLOOKUP($A37,webquery!S:V,2,FALSE)))","v":2},{"$f":"VLOOKUP($A37,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D36","v":"Tyrrell Hatton"},{"$f":"BLANKS!E36","v":1},{"$f":"VALUE(IF($G37=\"\",\"\",VLOOKUP($G37,webquery!S:V,2,FALSE)))","v":14},{"$f":"VLOOKUP($G37,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G36","v":0}]
[{"$f":"BLANKS!A37","v":"Bill Haas"},{"$f":"BLANKS!B37","v":7},{"$f":"VALUE(IF($A38=\"\",\"\",VLOOKUP($A38,webquery!S:V,2,FALSE)))","v":3},{"$f":"VLOOKUP($A38,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D37","v":"Tommy Fleetwood"},{"$f":"BLANKS!E37","v":4},{"$f":"VALUE(IF($G38=\"\",\"\",VLOOKUP($G38,webquery!S:V,2,FALSE)))","v":8},{"$f":"VLOOKUP($G38,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G37","v":0}]
[{"$f":"BLANKS!A38","v":"Alex Noren"},{"$f":"BLANKS!B38","v":6},{"$f":"VALUE(IF($A39=\"\",\"\",VLOOKUP($A39,webquery!S:V,2,FALSE)))","v":8},{"$f":"VLOOKUP($A39,webquery!$S:V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!D38","v":"Soren Kjeldsen"},{"$f":"BLANKS!E38","v":3},{"$f":"VALUE(IF($G39=\"\",\"\",VLOOKUP($G39,webquery!S:V,2,FALSE)))","v":1},{"$f":"VLOOKUP($G39,webquery!$S:$V,4,FALSE)","v":"18"},1.5,null,{"$f":"BLANKS!G38","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":2},{"$f":"IF(ISERROR(C40-B34/100),\"\",C40-B34/100)","v":1.9419999999999999},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":12},{"$f":"IF(ISERROR(I40-H34/100),\"\",I40-H34/100)","v":11.962},null,null,"Best 3"]
["Running position",null,{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,4,FALSE)","v":3},{"$f":"VLOOKUP(A34,ranks!$C$4:$G$14,5,FALSE)","v":3},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G34,ranks!$C$4:$G$14,4,FALSE)","v":8},{"$f":"VLOOKUP(G34,ranks!$C$4:$G$14,5,FALSE)","v":8},"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"]