For those who haven't seen it, a redlining (ie hiking every trail) workbook for the 29th Edition of the AMC White Mountain Guide has been made available online:
White Mountains Redlining Workbook
White Mountains Redlining Workbook
White Mountain Redlining Workbook (29th Edition)
- Thread starter rocket21
- Start date
Help Support vftt.org:
ksearl
Active member
Very Cool! Thanks for sharing!
Karl
Karl
sdways01
New member
In the "Mileage To Do" column, just subtract the distance of the section you hiked. This will give you partial completion of that trail.
Oh, that's what I'm supposed to do? That's backward. It should start at zero and I should write in the mileage I hiked (which I know) not have to do math in my head in order to fill in a number in the spreadsheet.
That's okay, I can fix my own copy to function the right way around. Thanks for the explanation.
That's okay, I can fix my own copy to function the right way around. Thanks for the explanation.
It's structured the same way Tony Federer's 28th Edition spreadsheet was. It's faster to enter "0" to denote a finished trail rather than look up the total trail distance and enter that to denote finished.
Except the total distance is in the column immediately to the left.
To each their own, my copy is now the way I like it. Everything works on the Mac imported into Numbers except for the conditional formatting to make the little %-finished bar graphs. I haven't tried it on the iOS version of Numbers yet.
una_dogger
Well-known member
I'm always impressed when someone creates something like this and then shares it. The fact that you kept the same functionality as the previous editions share-sheet might be helpful to users familiar with it.
TrishandAlex
New member
What an excellent resource. Clear, easy to use, and fun to look through. Many thanks to the creator for sharing this.
una_dogger
Well-known member
Raymond
Well-known member
- Joined
- Sep 4, 2003
- Messages
- 1,536
- Reaction score
- 59
It seems to me that it would be handiest if it listed every trail segment, like this:
Crawford Path
XXXXHighland Center to Route 302
XXXXRoute 302 to Crawford Connector
XXXXCrawford Connector to Gibbs Falls spur
XXXXGibbs Falls spur to Mizpah Cut-off
and so forth, and you just checked off each segment. That way you don’t have to figure out which parts you have and haven’t done yet.
Crawford Path
XXXXHighland Center to Route 302
XXXXRoute 302 to Crawford Connector
XXXXCrawford Connector to Gibbs Falls spur
XXXXGibbs Falls spur to Mizpah Cut-off
and so forth, and you just checked off each segment. That way you don’t have to figure out which parts you have and haven’t done yet.
sdways01
New member
While it would be easy to mark off segments in the workbook, it would also make for MUCH longer pages within it also making it harder to find a section in the list. I've had to look through the list twice sometimes as it is to find a particular trail. It would also include some very short sections where intersections are close to each other. Would these get labeled as 0.1 or 0.0 miles?
Before I downloaded the workbook from here, I had actually just purchased a second map (no more than $10) and started marking off trails with an orange sharpie. This is great for a quick visual of what you have and have not done. It's also great for thinking up loops to hit trails you haven't gotten to yet as well. It does pose the same problem as above with the intersections that are very close to each other to make sure you don't color over the wrong spot of trail.
Before I downloaded the workbook from here, I had actually just purchased a second map (no more than $10) and started marking off trails with an orange sharpie. This is great for a quick visual of what you have and have not done. It's also great for thinking up loops to hit trails you haven't gotten to yet as well. It does pose the same problem as above with the intersections that are very close to each other to make sure you don't color over the wrong spot of trail.
Tis true. It's also worth noting that the AMC guide didn't give segment mileage for every single junction. I've done some of the segment work though. PM your email and I'll send you what I have.
trailbagger
New member
Actually, I created an evolved version of Tony Federer's spreadsheet, for the WMG 29th edition, that allows hikes to be recorded in this format. And, because hikes are logged to include the date, the spreadsheet also tracks progress towards the Grid, and the NH4ks in Winter, Spring, Summer and Fall. I even put it on the web, at https://sites.google.com/site/northeastredlines/home. However, I haven't found the energy to figure out how to "promote" the site so that it shows up in searches, and so the spreadsheet lives on in anonymity. If anyone is interested in trying it out, it's there to download. Any feedback would be welcome.
Raymond
Well-known member
- Joined
- Sep 4, 2003
- Messages
- 1,536
- Reaction score
- 59
Read-only in Excel 2003, it looks like.
trailbagger
New member
Yeah, I think you need Excel 2007 or later. I developed it using Excel 2010, and don't have any easy way to test it on older versions.
Similar threads
