SYNTHETIC SAMPLE · invented values, not a customer file
This page explains the review questions for a bowling score workbook. It is not an official bowling ruling, and it does not promise that any customer workbook can be repaired.
| Date | Score | Counted? |
|---|---|---|
| Oct 1 | 0 | Yes — this is a recorded score. |
| Oct 1 | 160 | Yes |
| Oct 2 | 200 | Yes |
| Oct 2 | 180 | Yes |
| Oct 2 | Blank | No — no score has been recorded. |
Answer for this synthetic example: a recorded zero remains in the calculation; an empty score cell is not a game. The valid-game average is 135: (0 + 160 + 200 + 180) ÷ 4. If the blank were treated as zero, it would be 108 instead. The correct rule for a real workbook must be agreed from its records; this is not a universal league ruling.
For numeric cells, Microsoft documents that AVERAGE ignores empty cells and includes zero values; Google documents the AVERAGE function. Confirm the actual workbook's values and formula before changing it: Microsoft AVERAGE · Google Sheets AVERAGE.
If numeric scores begin in B2, a common running-average pattern is =AVERAGE($B$2:B2). The dollar signs keep the first score cell fixed; as the formula is copied down, the final reference moves to the current row: B2:B3, then B2:B4. The exact column, first score row, and blank-handling rule must match the workbook; mixed text labels or different score columns need a different review.
Not if the goal is an average per game. Suppose one session has 2 games averaging 200 and another has 6 games averaging 150:
Both numbers can answer a different question: per-game performance gives every game equal weight, while per-session reporting gives every session equal weight. This page does not choose an official rule; the workbook needs an agreed definition.
The pilot's job is to repair one agreed formula or summary problem after reviewing the real file. It does not determine league rules or infer missing scores.
Download the existing synthetic workbook (.xlsx) · Download the synthetic CSV · Back to the free waitlist for the proposed $29 pilot