Chat Rooms (0 Chatting)  |  Search  |   Login/Join
* For the benefit of the community, commercial posting is not allowed.
Boundary Waters Quetico Forum
   Trip Planning Forum
      BWCAW Permit Availability Study April 24, 2019     
 Forum Sponsor

Author

Text

schweady
distinguished member(6680)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
 
04/24/2019 01:30PM
Second in a monthly series

I’m back at it with a new set of numbers showing the permits remaining for the 153 days in the reservation season. 63 entry points x 153 dates = 9,639 numbers representing the 41,049 permits offered each year.

This data was collected one week before the beginning of the month of May. Hopefully, I can continue to present similar snapshots of permits remaining each month on May 25, Jun 24, Jul 25, and Aug 25.

The rationale for the study may be found in my first installment for 2019:
BWCAW Permit Availability Study March 25, 2019

So, here are the results for April 24, 2019 (7+ weeks into the reservation period). I hope you'll enjoy exploring the twenty-one pages of stats on the permits remaining at each of the 63 individual entry points and the three summary pages at the end:

 
Reply    Reply with Quote    Print Top Bottom Previous Next
WhiteWolf
distinguished member(4050)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
 
04/24/2019 02:41PM
Great stuff!!! Thanks for the info your work.
ManAndDog
member (24)member
 
04/25/2019 08:58AM
Great info, thanks!
paddlinjoe
distinguished member (350)distinguished memberdistinguished memberdistinguished member
 
04/25/2019 09:21AM
I really enjoyed looking through your data. Very nicely presented. Thanks for the taking the time to share it.
04/25/2019 10:16AM
Very cool info and study. Thanks!
scotttimm
distinguished member (202)distinguished memberdistinguished memberdistinguished member
 
04/25/2019 11:23AM
I love data. I can't help but think of how this could be of use to the Powers that Be in future consideration of permit handling...thank you for this!
scotttimm
distinguished member (202)distinguished memberdistinguished memberdistinguished member
 
04/25/2019 11:30AM
Can I ask a question about the color formatting? Looking at the monthly snapshots, for example, the EP 16 Moose River - why is a "5" green in June but light red in September?
schweady
distinguished member(6680)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
 
04/25/2019 03:40PM
scotttimm: "Can I ask a question about the color formatting? Looking at the monthly snapshots, for example, the EP 16 Moose River - why is a "5" green in June but light red in September?"
Yikes! Thank you, scotttimm! You found a conditional formatting range error I made for Jul, Aug, and Sep in all of the individual EP pages. (cyclones30 found the same error of mine last month in my summary calendar, but I didn't think to also check each individual entry point. Duh...)

7:06 pm... Fixed!
cyclones30
distinguished member(1766)distinguished memberdistinguished memberdistinguished memberdistinguished member
 
04/25/2019 06:50PM
Always like these! I did mine in the winter when I had time, now that it's planting season...no way I'll do it now. Thanks! Surprised to see Pine lake jump up that high
schweady
distinguished member(6680)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
 
04/25/2019 07:07PM
Got that pesky conditional formatting fixed and the individual EP calendar colors make a lot more sense. Thanks to both of you for digging deeply enough to find areas in need of correction. Together, we're better.
1JimD
distinguished member (393)distinguished memberdistinguished memberdistinguished member
 
04/25/2019 07:58PM
Amazing ! Thanks !

Jim
Jaywalker
distinguished member(1960)distinguished memberdistinguished memberdistinguished memberdistinguished member
 
04/26/2019 04:13PM
I love this, Schweady. Thanks for doing it. I love spreadsheets!
jacobf
member (32)member
 
05/03/2019 12:57PM
I was working on learning some web scraping and app development and schweady's work reminded me that the BWCA permit reservation page would be the perfect thing to practice with. I created a script that would go through all the dates and pull the number of available permits and then publish them to a page where you can compare two entry points. The method I'm using lacks control over formatting the cells like in schweady's results, but it was a fun exercise. You can access it at the link below.

BWCA permit visualization
schweady
distinguished member(6680)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
 
05/04/2019 09:43AM
Cool work, Jacob.
Is it possible to compare more than two EPs at a time?
jacobf
member (32)member
 
05/04/2019 01:58PM
schweady: "Cool work, Jacob.
Is it possible to compare more than two EPs at a time?
"


Yes, there’s not really any limit on the number other than space on the screen. I would just have to adjust the code. How many are you thinking?
schweady
distinguished member(6680)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
 
05/04/2019 03:19PM
Just curiosity, mostly. Any number from 1 - 63 has its own level of usefulness, I suppose.
 
Reply    Reply with Quote    Print Top Bottom Previous Next