SYNTHETIC SAMPLE · invented values, not a customer file
This page demonstrates the intended review logic for an existing score sheet. It is not an official bowling calculation or a promise that any customer workbook can be repaired.
| Date | Score | Valid game? |
|---|---|---|
| Oct 1 | 0 | Yes — a recorded zero stays in the math |
| Oct 1 | 160 | Yes |
| Oct 2 | 200 | Yes |
| Oct 2 | 180 | Yes |
| Oct 2 | Blank | No — no recorded score |
Download the working synthetic workbook (.xlsx) — formulas cover 100 input rows; the included records are invented.
A formula that silently treats the blank as a zero would change the all-score average to 108. The point is not one universal formula: it is documenting the agreed rule and checking it against the source rows.