View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
meral
 
Posts: n/a
Default Pareto With Excel


Yes dlw you are right if there is 2 2 2 2 and 1 1 1 3
2 2 2 2 is over other branch same for 3 3 3 3 is better then 1 1 1
4...
Here i choose best according to highest scores with in all criteria...
it can be weaken by selecting 3 out of 4 criteria but here i am srictly
choose all criterias....
if there is no branch between 3333 and 1114 so i will choose 3333 is
better than 1114 because in 4.criteria this branch is back of 3333
branch...

This is mathemetical rule known as q-pareto rule...


--
meral
------------------------------------------------------------------------
meral's Profile: http://www.excelforum.com/member.php...fo&userid=7357
View this thread: http://www.excelforum.com/showthread...hreadid=496385