{"id":131348,"date":"2016-08-24T06:15:41","date_gmt":"2016-08-24T12:15:41","guid":{"rendered":"http:\/\/hill-kleerup.org\/blog\/2016\/08\/24\/when-excel-makes-genetic-problems-worse.html"},"modified":"2016-08-24T06:15:41","modified_gmt":"2016-08-24T12:15:41","slug":"when-excel-makes-genetic-problems-worse","status":"publish","type":"post","link":"https:\/\/hill-kleerup.org\/blog\/2016\/08\/24\/when-excel-makes-genetic-problems-worse.html","title":{"rendered":"When Excel makes genetic problems worse"},"content":{"rendered":"<p>Not that Excel actual genetic damage (I don&#39;t think) but that common gene references in genetic research get misinterpreted and autocorrected \/ auto formatted into something quite different, resulting in a significant number of (poorly proofread) papers being published with such errors.<\/p><\/blockquote>\n<blockquote class=\"sm2wp\"><p>\n<a style='display:inline;' href='http:\/\/www.winbeta.org\/news\/20-of-scientific-papers-on-genes-contain-gene-name-conversion-errors-caused-by-excel'><br \/>\n<img src='https:\/\/lh3.googleusercontent.com\/proxy\/1Mog8cMzWGdMcpgUs_BhP1lIiQbO6KOGUbJDihPg-dhojZdvtfLLPLUgtKNMmDy2nIlXOnvx32FZYPrAmj6pBMsCI-ENTxu7xUZ-uU1g=w506-h910' border='0' style='max-width:650px;'\/><br \/>\n<\/a><br \/>\n<span style='font-size:large;'><a href='http:\/\/www.winbeta.org\/news\/20-of-scientific-papers-on-genes-contain-gene-name-conversion-errors-caused-by-excel'>20% of scientific papers on genes contain gene name conversion errors caused by Excel<\/a><\/span><br \/>\nAccording to three scientists, Mark Ziemann, Yotam Eren, and Assam El-Osta, Microsoft Excel has trouble converting with gene names.\n<\/p><\/blockquote>\n<p><span style='font-size:small;'><a href='https:\/\/plus.google.com\/+DaveHill47\/posts\/NDvjdhHGGEH'>View on Google+<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Not that Excel actual genetic damage (I don&#39;t think) but that common gene references in genetic research get misinterpreted and autocorrected \/ auto formatted into something quite different, resulting in a significant number of (poorly proofread) papers being published with such errors. 20% of scientific papers on genes contain gene name conversion errors caused by &hellip; <a href=\"https:\/\/hill-kleerup.org\/blog\/2016\/08\/24\/when-excel-makes-genetic-problems-worse.html\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;When Excel makes genetic problems worse&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[106],"tags":[],"class_list":["post-131348","post","type-post","status-publish","format-standard","hentry","category-plusposts"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5788,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/07\/18\/frankensteins_e.html","url_meta":{"origin":131348,"position":0},"title":"Frankenstein&#8217;s #ERROR","author":"***Dave","date":"Sun 18-Jul-04 1:56pm","format":false,"excerpt":"US geneticists are having big problems with data stored in Excel. The problem, which can cause medically important genes to be hidden from view, is widespread, and has affected some...","rel":"","context":"In &quot;Hi-Tech&quot;","block_context":{"text":"Hi-Tech","link":"https:\/\/hill-kleerup.org\/blog\/category\/hi-tech"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":33214,"url":"https:\/\/hill-kleerup.org\/blog\/2013\/04\/16\/the-excel-error-that-drove-economic-policy-off-a-cliff.html","url_meta":{"origin":131348,"position":1},"title":"The Excel error that drove economic policy off a cliff","author":"***Dave","date":"Tue 16-Apr-13 5:45pm","format":false,"excerpt":"It's useful to show your work, because then people can point out errors in it. \u00a0Such as Excel range miscalculations that skew your results.That would seem a relatively trivial thing, except that Carmen Reinhart and Kenneth Rogoff's paper \"Growth in a Time of Debt\" (2010) is cited all over the\u2026","rel":"","context":"In &quot;~PlusPosts&quot;","block_context":{"text":"~PlusPosts","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/plusposts"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8890,"url":"https:\/\/hill-kleerup.org\/blog\/2006\/03\/29\/sinister.html","url_meta":{"origin":131348,"position":2},"title":"Sinister","author":"***Dave","date":"Wed 29-Mar-06 9:08am","format":false,"excerpt":"A summary of current science on handedness. Not much new info here for someone who's read up on the subject, but still interesting. Whatever evolutionary jog made humans left-brain dominant...","rel":"","context":"In &quot;Science &amp; Nature&quot;","block_context":{"text":"Science &amp; Nature","link":"https:\/\/hill-kleerup.org\/blog\/category\/science"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13339,"url":"https:\/\/hill-kleerup.org\/blog\/2009\/01\/17\/yeah_this_is_likely_to_en.html","url_meta":{"origin":131348,"position":3},"title":"Yeah, this is likely to end well &#8230;","author":"***Dave","date":"Sat 17-Jan-09 12:11pm","format":false,"excerpt":"I see a SciFi Original Movie coming in ... Amateurs are trying genetic engineering at home - Yahoo! News\u00a0 SAN FRANCISCO \u2013 The Apple computer was invented in a garage....","rel":"","context":"In &quot;Science &amp; Nature&quot;","block_context":{"text":"Science &amp; Nature","link":"https:\/\/hill-kleerup.org\/blog\/category\/science"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9657,"url":"https:\/\/hill-kleerup.org\/blog\/2006\/05\/17\/giving_new_mean.html","url_meta":{"origin":131348,"position":4},"title":"Giving new meaning to &#8220;hot monkey sex&#8221;","author":"***Dave","date":"Wed 17-May-06 3:29pm","format":false,"excerpt":"A new, more extensive study of DNA variations between humans and chimps seems to indicate that the speciation between the two (or their respective ancestors) was an on-again, off-again matter....","rel":"","context":"In &quot;Science &amp; Nature&quot;","block_context":{"text":"Science &amp; Nature","link":"https:\/\/hill-kleerup.org\/blog\/category\/science"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11490,"url":"https:\/\/hill-kleerup.org\/blog\/2007\/08\/15\/excel_hiccups.html","url_meta":{"origin":131348,"position":5},"title":"Excel hiccups","author":"***Dave","date":"Wed 15-Aug-07 11:11am","format":false,"excerpt":"I'm sure I read something about this somewhere, sometime, but damned if I can figure out where. My Excel installation has suddenly decided that it's going to pause every minute...","rel":"","context":"In &quot;My Computer&quot;","block_context":{"text":"My Computer","link":"https:\/\/hill-kleerup.org\/blog\/category\/my-computer"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/131348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/comments?post=131348"}],"version-history":[{"count":0,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/131348\/revisions"}],"wp:attachment":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media?parent=131348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/categories?post=131348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/tags?post=131348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}