Last summer we had crates of bottled water on the station for emergency
use. Unfortunately when we thought we might need it a week or so ago, it
was all past its Sell-By date.

You could have just done a "Coca-Cola" emptied all the bottles and
filled them with tap water from Kent.