I'll test if this antenna methods works as an alternative. I'd feel more comfortable sharing with others if mains voltages are eliminated entirely.
Disagree on the surprise that the setup worked, though. Mains is only regulated to a few % in frequency from what I've read. But you can see 0.05 Hz deviations (or 1%aka 1000 ppm). Even a junky crystal at ~100ppm is an order of magnitude better. A 10 ppm oscillator isn't hard to find, so the computer is likely somewhere in the middle. The math all checks out.
There is open distributed monitoring for all kinds of signals, like seismometer networks, weather, ads-b... Is there anything like this for the power network? Like a reference design or an esp32-shield?
How would it look like if we were serious?
I would make it three phase, with direct coupling to also see the exact voltage changing over the day. Sometimes we have issues with local voltage rising too high and PV inverters shutting off. I'd like to see and log this. An audio ADC should be good, but needs three channels.
For distributed sensing and logging, you would need a reasonable accurate time synchronization. Raw ntp over internet might not be good enough, at least not for localizing fault propagation issues over the whole continent. Better stick a 5€ GPS module on there.
Anybody seriously working on this..?
I remember reading an article about this being used in some forensic capacity to determine the date/time a video was taken by comparing the frequency noise.