3 groups of 12 numbers, from last 100 spins

[gianfrancopierino]

i have 3 groups of numbers:
group 1: 1,2,3,4,5,6,7,8,9,10,11,12
group 2: 13,14,15,16,17,18,19,20,21,22,23,24
group 3: 25,26,27,28,29,30,31,32,33,34,35,36

after 100 spins i want to know how many extraction of every group I have
what's the easiest way?

tks and keep working guys

[alexlaf]

One way.
 

[gianfrancopierino]

wow, tks alex, good job

let's say i insert 500 numbres
100 extracted numbres give me 29,35,36
can i receive these statistics at every spin? so the statistics are allways for the last 100 extractions?

[alexlaf]

Yes

[Bigbroben]

This?

[gianfrancopierino]

alexlaf, when i insert 500 numbers into excel file i get overall statistics, i need allways on the last 100

Bigbroben, i could not understand how to use your file

[alexlaf]

It counts for every 100..exp 100-101(100)
No time for something better maby there are some already sheets for your task.

Cheers

Alex

[gianfrancopierino]

alexlaf, thank you very much.
now i will do some test on what group to play, after 100 spins there is a cold group, a medium hit group, and a hot group.