Click here to Skip to main content
15,887,267 members
Home / Discussions / Algorithms
   

Algorithms

 
AnswerRe: Time Complexity of following method? Pin
Member 1546299610-Dec-21 5:08
Member 1546299610-Dec-21 5:08 
QuestionNUMBER OF COMBINATIONS OF THE ARRANGEMENT OF CAPS Pin
Member 1543482417-Nov-21 13:48
Member 1543482417-Nov-21 13:48 
AnswerRe: NUMBER OF COMBINATIONS OF THE ARRANGEMENT OF CAPS Pin
Greg Utas23-Nov-21 5:14
professionalGreg Utas23-Nov-21 5:14 
QuestionC# Pin
Member 153810723-Oct-21 21:36
Member 153810723-Oct-21 21:36 
AnswerRe: C# Pin
Richard MacCutchan3-Oct-21 21:49
mveRichard MacCutchan3-Oct-21 21:49 
QuestionFunction of algorithm Pin
danindya1-Sep-21 15:52
professionaldanindya1-Sep-21 15:52 
AnswerRe: Function of algorithm - Spammer Pin
Dave Kreskowiak1-Sep-21 16:23
mveDave Kreskowiak1-Sep-21 16:23 
QuestionHelp with allocation algorithm Pin
Cynthia Moore24-Aug-21 19:43
Cynthia Moore24-Aug-21 19:43 
Hi,

I am new here. I hope I am doing this right. If not, please advise.

I signed up to handle a neighborhood project that involves distributing about 700 items to anyone in the neighborhood who wants them. I have created an Access database containing the items with details such as the size, weight, and condition (very good to poor). I also have a Google Sheet that I populated from the database. It has one row for each item. There are columns for each of the properties (description, size, weight, condition etc.). These are all read only (protected).

The first column is the selection column. In it, the neighbor can indicate whether they want that item or not. My current thinking is to let them enter a priority number (1-10) or leave it blank.

I will allow each neighbor to access a copy of that sheet and fill in their choices. When they are all done, I will lock the sheets and import the priority columns to Excel where I am more comfortable. I have the code roughed out that will do the actual allocations.

My remaining task is to devise an algorithm for allocating items that are selected by multiple people. I could just select randomly, but I'd like an algorithm that does the allocation as fairly as possible.

I realize that "fairly" is subjective.

I currently have about 20 people who have said they want some of the items. At least one person said they would take them all.

The algorithm will start by allocating all of the items that are selected by just one person.

My current thinking for the items selected by multiple people is to calculate some measure of the percentage of the items they requested that they have already been given. Suppose A & B both choose item 143, A has 20% of their requests, and B has 30% of theirs. I could then award that item to A or, since B has 3/2 as much of their selections as does A, I could generate a random number from 1-5 and award it to A if it's 1-3, and B if 4-5. Or I could skew it more in favor of A, the one with the lower percentage.

I'm not entirely happy with this algorithm for a couple of reasons. (1) It doesn't take into account the priority choice. What if A choose the item with a priority of 5, but B chose with with a priority of 1? (2) I'm not sure of it takes into account how many items each one chose. If B only chose 1 item but A chose 100, should that one go to B, because if not, they get nothing?

I would appreciate any suggestions for good ways to handle this.

Thanks
AnswerRe: Help with allocation algorithm Pin
Gerry Schmitz25-Aug-21 18:49
mveGerry Schmitz25-Aug-21 18:49 
GeneralRe: Help with allocation algorithm Pin
Cynthia Moore25-Aug-21 19:42
Cynthia Moore25-Aug-21 19:42 
GeneralRe: Help with allocation algorithm Pin
Gerry Schmitz26-Aug-21 4:37
mveGerry Schmitz26-Aug-21 4:37 
GeneralRe: Help with allocation algorithm Pin
Cynthia Moore26-Aug-21 7:16
Cynthia Moore26-Aug-21 7:16 
AnswerRe: Help with allocation algorithm Pin
BillWoodruff28-Aug-21 16:09
professionalBillWoodruff28-Aug-21 16:09 
QuestionWhich is the more preferred approach for novice coders, depth first search, or, breadth first search? Pin
the prestige city23-Jul-21 1:23
professionalthe prestige city23-Jul-21 1:23 
AnswerRe: Which is the more preferred approach for novice coders, depth first search, or, breadth first search? Pin
Gerry Schmitz24-Jul-21 7:15
mveGerry Schmitz24-Jul-21 7:15 
AnswerRe: Which is the more preferred approach for novice coders, depth first search, or, breadth first search? Pin
David Camp5-Oct-22 14:51
David Camp5-Oct-22 14:51 
AnswerRe: Which is the more preferred approach for novice coders, depth first search, or, breadth first search? Pin
prestige primrose hills phase 210-Nov-22 22:21
professionalprestige primrose hills phase 210-Nov-22 22:21 
AnswerRe: Which is the more preferred approach for novice coders, depth first search, or, breadth first search? Pin
Provident Ecopolitan Bagalur20-Jul-23 21:09
Provident Ecopolitan Bagalur20-Jul-23 21:09 
QuestionFind cartesians for matrix elements Pin
Member 1528858613-Jul-21 19:38
Member 1528858613-Jul-21 19:38 
QuestionGuess A Word If Number Of Character Matches Are Given Pin
Member 1525570320-Jun-21 20:54
Member 1525570320-Jun-21 20:54 
AnswerRe: Guess A Word If Number Of Character Matches Are Given Pin
OriginalGriff20-Jun-21 21:01
mveOriginalGriff20-Jun-21 21:01 
QuestionWhat are the in-order and post-order traversals of the following tree? Pin
priyamtheone20-May-21 5:02
priyamtheone20-May-21 5:02 
AnswerRe: What are the in-order and post-order traversals of the following tree? Pin
harold aptroot20-May-21 7:08
harold aptroot20-May-21 7:08 
GeneralRe: What are the in-order and post-order traversals of the following tree? Pin
priyamtheone20-May-21 9:37
priyamtheone20-May-21 9:37 
GeneralRe: What are the in-order and post-order traversals of the following tree? Pin
harold aptroot20-May-21 9:48
harold aptroot20-May-21 9:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.