data analyzing problem

Hello guys!
Here I have a fairly complicated data analyzing problem.
MY original data (Green square in the example) consists of Names (a,b,c,d,e,) and their score each day.

The last day is the final score (the red row)

I need excel to calculate the rankings each day (Yellow Square) and then display the deviation integer (blue square - positive number if the ranking is higher than the final and negative if vice versa) from the final score.

The rankings each day (yelow square) is not the goal of my research. It is just to show what I mean by deviation integer.

I am pretty sure it can be done by applying formula to the score row of each day, it is just that I lack the knowledge.