SalientAnimal Posted August 7, 2012 Share Posted August 7, 2012 Hi All, So I know best practice is to list your codethat you are using and then get guidance from there, however right now, I don't even know where to start, so I can't even begin to write my code I would like some guidance on where it would be best to start. I have a set of data, extracted from a MySQL database into Excel. This data then needs to be randomly assigned to 5 different users based on their ranking. So as an example I have 100 records all ranked as: 15 Bronze, 50 Silver, 20 Gold, 15 Platinum. The users are ranked 1 - 5. However you could have two users equally ranked. So lets assume: User 1 = Rank 1 User 2 = Rank 2 User 3 = Rank 2 User 4 = Rank 4 User 5 = Rank 5 All the users need to be assigned the same amount of records (20), but User 1 needs to have more Platinum records assigned to them than any of the other users. User 5 needs to have more Bronze records assigned to them than the other users. So can anyone suggest a way of doing this? Can I do it with a SQL query? OR Would it be easier to do it with a marco? Thanks Link to comment https://forums.phpfreaks.com/topic/266759-where-to-start/ Share on other sites More sharing options...
Barand Posted August 7, 2012 Share Posted August 7, 2012 Whether you use a query or a macro you will have to devise a distribution algorithm. Link to comment https://forums.phpfreaks.com/topic/266759-where-to-start/#findComment-1367601 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.