Welcome Guest
You last visited December 10, 2016, 7:35 am
All times shown are
Eastern Time (GMT-5:00)

# excel help

Topic closed. 17 replies. Last post 12 years ago by winsumloosesum.

 Page 1 of 2
New Member
macon
United States
Member #12671
March 20, 2005
2 Posts
Offline
 Posted: April 8, 2005, 11:16 pm - IP Logged

any help is appreceated. i need to turn these numbers into a pyramid with the number with the highest value at the top and the lowest value lower right

0= 15                                                                        0
1= 12
2= 8                                                                  7               1
3= 9
4= 8                                                            6            3              4
5= 8
6= 11                                                      5        2            8            9
7= 13
8= 5
9= 4

crude model to give you an idea of what i am trying to do

i can get excel to do everything ok i just got stuck with the numbers with the same value on paper i just use the first number in a games history to break ties in this example 4 shows up most recent in game history.

again if you can help thank you.

ps: cant spell

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: April 9, 2005, 2:19 am - IP Logged

dim digits() as integer, rank() as integer

dim t as integer, rank_val as integer, passes as integer,currentnum as integer

dim high_val as integer, low_val as integer

rank_val = 0

redim digits(9)

redim rank(9)

for t = 0 to 9

digits(t)=0 '<----- your digit "counts" will go here, later

rank(t) = 0 '<---- let's you rank numbers that have the same 'count'

next t

...(cycle through your numbers using) ...

digits(currentnum) = digits(currentnum) (plus) 1

....' after your 'counts' are set '.....

high_val = 0

low_val =100

for t= 0 to 9

if digits(t) > high_val then high_val = digits(t)

if digits(t) < low_val then low_val = digits(t)

next t

for passes = high_val to low_val step -1

for t = 0 to 9

if digits(t) = passes then

rank_val = rank_val (plus) 1

rank(t) = rank_val

end if

next t

next passes

'after this point, you can place the number by calling the

digit or the rank and set it in whatever cell you want'

(plus) is used where the symbol wouldn't show up

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

New Member
macon
United States
Member #12671
March 20, 2005
2 Posts
Offline
 Posted: April 9, 2005, 8:46 am - IP Logged

Thank you for your help its been some time since i messed with any vb im having some trouble with it

hopefully you put me in the right direction

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: April 11, 2005, 10:26 pm - IP Logged

 Game Date Results Cash 3 5/1/2004 8, 7, 7 Cash 3 5/2/2004 6, 5, 0 Cash 3 5/3/2004 7, 4, 2 Cash 3 5/4/2004 2, 4, 3 Cash 3 5/5/2004 9, 4, 4 Cash 3 5/6/2004 2, 7, 3 Cash 3 5/7/2004 9, 6, 4 Cash 3 5/8/2004 8, 4, 1 Cash 3 5/9/2004 4, 4, 5 Cash 3 5/10/2004 3, 5, 9

I am trying to import previous lottery results into an excel spreadsheet.

The above is how it looks--Just wondering if there is any way that I can get rid of the , so that I can just cut and paste results into the specific area that I want.

L ttaL   T

CA
United States
Member #2987
December 10, 2003
832 Posts
Offline
 Posted: April 12, 2005, 1:14 am - IP Logged

lottaloot -

If you are using this data from a text file in a simple editor like WordPad, simply use find-and-replace <CTRL-H> to replace the commas with spaces. If it's already a .csv (Comma-separated values) file, you have double commas in there - replace those double commas with a space and a comma.

The other alternative is to remove the commas using the same method after the file is imported to Excel, and the numbers will be automatically converted to values after that is done.

gl

j

Blessed Saint Leibowitz, keep 'em dreamin' down there.....

Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

=^.^=

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: April 12, 2005, 4:26 am - IP Logged

M\$ XL also gives you the option of selecting a custom character to be treated as a delimiter or converted to another character. When you do an "import" from text look for a blank box near the top, where it shows what you will import. You put your apostrophe or whatever into that box. You can tell XL to treat it as a delimiter instead of a character. HTH

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: April 12, 2005, 11:09 am - IP Logged

time treat. Wonder if you could devise a spreadsheet to use for thread pick3 reviewed post to enter past say 30 draws and apply his filters by choice. I think he has some great ideas to help solve daily numbers. What do you think? thanks

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: April 12, 2005, 12:13 pm - IP Logged

Thanks you guys

L ttaL   T

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: April 12, 2005, 7:22 pm - IP Logged

retxx,

I don't follow the pick 3 threads, so I don't know which poster you are referring to...

As far as applying filters "by choice"; if you mean "use filter A, is the numbers run "left" and use filter B, if the numbers run "right", then yes, it can be done. You would need some code to run behind the spreadsheet, though. If that wasn't your question, please rephrase it for me.

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: April 12, 2005, 9:27 pm - IP Logged

to rephrase it I mean enter the last 30 pic3 draws and use filters such as hll-lhh-sums as an example to reduce the amount of plays. hll meaning high-low-low and lhh meaning low-high-high. I will find the correct thread number so you can look at his formula. I will get back. thanks

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: April 12, 2005, 9:31 pm - IP Logged

it is on lottery systems and is old pick3 method reviewed by lantern. Quite interesting and informative.

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: April 13, 2005, 2:03 am - IP Logged

for those of you playing at home, the "system" in question is at

Steel yourselves for pointless verbosity.

Happily, I don't have to change my original answer.

You drop the numbers into a spreadsheet. You run different scenarios and output them to another/other sheets depending on which/how many scenarios you're using. Your code picks up the numbers, parses them, runs your filters, drops your results onto your output page(s). You can even branch based on intermediate results.

The good news is your code will take up fewer pages than that thread.

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: April 13, 2005, 11:13 am - IP Logged

I misunderstood you because I thought there was a spreadsheet at that thread but nothing. can you write one to conform with what lantern is doing manually? thanks

Ga
United States
Member #4378
April 17, 2004
136 Posts
Offline
 Posted: April 13, 2005, 11:23 am - IP Logged

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: April 13, 2005, 6:29 pm - IP Logged

retxx,

there are two pieces, the spreadsheet which just holds the raw data, that's more cut-and-paste than "write", and the code which does all that comparison stuff, is the part you "write". If you're interested in trying to code his system, you can use the code at the beginning of this thread as one possible starting place. You would only need to modify it slightly to hold the extra ranking and statistical data. The people who play p3 and write their own code probably have most of the other parts already in their systems somewhere. LANTERN pointed out there are variations on the filters, so you could have different results even with the same code as someone else. LANTERN has tied them together in a particular way. All of the pieces exist, you just have to put them together, or buy someone else's. I'm sure there are retail versions that do this, if you don't write your own code.

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

 Page 1 of 2