Escape Excel: A tool for preventing gene symbol and accession conversion errors
Publication Date
September 27, 2017
Authors
Eric A. Welsh, Paul A. Stewart, Brent M. Kuenzi & James A. Eschrich
Volume
12
Issue
9
Pages
e0185207
DOI
https://dx.plos.org/10.1371/journal.pone.0185207
Publisher URL
http://journals.plos.org/plosone/article?id=10.1371%2Fjournal.pone.0185207
Scopus
85029941291
Mendeley
http://www.mendeley.com/research/escape-excel-tool-preventing-gene-symbol-accession-conversion-errors
Events
Loading … Spinner

Mendeley | Further Information

{"title"=>"Escape Excel: A tool for preventing gene symbol and accession conversion errors", "type"=>"journal", "authors"=>[{"first_name"=>"Eric A.", "last_name"=>"Welsh", "scopus_author_id"=>"7005180650"}, {"first_name"=>"Paul A.", "last_name"=>"Stewart", "scopus_author_id"=>"7403039434"}, {"first_name"=>"Brent M.", "last_name"=>"Kuenzi", "scopus_author_id"=>"56079429200"}, {"first_name"=>"James A.", "last_name"=>"Eschrich", "scopus_author_id"=>"57195903142"}], "year"=>2017, "source"=>"PLoS ONE", "identifiers"=>{"pui"=>"618483709", "pmid"=>"28953918", "doi"=>"10.1371/journal.pone.0185207", "issn"=>"19326203", "scopus"=>"2-s2.0-85029941291", "sgr"=>"85029941291", "isbn"=>"19326203 (Electronic)"}, "id"=>"8e638990-0fe1-3311-9023-0c1493b518b4", "abstract"=>"#Background# Microsoft Excel automatically converts certain gene symbols, database accessions, and other alphanumeric text into dates, scientific notation, and other numerical representations. These conversions lead to subsequent, irreversible, corruption of the imported text. A recent survey of popular genomic literature estimates that one-fifth of all papers with supplementary gene lists suffer from this issue. #Results# Here, we present an open-source tool, Escape Excel, which prevents these erroneous conversions by generating an escaped text file that can be safely imported into Excel. Escape Excel is implemented in a variety of formats (http://www.github.com/pstew/escape_excel), including a command line based Perl script, a Windows-only Excel Add-In, an OS X dragand- drop application, a simple web-server, and as a Galaxy web environment interface. Test server implementations are accessible as a Galaxy interface (http://apostl.moffitt.org) and simple non-Galaxy web server (http://apostl.moffitt.org:8000/). #Conclusions# Escape Excel detects and escapes a wide variety of problematic text strings so that they are not erroneously converted into other representations upon importation into Excel. Examples of problematic strings include date-like strings, time-like strings, leading zeroes in front of numbers, and long numeric and alphanumeric identifiers that should not be automatically converted into scientific notation. It is hoped that greater awareness of these potential data corruption issues, together with diligent escaping of text files prior to importation into Excel, will help to reduce the amount of Excel-corrupted data in scientific analyses and publications.", "link"=>"http://www.mendeley.com/research/escape-excel-tool-preventing-gene-symbol-accession-conversion-errors", "reader_count"=>11, "reader_count_by_academic_status"=>{"Unspecified"=>1, "Professor > Associate Professor"=>1, "Researcher"=>4, "Student > Ph. D. Student"=>2, "Student > Master"=>1, "Student > Bachelor"=>2}, "reader_count_by_user_role"=>{"Unspecified"=>1, "Professor > Associate Professor"=>1, "Researcher"=>4, "Student > Ph. D. Student"=>2, "Student > Master"=>1, "Student > Bachelor"=>2}, "reader_count_by_subject_area"=>{"Unspecified"=>1, "Engineering"=>2, "Agricultural and Biological Sciences"=>6, "Computer Science"=>1, "Immunology and Microbiology"=>1}, "reader_count_by_subdiscipline"=>{"Engineering"=>{"Engineering"=>2}, "Immunology and Microbiology"=>{"Immunology and Microbiology"=>1}, "Agricultural and Biological Sciences"=>{"Agricultural and Biological Sciences"=>6}, "Computer Science"=>{"Computer Science"=>1}, "Unspecified"=>{"Unspecified"=>1}}, "reader_count_by_country"=>{"Czech Republic"=>1}, "group_count"=>0}

Scopus | Further Information

{"@_fa"=>"true", "link"=>[{"@_fa"=>"true", "@ref"=>"self", "@href"=>"https://api.elsevier.com/content/abstract/scopus_id/85029941291"}, {"@_fa"=>"true", "@ref"=>"author-affiliation", "@href"=>"https://api.elsevier.com/content/abstract/scopus_id/85029941291?field=author,affiliation"}, {"@_fa"=>"true", "@ref"=>"scopus", "@href"=>"https://www.scopus.com/inward/record.uri?partnerID=HzOxMe3b&scp=85029941291&origin=inward"}, {"@_fa"=>"true", "@ref"=>"scopus-citedby", "@href"=>"https://www.scopus.com/inward/citedby.uri?partnerID=HzOxMe3b&scp=85029941291&origin=inward"}], "prism:url"=>"https://api.elsevier.com/content/abstract/scopus_id/85029941291", "dc:identifier"=>"SCOPUS_ID:85029941291", "eid"=>"2-s2.0-85029941291", "dc:title"=>"Escape Excel: A tool for preventing gene symbol and accession conversion errors", "dc:creator"=>"Welsh E.", "prism:publicationName"=>"PLoS ONE", "prism:eIssn"=>"19326203", "prism:volume"=>"12", "prism:issueIdentifier"=>"9", "prism:pageRange"=>nil, "prism:coverDate"=>"2017-09-01", "prism:coverDisplayDate"=>"September 2017", "prism:doi"=>"10.1371/journal.pone.0185207", "citedby-count"=>"0", "affiliation"=>[{"@_fa"=>"true", "affilname"=>"Moffitt Cancer Center", "affiliation-city"=>"Tampa", "affiliation-country"=>"United States"}], "pubmed-id"=>"28953918", "prism:aggregationType"=>"Journal", "subtype"=>"ar", "subtypeDescription"=>"Article", "article-number"=>"e0185207", "source-id"=>"10600153309", "openaccess"=>"1", "openaccessFlag"=>true}

Twitter

Counter

  • {"month"=>"9", "year"=>"2017", "pdf_views"=>"17", "xml_views"=>"6", "html_views"=>"126"}
  • {"month"=>"10", "year"=>"2017", "pdf_views"=>"49", "xml_views"=>"4", "html_views"=>"370"}
  • {"month"=>"11", "year"=>"2017", "pdf_views"=>"9", "xml_views"=>"1", "html_views"=>"195"}
  • {"month"=>"12", "year"=>"2017", "pdf_views"=>"10", "xml_views"=>"1", "html_views"=>"289"}
  • {"month"=>"1", "year"=>"2018", "pdf_views"=>"2", "xml_views"=>"0", "html_views"=>"71"}
  • {"month"=>"2", "year"=>"2018", "pdf_views"=>"6", "xml_views"=>"0", "html_views"=>"12"}
  • {"month"=>"3", "year"=>"2018", "pdf_views"=>"17", "xml_views"=>"1", "html_views"=>"36"}
  • {"month"=>"4", "year"=>"2018", "pdf_views"=>"4", "xml_views"=>"0", "html_views"=>"18"}
  • {"month"=>"5", "year"=>"2018", "pdf_views"=>"8", "xml_views"=>"5", "html_views"=>"11"}
  • {"month"=>"6", "year"=>"2018", "pdf_views"=>"5", "xml_views"=>"3", "html_views"=>"25"}
  • {"month"=>"7", "year"=>"2018", "pdf_views"=>"32", "xml_views"=>"2", "html_views"=>"16"}
  • {"month"=>"8", "year"=>"2018", "pdf_views"=>"13", "xml_views"=>"1", "html_views"=>"18"}
  • {"month"=>"9", "year"=>"2018", "pdf_views"=>"12", "xml_views"=>"0", "html_views"=>"21"}
  • {"month"=>"10", "year"=>"2018", "pdf_views"=>"6", "xml_views"=>"1", "html_views"=>"32"}
  • {"month"=>"11", "year"=>"2018", "pdf_views"=>"3", "xml_views"=>"0", "html_views"=>"21"}
  • {"month"=>"12", "year"=>"2018", "pdf_views"=>"4", "xml_views"=>"1", "html_views"=>"16"}
  • {"month"=>"1", "year"=>"2019", "pdf_views"=>"9", "xml_views"=>"0", "html_views"=>"28"}
  • {"month"=>"2", "year"=>"2019", "pdf_views"=>"20", "xml_views"=>"0", "html_views"=>"33"}
  • {"month"=>"3", "year"=>"2019", "pdf_views"=>"8", "xml_views"=>"0", "html_views"=>"39"}
  • {"month"=>"4", "year"=>"2019", "pdf_views"=>"14", "xml_views"=>"0", "html_views"=>"34"}
  • {"month"=>"5", "year"=>"2019", "pdf_views"=>"6", "xml_views"=>"0", "html_views"=>"31"}
  • {"month"=>"6", "year"=>"2019", "pdf_views"=>"13", "xml_views"=>"0", "html_views"=>"26"}
  • {"month"=>"7", "year"=>"2019", "pdf_views"=>"10", "xml_views"=>"0", "html_views"=>"17"}
  • {"month"=>"8", "year"=>"2019", "pdf_views"=>"8", "xml_views"=>"0", "html_views"=>"24"}
  • {"month"=>"9", "year"=>"2019", "pdf_views"=>"10", "xml_views"=>"0", "html_views"=>"99"}
  • {"month"=>"10", "year"=>"2019", "pdf_views"=>"6", "xml_views"=>"1", "html_views"=>"16"}
  • {"month"=>"11", "year"=>"2019", "pdf_views"=>"6", "xml_views"=>"1", "html_views"=>"21"}
  • {"month"=>"12", "year"=>"2019", "pdf_views"=>"7", "xml_views"=>"0", "html_views"=>"20"}
  • {"month"=>"1", "year"=>"2020", "pdf_views"=>"16", "xml_views"=>"0", "html_views"=>"35"}
  • {"month"=>"2", "year"=>"2020", "pdf_views"=>"17", "xml_views"=>"3", "html_views"=>"31"}
  • {"month"=>"3", "year"=>"2020", "pdf_views"=>"9", "xml_views"=>"0", "html_views"=>"21"}
  • {"month"=>"4", "year"=>"2020", "pdf_views"=>"22", "xml_views"=>"0", "html_views"=>"23"}
  • {"month"=>"5", "year"=>"2020", "pdf_views"=>"55", "xml_views"=>"1", "html_views"=>"30"}
  • {"month"=>"6", "year"=>"2020", "pdf_views"=>"9", "xml_views"=>"1", "html_views"=>"25"}
  • {"month"=>"7", "year"=>"2020", "pdf_views"=>"15", "xml_views"=>"0", "html_views"=>"35"}
  • {"month"=>"8", "year"=>"2020", "pdf_views"=>"10", "xml_views"=>"7", "html_views"=>"62"}
  • {"month"=>"9", "year"=>"2020", "pdf_views"=>"11", "xml_views"=>"1", "html_views"=>"61"}
  • {"month"=>"10", "year"=>"2020", "pdf_views"=>"2", "xml_views"=>"0", "html_views"=>"32"}
  • {"month"=>"11", "year"=>"2020", "pdf_views"=>"5", "xml_views"=>"0", "html_views"=>"19"}

PMC Usage Stats

  • {"unique-ip"=>"21", "full-text"=>"15", "pdf"=>"4", "abstract"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"3", "supp-data"=>"1", "cited-by"=>"0", "year"=>"2017", "month"=>"10"}
  • {"unique-ip"=>"18", "full-text"=>"18", "pdf"=>"5", "abstract"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"1", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2017", "month"=>"11"}
  • {"unique-ip"=>"14", "full-text"=>"11", "pdf"=>"0", "abstract"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"9", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2017", "month"=>"12"}
  • {"unique-ip"=>"12", "full-text"=>"14", "pdf"=>"0", "abstract"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"3", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2018", "month"=>"1"}
  • {"unique-ip"=>"1", "full-text"=>"1", "pdf"=>"0", "abstract"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2018", "month"=>"2"}
  • {"unique-ip"=>"22", "full-text"=>"21", "pdf"=>"4", "abstract"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2018", "month"=>"3"}
  • {"unique-ip"=>"18", "full-text"=>"19", "pdf"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"3", "cited-by"=>"0", "year"=>"2019", "month"=>"1"}
  • {"unique-ip"=>"21", "full-text"=>"23", "pdf"=>"4", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"2", "supp-data"=>"6", "cited-by"=>"0", "year"=>"2018", "month"=>"12"}
  • {"unique-ip"=>"26", "full-text"=>"28", "pdf"=>"2", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"1", "cited-by"=>"0", "year"=>"2018", "month"=>"11"}
  • {"unique-ip"=>"26", "full-text"=>"26", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"4", "cited-by"=>"0", "year"=>"2018", "month"=>"9"}
  • {"unique-ip"=>"17", "full-text"=>"17", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2018", "month"=>"4"}
  • {"unique-ip"=>"23", "full-text"=>"26", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2018", "month"=>"5"}
  • {"unique-ip"=>"10", "full-text"=>"11", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2018", "month"=>"6"}
  • {"unique-ip"=>"19", "full-text"=>"17", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"3", "supp-data"=>"3", "cited-by"=>"0", "year"=>"2018", "month"=>"7"}
  • {"unique-ip"=>"32", "full-text"=>"33", "pdf"=>"2", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"1", "cited-by"=>"0", "year"=>"2018", "month"=>"10"}
  • {"unique-ip"=>"32", "full-text"=>"32", "pdf"=>"3", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"5", "supp-data"=>"1", "cited-by"=>"0", "year"=>"2018", "month"=>"8"}
  • {"unique-ip"=>"37", "full-text"=>"38", "pdf"=>"3", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"2", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"2"}
  • {"unique-ip"=>"41", "full-text"=>"49", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"1", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"3"}
  • {"unique-ip"=>"29", "full-text"=>"38", "pdf"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"4"}
  • {"unique-ip"=>"33", "full-text"=>"37", "pdf"=>"2", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"3", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"5"}
  • {"unique-ip"=>"44", "full-text"=>"47", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"1", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"8"}
  • {"unique-ip"=>"33", "full-text"=>"34", "pdf"=>"5", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"9"}
  • {"unique-ip"=>"27", "full-text"=>"28", "pdf"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2019", "month"=>"10"}
  • {"unique-ip"=>"16", "full-text"=>"17", "pdf"=>"2", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"5", "cited-by"=>"0", "year"=>"2019", "month"=>"12"}
  • {"unique-ip"=>"19", "full-text"=>"16", "pdf"=>"3", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"1", "cited-by"=>"0", "year"=>"2020", "month"=>"2"}
  • {"unique-ip"=>"20", "full-text"=>"22", "pdf"=>"2", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2020", "month"=>"3"}
  • {"unique-ip"=>"21", "full-text"=>"29", "pdf"=>"5", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"1", "cited-by"=>"0", "year"=>"2020", "month"=>"4"}
  • {"unique-ip"=>"30", "full-text"=>"28", "pdf"=>"2", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"4", "supp-data"=>"2", "cited-by"=>"0", "year"=>"2020", "month"=>"5"}
  • {"unique-ip"=>"15", "full-text"=>"13", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"1", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2020", "month"=>"6"}
  • {"unique-ip"=>"14", "full-text"=>"13", "pdf"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2020", "month"=>"7"}
  • {"unique-ip"=>"32", "full-text"=>"32", "pdf"=>"4", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"5", "cited-by"=>"0", "year"=>"2020", "month"=>"8"}
  • {"unique-ip"=>"10", "full-text"=>"11", "pdf"=>"0", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2020", "month"=>"9"}
  • {"unique-ip"=>"15", "full-text"=>"16", "pdf"=>"1", "scanned-summary"=>"0", "scanned-page-browse"=>"0", "figure"=>"0", "supp-data"=>"0", "cited-by"=>"0", "year"=>"2020", "month"=>"10"}
Loading … Spinner
There are currently no alerts