{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Main Menu","SheetVisibility","RefList","SchedulePlanner","Weekly Schedule","Player Contribution","AGL Teams","12OunceHcapRoster","EHS Restriction"],"not_rendered":{"images":3,"macros":1,"external_links":1,"defined_names":391},"read":"whole","date_system":"1900"}

{"sheet":"Main Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"SheetVisibility","index":1,"n_rows":10,"n_cols":4,"rows_kept":10}
["Sheet Name","CodeName","Visibility","Visible\nHidden\nVeryHidden"]
["Main Menu","Sheet9",{"$f":"IF(D2=\"xlSheetVeryHidden\",2,IF(D2=\"xlSheetHidden\",0,-1))","v":2},"xlSheetVeryHidden"]
["SheetVisibility","programmerSheetVisibility",{"$f":"IF(D3=\"xlSheetVeryHidden\",2,IF(D3=\"xlSheetHidden\",0,-1))","v":0},"xlSheetHidden"]
["RefList","Sheet8",2,"xlSheetVeryHidden"]
["SchedulePlanner","Sheet11",2,"xlSheetVeryHidden"]
["Weekly Schedule","Sheet1",-1,"xlSheetVisible"]
["Player Contribution","Sheet2",-1,"xlSheetVisible"]
["AGL Teams","Sheet3",2,"xlSheetVeryHidden"]
["EHS Restriction","Sheet4",2,"xlSheetVeryHidden"]
["12OunceHcapRoster","Sheet5",-1,"xlSheetVisible"]

{"sheet":"RefList","index":2,"n_rows":1,"n_cols":1,"rows_kept":1}
["No External References In This Workbook"]

{"sheet":"SchedulePlanner","index":3,"n_rows":64,"n_cols":19,"rows_kept":64,"merged":[[0,0,0,10]]}
["12 Ounce Handicap - 2016 Playing Schedule"]
["Week",{"$f":"'Weekly Schedule'!B3","v":"Smiley"},{"$f":"'Weekly Schedule'!C3","v":"Laces"},{"$f":"'Weekly Schedule'!D3","v":"BB"},{"$f":"'Weekly Schedule'!E3","v":"Lewis"},{"$f":"'Weekly Schedule'!F3","v":"Cooler Dude"},{"$f":"'Weekly Schedule'!G3","v":"Yates"},null,"X","Beer","Total","Front","Back",null,"Laces","BB","Lewis","Cooler Dude","Yates"]
["2016-06-07","X","X","Bye","X","Bye","X",null,{"$f":"COUNTIF(B3:G3,\"X\")","v":4},{"$f":"COUNTIF(B3:G3,\"Beer\")","v":0},{"$f":"I3+J3","v":4},{"$f":"IF('Weekly Schedule'!L4=\"\",\"x\",\"\")","v":""},{"$f":"IF(L3=\"\",\"x\",\"\")","v":"x"},"Smiley",6,5,7,4,7]
[{"$f":"A3+7","v":"2016-06-14"},"X","X","X","Bye","Bye","X",null,{"$f":"COUNTIF(B4:G4,\"X\")","v":4},{"$f":"COUNTIF(B4:G4,\"Beer\")","v":0},{"$f":"I4+J4","v":4},{"$f":"IF('Weekly Schedule'!L5=\"\",\"x\",\"\")","v":"x"},"","Laces",null,6,5,7,5]
["2016-06-21","X","X","X","Bye","Bye","Bye",null,3,0,3,{"$f":"IF('Weekly Schedule'!L6=\"\",\"x\",\"\")","v":""},"x","BB",null,null,6,5,7]
["2016-06-28","Bye","X","X","X","X","Bye",null,4,0,4,{"$f":"IF('Weekly Schedule'!L7=\"\",\"x\",\"\")","v":"x"},"","Lewis",{"$nulls":3},6,6]
["2016-07-05","X","Bye","Bye","X","X","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L8=\"\",\"x\",\"\")","v":""},"x","Cooler Dude",{"$nulls":4},5]
["2016-07-12","Bye","Bye","X","X","X","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L9=\"\",\"x\",\"\")","v":"x"},""]
["2016-07-19","Bye","X","X","Bye","X","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L10=\"\",\"x\",\"\")","v":""},"x"]
["2016-07-26","X","X","Bye","X","X","Bye",null,4,0,4,{"$f":"IF('Weekly Schedule'!L11=\"\",\"x\",\"\")","v":"x"},""]
["2016-08-02","X","Bye","X","X","Bye","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L12=\"\",\"x\",\"\")","v":""},"x"]
["2016-08-09","Bye","X","X","Bye","X","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L13=\"\",\"x\",\"\")","v":"x"},""]
["2016-08-16","X","X","Bye","X","X","Bye",null,4,0,4,{"$f":"IF('Weekly Schedule'!L14=\"\",\"x\",\"\")","v":""},"x"]
["2016-08-23","X","Bye","X","X","Bye","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L15=\"\",\"x\",\"\")","v":"x"},""]
["2016-08-30","X","X","Bye","Bye","X","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L16=\"\",\"x\",\"\")","v":""},"x"]
["2016-09-06","Bye","X","X","X","X","Bye",null,4,0,4,{"$f":"IF('Weekly Schedule'!L17=\"\",\"x\",\"\")","v":"x"},""]
["2016-09-13","X","Bye","X","X","Bye","X",null,4,0,4,{"$f":"IF('Weekly Schedule'!L18=\"\",\"x\",\"\")","v":""},"x"]
["2016-05-21","Season Opening Tourney"]
["2016-07-16","Mid-Season Tourney"]
["2016-09-24","Final Annual Tourney"]
["Bye",{"$f":"COUNTIF(B$3:B$20,$A21)","v":5},{"$f":"COUNTIF(C$3:C$20,$A21)","v":5},5,5,6,5]
["Beer",{"$f":"COUNTIF(B$3:B$20,$A22)","v":0},0,0,0,0,0]
[]
[null,"Buds","DC","DC","Coors Lite"]
[{"$f":"'Weekly Schedule'!A27","v":"Opening Tourney - Sat 21 May 2016"}]
[{"$f":"'Weekly Schedule'!A28","v":"Mid-Season Tourney - Sat 16 July 2016"}]
[{"$f":"'Weekly Schedule'!A29","v":"Final Tourney - Sat 24 September 2016"}]
[]
[]
[null,"Fr","Fr","Fr","Fr","Fr","Fr"]
[null,{"$f":"IF(AND(OR(B3=\"Beer\",B3=\"X\"),$L3<>\"\"),1,\"\")","v":""},{"$f":"IF(AND(OR(C3=\"Beer\",C3=\"X\"),$L3<>\"\"),1,\"\")","v":""},"","","",""]
[null,1,1,1,"","",1]
[null,"","","","","",""]
[null,"",1,1,1,1,""]
[null,"","","","","",""]
[null,"","",1,1,1,1]
[null,"","","","","",""]
[null,1,1,"",1,1,""]
[null,"","","","","",""]
[null,"",1,1,"",1,1]
[null,"","","","","",""]
[null,1,"",1,1,"",1]
[null,"","","","","",""]
[null,"",1,1,1,1,""]
[null,"","","","","",""]
[null,{"$f":"SUM(B31:B45)","v":3},5,6,5,5,4]
[null,"Bk","Bk","Bk","Bk","Bk","Bk"]
[null,{"$f":"IF(AND(OR(B3=\"Beer\",B3=\"X\"),$M3<>\"\"),1,\"\")","v":1},1,"",1,"",1]
[null,"","","","","",""]
[null,1,1,1,"","",""]
[null,"","","","","",""]
[null,1,"","",1,1,1]
[null,"","","","","",""]
[null,"",1,1,"",1,1]
[null,"","","","","",""]
[null,1,"",1,1,"",1]
[null,"","","","","",""]
[null,1,1,"",1,1,""]
[null,"","","","","",""]
[null,1,1,"","",1,1]
[null,"","","","","",""]
[null,1,"",1,1,"",1]
[null,{"$f":"SUM(B48:B62)","v":7},5,4,5,4,6]
[null,{"$f":"B63+B46","v":10},10,10,10,9,10]

{"sheet":"Weekly Schedule","index":4,"n_rows":66,"n_cols":26,"rows_kept":66,"merged":[[1,0,1,10],[1,11,1,12],[1,13,1,25],[2,16,2,25],[3,7,5,7],[6,7,8,7],[9,7,11,7],[12,7,14,7],[15,7,17,7]]}
["AGLID","2006_062","2006_016","2013_009","2014_011","2006_070","2015_013"]
[{"$f":"SchedulePlanner!A1","v":"12 Ounce Handicap - 2016 Playing Schedule"},{"$nulls":10},"Starting Hole",null,"Opposing Team"]
["Week",{"$f":"IF(VLOOKUP(B1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE)<>\"\",VLOOKUP(B1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE),VLOOKUP(B1,'12OunceHcapRoster'!$A$2:$AA$9,6,FALSE))","v":"Smiley"},{"$f":"IF(VLOOKUP(C1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE)<>\"\",VLOOKUP(C1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE),VLOOKUP(C1,'12OunceHcapRoster'!$A$2:$AA$9,6,FALSE))","v":"Laces"},{"$f":"IF(VLOOKUP(D1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE)<>\"\",VLOOKUP(D1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE),VLOOKUP(D1,'12OunceHcapRoster'!$A$2:$AA$9,6,FALSE))","v":"BB"},{"$f":"IF(VLOOKUP(E1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE)<>\"\",VLOOKUP(E1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE),VLOOKUP(E1,'12OunceHcapRoster'!$A$2:$AA$9,6,FALSE))","v":"Lewis"},{"$f":"IF(VLOOKUP(F1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE)<>\"\",VLOOKUP(F1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE),VLOOKUP(F1,'12OunceHcapRoster'!$A$2:$AA$9,6,FALSE))","v":"Cooler Dude"},{"$f":"IF(VLOOKUP(G1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE)<>\"\",VLOOKUP(G1,'12OunceHcapRoster'!$A$2:$AA$9,11,FALSE),VLOOKUP(G1,'12OunceHcapRoster'!$A$2:$AA$9,6,FALSE))","v":"Yates"},"Robin","X","Beer","Total","Back","Front","Number","Name","Captain","Players"]
[{"$f":"SchedulePlanner!A3","v":"2016-06-07"},{"$f":"SchedulePlanner!B3","v":"X"},{"$f":"SchedulePlanner!C3","v":"X"},{"$f":"SchedulePlanner!D3","v":"Bye"},{"$f":"SchedulePlanner!E3","v":"X"},{"$f":"SchedulePlanner!F3","v":"Bye"},{"$f":"SchedulePlanner!G3","v":"X"},1,{"$f":"COUNTIF(B4:G4,\"X\")","v":4},{"$f":"COUNTIF(B4:G4,\"Beer\")","v":0},{"$f":"I4+J4","v":4},15,null,3,{"$f":"VLOOKUP(N4,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Hack Attack"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2014_006"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2014_006"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2014_005"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2014_009"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_002"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2014_010"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_004"},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N4,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A4","v":"2016-06-14"},{"$f":"SchedulePlanner!B4","v":"X"},{"$f":"SchedulePlanner!C4","v":"X"},{"$f":"SchedulePlanner!D4","v":"X"},{"$f":"SchedulePlanner!E4","v":"Bye"},{"$f":"SchedulePlanner!F4","v":"Bye"},{"$f":"SchedulePlanner!G4","v":"X"},null,{"$f":"COUNTIF(B5:G5,\"X\")","v":4},{"$f":"COUNTIF(B5:G5,\"Beer\")","v":0},{"$f":"I5+J5","v":4},null,1,15,{"$f":"VLOOKUP(N5,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Stress Relief"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_090"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_090"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_015"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_032"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_078"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_079"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_003"},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N5,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A5","v":"2016-06-21"},{"$f":"SchedulePlanner!B5","v":"X"},{"$f":"SchedulePlanner!C5","v":"X"},{"$f":"SchedulePlanner!D5","v":"X"},{"$f":"SchedulePlanner!E5","v":"Bye"},{"$f":"SchedulePlanner!F5","v":"Bye"},{"$f":"SchedulePlanner!G5","v":"Bye"},null,3,0,3,12,null,5,{"$f":"VLOOKUP(N6,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Big Knockers"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_041"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_041"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_025"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_029"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2008_002"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_058"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2011_007"},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N6,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A6","v":"2016-06-28"},{"$f":"SchedulePlanner!B6","v":"Bye"},{"$f":"SchedulePlanner!C6","v":"X"},{"$f":"SchedulePlanner!D6","v":"X"},{"$f":"SchedulePlanner!E6","v":"X"},{"$f":"SchedulePlanner!F6","v":"X"},{"$f":"SchedulePlanner!G6","v":"Bye"},2,4,0,4,null,8,13,{"$f":"VLOOKUP(N7,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Crooked Shanks"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2011_004"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2011_004"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_007"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2013_003"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_006"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_009"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_087"},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N7,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A7","v":"2016-07-05"},{"$f":"SchedulePlanner!B7","v":"X"},{"$f":"SchedulePlanner!C7","v":"Bye"},{"$f":"SchedulePlanner!D7","v":"Bye"},{"$f":"SchedulePlanner!E7","v":"X"},{"$f":"SchedulePlanner!F7","v":"X"},{"$f":"SchedulePlanner!G7","v":"X"},null,4,0,4,11,null,8,{"$f":"VLOOKUP(N8,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Deep Ruff"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_083"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_083"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_001"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_036"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_014"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_052"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2010_008"},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N8,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A8","v":"2016-07-12"},{"$f":"SchedulePlanner!B8","v":"Bye"},{"$f":"SchedulePlanner!C8","v":"Bye"},{"$f":"SchedulePlanner!D8","v":"X"},{"$f":"SchedulePlanner!E8","v":"X"},{"$f":"SchedulePlanner!F8","v":"X"},{"$f":"SchedulePlanner!G8","v":"X"},null,4,0,4,null,3,14,{"$f":"VLOOKUP(N9,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Bogey Machine"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_084"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_084"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_005"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2010_009"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_038"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_064"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_004"},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N9,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A9","v":"2016-07-19"},{"$f":"SchedulePlanner!B9","v":"Bye"},{"$f":"SchedulePlanner!C9","v":"X"},{"$f":"SchedulePlanner!D9","v":"X"},{"$f":"SchedulePlanner!E9","v":"Bye"},{"$f":"SchedulePlanner!F9","v":"X"},{"$f":"SchedulePlanner!G9","v":"X"},3,4,0,4,18,null,16,{"$f":"VLOOKUP(N10,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Bye"},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N10,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A10","v":"2016-07-26"},{"$f":"SchedulePlanner!B10","v":"X"},{"$f":"SchedulePlanner!C10","v":"X"},{"$f":"SchedulePlanner!D10","v":"Bye"},{"$f":"SchedulePlanner!E10","v":"X"},{"$f":"SchedulePlanner!F10","v":"X"},{"$f":"SchedulePlanner!G10","v":"Bye"},null,4,0,4,null,8,6,{"$f":"VLOOKUP(N11,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Greenies"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_012"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_012"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_008"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_010"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_009"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_012"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_011"},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N11,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A11","v":"2016-08-02"},{"$f":"SchedulePlanner!B11","v":"X"},{"$f":"SchedulePlanner!C11","v":"Bye"},{"$f":"SchedulePlanner!D11","v":"X"},{"$f":"SchedulePlanner!E11","v":"X"},{"$f":"SchedulePlanner!F11","v":"Bye"},{"$f":"SchedulePlanner!G11","v":"X"},null,4,0,4,"13/14",null,10,{"$f":"VLOOKUP(N12,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Rusty Irons"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_054"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_054"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_008"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_013"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_010"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_069"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_011"},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N12,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A12","v":"2016-08-09"},{"$f":"SchedulePlanner!B12","v":"Bye"},{"$f":"SchedulePlanner!C12","v":"X"},{"$f":"SchedulePlanner!D12","v":"X"},{"$f":"SchedulePlanner!E12","v":"Bye"},{"$f":"SchedulePlanner!F12","v":"X"},{"$f":"SchedulePlanner!G12","v":"X"},4,4,0,4,null,2,1,{"$f":"VLOOKUP(N13,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Putt-Putts"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_007"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_007"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_014"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_035"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_005"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_075"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_091"},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N13,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A13","v":"2016-08-16"},{"$f":"SchedulePlanner!B13","v":"X"},{"$f":"SchedulePlanner!C13","v":"X"},{"$f":"SchedulePlanner!D13","v":"Bye"},{"$f":"SchedulePlanner!E13","v":"X"},{"$f":"SchedulePlanner!F13","v":"X"},{"$f":"SchedulePlanner!G13","v":"Bye"},null,4,0,4,17,null,4,{"$f":"VLOOKUP(N14,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"A Flights"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2012_004"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2012_004"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2007_001"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2013_006"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_001"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2014_001"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2012_007"},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N14,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A14","v":"2016-08-23"},{"$f":"SchedulePlanner!B14","v":"X"},{"$f":"SchedulePlanner!C14","v":"Bye"},{"$f":"SchedulePlanner!D14","v":"X"},{"$f":"SchedulePlanner!E14","v":"X"},{"$f":"SchedulePlanner!F14","v":"Bye"},{"$f":"SchedulePlanner!G14","v":"X"},null,4,0,4,null,"6/7",12,{"$f":"VLOOKUP(N15,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Bogie Bunch"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_086"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_086"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2011_001"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_031"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_002"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_003"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2010_001"},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N15,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A15","v":"2016-08-30"},{"$f":"SchedulePlanner!B15","v":"X"},{"$f":"SchedulePlanner!C15","v":"X"},{"$f":"SchedulePlanner!D15","v":"Bye"},{"$f":"SchedulePlanner!E15","v":"Bye"},{"$f":"SchedulePlanner!F15","v":"X"},{"$f":"SchedulePlanner!G15","v":"X"},5,4,0,4,10,null,9,{"$f":"VLOOKUP(N16,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Stiff Shafts"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_033"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_033"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_006"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_012"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2015_007"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2016_013"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_081"},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N16,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A16","v":"2016-09-06"},{"$f":"SchedulePlanner!B16","v":"Bye"},{"$f":"SchedulePlanner!C16","v":"X"},{"$f":"SchedulePlanner!D16","v":"X"},{"$f":"SchedulePlanner!E16","v":"X"},{"$f":"SchedulePlanner!F16","v":"X"},{"$f":"SchedulePlanner!G16","v":"Bye"},null,4,0,4,null,"6/7",2,{"$f":"VLOOKUP(N17,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Tuff Links"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_053"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_053"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_022"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_040"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_077"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_082"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_088"},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N17,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A17","v":"2016-09-13"},{"$f":"SchedulePlanner!B17","v":"X"},{"$f":"SchedulePlanner!C17","v":"Bye"},{"$f":"SchedulePlanner!D17","v":"X"},{"$f":"SchedulePlanner!E17","v":"X"},{"$f":"SchedulePlanner!F17","v":"Bye"},{"$f":"SchedulePlanner!G17","v":"X"},null,4,0,4,"13/14",null,7,{"$f":"VLOOKUP(N18,'AGL Teams'!$A$2:$O$17,2,FALSE)","v":"Happy Gilmores"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_076"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_076"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_059"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_060"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_063"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2010_003"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":"2006_067"},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0},{"$f":"VLOOKUP($N18,'AGL Teams'!$A$2:$O$17,COLUMN()-11,FALSE)","v":0}]
[{"$f":"SchedulePlanner!A18","v":"2016-05-21"},"X","X","X","X","X","X",{"$f":"SchedulePlanner!B18","v":"Season Opening Tourney"}]
[{"$f":"SchedulePlanner!A19","v":"2016-07-16"},"X","X","X","X","X","X",{"$f":"SchedulePlanner!B19","v":"Mid-Season Tourney"}]
[{"$f":"SchedulePlanner!A20","v":"2016-09-24"},"X","X","X","X","X","X",{"$f":"SchedulePlanner!B20","v":"Final Annual Tourney"}]
["Bye",{"$f":"COUNTIF(B$4:B$21,$A22)","v":5},{"$f":"COUNTIF(C$4:C$21,$A22)","v":5},5,5,6,5]
["Beer",{"$f":"COUNTIF(B$4:B$21,$A23)","v":0},0,0,0,0,0]
[null,"X",{"$f":"\"- Scheduled to Play\"","v":"- Scheduled to Play"}]
[null,"Beer",{"$f":"\"- Scheduled to Play AND Bring the Beer (Tourneys are BYO)\"","v":"- Scheduled to Play AND Bring the Beer (Tourneys are BYO)"}]
[null,"BYE",{"$f":"\"- Not Scheduled to Play\"","v":"- Not Scheduled to Play"}]
[{"$f":"\"Opening Tourney - \" & TEXT(A19, \"ddd d mmmm yyyy\")","v":"Opening Tourney - Sat 21 May 2016"}]
[{"$f":"\"Mid-Season Tourney - \" & TEXT(A20, \"ddd d mmmm yyyy\")","v":"Mid-Season Tourney - Sat 16 July 2016"}]
[{"$f":"\"Final Tourney - \" & TEXT(A21, \"ddd d mmmm yyyy\")","v":"Final Tourney - Sat 24 September 2016"}]
[]
[]
[null,"Fr","Fr","Fr","Fr","Fr","Fr"]
[null,{"$f":"IF(AND(OR(B4=\"Beer\",B4=\"X\"),$L4<>\"\"),1,\"\")","v":1},1,"",1,"",1]
[null,"","","","","",""]
[null,1,1,1,"","",""]
[null,"","","","","",""]
[null,1,"","",1,1,1]
[null,"","","","","",""]
[null,"",1,1,"",1,1]
[null,"","","","","",""]
[null,1,"",1,1,"",1]
[null,"","","","","",""]
[null,1,1,"",1,1,""]
[null,"","","","","",""]
[null,1,1,"","",1,1]
[null,"","","","","",""]
[null,1,"",1,1,"",1]
[null,{"$f":"SUM(B33:B47)+IF(B20<>\"BYE\",1,0)+IF(B21<>\"BYE\",1,0)","v":9},7,6,7,6,8]
[null,"Bk","Bk","Bk","Bk","Bk","Bk"]
[null,{"$f":"IF(AND(OR(B4=\"Beer\",B4=\"X\"),$M4<>\"\"),1,\"\")","v":""},"","","","",""]
[null,1,1,1,"","",1]
[null,"","","","","",""]
[null,"",1,1,1,1,""]
[null,"","","","","",""]
[null,"","",1,1,1,1]
[null,"","","","","",""]
[null,1,1,"",1,1,""]
[null,"","","","","",""]
[null,"",1,1,"",1,1]
[null,"","","","","",""]
[null,1,"",1,1,"",1]
[null,"","","","","",""]
[null,"",1,1,1,1,""]
[null,"","","","","",""]
[null,{"$f":"SUM(B50:B64)+IF(B20<>\"BYE\",1,0)+IF(B21<>\"BYE\",1,0)","v":5},7,8,7,7,6]
[null,{"$f":"B48+B65","v":14},14,14,14,13,14]

{"sheet":"Player Contribution","index":5,"n_rows":51,"n_cols":26,"rows_kept":51,"merged":[[0,0,0,25],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,16],[1,17,1,19],[1,20,1,24],[1,25,2,25],[3,25,5,25],[6,25,8,25],[9,25,11,25],[12,25,14,25],[15,25,17,25],[21,2,21,4],[21,5,21,7],[21,8,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,19],[21,23,23,24],[21,25,23,25]]}
["12 Ounce Handicap - Playing Contribution"]
[null,null,{"$f":"'Weekly Schedule'!B3","v":"Smiley"},null,null,{"$f":"'Weekly Schedule'!C3","v":"Laces"},null,null,{"$f":"'Weekly Schedule'!D3","v":"BB"},null,null,{"$f":"'Weekly Schedule'!E3","v":"Lewis"},null,null,{"$f":"'Weekly Schedule'!F3","v":"Cooler Dude"},null,null,{"$f":"'Weekly Schedule'!G3","v":"Yates"},null,null,"Team Totals",{"$nulls":4},"Robin Points"]
["Date","Event","Indy","Match","Total","Indy","Match","Total","Indy","Match","Total","Indy","Match","Total","Indy","Match","Total","Indy","Match","Total","Indy","Match",{"$f":"\"-Low\"","v":"-Low"},"Points","Total"]
[{"$f":"'Weekly Schedule'!A4","v":"2016-06-07"},"Robin 1 Week 1",9,9,{"$f":"IF(OR(C4=\"BYE\",C4=\"X\",C4=\"Beer\"),\"\",IF(C4=9999,9999,C4+D4))","v":18},7,12,{"$f":"IF(OR(F4=\"BYE\",F4=\"X\",F4=\"Beer\"),\"\",IF(F4=9999,9999,F4+G4))","v":19},9999,{"$f":"I4","v":9999},{"$f":"IF(OR(I4=\"BYE\",I4=\"X\",I4=\"Beer\"),\"\",IF(I4=9999,9999,I4+J4))","v":9999},11,11,{"$f":"IF(OR(L4=\"BYE\",L4=\"X\",L4=\"Beer\"),\"\",IF(L4=9999,9999,L4+M4))","v":22},9999,{"$f":"O4","v":9999},{"$f":"IF(OR(O4=\"BYE\",O4=\"X\",O4=\"Beer\"),\"\",IF(O4=9999,9999,O4+P4))","v":9999},12,9,{"$f":"IF(OR(R4=\"BYE\",R4=\"X\",R4=\"Beer\"),\"\",IF(R4=9999,9999,R4+S4))","v":21},{"$f":"IF(OR(C4=\"BYE\",C4=9999,C4=\"Beer\",C4=\"X\"),0,C4)+IF(OR(F4=\"BYE\",F4=9999,F4=\"Beer\",F4=\"X\"),0,F4)+IF(OR(I4=\"BYE\",I4=9999,I4=\"Beer\",I4=\"X\"),0,I4)+IF(OR(L4=\"BYE\",L4=9999,L4=\"Beer\",L4=\"X\"),0,L4)+IF(OR(O4=\"BYE\",O4=9999,O4=\"Beer\",O4=\"X\"),0,O4)+IF(OR(R4=\"BYE\",R4=9999,R4=\"Beer\",R4=\"X\"),0,R4)","v":39},{"$f":"IF(OR(D4=\"BYE\",D4=9999,D4=\"Beer\",D4=\"X\"),0,D4)+IF(OR(G4=\"BYE\",G4=9999,G4=\"Beer\",G4=\"X\"),0,G4)+IF(OR(J4=\"BYE\",J4=9999,J4=\"Beer\",J4=\"X\"),0,J4)+IF(OR(M4=\"BYE\",M4=9999,M4=\"Beer\",M4=\"X\"),0,M4)+IF(OR(P4=\"BYE\",P4=9999,P4=\"Beer\",P4=\"X\"),0,P4)+IF(OR(S4=\"BYE\",S4=9999,S4=\"Beer\",S4=\"X\"),0,S4)","v":41},{"$f":"IF(OR(C4=\"X\",C4=\"BYE\",C4=\"Beer\",E4+H4+K4+N4+Q4+T4>3*9999),0,MIN(E4,H4,K4,N4,Q4,T4))","v":18},{"$f":"U4+V4-W4","v":62},{"$f":"X4","v":62},4]
[{"$f":"'Weekly Schedule'!A5","v":"2016-06-14"},"Robin 1 Week 2",4,4,8,9,9,18,5,12,17,9999,{"$f":"L5","v":9999},9999,9999,9999,9999,13,8,21,{"$f":"IF(OR(C5=\"BYE\",C5=9999,C5=\"Beer\",C5=\"X\"),0,C5)+IF(OR(F5=\"BYE\",F5=9999,F5=\"Beer\",F5=\"X\"),0,F5)+IF(OR(I5=\"BYE\",I5=9999,I5=\"Beer\",I5=\"X\"),0,I5)+IF(OR(L5=\"BYE\",L5=9999,L5=\"Beer\",L5=\"X\"),0,L5)+IF(OR(O5=\"BYE\",O5=9999,O5=\"Beer\",O5=\"X\"),0,O5)+IF(OR(R5=\"BYE\",R5=9999,R5=\"Beer\",R5=\"X\"),0,R5)","v":31},33,{"$f":"IF(OR(C5=\"X\",C5=\"BYE\",C5=\"Beer\",E5+H5+K5+N5+Q5+T5>3*9999),0,MIN(E5,H5,K5,N5,Q5,T5))","v":8},{"$f":"U5+V5-W5","v":56},{"$f":"Y4+X5","v":118}]
[{"$f":"'Weekly Schedule'!A6","v":"2016-06-21"},"Robin 1 Week 3",11,10,21,7,9,16,9,9,18,9999,9999,9999,9999,9999,9999,9999,{"$f":"R6","v":9999},9999,27,28,{"$f":"IF(OR(C6=\"X\",C6=\"BYE\",C6=\"Beer\",E6+H6+K6+N6+Q6+T6>3*9999),0,MIN(E6,H6,K6,N6,Q6,T6))","v":0},{"$f":"U6+V6-W6","v":55},{"$f":"Y5+X6","v":173}]
[{"$f":"'Weekly Schedule'!A7","v":"2016-06-28"},"Robin 2 Week 1",9999,{"$f":"C7","v":9999},9999,0,0,0,12,9,21,10,8,18,5,8,13,9999,9999,9999,27,25,{"$f":"IF(OR(C7=\"X\",C7=\"BYE\",C7=\"Beer\",E7+H7+K7+N7+Q7+T7>3*9999),0,MIN(E7,H7,K7,N7,Q7,T7))","v":0},{"$f":"U7+V7-W7","v":52},{"$f":"X7","v":52},4]
[{"$f":"'Weekly Schedule'!A8","v":"2016-07-05"},"Robin 2 Week 2",9,9,18,9999,{"$f":"F8","v":9999},9999,8,12,20,9999,9999,9999,6,6,12,7,10,17,30,37,12,55,{"$f":"X8+Y7","v":107}]
[{"$f":"'Weekly Schedule'!A9","v":"2016-07-12"},"Robin 2 Week 3",9999,9999,9999,9999,9999,9999,7,7,14,16,13,29,12,11,23,12,12,24,47,43,14,76,{"$f":"Y8+X9","v":183}]
[{"$f":"'Weekly Schedule'!A10","v":"2016-07-19"},"Robin 3 Week 1",9999,9999,9999,11,11,22,4,4,8,9999,9999,9999,7,7,14,9,9,18,31,31,8,54,{"$f":"X10","v":54},3]
[{"$f":"'Weekly Schedule'!A11","v":"2016-07-26"},"Robin 3 Week 2",8,8,16,11,8,19,8,9,17,9999,9999,9999,4,6,10,9999,9999,9999,31,31,10,52,{"$f":"Y10+X11","v":106}]
[{"$f":"'Weekly Schedule'!A12","v":"2016-08-02"},"Robin 3 Week 3",9,12,21,9999,{"$f":"F12","v":9999},9999,10,8,18,9999,9999,9999,5,8,13,13,12,25,37,40,{"$f":"IF(OR(C12=\"X\",C12=\"BYE\",C12=\"Beer\",E12+H12+K12+N12+Q12+T12>3*9999),0,MIN(E12,H12,K12,N12,Q12,T12))","v":13},64,{"$f":"Y11+X12","v":170}]
[{"$f":"'Weekly Schedule'!A13","v":"2016-08-09"},"Robin 4 Week 1",{"$f":"'Weekly Schedule'!B13","v":"Bye"},{"$f":"C13","v":"Bye"},"",{"$f":"'Weekly Schedule'!C13","v":"X"},{"$f":"F13","v":"X"},"",{"$f":"'Weekly Schedule'!D13","v":"X"},"X","",{"$f":"'Weekly Schedule'!E13","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!F13","v":"X"},"X","",{"$f":"'Weekly Schedule'!G13","v":"X"},"X","",0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"X13","v":{"$error":"#VALUE!"}}]
[{"$f":"'Weekly Schedule'!A14","v":"2016-08-16"},"Robin 4 Week 2",{"$f":"'Weekly Schedule'!B14","v":"X"},{"$f":"C14","v":"X"},"",{"$f":"'Weekly Schedule'!C14","v":"X"},{"$f":"F14","v":"X"},"",{"$f":"'Weekly Schedule'!D14","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!E14","v":"X"},"X","",{"$f":"'Weekly Schedule'!F14","v":"X"},"X","",{"$f":"'Weekly Schedule'!G14","v":"Bye"},"Bye","",0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Y13+X14","v":{"$error":"#VALUE!"}}]
[{"$f":"'Weekly Schedule'!A15","v":"2016-08-23"},"Robin 4 Week 3",{"$f":"'Weekly Schedule'!B15","v":"X"},"X","",{"$f":"'Weekly Schedule'!C15","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!D15","v":"X"},"X","",{"$f":"'Weekly Schedule'!E15","v":"X"},"X","",{"$f":"'Weekly Schedule'!F15","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!G15","v":"X"},"X","",0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Y14+X15","v":{"$error":"#VALUE!"}}]
[{"$f":"'Weekly Schedule'!A16","v":"2016-08-30"},"Robin 5 Week 1",{"$f":"'Weekly Schedule'!B16","v":"X"},"X","",{"$f":"'Weekly Schedule'!C16","v":"X"},"X","",{"$f":"'Weekly Schedule'!D16","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!E16","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!F16","v":"X"},"X","",{"$f":"'Weekly Schedule'!G16","v":"X"},"X","",0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"X16","v":{"$error":"#VALUE!"}}]
[{"$f":"'Weekly Schedule'!A17","v":"2016-09-06"},"Robin 5 Week 2",{"$f":"'Weekly Schedule'!B17","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!C17","v":"X"},"X","",{"$f":"'Weekly Schedule'!D17","v":"X"},"X","",{"$f":"'Weekly Schedule'!E17","v":"X"},"X","",{"$f":"'Weekly Schedule'!F17","v":"X"},"X","",{"$f":"'Weekly Schedule'!G17","v":"Bye"},"Bye","",0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Y16+X17","v":{"$error":"#VALUE!"}}]
[{"$f":"'Weekly Schedule'!A18","v":"2016-09-13"},"Robin 5 Week 3",{"$f":"'Weekly Schedule'!B18","v":"X"},"X","",{"$f":"'Weekly Schedule'!C18","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!D18","v":"X"},"X","",{"$f":"'Weekly Schedule'!E18","v":"X"},"X","",{"$f":"'Weekly Schedule'!F18","v":"Bye"},"Bye","",{"$f":"'Weekly Schedule'!G18","v":"X"},"X","",{"$f":"IF(OR(C18=\"BYE\",C18=9999,C18=\"Beer\",C18=\"X\"),0,C18)+IF(OR(F18=\"BYE\",F18=9999,F18=\"Beer\",F18=\"X\"),0,F18)+IF(OR(I18=\"BYE\",I18=9999,I18=\"Beer\",I18=\"X\"),0,I18)+IF(OR(L18=\"BYE\",L18=9999,L18=\"Beer\",L18=\"X\"),0,L18)+IF(OR(O18=\"BYE\",O18=9999,O18=\"Beer\",O18=\"X\"),0,O18)+IF(OR(R18=\"BYE\",R18=9999,R18=\"Beer\",R18=\"X\"),0,R18)","v":0},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Y17+X18","v":{"$error":"#VALUE!"}}]
[{"$f":"'Weekly Schedule'!A19","v":"2016-05-21"},"Season Start Tourney",17,0,17,22,0,22,0,0,0,23,0,23,14,0,14,20,0,20,96,0,{"$f":"SMALL(SeasonStartPts,1)+SMALL(SeasonStartPts,2)","v":14},{"$f":"U19+V19-W19","v":82},{"$f":"X19","v":82},4]
[{"$f":"'Weekly Schedule'!A20","v":"2016-07-16"},"Mid-Season Tourney",11,9,20,9,8,17,6,16,22,11,7,18,10,8,18,7,11,18,54,59,{"$f":"SMALL(MidSeasonPts,1)+SMALL(MidSeasonPts,2)","v":35},{"$f":"U20+V20-W20","v":78},{"$f":"X20","v":78},3]
[{"$f":"'Weekly Schedule'!A21","v":"2016-09-24"},"Season End Toureney",{"$f":"'Weekly Schedule'!B21","v":"X"},{"$f":"C21","v":"X"},"",{"$f":"'Weekly Schedule'!C21","v":"X"},{"$f":"F21","v":"X"},"",{"$f":"'Weekly Schedule'!D21","v":"X"},{"$f":"I21","v":"X"},"",{"$f":"'Weekly Schedule'!E21","v":"X"},{"$f":"L21","v":"X"},"",{"$f":"'Weekly Schedule'!F21","v":"X"},{"$f":"O21","v":"X"},"",{"$f":"'Weekly Schedule'!G21","v":"X"},{"$f":"R21","v":"X"},"",0,0,{"$f":"SMALL(SeasonEndPts,1)+SMALL(SeasonEndPts,2)","v":{"$error":"#NUM!"}},{"$f":"U21+V21-W21","v":{"$error":"#NUM!"}},{"$f":"X21","v":{"$error":"#NUM!"}}]
["Off",null,{"$f":"COUNTIF(C4:C18,9999)+COUNTIF(C4:C18,\"BYE\")","v":5},null,null,{"$f":"COUNTIF(F4:F18,9999)+COUNTIF(F4:F18,\"BYE\")","v":5},null,null,{"$f":"COUNTIF(I4:I18,9999)+COUNTIF(I4:I18,\"BYE\")","v":3},null,null,{"$f":"COUNTIF(L4:L18,9999)+COUNTIF(L4:L18,\"BYE\")","v":8},null,null,{"$f":"COUNTIF(O4:O18,9999)+COUNTIF(O4:O18,\"BYE\")","v":5},null,null,{"$f":"COUNTIF(R4:R18,9999)+COUNTIF(R4:R18,\"BYE\")","v":5},{"$nulls":5},"Total Robin Points",null,{"$f":"SUM(Z4:Z21)","v":18}]
[">20 pts",{"$nulls":3},{"$f":"COUNTIF(E4:E21,\">20\")-COUNTIF(E4:E21,\"=9999\")","v":2},null,null,{"$f":"COUNTIF(H4:H21,\">20\")-COUNTIF(H4:H21,\"=9999\")","v":2},null,null,{"$f":"COUNTIF(K4:K21,\">20\")-COUNTIF(K4:K21,\"=9999\")","v":2},null,null,{"$f":"COUNTIF(N4:N21,\">20\")-COUNTIF(N4:N21,\"=9999\")","v":3},null,null,{"$f":"COUNTIF(Q4:Q21,\">20\")-COUNTIF(Q4:Q21,\"=9999\")","v":1},null,null,{"$f":"COUNTIF(T4:T21,\">20\")-COUNTIF(T4:T21,\"=9999\")","v":4}]
["Average Points",{"$nulls":3},{"$f":"(SUM(E4:E21)-COUNTIF(E4:E21,9999)*9999)/(18-COUNTIF(E4:E21,9999)-COUNTIF(E4:E21,\"\"))","v":{"v":17.375,"d":"17.4"}},null,null,{"$f":"(SUM(H4:H21)-COUNTIF(H4:H21,9999)*9999)/(18-COUNTIF(H4:H21,9999)-COUNTIF(H4:H21,\"\"))","v":{"v":16.625,"d":"16.6"}},null,null,{"$f":"(SUM(K4:K21)-COUNTIF(K4:K21,9999)*9999)/(18-COUNTIF(K4:K21,9999)-COUNTIF(K4:K21,\"\"))","v":15.5},null,null,{"$f":"(SUM(N4:N21)-COUNTIF(N4:N21,9999)*9999)/(18-COUNTIF(N4:N21,9999)-COUNTIF(N4:N21,\"\"))","v":{"v":22,"d":"22.0"}},null,null,{"$f":"(SUM(Q4:Q21)-COUNTIF(Q4:Q21,9999)*9999)/(18-COUNTIF(Q4:Q21,9999)-COUNTIF(Q4:Q21,\"\"))","v":{"v":14.625,"d":"14.6"}},null,null,{"$f":"(SUM(T4:T21)-COUNTIF(T4:T21,9999)*9999)/(18-COUNTIF(T4:T21,9999)-COUNTIF(T4:T21,\"\"))","v":20.5}]
[]
[null,null,"X",{"$f":"'Weekly Schedule'!C24","v":"- Scheduled to Play"}]
[null,null,"Beer",{"$f":"'Weekly Schedule'!C25","v":"- Scheduled to Play AND Bring the Beer (Tourneys are BYO)"}]
[null,null,"Bye",{"$f":"'Weekly Schedule'!C26","v":"- Not Scheduled to Play"}]
[null,null,9999,{"$f":"\"- Scheduled as a Bye and didn't play (cell contains 9999 for calculation purposes)\"","v":"- Scheduled as a Bye and didn't play (cell contains 9999 for calculation purposes)"}]
[null,null,0,{"$f":"\"- Scheduled to play and didn't/couldn't get someone to cover\"","v":"- Scheduled to play and didn't/couldn't get someone to cover"}]
[null,null,{"$f":"'Weekly Schedule'!A27","v":"Opening Tourney - Sat 21 May 2016"}]
[null,null,{"$f":"'Weekly Schedule'!A28","v":"Mid-Season Tourney - Sat 16 July 2016"}]
[null,null,{"$f":"'Weekly Schedule'!A29","v":"Final Tourney - Sat 24 September 2016"}]
[]
[null,"At the End of R5W3"]
[null,"Team","Pts","Rank"]
[null,"Putt-Putts"]
[null,"Happy Gilmores"]
[null,"Deep Ruff"]
[null,"Stiff Shafts"]
[null,"Big Knockers"]
[null,"12 Ounce Handicap"]
[null,"Greenies"]
[null,"Tuff Links"]
[null,"A Flights"]
[null,"Golf Knights"]
[null,"Lonesome Duffers"]
[null,"Bogie Bunch"]
[null,"Stress Relief"]
[null,"Crooked Shanks"]
[null,"Rusty Irons"]

{"sheet":"AGL Teams","index":6,"n_rows":17,"n_cols":15,"rows_kept":17}
["TeamID","Team Name","Team Short Name","TeamID\n(for lookups by Team Name or Team Short Name)","Captain",1,2,3,4,5,6,7,8,9,10]
[1,"Putt-Putts","Putts",1,"2006_007","2006_007","2006_014","2006_035","2015_005","2006_075","2006_091"]
[2,"Tuff Links","Links",2,"2006_053","2006_053","2006_022","2006_040","2006_077","2006_082","2006_088"]
[3,"Hack Attack","Attacks",3,"2014_006","2014_006","2014_005","2014_009","2015_002","2014_010","2015_004"]
[4,"A Flights","Flights",4,"2012_004","2012_004","2007_001","2013_006","2016_001","2014_001","2012_007"]
[5,"Big Knockers","Knockers",5,"2006_041","2006_041","2006_025","2006_029","2008_002","2006_058","2011_007"]
[6,"Greenies","Greenies",6,"2006_012","2006_012","2016_008","2016_010","2016_009","2016_012","2016_011"]
[7,"Happy Gilmores","Gilmores",7,"2006_076","2006_076","2006_059","2006_060","2006_063","2010_003","2006_067"]
[8,"Deep Ruff","Ruff",8,"2006_083","2006_083","2006_001","2006_036","2015_014","2006_052","2010_008"]
[9,"Stiff Shafts","Shafts",9,"2006_033","2006_033","2006_006","2015_012","2015_007","2016_013","2006_081"]
[10,"Rusty Irons","Irons",10,"2006_054","2006_054","2006_008","2006_013","2015_010","2006_069","2015_011"]
[11,"12 Ounce Handicap","12 Ouncers",11,"2006_070","2006_070","2006_016","2013_009","2014_011","2006_062","2015_013"]
[12,"Bogie Bunch","Bogies",12,"2006_086","2006_086","2011_001","2006_031","2016_002","2016_003","2010_001"]
[13,"Crooked Shanks","Shanks",13,"2011_004","2011_004","2016_007","2013_003","2016_006","2015_009","2006_087"]
[14,"Bogey Machine","Machine",14,"2006_084","2006_084","2016_005","2010_009","2006_038","2006_064","2016_004"]
[15,"Stress Relief","Relief",15,"2006_090","2006_090","2006_015","2006_032","2006_078","2006_079","2015_003"]
[16,"Bye","Bye",{"$f":"A17","v":16}]

{"sheet":"12OunceHcapRoster","index":7,"n_rows":59,"n_cols":65,"rows_kept":59,"merged":[[26,8,26,11],[27,1,27,3]]}
["AGLID","SeasonID","Playing Status","New Or Returning Player","Player Info Status","Last Name","First Name","MI","Suffix","Full Name","Nickname","Squaw Status","SquawID","Employee Status","EmployeeID","Work Ph","Home Ph","Cell Ph","Pager","Other Ph","Team ID","Team Name","Captain Or Player","Playing Tees","Male Or Female","Email","Other Email","AGLID","EHS","Index","2013 Cash","2013 Certificates","2013 Totals"]
["2006_062",2016,"Active","Returning","Current","Miley","David","G",null,"David Miley","Smiley","Non-Member",null,"Retiree",119951,"??????????","??????????",8173196593,"??????????","??????????",10,"12 Ounce Handicap","Captain","Middle","Male","david@TheMileys.net",null,{"$f":"A2","v":"2006_062"}]
["2006_016",2016,"Active","Returning","Current","Cox","Dewayne",null,null,"Dewayne Cox","Laces","Commissioner","C67","Retiree",null,"??????????","??????????",8177988872,"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male","dewaynecox@uwmail.com",null,"2006_016"]
["2013_009",2016,"Active","Returning","Current","Holt","Jim","I",null,"Jim Holt","BB","Member","J21","Employee",null,8177634228,8174418591,8173664958,"??????????",8177398912,10,"12 Ounce Handicap","Player","Middle","Male","jim.i.holt@lmco.com",null,"2013_009",14]
["2014_011",2016,"Active","Returning","Current","Lewis","Josh",null,null,"Josh Lewis",null,"Non-Member",null,"Employee",null,8179353370,null,null,"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male","joshua.b.lewis@lmco.com",null,"2014_011"]
["2006_070",2016,"Active","Returning","Current","Pruitt","Bruce","E",null,"Bruce Pruitt","Cooler Dude","Non-Member",null,"Employee",115759,8179353290,8178619037,8173663002,"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male","bruce.e.pruitt@lmco.com","brucepruitt@sbcglobal.net","2006_070"]
["2015_013",2016,"Active","Returning","Current","Yates","Rowdy",null,null,"Rowdy Yates",null,"Non-Member",null,"Employee",null,"??????????","??????????","??????????","??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male",null,null,"2015_013"]
[]
[]
[]
["AGLID","SeasonID","Playing Status","New Or Returning Player","Player Info Status","Last Name","First Name","MI","Suffix","Full Name","Nickname","Squaw Status","SquawID","Employee Status","EmployeeID","Work Ph","Home Ph","Cell Ph","Pager","Other Ph","Team ID","Team Name","Captain Or Player","Playing Tees","Male Or Female","Email","Other Email","AGLID","EHS","Index","2013 Cash","2013 Certificates","2013 Totals"]
["2006_062",null,"Active","Returning","Unchanged","Miley","David",null,null,{"$f":"G12&\" \"&F12","v":"David Miley"},"Smiley","Non-Member",null,"Employee",119951,8179364333,8177321066,8173196593,null,null,10,"12 Ounce Handicap","Captain","Middle","Male","david.g.miley@lmco.com",null,{"$f":"A12","v":"2006_062"}]
["2006_016",null,"Active","Returning","Unchanged","Cox","Dewayne",null,null,"Dewayne Cox","Laces","Commissioner","C67","Employee",null,8179354579,{"$nulls":4},10,"12 Ounce Handicap","Player","Middle","Male","Dewayne.d.cox@lmco.com",null,"2006_016"]
["2013_009",null,"Active","Returning","Unchanged","Holt","Jim","I",null,"Jim Holt",null,"Non-Member",null,"Employee",null,8177634228,8174418591,8173664958,"??????????",8177398912,{"$f":"VLOOKUP(V14,TeamNames,3,FALSE)","v":{"$error":"#REF!"}},"12 Ounce Handicap","Player","Middle","Male",null,null,"2013_009",14]
["2011_011",null,"Active","Returning","Unchanged","Johnson","Vernon",null,null,"Vernon Johnson",null,"Non-Member",null,"Employee",{"$nulls":4},"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male",null,null,"2011_011"]
["2013_010",null,"Active","Returning","Deleted","Pereira","Gary",null,null,"Gary Pereira",null,"Member","GHIN0302460","Employee",{"$nulls":4},"??????????",8177398912,{"$f":"VLOOKUP(V16,TeamNames,3,FALSE)","v":{"$error":"#REF!"}},"12 Ounce Handicap","Player","Middle","Male",null,null,"2013_010"]
["2006_070",null,"Active","Returning","Unchanged","Pruitt","Bruce","E",null,"Bruce Pruitt","Cooler Dude","Non-Member",null,"Employee",115759,8179353290,8178619037,8173663002,"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male","bruce.e.pruitt@lmco.com","brucepruitt@sbcglobal.net","2006_070"]
["2014_011",null,"Active","New","Unchanged","Lewis","Josh",null,null,"Josh Lewis",null,"Non-Member",null,"Employee",null,8179353370,null,null,"??????????","??????????",{"$f":"VLOOKUP(V18,TeamNames,3,FALSE)","v":{"$error":"#REF!"}},"12 Ounce Handicap","Player","Middle","Male","joshua.b.lewis@lmco.com",null,"2014_011"]
["2011_009",null,"Inactive","New","Deleted","Fahrney","Larry",null,null,"Larry Fahrney",null,"Non-Member",null,"Employee",{"$nulls":4},"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male",null,null,"2011_009"]
["2006_074",null,"Inactive","Returning","Deleted","Saunier","Paul",null,null,"Paul Saunier","AFLAC","Non-Member",null,"Employee",124936,8175555587,8175013424,8175013424,"??????????",8173194366,10,"12 Ounce Handicap","Player","Middle","Male","dwight.p.saunier@lmco.com",null,"2006_074"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},"Phones"]
[null,"Player",null,null,"Nickname","Squaw Creek Member","Starting Handicap (SC Index)","On Handicap Restriction Thru","Work","Home","Page/Other","Cell","Employee ID","Paid!"]
["2006_062","David","G","Miley","Smiley","Employee","Established Last Season",{"$f":"'EHS Restriction'!B23","v":"Not On EHS"},8176558051,8177321066,8176947499,8173196593,119951]
["2006_016","Dewayne",null,"Cox","RED","C67","Established Last Season",{"$f":"'EHS Restriction'!D23","v":{"$error":"#N/A"}},54579,"(817)613-8011","None","None",271040]
["2011_009","Larry","W","Fahrney",null,"Employee","Index",{"$f":"'EHS Restriction'!F23","v":"Not On EHS"},8177774915,8179958642,8174582198]
["2011_011","Vernon",null,"Johnson",null,null,"EHS",{"$f":"'EHS Restriction'!C23","v":"Not On EHS"},8176558017,"(817)416-9889","(800)497-5382 (4975382@skytel.com)",8178790021,111444,"Yes"]
["2006_070","Bruce",null,"Pruitt","Cooler Dude","Employee","Established Last Season",{"$f":"'EHS Restriction'!G23","v":"Not On EHS"},8179353290,"(817)861-9037","None",8173723421,115759]
["2006_074","Paul",null,"Saunier","AFLAC","Employee","Established Last Season",{"$f":"'EHS Restriction'!E23","v":{"$error":"#N/A"}},55587,"(817)441-7708","None","None",124936,{"$nulls":15},"EHS","Index"]
["AGLID","SeasonID","Playing Status","New Or Returning Player","Player Info Status","Last Name","First Name","MI","Suffix","Full Name","Nickname","Squaw Status","SquawID","Employee Status","EmployeeID","Work Ph","Home Ph","Cell Ph","Pager","Other Ph","Team ID","Team Name","Captain Or Player","Playing Tees","Playing Tees","Male Or Female","Email","AGLID"]
["2006_062",null,"Active","Returning","Unchanged","Miley","David",null,null,{"$f":"G36&\" \"&F36","v":"David Miley"},"sMiley","Non-Member",null,"Employee",119951,8179364333,8177321066,8173196593,null,8174807410,"TeamID_04",{"$f":"IF($U36=\"\",\"\",VLOOKUP($U36,TeamRoster,3,FALSE))","v":"12 Ounce Handicap"},"Captain","Middle","Middle","Male","david.g.miley@lmco.com",{"$f":"A36","v":"2006_062"}]
["2006_016",null,"Active","Returning","Unchanged","Cox","Dewayne",null,null,"Dewayne Cox","Laces","Commissioner","C67","Employee",null,8179354579,8176138011,{"$nulls":3},"TeamID_04","12 Ounce Handicap","Player","Middle","Middle","Male","Dewayne.d.cox@lmco.com","2006_016"]
["2006_042",null,"Active","Returning","Unchanged","Kim","Kyung",null,null,"Kyung Kim","KK","Member","K12","Employee",111444,8179354394,8174169889,8178790021,null,"??????????","TeamID_04","12 Ounce Handicap","Player","Middle","Middle","Male","kyung.k.kim@lmco.com","2006_042"]
["2009_001","Add","Active","Returning","AddedAndChanged","Maurer","Eric","R",null,"Eric Maurer","Gator","Non-Member",null,"Employee",139578,8179355705,8174488656,8177263164,"??????????","??????????","TeamID_04","12 Ounce Handicap","Player","Middle","Middle","Male","eric.r.maurer@lmco.com","2009_001"]
["2006_070",null,"Active","Returning","Unchanged","Pruitt","Bruce","E",null,"Bruce Pruitt","CoolerDude","Non-Member",null,"Employee",115759,8179353290,8178619037,8173663002,"??????????","??????????","TeamID_04","12 Ounce Handicap","Player","Middle","Middle","Male","bruce.e.pruitt@lmco.com","2006_070"]
["2006_074",null,"Active","Returning","Unchanged","Saunier","Paul",null,null,"Paul Saunier","AFLAC","Non-Member",null,"Employee",124936,8179355587,null,8175013424,"??????????","??????????","TeamID_04","12 Ounce Handicap","Player","Middle","Middle","Male","dwight.p.saunier@lmco.com","2006_074"]
[{"$nulls":30},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},0,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#REF!"},"David Miley","12 Ounce Handicap",0,0,0,0,0,{"v":23.1,"d":"$23.10"}]
["2006_062",null,"Active","Returning","Unchanged","Miley","David",null,null,"David Miley","PaperCup","Non-Member",null,"Employee",119951,8179364333,8177321066,8173196593,null,null,15,"Captain","Middle","Male","Male","david.g.miley@lmco.com",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},0,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#REF!"},"Dewayne Cox","12 Ounce Handicap",0,0,0,0,0,0]
["2006_016",null,"Active","Returning","Unchanged","Cox","Dewayne",null,null,"Dewayne Cox","Laces","Commissioner","C67","Employee",null,8179354579,{"$nulls":4},15,"Player","Middle","Male","Male","Dewayne.d.cox@lmco.com",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},0,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#REF!"},"Larry Fahrney","12 Ounce Handicap",0,0,0,0,0,0]
["2011_009",null,"Active","New","Added","Fahrney","Larry",null,null,"Larry Fahrney",null,"Non-Member",null,"Employee",{"$nulls":4},"??????????","??????????",15,"Player","Middle","Male","Male",{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},0,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#REF!"},"Kyung Kim","12 Ounce Handicap",0,0,0,0,0,0]
["2006_042",null,"Active","Returning","Unchanged","Kim","Kyung",null,null,"Kyung Kim","KK","Member","K12","Employee",111444,8179354394,8174169889,8177060606,8004975382,"??????????",15,"Player","Middle","Male","Male","kyung.k.kim@lmco.com","lmee84@msn.com",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},0,0,0,0,{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#REF!"},"Bruce Pruitt","12 Ounce Handicap",0,0,0,0,0,0]
["2006_070",null,"Active","Returning","Unchanged","Pruitt","Bruce","E",null,"Bruce Pruitt","CoolerDude","Non-Member",null,"Employee",115759,8179353290,8178619037,8173663002,"??????????","??????????",15,"Player","Middle","Male","Male","bruce.e.pruitt@lmco.com","brucepruitt@sbcglobal.net",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},0,0,0,{"v":10,"d":"$10.00"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#REF!"},"Paul Saunier","12 Ounce Handicap",0,0,0,0,0,0]
["2006_074",null,"Active","Returning","Unchanged","Saunier","Paul",null,null,"Paul Saunier","AFLAC","Non-Member",null,"Employee",124936,8179355587,8174417708,8175019546,"??????????","??????????",15,"Player","Middle","Male","Male","dwight.p.saunier@lmco.com"]
[]
[2013]
["AGLID","SeasonID","Playing Status","New Or Returning Player","Player Info Status","Last Name","First Name","MI","Suffix","Full Name","Nickname","Squaw Status","SquawID","Employee Status","EmployeeID","Work Ph","Home Ph","Cell Ph","Pager","Other Ph","Team ID","Team Name","Captain Or Player","Playing Tees","Male Or Female","Email","Other Email","AGLID","EHS","Index","2013 Cash","2013 Certificates","2013 Totals"]
["2006_062",null,"Active","Returning","Unchanged","Miley","David",null,null,{"$f":"G52&\" \"&F52","v":"David Miley"},"Smiley","Non-Member",null,"Employee",119951,8179364333,8177321066,8173196593,null,null,10,"12 Ounce Handicap","Captain","Middle","Male","david.g.miley@lmco.com",null,{"$f":"A52","v":"2006_062"}]
["2006_016",null,"Active","Returning","Unchanged","Cox","Dewayne",null,null,"Dewayne Cox","Laces","Commissioner","C67","Employee",null,8179354579,{"$nulls":4},10,"12 Ounce Handicap","Player","Middle","Male","Dewayne.d.cox@lmco.com",null,"2006_016"]
["2013_009",null,"Active","Returning","Unchanged","Holt","Jim","I",null,"Jim Holt",null,"Non-Member",null,"Employee",null,8177634228,8174418591,8173664958,"??????????",8177398912,{"$f":"VLOOKUP(V54,TeamNames,3,FALSE)","v":{"$error":"#REF!"}},"12 Ounce Handicap","Player","Middle","Male",null,null,"2013_009",14]
["2011_011",null,"Active","New","Added","Johnson","Vernon",null,null,"Vernon Johnson",null,"Non-Member",null,"Employee",{"$nulls":4},"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male",null,null,"2011_011"]
["2013_010",null,"Active","New","Added","Pereira","Gary",null,null,"Gary Pereira",null,"Member","GHIN0302460","Employee",{"$nulls":4},"??????????",8177398912,{"$f":"VLOOKUP(V56,TeamNames,3,FALSE)","v":{"$error":"#REF!"}},"12 Ounce Handicap","Player","Middle","Male",null,null,"2013_010"]
["2006_070",null,"Active","Returning","Unchanged","Pruitt","Bruce","E",null,"Bruce Pruitt","Cooler Dude","Non-Member",null,"Employee",115759,8179353290,8178619037,8173663002,"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male","bruce.e.pruitt@lmco.com","brucepruitt@sbcglobal.net","2006_070"]
["2011_009",null,"Inactive","New","Added","Fahrney","Larry",null,null,"Larry Fahrney",null,"Non-Member",null,"Employee",{"$nulls":4},"??????????","??????????",10,"12 Ounce Handicap","Player","Middle","Male",null,null,"2011_009"]
["2006_074",null,"Inactive","Returning","Unchanged","Saunier","Paul",null,null,"Paul Saunier","AFLAC","Non-Member",null,"Employee",124936,8175555587,8175013424,8175013424,"??????????",8173194366,10,"12 Ounce Handicap","Player","Middle","Male","dwight.p.saunier@lmco.com",null,"2006_074"]

{"sheet":"EHS Restriction","index":8,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,10]]}
["Slice of Life - 2002 EHS Schedule"]
["Week",{"$f":"'12OunceHcapRoster'!B29&\" \"&'12OunceHcapRoster'!D29","v":"David Miley"},{"$f":"'12OunceHcapRoster'!B30&\" \"&'12OunceHcapRoster'!D30","v":"Dewayne Cox"},{"$f":"'12OunceHcapRoster'!B31&\" \"&'12OunceHcapRoster'!D31","v":"Larry Fahrney"},{"$f":"'12OunceHcapRoster'!B32&\" \"&'12OunceHcapRoster'!D32","v":"Vernon Johnson"},{"$f":"'12OunceHcapRoster'!B33&\" \"&'12OunceHcapRoster'!D33","v":"Bruce Pruitt"},{"$f":"'12OunceHcapRoster'!B34&\" \"&'12OunceHcapRoster'!D34","v":"Paul Saunier"},null,"EHS Restriction"]
["2002-06-18",{"$f":"IF(VLOOKUP($A3,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A3,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A3,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A3,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A3,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A3,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1)","v":{"$error":"#N/A"}},"No of Weeks",5]
[{"$f":"A3+7","v":"2002-06-25"},{"$f":"IF(VLOOKUP($A4,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B3))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A4,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C3))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A4,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D3))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A4,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E3))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A4,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F3))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A4,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G3))","v":{"$error":"#N/A"}}]
["2002-07-02",{"$f":"IF(VLOOKUP($A5,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B4))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A5,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C4))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A5,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D4))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A5,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E4))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A5,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F4))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A5,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G4))","v":{"$error":"#N/A"}}]
["2002-07-09",{"$f":"IF(VLOOKUP($A6,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B5))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A6,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C5))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A6,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D5))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A6,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E5))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A6,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F5))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A6,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G5))","v":{"$error":"#N/A"}}]
["2002-07-16",{"$f":"IF(VLOOKUP($A7,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B6))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A7,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C6))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A7,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D6))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A7,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E6))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A7,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F6))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A7,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G6))","v":{"$error":"#N/A"}}]
["2002-07-23",{"$f":"IF(VLOOKUP($A8,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B7))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A8,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C7))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A8,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D7))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A8,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E7))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A8,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F7))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A8,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G7))","v":{"$error":"#N/A"}}]
["2002-07-30",{"$f":"IF(VLOOKUP($A9,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B8))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A9,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C8))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A9,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D8))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A9,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E8))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A9,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F8))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A9,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G8))","v":{"$error":"#N/A"}}]
["2002-08-06",{"$f":"IF(VLOOKUP($A10,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B9))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A10,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C9))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A10,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D9))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A10,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E9))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A10,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F9))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A10,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G9))","v":{"$error":"#N/A"}}]
[{"$f":"'Weekly Schedule'!A20","v":"2016-07-16"},{"$f":"IF(VLOOKUP($A11,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B10))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A11,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C10))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A11,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D10))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A11,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E10))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A11,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F10))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A11,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G10))","v":{"$error":"#N/A"}},"Mid-Season Tourney (Front)"]
[{"$f":"'Weekly Schedule'!A20","v":"2016-07-16"},{"$f":"IF(VLOOKUP($A12,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B11))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A12,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C11))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A12,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D11))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A12,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E11))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A12,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F11))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A12,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G11))","v":{"$error":"#N/A"}},"Mid-Season Tourney (Back)"]
[{"$f":"A10+7","v":"2002-08-13"},{"$f":"IF(VLOOKUP($A13,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B12))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A13,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C12))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A13,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D12))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A13,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E12))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A13,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F12))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A13,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G12))","v":{"$error":"#N/A"}}]
["2002-08-20",{"$f":"IF(VLOOKUP($A14,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B13))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A14,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C13))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A14,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D13))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A14,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E13))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A14,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F13))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A14,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G13))","v":{"$error":"#N/A"}}]
["2002-08-27",{"$f":"IF(VLOOKUP($A15,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B14))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A15,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C14))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A15,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D14))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A15,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E14))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A15,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F14))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A15,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G14))","v":{"$error":"#N/A"}}]
["2002-09-03",{"$f":"IF(VLOOKUP($A16,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B15))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A16,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C15))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A16,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D15))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A16,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E15))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A16,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F15))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A16,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G15))","v":{"$error":"#N/A"}}]
["2002-09-10",{"$f":"IF(VLOOKUP($A17,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B16))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A17,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C16))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A17,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D16))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A17,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E16))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A17,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F16))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A17,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G16))","v":{"$error":"#N/A"}}]
["2002-09-17",{"$f":"IF(VLOOKUP($A18,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B17))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A18,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C17))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A18,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D17))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A18,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E17))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A18,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F17))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A18,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G17))","v":{"$error":"#N/A"}}]
["2002-09-24",{"$f":"IF(VLOOKUP($A19,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B18))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A19,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C18))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A19,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D18))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A19,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E18))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A19,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F18))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A19,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G18))","v":{"$error":"#N/A"}}]
[{"$f":"'Weekly Schedule'!A21","v":"2016-09-24"},{"$f":"IF(VLOOKUP($A20,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B19))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A20,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C19))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A20,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D19))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A20,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E19))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A20,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F19))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A20,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G19))","v":{"$error":"#N/A"}},"Final Tourney (Front)"]
[{"$f":"'Weekly Schedule'!A21","v":"2016-09-24"},{"$f":"IF(VLOOKUP($A21,'Weekly Schedule'!$A$4:$G$21,1+B$24,FALSE)=\"BYE\",\"BYE\",1+MAX(B$3:B20))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A21,'Weekly Schedule'!$A$4:$G$21,1+C$24,FALSE)=\"BYE\",\"BYE\",1+MAX(C$3:C20))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A21,'Weekly Schedule'!$A$4:$G$21,1+D$24,FALSE)=\"BYE\",\"BYE\",1+MAX(D$3:D20))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A21,'Weekly Schedule'!$A$4:$G$21,1+E$24,FALSE)=\"BYE\",\"BYE\",1+MAX(E$3:E20))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A21,'Weekly Schedule'!$A$4:$G$21,1+F$24,FALSE)=\"BYE\",\"BYE\",1+MAX(F$3:F20))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($A21,'Weekly Schedule'!$A$4:$G$21,1+G$24,FALSE)=\"BYE\",\"BYE\",1+MAX(G$3:G20))","v":{"$error":"#N/A"}},"Final Tourney (Back)"]
["Scheduled or Actual Bye",{"$f":"COUNTIF(B$3:B$21,RIGHT($A22,3))","v":0},0,0,0,0,0]
["On EHS Restriction Thru",{"$f":"IF('12OunceHcapRoster'!G29=\"Established Last Season\",\"Not On EHS\",INDIRECT(ADDRESS(MATCH(SMALL(B3:B21,$I$3),B3:B21,0)+2,1)))","v":"Not On EHS"},{"$f":"IF('12OunceHcapRoster'!G30=\"Established Last Season\",\"Not On EHS\",INDIRECT(ADDRESS(MATCH(SMALL(C3:C21,$I$3),C3:C21,0)+2,1)))","v":"Not On EHS"},{"$f":"IF('12OunceHcapRoster'!G31=\"Established Last Season\",\"Not On EHS\",INDIRECT(ADDRESS(MATCH(SMALL(D3:D21,$I$3),D3:D21,0)+2,1)))","v":{"$error":"#N/A"}},{"$f":"IF('12OunceHcapRoster'!G32=\"Established Last Season\",\"Not On EHS\",INDIRECT(ADDRESS(MATCH(SMALL(E3:E21,$I$3),E3:E21,0)+2,1)))","v":{"$error":"#N/A"}},{"$f":"IF('12OunceHcapRoster'!G33=\"Established Last Season\",\"Not On EHS\",INDIRECT(ADDRESS(MATCH(SMALL(F3:F21,$I$3),F3:F21,0)+2,1)))","v":"Not On EHS"},{"$f":"IF('12OunceHcapRoster'!G34=\"Established Last Season\",\"Not On EHS\",INDIRECT(ADDRESS(MATCH(SMALL(G3:G21,$I$3),G3:G21,0)+2,1)))","v":"Not On EHS"}]
[null,1,2,3,4,5,6]
[]
[null,"BYE",{"$f":"\"- Not Scheduled to Play\"","v":"- Not Scheduled to Play"}]