This is brilliant! Thank you!! I've used it all season for my little league team (8-12 yr old), and it's been super helpful with planning ahead and showing up prepared on game day. Makes assigning positions fairly a breeze. I haven't had a single complaint from a parent about their kid not getting enough time at any position or a chance at leading off the batting order. THANK YOU!!
First off all thanks a lot for all the works that has been put on these excel sheet. I am having a problem with one cell only. I have a team of 12 players and sometimes i will have 3-4 players that can't be at a game and the cell Y21 on every sheet will give me a blank result or a #ref! error which will then cause a blank result for the next game at the LF postion. Any idea on how to fix this ?
Hello awesome video by the way. Super helpful. I typed in all the info for the first game, and everything is working the way it should except the cumulative game counts under roster heading. not sure if I deleted a formula or typed something in wrong. Could you help and let me know. Thanks a ton.
Hi Bryan, I'm trying to replicate your bug within the Lineups spreadsheets, but the cumulative game counts are working for me. They are based on the "Batting Position Order" data in the cells on the "RosterAndTracking" sheet. Would you please email a screen cap or share your Google Sheet with coachrick@bayislandbaseball.com so I can troubleshoot further? Thanks.
Our league allows 4 outfielders but our team varies between 9 and 10 players. To avoid the lineup card having red I was thinking of adding a N/A player and giving them LCF each inning. Also we never play more than 4 innings, what would be the best way to clear those out on the lineup card? Just delete them? Thank you very much for this.
Wow, that’s a lot of outfielders! Unfortunately, the two versions only track 3 or 4 outfielders. But if you “Save a copy” when accessing the spreadsheet, you can add columns yourself. Have fun!
Hi again. I modified the lineup after already creating the defensive positions and now the defensive positions on the line up card portion is all blank and red. U know why? Thx
Yes! I've just added versions of the template for 9 fielders. Please check the video description for the updated links: ua-cam.com/video/x1JaB763Dbw/v-deo.html
How do you adjust after the game if you only played 5 innings instead of 6. I was thinking to delete the inning 6 column. Love this spreadsheet by the way!
Hey Matthew, glad you find the spreadsheet useful. If you didn’t play a 6th inning, you can clear the positions in the cells for that inning, then add a “Did Not Play” note instead of deleting the column and potentially breaking a formula.
This is an awesome tool for tracking. Looking to use this for my softball team, we play 7 innings. I'm not great with formulas, but trying to insert and "format as line before" to add the 7th innings doesn't work to add to the history of positions played. Is there a simple way to add a 7th inning column?
Nope, digging into it there’s a whole bunch of formulas everywhere and I’m no where savvy enough to figure it out. If anyone does though, I think A LOT of people would appreciate it. Still, it was very helpful through the season.
@@DarrellGeissI figured it out. Well mostly. It’s a 3 step process that you have to do on each sheet. In the top corner of the sheet it begins with column O. The arrow in the box indicates that there are hidden cells. Select the arrow that will then expand and unhide columns A-N which has the current game tracker info. Now go back to the game lineup section and add a column to the right of column AK. Select to highlight all of the cells for both the top and bottom lineups in AK and then drag right to copy the formatting to column AL. That will add the 7th inning. Do the same steps for Defensive positions column AT. Now go back to hidden current game tracker info columns A-L. Starting with the cell C6 (which should be the first of the top row of zeroes) double click to expand the formula. You’ll see there’s a bunch of “if” statements. Copy the last if statement. In this cell it is +IF($AK6=Q$4,1,0). Paste that copy directly after it and change the K in $AK6 to L. Now it should read +IF($AL6=Q$4,1,0). Once you have completed that then you can click to drag down the conditional formatting to the rest of the cells in that column. Just repeat the process for the rest of the cells D6-L6 noting that the only reference value you’re changing is that K to now an L. You have to do this on every sheet. I wouldn’t recommend copy and pasting from one sheet to another as I don’t know what other hidden treats and formulas there that may be affected. This seems to work for me.
Great question! I’ve found copying and pasting positions and cells creates bugs in the spreadsheet. It’s always best to manually type in names and positions into the lineups. It seems like more work, but it will save you from having to start over when copying/pasting breaks the formulas.
This is brilliant! Thank you!! I've used it all season for my little league team (8-12 yr old), and it's been super helpful with planning ahead and showing up prepared on game day. Makes assigning positions fairly a breeze. I haven't had a single complaint from a parent about their kid not getting enough time at any position or a chance at leading off the batting order.
THANK YOU!!
Thank you!! Just what I was looking for
First off all thanks a lot for all the works that has been put on these excel sheet. I am having a problem with one cell only. I have a team of 12 players and sometimes i will have 3-4 players that can't be at a game and the cell Y21 on every sheet will give me a blank result or a #ref! error which will then cause a blank result for the next game at the LF postion. Any idea on how to fix this ?
Thank you so much for creating this. I am not an xcel guy. Is there an easy was to add a 7th inning and have everything still work?
this is incredible. how do you add more games?
Hello awesome video by the way. Super helpful.
I typed in all the info for the first game, and everything is working the way it should except the cumulative game counts under roster heading. not sure if I deleted a formula or typed something in wrong. Could you help and let me know.
Thanks a ton.
Hi Bryan, I'm trying to replicate your bug within the Lineups spreadsheets, but the cumulative game counts are working for me. They are based on the "Batting Position Order" data in the cells on the "RosterAndTracking" sheet. Would you please email a screen cap or share your Google Sheet with coachrick@bayislandbaseball.com so I can troubleshoot further? Thanks.
Our league allows 4 outfielders but our team varies between 9 and 10 players. To avoid the lineup card having red I was thinking of adding a N/A player and giving them LCF each inning. Also we never play more than 4 innings, what would be the best way to clear those out on the lineup card? Just delete them? Thank you very much for this.
This is awesome. Is there a way to add additional OF positions? Our league rules state no one is on the bench. so we can have 6 OFs
Wow, that’s a lot of outfielders! Unfortunately, the two versions only track 3 or 4 outfielders. But if you “Save a copy” when accessing the spreadsheet, you can add columns yourself. Have fun!
Hi again. I modified the lineup after already creating the defensive positions and now the defensive positions on the line up card portion is all blank and red. U know why? Thx
Hello, awesome template. Is there an easy way to limit this to 9 def positions? We only play with 3 outfielders.
Yes! I've just added versions of the template for 9 fielders. Please check the video description for the updated links: ua-cam.com/video/x1JaB763Dbw/v-deo.html
How do you adjust after the game if you only played 5 innings instead of 6. I was thinking to delete the inning 6 column. Love this spreadsheet by the way!
I think if I delete whole 6th inning column it should still compute everything ok ?
Hey Matthew, glad you find the spreadsheet useful. If you didn’t play a 6th inning, you can clear the positions in the cells for that inning, then add a “Did Not Play” note instead of deleting the column and potentially breaking a formula.
This is an awesome tool for tracking. Looking to use this for my softball team, we play 7 innings. I'm not great with formulas, but trying to insert and "format as line before" to add the 7th innings doesn't work to add to the history of positions played. Is there a simple way to add a 7th inning column?
did you ever figure out how tro get the 7th inning to track? I also need 7 innings.
Nope, digging into it there’s a whole bunch of formulas everywhere and I’m no where savvy enough to figure it out. If anyone does though, I think A LOT of people would appreciate it. Still, it was very helpful through the season.
@@DarrellGeissI figured it out. Well mostly. It’s a 3 step process that you have to do on each sheet.
In the top corner of the sheet it begins with column O. The arrow in the box indicates that there are hidden cells.
Select the arrow that will then expand and unhide columns A-N which has the current game tracker info.
Now go back to the game lineup section and add a column to the right of column AK. Select to highlight all of the cells for both the top and bottom lineups in AK and then drag right to copy the formatting to column AL. That will add the 7th inning.
Do the same steps for Defensive positions column AT.
Now go back to hidden current game tracker info columns A-L. Starting with the cell C6 (which should be the first of the top row of zeroes) double click to expand the formula. You’ll see there’s a bunch of “if” statements. Copy the last if statement. In this cell it is +IF($AK6=Q$4,1,0). Paste that copy directly after it and change the K in $AK6 to L. Now it should read +IF($AL6=Q$4,1,0). Once you have completed that then you can click to drag down the conditional formatting to the rest of the cells in that column. Just repeat the process for the rest of the cells D6-L6 noting that the only reference value you’re changing is that K to now an L.
You have to do this on every sheet.
I wouldn’t recommend copy and pasting from one sheet to another as I don’t know what other hidden treats and formulas there that may be affected. This seems to work for me.
Also can u copy And paste the positions after creating the first game to input for the 2nd game? I tried but couldn’t seem to do it
Great question! I’ve found copying and pasting positions and cells creates bugs in the spreadsheet. It’s always best to manually type in names and positions into the lineups. It seems like more work, but it will save you from having to start over when copying/pasting breaks the formulas.
HOW CAN I ADD AN ADDITIONAL ROSTER POSITION? (WE HAVE LEFT PITCHER AND RIGHT PITCHER)
Hi! How do u get to your template on my computer? Thx
The links to each division’s template are in the video description. If you can’t see the links, click “more info” to reveal the links.