need a macro enlighten for dynamic skip and hit intervalPrev Topic Next Topic

New Topic New Poll

sysp34

Heroic City
Indonesia
Member #31,688
February 2, 2006
1,153 Posts
Offline

Jun 25, 2006, 9:47 am

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
157 257 857 109 209 809
149 249 849 159 259 859
for 15 state with eve drawing
--------------------------------
Monday, June 19, 2006
California 3-1-5
Florida 1-7-4
Louisiana 0-2-9
Michigan 0-6-1
New Mexico 0-1-7
New York 9-1-5*
Ohio 3-4-8 5-2-7
Tennessee 0-3-2*
Virginia 5-8-6*
9 hit with 3 correct state (eve)
--------------------------------
Tuesday, June 20, 2006
Connecticut 1-6-4
Delaware 2-6-4
Michigan 8-0-7
Missouri 1-9-5
Virginia 2-6-0*
Washington, D.C. 2-6-4
6 hit with 1 correct state (eve)
--------------------------------
Wednesday, June 21, 2006
Connecticut 0-1-9*
Georgia 2-0-7 6-1-0*
Maryland 1-7-0
Texas 1-0-3 0-7-2*
Tri-State 0-1-7*
Virginia 0-8-3*
6 hit with 5 correct state (eve)
--------------------------------
Thursday, June 22, 2006
Illinois 8-3-4
Maryland 9-4-1
New York 4-7-2
South Carolina 5-6-8*
Tri-State 7-8-4*
5 hit with 2 correct state (eve)
--------------------------------
Friday, June 23, 2006
Connecticut 4-7-2
Indiana 4-7-2
Missouri 3-8-5
Pennsylvania 3-5-2
Tri-State 0-6-1*
Virginia 3-1-0*
Washington 7-5-8
Washington, D.C. 1-3-4
8 hit with 2 correct state (eve)
--------------------------------
Saturday, June 23, 2006
Connecticut 2-0-3
Minnesota 0-3-1
Nebraska 1-0-7
New York 0-3-2 9-5-1*
Ontario 1-7-5
Puerto Rico 2-0-6
South Carolina 1-0-7
Tennessee 2-5-7*
Washington, D.C. 1-4-3
10 hit with 2 correct state (eve)
--------------------------------
thank and good luck
sysp34
SirMetro

East of Atlanta
United States
Member #6,191
August 11, 2004
1,390 Posts
Offline

Jun 28, 2006, 8:54 pm

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
sysp34

Heroic City
Indonesia
Member #31,688
February 2, 2006
1,153 Posts
Offline

Jun 28, 2006, 10:02 pm

Quote: Originally posted by SirMetro on June 28, 2006
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
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,draw!$F$2:$F2)))))=0),((COUNTA(draw!$F$2:$F2)+1)-((COUNTA(draw!$F$2:$F2)+1)-(ROWS(draw!$F$2:$F2)-MATCH(2,1/SEARCH(B$1,draw!$F$2:$F2))))),"")

it was extended for this formula if(or(a1=0,a2=0),count skip or hit,blank)

00 03 00 00 01 00 04 00 01 00 00 00 07 00 03 00 00 00 00 00 03 00 00 01 00 04 00 00 00 03 00 00 03 00 13 00 01 00 03 00 03 00 01 00 00 03 00 03 00 01 00 03 00 03 00 01 00 04 00 00

therefore we need macro to count ONLY last 30 skip and 30 hit or 60 skip and hit interval for these patterns

a.c.h, 2a.c, 2a.h, 2c.a, 2h.a, 2c.h, 2h.c, 3a, 3c, 3h,

A.A.A, A.A.C, A.A.H, A.C.A, A.H.A, C.A.A, H.A.A, A.C.C, A.C.H, A.H.C, A.H.H, C.A.C, C.A.H, C.C.A, C.H.A, H.A.C, H.A.H, H.C.A, H.H.A, C.C.C, C.C.H, C.H.C, C.H.H, H.C.C, H.C.H, H.H.C, H.H.H
123

AHC
AHC
AHC

single.FD
double.FD
triple.FD

012345
012345
012345

well thanks, i hope we HAC pick 3/4 games lol

if you have any question please make some questionaire and email to me i try to answer your question, because often my neuron are fastest that my hand, that way my english language is worst. lol

sysp34
LANTERN

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jul 2, 2006, 4:02 am

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

BibleOnline ParishesOnline ChristianRadioOnline MassOnline Mass

"Ten measures of beauty descended to the world, nine were taken by Jerusalem."
sysp34

Heroic City
Indonesia
Member #31,688
February 2, 2006
1,153 Posts
Offline

Jul 2, 2006, 4:43 am

Quote: Originally posted by LANTERN on July 2, 2006
Who will help sysp34?
Whoever helps him might also be helping himself in the end, after sysp34 adds those macros into his spreadsheet(s).
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.
LANTERN

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jul 3, 2006, 6:06 am

Quote: Originally posted by sysp34 on July 2, 2006
Quote: Originally posted by LANTERN on July 2, 2006
Who will help sysp34?
Whoever helps him might also be helping himself in the end, after sysp34 adds those macros into his spreadsheet(s).
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.

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 filters, I created new filters, that is possible good variations of some already known filters, they are both: New and old, new uses or new ways of using some filters, but an unknown variation of their regular use, I will add them to my growing list of filters, some of which I might have never posted about, I have showed way too much already as it is and Paurths does not seem to want to add any more filters to his FreeWheelers any-way, not even those of which I have already posted about.
If you can, try to add some VISUAL stats or Graphics to your spreadsheets, as Visual representation(s) of stats can help a lot, you can see things in them that you can't see just with numbers' stats.
Master sysp34, Good luck to you.
Fernando.

BibleOnline ParishesOnline ChristianRadioOnline MassOnline Mass

"Ten measures of beauty descended to the world, nine were taken by Jerusalem."
paurths

Switching between Fairfax, VA and Belgium
Belgium
Member #19,286
July 29, 2005
2,254 Posts
Offline

Jul 3, 2006, 6:17 am

lol Fernando,
there are only 24 hours in 1 day...
greetz
Ricky
CARBOB

COLUMBUS,GA.
United States
Member #4,924
June 3, 2004
6,719 Posts
Offline

Jul 3, 2006, 6:53 am

Quote: Originally posted by paurths on July 3, 2006
lol Fernando,
there are only 24 hours in 1 day...
greetz
Ricky
Ricky,
You mean, you have to eat, sleep and work? LOL
Go Germany!!!
LANTERN

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jul 3, 2006, 6:54 am

Ricky

Yes, I know. Not to worry.

Thanks a lot.

Fernando.

BibleOnline ParishesOnline ChristianRadioOnline MassOnline Mass

"Ten measures of beauty descended to the world, nine were taken by Jerusalem."
LANTERN

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jul 3, 2006, 7:08 am

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:KeyNumbers:4,5,6,7,8,9,SameInstructionsAsAbove>
<SelectFilter:KeyNumbers:5OrfewerDigitsNotForDoubles>

BibleOnline ParishesOnline ChristianRadioOnline MassOnline Mass

"Ten measures of beauty descended to the world, nine were taken by Jerusalem."
LANTERN

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jul 3, 2006, 7:11 am

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.

BibleOnline ParishesOnline ChristianRadioOnline MassOnline Mass

"Ten measures of beauty descended to the world, nine were taken by Jerusalem."
LANTERN

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jul 3, 2006, 7:14 am

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

BibleOnline ParishesOnline ChristianRadioOnline MassOnline Mass

"Ten measures of beauty descended to the world, nine were taken by Jerusalem."
paurths

Switching between Fairfax, VA and Belgium
Belgium
Member #19,286
July 29, 2005
2,254 Posts
Offline

Jul 3, 2006, 10:00 am

Quote: Originally posted by CARBOB on July 3, 2006
Quote: Originally posted by paurths on July 3, 2006
lol Fernando,
there are only 24 hours in 1 day...
greetz
Ricky
Ricky,
You mean, you have to eat, sleep and work? LOL
Go Germany!!!

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

New Topic New Poll

Subscribe to this topic

need a macro enlighten for dynamic skip and hit intervalPrev TopicNext Topic

need a macro enlighten for dynamic skip and hit intervalPrev Topic Next Topic