Another bizarre feature is Excel's VLookup function returning a 0 when the lookup value is an empty cell. Who knows how many research papers have errors due to that.
-
-
Prikaži ovu nit
-
Here's the paper by Ziemann, Eren & El-Osta on gene name errors:https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 …
Prikaži ovu nit
Kraj razgovora
Novi razgovor -
-
-
I do early modern English bibliography. I had one excel sheet that transformed every British Library call number with an 'e' in it into logarithms. My eye kept twitching when that one happened. John Fletcher's The Nightwalker is BL 644e3, not 644000
-
Now try too understand why that is happening.
- Još 6 drugih odgovora
Novi razgovor -
-
-
20% of papers using Excel, not 20% of all papers.
-
More precisely, ~20% of papers which provided supplementary gene lists in xls format. I don't think it's known if the authors used Excel for data analysis. Original paper here:https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 …
Kraj razgovora
Novi razgovor -
-
-
Glad you liked it. Time for a follow-up methinks
-
Definitely! Btw, I've been wondering if in most of these papers Excel was used for data analysis or if the authors only made the gene lists available as xls. If it's the latter, journals could introduce some quality control or could even reject that format.
- Još 2 druga odgovora
Novi razgovor -
-
-
One in five, this is 1/5, or as Excel would say: January the 5th.
-
Best. Twit. Of. The. Whole. Thread.
Kraj razgovora
Novi razgovor -
Čini se da učitavanje traje već neko vrijeme.
Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.
: