{"id":5125,"date":"2023-06-30T16:21:48","date_gmt":"2023-06-30T15:21:48","guid":{"rendered":"https:\/\/dynfut.tamtomy.cz\/?p=5125"},"modified":"2023-06-30T16:21:48","modified_gmt":"2023-06-30T15:21:48","slug":"simulation-tools-excel-or-a-digital-twin","status":"publish","type":"post","link":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/","title":{"rendered":"Simulation tools: Excel or a digital twin?"},"content":{"rendered":"

45 minutes. That’s how quickly one of the companies recovered the costs of acquiring the simulation model. \u201cSometimes the simulated processes are simple and Excel is really enough for them. In more complicated, complex cases, it pays to work with <\/span>dynamic simulation<\/span>,\u201d explains Petr Jal\u016fvka, Company Representative of DYNAMIC FUTURE.<\/span><\/p>\n

One example, as an introduction<\/b><\/h2>\n

That example is a bit older, but it will serve perfectly to explain how it was possible to save a lot of money in less than an hour. The mentioned company was building a new line with a conveyor, which was linked to other production phases. The products had to be placed on special platforms on the line, and the purchase price of one was around 5,000 euros. The equipment supplier has suggested how many conveyors the company needs to order to keep the production flow smooth.<\/span><\/p>\n

\u201cA simple simulation carried out in WITNESS by a company employee verified that only half the number of platforms will be needed, compared to the plan. It took 45 minutes, <\/span>and the company really saved a lot of money<\/b>,\u201d recalls Petr Jal\u016fvka.<\/span><\/p><\/blockquote>\n

Excel can\u2019t do everything<\/b><\/h2>\n

Although there have been speculations about the end of classic Excel for at least 10 years, it is certainly difficult for similar tools to surpass it. When it comes to predictions, however, dynamic simulation, i.e. the use of digital twins, clearly has the upper hand.<\/span><\/p>\n

\u201cExcel still remains much more popular than simulation. Actually, it is possible to carry out simulations in it, to some extent. However, in principle, it requires many simplifications, and what is most fundamental – <\/span>it can\u2019t work with time<\/b>,\u201d says the Company Representative.<\/span><\/p><\/blockquote>\n

According to him, the complexity of processes in companies is becoming more and more complex. The tool from the Microsoft workshop must be \u201cfed\u201d with input data in a complex way, while remembering all possible connections, combinations, and internal links that are key to the result. Simulation users have an easier job in this direction, with much more accurate results.<\/span><\/p>\n

\u201cIt\u2019s like cars. Previously, the driver had to control a lot of things while driving, there was no automatic choke, shifting, opening, safety features. Today, all you have to do is press the right button, turn the steering wheel, and increase or decrease the speed,\u201d explains Petr Jal\u016fvka.<\/span><\/p><\/blockquote>\n

Don\u2019t take a cannon to shoot sparrows<\/b><\/h2>\n

When DYNAMIC FUTURE comes to companies, they always come across the use of Excel for production planning, for example. According to P. Jal\u016fvka, its fundamental advantage is that it is a fast tool, easy to understand for everyone. And where, for example, advanced planning works, or in companies that also use other software products, Excel is a good choice.<\/span><\/p>\n

\u201cExcel, for example, allows you to quickly pull out the part of the processes that you need to solve or analyze data. When people use it in their daily routine, and for global, long-term solutions, they have other tools, and it has its merits. There is no need to always take a cannon for shooting sparrows,\u201d the Company Representative points out.<\/span><\/p><\/blockquote>\n

As we have already mentioned, the limitation is the impossibility of working with the time factor in Excel. Anyone who needs, for example, to <\/span>simulate the operation of two devices that are to operate one after the other<\/b>, each of which has its own cycle time, and needs a buffer between them, which is continuously filled, comes across this. The Excel user then has to make time slices that show how the situation looks at different moments. A digital twin user does not need to make such considerations. It is enough to enter the times for the first and second devices into the programme, plus simulate the connection between them and the buffer.<\/span><\/p>\n

Good input for the simulation model<\/b><\/h2>\n

However, knowing how to work in Excel is a big plus for using digital twins. <\/span>Excel can be an interface<\/b> in which users can find the inputs to the simulation model, the outputs, as well as the parameterization of the simulation, such as the length of the simulation period, replication, and so on. Users thus work with something they know, something they can grasp. They can \u201cjust click on the <\/span>WITNESS<\/span> tab\u201d and let the simulation process run.<\/span><\/p>\n

\u201cWe always create the outputs from the digital twin with the customer to make it as understandable as possible for him\/her. In them, he\/she can find, for example, equipment utilization, inventory trends, but we also motivate him\/her to dynamic parameters,\u201d says P. Jal\u016fvka.<\/p><\/blockquote>\n

At the same time, however, he points out that <\/span>controlling digital twins through Excel has its limits<\/b>. It is always necessary to clearly define what the changeable parameters are (number of workers, number of work groups, operating times on equipment, etc.) All inputs must be defined in advance.<\/span><\/p>\n

\u201cIf we want to modify more variables, then the only option is a simulation model,\u201d he states.<\/p><\/blockquote>\n

The biggest problem? There are not enough people for it<\/b><\/h2>\n

According to Petr Jal\u016fvka, there is no problem that people in companies do not believe in dynamic simulations. The reason why they are so little used so far is the lack of experts.<\/span><\/p>\n

\u201cSomeone has to deal with simulations on a daily basis. It is a tool that, in the hands of capable people, examines situations with maximum accuracy. But it doesn\u2019t run, alone and it\u2019s not enough to work with it just during the lunch break with a snack,\u201d states P. Jal\u016fvka.<\/span><\/p><\/blockquote>\n



<\/p>\n","protected":false},"excerpt":{"rendered":"

45 minutes. That’s how quickly one of the companies recovered the costs of acquiring the simulation model. \u201cSometimes the simulated processes are simple and Excel is really enough for them. In more complicated, complex cases, it pays to work with dynamic simulation,\u201d explains Petr Jal\u016fvka, Company Representative of DYNAMIC FUTURE. One example, as an introduction […]<\/p>\n","protected":false},"author":2869,"featured_media":5111,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"acf":[],"yoast_head":"\nSimulation tools: Excel or a digital twin? - DYNAMIC FUTURE<\/title>\n<meta name=\"description\" content=\"Pokud pot\u0159ebujete prov\u00e1d\u011bt modifitkovateln\u00e9 simulace s p\u0159esn\u00fdmi v\u00fdsledky, Excel v\u00e1m sta\u010dit nebude. Pro\u010d, odpov\u00edd\u00e1 Petr Jal\u016fvka, jednatel DYNAMIC FUTURE.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simulation tools: Excel or a digital twin? - DYNAMIC FUTURE\" \/>\n<meta property=\"og:description\" content=\"Pokud pot\u0159ebujete prov\u00e1d\u011bt modifitkovateln\u00e9 simulace s p\u0159esn\u00fdmi v\u00fdsledky, Excel v\u00e1m sta\u010dit nebude. Pro\u010d, odpov\u00edd\u00e1 Petr Jal\u016fvka, jednatel DYNAMIC FUTURE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/\" \/>\n<meta property=\"og:site_name\" content=\"DYNAMIC FUTURE\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-30T15:21:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"840\" \/>\n\t<meta property=\"og:image:height\" content=\"561\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Souad Kratochv\u00edlov\u00e1 Kafi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Souad Kratochv\u00edlov\u00e1 Kafi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/\",\"url\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/\",\"name\":\"Simulation tools: Excel or a digital twin? - DYNAMIC FUTURE\",\"isPartOf\":{\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg\",\"datePublished\":\"2023-06-30T15:21:48+00:00\",\"dateModified\":\"2023-06-30T15:21:48+00:00\",\"author\":{\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/#\/schema\/person\/2047edcdd4b754c532d0ea8eb7769179\"},\"description\":\"Pokud pot\u0159ebujete prov\u00e1d\u011bt modifitkovateln\u00e9 simulace s p\u0159esn\u00fdmi v\u00fdsledky, Excel v\u00e1m sta\u010dit nebude. Pro\u010d, odpov\u00edd\u00e1 Petr Jal\u016fvka, jednatel DYNAMIC FUTURE.\",\"breadcrumb\":{\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#primaryimage\",\"url\":\"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg\",\"contentUrl\":\"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg\",\"width\":840,\"height\":561,\"caption\":\"Two men with tablet talking in factory shop floor\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dynfut.tamtomy.cz\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simulation tools: Excel or a digital twin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/#website\",\"url\":\"https:\/\/dynfut.tamtomy.cz\/en\/\",\"name\":\"DYNAMIC FUTURE\",\"description\":\"digital twins (digit\u00e1ln\u00ed dvoj\u010data) pro p\u0159esn\u00e9 rozhodov\u00e1n\u00ed v pr\u016fmyslu a logistice\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dynfut.tamtomy.cz\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dynfut.tamtomy.cz\/en\/#\/schema\/person\/2047edcdd4b754c532d0ea8eb7769179\",\"name\":\"Souad Kratochv\u00edlov\u00e1 Kafi\",\"url\":\"https:\/\/dynfut.tamtomy.cz\/en\/author\/souaddigitaalcz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simulation tools: Excel or a digital twin? - DYNAMIC FUTURE","description":"Pokud pot\u0159ebujete prov\u00e1d\u011bt modifitkovateln\u00e9 simulace s p\u0159esn\u00fdmi v\u00fdsledky, Excel v\u00e1m sta\u010dit nebude. Pro\u010d, odpov\u00edd\u00e1 Petr Jal\u016fvka, jednatel DYNAMIC FUTURE.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Simulation tools: Excel or a digital twin? - DYNAMIC FUTURE","og_description":"Pokud pot\u0159ebujete prov\u00e1d\u011bt modifitkovateln\u00e9 simulace s p\u0159esn\u00fdmi v\u00fdsledky, Excel v\u00e1m sta\u010dit nebude. Pro\u010d, odpov\u00edd\u00e1 Petr Jal\u016fvka, jednatel DYNAMIC FUTURE.","og_url":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/","og_site_name":"DYNAMIC FUTURE","article_published_time":"2023-06-30T15:21:48+00:00","og_image":[{"width":840,"height":561,"url":"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg","type":"image\/jpeg"}],"author":"Souad Kratochv\u00edlov\u00e1 Kafi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Souad Kratochv\u00edlov\u00e1 Kafi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/","url":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/","name":"Simulation tools: Excel or a digital twin? - DYNAMIC FUTURE","isPartOf":{"@id":"https:\/\/dynfut.tamtomy.cz\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#primaryimage"},"image":{"@id":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#primaryimage"},"thumbnailUrl":"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg","datePublished":"2023-06-30T15:21:48+00:00","dateModified":"2023-06-30T15:21:48+00:00","author":{"@id":"https:\/\/dynfut.tamtomy.cz\/en\/#\/schema\/person\/2047edcdd4b754c532d0ea8eb7769179"},"description":"Pokud pot\u0159ebujete prov\u00e1d\u011bt modifitkovateln\u00e9 simulace s p\u0159esn\u00fdmi v\u00fdsledky, Excel v\u00e1m sta\u010dit nebude. Pro\u010d, odpov\u00edd\u00e1 Petr Jal\u016fvka, jednatel DYNAMIC FUTURE.","breadcrumb":{"@id":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#primaryimage","url":"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg","contentUrl":"https:\/\/dynfut.tamtomy.cz\/wp-content\/uploads\/2023\/06\/two-men-with-tablet-talking-in-factory-shop-floor-2023-03-23-23-09-42-utcM.jpg","width":840,"height":561,"caption":"Two men with tablet talking in factory shop floor"},{"@type":"BreadcrumbList","@id":"https:\/\/dynfut.tamtomy.cz\/en\/simulation-tools-excel-or-a-digital-twin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dynfut.tamtomy.cz\/en\/"},{"@type":"ListItem","position":2,"name":"Simulation tools: Excel or a digital twin?"}]},{"@type":"WebSite","@id":"https:\/\/dynfut.tamtomy.cz\/en\/#website","url":"https:\/\/dynfut.tamtomy.cz\/en\/","name":"DYNAMIC FUTURE","description":"digital twins (digit\u00e1ln\u00ed dvoj\u010data) pro p\u0159esn\u00e9 rozhodov\u00e1n\u00ed v pr\u016fmyslu a logistice","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dynfut.tamtomy.cz\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/dynfut.tamtomy.cz\/en\/#\/schema\/person\/2047edcdd4b754c532d0ea8eb7769179","name":"Souad Kratochv\u00edlov\u00e1 Kafi","url":"https:\/\/dynfut.tamtomy.cz\/en\/author\/souaddigitaalcz\/"}]}},"_links":{"self":[{"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/posts\/5125"}],"collection":[{"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/users\/2869"}],"replies":[{"embeddable":true,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/comments?post=5125"}],"version-history":[{"count":4,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/posts\/5125\/revisions"}],"predecessor-version":[{"id":5129,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/posts\/5125\/revisions\/5129"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/media\/5111"}],"wp:attachment":[{"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/media?parent=5125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/categories?post=5125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynfut.tamtomy.cz\/en\/wp-json\/wp\/v2\/tags?post=5125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}