Microsoft Excel blamed for gene study errors
Microsoft's Excel has been blamed for errors in academic papers on genomics, the BBC reports.
Researchers trying to raise awareness of the issue claim that the spreadsheet software automatically converts the names of certain genes into dates.
Gene symbols like SEPT2 (Septin 2) were found to be altered to "September 2".
However, Microsoft, which released the first version of Excel in 1985, said the gene renaming errors can be overcome if users make alterations in the application settings.
"Excel is able to display data and text in many different ways. Default settings are intended to work in most day-to-day scenarios," a spokeswoman for the corporation told the BBC.
"Excel offers a wide range of options, which customers with specific needs can use to change the way their data is represented."
The study also claimed that the Excel conversion problem was present in other spreadsheet software, such as Apache OpenOffice Calc.
The systemic error was not, however, present in Google Sheets.
The researchers claimed the problem is present in "approximately one-fifth of papers" that collated data in Excel documents.
The trio, writing for the Melbourne-based academic institute Baker IDI, scanned 3,597 published scientific papers to conduct their study.
They found 704 of those papers contained gene name errors created by Excel.
Ewan Birney, director of the European Bioinformatics Institute, does not blame Excel and told the BBC: "What frustrates me is researchers are relying on Excel spreadsheets for clinical trials."
The Excel gene renaming issue has been known among the scientific community for more than a decade, Birney added.
He recommended that the program should only be considered for "lightweight scientific analysis".
One of the paper's three researchers, Assam El-Osta, said the errors were found specifically on the supplemental data sheets of academic studies.
He told the BBC that supplemental pages contained "important supporting data, rich with information," and added that resolving these errors was "time-consuming".
Excel's automatic renaming of certain genes was first cited by the scientific community back in 2004, the Baker IDI study claims. Since then the problem has "increased at an annual rate of 15%" over the past five years.
Videos
Interview with Francis Malige, EBRD Managing Director
Armenians Commemorating 106th Anniversary of Genocide
Biden Under Pressure to Recognize Armenian Genocide - KTLA 5 News
Governance and Oversight Capacities Account for Our Bank's Robust Management System - Philip Lynch, Independent Board Member at Ameriabank
'Mr. President, It Is Now in Your Power to Right Decades of Denial' - US Congressman Adam Schiff Urges Joe Biden to Recognize Armenian Genocide
Armenians of Nagorno-Karabakh in Despair After Trauma of Military Defeat - France 24
Interview with Kakhaber Kiknavelidze, an Independent Member of Ameriabank Board of Directors
Only Terrorists Keep Hostages, Putting Forward Preconditions for Their Release - Edmon Marukyan
Rep Adam Schiff Says Congress Should Recognize Artsakh
UN's Guterres Issues Global Appeal to Make 2021 'Year of Healing'
NASA's Mars 2020 Perseverance Rover Landing Animations
Azerbaijan Uses Prohibited Phosphorus Chemical Munitions - Defense Army Video
Artsakh Defense Army Units Neutralizing Azerbaijani Arms Supplies
Artsakh Defense Army Units Neutralizing Azerbaijani Drone
Nagorno-Karabakh's Status Has Been At the Heart of Our Approach - Zohrab Mnatsakanyan
Artsakh Defense Army Releases Video Featuring Damaged Azerbaijani Military Equipment
Artsakh Defense Army Units Inflicting Manpower Losses on Azerbaijan
Gas Pipeline Damaged in Azerbaijani Fire Targeting Nagorno-Karabakh's Capital
President Armen Sarkissian Meets Emmanuel Macron at Élysée Palace
Artsakh Defense Army Neutralizes Azerbaijani Military Hardware
Artsakh Defense Army Units Neutralizing Azerbaijani Military Infrastructures
President Armen Sarkissian Meets with NATO Secretary-General in Brussels
Buildings and Homes Lying in Ruins in Nagorno-Karabakh's Capital After Azerbaijani Shelling
Artsakh Defense Army's Precision Fire Gives Deadly Blow to Enemy
Artsakh Defense Army Units Destroying Azerbaijani Tank
Zohrab Mnatsakanyan: Ceasefire Does not Mandate Azerbaijan to Kill Civilians and Hit Civilian Settlements
Armenians Protest Outside Turkrish Embassy in Los Angeles
Losses in Azerbaijan's Military Featured in Defense Army Footage
Artsakh Defense Army Neutralizing Adversary's Transport Column
Turkey openly backs Azerbaijan 'far more aggressively than in the past' - ABC News on Syrian mercenaries fighting in Karabakh
Iconic Armenian Church Hit in Azerbaijani Attacks in Nagorno-Karabakh City (photos)
Artsakh Defense Army Continues High-Precision Strikes
War Situation in Karabakh on European Parliament's Agenda
Call for Urgent Action: Armenian Journalist Brings Intn'l Colleagues' Attention to Situation iin Artsakh After Azerbaijani Attacks
Turkey's Support to Syrian Mercenaries Fighting Against Artsakh: Facts About Azerbaijani Aggression
Nagorno-Karabakh's Capital Under Azerbaijani Strikes
Armenian Armed Forces Neutralize Azerbaijani Defense Positions
ArmenianTroops Destroy Azerbaijani Armored Fighting Vehicle on Frontline
There is a solid evidence that Azerbaijan has launched a thoroughly planned attack on the NKR
EU calls for Immediate End to Hostilities over Nagorno-Karabakh
- 15:20 • 24.05.21 Interview with Francis Malige, EBRD Managing Director
- 11:39 • 24.04.21 Armenians Commemorating 106th Anniversary of Genocide
- 09:40 • 23.04.21 Biden Under Pressure to Recognize Armenian Genocide - KTLA 5 News
- 15:34 • 22.04.21 Governance and Oversight Capacities Account for Our Bank's Robust Management System - Philip Lynch, Independent Board Member at Ameriabank
- 14:09 • 21.04.21 'Mr. President, It Is Now in Your Power to Right Decades of Denial' - US Congressman Adam Schiff Urges Joe Biden to Recognize Armenian Genocide
- 12:37 • 03.04.21 Armenians of Nagorno-Karabakh in Despair After Trauma of Military Defeat - France 24
- 17:33 • 11.03.21 Interview with Kakhaber Kiknavelidze, an Independent Member of Ameriabank Board of Directors
- 17:57 • 26.01.21 Only Terrorists Keep Hostages, Putting Forward Preconditions for Their Release - Edmon Marukyan
- 13:33 • 22.01.21 Rep Adam Schiff Says Congress Should Recognize Artsakh
- 09:42 • 29.12.20 UN's Guterres Issues Global Appeal to Make 2021 'Year of Healing'
- 18:41 • 24.12.20 NASA's Mars 2020 Perseverance Rover Landing Animations
- 13:33 • 31.10.20 Azerbaijan Uses Prohibited Phosphorus Chemical Munitions - Defense Army Video
- 16:37 • 30.10.20 Artsakh Defense Army Units Neutralizing Azerbaijani Arms Supplies
- 11:25 • 28.10.20 Artsakh Defense Army Units Neutralizing Azerbaijani Drone
- 13:45 • 24.10.20 Nagorno-Karabakh's Status Has Been At the Heart of Our Approach - Zohrab Mnatsakanyan
- 11:51 • 24.10.20 Artsakh Defense Army Releases Video Featuring Damaged Azerbaijani Military Equipment
- 11:40 • 24.10.20 Artsakh Defense Army Units Inflicting Manpower Losses on Azerbaijan
- 10:39 • 24.10.20 Gas Pipeline Damaged in Azerbaijani Fire Targeting Nagorno-Karabakh's Capital
- 12:41 • 23.10.20 President Armen Sarkissian Meets Emmanuel Macron at Élysée Palace
- 12:16 • 23.10.20 Artsakh Defense Army Neutralizes Azerbaijani Military Hardware
- 12:02 • 22.10.20 Artsakh Defense Army Units Neutralizing Azerbaijani Military Infrastructures
- 10:35 • 22.10.20 President Armen Sarkissian Meets with NATO Secretary-General in Brussels
- 10:51 • 17.10.20 Buildings and Homes Lying in Ruins in Nagorno-Karabakh's Capital After Azerbaijani Shelling
- 15:09 • 15.10.20 Artsakh Defense Army's Precision Fire Gives Deadly Blow to Enemy
- 13:13 • 13.10.20 Artsakh Defense Army Units Destroying Azerbaijani Tank
- 12:56 • 12.10.20 Zohrab Mnatsakanyan: Ceasefire Does not Mandate Azerbaijan to Kill Civilians and Hit Civilian Settlements
- 12:23 • 12.10.20 Armenians Protest Outside Turkrish Embassy in Los Angeles
- 17:23 • 09.10.20 Losses in Azerbaijan's Military Featured in Defense Army Footage
- 15:53 • 09.10.20 Artsakh Defense Army Neutralizing Adversary's Transport Column
- 14:11 • 09.10.20 Turkey openly backs Azerbaijan 'far more aggressively than in the past' - ABC News on Syrian mercenaries fighting in Karabakh
- 15:52 • 08.10.20 Iconic Armenian Church Hit in Azerbaijani Attacks in Nagorno-Karabakh City (photos)
- 10:57 • 08.10.20 Artsakh Defense Army Continues High-Precision Strikes
- 14:24 • 07.10.20 War Situation in Karabakh on European Parliament's Agenda
- 19:31 • 05.10.20 Call for Urgent Action: Armenian Journalist Brings Intn'l Colleagues' Attention to Situation iin Artsakh After Azerbaijani Attacks
- 16:17 • 04.10.20 Turkey's Support to Syrian Mercenaries Fighting Against Artsakh: Facts About Azerbaijani Aggression
- 12:39 • 04.10.20 Nagorno-Karabakh's Capital Under Azerbaijani Strikes
- 13:49 • 03.10.20 Armenian Armed Forces Neutralize Azerbaijani Defense Positions
- 10:12 • 29.09.20 ArmenianTroops Destroy Azerbaijani Armored Fighting Vehicle on Frontline
- 23:42 • 28.09.20 There is a solid evidence that Azerbaijan has launched a thoroughly planned attack on the NKR
- 18:45 • 28.09.20 EU calls for Immediate End to Hostilities over Nagorno-Karabakh
Most popular articles Today Yesterday For a week
-
Economy 17:01 • 22/03 Marzes remain in the focus of attention of Viva-MTS: New service center opened in Tchambarak Taking care of society, which is a core principle at Viva-MTS, has also been part of life of the Company’s staff members. Years ago, sanitary facility was built in the school with around AMD 2 million raised by the Finance and Administration Department staff.
-
Event 15:22 • 26/03 “START+”: “Kinodaran” without subscription fee, 10 GB internet, 1000 minutes and favorite apps without any limits To mention, the subscribers to “START+” tariff plan use “Kinodaran” with no subscription fee, and when using the favorite top applications, the main Internet-package is not consumed.
-
Event 10:38 • 26/03 Ucom Launches Network Modernization Efforts in Regions of Armenia With the first batch from planned shipments of this year Ucom received an up-to-date systems and radio modules from Nokia. These up-to-date modules will be utilized to modernize a portion of Ucom’s regional sites enhancing coverage in those areas and extending LTE technology.
Event
-
10:38 • 26.03.24 Ucom Launches Network Modernization Efforts in Regions of Armenia