Average every n number of rows in a spreadsheet

I have a long column of data that I want to make into a chart. The problem is that the column has over 50000 rows and processing it gets problematic. I looked for a way to average every Nth number of rows, in order to speed up things.
Read the rest of this entry »


Venn diagrams online

I’ve been preparing some figures, where I need to include Venn diagrams. I am looking to make them proportional to the values. So far, I have not found a way to do this in Gnumeric, WPS Office LibreOffice or OpenOffice.org. I guess, I should find the time to learn a little bit more of R. Meanwhile, I’ve been searching for a quick solution online.

Read the rest of this entry »


Keep lines thickness in Inkscape

I am preparing some figures in Inkscape. Something that always gets on my nerves is fixing lines (border) width when scaling objects. The solution is quite simple and actually obvious.
Read the rest of this entry »


Shorten contents of spreadsheet cells

I have a spreadsheet file with a list of species’ Latin names. I want to automatically create abbreviations for each species, by shortening both the genus and specific epithet to a certain number of characters. Here’s how to do it.
Read the rest of this entry »


Color calculator

I’ve been preparing some figures, where I needed a colour palette that is visually appealing and offers good contrast between at least two colours. I am not a designer and I have no experience with these things… So, I googled a bit and I found the Color Calculator, offered by Sessions College for Professional Design.

Read the rest of this entry »