Ranking Based on Criteria

I'm looking to rank some categories based on criteria from other cells. I have 12 people who will receive a score in four different categories. I want to rank them by their finish according to my scale I've included and add up their composite score of the four categories to one whole number. There are 3 numbers in the scale, 3 being the best and one being the worst. So for the Top 4 finishers at each cateogory I want them to receive a 3 for that category, and same with the middle 4 to receive a 2 and the bottom 4 to receive a 1.

This is easy to do manually if the numbers and amount of players weren't consistently changing. For example, if I start out with 12 players and then two more players get added to the sheet that is going to affect the rest of the players. I would then want the category scale to now be divisible by 14 players instead of 12. Also, I'd need to calculate in if a players category score changes that the rest of the players are now affected as well.

I've attached my worksheet. Thanks!