Browsed by
Category: Software

Excel / LibreOffice Calc – text and data processing

Excel / LibreOffice Calc – text and data processing

I’ll show how to parse text, extract numbers and calculate averages on an example of performance data. I have performed a dozen of performance scenarios, each repeated four times to get an average. Every sample contained three values: time in seconds of execution of the first step, time in seconds of execution of the second step, and memory consumption in MB. For instance, 17.6 | 7.4 | 687 meant:

Read More Read More

Online mind mapping tools

Online mind mapping tools

I’ve been using mind mapping tools for years for creating plans or elaborating ideas. So far, my favorite offline software was FreeMind. It hasn’t been updated for years, but it is open source and has impressive features, like formatting nodes, icons, good keyboard support, adding links, colorful clouds for branches, and much more. Just take a look at the screenshot in Wikipedia. Today I decided to look for some online alternative for easier access on any device (also mobile) and simplified sharing.

Read More Read More

WordPress – another way to add widgets area (sidebar) below a post

WordPress – another way to add widgets area (sidebar) below a post

Previously I described one method to add custom widgets areas by copying and modifying theme files:

Now I’d like to describe another possibility when it comes to adding widgets area above or below a post or page – by adding the_content filter.

Read More Read More

How I refactored maze generating Python code and used advanced class features

How I refactored maze generating Python code and used advanced class features

Previously, I have created a maze generating code while learning Python. Later I enhanced it with animation and marking special cells. All of it was done in rush, to solve the problem. Now I spent some time improving the quality of the code by encapsulating code into classes, using “private” methods and fields and separating concerns. The exact steps I took can be viewed in the GitHub repository or read here.

Read More Read More

My favorite graphing tool – Graphviz

My favorite graphing tool – Graphviz

I used to create many graphs, usually the kind of dependency/hierarchy (see the previous post about Programming paradigms in JavaScript).

A long time ago I discovered a perfect tool for a developer to create and maintain various graphs – Graphviz. You can download it and use offline, but there are also online interpreters for quick experiments, for example:

Read More Read More

WordPress – add custom widgets on home page

WordPress – add custom widgets on home page

I once had a desire to provide a list of shortcuts on the home page for my blog’s new users. I didn’t like the default WordPress’ blog page to be just a list of posts. I didn’t think that sidebar widgets grouping posts by date, category or tag would be helpful enough to grasp the versatility of the topics I cover here. I wanted to display a clear list of links with what a user can read about.

Read More Read More

Restore a computer backup from “Backup and Sync from Google”

Restore a computer backup from “Backup and Sync from Google”

I use the Backup and Sync from Google application that allows synchronizing all or a part of Google Drive cloud with a local folder. It also allows creating hot backup of selected folders. It monitors files in those folders and any change initiates immediate synchronization with the cloud. All folders from one computer are grouped into that machine name, and you can have multiple computers backed up (well, parts of them, it is not a full backup).

Read More Read More

Add Jasmine unit testing support to Angular in StackBlitz

Add Jasmine unit testing support to Angular in StackBlitz

I mentioned StackBlitz in the post about online code editors. This service allows for creating i.a. running Angular applications. Once I wanted to execute unit tests written in Jasmine inside it, and I hit a lot of troubles. Finally, I managed to resolve them all.

Read More Read More

My favorite bookmarklets

My favorite bookmarklets

Bookmarklets are an “ancient” idea to execute custom scripts on arbitrary pages. I haven’t really heard people using it nowadays, but there still seem to be present several interesting scripts to improve browsing. A few years ago I created several scripts to add custom formatting and features to Jira board and issue pages and recently I created an “add-on” to Trello and I discovered some bookmarklets created by others, which I list below.

Read More Read More

Trello Power-Up to hide labels and fields from card covers

Trello Power-Up to hide labels and fields from card covers

I had an ingenious idea to show a clutterless view of a Trello board. Sometimes it is beneficial to have an overview of card names without all the details like labels, assignments, photos, dates, custom fields, and so on.

For instance, instead of displaying a board with tens of cards with labels, due dates and custom fields like this:

Read More Read More