2014 SN Diary: Travel Day, June 20

I’ve set this post to be published at around the time I board my first flight Friday morning. It’s rare for me flying anywhere for fencing besides Portland or Phoenix to get a flight that leaves later than 6:00 am, which means I get up at 2:30 or 3:00 to get myself to the airport in time. I learned long ago not to try to work on my way to tournaments—flights are for traversing the wormhole into the alternate universe of Tournament Time. My main goal is to stay awake long enough to board my flight, and then sleep. If I can’t sleep, I’ll watch the landscape out the window, and if it’s cloudy and I can’t sleep, I’ll resort to a crime novel or science fiction. The point is to avoid anything like reality, because that transition into the unreality of Summer Nationals is an important factor in how I survive it.

Over the last couple of weeks, in addition to working on the BC staff schedule and other SN prep (plus reviewing material for tomorrow’s board meeting), I’ve been creating the beginnings of posts for every day of SN. I think I’ve finally figured out a way to blog SN as it happens that I will be able to keep up with through the ever-increasing cognitive dysfunction.

The pre-written sections are a look at what each day’s competition is expected to look like from my point of view, and includes what I think of as the “big grid” in the strip planning spreadsheet we use. So this post will provide some basics about how that spreadsheet works and how we use it.

Here’s the big overview of a typical competition day:

whole sheet

The big grid on the left is the overall view of strip usage by the half hour through the whole day. The righthand two-thirds are columns for each event. What we do is enter the data for each event in the appropriate columns, and from that the formulas generate the grid view.

Here’s a look at the information on a single event:

eventThe category, sex, weapon, and number of entries are entered in the blue boxes at the top. On the left side of the column, we can enter the time. Traditionally, we enter the time as a half-hour later than close of registration, to allow for the withdrawal of no-shows, resolution of conflicts, and assignment of referees. With the new setup, using the referee auto-assign, we can now start as soon as 5 minutes after close, but we have chosen not to adjust the spreadsheet for that yet, since slight overestimating the time required works in our favor.

Below the number of entries, the worksheet gives us the range for the number of pools possible. For national events, we almost always choose the smallest available number because the rules require maximizing pools at 7 members whenever possible. (Veterans are the one category allowed to have pools of 5 even when larger pools are possible, but we don’t like to do that unless we’re really pressed for time, since the Vets, like most fencers, always like having more bouts.) Also in this section, we can set the promotion rate and whether the pools should be flighted, and the worksheet shows how many strips that will use and how long the pools can be expected to take.

The next section shows the DEs and how many fencers are promoted to that round. After indicating whether there is repechage (always and forever at national events, I hope that box shows “N” because a “Y” means 2-3 hours longer for that event to occupy 8-16 strips than without repechage. Again, we set the number of DE strips and the worksheet shows the time required.

If there is repechage, the next section down shows the strip usage from the round of 32 or 16, as applicable.

Finally, the last section shows the timing for the round of 8. The formulas have not yet been updated to show the effect of replay, so we sometimes bump up the “seeding minutes” between rounds to allow for the extra time replay takes.

What we do when we create the schedules for national events is enter the data for all the events for each day, and then we start playing around with the start times, the number of DE strips, and whether pools need to be flighted in order to make everything fit into the overall day, as shown in the big grid. Sometimes it’s a pretty easy process. Other times, there are long stretches of time filled with exclamations like “Ack!” and “Yikes!” and “Crap, that didn’t help at all!” and “Oops, so not going there!” as we try various options.

Note, by the way, the number in the top upper left of this column of information. That’ll tell you which column in the grid shows this event.

 

Looking at the whole-day picture, we can find additional useful information:

grid

In the main part of the grid, each column represents a single event, with the weapon indicated at the top of the column, and each cell shows how many strips are used during that particular half hour. On this day, there are 5 individual events and 2 team events (those are further to the right, in the “T” columns). So looking at our event from above in column #2, we can see that the pool round will use 22 strips from 8:00 am to 12:30 pm and the DE round will use 16 strips (4 complete pods) from 12:30 pm to about 4:00 pm. The actual time will vary according to how fast the fencers fence and when the complete round of 16 can move over to replay. So the timing shown here for the final rounds will be only an approximation of the eventual reality.

Further to the right are three columns under “Weapon,” which show how many referees are needed in each weapon during any given half hour, and at the bottom, the maximum number required simultaneously.

The last column on the right shows the number of strips in the hall, and further down, ominous red numbers that indicate strip deficits. As a general rule, red numbers here are bad, but some are worse than others. A -1 or -2 when a final of 8 is finishing isn’t really a problem, because by then that 8 is probably in its semis or gold medal bout and not using all 4 of its allotment. And the -17 on this day is what I think of as a squishy negative—many of the 32 DE strips used by the #1 event will already be free as the last few finish up, so not too many of the pools of the afternoon events will need to be delayed. Unless, of course, that #1 event has a major injury or equipment problem that delays the last pool coming in, so that the DEs start late and then finish late, and suddenly we’ve got a competition day that’ll run later than projected.

Down at the bottom left, we can change the times allotted for each kind of bout and match. They’ve been where they are now for the past couple of years. It used to be that foil durations were somewhere between epee and saber, but that changed with the foil timings. It also used to be that saber generally ran faster than projected, and foil and epee more slowly, to the point that if the point weapons finished within an hour after their projected end times, I considered it in good time. Since we’ve started using replay, saber tends to run at or slightly later than projected, and epee often runs as much as an hour ahead. Foil these days consistently runs more slowly than both other weapons, though we haven’t quantified it well enough to change the timings yet.

So that should give you the basics of how to interpret the “how hard was today supposed to be?” grids I’ll be posting throughout SN.

Advertisements

3 comments on “2014 SN Diary: Travel Day, June 20

  1. It would have been nice if you had mentioned who spent countless hours designing and developing the spreadsheet and gave it to the USFA for free. [cough] [cough] It should also be noted that it’s only the fields shown in blue that are filled in. All of the numbers in black (including the strip usage section) are automatically calculated from the data that is entered in the blue fields.

    • Oh, George, you’re absolutely right. Last night as I was falling asleep I remembered that I’d meant to thank you specifically and profusely for creating this spreadsheet. I can’t even begin to think about scheduling our tournaments without it–and I’m by no means alone in that. Unfortunately, by the time I woke up, I’d shifted into set-up day mode, and it completely slipped my mind to fix that.

      I hope you’ll forgive me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s