Re: How can I order a aggregation of items from multiple lists



On 22 Dec 2006 11:14:20 -0800, "bcot" <arustad@xxxxxxxxx> wrote:

I hope this is an appropriate groups for asking this question.

I'm trying to calculate what an aggregate list of items should look
given multiple small lists of items. Items may appear in in multiple
lists. And each list is ordered from most popular to least popular.

For example:

user 1 list user 2 list user 3 list
-------------- --------------- ---------------
a a b
b b x
c e y
d f
e
f

Given the data above, should 'b' be the first time, because it shows up
in 3 lists? Or, because there are 2 'a' and they are both in position
1, should they be worth more?

Any help on this would be appreciated...obviously, I'm no mathmatician,
so if I need to provide further info, please let me know.

When it comes to decisions here,
the mathematics take second place to the politics.

Do you want to maximize the *satisfaction* of a few raters,
or to minimize the *dissatisfaction* across all raters?

If you score this like Victories in a track meet or a swimming
meet between schools, individual events are given points.
A "1" might count 10 points for the team, a "2" count 5 points,
and places "3", "4", and "5" count 3, 2, and 1, respectively.
Relay races count double.

Dealing with ranks, you get into further choices if you want
to rank the whole set -- like voting for ice skaters in
Olympic competition (by the old, complicated system, or
the new, complicated system) -- or if you want to choose one
winner for a political office with a dozen parties in the race.
(Various places do have various systems.)


In general, the practice is for you to do the following -
1) Look at a *lot* of examples of what you are rating,
including a number of extreme cases.
2) Figure out who you *feel* should be the winners.
3) Find a system that gives you the winners that you
feel are right, with the least work and confusion.

That's trickier if the "you" is plural.
What's easier is to copy pretty closely whatever other
folks have done with *your* exact problem ....


--
Rich Ulrich, wpilib@xxxxxxxx
http://www.pitt.edu/~wpilib/index.html
.



Relevant Pages

  • [Full-Disclosure] Re: Full-Disclosure digest, Vol 1 #1933 - 20 msgs
    ... read from multiple peoples articles that it isn't this kind of bug. ... > that about how bad Windows sucks from people who don't know enough about how ... I don't do it out in the public lists like ... >>because you have a bug up your bum about it and work to prove that stance. ...
    (Full-Disclosure)
  • Re: Difficulty with List Selection and New Records
    ... but one Patent can be assigned to multiple ... Doug Steele, Microsoft Access MVP ... I need to create a list that allows multiple selections. ... successfully created lists that allow multiple selections. ...
    (microsoft.public.access.gettingstarted)
  • Re: MOSS 2007 Out of the Box Workflows Broken
    ... I will add that choosing the Allow Multiple Seletions also prevents users ... from editing lists in datasheet view, exporting lists to excel, and using ... that field in custom workflows through SharePoint Designer. ... theworkflowuses the default Task content type to manageworkflowtasks we ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Trouble w/ Value List
    ... What I am wanting is three drop down lists, two of which allow for multiple selections. ... Under some circumstances you may want to use a validation rule instead - you couldn't have a list of all the email addresses in the world but you could devise a validation rule expression which returned True if the text entered contained an "@" character. ... there are dangers - it's considered bad design to have multiple values in one table field (violates the "normalisation" rule of "1st Normal Form" to be specific). ...
    (microsoft.public.access.gettingstarted)
  • Re: Multiple criteria with multiple results in one cell
    ... multiple criteria. ... firstcell is the first cell of the output array, ... companies in a separate column on that worksheet based on a pay rate table ... drop-down lists on her site, but in those cases, it requires either having a ...
    (microsoft.public.excel.worksheet.functions)