{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Main","New-Edit Round","New-Edit Course","All Stats","Last 5 Rounds","Course Stats","Scores","Course Data","Misc"],"not_rendered":{"charts":4,"images":20,"macros":1,"external_links":0,"defined_names":203,"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":"Main","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,1,7]]}
["Golf Stats v1.7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Lowest Round \",TEXT('All Stats'!F5,\"+0\"))","v":"Lowest Round +15"}]
[]
[]
[]
[null,{"$f":"HdcpText","v":"Current Handicap = 13,4"}]

{"sheet":"New-Edit Round","index":1,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,7,3,8],[0,0,0,28],[23,2,24,22],[3,1,3,6],[4,1,4,6],[3,9,3,10],[4,9,4,10],[3,11,3,12],[4,11,4,12],[4,7,4,8]]}
["Enter New Round or Edit Previous Round"]
[]
[null,null,0,1,2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Go Back to Main"]
[null,"Select Course",null,null,null,null,null,"Date",null,"Rating",null,"Slope",null,null,null,null,null,null,"Current Handicap =",null,null,null,{"$f":"CurrentHdcp","v":13.4}]
[null,null,null,null,null,null,null,"2006-06-26T08:18:27",null,{"$f":"Rating","v":{"$error":"#N/A"}},null,{"$f":"Slope","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,"To Enter a New Round"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Click Clear Round button."]
[null,"HOLE",1,2,3,4,5,6,7,8,9,"Out",10,11,12,13,14,15,16,17,18,"In","Total",null,"2. Select Course from dropdown."]
[null,"YARDS",{"$f":"Yards","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"3. Key Date round played."]
[null,"HDCP",{"$f":"Hdcp","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"4. Key Data into Turquoise cells."]
[null,"PAR",{"$f":"Par","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"5. Click Save as New button."]
[null,"Score",null,null,null,null,null,null,null,null,null,{"$f":"SUM(Front1)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Back1)","v":0},{"$f":"L11+V11","v":0}]
[null,"to par",{"$f":"IF(C11=\"\",0,C11-C10)","v":0},{"$f":"IF(D11=\"\",0,D11-D10)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(C12:K12)","v":0},{"$f":"IF(M11=\"\",0,M11-M10)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M12:U12)","v":0},null,null,"To Edit or View a Previous Round"]
[null,"running",{"$f":"C12","v":0},{"$f":"C13+D12","v":0},{"$f":"D13+E12","v":0},0,0,0,0,0,0,null,{"$f":"K13+M12","v":0},{"$f":"M13+N12","v":0},0,0,0,0,0,0,0,null,null,null,"1. Click the Load Round button."]
[null,"Putts",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C14:K14)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(M14:U14)","v":0},{"$f":"L14+V14","v":0},null,"2. Select the round you want to view."]
[null,"Fairway",null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(SUM(C15:K15),\"/\",COUNTIF(C10:K10,\">3\"))","v":"0/0"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(SUM(M15:U15),\"/\",COUNTIF(M10:U10,\">3\"))","v":"0/0"},{"$f":"CONCATENATE(SUM(C15:K15,M15:U15),\"/\",COUNTIF(C10:K10,\">3\")+COUNTIF(M10:U10,\">3\"))","v":"0/0"},null,"3. Click Ok."]
[null,"Sand *",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16:K16)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(M16:U16)","v":0},{"$f":"L16+V16","v":0},null,"-- only continue if you want to edit round --"]
[null,"Major Mistakes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Make changes."]
[null,"Miss Drive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Click the Overwrite Old button."]
[null,"Miss Iron"]
[null,"GIR",{"$f":"IF(C$11=\"\",0,IF(C$11-C$14<=(C$10-2),1,0))","v":0},{"$f":"IF(D$11=\"\",0,IF(D$11-D$14<=(D$10-2),1,0))","v":0},0,0,0,0,0,0,0,{"$f":"SUM(C20:K20)&\"/9\"","v":"0/9"},{"$f":"IF(M$11=\"\",0,IF(M$11-M$14<=(M$10-2),1,0))","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M20:U20)&\"/9\"","v":"0/9"},{"$f":"SUM(C20:K20,M20:U20)&\"/18\"","v":"0/18"},null,"When Keying Data"]
[null,"GIR + 1",{"$f":"IF(C$11=\"\",0,IF(C$11-C$14=(C$10-1),1,0))","v":0},{"$f":"IF(D$11=\"\",0,IF(D$11-D$14=(D$10-1),1,0))","v":0},0,0,0,0,0,0,0,{"$f":"SUM(C21:K21)&\"/9\"","v":"0/9"},{"$f":"IF(M$11=\"\",0,IF(M$11-M$14=(M$10-1),1,0))","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M21:U21)&\"/9\"","v":"0/9"},{"$f":"SUM(C21:K21,M21:U21)&\"/18\"","v":"0/18"},null,"Key # and hit enter to move to next hole."]
[null,"GIR + 2",{"$f":"IF(C$11=\"\",0,IF(C$11-C$14=C$10,1,0))","v":0},{"$f":"IF(D$11=\"\",0,IF(D$11-D$14=D$10,1,0))","v":0},0,0,0,0,0,0,0,{"$f":"SUM(C22:K22)&\"/9\"","v":"0/9"},{"$f":"IF(M$11=\"\",0,IF(M$11-M$14=M$10,1,0))","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M22:U22)&\"/9\"","v":"0/9"},{"$f":"SUM(C22:K22,M22:U22)&\"/18\"","v":"0/18"}]
[null,"GIR + 3+",{"$f":"IF(SUM(C20:C22)=0,1,0)","v":1},{"$f":"IF(SUM(D20:D22)=0,1,0)","v":1},1,1,1,1,1,1,1,{"$f":"SUM(C23:K23)&\"/9\"","v":"9/9"},{"$f":"IF(SUM(M20:M22)=0,1,0)","v":1},1,1,1,1,1,1,1,1,{"$f":"SUM(M23:U23)&\"/9\"","v":"9/9"},{"$f":"SUM(C23:K23,M23:U23)&\"/18\"","v":"18/18"},null,"To Save Picture of Scorecard"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the Copy Round button."]
[]
[null,"* - Sand is number of strokes after your first sand shot from a greenside bunker.  For example, if it took you two shots from",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How to Key Misses"]
[null,"     the bunker (we've all been there) and then two putts after that, record a 3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left","L"]
[null,null,{"$f":"C20*$C$3+C21*$D$3+C22*$E$3+C23*$F$3","v":3},{"$f":"D20*$C$3+D21*$D$3+D22*$E$3+D23*$F$3","v":3},3,3,3,3,3,3,3,null,{"$f":"M20*$C$3+M21*$D$3+M22*$E$3+M23*$F$3","v":3},3,3,3,3,3,3,3,3,null,null,null,"Right","R"]
[null,null,{"$f":"IF(C10>3,1,0)","v":{"$error":"#N/A"}},{"$f":"IF(D10>3,1,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Short","S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long","G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shank","X"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How to Key Major Mistakes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Driver",null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairway wood",null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long iron (or hybrid)",null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mid iron",null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Short iron",null,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wedge",null,"W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pitch",null,"T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chip",null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bump & Run",null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sand Shot",null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Putt",null,"P"]

{"sheet":"New-Edit Course","index":2,"n_rows":24,"n_cols":25,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[4,1,4,6],[4,7,4,8],[4,9,4,10],[3,1,3,6],[3,7,3,8],[3,9,3,10]]}
["Enter New Course or Edit Previously Entered Course"]
[]
[]
[null,"Course Name",null,null,null,null,null,"Rating",null,"Slope",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Enter a New Course"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Click Clear Course button."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Enter Course Name in cell B3."]
[null,"HOLE",1,2,3,4,5,6,7,8,9,"Out",10,11,12,13,14,15,16,17,18,"In","Total",null,"3. Enter Course Rating in cell H3."]
[null,"Yards",null,null,null,null,null,null,null,null,null,{"$f":"SUM(YardsF2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(YardsB2)","v":0},{"$f":"L8+V8","v":0},null,"4. Enter Course Slope in cell J3."]
[null,"Handicap",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Key Yards, Handicap and Par."]
[null,"Par",null,null,null,null,null,null,null,null,null,{"$f":"SUM(ParF2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(ParB2)","v":0},{"$f":"L10+V10","v":0},null,"6. Click the Save as New button."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To View or Edit a Course"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Click the Load Course button."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Select the Course you want to view."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Click ok."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-- only continue if you want to edit course --"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Make changes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Click the Overwrite Course button."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Par is Guessed based on Yards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If guess is wrong, then simply change it."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"When Keying Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key # and hit enter to move to next hole."]

{"sheet":"All Stats","index":3,"n_rows":46,"n_cols":27,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,3,6,4],[1,7,1,11],[1,1,1,5],[3,3,3,4],[5,3,5,4],[21,7,21,11],[11,1,11,5],[7,7,7,11],[17,1,17,5],[14,7,14,11],[8,1,9,5],[7,3,7,4],[1,23,1,26],[20,14,20,17],[20,18,20,21],[12,14,12,17],[12,18,12,21],[19,13,19,21],[1,13,1,21],[11,13,11,21],[2,14,2,17],[2,18,2,21]]}
[]
[null,"General Stats",null,null,null,null,null,"Average Putts by Hit vs Miss Green",null,null,null,null,"L","Iron Misses",null,null,null,null,null,null,null,null,null,"Major Mistakes"]
[null,null,null,null,null,null,null,"Par",3,4,5,"All","L",null,"Breakdown",null,null,null,"Avg Score",null,null,null,"D","Driver",null,{"$f":"SUM(IF(ISERR(SEARCH($W3,AllPenalty)),0,1))","v":13},{"$f":"Z3/SUM($Z$3:$Z$13)","v":0.14772727272727273}]
[null,"Avg Score",{"$f":"SUM(AllScore)/COUNTA(AllCourse)","v":90.125},"to par",null,{"$f":"SUM(AllToPar)/COUNTA(AllCourse)","v":19.125},null,"All",1.96,1.9111111111111112,1.9,1.9222222222222223,"R","Par",3,4,5,"All",3,4,5,"All","F","Fairway wood",null,{"$f":"SUM(IF(ISERR(SEARCH($W4,AllPenalty)),0,1))","v":7},{"$f":"Z4/SUM($Z$3:$Z$13)","v":7.9545454545454544E-2}]
[null,"Best Score",{"$f":"MIN(AllScoreTotal)","v":86},null,"to par",{"$f":"MIN(AllScoreTotal-AllParTotal)","v":15},null,"GIR",2.625,2.4545454545454546,2,2.4,"R","Left",{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M2,AllMissIron)),0,1))/SUM(1*(AllPar=O$4))","v":0.25},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M2,AllMissIron)),0,1))/SUM(1*(AllPar=P$4))","v":0.16666666666666666},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M2,AllMissIron)),0,1))/SUM(1*(AllPar=Q$4))","v":3.125E-2},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M2,AllMissIron)),0,1))/SUM(1*(AllPar>=3))","v":0.15972222222222221},{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*(AllPar=O$4))","v":1.2},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*(AllPar=P$4))","v":1.5833333333333333},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*(AllPar=Q$4))","v":0},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M3,AllMissIron)),0,1)*(AllPar>=3))","v":1.3478260869565217},"L","Long iron (or hybrid)",null,{"$f":"SUM(IF(ISERR(SEARCH($W5,AllPenalty)),0,1))","v":5},5.6818181818181816E-2]
[null,"Avg Putts",{"$f":"SUM(AllPutt)/COUNTA(AllCourse)","v":35.5},"% of stokes",null,{"$f":"C6/C4","v":0.39389736477115117},null,"Non-GIR",1.6470588235294117,1.7352941176470589,1.8571428571428572,1.7384615384615385,"G","Right",{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M4,AllMissIron)),0,1))/SUM(1*(AllPar=O$4))","v":0.45},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M4,AllMissIron)),0,1))/SUM(1*(AllPar=P$4))","v":0.33333333333333331},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M4,AllMissIron)),0,1))/SUM(1*(AllPar=Q$4))","v":0.5},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M4,AllMissIron)),0,1))/SUM(1*(AllPar>=3))","v":0.40277777777777779},{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*(AllPar=O$4))","v":0.94444444444444442},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*(AllPar=P$4))","v":1.125},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*(AllPar=Q$4))","v":1.25},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M5,AllMissIron)),0,1)*(AllPar>=3))","v":1.103448275862069},"M","Mid iron",null,{"$f":"SUM(IF(ISERR(SEARCH($W6,AllPenalty)),0,1))","v":8},9.0909090909090912E-2]
[null,"Avg # of GIRs",{"$f":"SUM((AllGIR=0)*1)/COUNTA(AllCourse)","v":4.875},"GD predicted avg",null,{"$f":"HLOOKUP(ROUND(C7,0),Misc!B5:N6,2)","v":85},null,null,null,null,null,null,"G","Long",{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M6,AllMissIron)),0,1))/SUM(1*(AllPar=O$4))","v":0.05},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M6,AllMissIron)),0,1))/SUM(1*(AllPar=P$4))","v":0.15277777777777779},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M6,AllMissIron)),0,1))/SUM(1*(AllPar=Q$4))","v":0.125},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M6,AllMissIron)),0,1))/SUM(1*(AllPar>=3))","v":0.11805555555555555},{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*(AllPar=O$4))","v":1.5},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*(AllPar=P$4))","v":1.0909090909090908},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*(AllPar=Q$4))","v":0.5},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M7,AllMissIron)),0,1)*(AllPar>=3))","v":1},"S","Short iron",null,{"$f":"SUM(IF(ISERR(SEARCH($W7,AllPenalty)),0,1))","v":13},0.14772727272727273]
[null,null,null,"Avg Score - GD",null,{"$f":"C4-F7","v":5.125},null,"Putting Breakdown",null,null,null,null,"S","Short",{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M8,AllMissIron)),0,1))/SUM(1*(AllPar=O$4))","v":0.375},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M8,AllMissIron)),0,1))/SUM(1*(AllPar=P$4))","v":0.30555555555555558},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M8,AllMissIron)),0,1))/SUM(1*(AllPar=Q$4))","v":0.15625},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M8,AllMissIron)),0,1))/SUM(1*(AllPar>=3))","v":0.29166666666666669},{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*(AllPar=O$4))","v":0.66666666666666663},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*(AllPar=P$4))","v":0.95454545454545459},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*(AllPar=Q$4))","v":1},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M9,AllMissIron)),0,1)*(AllPar>=3))","v":0.8571428571428571},"W","Wedge",null,{"$f":"SUM(IF(ISERR(SEARCH($W8,AllPenalty)),0,1))","v":4},4.5454545454545456E-2]
[null,{"$f":"IF(C4>F7,\"Either your short game is letting you down or you have blow up holes!\",\"You have a good short game, now go hit some more greens!\")","v":"Either your short game is letting you down or you have blow up holes!"},null,null,null,null,null,"Par",3,4,5,"All","S","Shank",{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M10,AllMissIron)),0,1))/SUM(1*(AllPar=O$4))","v":2.5000000000000001E-2},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M10,AllMissIron)),0,1))/SUM(1*(AllPar=P$4))","v":1.3888888888888888E-2},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M10,AllMissIron)),0,1))/SUM(1*(AllPar=Q$4))","v":3.125E-2},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M10,AllMissIron)),0,1))/SUM(1*(AllPar>=3))","v":2.0833333333333332E-2},{"$f":"SUM((AllPar=O$4)*IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*(AllPar=O$4))","v":1},{"$f":"SUM((AllPar=P$4)*IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*(AllPar=P$4))","v":2},{"$f":"SUM((AllPar=Q$4)*IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*(AllPar=Q$4))","v":2},{"$f":"SUM((AllPar>=3)*IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*AllToPar)/SUM(IF(ISERR(SEARCH($M11,AllMissIron)),0,1)*(AllPar>=3))","v":1.6666666666666667},"T","Pitch",null,{"$f":"SUM(IF(ISERR(SEARCH($W9,AllPenalty)),0,1))","v":7},7.9545454545454544E-2]
[null,null,null,null,null,null,null,"No putt",{"$f":"SUM((AllPar=I$9)*(AllPutt=0)*1)/SUM((AllPar=I$9)*1)","v":0},{"$f":"SUM((AllPar=J$9)*(AllPutt=0)*1)/SUM((AllPar=J$9)*1)","v":0},{"$f":"SUM((AllPar=K$9)*(AllPutt=0)*1)/SUM((AllPar=K$9)*1)","v":0},{"$f":"SUM((AllPutt=0)*1)/COUNTA(AllPutt)","v":0},"X","No Miss",{"$f":"SUM((AllPar=O$4)*ISBLANK(AllMissIron))/SUM(1*(AllPar=O$4))","v":0.1},{"$f":"SUM((AllPar=P$4)*ISBLANK(AllMissIron))/SUM(1*(AllPar=P$4))","v":0.22222222222222221},{"$f":"SUM((AllPar=Q$4)*ISBLANK(AllMissIron))/SUM(1*(AllPar=Q$4))","v":0.25},{"$f":"SUM((AllPar>=3)*ISBLANK(AllMissIron))/SUM(1*(AllPar>=3))","v":0.19444444444444445},{"$f":"SUM((AllPar=O$4)*ISBLANK(AllMissIron)*AllToPar)/SUM(ISBLANK(AllMissIron)*(AllPar=O$4))","v":0.25},{"$f":"SUM((AllPar=P$4)*ISBLANK(AllMissIron)*AllToPar)/SUM(ISBLANK(AllMissIron)*(AllPar=P$4))","v":1.25},{"$f":"SUM((AllPar=Q$4)*ISBLANK(AllMissIron)*AllToPar)/SUM(ISBLANK(AllMissIron)*(AllPar=Q$4))","v":1},{"$f":"SUM((AllPar>=3)*ISBLANK(AllMissIron)*AllToPar)/SUM(ISBLANK(AllMissIron)*(AllPar>=3))","v":1.0357142857142858},"C","Chip",null,{"$f":"SUM(IF(ISERR(SEARCH($W10,AllPenalty)),0,1))","v":4},4.5454545454545456E-2]
[null,null,null,null,null,null,null,"1 putt",{"$f":"SUM((AllPar=I$9)*(AllPutt=1)*1)/SUM((AllPar=I$9)*1)","v":0.32500000000000001},{"$f":"SUM((AllPar=J$9)*(AllPutt=1)*1)/SUM((AllPar=J$9)*1)","v":0.19444444444444445},{"$f":"SUM((AllPar=K$9)*(AllPutt=1)*1)/SUM((AllPar=K$9)*1)","v":0.125},{"$f":"SUM((AllPutt=1)*1)/COUNTA(AllPutt)","v":0.21527777777777779},"X",null,null,null,null,null,null,null,null,null,"B","Bump & Run",null,{"$f":"SUM(IF(ISERR(SEARCH($W11,AllPenalty)),0,1))","v":0},0]
[null,"Score by Par & Distance",null,null,null,null,null,"2 putts",{"$f":"SUM((AllPar=I$9)*(AllPutt=2)*1)/SUM((AllPar=I$9)*1)","v":0.4},{"$f":"SUM((AllPar=J$9)*(AllPutt=2)*1)/SUM((AllPar=J$9)*1)","v":0.625},{"$f":"SUM((AllPar=K$9)*(AllPutt=2)*1)/SUM((AllPar=K$9)*1)","v":0.78125},{"$f":"SUM((AllPutt=2)*1)/COUNTA(AllPutt)","v":0.59722222222222221},null,"Drive Misses",null,null,null,null,null,null,null,null,"N","Sand Shot",null,{"$f":"SUM(IF(ISERR(SEARCH($W12,AllPenalty)),0,1))","v":2},2.2727272727272728E-2]
[null,"Par","All","Short","Medium","Long",null,"3+ putts",{"$f":"SUM((AllPar=I$9)*(AllPutt>2)*1)/SUM((AllPar=I$9)*1)","v":0.27500000000000002},{"$f":"SUM((AllPar=J$9)*(AllPutt>2)*1)/SUM((AllPar=J$9)*1)","v":0.18055555555555555},{"$f":"SUM((AllPar=K$9)*(AllPutt>2)*1)/SUM((AllPar=K$9)*1)","v":9.375E-2},{"$f":"SUM((AllPutt>2)*1)/COUNTA(AllPutt)","v":0.1875},null,null,"Breakdown",null,null,null,"Avg Score",null,null,null,"P","Putt",null,{"$f":"SUM(IF(ISERR(SEARCH($W13,AllPenalty)),0,1))","v":25},0.28409090909090912]
[null,3,{"$f":"SUM((AllPar=$B14)*(AllToPar))/SUM((AllPar=$B14)*1)","v":0.875},{"$f":"SUM((AllPar=$B14)*(AllYards<150)*AllToPar)/SUM((AllPar=$B14)*(AllYards<150))","v":0.6},{"$f":"SUM((AllPar=$B14)*(AllYards>=150)*(AllYards<=190)*AllToPar)/SUM((AllPar=$B14)*(AllYards>=150)*(AllYards<=190))","v":0.8571428571428571},{"$f":"SUM((AllPar=$B14)*(AllYards>190)*AllToPar)/SUM((AllPar=$B14)*(AllYards>190))","v":1},null,null,null,null,null,null,"L","Par",3,4,5,"All",3,4,5,"All"]
[null,4,{"$f":"SUM((AllPar=$B15)*(AllToPar))/SUM((AllPar=$B15)*1)","v":1.1666666666666667},{"$f":"SUM((AllPar=$B15)*(AllYards<350)*AllToPar)/SUM((AllPar=$B15)*(AllYards<350))","v":0.8571428571428571},{"$f":"SUM((AllPar=$B15)*(AllYards>=350)*(AllYards<=410)*AllToPar)/SUM((AllPar=$B15)*(AllYards>=350)*(AllYards<=410))","v":1.1666666666666667},{"$f":"SUM((AllPar=$B15)*(AllYards>410)*AllToPar)/SUM((AllPar=$B15)*(AllYards>410))","v":1.8888888888888888},null,"Average Score to Par by GIR",null,null,null,null,"L","Left",null,{"$f":"SUM((AllPar=P$14)*IF(ISERR(SEARCH($M14,AllMissDrive)),0,1))/SUM(1*(AllPar=P$14))","v":0.2361111111111111},{"$f":"SUM((AllPar=Q$14)*IF(ISERR(SEARCH($M14,AllMissDrive)),0,1))/SUM(1*(AllPar=Q$14))","v":0.125},{"$f":"SUM((AllPar>=4)*IF(ISERR(SEARCH($M14,AllMissDrive)),0,1))/SUM(1*(AllPar>=4))","v":0.20192307692307693},null,{"$f":"SUM((AllPar=P$14)*IF(ISERR(SEARCH($M15,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar=P$14)*IF(ISERR(SEARCH($M15,AllMissDrive)),0,1))","v":0.88235294117647056},{"$f":"SUM((AllPar=Q$14)*IF(ISERR(SEARCH($M15,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar=Q$14)*IF(ISERR(SEARCH($M15,AllMissDrive)),0,1))","v":1.75},{"$f":"SUM((AllPar>=4)*IF(ISERR(SEARCH($M15,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar>=4)*IF(ISERR(SEARCH($M15,AllMissDrive)),0,1))","v":1.0476190476190477}]
[null,5,{"$f":"SUM((AllPar=$B16)*(AllToPar))/SUM((AllPar=$B16)*1)","v":1.0625},{"$f":"SUM((AllPar=$B16)*(AllYards<500)*AllToPar)/SUM((AllPar=$B16)*(AllYards<500))","v":0.5},{"$f":"SUM((AllPar=$B16)*(AllYards>=500)*(AllYards<=560)*AllToPar)/SUM((AllPar=$B16)*(AllYards>=500)*(AllYards<=560))","v":1.2857142857142858},{"$f":"SUM((AllPar=$B16)*(AllYards>560)*AllToPar)/SUM((AllPar=$B16)*(AllYards>560))","v":1.375},null,"Par",3,4,5,"All","R","Right",null,{"$f":"SUM((AllPar=P$14)*IF(ISERR(SEARCH($M16,AllMissDrive)),0,1))/SUM(1*(AllPar=P$14))","v":0.19444444444444445},{"$f":"SUM((AllPar=Q$14)*IF(ISERR(SEARCH($M16,AllMissDrive)),0,1))/SUM(1*(AllPar=Q$14))","v":0.28125},{"$f":"SUM((AllPar>=4)*IF(ISERR(SEARCH($M16,AllMissDrive)),0,1))/SUM(1*(AllPar>=4))","v":0.22115384615384615},null,{"$f":"SUM((AllPar=P$14)*IF(ISERR(SEARCH($M17,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar=P$14)*IF(ISERR(SEARCH($M17,AllMissDrive)),0,1))","v":1.5714285714285714},{"$f":"SUM((AllPar=Q$14)*IF(ISERR(SEARCH($M17,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar=Q$14)*IF(ISERR(SEARCH($M17,AllMissDrive)),0,1))","v":1.1111111111111112},{"$f":"SUM((AllPar>=4)*IF(ISERR(SEARCH($M17,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar>=4)*IF(ISERR(SEARCH($M17,AllMissDrive)),0,1))","v":1.3913043478260869}]
[null,null,null,null,null,null,null,"GIR",{"$f":"SUM((AllPar=I$23)*(AllGIR=$A34)*(AllToPar))/SUM((AllPar=I$23)*(AllGIR=$A34))","v":0.75},{"$f":"SUM((AllPar=J$23)*(AllGIR=$A34)*(AllToPar))/SUM((AllPar=J$23)*(AllGIR=$A34))","v":0.3125},{"$f":"SUM((AllPar=K$23)*(AllGIR=$A34)*(AllToPar))/SUM((AllPar=K$23)*(AllGIR=$A34))","v":9.0909090909090912E-2},{"$f":"SUM((AllGIR=$A34)*(AllToPar))/SUM(1*(AllGIR=$A34))","v":0.38461538461538464},"R","Shank",null,{"$f":"SUM((AllPar=P$14)*IF(ISERR(SEARCH($M18,AllMissDrive)),0,1))/SUM(1*(AllPar=P$14))","v":5.5555555555555552E-2},{"$f":"SUM((AllPar=Q$14)*IF(ISERR(SEARCH($M18,AllMissDrive)),0,1))/SUM(1*(AllPar=Q$14))","v":6.25E-2},{"$f":"SUM((AllPar>=4)*IF(ISERR(SEARCH($M18,AllMissDrive)),0,1))/SUM(1*(AllPar>=4))","v":5.7692307692307696E-2},null,{"$f":"SUM((AllPar=P$14)*IF(ISERR(SEARCH($M19,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar=P$14)*IF(ISERR(SEARCH($M19,AllMissDrive)),0,1))","v":2.5},{"$f":"SUM((AllPar=Q$14)*IF(ISERR(SEARCH($M19,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar=Q$14)*IF(ISERR(SEARCH($M19,AllMissDrive)),0,1))","v":2.5},{"$f":"SUM((AllPar>=4)*IF(ISERR(SEARCH($M19,AllMissDrive)),0,1)*AllToPar)/SUM(1*(AllPar>=4)*IF(ISERR(SEARCH($M19,AllMissDrive)),0,1))","v":2.5}]
[null,"Score Breakdown",null,null,null,null,null,"GIR+1",{"$f":"SUM((AllPar=I$23)*(AllGIR=$A35)*(AllToPar))/SUM((AllPar=I$23)*(AllGIR=$A35))","v":0.66666666666666663},{"$f":"SUM((AllPar=J$23)*(AllGIR=$A35)*(AllToPar))/SUM((AllPar=J$23)*(AllGIR=$A35))","v":0.78787878787878785},{"$f":"SUM((AllPar=K$23)*(AllGIR=$A35)*(AllToPar))/SUM((AllPar=K$23)*(AllGIR=$A35))","v":0.9},{"$f":"SUM((AllGIR=$A35)*(AllToPar))/SUM(1*(AllGIR=$A35))","v":0.765625},"X","No Miss",null,{"$f":"SUM((AllPar=P$14)*ISBLANK(AllMissDrive))/SUM(1*(AllPar=P$14))","v":0.5},{"$f":"SUM((AllPar=Q$14)*ISBLANK(AllMissDrive))/SUM(1*(AllPar=Q$14))","v":0.53125},{"$f":"SUM((AllPar>=4)*ISBLANK(AllMissDrive))/SUM(1*(AllPar>=4))","v":0.50961538461538458},null,{"$f":"SUM((AllPar=P$14)*ISBLANK(AllMissDrive)*AllToPar)/SUM(1*(AllPar=P$14)*ISBLANK(AllMissDrive))","v":1},{"$f":"SUM((AllPar=Q$14)*ISBLANK(AllMissDrive)*AllToPar)/SUM(1*(AllPar=Q$14)*ISBLANK(AllMissDrive))","v":0.70588235294117652},{"$f":"SUM((AllPar>=4)*ISBLANK(AllMissDrive)*AllToPar)/SUM(1*(AllPar>=4)*ISBLANK(AllMissDrive))","v":0.90566037735849059}]
[null,"Par",3,4,5,"All",null,"GIR+2",{"$f":"SUM((AllPar=I$23)*(AllGIR=$A36)*(AllToPar))/SUM((AllPar=I$23)*(AllGIR=$A36))","v":1.4},{"$f":"SUM((AllPar=J$23)*(AllGIR=$A36)*(AllToPar))/SUM((AllPar=J$23)*(AllGIR=$A36))","v":2},{"$f":"SUM((AllPar=K$23)*(AllGIR=$A36)*(AllToPar))/SUM((AllPar=K$23)*(AllGIR=$A36))","v":1.75},{"$f":"SUM((AllGIR=$A36)*(AllToPar))/SUM(1*(AllGIR=$A36))","v":1.8387096774193548},"X"]
[null,"Eagle",{"$f":"SUM((AllPar=C$19)*(AllToPar=$A41))/SUM((AllPar=C$19)*1)","v":0},{"$f":"SUM((AllPar=D$19)*(AllToPar=$A41))/SUM((AllPar=D$19)*1)","v":0},{"$f":"SUM((AllPar=E$19)*(AllToPar=$A41))/SUM((AllPar=E$19)*1)","v":0},{"$f":"SUM(1*(AllToPar=$A41))/COUNTA(AllPar)","v":0},null,"GIR+3+",{"$f":"SUM((AllPar=I$23)*(AllGIR>=$A37)*(AllToPar))/SUM((AllPar=I$23)*(AllGIR=$A37))","v":2.5},{"$f":"SUM((AllPar=J$23)*(AllGIR>=$A37)*(AllToPar))/SUM((AllPar=J$23)*(AllGIR=$A37))","v":3.4},{"$f":"SUM((AllPar=K$23)*(AllGIR>=$A37)*(AllToPar))/SUM((AllPar=K$23)*(AllGIR=$A37))","v":3.3333333333333335},{"$f":"SUM((AllGIR>=$A37)*(AllToPar))/SUM(1*(AllGIR=$A37))","v":3.2},null,"Fairways Hit"]
[null,"Birdie",{"$f":"SUM((AllPar=C$19)*(AllToPar=$A42))/SUM((AllPar=C$19)*1)","v":2.5000000000000001E-2},{"$f":"SUM((AllPar=D$19)*(AllToPar=$A42))/SUM((AllPar=D$19)*1)","v":0},{"$f":"SUM((AllPar=E$19)*(AllToPar=$A42))/SUM((AllPar=E$19)*1)","v":0},{"$f":"SUM(1*(AllToPar=$A42))/COUNTA(AllPar)","v":6.9444444444444441E-3},null,null,null,null,null,null,null,null,"Breakdown",null,null,null,"Avg Score"]
[null,"Par",{"$f":"SUM((AllPar=C$19)*(AllToPar=$A43))/SUM((AllPar=C$19)*1)","v":0.22500000000000001},{"$f":"SUM((AllPar=D$19)*(AllToPar=$A43))/SUM((AllPar=D$19)*1)","v":0.29166666666666669},{"$f":"SUM((AllPar=E$19)*(AllToPar=$A43))/SUM((AllPar=E$19)*1)","v":0.375},{"$f":"SUM(1*(AllToPar=$A43))/COUNTA(AllPar)","v":0.29166666666666669},null,"GIR Breakdown",null,null,null,null,null,"Par",3,4,5,"All",3,4,5,"All"]
[null,"Bogey",{"$f":"SUM((AllPar=C$19)*(AllToPar=$A44))/SUM((AllPar=C$19)*1)","v":0.625},{"$f":"SUM((AllPar=D$19)*(AllToPar=$A44))/SUM((AllPar=D$19)*1)","v":0.40277777777777779},{"$f":"SUM((AllPar=E$19)*(AllToPar=$A44))/SUM((AllPar=E$19)*1)","v":0.3125},{"$f":"SUM(1*(AllToPar=$A44))/COUNTA(AllPar)","v":0.44444444444444442},null,"Par",3,4,5,"All",null,"Hit",null,{"$f":"SUM((AllPar=P22)*(AllFairway))/SUM(1*(AllPar=P22))","v":0.55555555555555558},{"$f":"SUM((AllPar=Q22)*(AllFairway))/SUM(1*(AllPar=Q22))","v":0.46875},{"$f":"SUM((AllPar>=4)*(AllFairway))/SUM(1*(AllPar>=4))","v":0.52884615384615385},null,{"$f":"SUM((AllPar=P$22)*(AllFairway=1)*(AllToPar))/SUM((AllPar=P$22)*(AllFairway=1))","v":1.0249999999999999},{"$f":"SUM((AllPar=Q$22)*(AllFairway=1)*(AllToPar))/SUM((AllPar=Q$22)*(AllFairway=1))","v":0.73333333333333328},{"$f":"SUM((AllPar>=4)*(AllFairway=1)*(AllToPar))/SUM((AllPar>=4)*(AllFairway=1))","v":0.94545454545454544}]
[null,"Double",{"$f":"SUM((AllPar=C$19)*(AllToPar=$A45))/SUM((AllPar=C$19)*1)","v":0.1},{"$f":"SUM((AllPar=D$19)*(AllToPar=$A45))/SUM((AllPar=D$19)*1)","v":0.18055555555555555},{"$f":"SUM((AllPar=E$19)*(AllToPar=$A45))/SUM((AllPar=E$19)*1)","v":0.21875},{"$f":"SUM(1*(AllToPar=$A45))/COUNTA(AllPar)","v":0.16666666666666666},null,"GIR",{"$f":"SUM((AllPar=I$23)*(AllGIR=$A27))/SUM((AllPar=I$23)*1)","v":0.3},{"$f":"SUM((AllPar=J$23)*(AllGIR=$A27))/SUM((AllPar=J$23)*1)","v":0.22222222222222221},{"$f":"SUM((AllPar=K$23)*(AllGIR=$A27))/SUM((AllPar=K$23)*1)","v":0.34375},{"$f":"SUM((AllGIR=$A27)*1)/SUM((AllPar>0)*1)","v":0.27083333333333331},null,"Miss",null,{"$f":"1-P23","v":0.44444444444444442},{"$f":"1-Q23","v":0.53125},{"$f":"1-R23","v":0.47115384615384615},null,{"$f":"SUM((AllPar=P$22)*(AllFairway=0)*(AllToPar))/SUM((AllPar=P$22)*(AllFairway=0))","v":1.34375},{"$f":"SUM((AllPar=Q$22)*(AllFairway=0)*(AllToPar))/SUM((AllPar=Q$22)*(AllFairway=0))","v":1.3529411764705883},{"$f":"SUM((AllPar>=4)*(AllFairway=0)*(AllToPar))/SUM((AllPar>=4)*(AllFairway=0))","v":1.346938775510204}]
[null,"Triple+",{"$f":"SUM((AllPar=C$19)*(AllToPar>=$A46))/SUM((AllPar=C$19)*1)","v":2.5000000000000001E-2},{"$f":"SUM((AllPar=D$19)*(AllToPar>=$A46))/SUM((AllPar=D$19)*1)","v":0.125},{"$f":"SUM((AllPar=E$19)*(AllToPar>=$A46))/SUM((AllPar=E$19)*1)","v":9.375E-2},{"$f":"SUM(1*(AllToPar>=$A46))/COUNTA(AllPar)","v":9.0277777777777776E-2},null,"GIR+1",{"$f":"SUM((AllPar=I$23)*(AllGIR=$A28))/SUM((AllPar=I$23)*1)","v":0.52500000000000002},{"$f":"SUM((AllPar=J$23)*(AllGIR=$A28))/SUM((AllPar=J$23)*1)","v":0.45833333333333331},{"$f":"SUM((AllPar=K$23)*(AllGIR=$A28))/SUM((AllPar=K$23)*1)","v":0.3125},{"$f":"SUM((AllGIR=$A28)*1)/SUM((AllPar>0)*1)","v":0.44444444444444442},null,"\"Penalty\" for miss",null,null,null,null,null,{"$f":"T24-T23","v":0.31875000000000009},{"$f":"U24-U23","v":0.61960784313725503},{"$f":"V24-V23","v":0.40148423005565859}]
[null,null,null,null,null,null,null,"GIR+2",{"$f":"SUM((AllPar=I$23)*(AllGIR=$A29))/SUM((AllPar=I$23)*1)","v":0.125},{"$f":"SUM((AllPar=J$23)*(AllGIR=$A29))/SUM((AllPar=J$23)*1)","v":0.25},{"$f":"SUM((AllPar=K$23)*(AllGIR=$A29))/SUM((AllPar=K$23)*1)","v":0.25},{"$f":"SUM((AllGIR=$A29)*1)/SUM((AllPar>0)*1)","v":0.21527777777777779}]
[0,null,null,null,null,null,null,"GIR+3+",{"$f":"SUM((AllPar=I$23)*(AllGIR>=$A30))/SUM((AllPar=I$23)*1)","v":0.05},{"$f":"SUM((AllPar=J$23)*(AllGIR>=$A30))/SUM((AllPar=J$23)*1)","v":6.9444444444444448E-2},{"$f":"SUM((AllPar=K$23)*(AllGIR>=$A30))/SUM((AllPar=K$23)*1)","v":9.375E-2},{"$f":"SUM((AllGIR>=$A30)*1)/SUM((AllPar>0)*1)","v":6.9444444444444448E-2}]
[1]
[2]
[3]
[]
[]
[]
[0]
[1]
[2]
[3]
[]
[]
[]
[-2]
[-1]
[0]
[1]
[2]
[3]

{"sheet":"Last 5 Rounds","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Course Stats","index":5,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,5],[1,1,1,5],[1,10,1,11],[2,10,2,11],[2,6,2,7],[2,8,2,9],[1,6,1,7],[1,8,1,9]]}
[]
[null,"Select Course",null,null,null,null,"Rating",null,"Slope",null,"Rounds"]
[null,"Chace Lake (Blue)",null,null,null,null,{"$f":"Rating2","v":71.2},null,{"$f":"Slope2","v":125},null,{"$f":"COUNTIF(AllCourse,B3)","v":3}]
[]
[null,"HOLE",{"$f":"X5","v":"Total"},1,2,3,4,5,6,7,8,9,"Out",10,11,12,13,14,15,16,17,18,"In","Total"]
[null,"YARDS",{"$f":"X6","v":6577},{"$f":"Yards2","v":380},155,414,308,574,419,548,206,320,3324,405,376,198,522,172,378,554,194,454,3253,6577]
[null,"HDCP",{"$f":"X7","v":0},{"$f":"Hdcp2","v":13},17,3,11,1,9,5,15,7,0,4,10,14,8,18,12,2,16,6,0,0]
[null,"PAR",{"$f":"X8","v":71},{"$f":"_Par2","v":4},3,4,4,5,4,5,3,4,36,4,4,3,5,3,4,5,3,4,35,71]
[null,"Avg Score",{"$f":"SUM((AllCourse=Course2)*(AllScore))/SUM((AllCourse=Course2)*1)","v":93.333333333333329},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=D$5))","v":5.333333333333333},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=E$5))","v":2.6666666666666665},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=F$5))","v":5},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=G$5))","v":5},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=H$5))","v":5.666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=I$5))","v":6.333333333333333},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=J$5))","v":5.666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=K$5))","v":4.333333333333333},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=L$5))","v":5},{"$f":"SUM((AllCourse=Course2)*(AllHole<=9)*(AllScore))/SUM((AllCourse=Course2)*1)","v":45},{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=N$5))","v":6.333333333333333},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=O$5))","v":4.666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=P$5))","v":4},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=Q$5))","v":7.666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=R$5))","v":3.6666666666666665},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=S$5))","v":5.666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=T$5))","v":6},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=U$5))","v":4},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*(AllScore))/SUM((AllCourse=Course2)*(AllHole=V$5))","v":6.333333333333333},{"$f":"SUM((AllCourse=Course2)*(AllHole>=10)*(AllScore))/SUM((AllCourse=Course2)*1)","v":48.333333333333336}]
[null,"to par",{"$f":"C9-C8","v":22.333333333333329},{"$f":"D9-D8","v":1.333333333333333},-0.33333333333333348,1,1,0.66666666666666696,2.333333333333333,0.66666666666666696,1.333333333333333,1,9,2.333333333333333,0.66666666666666696,1,2.666666666666667,0.66666666666666652,1.666666666666667,1,1,2.333333333333333,13.333333333333336]
[]
[null,"Hit Fairway",{"$f":"SUM((AllPar>3)*(AllCourse=Course2)*(AllFairway=1))/SUM((AllPar>3)*(AllCourse=Course2))","v":0.53846153846153844},{"$f":"IF(D8>3,SUM((AllCourse=Course2)*(AllHole=D$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=D$5)),0)","v":0.66666666666666663},{"$f":"IF(E8>3,SUM((AllCourse=Course2)*(AllHole=E$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=E$5)),0)","v":0},{"$f":"IF(F8>3,SUM((AllCourse=Course2)*(AllHole=F$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=F$5)),0)","v":1},{"$f":"IF(G8>3,SUM((AllCourse=Course2)*(AllHole=G$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=G$5)),0)","v":0.33333333333333331},{"$f":"IF(H8>3,SUM((AllCourse=Course2)*(AllHole=H$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=H$5)),0)","v":1},{"$f":"IF(I8>3,SUM((AllCourse=Course2)*(AllHole=I$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=I$5)),0)","v":0.66666666666666663},{"$f":"IF(J8>3,SUM((AllCourse=Course2)*(AllHole=J$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=J$5)),0)","v":0.33333333333333331},{"$f":"IF(K8>3,SUM((AllCourse=Course2)*(AllHole=K$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=K$5)),0)","v":0},{"$f":"IF(L8>3,SUM((AllCourse=Course2)*(AllHole=L$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=L$5)),0)","v":1},{"$f":"SUM((AllHole<=9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=1))/SUM((AllHole<=9)*(AllPar>3)*(AllCourse=Course2))","v":0.7142857142857143},{"$f":"IF(N8>3,SUM((AllCourse=Course2)*(AllHole=N$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=N$5)),0)","v":0.66666666666666663},{"$f":"IF(O8>3,SUM((AllCourse=Course2)*(AllHole=O$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=O$5)),0)","v":0.33333333333333331},{"$f":"IF(P8>3,SUM((AllCourse=Course2)*(AllHole=P$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=P$5)),0)","v":0},{"$f":"IF(Q8>3,SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=Q$5)),0)","v":0.33333333333333331},{"$f":"IF(R8>3,SUM((AllCourse=Course2)*(AllHole=R$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=R$5)),0)","v":0},{"$f":"IF(S8>3,SUM((AllCourse=Course2)*(AllHole=S$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=S$5)),0)","v":0.33333333333333331},{"$f":"IF(T8>3,SUM((AllCourse=Course2)*(AllHole=T$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=T$5)),0)","v":0.33333333333333331},{"$f":"IF(U8>3,SUM((AllCourse=Course2)*(AllHole=U$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=U$5)),0)","v":0},{"$f":"IF(V8>3,SUM((AllCourse=Course2)*(AllHole=V$5)*(AllFairway=1))/SUM((AllCourse=Course2)*(AllHole=V$5)),0)","v":0},{"$f":"SUM((AllHole>9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=1))/SUM((AllHole>9)*(AllPar>3)*(AllCourse=Course2))","v":0.33333333333333331}]
[null,"avg score",null,{"$f":"IF(D12<>0,SUM((AllCourse=Course2)*(AllHole=D$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=D$5)),0)","v":6},{"$f":"IF(E12<>0,SUM((AllCourse=Course2)*(AllHole=E$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=E$5)),0)","v":0},{"$f":"IF(F12<>0,SUM((AllCourse=Course2)*(AllHole=F$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=F$5)),0)","v":5},{"$f":"IF(G12<>0,SUM((AllCourse=Course2)*(AllHole=G$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=G$5)),0)","v":6},{"$f":"IF(H12<>0,SUM((AllCourse=Course2)*(AllHole=H$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=H$5)),0)","v":5.666666666666667},{"$f":"IF(I12<>0,SUM((AllCourse=Course2)*(AllHole=I$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=I$5)),0)","v":6.5},{"$f":"IF(J12<>0,SUM((AllCourse=Course2)*(AllHole=J$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=J$5)),0)","v":5},{"$f":"IF(K12<>0,SUM((AllCourse=Course2)*(AllHole=K$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=K$5)),0)","v":0},{"$f":"IF(L12<>0,SUM((AllCourse=Course2)*(AllHole=L$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=L$5)),0)","v":5},null,{"$f":"IF(N12<>0,SUM((AllCourse=Course2)*(AllHole=N$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=N$5)),0)","v":6.5},{"$f":"IF(O12<>0,SUM((AllCourse=Course2)*(AllHole=O$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=O$5)),0)","v":4},{"$f":"IF(P12<>0,SUM((AllCourse=Course2)*(AllHole=P$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=P$5)),0)","v":0},{"$f":"IF(Q12<>0,SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=Q$5)),0)","v":7},{"$f":"IF(R12<>0,SUM((AllCourse=Course2)*(AllHole=R$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=R$5)),0)","v":0},{"$f":"IF(S12<>0,SUM((AllCourse=Course2)*(AllHole=S$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=S$5)),0)","v":5},{"$f":"IF(T12<>0,SUM((AllCourse=Course2)*(AllHole=T$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=T$5)),0)","v":7},{"$f":"IF(U12<>0,SUM((AllCourse=Course2)*(AllHole=U$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=U$5)),0)","v":0},{"$f":"IF(V12<>0,SUM((AllCourse=Course2)*(AllHole=V$5)*(AllFairway=1)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=1)*(AllHole=V$5)),0)","v":0}]
[null,"to par",{"$f":"SUM((AllPar>3)*(AllCourse=Course2)*(AllFairway=1)*(AllToPar))/SUM((AllPar>3)*(AllCourse=Course2)*(AllFairway=1))","v":1.3809523809523809},{"$f":"IF(D12<>0,D13-D8,\"\")","v":2},{"$f":"IF(E12<>0,E13-E8,\"\")","v":""},1,2,0.66666666666666696,2.5,0,"",1,{"$f":"SUM((AllHole<=9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=1)*(AllToPar))/SUM((AllHole<=9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=1))","v":1.2666666666666666},2.5,0,"",2,"",1,2,"","",{"$f":"SUM((AllHole>9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=1)*(AllToPar))/SUM((AllHole>9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=1))","v":1.6666666666666667}]
[]
[null,"Miss Fairway",{"$f":"IF(C8>3,1-C12,0)","v":0.46153846153846156},{"$f":"IF(D8>3,1-D12,0)","v":0.33333333333333337},{"$f":"IF(E8>3,1-E12,0)","v":0},{"$f":"IF(F8>3,1-F12,0)","v":0},{"$f":"IF(G8>3,1-G12,0)","v":0.66666666666666674},{"$f":"IF(H8>3,1-H12,0)","v":0},{"$f":"IF(I8>3,1-I12,0)","v":0.33333333333333337},{"$f":"IF(J8>3,1-J12,0)","v":0.66666666666666674},{"$f":"IF(K8>3,1-K12,0)","v":0},{"$f":"IF(L8>3,1-L12,0)","v":0},{"$f":"IF(M8>3,1-M12,0)","v":0.2857142857142857},{"$f":"IF(N8>3,1-N12,0)","v":0.33333333333333337},{"$f":"IF(O8>3,1-O12,0)","v":0.66666666666666674},{"$f":"IF(P8>3,1-P12,0)","v":0},{"$f":"IF(Q8>3,1-Q12,0)","v":0.66666666666666674},{"$f":"IF(R8>3,1-R12,0)","v":0},{"$f":"IF(S8>3,1-S12,0)","v":0.66666666666666674},{"$f":"IF(T8>3,1-T12,0)","v":0.66666666666666674},{"$f":"IF(U8>3,1-U12,0)","v":0},{"$f":"IF(V8>3,1-V12,0)","v":1},{"$f":"IF(W8>3,1-W12,0)","v":0.66666666666666674}]
[null,"avg score",null,{"$f":"IF(D16<>0,SUM((AllCourse=Course2)*(AllHole=D$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=D$5)),0)","v":4},{"$f":"IF(E16<>0,SUM((AllCourse=Course2)*(AllHole=E$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=E$5)),0)","v":0},{"$f":"IF(F16<>0,SUM((AllCourse=Course2)*(AllHole=F$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=F$5)),0)","v":0},{"$f":"IF(G16<>0,SUM((AllCourse=Course2)*(AllHole=G$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=G$5)),0)","v":4.5},{"$f":"IF(H16<>0,SUM((AllCourse=Course2)*(AllHole=H$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=H$5)),0)","v":0},{"$f":"IF(I16<>0,SUM((AllCourse=Course2)*(AllHole=I$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=I$5)),0)","v":6},{"$f":"IF(J16<>0,SUM((AllCourse=Course2)*(AllHole=J$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=J$5)),0)","v":6},{"$f":"IF(K16<>0,SUM((AllCourse=Course2)*(AllHole=K$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=K$5)),0)","v":0},{"$f":"IF(L16<>0,SUM((AllCourse=Course2)*(AllHole=L$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=L$5)),0)","v":0},null,{"$f":"IF(N16<>0,SUM((AllCourse=Course2)*(AllHole=N$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=N$5)),0)","v":6},{"$f":"IF(O16<>0,SUM((AllCourse=Course2)*(AllHole=O$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=O$5)),0)","v":5},{"$f":"IF(P16<>0,SUM((AllCourse=Course2)*(AllHole=P$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=P$5)),0)","v":0},{"$f":"IF(Q16<>0,SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=Q$5)),0)","v":8},{"$f":"IF(R16<>0,SUM((AllCourse=Course2)*(AllHole=R$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=R$5)),0)","v":0},{"$f":"IF(S16<>0,SUM((AllCourse=Course2)*(AllHole=S$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=S$5)),0)","v":6},{"$f":"IF(T16<>0,SUM((AllCourse=Course2)*(AllHole=T$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=T$5)),0)","v":5.5},{"$f":"IF(U16<>0,SUM((AllCourse=Course2)*(AllHole=U$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=U$5)),0)","v":0},{"$f":"IF(V16<>0,SUM((AllCourse=Course2)*(AllHole=V$5)*(AllFairway=0)*(AllScore))/SUM((AllCourse=Course2)*(AllFairway=0)*(AllHole=V$5)),0)","v":6.333333333333333}]
[null,"to par",{"$f":"SUM((AllPar>3)*(AllCourse=Course2)*(AllFairway=0)*(AllToPar))/SUM((AllPar>3)*(AllCourse=Course2)*(AllFairway=0))","v":1.5},{"$f":"IF(D16<>0,D17-D8,\"\")","v":0},{"$f":"IF(E16<>0,E17-E8,\"\")","v":""},"",0.5,"",2,1,"","",{"$f":"SUM((AllHole<=9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=0)*(AllToPar))/SUM((AllHole<=9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=0))","v":0.83333333333333337},2,1,"",3,"",2,0.5,"",2.333333333333333,{"$f":"SUM((AllHole>9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=0)*(AllToPar))/SUM((AllHole>9)*(AllPar>3)*(AllCourse=Course2)*(AllFairway=0))","v":1.8333333333333333}]
[]
[null,"\"Penalty\" for miss",{"$f":"IF(OR(C14=\"\",C18=\"\"),\"\",C18-C14)","v":0.11904761904761907},{"$f":"IF(OR(D14=\"\",D18=\"\"),\"\",D18-D14)","v":-2},{"$f":"IF(OR(E14=\"\",E18=\"\"),\"\",E18-E14)","v":""},"",-1.5,"",-0.5,1,"","",-0.43333333333333324,-0.5,1,"",1,"",1,-1.5,"","",0.16666666666666652]
[]
[null,"Avg Putts",{"$f":"SUM((AllCourse=Course2)*(AllPutt))/$K$3","v":36},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=D$5))","v":2},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=E$5))","v":1},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=F$5))","v":1.6666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=G$5))","v":2},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=H$5))","v":1.6666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=I$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=J$5))","v":2},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=K$5))","v":1.6666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=L$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole<=9)*(AllPutt))/K3","v":16.666666666666668},{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=N$5))","v":2},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=O$5))","v":1.6666666666666667},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=P$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=Q$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=R$5))","v":2},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=S$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=T$5))","v":2},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=U$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*(AllPutt))/SUM((AllCourse=Course2)*(AllHole=V$5))","v":2.3333333333333335},{"$f":"SUM((AllCourse=Course2)*(AllHole>=10)*(AllPutt))/K3","v":19.333333333333332}]
[null,"per GIR",{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0))=0,0,SUM((AllCourse=Course2)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)))","v":2.2999999999999998},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=D$5))=0,0,SUM((AllCourse=Course2)*(AllHole=D$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=D$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=E$5))=0,0,SUM((AllCourse=Course2)*(AllHole=E$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=E$5)))","v":1},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=F$5))=0,0,SUM((AllCourse=Course2)*(AllHole=F$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=F$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=G$5))=0,0,SUM((AllCourse=Course2)*(AllHole=G$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=G$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=H$5))=0,0,SUM((AllCourse=Course2)*(AllHole=H$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=H$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=I$5))=0,0,SUM((AllCourse=Course2)*(AllHole=I$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=I$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=J$5))=0,0,SUM((AllCourse=Course2)*(AllHole=J$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=J$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=K$5))=0,0,SUM((AllCourse=Course2)*(AllHole=K$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=K$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=L$5))=0,0,SUM((AllCourse=Course2)*(AllHole=L$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=L$5)))","v":3},null,{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=N$5))=0,0,SUM((AllCourse=Course2)*(AllHole=N$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=N$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=O$5))=0,0,SUM((AllCourse=Course2)*(AllHole=O$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=O$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=P$5))=0,0,SUM((AllCourse=Course2)*(AllHole=P$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=P$5)))","v":2.5},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=Q$5))=0,0,SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=Q$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=R$5))=0,0,SUM((AllCourse=Course2)*(AllHole=R$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=R$5)))","v":3},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=S$5))=0,0,SUM((AllCourse=Course2)*(AllHole=S$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=S$5)))","v":0},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=T$5))=0,0,SUM((AllCourse=Course2)*(AllHole=T$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=T$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=U$5))=0,0,SUM((AllCourse=Course2)*(AllHole=U$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=U$5)))","v":3},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=V$5))=0,0,SUM((AllCourse=Course2)*(AllHole=V$5)*(AllGIR=0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR=0)*(AllHole=V$5)))","v":0}]
[null,"per non-GIR",{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0))=0,0,SUM((AllCourse=Course2)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)))","v":1.9318181818181819},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=D$5))=0,0,SUM((AllCourse=Course2)*(AllHole=D$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=D$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=E$5))=0,0,SUM((AllCourse=Course2)*(AllHole=E$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=E$5)))","v":1},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=F$5))=0,0,SUM((AllCourse=Course2)*(AllHole=F$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=F$5)))","v":1.6666666666666667},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=G$5))=0,0,SUM((AllCourse=Course2)*(AllHole=G$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=G$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=H$5))=0,0,SUM((AllCourse=Course2)*(AllHole=H$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=H$5)))","v":1.6666666666666667},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=I$5))=0,0,SUM((AllCourse=Course2)*(AllHole=I$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=I$5)))","v":2.3333333333333335},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=J$5))=0,0,SUM((AllCourse=Course2)*(AllHole=J$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=J$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=K$5))=0,0,SUM((AllCourse=Course2)*(AllHole=K$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=K$5)))","v":1.6666666666666667},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=L$5))=0,0,SUM((AllCourse=Course2)*(AllHole=L$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=L$5)))","v":2},null,{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=N$5))=0,0,SUM((AllCourse=Course2)*(AllHole=N$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=N$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=O$5))=0,0,SUM((AllCourse=Course2)*(AllHole=O$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=O$5)))","v":1.5},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=P$5))=0,0,SUM((AllCourse=Course2)*(AllHole=P$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=P$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=Q$5))=0,0,SUM((AllCourse=Course2)*(AllHole=Q$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=Q$5)))","v":2.3333333333333335},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=R$5))=0,0,SUM((AllCourse=Course2)*(AllHole=R$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=R$5)))","v":1.5},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=S$5))=0,0,SUM((AllCourse=Course2)*(AllHole=S$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=S$5)))","v":2.3333333333333335},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=T$5))=0,0,SUM((AllCourse=Course2)*(AllHole=T$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=T$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=U$5))=0,0,SUM((AllCourse=Course2)*(AllHole=U$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=U$5)))","v":2},{"$f":"IF(SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=V$5))=0,0,SUM((AllCourse=Course2)*(AllHole=V$5)*(AllGIR>0)*(AllPutt))/SUM((AllCourse=Course2)*(AllGIR>0)*(AllHole=V$5)))","v":2.3333333333333335}]
[]
[null,"Miss Drive - Freq",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Par"]
["L","Left",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1)*(AllPar>3))/SUM((AllCourse=Course2)*(AllPar>3))","v":0.12820512820512819},{"$f":"IF(D$8>3,SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(E$8>3,SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(F$8>3,SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(G$8>3,SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(H$8>3,SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(I$8>3,SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(J$8>3,SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(K$8>3,SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(L$8>3,SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},null,{"$f":"IF(N$8>3,SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(O$8>3,SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0.66666666666666663},{"$f":"IF(P$8>3,SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(Q$8>3,SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(R$8>3,SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(S$8>3,SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(T$8>3,SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(U$8>3,SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(V$8>3,SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1))/$K$3,\"\")","v":0},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A27,AllMissDrive)),0,1)*(AllPar>3))","v":0.8}]
["R","Right",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1)*(AllPar>3))/SUM((AllCourse=Course2)*(AllPar>3))","v":0.20512820512820512},{"$f":"IF(D$8>3,SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(E$8>3,SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(F$8>3,SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(G$8>3,SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0.66666666666666663},{"$f":"IF(H$8>3,SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(I$8>3,SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(J$8>3,SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(K$8>3,SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(L$8>3,SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},null,{"$f":"IF(N$8>3,SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(O$8>3,SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(P$8>3,SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(Q$8>3,SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(R$8>3,SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(S$8>3,SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(T$8>3,SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0.66666666666666663},{"$f":"IF(U$8>3,SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(V$8>3,SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A28,AllMissDrive)),0,1)*(AllPar>3))","v":1.375}]
["X","Shank",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1)*(AllPar>3))/SUM((AllCourse=Course2)*(AllPar>3))","v":0.12820512820512819},{"$f":"IF(D$8>3,SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(E$8>3,SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(F$8>3,SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(G$8>3,SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(H$8>3,SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(I$8>3,SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(J$8>3,SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(K$8>3,SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(L$8>3,SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},null,{"$f":"IF(N$8>3,SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(O$8>3,SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(P$8>3,SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(Q$8>3,SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},{"$f":"IF(R$8>3,SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(S$8>3,SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(T$8>3,SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0},{"$f":"IF(U$8>3,SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":""},{"$f":"IF(V$8>3,SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1))/$K$3,\"\")","v":0.33333333333333331},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A29,AllMissDrive)),0,1)*(AllPar>3))","v":2.2000000000000002}]
[null,"No Miss",{"$f":"SUM((AllCourse=Course2)*(AllPar>3)*ISBLANK(AllMissDrive))/SUM((AllCourse=Course2)*(AllPar>3))","v":0.51282051282051277},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A30,AllMissDrive)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A30,AllMissDrive)),0,1)*(AllPar>3))","v":1.4210526315789473}]
[]
[null,"Miss Approach",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Par"]
["L","Left",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/SUM((AllCourse=Course2)*(AllPar<>0))","v":0.12962962962962962},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},null,{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A33,AllMissIron)),0,1))","v":1.7142857142857142}]
["R","Right",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/SUM((AllCourse=Course2)*(AllPar<>0))","v":0.48148148148148145},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":1},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":1},null,{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":1},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))/$K$3","v":0},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A34,AllMissIron)),0,1))","v":1.1923076923076923}]
["S","Short",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/SUM((AllCourse=Course2)*(AllPar<>0))","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},null,{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":1},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))/$K$3","v":0},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A35,AllMissIron)),0,1))","v":0.94444444444444442}]
["G","Long",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/SUM((AllCourse=Course2)*(AllPar<>0))","v":9.2592592592592587E-2},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},null,{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0.66666666666666663},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))/$K$3","v":0},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A36,AllMissIron)),0,1))","v":1.4}]
["X","Shank",{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/SUM((AllCourse=Course2)*(AllPar<>0))","v":3.7037037037037035E-2},{"$f":"SUM((AllCourse=Course2)*(AllHole=D$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=E$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=F$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=G$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=H$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=I$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=J$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=K$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=L$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},null,{"$f":"SUM((AllCourse=Course2)*(AllHole=N$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=O$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=P$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=Q$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0.33333333333333331},{"$f":"SUM((AllCourse=Course2)*(AllHole=R$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=S$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=T$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=U$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},{"$f":"SUM((AllCourse=Course2)*(AllHole=V$5)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))/$K$3","v":0},null,null,{"$f":"SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1)*AllToPar)/SUM((AllCourse=Course2)*IF(ISERR(SEARCH($A37,AllMissIron)),0,1))","v":2}]

{"sheet":"Scores","index":6,"n_rows":23,"n_cols":247,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,184,0,201],[0,202,0,219],[0,220,0,237],[0,112,0,129],[0,130,0,147],[0,148,0,165],[0,166,0,183],[0,76,0,93],[0,94,0,111],[0,4,0,21],[0,22,0,39],[0,40,0,57],[0,58,0,75]]}
[null,null,6,7,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Putt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Penalty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GIR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ToPar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairway Att",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Par",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handicap",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miss Drive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miss Iron"]
["Course","Date","Notes","List",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,"Count","Score","Slope","Rating","Diff","Handicap","Par","Putts","GIR"]
["Chace Lake (White)","2006-05-25","Double bogey on 7 was due to shanking driver, shanking 3w and then a bad chip.","05/25/06 - Chace Lake (White)",5,3,5,5,5,5,7,4,4,5,5,4,6,4,4,6,4,5,2,1,2,1,2,3,2,2,2,2,2,2,1,3,2,1,1,2,null,null,null,null,null,null,"DFC",null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,1,1,null,null,1,1,1,null,null,null,1,null,null,1,2,1,null,2,null,null,null,2,null,null,null,null,null,null,null,1,1,null,1,1,1,2,0,0,2,1,0,1,1,1,2,0,0,2,2,1,1,0,1,1,0,1,2,1,0,1,1,1,1,1,0,1,1,1,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,359,148,399,282,495,368,497,200,311,375,351,173,505,152,346,566,175,397,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,null,null,"R",null,null,null,null,null,null,"L",null,null,"R","L",null,"R",null,null,"L","L",null,"R",null,"S","R","R","RG","R","RS","R","RG",null,null,"R","RS","G",0,{"$f":"SUM(E3:V3)","v":86},{"$f":"OFFSET(Slopes,MATCH(A3,Courses,FALSE),0)","v":128},{"$f":"OFFSET(Ratings,MATCH(A3,Courses,FALSE),0)","v":70.099999999999994},{"$f":"ROUND((IF3-IH3)*113/IG3,1)","v":14},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"SUM(ES3:FJ3)","v":71},{"$f":"SUM(W3:AN3)","v":33},{"$f":"COUNTIF(CQ3:DH3,0)","v":5}]
["Chace Lake (Blue)","2006-05-27","#3 - decent drive, but pushed my 5wood 30 yards right of green, then pitched over the green.  #6 - good drive, shanked my 7 iron into woods (had downhill lie).  #10 - good drive (almost too far into water), approach into trap, caught ball clean from trap into other trap, hit back over the green for 2nd bunker shot, then chip and 2 putts.  #13 - good drive, 3 hybrid hit tree and left awkward approach, shanked approach, left me with 60 yard pitch which I pushed big time, chip and two putts.  #16 - decent drive, good hybrid, then bad hybrid on the approach hit cart path and went 30 yards right of green.  #18 - bad drive (maybe 150 yards), awesome 3 wood from 250 (with a little help from cart path), left with simple chip that I ran over the green, even easier chip coming back, but still two putted.  Short game was not good today.  Putting wasn't great either.  Iron play was pretty bad too.","05/27/06 - Chace Lake (Blue)",5,2,6,5,5,6,6,4,5,7,4,3,7,4,5,7,4,6,2,1,2,1,1,2,2,2,3,2,1,2,2,3,2,2,2,2,null,null,"FT",null,null,"S",null,null,"P","SN",null,null,"LSW","P",null,"L",null,"DC",1,null,1,null,1,1,null,null,1,1,null,null,1,null,null,1,null,null,null,null,null,2,null,2,null,2,null,4,null,null,null,null,null,null,null,null,1,0,2,2,1,2,1,1,0,3,1,0,2,0,1,2,1,2,1,-1,2,1,0,2,1,1,1,3,0,0,2,1,1,2,1,2,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,380,155,414,308,574,419,548,206,320,405,376,198,522,172,378,554,194,454,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,null,null,null,"R",null,null,"X",null,null,null,"L",null,null,null,"G",null,null,"X","S",null,"R","S","R","X","R","RS","RG","R","S",null,"X","RS","G","R","L",null,0,{"$f":"SUM(E4:V4)","v":91},125,71.2,{"$f":"ROUND((IF4-IH4)*113/IG4,1)","v":17.899999999999999},{"$f":"NA()","v":{"$error":"#N/A"}},71,{"$f":"SUM(W4:AN4)","v":34},{"$f":"COUNTIF(CQ4:DH4,0)","v":4}]
["Chace Lake (White)","2006-05-28","Missed a couple of short putts on this round.  #11 - great drive, then pulled a 7 iron wayyy left, right next to tree, had to hit away from hole, then pitch shot didn't make it up the hill.  #12 - again a big pull.  #16 - big pull with driver and the hit my layup too far.","05/28/06 - Chace Lake (White)",5,4,5,4,5,5,6,4,5,4,7,5,5,4,5,7,3,5,2,1,1,2,2,3,2,2,2,1,2,3,2,1,2,2,1,3,null,null,null,null,null,"P",null,null,null,null,"S","SP",null,null,null,"D",null,"P",null,null,null,null,1,1,1,null,null,1,1,null,null,null,null,null,null,1,2,2,null,null,null,null,null,null,null,null,null,null,null,2,null,2,null,null,1,2,2,0,0,0,1,1,1,1,3,1,0,2,1,2,1,0,1,1,1,0,0,1,1,1,1,0,3,2,0,1,1,2,0,1,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,359,148,399,282,495,368,497,200,311,375,351,173,505,152,346,566,175,397,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,"L",null,"R","R",null,null,null,null,"R",null,null,null,null,null,"L","L",null,null,null,"L",null,"S","R","S","R","L",null,"LS","L","L","G","L",null,"R","R",null,0,88,128,70.099999999999994,15.8,{"$f":"NA()","v":{"$error":"#N/A"}},71,34,5]
["Chace Lake (Blue)","2006-05-29","#6 - nice drive, down hill lie for my approach and pulled my 6 iron into bunker, 4 shots later triple bogey.  #8 - push my 5 wood way right, bad pitch, bad pitch, two putts.  #10 - shank drive and bad approach.  #13 - diaster from start to finish.  #18 - bad drive.","05/29/06 - Chace Lake (Blue)",4,3,5,4,6,7,6,5,5,6,4,4,9,4,5,6,4,6,1,1,2,2,2,3,2,1,2,2,2,3,3,2,2,2,2,2,null,null,null,null,null,"MNP",null,"F",null,"DS",null,"P","DSP",null,null,null,null,"D",null,null,1,null,1,1,null,null,1,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,4,null,null,2,null,null,null,null,null,null,null,null,1,1,1,0,1,2,1,3,1,2,0,0,3,1,1,1,1,2,0,0,1,0,1,3,1,2,1,2,0,1,4,1,1,1,1,2,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,380,155,414,308,574,419,548,206,320,405,376,198,522,172,378,554,194,454,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,"L",null,null,"R",null,null,"R",null,null,"X","L",null,"X",null,null,"R",null,null,"R","S","SR","R","S","L","R","R","R","L",null,null,null,"SR","SR","SR","L","L",0,93,125,71.2,19.7,{"$f":"NA()","v":{"$error":"#N/A"}},71,36,3]
["Chace Lake (White)","2006-06-04T20:48:03","#9 - disaster!  Chunked 3W into water and couldn't recover.  #16 - great drive, but chunked my lay-up, pushed my approach.","06/04/06 - Chace Lake (White)",4,4,4,5,5,4,5,4,8,5,4,4,5,4,5,8,4,4,1,3,1,2,2,1,2,2,2,3,2,3,2,2,2,2,3,1,null,"P",null,null,null,null,null,null,"F","P",null,"P",null,null,null,"LM","P",null,null,null,1,1,null,null,1,null,null,null,1,null,1,null,1,1,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,1,0,1,1,0,1,0,1,3,0,0,0,0,1,1,3,0,1,0,1,0,1,0,0,0,1,4,1,0,1,0,1,1,3,1,0,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,359,148,399,282,495,368,497,200,311,375,351,173,505,152,346,566,175,397,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,"L",null,null,null,null,"L",null,null,"X","R",null,null,null,null,null,null,null,null,"L","R","R",null,null,"G","L","X",null,"S",null,"R",null,"L","G","R","SL","S",1,86,128,70.099999999999994,14,{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II7,ROW(INDIRECT(\"1:\"&IE7)))),1)","v":13.4},71,36,8]
["Chace Lake (White)","2006-06-15","Started on the back nine.  Roughest start in a LONG time.  Proud of the comeback I made.","06/15/06 - Chace Lake (White)",6,3,5,4,5,4,5,4,4,7,8,6,7,5,5,5,4,5,2,1,2,2,2,2,2,3,2,2,3,2,3,2,2,1,3,2,"DT",null,1,null,null,null,null,"P",null,"SD","MTP","MT","P","MW",null,null,"P",null,null,null,null,1,1,1,1,null,1,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,3,4,null,null,2,null,null,null,null,2,1,1,0,0,0,0,0,0,3,3,3,1,2,1,1,0,1,2,0,1,0,0,0,0,1,0,3,4,3,2,2,1,0,1,1,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,359,148,399,282,495,368,497,200,311,375,351,173,505,152,346,566,175,397,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,"R",null,"L",null,null,null,null,null,"R","R","R",null,"L",null,"L","R",null,null,"S","S",null,"GR",null,"S","S","S","R","LG","R","L","S","RG","L","R","G","L",1,92,128,70.099999999999994,19.3,{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II8,ROW(INDIRECT(\"1:\"&IE8)))),1)","v":13.4},71,38,7]
["Chace Lake (White)","2006-06-22",null,"06/22/06 - Chace Lake (White)",6,4,5,4,6,4,6,3,6,4,6,4,7,3,4,8,4,5,3,2,1,1,2,1,3,1,3,2,2,3,2,1,2,2,2,2,"FWP","S","MT",null,null,null,"P",null,"SP",null,"DM","P","D",null,null,"DLS",null,null,null,null,1,1,null,1,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,2,1,1,1,0,1,1,0,2,0,2,1,0,3,1,1,2,1,1,0,1,0,1,0,2,0,2,1,2,0,0,3,1,1,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,359,148,399,282,495,368,497,200,311,375,351,173,505,152,346,566,175,397,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,"L",null,"L",null,"R","L","L",null,"R",null,"L",null,"L",null,null,"R",null,"L","S","R","R","SR","SR","R","G","SR","SR","G","S","S",null,"S","S","R","R",null,2,89,128,70.099999999999994,16.7,{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II9,ROW(INDIRECT(\"1:\"&IE9)))),1)","v":13.4},71,35,4]
["Chace Lake (Blue)","2006-06-24",null,"06/24/06 - Chace Lake (Blue)",7,3,4,6,6,6,5,4,5,6,6,5,7,3,7,5,4,7,3,1,1,3,2,2,2,2,2,2,2,2,2,1,3,2,3,3,"TP",null,null,"SP","F","W",null,"C","S","M","D","T","L",null,"CP",null,"P","DFP",1,null,1,1,1,null,1,null,1,1,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,1,null,null,null,null,2,1,1,1,1,2,0,1,1,2,2,2,2,1,2,0,0,2,3,0,0,2,1,2,0,1,1,2,2,2,2,0,3,0,1,3,1,0,1,1,1,1,1,0,1,1,1,0,1,0,1,1,0,1,4,3,4,4,5,4,5,3,4,4,4,3,5,3,4,5,3,4,380,155,414,308,574,419,548,206,320,405,376,198,522,172,378,554,194,454,13,17,3,11,1,9,5,15,7,4,10,14,8,18,12,2,16,6,null,null,null,null,null,"L",null,null,null,"L","X",null,"R",null,"R","R",null,"R","R","SR","L","SR","R",null,null,"R","SR","G","SR","SR",null,"SR","GL","G","S",null,2,96,125,71.2,22.4,{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II10,ROW(INDIRECT(\"1:\"&IE10)))),1)","v":13.4},71,38,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II11,ROW(INDIRECT(\"1:\"&IE11)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II12,ROW(INDIRECT(\"1:\"&IE12)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II13,ROW(INDIRECT(\"1:\"&IE13)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II14,ROW(INDIRECT(\"1:\"&IE14)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II15,ROW(INDIRECT(\"1:\"&IE15)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II16,ROW(INDIRECT(\"1:\"&IE16)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II17,ROW(INDIRECT(\"1:\"&IE17)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II18,ROW(INDIRECT(\"1:\"&IE18)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II19,ROW(INDIRECT(\"1:\"&IE19)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II20,ROW(INDIRECT(\"1:\"&IE20)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II21,ROW(INDIRECT(\"1:\"&IE21)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"TRUNC(0.96*AVERAGE(SMALL($II$3:II22,ROW(INDIRECT(\"1:\"&IE22)))),1)","v":{"$error":"#N/A"}},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"ROUND((IF23-IH23)*113/IG23,1)","v":{"$error":"#N/A"}},{"$f":"TRUNC(0.96*AVERAGE(SMALL(II3:II23,ROW(INDIRECT(\"1:\"&IE23)))),1)","v":{"$error":"#N/A"}},0,0,0]

{"sheet":"Course Data","index":7,"n_rows":5,"n_cols":66,"rows_kept":5,"cut":false,"hidden":true,"merged":[[1,3,1,23],[1,24,1,44],[1,45,1,65]]}
[]
[null,2,2,"Yards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Par",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handicap"]
["Course","Rating","Slope",1,2,3,4,5,6,7,8,9,"Out",10,11,12,13,14,15,16,17,18,"In","Total",1,2,3,4,5,6,7,8,9,"Out",10,11,12,13,14,15,16,17,18,"In","Total",1,2,3,4,5,6,7,8,9,"Out",10,11,12,13,14,15,16,17,18,"In","Total"]
["Chace Lake (White)",70.099999999999994,128,359,148,399,282,495,368,497,200,311,3059,375,351,173,505,152,346,566,175,397,3040,6099,4,3,4,4,5,4,5,3,4,36,4,4,3,5,3,4,5,3,4,35,71,13,17,3,11,1,9,5,15,7,null,4,10,14,8,18,12,2,16,6]
["Chace Lake (Blue)",71.2,125,380,155,414,308,574,419,548,206,320,3324,405,376,198,522,172,378,554,194,454,3253,6577,4,3,4,4,5,4,5,3,4,36,4,4,3,5,3,4,5,3,4,35,71,13,17,3,11,1,9,5,15,7,null,4,10,14,8,18,12,2,16,6]

{"sheet":"Misc","index":8,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Move",true]
["Direction",-4121]
[]
[]
["GIRs",1,{"$f":"+B5+1","v":2},3,4,5,6,7,8,9,10,11,12,13]
["Score",93,91,89,87,85,83,81,79,77,75,73,71,69]
[]
[{"$f":"Main!A1","v":"Golf Stats v1.7"}]