{"id":96098,"date":"2026-10-04T04:30:32","date_gmt":"2026-10-04T04:30:32","guid":{"rendered":"https:\/\/skyplanner.ai\/?p=96098"},"modified":"2026-10-19T14:42:42","modified_gmt":"2026-10-19T14:42:42","slug":"gyartastervezes-excel-sablon","status":"publish","type":"post","link":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/","title":{"rendered":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz"},"content":{"rendered":"<div class=\"gb-container gb-container-article01 article-main-content-container\">\n\n<h1 class=\"wp-block-heading\">Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz<\/h1>\n\n\n<p>Egy gy\u00e1rt\u00e1si \u00fctemterv sablonban minden rendel\u00e9snek jut hely. A nehezebb k\u00e9rd\u00e9s az, hogy az \u00fczemben is jut-e: egy szabad g\u00e9pen, a megfelel\u0151 g\u00e9pkezel\u0151vel, m\u00e9g id\u0151ben ahhoz, hogy a k\u00f6vetkez\u0151 m\u0171velet \u00e9s a vev\u0151nek t\u00f6rt\u00e9n\u0151 kisz\u00e1ll\u00edt\u00e1s is hat\u00e1rid\u0151re megt\u00f6rt\u00e9njen.<\/p>\n\n\n<p><a href=\"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template.csv\">T\u00f6ltse le a gy\u00e1rt\u00e1si \u00fctemterv sablont (CSV Excelhez)<\/a>. Ez egy egyszer\u0171, saj\u00e1t ig\u00e9nyeire szabhat\u00f3 gy\u00e1rt\u00e1si p\u00e9lda, amelyben minden m\u0171velet k\u00fcl\u00f6n sorban szerepel. Az al\u00e1bbi t\u00e1bl\u00e1zat a k\u00e9t mintafeladatot mutatja; a f\u00e1jl az id\u0151pontok mellett a teljes d\u00e1tumokat is tartalmazza.<\/p>\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Rendel\u00e9s \/ m\u0171velet<\/th>\n<th>G\u00e9p \/ g\u00e9pkezel\u0151<\/th>\n<th style=\"text-align: right;\">\u00c1t\u00e1ll\u00e1s (perc)<\/th>\n<th style=\"text-align: right;\">Megmunk\u00e1l\u00e1s (perc)<\/th>\n<th>Kezd\u00e9s<\/th>\n<th>Befejez\u00e9s<\/th>\n<th>Hat\u00e1rid\u0151<\/th>\n<th>\u00c1llapot<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>A \/ A-10<\/td>\n<td>M1 \/ O1<\/td>\n<td style=\"text-align: right;\">30<\/td>\n<td style=\"text-align: right;\">120<\/td>\n<td>08:00<\/td>\n<td>10:30<\/td>\n<td>12:00<\/td>\n<td>Tervezett<\/td>\n<\/tr>\n<tr>\n<td>B \/ B-10<\/td>\n<td>M1 \/ O1<\/td>\n<td style=\"text-align: right;\">15<\/td>\n<td style=\"text-align: right;\">180<\/td>\n<td>10:30<\/td>\n<td>13:45<\/td>\n<td>16:00<\/td>\n<td>Tervezett<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n<p>A sablonnal megismerheti a sz\u00fcks\u00e9ges bemen\u0151 adatokat, \u00e9s kipr\u00f3b\u00e1lhat egy egyszer\u0171 m\u0171veleti sorrendet. Ha olyan gy\u00e1rt\u00e1si tervre van sz\u00fcks\u00e9ge, amely \u00faj rendel\u00e9sek, k\u00e9s\u00e9sek \u00e9s v\u00e1ltoz\u00f3 kapacit\u00e1s mellett is haszn\u00e1lhat\u00f3 marad, a SkyPlanner APS seg\u00edts\u00e9g\u00e9vel sz\u00e1m\u00edtsa ki az \u00fctemtervet. A t\u00e1bl\u00e1zat megmutatja az \u00d6n \u00e1ltal kiv\u00e1lasztott kezd\u00e9si id\u0151pontokat; a SkyPlanner pedig \u00fagy \u00fctemezi a m\u0171veleteket, hogy belef\u00e9rjenek a rendelkez\u00e9sre \u00e1ll\u00f3 kapacit\u00e1sba.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Mire kell v\u00e1laszt adnia egy gy\u00e1rt\u00e1si \u00fctemterv sablonnak?<\/h2>\n\n\n<p>A gy\u00e1rt\u00e1si \u00fctemterv meghat\u00e1rozza, hogy az egyes munk\u00e1kat mely er\u0151forr\u00e1sokon \u00e9s mikor v\u00e9gzik el. M\u0171veleti szinten n\u00e9gy k\u00e9rd\u00e9sre kell v\u00e1laszt adnia:<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mit kell elv\u00e9gezni?<\/strong> Azonos\u00edtsa a rendel\u00e9st \u00e9s a konkr\u00e9t m\u0171veletet; ne csak a term\u00e9k nev\u00e9t adja meg.<\/li>\n<li><strong>Hol v\u00e9gezhet\u0151 el?<\/strong> Adja meg a g\u00e9pet vagy munka\u00e1llom\u00e1st, valamint a munk\u00e1hoz sz\u00fcks\u00e9ges szem\u00e9lyeket.<\/li>\n<li><strong>Mikor v\u00e9gezhet\u0151 el?<\/strong> Vegye figyelembe az \u00e1t\u00e1ll\u00e1st, a megmunk\u00e1l\u00e1si id\u0151t, a munkaid\u0151szakokat \u00e9s mindazt, aminek el\u0151bb rendelkez\u00e9sre kell \u00e1llnia.<\/li>\n<li><strong>Id\u0151ben befejez\u0151dik?<\/strong> Vesse \u00f6ssze az eredm\u00e9nyt a m\u0171velet el\u0151\u00edrt befejez\u00e9si hat\u00e1ridej\u00e9vel \u00e9s a kisz\u00e1ll\u00edt\u00e1sig m\u00e9g h\u00e1tral\u00e9v\u0151 munk\u00e1val.<\/li>\n<\/ul>\n\n\n<p>Ez az ut\u00f3bbi k\u00fcl\u00f6nbs\u00e9g l\u00e9nyeges. Egy megmunk\u00e1l\u00e1si m\u0171velet befejez\u00e9se m\u00e9g nem jelenti azt, hogy a rendel\u00e9s kisz\u00e1ll\u00edthat\u00f3, ha ut\u00e1na m\u00e9g \u00f6sszeszerel\u00e9s, ellen\u0151rz\u00e9s vagy csomagol\u00e1s k\u00f6vetkezik. Minden m\u0171velethez olyan befejez\u00e9si hat\u00e1rid\u0151t adjon meg, amely mellett a k\u00f6vetkez\u0151 l\u00e9p\u00e9sekre is marad id\u0151.<\/p>\n\n\n<p>A heti mennyis\u00e9gi terv hasznos, de m\u00e1s k\u00e9rd\u00e9sre ad v\u00e1laszt. A <a href=\"\/hu\/forrasok\/master-production-schedule\/\">f\u0151 gy\u00e1rt\u00e1si \u00fctemterv<\/a> azt r\u00f6gz\u00edti, hogy milyen k\u00e9szterm\u00e9kekre van sz\u00fcks\u00e9g, \u00e9s mikorra. Ez a sablon az eggyel r\u00e9szletesebb szinthez k\u00e9sz\u00fclt: azokhoz a konkr\u00e9t m\u0171veletekhez, amelyek ugyanaz\u00e9rt a g\u00e9pid\u0151\u00e9rt \u00e9s g\u00e9pkezel\u0151i id\u0151\u00e9rt versengenek. A <a href=\"\/hu\/forrasok\/mi-a-termelesutemezes\/\">gy\u00e1rt\u00e1s\u00fctemez\u00e9si \u00fatmutat\u00f3<\/a> bemutatja, hogyan lesz ezekb\u0151l a bemen\u0151 adatokb\u00f3l v\u00e9grehajthat\u00f3 sorrend.<\/p>\n\n\n<h2 class=\"wp-block-heading\">A mint\u00e1ban minden sor kapacit\u00e1st foglal le<\/h2>\n\n\n<p>K\u00e9pzeljen el egy \u00fczemet, ahol k\u00e9t gy\u00e1rt\u00e1si feladat v\u00e1r ugyanarra a g\u00e9pre, az M1-re, \u00e9s ugyanarra a g\u00e9pkezel\u0151re, az O1-re. Mindkett\u0151h\u00f6z rendelkez\u00e9sre \u00e1ll az anyag. A g\u00e9p \u00e9s a g\u00e9pkezel\u0151 08:00 \u00e9s 16:00 k\u00f6z\u00f6tt folyamatosan el\u00e9rhet\u0151, \u00e9s egyik m\u0171veletet sem el\u0151zi meg m\u00e9g befejezetlen m\u0171velet.<\/p>\n\n\n<p>Az A feladat 30 percet foglal le \u00e1t\u00e1ll\u00e1sra \u00e9s 120 percet megmunk\u00e1l\u00e1sra, \u00edgy 10:30-ig k\u00f6ti le az er\u0151forr\u00e1st. Ezut\u00e1n a B feladat 15 percet foglal le \u00e1t\u00e1ll\u00e1sra \u00e9s 180 percet megmunk\u00e1l\u00e1sra, \u00e9s 13:45-kor fejez\u0151dik be. A k\u00e9t feladat nem fedi \u00e1t egym\u00e1st, \u00e9s mindkett\u0151 a megadott hat\u00e1rid\u0151 el\u0151tt elk\u00e9sz\u00fcl.<\/p>\n\n\n<p>Ez a sorrend az\u00e9rt m\u0171k\u00f6dik, mert a felt\u00e9telez\u00e9sek teljes\u00fclnek. Ha az O1 g\u00e9pkezel\u0151re 11:00-kor egy m\u00e1sik g\u00e9pn\u00e9l van sz\u00fcks\u00e9g, a B sorban szerepl\u0151 beoszt\u00e1s m\u00e1r nem hajthat\u00f3 v\u00e9gre, hi\u00e1ba szabad tov\u00e1bbra is az M1. Ha van eb\u00e9dsz\u00fcnet, megszakad a folyamatos munkaid\u0151szak. Ha pedig ezek k\u00f6zbens\u0151 m\u0171veletek, a k\u00e9s\u0151bbi l\u00e9p\u00e9sekhez is k\u00fcl\u00f6n kapacit\u00e1sra van sz\u00fcks\u00e9g.<\/p>\n\n\n<p>A t\u00e1bl\u00e1zat \u00e9rt\u00e9k\u00e9t nem a sz\u00ednez\u00e9se adja, hanem az, hogy minden sor lek\u00f6t egy r\u00e9szt az er\u0151forr\u00e1s rendelkez\u00e9sre \u00e1ll\u00f3 idej\u00e9b\u0151l.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Szabja testre a sablont \u00fagy, hogy a korl\u00e1tok is l\u00e1that\u00f3k maradjanak<\/h2>\n\n\n<p>Nyissa meg a CSV-f\u00e1jlt Excelben, \u00e9s mentse el a munkap\u00e9ld\u00e1nyt Excel-munkaf\u00fczetk\u00e9nt. Ha minden adat egyetlen oszlopban jelenik meg, vessz\u0151t haszn\u00e1lva elv\u00e1laszt\u00f3k\u00e9nt import\u00e1lja a f\u00e1jlt. A let\u00f6lt\u00f6tt CSV p\u00e9ldaadatokat tartalmaz, nem automatiz\u00e1lt \u00fctemez\u00e9si modellt.<\/p>\n\n\n<p>A p\u00e9ld\u00e1ban szerepl\u0151 d\u00e1tum <strong>2026. okt\u00f3ber 5.<\/strong> Cser\u00e9lje le a t\u00e9nyleges munkanapokra, \u00e9s ellen\u0151rizze, hogy a Kezd\u00e9s, Befejez\u00e9s \u00e9s Hat\u00e1rid\u0151 mez\u0151k val\u00f3di d\u00e1tum- \u00e9s id\u0151\u00e9rt\u00e9keket tartalmaznak-e, nem pedig import\u00e1lt sz\u00f6veget. Az id\u0151 mellett a d\u00e1tumot is jelen\u00edtse meg; k\u00fcl\u00f6nben a holnapi 08:00 ugyan\u00fagy n\u00e9zhet ki, mint a mai.<\/p>\n\n\n<h3 class=\"wp-block-heading\">Minden m\u0171velethez adjon meg k\u00fcl\u00f6n azonos\u00edt\u00f3t \u00e9s egy\u00e9rtelm\u0171 id\u0151adatokat<\/h3>\n\n\n<p>Az A \u00e9s B hely\u00e9re \u00edrja be saj\u00e1t rendel\u00e9s- \u00e9s m\u0171veletazonos\u00edt\u00f3it. Ha egy rendel\u00e9shez v\u00e1g\u00e1s, hajl\u00edt\u00e1s \u00e9s hegeszt\u00e9s sz\u00fcks\u00e9ges, ezeket k\u00fcl\u00f6n sorokban r\u00f6gz\u00edtse. A sorrendj\u00fcket a <a href=\"\/hu\/forrasok\/gyartasi-utvonal\/\">technol\u00f3giai \u00fatvonal<\/a> hat\u00e1rozza meg, nem az, hogy \u00e9ppen melyik sor k\u00f6vetkezik a t\u00e1bl\u00e1zatban.<\/p>\n\n\n<p>A Megmunk\u00e1l\u00e1s (perc) mez\u0151 a <strong>teljes t\u00e9tel megmunk\u00e1l\u00e1si idej\u00e9t<\/strong> jelenti. Ha a becsl\u00e9se darabonk\u00e9nti id\u0151re vonatkozik, bevitel el\u0151tt szorozza meg a mennyis\u00e9ggel. Az \u00c1t\u00e1ll\u00e1s (perc) ezen fel\u00fcli id\u0151, amely szint\u00e9n lek\u00f6ti a g\u00e9pet; ne rejtse el egy nem r\u00e9szletezett \u00f6sszid\u0151ben, \u00e9s ne sz\u00e1molja el k\u00e9tszer.<\/p>\n\n\n<p>Folyamatosan v\u00e9gzett m\u0171velet eset\u00e9n az F2 cella r\u00f6gz\u00edtett Befejez\u00e9s \u00e9rt\u00e9k\u00e9t cser\u00e9lje erre a k\u00e9pletre, majd m\u00e1solja le az alatta l\u00e9v\u0151 sorokba:<\/p>\n\n\n<p><code>=E2+(C2+D2)\/1440<\/code><\/p>\n\n\n<p>A k\u00e9plet hozz\u00e1adja a kezd\u00e9si id\u0151ponthoz az \u00e1t\u00e1ll\u00e1s \u00e9s a megmunk\u00e1l\u00e1s perceit. Nem v\u00e1laszt kezd\u00e9si id\u0151pontot, nem ker\u00fcli el a m\u00e1s feladatokkal val\u00f3 \u00fctk\u00f6z\u00e9st, \u00e9s nem helyezi \u00e1t a munk\u00e1t a m\u0171szakon k\u00edv\u00fcli id\u0151szakokr\u00f3l. Ebben a t\u00e1bl\u00e1zatban tov\u00e1bbra is \u00d6n hozza meg ezeket az \u00fctemez\u00e9si d\u00f6nt\u00e9seket.<\/p>\n\n\n<h3 class=\"wp-block-heading\">R\u00f6gz\u00edtse, minek kell rendelkez\u00e9sre \u00e1llnia a munka megkezd\u00e9se el\u0151tt<\/h3>\n\n\n<p>A m\u0171veletlista mellett minden g\u00e9p \u00e9s g\u00e9pkezel\u0151 munkaid\u0151szakait vezesse d\u00e1tummal egy\u00fctt. R\u00f6gz\u00edtse a sz\u00fcneteket, a karbantart\u00e1st \u00e9s az egy\u00e9b kies\u0151 id\u0151szakokat. A G\u00e9p \u00e9s a G\u00e9pkezel\u0151 adatokat bontsa k\u00fcl\u00f6n oszlopokba, ha a beoszt\u00e1sukat egym\u00e1st\u00f3l f\u00fcggetlen\u00fcl kell ellen\u0151riznie.<\/p>\n\n\n<p>T\u00f6bbl\u00e9p\u00e9ses rendel\u00e9sekhez vegyen fel egy El\u0151z\u0151 m\u0171velet oszlopot, \u00e9s \u00edrja bele az el\u0151z\u0151 m\u0171velet azonos\u00edt\u00f3j\u00e1t. Ha a kezd\u00e9s egy sz\u00e1ll\u00edt\u00e1st\u00f3l f\u00fcgg, r\u00f6gz\u00edtse azt is, mikor \u00e1ll rendelkez\u00e9sre az anyag. Egy sor csak akkor \u00fctemezhet\u0151, ha a sz\u00fcks\u00e9ges bemen\u0151 felt\u00e9telek teljes\u00fclnek, \u00e9s az el\u0151z\u0151 munk\u00e1k is elk\u00e9sz\u00fcltek.<\/p>\n\n\n<p>Ha egy m\u0171velet nem szak\u00edthat\u00f3 meg, olyan folyamatos munkaid\u0151szakra van sz\u00fcks\u00e9ge, amelybe az \u00e1t\u00e1ll\u00e1s \u00e9s a megmunk\u00e1l\u00e1s is belef\u00e9r. Ha megszak\u00edthat\u00f3, az egyszer\u0171 befejez\u00e9si k\u00e9plet nem sz\u00e1m\u00edtja ki a t\u00f6bb munkaid\u0151szakon \u00e1t tart\u00f3 m\u0171velet befejez\u00e9s\u00e9t. Ehhez k\u00fcl\u00f6n, a munkanapt\u00e1rt is figyelembe vev\u0151 sz\u00e1m\u00edt\u00e1s sz\u00fcks\u00e9ges.<\/p>\n\n\n<p>Itt mutatkozik meg a sablonban az igazi tervez\u00e9si feladat: nem az \u00fajabb sorok bevitele, hanem annak ellen\u0151rz\u00e9se, hogyan hatnak egym\u00e1sra a sorokban szerepl\u0151 munk\u00e1k.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Tesztelje a tervet egy felt\u00e9telez\u00e9s megv\u00e1ltoztat\u00e1s\u00e1val<\/h2>\n\n\n<p>Miel\u0151tt egy t\u00e1bl\u00e1zatban k\u00e9sz\u00fclt \u00fctemtervre t\u00e1maszkodna, n\u00e9zze meg, mi t\u00f6rt\u00e9nik, ha v\u00e1ltozik a gy\u00e1rt\u00e1s.<\/p>\n\n\n<p>Tegy\u00fck fel, hogy az A feladat 10:30-kor elk\u00e9sz\u00fclt, de az M1 g\u00e9p 10:30 \u00e9s 13:00 k\u00f6z\u00f6tt nem \u00e1ll rendelkez\u00e9sre. A B feladat m\u00e9g nem kezd\u0151d\u00f6tt el. Az \u00e1t\u00e1ll\u00e1shoz \u00e9s megmunk\u00e1l\u00e1shoz sz\u00fcks\u00e9ges 195 perc miatt most 16:15-kor fejez\u0151dne be, ha a munka folyamatosan haladna.<\/p>\n\n\n<p>Ez a befejez\u00e9s t\u00fall\u00e9pi mind a munkaid\u0151szak 16:00-s v\u00e9g\u00e9t, mind a B feladat 16:00-s hat\u00e1ridej\u00e9t. Ez figyelmeztet\u00e9s, nem j\u00f3v\u00e1hagyott \u00faj \u00fctemterv. A B kezd\u00e9si id\u0151pontj\u00e1nak \u00e1t\u00edr\u00e1sa felt\u00e1rta a probl\u00e9m\u00e1t, de nem oldotta meg.<\/p>\n\n\n<p>Megvizsg\u00e1lhat egy m\u00e1sik alkalmas g\u00e9pet, amelyhez szabad g\u00e9pkezel\u0151 is van, a munkaid\u0151 j\u00f3v\u00e1hagyott meghosszabb\u00edt\u00e1s\u00e1t vagy egy m\u00e1sik v\u00e1llalt sz\u00e1ll\u00edt\u00e1si hat\u00e1rid\u0151t. A B feladat \u00e1thelyez\u00e9sekor azonban az \u00faj helyre m\u00e1r beosztott munk\u00e1kat is ellen\u0151riznie kell. Ha a B ut\u00e1n tov\u00e1bbi m\u0171velet k\u00f6vetkezik, annak kezd\u00e9s\u00e9t is m\u00f3dos\u00edtani kellhet.<\/p>\n\n\n<p>Ez a k\u00fcl\u00f6nbs\u00e9g az egyszer\u0171 sz\u00e1m\u00edt\u00e1s \u00e9s a <a href=\"\/hu\/forrasok\/veges-kapacitasu-utemezes\/\">v\u00e9ges kapacit\u00e1s\u00fa \u00fctemez\u00e9s<\/a> k\u00f6z\u00f6tt. A sz\u00e1m\u00edt\u00e1s megadja, mikor \u00e9rne v\u00e9get a munka a v\u00e1lasztott beoszt\u00e1s szerint. Az \u00fctemez\u00e9s viszont \u00fagy tal\u00e1l helyet a munk\u00e1nak, hogy az ne l\u00e9pje t\u00fal a rendelkez\u00e9sre \u00e1ll\u00f3 kapacit\u00e1st.<\/p>\n\n\n<p>Miel\u0151tt kiadn\u00e1 a t\u00e1bl\u00e1zatban k\u00e9sz\u00fclt tervet, ellen\u0151rizze a g\u00e9pek \u00e9s g\u00e9pkezel\u0151k beoszt\u00e1s\u00e1nak \u00e1tfed\u00e9seit, az anyagokat, az el\u0151z\u0151 m\u0171veleteket, a munkaid\u0151szakokat \u00e9s a befejez\u00e9si hat\u00e1rid\u0151ket. \u0150rizze meg az elk\u00e9sz\u00fclt munk\u00e1k t\u00e9nyleges id\u0151adatait, \u00e9s egy\u00e9rtelm\u0171en jel\u00f6lje a j\u00f3v\u00e1hagyott verzi\u00f3t, hogy az \u00fczemben ne egy elavult p\u00e9ld\u00e1ny alapj\u00e1n dolgozzanak.<\/p>\n\n\n<p>A p\u00e9ld\u00e1ban ezek az ellen\u0151rz\u00e9sek m\u00e9g k\u00f6nnyen elv\u00e9gezhet\u0151k. Egy folyamatosan v\u00e1ltoz\u00f3 \u00fczemben viszont minden \u00e9rintett rendel\u00e9sn\u00e9l meg kell ism\u00e9telni \u0151ket: \u00e9ppen ezt a munk\u00e1t \u00e9rdemes egy \u00fctemez\u0151szoftverre b\u00edzni. Az <a href=\"\/hu\/forrasok\/excel-gyartastervezes-kihivasai-es-skyplanner-aps-megoldas\/\">Excel-alap\u00fa gy\u00e1rt\u00e1stervez\u00e9s neh\u00e9zs\u00e9geir\u0151l sz\u00f3l\u00f3 r\u00e9szletes \u00fatmutat\u00f3<\/a> bemutatja, mi\u00e9rt n\u0151 egyre nagyobbra a t\u00e1bl\u00e1zatok naprak\u00e9szen tart\u00e1s\u00e1nak terhe.<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u00d6n ir\u00e1ny\u00edtja a tervet, a SkyPlanner a kapacit\u00e1shoz igaz\u00edtja a munk\u00e1t<\/h2>\n\n\n<p>A SkyPlanner a munka\u00e1llom\u00e1sokat, m\u0171szakokat, g\u00e9pkezel\u0151ket, priorit\u00e1sokat \u00e9s anyagokat egyar\u00e1nt bevonja az \u00fctemez\u00e9sbe. \u00d6n megadja a gy\u00e1rt\u00e1si er\u0151forr\u00e1sokat \u00e9s a m\u0171veletek adatait; az Arcturus, a rendszer \u00fctemez\u00e9sre szolg\u00e1l\u00f3 mesters\u00e9ges intelligenci\u00e1ja pedig a be\u00e1ll\u00edtott kapacit\u00e1sok \u00e9s f\u00fcgg\u0151s\u00e9gek alapj\u00e1n kisz\u00e1m\u00edtja a sorrendet. Az eredm\u00e9ny a Gantt-id\u0151vonalon jelenik meg, minden munka\u00e1llom\u00e1s saj\u00e1t feladatsor\u00e1val \u00e9s az \u00f6sszetartoz\u00f3 folyamatl\u00e9p\u00e9sek k\u00f6z\u00f6tti kapcsolatokkal.<\/p>\n\n\n<p>Az M1 kies\u00e9se eset\u00e9n r\u00f6gz\u00edti a nem el\u00e9rhet\u0151 id\u0151szakot, majd \u00fajrasz\u00e1m\u00edtja az \u00fctemtervet. Az Arcturus a megadott er\u0151forr\u00e1s-lehet\u0151s\u00e9gek \u00e9s korl\u00e1tok alapj\u00e1n \u00fagy \u00fctemez, hogy a kies\u0151 kapacit\u00e1st ne haszn\u00e1lja. Ezut\u00e1n \u00e1ttekintheti az eredm\u00e9nyt, \u00e9s l\u00e1thatja, mely rendel\u00e9sek befejez\u00e9se ig\u00e9nyel figyelmet, ahelyett, hogy saj\u00e1t maga k\u00f6vetn\u00e9 v\u00e9gig a v\u00e1ltoz\u00e1s minden tovagy\u0171r\u0171z\u0151 hat\u00e1s\u00e1t a t\u00e1bl\u00e1zat soraiban.<\/p>\n\n\n<p>Ha enged\u00e9lyezi az anyagell\u00e1t\u00e1st figyelembe vev\u0151 \u00fctemez\u00e9st, a sz\u00e1m\u00edt\u00e1s az anyagok rendelkez\u00e9sre \u00e1ll\u00e1s\u00e1val is sz\u00e1molhat. A z\u00e1rol\u00e1sok megv\u00e9dik azokat a munk\u00e1kat, amelyeket nem szeretne \u00e1thelyezni, az el\u0151re be\u00e1ll\u00edtott priorit\u00e1sok pedig megadj\u00e1k, mely v\u00e1llal\u00e1sok a legfontosabbak. <strong>\u00d6n hat\u00e1rozza meg a priorit\u00e1sokat; a mesters\u00e9ges intelligencia k\u00f6veti \u0151ket.<\/strong> E d\u00f6nt\u00e9sek v\u00e9grehajt\u00e1s\u00e1hoz nem kell minden feladatot egyenk\u00e9nt elhelyeznie.<\/p>\n\n\n<p>Az el\u0151ny nem puszt\u00e1n egy rendezettebb rendel\u00e9slista, hanem egy olyan terv, amellyel az \u00fczemi v\u00e1ltoz\u00e1sok mellett is dolgozhat. Figyelm\u00e9t a gy\u00e1rt\u00e1si d\u00f6nt\u00e9sekre ford\u00edthatja: sz\u00fcks\u00e9ges-e t\u00f6bb kapacit\u00e1s, m\u00f3dos\u00edtani kell-e egy priorit\u00e1st, vagy egyeztetni kell-e a vev\u0151vel egy hat\u00e1rid\u0151r\u0151l. A d\u00f6nt\u00e9sek m\u00f6g\u00f6tti \u00fctemez\u00e9si sz\u00e1m\u00edt\u00e1sokat a SkyPlanner v\u00e9gzi el.<\/p>\n\n\n<p><a href=\"\/hu\/funkciok\/\">Ismerje meg a SkyPlanner \u00fctemez\u00e9si funkci\u00f3it<\/a>, \u00e9s n\u00e9zze meg, hogyan t\u00e1mogatja ezt a munk\u00e1t a Gantt, az er\u0151forr\u00e1sok rendelkez\u00e9sre \u00e1ll\u00e1s\u00e1nak kezel\u00e9se \u00e9s az automatikus \u00fctemez\u00e9s.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Mit hozott az UTU sz\u00e1m\u00e1ra az Excel lev\u00e1lt\u00e1sa?<\/h2>\n\n\n<p>Az UTU ulvilai gy\u00e1ra villamos eloszt\u00f3- \u00e9s kapcsol\u00f3berendez\u00e9seket gy\u00e1rt. A SkyPlanner bevezet\u00e9se el\u0151tt az egyes r\u00e9szlegek saj\u00e1t, k\u00e9zzel friss\u00edtett Excel-t\u00e1bl\u00e1zatokban terveztek. Az ERP-ben m\u00f3dos\u00edtott gy\u00e1rt\u00e1si sorrend nem mindig jutott el az \u00fczembe, \u00e9s neh\u00e9z volt \u00e1tl\u00e1tni a t\u00e9nyleges kapacit\u00e1st.<\/p>\n\n\n<p>Nem egyszer\u0171en egy oszlop hi\u00e1nyzott. A neh\u00e9zs\u00e9get az jelentette, hogy a rendel\u00e9si adatok, a gy\u00e1rt\u00e1si sorrend \u00e9s a munk\u00e1t v\u00e9gz\u0151 emberek folyamatosan \u00f6sszhangban maradjanak.<\/p>\n\n\n<p>Az UTU az Oracle NetSuite-ra val\u00f3 \u00e1t\u00e1ll\u00e1s sor\u00e1n v\u00e1lasztotta a SkyPlanner megold\u00e1s\u00e1t. Az UTU-n\u00e1l bevezetett SkyPlanner kapcsol\u00f3dik a NetSuite-hoz \u00e9s a b\u00e9rsz\u00e1mfejt\u00e9si rendszerhez, \u00e9s egyetlen rendszerben fogja \u00f6ssze a gy\u00e1r gy\u00e1rt\u00f3sorait \u00e9s r\u00e9szlegeit. A csapat k\u00fcl\u00f6n\u00f6sen fontosnak tartja a mesters\u00e9ges intelligenci\u00e1val t\u00e1mogatott \u00fctemez\u00e9s \u00e9s a Gantt-id\u0151vonal egy\u00fcttes haszn\u00e1lat\u00e1t: a m\u0171veletek sorrendje, a kapacit\u00e1s \u00e9s az el\u0151rehalad\u00e1s egy helyen l\u00e1that\u00f3.<\/p>\n\n\n<p>Az UTU besz\u00e1mol\u00f3ja szerint <strong>hetente k\u00f6r\u00fclbel\u00fcl k\u00e9t \u00f3r\u00e1t takar\u00edtanak meg a t\u00e1bl\u00e1zatok k\u00e9zi friss\u00edt\u00e9s\u00e9n<\/strong>, a friss\u00edtett feladatsor pedig m\u00e1sodpercek alatt eljut a szerel\u0151kh\u00f6z. A gyakorlatban ezt jelenti a sablonon val\u00f3 t\u00fall\u00e9p\u00e9s: kevesebb munka a m\u00e1solatok naprak\u00e9szen tart\u00e1s\u00e1val, \u00e9s egy\u00e9rtelm\u0171bb munkasorrend a feladatokat v\u00e9gz\u0151 koll\u00e9g\u00e1knak.<\/p>\n\n\n<p><a href=\"\/hu\/ugyfeltortenetek\/utu\/\">Olvassa el az UTU tapasztalatait az Excelr\u0151l a SkyPlannerre val\u00f3 \u00e1t\u00e1ll\u00e1sr\u00f3l<\/a>.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Tartsa meg a hasznos alapadatokat. Ne \u00e9p\u00edtse \u00fajra folyton az \u00fctemtervet.<\/h2>\n\n\n<p>A sablon seg\u00edt meghat\u00e1rozni az \u00fctemez\u00e9shez sz\u00fcks\u00e9ges adatokat: a m\u0171veleteket, az id\u0151tartamokat, az er\u0151forr\u00e1sokat, azok rendelkez\u00e9sre \u00e1ll\u00e1s\u00e1t \u00e9s az elv\u00e1rt befejez\u00e9si id\u0151pontokat. Ezek hasznos\u00edt\u00e1s\u00e1hoz nem kell folyton Excelben sz\u00e1molnia, hogyan hatnak egym\u00e1sra.<\/p>\n\n\n<p><strong>A SkyPlanner a ny\u00edlt REST API-j\u00e1n kereszt\u00fcl b\u00e1rmely ERP- vagy MES-rendszerrel integr\u00e1lhat\u00f3.<\/strong> A jobb \u00fctemez\u00e9s a megl\u00e9v\u0151 rendszereire \u00e9p\u00fclhet, mik\u00f6zben a priorit\u00e1sok meghat\u00e1roz\u00e1sa \u00e9s a gy\u00e1rt\u00e1si d\u00f6nt\u00e9sek tov\u00e1bbra is az \u00d6n kez\u00e9ben maradnak.<\/p>\n\n\n<p><a href=\"\/hu\/kapcsolat-ertekesites\/\">Foglaljon SkyPlanner-bemutat\u00f3t<\/a>, \u00e9s gondoljon egy tipikus rendel\u00e9s technol\u00f3giai \u00fatvonal\u00e1ra, valamint egy k\u00f6zelm\u00faltbeli \u00fctemez\u00e9si v\u00e1ltoz\u00e1sra. Ezek p\u00e9ld\u00e1j\u00e1n megvizsg\u00e1lhatja, hogyan \u00fctemezhet\u0151 a munka a g\u00e9pek \u00e9s a dolgoz\u00f3k korl\u00e1tozott kapacit\u00e1sa, valamint az egym\u00e1ssal verseng\u0151 hat\u00e1rid\u0151k mellett. Vagy <a href=\"\/hu\/proba\/\">pr\u00f3b\u00e1lja ki a SkyPlanner megold\u00e1s\u00e1t dem\u00f3adatokkal<\/a>, \u00e9s tekintse meg az \u00fctemtervet a Gantt-diagramon, miel\u0151tt megtervezn\u00e9 a saj\u00e1t be\u00e1ll\u00edt\u00e1sait.<\/p>\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz Egy gy\u00e1rt\u00e1si \u00fctemterv sablonban minden rendel\u00e9snek jut hely. A nehezebb k\u00e9rd\u00e9s az, hogy az \u00fczemben is jut-e: egy szabad g\u00e9pen, a megfelel\u0151 g\u00e9pkezel\u0151vel, m\u00e9g id\u0151ben ahhoz, hogy a k\u00f6vetkez\u0151 m\u0171velet \u00e9s a vev\u0151nek t\u00f6rt\u00e9n\u0151 kisz\u00e1ll\u00edt\u00e1s is hat\u00e1rid\u0151re megt\u00f6rt\u00e9njen. T\u00f6ltse le a gy\u00e1rt\u00e1si \u00fctemterv sablont (CSV Excelhez). Ez &#8230; <a title=\"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz\" class=\"read-more\" href=\"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/\" aria-label=\"Read more about Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz\">Olvass tov\u00e1bb<\/a><\/p>\n","protected":false},"author":3,"featured_media":97779,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_uag_custom_page_level_css":"","footnotes":""},"categories":[2526,312],"tags":[],"class_list":["post-96098","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aps-es-utemezes","category-forrasok","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.3 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz<\/title>\n<meta name=\"description\" content=\"T\u00f6lts\u00f6n le gy\u00e1rt\u00e1si \u00fctemterv sablont Excelhez. Tudja meg, mikor f\u00e9r bele a munka a kapacit\u00e1sba, \u00e9s hogyan kezeli a SkyPlanner a tervet gy\u00e1rt\u00e1si v\u00e1ltoz\u00e1skor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz\" \/>\n<meta property=\"og:description\" content=\"T\u00f6lts\u00f6n le gy\u00e1rt\u00e1si \u00fctemterv sablont Excelhez. Tudja meg, mikor f\u00e9r bele a munka a kapacit\u00e1sba, \u00e9s hogyan kezeli a SkyPlanner a tervet gy\u00e1rt\u00e1si v\u00e1ltoz\u00e1skor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/\" \/>\n<meta property=\"og:site_name\" content=\"SkyPlanner\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-04T04:30:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-19T14:42:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1672\" \/>\n\t<meta property=\"og:image:height\" content=\"941\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jussi M\u00e4ntyl\u00e4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jussi M\u00e4ntyl\u00e4\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/\"},\"author\":{\"name\":\"Jussi M\u00e4ntyl\u00e4\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#\\\/schema\\\/person\\\/d90eac23cfbf5af3a2c4a38ff10376b5\"},\"headline\":\"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz\",\"datePublished\":\"2026-10-04T04:30:32+00:00\",\"dateModified\":\"2026-10-19T14:42:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/\"},\"wordCount\":2770,\"publisher\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/production-schedule-template-hero-2.png\",\"articleSection\":[\"APS \u00e9s \u00fctemez\u00e9s\",\"forr\u00e1sok\"],\"inLanguage\":\"hu-HU\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/\",\"name\":\"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/production-schedule-template-hero-2.png\",\"datePublished\":\"2026-10-04T04:30:32+00:00\",\"dateModified\":\"2026-10-19T14:42:42+00:00\",\"description\":\"T\u00f6lts\u00f6n le gy\u00e1rt\u00e1si \u00fctemterv sablont Excelhez. Tudja meg, mikor f\u00e9r bele a munka a kapacit\u00e1sba, \u00e9s hogyan kezeli a SkyPlanner a tervet gy\u00e1rt\u00e1si v\u00e1ltoz\u00e1skor.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#breadcrumb\"},\"inLanguage\":\"hu-HU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu-HU\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#primaryimage\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/production-schedule-template-hero-2.png\",\"contentUrl\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/production-schedule-template-hero-2.png\",\"width\":1672,\"height\":941,\"caption\":\"Two groups of components waiting for one machining resource in a manufacturing production schedule\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/forrasok\\\/gyartastervezes-excel-sablon\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#website\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/\",\"name\":\"SkyPlanner\",\"description\":\"AI-powered production scheduling and planning software\",\"publisher\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu-HU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#organization\",\"name\":\"Skycode Oy\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu-HU\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Skyplanner-logo-2.svg\",\"contentUrl\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Skyplanner-logo-2.svg\",\"width\":223,\"height\":43,\"caption\":\"SkyPlanner APS\"},\"image\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"legalName\":\"Skycode Oy\",\"alternateName\":[\"Skycode\",\"SkyPlanner\",\"SkyPlanner APS\"],\"description\":\"Skycode Oy is the Finnish software company that develops and publishes SkyPlanner APS, AI production scheduling and advanced planning and scheduling (APS) software for manufacturers worldwide. Founded in 1997 as a sole proprietorship and incorporated as Skycode Oy in 2008.\",\"foundingDate\":\"1997\",\"taxID\":\"2204947-0\",\"vatID\":\"FI22049470\",\"telephone\":\"+358407000002\",\"email\":\"support@skyplanner.ai\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rantakatu 2 G 11\",\"postalCode\":\"65100\",\"addressLocality\":\"Vaasa\",\"addressCountry\":\"FI\"},\"brand\":{\"@type\":\"Brand\",\"name\":\"SkyPlanner\"},\"knowsAbout\":[\"Production Scheduling\",\"Advanced Planning and Scheduling\",\"Manufacturing AI\",\"Finite Capacity Scheduling\",\"ERP Integration\",\"MES Integration\"],\"areaServed\":\"Worldwide\",\"contactPoint\":[{\"@type\":\"ContactPoint\",\"contactType\":\"sales\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/contact-sales\\\/\",\"areaServed\":\"Worldwide\"},{\"@type\":\"ContactPoint\",\"contactType\":\"customer support\",\"email\":\"support@skyplanner.ai\",\"telephone\":\"+358407000002\",\"areaServed\":\"Worldwide\"}],\"sameAs\":[\"https:\\\/\\\/www.wikidata.org\\\/wiki\\\/Q141672132\",\"https:\\\/\\\/skycode.fi\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/skycodeoy\\\/\",\"https:\\\/\\\/www.finder.fi\\\/IT-konsultointi+IT-palvelut\\\/Skycode+Oy\\\/Vaasa\\\/yhteystiedot\\\/1934882\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/hu\\\/#\\\/schema\\\/person\\\/d90eac23cfbf5af3a2c4a38ff10376b5\",\"name\":\"Jussi M\u00e4ntyl\u00e4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu-HU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5cfcd5c06352082aff699784151984268501dafe5084791a9f280d4e3ec500f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5cfcd5c06352082aff699784151984268501dafe5084791a9f280d4e3ec500f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5cfcd5c06352082aff699784151984268501dafe5084791a9f280d4e3ec500f?s=96&d=mm&r=g\",\"caption\":\"Jussi M\u00e4ntyl\u00e4\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz","description":"T\u00f6lts\u00f6n le gy\u00e1rt\u00e1si \u00fctemterv sablont Excelhez. Tudja meg, mikor f\u00e9r bele a munka a kapacit\u00e1sba, \u00e9s hogyan kezeli a SkyPlanner a tervet gy\u00e1rt\u00e1si v\u00e1ltoz\u00e1skor.","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:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/","og_locale":"hu_HU","og_type":"article","og_title":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz","og_description":"T\u00f6lts\u00f6n le gy\u00e1rt\u00e1si \u00fctemterv sablont Excelhez. Tudja meg, mikor f\u00e9r bele a munka a kapacit\u00e1sba, \u00e9s hogyan kezeli a SkyPlanner a tervet gy\u00e1rt\u00e1si v\u00e1ltoz\u00e1skor.","og_url":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/","og_site_name":"SkyPlanner","article_published_time":"2026-10-04T04:30:32+00:00","article_modified_time":"2026-10-19T14:42:42+00:00","og_image":[{"width":1672,"height":941,"url":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png","type":"image\/png"}],"author":"Jussi M\u00e4ntyl\u00e4","twitter_card":"summary_large_image","twitter_misc":{"Szerz\u0151:":"Jussi M\u00e4ntyl\u00e4","Becs\u00fclt olvas\u00e1si id\u0151":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#article","isPartOf":{"@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/"},"author":{"name":"Jussi M\u00e4ntyl\u00e4","@id":"https:\/\/skyplanner.ai\/hu\/#\/schema\/person\/d90eac23cfbf5af3a2c4a38ff10376b5"},"headline":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz","datePublished":"2026-10-04T04:30:32+00:00","dateModified":"2026-10-19T14:42:42+00:00","mainEntityOfPage":{"@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/"},"wordCount":2770,"publisher":{"@id":"https:\/\/skyplanner.ai\/hu\/#organization"},"image":{"@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#primaryimage"},"thumbnailUrl":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png","articleSection":["APS \u00e9s \u00fctemez\u00e9s","forr\u00e1sok"],"inLanguage":"hu-HU"},{"@type":"WebPage","@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/","url":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/","name":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz","isPartOf":{"@id":"https:\/\/skyplanner.ai\/hu\/#website"},"primaryImageOfPage":{"@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#primaryimage"},"image":{"@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#primaryimage"},"thumbnailUrl":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png","datePublished":"2026-10-04T04:30:32+00:00","dateModified":"2026-10-19T14:42:42+00:00","description":"T\u00f6lts\u00f6n le gy\u00e1rt\u00e1si \u00fctemterv sablont Excelhez. Tudja meg, mikor f\u00e9r bele a munka a kapacit\u00e1sba, \u00e9s hogyan kezeli a SkyPlanner a tervet gy\u00e1rt\u00e1si v\u00e1ltoz\u00e1skor.","breadcrumb":{"@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#breadcrumb"},"inLanguage":"hu-HU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/"]}]},{"@type":"ImageObject","inLanguage":"hu-HU","@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#primaryimage","url":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png","contentUrl":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png","width":1672,"height":941,"caption":"Two groups of components waiting for one machining resource in a manufacturing production schedule"},{"@type":"BreadcrumbList","@id":"https:\/\/skyplanner.ai\/hu\/forrasok\/gyartastervezes-excel-sablon\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/skyplanner.ai\/hu\/"},{"@type":"ListItem","position":2,"name":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz"}]},{"@type":"WebSite","@id":"https:\/\/skyplanner.ai\/hu\/#website","url":"https:\/\/skyplanner.ai\/hu\/","name":"SkyPlanner","description":"AI-powered production scheduling and planning software","publisher":{"@id":"https:\/\/skyplanner.ai\/hu\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/skyplanner.ai\/hu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu-HU"},{"@type":"Organization","@id":"https:\/\/skyplanner.ai\/hu\/#organization","name":"Skycode Oy","url":"https:\/\/skyplanner.ai\/hu\/","logo":{"@type":"ImageObject","inLanguage":"hu-HU","@id":"https:\/\/skyplanner.ai\/hu\/#\/schema\/logo\/image\/","url":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2022\/05\/Skyplanner-logo-2.svg","contentUrl":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2022\/05\/Skyplanner-logo-2.svg","width":223,"height":43,"caption":"SkyPlanner APS"},"image":{"@id":"https:\/\/skyplanner.ai\/hu\/#\/schema\/logo\/image\/"},"legalName":"Skycode Oy","alternateName":["Skycode","SkyPlanner","SkyPlanner APS"],"description":"Skycode Oy is the Finnish software company that develops and publishes SkyPlanner APS, AI production scheduling and advanced planning and scheduling (APS) software for manufacturers worldwide. Founded in 1997 as a sole proprietorship and incorporated as Skycode Oy in 2008.","foundingDate":"1997","taxID":"2204947-0","vatID":"FI22049470","telephone":"+358407000002","email":"support@skyplanner.ai","address":{"@type":"PostalAddress","streetAddress":"Rantakatu 2 G 11","postalCode":"65100","addressLocality":"Vaasa","addressCountry":"FI"},"brand":{"@type":"Brand","name":"SkyPlanner"},"knowsAbout":["Production Scheduling","Advanced Planning and Scheduling","Manufacturing AI","Finite Capacity Scheduling","ERP Integration","MES Integration"],"areaServed":"Worldwide","contactPoint":[{"@type":"ContactPoint","contactType":"sales","url":"https:\/\/skyplanner.ai\/contact-sales\/","areaServed":"Worldwide"},{"@type":"ContactPoint","contactType":"customer support","email":"support@skyplanner.ai","telephone":"+358407000002","areaServed":"Worldwide"}],"sameAs":["https:\/\/www.wikidata.org\/wiki\/Q141672132","https:\/\/skycode.fi\/","https:\/\/www.linkedin.com\/company\/skycodeoy\/","https:\/\/www.finder.fi\/IT-konsultointi+IT-palvelut\/Skycode+Oy\/Vaasa\/yhteystiedot\/1934882"]},{"@type":"Person","@id":"https:\/\/skyplanner.ai\/hu\/#\/schema\/person\/d90eac23cfbf5af3a2c4a38ff10376b5","name":"Jussi M\u00e4ntyl\u00e4","image":{"@type":"ImageObject","inLanguage":"hu-HU","@id":"https:\/\/secure.gravatar.com\/avatar\/d5cfcd5c06352082aff699784151984268501dafe5084791a9f280d4e3ec500f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d5cfcd5c06352082aff699784151984268501dafe5084791a9f280d4e3ec500f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cfcd5c06352082aff699784151984268501dafe5084791a9f280d4e3ec500f?s=96&d=mm&r=g","caption":"Jussi M\u00e4ntyl\u00e4"}}]}},"uagb_featured_image_src":{"full":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png",1672,941,false],"thumbnail":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2-150x150.png",150,150,true],"medium":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2-300x169.png",300,169,true],"medium_large":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2-768x432.png",768,432,true],"large":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2-1024x576.png",1024,576,true],"1536x1536":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2-1536x864.png",1536,864,true],"2048x2048":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png",1672,941,false],"betterdocs-category-thumb":["https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2-360x203.png",360,203,true]},"uagb_author_info":{"display_name":"Jussi M\u00e4ntyl\u00e4","author_link":"https:\/\/skyplanner.ai\/hu\/author\/jussi\/"},"uagb_comment_info":0,"uagb_excerpt":"Gy\u00e1rt\u00e1si \u00fctemterv sablon: igaz\u00edtsa a munk\u00e1t a kapacit\u00e1shoz Egy gy\u00e1rt\u00e1si \u00fctemterv sablonban minden rendel\u00e9snek jut hely. A nehezebb k\u00e9rd\u00e9s az, hogy az \u00fczemben is jut-e: egy szabad g\u00e9pen, a megfelel\u0151 g\u00e9pkezel\u0151vel, m\u00e9g id\u0151ben ahhoz, hogy a k\u00f6vetkez\u0151 m\u0171velet \u00e9s a vev\u0151nek t\u00f6rt\u00e9n\u0151 kisz\u00e1ll\u00edt\u00e1s is hat\u00e1rid\u0151re megt\u00f6rt\u00e9njen. T\u00f6ltse le a gy\u00e1rt\u00e1si \u00fctemterv sablont (CSV Excelhez). Ez&hellip;","_links":{"self":[{"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/posts\/96098","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/comments?post=96098"}],"version-history":[{"count":1,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/posts\/96098\/revisions"}],"predecessor-version":[{"id":96127,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/posts\/96098\/revisions\/96127"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/media\/97779"}],"wp:attachment":[{"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/media?parent=96098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/categories?post=96098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyplanner.ai\/hu\/wp-json\/wp\/v2\/tags?post=96098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}