Let’s say you have a spreadsheet with two tabs: Contacts and Contest. Now you would like to import some data from one tab into the other. You can do this with the following formula: If you now want to import multiple fields just drag the field like you would do it if you were applying a formula normally:
Update: The chromedriver team looked at the issues and currently they won’t fix it as it only happens with non US-en keyboards. So to fix it the computer on which chromedriver gets run must have this keyboard set for it to work without problems. But they may implement a warning if the user doesn’t use the US-en keyboard so people … Read More
Yesterday on the 26th of November I gave a speech at the English Toastmasters Club in Bern about 3D printing. How I use it in my daily life and what my process is when repairing parts of my bicycle and other things. You can find the presentation with all the images online: https://docs.google.com/presentation/d/12j1Zav_I4uGXMvdOesYLl-rXYAn1I-mrzoBqnZ5OasU/edit?usp=sharing To record this video I’ve used my … Read More
I love this scene from season two of Bojack Horseman. If you haven’t seen the show I highly recommend it. The fact that it’s animated may put you off at first, but put yourself through the first season and you won’t be able to stop watching it. When I was a lot younger and already working and playing on the … Read More
Not feeling like doing something. Being to exhausted to do it. Not able to start working on that certain task. We all feel sometimes like we just can’t start to work. The times when we can’t start doing something. So what can we do about that? Lot’s of things. :) 1. Break down your task Starting by trying to break … Read More
A bit over a year ago I told a story in front of an audience at Wahre Geschichten. I was anxious and nervous before hand. So in the last year I compiled a few tips and tricks on how to be less anxious when speaking in public. #1 Sing your favorite song before giving your speech If you have a problem with … Read More
Instructions Get the Charles proxy application from here: https://www.charlesproxy.com/. Then install the Charles certificate on your android phone according to the instructions here: https://stackoverflow.com/a/31945622 Now install the app and start it, after a bit of loading you should see something similar to this: These are the HTTP requests the app makes. In this screenshot I’ve filtered out only the ones going … Read More
As of today my internship as a User Experience Designer at the SBB Cargo is over. I’ve spent the last six months from March to September working at their headquarters in Olten. In this time I was able to look at how a bigger company is run and how it compares to the smaller companies I’ve worked in before. The … Read More
If you don’t have a DeLorean time machine, a TARDIS or a Time Turner you might start worrying that this article isn’t for you. But don’t worry and continue reading. With this article I will show you how you can use the concept of time travel to stop worrying. Even if you don’t have a functional time travel device. I will teach you three … Read More
Maybe I am the special kind of stupid, but I’ve had issues with plugging in my USB C cable into my Nexus 5X for a while. It kept falling out when I wanted to keep it plugged in to charge it. But just a short while ago I had the smart idea to actually google my problem. The solution is painfully … Read More