Tx United States
Member #4,570
May 4, 2004
5,180 Posts
Offline
Sysp34
People are trying to understand your spreadsheet, I am not one of them, I don't do spreadsheets, I also don't do advanced or early future projected predictions, or project predictions into the future, just up to the very next draw, that does not mean that I could not do it, just that I have never really tried, except for one time for a several states 1 week prediction that I did and predicted right in 2 days, it was for about 5 states maybe, I can't remember, but it wasn't a real prediction, I just used a set of good "Generic" numbers.
For next draw predictions I can better help, but all of that is in my past filters' posts.
I don't plan on making very many new filters posts, at least no time soon.
Central Pa. United States
Member #4,076
March 19, 2004
32 Posts
Offline
Ok I take it the information you pasted on to us is from data in your main or general worksheet for ALL past draws and your trying to break it down to weekly and monthly is this correct? Soooooo just insert 2 more worksheets.name one weekly and one monthly and set up your same formulas to keep track of the last 7 or 14 if you have a mid day drawing and do the same for the last 30 or 60 in your monthly worksheet
Heroic City Indonesia
Member #31,688
February 2, 2006
1,153 Posts
Offline
Sysp34
People are trying to understand your spreadsheet, I am not one of them, I don't do spreadsheets, I also don't do advanced or early future projected predictions, or project predictions into the future, just up to the very next draw, that does not mean that I could not do it, just that I have never really tried, except for one time for a several states 1 week prediction that I did and predicted right in 2 days, it was for about 5 states maybe, I can't remember, but it wasn't a real prediction, I just used a set of good "Generic" numbers.
For next draw predictions I can better help, but all of that is in my past filters' posts.
I don't plan on making very many new filters posts, at least no time soon.
Look at the old posts already given.
yes i agree with you Lantern,
if there are so many filter we'll be confused to pick up the "good" number.
the .xls are for my wacth list to reduce p34lotto number by monthly_weekly trends. if there are even,odd,low,high,loweven,lowodd,higheven,highodd tendency i pick that number to reduce the 8 p34lotto component
just sharing the file to select the "favorite" numbers
Heroic City Indonesia
Member #31,688
February 2, 2006
1,153 Posts
Offline
Ok I take it the information you pasted on to us is from data in your main or general worksheet for ALL past draws and your trying to break it down to weekly and monthly is this correct? Soooooo just insert 2 more worksheets.name one weekly and one monthly and set up your same formulas to keep track of the last 7 or 14 if you have a mid day drawing and do the same for the last 30 or 60 in your monthly worksheet
Still don’t have a clue what you’re trying to do.
Bob
dear bob,
the problem is monthly range must be modified manually :)
column M to V =COUNTIF($E3:$G7,M$2) column BB to BG =COUNTIF($W3:$W7,BB$2) column BI to BN =COUNTIF($Z3:$Z7,BI$2) column BP to CA =COUNTIF($AC3:$AC7,BP$2) column CC to CT =COUNTIF(AI3:AI7,"x")
the countif range is row 3 to 7 but the monthly range is 3 to 6 so we must change the countif range row 3 to 6,
and if there a modified cell range then we must modified all function
so far solve with manually: select column M to V and with replace command change 7 with 6 and go to colum BB to CT and with replace command change 7 with 6 and
BOSTON United States
Member #48
September 9, 2001
3,954 Posts
Offline
tell me how to get the next draw to play after i went to sun 2006 screen and deleted all your dates and pick 4 numbers and replaced with jan 1 to current numbers in my state. No other screens updated the change to reflect my changes. i guess it needs macros to do this. correct? Can someone help with what i did/ thanks
Heroic City Indonesia
Member #31,688
February 2, 2006
1,153 Posts
Offline
Dear Pick 4 Hobbiest
just sharing xl sheet use last 95 draw (with 5 draw interval),
xls format 840 kb : http://www7.rapidupload.com/d.php?file=dl&filepath=10173 zip format 197 kb : http://www.rapidupload.com/d.php?file=dl&filepath=9766
East of Atlanta United States
Member #6,191
August 11, 2004
1,390 Posts
Offline
If I read what I think is the simplest request, the solution is ruther simple.
column M to V =COUNTIF($E3:$G7,M$2) the countif range is row 3 to 7 but the monthly range is 3 to 6 so we must change the countif range row 3 to 6,
If the objective is to retain the original formula, all one would have to do is keep that formula on a second sheet. Then simply copy and paste it back to the main work sheet. And yes, one could write a macro to do the same as well.
On a side note, it appears some of the functions are similiar to features that can be found here at LotteryPost if you sign up for the Premium service (well worth it if you play a lot).