{"id":38,"date":"2014-10-31T06:00:18","date_gmt":"2014-10-31T05:00:18","guid":{"rendered":"http:\/\/pensalla.cat\/?p=38"},"modified":"2014-12-27T21:14:23","modified_gmt":"2014-12-27T20:14:23","slug":"linternauta-del-31-doctubre-de-2014","status":"publish","type":"post","link":"https:\/\/pensalla.cat\/?p=38","title":{"rendered":"De les xifres d&#8217;audi\u00e8ncia a l&#8217;audi\u00e8ncia activa &#8211; L&#8217;Internauta del 31 d&#8217;octubre de 2014"},"content":{"rendered":"<div style=\"padding-top:0px;\t\r\npadding-right:0px;\r\npadding-bottom:0px;\r\npadding-left:0px;\r\nmargin-top:0px;\r\nmargin-right:0px;\r\nmargin-bottom:0px;\r\nmargin-left:0px;\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" \r\n\t\t\t\t        data-url=\"https:\/\/pensalla.cat\/?p=38\" \r\n\t\t\t\t        data-via=\"jjofra\"\r\n\t\t\t\t\t    data-text=\"De les xifres d'audi\u00e8ncia a l'audi\u00e8ncia activa - L'Internauta del 31 d'octubre de 2014\"\r\n\t\t\t\t\t    data-related=\"\"\r\n\t\t\t\t\t    data-count=\"none\"\r\n\t\t\t\t\t    data-hashtags=\"\"\r\n\t\t\t\t\t    data-lang=\"autoLANGauto\"\r\n\t\t\t\t\t    data-counturl=\"pensalla.cat\"\r\n\t\t\t\t\t    data-size=\"medium\"\r\n\t\t\t\t\t    data-dnt=\"false\"\t> Tweet <\/a> <\/div>\r\n\t\t                <script>\r\n\t\t\t\t\t    !function(d,s,id) {\r\n\t\t\t\t\t      var js,fjs=d.getElementsByTagName(s)[0];\r\n\t\t\t\t\t      if(!d.getElementById(id)) {\r\n\t\t\t\t\t       js=d.createElement(s);js.id=id;js.src=\"https:\/\/platform.twitter.com\/widgets.js\";fjs.parentNode.insertBefore(js,fjs);\r\n\t\t\t\t\t      }\r\n\t\t\t\t\t    }\r\n\t\t\t\t\t   (document,\"script\",\"twitter-wjs\");\r\n\t\t\t\t\t    <\/script><table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table id=\"templateHeader\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table class=\"templateContainer\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"headerContainer\" valign=\"top\">\n<table class=\"mcnImageBlock\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody class=\"mcnImageBlockOuter\">\n<tr>\n<td class=\"mcnImageBlockInner\" valign=\"top\">\n<table class=\"mcnImageContentContainer\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\n<tbody>\n<tr>\n<td class=\"mcnImageContent\" valign=\"top\"><a class=\"\" title=\"\" href=\"http:\/\/www.elpuntavui.tv\/video.html?view=video&amp;video_id=110703110\" target=\"_blank\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"mcnImage\" src=\"https:\/\/i0.wp.com\/gallery.mailchimp.com\/8ebfe63be3603515c0fc41244\/images\/94e8c4c5-16d0-4e97-b8b3-131fcfba9623.png?w=564&#038;ssl=1\" alt=\"\"  align=\"center\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table id=\"templateBody\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table class=\"templateContainer\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"bodyContainer\" valign=\"top\">\n<table class=\"mcnTextBlock\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody class=\"mcnTextBlockOuter\">\n<tr>\n<td class=\"mcnTextBlockInner\" valign=\"top\">\n<table class=\"mcnTextContentContainer\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\n<tbody>\n<tr>\n<td class=\"mcnTextContent\" valign=\"top\">\n<h1>Per a qu\u00e8 serveix l&#8217;Excel (i 2)?<\/h1>\n<p>Aquesta setmana, a\u00a0<a href=\"http:\/\/www.vilaweb.cat\/linternauta\" target=\"_blank\">l\u2019Internauta<\/a>\u00a0de\u00a0<a href=\"http:\/\/vilaweb.cat\/\" target=\"_blank\">Vilaweb<\/a>\u00a0i\u00a0<a href=\"http:\/\/www.elpuntavui.tv\/programes\/linternauta.html\" target=\"_blank\">ElPuntAvuiTV<\/a>: Confessions d&#8217;un dinosaure digital explicant\u00a0per a qu\u00e8 serveix l&#8217;Excel (segona part),\u00a0<a href=\"https:\/\/uwhisp.com\/w\/zs1\" target=\"_blank\">\u00e0udio<\/a>\u00a0i\/o\u00a0<a href=\"http:\/\/www.vilaweb.cat\/noticia\/4217451\/20141101\/serveix-lexcel-2.html\" target=\"_blank\">text<\/a><\/p>\n<p>Joan Jofra<br \/>\nAra els diumenges a les 17h a\u00a0<a href=\"http:\/\/www.elpuntavui.tv\/programes\/linternauta.html\" target=\"_blank\">ElPuntAvuiTV<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table id=\"templateColumns\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table class=\"templateContainer\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"columnsContainer\" align=\"left\" valign=\"top\" width=\"50%\">\n<table class=\"templateColumn\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\n<tbody>\n<tr>\n<td class=\"leftColumnContainer\" valign=\"top\">\n<table class=\"mcnCaptionBlock\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody class=\"mcnCaptionBlockOuter\">\n<tr>\n<td class=\"mcnCaptionBlockInner\" valign=\"top\">\n<table class=\"mcnCaptionBottomContent\" border=\"0\" width=\"false\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\n<tbody>\n<tr>\n<td class=\"mcnCaptionBottomImageContent\" align=\"center\" valign=\"top\"><a class=\"\" title=\"\" href=\"http:\/\/www.vilaweb.cat\/noticia\/4217451\/20141101\/serveix-lexcel-2.html\" target=\"_blank\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"mcnImage\" src=\"https:\/\/i0.wp.com\/gallery.mailchimp.com\/8ebfe63be3603515c0fc41244\/images\/04838eaa-9520-4ba5-9cbb-ecdc1deb30d8.jpg?w=264&#038;ssl=1\" alt=\"\"  \/><\/a><\/td>\n<\/tr>\n<tr>\n<td class=\"mcnTextContent\" valign=\"top\" width=\"264\">\n<p class=\"p1\"><strong>Per a qu\u00e8 serveix l&#8217;Excel (i 2)?<\/strong><\/p>\n<p>Despr\u00e9s d&#8217;una setmana de pr\u00e0ctica i en alguns casos de descoberta del programa Excel, continuar\u00e9 des d&#8217;on ens vam quedar, parlant de la manera de descobrir\u00a0utilitats\u00a0per a l&#8217;Excel amb les plantilles i parlant d&#8217;algunes q\u00fcestions m\u00e9s relatives a les seves funcions. Una d&#8217;aquestes \u2013que potser us sorprendr\u00e0\u2013 \u00e9s fer servir el programa en la\u00a0confecci\u00f3 d&#8217;horaris\u00a0i\u00a0agendes,\u00a0per\u00f2 potser hi ha programes m\u00e9s adequats que trobareu al web. Ja sabeu que no hi ha res com escriure qu\u00e8 voleu i Google us en d\u00f3na la resposta. Sin\u00f3,\u00a0espereu l&#8217;Internauta: s&#8217;admeten peticions!<\/p>\n<p>Bromes a banda, personalment crec que ens d\u00f3na m\u00e9s satisfaccions fer un petit full de c\u00e0lcul per resoldre un problema, per exemple, d&#8217;horaris, que no cercar-ne un que ens ho resolgui via Google.<\/p>\n<p>Avui tamb\u00e9 parlar\u00e9 de\u00a0macros\u00a0i gr\u00e0fics, la cosa tan visual i aclaridora que solen posar com a resultat de les enquestes, per\u00f2 nosaltres els podem aplicar a casa nostra per veure les nostres tend\u00e8ncies. Si hi escrivim dades di\u00e0ries, nom\u00e9s ens calen dos minuts i al final d&#8217;un per\u00edode de temps que establirem nosaltres, m\u00e0gicament veurem un gr\u00e0fic de la manera que vulguem que ens ajudar\u00e0 a saber els nostres costums, consums i tend\u00e8ncies, despeses en llum, tel\u00e8fon, sortides, pes, pressi\u00f3 arterial, etc.<\/p>\n<p>I tamb\u00e9 parlar\u00e9 de les macros amb un significat diferent de les de la fotografia. Som-hi!<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<td class=\"columnsContainer\" align=\"left\" valign=\"top\" width=\"50%\">\n<table class=\"templateColumn\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\">\n<tbody>\n<tr>\n<td class=\"rightColumnContainer\" valign=\"top\">\n<table class=\"mcnCaptionBlock\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody class=\"mcnCaptionBlockOuter\">\n<tr>\n<td class=\"mcnCaptionBlockInner\" valign=\"top\">\n<table class=\"mcnCaptionBottomContent\" border=\"0\" width=\"false\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\n<tbody>\n<tr>\n<td class=\"mcnCaptionBottomImageContent\" align=\"left\" valign=\"top\"><a class=\"\" title=\"\" href=\"http:\/\/www.vilaweb.cat\/noticia\/4217235\/20141031\/xifres-daudiencia-laudiencia-activa.html\" target=\"_blank\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"mcnImage\" src=\"https:\/\/i0.wp.com\/gallery.mailchimp.com\/8ebfe63be3603515c0fc41244\/images\/8abd933e-24e2-41ab-bb2a-d88088106949.jpg?w=264&#038;ssl=1\" alt=\"\"  \/><\/a><\/td>\n<\/tr>\n<tr>\n<td class=\"mcnTextContent\" valign=\"top\" width=\"264\">\n<p class=\"p1\"><strong>De les xifres d&#8217;audi\u00e8ncia a l&#8217;audi\u00e8ncia activa<\/strong><\/p>\n<p>Des de fa poc, hi ha una nova eina per a mesurar l&#8217;audi\u00e8ncia dels mitjans digitals i de l&#8217;impacte social que tenen. Es diu\u00a0<a href=\"http:\/\/www.sibilare.com\/audiencia-activa\">\u00cdndex d&#8217;Audi\u00e8ncia Activa<\/a>(IAA) i avalua l&#8217;activitat dels mitjans a les xarxes socials. Impulsat per la consultora de comunicaci\u00f3\u00a0<a href=\"http:\/\/www.sibilare.com\/\">Sibilare<\/a>, l&#8217;IAA quantifica els usuaris que han compartit i comentat a Twitter els continguts difosos pels mitjans digitals en catal\u00e0 i, d&#8217;una altra banda, el volum d&#8217;aquesta activitat. L&#8217;an\u00e0lisi \u00e9s exhaustiva, piulada a piulada, i amb una freq\u00fc\u00e8ncia setmanal, i es monitoritzen els principals mitjans digitals en catal\u00e0 d&#8217;acord amb la classificaci\u00f3 de l&#8217;OJD, de la qual l&#8217;IAA \u00e9s complementari. Aix\u00ed doncs, el nou \u00edndex ofereix a mitjans i anunciants un indicador m\u00e9s acurat per a detectar el grau d&#8217;inter\u00e8s de les seves not\u00edcies i per a segmentar l&#8217;audi\u00e8ncia d&#8217;acord amb les seves reaccions. En parlem amb el periodista Marc Argem\u00ed, soci director de Sibilare.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table id=\"templateFooter\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td align=\"center\" valign=\"top\">\n<table class=\"templateContainer\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"footerContainer\" valign=\"top\">\n<table class=\"mcnTextBlock\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody class=\"mcnTextBlockOuter\">\n<tr>\n<td class=\"mcnTextBlockInner\" valign=\"top\">\n<table class=\"mcnTextContentContainer\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\n<tbody>\n<tr>\n<td class=\"mcnTextContent\" valign=\"top\">Si voleu que algun amic tamb\u00e9 rebi aquest mail cada setmana,\u00a0<a href=\"http:\/\/eepurl.com\/WBDxD\" target=\"_blank\">aqu\u00ed pot donar-se alta<\/a><\/p>\n<p><a href=\"http:\/\/www.mailchimp.com\/monkey-rewards\/?utm_source=freemium_newsletter&amp;utm_medium=email&amp;utm_campaign=monkey_rewards&amp;aid=8ebfe63be3603515c0fc41244&amp;afl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" title=\"MailChimp Email Marketing\" src=\"https:\/\/i0.wp.com\/cdn-images.mailchimp.com\/monkey_rewards\/MC_MonkeyReward_15.png?resize=139%2C54&#038;ssl=1\" alt=\"Email Marketing Powered by MailChimp\" width=\"139\" height=\"54\" border=\"0\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div style=\"padding-top:0px;\t\r\npadding-right:0px;\r\npadding-bottom:0px;\r\npadding-left:0px;\r\nmargin-top:0px;\r\nmargin-right:0px;\r\nmargin-bottom:0px;\r\nmargin-left:0px;\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" \r\n\t\t\t\t        data-url=\"https:\/\/pensalla.cat\/?p=38\" \r\n\t\t\t\t        data-via=\"jjofra\"\r\n\t\t\t\t\t    data-text=\"De les xifres d'audi\u00e8ncia a l'audi\u00e8ncia activa - L'Internauta del 31 d'octubre de 2014\"\r\n\t\t\t\t\t    data-related=\"\"\r\n\t\t\t\t\t    data-count=\"none\"\r\n\t\t\t\t\t    data-hashtags=\"\"\r\n\t\t\t\t\t    data-lang=\"autoLANGauto\"\r\n\t\t\t\t\t    data-counturl=\"pensalla.cat\"\r\n\t\t\t\t\t    data-size=\"medium\"\r\n\t\t\t\t\t    data-dnt=\"false\"\t> Tweet <\/a> <\/div>\r\n\t\t                <script>\r\n\t\t\t\t\t    !function(d,s,id) {\r\n\t\t\t\t\t      var js,fjs=d.getElementsByTagName(s)[0];\r\n\t\t\t\t\t      if(!d.getElementById(id)) {\r\n\t\t\t\t\t       js=d.createElement(s);js.id=id;js.src=\"https:\/\/platform.twitter.com\/widgets.js\";fjs.parentNode.insertBefore(js,fjs);\r\n\t\t\t\t\t      }\r\n\t\t\t\t\t    }\r\n\t\t\t\t\t   (document,\"script\",\"twitter-wjs\");\r\n\t\t\t\t\t    <\/script>","protected":false},"excerpt":{"rendered":"<p>Tweet Per a qu\u00e8 serveix l&#8217;Excel (i 2)? Aquesta setmana, a\u00a0l\u2019Internauta\u00a0de\u00a0Vilaweb\u00a0i\u00a0ElPuntAvuiTV: Confessions d&#8217;un dinosaure digital explicant\u00a0per a qu\u00e8 serveix l&#8217;Excel (segona part),\u00a0\u00e0udio\u00a0i\/o\u00a0text Joan Jofra Ara els diumenges a les 17h a\u00a0ElPuntAvuiTV Per a qu\u00e8 serveix l&#8217;Excel (i 2)? Despr\u00e9s d&#8217;una<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/pensalla.cat\/?p=38\">Read more <span class=\"screen-reader-text\">De les xifres d&#8217;audi\u00e8ncia a l&#8217;audi\u00e8ncia activa &#8211; L&#8217;Internauta del 31 d&#8217;octubre de 2014<\/span><span class=\"meta-nav\"> &#8250;<\/span><\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-mails"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pensalla.cat\/index.php?rest_route=\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pensalla.cat\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pensalla.cat\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pensalla.cat\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pensalla.cat\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=38"}],"version-history":[{"count":0,"href":"https:\/\/pensalla.cat\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions"}],"wp:attachment":[{"href":"https:\/\/pensalla.cat\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pensalla.cat\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pensalla.cat\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}