Sign in

Rafał Rybnik

Interactive spreadsheets help free up your time

Unless stated otherwise, all pictures in the article are by the author. Brands belong to their respective owners and are used for information purposes.

If you are like me and run your own practice (business, freelancing, publishing, whatever you want to call it), you probably use some form of a spreadsheet. …


Show users what they want (even though they don’t even know what they want)

Content recommendation system on movie website
(Pic. by author. All logos and posters belong to their respective owners and are used for informational or editorial purposes to identify specific products and services.)

Personalized content proposals are now an established element of the Web. Most social media serve content to their users based on multiple touchpoints of the user’s interaction with the platform. (Some of them also track the user outside their pages, which has caused a whole discussion about privacy and blocking…


How to detect seasonality, forecast and fill gaps in time series using Fast Fourier Transform

Animated circle synchronized with periodic function
Mehmet E. Yavuz (2021). Fourier Series Animation using Harmonic Circles (link), MATLAB Central File Exchange. Retrieved January 24, 2021.

In this article, I will show you how useful for time series analysis is the Fourier transform. We will use the Fast Fourier Transform algorithm, which is available in most statistical packages and libraries. Visualisations and code examples in Python supplements this article.

All are available in this notebook (Google…


Banners for All Your Markets

Depending on your industry, the language of communication with potential clients can be more or less important. Every content must be in the language with which your users feel most comfortable.

Unless stated otherwise, all pictures in the article are by the author.

Translating your banner advertisement into other languages can really impact the effectiveness of your marketing creatives.

In my experience…


Create a Dashboard for Free with Google Sheets and C3.js — online visualization of spreadsheet data.

Unless stated otherwise, all pictures in the article are by the author.

We often have some business data that we need to track. We collect, process and store it in spreadsheets to then create charts and diagrams. However, sometimes there is a need to go out to a non-technical audience. …


Google Sheets as database, Apps Script as backend

Sometimes we have some data stored in a spreadsheet that we would like to make available to other applications, such as dashboards that visualise it. Of course, the growing number of applications and functionalities most often leads to a transition to the use of a real database. But sometimes, we…


Email is an important channel for communicating with your audience. There are plenty of email marketing platforms on the market. Most platforms offer some free tier (usually 2000 recipients per month), but the majority adds their logos to every email you send.

Unless stated otherwise, all pictures in the article are by the author.

Costs with an increasing number of users can…


Translate GTK app using Gettext and Localazy

Typically, when you start developing a new app, its interface is in a specific language, perhaps English, if you want to reach an international audience. By translating your app into other human languages, you can increase the number of people who can install, use, and recommend it.

A few weeks…


Add a tl;dr button to Google Docs

Whether you’re a writer, data scientist or just skimming through sources to get a job done, reading longer texts to pluck out crumbs of information can be quite exhausting. Automating such elements of your work allows you to focus on the creative side of things.

Unless stated otherwise, all pictures in the article are by the author.

Text summarization

Text summarization is the technique…

Rafał Rybnik

Software Developer • Data Science, Business Tools, Privacy• rafalrybnik@yahoo.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store