2022-2023 Celtics MPG and Total Minutes Projection

Here is a little spreadsheet I made.  I hope it isn't too wide for this forum.  I'll insert it using two different settings in case it cuts off the right side at the higher setting for some members.

I have projected each player's minutes per game (MPG) as well as their total minutes for the regular season.

I tried to balance the minutes per game vs. the total minutes and games played.  That is a hard juggling act because no one player actually plays all 82 games.  I know that there are only 48 minutes per game, so the result when adding each players MPG tends to be more than 48 per in the final tally.  I randomly picked 60 as my cutoff number.  It could be more, it could be less, I just did not want to spend the time researching for the typical average.

The important part is taking the player's MPG, projecting how many games they would play and coming up with a season total.  I added the previous season as an example as to how the minutes were spread around before, with a goal of reducing the total minutes for some players.

There are a few other items I added, like their full names and their nicknames (found online).

I may tweak the spreadsheet after a couple of the TBD players are determined and maybe after I get some feedback.

Here it is:

1024 px width:




800 px width:



My comments: It came out a little smaller than I'd like. I'll mess with it, making some columns narrower, etc., in order to get the text to appear larger.

I hope this one reads better, I got rid of the nicknames column, etc,:

Smaller version: