My Daily Data

Nearly a year ago I put up a link to my commuting data, then only with a couple months of information.  Now I offer an update: click here to open the Excel spreadsheet.  It was prepared in Excel 2010, but I think 2007 can also open it... those with older versions will have to get Microsoft's converter and hope it works properly with the spreadsheet.  Click "Enable Editing" to be able to play with the charts.  You can also view it in Google Docs (which is where I'm hosting the Excel file), but Google converts it quite woefully... the Excel version is strongly encouraged.

The first sheet plots my commute during my year of traveling to Greenbelt.  The cooler-colored lines are transit; the warmer lines are driving.  You can use the checkboxes to toggle each mode, of which my driving has been broken up into three segments: roughly the Beltway & BW Pkwy (MD), NY Ave east of Florida (NY), and NY / Mass Ave west of Florida (DC).  You can see I tried the bus between the Metro Station & my office a few times, but soon gave that up when it often took longer to go by bus than to walk.  I also gave up transit altogether once cold weather set in, and once warmth returned: construction on NY Ave made my commute better and I ultimately stuck with driving.  Only a few times did I have much issue on the rails, and even on the worst of days it was just a couple minutes more... whereas you can see that my worst days on the roads were far less pleasant.  There was one day where I'd made it halfway via transit when I remembered I needed my car for a meeting... that's the trip that tops 80 minutes.

The second sheet plots my current commute out to Merrifield.  It uses the same color scheme, but I deleted the car data as I haven't driven it yet (nor do I intend to).  The two car-related items are just me moving my car per street-sweeping schedules... though I failed at that at one point, paying $30 to the city for the privilege of not having to move my car for another week.  That's one problem of going car-free: you can forget you have a car.  If you turn on the "DC Walk" time, you'll see that there are two days without an input... I diverted quite heavily from my usual route after passing McPherson & didn't tally the walking time on those days.  There are also several omitted entire days where I diverted before reaching McPherson.

The third sheet displays data on train cars I've ridden & their temperatures.  There's not too much data yet as I haven't been on this commute too long yet (it feeds off the same data as the previous sheet to/from Merrifield).

Next up is my personal health since 1 June 2010 -- the first day I moved into DC.  It tracks numerous variables... weather is somewhat self-explanatory: higher values indicate lovely weather.  Snow can throw it off a bit as I rate snow rather highly... nuts to folk who fear trudging through it; I look forward to that every year!  Body tracks various variables in my physical form each day as well as several personal grooming factors.  Sleep is also pretty self-explanatory... it's at its peak in the 6-8 hr range and loses points if I get more or less than that.  Diet tracks breakfast, lunch, dinner, and snacking on whether they were healthy or unhealthy meals.  Exercise looks at a slew of different physical activities from each day.  Lastly, Net is just the average of any data sets currently turned on.

The last sheet tracks how much I walk each day.  It's kind of thrown off by a huge surge owing to my recent vacation... my hobbies are rather introverted back home, but abroad I become an outdoor hiker & city explorer from awakening to when my muscles finally give out.

Enjoy!

0 comments:

top