<i>Even scientists sometimes have IT problems. But this one actually made them change the names of genes.</i> <center> </center> Image by <a href="https://pixabay.com/users/aitoff-388338/?utm_source=link-attribution&utm_medium=referral&utm_campaign=image&utm_content=1951987" class="keychainify-checked steem-keychain-checked">Andrew Martin</a> from <a href="https://pixabay.com/?utm_source=link-attribution&utm_medium=referral&utm_campaign=image&utm_content=1951987" class="keychainify-checked steem-keychain-checked">Pixabay</a> * Be also sure to check out my other posts and follow me @kralizec and subscribe to my Youtube channel at [Kralizec Gaming Youtube Channel](https://www.youtube.com/channel/UCM6bVobsVUBzJ-oqajqI-eA) <h3></h3> The HUGO Gene Nomenclature Committee (HGNC) came up with a new directive that regulates the naming of genes. But, the reasons why changes need to be done may surprise you. It is being done because scientists had a problem writing down some of the names of the genes into Microsoft Excel. <h3></h3> Just in the past year, 27 human genes were renamed for this reason. Microsoft’s Excel interchanged them with dates and converted them. For example, the gene called Membrane Associated Righ-CH-Type Finger 1 or MARCH1 was converted into 1-Mar. And this definitely wasn't the only case as several genes have shortcuts that look like months of the year. In a study back in 2016 researchers analyzed what is the rate at which these errors occur. They analyzed more than 3,500 research papers and found out that more than one-fifth of all of them had a problem when writing down genes in Microsoft Excel. <h3></h3> Since Microsoft’s Excel doesn’t allow users to switch off automatic formatting the only way to fix the errors was to manually change the type of data in the individual columns. But, if the file was opened by someone else on another computer the formatting would switch back to the wrong one. Right now, you might be asking yourself – wouldn’t it be easier if Microsoft changed Excel? Well, Elspeth Bruford from HGNC thinks the problem is so specific Microsoft just won’t care. <h4>Sources:</h4> * https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 * https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates --- * If you like the content I’m producing about science maybe you will like the content I produce about gaming as well! Be sure to check out my other posts!
author | kralizec |
---|---|
permlink | how-microsoft-excel-changed-the-names-of-genes |
category | hive-196387 |
json_metadata | {"app":"peakd/2020.08.3","format":"markdown","tags":["science","stem","news","blog","hive"],"users":["kralizec"],"links":["https://pixabay.com/users/aitoff-388338/?utm_source=link-attribution&utm_medium=referral&utm_campaign=image&utm_content=1951987","https://pixabay.com/?utm_source=link-attribution&utm_medium=referral&utm_campaign=image&utm_content=1951987","/@kralizec","https://www.youtube.com/channel/UCM6bVobsVUBzJ-oqajqI-eA","https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7","https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates"],"image":["https://files.peakd.com/file/peakd-hive/kralizec/50PsSsVc-problem-1951987_1920.jpg"]} |
created | 2020-08-17 06:00:06 |
last_update | 2020-08-17 06:00:06 |
depth | 0 |
children | 3 |
last_payout | 2020-08-24 06:00:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 3.072 HBD |
curator_payout_value | 2.700 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 2,622 |
author_reputation | 228,510,658,450,281 |
root_title | "How Microsoft Excel Changed The Names Of Genes" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,113,909 |
net_rshares | 15,626,043,846,558 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
onealfa | 0 | 8,520,256,831 | 0.44% | ||
livingfree | 0 | 407,078,752,027 | 4% | ||
kralizec | 0 | 193,788,118,425 | 100% | ||
created | 0 | 667,281,887,352 | 4% | ||
zorg67 | 0 | 638,879,379 | 100% | ||
lovemetouchme2 | 0 | 15,826,912,022 | 15% | ||
automaton | 0 | 6,553,779,378 | 100% | ||
mys | 0 | 2,703,601,794 | 1.5% | ||
mxzn | 0 | 1,202,882,782 | 10.01% | ||
whd | 0 | 2,000,315,490 | 1.5% | ||
edkarnie | 0 | 181,845,395,610 | 100% | ||
tykee | 0 | 5,794,806,983 | 50% | ||
arvindkumar | 0 | 10,044,122,816 | 50.1% | ||
aafeng | 0 | 38,939,047,312 | 10% | ||
tipu | 0 | 8,096,566,808,220 | 20.02% | ||
fbslo | 0 | 2,780,419,835 | 0.75% | ||
yorkchinese | 0 | 33,495,368 | 20% | ||
kamchore | 0 | 141,302,801,087 | 100% | ||
smjn | 0 | 514,536,650,977 | 75% | ||
fragmentarion | 0 | 10,256,264,274 | 50% | ||
bala41288 | 0 | 28,626,145,837 | 10% | ||
happy-soul | 0 | 71,231,023,267 | 10.01% | ||
whack.science | 0 | 37,284,063,658 | 10% | ||
idkpdx | 0 | 380,152,848 | 2.5% | ||
amico | 0 | 16,325,108,388 | 1% | ||
beleg | 0 | 647,862,742 | 1.5% | ||
gadrian | 0 | 54,737,580,555 | 35% | ||
tonimontana | 0 | 659,119,728 | 23.46% | ||
statsexpert | 0 | 89,078,400 | 20% | ||
stefannikolov | 0 | 1,083,105,225 | 10.01% | ||
archisteem | 0 | 2,560,525,887 | 7.5% | ||
luminaryhmo | 0 | 6,454,883,511 | 100% | ||
longer | 0 | 2,463,844,767 | 5% | ||
donald.porter | 0 | 17,286,073,705 | 40.04% | ||
jk6276 | 0 | 0 | 1% | ||
julian2013 | 0 | 1,038,626,080 | 0.67% | ||
gordonramzy | 0 | 593,477,675 | 100% | ||
trisquelwhare | 0 | 4,674,910,076 | 100% | ||
jessica.steem | 0 | 563,967,301 | 100% | ||
laissez-faire | 0 | 97,024,183 | 100% | ||
loveprevails | 0 | 172,178,677 | 20% | ||
chibera | 0 | 118,282,028,768 | 100% | ||
balticbadger | 0 | 6,196,844,588 | 25% | ||
anti-bully | 0 | 1,302,606,266 | 100% | ||
dein-problem | 0 | 0 | -0.05% | ||
elkaos | 0 | 1,940,917,520 | 45% | ||
xxxxxxxxxx | 0 | 475,555,735,763 | 5% | ||
aqua.nano | 0 | 6,597,136,254 | 100% | ||
limka | 0 | 27,769,244 | 10% | ||
mia-cc | 0 | 2,560,079,671 | 20.02% | ||
samuel.steem | 0 | 962,140,330 | 100% | ||
paolo.senegal | 0 | 1,419,213,123 | 100% | ||
ylania | 0 | 4,397,770,527 | 20% | ||
quantumdeveloper | 0 | 2,489,680,054 | 50% | ||
maruskina | 0 | 31,343,516,991 | 50% | ||
travelwritemoney | 0 | 20,857,250,131 | 5% | ||
nalacanecorso | 0 | 1,205,459,225 | 100% | ||
jalentakesphotos | 0 | 475,558,506 | 10% | ||
babytarazkp | 0 | 5,570,855,498 | 85% | ||
thranax | 0 | 17,472,247,566 | 15% | ||
btc4breackfast | 0 | 1,845,765,630 | 100% | ||
pukeko | 0 | 0 | 1% | ||
vxc.stem | 0 | 0 | 23.46% | ||
bcm | 0 | 10,650,696,016 | 15.01% | ||
stemd | 0 | 326,103,806 | 100% | ||
drveni | 0 | 1,369,987,807 | 20% | ||
axel-blaze | 0 | 1,501,896,662,702 | 100% | ||
yggdrasil.laguna | 0 | 33,534,563 | 15% | ||
atheistrepublic | 0 | 305,867,975,050 | 100% | ||
pecoshop | 0 | 1,857,414,941 | 100% | ||
stem.curate | 0 | 937,708,312 | 100% | ||
stemisaria | 0 | 1,922,731,587 | 100% | ||
boomalex | 0 | 2,519,933,953 | 100% | ||
machete9595 | 0 | 2,429,742,415 | 100% | ||
innerhive | 0 | 1,207,320,438,115 | 5% | ||
hiveyoda | 0 | 13,371,420,246 | 4% | ||
gitplait | 0 | 59,826,484,441 | 100% | ||
peterpanpan | 0 | 94,943,727,624 | 100% | ||
honeycombs | 0 | 2,979,569,128 | 1% | ||
life-timer | 0 | 1,162,623,189,725 | 15% |
Upvoted by GITPLAIT! We have a curation trial on Hive.vote. you can earn a passive income by delegating to [@gitplait](https://hive.vote/dash.php?i=15&id=1&user=gitplait) We share 80 % of the curation rewards with the delegators. ___ _To delegate, use the links or adjust_ [10HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=10%20HP), [20HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=20%20HP), [50HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=50%20HP), [100HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=100%20HP), [200HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=200%20HP), [500HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=500%20HP), [1,000HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=1000%20HP), [10,000HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=10000%20HP), [100,000HIVE](https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=100000%20HP) ___ Join the [Community](https://hive.blog/trending/hive-103590) and chat with us on [Discord](https://discord.gg/CWCj3rw) let’s solve problems & build together.
author | gitplait |
---|---|
permlink | qf81jp |
category | hive-196387 |
json_metadata | {"links":["https://hive.vote/dash.php?i=15&id=1&user=gitplait","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=10%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=20%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=50%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=100%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=200%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=500%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=1000%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=10000%20HP","https://hivesigner.com/sign/delegateVestingShares?delegator=&delegatee=gitplait&vesting_shares=100000%20HP","https://hive.blog/trending/hive-103590","https://discord.gg/CWCj3rw"],"app":"hiveblog/0.1"} |
created | 2020-08-17 18:48:00 |
last_update | 2020-08-17 18:48:00 |
depth | 1 |
children | 0 |
last_payout | 2020-08-24 18:48:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,493 |
author_reputation | 911,220,543,569 |
root_title | "How Microsoft Excel Changed The Names Of Genes" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,124,438 |
net_rshares | 0 |
I wonder whether the same issue pops up in other spreadsheet programs like LibreOffice? I am not on my computer right now, so I can't test it.
author | jacobtothe |
---|---|
permlink | re-kralizec-qf77ds |
category | hive-196387 |
json_metadata | {"tags":["hive-196387"],"app":"peakd/2020.08.3"} |
created | 2020-08-17 07:56:21 |
last_update | 2020-08-17 07:56:21 |
depth | 1 |
children | 1 |
last_payout | 2020-08-24 07:56:21 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.022 HBD |
curator_payout_value | 0.023 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 142 |
author_reputation | 566,903,957,379,763 |
root_title | "How Microsoft Excel Changed The Names Of Genes" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,115,013 |
net_rshares | 193,788,118,425 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
kralizec | 0 | 193,788,118,425 | 100% |
I do not know. Though, since they specifically mentioned the fact that you cannot change the setting in Microsoft Excel there is a good chance you can change these settings in other programs. If you like my science content consider following my gaming stuff as well and perhaps even subscribe to the [Kralizec Gaming Youtube Channel](https://www.youtube.com/channel/UCM6bVobsVUBzJ-oqajqI-eA)
author | kralizec |
---|---|
permlink | re-jacobtothe-qf7po3 |
category | hive-196387 |
json_metadata | {"tags":["hive-196387"],"app":"peakd/2020.08.3"} |
created | 2020-08-17 14:31:15 |
last_update | 2020-08-17 14:31:15 |
depth | 2 |
children | 0 |
last_payout | 2020-08-24 14:31:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.013 HBD |
curator_payout_value | 0.013 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 392 |
author_reputation | 228,510,658,450,281 |
root_title | "How Microsoft Excel Changed The Names Of Genes" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,120,354 |
net_rshares | 116,384,252,143 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
jacobtothe | 0 | 116,384,252,143 | 25% |