Excel 2003 help? Keno number organization.

Reply #20

eddessaknight — Thu, 24 Dec 2009 01:53:10 GMT

Greetings Steve

Many thanks for the valuable 'how to' input link, now to only download apply...sorry but as an old vet I am seriously limited in computer or programing skills

The Fibo is named after an Italian mathamatician ,Leoardo of Pisa, who was known as Fibonacci

Fibonacci Sequence numbers and the golden ratio is found in nature; seeds, flowers, petals, pine cones, fruit and vegetables. It is a very simple concept, in short the Fibonacci sequence is a series of numbers beginning wi... [ More ]

Reply #19

CARBOB — Wed, 23 Dec 2009 14:36:24 GMT

Fantastic Steve, thank you! Merry Christmas to you and your daughter

Reply #18

winsumloosesum — Wed, 23 Dec 2009 05:18:40 GMT

Below is a download link on how to import the Keno draws into excel.

I'm using excel 2002 so if you have a newer version the instructions may not work.

In the zip file there are 3 files. There is an excel file with over 1000 past keno draws. There is a Word document and a Pdf with Instructions on how to import the Keno draws.

Let me know if you have any questions.

http://www.box.net/shared/hy5pnyy1bg

Reply #17

winsumloosesum — Wed, 23 Dec 2009 01:26:27 GMT

Eddessa,

Could you explain Fibo progression and how you use it to pick your keno numbeers?

Thanks

Reply #16

eddessaknight — Tue, 22 Dec 2009 22:48:59 GMT

Bye the Bye CORAB, a strategy I have succesfully (if opainfully) applied in the past is playing is to play numbers that haven't shown in the last 10 games and chase with Fibonachi progression - my experience is that those number will hit 99% before or on the 21st game. I said painfully because I dislike power progressions and sometimes while redlining on a prog it feels like a catylist for a heart attack

Thanks again for your interest response.

EddessaKnight

Reply #15

CARBOB — Mon, 21 Dec 2009 23:42:44 GMT

This could be fun to play around with. This is number of times each number was drawn in the 20 games.

32 7

64 7

11 6

19 6

28 6

36 6

44 6

59 6

74 6

78 6

80 6

01 5

05 5

08 5

09 5

16 5

18 5

21 5

22 5

23 5

25 5

30 5

31 5

45 5

47 5

51 5

52 5

63 5

77 5

02 4

10 4

14 4

24 4

34 4

43 4

48 4

55 4

58 4

60 4

Reply #14

CARBOB — Mon, 21 Dec 2009 23:09:41 GMT

It can be done, but it's a lot of cutting and pasting. Here's an image of the few I did. I would like to see a printed document.

Reply #13

eddessaknight — Mon, 21 Dec 2009 20:44:24 GMT

First a short but sincere note of thanks for speedy and courteous response CAROB.

The past performance data is on the Station Casinos live keno display @

http://ww2.kenousa.com/Sunset_Station/Main/index.html?

Clicking on Historical records will give access to approx 1000 games.

The 24 hour central game information feed eminates from South Station , a local Vegas casino that is part of a multi state newtwok.

In the past I have been able to acquire a useful extensive printed (text f... [ More ]

Reply #12

CARBOB — Mon, 21 Dec 2009 12:27:57 GMT

Is this data published on a website, or can it be put in text form? Is this data for a particular state

Reply #11

eddessaknight — Mon, 21 Dec 2009 06:01:09 GMT

Hello CARBOB et al-

Seasons Greeting Everyone,

Speaking of pairs-

Most interested in uncovering cold pairs that haven't shown in approx 150 games in 20/80 KENO.

Have a live game on line archive data source (analog) accessible of about 1000 past games but, sorry to say I am short on computer culture and or programing skills.

Thanks in advance for the patience; all constructive feedback for those inclined would be sincerley appreciated +

Happy Merry Holidays All ( good luck)

E... [ More ]

Reply #10

winsumloosesum — Wed, 16 Dec 2009 02:43:48 GMT

Updated the Michigan Keno Excel file.

Here is the new download link:

http://www.box.net/shared/uko66dy6oh

Updated drawings to include Tuesday December 15, 2009

Added skip chart for all 80 numbers

Added sort tables for total hits and current skips.

1. To add a new drawing go to the Tab at the bottom labeled Toolbars . Click the Toolbar labeled Clcik To Add New Drawing

This will add a new line to the tab labeled MIKeno (Michigan Keno).

The date will automatically be update... [ More ]

Reply #9

winsumloosesum — Tue, 15 Dec 2009 00:59:02 GMT

This is an Excel file with Michigan Keno draws.

http://www.box.net/shared/5npqq5yiuc

Skips, Hits, and drawing history.

Reply #8

Classic47 — Mon, 14 Dec 2009 22:22:53 GMT

All great help guys. CARBOB nailed the problem I've been having. Though I have found some alternatives for my chart which work fine for now, this is still very helpful. And yes, there will probably lots of trial and error, but I think I can get it.

Reply #7

CARBOB — Mon, 14 Dec 2009 21:26:29 GMT

I don't recall if Excel 03 has text to columns. If it does, when you imported the data, everything was in a single cell, so you want to do Text to columns. see image

Reply #6

hotshot4 — Mon, 14 Dec 2009 20:48:12 GMT

Using Excel 2007 so it may be different in 2003, once you have copied the information to a Excel spreedsheet, highlight the column you want

to seperate and click on Data, Data to Text, you can get a video of how this works, or just keep trying until you get it right, if the number are separated by a comman (,) or dash (-) change the information and see. If you work it right, it will put each number in a cell by itself.

Hope this helps

Reply #5

Delta Draw — Sun, 13 Dec 2009 09:21:50 GMT

Good pointers! I am also new to spreadsheets/excel and this is some good insight. Thanks.

DD

Reply #4

LottoChica23 — Sun, 13 Dec 2009 05:09:36 GMT

Don't despair, there is a way to work with the cut and pasted data.

Just cut and paste the data in a neat block if possible into a word document. Save the document as a txt file, then follow the instructions that I posted in this thread -- https://www.lotterypost.com/thread/204450/1473017?q=lottochica23 tab=us rp=search

When you use the Excel Import Wizard you can use different characters as delimiters to separate the data into columns when imported. in your case you would most likely be u... [ More ]

Reply #3

Classic47 — Sun, 13 Dec 2009 03:51:46 GMT

I guess it's just a matter of trying to put each number in a different cell. Since the spaces were there when I c p'd the numbers, I guess excel isn't very c p friendly. Perhaps there's a number sorter program that can sort the numbers? I did try one, but for some reason, it didn't record any 1s. Maybe I should just do daily 4 since there's not as much numbers and it would be easier to record by hand?

I do appreciate the advice, I just don't know if I have the patience to do much by hand... [ More ]

Reply #2

LottoChica23 — Sun, 13 Dec 2009 03:00:43 GMT

Get rid of the spaces...

If the spaces are within the cell, Excel does not see the contents of the cell as a number but rather as a label. Each number must be in its own individual cell with no spaces.

If there are blank cells within a column, some functions will not work. In either case, the spaces are what may be causing your problem.

HTH

Reply #1

phileight — Sun, 13 Dec 2009 02:57:25 GMT

not sure if that is what you want.

if you had each number in a different cell you could use the count if function to count the number of occurances of each number.

counting the numbers when combined can be done but not easy

Excel 2003 help? Keno number organization.

Classic47 — Sat, 12 Dec 2009 23:10:48 GMT

I copied and pasted some Keno numbers from the MI lottery website. I don't want a graph or anything fancy like that, I just want the numbers organized so I can easily see which numbers show up the most. The problem is that when I use any of the list functions, it only organizes them by the first collumn down. In other words, it treats each set of numbers as an individual number (there are spaces between the numbers just so ya know).

I think it has something to with each set of numbers taking... [ More ]