{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Standings","Scores","Teams","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"Standings","index":0,"n_rows":9,"n_cols":21,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Standings"]
["Place","Team Name","Wins","Losses","Win Pct",null,null,null,null,null,null,null,null,"Row Labels","Count of Winning team","Row Labels","Count of Losing Team","Team","Wins","Losses","Win Pct"]
["1st",{"$f":"Standings!R5","v":"Prairie Hawks Orange"},{"$f":"IFERROR(Standings!S5,0)","v":5},{"$f":"IFERROR(Standings!T5,0)","v":0},{"$f":"IF(B3=0,-0.000001,IF(D3=0, 100%, C3/(C3+D3)))","v":1},null,null,null,null,null,null,null,null,"Linn-Mar Lions",2,"J-Hawks White",5,{"$f":"Teams!B2","v":"J-Hawks White"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R3)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R3)","v":5},{"$f":"S3/(T3+S3)","v":{"$error":"#REF!"}}]
["2nd",{"$f":"Standings!R4","v":"Marion Gold"},{"$f":"IFERROR(Standings!S4,0)","v":2},{"$f":"IFERROR(Standings!T4,0)","v":1},{"$f":"IF(B4=0,-0.000001,IF(D4=0, 100%, C4/(C4+D4)))","v":0.66666666666666663},null,null,null,null,null,null,null,null,"Marion Gold",2,"Linn-Mar Lions",1,{"$f":"Teams!B3","v":"Marion Gold"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R4)","v":2},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R4)","v":1},0.66666666666666663]
["3rd",{"$f":"Standings!R7","v":"Linn-Mar Lions"},{"$f":"IFERROR(Standings!S7,0)","v":2},{"$f":"IFERROR(Standings!T7,0)","v":1},{"$f":"IF(B5=0,-0.000001,IF(D5=0, 100%, C5/(C5+D5)))","v":0.66666666666666663},null,null,null,null,null,null,null,null,"Prairie Hawks Orange",5,"Linn-Mar Pride",1,{"$f":"Teams!B4","v":"Prairie Hawks Orange"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R5)","v":5},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R5)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["4th",{"$f":"Standings!R6","v":"Springville O's"},{"$f":"IFERROR(Standings!S6,0)","v":1},{"$f":"IFERROR(Standings!T6,0)","v":2},{"$f":"IF(B6=0,-0.000001,IF(D6=0, 100%, C6/(C6+D6)))","v":0.33333333333333331},null,null,null,null,null,null,null,null,"Springville O's",1,"Marion Gold",1,{"$f":"Teams!B5","v":"Springville O's"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R6)","v":1},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R6)","v":2},0.33333333333333331]
["5th",{"$f":"Standings!R8","v":"Linn-Mar Pride"},{"$f":"IFERROR(Standings!S8,0)","v":0},{"$f":"IFERROR(Standings!T8,0)","v":1},{"$f":"IF(B7=0,-0.000001,IF(D7=0, 100%, C7/(C7+D7)))","v":0},null,null,null,null,null,null,null,null,"(blank)",null,"Springville O's",2,{"$f":"Teams!B6","v":"Linn-Mar Lions"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R7)","v":2},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R7)","v":1},0.66666666666666663]
["6th",{"$f":"Standings!R3","v":"J-Hawks White"},{"$f":"IFERROR(Standings!S3,0)","v":0},{"$f":"IFERROR(Standings!T3,0)","v":5},{"$f":"IF(B8=0,-0.000001,IF(D8=0, 100%, C8/(C8+D8)))","v":0},null,null,null,null,null,null,null,null,"Grand Total",10,"(blank)",null,{"$f":"Teams!B7","v":"Linn-Mar Pride"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R8)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R8)","v":1},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",10]

{"sheet":"Scores","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Date","Winning team","Score","Losing Team","Score"]
["2022-04-19","Prairie Hawks Orange",11,"J-Hawks White",7]
["2022-04-26","Prairie Hawks Orange",18,"J-Hawks White",11]
["2022-05-10","Marion Gold",11,"J-Hawks White",10]
["2022-05-10","Prairie Hawks Orange",12,"Linn-Mar Pride",11]
["2022-05-11","Linn-Mar Lions",5,"Springville O's",5]
["2022-05-17","Prairie Hawks Orange",17,"Linn-Mar Lions",9]
["2022-05-17","Springville O's",7,"J-Hawks White",6]
["2022-05-19","Prairie Hawks Orange",10,"Marion Gold",1]
["2022-05-23","Marion Gold",8,"Springville O's",7]
["2022-05-24","Linn-Mar Lions",12,"J-Hawks White",4]

{"sheet":"Teams","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Enter Team Names"]
[1,"J-Hawks White"]
[2,"Marion Gold"]
[3,"Prairie Hawks Orange"]
[4,"Springville O's"]
[5,"Linn-Mar Lions"]
[6,"Linn-Mar Pride"]

{"sheet":"Instructions","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["INSTRUCTIONS"]
[]
["Step 1","Go to Teams tab and enter all of your teams for the division"]
["Step 2","Go to Standings tab and click on Refresh button to show teams"]
["Step 3","Go to Scores and enter date, Winning team (Drop Down), and Score"]
["Step 4","Go to Scores and enter date, Losing team (Drop Down), and Score"]
["Step 5 ","Go to Standings tab and click on Refresh button to show updated league standings"]
[]
["Warning!!","Do NOT CHANGE/OVERWRITE/ADD ANY TABS OR MACROS"]