[Tool] Isle Royale Trip Planner Spreadsheet

Questions about trails and campsites on the island.

Moderator: MikeT

Tedd
NewbieCake
Posts: 3
Joined: Thu Jul 28, 2016 10:35 am

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Tedd »

I found what might be a bug. When I enter an east-to-west plan, starting at Rock_Harbor_Dock, I can go:
Rock_Harbor_Dock
Rock_Harbor_Campground
Suzys_Cave
Tobin_Harbor_Suzys_Cave_Junction
Tobin_Harbor_Mount_Franklin_Junction

But coming from the other direction I can't get farther than Suzys_Cave:

...
Tobin_Harbor_Mount_Franklin_Junction
Tobin_Harbor_Suzys_Cave_Junction
Suzys_Cave

and at that point my options are Three_Mile_Campground or back to Tobin_Harbor_Suzys_Cave_Junction, not on to Rock_Harbor_Campground as the east-to-west path suggests.

Now I'm pretty sure I'll be able to find my way from Suzys_Cave to Rock_Harbor_Dock without a piece of paper, but I would like to get it punched in correctly. Am I just doing something wrong?
User avatar
Ingo
Forum Moderator
Posts: 1944
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 257 times
Been thanked: 158 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

I'm traveling and can't check it now, but will when I get home. Probably Tues.
22: BI-PC-BI-RH, 21: RH-ML-DF-MB-DF, 18: MC-PC-BI-DB-RH-DF, 17: WI-IM-SB-FL-WC, 16: RH-CI-TI-RH, 14: BI-ML-CI-CH-MB, 13: RH-PI, 12: MC-CB-HL-TH, 11: WC-HC-WC, 09: MC-BI-DN-RH, 05: MI-CI-MB-DF-RH-TM-RH, 02: MC-LR-WL-CH, 01: BI-DB-RH, 79: worked RH
User avatar
Ingo
Forum Moderator
Posts: 1944
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 257 times
Been thanked: 158 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

Tedd wrote:I found what might be a bug. ... coming from the other direction I can't get farther than Suzys_Cave ... at that point my options are Three_Mile_Campground or back to Tobin_Harbor_Suzys_Cave_Junction, not on to Rock_Harbor_Campground as the east-to-west path suggests.
Tedd, "Yes" you found a bug! Should be fixed now, but you will need to start over from the public spreadsheet. Thanks for letting me know!
John I.
22: BI-PC-BI-RH, 21: RH-ML-DF-MB-DF, 18: MC-PC-BI-DB-RH-DF, 17: WI-IM-SB-FL-WC, 16: RH-CI-TI-RH, 14: BI-ML-CI-CH-MB, 13: RH-PI, 12: MC-CB-HL-TH, 11: WC-HC-WC, 09: MC-BI-DN-RH, 05: MI-CI-MB-DF-RH-TM-RH, 02: MC-LR-WL-CH, 01: BI-DB-RH, 79: worked RH
Tedd
NewbieCake
Posts: 3
Joined: Thu Jul 28, 2016 10:35 am

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Tedd »

Thanks for looking, and making the fix. And once again for the great tool!
User avatar
thesneakymonkey
May actually live on IR
Posts: 357
Joined: Sat Jan 14, 2017 5:43 pm
Isle Royale Visits: 3
Has thanked: 23 times
Been thanked: 36 times
Contact:

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by thesneakymonkey »

This is great! Thank you!!!
Donk_67
Trailblazer
Posts: 109
Joined: Sat Dec 21, 2013 1:00 pm
Isle Royale Visits: 2
Location: Petoskey MI

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Donk_67 »

Whoa! since I started using Google Drive, I decided to play with this and find it to be very useful to compare different scenarios...now to convince my hiking partner that by adding a few more miles and a few more hours of hiking we can knock out the Feldtman loop along with our Minong/Greenestone route. Thank you Ingo for developing this.
User avatar
Ingo
Forum Moderator
Posts: 1944
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 257 times
Been thanked: 158 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

Updated link that forces you to make a copy first (which is required to use). Again, note that you need a Google account to use, since it resides on Google Drive/Sheets.
https://docs.google.com/spreadsheets/d/ ... aUsp0/copy
22: BI-PC-BI-RH, 21: RH-ML-DF-MB-DF, 18: MC-PC-BI-DB-RH-DF, 17: WI-IM-SB-FL-WC, 16: RH-CI-TI-RH, 14: BI-ML-CI-CH-MB, 13: RH-PI, 12: MC-CB-HL-TH, 11: WC-HC-WC, 09: MC-BI-DN-RH, 05: MI-CI-MB-DF-RH-TM-RH, 02: MC-LR-WL-CH, 01: BI-DB-RH, 79: worked RH
paulbates
LNT Expert
Posts: 76
Joined: Mon Jun 12, 2017 8:57 pm
Isle Royale Visits: 3
Location: Dearborn, MI
Been thanked: 1 time

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by paulbates »

Thanks Ingo, that will help. Merry Christmas to you!

Paul
User avatar
natasha.tucker
NewbieCake
Posts: 1
Joined: Thu Oct 26, 2017 5:01 pm

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by natasha.tucker »

I am new to using this type of spreadsheet. I am doing something wrong. I want to go 8/18-8/22. I am not following any trail but I want to see if landing in rock harbor going to camp 13 hiking to 18 the next day, 6 or 5 the day after that and hiking back to he harbor on the 22 is doable. But I can't plug in any of these sites. Can anyone help me on this?
User avatar
Ingo
Forum Moderator
Posts: 1944
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 257 times
Been thanked: 158 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

natasha.tucker wrote: Sat Apr 14, 2018 8:29 am I am new to using this type of spreadsheet. I am doing something wrong. I want to go 8/18-8/22. I am not following any trail but I want to see if landing in rock harbor going to camp 13 hiking to 18 the next day, 6 or 5 the day after that and hiking back to he harbor on the 22 is doable. But I can't plug in any of these sites. Can anyone help me on this?
Natasha, it's set up for trail segments so you need to add each part as you go. Click the little down arrow in your last place in the Waypoint column to see where you can go next. If you're not familiar with the trails, you most likely will need to have a map nearby to reference. Note that you have to make a copy for yourself before you start. It's not ideal--just a little project I originally did for my own use.
22: BI-PC-BI-RH, 21: RH-ML-DF-MB-DF, 18: MC-PC-BI-DB-RH-DF, 17: WI-IM-SB-FL-WC, 16: RH-CI-TI-RH, 14: BI-ML-CI-CH-MB, 13: RH-PI, 12: MC-CB-HL-TH, 11: WC-HC-WC, 09: MC-BI-DN-RH, 05: MI-CI-MB-DF-RH-TM-RH, 02: MC-LR-WL-CH, 01: BI-DB-RH, 79: worked RH
Lane
NewbieCake
Posts: 25
Joined: Sun Jun 03, 2018 11:45 am

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Lane »

haha, Without a usable map one has to guess on every data point since my destination from point A to point B is not an option. And since I didn't 'double' entry for "camp" it doesn't show that. So with no 'camp' days, it took 25 entries to get from Rock Harbor to 3 mile to Lake Richie to W Chickenbone to Lane Cove and back to Rock Harbor. And I still am not sure if the waypoints are correct. But my mileage 'guess' from the chart shows only a couple tenths difference in mileage. There are no serviceable maps on the internet it seems. After 'figuring' out how to use the spreadsheet - still guessing tho - it seems to be pretty accurate. All of the "junctions/waypoints" are purely guesses but without a map... are there any maps that actually show such detail on trails/junctions etc.? Thanks for putting this together.
User avatar
dcclark
May actually live on IR
Posts: 385
Joined: Fri Aug 11, 2017 1:39 pm
Isle Royale Visits: 4
Location: Grand Rapids, MI
Has thanked: 156 times
Been thanked: 133 times
Contact:

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by dcclark »

Lane wrote: Fri Jun 08, 2018 5:28 am All of the "junctions/waypoints" are purely guesses but without a map... are there any maps that actually show such detail on trails/junctions etc.? Thanks for putting this together.
I agree, it's surprisingly hard to find a good, well-labeled IR map online. I use Acme Mapper in Topo mode. (That link takes you to a view centered on Daisy Farm.) This shows the trails, labeled, and campgrounds -- not 100% up to date, but not bad either.

It's worth ordering the Trails Illustrated (National Geographic) map to have in front of you when planning (and then take it with you on the island).
Lane
NewbieCake
Posts: 25
Joined: Sun Jun 03, 2018 11:45 am

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Lane »

thanks
User avatar
Ingo
Forum Moderator
Posts: 1944
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 257 times
Been thanked: 158 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

The waypoint junctions use the trail names on the NG Trails Illustrated map. FWIW, I too get confused sometimes, but usually have a map handy (on my office wall, or next to the recliner at home). For campsite to campsite distances, you can also use this chart https://www.nps.gov/isro/planyourvisit/ ... vidual.pdf.
22: BI-PC-BI-RH, 21: RH-ML-DF-MB-DF, 18: MC-PC-BI-DB-RH-DF, 17: WI-IM-SB-FL-WC, 16: RH-CI-TI-RH, 14: BI-ML-CI-CH-MB, 13: RH-PI, 12: MC-CB-HL-TH, 11: WC-HC-WC, 09: MC-BI-DN-RH, 05: MI-CI-MB-DF-RH-TM-RH, 02: MC-LR-WL-CH, 01: BI-DB-RH, 79: worked RH
User avatar
Midwest Ed
IR Expert
Posts: 1355
Joined: Sat Jul 03, 2010 1:25 am
Isle Royale Visits: 8
Location: Quad Cities, IL
Has thanked: 42 times
Been thanked: 82 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Midwest Ed »

dcclark wrote: Fri Jun 08, 2018 6:44 amI use Acme Mapper in Topo mode.
Thanks for the online mapper. I used to use one but it's not as good as Acme.
I notice the topo map loaded is showing 2 Feldtman trails. The Eastern one was abandoned quite some time ago. I'm sure most of it is under water now as that area had many boardwalks.
8 trips, 1975 x 2, 1976 x 2, 1978, 1985, 2000, 2013
Post Reply