bioRxiv docx template
Posted: 2021-02-28 Filed under: academic, office | Tags: bioRxiv, doc, docx, template Leave a commentI’ve been working on a manuscript in the last couple of months (more, actually). I am not going to discuss whether pre-prints are cool or not, however, they sometimes are necessary. For example, when writing a grant application, it definitely looks better to show the actual work in progress, rather than just stating “manuscript in preparation”, “submitted” or “under revision”.
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.
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 »
Trimming trees with TreeBeST
Posted: 2020-01-18 Filed under: academic | Tags: ensembl, phylogenetic tree, subtree, TimeTree, tree, treebest Leave a commentI needed a program that can easily trim branches from a phylogenetic tree and came across TreeBeST (Tree Building guided by Species Tree). TreeBeST is a neat and versatile program that builds, manipulates and displays phylogenetic trees and seems to be perfect for the job.
Read the rest of this entry »
slackalaxy.com 