Game room, token and ticket tracking spreadsheet

I need a simple spreadsheet to track a small game room. Each game has a meter for tokens taken in and tickets paid out. We try to read these meters once a week and would like to have a handy spreadsheet that makes it easy to record the readings, and will also provide some simple calculations, like the ratio of tickets paid to tokens earned each day, also the earnings of each game weekly or daily. I have some data collected already and I have two spreadsheets that we have attempted to design. The right person could make what we have much more effective and easy to use. It's important that it is designed in such a way, that data entry is simple and calculations are automatic.