Excel Flash Fill

From time to time you have annoying things to do which you cannot avoid e.g. split names into surname and last name. Here comes the flash fill feature: Given you have the full names in column A Go to cell B1 and enter the last name Go to B2 Go to tab “Data” Click Flash…

My most used keyboard shortcuts in Windows 10

Motivation As you become more experienced as a developer you will start to work on becoming more efficient instead of only being effective. Keyboard shortcuts are a great way to achieve tasks quicker. Shortcut Action Ctrl + X/C/V 🙂 Alt + Tab Switching between programs Ctrl + Tab Switch between tabs in programs Win +…

BarCamp Würzburg 2017

After visiting my first bar camp last year, I became quite an aficionado of craftsmanship gatherings. I visited: SWEC16 FMD 2017 DevCamp 2017 MQ! 2017 Management 3.0 Stammtisch All very different formats, locations and price ranges as well. So I was curious what was going to happen at #bcwue. The location The event took place…

Bosch IXO Repair

In 2006 I bought my first Bosch IXO. It did a wonderful job over the last years and helped a lot assemble and disassemble mostly furniture. (I moved 3 times in the last ten years) But when we started to renovate our  bureau at home the switch for changing directions started to get a slack…

MQ! – The Audi Innovation Summit

  Sometimes You get to something by sheer chance: Scrolling down my Facebook timeline I saw the ad for the Audi MQ! Why do I have to register? After visiting a couple of bar camps I was curious how Audi was organizing a conference. So the first thing notably different to all events I’ve visited…

Python 3 – there shall be just int

Trying to contribute to the Flask plugin flask-login I just added these lines: if isinstance(duration, (int, long)): duration = timedelta(seconds=duration) Looking quite plausible, isn’t it? But lo and behold: it doesn’t work under Python 3.x. Dang! The reason: Python 2 has two integer types: int and long. In Python 3 there is only int, which…

PB SwissTool Ratchet Screwdriver

I pity the fool who hasn’t got a tool! After buying cheap tools all my life I’ve decided that I became too old for 5€ screwdriver. Our working student Michael Jäger introduced me to the brand PB Swiss Tools. They have lifelong guarantee on their tools and have some nice ideas like colorcoding their bits…