[ensembl-dev] Exons numbers in VEP

[Healy, Matthew]

Even if you rarely use Excel, many other people do.  Nearly every public genomics database of nontrivial size contains some data records that have been corrupted by this particular Excel "feature."
________________________________________
From: dev-bounces at ensembl.org [dev-bounces at ensembl.org] On Behalf Of Eva Goncalves Serra [egs at sanger.ac.uk]
Sent: Tuesday, October 28, 2014 7:35 AM
To: Ensembl developers list
Subject: Re: [ensembl-dev] Exons numbers in VEP

Thanks Matthew - I don¹t normally read in these files in Excel so wasn¹t
aware. Thanks a lot!

Eva

On 28/10/2014 11:02, "Healy, Matthew" <Matthew.Healy at bms.com> wrote:

>When importing text into Excel, unless one specifies that a column is
>Text format it will use the General format.  General tries to parse
>calendar dates, which become integers -- count of days since 1Jan 1900
>(assuming 1900 was a leap year, which it was not in the Gregorian
>Calendar, for compatibility with Lotus 1-3-3 format) or on the Mac since
>1904.
>
>So certain fractions that could be dates get munged.  Also certain HGNC
>Gene Symbols like SEPT3 or MARCH1 get munged, so if you're munging Exon
>Numbers you should also check gene symbols!
>
>________________________________________
>From: dev-bounces at ensembl.org [dev-bounces at ensembl.org] On Behalf Of LAW
>Andy [andy.law at roslin.ed.ac.uk]
>Sent: Tuesday, October 28, 2014 6:42 AM
>To: Ensembl developers list
>Subject: Re: [ensembl-dev] Exons numbers in VEP
>
>Has the output file been through Excel at all?
>
>On 28 Oct 2014, at 10:17, Eva Goncalves Serra <egs at sanger.ac.uk> wrote:
>
>> Hi,
>>
>> After running VEP I realised that some variations do have numbers like
>>Œ46569¹ in the Exons number field, rather than for example ¹18/20¹. Does
>>anyone know why this is?
>>
>> Thanks very much,
>>
>> Eva
>> _______________________________________________
>> Dev mailing list    Dev at ensembl.org
>> Posting guidelines and subscribe/unsubscribe info:
>>http://lists.ensembl.org/mailman/listinfo/dev
>> Ensembl Blog: http://www.ensembl.info/
>
>
>--
>The University of Edinburgh is a charitable body, registered in
>Scotland, with registration number SC005336.
>
>
>_______________________________________________
>Dev mailing list    Dev at ensembl.org
>Posting guidelines and subscribe/unsubscribe info:
>http://lists.ensembl.org/mailman/listinfo/dev
>Ensembl Blog: http://www.ensembl.info/
>
>This message (including any attachments) may contain confidential,
>proprietary, privileged and/or private information.  The information is
>intended to be for the use of the individual or entity designated above.
>If you are not the intended recipient of this message, please notify the
>sender immediately, and delete the message and any attachments.  Any
>disclosure, reproduction, distribution or other use of this message or
>any attachments by an individual or entity other than the intended
>recipient is prohibited.
>
>_______________________________________________
>Dev mailing list    Dev at ensembl.org
>Posting guidelines and subscribe/unsubscribe info:
>http://lists.ensembl.org/mailman/listinfo/dev
>Ensembl Blog: http://www.ensembl.info/


_______________________________________________
Dev mailing list    Dev at ensembl.org
Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
Ensembl Blog: http://www.ensembl.info/

This message (including any attachments) may contain confidential, proprietary, privileged and/or private information.  The information is intended to be for the use of the individual or entity designated above.  If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments.  Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited.