calculate the delta value in each trio

jack

Member
calculate the delta value in each trio
* then after separating the draw line
in 5 trios, see delta value the difference between trios = example trio = 02 03 05 = delta or difference
http://www.mediafire.com/file/dl5fr8z3rk8h9pv/delta_dupla.xlsx/file
 

jack

Member
sorry, I forgot to ask, to attend the delta duo,
* see in a list the most and least frequently
* on the basis of the sweepstakes
* ex = delta duo x has been drawn 120 times, it's just an example, remember always I'll put new draws please
 

Frank

Member
Are you being serious ? You've used Excel for about 10 years or more and you cant write a formula to subtract one number from another ? So you've pretended all this time to be learning Excel!

Here is a clue :- in cell AK type in = R6-Q6

They don't get simpler than that !

Stop being lazy and get on with it!
 

jack

Member
hello Frank, please see the quantity and each double delta, and also the starting number of each delta
* ex = the double 2,3 has 80 times that was drawn, (it's only one ex) the starting number of the trio was 02
about the starting number of the trio, it is important to have a delta value reference, here you can put your idea about the starting number of the trio, to have a basis for using delta values, please
 

jack

Member
hello frank sorry i forgot to mention the delta value between the threes
from last triplet number to next triplet number
* ex = trio = 02 03 05 06 09 10 16 18 20 .........
last number of 1st trio 05 next 1st delta was 06
* so = delta = 1 and 4
* each draw will have a suit of 4 values
* ex = 1,4,2,3, are delta values between the three
* so I can have a base to use,
so we have two values from within, the double within each trio and the 4 values from the 5 trios between trios
* also do more frequent statistics. please!!!
 

Frank

Member
hello, , ok Frank, please
http://www.mediafire.com/file/dl5fr8z3rk8h9pv/delta_dupla.xlsx/file
Well I do recall asking YOU to get on with it. I do not recall asking you to get your friend XPBi-Cyril to do the work in the hope of pulling the wool over my eyes. For that reason I did only what I agreed to do before you moved the goalposts and did the counting. Its up to you and your friend from now on.

IM OUT !

https://www.mediafire.com/file/vl71pw5x1oh1ya5/delta_dupla.xlsm/file
 

jack

Member
hello ok great job, perfect congratulations, i would like to have your excel level one day i get there. thanks frank
 
Top