need a macro enlighten for dynamic skip and hit interval

Reply #12

paurths — Mon, 03 Jul 2006 14:00:03 GMT

I don't eat that much, but i sometimes drink enough for an entire week lol!

Go France!!!!! Go Zizou

Reply #11

LANTERN — Mon, 03 Jul 2006 11:14:54 GMT

The 3 last lines of Key Numbers commands is a special key numbers technique and so perhaps very hard to understand.

Reply #10

LANTERN — Mon, 03 Jul 2006 11:11:17 GMT

I know that the use of these layouts is hard to understand to those not familiar with the particular program, but What can I do or say?

Those are just some very good layouts, but not all of them, just most of them.

Reply #9

LANTERN — Mon, 03 Jul 2006 11:08:18 GMT

Layout for doubles:

<AddList:NumberClasses> B

<SelectFilter:NumberTypes> S,D

<AddList:Numbers:FromLotteryProgram>

<SubtractList:AbbrSums:LastDraw>

<SubtractList:Roots:LastDraw>

<SubtractList:LineWidth:9+Last2Draws>

<SubtractList:Roots:2ndLastDraw>

<SubtractList:Sums:3rdLastDraw>

<SubtractList:Pairs:LastDraw>

<SelectFilter:Pairs:>

<SubtractList:BoxedNumbers:Last26Draws>

<SelectFilter:KeyNumbers:0,1,2,3,4,5,6,CountFromLth-Rth,GoingDown,BeginWithLastDraw>

<SelectFilter:KeyNumb... [ More ]

Reply #8

LANTERN — Mon, 03 Jul 2006 10:54:05 GMT

Ricky

Yes, I know. Not to worry.

Thanks a lot.

Fernando.

Reply #7

CARBOB — Mon, 03 Jul 2006 10:53:33 GMT

Ricky,

You mean, you have to eat, sleep and work? LOL

Go Germany

Reply #6

paurths — Mon, 03 Jul 2006 10:17:46 GMT

lol Fernando,

there are only 24 hours in 1 day...

greetz

Ricky

Reply #5

LANTERN — Mon, 03 Jul 2006 10:06:28 GMT

sysp34

My friend, You are both: The Master and The Professor, hardly anybody is a match for you, you are almost The Predictor Supreme or maybe you already are, you seem to already be.

You have left me and many others very far behind.

This does not mean that you know everything and that have no more to learn, as I have never posted about everything that I know about filters and I learn more as time goes by, for example: I just today, by meditating on the Lotto 007 P3P4Demo program's fil... [ More ]

Reply #4

sysp34 — Sun, 02 Jul 2006 08:43:37 GMT

Fernando, my friends

i think that not possible to do in worksheet, because the dynamically conditions.

btw tx eve only cacth pair x38 lol still need learn from the PROFESSOR. :)

well thanks and good luck.

Reply #3

LANTERN — Sun, 02 Jul 2006 08:02:29 GMT

Who will help sysp34?

Whoever helps him might also be helping himself in the end, after sysp34 adds those macros into his spreadsheet(s).

Reply #2

sysp34 — Thu, 29 Jun 2006 02:02:32 GMT

Sir Metro,

thank for replying,

about dynamic skip and hit interval, i mean after we update drawing files then it should count last 30 skip and 30 hit interval. i though it need macro code because "the code" only count last row.

formula to count skip and hit interval

=IF(OR(((COUNTA(draw!$F$2:$F3)+1)-((COUNTA(draw!$F$2:$F3)+1)-(ROWS(draw!$F$2:$F3)-MATCH(2,1/SEARCH(B$1,draw!$F$2:$F3)))))=0,((COUNTA(draw!$F$2:$F2)+1)-((COUNTA(draw!$F$2:$F2)+1)-(ROWS(draw!$F$2:$F2)-MATCH(2,1/SEARCH(B$1... [ More ]

Reply #1

SirMetro — Thu, 29 Jun 2006 00:54:21 GMT

Please explain the origins of the original numbers so I can better understand how to write the required macro. I have an idea, but need more directions to better implement it.

Sir Metro

need a macro enlighten for dynamic skip and hit interval

sysp34 — Sun, 25 Jun 2006 13:47:57 GMT

Hi Macro/VBA master

is it posible to create dynamic skip and hit interval? because i have created open source spreadsheet that need dynamic skip and hit interval for smaller size and faster spreadsheet.

here is the link:

http://rapidshare.de/files/24071533/syshac1k.zip.html (1251 KB)

well i hope any Macro/VBA master would enlighten me.

so far the result like this

h.c.a

103 203 803 143 243 843

153 253 853 106 206 806

146 246 846 156 256 856

107 207 807 147 247 847

1... [ More ]