Studio711.com – Ben Martens

Office 16

powerqueryexcel2016The next version of Office is now public. “But Ben, I already have Office and I hate buying new copies of it.” Never fear! Do you have an Office 365 subscription? If so then you get this upgrade for FREE. And if you don’t have a subscription, this is a good reason to consider it. Unless you have a single computer in your house and you never upgrade Office, the subscription is a great deal. You get five installs with free upgrades, 1TB on One Drive, and some other perks for  100/year. There’s no more worrying about whether or not the upgrade is worth it for you. Pretty slick!

I normally don’t get too worked up about Office upgrades, but I’m really excited about Excel 2016. You may remember that I spent the vast majority of my time at Microsoft on Power Query and the projects that led up to it. Power Query now ships as a core feature of Excel 2016! Click the Data tab and look in the “Get & Transform” section. It’s awesome to have my code running on hundreds of millions (or billions?) of desktops. I know that it’s not a feature that most people will use, but it’s still cool to be included.

Front Step Bench

Before we re-landscaped the front yard, we had some hedges that came up to the front step. They weren’t beautiful, but they provided a convenient place for deliveries to be hidden. Now that we’ve removed the bushes, packages sit on our doorstep in plain view. We’ve never had a problem, but I’d prefer to have them at least partially obscured.

I decided to build a bench to fit on the step. Packages can be left under the bench, and, if necessary, I could even add a piece of wood to one end of the bench underneath the seat to really block the view from the street.

I used a SketchUp design file that is all over the web. (Unfortunately I don’t know who gets the original credit for this design. If you know, please contact me and I’ll give proper credit.) The design made heavy use of mortise and tenon joinery. While this type of joint is a staple in furniture woodworking, I’ve never done one myself. This seemed like a good learning project.

My first thought was to build this out of cedar since that handles outdoor weather well, but the cost quickly added up as I did the math. Instead, I ended up with hemlock fir (also purchased at Home Depot.) It’s pretty neat what you can do with standard dimensional lumber if you choose cleaner sections of the boards, trim off the rounded corners and run it through a jointer. This whole thing only cost about $30 in wood and I have some pretty big cutoffs left.

The four posts were wider than the 1 1/2″ I got from the boards so I used one full piece and then glued on half of another piece to get 2 1/4″. It actually looked reasonably good bare but after it was painted, the seam was completely invisible.

The mortise and tenon joints took me a very long time to complete as I fumbled my way through them. My joints got better and better as I went through the project though. I used a drill press to cut most of the mortises and then finished off the corners with a chisel. The next time I do it, I think I’ll try a router instead to get a cleaner mortise. I got the tenons with the bandsaw and that worked really well.

I hemmed and hawed a bit about how to finish the project. I like the look of natural wood, but it didn’t really fit the look of the front of the house. Plus I thought that the bench might weather unevenly since the outer half will be more exposed to sun and rain than the inner half. In the end, I put on a coat of Kilz primer and then used the same color as our exterior trim. I had an old can of that from the previous owners and the computers at Home Depot were able to match it perfectly! When I took the paint in to be matched, I explained that it was our house color. The lady replied “Do you live in an Army barracks?” I had never noticed it before, but instead of just being a dark gray color, it does actually have some green in it. Maybe I hadn’t noticed because it’s used for the house trim and it’s always against a light brown color.

I’m happy with the end result. It’s held together almost entirely without nails or screws. I did use a couple screws and nails just to ensure that the bottom seat supports don’t come lose over time. That part was at a weird angle and I didn’t want to screw up a mortise and tenon joint at that point in the project. The screw comes in from the back so nobody will see it.

bench1 bench2

(In the last photo, Elijah is trying to take a picture of me.)

Great Washington ShakeOut

washingtonshakeoutWhat would you do if the ground starting shaking right now? How would you reunite with your family? How would you survive for a few days if the area infrastructure was messed up? Education around those questions is the target of the Great Washington ShakeOut taking place today at 10:15am.

Tyla and I recently purchased an earthquake survival kit which just amounts to a backpack loaded with three days of food, water, and some basic supplies. We also have a generator and a bigger cash of canned food in the event that we’re able to stay on our property but can’t get food from the stores. It’s all stuff you hope that you never have to use, but if you do need it, you’ll probably wish you had done more!

Check out the site for some good information about how to be prepared.

Fantasy Football – Week 5

2015week5_joshmccownThe Seahawks. Bleh. I hope they finish above 0.500. The first half looked ok but then things fell apart in the second half and ended with four consecutive punts. I just don’t see how they can plan around their non-existing offensive line for an entire game.

Our league got a little more spread out but we still have four teams tied at 2-3. Luke continues to look for his first win, but take heart Luke. You’re not the lowest average score and your average score is almost exactly the same as Dad’s and he is 3-2. Luke also has had the second toughest schedule to this point. I think the game of the week was Andy and Tim. Going into Monday night, Tim had a reasonable chance of winning his match with less than 70 points!

There are a ton of high profile injuries floating around right now so please make sure you’re checking your rosters. I won’t call deadbeat on anyone yet but there have been a few situations that surprised me that a player was started despite the reports. I’ve got the league checker robot running again to send out notifications on Thursday and Saturday mornings. You’ll get notified if you have anybody in a worse than Probable state. Every year total points end up deciding the final spot in the playoffs so every game counts!

The power rankings have shifted a bit. Austin dropped out and Jim jumped onto the list. I’m still inexplicably on a good run that I expect to end any week. Jamaal Charles is out now so maybe that’s the start of the end for me.

1. Ben
2. Logan (+1)
3. Jim (+2)
4. Tim (-2)

Now on to the weekly awards.

This Week Season All-Time
Highest Team Score Ben had 150.86 Tim 200.51 (Week 3) Tim 200.51 (2013)
Lowest Team Score Austin had 64.70  Was Andy 70.73 (Week 2) Luke 47.01 (2011)
Biggest Blowout   Ben beat Austin by 68.23 (Week 4) Luke beat Andy by 113.02 (2010)
Closest Win Andy beat Tim by 8.83 Austin beat Jim by 2.49 (Week 2) Jim beat Ben by 0.12 (2012)
Highest Scoring Player Josh McCown had 39.48 for NO ONE. Aaron Rodgers had 44.92 for Tim (Week 3) Peyton Manning had 60.28 for Andy (2013)
Longest Winning Streak Ben has a 5 game winning streak Was Ben had a 4 game winning streak (Week 4) Micah had an 8 game winning streak (2011)
Longest Losing Streak Luke has a 5 game losing streak Was Luke had a 4 game losing streak. (Week 4) Kyle had a 14 game losing streak (2011)

Pumpkin Patch

A trip to a pumpkin patch is an annual tradition for us. This year we went back to Bob’s Corn and Pumpkin Farm. Elijah loved the hayride because we got to sit up from by the tractor. We didn’t even get off at the end. We just took the round trip. They also have a nice playground, small petting zoo and pony rides. If you’re into fall foods, they have plenty to choose from: apple and pumpkin donuts, kettle corn, BBQ, etc. For the bigger kids (umm… and me…) they have three pretty big air canons that shoot apples. All in all it was a great morning but I’m glad we got there early. It was getting really busy when we left.pumpkin2015_1 pumpkin2015_2 pumpkin2015_3 pumpkin2015_4

 

Firefly

FireflySay the word “Firefly” around a sci-fi geek and they’ll get all giddy and sad at the same time. The show only ran for one season (14 episodes) back in 2002 but it has a huge following. The show isn’t super high budget, but it’s plenty to be entertaining. It unabashedly mashes the western genre together with sci-fi and the result is great. The premise is that humans have been expanding across the galaxy and the outer planets were settled with basically people and some livestock. The show follows some a crew on a ship that takes whatever transport jobs they can find whether or not they skirt the edge of the law.

It’s all available for free on Amazon Instant Video if you have a Prime subscription. I finally watched the show and loved it, but now, like other fans, I’m disappointed that it’s over and there are no more available!

CrashPlan Update

crashplan-logoIn 2011 I signed up for CrashPlan and I’ve been a big advocate ever since. It’s a fantastic cloud backup service. You just install it on your machine, pay a small annual fee, tell it what folders to watch and you’re protected! There’s no limit on how much data you can upload. I have 3.9TB uploaded now!

As the size of my backups have increased, there have been two times when the app has stopped working. Both times were because the app was running out of memory to look at all the files and figure out what had changed. There’s an easy fix which is well-documented on the CrashPlan site. You just edit an INI file and restart the service.

If you’re not doing any kind off site backup yet, go to crashplan.com and sign up. It’s a tiny amount of money to be protected against all kinds of problems and data loss disasters.

Generator

generatorWe lose power at our house once or twice a year. In the last nine years, there have been a couple multi-day outages, but in general, our power is pretty reliable. But… we bought a generator. When we came back from vacation to a house with no power, food going bad in the fridge and an overtired kid who was thrown even more out of his routine, I snapped and clicked BUY IT NOW on Amazon.

Generators can get really expensive. I think I kept it fairly simple by making some compromises. I didn’t get a name brand, I didn’t get a super quiet model, I got gas instead of diesel, and I didn’t get one that is wired into my house. What I DID get is a DuroMax XP440E. It’s rated for a sustained 3500 watts, has an electric starter and it cost less than $400. I figure that if we use it even a few times, I’ll feel like it was worth the money.

My main goal during an outage would be to run the fridge along with some lights and cell phone chargers. That will be easily accomplished by placing the generator on the back patio and running extension cords into the house. Simple, but effective.

At some point I want to have a bunch of upgrades done on my electrical panel (per circuit usage monitoring, whole-house surge protection, etc) and at that point I might have them wire in a transfer switch. Then I could just plug the generator right into the panel and (carefully) power the whole house. Obviously we wouldn’t fire up the dryer, the microwave, etc, but it would be really nice to use light switches. Plus, our water heater requires electricity because it’s tankless so this would give us hot water. Brent, our HVAC guy, said we could power our furnace with the generator too. So there are lots of possibilities but I don’t plan to go down that route soon (or maybe ever.) In an emergency, I’m pretty sure I could hack up a solution to get the furnace powered by the generator so I feel like I’m covered. Plus it rarely gets THAT cold here.

Once it arrived, setup was simple. There are a few steps to follow to get it ready to run the first time, but now it should start up very easily via either the electric starter or the pull cord. We live less than a mile from the gas station so assuming they have generators, we should be able to get gas from them as needed if my small local cache runs out.

That all being said, I feel somewhat ridiculous for buying a generator. I grew up in a house that seemed to lose power all the time and we never had a generator. This was definitely a luxury purchase, but for I’m happy with getting this backup plan for only $400.

Fantasy Football – Week 4

2015week4 freemanWhew, the Seahawks squeaked out an ugly victory against arguably the worst team in the NFL. But even the Lions were able to run through that porous offensive line. Jimmy Graham is great, but was losing Unger worth it? And then we had “batgate” after the game was over. Apparently the touch in the endzone was illegal. Yes, it would have been better if the rules were properly enforced, but I don’t feel nearly as bad about this one as I did about the Packers one. Nobody seemed to even notice that something incorrect had happened (or maybe I just missed it as I fast forwarded to get to the action.)

We had some close games in our league. Luke and Andy faced off to see who would win their first game. Sorry Luke. Maybe next time? You are the closets to Detroit so I guess it fits. We had a lot of low scores, but looking at the rosters, a large part of it was some surprises about who made the points. There were a lot of points on the benches this week. I’m trying not to mention my streak because I know it will go down in flames.

The power rankings are back! Here’s what my super secret, proprietary formula says:

1. Ben
2. Tim
3. Logan
4. Austin

Now on to the weekly awards.

This Week Season All-Time
Highest Team Score Ben had 139.79 Tim 200.51 (Week 3) Tim 200.51 (2013)
Lowest Team Score Austin had 71.56 Andy 70.73 (Week 2) Luke 47.01 (2011)
Biggest Blowout Ben beat Austin by 68.23 Was Ben beat Dad by 60.90 (Week 1) Luke beat Andy by 113.02 (2010)
Closest Win Andy beat Luke by 5.53 Austin beat Jim by 2.49 (Week 2) Jim beat Ben by 0.12 (2012)
Highest Scoring Player Devonta Freeman had 35.40 for Ben Aaron Rodgers had 44.92 for Tim (Week 3) Peyton Manning had 60.28 for Andy (2013)
Longest Winning Streak Ben has a 4 game winning streak. Was Ben has a 3 game winning streak (Week 3) Micah had an 8 game winning streak (2011)
Longest Losing Streak Luke has a 4 game losing streak. Was Luke and Andy have 3 game losing streaks. (Week 3) Kyle had a 14 game losing streak (2011)

Apocolyptic Bunker

Imagine building a 70mph mobility scooter, a bed that launches you across the room as a morning alarm, or a jet bicycle. These are just some of the things that Colin Furze has done on his YouTube channel. His latest project trumps them all though: an apocalyptic bunker. He’s digging a huge hole in his back yard and building a bunker! You can watch parts 1, 2 and 3 on his channel now, but there will be a few more videos before he finishes. I love watching videos from makers, but Colin is in a league of his own. He dreams up crazy things and then actually makes them happen.