{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Scores","Varsity","JV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"1904"}

{"sheet":"Scores","index":0,"n_rows":24,"n_cols":24,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,6,4,10],[0,12,2,12],[3,12,5,12],[9,1,9,8],[9,13,9,20],[0,1,0,10],[1,1,1,10],[2,1,2,10],[3,1,3,10],[0,13,0,22],[1,13,1,22],[2,13,2,22],[3,13,3,22],[4,13,4,22],[5,13,5,22],[4,1,4,5]]}
["HOME TEAM:","Kimberly",null,null,null,null,null,null,null,null,null,null,"COMMENTS:"]
["AWAY TEAM:","Appleton North"]
[]
["COACHES:",null,null,null,null,null,null,null,null,null,null,null,"CONDITIONS:"]
["DATE/SITE:","2023-04-25",null,null,null,null,"Reid"]
[]
["Holes:",1,2,3,4,5,6,7,8,9,null,null,"Holes:",1,2,3,4,5,6,7,8,9]
["Par:",5,3,4,3,4,3,5,4,4,35,null,"Par:",5,3,4,3,4,3,5,4,4,35]
[]
["TEAM: ","Kimberly",null,null,null,null,null,null,null,null,"TOTAL",null,"TEAM: ","Appleton North",null,null,null,null,null,null,null,null,"TOTAL"]
["Aiden Cudney",4,3,3,3,5,3,4,4,4,{"$f":"SUM(B11:J11)","v":33},null,"Rasmus Madsen",5,5,3,3,5,3,5,4,5,{"$f":"SUM(N11:V11)","v":38}]
["Chance Rill",5,3,3,3,6,3,4,4,5,{"$f":"SUM(B12:J12)","v":36},null,"Drew Rudolf",5,4,4,4,5,3,4,3,5,{"$f":"SUM(N12:V12)","v":37}]
["Kade Dunham",4,3,5,3,6,3,5,4,4,{"$f":"SUM(B13:J13)","v":37},null,"Kyle Schabo",6,3,4,3,5,2,5,4,5,{"$f":"SUM(N13:V13)","v":37}]
["Trey Vanevenhoven",5,5,5,3,6,4,5,5,4,{"$f":"SUM(B14:J14)","v":42},null,"Dane Heindel",5,4,4,4,5,3,5,4,4,{"$f":"SUM(N14:V14)","v":38}]
["Riley Schmidt",5,3,5,3,5,3,5,4,4,{"$f":"SUM(B15:J15)","v":37},null,"Jon Huenink",6,5,3,6,4,4,6,4,5,{"$f":"SUM(N15:V15)","v":43}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K15)-MAX(K11:K15)","v":143},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W11:W15)-MAX(W11:W15)","v":150}]
["Wyatt Schmidt",5,5,5,3,7,4,6,5,4,{"$f":"SUM(B17:J17)","v":44},{"$f":"RANK(K17,$K$17:$K$23,1)","v":2},"Matthew Contrees",5,6,5,5,5,4,6,5,5,{"$f":"SUM(N17:V17)","v":46},{"$f":"RANK(W17,$W$17:$W$23,1)","v":1}]
["Peter Van Grinsven",5,4,5,4,7,4,4,4,4,{"$f":"SUM(B18:J18)","v":41},{"$f":"RANK(K18,$K$17:$K$23,1)","v":1},"Nolan Shea",6,5,7,3,6,5,6,5,5,{"$f":"SUM(N18:V18)","v":48},{"$f":"RANK(W18,$W$17:$W$23,1)","v":2}]
["Dominic Herron",8,7,6,3,6,4,7,5,6,52,4,"Dax Macklin",5,3,8,5,5,5,6,6,8,51,5]
["Cameron Wong",5,6,7,5,6,6,7,6,6,54,5,"Brady Post",6,4,4,5,6,4,7,8,6,{"$f":"SUM(N20:V20)","v":50},4]
["Tyler Haase",8,7,7,4,7,5,6,6,7,57,6,"Evan Meyer",6,6,5,5,7,3,8,6,5,51,5]
["Peyton Schreck",8,4,5,5,6,5,6,5,6,50,3,"Matthew Olesen",6,4,6,3,6,5,7,5,6,48,2]
["Issac Dietzer",10,5,7,4,10,6,8,7,8,65,7,"Jonah Sal",10,6,6,4,9,8,10,5,7,65,7]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(L17:L23,\"<5\")>=4,(COUNTIF(L17:L23,\"4\")>1)),SUMIF(L17:L23,\"<4\",K17:K23)+(SUMIF(L17:L23,\"=4\",K17:K23)/(COUNTIF(L17:L23,\"4\"))*1),\nIF(AND(COUNTIF(L17:L23,\"<5\")>=4,(COUNTIF(L17:L23,\"3\")>1)),SUMIF(L17:L23,\"<3\",K17:K23)+(SUMIF(L17:L23,\"=3\",K17:K23)/(COUNTIF(L17:L23,\"3\"))*2),\nIF(AND(COUNTIF(L17:L23,\"<5\")>=4,(COUNTIF(L17:L23,\"2\")>2)),SUMIF(L17:L23,\"<2\",K17:K23)+(SUMIF(L17:L23,\"=2\",K17:K23)/(COUNTIF(L17:L23,\"2\"))*3),\nIF(COUNTIF(L17:L23,\"=1\")>=4,((SUMIF(L17:L23,\"=1\",K17:K23)/COUNTIF(L17:L23,\"1\"))*4),\nIF(COUNTIF(L17:L23,\"<5\")=4,SUMIF(L17:L23,\"<5\",K17:K23))))))","v":187},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(X17:X23,\"<5\")>=4,(COUNTIF(X17:X23,\"4\")>1)),SUMIF(X17:X23,\"<4\",W17:W23)+(SUMIF(X17:X23,\"=4\",W17:W23)/(COUNTIF(X17:X23,\"4\"))*1),\nIF(AND(COUNTIF(X17:X23,\"<5\")>=4,(COUNTIF(X17:X23,\"3\")>1)),SUMIF(X17:X23,\"<3\",W17:W23)+(SUMIF(X17:X23,\"=3\",W17:W23)/(COUNTIF(X17:X23,\"3\"))*2),\nIF(AND(COUNTIF(X17:X23,\"<5\")>=4,(COUNTIF(X17:X23,\"2\")>2)),SUMIF(X17:X23,\"<2\",W17:W23)+(SUMIF(X17:X23,\"=2\",W17:W23)/(COUNTIF(X17:X23,\"2\"))*3),\nIF(COUNTIF(X17:X23,\"=1\")>=4,((SUMIF(X17:X23,\"=1\",W17:W23)/COUNTIF(X17:X23,\"1\"))*4),\nIF(COUNTIF(X17:X23,\"<5\")=4,SUMIF(X17:X23,\"<5\",W17:W23))))))","v":192}]

{"sheet":"Varsity","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,1,5,3],[6,1,6,3],[0,0,0,3],[0,5,0,6],[2,1,2,3],[2,5,2,6],[4,4,4,6]]}
["Fox Valley Association",null,null,null,null,"Varsity"]
[]
["Match Date:",{"$f":"Scores!B5","v":"2023-04-25"},null,null,"Report Date:",{"$f":"Scores!B5","v":"2023-04-25"}]
[]
[null,null,null,null,"          Team Score"]
["School Reporting:","Kimberly",null,null,"----->",{"$f":"Scores!K16","v":143}," "]
["Opponent:","Appleton North",null,null,"----->",{"$f":"Scores!W16","v":150}," "]
[]
["E-Mail this form to: webmaster@fvaathletics.org as an attachment",null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!F9)>0,\"Neenah\",Scores!$N$10))","v":""}]
[]
[null,null,"9 Hole","Position","Opponents"]
["Name (First Last)","School","Score","Finish Points","Beaten"]
["Aiden Cudney",{"$f":"IF(A13=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A13)>0,\"Neenah\",Scores!$N$10))","v":"Neenah"},33,{"$f":"IF(C13=\"\",\"\",IF(C13<>C14,F13,SUM(OFFSET(F13,0,0,COUNTIF(C13:C22,C13),1))/COUNTIF(C13:C22,C13)))","v":10},{"$f":"IF(C13>0,SUM(COUNTIFS($B$13:$B$22,\"<>\"&B13,$C$13:$C$22,\">\"&C13)+(0.5*SUM(COUNTIFS($B$13:$B$22,\"<>\"&B13,$C$13:$C$22,C13)))),\"\")","v":5},10]
["Chance Rill",{"$f":"IF(A14=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A14)>0,\"Neenah\",Scores!$N$10))","v":"Neenah"},36,{"$f":"IF(C14=\"\",\"\",IF(C14=C13,D13,IF(C14<>C15,F14,SUM(OFFSET(F14,0,0,COUNTIF(C14:C23,C14),1))/COUNTIF(C14:C23,C14))))","v":9},{"$f":"IF(C14>0,SUM(COUNTIFS($B$13:$B$22,\"<>\"&B14,$C$13:$C$22,\">\"&C14)+(0.5*SUM(COUNTIFS($B$13:$B$22,\"<>\"&B14,$C$13:$C$22,C14)))),\"\")","v":5},9]
["Kade Dunham",{"$f":"IF(A15=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A15)>0,\"Neenah\",Scores!$N$10))","v":"Neenah"},37,{"$f":"IF(C15=\"\",\"\",IF(C15=C14,D14,IF(C15<>C16,F15,SUM(OFFSET(F15,0,0,COUNTIF(C15:C24,C15),1))/COUNTIF(C15:C24,C15))))","v":6.5},4,8]
["Riley Schmidt",{"$f":"IF(A16=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A16)>0,\"Neenah\",Scores!$N$10))","v":"Neenah"},37,6.5,4,7]
["Drew Rudolf",{"$f":"IF(A17=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A17)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},37,6.5,2,6]
["Kyle Schabo",{"$f":"IF(A18=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A18)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},37,6.5,2,5]
["Rasmus Madsen",{"$f":"IF(A19=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A19)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},38,3.5,1,4]
["Dane Heindel",{"$f":"IF(A20=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A20)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},38,3.5,1,3]
["Trey Vanevenhoven",{"$f":"IF(A21=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A21)>0,\"Neenah\",Scores!$N$10))","v":"Neenah"},42,2,1,2]
["Jon Huenink",{"$f":"IF(A22=\"\",\"\",IF(COUNTIF(Scores!$A$11:$A$15,Varsity!A22)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},43,1,0,1]

{"sheet":"JV","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,1,5,3],[6,1,6,3],[0,0,0,3],[0,5,0,6],[2,1,2,3],[2,5,2,6],[4,4,4,6]]}
["Fox Valley Association",null,null,null,null,"JV"]
[]
["Match Date:",{"$f":"Scores!B5","v":"2023-04-25"},null,null,"Report Date:",{"$f":"Scores!B5","v":"2023-04-25"}]
[]
[null,null,null,null,"          Team Score"]
["School Reporting:",{"$f":"Scores!B1","v":"Kimberly"},null,null,"----->",{"$f":"Scores!K24","v":187}," "]
["Opponent:",{"$f":"Scores!B2","v":"Appleton North"},null,null,"----->",{"$f":"Scores!W24","v":192}," "]
[]
["E-Mail this form to: webmaster@fvaathletics.org as an attachment",null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!F9)>0,\"Neenah\",Scores!$N$10))","v":""}]
[]
[null,null,"9 Hole"]
["Name (First Last)","School","Score"]
["Parker Brown",{"$f":"IF(A13=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A13)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Riley Schmidt",{"$f":"IF(A14=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A14)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Nathan Phillips",{"$f":"IF(A15=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A15)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Garrett Fisher",{"$f":"IF(A16=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A16)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Max Gronbach",{"$f":"IF(A17=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A17)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Cole Hansen",{"$f":"IF(A18=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A18)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Kade Dunham",{"$f":"IF(A19=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A19)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["JJ Paider",{"$f":"IF(A20=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A20)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Ben Sajbel",{"$f":"IF(A21=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A21)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Ethan Jacobs",{"$f":"IF(A22=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A22)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Sam Coulthard",{"$f":"IF(A23=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A23)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Victor Guerra",{"$f":"IF(A24=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A24)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Blaise Beckman",{"$f":"IF(A25=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A25)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]
["Sebastian Heise",{"$f":"IF(A26=\"\",\"\",IF(COUNTIF(Scores!$A$17:$A$23,JV!A26)>0,\"Neenah\",Scores!$N$10))","v":"Appleton North"},0]