Hi all ... got a fun Friday question.
So here's the situation. Two lists of brands. 24 in one list and 16 in another. Everyone will be aware of at least one in the first list. Some will also have awareness of at least one in the second list.
Task: To allocate up to two brands to each respondent based on awareness. Any who are aware of brands from the second list will have one from each list. Others will have up to two from the first list.
There is a weighting (or target) for each brand. (so we might need 200 for brand 1, 40 for brand 2, 380 for Brand 3, etc).
No-one should fail quota based on this allocation, and if, when it comes time to allocate brands to a person, all available targets are full, they are able to be surpassed.
Any ideas to code this elegantly? I know I could set up quota questions (ALLOCATE1 and ALLOCATE2) and use quota logic but there's so many cells! Anyone got a better idea? Perhaps I need to set up a multichoice hidden list and query the database for numbers?
I'm on 9.8.0.