{"id":1458,"date":"2014-12-01T22:44:04","date_gmt":"2014-12-01T23:44:04","guid":{"rendered":"http:\/\/sites.uac.pt\/amendes\/?p=1458"},"modified":"2014-12-01T22:44:04","modified_gmt":"2014-12-01T23:44:04","slug":"spreadsheet-addiction","status":"publish","type":"post","link":"https:\/\/sites.uac.pt\/amendes\/estatistica\/spreadsheet-addiction\/","title":{"rendered":"Spreadsheet Addiction"},"content":{"rendered":"<div id=\"attachment_1459\" style=\"width: 160px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.burns-stat.com\/documents\/tutorials\/spreadsheet-addiction\/\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1459\" class=\"size-full wp-image-1459\" src=\"http:\/\/sites.uac.pt\/amendes\/files\/2014\/12\/logo-150.png\" alt=\"clicar na imagem para seguir o link\" width=\"150\" height=\"146\" \/><\/a><p id=\"caption-attachment-1459\" class=\"wp-caption-text\">clicar na imagem para seguir o link<\/p><\/div>\n<p><span style=\"color: #800000\">Um bom e muito completo relato dos defeitos do MS Excel para an\u00e1lise de dados.<\/span><br \/>\nSome people will think that the \u201caddiction\u201d in the title is over the top, or at least used metaphorically. It is used literally, and is not an exaggeration.<\/p>\n<p>Addiction is the persistent use of a substance where that use is detrimental to the user. It is not the substance that is the problem \u2014 more limited use may be beneficial. It is the extent and circumstances of the use that determine if the behavior is addictive or not.<\/p>\n<p>Spreadsheets are a wonderful invention. They are an excellent tool for what they are good at. The problem is that they are often stretched far beyond their home territory. Dangerous abuse of spreadsheets is only too common.<\/p>\n<p>I know there are many spreadsheets in financial companies that take all night to compute. These are complicated and commonly fail. When such spreadsheets are replaced by code more suited to the task, it is not unusual for the computation time to be cut to a few minutes and the process much easier to understand.<\/p>\n<p>A 2012 example of spreadsheet addiction.<\/p>\n<p>The technology acceptance model holds that there are two main factors that determine the uptake of a technology: the perceived usefulness and the perceived ease-of-use. Perception need not correspond to reality.<\/p>\n<p>The perception of the ease-of-use of spreadsheets is to some extent an illusion. It is dead easy to get an answer from a spreadsheet, however, it is not necessarily easy to get the right answer. Thus the distorted view.<\/p>\n<p>The difficulty of using alternatives to spreadsheets is overestimated by many people. Safety features can give the appearance of difficulty when in fact these are an aid.<\/p>\n<p>The hard way looks easy, the easy way looks hard.<\/p>\n<p>The remainder of this page is divided into the sections:<\/p>\n<p>Spreadsheet Computation<br \/>\nThe Treatment Center (Alternatives)<br \/>\nIf You Must Persist<br \/>\nSpecific Problems with Excel<br \/>\nAdditional Links<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um bom e muito completo relato dos defeitos do MS Excel para an\u00e1lise de dados. Some people will think that the \u201caddiction\u201d in the title is over the top, or at least used metaphorically. It is used literally, and is not an exaggeration. Addiction is the persistent use of a substance where that use is [&hellip;]<\/p>\n","protected":false},"author":159,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[102,150],"tags":[74,123,124],"class_list":["post-1458","post","type-post","status-publish","format-standard","hentry","category-estatistica","category-materiais-para-profissionais","tag-analise-de-dados","tag-excel","tag-programacao-em-folha-de-calculo"],"_links":{"self":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts\/1458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/users\/159"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/comments?post=1458"}],"version-history":[{"count":2,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts\/1458\/revisions"}],"predecessor-version":[{"id":1461,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts\/1458\/revisions\/1461"}],"wp:attachment":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/media?parent=1458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/categories?post=1458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/tags?post=1458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}