how to determine "Last Drawn" and "Mix Win Streak"

[Goldenrules]

Please a really need your help on a work basically how to determine "Last Drawn" and "Mix Win Streak" in 3 segments 100 draws, 24 hours, all times. I have a draw list of 10,000 already typed on Excel.


Please kindly help me.

10,000 draw list

10000draws DRAWS,Range,Total,Colour 30,3,26,17,8,36,L,120,0,3,3,3,8,17,26,30 48,27,32,8,46,35,H,196,1,2,3,8,27,32,35,46 6,7,22,8,16,30,L,89,6,7,8,16,22 27,33,4,19,45,37,H,165,3,3,0,4,19,27,33,37 7,40,45,6,21,15,L,134,2,4,0,6,7,15,21,40 37,21,9,43,33,42,H,185,9,21,33,37,42 1,44,6,15,18,33,L,117,1...

docs.google.com

Ball Frequency

Ball Frequency ID,TIME,DRAWS,ID 3202102,12:00:30 AM,24,32,43,39,26,49,3202102,24,32,43,39,26,49 3202103,12:01:20 AM,20,3,47,32,13,17,3202103,20,3,47,32,13,17 3202104,12:02:10 AM,17,36,3,37,18,25,3202104 3202105,12:03:00 AM,8,29,25,1,17,38,3202105 3202106,12:03:50 AM,27,4,39,7,25,3,3202106 320210...

docs.google.com

 

[Goldenrules]

And also for further understand of the work kindly visit the website:
logigames.bet9ja.com/Games/Launcher?gameId=11000&provider=0&sid=&pff=1&skin=201