Average every n number of rows in a spreadsheet
Posted: 2021-02-27 Filed under: academic, office | Tags: gnumeric, spreadsheet Leave a commentI 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
Posted: 2020-11-04 Filed under: academic, office | Tags: chart, diagram, venn Leave a commentI’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.
Keep lines thickness in Inkscape
Posted: 2020-09-26 Filed under: drawing | Tags: border, inkscape, line, proportion, scale, stroke Leave a commentI 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
Posted: 2020-08-05 Filed under: academic, office | Tags: Cell values, function, gnumeric, left, shorten, spreadsheet Leave a commentI 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
Posted: 2019-12-03 Filed under: drawing | Tags: color, colour, harmony Leave a commentI’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.
slackalaxy.com 