{"id":2546,"date":"2025-09-23T16:04:00","date_gmt":"2025-09-23T14:04:00","guid":{"rendered":"https:\/\/www.capsule.hu\/?p=2546"},"modified":"2025-09-23T16:18:11","modified_gmt":"2025-09-23T14:18:11","slug":"prediktiv-karbantartas-excellel","status":"publish","type":"post","link":"http:\/\/www.capsule.hu\/en\/prediktiv-karbantartas-excellel\/","title":{"rendered":"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel &#8211; Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra?"},"content":{"rendered":"<figure class=\"wp-block-image size-full has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1536\" height=\"1024\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png\" alt=\"\" class=\"wp-image-2559\" style=\"border-radius:50px;aspect-ratio:16\/9;object-fit:cover\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png 1536w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image-300x200.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image-1024x683.png 1024w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image-768x512.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image-18x12.png 18w\" sizes=\"auto, (max-width: 1536px) 100vw, 1536px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Bevezet\u00e9s<\/h2>\n\n\n\n<p>Egy v\u00e1ratlan g\u00e9ple\u00e1ll\u00e1s sokkal t\u00f6bbe ker\u00fcl, mint els\u0151re gondoln\u00e1nk. Nem csak a kies\u0151 gy\u00e1rt\u00e1si id\u0151r\u0151l van sz\u00f3, hanem a selejtterm\u00e9kekr\u0151l, az \u00fajraind\u00edt\u00e1s k\u00f6lts\u00e9g\u00e9r\u0151l, a hat\u00e1rid\u0151k cs\u00fasz\u00e1s\u00e1r\u00f3l \u00e9s a t\u00fal\u00f3r\u00e1r\u00f3l is. Egy magyar KKV eset\u00e9ben ak\u00e1r <strong>t\u00f6bb sz\u00e1zezer forint vesztes\u00e9get<\/strong> jelenthet egyetlen nap \u00e1ll\u00e1sid\u0151.<\/p>\n\n\n\n<p>A <strong>predikt\u00edv karbantart\u00e1s<\/strong> l\u00e9nyege, hogy a g\u00e9p adataib\u00f3l (pl. \u00e1ramfelv\u00e9tel, h\u0151m\u00e9rs\u00e9klet, ciklusid\u0151, vibr\u00e1ci\u00f3) el\u0151re felismerj\u00fck a hibajeleket. \u00cdgy nem ut\u00f3lag der\u00fcl ki, hogy baj van, hanem id\u0151ben tervezhet\u0151 a karbantart\u00e1s.<\/p>\n\n\n\n<p>Sokan azt gondolj\u00e1k, hogy ehhez bonyolult mesters\u00e9ges intelligencia \u00e9s dr\u00e1ga szoftver kell. Val\u00f3j\u00e1ban m\u00e1r <strong>Excelben is fel\u00e9p\u00edthet\u0151 egy egyszer\u0171 dashboard<\/strong>, amivel ki lehet mutatni az anom\u00e1li\u00e1kat \u00e9s alap szinten el\u0151re lehet jelezni, mikor t\u00e9r el a rendszer a megszokott m\u0171k\u00f6d\u00e9st\u0151l.<\/p>\n\n\n\n<p>Fontos azonban hangs\u00falyozni: <strong>Excel kis adatra \u00e9s 1\u20132 g\u00e9pre j\u00f3 megold\u00e1s<\/strong>, de ipari k\u00f6rnyezetben nem el\u00e9g stabil, nem kezeli j\u00f3l a nagy adathalmazokat, \u00e9s nincs val\u00f3s idej\u0171 m\u0171k\u00f6d\u00e9s. Ott m\u00e1r sk\u00e1l\u00e1zhat\u00f3, \u00fczembiztos rendszerekre van sz\u00fcks\u00e9g \u2013 ebben tudunk mi seg\u00edteni.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. l\u00e9p\u00e9s &#8211; Adatgy\u0171jt\u00e9s<\/h2>\n\n\n\n<p>T\u00e9telezz\u00fcnk fel egy egyszer\u0171 villanymotor k\u00e9t f\u0151bb param\u00e9ter\u00e9t szeretn\u00e9nk megvizsg\u00e1lni \u00e9s az alapj\u00e1n fel\u00fcgyleni a m\u00fak\u00f6d\u00e9s\u00e9t:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00c1ramfelv\u00e9tel (A)<\/li>\n\n\n\n<li>H\u0151m\u00e9rs\u00e9klet (\u00b0C)<\/li>\n<\/ul>\n\n\n\n<p>Az adatsorban egy nap 5 perces m\u00e9r\u00e9sei l\u00e1that\u00f3k, az adatokat leolvashatjuk manu\u00e1lisan vagy egy IoT modul seg\u00edts\u00e9g\u00e9vel id\u0151szakosan beolvashatunk egy adatb\u00e1zisba.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. l\u00e9p\u00e9s &#8211; Adatok el\u0151k\u00e9sz\u00edt\u00e9se Excelben<\/h2>\n\n\n\n<p>Miut\u00e1n megvan a t\u00e1bl\u00e1zat az id\u0151b\u00e9lyeggel \u00e9s a szenzoradatokkal, a k\u00f6vetkez\u0151 l\u00e9p\u00e9s, hogy <strong>l\u00e1that\u00f3v\u00e1 tegy\u00fck a trendeket<\/strong>. Ez az\u00e9rt fontos, mert a legt\u00f6bb g\u00e9phiba nem egyik pillanatr\u00f3l a m\u00e1sikra t\u00f6rt\u00e9nik \u2013 a g\u00e9p \u201esz\u00f3l\u201d, csak \u00e9szre kell venni az adatokban.<\/p>\n\n\n\n<p>Excelben ehhez nincs sz\u00fcks\u00e9g semmi bonyolultra: p\u00e1r egyszer\u0171 f\u00fcggv\u00e9ny \u00e9s grafikon el\u00e9g.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">T\u00e1bl\u00e1zat el\u0151k\u00e9sz\u00edt\u00e9se<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jel\u00f6ld ki az adatokat (id\u0151pont, \u00e1ramfelv\u00e9tel, h\u0151m\u00e9rs\u00e9klet)<\/li>\n\n\n\n<li>Men\u00fcsor \u27a1 <strong>Besz\u00far\u00e1s<\/strong> \u27a1 T\u00e1bl\u00e1zat\n<ul class=\"wp-block-list\">\n<li>\u00cdgy struktur\u00e1lt t\u00e1bl\u00e1zatot kapsz, amiben k\u00f6nnyen sz\u0171rhetsz,  rendezhetsz.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"689\" height=\"689\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.29.48-edited.png\" alt=\"\" class=\"wp-image-2548\" style=\"border-radius:15px;aspect-ratio:1;object-fit:cover;width:437px;height:auto\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.29.48-edited.png 689w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.29.48-edited-300x300.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.29.48-edited-150x150.png 150w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.29.48-edited-12x12.png 12w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3. l\u00e9p\u00e9s &#8211; Anom\u00e1lia detekt\u00e1l\u00e1s<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u00c1tlag \u00e9s sz\u00f3r\u00e1s sz\u00e1m\u00edt\u00e1sa<\/h3>\n\n\n\n<p>Az els\u0151 dolog, amit \u00e9rdemes n\u00e9zni: mi a \u201enorm\u00e1l\u201d m\u0171k\u00f6d\u00e9s.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=\u00c1TLAG(&#91;\u00c1ramfelv\u00e9tel]) \u2192 megmutatja az \u00e1tlagos \u00e9rt\u00e9ket.\n=SZ\u00d3R\u00c1S(&#91;\u00c1ramfelv\u00e9tel]) \u2192 a sz\u00f3r\u00e1st, vagyis mennyire ingadozik az adat.<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"426\" height=\"101\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.30.09.png\" alt=\"\" class=\"wp-image-2550\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.30.09.png 426w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.30.09-300x71.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.30.09-18x4.png 18w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Mit jelentenek az adatok?<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ha az \u00e9rt\u00e9kek k\u00f6zel \u00e1llnak az \u00e1tlaghoz, akkor stabil a m\u0171k\u00f6d\u00e9s.<\/li>\n\n\n\n<li>Ha az \u00e9rt\u00e9k a sz\u00f3r\u00e1s X-szeres\u00e9re van az \u00e1tlagt\u00f3l az gyan\u00fas, anom\u00e1li\u00e1t jelenthet.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Felt\u00e9teles form\u00e1z\u00e1s<\/h3>\n\n\n\n<p>Excelben automatikusan ki tudja emelni a &#8220;furcsa&#8221; \u00e9rt\u00e9keket. Hogyan?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jel\u00f6ld ki az \u00e1ramfelv\u00e9tel oszlopot<\/li>\n\n\n\n<li>Kezd\u0151lap \u27a1 Felt\u00e9teles form\u00e1z\u00e1s \u27a1 \u00daj szab\u00e1ly \u27a1 K\u00e9plet\n<ul class=\"wp-block-list\">\n<li>P\u00e9lda: [@\u00c1ramfelv\u00e9tel] &gt; (\u00c1TLAG + 3*SZ\u00d3R\u00c1S) &#8211; Piros h\u00e1tt\u00e9r<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u00cdgy azonnal l\u00e1tszik, ha valami kil\u00f3g a norm\u00e1l tartom\u00e1nyb\u00f3l.<\/li>\n<\/ul>\n\n\n\n<p><strong>Sz\u00f3r\u00e1s*3<\/strong><\/p>\n\n\n\n<p>A statisztik\u00e1ban ismert, hogy az adatok <strong>kb. 99,7%-a az \u00e1tlag \u00b1 3 sz\u00f3r\u00e1s tartom\u00e1ny\u00e1ba esik<\/strong> (ez az \u00fan. <em>68-95-99,7 szab\u00e1ly<\/em>).<\/p>\n\n\n\n<p>Ez\u00e9rt ha egy \u00e9rt\u00e9k <strong>3 sz\u00f3r\u00e1son k\u00edv\u00fcl esik<\/strong>, az m\u00e1r szinte biztosan rendellenes, vagyis <strong>anom\u00e1lia<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Grafikon k\u00e9sz\u00edt\u00e9se<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jel\u00f6ld ki az id\u0151b\u00e9lyeget \u00e9s a m\u00e9rt \u00e9rt\u00e9keket.<\/li>\n\n\n\n<li>Besz\u00far\u00e1s \u27a1 Vonaldiagram.\n<ul class=\"wp-block-list\">\n<li>Eredm\u00e9ny: egy id\u0151sor-grafikon, amin l\u00e1tszik a norm\u00e1l m\u0171k\u00f6d\u00e9s \u00e9s a kiugr\u00e1sok.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"966\" height=\"638\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.53.17.png\" alt=\"\" class=\"wp-image-2551\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.53.17.png 966w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.53.17-300x198.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.53.17-768x507.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.53.17-18x12.png 18w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Hogyan \u00e1br\u00e1zoljuk a sz\u00f3r\u00e1st Excelben?<\/strong><\/h4>\n\n\n\n<ul start=\"1\" class=\"wp-block-list\">\n<li>Sz\u00e1m\u00edtsuk ki az <strong>\u00e1tlagot<\/strong> \u00e9s a <strong>sz\u00f3r\u00e1st<\/strong>.\n<ul class=\"wp-block-list\">\n<li>=\u00c1TLAG([\u00c1ramfelv\u00e9tel])<\/li>\n\n\n\n<li>=SZ\u00d3R\u00c1S([\u00c1ramfelv\u00e9tel])<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>K\u00e9sz\u00edts\u00fcnk h\u00e1rom \u00faj seg\u00e9doszlopot a t\u00e1bl\u00e1zatban:\n<ul class=\"wp-block-list\">\n<li><strong>Fels\u0151 hat\u00e1r<\/strong> = \u00c1tlag + 3\u00d7Sz\u00f3r\u00e1s\/2<\/li>\n\n\n\n<li><strong>Als\u00f3 hat\u00e1r<\/strong> = \u00c1tlag \u2013 3\u00d7Sz\u00f3r\u00e1s\/2<\/li>\n\n\n\n<li>Ezek minden sorra ism\u00e9tl\u0151d\u0151 \u00e9rt\u00e9kek lesznek.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Rajzoljunk egy <strong>vonaldiagramot<\/strong>, amin l\u00e1tszik:\n<ul class=\"wp-block-list\">\n<li>a m\u00e9rt \u00e9rt\u00e9kek (pl. \u00e1ramfelv\u00e9tel),<\/li>\n\n\n\n<li>az \u00e1tlag (egyenes vonal),<\/li>\n\n\n\n<li>a fels\u0151 \u00e9s als\u00f3 hat\u00e1r (p\u00e1rhuzamos egyenesek).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Ha b\u00e1rmelyik adatpont <strong>\u00e1tl\u00e9pi a fels\u0151 vagy als\u00f3 hat\u00e1rt<\/strong>, azt azonnal l\u00e1tjuk a grafikonon \u2192 <strong>anom\u00e1lia<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"964\" height=\"345\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.57.42.png\" alt=\"\" class=\"wp-image-2552\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.57.42.png 964w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.57.42-300x107.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.57.42-768x275.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-12.57.42-18x6.png 18w\" sizes=\"auto, (max-width: 964px) 100vw, 964px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<h3 class=\"wp-block-heading\">ROI &#8211; Befektet\u00e9s megt\u00e9r\u00fcl\u00e9s<\/h3>\n\n\n\n<p>Egy ilyen egyszer\u0171 Excel dashboard m\u00e1r <strong>els\u0151 r\u00e1n\u00e9z\u00e9sre kisz\u00farja a hibajeleket<\/strong>, amiket egy\u00e9bk\u00e9nt csak a le\u00e1ll\u00e1skor venn\u00e9l \u00e9szre. Ha ez egyetlen nap kies\u00e9st el\u0151z meg, m\u00e1ris t\u00f6bb sz\u00e1zezer forintot takar\u00edt meg \u2013 \u00e9s mindezt Excelben, p\u00e1r kattint\u00e1ssal.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">4. l\u00e9p\u00e9s &#8211; El\u0151rejelz\u00e9s<\/h2>\n\n\n\n<p>Az anom\u00e1li\u00e1k jelz\u00e9se fontos, de az igazi \u00e9rt\u00e9k ott van, amikor el\u0151re tudjuk jelezni, hogy mikor fog a rendszer elt\u00e9rni a megszokott m\u0171k\u00f6d\u00e9st\u0151l. <strong>Excel szerencs\u00e9re be\u00e9p\u00edtve tartalmaz el\u0151rejelz\u0151 f\u00fcggv\u00e9nyeket<\/strong>, amikkel alap szinten megoldhat\u00f3 a predikci\u00f3.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">El\u0151rejelz\u00e9s trendvonallal<\/h3>\n\n\n\n<p>Az egyik legegyszer\u0171bb m\u00f3dszer a <strong>line\u00e1ris trendvonal<\/strong>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>K\u00e9sz\u00edts\u00fcnk egy vonaldiagramot az adatokb\u00f3l.<\/li>\n\n\n\n<li>Kattintsunk az adatsorra \u2192 \u201eTrendvonal hozz\u00e1ad\u00e1sa\u201d.<\/li>\n\n\n\n<li>V\u00e1lasszuk a <strong>line\u00e1ris trendvonalat<\/strong>, \u00e9s jel\u00f6lj\u00fck be: \u201eEgyenlet megjelen\u00edt\u00e9se a diagramon\u201d.<\/li>\n<\/ul>\n\n\n\n<p>Ez megmutatja, hogy az adataink \u00e1tlagosan merre tartanak. Ha a trendvonal meredeken emelkedik, az figyelmeztethet a k\u00f6zelg\u0151 t\u00falterhel\u00e9sre vagy hib\u00e1ra.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"903\" height=\"323\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.03.50.png\" alt=\"\" class=\"wp-image-2553\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.03.50.png 903w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.03.50-300x107.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.03.50-768x275.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.03.50-18x6.png 18w\" sizes=\"auto, (max-width: 903px) 100vw, 903px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">El\u0151rejelz\u00e9s f\u00fcggv\u00e9nnyel<\/h3>\n\n\n\n<p>Excelben van k\u00e9t hasznos be\u00e9p\u00edtett f\u00fcggv\u00e9ny, amivel konkr\u00e9t j\u00f6v\u0151beli \u00e9rt\u00e9ket sz\u00e1molhatunk:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>LINE\u00c1RIS EL\u0150REJELZ\u00c9S:\n   =EL\u0150REJELZ\u00c9S(x; ismert_\u00e9rt\u00e9kek; ismert_x-ek)\nID\u0150SOROS EL\u0150REJELZ\u00c9S:\n   =EL\u0150REJELZ\u00c9S.ETS(c\u00e9l_d\u00e1tum; \u00e9rt\u00e9kek; id\u0151pontok)<\/code><\/pre>\n\n\n\n<p><br><strong>Line\u00e1ris el\u0151rejelz\u00e9s<\/strong>:  Ez megmondja, hogy egy adott id\u0151pontban (x) v\u00e1rhat\u00f3an milyen \u00e9rt\u00e9k lesz.<\/p>\n\n\n\n<p><strong>Id\u0151soros el\u0151rejelz\u00e9s<\/strong> (<em>Exponential Triple Smoothing<\/em>): Ez sokkal pontosabb, mert figyelembe veszi a szezon\u00e1lis mint\u00e1kat, trendeket.<br><\/p>\n\n\n\n<p><strong>Hogyan haszn\u00e1ljuk \u0151ket a gyakorlatban?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>K\u00e9sz\u00edts\u00fcnk k\u00e9t oszlopot:\n<ul class=\"wp-block-list\">\n<li><strong>Id\u0151pont<\/strong> (p\u00e9ld\u00e1ul 2025.09.22. 10:00, 11:00, stb.)<\/li>\n\n\n\n<li><strong>M\u00e9rt \u00e9rt\u00e9k<\/strong> (pl. \u00e1ramfelv\u00e9tel).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Vegy\u00fcnk egy j\u00f6v\u0151beli id\u0151pontot (pl. 2025.10.01. 15:00), \u00e9s \u00edrjuk be k\u00fcl\u00f6n cell\u00e1ba.<\/li>\n\n\n\n<li>Haszn\u00e1ljuk a f\u00fcggv\u00e9nyt:\n<ul class=\"wp-block-list\">\n<li>=EL\u0150REJELZ\u00c9S.ETS(j\u00f6v\u0151beli_id\u0151pont; [\u00c1ramfelv\u00e9tel]; [Id\u0151pont])<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Excel kisz\u00e1molja, hogy az adott id\u0151pontban v\u00e1rhat\u00f3an milyen \u00e9rt\u00e9k lesz.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"372\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.59.50.png\" alt=\"\" class=\"wp-image-2554\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.59.50.png 842w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.59.50-300x133.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.59.50-768x339.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-13.59.50-18x8.png 18w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>M\u00e9g ha egyszer\u0171 is a modell, m\u00e1r egy ilyen el\u0151rejelz\u00e9s seg\u00edthet <strong>megel\u0151zni egy v\u00e1ratlan le\u00e1ll\u00e1st<\/strong>. Ha az \u00e9rt\u00e9kek folyamatosan emelkednek, \u00e9s az el\u0151rejelz\u00e9s szerint p\u00e1r \u00f3ra m\u00falva \u00e1tl\u00e9pik a norm\u00e1l tartom\u00e1nyt (\u00e1tlag + 3\u00d7sz\u00f3r\u00e1s), akkor <strong>tervezett karbantart\u00e1s<\/strong> szervezhet\u0151 \u2192 ROI: kevesebb \u00e1ll\u00e1sid\u0151, nagyobb g\u00e9pkihaszn\u00e1lts\u00e1g.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">Interakt\u00edv Excel Dashboard<\/h2>\n\n\n\n<p>Amikor m\u00e1r megvannak az alapadatok, az \u00e1tlag, a sz\u00f3r\u00e1s \u00e9s a \u00b13\u03c3 hat\u00e1rvonalak, a k\u00f6vetkez\u0151 l\u00e9p\u00e9s, hogy az inform\u00e1ci\u00f3t <strong>d\u00f6nt\u00e9st\u00e1mogat\u00f3 form\u00e1ba<\/strong> \u00f6nts\u00fck. Egy vezet\u0151 sz\u00e1m\u00e1ra sokkal t\u00f6bbet \u00e9r egy \u00e1tl\u00e1that\u00f3 dashboard, mint puszta sz\u00e1mok. Excelben ezt meglep\u0151en egyszer\u0171en meg lehet val\u00f3s\u00edtani.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>KPI-k: a legfontosabb mutat\u00f3k egy helyen<\/strong><\/h3>\n\n\n\n<p>A dashboard els\u0151 blokkja n\u00e9h\u00e1ny egyszer\u0171, de hasznos <strong>KPI-t<\/strong> (Key Performance Indicator) tartalmaz:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u00c1tlagos \u00e1ramfelv\u00e9tel<\/strong> \u2013 megmutatja a g\u00e9p tipikus m\u0171k\u00f6d\u00e9s\u00e9t.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sz\u00f3r\u00e1s<\/strong> \u2013 mennyire stabil a m\u0171k\u00f6d\u00e9s, mennyire ingadoznak az adatok.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Als\u00f3 \u00e9s fels\u0151 hat\u00e1r (\u00b13\u03c3)<\/strong> \u2013 innen l\u00e1tszik, hogy hol kezd\u0151dik az anom\u00e1lia.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Anom\u00e1li\u00e1k sz\u00e1ma az utols\u00f3 50 mint\u00e1ban<\/strong> \u2013 gyors betekint\u00e9st ad, mennyire probl\u00e9m\u00e1s a k\u00f6zelm\u00falt.<\/li>\n<\/ul>\n\n\n\n<p>Ezek egy\u00fctt m\u00e1r egy <strong>\u201eegysoros \u00e1llapotjelent\u00e9st\u201d<\/strong> adnak: a g\u00e9p m\u0171k\u00f6d\u00e9se norm\u00e1l tartom\u00e1nyban van-e, vagy \u00e9pp k\u00f6zel\u00edt a kritikus z\u00f3n\u00e1hoz.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"406\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-14.19.45-1024x406.png\" alt=\"\" class=\"wp-image-2555\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-14.19.45-1024x406.png 1024w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-14.19.45-300x119.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-14.19.45-768x304.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-14.19.45-18x7.png 18w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Kepernyofoto-2025-09-23-14.19.45.png 1478w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Grafikon \u00b13\u03c3 hat\u00e1rvonalakkal<\/strong><\/h3>\n\n\n\n<p>A KPI-k mellett a legfontosabb vizualiz\u00e1ci\u00f3 az id\u0151soros grafikon, amelyen l\u00e1tszik:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>a val\u00f3s adatok (pl. \u00e1ramfelv\u00e9tel \u00e9rt\u00e9kek),<\/li>\n\n\n\n<li>az \u00e1tlag (egyenes vonal),<\/li>\n\n\n\n<li>valamint a \u00b13\u03c3 hat\u00e1rvonalak (szaggatott vonal).<\/li>\n<\/ul>\n\n\n\n<p>Ha egy adatpont kil\u00f3g ebb\u0151l a tartom\u00e1nyb\u00f3l, az Excel <strong>felt\u00e9teles form\u00e1z\u00e1ssal pirosan kiemeli<\/strong>. Ez gyorsan r\u00e1ir\u00e1ny\u00edtja a figyelmet a gyan\u00fas m\u0171k\u00f6d\u00e9sre.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Mi\u00e9rt fontos ez \u00fczleti szempontb\u00f3l?<\/strong><\/h3>\n\n\n\n<p>Egy ilyen Excel dashboard:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Id\u0151t takar\u00edt meg<\/strong> \u2013 a karbantart\u00e1svezet\u0151 egy pillant\u00e1ssal l\u00e1tja, mi t\u00f6rt\u00e9nik.<\/li>\n\n\n\n<li><strong>Cs\u00f6kkenti a hibakock\u00e1zatot<\/strong> \u2013 a kiugr\u00e1sok vizu\u00e1lis kiemel\u00e9se miatt nem lehet \u0151ket figyelmen k\u00edv\u00fcl hagyni.<\/li>\n\n\n\n<li><strong>ROI szempontb\u00f3l gyorsan megt\u00e9r\u00fcl<\/strong> \u2013 ha egyetlen v\u00e1ratlan le\u00e1ll\u00e1st is megel\u0151z\u00fcnk vele, m\u00e1ris t\u00f6bb sz\u00e1zezer forintot sp\u00f3rolt a c\u00e9g.<\/li>\n<\/ul>\n\n\n\n<p>Fontos azonban meg\u00e9rteni: ez a m\u00f3dszer <strong>kisebb adathalmazokn\u00e1l \u00e9s 1\u20132 g\u00e9pn\u00e9l m\u0171k\u00f6dik j\u00f3l<\/strong>. Amint t\u00f6bb ezer sornyi adat, t\u00f6bb m\u0171szak vagy t\u00f6bb telephely adatai ker\u00fclnek el\u0151, Excel gyorsan kezelhetetlenn\u00e9 v\u00e1lik. Ez\u00e9rt a dashboard j\u00f3 <strong>bel\u00e9p\u0151 szint<\/strong>, de nem helyettes\u00edti az ipari megold\u00e1sokat.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Pr\u00f3b\u00e1ld ki a saj\u00e1t adataiddal!<\/h2>\n\n\n\n<p>A demo f\u00e1jl itt t\u00f6lthet\u0151 le:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f46f2034-bc95-4977-9e2e-de813953b011\" href=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/predictive_maintenance_dashboard.xlsx\">predictive_maintenance_dashboard<\/a><\/div>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">Mit kapsz a f\u00e1jlban?<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Adat<\/strong> munkalap\n<ul class=\"wp-block-list\">\n<li>500 id\u0151b\u00e9lyeg + m\u00e9rt \u00e9rt\u00e9k (\u00c1ramfelv\u00e9tel_A, H\u0151m\u00e9rs\u00e9klet_C).<\/li>\n\n\n\n<li>Sz\u00e1nd\u00e9kosan be\u00e9p\u00edtett \u201espike\u201d anom\u00e1li\u00e1k.<\/li>\n\n\n\n<li><strong>Als\u00f3Hat\u00e1r<\/strong> \/ <strong>Fels\u0151Hat\u00e1r<\/strong> oszlopok (a Dashboard \u00e9rt\u00e9keit t\u00fckr\u00f6zik).<\/li>\n\n\n\n<li><strong>Felt\u00e9teles form\u00e1z\u00e1s<\/strong>: piros cella, ha az \u00e1ram a fels\u0151 hat\u00e1r f\u00f6l\u00e9 megy.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Dashboard<\/strong> munkalap\n<ul class=\"wp-block-list\">\n<li><strong>\u00c1tlag, sz\u00f3r\u00e1s, \u00b13\u00d7sz\u00f3r\u00e1s<\/strong><\/li>\n\n\n\n<li><strong>Line\u00e1ris el\u0151rejelz\u00e9s<\/strong> a k\u00f6vetkez\u0151 id\u0151pontra (FORECAST).<\/li>\n\n\n\n<li><strong>KPI-k<\/strong> (utols\u00f3 50 minta \u00e1tlaga, anom\u00e1li\u00e1k sz\u00e1ma).<\/li>\n\n\n\n<li><strong>Grafikon<\/strong>: id\u0151 vs. \u00e1ramfelv\u00e9tel + als\u00f3\/fels\u0151 hat\u00e1rvonalak (szaggatott).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Mi\u00e9rt nem el\u00e9g az Excel?<\/h2>\n\n\n\n<p>Az Excel dashboard remek bel\u00e9p\u0151 szint: gyorsan elk\u00e9sz\u00edthet\u0151, mindenki ismeri, \u00e9s pillanatok alatt megmutatja, ha valami rendelleness\u00e9g t\u00f6rt\u00e9nik. <strong>De ipari k\u00f6rnyezetben komoly korl\u00e1tai vannak.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1. Korl\u00e1tos adatkezel\u00e9s<\/strong><\/h3>\n\n\n\n<p>Excel j\u00f3l kezeli az <strong>1\u20132 g\u00e9p adatait<\/strong> n\u00e9h\u00e1ny sz\u00e1z vagy ezer sorig. De amikor:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>t\u00f6bb t\u00edzezer m\u00e9r\u00e9si adat keletkezik naponta,<\/li>\n\n\n\n<li>t\u00f6bb g\u00e9p vagy telephely adatait kell \u00f6sszevetni,<\/li>\n\n\n\n<li>val\u00f3s idej\u0171 monitoring sz\u00fcks\u00e9ges,<\/li>\n<\/ul>\n\n\n\n<p>az Excel <strong>lass\u00fav\u00e1 v\u00e1lik, lefagyhat vagy teljesen \u00e1tl\u00e1thatatlann\u00e1 v\u00e1lik<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2. Nem val\u00f3s idej\u0171<\/strong><\/h3>\n\n\n\n<p>Az Excel alapvet\u0151en ut\u00f3lagos elemz\u00e9sre j\u00f3. Ha egy g\u00e9p t\u00falmelegszik vagy rendellenesen m\u0171k\u00f6dik, Excelben legkor\u00e1bban akkor l\u00e1tjuk, amikor az adat m\u00e1r beker\u00fclt a t\u00e1bl\u00e1zatba. Ez sokszor <strong>t\u00fal k\u00e9s\u0151<\/strong> \u2013 a g\u00e9p addigra meg\u00e1llhatott.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3. Nincs audit\u00e1l\u00e1s \u00e9s jogosults\u00e1gkezel\u00e9s<\/strong><\/h3>\n\n\n\n<p>Egy komoly ipari rendszerben fontos, hogy ki f\u00e9rhet hozz\u00e1 az adatokhoz, ki m\u00f3dos\u00edthatja \u0151ket, \u00e9s legyen <strong>napl\u00f3z\u00e1s<\/strong> minden v\u00e1ltoztat\u00e1sr\u00f3l.<\/p>\n\n\n\n<p>Excel ezt nem tudja. Egy rossz kattint\u00e1s, egy t\u00f6r\u00f6lt oszlop, \u00e9s elveszik az adat.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4. Neh\u00e9zkes egy\u00fcttm\u0171k\u00f6d\u00e9s<\/strong><\/h3>\n\n\n\n<p>Ha t\u00f6bb ember dolgozik ugyanazon az adaton, az Excel f\u00e1jlok verzi\u00f3kezel\u00e9se gyorsan k\u00e1ossz\u00e1 v\u00e1lik. Egy ipari k\u00f6rnyezetben viszont alapfelt\u00e9tel, hogy a karbantart\u00e1s, a termel\u00e9s \u00e9s a vezet\u0151s\u00e9g <strong>ugyanazt az adatot l\u00e1ssa val\u00f3s id\u0151ben<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>5. ROI szempontb\u00f3l vesz\u00e9lyes<\/strong><\/h3>\n\n\n\n<p>Az Excel-ben k\u00e9sz\u00fclt dashboard <strong>gyorsan megt\u00e9r\u00fcl<\/strong>, ha siker\u00fcl egy-k\u00e9t le\u00e1ll\u00e1st megel\u0151zni. De hossz\u00fa t\u00e1von:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>a karbantart\u00e1s nem tudja k\u00f6vetni a n\u00f6vekv\u0151 adatmennyis\u00e9get,<\/li>\n\n\n\n<li>a vezet\u0151k nem kapnak el\u00e9g gyors, pontos k\u00e9pet,<\/li>\n\n\n\n<li>\u00e9s fenn\u00e1ll a kock\u00e1zat, hogy egy kritikus hib\u00e1t id\u0151ben nem vesznek \u00e9szre.<\/li>\n<\/ul>\n\n\n\n<p>Ez v\u00e9g\u00fcl t\u00f6bb vesztes\u00e9get okozhat, mint amennyit a kezdeti Excel-megold\u00e1s megtakar\u00edtott.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Mit vonhatunk le tanuls\u00e1gk\u00e9nt?<\/strong><\/h3>\n\n\n\n<p>Az Excel t\u00f6k\u00e9letes bel\u00e9p\u0151szint\u0171 eszk\u00f6z a predikt\u00edv karbantart\u00e1s kipr\u00f3b\u00e1l\u00e1s\u00e1ra. Gyors, k\u00f6lts\u00e9ghat\u00e9kony \u00e9s azonnal k\u00e9zzelfoghat\u00f3 eredm\u00e9nyt ad. <strong>De hossz\u00fa t\u00e1von nem helyettes\u00edti az ipari szint\u0171 rendszereket<\/strong>, amelyek nagy adatmennyis\u00e9g kezel\u00e9s\u00e9re, val\u00f3s idej\u0171 elemz\u00e9sre \u00e9s t\u00f6bb g\u00e9p \u00f6sszehangolt monitoroz\u00e1s\u00e1ra alkalmasak.<\/p>\n\n\n\n<p>Ezt a blogposztot \u00e9ppen az\u00e9rt k\u00e9sz\u00edtett\u00fck, hogy megmutassuk: <strong>m\u00e1r Excelben is el lehet indulni<\/strong> ezen az \u00faton. Ha pedig a tapasztalatok alapj\u00e1n valaki nagyobb l\u00e9pt\u00e9kben szeretn\u00e9 bevezetni a predikt\u00edv karbantart\u00e1st, ott \u00e9rdemes tov\u00e1bbi technol\u00f3gi\u00e1kban gondolkodni.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"888\" src=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Group-32-1024x888.png\" alt=\"\" class=\"wp-image-2557\" srcset=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Group-32-1024x888.png 1024w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Group-32-300x260.png 300w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Group-32-768x666.png 768w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Group-32-14x12.png 14w, https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/Group-32.png 1118w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Z\u00e1r\u00e1s<\/h2>\n\n\n\n<p>A predikt\u00edv karbantart\u00e1s nem felt\u00e9tlen\u00fcl ig\u00e9nyel azonnal komplex ipari rendszert vagy dr\u00e1ga beruh\u00e1z\u00e1st. M\u00e1r <strong>Excelben is el lehet indulni<\/strong>, \u00e9s az els\u0151 tapasztalatokat megszerezni:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>hogyan viselkednek a g\u00e9pek adatai,<\/li>\n\n\n\n<li>mikor t\u00e9rnek el a norm\u00e1l m\u0171k\u00f6d\u00e9st\u0151l,<\/li>\n\n\n\n<li>hogyan jelezhet\u0151k el\u0151re az anom\u00e1li\u00e1k.<\/li>\n<\/ul>\n\n\n\n<p>Ezek a gyors pr\u00f3b\u00e1k seg\u00edtenek meggy\u0151zni a vezet\u0151s\u00e9get, \u00e9s l\u00e1that\u00f3v\u00e1 tenni, milyen \u00e9rt\u00e9k rejlik a g\u00e9padatokban.<\/p>\n\n\n\n<p>Ugyanakkor hossz\u00fa t\u00e1von az Excelnek megvannak a maga korl\u00e1tai. T\u00f6bb g\u00e9p, nagyobb adatmennyis\u00e9g \u00e9s val\u00f3s idej\u0171 ig\u00e9nyek eset\u00e9n m\u00e1r elengedhetetlen a <strong>sk\u00e1l\u00e1zhat\u00f3 ipari megold\u00e1s<\/strong>, amely biztos\u00edtja a megb\u00edzhat\u00f3s\u00e1got, a gyors reakci\u00f3id\u0151t \u00e9s a pontos el\u0151rejelz\u00e9st.<\/p>\n\n\n\n<p><strong>Tanuls\u00e1g:<\/strong> Excel j\u00f3 eszk\u00f6z a k\u00eds\u00e9rletez\u00e9shez \u00e9s a szeml\u00e9ltet\u00e9shez, de ipari k\u00f6rnyezetben a val\u00f3di \u00e9rt\u00e9ket a professzion\u00e1lis rendszerek hozz\u00e1k. A kett\u0151 nem egym\u00e1s helyett, hanem egym\u00e1s ut\u00e1n ad logikus fejl\u0151d\u00e9si utat:<\/p>\n\n\n\n<p><strong>Excel \u2192 Pilot \u2192 Ipari rendszer.<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-medium-font-size\">\u00c9rdekelne, hogyan haszn\u00e1lhatod az adataidat arra, hogy cs\u00f6kkentsd a le\u00e1ll\u00e1sokat \u00e9s n\u00f6veld a rendelkez\u00e9sre \u00e1ll\u00e1st? Vedd fel vel\u00fcnk a kapcsolatot, \u00e9s mutatunk egy m\u0171k\u00f6d\u0151 p\u00e9ld\u00e1t.<\/p>\n<\/blockquote>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-50 is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link has-medium-font-size has-custom-font-size wp-element-button\" href=\"\/en\/contact\/\">L\u00e9pjen vel\u00fcnk kapcsolatba<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"has-medium-font-size\"><\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Bevezet\u00e9s Egy v\u00e1ratlan g\u00e9ple\u00e1ll\u00e1s sokkal t\u00f6bbe ker\u00fcl, mint els\u0151re gondoln\u00e1nk. Nem csak a kies\u0151 gy\u00e1rt\u00e1si id\u0151r\u0151l van sz\u00f3, hanem a selejtterm\u00e9kekr\u0151l, az \u00fajraind\u00edt\u00e1s k\u00f6lts\u00e9g\u00e9r\u0151l, a hat\u00e1rid\u0151k cs\u00fasz\u00e1s\u00e1r\u00f3l \u00e9s a t\u00fal\u00f3r\u00e1r\u00f3l is. Egy magyar KKV eset\u00e9ben ak\u00e1r t\u00f6bb sz\u00e1zezer forint vesztes\u00e9get jelenthet egyetlen nap \u00e1ll\u00e1sid\u0151. A predikt\u00edv karbantart\u00e1s l\u00e9nyege, hogy a g\u00e9p adataib\u00f3l (pl. \u00e1ramfelv\u00e9tel, h\u0151m\u00e9rs\u00e9klet, [&hellip;]<\/p>","protected":false},"author":1,"featured_media":2559,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2546","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-egyeb"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel - Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra? - Capsule<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.capsule.hu\/en\/prediktiv-karbantartas-excellel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel - Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra? - Capsule\" \/>\n<meta property=\"og:description\" content=\"Bevezet\u00e9s Egy v\u00e1ratlan g\u00e9ple\u00e1ll\u00e1s sokkal t\u00f6bbe ker\u00fcl, mint els\u0151re gondoln\u00e1nk. Nem csak a kies\u0151 gy\u00e1rt\u00e1si id\u0151r\u0151l van sz\u00f3, hanem a selejtterm\u00e9kekr\u0151l, az \u00fajraind\u00edt\u00e1s k\u00f6lts\u00e9g\u00e9r\u0151l, a hat\u00e1rid\u0151k cs\u00fasz\u00e1s\u00e1r\u00f3l \u00e9s a t\u00fal\u00f3r\u00e1r\u00f3l is. Egy magyar KKV eset\u00e9ben ak\u00e1r t\u00f6bb sz\u00e1zezer forint vesztes\u00e9get jelenthet egyetlen nap \u00e1ll\u00e1sid\u0151. A predikt\u00edv karbantart\u00e1s l\u00e9nyege, hogy a g\u00e9p adataib\u00f3l (pl. \u00e1ramfelv\u00e9tel, h\u0151m\u00e9rs\u00e9klet, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.capsule.hu\/en\/prediktiv-karbantartas-excellel\/\" \/>\n<meta property=\"og:site_name\" content=\"Capsule\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-23T14:04:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-23T14:18:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.capsule.hu\/#\/schema\/person\/156c2badf90f1348e08b705e2cd3fa38\"},\"headline\":\"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel &#8211; Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra?\",\"datePublished\":\"2025-09-23T14:04:00+00:00\",\"dateModified\":\"2025-09-23T14:18:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/\"},\"wordCount\":2413,\"publisher\":{\"@id\":\"https:\/\/www.capsule.hu\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png\",\"articleSection\":[\"Egy\u00e9b\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/\",\"url\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/\",\"name\":\"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel - Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra? - Capsule\",\"isPartOf\":{\"@id\":\"https:\/\/www.capsule.hu\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png\",\"datePublished\":\"2025-09-23T14:04:00+00:00\",\"dateModified\":\"2025-09-23T14:18:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage\",\"url\":\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png\",\"contentUrl\":\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png\",\"width\":1536,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.capsule.hu\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel &#8211; Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.capsule.hu\/#website\",\"url\":\"https:\/\/www.capsule.hu\/\",\"name\":\"Capsule\",\"description\":\"okos megold\u00e1sok, egy kapszul\u00e1ban\",\"publisher\":{\"@id\":\"https:\/\/www.capsule.hu\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.capsule.hu\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.capsule.hu\/#organization\",\"name\":\"Capsule\",\"url\":\"https:\/\/www.capsule.hu\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.capsule.hu\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2023\/12\/Capsule-1.png\",\"contentUrl\":\"https:\/\/www.capsule.hu\/wp-content\/uploads\/2023\/12\/Capsule-1.png\",\"width\":519,\"height\":136,\"caption\":\"Capsule\"},\"image\":{\"@id\":\"https:\/\/www.capsule.hu\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.capsule.hu\/#\/schema\/person\/156c2badf90f1348e08b705e2cd3fa38\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.capsule.hu\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e65a3511b5a9802fb5552e52d468242dc2c1b84dda51565701e83e3595c4499f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e65a3511b5a9802fb5552e52d468242dc2c1b84dda51565701e83e3595c4499f?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.capsule.hu\"],\"url\":\"http:\/\/www.capsule.hu\/en\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel - Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra? - Capsule","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.capsule.hu\/en\/prediktiv-karbantartas-excellel\/","og_locale":"en_GB","og_type":"article","og_title":"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel - Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra? - Capsule","og_description":"Bevezet\u00e9s Egy v\u00e1ratlan g\u00e9ple\u00e1ll\u00e1s sokkal t\u00f6bbe ker\u00fcl, mint els\u0151re gondoln\u00e1nk. Nem csak a kies\u0151 gy\u00e1rt\u00e1si id\u0151r\u0151l van sz\u00f3, hanem a selejtterm\u00e9kekr\u0151l, az \u00fajraind\u00edt\u00e1s k\u00f6lts\u00e9g\u00e9r\u0151l, a hat\u00e1rid\u0151k cs\u00fasz\u00e1s\u00e1r\u00f3l \u00e9s a t\u00fal\u00f3r\u00e1r\u00f3l is. Egy magyar KKV eset\u00e9ben ak\u00e1r t\u00f6bb sz\u00e1zezer forint vesztes\u00e9get jelenthet egyetlen nap \u00e1ll\u00e1sid\u0151. A predikt\u00edv karbantart\u00e1s l\u00e9nyege, hogy a g\u00e9p adataib\u00f3l (pl. \u00e1ramfelv\u00e9tel, h\u0151m\u00e9rs\u00e9klet, [&hellip;]","og_url":"https:\/\/www.capsule.hu\/en\/prediktiv-karbantartas-excellel\/","og_site_name":"Capsule","article_published_time":"2025-09-23T14:04:00+00:00","article_modified_time":"2025-09-23T14:18:11+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Estimated reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#article","isPartOf":{"@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/"},"author":{"name":"admin","@id":"https:\/\/www.capsule.hu\/#\/schema\/person\/156c2badf90f1348e08b705e2cd3fa38"},"headline":"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel &#8211; Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra?","datePublished":"2025-09-23T14:04:00+00:00","dateModified":"2025-09-23T14:18:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/"},"wordCount":2413,"publisher":{"@id":"https:\/\/www.capsule.hu\/#organization"},"image":{"@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png","articleSection":["Egy\u00e9b"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/","url":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/","name":"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel - Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra? - Capsule","isPartOf":{"@id":"https:\/\/www.capsule.hu\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage"},"image":{"@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png","datePublished":"2025-09-23T14:04:00+00:00","dateModified":"2025-09-23T14:18:11+00:00","breadcrumb":{"@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#primaryimage","url":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png","contentUrl":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2025\/09\/image.png","width":1536,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.capsule.hu\/prediktiv-karbantartas-excellel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.capsule.hu\/"},{"@type":"ListItem","position":2,"name":"Hogyan tal\u00e1lj g\u00e9phib\u00e1kat Excellel &#8211; Mikor \u00e9rdemes tov\u00e1bbl\u00e9pni ipari megold\u00e1sokra?"}]},{"@type":"WebSite","@id":"https:\/\/www.capsule.hu\/#website","url":"https:\/\/www.capsule.hu\/","name":"Capsule","description":"Smart solutions, encapsulated","publisher":{"@id":"https:\/\/www.capsule.hu\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.capsule.hu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.capsule.hu\/#organization","name":"Capsule","url":"https:\/\/www.capsule.hu\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.capsule.hu\/#\/schema\/logo\/image\/","url":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2023\/12\/Capsule-1.png","contentUrl":"https:\/\/www.capsule.hu\/wp-content\/uploads\/2023\/12\/Capsule-1.png","width":519,"height":136,"caption":"Capsule"},"image":{"@id":"https:\/\/www.capsule.hu\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.capsule.hu\/#\/schema\/person\/156c2badf90f1348e08b705e2cd3fa38","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.capsule.hu\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e65a3511b5a9802fb5552e52d468242dc2c1b84dda51565701e83e3595c4499f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e65a3511b5a9802fb5552e52d468242dc2c1b84dda51565701e83e3595c4499f?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.capsule.hu"],"url":"http:\/\/www.capsule.hu\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/posts\/2546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/comments?post=2546"}],"version-history":[{"count":2,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/posts\/2546\/revisions"}],"predecessor-version":[{"id":2560,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/posts\/2546\/revisions\/2560"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/media\/2559"}],"wp:attachment":[{"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/media?parent=2546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/categories?post=2546"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.capsule.hu\/en\/wp-json\/wp\/v2\/tags?post=2546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}