need excel guru & master

Reply #24

SirMetro — Sat, 11 Feb 2006 16:00:39 GMT

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 appear... [ More ]

Reply #23

sysp34 — Sat, 11 Feb 2006 15:30:59 GMT

dear 4d hobbiest

just sharing another spreadsheet

zip files 346kb : http://www10.rapidupload.com/d.php?file=dl filepath=18081

just copy and paste last 100 draws and combine with pro filter pick3 and good luck

regards

sysp34

Reply #22

sysp34 — Wed, 08 Feb 2006 13:17:15 GMT

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

use last 95 draw for consecutive day and or

last 95 draw weekly

eg: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

1st week, 2nd week, 3rd week, 4th week

1,2,3,...31

for those drawing files find the highes... [ More ]

Reply #21

retxx — Mon, 06 Feb 2006 17:49:18 GMT

P.S. i can e-mail my screen that I changed to see if anyone can make corrections to adjust the other screens.

Reply #20

retxx — Mon, 06 Feb 2006 17:47:07 GMT

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

Reply #19

sysp34 — Mon, 06 Feb 2006 16:15:56 GMT

dear bob,

the problem is monthly range must be modified manually :)

column M to V

column BB to CT

eg: at .xls

zip format 104 kb : http://www.rapidupload.com/d.php?file=dl filepath=9743

xls format 409 kb: http://www10.rapidupload.com/d.php?file=dl filepath=16422

date 1st 2nd 3rd

3 02/02/87 064 0 6 4

02/09/87 502 5 0 2

02/16/87 615 6 1 5

02/23/87 099 0 9 9

7 02/01/88 961 9

Reply #18

sysp34 — Mon, 06 Feb 2006 14:49:08 GMT

Quote: Originally posted by hypersoniq on February 4, 2006 check out the .xls file

it's quite complex... even more so than the description above...

6 worksheets

it will take some time just to figure this thing out... let alone whatever added functionality is requested...

bro hypersonic

here are the modify .xls for pick 3 only.

zip format 104 kb : http://www.rapidupload.com/d.php?file=dl filepath=9743

xls format 409 kb: http://www10.rapidupload.com/d.php?file=dl filepat... [ More ]

Reply #17

sysp34 — Mon, 06 Feb 2006 14:43:28 GMT

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

regards

sysp34

Reply #16

wdthing — Mon, 06 Feb 2006 03:55:01 GMT

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

Reply #15

LANTERN — Mon, 06 Feb 2006 02:53:11 GMT

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 predi... [ More ]

Reply #14

LANTERN — Mon, 06 Feb 2006 02:41:48 GMT

It is also the word for free in Spanish. Which is a second language here in the USA. And so known by some non spanish people also.

Reply #13

paurths — Sun, 05 Feb 2006 19:32:32 GMT

lol

I know what it means, it's indeed the word for free in the language i speak.

I was just wondering how/why you would come up with it.

Reply #12

time*treat — Sun, 05 Feb 2006 19:13:30 GMT

gratis = free, but I did say at worst .

Reply #11

paurths — Sun, 05 Feb 2006 14:02:40 GMT

gratis effort

Reply #10

powerplayer — Sun, 05 Feb 2006 09:36:07 GMT

sysp34,

Thank you for sharing your sheet. I have been able to use multiple formulas from the sheet.

Still looking over sheet. Nice work by the way!!

If I can help in anyway I will post for u.

Can u give a example of what your trying to change/do???

Thx

PP

Reply #9

sysp34 — Sun, 05 Feb 2006 07:04:39 GMT

i speak javanesse sorry if my english so bad

the file .xls design for monthly analysis.

i don't have any idea to create formula with week, or month conditions as a filter because the pick 3 in my study will be balance (the number 0 to 9 should appears) the combination of monthly, weekly, and consecutive daily will be a good strategy to predict the next drawing.

is there any master or anyone guide me

regards

sysp34

Reply #8

LANTERN — Sun, 05 Feb 2006 06:39:07 GMT

Also, by the way, it is a little hard to understand you, which other language do you speak besides English (If any other

Reply #7

LANTERN — Sun, 05 Feb 2006 06:36:25 GMT

Your filters are for doing Monthly and or Weekly predictions ?

I only used filters when I did, back then, for predicting for the very next draw, not for many future draws as some others do here at the lottery post. I can program by the way and don't even know how to use Exel, I have never tried to learn yet. HyperSoniq might help you with your Exel spreadsheet in time as he learns about it if he can, as to filters, well I only did them for the very next draw and no programming, for programmi... [ More ]

Reply #6

sysp34 — Sun, 05 Feb 2006 06:22:02 GMT

well the disadvantage is the monthly filter must be create by your self (it take a time and attention)

i can't create the MONTHLY or maybe WEEKLY filter (it must be manually)

is there any master / anyone guide me to solve this step??? i have no idea

help me please.

regards

sysp34

Reply #5

Tenaj — Sun, 05 Feb 2006 05:56:32 GMT

Reply #4

LANTERN — Sun, 05 Feb 2006 05:39:12 GMT

Same here !

He's been Lurking for a while, I guess (?), Learning (?) or already knew (?), He is getting filters' stats with the spreadsheet, very good !, All is stats and their proper use, there is nothing else to use.

A brain and programming skills together in the same person, he is dangerous. Just kidding

Good luck

Reply #3

hypersoniq — Sat, 04 Feb 2006 17:11:26 GMT

check out the .xls file

it's quite complex... even more so than the description above...

6 worksheets

it will take some time just to figure this thing out... let alone whatever added functionality is requested...

Reply #2

time*treat — Fri, 03 Feb 2006 18:12:40 GMT

At worst, someone is asking for a whole bunch of gratis effort.

At best, I am not understanding this post.

Reply #1

lottaloot — Fri, 03 Feb 2006 15:43:02 GMT

WOW! (says the Lootster with eyes big glazed over

need excel guru & master

sysp34 — Fri, 03 Feb 2006 10:25:30 GMT

Dear Lottery Post Member, guru & excel master

please help me with macros cause i don't familiar with those step,

only a simple function :)

the file sysp34.xls are sunday draw with month febuary from 1987 (SG4D lottery)

download link:

zip format

http://www.rapidupload.com/d.php?file=dl&filepath=9720

excel format

http://www.rapidupload.com/d.php?file=dl&filepath=9721

please copy the link& paste to your internet browser

it's need a lot of step to all lottery state, ple... [ More ]