[Tool] Isle Royale Trip Planner Spreadsheet
Moderator: MikeT
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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?
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?
- Ingo
- Forum Moderator
- Posts: 1979
- Joined: Wed Sep 12, 2007 2:11 pm
- Isle Royale Visits: 15
- Location: Hillsborough, NC
- Has thanked: 1 time
- Been thanked: 2 times
Re: [Tool] Isle Royale Trip Planner Spreadsheet
I'm traveling and can't check it now, but will when I get home. Probably Tues.
24: MI-MB-MI, 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-TM-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
- Ingo
- Forum Moderator
- Posts: 1979
- Joined: Wed Sep 12, 2007 2:11 pm
- Isle Royale Visits: 15
- Location: Hillsborough, NC
- Has thanked: 1 time
- Been thanked: 2 times
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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!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.
John I.
24: MI-MB-MI, 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-TM-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
Re: [Tool] Isle Royale Trip Planner Spreadsheet
Thanks for looking, and making the fix. And once again for the great tool!
- thesneakymonkey
- May actually live on IR
- Posts: 358
- Joined: Sat Jan 14, 2017 5:43 pm
- Isle Royale Visits: 3
- Contact:
Re: [Tool] Isle Royale Trip Planner Spreadsheet
This is great! Thank you!!!
Trip1East side loop: https://youtu.be/xejNOfYWpIQ
Trip2 Minong End to End : https://www.youtube.com/playlist?list=P ... 9ZJVgtfgga
Trip3 Feltdmann loop : https://youtube.com/playlist?list=PLaiL ... 5Tc4NyvOCO
Husband_Wife_OutdoorLife on Youtube https://www.youtube.com/c/HusbandWifeOutdoorLife
Trip2 Minong End to End : https://www.youtube.com/playlist?list=P ... 9ZJVgtfgga
Trip3 Feltdmann loop : https://youtube.com/playlist?list=PLaiL ... 5Tc4NyvOCO
Husband_Wife_OutdoorLife on Youtube https://www.youtube.com/c/HusbandWifeOutdoorLife
-
- 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
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.
- Ingo
- Forum Moderator
- Posts: 1979
- Joined: Wed Sep 12, 2007 2:11 pm
- Isle Royale Visits: 15
- Location: Hillsborough, NC
- Has thanked: 1 time
- Been thanked: 2 times
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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
https://docs.google.com/spreadsheets/d/ ... aUsp0/copy
24: MI-MB-MI, 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-TM-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
-
- LNT Expert
- Posts: 76
- Joined: Mon Jun 12, 2017 9:57 pm
- Isle Royale Visits: 3
- Location: Dearborn, MI
Re: [Tool] Isle Royale Trip Planner Spreadsheet
Thanks Ingo, that will help. Merry Christmas to you!
Paul
Paul
- natasha.tucker
- NewbieCake
- Posts: 1
- Joined: Thu Oct 26, 2017 6:01 pm
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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?
- Ingo
- Forum Moderator
- Posts: 1979
- Joined: Wed Sep 12, 2007 2:11 pm
- Isle Royale Visits: 15
- Location: Hillsborough, NC
- Has thanked: 1 time
- Been thanked: 2 times
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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.natasha.tucker wrote: ↑Sat Apr 14, 2018 9: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?
24: MI-MB-MI, 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-TM-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
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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.
- dcclark
- May actually live on IR
- Posts: 405
- Joined: Fri Aug 11, 2017 2:39 pm
- Isle Royale Visits: 4
- Location: Grand Rapids, MI
- Has thanked: 1 time
- Contact:
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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).
- Ingo
- Forum Moderator
- Posts: 1979
- Joined: Wed Sep 12, 2007 2:11 pm
- Isle Royale Visits: 15
- Location: Hillsborough, NC
- Has thanked: 1 time
- Been thanked: 2 times
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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.
24: MI-MB-MI, 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-TM-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
- Midwest Ed
- IR Expert
- Posts: 1363
- Joined: Sat Jul 03, 2010 2:25 am
- Isle Royale Visits: 8
- Location: Quad Cities, IL
Re: [Tool] Isle Royale Trip Planner Spreadsheet
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.