A quick update on yesterday's post - the Yamaha Virago passed its MoT. That's a 100% pass record over 26 years.
On to today's observation.
I made a small mistake in my solar power spreadsheet the other day, which briefly suggested that my fairly modest domestic solar installation had generated enough electricity to make Gloucestershire glow gently in the dark.
This was not, strictly speaking, true. My roof had not become a small nuclear fusion facility. The National Grid had not rung up to ask if I could take the edge off peak demand. I had merely entered something catastrophically stupid into Excel, which is not really physics, but does have a tendency to create strange effects in the observable universe.
The interesting bit was not the mistake itself. I can make mistakes perfectly well without troubling the Nobel committee. The interesting bit was that the wrong figure fed a chart on another worksheet.
So the question wafted through my mind: did the chart change the moment I entered the wrong figure, or only when I opened the chart worksheet and observed it?
This is where Excel became unexpectedly philosophical, which is not something one wants from a piece of software that still thinks 1-2 is a date. The underlying data had changed. The workbook had accepted the madness. Somewhere inside the file, the future graph had already become ridiculous. But the chart itself, sitting on another worksheet, had not visibly changed, because I was not looking at it.
Then came the more awkward question: did the chart still exist?
This is not the sort of question one expects to ask about a spreadsheet. Normally the difficult questions are things like why has column G turned into dates, why is this formula referring to a workbook I deleted in 2018, and why has Excel decided that 1-2 means the second of January rather than, say, a subtraction sum, which would seem a reasonable enough guess.
But there we were, asking whether an unobserved chart actually existed.
The answer, rather annoyingly, is yes. It existed. But not as a fully alive, continuously updated visual thing sitting there nobly redrawing itself in the dark while nobody was watching.
The chart existed as an object in the workbook. Excel knew where it was, what it was linked to, and broadly how it was supposed to look. It had not lost the chart behind the sofa.
The last rendered version also existed. That was the old visual state: the chart as last painted, calm and respectable, still pretending my solar panels had behaved themselves. In that sense, the visible chart existed in the old state.
But the new visual chart did not yet exist on screen. The underlying data had changed, and the next rendering was already doomed, but Excel had not yet painted the new evidence.
So it was not, strictly speaking, a quantum superposition. The chart was not both old and new at the same time, like a cat in a box with an attitude problem. It was more prosaic than that, which is usually where Excel lives. It was an old rendered picture attached to a changed underlying reality.
Then I opened the chart worksheet.
At which point the graph suddenly leapt into its new and absurd position, like a startled cat finding out it had been assigned to PivotTable maintenance. The old visible chart vanished, the new ridiculous chart appeared, and for one brief moment my solar panels appeared to have outperformed the Severn Barrage, had anyone actually got round to building it.
Observation had not collapsed a probability curve. It had merely forced Excel to redraw the stale evidence from the changed data.
But that is enough for me.
This is not proper quantum mechanics. No serious physicist is going to win a Nobel Prize by staring at a line chart and asking whether June’s solar yield is both 243 kWh and the annual output of Dinorwig. Excel is not Copenhagen. It is more Swindon with formulae.
Still, it has the important ingredients. There is a hidden state, an observer, and a sudden change when the observer looks. There is also, regrettably, Microsoft Excel, which does rather lower the intellectual tone.
So no, the chart was not both old and new. It was old on screen, wrong underneath, and waiting to embarrass me the moment I clicked on it.
Schrodinger’s Spreadsheet: the data is wrong, the display is stale, and the observer is standing there with a cup of tea wondering why June has produced 14 gigawatt-hours.












