{"product_id":"youth-sports-team-roster-tracker","title":"Youth Sports Team Roster Tracker Spreadsheet","description":"\u003cp\u003eThis team roster tracker is for volunteer coaches and team managers running a youth sports squad through a season. It works out fair playing time, keeps attendance one session at a time and shows which families still owe the season fee.\u003c\/p\u003e\u003cp\u003eEvery youth coach eventually hears the question of whether a child is getting a fair go. The Playing Time tab answers it with numbers: minutes on the field against a fair share of the minutes available, over the games each player actually attended.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Pick Whole team or one player and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eAttendance:\u003c\/strong\u003e across the season, with a bar for every session\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe squad:\u003c\/strong\u003e shirt, name, position, attendance, minutes and fees for every player\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWho came:\u003c\/strong\u003e players at every game and practice, and the sessions a player missed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMinutes, game by game,\u003c\/strong\u003e against the fair share, with anyone under your line in soft red\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBy position:\u003c\/strong\u003e how the squad splits across positions\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eFees:\u003c\/strong\u003e money collected week by week, what is still owed, and by how many players\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFair minutes, worked out:\u003c\/strong\u003e a column per game with each player's minutes. The tab calculates a fair share for everyone who turned up, adds it up across the season and flags anyone below the line you set on Setup\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEvery game checked:\u003c\/strong\u003e minutes logged are compared with game length times players on the field, so a typo shows up the day you make it\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAttendance:\u003c\/strong\u003e Y or N per player for each session, with a rate per player, a count at each session, and games shaded apart from practices\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTeam fees:\u003c\/strong\u003e the season fee comes from Setup, a discount can be typed over it, and payments add up on the roster\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Roster, Attendance, Playing Time, Payments and Dashboard. Children's details are kept to a first name, a position and a parent to call. The worked example is an eight-week spring soccer roster for a fourteen-player under-11 side, with practice twice a week and a game on Saturday: 24 sessions, 8 games, two players flagged for low minutes and three families still owing fees. It is a ready coaching template and attendance tracker you can adapt to any sport and season.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow is a fair share of playing time worked out?\u003c\/h3\u003e\u003cp\u003eFor each game, the tab shares the available minutes among the players who turned up, adds each player's share across the season and compares it with the minutes they actually played.\u003c\/p\u003e\u003ch3\u003eIs it only for soccer?\u003c\/h3\u003e\u003cp\u003eNo. The example is a youth soccer team, but you set the game length and players on the field, so it works for other team sports too.\u003c\/p\u003e\u003ch3\u003eCan it track season fees and discounts?\u003c\/h3\u003e\u003cp\u003eYes. The season fee comes from Setup, a discount such as a sibling rate can be typed over it, and the dashboard lists who still owes.\u003c\/p\u003e\u003ch3\u003eWhat personal details does it store?\u003c\/h3\u003e\u003cp\u003eOnly a first name, a position and a parent to call for each child.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597872300126,"sku":"OPX-218","price":14.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/youth-sports-team-roster-tracker-01.jpg?v=1790833170","url":"https:\/\/opxviashop.com\/products\/youth-sports-team-roster-tracker","provider":"OPXVIA","version":"1.0","type":"link"}