Need a Program that Analyzes Roulette Spins in Sets of 37 Spin Sequences

[rjeaton1]

This should hopefully be a fairly simple request, however, I'm willing to $15 (via PayPal) to whoever chooses to do this.  If my request is more difficult than I think it is to code, I would be willing to pay more as long as it is a reasonable amount.

I need a program that analyzes spins in continuous sets of 37 spin sequences and extracts the following data:

On What Number Spin a Number Appeared Twice


On What Number Spin a Number Appeared Three Times


On What Number Spin a Number Appeared Four Times


Here is an example of what I mean:

29
8
26
10
34
1
24
2
23
7
1
27
19
31
5
18
7
35
32
10
31
20
17
21
15
15
33
22
17
28
3
18
17
15
22
15
14



Report:

Number of 37 Spin Sequences Analyzed   Doubles                   Triples                       Quads   

1                                                       spin 11 - double        Spin 33 - Triple          Spin 36 - Quad
                                                        spin 17 - double         Spin 34 - Triple
                                                        spin 20 - double
                                                        spin 21 - double
                                                        Spin 26 - Double
                                                        Spin 29 - Double
                                                        Spin 32 - Double
                                                        Spin 35 - Double



I would like it if the format for the numbers I would like to import and analyze could be in the format that they are posted in here.  Just a .txt file with the numbers in a single column.  I would like it if I could analyze a set of data as small as 37 spins, all the way to 100,000 spins.  Keep in mind though, that on spin 38 that means spin 1 would then be eliminated and the new set of 37 spins to analyze would be from spin 2 to spin 38.  So in a set of 38 numbers there are actually 2 sets of 37 spin sequences to analyze, but what number a double, triple, or quad appeared is going to change/get smaller/get larger.

If the output file could be something that I could import into excel that would be great.  If not, and it exports the data as I have shown it here, that's fine too.  If it were to output the analyzed data into a format that would be readable by excel, it would be best if it exported in a comma delimited .txt file.

I have attached what the above analyzed data would look like if it were analyzed and exported into a comma delimited .txt file ready to import into excel below. 


Keep in mind, in the picture below, underneath the "X2" "X3" OR "X4" is not what number appeared X2 (two times) it is on what number spin a number appeared X2 (two times).  I don't care what number repeated 2, 3 or 4 times, I just want to know on what number spin each of the those appeared on.

I have also shown a picture of what that .txt file looks like when it is imported into excel below.
[attachimg=#]












I would like this program when finished to be delivered to me via email

[Tangram]

Hi rj,

I can do this for you, but just to clarify what you need; suppose you imported a spin file with 100 spins to analyze, in excel you would have a row for the headings, then one row for each 37 spin block of numbers. So after the first 37 spins are analyzed, the counts for doubles, triples and quads are reset, the first spin is removed and the next spin is taken, then the analysis is repeated, etc. This means that after processing the file you would have 100 - 37 = 63 rows (so each new block of 37 after the first has only one new number). Correct?

[rjeaton1]

That would be awesome if you could do this Tangram, and yes what you said would be correct (about there only being one new number in each block).

Keep in mind though, that let's say when the first number is removed it means that one of the doubles later in the sequence is no longer a double anymore, that would have to be changed in that lines output data.  It also might mean that a triple has turned into a double, so on and so forth.

Oh, and is there a way to add one other thing, the total amount of numbers to show in each set of 37 spins?  (you would only count each number once regardless of how many times it came out).

Thanks again Tangram!

[Tangram]

rj,

Adding the total amount of numbers in each set is easy enough, but I think I misinterpreted what you meant in your first post after reading this:

Keep in mind though, that let's say when the first number is removed it means that one of the doubles later in the sequence is no longer a double anymore, that would have to be changed in that lines output data.  It also might mean that a triple has turned into a double, so on and so forth.

What I think you mean is that as each new spin is taken (and the first spin removed), the numbers under x2, x3, x4 will all need to be updated, so using your example spins, if the number 31 came in next, then the first spin (no. 29) is removed. When you remove the first spin it means that the existing x2,x3,x4 numbers will all be moved back - e.g. the first double occurred at spin 11 in the first 37 spin block, so now it's at spin 10, and similarly for each of the other numbers. Number 31 has just appeared, and it occurred twice in the previous block, so that means that the x3 numbers will have an addition (at spin number  37 in this new block), also the x2 spin number 21 will be removed because it was at spin 21 that 31 became a double in the first block.  So the updated excel file will look like this:

number of 37 spin sequence analyzed------x2 x2 x2 x2 x2 x2 x2--------x3 x3 x3-----x4
1----------------------------------------11,17,20,21,26,29,32,35----33,34--------36
2----------------------------------------10,16,19,25,28,31,34-------32,33,37-----35

Just checking. In my experience it's always quicker to spend more time on the spec than rewriting the wrong code. 

[rjeaton1]

Wow, you must have definitely done this before, and you know your stuff.  Thanks Tangram!

Everything you said was absolutely correct, except for one thing.  When a number triples, it doesn't get removed from the X2 block, because a number still did in fact appear twice on that given spin.  Same for when a number appears 4X.  Just because a number appeared 4 times, doesn't mean that it no longer appeared 3X (in fact, it means that a number MUST have appeared 4X as you can't hit 4X without first hitting 3X).

So, following on your example (which everything was correct in except the above) it would look like this if on spin number 38 the number 31 came out:

[table=,]number of 37 spin sequences analyzed,x2,x2,x2,x2,x2,x2,x2,x2,,,x3,x3,x3,,,x4
1,11,17,20,21,26,29,32,35,,,33,34,,,,36
2,10,16,19,20,25,28,31,34,,,32,33,37,,,35
[/table]

[Tangram]

Ok, that actually makes the coding a bit easier. I should have it done by tomorrow, or maybe Wednesday if I'm feeling lazy. 

[rjeaton1]

"if I'm feeling lazy" haha, funny stuff.  I know that feeling.

Thanks though Tangram, I appreciate it!  Is $15 enough, or is this more difficult than I thought it was to program?

[Tangram]

Is $15 enough, or is this more difficult than I thought it was to program?

It's a little trickier than I first thought, but it won't be much more than $15 ($20 at most).

[rjeaton1]

Awesome Tangram, I appreciate you not taking advantage of me, lol (not that I though you would).

If you'd like, I can send you half of the money now so you know I'm "good for it" so to speak.

[Tangram]

That's ok, I trust you.  Could you pm me your email address?

Ah, just noticed you already have. 

[rjeaton1]

Excellent Tangram, works perfectly!  It is definitely offering some interesting insight into what the numbers can do with "random" at work...

Thanks again!

Some very dissapointing things have been shown to me, and few positive things as well using this program.

I'll be posting an analyzed set of 100,000 spins for anybody to download very soon.

[VLSroulette]

I'll be posting an analyzed set of 100,000 spins for anybody to download very soon.

Thanks in advance mate.

You are top-notch "cobber" 

[rjeaton1]

Thanks in advance mate.

You are top-notch "cobber" 

Thanks Victor!    (I'm saying thanks under the assumption that "Cobber" is a positive thing, lol...any chance you'll explain what a "cobber" is?)

[rjeaton1]

-