Should I replace blank FPL data with zero in my sheet?
First establish what the blank means. Zero, unplayed, unavailable and not applicable are different states.
FFTQL data states, timestamps and source policyCheck before calculating
If three of four intended rounds have scores and the fourth is temporarily missing, filling it with zero changes the mean. Reopen the source to establish whether the team actually scored zero or the record is incomplete. Keep the missing state and its reason until evidence supplies the correct value.
This distinction also helps later updates. A pending record can be filled when the round settles, while an inapplicable record may require a different denominator throughout.
Practical checks
- Verify the source state behind each blank.
- Use zero only for a confirmed zero-valued record.
Context and sources
All numerical examples are hypothetical. The formulas explain a method, and the linked product pages explain data context. For real analysis, retain the source, units, season, gameweek range and retrieval time so another reader can reproduce it.