{"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":0.26588315823793696},{"$f":"RAND()","v":0.78980601637732795},0.7601589377186535,3.7430643743407654E-2,0.79107814717682245,0.75001533417173205]
["R2",1.7594441988339038E-2,0.97005494750695198,0.3705773003356867,0.89507012731877,0.73703726738739517,0.60213918756623164]
["R3",0.65720471570645533,0.56528506556801916,0.53730809678855895,0.96011860216932265,0.17423236812066034,0.25949522835186678]
["R4",0.27458551257870945,0.28916834546511327,0.92443826673142215,0.22818707094642199,0.64610896894069958,2.2809885999358959E-2]
["R5",0.21995825104318201,0.76694237456016012,0.34644697436429595,0.34656980341327714,0.37677272334687928,0.21306141570942716]
["R1",{"$f":"RANK(B5,$B5:$L5)","v":5},2,3,6,1,4]
["R2",6,1,5,2,3,4]
["R3",2,3,4,1,6,5]
["R4",4,3,1,5,2,6]
["R5",5,1,4,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":7.8053460524089902E-2},{"$f":"RAND()","v":0.51437653795783544},0.31679916902650673,0.30826023866611119,0.37030614710873089,0.25232616922416162,0.45318284357022698]
["R2",0.40077658154850004,0.72579994925196811,0.84737842781910699,0.74385856419747787,2.2108205406238257E-3,0.15530528082285977,0.88466529900266744]
["R3",0.54566469220395741,0.70559251403200385,0.90473068089978359,0.5877779415072566,0.91982360138684582,0.97170463083776326,0.41000175575543041]
["R4",0.44889381221009672,0.91035161947263821,0.98915965591622357,0.47664566928762786,0.68265328629917288,8.9646382864225105E-2,0.25401117382832317]
["R5",0.46252505208177608,6.5492402860202414E-2,0.22246612119284936,0.21858126246040388,0.32596480681933604,0.64935913723662764,0.43732397825814184]
["R1",{"$f":"RANK(B16,$B16:$L16)","v":7},1,4,5,3,6,2]
["R2",5,4,2,3,7,6,1]
["R3",6,4,3,5,2,1,7]
["R4",5,2,1,4,3,7,6]
["R5",2,7,5,6,4,1,3]
[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.54985485513280086},{"$f":"RAND()","v":0.13210848769161443},0.17838270002598122,0.22722825886738551,0.46743839983029389,0.48417037012578545,0.72000520706640625,0.23690727388692989]
["R2",0.67452140414116823,0.50519369015707993,0.27827577034386297,0.30503964487009372,0.70436613199741471,0.88162959927590046,0.26767073792585927,6.1504778011399752E-3]
["R3",0.22305417679404893,0.79348063281186554,0.71181503368688381,0.14948698109359471,0.31589509886496825,0.1688326479334421,0.88330138901543265,3.6596937083647196E-2]
["R4",0.81031553261062028,0.56377600114936888,7.0445360332905271E-2,0.54834053509876979,0.25238890940947645,0.14782039542221981,0.41014725113134187,0.98393064565898603]
["R5",0.10009190246978583,0.66375118673109423,0.61366030282066353,0.39388451446677986,0.17212675060095695,0.50207164303742868,0.39958771040767171,0.72328481170851178]
["R1",{"$f":"RANK(B27,$B27:$L27)","v":2},8,7,6,4,3,1,{"$f":"RANK(I27,$B27:$L27)","v":5}]
["R2",3,4,6,5,2,1,7,8]
["R3",5,2,3,7,4,6,1,8]
["R4",2,3,8,4,6,7,5,1]
["R5",8,2,3,6,7,4,5,1]
[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.36250107446715352},0.36811720346700039,0.89107004794417444,0.64264957949441626,0.40901689164203503,0.72380184073844556,0.95675810038123554,0.61364488583060794,0.62797725242259494]
["R2",0.60190812621931067,0.10554633633018584,0.32190454516776701,0.3940753777896806,0.53526135239762462,0.7403682687039046,0.32462824308904048,0.30856572859782105,0.54835880935305081]
["R3",0.95073139214539082,0.65135295901328416,0.31773111411759047,0.16430825096803992,0.29666753838533355,0.39104367460271861,0.82301625268528611,0.22025411590035548,0.70057966861872933]
["R4",0.69985636592825418,0.90590897053866304,0.18180099217097723,0.84444252352619109,0.49068441852849831,0.50157686960763115,0.72703184881774441,0.20232106451924214,0.46243215417808048]
["R5",0.64662170787576179,0.94329535778306473,0.31371550368888701,0.29106826037515066,0.95901263815067517,0.56923083019827836,0.24272637022766552,0.85538744726545934,0.540778259893401]
["R1",{"$f":"RANK(B38,$B38:$L38)","v":9},8,2,4,7,3,1,6,5]
["R2",{"$f":"RANK(B39,$B39:$L39)","v":2},9,7,5,4,1,6,8,3]
["R3",{"$f":"RANK(B40,$B40:$L40)","v":1},4,6,9,7,5,2,8,3]
["R4",{"$f":"RANK(B41,$B41:$L41)","v":4},1,9,2,6,5,3,8,7]
["R5",{"$f":"RANK(B42,$B42:$L42)","v":4},2,7,8,1,5,9,3,6]
[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.30029926377134775},0.98201113090294634,0.91556059751786034,0.61748133043545084,0.81284552136317512,0.18019043166965776,0.36708174786493708,0.91427492898120732,0.76916436512895969,0.76564666364440181]
["R2",0.63860251043398697,0.50322381055982746,0.27275721986206725,4.6854741425299884E-2,0.67274962804798566,0.69849522903262029,0.53231504118618944,0.58454436240968932,0.66206052435223739,0.64526481970452021]
["R3",0.8679903082816004,0.85736938453691458,0.86968939172319659,0.48846135955122927,0.17866686898468453,0.58919212565875545,5.5167670510705591E-2,0.32351197827647582,0.8795123515318326,0.36545910955817174]
["R4",0.82720117797673665,0.44725145285009571,0.38949719909272573,0.37261193747379762,0.68761709556457329,0.32019067111140975,5.0518167314702933E-2,0.88425749783948071,6.1385353393097586E-2,0.62637102676200174]
["R5",0.29407172924222302,0.79744737231053531,0.59793528979719912,8.4376124375907802E-2,0.73388815121401985,4.3180703244503738E-2,0.20797272148400492,0.16534382875612541,0.43098261010940919,0.7735622757605104]
["R1",{"$f":"RANK(B49,$B49:$L49)","v":9},1,2,7,4,10,8,3,5,{"$f":"RANK(K49,$B49:$L49)","v":6}]
["R2",{"$f":"RANK(B50,$B50:$L50)","v":5},8,9,10,2,1,7,6,3,{"$f":"RANK(K50,$B50:$L50)","v":4}]
["R3",{"$f":"RANK(B51,$B51:$L51)","v":3},4,2,6,9,5,10,8,1,{"$f":"RANK(K51,$B51:$L51)","v":7}]
["R4",{"$f":"RANK(B52,$B52:$L52)","v":2},5,6,7,3,8,10,1,9,{"$f":"RANK(K52,$B52:$L52)","v":4}]
["R5",{"$f":"RANK(B53,$B53:$L53)","v":6},1,4,9,3,10,7,8,5,{"$f":"RANK(K53,$B53:$L53)","v":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]
["R1",{"$f":"RAND()","v":0.75748110870140428},0.62366797169482258,0.83159523765205123,0.75200867742161404,0.66975762369269753,0.21038806098655871,0.58375079909629135,0.7874402419033264,0.4349008055420478,3.5420162303369529E-2,0.41552611437375353]
["R2",0.31271849450347255,0.693561927315825,2.0748996126169761E-3,0.64429463036148971,0.91365009614136061,0.74434405397027947,0.85371022494489057,0.37937992932944109,0.68451281570343703,0.35772065667288866,0.33282804915597575]
["R3",6.2369125734697994E-2,0.18733280523632945,0.99183379735041521,0.73136461009731779,0.74039213328661568,0.81215280024952208,0.10362488307298667,0.9274856936235587,0.1247705205764027,0.53241645994699227,0.34395017120231686]
["R4",0.8430201444857639,0.27289008259361258,0.13312675519113271,0.33448242489629898,0.59502529605713506,0.71980149699496043,0.72544115252657126,0.17356007687305364,2.773495790224878E-2,0.56908542355633684,0.28272173991225258]
["R5",0.41463557734811196,0.83684479505520482,0.79654555082379674,0.37960787752931158,0.10314556484196735,0.22405998808348326,0.70065969897927516,0.46792227707150658,0.20196534021983115,0.38652770884032406,0.67560285634683082]
["R1",{"$f":"RANK(B60,$B60:$L60)","v":3},6,1,4,5,10,7,2,8,{"$f":"RANK(K60,$B60:$L60)","v":11},9]
["R2",{"$f":"RANK(B61,$B61:$L61)","v":10},4,11,6,1,3,2,7,5,{"$f":"RANK(K61,$B61:$L61)","v":8},9]
["R3",{"$f":"RANK(B62,$B62:$L62)","v":11},8,1,5,4,3,10,2,9,{"$f":"RANK(K62,$B62:$L62)","v":6},7]
["R4",{"$f":"RANK(B63,$B63:$L63)","v":1},8,10,6,4,3,2,9,11,{"$f":"RANK(K63,$B63:$L63)","v":5},7]
["R5",{"$f":"RANK(B64,$B64:$L64)","v":6},1,2,8,11,9,3,5,10,{"$f":"RANK(K64,$B64:$L64)","v":7},4]
[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.68511063964538299,0.69215924379759364,0.64132431665684941,0.65332259292248906,0.94938865837996955,0.66639614761341415,0.2299439945172338,0.1341781805601252,0.93330056045536725,2.7308580535074789E-3,0.97182356496190769,0.44156658635006807]
["R2",0.4252364121056873,0.18331018921521847,0.25093569009546346,0.99688347461252946,0.89635795447279576,0.40796034861319086,0.19767484848384864,0.39712382213627961,0.33768329390050089,0.23713095318766242,0.36673642777828908,0.65846506715090192]
["R3",0.59037173721416136,0.80575806499342573,0.77434367177481556,4.3803478583731237E-2,0.96751224474991193,0.95732592174804598,0.6204259827693992,0.71421051203578678,0.60275858341657862,0.6848631950531352,0.60010535494883399,0.22170716511693556]
["R4",7.9889075114912278E-2,0.42069746110663409,0.77057551169508887,9.1815413299681015E-2,9.3605080437942245E-2,0.35173863681128181,0.253935143835471,0.87068893261467861,0.88784466032328124,0.87745686592056915,0.53448639291885358,0.7449232374814061]
["R5",0.44819027339447626,5.5749896550034372E-2,0.63840273330030395,0.82341110517162275,0.94621807557185622,0.17827964710177435,0.8864766956847463,0.45787833310792414,0.29729807253303997,7.3170508343148866E-3,0.58403686483602013,0.69114244632857125]
["R1",{"$f":"RANK(B71,$B71:$M71)","v":5},4,8,7,2,6,10,11,3,{"$f":"RANK(K71,$B71:$M71)","v":12},1,9]
["R2",{"$f":"RANK(B72,$B72:$M72)","v":4},12,9,1,2,5,11,6,8,{"$f":"RANK(K72,$B72:$M72)","v":10},7,3]
["R3",{"$f":"RANK(B73,$B73:$M73)","v":10},3,4,12,1,2,7,5,8,{"$f":"RANK(K73,$B73:$M73)","v":6},9,11]
["R4",{"$f":"RANK(B74,$B74:$M74)","v":12},7,4,11,10,8,9,3,1,{"$f":"RANK(K74,$B74:$M74)","v":2},6,5]
["R5",{"$f":"RANK(B75,$B75:$M75)","v":8},11,5,3,1,10,2,7,9,{"$f":"RANK(K75,$B75:$M75)","v":12},6,4]
[]
[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.50414579923608893},0.77210103824017351,0.36175025906582781,0.61324285588184257,0.23409284721909496,0.6086264784980272,0.19378730846421455,0.92680581226913472,0.71387749845088611,0.85742790299166494,0.94048672737729921,0.79269182070596489,1.9853004541030228E-2]
["R2",0.22373849659888334,0.46738915689591309,0.59305772347913333,0.92464720021987057,0.43583633523853893,0.62394882943700924,0.48778781612341138,0.70083346212675612,0.15750185861181298,0.57025893178025522,0.85912096043473463,0.18368293953804304,0.21745149105755401]
["R3",0.89870063940325606,0.52408558159869101,1.794591317085048E-2,0.39503390375147573,0.49021386836101222,0.60968978929559337,0.43221807691890823,0.95661346571716954,0.93795657085209716,0.30910452013451106,0.25807765207250077,0.11282952553848857,0.35113567077036778]
["R4",0.11473746122009088,8.8628617016760169E-2,0.47748762030045533,0.91985960323245786,0.35131200447750932,0.18548113179122161,0.53080507070197858,0.10894733028173142,0.74143268018264963,0.1915370045361986,0.77271150711512804,0.33289737970955247,0.18485706769655808]
["R5",0.28998683675140002,0.64002674927996295,0.65783865060669244,0.74565284575888668,0.62344483601490763,0.57347800671876414,0.95094319289108686,0.96704000673303858,0.3880912794087451,0.42474110597980674,0.58688002109932846,0.21190223566616606,0.84023784192516915]
["R1",{"$f":"RANK(B83,$B83:$N83)","v":9},5,10,7,11,8,12,2,6,{"$f":"RANK(K83,$B83:$N83)","v":3},1,4,13]
["R2",{"$f":"RANK(B84,$B84:$N84)","v":10},8,5,1,9,4,7,3,13,{"$f":"RANK(K84,$B84:$N84)","v":6},2,12,11]
["R3",{"$f":"RANK(B85,$B85:$N85)","v":3},5,13,8,6,4,7,1,2,{"$f":"RANK(K85,$B85:$N85)","v":10},11,12,9]
["R4",{"$f":"RANK(B86,$B86:$N86)","v":11},13,5,1,6,9,4,12,3,{"$f":"RANK(K86,$B86:$N86)","v":8},2,7,10]
["R5",{"$f":"RANK(B87,$B87:$N87)","v":12},6,5,4,7,9,2,1,11,{"$f":"RANK(K87,$B87:$N87)","v":10},8,13,3]
[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",0.47055002787352673,0.53076862534309166,0.42574301281216786,0.49087829715780851,0.35749494499439605,0.72597554667569875,8.1890934744159871E-2,1.1513056071146721E-2,0.10310792127406443,0.74933390063517735,0.86980448024456791,1.9121314888222996E-2,3.71629723389445E-2,0.21895999334972971]
["R2",7.5782510255077762E-2,0.47732542703114988,7.2542228967200528E-2,0.72316384012924873,0.80024717388431177,0.36150394706569677,0.42687333930441651,6.8919565980252839E-2,0.31117658008587845,0.57453014209277897,1.053190348690991E-2,6.4697990183711918E-3,0.42064523732961301,0.37941165260526499]
["R3",0.7807523176063409,0.50826689731079533,0.12340020469793378,0.59430374473638292,0.10550204242262773,0.31442041740982829,0.995295286054518,0.21257455173882722,0.89213287194978563,0.84513749269086225,0.70017683093553928,0.49944249438118338,0.6061694962496943,0.77058789277805473]
["R4",0.59208678947451987,0.7514015121712494,0.46562175305522324,0.76337150478175897,0.16985373134773407,0.96896643508167279,4.1794211324173158E-3,0.4974563011119153,0.10049402612255942,0.27081579922263088,5.0252865941594616E-2,0.94872688997913268,0.11106601731043408,0.67289201409367205]
["R5",0.34601177017153306,0.2397277087125288,0.54341873075415714,0.52359140487943145,5.4915431315521235E-2,0.99199899006268566,0.37454622303582874,0.24782140620284077,0.58981835930983895,0.82511956706875667,0.60020175391517983,0.69318728963706355,0.21458914109339655,0.15635010990143794]
["R1",{"$f":"RANK(B94,$B94:$O94)","v":6},4,7,5,8,3,11,14,10,{"$f":"RANK(K94,$B94:$O94)","v":2},1,13,12,9]
["R2",{"$f":"RANK(B95,$B95:$O95)","v":10},4,11,2,1,8,5,12,9,{"$f":"RANK(K95,$B95:$O95)","v":3},13,14,6,7]
["R3",{"$f":"RANK(B96,$B96:$O96)","v":4},9,13,8,14,11,1,12,2,{"$f":"RANK(K96,$B96:$O96)","v":3},6,10,7,5]
["R4",{"$f":"RANK(B97,$B97:$O97)","v":6},4,8,3,10,1,14,7,12,{"$f":"RANK(K97,$B97:$O97)","v":9},13,2,11,5]
["R5",{"$f":"RANK(B98,$B98:$O98)","v":9},11,6,7,14,1,8,10,5,{"$f":"RANK(K98,$B98:$O98)","v":2},4,3,12,13]
[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":0.35356996765791882},0.90676475716149108,0.55675599891139727,9.2377848283050956E-2,0.29448356841835999,0.63492465417884147,0.22136237539668346,0.33560455721128235,0.68291586386838166,0.99255303079432489,0.23220072625177246,3.0638102372663845E-2,0.42778015358296129,0.23128118196770486,0.28369739731711585]
["R2",0.92526217483552997,0.22577850151870038,0.36324948651674238,0.99091734520032593,4.4804765515749301E-2,0.36858018255254099,4.6258760704220969E-2,0.35920320309135267,0.41233471816254541,0.63519577700990204,0.42956955269234209,0.93490522106241136,0.9587882008130596,4.6603921134024118E-3,0.20320012220828365]
["R3",0.17149346859799031,0.56744669116662627,0.94112355254005098,0.29261497429992422,0.42122162998607748,6.590230246668638E-2,0.855053220329823,0.16206430092925839,0.54716341340153274,0.63973427720345533,0.41645073393216958,0.28274221700029434,0.82075005051378336,0.76548978751179775,0.74864712997367278]
["R4",0.80244111202051982,0.43146555835526457,0.37138884635047276,0.61311952200660202,0.67140656248248376,0.2292769068746533,0.81929135550541321,0.71356214978470889,0.42521674536220899,0.44526607885589853,0.87733934265836788,0.52170416269844211,0.44241127653466772,0.24311963967325412,0.97504860298013973]
["R5",0.8969275089343679,0.21517973913912736,0.27449417576294688,0.26279340075608593,0.78471795654058107,0.69323753753818607,0.76082145288053393,0.80681270696601282,0.54545530747687809,0.92444853436314667,0.50349194115399876,0.86677172653234291,0.46506407542591999,0.62458804224730746,0.46941728254981385]
["R1",{"$f":"RANK(B105,$B105:$P105)","v":7},2,5,14,9,4,13,8,3,{"$f":"RANK(K105,$B105:$P105)","v":1},11,15,6,12,10]
["R2",{"$f":"RANK(B106,$B106:$P106)","v":4},11,9,1,14,8,13,10,7,{"$f":"RANK(K106,$B106:$P106)","v":5},6,3,2,15,12]
["R3",{"$f":"RANK(B107,$B107:$P107)","v":13},7,1,11,9,15,2,14,8,{"$f":"RANK(K107,$B107:$P107)","v":6},10,12,3,4,5]
["R4",{"$f":"RANK(B108,$B108:$P108)","v":4},11,13,7,6,15,3,5,12,{"$f":"RANK(K108,$B108:$P108)","v":9},2,8,10,14,1]
["R5",{"$f":"RANK(B109,$B109:$P109)","v":2},15,13,14,5,7,6,4,9,{"$f":"RANK(K109,$B109:$P109)","v":1},10,3,12,8,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":3},{"$f":"INDEX(results!$A$7:$Q$42,$A4+6,$B4+3)","v":2.968},{"$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":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},6,{"$f":"IF(ISERROR(RANK(E5,$E$4:$E$14,1)),\"\",RANK(E5,$E$4:$E$14,1))","v":6}]
[{"$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":-1},{"$f":"INDEX(results!$A$7:$Q$42,$A6+6,$B6+3)","v":-1.046},2,3]
[{"$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":-1},{"$f":"INDEX(results!$A$7:$Q$42,$A7+6,$B7+3)","v":-1.0580000000000001},2,2]
[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":-3},{"$f":"INDEX(results!$A$7:$Q$42,$A8+6,$B8+3)","v":-3.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":2},{"$f":"INDEX(results!$A$7:$Q$42,$A9+6,$B9+3)","v":1.958},4,4]
[{"$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":2},{"$f":"INDEX(results!$A$7:$Q$42,$A10+6,$B10+3)","v":1.96},4,5]
[{"$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":4},{"$f":"INDEX(results!$A$7:$Q$42,$A11+6,$B11+3)","v":3.9620000000000002},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,"Marco",6,6,1,1]
[null,1,"Steve",6,6,1,1]
[null,1,"Craig",13,13,3,3]
[null,1,"Simmo",13,13,3,3]
[null,13,"Terry",13,13,3,3]
[null,7,"Fred / Keith",16,16,6,6]
[null,1,"Grant",20,20,7,7]
[null,7,"Stuart",22,22,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,"Thomas Pieters","-2","17","-2","-","-","-","-","-","-",null,null,null,null,null,2,{"$f":"SUBSTITUTE(INDEX($A$4:$J$159,R5,$S$2),\"*\",\"\")","v":"Thomas Pieters"},{"$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":"-2"},{"$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":-1.7916666666666667},{"$f":"INDEX($A$4:$N$159,R5,$V$2)","v":"17"}]
[null,1,"Matthew Fitzpatrick","-2","14","-2","-","-","-","-","-","-",null,null,null,null,null,3,"Matthew Fitzpatrick","-2",-1.7916666666666667,"14"]
[null,1,"Justin Rose","-2","13","-2","-","-","-","-","-","-",null,null,null,null,null,4,"Justin Rose","-2",-1.7916666666666667,"13"]
[null,1,"William McGirt","-2","13","-2","-","-","-","-","-","-",null,null,null,null,null,5,"William McGirt","-2",-1.7916666666666667,"13"]
[null,5,"Russell Henley","-1","18","-1","71","-","-","-","71","-",null,null,null,null,null,6,"Russell Henley","-1",-0.79166666666666663,"18"]
[null,5,"Kevin Chappell","-1","18","-1","71","-","-","-","71","-",null,null,null,null,null,7,"Kevin Chappell","-1",-0.79166666666666663,"18"]
[null,5,"Andy Sullivan","-1","18","-1","71","-","-","-","71","-",null,null,null,null,null,8,"Andy Sullivan","-1",-0.79166666666666663,"18"]
[null,5,"Rickie Fowler","-1","16","-1","-","-","-","-","-","-",null,null,null,null,null,9,"Rickie Fowler","-1",-0.79166666666666663,"16"]
[null,5,"Jason Dufner","-1","9","-1","-","-","-","-","-","-",null,null,null,null,null,10,"Jason Dufner","-1",-0.79166666666666663,"9"]
[null,5,"Shane Lowry","-1","5","-1","-","-","-","-","-","-",null,null,null,null,null,11,"Shane Lowry","-1",-0.79166666666666663,"5"]
[null,5,"Marc Leishman","-1","4","-1","-","-","-","-","-","-",null,null,null,null,null,12,"Marc Leishman","-1",-0.79166666666666663,"4"]
[null,5,"Bill Haas","-1","3","-1","-","-","-","-","-","-",null,null,null,null,null,13,"Bill Haas","-1",-0.79166666666666663,"3"]
[null,13,"Soren Kjeldsen","E","18","E","72","-","-","-","72","-",null,null,null,null,null,14,"Soren Kjeldsen",0,"","18"]
[null,13,"Paul Casey","E","16","E","-","-","-","-","-","-",null,null,null,null,null,15,"Paul Casey",0,"","16"]
[null,13,"Brooks Koepka","E","15","E","-","-","-","-","-","-",null,null,null,null,null,16,"Brooks Koepka",0,"","15"]
[null,13,"Jordan Spieth","E","14","E","-","-","-","-","-","-",null,null,null,null,null,17,"Jordan Spieth",0,"","14"]
[null,13,"Phil Mickelson","E","14","E","-","-","-","-","-","-",null,null,null,null,null,18,"Phil Mickelson",0,"","14"]
[null,13,"Ross Fisher","E","11","E","-","-","-","-","-","-",null,null,null,null,null,19,"Ross Fisher",0,"","11"]
[null,13,"Chris Wood","E","6","E","-","-","-","-","-","-",null,null,null,null,null,20,"Chris Wood",0,"","6"]
[null,13,"Charley Hoffman","E","6","E","-","-","-","-","-","-",null,null,null,null,null,21,"Charley Hoffman",0,"","6"]
[null,13,"Sergio Garcia","E","5","E","-","-","-","-","-","-",null,null,null,null,null,22,"Sergio Garcia",0,"","5"]
[null,13,"Alex Noren","E","4","E","-","-","-","-","-","-",null,null,null,null,null,23,"Alex Noren",0,"","4"]
[null,13,"Jon Rahm","E","4","E","-","-","-","-","-","-",null,null,null,null,null,24,"Jon Rahm",0,"","4"]
[null,24,"Scott Piercy","1","18","1","73","-","-","-","73","-",null,null,null,null,null,25,"Scott Piercy","1",1.2083333333333333,"18"]
[null,24,"Si Woo Kim","1","14","1","-","-","-","-","-","-",null,null,null,null,null,26,"Si Woo Kim","1",1.2083333333333333,"14"]
[null,24,"James Hahn","1","12","1","-","-","-","-","-","-",null,null,null,null,null,27,"James Hahn","1",1.2083333333333333,"12"]
[null,24,"Byeong-Hun An","1","11","1","-","-","-","-","-","-",null,null,null,null,null,28,"Byeong-Hun An","1",1.2083333333333333,"11"]
[null,24,"Ryan Moore","1","10","1","-","-","-","-","-","-",null,null,null,null,null,29,"Ryan Moore","1",1.2083333333333333,"10"]
[null,24,"Jose Maria Olazabal","1","10","1","-","-","-","-","-","-",null,null,null,null,null,30,"Jose Maria Olazabal","1",1.2083333333333333,"10"]
[null,24,"Webb Simpson","1","10","1","-","-","-","-","-","-",null,null,null,null,null,31,"Webb Simpson","1",1.2083333333333333,"10"]
[null,24,"Angel Cabrera","1","7","1","-","-","-","-","-","-",null,null,null,null,null,32,"Angel Cabrera","1",1.2083333333333333,"7"]
[null,24,"Yuta Ikeda","1","6","1","-","-","-","-","-","-",null,null,null,null,null,33,"Yuta Ikeda","1",1.2083333333333333,"6"]
[null,24,"Lee Westwood","1","5","1","-","-","-","-","-","-",null,null,null,null,null,34,"Lee Westwood","1",1.2083333333333333,"5"]
[null,24,"Bernhard Langer","1","4","1","-","-","-","-","-","-",null,null,null,null,null,35,"Bernhard Langer","1",1.2083333333333333,"4"]
[null,24,"Justin Thomas","1","3","1","-","-","-","-","-","-",null,null,null,null,null,36,"Justin Thomas","1",1.2083333333333333,"3"]
[null,36,"Daniel Summerhays","2","18","2","74","-","-","-","74","-",null,null,null,null,null,37,"Daniel Summerhays","2",2.2083333333333335,"18"]
[null,36,"Brendan Steele","2","18","2","74","-","-","-","74","-",null,null,null,null,null,38,"Brendan Steele","2",2.2083333333333335,"18"]
[null,36,"Stewart Hagestad","2","18","2","74","-","-","-","74","-",null,null,null,null,null,39,"Stewart Hagestad","2",2.2083333333333335,"18"]
[null,36,"Larry Mize","2","18","2","74","-","-","-","74","-",null,null,null,null,null,40,"Larry Mize","2",2.2083333333333335,"18"]
[null,36,"Kevin Kisner","2","18","2","74","-","-","-","74","-",null,null,null,null,null,41,"Kevin Kisner","2",2.2083333333333335,"18"]
[null,36,"Fred Couples","2","16","2","-","-","-","-","-","-",null,null,null,null,null,42,"Fred Couples","2",2.2083333333333335,"16"]
[null,36,"Rod Pampling","2","13","2","-","-","-","-","-","-",null,null,null,null,null,43,"Rod Pampling","2",2.2083333333333335,"13"]
[null,36,"Bernd Wiesberger","2","9","2","-","-","-","-","-","-",null,null,null,null,null,44,"Bernd Wiesberger","2",2.2083333333333335,"9"]
[null,36,"Danny Willett","2","9","2","-","-","-","-","-","-",null,null,null,null,null,45,"Danny Willett","2",2.2083333333333335,"9"]
[null,36,"Curtis Luck","2","9","2","-","-","-","-","-","-",null,null,null,null,null,46,"Curtis Luck","2",2.2083333333333335,"9"]
[null,36,"Mackenzie Hughes","2","7","2","-","-","-","-","-","-",null,null,null,null,null,47,"Mackenzie Hughes","2",2.2083333333333335,"7"]
[null,36,"Patrick Reed","2","4","2","-","-","-","-","-","-",null,null,null,null,null,48,"Patrick Reed","2",2.2083333333333335,"4"]
[null,36,"Hideto Tanihara","2","4","2","-","-","-","-","-","-",null,null,null,null,null,49,"Hideto Tanihara","2",2.2083333333333335,"4"]
[null,36,"Rory McIlroy","2","4","2","-","-","-","-","-","-",null,null,null,null,null,50,"Rory McIlroy","2",2.2083333333333335,"4"]
[null,36,"Bubba Watson","2","3","2","-","-","-","-","-","-",null,null,null,null,null,51,"Bubba Watson","2",2.2083333333333335,"3"]
[null,36,"Jimmy Walker","2","3","2","-","-","-","-","-","-",null,null,null,null,null,52,"Jimmy Walker","2",2.2083333333333335,"3"]
[null,52,"Billy Hurley III","3","18","3","75","-","-","-","75","-",null,null,null,null,null,53,"Billy Hurley III","3",3.2083333333333335,"18"]
[null,52,"Adam Hadwin","3","18","3","75","-","-","-","75","-",null,null,null,null,null,54,"Adam Hadwin","3",3.2083333333333335,"18"]
[null,52,"Gary Woodland","3","18","3","75","-","-","-","75","-",null,null,null,null,null,55,"Gary Woodland","3",3.2083333333333335,"18"]
[null,52,"Adam Scott","3","18","3","75","-","-","-","75","-",null,null,null,null,null,56,"Adam Scott","3",3.2083333333333335,"18"]
[null,52,"Hideki Matsuyama","3","15","3","-","-","-","-","-","-",null,null,null,null,null,57,"Hideki Matsuyama","3",3.2083333333333335,"15"]
[null,52,"Russell Knox","3","16","3","-","-","-","-","-","-",null,null,null,null,null,58,"Russell Knox","3",3.2083333333333335,"16"]
[null,52,"Rafa Cabrera Bello","3","14","3","-","-","-","-","-","-",null,null,null,null,null,59,"Rafa Cabrera Bello","3",3.2083333333333335,"14"]
[null,52,"Brandt Snedeker","3","13","3","-","-","-","-","-","-",null,null,null,null,null,60,"Brandt Snedeker","3",3.2083333333333335,"13"]
[null,52,"Jason Day","3","13","3","-","-","-","-","-","-",null,null,null,null,null,61,"Jason Day","3",3.2083333333333335,"13"]
[null,52,"Mark O'Meara","3","12","3","-","-","-","-","-","-",null,null,null,null,null,62,"Mark O'Meara","3",3.2083333333333335,"12"]
[null,52,"Roberto Castro","3","12","3","-","-","-","-","-","-",null,null,null,null,null,63,"Roberto Castro","3",3.2083333333333335,"12"]
[null,52,"Pat Perez","3","11","3","-","-","-","-","-","-",null,null,null,null,null,64,"Pat Perez","3",3.2083333333333335,"11"]
[null,52,"Ernie Els","3","10","3","-","-","-","-","-","-",null,null,null,null,null,65,"Ernie Els","3",3.2083333333333335,"10"]
[null,52,"Matt Kuchar","3","9","3","-","-","-","-","-","-",null,null,null,null,null,66,{"$f":"SUBSTITUTE(INDEX($A$4:$J$159,R69,$S$2),\"*\",\"\")","v":"Matt Kuchar"},{"$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":"3"},{"$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":3.2083333333333335},{"$f":"INDEX($A$4:$N$159,R69,$V$2)","v":"9"}]
[null,52,"Vijay Singh","3","8","3","-","-","-","-","-","-",null,null,null,null,null,67,"Vijay Singh","3",3.2083333333333335,"8"]
[null,52,"Charl Schwartzel","3","7","3","-","-","-","-","-","-",null,null,null,null,null,68,"Charl Schwartzel","3",3.2083333333333335,"7"]
[null,52,"Steve Stricker","3","7","3","-","-","-","-","-","-",null,null,null,null,null,69,"Steve Stricker","3",3.2083333333333335,"7"]
[null,69,"Mike Weir","4","18","4","76","-","-","-","76","-",null,null,null,null,null,70,"Mike Weir","4",4.208333333333333,"18"]
[null,69,"Sean O'Hair","4","18","4","76","-","-","-","76","-",null,null,null,null,null,71,"Sean O'Hair","4",4.208333333333333,"18"]
[null,69,"Daniel Berger","4","17","4","-","-","-","-","-","-",null,null,null,null,null,72,"Daniel Berger","4",4.208333333333333,"17"]
[null,69,"Kevin Na","4","16","4","-","-","-","-","-","-",null,null,null,null,null,73,"Kevin Na","4",4.208333333333333,"16"]
[null,69,"Branden Grace","4","15","4","-","-","-","-","-","-",null,null,null,null,null,74,"Branden Grace","4",4.208333333333333,"15"]
[null,69,"Hudson Swafford","4","12","4","-","-","-","-","-","-",null,null,null,null,null,75,"Hudson Swafford","4",4.208333333333333,"12"]
[null,69,"Ian Woosnam","4","12","4","-","-","-","-","-","-",null,null,null,null,null,76,"Ian Woosnam","4",4.208333333333333,"12"]
[null,69,"Brad Dalke","4","12","4","-","-","-","-","-","-",null,null,null,null,null,77,"Brad Dalke","4",4.208333333333333,"12"]
[null,69,"Emiliano Grillo","4","8","4","-","-","-","-","-","-",null,null,null,null,null,78,"Emiliano Grillo","4",4.208333333333333,"8"]
[null,69,"Henrik Stenson","4","7","4","-","-","-","-","-","-",null,null,null,null,null,79,"Henrik Stenson","4",4.208333333333333,"7"]
[null,69,"Tyrrell Hatton","4","7","4","-","-","-","-","-","-",null,null,null,null,null,80,"Tyrrell Hatton","4",4.208333333333333,"7"]
[null,80,"Brian Stuard","5","18","5","77","-","-","-","77","-",null,null,null,null,null,81,"Brian Stuard","5",5.208333333333333,"18"]
[null,80,"Sandy Lyle","5","18","5","77","-","-","-","77","-",null,null,null,null,null,82,"Sandy Lyle","5",5.208333333333333,"18"]
[null,80,"Louis Oosthuizen","5","18","5","77","-","-","-","77","-",null,null,null,null,null,83,"Louis Oosthuizen","5",5.208333333333333,"18"]
[null,80,"Zach Johnson","5","18","5","77","-","-","-","77","-",null,null,null,null,null,84,"Zach Johnson","5",5.208333333333333,"18"]
[null,80,"Jeung-hun Wang","5","15","5","-","-","-","-","-","-",null,null,null,null,null,85,"Jeung-hun Wang","5",5.208333333333333,"15"]
[null,85,"Jhonattan Vegas","6","18","6","78","-","-","-","78","-",null,null,null,null,null,86,"Jhonattan Vegas","6",6.208333333333333,"18"]
[null,85,"Jim Furyk","6","18","6","78","-","-","-","78","-",null,null,null,null,null,87,"Jim Furyk","6",6.208333333333333,"18"]
[null,85,"J.B. Holmes","6","18","6","78","-","-","-","78","-",null,null,null,null,null,88,"J.B. Holmes","6",6.208333333333333,"18"]
[null,85,"Tommy Fleetwood","6","18","6","78","-","-","-","78","-",null,null,null,null,null,89,"Tommy Fleetwood","6",6.208333333333333,"18"]
[null,85,"Francesco Molinari","6","17","6","-","-","-","-","-","-",null,null,null,null,null,90,"Francesco Molinari","6",6.208333333333333,"17"]
[null,85,"Martin Kaymer","6","14","6","-","-","-","-","-","-",null,null,null,null,null,91,"Martin Kaymer","6",6.208333333333333,"14"]
[null,85,"Toto Gana","6","8","6","-","-","-","-","-","-",null,null,null,null,null,92,"Toto Gana","6",6.208333333333333,"8"]
[null,87,"Dustin Johnson","-","2:03 PM","-","-","-","-","-","-","-",null,null,null,null,null,93,"Dustin Johnson","-","","2:03 PM"]
[null,92,"Trevor Immelman","7","18","7","79","-","-","-","79","-",null,null,null,null,null,94,"Trevor Immelman","7",7.208333333333333,"18"]
[null,93,"Scott Gregory","10","18","10","82","-","-","-","82","-",null,null,null,null,null,95,"Scott Gregory","10",10.208333333333334,"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":2},{"$f":"VLOOKUP($A8,webquery!$S:V,4,FALSE)","v":"4"},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":-2},{"$f":"VLOOKUP($G8,webquery!$S:$V,4,FALSE)","v":"13"},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":4},{"$f":"VLOOKUP($A9,webquery!$S:V,4,FALSE)","v":"7"},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":0},{"$f":"VLOOKUP($G9,webquery!$S:$V,4,FALSE)","v":"4"},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":-2},{"$f":"VLOOKUP($A10,webquery!$S:V,4,FALSE)","v":"14"},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":-1},{"$f":"VLOOKUP($G10,webquery!$S:$V,4,FALSE)","v":"4"},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":3},{"$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":1},{"$f":"VLOOKUP($G11,webquery!$S:$V,4,FALSE)","v":"5"},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":3},{"$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":0},{"$f":"VLOOKUP($G12,webquery!$S:$V,4,FALSE)","v":"6"},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":3},{"$f":"IF(ISERROR(C13-B7/100),\"\",C13-B7/100)","v":2.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":-3},{"$f":"IF(ISERROR(I13-H7/100),\"\",I13-H7/100)","v":-3.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":6},{"$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":-1},{"$f":"VLOOKUP($A17,webquery!$S:V,4,FALSE)","v":"16"},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":5},{"$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":0},{"$f":"VLOOKUP($G18,webquery!$S:$V,4,FALSE)","v":"5"},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":2},{"$f":"VLOOKUP($A19,webquery!$S:V,4,FALSE)","v":"4"},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":0},{"$f":"VLOOKUP($G19,webquery!$S:$V,4,FALSE)","v":"15"},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":2},{"$f":"VLOOKUP($A20,webquery!$S:V,4,FALSE)","v":"3"},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":3},{"$f":"VLOOKUP($G20,webquery!$S:$V,4,FALSE)","v":"9"},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":5},{"$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":2},{"$f":"VLOOKUP($G21,webquery!$S:$V,4,FALSE)","v":"9"},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":2},{"$f":"IF(ISERROR(I22-H16/100),\"\",I22-H16/100)","v":1.958},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":6},{"$f":"VLOOKUP(A16,ranks!$C$4:$G$14,5,FALSE)","v":6},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,4,FALSE)","v":4},{"$f":"VLOOKUP(G16,ranks!$C$4:$G$14,5,FALSE)","v":4},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(M16,ranks!$C$4:$G$14,4,FALSE)","v":""},{"$f":"VLOOKUP(M16,ranks!$C$4:$G$14,5,FALSE)","v":""},"adj for pick"]
[]
[{"$f":"'random picks'!D2","v":"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":3},{"$f":"VLOOKUP($A26,webquery!$S:V,4,FALSE)","v":"15"},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":"14"},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":2},{"$f":"VLOOKUP($A27,webquery!$S:V,4,FALSE)","v":"3"},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":0},{"$f":"VLOOKUP($G27,webquery!$S:$V,4,FALSE)","v":"16"},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":-2},{"$f":"VLOOKUP($A28,webquery!$S:V,4,FALSE)","v":"17"},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":3},{"$f":"VLOOKUP($G28,webquery!$S:$V,4,FALSE)","v":"13"},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":4},{"$f":"VLOOKUP($A29,webquery!$S:V,4,FALSE)","v":"17"},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":-1},{"$f":"VLOOKUP($A30,webquery!$S:V,4,FALSE)","v":"5"},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":2},{"$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":-1},{"$f":"IF(ISERROR(C31-B25/100),\"\",C31-B25/100)","v":-1.046},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":2},{"$f":"IF(ISERROR(I31-H25/100),\"\",I31-H25/100)","v":1.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":2},{"$f":"VLOOKUP(A25,ranks!$C$4:$G$14,5,FALSE)","v":3},"adj for pick",null,"Running position",null,{"$f":"VLOOKUP(G25,ranks!$C$4:$G$14,4,FALSE)","v":4},{"$f":"VLOOKUP(G25,ranks!$C$4:$G$14,5,FALSE)","v":5},"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":"14"},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":3},{"$f":"VLOOKUP($G35,webquery!$S:$V,4,FALSE)","v":"13"},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":3},{"$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":1},{"$f":"VLOOKUP($G36,webquery!$S:$V,4,FALSE)","v":"3"},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":3},{"$f":"VLOOKUP($A37,webquery!$S:V,4,FALSE)","v":"7"},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":4},{"$f":"VLOOKUP($G37,webquery!$S:$V,4,FALSE)","v":"7"},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":-1},{"$f":"VLOOKUP($A38,webquery!$S:V,4,FALSE)","v":"3"},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":6},{"$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":0},{"$f":"VLOOKUP($A39,webquery!$S:V,4,FALSE)","v":"4"},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":0},{"$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":-1},{"$f":"IF(ISERROR(C40-B34/100),\"\",C40-B34/100)","v":-1.0580000000000001},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":4},{"$f":"IF(ISERROR(I40-H34/100),\"\",I40-H34/100)","v":3.9620000000000002},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":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"]