SoniQ BOOM, a new P3/P4 system (Excel)

Reply #116

xavier102772 — Mon, 09 Jan 2006 16:21:57 GMT

True that. I agree that looking a few draws back may be the way. I've been trying a new strategy based on Ion's Pick332 software lately when I saw what you had with the spreadsheet. It uses another guys idea, modified from here for picking filter settings. So, far it is the best strategy I have found/thought up. If you're at all curious about it and know how to use Ion's Pick332 and/or Pick632, message me and I'll let you know the strategy I'm using.

Reply #115

hypersoniq — Mon, 09 Jan 2006 11:03:26 GMT

I started out before posting with the single digit precursor... results were poor, even with the formula error.triple digit precursors don't hold up well, there aren't enough of 'em even using full history.the hardest part about tweaking the results is to avoid using data that you woudln't have had before each pick... I am trying to figure out how to increase the individual column matches in one single step...perhaps this particular method needs to be modified... maybe announcers would work bett... [ More ]

Reply #114

xavier102772 — Mon, 09 Jan 2006 05:47:10 GMT

Yes, so if you use your numbers below. The first vertical column, or precursor digit would be 6 for the single digit precursor count. The next would add the 4 to it, so it would be 64 for the 2 digit precursor and the 3 digit precursor would be 641. Follow the same format for each digit in every draw.you mean vertical combos greater than 2?such as 1-4-6 would be position 1 in1/1 1-3-51/2 4-6-81/3 6-2-0

Reply #113

hypersoniq — Sun, 08 Jan 2006 19:33:02 GMT

you mean vertical combos greater than 2?such as 1-4-6 would be position 1 in1/1 1-3-51/2 4-6-81/3 6-2-0

Reply #112

xavier102772 — Sun, 08 Jan 2006 06:27:00 GMT

Great idea to concentrate on picking one gigit with consistency and accuracy Pogo. I think soniq is definately on the right track. Let's try this: Soniq's sheet currently selects a 2 digit precursor and does a count of the following digit and chooses the highest or lowest digit as the selection. Why not do the same thing but use a single digit, double digit and triple digit precursor. Sum for each digit position and select based on the highest or lowest count as per soniq's sheet. Use a spe... [ More ]

Reply #111

Pogo — Sun, 08 Jan 2006 05:09:34 GMT

I'm trying something new here... ...I'm setting my goal initially low. I'm going to start trying just to predict just 1 digit with some accuracy consistency. I think shooting for a straight 3 was just to ambitious at this point. Soniq, again I can't say enough good things about what you started here. I haven't researched something this hard since College. The rest of the gand here: keep the great ideas flowing in keep the positive thoughts going. Tonight I just finished dividing 15 years of... [ More ]

Reply #110

hypersoniq — Sat, 07 Jan 2006 20:09:31 GMT

1800 draw rolling history version of H2L is done... 12 hits :-(position 1 = 1,044position 2 = 996position 3 = 950

Reply #109

hypersoniq — Sat, 07 Jan 2006 16:06:04 GMT

second file done and uploaded... 8 hits alsoposition hits are mostly less...position 1 = 997position 2 = 985 (10 more than sb3.xls)position 3 = 946

Reply #108

hypersoniq — Sat, 07 Jan 2006 15:07:18 GMT

I noticed the hits spaced out evenly, it may not be needed to post a rolling history, but I will still fix and post it just to compare.the biggest difference in each individual column is about 900 matches... error formula was closer to 2000 matches in each column. if that can be increased, the hits will surely follow...still, on average, each column picks the right number 1/10th of the time. the repaired version picks more individual digits than vtrac straight mirror does, but vtrac lines 'em up... [ More ]

Reply #107

hypersoniq — Sat, 07 Jan 2006 14:57:00 GMT

recalcing the second sheet, will post to my website when done, this is the one that uses high to low to arbitrate ties...the 4 sheets by name and functionsb3.xls uses full history and arbitrates ties low to high (uploaded to website already)sb3_h2l.xls also uses full history but arbitrates high to low (to be uploaded on recalc completion)sb3_roll.xls uses rolling history, arbitrates like sb3.xls (pending recalc)sb3_h2l_roll.xls also uses rolling history, arbitrates like sb3_h2l (pending re... [ More ]

Reply #106

hareless — Sat, 07 Jan 2006 03:04:54 GMT

did your new sheet for night, down from 41 counts to 6.pogo, My texas sheet has night, eve, and then combined. the hits on the combined was only 10 more than mid, and 20 less overall. I have all night again to work on this, soon as people stop calling me to fix something.Oh well, job security.Melissa

Reply #105

Pogo — Sat, 07 Jan 2006 02:58:25 GMT

Don't start thinking of retirement... ...well, not quite yet anyways. The triple digit system works just like the double digit system; both systems being the versions after we found the errors. So they are both only hitting very infrequently. But the good news is that the numbers the double digit system and the numbers the triple digit system hit on only overlap some. Meaning 1 system gives numbers the other system doesn't and vice versa. Another problem arises though one system may give you 2 n... [ More ]

Reply #104

xavier102772 — Sat, 07 Jan 2006 02:21:04 GMT

Pogo, does that mean that it's the same as the double digit system before the counting errors were found or after? If it's before than maybe I can think about pick3 retirement again.

Reply #103

Pogo — Sat, 07 Jan 2006 01:57:10 GMT

Soniq don't get down about it. It's progress!!!I did a sheet with single digits - no info here. But, when I did a sheet with triple digits (1st digit from 3 draws) the overall number of hits is basically the same as the double digit system we are currently using. But here's the interesting thing, the numbers don't sart showing up until later on in the system unlike the double digit system, where the are spread out.Next, I'm going to try the triple digit system on the night draws, because I have... [ More ]

Reply #102

hypersoniq — Sat, 07 Jan 2006 00:41:38 GMT

it didn't change, so it looks like that part is fixed up too...I think it's time to break it down and see how many single digit matches were involved...position 1 = 1,029position 2 = 975position 3 = 1,027I am uploading this new (and newly unimpressive, sorry bout that folks) sheet to the website in place of the sb3 sheet on there... should only take a few minutes...

Reply #101

hypersoniq — Sat, 07 Jan 2006 00:33:06 GMT

I redid the first sheet with my last formula revision, it does the same thing... 8 straights :-(but the counts are right...soon as it's done (locked up during save) I will add tonight's draw and see if the pick from last draw changes... I have a feeling it won't.

Reply #100

Pogo — Sat, 07 Jan 2006 00:05:48 GMT

That's the exact same formula I'm using. I think it including the current search item was throwing it off, but it severely hurts the number of hits you get. But the data seems to be better. The numbers it produced for tonight's drawings are: (27 of them) lots of ties for the number counts, but here goes: 411, 412, 415, 481, 482, 485, 491, 492, 495, 511, 512, 515, 581, 582, 585, 591, 592, 595, 711, 712, 715, 781, 782, 785, 791, 792, and 795. Night time numbers in VA have a lot more ties going on.... [ More ]

Reply #99

xavier102772 — Fri, 06 Jan 2006 23:33:52 GMT

Just went through your spreadsheet with my updated formula soniq......well about 5000 draws anyway. Thought I'd just do half or so, cause it's so big. Anyway, 4 hits was all it got. I'll try your formula to see how it counts as well.

Reply #98

hypersoniq — Fri, 06 Jan 2006 23:27:03 GMT

sometimes simple is better...gonna try this...=SUMPRODUCT(--($M$3:$M1801=$M1802),--($J$3:$J1801=Q$1))note the range is restricted to data above the required match, might have been a less serious formula error because the target was part of the results... waiting to see (another recalc...)if the system appears to count correctly I will put it up when done, then update the others and put them up as recalcs get done.

Reply #97

hareless — Fri, 06 Jan 2006 23:17:53 GMT

I think I may have something you want to look at. When I get to work I will send it over.

Reply #96

xavier102772 — Fri, 06 Jan 2006 21:06:20 GMT

Just finished checking through my 3240 draw history with the updated couting formula. 6 hits in 3240 draws. Well, it's not amazing anymore, but it does beat random expectation which is only 3 hits. I believe somebody mentioned it, but perhaps by counting the number of times each digit follows the last digit for each position and then choosing the digit which has the highest combined hits with soniq's number choice method and this one, perhaps that would produce a greater number of hits. I'm g... [ More ]

Reply #95

hareless — Fri, 06 Jan 2006 20:34:34 GMT

thanks! will check it out later.

Reply #94

Pogo — Fri, 06 Jan 2006 20:25:37 GMT

I calculated last night for midday pick 3 midday pick 4 as:256 0313 respectively with a few other numbers ($12 at $1 per a pick 3 or pick 4) Today's midday drawing for Pick 3 Pick 4 in VA were:258 3033 respectively... ...so we're getting closer!!! -PoGo

Reply #93

xavier102772 — Fri, 06 Jan 2006 19:56:43 GMT

If anyone is curious as to how to fix the counting for the spreadsheet, I modified the formula to correct the counting. I checked back manually and it counts the exact number of hits. Just a warning, the result is not very good for hits. Looks like the counting of the forward digit really skews the results. Anyway, with the corrected counting it produces only a couple straight hits. The following is for the first 0 digit count. For the second digit just change the first Q$1 to r$11 and so o... [ More ]

Reply #92

Pogo — Fri, 06 Jan 2006 16:01:35 GMT

Soniq, I too made the changes of losing the -1 looking for the number pairs' matches by using the previous line. Here's the code I use for identifying a tie.=COUNTIF(Q3418:Z3418,AA3418)This is for the first digit it replaces the row AB which is previously unused. I then added conditional formatting to turn the background rose colored, if and only if it counts a tie.Hope you like it, Pogo

Reply #91

Zoozie — Fri, 06 Jan 2006 13:09:15 GMT

I don't mind excel - and can download the sheet... just hope it is for the non-excel users - KISS. :)Basically where we can download the excel sheet, input our numbers and see the numbers we should play without having to figure out -1, algorithms, etc. LOL

Reply #90

moreno1966 — Fri, 06 Jan 2006 12:57:28 GMT

same here zoozie. not excel train.regular numbers guy.hope it is in basic for us not into excel hypersoniq.thanks from all of here at lp

Reply #89

Zoozie — Fri, 06 Jan 2006 12:34:11 GMT

Hypersoniq - Great Job! I do hope the new version of your program includes basic set up/use for the non-excel folks like me. Seeing all of you put your heads together on this project ROCKS!I would help Hypersoniq... but excel is not my cup of tea. Looking forward to your new update.

Reply #88

hypersoniq — Fri, 06 Jan 2006 11:02:05 GMT

finally back online... installed a new LinkSYS cablemodem. (old modem failing intermittently)went from 1.7 megabits/sec up to 6 megabits/sec... blazing speed for under $80 ;-)I really need to figure the count error out. I have an idea, lose the -1 and just look one row above where the formula is, for example, calculating row 2000 make search range from 3 to 1999 (lose the recalc time of the IF)I also would like to get rid of the staleness that kicks in, what if the 0-9 count order (important whe... [ More ]

Reply #87

Pogo — Fri, 06 Jan 2006 08:08:37 GMT

Thanks for the info. Xavier, Pogo

Reply #86

xavier102772 — Fri, 06 Jan 2006 07:05:00 GMT

Every time I've done a manual count it's been off. And not just off by the one count of one digit, but in multiple digits counted and it's quite difficult to figure out why the formula isn't working. The reason why there is such a huge number of hits in the beginning is because of the offcounting, especially the future draw count. This skews the results majorly. In the beginning, the huge number of hits occur because the only digits counted are gonna be the following draws digits, and therefore... [ More ]

Reply #85

Pogo — Fri, 06 Jan 2006 06:51:45 GMT

That's a good idea. I'll just make tomorrow a dry run.But, I have been hand calculating everything to ensure his coding is correct, and thus far - it is dead on.Love the input everyone!Thank You,Pogo

Reply #84

Pogo — Fri, 06 Jan 2006 06:49:23 GMT

Well, not really much to tell, but I found, if you provide about 6 to 9 months worth of data prior to the date you want it to select numbers for. After you hit F9 and it recalculates, you pretty much have a choice of 2 numbers for each digit. And, when you have only 2 picks for each digit, it only takes 8 combinations to cover all possible combinations. Therefore, if the first digit is a 1 or 2, the second digit is a 3 or 4, and the last digit is a 5 or 6. You get this for combinations: 135, 136... [ More ]

Reply #83

xavier102772 — Fri, 06 Jan 2006 06:37:52 GMT

Pogo, I really wouldn't be wagering anything just yet unless you fixed the way the spreadsheet does it's counting. I hope you win Pogo, but I'm pretty sure you won't be winning tomorrow. Not to be cynical or negative, but I think patience and looking more closely at soniq's spreadsheets and waiting till soniq posts back on here would be prudent.

Reply #82

hareless — Fri, 06 Jan 2006 06:31:44 GMT

explain? more

Reply #81

Pogo — Fri, 06 Jan 2006 06:29:48 GMT

Startling News for my trials... ...VA numbers I'm using between 6 months (160 draws) 9 months (235 draws).Without using my corrected data, I'm averaging 82 out of 160 draws 120 out of 235 draws.I told you previously about adding an additional line to highlight when a draw has a tie. Well, when I use this data it corrects the few numbers (usually 1 number wrong for each pick 3) and I end up averaging 160 out of 160 235 out of 235.Again all of this data is using only 6 or 9 months worth of b... [ More ]

Reply #80

hareless — Fri, 06 Jan 2006 06:23:11 GMT

hmm. I think it Bill Gates fault. Maybe we should switch to the other side.Ha

Reply #79

xavier102772 — Fri, 06 Jan 2006 06:19:35 GMT

Going from retiring on this system to being dejected by it. :( I think I'm just gonna wait till hypersoniq gives us an update on his progress, because the more I look at it, the more the counting is off. Just for laughs, I modified the counting formula to not count the following digit in it's current counts to get an accurate count. I believe I had an accurate formula. What happened? The hits dropped down to 6 in 3240 draws from the original 47 hits. Not quite break even. I could still be off wi... [ More ]

Reply #78

hareless — Fri, 06 Jan 2006 06:02:58 GMT

I was actually thinking about that and was going to test it later. I did try applying vtrac numbers instead and it came with the same results.2000 heh? I wasn't sure where to start. Thanks for that.When I get time I will post you my hit ratio as well as what happens with the new test of 2000. \Melissa

Reply #77

xavier102772 — Thu, 05 Jan 2006 20:53:37 GMT

Looking at the skips in my original file. If you just played 12 draws after a hit, you would have spent $484(played only 484 draws) and would have won 14(14*$500=$7000) times. That's a 7000/484=17.67 win/loss ratio. Can't wait to see the new spreadsheets from soniq.

Reply #76

xavier102772 — Thu, 05 Jan 2006 20:01:04 GMT

Comparing the two files some more. The same 3 digit pick3 number appears to be the same 1 out of 7 draws or so. The wins are 7 that are the same picked number in each file. Draws played = 2000/7 = 285Amount Wagered = 285*2 = 570 Amount Won = 14*500 = 7000Win/Loss Ratio = 7000/570 = 12.28 Amazing.

Reply #75

xavier102772 — Thu, 05 Jan 2006 19:41:36 GMT

More interesting things about this system is the fact you can modify the draw history to check back various amounts and increase the number of wins substantially. I just did a small test on using only the past 2000 draws. Not a rolling 2000 draws like soniq's new sheets are, but just 2000 draws. It came back with approximately the same amount of hits, with approximately 1/4 of the hits being the same as the original draw sheet and the others being new hits. So essentially I had 47 hits in my... [ More ]

Reply #74

xavier102772 — Thu, 05 Jan 2006 18:12:51 GMT

Did some calculations based on the skips of hits in my drawing history using soniq's system. Here are the results(History has 3241 draws with 47 hits from soniq's spreadsheet, which is approximately 5.23 hits/year):STDEVMEDAVG1STD(.68)2STD(.95)3STD(.99)76.048533664.7234129.4468194.1702258.8936 Skips88186752221399027632351359924279383234850931235814373027841453626611102212531635936205123592 206

Reply #73

hareless — Thu, 05 Jan 2006 17:45:49 GMT

OK OK. I see now why the pick changes. Now that I have had time to go back and learn something.I shutup now.

Reply #72

hareless — Thu, 05 Jan 2006 17:17:39 GMT

oh well, I am pretty sure people are paying attention.I am starting to understand why he is waiting until he is done before posting the new ones.

Reply #71

hareless — Thu, 05 Jan 2006 17:15:49 GMT

oh yeah, doh. I wasn't really thinking about what he was saying. I know that if the new pick has a 0 it will highlight and mark as x because of the 000 in j, k, and l.I was just stuck in the fact the previous days picks were changing when you entered in the new draw....which I may or may not matter.

Reply #70

xavier102772 — Thu, 05 Jan 2006 16:24:07 GMT

Agreed hareless. Surprising everyone isn't all over this like white on rice. Looking at the history for my draws. I should be getting a hit pretty soon since it hasn't hit for about 180 draws, which is unusual for the Western Canada Pick3 history. Also, can't wait for all soniq's sheet's. Definately gold.

Reply #69

hareless — Thu, 05 Jan 2006 15:55:15 GMT

yeah, soniq is really on the something.

Reply #68

xavier102772 — Thu, 05 Jan 2006 15:29:52 GMT

My bad. I should have been more thorough with my counting. The counting is just off by one on pretty much every count as per soniq. Sorry. I really need to learn how to count. Maybe back to grade school. LOL.

Reply #67

hypersoniq — Thu, 05 Jan 2006 11:06:09 GMT

it does count the match it has, that's why the -1 is in there... to make sure you don't haave info that you wouldn't before hand.for the error, It may be becaue the announcer before you enter the next draw is 000 which then changes to the number when you enter it... if a 0 is called for, it highlights even tho it wasn't picked.I will continue to look into this... by tonight or fri... I will replace the sheets on my website with all 4 variants of the pick3... if that gets the bugs squished, pick4... [ More ]

Reply #66

hareless — Thu, 05 Jan 2006 04:51:03 GMT

no I noticed it too. I am having a problem with the columns that play new picks period.

Reply #65

retxx — Thu, 05 Jan 2006 03:40:31 GMT

I am confused also because i notice in the column that picks the new number to play it highlights pos. as if they were allready winning numbers drawn. Anyone else see this

Reply #64

Pogo — Thu, 05 Jan 2006 03:24:09 GMT

I have been giving it a whirl too, and it looks like the problem is that is counts the number that it is trying to match.For example: Previous number is 883 and current number is 230, so you get the 2 digit code 82, when it searches for 82 as a match it not onlys counts all previous 82 instances - it's also counting that very same instance. Not only am I finding this to disturb the count, but it is also resulting in the false correct picks. Again, if it didn't count the 82 code that it is actu... [ More ]

Reply #63

hareless — Wed, 04 Jan 2006 22:00:11 GMT

yeah I fixed the link, but I don't know how to make the zip file public. Work on it later.

Reply #62

xavier102772 — Wed, 04 Jan 2006 21:58:46 GMT

I used the file you emailed me to check through. The link to your ftp doesn't seem to work.

Reply #61

xavier102772 — Wed, 04 Jan 2006 21:57:16 GMT

Just looking through yours hareless. It doesn't count correctly either. I'm trying to figure out a formula that does count correctly. Although, I guess if the wrong formula produces so many wins, do we care if the formula is wrong or what it is doing as long as it keeps winning. Probably not, but I think we should get down to the bottom of the formula.

Reply #60

hareless — Wed, 04 Jan 2006 21:22:58 GMT

try this againhere ya go

Reply #59

hareless — Wed, 04 Jan 2006 20:48:16 GMT

well, excel is still busy, but I was able to FTP it to my site without my computer getting up and wacking me upside the head. I think it wanted too though.here's the link

Reply #58

hareless — Wed, 04 Jan 2006 20:25:50 GMT

also when I get done I am going to zip the file and put in on my ftp site so anyone can grab it.

Reply #57

hareless — Wed, 04 Jan 2006 20:23:20 GMT

I will check. I am calculating right now so its in a trance...LOL.Is it thursday or Friday yet?One thing I have noticed lately, is when I put in the new draw, the previous days pick changes but it keeps whatever number does hit ( think). I know it wasn't doing that originally. First I noticed in in the night, but my day and combine were fine. I reapplied the formulas for those 3 columns for night and it was fine after that. but now my day and combine are doing that. It doesn't make any sense to... [ More ]

Reply #56

xavier102772 — Wed, 04 Jan 2006 17:00:04 GMT

hareless, perhaps you could check your files as well? maybe it's just my excel. not likely, but it's possible.

Reply #55

xavier102772 — Wed, 04 Jan 2006 16:58:19 GMT

yep, looks like the bug is in your original file as well. definately does not count correctly.

Reply #54

xavier102772 — Wed, 04 Jan 2006 16:52:55 GMT

Yes, definately a counting error bug Soniq. Doing a few checks:announcer numbers 51: excel counted digit #2, 1 time; should have counted digit #1, 1 time and digit #2, 1 time. announcer numbers 56: excel counted digit #2, 1 time and digit #5, 1 time; should have counted digit #2, 2 times and digit #5, 1 time. I can send you my file if you want to check/verify. I'll be doing a quick check of your original data file momentarily and let you know if the bug is there as well. Pretty sure it will... [ More ]

Reply #53

xavier102772 — Wed, 04 Jan 2006 16:34:06 GMT

Been trying to do a test on getting a 3 number straight pick. I deleted all the rows until the row prior to the win and when I try to run it and recalculate, excel either doesn't calculate or it calculates incorrectly. The hits that ocurred for the precursor don't show up in the count section. I went back ad manually checked and they should be there but they aren't counted. Usually I just get the winner to be 000, which is not correct. Is there something I need to do to get it to work corre... [ More ]

Reply #52

xavier102772 — Wed, 04 Jan 2006 15:41:18 GMT

Thanks soniq. Also, if you have time could you post the high to low digit versions as well. Or alternately, if you let us know the formula and what the new formula are that need to be changed. Since we have the base version right now, that may be easiest.

Reply #51

hypersoniq — Wed, 04 Jan 2006 10:46:06 GMT

thanks everyone for all the kind words and helpin' eachother out! 1 reason why LP is the best!I will replace the SB3 and SB4 sheets on my website with the rolling history versions either thurs. or fri., when I have some more time. (SB4_roll not finished yet)right now, my cable modem is getting some wierd intermittent failures (needs to be replaced, doing that tonight with a new LinkSys model.I posted older versions to the website by mistake, hareless has the right one at the moment, the problem... [ More ]

Reply #50

hareless — Wed, 04 Jan 2006 01:29:09 GMT

And by the way soniq, I am willing to work on more states for you.

Reply #49

hareless — Wed, 04 Jan 2006 01:28:08 GMT

No problem. Hope it helps. I can't wait to see the new sheet. Esp since I am having that funky problem with the predition draws. It could just be my beat down processor, I think its time for a new one. plus im not sure what was changed to reverse the order of the digits.

Reply #48

xavier102772 — Tue, 03 Jan 2006 22:10:32 GMT

Thanks for the updated spreadsheet hairless. Total number of straight hits(3) for my 3240 pick3 draws in Western Canada is 47. Cost of play = $3240Winnings = 47 * 500 = $235007.25 ratio of cost to winnings. Nice.Side note for Soniq: The greatest frequency of hits in my draws occurred between ~1400-1800 draws for 11 hits out of the 47. Which seems to be hitting at double the frequency of the rest of the draw history. If you have the other spreadsheet with the rolling history and the new tie

Reply #47

hareless — Tue, 03 Jan 2006 18:40:58 GMT

yes I did, but when it was fixed, it was in the 40's. what is your email

Reply #46

xavier102772 — Tue, 03 Jan 2006 18:38:31 GMT

Yeah, it looks like patience is key when waiting for the sheet to update. If you could send the updated spreadsheet I would definately appreciate it. Thanks hareless. Oh and BTW, did you get similar results with the hits when you had the -1's in your original spreadsheet

Reply #45

hareless — Tue, 03 Jan 2006 18:07:47 GMT

well, when its calculating, it will appear as if its locked up. You have to wait. If you hit cntrl alt dlt to get to task manager you will see the process moving for excel. In windows xp, it may even say not responding under applications but under processes, it will be moving.it takes a while! He fixed my sheet that had negative ones, I can send it to you if you like.

Reply #44

xavier102772 — Tue, 03 Jan 2006 18:00:27 GMT

Ok, I figured it out. Looks like I had spaces in my data that weren't supposed to be there. I have the -1's in my sheet. Just wondering if you can send me the updated formula's for the spreadsheet for the pick3 soniq? Thanks. However, something I did find very interesting was that in my data I had 91 straight hits in the first 350 draws, then there was 45 for the remaining 2890 draws. Hopefully it's not something wrong with what I did. Disregarding the 91 hits: 45*500=225003240 draws *1=3... [ More ]

Reply #43

xavier102772 — Tue, 03 Jan 2006 16:37:48 GMT

Possibly a stupid question Soniq but if I deleted all the draws except the last one in your pick3 spreadsheet and replaced them with the ones from my pick3 game and then copied your formula to all the rows; if I pressed F9 at that point, would it recalculate correctly then. I'm not bad with excel, but trying last night, Excel would either lock up on me or wouldn't recalculate and I'd get all # signs and no updated numbers. Any help would be appreciated. Also, if you have the updated sheet wit... [ More ]

Reply #42

retxx — Tue, 03 Jan 2006 16:29:34 GMT

hyper your instructions for using the F9 were perfect. I would like to express my appreciation for all the help we all get from hyper on this forum. Just wait till his v.2 is ready. I think it might help to increase profits for all who choose to use it. Again thanks for all your hard work that you have put into this.

Reply #41

hypersoniq — Tue, 03 Jan 2006 10:23:52 GMT

I like that idea!the ratio I'm after improving is plays to hits... that's LOWwe seem to be doing good in bets to prize money, and improving plays to hits will make that go up even further.

Reply #40

xavier102772 — Tue, 03 Jan 2006 07:16:54 GMT

Just a simple idea for you Soniq. Perhaps you could incorporate a count of the skips between the straight hits in your spreadsheet. This way you can play less and hopefully increase your winning vs spending ratio. Also, calculate the median skip of the hits so that you could employ a strategy to take advantage of the skips and it's median.

Reply #39

hypersoniq — Tue, 03 Jan 2006 04:14:26 GMT

retxx: you can feel free to experiment and you can use the MASS 4 sheet as-is for now,but if you prefer to wait, I think the results will end up being better in the long run.but DO feel free to check out different scenarios. You can't break the sheet,and if you do...d/l it again

Reply #38

retxx — Tue, 03 Jan 2006 03:27:33 GMT

I think I might just delete all the versions for now and wait for your green light on V2. Do you agree hyper

Reply #37

hypersoniq — Tue, 03 Jan 2006 02:31:51 GMT

the other version of the P3 SB sheet, the high-to-low... produced 134 hits! (had 83)only missed 1986, picked 2 straights in 2005...made $25,500 MORE than with full history!for kicks, playing both...cost = $19,774total won = $125,000net profit = $105,226all without missing at least ONE straight hit EVERY YEAR!I gotta do some more comparisons, but this seems like it's working

Reply #36

hypersoniq — Tue, 03 Jan 2006 01:29:00 GMT

WOW!rolling history is the ticket!!!!!!!!116 hits on the sheet that had 64!only year missed was 1983!!!!!!!!!!!!!!that's $26,000 MORE than the entire history pick!last wins = 4 straight in 2005!!!!I MUST apply this to the sheet with over 800 wins...this does it! beats money won AND the Cyclic hit rate!2000 draw rolling history was the knockout punch! Thanks WSLS for sending me down that road for ideas!this is gonna take forever in pick4, but it should be worth it in the end...with results like... [ More ]

Reply #35

hypersoniq — Tue, 03 Jan 2006 00:37:24 GMT

first sheet is undergoing recalc... hoping it gets done in under 2 hours :-(this is adding a rolling history (2000 draws at a time) because the system sheets in PA hold the majority of their hits in that range. I am hoping to get recalc time on the PC and have them done by the weekend so I can begin with Version 2. so far every test has returned more hits than the previous one.in the end, the system should spit out 4 numbers for each game (pick4 and pick3)... if they match then you can eliminate... [ More ]

Reply #34

moreno1966 — Tue, 03 Jan 2006 00:29:43 GMT

great job hypersoniq i think this is the one.i'll be keeping a eye in MASS .let you know how it goes.this is it retxx

Reply #33

hypersoniq — Mon, 02 Jan 2006 23:04:59 GMT

recalc done... upped the straight hits from 11 to 15 in PA big 4, but the last hit was 1998 :-(now it's time to see them together...Straight hits low-to-high4/8/19843/25/19884/8/198812/10/19882/26/19899/27/19898/7/19906/7/19951/31/19984/21/19997/20/2001straight hits high-to-low9/30/19829/2/198410/25/19846/11/19866/15/19869/11/19879/1/19899/22/198910/25/19893/28/19914/10/19919/9/19918/17/199211/26/199710/31/1998now let's see the numbers... if you played 2 numbers a day (when they differ would be... [ More ]

Reply #32

hareless — Mon, 02 Jan 2006 22:07:58 GMT

I hope my spreadsheet helps.

Reply #31

hypersoniq — Mon, 02 Jan 2006 21:36:01 GMT

fret not hareless (unless of course you play the guitar) I am working on version 2 which skips backtesting and just gives picks (hoping to make updating for each state a snap)... I outlined my goals for v2 in my blog and also called out openly for requests, so if anyone has requests for the v2, add 'em to my blog... I will start a new thread for v2 when it's ready for distribution.before I work on v2 though, I need to do recalcs for rolling history...right now I am maintaining 4 sheets (pick3, t... [ More ]

Reply #30

hareless — Mon, 02 Jan 2006 21:06:09 GMT

yeah, I feel your pain.

Reply #29

hypersoniq — Mon, 02 Jan 2006 20:55:45 GMT

before I do rolling history calcs, I am trying the reverse digit scenario on the pa pick 4 to see if it hits more than 11...should be a 1 hour recalc minimum

Reply #28

hareless — Mon, 02 Jan 2006 20:43:03 GMT

sorry. meant digits.Ok, got it.

Reply #27

hypersoniq — Mon, 02 Jan 2006 14:39:04 GMT

not the draw, I jst altered how it chooses the winner of a tie.first way, lower number would win (if 3 had 12 matches and 7 had 12 matches, 3 would get picked... now 7 would.

Reply #26

hareless — Mon, 02 Jan 2006 07:59:04 GMT

well, what do you mean by reverse the order of the draw

Reply #25

hypersoniq — Mon, 02 Jan 2006 06:30:43 GMT

next experiment for me is a rolling history range, going to analyze data and see if confining history to 1,800 to 2,000 draws produces better results.

Reply #24

hypersoniq — Mon, 02 Jan 2006 06:29:24 GMT

retxx, I fixed the bad link, it loads now.

Reply #23

retxx — Mon, 02 Jan 2006 02:50:09 GMT

I sent you an e-mail saying when i tried to download the sbmass 4 excel I hit save as and it comes up as sb3. don't know why. maybe if you e-mail it it will work. Thanks salesmn419@aol.com

Reply #22

Greg — Mon, 02 Jan 2006 01:43:56 GMT

Hypersoniq, I love your HYPERBRILLIANCE!When the PA Lottery tries to buy you out, REFUSE! You da man

Reply #21

hareless — Mon, 02 Jan 2006 00:05:29 GMT

reverse the order of the digits

Reply #20

hypersoniq — Sat, 31 Dec 2005 20:00:34 GMT

I reversed the order of the digits in Q-Z, AC-AL and AO-AX to read 9-0 instead of 0-9resultshits up to 83! all it does different is pick the HIGHEST number in a tie... rather than the lowest.frequency is a bit better too, fewer missed yearsmissed 1997-1999, 2003, and 2005best years are a tie... 1977 and 1980 with 12 hits each.overall statscost to play = $9,885total won = $41,500total profit = $31,615small improvement, but it is a change in the right direction

Reply #19

hypersoniq — Sat, 31 Dec 2005 17:59:03 GMT

Massachusetts Numbers Game (pick 4) version is available on the website. breakdown is in my blog, but in a nutsahell, 13 straight 4/4 hits.that was a request from retxx, I won't be able to do all states this way (over 3 hours to recalc on a pentium4@2.6GHz), version 2 (without backtesting) will be easier. (and will eventually replace the ones on the website)... I have no timeline for version2 release because I still need to figure it all out yet, but I AM working on it.

Reply #18

hareless — Sat, 31 Dec 2005 09:51:16 GMT

All I can say is wow. Been working on this for a few hours.I will have something to send you soon.Thats pretty awesome soniq. I am speechless.

Reply #17

hypersoniq — Sat, 31 Dec 2005 05:45:40 GMT

WSLS:not sure, I think I will need to look at that high hit area.I was contemplating a rolling history formula, that takes into account 2000 draws at a time, maybe only 1800... just to see if that makes a difference.another thing I want to do is change the reference columns for each position from 0-9 to 9-0, this would break ties by picking a higher, rather than lower number.I think the 1393-1786 phenomenon is because the data isn't as bulky... using all of history might be smoothing the data t... [ More ]