In this spreadsheet score keeping for the card game ‘Bonken’ has been implemented. The flow is as follows.
First the names of the four players are entered
Then at his turn one of the players select his favored game, given the hand of cards he has.
The other players are given the opportunity to double all other players.
The player who selected the game, is then given the opportunity to redouble (only) those that doubled him.
At the end of each game, the number of tricks are counted, and entered into the spreadsheet.
Given the (re)doubling situation and the value of each trick, the score is then calculated and added to the overview table.
That’s basically it ♠ ♥ ♣ ♦ ♠ ♥ ♣ ♦ ♠ ♥ ♣ ♦ ♠ ♥ ♣ ♦ ♠ ♥ ♣ ♦