United States
Member #116,337
September 8, 2011
5,179 Posts
Offline
I need a software program to count set of numbers, it could be digits, pairs, triads .. any set length. Basically, input 0000111334557895479 will tabulate each digit and frequency.I need a general program for number/ frequency counter, where a number can be any string set. Thanks.
United States
Member #116,337
September 8, 2011
5,179 Posts
Offline
Quote: Originally posted by adobea78 on Nov 21, 2017
I need a software program to count set of numbers, it could be digits, pairs, triads .. any set length. Basically, input 0000111334557895479 will tabulate each digit and frequency.I need a general program for number/ frequency counter, where a number can be any string set. Thanks.
The draws 198-239-890-962-171-596-187 simulates these combos based on their sum parameters
576-015-401-247-657-481-293-692-695-570-973-472-976-016-963-729-946-160-386-925-962-462-803-514-083-259-508-351-218-958-081-563-817-109-234-428-810-930-794-241-846-875-813-235-581-194-504-279-821-783-815-670-836-594-430-139-674-435-819-259-457-724-925-148-896-192-964-241-846-875-813-235-581-194-504-279-821-783-815-670-836-594-430-139-674-435-819-259-457-724-925-148-896-192-964-964-830-386-981-378-160-403-745-132-938-907-451-678-951-423-935-086-481-140-138-154-805-519-680-874-027-013-027-841-918-892-648-560-591-102-739-254-056-087-284-670-531-879-643-025-410-230-250-852-096-152-638-651-374-451-614-254-034-319-258-789--- A frequency set counter is needed to filter identical picks.
Michigan United States
Member #128,621
May 29, 2012
575 Posts
Offline
Rl
I think what she is looking for is, the first sum is 18=198. Now she has a chart from awhile back that shows all of the draws in the same sum of 18 ex 945/639 looking at a time frame say most recent to 50 draws ago. Sum 18 will have like draws in the time. Maybe not. Dld
South Africa
Member #129,814
June 28, 2012
2,039 Posts
Offline
Quote: Originally posted by adobea78 on Nov 21, 2017
I need a software program to count set of numbers, it could be digits, pairs, triads .. any set length. Basically, input 0000111334557895479 will tabulate each digit and frequency.I need a general program for number/ frequency counter, where a number can be any string set. Thanks.
digit
freq
0
4
1
3
3
2
4
2
5
3
7
2
8
1
9
2
Adobea78
This might help you create a excell sheet with the name Calculations + Data (Bin =Pick 3 number)
BIN
FREQ
1
3
2
1
3
1
4
1
5
1
6
2
7
1
8
1
9
2
10
0
11
1
Then a Data tab (same principle this can me ammended for pick3) -Delete 44 65 1......Replace 9 32 36 with your pick3 number 7 5 2 etc. Pick3 dataon C D E
A B c d e Discard Discard Discard
Powerball
4/1/2017
9
32
36
44
65
1
Powerball
3/29/2017
8
15
31
36
62
11
Powerball
3/25/2017
18
31
32
45
48
16
Powerball
3/22/2017
2
9
27
29
42
9
Powerball
3/18/2017
13
25
44
54
67
5
Powerball
3/15/2017
16
30
41
48
53
16
Powerball
3/11/2017
1
26
41
50
57
11
Sub Process()
Dim WsWeb As Worksheet
Dim WsData As Worksheet
Dim WsCalc As Worksheet
Dim qt As QueryTable
Dim WsWebRowNo As Long
Dim WsDataRowNo As Long
Dim Draw As String
Dim N As Variant
Dim I As Integer
Dim MaxDateData As Date
Set WsWeb = ThisWorkbook.Worksheets("WebScrape")
Set WsData = ThisWorkbook.Worksheets("Data")
Set WsCalc = ThisWorkbook.Worksheets("Calculations")
Call DeleteQT
WsWeb.Cells.Clear
Call DrawNumbers
Set qt = WsWeb.QueryTables(1)
WsDataRowNo = WsData.Cells(WsData.Rows.Count, "A").End(xlUp).Row + 1
MaxDateData = Application.WorksheetFunction.Max(WsData.Columns("B:B"))
For WsWebRowNo = 2 To WsWeb.Cells(WsWeb.Rows.Count, "A").End(xlUp).Row
If WsWeb.Cells(WsWebRowNo, "B") > MaxDateData Then
WsData.Cells(WsDataRowNo, "A") = WsWeb.Cells(WsWebRowNo, "A")
WsData.Cells(WsDataRowNo, "B") = WsWeb.Cells(WsWebRowNo, "B")
Draw = Replace(WsWeb.Cells(WsWebRowNo, "C"), " ", "-")
N = Split(Draw, "-")
For I = 0 To UBound(N)
WsData.Cells(WsDataRowNo, 3 + I) = N(I)
Next I
Call UpdateCalcWS(WsCalc) End Sub Function UpdateCalcWS(WsCalc As Worksheet) 'Add Formula Arrays to Calculations WorkSheet WsCalc.Range("C2:C60").FormulaArray = "=FREQUENCY(DrawRng,RC[-1]:R[58]C[-1])" WsCalc.Range("D2:D36").FormulaArray = "=FREQUENCY(pbRng,RC[-2]:R[34]C[-2])"
'Copy the Draw Freqs to a new range
WsCalc.Range("E2:F60").Value = Range("B2:C60").Value
WsCalc.Range("G2:G36").Value = Range("B2:B36").Value
WsCalc.Range("H2:H36").Value = Range("D2:D36").Value
WsCalc.Range("E1:F60").Sort Key1:=WsCalc.Range("F1"), Order1:=xlDescending, _
Header:=xlYes, _
MatchCase:=False, _
Orientation:=xlTopToBottom
WsCalc.Range("G1:H36").Sort Key1:=WsCalc.Range("H1"), Order1:=xlDescending, _
Header:=xlYes, _
MatchCase:=False, _
Orientation:=xlTopToBottom
End Function
Function SortIt(WsCalc As Worksheet, strRng As String, SortCol As String)
Application.CutCopyMode = False
With WsCalc.Sort
.SetRange Range(strRng)
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Function
Regards
Ricklou
Eating trolls 🤡 for breakfast since 2020.Talk is cheap, money buy the whiskeyHave a great 2026
The way I read this is that you want a tool to generate the combos with no duplicates using the sums
from these drawings "198-239-890-962-171-596-187" It's still simple to do but I need to know exactly
how you build the string from start to finish. The sums are 16-20-9-17-17-14-18 but I see combos
above with digits that are not within these sums or does the list above indicate all the combos that have
sums of 16-20-9-17-14-18? Let me know, you can post the answer or PM me.
RL
Hi RL, All I need is A set counter, a set can be any length of string, example,1(P1),12(P2) 123(P3),1234(P4), 123456(P5) ..etc.
The combos are already generated, so I copy and paste them for the program to sort it by frequency.I have already discussed using recurrent concept to simulate any given matrix in earlier thread. See snippet of simulation and formation of next string.
MO
Drawing Date
Pick 3
Pick 4
Midday
Evening
Midday
Evening
Fri, Nov 24, 2017
1-5-2
7-9-8-0
Thu, Nov 23, 2017
3-7-0
9-9-6
0-0-4-4
2-2-5-4
Wed, Nov 22, 2017
9-5-4
9-8-7
7-7-1-2
6-7-0-0
Tue, Nov 21, 2017
3-0-8
9-3-3
9-2-7-9
9-5-1-8
Mon, Nov 20, 2017
1-6-1
9-8-5
9-8-1-4
6-9-3-2
Sun, Nov 19, 2017
2-5-1
3-9-0
6-2-5-7
5-7-1-1
Sat, Nov 18, 2017
3-8-8
0-9-9
6-6-3-4
9-1-4-9
Fri, Nov 17, 2017
8-4-0
7-0-4
1-5-5-1
3-1-9-1
Thu, Nov 16, 2017
7-1-7
4-4-9
8-4-3-5
8-9-9-4
Wed, Nov 15, 2017
4-1-1
3-0-7
4-5-8-1
8-6-7-0
Tue, Nov 14, 2017
8-6-7
1-7-1
6-8-3-6
5-6-2-9
Mon, Nov 13, 2017
9-8-0
5-4-8
6-4-8-7
4-3-2-7
Sun, Nov 12, 2017
0-8-1
9-7-0
1-7-1-6
9-9-1-3
Sat, Nov 11, 2017
1-3-2
3-7-5
0-8-3-2
7-1-5-7
Fri, Nov 10, 2017
5-6-3
3-0-5
9-6-8-7
2-0-4-1
Thu, Nov 9, 2017
1-5-9
7-2-8
9-5-1-9
8-4-6-9
Wed, Nov 8, 2017
4-6-0
0-6-8
8-0-6-9
4-0-9-8
Tue, Nov 7, 2017
2-5-3
7-4-2
8-2-6-4
8-7-4-5
Mon, Nov 6, 2017
6-1-2
4-2-7
9-3-9-4
9-6-5-6
Sun, Nov 5, 2017
1-4-2
8-2-7
3-3-6-4
7-8-8-9
Sat, Nov 4, 2017
5-5-1
4-7-3
5-0-8-8
3-9-4-4
Fri, Nov 3, 2017
7-9-1
1-6-1
5-1-2-8
1-7-2-6
Thu, Nov 2, 2017
8-4-2
0-0-3
6-1-7-0
7-9-3-2
Wed, Nov 1, 2017
3-2-8
9-4-2
1-4-2-2
2-4-3-7
Tue, Oct 31, 2017
4-4-5
9-6-4
0-7-8-8
5-5-2-6
Mon, Oct 30, 2017
6-5-1
5-0-8
3-4-8-9
7-3-7-6
Sun, Oct 29, 2017
1-8-8
0-7-1
8-6-8-2
3-9-3-8
Sat, Oct 28, 2017
5-8-0
7-1-8
1-7-1-8
5-7-5-6
Fri, Oct 27, 2017
1-9-7
6-4-2
0-0-0-1
1-6-6-4
Thu, Oct 26, 2017
5-7-2
4-7-9
6-6-5-7
8-4-8-1
Wed, Oct 25, 2017
5-6-3
4-5-8
1-8-6-1
1-1-1-2
Take the draw 563 with the sum 14, I have the option of locating the next probably sums by simulating possible combos under sum 14.
Sum 14> 962-462-803-514-083-259-508-351-218-958-081-563-817-109-234-428-810-930-794
Observation>simulated sums 11>Predicted draws 803,083> try forming a string 800833>
'' 9> '' 081, 810> try a string 088110
Lets form a string for sum 12>462-930> 496320> 4,9 becomes your drive, 49-46-96-93
Normally , you track due sums, so with due sum 11, you have 69 combos to consider and filter. I prefer the word 'next' than 'due'. I can focus on few picks and bet accordingly for nice prize.
You can also form the next 10 string compressing the simulated draws 962-462-803-514-083-259-508-351-218-958-081-563-817-109-234-428-810-930-794> 962462803514083259508351218958081563817109234428810930794>string 8012359462> drive 8,0
Like, i said, i need program to just count sets, and i think i got my request two days ago by LP member, thanks anyway.
Have a great 2026
