{"id":7645,"date":"2025-09-16T11:48:16","date_gmt":"2025-09-16T11:48:16","guid":{"rendered":"https:\/\/opiumsystems.sk\/ako-vymenit-excel-mesta-za-moderny-intranet-v-priebehu-3-tyzdnov\/"},"modified":"2026-05-20T07:33:47","modified_gmt":"2026-05-20T07:33:47","slug":"jak-nahradit-excelove-tabulky-mestskeho-uradu-modernim-intranetem-behem-tri-tydnu","status":"publish","type":"post","link":"https:\/\/opiumsystems.sk\/cz\/ako-vymenit-excel-mesta-za-moderny-intranet-v-priebehu-3-tyzdnov\/","title":{"rendered":"Jak nahradit tabulky Excel m\u011bstsk\u00e9ho \u00fa\u0159adu modern\u00edm intranetem b\u011bhem 3 t\u00fddn\u016f?\u00a0"},"content":{"rendered":"<p>Trnava je dal\u0161\u00edm z m\u011bst, kter\u00e1 se technologick\u00fdch inovac\u00ed rozhodn\u011b neboj\u00ed. Kdy\u017e n\u00e1s m\u011bsto oslovilo s po\u017eadavkem, \u017ee pot\u0159ebuje lep\u0161\u00ed syst\u00e9m pro spr\u00e1vu investi\u010dn\u00edch projekt\u016f, m\u011blo jednu hlavn\u00ed podm\u00ednku:\u202f<strong>mus\u00ed to b\u00fdt rychl\u00e9 a funk\u010dn\u00ed<\/strong>. \u0158ekn\u011bme si to na rovinu \u2013 nahradit zaveden\u00fd Excel nen\u00ed ani snadn\u00fd, ani jednoduch\u00fd \u00fakol, ale kdy\u017e se spoj\u00ed touha zm\u011bnit v\u011bci k lep\u0161\u00edmu s jasnou viz\u00ed, lze dok\u00e1zat z\u00e1zraky.&nbsp;<\/p>\n\n\n\n<p>A tak vznikl m\u011bstsk\u00fd intranet \u0161it\u00fd na m\u00edru. Zprovozn\u011bn za rekordn\u00edch 2,5 t\u00fddne. Ano, \u010dtete spr\u00e1vn\u011b \u2013 necel\u00e9 t\u0159i t\u00fddny.&nbsp;<\/p>\n\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" id=\"digitalizacia-evidencie\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Obsah<\/strong>\u202f\u202f&nbsp;<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em><a href=\"#exceluznestacil\">Excel u\u017e nesta\u010dil<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#sharepointkalendar\">Anal\u00fdza a <\/a><a href=\"#analyzaaworkshopy\">workshopy<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#dvaapoltyzdnaktorestalizato\">Dva a p\u016fl t\u00fddne, kter\u00e9 za to st\u00e1ly<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#codnestrnavapouziva\">Co dnes Trnava pou\u017e\u00edv\u00e1<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#technologiektoremestouzmalenlepsievyuzite\">Technologie, kter\u00e9 m\u011bsto ji\u017e m\u00e1 \u2013 jen l\u00e9pe vyu\u017eit\u00e9<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#akosystemhodnotimesto\">Jak syst\u00e9m hodnot\u00ed m\u011bsto<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#trnavaukazalazedigitalizacianemusitrvatroky\">Trnava dok\u00e1zala, \u017ee digitalizace nemus\u00ed trvat roky<\/a><\/em><\/li>\n<\/ul>\n\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" id=\"digitalizacia-evidencie\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"exceluznestacil\"><strong>Excel u\u017e nesta\u010dil<\/strong>&nbsp;<\/h3>\n\n\n\n<p>P\u0159edstavte si spr\u00e1vu des\u00edtek m\u011bstsk\u00fdch investi\u010dn\u00edch projekt\u016f, spoustu odpov\u011bdn\u00fdch osob, term\u00edn\u016f, dokumentace, schvalov\u00e1n\u00ed\u2026 a to v\u0161e v Excelu. S rostouc\u00ed slo\u017eitost\u00ed v\u0161ak vyvstala pot\u0159eba syst\u00e9mu, kter\u00fd bude p\u0159ehledn\u00fd, bezpe\u010dn\u00fd a pou\u017eiteln\u00fd pro v\u0161echny zam\u011bstnance m\u011bsta.&nbsp;<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"665\" src=\"https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Investicna-akcia-Display-Ulohy-Display-2-1-1024x665.jpg\" alt=\"\" class=\"wp-image-7642\" srcset=\"https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Investicna-akcia-Display-Ulohy-Display-2-1-1024x665.jpg 1024w, https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Investicna-akcia-Display-Ulohy-Display-2-1-300x195.jpg 300w, https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Investicna-akcia-Display-Ulohy-Display-2-1-768x499.jpg 768w, https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Investicna-akcia-Display-Ulohy-Display-2-1.jpg 1512w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" id=\"centralizovanaplatforma\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"analyzaaworkshopy\"><strong>Anal\u00fdza a workshopy<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Spolupr\u00e1ce s m\u011bstem Trnava odstartovala v prosinci. Za\u010dali jsme s\u00e9ri\u00ed t\u0159\u00ed intenzivn\u00edch workshop\u016f, kter\u00e9 jsme rozlo\u017eili do t\u0159\u00ed t\u00fddn\u016f \u2013 a ano, stihli jsme je i mezi v\u00e1no\u010dn\u00edmi kol\u00e1\u010di a pun\u010dem. D\u00edky rychl\u00e9 a v\u011bcn\u00e9 spolupr\u00e1ci a pozitivn\u011b nalad\u011bn\u00e9mu t\u00fdmu se n\u00e1m poda\u0159ilo velmi rychle z\u00edskat jasnou p\u0159edstavu o pot\u0159eb\u00e1ch m\u011bsta.&nbsp;&nbsp;<\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" id=\"z\u00e1ver\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"dvaapoltyzdnaktorestalizato\"><strong>Dva a p\u016fl t\u00fddne, kter\u00e9 za to st\u00e1ly<\/strong>&nbsp;<\/h3>\n\n\n\n<p>N\u00e1sledovala expresn\u00ed f\u00e1ze p\u0159izp\u016fsoben\u00ed \u0159e\u0161en\u00ed \u2013 za 2,5 t\u00fddne jsme upravili a nasadili m\u011bstsk\u00fd intranet p\u0159esn\u011b podle individu\u00e1ln\u00edch po\u017eadavk\u016f. Po nasazen\u00ed prob\u011bhla je\u0161t\u011b m\u011bs\u00ed\u010dn\u00ed testovac\u00ed f\u00e1ze, b\u011bhem n\u00ed\u017e byly dolad\u011bny posledn\u00ed detaily. Rychlost neznamenala \u00fastupky v kvalit\u011b \u2013 naopak, d\u00edky jasn\u011b definovan\u00fdm c\u00edl\u016fm a skv\u011bl\u00e9 spolupr\u00e1ci \u0161lo v\u0161e jako po m\u00e1sle.&nbsp;<\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" id=\"z\u00e1ver\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"codnestrnavapouziva\"><strong>Co dnes Trnava pou\u017e\u00edv\u00e1?<\/strong>&nbsp;<\/h3>\n\n\n\n<p>V\u00fdsledkem je funk\u010dn\u00ed a p\u0159ehledn\u00fd intranet, kter\u00fd v\u00fdrazn\u011b zjednodu\u0161uje ka\u017edodenn\u00ed chod m\u011bsta:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Domovsk\u00e1 str\u00e1nka centr\u00e1ln\u00edho uzlu<\/strong>\u202f\u2013 rychl\u00fd p\u0159\u00edstup ke v\u0161em d\u016fle\u017eit\u00fdm informac\u00edm a modul\u016fm&nbsp;<\/li>\n\n\n\n<li><strong>Mana\u017eersk\u00fd dashboard<\/strong>\u202fpro veden\u00ed m\u011bsta \u2013 p\u0159ehledy o stavu investic, rozpo\u010dt\u016f \u010di \u00fakol\u016f p\u0159ipraven\u00e9 na m\u00edru&nbsp;<\/li>\n\n\n\n<li><strong>Modul investi\u010dn\u00edch akci\u00ed<\/strong>\u202f\u2013 evidence f\u00e1ze, stavu, rozpo\u010dtu, term\u00edn\u016f i dokumentace&nbsp;<\/li>\n\n\n\n<li><strong>Automatizovan\u00e1 spr\u00e1va dokument\u016f<\/strong>\u202f\u2013 syst\u00e9m s\u00e1m vytv\u00e1\u0159\u00ed strukturu dokument\u016f pro ka\u017edou akci&nbsp;<\/li>\n\n\n\n<li><strong>Spr\u00e1va \u00fakol\u016f m\u011bsta<\/strong>\u202f\u2013 p\u0159ehledn\u00e1 evidence \u00fakol\u016f u v\u0161ech zam\u011bstnanc\u016f<\/li>\n\n\n\n<li><strong>P\u0159ehled odd\u011blen\u00ed a jejich zam\u011bstnanc\u016f<\/strong>\u202f\u2013 intern\u00ed organiza\u010dn\u00ed struktura jednodu\u0161e a srozumiteln\u011b&nbsp;<\/li>\n<\/ul>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" id=\"z\u00e1ver\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"663\" src=\"https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Domov-2-1024x663.jpg\" alt=\"\" class=\"wp-image-7643\" srcset=\"https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Domov-2-1024x663.jpg 1024w, https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Domov-2-300x194.jpg 300w, https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Domov-2-768x497.jpg 768w, https:\/\/opiumsystems.sk\/wp-content\/uploads\/2026\/04\/Domov-2.jpg 1512w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" id=\"centralizovanaplatforma\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"technologiektoremestouzmalenlepsievyuzite\"><strong>Technologie, kter\u00e9 m\u011bsto ji\u017e m\u00e1 \u2013 jen l\u00e9pe vyu\u017eit\u00e9<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Z\u00e1kladem \u0159e\u0161en\u00ed jsou slu\u017eby Microsoft 365 a SharePoint. M\u011bsto Trnava tuto platformu ji\u017e vyu\u017e\u00edvalo, chyb\u011bla j\u00ed v\u0161ak struktura a propojen\u00ed s procesy m\u011bsta. V r\u00e1mci projektu jsme proto poskytli tak\u00e9\u202f<strong>technologick\u00e9 konzultace<\/strong>\u202fa doporu\u010den\u00ed, jak prost\u0159ed\u00ed M365 nastavit a p\u0159izp\u016fsobit tak, aby z n\u011bj mohli zam\u011bstnanci m\u011bsta pln\u011b t\u011b\u017eit.&nbsp;<\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" id=\"z\u00e1ver\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"akosystemhodnotimesto\"><strong>Jak syst\u00e9m hodnot\u00ed m\u011bsto?<\/strong>&nbsp;<\/h3>\n\n\n\n<p><strong><em>Jak\u00fd byl hlavn\u00ed d\u016fvod pro zaveden\u00ed nov\u00e9ho syst\u00e9mu?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Syst\u00e9m pro \u0159\u00edzen\u00ed investi\u010dn\u00edch projekt\u016f nahrazuje lok\u00e1ln\u00ed evidenci zam\u011bstnanc\u016f m\u011bsta, kte\u0159\u00ed pl\u00e1nuj\u00ed, \u0159\u00edd\u00ed a kontroluj\u00ed investi\u010dn\u00ed stavebn\u00ed projekty. Tento krok byl nezbytn\u00fd pro zjednodu\u0161en\u00ed spr\u00e1vy a koordinace t\u011bchto projekt\u016f.&nbsp;<\/p>\n\n\n\n<p><strong><em>Jak\u00e9 v\u00fdhody p\u0159in\u00e1\u0161\u00ed nov\u00fd syst\u00e9m zam\u011bstnanc\u016fm?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Toto \u0159e\u0161en\u00ed umo\u017e\u0148uje sd\u00edlen\u00ed dokument\u016f a informac\u00ed nap\u0159\u00ed\u010d celou organiza\u010dn\u00ed strukturou \u00fa\u0159adu. Zlep\u0161ila se tak\u00e9 p\u0159ehlednost o stavu investi\u010dn\u00edch projekt\u016f a zrychlily se procesy schvalov\u00e1n\u00ed a kontroly projekt\u016f. Spr\u00e1va \u00fakol\u016f v syst\u00e9mu d\u00e1le p\u0159isp\u00edv\u00e1 k efektivn\u011bj\u0161\u00edmu rozd\u011blen\u00ed pr\u00e1ce.&nbsp;<\/p>\n\n\n\n<p><strong><em>Jak\u00e9 technologie a n\u00e1stroje jste si pro sv\u016fj nov\u00fd syst\u00e9m vybrali a pro\u010d?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Implementovan\u00fd syst\u00e9m je postaven na platform\u011b SharePoint, kterou u\u017eivatel\u00e9 ji\u017e dob\u0159e znaj\u00ed. D\u00edky tomu je pr\u00e1ce se syst\u00e9mem intuitivn\u00ed a nevy\u017eaduje dlouh\u00e9 a \u010dasov\u011b n\u00e1ro\u010dn\u00e9 za\u0161kolov\u00e1n\u00ed zam\u011bstnanc\u016f.&nbsp;<\/p>\n\n\n\n<p><strong><em>&nbsp;Jak syst\u00e9m hodnot\u00ed zam\u011bstnanci, kte\u0159\u00ed jej pou\u017e\u00edvaj\u00ed?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Zam\u011bstnanci oce\u0148uj\u00ed jednoduchost a p\u0159ehlednost syst\u00e9mu, kter\u00e1 jim umo\u017e\u0148uje rychlej\u0161\u00ed p\u0159\u00edstup k pot\u0159ebn\u00fdm informac\u00edm a \u00fakol\u016fm. Syst\u00e9m v\u00fdrazn\u011b zjednodu\u0161il ka\u017edodenn\u00ed pr\u00e1ci, proto\u017ee v\u0161e je nyn\u00ed centralizov\u00e1no a dostupn\u00e9 na jednom m\u00edst\u011b.&nbsp;<\/p>\n\n\n\n<p class=\"has-text-align-right\">\u2013 Radoslav Drobn\u00fd \u2013&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"has-text-align-right\">&nbsp; odd\u011blen\u00ed pro inteligentn\u00ed m\u011bsto m\u011bsta Trnava&nbsp;<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"trnavaukazalazedigitalizacianemusitrvatroky\"><strong>Trnava dok\u00e1zala, \u017ee digitalizace nemus\u00ed trvat roky<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Tento projekt je d\u016fkazem toho, \u017ee i m\u011bstsk\u00e1 samospr\u00e1va dok\u00e1\u017ee b\u00fdt rychl\u00e1, efektivn\u00ed a p\u0159ipraven\u00e1 na modern\u00ed \u0159e\u0161en\u00ed. V\u0161e z\u00e1vis\u00ed na p\u0159\u00edstupu, d\u016fv\u011b\u0159e a spolupr\u00e1ci. Nejlep\u0161\u00edm d\u016fkazem je i pozitivn\u00ed zp\u011btn\u00e1 vazba od m\u011bsta, o kter\u00e9 jste si mohli p\u0159e\u010d\u00edst.&nbsp;<\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Trnava je \u010fal\u0161\u00edm z miest, ktor\u00e9 sa rozhodne neboja technologick\u00fdch inov\u00e1ci\u00ed. Ke\u010f n\u00e1s z mesta oslovili s po\u017eiadavkou, \u017ee potrebuj\u00fa lep\u0161\u00ed syst\u00e9m pre spr\u00e1vu investi\u010dn\u00fdch akci\u00ed, mali jednu hlavn\u00fa podmienku:\u202fmus\u00ed to by\u0165 r\u00fdchle a funk\u010dn\u00e9. Povedzme si na rovinu \u2013 nahradi\u0165 zau\u017e\u00edvan\u00fd Excel nie je mal\u00e1 a ani jednoduch\u00e1 vec, no ke\u010f sa spoj\u00ed chu\u0165 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":7644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_breakdance_hide_in_design_set":false,"_breakdance_tags":"","footnotes":""},"categories":[24],"tags":[],"post_folder":[],"class_list":["post-7645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digitalizacia"],"acf":[],"_links":{"self":[{"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/posts\/7645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/comments?post=7645"}],"version-history":[{"count":0,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/posts\/7645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/media\/7644"}],"wp:attachment":[{"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/media?parent=7645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/categories?post=7645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/tags?post=7645"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/opiumsystems.sk\/cz\/wp-json\/wp\/v2\/post_folder?post=7645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}