excel help

Reply #17

winsumloosesum — Sat, 16 Apr 2005 02:18:24 GMT

0= 15 01= 12 2= 8 7 13= 94= 8 6 3 45= 86= 11 5 2 8 97= 138= 59= 4Shanemc1How would you wheel you Pyriamid??winsum

Reply #16

time*treat — Fri, 15 Apr 2005 22:28:56 GMT

*color printouts*In the vb editor, onscreen, you can have keywords one color, and comments another color and so on. I'm wondering if any of you know how to get the printout of the 'code' in this multi-color format.

Reply #15

winsumloosesum — Thu, 14 Apr 2005 02:53:03 GMT

GameDateResultsCash 35/1/20048, 7, 7Cash 35/2/20046, 5, 0Cash 35/3/20047, 4, 2Cash 35/4/20042, 4, 3Cash 35/5/20049, 4, 4Cash 35/6/20042, 7, 3Cash 35/7/20049, 6, 4Cash 35/8/20048, 4, 1Cash 35/9/20044, 4, 5Cash 35/10/20043, 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.If your 3 digit numbers are in on... [ More ]

Reply #14

time*treat — Wed, 13 Apr 2005 22:29:13 GMT

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

Reply #13

crash — Wed, 13 Apr 2005 15:23:10 GMT

Reply #12

retxx — Wed, 13 Apr 2005 15:13:32 GMT

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

Reply #11

time*treat — Wed, 13 Apr 2005 06:03:28 GMT

for those of you playing at home, the system in question is at https://www.lotterypost.com/threads110385p1.htmSteel 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... [ More ]

Reply #10

retxx — Wed, 13 Apr 2005 01:31:27 GMT

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

Reply #9

retxx — Wed, 13 Apr 2005 01:27:51 GMT

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

Reply #8

time*treat — Tue, 12 Apr 2005 23:22:01 GMT

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.

Reply #7

lottaloot — Tue, 12 Apr 2005 16:13:08 GMT

Thanks you guys

Reply #6

retxx — Tue, 12 Apr 2005 15:09:32 GMT

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

Reply #5

time*treat — Tue, 12 Apr 2005 08:26:50 GMT

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

Reply #4

johnph77 — Tue, 12 Apr 2005 05:14:43 GMT

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

Reply #3

lottaloot — Tue, 12 Apr 2005 02:26:19 GMT

Reply #2

shanemc1 — Sat, 09 Apr 2005 12:46:13 GMT

Thank you for your help its been some time since i messed with any vb im having some trouble with ithopefully you put me in the right direction

Reply #1

time*treat — Sat, 09 Apr 2005 06:19:15 GMT

dim digits() as integer, rank() as integerdim t as integer, rank_val as integer, passes as integer,currentnum as integerdim high_val as integer, low_val as integerrank_val = 0redim 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 = 0l... [ More ]

excel help

shanemc1 — Sat, 09 Apr 2005 03:16:29 GMT

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 right0= 15 01= 12 2= 8 7 1 3= 94= 8 6 3 45= 86= 11