{"id":96089,"date":"2026-10-04T04:30:32","date_gmt":"2026-10-04T04:30:32","guid":{"rendered":"https:\/\/skyplanner.ai\/?p=96089"},"modified":"2026-10-19T14:42:42","modified_gmt":"2026-10-19T14:42:42","slug":"planovani-vyroby-excel-sablona","status":"publish","type":"post","link":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/","title":{"rendered":"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity"},"content":{"rendered":"<div class=\"gb-container gb-container-article01 article-main-content-container\">\n\n<h1 class=\"wp-block-heading\">\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity<\/h1>\n\n\n<p>V \u0161ablon\u011b rozvrhu v\u00fdroby m\u00e1 ka\u017ed\u00e1 zak\u00e1zka sv\u00e9 m\u00edsto na pap\u00ed\u0159e. T\u011b\u017e\u0161\u00ed ot\u00e1zka je, zda se pro ni najde m\u00edsto i ve v\u00fdrob\u011b: na dostupn\u00e9m stroji, se spr\u00e1vnou obsluhou a v\u010das, aby mohla nav\u00e1zat dal\u0161\u00ed operace a bylo mo\u017en\u00e9 dodr\u017eet term\u00edn dod\u00e1n\u00ed z\u00e1kazn\u00edkovi.<\/p>\n\n\n<p><a href=\"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template.csv\">St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby (CSV pro Excel)<\/a>. Jde o jednoduch\u00fd p\u0159\u00edklad z v\u00fdroby, kter\u00fd si m\u016f\u017eete upravit; ka\u017ed\u00e1 operace m\u00e1 vlastn\u00ed \u0159\u00e1dek. Tabulka n\u00ed\u017ee ukazuje dv\u011b vzorov\u00e9 operace. Soubor obsahuje krom\u011b \u010das\u016f tak\u00e9 \u00fapln\u00e1 data.<\/p>\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Zak\u00e1zka \/ operace<\/th>\n<th>Stroj \/ obsluha<\/th>\n<th style=\"text-align: right;\">Se\u0159\u00edzen\u00ed (min)<\/th>\n<th style=\"text-align: right;\">Zpracov\u00e1n\u00ed (min)<\/th>\n<th>Za\u010d\u00e1tek<\/th>\n<th>Konec<\/th>\n<th>Po\u017eadovan\u00fd konec<\/th>\n<th>Stav<\/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>Napl\u00e1nov\u00e1no<\/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>Napl\u00e1nov\u00e1no<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n<p>\u0160ablona v\u00e1m pom\u016f\u017ee pochopit vstupn\u00ed \u00fadaje a vyzkou\u0161et jednoduch\u00e9 po\u0159ad\u00ed operac\u00ed. Pokud m\u00e1 v\u00fdrobn\u00ed pl\u00e1n z\u016fstat pou\u017eiteln\u00fd i p\u0159i nov\u00fdch zak\u00e1zk\u00e1ch, zpo\u017ed\u011bn\u00edch a zm\u011bn\u00e1ch kapacity, nechte rozvrh vypo\u010d\u00edtat v SkyPlanner APS. Tabulka zobraz\u00ed za\u010d\u00e1tky, kter\u00e9 jste zvolili; SkyPlanner za v\u00e1s rozm\u00edst\u00ed operace do dostupn\u00e9 kapacity.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Co by v\u00e1m m\u011bla \u0161ablona rozvrhu v\u00fdroby \u0159\u00edct?<\/h2>\n\n\n<p>Rozvrh v\u00fdroby ur\u010duje, kdy se bude pr\u00e1ce prov\u00e1d\u011bt a na jak\u00fdch v\u00fdrobn\u00edch zdroj\u00edch. U ka\u017ed\u00e9 operace by m\u011bl odpov\u011bd\u011bt na \u010dty\u0159i ot\u00e1zky:<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Co se bude prov\u00e1d\u011bt?<\/strong> Uve\u010fte zak\u00e1zku a konkr\u00e9tn\u00ed operaci, ne jen n\u00e1zev v\u00fdrobku.<\/li>\n<li><strong>Kde lze operaci prov\u00e9st?<\/strong> Uve\u010fte stroj nebo pracovi\u0161t\u011b a pracovn\u00edky pot\u0159ebn\u00e9 k proveden\u00ed pr\u00e1ce.<\/li>\n<li><strong>Kdy lze operaci prov\u00e9st?<\/strong> Zohledn\u011bte se\u0159\u00edzen\u00ed, dobu zpracov\u00e1n\u00ed, pracovn\u00ed dobu a v\u0161e, co mus\u00ed b\u00fdt p\u0159ipraveno p\u0159ed zah\u00e1jen\u00edm.<\/li>\n<li><strong>Skon\u010d\u00ed v\u010das?<\/strong> Porovnejte v\u00fdsledek s po\u017eadovan\u00fdm koncem operace a zohledn\u011bte pr\u00e1ci, kter\u00e1 je\u0161t\u011b zb\u00fdv\u00e1 do expedice.<\/li>\n<\/ul>\n\n\n<p>Pr\u00e1v\u011b toto rozli\u0161en\u00ed je d\u016fle\u017eit\u00e9. Dokon\u010den\u00e1 obr\u00e1b\u011bc\u00ed operace neznamen\u00e1, \u017ee je zak\u00e1zka p\u0159ipravena k expedici, pokud po n\u00ed je\u0161t\u011b n\u00e1sleduje mont\u00e1\u017e, kontrola nebo balen\u00ed. Ka\u017ed\u00e9 operaci ur\u010dete po\u017eadovan\u00fd konec tak, aby zbyl \u010das na navazuj\u00edc\u00ed pr\u00e1ci.<\/p>\n\n\n<p>T\u00fddenn\u00ed pl\u00e1n uv\u00e1d\u011bj\u00edc\u00ed mno\u017estv\u00ed v\u00fdrobk\u016f je u\u017eite\u010dn\u00fd, ale odpov\u00edd\u00e1 na jinou ot\u00e1zku. <a href=\"\/cs\/zdroje\/master-production-schedule\/\">Hlavn\u00ed v\u00fdrobn\u00ed pl\u00e1n<\/a> stanovuje, jak\u00e9 hotov\u00e9 v\u00fdrobky jsou pot\u0159eba a kdy. Tato \u0161ablona jde o \u00farove\u0148 n\u00ed\u017e: ke konkr\u00e9tn\u00edm operac\u00edm, kter\u00e9 soupe\u0159\u00ed o \u010das stroj\u016f a obsluhy. <a href=\"\/cs\/zdroje\/co-je-planovani-vyroby\/\">Pr\u016fvodce rozvrhov\u00e1n\u00edm v\u00fdroby<\/a> vysv\u011btluje, jak z t\u011bchto vstup\u016f sestavit provediteln\u00e9 po\u0159ad\u00ed operac\u00ed.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Vn\u00edmejte vzor jako rezervaci kapacity<\/h2>\n\n\n<p>P\u0159edstavte si provoz, kde dv\u011b operace \u010dekaj\u00ed na stejn\u00fd stroj M1 a stejnou obsluhu O1. Materi\u00e1l pro ob\u011b je p\u0159ipraven\u00fd. Stroj i obsluha jsou nep\u0159etr\u017eit\u011b k dispozici od 08:00 do 16:00 a ani jedna operace ne\u010dek\u00e1 na dokon\u010den\u00ed p\u0159edchoz\u00ed operace.<\/p>\n\n\n<p>Pro operaci A je vyhrazeno 30 minut na se\u0159\u00edzen\u00ed a 120 minut na zpracov\u00e1n\u00ed. V\u00fdrobn\u00ed zdroj je tedy obsazen\u00fd do 10:30. Pot\u00e9 operace B pot\u0159ebuje 15 minut na se\u0159\u00edzen\u00ed a 180 minut na zpracov\u00e1n\u00ed, tak\u017ee skon\u010d\u00ed ve 13:45. Operace se nep\u0159ekr\u00fdvaj\u00ed a ob\u011b skon\u010d\u00ed p\u0159ed uveden\u00fdm po\u017eadovan\u00fdm term\u00ednem.<\/p>\n\n\n<p>Toto po\u0159ad\u00ed je provediteln\u00e9, proto\u017ee plat\u00ed v\u00fdchoz\u00ed p\u0159edpoklady. Pokud je O1 v 11:00 pot\u0159eba na jin\u00e9m stroji, p\u0159i\u0159azen\u00ed v \u0159\u00e1dku B u\u017e provediteln\u00e9 nen\u00ed, i kdy\u017e M1 z\u016fst\u00e1v\u00e1 voln\u00fd. P\u0159est\u00e1vka na ob\u011bd zase p\u0159eru\u0161\u00ed souvislou pracovn\u00ed dobu. A pokud jde o mezilehl\u00e9 operace, navazuj\u00edc\u00ed kroky st\u00e1le pot\u0159ebuj\u00ed vlastn\u00ed kapacitu.<\/p>\n\n\n<p>P\u0159\u00ednos tabulky nespo\u010d\u00edv\u00e1 v jej\u00edm barevn\u00e9m proveden\u00ed. D\u016fle\u017eit\u00e9 je, jakou \u010d\u00e1st dostupn\u00e9ho \u010dasu v\u00fdrobn\u00edho zdroje ka\u017ed\u00fd \u0159\u00e1dek rezervuje.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Upravte \u0161ablonu tak, aby omezen\u00ed z\u016fstala viditeln\u00e1<\/h2>\n\n\n<p>Otev\u0159ete CSV v Excelu a pracovn\u00ed kopii ulo\u017ete jako se\u0161it Excelu. Pokud se v\u0161e zobraz\u00ed v jedin\u00e9m sloupci, importujte soubor s \u010d\u00e1rkou jako odd\u011blova\u010dem. Sta\u017een\u00fd soubor CSV obsahuje vzorov\u00e9 hodnoty, nikoli model pro automatick\u00e9 rozvrhov\u00e1n\u00ed.<\/p>\n\n\n<p>Ve vzoru je pou\u017eito datum <strong>5. \u0159\u00edjna 2026<\/strong>. Nahra\u010fte je skute\u010dn\u00fdmi pracovn\u00edmi daty a ov\u011b\u0159te, \u017ee sloupce Za\u010d\u00e1tek, Konec a Po\u017eadovan\u00fd konec obsahuj\u00ed skute\u010dn\u00e9 hodnoty data a \u010dasu, nikoli text p\u0159evzat\u00fd p\u0159i importu. Zobrazujte datum i \u010das; jinak m\u016f\u017ee z\u00edt\u0159ej\u0161\u00edch 08:00 vypadat stejn\u011b jako dne\u0161n\u00edch.<\/p>\n\n\n<h3 class=\"wp-block-heading\">Ka\u017ed\u00e9 operaci p\u0159id\u011blte vlastn\u00ed ozna\u010den\u00ed a spr\u00e1vn\u011b ur\u010dete jej\u00ed trv\u00e1n\u00ed<\/h3>\n\n\n<p>Nahra\u010fte A a B identifik\u00e1tory sv\u00fdch zak\u00e1zek a operac\u00ed. Pokud zak\u00e1zka vy\u017eaduje \u0159ez\u00e1n\u00ed, oh\u00fdb\u00e1n\u00ed a sva\u0159ov\u00e1n\u00ed, pou\u017eijte pro ka\u017edou operaci samostatn\u00fd \u0159\u00e1dek. Jejich po\u0159ad\u00ed ur\u010duje <a href=\"\/cs\/zdroje\/vyrobni-postup\/\">technologick\u00fd postup<\/a>, nikoli to, kter\u00fd \u0159\u00e1dek je v tabulce zrovna dal\u0161\u00ed.<\/p>\n\n\n<p>Sloupec Zpracov\u00e1n\u00ed (min) znamen\u00e1 <strong>celkovou dobu zpracov\u00e1n\u00ed d\u00e1vky<\/strong>. Pokud odhadujete \u010das na jeden kus, p\u0159ed zad\u00e1n\u00edm jej vyn\u00e1sobte po\u010dtem kus\u016f. Se\u0159\u00edzen\u00ed (min) je dal\u0161\u00ed \u010das, po kter\u00fd je stroj obsazen\u00fd; neskr\u00fdvejte jej v sou\u010dtu bez vysv\u011btlen\u00ed ani jej nezapo\u010d\u00edt\u00e1vejte dvakr\u00e1t.<\/p>\n\n\n<p>U operace, kter\u00e1 prob\u00edh\u00e1 bez p\u0159eru\u0161en\u00ed, nahra\u010fte pevn\u011b zadan\u00fd Konec v bu\u0148ce F2 t\u00edmto vzorcem a zkop\u00edrujte jej do dal\u0161\u00edch \u0159\u00e1dk\u016f:<\/p>\n\n\n<p><code>=E2+(C2+D2)\/1440<\/code><\/p>\n\n\n<p>Vzorec p\u0159i\u010dte k \u010dasu za\u010d\u00e1tku minuty na se\u0159\u00edzen\u00ed a zpracov\u00e1n\u00ed. Neur\u010d\u00ed v\u0161ak za\u010d\u00e1tek, nezabr\u00e1n\u00ed kolizi s jinou operac\u00ed ani nep\u0159esune pr\u00e1ci tak, aby neprob\u00edhala mimo pracovn\u00ed dobu sm\u011bny. Tato rozhodnut\u00ed o rozvrhu jsou v tabulce st\u00e1le na v\u00e1s.<\/p>\n\n\n<h3 class=\"wp-block-heading\">Zaznamenejte, co mus\u00ed b\u00fdt p\u0159ed zah\u00e1jen\u00edm pr\u00e1ce k dispozici<\/h3>\n\n\n<p>Vedle seznamu operac\u00ed ve\u010fte pro ka\u017ed\u00fd stroj a obsluhu pracovn\u00ed dobu v konkr\u00e9tn\u00edch dnech. Zaznamenejte p\u0159est\u00e1vky, \u00fadr\u017ebu a dal\u0161\u00ed obdob\u00ed nedostupnosti. Pokud pot\u0159ebujete p\u0159i\u0159azen\u00ed stroj\u016f a obsluhy kontrolovat nez\u00e1visle, rozd\u011blte Stroj a Obsluha do samostatn\u00fdch sloupc\u016f.<\/p>\n\n\n<p>U zak\u00e1zek s v\u00edce kroky p\u0159idejte sloupec P\u0159edchoz\u00ed operace s jej\u00edm identifik\u00e1torem. Pokud za\u010d\u00e1tek z\u00e1vis\u00ed na dod\u00e1vce materi\u00e1lu, dopl\u0148te \u00fadaj o tom, kdy bude materi\u00e1l p\u0159ipraven. Operaci lze za\u0159adit do rozvrhu teprve tehdy, kdy\u017e jsou p\u0159ipraveny pot\u0159ebn\u00e9 vstupy a dokon\u010dena p\u0159edchoz\u00ed pr\u00e1ce.<\/p>\n\n\n<p>Pokud operaci nelze p\u0159eru\u0161it, pot\u0159ebuje souvisl\u00fd pracovn\u00ed interval dostate\u010dn\u011b dlouh\u00fd pro se\u0159\u00edzen\u00ed i zpracov\u00e1n\u00ed. Pokud ji p\u0159eru\u0161it lze, jednoduch\u00fd vzorec pro \u010das dokon\u010den\u00ed nezohledn\u00ed rozlo\u017een\u00ed pr\u00e1ce do n\u011bkolika pracovn\u00edch interval\u016f. K tomu je pot\u0159eba samostatn\u00fd v\u00fdpo\u010det, kter\u00fd zohled\u0148uje pracovn\u00ed kalend\u00e1\u0159.<\/p>\n\n\n<p>Pr\u00e1v\u011b tady \u0161ablona odhaluje skute\u010dnou podstatu pl\u00e1nov\u00e1n\u00ed: nejde o p\u0159id\u00e1v\u00e1n\u00ed dal\u0161\u00edch \u0159\u00e1dk\u016f, ale o kontrolu toho, jak se navz\u00e1jem ovliv\u0148uj\u00ed.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Prov\u011b\u0159te pl\u00e1n zm\u011bnou jednoho p\u0159edpokladu<\/h2>\n\n\n<p>Ne\u017e se na rozvrh v tabulce spolehnete, ov\u011b\u0159te, co se stane p\u0159i zm\u011bn\u011b ve v\u00fdrob\u011b.<\/p>\n\n\n<p>P\u0159edpokl\u00e1dejme, \u017ee A skon\u010dila v 10:30, ale M1 nen\u00ed od 10:30 do 13:00 k dispozici. B je\u0161t\u011b neza\u010dala. Jej\u00edch 195 minut se\u0159\u00edzen\u00ed a zpracov\u00e1n\u00ed by p\u0159i nep\u0159etr\u017eit\u00e9 pr\u00e1ci nyn\u00ed znamenalo dokon\u010den\u00ed v 16:15.<\/p>\n\n\n<p>Takov\u00fd konec p\u0159esahuje jak pracovn\u00ed dobu kon\u010d\u00edc\u00ed v 16:00, tak po\u017eadovan\u00fd konec B v 16:00. Jde o varov\u00e1n\u00ed, nikoli o schv\u00e1len\u00fd n\u00e1hradn\u00ed rozvrh. Posunut\u00edm za\u010d\u00e1tku B v bu\u0148ce jste probl\u00e9m odhalili, ne vy\u0159e\u0161ili.<\/p>\n\n\n<p>M\u016f\u017eete prov\u011b\u0159it jin\u00fd vhodn\u00fd stroj s dostupnou obsluhou, schv\u00e1len\u00e9 prodlou\u017een\u00ed pracovn\u00ed doby nebo zm\u011bnu sl\u00edben\u00e9ho term\u00ednu dod\u00e1n\u00ed. P\u0159esunut\u00ed B jinam ale vy\u017eaduje tak\u00e9 kontrolu pr\u00e1ce, kter\u00e1 u\u017e je tam napl\u00e1novan\u00e1. Pokud po B n\u00e1sleduje dal\u0161\u00ed operace, m\u016f\u017ee b\u00fdt nutn\u00e9 posunout i jej\u00ed za\u010d\u00e1tek.<\/p>\n\n\n<p>V tom spo\u010d\u00edv\u00e1 rozd\u00edl mezi aritmetick\u00fdm v\u00fdpo\u010dtem a <a href=\"\/cs\/zdroje\/planovani-s-omezenou-kapacitou\/\">pl\u00e1nov\u00e1n\u00edm do omezen\u00fdch kapacit<\/a>. V\u00fdpo\u010det ur\u010d\u00ed, kdy by zvolen\u00e9 p\u0159i\u0159azen\u00ed skon\u010dilo. Rozvrhov\u00e1n\u00ed najde pro pr\u00e1ci m\u00edsto, ani\u017e by p\u0159ekro\u010dilo dostupnou kapacitu.<\/p>\n\n\n<p>Ne\u017e pl\u00e1n z tabulky p\u0159ed\u00e1te do v\u00fdroby, zkontrolujte p\u0159ekryvy na stroj\u00edch i u obsluhy, materi\u00e1l, p\u0159edchoz\u00ed operace, pracovn\u00ed dobu a po\u017eadovan\u00e9 konce. U dokon\u010den\u00e9 pr\u00e1ce ponechte skute\u010dn\u00e9 \u010dasy a schv\u00e1lenou verzi jasn\u011b ozna\u010dte, aby se v\u00fdrobn\u00ed provoz ne\u0159\u00eddil zastaralou kopi\u00ed.<\/p>\n\n\n<p>V tomto p\u0159\u00edkladu se takov\u00e9 kontroly daj\u00ed zvl\u00e1dnout. V provozu, kde se situace m\u011bn\u00ed, je ale pot\u0159eba opakovat je u v\u0161ech dot\u010den\u00fdch zak\u00e1zek \u2014 a pr\u00e1v\u011b tuto pr\u00e1ci by v\u00e1m m\u011bl software pro rozvrhov\u00e1n\u00ed u\u0161et\u0159it. Pro\u010d n\u00e1ro\u010dnost pr\u016fb\u011b\u017en\u00fdch aktualizac\u00ed roste, rozeb\u00edr\u00e1 podrobn\u011bj\u0161\u00ed <a href=\"\/cs\/zdroje\/vyzvy-planovani-vyroby-excel-skyplanner-aps\/\">pr\u016fvodce probl\u00e9my pl\u00e1nov\u00e1n\u00ed v\u00fdroby v Excelu<\/a>.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Vy \u0159i\u010fte pl\u00e1n, SkyPlanner a\u0165 po\u010d\u00edt\u00e1 rozvrh<\/h2>\n\n\n<p>SkyPlanner p\u0159i rozvrhov\u00e1n\u00ed zohled\u0148uje va\u0161e pracovi\u0161t\u011b, sm\u011bny, obsluhu, priority a materi\u00e1l. Vy definujete v\u00fdrobn\u00ed zdroje a \u00fadaje o operac\u00edch; Arcturus, um\u011bl\u00e1 inteligence pro rozvrhov\u00e1n\u00ed, vypo\u010d\u00edt\u00e1 po\u0159ad\u00ed podle nastaven\u00e9 kapacity a n\u00e1vaznost\u00ed. V\u00fdsledek se zobraz\u00ed v \u010dasov\u00e9 ose Gantt, s frontou operac\u00ed pro ka\u017ed\u00e9 pracovi\u0161t\u011b a vazbami mezi souvisej\u00edc\u00edmi kroky procesu.<\/p>\n\n\n<p>P\u0159i v\u00fdpadku M1 zaznamen\u00e1te obdob\u00ed nedostupnosti a p\u0159epo\u010d\u00edt\u00e1te rozvrh. Arcturus napl\u00e1nuje pr\u00e1ci mimo blokovanou kapacitu podle mo\u017enost\u00ed v\u00fdrobn\u00edch zdroj\u016f a omezen\u00ed, kter\u00e1 jste definovali. V\u00fdsledek pak m\u016f\u017eete zkontrolovat a zjistit, kde je pot\u0159eba v\u011bnovat pozornost dokon\u010den\u00ed zak\u00e1zky, m\u00edsto abyste sami dohled\u00e1vali ka\u017edou navazuj\u00edc\u00ed zm\u011bnu v \u0159\u00e1dc\u00edch tabulky.<\/p>\n\n\n<p>Pokud zapnete rozvrhov\u00e1n\u00ed se zohledn\u011bn\u00edm materi\u00e1lu, m\u016f\u017ee v\u00fdpo\u010det zahrnout i jeho dostupnost. Z\u00e1mky chr\u00e1n\u00ed pr\u00e1ci, kterou nechcete p\u0159esouvat, a p\u0159ednastaven\u00e9 priority ur\u010duj\u00ed, kter\u00e9 z\u00e1vazky jsou nejd\u016fle\u017eit\u011bj\u0161\u00ed. <strong>O priorit\u00e1ch rozhodujete vy; um\u011bl\u00e1 inteligence se jimi \u0159\u00edd\u00ed.<\/strong> Aby podle va\u0161ich rozhodnut\u00ed sestavila rozvrh, nemus\u00edte ka\u017edou operaci um\u00eds\u0165ovat jednotliv\u011b.<\/p>\n\n\n<p>V\u00fdsledkem nen\u00ed jen p\u0159ehledn\u011bj\u0161\u00ed seznam zak\u00e1zek, ale pl\u00e1n, se kter\u00fdm m\u016f\u017eete pracovat i p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b. Svou pozornost v\u011bnujete rozhodov\u00e1n\u00ed: zda p\u0159idat kapacitu, zm\u011bnit prioritu nebo se z\u00e1kazn\u00edkem projednat term\u00edn. SkyPlanner se postar\u00e1 o souvisej\u00edc\u00ed v\u00fdpo\u010det rozvrhu.<\/p>\n\n\n<p><a href=\"\/cs\/funkce\/\">Prohl\u00e9dn\u011bte si funkce SkyPlanner pro rozvrhov\u00e1n\u00ed<\/a> a zjist\u011bte, jak v\u00e1m p\u0159i t\u00e9to pr\u00e1ci pom\u00e1haj\u00ed \u010dasov\u00e1 osa Gantt, dostupnost v\u00fdrobn\u00edch zdroj\u016f a automatick\u00e9 rozvrhov\u00e1n\u00ed.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Co UTU p\u0159inesl p\u0159echod od Excelu<\/h2>\n\n\n<p>Z\u00e1vod UTU v Ulvile vyr\u00e1b\u00ed elektrick\u00e9 rozv\u00e1d\u011b\u010de a sp\u00ednac\u00ed za\u0159\u00edzen\u00ed. P\u0159ed zaveden\u00edm SkyPlanner jednotliv\u00e1 odd\u011blen\u00ed pl\u00e1novala ve vlastn\u00edch, ru\u010dn\u011b aktualizovan\u00fdch tabulk\u00e1ch Excelu. Zm\u011bny po\u0159ad\u00ed v ERP se ne v\u017edy dostaly do v\u00fdrobn\u00edho provozu a bylo obt\u00ed\u017en\u00e9 z\u00edskat p\u0159ehled o skute\u010dn\u00e9 kapacit\u011b.<\/p>\n\n\n<p>Probl\u00e9m nespo\u010d\u00edval jen v chyb\u011bj\u00edc\u00edm sloupci. Bylo pot\u0159eba udr\u017eet soulad mezi \u00fadaji o zak\u00e1zk\u00e1ch, po\u0159ad\u00edm v\u00fdroby a informacemi, podle kter\u00fdch pracuj\u00ed lid\u00e9 v provozu.<\/p>\n\n\n<p>UTU si p\u0159i p\u0159echodu na Oracle NetSuite vybralo SkyPlanner. V r\u00e1mci tohoto nasazen\u00ed je SkyPlanner propojen\u00fd s NetSuite a mzdov\u00fdm syst\u00e9mem a sdru\u017euje v\u00fdrobn\u00ed linky i odd\u011blen\u00ed z\u00e1vodu do jednoho syst\u00e9mu. T\u00fdm vyzdvihuje kombinaci rozvrhov\u00e1n\u00ed pomoc\u00ed um\u011bl\u00e9 inteligence a \u010dasov\u00e9 osy Gantt: po\u0159ad\u00ed operac\u00ed, kapacity i pr\u016fb\u011bh v\u00fdroby jsou vid\u011bt na jednom m\u00edst\u011b.<\/p>\n\n\n<p>UTU uv\u00e1d\u00ed, \u017ee na ru\u010dn\u00ed aktualizaci tabulek u\u0161et\u0159\u00ed p\u0159ibli\u017en\u011b <strong>dv\u011b hodiny t\u00fddn\u011b<\/strong> a aktualizovan\u00e1 fronta pr\u00e1ce se k mont\u00e1\u017en\u00edk\u016fm dostane b\u011bhem n\u011bkolika sekund. Pr\u00e1v\u011b v tom spo\u010d\u00edv\u00e1 praktick\u00fd p\u0159\u00ednos oproti \u0161ablon\u011b: m\u00e9n\u011b \u00fasil\u00ed v\u011bnovan\u00e9ho udr\u017eov\u00e1n\u00ed aktu\u00e1ln\u00edch kopi\u00ed a p\u0159ehledn\u011bj\u0161\u00ed po\u0159ad\u00ed operac\u00ed pro lidi, kte\u0159\u00ed pr\u00e1ci prov\u00e1d\u011bj\u00ed.<\/p>\n\n\n<p><a href=\"\/cs\/pribehy-zakazniku\/utu\/\">P\u0159e\u010dt\u011bte si zku\u0161enosti UTU s p\u0159echodem z Excelu na SkyPlanner<\/a>.<\/p>\n\n\n<h2 class=\"wp-block-heading\">Ponechte si u\u017eite\u010dn\u00e9 vstupy. P\u0159esta\u0148te rozvrh sestavovat st\u00e1le znovu.<\/h2>\n\n\n<p>\u0160ablona v\u00e1m pom\u016f\u017ee ur\u010dit, jak\u00e9 \u00fadaje pot\u0159ebujete pro rozvrhov\u00e1n\u00ed: operace, dobu jejich trv\u00e1n\u00ed, v\u00fdrobn\u00ed zdroje, jejich dostupnost a po\u017eadovan\u00e9 term\u00edny dokon\u010den\u00ed. Abyste tyto vstupy vyu\u017eili, nemus\u00edte jejich vz\u00e1jemn\u00e9 vazby st\u00e1le p\u0159epo\u010d\u00edt\u00e1vat v Excelu.<\/p>\n\n\n<p><strong>SkyPlanner lze prost\u0159ednictv\u00edm jeho otev\u0159en\u00e9ho REST API propojit s jak\u00fdmkoli syst\u00e9mem ERP nebo MES.<\/strong> Lep\u0161\u00ed rozvrhov\u00e1n\u00ed tak m\u016f\u017ee nav\u00e1zat na va\u0161e st\u00e1vaj\u00edc\u00ed syst\u00e9my, p\u0159i\u010dem\u017e priority i rozhodov\u00e1n\u00ed o v\u00fdrob\u011b z\u016fst\u00e1vaj\u00ed ve va\u0161ich rukou.<\/p>\n\n\n<p><a href=\"\/cs\/kontaktni-prodej\/\">Objednejte si uk\u00e1zku SkyPlanner<\/a> a p\u0159ipravte si typick\u00fd technologick\u00fd postup zak\u00e1zky a p\u0159\u00edklad ned\u00e1vn\u00e9 zm\u011bny rozvrhu. Na t\u011bchto p\u0159\u00edkladech m\u016f\u017eete prozkoumat, jak by se dala va\u0161e v\u00fdroba rozvrhnout, kdy\u017e je t\u0159eba sladit dostupnost stroj\u016f a lid\u00ed s term\u00edny dokon\u010den\u00ed. Nebo si <a href=\"\/cs\/zkusebni-verze\/\">vyzkou\u0161ejte SkyPlanner s uk\u00e1zkov\u00fdmi daty<\/a> a prohl\u00e9dn\u011bte si rozvrh na \u010dasov\u00e9 ose Gantt, ne\u017e za\u010dnete pl\u00e1novat vlastn\u00ed nastaven\u00ed.<\/p>\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity V \u0161ablon\u011b rozvrhu v\u00fdroby m\u00e1 ka\u017ed\u00e1 zak\u00e1zka sv\u00e9 m\u00edsto na pap\u00ed\u0159e. T\u011b\u017e\u0161\u00ed ot\u00e1zka je, zda se pro ni najde m\u00edsto i ve v\u00fdrob\u011b: na dostupn\u00e9m stroji, se spr\u00e1vnou obsluhou a v\u010das, aby mohla nav\u00e1zat dal\u0161\u00ed operace a bylo mo\u017en\u00e9 dodr\u017eet term\u00edn dod\u00e1n\u00ed z\u00e1kazn\u00edkovi. St\u00e1hn\u011bte si \u0161ablonu &#8230; <a title=\"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity\" class=\"read-more\" href=\"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/\" aria-label=\"Read more about \u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity\">Read more<\/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":[2518,303],"tags":[],"class_list":["post-96089","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aps-a-rozvrhovani","category-zdroje","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>\u0160ablona pro pl\u00e1nov\u00e1n\u00ed v\u00fdroby v Excelu: Jak vyu\u017e\u00edt kapacitu<\/title>\n<meta name=\"description\" content=\"St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby pro Excel. Zjist\u011bte, kdy se pr\u00e1ce vejde do kapacity a jak SkyPlanner upravuje pl\u00e1n p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b.\" \/>\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\/cs\/zdroje\/planovani-vyroby-excel-sablona\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity\" \/>\n<meta property=\"og:description\" content=\"St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby pro Excel. Zjist\u011bte, kdy se pr\u00e1ce vejde do kapacity a jak SkyPlanner upravuje pl\u00e1n p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/\" \/>\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=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jussi M\u00e4ntyl\u00e4\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/\"},\"author\":{\"name\":\"Jussi M\u00e4ntyl\u00e4\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#\\\/schema\\\/person\\\/d90eac23cfbf5af3a2c4a38ff10376b5\"},\"headline\":\"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity\",\"datePublished\":\"2026-10-04T04:30:32+00:00\",\"dateModified\":\"2026-10-19T14:42:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/\"},\"wordCount\":2352,\"publisher\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/skyplanner.ai\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/production-schedule-template-hero-2.png\",\"articleSection\":[\"APS a rozvrhov\u00e1n\u00ed\",\"zdroje\"],\"inLanguage\":\"cs\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/\",\"name\":\"\u0160ablona pro pl\u00e1nov\u00e1n\u00ed v\u00fdroby v Excelu: Jak vyu\u017e\u00edt kapacitu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#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\":\"St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby pro Excel. Zjist\u011bte, kdy se pr\u00e1ce vejde do kapacity a jak SkyPlanner upravuje pl\u00e1n p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#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\\\/cs\\\/zdroje\\\/planovani-vyroby-excel-sablona\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#website\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/\",\"name\":\"SkyPlanner\",\"description\":\"AI-powered production scheduling and planning software\",\"publisher\":{\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#organization\",\"name\":\"Skycode Oy\",\"url\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/skyplanner.ai\\\/cs\\\/#\\\/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\\\/cs\\\/#\\\/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\\\/cs\\\/#\\\/schema\\\/person\\\/d90eac23cfbf5af3a2c4a38ff10376b5\",\"name\":\"Jussi M\u00e4ntyl\u00e4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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":"\u0160ablona pro pl\u00e1nov\u00e1n\u00ed v\u00fdroby v Excelu: Jak vyu\u017e\u00edt kapacitu","description":"St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby pro Excel. Zjist\u011bte, kdy se pr\u00e1ce vejde do kapacity a jak SkyPlanner upravuje pl\u00e1n p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b.","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\/cs\/zdroje\/planovani-vyroby-excel-sablona\/","og_locale":"cs_CZ","og_type":"article","og_title":"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity","og_description":"St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby pro Excel. Zjist\u011bte, kdy se pr\u00e1ce vejde do kapacity a jak SkyPlanner upravuje pl\u00e1n p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b.","og_url":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/","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":{"Napsal(a)":"Jussi M\u00e4ntyl\u00e4","Odhadovan\u00e1 doba \u010dten\u00ed":"12 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#article","isPartOf":{"@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/"},"author":{"name":"Jussi M\u00e4ntyl\u00e4","@id":"https:\/\/skyplanner.ai\/cs\/#\/schema\/person\/d90eac23cfbf5af3a2c4a38ff10376b5"},"headline":"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity","datePublished":"2026-10-04T04:30:32+00:00","dateModified":"2026-10-19T14:42:42+00:00","mainEntityOfPage":{"@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/"},"wordCount":2352,"publisher":{"@id":"https:\/\/skyplanner.ai\/cs\/#organization"},"image":{"@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#primaryimage"},"thumbnailUrl":"https:\/\/skyplanner.ai\/wp-content\/uploads\/2026\/10\/production-schedule-template-hero-2.png","articleSection":["APS a rozvrhov\u00e1n\u00ed","zdroje"],"inLanguage":"cs"},{"@type":"WebPage","@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/","url":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/","name":"\u0160ablona pro pl\u00e1nov\u00e1n\u00ed v\u00fdroby v Excelu: Jak vyu\u017e\u00edt kapacitu","isPartOf":{"@id":"https:\/\/skyplanner.ai\/cs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#primaryimage"},"image":{"@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#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":"St\u00e1hn\u011bte si \u0161ablonu rozvrhu v\u00fdroby pro Excel. Zjist\u011bte, kdy se pr\u00e1ce vejde do kapacity a jak SkyPlanner upravuje pl\u00e1n p\u0159i zm\u011bn\u00e1ch ve v\u00fdrob\u011b.","breadcrumb":{"@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/skyplanner.ai\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#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\/cs\/zdroje\/planovani-vyroby-excel-sablona\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/skyplanner.ai\/cs\/"},{"@type":"ListItem","position":2,"name":"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity"}]},{"@type":"WebSite","@id":"https:\/\/skyplanner.ai\/cs\/#website","url":"https:\/\/skyplanner.ai\/cs\/","name":"SkyPlanner","description":"AI-powered production scheduling and planning software","publisher":{"@id":"https:\/\/skyplanner.ai\/cs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/skyplanner.ai\/cs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/skyplanner.ai\/cs\/#organization","name":"Skycode Oy","url":"https:\/\/skyplanner.ai\/cs\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/skyplanner.ai\/cs\/#\/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\/cs\/#\/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\/cs\/#\/schema\/person\/d90eac23cfbf5af3a2c4a38ff10376b5","name":"Jussi M\u00e4ntyl\u00e4","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/jussi\/"},"uagb_comment_info":0,"uagb_excerpt":"\u0160ablona rozvrhu v\u00fdroby: Jak pr\u00e1ci vm\u011bstnat do dostupn\u00e9 kapacity V \u0161ablon\u011b rozvrhu v\u00fdroby m\u00e1 ka\u017ed\u00e1 zak\u00e1zka sv\u00e9 m\u00edsto na pap\u00ed\u0159e. T\u011b\u017e\u0161\u00ed ot\u00e1zka je, zda se pro ni najde m\u00edsto i ve v\u00fdrob\u011b: na dostupn\u00e9m stroji, se spr\u00e1vnou obsluhou a v\u010das, aby mohla nav\u00e1zat dal\u0161\u00ed operace a bylo mo\u017en\u00e9 dodr\u017eet term\u00edn dod\u00e1n\u00ed z\u00e1kazn\u00edkovi. St\u00e1hn\u011bte si \u0161ablonu&hellip;","_links":{"self":[{"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/posts\/96089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/comments?post=96089"}],"version-history":[{"count":1,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/posts\/96089\/revisions"}],"predecessor-version":[{"id":96118,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/posts\/96089\/revisions\/96118"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/media\/97779"}],"wp:attachment":[{"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/media?parent=96089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/categories?post=96089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyplanner.ai\/cs\/wp-json\/wp\/v2\/tags?post=96089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}