A Better Way to Visualize XC Team Results

I’ve always thought that we could do a lot better displaying XC race team results.  The cold, dry text format that we’re all used to is nice for a quick score, but pretty bad for most anything else.  Just how did our fifth runner stack up against everyone else’s?  Sure, you can scan the column and compare a couple teams at a time, but there should be a better way.

Another thing that should be easily visualized is the differences in the scores.  Let’s say we were behind a team by 10 points.  Is that a lot?  In a dual meet it’s not really that close but in the state meet or a big invitational that’s a razor thin margin!

Here’s my attempt at making cross country team results way more fun to look at.  These are the results from the North Carolina XC State meets from November 3rd, 2018.  Each column represents a team.  Each colored section in the column represents the points for one of the five scoring runners.  The total column height is the team score for the team.  Hover your mouse over the columns to see a popup that shows the runner’s name, place, and time.

Take a look and let me know what you think.  How would you improve it?  Any reason Milesplit shouldn’t do this? If you like this, follow me on Twitter.

The XC Coaching Timer App I Created

Since we just got done with the state meet yesterday, I wanted to post some details about the app I created a few years ago and the companion web site.  I don’t have any plans on making this available to others, but maybe it will give someone some ideas to do some better things with a timing app.

The Problem I’m Trying to Solve

My wife Joan is the head coach of Chapel Hill High (I’m the assistant).  Although I’m the “data guy,” Joan is simply amazing at remembering all the PRs and times of the entirety of both the boy’s and girl’s teams.  As soon as the runners finish a race she instantly knows if they ran well or not with high accuracy.  I quickly realized that there was no way I could remember the PRs for 80 kids each season.  I knew I needed a technological solution.

Here’s a list of things that I wanted to be able to do:

  1. Be able to record the finishing times of each runner on the team as they cross the line without having to write anything down on a clipboard.
  2. Easily keep track of mile splits during a XC race for each runner on the team.
  3. Tell me at a glance how well the runner ran compared to their personal best and their season best.
  4. Keep track of the big, notable workouts we do each year to be able to compare runners’ progress across years against themselves and against runners that graduated seasons ago.

My Approach

The Web Site

I created a web site using PHP and a database that can store times, splits, and rosters from races and workouts. You can do all sorts of queries and reports to compare 5k results across the program’s history or see a particular workout report that shows athlete’s improvements over time.

This was quite an effort but not because of the coding as much as collecting as much race history as we could from Mile Split and our archives. Of course this is mostly a manual effort and Mile Split doesn’t make it easy since they only allow you to show one race at a time instead of being able to download your team’s entire history.  I made this request to them but they were not interested in allowing this.

My Android Timing App

The web site is pretty nice, but by itself it’s not particularly unique.  In my mind the real convenience is the Android app that I created to integrate with the web site for efficiently timing the actual races.  I call it Coaching Timer (such an amazing name I realize!) and here’s some screenshots to show how it works.

Timing the Race

Here’s a screenshot of the main timer view.  You start the timer with either volume up or down button.  The 04:45 is the current elapsed race time.

The main timer view for a race

As they come through the mile split, I press the button for that particular runner as they cross the mile mark.  The runners are in descending order by their PR (more on how this happens later – it’s easy!)  When I press a runner’s button, that button goes to the bottom of the list of buttons.  See this screenshot that shows Ben Hawley and Owen Rogers having dropped to the bottom of the list.  Why is this important?  It minimizes the hunting I have to do to find the name as someone crosses the mile mark.  It also allows me to quickly determine if every team member has crossed the mile mark.  Also, if I end up having to click a button out of order that’s a mild indication that someone might be having a good day or a bad day.

As I click each button the timestamp is recorded along with the name in the left hand column.

Ben and Owen just passed the mile mark

As They Finish

I record the 2 mile splits similarly, but then for the finish the app sees that it’s within a normal range of a 5k finish and it adds some important details to the timestamp.

PR and SB comparison added to timestamp

In the above screenshot, Amelia Maughan, Lilly Crook, and Sydney Runkle just crossed the finish line and I clicked their buttons (which moved to the bottom of the list, remember.)  In this case, though, their PR and SB (season best) data was added to the timestamp.  I can quickly see that Amelia tied her PR, Lilly was 20 seconds off a PR and 10 seconds off a season best, and Sydney beat her PR by 6 seconds.

Send the Results

In the 3 dot menu on the top right of the app, there are several options, two of which allow you to send results.

The Email Times and Text Times menu items let’s you send the results to another app for sending.  Email Times brings up the following email message ready to send.  Text Times let’s you send them via text message.

Sending results via email

So How Does The App Know the PRs?

Here’s where some magic happens that I really like.  You create groups in the app for each race that’s happening – for example, Boys Varsity, Boys JV, Boys JJV, etc.  When you initially start a timer you choose the group to use for the race.

I initially created the groups by hand – typing in each runner’s name individually.  I realized quickly how much better it could be, so I added an Import function for creating the groups.

The import function pulls a list of runners from the web site. It stores three pieces of data for each runner: their name, their PR, and their season best.  The runners are listed in descending order by PR which lines them up just right for selecting varsity, JV, and JJV.

Managing groups and the Import function

Just check the box for each runner to include in this group.

List of runners in descending order by PR

Then to start a timer for a race, just choose the appropriate group and click Start Timer:

Additional Nice Features that I’ve Added

Phone Sleep Prevention: As I’ve used the app over the years I’ve added some features to improve it.  When waiting for the start, sometimes the phone would time out and I’d have to unlock it and, dang, I just missed the start of the race.  So now there’s a feature implemented that prevents the phone from going to sleep with the Coaching Timer app is active.

Volume Buttons Start Timer: Also I realized it was hard to tap a button and look at the starter’s pistol in the distance across a field since there’s no tactile feedback from a virtual button on the screen.  I added a way to start the timer via either volume control – problem solved and it’s much, much easier.

Disabled Phone Rotation: At first I thought it would be important to be able to rotate the phone and have the app switch from portrait to landscape since some names can be long and starting wrapping in portrait mode.  This mostly ended up being disorienting when trying to get splits quickly and I disabled it.

Multiple Simultaneous Timers: Most races end up completing before subsequent race begin, but occasionally that’s not the case and they overlap.  This is why it’s important to be able to keep multiple timers running simultaneously.

Adjust Start Time for Running Timer: Another critical feature that I added that has saved my behind multiple times is the ability to adjust the start time of an already started timer on the fly.  Super useful!  Let’s say you missed the start of the race.  No more quick math to adjust each time after the fact – as long as anyone got the start of the race on their stopwatch, this function let’s you set the timer to any running time.  This has been probably the most useful feature I added – it happens a lot and this is an awesome backup.

Adjustment Factor for Certain Race Venues: There’s an optional “adjustment factor” that you can apply on the web site for certain race venues/meets.  Let’s say there’s a course one day that’s cold and muddy and the times are very slow compared to a “normal” course on a good day, or perhaps a course is short.  You can apply an adjustment factor that provides an adjusted time for the purposes of the PR calculation.  This prevents the PRs being skewed if we run a short course where true PRs shouldn’t really be valid.

The State of the App

The app is pretty stable right now and I’ve thought about releasing it to other coaches.  But in order to do that I would have to put a good amount of work into generalizing it to work with other teams.  Also, it’s highly dependent on the web site which is another layer of complication for someone to set up.  To be honest I’ve always thought this would be a good thing for MileSplit to do since they have a good bit of the data required to make something like this work for any coach.

If you have any comments or suggestions I’d love to hear some feedback.  Comment on this post and also follow me on Twitter while you’re at it.

Why is Bicycle Commuting Down? More theories from the comments

I got several excellent comments from various people to my post about why bicycle commuting has fallen since 2014.  Some comments disputed some of my thoughts while others provided interesting theories of their own.  I’ll summarize these responses.  Here is the graph again:

I indicated the source as “US Census Data,” but I should have been more specific as one comment suggested that since the “census” is only done every 10 years that these numbers are completely made up.  These numbers come from the American Community Survey and they are updated annually.

The Decrease Isn’t Really Real

A small number of responses were of this type.  They said that the ACS is a survey and there is insufficient data to reflect a real decline.  It’s theoretically possible that the numbers for the last 3 years are erroneous and that the number of bicycle commuters is actually growing, but I doubt it.  The ACS is commonly used by cycling advocacy groups to point to successes – see this report by the League of American Bicyclists (LAB) which comes from the ACS data.

In general I think the LAB’s approach is a good one – attempt to measure municipalities’ cycling friendliness score and then use the ACS data to report successes.  This can be a powerful argument for cycling advocacy – sprinkle some cycling infrastructure improvements and watch it grow.

Given the success in building cycling infrastructure in lots of areas in the US, are we bumping up against a theoretical ceiling for cycling?  I don’t think so but I admit these ACS numbers make me less sure.  One comment suggested that looking at bicycle sales numbers as evidence that the decline is an anomaly. A quick search for those numbers doesn’t look optimistic to me.

Commute Times are Increasing

A few comments suggested looking at workers’ commute times which are, in fact, increasing over time.  Interestingly I couldn’t find any data on commuting distances.  I would imagine that there should be data that analyses congestion over time by looking at commute times and commute distances over time.

By the numbers, all of the new workers over the last several years are choosing to commute by car.  They apparently aren’t bothered too much by the longer commutes/congestion or maybe they don’t feel like they have a choice.  As commutes get longer, at some point along that continuum the choice to bike to work is no longer a realistic option.

The Places Where Cycling Is Easy Are More Expensive

A few folks responded with this argument including economist Arnold Kling:

Perhaps rents went up in some locations, forcing some would-be bike commuters to move out of range

This is not something I thought of prior to writing the post, but this makes a lot of sense.  The areas where cycling infrastructure is excellent or improving are also affected by the housing crisis.  Could it be that local zoning laws are indirectly working against cycling?  Seems like a reasonable theory worth exploring.

The Connected Generation Can’t be Disconnected Long Enough to Ride a Bike

Also, it is much harder to text on your phone when cycling, versus Uber (or even sneaking in texts at stoplights). For the ‘connected generation’ on-road cycling may be an unacceptable interruption. If they want exercise they can use a stationary cycle.

Steve here

This seems logical to me although I have to way to verify it or gauge how important its effect is.  I’ve always thought of this as an advantage to riding a bike, not a downside.  I’m sure not everyone feels the same way.

Jonathan Haidt Responds on “Helicopter-ness”

I asked Jonathan Haidt (author of The Righteous Mind and Coddling of the American Mind) what he thought about the timing of the decline and the helicopter parent theory.  He responded:

lenore skenazy and i found some data on the sharp decline in biking to school for kids, i think it happened in the 1990s. 2015 would not be a special year, for adults; it was special on campus.  i would not interpret the 3 year decline for adults as anything yet, could be random fluctuation. unless you can get data broken down by age. if you find no change for those over age 30, but yes for under 25, then it is Gen Z. 

I looked for data on bicycle commuting and age via the ACS.  Oddly enough, you can get raw bicycle commuting numbers normally, but when you group by age they are lumped together in a single group with “Taxicab, motorcycle, bicycle, or other means.”  This category is increasing over the timeframe of the bicycle decline which as far as I can tell makes this impossible to isolate bicycle commutes unfortunately.  If anyone knows how to use the ACS to isolate bicycle commuters please let me know.

Here are a couple charts that show the difficulty.  Even though there is a drop in bicycle commuting, this larger group is increasing over time.  Bicycle commuters are only a small part of this group so it’s hard to tease out any effect here.

Randal O’Toole Seems to Doubt the Work from Home Theory

I knew Randal O’Toole was an avid cyclist, so I emailed him to see if he had any ideas.  Here’s how he responded:

Those are good ideas. Here’s an additional datapoint: people who work at home earn the most money. Drive alones are second, transit third, and “other” (which includes cycling) well below that. Walking is lowest.

So if work-at-homes captured cyclists, it was the high-end cyclists. I’m not sure how many of those there were.

A more significant phenomenon: the census form asks people how they “usually” get to work. The National Household Travel Survey found that people who usually drive in fact drive 98 percent of the time but people who say they usually bicycle in fact only bicycle 70 percent of the time. Maybe some of those people who bicycled, say, 60 percent of the time in 2014 went to 40 percent in 2017.

Randal said a couple things that surprised me here.  One is that cyclists as a group earn less money than the average worker.  I tried to confirm this with the ACS survey and it’s true that the group that contains bicycle commuters earn less than average, but I suspect that, like age, this is similarly confounded by grouping “Taxicab, motorcycle, bicycle, or other means” together.  A quick search shows that in Australia cycling commuters are wealthier than average.  I also discovered from survey data from the NC DOT that cyclists that use greenways strongly skew rich and white relative to the local population.

Randal’s theory about percentage of time commuting seems to jive with the housing costs theory previously mentioned.

General Safety Concerns/Helicopter Generation

A large number of comments suggested that cycling is, in fact, getting more dangerous over time due to drivers texting, more cars, more cycling-intolerant drivers, etc.  I agree that it seems there is a general sense among cyclists that of course it’s getting worse on the roads.  This has always struck me as somewhat of a moral panic.  I’ve had my share of cars purposely buzzing me on my bike and yelling crazy things at me but I don’t get the sense from my own experience that these incidents are increasing over time.

Cycling advocates consistently talk about the large number of people who WOULD bike if they could be made to feel safer on a bicycle.  This approach seems to have been successful in getting municipalities to devote resources to large cycling infrastructure projects.  The current generation seems to be especially convinced by appeals to safety but there’s a bit of a paradox.  If people believe cycling is TOO dangerous they’re not going to do it no matter how good the infrastructure is.  (Safety first!)  But if people feel that cycling is safe then there isn’t much demand for new infrastructure to be built.

Are the roads getting more dangerous over time?  I decided to try to answer that question.  It doesn’t feel like it to me but let’s look at the data.  The National Highway Traffic Safety Administration has kept statistics on crashes for a long time.  They produce an annual report that has all sorts of data on traffic deaths.

First off, I would have intuitively expected to see deaths from distracted drivers increasing over time (texting, obviously), but that doesn’t appear to be the case.  (Not sure why we see that sudden decrease from 2009 to 2010 – anyone know?)

OK, well how about deaths from drunk driving?  Are those increasing?  No – it turns out they’re way down.

What about motorists that exceed the speed limit and cause a crash that kills someone?  Getting worse over time?  No – those are down too.

Note that the charts above are pessimistic since I didn’t normalize on vehicle miles traveled which has been steadily increasing over time.  That is, if we accounted for miles traveled the charts above would look even better than they already do.  Here’s a chart of vehicle miles traveled by year.  (Note I adjusted the y-axis minimum for better readability.)

If we reflexively respond to safety concerns in a thoughtless way we sometimes end up with poor solutions that are sometimes worse than the problem.

Most Unique Response: Fade Out of the Lance Armstrong Effect

From my local cycling friend Brendan:

The post Lance Armstrong cycling era taking effect.

I think the high end cycling world has definitely taken a hit – at least anecdotally from my perspective in a cycling heavy area.  I’m reasonably confident (65%) USA Cycling could produce some reports based on road race participation over the last decade and it would show a steady decline.  Would this have an effect on bicycle commuting?  Probably but most likely the effect would be small.

Where is the Cycling Ceiling in the US?

It ultimately boils down to this for me as I alluded to earlier: how much room is there to grow cycling in the US?  Of course I don’t have the answer to this but these numbers make me think that perhaps we’re closer to the ceiling than I would have guessed.  And given the headwinds of safety consciousness, housing costs, the price of gas, and the rise of telecommuting, how big could gains from infrastructure improvements be?

I’m starting to think about a way to come up with an answer to this question on my own from some other data sources.  Look for a post soon.

Offer to Bet

If you believe the drop in bicycle commuting is temporary, I’m offering a bet at 1:1 odds that the bicycle commuting number won’t exceed the number from 2014 in years 2018, 2019, or 2020.  Any takers?  Send me a DM on Twitter: @davemabe.

Commuting by Bicycle is – down?

Imagine the year is 2014.  We’re in the midst of an era when lots of cities across the US are working hard to promote cycling.  By many counts it’s never been easier to ride a bike.  Our family was already three years into getting by with just one car – this would not have been possible without the ease of cycling in my hometown of Carrboro, NC. During and since that time many major cities have implemented lots of cycling initiatives to build new bike lanes, make more areas accessible by bike, and created bike shares to make it as easy as possible to bike. So what would have been your prediction in 2014 about what US bicycle commuting numbers would look like over the next three years? I think it’s safe to say we’d be haggling over how much of an increase in bicycle commuting there would be in 2014-2017.

This makes it even more striking that the number of people commuting by bike in the US has steadily decreased since 2014.  This is over a time period where the total US workforce has steadily increased, so in percentage terms the cycling numbers are even worse than the chart above appears (down from a peak in 2014 of 0.62% to 0.55% in 2017).

So why has this drop in bicycle commuting occurred?  I can’t say for sure, but here are some theories about what might be playing a role.

Americans Really Like Travelling by Car

The percent of US workers commuting by car (alone or carpool) has remained remarkably consistent – it’s currently 85.3% of the workforce. Commuting by public transit is down in percentage terms from it’s peak in 2015 – 5.232% then and 4.998% now.

As much as people complain about traffic congestion, it’s apparently not enough to change people’s behavior too much.

Gas Prices are Down

US gas prices are close to their lowest in a decade, making driving relatively more attractive at the margins.

Popularity of Electric Vehicles

Electric vehicles continue to become more widespread in the US.  When you think about the target market for these vehicles, a significant portion of this group might also consider biking to work.  It’s becoming easier to signal environmental consciousness AND drive a stylish car.  I suspect this is crowding out some would-be bicycle commuters.
(Hat tip to my wife Joan for this one)

Working from Home is Exploding

If the percent of the workforce that is commuting by car is basically unchanged and the percent of transit use is down, what’s left?

It turns out working from home has been quietly exploding.  After a four year run of basically no change from 2008 through 2011, there have been solid increases and now it’s up over a third from 2011.  In fact 2017 was the first year where more people work from home than commute by public transit.  This occurred during a period of lower gas prices – seems reasonable to assume that these numbers are positively correlated.  That is, if the price of gas were higher over the last 3 years or in the future, these work from home numbers likely would be higher still.

Kids of Helicopter Parents Enter the Workforce

Another theory that seems like it might be true is that kids of so-called helicopter parents are coming of age and entering the workforce.  I expect there’s not great data to look at for the “helicopter-ness” of the last couple decades, but it certainly seems to be true that safety (over) conscious parenting has increased dramatically.  (Here’s a daycare that’s suggesting kids wear helmets for recess, for example.)  It’s hard to deny that this has been the case and in fact we’re starting to see responses to this problem.

The time period for the decline in bicycle commuting also might roughly coincide with a generation of safety conscious kids entering the workforce.  Will kids of this generation be more of less likely to commute by bike to work?  The answer seems obvious.

Any other theories?

Predictions on Bicycle Commuting in Next 4 Years?

Anyone willing to offer a bet on what future numbers of bicycle commuters will be in the census data?  If so, contact me.

Public Support for Surge Pricing, I Mean, Price Gouging Over Time

“Price Gouging” has a negative connotation.  The public broadly supports the vague laws that prevent it.  Here’s a list of the states that have laws preventing some form of price gouging along with the language used in the statutes.  You’ll notice that fewer than half of the states that have such laws actually specify a percentage increase in the price – most of the statutes use the vague, “weasel wording” of “grossly excessive,” “unconscionably high,” or similar highly subjective language.  In my state of North Carolina, they use the term “unreasonably excessive.”  Putting aside the problem of putting a precise definition on just what price gouging is, the public supports these laws.

It’s hard to find a public poll directly on this topic – the closest I could find was a Gallup poll about what was to blame when gasoline prices were high in 2008 – 58% blamed “price gouging by oil companies.”

There is a poll, however, of people with the most knowledge of the effects of “price gouging” – economists.  They are overwhelmingly against laws preventing price gouging.  If your knee jerk reaction is that “economists are just partisans that love the rich” – keep in mind that the average economist is a moderate Democrat.

In another setting, though, the public apparently is very supportive of price gouging.  Uber and Lyft are extremely popular with their “surge pricing” being very effective during busy events whether that be a sporting event or a disaster.

I am holding out hope that the public will slowly come around to soften their support of laws against price gouging as they more routinely encounter it via Uber and Lyft and even Airbnb.  In fact, as the sharing economy continues to grow more and more of us become the “gougers” – for example, renting out a room in one’s house during a major sporting event.

What other issues have such a large split in support between the public and economists?

I asked that question to economist Mike Munger who quickly answered “rent control” – an issue that is popular politically but where economists are almost universally against.

How do I feel about it?  I like to say I’m pro choice – for everything.  Especially voluntary transactions.

Why Should We Have To Give Up Privacy by Simply Registering to Vote?

After a discussion with a friend who’s quite concerned about voting rights, I decided to take a look at what voting data was available.  Depending on which side of the issue you are on, you probably think that voter fraud is the most important issue and under reported or you think that voter suppression is the most important issue and under reported.  A lot of discussions about voting get stuck on these points so I was interested in looking at the data and perhaps somehow determining for myself the magnitude of “voter fraud” and “voter suppression.”

I searched for a few voting terms and ended up at the North Carolina Board of Elections web site. I went to the Data & Stats section and was pretty horrified by what I found.

There are several zip files that are freely downloadable anonymously which contain almost every piece of voter registration data and voting history for every registered voter going back over 20 years.  This includes voter affiliation changes, which ballot you used to vote in the primaries, whether you voted early, regular, or absentee in every election, your mailing address, your age, your race and gender, your phone number – basically EVERYTHING associated with your voting history for 20 years EXCEPT what boxes you ended up checking on the ballot.

Here’s a list of things that you can easily do without logging in or paying any fee – just by simply downloading a couple files:

  • The party affiliation of anyone
  • When and how anyone changed their party affiliation for the last 20+ years
  • Whether someone voted or not in each election over the past 20+ years
  • What ballot someone used in each election for the past 20+ years
  • Using street names, look up how your neighbors’ affiliation and whether they’ve voted in recent elections

With a little work you could create a list of people in your town that didn’t vote in the last election or who recently changed party affiliation. You could easily include their address, age, phone number, gender, and race.  All this can be done by anyone who has access to the internet from anywhere in the world.

Here’s one example in Pennsylvania where a shady political group sent mailings to registered voters who failed to vote in the last election with a threat of a followup so that “you and your friends, your neighbors, and other people you know will all know who voted and who did not vote.”

Why do we have to give up this much privacy just to register to vote?

How many people would be less likely to register to vote if they knew they were giving up this much privacy to do so?

Imagine if private companies treated their customer data as carelessly as this.

The best reason I can come up with to support this invasion of privacy is to ensure transparency and therefore faith in our democracy.  The current status quo seems to go far beyond what would be required to fulfill that standard though.

The Golden Modes Award

I happened to notice that our local public transportation organization is giving awards for smart commuting that they call the Golden Modes. Here’s how they describe the awards:

The Golden Modes Awards recognize companies, organizations and people who best use their resources to influence Triangle employees and university students to pursue smart commuting options. Ultimately, they reduce the number of people who drive alone, reducing traffic congestion, alleviating air pollution and improving our quality of life.

My work situation is tailor made for this award!  I went back and looked at previous award winners – taking public transportation from Raleigh to Chapel Hill, commuting by bike to work, commuting by bus to Durham, etc.  How can I not nominate myself for this award given how much better my commute is?  I just self-nominated just ahead of the deadline which is today.  Here’s what I submitted:

Having worked from home for 17 years now, I believe I exemplify the smartest of smart commuting – no commute at all. My carbon footprint is minuscule compared to previous years’ award winners. Working from home has huge benefits – I figure I save 2.5 hours per day for almost 2 decades. This allows a completely different lifestyle than I otherwise would have. I am able to run and cycle with friends, spend more time with family, and get more work done – all without contributing to congestion or requiring a subsidy. Raining? Snowed in? It doesn’t matter to me – my commute is a breeze.

I’m pretty sure there’s no way I can lose this one.

Wager Offered on Net Neutrality

Although I got no takers on my last offer to bet on the light rail project, I’m offering a new one based on the effects of the net neutrality rules being phased out. This change officially went into effect yesterday 6/11/2018.

I’m offering to bet $100 that the cost of internet services as measured by the US Bureau of Labor Statistics will not increase more than the level of inflation on 6/11/2023 (five years from the rule change going into effect). I’m offering even odds.

If the net neutrality rules are put back in effect prior to that time, then the bet will be nullified.

Any takers? DM me on twitter if you’re interested.

My Cheap, Delicious, Homemade Energy Drink

Keith Sockman and I ride bikes together and the subject of energy drinks came up. I told him my philosophy of energy drinks at the time: “Never ride far enough to require any refreshment besides water.” I’m too cheap!

(Quick aside about the energy drink market – it’s big business! On any serious cycling ride you’ll find all sorts of colors and textures of liquids being consumed from water bottles. They’re expensive. In fact, in true cycling over-the-top fashion you can order custom energy drinks specific to your body – that can’t be cheap!)

Keith told me that he makes his own energy drink and has perfected the recipe over the years. Most of the benefit for a fraction of the price – this immediately piqued my interest!

I’ve tried this recipe 3 times now (each batch makes ~48 bottles) and I’ve been very pleased. I’ve also sent this to our Cross Country team and many of them have tried it with positive results. It’s important to emphasize especially to young runners that although water is great, in the summer it’s oftentimes not enough. (Interesting side note – when I first sent this out to the team, I’m pretty sure we singlehandedly affected the local lime market temporarily.  We’ve got a large team!)

Here’s the recipe (with Keith’s permission):

  • 2 cups honey
  • Juice from 12 limes – I also include a lot of the pulp
  • 1/3 cup salt

Combine the ingredients in a used mayonnaise or peanut butter jar, top it off with a little water, and put in the freezer. After a while it gains a slushy like texture, less so if you add less (or no) water.

When you’re ready to make a bottle, put 3 tablespoons of the mixture in the bottom of the bottle and fill the rest up with water. It might taste a little salty at first but I quickly got accustomed to it.

One tip – I reused the same old peanut butter jar and I used a sharpie to mark the 2 cup line so I can easily fill the honey to the line without wasting a lot of it by having to use a separate measuring cup.

  

Have you tried this or something similar?  Do you have any suggestions for the recipe?  I’d love to hear them.

 

Supposed Economic Benefits of Greenways

(I support greenways where they make sense.  In fact, I’m on the Greenways Commission for the Town of Carrboro.)

You don’t have to look hard to find outlandish claims made in support of various causes these days.  For example, see Trump’s “Trade wars are good and easy to win” claim.  Occasionally though I come across something so egregious that I just can’t let it pass without commenting.

The NC DOT funded a three year study to quantify the economic benefits of shared use paths (SUPs a.k.a. greenways).  Their conclusion?  For every $1 spent in trail construction (once), $1.72 is generated ANNUALLY.  That’s a pretty amazing statistic.  Let that sink in for a minute.  Is that really possible?  If someone claims they can easily make a 72% return on your money every single year, do you respond with healthy skepticism?  You should!  This is being reported as a return on investment.

Which SUPs Should We Look At?

Let’s take a look at the study and see how they arrive at these numbers.  Of course you can’t do a detailed study of every SUP in North Carolina, so you have to choose a sample that’s representative of all SUPs in NC.  So how did they decide which SUPs to study?

The shared use paths studied were selected
because they:
• Have a state or regional significance.
• Have good opportunities to capture
economic revenue.
• Were not impacted by construction,
significant maintenance, or detouring
during the project period.
• Are relatively ‘established’ (i.e. at least
5 years old with minimal adjacent
land use changes anticipated).
• Have the ability to demonstrate a
transportation function.
• Are geographically dispersed across
North Carolina.
• Are a good mix between urban and
rural areas.

In other words, they picked ones that they could use to show maximum impact.  You literally could not pick 4 SUPs that would show a better economic result.  Not a choice I would have made but I get it.  Just one page into the study and you can see where this is heading.

Gathering Data

They got several people together and went to each SUP and set up a survey station.  This required 187 people across 3 years.  They visited some SUPs just once and others every year.  So it’s easy to imagine the situation – you’re running or biking along the SUP and you come across some friendly people asking you if you want to fill out a survey.  Of course you can’t force people to take a survey so some choose to do it, some do not.  Having spent a lot of time exercising on paths and greenways, I can imagine the type of person that on average would take a survey and, on average, would choose not to take a survey.  The people that choose not to take the survey are on average more likely to be working out and not willing to stop.  Of course these trips don’t generate any income at all.  Excluding these SUP users are good for the final numbers!  Pretty convenient!

Questions on the Survey

The survey actually looks pretty good.  They ask some good questions and it’s pretty thorough.  Race, gender, salary, how many people in the group for this trip, how long is your trip, transportation type – all reasonable questions.  They also ask how much money they’re going to be spending on this trip and how many trips they typically take.  They use this to produce tables like this one – which breaks down expenditures by type and transportation method:

This seems fine, but as I look closely at I notice that runners sure are buying a lot of groceries!  11% of the 663 users that were running are spending $41 per trip on groceries.  18% are running to and from a restaurant to eat.  4% are on their way to buy some consumer products at $97 per trip at retail.  All in all, 35% of all SUP users who are running are doing so to go spend some money.  That seems extraordinarily high!

A Useful Result: SUP Users are Rich and White

I did learn one interesting thing from the survey results.  SUP users skew overwhelmingly rich and white.  The second largest income bracket for users is >$200K.  About 75% of SUP users earn above the US median household income of $59K.  This is not something I’d thought much about before but it makes sense.  I would have like to have seen an income/race breakdown by transportation type.

Users are overwhelmingly white at 83%.  This number might not sound too skewed until you consider the fact that this SUP is in Durham where 37% of the population are people of color.  I never realized that SUPs were this much of an amenity for the rich.  But, hey, this is also convenient for the purposes of the desired outcome of the study!

Other Economic Impact Results Touted

The infographic at the top of the post touts not only the amazing “spend $1 now and get $1.72 annually forever” statistic.  There are other stats that are asserted.

“A one time $26.7M capital investment in the four greenways” – ok first of all this number has to be way lower than the actual cost of the greenways.  I expect the land alone probably costs that much.  There’s obviously something I’m not understanding about that number.  The implication is that $26.7M is the total cost of the SUPs and I just can’t believe it’s that low given how many bridges are on the ATT and how expensive bridges typically are.  For example, in Carrboro they spent $1.3M on a quarter mile of greenway with a bridge in it.

“$48.7M in estimated business revenue from greenway construction” – a one time $26.7M investment produces $48.7M in business revenue from greenway construction?  Does that make any sense?

“790 jobs are supported annually through greenway construction” – this is truly an amazing statistic that seems so absurd that it doesn’t deserve a response.

If These Stats Are Correct, What Does that Mean?

If you really can spend $1 and get a $1.72 annually, then it would make perfect sense to cancel all of North Carolina’s public projects and simply build SUPs everywhere.  Sure there would be decreasing returns the more we built but there’s a tremendous amount of room to play with.  Even a 4% annual return would be excellent!

The fallacy of the study is that it implies that the greenway creates the economic activity.  It does no such thing. One category of SUP users made trips to restaurants.  If the SUP didn’t exist, would those people starve?  Would the $1.72 instantly evaporate if the SUP went away?  No – people would quickly find alternatives.

A good question you should always ask yourself is “compared to what?”  Imagine we used this same methodology to evaluate the economic benefits of a road through a similar study.  We survey people that drive on the road.  Where are they going?  How often do they use it?  There are a lot more road users per square inch of road than a SUP – it’s pretty easy to see that the $1.72 number would be DWARFED by the same number for a road.  A lot of people use the road to drive to work.  Do we say that the road created that job?

No that would be absurd.

I wonder how much we paid for this study – it makes us all look silly and probably ultimately shows more evidence against a greenway than for it.