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 »

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 »

Slackware and SlackBuilds.org cited in a scientific publication

The latest paper from our research group has just been published in Scientific Reports. A big part of the work was done in silico, using different software tools and databases. All bioinformatics software used locally was installed on a Slackware64 system, almost exclusively from the scripts at SlackBuilds.org. With this post, I would like to give my sincere thanks to Slackware and the SlackBuilds.org community.
Read the rest of this entry »

Row to column in Gnumeric

I have some spreadsheet data which I want to present in columns, instead of the rows that I initially entered. I searched a bit and found instructions for Excel here. The principle is the same, so here’s what I did for Gnumeric. Read the rest of this entry »

Cell values as rows in a spreadsheet

I have some spreadsheet data where the first column lists the position of a certain amino acid within a protein. There areĀ  many amino acid sites that are skipped, therefore the rows do not follow the actual, uninterrupted, amino acid sequence. Read the rest of this entry »