Planning a thru-hike on the John Muir Trail (or any other long-distance trail) can be overwhelming, it can take months of planning, and keeping track of details can be frustrating. There are so many different books, articles, and apps to reference that finding one comprehensive tool to plan your trek seems elusive, but from my own experience, I believe it all comes down to personal preference and how you choose to keep information organized.
I’ve written a couple of other blog posts related to what is involved in planning for a backpacking adventure of this magnitude, including ‘The JMT – I have to carry how much food?‘ In this particular post, I included some screenshots to a workbook I was using for selecting my on-trail menu. Since then, I’ve received multiple requests asking if I would provide a copy of my workbook to help others with their planning.
So without further ado, here it is, my comprehensive JMT Hike Planning Workbook (click to download)!
A couple of notes regarding the workbook:
- It is a COMPREHENSIVE planning tool that includes worksheets for itineraries, logistics, resupplies, costs, food selection lists, food ordering lists, food schedules, and gear lists. Remember I spoke about planning being overwhelming? Well, this workbook is the epitome of that word, I apologize if looking at it gives you a migraine. People asked, and I provided.
- It is an Excel workbook that contains formulas, vLookups, and pivot tables. If you are unfamiliar with any of these, using this workbook can be cumbersome and perhaps impossible to understand. Again, I apologize. People asked, and I provided.
- In addition to the first row in every sheet, I’ve added comments in various cells on many of the worksheets. Be sure that you have comment viewing turned on in Excel.
Here are some other posts you might find helpful:
mike paivaJuly 20, 2021
Hi, could you please email the workbook directly to me as well?
Go. Own ItJuly 20, 2021
Hello, Mike! Sure, I’m sending it over now.
JeffJune 12, 2021
Hi, I can’t seem to download the link for the planning excel sheet. Would you please email?
Go. Own ItJune 12, 2021
Hello. I apologize for the difficulty. I just emailed it to you. If you need anything else, please let me know!
Aran H.June 1, 2021
Hello. Thank you so much for all the effort you put into this great resource. I had the same issue trying to download. Could you also email the excel sheet to me please. Many thanks. AH
Go. Own ItJune 1, 2021
Hello, Aran! I apologize for the issues you’ve had downloading the file. I’m sending you the workbook via email now.
Annette HalloranApril 8, 2021
I tried downloading, but it just opens a screen and closes it. Excited to check this out I love playing in excel 🙂
Go. Own ItApril 8, 2021
Hello Annette! Sorry about that. I’m sending you the workbook via email.