News from New Zealand
Posted: Sat Sep 20, 2014 3:03 am
As a brand new member to the forum, I thought I'd introduce myself and share my recent PWD experience. I've been a Cub leader for about 20 years (based in Christchurch, New Zealand) and until about 3 months ago had never heard of the Pinewood Derby. Our Scouting Zone (Torlesse) recently held a Six Leader training camp and we were looking for a fun activity to wrap around the leadership training sessions. Our Zone Cub Leader had participated in a PWD as a Cub in the US, and suggested we hold a derby at the camp. To our knowledge there had never been a Pinewood Derby in this area before.
I volunteered to make the track and so the research began (you can't buy a track in NZ, and importing one would have been too expensive). I eventually settled on some (rather old) plans by Larry Bosworth and construction of a 4 lane track began. I thought I was realistic about how much work this would be, but its fair to say it took a LOT more time than I anticipated. Anyway the track was finished successfully, and I recommend Larry's design - although in hindsight I could have saved quite a bit on hardware by relying more on modern adhesives. I imported 60 sets of wheels and axles from Maximum Velocity and we made the blocks locally.
To manage the race I put together to Excel spreadsheet. From lots of reading online at seemed a heat schedule based on Stan and Cory's Partial Perfect-N was the way to go. I started with a spreadsheet shared online by Bob Baggerman but the problem with Bob's sheet was the pre-generated PPN charts it included only went up to a maximum of 15 cars. I found the online PPN generator, but wasn't confident of having good enough data coverage at the camp to rely on internet access. We were expecting 48 Cubs at the camp, and I wouldn't know the exact number of cars until a few minutes before the race so I needed to be able to generate the heat schedule in the spreadsheet. I read about the PPN.DLL, but every reference to it ended in dead links. I eventually found the DerbyRunner project https://code.google.com/p/derbyrunner/ and from this extracted the PPN generator python script. I considered rewriting this in VBA, but with time getting short, I found an Excel addin that allows you to call a python script from Excel. Using this I modified the spreadsheet to generate the heat schedule at the push of a button based on the number of cars entered in the sheet. Some other enhancements I made to the spreadsheet included buttons to play some mp3 sound effects, use of Windows Text-To-Speech to automatically announce what cars are in which lane for each heat (using Ivona's voices which are very realistic and highly recommended), and a separate "Projector View" sheet that I would put in a different Window and project onto the wall so everyone could see the results as entered and see who was in the next race.
We ran our derby a bit different from the typical approach as we wanted it to be a surprise and have the Cubs actually make the cars at the camp. Since none of the Cubs knew what a Pinewood Derby is, we showed them the Down & Derby movie on the first (Friday) night of camp. Making the cars was scheduled between the Sixes cooking their dinner on the Saturday night, and campfire. We gave them a wedge shaped block and provided rasps, files and sandpaper for some minor shaping of the block, a table with jigs for fixing the wheels, and also had some adults with offcuts of wood and jigsaws to make shapes on request that the Cubs could fix to their car with quick drying glue. We setup the track and allowed them some practice runs before painting their car and leaving it to dry over night. 95% got a basic car made and painted in 90 minutes.
On the Sunday morning, after Cubs Own we had the derby. I was delighted that everything went to plan and the race was very successful. The buzz in the hall during the race was incredible. The spreadsheet worked really well, and the Cubs and leaders liked the automated voice announcements and I think they helped us keep up a reasonable pace (we did 49 heats plus a tie breaker in about 60 minutes). The track start gate worked well. We had no electronic finish gate - just three adults calling which lanes were 1st, 2nd and 3rd which worked pretty smoothly. It helped of course the cars were rather crude - no lube, no alignment and varying weights so the finishes were seldom close. Oh and I made the track 25% longer than the plans which helps separate the cars more.
So of course now we have made the track and caught the PWD "bug" and are keen to hold a regular PWD event. I've already ordered some parts to make a Arduino based track timer which I plan to integrate with the spreadsheet.
One thing I'm curious about is the current "health" of Pinewood Derby in the USA. From all my reading over the last few months, the vast majority of the information online is quite old. The number of new posts on this forum on the last years seems quite low for example. I realize PWD has been around for a long time but the general impression I get is that there is a lot less PWD activity these days than there has been in the past. A lot of links to resources point to sites that don't exist anymore. Is PWD as popular as ever in the US, or has interest in the activity waned somewhat in recent years?
Anyway I'm excited about developing a annual Pinewood Derby event in Christchurch, and judging by the feedback from our Sixer camp I think its going to be very popular.
I volunteered to make the track and so the research began (you can't buy a track in NZ, and importing one would have been too expensive). I eventually settled on some (rather old) plans by Larry Bosworth and construction of a 4 lane track began. I thought I was realistic about how much work this would be, but its fair to say it took a LOT more time than I anticipated. Anyway the track was finished successfully, and I recommend Larry's design - although in hindsight I could have saved quite a bit on hardware by relying more on modern adhesives. I imported 60 sets of wheels and axles from Maximum Velocity and we made the blocks locally.
To manage the race I put together to Excel spreadsheet. From lots of reading online at seemed a heat schedule based on Stan and Cory's Partial Perfect-N was the way to go. I started with a spreadsheet shared online by Bob Baggerman but the problem with Bob's sheet was the pre-generated PPN charts it included only went up to a maximum of 15 cars. I found the online PPN generator, but wasn't confident of having good enough data coverage at the camp to rely on internet access. We were expecting 48 Cubs at the camp, and I wouldn't know the exact number of cars until a few minutes before the race so I needed to be able to generate the heat schedule in the spreadsheet. I read about the PPN.DLL, but every reference to it ended in dead links. I eventually found the DerbyRunner project https://code.google.com/p/derbyrunner/ and from this extracted the PPN generator python script. I considered rewriting this in VBA, but with time getting short, I found an Excel addin that allows you to call a python script from Excel. Using this I modified the spreadsheet to generate the heat schedule at the push of a button based on the number of cars entered in the sheet. Some other enhancements I made to the spreadsheet included buttons to play some mp3 sound effects, use of Windows Text-To-Speech to automatically announce what cars are in which lane for each heat (using Ivona's voices which are very realistic and highly recommended), and a separate "Projector View" sheet that I would put in a different Window and project onto the wall so everyone could see the results as entered and see who was in the next race.
We ran our derby a bit different from the typical approach as we wanted it to be a surprise and have the Cubs actually make the cars at the camp. Since none of the Cubs knew what a Pinewood Derby is, we showed them the Down & Derby movie on the first (Friday) night of camp. Making the cars was scheduled between the Sixes cooking their dinner on the Saturday night, and campfire. We gave them a wedge shaped block and provided rasps, files and sandpaper for some minor shaping of the block, a table with jigs for fixing the wheels, and also had some adults with offcuts of wood and jigsaws to make shapes on request that the Cubs could fix to their car with quick drying glue. We setup the track and allowed them some practice runs before painting their car and leaving it to dry over night. 95% got a basic car made and painted in 90 minutes.
On the Sunday morning, after Cubs Own we had the derby. I was delighted that everything went to plan and the race was very successful. The buzz in the hall during the race was incredible. The spreadsheet worked really well, and the Cubs and leaders liked the automated voice announcements and I think they helped us keep up a reasonable pace (we did 49 heats plus a tie breaker in about 60 minutes). The track start gate worked well. We had no electronic finish gate - just three adults calling which lanes were 1st, 2nd and 3rd which worked pretty smoothly. It helped of course the cars were rather crude - no lube, no alignment and varying weights so the finishes were seldom close. Oh and I made the track 25% longer than the plans which helps separate the cars more.
So of course now we have made the track and caught the PWD "bug" and are keen to hold a regular PWD event. I've already ordered some parts to make a Arduino based track timer which I plan to integrate with the spreadsheet.
One thing I'm curious about is the current "health" of Pinewood Derby in the USA. From all my reading over the last few months, the vast majority of the information online is quite old. The number of new posts on this forum on the last years seems quite low for example. I realize PWD has been around for a long time but the general impression I get is that there is a lot less PWD activity these days than there has been in the past. A lot of links to resources point to sites that don't exist anymore. Is PWD as popular as ever in the US, or has interest in the activity waned somewhat in recent years?
Anyway I'm excited about developing a annual Pinewood Derby event in Christchurch, and judging by the feedback from our Sixer camp I think its going to be very popular.