{"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":"how-to-replace-excel-city-data-with-a-modern-intranet-in-3-weeks","status":"publish","type":"post","link":"https:\/\/opiumsystems.sk\/en\/ako-vymenit-excel-mesta-za-moderny-intranet-v-priebehu-3-tyzdnov\/","title":{"rendered":"How to replace an Excel city plan with a modern intranet in 3 weeks?\u00a0"},"content":{"rendered":"<p>Trnava is another city that certainly isn't afraid of technological innovation. When the city approached us with the request that they needed a better system for managing investment projects, they had one main condition:<strong>It needs to be fast and functional<\/strong>. Let's be honest - replacing the established Excel isn't a small or easy task, but when the desire to change things for the better is combined with a clear vision, wonders can happen.&nbsp;<\/p>\n\n\n\n<p>And so, a custom city intranet was created. Deployed in a record 2.5 weeks. Yes, you read that right \u2013 less than three weeks.&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>Content<\/strong>\u202f\u202f&nbsp;<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em><a href=\"#exceluznestacil\">Excel was no longer enough<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#sharepointkalendar\">Analysis and <\/a><a href=\"#analyzaaworkshopy\">workshops<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#dvaapoltyzdnaktorestalizato\">Two and a half weeks that were worth it<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#codnestrnavapouziva\">What does Trnava use today<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#technologiektoremestouzmalenlepsievyuzite\">Technologies the city already has\u2014just put to better use<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#akosystemhodnotimesto\">How the system rates a city<\/a><\/em><\/li>\n\n\n\n<li><em><a href=\"#trnavaukazalazedigitalizacianemusitrvatroky\">Trnava showed that digitalization doesn't have to take years.<\/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 was no longer enough<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Imagine managing dozens of municipal investment projects, numerous responsible parties, deadlines, documentation, approvals... and it's all in Excel. However, with increasing complexity came the need for a system that would be clear, secure, and usable for all city employees.&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>Analysis and Workshops<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Cooperation with the city of Trnava began in December. We started with a series of three intensive workshops spread over three weeks \u2013 and yes, we managed to fit them in between Christmas cookies and mulled wine. Thanks to the quick and efficient cooperation and the positively minded team, we were able to get a clear picture of the city's needs very quickly.&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>Two and a half weeks that were worth it<\/strong>&nbsp;<\/h3>\n\n\n\n<p>The express phase of solution customization followed \u2013 in 2.5 weeks, we modified and deployed the city intranet exactly according to individual requirements. After deployment, a one-month testing phase took place where the final details were fine-tuned. Speed did not mean compromises in quality \u2013 on the contrary, thanks to clearly defined goals and great cooperation, everything went smoothly.&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>What is Trnava using today?<\/strong>&nbsp;<\/h3>\n\n\n\n<p>The result is a functional and clear intranet that significantly simplifies the daily operations of the city:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Central Hub Homepage<\/strong>\u2013 quick access to all important information and modules&nbsp;<\/li>\n\n\n\n<li><strong>Management Dashboard<\/strong>for city management \u2013 tailor-made reports on investment status, budgets, or tasks&nbsp;<\/li>\n\n\n\n<li><strong>Investment Stock Module<\/strong>\u2013 evidence of phase, status, budget, deadlines, and documentation&nbsp;<\/li>\n\n\n\n<li><strong>Automated Document Management<\/strong>\u2013 the system itself creates the document structure for each action&nbsp;<\/li>\n\n\n\n<li><strong>City Task Management<\/strong>\u2013 clear task tracking across all employees<\/li>\n\n\n\n<li><strong>Overview of Departments and their Employees<\/strong>\u2013 internal organizational structure, simple and understandable&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>Technologies the city already has\u2014just put to better use<\/strong>&nbsp;<\/h3>\n\n\n\n<p>The solution's foundation is Microsoft 365 and SharePoint. The city of Trnava was already using this platform, but it lacked structure and integration with the city's processes. Therefore, within the project, we also provided<strong>Technology consulting<\/strong>and recommendations on how to set up and customize the M365 environment so that city employees can benefit from it to the fullest.&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>How does the system rate the city?<\/strong>&nbsp;<\/h3>\n\n\n\n<p><strong><em>What was the main reason for implementing the new system?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>The investment stock management system replaces the local records of city workers who plan, manage, and control investment construction projects. This step was necessary to simplify the management and coordination of these projects.&nbsp;<\/p>\n\n\n\n<p><strong><em>What benefits does the new system bring to employees?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>The solution allows for the sharing of documents and information across the entire organizational structure of the office. Transparency regarding the status of investment actions has also improved, and project approval and control processes have been accelerated. Furthermore, task management within the system contributes to a more efficient division of labor.&nbsp;<\/p>\n\n\n\n<p><strong><em>What technologies and tools did you choose for your new system, and why?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>The implemented system is built on the SharePoint platform, which is already well-known to users. This ensures that working with the system is intuitive and does not require long and time-consuming employee training.&nbsp;<\/p>\n\n\n\n<p><strong><em>&nbsp;How do employees who use the system rate it?<\/em><\/strong>&nbsp;<\/p>\n\n\n\n<p>Employees appreciate the system's simplicity and clarity, which allows them faster access to necessary information and tasks. The system has significantly simplified daily work, as everything is now centralized and accessible in one place.&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; Report for Trnava Smart City&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 showed that digitalization doesn't have to take years.<\/strong>&nbsp;<\/h3>\n\n\n\n<p>This project is proof that even municipal self-government can be fast, efficient, and ready for modern solutions. Everything depends on the approach, trust, and cooperation. The best proof is also the positive feedback from the city, which you could read about.&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\/en\/wp-json\/wp\/v2\/posts\/7645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/comments?post=7645"}],"version-history":[{"count":0,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/posts\/7645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/media\/7644"}],"wp:attachment":[{"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/media?parent=7645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/categories?post=7645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/tags?post=7645"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/opiumsystems.sk\/en\/wp-json\/wp\/v2\/post_folder?post=7645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}