Need Excel programming help

Reply #38

garyo1954 — Sun, 13 Nov 2022 00:38:19 GMT

I was about to ask if you understood that.

Looks like I'm too late.

Unless we're dealing with a time traveler, I can't wrap my head around how he'd have the next ten years of draws. But if he was a time traveler he wouldn't need our help.

Very fishy!

G

Reply #37

AllenB — Sun, 13 Nov 2022 00:33:46 GMT

I have inputs for the next 10 years worth of draws figured out, just need the equations to apply.

How is that even possible and what good is it when we have a Random Event to predict.

I'm OUT!

Good Luck.

Reply #36

AllenB — Sun, 13 Nov 2022 00:23:50 GMT

Ok I ll try to forget what the equations are for the moment.

Are we trying to find 6 of the 2200 equations to use?

That sounds a lot harder than trying to pick numbers form around 40 options per position. Does position even matter?

Again, without the equations I am flying blind.

Reply #35

garyo1954 — Sun, 13 Nov 2022 00:05:34 GMT

At this point I have no idea what you want to do.

Your first post says, Then I use a macro I made to reformat the data into csv,......

Let's say this is your data.....

4105,10/17/2022,Mon,12-19-25-29-36-37,158,4/2

4106,10/19/2022,Wed,31-32-33-36-42-49,223,3/3

4107,10/22/2022,Sat,02-11-13-21-24-46,117,3/3

4108,10/24/2022,Mon,15-23-34-35-37-49,193,5/1

4109,10/26/2022,Wed,10-20-42-44-47-49,212,2/4

4110,10/29/2022,Sat,03-07-09-24-36-37,116,4/2

4111,10/31/2022,Mon,14... [ More ]

Reply #34

Pneum0 — Sat, 12 Nov 2022 21:40:58 GMT

I am not trying to use the output of the formulas to predict values, I am looking for a pattern in the formulas used, and trying to get the 6 equations for the 6 numbers on the next draw. I already have the inputs figured out, I am trying to find the equation pattern that gives me the output.

I have 2800 draws of data and the inputs... I have calculated for each cell all the transform equations from the set of 2200 that give me the correct output for those 2800 draws.

If I can predi... [ More ]

Reply #33

garyo1954 — Sat, 05 Nov 2022 19:49:24 GMT

Sorry, Allen. Guess it wasn't what I was thinking. Still interesting.

I think he is describing his sorting process here...

I copy the (missing word) to sheet 3, my macro sorter sheet that transposes and reformat the equations as csv text strings (using a macro), I then copy these back into the correct cell of the draw data (slow, repeat for all 6 values)..

Have a spreadsheet with approximately 2800 draws of data, and output equations...

Since it's getting more confusin... [ More ]

Reply #32

Pneum0 — Sat, 05 Nov 2022 19:22:14 GMT

The later. I can soft just fine using text filtering, then write down numbers, and do an extract of the new t row of data .or just rerun those rows and do a custom format to highlight duplicate values or do a removal of symbols to help flag groupings by type, then play permutations of them.

Or maybe I get lucky and hit Powerball today with my best statistical guess based on previous history...then I give up on gambling for good and go fishing..

Reply #31

AllenB — Sat, 05 Nov 2022 19:15:19 GMT

Good Luck with the Storm.

We are getting ahead of ourselves here. Describing a method of sorting values derived from FORMULAS that have not been described.

Perhaps that is not the help you seek, (the Formulas that is), Are you looking for advise on how to speed up your sorting process

Reply #30

Pneum0 — Sat, 05 Nov 2022 18:25:25 GMT

Allen B,

I have:

Sheet1: columns with the Draw No., date, and draw results data, then I have 7 fields where I put the unique number (parsed data) , I have 6 blank fields where I place my equations.... and a cell that I fill in with color, when my data entry for that line is complete.

Sheet 2 has a set of input cells at the top, with the same column alignment as the results/input data, I have written out longhand all the 1 value - 7 value combinations in one column, next to that

Reply #29

garyo1954 — Fri, 04 Nov 2022 02:04:07 GMT

Allen, you could do it!

G

Reply #28

AllenB — Fri, 04 Nov 2022 01:33:04 GMT

First Question. 2200 Formulas. Do you apply 2200 Formulas to Each Number? To the Entire Draw? In other words is each formula unique?

You have over 16000 Columns in Excel; but, you will probably run out of memory before you get done.

I might be able to help you if I knew something about your formulas.

Keep in mind that you have to also apply those same formulas to every possible number in the game in order to be able to retrieve those balls that have the correct Value or what you th... [ More ]

Reply #27

garyo1954 — Thu, 03 Nov 2022 20:48:05 GMT

I can see how it can be done if the predictive strategy is not what we call a common RNG. Possibly more of a derived future forecast? Yeah, that's intriguing (to me).

Never heard or seen anyone attempt it, but I can see it is possible. How well it would work depends on your equations (IMO).

Without knowing the data you use, I can almost frame what I would feel comfortable using.

But I understand that's not your question, so I refrain from walking over and possibly contaminating you... [ More ]

Reply #26

ddude003 — Wed, 02 Nov 2022 19:49:53 GMT

Guessing you worked for/with Boeing as DOE Richland or ANF would be a bit of a commute for you Pneum0... And if I am remembering R runs on a Cray...

And Mr. Gore did, in a way, help invent the Internet... He continually recommended funding the research that ARPA at PARC which did invent the Internet...

Reply #25

garyo1954 — Wed, 02 Nov 2022 17:17:10 GMT

Never worked with wide area network protocols and data transfer. And I've never seen a Cray (supercomputer) so can't comment on how that would help you.

But the problem solving is exactly what you need. Rarely does a program do exactly what you think it should. In those cases you are the only one who can remedy the problem. From that standpoint you are good to go.

Have you tried writing it in BASIC? There are compilers such as FreeBASIC, PowerBASIC, QB64, and places to download BASIC... [ More ]

Reply #24

Pneum0 — Wed, 02 Nov 2022 05:01:01 GMT

garyo1954

I was a sysop back in the days of DARPANET, SIGNET and MILNET, before Mr. Gore went to the meeting where they coined the Internet.... Back when a 086 was still a fast machine.

You talk about looping things... I looped the Cray once, just once . I am much more careful now...

4 years ago I was the #5 user of the Cray Farm for several weeks running (Models that take 20-24 hours to converge on a Cray. Three of my coworkers were also in the top 5, along with the company modeling... [ More ]

Reply #23

ddude003 — Wed, 02 Nov 2022 01:15:54 GMT

Consider the first few lines of a 70 line Profit model with prediction(s)...

library(readr)

library(dplyr)

library(prophet)

mydata - read_csv('~/Desktop/Rfolder/lo.csv', cols(ds = col_date(format = ), y = col_double()))

tail(mydata)

Gives you...

# A tibble: 6 7

X1 X2 X3 X4 X5 X6 X7

1 1998-01-03 3 15 20 21 36 40

2 1998-01-07 7 18 28 35 38 42

3 1998-01-10 12 22 23 26 27 43

4 1998-01-14 14 19 23 34 36 41

5 1998-01-17 11 12 20 30 32 44

6 1998-01-21 8... [ More ]

Reply #22

cottoneyedjoe — Wed, 02 Nov 2022 01:10:01 GMT

If you can get this training through work, definitely take advantage of the opportunity. Learning enough Python or R to analyze lottery data won't take a year if you can already program in another language. Maybe a month to get fluent in new syntax.

Reply #21

Pneum0 — Tue, 01 Nov 2022 22:44:13 GMT

I can get data science training through work so R or Python is a possibility. It is just a matter of the time to learn it. Then I might even be able to build an AI to try to pattern match for me. The question is by doing a massive manual entry campaign now, can I just use search and try to deduce some logic/pattern form my model and do a prediction ( some limited success already), or do I spend a year in my spare time learning R or Python and programming as I go and hopefully get to my current ,... [ More ]

Reply #20

ddude003 — Mon, 31 Oct 2022 22:21:22 GMT

I like R for doing this kind of stuff... R has some very nice libraries and packages for managing data and analysis...

Reply #19

db101 — Sat, 29 Oct 2022 19:59:41 GMT

If you have the time to teach yourself a new language you'd be better off with something more widely used in quantitative/scientific fields like JavaScript, C, C++, R, Python, Matlab,... only because you'll find a lot more resources online for applying these languages to working out math and data problems. Not as many scientists working in VB.

Reply #18

Pneum0 — Sat, 29 Oct 2022 17:39:14 GMT

I am actually a pretty decent programmer in some antiquated Languages: BASIC, FORTRAN, SAMECS, TS170; VB is something I have lightly played with to build a few more advanced macros to do things that Excel does not do easily, but I am far from any sort of expert in using it...

I can either make progress slowly by grinding through this data manually to build my search tools, or I can take a month and figure out how to do the Visual Basic programming and get a few test cases run before turning

Reply #17

garyo1954 — Tue, 25 Oct 2022 22:05:20 GMT

Even the simple can become impossible when you have someone who doesn't know how to do something micromanaging the person who does. - G

I'm this way. If you want me to do it give me the data you want to use, the information you want and the output you expect. From there get out of my way and let me do my job. How I get it done is my business.

If I have questions, I'll ask.

But I don't need you telling me how to do it. If you could do it your way, you wouldn't have me doing it.... [ More ]

Reply #16

LottoIntuitive — Tue, 25 Oct 2022 21:38:15 GMT

The only thing that matters are the results you produce. You either have a strategy that wins more than you lose over time or you don't. You'll know by the results. It doesn't matter you pick what combos to play. Just get results.

I use excel spreadsheets that I've learned to formulate on my own to help me backtest faster/better.

I analyze up to 1,200 of the previous combos. I working in adding up to 15,000 of the previous combos for 33 individual state drawings. I only predict state tha... [ More ]

Reply #15

ddude003 — Tue, 25 Oct 2022 21:01:08 GMT

Simple things should be simple, complex things should be possible. - Alan Kay

Reply #14

garyo1954 — Tue, 25 Oct 2022 12:20:11 GMT

If programming were simple, you could do it. But maybe Excel is not the best means to accomplish what you want.

Programming is taking an idea and teaching a computer to think it through. It's like taking a blank canvas and creating a

Bob Ross beautiful little scenery. You are essentially writing the brain, or part of the brain, for a task your computer is to

carry out. And you are writing it from scratch.

Applying 7 functions to each combination and using those with 2200 formulas... [ More ]

Reply #13

Pneum0 — Tue, 25 Oct 2022 02:08:03 GMT

I work in Aerospace, I know the shortcomings of M.S. Luckily all this is integer level equations.

I have been trained for allowable development using Mil-Hdbk5 and have 1/2 a life time dealing with statistical process control, trend analysis in cutter wear and resulting hole quality...as well as doing the stress calcs to keep the traveling public in the sky.

Reply #12

ddude003 — Tue, 25 Oct 2022 01:45:28 GMT

Frenz don't let frenz use excel... Google accuracy issues with excel ... As is with all M$ products, you are the crash test dummy...

Reply #11

cottoneyedjoe — Mon, 24 Oct 2022 23:35:13 GMT

Yeah, a person who's trying to suss out a pattern could do it both ways -- only new data, or new and old mixed -- out of sheer curiosity, why not?. Once you've written the program, it's no effort to swap out one data set and replace it with another. But that old data is noise at this point, not signal. Whatever machine output those numbers has long since been living in a landfill.

Reply #10

garyo1954 — Mon, 24 Oct 2022 23:14:45 GMT

I agree with you joe.

But, it would be interesting to see if any of the formulas could hit from one draw to the next. And how many times it happens, if it happens.

G

Reply #9

cottoneyedjoe — Mon, 24 Oct 2022 22:50:41 GMT

The computers that a lottery uses to generate pseudo-random numbers get updated/replaced every few years. The programs may even get rewritten with new algorithms. All of these changes affect how a PRNG behaves, which means your very old data is probably useless now. I would not use anything over 5 years old.

(It's the same with physical balls. They get replaced frequently too.

Reply #8

garyo1954 — Mon, 24 Oct 2022 22:42:42 GMT

Good to know. I'm leaning to phileight's answer.

Seems you're trying to get everything done at one step.

Sometimes it's better to solve one problem at a time then go to the next step.

I don't work in Excel, but I write all my data files in CSV.

I open the file in a program and input the data and go from there.

Is the data sorted?

G

Reply #7

JeetKuneDoLotto — Mon, 24 Oct 2022 22:41:38 GMT

I think he wants to win.

Reply #6

phileight — Mon, 24 Oct 2022 22:29:33 GMT

have you done a flow chart of what you want to do

Reply #5

Pneum0 — Mon, 24 Oct 2022 22:09:16 GMT

It could be used for either a pick 5 or a pick 6...I am looking at both. There are a lot of these things out there.

The Hit 5, 5/42 changed to RNG like 2018'ish, ( they had someone sue the state for lottery info and off screen draw data under FOI, they won, then the state changed a lot of the games.... then in Sept 2020, they went from 3 draws per week to 7 draws to week, and I believe changed some things in how the system generates things.

They are only at draw 785 or so since that chan... [ More ]

Reply #4

garyo1954 — Mon, 24 Oct 2022 22:00:52 GMT

You want the data in a CSV format?

I'm assuming this is the Washington Hit 5 5/42.

G

Reply #3

Cmoore50 — Mon, 24 Oct 2022 21:16:38 GMT

I use excel, but this looks to be above my pay scale. 2800 draws is a lot. Good luck

Reply #2

Stat$talker — Mon, 24 Oct 2022 21:08:36 GMT

or see if my Dyslexic brain is just generating B.S.

If you didn't write yo Excel problem or da werd cixelsyD backwardz ?..you ain't Dyslexic..

Reply #1

Todd — Mon, 24 Oct 2022 20:51:58 GMT

Need Excel programming help

Pneum0 — Mon, 24 Oct 2022 19:58:57 GMT

I am working on a crude model trying to figure out an RNG.

I have about 17 years worth of data. Have figured out an underlying function that allows me to take 7 inputs I think they are using and the results which generates linear (addition and subtraction type equations for 99% of draws). Have about 2200 equations.

Some numbers have up to 49 ways of getting the number for any given draw....

Current format is draw. Date. The 6 numbers generated by the draw, a blank separator row and t... [ More ]