{"id":350,"date":"2014-04-25T21:18:34","date_gmt":"2014-04-25T19:18:34","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=350"},"modified":"2022-11-03T16:08:41","modified_gmt":"2022-11-03T15:08:41","slug":"excel-creer-un-tableau-croise-dynamique-regles-de-base","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/04\/excel-creer-un-tableau-croise-dynamique-regles-de-base\/","title":{"rendered":"Excel &#8211; Cr\u00e9er un tableau crois\u00e9 dynamique, r\u00e8gles de base"},"content":{"rendered":"<p>Voici quelques r\u00e8gles \u00e0 respecter afin que vos tableaux crois\u00e9s fassent ce que vous attendez d&rsquo;eux :<\/p>\n<ul>\n<li>Chaque colonne des donn\u00e9es sources doit avoir un en-t\u00eate \u00ab\u00a0utilisable\u00a0\u00bb (pas trop long) et unique<\/li>\n<li>Faites en sorte qu&rsquo;il n&rsquo;y ait pas de cellules fusionn\u00e9es dans les en-t\u00eates des donn\u00e9es sources<\/li>\n<li>Si une colonne contient des donn\u00e9es num\u00e9riques, faites en sorte qu&rsquo;aucune cellule ne soit vide. Au besoin, ins\u00e9rez des 0<\/li>\n<li>Il ne peut y avoir de ligne ou de colonne vide<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Voici quelques r\u00e8gles \u00e0 respecter afin que vos tableaux crois\u00e9s fassent ce que vous attendez d&rsquo;eux : Chaque colonne des donn\u00e9es sources doit avoir un en-t\u00eate \u00ab\u00a0utilisable\u00a0\u00bb (pas&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[19],"class_list":{"0":"post-350","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-tableau"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=350"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}