He started with conditional formatting—turning cells deep red if they fell outside three standard deviations of the buoy’s own historical mean. A cascade of red appeared at row 8,432. He then used a VLOOKUP to cross-reference each anomalous reading against a secondary database dump of maintenance logs. No overlaps. The buoy had not been serviced. No storms had passed over it.
Then came the anomaly.
Meanwhile, Aris himself took the . It felt almost quaint. He exported a raw, unsanitized CSV of the suspect buoy’s last 10,000 readings into a blank Excel workbook. No pivot tables. No charts at first. Just rows and rows of floating-point numbers. 6.3.3 test using spreadsheets and databases