I hope someone can help... we're holding a motorcycle 'poker run' to benefit a friend with breast cancer. How it works: each rider stops at 5 different stops - drawing a card at each stop... we'd like to be able to have a spreadsheet which shows where each rider stands after each stop... so the spreadsheet will have to be able to calculate the value of poker hands (and partial poker hands as they pick cards) (simple draw poker)... I know that I can accomplish this in Excel but am hoping that someone will be able to provide me with, at least, tips & tricks on how to make it easier to create.

Thank you!!