INSERT INTO `zamestnanci_na_projektu_smazane` (`id`, `id_projektu`, `nakladove_stredisko`, `prefix_fis`, `fis_projektu`, `komplexni_polozka`, `nazev_projektu`, `login_zamestnance`, `na_projektu_od`, `na_projektu_do`, `uvazek_na_projektu`, `mzdova_trida`, `stupen`, `mzdovy_tarif`, `osobni_priplatek`, `projektovy_priplatek`, `priplatek`, `hruba_mzda`, `hruba_mzda_bez_priplatku`, `superhruba_mzda`, `superhruba_a_soc_fond`, `hruba_mzda_FTE`, `funkce`, `kmenova_zakazka`, `priznak`, `mzdovy_limit_kategorie`, `mzdovy_limit_castka`, `preuctovani`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(9408, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'hejtmpet', '2023-11-01', '2038-12-30', '0.60', 'A3', 0, 18600, 21570, 0, 0, 40170, 40170, 53747, 54149, 66950, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6732', '1', 'W-6759', '0000-00-00', '0000-00-00'),
(9440, 279, '36216', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'vlasabar', '2023-11-01', '2038-12-30', '0.55', '6', 0, 13750, 14575, 0, 0, 28325, 28325, 37899, 38182, 51500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6737', '1', 'W-6760', '0000-00-00', '0000-00-00'),
(9441, 353, '36216', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'vlasabar', '2023-11-01', '2038-12-30', '0.05', '6', 0, 1250, 1325, 0, 0, 2575, 2575, 3445, 3471, 51500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6737', '2', 'W-6760', '0000-00-00', '0000-00-00'),
(9442, 387, '36216', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'vlasabar', '2023-11-01', '2038-12-30', '0.40', '6', 0, 10000, 10600, 0, 0, 20600, 20600, 27563, 27769, 51500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6737', '3', 'W-6760', '0000-00-00', '0000-00-00'),
(9447, 74, '36212', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'malikzd1', '2023-11-01', '2038-12-30', '0.10', 'A3', 0, 2481, 2579, 0, 0, 5060, 5060, 6770, 6821, 50600, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6739', '1', 'W-6758', '0000-00-00', '0000-00-00'),
(9448, 208, '36212', '604', '6042201V000', '1ND', 'H2020 - ARV', 'malikzd1', '2023-11-01', '2038-12-30', '0.65', 'A3', 0, 16127, 16764, 0, 0, 32890, 32890, 44007, 44336, 50600, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6739', '2', 'W-6758', '0000-00-00', '0000-00-00'),
(9498, 112, '36251', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'vcelakj1', '2023-11-01', '2038-12-30', '0.01', '7', 0, 277, 624, 200, 0, 1100, 900, 1472, 1483, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6727', '1', 'W-6757', '0000-00-00', '0000-00-00'),
(9499, 250, '36251', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'vcelakj1', '2023-11-01', '2038-12-30', '0.39', '7', 0, 10784, 24317, 7800, 0, 42900, 35100, 57400, 57829, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6727', '2', 'W-6757', '0000-00-00', '0000-00-00'),
(9500, 145, '36251', '312', '3122103V000', '1ND', 'TAČR DOPRAVA - SOMKo', 'vcelakj1', '2023-11-01', '2038-12-30', '0.40', '7', 0, 11060, 24940, 8000, 0, 44000, 36000, 58872, 59312, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6727', '3', 'W-6757', '0000-00-00', '0000-00-00'),
(9501, 385, '36251', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vcelakj1', '2023-11-01', '2038-12-30', '0.20', '7', 0, 5530, 12470, 4000, 0, 22000, 18000, 29436, 29656, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6727', '4', 'W-6757', '0000-00-00', '0000-00-00'),
(9526, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'pavlija5', '2023-11-01', '2038-12-30', '0.05', '6', 0, 1241, 1760, 0, 0, 3000, 3000, 4014, 4044, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6752', '1', 'W-6761', '0000-00-00', '0000-00-00'),
(9527, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'pavlija5', '2023-11-01', '2038-12-30', '0.05', '6', 0, 1241, 1760, 0, 0, 3000, 3000, 4014, 4044, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6752', '2', 'W-6761', '0000-00-00', '0000-00-00'),
(9528, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'pavlija5', '2023-11-01', '2038-12-30', '0.45', '6', 0, 11165, 15836, 0, 0, 27000, 27000, 36126, 36396, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6752', '3', 'W-6761', '0000-00-00', '0000-00-00'),
(9529, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'pavlija5', '2023-11-01', '2038-12-30', '0.20', '6', 0, 4962, 7038, 0, 0, 12000, 12000, 16056, 16176, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6752', '4', 'W-6761', '0000-00-00', '0000-00-00'),
(9530, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'pavlija5', '2023-11-01', '2038-12-30', '0.25', '6', 0, 6203, 8798, 0, 0, 15000, 15000, 20070, 20220, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6752', '5', 'W-6761', '0000-00-00', '0000-00-00'),
(9535, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'suchndan', '2023-11-01', '2038-12-30', '0.20', '6', 0, 4962, 6838, 0, 0, 11800, 11800, 15788, 15906, 59000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6754', '1', 'W-6762', '0000-00-00', '0000-00-00'),
(9536, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'suchndan', '2023-11-01', '2038-12-30', '0.10', '6', 0, 2481, 3419, 0, 0, 5900, 5900, 7894, 7953, 59000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6754', '2', 'W-6762', '0000-00-00', '0000-00-00'),
(9537, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'suchndan', '2023-11-01', '2038-12-30', '0.25', '6', 0, 6203, 8548, 0, 0, 14750, 14750, 19736, 19883, 59000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6754', '3', 'W-6762', '0000-00-00', '0000-00-00'),
(9538, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'suchndan', '2023-11-01', '2038-12-30', '0.10', '6', 0, 2481, 3419, 0, 0, 5900, 5900, 7894, 7953, 59000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6754', '4', 'W-6762', '0000-00-00', '0000-00-00'),
(9539, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'suchndan', '2023-11-01', '2038-12-30', '0.20', '6', 0, 4962, 6838, 0, 0, 11800, 11800, 15788, 15906, 59000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6754', '5', 'W-6762', '0000-00-00', '0000-00-00'),
(9540, 452, '36222', '398', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'suchndan', '2023-11-01', '2038-12-30', '0.15', '6', 0, 3722, 5129, 0, 0, 8850, 8850, 11841, 11930, 59000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6754', '6', 'W-6762', '0000-00-00', '0000-00-00'),
(9542, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'vodicvac', '2023-11-01', '2038-12-30', '0.20', '7', 0, 5532, 6668, 0, 0, 12200, 12200, 16324, 16446, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6755', '1', 'W-6763', '0000-00-00', '0000-00-00'),
(9543, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'vodicvac', '2023-11-01', '2038-12-30', '0.20', '7', 0, 5532, 6668, 0, 0, 12200, 12200, 16324, 16446, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6755', '2', 'W-6763', '0000-00-00', '0000-00-00'),
(9544, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'vodicvac', '2023-11-01', '2038-12-30', '0.25', '7', 0, 6915, 8335, 0, 0, 15250, 15250, 20405, 20557, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6755', '3', 'W-6763', '0000-00-00', '0000-00-00'),
(9545, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'vodicvac', '2023-11-01', '2038-12-30', '0.05', '7', 0, 1383, 1667, 0, 0, 3050, 3050, 4081, 4111, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6755', '4', 'W-6763', '0000-00-00', '0000-00-00'),
(9546, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'vodicvac', '2023-11-01', '2038-12-30', '0.15', '7', 0, 4149, 5001, 0, 0, 9150, 9150, 12243, 12334, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6755', '5', 'W-6763', '0000-00-00', '0000-00-00'),
(9547, 452, '36222', '314', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'vodicvac', '2023-11-01', '2038-12-30', '0.15', '7', 0, 4149, 5001, 0, 0, 9150, 9150, 12243, 12334, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6755', '7', 'W-6763', '0000-00-00', '0000-00-00'),
(9548, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'zelenzby', '2023-11-01', '2038-12-30', '0.05', '6', 0, 1241, 1859, 0, 0, 3100, 3100, 4148, 4179, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6756', '1', 'W-6764', '0000-00-00', '0000-00-00'),
(9549, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'zelenzby', '2023-11-01', '2038-12-30', '0.15', '6', 0, 3723, 5577, 0, 0, 9300, 9300, 12443, 12536, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6756', '2', 'W-6764', '0000-00-00', '0000-00-00'),
(9550, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'zelenzby', '2023-11-01', '2038-12-30', '0.05', '6', 0, 1241, 1859, 0, 0, 3100, 3100, 4148, 4179, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6756', '3', 'W-6764', '0000-00-00', '0000-00-00'),
(9551, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'zelenzby', '2023-11-01', '2038-12-30', '0.20', '6', 0, 4964, 7436, 0, 0, 12400, 12400, 16591, 16715, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6756', '4', 'W-6764', '0000-00-00', '0000-00-00'),
(9552, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'zelenzby', '2023-11-01', '2038-12-30', '0.30', '6', 0, 7446, 11154, 0, 0, 18600, 18600, 24887, 25073, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6756', '5', 'W-6764', '0000-00-00', '0000-00-00'),
(9553, 452, '36222', '314', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'zelenzby', '2023-11-01', '2038-12-30', '0.25', '6', 0, 6205, 9295, 0, 0, 15500, 15500, 20739, 20894, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6756', '6', 'W-6764', '0000-00-00', '0000-00-00'),
(9598, 242, '36255', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'kuzvalen', '2023-12-01', '2024-12-31', '0.10', '6', 0, 2481, 1519, 0, 0, 4000, 4000, 5352, 5392, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6705', '1', 'W-6858', '0000-00-00', '0000-00-00'),
(9599, 267, '36255', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'kuzvalen', '2023-12-01', '2024-12-31', '0.20', '6', 0, 4962, 3038, 0, 0, 8000, 8000, 10704, 10784, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6705', '2', 'W-6858', '0000-00-00', '0000-00-00'),
(9600, 263, '36255', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kuzvalen', '2023-12-01', '2024-12-31', '0.30', '6', 0, 7443, 4557, 0, 0, 12000, 12000, 16056, 16176, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6705', '3', 'W-6858', '0000-00-00', '0000-00-00'),
(9620, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'jararobe', '2024-01-01', '2038-12-30', '0.70', 'A3', 0, 38500, 46375, 0, 18000, 102875, 84875, 137647, 138676, 121250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6774', '1', 'W-6847', '0000-00-00', '0000-00-00'),
(9621, 385, '36910', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'jararobe', '2024-01-01', '2038-12-30', '0.10', 'A3', 0, 5500, 6625, 0, 0, 12125, 12125, 16223, 16345, 121250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6774', '2', 'W-6847', '0000-00-00', '0000-00-00'),
(9638, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2024-01-01', '2038-12-30', '0.55', '6', 0, 14328, 12622, 0, 0, 26950, 26950, 36059, 36329, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6781', '1', 'W-6942', '0000-00-00', '0000-00-00'),
(9639, 167, '36920', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stoladan', '2024-01-01', '2038-12-30', '0.05', '6', 0, 1303, 1147, 0, 0, 2450, 2450, 3278, 3303, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6781', '2', 'W-6942', '0000-00-00', '0000-00-00'),
(9640, 385, '36920', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'stoladan', '2024-01-01', '2038-12-30', '0.20', '6', 0, 5210, 4590, 0, 0, 9800, 9800, 13112, 13210, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6781', '3', 'W-6942', '0000-00-00', '0000-00-00'),
(9641, 387, '36920', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'stoladan', '2024-01-01', '2038-12-30', '0.20', '6', 0, 5210, 4590, 0, 0, 9800, 9800, 13112, 13210, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6781', '4', 'W-6942', '0000-00-00', '0000-00-00'),
(9642, 128, '36910', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'lupisant', '2024-01-01', '2038-12-30', '0.19', 'A4', 0, 12350, 11856, 0, 0, 24206, 24206, 32388, 32630, 127400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6782', '1', 'W-7138', '0000-00-00', '0000-00-00'),
(9643, 208, '36910', '604', '6042201V000', '1ND', 'H2020 - ARV', 'lupisant', '2024-01-01', '2038-12-30', '0.20', 'A4', 0, 13000, 12480, 0, 0, 25480, 25480, 34092, 34347, 127400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6782', '2', 'W-7138', '0000-00-00', '0000-00-00'),
(9644, 91, '36910', '888', '8889701V000', '9NN', 'Režie - ostatní', 'lupisant', '2024-01-01', '2038-12-30', '0.41', 'A4', 0, 26650, 25584, 0, 0, 52234, 52234, 69889, 70411, 127400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6782', '3', 'W-7138', '0000-00-00', '0000-00-00'),
(9645, 387, '36910', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'lupisant', '2024-01-01', '2038-12-30', '0.10', 'A4', 0, 6500, 6240, 0, 0, 12740, 12740, 17046, 17174, 127400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6782', '4', 'W-7138', '0000-00-00', '0000-00-00'),
(9657, 275, '36212', '312', '3122105A132', '1ND', 'TAČR TREND - REWAGYPS (Staněk)', 'stanekam', '2024-01-01', '2038-12-30', '0.20', 'A3', 0, 6200, 6800, 0, 0, 13000, 13000, 17394, 17524, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6800', '1', 'W-6959', '0000-00-00', '0000-00-00'),
(9658, 112, '36212', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'stanekam', '2024-01-01', '2038-12-30', '0.40', 'A3', 0, 12400, 13600, 0, 0, 26000, 26000, 34788, 35048, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6800', '2', 'W-6959', '0000-00-00', '0000-00-00'),
(9659, 112, '36212', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'sojkokat', '2024-01-01', '2038-12-30', '0.80', 'A3', 0, 24800, 17200, 0, 0, 42000, 42000, 56196, 56616, 52500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6801', '1', 'W-6958', '0000-00-00', '0000-00-00'),
(9660, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'buresmi4', '2024-01-01', '2038-12-30', '0.20', '6', 0, 4962, 4908, 0, 0, 9870, 9870, 13206, 13305, 49350, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6802', '1', 'W-6948', '0000-00-00', '0000-00-00'),
(9683, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'zelenzby', '2023-12-01', '2038-12-30', '0.10', '6', 0, 3300, 2900, 0, 0, 6200, 6200, 8296, 8358, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6807', '1', 'W-6831', '0000-00-00', '0000-00-00'),
(9684, 90, '36222', '312', '3122002V000', '1ND', 'TAČR THETA III Data4energy', 'zelenzby', '2023-12-01', '2038-12-30', '0.25', '6', 0, 8250, 7250, 0, 0, 15500, 15500, 20739, 20894, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6807', '2', 'W-6831', '0000-00-00', '0000-00-00'),
(9685, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'zelenzby', '2023-12-01', '2038-12-30', '0.05', '6', 0, 1650, 1450, 0, 0, 3100, 3100, 4148, 4179, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6807', '3', 'W-6831', '0000-00-00', '0000-00-00'),
(9686, 232, '36222', '311', '3112203V000', '1ND', 'TAČR THETA IV - tribo-RVE (Šlechta)', 'zelenzby', '2023-12-01', '2038-12-30', '0.20', '6', 0, 6600, 5800, 0, 0, 12400, 12400, 16591, 16715, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6807', '4', 'W-6831', '0000-00-00', '0000-00-00'),
(9687, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'zelenzby', '2023-12-01', '2038-12-30', '0.15', '6', 0, 4950, 4350, 0, 0, 9300, 9300, 12443, 12536, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6807', '5', 'W-6831', '0000-00-00', '0000-00-00'),
(9688, 452, '36222', '314', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'zelenzby', '2023-12-01', '2038-12-30', '0.25', '6', 0, 8250, 7250, 0, 0, 15500, 15500, 20739, 20894, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6807', '6', 'W-6831', '0000-00-00', '0000-00-00'),
(9690, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'beckajir', '2024-01-01', '2025-12-31', '0.20', '6', 0, 4962, 2638, 0, 0, 7600, 7600, 10169, 10245, 38000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6809', '1', 'W-6947', '0000-00-00', '0000-00-00'),
(9718, 199, '36213', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vancuto4', '2023-12-01', '2024-12-31', '0.10', '6', 0, 2500, 1700, 0, 0, 4200, 4200, 5620, 5662, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6814', '1', 'W-6838', '0000-00-00', '0000-00-00'),
(9719, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vancuto4', '2023-12-01', '2024-12-31', '0.70', '6', 0, 17500, 11900, 0, 0, 29400, 29400, 39337, 39631, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6814', '2', 'W-6838', '0000-00-00', '0000-00-00'),
(9723, 225, '36241', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'ptacepe4', '2024-01-01', '2038-12-30', '0.10', '7', 0, 2765, 2635, 0, 0, 5400, 5400, 7225, 7279, 54000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6815', '1', 'W-6926', '0000-00-00', '0000-00-00'),
(9727, 225, '36241', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'brandrad', '2024-01-01', '2038-12-30', '0.10', '7', 0, 2765, 2235, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6821', '1', 'W-6924', '0000-00-00', '0000-00-00'),
(9729, 468, '36216', '606', '6062304V003', '1ND', 'NBSINFRA HE-Sněhota - WP3', 'feliclic', '2024-01-01', '2024-12-31', '0.75', '6', 0, 18608, 15143, 0, 0, 33750, 33750, 45158, 45495, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6808', '1', 'W-6949', '0000-00-00', '0000-00-00'),
(9732, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'spaleja1', '2023-07-01', '2023-07-31', '0.05', '6', 0, 1241, 1259, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-6826', '1', 'W-6827', '0000-00-00', '0000-00-00'),
(9733, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'spaleja1', '2023-07-01', '2023-07-31', '0.05', '6', 0, 1241, 1259, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-6826', '2', 'W-6827', '0000-00-00', '0000-00-00'),
(9734, 231, '36222', '312', '3122201V000', '1ND', 'TAČR THETA IV - COGEN mikroKVET_CZ', 'spaleja1', '2023-07-01', '2023-07-31', '0.15', '6', 0, 3723, 3777, 0, 0, 7500, 7500, 10035, 10110, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-6826', '3', 'W-6827', '0000-00-00', '0000-00-00'),
(9735, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'spaleja1', '2023-07-01', '2023-07-31', '0.35', '6', 0, 8687, 8813, 0, 0, 17500, 17500, 23415, 23590, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-6826', '4', 'W-6827', '0000-00-00', '0000-00-00'),
(9761, 201, '36261', '894', '8941501V906', '1NE', 'Mzdový Fond RP6', 'novotp17', '2024-01-01', '2038-12-30', '0.10', '6', 0, 2107, 695, 0, 0, 2802, 2802, 3749, 3777, 28020, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6835', '1', 'W-6896', '0000-00-00', '0000-00-00'),
(9769, 250, '36242', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'prosezde', '2024-01-01', '2024-12-31', '0.10', '5', 0, 3900, 2100, 0, 0, 6000, 6000, 8028, 8088, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6840', '1', 'W-6928', '0000-00-00', '0000-00-00'),
(9771, 250, '36242', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'svorapet', '2024-01-01', '2038-12-30', '0.10', '6', 0, 2481, 1716, 0, 0, 4197, 4197, 5616, 5658, 41966, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6842', '1', 'W-6927', '0000-00-00', '0000-00-00'),
(9772, 74, '36214', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'volfmar3', '2023-12-01', '2038-12-30', '0.01', 'A3', 0, 423, 401, 56, 0, 880, 824, 1177, 1186, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '1', 'W-6868', '0000-00-00', '0000-00-00'),
(9773, 208, '36214', '604', '6042201V000', '1ND', 'H2020 - ARV', 'volfmar3', '2023-12-01', '2038-12-30', '0.04', 'A3', 0, 1692, 1604, 222, 0, 3518, 3296, 4707, 4742, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '2', 'W-6868', '0000-00-00', '0000-00-00'),
(9774, 407, '36214', '113', '1132305V000', '1ND', 'UNILEAD II. MŠMT CRP 2023 - Železná', 'volfmar3', '2023-12-01', '2038-12-30', '0.27', 'A3', 0, 11421, 10827, 1500, 0, 23748, 22248, 31775, 32012, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '3', 'W-6868', '0000-00-00', '0000-00-00'),
(9775, 365, '36214', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'volfmar3', '2023-12-01', '2038-12-30', '0.04', 'A3', 0, 1692, 1604, 222, 0, 3518, 3296, 4707, 4742, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '4', 'W-6868', '0000-00-00', '0000-00-00'),
(9776, 353, '36214', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'volfmar3', '2023-12-01', '2038-12-30', '0.27', 'A3', 0, 11421, 10827, 1500, 0, 23748, 22248, 31775, 32012, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '5', 'W-6868', '0000-00-00', '0000-00-00'),
(9777, 225, '36214', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'volfmar3', '2023-12-01', '2038-12-30', '0.12', 'A3', 0, 5076, 4812, 667, 0, 10555, 9888, 14123, 14228, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '6', 'W-6868', '0000-00-00', '0000-00-00'),
(9778, 332, '36214', '604', '6042201A133', '1ND', 'Probono H2020 - Tencar', 'volfmar3', '2023-12-01', '2038-12-30', '0.15', 'A3', 0, 6345, 6015, 833, 0, 13193, 12360, 17652, 17784, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6843', '7', 'W-6868', '0000-00-00', '0000-00-00'),
(9779, 304, '36254', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'zelenva2', '2023-12-01', '2024-02-29', '0.40', '6', 0, 10476, 7124, 1600, 0, 19200, 17600, 25690, 25882, 44000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6844', '1', 'W-6859', '0000-00-00', '0000-00-00'),
(9780, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'zelenva2', '2023-12-01', '2024-02-29', '0.40', '6', 0, 10476, 7124, 1600, 0, 19200, 17600, 25690, 25882, 44000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6844', '2', 'W-6859', '0000-00-00', '0000-00-00'),
(9781, 311, '36254', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'zelenva2', '2023-12-01', '2024-02-29', '0.20', '6', 0, 5238, 3562, 800, 0, 9600, 8800, 12845, 12941, 44000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6844', '3', 'W-6859', '0000-00-00', '0000-00-00'),
(9782, 167, '36216', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'sykorma6', '2023-12-01', '2023-12-31', '0.30', '6', 0, 7443, 7362, 0, 0, 14805, 14805, 19809, 19957, 49350, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6845', '1', 'W-7690', '2023-12-01', '2038-12-30'),
(9894, 112, '36251', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'vcelakj1', '2024-01-01', '2038-12-30', '0.01', '7', 0, 550, 350, 200, 0, 1100, 900, 1472, 1483, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6867', '1', 'W-6914', '0000-00-00', '0000-00-00'),
(9895, 250, '36251', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'vcelakj1', '2024-01-01', '2038-12-30', '0.19', '7', 0, 10450, 6650, 3800, 0, 20900, 17100, 27964, 28173, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6867', '2', 'W-6914', '0000-00-00', '0000-00-00'),
(9896, 145, '36251', '312', '3122103V000', '1ND', 'TAČR DOPRAVA - SOMKo', 'vcelakj1', '2024-01-01', '2038-12-30', '0.30', '7', 0, 16500, 10500, 6000, 0, 33000, 27000, 44154, 44484, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6867', '3', 'W-6914', '0000-00-00', '0000-00-00'),
(9897, 385, '36251', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vcelakj1', '2024-01-01', '2038-12-30', '0.50', '7', 0, 27500, 17500, 10000, 0, 55000, 45000, 73590, 74140, 90000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6867', '4', 'W-6914', '0000-00-00', '0000-00-00'),
(9943, 302, '36211', '606', '6062303V000', '1ND', 'CIRC-BOOST HE - Pavlů', 'pavluter', '2024-01-01', '2038-12-30', '0.30', 'A3', 0, 12000, 10950, 0, 0, 22950, 22950, 30707, 30937, 76500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6870', '1', 'W-6970', '0000-00-00', '0000-00-00'),
(9944, 279, '36211', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'pavluter', '2024-01-01', '2038-12-30', '0.30', 'A3', 0, 12000, 10950, 0, 0, 22950, 22950, 30707, 30937, 76500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6870', '3', 'W-6970', '0000-00-00', '0000-00-00'),
(9945, 387, '36211', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'pavluter', '2024-01-01', '2038-12-30', '0.30', 'A3', 0, 12000, 10950, 0, 0, 22950, 22950, 30707, 30937, 76500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6870', '4', 'W-6970', '0000-00-00', '0000-00-00'),
(9959, 128, '36216', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'veselj30', '2024-01-01', '2024-01-31', '0.01', '6', 0, 281, 214, 0, 0, 494, 494, 661, 666, 49440, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6877', '1', 'W-6963', '0000-00-00', '0000-00-00'),
(9960, 387, '36216', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'veselj30', '2024-01-01', '2024-01-31', '0.79', '6', 0, 22177, 16880, 0, 0, 39058, 39058, 52260, 52650, 49440, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6877', '2', 'W-6963', '0000-00-00', '0000-00-00'),
(9961, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'hodkojul', '2024-01-01', '2038-12-30', '0.01', '7', 0, 330, 319, 0, 0, 649, 649, 868, 875, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6878', '1', 'W-6968', '0000-00-00', '0000-00-00'),
(9962, 407, '36216', '113', '1132305V000', '1ND', 'UNILEAD II. MŠMT CRP 2023 - Železná', 'hodkojul', '2024-01-01', '2038-12-30', '0.05', '7', 0, 1650, 1595, 0, 0, 3245, 3245, 4342, 4374, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6878', '2', 'W-6968', '0000-00-00', '0000-00-00'),
(9963, 353, '36216', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'hodkojul', '2024-01-01', '2038-12-30', '0.94', '7', 0, 31020, 29977, 0, 0, 60997, 60997, 81614, 82224, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6878', '3', 'W-6968', '0000-00-00', '0000-00-00'),
(9999, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'zuzansch', '2024-01-01', '2038-12-30', '0.50', '6', 0, 12405, 10845, 0, 0, 23250, 23250, 31109, 31341, 46500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6893', '1', 'W-6943', '0000-00-00', '0000-00-00'),
(10000, 230, '36920', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'zuzansch', '2024-01-01', '2038-12-30', '0.14', '6', 0, 3473, 3037, 0, 0, 6510, 6510, 8710, 8775, 46500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6893', '2', 'W-6943', '0000-00-00', '0000-00-00'),
(10001, 225, '36920', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'zuzansch', '2024-01-01', '2038-12-30', '0.22', '6', 0, 5458, 4772, 0, 0, 10230, 10230, 13688, 13790, 46500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6893', '3', 'W-6943', '0000-00-00', '0000-00-00'),
(10002, 423, '36920', '311', '3112401V000', '1ND', 'LIWEPLAS TAČR Sigma DC2 - Hataj', 'zuzansch', '2024-01-01', '2038-12-30', '0.14', '6', 0, 3473, 3037, 0, 0, 6510, 6510, 8710, 8775, 46500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6893', '4', 'W-6943', '0000-00-00', '0000-00-00'),
(10091, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'rutovmar', '2024-01-01', '2024-12-31', '0.15', '6', 0, 3722, 2954, 0, 0, 6675, 6675, 8931, 8998, 44500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6923', '1', 'W-6945', '0000-00-00', '0000-00-00'),
(10092, 310, '36920', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'rutovmar', '2024-01-01', '2024-12-31', '0.50', '6', 0, 12405, 9845, 0, 0, 22250, 22250, 29771, 29993, 44500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6923', '2', 'W-6945', '0000-00-00', '0000-00-00'),
(10093, 496, '36920', '311', '3112402V000', '1ND', 'Dukovany TaČR Beta Bittnar', 'rutovmar', '2024-01-01', '2024-12-31', '0.35', '6', 0, 8684, 6891, 0, 0, 15575, 15575, 20839, 20995, 44500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6923', '3', 'W-6945', '0000-00-00', '0000-00-00'),
(10112, 423, '36241', '311', '3112401V000', '1ND', 'LIWEPLAS TAČR Sigma DC2 - Hataj', 'postajan', '2024-01-01', '2024-01-31', '0.05', '7', 0, 1750, 1250, 0, 0, 3000, 3000, 4014, 4044, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6935', '1', 'W-7700', '2024-01-01', '2038-12-30'),
(10113, 225, '36241', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'postajan', '2024-01-01', '2024-01-31', '0.10', '7', 0, 3500, 2500, 0, 1000, 7000, 6000, 9366, 9436, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6935', '2', 'W-7700', '2024-01-01', '2038-12-30'),
(10114, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'postajan', '2024-01-01', '2024-01-31', '0.25', '7', 0, 8750, 6250, 0, 1000, 16000, 15000, 21408, 21568, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6935', '3', 'W-7700', '2024-01-01', '2038-12-30'),
(10115, 202, '36241', '894', '8941501V904', '1NE', 'Mzdový Fond RP4', 'postajan', '2024-01-01', '2024-01-31', '0.60', '7', 0, 21000, 15000, 0, 3000, 39000, 36000, 52182, 52572, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6935', '4', 'W-7700', '2024-01-01', '2038-12-30'),
(10233, 208, '36217', '604', '6042201V000', '1ND', 'H2020 - ARV', 'hodekdra', '2024-01-01', '2024-02-29', '0.20', '4', 0, 4302, 3678, 0, 0, 7980, 7980, 10677, 10757, 39900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6952', '1', 'W-7154', '2024-01-01', '2038-12-30'),
(10234, 199, '36217', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'hodekdra', '2024-01-01', '2024-02-29', '0.20', '4', 0, 4302, 3678, 0, 0, 7980, 7980, 10677, 10757, 39900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6952', '2', 'W-7154', '2024-01-01', '2038-12-30'),
(10235, 128, '36217', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'hodekdra', '2024-01-01', '2024-02-29', '0.40', '4', 0, 8604, 7356, 0, 0, 15960, 15960, 21354, 21514, 39900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6952', '3', 'W-7154', '2024-01-01', '2038-12-30'),
(10236, 225, '36217', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodekdra', '2024-01-01', '2024-02-29', '0.05', '4', 0, 1076, 920, 0, 0, 1995, 1995, 2669, 2689, 39900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6952', '4', 'W-7154', '2024-01-01', '2038-12-30'),
(10237, 320, '36217', '301', '3012214A143', '1ND', 'Vícevrstvy GAČR - FSv Sněhota', 'hodekdra', '2024-01-01', '2024-02-29', '0.15', '4', 0, 3227, 2759, 0, 0, 5985, 5985, 8008, 8068, 39900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6952', '5', 'W-7154', '2024-01-01', '2038-12-30'),
(10258, 199, '36217', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vitovjan', '2024-01-01', '2024-02-29', '0.75', '6', 0, 18610, 17615, 0, 0, 36225, 36225, 48469, 48831, 48300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6964', '1', 'W-7155', '2024-01-01', '2038-12-30'),
(10259, 128, '36217', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'vitovjan', '2024-01-01', '2024-02-29', '0.20', '6', 0, 4963, 4697, 0, 0, 9660, 9660, 12925, 13022, 48300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6964', '2', 'W-7155', '2024-01-01', '2038-12-30'),
(10260, 225, '36217', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'vitovjan', '2024-01-01', '2024-02-29', '0.05', '6', 0, 1241, 1174, 0, 0, 2415, 2415, 3231, 3255, 48300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6964', '3', 'W-7155', '2024-01-01', '2038-12-30'),
(10264, 199, '36214', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'volfmar3', '2024-01-01', '2024-02-29', '0.33', 'A3', 0, 13959, 13233, 0, 1833, 29025, 27192, 38835, 39126, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6966', '1', 'W-7152', '2024-01-01', '2038-12-30'),
(10265, 365, '36214', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'volfmar3', '2024-01-01', '2024-02-29', '0.21', 'A3', 0, 8883, 8421, 0, 1167, 18471, 17304, 24714, 24899, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6966', '2', 'W-7152', '2024-01-01', '2038-12-30'),
(10266, 225, '36214', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'volfmar3', '2024-01-01', '2024-02-29', '0.05', 'A3', 0, 2115, 2005, 0, 278, 4398, 4120, 5885, 5929, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6966', '3', 'W-7152', '2024-01-01', '2038-12-30'),
(10267, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'volfmar3', '2024-01-01', '2024-02-29', '0.04', 'A3', 0, 1692, 1604, 0, 222, 3518, 3296, 4707, 4742, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6966', '4', 'W-7152', '2024-01-01', '2038-12-30'),
(10268, 353, '36216', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'volfmar3', '2024-01-01', '2024-02-29', '0.27', 'A3', 0, 11421, 10827, 0, 1500, 23748, 22248, 31775, 32012, 82400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6966', '5', 'W-7152', '2024-01-01', '2038-12-30'),
(10271, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'hodkojul', '2024-01-01', '2024-02-29', '0.01', '7', 0, 330, 319, 0, 0, 649, 649, 868, 875, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6968', '1', 'W-7153', '2024-01-01', '2038-12-30'),
(10272, 353, '36216', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'hodkojul', '2024-01-01', '2024-02-29', '0.94', '7', 0, 31015, 29981, 0, 0, 60997, 60997, 81614, 82224, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6968', '2', 'W-7153', '2024-01-01', '2038-12-30'),
(10273, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'hodkojul', '2024-01-01', '2024-02-29', '0.05', '7', 0, 1650, 1595, 0, 0, 3245, 3245, 4342, 4374, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6968', '3', 'W-7153', '2024-01-01', '2038-12-30'),
(10343, 388, '36231', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'maierlen', '2024-01-01', '2038-12-30', '0.30', 'A3', 0, 9300, 6600, 0, 0, 15900, 15900, 21274, 21433, 53000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6975', '1', 'W-7716', '0000-00-00', '0000-00-00'),
(10344, 260, '36231', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'maierlen', '2024-01-01', '2038-12-30', '0.20', 'A3', 0, 6200, 4400, 0, 0, 10600, 10600, 14183, 14289, 53000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6975', '2', 'W-7716', '0000-00-00', '0000-00-00'),
(10347, 372, '36231', '554', '5542301V000', '1ND', 'ROD-Decont OP TAK Aplikace I', 'knymarti', '2024-01-01', '2024-03-31', '0.20', '7', 0, 5530, 5070, 0, 1000, 11600, 10600, 15521, 15637, 53000, '', 'ne', 'ne', 'B10', 64130, 0, 1, 'W-6976', '1', 'W-7718', '2024-01-01', '2038-12-30'),
(10348, 112, '36231', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'knymarti', '2024-01-01', '2024-03-31', '0.04', '7', 0, 1106, 1014, 0, 200, 2320, 2120, 3104, 3127, 53000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6976', '2', 'W-7718', '2024-01-01', '2038-12-30'),
(10349, 388, '36231', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'knymarti', '2024-01-01', '2024-03-31', '0.10', '7', 0, 2765, 2535, 0, 500, 5800, 5300, 7760, 7818, 53000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6976', '3', 'W-7718', '2024-01-01', '2038-12-30'),
(10350, 260, '36231', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'knymarti', '2024-01-01', '2024-03-31', '0.66', '7', 0, 18249, 16731, 0, 3300, 38280, 34980, 51219, 51601, 53000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6976', '4', 'W-7718', '2024-01-01', '2038-12-30'),
(10405, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vancuto4', '2024-01-01', '2024-01-31', '0.20', '6', 0, 5000, 3400, 0, 0, 8400, 8400, 11239, 11323, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6962', '1', 'W-7705', '2024-01-01', '2024-12-31'),
(10406, 199, '36213', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vancuto4', '2024-01-01', '2024-01-31', '0.60', '6', 0, 15000, 10200, 0, 0, 25200, 25200, 33718, 33970, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-6962', '2', 'W-7705', '2024-01-01', '2024-12-31'),
(10410, 495, '36256', '554', '5542401V000', '1ND', 'CEBIA Dron OP TAK Aplikace I', 'XXXtmpXXXjirinmar', '2024-01-01', '2024-12-31', '0.10', 'A4', 0, 6000, 3800, 0, 0, 9800, 9800, 13112, 13210, 98000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7002', '1', 'W-7011', '0000-00-00', '0000-00-00'),
(10413, 495, '36256', '554', '5542401V000', '1ND', 'CEBIA Dron OP TAK Aplikace I', 'XXXtmpXXXpilardan', '2024-01-01', '2024-12-31', '0.50', '5', 0, 17000, 15500, 0, 0, 32500, 32500, 43485, 43810, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7005', '1', 'W-7027', '0000-00-00', '0000-00-00'),
(10414, 495, '36256', '554', '5542401V000', '1ND', 'CEBIA Dron OP TAK Aplikace I', 'XXXtmpXXXkramnda1', '2024-01-01', '2024-12-31', '0.60', '5', 0, 19000, 18200, 0, 0, 37200, 37200, 49774, 50146, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7006', '1', 'W-7028', '0000-00-00', '0000-00-00'),
(10416, 495, '36256', '554', '5542401V000', '1ND', 'CEBIA Dron OP TAK Aplikace I', 'bazkoale', '2024-01-01', '2024-12-31', '1.00', '5', 0, 23350, 16650, 0, 0, 40000, 40000, 53520, 53920, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7008', '1', 'W-7030', '0000-00-00', '0000-00-00'),
(10417, 495, '36256', '554', '5542401V000', '1ND', 'CEBIA Dron OP TAK Aplikace I', 'XXXtmpXXXkleprlud', '2024-01-01', '2024-12-31', '0.50', '7', 0, 13825, 6175, 0, 0, 20000, 20000, 26760, 26960, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7009', '1', 'W-7029', '0000-00-00', '0000-00-00'),
(10424, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vancuto4', '2024-02-01', '2024-02-29', '0.20', '6', 0, 5000, 3400, 0, 0, 8400, 8400, 11239, 11323, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7015', '1', 'W-7706', '2024-02-01', '2024-12-31'),
(10425, 199, '36213', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vancuto4', '2024-02-01', '2024-02-29', '0.80', '6', 0, 20000, 13600, 0, 0, 33600, 33600, 44957, 45293, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7015', '2', 'W-7706', '2024-02-01', '2024-12-31'),
(10432, 74, '36254', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'skandnik', '2024-02-01', '2024-02-29', '0.45', '7', 0, 12442, 13658, 36000, 0, 62100, 26100, 83090, 83711, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7020', '1', 'W-7039', '0000-00-00', '0000-00-00'),
(10433, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'skandnik', '2024-02-01', '2024-02-29', '0.05', '7', 0, 1382, 1518, 4000, 0, 6900, 2900, 9232, 9301, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7020', '2', 'W-7039', '0000-00-00', '0000-00-00'),
(10434, 484, '36254', '544', '5442401C060', '1ND', 'Eco&Stor OPJAK - FEL Procházka', 'skandnik', '2024-02-01', '2024-02-29', '0.50', '7', 0, 13824, 15176, 0, 0, 29000, 29000, 38802, 39092, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7020', '3', 'W-7039', '0000-00-00', '0000-00-00'),
(10447, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vancuto4', '2024-03-01', '2024-08-31', '0.20', '6', 0, 5000, 4000, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7033', '1', 'W-7707', '2024-03-01', '2024-12-31'),
(10448, 199, '36213', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'vancuto4', '2024-03-01', '2024-08-31', '0.80', '6', 0, 20000, 16000, 0, 0, 36000, 36000, 48168, 48528, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7033', '2', 'W-7707', '2024-03-01', '2024-12-31'),
(10450, 74, '36254', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'skandnik', '2024-02-01', '2024-02-29', '0.45', '7', 0, 12442, 13658, 36000, 0, 62100, 26100, 83090, 83711, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7039', '1', 'W-7050', '0000-00-00', '0000-00-00'),
(10451, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'skandnik', '2024-02-01', '2024-02-29', '0.05', '7', 0, 1382, 1518, 4000, 0, 6900, 2900, 9232, 9301, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7039', '2', 'W-7050', '0000-00-00', '0000-00-00'),
(10452, 484, '36254', '544', '5442401C060', '1ND', 'Eco&Stor OPJAK - FEL Procházka', 'skandnik', '2024-02-01', '2024-02-29', '0.50', '7', 0, 13824, 15176, 0, 0, 29000, 29000, 38802, 39092, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7039', '3', 'W-7050', '0000-00-00', '0000-00-00'),
(10463, 430, '36211', '301', '3012401V000', '1ND', 'CAC GAČR - Hájek', 'kabicver', '2024-03-01', '2024-12-31', '0.60', '6', 0, 14886, 3114, 0, 0, 18000, 18000, 24084, 24264, 30000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-', '1', 'W-7073', '0000-00-00', '0000-00-00'),
(10469, 423, '36241', '311', '3112401V000', '1ND', 'LIWEPLAS TAČR Sigma DC2 - Hataj', 'postajan', '2024-02-01', '2024-08-31', '0.05', '7', 0, 1750, 1250, 0, 0, 3000, 3000, 4014, 4044, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7047', '1', 'W-7701', '2024-02-01', '2038-12-30'),
(10470, 225, '36241', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'postajan', '2024-02-01', '2024-08-31', '0.10', '7', 0, 3500, 2500, 0, 1000, 7000, 6000, 9366, 9436, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7047', '2', 'W-7701', '2024-02-01', '2038-12-30'),
(10471, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'postajan', '2024-02-01', '2024-08-31', '0.45', '7', 0, 15750, 11250, 0, 2500, 29500, 27000, 39471, 39766, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7047', '3', 'W-7701', '2024-02-01', '2038-12-30'),
(10472, 202, '36241', '894', '8941501V904', '1NE', 'Mzdový Fond RP4', 'postajan', '2024-02-01', '2024-08-31', '0.20', '7', 0, 7000, 5000, 0, 1500, 13500, 12000, 18063, 18198, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7047', '4', 'W-7701', '2024-02-01', '2038-12-30'),
(10473, 385, '36241', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'postajan', '2024-02-01', '2024-08-31', '0.20', '7', 0, 7000, 5000, 0, 0, 12000, 12000, 16056, 16176, 60000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7047', '5', 'W-7701', '2024-02-01', '2038-12-30'),
(10510, 112, '36253', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'pelanpav', '2024-02-01', '2038-12-30', '0.45', '6', 0, 11165, 9536, 0, 0, 20700, 20700, 27697, 27904, 46000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-', '1', 'W-', '0000-00-00', '0000-00-00'),
(10511, 145, '36253', '312', '3122103V000', '1ND', 'TAČR DOPRAVA - SOMKo', 'pelanpav', '2024-02-01', '2038-12-30', '0.35', '6', 0, 8684, 7416, 0, 0, 16100, 16100, 21542, 21703, 46000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-', '3', 'W-', '0000-00-00', '0000-00-00'),
(10588, 484, '36212', '544', '5442401C060', '1ND', 'Eco&Stor OPJAK - FEL Procházka', 'malikzd1', '2024-04-01', '2038-12-30', '0.49', 'A3', 0, 15190, 13230, 0, 0, 28420, 28420, 38026, 38310, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7100', '1', 'W-7185', '0000-00-00', '0000-00-00'),
(10589, 74, '36212', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'malikzd1', '2024-04-01', '2038-12-30', '0.01', 'A3', 0, 310, 270, 0, 0, 580, 580, 776, 782, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7100', '2', 'W-7185', '0000-00-00', '0000-00-00'),
(10648, 208, '36212', '604', '6042201V000', '1ND', 'H2020 - ARV', 'malikzd1', '2024-01-01', '2024-02-29', '0.20', 'A3', 0, 6200, 5400, 0, 0, 11600, 11600, 15521, 15637, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7112', '1', 'W-7151', '0000-00-00', '0000-00-00'),
(10649, 74, '36212', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'malikzd1', '2024-01-01', '2024-02-29', '0.01', 'A3', 0, 310, 270, 0, 0, 580, 580, 776, 782, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7112', '2', 'W-7151', '0000-00-00', '0000-00-00'),
(10650, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'malikzd1', '2024-01-01', '2024-02-29', '0.19', 'A3', 0, 5890, 5130, 0, 0, 11020, 11020, 14745, 14855, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7112', '3', 'W-7151', '0000-00-00', '0000-00-00'),
(10686, 112, '36251', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'vcelakj1', '2024-04-01', '2038-12-30', '0.45', '7', 0, 24750, 15750, 15750, 0, 56250, 40500, 75263, 75825, 90000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7127', '1', 'W-7198', '0000-00-00', '0000-00-00'),
(10687, 250, '36251', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'vcelakj1', '2024-04-01', '2038-12-30', '0.05', '7', 0, 2750, 1750, 1750, 0, 6250, 4500, 8363, 8425, 90000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7127', '2', 'W-7198', '0000-00-00', '0000-00-00'),
(10688, 385, '36251', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vcelakj1', '2024-04-01', '2038-12-30', '0.20', '7', 0, 11000, 7000, 7000, 0, 25000, 18000, 33450, 33700, 90000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7127', '4', 'W-7198', '0000-00-00', '0000-00-00'),
(10689, 75, '36251', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'vcelakj1', '2024-04-01', '2038-12-30', '0.30', '7', 0, 16500, 10500, 10500, 0, 37500, 27000, 50175, 50550, 90000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7127', '5', 'W-7198', '0000-00-00', '0000-00-00'),
(10709, 208, '36212', '604', '6042201V000', '1ND', 'H2020 - ARV', 'malikzd1', '2024-01-01', '2024-02-29', '0.20', 'A3', 0, 6200, 5400, 0, 0, 11600, 11600, 15521, 15637, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7151', '1', 'W-7217', '0000-00-00', '0000-00-00'),
(10710, 74, '36212', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'malikzd1', '2024-01-01', '2024-02-29', '0.20', 'A3', 0, 6200, 5400, 0, 0, 11600, 11600, 15521, 15637, 58000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7151', '2', 'W-7217', '0000-00-00', '0000-00-00'),
(10768, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'mascujak', '2024-04-01', '2038-12-30', '0.35', 'A3', 0, 10850, 14350, 0, 3500, 28700, 25200, 38401, 38688, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7172', '1', 'W-7232', '0000-00-00', '0000-00-00'),
(10769, 365, '36222', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'mascujak', '2024-04-01', '2038-12-30', '0.10', 'A3', 0, 3100, 4100, 0, 1000, 8200, 7200, 10972, 11054, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7172', '3', 'W-7232', '0000-00-00', '0000-00-00'),
(10770, 502, '36222', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'mascujak', '2024-04-01', '2038-12-30', '0.05', 'A3', 0, 1550, 2050, 0, 500, 4100, 3600, 5486, 5527, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7172', '4', 'W-7232', '0000-00-00', '0000-00-00'),
(10784, 325, '36222', '312', '3122301V000', '1ND', 'EE1 TAČR Théta V - Maščuch', 'vodicvac', '2024-04-01', '2038-12-30', '0.60', '7', 0, 16596, 20004, 0, 0, 36600, 36600, 48971, 49337, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7177', '1', 'W-7192', '0000-00-00', '0000-00-00'),
(10785, 452, '36222', '398', '3142302B062', '1ND', 'NCE 2 TAČR - Maščuch', 'vodicvac', '2024-04-01', '2038-12-30', '0.15', '7', 0, 4149, 5001, 0, 0, 9150, 9150, 12243, 12334, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7177', '2', 'W-7192', '0000-00-00', '0000-00-00'),
(10786, 149, '36222', '311', '3112004B001', '1ND', 'TAČR KAPPA - DEXPAND', 'vodicvac', '2024-04-01', '2038-12-30', '0.05', '7', 0, 1383, 1667, 0, 0, 3050, 3050, 4081, 4111, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7177', '3', 'W-7192', '0000-00-00', '0000-00-00'),
(10787, 230, '36222', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'vodicvac', '2024-04-01', '2038-12-30', '0.05', '7', 0, 1383, 1667, 0, 0, 3050, 3050, 4081, 4111, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7177', '4', 'W-7192', '0000-00-00', '0000-00-00'),
(10788, 502, '36222', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'vodicvac', '2024-04-01', '2038-12-30', '0.15', '7', 0, 4149, 5001, 0, 0, 9150, 9150, 12243, 12334, 61000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7177', '5', 'W-7192', '0000-00-00', '0000-00-00'),
(10789, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'pospika4', '2024-04-01', '2038-12-30', '0.21', '6', 0, 5208, 5082, 0, 0, 10290, 10290, 13768, 13871, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7182', '1', 'W-7235', '0000-00-00', '0000-00-00'),
(10790, 372, '36930', '554', '5542301V000', '1ND', 'ROD-Decont OP TAK Aplikace I', 'pospika4', '2024-04-01', '2038-12-30', '0.32', '6', 0, 7936, 7744, 0, 0, 15680, 15680, 20980, 21137, 49000, '', 'ne', 'ne', 'B11', 53900, 0, 1, 'W-7182', '2', 'W-7235', '0000-00-00', '0000-00-00'),
(10791, 369, '36930', '554', '5542402V000', '1ND', 'AHU-OPT OP TAK Aplikace I', 'pospika4', '2024-04-01', '2038-12-30', '0.47', '6', 0, 11656, 11374, 0, 0, 23030, 23030, 30814, 31044, 49000, '', 'ne', 'ne', 'B4', 53900, 0, 1, 'W-7182', '3', 'W-7235', '0000-00-00', '0000-00-00'),
(10793, 270, '36254', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'wolfp1', '2024-04-01', '2038-12-30', '0.15', '7', 0, 4148, 5603, 1500, 0, 11250, 9750, 15053, 15165, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7107', '2', 'W-7186', '0000-00-00', '0000-00-00'),
(10794, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wolfp1', '2024-04-01', '2038-12-30', '0.25', '7', 0, 6913, 9338, 2500, 0, 18750, 16250, 25088, 25275, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7107', '3', 'W-7186', '0000-00-00', '0000-00-00'),
(10795, 75, '36254', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'wolfp1', '2024-04-01', '2038-12-30', '0.40', '7', 0, 11060, 14940, 4000, 0, 30000, 26000, 40140, 40440, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7107', '4', 'W-7186', '0000-00-00', '0000-00-00'),
(10807, 74, '36221', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'shemevia', '2024-04-01', '2038-12-30', '0.95', '7', 0, 35483, 26267, 0, 0, 61750, 61750, 82622, 83239, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7193', '1', 'W-7226', '0000-00-00', '0000-00-00'),
(10808, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'shemevia', '2024-04-01', '2038-12-30', '0.05', '7', 0, 1867, 1383, 0, 0, 3250, 3250, 4349, 4381, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7193', '2', 'W-7226', '0000-00-00', '0000-00-00'),
(10809, 75, '36221', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'pokornik', '2024-04-01', '2038-12-30', '0.20', '7', 0, 7470, 5530, 0, 0, 13000, 13000, 17394, 17524, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7194', '1', 'W-7225', '0000-00-00', '0000-00-00'),
(10810, 242, '36221', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'pokornik', '2024-04-01', '2038-12-30', '0.20', '7', 0, 7470, 5530, 0, 0, 13000, 13000, 17394, 17524, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7194', '2', 'W-7225', '0000-00-00', '0000-00-00'),
(10811, 300, '36221', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'pokornik', '2024-04-01', '2038-12-30', '0.40', '7', 0, 14940, 11060, 0, 0, 26000, 26000, 34788, 35048, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7194', '3', 'W-7225', '0000-00-00', '0000-00-00'),
(10812, 251, '36221', '894', '8941501V902', '1NE', 'Mzdový Fond RP2', 'pokornik', '2024-04-01', '2038-12-30', '0.20', '7', 0, 7470, 5530, 0, 0, 13000, 13000, 17394, 17524, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7194', '4', 'W-7225', '0000-00-00', '0000-00-00');
INSERT INTO `zamestnanci_na_projektu_smazane` (`id`, `id_projektu`, `nakladove_stredisko`, `prefix_fis`, `fis_projektu`, `komplexni_polozka`, `nazev_projektu`, `login_zamestnance`, `na_projektu_od`, `na_projektu_do`, `uvazek_na_projektu`, `mzdova_trida`, `stupen`, `mzdovy_tarif`, `osobni_priplatek`, `projektovy_priplatek`, `priplatek`, `hruba_mzda`, `hruba_mzda_bez_priplatku`, `superhruba_mzda`, `superhruba_a_soc_fond`, `hruba_mzda_FTE`, `funkce`, `kmenova_zakazka`, `priznak`, `mzdovy_limit_kategorie`, `mzdovy_limit_castka`, `preuctovani`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(10853, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'stanekam', '2024-04-01', '2024-07-31', '0.50', 'A3', 0, 15500, 17000, 0, 0, 32500, 32500, 43485, 43810, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7209', '1', 'W-7704', '2024-04-01', '2038-12-30'),
(10854, 434, '36212', '301', '3012402A124', '1ND', 'Plísně 2 GAČR - Staněk', 'stanekam', '2024-04-01', '2024-07-31', '0.20', 'A3', 0, 6200, 6800, 0, 0, 13000, 13000, 17394, 17524, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7209', '2', 'W-7704', '2024-04-01', '2038-12-30'),
(10954, 309, '36212', '392', '3922301V000', '1ND', 'MERIT COFUND HE - Tywoniak', 'salehfat', '2024-05-03', '2025-03-31', '1.00', '7', 0, 40000, 38290, 0, 0, 78290, 78290, 104752, 105535, 78290, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7062', '1', 'W-7255', '0000-00-00', '0000-00-00'),
(10975, 467, '36215', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'petrema1', '2024-05-01', '2024-12-31', '0.25', '6', 0, 6203, 3962, 0, 0, 10165, 10165, 13601, 13702, 40660, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7250', '1', 'W-7272', '0000-00-00', '0000-00-00'),
(10976, 528, '36215', '391', '3912401V000', '1ND', 'Hybridní zelená střecha SIC Transférové vouchery Petreje', 'petrema1', '2024-05-01', '2024-12-31', '0.35', '6', 0, 8684, 5547, 0, 0, 14231, 14231, 19041, 19183, 40660, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7250', '2', 'W-7272', '0000-00-00', '0000-00-00'),
(11024, 260, '36233', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'janovvit', '2024-06-01', '2038-12-30', '0.40', '6', 0, 15180, 7620, 0, 0, 22800, 22800, 30506, 30734, 57000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7261', '1', 'W-7298', '0000-00-00', '0000-00-00'),
(11025, 112, '36253', '604', '6042001V000 ', '1ND', 'H2020 - PLURAL', 'janovvit', '2024-06-01', '2038-12-30', '0.60', '6', 0, 22770, 11430, 0, 0, 34200, 34200, 45760, 46102, 57000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7261', '2', 'W-7298', '0000-00-00', '0000-00-00'),
(11115, 251, '36222', '894', '8941501V902', '1NE', 'Mzdový Fond RP2', 'spaleja1', '2024-07-01', '2038-12-30', '0.60', '6', 0, 14892, 22308, 0, 0, 37200, 37200, 49774, 50146, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7295', '1', 'W-7335', '0000-00-00', '0000-00-00'),
(11164, 260, '36233', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'janovvit', '2024-06-01', '2024-06-30', '0.40', '6', 0, 15180, 7620, 0, 0, 22800, 22800, 30506, 30734, 57000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7298', '1', 'W-7543', '2024-06-01', '2038-12-30'),
(11165, 112, '36253', '604', '6042001V000 ', '1ND', 'H2020 - PLURAL', 'janovvit', '2024-06-01', '2024-06-30', '0.55', '6', 0, 20873, 10478, 0, 0, 31350, 31350, 41946, 42260, 57000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7298', '2', 'W-7543', '2024-06-01', '2038-12-30'),
(11166, 368, '36253', '554', '5542403V000', '1ND', 'Jeremiáš MPO ČR OP TAK Janovský', 'janovvit', '2024-06-01', '2024-06-30', '0.05', '6', 0, 1898, 953, 0, 0, 2850, 2850, 3813, 3842, 57000, '', 'ne', 'ne', 'B1', 77000, 0, 1, 'W-7298', '3', 'W-7543', '2024-06-01', '2038-12-30'),
(11195, 360, '36254', '894', '8941501V905', '1NE', 'Mzdový Fond RP5', 'malikfaw', '2024-07-11', '2024-12-31', '0.50', '7', 0, 17000, 14000, 0, 0, 31000, 31000, 41478, 41788, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7323', '1', 'W-7456', '0000-00-00', '0000-00-00'),
(11196, 208, '36254', '604', '6042201V000', '1ND', 'H2020 - ARV', 'malikfaw', '2024-07-11', '2024-12-31', '0.50', '7', 0, 17000, 14000, 0, 0, 31000, 31000, 41478, 41788, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7323', '2', 'W-7456', '0000-00-00', '0000-00-00'),
(11251, 260, '36233', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'janovvit', '2024-07-01', '2024-07-31', '0.40', '6', 0, 15180, 7620, 0, 0, 22800, 22800, 30506, 30734, 57000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7328', '1', 'W-7544', '2024-07-01', '2038-12-30'),
(11252, 112, '36253', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'janovvit', '2024-07-01', '2024-07-31', '0.05', '6', 0, 1898, 953, 0, 0, 2850, 2850, 3813, 3842, 57000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7328', '2', 'W-7544', '2024-07-01', '2038-12-30'),
(11253, 368, '36233', '554', '5542403V000', '1ND', 'Jeremiáš MPO ČR OP TAK Janovský', 'janovvit', '2024-07-01', '2024-07-31', '0.55', '6', 0, 20873, 10478, 0, 0, 31350, 31350, 41946, 42260, 57000, '', 'ne', 'ne', 'B1', 77000, 0, 1, 'W-7328', '3', 'W-7544', '2024-07-01', '2038-12-30'),
(11254, 243, '36253', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'martivl6', '2024-07-01', '2038-12-30', '0.50', '6', 0, 12405, 12595, 3500, 0, 28500, 25000, 38133, 38418, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7336', '1', 'W-7359', '0000-00-00', '0000-00-00'),
(11255, 208, '36253', '604', '6042201V000', '1ND', 'H2020 - ARV', 'martivl6', '2024-07-01', '2038-12-30', '0.10', '6', 0, 2481, 2519, 700, 0, 5700, 5000, 7627, 7684, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7336', '2', 'W-7359', '0000-00-00', '0000-00-00'),
(11256, 304, '36253', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'martivl6', '2024-07-01', '2038-12-30', '0.10', '6', 0, 2481, 2519, 700, 0, 5700, 5000, 7627, 7684, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7336', '3', 'W-7359', '0000-00-00', '0000-00-00'),
(11257, 303, '36253', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'martivl6', '2024-07-01', '2038-12-30', '0.10', '6', 0, 2481, 2519, 700, 0, 5700, 5000, 7627, 7684, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7336', '4', 'W-7359', '0000-00-00', '0000-00-00'),
(11258, 481, '36253', '311', '3112404V000', '1ND', 'AID-PV TAČR THÉTA 2 Martínek', 'martivl6', '2024-07-01', '2038-12-30', '0.20', '6', 0, 4962, 5038, 1400, 0, 11400, 10000, 15253, 15367, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7336', '5', 'W-7359', '0000-00-00', '0000-00-00'),
(11297, 270, '36254', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'wolfp1', '2024-07-01', '2038-12-30', '0.30', '7', 0, 8295, 11205, 3000, 0, 22500, 19500, 30105, 30330, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7342', '2', 'W-7360', '0000-00-00', '0000-00-00'),
(11298, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wolfp1', '2024-07-01', '2038-12-30', '0.40', '7', 0, 11060, 14940, 4000, 0, 30000, 26000, 40140, 40440, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7342', '3', 'W-7360', '0000-00-00', '0000-00-00'),
(11299, 75, '36254', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'wolfp1', '2024-07-01', '2038-12-30', '0.10', '7', 0, 2765, 3735, 1000, 0, 7500, 6500, 10035, 10110, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7342', '4', 'W-7360', '0000-00-00', '0000-00-00'),
(11300, 303, '36257', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'zavrevoj', '2024-08-01', '2024-12-31', '0.25', 'A3', 0, 11250, 8750, 0, 0, 20000, 20000, 26760, 26960, 80000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7338', '1', 'W-7435', '0000-00-00', '0000-00-00'),
(11301, 242, '36257', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'zavrevoj', '2024-08-01', '2024-12-31', '0.25', 'A3', 0, 11250, 8750, 0, 0, 20000, 20000, 26760, 26960, 80000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7338', '2', 'W-7435', '0000-00-00', '0000-00-00'),
(11302, 482, '36257', '311', '3112403V000', '1ND', 'FacilityAggregator TAČR THÉTA 2 Dostál', 'zavrevoj', '2024-08-01', '2024-12-31', '0.10', 'A3', 0, 4500, 3500, 0, 0, 8000, 8000, 10704, 10784, 80000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7338', '3', 'W-7435', '0000-00-00', '0000-00-00'),
(11303, 353, '36216', '661', '6612301V000', '1ND', 'INDICATE LaudesF - Železná', 'hodkojul', '2024-07-01', '2038-12-30', '0.10', '7', 0, 3300, 3189, 0, 0, 6489, 6489, 8682, 8747, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7344', '1', 'W-7370', '0000-00-00', '0000-00-00'),
(11304, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR - není - Klepačová', 'hodkojul', '2024-07-01', '2038-12-30', '0.80', '7', 0, 26400, 25512, 0, 0, 51912, 51912, 69458, 69977, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7344', '2', 'W-7370', '0000-00-00', '0000-00-00'),
(11305, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodkojul', '2024-07-01', '2038-12-30', '0.10', '7', 0, 3300, 3189, 0, 0, 6489, 6489, 8682, 8747, 64890, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7344', '3', 'W-7370', '0000-00-00', '0000-00-00'),
(11312, 529, '36216', '113', '1132401N000', '1NP', 'PPRO MŠMT ČR - není - Klepačová', 'salkokat', '2024-07-01', '2024-12-31', '0.60', '6', 0, 14880, 13368, 0, 0, 28248, 28248, 37796, 38078, 47080, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7346', '1', 'W-7369', '0000-00-00', '0000-00-00'),
(11313, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR - není - Klepačová', 'salkokat', '2024-07-01', '2024-12-31', '0.20', '6', 0, 4960, 4456, 0, 0, 9416, 9416, 12599, 12693, 47080, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7346', '2', 'W-7369', '0000-00-00', '0000-00-00'),
(11320, 263, '36216', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kmonibar', '2024-07-01', '2024-12-31', '0.10', '7', 0, 2757, 1968, 0, 0, 4725, 4725, 6322, 6369, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '1', 'W-7368', '0000-00-00', '0000-00-00'),
(11321, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'kmonibar', '2024-07-01', '2024-12-31', '0.01', '7', 0, 276, 197, 0, 0, 473, 473, 633, 638, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '2', 'W-7368', '0000-00-00', '0000-00-00'),
(11322, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'kmonibar', '2024-07-01', '2024-12-31', '0.01', '7', 0, 276, 197, 0, 0, 473, 473, 633, 638, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '3', 'W-7368', '0000-00-00', '0000-00-00'),
(11323, 272, '36216', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'kmonibar', '2024-07-01', '2024-12-31', '0.30', '7', 0, 8271, 5904, 0, 0, 14175, 14175, 18966, 19108, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '4', 'W-7368', '0000-00-00', '0000-00-00'),
(11324, 529, '36216', '113', '1132401N000', '1NP', 'PPRO MŠMT ČR - není - Klepačová', 'kmonibar', '2024-07-01', '2024-12-31', '0.18', '7', 0, 4963, 3542, 0, 0, 8505, 8505, 11380, 11465, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '5', 'W-7368', '0000-00-00', '0000-00-00'),
(11325, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR - není - Klepačová', 'kmonibar', '2024-07-01', '2024-12-31', '0.20', '7', 0, 5514, 3936, 0, 0, 9450, 9450, 12644, 12739, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '6', 'W-7368', '0000-00-00', '0000-00-00'),
(11326, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'kmonibar', '2024-07-01', '2024-12-31', '0.20', '7', 0, 5514, 3936, 0, 0, 9450, 9450, 12644, 12739, 47250, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7345', '7', 'W-7368', '0000-00-00', '0000-00-00'),
(11337, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2024-07-01', '2038-12-30', '0.06', '6', 0, 1563, 1377, 0, 0, 2940, 2940, 3934, 3963, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7355', '1', 'W-7366', '0000-00-00', '0000-00-00'),
(11338, 233, '36920', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'stoladan', '2024-07-01', '2038-12-30', '0.20', '6', 0, 5210, 4590, 0, 0, 9800, 9800, 13112, 13210, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7355', '2', 'W-7366', '0000-00-00', '0000-00-00'),
(11339, 385, '36920', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'stoladan', '2024-07-01', '2038-12-30', '0.20', '6', 0, 5210, 4590, 0, 0, 9800, 9800, 13112, 13210, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7355', '3', 'W-7366', '0000-00-00', '0000-00-00'),
(11340, 387, '36920', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'stoladan', '2024-07-01', '2038-12-30', '0.20', '6', 0, 5210, 4590, 0, 0, 9800, 9800, 13112, 13210, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7355', '4', 'W-7366', '0000-00-00', '0000-00-00'),
(11341, 540, '36920', '107', '1072401V900', '1ND', 'NPO GreenDeal Admin MŠMT ČR NPO Klepačová', 'stoladan', '2024-07-01', '2038-12-30', '0.19', '6', 0, 4950, 4360, 0, 0, 9310, 9310, 12457, 12550, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7355', '5', 'W-7366', '0000-00-00', '0000-00-00'),
(11342, 250, '36920', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'stoladan', '2024-07-01', '2038-12-30', '0.15', '6', 0, 3908, 3442, 0, 0, 7350, 7350, 9834, 9908, 49000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7355', '6', 'W-7366', '0000-00-00', '0000-00-00'),
(11343, 260, '36233', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'XXXtmpXXXkhatefab', '2024-06-01', '2024-06-15', '0.05', 'A4', 0, 1750, 980, 0, 0, 2730, 2730, 3653, 3680, 54600, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7356', '1', 'W-7458', '0000-00-00', '0000-00-00'),
(11431, 468, '36215', '606', '6062304V003', '1ND', 'NBSINFRA HE-Sněhota - WP3', 'zatecpav', '2024-10-08', '2025-12-31', '1.00', '6', 0, 25000, 17000, 0, 0, 42000, 42000, 56196, 56616, 42000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7376', '1', 'W-7586', '0000-00-00', '0000-00-00'),
(11443, 320, '36215', '301', '3012214A143', '1ND', 'Vícevrstvy GAČR - FSv Sněhota', 'heckopet', '2024-09-01', '2038-12-30', '0.05', '6', 0, 1241, 844, 0, 0, 2085, 2085, 2790, 2811, 41700, '', 'ne', 'ne', 'B1', 60000, 0, 1, 'W-7383', '1', 'W-7495', '0000-00-00', '0000-00-00'),
(11444, 467, '36215', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'heckopet', '2024-09-01', '2038-12-30', '0.20', '6', 0, 4964, 3376, 0, 0, 8340, 8340, 11159, 11242, 41700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7383', '2', 'W-7495', '0000-00-00', '0000-00-00'),
(11445, 449, '36215', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'heckopet', '2024-09-01', '2038-12-30', '0.10', '6', 0, 2482, 1688, 0, 0, 4170, 4170, 5579, 5621, 41700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7383', '3', 'W-7495', '0000-00-00', '0000-00-00'),
(11446, 528, '36215', '391', '3912401V000', '1ND', 'Hybridní zelená střecha SIC Transférové vouchery Petreje', 'heckopet', '2024-09-01', '2038-12-30', '0.40', '6', 0, 9928, 6752, 0, 0, 16680, 16680, 22318, 22485, 41700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7383', '4', 'W-7495', '0000-00-00', '0000-00-00'),
(11449, 467, '36215', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'petrema1', '2024-09-01', '2024-12-31', '0.05', '6', 0, 1240, 915, 0, 0, 2155, 2155, 2883, 2905, 43100, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7386', '1', 'W-7493', '0000-00-00', '0000-00-00'),
(11450, 528, '36215', '391', '3912401V000', '1ND', 'Hybridní zelená střecha SIC Transférové vouchery Petreje', 'petrema1', '2024-09-01', '2024-12-31', '0.55', '6', 0, 13640, 10065, 0, 0, 23705, 23705, 31717, 31954, 43100, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7386', '2', 'W-7493', '0000-00-00', '0000-00-00'),
(11472, 208, '36217', '604', '6042201V000', '1ND', 'H2020 - ARV', 'vitovjan', '2024-09-01', '2038-12-30', '0.20', '6', 0, 4963, 4898, 0, 0, 9860, 9860, 13193, 13291, 49300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7392', '1', 'W-7488', '0000-00-00', '0000-00-00'),
(11473, 128, '36217', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'vitovjan', '2024-09-01', '2038-12-30', '0.20', '6', 0, 4963, 4898, 0, 0, 9860, 9860, 13193, 13291, 49300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7392', '2', 'W-7488', '0000-00-00', '0000-00-00'),
(11474, 225, '36217', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'vitovjan', '2024-09-01', '2038-12-30', '0.20', '6', 0, 4963, 4898, 0, 0, 9860, 9860, 13193, 13291, 49300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7392', '3', 'W-7488', '0000-00-00', '0000-00-00'),
(11475, 434, '36217', '301', '3012402A124', '1ND', 'Plísně 2 GAČR - Staněk', 'vitovjan', '2024-09-01', '2038-12-30', '0.20', '6', 0, 4963, 4898, 0, 0, 9860, 9860, 13193, 13291, 49300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7392', '4', 'W-7488', '0000-00-00', '0000-00-00'),
(11476, 417, '36217', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'vitovjan', '2024-09-01', '2038-12-30', '0.20', '6', 0, 4963, 4898, 0, 0, 9860, 9860, 13193, 13291, 49300, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7392', '5', 'W-7488', '0000-00-00', '0000-00-00'),
(11489, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'sojkokat', '2024-09-01', '2038-12-30', '0.90', 'A3', 0, 27900, 22230, 0, 0, 50130, 50130, 67074, 67575, 55700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7400', '1', 'W-7491', '0000-00-00', '0000-00-00'),
(11520, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'volfmar3', '2024-09-01', '2038-12-30', '0.01', 'A3', 0, 423, 426, 55, 0, 904, 849, 1210, 1219, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7411', '1', 'W-7489', '0000-00-00', '0000-00-00'),
(11521, 417, '36216', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'volfmar3', '2024-09-01', '2038-12-30', '0.35', 'A3', 0, 14805, 14910, 0, 0, 29715, 29715, 39759, 40056, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7411', '2', 'W-7489', '0000-00-00', '0000-00-00'),
(11522, 365, '36214', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'volfmar3', '2024-09-01', '2038-12-30', '0.14', 'A3', 0, 5922, 5964, 778, 0, 12664, 11886, 16944, 17071, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7411', '3', 'W-7489', '0000-00-00', '0000-00-00'),
(11523, 128, '36214', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'volfmar3', '2024-09-01', '2038-12-30', '0.20', 'A3', 0, 8460, 8520, 1111, 0, 18091, 16980, 24206, 24387, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7411', '4', 'W-7489', '0000-00-00', '0000-00-00'),
(11524, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR NPO Klepačová', 'volfmar3', '2024-09-01', '2038-12-30', '0.10', 'A3', 0, 4230, 4260, 2500, 0, 10990, 8490, 14705, 14815, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7411', '5', 'W-7489', '0000-00-00', '0000-00-00'),
(11525, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'volfmar3', '2024-09-01', '2038-12-30', '0.10', 'A3', 0, 4230, 4260, 556, 0, 9046, 8490, 12104, 12194, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7411', '6', 'W-7489', '0000-00-00', '0000-00-00'),
(11572, 388, '36231', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'karnihan', '2024-08-01', '2024-08-31', '0.35', '6', 0, 8684, 8116, 0, 0, 16800, 16800, 22478, 22646, 48000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7427', '1', 'W-7717', '2024-08-01', '2038-12-30'),
(11573, 383, '36231', '261', '2612306A124', '1ND', 'NAKI MKČR - Maierová', 'karnihan', '2024-08-01', '2024-08-31', '0.40', '6', 0, 9924, 9276, 0, 0, 19200, 19200, 25690, 25882, 48000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7427', '2', 'W-7717', '2024-08-01', '2038-12-30'),
(11595, 267, '36255', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'neslamic', '2024-09-01', '2024-12-31', '0.70', '6', 0, 17374, 14126, 0, 0, 31500, 31500, 42147, 42462, 45000, '', 'ne', 'ne', 'B1', 60000, 0, 1, 'W-7428', '1', 'W-7481', '0000-00-00', '0000-00-00'),
(11596, 242, '36255', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'neslamic', '2024-09-01', '2024-12-31', '0.10', '6', 0, 2481, 2019, 0, 0, 4500, 4500, 6021, 6066, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7428', '2', 'W-7481', '0000-00-00', '0000-00-00'),
(11597, 303, '36255', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'neslamic', '2024-09-01', '2024-12-31', '0.10', '6', 0, 2481, 2019, 0, 0, 4500, 4500, 6021, 6066, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7428', '3', 'W-7481', '0000-00-00', '0000-00-00'),
(11598, 304, '36255', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'neslamic', '2024-09-01', '2024-12-31', '0.10', '6', 0, 2481, 2019, 0, 0, 4500, 4500, 6021, 6066, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7428', '4', 'W-7481', '0000-00-00', '0000-00-00'),
(11610, 388, '36231', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'karnihan', '2024-09-01', '2038-12-30', '0.37', '6', 0, 9180, 8580, 0, 0, 17760, 17760, 23763, 23940, 48000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7442', '1', 'W-7720', '0000-00-00', '0000-00-00'),
(11611, 383, '36231', '261', '2612306A124', '1ND', 'NAKI MKČR - Maierová', 'karnihan', '2024-09-01', '2038-12-30', '0.40', '6', 0, 9924, 9276, 0, 0, 19200, 19200, 25690, 25882, 48000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7442', '2', 'W-7720', '0000-00-00', '0000-00-00'),
(11612, 260, '36231', '894', '8941501V903', '1NE', 'Mzdový Fond RP3', 'karnihan', '2024-09-01', '2038-12-30', '0.13', '6', 0, 3225, 3015, 0, 0, 6240, 6240, 8349, 8412, 48000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7442', '3', 'W-7720', '0000-00-00', '0000-00-00'),
(11647, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'danickar', '2024-09-01', '2024-09-30', '0.90', '4', 0, 19359, 15741, 0, 0, 35100, 35100, 46964, 47315, 39000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7460', '1', 'W-7724', '2024-09-01', '2024-12-31'),
(11648, 479, '36930', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'danickar', '2024-09-01', '2024-09-30', '0.10', '4', 0, 2151, 1749, 0, 0, 3900, 3900, 5218, 5257, 39000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7460', '2', 'W-7724', '2024-09-01', '2024-12-31'),
(11655, 304, '36960', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'civinjan', '2024-09-01', '2038-12-30', '0.70', '6', 0, 21000, 14000, 0, 0, 35000, 35000, 46830, 47180, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7462', '1', 'W-7474', '0000-00-00', '0000-00-00'),
(11656, 365, '36960', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'civinjan', '2024-09-01', '2038-12-30', '0.10', '6', 0, 3000, 2000, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7462', '2', 'W-7474', '0000-00-00', '0000-00-00'),
(11664, 208, '36217', '604', '6042201V000', '1ND', 'H2020 - ARV', 'hodekdra', '2024-10-01', '2038-12-30', '0.20', '4', 0, 4302, 4078, 0, 0, 8380, 8380, 11212, 11296, 41900, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7465', '1', 'W-7584', '0000-00-00', '0000-00-00'),
(11665, 320, '36217', '301', '3012214A143', '1ND', 'Vícevrstvy GAČR - FSv Sněhota', 'hodekdra', '2024-10-01', '2038-12-30', '0.15', '4', 0, 3227, 3059, 0, 0, 6285, 6285, 8409, 8472, 41900, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7465', '2', 'W-7584', '0000-00-00', '0000-00-00'),
(11666, 128, '36217', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'hodekdra', '2024-10-01', '2038-12-30', '0.05', '4', 0, 1076, 1020, 0, 0, 2095, 2095, 2803, 2824, 41900, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7465', '3', 'W-7584', '0000-00-00', '0000-00-00'),
(11667, 225, '36217', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodekdra', '2024-10-01', '2038-12-30', '0.05', '4', 0, 1076, 1020, 0, 0, 2095, 2095, 2803, 2824, 41900, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7465', '4', 'W-7584', '0000-00-00', '0000-00-00'),
(11668, 199, '36217', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'hodekdra', '2024-10-01', '2038-12-30', '0.55', '4', 0, 11831, 11215, 0, 0, 23045, 23045, 30834, 31065, 41900, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7465', '5', 'W-7584', '0000-00-00', '0000-00-00'),
(11691, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'hejtmpet', '2024-10-01', '2038-12-30', '0.05', 'A3', 0, 1750, 1435, 0, 417, 3602, 3185, 4819, 4855, 63700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7471', '1', 'W-7573', '0000-00-00', '0000-00-00'),
(11692, 417, '36213', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'hejtmpet', '2024-10-01', '2038-12-30', '0.55', 'A3', 0, 19250, 15785, 0, 4583, 39618, 35035, 53009, 53405, 63700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7471', '2', 'W-7573', '0000-00-00', '0000-00-00'),
(11693, 304, '36960', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'civinjan', '2024-09-01', '2038-12-30', '0.60', '6', 0, 18000, 12000, 0, 0, 30000, 30000, 40140, 40440, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7474', '1', 'W-7475', '0000-00-00', '0000-00-00'),
(11694, 365, '36960', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'civinjan', '2024-09-01', '2038-12-30', '0.10', '6', 0, 3000, 2000, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7474', '2', 'W-7475', '0000-00-00', '0000-00-00'),
(11695, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'civinjan', '2024-09-01', '2038-12-30', '0.10', '6', 0, 3000, 2000, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7474', '3', 'W-7475', '0000-00-00', '0000-00-00'),
(11795, 320, '36215', '301', '3012214A143', '1ND', 'Vícevrstvy GAČR - FSv Sněhota', 'jelinvl1', '2024-10-01', '2038-12-30', '0.20', '7', 0, 5530, 5170, 0, 0, 10700, 10700, 14317, 14424, 53500, '', 'ne', 'ne', 'B1', 60000, 0, 1, 'W-7501', '1', 'W-7585', '0000-00-00', '0000-00-00'),
(11796, 467, '36215', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'jelinvl1', '2024-10-01', '2038-12-30', '0.20', '7', 0, 5530, 5170, 0, 0, 10700, 10700, 14317, 14424, 53500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7501', '2', 'W-7585', '0000-00-00', '0000-00-00'),
(11797, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'feliclic', '2024-10-01', '2038-12-30', '0.38', '6', 0, 9424, 11856, 0, 0, 21280, 21280, 28473, 28685, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7502', '1', 'W-7538', '0000-00-00', '0000-00-00'),
(11798, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 248, 312, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7502', '3', 'W-7538', '0000-00-00', '0000-00-00'),
(11799, 468, '36216', '606', '6062304V003', '1ND', 'NBSINFRA HE-Sněhota - WP3', 'feliclic', '2024-10-01', '2038-12-30', '0.20', '6', 0, 4960, 6240, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7502', '4', 'W-7538', '0000-00-00', '0000-00-00'),
(11800, 469, '36216', '606', '6062304V006', '1ND', 'NBSINFRA HE-Sněhota - WP6', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 248, 312, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7502', '5', 'W-7538', '0000-00-00', '0000-00-00'),
(11801, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'feliclic', '2024-10-01', '2038-12-30', '0.40', '6', 0, 9920, 12480, 0, 0, 22400, 22400, 29971, 30195, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7502', '6', 'W-7538', '0000-00-00', '0000-00-00'),
(11859, 365, '36222', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'mascujak', '2024-10-01', '2038-12-30', '0.10', 'A3', 0, 3100, 4100, 0, 1000, 8200, 7200, 10972, 11054, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7516', '1', 'W-7642', '0000-00-00', '0000-00-00'),
(11860, 502, '36222', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'mascujak', '2024-10-01', '2038-12-30', '0.20', 'A3', 0, 6200, 8200, 0, 2000, 16400, 14400, 21943, 22107, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7516', '2', 'W-7642', '0000-00-00', '0000-00-00'),
(11861, 480, '36222', '311', '3112405V000', '1ND', 'RASH TAČR THÉTA 2 Maščuch', 'mascujak', '2024-10-01', '2038-12-30', '0.10', 'A3', 0, 3100, 4100, 0, 1000, 8200, 7200, 10972, 11054, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7516', '3', 'W-7642', '0000-00-00', '0000-00-00'),
(11862, 479, '36222', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'mascujak', '2024-10-01', '2038-12-30', '0.10', 'A3', 0, 3100, 4100, 0, 1000, 8200, 7200, 10972, 11054, 72000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7516', '4', 'W-7642', '0000-00-00', '0000-00-00'),
(11863, 365, '36222', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'spaleja1', '2024-10-01', '2038-12-30', '0.05', '6', 0, 1750, 1350, 0, 0, 3100, 3100, 4148, 4179, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7517', '1', 'W-7551', '0000-00-00', '0000-00-00'),
(11864, 502, '36222', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'spaleja1', '2024-10-01', '2038-12-30', '0.10', '6', 0, 3500, 2700, 0, 0, 6200, 6200, 8296, 8358, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7517', '2', 'W-7551', '0000-00-00', '0000-00-00'),
(11865, 480, '36222', '311', '3112405V000', '1ND', 'RASH TAČR THÉTA 2 Maščuch', 'spaleja1', '2024-10-01', '2038-12-30', '0.35', '6', 0, 12250, 9450, 0, 0, 21700, 21700, 29035, 29252, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7517', '3', 'W-7551', '0000-00-00', '0000-00-00'),
(11866, 479, '36222', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'spaleja1', '2024-10-01', '2038-12-30', '0.10', '6', 0, 3500, 2700, 0, 0, 6200, 6200, 8296, 8358, 62000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7517', '4', 'W-7551', '0000-00-00', '0000-00-00'),
(11870, 310, '36222', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'dvorakr8', '2024-11-01', '2025-12-31', '0.25', '4', 0, 5500, 4500, 0, 0, 10000, 10000, 13380, 13480, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7531', '1', 'W-7757', '0000-00-00', '0000-00-00'),
(11871, 300, '36222', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'dvorakr8', '2024-11-01', '2025-12-31', '0.25', '4', 0, 5500, 4500, 0, 0, 10000, 10000, 13380, 13480, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7531', '2', 'W-7757', '0000-00-00', '0000-00-00'),
(11872, 479, '36222', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'dvorakr8', '2024-11-01', '2025-12-31', '0.25', '4', 0, 5500, 4500, 0, 0, 10000, 10000, 13380, 13480, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7531', '3', 'W-7757', '0000-00-00', '0000-00-00'),
(11873, 502, '36222', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'dvorakr8', '2024-11-01', '2025-12-31', '0.25', '4', 0, 5500, 4500, 0, 0, 10000, 10000, 13380, 13480, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7531', '4', 'W-7757', '0000-00-00', '0000-00-00'),
(11886, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'feliclic', '2024-10-01', '2038-12-30', '0.38', '6', 0, 10640, 10640, 0, 0, 21280, 21280, 28473, 28685, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7538', '1', 'W-7570', '0000-00-00', '0000-00-00'),
(11887, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 280, 280, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7538', '3', 'W-7570', '0000-00-00', '0000-00-00'),
(11888, 468, '36216', '606', '6062304V003', '1ND', 'NBSINFRA HE-Sněhota - WP3', 'feliclic', '2024-10-01', '2038-12-30', '0.20', '6', 0, 5600, 5600, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7538', '4', 'W-7570', '0000-00-00', '0000-00-00'),
(11889, 469, '36216', '606', '6062304V006', '1ND', 'NBSINFRA HE-Sněhota - WP6', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 280, 280, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7538', '5', 'W-7570', '0000-00-00', '0000-00-00'),
(11890, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'feliclic', '2024-10-01', '2038-12-30', '0.40', '6', 0, 11200, 11200, 0, 0, 22400, 22400, 29971, 30195, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7538', '6', 'W-7570', '0000-00-00', '0000-00-00'),
(11908, 374, '36930', '554', '5542405V000', '1ND', 'ISS OP TAK Aplikace I', 'mlejnzuz', '2024-10-01', '2025-03-31', '0.20', '6', 0, 4962, 4038, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'B4', 53900, 0, 1, 'W-7548', '1', 'W-7686', '0000-00-00', '0000-00-00'),
(11909, 230, '36930', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'mlejnzuz', '2024-10-01', '2025-03-31', '0.20', '6', 0, 4962, 4038, 0, 0, 9000, 9000, 12042, 12132, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7548', '2', 'W-7686', '0000-00-00', '0000-00-00'),
(11910, 225, '36930', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'mlejnzuz', '2024-10-01', '2025-03-31', '0.16', '6', 0, 3970, 3230, 0, 0, 7200, 7200, 9634, 9706, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7548', '3', 'W-7686', '0000-00-00', '0000-00-00'),
(11911, 388, '36930', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'mlejnzuz', '2024-10-01', '2025-03-31', '0.09', '6', 0, 2233, 1817, 0, 0, 4050, 4050, 5419, 5459, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7548', '4', 'W-7686', '0000-00-00', '0000-00-00'),
(11912, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'mlejnzuz', '2024-10-01', '2025-03-31', '0.35', '6', 0, 8684, 7066, 0, 0, 15750, 15750, 21074, 21231, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7548', '5', 'W-7686', '0000-00-00', '0000-00-00'),
(11921, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'danickar', '2024-10-01', '2025-12-31', '0.90', '4', 0, 19359, 15741, 0, 0, 35100, 35100, 46964, 47315, 39000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7550', '1', 'W-7564', '0000-00-00', '0000-00-00'),
(11922, 479, '36930', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'danickar', '2024-10-01', '2025-12-31', '0.10', '4', 0, 2151, 1749, 0, 0, 3900, 3900, 5218, 5257, 39000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7550', '2', 'W-7564', '0000-00-00', '0000-00-00'),
(11973, 417, '36212', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'buresmi4', '2024-10-01', '2038-12-30', '0.10', '6', 0, 2481, 2759, 0, 0, 5240, 5240, 7011, 7064, 52400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7566', '1', 'W-7595', '0000-00-00', '0000-00-00'),
(11974, 381, '36212', '554', '5542407V000', '1ND', 'RecBet OP TAK Aplikace I', 'buresmi4', '2024-10-01', '2038-12-30', '0.30', '6', 0, 7443, 8277, 0, 0, 15720, 15720, 21033, 21191, 52400, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7566', '2', 'W-7595', '0000-00-00', '0000-00-00'),
(11991, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'feliclic', '2024-10-01', '2038-12-30', '0.33', '6', 0, 8184, 10296, 0, 0, 18480, 18480, 24726, 24911, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7570', '1', 'W-7597', '0000-00-00', '0000-00-00'),
(11992, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'feliclic', '2024-10-01', '2038-12-30', '0.15', '6', 0, 3720, 4680, 0, 0, 8400, 8400, 11239, 11323, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7570', '2', 'W-7597', '0000-00-00', '0000-00-00'),
(11993, 468, '36216', '606', '6062304V003', '1ND', 'NBSINFRA HE-Sněhota - WP3', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 248, 312, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7570', '3', 'W-7597', '0000-00-00', '0000-00-00'),
(11994, 469, '36216', '606', '6062304V006', '1ND', 'NBSINFRA HE-Sněhota - WP6', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 248, 312, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7570', '4', 'W-7597', '0000-00-00', '0000-00-00'),
(11995, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'feliclic', '2024-10-01', '2038-12-30', '0.50', '6', 0, 12400, 15600, 0, 0, 28000, 28000, 37464, 37744, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7570', '5', 'W-7597', '0000-00-00', '0000-00-00'),
(12005, 417, '36212', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'stanekam', '2024-10-01', '2038-12-30', '0.05', 'A3', 0, 1550, 1800, 0, 0, 3350, 3350, 4482, 4516, 67000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7560', '1', 'W-7599', '0000-00-00', '0000-00-00'),
(12006, 434, '36212', '301', '3012402A124', '1ND', 'Plísně 2 GAČR - Staněk', 'stanekam', '2024-10-01', '2038-12-30', '0.20', 'A3', 0, 6200, 7200, 0, 0, 13400, 13400, 17929, 18063, 67000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7560', '2', 'W-7599', '0000-00-00', '0000-00-00'),
(12007, 381, '36212', '554', '5542407V000', '1ND', 'RecBet OP TAK Aplikace I', 'stanekam', '2024-10-01', '2038-12-30', '0.45', 'A3', 0, 13950, 16200, 0, 0, 30150, 30150, 40341, 40642, 67000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7560', '3', 'W-7599', '0000-00-00', '0000-00-00'),
(12029, 548, '36930', '104', '1042457N000', '1NP', 'PPSŘ -AEDO MŠMT ČR Program na podporu strategického řízení Dytrich', 'danickar', '2024-10-01', '2025-12-31', '0.90', '4', 0, 19359, 15741, 0, 0, 35100, 35100, 46964, 47315, 39000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7564', '1', 'W-7685', '0000-00-00', '0000-00-00'),
(12030, 479, '36930', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'danickar', '2024-10-01', '2025-12-31', '0.10', '4', 0, 2151, 1749, 0, 0, 3900, 3900, 5218, 5257, 39000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7564', '2', 'W-7685', '0000-00-00', '0000-00-00'),
(12036, 535, '36256', '554', '5542410V000', '1ND', 'CEBIA AI MPO ČR OP TAK Čepek', 'XXXtmpXXXmuhlffra', '2024-09-01', '2025-12-31', '0.40', '4', 0, 8604, 7396, 0, 0, 16000, 16000, 21408, 21568, 40000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7582', '1', 'W-7764', '0000-00-00', '0000-00-00'),
(12038, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'volfmar3', '2024-10-01', '2038-12-30', '0.01', 'A3', 0, 423, 426, 55, 0, 904, 849, 1210, 1219, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7557', '1', 'W-7600', '0000-00-00', '0000-00-00'),
(12039, 417, '36216', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'volfmar3', '2024-10-01', '2038-12-30', '0.01', 'A3', 0, 423, 426, 0, 0, 849, 849, 1136, 1144, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7557', '2', 'W-7600', '0000-00-00', '0000-00-00'),
(12040, 365, '36214', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'volfmar3', '2024-10-01', '2038-12-30', '0.15', 'A3', 0, 6345, 6390, 778, 0, 13513, 12735, 18080, 18216, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7557', '3', 'W-7600', '0000-00-00', '0000-00-00'),
(12041, 128, '36214', '312', '3122101V000', '1ND', 'TAČR TREND III - Automation4Timber', 'volfmar3', '2024-10-01', '2038-12-30', '0.23', 'A3', 0, 9729, 9798, 1111, 0, 20638, 19527, 27614, 27820, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7557', '4', 'W-7600', '0000-00-00', '0000-00-00'),
(12042, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR NPO Klepačová', 'volfmar3', '2024-10-01', '2038-12-30', '0.40', 'A3', 0, 16920, 17040, 2500, 0, 36460, 33960, 48783, 49148, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7557', '5', 'W-7600', '0000-00-00', '0000-00-00'),
(12043, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'volfmar3', '2024-10-01', '2038-12-30', '0.10', 'A3', 0, 4230, 4260, 556, 0, 9046, 8490, 12104, 12194, 84900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7557', '6', 'W-7600', '0000-00-00', '0000-00-00'),
(12044, 279, '36216', '661', '6612202V000', '1ND', 'Cir4ConClimate EUKI - Pavlů', 'polovkri', '2024-10-01', '2038-12-30', '0.30', '7', 0, 8313, 8697, 0, 0, 17010, 17010, 22759, 22929, 56700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7556', '1', 'W-7596', '0000-00-00', '0000-00-00'),
(12045, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'polovkri', '2024-10-01', '2038-12-30', '0.30', '7', 0, 8313, 8697, 0, 0, 17010, 17010, 22759, 22929, 56700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7556', '2', 'W-7596', '0000-00-00', '0000-00-00'),
(12046, 332, '36216', '604', '6042201A133', '1ND', 'Probono H2020 - Tencar', 'polovkri', '2024-10-01', '2038-12-30', '0.20', '7', 0, 5542, 5798, 0, 0, 11340, 11340, 15173, 15286, 56700, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7556', '3', 'W-7596', '0000-00-00', '0000-00-00'),
(12059, 522, '36216', '107', '1072401V400', '1NP', 'NPO GreenDeal MŠMT ČR NPO Klepačová', 'hodkojul', '2024-10-01', '2038-12-30', '0.84', '7', 0, 27720, 28980, 0, 0, 56700, 56700, 75865, 76432, 67500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7558', '1', 'W-7598', '0000-00-00', '0000-00-00'),
(12060, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodkojul', '2024-10-01', '2038-12-30', '0.15', '7', 0, 4950, 5175, 0, 0, 10125, 10125, 13547, 13649, 67500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7558', '2', 'W-7598', '0000-00-00', '0000-00-00'),
(12061, 417, '36216', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'hodkojul', '2024-10-01', '2038-12-30', '0.01', '7', 0, 330, 345, 0, 0, 675, 675, 903, 910, 67500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7558', '3', 'W-7598', '0000-00-00', '0000-00-00'),
(12073, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'feliclic', '2024-10-01', '2038-12-30', '0.38', '6', 0, 10640, 10640, 0, 0, 21280, 21280, 28473, 28685, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7597', '1', 'W-7862', '0000-00-00', '0000-00-00'),
(12074, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 280, 280, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7597', '3', 'W-7862', '0000-00-00', '0000-00-00'),
(12075, 468, '36216', '606', '6062304V003', '1ND', 'NBSINFRA HE-Sněhota - WP3', 'feliclic', '2024-10-01', '2038-12-30', '0.20', '6', 0, 5600, 5600, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7597', '4', 'W-7862', '0000-00-00', '0000-00-00'),
(12076, 469, '36216', '606', '6062304V006', '1ND', 'NBSINFRA HE-Sněhota - WP6', 'feliclic', '2024-10-01', '2038-12-30', '0.01', '6', 0, 280, 280, 0, 0, 560, 560, 749, 755, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7597', '5', 'W-7862', '0000-00-00', '0000-00-00'),
(12077, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'feliclic', '2024-10-01', '2038-12-30', '0.40', '6', 0, 11200, 11200, 0, 0, 22400, 22400, 29971, 30195, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7597', '6', 'W-7862', '0000-00-00', '0000-00-00'),
(12092, 537, '36244', '554', '5542409V000', '1ND', 'HALA 4.0 MPO ČR OP TAK Wald', 'XXXtmpXXXhorovkam', '2024-10-01', '2026-12-31', '0.48', 'A3', 0, 14880, 6894, 0, 0, 21774, 21774, 29134, 29351, 45362, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7602', '1', 'W-7664', '0000-00-00', '0000-00-00'),
(12134, 537, '36244', '554', '5542409V000', '1ND', 'HALA 4.0 MPO ČR OP TAK Wald', 'XXXtmpXXXmaresda5', '2024-10-01', '2026-12-31', '0.68', '5', 0, 15878, 8385, 0, 0, 24263, 24263, 32464, 32707, 35681, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7616', '1', 'W-7663', '0000-00-00', '0000-00-00'),
(12255, 208, '36255', '604', '6042201V000', '1ND', 'H2020 - ARV', 'starason', '2024-11-01', '2024-12-31', '0.01', '6', 0, 248, 202, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7620', '1', 'W-7787', '0000-00-00', '0000-00-00'),
(12256, 303, '36255', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'starason', '2024-11-01', '2024-12-31', '0.01', '6', 0, 248, 202, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7620', '2', 'W-7787', '0000-00-00', '0000-00-00'),
(12257, 267, '36255', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'starason', '2024-11-01', '2024-12-31', '0.68', '6', 0, 16864, 13736, 0, 0, 30600, 30600, 40943, 41249, 45000, '', 'ne', 'ne', 'B1', 60000, 0, 1, 'W-7620', '3', 'W-7787', '0000-00-00', '0000-00-00'),
(12314, 300, '36221', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'sulcvlad', '2024-10-01', '2024-12-31', '0.50', 'A3', 0, 15500, 9500, 0, 0, 25000, 25000, 33450, 33700, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7640', '1', 'W-7678', '0000-00-00', '0000-00-00'),
(12315, 304, '36221', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'matustom', '2024-10-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7641', '1', 'W-7671', '0000-00-00', '0000-00-00'),
(12316, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'matustom', '2024-10-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7641', '2', 'W-7671', '0000-00-00', '0000-00-00'),
(12317, 233, '36221', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'matustom', '2024-10-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7641', '3', 'W-7671', '0000-00-00', '0000-00-00'),
(12318, 367, '36221', '554', '5542411V000', '1ND', 'Vodík MPO ČR OP TAK Matuška', 'matustom', '2024-10-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7641', '4', 'W-7671', '0000-00-00', '0000-00-00'),
(12319, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'matustom', '2024-10-01', '2038-12-30', '0.30', 'A4', 0, 13200, 12000, 0, 3000, 28200, 25200, 37732, 38014, 84000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7641', '5', 'W-7671', '0000-00-00', '0000-00-00'),
(12344, 304, '36221', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'novotji8', '2024-11-01', '2038-12-30', '0.15', '6', 0, 5250, 4950, 0, 0, 10200, 10200, 13648, 13750, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7652', '1', 'W-7753', '0000-00-00', '0000-00-00'),
(12345, 367, '36221', '554', '5542411V000', '1ND', 'Vodík MPO ČR OP TAK Matuška', 'novotji8', '2024-11-01', '2038-12-30', '0.20', '6', 0, 7000, 6600, 0, 0, 13600, 13600, 18197, 18333, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7652', '2', 'W-7753', '0000-00-00', '0000-00-00'),
(12346, 310, '36221', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'novotji8', '2024-11-01', '2038-12-30', '0.25', '6', 0, 8750, 8250, 0, 0, 17000, 17000, 22746, 22916, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7652', '3', 'W-7753', '0000-00-00', '0000-00-00'),
(12347, 300, '36221', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'novotji8', '2024-11-01', '2038-12-30', '0.20', '6', 0, 7000, 6600, 0, 0, 13600, 13600, 18197, 18333, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7652', '4', 'W-7753', '0000-00-00', '0000-00-00'),
(12348, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'novotji8', '2024-11-01', '2038-12-30', '0.20', '6', 0, 7000, 6600, 0, 0, 13600, 13600, 18197, 18333, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7652', '5', 'W-7753', '0000-00-00', '0000-00-00'),
(12356, 367, '36221', '554', '5542411V000', '1ND', 'Vodík MPO ČR OP TAK Matuška', 'puttaluk', '2024-11-01', '2024-12-31', '0.30', '7', 0, 12000, 9900, 0, 0, 21900, 21900, 29302, 29521, 73000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7655', '1', 'W-7763', '0000-00-00', '0000-00-00'),
(12357, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'puttaluk', '2024-11-01', '2024-12-31', '0.30', '7', 0, 12000, 9900, 0, 0, 21900, 21900, 29302, 29521, 73000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7655', '2', 'W-7763', '0000-00-00', '0000-00-00'),
(12363, 233, '36221', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'straka', '2024-11-01', '2038-12-30', '0.10', '7', 0, 2965, 3535, 0, 0, 6500, 6500, 8697, 8762, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7658', '1', 'W-7721', '0000-00-00', '0000-00-00'),
(12364, 300, '36221', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'straka', '2024-11-01', '2038-12-30', '0.40', '7', 0, 11860, 14140, 0, 0, 26000, 26000, 34788, 35048, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7658', '2', 'W-7721', '0000-00-00', '0000-00-00'),
(12376, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'langeeri', '2024-11-01', '2024-12-31', '0.10', '6', 0, 2482, 4318, 0, 0, 6800, 6800, 9098, 9166, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7662', '1', 'W-7722', '0000-00-00', '0000-00-00'),
(12377, 310, '36221', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'langeeri', '2024-11-01', '2024-12-31', '0.38', '6', 0, 9432, 16408, 0, 0, 25840, 25840, 34574, 34832, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7662', '2', 'W-7722', '0000-00-00', '0000-00-00'),
(12378, 304, '36221', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'langeeri', '2024-11-01', '2024-12-31', '0.22', '6', 0, 5460, 9500, 0, 0, 14960, 14960, 20016, 20166, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7662', '3', 'W-7722', '0000-00-00', '0000-00-00'),
(12379, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'langeeri', '2024-11-01', '2024-12-31', '0.30', '6', 0, 7446, 12954, 0, 0, 20400, 20400, 27295, 27499, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7662', '4', 'W-7722', '0000-00-00', '0000-00-00'),
(12382, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'matejsi2', '2025-01-01', '2025-12-31', '0.20', '5', 0, 4670, 5330, 0, 0, 10000, 10000, 13380, 13480, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7665', '1', 'W-7681', '0000-00-00', '0000-00-00'),
(12383, 385, '36241', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'matejsi2', '2025-01-01', '2025-12-31', '0.40', '5', 0, 9340, 10660, 0, 0, 20000, 20000, 26760, 26960, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7665', '2', 'W-7681', '0000-00-00', '0000-00-00'),
(12414, 250, '36241', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'matejsi2', '2025-01-01', '2025-12-31', '0.20', '5', 0, 5200, 4800, 0, 0, 10000, 10000, 13380, 13480, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7681', '1', 'W-7852', '0000-00-00', '0000-00-00'),
(12415, 385, '36241', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'matejsi2', '2025-01-01', '2025-12-31', '0.40', '5', 0, 10400, 9600, 0, 0, 20000, 20000, 26760, 26960, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7681', '2', 'W-7852', '0000-00-00', '0000-00-00'),
(12416, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'pospika4', '2024-11-01', '2038-12-30', '0.21', '6', 0, 6300, 7119, 0, 0, 13419, 13419, 17955, 18089, 63900, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7682', '1', 'W-7800', '0000-00-00', '0000-00-00'),
(12417, 372, '36930', '554', '5542301V000', '1ND', 'ROD-Decont OP TAK Aplikace I', 'pospika4', '2024-11-01', '2038-12-30', '0.32', '6', 0, 9600, 7648, 0, 0, 17248, 17248, 23078, 23250, 53900, '', 'ne', 'ne', 'B11', 53900, 0, 1, 'W-7682', '2', 'W-7800', '0000-00-00', '0000-00-00');
INSERT INTO `zamestnanci_na_projektu_smazane` (`id`, `id_projektu`, `nakladove_stredisko`, `prefix_fis`, `fis_projektu`, `komplexni_polozka`, `nazev_projektu`, `login_zamestnance`, `na_projektu_od`, `na_projektu_do`, `uvazek_na_projektu`, `mzdova_trida`, `stupen`, `mzdovy_tarif`, `osobni_priplatek`, `projektovy_priplatek`, `priplatek`, `hruba_mzda`, `hruba_mzda_bez_priplatku`, `superhruba_mzda`, `superhruba_a_soc_fond`, `hruba_mzda_FTE`, `funkce`, `kmenova_zakazka`, `priznak`, `mzdovy_limit_kategorie`, `mzdovy_limit_castka`, `preuctovani`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(12418, 369, '36930', '554', '5542402V000', '1ND', 'AHU-OPT OP TAK Aplikace I', 'pospika4', '2024-11-01', '2038-12-30', '0.47', '6', 0, 14100, 11233, 0, 0, 25333, 25333, 33896, 34149, 53900, '', 'ne', 'ne', 'B4', 53900, 0, 1, 'W-7682', '3', 'W-7800', '0000-00-00', '0000-00-00'),
(12419, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'stoladan', '2024-11-01', '2038-12-30', '0.06', '6', 0, 1800, 1560, 0, 0, 3360, 3360, 4496, 4529, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7683', '1', 'W-7756', '0000-00-00', '0000-00-00'),
(12420, 233, '36920', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'stoladan', '2024-11-01', '2038-12-30', '0.20', '6', 0, 6000, 5200, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7683', '2', 'W-7756', '0000-00-00', '0000-00-00'),
(12421, 385, '36920', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'stoladan', '2024-11-01', '2038-12-30', '0.20', '6', 0, 6000, 5200, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7683', '3', 'W-7756', '0000-00-00', '0000-00-00'),
(12422, 387, '36920', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'stoladan', '2024-11-01', '2038-12-30', '0.20', '6', 0, 6000, 5200, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7683', '4', 'W-7756', '0000-00-00', '0000-00-00'),
(12423, 540, '36920', '107', '1072401V900', '1ND', 'NPO GreenDeal Admin MŠMT ČR NPO Klepačová', 'stoladan', '2024-11-01', '2038-12-30', '0.19', '6', 0, 5700, 4940, 0, 0, 10640, 10640, 14236, 14343, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7683', '5', 'W-7756', '0000-00-00', '0000-00-00'),
(12424, 250, '36920', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'stoladan', '2024-11-01', '2038-12-30', '0.15', '6', 0, 4500, 3900, 0, 0, 8400, 8400, 11239, 11323, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7683', '6', 'W-7756', '0000-00-00', '0000-00-00'),
(12441, 91, '36870', '888', '8889701V000', '9NN', 'Režie - ostatní', 'vanek', '2024-11-01', '2038-12-30', '0.40', '6', 0, 12000, 10400, 0, 0, 22400, 22400, 29971, 30195, 56000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7688', '1', 'W-7802', '0000-00-00', '0000-00-00'),
(12448, 374, '36930', '554', '5542405V000', '1ND', 'ISS OP TAK Aplikace I', 'mlejnzuz', '2024-11-01', '2025-03-31', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'B4', 53900, 0, 1, 'W-7686', '1', 'W-7761', '0000-00-00', '0000-00-00'),
(12449, 230, '36930', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'mlejnzuz', '2024-11-01', '2025-03-31', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7686', '2', 'W-7761', '0000-00-00', '0000-00-00'),
(12450, 225, '36930', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'mlejnzuz', '2024-11-01', '2025-03-31', '0.16', '6', 0, 4320, 4000, 0, 0, 8320, 8320, 11132, 11215, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7686', '3', 'W-7761', '0000-00-00', '0000-00-00'),
(12451, 388, '36930', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'mlejnzuz', '2024-11-01', '2025-03-31', '0.09', '6', 0, 2430, 2250, 0, 0, 4680, 4680, 6262, 6309, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7686', '4', 'W-7761', '0000-00-00', '0000-00-00'),
(12452, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'mlejnzuz', '2024-11-01', '2025-03-31', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7686', '5', 'W-7761', '0000-00-00', '0000-00-00'),
(12453, 423, '36930', '311', '3112401V000', '1ND', 'LIWEPLAS TAČR Sigma DC2 - Hataj', 'mlejnzuz', '2024-11-01', '2025-03-31', '0.15', '6', 0, 4050, 3750, 0, 0, 7800, 7800, 10436, 10514, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7686', '6', 'W-7761', '0000-00-00', '0000-00-00'),
(12463, 365, '36960', '312', '3122303V000', '1ND', 'Resilience obcí TAČR Sigma DC3 - Volf', 'civinjan', '2024-11-01', '2038-12-30', '0.05', '6', 0, 1500, 1000, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7693', '1', 'W-7774', '0000-00-00', '0000-00-00'),
(12464, 208, '36960', '604', '6042201V000', '1ND', 'H2020 - ARV', 'civinjan', '2024-11-01', '2038-12-30', '0.70', '6', 0, 21000, 14000, 0, 0, 35000, 35000, 46830, 47180, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7693', '2', 'W-7774', '0000-00-00', '0000-00-00'),
(12465, 272, '36960', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'civinjan', '2024-11-01', '2038-12-30', '0.05', '6', 0, 1500, 1000, 0, 0, 2500, 2500, 3345, 3370, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7693', '3', 'W-7774', '0000-00-00', '0000-00-00'),
(12550, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'langeeri', '2024-11-01', '2025-12-31', '0.10', '6', 0, 3600, 3200, 0, 0, 6800, 6800, 9098, 9166, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7722', '1', 'W-7762', '0000-00-00', '0000-00-00'),
(12551, 310, '36221', '591', '5912301V000', '1ND', 'WEEEWaste - Interreg Europe - Tobiáš', 'langeeri', '2024-11-01', '2025-12-31', '0.38', '6', 0, 13680, 12160, 0, 0, 25840, 25840, 34574, 34832, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7722', '2', 'W-7762', '0000-00-00', '0000-00-00'),
(12552, 304, '36221', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'langeeri', '2024-11-01', '2025-12-31', '0.22', '6', 0, 7920, 7040, 0, 0, 14960, 14960, 20016, 20166, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7722', '3', 'W-7762', '0000-00-00', '0000-00-00'),
(12553, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'langeeri', '2024-11-01', '2025-12-31', '0.30', '6', 0, 10800, 9600, 0, 0, 20400, 20400, 27295, 27499, 68000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7722', '4', 'W-7762', '0000-00-00', '0000-00-00'),
(12603, 529, '36216', '113', '1132401N000', '1NP', 'PPRO MŠMT ČR - není - Klepačová', 'salkokat', '2024-11-01', '2038-12-30', '0.79', '6', 0, 19592, 19908, 0, 0, 39500, 39500, 52851, 53246, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7744', '1', 'W-7760', '0000-00-00', '0000-00-00'),
(12604, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR NPO Klepačová', 'salkokat', '2024-11-01', '2038-12-30', '0.01', '6', 0, 248, 252, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7744', '2', 'W-7760', '0000-00-00', '0000-00-00'),
(12605, 263, '36216', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kmonibar', '2024-11-01', '2025-12-31', '0.01', '7', 0, 276, 224, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '1', 'W-7771', '0000-00-00', '0000-00-00'),
(12606, 208, '36216', '604', '6042201V000', '1ND', 'H2020 - ARV', 'kmonibar', '2024-11-01', '2025-12-31', '0.01', '7', 0, 276, 224, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '2', 'W-7771', '0000-00-00', '0000-00-00'),
(12607, 467, '36216', '606', '6062304V002', '1ND', 'NBSINFRA HE-Sněhota - WP2', 'kmonibar', '2024-11-01', '2025-12-31', '0.01', '7', 0, 276, 224, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '3', 'W-7771', '0000-00-00', '0000-00-00'),
(12608, 272, '36216', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'kmonibar', '2024-11-01', '2025-12-31', '0.01', '7', 0, 276, 224, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '4', 'W-7771', '0000-00-00', '0000-00-00'),
(12609, 529, '36216', '113', '1132401N000', '1NP', 'PPRO MŠMT ČR - není - Klepačová', 'kmonibar', '2024-11-01', '2025-12-31', '0.85', '7', 0, 23460, 19040, 0, 0, 42500, 42500, 56865, 57290, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '5', 'W-7771', '0000-00-00', '0000-00-00'),
(12610, 522, '36216', '107', '1072401V400', '1ND', 'NPO GreenDeal MŠMT ČR NPO Klepačová', 'kmonibar', '2024-11-01', '2025-12-31', '0.01', '7', 0, 276, 224, 0, 0, 500, 500, 669, 674, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '6', 'W-7771', '0000-00-00', '0000-00-00'),
(12611, 449, '36216', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'kmonibar', '2024-11-01', '2025-12-31', '0.10', '7', 0, 2757, 2243, 0, 0, 5000, 5000, 6690, 6740, 50000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7742', '7', 'W-7771', '0000-00-00', '0000-00-00'),
(12668, 374, '36930', '554', '5542405V000', '1ND', 'ISS OP TAK Aplikace I', 'mlejnzuz', '2024-11-01', '2038-12-30', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'B4', 53900, 0, 1, 'W-7761', '1', 'W-7804', '0000-00-00', '0000-00-00'),
(12669, 230, '36930', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'mlejnzuz', '2024-11-01', '2038-12-30', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7761', '2', 'W-7804', '0000-00-00', '0000-00-00'),
(12670, 225, '36930', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'mlejnzuz', '2024-11-01', '2038-12-30', '0.16', '6', 0, 4320, 4000, 0, 0, 8320, 8320, 11132, 11215, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7761', '3', 'W-7804', '0000-00-00', '0000-00-00'),
(12671, 388, '36930', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'mlejnzuz', '2024-11-01', '2038-12-30', '0.09', '6', 0, 2430, 2250, 0, 0, 4680, 4680, 6262, 6309, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7761', '4', 'W-7804', '0000-00-00', '0000-00-00'),
(12672, 502, '36930', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'mlejnzuz', '2024-11-01', '2038-12-30', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7761', '5', 'W-7804', '0000-00-00', '0000-00-00'),
(12673, 423, '36930', '311', '3112401V000', '1ND', 'LIWEPLAS TAČR Sigma DC2 - Hataj', 'mlejnzuz', '2024-11-01', '2038-12-30', '0.15', '6', 0, 4050, 3750, 0, 0, 7800, 7800, 10436, 10514, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7761', '6', 'W-7804', '0000-00-00', '0000-00-00'),
(12746, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wolfp1', '2024-11-01', '2038-12-30', '0.60', '7', 0, 16590, 22410, 6000, 0, 45000, 39000, 60210, 60660, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7780', '1', 'W-7811', '0000-00-00', '0000-00-00'),
(12747, 311, '36254', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'wolfp1', '2024-11-01', '2038-12-30', '0.10', '7', 0, 2765, 3735, 1000, 0, 7500, 6500, 10035, 10110, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7780', '2', 'W-7811', '0000-00-00', '0000-00-00'),
(12748, 481, '36254', '311', '3112404V000', '1ND', 'AID-PV TAČR THÉTA 2 Martínek', 'wolfp1', '2024-11-01', '2038-12-30', '0.10', '7', 0, 2765, 3735, 1000, 0, 7500, 6500, 10035, 10110, 65000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7780', '3', 'W-7811', '0000-00-00', '0000-00-00'),
(12768, 522, '36216', '107', '1072401V400', '1NP', 'NPO GreenDeal MŠMT ČR NPO Klepačová', 'hodkojul', '2024-11-01', '2038-12-30', '0.59', '7', 0, 19470, 20355, 0, 0, 39825, 39825, 53286, 53684, 67500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7791', '1', 'W-7810', '0000-00-00', '0000-00-00'),
(12769, 225, '36216', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'hodkojul', '2024-11-01', '2038-12-30', '0.40', '7', 0, 13200, 13800, 0, 0, 27000, 27000, 36126, 36396, 67500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7791', '2', 'W-7810', '0000-00-00', '0000-00-00'),
(12770, 417, '36216', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'hodkojul', '2024-11-01', '2038-12-30', '0.01', '7', 0, 330, 345, 0, 0, 675, 675, 903, 910, 67500, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7791', '3', 'W-7810', '0000-00-00', '0000-00-00'),
(12817, 374, '36930', '554', '5542405V000', '1ND', 'ISS OP TAK Aplikace I', 'mlejnzuz', '2024-11-01', '2025-12-31', '0.24', '6', 0, 6480, 6000, 0, 0, 12480, 12480, 16698, 16823, 52000, '', 'ne', 'ne', 'B4', 53900, 0, 1, 'W-7804', '1', 'W-7809', '0000-00-00', '0000-00-00'),
(12818, 230, '36930', '311', '3112202V000', '1ND', 'TAČR THETA IV - BIOM_Nástřiky', 'mlejnzuz', '2024-11-01', '2025-12-31', '0.20', '6', 0, 5400, 5000, 0, 0, 10400, 10400, 13915, 14019, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7804', '2', 'W-7809', '0000-00-00', '0000-00-00'),
(12819, 225, '36930', '312', '3122202V000', '1ND', 'TAČR TREND IV -  PReRaSyD ecokit', 'mlejnzuz', '2024-11-01', '2025-12-31', '0.16', '6', 0, 4320, 4000, 0, 0, 8320, 8320, 11132, 11215, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7804', '3', 'W-7809', '0000-00-00', '0000-00-00'),
(12820, 388, '36930', '312', '3122302V000', '1ND', 'LUNA TAČR Trend Nováčci - Maierová', 'mlejnzuz', '2024-11-01', '2025-12-31', '0.09', '6', 0, 2430, 2250, 0, 0, 4680, 4680, 6262, 6309, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7804', '4', 'W-7809', '0000-00-00', '0000-00-00'),
(12821, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'mlejnzuz', '2024-11-01', '2025-12-31', '0.16', '6', 0, 4320, 4000, 0, 0, 8320, 8320, 11132, 11215, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7804', '5', 'W-7809', '0000-00-00', '0000-00-00'),
(12822, 423, '36930', '311', '3112401V000', '1ND', 'LIWEPLAS TAČR Sigma DC2 - Hataj', 'mlejnzuz', '2024-11-01', '2025-12-31', '0.15', '6', 0, 4050, 3750, 0, 0, 7800, 7800, 10436, 10514, 52000, '', 'ne', 'ne', 'neni', 0, 0, 1, 'W-7804', '6', 'W-7809', '0000-00-00', '0000-00-00'),
(12859, 243, '36254', '311', '3112201V000', '1ND', 'TAČR ENERDIGIT DORES', 'wolfp1', '2024-11-01', '2038-12-30', '0.60', '7', 0, 21210, 17790, 6000, 0, 45000, 39000, 60210, 60660, 65000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7811', '1', 'W-7812', '0000-00-00', '0000-00-00'),
(12860, 311, '36254', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'wolfp1', '2024-11-01', '2038-12-30', '0.10', '7', 0, 3535, 2965, 1000, 0, 7500, 6500, 10035, 10110, 65000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7811', '2', 'W-7812', '0000-00-00', '0000-00-00'),
(12861, 481, '36254', '311', '3112404V000', '1ND', 'AID-PV TAČR THÉTA 2 Martínek', 'wolfp1', '2024-11-01', '2038-12-30', '0.10', '7', 0, 3535, 2965, 1000, 0, 7500, 6500, 10035, 10110, 65000, '', 'ne', 'ne', 'neni', 0, 0, 0, 'W-7811', '3', 'W-7812', '0000-00-00', '0000-00-00');

-- --------------------------------------------------------

--
-- Table structure for table `zamestnanci_na_projektu_vraceno_zpet`
--

CREATE TABLE `zamestnanci_na_projektu_vraceno_zpet` (
  `id` int(11) NOT NULL,
  `id_projektu` int(11) NOT NULL COMMENT 'CK-id projektu z tabulky projektu datbaze obecne',
  `nakladove_stredisko` varchar(15) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `prefix_fis` varchar(15) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `fis_projektu` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `komplexni_polozka` varchar(15) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `nazev_projektu` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `login_zamestnance` varchar(63) COLLATE utf8_czech_ci NOT NULL,
  `na_projektu_od` date NOT NULL,
  `na_projektu_do` date NOT NULL COMMENT 'hodnota ''2049-12-30'' znamená ''na dobu neurčitou''',
  `uvazek_na_projektu` decimal(3,2) NOT NULL DEFAULT 0.00,
  `mzdova_trida` varchar(7) COLLATE utf8_czech_ci NOT NULL DEFAULT '0',
  `stupen` int(11) NOT NULL DEFAULT 0,
  `mzdovy_tarif` int(11) NOT NULL DEFAULT 0,
  `osobni_priplatek` int(11) NOT NULL DEFAULT 0,
  `projektovy_priplatek` int(11) NOT NULL DEFAULT 0,
  `priplatek` int(11) NOT NULL DEFAULT 0,
  `hruba_mzda` int(11) NOT NULL DEFAULT 0,
  `hruba_mzda_bez_priplatku` int(11) NOT NULL DEFAULT 0,
  `superhruba_mzda` int(11) NOT NULL DEFAULT 0,
  `superhruba_a_soc_fond` int(11) NOT NULL DEFAULT 0,
  `hruba_mzda_FTE` int(11) NOT NULL DEFAULT 0,
  `funkce` varchar(127) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `kmenova_zakazka` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'pouze hodnoty "ano", "ne" nebo nevyplněno',
  `priznak` varchar(7) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT ' 	pouze hodnoty "ano", "ne" nebo nevyplněno ',
  `mzdovy_limit_kategorie` varchar(7) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'je-li pro danou osobu na daném projektu nastaven v app."Projektové řízení" mzdový limit obsahuje jeho kategorii (tj.B1-B15)',
  `mzdovy_limit_castka` int(11) DEFAULT NULL COMMENT 'je-li pro danou osobu na daném projektu nastaven v app."Projektové řízení" mzdový limit obsahuje jeho finanční výši v Kč',
  `preuctovani` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1=přezdrojování ve workflow zaškrtnuto',
  `stav` int(11) NOT NULL DEFAULT 0 COMMENT '0=pending; 1=potvrzeno; 2=smazáno',
  `idAplikace` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'Obsahuje identifikátor aplikace, která záznam naposledy upravila (W=workflow, číslo dále index z tabulky "workflow-ukoly"',
  `idAplikace2` varchar(31) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'Dodatečné info k aplikaci, která provedla tento záznam. Workflow zde zapisuje cislo radku v seznamu projektu uvedených v daném úkolu jeho id je uvedeno ve sloupci idAplikace',
  `idAplikaceKteraZpusobilaZmenu` varchar(63) COLLATE utf8_czech_ci NOT NULL DEFAULT '' COMMENT 'Pokud nějaký nový záznam způsobí, že se musí měnit hodnotzy u některého staršího záznamu, je u tohoto satršího záznamu uvedeno idAplikace, která tuto změnu způsobila. Současně je do polí puvodniDatumOd a Do přepsána hodnota z polí DatumOd a Do, ab bylo možno tuto hodnotu popřípadě vrátit.',
  `puvodni_na_projektu_od` date DEFAULT NULL COMMENT 'pokud došlo ke změně nasazení  dané osoby na tento projekt(např novým úkolem Workflow) obsahuje původní hodnotu  pole na_projektu_od',
  `puvodni_na_projektu_do` date DEFAULT NULL COMMENT 'pokud došlo ke změně nasazení  dané osoby na tento projekt(např novým úkolem Workflow) obsahuje původní hodnotu  pole na_projektu_do'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `zamestnanci_na_projektu_vraceno_zpet`
--

INSERT INTO `zamestnanci_na_projektu_vraceno_zpet` (`id`, `id_projektu`, `nakladove_stredisko`, `prefix_fis`, `fis_projektu`, `komplexni_polozka`, `nazev_projektu`, `login_zamestnance`, `na_projektu_od`, `na_projektu_do`, `uvazek_na_projektu`, `mzdova_trida`, `stupen`, `mzdovy_tarif`, `osobni_priplatek`, `projektovy_priplatek`, `priplatek`, `hruba_mzda`, `hruba_mzda_bez_priplatku`, `superhruba_mzda`, `superhruba_a_soc_fond`, `hruba_mzda_FTE`, `funkce`, `kmenova_zakazka`, `priznak`, `mzdovy_limit_kategorie`, `mzdovy_limit_castka`, `preuctovani`, `stav`, `idAplikace`, `idAplikace2`, `idAplikaceKteraZpusobilaZmenu`, `puvodni_na_projektu_od`, `puvodni_na_projektu_do`) VALUES
(1241, 24, '36232', '251', '2511701V000', '1ND', 'AZV Kýla - Sabo - s veterinou Brno', 'blahnver', '2020-06-01', '2020-12-31', '0.20', '10', 1, 4264, 738, 0, 0, 5002, 5002, 6693, 6743, 25010, '', 'ano', '', '', NULL, 0, 0, 'W-3178', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1258, 66, '36221', '592', '5921901V000', '1ND', 'Interreg LC-districts', 'novotji8', '2020-10-01', '2020-12-31', '0.10', '10', 2, 2204, 1796, 0, 0, 4000, 4000, 5352, 5392, 40000, '', 'ne', '', '', NULL, 0, 0, 'W-3187', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1259, 56, '36221', '313', '3131901V007', '1ND', 'NCK - RESOPT', 'novotji8', '2020-10-01', '2020-12-31', '0.10', '10', 2, 2204, 1796, 0, 0, 4000, 4000, 5352, 5392, 40000, '', 'ne', '', '', NULL, 0, 0, 'W-3187', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1260, 54, '36221', '311', '3111908V000', '1ND', 'TA ČR ZETA II - MAGDA', 'novotji8', '2020-10-01', '2020-12-31', '0.75', '10', 2, 16530, 13470, 0, 0, 30000, 30000, 40140, 40440, 40000, '', 'ne', '', '', NULL, 0, 0, 'W-3187', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1261, 34, '36221', '131', '1311601V000', '1ND', 'NPU', 'novotji8', '2020-10-01', '2020-12-31', '0.05', '10', 2, 1102, 898, 0, 0, 2000, 2000, 2676, 2696, 40000, '', 'ano', '', '', NULL, 0, 0, 'W-3187', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1500, 50, '36211', '311', '3111904V000', '1ND', 'TA ČR ZETA II - Karbeton II', 'jirkazuz', '2021-01-01', '2038-12-30', '0.40', '10', 1, 8528, 4312, 0, 0, 12840, 12840, 17180, 17308, 32100, '', 'ne', '', '', NULL, 0, 0, 'W-3319', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1501, 129, '36211', '312', '3122003V000', '1ND', 'TREND II - FullSpectraSun (Spectrasol)', 'jirkazuz', '2021-01-01', '2038-12-30', '0.15', '10', 1, 3198, 1617, 0, 0, 4815, 4815, 6442, 6491, 32100, '', 'ne', '', '', NULL, 0, 0, 'W-3319', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1545, 39, '36211', '312', '3121701V000', '1ND', 'TA ČR EESDOK', 'pestaja2', '2020-11-01', '2021-12-31', '0.45', '10', 1, 9594, 5706, 0, 0, 15300, 15300, 20471, 20624, 34000, '', 'ne', '', '', NULL, 0, 0, 'W-3333', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1546, 81, '36211', '165', '1652001V000', '1ND', 'INTER ACTION INDIE', 'pestaja2', '2020-11-01', '2021-12-31', '0.10', '10', 1, 2132, 1268, 0, 0, 3400, 3400, 4549, 4583, 34000, '', 'ne', '', '', NULL, 0, 0, 'W-3333', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1547, 57, '36211', '313', '3131901V009', '1ND', 'NCK - BIMIP', 'pestaja2', '2020-11-01', '2021-12-31', '0.05', '10', 1, 1066, 634, 0, 0, 1700, 1700, 2275, 2292, 34000, '', 'ne', '', '', NULL, 0, 0, 'W-3333', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1548, 47, '36211', '165', '1651901V000', '1ND', 'INTER TRANSFER Annex 72 - životní cyklus budov', 'pestaja2', '2020-11-01', '2021-12-31', '0.05', '10', 1, 1066, 634, 0, 0, 1700, 1700, 2275, 2292, 34000, '', 'ne', '', '', NULL, 0, 0, 'W-3333', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1549, 49, '36211', '311', '3111903V000', '1ND', 'TA ČR ZETA II - EnviBIM', 'pestaja2', '2020-11-01', '2021-12-31', '0.10', '10', 1, 2132, 1268, 0, 0, 3400, 3400, 4549, 4583, 34000, '', 'ne', '', '', NULL, 0, 0, 'W-3333', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1824, 41, '36930', '533', '5331601C000', '1ND', 'OP VVV - CAP', 'zamprlib', '2021-01-01', '2038-12-30', '0.10', '8', 5, 1982, 2368, 0, 0, 4350, 4350, 5820, 5864, 43500, '', 'ne', '', '', NULL, 0, 0, 'W-3452', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(1825, 34, '36930', '131', '1311601V000', '1ND', 'NPU', 'zamprlib', '2021-01-01', '2038-12-30', '0.90', '8', 5, 17838, 21312, 0, 0, 39150, 39150, 52383, 52774, 43500, '', 'ne', '', '', NULL, 0, 0, 'W-3452', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2081, 33, '36255', '311', '3111901V000', '1ND', 'TA ČR ETA - Veřejná výstavba KVAS', 'liskam10', '2021-01-01', '2021-12-31', '0.60', '9', 1, 11238, 9162, 0, 0, 20400, 20400, 27295, 27499, 34000, '', 'ne', '', '', NULL, 0, 0, 'W-3556', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2373, 17, '', '312', '3121802V000', '1ND', 'TA ČR THETA - Hydronics', 'vanekj15', '2021-02-01', '2038-12-30', '0.00', '5', 5, 0, 0, 0, 0, 0, 0, 0, 0, 20000, '', 'ne', '', '', NULL, 0, 0, 'W-3628', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2383, 41, '36254', '533', '5331601C000', '1ND', 'OP VVV - CAP', 'wolfp1', '2021-02-01', '2038-12-30', '0.50', '11', 4, 12850, 23150, 0, 0, 36000, 36000, 48168, 48528, 58000, '', 'ne', '', '', NULL, 0, 0, 'W-3633', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2384, 53, '36254', '311', '3111907V000', '1ND', 'TA ČR ZETA II - Řízení SAS (AERS 2)', 'wolfp1', '2021-02-01', '2038-12-30', '0.35', '11', 4, 8995, 13055, 1750, 0, 22050, 20300, 29503, 29723, 58000, '', 'ne', '', '', NULL, 0, 0, 'W-3633', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2385, 69, '36254', '311', '3111902B001', '1ND', 'TAČR THÉTA II Energetická odezva budov - ELPRAMO', 'wolfp1', '2021-02-01', '2038-12-30', '0.05', '11', 4, 1285, 1865, 250, 0, 3150, 2900, 4215, 4246, 58000, '', 'ne', '', '', NULL, 0, 0, 'W-3633', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2386, 56, '36254', '313', '3131901V007', '1ND', 'NCK - RESOPT', 'wolfp1', '2021-02-01', '2038-12-30', '0.10', '11', 4, 2570, 3730, 500, 0, 6300, 5800, 8429, 8492, 58000, '', 'ne', '', '', NULL, 0, 0, 'W-3633', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2447, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'dytrijak', '2021-03-01', '2038-12-30', '0.80', '12', 5, 24400, 48184, 0, 10000, 82584, 72584, 110497, 111323, 90730, '', 'ne', '', '', NULL, 0, 0, 'W-3692', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(2448, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'dytrijak', '2021-03-01', '2038-12-30', '0.20', '12', 5, 6100, 14506, 2460, 0, 20606, 18146, 27571, 27777, 90730, '', 'ne', '', '', NULL, 0, 0, 'W-3692', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(3199, 175, '36930', '888', '8889701V930', '9NN', 'Režie - finanční oddělení', 'akcacagl', '2021-05-01', '2021-05-02', '0.60', '3', 0, 18000, 0, 0, 0, 18000, 18000, 24084, 24264, 30000, '', 'ne', '', '', NULL, 0, 0, 'W-4009', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(3605, 197, '', '552', '5522110V000', '1ND', 'OP PIK Multi-Heat', 'sourebor', '2021-07-01', '2038-12-30', '0.20', '7', 0, 5530, 6870, 0, 0, 12400, 12400, 16591, 16715, 62000, '', 'ne', '', '', NULL, 0, 0, 'W-4205', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(3606, 178, '', '552', '5522104V000', '1ND', 'OP PIK EMET', 'sourebor', '2021-07-01', '2038-12-30', '0.70', '7', 0, 19355, 24045, 0, 0, 43400, 43400, 58069, 58503, 62000, '', 'ano', '', '', NULL, 0, 0, 'W-4205', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(3607, 187, '', '552', '5522107V000', '1ND', 'OP PIK DH4.ENERGY / Feramat', 'sourebor', '2021-07-01', '2038-12-30', '0.10', '7', 0, 2765, 3435, 0, 0, 6200, 6200, 8296, 8358, 62000, '', 'ne', '', '', NULL, 0, 0, 'W-4205', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(3626, 74, '36216', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'hodkojul', '2021-08-01', '2021-12-31', '0.50', '7', 0, 13825, 7175, 0, 0, 21000, 21000, 28098, 28308, 42000, '', 'ano', '', '', NULL, 0, 0, 'W-4215', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(3627, 47, '36216', '165', '1651901V000', '1ND', 'INTER TRANSFER Annex 72 - životní cyklus budov', 'hodkojul', '2021-08-01', '2021-12-31', '0.10', '7', 0, 2765, 1435, 0, 0, 4200, 4200, 5620, 5662, 42000, '', 'ne', '', '', NULL, 0, 0, 'W-4215', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4103, 75, '36255', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'stanknic', '2021-10-01', '2021-12-31', '0.20', '6', 0, 4962, 2638, 0, 0, 7600, 7600, 10169, 10245, 38000, '', 'ne', '', '', NULL, 0, 0, 'W-4420', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4104, 167, '36255', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stanknic', '2021-10-01', '2021-12-31', '0.05', '6', 0, 1241, 660, 0, 0, 1900, 1900, 2542, 2561, 38000, '', 'ne', '', '', NULL, 0, 0, 'W-4420', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4105, 70, '36255', '313', '3131901V012', '1ND', 'NCK - CONAI', 'stanknic', '2021-10-01', '2021-12-31', '0.20', '6', 0, 4962, 2638, 0, 0, 7600, 7600, 10169, 10245, 38000, '', 'ne', '', '', NULL, 0, 0, 'W-4420', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4189, 258, '36256', '552', '5522117V000', '1ND', 'OP PIK TEAS_Servis FIT', 'XXXtmpXXXsurynpav', '2021-10-01', '2023-05-31', '0.20', 'A4', 0, 9000, 8800, 0, 0, 17800, 17800, 23816, 23994, 89000, '', 'ne', '', '', NULL, 0, 0, 'W-4453', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4190, 257, '36256', '552', '5522120V000', '1ND', 'OP PIK TEAS_DMS FIT', 'XXXtmpXXXsurynpav', '2021-10-01', '2023-05-31', '0.20', 'A4', 0, 9000, 8800, 0, 0, 17800, 17800, 23816, 23994, 89000, '', 'ne', '', '', NULL, 0, 0, 'W-4453', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4423, 86, '36870', '888', '8888100V000', '9NN', 'Režie - správa budovy', 'karhasan', '2022-01-01', '2038-12-30', '1.00', '1', 0, 17300, 2800, 0, 0, 20100, 20100, 26894, 27095, 20100, '', 'ano', '', '', NULL, 0, 0, 'W-4586', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4502, 65, '36930', '311', '3111913V000', '1ND', 'TAČR THÉTA II Rošt', 'pospika4', '2022-01-01', '2038-12-30', '0.12', '6', 0, 2978, 2050, 0, 0, 5028, 5028, 6727, 6778, 41900, '', 'ne', '', '', NULL, 0, 0, 'W-4631', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4503, 62, '36930', '202', '2021901V000', '1ND', 'TRIO Zlín', 'pospika4', '2022-01-01', '2038-12-30', '0.08', '6', 0, 1985, 1367, 0, 0, 3352, 3352, 4485, 4518, 41900, '', 'ne', '', '', NULL, 0, 0, 'W-4631', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4504, 93, '36930', '552', '5522002V000', '1ND', 'OP PIK Kotel GTP', 'pospika4', '2022-01-01', '2038-12-30', '0.24', '6', 0, 5955, 4101, 0, 0, 10056, 10056, 13455, 13555, 41900, '', 'ne', '', '', NULL, 0, 0, 'W-4631', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4505, 180, '36930', '552', '5522105V000', '1ND', 'OP PIK LASSO', 'pospika4', '2022-01-01', '2038-12-30', '0.13', '6', 0, 3226, 2221, 0, 0, 5447, 5447, 7288, 7343, 41900, '', 'ne', '', '', NULL, 0, 0, 'W-4631', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(4506, 91, '36930', '888', '8889701V000', '9NN', 'Režie - ostatní', 'pospika4', '2022-01-01', '2038-12-30', '0.43', '6', 0, 10670, 7347, 0, 0, 18017, 18017, 24107, 24287, 41900, '', 'ano', '', '', NULL, 0, 0, 'W-4631', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5147, 194, '36233', '552', '5522101V000', '1ND', 'OP PIK VIVA', 'janovvit', '2022-03-01', '2038-12-30', '0.60', '6', 0, 22770, 5130, 0, 0, 27900, 27900, 37330, 37609, 46500, '', 'ano', '', '', NULL, 0, 0, 'W-4864', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5148, 252, '36253', '552', '5522123V000', '1ND', 'OP PIK IX Softlink II', 'janovvit', '2022-03-01', '2038-12-30', '0.05', '6', 0, 2040, 460, 0, 0, 2500, 2500, 3345, 3370, 46500, '', 'ne', '', '', NULL, 0, 0, 'W-4864', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5149, 218, '36253', '552', '5522115V000', '1ND', 'OP PIK SANS SOUCI', 'janovvit', '2022-03-01', '2038-12-30', '0.05', '6', 0, 2040, 460, 0, 0, 2500, 2500, 3345, 3370, 46500, '', 'ne', '', '', NULL, 0, 0, 'W-4864', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5150, 150, '36233', '312', '3122102V000', '1ND', 'TAČR TREND III - Timber Guard - Inosens', 'janovvit', '2022-03-01', '2038-12-30', '0.30', '6', 0, 12242, 2758, 0, 0, 15000, 15000, 20070, 20220, 46500, '', 'ne', '', '', NULL, 0, 0, 'W-4864', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5333, 280, '36256', '552', '5522205V000', '1ND', 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 'XXXtmpXXXXXXlatkamatXXX', '2022-03-01', '2022-05-31', '0.30', '5', 0, 7005, 1995, 0, 0, 9000, 9000, 12042, 12132, 30000, '', 'ne', '', '', NULL, 0, 0, 'W-4934', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5334, 280, '36256', '552', '5522205V000', '1ND', 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 'XXXtmpXXXvalenad1', '2022-03-01', '2023-05-31', '0.50', '6', 0, 20000, 19000, 0, 0, 39000, 39000, 52182, 52572, 78000, '', 'ne', '', '', NULL, 0, 0, 'W-4933', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5339, 280, '36256', '552', '5522205V000', '1ND', 'OP PIK IX CEBIA DIGITALIZACE VIN FIT', 'XXXtmpXXXXXXmalecadaXXX', '2022-03-01', '2023-05-31', '0.20', '5', 0, 4670, 1630, 0, 0, 6300, 6300, 8429, 8492, 31500, '', 'ne', '', '', NULL, 0, 0, 'W-4935', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5348, 271, '36256', '552', '5522204V000', '1ND', 'OP PIK IX CEBIA AUTOTRACER FIT', 'XXXtmpXXX', '2022-03-01', '2023-05-31', '0.20', '6', 0, 4962, 6038, 0, 0, 11000, 11000, 14718, 14828, 55000, '', 'ne', '', '', NULL, 0, 0, 'W-4940', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5453, 19, '36255', '312', '3121804V000', '1ND', 'TAČR THETA NextGenDistrict', 'stanknic', '2022-04-01', '2022-12-31', '0.40', '6', 0, 9925, 6475, 0, 0, 16400, 16400, 21943, 22107, 41000, '', 'ne', '', '', NULL, 0, 0, 'W-4976', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5454, 167, '36255', '312', '3122104V000', '1ND', 'TAČR ETA V - Obce mluví o vodě', 'stanknic', '2022-04-01', '2022-12-31', '0.05', '6', 0, 1241, 809, 0, 0, 2050, 2050, 2743, 2763, 41000, '', 'ne', '', '', NULL, 0, 0, 'W-4976', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5455, 88, '36255', '311', '3112001V000', '1ND', 'TAČR ZETA IV - WH-CarBatt', 'stanknic', '2022-04-01', '2022-12-31', '0.15', '6', 0, 3722, 2429, 0, 0, 6150, 6150, 8229, 8290, 41000, '', 'ne', '', '', NULL, 0, 0, 'W-4976', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5456, 157, '36255', '661', '6612001V000', '1ND', 'EUKI - Energy Efficiency Network', 'stanknic', '2022-04-01', '2022-12-31', '0.20', '6', 0, 4962, 3238, 0, 0, 8200, 8200, 10972, 11054, 41000, '', 'ne', '', '', NULL, 0, 0, 'W-4976', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(5874, 213, '36253', '552', '5522118V000', '1ND', 'OP PIK StructureGuard', 'sedlaj53', '2022-07-01', '2023-05-31', '1.00', '7', 0, 32300, 36700, 0, 0, 69000, 69000, 92322, 93012, 69000, '', 'ne', '', '', NULL, 0, 0, 'W-5146', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6130, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'matustom', '2022-07-01', '2038-12-30', '0.05', 'A4', 0, 1750, 1850, 0, 625, 4225, 3600, 5653, 5695, 72000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5235', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6131, 183, '36221', '552', '5522112V000', '1ND', 'OP PIK FASHEX / Dekmetal', 'matustom', '2022-07-01', '2038-12-30', '0.10', 'A4', 0, 3500, 3700, 0, 1250, 8450, 7200, 11306, 11391, 72000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5235', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6132, 197, '36221', '552', '5522110V000', '1ND', 'OP PIK Multi-Heat / TECHTRANS', 'matustom', '2022-07-01', '2038-12-30', '0.05', 'A4', 0, 1750, 1850, 0, 635, 4235, 3600, 5666, 5709, 72000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5235', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6133, 187, '36221', '552', '5522107V000', '1ND', 'OP PIK DH4.ENERGY / Feramat', 'matustom', '2022-07-01', '2038-12-30', '0.10', 'A4', 0, 3500, 3700, 0, 1250, 8450, 7200, 11306, 11391, 72000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5235', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6134, 233, '36221', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'matustom', '2022-07-01', '2038-12-30', '0.10', 'A4', 0, 3500, 3700, 0, 1250, 8450, 7200, 11306, 11391, 72000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5235', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6326, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'XXXtmpXXXnun', '2022-09-01', '2022-12-31', '1.00', '6', 0, 31000, 29000, 0, 0, 60000, 60000, 80280, 80880, 60000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5305', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(6631, 194, '36233', '552', '5522101V000', '1ND', 'OP PIK VIVA', 'svoboto9', '2022-10-01', '2023-05-31', '1.00', '6', 0, 30000, 25000, 0, 0, 55000, 55000, 73590, 74140, 55000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5415', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(7781, 268, '36261', '312', '3122204V000', '1ND', 'MetaMorph - TAČR KAPPA - InoCure', 'rulcjiri', '2023-02-01', '2038-12-30', '0.57', '7', 0, 20448, 19452, 0, 0, 39900, 39900, 53386, 53785, 70000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-5982', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8472, 194, '36233', '552', '5522101V000', '1ND', 'OP PIK VIVA', 'janovvit', '2023-06-01', '2038-12-30', '0.60', '6', 0, 22770, 8430, 0, 0, 31200, 31200, 41746, 42058, 52000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6354', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8473, 112, '36253', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'janovvit', '2023-06-01', '2038-12-30', '0.40', '6', 0, 15180, 5620, 0, 0, 20800, 20800, 27830, 28038, 52000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6354', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8658, 75, '36960', '604', '6041901V000', '1ND', 'H2020 - SPARCS', 'kuzmimic', '2023-06-01', '2038-12-30', '0.45', '6', 0, 15645, 15135, 0, 0, 30780, 30780, 41184, 41491, 68400, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6394', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8659, 303, '36960', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'kuzmimic', '2023-06-01', '2038-12-30', '0.25', '6', 0, 8692, 6208, 0, 0, 14900, 14900, 19936, 20085, 59600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6394', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8660, 242, '36960', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'kuzmimic', '2023-06-01', '2038-12-30', '0.10', '6', 0, 3477, 3363, 0, 0, 6840, 6840, 9152, 9220, 68400, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6394', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8661, 263, '36960', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'kuzmimic', '2023-06-01', '2038-12-30', '0.10', '6', 0, 3477, 3363, 0, 0, 6840, 6840, 9152, 9220, 68400, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6394', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(8662, 272, '36960', '606', '6062201V000', '1ND', 'NEB-STAR HE - Kuzmič', 'kuzmimic', '2023-06-01', '2038-12-30', '0.10', '6', 0, 3477, 3363, 0, 0, 6840, 6840, 9152, 9220, 68400, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6394', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10239, 208, '36212', '604', '6042201V000', '1ND', 'H2020 - ARV', 'malikzd1', '2024-01-01', '2038-12-30', '0.20', 'A3', 0, 6200, 3920, 0, 0, 10120, 10120, 13541, 13642, 50600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6954', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10240, 74, '36212', '604', '6041902V000', '1ND', 'H2020 - POWERSKIN PLUS', 'malikzd1', '2024-01-01', '2038-12-30', '0.01', 'A3', 0, 310, 196, 0, 0, 506, 506, 677, 682, 50600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6954', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10241, 199, '36212', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'malikzd1', '2024-01-01', '2038-12-30', '0.19', 'A3', 0, 5890, 3724, 0, 0, 9614, 9614, 12864, 12960, 50600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-6954', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10758, 112, '36231', '604', '6042001V000', '1ND', 'H2020 - PLURAL', 'vitouja1', '2024-04-01', '2038-12-30', '0.05', '6', 0, 1240, 810, 0, 0, 2050, 2050, 2743, 2763, 41000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7165', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(10759, 369, '36231', '554', '5542402V000', '1ND', 'AHU-OPT OP TAK Aplikace I', 'vitouja1', '2024-04-01', '2038-12-30', '0.45', '6', 0, 11160, 7290, 0, 0, 18450, 18450, 24686, 24871, 41000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7165', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(11432, 385, '36213', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'piteldan', '2024-09-01', '2038-12-30', '0.25', '6', 0, 6202, 4198, 0, 0, 10400, 10400, 13915, 14019, 41600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7379', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(11433, 199, '36213', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'piteldan', '2024-09-01', '2038-12-30', '0.25', '6', 0, 6202, 4198, 0, 0, 10400, 10400, 13915, 14019, 41600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7379', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(11808, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'XXXtmpXXXverlosko', '2024-11-01', '2025-12-31', '1.00', '6', 0, 24810, 13190, 0, 0, 38000, 38000, 50844, 51224, 38000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7509', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(11877, 374, '36233', '554', '5542405V000', '1ND', 'ISS OP TAK Aplikace I', 'janovvit', '2024-10-01', '2038-12-30', '0.40', '6', 0, 15180, 7620, 0, 0, 22800, 22800, 30506, 30734, 57000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7521', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(11878, 368, '36253', '554', '5542403V000', '1ND', 'Jeremiáš MPO ČR OP TAK Janovský', 'janovvit', '2024-10-01', '2038-12-30', '0.60', '6', 0, 22770, 11430, 0, 0, 34200, 34200, 45760, 46102, 57000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7521', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12222, 369, '36233', '554', '5542402V000', '1ND', 'AHU-OPT OP TAK Aplikace I', 'janovvit', '2024-10-01', '2038-12-30', '0.40', '6', 0, 15180, 7620, 0, 0, 22800, 22800, 30506, 30734, 57000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7625', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12223, 444, '36253', '398', '3122401V000', '1ND', 'HighRiseTimber TAČR Trend X - Wawerka', 'janovvit', '2024-10-01', '2038-12-30', '0.10', '6', 0, 3795, 1905, 0, 0, 5700, 5700, 7627, 7684, 57000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7625', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12224, 368, '36253', '554', '5542403V000', '1ND', 'Jeremiáš MPO ČR OP TAK Janovský', 'janovvit', '2024-10-01', '2038-12-30', '0.50', '6', 0, 18975, 9525, 0, 0, 28500, 28500, 38133, 38418, 57000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7625', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12287, 267, '36255', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'neslamic', '2024-10-01', '2024-12-31', '0.80', '6', 0, 19856, 16144, 0, 0, 36000, 36000, 48168, 48528, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7622', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12288, 242, '36255', '311', '3112202B001', '1ND', 'TAČR THETA IV - Power2Heat', 'neslamic', '2024-10-01', '2024-12-31', '0.01', '6', 0, 248, 202, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7622', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12289, 303, '36255', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'neslamic', '2024-10-01', '2024-12-31', '0.01', '6', 0, 248, 202, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7622', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12290, 304, '36255', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'neslamic', '2024-10-01', '2024-12-31', '0.01', '6', 0, 248, 202, 0, 0, 450, 450, 602, 607, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7622', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12291, 270, '36255', '311', '3112207V000', '1ND', 'TAČR BETA - Energetické komunity - Vácha', 'neslamic', '2024-10-01', '2024-12-31', '0.17', '6', 0, 4219, 3431, 0, 0, 7650, 7650, 10236, 10312, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7622', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12332, 201, '36261', '894', '8941501V906', '1NE', 'Mzdový Fond RP6', 'divinrad', '2024-11-01', '2038-12-30', '0.28', '6', 0, 11760, 9520, 0, 0, 21280, 21280, 28473, 28685, 76000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7647', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12333, 201, '36261', '894', '8941501V906', '1NE', 'Mzdový Fond RP6', 'novotp17', '2024-11-01', '2038-12-30', '1.00', '6', 0, 28590, 9430, 0, 0, 38020, 38020, 50871, 51251, 28020, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7648', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12351, 304, '36221', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'matustom', '2024-11-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2300, 0, 500, 5000, 4500, 6690, 6740, 90000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7654', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12352, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'matustom', '2024-11-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2300, 0, 500, 5000, 4500, 6690, 6740, 90000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7654', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12353, 233, '36221', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'matustom', '2024-11-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2300, 0, 500, 5000, 4500, 6690, 6740, 90000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7654', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12354, 367, '36221', '554', '5542411V000', '1ND', 'Vodík MPO ČR OP TAK Matuška', 'matustom', '2024-11-01', '2038-12-30', '0.30', 'A4', 0, 13200, 13800, 0, 3000, 30000, 27000, 40140, 40440, 90000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7654', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12355, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'matustom', '2024-11-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2300, 0, 500, 5000, 4500, 6690, 6740, 90000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7654', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12532, 417, '36218', '554', '5542404V000', '1ND', 'CITI CAN MPO ČR OP TAK Volf', 'trubinik', '2025-02-01', '2038-12-30', '0.40', '6', 0, 9924, 6756, 0, 0, 16680, 16680, 22318, 22485, 41700, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7709', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12589, 302, '36211', '606', '6062303V000', '1ND', 'CIRC-BOOST HE - Pavlů', 'solosvia', '2025-01-01', '2038-12-30', '0.10', '6', 0, 2482, 978, 0, 0, 3460, 3460, 4629, 4664, 34600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7746', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12590, 430, '36211', '301', '3012401V000', '1ND', 'CAC GAČR - Hájek', 'solosvia', '2025-01-01', '2038-12-30', '0.90', '6', 0, 22338, 8802, 0, 0, 31140, 31140, 41665, 41977, 34600, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7746', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12593, 199, '36216', '894', '8941501V901', '1NE', 'Mzdový Fond RP1', 'tencajir', '2024-12-01', '2025-12-31', '0.05', '7', 0, 1750, 1350, 0, 0, 3100, 3100, 4148, 4179, 62000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7748', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12623, 250, '36920', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'rutovmar', '2024-11-01', '2025-12-31', '0.15', '6', 0, 3722, 2953, 0, 0, 6675, 6675, 8931, 8998, 44500, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7755', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12624, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'rutovmar', '2024-11-01', '2025-12-31', '0.22', '6', 0, 5459, 4331, 0, 0, 9790, 9790, 13099, 13197, 44500, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7755', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12625, 496, '36920', '311', '3112402V000', '1ND', 'Dukovany TaČR Beta Bittnar', 'rutovmar', '2024-11-01', '2025-12-31', '0.35', '6', 0, 8684, 6891, 0, 0, 15575, 15575, 20839, 20995, 44500, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7755', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12626, 267, '36920', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'rutovmar', '2024-11-01', '2025-12-31', '0.14', '6', 0, 3474, 2756, 0, 0, 6230, 6230, 8336, 8398, 44500, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7755', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12627, 479, '36920', '591', '5912401V000', '1ND', 'Repower Industries Interreg Europe - Tobiáš', 'rutovmar', '2024-11-01', '2025-12-31', '0.14', '6', 0, 3474, 2756, 0, 0, 6230, 6230, 8336, 8398, 44500, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7755', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12628, 300, '36920', '591', '5912302V000', '1ND', 'Circular WEEP Interreg CE - Tobiáš', 'stoladan', '2024-11-01', '2038-12-30', '0.06', '6', 0, 1800, 1560, 0, 0, 3360, 3360, 4496, 4529, 56000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7756', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12629, 233, '36920', '311', '3112204V000', '1ND', 'TAČR THETA IV - FlexiCoMix Regulus', 'stoladan', '2024-11-01', '2038-12-30', '0.20', '6', 0, 6000, 5200, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7756', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12630, 385, '36920', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'stoladan', '2024-11-01', '2038-12-30', '0.20', '6', 0, 6000, 5200, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7756', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12631, 387, '36920', '165', '1652301V000', '1ND', 'TISMIC MŠMT - Lupíšek', 'stoladan', '2024-11-01', '2038-12-30', '0.20', '6', 0, 6000, 5200, 0, 0, 11200, 11200, 14986, 15098, 56000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7756', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12632, 540, '36920', '107', '1072401V900', '1ND', 'NPO GreenDeal Admin MŠMT ČR NPO Klepačová', 'stoladan', '2024-11-01', '2038-12-30', '0.19', '6', 0, 5700, 4940, 0, 0, 10640, 10640, 14236, 14343, 56000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7756', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(12633, 250, '36920', '311', '3112205V000', '1ND', 'TAČR DOPRAVA - FICOS', 'stoladan', '2024-11-01', '2038-12-30', '0.15', '6', 0, 4500, 3900, 0, 0, 8400, 8400, 11239, 11323, 56000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-7756', '6', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13550, 385, '36253', '165', '1652302V000', '1ND', 'AMKEMT MŠMT - Hejtmánek', 'vcelakj1', '2025-02-01', '2038-12-30', '0.20', '7', 0, 11000, 9000, 2000, 0, 22000, 20000, 29436, 29656, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8037', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13551, 208, '36253', '604', '6042201V000', '1ND', 'H2020 - ARV', 'vcelakj1', '2025-02-01', '2038-12-30', '0.30', '7', 0, 16500, 13500, 3000, 0, 33000, 30000, 44154, 44484, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8037', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13552, 482, '36253', '311', '3112403V000', '1ND', 'FacilityAggregator TAČR THÉTA 2 Dostál', 'vcelakj1', '2025-02-01', '2038-12-30', '0.30', '7', 0, 16500, 13500, 3000, 0, 33000, 30000, 44154, 44484, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8037', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13553, 304, '36253', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'vcelakj1', '2025-02-01', '2038-12-30', '0.20', '7', 0, 11000, 9000, 2000, 0, 22000, 20000, 29436, 29656, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8037', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13648, 91, '36920', '888', '8889701V000', '9NN', 'Režie - ostatní', 'schwami5', '2025-02-01', '2025-12-31', '0.65', '6', 0, 16127, 13123, 0, 0, 29250, 29250, 39137, 39429, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8055', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13649, 449, '36920', '592', '5922401V000', '1ND', 'SuPeRBE Interreg Interreg CENTRAL EUROPE Felicioni', 'schwami5', '2025-02-01', '2025-12-31', '0.24', '6', 0, 5955, 4845, 0, 0, 10800, 10800, 14450, 14558, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8055', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13650, 504, '36920', '311', '3112501V000', '1ND', 'NOTATION TAČR SIGMA Janovský', 'schwami5', '2025-02-01', '2025-12-31', '0.11', '6', 0, 2729, 2221, 0, 0, 4950, 4950, 6623, 6673, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8055', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13750, 91, '36960', '888', '8889701V000', '9NN', 'Režie - ostatní', 'XXXtmpXXXmarval', '2025-03-01', '2025-12-31', '1.00', '6', 0, 35000, 25000, 0, 0, 60000, 60000, 80280, 80880, 60000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8093', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(13931, 580, '36216', '122', '1222100V001', '1ND', 'DKRVO RP1 MŠMT ČR DKRVO Jára', 'tencajir', '2025-03-01', '2038-12-30', '0.05', '7', 0, 1750, 1350, 0, 0, 3100, 3100, 4148, 4179, 62000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8166', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14086, 208, '36257', '604', '6042201V000', '1ND', 'H2020 - ARV', 'kichosof', '2025-04-01', '2038-12-30', '0.50', '7', 0, 13826, 12674, 5000, 0, 31500, 26500, 42147, 42462, 53000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8269', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14087, 484, '36257', '544', '5442401C060', '1ND', 'Eco&Stor OPJAK - FEL Procházka', 'kichosof', '2025-04-01', '2038-12-30', '0.50', '7', 0, 13825, 12675, 5000, 0, 31500, 26500, 42147, 42462, 53000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8269', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14088, 513, '36254', '311', '3112502V000', '1ND', 'OptiComm TAČR SIGMA Bäumelt', 'konjepat', '2025-04-01', '2025-12-31', '0.50', '6', 0, 12405, 10095, 0, 0, 22500, 22500, 30105, 30330, 45000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8270', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14089, 263, '36251', '606', '6062202V000', '1ND', 'CRAFT HE - Vácha', 'mackoja3', '2025-04-01', '2025-12-31', '0.45', '4', 0, 9675, 7425, 0, 0, 17100, 17100, 22880, 23051, 38000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8271', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14090, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'mackoja3', '2025-04-01', '2025-12-31', '0.05', '4', 0, 1075, 825, 0, 0, 1900, 1900, 2542, 2561, 38000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8271', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14091, 267, '36251', '301', '3012301V000', '1ND', 'Bytová družstva GAČR Polsko - Vácha', 'mackoja3', '2025-04-01', '2025-12-31', '0.10', '4', 0, 2150, 1650, 0, 0, 3800, 3800, 5084, 5122, 38000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8271', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14095, 208, '36257', '604', '6042201V000', '1ND', 'H2020 - ARV', 'martivl6', '2025-04-01', '2038-12-30', '0.05', '6', 0, 1259, 1241, 500, 0, 3000, 2500, 4014, 4044, 50000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8272', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14096, 303, '36257', '606', '6062301V000', '1ND', 'GLocalFlex HE - Zavřel', 'martivl6', '2025-04-01', '2038-12-30', '0.35', '6', 0, 8816, 8684, 3500, 0, 21000, 17500, 28098, 28308, 50000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8272', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14097, 481, '36257', '311', '3112404V000', '1ND', 'AID-PV TAČR THÉTA 2 Martínek', 'martivl6', '2025-04-01', '2038-12-30', '0.60', '6', 0, 15113, 14887, 6000, 0, 36000, 30000, 48168, 48528, 50000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8272', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14098, 208, '36251', '604', '6042201V000', '1ND', 'H2020 - ARV', 'wawerrob', '2025-04-01', '2038-12-30', '0.35', '7', 0, 19250, 15750, 1750, 1750, 38500, 35000, 51513, 51898, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8273', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14099, 444, '36251', '398', '3122401V000', '1ND', 'HighRiseTimber TAČR Trend X - Wawerka', 'wawerrob', '2025-04-01', '2038-12-30', '0.10', '7', 0, 5500, 4500, 500, 500, 11000, 10000, 14718, 14828, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8273', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14100, 373, '36251', '554', '5542408V000', '1ND', 'Senzory pro IAQ MPO ČR OP TAK Wawerka', 'wawerrob', '2025-04-01', '2038-12-30', '0.30', '7', 0, 16500, 13500, 1500, 1500, 33000, 30000, 44154, 44484, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8273', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14101, 491, '36251', '311', '3112406V000', '1ND', 'UPCHANGE TAČR Clean Energy Transition (CET) Wawerka', 'wawerrob', '2025-04-01', '2038-12-30', '0.25', '7', 0, 13750, 11250, 1250, 1250, 27500, 25000, 36795, 37070, 100000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8273', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14102, 311, '36254', '311', '3112301V000', '1ND', 'SAFEBATT- TAČR 4.VS - Dostál', 'wolfp1', '2025-04-01', '2038-12-30', '0.35', '7', 0, 12373, 10378, 3500, 0, 26250, 22750, 35123, 35385, 65000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8274', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14103, 481, '36254', '311', '3112404V000', '1ND', 'AID-PV TAČR THÉTA 2 Martínek', 'wolfp1', '2025-04-01', '2038-12-30', '0.25', '7', 0, 8838, 7413, 2500, 0, 18750, 16250, 25088, 25275, 65000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8274', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14442, 304, '36221', '606', '6062302V000', '1ND', 'ASCEND HE - Matuška', 'matustom', '2025-05-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8386', '1', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14443, 208, '36221', '604', '6042201V000', '1ND', 'H2020 - ARV', 'matustom', '2025-05-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8386', '2', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14444, 494, '36221', '311', '3112506V000', '1ND', 'RESPED TAČR Driving Urban Transition (DUT) Kuzmič', 'matustom', '2025-05-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8386', '3', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14445, 367, '36221', '554', '5542411V000', '1ND', 'Vodík MPO ČR OP TAK Matuška', 'matustom', '2025-05-01', '2038-12-30', '0.05', 'A4', 0, 2200, 2000, 0, 500, 4700, 4200, 6289, 6336, 84000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8386', '4', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14446, 502, '36221', '564', '5642401V000', '1ND', 'SYNERGYS MŽP - Matuška', 'matustom', '2025-05-01', '2038-12-30', '0.30', 'A4', 0, 13200, 12000, 0, 0, 25200, 25200, 33718, 33970, 84000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8386', '5', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00'),
(14447, 582, '36221', '122', '1222100V002', '1ND', 'DKRVO RP2 MŠMT ČR DKRVO Jára', 'matustom', '2025-05-01', '2038-12-30', '0.00', 'A4', 0, 0, 0, 0, 3000, 3000, 0, 4014, 4044, 84000, '', 'ne', 'ne', '', NULL, 0, 0, 'W-8386', '6', 'W-úkol vracen zpět tvůrci', '0000-00-00', '0000-00-00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dpp_dpc`
--
ALTER TABLE `dpp_dpc`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `egje_odpracovana_doba`
--
ALTER TABLE `egje_odpracovana_doba`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `financni_koeficienty`
--
ALTER TABLE `financni_koeficienty`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mzdove_tarify`
--
ALTER TABLE `mzdove_tarify`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mzdove_tarify-kesmazani`
--
ALTER TABLE `mzdove_tarify-kesmazani`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `odmeny`
--
ALTER TABLE `odmeny`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rekap`
--
ALTER TABLE `rekap`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`login`,`id_role`);

--
-- Indexes for table `zamestnanci_na_projektu`
--
ALTER TABLE `zamestnanci_na_projektu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `zamestnanci_na_projektu_log`
--
ALTER TABLE `zamestnanci_na_projektu_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `zamestnanci_na_projektu_smazane`
--
ALTER TABLE `zamestnanci_na_projektu_smazane`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `zamestnanci_na_projektu_vraceno_zpet`
--
ALTER TABLE `zamestnanci_na_projektu_vraceno_zpet`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dpp_dpc`
--
ALTER TABLE `dpp_dpc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16759;

--
-- AUTO_INCREMENT for table `egje_odpracovana_doba`
--
ALTER TABLE `egje_odpracovana_doba`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3347;

--
-- AUTO_INCREMENT for table `financni_koeficienty`
--
ALTER TABLE `financni_koeficienty`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mzdove_tarify`
--
ALTER TABLE `mzdove_tarify`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mzdove_tarify-kesmazani`
--
ALTER TABLE `mzdove_tarify-kesmazani`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `odmeny`
--
ALTER TABLE `odmeny`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1599;

--
-- AUTO_INCREMENT for table `rekap`
--
ALTER TABLE `rekap`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16977;

--
-- AUTO_INCREMENT for table `zamestnanci_na_projektu`
--
ALTER TABLE `zamestnanci_na_projektu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14465;

--
-- AUTO_INCREMENT for table `zamestnanci_na_projektu_log`
--
ALTER TABLE `zamestnanci_na_projektu_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `zamestnanci_na_projektu_smazane`
--
ALTER TABLE `zamestnanci_na_projektu_smazane`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12862;

--
-- AUTO_INCREMENT for table `zamestnanci_na_projektu_vraceno_zpet`
--
ALTER TABLE `zamestnanci_na_projektu_vraceno_zpet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14459;
COMMIT;

