Boing Boing Staging

Genetic research irreversibly damaged by Excel autoformatting

The Autocorrect feature in Excel (which drives me bonkers across the whole Office suite) has introduced irreversible errors into genetic research that is tabulated in spreadsheets, because Except autocorrects some identifiers to be dates.

Excel is widely used in genetic research to process microarray data. A microarray chip detects amounts of protein produced from thousands of different genes, enabling researchers to see which particular gene is being expressed in a sample of diseased tissue, for example.

The errors are introduced because some genetic identifiers look very like dates to Excel. If the spreadsheet is not properly set up, it will convert an identifier, such as SEPT2 to a date: 2-Sep. The conversion, the researchers say, is irreversible: once the error has been introduced, the original data is gone.

Link

(via Futurismic)

Exit mobile version