Excel Model that keeps track of basketball statistics
Hello all,
So I need some help on how to best build a model that does the following: 1) Keeps track of the stats for all players that played in a particular game 2) Allows me to easily see the stats for any one player for all games that player has participated in 3) Easy input of stats on a per game basis.
Some ideas that come to mind are using indirects and delegating a separate tab per player...however what I think would be really cool would be to have one input sheet that has all the games played, and then an output sheet where I can type a name and see his stats for every game he has played in.
p.s. this is for the pickup games my friends and I play every so often.
Besides the fact that this is a bit ridiculous, thoughts? lol
seems reasonable, i use excel for everything, indirects will work, i will have a few macros that might help you if you're into vba.
I think this is do-able in your parameters. I don't know an easy way to do the first part.... but get the box scores for every game into a tab. I think one way to track the game (my first copy/paste didn't have team names copied...) is to insert a line after every game w/ a line that has like ["GAME TEAMS"] [WINNING TEAM] [LOSING TEAM]
In a separate sheet have the player's name (if you're really nerdy about this create a drop down list of all player names. You can do this through some array formulas which can get u each unique name once. Have the first line be the average for all games below or sum through those respective formulas. After that, you can have it find the first time the player was mentioned, second time, etc. and then work off that row # for other stats (once again, there's an array formula for this which you can feed in just the player name and Nth game). For games won versus lost and team names u can find the first "GAME TEAMS" after the player's name.
And yes I learned how to do all this while working for work related stuff..... lol
gl!!
Would love a copy of this when it's done hahahaha. Remind me to invite you to next year's WSO fantasy basketball league
Et est optio reprehenderit suscipit voluptate beatae. Iste quia quidem expedita voluptatem. Corporis suscipit delectus voluptatum odit. Reprehenderit veritatis cumque dolorem tempora et est deleniti.
Ipsam modi nam est cupiditate error blanditiis. Non omnis nostrum illum veniam veniam nobis alias voluptatibus. Aliquam velit numquam fuga dolorem aut culpa itaque. Dignissimos sit fuga sed quia odio veniam.
Aliquid eum asperiores et. Voluptas veritatis nostrum qui omnis quia et. Error ipsa sint nisi quisquam unde. Aut nostrum accusantium vero vero sit. Nemo et est temporibus in.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...