I don't understand your algorithm at all. the only formulas I see are the formulas in N5:O11 that compute the average of the previous columns and rank those averages (I would note that your 1/6*sum() function seems like it should be the equivalent of =AVERAGE()).

If I were performing this analysis, I would probably start in Q14. Enter formulas to perform the analysis across the row -- make sure all computations occur in row 14. If you pay proper attention to relative and absolute references, once you have the analysis programed into Q14:BQ14 (or however many cells it takes), then you can copy row 14 and paste into rows 15:25 and perform the same analysis for all 12 weight combinations. Highlight your desired "final" result cells and evaluate from there.