Studio711

Gadgets

Truck Stats

Last year, Tyla got me an OBDII data logger (Automatic) for my birthday and, of course, I ended up writing an app to download my trip data so I could analyze it. I still get those analysis reports twice per day and they continue to be interesting. For example, I don’t know why, but the last two weeks have had some of the worst traffic on my way home from work in the last year. Now that I have over a year of data, there’s enough to calculate some semi-interesting stats on my drives in our 2016 F150 3.5L Ecoboost:

    • The average trip to work takes me 26.3 minutes.
    • The average trip home takes me 33.9 minutes.
    • It feels like if I leave work a couple minutes early, I’ll avoid the worst of the traffic. Here’s my average commute time based on when I leave. (The x-axis is in 24 hour time so 17 is 5pm.) The y-axis is my average commute home in minutes. It does look like if I leave about 10 minutes before 5 my commute is generally 5-10 minutes faster.
    • My most fuel efficient trip was a 43.7mpg drive along the 3.5 mile route from my house to Home Depot. Not bad for a 5000 pound truck! (A lot of it is downhill and I like to see how little gas I can use on that route…)
      • Best fuel mileage for a trip over 10 miles: Church to Totem Lake AutoZone 28.0mpg
      • Best fuel mileage for a trip over 50 miles: Crystal Mountain to our house 24.7mpg
    • My worst gas mileage is going from Work to the butcher. It’s a short trip and when it’s really cold, my truck spends the whole time idling at stop lights and trying to warm up. I’ve gotten 3.5mpg on that route a couple times!
    • Of the days that I drive the truck, I spend an average of 69.3 minute driving.
    • The most driving in one day was 366 minutes. That was May 25, 2018 when we drove down to Ocean Park for Memorial Day.

I love having all this data! I could do this all night but I should probably cut it off here and go to bed. By the way, all of these charts and stats were created with public preview of Azure Data Explorer. We’ve been using that product internally for a couple years and it makes stuff like the stats above ridiculously fast and easy. If you’re at all involved in data engineering or data analysis, you need to get familiar with Azure Data Explorer!

Standing Desk Monitor

We have nice standing desks at work. They have electric motors with memory settings so it’s quick and easy to switch between standing up or sitting down. I believe that it’s significantly healthier to stand up at least part of the day, but I find myself being lazy and sitting for most of the day. I also know that it’s relatively easy to motivate myself by measuring whatever I’m trying to improve. Time for a project!

To measure whether I’m standing or sitting, I decided to use a distance sensor that either sits on top of the desk and looks at the floor, or sits on the floor and looks up. I’m sure there are cheaper ways to do this, but I ordered a SparkFun BlackBoard, Distance Sensor Breakout, and a Qwiic cable to connect them. There was no soldering required. I plugged it all in and I was good to go. I laser cut a wood box to hold all the components.

I wrote a simple program for the Arduino-compatible BlackBoard that would send a measurement when it received a keystroke and then I wrote a program that runs on the computer to periodically request measurements (via USB) and upload them to a database in the cloud. I put a website on top of the page and voila!

A friend at work heard about the idea and wanted to compete with me so now we are both running these devices. You can track our progress at http://standupweb.azurewebsites.net/

Goodbye Comcast TV

I grew up with an antenna on top of our house. We could get some channels from Chicago in addition to the local channels so we had a pretty good selection. But I still remember going to college and having CABLE TV. I was in awe of ESPN. I’ve had cable ever since then, but since Elijah was born our TV watching has gone way down and most of it is via Netflix or Amazon Prime. So last week I took the plunge and totally canceled my TV service.

It wasn’t quite that simple though because we host football parties at our house so I need some way to watch local broadcast stations. I went to antennaweb.org and picked up one of the antennas that they recommended for my location. I mounted it up in the rafters of my garage pointing the direction recommended on the site. The picture looks beautiful! Unfortunately, some of the channels have small glitches every few minutes. But I’m still going for it.

Our cable TV plus 150Mbps internet was $82/month. When the annual contract ended, it jumped up to $98. I really didn’t want to sign another contract that included TV since I’ve been thinking about canceling for so long, but I don’t mind signing a contract for internet since there aren’t many other options around here. I did drop our speed down to 60Mbps to save even more money. I signed a contract that locks in the price at $45/month including fees, etc for 2 years. So even if we go back to cable TV in four or five months, I’ll still come out ahead with the hardware that I purchased for the antenna solution.

And here’s a breakdown of that hardware…

That tuner purchase was a surprise. I forgot that the InfiniTV card in my Media Center PC doesn’t have an ATSC tuner built in (that’s the over-the-air signal format.) Thankfully I was able to find the older model of the HD Homerun for a pretty cheap price. It hooked up just fine to the Media Center PC. I also played around with the DVR/Live TV features of Plex but I was frustrated that I couldn’t watch a show while it was recording. I’m sure that will come along eventually though. Once it does, then I can ditch the separate PC I have just for running Media Center.

So what happens if we’re having a football party and the signal is too glitchy? Thankfully, there are plenty of online cable providers that I can flip on in just a few minutes. In my area, most of the Seahawks games are on FOX and only DirectTV Now and Comcast Instant TV currently have my local FOX affiliate. So I can sign up with them and be back in the action very easily. The Comcast offering is interesting because it’s only $18/month and includes all the local channels that I’m interested in. The Cloud DVR from the Comcast service was a mess to figure out, but I finally realized that you can only schedule recordings from the Roku app. I think that’s due to a patent war that they lost with Tivo which made them remove any kind of browser or phone DVR scheduling. I get why it is like that, but they are definitely not forthcoming about that limitation.

Yada yada yada, now I’m saving ~$50/month and it feels great!

Dash Cams for the F150 and Escape

Whenever I hear about dash cams, I think about people in eastern Europe or Russia recording meteors and crazy crashes (the audio of some of those videos is probably NSFW.) But then I was at a party for one of Elijah’s classmates and a King County detective was talking about how he was installing dash cams in his car and his wife’s car. Huh? It turns out that there are groups of people who travel around the country basically putting you in a situation where you have no choice but to rear end them. With no evidence, the person in the rear is generally at fault because hey, you should have stopped. He said that Seattle is swamped with this stuff right now.

It’s highly unlikely that will ever happen to me, but you know how much I already enjoy doing timelapse video, especially on road trips so having a camera mounted nicely in the car was appealing. The fact that it might come in handy some day for insurance purposes was enough to push me over the edge.

I started with my truck and was lucky enough to find a video showing the camera I wanted being installed in a truck very similar to mine. It was super handy to see where the fuse box was, how to get the various pieces of molding off, etc. Here’s what I ordered:

While Dad was visiting, we got it all installed in my 2016 F150 without too much hassle and it has been working well. You can check the Amazon page to see samples of the video quality, but it’s plenty good for what I want. The camera itself works nicely and is low profile, especially compared to some of the other big suction cup versions. The wire exits the camera and is hidden all the way down to the fuse box so there isn’t anything dangling down or plugged into my cigarette lighter.

It went well so I decided to install the same setup in our 2013 Escape. The only difference was that the Escape used mini fuses instead of the micro fuses that the truck uses. Installation there was a little more tricky because of the goofy shape of the plastic around the rear view mirror, but I found a good spot for it and was able to run the wire down to the fuse box under the glove box. I can get free access to the Chilton’s website via our library and that came in handy for figuring out how to remove a couple pieces of trim. I also stumbled across a YouTube channel devoted to the 2013 Escape which will come in handy in the future.

I’m excited to go on a road trip and use this instead of the hacky/messy/annoying GoPro setup that I used to use. With the 64GB card, I could record 11 hours of 1080p video or even more than that if I use the timelapse mode in the camera.

In other countries, insurance companies offer discounts for dash cams, but that hasn’t been popularized here yet. Even without the discount, I do wonder if/when car manufacturers are going to build these in. It’s not a big stretch to imagine this as part of your rear view mirror mount or maybe even using some of the parking cameras that are already installed.

OBDII Trip Reports

OBDII is the standard for the diagnostics plug that is somewhere around the drivers side footwell of your car. For many years I’ve enjoyed having a ScanGauge in my car, and then for my birthday this year, Tyla got me an Automatic OBDII reader. That has been plugged into my truck for a few months, happily uploading data to the cloud.

I finally got around to playing with their API. I wrote an app that runs twice a day on my computer. It calls their API and pulls down any recent trips that I’ve made. It looks for a few places that I’ve labeled (Home, Work, Safeway, etc) and looks for trips that start and end in a named place. If it finds one, it looks how that trip ranks in terms of fuel usage and time. Then I get an email showing me my “score”. It’s a fun way to see if my fast trip to work really was my fastest trip ever, or how that extra bad stop and go traffic affected my fuel usage.

The email is pretty simple right now. I keep thinking that I’ll make it fancier with some charts, additional stats, etc but so far this has been good enough. I think the next thing that I will add as I get more data is a breakdown to show the score for all time, the current month, the day of the week, etc.