{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Scores","Settings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["Golf League Tracker Callaway Scoring Worksheet"]
["www.GolfLeagueTracker.com"]
[]
["About"]
[null,"The Callaway scoring system is designed for a one-day tournament where players don't have official handicaps, and "]
[null,"in fact, have a handicap calculated based on the round that they play.   For detailed information on how Callaway works"]
[null,"take a look at this article online:"]
[null,"https://www.thoughtco.com/how-to-use-the-callaway-system-1564469"]
[]
["Instructions"]
[1,"Enter the correct Par numbers for each hole of your course.  This is important since there is a double-par rule using the Callaway System"]
[2,"Input actual hole by hole scores"]
[3,"Standard rules for this system is to ignore the score on holes 17 and 18 for handciap adjustments.  This prevents a player from getting an artificially high score on 17 and 18 to inflate his handicap.  You also have the option to exclude the 16th hole by clicking on the \"Exclude\" button on the Settings sheet."]
[4,"Sheet is set for 40 players. If you want to use more players, just copy the *entire row* down.  Be sure to select the entire row so the hidden formulas are also copied. "]

{"sheet":"Scores","index":1,"n_rows":52,"n_cols":45,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Golf League Tracker Callaway Scoring"]
["www.GolfLeagueTracker.com"]
[]
[null,"Hole",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,"Total",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,null,"Worst",null,"Additional Stroke Adj","Hdcp","Net Score"]
["Player Name","Par",4,3,4,3,4,4,5,5,4,4,5,3,4,4,5,3,4,4,{"$f":"SUM(C5:T5)","v":72}]
["Player 1",null,4,4,4,4,6,6,6,4,4,4,4,4,4,4,4,4,4,4,{"$f":"IF(SUM(C6:T6)=0,\"\",SUM(C6:T6))","v":78},{"$f":"IF(C6>2*C$5,2*C$5,C6)","v":4},{"$f":"IF(D6>2*D$5,2*D$5,D6)","v":4},{"$f":"IF(E6>2*E$5,2*E$5,E6)","v":4},{"$f":"IF(F6>2*F$5,2*F$5,F6)","v":4},{"$f":"IF(G6>2*G$5,2*G$5,G6)","v":6},{"$f":"IF(H6>2*H$5,2*H$5,H6)","v":6},{"$f":"IF(I6>2*I$5,2*I$5,I6)","v":6},{"$f":"IF(J6>2*J$5,2*J$5,J6)","v":4},{"$f":"IF(K6>2*K$5,2*K$5,K6)","v":4},{"$f":"IF(L6>2*L$5,2*L$5,L6)","v":4},{"$f":"IF(M6>2*M$5,2*M$5,M6)","v":4},{"$f":"IF(N6>2*N$5,2*N$5,N6)","v":4},{"$f":"IF(O6>2*O$5,2*O$5,O6)","v":4},{"$f":"IF(P6>2*P$5,2*P$5,P6)","v":4},{"$f":"IF(Q6>2*Q$5,2*Q$5,Q6)","v":4},{"$f":"IF(R6>2*R$5,2*R$5,R6)","v":4},{"$f":"IF(S6>2*S$5,2*S$5,S6)","v":4},{"$f":"IF(T6>2*T$5,2*T$5,T6)","v":4},{"$f":"IF(U6>130,\"6 Worst Holes\",VLOOKUP(U6,Settings!$A$18:$J$80,2,FALSE))","v":"Worst Hole"},{"$f":"IF(AN6=\"Scratch\",\"0\",IF(AN6=\"1/2 of Worst Hole\",MAX(V6:AJ6)/2,IF(AN6=\"Worst Hole\",MAX(V6:AJ6),IF(AN6=\"1 1/2 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)/2,IF(AN6=\"2 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2),IF(AN6=\"2 1/2 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)/2,IF(AN6=\"3 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3),\"\")))))))","v":6},{"$f":"IF(AN6=\"3 1/2 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)+LARGE(V6:AJ6,4)/2,IF(AN6=\"4 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)+LARGE(V6:AJ6,4),IF(AN6=\"4 1/2 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)+LARGE(V6:AJ6,4)+LARGE(V6:AJ6,5)/2,IF(AN6=\"5 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)+LARGE(V6:AJ6,4)+LARGE(V6:AJ6,5),IF(AN6=\"5 1/2 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)+LARGE(V6:AJ6,4)+LARGE(V6:AJ6,5)+LARGE(V6:AJ6,5)/2,IF(AN6=\"6 Worst Holes\",MAX(V6:AJ6)+LARGE(V6:AJ6,2)+LARGE(V6:AJ6,3)+LARGE(V6:AJ6,4)+LARGE(V6:AJ6,5)+LARGE(V6:AJ6,5),\"\"))))))","v":""},{"$f":"VLOOKUP(U6,Settings!$A$18:$J$80,3,FALSE)","v":0},{"$f":"IF(ISERROR(IF(ISNUMBER(AO6),ROUND(AO6+AQ6,0),ROUND(AP6+AQ6,0))),0,IF(ISNUMBER(AO6),ROUND(AO6+AQ6,0),ROUND(AP6+AQ6,0)))","v":6},{"$f":"IF(ISERROR(AQ6),\"\",U6-AR6)","v":72}]
["Player 2",null,4,4,4,4,5,4,5,4,4,4,4,4,4,4,4,6,4,4,{"$f":"IF(SUM(C7:T7)=0,\"\",SUM(C7:T7))","v":76},{"$f":"IF(C7>2*C$5,2*C$5,C7)","v":4},{"$f":"IF(D7>2*D$5,2*D$5,D7)","v":4},{"$f":"IF(E7>2*E$5,2*E$5,E7)","v":4},{"$f":"IF(F7>2*F$5,2*F$5,F7)","v":4},{"$f":"IF(G7>2*G$5,2*G$5,G7)","v":5},{"$f":"IF(H7>2*H$5,2*H$5,H7)","v":4},{"$f":"IF(I7>2*I$5,2*I$5,I7)","v":5},{"$f":"IF(J7>2*J$5,2*J$5,J7)","v":4},{"$f":"IF(K7>2*K$5,2*K$5,K7)","v":4},{"$f":"IF(L7>2*L$5,2*L$5,L7)","v":4},{"$f":"IF(M7>2*M$5,2*M$5,M7)","v":4},{"$f":"IF(N7>2*N$5,2*N$5,N7)","v":4},{"$f":"IF(O7>2*O$5,2*O$5,O7)","v":4},{"$f":"IF(P7>2*P$5,2*P$5,P7)","v":4},{"$f":"IF(Q7>2*Q$5,2*Q$5,Q7)","v":4},{"$f":"IF(R7>2*R$5,2*R$5,R7)","v":6},{"$f":"IF(S7>2*S$5,2*S$5,S7)","v":4},{"$f":"IF(T7>2*T$5,2*T$5,T7)","v":4},{"$f":"IF(U7>130,\"6 Worst Holes\",VLOOKUP(U7,Settings!$A$18:$J$80,2,FALSE))","v":"Worst Hole"},{"$f":"IF(AN7=\"Scratch\",\"0\",IF(AN7=\"1/2 of Worst Hole\",MAX(V7:AJ7)/2,IF(AN7=\"Worst Hole\",MAX(V7:AJ7),IF(AN7=\"1 1/2 Worst Holes\",MAX(V7:AJ7)+LARGE(V7:AJ7,2)/2,IF(AN7=\"2 Worst Holes\",MAX(V7:AJ7)+LARGE(V7:AJ7,2),IF(AN7=\"2 1/2 Worst Holes\",MAX(V7:AJ7)+LARGE(V7:AJ7,2)+LARGE(V7:AJ7,3)/2,IF(AN7=\"3 Worst Holes\",MAX(V7:AJ7)+LARGE(V7:AJ7,2)+LARGE(V7:AJ7,3),\"\")))))))","v":5},{"$f":"IF(AN7=\"3 1/2 Worst Holes\",MAX(V7:AM7)+LARGE(V7:AM7,2)+LARGE(V7:AM7,3)+LARGE(V7:AM7,4)/2,IF(AN7=\"4 Worst Holes\",MAX(V7:AM7)+LARGE(V7:AM7,2)+LARGE(V7:AM7,3)+LARGE(V7:AM7,4),IF(AN7=\"4 1/2 Worst Holes\",MAX(V7:AM7)+LARGE(V7:AM7,2)+LARGE(V7:AM7,3)+LARGE(V7:AM7,4)+LARGE(V7:AM7,5)/2,IF(AN7=\"5 Worst Holes\",MAX(V7:AM7)+LARGE(V7:AM7,2)+LARGE(V7:AM7,3)+LARGE(V7:AM7,4)+LARGE(V7:AM7,5),IF(AN7=\"5 1/2 Worst Holes\",MAX(V7:AM7)+LARGE(V7:AM7,2)+LARGE(V7:AM7,3)+LARGE(V7:AM7,4)+LARGE(V7:AM7,5)+LARGE(V7:AM7,5)/2,IF(AN7=\"6 Worst Holes\",MAX(V7:AM7)+LARGE(V7:AM7,2)+LARGE(V7:AM7,3)+LARGE(V7:AM7,4)+LARGE(V7:AM7,5)+LARGE(V7:AM7,5),\"\"))))))","v":""},{"$f":"VLOOKUP(U7,Settings!$A$18:$J$80,3,FALSE)","v":-2},{"$f":"IF(ISERROR(IF(ISNUMBER(AO7),ROUND(AO7+AQ7,0),ROUND(AP7+AQ7,0))),0,IF(ISNUMBER(AO7),ROUND(AO7+AQ7,0),ROUND(AP7+AQ7,0)))","v":3},{"$f":"IF(ISERROR(AQ7),\"\",U7-AR7)","v":73}]
["Player 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C8>2*C$5,2*C$5,C8)","v":0},{"$f":"IF(D8>2*D$5,2*D$5,D8)","v":0},{"$f":"IF(E8>2*E$5,2*E$5,E8)","v":0},{"$f":"IF(F8>2*F$5,2*F$5,F8)","v":0},{"$f":"IF(G8>2*G$5,2*G$5,G8)","v":0},{"$f":"IF(H8>2*H$5,2*H$5,H8)","v":0},{"$f":"IF(I8>2*I$5,2*I$5,I8)","v":0},{"$f":"IF(J8>2*J$5,2*J$5,J8)","v":0},{"$f":"IF(K8>2*K$5,2*K$5,K8)","v":0},{"$f":"IF(L8>2*L$5,2*L$5,L8)","v":0},{"$f":"IF(M8>2*M$5,2*M$5,M8)","v":0},{"$f":"IF(N8>2*N$5,2*N$5,N8)","v":0},{"$f":"IF(O8>2*O$5,2*O$5,O8)","v":0},{"$f":"IF(P8>2*P$5,2*P$5,P8)","v":0},{"$f":"IF(Q8>2*Q$5,2*Q$5,Q8)","v":0},{"$f":"IF(R8>2*R$5,2*R$5,R8)","v":0},{"$f":"IF(S8>2*S$5,2*S$5,S8)","v":0},{"$f":"IF(T8>2*T$5,2*T$5,T8)","v":0},{"$f":"IF(U8>130,\"6 Worst Holes\",VLOOKUP(U8,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN8=\"Scratch\",\"0\",IF(AN8=\"1/2 of Worst Hole\",MAX(V8:AJ8)/2,IF(AN8=\"Worst Hole\",MAX(V8:AJ8),IF(AN8=\"1 1/2 Worst Holes\",MAX(V8:AJ8)+LARGE(V8:AJ8,2)/2,IF(AN8=\"2 Worst Holes\",MAX(V8:AJ8)+LARGE(V8:AJ8,2),IF(AN8=\"2 1/2 Worst Holes\",MAX(V8:AJ8)+LARGE(V8:AJ8,2)+LARGE(V8:AJ8,3)/2,IF(AN8=\"3 Worst Holes\",MAX(V8:AJ8)+LARGE(V8:AJ8,2)+LARGE(V8:AJ8,3),\"\")))))))","v":""},{"$f":"IF(AN8=\"3 1/2 Worst Holes\",MAX(V8:AM8)+LARGE(V8:AM8,2)+LARGE(V8:AM8,3)+LARGE(V8:AM8,4)/2,IF(AN8=\"4 Worst Holes\",MAX(V8:AM8)+LARGE(V8:AM8,2)+LARGE(V8:AM8,3)+LARGE(V8:AM8,4),IF(AN8=\"4 1/2 Worst Holes\",MAX(V8:AM8)+LARGE(V8:AM8,2)+LARGE(V8:AM8,3)+LARGE(V8:AM8,4)+LARGE(V8:AM8,5)/2,IF(AN8=\"5 Worst Holes\",MAX(V8:AM8)+LARGE(V8:AM8,2)+LARGE(V8:AM8,3)+LARGE(V8:AM8,4)+LARGE(V8:AM8,5),IF(AN8=\"5 1/2 Worst Holes\",MAX(V8:AM8)+LARGE(V8:AM8,2)+LARGE(V8:AM8,3)+LARGE(V8:AM8,4)+LARGE(V8:AM8,5)+LARGE(V8:AM8,5)/2,IF(AN8=\"6 Worst Holes\",MAX(V8:AM8)+LARGE(V8:AM8,2)+LARGE(V8:AM8,3)+LARGE(V8:AM8,4)+LARGE(V8:AM8,5)+LARGE(V8:AM8,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U8,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO8),ROUND(AO8+AQ8,0),ROUND(AP8+AQ8,0))),0,IF(ISNUMBER(AO8),ROUND(AO8+AQ8,0),ROUND(AP8+AQ8,0)))","v":0},{"$f":"IF(ISERROR(AQ8),\"\",U8-AR8)","v":""}]
["Player 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C9>2*C$5,2*C$5,C9)","v":0},{"$f":"IF(D9>2*D$5,2*D$5,D9)","v":0},{"$f":"IF(E9>2*E$5,2*E$5,E9)","v":0},{"$f":"IF(F9>2*F$5,2*F$5,F9)","v":0},{"$f":"IF(G9>2*G$5,2*G$5,G9)","v":0},{"$f":"IF(H9>2*H$5,2*H$5,H9)","v":0},{"$f":"IF(I9>2*I$5,2*I$5,I9)","v":0},{"$f":"IF(J9>2*J$5,2*J$5,J9)","v":0},{"$f":"IF(K9>2*K$5,2*K$5,K9)","v":0},{"$f":"IF(L9>2*L$5,2*L$5,L9)","v":0},{"$f":"IF(M9>2*M$5,2*M$5,M9)","v":0},{"$f":"IF(N9>2*N$5,2*N$5,N9)","v":0},{"$f":"IF(O9>2*O$5,2*O$5,O9)","v":0},{"$f":"IF(P9>2*P$5,2*P$5,P9)","v":0},{"$f":"IF(Q9>2*Q$5,2*Q$5,Q9)","v":0},{"$f":"IF(R9>2*R$5,2*R$5,R9)","v":0},{"$f":"IF(S9>2*S$5,2*S$5,S9)","v":0},{"$f":"IF(T9>2*T$5,2*T$5,T9)","v":0},{"$f":"IF(U9>130,\"6 Worst Holes\",VLOOKUP(U9,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN9=\"Scratch\",\"0\",IF(AN9=\"1/2 of Worst Hole\",MAX(V9:AJ9)/2,IF(AN9=\"Worst Hole\",MAX(V9:AJ9),IF(AN9=\"1 1/2 Worst Holes\",MAX(V9:AJ9)+LARGE(V9:AJ9,2)/2,IF(AN9=\"2 Worst Holes\",MAX(V9:AJ9)+LARGE(V9:AJ9,2),IF(AN9=\"2 1/2 Worst Holes\",MAX(V9:AJ9)+LARGE(V9:AJ9,2)+LARGE(V9:AJ9,3)/2,IF(AN9=\"3 Worst Holes\",MAX(V9:AJ9)+LARGE(V9:AJ9,2)+LARGE(V9:AJ9,3),\"\")))))))","v":""},{"$f":"IF(AN9=\"3 1/2 Worst Holes\",MAX(V9:AM9)+LARGE(V9:AM9,2)+LARGE(V9:AM9,3)+LARGE(V9:AM9,4)/2,IF(AN9=\"4 Worst Holes\",MAX(V9:AM9)+LARGE(V9:AM9,2)+LARGE(V9:AM9,3)+LARGE(V9:AM9,4),IF(AN9=\"4 1/2 Worst Holes\",MAX(V9:AM9)+LARGE(V9:AM9,2)+LARGE(V9:AM9,3)+LARGE(V9:AM9,4)+LARGE(V9:AM9,5)/2,IF(AN9=\"5 Worst Holes\",MAX(V9:AM9)+LARGE(V9:AM9,2)+LARGE(V9:AM9,3)+LARGE(V9:AM9,4)+LARGE(V9:AM9,5),IF(AN9=\"5 1/2 Worst Holes\",MAX(V9:AM9)+LARGE(V9:AM9,2)+LARGE(V9:AM9,3)+LARGE(V9:AM9,4)+LARGE(V9:AM9,5)+LARGE(V9:AM9,5)/2,IF(AN9=\"6 Worst Holes\",MAX(V9:AM9)+LARGE(V9:AM9,2)+LARGE(V9:AM9,3)+LARGE(V9:AM9,4)+LARGE(V9:AM9,5)+LARGE(V9:AM9,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U9,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO9),ROUND(AO9+AQ9,0),ROUND(AP9+AQ9,0))),0,IF(ISNUMBER(AO9),ROUND(AO9+AQ9,0),ROUND(AP9+AQ9,0)))","v":0},{"$f":"IF(ISERROR(AQ9),\"\",U9-AR9)","v":""}]
["Player 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C10>2*C$5,2*C$5,C10)","v":0},{"$f":"IF(D10>2*D$5,2*D$5,D10)","v":0},{"$f":"IF(E10>2*E$5,2*E$5,E10)","v":0},{"$f":"IF(F10>2*F$5,2*F$5,F10)","v":0},{"$f":"IF(G10>2*G$5,2*G$5,G10)","v":0},{"$f":"IF(H10>2*H$5,2*H$5,H10)","v":0},{"$f":"IF(I10>2*I$5,2*I$5,I10)","v":0},{"$f":"IF(J10>2*J$5,2*J$5,J10)","v":0},{"$f":"IF(K10>2*K$5,2*K$5,K10)","v":0},{"$f":"IF(L10>2*L$5,2*L$5,L10)","v":0},{"$f":"IF(M10>2*M$5,2*M$5,M10)","v":0},{"$f":"IF(N10>2*N$5,2*N$5,N10)","v":0},{"$f":"IF(O10>2*O$5,2*O$5,O10)","v":0},{"$f":"IF(P10>2*P$5,2*P$5,P10)","v":0},{"$f":"IF(Q10>2*Q$5,2*Q$5,Q10)","v":0},{"$f":"IF(R10>2*R$5,2*R$5,R10)","v":0},{"$f":"IF(S10>2*S$5,2*S$5,S10)","v":0},{"$f":"IF(T10>2*T$5,2*T$5,T10)","v":0},{"$f":"IF(U10>130,\"6 Worst Holes\",VLOOKUP(U10,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN10=\"Scratch\",\"0\",IF(AN10=\"1/2 of Worst Hole\",MAX(V10:AJ10)/2,IF(AN10=\"Worst Hole\",MAX(V10:AJ10),IF(AN10=\"1 1/2 Worst Holes\",MAX(V10:AJ10)+LARGE(V10:AJ10,2)/2,IF(AN10=\"2 Worst Holes\",MAX(V10:AJ10)+LARGE(V10:AJ10,2),IF(AN10=\"2 1/2 Worst Holes\",MAX(V10:AJ10)+LARGE(V10:AJ10,2)+LARGE(V10:AJ10,3)/2,IF(AN10=\"3 Worst Holes\",MAX(V10:AJ10)+LARGE(V10:AJ10,2)+LARGE(V10:AJ10,3),\"\")))))))","v":""},{"$f":"IF(AN10=\"3 1/2 Worst Holes\",MAX(V10:AM10)+LARGE(V10:AM10,2)+LARGE(V10:AM10,3)+LARGE(V10:AM10,4)/2,IF(AN10=\"4 Worst Holes\",MAX(V10:AM10)+LARGE(V10:AM10,2)+LARGE(V10:AM10,3)+LARGE(V10:AM10,4),IF(AN10=\"4 1/2 Worst Holes\",MAX(V10:AM10)+LARGE(V10:AM10,2)+LARGE(V10:AM10,3)+LARGE(V10:AM10,4)+LARGE(V10:AM10,5)/2,IF(AN10=\"5 Worst Holes\",MAX(V10:AM10)+LARGE(V10:AM10,2)+LARGE(V10:AM10,3)+LARGE(V10:AM10,4)+LARGE(V10:AM10,5),IF(AN10=\"5 1/2 Worst Holes\",MAX(V10:AM10)+LARGE(V10:AM10,2)+LARGE(V10:AM10,3)+LARGE(V10:AM10,4)+LARGE(V10:AM10,5)+LARGE(V10:AM10,5)/2,IF(AN10=\"6 Worst Holes\",MAX(V10:AM10)+LARGE(V10:AM10,2)+LARGE(V10:AM10,3)+LARGE(V10:AM10,4)+LARGE(V10:AM10,5)+LARGE(V10:AM10,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U10,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO10),ROUND(AO10+AQ10,0),ROUND(AP10+AQ10,0))),0,IF(ISNUMBER(AO10),ROUND(AO10+AQ10,0),ROUND(AP10+AQ10,0)))","v":0},{"$f":"IF(ISERROR(AQ10),\"\",U10-AR10)","v":""}]
["Player 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C11:T11)=0,\"\",SUM(C11:T11))","v":""},{"$f":"IF(C11>2*C$5,2*C$5,C11)","v":0},{"$f":"IF(D11>2*D$5,2*D$5,D11)","v":0},{"$f":"IF(E11>2*E$5,2*E$5,E11)","v":0},{"$f":"IF(F11>2*F$5,2*F$5,F11)","v":0},{"$f":"IF(G11>2*G$5,2*G$5,G11)","v":0},{"$f":"IF(H11>2*H$5,2*H$5,H11)","v":0},{"$f":"IF(I11>2*I$5,2*I$5,I11)","v":0},{"$f":"IF(J11>2*J$5,2*J$5,J11)","v":0},{"$f":"IF(K11>2*K$5,2*K$5,K11)","v":0},{"$f":"IF(L11>2*L$5,2*L$5,L11)","v":0},{"$f":"IF(M11>2*M$5,2*M$5,M11)","v":0},{"$f":"IF(N11>2*N$5,2*N$5,N11)","v":0},{"$f":"IF(O11>2*O$5,2*O$5,O11)","v":0},{"$f":"IF(P11>2*P$5,2*P$5,P11)","v":0},{"$f":"IF(Q11>2*Q$5,2*Q$5,Q11)","v":0},{"$f":"IF(R11>2*R$5,2*R$5,R11)","v":0},{"$f":"IF(S11>2*S$5,2*S$5,S11)","v":0},{"$f":"IF(T11>2*T$5,2*T$5,T11)","v":0},{"$f":"IF(U11>130,\"6 Worst Holes\",VLOOKUP(U11,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN11=\"Scratch\",\"0\",IF(AN11=\"1/2 of Worst Hole\",MAX(V11:AJ11)/2,IF(AN11=\"Worst Hole\",MAX(V11:AJ11),IF(AN11=\"1 1/2 Worst Holes\",MAX(V11:AJ11)+LARGE(V11:AJ11,2)/2,IF(AN11=\"2 Worst Holes\",MAX(V11:AJ11)+LARGE(V11:AJ11,2),IF(AN11=\"2 1/2 Worst Holes\",MAX(V11:AJ11)+LARGE(V11:AJ11,2)+LARGE(V11:AJ11,3)/2,IF(AN11=\"3 Worst Holes\",MAX(V11:AJ11)+LARGE(V11:AJ11,2)+LARGE(V11:AJ11,3),\"\")))))))","v":""},{"$f":"IF(AN11=\"3 1/2 Worst Holes\",MAX(V11:AM11)+LARGE(V11:AM11,2)+LARGE(V11:AM11,3)+LARGE(V11:AM11,4)/2,IF(AN11=\"4 Worst Holes\",MAX(V11:AM11)+LARGE(V11:AM11,2)+LARGE(V11:AM11,3)+LARGE(V11:AM11,4),IF(AN11=\"4 1/2 Worst Holes\",MAX(V11:AM11)+LARGE(V11:AM11,2)+LARGE(V11:AM11,3)+LARGE(V11:AM11,4)+LARGE(V11:AM11,5)/2,IF(AN11=\"5 Worst Holes\",MAX(V11:AM11)+LARGE(V11:AM11,2)+LARGE(V11:AM11,3)+LARGE(V11:AM11,4)+LARGE(V11:AM11,5),IF(AN11=\"5 1/2 Worst Holes\",MAX(V11:AM11)+LARGE(V11:AM11,2)+LARGE(V11:AM11,3)+LARGE(V11:AM11,4)+LARGE(V11:AM11,5)+LARGE(V11:AM11,5)/2,IF(AN11=\"6 Worst Holes\",MAX(V11:AM11)+LARGE(V11:AM11,2)+LARGE(V11:AM11,3)+LARGE(V11:AM11,4)+LARGE(V11:AM11,5)+LARGE(V11:AM11,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U11,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO11),ROUND(AO11+AQ11,0),ROUND(AP11+AQ11,0))),0,IF(ISNUMBER(AO11),ROUND(AO11+AQ11,0),ROUND(AP11+AQ11,0)))","v":0},{"$f":"IF(ISERROR(AQ11),\"\",U11-AR11)","v":""}]
["Player 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U12>130,\"6 Worst Holes\",VLOOKUP(U12,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN12=\"Scratch\",\"0\",IF(AN12=\"1/2 of Worst Hole\",MAX(V12:AJ12)/2,IF(AN12=\"Worst Hole\",MAX(V12:AJ12),IF(AN12=\"1 1/2 Worst Holes\",MAX(V12:AJ12)+LARGE(V12:AJ12,2)/2,IF(AN12=\"2 Worst Holes\",MAX(V12:AJ12)+LARGE(V12:AJ12,2),IF(AN12=\"2 1/2 Worst Holes\",MAX(V12:AJ12)+LARGE(V12:AJ12,2)+LARGE(V12:AJ12,3)/2,IF(AN12=\"3 Worst Holes\",MAX(V12:AJ12)+LARGE(V12:AJ12,2)+LARGE(V12:AJ12,3),\"\")))))))","v":""},{"$f":"IF(AN12=\"3 1/2 Worst Holes\",MAX(V12:AM12)+LARGE(V12:AM12,2)+LARGE(V12:AM12,3)+LARGE(V12:AM12,4)/2,IF(AN12=\"4 Worst Holes\",MAX(V12:AM12)+LARGE(V12:AM12,2)+LARGE(V12:AM12,3)+LARGE(V12:AM12,4),IF(AN12=\"4 1/2 Worst Holes\",MAX(V12:AM12)+LARGE(V12:AM12,2)+LARGE(V12:AM12,3)+LARGE(V12:AM12,4)+LARGE(V12:AM12,5)/2,IF(AN12=\"5 Worst Holes\",MAX(V12:AM12)+LARGE(V12:AM12,2)+LARGE(V12:AM12,3)+LARGE(V12:AM12,4)+LARGE(V12:AM12,5),IF(AN12=\"5 1/2 Worst Holes\",MAX(V12:AM12)+LARGE(V12:AM12,2)+LARGE(V12:AM12,3)+LARGE(V12:AM12,4)+LARGE(V12:AM12,5)+LARGE(V12:AM12,5)/2,IF(AN12=\"6 Worst Holes\",MAX(V12:AM12)+LARGE(V12:AM12,2)+LARGE(V12:AM12,3)+LARGE(V12:AM12,4)+LARGE(V12:AM12,5)+LARGE(V12:AM12,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U12,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO12),ROUND(AO12+AQ12,0),ROUND(AP12+AQ12,0))),0,IF(ISNUMBER(AO12),ROUND(AO12+AQ12,0),ROUND(AP12+AQ12,0)))","v":0},{"$f":"IF(ISERROR(AQ12),\"\",U12-AR12)","v":""}]
["Player 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U13>130,\"6 Worst Holes\",VLOOKUP(U13,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN13=\"Scratch\",\"0\",IF(AN13=\"1/2 of Worst Hole\",MAX(V13:AJ13)/2,IF(AN13=\"Worst Hole\",MAX(V13:AJ13),IF(AN13=\"1 1/2 Worst Holes\",MAX(V13:AJ13)+LARGE(V13:AJ13,2)/2,IF(AN13=\"2 Worst Holes\",MAX(V13:AJ13)+LARGE(V13:AJ13,2),IF(AN13=\"2 1/2 Worst Holes\",MAX(V13:AJ13)+LARGE(V13:AJ13,2)+LARGE(V13:AJ13,3)/2,IF(AN13=\"3 Worst Holes\",MAX(V13:AJ13)+LARGE(V13:AJ13,2)+LARGE(V13:AJ13,3),\"\")))))))","v":""},{"$f":"IF(AN13=\"3 1/2 Worst Holes\",MAX(V13:AM13)+LARGE(V13:AM13,2)+LARGE(V13:AM13,3)+LARGE(V13:AM13,4)/2,IF(AN13=\"4 Worst Holes\",MAX(V13:AM13)+LARGE(V13:AM13,2)+LARGE(V13:AM13,3)+LARGE(V13:AM13,4),IF(AN13=\"4 1/2 Worst Holes\",MAX(V13:AM13)+LARGE(V13:AM13,2)+LARGE(V13:AM13,3)+LARGE(V13:AM13,4)+LARGE(V13:AM13,5)/2,IF(AN13=\"5 Worst Holes\",MAX(V13:AM13)+LARGE(V13:AM13,2)+LARGE(V13:AM13,3)+LARGE(V13:AM13,4)+LARGE(V13:AM13,5),IF(AN13=\"5 1/2 Worst Holes\",MAX(V13:AM13)+LARGE(V13:AM13,2)+LARGE(V13:AM13,3)+LARGE(V13:AM13,4)+LARGE(V13:AM13,5)+LARGE(V13:AM13,5)/2,IF(AN13=\"6 Worst Holes\",MAX(V13:AM13)+LARGE(V13:AM13,2)+LARGE(V13:AM13,3)+LARGE(V13:AM13,4)+LARGE(V13:AM13,5)+LARGE(V13:AM13,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U13,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO13),ROUND(AO13+AQ13,0),ROUND(AP13+AQ13,0))),0,IF(ISNUMBER(AO13),ROUND(AO13+AQ13,0),ROUND(AP13+AQ13,0)))","v":0},{"$f":"IF(ISERROR(AQ13),\"\",U13-AR13)","v":""}]
["Player 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C14:T14)=0,\"\",SUM(C14:T14))","v":""},{"$f":"IF(C14>2*C$5,2*C$5,C14)","v":0},{"$f":"IF(D14>2*D$5,2*D$5,D14)","v":0},{"$f":"IF(E14>2*E$5,2*E$5,E14)","v":0},{"$f":"IF(F14>2*F$5,2*F$5,F14)","v":0},{"$f":"IF(G14>2*G$5,2*G$5,G14)","v":0},{"$f":"IF(H14>2*H$5,2*H$5,H14)","v":0},{"$f":"IF(I14>2*I$5,2*I$5,I14)","v":0},{"$f":"IF(J14>2*J$5,2*J$5,J14)","v":0},{"$f":"IF(K14>2*K$5,2*K$5,K14)","v":0},{"$f":"IF(L14>2*L$5,2*L$5,L14)","v":0},{"$f":"IF(M14>2*M$5,2*M$5,M14)","v":0},{"$f":"IF(N14>2*N$5,2*N$5,N14)","v":0},{"$f":"IF(O14>2*O$5,2*O$5,O14)","v":0},{"$f":"IF(P14>2*P$5,2*P$5,P14)","v":0},{"$f":"IF(Q14>2*Q$5,2*Q$5,Q14)","v":0},{"$f":"IF(R14>2*R$5,2*R$5,R14)","v":0},{"$f":"IF(S14>2*S$5,2*S$5,S14)","v":0},{"$f":"IF(T14>2*T$5,2*T$5,T14)","v":0},{"$f":"IF(U14>130,\"6 Worst Holes\",VLOOKUP(U14,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN14=\"Scratch\",\"0\",IF(AN14=\"1/2 of Worst Hole\",MAX(V14:AJ14)/2,IF(AN14=\"Worst Hole\",MAX(V14:AJ14),IF(AN14=\"1 1/2 Worst Holes\",MAX(V14:AJ14)+LARGE(V14:AJ14,2)/2,IF(AN14=\"2 Worst Holes\",MAX(V14:AJ14)+LARGE(V14:AJ14,2),IF(AN14=\"2 1/2 Worst Holes\",MAX(V14:AJ14)+LARGE(V14:AJ14,2)+LARGE(V14:AJ14,3)/2,IF(AN14=\"3 Worst Holes\",MAX(V14:AJ14)+LARGE(V14:AJ14,2)+LARGE(V14:AJ14,3),\"\")))))))","v":""},{"$f":"IF(AN14=\"3 1/2 Worst Holes\",MAX(V14:AM14)+LARGE(V14:AM14,2)+LARGE(V14:AM14,3)+LARGE(V14:AM14,4)/2,IF(AN14=\"4 Worst Holes\",MAX(V14:AM14)+LARGE(V14:AM14,2)+LARGE(V14:AM14,3)+LARGE(V14:AM14,4),IF(AN14=\"4 1/2 Worst Holes\",MAX(V14:AM14)+LARGE(V14:AM14,2)+LARGE(V14:AM14,3)+LARGE(V14:AM14,4)+LARGE(V14:AM14,5)/2,IF(AN14=\"5 Worst Holes\",MAX(V14:AM14)+LARGE(V14:AM14,2)+LARGE(V14:AM14,3)+LARGE(V14:AM14,4)+LARGE(V14:AM14,5),IF(AN14=\"5 1/2 Worst Holes\",MAX(V14:AM14)+LARGE(V14:AM14,2)+LARGE(V14:AM14,3)+LARGE(V14:AM14,4)+LARGE(V14:AM14,5)+LARGE(V14:AM14,5)/2,IF(AN14=\"6 Worst Holes\",MAX(V14:AM14)+LARGE(V14:AM14,2)+LARGE(V14:AM14,3)+LARGE(V14:AM14,4)+LARGE(V14:AM14,5)+LARGE(V14:AM14,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U14,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO14),ROUND(AO14+AQ14,0),ROUND(AP14+AQ14,0))),0,IF(ISNUMBER(AO14),ROUND(AO14+AQ14,0),ROUND(AP14+AQ14,0)))","v":0},{"$f":"IF(ISERROR(AQ14),\"\",U14-AR14)","v":""}]
["Player 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U15>130,\"6 Worst Holes\",VLOOKUP(U15,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN15=\"Scratch\",\"0\",IF(AN15=\"1/2 of Worst Hole\",MAX(V15:AJ15)/2,IF(AN15=\"Worst Hole\",MAX(V15:AJ15),IF(AN15=\"1 1/2 Worst Holes\",MAX(V15:AJ15)+LARGE(V15:AJ15,2)/2,IF(AN15=\"2 Worst Holes\",MAX(V15:AJ15)+LARGE(V15:AJ15,2),IF(AN15=\"2 1/2 Worst Holes\",MAX(V15:AJ15)+LARGE(V15:AJ15,2)+LARGE(V15:AJ15,3)/2,IF(AN15=\"3 Worst Holes\",MAX(V15:AJ15)+LARGE(V15:AJ15,2)+LARGE(V15:AJ15,3),\"\")))))))","v":""},{"$f":"IF(AN15=\"3 1/2 Worst Holes\",MAX(V15:AM15)+LARGE(V15:AM15,2)+LARGE(V15:AM15,3)+LARGE(V15:AM15,4)/2,IF(AN15=\"4 Worst Holes\",MAX(V15:AM15)+LARGE(V15:AM15,2)+LARGE(V15:AM15,3)+LARGE(V15:AM15,4),IF(AN15=\"4 1/2 Worst Holes\",MAX(V15:AM15)+LARGE(V15:AM15,2)+LARGE(V15:AM15,3)+LARGE(V15:AM15,4)+LARGE(V15:AM15,5)/2,IF(AN15=\"5 Worst Holes\",MAX(V15:AM15)+LARGE(V15:AM15,2)+LARGE(V15:AM15,3)+LARGE(V15:AM15,4)+LARGE(V15:AM15,5),IF(AN15=\"5 1/2 Worst Holes\",MAX(V15:AM15)+LARGE(V15:AM15,2)+LARGE(V15:AM15,3)+LARGE(V15:AM15,4)+LARGE(V15:AM15,5)+LARGE(V15:AM15,5)/2,IF(AN15=\"6 Worst Holes\",MAX(V15:AM15)+LARGE(V15:AM15,2)+LARGE(V15:AM15,3)+LARGE(V15:AM15,4)+LARGE(V15:AM15,5)+LARGE(V15:AM15,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U15,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO15),ROUND(AO15+AQ15,0),ROUND(AP15+AQ15,0))),0,IF(ISNUMBER(AO15),ROUND(AO15+AQ15,0),ROUND(AP15+AQ15,0)))","v":0},{"$f":"IF(ISERROR(AQ15),\"\",U15-AR15)","v":""}]
["Player 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U16>130,\"6 Worst Holes\",VLOOKUP(U16,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN16=\"Scratch\",\"0\",IF(AN16=\"1/2 of Worst Hole\",MAX(V16:AJ16)/2,IF(AN16=\"Worst Hole\",MAX(V16:AJ16),IF(AN16=\"1 1/2 Worst Holes\",MAX(V16:AJ16)+LARGE(V16:AJ16,2)/2,IF(AN16=\"2 Worst Holes\",MAX(V16:AJ16)+LARGE(V16:AJ16,2),IF(AN16=\"2 1/2 Worst Holes\",MAX(V16:AJ16)+LARGE(V16:AJ16,2)+LARGE(V16:AJ16,3)/2,IF(AN16=\"3 Worst Holes\",MAX(V16:AJ16)+LARGE(V16:AJ16,2)+LARGE(V16:AJ16,3),\"\")))))))","v":""},{"$f":"IF(AN16=\"3 1/2 Worst Holes\",MAX(V16:AM16)+LARGE(V16:AM16,2)+LARGE(V16:AM16,3)+LARGE(V16:AM16,4)/2,IF(AN16=\"4 Worst Holes\",MAX(V16:AM16)+LARGE(V16:AM16,2)+LARGE(V16:AM16,3)+LARGE(V16:AM16,4),IF(AN16=\"4 1/2 Worst Holes\",MAX(V16:AM16)+LARGE(V16:AM16,2)+LARGE(V16:AM16,3)+LARGE(V16:AM16,4)+LARGE(V16:AM16,5)/2,IF(AN16=\"5 Worst Holes\",MAX(V16:AM16)+LARGE(V16:AM16,2)+LARGE(V16:AM16,3)+LARGE(V16:AM16,4)+LARGE(V16:AM16,5),IF(AN16=\"5 1/2 Worst Holes\",MAX(V16:AM16)+LARGE(V16:AM16,2)+LARGE(V16:AM16,3)+LARGE(V16:AM16,4)+LARGE(V16:AM16,5)+LARGE(V16:AM16,5)/2,IF(AN16=\"6 Worst Holes\",MAX(V16:AM16)+LARGE(V16:AM16,2)+LARGE(V16:AM16,3)+LARGE(V16:AM16,4)+LARGE(V16:AM16,5)+LARGE(V16:AM16,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U16,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO16),ROUND(AO16+AQ16,0),ROUND(AP16+AQ16,0))),0,IF(ISNUMBER(AO16),ROUND(AO16+AQ16,0),ROUND(AP16+AQ16,0)))","v":0},{"$f":"IF(ISERROR(AQ16),\"\",U16-AR16)","v":""}]
["Player 12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U17>130,\"6 Worst Holes\",VLOOKUP(U17,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN17=\"Scratch\",\"0\",IF(AN17=\"1/2 of Worst Hole\",MAX(V17:AJ17)/2,IF(AN17=\"Worst Hole\",MAX(V17:AJ17),IF(AN17=\"1 1/2 Worst Holes\",MAX(V17:AJ17)+LARGE(V17:AJ17,2)/2,IF(AN17=\"2 Worst Holes\",MAX(V17:AJ17)+LARGE(V17:AJ17,2),IF(AN17=\"2 1/2 Worst Holes\",MAX(V17:AJ17)+LARGE(V17:AJ17,2)+LARGE(V17:AJ17,3)/2,IF(AN17=\"3 Worst Holes\",MAX(V17:AJ17)+LARGE(V17:AJ17,2)+LARGE(V17:AJ17,3),\"\")))))))","v":""},{"$f":"IF(AN17=\"3 1/2 Worst Holes\",MAX(V17:AM17)+LARGE(V17:AM17,2)+LARGE(V17:AM17,3)+LARGE(V17:AM17,4)/2,IF(AN17=\"4 Worst Holes\",MAX(V17:AM17)+LARGE(V17:AM17,2)+LARGE(V17:AM17,3)+LARGE(V17:AM17,4),IF(AN17=\"4 1/2 Worst Holes\",MAX(V17:AM17)+LARGE(V17:AM17,2)+LARGE(V17:AM17,3)+LARGE(V17:AM17,4)+LARGE(V17:AM17,5)/2,IF(AN17=\"5 Worst Holes\",MAX(V17:AM17)+LARGE(V17:AM17,2)+LARGE(V17:AM17,3)+LARGE(V17:AM17,4)+LARGE(V17:AM17,5),IF(AN17=\"5 1/2 Worst Holes\",MAX(V17:AM17)+LARGE(V17:AM17,2)+LARGE(V17:AM17,3)+LARGE(V17:AM17,4)+LARGE(V17:AM17,5)+LARGE(V17:AM17,5)/2,IF(AN17=\"6 Worst Holes\",MAX(V17:AM17)+LARGE(V17:AM17,2)+LARGE(V17:AM17,3)+LARGE(V17:AM17,4)+LARGE(V17:AM17,5)+LARGE(V17:AM17,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U17,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO17),ROUND(AO17+AQ17,0),ROUND(AP17+AQ17,0))),0,IF(ISNUMBER(AO17),ROUND(AO17+AQ17,0),ROUND(AP17+AQ17,0)))","v":0},{"$f":"IF(ISERROR(AQ17),\"\",U17-AR17)","v":""}]
["Player 13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U18>130,\"6 Worst Holes\",VLOOKUP(U18,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN18=\"Scratch\",\"0\",IF(AN18=\"1/2 of Worst Hole\",MAX(V18:AJ18)/2,IF(AN18=\"Worst Hole\",MAX(V18:AJ18),IF(AN18=\"1 1/2 Worst Holes\",MAX(V18:AJ18)+LARGE(V18:AJ18,2)/2,IF(AN18=\"2 Worst Holes\",MAX(V18:AJ18)+LARGE(V18:AJ18,2),IF(AN18=\"2 1/2 Worst Holes\",MAX(V18:AJ18)+LARGE(V18:AJ18,2)+LARGE(V18:AJ18,3)/2,IF(AN18=\"3 Worst Holes\",MAX(V18:AJ18)+LARGE(V18:AJ18,2)+LARGE(V18:AJ18,3),\"\")))))))","v":""},{"$f":"IF(AN18=\"3 1/2 Worst Holes\",MAX(V18:AM18)+LARGE(V18:AM18,2)+LARGE(V18:AM18,3)+LARGE(V18:AM18,4)/2,IF(AN18=\"4 Worst Holes\",MAX(V18:AM18)+LARGE(V18:AM18,2)+LARGE(V18:AM18,3)+LARGE(V18:AM18,4),IF(AN18=\"4 1/2 Worst Holes\",MAX(V18:AM18)+LARGE(V18:AM18,2)+LARGE(V18:AM18,3)+LARGE(V18:AM18,4)+LARGE(V18:AM18,5)/2,IF(AN18=\"5 Worst Holes\",MAX(V18:AM18)+LARGE(V18:AM18,2)+LARGE(V18:AM18,3)+LARGE(V18:AM18,4)+LARGE(V18:AM18,5),IF(AN18=\"5 1/2 Worst Holes\",MAX(V18:AM18)+LARGE(V18:AM18,2)+LARGE(V18:AM18,3)+LARGE(V18:AM18,4)+LARGE(V18:AM18,5)+LARGE(V18:AM18,5)/2,IF(AN18=\"6 Worst Holes\",MAX(V18:AM18)+LARGE(V18:AM18,2)+LARGE(V18:AM18,3)+LARGE(V18:AM18,4)+LARGE(V18:AM18,5)+LARGE(V18:AM18,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U18,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO18),ROUND(AO18+AQ18,0),ROUND(AP18+AQ18,0))),0,IF(ISNUMBER(AO18),ROUND(AO18+AQ18,0),ROUND(AP18+AQ18,0)))","v":0},{"$f":"IF(ISERROR(AQ18),\"\",U18-AR18)","v":""}]
["Player 14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U19>130,\"6 Worst Holes\",VLOOKUP(U19,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN19=\"Scratch\",\"0\",IF(AN19=\"1/2 of Worst Hole\",MAX(V19:AJ19)/2,IF(AN19=\"Worst Hole\",MAX(V19:AJ19),IF(AN19=\"1 1/2 Worst Holes\",MAX(V19:AJ19)+LARGE(V19:AJ19,2)/2,IF(AN19=\"2 Worst Holes\",MAX(V19:AJ19)+LARGE(V19:AJ19,2),IF(AN19=\"2 1/2 Worst Holes\",MAX(V19:AJ19)+LARGE(V19:AJ19,2)+LARGE(V19:AJ19,3)/2,IF(AN19=\"3 Worst Holes\",MAX(V19:AJ19)+LARGE(V19:AJ19,2)+LARGE(V19:AJ19,3),\"\")))))))","v":""},{"$f":"IF(AN19=\"3 1/2 Worst Holes\",MAX(V19:AM19)+LARGE(V19:AM19,2)+LARGE(V19:AM19,3)+LARGE(V19:AM19,4)/2,IF(AN19=\"4 Worst Holes\",MAX(V19:AM19)+LARGE(V19:AM19,2)+LARGE(V19:AM19,3)+LARGE(V19:AM19,4),IF(AN19=\"4 1/2 Worst Holes\",MAX(V19:AM19)+LARGE(V19:AM19,2)+LARGE(V19:AM19,3)+LARGE(V19:AM19,4)+LARGE(V19:AM19,5)/2,IF(AN19=\"5 Worst Holes\",MAX(V19:AM19)+LARGE(V19:AM19,2)+LARGE(V19:AM19,3)+LARGE(V19:AM19,4)+LARGE(V19:AM19,5),IF(AN19=\"5 1/2 Worst Holes\",MAX(V19:AM19)+LARGE(V19:AM19,2)+LARGE(V19:AM19,3)+LARGE(V19:AM19,4)+LARGE(V19:AM19,5)+LARGE(V19:AM19,5)/2,IF(AN19=\"6 Worst Holes\",MAX(V19:AM19)+LARGE(V19:AM19,2)+LARGE(V19:AM19,3)+LARGE(V19:AM19,4)+LARGE(V19:AM19,5)+LARGE(V19:AM19,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U19,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO19),ROUND(AO19+AQ19,0),ROUND(AP19+AQ19,0))),0,IF(ISNUMBER(AO19),ROUND(AO19+AQ19,0),ROUND(AP19+AQ19,0)))","v":0},{"$f":"IF(ISERROR(AQ19),\"\",U19-AR19)","v":""}]
["Player 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U20>130,\"6 Worst Holes\",VLOOKUP(U20,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN20=\"Scratch\",\"0\",IF(AN20=\"1/2 of Worst Hole\",MAX(V20:AJ20)/2,IF(AN20=\"Worst Hole\",MAX(V20:AJ20),IF(AN20=\"1 1/2 Worst Holes\",MAX(V20:AJ20)+LARGE(V20:AJ20,2)/2,IF(AN20=\"2 Worst Holes\",MAX(V20:AJ20)+LARGE(V20:AJ20,2),IF(AN20=\"2 1/2 Worst Holes\",MAX(V20:AJ20)+LARGE(V20:AJ20,2)+LARGE(V20:AJ20,3)/2,IF(AN20=\"3 Worst Holes\",MAX(V20:AJ20)+LARGE(V20:AJ20,2)+LARGE(V20:AJ20,3),\"\")))))))","v":""},{"$f":"IF(AN20=\"3 1/2 Worst Holes\",MAX(V20:AM20)+LARGE(V20:AM20,2)+LARGE(V20:AM20,3)+LARGE(V20:AM20,4)/2,IF(AN20=\"4 Worst Holes\",MAX(V20:AM20)+LARGE(V20:AM20,2)+LARGE(V20:AM20,3)+LARGE(V20:AM20,4),IF(AN20=\"4 1/2 Worst Holes\",MAX(V20:AM20)+LARGE(V20:AM20,2)+LARGE(V20:AM20,3)+LARGE(V20:AM20,4)+LARGE(V20:AM20,5)/2,IF(AN20=\"5 Worst Holes\",MAX(V20:AM20)+LARGE(V20:AM20,2)+LARGE(V20:AM20,3)+LARGE(V20:AM20,4)+LARGE(V20:AM20,5),IF(AN20=\"5 1/2 Worst Holes\",MAX(V20:AM20)+LARGE(V20:AM20,2)+LARGE(V20:AM20,3)+LARGE(V20:AM20,4)+LARGE(V20:AM20,5)+LARGE(V20:AM20,5)/2,IF(AN20=\"6 Worst Holes\",MAX(V20:AM20)+LARGE(V20:AM20,2)+LARGE(V20:AM20,3)+LARGE(V20:AM20,4)+LARGE(V20:AM20,5)+LARGE(V20:AM20,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U20,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO20),ROUND(AO20+AQ20,0),ROUND(AP20+AQ20,0))),0,IF(ISNUMBER(AO20),ROUND(AO20+AQ20,0),ROUND(AP20+AQ20,0)))","v":0},{"$f":"IF(ISERROR(AQ20),\"\",U20-AR20)","v":""}]
["Player 16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U21>130,\"6 Worst Holes\",VLOOKUP(U21,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN21=\"Scratch\",\"0\",IF(AN21=\"1/2 of Worst Hole\",MAX(V21:AJ21)/2,IF(AN21=\"Worst Hole\",MAX(V21:AJ21),IF(AN21=\"1 1/2 Worst Holes\",MAX(V21:AJ21)+LARGE(V21:AJ21,2)/2,IF(AN21=\"2 Worst Holes\",MAX(V21:AJ21)+LARGE(V21:AJ21,2),IF(AN21=\"2 1/2 Worst Holes\",MAX(V21:AJ21)+LARGE(V21:AJ21,2)+LARGE(V21:AJ21,3)/2,IF(AN21=\"3 Worst Holes\",MAX(V21:AJ21)+LARGE(V21:AJ21,2)+LARGE(V21:AJ21,3),\"\")))))))","v":""},{"$f":"IF(AN21=\"3 1/2 Worst Holes\",MAX(V21:AM21)+LARGE(V21:AM21,2)+LARGE(V21:AM21,3)+LARGE(V21:AM21,4)/2,IF(AN21=\"4 Worst Holes\",MAX(V21:AM21)+LARGE(V21:AM21,2)+LARGE(V21:AM21,3)+LARGE(V21:AM21,4),IF(AN21=\"4 1/2 Worst Holes\",MAX(V21:AM21)+LARGE(V21:AM21,2)+LARGE(V21:AM21,3)+LARGE(V21:AM21,4)+LARGE(V21:AM21,5)/2,IF(AN21=\"5 Worst Holes\",MAX(V21:AM21)+LARGE(V21:AM21,2)+LARGE(V21:AM21,3)+LARGE(V21:AM21,4)+LARGE(V21:AM21,5),IF(AN21=\"5 1/2 Worst Holes\",MAX(V21:AM21)+LARGE(V21:AM21,2)+LARGE(V21:AM21,3)+LARGE(V21:AM21,4)+LARGE(V21:AM21,5)+LARGE(V21:AM21,5)/2,IF(AN21=\"6 Worst Holes\",MAX(V21:AM21)+LARGE(V21:AM21,2)+LARGE(V21:AM21,3)+LARGE(V21:AM21,4)+LARGE(V21:AM21,5)+LARGE(V21:AM21,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U21,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO21),ROUND(AO21+AQ21,0),ROUND(AP21+AQ21,0))),0,IF(ISNUMBER(AO21),ROUND(AO21+AQ21,0),ROUND(AP21+AQ21,0)))","v":0},{"$f":"IF(ISERROR(AQ21),\"\",U21-AR21)","v":""}]
["Player 17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U22>130,\"6 Worst Holes\",VLOOKUP(U22,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN22=\"Scratch\",\"0\",IF(AN22=\"1/2 of Worst Hole\",MAX(V22:AJ22)/2,IF(AN22=\"Worst Hole\",MAX(V22:AJ22),IF(AN22=\"1 1/2 Worst Holes\",MAX(V22:AJ22)+LARGE(V22:AJ22,2)/2,IF(AN22=\"2 Worst Holes\",MAX(V22:AJ22)+LARGE(V22:AJ22,2),IF(AN22=\"2 1/2 Worst Holes\",MAX(V22:AJ22)+LARGE(V22:AJ22,2)+LARGE(V22:AJ22,3)/2,IF(AN22=\"3 Worst Holes\",MAX(V22:AJ22)+LARGE(V22:AJ22,2)+LARGE(V22:AJ22,3),\"\")))))))","v":""},{"$f":"IF(AN22=\"3 1/2 Worst Holes\",MAX(V22:AM22)+LARGE(V22:AM22,2)+LARGE(V22:AM22,3)+LARGE(V22:AM22,4)/2,IF(AN22=\"4 Worst Holes\",MAX(V22:AM22)+LARGE(V22:AM22,2)+LARGE(V22:AM22,3)+LARGE(V22:AM22,4),IF(AN22=\"4 1/2 Worst Holes\",MAX(V22:AM22)+LARGE(V22:AM22,2)+LARGE(V22:AM22,3)+LARGE(V22:AM22,4)+LARGE(V22:AM22,5)/2,IF(AN22=\"5 Worst Holes\",MAX(V22:AM22)+LARGE(V22:AM22,2)+LARGE(V22:AM22,3)+LARGE(V22:AM22,4)+LARGE(V22:AM22,5),IF(AN22=\"5 1/2 Worst Holes\",MAX(V22:AM22)+LARGE(V22:AM22,2)+LARGE(V22:AM22,3)+LARGE(V22:AM22,4)+LARGE(V22:AM22,5)+LARGE(V22:AM22,5)/2,IF(AN22=\"6 Worst Holes\",MAX(V22:AM22)+LARGE(V22:AM22,2)+LARGE(V22:AM22,3)+LARGE(V22:AM22,4)+LARGE(V22:AM22,5)+LARGE(V22:AM22,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U22,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO22),ROUND(AO22+AQ22,0),ROUND(AP22+AQ22,0))),0,IF(ISNUMBER(AO22),ROUND(AO22+AQ22,0),ROUND(AP22+AQ22,0)))","v":0},{"$f":"IF(ISERROR(AQ22),\"\",U22-AR22)","v":""}]
["Player 18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U23>130,\"6 Worst Holes\",VLOOKUP(U23,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN23=\"Scratch\",\"0\",IF(AN23=\"1/2 of Worst Hole\",MAX(V23:AJ23)/2,IF(AN23=\"Worst Hole\",MAX(V23:AJ23),IF(AN23=\"1 1/2 Worst Holes\",MAX(V23:AJ23)+LARGE(V23:AJ23,2)/2,IF(AN23=\"2 Worst Holes\",MAX(V23:AJ23)+LARGE(V23:AJ23,2),IF(AN23=\"2 1/2 Worst Holes\",MAX(V23:AJ23)+LARGE(V23:AJ23,2)+LARGE(V23:AJ23,3)/2,IF(AN23=\"3 Worst Holes\",MAX(V23:AJ23)+LARGE(V23:AJ23,2)+LARGE(V23:AJ23,3),\"\")))))))","v":""},{"$f":"IF(AN23=\"3 1/2 Worst Holes\",MAX(V23:AM23)+LARGE(V23:AM23,2)+LARGE(V23:AM23,3)+LARGE(V23:AM23,4)/2,IF(AN23=\"4 Worst Holes\",MAX(V23:AM23)+LARGE(V23:AM23,2)+LARGE(V23:AM23,3)+LARGE(V23:AM23,4),IF(AN23=\"4 1/2 Worst Holes\",MAX(V23:AM23)+LARGE(V23:AM23,2)+LARGE(V23:AM23,3)+LARGE(V23:AM23,4)+LARGE(V23:AM23,5)/2,IF(AN23=\"5 Worst Holes\",MAX(V23:AM23)+LARGE(V23:AM23,2)+LARGE(V23:AM23,3)+LARGE(V23:AM23,4)+LARGE(V23:AM23,5),IF(AN23=\"5 1/2 Worst Holes\",MAX(V23:AM23)+LARGE(V23:AM23,2)+LARGE(V23:AM23,3)+LARGE(V23:AM23,4)+LARGE(V23:AM23,5)+LARGE(V23:AM23,5)/2,IF(AN23=\"6 Worst Holes\",MAX(V23:AM23)+LARGE(V23:AM23,2)+LARGE(V23:AM23,3)+LARGE(V23:AM23,4)+LARGE(V23:AM23,5)+LARGE(V23:AM23,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U23,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO23),ROUND(AO23+AQ23,0),ROUND(AP23+AQ23,0))),0,IF(ISNUMBER(AO23),ROUND(AO23+AQ23,0),ROUND(AP23+AQ23,0)))","v":0},{"$f":"IF(ISERROR(AQ23),\"\",U23-AR23)","v":""}]
["Player 19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U24>130,\"6 Worst Holes\",VLOOKUP(U24,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN24=\"Scratch\",\"0\",IF(AN24=\"1/2 of Worst Hole\",MAX(V24:AJ24)/2,IF(AN24=\"Worst Hole\",MAX(V24:AJ24),IF(AN24=\"1 1/2 Worst Holes\",MAX(V24:AJ24)+LARGE(V24:AJ24,2)/2,IF(AN24=\"2 Worst Holes\",MAX(V24:AJ24)+LARGE(V24:AJ24,2),IF(AN24=\"2 1/2 Worst Holes\",MAX(V24:AJ24)+LARGE(V24:AJ24,2)+LARGE(V24:AJ24,3)/2,IF(AN24=\"3 Worst Holes\",MAX(V24:AJ24)+LARGE(V24:AJ24,2)+LARGE(V24:AJ24,3),\"\")))))))","v":""},{"$f":"IF(AN24=\"3 1/2 Worst Holes\",MAX(V24:AM24)+LARGE(V24:AM24,2)+LARGE(V24:AM24,3)+LARGE(V24:AM24,4)/2,IF(AN24=\"4 Worst Holes\",MAX(V24:AM24)+LARGE(V24:AM24,2)+LARGE(V24:AM24,3)+LARGE(V24:AM24,4),IF(AN24=\"4 1/2 Worst Holes\",MAX(V24:AM24)+LARGE(V24:AM24,2)+LARGE(V24:AM24,3)+LARGE(V24:AM24,4)+LARGE(V24:AM24,5)/2,IF(AN24=\"5 Worst Holes\",MAX(V24:AM24)+LARGE(V24:AM24,2)+LARGE(V24:AM24,3)+LARGE(V24:AM24,4)+LARGE(V24:AM24,5),IF(AN24=\"5 1/2 Worst Holes\",MAX(V24:AM24)+LARGE(V24:AM24,2)+LARGE(V24:AM24,3)+LARGE(V24:AM24,4)+LARGE(V24:AM24,5)+LARGE(V24:AM24,5)/2,IF(AN24=\"6 Worst Holes\",MAX(V24:AM24)+LARGE(V24:AM24,2)+LARGE(V24:AM24,3)+LARGE(V24:AM24,4)+LARGE(V24:AM24,5)+LARGE(V24:AM24,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U24,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO24),ROUND(AO24+AQ24,0),ROUND(AP24+AQ24,0))),0,IF(ISNUMBER(AO24),ROUND(AO24+AQ24,0),ROUND(AP24+AQ24,0)))","v":0},{"$f":"IF(ISERROR(AQ24),\"\",U24-AR24)","v":""}]
["Player 20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U25>130,\"6 Worst Holes\",VLOOKUP(U25,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN25=\"Scratch\",\"0\",IF(AN25=\"1/2 of Worst Hole\",MAX(V25:AJ25)/2,IF(AN25=\"Worst Hole\",MAX(V25:AJ25),IF(AN25=\"1 1/2 Worst Holes\",MAX(V25:AJ25)+LARGE(V25:AJ25,2)/2,IF(AN25=\"2 Worst Holes\",MAX(V25:AJ25)+LARGE(V25:AJ25,2),IF(AN25=\"2 1/2 Worst Holes\",MAX(V25:AJ25)+LARGE(V25:AJ25,2)+LARGE(V25:AJ25,3)/2,IF(AN25=\"3 Worst Holes\",MAX(V25:AJ25)+LARGE(V25:AJ25,2)+LARGE(V25:AJ25,3),\"\")))))))","v":""},{"$f":"IF(AN25=\"3 1/2 Worst Holes\",MAX(V25:AM25)+LARGE(V25:AM25,2)+LARGE(V25:AM25,3)+LARGE(V25:AM25,4)/2,IF(AN25=\"4 Worst Holes\",MAX(V25:AM25)+LARGE(V25:AM25,2)+LARGE(V25:AM25,3)+LARGE(V25:AM25,4),IF(AN25=\"4 1/2 Worst Holes\",MAX(V25:AM25)+LARGE(V25:AM25,2)+LARGE(V25:AM25,3)+LARGE(V25:AM25,4)+LARGE(V25:AM25,5)/2,IF(AN25=\"5 Worst Holes\",MAX(V25:AM25)+LARGE(V25:AM25,2)+LARGE(V25:AM25,3)+LARGE(V25:AM25,4)+LARGE(V25:AM25,5),IF(AN25=\"5 1/2 Worst Holes\",MAX(V25:AM25)+LARGE(V25:AM25,2)+LARGE(V25:AM25,3)+LARGE(V25:AM25,4)+LARGE(V25:AM25,5)+LARGE(V25:AM25,5)/2,IF(AN25=\"6 Worst Holes\",MAX(V25:AM25)+LARGE(V25:AM25,2)+LARGE(V25:AM25,3)+LARGE(V25:AM25,4)+LARGE(V25:AM25,5)+LARGE(V25:AM25,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U25,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO25),ROUND(AO25+AQ25,0),ROUND(AP25+AQ25,0))),0,IF(ISNUMBER(AO25),ROUND(AO25+AQ25,0),ROUND(AP25+AQ25,0)))","v":0},{"$f":"IF(ISERROR(AQ25),\"\",U25-AR25)","v":""}]
["Player 21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U26>130,\"6 Worst Holes\",VLOOKUP(U26,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN26=\"Scratch\",\"0\",IF(AN26=\"1/2 of Worst Hole\",MAX(V26:AJ26)/2,IF(AN26=\"Worst Hole\",MAX(V26:AJ26),IF(AN26=\"1 1/2 Worst Holes\",MAX(V26:AJ26)+LARGE(V26:AJ26,2)/2,IF(AN26=\"2 Worst Holes\",MAX(V26:AJ26)+LARGE(V26:AJ26,2),IF(AN26=\"2 1/2 Worst Holes\",MAX(V26:AJ26)+LARGE(V26:AJ26,2)+LARGE(V26:AJ26,3)/2,IF(AN26=\"3 Worst Holes\",MAX(V26:AJ26)+LARGE(V26:AJ26,2)+LARGE(V26:AJ26,3),\"\")))))))","v":""},{"$f":"IF(AN26=\"3 1/2 Worst Holes\",MAX(V26:AM26)+LARGE(V26:AM26,2)+LARGE(V26:AM26,3)+LARGE(V26:AM26,4)/2,IF(AN26=\"4 Worst Holes\",MAX(V26:AM26)+LARGE(V26:AM26,2)+LARGE(V26:AM26,3)+LARGE(V26:AM26,4),IF(AN26=\"4 1/2 Worst Holes\",MAX(V26:AM26)+LARGE(V26:AM26,2)+LARGE(V26:AM26,3)+LARGE(V26:AM26,4)+LARGE(V26:AM26,5)/2,IF(AN26=\"5 Worst Holes\",MAX(V26:AM26)+LARGE(V26:AM26,2)+LARGE(V26:AM26,3)+LARGE(V26:AM26,4)+LARGE(V26:AM26,5),IF(AN26=\"5 1/2 Worst Holes\",MAX(V26:AM26)+LARGE(V26:AM26,2)+LARGE(V26:AM26,3)+LARGE(V26:AM26,4)+LARGE(V26:AM26,5)+LARGE(V26:AM26,5)/2,IF(AN26=\"6 Worst Holes\",MAX(V26:AM26)+LARGE(V26:AM26,2)+LARGE(V26:AM26,3)+LARGE(V26:AM26,4)+LARGE(V26:AM26,5)+LARGE(V26:AM26,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U26,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO26),ROUND(AO26+AQ26,0),ROUND(AP26+AQ26,0))),0,IF(ISNUMBER(AO26),ROUND(AO26+AQ26,0),ROUND(AP26+AQ26,0)))","v":0},{"$f":"IF(ISERROR(AQ26),\"\",U26-AR26)","v":""}]
["Player 22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U27>130,\"6 Worst Holes\",VLOOKUP(U27,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN27=\"Scratch\",\"0\",IF(AN27=\"1/2 of Worst Hole\",MAX(V27:AJ27)/2,IF(AN27=\"Worst Hole\",MAX(V27:AJ27),IF(AN27=\"1 1/2 Worst Holes\",MAX(V27:AJ27)+LARGE(V27:AJ27,2)/2,IF(AN27=\"2 Worst Holes\",MAX(V27:AJ27)+LARGE(V27:AJ27,2),IF(AN27=\"2 1/2 Worst Holes\",MAX(V27:AJ27)+LARGE(V27:AJ27,2)+LARGE(V27:AJ27,3)/2,IF(AN27=\"3 Worst Holes\",MAX(V27:AJ27)+LARGE(V27:AJ27,2)+LARGE(V27:AJ27,3),\"\")))))))","v":""},{"$f":"IF(AN27=\"3 1/2 Worst Holes\",MAX(V27:AM27)+LARGE(V27:AM27,2)+LARGE(V27:AM27,3)+LARGE(V27:AM27,4)/2,IF(AN27=\"4 Worst Holes\",MAX(V27:AM27)+LARGE(V27:AM27,2)+LARGE(V27:AM27,3)+LARGE(V27:AM27,4),IF(AN27=\"4 1/2 Worst Holes\",MAX(V27:AM27)+LARGE(V27:AM27,2)+LARGE(V27:AM27,3)+LARGE(V27:AM27,4)+LARGE(V27:AM27,5)/2,IF(AN27=\"5 Worst Holes\",MAX(V27:AM27)+LARGE(V27:AM27,2)+LARGE(V27:AM27,3)+LARGE(V27:AM27,4)+LARGE(V27:AM27,5),IF(AN27=\"5 1/2 Worst Holes\",MAX(V27:AM27)+LARGE(V27:AM27,2)+LARGE(V27:AM27,3)+LARGE(V27:AM27,4)+LARGE(V27:AM27,5)+LARGE(V27:AM27,5)/2,IF(AN27=\"6 Worst Holes\",MAX(V27:AM27)+LARGE(V27:AM27,2)+LARGE(V27:AM27,3)+LARGE(V27:AM27,4)+LARGE(V27:AM27,5)+LARGE(V27:AM27,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U27,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO27),ROUND(AO27+AQ27,0),ROUND(AP27+AQ27,0))),0,IF(ISNUMBER(AO27),ROUND(AO27+AQ27,0),ROUND(AP27+AQ27,0)))","v":0},{"$f":"IF(ISERROR(AQ27),\"\",U27-AR27)","v":""}]
["Player 23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U28>130,\"6 Worst Holes\",VLOOKUP(U28,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN28=\"Scratch\",\"0\",IF(AN28=\"1/2 of Worst Hole\",MAX(V28:AJ28)/2,IF(AN28=\"Worst Hole\",MAX(V28:AJ28),IF(AN28=\"1 1/2 Worst Holes\",MAX(V28:AJ28)+LARGE(V28:AJ28,2)/2,IF(AN28=\"2 Worst Holes\",MAX(V28:AJ28)+LARGE(V28:AJ28,2),IF(AN28=\"2 1/2 Worst Holes\",MAX(V28:AJ28)+LARGE(V28:AJ28,2)+LARGE(V28:AJ28,3)/2,IF(AN28=\"3 Worst Holes\",MAX(V28:AJ28)+LARGE(V28:AJ28,2)+LARGE(V28:AJ28,3),\"\")))))))","v":""},{"$f":"IF(AN28=\"3 1/2 Worst Holes\",MAX(V28:AM28)+LARGE(V28:AM28,2)+LARGE(V28:AM28,3)+LARGE(V28:AM28,4)/2,IF(AN28=\"4 Worst Holes\",MAX(V28:AM28)+LARGE(V28:AM28,2)+LARGE(V28:AM28,3)+LARGE(V28:AM28,4),IF(AN28=\"4 1/2 Worst Holes\",MAX(V28:AM28)+LARGE(V28:AM28,2)+LARGE(V28:AM28,3)+LARGE(V28:AM28,4)+LARGE(V28:AM28,5)/2,IF(AN28=\"5 Worst Holes\",MAX(V28:AM28)+LARGE(V28:AM28,2)+LARGE(V28:AM28,3)+LARGE(V28:AM28,4)+LARGE(V28:AM28,5),IF(AN28=\"5 1/2 Worst Holes\",MAX(V28:AM28)+LARGE(V28:AM28,2)+LARGE(V28:AM28,3)+LARGE(V28:AM28,4)+LARGE(V28:AM28,5)+LARGE(V28:AM28,5)/2,IF(AN28=\"6 Worst Holes\",MAX(V28:AM28)+LARGE(V28:AM28,2)+LARGE(V28:AM28,3)+LARGE(V28:AM28,4)+LARGE(V28:AM28,5)+LARGE(V28:AM28,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U28,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO28),ROUND(AO28+AQ28,0),ROUND(AP28+AQ28,0))),0,IF(ISNUMBER(AO28),ROUND(AO28+AQ28,0),ROUND(AP28+AQ28,0)))","v":0},{"$f":"IF(ISERROR(AQ28),\"\",U28-AR28)","v":""}]
["Player 24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U29>130,\"6 Worst Holes\",VLOOKUP(U29,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN29=\"Scratch\",\"0\",IF(AN29=\"1/2 of Worst Hole\",MAX(V29:AJ29)/2,IF(AN29=\"Worst Hole\",MAX(V29:AJ29),IF(AN29=\"1 1/2 Worst Holes\",MAX(V29:AJ29)+LARGE(V29:AJ29,2)/2,IF(AN29=\"2 Worst Holes\",MAX(V29:AJ29)+LARGE(V29:AJ29,2),IF(AN29=\"2 1/2 Worst Holes\",MAX(V29:AJ29)+LARGE(V29:AJ29,2)+LARGE(V29:AJ29,3)/2,IF(AN29=\"3 Worst Holes\",MAX(V29:AJ29)+LARGE(V29:AJ29,2)+LARGE(V29:AJ29,3),\"\")))))))","v":""},{"$f":"IF(AN29=\"3 1/2 Worst Holes\",MAX(V29:AM29)+LARGE(V29:AM29,2)+LARGE(V29:AM29,3)+LARGE(V29:AM29,4)/2,IF(AN29=\"4 Worst Holes\",MAX(V29:AM29)+LARGE(V29:AM29,2)+LARGE(V29:AM29,3)+LARGE(V29:AM29,4),IF(AN29=\"4 1/2 Worst Holes\",MAX(V29:AM29)+LARGE(V29:AM29,2)+LARGE(V29:AM29,3)+LARGE(V29:AM29,4)+LARGE(V29:AM29,5)/2,IF(AN29=\"5 Worst Holes\",MAX(V29:AM29)+LARGE(V29:AM29,2)+LARGE(V29:AM29,3)+LARGE(V29:AM29,4)+LARGE(V29:AM29,5),IF(AN29=\"5 1/2 Worst Holes\",MAX(V29:AM29)+LARGE(V29:AM29,2)+LARGE(V29:AM29,3)+LARGE(V29:AM29,4)+LARGE(V29:AM29,5)+LARGE(V29:AM29,5)/2,IF(AN29=\"6 Worst Holes\",MAX(V29:AM29)+LARGE(V29:AM29,2)+LARGE(V29:AM29,3)+LARGE(V29:AM29,4)+LARGE(V29:AM29,5)+LARGE(V29:AM29,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U29,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO29),ROUND(AO29+AQ29,0),ROUND(AP29+AQ29,0))),0,IF(ISNUMBER(AO29),ROUND(AO29+AQ29,0),ROUND(AP29+AQ29,0)))","v":0},{"$f":"IF(ISERROR(AQ29),\"\",U29-AR29)","v":""}]
["Player 25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U30>130,\"6 Worst Holes\",VLOOKUP(U30,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN30=\"Scratch\",\"0\",IF(AN30=\"1/2 of Worst Hole\",MAX(V30:AJ30)/2,IF(AN30=\"Worst Hole\",MAX(V30:AJ30),IF(AN30=\"1 1/2 Worst Holes\",MAX(V30:AJ30)+LARGE(V30:AJ30,2)/2,IF(AN30=\"2 Worst Holes\",MAX(V30:AJ30)+LARGE(V30:AJ30,2),IF(AN30=\"2 1/2 Worst Holes\",MAX(V30:AJ30)+LARGE(V30:AJ30,2)+LARGE(V30:AJ30,3)/2,IF(AN30=\"3 Worst Holes\",MAX(V30:AJ30)+LARGE(V30:AJ30,2)+LARGE(V30:AJ30,3),\"\")))))))","v":""},{"$f":"IF(AN30=\"3 1/2 Worst Holes\",MAX(V30:AM30)+LARGE(V30:AM30,2)+LARGE(V30:AM30,3)+LARGE(V30:AM30,4)/2,IF(AN30=\"4 Worst Holes\",MAX(V30:AM30)+LARGE(V30:AM30,2)+LARGE(V30:AM30,3)+LARGE(V30:AM30,4),IF(AN30=\"4 1/2 Worst Holes\",MAX(V30:AM30)+LARGE(V30:AM30,2)+LARGE(V30:AM30,3)+LARGE(V30:AM30,4)+LARGE(V30:AM30,5)/2,IF(AN30=\"5 Worst Holes\",MAX(V30:AM30)+LARGE(V30:AM30,2)+LARGE(V30:AM30,3)+LARGE(V30:AM30,4)+LARGE(V30:AM30,5),IF(AN30=\"5 1/2 Worst Holes\",MAX(V30:AM30)+LARGE(V30:AM30,2)+LARGE(V30:AM30,3)+LARGE(V30:AM30,4)+LARGE(V30:AM30,5)+LARGE(V30:AM30,5)/2,IF(AN30=\"6 Worst Holes\",MAX(V30:AM30)+LARGE(V30:AM30,2)+LARGE(V30:AM30,3)+LARGE(V30:AM30,4)+LARGE(V30:AM30,5)+LARGE(V30:AM30,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U30,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO30),ROUND(AO30+AQ30,0),ROUND(AP30+AQ30,0))),0,IF(ISNUMBER(AO30),ROUND(AO30+AQ30,0),ROUND(AP30+AQ30,0)))","v":0},{"$f":"IF(ISERROR(AQ30),\"\",U30-AR30)","v":""}]
["Player 26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U31>130,\"6 Worst Holes\",VLOOKUP(U31,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN31=\"Scratch\",\"0\",IF(AN31=\"1/2 of Worst Hole\",MAX(V31:AJ31)/2,IF(AN31=\"Worst Hole\",MAX(V31:AJ31),IF(AN31=\"1 1/2 Worst Holes\",MAX(V31:AJ31)+LARGE(V31:AJ31,2)/2,IF(AN31=\"2 Worst Holes\",MAX(V31:AJ31)+LARGE(V31:AJ31,2),IF(AN31=\"2 1/2 Worst Holes\",MAX(V31:AJ31)+LARGE(V31:AJ31,2)+LARGE(V31:AJ31,3)/2,IF(AN31=\"3 Worst Holes\",MAX(V31:AJ31)+LARGE(V31:AJ31,2)+LARGE(V31:AJ31,3),\"\")))))))","v":""},{"$f":"IF(AN31=\"3 1/2 Worst Holes\",MAX(V31:AM31)+LARGE(V31:AM31,2)+LARGE(V31:AM31,3)+LARGE(V31:AM31,4)/2,IF(AN31=\"4 Worst Holes\",MAX(V31:AM31)+LARGE(V31:AM31,2)+LARGE(V31:AM31,3)+LARGE(V31:AM31,4),IF(AN31=\"4 1/2 Worst Holes\",MAX(V31:AM31)+LARGE(V31:AM31,2)+LARGE(V31:AM31,3)+LARGE(V31:AM31,4)+LARGE(V31:AM31,5)/2,IF(AN31=\"5 Worst Holes\",MAX(V31:AM31)+LARGE(V31:AM31,2)+LARGE(V31:AM31,3)+LARGE(V31:AM31,4)+LARGE(V31:AM31,5),IF(AN31=\"5 1/2 Worst Holes\",MAX(V31:AM31)+LARGE(V31:AM31,2)+LARGE(V31:AM31,3)+LARGE(V31:AM31,4)+LARGE(V31:AM31,5)+LARGE(V31:AM31,5)/2,IF(AN31=\"6 Worst Holes\",MAX(V31:AM31)+LARGE(V31:AM31,2)+LARGE(V31:AM31,3)+LARGE(V31:AM31,4)+LARGE(V31:AM31,5)+LARGE(V31:AM31,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U31,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO31),ROUND(AO31+AQ31,0),ROUND(AP31+AQ31,0))),0,IF(ISNUMBER(AO31),ROUND(AO31+AQ31,0),ROUND(AP31+AQ31,0)))","v":0},{"$f":"IF(ISERROR(AQ31),\"\",U31-AR31)","v":""}]
["Player 27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U32>130,\"6 Worst Holes\",VLOOKUP(U32,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN32=\"Scratch\",\"0\",IF(AN32=\"1/2 of Worst Hole\",MAX(V32:AJ32)/2,IF(AN32=\"Worst Hole\",MAX(V32:AJ32),IF(AN32=\"1 1/2 Worst Holes\",MAX(V32:AJ32)+LARGE(V32:AJ32,2)/2,IF(AN32=\"2 Worst Holes\",MAX(V32:AJ32)+LARGE(V32:AJ32,2),IF(AN32=\"2 1/2 Worst Holes\",MAX(V32:AJ32)+LARGE(V32:AJ32,2)+LARGE(V32:AJ32,3)/2,IF(AN32=\"3 Worst Holes\",MAX(V32:AJ32)+LARGE(V32:AJ32,2)+LARGE(V32:AJ32,3),\"\")))))))","v":""},{"$f":"IF(AN32=\"3 1/2 Worst Holes\",MAX(V32:AM32)+LARGE(V32:AM32,2)+LARGE(V32:AM32,3)+LARGE(V32:AM32,4)/2,IF(AN32=\"4 Worst Holes\",MAX(V32:AM32)+LARGE(V32:AM32,2)+LARGE(V32:AM32,3)+LARGE(V32:AM32,4),IF(AN32=\"4 1/2 Worst Holes\",MAX(V32:AM32)+LARGE(V32:AM32,2)+LARGE(V32:AM32,3)+LARGE(V32:AM32,4)+LARGE(V32:AM32,5)/2,IF(AN32=\"5 Worst Holes\",MAX(V32:AM32)+LARGE(V32:AM32,2)+LARGE(V32:AM32,3)+LARGE(V32:AM32,4)+LARGE(V32:AM32,5),IF(AN32=\"5 1/2 Worst Holes\",MAX(V32:AM32)+LARGE(V32:AM32,2)+LARGE(V32:AM32,3)+LARGE(V32:AM32,4)+LARGE(V32:AM32,5)+LARGE(V32:AM32,5)/2,IF(AN32=\"6 Worst Holes\",MAX(V32:AM32)+LARGE(V32:AM32,2)+LARGE(V32:AM32,3)+LARGE(V32:AM32,4)+LARGE(V32:AM32,5)+LARGE(V32:AM32,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U32,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO32),ROUND(AO32+AQ32,0),ROUND(AP32+AQ32,0))),0,IF(ISNUMBER(AO32),ROUND(AO32+AQ32,0),ROUND(AP32+AQ32,0)))","v":0},{"$f":"IF(ISERROR(AQ32),\"\",U32-AR32)","v":""}]
["Player 28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U33>130,\"6 Worst Holes\",VLOOKUP(U33,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN33=\"Scratch\",\"0\",IF(AN33=\"1/2 of Worst Hole\",MAX(V33:AJ33)/2,IF(AN33=\"Worst Hole\",MAX(V33:AJ33),IF(AN33=\"1 1/2 Worst Holes\",MAX(V33:AJ33)+LARGE(V33:AJ33,2)/2,IF(AN33=\"2 Worst Holes\",MAX(V33:AJ33)+LARGE(V33:AJ33,2),IF(AN33=\"2 1/2 Worst Holes\",MAX(V33:AJ33)+LARGE(V33:AJ33,2)+LARGE(V33:AJ33,3)/2,IF(AN33=\"3 Worst Holes\",MAX(V33:AJ33)+LARGE(V33:AJ33,2)+LARGE(V33:AJ33,3),\"\")))))))","v":""},{"$f":"IF(AN33=\"3 1/2 Worst Holes\",MAX(V33:AM33)+LARGE(V33:AM33,2)+LARGE(V33:AM33,3)+LARGE(V33:AM33,4)/2,IF(AN33=\"4 Worst Holes\",MAX(V33:AM33)+LARGE(V33:AM33,2)+LARGE(V33:AM33,3)+LARGE(V33:AM33,4),IF(AN33=\"4 1/2 Worst Holes\",MAX(V33:AM33)+LARGE(V33:AM33,2)+LARGE(V33:AM33,3)+LARGE(V33:AM33,4)+LARGE(V33:AM33,5)/2,IF(AN33=\"5 Worst Holes\",MAX(V33:AM33)+LARGE(V33:AM33,2)+LARGE(V33:AM33,3)+LARGE(V33:AM33,4)+LARGE(V33:AM33,5),IF(AN33=\"5 1/2 Worst Holes\",MAX(V33:AM33)+LARGE(V33:AM33,2)+LARGE(V33:AM33,3)+LARGE(V33:AM33,4)+LARGE(V33:AM33,5)+LARGE(V33:AM33,5)/2,IF(AN33=\"6 Worst Holes\",MAX(V33:AM33)+LARGE(V33:AM33,2)+LARGE(V33:AM33,3)+LARGE(V33:AM33,4)+LARGE(V33:AM33,5)+LARGE(V33:AM33,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U33,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO33),ROUND(AO33+AQ33,0),ROUND(AP33+AQ33,0))),0,IF(ISNUMBER(AO33),ROUND(AO33+AQ33,0),ROUND(AP33+AQ33,0)))","v":0},{"$f":"IF(ISERROR(AQ33),\"\",U33-AR33)","v":""}]
["Player 29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U34>130,\"6 Worst Holes\",VLOOKUP(U34,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN34=\"Scratch\",\"0\",IF(AN34=\"1/2 of Worst Hole\",MAX(V34:AJ34)/2,IF(AN34=\"Worst Hole\",MAX(V34:AJ34),IF(AN34=\"1 1/2 Worst Holes\",MAX(V34:AJ34)+LARGE(V34:AJ34,2)/2,IF(AN34=\"2 Worst Holes\",MAX(V34:AJ34)+LARGE(V34:AJ34,2),IF(AN34=\"2 1/2 Worst Holes\",MAX(V34:AJ34)+LARGE(V34:AJ34,2)+LARGE(V34:AJ34,3)/2,IF(AN34=\"3 Worst Holes\",MAX(V34:AJ34)+LARGE(V34:AJ34,2)+LARGE(V34:AJ34,3),\"\")))))))","v":""},{"$f":"IF(AN34=\"3 1/2 Worst Holes\",MAX(V34:AM34)+LARGE(V34:AM34,2)+LARGE(V34:AM34,3)+LARGE(V34:AM34,4)/2,IF(AN34=\"4 Worst Holes\",MAX(V34:AM34)+LARGE(V34:AM34,2)+LARGE(V34:AM34,3)+LARGE(V34:AM34,4),IF(AN34=\"4 1/2 Worst Holes\",MAX(V34:AM34)+LARGE(V34:AM34,2)+LARGE(V34:AM34,3)+LARGE(V34:AM34,4)+LARGE(V34:AM34,5)/2,IF(AN34=\"5 Worst Holes\",MAX(V34:AM34)+LARGE(V34:AM34,2)+LARGE(V34:AM34,3)+LARGE(V34:AM34,4)+LARGE(V34:AM34,5),IF(AN34=\"5 1/2 Worst Holes\",MAX(V34:AM34)+LARGE(V34:AM34,2)+LARGE(V34:AM34,3)+LARGE(V34:AM34,4)+LARGE(V34:AM34,5)+LARGE(V34:AM34,5)/2,IF(AN34=\"6 Worst Holes\",MAX(V34:AM34)+LARGE(V34:AM34,2)+LARGE(V34:AM34,3)+LARGE(V34:AM34,4)+LARGE(V34:AM34,5)+LARGE(V34:AM34,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U34,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO34),ROUND(AO34+AQ34,0),ROUND(AP34+AQ34,0))),0,IF(ISNUMBER(AO34),ROUND(AO34+AQ34,0),ROUND(AP34+AQ34,0)))","v":0},{"$f":"IF(ISERROR(AQ34),\"\",U34-AR34)","v":""}]
["Player 30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U35>130,\"6 Worst Holes\",VLOOKUP(U35,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN35=\"Scratch\",\"0\",IF(AN35=\"1/2 of Worst Hole\",MAX(V35:AJ35)/2,IF(AN35=\"Worst Hole\",MAX(V35:AJ35),IF(AN35=\"1 1/2 Worst Holes\",MAX(V35:AJ35)+LARGE(V35:AJ35,2)/2,IF(AN35=\"2 Worst Holes\",MAX(V35:AJ35)+LARGE(V35:AJ35,2),IF(AN35=\"2 1/2 Worst Holes\",MAX(V35:AJ35)+LARGE(V35:AJ35,2)+LARGE(V35:AJ35,3)/2,IF(AN35=\"3 Worst Holes\",MAX(V35:AJ35)+LARGE(V35:AJ35,2)+LARGE(V35:AJ35,3),\"\")))))))","v":""},{"$f":"IF(AN35=\"3 1/2 Worst Holes\",MAX(V35:AM35)+LARGE(V35:AM35,2)+LARGE(V35:AM35,3)+LARGE(V35:AM35,4)/2,IF(AN35=\"4 Worst Holes\",MAX(V35:AM35)+LARGE(V35:AM35,2)+LARGE(V35:AM35,3)+LARGE(V35:AM35,4),IF(AN35=\"4 1/2 Worst Holes\",MAX(V35:AM35)+LARGE(V35:AM35,2)+LARGE(V35:AM35,3)+LARGE(V35:AM35,4)+LARGE(V35:AM35,5)/2,IF(AN35=\"5 Worst Holes\",MAX(V35:AM35)+LARGE(V35:AM35,2)+LARGE(V35:AM35,3)+LARGE(V35:AM35,4)+LARGE(V35:AM35,5),IF(AN35=\"5 1/2 Worst Holes\",MAX(V35:AM35)+LARGE(V35:AM35,2)+LARGE(V35:AM35,3)+LARGE(V35:AM35,4)+LARGE(V35:AM35,5)+LARGE(V35:AM35,5)/2,IF(AN35=\"6 Worst Holes\",MAX(V35:AM35)+LARGE(V35:AM35,2)+LARGE(V35:AM35,3)+LARGE(V35:AM35,4)+LARGE(V35:AM35,5)+LARGE(V35:AM35,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U35,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO35),ROUND(AO35+AQ35,0),ROUND(AP35+AQ35,0))),0,IF(ISNUMBER(AO35),ROUND(AO35+AQ35,0),ROUND(AP35+AQ35,0)))","v":0},{"$f":"IF(ISERROR(AQ35),\"\",U35-AR35)","v":""}]
["Player 31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U36>130,\"6 Worst Holes\",VLOOKUP(U36,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN36=\"Scratch\",\"0\",IF(AN36=\"1/2 of Worst Hole\",MAX(V36:AJ36)/2,IF(AN36=\"Worst Hole\",MAX(V36:AJ36),IF(AN36=\"1 1/2 Worst Holes\",MAX(V36:AJ36)+LARGE(V36:AJ36,2)/2,IF(AN36=\"2 Worst Holes\",MAX(V36:AJ36)+LARGE(V36:AJ36,2),IF(AN36=\"2 1/2 Worst Holes\",MAX(V36:AJ36)+LARGE(V36:AJ36,2)+LARGE(V36:AJ36,3)/2,IF(AN36=\"3 Worst Holes\",MAX(V36:AJ36)+LARGE(V36:AJ36,2)+LARGE(V36:AJ36,3),\"\")))))))","v":""},{"$f":"IF(AN36=\"3 1/2 Worst Holes\",MAX(V36:AM36)+LARGE(V36:AM36,2)+LARGE(V36:AM36,3)+LARGE(V36:AM36,4)/2,IF(AN36=\"4 Worst Holes\",MAX(V36:AM36)+LARGE(V36:AM36,2)+LARGE(V36:AM36,3)+LARGE(V36:AM36,4),IF(AN36=\"4 1/2 Worst Holes\",MAX(V36:AM36)+LARGE(V36:AM36,2)+LARGE(V36:AM36,3)+LARGE(V36:AM36,4)+LARGE(V36:AM36,5)/2,IF(AN36=\"5 Worst Holes\",MAX(V36:AM36)+LARGE(V36:AM36,2)+LARGE(V36:AM36,3)+LARGE(V36:AM36,4)+LARGE(V36:AM36,5),IF(AN36=\"5 1/2 Worst Holes\",MAX(V36:AM36)+LARGE(V36:AM36,2)+LARGE(V36:AM36,3)+LARGE(V36:AM36,4)+LARGE(V36:AM36,5)+LARGE(V36:AM36,5)/2,IF(AN36=\"6 Worst Holes\",MAX(V36:AM36)+LARGE(V36:AM36,2)+LARGE(V36:AM36,3)+LARGE(V36:AM36,4)+LARGE(V36:AM36,5)+LARGE(V36:AM36,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U36,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO36),ROUND(AO36+AQ36,0),ROUND(AP36+AQ36,0))),0,IF(ISNUMBER(AO36),ROUND(AO36+AQ36,0),ROUND(AP36+AQ36,0)))","v":0},{"$f":"IF(ISERROR(AQ36),\"\",U36-AR36)","v":""}]
["Player 32",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U37>130,\"6 Worst Holes\",VLOOKUP(U37,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN37=\"Scratch\",\"0\",IF(AN37=\"1/2 of Worst Hole\",MAX(V37:AJ37)/2,IF(AN37=\"Worst Hole\",MAX(V37:AJ37),IF(AN37=\"1 1/2 Worst Holes\",MAX(V37:AJ37)+LARGE(V37:AJ37,2)/2,IF(AN37=\"2 Worst Holes\",MAX(V37:AJ37)+LARGE(V37:AJ37,2),IF(AN37=\"2 1/2 Worst Holes\",MAX(V37:AJ37)+LARGE(V37:AJ37,2)+LARGE(V37:AJ37,3)/2,IF(AN37=\"3 Worst Holes\",MAX(V37:AJ37)+LARGE(V37:AJ37,2)+LARGE(V37:AJ37,3),\"\")))))))","v":""},{"$f":"IF(AN37=\"3 1/2 Worst Holes\",MAX(V37:AM37)+LARGE(V37:AM37,2)+LARGE(V37:AM37,3)+LARGE(V37:AM37,4)/2,IF(AN37=\"4 Worst Holes\",MAX(V37:AM37)+LARGE(V37:AM37,2)+LARGE(V37:AM37,3)+LARGE(V37:AM37,4),IF(AN37=\"4 1/2 Worst Holes\",MAX(V37:AM37)+LARGE(V37:AM37,2)+LARGE(V37:AM37,3)+LARGE(V37:AM37,4)+LARGE(V37:AM37,5)/2,IF(AN37=\"5 Worst Holes\",MAX(V37:AM37)+LARGE(V37:AM37,2)+LARGE(V37:AM37,3)+LARGE(V37:AM37,4)+LARGE(V37:AM37,5),IF(AN37=\"5 1/2 Worst Holes\",MAX(V37:AM37)+LARGE(V37:AM37,2)+LARGE(V37:AM37,3)+LARGE(V37:AM37,4)+LARGE(V37:AM37,5)+LARGE(V37:AM37,5)/2,IF(AN37=\"6 Worst Holes\",MAX(V37:AM37)+LARGE(V37:AM37,2)+LARGE(V37:AM37,3)+LARGE(V37:AM37,4)+LARGE(V37:AM37,5)+LARGE(V37:AM37,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U37,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO37),ROUND(AO37+AQ37,0),ROUND(AP37+AQ37,0))),0,IF(ISNUMBER(AO37),ROUND(AO37+AQ37,0),ROUND(AP37+AQ37,0)))","v":0},{"$f":"IF(ISERROR(AQ37),\"\",U37-AR37)","v":""}]
["Player 33",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U38>130,\"6 Worst Holes\",VLOOKUP(U38,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN38=\"Scratch\",\"0\",IF(AN38=\"1/2 of Worst Hole\",MAX(V38:AJ38)/2,IF(AN38=\"Worst Hole\",MAX(V38:AJ38),IF(AN38=\"1 1/2 Worst Holes\",MAX(V38:AJ38)+LARGE(V38:AJ38,2)/2,IF(AN38=\"2 Worst Holes\",MAX(V38:AJ38)+LARGE(V38:AJ38,2),IF(AN38=\"2 1/2 Worst Holes\",MAX(V38:AJ38)+LARGE(V38:AJ38,2)+LARGE(V38:AJ38,3)/2,IF(AN38=\"3 Worst Holes\",MAX(V38:AJ38)+LARGE(V38:AJ38,2)+LARGE(V38:AJ38,3),\"\")))))))","v":""},{"$f":"IF(AN38=\"3 1/2 Worst Holes\",MAX(V38:AM38)+LARGE(V38:AM38,2)+LARGE(V38:AM38,3)+LARGE(V38:AM38,4)/2,IF(AN38=\"4 Worst Holes\",MAX(V38:AM38)+LARGE(V38:AM38,2)+LARGE(V38:AM38,3)+LARGE(V38:AM38,4),IF(AN38=\"4 1/2 Worst Holes\",MAX(V38:AM38)+LARGE(V38:AM38,2)+LARGE(V38:AM38,3)+LARGE(V38:AM38,4)+LARGE(V38:AM38,5)/2,IF(AN38=\"5 Worst Holes\",MAX(V38:AM38)+LARGE(V38:AM38,2)+LARGE(V38:AM38,3)+LARGE(V38:AM38,4)+LARGE(V38:AM38,5),IF(AN38=\"5 1/2 Worst Holes\",MAX(V38:AM38)+LARGE(V38:AM38,2)+LARGE(V38:AM38,3)+LARGE(V38:AM38,4)+LARGE(V38:AM38,5)+LARGE(V38:AM38,5)/2,IF(AN38=\"6 Worst Holes\",MAX(V38:AM38)+LARGE(V38:AM38,2)+LARGE(V38:AM38,3)+LARGE(V38:AM38,4)+LARGE(V38:AM38,5)+LARGE(V38:AM38,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U38,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO38),ROUND(AO38+AQ38,0),ROUND(AP38+AQ38,0))),0,IF(ISNUMBER(AO38),ROUND(AO38+AQ38,0),ROUND(AP38+AQ38,0)))","v":0},{"$f":"IF(ISERROR(AQ38),\"\",U38-AR38)","v":""}]
["Player 34",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U39>130,\"6 Worst Holes\",VLOOKUP(U39,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN39=\"Scratch\",\"0\",IF(AN39=\"1/2 of Worst Hole\",MAX(V39:AJ39)/2,IF(AN39=\"Worst Hole\",MAX(V39:AJ39),IF(AN39=\"1 1/2 Worst Holes\",MAX(V39:AJ39)+LARGE(V39:AJ39,2)/2,IF(AN39=\"2 Worst Holes\",MAX(V39:AJ39)+LARGE(V39:AJ39,2),IF(AN39=\"2 1/2 Worst Holes\",MAX(V39:AJ39)+LARGE(V39:AJ39,2)+LARGE(V39:AJ39,3)/2,IF(AN39=\"3 Worst Holes\",MAX(V39:AJ39)+LARGE(V39:AJ39,2)+LARGE(V39:AJ39,3),\"\")))))))","v":""},{"$f":"IF(AN39=\"3 1/2 Worst Holes\",MAX(V39:AM39)+LARGE(V39:AM39,2)+LARGE(V39:AM39,3)+LARGE(V39:AM39,4)/2,IF(AN39=\"4 Worst Holes\",MAX(V39:AM39)+LARGE(V39:AM39,2)+LARGE(V39:AM39,3)+LARGE(V39:AM39,4),IF(AN39=\"4 1/2 Worst Holes\",MAX(V39:AM39)+LARGE(V39:AM39,2)+LARGE(V39:AM39,3)+LARGE(V39:AM39,4)+LARGE(V39:AM39,5)/2,IF(AN39=\"5 Worst Holes\",MAX(V39:AM39)+LARGE(V39:AM39,2)+LARGE(V39:AM39,3)+LARGE(V39:AM39,4)+LARGE(V39:AM39,5),IF(AN39=\"5 1/2 Worst Holes\",MAX(V39:AM39)+LARGE(V39:AM39,2)+LARGE(V39:AM39,3)+LARGE(V39:AM39,4)+LARGE(V39:AM39,5)+LARGE(V39:AM39,5)/2,IF(AN39=\"6 Worst Holes\",MAX(V39:AM39)+LARGE(V39:AM39,2)+LARGE(V39:AM39,3)+LARGE(V39:AM39,4)+LARGE(V39:AM39,5)+LARGE(V39:AM39,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U39,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO39),ROUND(AO39+AQ39,0),ROUND(AP39+AQ39,0))),0,IF(ISNUMBER(AO39),ROUND(AO39+AQ39,0),ROUND(AP39+AQ39,0)))","v":0},{"$f":"IF(ISERROR(AQ39),\"\",U39-AR39)","v":""}]
["Player 35",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U40>130,\"6 Worst Holes\",VLOOKUP(U40,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN40=\"Scratch\",\"0\",IF(AN40=\"1/2 of Worst Hole\",MAX(V40:AJ40)/2,IF(AN40=\"Worst Hole\",MAX(V40:AJ40),IF(AN40=\"1 1/2 Worst Holes\",MAX(V40:AJ40)+LARGE(V40:AJ40,2)/2,IF(AN40=\"2 Worst Holes\",MAX(V40:AJ40)+LARGE(V40:AJ40,2),IF(AN40=\"2 1/2 Worst Holes\",MAX(V40:AJ40)+LARGE(V40:AJ40,2)+LARGE(V40:AJ40,3)/2,IF(AN40=\"3 Worst Holes\",MAX(V40:AJ40)+LARGE(V40:AJ40,2)+LARGE(V40:AJ40,3),\"\")))))))","v":""},{"$f":"IF(AN40=\"3 1/2 Worst Holes\",MAX(V40:AM40)+LARGE(V40:AM40,2)+LARGE(V40:AM40,3)+LARGE(V40:AM40,4)/2,IF(AN40=\"4 Worst Holes\",MAX(V40:AM40)+LARGE(V40:AM40,2)+LARGE(V40:AM40,3)+LARGE(V40:AM40,4),IF(AN40=\"4 1/2 Worst Holes\",MAX(V40:AM40)+LARGE(V40:AM40,2)+LARGE(V40:AM40,3)+LARGE(V40:AM40,4)+LARGE(V40:AM40,5)/2,IF(AN40=\"5 Worst Holes\",MAX(V40:AM40)+LARGE(V40:AM40,2)+LARGE(V40:AM40,3)+LARGE(V40:AM40,4)+LARGE(V40:AM40,5),IF(AN40=\"5 1/2 Worst Holes\",MAX(V40:AM40)+LARGE(V40:AM40,2)+LARGE(V40:AM40,3)+LARGE(V40:AM40,4)+LARGE(V40:AM40,5)+LARGE(V40:AM40,5)/2,IF(AN40=\"6 Worst Holes\",MAX(V40:AM40)+LARGE(V40:AM40,2)+LARGE(V40:AM40,3)+LARGE(V40:AM40,4)+LARGE(V40:AM40,5)+LARGE(V40:AM40,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U40,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO40),ROUND(AO40+AQ40,0),ROUND(AP40+AQ40,0))),0,IF(ISNUMBER(AO40),ROUND(AO40+AQ40,0),ROUND(AP40+AQ40,0)))","v":0},{"$f":"IF(ISERROR(AQ40),\"\",U40-AR40)","v":""}]
["Player 36",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U41>130,\"6 Worst Holes\",VLOOKUP(U41,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN41=\"Scratch\",\"0\",IF(AN41=\"1/2 of Worst Hole\",MAX(V41:AJ41)/2,IF(AN41=\"Worst Hole\",MAX(V41:AJ41),IF(AN41=\"1 1/2 Worst Holes\",MAX(V41:AJ41)+LARGE(V41:AJ41,2)/2,IF(AN41=\"2 Worst Holes\",MAX(V41:AJ41)+LARGE(V41:AJ41,2),IF(AN41=\"2 1/2 Worst Holes\",MAX(V41:AJ41)+LARGE(V41:AJ41,2)+LARGE(V41:AJ41,3)/2,IF(AN41=\"3 Worst Holes\",MAX(V41:AJ41)+LARGE(V41:AJ41,2)+LARGE(V41:AJ41,3),\"\")))))))","v":""},{"$f":"IF(AN41=\"3 1/2 Worst Holes\",MAX(V41:AM41)+LARGE(V41:AM41,2)+LARGE(V41:AM41,3)+LARGE(V41:AM41,4)/2,IF(AN41=\"4 Worst Holes\",MAX(V41:AM41)+LARGE(V41:AM41,2)+LARGE(V41:AM41,3)+LARGE(V41:AM41,4),IF(AN41=\"4 1/2 Worst Holes\",MAX(V41:AM41)+LARGE(V41:AM41,2)+LARGE(V41:AM41,3)+LARGE(V41:AM41,4)+LARGE(V41:AM41,5)/2,IF(AN41=\"5 Worst Holes\",MAX(V41:AM41)+LARGE(V41:AM41,2)+LARGE(V41:AM41,3)+LARGE(V41:AM41,4)+LARGE(V41:AM41,5),IF(AN41=\"5 1/2 Worst Holes\",MAX(V41:AM41)+LARGE(V41:AM41,2)+LARGE(V41:AM41,3)+LARGE(V41:AM41,4)+LARGE(V41:AM41,5)+LARGE(V41:AM41,5)/2,IF(AN41=\"6 Worst Holes\",MAX(V41:AM41)+LARGE(V41:AM41,2)+LARGE(V41:AM41,3)+LARGE(V41:AM41,4)+LARGE(V41:AM41,5)+LARGE(V41:AM41,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U41,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO41),ROUND(AO41+AQ41,0),ROUND(AP41+AQ41,0))),0,IF(ISNUMBER(AO41),ROUND(AO41+AQ41,0),ROUND(AP41+AQ41,0)))","v":0},{"$f":"IF(ISERROR(AQ41),\"\",U41-AR41)","v":""}]
["Player 37",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U42>130,\"6 Worst Holes\",VLOOKUP(U42,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN42=\"Scratch\",\"0\",IF(AN42=\"1/2 of Worst Hole\",MAX(V42:AJ42)/2,IF(AN42=\"Worst Hole\",MAX(V42:AJ42),IF(AN42=\"1 1/2 Worst Holes\",MAX(V42:AJ42)+LARGE(V42:AJ42,2)/2,IF(AN42=\"2 Worst Holes\",MAX(V42:AJ42)+LARGE(V42:AJ42,2),IF(AN42=\"2 1/2 Worst Holes\",MAX(V42:AJ42)+LARGE(V42:AJ42,2)+LARGE(V42:AJ42,3)/2,IF(AN42=\"3 Worst Holes\",MAX(V42:AJ42)+LARGE(V42:AJ42,2)+LARGE(V42:AJ42,3),\"\")))))))","v":""},{"$f":"IF(AN42=\"3 1/2 Worst Holes\",MAX(V42:AM42)+LARGE(V42:AM42,2)+LARGE(V42:AM42,3)+LARGE(V42:AM42,4)/2,IF(AN42=\"4 Worst Holes\",MAX(V42:AM42)+LARGE(V42:AM42,2)+LARGE(V42:AM42,3)+LARGE(V42:AM42,4),IF(AN42=\"4 1/2 Worst Holes\",MAX(V42:AM42)+LARGE(V42:AM42,2)+LARGE(V42:AM42,3)+LARGE(V42:AM42,4)+LARGE(V42:AM42,5)/2,IF(AN42=\"5 Worst Holes\",MAX(V42:AM42)+LARGE(V42:AM42,2)+LARGE(V42:AM42,3)+LARGE(V42:AM42,4)+LARGE(V42:AM42,5),IF(AN42=\"5 1/2 Worst Holes\",MAX(V42:AM42)+LARGE(V42:AM42,2)+LARGE(V42:AM42,3)+LARGE(V42:AM42,4)+LARGE(V42:AM42,5)+LARGE(V42:AM42,5)/2,IF(AN42=\"6 Worst Holes\",MAX(V42:AM42)+LARGE(V42:AM42,2)+LARGE(V42:AM42,3)+LARGE(V42:AM42,4)+LARGE(V42:AM42,5)+LARGE(V42:AM42,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U42,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO42),ROUND(AO42+AQ42,0),ROUND(AP42+AQ42,0))),0,IF(ISNUMBER(AO42),ROUND(AO42+AQ42,0),ROUND(AP42+AQ42,0)))","v":0},{"$f":"IF(ISERROR(AQ42),\"\",U42-AR42)","v":""}]
["Player 38",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U43>130,\"6 Worst Holes\",VLOOKUP(U43,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN43=\"Scratch\",\"0\",IF(AN43=\"1/2 of Worst Hole\",MAX(V43:AJ43)/2,IF(AN43=\"Worst Hole\",MAX(V43:AJ43),IF(AN43=\"1 1/2 Worst Holes\",MAX(V43:AJ43)+LARGE(V43:AJ43,2)/2,IF(AN43=\"2 Worst Holes\",MAX(V43:AJ43)+LARGE(V43:AJ43,2),IF(AN43=\"2 1/2 Worst Holes\",MAX(V43:AJ43)+LARGE(V43:AJ43,2)+LARGE(V43:AJ43,3)/2,IF(AN43=\"3 Worst Holes\",MAX(V43:AJ43)+LARGE(V43:AJ43,2)+LARGE(V43:AJ43,3),\"\")))))))","v":""},{"$f":"IF(AN43=\"3 1/2 Worst Holes\",MAX(V43:AM43)+LARGE(V43:AM43,2)+LARGE(V43:AM43,3)+LARGE(V43:AM43,4)/2,IF(AN43=\"4 Worst Holes\",MAX(V43:AM43)+LARGE(V43:AM43,2)+LARGE(V43:AM43,3)+LARGE(V43:AM43,4),IF(AN43=\"4 1/2 Worst Holes\",MAX(V43:AM43)+LARGE(V43:AM43,2)+LARGE(V43:AM43,3)+LARGE(V43:AM43,4)+LARGE(V43:AM43,5)/2,IF(AN43=\"5 Worst Holes\",MAX(V43:AM43)+LARGE(V43:AM43,2)+LARGE(V43:AM43,3)+LARGE(V43:AM43,4)+LARGE(V43:AM43,5),IF(AN43=\"5 1/2 Worst Holes\",MAX(V43:AM43)+LARGE(V43:AM43,2)+LARGE(V43:AM43,3)+LARGE(V43:AM43,4)+LARGE(V43:AM43,5)+LARGE(V43:AM43,5)/2,IF(AN43=\"6 Worst Holes\",MAX(V43:AM43)+LARGE(V43:AM43,2)+LARGE(V43:AM43,3)+LARGE(V43:AM43,4)+LARGE(V43:AM43,5)+LARGE(V43:AM43,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U43,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO43),ROUND(AO43+AQ43,0),ROUND(AP43+AQ43,0))),0,IF(ISNUMBER(AO43),ROUND(AO43+AQ43,0),ROUND(AP43+AQ43,0)))","v":0},{"$f":"IF(ISERROR(AQ43),\"\",U43-AR43)","v":""}]
["Player 39",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U44>130,\"6 Worst Holes\",VLOOKUP(U44,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN44=\"Scratch\",\"0\",IF(AN44=\"1/2 of Worst Hole\",MAX(V44:AJ44)/2,IF(AN44=\"Worst Hole\",MAX(V44:AJ44),IF(AN44=\"1 1/2 Worst Holes\",MAX(V44:AJ44)+LARGE(V44:AJ44,2)/2,IF(AN44=\"2 Worst Holes\",MAX(V44:AJ44)+LARGE(V44:AJ44,2),IF(AN44=\"2 1/2 Worst Holes\",MAX(V44:AJ44)+LARGE(V44:AJ44,2)+LARGE(V44:AJ44,3)/2,IF(AN44=\"3 Worst Holes\",MAX(V44:AJ44)+LARGE(V44:AJ44,2)+LARGE(V44:AJ44,3),\"\")))))))","v":""},{"$f":"IF(AN44=\"3 1/2 Worst Holes\",MAX(V44:AM44)+LARGE(V44:AM44,2)+LARGE(V44:AM44,3)+LARGE(V44:AM44,4)/2,IF(AN44=\"4 Worst Holes\",MAX(V44:AM44)+LARGE(V44:AM44,2)+LARGE(V44:AM44,3)+LARGE(V44:AM44,4),IF(AN44=\"4 1/2 Worst Holes\",MAX(V44:AM44)+LARGE(V44:AM44,2)+LARGE(V44:AM44,3)+LARGE(V44:AM44,4)+LARGE(V44:AM44,5)/2,IF(AN44=\"5 Worst Holes\",MAX(V44:AM44)+LARGE(V44:AM44,2)+LARGE(V44:AM44,3)+LARGE(V44:AM44,4)+LARGE(V44:AM44,5),IF(AN44=\"5 1/2 Worst Holes\",MAX(V44:AM44)+LARGE(V44:AM44,2)+LARGE(V44:AM44,3)+LARGE(V44:AM44,4)+LARGE(V44:AM44,5)+LARGE(V44:AM44,5)/2,IF(AN44=\"6 Worst Holes\",MAX(V44:AM44)+LARGE(V44:AM44,2)+LARGE(V44:AM44,3)+LARGE(V44:AM44,4)+LARGE(V44:AM44,5)+LARGE(V44:AM44,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U44,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(ISNUMBER(AO44),ROUND(AO44+AQ44,0),ROUND(AP44+AQ44,0))),0,IF(ISNUMBER(AO44),ROUND(AO44+AQ44,0),ROUND(AP44+AQ44,0)))","v":0},{"$f":"IF(ISERROR(AQ44),\"\",U44-AR44)","v":""}]
["Player 40",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(U45>130,\"6 Worst Holes\",VLOOKUP(U45,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN45=\"Scratch\",\"0\",IF(AN45=\"1/2 of Worst Hole\",MAX(V45:AJ45)/2,IF(AN45=\"Worst Hole\",MAX(V45:AJ45),IF(AN45=\"1 1/2 Worst Holes\",MAX(V45:AJ45)+LARGE(V45:AJ45,2)/2,IF(AN45=\"2 Worst Holes\",MAX(V45:AJ45)+LARGE(V45:AJ45,2),IF(AN45=\"2 1/2 Worst Holes\",MAX(V45:AJ45)+LARGE(V45:AJ45,2)+LARGE(V45:AJ45,3)/2,IF(AN45=\"3 Worst Holes\",MAX(V45:AJ45)+LARGE(V45:AJ45,2)+LARGE(V45:AJ45,3),\"\")))))))","v":""},{"$f":"IF(AN45=\"3 1/2 Worst Holes\",MAX(V45:AM45)+LARGE(V45:AM45,2)+LARGE(V45:AM45,3)+LARGE(V45:AM45,4)/2,IF(AN45=\"4 Worst Holes\",MAX(V45:AM45)+LARGE(V45:AM45,2)+LARGE(V45:AM45,3)+LARGE(V45:AM45,4),IF(AN45=\"4 1/2 Worst Holes\",MAX(V45:AM45)+LARGE(V45:AM45,2)+LARGE(V45:AM45,3)+LARGE(V45:AM45,4)+LARGE(V45:AM45,5)/2,IF(AN45=\"5 Worst Holes\",MAX(V45:AM45)+LARGE(V45:AM45,2)+LARGE(V45:AM45,3)+LARGE(V45:AM45,4)+LARGE(V45:AM45,5),IF(AN45=\"5 1/2 Worst Holes\",MAX(V45:AM45)+LARGE(V45:AM45,2)+LARGE(V45:AM45,3)+LARGE(V45:AM45,4)+LARGE(V45:AM45,5)+LARGE(V45:AM45,5)/2,IF(AN45=\"6 Worst Holes\",MAX(V45:AM45)+LARGE(V45:AM45,2)+LARGE(V45:AM45,3)+LARGE(V45:AM45,4)+LARGE(V45:AM45,5)+LARGE(V45:AM45,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U45,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ45),\"\",U45-AR45)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C46>2*C$5,2*C$5,C46)","v":0},{"$f":"IF(D46>2*D$5,2*D$5,D46)","v":0},{"$f":"IF(E46>2*E$5,2*E$5,E46)","v":0},{"$f":"IF(F46>2*F$5,2*F$5,F46)","v":0},{"$f":"IF(G46>2*G$5,2*G$5,G46)","v":0},{"$f":"IF(H46>2*H$5,2*H$5,H46)","v":0},{"$f":"IF(I46>2*I$5,2*I$5,I46)","v":0},{"$f":"IF(J46>2*J$5,2*J$5,J46)","v":0},{"$f":"IF(K46>2*K$5,2*K$5,K46)","v":0},{"$f":"IF(L46>2*L$5,2*L$5,L46)","v":0},{"$f":"IF(M46>2*M$5,2*M$5,M46)","v":0},{"$f":"IF(N46>2*N$5,2*N$5,N46)","v":0},{"$f":"IF(O46>2*O$5,2*O$5,O46)","v":0},{"$f":"IF(P46>2*P$5,2*P$5,P46)","v":0},{"$f":"IF(Q46>2*Q$5,2*Q$5,Q46)","v":0},{"$f":"IF(R46>2*R$5,2*R$5,R46)","v":0},{"$f":"IF(S46>2*S$5,2*S$5,S46)","v":0},{"$f":"IF(T46>2*T$5,2*T$5,T46)","v":0},{"$f":"IF(U46>130,\"6 Worst Holes\",VLOOKUP(U46,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN46=\"Scratch\",\"0\",IF(AN46=\"1/2 of Worst Hole\",MAX(V46:AJ46)/2,IF(AN46=\"Worst Hole\",MAX(V46:AJ46),IF(AN46=\"1 1/2 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)/2,IF(AN46=\"2 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2),IF(AN46=\"2 1/2 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)/2,IF(AN46=\"3 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3),\"\")))))))","v":""},{"$f":"IF(AN46=\"3 1/2 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)+LARGE(V46:AJ46,4)/2,IF(AN46=\"4 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)+LARGE(V46:AJ46,4),IF(AN46=\"4 1/2 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)+LARGE(V46:AJ46,4)+LARGE(V46:AJ46,5)/2,IF(AN46=\"5 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)+LARGE(V46:AJ46,4)+LARGE(V46:AJ46,5),IF(AN46=\"5 1/2 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)+LARGE(V46:AJ46,4)+LARGE(V46:AJ46,5)+LARGE(V46:AJ46,5)/2,IF(AN46=\"6 Worst Holes\",MAX(V46:AJ46)+LARGE(V46:AJ46,2)+LARGE(V46:AJ46,3)+LARGE(V46:AJ46,4)+LARGE(V46:AJ46,5)+LARGE(V46:AJ46,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U46,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ46),\"\",U46-AR46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C47>2*C$5,2*C$5,C47)","v":0},{"$f":"IF(D47>2*D$5,2*D$5,D47)","v":0},{"$f":"IF(E47>2*E$5,2*E$5,E47)","v":0},{"$f":"IF(F47>2*F$5,2*F$5,F47)","v":0},{"$f":"IF(G47>2*G$5,2*G$5,G47)","v":0},{"$f":"IF(H47>2*H$5,2*H$5,H47)","v":0},{"$f":"IF(I47>2*I$5,2*I$5,I47)","v":0},{"$f":"IF(J47>2*J$5,2*J$5,J47)","v":0},{"$f":"IF(K47>2*K$5,2*K$5,K47)","v":0},{"$f":"IF(L47>2*L$5,2*L$5,L47)","v":0},{"$f":"IF(M47>2*M$5,2*M$5,M47)","v":0},{"$f":"IF(N47>2*N$5,2*N$5,N47)","v":0},{"$f":"IF(O47>2*O$5,2*O$5,O47)","v":0},{"$f":"IF(P47>2*P$5,2*P$5,P47)","v":0},{"$f":"IF(Q47>2*Q$5,2*Q$5,Q47)","v":0},{"$f":"IF(R47>2*R$5,2*R$5,R47)","v":0},{"$f":"IF(S47>2*S$5,2*S$5,S47)","v":0},{"$f":"IF(T47>2*T$5,2*T$5,T47)","v":0},{"$f":"IF(U47>130,\"6 Worst Holes\",VLOOKUP(U47,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN47=\"Scratch\",\"0\",IF(AN47=\"1/2 of Worst Hole\",MAX(V47:AJ47)/2,IF(AN47=\"Worst Hole\",MAX(V47:AJ47),IF(AN47=\"1 1/2 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)/2,IF(AN47=\"2 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2),IF(AN47=\"2 1/2 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)/2,IF(AN47=\"3 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3),\"\")))))))","v":""},{"$f":"IF(AN47=\"3 1/2 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)+LARGE(V47:AJ47,4)/2,IF(AN47=\"4 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)+LARGE(V47:AJ47,4),IF(AN47=\"4 1/2 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)+LARGE(V47:AJ47,4)+LARGE(V47:AJ47,5)/2,IF(AN47=\"5 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)+LARGE(V47:AJ47,4)+LARGE(V47:AJ47,5),IF(AN47=\"5 1/2 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)+LARGE(V47:AJ47,4)+LARGE(V47:AJ47,5)+LARGE(V47:AJ47,5)/2,IF(AN47=\"6 Worst Holes\",MAX(V47:AJ47)+LARGE(V47:AJ47,2)+LARGE(V47:AJ47,3)+LARGE(V47:AJ47,4)+LARGE(V47:AJ47,5)+LARGE(V47:AJ47,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U47,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ47),\"\",U47-AR47)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C48>2*C$5,2*C$5,C48)","v":0},{"$f":"IF(D48>2*D$5,2*D$5,D48)","v":0},{"$f":"IF(E48>2*E$5,2*E$5,E48)","v":0},{"$f":"IF(F48>2*F$5,2*F$5,F48)","v":0},{"$f":"IF(G48>2*G$5,2*G$5,G48)","v":0},{"$f":"IF(H48>2*H$5,2*H$5,H48)","v":0},{"$f":"IF(I48>2*I$5,2*I$5,I48)","v":0},{"$f":"IF(J48>2*J$5,2*J$5,J48)","v":0},{"$f":"IF(K48>2*K$5,2*K$5,K48)","v":0},{"$f":"IF(L48>2*L$5,2*L$5,L48)","v":0},{"$f":"IF(M48>2*M$5,2*M$5,M48)","v":0},{"$f":"IF(N48>2*N$5,2*N$5,N48)","v":0},{"$f":"IF(O48>2*O$5,2*O$5,O48)","v":0},{"$f":"IF(P48>2*P$5,2*P$5,P48)","v":0},{"$f":"IF(Q48>2*Q$5,2*Q$5,Q48)","v":0},{"$f":"IF(R48>2*R$5,2*R$5,R48)","v":0},{"$f":"IF(S48>2*S$5,2*S$5,S48)","v":0},{"$f":"IF(T48>2*T$5,2*T$5,T48)","v":0},{"$f":"IF(U48>130,\"6 Worst Holes\",VLOOKUP(U48,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN48=\"Scratch\",\"0\",IF(AN48=\"1/2 of Worst Hole\",MAX(V48:AJ48)/2,IF(AN48=\"Worst Hole\",MAX(V48:AJ48),IF(AN48=\"1 1/2 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)/2,IF(AN48=\"2 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2),IF(AN48=\"2 1/2 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)/2,IF(AN48=\"3 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3),\"\")))))))","v":""},{"$f":"IF(AN48=\"3 1/2 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)+LARGE(V48:AJ48,4)/2,IF(AN48=\"4 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)+LARGE(V48:AJ48,4),IF(AN48=\"4 1/2 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)+LARGE(V48:AJ48,4)+LARGE(V48:AJ48,5)/2,IF(AN48=\"5 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)+LARGE(V48:AJ48,4)+LARGE(V48:AJ48,5),IF(AN48=\"5 1/2 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)+LARGE(V48:AJ48,4)+LARGE(V48:AJ48,5)+LARGE(V48:AJ48,5)/2,IF(AN48=\"6 Worst Holes\",MAX(V48:AJ48)+LARGE(V48:AJ48,2)+LARGE(V48:AJ48,3)+LARGE(V48:AJ48,4)+LARGE(V48:AJ48,5)+LARGE(V48:AJ48,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U48,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ48),\"\",U48-AR48)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C49>2*C$5,2*C$5,C49)","v":0},{"$f":"IF(D49>2*D$5,2*D$5,D49)","v":0},{"$f":"IF(E49>2*E$5,2*E$5,E49)","v":0},{"$f":"IF(F49>2*F$5,2*F$5,F49)","v":0},{"$f":"IF(G49>2*G$5,2*G$5,G49)","v":0},{"$f":"IF(H49>2*H$5,2*H$5,H49)","v":0},{"$f":"IF(I49>2*I$5,2*I$5,I49)","v":0},{"$f":"IF(J49>2*J$5,2*J$5,J49)","v":0},{"$f":"IF(K49>2*K$5,2*K$5,K49)","v":0},{"$f":"IF(L49>2*L$5,2*L$5,L49)","v":0},{"$f":"IF(M49>2*M$5,2*M$5,M49)","v":0},{"$f":"IF(N49>2*N$5,2*N$5,N49)","v":0},{"$f":"IF(O49>2*O$5,2*O$5,O49)","v":0},{"$f":"IF(P49>2*P$5,2*P$5,P49)","v":0},{"$f":"IF(Q49>2*Q$5,2*Q$5,Q49)","v":0},{"$f":"IF(R49>2*R$5,2*R$5,R49)","v":0},{"$f":"IF(S49>2*S$5,2*S$5,S49)","v":0},{"$f":"IF(T49>2*T$5,2*T$5,T49)","v":0},{"$f":"IF(U49>130,\"6 Worst Holes\",VLOOKUP(U49,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN49=\"Scratch\",\"0\",IF(AN49=\"1/2 of Worst Hole\",MAX(V49:AJ49)/2,IF(AN49=\"Worst Hole\",MAX(V49:AJ49),IF(AN49=\"1 1/2 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)/2,IF(AN49=\"2 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2),IF(AN49=\"2 1/2 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)/2,IF(AN49=\"3 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3),\"\")))))))","v":""},{"$f":"IF(AN49=\"3 1/2 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)+LARGE(V49:AJ49,4)/2,IF(AN49=\"4 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)+LARGE(V49:AJ49,4),IF(AN49=\"4 1/2 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)+LARGE(V49:AJ49,4)+LARGE(V49:AJ49,5)/2,IF(AN49=\"5 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)+LARGE(V49:AJ49,4)+LARGE(V49:AJ49,5),IF(AN49=\"5 1/2 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)+LARGE(V49:AJ49,4)+LARGE(V49:AJ49,5)+LARGE(V49:AJ49,5)/2,IF(AN49=\"6 Worst Holes\",MAX(V49:AJ49)+LARGE(V49:AJ49,2)+LARGE(V49:AJ49,3)+LARGE(V49:AJ49,4)+LARGE(V49:AJ49,5)+LARGE(V49:AJ49,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U49,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ49),\"\",U49-AR49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C50>2*C$5,2*C$5,C50)","v":0},{"$f":"IF(D50>2*D$5,2*D$5,D50)","v":0},{"$f":"IF(E50>2*E$5,2*E$5,E50)","v":0},{"$f":"IF(F50>2*F$5,2*F$5,F50)","v":0},{"$f":"IF(G50>2*G$5,2*G$5,G50)","v":0},{"$f":"IF(H50>2*H$5,2*H$5,H50)","v":0},{"$f":"IF(I50>2*I$5,2*I$5,I50)","v":0},{"$f":"IF(J50>2*J$5,2*J$5,J50)","v":0},{"$f":"IF(K50>2*K$5,2*K$5,K50)","v":0},{"$f":"IF(L50>2*L$5,2*L$5,L50)","v":0},{"$f":"IF(M50>2*M$5,2*M$5,M50)","v":0},{"$f":"IF(N50>2*N$5,2*N$5,N50)","v":0},{"$f":"IF(O50>2*O$5,2*O$5,O50)","v":0},{"$f":"IF(P50>2*P$5,2*P$5,P50)","v":0},{"$f":"IF(Q50>2*Q$5,2*Q$5,Q50)","v":0},{"$f":"IF(R50>2*R$5,2*R$5,R50)","v":0},{"$f":"IF(S50>2*S$5,2*S$5,S50)","v":0},{"$f":"IF(T50>2*T$5,2*T$5,T50)","v":0},{"$f":"IF(U50>130,\"6 Worst Holes\",VLOOKUP(U50,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN50=\"Scratch\",\"0\",IF(AN50=\"1/2 of Worst Hole\",MAX(V50:AJ50)/2,IF(AN50=\"Worst Hole\",MAX(V50:AJ50),IF(AN50=\"1 1/2 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)/2,IF(AN50=\"2 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2),IF(AN50=\"2 1/2 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)/2,IF(AN50=\"3 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3),\"\")))))))","v":""},{"$f":"IF(AN50=\"3 1/2 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)+LARGE(V50:AJ50,4)/2,IF(AN50=\"4 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)+LARGE(V50:AJ50,4),IF(AN50=\"4 1/2 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)+LARGE(V50:AJ50,4)+LARGE(V50:AJ50,5)/2,IF(AN50=\"5 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)+LARGE(V50:AJ50,4)+LARGE(V50:AJ50,5),IF(AN50=\"5 1/2 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)+LARGE(V50:AJ50,4)+LARGE(V50:AJ50,5)+LARGE(V50:AJ50,5)/2,IF(AN50=\"6 Worst Holes\",MAX(V50:AJ50)+LARGE(V50:AJ50,2)+LARGE(V50:AJ50,3)+LARGE(V50:AJ50,4)+LARGE(V50:AJ50,5)+LARGE(V50:AJ50,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U50,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ50),\"\",U50-AR50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C51>2*C$5,2*C$5,C51)","v":0},{"$f":"IF(D51>2*D$5,2*D$5,D51)","v":0},{"$f":"IF(E51>2*E$5,2*E$5,E51)","v":0},{"$f":"IF(F51>2*F$5,2*F$5,F51)","v":0},{"$f":"IF(G51>2*G$5,2*G$5,G51)","v":0},{"$f":"IF(H51>2*H$5,2*H$5,H51)","v":0},{"$f":"IF(I51>2*I$5,2*I$5,I51)","v":0},{"$f":"IF(J51>2*J$5,2*J$5,J51)","v":0},{"$f":"IF(K51>2*K$5,2*K$5,K51)","v":0},{"$f":"IF(L51>2*L$5,2*L$5,L51)","v":0},{"$f":"IF(M51>2*M$5,2*M$5,M51)","v":0},{"$f":"IF(N51>2*N$5,2*N$5,N51)","v":0},{"$f":"IF(O51>2*O$5,2*O$5,O51)","v":0},{"$f":"IF(P51>2*P$5,2*P$5,P51)","v":0},{"$f":"IF(Q51>2*Q$5,2*Q$5,Q51)","v":0},{"$f":"IF(R51>2*R$5,2*R$5,R51)","v":0},{"$f":"IF(S51>2*S$5,2*S$5,S51)","v":0},{"$f":"IF(T51>2*T$5,2*T$5,T51)","v":0},{"$f":"IF(U51>130,\"6 Worst Holes\",VLOOKUP(U51,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN51=\"Scratch\",\"0\",IF(AN51=\"1/2 of Worst Hole\",MAX(V51:AJ51)/2,IF(AN51=\"Worst Hole\",MAX(V51:AJ51),IF(AN51=\"1 1/2 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)/2,IF(AN51=\"2 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2),IF(AN51=\"2 1/2 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)/2,IF(AN51=\"3 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3),\"\")))))))","v":""},{"$f":"IF(AN51=\"3 1/2 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)+LARGE(V51:AJ51,4)/2,IF(AN51=\"4 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)+LARGE(V51:AJ51,4),IF(AN51=\"4 1/2 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)+LARGE(V51:AJ51,4)+LARGE(V51:AJ51,5)/2,IF(AN51=\"5 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)+LARGE(V51:AJ51,4)+LARGE(V51:AJ51,5),IF(AN51=\"5 1/2 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)+LARGE(V51:AJ51,4)+LARGE(V51:AJ51,5)+LARGE(V51:AJ51,5)/2,IF(AN51=\"6 Worst Holes\",MAX(V51:AJ51)+LARGE(V51:AJ51,2)+LARGE(V51:AJ51,3)+LARGE(V51:AJ51,4)+LARGE(V51:AJ51,5)+LARGE(V51:AJ51,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U51,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ51),\"\",U51-AR51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(C52>2*C$5,2*C$5,C52)","v":0},{"$f":"IF(D52>2*D$5,2*D$5,D52)","v":0},{"$f":"IF(E52>2*E$5,2*E$5,E52)","v":0},{"$f":"IF(F52>2*F$5,2*F$5,F52)","v":0},{"$f":"IF(G52>2*G$5,2*G$5,G52)","v":0},{"$f":"IF(H52>2*H$5,2*H$5,H52)","v":0},{"$f":"IF(I52>2*I$5,2*I$5,I52)","v":0},{"$f":"IF(J52>2*J$5,2*J$5,J52)","v":0},{"$f":"IF(K52>2*K$5,2*K$5,K52)","v":0},{"$f":"IF(L52>2*L$5,2*L$5,L52)","v":0},{"$f":"IF(M52>2*M$5,2*M$5,M52)","v":0},{"$f":"IF(N52>2*N$5,2*N$5,N52)","v":0},{"$f":"IF(O52>2*O$5,2*O$5,O52)","v":0},{"$f":"IF(P52>2*P$5,2*P$5,P52)","v":0},{"$f":"IF(Q52>2*Q$5,2*Q$5,Q52)","v":0},{"$f":"IF(R52>2*R$5,2*R$5,R52)","v":0},{"$f":"IF(S52>2*S$5,2*S$5,S52)","v":0},{"$f":"IF(T52>2*T$5,2*T$5,T52)","v":0},{"$f":"IF(U52>130,\"6 Worst Holes\",VLOOKUP(U52,Settings!$A$18:$J$80,2,FALSE))","v":"6 Worst Holes"},{"$f":"IF(AN52=\"Scratch\",\"0\",IF(AN52=\"1/2 of Worst Hole\",MAX(V52:AJ52)/2,IF(AN52=\"Worst Hole\",MAX(V52:AJ52),IF(AN52=\"1 1/2 Worst Holes\",MAX(V52:AJ52)+LARGE(V52:AJ52,2)/2,IF(AN52=\"2 Worst Holes\",MAX(V52:AJ52)+LARGE(V52:AJ52,2),IF(AN52=\"2 1/2 Worst Holes\",MAX(V52:AJ52)+LARGE(V52:AJ52,2)+LARGE(V52:AJ52,3)/2,IF(AN52=\"3 Worst Holes\",MAX(V52:AJ52)+LARGE(V52:AJ52,2)+LARGE(V52:AJ52,3),\"\")))))))","v":""},{"$f":"IF(AN52=\"3 1/2 Worst Holes\",MAX(V52:AM52)+LARGE(V52:AM52,2)+LARGE(V52:AM52,3)+LARGE(V52:AM52,4)/2,IF(AN52=\"4 Worst Holes\",MAX(V52:AM52)+LARGE(V52:AM52,2)+LARGE(V52:AM52,3)+LARGE(V52:AM52,4),IF(AN52=\"4 1/2 Worst Holes\",MAX(V52:AM52)+LARGE(V52:AM52,2)+LARGE(V52:AM52,3)+LARGE(V52:AM52,4)+LARGE(V52:AM52,5)/2,IF(AN52=\"5 Worst Holes\",MAX(V52:AM52)+LARGE(V52:AM52,2)+LARGE(V52:AM52,3)+LARGE(V52:AM52,4)+LARGE(V52:AM52,5),IF(AN52=\"5 1/2 Worst Holes\",MAX(V52:AM52)+LARGE(V52:AM52,2)+LARGE(V52:AM52,3)+LARGE(V52:AM52,4)+LARGE(V52:AM52,5)+LARGE(V52:AM52,5)/2,IF(AN52=\"6 Worst Holes\",MAX(V52:AM52)+LARGE(V52:AM52,2)+LARGE(V52:AM52,3)+LARGE(V52:AM52,4)+LARGE(V52:AM52,5)+LARGE(V52:AM52,5),\"\"))))))","v":0},{"$f":"VLOOKUP(U52,Settings!$A$18:$J$80,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(AQ52),\"\",U52-AR52)","v":""}]

{"sheet":"Settings","index":2,"n_rows":80,"n_cols":15,"rows_kept":80,"cut":false,"hidden":false,"merged":[[3,5,3,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[0,0,0,4],[0,5,0,8],[1,5,1,8],[2,5,2,8],[14,5,14,8],[11,5,11,8],[12,5,12,8],[13,5,13,8],[7,5,7,8],[8,5,8,8],[9,5,9,8],[10,5,10,8]]}
["Gross (using double par max.)",null,null,null,null,"Handicap Deduction"]
[null,null,70,71,72,"Scratch",null,null,null,null,null,null,null,null,"You can choose to exclude the 16th"]
[73,74,75,null,null,"1/2 of Worst Hole",null,null,null,null,null,null,null,null,"hole from the \"worst hole\" calculation."]
[76,77,78,79,80,"Worst Hole"]
[81,82,83,84,85,"1 1/2 Worst Holes",null,null,null,null,null,null,null,null,"The idea is to prevent a player from using the"]
[86,87,88,89,90,"2 Worst Holes",null,null,null,null,null,null,null,null,"last 2 or 3 holes to jack up his handicap"]
[91,92,93,94,95,"2 1/2 Worst Holes"]
[96,97,98,99,100,"3 Worst Holes"]
[101,102,103,104,105,"3 1/2 Worst Holes"]
[106,107,108,109,110,"4 Worst Holes"]
[111,112,113,114,115,"4 1/2 Worst Holes"]
[116,117,118,119,120,"5 Worst Holes"]
[121,122,123,124,125,"5 1/2 Worst Holes"]
[126,127,128,129,130,"6 Worst Holes"]
[-2,-1,0,1,2,"Handicap Adjustment"]
[]
[]
[68,{"$f":"$F$2","v":"Scratch"},0]
[69,{"$f":"$F$2","v":"Scratch"},0]
[70,{"$f":"$F$2","v":"Scratch"},0]
[71,{"$f":"$F$2","v":"Scratch"},0]
[72,{"$f":"$F$2","v":"Scratch"},0]
[73,{"$f":"$F$3","v":"1/2 of Worst Hole"},-2]
[74,{"$f":"$F$3","v":"1/2 of Worst Hole"},-1]
[75,{"$f":"$F$3","v":"1/2 of Worst Hole"},0]
[76,{"$f":"$F$4","v":"Worst Hole"},-2]
[77,{"$f":"$F$4","v":"Worst Hole"},-1]
[78,{"$f":"$F$4","v":"Worst Hole"},0]
[79,{"$f":"$F$4","v":"Worst Hole"},1]
[80,{"$f":"$F$4","v":"Worst Hole"},2]
[81,{"$f":"$F$5","v":"1 1/2 Worst Holes"},-2]
[82,{"$f":"$F$5","v":"1 1/2 Worst Holes"},-1]
[83,{"$f":"$F$5","v":"1 1/2 Worst Holes"},0]
[84,{"$f":"$F$5","v":"1 1/2 Worst Holes"},1]
[85,{"$f":"$F$5","v":"1 1/2 Worst Holes"},2]
[86,{"$f":"$F$6","v":"2 Worst Holes"},-2]
[87,{"$f":"$F$6","v":"2 Worst Holes"},-1]
[88,{"$f":"$F$6","v":"2 Worst Holes"},0]
[89,{"$f":"$F$6","v":"2 Worst Holes"},1]
[90,{"$f":"$F$6","v":"2 Worst Holes"},2]
[91,{"$f":"$F$7","v":"2 1/2 Worst Holes"},-2]
[92,{"$f":"$F$7","v":"2 1/2 Worst Holes"},-1]
[93,{"$f":"$F$7","v":"2 1/2 Worst Holes"},0]
[94,{"$f":"$F$7","v":"2 1/2 Worst Holes"},1]
[95,{"$f":"$F$7","v":"2 1/2 Worst Holes"},2]
[96,{"$f":"$F$8","v":"3 Worst Holes"},-2]
[97,{"$f":"$F$8","v":"3 Worst Holes"},-1]
[98,{"$f":"$F$8","v":"3 Worst Holes"},0]
[99,{"$f":"$F$8","v":"3 Worst Holes"},1]
[100,{"$f":"$F$8","v":"3 Worst Holes"},2]
[101,{"$f":"$F$9","v":"3 1/2 Worst Holes"},-2]
[102,{"$f":"$F$9","v":"3 1/2 Worst Holes"},-1]
[103,{"$f":"$F$9","v":"3 1/2 Worst Holes"},0]
[104,{"$f":"$F$9","v":"3 1/2 Worst Holes"},1]
[105,{"$f":"$F$9","v":"3 1/2 Worst Holes"},2]
[106,{"$f":"$F$10","v":"4 Worst Holes"},-2]
[107,{"$f":"$F$10","v":"4 Worst Holes"},-1]
[108,{"$f":"$F$10","v":"4 Worst Holes"},0]
[109,{"$f":"$F$10","v":"4 Worst Holes"},1]
[110,{"$f":"$F$10","v":"4 Worst Holes"},2]
[111,{"$f":"$F$11","v":"4 1/2 Worst Holes"},-2]
[112,{"$f":"$F$11","v":"4 1/2 Worst Holes"},-1]
[113,{"$f":"$F$11","v":"4 1/2 Worst Holes"},0]
[114,{"$f":"$F$11","v":"4 1/2 Worst Holes"},1]
[115,{"$f":"$F$11","v":"4 1/2 Worst Holes"},2]
[116,{"$f":"$F$12","v":"5 Worst Holes"},-2]
[117,{"$f":"$F$12","v":"5 Worst Holes"},-1]
[118,{"$f":"$F$12","v":"5 Worst Holes"},0]
[119,{"$f":"$F$12","v":"5 Worst Holes"},1]
[120,{"$f":"$F$12","v":"5 Worst Holes"},2]
[121,{"$f":"$F$13","v":"5 1/2 Worst Holes"},-2]
[122,{"$f":"$F$13","v":"5 1/2 Worst Holes"},-1]
[123,{"$f":"$F$13","v":"5 1/2 Worst Holes"},0]
[124,{"$f":"$F$13","v":"5 1/2 Worst Holes"},1]
[125,{"$f":"$F$13","v":"5 1/2 Worst Holes"},2]
[126,{"$f":"$F$14","v":"6 Worst Holes"},-2]
[127,{"$f":"$F$14","v":"6 Worst Holes"},-1]
[128,{"$f":"$F$14","v":"6 Worst Holes"},0]
[129,{"$f":"$F$14","v":"6 Worst Holes"},1]
[130,{"$f":"$F$14","v":"6 Worst Holes"},2]