Gene name errors are widespread in the scientific literature.

@kareem_carr If you want to have genes randomly named "7-Sep" in your data, Excel is right there. https://t.co/W70BYEZr49

@causalinf @ladyaeva I saw a recent video of @standupmaths about this (and other problems with Excel): https://t.co/Q3YvXecZa3

Excel turned gene names into dates in one-fifth of human gene papers, but still won't auto-wrap text. Yet another reason journalists should learn to code. pubmed.ncbi.nlm.nih.gov/27552985/

【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/U8lXlYyT7D 2016年 Gene name errors are widespread in the scientific literature https://t.co/JYwqEfUiFi

@Eric_Fauman @pjobphd @ksuhre Reminded me of these two papers - 1) Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/M8s1Kxz2mz 2) Gene name errors are widespread in the scientific literature https://t.co/anqu8cVZCw #bioinformatics https://t.co/KiPPMDaDXu

@opinonhaver I think it’s the collective & cumulative effect of excel errors in bioinformatics/genomics papers https://t.co/Gh7fPDYSQW

Excel turned gene names into dates in one-fifth of human gene papers, but still won't auto-wrap text. Yet another reason journalists should learn to code. pubmed.ncbi.nlm.nih.gov/27552985/

@CatocatAnthony @bwinterrose @GrantSlatton wrong, everything is a date. even the genes in our bodies. https://t.co/vPjdbxC9rA

@SecurityReasons Та стара ж хуйня https://t.co/qXRLsXoYce

@gregce10 @adbreind @charles_irl @mpicbg brutal: https://t.co/2vpMk4MNjR

3/ Real-World Consequences A 2016 study found that about 20% of published genomic papers had Excel-induced gene name errors. Source:Genome Biology Study https://t.co/XH1934wvSo

@OttoKurect @TannhauserGate0 @memeticsisyphus Similar meant a loss to the UK government's tracking of positive covid cases. I forget which ones are included in this but might be of interest https://t.co/yI1aHnYlwN

@sweetsauerkr4ut @_WagnerG_ @ML_Burn https://t.co/jYjqQBMZ3h

I have a set of horror stories culled from searching Retraction Watch for "excel", but the classic data-type error in my field is when Excel assumes gene names are dates. Noticed 2004, still rampant in 2016: doi.org:10.1186/s13059-016-1044-7.

Background: https://t.co/ZlRU2ufMbR https://t.co/iSEXWgoR8i https://t.co/VpQewV1SHL

@AlmaLinux https://t.co/2OBL7BROsP

@milot_mirdita @SDuninHorkawicz @DdelAlamo Need an update version of this including PDB identifiers https://t.co/fm7eYNcxDr

https://t.co/yLpsWAQSCy smol paper here

RT @EuSpRIG: Remembering when Matt Parker and I wrote a spreadsheet joke for his piece "when #spreadsheets attack" - this was in the wake o…

Remembering when Matt Parker and I wrote a spreadsheet joke for his piece "when #spreadsheets attack" - this was in the wake of the loss of #covid cases by the UK government via a #spreadsheet @Felienne features strongly too! https://t.co/WoXUmUbMvZ

Bir diğer araştırma ise Microsoft Excel'in ayarlarından kaynaklı sehven hata nedeniyle makalelerin % 20'sinde gen isimlerinin karıştırıldığını tespit etti. https://t.co/cqGC9lQIpj https://t.co/xOh7XSoUUu

@estebanmoro wow indeed! Reminds me of the use of Excel creating fake gene names in bioinformatics (like « March1 »)… Great to see such replication work, this is science in action! https://t.co/VkdK5ieRl5

@JHWeissmann … errors Ziemann, M., Eren, Y. & El-Osta, A. talk about in ‘Gene name errors are widespread in the scientific literature. Genome Biol 17, 177 (2016)’ through to troublesome model assumptions, extended robustness and sensitivity checks etc.

@JanTrka @dagmarhanzlik @UniKarlova víte? A nebo se jen domníváte? Je docela poučné kouknout se na výskyt nereprodukovatelnosti studii, počet p-hackingu, ale i takova kontrola nazvu genu,… tam vsude jsou Q1 casopisy casto horsi, nez Q2 https://t.co/lh3pfV5b98

@tkapler Přitom to byla taková zábava https://t.co/GpsqW4D2sN

RT @takatoh_life: 【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformati…

RT @takatoh_life: 【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformati…

【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/U8lXlYyT7D 2016年 Gene name errors are widespread in the scientific literature https://t.co/JYwqEfUiFi

PSA: Es gibt eine European Spreadsheet Risk Interest Group.  https://t.co/2HStFTC7YE Und wer ein paar takes lieber als leicht verdauliches YouTube-Video haben will, Matt Parker ist dein Freund: https://t.co/fpsTuth5qt

Folgenreichste Fehler #ExcelDAU: Vortrag eines Mathematikers mit zahlreichen konkreten Beispielen: https://t.co/Mu45L3wxRT

@motomatters @standupmaths @TimHarford Matt’s YouTube channel is also excellent, and includes some spreadsheet videos like this one https://t.co/EXMj10LiDg

@kareem_carr If you want to have genes randomly named "7-Sep" in your data, Excel is right there. https://t.co/W70BYEZr49

@DubiousLlama @ianbremmer @NOAA I stopped trusting papers without raw data long ago. Peer review has failed pretty badly. For example: https://t.co/5cv4U96ghl

https://t.co/Ji1O0LE0ZU

@opinonhaver I think it’s the collective & cumulative effect of excel errors in bioinformatics/genomics papers https://t.co/Gh7fPDYSQW

ICYMI #research #AcademicTwitter #AcademicChatter #genetics #medicine https://t.co/S0C04q02Kh

https://t.co/LZilhnzsuw wow

@golinvauxb No kidding Sherlock! Ziemann, M., Eren, Y. & El-Osta, A. "Gene name errors are widespread in the scientific literature". Genome Biol 17, 177 (2016). https://t.co/XAs2dtmTLi

'Why don’t reviewers catch basic errors and blatant fraud? One reason is that they almost never look at the data behind the papers they review, which is exactly where the errors and fraud are most likely to be.' https://t.co/pjApMNAPin

Some references regarding the issue: https://t.co/Z0kJY3EnNS https://t.co/eOvQYB3KbF

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

@JakubTomek13 https://t.co/zerMGP8ZCX

@StevenSalzberg1 @nomad421 Yep. Except it happens so frequently. This article suggest 20% of articles have this problem

@deivudesu This unfortunately does not come as a surprise. @mdziemann and co found that hype impact journals are actually more likely to contain excel errors. https://t.co/wFc6PxKLEx https://t.co/wjuoB70RaI

When spreadsheets attack... https://t.co/4ju3ZazmTF

@alliao Yep! https://t.co/4ju3ZazmTF

https://t.co/cR7dBZ3JxT

@edwardog It became a great business, indeed. People loved to feel empowered. Until they were helpless. Like this one: https://t.co/XEJmtRRbXD Which led to this: https://t.co/m4ZNw66Sq7

@CiItay https://t.co/mDDAbpfiw7

Gene symbols such as SEPT2 (Septin 2) and MARCH1 are converted by default to ‘2-Sep’ and ‘1-Mar’, respectively by Excel. Is there a way to permanently deactivate automatic conversion to dates in Excel? https://t.co/Z6KvBSv8HQ

@qikipedia Ah, @standupmaths covered this https://t.co/MF7BkD1Ejs

RT @Mechagenide: @c3iq I'd laugh if it wasn't both accurate AND they didn't still manage to mess that up https://t.co/DZddVP4eGI

@c3iq I'd laugh if it wasn't both accurate AND they didn't still manage to mess that up https://t.co/DZddVP4eGI

@DerekSollberger Your next journal club read? https://t.co/tinoLOodi8 https://t.co/ucDdnN2RSD

"MS Excel.. is known to convert gene names to dates and floating-point numbers. A programmatic scan of leading genomics journals reveals that approximately one-fifth of papers with supplementary Excel gene lists contain erroneous gene name conversions." https://t.co/go5VyQINAK

@banannareli @nplareau FYI: https://t.co/I2LnfbtcCP

@stevieinselby Matt has already done a video that discusses this! https://t.co/yh5BFOwfYB

I once enrolled for a course on "Building Trustworthy Systems" & later discovered a video about how much Excel — that popular Microsoft Spreadsheet software had cost businesses. According to the video, the state department of education in Utah https://t.co/53fSnQ4BcY

@BenthicAnnabell https://t.co/rFCfc5cBhb

RT @TheSheetsGuy: Happy Friday! Here's a video to watch this weekend: "When Spreadsheets Attack!" This video has background on the stats…

When #Spreadsheets #Attack I watched this, last night in bed, was interesting. https://t.co/SdvvOQq7IS

Gene name errors are widespread in the scientific literature, as said in Genome Biology journal. “Septin 2” can be coded as SEPT2, and spreadsheet software can convert it into date. Have to be careful! #data #error #gene #Excel #journal #AcademicTwitter https://t.co/7aOareWzw5

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

"The spreadsheet software Microsoft Excel, when used with default settings, is known to convert gene names to dates and floating-point numbers. A programmatic scan of leading genomics journals reveals that approximately one-fifth of papers ..." https://t.co/DUZqSgliek

@Schemerwoude https://t.co/QNnZpsEopc M$ mag geloof ik ook niet zomaar iets aanpassen aan de manier waarop excel berekeningen doet.

@belathoud @halvarflake Thought you were talking about this: https://t.co/OAEVKZRLqQ Guess not though

According to @standupmaths: “With great spreadsheetpower comes great spreadsheetresponsibility!”

@J_my_sci Excel autoformatting strikes again... You ha e probably seen this but I always give it to students to show them why working with data in Excel can be problematic https://t.co/s9brzeClDK

@AiSimonThompson @lawrennd Point well taken. This might be a fun illustration of your point: https://t.co/MDnNSOeMuk

What would the spreadsheet equivalent of the “bat symbol” look like @standupmaths? https://t.co/SSg5dwYTdt https://t.co/A2ZT7B2PLJ

“With great spreadsheet power, comes great spreadsheet responsibility.” Such a punchline… When Spreadsheets Attack! https://t.co/Ceu6KWv2i9 via @YouTube

RT @causalinf: Dude this is freaking hilarious. 20% of papers in the gene literature are screwed up bc freaking excel converted the gene id…

@gvwilson @researchremix There's the gene names issue, but not sure if you mean that kind of thing https://t.co/TwB2K5Budb

@bhalomanush Lovely video by Matt Parker about the same issue https://t.co/iQgSp9o1Cm

@spektrum paper fast genau 5 Jahre alt https://t.co/j8ny5RCPDd

RT @StoreGene: At such a crucial point in precision medicine, it is important we are aware of possible mistakes that could affect progress.…

RT @StoreGene: At such a crucial point in precision medicine, it is important we are aware of possible mistakes that could affect progress.…

At such a crucial point in precision medicine, it is important we are aware of possible mistakes that could affect progress. Read more: https://t.co/Hqo0eGC4zY #Bioinformatics #BigData #genomics #geneticists #research #DataAnalytics #medicine #wgs #genes #PrecisionMedicine

Gene name errors are widespread in the scientific literature | Genome Biology | Excel’s automatic conversion of gene names to dates corrupted data in 20% of published papers. https://t.co/KXTc5HkkO9

@jdstraughan We laugh to keep from crying

RT @causalinf: Dude this is freaking hilarious. 20% of papers in the gene literature are screwed up bc freaking excel converted the gene id…

RT @causalinf: Dude this is freaking hilarious. 20% of papers in the gene literature are screwed up bc freaking excel converted the gene id…

@asmae_toumi @Ben_G_Braun This isn’t funny, it’s life threatening because decisions are made based on 20% erroneous genomics. https://t.co/KKDz1T8llb Ok we can laugh a little about how the most ubiquitous software is actually a very bad one :-/

@Rami_Krispin @jesmiq https://t.co/52M6I7wQWg https://t.co/a1boufVPg4

@AnneAMadden Excel causes errors in 20% of papers with genetic data. For example, “Membrane Associated Ring-CH-Type Finger 1” is written as “MARCH1” and so Excel converts it to “1st of March”: https://t.co/aEUfmM1te6 Fixed with new gene names in 2016: https://t.co/k5iYdM5Nwe

@andreasvc @_akpiper There are definitely domain-specific issues: https://t.co/QVbc6VO1To

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

@aleroi @LeenaViikari haluun aina tilaisuuden tullen puhua artikkelista, jonka mukaan noin 20 % excel-listoja sisältävistä genomiikan artikkeleista on mukana ohjelman päivämääräksi muuttamia geeninimiä https://t.co/umS3zu8LcU

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

Gene name errors are widespread in the scientific literature https://t.co/CdN0d7dPkP

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

3/18/21 This week's off topic Thursday relates to one of my love-hate relationships: excel! https://t.co/GDXZabTUzh

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

RT @emollick: A third of all genetics papers published in Nature over a decade (and 20% across all journals) had errors due to the fact tha…

@adspthepodcast @msexcel These videos from @standupmaths, https://t.co/SvMr0gZ6ey and https://t.co/L3y7klPts0 kinda show when Excel goes wrong :) I saw these videos today and thought of this episode. People tend to overuse spreadsheets and can lead to problems.

@mbeisen https://t.co/H5BHLYXKgy

@sethvargo https://t.co/K71nkTsenq

@HHelenaV https://t.co/Yv1uMg8rXT

@icklenellierose Enron's records are also literally the ur-example of spreadsheet errors. https://t.co/NLog0ysBKL

For those who prefer video to reading, here is the video: https://t.co/vKehQcZT4w

@SardArchaeo @PleaseBeGneiss https://t.co/nbHZqMNMDM

@alicekeeler https://t.co/BPE21N8bjp

How do "we" know that ~90% of all spreadsheets contain mistakes ❓ Watch "When Spreadsheets Attack!" on YouTube https://t.co/15fOetx6Ld @EuSpRIG Spreadsheets are great but more often than not you need a program to do the work for you

When Spreadsheets Attack! https://t.co/2RZbYbIghP

In honour of the serco test and trace excel debacle, here's a from Matt Parker @standupmaths from January "The moral of the story is, I don't know, don't use excel as a database" https://t.co/T22Aa9PXlx

Also @standupmaths made an awesome video about mistakes caused by Excell https://t.co/vT2ZBpdV4B

@sleepiest_ Things you might also be interested in: https://t.co/GQEzhEaKlU

@EveryCountry https://t.co/I0lfnXSDsr

And finally, when spreadsheets turn on you, the results can be ... material for a standup mathematician: https://t.co/YzqRZaEcio

@JuliaHB1 https://t.co/1HPM86LjLd

@simondolan https://t.co/1HPM86LjLd

@MurrayData https://t.co/1HPM86LjLd

@MacFhearraigh I'll just leave this here: Gene name errors are widespread in the scientific literature | Genome Biology | Full Text https://t.co/AeDCYOQbXs

@Rachael2Win https://t.co/aLMY5IwJFu Before anyone has a go, watch this. Most spreadsheets contain errors.

@MilesBriggsMSP https://t.co/aLMY5IwJFu You should watch this before commenting, unless you want to come across as an idiot like @milesbriggsMsp

@MBallantyneMSP https://t.co/aLMY5IwJFu Watch this before falling into the dunning kruger trap like @MBallantyneMSP

Gene name errors are widespread in the scientific literature | Genome Biology | Full Text: Quand on entre certains trucs dans un case Excel, ce dernier essaye d'interpréter ça : si vous mettez "SEPT2", il convertira ça en "01/09/2002", car il pense que… https://t.co/GhRriEyevk

@unixtippse https://t.co/7zVhWcex1d Sein Buch Humble PI hat auch noch einen Abschnitt zu Excel.

@YFeyman @hyperplanes It’s not just formatting. With Y2K Excel crossed the Rubicon and began altering data without telling the users. Excel munging gene names into dates is a well known problem in bioinformatics https://t.co/VXUFzpp747 and https://t.co/YV32pIYy7Z

@SwiftOnSecurity Does @standupmaths ever have a video for you: https://t.co/660eBH1j1D

this is such an interesting video, bottom line don’t use excel for databases https://t.co/tCOpzEvvgO

@zayneYee https://t.co/7EsGWs8ugt

@standupmaths If you were impressed with a 41 MB spreadsheet, I work with one that’s 47 MB. Almost 9 MB is just one sheet of formulas (7200 rows by 150 columns). Yes, we actually use it. Yes, I’m doing everything I can to fix it. https://t.co/IC9kmJGVJq

RT @ksuhre: @krassowski_m @FrezzaLab There are actually papers in PubMed on the problem: "Gene name errors are widespread in the scientific…

@krassowski_m @FrezzaLab There are actually papers in PubMed on the problem: "Gene name errors are widespread in the scientific literature" https://t.co/GPovEKVih5 and "Truke, a Web Tool to Check for and Handle Excel Misidentified Gene Symbols" https://t.co/Fb6aa9gBF1

@ph0b @flyingtragedy That could be it! Excel has a way of not doing what you want https://t.co/jD4ZFNhU6k

Augh. See *the first sentence* of this PDF. "Gene name errors are widespread in the scientific literature" https://t.co/OYAEWgoQ6C

RT @SecloreVishal: When spreadsheets attack !! Amazing video from one of my favourite youtube channels on the curse of spreadsheets! Atleas…

When spreadsheets attack !! Amazing video from one of my favourite youtube channels on the curse of spreadsheets! Atleast now when you make a spreadsheet mistake you can correct it my recalling it !! #secloreit https://t.co/fb5RupkOdO

@jannikbuhr Excel, back at it again https://t.co/s5q0YVNaYj

Happy Friday! Here's a video to watch this weekend: "When Spreadsheets Attack!" This video has background on the stats for the spreadsheets from Enron. Also, times when a spreadsheet's default behavior can play havoc with your data. https://t.co/yRpTG0CuNP #Spreadsheets

C'est pour @saloperie__ ça dis donc https://t.co/fPLwGsyX98

BTW: Also see this ;) When Spreadsheets Attack! https://t.co/4ju3ZayP47 by @standupmaths

RT @MakerWijnen: @causalinf @ladyaeva I saw a recent video of @standupmaths about this (and other problems with Excel): https://t.co/Q3YvXe…

For a bit more on the annoyances of using a spreadsheet when you want a database - @standupmaths https://t.co/qUATet1D1g https://t.co/ltNJbsJsFk

@causalinf @ladyaeva I saw a recent video of @standupmaths about this (and other problems with Excel): https://t.co/Q3YvXecZa3

RT @EuSpRIG: This is a really fantastic video all about spreadsheet errors from the brilliant @standupmaths, featuring some of the horror s…

This is a really fantastic video all about spreadsheet errors from the brilliant @standupmaths, featuring some of the horror stories and analysis from @EuSpRIG https://t.co/Eb0pkdEmWx We are most honored, please go and watch it! #excel #spreadsheets #risk #fail #error

@Durangatan Except when it fails silently https://t.co/mAjjU3RChC

@simonrjones Ah, but did you see @standupmaths's recent "When Spreadsheets Attack!" vid? :-) https://t.co/HjyIfL4KD3

@horcicaa Mi připomnělo nedávné video kdy Excel se chová jinak než lidé očekávají a velká finanční firma přišla o miliardy :) https://t.co/GpsqW4D2sN

JPMorgan Chase lost an unfathomable sum of money. Unnecessarily. https://t.co/9orSfFvQ8G #finance #spreadsheets #CFO #budgeting https://t.co/XPMu76nYXi

"Sometimes, the spreadsheet can hit the fan" https://t.co/YSowVC3hXX from @standupmaths

Para tenerlo en cuenta @saul_mendez97 https://t.co/kORMh6oh7k

Interesting (and hopefully partially useful) information on the standupmaths channel about spreadsheet errors and research. Worth a watch https://t.co/lzmPhzSRoP

all this time on hold is leading me to think about @standupmaths new video about (in part) database errors - https://t.co/aA2NElzuS2

"With great Spreadsheet power, comes great Spreadsheet responsibility" Excellent video on why sometimes Excel is not the best application to store your data - via @standupmaths - When Spreadsheets Attack! - https://t.co/nRHYxHsnur #data #spreadsheet

https://t.co/2WIctPmegO

Great video from @standupmaths, with reminders of my former life, where almost all my work was in Excel https://t.co/n0VVVrjrcf

Think Pepper for #AssetManagers. As the inimitable Matt Parker puts it with great spreadsheet power comes great spreadsheet responsibility or else When Spreadsheets Attack!: https://t.co/a62Tln3Kzb

“Approximately 19.6% genomic spreadsheets have an autocorrect error.” Hilariously, most common error is gene name conversion to a date (e.g. march5, sep15)

@LegsDixon @AcademicChatter https://t.co/EDzniVgHhn

@Mandolesi_Giu @PgGrilli @marattin @ItaliaOggi Excel è uno strumento diabolico da prendere con le pinze. Chi non si è mai trovato in difficoltà con i risultati di un foglio di calcolo con qualche oscuro riferimento sbagliato? https://t.co/B7QZ4fhBpF

@Mocchapi matt parker did a video about this exact issue just a couple of days ago!! https://t.co/ZWqH2vBQH0

Quite half of excel spreadsheet without any calculation and a quarter of the rest have one error... Ow how many a "simple" spreadsheet need to be crosschecked, moreover when its a base for massive investment. https://t.co/HyXCvqblaO

Just watched @standupmaths video about spreadsheets https://t.co/UOHAgP56ww and I have to say the existence of this group has made my weekend https://t.co/gz3kDL4cN3

When Spreadsheets Attack! https://t.co/jKF43gaWrA

Developers of the world: watch this and try not to be angry, especially the @standupmaths Spiderman pun https://t.co/Vx46WpYtWc

yeah abuse a spreadsheet then you get this When Spreadsheets Attack! https://t.co/ScLkZkd1dJ via @YouTube

apparently around 40% of spreadsheets don't contain calculations - that is they don't need to be spreadsheets. (that's more like 99% of the spreadsheets shared with me at the office...) - https://t.co/CXicYhhgxd

@standupmaths @Felienne Yay spreadsheets! https://t.co/TpJz324U0K

https://t.co/F4qiF77dWb Heb je deze al gezien?

Check out the latest video from @standupmaths about spreadsheet errors. I've been using Excel for years and this video taught me some things I didn't know. #excel #spreadsheets #errors https://t.co/g90erfF7VV

@mickaelgodard https://t.co/s7E9FwLAWn

“With great spreadsheet powers, comes great spreadsheet responsibility” @standupmaths highlights some of the common errors and dangers of working with data in spreadsheets in this entertaining video https://t.co/p7yaP0uF9S

When Spreadsheets Attack! https://t.co/LHWKqSXiH5 via @YouTube

"Standup Maths - When Spreadsheets" Attack! https://t.co/yVA84ZCJ1T #standupmaths #maths #math #spreadsheets #excel #data #errors

Europäische Interessengemeinschaft zu den Gefahren von und in Tabellenkalkulationen. Yay. https://t.co/bVoUQcwQh7 https://t.co/fIBrZ2knGi

Using Excel is apparently riskier than I'd imagined

@ManyATrueNerd @ClaireRousseau Some spreadsheet goodness to calm yourself before the storm https://t.co/yxVE83ymJA

Seeing "When Spreadsheets Attack!" on my @YouTube frontpage somehow reminds me of @Felienne... https://t.co/JHmt6RgdbX *a few minutes into the video* Ah...

RT @RobustlyB: .@standupmaths's latest video highlights the need of robust statistics discussed in our latest podcast. Data are usually co…

Gene name errors are widespread in the scientific literature | Genome Biology | Full Text https://t.co/1fLnAll5QK

I'm guessing you also know about the scientific consequences of spreadsheet errors? Lots of poorly managed scientific data held in spreadsheets. https://t.co/xxQrMOV5br https://t.co/UBXCuhBpHQ https://t.co/VljXEzvvNe

CAT HACKER: Gene name errors are widespread in the scientific literature https://t.co/hWpZP1wbAP

Gene name errors are widespread in the scientific literature https://t.co/Zxv55wDIpt 9

Gene name errors are widespread in the scientific literature https://t.co/h62iuIlZaA

New top story on Hacker News: Gene name errors are widespread in the scientific literature https://t.co/YdmmdhKL9t

Gene name errors are widespread in the scientific literature L: https://t.co/lBNWDaj1Nx C: https://t.co/7MPu0gEUVl

Gene name errors are widespread in the scientific literature https://t.co/MY20UD9nTO

@JuliePierce77 I think this is a reference to a 2016 paper that has been going around again on social media this week. https://t.co/hP95LUhggT

RT @dk_barupal: @Eric_Fauman @pjobphd @ksuhre Reminded me of these two papers - 1) Mistaken Identifiers: Gene name errors can be introduced…

RT @dk_barupal: @Eric_Fauman @pjobphd @ksuhre Reminded me of these two papers - 1) Mistaken Identifiers: Gene name errors can be introduced…

@Eric_Fauman @pjobphd @ksuhre Reminded me of these two papers - 1) Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/M8s1Kxz2mz 2) Gene name errors are widespread in the scientific literature https://t.co/anqu8cVZCw #bioinformatics https://t.co/KiPPMDaDXu

@Dale_Masch Perhaps I don’t fear the impact of excel as much as I should. https://t.co/cMDrxeBBQj

RT @tomstafford: Working on some motivational slides for using coding to do data analysis #1: Gene name errors are widespread in the scient…

Working on some motivational slides for using coding to do data analysis #1: Gene name errors are widespread in the scientific literature https://t.co/i4MQPaEWTr Excel autoformat introduces widespread errors into the supplementary material of leading genomics journals

@hisotalus @eglerean @matteo_brainnet @INM7_ISN @bttyeo See for example "Gene name errors are widespread in the scientific literature" https://t.co/XAs2dtEv9S 3/

Gene name errors are widespread in the scientific literature (2016) [pdf] https://t.co/g5r3cdNfho #Gene #NameErrors #ScientificLiterature

RT @ModScienceWkly Gene name errors common in genomic literature SUPP due to automatic renaming convention in #Excel http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7

Excel’s role in propagating gene name errors https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7

Vorsicht bei der Verwendung von Excel für die wissenschaftliche Daten-Auswertung! http://www.heise.de/newsticker/meldung/Verfaelschte-Tabellen-Excel-bereitet-Genforschern-Probleme-3304538.html und http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7

Excel helpfully replaces gene symbols like SEPT2 with date. 20-30% of suppl. data corrupted #ToldYouNotToUseExcel http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7