Snow!

I’ve been salivating recently. Not because of anything I’ve eaten, but because of the Birkie Webcam at OO. Conditions look gorgeous, and the early snowpack looks to stay in place at least through the New Year—hopefully it will grow and flourish. Ski reports I’ve heard have been fantastic, and I kind of wish I was headed to Birkieland even with a good thump of snow coming to the Northeast. Oh, well. We can’t all be lucky enough to live in Hayward.

Major fare sale to MSP

Flying to the Birkie from afar? If so, there is a major fare sale for flights in to MSP. Sun Country has posted fares under $200 from most cities round-trip, and Delta has matched most of these. These are non-stop flights right to MSP. This is a great deal, guys.

I’m seeing $178 from Boston and DC, $198 from NY and Seattle and $218 from San Fran. If you are booking air travel and have not yet done so, do it today.

You can thank me later.

Trail porn

We generally keep this a family-friendly site here at BirkieGuide.com. BUT! There is now a live webcam at OO. So if you want to see pictures of snow, groomed, and on the Birkie Trail, you can. This is something I will probably be looking at daily until the race, and hourly starting in, well, as soon as there is snow. This is pretty darned exciting! (Of course, if you look right now, there are the vestiges of some early snow melting away. But this soon will move away!)

136 days to the Birkie. 0 entries left.

In case you missed it, it is now too late to register for the Birkie. Yup. Sorry. (Oh, you can raise money for JDRF and that will allow you in. Maybe.) So if you’re not in yet, you’re hosed. If you think you signed up, but you had that slight twinge of “maybe it got messed up somehow and I don’t remember” well, then, there is the opportunity to confirm your registration. Did I do that this afternoon? I most certainly did.

Now, there’s four-and-a-half months to get fast. If you live in Boston, Madison, San Francisco or Edmonton (for reals) you should check out November Project, because they run stairs, hills and do strength, and it’s a lot easier to run stairs with other people than on your own. If you live elsewhere, well, there’s no law against running hills at 6:30 a.m. every Monday, Wednesday and Friday.

Almost half way there!

The dog days of August are upon us. With the Birkie early next year—February 22nd—it means that we’re almost at the halfway point to start counting down to the next Birkebeiner rather than up from the most recent one. I was going to have a Halfway to Birkie party with local skiers to drink beer and tell lies but then was offered a position as hutmaster at Lakes of the Clouds Hut, on the high alpine reaches of Mount Washington. So instead, I’ll be getting paid to go hiking for a month. That’s not a bad thing.

Next year, I won’t be working 5000 feet on the side of a mountain, so we’ll hammer this out (also, it turns out that I’ve been trying to schedule a call with the new Birkie director for about two weeks and it keeps falling through). So stay tuned for that!

Anyway, I’ll be getting back to more Birkieguide soon. I hope everyone’s training is going dandy. I’ve managed to rollerski twice in the last week, totaling more than 60k. This is good! Slightly higher in the Elite Wave, here I come.

Data

It’s coming. I’m having some issues/fun with getting everything uploaded without crashing the server. It’s not the tippity top of my priorities by now, but I’m hoping for some time in May. If I’m lucky, hopefully before the last snow melts out of the Midwest (and, jeezum, before the Larium Glacier melts out up in the Keweenaw).

Anyone good at coding/data visualization?

So, I need some help. I have some really fun data. It shows, for every minute during the Birkie, how many skiers were at each quarter kilometer of the course. The example above, for instance, shows the state of the race—the actual position of skiers on the course, by wave—at 9:03 a.m.. The fourth wave is just setting out while the earliest waves are already forming packs. The front of the third wave is catching the front of the second; the front of the second wave is making progress in to the first. Pretty cool, right? (These are all based on four split times, so it’s not a perfect representation of exactly who is where, but it’s a pretty good approximation.)

I want to animate these, probably in to a Youtube or Vimeo and play it at, say, 5–10 fps (so each hour is 6–12 seconds and the whole of the race takes a minute or two). But there are (at least) two relatively major stumbling blocks, and if anyone can help, I’d certainly be grateful:

  1. I need to export 600 images. One for each minute, 8 a.m. to 6 p.m. I certainly could do this manually, but I would be driven to the drink well before the first wave arrived in Hayward. In other words, I need to automate this. I think it could be done in Excel; you’d need a Macro to find a piece of text, increment it, export the chart and loop back to the beginning. (Why the find-replace? The method I used to get the data was to calculate the position for each racer for each minute. I then ran a separate count for the number of skiers in each 250m block for a particular minute and made a chart. Then I run a Find-Replace to go from, for instance, cell AB to cell AC which increments one minute forward. If anyone has a better idea how to do this in Excel or in a SQL environment, I’m all ears.)
  2. Take all these images in to some kind of video-making program and compress it in to a “time lapse” thing. I think I know someone who can do this, but if anyone has those skills, and if we get to that point, I’d be very happy for the help.

If you can provide any assistance, it would be fantastic. Drop me an email (ari.ofsevit@gmail) or comment here (you need to log in; otherwise we get lots of spam) to get in touch. Extra bonus points if you’re patient enough to explain to me what you’re doing, instead of just doing it. I’d certainly give you lots of on-site recognition for any help, and probably buy you a beer in Hayward next February.

 

They’re running in Unix Time

An obscure Simpsons quote notwithstanding, it’s time for me to brush up on Unix time. Why? Because I have a dataset with close to 20,000 rows of Birkie data, and the split times are in Unix time. It’s exact, yes, but kind of kooky to sort in to real-life time.

In any case, look for data updates in coming days. Data!

Updates: we’re getting some really fun data for the number of people each skier passed and was passed by, split data, and the like. Stay tuned!

New things on the site

A few new things to note:

  1. New race reports. Check them out. And keep them coming!
  2. New Birkie Trail Subway-style Map. Yes, I am that much of a nerd.
  3. A post about the 100k day I skied on the Birkie trail a few years back. The weather should be just about right for something like that this year if the grooming holds.
Results: coming. Don’t hold your breath; once I have the data it takes a few days to get it in to a usable format.