Create a free Org Chart and sync with Google Sheets Recently I tried to create a free org chart from my employee list in google sheets. The org chart should be optically pleasing, support multi-team-lev Daniel Setzermann Feb 25, 2024 public 1 min read →
Quickly compress images with Automator (Mac) Although data-plans are becoming bigger and bigger the size of a webpage still matters – according to many sources the page load time drastically affe Daniel Setzermann Jul 2, 2017 public 2 min read →
A Better Campaign URL Builder for UTM Tracking Links This is a free google spreadsheet based campaign url builder for utm tracking links to be used with Google Analytics. I've created this tool with Daniel Setzermann Jun 19, 2017 public 5 min read →
How to calculate the median per group with MySQL The other day I had to calculate the median per group within MySQL. Turns out this is not as easy as it sounds mostly due to the fact that there exist Daniel Setzermann Jul 9, 2016 public 3 min read →
The best way to convert a screen recording (or any video) to a gif both in quality and size A gif of a screen recording has proven itself to be a very practical solution to make tutorials easier to understand. The gif has the big advantage th Daniel Setzermann Jun 5, 2016 public 2 min read →
How to build an analogue dashboard for digital metrics – like the current number of visitors on your site Update 2025: This doesn't work anymore – the post is kept alive because I still like what I've done back then. But don't try to rebuild th Daniel Setzermann May 29, 2016 public 6 min read →
