I have an interesting problem. It is an Excel, points, and calendar challenge.
I will break this question down into a few questions if I can.
Just imagine you work on a team and every day each player on the team gets a base rate of one point every day. (this is one point at the start but can increase to 1.5 or 2.0 at a later date). Now the goalie has a very hard job so he gets 1.5 additional points everyday on top of the base points.
So here is the logic.
(y)- base rate
X+Y+A = points per day
This is how I am doing this points tracking now….Look at how many columns there are. I need a way to automate this.