Now that the Food Drops have been defined, the Labels for the Buckets or Packages (depending on if they are kept in an office or left in the bush) can be created.
These Food Drop labels, originally produced for the Australian Alpine Walking Track hike, are a simple Worksheet that references the Pre & Post Walk Itinerary. Everything is manual, as I couldn't see the benefit of spending time automating anything on this sheet. Though, having said that, using cell links is automation enough, as the labels will update if the underlying data is changed.
These beautiful labels will be printed out in colour (we'll get them laser printed so that we don't run into ink running issues), then cut out and laminated.
The return label will be put inside the Food Drop with packing tape, and the Food Drop labels will be taped to either the Bucket (if it's going into the bush), or package (probably a garbage bag).
What's nice about using a spreadsheet is that any changes that the Accommodation Requests produce will be automatically updated in the Labels. Essentially I don't need to worry about the accuracy of these Labels now, if they generate without error, the data will be correct.
Next TaskAccommodation Requests
where I'll generate the requests to the various accommodation options over the hike.
The Friends of The Heysen Trail have a huge amount of resources available, which we have obviously availed ourselves of quite liberally. I'll be updating this as required…