Dozen Project stats wanted

[Mr Chips]

I have been slowly working on a Dozen Project hand testing and have reached just over 3000 select spins. I am renewing
my efforts to get to 5000 select spins by the end of the month. Poits' 12 million stats have shown the maximum interval
for a Dozen is 39 spins. I am also aware of the stats on the excellent Oops website, which are very useful. My method so
far has produced a maximum of 16. Of course I have a long way to go yet, but what I am after is the likely maximum number
of spins I can expect before there is an increase above 16.
 
The Oops site shows approx 80,000 spins and gives a breakdown with a maximum interval above 30 spins. I am optimistic
that my method can greatly improve on the intervals, but it would be helpful if I knew I was on course in improving on the
stats.
 
If anyone knows or has statistical info for Dozens I would appreciate taking a look at it.
 
Many Thanks

Mr Chips

[rjeaton1]

I have been slowly working on a Dozen Project hand testing and have reached just over 3000 select spins. I am renewing
my efforts to get to 5000 select spins by the end of the month. Poits' 12 million stats have shown the maximum interval
for a Dozen is 39 spins. I am also aware of the stats on the excellent Oops website, which are very useful. My method so
far has produced a maximum of 16. Of course I have a long way to go yet, but what I am after is the likely maximum number
of spins I can expect before there is an increase above 16.
 
The Oops site shows approx 80,000 spins and gives a breakdown with a maximum interval above 30 spins. I am optimistic
that my method can greatly improve on the intervals, but it would be helpful if I knew I was on course in improving on the
stats.
 
If anyone knows or has statistical info for Dozens I would appreciate taking a look at it.
 
Many Thanks

Mr Chips

If you'd like Mr. Chips, I can probably throw something together in RXtreme that will not bet, but keep track of whatever statistics about the dozens you'd like it to keep track of.

I'm not sure of what exactly you want tracked, but if you put up a very specific list of what you want tracked I can probably have it done in about an hour or so.

[rjeaton1]

Doing it in RXtreme means you'll be able to import whatever spins or however many spins you'd like and just let it run overnight...when you wake up, you'll have all the stats you need.

[Stepydan]

Hi Mr chips 

In addition to what Rjeaton1 said, I can design an excel sheet for your tracking and statistics needs.

Currently, series of up to 10,000 spins are ok. Once the formulas and formatting are set up, this is a matter of seconds for you to have the desired figures.

I'll second Rjeaton1 : please explain what you would like as for results/stats.

Cheers, 

Stepydan.

[Mr Chips]

rjeaton,
 
Thanks very much for your offer of help.
 
What I am after is if 80,000 spins are imported then all Dozen intervals at 16 and above are recorded at the spin they appeared.
So 16 interval may come in at spin 2000, 22 interval at spin 4500 etc. It may be simpler for example to record the various 16 and
above intervals by spin 3000, so intervals 16, 22 and 25 may have shown up by then. The next record is at spin 5000. By then
16 may have shown three times, 22, 25, 23 twice etc. The next record would be 10,000 spins and then every 10,000 up to 80,000
spins.
 
I am not sure how difficult this would be to implement or whether there would be a simpler way to do it. If you want any further
clarification I will of course be happy to do so.
 
Regards
 
Mr Chips

[rjeaton1]

You're welcome Mr. Chips, no problem at all.  Glad I can help 

I think I get it, but just to make sure (before I write the script and have it be wrong) I'll give a small example of how I understand it:

Starting at spins 1 through 15, the 3rd dozen has not appeared...up until now, nothing has been recorded...only tracked.

Then, on spin 16, the 3rd dozen still has not appeared...the program records the following: Interval Length of 16 Happened on the 16th spin and it was the 3rd dozen.

Spin 17 - 3rd dozen still has not appeared...the program records: Interval Length of 17 Happened on the 17th spin and it was the 3rd dozen.

Spin 18 - 3rd dozen hits...nothing recorded

Spins 19 through 34 - first dozen hasn't hit...nothing recorded only tracked

Spin 35 - First dozen still hasn't hit...records the following:

Interval length of 16 happened on spin 35 to the first dozen.

So on and so forth...Is all of that correct?

[rjeaton1]

Or, are you looking for the spin number on which any interval greater than 16 ends?

Like this:

Spins 1 through 16 the third dozen hasn't shown...nothing recorded, only tracked.

Spin 17 - Third dozen still misses

Spin 18 - Third dozen still misses

Spin 19 - Third dozen hits - The program records: Interval length of 19 happened on spin 19 to the third dozen.

So on and so forth.

These are the only two ways I can figure to interpret what you typed out.  Hopefully one of them is correct, haha.

Let me know.

[rjeaton1]

Well, actually, let us know (as Stepydan has offered to help as well.  And let me tell you, I've seen his work with Excel...he's a genius with it)

[Mr Chips]

rjeaton,
 
Your reply 6 would be ideal and would achieve exactly what I am after. I will certainly owe you one.
 
Many, Many Thanks
 
Mr Chips

[rjeaton1]

No problem at all Mr. Chips! 

As long as we have contributing members like you around, this forum will be able to continue to work towards it's goal.

I may be going to dinner here in a little bit, so I may fail with my timeline of an hour.  But, it will be up here by the end of today.

[Mr Chips]

Stepydan,
 
Thanks very much for your offer. rjeaton will be able to let me import the 80,000 spins, which will allow me to get the info I want.
 
If it's ok I would like to keep your excel skills in mind for the future.
 
Regards
 
Mr Chips

[Stepydan]

Mr Chips
 

rjeaton will be able to let me import the 80,000 spins, which will allow me to get the info I want.
 
If it's ok I would like to keep your excel skills in mind for the future.

This is perfectly ok. 

For the record, I wrote 10,000 spins for reading and manipulating convenience, from the user point of view. This is not to say 80,000 spins aren't possible.
Indeed 80,000 spins is just a matter of design : instead of using one column for the spins to be entered, excel allows the use of over 1,000 columns. Any column can easily contain 10,000 spins (in fact up to about 65,000 with excel 2003, and over 1,000 000 with excel 2007 !!!).
So 80,000 numbers are not really a problem.

Anyway, I am sure Rjeaton1 will come up with something really handy. I have yet to decide myself to learn Rx scripting. I would not object and refrain that much to it if RX code could easily be transformed into this NWRS power house, but this is for another thread...

Cheers 

Stepydan.

[rjeaton1]

Alright Mr. Chips, I've got this finished.  Let me know how it goes 

First, before I post the script, I'll explain what you're looking at.  How it reports the data is shown in the picture below:
[attachimg=#]

[rjeaton1]

Alright, so using the picture above as a reference point I'll explain how to read the output.

First off, disregard all data records except for the last 6.  The others are just used for tracking.  The last 6 are used for recording the data you wanted.

Inside the first circle (the red one) in the first row (labelled on the right as 2nd dozen interval length) you'll see it says 18.  That means, it went 18 spins in a row without hitting.

Then directly beneath that you'll see 351.  That means on spin 351 is when the 2nd dozen hit after missing for 18 spins.

Then, in the green circle 16..beneath it 1517.  That means the 2nd dozen went 16 spins without hitting and the 16 missing streak ended on spin 1,517.  So on and so forth with that data and the data for the 1st and 3rd dozens.

So, the data after the first comma relates to the data after the first comma in the the row beneath it.

Hopefully all of this makes sense.  If it does, and you don't want any changes made, let me know and I'll post the script here for you.

[rjeaton1]

One last example...

In the last row you'll see "3rd dozen interval ending spin number".  The last number in that row is 2,122.  It is in the third place.

So, I go to the row above it "3rd dozen interval length" and go to the number in third place.  That number is 16.

That means the 3rd dozen went without hitting for 16 spins and finally hit on spin 2,122.

That should hopefully make everything very clear.

Let me know if I've missed anything and what else you would like added/taken away or make anything easier to read...etc.

[rjeaton1]

-