Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Creating a Randomized List with Two Items Anchored in Middle


I'm attempting to create a 30 item list for a grid. I would like to anchor two QC items (i.e. please check 3) to the middle of the list. Is there a way to anchor both of those to the middle while randomizing the entire list besides those items?

A items
QC 1
QC 2
B items

I know how to make the list so that I randomize the A items and the B items, but they are stuck either above the QC items or below it. I would ideally like the A and B items to be randomly distributed throughout the entire list.

Any help would be greatly appreciated.
asked Oct 3, 2017 by Matt

1 Answer

+1 vote
Best answer
Constructed list building instructions are evaluated sequentially, so you just need to be a little more specific with your list building.  Assuming you had a parent list called List1 that had 10 A items, 10 B items and QC1 and QC2 (total of 22 items), you could do something like this in a constructed list:


If you now want QC1 and QC2 to be in the middle, use the Insert function:

INSERT (TargetPosition#, ListName, StartMember#, EndMember#)

You can insert QC1 and QC2 to whichever spot you want in the list.

If you wanted it to be random but somewhere in the middle, replace an explicit value for TargetPosition# with a random number function:

RandNum(Seed, Min#, Max#)  

and set the min and max to be somewhere in the middle of the list, i.e. min 6 max 12.
answered Oct 3, 2017 by Brian McEwan Gold Sawtooth Software, Inc. (45,995 points)