hi Stan,
Can you create a summary stats table for Segment Calculator? if you sort each column with most tickets to lowest ticket and give ranking #1 for segment with most tickets... see what I mean below:
03/28/08 3-0-2,4-0-1,2-0-3,2-0-3,3-0-2,3-0-2,3-0-2,3-0-2,3-0-2,2-0-3,1-0-4
03/29/08 1-0-4,3-0-2,1-0-4,3-0-2,3-0-2,3-0-2,1-0-4,1-0-4,3-0-2,1-0-4,1-0-4
03/30/08 2-0-3,0-0-5,2-0-3,2-0-3,0-0-5,2-0-3,1-0-4,2-0-3,2-0-3,1-0-4,2-0-3
03/31/08 3-0-2,4-0-1,4-0-1,2-0-3,3-0-2,1-0-4,1-0-4,3-0-2,3-0-2,2-0-3,3-0-2
04/01/08 3-0-2,2-0-3,2-0-3,1-0-4,2-0-3,3-0-2,1-0-4,2-0-3,0-0-5,2-0-3,0-0-5
Here's what the latest 5 draws would look like base on the above segments:
03/28/08 2 4 1 1 3 3 3 2 1 1 3
03/29/08 2 2 2 2 4 1 2 3 1 3 3
03/30/08 1 5 1 1 3 1 2 1 1 3 1
03/31/08 2 4 4 1 3 1 3 2 2 2 2
04/01/08 2 1 1 3 1 3 3 1 5 2 5
For example, 4/1/08 with Column 0 = 3-0-2, if you sorted Column 0
2-0-3 209440
3-0-2 157080
1-0-4 124355
4-0-1 52360
then you get 2 for Column 0
A filter a be create similar to Segment Combinations.
Thanks,
Da80th