{"id":136,"date":"2026-08-14T09:10:34","date_gmt":"2026-08-14T07:10:34","guid":{"rendered":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/?page_id=136"},"modified":"2026-08-17T16:57:13","modified_gmt":"2026-08-17T14:57:13","slug":"automatizace","status":"publish","type":"page","link":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/automatizace\/","title":{"rendered":"Automatizace"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">M\u00e9n\u011b ru\u010dn\u00ed pr\u00e1ce. M\u00e9n\u011b chyb. V\u00edce \u010dasu na d\u016fle\u017eitou pr\u00e1ci.<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Opakujete ka\u017ed\u00fd den nebo ka\u017ed\u00fd t\u00fdden stejn\u00e9 \u00fakoly v Excelu, zpracov\u00e1v\u00e1te data ru\u010dn\u011b, vytv\u00e1\u0159\u00edte st\u00e1le stejn\u00e9 reporty nebo p\u0159episujete informace mezi n\u011bkolika soubory?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Takov\u00e9 \u010dinnosti lze \u010dasto automatizovat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pom\u00e1h\u00e1me firm\u00e1m hledat a automatizovat opakovan\u00e9 kancel\u00e1\u0159sk\u00e9 a technick\u00e9 procesy. Zam\u011b\u0159ujeme se p\u0159edev\u0161\u00edm na praktick\u00e1 \u0159e\u0161en\u00ed, kter\u00e1 \u0161et\u0159\u00ed \u010das, sni\u017euj\u00ed chybovost a usnad\u0148uj\u00ed ka\u017edodenn\u00ed pr\u00e1ci.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Co lze automatizovat?<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Automatizace nemus\u00ed znamenat rozs\u00e1hl\u00fd IT projekt. \u010casto jde o jednu konkr\u00e9tn\u00ed \u010dinnost, kter\u00e1 se opakuje ka\u017ed\u00fd den a zbyte\u010dn\u011b zab\u00edr\u00e1 \u010das zam\u011bstnanc\u016fm.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Zpracov\u00e1n\u00ed dat<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Automatizujeme opakovan\u00e9 zpracov\u00e1n\u00ed a \u00fapravy dat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nap\u0159\u00edklad:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>na\u010d\u00edt\u00e1n\u00ed dat z Excelu,<\/li>\n\n\n\n<li>filtrov\u00e1n\u00ed a t\u0159\u00edd\u011bn\u00ed,<\/li>\n\n\n\n<li>spojov\u00e1n\u00ed dat z v\u00edce soubor\u016f,<\/li>\n\n\n\n<li>vyhled\u00e1v\u00e1n\u00ed a kontrola \u00fadaj\u016f,<\/li>\n\n\n\n<li>p\u0159evody dat do po\u017eadovan\u00e9ho form\u00e1tu,<\/li>\n\n\n\n<li>automatick\u00e9 zpracov\u00e1n\u00ed velk\u00e9ho mno\u017estv\u00ed \u0159\u00e1dk\u016f.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Generov\u00e1n\u00ed report\u016f a dokument\u016f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Pokud pravideln\u011b vytv\u00e1\u0159\u00edte stejn\u00e9 reporty nebo dokumenty pouze s jin\u00fdmi \u00fadaji, nen\u00ed nutn\u00e9 v\u0161e p\u0159ipravovat ru\u010dn\u011b.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lze nap\u0159\u00edklad automatizovat:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>pravideln\u00e9 reporty,<\/li>\n\n\n\n<li>tabulkov\u00e9 p\u0159ehledy,<\/li>\n\n\n\n<li>exporty dat,<\/li>\n\n\n\n<li>generov\u00e1n\u00ed dokument\u016f,<\/li>\n\n\n\n<li>p\u0159\u00edpravu podklad\u016f pro jedn\u00e1n\u00ed,<\/li>\n\n\n\n<li>opakovan\u00e9 v\u00fdstupy podle p\u0159edem definovan\u00fdch parametr\u016f.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Automatizace Excelu<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Excel je \u010dasto ned\u00edlnou sou\u010d\u00e1st\u00ed ka\u017edodenn\u00ed pr\u00e1ce. Pokud v\u0161ak vy\u017eaduje velk\u00e9 mno\u017estv\u00ed ru\u010dn\u00edch krok\u016f, m\u016f\u017ee se st\u00e1t zdrojem zbyte\u010dn\u00e9 pr\u00e1ce i chyb.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pomoc\u00ed VBA a dal\u0161\u00edch n\u00e1stroj\u016f m\u016f\u017eeme automatizovat opakovan\u00e9 operace p\u0159\u00edmo v prost\u0159ed\u00ed Excelu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nap\u0159\u00edklad:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Otev\u0159\u00edt soubor \u2192 na\u010d\u00edst data \u2192 zpracovat \u2192 zkontrolovat \u2192 vytvo\u0159it v\u00fdstup \u2192 ulo\u017eit.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To v\u0161e m\u016f\u017ee prob\u011bhnout bez nutnosti prov\u00e1d\u011bt jednotliv\u00e9 kroky ru\u010dn\u011b.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Automatizace pomoc\u00ed Pythonu<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Pro slo\u017eit\u011bj\u0161\u00ed zpracov\u00e1n\u00ed dat nebo procesy, kter\u00e9 p\u0159esahuj\u00ed mo\u017enosti b\u011b\u017en\u00e9ho Excelu, vyu\u017e\u00edv\u00e1me tak\u00e9 Python.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Python lze vyu\u017e\u00edt nap\u0159\u00edklad pro:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>zpracov\u00e1n\u00ed v\u011bt\u0161\u00edho mno\u017estv\u00ed dat,<\/li>\n\n\n\n<li>automatizovan\u00e9 v\u00fdpo\u010dty,<\/li>\n\n\n\n<li>transformaci dat,<\/li>\n\n\n\n<li>pr\u00e1ci s v\u00edce soubory,<\/li>\n\n\n\n<li>p\u0159\u00edpravu v\u00fdstup\u016f,<\/li>\n\n\n\n<li>opakovan\u00e9 \u00falohy podle definovan\u00fdch pravidel.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Technologii v\u017edy vol\u00edme podle konkr\u00e9tn\u00edho probl\u00e9mu. Ne ka\u017ed\u00fd proces pot\u0159ebuje Python \u2013 n\u011bkdy je jednodu\u0161\u0161\u00ed a efektivn\u011bj\u0161\u00ed \u0159e\u0161en\u00ed pomoc\u00ed Excelu nebo VBA.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Jak poznat, \u017ee se v\u00e1\u0161 proces vyplat\u00ed automatizovat?<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Typick\u00fdm sign\u00e1lem je, kdy\u017e zam\u011bstnanec pravideln\u011b:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>kop\u00edruje data mezi soubory,<\/li>\n\n\n\n<li>vytv\u00e1\u0159\u00ed stejn\u00fd report ka\u017ed\u00fd t\u00fdden nebo m\u011bs\u00edc,<\/li>\n\n\n\n<li>ru\u010dn\u011b kontroluje velk\u00e9 mno\u017estv\u00ed \u00fadaj\u016f,<\/li>\n\n\n\n<li>p\u0159episuje informace z jednoho syst\u00e9mu do druh\u00e9ho,<\/li>\n\n\n\n<li>upravuje tabulky podle st\u00e1le stejn\u00fdch pravidel,<\/li>\n\n\n\n<li>opakuje n\u011bkolik stejn\u00fdch krok\u016f p\u0159i ka\u017ed\u00e9m zpracov\u00e1n\u00ed dat.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u010c\u00edm \u010dast\u011bji se \u010dinnost opakuje a \u010d\u00edm v\u00edce \u010dasu zab\u00edr\u00e1, t\u00edm v\u011bt\u0161\u00ed m\u016f\u017ee b\u00fdt p\u0159\u00ednos automatizace.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Nejd\u0159\u00edve hled\u00e1me probl\u00e9m, potom \u0159e\u0161en\u00ed<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Automatizace nen\u00ed c\u00edlem sama o sob\u011b.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nejprve se pod\u00edv\u00e1me na sou\u010dasn\u00fd proces a zjist\u00edme:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Co se dnes d\u011bl\u00e1 ru\u010dn\u011b?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Jak \u010dasto se \u010dinnost opakuje?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kolik \u010dasu zabere?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kde vznikaj\u00ed chyby?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Jak\u00e1 jsou pravidla pro zpracov\u00e1n\u00ed?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Teprve potom navrhneme vhodn\u00fd zp\u016fsob automatizace.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">V\u00fdsledkem nemus\u00ed b\u00fdt slo\u017eit\u00e1 aplikace. N\u011bkdy sta\u010d\u00ed jednoduch\u00fd n\u00e1stroj, kter\u00fd odstran\u00ed n\u011bkolik opakovan\u00fdch krok\u016f a zam\u011bstnanc\u016fm u\u0161et\u0159\u00ed hodiny pr\u00e1ce.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Jak spolupr\u00e1ce prob\u00edh\u00e1<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">01 \u2014 Pop\u00ed\u0161ete n\u00e1m proces<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sta\u010d\u00ed n\u00e1m popsat, co dnes d\u011bl\u00e1te ru\u010dn\u011b a co se p\u0159i pr\u00e1ci opakuje.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">02 \u2014 Najdeme prostor pro automatizaci<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Projdeme sou\u010dasn\u00fd postup a vyhodnot\u00edme, kter\u00e9 \u010d\u00e1sti lze automatizovat.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">03 \u2014 Navrhneme \u0159e\u0161en\u00ed<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Podle charakteru procesu zvol\u00edme vhodn\u00fd n\u00e1stroj \u2013 nap\u0159\u00edklad Excel\/VBA nebo Python.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">04 \u2014 Vytvo\u0159\u00edme a otestujeme \u0159e\u0161en\u00ed<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Automatizovan\u00fd proces ov\u011b\u0159\u00edme na re\u00e1ln\u00fdch datech a uprav\u00edme podle va\u0161ich pot\u0159eb.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">05 \u2014 P\u0159ed\u00e1me v\u00e1m funk\u010dn\u00ed n\u00e1stroj<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">V\u00fdsledkem je \u0159e\u0161en\u00ed, kter\u00e9 m\u016f\u017eete pou\u017e\u00edvat p\u0159i ka\u017edodenn\u00ed pr\u00e1ci.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">M\u00e1te proces, kter\u00fd neust\u00e1le opakujete?<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Mo\u017en\u00e1 ho nemus\u00ed d\u011blat \u010dlov\u011bk.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Popi\u0161te n\u00e1m, jak dnes proces funguje. Spole\u010dn\u011b se pod\u00edv\u00e1me, zda d\u00e1v\u00e1 jeho automatizace smysl a jak\u00e9 \u0159e\u0161en\u00ed by pro v\u00e1s bylo nejvhodn\u011bj\u0161\u00ed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/kontaktni-formular\/\" data-type=\"page\" data-id=\"84\">[Chci konzultovat automatizaci]<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u00e9n\u011b ru\u010dn\u00ed pr\u00e1ce. M\u00e9n\u011b chyb. V\u00edce \u010dasu na d\u016fle\u017eitou pr\u00e1ci. Opakujete ka\u017ed\u00fd den nebo ka\u017ed\u00fd t\u00fdden stejn\u00e9 \u00fakoly v Excelu, zpracov\u00e1v\u00e1te data ru\u010dn\u011b, vytv\u00e1\u0159\u00edte st\u00e1le stejn\u00e9 reporty nebo p\u0159episujete informace mezi n\u011bkolika soubory? Takov\u00e9 \u010dinnosti lze \u010dasto automatizovat. Pom\u00e1h\u00e1me firm\u00e1m hledat a automatizovat opakovan\u00e9 kancel\u00e1\u0159sk\u00e9 a technick\u00e9 procesy. Zam\u011b\u0159ujeme se p\u0159edev\u0161\u00edm na praktick\u00e1 \u0159e\u0161en\u00ed, kter\u00e1&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"class_list":["post-136","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/pages\/136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":2,"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/pages\/136\/revisions"}],"predecessor-version":[{"id":150,"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/pages\/136\/revisions\/150"}],"wp:attachment":[{"href":"https:\/\/www.engitec-office.cz\/domains\/engitec-office.cz\/wp-json\/wp\/v2\/media?parent=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}