PrioritizationTemplate1.xlsx on the Sheet named Best Option-I have 3 weighted columns(B=risk-60%, C=frequency-20%, D=complexity-20%,) for 5 different departments(A) that are prioritized in a column(E). Column(F) contains 4 options "for additional weighting" BC=(-70% of E), BP=(-30% of E), NA=0%, and BC,BP=((-70% of E)-(-30% of E)).
First- does any of this make sense? and how can I accomplish this? Any assistance is greatly appreciated!
Bookmarks