Studio711.com – Ben Martens

USB Power Meter

usbpowermeterHave you ever wondered why your phone charges more quickly using some power adapters than others? Some adapters can provide more amps than others. Most standard USB ports provide 0.5 amps but most phones and tablets these days will make use of 1 or even 2 Amps.

When we travel, we carry a small Belkin surge protector with built in USB ports. It has been really convenient, but on this last trip, I noticed that the phones charge really slowly with it. After a little reading, I realized they were only 0.5 amp USB jacks.

Amazon says they have a version that will do at least 1.0 amp to each jack so I ordered that one. When it arrived, I tried it out but wasn’t sure it was really doing what it should. I did some searching and learned that there are USB power testers so I picked one up. Indeed, the new Belkin charger was not providing the power that the description claimed it would so I shipped it back.

I ended up ordering a 5 port USB charging hub that has more than enough power to charge all our devices at full speed. We’ll throw this in our travel bag and be speedily charged on future trips.

iVac Switch Review

ivacMy simple shop-vac dust collection system works very well for my small shop, but one annoyance is turning the vacuum on and off every time I turn a tool on and off. I finally bought an iVac switch and my only regret is not buying it sooner. You plug both your vacuum and your tool into this switch. Whenever your tool turns on, your vacuum will turn on. When you turn the tool off, the vacuum runs for another 3-5 seconds and then shuts off. It’s incredibly convenient.

It has two plugs so that you can source power from two different electrical circuits. This would be useful if the tool you are using takes around 15 amps. You’d blow the circuit if you turned on a shop vac too. I don’t use that feature yet but I like knowing that it exists.

There’s a switch on the front that lets you choose from Auto, On, or Off so you can still flip the vacuum on without a tool or stop it from coming on when you turn on a tool. The whole thing seems simple but it’s very well-designed.

Now I don’t have to reach under my bench to flip the vacuum on and off. I can hide it away and let this magic switch do the work.

Car Buying Process

2016f150magneticgrayI’m pretty sure that I don’t buy vehicles like normal people. I also think that the current dealer sales model exists because people don’t share information about their car buying ideas. So I’ll do my part to share some info. I’m definitely not saying this is the right/best way to do it, but if you’re thinking about buying a car and you’re masochistic enough to read this whole post, maybe you’ll find a tidbit or two that are useful.

First of all, let me say that I think it’s ridiculous that in 2016 I have to talk to a middleman to buy a vehicle. I can completely build out my vehicle on Ford.com. Why can’t I be given a fair price there and purchase it? I get that we need dealers to service vehicles and they could also provide test drives and be an escrow service and/or a bank loan service, but it’s very frustrating that I have to haggle with a bunch of dealers to get a good price when everybody is selling the exact same thing. The whole business model seems antiquated. That being said, you can still work the model to your advantage but it takes some extra effort.

Before I dive into the process, let’s make sure we are clear on some terminology.

  • MSRP: This is the “sticker price.” It’s what you see if you build a vehicle on the Ford website. Nobody should pay this price.
  • Invoice or Dealer Invoice: This is what the dealer pays to Ford to get the vehicle. Some dealers will try to argue that they can’t go below this number or they will lose money. If somebody tells you that, walk out of the door. You don’t want to deal with someone who lies to your face.
  • Dealer Holdback: Ford periodically sends dealers a check that equates to 2-3% of the invoice price for every vehicle they sold. Why? I don’t know. But if you negotiate well, you can dip into this money to get below invoice pricing.
  • A/X/Z plans: Ford offers special deals for employees, family members, affiliated companies, etc. As the nephew of a Ford employee and also through my company, I’m eligible for the X Plan. This roughly equates to invoice pricing. You walk in and get a flat price with no negotiation and that price is pretty good. The A Plan is the best deal. It equates to invoice minus holdback.
  • Dealer discounts: These are bogus as far as I know. It’s a “discount” that the dealer gives you. But in reality they just start with a higher price and then give you the discount off of that. The discount is never going to get you below invoice minus holdback.
  • Factory rebates/incentives: This is money that Ford pays back to you for buying a vehicle. It could come in the form of low interest loans. With these rebates, you CAN go below that magical invoice minus holdback line. Don’t include these in your negotiations. These are exactly the same for every dealer and they don’t cost the dealer a dime.

I started my detailed research back in September. I found a couple forums that focused on the Ford F150 because I knew that’s the truck I wanted to buy. The best one I found was f150forum.com. That place is a gold mine of information about F150s. The most useful things I found were the official order guide and price sheet for the 2016 F150. This was key because it let me know the invoice pricing was for the exact truck I wanted.

I knew I could fall back on the X Plan but I wanted to see if I could beat it. There were a large number of people in the forum getting trucks for ~$500 under invoice and even a few getting it for $1000 under invoice. The holdback on my truck is somewhere around $1500 so I knew that was my absolute bottom line.

The forum taught me that there are three fees that you can’t avoid: Destination, Fuel, and Advertising Assessment. Some dealers might say they aren’t charging you for them, but they have to pay those fees so they’re just tacking on more money to your price somewhere else. It’s all part of the invoice price so stick to invoice price as your negotiation point.

That order guide also alerted me to the fact that the Heavy Duty Payload option that I wanted was not going to be built until the first quarter of 2016. That meant there was no point in being in a rush and I also shouldn’t expect to get my truck until summer. In a good scenario, it takes 10 weeks to get your truck from the time you place the order. Add on some delays and the delayed start to production and I’m looking at a long wait.

The forum also taught me that it was customary for dealers to ask for a $500-1000 deposit when you order a vehicle. This gives them a bit of protection in case you order a weird configuration and then decide you don’t want it. You forfeit that deposit and they can now pass that money on to the person who eventually buys it in case they need some extra bargaining room to offload a weird vehicle configuration.

I put the shopping off until after Christmas, but when the New Year rolled around, I had the final conversation with Tyla and then we moved ahead.

We didn’t have a great experience with Ford of Kirkland when we bought the Escape. The overall dealership was fine but our sales guy was the stereotypical car salesman. I wasn’t eager to chat with him again so I reserved that dealer as my X Plan dealership. You’re not supposed to haggle and THEN pull out the X Plan so if I wanted to use the X Plan, I’d just walk in the door fresh and ask for it.

I did a search for all the Ford dealers in about a 1.5 hour radius. My first contact, for no particular reason, was Harris Ford. I wanted to get one quote in hand to make sure that everything matched up with my expectations before blasting off to a bunch of other dealers. After waiting two days and hearing nothing, I sent the same thing to Evergreen Ford. My phone rang immediately and within an hour I had a quote in my email complete with invoice pricing listed. They quoted me $700 above invoice. I knew I could beat that but it was a starting point.

With that quote in hand, I contacted eight more dealers. Unfortunately, not all of them had their act together. For example, it took Harris Ford 6 days to finally contact me. Marysville Ford never replied to me. Lots of the dealers appeared to be using the Motosnap CRM (Customer Relationship Management) tool to handle incoming customer contacts. Lots of dealers also appeared to have very little idea how to use the tool correctly. I got lots of duplicate emails listing different sales people from the same dealer who were supposed to contact me, letters from the manager asking if I was happy with the service even though nobody had contact me, and lots of other goof ups like that. Pretty much every dealer except Evergreen Ford and Autonation Ford Lincoln Bellevue should do a very detailed audit of how well their employees are using the CRM tools. It’s a mess and very quickly gave me the impression that a dealer was old-fashioned and didn’t understand the internet. I was focused on dealers who were happy to converse over email because it was so much easier to organize emails than voice mails.

After the dust had settled, the Bellevue dealer was in the lead. He STARTED with a quote of $500 under invoice. That guy got it. He knew that I was a savvy internet shopper and knew that I’d be getting quotes for somewhere around, or just above, invoice so he started low. Honestly I still feel a little bad about not ordering from him. But because I had started with Evergreen Ford and they had scheduled a test drive for me the following weekend, I had started to build a relationship with them too. I also respected them because they were the only dealer to show me the invoice pricing along with their quote.

Before the test drive, I told my contact that I’d be coming in with my wife and a 2 year old and that I only had about 30 minutes to spend at the dealer before we had to go to another appointment. We almost walked out because their morning sales meeting ran late, but in the end, I stuck around to see how he would react to the delay. Once I saw his reaction, I was glad I waited. I felt like he was honestly thrown off his game and on the defensive. It was a good spot for me so I stuck with it.

We hurried off after the test drive because we had to, but I think it was a good negotiation tactic anyway. Dealers hate to see you walk out their doors because it’s so easy for somebody else to sell you the exact same thing.

Via email and phone later that weekend, I got them to beat the Bellevue price by $100 so it was a total of $600 under invoice. Pretty much every dealer I talked to said “Call me at the end and I’ll beat any price you have.” That bugs me. Just give me a good deal from the beginning. The problem is that no dealer wants to lose a sale for $50 or $100. Well, I didn’t want to keep shopping around and before I got the $600 quote, I said if they gave me that price, I’d stop shopping. So I held to my word and happily ended the process. Could I have shopped it around for another hundred or two in savings and left lots of angry dealers in my wake? Yeah, but I don’t have the stomach for that. My final price was part way between the X Plan price and the A Plan price, right in the sweet spot of the target I set out before this began.

From that point it was easy. I walked in, signed the order form to verify that they were ordering the right options, paid my $1000 deposit and then began the long wait. The only other thing I did was get it written in an email that they wouldn’t automatically tack on any of the dealer extras and then try to charge me for them (like paint protection, theft recovery systems, etc.) Some of the sleazier dealers will do that at least for their cars on the lot.

Once the order makes it into the system, I should be able to track it myself without bugging the dealer. That same F150 forum also has instructions for how to use the Ford Order Tracking system to get extra information about your build.

So what are my summarized pieces of advice?
1. Know the invoice price for your vehicle before you talk to anyone or at least demand to see it as part of your quote.
2. Talk to at least two dealers so you can have some negotiation leverage. Negotiate in terms of the invoice price. Don’t include factory rebates or incentives in the discussion.
3. You can and probably should consider doing all of this from home over the internet and the phone. So many of the sales man tricks only work once you’re sitting at their desk and they know you can’t talk to other dealers.
4. After you’ve got that locked in, THEN you can talk about your trade-in value. And after you get that locked in THEN you can talk about service plans, etc. Don’t let them try to do all those numbers at once because they’ll take money off one and hide it in another place. At that point it’s like trying to squeeze a fat man into tiny pants. No matter where you push, something always pops out.

What would I do differently next time? I think instead of just asking all those dealers for quotes, I would also tell them that I’m blasting out the quote to however many dealers and say that whoever gives me $1000 under invoice first will get my business. That would save all the back and forth about “Call me and I’ll beat any deal”, and if nobody wanted to play ball then I could still go back with a higher offer. That also gives everyone an equal chance and doesn’t favor people who contact me first, give me a test drive, etc. It’s probably a lot faster than what I did too.

If you’re curious exactly what I ordered, here are the specs:

  • 2016 Ford F-150 XLT SuperCrew, 6-1/2′ Box, 3.5L V6 EcoBoost® Engine, 6-Speed Automatic Electronic Transmission w/Tow/Haul Mode, 4X4, 3.73 Electronic Locking Axle
  • Exterior: Magnetic
  • Interior: Medium Earth Gray
  • Seating: Bench
  • Equipment Group 301A
    • Fixed Backlight with Privacy Glass and Defroster
    • 8-way Power Driver’s Seat (Power Lumbar Driver/Manual Lumbar Passenger)
    • 4.2″ Productivity Screen in Instrument Cluster
    • Manual-folding, Power Glass Sideview Mirrors with Heat, Turn Signal, Auto Dimming Feature (Driver’s Side) and Black Skull Caps
    • Auto-Dimming Rearview Mirror
    • Leather-Wrapped Steering Wheel
    • Rear View Camera with Dynamic Hitch Assist
    • Power-Adjustable Pedals
    • Rear Under-seat Storage
    • Class IV Trailer Hitch (incl. Smart Trailer Tow Connector, 4-pin/7-pin wiring)
    • SiriusXM Satellite Radio (7 Speakers)
  • Heavy Duty Payload XLT
    • 3.73 Electronic-locking rear axle
    • 9.75-inch gearset
    • Upgraded springs and auxiliary transmission oil cooler
    • 18-inch Silver Aluminum Wheels
  • Max Trailer Tow
    • Auxiliary transmission oil cooler
    • Integrated Trailer Brake Controller
    • Upgraded front stabilizer bar
    • Upgraded rear bumper
  • Off Road Package
  • SYNC 3
  • Navigation
  • 110 Outlet
  • All weather floor mats

Features are definitely a subjective choice. The nice thing about ordering your own truck is that you can get exactly what you want. I chose to spend my dollars on the hauling, towing and off road capabilities of the truck rather than for interior creature comforts. Yes, I live in a subdivision and no, I won’t need to haul a ton of rocks very often. But I feel like I’m less likely to regret buying a truck that can handle a lot of situations safely than I am to regret not having heated leather seats.

You’ll notice that I did spring for Sync 3 and the Navigation package though. After being underwhelmed with the My Ford Touch Sync 2 in Escape, I was all set to save some money and skip it in the truck. But Sync 3 is a completely new system and it looks like a lot more of what I want in a car computer. Specifically, it puts a lot more of the workload onto the phone which can be upgraded and replaced a lot easier than the truck. It will be support Android Auto next year and we’re probably switching to Android at the end of this year so that will work well for me.

I hope to have this truck for a very long time and make a lot of good memories with it. I’m looking forward to using it to haul bikes to family bike ride spots, go camping, and explore mountain roads in addition to more regular tasks like hauling things to the dump and buying wood. I’ve never owned a truck as a daily driver so that part makes me a little nervous but I’m pretty confident that this is a good decision.

You’ll probably hear a thing or two about this when it arrives my house this summer.

Indiana Christmas Video

While we were in Indiana, we took a lot of video with the intention of making a Christmas movie. That’s all been edited up and is now ready. Dad’s tractor shows up a ton in this video, but it honestly did get used a lot during the trip: rides for the boys, rescuing the girls who got stuck in the car on the driveway in the snow/ice, plowing snow, and moving trees that had fallen during the storm. There’s also a clip of Dad putting the tractor into their brand new garage/shop for the first time! For 30 years he’s had to tarp and un-tarp the tractor before every use, deal with mice chewing cables and haul the tractor battery in and out of the house. It’s so much easier now!

Disaster Planning: Passwords

disasterplanHow many times have I written about making sure you have a good backup plan in place? I’m too lazy to look, but it’s a lot. I’ll summarize on the off chance that you don’t remember the plan:

Imagine that at this exact moment, your house explodes in a giant fireball. Nobody is injured but all of your computers are obliterated. Did you lose files? If the answer is yes then you’ve failed. Luckily, the remedy is very easy: sign up for an online backup service and run it on all your computers. I like crashplan.com but there are lots of other options. If you’re running that, no matter what happens to your physical machines, you can still get your files.

I saw two data loss situations happen in December and it reminded me of another thing to think about. Dad, I’ll use you as an example since it has a happy ending.

Dad has a good backup strategy in place. It’s not cloud backup because they’re in a limited bandwidth situation, but he does a good job with a physical offsite backup solution. While I was home at Christmas, his main hard drive died. The first thought is “Whew, at least I don’t have to worry about data loss.” But then when he went to restore from his backup drive, he realized that he didn’t (right away) remember his BitLocker password. The whole drive was encrypted so it was only useful if he had that master password. Thankfully he was able to get it and everything went smoothly from there.

But this is a good opportunity for us evaluate our own backup strategies. If you lose all your computers, can you still access/remember all your passwords? In our house we use lastpass.com, but there are other options. I’ve written about LastPass before. It’s a free tool that securely stores all of your passwords online and then you have one (very strong, very long) password that you use to access those passwords. I won’t go into details here, but it’s impossible to hack your account unless someone is able to guess your password. Tyla and I both know that master password so even if our house blows up and I’m in it, she’ll still be able to get to every password that we have.

Disaster planning can seem like a daunting task but if you just use a couple services (crashplan.com and lastpass.com), you’ll be covered in a huge range of situations.

Family Sign

I’ve had a couple laser cutter project posts recently, but the real reason I learned how to use it is because Tyla wanted a family sign. She found some on Etsy that she liked but we didn’t like the prices. My first thought was to cut them out on the bandsaw but I quickly realized that would take forever and I wasn’t sure I could cut out the smaller letters.

The laser cutter made quick work of the letters and then it was just a matter of painting them and painting the backing board. It has been really cold and wet around here but I managed to get it all done and assembled.

The dimensions on the sign came out as planned, but it feels pretty big now that it’s in place. It’s growing on me though. The nice thing is that this was made out of scrap wood with only a few hours of work. Most of the time was just doing the painting and letting that dry.

You can’t see it in the photo below, but the letters are made out of 1/8″ wood so they are raised up from the backing board. It’s a nice 3D effect and gives really crisp lines.

familysignoverdoor

Indiana Trip

Tyla, Elijah and I flew back to Indiana for Christmas this year. Leading up to the trip, we had visions of a relaxing white Christmas with lots of fun activities. It was definitely a memorable trip, but it was not what we had expected!

It was over 60 degrees the first day so there was no snow for Christmas. Soon after we arrived, Elijah started throwing up and that lasted a few days. And on the last days of our trip, we had a freezing rain/sleet/snow storm that knocked out power for 3 hours, snowed us in for an afternoon, and took down three trees on the driveway. We had to saw our way out.

Still, with all that going on, we had a great time. Elijah’s sickness had a pretty big effect on our activities and even going to church as a big group, but there were plenty of smiles to go around. I was very thankful that we were at Mom and Dad’s house for Elijah getting sick like that. I kept imagining how much harder it would have been if that had happened on our trip to San Diego or something like that.

Dad has the new shop all buttoned up on the outside. The doors are in, the siding is up, and while we were there, he parked his Allis Chalmers in the garage for the first time! After 30 years of storing the battery inside and putting a tarp over the tractor every time he was done with it, this is really a game-changer! There’s still a lot of interior shop work to be done, but I’m glad he was able to get the exterior done before winter hit.

We took a lot of video while we were there with the intent of making another Christmas movie. That should be posted soon, but until then you can check out some photos.

indiana2015_08

indiana2015_01

indiana2015_02

indiana2015_03

indiana2015_04

indiana2015_05

indiana2015_06

indiana2015_07

Seahawks Skyline Cutout

There are some pretty cool custom Seahawks signs floating around Etsy and local craft fairs. I decided to try making my own on the laser cutter. I spent a bunch of time in Inkscape modifying/drawing a logo. I don’t take much credit for the design. It’s largely a copy of other ones that I have seen, but I’m really happy with how this one turned out. It can be cut at any scale but this one is a little over 20″ wide.

seahawkswoodsign

Fantasy Football Super Stats

fantasyfootballstatsI wrote a tool for our fantasy football league that checks the rosters twice a week and sends out emails if you having anyone starting a game who is injured, on a bye week, or just questionable. That, along with lots of effort from each coach, has made our league pretty good in terms of starting full rosters every week.

I started playing around more with the Yahoo API and realized that I could download stats for every game. Not just that, I could download stats for all nine seasons that we’ve had this league! Give a data scientist a fun data set like this and see what happens. None of the stuff I did is very complicated in terms of real “data science”, but it sure was fun!

First of all, I have some corrections to make to the table of records. One of these is due to a stat correction from Yahoo and the other is because Yahoo’s online interface didn’t let me go back far enough to see the old record. Here is the updated table with changes in bold. It turns out that Tim didn’t break the record for highest score in a game or the highest player score in a game.

This Week Season All-Time
Highest Team Score Ben had 151.18 Tim 200.51 (Week 3) Tim had 206.94 in 2008
Lowest Team Score Andy had 75.31 Andy had 41.29 (Week 14) Andy had 41.29 (2015)
Biggest Blowout Luke beat Andy by 42.02 Ben beat Dad by 111.43 (Week 8) Luke beat Andy by 113.02 (2010)
Closest Win Austin beat Logan by 16.44 Ben beat Andy by 2.46 (Week 7) Jim beat Ben by 0.12 (2012)
Highest Scoring Player Kirk Cousins had 40.20 as a free agent. Drew Brees had 58.30 on Tim’s bench (Week 8) Peyton Manning had 60.28 for Andy (2013)
Longest Active Winning Streak Austin has a 4 game winning streak. Ben had an 8 game winning streak (Week 8) Micah (2011) and Ben (2015) had an 8 game winning streak
Longest Active Losing Streak Jim has a 4 game losing streak. Andy had a 8 game losing streak (Week 14) Kyle had a 14 game losing streak (2011)

Ok, but that’s pretty boring. What else can we answer? How about who had the most points on their bench? Instead of just counting the total, let’s look at the percentage of the total team’s points that sat on the bench. This stat is mostly just a curiosity. You could have a lot of points on the bench because you started the wrong people or because your team was really strong.

Tim Scherschel 36.0%
Dallon Martens 32.4%
Ben Martens 32.3%
Logan Brandt 32.1%
League Total 31.7%
Luke 31.2%
Jim 30.9%
Austin 30.0%
Andy Daniels 27.6%

Which positions produce the most average points in a game?

QB 22.3
WR 13.2
RB 11.4
DEF 10.7
TE 10.1
K 8.3

I broke the all time record for most points in a season. But how does it compare to everyone else over the past seasons?

scoresbyyearbycoach

How does the average number of points per team vary by year? Does it all average out or is there more scoring in some years?

Which players have generated the most points since 2007 in our league?

Drew Brees 3089.66
Tom Brady 2940.34
Aaron Rodgers 2825.2
Peyton Manning 2602.78
Philip Rivers 2300.68
Tony Romo 2106.5
Ben Roethlisberger 2061.72
Adrian Peterson 2026.62
Eli Manning 1969.96
Matt Ryan 1900.98

Who were the top 3 players at each position in our league this year?

Tom Brady Ben Martens QB 410.94
Russell Wilson Luke QB 377.18
Cam Newton Austin QB 376.46
Antonio Brown Austin WR 296.93
Julio Jones Logan Brandt WR 287.70
Odell Beckham Jr. Ben Martens WR 264.00
Adrian Peterson Jim RB 232.40
Devonta Freeman Ben Martens RB 205.60
Doug Martin Dallon Martens RB 201.50
Rob Gronkowski Austin TE 216.94
Greg Olsen Tim Scherschel TE 186.30
Tyler Eifert Logan Brandt TE 152.40
Stephen Gostkowski Dallon Martens K 167.00
Steven Hauschka Tim Scherschel K 127.00
Mason Crosby Logan Brandt K 116.00
Arizona Dallon Martens DEF 200.86
Denver Ben Martens DEF 196.94
Seattle Tim Scherschel DEF 180.70

Who has had the easiest schedule for the history of our league?
Tim. Dad has had the hardest schedule. But really, they are all very similar. Nobody deviated more than 2% from the mean.

Who had the most close wins in the last four years? This is a count of the number of times that each person won by less than 10 points.

Jim 8
Andy Daniels 8
Logan Brandt 7
Tim Scherschel 7
Dallon Martens 7
Austin 5
Ben Martens 5
Luke 5

There are so many more questions on my list to answer, but frankly I’ve been spending a lot of late nights digging through this. Hopefully if I get this post out, I’ll stop for a while and go to sleep!

If you’re interested in this dataset, let me know. I can either ship it to you in Excel or I can give you access to the SQL database and you can run your own queries. I hope to keep it running next year as the season progresses. I think I’ll also be able to use it to generate the Weekly Awards table each week which will make my blog posts easier.

Thanks to everyone for a great season! Go Seahawks!

Custom Mario Coins

One of the first projects I attempted on the laser cutter was making some acryllic coins for my nephew. He loves Mario and I thought that it would be a good learning opportunity for me and something fun to maybe spark his interesting in making things.

The design is pretty simple. It’s just the Mario logo on one side and his name on the other side. I etched a circle around the outside of the coin on both sides. When I etched the first side, I also cut out the coin. Then I carefully flipped the coin over without moving the rest of the piece and cut the back. They weren’t perfect because there’s a little slop in that flip but they came out pretty well.

customcoins