excel users

Reply #4

plnwebguy — Thu, 04 Mar 2004 05:20:38 GMT

Paintbrush,Converting to 3 and 4 digits wouldn't be a problem, but I think filtering may be kind of tough. It would take playing around with some of the built-in functions to get it to do what you want - I would say it would even require functions nested inside of functions. Plus you would have to put it in a macro or write a vba to make it repeat the filter over several draws. Instead of Excel, an option would be to use a database program like Access (or Filemaker if you use a Mac). Access i... [ More ]

Reply #3

paintbrush — Thu, 04 Mar 2004 02:43:58 GMT

Thanks winsum and plnwebguy I have all of versabet products,my problemis in the filtering I want to convert past historydraws into 3 digit and 4 digit games on the sameline.and open up the file and start deletingcombinations for everydraw there is 10 combosof 3 digit numbers and for every history draw thatsis 6300 combinations and a 20 number wheel is8500+ combinations and iam sure out of the 6300you would have a lot of over laping but i wouldlike to see how many combo's are left do you see were... [ More ]

Reply #2

winsumloosesum — Wed, 03 Mar 2004 23:16:43 GMT

I think Excel is limited in wheeling but it can be accomplished if you have the time.There are plenty of free wheeling software and pay software. Chaeck out versabet.com for Intelli-Pick wheeling software. I believe they have a demo to try.wsls

Reply #1

plnwebguy — Wed, 03 Mar 2004 21:25:55 GMT

Paintbrush,You should be able to wheel and do some filtering. For the wheeling you'd need to understand how to do what are called functions and formulas. I'm not sure how much you can do with filtering based on what you want to do though. You can filter manually using the filter command under Data. You may be able to do what you want to do more efficiently using what are called macros and/or vba - so I would check those out with regards to your classes. If you do a search on Google on some... [ More ]

excel users

paintbrush — Wed, 03 Mar 2004 02:28:49 GMT

had a question for you excel users heard its a powerfulprogram and before I look for a class .Wanted to know iffirst can you wheel with it?second can after saving file open up to filter with customizedpast history files .Which would be broke down as such (this is forpick 5 games)01/02/04 5 12 23 34 20 - 5 12 23. 5 12 34 (each draw would be broken down into 3 digit and 4 digit games on each line ) than you would filter back as many days back as you wish ask... [ More ]