I have never really got to grips with spreadsheets. It seemed to me that they got used - at work - all too often when a simple table would have served instead. Over the past few years I've used them more and more, and learned how to do simple things with them, on a strictly need-to-know basis.
A few months ago, however, I realised that these new found (and hard won) skills could be pressed into the service of boating - and greated the Great Chertsey Victualling Spreadsheet. Basically, I input the number of days we're going away for, and the inventory of what's already on board, and it creates a shopping list.up to the nearest whole number - rounding down is no use when I need to know how many packs to buy. Is this truly impossible in Excel?
I started with estimates of how much we use of each item daily, which can be adjusted with more experience. Meals can be planned in this way because of the cunning way we eat whilst boating - which I will spin out into another post.
2 weeks ago