{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Entry Sheet","Home Team","Visiting Team","Info","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"1900"}

{"sheet":"Entry Sheet","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Save File as \"NCABL Game XX\" prior to sending to statistician, league office, website manager and home and visitng managers."]
["Enter information in blue cells only"]
["Macros must be enabled to use the all functions of this worksheet"]
[]
[]
["Home Team:"]
["Visiting Team:"]
["Game Number:"]
["Date of Game:"]
["Report Submitted By:"]
["Date Report Submitted:"]

{"sheet":"Home Team","index":1,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,15],[4,7,4,11],[5,7,5,11],[6,7,6,11],[3,7,3,11],[1,3,1,8],[4,3,4,6],[5,3,5,6],[6,3,6,6],[3,3,3,6],[9,1,10,2],[52,2,52,7],[49,2,49,7],[50,2,50,7],[50,8,50,16],[51,8,51,16],[48,8,48,16],[49,8,49,16],[52,8,52,16],[45,0,45,1],[46,0,46,1],[51,2,51,7],[48,2,48,7],[37,0,37,1],[36,0,36,1]]}
[null,"NCABL Game Report"]
[null,null,null,"www.ncabl.ab.ca"]
[]
[null,null,null,"Game No:",null,null,null,{"$f":"'Entry Sheet'!B8","v":0}]
[null,null,null,"Submitted by:",null,null,null,{"$f":"'Entry Sheet'!B10","v":0}]
[null,null,null,"Date of Game:",null,null,null,{"$f":"'Entry Sheet'!B9","v":"00:00:00"}]
[null,null,null,"Date Submitted:",null,null,null,{"$f":"'Entry Sheet'!B11","v":"00:00:00"}]
[]
[]
[null,{"$f":"'Entry Sheet'!B6","v":0},null,null,"Score",null,1,2,3,4,5,6,7,8,9,"R","H","E"]
[null,null,null,null,"Visitor",null,null,null,null,null,null,null,null,null,null,{"$f":"'Visiting Team'!F37","v":0},{"$f":"'Visiting Team'!E37","v":0},{"$f":"'Visiting Team'!R37","v":0}]
[null,"Team",null,null,"Home",null,null,null,null,null,null,null,null,null,null,{"$f":"F37","v":0},{"$f":"E37","v":0},{"$f":"R37","v":0}]
[]
["Alphabetical Order - Last Name First"]
["No.","Player","PA","AB","H","R","RBI","2B","3B","HR","SAC","SF","HP","BB","K","SB","CS","E"]
[null,null,{"$f":"IF(B16<>\"\",N16+M16+L16+K16+D16,\"\")","v":""}]
[null,null,{"$f":"IF(B17<>\"\",N17+M17+L17+K17+D17,\"\")","v":""}]
[null,null,{"$f":"IF(B18<>\"\",N18+M18+L18+K18+D18,\"\")","v":""}]
[null,null,{"$f":"IF(B19<>\"\",N19+M19+L19+K19+D19,\"\")","v":""}]
[null,null,{"$f":"IF(B20<>\"\",N20+M20+L20+K20+D20,\"\")","v":""}]
[null,null,{"$f":"IF(B21<>\"\",N21+M21+L21+K21+D21,\"\")","v":""}]
[null,null,{"$f":"IF(B22<>\"\",N22+M22+L22+K22+D22,\"\")","v":""}]
[null,null,{"$f":"IF(B23<>\"\",N23+M23+L23+K23+D23,\"\")","v":""}]
[null,null,{"$f":"IF(B24<>\"\",N24+M24+L24+K24+D24,\"\")","v":""}]
[null,null,{"$f":"IF(B25<>\"\",N25+M25+L25+K25+D25,\"\")","v":""}]
[null,null,{"$f":"IF(B26<>\"\",N26+M26+L26+K26+D26,\"\")","v":""}]
[null,null,{"$f":"IF(B27<>\"\",N27+M27+L27+K27+D27,\"\")","v":""}]
[null,null,{"$f":"IF(B28<>\"\",N28+M28+L28+K28+D28,\"\")","v":""}]
[null,null,{"$f":"IF(B29<>\"\",N29+M29+L29+K29+D29,\"\")","v":""}]
[null,null,{"$f":"IF(B30<>\"\",N30+M30+L30+K30+D30,\"\")","v":""}]
[null,null,{"$f":"IF(B31<>\"\",N31+M31+L31+K31+D31,\"\")","v":""}]
[null,null,{"$f":"IF(B32<>\"\",N32+M32+L32+K32+D32,\"\")","v":""}]
[null,null,{"$f":"IF(B33<>\"\",N33+M33+L33+K33+D33,\"\")","v":""}]
[null,null,{"$f":"IF(B34<>\"\",N34+M34+L34+K34+D34,\"\")","v":""}]
[null,null,{"$f":"IF(B35<>\"\",N35+M35+L35+K35+D35,\"\")","v":""}]
[]
["Team Totals",null,{"$f":"SUM(C16:C36)","v":0},{"$f":"SUM(D16:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Legend",null,"Plate Appearances","At Bats","Hits","Runs","Runs Batted in","Doubles","Triples","Home Runs","Sacrifice Bunt","Sacrifice Fly","Hit By Pitch","Base on Balls","Strikeout","Stolen Base","Caught Stealing","Error"]
[]
["No.","Pitcher","IP","BF","H","R","ER","BB","K","HR","BK","WP","HB","W","L","S","CG"]
[]
[]
[]
[]
[]
["Team Totals",null,{"$f":"SUM(C41:C45)","v":0},{"$f":"SUM(D41:D45)","v":0},{"$f":"SUM(E41:E45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Legend",null,"Innings Pitched","Batters Faced","Hits","Runs","Earned Runs","Base on Balls","Strikeout","Home Runs","Balks","Wild Pitches","Hit Batters","Win","Loss","Save","Complete Game"]
[]
["Email game summary forms to:",null,"Statistician  ",null,null,null,null,null,"ryan.petryshyn@shaw.ca"]
[null,null,"League office  ",null,null,null,null,null,"prriopel@telusplanet.net"]
[null,null,"Website manager",null,null,null,null,null,"websitemanager@ncabl.ab.ca"]
[null,null,"Home Manager  ",null,null,null,null,null,{"$f":"VLOOKUP('Entry Sheet'!B6,Info!$A$2:$C$11,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Visiting Manager  ",null,null,null,null,null,{"$f":"VLOOKUP('Entry Sheet'!B7,Info!$A$2:$C$11,3,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Visiting Team","index":2,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,8,52,16],[51,8,51,16],[49,8,49,16],[48,8,48,16],[52,2,52,7],[51,2,51,7],[49,2,49,7],[48,2,48,7],[0,1,0,15],[1,3,1,8],[3,3,3,6],[3,7,3,11],[4,3,4,6],[4,7,4,11],[9,1,10,2],[50,2,50,7],[50,8,50,16],[5,3,5,6],[5,7,5,11],[6,3,6,6],[6,7,6,11],[37,0,37,1],[45,0,45,1],[46,0,46,1],[36,0,36,1]]}
[null,"NCABL Game Report"]
[null,null,null,"www.ncabl.ab.ca"]
[]
[null,null,null,"Game No:",null,null,null,{"$f":"'Entry Sheet'!B8","v":0}]
[null,null,null,"Submitted by:",null,null,null,{"$f":"'Entry Sheet'!B10","v":0}]
[null,null,null,"Date of Game:",null,null,null,{"$f":"'Entry Sheet'!B9","v":"00:00:00"}]
[null,null,null,"Date Submitted:",null,null,null,{"$f":"'Entry Sheet'!B11","v":"00:00:00"}]
[]
[]
[null,{"$f":"'Entry Sheet'!B7","v":0},null,null,"Score",null,1,2,3,4,5,6,7,8,9,"R","H","E"]
[null,null,null,null,"Visitor",null,{"$f":"IF('Home Team'!G11=\"\",\"\", 'Home Team'!G11 )","v":""},{"$f":"IF('Home Team'!H11=\"\",\"\", 'Home Team'!H11 )","v":""},{"$f":"IF('Home Team'!I11=\"\",\"\", 'Home Team'!I11 )","v":""},{"$f":"IF('Home Team'!J11=\"\",\"\", 'Home Team'!J11 )","v":""},{"$f":"IF('Home Team'!K11=\"\",\"\", 'Home Team'!K11 )","v":""},{"$f":"IF('Home Team'!L11=\"\",\"\", 'Home Team'!L11 )","v":""},{"$f":"IF('Home Team'!M11=\"\",\"\", 'Home Team'!M11 )","v":""},{"$f":"IF('Home Team'!N11=\"\",\"\", 'Home Team'!N11 )","v":""},{"$f":"IF('Home Team'!O11=\"\",\"\", 'Home Team'!O11 )","v":""},{"$f":"'Visiting Team'!F37","v":0},{"$f":"'Visiting Team'!E37","v":0},{"$f":"'Visiting Team'!R37","v":0}]
[null,"Team",null,null,"Home",null,{"$f":"IF('Home Team'!G12=\"\",\"\", 'Home Team'!G12)","v":""},{"$f":"IF('Home Team'!H12=\"\",\"\", 'Home Team'!H12)","v":""},{"$f":"IF('Home Team'!I12=\"\",\"\", 'Home Team'!I12)","v":""},{"$f":"IF('Home Team'!J12=\"\",\"\", 'Home Team'!J12)","v":""},{"$f":"IF('Home Team'!K12=\"\",\"\", 'Home Team'!K12)","v":""},{"$f":"IF('Home Team'!L12=\"\",\"\", 'Home Team'!L12)","v":""},{"$f":"IF('Home Team'!M12=\"\",\"\", 'Home Team'!M12)","v":""},{"$f":"IF('Home Team'!N12=\"\",\"\", 'Home Team'!N12)","v":""},{"$f":"IF('Home Team'!O12=\"\",\"\", 'Home Team'!O12)","v":""},{"$f":"'Home Team'!F37","v":0},{"$f":"'Home Team'!E37","v":0},{"$f":"'Home Team'!R37","v":0}]
[]
["Alphabetical Order - Last Name First"]
["No.","Player","PA","AB","H","R","RBI","2B","3B","HR","SAC","SF","HP","BB","K","SB","CS","E"]
[null,null,{"$f":"IF(B16<>\"\",D16+K16+L16+M16+N16,\"\")","v":""}]
[null,null,{"$f":"IF(B17<>\"\",D17+K17+L17+M17+N17,\"\")","v":""}]
[null,null,{"$f":"IF(B18<>\"\",D18+K18+L18+M18+N18,\"\")","v":""}]
[null,null,{"$f":"IF(B19<>\"\",D19+K19+L19+M19+N19,\"\")","v":""}]
[null,null,{"$f":"IF(B20<>\"\",D20+K20+L20+M20+N20,\"\")","v":""}]
[null,null,{"$f":"IF(B21<>\"\",D21+K21+L21+M21+N21,\"\")","v":""}]
[null,null,{"$f":"IF(B22<>\"\",D22+K22+L22+M22+N22,\"\")","v":""}]
[null,null,{"$f":"IF(B23<>\"\",D23+K23+L23+M23+N23,\"\")","v":""}]
[null,null,{"$f":"IF(B24<>\"\",D24+K24+L24+M24+N24,\"\")","v":""}]
[null,null,{"$f":"IF(B25<>\"\",D25+K25+L25+M25+N25,\"\")","v":""}]
[null,null,{"$f":"IF(B26<>\"\",D26+K26+L26+M26+N26,\"\")","v":""}]
[null,null,{"$f":"IF(B27<>\"\",D27+K27+L27+M27+N27,\"\")","v":""}]
[null,null,{"$f":"IF(B28<>\"\",D28+K28+L28+M28+N28,\"\")","v":""}]
[null,null,{"$f":"IF(B29<>\"\",D29+K29+L29+M29+N29,\"\")","v":""}]
[null,null,{"$f":"IF(B30<>\"\",D30+K30+L30+M30+N30,\"\")","v":""}]
[null,null,{"$f":"IF(B31<>\"\",D31+K31+L31+M31+N31,\"\")","v":""}]
[null,null,{"$f":"IF(B32<>\"\",D32+K32+L32+M32+N32,\"\")","v":""}]
[null,null,{"$f":"IF(B33<>\"\",D33+K33+L33+M33+N33,\"\")","v":""}]
[null,null,{"$f":"IF(B34<>\"\",D34+K34+L34+M34+N34,\"\")","v":""}]
[null,null,{"$f":"IF(B35<>\"\",D35+K35+L35+M35+N35,\"\")","v":""}]
[]
["Team Totals",null,{"$f":"SUM(C16:C36)","v":0},{"$f":"SUM(D16:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Legend",null,"Plate Appearances","At Bats","Hits","Runs","Runs Batted in","Doubles","Triples","Home Runs","Sacrifice Bunt","Sacrifice Fly","Hit By Pitch","Base on Balls","Strikeout","Stolen Base","Caught Stealing","Error"]
[]
["No.","Pitcher","IP","BF","H","R","ER","BB","K","HR","BK","WP","HB","W","L","S","CG"]
[]
[]
[]
[]
[]
["Team Totals",null,{"$f":"SUM(C41:C45)","v":0},{"$f":"SUM(D41:D45)","v":0},{"$f":"SUM(E41:E45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Legend",null,"Innings Pitched","Batters Faced","Hits","Runs","Earned Runs","Base on Balls","Strikeout","Home Runs","Balks","Wild Pitches","Hit Batters","Win","Loss","Save","Complete Game"]
[]
["Email game summary forms to:",null,"Statistician  ",null,null,null,null,null,"ryan.petryshyn@shaw.ca"]
[null,null,"League office  ",null,null,null,null,null,"prriopel@telusplanet.net"]
[null,null,"Website manager",null,null,null,null,null,"websitemanager@ncabl.ab.ca"]
[null,null,"Home Manager  ",null,null,null,null,null,{"$f":"VLOOKUP('Entry Sheet'!B6,Info!$A$2:$C$11,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Visiting Manager  ",null,null,null,null,null,{"$f":"VLOOKUP('Entry Sheet'!B7,Info!$A$2:$C$11,3,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Info","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Teams","Manager Names","Manager Emails",null,null,null,null,null,"Teams for dropdown"]
["Barrhead Orioles","Chase Visser","chase.visser8@yahoo.com",null,null,2023,null,null,{"$f":"_xlfn.UNIQUE(A2:A11)","v":"Barrhead Orioles"}]
["Barrhead Orioles","Brenden Meier","brandenmeier01@gmail.com",null,null,2023,null,null,"Ft. Saskatchewan Reds"]
["Ft. Saskatchewan Reds","Randy Stawnichy","stawnich@telus.net",null,null,2023,null,null,"Parkland Twins"]
["Ft. Saskatchewan Reds","Tanner Stawnichy","tstawnichy@hotmail.com",null,null,2023,null,null,"St. Albert Cardinals"]
["Parkland Twins","Joe Pasychnyk","josefpasychnyk@gmail.com",null,null,2023,null,null,"Westlock Red Lions"]
["Parkland Twins","Mike Cassidy","mikecassidy1992@gmail.com",null,null,2023]
["St. Albert Cardinals","Zach Pollard","zach30.zp@gmail.com",null,null,2023]
["St. Albert Cardinals","Robert Sullivan","rsllvn4@gmail.com",null,null,2023]
["Westlock Red Lions","Chris Brand","cbrand17@hotmail.com",null,null,2023]
["Westlock Red Lions","Jordan Brand","jbrand31@hotmail.com",null,null,2023]

{"sheet":"Sheet1","index":4,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Barrhead Orioles:","Warren Warehime","warrenwarehime@gmail.com",null,null,null,null,null,null,"Teams","Manager Names","Manager Emails"]
["Camrose Axemen:","Kris Kushnerick","kriskush@hotmail.com",null,null,null,null,null,null,"Barrhead Orioles","Warren Warehime","warrenwarehime@gmail.com",null,null,2016]
["Edmonton Athletics:","Mark Trela","mark@sil.ab.ca",null,null,null,null,null,null,"Camrose Axemen","Kris Kushnerick","kriskush@hotmail.com",null,null,2016]
["Edmonton Blackhawks:","Randy Gregg","rjgregg@shaw.ca",null,null,null,null,null,null,"Edmonton Athletics","Mark Trela","mark@sil.ab.ca",null,null,2016]
["Edmonton Primeaus:","Kyle Fagnan","kjf_28@hotmail.com",null,null,null,null,null,null,"Edmonton Blackhawks","Randy Gregg","rjgregg@shaw.ca",null,null,2016]
["St. Albert Cardinals:","Ed Ewasiuk","ed.ewasiuk@stantec.com",null,null,null,null,null,null,"Edmonton Primeaus","Kyle Fagnan","kjf_28@hotmail.com",null,null,2016]
["Sherwood Park Athletics:","Pat McElroy","pat.mcelroy@ca.weatherford.com",null,null,null,null,null,null,"St. Albert Cardinals","Ed Ewasiuk","ed.ewasiuk@stantec.com",null,null,2016]
["Stony Plain Mets","Brad Walde","B_Walde@hotmail.com",null,null,null,null,null,null,"Sherwood Park Athletics","Pat McElroy","pat.mcelroy@ca.weatherford.com",null,null,2016]
["Sturgeon Paladins:","Bryan Bartman","bryan@acircuit.ca",null,null,null,null,null,null,"Stony Plain Mets","Brad Walde","B_Walde@hotmail.com",null,null,2016]
["Westlock Red Lions:","Adam Sawatzky","asawatzky@brenntag.ca",null,null,null,null,null,null,"Sturgeon Paladins","Bryan Bartman","bryan@acircuit.ca",null,null,2016]
[null,null,null,null,null,null,null,null,null,"Westlock Red Lions","Adam Sawatzky","asawatzky@brenntag.ca",null,null,2016]