Formula to get a ranking based on three columns

Continuing on the good work by Gregb11, I have added 3 attributes/fields to give flexibility in the scoring computation:

1. Weightage in B1:D1 - the weightage to be given for each of the scores
2. Highest possible score in B2:D2 - I am taking the maximum of available scores as the highest possible score; if the maximum score for Combined Avg. is 100 and Cleanliness Avg. is 5, then put 100 in cell B2 and 5 in cell D2
3. Lowest possible score in B3:D3 - I am taking the minimum of available scores as the lowest possible score; if the lowest possible scores for all is 0 or 0%, then key in 0 in B3:D3
4. Recompute percentage score for Combined Avg. in E5=(B$2-[@[COMBINED AVG.]])/(B$2-B$3), copy down
5. Recompute percentage score for Attendance Rate in F5=([@[ATTENDANCE RATE]]-C$3)/(C$2-C$3), copy down
6. Recompute percentage score for Cleanliness Avg. in G5=([@[Cleanliness AVG.]]-D$3)/(D$2-D$3), copy down
7. Weighted Total Score in H5=SUMPRODUCT(Table26[@[COMBINED AVG. SCORE]:[Cleanliness AVG SCORE]],$B$1:$D$1), copy down
8. Ranking in I5=RANK.EQ([@[Weighted Total Score]],[Weighted Total Score]), copy down