[Tool] Isle Royale Trip Planner Spreadsheet

Questions about trails and campsites on the island.

Moderator: MikeT

WiscoDude3
NewbieCake
Posts: 4
Joined: Fri Mar 31, 2023 11:04 am
Has thanked: 1 time

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by WiscoDude3 »

This is a really great tool. Thanks for the effort of creating this.
As someone that's completely new to the island, is there a map that someone could refer me too when building my itinerary?
I'm not familiar with some of the trail/location names.

Thanks!
User avatar
dcclark
May actually live on IR
Posts: 391
Joined: Fri Aug 11, 2017 1:39 pm
Isle Royale Visits: 4
Location: Grand Rapids, MI
Has thanked: 161 times
Been thanked: 141 times
Contact:

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by dcclark »

The best map by far is the National Geographic paper map #240 -- waterproof and detailed for use on the island.

For use in planning, I'd check out this one or the ones at NPMaps. Not as detailed, but they show the key locations.
User avatar
hooky
IR Expert
Posts: 791
Joined: Mon Mar 26, 2012 11:26 am
Isle Royale Visits: 2
Location: Central Indiana
Has thanked: 138 times
Been thanked: 54 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by hooky »

Mdskpr wrote: Mon Feb 14, 2022 7:58 am Ingo...thank you for the reply & direction.

In planning my trip I believe I ran into an issue. From Hatch Lake / Greenstone Junction, there is no option for Hatchet Lake Campground or Minong Trail junction toward Todd Harbor. You can only travel to: Ishpeming Point, Desor, or Island MIne /Greenstone junction.
From hatch/greenstone you should be able to select hatchet lake camp junction then get the hatchet lake minong junction and then the Minong destinations. Should look like this:

Image

Anywhere there's a junction, you have to go to that junction and make a choice on where to go next. It's easier if you have a map in front of you to see all the minor junctions.

Even a simple map like this will help you understand all the junctions
Image
User avatar
Backpacker534
May actually live on IR
Posts: 396
Joined: Thu Aug 21, 2008 5:41 pm
Isle Royale Visits: 9
Location: Michigan
Has thanked: 4 times
Been thanked: 28 times
Contact:

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Backpacker534 »


dcclark wrote:The best map by far is the National Geographic paper map #240 -- waterproof and detailed for use on the island.

I agree, dcclark! I have owned two of them since my first ISRO trip in 1999. Priceless piece of "gear", especially if you geek out on maps like I do. Image

Sent from my SM-G781V using Tapatalk

User avatar
odd man out
LNT Expert
Posts: 76
Joined: Tue Feb 23, 2016 3:13 pm
Has thanked: 5 times
Been thanked: 15 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by odd man out »

The problem with the NG map is my hike will cover just a small percent of it. I think I will print out some custom maps from CalTopo and put the in a large baggie.

As for the planning tool, I know the trails pretty well but still found ithe spreadsheet a bit confusing to use. A web page interface where you could click on a map would be nice. Maybe I will program one when I retire.
User avatar
Ingo
Forum Moderator
Posts: 1951
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 270 times
Been thanked: 165 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

odd man out wrote: Mon May 01, 2023 10:27 am As for the planning tool, I know the trails pretty well but still found ithe spreadsheet a bit confusing to use. A web page interface where you could click on a map would be nice. Maybe I will program one when I retire.
A web interface would be great! Unfortunate that's not in my skill set. I've always wished someone would be inclined to take it and make it more user friendly. The original spreadsheet is 20+ yrs old--it wasn't until Google sheets supported all the drop-down and lookup functions that I made it public. I originally did it for paddling/portaging times, which I mostly do, and the point-to-point trail intersection thing is an extension of that. Frankly I thought it might be too unfriendly for most folks, but have been surprised to see people handing a print out of it to the rangers when filling out itineraries.
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
odd man out
LNT Expert
Posts: 76
Joined: Tue Feb 23, 2016 3:13 pm
Has thanked: 5 times
Been thanked: 15 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by odd man out »

I've used Javascript to program interactive web pages. If I were to do it it would be text based and very primitive looking. But I do like the spreadsheet is set up to hike from node to node. That is a logical way to plan.

I was wondering where all the mileages came from. There is more detail there than on the maps ive seen.
User avatar
Ingo
Forum Moderator
Posts: 1951
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 270 times
Been thanked: 165 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

odd man out wrote: Mon May 01, 2023 11:31 am But I do like the spreadsheet is set up to hike from node to node. That is a logical way to plan.
And a clickable map would be really great :D !
odd man out wrote: Mon May 01, 2023 11:31 amI was wondering where all the mileages came from. There is more detail there than on the maps ive seen.
You made me look... I thought I was tracking the sources in the "Combos" sheet, but apparently I dropped that at some point. In addition to maps, I also used some data from Mike Tremblay who started the first forum pre-dating this one and developed his own tools, although I'm not sure if he's kept them up (http://www.isleroyale.info/index.html). And it used to be more common for folks to report measured GPS distances, so some came from there. And as a last resort, I may have just made up some of the short spurs after trying to measure on Google maps where I figured .1 or .2 miles was close enough :D . The paddling distances are from measuring on a map.
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
hooky
IR Expert
Posts: 791
Joined: Mon Mar 26, 2012 11:26 am
Isle Royale Visits: 2
Location: Central Indiana
Has thanked: 138 times
Been thanked: 54 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by hooky »

@Ingo you mentioned Mike, has anyone seen or heard from him lately? Seems like it's been several years since he was active.
User avatar
Ingo
Forum Moderator
Posts: 1951
Joined: Wed Sep 12, 2007 1:11 pm
Isle Royale Visits: 14
Location: Hillsborough, NC
Has thanked: 270 times
Been thanked: 165 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Ingo »

hooky wrote: Tue May 02, 2023 10:32 pm @Ingo you mentioned Mike, has anyone seen or heard from him lately? Seems like it's been several years since he was active.
No, not for a few years that I recall.
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
odd man out
LNT Expert
Posts: 76
Joined: Tue Feb 23, 2016 3:13 pm
Has thanked: 5 times
Been thanked: 15 times

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by odd man out »

I have started a clickable web page. The first version will have buttons, not a map. I will post when I have a functioning version.
User avatar
Backpacker534
May actually live on IR
Posts: 396
Joined: Thu Aug 21, 2008 5:41 pm
Isle Royale Visits: 9
Location: Michigan
Has thanked: 4 times
Been thanked: 28 times
Contact:

Re: [Tool] Isle Royale Trip Planner Spreadsheet

Post by Backpacker534 »

odd man out wrote:I have started a clickable web page. The first version will have buttons, not a map. I will post when I have a functioning version.
How cool! I can't wait to see it.

Sent from my SM-G781V using Tapatalk

Post Reply