{"id":10127,"date":"2025-07-23T12:53:34","date_gmt":"2025-07-23T12:53:34","guid":{"rendered":"https:\/\/podpora.nuggetsw.cz\/?post_type=lsvr_kba&#038;p=10127"},"modified":"2025-10-29T10:10:26","modified_gmt":"2025-10-29T10:10:26","slug":"sestavy-mzdova-statistika","status":"publish","type":"lsvr_kba","link":"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/sestavy-mzdova-statistika\/","title":{"rendered":"Sestavy: Mzdov\u00e1 statistika"},"content":{"rendered":"\n<p>Mzdov\u00e9 statistiky jsou univerz\u00e1ln\u00edm n\u00e1strojem pro p\u0159\u00edpravu anal\u00fdz mzdov\u00fdch n\u00e1klad\u016f i rozbor\u016f pln\u011bn\u00ed \u010dasov\u00e9ho fondu. Proto\u017ee ka\u017ed\u00e1 spole\u010dnost m\u00e1 odli\u0161n\u00e9 po\u017eadavky, sna\u017e\u00edme se, aby na\u0161e n\u00e1stroje byly, co nejv\u00edce univerz\u00e1ln\u00ed a umo\u017e\u0148ovaly u\u017eivatel\u016fm z\u00edskat, co nejsnadn\u011bji v\u0161echna po\u017eadovan\u00e1 data a pohledy na n\u011b.&nbsp;<\/p>\n\n\n\n<p>Statistiky m\u00e1me t\u0159i a ka\u017ed\u00e1 se vytv\u00e1\u0159\u00ed pro jin\u00e9 \u00fa\u010dely. LZ721 je \u0159\u00e1dkov\u00e1 statistika bez jmen, LZ722 se vytv\u00e1\u0159\u00ed pro aktu\u00e1ln\u00ed m\u011bs\u00edc (pro jmenn\u00fd seznam zam\u011bstnanc\u016f) a LZ723 je obdobn\u00e1 LZ722, jen se vytv\u00e1\u0159\u00ed pro \u010dasovou \u0159adu (nap\u0159. za rok, fisk\u00e1ln\u00ed rok apod.)<\/p>\n\n\n\n<p><em><strong>Co se dozv\u00edte v tomto \u010dl\u00e1nku:<\/strong><\/em><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Tvorba &#8222;\u0161ablony&#8220; pro statistiku<\/li><li>Mzdov\u00e1 statistika LZ721 &#8211; \u0159\u00e1dkov\u00e1, beze jmen<\/li><li>Mzdov\u00e1 statistika LZ722 &#8211; nejpou\u017e\u00edvan\u011bj\u0161\u00ed v r\u00e1mci m\u011bs\u00edce<\/li><li>P\u0159\u00edklad: mzdov\u00e1 statistika LZ722 &#8211; pro pr\u00e9mie<\/li><li>Mzdov\u00e1 statistika LZ723 &#8211; \u010dasov\u00e1<\/li><li>P\u0159\u00edklad: mzdov\u00e1 statistika LZ723 &#8211; hrub\u00e1 mzda po m\u011bs\u00edc\u00edch<\/li><li>Znak sumace ve statistik\u00e1ch<\/li><li>V\u00fdstupy mzdov\u00fdch statistik<\/li><li>V\u00fdb\u011brov\u00e9 krit\u00e9rium ve v\u00fdstupu mzdov\u00fdch statistik<\/li><\/ol>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Tvorba &#8222;\u0161ablony&#8220; pro statistiku<\/h2>\n\n\n\n<p><strong>Tzv. \u0161ablonu pro mzdovou statistiku si vytv\u00e1\u0159\u00edte ve funkci 2-7-2, 2-7-3 nebo 2-7-4<\/strong>, v\u00fdstupn\u00ed sestavu pak generujete nap\u0159. ve funkci 10 a 11 (viz n\u00ed\u017ee)<\/p>\n\n\n\n<p><strong>LZ721 \u2013 vytv\u00e1\u0159\u00ed se ve funkci Mzdy 2-7-2<\/strong> (bez jmen, \u0159\u00e1dkov\u00e1)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0158\u00e1dkov\u00e1 statistika bez jmen zam\u011bstnanc\u016f, pouze dle kategorie (\u00fadaj L3204 v kmenov\u00fdch \u00fadaj\u00edch zam\u011bstnance) a sou\u010dtovan\u00e1 dle nastaven\u00ed v tiskov\u00fdch parametrech 2-7-5.<\/li><li>Po\u010det \u0159\u00e1dk\u016f limitov\u00e1n na 500.<\/li><\/ul>\n\n\n\n<p><strong>LZ722 \u2013 vytv\u00e1\u0159\u00ed se funkci Mzdy 2-7-3 (nejpou\u017e\u00edvan\u011bj\u0161\u00ed)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Sloupcov\u00e1 statistika obsahuj\u00edc\u00ed jm\u00e9na zam\u011bstnanc\u016f a hodnoty mzdov\u00fdch slo\u017eek v jednotliv\u00fdch sloupc\u00edch a sou\u010dtovan\u00e1 dle nastaven\u00ed v tiskov\u00fdch parametrech 2-7-5.<\/li><\/ul>\n\n\n\n<p><strong>LZ723 \u2013 vytv\u00e1\u0159\u00ed se ve funkci Mzdy 2-7-4 (\u010dasov\u00e1)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Obdoba statistiky LZ722, ale nav\u00edc s roz\u0161\u00ed\u0159en\u00fdm parametrem o \u010dasovou osu (pro m\u011bs\u00edce v aktu\u00e1ln\u00edm roce, pro fisk\u00e1ln\u00ed rok apod.) a tak\u00e9 sou\u010dtovan\u00e1 dle nastaven\u00ed v tiskov\u00fdch parametrech 2-7-5.<\/li><\/ul>\n\n\n\n<p>Kdy\u017e otev\u0159ete n\u011bkterou z v\u00fd\u0161e uveden\u00fdch funkc\u00ed, otev\u0159e se okno s ji\u017e d\u0159\u00edve ulo\u017een\u00fdmi statistikami:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"467\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/MS1.jpg\" alt=\"\" class=\"wp-image-7715\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/MS1.jpg 616w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/MS1-300x227.jpg 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">V\u00fdznamov\u00e9 tla\u010d\u00edtka pro v\u0161echny mzdov\u00e9 statistiky:<\/h4>\n\n\n\n<p><strong>Upravit<\/strong> \u2013 otev\u0159ete ozna\u010denou, d\u0159\u00edve ulo\u017eenou statistiku.<br><strong>Nov\u00fd z\u00e1znam<\/strong> \u2013 umo\u017en\u00ed vytvo\u0159it novou statistiku s&nbsp;unik\u00e1tn\u00edm n\u00e1zvem.<br><strong>Smazat z\u00e1znam<\/strong> \u2013 umo\u017en\u00ed smazat st\u00e1vaj\u00edc\u00ed statistiku (ozna\u010denou statistiku).<br><strong>Kopie<\/strong> \u2013 umo\u017en\u00ed vytvo\u0159it kopii ji\u017e st\u00e1vaj\u00edc\u00ed statistiky s unik\u00e1tn\u00edm n\u00e1zvem a pracovat s n\u00ed, ani\u017e by to ovlivnilo p\u016fvodn\u00ed kop\u00edrovanou statistiku.<br><strong>Opis definice<\/strong> \u2013 umo\u017en\u00ed do Tiskov\u00fdch zpr\u00e1v vyjet sestavu, kter\u00e1 uk\u00e1\u017ee v\u0161echny mzdov\u00e9 slo\u017eky ve statistice.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Mzdov\u00e1 statistika <strong>LZ721<\/strong> &#8211; \u0159\u00e1dkov\u00e1, beze jmen<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Funkce Mzdy 2-7-2<\/strong> &#8211; <strong>Nov\u00fd z\u00e1znam<\/strong> (za nebo p\u0159ed, poprv\u00e9 je to jedno)<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"602\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-37.png\" alt=\"\" class=\"wp-image-7717\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-37.png 794w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-37-300x227.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-37-768x582.png 768w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/figure><\/div>\n\n\n\n<p>Nejprve si pojmenujte statistku do prvn\u00edho \u017elut\u00e9ho pole Statistika: unik\u00e1tn\u00ed bez mezerov\u00fd n\u00e1zev, max. 10 alfanumerick\u00fdch znak\u016f bez pou\u017eit\u00ed znak\u016f \\, \/, *, :, ?, &#8222;, &lt;, &gt;, | ) a ve druh\u00e9m \u017elut\u00e9m poli si zapi\u0161te kr\u00e1tk\u00fd popis statistiky.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"38\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38.png\" alt=\"\" class=\"wp-image-7718\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38.png 783w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38-300x15.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38-768x37.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Vysv\u011btlen\u00ed jednotliv\u00fdch pol\u00ed \u2013 statistika LZ721<\/h4>\n\n\n\n<p><strong>N\u00e1zev \u0159\u00e1dku<\/strong> \u2013 n\u00e1zev, kter\u00fd se objev\u00ed jako n\u00e1zev sloupce ve v\u00fdsledn\u00e9 sestav\u011b.<br><strong>Tiskov\u00fd \u0159\u00e1dek<\/strong> \u2013 program ur\u010d\u00ed sice s\u00e1m, ale je mo\u017eno si nastavit vlastn\u00ed \u0159\u00e1dkov\u00e1n\u00ed nap\u0159. po zad\u00e1n\u00ed v\u0161ech \u0159\u00e1dk\u016f budete cht\u00edt zm\u011bnit po\u0159ad\u00ed, vyu\u017eijete p\u0159e\u010d\u00edslov\u00e1n\u00ed tohoto pole.<br><strong>Po\u010detn\u00ed operace<\/strong> \u2013 zde si vyberete, zdali chcete K\u010d, hod., dny, sou\u010dty \u0159\u00e1dk\u016f, atd.<br><strong>N\u00e1sob\u00edc\u00ed konstanta<\/strong> &#8211; pro standardn\u00ed definici \u0159\u00e1dku se \u00fadaj nevypl\u0148uje a nech\u00e1v\u00e1 se hodnota 000.00; toto pole je ur\u010deno pro z\u00e1pis hodnoty, kter\u00e9 n\u00e1sob\u00ed hodnoty mzdov\u00fdch slo\u017eek zapsan\u00fdch v p\u0159\u00edslu\u0161en\u00e9m \u0159\u00e1dku\/sloupce nebo kter\u00e1 nap\u0159. zjist\u00ed vz\u00e1jemn\u00fd pod\u00edl hodnot zapsan\u00fdch na \u010d\u00edslech p\u0159\u00edslu\u0161n\u00fdch \u0159\u00e1dk\u016f\/sloupc\u016f.<\/p>\n\n\n\n<p>N\u00e1sleduje <strong>p\u0159id\u00e1n\u00ed mzdov\u00e9 slo\u017eky \u010di skupiny<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Mzdov\u00e9 slo\u017eky<\/strong><ol><li><strong>P\u0159idat Mzdsl<\/strong><ul><li>Otev\u0159e se v t\u011ble tabulky jedno okno pro zad\u00e1n\u00ed jedn\u00e9 mzdov\u00e9 slo\u017eky (bu\u010f zap\u00ed\u0161ete \u010d\u00edslo mzdov\u00e9 slo\u017eky do \u017elut\u00e9ho pole nebo si pom\u016f\u017eete otev\u00edrac\u00edm menu <img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"26\" class=\"wp-image-7719\" style=\"\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5.jpg\" alt=\"\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5.jpg 355w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5-300x22.jpg 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/li><\/ul><\/li><li><strong>P\u0159idat v\u00edce Mzdsl<\/strong><ul><li>Otev\u0159e se \u010d\u00edseln\u00edk mzdov\u00fdch slo\u017eek, kde si m\u016f\u017eete ozna\u010dit v\u00edce mzdov\u00fdch slo\u017eek a tla\u010d\u00edtkem OK vlo\u017eit v\u0161echny najednou (m\u016f\u017eete pou\u017e\u00edt filtr &#8211; \u017elut\u00e9 pole vpravo naho\u0159e).<\/li><\/ul><\/li><\/ol><\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"444\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39.png\" alt=\"\" class=\"wp-image-7720\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39.png 720w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39-300x185.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure><\/div>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>Skupiny<\/strong><ul><li>Otev\u0159e se mo\u017enost zadat skupiny slo\u017eek, nap\u0159. hrub\u00e1 mzda, mzdov\u00e9 slo\u017eky pololetn\u00ed, mzdov\u00e9 slo\u017eky vstupuj\u00edc\u00ed do v\u00fdpo\u010dtu pr\u00e9mi\u00ed apod.<\/li><li>Podklady pro tyto skupiny se berou z \u010d\u00edseln\u00edku mzdov\u00fdch slo\u017eek a jejich zapo\u010ditatelnosti, tedy z funkce <a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/nastaveni-ciselniku-mzdovych-slozek\/\" target=\"_blank\">Mzdy 2-4-2<\/a>.<\/li><\/ul><\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"405\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40.png\" alt=\"\" class=\"wp-image-7721\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40.png 354w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40-262x300.png 262w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/figure><\/div>\n\n\n\n<p><strong>Po\u010det \u0159\u00e1dk\u016f je limitov\u00e1n max. do 500<\/strong>.<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Mzdov\u00e1 statistika <strong>LZ72<\/strong>2 &#8211; nejpou\u017e\u00edvan\u011bj\u0161\u00ed v r\u00e1mci m\u011bs\u00edce<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Jednotliv\u00e9 \u0159\u00e1dky p\u0159i tvorb\u011b statistiky znamenaj\u00ed jeden sloupec ve v\u00fdstupn\u00edm CSV souboru.<\/li><li>Ka\u017ed\u00fd sloupec ve v\u00fdstupn\u00edm souboru m\u016f\u017eete naplnit se\u010dten\u00edm n\u011bkolika mzdov\u00fdch slo\u017eek, kter\u00e9 se nas\u010d\u00edt\u00e1vaj\u00ed pr\u00e1v\u011b do jednoho sloupce.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Funkce Mzdy 2-7-3<\/strong> &#8211; <strong>Nov\u00fd z\u00e1znam<\/strong> (za nebo p\u0159ed, poprv\u00e9 je to jedno)<\/li><li>Pro v\u0161echny statistiky plat\u00ed, \u017ee se mus\u00ed unik\u00e1tn\u011b jmenovat: <ul><li>do pole s n\u00e1zvem &#8222;Statistika&#8220; vlo\u017ete unik\u00e1tn\u00ed n\u00e1zev bez mezer, max. 10 alfanumerick\u00fdch znak\u016f bez pou\u017eit\u00ed znak\u016f \\, \/, *, :, ?, &#8222;, &lt;, &gt;, | ) <\/li><li>do druh\u00e9ho \u017elut\u00e9ho pole kr\u00e1tk\u00fd popis statistiky<\/li><\/ul><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"38\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38.png\" alt=\"\" class=\"wp-image-7718\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38.png 783w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38-300x15.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38-768x37.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure><\/div>\n\n\n\n<p><strong>Nov\u00fd z\u00e1znam otev\u0159e okno pro zad\u00e1v\u00e1n\u00ed konkr\u00e9tn\u00edho sloupce<\/strong>:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"221\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-43.png\" alt=\"\" class=\"wp-image-7730\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-43.png 650w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-43-300x102.png 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure><\/div>\n\n\n\n<p><strong>N\u00e1zev sloupce<\/strong> &#8211; n\u00e1zev, kter\u00fd se objev\u00ed jako n\u00e1zev sloupce ve v\u00fdsledn\u00e9 sestav\u011b.<br><strong>Tiskov\u00fd sloupec<\/strong> &#8211; program ur\u010d\u00ed sice s\u00e1m, ale je mo\u017eno si nastavit vlastn\u00ed po\u0159ad\u00ed sloupc\u016f nap\u0159. po zad\u00e1n\u00ed v\u0161ech sloupc\u016f budete cht\u00edt zm\u011bnit po\u0159ad\u00ed, vyu\u017eijete p\u0159e\u010d\u00edslov\u00e1n\u00ed tohoto pole.<br><strong>Po\u010detn\u00ed operace<\/strong> &#8211; zde si vyberete, zdali chcete K\u010d, hod., dny, sou\u010dty sloupc\u016f, atd.<br><strong>N\u00e1sob\u00edc\u00ed konstanta<\/strong> &#8211; pro standardn\u00ed definici \u0159\u00e1dku se \u00fadaj nevypl\u0148uje a nech\u00e1v\u00e1 se hodnota 000.00; toto pole je ur\u010deno pro z\u00e1pis hodnoty, kter\u00e9 n\u00e1sob\u00ed hodnoty mzdov\u00fdch slo\u017eek zapsan\u00fdch v p\u0159\u00edslu\u0161en\u00e9m \u0159\u00e1dku\/sloupce nebo kter\u00e1 nap\u0159. zjist\u00ed vz\u00e1jemn\u00fd pod\u00edl hodnot zapsan\u00fdch na \u010d\u00edslech p\u0159\u00edslu\u0161n\u00fdch \u0159\u00e1dk\u016f\/sloupc\u016f.<br><strong>Query \u00fadaj a Text<\/strong> &#8211; v p\u0159\u00edpad\u011b, \u017ee budete cht\u00edt spojit vytv\u00e1\u0159enou mzdovou statistiku s query, m\u016f\u017eete si zde ur\u010dit jej\u00ed <strong>n\u00e1zev a popis<\/strong>, kdy \u00dadaj je 10m\u00edstn\u00fd identifik\u00e1tor a N\u00e1zev je max. 50m\u00edstn\u00fd konkr\u00e9tn\u00ed pojmenov\u00e1n\u00ed sloupce), nen\u00ed ale nutno vypl\u0148ovat. Pokud nevypln\u00edte a i p\u0159esto spoj\u00edte s Query, program dopln\u00ed n\u00e1zev jako Xyyyy, kdy &#8222;yyyy&#8220; je \u010d\u00edslo sloupce konkr\u00e9tn\u00ed p\u0159ipojen\u00e9 mzdov\u00e9 statistiky (p\u0159\u00edmo v querech m\u016f\u017eete tyto \u00fadaje pojmenovat \u010di p\u0159ejmenovat).<\/p>\n\n\n\n<p>N\u00e1sleduje <strong>p\u0159id\u00e1n\u00ed mzdov\u00e9 slo\u017eky \u010di skupiny<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Mzdov\u00e9 slo\u017eky<\/strong><ol><li><strong>P\u0159idat Mzdsl<\/strong><ul><li>Otev\u0159e se v\u00e1m v t\u011ble tabulky jedno okno pro zad\u00e1n\u00ed jedn\u00e9 mzdov\u00e9 slo\u017eky (bu\u010f zap\u00ed\u0161ete \u010d\u00edslo mzdov\u00e9 slo\u017eky do \u017elut\u00e9ho pole nebo si pom\u016f\u017eete otev\u00edrac\u00edm menu <img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"26\" class=\"wp-image-7719\" style=\"\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5.jpg\" alt=\"\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5.jpg 355w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5-300x22.jpg 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/li><\/ul><\/li><li><strong>P\u0159idat v\u00edce Mzdsl<\/strong><ul><li>Otev\u0159e se v\u00e1m \u010d\u00edseln\u00edk mzdov\u00fdch slo\u017eek, kde si m\u016f\u017eete ozna\u010dit v\u00edce mzdov\u00fdch slo\u017eek a tla\u010d\u00edtkem OK vlo\u017eit v\u0161echny najednou (m\u016f\u017eete pou\u017e\u00edt filtr &#8211; \u017elut\u00e9 pole vpravo naho\u0159e).<\/li><\/ul><\/li><\/ol><\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"444\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39.png\" alt=\"\" class=\"wp-image-7720\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39.png 720w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39-300x185.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure><\/div>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>Skupiny<\/strong><ul><li>Otev\u0159e se mo\u017enost zadat skupiny slo\u017eek, nap\u0159. hrub\u00e1 mzda, mzdov\u00e9 slo\u017eky pololetn\u00ed, mzdov\u00e9 slo\u017eky vstupuj\u00edc\u00ed do v\u00fdpo\u010dtu pr\u00e9mi\u00ed apod.<\/li><li>Podklady pro tyto skupiny se berou z \u010d\u00edseln\u00edku mzdov\u00fdch slo\u017eek a jejich zapo\u010ditatelnosti, tedy z funkce <a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/nastaveni-ciselniku-mzdovych-slozek\/\" target=\"_blank\">Mzdy 2-4-2<\/a>.<\/li><\/ul><\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"405\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40.png\" alt=\"\" class=\"wp-image-7721\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40.png 354w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40-262x300.png 262w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/figure><\/div>\n\n\n\n<p><strong>M\u016f\u017eete m\u00edt a\u017e 10 sloupc\u016f v jednom \u0159\u00e1dku, po\u010det sloupc\u016f limitov\u00e1n max. do 100<\/strong><\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">P\u0159\u00edklad: Tvorba statistiky LZ722 pro pr\u00e9mie<\/h2>\n\n\n\n<p>Uk\u00e1\u017eeme si, jak si vyrob\u00edme statistiku, kdy ve v\u00fdsledn\u00e9m souboru budou \u010dty\u0159i sloupe\u010dky: pro m\u011bs\u00ed\u010dn\u00ed pr\u00e9mie, \u010dtvrtletn\u00ed pr\u00e9mie, ro\u010dn\u00ed pr\u00e9mie a celkem v\u0161echny pr\u00e9mie dohromady.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"790\" height=\"243\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-44.png\" alt=\"\" class=\"wp-image-7731\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-44.png 790w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-44-300x92.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-44-768x236.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/figure><\/div>\n\n\n\n<p><strong>KROK 1<\/strong>: Nov\u00fd z\u00e1znam (za nebo p\u0159ed je pro prvn\u00ed p\u0159id\u00e1n\u00ed jedno)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>V tomto sloupe\u010dku m\u00e1me pouze jednu m\u011bs\u00ed\u010dn\u00ed pr\u00e9mii a je v K\u010d, proto v Po\u010detn\u00ed operaci z\u016fst\u00e1v\u00e1 Sou\u010det K\u010d.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"651\" height=\"208\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-45.png\" alt=\"\" class=\"wp-image-7732\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-45.png 651w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-45-300x96.png 300w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Po ulo\u017een\u00ed tla\u010d\u00edtkem OK se n\u00e1m otev\u0159e nov\u00e9 okno pro zad\u00e1n\u00ed nov\u00e9ho sloupce.<\/li><\/ul>\n\n\n\n<p><strong>KROK 2<\/strong>: Do druh\u00e9ho sloupce budeme p\u0159id\u00e1vat v\u00edce korunov\u00fdch mzdov\u00fdch slo\u017eek, proto\u017ee do \u010dtvrtletn\u00edch pr\u00e9mi\u00ed pot\u0159ebujeme zadat dv\u011b mzdov\u00e9 slo\u017eky.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>V\u0161imn\u011bte si, \u017ee kdy\u017e se p\u0159es P\u0159idat v\u00edce Mzdsl otev\u0159e &#8222;V\u00fdb\u011br mzdov\u00fdch slo\u017eek&#8220;, \u017ee je vyu\u017eit filtr vpravo naho\u0159e, kter\u00fd z\u00fa\u017eil v\u00fdb\u011br mzdov\u00fdch slo\u017eek &#8211; sta\u010d\u00ed pak pouze ozna\u010dit dan\u00e9 mzdov\u00e9 slo\u017eky a pomoc\u00ed tla\u010d\u00edtka OK vlo\u017eit do statistiky.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"427\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-46.png\" alt=\"\" class=\"wp-image-7733\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-46.png 731w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-46-300x175.png 300w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/figure><\/div>\n\n\n\n<p><strong>KROK 3<\/strong>: Do t\u0159et\u00edho sloupce budeme p\u0159id\u00e1vat podobn\u00fdm zp\u016fsobem co v kroku 2.<\/p>\n\n\n\n<p><strong>KROK 4<\/strong>: Chceme v\u0161echny pr\u00e9mie se\u010d\u00edst, proto v dal\u0161\u00edm sloupci v Po\u010detn\u00ed operaci vybereme Sou\u010det d\u0159\u00edve spo\u010d\u00edtan\u00fdch sloupc\u016f a pak ve V\u00fdb\u011bru n\u00ed\u017ee ozna\u010d\u00edme sloupce, kter\u00e9 chceme se\u010d\u00edst (v na\u0161em p\u0159\u00edpad\u011b v\u0161echny).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"646\" height=\"230\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-47.png\" alt=\"\" class=\"wp-image-7734\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-47.png 646w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-47-300x107.png 300w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/figure><\/div>\n\n\n\n<p>Takto m\u00e1me p\u0159ipravenou mzdovou statistiku pro Pr\u00e9mie. V\u00fdstupn\u00ed sestava ve funkci 11-3-3 (kde jsem si ur\u010dila, \u017ee chci sestavu za cel\u00fd rok 2023 od ledna do prosince) pak do Pracovn\u00edho adres\u00e1\u0159e vygeneruje sestavu s n\u00e1zvem Pr\u00e9mie a vypad\u00e1 pak takto (vzorek z v\u00fdstupn\u00edho souboru):<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"812\" height=\"362\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-48.png\" alt=\"\" class=\"wp-image-7735\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-48.png 812w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-48-300x134.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-48-768x342.png 768w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Mzdov\u00e1 statistika LZ723 &#8211; \u010dasov\u00e1<\/h2>\n\n\n\n<p><strong>Funkce Mzdy 2-7-4 &#8211; Nov\u00fd z\u00e1znam<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"594\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-49.png\" alt=\"\" class=\"wp-image-7737\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-49.png 795w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-49-300x224.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-49-768x574.png 768w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Pro v\u0161echny statistiky plat\u00ed, \u017ee se mus\u00ed unik\u00e1tn\u011b jmenovat: <ul><li>do pole s n\u00e1zvem &#8222;Statistika&#8220; vlo\u017ete unik\u00e1tn\u00ed n\u00e1zev bez mezer, max. 10 alfanumerick\u00fdch znak\u016f bez pou\u017eit\u00ed znak\u016f \\, \/, *, :, ?, &#8222;, &lt;, &gt;, | ) <\/li><li>do druh\u00e9ho \u017elut\u00e9ho pole kr\u00e1tk\u00fd popis statistiky<\/li><\/ul><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"38\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38.png\" alt=\"\" class=\"wp-image-7718\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38.png 783w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38-300x15.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-38-768x37.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure><\/div>\n\n\n\n<p><strong>N\u00e1zev sloupce<\/strong> &#8211; n\u00e1zev, kter\u00fd se objev\u00ed jako n\u00e1zev sloupce ve v\u00fdsledn\u00e9 sestav\u011b.<br><strong>Tiskov\u00fd sloupec<\/strong> &#8211; program ur\u010d\u00ed sice s\u00e1m, ale je mo\u017eno si nastavit vlastn\u00ed po\u0159ad\u00ed sloupc\u016f nap\u0159. po zad\u00e1n\u00ed v\u0161ech sloupc\u016f budete cht\u00edt zm\u011bnit po\u0159ad\u00ed, vyu\u017eijete p\u0159e\u010d\u00edslov\u00e1n\u00ed tohoto pole.<br><strong>Po\u010detn\u00ed operace<\/strong> &#8211; zde si vyberete, zdali chcete K\u010d, hod., dny, sou\u010dty sloupc\u016f, atd.<br><strong>N\u00e1sob\u00edc\u00ed konstanta<\/strong> &#8211; pro standardn\u00ed definici \u0159\u00e1dku se \u00fadaj nevypl\u0148uje a nech\u00e1v\u00e1 se hodnota 000.00; toto pole je ur\u010deno pro z\u00e1pis hodnoty, kter\u00e9 n\u00e1sob\u00ed hodnoty mzdov\u00fdch slo\u017eek zapsan\u00fdch v p\u0159\u00edslu\u0161en\u00e9m \u0159\u00e1dku\/sloupce nebo kter\u00e1 nap\u0159. zjist\u00ed vz\u00e1jemn\u00fd pod\u00edl hodnot zapsan\u00fdch na \u010d\u00edslech p\u0159\u00edslu\u0161n\u00fdch \u0159\u00e1dk\u016f\/sloupc\u016f.<br><strong>Query \u00fadaj a Text<\/strong> &#8211; v p\u0159\u00edpad\u011b, \u017ee budete cht\u00edt spojit vytv\u00e1\u0159enou mzdovou statistiku s query, m\u016f\u017eete si zde ur\u010dit jej\u00ed n\u00e1zev a popis, kdy \u00dadaj je 10m\u00edstn\u00fd identifik\u00e1tor a N\u00e1zev je max. 50m\u00edstn\u00fd konkr\u00e9tn\u00ed pojmenov\u00e1n\u00ed sloupce), nen\u00ed ale nutno vypl\u0148ovat. Pokud nevypln\u00edte a i p\u0159esto spoj\u00edte s Query, program dopln\u00ed n\u00e1zev jako Xyyyy, kdy &#8222;yyyy&#8220; je \u010d\u00edslo sloupce konkr\u00e9tn\u00ed p\u0159ipojen\u00e9 mzdov\u00e9 statistiky (p\u0159\u00edmo v querech m\u016f\u017eete tyto \u00fadaje pojmenovat \u010di p\u0159ejmenovat).<\/p>\n\n\n\n<p><strong>Zm\u011bna roku (m\u00ednus)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>0 \u2013 aktu\u00e1ln\u00ed rok = zadan\u00fd rok<\/li><li>1 \u2013 aktu\u00e1ln\u00ed rok = zadan\u00fd rok m\u00ednus 1 (tedy lo\u0148sk\u00fd rok)<\/li><li>2 \u2013 aktu\u00e1ln\u00ed rok = zadan\u00fd rok m\u00ednus 2 (tedy p\u0159edlo\u0148sk\u00fd rok)<\/li><\/ul>\n\n\n\n<p><strong>M\u011bs\u00edc<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Vypln\u011bno pole s +\/-: Pokud nen\u00ed vypln\u011bno, tak aktu\u00e1ln\u00ed m\u011bs\u00edc = zadan\u00fd m\u011bs\u00edc (tento sloupec pracuje p\u0159i vytv\u00e1\u0159en\u00ed zpr\u00e1vy za m\u011bs\u00edc po v\u00fdpo\u010dtu nebo s hodnotami aktu\u00e1ln\u00edho m\u011bs\u00edce \u00fa\u010detn\u00edho obdob\u00ed.<\/li><li>Vypln\u011bno pole s \u010d\u00edslem 1-12, tak aktu\u00e1ln\u00ed m\u011bs\u00edc = vypln\u011bn\u00fd m\u011bs\u00edc 1-12 (tento \u0159\u00e1dek pracuje v\u017edy s hodnotami m\u011bs\u00edce vypsan\u00e9ho ve sloupci M\u011bs\u00edc).<\/li><li>Vypln\u011bno +\/- a m\u011bs\u00edc 1-12: pak aktu\u00e1ln\u00ed m\u011bs\u00edc = zadan\u00fd m\u011bs\u00edc +\/- a m\u011bs\u00edc 1-12 (tento sloupec pracuje p\u0159i vytv\u00e1\u0159en\u00ed zpr\u00e1vy za m\u011bs\u00edc po v\u00fdpo\u010dtu s hodnotami aktu\u00e1ln\u00edho m\u011bs\u00edce +\/- po\u010det m\u011bs\u00edc\u016f uveden\u00fdch ve sloupci M\u011bs\u00edc, resp. hodnotami zadan\u00e9ho m\u011bs\u00edce +\/- po\u010det m\u011bs\u00edc\u016f uveden\u00fdch ve sloupci M\u011bs\u00edc.<\/li><\/ul>\n\n\n\n<p><strong>Po\u010det m\u011bs\u00edc\u016f<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>nevypln\u011bno = sloupec se vypo\u010dte ze mzdov\u00fdch slo\u017eek za aktu\u00e1ln\u00ed rok a aktu\u00e1ln\u00ed m\u011bs\u00edc<\/li><li>vypln\u011bno = \u0159\u00e1dek se vypo\u010dte ze mzdov\u00fdch slo\u017eek za zadan\u00e9 obdob\u00ed<\/li><\/ul>\n\n\n\n<p>N\u00e1sleduje <strong>p\u0159id\u00e1n\u00ed mzdov\u00e9 slo\u017eky \u010di skupiny<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Mzdov\u00e9 slo\u017eky<\/strong><ol><li><strong>P\u0159idat Mzdsl<\/strong><ul><li>Otev\u0159e se v t\u011ble tabulky jedno okno pro zad\u00e1n\u00ed jedn\u00e9 mzdov\u00e9 slo\u017eky (bu\u010f zap\u00ed\u0161ete \u010d\u00edslo mzdov\u00e9 slo\u017eky do \u017elut\u00e9ho pole nebo si pom\u016f\u017eete otev\u00edrac\u00edm menu <img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"26\" class=\"wp-image-7719\" style=\"\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5.jpg\" alt=\"\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5.jpg 355w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/MS5-300x22.jpg 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/li><\/ul><\/li><li><strong>P\u0159idat v\u00edce Mzdsl<\/strong><ul><li>Otev\u0159e se \u010d\u00edseln\u00edk mzdov\u00fdch slo\u017eek, kde si m\u016f\u017eete ozna\u010dit v\u00edce mzdov\u00fdch slo\u017eek a tla\u010d\u00edtkem OK vlo\u017eit v\u0161echny najednou (m\u016f\u017eete pou\u017e\u00edt filtr &#8211; \u017elut\u00e9 pole vpravo naho\u0159e).<\/li><\/ul><\/li><\/ol><\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"444\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39.png\" alt=\"\" class=\"wp-image-7720\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39.png 720w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-39-300x185.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure><\/div>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>Skupiny<\/strong><ul><li>Otev\u0159e se v\u00e1m mo\u017enost zadat skupiny slo\u017eek, nap\u0159. hrub\u00e1 mzda, mzdov\u00e9 slo\u017eky pololetn\u00ed, mzdov\u00e9 slo\u017eky vstupuj\u00edc\u00ed do v\u00fdpo\u010dtu pr\u00e9mi\u00ed apod.<\/li><li>Podklady pro tyto skupiny se berou z \u010d\u00edseln\u00edku mzdov\u00fdch slo\u017eek a jejich zapo\u010ditatelnosti, tedy z funkce <a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/nastaveni-ciselniku-mzdovych-slozek\/\" target=\"_blank\">Mzdy 2-4-2<\/a>.<\/li><\/ul><\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"405\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40.png\" alt=\"\" class=\"wp-image-7721\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40.png 354w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-40-262x300.png 262w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/figure><\/div>\n\n\n\n<p><strong>M\u016f\u017eete m\u00edt a\u017e 10 sloupc\u016f v jednom \u0159\u00e1dku, po\u010det sloupc\u016f limitov\u00e1n max. do 100<\/strong>. <\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">P\u0159\u00edklad: Mzdov\u00e1 statistika LZ723 &#8211; hrub\u00e1 mzda po m\u011bs\u00edc\u00edch<\/h2>\n\n\n\n<p>Uk\u00e1\u017eeme si, jak si vyrob\u00edme mzdovou statistiku na hrubou mzdu, ale po jednotliv\u00fdch m\u011bs\u00edc\u00edch a za cel\u00fd rok.<\/p>\n\n\n\n<p><strong>KROK 1<\/strong>: Nov\u00fd z\u00e1znam (za nebo p\u0159ed je jedno) &#8211; pojmenujeme statistiku; zap\u00ed\u0161eme n\u00e1zev do N\u00e1zev sloupce a ur\u010d\u00edme m\u011bs\u00edc (rok chceme aktu\u00e1ln\u00ed) a Po\u010det m\u011bs\u00edc\u016f = 1; a vybereme Skupiny a z v\u00fdb\u011bru vybereme HRMZ Zapo\u010ditateln\u00e9 do hrub\u00e9 mzdy a ulo\u017e\u00edme tla\u010d\u00edtkem OK.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"793\" height=\"599\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-51.png\" alt=\"\" class=\"wp-image-7740\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-51.png 793w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-51-300x227.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-51-768x580.png 768w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><\/figure><\/div>\n\n\n\n<p><strong>KROK 2<\/strong>: Jeliko\u017e budeme m\u00edt de facto 12 sloupc\u016f \u00fapln\u011b stejn\u00fdch, proto dal\u0161\u00ed okno zav\u0159eme a v otev\u0159en\u00e9m okn\u011b klikneme na Kopie (kopii m\u016f\u017eeme ud\u011blat pouze pro posledn\u00ed \u0159\u00e1dek v aktualizaci statistiky) a zvol\u00edme 11 kopi\u00ed.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"314\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-52.png\" alt=\"\" class=\"wp-image-7741\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-52.png 794w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-52-300x119.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-52-768x304.png 768w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/figure><\/div>\n\n\n\n<p><strong>KROK 3<\/strong>: Ozna\u010d\u00edme si 11 \u0159\u00e1dk\u016f (v\u00fdstupn\u00edch sloupc\u016f) a p\u0159es tla\u010d\u00edtko Upravit si otev\u0159eme tyto okna (dole bude \u0161ipka na posunut\u00ed).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"791\" height=\"360\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-53.png\" alt=\"\" class=\"wp-image-7742\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-53.png 791w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-53-300x137.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-53-768x350.png 768w\" sizes=\"auto, (max-width: 791px) 100vw, 791px\" \/><\/figure><\/div>\n\n\n\n<p>V jednotliv\u00fdch m\u011bs\u00edc\u00edch zm\u011bn\u00edte t\u0159i \u00fadaje: N\u00e1zev sloupce, pokud v n\u011bm uv\u00e1d\u00edte dan\u00fd m\u011bs\u00edc, Tiskov\u00fd sloupec (zkontrolujte, \u017ee se \u010d\u00edslo zved\u00e1) a M\u011bs\u00edc (op\u011bt bude v\u0161ude 1 a to zm\u011bnit podle dan\u00e9ho m\u011bs\u00edce):<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"793\" height=\"372\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-55.png\" alt=\"\" class=\"wp-image-7744\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-55.png 793w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-55-300x141.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-55-768x360.png 768w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><\/figure><\/div>\n\n\n\n<p>V\u00fdsledek bude n\u00e1sleduj\u00edc\u00ed:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"426\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-57.png\" alt=\"\" class=\"wp-image-7746\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-57.png 794w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-57-300x161.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-57-768x412.png 768w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/figure><\/div>\n\n\n\n<p><strong>KROK 4<\/strong>: P\u0159id\u00e1me sloupec s Celkem &#8211; stoupn\u011bte si na posledn\u00ed \u0159\u00e1dek a klikn\u011bte na Nov\u00fd z\u00e1znam za; pot\u00e9 v Po\u010detn\u00ed operaci najd\u011bte Sou\u010det d\u0159\u00edve spo\u010d\u00edtan\u00fdch sloupc\u016f a ve v\u00fdb\u011bru ozna\u010dte sloupce k se\u010dten\u00ed (v p\u0159\u00edpad\u011b, \u017ee se v\u00e1m neobjev\u00ed posledn\u00ed sloupec &#8211; v na\u0161em p\u0159\u00edpad\u011b prosinec, ozna\u010dte v\u0161echny ostatn\u00ed check boxy, ulo\u017ete a otev\u0159ete \u0159\u00e1dek Celkem p\u0159es Upravit a pot\u00e9 ozna\u010dte i ten posledn\u00ed chyb\u011bj\u00edc\u00ed check box).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"460\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-58.png\" alt=\"\" class=\"wp-image-7747\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-58.png 647w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-58-300x213.png 300w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/figure><\/div>\n\n\n\n<p><strong>KROK 5<\/strong>: Ulo\u017ete celou statistiku tla\u010d\u00edtkem OK.<\/p>\n\n\n\n<p><strong>KROK 6<\/strong>: Sestavu vygenerujete do pracovn\u00edho adres\u00e1\u0159e pomoc\u00ed funkce 11-3-4 a v\u00fdb\u011brem prvn\u00edho m\u011bs\u00edce zpracov\u00e1n\u00ed <img loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"37\" class=\"wp-image-7748\" style=\"\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/hm7.jpg\" alt=\"\"><\/p>\n\n\n\n<p>V\u00fdsledek je pouze vzorek z cel\u00e9ho souboru:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-59.png\" alt=\"\" class=\"wp-image-7749\" width=\"1075\" height=\"203\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-59.png 1812w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-59-300x57.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-59-1024x194.png 1024w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-59-768x145.png 768w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/02\/image-59-1536x291.png 1536w\" sizes=\"auto, (max-width: 1075px) 100vw, 1075px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Znak sumace ve statistik\u00e1ch<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Je zde p\u0159\u00edm\u00e1 n\u00e1vaznost na napln\u011bn\u00e1 pole definice, program d\u00edky t\u011bmto znak\u016fm rozpozn\u00e1 korunov\u00e9 mzdov\u00e9 slo\u017eky, hodinov\u00e9 mzdov\u00e9 slo\u017eky, \u010di \u010d\u00edsla \u0159\u00e1dk\u016f pro matematick\u00e9 operace.<\/li><li>Znak sumace \u0159e\u0161\u00ed t\u0159i v\u00fdznamov\u00e9 okruhy, a to:<\/li><\/ul>\n\n\n\n<p><strong>a) na\u010d\u00edt\u00e1n\u00ed dn\u016f, hodin, korun z p\u0159\u00edslu\u0161n\u00fdch mzdov\u00fdch slo\u017eek (ve v\u0161ech statistik\u00e1ch)<\/strong><\/p>\n\n\n\n<p>sou\u010det hodin<br>sou\u010det korunov\u00fdch mzdov\u00fdch slo\u017eek<br>sou\u010det pracovn\u00edch dn\u016f<br>sou\u010det pracovn\u00edch dn\u016f bez SO + NE (v LZ721 plat\u00ed pouze pro mzd. sl. pro nemoc. d\u00e1vky)<br>sou\u010det pracovn\u00edch hodin bez SO + NE (v LZ721plat\u00ed pouze pro mzd. sl. pro nemoc. d\u00e1vky).<\/p>\n\n\n\n<p><strong>b) matematick\u00e9 operace mezi \u010d\u00edsly (ve v\u0161ech statistik\u00e1ch)<\/strong><\/p>\n\n\n\n<p>sou\u010det d\u0159\u00edve spo\u010d\u00edtan\u00fdch sloupc\u016f (po zad\u00e1n\u00ed t\u00e9to po\u010detn\u00ed operace se n\u00e1m n\u00ed\u017ee otev\u0159e mo\u017enost v\u00fdb\u011bru t\u011bch sloupc\u016f\/\u0159\u00e1dk\u016f, kter\u00e9 chceme se\u010d\u00edst)<br>rozd\u00edl dvou sloupc\u016f\/\u0159\u00e1dk\u016f (zad\u00e1me dv\u011b mzdov\u00e9 slo\u017eky, kter\u00e9 chceme ode\u010d\u00edst)<br>sou\u010din dvou sloupc\u016f\/\u0159\u00e1dk\u016f (n\u00e1sob\u00edm zadan\u00e9 \u0159\u00e1dky)<br>pod\u00edl dvou sloupc\u016f\/\u0159\u00e1dk\u016f (d\u011bl\u00edm zadan\u00e9 \u0159\u00e1dky)<\/p>\n\n\n\n<p><strong>c) znaky pro v\u00fdpo\u010det odvod\u016f na SP, ZP za organizaci (statistika LZ721, nen\u00ed v LZ722)<\/strong><\/p>\n\n\n\n<p>zdravotn\u00ed poji\u0161t\u011bn\u00ed za organizaci (mzdov\u00e9 slo\u017eky se nedopl\u0148uj\u00ed)<br>soci\u00e1ln\u00ed poji\u0161t\u011bn\u00ed za organizaci (mzdov\u00e9 slo\u017eky se nedopl\u0148uj\u00ed)<\/p>\n\n\n\n<p><strong>d) znaky pro z\u00e1po\u010det zam\u011bstnanc\u016f do stavu zam\u011bstnanc\u016f (statistika LZ722 a LZ723, nen\u00ed<\/strong><\/p>\n\n\n\n<p>z\u00e1po\u010det do eviden\u010dn\u00edho stavu<br>z\u00e1po\u010det do p\u0159epo\u010dten\u00e9ho stavu<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">V\u00fdstupy mzdov\u00fdch statistik<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00fdstup mzdov\u00fdch statistik do Pracovn\u00edho adres\u00e1\u0159e (nejv\u00edce pou\u017e\u00edvan\u00e9)<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">V\u017edy mus\u00ed b\u00fdt dan\u00fd m\u011bs\u00edc p\u0159epo\u010d\u00edtan\u00fd<\/mark><\/strong><\/li><li>I kdy\u017e se v\u00e1m vygeneruje v\u00fdsledn\u00e1 statistika do Zpr\u00e1v, pracujte se statistikou <strong>vygenerovanou do Pracovn\u00edho adres\u00e1\u0159e<\/strong>.<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>&nbsp;pro LZ721 (\u0159\u00e1dkov\u00e1 statistika dle kategori\u00ed, definov\u00e1na ve 2-7-2)<\/strong> <ul><li>ve funkci <strong>Mzdy 11-3-1<\/strong> (v Pracovn\u00edm adres\u00e1\u0159i + ve Zpr\u00e1v\u00e1ch).<\/li><\/ul><\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>&nbsp;pro LZ722 (sloupcov\u00e1 po jednotliv\u00fdch zam\u011bstnanc\u00edch, definov\u00e1na ve 2-7-3)<\/strong> <ul><li>ve funkci <strong>Mzdy 11-3-2<\/strong> podle kmenov\u00fdch st\u0159edisek a v Mzdy 11-3-3 podle n\u00e1kladov\u00fdch st\u0159edisek (v Pracovn\u00edm adres\u00e1\u0159i + ve Zpr\u00e1v\u00e1ch).<\/li><\/ul><\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li><strong>\u00a0pro LZ723 (sloupcov\u00e1 po jednotliv\u00fdch zam\u011bstnanc\u00edch s \u010dasov\u00fdm porovn\u00e1n\u00edm, definov\u00e1na ve 2-7-4)<\/strong> <ul><li>ve funkci <strong>Mzdy 11-3-4<\/strong> podle kmenov\u00fdch st\u0159edisek, a v <strong>Mzdy 11-3-5<\/strong> podle n\u00e1kladov\u00fdch st\u0159edisek,<\/li><li>vyb\u00edr\u00e1 se rok zpracov\u00e1n\u00ed a <u>v\u00fdchoz\u00ed<\/u> m\u011bs\u00edc zpracov\u00e1n\u00ed (v Pracovn\u00edm adres\u00e1\u0159i + ve Zpr\u00e1v\u00e1ch).<\/li><\/ul><\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Tisk mzdov\u00fdch statistik do Tiskov\u00fdch zpr\u00e1v<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">V\u017edy mus\u00ed b\u00fdt dan\u00fd m\u011bs\u00edc p\u0159epo\u010d\u00edtan\u00fd<\/mark><\/strong>.<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>\u00a0pro LZ721 (\u0159\u00e1dkov\u00e1 statistika dle kategori\u00ed, definov\u00e1na ve 2-7-2)<\/strong> <ul><li>pro aktu\u00e1ln\u00ed obdob\u00ed vytiskneme ve funkci <strong>Mzdy 8-8-1<\/strong> a tuto statistiku najdeme v tiskov\u00fdch zpr\u00e1v\u00e1ch,<\/li><li>za v\u00edce obdob\u00ed ve funkci <strong>Mzdy 10-6-1<\/strong> a najdeme v tiskov\u00fdch zpr\u00e1v\u00e1ch.<\/li><\/ul><\/li><li><strong>\u00a0pro LZ722 (sloupcov\u00e1 po jednotliv\u00fdch zam\u011bstnanc\u00edch, definov\u00e1na ve 2-7-3)<\/strong> <ul><li>pro aktu\u00e1ln\u00ed obdob\u00ed vytiskneme ve funkci <strong>Mzdy 8-8-2<\/strong> a najdeme v tiskov\u00fdch zpr\u00e1v\u00e1ch,<\/li><li>za v\u00edce obdob\u00ed ve funkci <strong>Mzdy 10-6-3<\/strong>.<\/li><\/ul><\/li><li><strong>\u00a0pro LZ723 (sloupcov\u00e1 po jednotliv\u00fdch zam\u011bstnanc\u00edch s \u010dasov\u00fdm porovn\u00e1n\u00edm, definov\u00e1na ve 2-7-4)<\/strong> <ul><li>pro aktu\u00e1ln\u00ed obdob\u00ed vytiskneme ve funkci <strong>Mzdy 8-8-4<\/strong> a najdeme ji v tiskov\u00fdch zpr\u00e1v\u00e1ch,<\/li><li>za v\u00edce obdob\u00ed ve funkci <strong>Mzdy 10-6-4<\/strong> podle kmenov\u00fdch st\u0159edisek a ve funkci <strong>Mzdy 10-6-5<\/strong> podle n\u00e1kladov\u00fdch st\u0159edisek.<\/li><\/ul><\/li><\/ol>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">V\u00fdb\u011brov\u00e9 krit\u00e9rium ve v\u00fdstupu mzdov\u00fdch statistik<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"366\" height=\"84\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-106.png\" alt=\"\" class=\"wp-image-8005\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-106.png 366w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-106-300x69.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Pokud nechcete v\u00fdb\u011brov\u00e9 krit\u00e9rium pou\u017e\u00edt, neozna\u010dujte \u00fadaj Aktivn\u00ed a v takov\u00e9m p\u0159\u00edpad\u011b statistiky poskytnou data, tedy slo\u017eky v\u0161ech osob a pom\u011br\u016f evidovan\u00e9 a vyplacen\u00e9 v p\u0159\u00edslu\u0161n\u00e9m obdob\u00ed.<\/li><li>Nov\u011b (od roku 2024) je v\u0161ak umo\u017en\u011bno u v\u0161ech typ\u016f statistik aplikovat standardn\u00ed v\u00fdb\u011brov\u00e9 krit\u00e9rium a v\u00fdsledn\u00fd report si omezit dle pot\u0159eby jen na slo\u017eky ur\u010dit\u00e9 skupiny osob nebo pom\u011br\u016f.<\/li><li>M\u016f\u017eete tak vytvo\u0159it vytvo\u0159it statistiky nejen po st\u0159edisc\u00edch a kategori\u00edch, ale tak\u00e9 nap\u0159\u00edklad dle profes\u00ed, lokalit a jak\u00e9hokoli dal\u0161\u00edho atributu, kter\u00fd u sv\u00fdch zam\u011bstnanc\u016f evidujete.<\/li><li>Pro ka\u017edou statistiku si nyn\u00ed m\u016f\u017eete vybrat, zda chcete v\u00fdb\u011brov\u00e9 krit\u00e9rium aplikovat (ponechali jsme mo\u017enost vytv\u00e1\u0159et statistiky i bez filtr\u016f, proto\u017ee pro n\u011bkter\u00e9 p\u0159\u00edpady to st\u00e1le bude vhodn\u011bj\u0161\u00ed) a pokud ano, zda se m\u00e1 filtr aplikovat pro ka\u017ed\u00fd pom\u011br v ka\u017ed\u00e9m zpracov\u00e1van\u00e9m obdob\u00ed, nebo jen dle stavu k rozhodn\u00e9mu obdob\u00ed statistiky (co\u017e je obvykle posledn\u00ed m\u011bs\u00edc).<\/li><li>Budete-li tak zkoumat nap\u0159\u00edklad mzdov\u00e9 n\u00e1klady dle profes\u00ed, m\u016f\u017eete tak z\u00edskat strukturu mezd zam\u011bstnanc\u016f podle toho, v jak\u00e9m povol\u00e1n\u00ed pracuj\u00ed t\u0159eba ke konci roku, nebo strukturu p\u0159esn\u011b tak, jak byla jednotliv\u00fdm povol\u00e1n\u00edm vyplacena v pr\u016fb\u011bhu cel\u00e9ho roku.<\/li><\/ul>\n\n\n\n<p class=\"has-text-align-center\"><em><strong>UPOZORN\u011aN\u00cd<\/strong><\/em>:<\/p>\n\n\n\n<p><strong>!!!V p\u0159\u00edpad\u011b, \u017ee v pr\u016fb\u011bhu roku budete otev\u00edrat nov\u00e9 mzdov\u00e9 slo\u017eky, nezapome\u0148te je p\u0159idat i do mzdov\u00fdch statistik, kter\u00e9 pravideln\u011b pou\u017e\u00edv\u00e1te!!!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mzdov\u00e9 statistiky jsou univerz\u00e1ln\u00edm n\u00e1strojem pro p\u0159\u00edpravu anal\u00fdz mzdov\u00fdch n\u00e1klad\u016f i rozbor\u016f pln\u011bn\u00ed \u010dasov\u00e9ho fondu. Proto\u017ee ka\u017ed\u00e1 spole\u010dnost m\u00e1 odli\u0161n\u00e9 po\u017eadavky, sna\u017e\u00edme se, aby na\u0161e n\u00e1stroje byly, co nejv\u00edce univerz\u00e1ln\u00ed a umo\u017e\u0148ovaly u\u017eivatel\u016fm z\u00edskat, co nejsnadn\u011bji v\u0161echna po\u017eadovan\u00e1 data a pohledy na n\u011b.&nbsp; Statistiky m\u00e1me t\u0159i a ka\u017ed\u00e1 se vytv\u00e1\u0159\u00ed pro jin\u00e9 \u00fa\u010dely. LZ721 je [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"template":"","format":"standard","meta":{"footnotes":""},"lsvr_kba_cat":[77],"lsvr_kba_tag":[271,272,273,167,274,270,275],"class_list":["post-10127","lsvr_kba","type-lsvr_kba","status-publish","format-standard","hentry","lsvr_kba_cat-uzivatelske-sestavy","lsvr_kba_tag-lz721","lsvr_kba_tag-lz722","lsvr_kba_tag-lz723","lsvr_kba_tag-mzdova-statistika","lsvr_kba_tag-priklad-mzdove-statistiky","lsvr_kba_tag-query-se-mzdovou-statistikou","lsvr_kba_tag-statistika"],"_links":{"self":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/10127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba"}],"about":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/types\/lsvr_kba"}],"author":[{"embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":6,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/10127\/revisions"}],"predecessor-version":[{"id":10757,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/10127\/revisions\/10757"}],"wp:attachment":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/media?parent=10127"}],"wp:term":[{"taxonomy":"lsvr_kba_cat","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba_cat?post=10127"},{"taxonomy":"lsvr_kba_tag","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba_tag?post=10127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}