This was recently mentioned in an SLN thread. I have put together a simple spreadsheet to plot wave buoy data at the Sevenstones lightship. Using a spreadsheet to harvest the latest data in this way is a compelling prospect, however at present I can’t think of a practical application!
Open the spreadsheet and select “enable macros”. After a few seconds the graph will change automatically to reflect the current readings from the lightship.
Click on chart to download spreadsheet
Â© National Maritime Museum, London
Thanks to Rowser for his assistance with the method. This page is a helpful intoduction to web queries.