{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Roster","Results","Game1","Game2","Game3","Game4","Game5","Game6","Game7","Game8","Game9","Game10","Totals"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":1,"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":"Roster","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,6,1,10],[2,6,7,10]]}
["NGNL 2019 Summer Season"]
["Player #","Last Name","First Name","Category","Sex",null,"INSTRUCTIONS:"]
[1,"Arias","Luis","N","M",null,"Follow the examples and enter the names of any players added to the roster.  If anyone needs to be removed, it should be done BEFORE entering any game data for a season. Add new players by replacing the generic \"Player\" entries with the new player."]
[2,"Castello","Erin","J","F"]
[3,"Huls","Josh","N","M"]
[4,"McKinney","Colin","J","M"]
[5,"Padams","Jordan","J","M"]
[6,"Patel","Saagar","J","M"]
[7,"Shelton","Jacob","J","M"]
[8,"Stegman","Matt","J","M",null,"on roster, but didn't play summer season"]
[9,"Stragier","Michael","J","M"]
[10,"Vicic","Mike","J","M"]
[11,"Vogel","Amy","J","F",null,"on roster, but didn't play summer season"]
[12,"Waldman","Jeff","J","M"]
[13,"Sereno","Gina","J","F"]
[14,"Saxton","Kimberly","J","F"]
[15,"Martin","Max","J","M"]
[16,"Gaston","Andy","J","M"]
[17,"Lee","Jonathan","J","M",null,"on roster, but didn't play summer season"]
[18,"Stetson","Michael","J","M",null,"on roster, but didn't play summer season"]
[19,"Player","T"]
[20,"Player","U"]
[21,"Player","V"]
[22,"Player","W"]
[23,"Player","X"]
[24,"Player","Y"]
[25,"Player","Z"]

{"sheet":"Results","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[14,0,14,4],[15,0,19,4]]}
[{"$f":"Roster!A1&\" Game Results\"","v":"NGNL 2019 Summer Season Game Results"}]
["Game #","Opponent","Result","NGNL","Opponent"]
[1,"vs. Sharks",{"$f":"IF(D3=\"\",\"\",IF(D3=E3,\"T\",IF(D3>E3,\"W\",\"L\")))","v":"L"},9,22]
[2,"vs. Space Force","W",19,17]
[3,"at Scared Hitless","W",29,26]
[4,"vs AFOS","L",24,27]
[5,"at Dawgs","L",11,13]
[6,"at Titan-1UP","L",3,18]
[7,"vs 5th Base","L",18,23]
[8,null,""]
[9,null,""]
[10,null,""]
[]
[]
["INSTRUCTIONS:"]
["Enter the opponent for each game. Use \"at\" for away games and \"vs\" for home games. Example, for a home game against the Dawgs, type \"vs Dawgs\". Enter the score for each team in the appropriate box.  The Result is computed automatically."]

{"sheet":"Game1","index":2,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B3&\" \"&Results!C3&\" \"&Results!D3&\"-\"&Results!E3","v":"NGNL 2019 Summer Season NGNL vs. Sharks L 9-22"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":3},1,1,0,0,{"$f":"E3+F3+G3+H3","v":2},2,1,0,0,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0.66666666666666663},{"$f":"IF(D3>0,S3/D3,0)","v":1},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.66666666666666663},{"$f":"O3+P3","v":1.6666666666666665},3,{"$f":"(E3+F3*2+G3*3+H3*4)","v":3},0]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,3,1,0,0,0,1,0,1,0,0,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.66666666666666663,3,1,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},1,4,3,0,0,0,3,1,1,0,0,0.75,0.75,0.75,1.5,4,3,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},1,4,2,0,0,0,2,1,1,0,0,0.5,0.5,0.5,1,4,2,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,4,2,0,0,0,2,1,1,0,0,0.5,0.5,0.5,1,4,2,0]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,4,0,0,0,0,0,0,1,0,0,0,0,0,0,4,0,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},1,3,0,0,1,0,1,1,1,0,0,0.33333333333333331,1,0.25,1.25,4,3,1]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},1,2,1,0,0,0,1,2,0,1,0,0.5,0.5,0.66666666666666663,1.1666666666666665,3,1,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,4,1,0,1,0,2,1,2,0,0,0.5,1,0.5,1.5,4,4,0]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":9},31,11,1,2,0,14,9,9,1,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.45370370370370378},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0.62037037037037035},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.46296296296296291},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.0833333333333333},{"$f":"SUM(R3:R27)","v":33},{"$f":"SUM(S3:S27)","v":19},{"$f":"SUM(T3:T27)","v":1}]

{"sheet":"Game2","index":3,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B4&\" \"&Results!C4&\" \"&Results!D4&\"-\"&Results!E4","v":"NGNL 2019 Summer Season NGNL vs. Space Force W 19-17"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":4},3,0,0,0,{"$f":"E3+F3+G3+H3","v":3},2,0,0,0,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0.75},{"$f":"IF(D3>0,S3/D3,0)","v":0.75},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.75},{"$f":"O3+P3","v":1.5},4,{"$f":"(E3+F3*2+G3*3+H3*4)","v":3},0]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,3,2,0,0,0,2,3,0,1,0,0.66666666666666663,0.66666666666666663,0.75,1.4166666666666665,4,2,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},1,5,3,0,1,0,4,4,4,0,0,0.8,1.2,0.8,2,5,6,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},1,3,0,0,1,0,1,3,1,2,0,0.33333333333333331,1,0.6,1.6,5,3,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,4,2,2,0,0,4,4,5,1,0,1,1.5,1,2.5,5,6,0]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,1,1,0,0,0,1,1,1,3,null,1,1,1,2,4,1,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},1,3,1,1,0,0,2,1,1,1,0,0.66666666666666663,1,0.6,1.6,5,3,1]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},1,3,2,0,0,0,2,0,2,1,0,0.66666666666666663,0.66666666666666663,0.75,1.4166666666666665,4,2,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,4,1,2,0,0,3,1,5,1,0,0.75,1.25,0.8,2.0499999999999998,5,5,0]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":9},30,15,5,2,0,22,19,19,10,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.73703703703703716},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":1.0037037037037038},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.78333333333333333},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.787037037037037},{"$f":"SUM(R3:R27)","v":41},{"$f":"SUM(S3:S27)","v":31},{"$f":"SUM(T3:T27)","v":1}]

{"sheet":"Game3","index":4,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B5&\" \"&Results!C5&\" \"&Results!D5&\"-\"&Results!E5","v":"NGNL 2019 Summer Season NGNL at Scared Hitless W 29-26"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":5},2,3,0,0,{"$f":"E3+F3+G3+H3","v":5},5,1,0,0,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":1},{"$f":"IF(D3>0,S3/D3,0)","v":1.6},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":1},{"$f":"O3+P3","v":2.6},5,{"$f":"(E3+F3*2+G3*3+H3*4)","v":8},0]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,4,1,0,0,0,1,2,1,1,0,0.25,0.25,0.4,0.65,5,1,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},1,5,2,1,0,2,5,4,9,0,0,1,2.4,1,3.4,5,12,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},1,5,2,0,0,0,2,1,1,0,1,0.4,0.4,0.4,0.8,5,2,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},1,5,1,1,0,0,2,3,2,0,0,0.4,0.6,0.4,1,5,3,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,6,3,1,0,0,4,3,1,0,1,0.66666666666666663,0.83333333333333337,0.66666666666666663,1.5,6,5,0]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,3,1,1,0,0,2,2,1,2,0,0.66666666666666663,1,0.8,1.8,5,3,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},1,5,2,0,0,1,3,2,5,0,0,0.6,1.2,0.6,1.7999999999999998,5,6,0]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},1,5,3,1,0,0,4,4,1,1,0,0.8,1,0.83333333333333337,1.8333333333333335,6,5,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,5,2,2,0,0,4,2,5,0,0,0.8,1.2,0.8,2,5,6,0]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},1,4,1,0,0,0,1,1,2,1,1,0.25,0.25,0.4,0.65,5,1,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":11},52,20,10,0,3,33,29,29,5,3,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.6212121212121211},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0.97575757575757571},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.66363636363636358},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.6393939393939392},{"$f":"SUM(R3:R27)","v":57},{"$f":"SUM(S3:S27)","v":52},{"$f":"SUM(T3:T27)","v":0}]

{"sheet":"Game4","index":5,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B6&\" \"&Results!C6&\" \"&Results!D6&\"-\"&Results!E6","v":"NGNL 2019 Summer Season NGNL vs AFOS L 24-27"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":4},3,null,null,null,{"$f":"E3+F3+G3+H3","v":3},3,2,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0.75},{"$f":"IF(D3>0,S3/D3,0)","v":0.75},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.6},{"$f":"O3+P3","v":1.35},5,{"$f":"(E3+F3*2+G3*3+H3*4)","v":3},1]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,5,4,null,null,null,4,2,1,null,null,0.8,0.8,0.8,1.6,5,4]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},1,3,1,1,1,null,3,4,4,2,null,1,2,1,3,5,6]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},1,4,2,1,null,null,3,2,3,1,null,0.75,1,0.8,1.8,5,4]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,5,2,1,1,null,4,1,4,null,null,0.8,1.4,0.8,2.2000000000000002,5,7]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,4,2,1,null,null,3,2,null,1,null,0.75,1,0.8,1.8,5,4]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},1,3,null,null,null,1,1,1,3,1,null,0.33333333333333331,1.3333333333333333,0.4,1.7333333333333334,5,4,1]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},1,5,3,1,null,null,4,4,2,null,null,0.8,1,0.8,1.8,5,5]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,5,2,null,null,null,2,2,1,null,null,0.4,0.4,0.4,0.8,5,2]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},1,4,1,null,null,null,1,1,1,null,1,0.25,0.25,0.25,0.5,4,1]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},1,4,2,null,null,null,2,2,2,null,null,0.5,0.5,0.5,1,4,2]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":11},46,22,5,2,1,30,24,23,5,1,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.64848484848484844},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0.94848484848484849},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.65},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.5984848484848486},{"$f":"SUM(R3:R27)","v":53},{"$f":"SUM(S3:S27)","v":42},{"$f":"SUM(T3:T27)","v":2}]

{"sheet":"Game5","index":6,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B7&\" \"&Results!C7&\" \"&Results!D7&\"-\"&Results!E7","v":"NGNL 2019 Summer Season NGNL at Dawgs L 11-13"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":4},2,null,null,null,{"$f":"E3+F3+G3+H3","v":2},1,null,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0.5},{"$f":"IF(D3>0,S3/D3,0)","v":0.5},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.5},{"$f":"O3+P3","v":1},4,{"$f":"(E3+F3*2+G3*3+H3*4)","v":2}]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,3,1,null,null,null,1,1,null,null,null,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.66666666666666663,3,1]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},1,4,1,2,null,null,3,3,3,null,null,0.75,1.25,0.75,2,4,5]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},1,4,1,2,null,1,4,2,5,null,null,1,2.25,1,3.25,4,9]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,4,1,1,null,null,2,1,null,null,null,0.5,0.75,0.5,1.25,4,3]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,4,2,null,null,null,2,null,2,null,null,0.5,0.5,0.5,1,4,2]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},1,4,1,null,null,null,1,1,null,null,null,0.25,0.25,0.25,0.5,4,1]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,4,2,null,null,null,2,1,null,null,null,0.5,0.5,0.5,1,4,2]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},1,3,1,null,null,null,1,1,null,null,null,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.66666666666666663,3,1]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},1,3,null,null,null,null,0,null,null,null,null,0,0,0,0,3,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":10},37,12,5,0,1,18,11,10,0,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.46666666666666662},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0.66666666666666663},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.46666666666666662},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.1333333333333333},{"$f":"SUM(R3:R27)","v":37},{"$f":"SUM(S3:S27)","v":26},{"$f":"SUM(T3:T27)","v":0}]

{"sheet":"Game6","index":7,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B8&\" \"&Results!C8&\" \"&Results!D8&\"-\"&Results!E8","v":"NGNL 2019 Summer Season NGNL at Titan-1UP L 3-18"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":4},1,null,null,null,{"$f":"E3+F3+G3+H3","v":1},null,null,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0.25},{"$f":"IF(D3>0,S3/D3,0)","v":0.25},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.25},{"$f":"O3+P3","v":0.5},4,{"$f":"(E3+F3*2+G3*3+H3*4)","v":1}]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,3,null,null,null,null,0,null,null,null,null,0,0,0,0,3,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,3,2,null,null,null,2,null,1,null,null,0.66666666666666663,0.66666666666666663,0.66666666666666663,1.3333333333333333,3,2]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,3,null,null,null,null,0,null,1,null,null,0,0,0,0,3,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},1,3,1,null,1,null,2,1,null,null,null,0.66666666666666663,1.3333333333333333,0.66666666666666663,2,3,4]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},1,4,1,null,null,1,2,1,1,null,null,0.5,1.25,0.5,1.75,4,5]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,3,1,1,null,null,2,1,null,null,null,0.66666666666666663,1,0.66666666666666663,1.6666666666666665,3,3]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},1,3,1,null,null,null,1,null,null,null,null,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.66666666666666663,3,1]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},1,3,1,null,null,null,1,null,null,null,null,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.66666666666666663,3,1]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},1,3,3,null,null,null,3,null,null,null,null,1,1,1,2,3,3]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":10},32,11,1,1,1,14,3,3,0,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.4416666666666666},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0.61666666666666659},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.4416666666666666},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.0583333333333333},{"$f":"SUM(R3:R27)","v":32},{"$f":"SUM(S3:S27)","v":20},{"$f":"SUM(T3:T27)","v":0}]

{"sheet":"Game7","index":8,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B9&\" \"&Results!C9&\" \"&Results!D9&\"-\"&Results!E9","v":"NGNL 2019 Summer Season NGNL vs 5th Base L 18-23"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},1,{"$f":"R3-(T3+L3)","v":4},2,2,null,null,{"$f":"E3+F3+G3+H3","v":4},3,3,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":1},{"$f":"IF(D3>0,S3/D3,0)","v":1.5},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.8},{"$f":"O3+P3","v":2.2999999999999998},5,{"$f":"(E3+F3*2+G3*3+H3*4)","v":6},1]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},1,3,2,null,null,null,2,2,1,1,null,0.66666666666666663,0.66666666666666663,0.75,1.4166666666666665,4,2]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},1,3,3,null,null,null,3,2,2,1,null,1,1,0.8,1.8,5,3,1]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},1,4,2,2,null,null,4,2,2,1,null,1,1.5,1,2.5,5,6]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},1,5,2,1,null,null,3,null,4,null,null,0.6,0.8,0.6,1.4,5,4]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},1,5,1,null,null,null,1,1,2,null,null,0.2,0.2,0.2,0.4,5,1]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},1,3,2,null,null,null,2,4,2,2,null,0.66666666666666663,0.66666666666666663,0.8,1.4666666666666668,5,2]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},1,5,2,null,null,null,2,2,1,null,null,0.4,0.4,0.4,0.8,5,2]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},1,4,1,null,null,null,1,2,1,1,null,0.25,0.25,0.4,0.65,5,1]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":1},{"$f":"SUM(C3:C27)","v":9},36,17,5,0,0,22,18,18,6,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0.64259259259259272},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0.77592592592592591},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0.63888888888888895},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":1.414814814814815},{"$f":"SUM(R3:R27)","v":44},{"$f":"SUM(S3:S27)","v":27},{"$f":"SUM(T3:T27)","v":2}]

{"sheet":"Game8","index":9,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B10&\" \"&Results!C10&\" \"&Results!D10&\"-\"&Results!E10","v":"NGNL 2019 Summer Season NGNL   -"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},null,{"$f":"R3-(T3+L3)","v":0},null,null,null,null,{"$f":"E3+F3+G3+H3","v":0},null,null,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0},{"$f":"IF(D3>0,S3/D3,0)","v":0},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0},{"$f":"O3+P3","v":0},null,{"$f":"(E3+F3*2+G3*3+H3*4)","v":0}]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":0},{"$f":"SUM(C3:C27)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":0},{"$f":"SUM(R3:R27)","v":0},{"$f":"SUM(S3:S27)","v":0},{"$f":"SUM(T3:T27)","v":0}]

{"sheet":"Game9","index":10,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B11&\" \"&Results!C11&\" \"&Results!D11&\"-\"&Results!E11","v":"NGNL 2019 Summer Season NGNL   -"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},null,{"$f":"R3-(T3+L3)","v":0},null,null,null,null,{"$f":"E3+F3+G3+H3","v":0},null,null,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0},{"$f":"IF(D3>0,S3/D3,0)","v":0},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0},{"$f":"O3+P3","v":0},null,{"$f":"(E3+F3*2+G3*3+H3*4)","v":0}]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":0},{"$f":"SUM(C3:C27)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":0},{"$f":"SUM(R3:R27)","v":0},{"$f":"SUM(S3:S27)","v":0},{"$f":"SUM(T3:T27)","v":0}]

{"sheet":"Game10","index":11,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" NGNL \"&Results!B12&\" \"&Results!C12&\" \"&Results!D12&\"-\"&Results!E12","v":"NGNL 2019 Summer Season NGNL   -"}]
["Rank","Name","At Game?","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[1,{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},null,{"$f":"R3-(T3+L3)","v":0},null,null,null,null,{"$f":"E3+F3+G3+H3","v":0},null,null,null,null,{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0},{"$f":"IF(D3>0,S3/D3,0)","v":0},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0},{"$f":"O3+P3","v":0},null,{"$f":"(E3+F3*2+G3*3+H3*4)","v":0}]
[2,{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[3,{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[4,{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[5,{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[6,{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[7,{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[8,{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[9,{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[10,{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[11,{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[12,{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[13,{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[14,{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[15,{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[16,{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[17,{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[18,{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[19,{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[20,{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[21,{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[22,{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[23,{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[24,{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[25,{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},null,0,null,null,null,null,0,null,null,null,null,0,0,0,0,null,0]
[null,{"$f":"IF(C28>0,1,0)","v":0},{"$f":"SUM(C3:C27)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(C28>0,SUM(N3:N27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(O3:O27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(P3:P27)/C28,0)","v":0},{"$f":"IF(C28>0,SUM(Q3:Q27)/C28,0)","v":0},{"$f":"SUM(R3:R27)","v":0},{"$f":"SUM(S3:S27)","v":0},{"$f":"SUM(T3:T27)","v":0}]

{"sheet":"Totals","index":12,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[{"$f":"Roster!A1&\" Stats\"","v":"NGNL 2019 Summer Season Stats"}]
["Rank","Name","Games","AB","1B","2B","3B","HR","Hits","Runs","RBIs","BB","SO","AVG","SLG","OBA","OPS","PA","TB","SF"]
[{"$f":"--SUBTOTAL(3,B$3:B3)","v":1},{"$f":"Roster!B5&\", \"&LEFT(Roster!C5,1)","v":"Huls, J"},{"$f":"SUM(Game1:Game10!C5)","v":5},{"$f":"R3-(T3+L3)","v":21},{"$f":"SUM(Game1:Game10!E5)","v":10},{"$f":"SUM(Game1:Game10!F5)","v":4},{"$f":"SUM(Game1:Game10!G5)","v":2},{"$f":"SUM(Game1:Game10!H5)","v":2},{"$f":"E3+F3+G3+H3","v":18},{"$f":"SUM(Game1:Game10!J5)","v":16},{"$f":"SUM(Game1:Game10!K5)","v":21},{"$f":"SUM(Game1:Game10!L5)","v":2},{"$f":"SUM(Game1:Game10!M5)","v":0},{"$f":"IF(D3>0,(E3+F3+G3+H3)/D3,0)","v":0.8571428571428571},{"$f":"IF(D3>0,S3/D3,0)","v":1.5238095238095237},{"$f":"IF(R3>0,(E3+F3+G3+H3+L3)/R3,0)","v":0.86956521739130432},{"$f":"O3+P3","v":2.3933747412008279},{"$f":"SUM(Game1:Game10!R5)","v":23},{"$f":"(E3+F3*2+G3*3+H3*4)","v":32},{"$f":"SUM(Game1:Game10!T5)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B4)","v":2},{"$f":"Roster!B3&\", \"&LEFT(Roster!C3,1)","v":"Arias, L"},{"$f":"SUM(Game1:Game10!C3)","v":7},28,{"$f":"SUM(Game1:Game10!E3)","v":14},{"$f":"SUM(Game1:Game10!F3)","v":6},{"$f":"SUM(Game1:Game10!G3)","v":0},{"$f":"SUM(Game1:Game10!H3)","v":0},20,{"$f":"SUM(Game1:Game10!J3)","v":16},{"$f":"SUM(Game1:Game10!K3)","v":7},{"$f":"SUM(Game1:Game10!L3)","v":0},{"$f":"SUM(Game1:Game10!M3)","v":0},0.7142857142857143,0.9285714285714286,0.66666666666666663,1.5952380952380953,{"$f":"SUM(Game1:Game10!R3)","v":30},26,{"$f":"SUM(Game1:Game10!T3)","v":2}]
[{"$f":"--SUBTOTAL(3,B$3:B5)","v":2},{"$f":"Roster!B13&\", \"&LEFT(Roster!C13,1)","v":"Vogel, A"},{"$f":"SUM(Game1:Game10!C13)","v":0},0,{"$f":"SUM(Game1:Game10!E13)","v":0},{"$f":"SUM(Game1:Game10!F13)","v":0},{"$f":"SUM(Game1:Game10!G13)","v":0},{"$f":"SUM(Game1:Game10!H13)","v":0},0,{"$f":"SUM(Game1:Game10!J13)","v":0},{"$f":"SUM(Game1:Game10!K13)","v":0},{"$f":"SUM(Game1:Game10!L13)","v":0},{"$f":"SUM(Game1:Game10!M13)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R13)","v":0},0,{"$f":"SUM(Game1:Game10!T13)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B6)","v":3},{"$f":"Roster!B12&\", \"&LEFT(Roster!C12,1)","v":"Vicic, M"},{"$f":"SUM(Game1:Game10!C12)","v":6},22,{"$f":"SUM(Game1:Game10!E12)","v":12},{"$f":"SUM(Game1:Game10!F12)","v":2},{"$f":"SUM(Game1:Game10!G12)","v":0},{"$f":"SUM(Game1:Game10!H12)","v":1},15,{"$f":"SUM(Game1:Game10!J12)","v":15},{"$f":"SUM(Game1:Game10!K12)","v":8},{"$f":"SUM(Game1:Game10!L12)","v":5},{"$f":"SUM(Game1:Game10!M12)","v":0},0.68181818181818177,0.90909090909090906,0.7407407407407407,1.6498316498316496,{"$f":"SUM(Game1:Game10!R12)","v":27},20,{"$f":"SUM(Game1:Game10!T12)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B7)","v":4},{"$f":"Roster!B8&\", \"&LEFT(Roster!C8,1)","v":"Patel, S"},{"$f":"SUM(Game1:Game10!C8)","v":7},31,{"$f":"SUM(Game1:Game10!E8)","v":14},{"$f":"SUM(Game1:Game10!F8)","v":6},{"$f":"SUM(Game1:Game10!G8)","v":1},{"$f":"SUM(Game1:Game10!H8)","v":0},21,{"$f":"SUM(Game1:Game10!J8)","v":10},{"$f":"SUM(Game1:Game10!K8)","v":16},{"$f":"SUM(Game1:Game10!L8)","v":1},{"$f":"SUM(Game1:Game10!M8)","v":1},0.67741935483870963,0.93548387096774188,0.6875,1.622983870967742,{"$f":"SUM(Game1:Game10!R8)","v":32},29,{"$f":"SUM(Game1:Game10!T8)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B8)","v":5},{"$f":"Roster!B6&\", \"&LEFT(Roster!C6,1)","v":"McKinney, C"},{"$f":"SUM(Game1:Game10!C6)","v":6},23,{"$f":"SUM(Game1:Game10!E6)","v":10},{"$f":"SUM(Game1:Game10!F6)","v":3},{"$f":"SUM(Game1:Game10!G6)","v":1},{"$f":"SUM(Game1:Game10!H6)","v":1},15,{"$f":"SUM(Game1:Game10!J6)","v":11},{"$f":"SUM(Game1:Game10!K6)","v":13},{"$f":"SUM(Game1:Game10!L6)","v":4},{"$f":"SUM(Game1:Game10!M6)","v":1},0.65217391304347827,1,0.6785714285714286,1.6785714285714286,{"$f":"SUM(Game1:Game10!R6)","v":28},23,{"$f":"SUM(Game1:Game10!T6)","v":1}]
[{"$f":"--SUBTOTAL(3,B$3:B9)","v":6},{"$f":"Roster!B14&\", \"&LEFT(Roster!C14,1)","v":"Waldman, J"},{"$f":"SUM(Game1:Game10!C14)","v":7},30,{"$f":"SUM(Game1:Game10!E14)","v":11},{"$f":"SUM(Game1:Game10!F14)","v":5},{"$f":"SUM(Game1:Game10!G14)","v":1},{"$f":"SUM(Game1:Game10!H14)","v":0},17,{"$f":"SUM(Game1:Game10!J14)","v":10},{"$f":"SUM(Game1:Game10!K14)","v":14},{"$f":"SUM(Game1:Game10!L14)","v":1},{"$f":"SUM(Game1:Game10!M14)","v":0},0.56666666666666665,0.8,0.58064516129032262,1.3806451612903228,{"$f":"SUM(Game1:Game10!R14)","v":31},24,{"$f":"SUM(Game1:Game10!T14)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B10)","v":7},{"$f":"Roster!B11&\", \"&LEFT(Roster!C11,1)","v":"Stragier, M"},{"$f":"SUM(Game1:Game10!C11)","v":6},21,{"$f":"SUM(Game1:Game10!E11)","v":5},{"$f":"SUM(Game1:Game10!F11)","v":1},{"$f":"SUM(Game1:Game10!G11)","v":2},{"$f":"SUM(Game1:Game10!H11)","v":2},10,{"$f":"SUM(Game1:Game10!J11)","v":7},{"$f":"SUM(Game1:Game10!K11)","v":10},{"$f":"SUM(Game1:Game10!L11)","v":2},{"$f":"SUM(Game1:Game10!M11)","v":0},0.47619047619047616,1,0.46153846153846156,1.4615384615384617,{"$f":"SUM(Game1:Game10!R11)","v":26},21,{"$f":"SUM(Game1:Game10!T11)","v":3}]
[{"$f":"--SUBTOTAL(3,B$3:B11)","v":8},{"$f":"Roster!B4&\", \"&LEFT(Roster!C4,1)","v":"Castello, E"},{"$f":"SUM(Game1:Game10!C4)","v":7},24,{"$f":"SUM(Game1:Game10!E4)","v":11},{"$f":"SUM(Game1:Game10!F4)","v":0},{"$f":"SUM(Game1:Game10!G4)","v":0},{"$f":"SUM(Game1:Game10!H4)","v":0},11,{"$f":"SUM(Game1:Game10!J4)","v":10},{"$f":"SUM(Game1:Game10!K4)","v":4},{"$f":"SUM(Game1:Game10!L4)","v":3},{"$f":"SUM(Game1:Game10!M4)","v":0},0.45833333333333331,0.45833333333333331,0.51851851851851849,0.97685185185185186,{"$f":"SUM(Game1:Game10!R4)","v":27},11,{"$f":"SUM(Game1:Game10!T4)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B12)","v":9},{"$f":"Roster!B9&\", \"&LEFT(Roster!C9,1)","v":"Shelton, J"},{"$f":"SUM(Game1:Game10!C9)","v":7},24,{"$f":"SUM(Game1:Game10!E9)","v":7},{"$f":"SUM(Game1:Game10!F9)","v":2},{"$f":"SUM(Game1:Game10!G9)","v":0},{"$f":"SUM(Game1:Game10!H9)","v":0},9,{"$f":"SUM(Game1:Game10!J9)","v":6},{"$f":"SUM(Game1:Game10!K9)","v":8},{"$f":"SUM(Game1:Game10!L9)","v":6},{"$f":"SUM(Game1:Game10!M9)","v":0},0.375,0.45833333333333331,0.5,0.95833333333333326,{"$f":"SUM(Game1:Game10!R9)","v":30},11,{"$f":"SUM(Game1:Game10!T9)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B13)","v":10},{"$f":"Roster!B7&\", \"&LEFT(Roster!C7,1)","v":"Padams, J"},{"$f":"SUM(Game1:Game10!C7)","v":2},9,{"$f":"SUM(Game1:Game10!E7)","v":3},{"$f":"SUM(Game1:Game10!F7)","v":3},{"$f":"SUM(Game1:Game10!G7)","v":0},{"$f":"SUM(Game1:Game10!H7)","v":0},6,{"$f":"SUM(Game1:Game10!J7)","v":5},{"$f":"SUM(Game1:Game10!K7)","v":4},{"$f":"SUM(Game1:Game10!L7)","v":1},{"$f":"SUM(Game1:Game10!M7)","v":0},0.66666666666666663,1,0.7,1.7,{"$f":"SUM(Game1:Game10!R7)","v":10},9,{"$f":"SUM(Game1:Game10!T7)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B14)","v":11},{"$f":"Roster!B18&\", \"&LEFT(Roster!C18,1)","v":"Gaston, A"},{"$f":"SUM(Game1:Game10!C18)","v":2},7,{"$f":"SUM(Game1:Game10!E18)","v":4},{"$f":"SUM(Game1:Game10!F18)","v":0},{"$f":"SUM(Game1:Game10!G18)","v":0},{"$f":"SUM(Game1:Game10!H18)","v":0},4,{"$f":"SUM(Game1:Game10!J18)","v":2},{"$f":"SUM(Game1:Game10!K18)","v":1},{"$f":"SUM(Game1:Game10!L18)","v":1},{"$f":"SUM(Game1:Game10!M18)","v":0},0.5714285714285714,0.5714285714285714,0.625,1.1964285714285714,{"$f":"SUM(Game1:Game10!R18)","v":8},4,{"$f":"SUM(Game1:Game10!T18)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B15)","v":12},{"$f":"Roster!B17&\", \"&LEFT(Roster!C17,1)","v":"Martin, M"},{"$f":"SUM(Game1:Game10!C17)","v":3},10,{"$f":"SUM(Game1:Game10!E17)","v":3},{"$f":"SUM(Game1:Game10!F17)","v":0},{"$f":"SUM(Game1:Game10!G17)","v":0},{"$f":"SUM(Game1:Game10!H17)","v":0},3,{"$f":"SUM(Game1:Game10!J17)","v":2},{"$f":"SUM(Game1:Game10!K17)","v":2},{"$f":"SUM(Game1:Game10!L17)","v":0},{"$f":"SUM(Game1:Game10!M17)","v":0},0.3,0.3,0.3,0.6,{"$f":"SUM(Game1:Game10!R17)","v":10},3,{"$f":"SUM(Game1:Game10!T17)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B16)","v":13},{"$f":"Roster!B16&\", \"&LEFT(Roster!C16,1)","v":"Saxton, K"},{"$f":"SUM(Game1:Game10!C16)","v":3},10,{"$f":"SUM(Game1:Game10!E16)","v":3},{"$f":"SUM(Game1:Game10!F16)","v":0},{"$f":"SUM(Game1:Game10!G16)","v":0},{"$f":"SUM(Game1:Game10!H16)","v":0},3,{"$f":"SUM(Game1:Game10!J16)","v":2},{"$f":"SUM(Game1:Game10!K16)","v":1},{"$f":"SUM(Game1:Game10!L16)","v":0},{"$f":"SUM(Game1:Game10!M16)","v":1},0.3,0.3,0.3,0.6,{"$f":"SUM(Game1:Game10!R16)","v":10},3,{"$f":"SUM(Game1:Game10!T16)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B17)","v":14},{"$f":"Roster!B15&\", \"&LEFT(Roster!C15,1)","v":"Sereno, G"},{"$f":"SUM(Game1:Game10!C15)","v":1},4,{"$f":"SUM(Game1:Game10!E15)","v":1},{"$f":"SUM(Game1:Game10!F15)","v":0},{"$f":"SUM(Game1:Game10!G15)","v":0},{"$f":"SUM(Game1:Game10!H15)","v":0},1,{"$f":"SUM(Game1:Game10!J15)","v":1},{"$f":"SUM(Game1:Game10!K15)","v":2},{"$f":"SUM(Game1:Game10!L15)","v":1},{"$f":"SUM(Game1:Game10!M15)","v":1},0.25,0.25,0.4,0.65,{"$f":"SUM(Game1:Game10!R15)","v":5},1,{"$f":"SUM(Game1:Game10!T15)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B18)","v":15},{"$f":"Roster!B10&\", \"&LEFT(Roster!C10,1)","v":"Stegman, M"},{"$f":"SUM(Game1:Game10!C10)","v":0},0,{"$f":"SUM(Game1:Game10!E10)","v":0},{"$f":"SUM(Game1:Game10!F10)","v":0},{"$f":"SUM(Game1:Game10!G10)","v":0},{"$f":"SUM(Game1:Game10!H10)","v":0},0,{"$f":"SUM(Game1:Game10!J10)","v":0},{"$f":"SUM(Game1:Game10!K10)","v":0},{"$f":"SUM(Game1:Game10!L10)","v":0},{"$f":"SUM(Game1:Game10!M10)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R10)","v":0},0,{"$f":"SUM(Game1:Game10!T10)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B19)","v":15},{"$f":"Roster!B19&\", \"&LEFT(Roster!C19,1)","v":"Lee, J"},{"$f":"SUM(Game1:Game10!C19)","v":0},{"$f":"R19-(T19+L19)","v":0},{"$f":"SUM(Game1:Game10!E19)","v":0},{"$f":"SUM(Game1:Game10!F19)","v":0},{"$f":"SUM(Game1:Game10!G19)","v":0},{"$f":"SUM(Game1:Game10!H19)","v":0},{"$f":"E19+F19+G19+H19","v":0},{"$f":"SUM(Game1:Game10!J19)","v":0},{"$f":"SUM(Game1:Game10!K19)","v":0},{"$f":"SUM(Game1:Game10!L19)","v":0},{"$f":"SUM(Game1:Game10!M19)","v":0},{"$f":"IF(D19>0,(E19+F19+G19+H19)/D19,0)","v":0},{"$f":"IF(D19>0,S19/D19,0)","v":0},{"$f":"IF(R19>0,(E19+F19+G19+H19+L19)/R19,0)","v":0},{"$f":"O19+P19","v":0},{"$f":"SUM(Game1:Game10!R19)","v":0},{"$f":"(E19+F19*2+G19*3+H19*4)","v":0},{"$f":"SUM(Game1:Game10!T19)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B20)","v":15},{"$f":"Roster!B20&\", \"&LEFT(Roster!C20,1)","v":"Stetson, M"},{"$f":"SUM(Game1:Game10!C20)","v":0},0,{"$f":"SUM(Game1:Game10!E20)","v":0},{"$f":"SUM(Game1:Game10!F20)","v":0},{"$f":"SUM(Game1:Game10!G20)","v":0},{"$f":"SUM(Game1:Game10!H20)","v":0},0,{"$f":"SUM(Game1:Game10!J20)","v":0},{"$f":"SUM(Game1:Game10!K20)","v":0},{"$f":"SUM(Game1:Game10!L20)","v":0},{"$f":"SUM(Game1:Game10!M20)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R20)","v":0},0,{"$f":"SUM(Game1:Game10!T20)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B21)","v":15},{"$f":"Roster!B21&\", \"&LEFT(Roster!C21,1)","v":"Player, T"},{"$f":"SUM(Game1:Game10!C21)","v":0},0,{"$f":"SUM(Game1:Game10!E21)","v":0},{"$f":"SUM(Game1:Game10!F21)","v":0},{"$f":"SUM(Game1:Game10!G21)","v":0},{"$f":"SUM(Game1:Game10!H21)","v":0},0,{"$f":"SUM(Game1:Game10!J21)","v":0},{"$f":"SUM(Game1:Game10!K21)","v":0},{"$f":"SUM(Game1:Game10!L21)","v":0},{"$f":"SUM(Game1:Game10!M21)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R21)","v":0},0,{"$f":"SUM(Game1:Game10!T21)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B22)","v":15},{"$f":"Roster!B22&\", \"&LEFT(Roster!C22,1)","v":"Player, U"},{"$f":"SUM(Game1:Game10!C22)","v":0},0,{"$f":"SUM(Game1:Game10!E22)","v":0},{"$f":"SUM(Game1:Game10!F22)","v":0},{"$f":"SUM(Game1:Game10!G22)","v":0},{"$f":"SUM(Game1:Game10!H22)","v":0},0,{"$f":"SUM(Game1:Game10!J22)","v":0},{"$f":"SUM(Game1:Game10!K22)","v":0},{"$f":"SUM(Game1:Game10!L22)","v":0},{"$f":"SUM(Game1:Game10!M22)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R22)","v":0},0,{"$f":"SUM(Game1:Game10!T22)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B23)","v":15},{"$f":"Roster!B23&\", \"&LEFT(Roster!C23,1)","v":"Player, V"},{"$f":"SUM(Game1:Game10!C23)","v":0},0,{"$f":"SUM(Game1:Game10!E23)","v":0},{"$f":"SUM(Game1:Game10!F23)","v":0},{"$f":"SUM(Game1:Game10!G23)","v":0},{"$f":"SUM(Game1:Game10!H23)","v":0},0,{"$f":"SUM(Game1:Game10!J23)","v":0},{"$f":"SUM(Game1:Game10!K23)","v":0},{"$f":"SUM(Game1:Game10!L23)","v":0},{"$f":"SUM(Game1:Game10!M23)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R23)","v":0},0,{"$f":"SUM(Game1:Game10!T23)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B24)","v":15},{"$f":"Roster!B24&\", \"&LEFT(Roster!C24,1)","v":"Player, W"},{"$f":"SUM(Game1:Game10!C24)","v":0},0,{"$f":"SUM(Game1:Game10!E24)","v":0},{"$f":"SUM(Game1:Game10!F24)","v":0},{"$f":"SUM(Game1:Game10!G24)","v":0},{"$f":"SUM(Game1:Game10!H24)","v":0},0,{"$f":"SUM(Game1:Game10!J24)","v":0},{"$f":"SUM(Game1:Game10!K24)","v":0},{"$f":"SUM(Game1:Game10!L24)","v":0},{"$f":"SUM(Game1:Game10!M24)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R24)","v":0},0,{"$f":"SUM(Game1:Game10!T24)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B25)","v":15},{"$f":"Roster!B25&\", \"&LEFT(Roster!C25,1)","v":"Player, X"},{"$f":"SUM(Game1:Game10!C25)","v":0},0,{"$f":"SUM(Game1:Game10!E25)","v":0},{"$f":"SUM(Game1:Game10!F25)","v":0},{"$f":"SUM(Game1:Game10!G25)","v":0},{"$f":"SUM(Game1:Game10!H25)","v":0},0,{"$f":"SUM(Game1:Game10!J25)","v":0},{"$f":"SUM(Game1:Game10!K25)","v":0},{"$f":"SUM(Game1:Game10!L25)","v":0},{"$f":"SUM(Game1:Game10!M25)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R25)","v":0},0,{"$f":"SUM(Game1:Game10!T25)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B26)","v":15},{"$f":"Roster!B26&\", \"&LEFT(Roster!C26,1)","v":"Player, Y"},{"$f":"SUM(Game1:Game10!C26)","v":0},0,{"$f":"SUM(Game1:Game10!E26)","v":0},{"$f":"SUM(Game1:Game10!F26)","v":0},{"$f":"SUM(Game1:Game10!G26)","v":0},{"$f":"SUM(Game1:Game10!H26)","v":0},0,{"$f":"SUM(Game1:Game10!J26)","v":0},{"$f":"SUM(Game1:Game10!K26)","v":0},{"$f":"SUM(Game1:Game10!L26)","v":0},{"$f":"SUM(Game1:Game10!M26)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R26)","v":0},0,{"$f":"SUM(Game1:Game10!T26)","v":0}]
[{"$f":"--SUBTOTAL(3,B$3:B27)","v":15},{"$f":"Roster!B27&\", \"&LEFT(Roster!C27,1)","v":"Player, Z"},{"$f":"SUM(Game1:Game10!C27)","v":0},0,{"$f":"SUM(Game1:Game10!E27)","v":0},{"$f":"SUM(Game1:Game10!F27)","v":0},{"$f":"SUM(Game1:Game10!G27)","v":0},{"$f":"SUM(Game1:Game10!H27)","v":0},0,{"$f":"SUM(Game1:Game10!J27)","v":0},{"$f":"SUM(Game1:Game10!K27)","v":0},{"$f":"SUM(Game1:Game10!L27)","v":0},{"$f":"SUM(Game1:Game10!M27)","v":0},0,0,0,0,{"$f":"SUM(Game1:Game10!R27)","v":0},0,{"$f":"SUM(Game1:Game10!T27)","v":0}]
[null,{"$f":"\"Min PA to qualify: \"&FLOOR(C28*2,0.1)","v":"Min PA to qualify: 14"},{"$f":"SUM(Game1:Game10!B28)","v":7},{"$f":"SUM(D3:D27)","v":264},108,32,7,6,153,113,111,27,4,{"$f":"IF(C28>0,I28/D28,0)","v":0.57954545454545459},{"$f":"IF(C28>0,S28/D28,0)","v":0.82196969696969702},{"$f":"IF(C28>0,(I28+L28)/R28,0)","v":0.60606060606060608},{"$f":"IF(C28>0,O28+P28,0)","v":1.4280303030303032},{"$f":"SUM(R3:R27)","v":297},{"$f":"SUM(S3:S27)","v":217},{"$f":"SUM(T3:T27)","v":6}]
[null,{"$f":"\"Team Run Avg: \"&IF(C28>0,ROUNDUP(SUM(Results!D3:D12)/C28,2),0)","v":"Team Run Avg: 16.15"}]
[null,{"$f":"\"Opp Run Avg: \"&IF(C28>0,ROUNDUP(SUM(Results!E3:E12)/C28,2),0)","v":"Opp Run Avg: 20.86"}]