BWCA BWCAW Permit Availability Study April 24, 2019 Boundary Waters Trip Planning Forum
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(8071)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower member
  
04/24/2019 01:30PM   (Thread Older Than 3 Years)
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
04/24/2019 02:41PM  
Great stuff!!! Thanks for the info your work.
04/25/2019 08:58AM  
Great info, thanks!
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(647)distinguished memberdistinguished 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(647)distinguished memberdistinguished 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(8071)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(4163)distinguished memberdistinguished memberdistinguished memberdistinguished memberpower 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(8071)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(587)distinguished memberdistinguished memberdistinguished memberdistinguished member
  
04/25/2019 07:58PM  
Amazing ! Thanks !

Jim
04/26/2019 04:13PM  
I love this, Schweady. Thanks for doing it. I love spreadsheets!
jacobf
member (40)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(8071)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 (40)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(8071)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
Trip Planning Sponsor:
Sawbill Canoe Outfitters