{"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":18,"n_cols":21,"rows_kept":18,"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!R7","v":"CPU Storm"},{"$f":"IFERROR(Standings!S7,0)","v":5},{"$f":"IFERROR(Standings!T7,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,"Alburnett Pirates",1,"Alburnett Pirates",2,{"$f":"Teams!B2","v":"CR Cougars Green"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R3)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R3)","v":2},{"$f":"S3/(T3+S3)","v":{"$error":"#REF!"}}]
["2nd",{"$f":"Standings!R5","v":"MV Mustangs"},{"$f":"IFERROR(Standings!S5,0)","v":3},{"$f":"IFERROR(Standings!T5,0)","v":2},{"$f":"IF(B4=0,-0.000001,IF(D4=0, 100%, C4/(C4+D4)))","v":0.6},null,null,null,null,null,null,null,null,"CPU Storm",5,"CR Cougars Green",2,{"$f":"Teams!B3","v":"Saints Navy"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R4)","v":2},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R4)","v":3},0.4]
["3rd",{"$f":"Standings!R6","v":"Martelle Tigers"},{"$f":"IFERROR(Standings!S6,0)","v":2},{"$f":"IFERROR(Standings!T6,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,"Linn-Mar Gray",2,"CR Warriors ",1,{"$f":"Teams!B4","v":"MV Mustangs"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R5)","v":3},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R5)","v":2},0.6]
["4th",{"$f":"Standings!R12","v":"Linn-Mar Gray"},{"$f":"IFERROR(Standings!S12,0)","v":2},{"$f":"IFERROR(Standings!T12,0)","v":3},{"$f":"IF(B6=0,-0.000001,IF(D6=0, 100%, C6/(C6+D6)))","v":0.4},null,null,null,null,null,null,null,null,"Linn-Mar Silver",2,"Linn-Mar Gray",3,{"$f":"Teams!B5","v":"Martelle Tigers"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R6)","v":2},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R6)","v":1},0.66666666666666663]
["5th",{"$f":"Standings!R13","v":"Linn-Mar Silver"},{"$f":"IFERROR(Standings!S13,0)","v":2},{"$f":"IFERROR(Standings!T13,0)","v":3},{"$f":"IF(B7=0,-0.000001,IF(D7=0, 100%, C7/(C7+D7)))","v":0.4},null,null,null,null,null,null,null,null,"Martelle Tigers",2,"Linn-Mar Silver",3,{"$f":"Teams!B6","v":"CPU Storm"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R7)","v":5},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R7)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["6th",{"$f":"Standings!R4","v":"Saints Navy"},{"$f":"IFERROR(Standings!S4,0)","v":2},{"$f":"IFERROR(Standings!T4,0)","v":3},{"$f":"IF(B8=0,-0.000001,IF(D8=0, 100%, C8/(C8+D8)))","v":0.4},null,null,null,null,null,null,null,null,"MV Mustangs",3,"Martelle Tigers",1,{"$f":"Teams!B7","v":"Solon All Stars"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R8)","v":1},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R8)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["7th",{"$f":"Standings!R15","v":"Prairie Hawks Black"},{"$f":"IFERROR(Standings!S15,0)","v":1},{"$f":"IFERROR(Standings!T15,0)","v":0},{"$f":"IF(B9=0,-0.000001,IF(D9=0, 100%, C9/(C9+D9)))","v":1},null,null,null,null,null,null,null,null,"Prairie Hawks Black",1,"MV Mustangs",2,{"$f":"Teams!B8","v":"Alburnett Pirates"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R9)","v":1},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R9)","v":2},0.33333333333333331]
["8th",{"$f":"Standings!R8","v":"Solon All Stars"},{"$f":"IFERROR(Standings!S8,0)","v":1},{"$f":"IFERROR(Standings!T8,0)","v":0},{"$f":"IF(B10=0,-0.000001,IF(D10=0, 100%, C10/(C10+D10)))","v":1},null,null,null,null,null,null,null,null,"Saints Navy",2,"Saints Navy",3,{"$f":"Teams!B9","v":"North Liunn Lynx"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R10)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R10)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["9th",{"$f":"Standings!R9","v":"Alburnett Pirates"},{"$f":"IFERROR(Standings!S9,0)","v":1},{"$f":"IFERROR(Standings!T9,0)","v":2},{"$f":"IF(B11=0,-0.000001,IF(D11=0, 100%, C11/(C11+D11)))","v":0.33333333333333331},null,null,null,null,null,null,null,null,"Solon All Stars",1,"Vinton Vikings",3,{"$f":"Teams!B10","v":"CR Warriors "},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R11)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R11)","v":1},{"$error":"#REF!"}]
["10th",{"$f":"Standings!R14","v":"Vinton Vikings"},{"$f":"IFERROR(Standings!S14,0)","v":1},{"$f":"IFERROR(Standings!T14,0)","v":3},{"$f":"IF(B12=0,-0.000001,IF(D12=0, 100%, C12/(C12+D12)))","v":0.25},null,null,null,null,null,null,null,null,"Vinton Vikings",1,"(blank)",null,{"$f":"Teams!B11","v":"Linn-Mar Gray"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R12)","v":2},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R12)","v":3},0.4]
["11th",{"$f":"Standings!R10","v":"North Liunn Lynx"},{"$f":"IFERROR(Standings!S10,0)","v":0},{"$f":"IFERROR(Standings!T10,0)","v":0},{"$f":"IF(B13=0,-0.000001,IF(D13=0, 100%, C13/(C13+D13)))","v":1},null,null,null,null,null,null,null,null,"(blank)",null,"Grand Total",20,{"$f":"Teams!B12","v":"Linn-Mar Silver"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R13)","v":2},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R13)","v":3},0.4]
["12th",{"$f":"Standings!R11","v":"CR Warriors "},{"$f":"IFERROR(Standings!S11,0)","v":0},{"$f":"IFERROR(Standings!T11,0)","v":1},{"$f":"IF(B14=0,-0.000001,IF(D14=0, 100%, C14/(C14+D14)))","v":0},null,null,null,null,null,null,null,null,"Grand Total",20,null,null,{"$f":"Teams!B13","v":"Vinton Vikings"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R14)","v":1},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R14)","v":3},0.25]
["13th",{"$f":"Standings!R3","v":"CR Cougars Green"},{"$f":"IFERROR(Standings!S3,0)","v":0},{"$f":"IFERROR(Standings!T3,0)","v":2},{"$f":"IF(B15=0,-0.000001,IF(D15=0, 100%, C15/(C15+D15)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Teams!B14","v":"Prairie Hawks Black"},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R15)","v":1},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R15)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["14th",{"$f":"Standings!R16","v":0},{"$f":"IFERROR(Standings!S16,0)","v":0},{"$f":"IFERROR(Standings!T16,0)","v":0},{"$f":"IF(B16=0,-0.000001,IF(D16=0, 100%, C16/(C16+D16)))","v":-9.9999999999999995E-7},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Teams!B15","v":0},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R16)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R16)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["15th",{"$f":"Standings!R17","v":0},{"$f":"IFERROR(Standings!S17,0)","v":0},{"$f":"IFERROR(Standings!T17,0)","v":0},{"$f":"IF(B17=0,-0.000001,IF(D17=0, 100%, C17/(C17+D17)))","v":-9.9999999999999995E-7},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Teams!B16","v":0},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R17)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R17)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["16th",{"$f":"Standings!R18","v":0},{"$f":"IFERROR(Standings!S18,0)","v":0},{"$f":"IFERROR(Standings!T18,0)","v":0},{"$f":"IF(B18=0,-0.000001,IF(D18=0, 100%, C18/(C18+D18)))","v":-9.9999999999999995E-7},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Teams!B17","v":0},{"$f":"GETPIVOTDATA(\"Winning team\",Standings!$N$2,\"Winning team\",R18)","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Losing Team\",Standings!$P$2,\"Losing Team\",R18)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]

{"sheet":"Scores","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Date","Winning team","Score","Losing Team","Score"]
["2022-04-26","CPU Storm",10,"Linn-Mar Silver",7]
["2022-04-27","MV Mustangs",10,"Linn-Mar Gray",9]
["2022-05-04","Linn-Mar Silver",16,"CR Cougars Green",3]
["2022-05-06","Martelle Tigers",10,"Vinton Vikings",7]
["2022-05-06","MV Mustangs",8,"Saints Navy",2]
["2022-05-10","Martelle Tigers",6,"Linn-Mar Silver",6]
["2022-05-11","MV Mustangs",12,"Alburnett Pirates",4]
["2022-05-12","Prairie Hawks Black",9,"Linn-Mar Silver",8]
["2022-05-12","CPU Storm",14,"MV Mustangs",9]
["2022-05-11","CPU Storm",12,"Vinton Vikings",11]
["2022-05-10","CPU Storm",11,"CR Cougars Green",4]
["2022-05-10","Linn-Mar Gray",10,"Vinton Vikings",8]
["2022-05-17","Linn-Mar Gray",10,"Alburnett Pirates",7]
["2022-04-27","Alburnett Pirates",9,"Saints Navy",0]
["2022-05-12","Vinton Vikings",24,"Saints Navy",5]
["2022-05-17","CPU Storm",14,"CR Warriors ",9]
["2022-05-17","Saints Navy",11,"Martelle Tigers",6]
["2022-05-18","Linn-Mar Silver",13,"MV Mustangs",3]
["2022-05-19","Solon All Stars",11,"Linn-Mar Gray",7]
["2022-05-23","Saints Navy",13,"Linn-Mar Gray",7]

{"sheet":"Teams","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Enter Team Names"]
[1,"CR Cougars Green"]
[2,"Saints Navy"]
[3,"MV Mustangs"]
[4,"Martelle Tigers"]
[5,"CPU Storm"]
[6,"Solon All Stars"]
[7,"Alburnett Pirates"]
[8,"North Liunn Lynx"]
[9,"CR Warriors "]
[10,"Linn-Mar Gray"]
[11,"Linn-Mar Silver"]
[12,"Vinton Vikings"]
[13,"Prairie Hawks Black"]

{"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"]