Euan,
Great way to illustrate the concept of eroei, but a quibble. Shouldn't the line intersect the x axis at eroei of 1 (break even, all energy used to produce energy), not 0?

Welaka - you are correct. However, the scale on this chart actually runs from 1 to 50. I've checked my spread sheet and there is no easy way to modify the chart.