TableRun Blog

Spreadsheet Board Game Template: Trace a Turn Through Formulas

Follow a turn from the input on Log to the positions, balances and ownership shown elsewhere in the workbook.

Monopoly template cover

Read the sample turn in Log

Explore the template

Preparing template preview…

Use this template

The existing TableRun workbook has separate Board, Log, Properties and Setup sheets. In Log, follow a filled row from the player and dice through the action and ending position. Compare the before-and-after cash columns to see where the workbook records the financial effect of that turn.

Compare the log with the board and property list

Board gives a snapshot of player positions and balances. Properties adds the ownership view. If the sample turn records a purchase, look for the property in that list and compare it with the player’s position shown on the board. This is a practical way to see how a spreadsheet separates events from summaries.

Use a personal copy for experiments

Open a copy and use an input the template labels for the next turn. Observe which values change across the three sheets. Keep calculated cells intact while comparing outcomes so you can trace changes back to the action field.

Follow one sample turn from input to result

In Log, choose a completed row and read it in three passes. First note the player, dice and action. Then compare From, To and Square to see what that movement landed on. Finally read What happened and the two cash columns. If the result describes a purchase, the difference in cash provides a useful cross-check against the recorded price on the same turn.

Next, compare the workbook's current Board and Properties with the most recent completed turns. Earlier rows are a history. If a current total differs from an older event, trace later turns affecting that player before assuming the formulas are broken. This distinction between a row of evidence and a current summary also applies to transactions and inventory in ordinary spreadsheets.

Troubleshoot in a copy before changing formulas

Use a fresh copy when you want to compare an input or undo an experiment. Change a single labeled input in the next available row, then see which calculated fields respond. If a later summary looks surprising, check the current turn, the ending position and the cash change in that order. Keep a note of the starting values so you can reproduce what you observed.

Read about TableRun