Quote:
Originally Posted by Captain_Kirch
I do not claim to be an expert in excel, if there's a better way to do what I've done here, kindly suggest it.
|
I think that you actually did quite a good job implementing Excel functions. The
SUMIF function is not one that I see used very much anymore: most people use a combination of
SUM and
IF which ends up being fairly convoluted so I commend you and your sparing usage of functions!
Something that you may consider implementing for the future is a sheet where you can easily look up data for a given team. If you have ever looked at the game announcer tool that sort of resembles what I am getting at. Many teams do this type of thing in their normal scouting spreadsheet so that you can easily look up a team's stats (or in this case projected stats). Just an idea.