Since my trips are always a group affair, I prepare a similar spreadsheet, using pages 1 and 2. Pulling data off of the topos, I show distance, elevation change and estimate hiking time for each segment. I also track the same data for the entire trip After selecting a trip from the year's choices, at least two other members of the group look at campsite choices. For example, couple of years ago I wanted to camp at Wanda Lake and take our layover day to visit the Ionian Basin. One of the group was adamant about not camping there, calling it desolate. We ended up changing the itinerary to avoid camping at Wanda. In any case, we combine their input to get a final itinerary. This way, all of the parties that desire can have input into the final trip. The advantage for me is that hiking times are spelled out so there are no surprises about long days. Checking the trip spreadsheet with GPS data post trip shows that I consistently estimate hiking time about 5 - 10% high. I Like the approach, since it satisfies my engineer side. We have used this approach for many years, and it works for us.
Two roads diverged in a wood, and I — I took the one less traveled by,
And that has made all the difference. Robert Frost