Bingo

[mikajake]

Hi there i am a novice with Alpha and I have been given the task of converting an excel spreadsheet to a database. It is a spreadsheet that looks after daily bingo finances for both the hall and the organizations that host their charity at the hall.

Here is the outline. Each day, there are three sessions (Matinee, Evening, Late) During each session, one organization plays their 8 games, all different types of games. As well as each game has a different financial structure...being payouts, jackpot growth.

Also, 4 of the 8 games, has a jackpot that grows if no one wins the game in that session. The database has to keep track of the jackpot for each game.

I have supplied a pdf of the input screen as is in excel.

The way I see it, I should create on master file, from that file create table for each of the 8 games types. Then attach a jackpot table to tables that require jackpot monitoring.

The last thing, if anyone is willing to help is to get the printouts to look somewhat similar....but we can do that later.

Thanks so much in advance.

http://heavyequipmentwantedads.com/downloads/file1.pdf

[Peter.Greulich]

Re: Bingo

The way I see it, I should create on master file, from that file create table for each of the 8 games types. Then attach a jackpot table to tables that require jackpot monitoring.

Maybe. But when working with dbs, you always want to "normalize" data to the extent possible. It might be better to have one table for all the game types. As you say, you could have a child table linked to the game table to track the jackpots.

[MoGrace]

Re: Bingo

Hi David,
Just in looking briefly at your spreadsheet it seems some info is not clear because it is probably buried in the calculations. For instance how does the Super Jackpot list 4 different types of tickets sold at different prices each equaling 111 which then is totaled to be $2,664? Even the spreadsheet is not clear here. If 111 tickets are sold @ $2 then the total should show as 222 not 111. If you could get this spreadsheet to reflect a little better what exactly you are calculating it would be easier to see how it could be converted to a table.

If you could work on that, I'll bet you'd get lots of offers to help!