{"id":7645,"date":"2025-09-16T11:48:16","date_gmt":"2025-09-16T11:48:16","guid":{"rendered":"https:\/\/opium.matelabs.dev\/ako-vymenit-excel-mesta-za-moderny-intranet-v-priebehu-3-tyzdnov\/"},"modified":"2026-04-24T11:55:06","modified_gmt":"2026-04-24T11:55:06","slug":"ako-vymenit-excel-mesta-za-moderny-intranet-v-priebehu-3-tyzdnov","status":"publish","type":"post","link":"https:\/\/opium.matelabs.dev\/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 \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:\u202f<strong>mus\u00ed to by\u0165 r\u00fdchle a funk\u010dn\u00e9<\/strong>. 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 zmeni\u0165 veci k lep\u0161iemu s jasnou v\u00edziou, dok\u00e1\u017eu sa divy.&nbsp;<\/p>\n\n\n\n<p>A tak vznikol mestsk\u00fd intranet na mieru. Nasaden\u00fd za rekordn\u00fdch 2,5 t\u00fd\u017ed\u0148a. \u00c1no, \u010d\u00edtate spr\u00e1vne \u2013 necel\u00e9 tri t\u00fd\u017edne.&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 pol t\u00fd\u017ed\u0148a, ktor\u00e9 st\u00e1li za to<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#codnestrnavapouziva\">\u010co dnes Trnava pou\u017e\u00edva<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#technologiektoremestouzmalenlepsievyuzite\">Technol\u00f3gie, ktor\u00e9 mesto u\u017e m\u00e1 &#8211; len lep\u0161ie vyu\u017eit\u00e9<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#akosystemhodnotimesto\">Ako syst\u00e9m hodnot\u00ed mesto<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#trnavaukazalazedigitalizacianemusitrvatroky\">Trnava uk\u00e1zala, \u017ee digitaliz\u00e1cia nemus\u00ed trva\u0165 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>Predstavte si spr\u00e1vu desiatok mestsk\u00fdch investi\u010dn\u00fdch akci\u00ed, mno\u017estvo zodpovedn\u00fdch os\u00f4b, term\u00ednov, dokument\u00e1cie, schva\u013eovania&#8230; a cel\u00e9 je to v Exceli. S narastaj\u00facou komplexnos\u0165ou v\u0161ak pri\u0161la potreba syst\u00e9mu, ktor\u00fd bude preh\u013eadn\u00fd, bezpe\u010dn\u00fd a pou\u017eite\u013en\u00fd pre v\u0161etk\u00fdch zamestnancov mesta.&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\/2025\/09\/Investicna-akcia-Display-Ulohy-Display-2-1-1024x665.jpg\" alt=\"\" class=\"wp-image-7642\" \/><\/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\u00e1ca s mestom Trnava od\u0161tartovala v decembri. Za\u010dali sme s\u00e9riou troch intenz\u00edvnych workshopov, ktor\u00e9 sme rozlo\u017eili do troch t\u00fd\u017ed\u0148ov \u2013 a \u00e1no, stihli sme ich aj medzi viano\u010dn\u00fdmi kol\u00e1\u010dmi a pun\u010dom. V\u010faka r\u00fdchlej a vecnej spolupr\u00e1ci a pozit\u00edvne naladenom t\u00edme sa n\u00e1m podarilo ve\u013emi r\u00fdchlo z\u00edska\u0165 jasn\u00fd obraz o potreb\u00e1ch mesta.&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 pol t\u00fd\u017ed\u0148a, ktor\u00e9 st\u00e1li za to<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Nasledovala expresn\u00e1 f\u00e1za prisp\u00f4sobenia rie\u0161enia \u2013 za 2,5 t\u00fd\u017ed\u0148a sme upravili a nasadili mestsk\u00fd intranet presne pod\u013ea individu\u00e1lnych po\u017eiadaviek.&nbsp; Po nasaden\u00ed prebehla e\u0161te mesa\u010dn\u00e1 testovacia f\u00e1za, kde sa doladili posledn\u00e9 detaily. R\u00fdchlos\u0165 neznamenala \u00fastupky v kvalite \u2013 naopak, v\u010faka jasne definovan\u00fdm cie\u013eom a skvelej spolupr\u00e1ci i\u0161lo v\u0161etko ako po masle.&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>\u010co dnes Trnava pou\u017e\u00edva?<\/strong>&nbsp;<\/h3>\n\n\n\n<p>V\u00fdsledkom je funk\u010dn\u00fd a preh\u013eadn\u00fd intranet, ktor\u00fd v\u00fdrazne zjednodu\u0161uje ka\u017edodenn\u00e9 fungovanie mesta:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Domovsk\u00e1 str\u00e1nka centr\u00e1lneho hubu<\/strong>\u202f\u2013 r\u00fdchly pr\u00edstup ku v\u0161etk\u00fdm d\u00f4le\u017eit\u00fdm inform\u00e1ci\u00e1m a modulom&nbsp;<\/li>\n\n\n\n<li><strong>Mana\u017e\u00e9rsky dashboard<\/strong>\u202fpre vedenie mesta \u2013 na mieru pripraven\u00e9 preh\u013eady o stave invest\u00edci\u00ed, rozpo\u010dtoch \u010di \u00faloh\u00e1ch&nbsp;<\/li>\n\n\n\n<li><strong>Modul investi\u010dn\u00fdch akci\u00ed<\/strong>\u202f\u2013 evidencia f\u00e1zy, statusu, rozpo\u010dtu, term\u00ednov aj dokument\u00e1cie&nbsp;<\/li>\n\n\n\n<li><strong>Automatizovan\u00e1 spr\u00e1va dokumentov<\/strong>\u202f\u2013 syst\u00e9m s\u00e1m vytv\u00e1ra \u0161trukt\u00faru dokumentov pre ka\u017ed\u00fa akciu&nbsp;<\/li>\n\n\n\n<li><strong>Spr\u00e1va \u00faloh mesta<\/strong>\u202f\u2013 preh\u013eadn\u00e1 evidencia \u00faloh naprie\u010d v\u0161etk\u00fdmi zamestnancami<\/li>\n\n\n\n<li><strong>Preh\u013ead odborov a ich zamestnancov<\/strong>\u202f\u2013 intern\u00e1 organiza\u010dn\u00e1 \u0161trukt\u00fara jednoducho a zrozumite\u013ene&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\/2025\/09\/Domov-2-1024x663.jpg\" alt=\"\" class=\"wp-image-7643\" \/><\/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>Technol\u00f3gie, ktor\u00e9 mesto u\u017e m\u00e1 \u2013 len lep\u0161ie vyu\u017eit\u00e9<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Z\u00e1kladom rie\u0161enia je Microsoft 365 a SharePoint. Mesto Trnava u\u017e t\u00fato platformu vyu\u017e\u00edvalo, no ch\u00fdbala jej \u0161trukt\u00fara a prepojenie s procesmi mesta. V r\u00e1mci projektu sme preto poskytli aj\u202f<strong>technologick\u00e9 konzult\u00e1cie<\/strong>\u202fa odpor\u00fa\u010dania, ako prostredie M365 nastavi\u0165 a prisp\u00f4sobi\u0165 tak, aby z neho zamestnanci mesta mohli \u0165a\u017ei\u0165 naplno.&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>Ako syst\u00e9m hodnot\u00ed mesto?<\/strong>&nbsp;<\/h3>\n\n\n\n<p><strong><em>Ak\u00fd bol hlavn\u00fd d\u00f4vod pre implement\u00e1ciu nov\u00e9ho syst\u00e9mu?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Syst\u00e9m pre riadenie investi\u010dn\u00fdch akci\u00ed nahr\u00e1dza lok\u00e1lne evidencie pracovn\u00edkov mesta, ktor\u00ed pl\u00e1nuj\u00fa, riadia a kontroluj\u00fa projekty investi\u010dnej v\u00fdstavby. Tento krok bol nevyhnutn\u00fd pre zjednodu\u0161enie spr\u00e1vy a koordin\u00e1cie t\u00fdchto projektov.&nbsp;<\/p>\n\n\n\n<p><strong><em>Ak\u00e9 v\u00fdhody prin\u00e1\u0161a nov\u00fd syst\u00e9m pre zamestnancov?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Rie\u0161enie umo\u017e\u0148uje zdie\u013eanie dokumentov a inform\u00e1ci\u00ed naprie\u010d celou organiza\u010dnou \u0161trukt\u00farou \u00faradu. Zlep\u0161ila sa aj preh\u013eadnos\u0165 o stave investi\u010dn\u00fdch akci\u00ed a ur\u00fdchlili sa procesy schva\u013eovania a kontroly projektov. Mana\u017ement \u00faloh v syst\u00e9me \u010falej prispieva k efekt\u00edvnej\u0161iemu rozdeleniu pr\u00e1ce.&nbsp;<\/p>\n\n\n\n<p><strong><em>Ak\u00e9 technol\u00f3gie a n\u00e1stroje ste si vybrali pre v\u00e1\u0161 nov\u00fd system a pre\u010do?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Implementovan\u00fd syst\u00e9m je postaven\u00fd na platforme SharePoint, ktor\u00e1 je pou\u017e\u00edvate\u013eom u\u017e dobre zn\u00e1ma. Tento fakt zabezpe\u010duje, \u017ee pr\u00e1ca so syst\u00e9mom je intuit\u00edvna a nevy\u017eaduje dlh\u00e9 a \u010dasovo n\u00e1ro\u010dn\u00e9 za\u0161kolenie zamestnancov.&nbsp;<\/p>\n\n\n\n<p><strong><em>&nbsp;Ako hodnotia syst\u00e9m zamestnanci, ktor\u00ed ho pou\u017e\u00edvaj\u00fa?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Zamestnanci oce\u0148uj\u00fa jednoduchos\u0165 a preh\u013eadnos\u0165 syst\u00e9mu, \u010do im umo\u017e\u0148uje r\u00fdchlej\u0161\u00ed pr\u00edstup k potrebn\u00fdm inform\u00e1ci\u00e1m a \u00faloh\u00e1m. Syst\u00e9m v\u00fdrazne zjednodu\u0161il ka\u017edodenn\u00fa pr\u00e1cu, preto\u017ee v\u0161etko je teraz centralizovan\u00e9 a dostupn\u00e9 na jednom mieste.&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; refer\u00e1t pre smart city mesta 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 uk\u00e1zala, \u017ee digitaliz\u00e1cia nemus\u00ed trva\u0165 roky<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Tento projekt je d\u00f4kazom, \u017ee aj mestsk\u00e1 samospr\u00e1va vie by\u0165 r\u00fdchla, efekt\u00edvna a pripraven\u00e1 na modern\u00e9 rie\u0161enia. V\u0161etko z\u00e1vis\u00ed od pr\u00edstupu, d\u00f4very a spolupr\u00e1ce. Najlep\u0161\u00edm d\u00f4kazom je aj pozit\u00edvna sp\u00e4tn\u00e1 v\u00e4zba od mesta, o ktorej ste si mohli pre\u010d\u00edta\u0165.\u00a0<\/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:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/posts\/7645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/comments?post=7645"}],"version-history":[{"count":1,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/posts\/7645\/revisions"}],"predecessor-version":[{"id":7646,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/posts\/7645\/revisions\/7646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/media\/7644"}],"wp:attachment":[{"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/media?parent=7645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/categories?post=7645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/tags?post=7645"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/opium.matelabs.dev\/cz\/wp-json\/wp\/v2\/post_folder?post=7645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}