{"id":914,"date":"2011-11-03T21:16:01","date_gmt":"2011-11-03T20:16:01","guid":{"rendered":"http:\/\/www.matjazev.net\/blog\/?p=914"},"modified":"2011-11-09T20:31:11","modified_gmt":"2011-11-09T19:31:11","slug":"gantogram","status":"publish","type":"post","link":"https:\/\/www.matjazev.net\/blog\/2011\/11\/03\/gantogram\/","title":{"rendered":"Gantogram"},"content":{"rendered":"<p>Zadnji\u010d sem vam opisal kako lahko <a href=\"http:\/\/www.matjazev.net\/blog\/2011\/11\/03\/lebdeci-graf\/\">izdelate \u00bblebde\u010di graf\u00ab<\/a> in seveda lahko <strong>povsem isto tehniko uporabite tudi pri  izrisu gantograma<\/strong>:<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-920\" title=\"gantogram1\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram1.png\" alt=\"\" width=\"424\" height=\"283\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram1.png 424w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram1-300x200.png 300w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/a><\/p>\n<p>Gantogram na sliki je seveda malce ozek (toliko da se slika vidi na blogu), a sicer je to \u010disto pravi gantogram. Kot \u017ee zapisano, pa sem ga tudi <strong>ustvaril na povsem enak na\u010din, kot <a href=\"http:\/\/www.matjazev.net\/blog\/2011\/11\/03\/lebdeci-graf\/\">\u00bblebde\u010d\u00ab graf<\/a><\/strong>, le da so tukaj \u00bbstolpci\u00ab obrnjeni vodoravno.<\/p>\n<p>Omenjen graf sem izdelal na podlagi slede\u010de tabele:<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/tab_gantogram1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-918\" title=\"tab_gantogram1\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/tab_gantogram1.png\" alt=\"\" width=\"208\" height=\"102\" \/><\/a><\/p>\n<p>Sam graf pa omenjam zato, <strong>ker je potrebno (zaradi datumov!) ob gantogramu malce ve\u010d truda<\/strong>. \u010ce namre\u010d izdelate graf na podlagi gornje tabele, boste dobili slede\u010d zmazek:<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-919\" title=\"gantogram2\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram2.png\" alt=\"\" width=\"422\" height=\"282\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram2.png 422w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/gantogram2-300x200.png 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/a><\/p>\n<p>Na omenjenem grafu sta vidni <strong>vsaj dve iztopajo\u010di napaki<\/strong>. Prva napaka so sami <strong>odseki, ki so vsi enaki<\/strong>, druga napaka pa so<strong> neki \u010dudni datumi<\/strong> spodaj. \u010ce graf pove\u010date vidite, da so spodaj zapisani datumi od 0.1.1900 do 4.10.2173!!!<\/p>\n<h2>Od kot Excelu ti datumi?<\/h2>\n<p>Za raziskavo te \u00bbskrivnosti\u00ab si morate prebrati, <strong><a href=\"http:\/\/www.matjazev.net\/blog\/2010\/12\/02\/datumi-v-excelu\/\">kako Excel sploh vidi datume<\/a><\/strong>. Kot vidite, je datum pa\u010d navadna \u0161tevilka in <strong>\u0161tevilka 0 je pa\u010d \u00bbdatum\u00ab 0.1.1900<\/strong>. Na drugi strani pa imamo datum 4.10.2173. Zakaj?<\/p>\n<p>No; \u010de datumsko celico 11.10.2011 prika\u017eete kot \u0161tevilo,  boste videli 40827, 8.11.2011 pa kot 40855. Vsota omenjenih \u0161tevil je 81682, kar predstavlja datum 20.8.2123 in Excel na koncu tabele pa\u010d poka\u017ee ve\u010dji datum in je izbral 4.10.2173.<\/p>\n<h2>Popravek tabele<\/h2>\n<p>V drugi stolpec moramo \u2013 kot \u017ee pri \u00bblebde\u010dem\u00ab grafu \u2013 dodati pa\u010d samo \u0161tevilo dni vsake naloge, ki je seveda <strong>razlika obeh datumov<\/strong>. Dobimo torej spodnjo tabelo:<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/tab_gantogram2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-917\" title=\"tab_gantogram2\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/tab_gantogram2.png\" alt=\"\" width=\"208\" height=\"102\" \/><\/a><\/p>\n<p>S tem \u017ee dobimo precej bolj smiseln graf, a datumi so \u0161e <strong>zmeraj \u010dudni in preveliki \u2013 leto je odve\u010d<\/strong>! Zato je potrebno <strong>izbrati os z datumi<\/strong> in ji najprej <strong>ro\u010dno nastaviti meje datumov<\/strong>:<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-916\" title=\"okno_gantogram1\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram1.png\" alt=\"\" width=\"541\" height=\"550\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram1.png 541w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram1-295x300.png 295w\" sizes=\"(max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<p>Nakar ji nastavimo <strong>\u0161e obliko datumov<\/strong> (damo dan in mesec), s \u010dimer <strong>dobimo gantogram z za\u010detka dana\u0161njega bloga \ud83d\ude09<\/strong><\/p>\n<p><strong><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-915\" title=\"okno_gantogram2\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram2.png\" alt=\"\" width=\"541\" height=\"550\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram2.png 541w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2011\/11\/okno_gantogram2-295x300.png 295w\" sizes=\"(max-width: 541px) 100vw, 541px\" \/><\/a><br \/>\n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zadnji\u010d sem vam opisal kako lahko izdelate \u00bblebde\u010di graf\u00ab in seveda lahko povsem isto tehniko uporabite tudi pri izrisu gantograma: Gantogram na sliki je seveda malce ozek (toliko da se slika vidi na blogu), a sicer je to \u010disto pravi gantogram. Kot \u017ee zapisano, pa sem ga tudi ustvaril na povsem enak na\u010din, kot \u00bblebde\u010d\u00ab &hellip; <a href=\"https:\/\/www.matjazev.net\/blog\/2011\/11\/03\/gantogram\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Gantogram<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,3,19],"tags":[14,50,61,33,30],"_links":{"self":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/914"}],"collection":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/comments?post=914"}],"version-history":[{"count":10,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/914\/revisions"}],"predecessor-version":[{"id":932,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/914\/revisions\/932"}],"wp:attachment":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/media?parent=914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/categories?post=914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/tags?post=914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}