|Posted: May 7, 2006, 12:51 pm - IP Logged|
Problem in tracking with this method in Excel is you have to address ALL 6 possible combinations individually.
My basic spreadsheet looks like this (some of you may have seen it)
|Day||Eve|| ||a||b||c|| ||ab||ac||ba||bc||ca||cb||H/L||O/E|| || ||Group Sum|
This setup is designed to allow me to track any number, pair and be broken down by the individual days (I stopped tracking individual day of the week because I never saw a usuable outcome).
As you can see, the ab thru cb columns will allow you to hunt down every possible combination. The formulas are setup such to not allow the same number to be repeated.
Now, if you simply setup your spreadsheet such to allow tracking of each individual column, you will be able to track the numbers easier. Once all the numbers is compiled, you can then write a formula that will allow you to simply pick and choose the smallest number of the 6 columns as the primary. In otherwords, your basic layout will look something like this
Now you can see how long it has been since a pair has hit (this chart is fictional and provided for example only). The long & short of it is, there is no shortcut to doing it. It will require a LOT of work to establish the chart. But, once it is done, sorting on the OUT column will allow you to track which pairs are out for a long time.
Hope this points you into the right direction.